{"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.1/26/02/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":43,"n_cols":6,"rows_kept":43,"merged":[[1,0,1,5],[2,0,2,5],[3,0,3,5],[4,0,4,5],[39,0,39,1],[39,3,39,4],[42,0,42,1],[42,3,42,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 excl. VAT","TENDERED BOQ QUANTITY","TENDERED AMOUNT"]
[]
[null,"Preliminaries and General"]
[]
[{"$f":"1+0.001","v":1.001},"Establishment of Site","sum",0,1,{"$f":"D11*E11","v":0}]
[]
[{"$f":"A11+0.001","v":{"v":1.0019999999999998,"d":"1.002"}},"Twelve month guarantee","sum",0,1,{"$f":"D13*E13","v":0}]
[]
[{"$f":"A13+0.001","v":{"v":1.0029999999999997,"d":"1.003"}},"Workshop drawings","sum",0,1,{"$f":"D15*E15","v":0}]
[]
[{"$f":"A15+0.001","v":{"v":1.0039999999999996,"d":"1.004"}},"As-Built drawings","sum",0,1,{"$f":"D17*E17","v":0}]
[]
[{"$f":"A17+0.001","v":{"v":1.0049999999999994,"d":"1.005"}},"Builder's work & making good","sum",0,1,{"$f":"D19*E19","v":0}]
[]
[{"$f":"A19+0.001","v":{"v":1.0059999999999993,"d":"1.006"}},"Testing, commissioning & programming of gas suppression, fire detection & alarm system","sum",0,1,{"$f":"D21*E21","v":0}]
[]
[{"$f":"A21+0.001","v":{"v":1.0069999999999992,"d":"1.007"}},"Transportation","sum",0,1,{"$f":"D23*E23","v":0}]
[]
[{"$f":"A23+0.001","v":{"v":1.0079999999999991,"d":"1.008"}},"Hiring of scaffolding and Rigging of the equipments","sum",0,1,{"$f":"D25*E25","v":0}]
[]
[{"$f":"A25+0.001","v":{"v":1.008999999999999,"d":"1.009"}},"Issuing of Compliance Certificate (COC)","sum",0,1,{"$f":"D27*E27","v":0}]
[]
[{"$f":"A27+0.001","v":{"v":1.009999999999999,"d":"1.010"}},"Training of staff","sum",0,1,{"$f":"D29*E29","v":0}]
[]
[{"$f":"A29+0.001","v":{"v":1.0109999999999988,"d":"1.011"}},"Handover documentation 1 x archlever file & 1 x flashdrive","sum",0,1,{"$f":"D31*E31","v":0}]
[]
[]
[null,"TOTAL CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F9:F29)","v":0}]
[]
[]
[]
[]
[]
["Company Representative: Name",null,null,"Capacity"]
[]
[]
["Signature",null,null,"Date"]

{"sheet":"Fire","index":2,"n_rows":31,"n_cols":6,"rows_kept":31,"merged":[[1,0,1,5],[2,0,2,5],[4,0,4,5],[5,0,5,5],[27,0,27,1],[27,3,27,4],[30,0,30,1],[30,3,30,4]]}
[]
["SUBJECT :  BILL OF QUANTITIES"]
["PART 2     "]
[]
[{"$f":"'Preliminaries & Generals'!A4","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":"D12*E12","v":0}]
[{"$f":"A12+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":"D13*E13","v":0}]
[{"$f":"A13+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) for Rooms 27 and 31.","Sum",0,1,0]
[{"$f":"A14+0.001","v":{"v":2.0039999999999996,"d":"2.004"}},"Allow for fire detection configuration/interfacing to HVAC system for Rooms 27 and 31. ","Sum",0,1,{"$f":"D15*E15","v":0}]
[{"$f":"A15+0.001","v":{"v":2.0049999999999994,"d":"2.005"}},"Conduct a room integrity test and resolve all non-compliance items to make the rooms compliant for Rooms 27 and 31.","Sum",0,1,{"$f":"D16*E16","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 20mm 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":"D19*E19","v":0}]
[]
[]
[null,"TOTAL CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F9:F19)","v":0}]
[]
[]
[]
[]
[]
["Company Representative: Name",null,null,"Capacity"]
[]
[]
["Signature",null,null,"Date"]

{"sheet":"Summary","index":3,"n_rows":41,"n_cols":5,"rows_kept":41,"merged":[[1,0,2,4],[3,0,3,4],[5,0,5,4],[6,0,6,4],[30,0,30,4],[31,0,31,4],[37,0,37,1],[37,3,37,4],[40,0,40,1],[40,3,40,4]]}
[]
["SUBJECT :  BILL OF QUANTITIES"]
[]
["PART 3"]
[]
[{"$f":"Fire!A5","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'!F34","v":0}]
[{"$f":"A13+0.001","v":3.002},"FIRE",2,null,{"$f":"Fire!F22","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,E18)","v":0}]
[]
[]
[null,"ADD 15% VAT",null,null,{"$f":"E19*15%","v":0}]
[]
[null,"TRADE DISCOUNT"]
[]
[null,"TOTAL",null,null,{"$f":"(E19+E22)-E24","v":0}]
[]
[null,"SETTLEMENT DISCOUNT",null,null,{"$f":"SUM(E21,E24)","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"]