{"text_format":"3","workbook":"xlsx","n_sheets":21,"sheets":["Summary Total","LV Reticulation","Sheet9","1 BED","2 BED","Administration Block","ComputerLaboratory","Home Economics","School Hall","Existing 4 CLR+Abl","Science Lab + Library","New 4 CLR+Abl","HOD+Multipurpose+Maths Lab","Caretakers Room + Store","TuckShop","Changerooms","Guard House","Area Lighting","Lightning Protection ","Refuse Area","Fire Supression"],"not_rendered":{"external_links":1,"defined_names":17},"read":"whole","date_system":"1900"}

{"sheet":"Summary Total","index":0,"n_rows":173,"n_cols":17,"rows_kept":173,"merged":[[1,1,1,5],[2,1,2,5]]}
[]
[null,"CN LEKALAKE SECONDARY SCHOOL"]
[null,"SUMMARY: ELECTRICAL WORKS "]
[null,"Section","Description","Quantity","Amount","Total","Previous","Variance"]
[]
[null,1,"P&G's @ 10 % of items 2-15",null,null,0]
[null,1," LV Reticulation",1,{"$f":"'LV Reticulation'!G60","v":0},null,{"v":9607955,"d":"ZAR 9,607,955.00"},{"$f":"F7-G7","v":{"v":-9607955,"d":"(9,607,955.00)"}}]
[null,2,"Administration Block",1,{"$f":"'Administration Block'!G173","v":0}]
[null,3,"Computer Laboratory",1,{"$f":"ComputerLaboratory!G175","v":0}]
[null,4,"Home Economics",1,{"$f":"'Home Economics'!G175","v":0}]
[null,5,"School Hall",1,{"$f":"'School Hall'!G177","v":0}]
[null,6,"Existing 4 CLR + Ablutions",4,{"$f":"'Existing 4 CLR+Abl'!G175","v":0}]
[null,7,"ScienceLab + Library",1,{"$f":"'Science Lab + Library'!G171","v":0}]
[null,8,"New 4 CLR + Ablutions",4,{"$f":"'New 4 CLR+Abl'!G173","v":0}]
[null,9,"New HOD + Multipurpose CLR + Maths Lab + Ablutions",1,{"$f":"'HOD+Multipurpose+Maths Lab'!G171","v":0}]
[null,10,"Caretakers room + Store",1,{"$f":"'Caretakers Room + Store'!G173","v":0}]
[null,11,"Tuckshop",1,{"$f":"TuckShop!G173","v":0}]
[null,12,"Changerooms",1,{"$f":"Changerooms!G173","v":0},null,{"v":11046000,"d":"ZAR 11,046,000.00"},{"$f":"F18-G18","v":{"v":-11046000,"d":"(11,046,000.00)"}},null,{"$f":"SUM(F18:F18)*1.1","v":0},{"$f":"SUM(F18:F18)","v":0},{"$f":"F18/$K$18","v":{"$error":"#DIV/0!"}},{"$f":"L18/D18","v":{"$error":"#DIV/0!"}},{"$f":"M18*#REF!","v":{"$error":"#DIV/0!"}},{"$f":"N18*D18","v":{"$error":"#DIV/0!"}},null,{"v":26019.9578075824,"d":"ZAR 26,019.96"}]
[null,13,"Guard House",1,{"$f":"'Guard House'!G173","v":0}]
[null,14,"Provide the Sum of R 600 000,00 for area lighting including tennis court and soccer field lighting","Sum",{"v":600000,"d":"ZAR 600,000.00"},{"$f":"E20","v":{"v":600000,"d":"ZAR 600,000.00"}},{"$f":"F20*E20","v":{"v":360000000000,"d":"ZAR 360,000,000,000.00"}}]
[]
[null,null,"SUB TOTAL "]
[]
[]
[]
[null,null,"TOTAL BID PRICE CARRIED TO MAIN BoQ PAGE 156"]
[]
[{"$nulls":4},{"v":42,"d":"42.00"}]
{"$rows_empty":8}
[{"$nulls":5},{"$f":"5171811.67-2324872.67","v":2846939}]
{"$rows_empty":29}
[{"$nulls":4},750,null,{"$f":"F67*E67","v":0}]
[]
[]
[]
[]
[]
[{"$nulls":4},45]
{"$rows_empty":7}
[{"$nulls":4},4]
[]
[{"$nulls":4},12]
{"$rows_empty":22}
[{"$nulls":4},4]
{"$rows_empty":19}
[{"$nulls":4},8]
[]
[]
[]
[null,null,"Type F Socket outlet",null,1,1250,{"$f":"E130*F130","v":1250}]
{"$rows_empty":16}
[{"$nulls":4},15]
[]
[{"$nulls":4},8]
{"$rows_empty":15}
[{"$nulls":4},{"$f":"50","v":50}]
{"$rows_empty":7}
[{"$nulls":4},6]

{"sheet":"LV Reticulation","index":1,"n_rows":173,"n_cols":27,"rows_kept":173,"merged":[[17,16,17,17],[17,18,17,19],[17,20,17,21],[17,22,17,23],[17,24,17,25]]}
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","TOTAL"]
[null,null,"Low Voltage Reticulation"]
[]
[null,1.1,"Distribution Kiosk"]
[]
[null,null,"P&G's @ 10 % of items 2-15"]
[]
[null,null,"Supply and installation of new main distribution kiosk compliance to SANS 10142, Clause 6.6.1.20. ","No",1,0,{"$f":"F8*E8","v":0}]
[]
[null,null,"Plinth","No",1,0,{"$f":"E10*F10","v":0}]
[]
[null,null,"Trenching"]
[null,null,"Excavating, bedding, backfilling, consolidating and"]
[]
[null,null,"Pickable soil","m³",{"$f":"(530)*0.7","v":371},0,{"$f":"F15*E15","v":0},null,{"$f":"80+60+40+110+65*4+60+70+85*2+60+135+135+110+130+90+60+60","v":{"v":1630,"d":"1630.00"}},{"$f":"I15*0.8*0.4","v":{"v":521.6,"d":"521.60"}}]
[null,null,"Hard rock","m³",{"$f":"(530)*0.3","v":159},0,{"$f":"F16*E16","v":0}]
[]
[null,null,"Backfilling and compaction","m³",{"$f":"E16+E15","v":530},0,{"$f":"F18*E18","v":0},null,{"$f":"I15-65","v":{"v":1565,"d":"R 1,565.00"}}]
[]
[null,null,"110mm diameter PVC sleeves for road crossings/cable entries into the building-rate must include for galvanised steel draw wires in spare sleeves and sealing of ends","m",60,0,{"$f":"F20*E20","v":0},null,{"$f":"350/6","v":{"v":58.333333333333336,"d":"R 58.33"}}]
[null,null,"50mm diameter PVC sleeves for road crossings/cable entries into the building-rate must include for galvanised steel draw wires in spare sleeves and sealing of ends","m",150,0,{"$f":"F21*E21","v":0}]
[]
[null,1.4,"Cable warning tape, 300mm above cables","m",1650,0,{"$f":"F23*E23","v":0},null,{"$f":"343/100","v":{"v":3.43,"d":"R 3.43"}}]
[]
[null,1.5,"Cable markers, above cables","No",35,0,{"$f":"F25*E25","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G2:G25)","v":0}]
[null,null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":3},{"$f":"G27","v":0}]
[]
[null,1.6,"600/1000V  PVC SWA  cables,in trenches and sleeves, including labels. All LV cables to be supplied by Aberdare Cables or African Cables. "]
[]
[null,"1.6.1","6mm² 4core. ","m",{"$f":"110+60","v":170},0,{"$f":"E32*F32","v":0}]
[]
[null,"1.6.1","10mm² 2core. ","m",1630,0,{"$f":"E34*F34","v":0}]
[]
[null,1.7,"600/1000V Cable terminations, "]
[null,null,"for PVC PVC SWA PVC Cu cables, for indoor or outdoor "]
[null,null,"use, as required"]
[]
[null,"1.7.1","Gland no 3 complete with shroud","No",4,0,{"$f":"F40*E40","v":0}]
[]
[null,"1.7.1","Gland no 2 complete with shroud","No",3,0,{"$f":"E42*F42","v":0}]
[{"$nulls":26},"10mm2  Cable Length"]
[null,1.8,"Earth conductors (HDHC), including ends"]
[]
[null,"1.8.1","6mm² ","m",{"$f":"E34","v":1630},0,{"$f":"E46*F46","v":0}]
[]
[null,"1.8.1","4mm² ","m",{"$f":"E32","v":170},0,{"$f":"E48*F48","v":0}]
[]
[null,"1.9","Electrical Test"]
[]
[null,"1.9.1","Testing of this section in the presence of"]
[null,null,"the Employer and/or the Engineer, including"]
[null,null,"all equipment, power generator, etc.","No",1,0,{"$f":"F54*E54","v":0}]
[]
[null,"1.10","Others"]
[]
[null,"1.10.1","Provide Sum of R 30,000.00 for supply and installation of borehole and fire pump cables.","Sum",1,{"v":30000,"d":"R30,000.00"},{"$f":"E58*F58","v":{"v":30000,"d":"30,000.00"}}]
[]
[null," ","TOTAL FOR BILL - CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},750,null,{"$f":"F67*E67","v":0}]
[]
[]
[]
[]
[]
[{"$nulls":4},45]
{"$rows_empty":7}
[{"$nulls":4},4]
[]
[{"$nulls":4},12]
{"$rows_empty":22}
[{"$nulls":4},4]
{"$rows_empty":19}
[{"$nulls":4},8]
[]
[]
[]
[null,null,"Type F Socket outlet",null,1,{"v":1250,"d":"R1,250.00"},{"$f":"E130*F130","v":{"v":1250,"d":"R1,250.00"}}]
{"$rows_empty":16}
[{"$nulls":4},15]
[]
[{"$nulls":4},8]
{"$rows_empty":15}
[{"$nulls":4},{"$f":"50","v":50}]
{"$rows_empty":7}
[{"$nulls":4},6]

{"sheet":"Sheet9","index":2,"n_rows":25,"n_cols":9,"rows_kept":25,"hidden":true,"merged":[[1,1,1,8],[2,1,2,8]]}
[]
[null,"CARLTONVILLE  SOCIAL HOUSING DEVELOPMENT - THE MOEPLE (EXT. 20 - ERF 2204)"]
[null,"SUMMARY: ELECTRICAL WORKS "]
[null,"Section","Description","Quantity","Unit","Rate","Amount","Multiple","Total"]
[]
[null,1,"P & Gs",{"$nulls":5},{"$f":"0.1*SUM(I8:I16)","v":{"v":2849470.5,"d":"ZAR 2,849,470.50"}}]
[null,3,"MV Reticulation - Internal","Lot",null,null,{"$f":"'[1]Int. MV Reticulation (X20)'!F91","v":{"v":4465376.45,"d":"ZAR 4,465,376.45"}},null,{"$f":"G7","v":{"v":4465376.45,"d":"ZAR 4,465,376.45"}}]
[null,4,"LV Reticulation","Lot",null,null,{"$f":"'[1]LV Reticulation (X20)'!F105","v":{"v":9099855,"d":"ZAR 9,099,855.00"}},null,{"$f":"G8","v":{"v":9099855,"d":"ZAR 9,099,855.00"}}]
[null,5,"Building Electrification - Block A",{"$f":"(8.4+27.2+40.3*8)*3+5.4+5.2","v":1084.6000000000001},"m2",{"v":500,"d":"ZAR 500.00"},{"$f":"F9*D9","v":{"v":542300.0000000001,"d":"ZAR 542,300.00"}},13,{"$f":"G9*H9","v":{"v":7049900.000000002,"d":"ZAR 7,049,900.00"}}]
[null,6,"Building Electrification - Block B",{"$f":"(8.4+27.2+45*4+31.2*4)*3+5.4+5.2","v":1031.8},"m2",{"v":500,"d":"ZAR 500.00"},{"$f":"F10*D10","v":{"v":515900,"d":"ZAR 515,900.00"}},13,{"$f":"G10*H10","v":{"v":6706700,"d":"ZAR 6,706,700.00"}}]
[null,7,"Building Electrification - Block C",{"$f":"D10","v":1031.8},"m2",{"v":500,"d":"ZAR 500.00"},{"v":515900,"d":"ZAR 515,900.00"},8,{"$f":"G11*H11","v":{"v":4127200,"d":"ZAR 4,127,200.00"}}]
[null,8,"Building Electrification - Block D",{"$f":"3.5+4.2+45*3+31.2*3","v":236.29999999999998},"m2",{"v":500,"d":"ZAR 500.00"},{"v":118149.99999999999,"d":"ZAR 118,150.00"},0,{"$f":"G12*H12","v":0}]
[null,9,"Building Electrification - Block E",{"$f":"(8.4+27.2+40.3*2+45*3+31.2*3)*3+5.4+5.2","v":1045},"m2",{"v":500,"d":"ZAR 500.00"},{"v":522500,"d":"ZAR 522,500.00"},2,{"$f":"G13*H13","v":{"v":1045000,"d":"ZAR 1,045,000.00"}}]
[null,10,"Building Electrification - Lifestyle Centre",415,"m2",{"v":950,"d":"ZAR 950.00"},{"v":394250,"d":"ZAR 394,250.00"},null,{"$f":"G14","v":{"v":394250,"d":"ZAR 394,250.00"}}]
[null,11,"Building Electrification - Refuse Area",212,"m2",{"v":150,"d":"ZAR 150.00"},{"v":31800,"d":"ZAR 31,800.00"},null,{"v":31800,"d":"ZAR 31,800.00"}]
[null,12,"Building Electrification - Guard House",15,"m2","-",{"$f":"40000","v":{"v":40000,"d":"ZAR 40,000.00"}},null,{"v":40000,"d":"ZAR 40,000.00"}]
[null,13,"Electric Fencing",1480,"m",{"v":150,"d":"ZAR 150.00"},{"$f":"D17*F17","v":{"v":222000,"d":"ZAR 222,000.00"}},1,{"$f":"G17*H17","v":{"v":222000,"d":"ZAR 222,000.00"}}]
[null,14,"Satellite and TV installs",864,"no.",{"v":2250,"d":"ZAR 2,250.00"},{"$f":"F18*D18","v":{"v":1944000,"d":"ZAR 1,944,000.00"}},null,{"$f":"G18","v":{"v":1944000,"d":"ZAR 1,944,000.00"}}]
[null,15,"Area Lighting ","Sum",null,null,{"v":1750000,"d":"ZAR 1,750,000.00"},null,{"v":1750000,"d":"ZAR 1,750,000.00"}]
[null,16,"Provisional Sum - Access Control and Security Cameras","Sum",null,null,{"v":500000,"d":"ZAR 500,000.00"},null,{"$f":"G20","v":{"v":500000,"d":"ZAR 500,000.00"}}]
[null,17,"Provisional Sum - Metering System","Sum",null,null,{"v":2600000,"d":"ZAR 2,600,000.00"},null,{"$f":"G21","v":{"v":2600000,"d":"ZAR 2,600,000.00"}}]
[]
[null,null,"SUB TOTAL 1",{"$nulls":5},{"$f":"SUM(I6:I21)","v":{"v":42825551.95,"d":"ZAR 42,825,551.95"}}]
[null,null,"15% VAT",{"$nulls":5},{"$f":"I23*0.15","v":{"v":6423832.7925,"d":"ZAR 6,423,832.79"}}]
[null,null,"TOTAL ESTIMATED COST (INCL. VAT)",{"$nulls":5},{"$f":"I23+I24","v":{"v":49249384.74250001,"d":"ZAR 49,249,384.74"}}]

{"sheet":"1 BED","index":3,"n_rows":172,"n_cols":15,"rows_kept":172,"hidden":true,"merged":[[42,0,42,1],[96,0,96,1],[143,0,143,1]]}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[4,"1 BEDROOM UNIT"]
[]
[]
["4.1","Excavation and Trenching"]
[null,"MV Reticulation "]
[null,"General trenching workfor sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
["4.1.1","Trenching through floor for sleeves","m³",null,{"v":68.77,"d":"R 68.77"},"rate only"]
[]
["4.1.2","Excavation and backfilling in soft soil","m³",null,{"v":103,"d":"R 103.00"},"rate only"]
[]
["4.1.3","Excavation and backfilling in hard rock","m³",null,{"v":203,"d":"R 203.00"},"rate only"]
[]
["4.2","Cable and Data Sleeves"]
[]
[null,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
["4.2.1","75mm Diameter for Data","m",8,{"v":75,"d":"R 75.00"},"rate only"]
[]
["4.2.2","110mm Diameter for power cable","m",null,{"v":105,"d":"R 105.00"},"rate only"]
[]
[null,"Radius bends:"]
[]
["4.2.3","75mm Diameter ","No",null,{"v":166,"d":"R 166.00"},"rate only"]
[]
["4.2.7","110mm Diameter","No",null,{"v":198,"d":"R 198.00"},"rate only"]
[]
["4.3","Draw Wires"]
[]
["4.4.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",100,{"v":5.5,"d":"R 5.50"},{"$f":"E34*D34","v":{"v":550,"d":"550.00"}}]
[]
["4.4","Distribution Boards"]
[]
[null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized interna"]
[]
["4.4.1","Supply and install a Distribution Board c/w 1P prepaid meter","No.",1,{"$f":"3200+5000","v":{"v":8200,"d":"R 8,200.00"}},{"$f":"E40*D40","v":{"v":8200,"d":"8,200.00"}}]
[]
[null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F3:F41)","v":{"v":8750,"d":"R 8,750.00"}}]
["TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"F42","v":{"v":8750,"d":"R 8,750.00"}}]
[]
["4.5","Low Voltage PVC Cables"]
[null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
["4.4.1","6mm 2 core PVC SWA Cable","m",0,{"v":26.25,"d":"R 26.25"}]
[]
["4.4.2","4mm BCEW  ","m",0,{"v":4.1,"d":"R 4.10"}]
[]
[null,"Terminations:"]
[]
["4.4.3","6mm 2 core cable","No",2,{"v":90,"d":"R 90.00"},{"$f":"E54*D54","v":{"v":180,"d":"180.00"}}]
[]
["4.4.4","4mm BCEW","No",2,{"v":40,"d":"R 40.00"},{"$f":"E56*D56","v":{"v":80,"d":"80.00"}}]
[]
["4.6","Conduit Work"]
[]
[null,"Supply, delivery and installation of SABS approved PVC / Galvanised Conduits completed with all required conduit accessories.   "]
[]
[null,"Built or Chase into brick or concrete work:"]
[]
["4.6.1","20mm PVC Conduit ","m",0,{"v":18,"d":"R 18.00"}]
[]
["4.6.2","25mm PVC Conduit ","m",60,{"v":20,"d":"R 20.00"},{"$f":"E66*D66","v":{"v":1200,"d":"1,200.00"}}]
[]
[null,"In Ceiling space and Timber work or along Purlins"]
[]
["4.6.3","20mm PVC Conduit ","m",70,{"v":18,"d":"R 18.00"},{"$f":"E70*D70","v":{"v":1260,"d":"1,260.00"}}]
[]
["4.6.4","25mm PVC Conduit ","m",0,{"v":20,"d":"R 20.00"}]
[]
[]
[]
[]
[]
[null,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
["4.6.6","20mm diameter 4 way type(round box)","No",15,{"v":55,"d":"R 55.00"},{"$f":"E80*D80","v":{"v":825,"d":"825.00"}}]
[]
[]
[]
["4.7","Wall Boxes"]
[]
[null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,"Flush mounted type:"]
[]
["4.4.1","100 x 50 x 50mm","No",4,{"v":55,"d":"R 55.00"},{"$f":"E90*D90","v":{"v":220,"d":"220.00"}}]
[]
["4.4.2","100 x 100 x 50mm","No",6,{"v":60,"d":"R 60.00"},{"$f":"E92*D92","v":{"v":360,"d":"360.00"}}]
[]
[]
[]
[null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F43:F95)","v":{"v":12875,"d":"R 12,875.00"}}]
["TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"F96","v":{"v":12875,"d":"R 12,875.00"}}]
[]
["4.8","PVC Wiring in conduits:"]
[]
["4.8.1","2.5mm² for lights circuits","m",250,{"v":9,"d":"R 9.00"},{"$f":"E101*D101","v":{"v":2250,"d":"2,250.00"}},null,null,{"$f":"80*3","v":240}]
[]
["4.8.2","4mm² for plug sockets circuits","m",250,{"v":16,"d":"R 16.00"},{"$f":"E103*D103","v":{"v":4000,"d":"4,000.00"}}]
[]
[null,"Stranded Bare Copper Earth Wire"]
[]
[null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
["4.8.3","2.5mm² ","m",{"$f":"D101","v":250},{"v":6,"d":"R 6.00"},{"$f":"E109*D109","v":{"v":1500,"d":"1,500.00"}}]
[]
["4.8.4","4mm² ","m",{"$f":"D103","v":250},{"v":6,"d":"R 6.00"},{"$f":"E111*D111","v":{"v":1500,"d":"1,500.00"}}]
[]
["4.9","Light Switches"]
[]
[null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. All boxes for flush mounting meas"]
[]
["4.9.1","1 Lever 1 way","No",3,{"v":95,"d":"R 95.00"},{"$f":"E117*D117","v":{"v":285,"d":"285.00"}}]
[]
["4.9.2","1 Lever 2 way","No",1,{"v":140,"d":"R 140.00"},{"$f":"E119*D119","v":{"v":140,"d":"140.00"}}]
[]
["4.9.3","3 Lever 2 way","No",0,{"v":160,"d":"R 160.00"},{"$f":"E121*D121","v":{"v":0,"d":"0.00"}}]
[]
["4.9.4","3 Lever 1 way","No",0,{"v":180,"d":"R 180.00"},{"$f":"E123*D123","v":{"v":0,"d":"0.00"}}]
[]
["4.9.4","Photo cell","No",0,{"v":450,"d":"R 450.00"},{"$f":"E125*D125","v":{"v":0,"d":"0.00"}}]
[]
["4.10","Socket Outlets"]
[]
[null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,"Flush switched sockets type:"]
[]
["4.10.1","16A 3 pin single socket outlets","No",1,{"v":150,"d":"R 150.00"},{"$f":"E137*D137","v":{"v":150,"d":"150.00"}}]
[]
["4.10.2","16A 3 ZA socket outlets","No",3,{"v":175,"d":"R 175.00"},{"$f":"E139*D139","v":{"v":525,"d":"525.00"}}]
[]
["4.10.3","Type D: Wall mounted TV/SAT point  ","No",1,{"v":250,"d":"R 250.00"},{"$f":"E141*D141","v":{"v":250,"d":"250.00"}}]
[]
[null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F97:F142)","v":{"v":23475,"d":"R 23,475.00"}}]
["TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"F143","v":{"v":23475,"d":"R 23,475.00"}}]
[]
["4.11","Light Fittings"]
[]
[null,"Suppy, delievery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
["4.11.1","Type F1: 2x14W 600mm  Decorative Fluorescent Light ","No",0,{"v":830,"d":"R 830.00"},{"$f":"E152*D152","v":{"v":0,"d":"0.00"}}]
[{"$nulls":14},{"$f":"60*12","v":720}]
["4.11.2","Type W1: 2x14W 600mm  Decorative Vapour Fluorescent Light ","No",1,{"v":650,"d":"R 650.00"},{"$f":"E154*D154","v":{"v":650,"d":"650.00"}}]
[]
["4.11.3","Type B1: Ceiling/Wall  mounted bulkhead 2x 18W CFL  ","No",4,{"v":550,"d":"R 550.00"},{"$f":"E156*D156","v":{"v":2200,"d":"2,200.00"}}]
[]
[]
[]
["4.12","Electrical Tests",{"$nulls":12},{"$f":"150*9","v":1350}]
[]
[null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
["4.12.1","Building installation","Sum",1,{"v":1500,"d":"R 1,500.00"},{"$f":"E164*D164","v":{"v":1500,"d":"1,500.00"}}]
[]
["4.13","Others"]
[]
["4.13.1","Provide the sum of R1500-00 for earthing and lightning protection installations by specialist","Sum",0,{"v":1500,"d":"R 1,500.00"},{"$f":"E168*D168","v":{"v":0,"d":"0.00"}}]
[]
["4.12.2","40A Isolator points with complete and suitable fitting, for geyser or cooker","No",1,{"v":350,"d":"R 350.00"},{"$f":"E170*D170","v":{"v":350,"d":"350.00"}}]
[]
[" ","TOTAL FOR BILL - CARRIED FORWARD TO SUMMARY",{"$nulls":3},{"$f":"SUM(F144:F171)","v":{"v":28175,"d":"R 28,175.00"}}]

{"sheet":"2 BED","index":4,"n_rows":172,"n_cols":15,"rows_kept":172,"hidden":true,"merged":[[42,0,42,1],[96,0,96,1],[143,0,143,1]]}
["ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[4,"2 BEDROOM UNIT"]
[]
[]
["4.1","Excavation and Trenching"]
[null,"MV Reticulation "]
[null,"General trenching workfor sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
["4.1.1","Trenching through floor for sleeves","m³",null,{"v":68.77,"d":"R 68.77"},"rate only"]
[]
["4.1.2","Excavation and backfilling in soft soil","m³",null,{"v":103,"d":"R 103.00"},"rate only"]
[]
["4.1.3","Excavation and backfilling in hard rock","m³",null,{"v":203,"d":"R 203.00"},"rate only"]
[]
["4.2","Cable and Data Sleeves"]
[]
[null,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
["4.2.1","75mm Diameter for Data","m",8,{"v":75,"d":"R 75.00"},"rate only"]
[]
["4.2.2","110mm Diameter for power cable","m",null,{"v":105,"d":"R 105.00"},"rate only"]
[]
[null,"Radius bends:"]
[]
["4.2.3","75mm Diameter ","No",null,{"v":166,"d":"R 166.00"},"rate only"]
[]
["4.2.7","110mm Diameter","No",null,{"v":198,"d":"R 198.00"},"rate only"]
[]
["4.3","Draw Wires"]
[]
["4.4.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",150,{"v":5.5,"d":"R 5.50"},{"$f":"E34*D34","v":{"v":825,"d":"825.00"}}]
[]
["4.4","Distribution Boards"]
[]
[null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized interna"]
[]
["4.4.1","Supply and install a Distribution Board c/w 1P prepaid meter","No.",1,{"$f":"3200+5000","v":{"v":8200,"d":"R 8,200.00"}},{"$f":"E40*D40","v":{"v":8200,"d":"8,200.00"}}]
[]
[null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F3:F41)","v":{"v":9025,"d":"R 9,025.00"}}]
["TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"F42","v":{"v":9025,"d":"R 9,025.00"}}]
[]
["4.5","Low Voltage PVC Cables"]
[null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
["4.4.1","6mm 2 core PVC SWA Cable","m",0,{"v":26.25,"d":"R 26.25"}]
[]
["4.4.2","4mm BCEW  ","m",0,{"v":4.1,"d":"R 4.10"}]
[]
[null,"Terminations:"]
[]
["4.4.3","6mm 2 core cable","No",2,{"v":90,"d":"R 90.00"},{"$f":"E54*D54","v":{"v":180,"d":"180.00"}}]
[]
["4.4.4","4mm BCEW","No",2,{"v":40,"d":"R 40.00"},{"$f":"E56*D56","v":{"v":80,"d":"80.00"}}]
[]
["4.6","Conduit Work"]
[]
[null,"Supply, delivery and installation of SABS approved PVC / Galvanised Conduits completed with all required conduit accessories.   "]
[]
[null,"Built or Chase into brick or concrete work:"]
[]
["4.6.1","20mm PVC Conduit ","m",0,{"v":18,"d":"R 18.00"}]
[]
["4.6.2","25mm PVC Conduit ","m",75,{"v":20,"d":"R 20.00"},{"$f":"E66*D66","v":{"v":1500,"d":"1,500.00"}}]
[]
[null,"In Ceiling space and Timber work or along Purlins"]
[]
["4.6.3","20mm PVC Conduit ","m",80,{"v":18,"d":"R 18.00"},{"$f":"E70*D70","v":{"v":1440,"d":"1,440.00"}}]
[]
["4.6.4","25mm PVC Conduit ","m",0,{"v":20,"d":"R 20.00"}]
[]
[]
[]
[]
[]
[null,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
["4.6.6","20mm diameter 4 way type(round box)","No",20,{"v":55,"d":"R 55.00"},{"$f":"E80*D80","v":{"v":1100,"d":"1,100.00"}}]
[]
[]
[]
["4.7","Wall Boxes"]
[]
[null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,"Flush mounted type:"]
[]
["4.4.1","100 x 50 x 50mm","No",6,{"v":55,"d":"R 55.00"},{"$f":"E90*D90","v":{"v":330,"d":"330.00"}}]
[]
["4.4.2","100 x 100 x 50mm","No",10,{"v":60,"d":"R 60.00"},{"$f":"E92*D92","v":{"v":600,"d":"600.00"}}]
[]
[]
[]
[null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F43:F95)","v":{"v":14255,"d":"R 14,255.00"}}]
["TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"F96","v":{"v":14255,"d":"R 14,255.00"}}]
[]
["4.8","PVC Wiring in conduits:"]
[]
["4.8.1","2.5mm² for lights circuits","m",300,{"v":9,"d":"R 9.00"},{"$f":"E101*D101","v":{"v":2700,"d":"2,700.00"}},null,null,{"$f":"80*3","v":240}]
[]
["4.8.2","4mm² for plug sockets circuits","m",300,{"v":14,"d":"R 14.00"},{"$f":"E103*D103","v":{"v":4200,"d":"4,200.00"}}]
[]
[null,"Stranded Bare Copper Earth Wire"]
[]
[null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
["4.8.3","2.5mm² ","m",{"$f":"D101","v":300},{"v":6,"d":"R 6.00"},{"$f":"E109*D109","v":{"v":1800,"d":"1,800.00"}}]
[]
["4.8.4","4mm² ","m",{"$f":"D103","v":300},{"v":6,"d":"R 6.00"},{"$f":"E111*D111","v":{"v":1800,"d":"1,800.00"}}]
[]
["4.9","Light Switches"]
[]
[null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. All boxes for flush mounting meas"]
[]
["4.9.1","1 Lever 1 way","No",2,{"v":95,"d":"R 95.00"},{"$f":"E117*D117","v":{"v":190,"d":"190.00"}}]
[]
["4.9.2","1 Lever 2 way","No",1,{"v":140,"d":"R 140.00"},{"$f":"E119*D119","v":{"v":140,"d":"140.00"}}]
[]
["4.9.3","3 Lever 2 way","No",1,{"v":160,"d":"R 160.00"},{"$f":"E121*D121","v":{"v":160,"d":"160.00"}}]
[]
["4.9.4","3 Lever 1 way","No",1,{"v":180,"d":"R 180.00"},{"$f":"E123*D123","v":{"v":180,"d":"180.00"}}]
[]
["4.9.4","Photo cell","No",0,{"v":450,"d":"R 450.00"},{"$f":"E125*D125","v":{"v":0,"d":"0.00"}}]
[]
["4.10","Socket Outlets"]
[]
[null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,"Flush switched sockets type:"]
[]
["4.10.1","16A 3 pin single socket outlets","No",2,{"v":150,"d":"R 150.00"},{"$f":"E137*D137","v":{"v":300,"d":"300.00"}}]
[]
["4.10.2","16A 3 ZA socket outlets","No",4,{"v":175,"d":"R 175.00"},{"$f":"E139*D139","v":{"v":700,"d":"700.00"}}]
[]
["4.10.3","Type D: Wall mounted TV/SAT point  ","No",1,{"v":250,"d":"R 250.00"},{"$f":"E141*D141","v":{"v":250,"d":"250.00"}}]
[]
[null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(F97:F142)","v":{"v":26675,"d":"R 26,675.00"}}]
["TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"F143","v":{"v":26675,"d":"R 26,675.00"}}]
[]
["4.11","Light Fittings"]
[]
[null,"Suppy, delievery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
["4.11.1","Type F1: 2x14W 600mm  Decorative Fluorescent Light ","No",0,{"v":830,"d":"R 830.00"},{"$f":"E152*D152","v":{"v":0,"d":"0.00"}}]
[{"$nulls":14},{"$f":"60*12","v":720}]
["4.11.2","Type W1: 2x14W 600mm  Decorative Vapour Fluorescent Light ","No",1,{"v":650,"d":"R 650.00"},{"$f":"E154*D154","v":{"v":650,"d":"650.00"}}]
[]
["4.11.3","Type B1: Ceiling/Wall  mounted bulkhead 2x 18W CFL  ","No",7,{"v":550,"d":"R 550.00"},{"$f":"E156*D156","v":{"v":3850,"d":"3,850.00"}}]
[]
[]
[]
["4.12","Electrical Tests",{"$nulls":12},{"$f":"150*9","v":1350}]
[]
[null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
["4.12.1","Building installation","Sum",1,{"v":1500,"d":"R 1,500.00"},{"$f":"E164*D164","v":{"v":1500,"d":"1,500.00"}}]
[]
["4.13","Others"]
[]
["4.13.1","Provide the sum of R2500-00 for earthing and lightning protection installations by specialist","Sum",0,{"v":1500,"d":"R 1,500.00"},{"$f":"E168*D168","v":{"v":0,"d":"0.00"}}]
[]
["4.12.2","40A Isolator points with complete and suitable fitting, for geyser or cooker","No",1,{"v":350,"d":"R 350.00"},{"$f":"E170*D170","v":{"v":350,"d":"350.00"}}]
[]
[" ","TOTAL FOR BILL - CARRIED FORWARD TO SUMMARY",{"$nulls":3},{"$f":"SUM(F144:F171)","v":{"v":33025,"d":"R 33,025.00"}}]

{"sheet":"Administration Block","index":5,"n_rows":175,"n_cols":16,"rows_kept":175,"merged":[[39,1,39,2],[85,1,85,2],[136,1,136,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,2,"Administration Block"]
[]
[null,2.1,"P&G's @ 10 % of items 2-15"]
[null,null,"MV Reticulation "]
[null,3.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,4.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,5.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,6.1]
[null,null,"Excavation and backfilling in hard rock","m³",null,null,"rate only"]
[null,7.1,"Cable and Data Sleeves"]
[]
[null,8.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,9.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"2.2.2","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"2.2.2","110mm Diameter","No",null,null,"rate only"]
[]
[null,2.2,"Draw Wires"]
[]
[null,"2.2.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":1100},0,{"$f":"E31*F31","v":0}]
[]
[null,2.2,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"2.2.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,2.5,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"2.5.1","10mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"2.5.2","4mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"2.5.2","16mm 2 core cable","No",null,null,"rate only"]
[]
[null,"2.5.2","10mm BCEW","No",null,null,"rate only"]
[]
[null,2.6,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"2.6.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"2.6.2","25mm PVC conduit ","m",650,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"2.6.2","20mm PVC conduit ","m",450,0,{"$f":"F67*E67","v":0}]
[]
[null,"2.6.2","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,2.7,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"2.7.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,2.7,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"2.7.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"2.7.2","100 x 100 x 50mm","No",12,0,{"$f":"F83*E83","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G39:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,2.8,"PVC Wiring in conduits:"]
[]
[null,"2.8.1","2.5mm² for lights circuits","m",2500,0,{"$f":"F89*E89","v":0}]
[]
[null,"2.8.2","4mm² for plug sockets circuits","m",1500,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"2.8.2","2.5mm² ","m",{"$f":"E90","v":2500},0,{"$f":"F98*E98","v":0}]
[]
[null,"2.8.2","4mm² ","m",null,null,"rate only"]
[]
[null,2.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"2.9.1","1 Lever 1 way","No",4,0,{"$f":"F106*E106","v":0}]
[]
[null,"2.9.2","1 Lever 2 way","No",2,0,{"$f":"E108*F108","v":0}]
[]
[null,"2.9.2","2 Lever 2 way","No",null,null,"rate only"]
[]
[null,"2.9.2","2 Lever 1 way","No",null,null,"rate only"]
[]
[null,"2.9.5","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,"2.9.6","Motion Sensor","No",3,0,{"$f":"E116*F116","v":0}]
[]
[null,2.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"2.10.1","16A single socket outlets - ZA plug","No",18,0,{"$f":"E128*F128","v":0}]
[]
[null,"2.10.2","Type F Socket outlet","No",1,0,{"$f":"E130*F130","v":0}]
[]
[null,"2.10.2","Type D Socket outlet","No",null,null,"rate only"]
[]
[null,"2.10.2","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G125)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G136","v":0}]
[]
[null,2.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"2.11.1","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",29,0,{"$f":"E145*F145","v":0}]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"2.11.2","15W LED Round Bulkhead 4000K","No",15,0,{"$f":"F147*E147","v":0}]
[]
[null,"2.11.2","8 Inch 8W LED Downlight","No",8,0,{"$f":"E149*F149","v":0}]
[]
[null,2.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"2.12.1","Building installation","Sum",1,{"v":14500,"d":"R14,500.00"},{"$f":"F155*E155","v":{"v":14500,"d":"R14,500.00"}}]
[]
[null,2.12,"Others"]
[]
[null,"2.12.1","200 x 200mm - Telephone & Data DB","No",1,0,{"$f":"E159*F159","v":0}]
[]
[null,"2.12.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",4,0,{"$f":"E161*F161","v":0}]
[]
[null,"2.12.2","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",150,0,{"$f":"E163*F163","v":0}]
[]
[null,"2.12.4","Provide the Sum of R 42,500.00 for earthing and lightning protection","Sum",1,{"v":42500,"d":"R42,500.00"},{"$f":"E165*F165","v":{"v":42500,"d":"R42,500.00"}}]
[]
[null,"2.12.5","20A 2pole Isolator, in suitable York Box, for HVAC","No",17,0,{"$f":"E167*F167","v":0}]
[]
[null,"2.12.6","40A Isolator points with complete and suitable fitting, for stove","No",1,0,{"$f":"E169*F169","v":0}]
[]
[null,"2,12,7","Provide the sum of R 55 000,00 for the relocation of of existing server from old admin to the new admin","No","Sum",{"v":55000,"d":"R55,000.00"},{"$f":"F171","v":{"v":55000,"d":"R55,000.00"}}]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (2X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]
[]
[{"$nulls":4},6]

{"sheet":"ComputerLaboratory","index":6,"n_rows":175,"n_cols":16,"rows_kept":175,"merged":[[39,1,39,2],[85,1,85,2],[134,1,134,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,3,"Computer Laboratory"]
[]
[null,3.1,"P&G's @ 10 % of items 2-15"]
[]
[null,4.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,5.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,6.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,7.1,"Excavation and backfilling in soft soil"]
[{"$nulls":3},"m³",null,null,"rate only"]
[null,8.1,"Cable and Data Sleeves"]
[]
[null,9.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,10.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"3.2.3","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"3.2.3","110mm Diameter","No",null,null,"rate only"]
[]
[null,3.3,"Draw Wires"]
[]
[null,"3.3.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":800},0,{"$f":"F31*E31","v":0}]
[]
[null,3.3,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"3.3.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,3.3,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"3.3.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"3.3.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"3.3.3","10mm 2 core cable","No",2,0,{"$f":"E51*F51","v":0}]
[]
[null,"3.3.3","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,3.3,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"3.3.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"3.3.2","25mm PVC conduit ","m",350,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"3.3.3","20mm PVC conduit ","m",450,0,{"$f":"F67*E67","v":0}]
[]
[null,"3.3.3","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,3.3,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"3.3.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,3.3,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"3.3.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"3.3.2","100 x 100 x 50mm","No",12,0,{"$f":"F83*E83","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,3.8,"PVC Wiring in conduits:"]
[]
[null,"3.8.1","2.5mm² house wire for lights circuits","m",400,0,{"$f":"F90*E90","v":0},null,null,{"$f":"970/100","v":{"v":9.7,"d":"R9.70"}}]
[]
[null,"3.8.2","4mm² house wire for lights socket outlets and isolators","m",450,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"3.8.3","1.5mm² ","m",{"$f":"E90","v":400},0,{"$f":"F98*E98","v":0}]
[]
[null,"3.8.3","4mm² ","m",null,null,"rate only"]
[]
[null,3.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"3.9.1","1 Lever 1 way","No",4,0,{"$f":"F106*E106","v":0}]
[]
[null,"3.9.2","1 Lever 2 way","No",null,null,"rate only"]
[]
[null,"3.9.3","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"3.9.3","3600 occupancy sensor","No",null,null,"rate only"]
[]
[null,"3.9.3","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,3.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"3.10.1","16A single socket outlets - ZA plug","No",8,0,{"$f":"F126*E126","v":0}]
[]
[null,"3.10.2","16A  double socket outlets - ZA plug","No",null,null,"Rate only"]
[]
[null,"3.10.3","Type F Socket outlet","No",1,0,{"$f":"E130*F130","v":0}]
[]
[null,"3.10.3","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G133)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G134","v":0}]
[]
[null,3.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"3.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"3.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"3.11.3","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",15,0,{"$f":"E147*F147","v":0}]
[]
[null,"3.11.3","15W LED Round Bulkhead 4000K","No",8,0,{"$f":"F149*E149","v":0}]
[]
[null,"3.11.3","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",null,null,"rate only"]
[]
[null,3.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"3.12.1","Building installation","Sum",1,{"v":6000,"d":"R6,000.00"},{"$f":"F157*E157","v":{"v":6000,"d":"R6,000.00"}}]
[]
[null,3.13,"Others"]
[]
[null,"3.13.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"3.13.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"3.13.3","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",{"$f":"50","v":50},0,{"$f":"E165*F165","v":0}]
[]
[null,"3.13.3","DATA and Telephone points on must include draw box, blank cover plate, etc,","No",null,null,"Rate only"]
[]
[null,"3.13.3","Provide the Sum of R 26,500.00 for earthing and lightning protection","Sum",1,{"v":26500,"d":"R26,500.00"},{"$f":"E169*F169","v":{"v":26500,"d":"R26,500.00"}}]
[]
[null,"3.13.3","Provide the sum of R 45 000,00 for the removal of electrical installations in the existing admin","No",1,0,{"$f":"E171*F171","v":0}]
[]
[null,"3.13.3","20A Isolator points with complete and suitable fitting, for HVAC","No",6,0,{"$f":"E173*F173","v":0}]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"Home Economics","index":7,"n_rows":175,"n_cols":16,"rows_kept":175,"merged":[[39,1,39,2],[85,1,85,2],[134,1,134,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,4,"Home Economics"]
[]
[null,4.1,"P&G's @ 10 % of items 2-15"]
[]
[null,5.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,6.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,7.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,8.1,"Excavation and backfilling in soft soil"]
[{"$nulls":3},"m³",null,null,"rate only"]
[null,9.1,"Cable and Data Sleeves"]
[]
[null,10.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,11.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"4.2.4","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"4.2.4","110mm Diameter","No",null,null,"rate only"]
[]
[null,4.4,"Draw Wires"]
[]
[null,"4.4.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":800},0,{"$f":"F31*E31","v":0}]
[]
[null,4.4,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"4.4.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,4.4,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"4.4.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"4.4.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"4.4.4","10mm 2 core cable","No",2,0,{"$f":"E51*F51","v":0}]
[]
[null,"4.4.4","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,4.4,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"4.4.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"4.4.2","25mm PVC conduit ","m",350,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"4.4.4","20mm PVC conduit ","m",450,0,{"$f":"F67*E67","v":0}]
[]
[null,"4.4.4","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,4.4,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"4.4.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,4.4,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"4.4.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"4.4.2","100 x 100 x 50mm","No",12,0,{"$f":"F83*E83","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,4.8,"PVC Wiring in conduits:"]
[]
[null,"4.8.1","2.5mm² house wire for lights circuits","m",400,0,{"$f":"F90*E90","v":0},null,null,{"$f":"970/100","v":{"v":9.7,"d":"R9.70"}}]
[]
[null,"4.8.2","4mm² house wire for lights socket outlets and isolators","m",450,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"4.8.4","1.5mm² ","m",{"$f":"E90","v":400},0,{"$f":"F98*E98","v":0}]
[]
[null,"4.8.4","4mm² ","m",null,null,"rate only"]
[]
[null,4.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"4.9.1","1 Lever 1 way","No",4,0,{"$f":"F106*E106","v":0}]
[]
[null,"4.9.2","1 Lever 2 way","No",null,null,"rate only"]
[]
[null,"4.9.4","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"4.9.4","3600 occupancy sensor","No",null,null,"rate only"]
[]
[null,"4.9.4","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,4.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"4.10.1","16A single socket outlets - ZA plug","No",8,0,{"$f":"F126*E126","v":0}]
[]
[null,"4.10.2","16A  double socket outlets - ZA plug","No",null,null,"Rate only"]
[]
[null,"4.10.4","Type F Socket outlet","No",null,null,"rate only"]
[]
[null,"4.10.4","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G133)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G134","v":0}]
[]
[null,4.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"4.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"4.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"4.11.4","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",8,0,{"$f":"E147*F147","v":0}]
[]
[null,"4.11.4","15W LED Round Bulkhead 4000K","No",12,0,{"$f":"F149*E149","v":0}]
[]
[null,"4.11.4","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",null,null,"rate only"]
[]
[null,4.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"4.12.1","Building installation","Sum",1,{"v":6000,"d":"R6,000.00"},{"$f":"F157*E157","v":{"v":6000,"d":"R6,000.00"}}]
[]
[null,4.14,"Others"]
[]
[null,"4.14.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"4.14.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"4.14.4","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",null,null,"rate only"]
[]
[null,"4.14.4","DATA and Telephone points on must include draw box, blank cover plate, etc,","No",null,null,"Rate only"]
[]
[null,"4.14.4","Provide the Sum of R 26,500.00 for earthing and lightning protection","Sum",1,{"v":26500,"d":"R26,500.00"},{"$f":"E169*F169","v":{"v":26500,"d":"R26,500.00"}}]
[]
[null,"4.14.4","Provide the sum of R 55 000,00 for the removal of electrical installations in the existing cooking area","No",1,0,{"$f":"E171*F171","v":0}]
[]
[null,"4.14.4","20A TP Isolator points with complete and suitable fitting, for extraction fan","No",4,0,{"$f":"E173*F173","v":0}]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"School Hall","index":8,"n_rows":177,"n_cols":16,"rows_kept":177,"merged":[[39,1,39,2],[85,1,85,2],[136,1,136,2]]}
[]
[null,null,"DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,5,"School Hall"]
[]
[null,5.1,"P&G's @ 10 % of items 2-15"]
[null,null,"MV Reticulation "]
[null,6.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,7.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,8.1,"Trenching through floor for sleeves","m³",null,{"$f":"SUM(F6:F11)","v":0},"rate only"]
[null,null,"Provide the provissional sum of ZAR 1,550,900.00 for the refurbishment of Block A,B,C,D,E and Administration block ( This includes small power and lighting and earthing and lightning protection)"]
[null,9.1]
[null,null,"Excavation and backfilling in hard rock","m³",null,null,"rate only"]
[null,10.1,"Cable and Data Sleeves"]
[]
[null,11.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,12.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"5.2.5","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"5.2.5","110mm Diameter","No",null,null,"rate only"]
[]
[null,5.5,"Draw Wires"]
[]
[null,"5.5.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":950},0,{"$f":"F31*E31","v":0}]
[]
[null,5.5,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"5.5.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,5.5,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"5.5.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"5.5.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"5.5.5","10mm 2 core cable","No",4,0,{"$f":"E51*F51","v":0}]
[]
[null,"5.5.5","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,5.6,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"5.6.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"5.6.2","25mm PVC conduit ","m",450,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"5.6.5","20mm PVC conduit ","m",500,0,{"$f":"F67*E67","v":0}]
[]
[null,"5.6.5","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,5.7,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"5.7.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,5.7,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"5.7.1","100 x 50 x 50mm","No",6,0,{"$f":"F81*E81","v":0}]
[]
[null,"5.7.2","100 x 100 x 50mm","No",12,0,{"$f":"F83*E83","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,5.8,"PVC Wiring in conduits:"]
[]
[null,"5.8.1","2.5mm² house wire for lights circuits","m",1850,0,{"$f":"F90*E90","v":0}]
[]
[null,"5.8.2","Flat twin 4mm² X2+Earth for plug sockets and airconditioning circuits","m",850,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"5.8.5","2.5mm² ","m",{"$f":"E90","v":1850},0,{"$f":"F98*E98","v":0}]
[]
[null,"5.8.5","4mm² ","m",null,null,"rate only"]
[]
[null,5.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"5.9.1","1 Lever 1 way","No",6,0,{"$f":"F106*E106","v":0}]
[]
[null,"5.9.2","1 Lever 2 way","No",2,0,{"$f":"E108*F108","v":0}]
[]
[null,"5.9.5","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"5.9.5","3 Lever 1 way","No",null,null,"rate only"]
[]
[null,"5.9.5","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,"5.9.6","Motion Sensor","No",2,0,{"$f":"E116*F116","v":0}]
[]
[null,5.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"5.10.1","16A single socket outlets - ZA plug","No",7,0,{"$f":"F128*E128","v":0}]
[]
[null,"5.10.2","Type F Socket outlet","No",null,null,"rate only"]
[]
[null,"5.10.5","Type D Socket outlet","No",null,null,"Rate only"]
[]
[null,"5.10.5","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G135)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G136","v":0}]
[]
[null,5.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"5.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"5.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"5.11.5","4ft or 2ft T8 Open Channel Luminaire With 2x18 LED Tube","No",8,0,{"$f":"E149*F149","v":0}]
[]
[null,"5.11.5","15W LED Round Bulkhead 4000K","No",19,0,{"$f":"F151*E151","v":0}]
[]
[null,"5.11.5","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",12,0,{"$f":"F153*E153","v":0}]
[]
[null,5.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"5.12.1","Building installation","Sum",1,{"v":12000,"d":"R12,000.00"},{"$f":"F159*E159","v":{"v":12000,"d":"R12,000.00"}}]
[]
[null,5.15,"Others"]
[]
[null,"5.15.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"5.15.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"5.15.5","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",null,null,"Rate only"]
[]
[null,"5.15.5","DATA and Telephone points on must include draw box, blank cover plate, etc,","No",null,null,"Rate only"]
[]
[null,"5.15.5","Provide the Sum of R 35,500.00 for earthing and lightning protection","Sum",1,{"v":35500,"d":"R35,500.00"},{"$f":"E171*F171","v":{"v":35500,"d":"R35,500.00"}}]
[]
[null,"5.15.6","20A 2pole Isolator, in suitable York Box, for HVAC","No",6,0,{"$f":"E173*F173","v":0}]
[]
[null,"5.15.7","40A Isolator points with complete and suitable fitting, for stove","No",2,0,{"$f":"E175*F175","v":0}]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"Existing 4 CLR+Abl","index":9,"n_rows":175,"n_cols":16,"rows_kept":175,"merged":[[39,1,39,2],[85,1,85,2],[134,1,134,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,6,"Exisiting 4 CLR"]
[]
[null,6.1,"P&G's @ 10 % of items 2-15"]
[]
[null,7.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,8.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,9.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,10.1,"Excavation and backfilling in soft soil"]
[{"$nulls":3},"m³",null,null,"rate only"]
[null,11.1,"Cable and Data Sleeves"]
[]
[null,12.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,13.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"6.2.6","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"6.2.6","110mm Diameter","No",null,null,"rate only"]
[]
[null,6.6,"Draw Wires"]
[]
[null,"6.6.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":1150},0,{"$f":"F31*E31","v":0}]
[]
[null,6.6,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"6.6.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,6.6,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"6.6.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"6.6.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"6.6.6","10mm 2 core cable","No",2,0,{"$f":"E51*F51","v":0}]
[]
[null,"6.6.6","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,6.6,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"6.6.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"6.6.2","25mm PVC conduit ","m",400,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"6.6.6","20mm PVC conduit ","m",750,0,{"$f":"F67*E67","v":0}]
[]
[null,"6.6.6","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,6.7,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"6.7.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,6.7,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"6.7.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"6.7.2","100 x 100 x 50mm","No",12,0,{"$f":"F83*E83","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,6.8,"PVC Wiring in conduits:"]
[]
[null,"6.8.1","1.5mm² house wire for lights circuits","m",{"$f":"150*3","v":450},0,{"$f":"F90*E90","v":0},null,null,{"$f":"970/100","v":{"v":9.7,"d":"R9.70"}}]
[]
[null,"6.8.2","4mm² house wire for lights socket outlets and isolators","m",550,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"6.8.6","2.5mm² ","m",{"$f":"E90","v":450},0,{"$f":"F98*E98","v":0}]
[]
[null,"6.8.6","4mm² ","m",null,null,"rate only"]
[]
[null,6.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"6.9.1","1 Lever 1 way","No",4,0,{"$f":"F106*E106","v":0}]
[]
[null,"6.9.2","1 Lever 2 way","No",null,null,"rate only"]
[]
[null,"6.9.6","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"6.9.6","3 Lever 1 way","No",null,null,"rate only"]
[]
[null,"6.9.6","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,6.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"6.10.1","16A single socket outlets - ZA plug","No",8,0,{"$f":"F126*E126","v":0}]
[]
[null,"6.10.2","16A  double socket outlets - ZA plug","No",null,null,"Rate only"]
[]
[null,"6.10.6","Type D Socket outlet","No",4,0,{"$f":"E130*F130","v":0}]
[]
[null,"6.10.6","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G133)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G134","v":0}]
[]
[null,6.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"6.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"6.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"6.11.6","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",15,0,{"$f":"E147*F147","v":0}]
[]
[null,"6.11.6","15W LED Round Bulkhead 4000K","No",8,0,{"$f":"F149*E149","v":0}]
[]
[null,"6.11.6","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",null,null,"rate only"]
[]
[null,6.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"6.12.1","Building installation","Sum",1,{"v":6000,"d":"R6,000.00"},{"$f":"F157*E157","v":{"v":6000,"d":"R6,000.00"}}]
[]
[null,6.16,"Others"]
[]
[null,"6.16.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"6.16.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"6.16.6","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",null,null,"Rate only"]
[]
[null,"6.16.6","DATA and Telephone points on must include draw box, blank cover plate, etc,","No",null,null,"Rate only"]
[]
[null,"6.16.6","Provide the Sum of R 38,500.00 for earthing and lightning protection","Sum",1,{"v":38500,"d":"R38,500.00"},{"$f":"E169*F169","v":{"v":38500,"d":"R38,500.00"}}]
[]
[null,"6.16.6","Provide the sum of R 25 000,00 for the removal of electrical installations in the existing classrooms","No",1,0,{"$f":"E171*F171","v":0}]
[]
[null,"6.16.7","40A Isolator points with complete and suitable fitting, for stove","No",2,0,{"$f":"E173*F173","v":0}]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"Science Lab + Library","index":10,"n_rows":171,"n_cols":16,"rows_kept":171,"merged":[[39,1,39,2],[85,1,85,2],[134,1,134,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,7,"Science Lab + Library"]
[]
[null,7.1,"P&G's @ 10 % of items 2-15"]
[]
[null,8.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,9.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,10.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,11.1,"Excavation and backfilling in soft soil"]
[{"$nulls":3},"m³",null,null,"rate only"]
[null,12.1,"Cable and Data Sleeves"]
[]
[null,13.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,14.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"7.2.7","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"7.2.7","110mm Diameter","No",null,null,"rate only"]
[]
[null,7.7,"Draw Wires"]
[]
[null,"7.7.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":1250},0,{"$f":"F31*E31","v":0}]
[]
[null,7.7,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"7.7.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,7.7,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"7.7.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"7.7.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"7.7.7","10mm 2 core cable","No",2,0,{"$f":"E51*F51","v":0}]
[]
[null,"7.7.7","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,7.7,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"7.7.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"7.7.2","25mm PVC conduit ","m",600,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"7.7.7","20mm PVC conduit ","m",650,0,{"$f":"F67*E67","v":0}]
[]
[null,"7.7.7","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,7.7,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"7.7.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,7.7,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"7.7.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"7.7.2","100 x 100 x 50mm","No",12,0,{"$f":"F83*E83","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,7.8,"PVC Wiring in conduits:"]
[]
[null,"7.8.1","1.5mm² house wire for lights circuits","m",550,0,{"$f":"F90*E90","v":0},null,null,{"$f":"970/100","v":{"v":9.7,"d":"R9.70"}}]
[]
[null,"7.8.2","4mm² house wire for lights socket outlets and isolators","m",650,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"7.8.7","2.5mm² ","m",{"$f":"E90","v":550},0,{"$f":"F98*E98","v":0}]
[]
[null,"7.8.7","4mm² ","m",null,null,"rate only"]
[]
[null,7.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"7.9.1","1 Lever 1 way","No",4,0,{"$f":"F106*E106","v":0}]
[]
[null,"7.9.2","1 Lever 2 way","No",null,null,"rate only"]
[]
[null,"7.9.7","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"7.9.7","3 Lever 1 way","No",null,null,"rate only"]
[]
[null,"7.9.7","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,7.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"7.10.1","16A single socket outlets - ZA plug","No",8,0,{"$f":"F126*E126","v":0}]
[]
[null,"7.10.2","16A  double socket outlets - ZA plug","No",null,null,"Rate only"]
[]
[null,"7.10.7","Type F Socket outlet","No",1,0,{"$f":"E130*F130","v":0}]
[]
[null,"7.10.7","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G133)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G134","v":0}]
[]
[null,7.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"7.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"7.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"7.11.7","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",15,0,{"$f":"E147*F147","v":0}]
[]
[null,"7.11.7","15W LED Round Bulkhead 4000K","No",8,0,{"$f":"F149*E149","v":0}]
[]
[null,"7.11.7","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",null,null,"rate only"]
[]
[null,7.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"7.12.1","Building installation","Sum",1,{"v":6000,"d":"R6,000.00"},{"$f":"F157*E157","v":{"v":6000,"d":"R6,000.00"}}]
[]
[null,7.17,"Others"]
[]
[null,"7.17.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"7.17.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"7.17.7","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",null,null,"Rate only"]
[]
[null,"7.17.7","Provide the sum of R 28 500,00 for the removal of electrical installations in the existing classrooms","Sum",1,{"v":28500,"d":"R28,500.00"},{"$f":"E167*F167","v":{"v":28500,"d":"R28,500.00"}}]
[]
[null,"7.17.8","40A Isolator points with complete and suitable fitting, for stove","No",6,0,{"$f":"E169*F169","v":0}]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"New 4 CLR+Abl","index":11,"n_rows":173,"n_cols":16,"rows_kept":173,"merged":[[39,1,39,2],[85,1,85,2],[134,1,134,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,9,"Exisiting 4 CLR"]
[]
[null,9.1,"P&G's @ 10 % of items 2-15"]
[]
[null,10.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,11.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,12.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,13.1,"Excavation and backfilling in soft soil"]
[{"$nulls":3},"m³",null,null,"rate only"]
[null,14.1,"Cable and Data Sleeves"]
[]
[null,15.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,16.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"9.2.9","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"9.2.9","110mm Diameter","No",null,null,"rate only"]
[]
[null,9.9,"Draw Wires"]
[]
[null,"9.9.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":1150},0,{"$f":"F31*E31","v":0}]
[]
[null,9.9,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"9.9.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,9.9,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"9.9.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"9.9.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"9.9.9","10mm 2 core cable","No",2,0,{"$f":"E51*F51","v":0}]
[]
[null,"9.9.9","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,9.9,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"9.9.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"9.9.2","25mm PVC conduit ","m",400,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"9.9.9","20mm PVC conduit ","m",750,0,{"$f":"F67*E67","v":0}]
[]
[null,"9.9.9","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,9.7,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"9.7.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,9.7,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"9.7.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"9.7.2","100 x 100 x 50mm","No",12,0,{"$f":"F83*E83","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,9.8,"PVC Wiring in conduits:"]
[]
[null,"9.8.1","1.5mm² house wire for lights circuits","m",{"$f":"150*3","v":450},0,{"$f":"F90*E90","v":0},null,null,{"$f":"970/100","v":{"v":9.7,"d":"R9.70"}}]
[]
[null,"9.8.2","4mm² house wire for lights socket outlets and isolators","m",600,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"9.8.9","2.5mm² ","m",{"$f":"E90","v":450},0,{"$f":"F98*E98","v":0}]
[]
[null,"9.8.9","4mm² ","m",null,null,"rate only"]
[]
[null,9.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"9.9.1","1 Lever 1 way","No",4,0,{"$f":"F106*E106","v":0}]
[]
[null,"9.9.2","1 Lever 2 way","No",null,null,"rate only"]
[]
[null,"9.9.9","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"9.9.9","3 Lever 1 way","No",null,null,"rate only"]
[]
[null,"9.9.9","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,9.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"9.10.1","16A single socket outlets - ZA plug","No",8,0,{"$f":"F126*E126","v":0}]
[]
[null,"9.10.2","16A  double socket outlets - ZA plug","No",null,null,"Rate only"]
[]
[null,"9.10.9","Type D Socket outlet","No",4,0,{"$f":"E130*F130","v":0}]
[]
[null,"9.10.9","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G133)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G134","v":0}]
[]
[null,9.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"9.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"9.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"9.11.9","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",15,0,{"$f":"E147*F147","v":0}]
[]
[null,"9.11.9","15W LED Round Bulkhead 4000K","No",8,0,{"$f":"F149*E149","v":0}]
[]
[null,"9.11.9","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",null,null,"rate only"]
[]
[null,9.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"9.12.1","Building installation","Sum",1,{"v":6000,"d":"R6,000.00"},{"$f":"F157*E157","v":{"v":6000,"d":"R6,000.00"}}]
[]
[null,9.19,"Others"]
[]
[null,"9.19.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"9.19.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"9.19.9","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",{"$f":"50","v":50},null,"Rate only"]
[]
[null,"9.19.9","DATA and Telephone points on must include draw box, blank cover plate, etc,","No",null,null,"Rate only"]
[]
[null,"9.19.9","Provide the Sum of R 38,500.00 for earthing and lightning protection","Sum",1,{"v":38500,"d":"R38,500.00"},{"$f":"E169*F169","v":{"v":38500,"d":"R38,500.00"}}]
[]
[null,"9.19.10","40A Isolator points with complete and suitable fitting, for stove","No",2,0,{"$f":"E171*F171","v":0}]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"HOD+Multipurpose+Maths Lab","index":12,"n_rows":171,"n_cols":16,"rows_kept":171,"merged":[[39,1,39,2],[85,1,85,2],[134,1,134,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,10,"Exisiting 4 CLR"]
[]
[null,10.1,"P&G's @ 10 % of items 2-15"]
[]
[null,11.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,12.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,13.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,14.1,"Excavation and backfilling in soft soil"]
[{"$nulls":3},"m³",null,null,"rate only"]
[null,15.1,"Cable and Data Sleeves"]
[]
[null,16.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,17.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"10.2.10","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"10.2.10","110mm Diameter","No",null,null,"rate only"]
[]
[null,10.1,"Draw Wires"]
[]
[null,"10.10.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":750},0,{"$f":"F31*E31","v":0}]
[]
[null,10.1,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"10.10.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,10.1,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"10.10.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"10.10.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"10.10.10","10mm 2 core cable","No",2,0,{"$f":"E51*F51","v":0}]
[]
[null,"10.10.10","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,10.1,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"10.10.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"10.10.2","25mm PVC conduit ","m",350,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"10.10.10","20mm PVC conduit ","m",400,0,{"$f":"F67*E67","v":0}]
[]
[null,"10.10.10","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,10.7,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"10.7.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,10.7,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"10.7.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"10.7.2","100 x 100 x 50mm","No",12,0,{"$f":"F83*E83","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,10.8,"PVC Wiring in conduits:"]
[]
[null,"10.8.1","1.5mm² house wire for lights circuits","m",350,0,{"$f":"F90*E90","v":0},null,null,{"$f":"970/100","v":{"v":9.7,"d":"R9.70"}}]
[]
[null,"10.8.2","4mm² house wire for lights socket outlets and isolators","m",400,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"10.8.10","2.5mm² ","m",{"$f":"E90","v":350},0,{"$f":"F98*E98","v":0}]
[]
[null,"10.8.10","4mm² ","m",null,null,"rate only"]
[]
[null,10.1,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"10.10.1","1 Lever 1 way","No",4,0,{"$f":"F106*E106","v":0}]
[]
[null,"10.10.2","1 Lever 2 way","No",null,null,"rate only"]
[]
[null,"10.10.10","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"10.10.10","3 Lever 1 way","No",null,null,"rate only"]
[]
[null,"10.10.10","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,10.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"10.10.1","16A single socket outlets - ZA plug","No",8,0,{"$f":"F126*E126","v":0}]
[]
[null,"10.10.2","16A  double socket outlets - ZA plug","No",null,null,"Rate only"]
[]
[null,"10.10.10","Type F Socket outlet","No",1,0,{"$f":"E130*F130","v":0}]
[]
[null,"10.10.10","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G133)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G134","v":0}]
[]
[null,10.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"10.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"10.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"10.11.10","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",15,0,{"$f":"E147*F147","v":0}]
[]
[null,"10.11.10","15W LED Round Bulkhead 4000K","No",8,0,{"$f":"F149*E149","v":0}]
[]
[null,"10.11.10","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",null,null,"rate only"]
[]
[null,10.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"10.12.1","Building installation","Sum",1,{"v":6000,"d":"R6,000.00"},{"$f":"F157*E157","v":{"v":6000,"d":"R6,000.00"}}]
[]
[null,10.11,"Others"]
[]
[null,"10.110.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"10.110.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"10.110.10","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",{"$f":"50","v":50},null,"Rate only"]
[]
[null,"10.110.10","40A Isolator points with complete and suitable fitting, for stove","No",2,0,{"$f":"E167*F167","v":0}]
[]
[null,"10.110.10","Provide the Sum of R 38,500.00 for earthing and lightning protection","Sum",1,{"v":38500,"d":"R38,500.00"},{"$f":"E169*F169","v":{"v":38500,"d":"R38,500.00"}}]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"Caretakers Room + Store","index":13,"n_rows":173,"n_cols":16,"rows_kept":173,"merged":[[39,1,39,2],[85,1,85,2],[134,1,134,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,12,"CARETAKER + STORAGE"]
[]
[null,12.1,"P&G's @ 10 % of items 2-15"]
[]
[null,13.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,14.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,15.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,16.1,"Excavation and backfilling in soft soil"]
[{"$nulls":3},"m³",null,null,"rate only"]
[null,17.1,"Cable and Data Sleeves"]
[]
[null,18.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,19.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"12.2.12","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"12.2.12","110mm Diameter","No",null,null,"rate only"]
[]
[null,12.12,"Draw Wires"]
[]
[null,"12.12.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":400},0,{"$f":"F31*E31","v":0}]
[]
[null,12.12,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"12.12.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,12.12,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"12.12.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"12.12.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"12.12.12","10mm 2 core cable","No",2,0,{"$f":"E51*F51","v":0}]
[]
[null,"12.12.12","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,12.12,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"12.12.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"12.12.2","25mm PVC conduit ","m",150,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"12.12.12","20mm PVC conduit ","m",250,0,{"$f":"F67*E67","v":0}]
[]
[null,"12.12.12","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,12.7,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"12.7.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,12.7,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"12.7.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"12.7.2","100 x 100 x 50mm","No",12,0,{"$f":"F83*E83","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,12.12,"PVC Wiring in conduits:"]
[]
[null,"12.12.1","1.5mm² house wire for lights circuits","m",220,0,{"$f":"F90*E90","v":0},null,null,{"$f":"970/100","v":{"v":9.7,"d":"R9.70"}}]
[]
[null,"12.12.2","4mm² house wire for lights socket outlets and isolators","m",250,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"12.12.12","2.5mm² ","m",{"$f":"E90","v":220},0,{"$f":"F98*E98","v":0}]
[]
[null,"12.12.12","4mm² ","m",null,null,"rate only"]
[]
[null,12.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"12.9.1","1 Lever 1 way","No",4,0,{"$f":"F106*E106","v":0}]
[]
[null,"12.9.2","1 Lever 2 way","No",null,null,"rate only"]
[]
[null,"12.9.12","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"12.9.12","3 Lever 1 way","No",null,null,"rate only"]
[]
[null,"12.9.12","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,12.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"12.10.1","16A single socket outlets - ZA plug","No",8,0,{"$f":"F126*E126","v":0}]
[]
[null,"12.10.2","16A  double socket outlets - ZA plug","No",null,null,"Rate only"]
[]
[null,"12.10.12","Type F Socket outlet","No",null,null,"rate only"]
[]
[null,"12.10.12","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G133)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G134","v":0}]
[]
[null,12.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"12.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"12.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"12.11.12","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",15,0,{"$f":"E147*F147","v":0}]
[]
[null,"12.11.12","15W LED Round Bulkhead 4000K","No",8,0,{"$f":"F149*E149","v":0}]
[]
[null,"12.11.12","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",null,null,"rate only"]
[]
[null,12.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"12.12.1","Building installation","Sum",1,{"v":4000,"d":"R4,000.00"},{"$f":"F157*E157","v":{"v":4000,"d":"R4,000.00"}}]
[]
[null,12.112,"Others"]
[]
[null,"12.112.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"12.112.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"12.112.12","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",null,null,"Rate only"]
[]
[null,"12.112.12","DATA and Telephone points on must include draw box, blank cover plate, etc,","No",null,null,"Rate only"]
[]
[null,"12.112.12","Provide the Sum of R 12,500.00 for earthing and lightning protection","Sum",1,{"v":12500,"d":"R12,500.00"},{"$f":"E169*F169","v":{"v":12500,"d":"R12,500.00"}}]
[]
[null,"12.112.7","40A Isolator points with complete and suitable fitting, for stove","No",null,null,"rate only"]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"TuckShop","index":14,"n_rows":173,"n_cols":16,"rows_kept":173,"merged":[[39,1,39,2],[85,1,85,2],[134,1,134,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,13,"TUCKSHOP"]
[]
[null,13.1,"P&G's @ 10 % of items 2-15"]
[]
[null,14.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,15.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,16.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,17.1,"Excavation and backfilling in soft soil"]
[{"$nulls":3},"m³",null,null,"rate only"]
[null,18.1,"Cable and Data Sleeves"]
[]
[null,19.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,20.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"13.2.13","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"13.2.13","110mm Diameter","No",null,null,"rate only"]
[]
[null,13.13,"Draw Wires"]
[]
[null,"13.13.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":270},0,{"$f":"F31*E31","v":0}]
[]
[null,13.13,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"13.13.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,13.13,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"13.13.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"13.13.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"13.13.13","10mm 2 core cable","No",2,0,{"$f":"E51*F51","v":0}]
[]
[null,"13.13.13","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,13.13,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"13.13.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"13.13.2","25mm PVC conduit ","m",150,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"13.13.13","20mm PVC conduit ","m",120,0,{"$f":"F67*E67","v":0}]
[]
[null,"13.13.13","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,13.7,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"13.7.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,13.7,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"13.7.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"13.7.2","100 x 100 x 50mm","No",12,0,{"$f":"F83*E83","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,13.13,"PVC Wiring in conduits:"]
[]
[null,"13.13.1","1.5mm² house wire for lights circuits","m",250,0,{"$f":"F90*E90","v":0},null,null,{"$f":"970/100","v":{"v":9.7,"d":"R9.70"}}]
[]
[null,"13.13.2","4mm² house wire for lights socket outlets and isolators","m",250,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"13.13.13","2.5mm² ","m",{"$f":"E90","v":250},0,{"$f":"F98*E98","v":0}]
[]
[null,"13.13.13","4mm² ","m",null,null,"rate only"]
[]
[null,13.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"13.9.1","1 Lever 1 way","No",4,0,{"$f":"F106*E106","v":0}]
[]
[null,"13.9.2","1 Lever 2 way","No",null,null,"rate only"]
[]
[null,"13.9.13","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"13.9.13","3 Lever 1 way","No",null,null,"rate only"]
[]
[null,"13.9.13","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,13.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"13.10.1","16A single socket outlets - ZA plug","No",8,0,{"$f":"F126*E126","v":0}]
[]
[null,"13.10.2","16A  double socket outlets - ZA plug","No",null,null,"Rate only"]
[]
[null,"13.10.13","Type F Socket outlet","No",null,null,"rate only"]
[]
[null,"13.10.13","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G133)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G134","v":0}]
[]
[null,13.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"13.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"13.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"13.11.13","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",15,0,{"$f":"E147*F147","v":0}]
[]
[null,"13.11.13","15W LED Round Bulkhead 4000K","No",8,0,{"$f":"F149*E149","v":0}]
[]
[null,"13.11.13","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",null,null,"rate only"]
[]
[null,13.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"13.12.1","Building installation","Sum",1,{"v":4000,"d":"R4,000.00"},{"$f":"F157*E157","v":{"v":4000,"d":"R4,000.00"}}]
[]
[null,13.113,"Others"]
[]
[null,"13.113.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"13.113.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"13.113.13","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",{"$f":"50","v":50},null,"Rate only"]
[]
[null,"13.113.13","DATA and Telephone points on must include draw box, blank cover plate, etc,","No",null,null,"Rate only"]
[]
[null,"13.113.13","Provide the Sum of R 12,500.00 for earthing and lightning protection","Sum",1,{"v":12500,"d":"R12,500.00"},{"$f":"E169*F169","v":{"v":12500,"d":"R12,500.00"}}]
[]
[null,"13.113.7","40A Isolator points with complete and suitable fitting, for stove","No",null,null,"rate only"]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"Changerooms","index":15,"n_rows":173,"n_cols":16,"rows_kept":173,"merged":[[39,1,39,2],[85,1,85,2],[134,1,134,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,14,"CHANGEROOMS"]
[]
[null,14.1,"P&G's @ 10 % of items 2-15"]
[]
[null,15.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,16.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,17.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,18.1,"Excavation and backfilling in soft soil"]
[{"$nulls":3},"m³",null,null,"rate only"]
[null,19.1,"Cable and Data Sleeves"]
[]
[null,20.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,21.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"14.2.14","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"14.2.14","110mm Diameter","No",null,null,"rate only"]
[]
[null,14.14,"Draw Wires"]
[]
[null,"14.14.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":270},0,{"$f":"F31*E31","v":0}]
[]
[null,14.14,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"14.14.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,14.14,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"14.14.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"14.14.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"14.14.14","10mm 2 core cable","No",2,0,{"$f":"E51*F51","v":0}]
[]
[null,"14.14.14","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,14.14,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"14.14.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"14.14.2","25mm PVC conduit ","m",150,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"14.14.14","20mm PVC conduit ","m",120,0,{"$f":"F67*E67","v":0}]
[]
[null,"14.14.14","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,14.7,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"14.7.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,14.7,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"14.7.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"14.7.2","100 x 100 x 50mm","No",12,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,14.14,"PVC Wiring in conduits:"]
[]
[null,"14.14.1","1.5mm² house wire for lights circuits","m",250,0,{"$f":"F90*E90","v":0},null,null,{"$f":"970/100","v":{"v":9.7,"d":"R9.70"}}]
[]
[null,"14.14.2","4mm² house wire for lights socket outlets and isolators","m",60,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"14.14.14","2.5mm² ","m",{"$f":"E90","v":250},0,{"$f":"F98*E98","v":0}]
[]
[null,"14.14.14","4mm² ","m",null,null,"rate only"]
[]
[null,14.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"14.9.1","1 Lever 1 way","No",4,0,{"$f":"F106*E106","v":0}]
[]
[null,"14.9.2","1 Lever 2 way","No",null,null,"rate only"]
[]
[null,"14.9.14","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"14.9.14","3 Lever 1 way","No",null,null,"rate only"]
[]
[null,"14.9.14","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,14.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"14.10.1","16A single socket outlets - ZA plug","No",6,0,{"$f":"F126*E126","v":0}]
[]
[null,"14.10.2","16A  double socket outlets - ZA plug","No",null,null,"Rate only"]
[]
[null,"14.10.14","Type F Socket outlet","No"]
[]
[null,"14.10.14","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G133)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G134","v":0}]
[]
[null,14.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"14.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"14.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"14.11.14","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",15,0,{"$f":"E147*F147","v":0}]
[]
[null,"14.11.14","15W LED Round Bulkhead 4000K","No",8,0,{"$f":"F149*E149","v":0}]
[]
[null,"14.11.14","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",null,null,"rate only"]
[]
[null,14.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"14.12.1","Building installation","Sum",1,{"v":4000,"d":"R4,000.00"},{"$f":"F157*E157","v":{"v":4000,"d":"R4,000.00"}}]
[]
[null,14.114,"Others"]
[]
[null,"14.114.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"14.114.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"14.114.14","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",null,null,"Rate only"]
[]
[null,"14.114.14","DATA and Telephone points on must include draw box, blank cover plate, etc,","No",null,null,"Rate only"]
[]
[null,"14.114.14","Provide the Sum of R 10,000.00 for earthing and lightning protection","Sum",1,{"v":10000,"d":"R10,000.00"},{"$f":"E169*F169","v":{"v":10000,"d":"R10,000.00"}}]
[]
[null,"14.114.7","40A Isolator points with complete and suitable fitting, for stove","No",null,null,"rate only"]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"Guard House","index":16,"n_rows":173,"n_cols":16,"rows_kept":173,"merged":[[39,1,39,2],[85,1,85,2],[134,1,134,2]]}
[]
[null,"ITEM","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,15,"GUARD HOUSE"]
[]
[null,15.1,"P&G's @ 10 % of items 2-15"]
[]
[null,16.1,"General trenching work for sleeves along the routes as pegged out on site after co-ordination with other services"]
[]
[null,17.1,"Allowance must be made for the sifting of soil when required, removal and carting away of all stones and rocks including dumping off site. Backfilling and compaction shall be carried out as specified for overall siteworks."]
[]
[null,18.1,"Trenching through floor for sleeves","m³",null,null,"rate only"]
[]
[null,19.1,"Excavation and backfilling in soft soil"]
[{"$nulls":3},"m³",null,null,"rate only"]
[null,20.1,"Cable and Data Sleeves"]
[]
[null,21.1,"Supply and installation of PVC Sleeves through floor construction to power distribution board and communication board complete with standard radius sleeve bends"]
[]
[null,22.1,"50 mm Diameter for Power Cables ","m",60,0,{"$f":"F20*E20","v":0}]
[null,null,"110mm Diameter for power cable","m",null,null,"rate only"]
[]
[null,null,"Radius bends:"]
[]
[null,"15.2.15","75mm Diameter ","No",null,null,"rate only"]
[]
[null,"15.2.15","110mm Diameter","No",null,null,"rate only"]
[]
[null,15.15,"Draw Wires"]
[]
[null,"15.15.1","Supply and install a 0,6mm diameter galvanised draw wire in sleeves and conduit for data installation","m",{"$f":"E63+E67","v":250},0,{"$f":"F31*E31","v":0}]
[]
[null,15.15,"Distribution Boards"]
[]
[null,null,"Supply, delivery, storage and submission of workshop drawings for the Flush mounted architrave steel type power distribution boards complete with flush trays,doors,switch gear mounting trays, copper busbars, neutral and earth bars, correctly sized internal"]
[]
[null,"15.15.1","Supply and install a Distribution Board","No.",1,0,{"$f":"F37*E37","v":0}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G38)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G39","v":0}]
[]
[null,15.15,"Low Voltage PVC Cables"]
[null,null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
[null,"15.15.1","4mm 4 core PVC SWA Cable","m",null,null,"rate only"]
[]
[null,"15.15.2","2.5mm BCEW  ","m",null,null,"rate only"]
[]
[null,null,"Terminations:"]
[]
[null,"15.15.15","10mm 2 core cable","No",2,0,{"$f":"E51*F51","v":0}]
[]
[null,"15.15.15","6mm BCEW","No",1,0,{"$f":"E53*F53","v":0}]
[]
[null,15.15,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,null,"Built or Chase into brick or concrete work:"]
[]
[null,"15.15.1","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"15.15.2","25mm PVC conduit ","m",150,0,{"$f":"F63*E63","v":0}]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"15.15.15","20mm PVC conduit ","m",100,0,{"$f":"F67*E67","v":0}]
[]
[null,"15.15.15","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,15.7,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"15.7.1","20mm diameter 4 way type(round box)","No",45,0,{"$f":"F73*E73","v":0}]
[]
[null,15.7,"Wall Boxes"]
[]
[null,null,"Supply and installation of SABS approved galvanised pressed steel wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,null,"Flush mounted type:"]
[]
[null,"15.7.1","100 x 50 x 50mm","No",4,0,{"$f":"F81*E81","v":0}]
[]
[null,"15.7.2","100 x 100 x 50mm","No",12,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G40:G84)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G85","v":0}]
[]
[null,15.15,"PVC Wiring in conduits:"]
[]
[null,"15.15.1","1.5mm² house wire for lights circuits","m",250,0,{"$f":"F90*E90","v":0},null,null,{"$f":"970/100","v":{"v":9.7,"d":"R9.70"}}]
[]
[null,"15.15.2","4mm² house wire for lights socket outlets and isolators","m",60,0,{"$f":"F92*E92","v":0}]
[]
[null,null,"Stranded Bare Copper Earth Wire"]
[]
[null,null,"Supply and installation of stranded bare copper earth wire along with PVC wiring in conduits. Tendered rates shall make provision for wastage."]
[]
[null,"15.15.15","2.5mm² ","m",{"$f":"E90","v":250},0,{"$f":"F98*E98","v":0}]
[]
[null,"15.15.15","4mm² ","m",null,null,"rate only"]
[]
[null,15.9,"Light Switches"]
[]
[null,null,"Supply and installation of SABS approved type 16A flush and surface type light switches. Final paint finishes shall be confirmed at a later stage, allowance shall however be made as specified in the general specification. "]
[]
[null,"15.9.1","1 Lever 1 way","No",2,0,{"$f":"F106*E106","v":0}]
[]
[null,"15.9.2","1 Lever 2 way","No",null,null,"rate only"]
[]
[null,"15.9.15","3 Lever 2 way","No",null,null,"rate only"]
[]
[null,"15.9.15","3 Lever 1 way","No",null,null,"rate only"]
[]
[null,"15.9.15","Photo cell","No",1,0,{"$f":"E114*F114","v":0}]
[]
[null,15.1,"Socket Outlets"]
[]
[null,null,"Supply and installation of SABS approved switched and unswitched type flush and surface mounted type 16A switched socket outlets suitable for mounting in flush steel wall boxes or in steel pedestal units or on surface."]
[]
[null,null,"The final colour of the paint finish shall be confirmed at a later stage, allowance shall be made as specified in the specification."]
[]
[null,null,"All flush type boxes and special pedestals measured elsewhere."]
[]
[null,null,"Flush switched sockets type:"]
[]
[null,"15.10.1","16A single socket outlets - ZA plug","No",4,0,{"$f":"F126*E126","v":0}]
[]
[null,"15.10.2","16A  double socket outlets - ZA plug","No",null,null,"Rate only"]
[]
[null,"15.10.15","Type F Socket outlet","No",null,null,"rate only"]
[]
[null,"15.10.15","Power Pole","No",null,null,"rate only"]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G86:G133)","v":0}]
[null,"TOTAL FOR BILL - BROUGHT FORWARD ",{"$nulls":4},{"$f":"G134","v":0}]
[]
[null,15.11,"Light Fittings"]
[]
[null,null,"Supply, delivery to site, storage and installation of the below specified light fittings complete with lamps,  fixing material, mounting  and tubes. Allowance must be made in the rates for all the required fixing materials and accessories.  "]
[]
[null,null,"Fittings to be equal and similar approved to the below quoted manufacture."]
[]
[null,"15.11.1","Type F1: 2x14W 600mm  LED decorative fluorescent light ","No",null,null,"rate only"]
[{"$nulls":15},{"$f":"60*12","v":720}]
[null,"15.11.2","Type W1: 2x14W 600mm LED decorative vapour fluorescent light ","No",null,null,"rate only"]
[]
[null,"15.11.15","Opal E-Battien 4FT 1140mm 45W - 4000K - IP20","No",2,0,{"$f":"E147*F147","v":0}]
[]
[null,"15.11.15","15W LED Round Bulkhead 4000K","No",4,0,{"$f":"F149*E149","v":0}]
[]
[null,"15.11.15","Suspended cosmos 100W IP65 1-10V dimmable high bay","No",null,null,"rate only"]
[]
[null,15.12,"Electrical Tests"]
[]
[null,null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
[null,"15.12.1","Building installation","Sum",1,{"v":4000,"d":"R4,000.00"},{"$f":"F157*E157","v":{"v":4000,"d":"R4,000.00"}}]
[]
[null,15.115,"Others"]
[]
[null,"15.115.1","300 x 300mm - Telephone & Data DB","No",null,null,"Rate only"]
[]
[null,"15.115.2","100 x 100 x 50mm - Draw box for Communication complete with blank cover","No",null,null,"Rate only"]
[]
[null,"15.115.15","2 compartment power skirting complete with socket outlets and blabks for telephone and data points.","m",{"$f":"50","v":50},null,"Rate only"]
[]
[null,"15.115.15","DATA and Telephone points on must include draw box, blank cover plate, etc,","No",null,null,"Rate only"]
[]
[null,"15.115.15","Provide the Sum of R 10 000.00 for earthing and lightning protection","Sum",1,{"v":10000,"d":"R10,000.00"},{"$f":"E169*F169","v":{"v":10000,"d":"R10,000.00"}}]
[]
[null,"15.115.7","40A Isolator points with complete and suitable fitting, for stove","No",null,null,"rate only"]
[]
[null," ","TOTAL FOR BILL  PER BLOCK (3X FLOORS)- CARRIED FORWARD TO SUMMARY",{"$nulls":3},0]

{"sheet":"Area Lighting","index":17,"n_rows":114,"n_cols":19,"rows_kept":114,"hidden":true}
[]
[]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","TOTAL"]
[]
[null,6,"AREA LIGHTING"]
[]
[null,6.1,"LOW VOLTAGE CABLE"]
[null,null,"For the Supply, delivery to Site and Installation of the following Low Voltage Cable:(600/1000V PVC PVC SWA  Cu)"]
[null,"6.1.1","4mm x 4 core","m",null,null,{"$f":"E9*F9","v":0}]
[null,"6.1.2","16mm x 2 core","m",null,null,"rate only"]
[null,"6.1.3","2.5mm x 2 core","m",1500,{"v":12,"d":"R 12.00"},{"$f":"F11*E11","v":{"v":18000,"d":"R 18,000.00"}}]
[]
[null,6.2,"Provide the provissional sum of ZAR 1,550,900.00 for the refurbishment of Block A,B,C,D,E and Administration block ( This includes small power and lighting and earthing and lightning protection)",null,1550900]
[null,null,"For the Supply and Installation of the following",{"$nulls":15},{"$f":"S13*650","v":0}]
[null,null,"BCE Wire to run with LV Cables:",null,null,{"$f":"SUM(F6:F13)","v":{"v":12,"d":"R 12.00"}}]
[null,"6.2.1","16mm sq ( With 25mm sq Cable )","m",null,{"$f":"F15*0.1","v":{"v":1.2000000000000002,"d":"R 1.20"}}]
[null,"6.2.2","10mm sq ( With 10 - 16mm sq Cable ) ","m",null,{"$f":"F16+F15","v":{"v":13.2,"d":"R 13.20"}}]
[null,"6.2.3","1.5mm   sq ( With 2.5mm sq cable)","m",null,{"$f":"F17*0.15","v":{"v":1.9799999999999998,"d":"R 1.98"}},"rate only"]
[{"$nulls":5},{"$f":"F18+F17","v":{"v":15.18,"d":"R 15.18"}}]
[null,6.3,"LOW VOLTAGE CABLE TERMINATIONS"]
[null,null,"For the supply of Indoor terminations",null,{"v":42,"d":"42.00"}]
[null,null,"including suitable Lugs and Glands for the"]
[null,null,"Low Voltage Cable and BCE Wire:"]
[null,"6.3.1","25mm x 4 core","No.",null,null,"rate only"]
[null,"6.3.2","16mm x 4 core","No.",null,null,"rate only"]
[null,"6.3.3","16mm x 2 core","No.",null,null,"rate only"]
[null,"6.3.4","4mm x 2 core","No.",null,null,"rate only"]
[]
[null,6.4,"BARE COPPER EARTH WIRE (STRANDED)"]
[{"$nulls":5},{"$f":"5171811.67-2324872.67","v":{"v":2846939,"d":"R 2,846,939.00"}}]
[null,"6.4.1","BCEW 16mm sq ","No.",null,null,"rate only"]
[null,"6.4.2","BCEW 10mm sq ","No.",null,null,"rate only"]
[null,"6.4.3","BCEW  1.5mm sq ","No.",{"$f":"E11","v":1500},{"v":9,"d":"R 9.00"},{"$f":"F33*E33","v":{"v":13500,"d":"R 13,500.00"}}]
[]
[null,6.6,"LOW VOLTAGE CABLE JOINTS"]
[null,null,"For the Supply, delivery to Site and"]
[null,null,"Installation of the following Low Voltage Cable"]
[null,null,"Joints:"]
[null,"6.6.1","50mm x 4 core","No.",null,null,"rate only"]
[null,"6.6.2","16mm x 4 core","No.",null,null,"rate only"]
[null,"6.6.3","35mm x 2 core","No.",null,null,"rate only"]
[null,"6.6.4","6mm x 4 core","No.",null,null,"rate only"]
[]
[null,6.6,"Conduit Work"]
[]
[null,null,"Supply, delivery and installation of SABS approved PVC Conduits completed with all required conduit accessories.   "]
[]
[null,"6.6.1","Built or Chase into brick or concrete work:"]
[]
[null,"6.6.2","20mm PVC conduit ","m",null,null,"rate only"]
[]
[null,"6.6.3","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,null,"In Ceiling space and Timber work or along Purlins"]
[]
[null,"6.6.4","20mm PVC conduit ","m",300,{"v":25,"d":"R25.00"},{"$f":"F56*E56","v":{"v":7500,"d":"R7,500.00"}}]
[]
[null,"6.6.6","25mm PVC conduit ","m",null,null,"rate only"]
[]
[null,null,"Supply and installation of SABS approved conduit boxes, installed in the run of the conduit installation, cast into concrete and built into brickwork or flush inside false ceiling spaces, complete with all required conduit termination accessories. "]
[]
[null,"6.6.6","20mm diameter 4 way type(round box)","No",15,{"v":15,"d":"R15.00"},{"$f":"F62*E62","v":{"v":225,"d":"R225.00"}}]
[]
[null,null,"TOTAL FOR BILL - CARRIED FORWARD ",{"$nulls":3},{"$f":"SUM(G4:G62)","v":{"v":39225,"d":"R39,225.00"}}]
[null,null,"TOTAL BROUGHT  FORWARD",{"$nulls":3},{"$f":"G64","v":{"v":39225,"d":"R 39,225.00"}}]
[]
[null,6.8,"STREETLIGHTS"]
[]
[null,null,"Supply, delivery to Site and Installation of the following Street light units complete as per Specification."]
[]
[null,"6.8.1","Galvanised steel  poles, 2m mounting height complete accessories. Colour - Mineral Grey (K913) RAL 7045 ","No.",null,null,"rate only"]
[]
[null,"6.8.2","Galvanised steel  poles, 5m mounting height complete accessories. Colour - Mineral Grey (K913) RAL 7045 ","No.",2,{"$f":"3980*1.3","v":{"v":5174,"d":"R 5,174.00"}},{"$f":"E73*F73","v":{"v":10348,"d":"R 10,348.00"}}]
[]
[null,"6.8.3","Galvanised steel  poles, 8m mounting height complete accessories. Colour - Mineral Grey (K913) RAL 7045 ","No.",null,null,"rate only"]
[]
[null,"6.8.4","Galvanised steel  poles, 15m mounting height with 4 way mounting spigot complete accessories. Colour - Mineral Grey (K913) RAL 7045 ","No.",null,null,"rate only"]
[]
[null,"6.8.6","Beka shredder bollard 9LED/14W with all accessories","No.",null,null,"rate only"]
[]
[null,"6.8.6","Beka shredder zela with all accessories","No.",null,null,"rate only"]
[]
[null,"6.8.6","1200mm 2x14W LED vapourproof fluorescent luminaire","No",null,null,"rate only"]
[]
[null,"6.8.8"," GEN 0-1 LED STREETLIGHT 51W - 650mA - OPTIC 41810 - 4000K\nMOUNTED ON 5M POLES","No",16,{"$f":"1650*1.2*1.3","v":{"v":2574,"d":"R2,574.00"}},{"$f":"E85*F85","v":{"v":41184,"d":"R41,184.00"}}]
[]
[null,"6.8.9"," ZELA DECORATIVE LED POST-TOP LUMINAIRE 46W -\nMOUNTED ON 5M POLES","No.",2,{"v":2750,"d":"2,750.00"},{"$f":"E87*F87","v":{"v":5500,"d":"5,500.00"}}]
[]
[null,6.9,"WIRING ON THE POLE"]
[]
[]
[null,"6.9.1","600/1000V grade PVC insulated stranded copper conductors compete with terminations and accessories"]
[]
[null,"6.9.2","Norse cable 2.5mm2 or( Equivalent ) and other accessories for street light connection from ABC to Luminaire","m",null,null,"rate only"]
[]
[null,"6.9.3","1.5mm² Stranded  bare copper earth wire ","m",null,null,"rate only"]
[]
[null,"6.6","Earthing and Lightning Protection System"]
[]
[null,null,"Earth Electrode"]
[null,"6.6.1","Supply and installation of 10mm2 single core PVC SWA PVC cable earth Wire ","m",null,null,"rate only"]
[]
[null,"6.6.2","Earth spikes 1,2m long and accessories all the way to light fitting","No.",null,null,"rate only"]
[]
[null,"6.6.3","Supply and install earthing  accessories of the light fitting","No.",null,null,"rate only"]
[]
[null,"6.11","TESTING AND COMMISSIONING"]
[null,null,"Supply all Test equipment and Labour"]
[null,null,"for Testing, Commissioning and "]
[null,null,"Adjustment at Completion, as well as being"]
[null,null,"in attendance for any Inspections and Tests"]
[null,null,"that the Engineer may call for. All Eskom Standards and specifications will apply","sum",1,{"v":5000,"d":"R 5,000.00"},{"$f":"F112*E112","v":{"v":5000,"d":"R 5,000.00"}}]
[]
[null,null," TOTAL CARRIED TO SUMMARY",{"$nulls":3},{"$f":"SUM(G65:G112)","v":{"v":101257,"d":"R 101,257.00"}}]

{"sheet":"Lightning Protection ","index":18,"n_rows":66,"n_cols":6,"rows_kept":66,"hidden":true}
["ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[5,"Earthing and Lightning Protection System"]
[]
[null,"Low Voltage  Conductor"]
[null,"Supply and installation of  Bare Copper Earth Wire for Earthing and Bonding on earth mat with connecting accessories"]
[]
[5.1,"Bonding and Earth Conductors "]
[]
["5.1.2","Bonding Conductor 16mm2 CU conductor & connecting accessories","m",5,{"v":35,"d":"35.00"},{"$f":"E10*D10","v":{"v":175,"d":"175.00"}}]
[]
["5.1.3","Earth Conductor 50mm2 Cu or KWENA  conductor & connecting accessories","m",null,null,"rate only"]
[]
["5.1.4","Down Conductor 50mm2 Al conductor & connecting accessories","m",{"$f":"4*4","v":16},{"v":165,"d":"165.00"},{"$f":"E14*D14","v":{"v":2640,"d":"2,640.00"}}]
[]
["5.1.5","Exometric weld","No",4,{"v":230,"d":"230.00"},{"$f":"E16*D16","v":{"v":920,"d":"920.00"}}]
[]
[5.2,"Earth Electrode"]
[null,"Supply and installation of PVC SWA PVC cable and Bare Copper Earth Wire in sleeves and in trenches"]
[]
["5.2,1","Earth spikes 1,2m long and accessories","No",4,{"v":385,"d":"385.00"},{"$f":"E21*D21","v":{"v":1540,"d":"1,540.00"}}]
[]
[5.3,"Conduit Work"]
[]
[null,"Supply, delivery and installation of SABS approved PVC / Galvanised Conduits completed with all required conduit accessories.   "]
[]
[null,"Built or Chase into brick or concrete work:"]
[]
["5.3.1","30mm PVC Conduit","m",8,{"v":35,"d":"35.00"},{"$f":"E29*D29","v":{"v":280,"d":"280.00"}}]
[]
["5.3.2","30mm Galvanised Conduit","m",null,null,"rate only"]
[]
[5.4,"Test Joint Wall Boxes"]
[null,"Supply and installation of SABS approved LPS wall boxes for building flush into brickwork or cast into concrete work."]
[]
[null,"Surface mounted type:"]
[]
["5.4.1","100 x 100 x 100mm box for LPS","No",4,{"v":190,"d":"190.00"},{"$f":"E38*D38","v":{"v":760,"d":"760.00"}}]
[]
["5.4.2","100 x 100 Blank cover for LPS ","No",{"$f":"D38","v":4},{"v":60,"d":"60.00"},{"$f":"E40*D40","v":{"v":240,"d":"240.00"}}]
[]
[5.5,"Electrical Tests"]
[]
[]
[null,"Making provision for the required inspection, tests and the commissioning of the complete installation and the issuing of the required certificate."]
[]
["5.5.1","Soil resistivity Test ","Sum",1,{"$f":"1800/3","v":{"v":600,"d":"600.00"}},{"$f":"E47*D47","v":{"v":600,"d":"600.00"}}]
[]
["5.5.2","Risk Assessment ","Sum",1,{"$f":"1500/3","v":{"v":500,"d":"500.00"}},{"$f":"E49*D49","v":{"v":500,"d":"500.00"}}]
[]
["5.5.3","Installations accessories including surge protection devices etc","No",3,{"v":450,"d":"450.00"},{"$f":"E51*D51","v":{"v":1350,"d":"1,350.00"}}]
[]
["5.5.4","Certificate of Compliance  as per IEC 62305:2010-2012","No",1,{"$f":"1500/3","v":{"v":500,"d":"500.00"}},{"$f":"E53*D53","v":{"v":500,"d":"500.00"}}]
[]
[5.6,"Others"]
[]
["5.6.1","Design documentation","Sum",1,{"$f":"1800/3","v":{"v":600,"d":"600.00"}},{"$f":"E57*D57","v":{"v":600,"d":"600.00"}}]
[]
["5.6.2","As Built documentation","Sum",1,{"$f":"1500/3","v":{"v":500,"d":"500.00"}},{"$f":"E59*D59","v":{"v":500,"d":"500.00"}}]
[]
["5.6.3","Service detection tests","Sum",null,null,"rate only"]
[]
["5.6.4","Sundries and other associated items","Sum",1,null,{"$f":"E63*D63","v":{"v":0,"d":"0.00"}}]
[]
[]
[null,"TOTAL BID PRICE  VAT INCL",{"$nulls":3},{"$f":"SUM(F6:F65)","v":{"v":10605,"d":"ZAR 10,605.00"}}]

{"sheet":"Refuse Area","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}

{"sheet":"Fire Supression","index":20,"n_rows":184,"n_cols":10,"rows_kept":184,"hidden":true,"merged":[[32,0,32,1],[33,0,33,1],[61,0,61,1],[62,0,62,1]]}
["ITEM","DESCRIPTION","UNIT","QTY","SUPPLY","INSTALL","AMOUNT"]
[5]
[5.1,"LECTURE HALL"]
[]
["5.1.1","VALVE CHAMBER"]
["5.1.1.1","Schedule 40 and 100mm norminal bore stop valve","No.",1,450,150,{"$f":"(E6+F6)*D6","v":{"v":600,"d":"600.00"}}]
["5.1.1.2","Schedule 40 and 100mm norminal bore alarm valve","No.",1,380,150,{"v":530,"d":"530.00"}]
["5.1.1.3","Booster Connections","No.",2,180,35,{"v":430,"d":"430.00"}]
["5.1.1.4","Schedule 40 and 50mm norminal bore Flushing valve","No.",1,520,150,{"v":670,"d":"670.00"}]
["5.1.1.5","Pressure gauge","No.",2,580,95,{"v":1350,"d":"1,350.00"}]
["5.1.1.6","Schedule 40 and 80mm norminal bore test pipe","m",10,780,150,{"v":9300,"d":"9,300.00"}]
["5.1.1.7","Schedule 40 and 50mm norminal bore  Alarm motor valve","No.",1,430,150,{"v":580,"d":"580.00"}]
["5.1.1.8","Schedule 40 and 50mm norminal bore drain pipe","m",8,570,150,{"v":5760,"d":"5,760.00"}]
["5.1.1.9","Schedule 40 and 80mm norminal bore test valve","m",1,700,150,{"v":850,"d":"850.00"}]
["5.1.1.10","Alarm pressure switch","No.",1,280,95,{"v":375,"d":"375.00"}]
["5.1.1.11","Schedule 40 and 15mm norminal bore  alarm By-Pass valve","No.",1,190,90,{"v":280,"d":"280.00"}]
["5.1.1.12","50mm Alarm strainer","No.",1,380,95,{"v":475,"d":"475.00"}]
["5.1.1.13","Schedule 40 and 50mm norminal bore  union","No.",1,90,21,{"v":111,"d":"111.00"}]
["5.1.1.14","50mm false alarm pump suction isolation valve","No.",1,410,95,{"v":505,"d":"505.00"}]
["5.1.1.15","False alarm pump","No.",1,700,95,{"v":795,"d":"795.00"}]
["5.1.1.16","50mm False alarm pump delivery non return valve","No.",1,760,95,{"v":855,"d":"855.00"}]
["5.1.1.17","50mm False alarm pump delivery stop valve","No.",1,760,95,{"v":855,"d":"855.00"}]
["5.1.1.18","Schedule 40 and 50mm norminal bore Alarm test valve","No.",1,710,150,{"v":860,"d":"860.00"}]
[]
["5.1.2","PIPING AND ACCESSORIES"]
["5.1.2.1","Schedule 40 and 32mm norminal bore pipe","m",45,400,{"v":150,"d":"150.00"},{"$f":"(E26+F26)*D26","v":{"v":24750,"d":"24,750.00"}}]
["5.1.2.2","Schedule 40 and 40mm norminal bore pipe","m",250,380,{"v":150,"d":"150.00"},{"v":132500,"d":"132,500.00"}]
["5.1.2.3","Schedule 40 and 50mm norminal bore pipe","m",6.5,690,{"v":150,"d":"150.00"},{"v":5460,"d":"5,460.00"}]
["5.1.2.4","Schedule 40 and 60mm norminal bore pipe","m",3,730,{"v":150,"d":"150.00"},{"v":2640,"d":"2,640.00"}]
["5.1.2.5","Schedule 40 and 80mm norminal bore pipe","m",3,890,{"v":150,"d":"150.00"},{"v":3120,"d":"3,120.00"}]
["5.1.2.6","Schedule 40 and 100mm norminal bore pipe","m",47,990,{"v":150,"d":"150.00"},{"v":53580,"d":"53,580.00"}]
[]
["TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(G5:G31)","v":{"v":247231,"d":"R 247,231.00"}}]
["TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"G33","v":{"v":247231,"d":"R 247,231.00"}}]
[]
["5.1.3","ELBOWS"]
["5.1.3.1","Schedule 40 and 32mm norminal bore 90 degree elbow","No.",{"v":158,"d":"158 "},{"v":100,"d":"100 "},19,{"$f":"(E37+F37)*D37","v":{"v":18802,"d":"18,802.00"}}]
["5.1.3.2","Schedule 40 and 40mm norminal bore 90 degree elbow","No.",{"v":24,"d":"24 "},{"v":132,"d":"132 "},19,{"$f":"(E38+F38)*D38","v":{"v":3624,"d":"3,624.00"}}]
["5.1.3.3","Schedule 40 and 100mm norminal bore 90 degree elbow","No.",{"v":10,"d":"10 "},{"v":180,"d":"180 "},19,{"$f":"(E39+F39)*D39","v":{"v":1990,"d":"1,990.00"}}]
["5.1.3.4","Schedule 40 and 32mm norminal bore 45 degree elbow","No.",{"v":2,"d":"2 "},{"v":100,"d":"100 "},19,{"$f":"(E40+F40)*D40","v":{"v":238,"d":"238.00"}}]
[]
["5.1.4","TEES"]
["5.1.4.1","Schedule 40 and 100mm x40mm norminal bore connecting tee","No.",8,210,{"v":19,"d":"19.00"},{"$f":"(E43+F43)*D43","v":{"v":1832,"d":"1,832.00"}}]
["5.1.4.2","Schedule 40 and 80mm x40mm norminal bore connecting tee","No.",2,190,{"v":19,"d":"19.00"},{"$f":"(E44+F44)*D44","v":{"v":418,"d":"418.00"}}]
["5.1.4.3","Schedule 40 and 60mm x40mm norminal bore connecting tee","No.",2,189,{"v":19,"d":"19.00"},{"$f":"(E45+F45)*D45","v":{"v":416,"d":"416.00"}}]
["5.1.4.4","Schedule 40 and 50mm x40mm norminal bore connecting tee","No.",4,134,{"v":19,"d":"19.00"},{"$f":"(E46+F46)*D46","v":{"v":612,"d":"612.00"}}]
["5.1.4.5","Schedule 40 and 40mm x32mm norminal bore connecting tee","No.",23,100,{"v":19,"d":"19.00"},{"$f":"(E47+F47)*D47","v":{"v":2737,"d":"2,737.00"}}]
[]
["5.1.5","REDUCERS"]
["5.1.5.1","Schedule 40 and 40 to 32mm norminal bore  concentric reducer","No.",158,117,{"v":19,"d":"19.00"},{"$f":"(E50+F50)*D50","v":{"v":21488,"d":"21,488.00"}}]
["5.1.5.2","Schedule 40 and 50 to 40mm norminal bore  concentric reducer","No.",6,128,{"v":19,"d":"19.00"},{"$f":"(E51+F51)*D51","v":{"v":882,"d":"882.00"}}]
["5.1.5.3","Schedule 40 and 60 to 50mm norminal bore  concentric reducer","No.",2,136,{"v":19,"d":"19.00"},{"$f":"(E52+F52)*D52","v":{"v":310,"d":"310.00"}}]
["5.1.5.4","Schedule 40 and 80 to 60mm norminal bore  concentric reducer","No.",2,147,{"v":19,"d":"19.00"},{"$f":"(E53+F53)*D53","v":{"v":332,"d":"332.00"}}]
["5.1.5.5","Schedule 40 and 100 to 80mm norminal bore  concentric reducer","No.",2,178,{"v":19,"d":"19.00"},{"$f":"(E54+F54)*D54","v":{"v":394,"d":"394.00"}}]
[]
["5.1.6","SPRINKLERS"]
[]
["5.1.6.1","White painted peiling sprinkler heads with white rosettes to a plasterboard ceiling. 362 x 552 outlet melting point 158 ° F type","No.",90,200,{"v":45,"d":"45.00"},{"$f":"(E58+F58)*D58","v":{"v":22050,"d":"22,050.00"}}]
[]
[]
[]
["TOTAL CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(G34:G61)","v":{"v":323356,"d":"R 323,356.00"}}]
["TOTAL CARRIED TO SUMMARY (SPRINKLER FIRE SYSTEM )",{"$nulls":5},{"$f":"G62","v":{"v":323356,"d":"R 323,356.00"}}]
{"$rows_empty":120}
[{"$nulls":9},"Note: Eng/Siboniso to input correct capacity as per specification"]