Spreadsheet: 147637d1332898290-percentage-calculation-errors-formula-problem
Sheet: Sheet1

COST BREAKDOWN - SPECIFICATION OF REPAIRS
 |  |  |  |  |  |  |  |  |  | Draw 1 |  |  |  |  | 2012-03-18 00:00:00 |  |  | Draw 2 |  |  |  |  | 2012-03-18 00:00:00 |  | Draw 3 |  |  | 2012-03-18 00:00:00 |  | Draw 4 |  |  | 2012-03-18 00:00:00 |  | Draw 5 |  |  | 2012-03-18 00:00:00 |  | Draw 6 |  |  | 2012-03-18 00:00:00
1 | Masonry-Foundation |  |  | Labor | [NAME]. | Tax | 0.098 | Total |  | Bid Amount | Invoice Amount | Money Under Budget | Revised Total | Request for this draw | Percent Complete |  | Total Allotted | Remaining Balance | Invoice Amount | Money Under Budget | Revised Total | Request for this draw | Percent Complete |  | Balance | Money Under Budget | Requst for this draw | Percent Complete |  | Balance | Money Under Budget | Requst for this draw | Percent Complete |  | Balance | Money Under Budget | Requst for this draw | Percent Complete |  | Balance | Money Under Budget | Requst for this draw | Percent Complete |  | Total Disbursed | % Disbursed | Balance
 | 1.1 | N/A |  | 8215 | 10000 | 1785.07 |  | 20000.07 |  | 20000.07 | 0 | 0 | 20000.07 | 2000.007 | 0.1 |  | 20000.07 | 18000.063 | 0 | 0 | 20000.07 | -1999.807 | 0.2 |  | 19999.87 | 0 | 7999.947999999999 | 0.6 |  | 11999.922 | 0 | 1799.9883 | 0.75 |  | 10199.9337 | 0 | 2549.983425 | 1 |  | 7649.950274999999 | 0 | 0 | 0 |  | 12350.119725
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 20000.07
2 | Sidings |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 2.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
3 | Gutters & Down Spouts |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 3.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
4 | Roof |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 4.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
5 | Shutters |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 5.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
6 | Exteriors (Decks) |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 6.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
7 | Walks (Patios, Pavers) |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 7.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
8 | Driveways |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 8.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
9 | Exterior Painting |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 9.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  | 0 |  | Total |  | 0
10 | Caulking |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 10.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
11 | Fencing |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 11.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
12 | Grading (Excavation, Backfill) |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 12.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
13 | Windows |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 13.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
14 | Weather-stripping |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 14.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
15 | Exterior Doors |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 15.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
16 | Interior Doors |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 16.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
17 | Partition Walls (Framing) |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 17.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
18 | Drywall-Plaster |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 18.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
19 | Decorating (Interior Painting) |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 19.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
20 | Wood Trim |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 20.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
21 | Stairs |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 21.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  |  | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
22 | Closets |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 22.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  | 0
 |  |  |  |  |  | Total |  | 0
23 | Wood Floors |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 23.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
24 | Finished Floors |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 24.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
25 | Ceramic Tile (Floors, Showers, Counters, etc.) |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 25.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
26 | Bathroom Accessories |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 26.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
27 | Plumbing |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 27.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 27.1 |  |  | 0 | 0 | 0 |  | 0
 | 27.11 |  |  | 0 | 0 | 0 |  | 0
 | 27.12 |  |  | 0 | 0 | 0 |  | 0
 | 27.13 |  |  | 0 | 0 | 0 |  | 0
 | 27.14 |  |  | 0 | 0 | 0 |  | 0
 | 27.15 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
28 | Electrical |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 28.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 28.1 |  |  | 0 | 0 | 0 |  | 0
 | 28.11 |  |  | 0 | 0 | 0 |  | 0
 | 28.12 |  |  | 0 | 0 | 0 |  | 0
 | 28.13 |  |  | 0 | 0 | 0 |  | 0
 | 28.14 |  |  | 0 | 0 | 0 |  | 0
 | 28.15 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
29 | Heating |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 29.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
30 | Insulation |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 30.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
31 | Cabinetry (and Counters) |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 31.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
32 | Appliances |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 32.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
33 | Basements (Crawl Spaces) |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 33.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 33.1 |  |  | 0 | 0 | 0 |  | 0
 | 33.11 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
34 | Cleanup |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 34.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
35 | Miscellaneous |  |  | Labor | Bid/Cost | Tax | 0.098 | Total
 | 35.1 | N/A |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 0 |  |  | 0 | 0 | 0 |  | 0
 | 35.1 |  |  | 0 | 0 | 0 |  | 0
 | 35.11 |  |  | 0 | 0 | 0 |  | 0
 | 35.12 |  |  | 0 | 0 | 0 |  | 0
 | 35.13 |  |  | 0 | 0 | 0 |  | 0
 | 35.14 |  |  | 0 | 0 | 0 |  | 0
 | 35.15 |  |  | 0 | 0 | 0 |  | 0
 |  |  |  |  |  | Total |  | 0
 |  |  |  | Labor | [NAME]. | Tax |  | Total
 |  |  | Grand Totals | 8215 | 10000 | 1785.07 |  | 20000.07
 |  |  | 2011-12-29 00:00:00 |  | SO-524
Consultant Signature |  |  | Date |  | I.D Number
Borrower Signature |  |  | Date
Borrower Signature |  |  | Date
Contractor Signature |  |  | Date