Spreadsheet: 141153d1329132201-excel-2007-macro-for-inserting-rows-with-formulas-test-populated
Sheet: 10-50

Phase | Task | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor Total | Quantity | Unit | Unit Price | Owned Equipment | Rented Equipment | Material | Subs | Other | [NAME] % | [NAME] Cost | Total Cost
 |  |  |  |  |  |  |  |  |  | Hours | Hours | Hours | Hours | Hours | Hours | Hours
 | 10 | Labor | Column1 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column110 | Column111 | Column112 | Column113 | Column114 | Column115 | Column116 | Column117 | Column118 | Column119 | Column120 | Column121 | Column122 | Column123 | Column124 | Column125 | Column126
 |  | Welders |  |  |  | 2 |  |  |  |  |  |  | 172 |  |  |  |  |  |  |  |  |  |  |  |  | 0.07
 |  | Equipment Operators |  | 2 |  |  |  |  |  |  | 344 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.07
 |  | Superintendent | 1 |  |  |  |  |  |  | 500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.07
 |  | Subtotals
 | 20 | Materials | Column1 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column110 | Column111 | Column112 | Column113 | Column114 | Column115 | Column116 | Column117 | Column118 | Column119 | Column120 | Column121 | Column122 | Column123 | Column124 | Column125 | Column126
 |  | 4" DI |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1250 | LF | 20.5 |  |  |  |  |  | 0.1
 |  | Valves |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | EA | 576 |  |  |  |  |  | 0.1
 |  | Misc fittings |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | LS | 1500 |  |  |  |  |  | 0.1
 |  | Subtotals
 | 30 | Equipment Owned | Column1 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column110 | Column111 | Column112 | Column113 | Column114 | Column115 | Column116 | Column117 | Column118 | Column119 | Column120 | Column121 | Column122 | Column123 | Column124 | Column125 | Column126
 |  | Generator - Monthly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Month
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Month
 |  | Vehicle - Field Truck - Monthly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Month
 |  | Subtotals
 | 40 | Equipment Rented | Column1 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column110 | Column111 | Column112 | Column113 | Column114 | Column115 | Column116 | Column117 | Column118 | Column119 | Column120 | Column121 | Column122 | Column123 | Column124 | Column125 | Column126
 |  | Hydraulic Excavators-320D LLR 50,265 lbs, 21'9" dig depth- Monthly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Month |  |  |  |  |  |  | 0.1
 |  | Telescopic Material Handlers TL9943 9,000 lbs., 43- Monthly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Month |  |  |  |  |  |  | 0.1
 |  | Water Equipment-2,000 gallon water truck- Monthly |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Month |  |  |  |  |  |  | 0.1
PHASE 10 - |  | Subtotals
 | 50 | Subcontracts | Column1 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column110 | Column111 | Column112 | Column113 | Column114 | Column115 | Column116 | Column117 | Column118 | Column119 | Column120 | Column121 | Column122 | Column123 | Column124 | Column125 | Column126
 |  | QA/QC Sub |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | LS | 3000 |  |  |  |  |  | 0.1
 |  | Subtotals
 | 60 | Other | Column1 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column110 | Column111 | Column112 | Column113 | Column114 | Column115 | Column116 | Column117 | Column118 | Column119 | Column120 | Column121 | Column122 | Column123 | Column124 | Column125 | Column126
 |  | Fuel, Oil, Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | LS | 2600 |  |  |  |  |  | 0.1
 |  | Subtotals
 |  | Phase 10 Total
 | 10 | Labor | Column1 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column110 | Column111 | Column112 | Column113 | Column114 | Column115 | Column116 | Column117 | Column118 | Column119 | Column120 | Column121 | Column122 | Column123 | Column124 | Column125 | Column126
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 15 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 15 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 20 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 20 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 25 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 25 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 30 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 30 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 35 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 35 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
[NAME] |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 40 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 45 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 45 Total
 | 10
 |  | Subtotals
 | 20
 |  | Subtotals
 | 30
 |  | Subtotals
 | 40
PHASE 50 - |  | Subtotals
 | 50
 |  | Subtotals
 | 60
 |  | Subtotals
 |  | Phase 50 Total
 |  | Page Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total (excluding markup)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage