{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Cover Page","Summary","Preliminaries","Provisional Amounts","Ducting","Piping & Fitting","Equipment","Terminals","VRF"],"not_rendered":{"images":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":27,"n_cols":4,"rows_kept":27,"merged":[[0,0,12,4],[13,0,13,4],[23,0,23,4],[25,0,25,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3]]}
{"$rows_empty":13}
["PRICING SUBMISSION"]
[]
[]
["RFP NO:",null,null,"RFP NO. 9501/16/04/2025"]
[]
["RFP NAME:",null,null,"\tProcurement and installation of an HVAC system and replacement of the BMS System at the CSIR ICC for a period of three (3) years."]
[]
["BIDDER NAME"]
[]
[]
[]
["Intructions: "]
["Kindly furnish comprehensive pricing details in accordance with the outlined Bill of Quantity in Annexure D. It is imperative that the provided pricing strictly adheres to the \nPricing Schedule. Any deviation from this guideline will lead to disqualification, as it could \nrender the bid non-responsive"]
["All tendered amounts must include Preliminaries and Generals (P&G)"]

{"sheet":"Summary","index":1,"n_rows":29,"n_cols":7,"rows_kept":29,"merged":[[0,0,0,6],[1,1,1,3],[2,1,2,3],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[24,1,24,5],[25,1,25,5],[26,1,26,5],[27,1,27,5]]}
[]
["PROJECT:","\tProcurement and installation of an HVAC system and replacement of the BMS System at the CSIR ICC for a period of three (3) years"]
["RFP No. ","RFP NO. 9501/16/04/2025"]
[]
[null,"CONSTRUCTION BILL",{"$nulls":4},"Appointment "]
[null,"Scope:",{"$nulls":4},"Value (incl. P&G's)"]
[null,"Preliminaries",{"$nulls":4},{"$f":"Preliminaries!G42","v":0}]
[null,"Provisional Amounts",{"$nulls":4},{"$f":"'Provisional Amounts'!G58","v":{"v":10000000,"d":"R 10,000,000.00"}}]
[null,"Ducting",{"$nulls":4},{"$f":"Ducting!G48","v":0}]
[null,"Piping and Fittings",{"$nulls":4},{"$f":"'Piping & Fitting'!G142","v":0}]
[null,"Equipment",{"$nulls":4},{"$f":"Equipment!G138","v":0}]
[null,"Terminals",{"$nulls":4},{"$f":"Terminals!G65","v":0}]
[null,"VRF",{"$nulls":4},{"$f":"VRF!G102","v":0}]
{"$rows_empty":10}
[null,"Sub Total (excluding VAT and Contingencies)"]
[null,"Project contingencies at 20%"]
[null,"Sub Total (excluding VAT)"]
[null,"VAT @15.5%"]
[null,"Sub total"]
[{"$nulls":6},{"$f":"SUM(G7:G28)","v":{"v":10000000,"d":"R 10,000,000.00"}}]

{"sheet":"Preliminaries","index":2,"n_rows":42,"n_cols":7,"rows_kept":42,"merged":[[0,1,0,3],[1,1,1,3]]}
["PROJECT:","\tProcurement and installation of an HVAC system and replacement of the BMS System at the CSIR ICC for a period of three (3) years"]
["RFP No. ","RFP NO. 9501/16/04/2025"]
[]
[null,"Page/Item","Bill description","Unit","Quantity","Tender Rate","Value"]
[null,"PL","Preliminaries","",null,"",""]
[]
[null,"Pl1","Drawings, Submissions and Detailed Engineering","No",{"v":1,"d":"1.00"},null,{"$f":"F7*E7","v":0}]
[null,"Pl2","Work provided by Others","No",{"v":1,"d":"1.00"},null,{"$f":"F8*E8","v":0}]
[null,"Pl3","Delivery of material, equipment and ducting to site","No",{"v":1,"d":"1.00"},null,{"$f":"F9*E9","v":0}]
[null,"Pl4","High level access for installation and commissioning ","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl5","Compliance with Standards and Regulations","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl6","Health and Safety Requirements, including all medicals and Working on Heights Training","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl7","Statutory Certifications (Electrical and Refrigeration)"]
[null,"Pl8","Scaffolding","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl9","Programming","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl10","Contract Management","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl11","Organization and Management of Subcontractors","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl12","Allowance for Generator Power During Construction"]
[null,"Pl13","Protection Against Damage","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl14","Access to Equipment and Systems","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl15","Cleaning and Start-up","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl16","Pre-commissioning of Equipment Before Change-over"]
[null,"Pl17","Testing, Balancing, Commissioning, Operation of Plant and Handover after Final Change-Over","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl18","Allow for training and certification of client selected personnel. As per the specification.","No",{"v":1,"d":"1.00"},null,{"$f":"F24*E24","v":0}]
[null,"Pl19","Construction Guarantee & Insurances","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl20","Payment Guarantees on Imported Capital Plant","No",{"v":1,"d":"1.00"},null,{"$f":"F26*E26","v":0}]
[null,"Pl21","Quality Management System, Testing and Inspection","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl22","Operating and Maintenance Manuals","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl23","Two Year's Maintenance","No",{"v":1,"d":"1.00"},null,{"$f":"I31","v":0}]
[null,"Pl24","Special Attendance","No",{"v":1,"d":"1.00"},null,0]
[null,"Project contingencies at 20%","Preparation of Pre-Start up Procedures","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl26","Completion of Subcontract work","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl27","Building Tuning","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl28","Environmental Management, Houskeeping and Waste Disposal","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl29","Water Management","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl30","Air Tightness Testing","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl31","Travelling and Accommodation","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl32","Site Establishment","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl33","As-Built Drawings","No",{"v":1,"d":"1.00"},null,0]
[null,"Pl34","End of Warrantee Handover","No",{"v":1,"d":"1.00"},null,{"$f":"F40*E40","v":0}]
[null,null,"",""]
[{"$nulls":6},{"$f":"SUM(G5:G41)","v":0}]

{"sheet":"Provisional Amounts","index":3,"n_rows":58,"n_cols":7,"rows_kept":58,"merged":[[0,1,0,3],[1,1,1,3]]}
["PROJECT:","\tProcurement and installation of an HVAC system and replacement of the BMS System at the CSIR ICC for a period of three (3) years"]
["RFP No. ","RFP NO. 9501/16/04/2025"]
[]
[null,"Page/Item","Bill description","Unit","Quantity","Tender Rate","Value"]
[null,"PA","Provisional Amounts","",null,"",""]
[]
[null,"PA1","Controls and Electrical Complete (R 1500 000.00)","No",{"v":1,"d":"1.00"},{"v":1500000,"d":"R1,500,000.00"},{"$f":"F7*E7","v":{"v":1500000,"d":"R1,500,000.00"}}]
[null,null,"- Central Plant Manager (Carrel PCO5 or Similar) incl. all wiring, sensors and reticulation"]
[null,null,"- AHU Controller (Carrel PCO5 or Similar) incl. all wiring, sensors and reticulation"]
[null,null,"- Programming of all controllers"]
[null,null,"- CO2 Monitoring on all AHU's"]
[null,null,"- Main Chiller Plant MCC"]
[null,null,"- Reticulation from main MCC to all equipment including Ice Storage and Hot Water Plant (valves, motorised dampers, pumps, AHU's, chillers, fans, VSD's, etc)"]
[null,"PA2","Supply,  installation and commissioning of new electrical feeds to the HVAC systems including, circuit breakers, modifications to existing distribution boards, cabling, cable trays, new distribution boards and issuing if certificate of compliances.  (R 1500 000.00)","No",{"v":1,"d":"1.00"},{"v":1500000,"d":"R1,500,000.00"},{"$f":"F14*E14","v":{"v":1500000,"d":"R1,500,000.00"}}]
[null,"PA3","Allowance for coil treatment (Chillers, Ahus's and VRF)  (R 100 000.00)","No",{"v":1,"d":"1.00"},{"v":100000,"d":"R100,000.00"},{"$f":"F15*E15","v":{"v":100000,"d":"R100,000.00"}}]
[null,"PA4","Builders Work  (R 2 000 000.00)","No",{"v":1,"d":"1.00"},{"v":2000000,"d":"R2,000,000.00"},{"$f":"F16*E16","v":{"v":2000000,"d":"R2,000,000.00"}}]
[null,null,"- Special Supports in Plantrooms for Piping"]
[null,null,"- Specialised Plinths"]
[null,null,"- Water Proofing"]
[null,null,"- Ceiling alterations"]
[null,null,"- Removal and reinstallation of aluminium doors for equipment access"]
[null,null,"- Plumbing alterations and additions"]
[null,null,"- Wall penetrations and making good"]
[null,"PA5","Allowance for Phased Rigging  (R 400 000.00)","No",{"v":1,"d":"1.00"},{"v":400000,"d":"R400,000.00"},{"$f":"F24*E24","v":{"v":400000,"d":"R400,000.00"}}]
[null,"PA6","Removal of Existing  (R 400 000.00)","No",{"v":1,"d":"1.00"},{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"}]
[null,null,"- De-commisssioning of all equipment"]
[null,null,"- Stripout of exisitng equipment (chillers, AHU's, piping, ducting, cabling, etc.)"]
[null,null,"- Removal and safe disposal of all equipment and materials"]
[null,"PA7","BMS  (R 1 000 000.00)","No",{"v":1,"d":"1.00"},{"v":1000000,"d":"R1,000,000.00"},{"v":1000000,"d":"R1,000,000.00"}]
[null,"PA8","Allow for camera inspection of all existing ducting  (R 400 000.00)","No",{"v":1,"d":"1.00"},{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"}]
[null,"Project contingencies at 20%","Connection to existing ducting (10-off)  (R 300 000.00)","No",{"v":1,"d":"1.00"},{"v":300000,"d":"R300,000.00"},{"v":300000,"d":"R300,000.00"}]
[null,"PA10","Re-Commissioning and Re-Balancing of Existing  (R 500 000.00)","No",{"v":1,"d":"1.00"},{"v":500000,"d":"R500,000.00"},{"$f":"F32*E32","v":{"v":500000,"d":"R500,000.00"}}]
[null,"PA11","Forward Cover on Imported Equipment  (R 500 000.00)","No",{"v":1,"d":"1.00"},{"v":500000,"d":"R500,000.00"},{"v":500000,"d":"R500,000.00"}]
[null,"PA12","Continuous colour coding lines for all piping  (R 200 000.00)","No",{"v":1,"d":"1.00"},{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"}]
[null,"PA13","Relocation of existing split condensing units  (R 200 000.00)","No",{"v":1,"d":"1.00"},{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"}]
[null,"PA14","Specialist fire sealant in fire rated partitions   (R 500 000.00)","No",{"v":1,"d":"1.00"},{"v":500000,"d":"R500,000.00"},{"v":500000,"d":"R500,000.00"}]
[null,"PA15","Structural steelworks  (R 500 000.00)","No",{"v":1,"d":"1.00"},{"v":500000,"d":"R500,000.00"},{"v":500000,"d":"R500,000.00"}]
{"$rows_empty":19}
[null,null,"",""]
[{"$nulls":6},{"$f":"SUM(G5:G57)","v":{"v":10000000,"d":"R10,000,000.00"}}]

{"sheet":"Ducting","index":4,"n_rows":48,"n_cols":7,"rows_kept":48,"merged":[[0,1,0,3],[1,1,1,3]]}
["PROJECT:","\tProcurement and installation of an HVAC system and replacement of the BMS System at the CSIR ICC for a period of three (3) years"]
["RFP No. ","RFP NO. 9501/16/04/2025"]
[]
[null,"Page/Item","Bill description","Unit","Quantity","Tender Rate","Value"]
[null,"A","Ducting",null,null,"",""]
[null,"A1","Price to include for low pressure galvanised ducting including 50mm Sonic Liner, installation and labour, c/w all fixing and supports"]
[null,"A1.1","Insulated Straight Ducting"]
[null,"A1.1.1","Category 1 - Ducting with a width or height < 750mm and semi-perimeter < 1150mm","m²",{"$f":"230*1.1","v":{"v":253.00000000000003,"d":"253"}},null,{"$f":"F8*E8","v":0}]
[null,"A1.1.2","Category 2 - Ducting with a width or height < 750mm and semi-perimeter > 1150mm","m²",{"$f":"96*1.1","v":{"v":105.60000000000001,"d":"106"}},null,{"$f":"F9*E9","v":0}]
[null,"A1.1.3","Category 3 - Ducting with longest side between 751mm and 1350mm","m²",{"$f":"233*1.1","v":{"v":256.3,"d":"256"}},null,0]
[null,"A1.1.4","Category 4 - Ducting with longest side between 1351mm and 2000mm","m²",{"$f":"361*1.1","v":{"v":397.1,"d":"397"}},null,0]
[null,"A1.1.6","Category 6 - Re-inforced Spiral Ducting"]
[null,"A1.2.6.1","- dia 150mm","m²",{"$f":"(9.84*1.1)*PI()*0.15","v":{"v":5.1006898323683885,"d":"5"}},null,{"$f":"F13*E13","v":0}]
[]
[null,"A1.2","Insulated Transformations and Bends"]
[null,"A1.2.1","Category 1 - Ducting with a width or height > 750mm and semi-perimeter < 1150mm","m²",{"$f":"32*1.1","v":{"v":35.2,"d":"35"}},null,{"$f":"F16*E16","v":0}]
[null,"A1.2.2","Category 2 - Ducting with a width or height > 750mm and semi-perimeter > 1150mm","m²",{"$f":"15*1.1","v":{"v":16.5,"d":"17"}},null,0]
[null,"A1.2.3","Category 3 - Ducting with longest side between 750mm and 1350mm","m²",{"$f":"75*1.1","v":{"v":82.5,"d":"83"}},null,0]
[null,"A1.2.4","Category 4 - Ducting with longest side between 1351mm and 2000mm","m²",{"$f":"68*1.1","v":{"v":74.80000000000001,"d":"75"}},null,0]
[]
[null,"A1.3","Insulated Straight Ducting"]
[null,"A3","Price to include for 50mm Sonic Liner c/w installation and labour"]
[null,"A1.3.1","Category 1 - Ducting with a width or height < 750mm and semi-perimeter < 1150mm","m²",{"$f":"230*1.1","v":{"v":253.00000000000003,"d":"253"}},null,{"$f":"F23*E23","v":0}]
[null,"A1.3.2","Category 2 - Ducting with a width or height < 750mm and semi-perimeter > 1150mm","m²",{"$f":"96*1.1","v":{"v":105.60000000000001,"d":"106"}},null,{"$f":"F24*E24","v":0}]
[null,"A1.3.3","Category 3 - Ducting with longest side between 751mm and 1350mm","m²",{"$f":"233*1.1","v":{"v":256.3,"d":"256"}},null,0]
[null,"A1.3.4","Category 4 - Ducting with longest side between 1351mm and 2000mm","m²",{"$f":"361*1.1","v":{"v":397.1,"d":"397"}},null,0]
[null,"A1.3.6","Category 6 - Re-inforced Spiral Ducting"]
[null,"A1.3.6.1","- dia 150mm","m²",{"$f":"(9.84*1.1)*PI()*0.15","v":{"v":5.1006898323683885,"d":"5"}},null,{"$f":"F28*E28","v":0}]
[]
[]
[null,"Project contingencies at 20%"]
{"$rows_empty":15}
[null,null,"",""]
[{"$nulls":6},{"$f":"SUM(G5:G47)","v":0}]

{"sheet":"Piping & Fitting","index":5,"n_rows":142,"n_cols":7,"rows_kept":142,"merged":[[0,1,0,3],[1,1,1,3],[5,8,5,9]]}
["PROJECT:","\tProcurement and installation of an HVAC system and replacement of the BMS System at the CSIR ICC for a period of three (3) years"]
["RFP No. ","RFP NO. 9501/16/04/2025"]
[]
[null,"Page/Item","Bill description","Unit","Quantity","Tender Rate","Value"]
[null,"A","CHW Piping and Fittings",""]
[null,"A1","Straight chilled water piping including brackets supported ",""]
[null,"A1.1","Black steel chilled water piping including painting (primer and final coat), insulation and all pipe supports ",""]
[null,"A1.1.1","NB 150, Medium Black Steel ","m",518,null,{"$f":"F8*E8","v":0}]
[null,"A1.1.2","NB 100, Medium Black Steel ","m",267,null,{"$f":"F9*E9","v":0}]
[null,"A1.1.3","NB 80, Medium Black Steel","m",21,null,0]
[null,"A1.1.4","NB 65, Medium Black Steel","m",180,null,0]
[null,"A1.1.5","NB 50, Medium Black Steel","m",54,null,0]
[null,"A1.1.6","NB 32, Medium Black Steel","m",30,null,0]
[null,"A1.1.7","NB 25, Medium Black Steel","m",30,null,0]
[null,null,"Chilled Water Cladding",""]
[null,null,"Galvanised Cladding c/w strapping and installation",""]
[null,"A1.1.8","NB 150, Medium Black Steel ","m",{"v":466.2,"d":"466"},null,{"$f":"F17*E17","v":0}]
[null,"A1.1.9","NB 100, Medium Black Steel ","m",{"v":240.3,"d":"240"},null,{"$f":"F18*E18","v":0}]
[null,"A1.1.10","NB 80, Medium Black Steel","m",{"v":18.900000000000002,"d":"19"},null,0]
[null,"A1.1.11","NB 65, Medium Black Steel","m",162,null,0]
[null,"A1.1.12","NB 50, Medium Black Steel","m",{"$f":"49+80","v":129},null,0]
[null,"A1.1.13","NB 32, Medium Black Steel","m",{"$f":"27+50","v":77},null,0]
[null,"A1.1.14","NB 25, Medium Black Steel","m",{"$f":"27+50","v":77},null,0]
[{"$nulls":3},""]
[null,"A2","Pair Flanges c/w bolts, washers and nuts",""]
[null,"A2.1","Black steel chilled water flanges including painting (primer and final coat) and insulation ",""]
[null,"A2.1.1","NB 150, Medium Black Steel","No",{"$f":"E73+E83+E88+E92+E121+E131","v":55},null,{"$f":"F27*E27","v":0}]
[null,"A2.1.2","NB 125, Medium Black Steel","No",{"$f":"E87+E120","v":6},null,0]
[null,"A2.1.3","NB 100, Medium Black Steel","No",{"$f":"E72+E82+E119+E130","v":38},null,0]
[null,"A2.1.4","NB 80, Medium Black Steel","No",{"$f":"E71+E81+E118+E129","v":23},null,0]
[null,"Project contingencies at 20%",null,""]
[null,"A3","Chilled Water Elbows with",""]
[null,"A3.1","Black steel chilled water bends including painting (primer and final coat) and insulation ",""]
[null,"A3.1.1","90° Elbow NB 150, Medium Black Steel","No",82,null,{"$f":"F34*E34","v":0}]
[null,"A3.1.2","90° Elbow NB 100, Medium Black Steel","No",73,null,0]
[null,"A3.1.3","90° Elbow NB 80, Medium Black Steel","No",14,null,0]
[null,"A3.1.4","90° Elbow NB 65, Medium Black Steel","No",71,null,0]
[null,"A3.1.5","90° Elbow NB 50, Medium Black Steel","No",{"$f":"47+10","v":57},null,0]
[null,"A3.1.6","90° Elbow NB 32, Medium Black Steel","No",{"$f":"3+10","v":13},null,0]
[{"$nulls":3},""]
[null,"A4","Chilled Water Eccentric Reducers with",""]
[null,"A4.1","Black steel chilled water reducers including painting (primer and final coat) and insulation ",""]
[null,"A4.1.1","Red. NB 110 - 65, Medium Black Steel","No",2,null,{"$f":"F43*E43","v":0}]
[null,"A4.1.2","Red. NB 150 - 100, Medium Black Steel","No",4,null,0]
[null,"A4.1.3","Red. NB 200 - 150, Medium Black Steel","No",4,null,0]
[null,"A4.1.4","Red. NB 25 - 20, Medium Black Steel","No",4,null,0]
[null,"A4.1.5","Red. NB 50 - 32, Medium Black Steel","No",1,null,0]
[null,"A4.1.6","Red. NB 50 - 40, Medium Black Steel","No",8,null,0]
[null,"A4.1.7","Red. NB 80 - 50, Medium Black Steel","No",8,null,0]
[]
[null,"A5","Chilled Water Equal Tees ",""]
[null,"A5.1","Black steel chilled water tees including painting (primer and final coat) and insulation ",""]
[null,"A5.1.1","Equal Tee NB 150, Medium Black Steel","No",29,null,{"$f":"F53*E53","v":0}]
[null,"A5.1.2","Equal Tee NB 100, Medium Black Steel","No",6,null,0]
[null,"A5.1.3","Equal Tee NB 80, Medium Black Steel","No",4,null,0]
[null,"A5.1.4","Equal Tee NB 50, Medium Black Steel","No",4,null,0]
[{"$nulls":3},""]
[null,"A6","Chilled Water Reducing Tees/Tie Ins",""]
[null,"A6.1","Black steel chilled water tees including painting (primer and final coat) and insulation ",""]
[null,"A6.1.2","NB 150, 150, 100 Medium Black Steel ","No",9,null,{"$f":"F60*E60","v":0}]
[{"$nulls":3},""]
[null,"A7","Chilled Water Stub Take-offs with NB > 50mm ",""]
[null,"A7.1","Black steel chilled water tees including painting (primer and final coat) and insulation ",""]
[null,"A7.2","NB 20 Medium Black Steel ","No",2,null,{"$f":"F64*E64","v":0}]
[null,"A7.3","NB 80 Medium Black Steel ","No",2,null,0]
[null,"A7.4","NB 65 Medium Black Steel ","No",26,null,0]
[null,"A7.5","NB 50 Medium Black Steel ","No",14,null,0]
[null,"A7.6","NB 25 Medium Black Steel ","No",7,null,0]
[{"$nulls":3},""]
[null,"A8","Chilled Water Non return Valves"]
[null,"A8.1","NB 80","No",2,null,{"$f":"F71*E71","v":0}]
[null,"A8.2","NB 100","No",4,null,0]
[null,"A8.3","NB 150","No",6,null,0]
[]
[null,"A9","Chilled Water strainers"]
[null,"A9.1","NB 20","No.",1,null,{"$f":"F76*E76","v":0}]
[null,"A9.2","NB 32","No.",6,null,{"$f":"F77*E77","v":0}]
[null,"A9.3","NB 40","No.",3,null,0]
[null,"A9.4","NB 50","No.",3,null,0]
[null,"A9.5","NB 65","No.",6,null,0]
[null,"A9.6","NB 80","No",3,null,0]
[null,"A9.7","NB 100","No",{"$f":"E83*2","v":12},null,0]
[null,"A9.8","NB 150","No",6,null,0]
[]
[null,"A10","Chilled Water Balancing Valve"]
[null,"A10.1","Balancing Valve supplied and installed"]
[null,"A10.1.1","NB 125","No",2,null,{"$f":"F87*E87","v":0}]
[null,"A10.1.2","NB 150","No",1,null,0]
[]
[null,"A11","Chilled Water 3-Way Open/Close Valve"]
[null,"A11.1","3-Way Valve supplied and installed"]
[null,"A11.1.1","NB 150","No",1,null,{"$f":"F92*E92","v":0}]
[]
[null,"A12","Chilled Water Instruments"]
[null,"A12.1","Pressure gauge, c/w gauge tube and gauge cock ","No",54,null,{"$f":"F95*E95","v":0}]
[null,"A12.2","Thermometer","No",{"$f":"32+20+20","v":72},null,0]
[null,"A12.3","Binder test points","No",{"$f":"54+30+30","v":114},null,0]
[null,"A12.4","Chilled water flow switch","No",12,null,0]
[]
[null,"A13","Chilled Water Auto Air Vents ",""]
[null,"A13.1","NB 15","No",16,null,{"$f":"F101*E101","v":0}]
[]
[null,"A14","Chilled Water Drain Cock",""]
[null,"A14.1","NB 25","No",10,null,{"$f":"F104*E104","v":0}]
[]
[null,"A15","Pressure Relief Valve"]
[null,"A15.1","NB 25","No",1,null,{"$f":"F107*E107","v":0}]
[]
[null,"A16","Chilled Water Sockets for mounting sensors",""]
[null,"A16.1","NB 25","No",{"$f":"SUM(E95:E109)","v":279},null,{"$f":"F110*E110","v":0}]
[]
[null,"A17","Chilled Water Isolating Valves"]
[null,"A17.1","Shut-off valve NB 20, Ball Valve","No.",{"$f":"2+3","v":5},null,{"$f":"F113*E113","v":0}]
[null,"A17.2","Shut-off valve NB 32, Ball Valve","No.",{"$f":"12+2","v":14},null,{"$f":"F114*E114","v":0}]
[null,"A17.3","Shut-off valve NB 40, Ball Valve","No.",6,null,0]
[null,"A17.4","Shut-off valve NB 50, Ball Valve","No.",6,null,0]
[null,"A17.5","Shut-off valve NB 65, Ball Valve","No.",12,null,0]
[null,"A17.6","Shut-off valve NB 80, Cast Iron Butterfly","No",{"$f":"8+2","v":10},null,0]
[null,"A17.7","Shut-off valve NB 100, Cast Iron Butterfly","No",16,null,0]
[null,"A17.8","Shut-off valve NB 125, Cast Iron Butterfly","No",4,null,0]
[null,"A17.9","Shut-off valve NB 150, Cast Iron Butterfly","No",27,null,0]
[]
[null,"A18","Chilled Water Flexible Pipe Connections (Bell house)"]
[null,"A18.1","NB 20","No.",4,null,{"$f":"F124*E124","v":0}]
[null,"A18.2","NB 32","No",24,null,{"$f":"F125*E125","v":0}]
[null,"A18.3","NB 40","No",12,null,0]
[null,"A18.4","NB 50","No",12,null,0]
[null,"A18.5","NB 65","No",24,null,0]
[null,"A18.6","NB 80 flexible pipe connection, flanged connection","No",{"$f":"4+4","v":8},null,{"$f":"F129*E129","v":0}]
[null,"A18.7","NB 100 flexible pipe connection, flanged connection","No",6,null,0]
[null,"A18.8","NB 150 flexible pipe connection, flanged connection","No",14,null,0]
[]
[null,"A19","Water Treatment ",""]
[null,"A19.1","Automated Water Treatment c/w Valves and Connection pipes for chilled water, incl. (10000 L)","Lot",1,null,{"$f":"F134*E134","v":0}]
[null,"A19.2","Automated Water Treatment c/w Valves and Connection pipes for hot water, incl. (42000L)","Lot",1,null,0]
[{"$nulls":3},""]
[null,"A20","Blanc Flanges c/w bolts, washers and nuts",""]
[null,"A20.1","Black steel chilled water flanges including painting (primer and final coat), insulation ",""]
[null,"A20.1.1","NB 100, Medium Black Steel","No",1,null,{"$f":"F139*E139","v":0}]
[null,"A20.1.2","NB 150, Medium Black Steel","No",20,null,0]
[]
[{"$nulls":6},{"$f":"SUM(G5:G141)","v":0}]

{"sheet":"Equipment","index":6,"n_rows":138,"n_cols":78,"rows_kept":138,"merged":[[0,1,0,3],[1,1,1,3]]}
["PROJECT:","\tProcurement and installation of an HVAC system and replacement of the BMS System at the CSIR ICC for a period of three (3) years"]
["RFP No. ","RFP NO. 9501/16/04/2025"]
[]
[null,"Page/Item","Bill description","Unit","Quantity","Tender Rate","Value"]
[null,"A","4-Pipe Air-Cooled Heat Recovery Chiller ",""]
[null,"A1","Chiller supply",""]
[null,"A1.1","Price to include supply and delivery to site, including commissioning by supplier and two year free maintenance and guarantee"]
[null,"A1.1.1","277kWc, 132 kWh","No",2,null,{"$f":"F8*E8","v":0}]
[null,"A1.1.2","Anti-vibration mountings on unit ","No",2,null,{"$f":"F9*E9","v":0}]
[]
[null,"A2","Installation of Chiller",""]
[null,"A2.1","Mark-up unit on by HVAC Contractor (Specify %)","%",null,null,{"$f":"SUM(G8:G10)*F12","v":0}]
[null,"A2.2","Installation of Chiller (Labour Only)","Lot",2,null,{"$f":"F13*E13","v":0}]
[null,"A2.3","Pipe connections (Labour only)","Lot",2,null,{"$f":"F14*E14","v":0}]
[null,"A2.4","Electrical Connection of Unit ","Lot",2,null,{"$f":"F15*E15","v":0}]
[]
[null,"B","2-Pipe Air-Cooled Heat Pump Chiller",""]
[null,"B1","Heat Pump Only Supply",""]
[null,"B1.1","Price to include supply and delivery to site, including commissioning by supplier and two year free maintenance and guarantee"]
[null,"B1.1.1","541.2 kWh, 619.4 kWc","No",1,null,{"$f":"F20*E20","v":0}]
[null,"B1.1.2","Anti-vibration mountings on unit ","No",1,null,{"$f":"F21*E21","v":0}]
[]
[null,"B2","Installation of Heat Pump Chiller",""]
[null,"B2.1","Mark-up unit on by HVAC Contractor (Specify %)","%",null,null,{"$f":"SUM(G20:G22)*F24","v":0}]
[null,"B2.2","Installation of Chiller (Labour Only)","Lot",1,null,{"$f":"F25*E25","v":0}]
[null,"B2.3","Pipe connections (Labour only)","Lot",1,null,{"$f":"F26*E26","v":0}]
[null,"B2.5","Electrical Connection of Unit ","Lot",1,null,{"$f":"F27*E27","v":0}]
[]
[null,"C","Chilled Water "]
[null,"C1","Chilled Water Energy Control Valves"]
[null,"Project contingencies at 20%","Pressure Independent Energy Control Valve c/w modulating actuator controlled via wall mounted controller"]
[null,"C1.1.1","2-way Pressure Independent Energy Valve NB 20","No.",1,null,{"$f":"F32*E32","v":0}]
[null,"C1.1.2","2-way Pressure Independent Energy Valve NB 25","No.",{"$f":"5+3","v":8},null,0]
[null,"C1.1.3","2-way Pressure Independent Energy Valve NB 32","No.",{"$f":"4+2","v":6},null,0]
[null,"C1.1.4","2-way Pressure Independent Energy Valve NB 40","No.",0,null,0]
[null,"C1.1.5","2-way Pressure Independent Energy Valve NB 50","No.",6,null,0]
[null,"C1.1.6","2-way Pressure Independent Energy Valve NB 65","No.",4,null,0]
[]
[null,"C2","Electrocnic Flow Meter"]
[null,"C2.1","Electronic Water flow meter supplied and installed"]
[null,"C2.1.1","NB 80","No",2,null,{"$f":"F41*E41","v":0}]
[null,"C2.1.2","NB 100","No",2,null,{"$f":"F42*E42","v":0}]
[null,"C2.1.3","NB 150","No",4,null,{"$f":"F43*E43","v":0}]
[]
[null,"C3","Chilled Water 3-Way Modulating Valve"]
[null,"C3.1","3-Way Modulating Valve supplied and installed"]
[null,"C3.1.1","NB 150","No",1,null,{"$f":"F47*E47","v":0}]
[]
[null,"C4","Gravity Feed Expansion Tank",""]
[null,"C4.1","Chilled Water Circuit for ice storage pressure booster set (150L hydrosphere)","No",1,null,{"$f":"F50*E50","v":0}]
[null,"C4.2","00","No",1,null,{"$f":"F51*E51","v":0}]
[]
[null,"D","4-Pipe CAV Air Handling Unit, complete with chilled water cooling coil, hot water heating coil, supply air fan, primary and secondary filtration"]
[null,"D1","Supply of AHU"]
[null,"D1.1","Price to include supply and delivery to site, including two year free maintenance and guarantee"]
[null,"D1.1.1","AHU-01, 1 900L/s - 37.6 kW Cooling, 16 kW Heating","No",1,null,{"$f":"F56*E56","v":0}]
[null,"D1.1.2","AHU-02, 2 600L/s - 49.8 kW Cooling, 22.7 kW Heating","No",1,null,{"$f":"F57*E57","v":0}]
[null,"D1.1.3","AHU-03, 1 400L/s - 23.5 kW Cooling, 11.5 kW Heating","No",1,null,0]
[null,"D1.1.4","AHU-04, 7 500L/s - 149.0 kW Cooling, 64.6 kW Heating","No",1,null,0]
[null,"D1.1.5","AHU-05, 2 400L/s - 49.2 kW Cooling, 23.7 kW Heating","No",1,null,0]
[null,"D1.1.6","AHU-06, 3 200L/s - 62.8 kW Cooling, 35.5k W Heating","No",1,null,0]
[null,"D1.1.7","AHU-07, 9 480L/s - 163.0 kW Cooling, 88.0 kW Heating","No",1,null,0]
[null,"D1.1.8","AHU-08, 11 500L/s - 205.0 kW Cooling, 118.0 kW Heating","No",1,null,0]
[null,"D1.1.9","AHU-09, 10 500L/s - 184.0 kW Cooling, 187.0 kW Heating","No",1,null,{"$f":"F64*E64","v":0}]
[null,"D1.1.10","AHU-10, 6 990L/s - 118.0 kW Cooling, 80.3 kW Heating","No",1,null,0]
[null,"D1.1.11","Anti-vibration mountings on unit ","Lot",10,null,{"$f":"F66*E66","v":0}]
[]
[null,"D2","Installation of AHU (Labour Only)",""]
[null,"D2.1","HVAC Contractor mark-up on air-handling unit (Specify _____%)","%",1,null,{"$f":"SUM(G56:G67)*F69","v":0}]
[null,"D2.2","Installation of AHU (Labour Only)","Lot",10,null,{"$f":"F70*E70","v":0}]
[null,"D2.3","Chilled and Hot water pipe connections (Labour Only)","Lot",10,null,0]
[null,"D2.4","Electrical connection of unit","Lot",10,null,0]
[null,"D2.5","Commissioning and balancing of unit","Lot",10,null,0]
[null,"D2.6","Condensate drain connection of unit (Labour Only)","Lot",10,null,0]
[null,"D2.7","Canvas duct connection of unit","Lot",10,null,0]
[]
[null,"D3","Stand Alone Control System ",{"$nulls":7},{"$f":"IF(J77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(J77),$H77*J77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(K77),K77,0)=0,\"\",IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(K77),K77,0))","v":""},null,null,{"$f":"IF(N77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(N77),$H77*N77,0)))","v":""},null,{"$f":"IF(P77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(P77),$H77*P77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(O77),O77,0)+IF(ISNUMBER(Q77),Q77,0)=0,\"\",IF(ISNUMBER(O77),O77,0)+IF(ISNUMBER(Q77),Q77,0))","v":""},null,null,{"$f":"IF(T77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(T77),$H77*T77,0)))","v":""},null,{"$f":"IF(V77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(V77),$H77*V77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(U77),U77,0)+IF(ISNUMBER(W77),W77,0)=0,\"\",IF(ISNUMBER(U77),U77,0)+IF(ISNUMBER(W77),W77,0))","v":""},null,null,{"$f":"IF(Z77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(Z77),$H77*Z77,0)))","v":""},null,{"$f":"IF(AB77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(AB77),$H77*AB77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AA77),AA77,0)+IF(ISNUMBER(AC77),AC77,0)=0,\"\",IF(ISNUMBER(AA77),AA77,0)+IF(ISNUMBER(AC77),AC77,0))","v":""},null,null,{"$f":"IF(AF77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(AF77),$H77*AF77,0)))","v":""},null,{"$f":"IF(AH77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(AH77),$H77*AH77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AG77),AG77,0)+IF(ISNUMBER(AI77),AI77,0)=0,\"\",IF(ISNUMBER(AG77),AG77,0)+IF(ISNUMBER(AI77),AI77,0))","v":""},null,null,{"$f":"IF(AL77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(AL77),$H77*AL77,0)))","v":""},null,{"$f":"IF(AN77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(AN77),$H77*AN77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AM77),AM77,0)+IF(ISNUMBER(AO77),AO77,0)=0,\"\",IF(ISNUMBER(AM77),AM77,0)+IF(ISNUMBER(AO77),AO77,0))","v":""},null,null,{"$f":"IF(AR77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(AR77),$H77*AR77,0)))","v":""},null,{"$f":"IF(AT77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(AT77),$H77*AT77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AS77),AS77,0)+IF(ISNUMBER(AU77),AU77,0)=0,\"\",IF(ISNUMBER(AS77),AS77,0)+IF(ISNUMBER(AU77),AU77,0))","v":""},null,null,{"$f":"IF(AX77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(AX77),$H77*AX77,0)))","v":""},null,{"$f":"IF(AZ77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(AZ77),$H77*AZ77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AY77),AY77,0)+IF(ISNUMBER(BA77),BA77,0)=0,\"\",IF(ISNUMBER(AY77),AY77,0)+IF(ISNUMBER(BA77),BA77,0))","v":""},null,null,{"$f":"IF(BD77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(BD77),$H77*BD77,0)))","v":""},null,{"$f":"IF(BF77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(BF77),$H77*BF77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BE77),BE77,0)+IF(ISNUMBER(BG77),BG77,0)=0,\"\",IF(ISNUMBER(BE77),BE77,0)+IF(ISNUMBER(BG77),BG77,0))","v":""},null,null,{"$f":"IF(BJ77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(BJ77),$H77*BJ77,0)))","v":""},null,{"$f":"IF(BL77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(BL77),$H77*BL77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BK77),BK77,0)+IF(ISNUMBER(BM77),BM77,0)=0,\"\",IF(ISNUMBER(BK77),BK77,0)+IF(ISNUMBER(BM77),BM77,0))","v":""},null,null,{"$f":"IF(BP77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(BP77),$H77*BP77,0)))","v":""},null,{"$f":"IF(BR77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(BR77),$H77*BR77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BQ77),BQ77,0)+IF(ISNUMBER(BS77),BS77,0)=0,\"\",IF(ISNUMBER(BQ77),BQ77,0)+IF(ISNUMBER(BS77),BS77,0))","v":""},null,null,{"$f":"IF(BV77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(BV77),$H77*BV77,0)))","v":""},null,{"$f":"IF(BX77=\"\",\"\",IF($H77=\"\",\"\",IF(ISNUMBER(BX77),$H77*BX77,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BW77),BW77,0)+IF(ISNUMBER(BY77),BY77,0)=0,\"\",IF(ISNUMBER(BW77),BW77,0)+IF(ISNUMBER(BY77),BY77,0))","v":""}]
[null,"D3.1","FCU controller to have ability to control, set-point, fan speed, on/off, modulating control valve, closing of modulating valve when unit is switched off and to sense room temperature c/w weekly timer program",{"$nulls":7},{"$f":"IF(J78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(J78),$H78*J78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(K78),K78,0)=0,\"\",IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(K78),K78,0))","v":""},null,null,{"$f":"IF(N78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(N78),$H78*N78,0)))","v":""},null,{"$f":"IF(P78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(P78),$H78*P78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(O78),O78,0)+IF(ISNUMBER(Q78),Q78,0)=0,\"\",IF(ISNUMBER(O78),O78,0)+IF(ISNUMBER(Q78),Q78,0))","v":""},null,null,{"$f":"IF(T78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(T78),$H78*T78,0)))","v":""},null,{"$f":"IF(V78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(V78),$H78*V78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(U78),U78,0)+IF(ISNUMBER(W78),W78,0)=0,\"\",IF(ISNUMBER(U78),U78,0)+IF(ISNUMBER(W78),W78,0))","v":""},null,null,{"$f":"IF(Z78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(Z78),$H78*Z78,0)))","v":""},null,{"$f":"IF(AB78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(AB78),$H78*AB78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AA78),AA78,0)+IF(ISNUMBER(AC78),AC78,0)=0,\"\",IF(ISNUMBER(AA78),AA78,0)+IF(ISNUMBER(AC78),AC78,0))","v":""},null,null,{"$f":"IF(AF78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(AF78),$H78*AF78,0)))","v":""},null,{"$f":"IF(AH78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(AH78),$H78*AH78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AG78),AG78,0)+IF(ISNUMBER(AI78),AI78,0)=0,\"\",IF(ISNUMBER(AG78),AG78,0)+IF(ISNUMBER(AI78),AI78,0))","v":""},null,null,{"$f":"IF(AL78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(AL78),$H78*AL78,0)))","v":""},null,{"$f":"IF(AN78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(AN78),$H78*AN78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AM78),AM78,0)+IF(ISNUMBER(AO78),AO78,0)=0,\"\",IF(ISNUMBER(AM78),AM78,0)+IF(ISNUMBER(AO78),AO78,0))","v":""},null,null,{"$f":"IF(AR78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(AR78),$H78*AR78,0)))","v":""},null,{"$f":"IF(AT78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(AT78),$H78*AT78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AS78),AS78,0)+IF(ISNUMBER(AU78),AU78,0)=0,\"\",IF(ISNUMBER(AS78),AS78,0)+IF(ISNUMBER(AU78),AU78,0))","v":""},null,null,{"$f":"IF(AX78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(AX78),$H78*AX78,0)))","v":""},null,{"$f":"IF(AZ78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(AZ78),$H78*AZ78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AY78),AY78,0)+IF(ISNUMBER(BA78),BA78,0)=0,\"\",IF(ISNUMBER(AY78),AY78,0)+IF(ISNUMBER(BA78),BA78,0))","v":""},null,null,{"$f":"IF(BD78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(BD78),$H78*BD78,0)))","v":""},null,{"$f":"IF(BF78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(BF78),$H78*BF78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BE78),BE78,0)+IF(ISNUMBER(BG78),BG78,0)=0,\"\",IF(ISNUMBER(BE78),BE78,0)+IF(ISNUMBER(BG78),BG78,0))","v":""},null,null,{"$f":"IF(BJ78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(BJ78),$H78*BJ78,0)))","v":""},null,{"$f":"IF(BL78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(BL78),$H78*BL78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BK78),BK78,0)+IF(ISNUMBER(BM78),BM78,0)=0,\"\",IF(ISNUMBER(BK78),BK78,0)+IF(ISNUMBER(BM78),BM78,0))","v":""},null,null,{"$f":"IF(BP78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(BP78),$H78*BP78,0)))","v":""},null,{"$f":"IF(BR78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(BR78),$H78*BR78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BQ78),BQ78,0)+IF(ISNUMBER(BS78),BS78,0)=0,\"\",IF(ISNUMBER(BQ78),BQ78,0)+IF(ISNUMBER(BS78),BS78,0))","v":""},null,null,{"$f":"IF(BV78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(BV78),$H78*BV78,0)))","v":""},null,{"$f":"IF(BX78=\"\",\"\",IF($H78=\"\",\"\",IF(ISNUMBER(BX78),$H78*BX78,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BW78),BW78,0)+IF(ISNUMBER(BY78),BY78,0)=0,\"\",IF(ISNUMBER(BW78),BW78,0)+IF(ISNUMBER(BY78),BY78,0))","v":""}]
[null,"D3.1.1","AHU wall thermostat","No.",0,null,{"$f":"F79*E79","v":0},{"$nulls":3},{"$f":"IF(J79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(J79),$H79*J79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(K79),K79,0)=0,\"\",IF(ISNUMBER(#REF!),#REF!,0)+IF(ISNUMBER(K79),K79,0))","v":""},null,null,{"$f":"IF(N79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(N79),$H79*N79,0)))","v":""},null,{"$f":"IF(P79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(P79),$H79*P79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(O79),O79,0)+IF(ISNUMBER(Q79),Q79,0)=0,\"\",IF(ISNUMBER(O79),O79,0)+IF(ISNUMBER(Q79),Q79,0))","v":""},null,null,{"$f":"IF(T79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(T79),$H79*T79,0)))","v":""},null,{"$f":"IF(V79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(V79),$H79*V79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(U79),U79,0)+IF(ISNUMBER(W79),W79,0)=0,\"\",IF(ISNUMBER(U79),U79,0)+IF(ISNUMBER(W79),W79,0))","v":""},null,null,{"$f":"IF(Z79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(Z79),$H79*Z79,0)))","v":""},null,{"$f":"IF(AB79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(AB79),$H79*AB79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AA79),AA79,0)+IF(ISNUMBER(AC79),AC79,0)=0,\"\",IF(ISNUMBER(AA79),AA79,0)+IF(ISNUMBER(AC79),AC79,0))","v":""},null,null,{"$f":"IF(AF79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(AF79),$H79*AF79,0)))","v":""},null,{"$f":"IF(AH79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(AH79),$H79*AH79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AG79),AG79,0)+IF(ISNUMBER(AI79),AI79,0)=0,\"\",IF(ISNUMBER(AG79),AG79,0)+IF(ISNUMBER(AI79),AI79,0))","v":""},null,null,{"$f":"IF(AL79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(AL79),$H79*AL79,0)))","v":""},null,{"$f":"IF(AN79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(AN79),$H79*AN79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AM79),AM79,0)+IF(ISNUMBER(AO79),AO79,0)=0,\"\",IF(ISNUMBER(AM79),AM79,0)+IF(ISNUMBER(AO79),AO79,0))","v":""},null,null,{"$f":"IF(AR79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(AR79),$H79*AR79,0)))","v":""},null,{"$f":"IF(AT79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(AT79),$H79*AT79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AS79),AS79,0)+IF(ISNUMBER(AU79),AU79,0)=0,\"\",IF(ISNUMBER(AS79),AS79,0)+IF(ISNUMBER(AU79),AU79,0))","v":""},null,null,{"$f":"IF(AX79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(AX79),$H79*AX79,0)))","v":""},null,{"$f":"IF(AZ79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(AZ79),$H79*AZ79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AY79),AY79,0)+IF(ISNUMBER(BA79),BA79,0)=0,\"\",IF(ISNUMBER(AY79),AY79,0)+IF(ISNUMBER(BA79),BA79,0))","v":""},null,null,{"$f":"IF(BD79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(BD79),$H79*BD79,0)))","v":""},null,{"$f":"IF(BF79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(BF79),$H79*BF79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BE79),BE79,0)+IF(ISNUMBER(BG79),BG79,0)=0,\"\",IF(ISNUMBER(BE79),BE79,0)+IF(ISNUMBER(BG79),BG79,0))","v":""},null,null,{"$f":"IF(BJ79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(BJ79),$H79*BJ79,0)))","v":""},null,{"$f":"IF(BL79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(BL79),$H79*BL79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BK79),BK79,0)+IF(ISNUMBER(BM79),BM79,0)=0,\"\",IF(ISNUMBER(BK79),BK79,0)+IF(ISNUMBER(BM79),BM79,0))","v":""},null,null,{"$f":"IF(BP79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(BP79),$H79*BP79,0)))","v":""},null,{"$f":"IF(BR79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(BR79),$H79*BR79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BQ79),BQ79,0)+IF(ISNUMBER(BS79),BS79,0)=0,\"\",IF(ISNUMBER(BQ79),BQ79,0)+IF(ISNUMBER(BS79),BS79,0))","v":""},null,null,{"$f":"IF(BV79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(BV79),$H79*BV79,0)))","v":""},null,{"$f":"IF(BX79=\"\",\"\",IF($H79=\"\",\"\",IF(ISNUMBER(BX79),$H79*BX79,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BW79),BW79,0)+IF(ISNUMBER(BY79),BY79,0)=0,\"\",IF(ISNUMBER(BW79),BW79,0)+IF(ISNUMBER(BY79),BY79,0))","v":""}]
[]
[null,"E","Pumps"]
[null,"E1","Price to include supply and delivery to site, sub-contractor mark-up, c/w pump frame"]
[null,"E1.1","Base-mounted Primary Chilled Water Pump "]
[null,"E1.1.1","Pump: 17.50l/s, 284kPa, Temp (-2) -13, 25% glycol)","No",4,null,{"$f":"F84*E84","v":0}]
[]
[null,"E1.2","Base-mounted Secondary Chilled Water Pump "]
[null,"E1.2.1","Pump: 29.61l/s, 218kPa, Temp 5-13, 25% glycol)","No",2,null,{"$f":"F87*E87","v":0}]
[]
[null,"E1.3","Base-mounted Primary Hot Water Pump (Heat Recovery)"]
[null,"E1.3.1","Pump: 6.38l/s, 72kPa, Temp 20-50, water)","No",2,null,{"$f":"F90*E90","v":0}]
[]
[null,"E1.4","Base-mounted Secondary Hot Water Pump (Heat Recovery)"]
[null,"E1.4.1","Pump: 26.89l/s, 159kPa, Temp 20-50, water)","No",2,null,{"$f":"F93*E93","v":0}]
[]
[null,"E1.5","Base-mounted Primary Hot Water Pump (Heat Pemp)"]
[null,"E1.5.1","Pump: 26.10l/s, 59kPa, Temp 20-50, water)","No",2,null,{"$f":"F96*E96","v":0}]
[]
[null,"E1.6","Installation of Pumps"]
[null,"E1.6.1","Anti-vibration mountings per pump","Lot",{"$f":"SUM(E84:E98)","v":12},null,{"$f":"F99*E99","v":0}]
[null,"E1.6.2","Installation of Pumps (Labour Only)","Lot",{"$f":"$E$99","v":12},null,0]
[null,"E1.6.3","Chilled/Hot water pipe connections (Labour only)","Lot",12,null,0]
[null,"E1.6.4","Electrical Connection of Pump and E-stop (Labour Only)","Lot",12,null,0]
[null,"E1.6.5","Balancing and Commissioning of Pump","Lot",12,null,0]
[null,"E1.6.6","Stainless Steel Drip Tray (Supply and Install)","Lot",12,null,0]
[null,"E1.6.7","Driptray Connection to nearest Full-bore Drain (Including material and Labour)","Lot",12,null,0]
[]
[null,"F","Hot Water Storage Tank","",""]
[null,"F1","Hot water tank including insulation",{"$nulls":13},{"$f":"IF(P108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(P108),$H108*P108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(O108),O108,0)+IF(ISNUMBER(Q108),Q108,0)=0,\"\",IF(ISNUMBER(O108),O108,0)+IF(ISNUMBER(Q108),Q108,0))","v":""},null,null,{"$f":"IF(T108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(T108),$H108*T108,0)))","v":""},null,{"$f":"IF(V108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(V108),$H108*V108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(U108),U108,0)+IF(ISNUMBER(W108),W108,0)=0,\"\",IF(ISNUMBER(U108),U108,0)+IF(ISNUMBER(W108),W108,0))","v":""},null,null,{"$f":"IF(Z108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(Z108),$H108*Z108,0)))","v":""},null,{"$f":"IF(AB108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(AB108),$H108*AB108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AA108),AA108,0)+IF(ISNUMBER(AC108),AC108,0)=0,\"\",IF(ISNUMBER(AA108),AA108,0)+IF(ISNUMBER(AC108),AC108,0))","v":""},null,null,{"$f":"IF(AF108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(AF108),$H108*AF108,0)))","v":""},null,{"$f":"IF(AH108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(AH108),$H108*AH108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AG108),AG108,0)+IF(ISNUMBER(AI108),AI108,0)=0,\"\",IF(ISNUMBER(AG108),AG108,0)+IF(ISNUMBER(AI108),AI108,0))","v":""},null,null,{"$f":"IF(AL108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(AL108),$H108*AL108,0)))","v":""},null,{"$f":"IF(AN108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(AN108),$H108*AN108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AM108),AM108,0)+IF(ISNUMBER(AO108),AO108,0)=0,\"\",IF(ISNUMBER(AM108),AM108,0)+IF(ISNUMBER(AO108),AO108,0))","v":""},null,null,{"$f":"IF(AR108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(AR108),$H108*AR108,0)))","v":""},null,{"$f":"IF(AT108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(AT108),$H108*AT108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AS108),AS108,0)+IF(ISNUMBER(AU108),AU108,0)=0,\"\",IF(ISNUMBER(AS108),AS108,0)+IF(ISNUMBER(AU108),AU108,0))","v":""},null,null,{"$f":"IF(AX108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(AX108),$H108*AX108,0)))","v":""},null,{"$f":"IF(AZ108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(AZ108),$H108*AZ108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AY108),AY108,0)+IF(ISNUMBER(BA108),BA108,0)=0,\"\",IF(ISNUMBER(AY108),AY108,0)+IF(ISNUMBER(BA108),BA108,0))","v":""},null,null,{"$f":"IF(BD108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(BD108),$H108*BD108,0)))","v":""},null,{"$f":"IF(BF108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(BF108),$H108*BF108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BE108),BE108,0)+IF(ISNUMBER(BG108),BG108,0)=0,\"\",IF(ISNUMBER(BE108),BE108,0)+IF(ISNUMBER(BG108),BG108,0))","v":""},null,null,{"$f":"IF(BJ108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(BJ108),$H108*BJ108,0)))","v":""},null,{"$f":"IF(BL108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(BL108),$H108*BL108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BK108),BK108,0)+IF(ISNUMBER(BM108),BM108,0)=0,\"\",IF(ISNUMBER(BK108),BK108,0)+IF(ISNUMBER(BM108),BM108,0))","v":""},null,null,{"$f":"IF(BP108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(BP108),$H108*BP108,0)))","v":""},null,{"$f":"IF(BR108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(BR108),$H108*BR108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BQ108),BQ108,0)+IF(ISNUMBER(BS108),BS108,0)=0,\"\",IF(ISNUMBER(BQ108),BQ108,0)+IF(ISNUMBER(BS108),BS108,0))","v":""},null,null,{"$f":"IF(BV108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(BV108),$H108*BV108,0)))","v":""},null,{"$f":"IF(BX108=\"\",\"\",IF($H108=\"\",\"\",IF(ISNUMBER(BX108),$H108*BX108,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BW108),BW108,0)+IF(ISNUMBER(BY108),BY108,0)=0,\"\",IF(ISNUMBER(BW108),BW108,0)+IF(ISNUMBER(BY108),BY108,0))","v":""}]
[null,"F1.1","40000L","No",1,null,{"$f":"F109*E109","v":0}]
[]
[null,"G","Air Control","",""]
[null,"G1","Motorised Balancing damper c/w 24 V Actuator, supply and installed",{"$nulls":13},{"$f":"IF(P112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(P112),$H112*P112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(O112),O112,0)+IF(ISNUMBER(Q112),Q112,0)=0,\"\",IF(ISNUMBER(O112),O112,0)+IF(ISNUMBER(Q112),Q112,0))","v":""},null,null,{"$f":"IF(T112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(T112),$H112*T112,0)))","v":""},null,{"$f":"IF(V112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(V112),$H112*V112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(U112),U112,0)+IF(ISNUMBER(W112),W112,0)=0,\"\",IF(ISNUMBER(U112),U112,0)+IF(ISNUMBER(W112),W112,0))","v":""},null,null,{"$f":"IF(Z112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(Z112),$H112*Z112,0)))","v":""},null,{"$f":"IF(AB112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(AB112),$H112*AB112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AA112),AA112,0)+IF(ISNUMBER(AC112),AC112,0)=0,\"\",IF(ISNUMBER(AA112),AA112,0)+IF(ISNUMBER(AC112),AC112,0))","v":""},null,null,{"$f":"IF(AF112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(AF112),$H112*AF112,0)))","v":""},null,{"$f":"IF(AH112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(AH112),$H112*AH112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AG112),AG112,0)+IF(ISNUMBER(AI112),AI112,0)=0,\"\",IF(ISNUMBER(AG112),AG112,0)+IF(ISNUMBER(AI112),AI112,0))","v":""},null,null,{"$f":"IF(AL112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(AL112),$H112*AL112,0)))","v":""},null,{"$f":"IF(AN112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(AN112),$H112*AN112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AM112),AM112,0)+IF(ISNUMBER(AO112),AO112,0)=0,\"\",IF(ISNUMBER(AM112),AM112,0)+IF(ISNUMBER(AO112),AO112,0))","v":""},null,null,{"$f":"IF(AR112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(AR112),$H112*AR112,0)))","v":""},null,{"$f":"IF(AT112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(AT112),$H112*AT112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AS112),AS112,0)+IF(ISNUMBER(AU112),AU112,0)=0,\"\",IF(ISNUMBER(AS112),AS112,0)+IF(ISNUMBER(AU112),AU112,0))","v":""},null,null,{"$f":"IF(AX112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(AX112),$H112*AX112,0)))","v":""},null,{"$f":"IF(AZ112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(AZ112),$H112*AZ112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(AY112),AY112,0)+IF(ISNUMBER(BA112),BA112,0)=0,\"\",IF(ISNUMBER(AY112),AY112,0)+IF(ISNUMBER(BA112),BA112,0))","v":""},null,null,{"$f":"IF(BD112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(BD112),$H112*BD112,0)))","v":""},null,{"$f":"IF(BF112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(BF112),$H112*BF112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BE112),BE112,0)+IF(ISNUMBER(BG112),BG112,0)=0,\"\",IF(ISNUMBER(BE112),BE112,0)+IF(ISNUMBER(BG112),BG112,0))","v":""},null,null,{"$f":"IF(BJ112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(BJ112),$H112*BJ112,0)))","v":""},null,{"$f":"IF(BL112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(BL112),$H112*BL112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BK112),BK112,0)+IF(ISNUMBER(BM112),BM112,0)=0,\"\",IF(ISNUMBER(BK112),BK112,0)+IF(ISNUMBER(BM112),BM112,0))","v":""},null,null,{"$f":"IF(BP112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(BP112),$H112*BP112,0)))","v":""},null,{"$f":"IF(BR112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(BR112),$H112*BR112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BQ112),BQ112,0)+IF(ISNUMBER(BS112),BS112,0)=0,\"\",IF(ISNUMBER(BQ112),BQ112,0)+IF(ISNUMBER(BS112),BS112,0))","v":""},null,null,{"$f":"IF(BV112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(BV112),$H112*BV112,0)))","v":""},null,{"$f":"IF(BX112=\"\",\"\",IF($H112=\"\",\"\",IF(ISNUMBER(BX112),$H112*BX112,0)))","v":""},{"$f":"IF(IF(ISNUMBER(BW112),BW112,0)+IF(ISNUMBER(BY112),BY112,0)=0,\"\",IF(ISNUMBER(BW112),BW112,0)+IF(ISNUMBER(BY112),BY112,0))","v":""}]
[null,"G1.1","Motorised Balancing Dampers","",""]
[null,"G1.1.1","500 x 1200, motorised c/w 24V motor","No",{"$f":"1+1+1","v":3},null,{"$f":"F114*E114","v":0}]
[null,"G1.1.2","600 x 1300, motorised c/w 24V motor","No",{"$f":"2+2","v":4},null,{"$f":"F115*E115","v":0}]
[null,"G1.1.3","900 x 1300, motorised c/w 24V motor","No",{"$f":"2+2","v":4},null,0]
[null,"G1.1.4","1000 x 1450, motorised c/w 24V motor","No",{"$f":"2","v":2},null,0]
[null,"G1.1.5","1200 x 1650, motorised c/w 24V motor","No",{"$f":"2+2","v":4},null,0]
[]
[null,"H","Variable Speed Drives"]
[null,"H1","VSD - 1.1 kW","No",2,null,{"$f":"F121*E121","v":0}]
[null,"H2","VSD - 3 kW","No",2,null,0]
[null,"H3","VSD - 7.5 kW","No",2,null,{"$f":"F123*E123","v":0}]
[null,"H4","VSD - 11 kW","No",{"$f":"4+2","v":6},null,0]
[]
[null,"I","CW Ceiling Cassettes"]
[null,"I1","4-Pipe for chilled water cooling coils and hot water heating coils, complete with accessories,"]
[null,null,"wall-mounted controller, condensate piping, supplied, installed, tested and commissioned."]
[null,"I1.1","10,0 kW (Nominal Cooling) and 6,7 kW (Nominal heating), 4-way blow","No",{"v":2,"d":"2.00"},null,{"$f":"F129*E129","v":0}]
[null,"I1.2","4,0 kW (Nominal Cooling) and 3,0 kW (Nominal heating), 4-way blow","No",{"v":1,"d":"1.00"},null,0]
[null,"I1.3","8,0 kW (Nominal Cooling) and 5,1 kW (nominal heating), 4-way blow","No",{"v":1,"d":"1.00"},null,0]
[]
[null,"J1","Thermal Energy Storage Tanks"]
[null,"J1.1","Ice storage tanks as per the Specification document - double inlet, double outlet type","No",{"v":6,"d":"6.00"},null,{"$f":"F134*E134","v":0}]
[null,"J1.2","Ice storage tanks as per the Specification document - single inlet, single outlet type","No",{"v":1,"d":"1.00"},null,0]
[]
[]
[{"$nulls":6},{"$f":"SUM(G5:G136)","v":0}]

{"sheet":"Terminals","index":7,"n_rows":65,"n_cols":7,"rows_kept":65,"merged":[[0,1,0,3],[1,1,1,3]]}
["PROJECT:","\tProcurement and installation of an HVAC system and replacement of the BMS System at the CSIR ICC for a period of three (3) years"]
["RFP No. ","RFP NO. 9501/16/04/2025"]
[]
[null,"Page/Item","Bill description","Unit","Quantity","Tender Rate","Value"]
[null,"A","Constant Volume Air Terminals",""]
[null,"A1","Weather Louvres",""]
[null,"A1.1","500 x 1200, Natural Anodised","No",{"$f":"1+1+1","v":3},null,{"$f":"F7*E7","v":0}]
[null,"A1.2","600 x 1300, Natural Anodised","No",{"$f":"2+2","v":4},null,{"$f":"F8*E8","v":0}]
[null,"A1.3","900 x 1300, Natural Anodised","No",{"$f":"2+2","v":4},null,{"$f":"F9*E9","v":0}]
[null,"A1.4","1000 x 1450, Natural Anodised","No",{"$f":"2","v":2},null,0]
[null,"A1.5","1200 x 1650, Natural Anodised","No",{"$f":"2+2","v":4},null,0]
{"$rows_empty":52}
[null,null,"",""]
[{"$nulls":6},{"$f":"SUM(G5:G64)","v":0}]

{"sheet":"VRF","index":8,"n_rows":102,"n_cols":7,"rows_kept":102,"merged":[[0,1,0,3],[1,1,1,3]]}
["PROJECT:","\tProcurement and installation of an HVAC system and replacement of the BMS System at the CSIR ICC for a period of three (3) years"]
["RFP No. ","RFP NO. 9501/16/04/2025"]
[]
[null,"Page/Item","Bill description","Unit","Quantity","Tender Rate","Value"]
[null,"A","VRF Heat Recovery Air-conditioning Units"]
[null,"A1","Indoor Units"]
[null,null,"VRF Heat recovery type indoor Air-conditioning  units, to specification, tested and installed. Including all necessary refrigerant piping including thermal insulation , trunking, final electrical connections between isolator and indoor unit, p-trap condensate outlets, mounting accessories and supply air sound  attenuators (for hide away units). All Indoor units must be equipped with Electronic expansion valves and fitted with ECcontrolled supply air fans, and wall-mounted controllers. (Samsung, Daikin or other approved)"]
[null,null,"The Quantity represents the total number of mechanical equipment items for a particular type, sub-type and size."]
[null,null,"The tendered rates for each item shall include full compensation for any costs, work or materials required to provide and install each piece of mechanical equipment, as specified and approved by the Engineer."]
[null,null,"Length of refrigerant piping measured is only the linear meters between indoor unit and refrigerant controller box (not the sum of the liquid and suction line).  "]
[null,"A1.1","Office 1 - One-way blow ceiling cassette (AC02)","No",1,null,{"$f":"F11*E11","v":0}]
[null,{"$f":"IF(D12<>\"\",MAX(#REF!)+1,\"\")","v":""},"2.8 kW (Nominal Cooling) inclusive of 18m refrigerant "]
[null,null,"piping and accessories"]
[null,"A1.2","Office 2 - Four-way blow ceiling cassette (AC04)","No",1,null,{"$f":"F14*E14","v":0}]
[null,{"$f":"IF(D15<>\"\",MAX(B11:B14)+1,\"\")","v":""},"4.5 kW (Nominal Cooling) inclusive of 24m refrigerant "]
[null,null,"piping and accessories"]
[null,"A1.3","Office 3 - One-way blow ceiling cassette (AC02)","No",1,null,{"$f":"F17*E17","v":0}]
[null,{"$f":"IF(D18<>\"\",MAX(B11:B17)+1,\"\")","v":""},"2.8 kW (Nominal Cooling) inclusive of 3m refrigerant "]
[null,null,"piping and accessories"]
[null,"A1.4","Office 4 - One-way blow ceiling cassette (AC02)","No",1,null,{"$f":"F20*E20","v":0}]
[null,{"$f":"IF(D21<>\"\",MAX(B11:B20)+1,\"\")","v":""},"2.8 kW (Nominal Cooling) inclusive of 7m refrigerant "]
[null,null,"piping and accessories"]
[null,"A1.5","Office 5 - One-way blow ceiling cassette (AC02)","No",1,null,{"$f":"F23*E23","v":0}]
[null,{"$f":"IF(D24<>\"\",MAX(B14:B23)+1,\"\")","v":""},"2.8 kW (Nominal Cooling) inclusive of 13m refrigerant "]
[null,null,"piping and accessories"]
[null,"A1.6","Office 6 - One-way blow ceiling cassette (AC02)","No",1,null,{"$f":"F26*E26","v":0}]
[null,{"$f":"IF(D27<>\"\",MAX(B11:B26)+1,\"\")","v":""},"2.8 kW (Nominal Cooling) inclusive of 17m refrigerant "]
[null,{"$f":"IF(D28<>\"\",MAX(B11:B27)+1,\"\")","v":""},"piping and accessories"]
[null,"A1.7","Coffee pause room (AC03) - One-way blow cassette","No",1,null,{"$f":"F29*E29","v":0}]
[null,{"$f":"IF(D30<>\"\",MAX(B20:B29)+1,\"\")","v":""},"3.6 kW (Nominal Cooling) inclusive of 11m refrigerant "]
[null,"Project contingencies at 20%","piping and accessories"]
[null,"A1.8","Meeting Room 2 (AC04) - Four-way ceiling cassette","No",1,null,{"$f":"F32*E32","v":0}]
[null,{"$f":"IF(D33<>\"\",MAX(B16:B32)+1,\"\")","v":""},"4.5 kW (Nominal Cooling) inclusive of 7m refrigerant "]
[null,{"$f":"IF(D34<>\"\",MAX(B16:B33)+1,\"\")","v":""},"piping and accessories"]
[null,"A1.9","Meeting Room 1 (AC05) - Four-way ceiling cassette","No",1,null,{"$f":"F35*E35","v":0}]
[null,null,"7.1 kW (Nominal Cooling) inclusive of 3m refrigerant"]
[null,null,"piping and accessories"]
[null,"A1.10","Reception (AC01) - One-way ceiling cassette","No",1,null,{"$f":"F38*E38","v":0}]
[null,null,"2.2 kW (Nominal Cooling) inclusive of 8m refrigerant "]
[null,null,"piping and accessories"]
[]
[null,"A2","Condensing unit"]
[null,null,"VRF heat recovery air cooled condensing units inclusive of drain pans and accessories to specification, tested and installed. Including all necessary refrigerant piping including thermal insulation ,trunking, final electrical connections between isolator and outdoor unit all to ensure a fully functional system as described. (Samsung, Daikin or other approved)."]
[null,null,"The Quantity represents the total number of mechanical equipment items for a particular type, sub-type and size."]
[null,null,"The tendered rates for each item shall include full compensation for any costs, work or materials required to provide and install each piece of mechanical equipment, as specified and approved by the Engineer."]
[null,null,"Length of refrigerant piping measured is only the linear meters between outdoor unit and refrigerant controller box. Allow for galvanised trunking - pipes are exposed between outdoor unit and first refrigerant control box."]
[null,"A2.1","Outdoor Unit (ODU01) : Heat Recovery VRF","No",1,null,{"$f":"F47*E47","v":0}]
[null,null,"33.6 kW (Nominal Capacity) inclusive of 39m refrigerant piping "]
[null,null,"and accessories"]
[]
[null,"A3","Refrigerant Controller units (MCU or BS/BC box)"]
[null,null,"Including all accessories, fittings, installation, etc. to ensure a fully functioning system as per the specifications and relevant standards."]
[null,null,"The Quantity represents the total number of mechanical equipment items for a particular type, sub-type and size."]
[null,null,"The tendered rates for each item shall include full compensation for any costs, work or materials required to provide and install each piece of mechanical equipment, as specified and approved by the Engineer."]
[null,"A3.1","4 Port Controller (MCU01)","No",1,null,{"$f":"F55*E55","v":0}]
[null,"A3.2","6 Port Controller (MCU02)","No",1,null,{"$f":"F56*E56","v":0}]
[]
[null,"A4","Refrigerant Pipe Y-joints"]
[null,"A4.1","3 Y-joints to branch refrigerant controller units","No",3,null,{"$f":"F59*E59","v":0}]
[]
[null,"A5","uPVC piping and fittings "]
[null,"A5.1","Ø25 mm ","m",24,null,{"$f":"F62*E62","v":0}]
[null,"A5.2","Ø50 mm","m",45,null,{"$f":"F63*E63","v":0}]
[]
[null,"B","Ducting",{"$nulls":3},""]
[null,"B1","Price to include for low pressure galvanised ducting including 50mm Sonic Liner, installation and labour, c/w all fixing and supports"]
[null,"B1.1","Insulated Straight Ducting"]
[null,"B1.1.1","Category 1 - Ducting with a width or height < 750mm and semi-perimeter < 1150mm","m²",40,null,{"$f":"F68*E68","v":0}]
[null,"B1.1.2","Category 6 - Re-inforced Spiral Ducting"]
[null,"B1.1.2.1","- dia 150mm","m",13,null,{"$f":"F70*E70","v":0}]
[]
[null,"B1.2","Insulated Straight Ducting"]
[null,"B2","Price to include for 50mm Sonic Liner c/w installation and labour"]
[null,"B1.2.1","Category 1 - Ducting with a width or height < 750mm and semi-perimeter < 1150mm","m²",40,null,{"$f":"F74*E74","v":0}]
[null,"B1.2.6","Category 6 - Re-inforced Spiral Ducting"]
[null,"B1.2.6.1","- dia 150mm","m²",{"v":5.89,"d":"6"},null,{"$f":"F76*E76","v":0}]
[]
[null,"B1.3","Insulated Transformations and Bends"]
[null,"B1.3.1","Category 1 - Ducting with a width or height > 750mm and semi-perimeter < 1150mm","m²",6,null,{"$f":"F79*E79","v":0}]
[]
[null,"C","Fan Installation","",""]
[null,"C1","Axial Flow Fan","",""]
[null,"C1.1","Dia 560, 1400L/s @ 300Pa ","No",1,null,{"$f":"F83*E83","v":0}]
[null,"C1.2","Fan mounting Feet","No",1,null,{"$f":"F84*E84","v":0}]
[null,"C1.3","Flanges","No",1,null,{"$f":"F85*E85","v":0}]
[null,"C1.4","AVM's","No",1,null,{"$f":"F86*E86","v":0}]
[null,"C1.5","Support Frame","No",1,null,{"$f":"F87*E87","v":0}]
[]
[null,"C2","Electrical Distribution System",""]
[null,"C2.1","Electrical Connection of Axial Flow Fan","No",1,null,{"$f":"F90*E90","v":0}]
[]
[null,"C3","Flexible canvas connections between equipment and duct installations ",""]
[null,"C3.1","Axial Flow Fans","No",2,null,{"$f":"F93*E93","v":0}]
[]
[null,"C4","Sound Attenuators for Fans",""]
[null,"C4.1","Dia 560 x 1.5D, POD","No",2,null,{"$f":"F96*E96","v":0}]
[]
[null,"D","Constant Volume Air Terminals",""]
[null,"D1","Fresh Air Grille",""]
[null,"D1.1","Supply air Disc Valves, Dia 200, dia 200 Neck","No",10,null,{"$f":"F100*E100","v":0}]
[null,null,"",""]
[{"$nulls":6},{"$f":"SUM(G5:G101)","v":0}]