Spreadsheet: 767913d1644727437-formatting-crystal-reports-data-in-excel-formatting-question
Sheet: Sheet1

Item | Sub-Type | Estimate Cost | Actual Cost | Open POs | Items Recieved | Committed Costs | Total Projected | Estimated Revenue | Estimated Margin % | Actual Revenue | Actual Margin % | Actual Time To Date | Open A/R Balance | Paid To Date
 | **No Item Entered** | 649.68 |  |  |  |  |  | 649.68
Total for Convenience Fee |  | 649.68 |  |  |  |  |  | 649.68
 | Electrical Equipment Install | 1125 | 692.83 |  |  |  | 692.83 | 1731 |  |  |  | 23
 | Mechanical/Racking | 844 | 1106.78 |  |  |  | 1106.78 | 1298 |  |  |  | 40
Total for Install |  | 1969 | 1799.61 |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  | 1799.61 | 3029
 | Freight | 50 | 286.09 |  |  |  | 286.09 | 67
 | Inverters | 1238 | 287.92 |  |  |  | 287.92 | 1650
 | Monitoring Equipment | 500 |  |  |  |  |  | 667
 | Racking | 563 | 980.75 |  |  |  | 980.75 | 750
 | Residential BOS | 563 | 60.32 |  |  |  | 60.32 | 750
 | Sales tax | 450 | 620.92 |  |  |  | 620.92 | 600
 | Solar Modules | 4500 | 5319.45 |  |  |  | 5319.45 | 6000
 | String Wire/lugs/connectors |  | 64.12 |  |  |  | 64.12
Total for Material |  | 7864 | 7619.57
 |  |  |  |  |  |  | 7619.57 | 10484
 | Design | 300 | 624.35 |  |  |  | 624.35 | 462 |  |  |  | 18.5
 | Inspections | 200 | 226.49 |  |  |  | 226.49 | 308 |  |  |  | 7
 | Project Administration | 300 | 971.05 |  |  |  | 971.05 | 462 |  |  |  | 26.75
 | Project Management | 300 |  |  |  |  |  | 5178
 | Site Audit | 200 | 185.62 |  |  |  | 185.62 | 308 |  |  |  | 5.5
Total for Prof Svc |  | 1300 | 2007.51 |  |  |  |  |  |  |  |  | 57.75
 |  |  |  |  |  |  | 2007.51 | 6718
 | Commission | 580 |  |  |  |  |  | 580
 | Drive Pay |  | 66.94 |  |  |  | 66.94
 | Permits | 250 | 757.09 |  |  |  | 757.09 | 250
 | Utility Fees | 145 | 145 |  |  |  | 145 | 145
Total for Project Expense |  | 975 | 969.03
 |  |  |  |  |  |  | 969.03 | 975
 | Interconnection  Consultant | 450 |  |  |  |  |  | 450
Total for Subcontractors |  | 450 |  |  |  |  |  | 450
[NAME] |  | 13207.68 | 12395.72 | 0 | 0 | 0 | 12395.72 | 22305.68 | 40.78781727344784 | 22305.68 | 44.42796632965236 | 120.75 | 0 | 22305.68
 | Electrical Equipment Install | 1190 | 707.35 |  |  |  | 707.35 | 1831 |  |  |  | 26
 | Inverter installation | 1309 |  |  |  |  |  | 1870
 | Mechanical/Racking | 893 | 615.86 |  |  |  | 615.86 | 1373 |  |  |  | 21
 | MSP Installation | 960 | 1408 |  |  |  | 1408 | 1477 |  |  |  | 46
Total for Install |  | 4352 | 2731.21 |  |  |  |  |  |  |  |  | 93
 |  |  |  |  |  |  | 2731.21 | 6551
 | Electrical Equipment |  | 269.76 |  |  |  | 269.76
 | Freight | 150 | 311.9399999999999 |  |  |  | 311.9399999999999 | 214
 | Inverters |  | 2447.32 |  |  |  | 2447.32
 | Monitoring Equipment | 500 | 490.11 |  |  |  | 490.11 | 714
 | MSP Equiptment | 1000 |  |  |  |  |  | 1429
 | Racking | 1012 | 534.17 |  |  |  | 534.17 | 1445
 | Residential BOS | 893 | 26 |  |  |  | 26 | 1275
 | Sales tax | 900 | 766.95 |  |  |  | 766.95 | 1286
 | Solar Modules | 4760 | 4495.48 |  |  |  | 4495.48 | 6800
 | String Wire/lugs/connectors |  | 28.48 |  |  |  | 28.48
Total for Material |  | 9215 | 9370.21
 |  |  |  |  |  |  | 9370.21 | 13163
 | Design | 600 | 67.51 |  |  |  | 67.51 | 504 |  |  |  | 2
 | Inspections | 200 | 156.2 |  |  |  | 156.2 | 308 |  |  |  | 5
 | MSP Project Administration | 384 | 276.88 |  |  |  | 276.88 | 171 |  |  |  | 7
 | Project Administration | 576 | 799.31 |  |  |  | 799.31 | 467 |  |  |  | 23.25
 | Project Management | 600 |  |  |  |  |  | 503
 | Site Audit | 196 | 134.99 |  |  |  | 134.99 | 302 |  |  |  | 4
Total for Prof Svc |  | 2556 | 1434.89 |  |  |  |  |  |  |  |  | 41.25
 |  |  |  |  |  |  | 1434.89 | 2255
 | Commission | 1200 |  |  |  |  |  | 1714
 | Drive Pay |  | 66.96 |  |  |  | 66.96
 | Permits | 250 | 488 |  |  |  | 488 | 357
 | Referral Fees |  | 500 |  |  |  | 500
 | Utility Fees | 145 | 290 |  |  |  | 290 | 207
Total for Project Expense |  | 1595 | 1344.96
 |  |  |  |  |  |  | 1344.96 | 2278
 | Interconnection  Consultant | 450 |  |  |  |  |  | 643
 | Other Subcontractor |  | 750 |  |  |  | 750
Total for Subcontractors |  | 450 | 750
 |  |  |  |  |  |  | 750 | 643
[NAME] |  | 18168 | 15631.27 | 0 | 0 | 0 | 15631.27 | 24890 | 27.00683005222981 | 24890 | 37.19859381277622 | 134.25 | 0 | 24890