{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["BIll 1 General","Bill 2 AC","Summary"],"not_rendered":{"external_links":1,"defined_names":6},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"BIll 1 General","index":0,"n_rows":120,"n_cols":19,"rows_kept":120,"merged":[[5,6,5,8],[5,11,5,13],[5,16,5,18],[6,6,6,8],[6,11,6,13],[6,16,6,18]],"flags":["formulas_cached_only"]}
[null,"SECTION 10"]
[]
[null,"PROTEA FLATS"]
[null,"HEATING VENTILATION AND AIR CONDITIONING INSTALLATION"]
[]
[null,"PROVISIONAL SCHEDULE OF QUANTITIES ",{"$nulls":9},"CLAIM 1",{"$nulls":4},"CLAIM 2"]
[{"$nulls":11},"CLIMATE CONTROL",{"$nulls":4},"CLIMATE CONTROL"]
[null,"ITEM","DESCRIPTION","UNIT",null,"QTY","SUPPLY RATE","INSTALL RATE","AMOUNT",null,"QTY","SUPPLY RATE","INSTALL RATE","AMOUNT",null,"QTY","SUPPLY RATE","INSTALL RATE","AMOUNT"]
[]
[null,null,"Bill No. 1 : Preliminary and General"]
[]
[null,"1.1","Compliance with General Conditions of Contract : Insurances, Sureties, etc as outlined in the Principal Contractor's Preliminaries."]
[]
[null,null,"Fixed","Item",null,1,{"$nulls":5},0,null,0,null,null,0,null,0]
[null,null,"Value Related","Item",null,1,{"$nulls":5},{"v":2312.5,"d":"2,312.50"},{"v":690,"d":"690.00"},0,null,{"v":1,"d":"1.00"},{"v":2312.5,"d":"2,312.50"},{"v":690,"d":"690.00"},{"v":3002.5,"d":"3,002.50"}]
[null,null,"Time Related","Item",null,1,{"$nulls":7},0,{"$nulls":4},0]
[]
[null,1.2,"Establish on Site and provision of buildings and storage facilities including de-establishment of site, cleaning and tidying up after completion of contract"]
[]
[null,null,"Fixed","Item",null,1,{"$nulls":5},0,null,0,null,null,0,null,0]
[null,null,"Value Related","Item",null,1,{"$nulls":5},0,null,0,null,null,0,null,0]
[null,null,"Time Related","Item",null,1,{"$nulls":5},{"v":312.5,"d":"312.50"},{"v":4600,"d":"4,600.00"},0,null,null,{"v":312.5,"d":"312.50"},{"v":4600,"d":"4,600.00"},0]
[]
[null,1.3,"Tools and equipment, Communication, transport."]
[]
[null,null,"Fixed","Item",null,1,{"$nulls":5},{"v":312.5,"d":"312.50"},{"v":2760,"d":"2,760.00"},0,null,{"v":0.4,"d":"0.40"},{"v":312.5,"d":"312.50"},{"v":2760,"d":"2,760.00"},{"v":1250,"d":"1,250.00"}]
[null,null,"Value Related","Item",null,1,{"$nulls":5},0,null,0,null,null,0,null,0]
[null,null,"Time Related","Item",null,1,{"$nulls":5},{"v":13650,"d":"13,650.00"},{"v":5520,"d":"5,520.00"},0,null,{"v":0.4,"d":"0.40"},{"v":13650,"d":"13,650.00"},{"v":5520,"d":"5,520.00"},{"v":8500,"d":"8,500.00"}]
[]
[null,"1.4","Contract Management, Company overheads and supervision of the Works including attendance of site meetings (2 per month)"]
[]
[null,null,"Fixed","Item",null,1,{"$nulls":7},0,{"$nulls":4},0]
[null,null,"Value Related","Item",null,1,{"$nulls":7},0,{"$nulls":4},0]
[null,null,"Time Related","Item",null,1,{"$nulls":5},{"v":1562.5,"d":"1,562.50"},{"v":11040,"d":"11,040.00"},0,null,0.35,{"v":1562.5,"d":"1,562.50"},{"v":11040,"d":"11,040.00"},{"v":4560,"d":"4,560.00"}]
[]
[null,1.5,"Provision of all drawings and manuals as specified including As-Installed drawings","Item",null,1,{"$nulls":5},{"v":1062.5,"d":"1,062.50"},{"v":1610,"d":"1,610.00"},0,null,null,{"v":1062.5,"d":"1,062.50"},{"v":1610,"d":"1,610.00"},0]
{"$rows_empty":26}
[null,null,"Total Carried forward to Next Page",{"$nulls":10},0,{"$nulls":4},{"v":17312.5,"d":"17,312.50"}]
[]
[null,null,"Total Carried forward From Previous Page",{"$nulls":10},0,{"$nulls":4},{"v":17312.5,"d":"17,312.50"}]
[]
[null,1.6,"Liaison with Local Supply Authority, compliance with OSH Act, Local By-laws and any other statutory regulations ","Item",null,1,{"$nulls":5},{"v":6160,"d":"6,160.00"},{"v":1150,"d":"1,150.00"},0,null,{"v":1,"d":"1.00"},{"v":6160,"d":"6,160.00"},{"v":1150,"d":"1,150.00"},{"v":7310,"d":"7,310.00"}]
[]
[null,1.7,"Any additional item not specifically mentioned or included in the Bills of Quantities which the Tenderer may wish to detail. (Specify)","Item",null,1,{"$nulls":5},{"v":1732.5,"d":"1,732.50"},{"v":16932.6,"d":"16,932.60"},0,null,null,{"v":1732.5,"d":"1,732.50"},{"v":16932.6,"d":"16,932.60"},0]
[]
[null,1.8,"Additional testing and balancing at discression of the mechanical engineer.","Item",null,1,{"$nulls":5},0,{"v":3680,"d":"3,680.00"},0,null,null,0,{"v":3680,"d":"3,680.00"},0]
{"$rows_empty":48}
[null,null,"Total Carried forward to Summary Page",{"$nulls":5},0,{"$nulls":4},0,{"$nulls":4},{"v":24622.5,"d":"24,622.50"}]

{"sheet":"Bill 2 AC","index":1,"n_rows":117,"n_cols":8,"rows_kept":117,"merged":[[6,5,6,7]],"flags":["formulas_cached_only"]}
[null,"SECTION 10"]
[]
[null,"PROTEA FLATS"]
[null,"HEATING VENTILATION AND AIR CONDITIONING INSTALLATION"]
[]
[null,"PROVISIONAL SCHEDULE OF QUANTITIES "]
[]
[null,"ITEM","DESCRIPTION","UNIT","QTY","SUPPLY RATE","INSTALL RATE","AMOUNT"]
[null,{"v":2,"d":"2.0"},"Bill No. 2 : Air Conditioning Equipment "]
[]
[null,null,"Inverter Split Units"]
[null,null,"Supply and Install:"]
[]
[null,2.1,"AC 1 - Inverter mid wall split unit, 2,8 kW cooling / heating output, single phase. ","No.",3]
[]
[null,2.2,"AC 2 - Inverter mid wall split unit, 3,5 kW cooling / heating output, single phase. ","No.",3]
[]
[null,2.3,"AC 3 - Inverter ceiling cassette split unit, 5,6 kW cooling / heating output, single phase. ","No.",2]
[]
[null,2.4,"AC 4 - Inverter ceiling cassette split unit, 9 kW cooling / heating output, single phase. ","No.",1]
[]
[null,null,"Corrosion Treatment"]
[]
[null,2.5,"Chemical oxidization treatment to 2,8 kW unit condenser coils, panels & circuit boards.","No.",3]
[]
[null,2.6,"Chemical oxidization treatment to 3,5 kW unit condenser coils, panels & circuit boards.","No.",3]
[]
[null,2.7,"Chemical oxidization treatment to 5,6 kW unit condenser coils, panels & circuit boards.","No.",2]
[]
[null,2.8,"Chemical oxidization treatment to 9 kW unit condenser coils, panels & circuit boards.","No.",1]
[]
[null,null,"Refrigerant Piping"]
[]
[null,null,"Supply, Install, test, commission and provide 12 month guarantee for send and return refrigerant piping for the entire installation, including thermaflex insulation, hangers, brackets and etc."]
[]
[null,2.9,"6.4 mm","m",101]
[]
[null,{"v":2.1,"d":"2.10"},"9.5 mm","m",64]
[]
[null,2.11,"12,7 mm","m",46]
[]
[null,2.12,"15.9 mm","m",15]
[]
[null,2.13,"R410A extra refrigerant charge","kg","Sum"]
[]
[null,null,"Electrical "]
[]
[null,2.14,"Connection of AC unit to external isolator provided by others","No.",9]
[null,null,"Condensate Pump"]
[]
[null,2.15,"Corner, in trunking type, condensate pump.","No",6]
{"$rows_empty":9}
[null,null,"Total Carried forward to Next Page"]
[]
[null,null,"Total Carried forward From Previous Page"]
[]
[null,null,"Condensate Piping"]
[]
[null,2.16,"6 mm diameter clear plastic condensate drain pipe.","m",6]
[]
[null,2.17,"20 mm diameter PVC condensate drain pipe, incl. all unions, elbows, hangers and brackets.","m",50]
[]
[null,2.18,"40 mm diameter PVC condensate drain pipe, incl. all unions, elbows, hangers and brackets.","m",50]
[]
[null,null,"Trunking"]
[]
[null,2.19,"Cab-strut white PVC trunking incl. covers, elbow, bends and etc or similar approved.","m",5]
[]
[null,null,"Wire Basket"]
[]
[null,{"v":2.2,"d":"2.20"},"Wire basket 150 mm wide x 1 mm thick light duty hot dipped galvanised cable tray, wire mesh, c/w hanger channel, elbows, bends, and etc or similar approved.","m",50]
[]
[null,null,"Infra Red Remotes"]
[]
[null,2.21,"Supply, Install, test, commission and provide 12 month guarantee for remote control, in positions shown.","No",1]
[]
[null,null,"Coring Through Brickwork"]
[]
[null,2.22,"Core through 220 mm brick work, 100 mm diam core.","No",9]
[]
[null,null,"12 Month Service Plan"]
[]
[null,2.23,"Supply 12 month service plan, for each unit, consisting of 3 quarterly minor services, and 1 final major service at 12 months from Practical Completion","No",9]
[]
[null,null,"Training of Staff"]
[]
[null,2.24,"Training of staff on operation of units; ; location of equipment and basic day to day maintenance.","No",3]
{"$rows_empty":21}
[null,null,"Total Carried forward to Summary Page"]

{"sheet":"Summary","index":2,"n_rows":53,"n_cols":6,"rows_kept":53,"merged":[[13,2,13,3],[50,1,50,3],[51,1,51,3],[52,1,52,3]],"flags":["formulas_cached_only"]}
[null,"SECTION 10"]
[]
[null,"PROTEA FLATS"]
[null,"HEATING VENTILATION AND AIR CONDITIONING INSTALLATION"]
[]
[null,"PROVISIONAL SCHEDULE OF QUANTITIES "]
[]
[null,"BILL NO.","DESCRIPTION",null,null,"AMOUNT"]
[]
[null,1,"Bill No. 1 : Preliminary and General"]
[]
[null,2,"Bill No. 2 : Air Conditioning Equipment "]
{"$rows_empty":38}
[null,"SUBTOTAL EXCLUDING VAT @ 15%"]
[null,"MAIN CONTRACTOR'S PROFIT AND ATTENDANCE"]
[null,"TOTAL (EXCLUDING VAT) CARRIED OVER TO SECTION 10 ON FINAL SUMMARY OF PAGE BOQ 345"]