{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Section 1","Section 2","Section 3","Summary"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Section 1","index":0,"n_rows":36,"n_cols":23,"rows_kept":36,"merged":[[2,0,2,5]]}
["BILL OF QUANTITIES - IZIKO SOUTH AFRICAN MUSEUM: RFQ 1:"]
["IZIKO SOUTH AFRICAN MUSEUM GENERATOR CONNECTION"]
["PROJECT NUMBER: "]
["TENDER NUMBER: "]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT","RATE","AMOUNT","RATE","AMOUNT","RATE","AMOUNT","RATE","AMOUNT","QTY","RATE","AMOUNT","QTY","RATE","AMOUNT","QTY","RATE","AMOUNT"]
[]
[null,"SECTION 1"]
[null,"PRELIMINARY AND GENERAL"]
[]
["1.1","Plant and Equipment","Sum",1,0,{"$f":"PRODUCT(D11:E11)","v":0},0,{"$f":"PRODUCT(G11,D11)","v":0},0,{"$f":"PRODUCT(I11,D11)","v":0},0,{"$f":"PRODUCT(K11,D11)","v":0},0,{"$f":"PRODUCT(M11,D11)","v":0},0,0,{"$f":"PRODUCT(O11:P11)","v":0},0,0,{"$f":"PRODUCT(R11:S11)","v":0},0,0,{"$f":"PRODUCT(U11:V11)","v":0}]
[]
["1.2","Site Establishment","Sum",1,0,{"$f":"PRODUCT(D13:E13)","v":0},0,{"$f":"PRODUCT(G13,D13)","v":0},0,{"$f":"PRODUCT(I13,D13)","v":0},0,{"$f":"PRODUCT(K13,D13)","v":0},0,{"$f":"PRODUCT(M13,D13)","v":0},0,0,{"$f":"PRODUCT(O13:P13)","v":0},0,0,{"$f":"PRODUCT(R13:S13)","v":0},0,0,{"$f":"PRODUCT(U13:V13)","v":0}]
[]
["1.3","Supervision and / or Site Foreman","Sum",1,0,{"$f":"PRODUCT(D15:E15)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O15:P15)","v":0},0,0,{"$f":"PRODUCT(R15:S15)","v":0},0,0,{"$f":"PRODUCT(U15:V15)","v":0}]
[]
["1.4","Isolate 11kV RMU Switches","Each",2,0,{"$f":"PRODUCT(D17:E17)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O17:P17)","v":0},0,0,{"$f":"PRODUCT(R17:S17)","v":0},0,0,{"$f":"PRODUCT(U17:V17)","v":0}]
[]
["1.5","Testing and commissioning of entire installation","Sum",1,0,{"$f":"PRODUCT(D19:E19)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O19:P19)","v":0},0,0,{"$f":"PRODUCT(R19:S19)","v":0},0,0,{"$f":"PRODUCT(U19:V19)","v":0}]
[]
["1.6","Issue Certificates of Compliance","Sum",1,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O21:P21)","v":0},0,0,{"$f":"PRODUCT(R21:S21)","v":0},0,0,{"$f":"PRODUCT(U21:V21)","v":0}]
[]
["1.7","As-built drawings (3 Sets)","Sum",1,0,{"$f":"PRODUCT(D23:E23)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O23:P23)","v":0},0,0,{"$f":"PRODUCT(R23:S23)","v":0},0,0,{"$f":"PRODUCT(U23:V23)","v":0}]
[{"$nulls":5}," ",0,{"$nulls":9}," ",null,null," ",null,null," "]
["1.8","Guarantee for 12 months from Completion","Sum",1,0,{"$f":"PRODUCT(D25:E25)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O25:P25)","v":0},0,0,{"$f":"PRODUCT(R25:S25)","v":0},0,0,{"$f":"PRODUCT(U25:V25)","v":0}]
[]
["1.9","Compliance with the COVID, OHS Act & Client Health and Safety regulations and specifications(including Client's Site Specific Health and Safety Specifications)","Sum",1,0,{"$f":"PRODUCT(D27:E27)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O27:P27)","v":0},0,0,{"$f":"PRODUCT(R27:S27)","v":0},0,0,{"$f":"PRODUCT(U27:V27)","v":0}]
[{"$nulls":6},0]
["1.10","Provide temporary power and lighting during construction","Sum",1,0,{"$f":"PRODUCT(D29:E29)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O29:P29)","v":0},0,0,{"$f":"PRODUCT(R29:S29)","v":0},0,0,{"$f":"PRODUCT(U29:V29)","v":0}]
[]
["1.11","Identifying, Tracing and Labelling of Feeder Circuit Breakers by means of \"BROTHER\" type stick on black text on white background labels. ","Sum",4,0,{"$f":"PRODUCT(D31:E31)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O31:P31)","v":0},0,0,{"$f":"PRODUCT(R31:S31)","v":0},0,0,{"$f":"PRODUCT(U31:V31)","v":0}]
[]
[]
[]
[]
[null,"SUB-TOTAL CARRIED TO SUMMARY SHEET",{"$nulls":3},{"$f":"SUM(F7:F35)","v":0},null,{"$f":"SUM(H7:H35)","v":0},null,{"$f":"SUM(J7:J35)","v":0},null,{"$f":"SUM(L7:L35)","v":0},null,{"$f":"SUM(N7:N35)","v":0},null,null,{"$f":"SUM(Q7:Q35)","v":0},null,null,{"$f":"SUM(T8:T35)","v":0},null,null,{"$f":"SUM(W7:W35)","v":0}]

{"sheet":"Section 2","index":1,"n_rows":38,"n_cols":23,"rows_kept":38,"merged":[[2,0,2,5]]}
[{"$f":"'Section 1'!A1","v":"BILL OF QUANTITIES - IZIKO SOUTH AFRICAN MUSEUM: RFQ 1:"}]
[{"$f":"'Section 1'!A2","v":"IZIKO SOUTH AFRICAN MUSEUM GENERATOR CONNECTION"}]
["PROJECT NUMBER: "]
["TENDER NUMBER: "]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT","RATE","AMOUNT","RATE","AMOUNT","RATE","AMOUNT","RATE","AMOUNT","QTY","RATE","AMOUNT","QTY","RATE","AMOUNT","QTY","RATE","AMOUNT"]
[]
[null,"SECTION 2"]
[]
["2.1","Trace existing feeder cables and supply circuit breakers to existing Sub-DB's as pointed out on site:"]
["2.1.1","Main LV Panel (existing)","No",4,0,{"$f":"PRODUCT(D11:E11)","v":0}]
[]
["2.2","Labelling of Circuit Breakers and Sub-DB"]
[{"$nulls":6},0,{"$f":"PRODUCT(G14,D14)","v":0},0,{"$f":"PRODUCT(I14,D14)","v":0},0,{"$f":"PRODUCT(K14,D14)","v":0},0,{"$f":"PRODUCT(M14,D14)","v":0},0,0,{"$f":"PRODUCT(O14:P14)","v":0},0,0,{"$f":"PRODUCT(R14:S14)","v":0},0,0,{"$f":"PRODUCT(U14:V14)","v":0}]
["2.2.1","Main LV Panel (existing)","No",4,0,{"$f":"PRODUCT(D15:E15)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O15:P15)","v":0},0,0,{"$f":"PRODUCT(R15:S15)","v":0},0,0,{"$f":"PRODUCT(U15:V15)","v":0}]
[]
["2.3","Remove existing Bus Bar/Cable Tails between identified circuit breakers and Main LV Panel bus bars"]
[{"$nulls":6},0,{"$f":"PRODUCT(G18,D18)","v":0},0,{"$f":"PRODUCT(I18,D18)","v":0},0,{"$f":"PRODUCT(K18,D18)","v":0},0,{"$f":"PRODUCT(M18,D18)","v":0},0,0,{"$f":"PRODUCT(O18:P18)","v":0},0,0,{"$f":"PRODUCT(R18:S18)","v":0},0,0,{"$f":"PRODUCT(U18:V18)","v":0}]
["2.3.1","Labour","m",4,0,{"$f":"PRODUCT(D19:E19)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O19:P19)","v":0},0,0,{"$f":"PRODUCT(R19:S19)","v":0},0,0,{"$f":"PRODUCT(U19:V19)","v":0}]
[]
["2.4","Supply and install H07 Single Core Cabling between existing Standby Generator Panel and identified circuit breakers"]
[]
[null,"Supply:",{"$nulls":4},0,{"$f":"PRODUCT(G23,D23)","v":0},0,{"$f":"PRODUCT(I23,D23)","v":0},0,{"$f":"PRODUCT(K23,D23)","v":0},0,{"$f":"PRODUCT(M23,D23)","v":0},0,0,{"$f":"PRODUCT(O23:P23)","v":0},0,0,{"$f":"PRODUCT(R23:S23)","v":0},0,0,{"$f":"PRODUCT(U23:V23)","v":0}]
["2.4.1","70mm² Single Core Copper H07 Cabling/phase (L1,L2,L3 &N)","m",85,0,{"$f":"PRODUCT(D24:E24)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O24:P24)","v":0},0,0,{"$f":"PRODUCT(R24:S24)","v":0},0,0,{"$f":"PRODUCT(U24:V24)","v":0}]
[]
[null,"Install:"]
["2.4.2","2 x 70mm² Single Core Copper H07 Cabling/phase (L1,L2,L3 &N)","m",85,0,{"$f":"PRODUCT(D27:E27)","v":0},0,{"$f":"PRODUCT(G27,D27)","v":0},0,{"$f":"PRODUCT(I27,D27)","v":0},0,{"$f":"PRODUCT(K27,D27)","v":0},0,{"$f":"PRODUCT(M27,D27)","v":0},0,0,{"$f":"PRODUCT(O27:P27)","v":0},0,0,{"$f":"PRODUCT(R27:S27)","v":0},0,0,{"$f":"PRODUCT(U27:V27)","v":0}]
[{"$nulls":6},0,0,0,0,0,0,0,0,0,0,{"$f":"PRODUCT(O28:P28)","v":0},0,0,{"$f":"PRODUCT(R28:S28)","v":0},0,0,{"$f":"PRODUCT(U28:V28)","v":0}]
[null,"Cable Terminations:"]
["2.4.3","70mm² Single Core copper H07 Cabling/phase (L1,L2,L3 &N)","each",12,0,{"$f":"PRODUCT(D30:E30)","v":0}]
[{"$nulls":6},0,{"$f":"PRODUCT(G31,D31)","v":0},0,{"$f":"PRODUCT(I31,D31)","v":0},0,{"$f":"PRODUCT(K31,D31)","v":0},0,{"$f":"PRODUCT(M31,D31)","v":0},0,0,{"$f":"PRODUCT(O31:P31)","v":0},0,0,{"$f":"PRODUCT(R31:S31)","v":0},0,0,{"$f":"PRODUCT(U31:V31)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"SUB-TOTAL CARRIED TO SUMMARY SHEET",{"$nulls":3},{"$f":"SUM(F7:F37)","v":0},null,{"$f":"SUM(H7:H37)","v":0},null,{"$f":"SUM(J10:J37)","v":0},null,{"$f":"SUM(L10:L37)","v":0},null,{"$f":"SUM(N10:N37)","v":0},null,null,{"$f":"SUM(Q10:Q37)","v":0},null,null,{"$f":"SUM(T10:T37)","v":0},null,null,{"$f":"SUM(W7:W37)","v":0}]

{"sheet":"Section 3","index":2,"n_rows":55,"n_cols":23,"rows_kept":55,"merged":[[2,0,2,5]]}
[{"$f":"'Section 1'!A1","v":"BILL OF QUANTITIES - IZIKO SOUTH AFRICAN MUSEUM: RFQ 1:"}]
[{"$f":"'Section 1'!A2","v":"IZIKO SOUTH AFRICAN MUSEUM GENERATOR CONNECTION"}]
["PROJECT NUMBER: "]
["TENDER NUMBER: "]
[]
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT","RATE","AMOUNT","RATE","AMOUNT","RATE","AMOUNT","RATE","AMOUNT","QTY","RATE","AMOUNT","QTY","RATE","AMOUNT","QTY","RATE","AMOUNT"]
[]
[null,"SECTION 3"]
[]
[null,"Any other equipment necessary for a complete installation but not reflected in the Bill of Quantities"]
[]
[null,"(Detail). . ."]
[]
[null,"Supply","No"]
[null,"Install","No"]
[]
[null,"(Detail). . ."]
[]
[null,"Supply","No"]
[null,"Install","No"]
[]
[null,"(Detail). . ."]
[]
[null,"Supply","No"]
[null,"Install","No"]
[]
[null,"(Detail). . ."]
[]
[null,"Supply","No"]
[null,"Install","No"]
[]
[null,"(Detail). . ."]
[]
[null,"Supply","No"]
[null,"Install","No"]
[]
[null,"(Detail). . ."]
[]
[null,"Supply","No"]
[null,"Install","No"]
[]
[null,"(Detail). . ."]
[]
[null,"Supply","No"]
[null,"Install","No"]
[]
[null,"(Detail). . ."]
[]
[null,"Supply","No"]
[null,"Install","No"]
[]
[]
[]
[]
[null,"SUB-TOTAL CARRIED TO SUMMARY SHEET",{"$nulls":3},{"$f":"SUM(F7:F54)","v":0},null,{"$f":"SUM(H7:H54)","v":0},null,{"$f":"SUM(J7:J54)","v":0},null,{"$f":"SUM(L7:L54)","v":0},null,{"$f":"SUM(N7:N54)","v":0},null,null,{"$f":"SUM(Q7:Q54)","v":0},null,null,{"$f":"SUM(T7:T54)","v":0},null,null,{"$f":"SUM(W7:W54)","v":0}]

{"sheet":"Summary","index":3,"n_rows":25,"n_cols":23,"rows_kept":25,"merged":[[2,0,2,5]]}
[{"$f":"'Section 1'!A1","v":"BILL OF QUANTITIES - IZIKO SOUTH AFRICAN MUSEUM: RFQ 1:"}]
[{"$f":"'Section 1'!A2","v":"IZIKO SOUTH AFRICAN MUSEUM GENERATOR CONNECTION"}]
["PROJECT NUMBER: "]
["TENDER NUMBER: "]
[]
["ITEM","DESCRIPTION",{"$nulls":3},"AMOUNT",null,"AMOUNT",null,"AMOUNT",null,"AMOUNT",null,"AMOUNT",null,null,"AMOUNT",null,null,"AMOUNT",null,null,"AMOUNT"]
[]
[null,"SUMMARY SHEET"]
[]
[1,"Section 1",{"$nulls":3},{"$f":"'Section 1'!$F$36","v":0},null,{"$f":"'Section 1'!$H$36","v":0},null,{"$f":"'Section 1'!$J$36","v":0},null,{"$f":"'Section 1'!$L$36","v":0},null,{"$f":"'Section 1'!$N$36","v":0},null,null,{"$f":"'Section 1'!$Q$36","v":0},null,null,{"$f":"'Section 1'!$T$36","v":0},null,null,{"$f":"'Section 1'!$W$36","v":0}]
[]
[2,"Section 2",{"$nulls":3},{"$f":"'Section 2'!$F$38","v":0},null,{"$f":"'Section 2'!$H$38","v":0},null,{"$f":"'Section 2'!$J$38","v":0},null,{"$f":"'Section 2'!$L$38","v":0},null,{"$f":"'Section 2'!$N$38","v":0},null,null,{"$f":"'Section 2'!$Q$38","v":0},null,null,{"$f":"'Section 2'!$T$38","v":0},null,null,{"$f":"'Section 2'!$W$38","v":0}]
[]
[3,"Section 3",{"$nulls":3},{"$f":"'Section 3'!$F$46","v":0}]
[{"$nulls":7},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[4,"Contingency Amount (To be used or omitted at the discretion of the authorised Iziko representative)","PS",1,{"v":15000,"d":"R 15,000.00"},{"$f":"SUM(D16*E16)","v":{"v":15000,"d":"R 15,000.00"}}]
[{"$nulls":7},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[5,"TOTAL TENDER SUM (Excl VAT)",{"$nulls":3},{"$f":"SUM(F10:F16)","v":{"v":15000,"d":"R 15,000.00"}},null,{"$f":"SUM(H7:H19)","v":{"$error":"#REF!"}},null,{"$f":"SUM(J7:J19)","v":{"$error":"#REF!"}},null,{"$f":"SUM(L7:L19)","v":{"$error":"#REF!"}},null,{"$f":"SUM(N7:N17)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(Q7:Q17)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(T7:T17)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(W7:W17)","v":{"$error":"#REF!"}}]
[6,"Add 15% VAT",{"$nulls":3},{"$f":"PRODUCT(F21*0.15)","v":{"v":2250,"d":"R 2,250.00"}},null,{"$f":"PRODUCT(H21*0.15)","v":{"$error":"#REF!"}},null,{"$f":"PRODUCT(J21*0.15)","v":{"$error":"#REF!"}},null,{"$f":"PRODUCT(L21*0.15)","v":{"$error":"#REF!"}},{"$nulls":4},{"$f":"PRODUCT(Q21*0.15)","v":{"$error":"#REF!"}},null,null,{"$f":"PRODUCT(T21*0.15)","v":{"$error":"#REF!"}},null,null,{"$f":"PRODUCT(W21*0.15)","v":{"$error":"#REF!"}}]
[]
[]
[7,"TOTAL TENDER SUM (INCL VAT) CARRIED FORWARD TO TENDER FORM ",{"$nulls":3},{"$f":"SUM(F21:F22)","v":{"v":17250,"d":"R 17,250.00"}},null,{"$f":"SUM(H21:H22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(J21:J22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(L21:L22)","v":{"$error":"#REF!"}},null,{"$f":"SUM(N21:N22)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(Q21:Q22)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(T21:T22)","v":{"$error":"#REF!"}},null,null,{"$f":"SUM(W21:W22)","v":{"$error":"#REF!"}}]