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

CODE | ITEM | Supplier | QTY | COST |  | ACTUAL COST | INC B/M | GST Amt | TOTAL INC GST | CODE TOTAL
5-1400 | PLASTER
51400 | 6mm Villaboard 1350*1200 |  | 0 | 20.68 | each
51400 | 6mm Villaboard 1800*1200 |  | 0 | 13.77 | each
51400 | 6mm Villaboard 2400*1200 |  | 0 | 18.37 | each
52235 | Internal Plaster RCA Plastering |  | 1 | 25000 | quote
52235 | [NAME]
52235 | NRG render |  | 169.48 | 40 | m2
52235 | block work render |  |  | 28 | m2
52235 | render northern wall |  | 66.78 | 28 | m2
52235 | nrg hoods |  | 32.9 | 45 | m2
52235 | Quote |  | 0 | 15180 | quote
5-1330 | SOFFITS
51330 | 6mm Villaboard 2400*1200 |  | 0 | 12 | m2
51330 | 6mm Hardiflex 1800*1200 |  |  | 23 | each
51330 | 6mm Hardiflex 2400*1200 |  |  | 28.6 | each
51330 | 6mm Hardiflex 3000*1200 |  | 0 | 35.7 | each
51330 | 6mm Hardiflex 3000*900 |  |  | 26.6 | each
51330 | 6mm Hardiflex 2400*900 |  |  | 21.5 | each
51330 | 4.5mm Hardiflex 2400*1200 |  | 0 | 8 | m2
51330 | [NAME] |  | 0 | 1 | Lm
51330 | Sunhoods / Awnings |  | 0 | 1 | item
51330 | 18mm Fibre Cement |  | 0 | 60 | m2
51445 | 42*19 |  | 0 | 1.33 | Lm
51445 |  |  | 0 | 1.33 | Lm
5-1430 | DOORS
 | Internal & External Doors
5-1435 | Front Door and media doors |  | 2 | 1750 | PC
51430 | Int. Primecoat 2340X820X35 |  | 5 | 42.26 | each
51430 | Int. Primecoat 2340X720X35 |  | 3 | 42.26 | each
51430 | Cavity Sliding unit 770X2390 |  | 2 | 193.98 | each
51430 | 2340x 900 Int Hollow. |  | 0 | 95 | each
51430 | 2340x <870 [NAME] |  | 0 | 43 | each
51430 | Slide |  | 0 | 25.33 | each
51430 |  |  | 0 | 2000 | each
51430 | [NAME] 2040*820 |  | 0 | 200 | each
51430 | French Doors |  | 0 | 485 | each
51430 | Interoir Redicote 2340*1220 |  | 0 | 185 | each
51430 | Cavity Slider Easyglide 2340 |  | 0 | 180 | each
51430
5-1435 | Door Handles and Seals |  | 0 | 55 | PC
51435 | Handles Etc |  | 11 | 55 | each
51435 | Storage Bolts |  | 0 | 30 | each
51435 | Deadlock |  | 0 | 78.2 | each
51435 | Passage Set |  | 0 | 70 | each
51435 | Privacy Adaptor |  | 0 | 18 | each
51435 | Door Stop Magnet |  | 0 | 16 | each
51435 | Lockwood Sliding Privacy Latch |  | 0 | 20 | each
51435 | Weather Seal |  | 1 | 40 | each
51435 | Efco 100mm D Pull SCP |  | 0 | 13 | each
51435 | [NAME] |  | 5 | 12 | cylndr
51435 | [NAME] |  | 0 | 5 | each
51430 | Door Hardware
51430 | [NAME] |  | 0 | 16.5 | each
51430 | [NAME] 100mm PB Zen |  | 0 | 6.15 | each
51430 | Flush Bolt SCP Timber Door |  | 0 | 15 | each
51430 | Stainless Steel Hairline |  | 0 | 15 | pair
51430 | [NAME]*100Z |  | 0 | 3 | pair
51430 | [NAME]*100 ZP |  | 0 | 2 | each
51430 | Hairline Hinges 100mm Zinc |  | 0 | 1.5 | each
51430 | Hinge Screws (1000) |  | 0 | 28 | box
51430 | Entrance Jamb 140 x 19 |  | 0 | 12.5 | Lm
51430 | Door Sill |  | 0 | 12 | Lm
51430 | Door Stop Magnet 040 SC Scope |  | 0 | 22 | each
51430 | Door Stops DS2 |  | 0 | 0.8 | each
51430 | Door Stops DS1 |  | 0 | 0.65 | each
51430 | Sliding Door Track |  | 0 | 88 | each
5-1440 | SHELVING
51440 | White Board 2400*600 |  | 0 | 22 | sheet
51440 | White Board 3600*600 |  | 0 | 30 | sheet
51440 | White Board 2400*450 |  | 0 | 17 | sheet
51440 | White Board 3600*450 |  | 0 | 22.9 | sheet
51440 | 19mm Chrome Hanging Rail |  | 0 | 4 | Lm
51440 | 19mm [NAME] |  | 0 | 2 | pair
51440 | 19mm Chrome Centre Pillars |  | 0 | 1 | each
51440 |  |  | 0 | 0.9 | each
5-1445 | MOULDINGS
51445 | Mouldings |  | 0 | 3000 | item
51445 | Pine 290*19 |  | 0 | 11 | Lm
51445 | Pine  190*19 |  | 0 | 6.8 | Lm
51445 | Meranti 140*31 rebated [NAME] |  | 0 | 54 | 5.4L
51445 | [NAME] 140*31 Rebated |  | 0 | 7.9 | Lm
51445 | Pine FJ 140*19 |  | 0 | 4.2 | Lm
51445 | Pine FJ 140*11 |  | 0 | 3.5 | Lm
51445 | Pine FJ 116*19 [NAME] |  |  | 3.3 | Lm
51445 | Pine FJ 116*11 |  | 0 | 2.75 | Lm
51445 | Pine 90*90 dressed |  | 0 | 15 | Lm
51445 | Pine      93*42 dressed |  | 0 | 9 | Lm
51445 | Pine FJ 93*19 |  | 0 | 2.65 | Lm
51445 | Pine FJ 92*11 |  | 0 | 2.1 | Lm
51445 | Pine      68*42 dressed |  | 0 | 6 | Lm
51445 | Pine FJ 68*19 [NAME] skitrs |  | 300 | 2 | Lm
51445 | Pine FJ 68*11 |  | 0 | 1.65 | Lm
51445 | Pine FJ 42*11 |  | 0 | 1.05 | Lm
51445 | Pine FJ 30*30 |  | 0 | 2.09 | Lm
51445 | Pine FJ 31*19 |  | 0 | 1.1 | Lm
51445 | Pine FJ 30*11 stops |  |  | 0.8 | Lm
51445 | Pine FJ 18*18 |  | 0 | 0.75 | Lm
51445 | Pine FJ 19mm Quad |  | 0 | 0.96 | Lm
51445 | Pine FJ 42mm Cornice |  | 0 | 1.95 | Lm
51445 | Pine FJ 68*18 Heritage Colonial |  | 0 | 3.01 | Lm
51445 | Pine FJ 140*18 Heritage Colonial (min 6 /5.2) |  | 0 | 4.48 | Lm
51445 |  |  | 0 | 4.48 | Lm
51450 | INTERNAL PANELLING
51450 | VJ Pine 133*12 |  | 0 | 1.3 | Lm
51450 | 9mm VJ melimine 2400*1200 |  | 0 | 28 | each
51450 | 9mm VJ melimine 2700*1200 |  | 0 | 31 | each
51450 | 9mm VJ melimine 3000*1200 |  | 0 | 34 | each
51450 | [NAME] 9mm |  | 0 | 40 | sheet
52245 | CABINETMAKER |  | 1 | 19250 | PC
5-1480 | BALUSTRADING
52247 | Internal Balustrading (S & F) |  | 1 |  | PC
52247 | External Balustrading (S & F) INC Pool F |  | 1 |  | PC
51480 | Stainless Steel Wire 1/8 1*19 |  | 0 | 1.2 | Lm
51480 | Stainless Steel Thimbles 4mm |  | 0 | 0.55 | each
51480 | S/Steel Turnbuckles 5mm H/E |  | 0 | 6.5 | each
51480 | 8g x 11/4 Screws  (200) |  | 0 | 25 | box
51480 | M5 G304 Wire Rope Straps (saddles) |  | 0 | 0.9 | each
51480 | 3.2 Nickle Plated Copper Ferrules |  | 0 | 0.55 | each
51480 | [NAME] |  | 0 | 25 | day
51480 | Ladies Waist / Bread Loaf |  | 0 | 9.753 | Lm
51480 | [NAME] |  | 0 | 4.8 | Lm
51480 | Dressed HWD 42*31 |  | 0 | 2.4 | Lm
51480 | Dressed HWD 42*41 |  | 0 | 3 | Lm
51480 | LOSP  FJ Pine 42*19 |  | 0 | 1.9 | Lm
51420 | [NAME]
51420 | Tiles - Internal |  | 115 | 27 | m2
51420 | Tiles - External |  | 138 | 27 | m2
51420 | [NAME] |  | 80.89 | 27 | each
51420 | Stairs LM |  |  | 27 | each
51420 |  |  | 0 | 25 | each
52240 | TILER
52240 | 600x600 Wall Tiles |  |  |  | quote
52240 | 600x600 Floor internal Tiles |  |  | 55 | m2
52240 | 600X600 external Tiles |  |  | 50 | m2
52240 | 50[NAME] bedding |  |  | 50 | Lm
52240 | Skirting tiles |  | 30 | 15 | Lm
52240 | stair treads per face |  |  | 60 | lm
52240 | Angle |  | 20 | 20 | Lm
52240 | Mitres |  | 20 | 35 | Lm
52240 | Silicone |  | 50 | 6 | item
51220 |  |  | 0 | 14 | m2
51600 | SHOWER SCREENS/MIRRORS/POOL FENCING
51600 | Shower Screens
51600 | Bathroom D/S |  | 1 | 891 | each
51600 | Bathroom U/S |  | 1 | 891 | each
51600
51600 |  |  |  |  | lm
51600 | Mirrors
51600 | Bathroom D/S |  | 1 | 143 | each
51600 | Bathroom U/S |  | 1 | 137 | each
51600 | Ensuite mirror |  | 1 | 209 | each
51600 | Wardrobe Doors
51600 | Guest room mirror doors |  | 1 | 379.5 | each
51600 | Bed 2 mirror doors |  | 1 | 484 | each
51600 | Bed 3 mirror doors |  | 1 | 484 | each
51600 | Linen mirror doors |  | 1 | 434.5 | each
52243 | GARAGE DOORS
52243 | Panellife door w/ motor |  | 1 | 1465 | each
52243 | Sheeting of custom door |  | 0 | 0 | each
52243 | Hand Controller |  | 0 | 60 | each
52243 |  |  | 0 | 60 | each
52227 | CARPENTER PREPAINT
52227 | [NAME] |  | 220 | 42 | hour
52227 | Tradesperson |  | 0 | 38 | hour
52227 | Apprentice |  | 0 | 22 | hour
52227 | apprentice |  | 210 | 16.45 | hour
 | Prepaint Totals
NOTES
1