{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["P&Gs","ELECTRICAL","PROVISIONAL AMOUNTS","SUMMARY"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"P&Gs","index":0,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[1,0,1,3],[1,4,1,5],[5,1,6,1],[18,0,18,4]]}
["IZIKO NATIONAL MUSEUMS - CAPE TOWN"]
["NELSON MANDELA PRISON HOME-GUARD HOUSE REPAIRS",{"$nulls":3},"SECTION 1: PRELIMINARY AND GENERAL "]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE            ","AMOUNT                       "]
[1,"SECTION 1: PRELIMINARY & GENERAL"]
[null,"The bill of quantities must be read together with the preamble, tender specifications and drawings forming part of this tender. Quantities will be re-measured, actual quantities will be certified for payment"]
[]
[{"v":1,"d":"1.0"},"Section 1: Preliminaries & General"]
["1.1","The bill of quantities must be read together with the preamble, tender specifications and drawings forming part of this tender. Quantities will be re-measured, actual quantities will be certified for payment","item",1,0,{"$f":"E9*D9","v":0}]
["1.2","All TIME related items in terms of the Principal Agreement as  relating to this contract (Mechanical works only)","item",1,0,{"$f":"E10*D10","v":0}]
["1.3","Allow for all FIXED charge related items in terms of the Principal Agreement relating to this contract","item",1,0,0]
["1.4","Site establishment cost","item",1,0,0]
["1.5","Temporary Lighting","item",1,0,0]
["1.6","Provide all scaffolding, lifting and plant equipment needed for the duration of the contract","sum",1,0,0]
["1.7","Allow for Rigging/hoisting of equipment (if applicable)","item",1,null,0]
["1.8","Allow for Testing and commissioning of entire Installation and decalre installation safe ","sum",1,0,0]
[1.9,"Allow for Safety File and Saftey Officer. ","sum",1,0,{"$f":"E17*D17","v":0}]
[]
["TOTAL CARRIED OVER TO SUMMARY",{"$nulls":4},{"$f":"SUM(F9:F18)","v":0}]

{"sheet":"ELECTRICAL","index":1,"n_rows":36,"n_cols":6,"rows_kept":36,"merged":[[1,4,1,5],[18,0,18,4],[35,0,35,4]]}
[{"$f":"'P&Gs'!A1","v":"IZIKO NATIONAL MUSEUMS - CAPE TOWN"}]
["NELSON MANDELA PRISON HOME-GUARD HOUSE REPAIRS",{"$nulls":3},"SECTION 2: FIRE SAFETY"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE            ","AMOUNT                       "]
[2,"ELECTRICAL INSTALLATION"]
[2.1,"EXISTING INSTALLATION"]
["2.1.1","inspect, test existing electrical installation and decalre safe","sum",1,null,{"$f":"SUM(D7*E7)","v":0}]
[2.2,"NEW INSTALLATION"]
["2.2.1","Type C light fittings","Each",45,null,{"$f":"SUM(D9*E9)","v":0}]
["2.2.2","Type B1 light ftittnigs","Each",0,null,{"$f":"SUM(D10*E10)","v":0}]
["2.2.3","Type B2 light fittings","Each",45,null,{"$f":"SUM(D11*E11)","v":0}]
[]
[]
[]
[]
[]
["2.5","GUARANTEE "]
["2.5.1","Allow for 12 Month maintenance period and guarantee for installations","Sum",{"v":1,"d":"1.00"},{"v":2500,"d":"R 2,500.00"},{"$f":"SUM(D18*E18)","v":{"v":2500,"d":"R 2,500.00"}}]
["TOTAL CARRIED OVER TO SUMMARY",{"$nulls":4},{"$f":"SUM(F5:F18)","v":{"v":2500,"d":"R 2,500.00"}}]
{"$rows_empty":16}
["TOTAL CARRIED OVER TO SUMMARY",{"$nulls":4},{"$f":"SUM(F17:F35)","v":{"v":5000,"d":"R5,000.00"}}]

{"sheet":"PROVISIONAL AMOUNTS","index":2,"n_rows":31,"n_cols":6,"rows_kept":31,"merged":[[1,4,1,5],[13,0,13,4],[30,0,30,4]]}
[{"$f":"'P&Gs'!A1","v":"IZIKO NATIONAL MUSEUMS - CAPE TOWN"}]
["NELSON MANDELA PRISON HOME-GUARD HOUSE REPAIRS",{"$nulls":3},"SECTION 3: PROVISIONAL AMOUNTS"]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE            ","AMOUNT                       "]
[3,"ELECTRICAL & ELECTRONIC INSTALLATIONS"]
[3.1,"Allow a Provisional Amount to repaitr existing electrical DB","sum",1,{"v":18500,"d":"R 18,500.00"},{"$f":"SUM(D6*E6)","v":{"v":18500,"d":"R18,500.00"}}]
[3.2,"Allow procional amount to replace faulty socket iutlets","sum",1,{"v":9500,"d":"R9,500.00"},{"$f":"SUM(D7*E7)","v":{"v":9500,"d":"R9,500.00"}}]
[3.3,"Allow testing and repair electrical wiring and.","sum",1,{"v":3500,"d":"R 3,500.00"},{"$f":"SUM(D8*E8)","v":{"v":3500,"d":"R3,500.00"}}]
[3.4,"Allow a Contingency Amount for hidden broken services","sum",1,{"v":15500,"d":"R 15,500.00"},{"$f":"SUM(D9*E9)","v":{"v":15500,"d":"R15,500.00"}}]
[]
[]
[]
[]
["TOTAL CARRIED OVER TO SUMMARY",{"$nulls":4},{"$f":"SUM(F5:F13)","v":{"v":47000,"d":"R 47,000.00"}}]
{"$rows_empty":16}
["TOTAL CARRIED OVER TO SUMMARY",{"$nulls":4},{"$f":"SUM(F9:F30)","v":{"v":62500,"d":"R62,500.00"}}]

{"sheet":"SUMMARY","index":3,"n_rows":10,"n_cols":3,"rows_kept":10}
[{"$f":"'P&Gs'!A1","v":"IZIKO NATIONAL MUSEUMS - CAPE TOWN"}]
["NELSON MANDELA PRISON HOME-GUARD HOUSE REPAIRS"]
[]
[null,"SUMMARY"]
["SECTION","DESCRIPTION","AMOUNT (R)"]
[1,"SECTION 1: PRELIMINARY AND GENERAL",{"$f":"SUM('P&Gs'!F19)","v":0}]
[2,"SECTION 2: ELECTRICAL INSTALLATION",{"$f":"SUM(ELECTRICAL!F19)","v":{"v":2500,"d":"R 2,500.00"}}]
[3,"SECTION 2: PROVISIONAL AMOUNTS",{"$f":"SUM('PROVISIONAL AMOUNTS'!F14)","v":{"v":47000,"d":"R 47,000.00"}}]
[]
[null,"SUB-TOTAL EXCL. 15% VAT",{"$f":"SUM(C6:C9)","v":{"v":49500,"d":"R 49,500.00"}}]