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

Project No.:
Project Name:
Client:
CRA Construction Manager:
CRA Site Superintendent:
Phase | Task | Description |  | Phase | Task | Description |  | Phase | Task | Description |  | Phase | Task | Description |  | Phase | Task | Description |  | Phase | Task | Description
05 |  | Overhead- Direct/Indirect |  | 50 |  |  |  | 95 |  |  |  | 140 |  |  |  | 185 |  |  |  | 230
 | 10 | Permits/Bonds/Insurance/Contingency |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor
 | 20 | Safety |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials
 | 30 | Project Administration Labor |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned
 | 40 | Rentals |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented
 | 50 | Travel - Lodging Per Diem, Mileage, Trips Home |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts
 | 60 | Consumables, Miscellaneous |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other
10 |  |  |  | 55 |  |  |  | 100 |  |  |  | 145 |  |  |  | 190 |  |  |  | 235
 | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor
 | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials
 | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned
 | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented
 | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts
 | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other
15 |  |  |  | 60 |  |  |  | 105 |  |  |  | 150 |  |  |  | 195 |  |  |  | 240
 | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor
 | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials
 | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned
 | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented
 | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts
 | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other
20 |  |  |  | 65 |  |  |  | 110 |  |  |  | 155 |  |  |  | 200 |  |  |  | 245
 | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor
 | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials
 | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned
 | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented
 | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts
 | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other
25 |  |  |  | 70 |  |  |  | 115 |  |  |  | 160 |  |  |  | 205
 | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor
 | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials
 | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned
 | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented
 | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts
 | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other
30 |  |  |  | 75 |  |  |  | 120 |  |  |  | 165 |  |  |  | 210
 | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor
 | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials
 | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned
 | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented
 | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts
 | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other
35 |  |  |  | 80 |  |  |  | 125 |  |  |  | 170 |  |  |  | 215
 | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor
 | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials
 | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned
 | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented
 | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts
 | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other
40 |  |  |  | 85 |  |  |  | 130 |  |  |  | 175 |  |  |  | 220
 | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor
 | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials
 | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned
 | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented
 | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts
 | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other
45 |  |  |  | 90 |  |  |  | 135 |  |  |  | 180 |  |  |  | 225
 | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor |  |  | 10 | Labor
 | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials |  |  | 20 | Materials
 | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned |  |  | 30 | Equipment Owned
 | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented |  |  | 40 | Equipment Rented
 | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts |  |  | 50 | Subcontracts
 | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other |  |  | 60 | Other