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

{"sheet":"Cover Page","index":0,"n_rows":21,"n_cols":4,"rows_kept":21,"merged":[[0,0,12,4],[13,0,13,4]]}
{"$rows_empty":13}
["ANNEXURE D - BILL OF QUANTITIES "]
[]
[]
["RFP NO:",null,null,"RFP No. 6596/29/10/2025"]
[]
["RFP NAME:",null,null,"Provision of the design, supply, installation and commissioning of gas suppression and fire detection and alarm systems in Rooms 27 and 31 at CSIR Rosebank (Cape Town."]
[]
["BIDDER NAME"]

{"sheet":"Preliminaries & Generals","index":1,"n_rows":49,"n_cols":6,"rows_kept":49,"merged":[[1,0,2,5],[3,0,3,5],[5,0,5,5],[6,0,6,5],[45,0,45,1],[45,3,45,4],[48,0,48,1],[48,3,48,4]]}
[]
["SUBJECT :  BILL OF QUANTITIES"]
[]
["PART 1       "]
[]
[{"$f":"'Cover Page'!D19","v":"Provision of the design, supply, installation and commissioning of gas suppression and fire detection and alarm systems in Rooms 27 and 31 at CSIR Rosebank (Cape Town."}]
["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},"Establishment of Site","sum",0,1,{"$f":"D13*E13","v":0}]
[]
[{"$f":"A13+0.001","v":{"v":1.0019999999999998,"d":"1.002"}},"Twelve month guarantee","sum",0,1,0]
[]
[{"$f":"A15+0.001","v":{"v":1.0029999999999997,"d":"1.003"}},"Workshop drawings","sum",0,1,0]
[]
[{"$f":"A17+0.001","v":{"v":1.0039999999999996,"d":"1.004"}},"As-Built drawings","sum",0,1,0]
[]
[{"$f":"A19+0.001","v":{"v":1.0049999999999994,"d":"1.005"}},"Builder's work & making good","sum",0,1,0]
[]
[{"$f":"A21+0.001","v":{"v":1.0059999999999993,"d":"1.006"}},"Testing, commissioning & programming of gas suppression, fire detection & alarm system","sum",0,1,0]
[]
[{"$f":"A23+0.001","v":{"v":1.0069999999999992,"d":"1.007"}},"Transportation","sum",0,1,0]
[]
[{"$f":"A25+0.001","v":{"v":1.0079999999999991,"d":"1.008"}},"Hiring of scaffolding and Rigging of the equipments","sum",0,1,{"$f":"D27*E27","v":0}]
[]
[{"$f":"A27+0.001","v":{"v":1.008999999999999,"d":"1.009"}},"Issuing of Compliance Certificate (COC)","sum",0,1,{"$f":"D29*E29","v":0}]
[]
[{"$f":"A29+0.001","v":{"v":1.009999999999999,"d":"1.010"}},"Training of staff","sum",0,1,{"$f":"D31*E31","v":0}]
[]
[{"$f":"A31+0.001","v":{"v":1.0109999999999988,"d":"1.011"}},"Handover documentation 1 x archlever file & 1 x flashdrive","sum",0,1,{"$f":"D33*E33","v":0}]
[]
[]
[]
[]
[]
[]
[null,"TOTAL CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F11:F31)","v":0}]
[]
[]
[]
[]
[]
["Company Representative: Name",null,null,"Capacity"]
[]
[]
["Signature",null,null,"Date"]

{"sheet":"Fire","index":2,"n_rows":32,"n_cols":6,"rows_kept":32,"merged":[[1,0,2,5],[3,0,3,5],[5,0,5,5],[6,0,6,5],[28,0,28,1],[28,3,28,4],[31,0,31,1],[31,3,31,4]]}
[]
["SUBJECT :  BILL OF QUANTITIES"]
[]
["PART 2     "]
[]
[{"$f":"'Preliminaries & Generals'!A6","v":"Provision of the design, supply, installation and commissioning of gas suppression and fire detection and alarm systems in Rooms 27 and 31 at CSIR Rosebank (Cape Town."}]
["BILL NO. 2 - FIRE"]
[]
["ITEM NO","DESCRIPTION","UNIT","RATE","TENDERED BOQ QUANTITY","TENDERED AMOUNT"]
[]
[null,"BUILDING 2 "]
[]
[{"$f":"2+0.001","v":2.001},"Design of Energen gas suppression, fire detection and alarm systems in accordance with SANS 14520 for room 27. The room sizes are 23 meter square and 3 meter high (FFL to Soffit of slab.)","Sum",0,1,{"$f":"D13*E13","v":0}]
[{"$f":"A13+0.001","v":2.002},"Design of Energen gas suppression, fire detection and alarm systems in accordance with SANS 14520 for room 31. The room sizes are 21 meter square and 3 meter high (FFL to Soffit of slab.)","Sum",0,1,{"$f":"D14*E14","v":0}]
[{"$f":"A14+0.001","v":{"v":2.0029999999999997,"d":"2.003"}},"Construction (procurement of materials for the installation, this will include all smoke detectors, wiring, conduits, gas cylinders, pipes, nozzles etc) - devices to be compatible to the selected Gas Control Panel (GCU).","Sum",0,1,0]
[{"$f":"A15+0.001","v":{"v":2.0039999999999996,"d":"2.004"}},"Allow for fire detection configuration/interfacing to HVAC system. ","Sum",0,1,{"$f":"D16*E16","v":0}]
[{"v":2.0049999999999994,"d":"2.005"},"Conduct room integrity test and resolve all non-compliance items to make the compliant","Sum",0,1,{"$f":"D17*E17","v":0}]
[2.006,"Manufacture, supply and install 120 min Class D Fire Door (Manufactured to SANS1253:2016), including frame. Class D Capped & Cladded Double Fire Door, 1340X2330 with 280mm steel frame to suit. Accoustic rated with peremiter and drop down seals to be included.","Sum",0,1,0]
[2.007,"Manufacture, supply and install 120 min Class D Fire Door (Manufactured to SANS1253:2016), including frame. Class D Capped & Cladded Double Fire Door, 1380X2350 with 280mm steel frame to suit.Accoustic rated with perimeter and drop down seals to be included.","Sum",0,1,0]
[2.008,"Design and installation sign off by registered Professional Engineer or Technologist with ECSA.","Sum",0,1,{"$f":"D20*E20","v":0}]
[]
[]
[null,"TOTAL CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F10:F20)","v":0}]
[]
[]
[]
[]
[]
["Company Representative: Name",null,null,"Capacity"]
[]
[]
["Signature",null,null,"Date"]

{"sheet":"Summary","index":3,"n_rows":43,"n_cols":5,"rows_kept":43,"merged":[[1,0,2,4],[3,0,3,4],[5,0,5,4],[6,0,6,4],[32,0,32,4],[33,0,33,4],[39,0,39,1],[39,3,39,4],[42,0,42,1],[42,3,42,4]]}
[]
["SUBJECT :  BILL OF QUANTITIES"]
[]
["PART 3"]
[]
[{"$f":"Fire!A6","v":"Provision of the design, supply, installation and commissioning of gas suppression and fire detection and alarm systems in Rooms 27 and 31 at CSIR Rosebank (Cape Town."}]
["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'!F40","v":0}]
[{"$f":"A13+0.001","v":3.002},"FIRE",2,null,{"$f":"Fire!F23","v":0}]
[]
[]
[null,"SUB TOTAL 1",null,null,{"$f":"SUM(E11:E14)","v":0}]
[]
[null,"ADD 10% CONTINGENCY ",null,null,0]
[]
[null,"SUB TOTAL 2",null,null,{"$f":"SUM(E17,E19)","v":0}]
[]
[]
[null,"ADD 15% VAT",null,null,{"$f":"E21*15%","v":0}]
[]
[null,"TRADE DISCOUNT",null,null,{"$f":"SUM(E19,E22)","v":0}]
[]
[null,"TOTAL",null,null,{"$f":"(E21+E24)-E26","v":0}]
[]
[null,"SETTLEMENT DISCOUNT",null,null,{"$f":"SUM(E23,E26)","v":0}]
[]
["Definition of discounts "]
["·         A settlement discount is where a business offers the CSIR a discount when an invoice is paid on time or within 45 days from receipt of the statement."]
["·         A trade discount is defined as a type of discount that is cut off the retail or proposal price of an item. The discount is immediately deducted from the proposal price."]
[]
[]
[]
[]
[]
["Company Representative: Name",null,null,"Capacity"]
[]
[]
["Signature",null,null,"Date"]