{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Cover Page","Preliminaries & Generals","Gas Suppression Test","Summary"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":23,"n_cols":1,"rows_kept":23,"merged":[[22,0,29,5]]}
{"$rows_empty":22}
["BILL OF MATERIALS\n \nBUILDING 22 ARCHIVE ROOMS GAS SUPPRESSION ONCE OFF 10 YEARLY PRESSURE TESTING AND MAINTENANCE OF ALL ASSOSCIATED COMPONENTS"]

{"sheet":"Preliminaries & Generals","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"merged":[[5,0,5,5]]}
[]
["SUBJECT :  BILL OF QUANTITIES"]
[]
["PART 1       "]
[]
["BUILDING 22 ARCHIVE ROOMS GAS SUPPRESSION ONCE OFF 10 YEARLY PRESSURE TESTING AND MAINTENANCE OF ALL ASSOSCIATED COMPONENTS"]
["BILL NO. 1 - PRELIMINARIES & GENERAL"]
[]
["ITEM NO","DESCRIPTION","UNIT","RATE","TENDERED BOQ QUANTITY","TENDERED AMOUNT"]
[]
[null,"Preliminaries and General"]
[]
[{"$f":"1+0.001","v":1.001},"Twelve month guarantee","sum",0,1,{"$f":"D13*E13","v":0}]
[]
[{"$f":"A13+0.001","v":{"v":1.0019999999999998,"d":"1.002"}},"Transportation","sum",0,1,0]
[]
[{"$f":"A15+0.001","v":{"v":1.0029999999999997,"d":"1.003"}},"Hiring of scaffolding and Rigging of the equipments","sum",0,1,{"$f":"D17*E17","v":0}]
[]
[{"$f":"A17+0.001","v":{"v":1.0039999999999996,"d":"1.004"}},"Issuing of Compliance Certificate (COC)","sum",0,1,{"$f":"D19*E19","v":0}]
{"$rows_empty":8}
[null,"TOTAL CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F11:F20)","v":0}]

{"sheet":"Gas Suppression Test","index":2,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[5,0,5,5]]}
[]
["SUBJECT :  BILL OF QUANTITIES"]
[]
["PART 2     "]
[]
[{"$f":"'Preliminaries & Generals'!A6","v":"BUILDING 22 ARCHIVE ROOMS GAS SUPPRESSION ONCE OFF 10 YEARLY PRESSURE TESTING AND MAINTENANCE OF ALL ASSOSCIATED COMPONENTS"}]
["BILL NO. 2 - FIRE"]
[]
["ITEM NO","DESCRIPTION","UNIT","RATE","TENDERED BOQ QUANTITY","TENDERED AMOUNT"]
[]
[null,"BUILDING 22 ARCHIVE ROOM"]
[]
[{"$f":"2+0.001","v":2.001},"Removal of cylinders for hydrotesting","No",0,14,{"$f":"D13*E13","v":0}]
[{"$f":"A13+0.001","v":2.002},"10 yearly cylinders pressure testing (total weight is 80kg each cylinder)","No",0,14,0]
[{"v":2.0029999999999997,"d":"2.003"},"Refill 14 x cylinders with the appropriate fire suppression agent (HFC-227) ","Sum",0,1,{"$f":"D15*E15","v":0}]
[{"v":2.0039999999999996,"d":"2.004"},"Testing of all assosciatd components for proper functioality such as control panels, detectors, and detonators or electromagnetic release devices, electrical wiring and all other relevant components. ","Sum",0,1,{"$f":"D16*E16","v":0}]
[{"v":2.0049999999999994,"d":"2.005"},"Testing, commissioning & programming of gas suppression, fire detection & alarm system","Sum",0,1,{"$f":"D17*E17","v":0}]
{"$rows_empty":18}
[null,"TOTAL CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F10:F33)","v":0}]

{"sheet":"Summary","index":3,"n_rows":31,"n_cols":5,"rows_kept":31,"merged":[[5,0,5,4],[36,0,36,1]]}
[]
["SUBJECT :  BILL OF QUANTITIES"]
[]
["PART 3"]
[]
[{"$f":"'Gas Suppression Test'!A6","v":"BUILDING 22 ARCHIVE ROOMS GAS SUPPRESSION ONCE OFF 10 YEARLY PRESSURE TESTING AND MAINTENANCE OF ALL ASSOSCIATED COMPONENTS"}]
["BILL NO. 3 - SUMMARY"]
[]
["ITEM NO","DESCRIPTION","FROM PART NO.","PAGE NO.","TENDERED AMOUNT"]
[]
[null,"MAIN OFFER"]
[]
[]
[{"$f":"3+0.001","v":3.001},"PRELIMINARIES & GENERALS",1,null,{"$f":"'Preliminaries & Generals'!F28","v":0}]
[{"$f":"A14+0.001","v":3.002},"GAS SUPPRESSION TEST",2,null,{"$f":"'Gas Suppression Test'!F36","v":0}]
[]
[]
[]
[]
[]
[]
[null,"SUB TOTAL 1",null,null,{"$f":"SUM(E11:E16)","v":0}]
[]
[null,"ADD 10% CONTINGENCY ",null,null,0]
[]
[null,"SUB TOTAL 2",null,null,{"$f":"SUM(E22,E24)","v":0}]
[]
[]
[null,"ADD 15% VAT",null,null,{"$f":"E26*15%","v":0}]
[]
[null,"TOTAL",null,null,{"$f":"SUM(E26,E29)","v":0}]