{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Summary Page","Section 1 - P&Gs","Section 2 - SPRINKLERS","Section 3 - EQUIPMENT & SIGNAGE","Section 4 - DETECTION & GAS SUP","Section 5 - Existing equipment ","Sect","Sheet3"],"not_rendered":{"images":2,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Summary Page","index":0,"n_rows":42,"n_cols":4,"rows_kept":42}
[null,"QCTO Hatfield"]
[null,"Fire Engineering Services"]
[null,"Office Fire Protection Systems"]
[null,"256 Glyn Lane, Hatfield, Pretoria"]
[]
["Project:","QCTO Hatfield"]
["Address:","256 Glyn Lane, Hatfield, Pretoria"]
[]
[]
["Item No.","Description"]
[]
[1,{"$f":"'Section 1 - P&Gs'!B4","v":"Section 01 - Preliminaries and General"},null,{"$f":"'Section 1 - P&Gs'!F59","v":0}]
[2,{"$f":"'Section 2 - SPRINKLERS'!B4","v":"Section 02 - Sprinkler Installation"},null,{"$f":"'Section 2 - SPRINKLERS'!F62","v":0}]
[3,{"$f":"'Section 3 - EQUIPMENT & SIGNAGE'!B4","v":"Section 03 - Equipment & Signage"},null,{"$f":"'Section 3 - EQUIPMENT & SIGNAGE'!E51","v":0}]
[4,{"$f":"'Section 4 - DETECTION & GAS SUP'!B4","v":"Section 04 - Detection & Gas Suppression"},null,{"$f":"'Section 4 - DETECTION & GAS SUP'!F70","v":0}]
[4,{"$f":"'Section 5 - Existing equipment '!B4","v":"Section 05 - Existing equipment"},null,{"$f":"'Section 5 - Existing equipment '!F18","v":0}]
[6,"Sub - Total",null,{"$f":"SUM(D12:D13)","v":0}]
[]
[7,"VAT",{"v":0.15,"d":"15%"},{"$f":"D17*15%","v":0}]
[]
[8,"Total",null,{"$f":"D19+D17","v":0}]
[]
[]
["Tendering Company:"]
[]
[]
[]
[]
[]
[]
["Address:"]
[]
[]
[]
[]
[]
[]
["Date:"]
[]
[]
[]
["Signature:"]

{"sheet":"Section 1 - P&Gs","index":1,"n_rows":59,"n_cols":6,"rows_kept":59}
[null,"QCTO Hatfield"]
[{"$f":"IF(ISBLANK(C2),\"\",MAX(A1:$A$1)+0.01)","v":""},"Fire Engineering Services"]
[null,"Office Fire Protection Systems"]
[null,"Section 01 - Preliminaries and General"]
[]
["ITEM","QCTO Hatfield","UNIT","QTY","RATE ","TOTAL"]
[{"$f":"IF(ISBLANK(C7),\"\",MAX(A$1:$A6)+0.01)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK(D7),\"\",D7*E7)","v":""}]
[1,"SECTION 1 - PRELIMINARIES AND GENERAL",{"$nulls":3},{"$f":"IF(ISBLANK(D8),\"\",D8*E8)","v":""}]
[{"$f":"IF(ISBLANK(C9),\"\",MAX(A$1:$A8)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C10),\"\",MAX(A$1:$A9)+0.01)","v":1.01},"Site establishment, mobilisation direct costs","Item",1,null,0]
[{"$f":"IF(ISBLANK(C11),\"\",MAX(A$1:$A10)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C12),\"\",MAX(A$1:$A11)+0.01)","v":1.02},"Site destablishment, demobilisation direct costs","Item",1,null,0]
[{"$f":"IF(ISBLANK(C13),\"\",MAX(A$1:$A12)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C14),\"\",MAX(A$1:$A13)+0.01)","v":""},"Project engineering and management",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C15),\"\",MAX(A$1:$A14)+0.01)","v":1.03},"Project Manager","Item",1,null,0]
[{"$f":"IF(ISBLANK(C16),\"\",MAX(A$1:$A15)+0.01)","v":1.04},"Site Manager","Item",1,null,0]
[{"$f":"IF(ISBLANK(C17),\"\",MAX(A$1:$A16)+0.01)","v":1.05},"Health and safety","Item",1,null,0]
[{"$f":"IF(ISBLANK(C18),\"\",MAX(A$1:$A17)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C19),\"\",MAX(A$1:$A18)+0.01)","v":1.06},"Commissioning / handover / training sessions","Item",1,null,0]
[{"$f":"IF(ISBLANK(C20),\"\",MAX(A$1:$A19)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C21),\"\",MAX(A$1:$A20)+0.01)","v":1.07},"One year maintenance and guarantee from date of practical completion","Item",1,null,0]
[{"$f":"IF(ISBLANK(C22),\"\",MAX(A$1:$A21)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C23),\"\",MAX(A$1:$A22)+0.01)","v":1.08},"Safety file and contractors pack","Item",1,null,0]
[{"$f":"IF(ISBLANK(C24),\"\",MAX(A$1:$A23)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C25),\"\",MAX(A$1:$A24)+0.01)","v":1.09},"Operating and maintenance manual as per specifications","Item",1,null,0]
[{"$f":"IF(ISBLANK(C26),\"\",MAX(A$1:$A25)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C27),\"\",MAX(A$1:$A26)+0.01)","v":{"v":1.1,"d":"1.10"}},"Workshop drawings as per specifications","Item",1,null,0]
[{"$f":"IF(ISBLANK(C28),\"\",MAX(A$1:$A27)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C29),\"\",MAX(A$1:$A28)+0.01)","v":1.11},"As-built drawings as per specifications","Item",1,null,0]
[{"$f":"IF(ISBLANK(C30),\"\",MAX(A$1:$A29)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C31),\"\",MAX(A$1:$A30)+0.01)","v":1.12},"Scaffolding and equipment","Item",1,null,0]
[{"$f":"IF(ISBLANK(C32),\"\",MAX(A$1:$A31)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C33),\"\",MAX(A$1:$A32)+0.01)","v":""},"Any other items not specifically mentioned in this bill for this section (specify below)",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C34),\"\",MAX(A$1:$A33)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C35),\"\",MAX(A$1:$A34)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C36),\"\",MAX(A$1:$A35)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C37),\"\",MAX(A$1:$A36)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C38),\"\",MAX(A$1:$A37)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C39),\"\",MAX(A$1:$A38)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C40),\"\",MAX(A$1:$A39)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C41),\"\",MAX(A$1:$A40)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C42),\"\",MAX(A$1:$A41)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C43),\"\",MAX(A$1:$A42)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C44),\"\",MAX(A$1:$A43)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C45),\"\",MAX(A$1:$A44)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C46),\"\",MAX(A$1:$A45)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C47),\"\",MAX(A$1:$A46)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C48),\"\",MAX(A$1:$A47)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C49),\"\",MAX(A$1:$A48)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C50),\"\",MAX(A$1:$A49)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C51),\"\",MAX(A$1:$A50)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C52),\"\",MAX(A$1:$A51)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C53),\"\",MAX(A$1:$A52)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C54),\"\",MAX(A$1:$A53)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C55),\"\",MAX(A$1:$A54)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C56),\"\",MAX(A$1:$A55)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C57),\"\",MAX(A$1:$A56)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C58),\"\",MAX(A$1:$A57)+0.01)","v":""},{"$nulls":4},""]
["","SECTION TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(F7:F58)","v":0}]

{"sheet":"Section 2 - SPRINKLERS","index":2,"n_rows":62,"n_cols":6,"rows_kept":62}
[null,"QCTO Hatfield"]
[null,"Fire Engineering Services"]
[null,"Office Fire Protection Systems"]
[null,"Section 02 - Sprinkler Installation"]
[]
["ITEM","Snow Soft","UNIT","QTY","RATE ","TOTAL"]
[2,"SECTION 2 - SPRINKLER INSTALLATION ",{"$nulls":3},{"$f":"IF(ISBLANK(D7),\"\",D7*E7)","v":""}]
[{"$f":"IF(ISBLANK(C8),\"\",MAX(A$1:$A7)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C9),\"\",MAX(A$1:$A8)+0.01)","v":""},"All items in this section shall include all necessary consumables for installation.",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C10),\"\",MAX(A$1:$A9)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C11),\"\",MAX(A$1:$A10)+0.01)","v":""},"Sprinkler Piping and Fittings",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C12),\"\",MAX(A$1:$A11)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C13),\"\",MAX(A$1:$A12)+0.01)","v":""},"Supply and install SANS 62 Medium Wall black steel piping and fittings complete with all pipe supports and hangers",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C14),\"\",MAX(A$1:$A13)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C15),\"\",MAX(A$1:$A14)+0.01)","v":""},"Descriptions of pipes and fittings shall include red paint with a single coat primer and 2 coats enamel paint with a minimum thickness of 25 µm.",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C16),\"\",MAX(A$1:$A15)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C17),\"\",MAX(A$1:$A16)+0.01)","v":2.01},"25 mm","m",{"$f":"6*21+1.5*7+3*7+10*6+8*2+6*27+1.5*4","v":{"v":401.5,"d":"402"}},null,0]
[{"$f":"IF(ISBLANK(C18),\"\",MAX(A$1:$A17)+0.01)","v":{"v":2.0199999999999996,"d":"2.02"}},"32 mm","m",{"$f":"6*14+3*14+1.5*14+6*14+3*14+14*1.5","v":294},null,0]
[{"$f":"IF(ISBLANK(C19),\"\",MAX(A$1:$A18)+0.01)","v":{"v":2.0299999999999994,"d":"2.03"}},"40 mm","m",{"$f":"30*1.5","v":45},null,0]
[{"$f":"IF(ISBLANK(C20),\"\",MAX(A$1:$A19)+0.01)","v":{"v":2.039999999999999,"d":"2.04"}},"50 mm","m",0,null,0]
[{"$f":"IF(ISBLANK(C21),\"\",MAX(A$1:$A20)+0.01)","v":{"v":2.049999999999999,"d":"2.05"}},"65mm","m",0,null,0]
[{"$f":"IF(ISBLANK(C22),\"\",MAX(A$1:$A21)+0.01)","v":{"v":2.0599999999999987,"d":"2.06"}},"80 mm","m",100,null,0]
[{"$f":"IF(ISBLANK(C23),\"\",MAX(A$1:$A22)+0.01)","v":{"v":2.0699999999999985,"d":"2.07"}},"100 mm","m",27,null,0]
[{"$f":"IF(ISBLANK(C24),\"\",MAX(A$1:$A23)+0.01)","v":{"v":2.0799999999999983,"d":"2.08"}},"150 mm","m",0,null,0]
[{"$f":"IF(ISBLANK(C25),\"\",MAX(A$1:$A24)+0.01)","v":{"v":2.089999999999998,"d":"2.09"}},"200 mm","m",0,null,0]
[{"$f":"IF(ISBLANK(C26),\"\",MAX(A$1:$A24)+0.01)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK(D26),\"\",D26*E26)","v":""}]
[{"$f":"IF(ISBLANK(C27),\"\",MAX(A$1:$A26)+0.01)","v":""},"Sprinkler Heads",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C28),\"\",MAX(A$1:$A27)+0.01)","v":""},"Sprinkler heads to be installed as indicated on drawing, including ranges, flanges, connections, fittings, hangers, brackets, threaded rod, etc.  ",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C29),\"\",MAX(A$1:$A28)+0.01)","v":{"v":2.099999999999998,"d":"2.10"}},"Ordinary hazard, 93°C, K80, 15mm brass conventional, standard response with a design density of 5mm/min","No.",290,null,0]
[{"$f":"IF(ISBLANK(C30),\"\",MAX(A$1:$A29)+0.01)","v":{"v":2.1099999999999977,"d":"2.11"}},"High hazard with a design density of 7,5mm/min and activation temperature of 93°C for sprinklers in pump house","No.",6,null,0]
[{"$f":"IF(ISBLANK(C31),\"\",MAX(A$1:$A30)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C32),\"\",MAX(A$1:$A31)+0.01)","v":""},"ICV Chamber ",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C33),\"\",MAX(A$1:$A32)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C34),\"\",MAX(A$1:$A33)+0.01)","v":""},"Supply and installation control valve assembly as per typical detail in accordance with SANS 10287, complete with rack and  roof sprinklers arrangement, fittings, water alarm and test arrangement. \n\nProvision to be made for construction of ICV chamber from double brick masonry walls with concrete screed finish and concrete roof.\n\nWorkshop drawings shall be provided by the contractor and submitted for approval prior to ordering of any materials or beginning construction.\n\nItem rate shall include all necessary fittings and consumables.",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C35),\"\",MAX(A$1:$A34)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C36),\"\",MAX(A$1:$A35)+0.01)","v":{"v":2.1199999999999974,"d":"2.12"}},"Construction of ICV Chamber","Item",1,null,0]
[{"$f":"IF(ISBLANK(C37),\"\",MAX(A$1:$A36)+0.01)","v":{"v":2.1299999999999972,"d":"2.13"}},"100 mm ICV arrangement","No.",1,null,0]
[{"$f":"IF(ISBLANK(C38),\"\",MAX(A$1:$A37)+0.01)","v":{"v":2.139999999999997,"d":"2.14"}},"100 mm flow switch","No.",1,null,0]
[{"$f":"IF(ISBLANK(C39),\"\",MAX(A$1:$A38)+0.01)","v":{"v":2.149999999999997,"d":"2.15"}},"Manifold for 3 ICVs","Item",1,null,0]
[{"$f":"IF(ISBLANK(C40),\"\",MAX(A$1:$A39)+0.01)","v":{"v":2.1599999999999966,"d":"2.16"}},"All statutory signage including fixing.","Item",1,null,0]
[]
[{"$f":"IF(ISBLANK(C42),\"\",MAX(A$1:$A39)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C43),\"\",MAX(A$1:$A42)+0.01)","v":""},"Water Supplies & Pumphouse",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C44),\"\",MAX(A$1:$A43)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C45),\"\",MAX(A$1:$A44)+0.01)","v":{"v":2.1699999999999964,"d":"2.17"}},"New circular steel water storage tanks, 953m³ minimum effective capacity including flanges, connections, fittings, hangers, brackets, vortex inhibitors, water level indicator, water inlets, water outlets to sprinklers pump, valves, drain, etc.","No.",2,null,0]
[{"$f":"IF(ISBLANK(C46),\"\",MAX(A$1:$A45)+0.01)","v":{"v":2.179999999999996,"d":"2.18"}},"New Ø100 suction piping including flanges, isolation valves, connections, fittings, hangers & brackets or stands, etc. complete","m",20,null,0]
[{"$f":"IF(ISBLANK(C47),\"\",MAX(A$1:$A46)+0.01)","v":{"v":2.189999999999996,"d":"2.19"}},"New Ø100 test return piping including flanges, isolation valves, connections, fittings, hangers, brackets, etc. complete","No.",20,null,0]
[{"$f":"IF(ISBLANK(C48),\"\",MAX(A$1:$A47)+0.01)","v":{"v":2.1999999999999957,"d":"2.20"}},"New Ø100 infill piping including flanges, isolation valves, connections, fittings, hangers, brackets, water mains connection at street, etc. complete consisting of uPVC class 16 underground pipe and painted black medium pipe surface.","No.",20,null,0]
[{"$f":"IF(ISBLANK(C49),\"\",MAX(A$1:$A48)+0.01)","v":{"v":2.2099999999999955,"d":"2.21"}},"Ø100 main u/ground steel piping from pump house to connection in ICV chamber, including flanges, non-return check valves, connections, fittings, brackets, thrust blocks, Denso wrap, end-cap, etc. complete.","No.",20,null,0]
[{"$f":"IF(ISBLANK(C50),\"\",MAX(A$1:$A49)+0.01)","v":{"v":2.2199999999999953,"d":"2.22"}},"Complete pump room piping including auto start arrangement, GVI Test flow meter, etc. (Pump room to be constructed by others)","No.",1,null,0]
[{"$f":"IF(ISBLANK(C51),\"\",MAX(A$1:$A50)+0.01)","v":{"v":2.229999999999995,"d":"2.23"}},"Complete diesel and electric Driven pumps to ASIB Standards;  1,357 L/min @ 3.62 bar operating capacity as per specification, complete with control panels","No.",1,null,0]
[{"$f":"IF(ISBLANK(C52),\"\",MAX(A$1:$A51)+0.01)","v":{"v":2.239999999999995,"d":"2.24"}},"Complete jockey or make-up pump","No.",1,null,0]
[{"$f":"IF(ISBLANK(C53),\"\",MAX(A$1:$A52)+0.01)","v":{"v":2.2499999999999947,"d":"2.25"}},"Complete enunciator panel","No.",1,null,0]
[{"$f":"IF(ISBLANK(C54),\"\",MAX(A$1:$A52)+0.01)","v":{"v":2.2499999999999947,"d":"2.25"}},"Complete electrical installation including electrical cable from nearest suitable DB,  electrical distribution board suitable for jockey pump and battery chargers, main power supply make-off in panel, etc","Item",1,null,0]
[{"$f":"IF(ISBLANK(C55),\"\",MAX(A$1:$A53)+0.01)","v":{"v":2.2599999999999945,"d":"2.26"}},"3-Phase 380 VAC DB in pump house fed from 60A CB  mains supply. ","Item",1,null,0]
[{"$f":"IF(ISBLANK(C56),\"\",MAX(A$1:$A54)+0.01)","v":{"v":2.2599999999999945,"d":"2.26"}},"All statutory signage including fixing.","Item",1,null,0]
[]
[{"$f":"IF(ISBLANK(C58),\"\",MAX(A$1:$A50)+0.01)","v":""},"Any other items not specifically mentioned in this bill for this section (specify below)",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C59),\"\",MAX(A$1:$A58)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C60),\"\",MAX(A$1:$A59)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C61),\"\",MAX(A$1:$A60)+0.01)","v":""},{"$nulls":4},""]
["","SECTION TOTAL"]

{"sheet":"Section 3 - EQUIPMENT & SIGNAGE","index":3,"n_rows":51,"n_cols":6,"rows_kept":51}
[null,"QCTO Hatfield"]
[null,"Fire Engineering Services"]
[null,"Office Fire Protection Systems"]
[null,"Section 03 - Equipment & Signage"]
[]
["ITEM","Snow Soft","UNIT","QTY","RATE ","TOTAL"]
[3,"SECTION 3 - EQUIPMENT & SIGNAGE",{"$nulls":3},{"$f":"IF(ISBLANK(D7),\"\",D7*E7)","v":""}]
[{"$f":"IF(ISBLANK(C8),\"\",MAX(A$1:$A7)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C9),\"\",MAX(A$1:$A8)+0.01)","v":""},"Fire Equipment",{"$nulls":3},""]
[null,"Supply and install equipment as listed below complete with wooden mounting board",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C11),\"\",MAX(A$1:$A10)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C12),\"\",MAX(A$1:$A11)+0.01)","v":3.01},"4.5 kg DCP Fire extinguisher","No.",0,null,0]
[{"$f":"IF(ISBLANK(C13),\"\",MAX(A$1:$A12)+0.01)","v":{"v":3.0199999999999996,"d":"3.02"}},"30 m fire hose reel","No.",6,null,0]
[{"$nulls":5},""]
[{"$f":"IF(ISBLANK(C15),\"\",MAX(A$1:$A14)+0.01)","v":""},"Fire Doors",{"$nulls":3},""]
[{"$nulls":5},""]
[{"$f":"IF(ISBLANK(C17),\"\",MAX(A$1:$A13)+0.01)","v":{"v":3.0299999999999994,"d":"3.03"}},"Class B - server room & archive","No ",4,null,0]
[{"$f":"IF(ISBLANK(C18),\"\",MAX(A$1:$A14)+0.01)","v":{"v":3.0299999999999994,"d":"3.03"}},"Push bars or thumb turns in existing emergency escape and exit doors","No ",3,null,0]
[{"$f":"IF(ISBLANK(C19),\"\",MAX(A$1:$A18)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C20),\"\",MAX(A$1:$A19)+0.01)","v":""},"Signage - 190 x 190 mm",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C21),\"\",MAX(A$1:$A20)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C22),\"\",MAX(A$1:$A21)+0.01)","v":""},"Supply and install framed photoluminescent safety and equipment signage fixed to walls using screws or cantilevers or suspended from trusses/ceilings using stainless steel cables",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C23),\"\",MAX(A$1:$A22)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C24),\"\",MAX(A$1:$A23)+0.01)","v":""},"Single Sided Fixed to Wall",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C25),\"\",MAX(A$1:$A24)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(#REF!),\"\",MAX(A$1:$A25)+0.01)","v":{"v":3.039999999999999,"d":"3.04"}},"E1 / E2 / E10 - Exit right / left / ahead","No.",10,null,0]
[{"$f":"IF(ISBLANK(C26),\"\",MAX(A$1:$A26)+0.01)","v":{"v":3.049999999999999,"d":"3.05"}},"E6 - Exit here","No.",7,null,0]
[{"$f":"IF(ISBLANK(C27),\"\",MAX(A$1:$A27)+0.01)","v":{"v":3.0599999999999987,"d":"3.06"}},"F4 / F5 / F6 - FE and HR here / left / right","No.",12,null,0]
[{"$f":"IF(ISBLANK(C28),\"\",MAX(A$1:$A28)+0.01)","v":{"v":3.0699999999999985,"d":"3.07"}},"F45 - Fire exit keep clear","No.",7,null,0]
[{"$f":"IF(ISBLANK(C29),\"\",MAX(A$1:$A29)+0.01)","v":{"v":3.0799999999999983,"d":"3.08"}},"F1 / F2 / F3 - HYD, FE, HR here / left / right","No.",5,null,0]
[{"$nulls":5},""]
[{"$f":"IF(ISBLANK(C31),\"\",MAX(A$1:$A31)+0.01)","v":""},"Double-Sided Suspended",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C32),\"\",MAX(A$1:$A32)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(#REF!),\"\",MAX(A$1:$A33)+0.01)","v":{"v":3.089999999999998,"d":"3.09"}},"E1 / E2 / E10 - Exit right / left / ahead","No.",10,null,0]
[{"$f":"IF(ISBLANK(#REF!),\"\",MAX(A$1:$A34)+0.01)","v":{"v":3.099999999999998,"d":"3.10"}},"F4 / F5 / F6 - FE and HR here / left / right","No.",5,null,0]
[{"$nulls":5},""]
[null,"Any other items not specifically mentioned in this bill for this section (specify below)"]
[]
[]
[{"$nulls":5},{"$f":"IF(ISBLANK(D40),\"\",D40*E40)","v":""}]
[]
[]
[]
[{"$f":"IF(ISBLANK(C44),\"\",MAX(A$1:$A6)+0.01)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK(D44),\"\",D44*E44)","v":""}]
[{"$f":"IF(ISBLANK(C45),\"\",MAX(A$1:$A44)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C46),\"\",MAX(A$1:$A45)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C47),\"\",MAX(A$1:$A46)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C48),\"\",MAX(A$1:$A47)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C49),\"\",MAX(A$1:$A48)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C50),\"\",MAX(A$1:$A49)+0.01)","v":""},{"$nulls":4},""]
["","SECTION TOTAL",{"$nulls":3},{"$f":"SUM(F7:F50)","v":0}]

{"sheet":"Section 4 - DETECTION & GAS SUP","index":4,"n_rows":70,"n_cols":6,"rows_kept":70}
[null,"QCTO Hatfield"]
[null,"Fire Engineering Services"]
[null,"Office Fire Protection Systems"]
[null,"Section 04 - Detection & Gas Suppression"]
[]
["ITEM","Snow Soft","UNIT","QTY","RATE ","TOTAL"]
[4,"SECTION 4 - DETECTION & GAS SUPPRESSION",{"$nulls":3},{"$f":"IF(ISBLANK(D7),\"\",D7*E7)","v":""}]
[{"$f":"IF(ISBLANK(C8),\"\",MAX(A$1:$A7)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C9),\"\",MAX(A$1:$A8)+0.01)","v":""},"Analogue Addressable Fire Alarm Panel ",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C10),\"\",MAX(A$1:$A9)+0.01)","v":4.01},"Allow for the procurement, delivery, installation, connection, testing and commissioning of a four loop analogue addressable fire detection and alarm system control panel.","No ",1,null,0]
[{"$f":"IF(ISBLANK(C11),\"\",MAX(A$1:$A10)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C12),\"\",MAX(A$1:$A11)+0.01)","v":4.02},"Allow for 220VAC isolator located above FAP to be done by registered electrician.","No.",1,null,0]
[{"$f":"IF(ISBLANK(C13),\"\",MAX(A$1:$A12)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C14),\"\",MAX(A$1:$A13)+0.01)","v":""},"Network Card",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C15),\"\",MAX(A$1:$A14)+0.01)","v":{"v":4.029999999999999,"d":"4.03"}},"Allow for the procurement, installation, testing and commissioning of fault tolerant network card.","No ",1,null,0]
[{"$f":"IF(ISBLANK(C16),\"\",MAX(A$1:$A15)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C17),\"\",MAX(A$1:$A16)+0.01)","v":""},"Stand By Batteries",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C18),\"\",MAX(A$1:$A17)+0.01)","v":{"v":4.039999999999999,"d":"4.04"}},"Allow for the procurement, delivery, installation, connection, testing and commissioning of stand by batteries for 24 hour back up and 30 minutes under full alarm load.","No ",2,null,0]
[{"$f":"IF(ISBLANK(C19),\"\",MAX(A$1:$A18)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C20),\"\",MAX(A$1:$A19)+0.01)","v":""},"Lightning Protection Units"]
[{"$f":"IF(ISBLANK(C21),\"\",MAX(A$1:$A20)+0.01)","v":{"v":4.049999999999999,"d":"4.05"}},"Allow for procurement and installation of lightning protection units on the mains power supply to the panel","No.",1,null,{"$f":"IF(ISBLANK(D21),\"\",D21*E21)","v":0}]
[{"$f":"IF(ISBLANK(C22),\"\",MAX(A$1:$A21)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C23),\"\",MAX(A$1:$A22)+0.01)","v":""},"Logbook"]
[{"$f":"IF(ISBLANK(C24),\"\",MAX(A$1:$A23)+0.01)","v":{"v":4.059999999999999,"d":"4.06"}},"A log book to be Installed in a holder and installed adjacent to master fire panel","No ",1,null,0]
[{"$f":"IF(ISBLANK(C25),\"\",MAX(A$1:$A24)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C26),\"\",MAX(A$1:$A25)+0.01)","v":""},"Block Plan",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C27),\"\",MAX(A$1:$A26)+0.01)","v":{"v":4.0699999999999985,"d":"4.07"}},"Provide zone diagram and associated signage, laminated and framed behind glass for the fire panel","No",1,null,0]
[{"$f":"IF(ISBLANK(C28),\"\",MAX(A$1:$A27)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C29),\"\",MAX(A$1:$A28)+0.01)","v":""},"Analogue Addressable Fire Detectors And Bases",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C30),\"\",MAX(A$1:$A29)+0.01)","v":""},"Allow for the procurement, installation, testing and commissioning of analogue addressable fire detectors and bases as follows:",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C31),\"\",MAX(A$1:$A30)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C32),\"\",MAX(A$1:$A31)+0.01)","v":{"v":4.079999999999998,"d":"4.08"}},"Optical smoke detectors","No ",6,null,0]
[{"$f":"IF(ISBLANK(C33),\"\",MAX(A$1:$A32)+0.01)","v":{"v":4.089999999999998,"d":"4.09"}},"Optical smoke detectors","No ",6,null,0]
[{"$f":"IF(ISBLANK(C34),\"\",MAX(A$1:$A32)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C35),\"\",MAX(A$1:$A34)+0.01)","v":""},"Analogue Addressable Manual Call Points",{"$nulls":3},""]
[{"$f":"IF(ISBLANK(C36),\"\",MAX(A$1:$A35)+0.01)","v":{"v":4.099999999999998,"d":"4.10"}},"Allow for the procurement, installation, testing and commissioning of analogue addressable manual fire alarm call points with re-settable elements and protective covers","No",7,null,0]
[{"$f":"IF(ISBLANK(C37),\"\",MAX(A$1:$A36)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C38),\"\",MAX(A$1:$A37)+0.01)","v":""}," Analogue Addressable Siren/Strobe"]
[{"$f":"IF(ISBLANK(C39),\"\",MAX(A$1:$A38)+0.01)","v":{"v":4.109999999999998,"d":"4.11"}},"Allow for the procurement, installation, testing and commissioning of analogue addressable fire siren and strobe units.","No",12,null,{"$f":"IF(ISBLANK(D39),\"\",D39*E39)","v":0}]
[{"$f":"IF(ISBLANK(C40),\"\",MAX(A$1:$A39)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C41),\"\",MAX(A$1:$A40)+0.01)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK(D41),\"\",D41*E41)","v":""}]
[{"$f":"IF(ISBLANK(C42),\"\",MAX(A$1:$A41)+0.01)","v":""},"Line Isolators"]
[{"$f":"IF(ISBLANK(C43),\"\",MAX(A$1:$A42)+0.01)","v":{"v":4.119999999999997,"d":"4.12"}},"Allow for the procurement, installation, testing and commissioning of line isolators","No",2,null,{"$f":"IF(ISBLANK(D43),\"\",D43*E43)","v":0}]
[{"$f":"IF(ISBLANK(C44),\"\",MAX(A$1:$A43)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C45),\"\",MAX(A$1:$A44)+0.01)","v":""},"Fire Resistive Cabling"]
[{"$f":"IF(ISBLANK(C46),\"\",MAX(A$1:$A45)+0.01)","v":{"v":4.129999999999997,"d":"4.13"}},"PH30, 2 core, 1.5mm","m",{"v":1000,"d":"1,000"},null,{"$f":"IF(ISBLANK(D46),\"\",D46*E46)","v":0}]
[{"$f":"IF(ISBLANK(C47),\"\",MAX(A$1:$A46)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C48),\"\",MAX(A$1:$A47)+0.01)","v":""},"Conduit And Couplings"]
[{"$f":"IF(ISBLANK(C49),\"\",MAX(A$1:$A48)+0.01)","v":""},"Allow for procurement and installation of galvanised metal conduit (with necessary couplings, junction boxes, etc.)\nConduit to be fixed every 1m with steel saddles.",{"$nulls":3},{"$f":"IF(ISBLANK(D49),\"\",D49*E49)","v":""}]
[{"$f":"IF(ISBLANK(C50),\"\",MAX(A$1:$A49)+0.01)","v":{"v":4.139999999999997,"d":"4.14"}},"25mm","m",20]
[]
[{"$f":"IF(ISBLANK(C52),\"\",MAX(A$1:$A51)+0.01)","v":""},"Gas Suppression"]
[null,"Supply and install clean gas agent (FM200) and detection panel for protection of the below listed volumetric enclosures.","m",{"v":1000,"d":"1,000"},null,{"$f":"IF(ISBLANK(D53),\"\",D53*E53)","v":0}]
[{"$f":"IF(ISBLANK(C54),\"\",MAX(A$1:$A53)+0.01)","v":{"v":4.149999999999997,"d":"4.15"}},"Server Room (97m3)","kg",null,null,""]
[{"$f":"IF(ISBLANK(C55),\"\",MAX(A$1:$A54)+0.01)","v":{"v":4.159999999999997,"d":"4.16"}},"Archive Room (945m3)","kg",null,null,""]
[{"$nulls":5},""]
[null,"Any other items not specifically mentioned in this bill for this section (specify below)"]
[]
[{"$f":"IF(ISBLANK(C59),\"\",MAX(A$1:$A58)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C60),\"\",MAX(A$1:$A59)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C61),\"\",MAX(A$1:$A60)+0.01)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK(D61),\"\",D61*E61)","v":""}]
[{"$f":"IF(ISBLANK(C62),\"\",MAX(A$1:$A61)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C63),\"\",MAX(A$1:$A62)+0.01)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK(D63),\"\",D63*E63)","v":""}]
[{"$f":"IF(ISBLANK(C64),\"\",MAX(A$1:$A63)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C65),\"\",MAX(A$1:$A64)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C66),\"\",MAX(A$1:$A65)+0.01)","v":""},{"$nulls":4},""]
[]
[{"$f":"IF(ISBLANK(C68),\"\",MAX(A$1:$A67)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C69),\"\",MAX(A$1:$A68)+0.01)","v":""},{"$nulls":4},""]
["","SECTION TOTAL",{"$nulls":3},{"$f":"SUM(F7:F69)","v":0}]

{"sheet":"Section 5 - Existing equipment ","index":5,"n_rows":18,"n_cols":6,"rows_kept":18}
[null,"QCTO Hatfield"]
[null,"Fire Engineering Services"]
[null,"Office Fire Protection Systems"]
[null,"Section 05 - Existing equipment"]
[]
["ITEM",null,"UNIT","QTY","RATE ","TOTAL"]
[5,"SECTION 4 - EXISTING EQUIPMENT ",{"$nulls":3},{"$f":"IF(ISBLANK(D7),\"\",D7*E7)","v":""}]
[{"$f":"IF(ISBLANK(C8),\"\",MAX(A$1:$A7)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C9),\"\",MAX(A$1:$A8)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C10),\"\",MAX(A$1:$A9)+0.01)","v":5.01},"Regular testing of fire detection and suppression system to make sure they will be ready to effectively respond in the event of fire.","No ",1,null,0]
[{"$f":"IF(ISBLANK(C11),\"\",MAX(A$1:$A10)+0.01)","v":""}]
[{"$f":"IF(ISBLANK(C12),\"\",MAX(A$1:$A11)+0.01)","v":5.02},"Monthly testing of power supply, performance tests, visual sound and smoke management","No.",1,null,0]
[{"$f":"IF(ISBLANK(C13),\"\",MAX(A$1:$A12)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C14),\"\",MAX(A$1:$A13)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C15),\"\",MAX(A$1:$A14)+0.01)","v":{"v":5.029999999999999,"d":"5.03"}},"Monthly InspectIion of  fire panel and lines to fire sensors zones","No ",1,null,0]
[{"$f":"IF(ISBLANK(C16),\"\",MAX(A$1:$A15)+0.01)","v":""},{"$nulls":4},""]
[{"$f":"IF(ISBLANK(C17),\"\",MAX(A$1:$A16)+0.01)","v":""},{"$nulls":4},{"$f":"IF(ISBLANK(D17),\"\",D17*E17)","v":""}]
["","SECTION TOTAL",{"$nulls":3},{"$f":"SUM(F7:F17)","v":0}]

{"sheet":"Sect","index":6,"n_rows":3,"n_cols":1,"rows_kept":3}
["1. Regular testing of fire detection and suppression system to make sure they will be ready to effectively respond in the event of fire."]
["2. Monthly testing of power supply, performance tests, visual sound and smoke management"]
["3. Monthly Inspect any fault from fire panel and lines to fire sensors zones"]

{"sheet":"Sheet3","index":7,"n_rows":0,"n_cols":0,"rows_kept":0}