Outline

Step 1: Client (CR)

If C: show C form

+ new job

SELECT job type: curb/gutter flat work paving Civil structural WHAT ARE THE TYPES of jobs?

Step 2: C job

Concrete Supplier form
Rebar Supplier Form
Stone Supplier Form
Whitecap Supplier Form

Questions: how should we display all of the options: (I think NLP) How can we fix the select box problem?
Send to all at one button click. - THEN COME BACK AND SELECT FINAL SUPPLIER IN JOB SECTION Right now, it seems like types of jobs and job components are mixed up on the spreadsheet....we need to separate so that types of jobs have job components

GLOBAL VARIABLES Company Name Overhead Labor Rate Tax Rate

Properties of every single job:

Crew? type of crew? quantity of type of crew? # of men? labor rate? tax? C Budget load relevant phase codes from job.. calculate by the appropriate phase code multiplier (ie. measurement manhours labor....) C Reference sheet Job Name Tax Labor rate Quantities of mix "quick add items"?

TYPE OF WORK QUANTITY UNIT PRODUCTION UNIT /MHR. MANHOURS. # CREW DAYS CREW SIZE UNIT LABOR LABOR COST UNIT COST MATERIAL COST MATERIAL TAX TOTAL MATERIAL EQPT RATE EQUIPMENTCOST EQUIPMENTTAX TOTAL EQUIPMENT SUB RATE TOTAL SUB COST OTHER/ SMALL TOOLS RATE OTHER/ SMALL TOOLS COST OTHER/ SMALL TOOLS TAX

Ramp Walls

WALLS TO 8' WALLS 8' TO 12' STRAIGHT WALLS 12’ & UP RADIUS WALLS BATTERED WALLS RAD BATT. WALLS SHAFT WALLS ONE SIDED WALLS TRENCH WALLS WALLS UNDER 2' SQUARE COLUMNS ROUND COLUMNS PILASTERS RECTANGLE COLUMNS 1/8” Luan SF PAN SLABS BEAM SIDES BEAM BOTTOMS DRILL and EPOXY Dovetail anchor LF WEEP PIPES CURE Patch SF RUB SF REBAR TON Wire Mesh W1.4 x W1.4 WATER STOP BEAM POCKETS DOOR BOX OUTS BOX OUTS BRICK LEDGE 3000 KSI 0.48 W/C ratio CONCRETE CY CONC PUMP HRS Conc Pump Mob Excavator Skidsteer LAYOUT MHRS MOBILIZE

Ramp Wall footing

EXCAVATION CY BACKFILL DISPOSE/HAUL TRUCKING CY TRUCKING HRS TRUCKING FUEL SURCHARGE DRILL & EPOXY ANCHOR BOLTS 6” PIPE BOLLARDS EDGE FORMING SF WATER STOP FTG STEPS REBAR TONS REBAR ACCESSORIES MUD SLAB CONCRETE. CY 3000 psi CONCRETE CY SUPER P. CY CONC PUMP HRS CONC PUMP TRIPS LIGHT TOWERS (EA/WEEK) Excavator (MO) Skidsteer (MO) Rammax (MO) Jumping Jack (MO) Flat Plate Tamp (MO) Lull (MO) ROLLER DOZER 5CY DUMP TRUCK (WK) LAYOUT MHRS MOBILIZE

Reinforcing

PHASE CODE DESCRIPTION LINE ITEM 6205 FOUNDATIONS REBAR TONS REBAR ACCESSORIES SUBTOTALS 6205 SOG LINE ITEM REBAR TONS REBAR ACCESSORIES SUBTOTALS 6205 TILT WALLS LINE ITEM REBAR TONS REBAR ACCESSORIES SUBTOTALS 6205 RAMP WALLS LINE ITEM REBAR TONS REBAR ACCESSORIES SUBTOTALS 6205 WALLS & COLUMNS LINE ITEM REBAR TONS REBAR ACCESSORIES SUBTOTALS 6205 DOCK PITS LINE ITEM REBAR TONS REBAR ACCESSORIES

Tilt Walls

6401 Panel Engineering PANEL ENGINEERING PLANS SUBTOTALS 6402 Form/Reveal/Embeds LINE ITEM 7.25” Edge Form 7.25” Common Form 7.5” Edge Form 7.5” Common Form 7.75” Edge Form 7.75” Common Form 8” Edge Form 8” Common Form 8.25” Edge Form 8.25” Common Form 8.5” Edge Form 8.5” Common Form 8.75” Edge Form 8.75” Common Form 9” Edge Form 9” Common Form 9.25” Edge Form 9.25” Common Form 9.5” Edge Form 9.5” Common Form 9.75” Edge Form 9.75” Common Form 10” Edge Form 10” Common Form 10.25” Edge Form 10.25” Common Form 10.5” Edge Form 10.5” Common Form 10.75” Edge Form 10.75” Common Form 11” Edge Form 11” Common Form 11.25” Edge Form 11.25” Common Form 11.5” Edge Form 11.5” Common Form 11.75” Edge Form 11.75” Common Form Total Edge Forms LF 12” Edge Form 0 12” Common Form FORM OPENINGS CHAMFER KNOCKOUTS REVEAL TYP A REVEAL TYP B REVEAL TYP C REVEAL TYP D GLUE PT NAILER HARDWARE (NAILER) SLAB SAVERS EMBEDS SAWCUT COVER FORMLINER SUBTOTALS 6403 Bondbreaker LINE ITEM BONDBREAKER SUBTOTALS 6404 LIfting & Bracing LINE ITEM LIFT INSERTS BRACE INSERTS BRACES SLAB BRACE BOLT COIL BOLT RING CLUTCH PANIC PLATE FREIGHT CHARGE INSERT CAPS DRILL BITS SUBTOTALS 6405 Panels Place/Finish LINE ITEM # of Panels 0 P&F PANELS WASTE 4% CONCRETE CURE PUMP TRIP LIGHT TOWERS (1 MONTH) SUBTOTALS 6406 Pre-Erection (Bumpers/Shims) LINE ITEM PRE-ERECTION SHIMS BUMPERS SUBTOTALS 6407 Panel Erection/Welding LINE ITEM CRANE & ERECTION WELD CONNECTIONS FTG TO PANEL SUBTOTALS 6408 Strip & Cleanup LINE ITEM STRIP CLEANUP SUBTOTALS 6409 Align & Grout LINE ITEM ALIGN & GROUT SUBTOTALS 6410 Patch & Rub LINE ITEM PATCH & RUB BOOM LIFT SUBTOTALS 6411 Panel Reinforcing LINE ITEM REBAR REBAR ACCESSORIES SUBTOTALS 6412 General Conditions LINE ITEM MANHOURS CREW DAYS SUPERINTENDANT 0.00 0.00 LAYOUT 8 TRUCKS FUEL TRAILER PHONE C CONTAINER SAFETY SMALL TOOLS MISC SUPPLIES WINTER CONCRETE COST LULL BOBCAT MISC OWNED EQUIP MISC RENTED EQUIPMENT TRAVEL & LODGING PERFORMANCE BONDS PERMITS

Dock Pits

PHASE CODE DESCRIPTION LINE ITEM 6705 DOCK LEVELERS (FORM, PLACE, REINFORCING) EXCAVATE CY P&F Slab FORM EDGES SF EMBED ANGLE CURE REBAR TON 3000 PSI CONCRETE EXCAVATOR

SLAB ON METAL DECK

TOTAL $/SF $/SF P&F $/SF SAWCUT # OF POURS (30,000 SF/POUR) #DIV/0! #DIV/0! #DIV/0! 0 PHASE CODE DESCRIPTION LINE ITEM 6301 Reinforcing/WWM REBAR TN Welded Wire Mesh WIRE MESH ACCESSORIES Dowel Baskets SUBTOTALS 6302 Finegrade LINE ITEM Finegrade Finegrade Excavator (MO) Skidsteer (MO) ROLLER (MO) DOZER (MO) SUBTOTALS 6303 Cure LINE ITEM CURE Densifier Concrete Polishing SUBTOTALS 6304 Sawcut LINE ITEM Sawcut SoffCut Saw (DAY) SUBTOTALS 6351 SOG Prep LINE ITEM 10 MIL POLY SF Excavate turndown CY 1/4”DIAMOND DOWELS EA 3/8”DIAMOND DOWELS EA 5/8” diameter x 18” DOWELS EA Expansion Joint. SF Dowel sleeves EA All Pour breaks Construction joints DRILL & EPOXY All perimeter Forms EDGE FORMING MISC 1 MISC 2 MISC 3 MISC 4 MISC 5 MISC 6 MISC 7 Rammax (MO) Jumping Jack (MO) Flat Plate Tamp (MO) Lull (MO) SUBTOTALS 6352 SOG Place & Finish LINE ITEM SOMD P&F SOMD P&F 2 SOMD P&F 3 SOMD P&F 4 SOMD P&F 5 WASTE 10% CONCRETE ***** CONC PUMP HRS CONC PUMP TRIPS LIGHT TOWERS (MO) Laser Screed (SF) Laser Screed Mobs EA SUBTOTALS 1102 Surveying/Layout LINE ITEM LAYOUT MHRS

SLAB ON GRADE

TOTAL $/SF $/SF P&F $/SF SAWCUT # OF POURS (30,000 SF/POUR) #DIV/0! #DIV/0! #DIV/0! 0 PHASE CODE DESCRIPTION LINE ITEM QTY UNIT 6301 Reinforcing/WWM REBAR TN 0 TN Welded Wire Mesh 0 SHEET WIRE MESH ACCESSORIES 0 SHEET Dowel Baskets 0.00 LF 0 SUBTOTALS 6302 Finegrade LINE ITEM QTY UNIT Finegrade Finegrade 0.00 SF Excavator (MO) 0 Skidsteer (MO) 0 ROLLER (MO) 0 DOZER (MO) 0 *** Proof Roll 0 EA *** Clean SOG 0 EA 0 SUBTOTALS 6303 Cure LINE ITEM QTY UNIT CURE 0 DRUM Densifier 0 DRUM Concrete Polishing 0 SF 0 0 SUBTOTALS 6304 Sawcut LINE ITEM QTY UNIT Sawcut 0 LF SoffCut Saw (DAY) 0 DAY 0 0 0 SUBTOTALS 6351 SOG Prep LINE ITEM QTY UNIT 10 MIL POLY SF 0 ROLLS Excavate turndown CY 0 CY 1/4”DIAMOND DOWELS EA 0 EA 3/8”DIAMOND DOWELS EA 0 EA 5/8” diameter x 18” DOWELS EA 0 EA Expansion Joint. SF 0 LF Dowel sleeves EA 0 EA All Pour breaks Construction joints 0.00 LF DRILL & EPOXY 0 EA All perimeter Forms EDGE FORMING 0 EA MISC 1 0 LF MISC 2 0 LF MISC 3 0 EA MISC 4 0 EA MISC 5 0 EA MISC 6 0 EA MISC 7 0 LF 0 0 0 0 Rammax (MO) 0 Jumping Jack (MO) 0 Flat Plate Tamp (MO) 0 Lull (MO) 0 SUBTOTALS 6352 SOG Place & Finish LINE ITEM QTY UNIT P&F SOG A 0 SF P&F POURBACK SOG 0 SF P&F SOG B 0 SF P&F SOG C 0 SF P&F SOG D 0 SF WASTE 7% CONCRETE 0 CY CONC PUMP HRS 0 HRS CONC PUMP TRIPS 0 EA LIGHT TOWERS (MO) 0 EA Laser Screed (SF) 0 SF Laser Screed Mobs EA 0 EA SUBTOTALS 1102 Surveying/Layout LINE ITEM QTY UNIT LAYOUT MHRS 0 HRS SUBTOTALS

Backfill Inside Bldg 57 Stone

PHASE CODE DESCRIPTION 6709 BACKFILL INSIDE BUILDING LINE ITEM EXCAVATION CY BACKFILL CY TRUCKING CY STONE TONS Excavator (MO) Skidsteer (MO) Rammax (MO) Jumping Jack (MO) Flat Plate Tamp (MO) Lull (MO) Backhoe DOZER Dumptruck

Stone Base

PHASE CODE DESCRIPTION LINE ITEM QTY UNIT 6305 Stone Base Stone TONS 0.00 TN WATER TRUCK 0 Skidsteer (MO) 0 ROLLER (MO) 0 DOZER (MO) 0 SUBTOTALS 6302 Finegrade LINE ITEM QTY UNIT Finegrade FINEGRADE 0 SF Excavator (MO) 0 Skidsteer (MO) 0 ROLLER (MO) 0 DOZER (MO) 0

Column Footings

# OF FOOTINGS #/DAY EXCAVATED #/DAY POURED CY/DAY POURED PHASE CODE DESCRIPTION 6204 Excavate CF LINE ITEM QTY UNIT PRODUCTION EXCAVATION CY 0 CY 1.5 Excavator (MO) 0 1E+13 Skidsteer (MO) 0 1E+13 ROLLER (MO) 0 1E+13 DOZER (MO) 0 1E+13 5CY DUMP TRUCK (WK) 0 WK 1E+13 0 1E+13 0 1E+13 SUBTOTALS 6206 Place CF 3KSI CONCRETE CY 0 CY 1.25 CONC PUMP HRS 0 HRS 1E+13 CONC PUMP TRIPS 0 EA 1E+13 0 10000000000 0 1E+15 SUBTOTALS 6205 Tie Reinforcing LINE ITEM QTY UNIT PRODUCTION REBAR TONS 0 TN 1E+13 0 1E+12 0 1E+12 SUBTOTALS 6702 Set Anchor Bolts LINE ITEM QTY UNIT PRODUCTION ANCHOR BOLTS 0 EA 1 0 1E+12 0 1E+12 SUBTOTALS 6703 Grout Base Plates LINE ITEM QTY UNIT PRODUCTION GROUT 0 CF 0.8 0 1E+12 0 1E+12 SUBTOTALS 6704 Diamonds Form/Place LINE ITEM QTY UNIT PRODUCTION DIAMONDS 0 EA 0.5 0 1E+12 0 1E+12 SUBTOTALS 1102 Surveying/Layout LINE ITEM QTY UNIT PRODUCTION LAYOUT 0 HRS 1 0 1E+12 0 1E+12

Continuous Footings

LF OF FOOTINGS LF/DAY EXCAVATED LF/DAY POURED CY/DAY POURED PHASE CODE DESCRIPTION 6204 Excavate WF LINE ITEM QTY UNIT EXCAVATION CY 0 CY Excavator (MO) 0 Skidsteer (MO) 0 ROLLER (MO) 0 DOZER (MO) 0 5CY DUMP TRUCK (WK) 0 WK 0 0 SUBTOTALS 6206 Place WF 3KSI CONCRETE CY 0 CY CONC PUMP HRS 0 HRS CONC PUMP TRIPS 0 EA 0 0 SUBTOTALS 6205 Tie Reinforcing LINE ITEM QTY UNIT REBAR TONS 0.00 TN 0 0 SUBTOTALS 1102 Surveying/Layout LINE ITEM QTY UNIT LAYOUT 0 HRS 0 0 SUBTOTALS