Spreadsheet: 118642d1313821119-shorten-formula-to-avoid-maxing-of-cpu-master-budget
Sheet: Enclosed 

CODE | ITEM | Supplier | QTY | COST |  | ACTUAL COST | Inc B/M | GST Amt | Total Inc GST | CODE TOTAL
5-1330 | EXTERNAL CLADDING
51330 | Matrix panel 9mm 2390X590 |  | 38 | 31.58 | Lm
51330 | Cavity Trim |  | 70 | 11.86 | Lm
51330 | Hardiblade |  | 1 | 142.23 | Lm
51330 | Strip vent |  | 10 | 6.36 | m2
51330 | Backing strip |  | 35 | 8.14 | Lm
51330 | Cbrad nails |  | 1 | 57.69 | Lm
51330 |  |  |  |  | Lm
51330 | NRG Board |  |  |  | Lm
51330 |  |  |  |  | m2
51330 | Quote |  | 1 | 4394.41 | each
51330 |  |  | 0 | 3.35 | Lm
51330 |  |  | 0 | 12 | m2
51330 |  |  | 0 | 12 | m2
51330 |  |  | 0 | 100 | item
52233 |  |  | 0 | 18 | m2
52233 |  |  | 0 | 75 | m2
52233 |  |  | 0 | 62 | m2
56000 |  |  | 0 | 50 | item
51320 | Sarking
51320 | Wall Sarking (1.3*1m, 60 m ) |  | 2 | 120 | roll
51320 | Spot Fixers |  | 1 | 12 | box
51320 | Staples |  | 3 | 12.55 | box
51320 | Insulation
51320 | R1.5 (11.2m2 /bag) |  | 14 | 27.2 | bags
51320 | R2.0 (7.5m2/bag) |  | 0 | 5 | m2
51320 | R2.5 (7.5m2/bag) |  | 0 | 6.6 | m2
52230 | SCAFFOLDING
52230 | [NAME] (Platform) |  | 0 | 28 | m
52230 | [NAME] Protection |  | 0 | 15 | m
52230 | [NAME] (Pick up & Delivery) |  | 0 | 100 | item
52230 | [NAME] |  | 1 | 12000 | item
57000 | 6 metre Planks |  | 0 | 22 | week
57000 | 16' [NAME] (pair) |  | 0 | 22 | week
5-1180 | BLOCK/BRICK WORK
51180 | Brickwork
51180 | 190mm Stey STD |  | 270 |  | p/1000
51180 | 190mm grey 3/4 |  | 120 |  | each
51180 | 190mm Grey half |  | 450 |  | each
51180 | 190mm grey control |  | 120 |  | p/1000
51180 | 190mm grey half control |  | 120 |  | p/3000
51180 | 190mm grey lintel |  | 90 |  | item
52217 | 190mm [NAME] |  | 270 |  | project
52217 | 190mm grey corner knockout |  | 270 |  | p/1000
52217 | 190mm grey h block |  | 4140 |  | p/1000
52217 | 190mm grey halof height |  | 300 |  | each
52217 | 290mm grey standard |  | 10 |  | Lm
52217 | 290mm grey h block |  | 120 |  | m
52217 | Quote |  | 1 |  | quote
52217 |  |  | 0 | 6.5 | m2
52217 |  |  | 0 | 10 | each
52217 | Vertical control Joint caulking |  | 50 | 20 | Lm
 | [NAME]
52217 | [NAME] including installation |  | 0 | 14 | block
 | Blockwork
52217 |  |  |  | 180 | block
52217 | Blocklayer |  |  | 2.8 | block
51180 |  |  |  | 2.13 | block
51180 |  |  |  | 2.13 | block
51180 |  |  |  | 20 | lm
51180 |  |  |  | 20 | lm
51180 | Waterproof Sealant |  | 0 | 180 | Tin
5-1300 | WINDOWS & SCREENS
51300 | [NAME] |  | 1 | 28882 | quote
51300 | Window Flashing 1.8m |  | 0 | 2.1 | m
51300 | [NAME]
51300 |  |  | 0 | 945 | item
51300 |  |  | 0 | 2668 | item
51300 |  |  | 0 |  | item
51300 | Sundry Glass
51300 | Fixed [NAME] |  | 0 | 1 | item
5-1310 | TIMBER JOINERY |  |  | 1 | quote
51310 | Stairs |  | 1 |  | quote
5-1350 | ROOF
51210 | [NAME]
51210 | Pine LSOP Pink Facia 180*25 |  | 0 | 9.25 | lm
51210 | [NAME] |  | 0 | 2.6 | Lm
51210 | Ceiling [NAME]*35 dressed |  | 0 | 1.08 | Lm
51210 | Ceiling Battens (steel) |  | 45 | 5.48 | Lm
51350 | [NAME]
51350 | Zincalume 762 Cover (incl. Gutter) |  | 0 | 37 | m2
51350 | [NAME]
51350 | Colourbond 762 Cover (incl. Gutter) |  | 0 | 42 | m2
51350 | Awnings 15mm CFC |  |  | 54 | m2
51350 | Metal Fascias & Gutter |  | 0 | 40 | m5
51350 | [NAME] 18m2*2*50m |  | 0 | 80 | roll
51350 | [NAME] 300mm Mill Finish |  | 0 | 90 | item
51350 | [NAME] 300mm Colourbond |  | 0 | 110 | item
51350 | [NAME]*600 |  | 0 | 460 | each
51670 | [NAME] Galv 14-10 x 75mm |  | 0 | 0.15 | each
51670 | Hoop Pine Strap 50m*30mm |  | 0 | 40 | roll
52233 | Supply & Fix Trim Deck Roof |  | 0 | 21000 | item
52233 | [NAME] |  | 0 | 35 | hours
56000 | [NAME] |  | 0 | 30 | load
52237 | WATERPROOFING
51410 | Quote Flexitray waterproofing |  | 1 | 2700 | quote
52237 | [NAME] tanking to floors and walls |  | 0 | 35 | m2
52237 | Waterproofing to Blockwalls |  | 0 | 35 | m2
 | Fibreglass
52237 | 900*900 |  | 0 | 120 | each
52237 | 1000*1500 |  | 0 | 180 | each
52237 | 1200*900 |  | 0 | 159 | each
52237 | 1500*900 |  | 0 | 160 | each
52237 | 1200*1200 |  | 0 | 150 | each
52237 | Hobs |  | 0 | 30 | each
52237 | [NAME] |  | 0 | 10 | lm
52237 | Sealer Floors |  | 0 | 32 | m2
52220 | PLUMBING
52220 | Subcontractor Supply & Fix |  | 0 | 19000 | quote
52220 | Gas Fitter 2x heaters |  | 0 | 1490 | quote
51460 | PLUMBING PC ITEMS |  |  |  | PC
51460 | Plumbing total PC |  | 1 | 17000 | each
51460 | [NAME] 100mm CP to PVC |  | 0 | 0 | each
51460 | 125L HWS |  | 0 | 387 | each
51460 | 250L HWS |  | 0 | 556 | each
51460 | 315L Dux HWS |  | 0 | 688.2 | each
51460 | HWS Stainless Steel Tray |  | 0 | 250 | each
51460 | Garbage Disposal |  | 0 | 137 | each
51460 | Vanity Basin |  | 0 | 79.36 | each
51460 | Semi Recessed Vanity Basin |  | 0 | 135 | each
51460 | Mini Wall Basin & Brackets |  | 0 | 130 | each
51460 | Bath |  | 0 | 125 | each
51460 | Plug & Waste |  | 0 | 4.1 | each
51460 | Spa Bath |  | 0 | 0 | each
51460 | Shower Base |  | 0 | 189 | each
51460 | Oliveri DF27 1234mm 1.75 Sink |  | 0 | 340.14 | each
51460 | Basin Taps |  | 0 | 90.75 | each
51460 | Bath Taps |  | 0 | 66.88 | each
51460 | Shower Taps |  | 0 | 74.94 | each
51460 | Cistern Stops |  | 0 | 5.95 | each
51460 | Washing Machine Taps |  | 0 | 70.4 | each
51460 | Wall Stop Set |  | 0 | 27.6 | each
51460 | [NAME]. |  | 0 | 14.14 | each
51460 | Wall Basin Taps |  | 0 | 101.44 | each
51460 | [NAME] |  | 0 | 98.81 | each
51460 | [NAME] and Cabinet |  | 0 | 220.2 | each
51460 | [NAME] |  | 0 | 0 | each
51460 | [NAME] |  | 0 | 36.27 | each
51460 | [NAME] |  | 0 | 56.61 | each
51460 | [NAME] |  | 0 | 0 | each
51460 | Toilet |  | 0 | 180 | each
51460 | Toilet Roll Holder |  | 0 | 21.78 | each
51460 | Soap Dish Holder |  | 0 | 0 | each
51460 | Shower S.S.Grate & PVC Channel |  | 0 | 430 | each
51460 | Allowance |  | 0 | 12000 | quote
51460 |  |  | 0 | 12625 | quote
52223 | ELECTRICAL
52223 | Subcontractor Quotation |  | 1 | 18122 | quote
52223 |  |  | 0 | 0 | quote
51470 | ELECTRICAL FITTINGS |  |  |  | PC
51470 | Exhaust Fans |  | 0 | 0 | each
51470 | Ceiling Fans 48" 3 Blade Aluminium |  | 0 | 90 | each
51470 | Sensor Light |  | 0 | 0 | each
51470 | White Goods |  | 0 | 0 | quote
51470 | Smoke Detectors |  | 0 | 110 | each
51470 |  |  | 0 | 100 | each
51470 | Lights |  | 0 | 60 | PC
52223 | TELSTRA
52223 | Standard Connection |  | 0 | 0 | item
52223 | Trench Digging |  | 0 | 14 | m
52227 | CARPENTER LOCKUP
52227 | [NAME] |  | 248 | 42 | hour
52227 | Tradesperson |  | 0 | 38 | hour
52227 | Labourer |  | 0 | 25 | hour
52227 | Apprentice |  | 248 | 16.45 | hour
 | Lockup Totals |  | 0
NOTES
1 | NO ALLOWANCE FOR SCREENS ON ALL DOORS