Spreadsheet: 541414d1507276542-formula-to-incrementally-exhaust-a-total-blank-job-breakdown_kp2
Sheet: Main Contract

Client
Job Number
Project name
 | Contract price |  | TOTAL CLAIM TO DATE | LEFT TO CLAIM | Claim | 1 | Claim |  | Claim |  | Claim | 4 | Claim |  | Claim |  | Claim |  | Claim |  | Claim |  | Claim |  |  | Claim |  | Claim |  | Claim |  | Claim |  | Claim |  | Claim |  | Claim |  | Claim |  | Claim |  | Claim |  | Claim |  | Claim |  | Claim
 |  |  |  |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv # |  | Inv #
 |  |  |  |  | $
Section 1 | General | Amount | TOTAL CLAIM TO DATE | LEFT TO CLAIM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Claimed | Approved | Revised | Approved | Claimed | Approved | Claimed | Approved | Claimed | Approved | Claimed | Approved | Claimed | Approved | Claimed | Approved | Claimed | Approved | Claimed | Approved | Claimed | Approved | Claimed | Approved | Claimed | Approved | Claimed | Approved | Claimed
1
 | External Civil Works | 200000 |  |  |  | 12877.6 |  | 0 |  |  |  | 0 |  | 0
 | 18 Terraces |  |  |  |  | 0 |  | 0 |  |  |  | 0
 | Stacks | 63551.99999999996
 | Terraces Rough In - Gas, Hot & Cold Water | 73008
 | sewer and stormwater internal works & groundworks | 60000 |  |  |  |  |  |  |  |  |  |  |  | 60000
 | Terraces Fit Off | 84240
 | Workshop Drawings/Design Meetings | 20000 |  |  |  | 20000 |  | 0 |  |  |  | 0 |  | 0
 | Temporary Services | 8297.77 |  |  |  | 0 |  | 2297.77 |  |  |  | 0 |  | 0 |  |  |  |  |  | 6000
 | Sewer Connection Fees | 3834.9 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | Cold Water Connection Fees | 5148.87 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
 | Gas Connection to Path Valve | 2198.43 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0
Section 2 | Basement 2 | Amount
2
 | Subsoil Drainage | 3900.87 |  |  |  |  |  | 3900.87
 | Carpark Grates on B2 Floor | 2500 |  |  |  |  |  | 2500
 | Stormwater works pipes & pits on B2 Floor | 44787.96 |  |  |  |  |  | 44787.96
 | [NAME] and (car wash Bay above ground) | 5200 |  |  |  |  |  | 2600
 | Basement 1 | Amount
 | Penetration | 1099.22 |  |  |  |  |  |  |  | 1099.22 |  |  |  |  |  | 0
 | Carpark Grates on B1 floor | 1113.71 |  |  |  |  |  |  |  | 1113.71 |  |  |  |  |  | 0
 | Stormwater & sewer works under B1 Floor @ H/L | 4619.84 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 4619.84
 | Domestic, Fire & rainwater reuse pumps | 26491.09 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 20000 |  |  |  | 3400 | 3400
 | High Level Cold, Hot, Npcw, Fire, Gas Reticulation | 81247.33 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  | 70000 |  | 11247.33
 | High Level Sewer and Stormwater for Ground floor | 93885.09 |  |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  | 93885.09
 | Level 1 Ground Floor | Amount
 | Penetrations | 6694.31 |  |  |  |  |  |  |  |  |  | 6694.31 |  |  |  | 0
 | Stacks | 71405.92 |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  | 71405.92
 | Apartment Rough In - Gas, Hot & Cold Water | 81488.84 |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 2488.84 |  |  |  |  |  | 79000
 | Cold & Hot & Gas Risers | 15000 |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0
 | Downpipes | 7000 |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  | 2690 |  |  |  | 4310
 | Apartment Fit Off | 66943.05 |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | (BG01 - only) | 4714.28
 | LEVEL 2 | Amount
 | Penetrations | 6694.31 |  |  |  |  |  |  |  |  |  |  |  | 3347.16 |  | 0 |  |  |  |  |  | 3347.15
 | Stacks | 71405.92 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  | 71405.92
 | Apartment Rough In - Gas, Hot & Cold Water | 81488.84 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 2488.84 |  |  |  |  |  | 39500 |  |  | 39500
 | Cold & Hot & Gas Risers | 15000 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | Downpipes | 7000 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  |  |  |  |  |  |  |  | 7000
 | Apartment Fit Off | 66943.05 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
 | LEVEL 3 | Amount
 | Penetrations | 6694.31 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6694.31
 | Stacks | 71405.92 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  | 71405.92
 | Apartment Rough In - Gas, Hot & Cold Water | 81488.84 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2488.84 |  |  |  |  |  |  |  |  |  |  |  |  | 79000
 | Cold & Hot & Gas Risers | 15000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Downpipes | 7000 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Apartment Fit Off | 66943.05 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | LEVEL 4 | Amount
 | Penetrations | 6694.305 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6694.305
 | Stacks | 71405.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71405.92 | 71405.92
 | Apartment Rough In - Gas, Hot & Cold Water | 81488.84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2488.84 |  |  |  |  |  |  |  | 30000 | 30000 |  | 49000
 | Cold & Hot & Gas Risers | 15000
 | Downpipes | 7000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7000
 | Apartment Fit Off | 66943.05
 | LEVEL 5 | Amount
 | Penetrations | 6694.31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6694.31
 | Stacks | 71405.92 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30000 | 30000 |  | 41405.92
 | Apartment Rough In - Gas, Hot & Cold Water | 81488.84 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2488.84 |  |  |  |  |  |  |  |  | 70000
 | Cold & Hot & Gas Risers | 15000
 | Downpipes | 7000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7000
 | Apartment Fit Off | 66943.05
 | LEVEL 6 | Amount
 | Penetrations | 6198.43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6198.43
 | Stacks | 60248.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60248.75
 | Apartment Rough In - Gas, Hot & Cold Water | 61271.35
 | Cold & Hot & Gas Risers | 7748.04
 | Downpipes | 6198.43 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6198.43
 | Apartment Fit Off | 54236.27
 | [NAME] | Amount
 | Penetrations | 1099.22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1099.22
 | Stormwater on roof and grates | 5099.22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5099.22
 | Sewer Vents | 1549.61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1549.61