{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Quote"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Quote","index":0,"n_rows":100,"n_cols":11,"rows_kept":100,"merged":[[8,1,8,6],[10,1,10,6],[97,1,97,2],[98,1,99,7]]}
[null,"Eskom Rotek Industries SOC Ltd"]
[null,"Registration No: 1990/006897/30"]
[null,"Vat NumberP: 4330196330"]
[null," Lower Germiston Road, Rosherville"]
[null,"Johannesburg"]
[null,"PO Box 40698"]
[null,"Cleveland, 2022 SA"]
[]
[null,"SUPPLY AND DELIVER MOBILE SUBSTATION CONTAINER AT TUTUKA POWER STATION"]
[]
[null,"BILL OF QUANTITIES"]
[null,"Item No","Description","Unit","Qty","Rate","Amount","Comments"]
[null,"Bill 1","P&G's"]
[null,1.1,"Supervision and Labour",{"$nulls":6},{"$f":"J96*20%","v":{"$error":"#REF!"}}]
[]
[null,"1.1.1","Supervisor","hrs",{"v":158.8796,"d":"159"}]
[null,"1.1.2","Rigger","hrs",{"v":149.16,"d":"149"},null,null,"1 Rigger "]
[null,"1.1.3","Rigger assistance","hrs",{"v":136.7258,"d":"137"},null,null,"1 Rigger asisstance",null,{"$f":"J96-J14","v":{"$error":"#REF!"}}]
[null,"1.1.4","Driver","hrs",{"v":88.01955,"d":"88"},null,null,"1 Driver"]
[null,"1.1.5","General worker","hrs",{"v":205.7666,"d":"206"},null,null,"10 GW",null,{"$f":"J18*40%","v":{"$error":"#REF!"}}]
[null,"1.1.6","Artisan electric","hrs",{"v":293.8235,"d":"294"},null,null,"1 Artisan"]
[null,"1.1.7","Semi-skilled","hrs",{"v":185.99,"d":"186"},null,null,"2 Semi-Skilled",null,{"$f":"J18-J20","v":{"$error":"#REF!"}}]
[null,"1.1.8","Mechanical Supervisor","hrs",{"v":122.2383,"d":"122"},null,null,"1 Supervisor"]
[null,"1.1.9","Mechanical Engineer (Preng)","hrs",{"v":125.866,"d":"126"},null,null,"1 Mechanical Eng"]
[]
[null,1.2,"Transport"]
[]
[null,"1.2.1","Transport and delivery of 12x3m container to Tutuka Power station","No",{"v":1,"d":"1.00"}]
[]
[null,1.3,"BTU Testing"]
[]
[null,"1.3.1","1X3 Phase surge arrestor","Item",{"v":1,"d":"1.00"}]
[null,"1.3.2","1X3 phase filter unit","Item",{"v":1,"d":"1.00"}]
[null,"1.3.3","FAT test bay booking","Item",{"v":1,"d":"1.00"}]
[null,"1.3.4","BTU Setting up","Item",{"v":1,"d":"1.00"}]
[null,"1.3.5","Document preparation","Item",{"v":1,"d":"1.00"}]
[null,"1.3.6","EMS Lab booking","Item",{"v":1,"d":"1.00"}]
[null,"1.3.7","Test certificate","Item",{"v":1,"d":"1.00"}]
[null,"1.3.8","Manufacturing of steel for BTU radition testing","Item",{"v":1,"d":"1.00"}]
[null,"1.3.9","Transportation of BTU for testing","Item",{"v":1,"d":"1.00"}]
[]
[null,"Bill 2","CABLES"]
[null,2.1,"Supply and install new LV Cables"]
[null,"2.1.1","2.5mm2 x 4core  (BVX04DCV)"]
[null,"a)","Supply","m",{"v":200,"d":"200.00"},null,null,"20% from original contract rate"]
[null,"b)","Install","m",{"v":200,"d":"200.00"},null,null,"20% from original contract rate"]
[null,"2.1.2","2.5mm2 x 7core  (BVX07DCV)"]
[null,"a)","Supply","m",{"v":200,"d":"200.00"},null,null,"20% from original contract rate"]
[null,"b)","Install","m",{"v":200,"d":"200.00"},null,null,"20% from original contract rate"]
[]
[null,2.2,"Terminations of LV Cables including Lables"]
[]
[null,"2.2.1","2.5mm2 x 4core  (BVX04DCV)"]
[null,"a)","Supply","No",{"v":26,"d":"26.00"},null,null,"20% from original contract rate"]
[null,"b)","Install","No",{"v":26,"d":"26.00"},null,null,"20% from original contract rate"]
[null,"2.2.2","2.5mm2 x 7core  (BVX07DCV)"]
[null,"a)","Supply","No",{"v":26,"d":"26.00"},null,null,"20% from original contract rate"]
[null,"b)","Install","No",{"v":26,"d":"26.00"},null,null,"20% from original contract rate"]
[]
[null,"Bill 3","RACKING"]
[null,3.1,"Cold drawn high tensile galvanized wire mesh cable tray (O-L GRIDSPAN GS 50x50) fixed in all positions, to all heights above floor level, brackets, bolts, nuts and washers, etc."]
[null,"3.1.1","300mm x 75mm"]
[null,"a)","Supply","m",{"v":12,"d":"12.00"},null,null,"20% from original contract rate"]
[null,"b)","Install","m",{"v":12,"d":"12.00"},null,null,"20% from original contract rate",null,{"$f":"81000","v":{"v":81000,"d":"R81,000.00"}}]
[]
[null,"Bill 4","MATERIALS"]
[null,4.1,"Mobile Container"]
[null,"4.1.1","12x3m Container"]
[null,"a)","Supply","No",{"v":1,"d":"1.00"}]
[null,"4.1.2","12x3m Iso Walling inside the container"]
[null,"a)","Supply","No",{"v":1,"d":"1.00"},{"$nulls":4},{"v":49950,"d":"R49,950.00"}]
[null,"4.1.3","2 Container doors(small) and cut outs",{"$nulls":6},{"$f":"J71*30%","v":{"v":14985,"d":"R14,985.00"}}]
[null,"a)","Supply","No",{"v":2,"d":"2.00"}]
[null,"4.1.4","2.5mx12mx1.5m Steel for fabrication of frames complete"]
[null,"a)","Supply","ea",{"v":1,"d":"1.00"}]
[null,"4.1.5","500mm Steel for roof extension and container to accommodate the Switchgear"]
[null,"a)","Supply","ea",{"v":1,"d":"1.00"}]
[null,"4.1.6","2 x Aircon circuits , 2 lighting circuits and 1 Plug circuit"]
[null,null,"2 x back up battery 36W florecent lights, 2 x 100W weather proof outside lights"]
[null,null,"4 x 1,5m 36W Floreccent lights , 2 x Plugs, Distrubution box including COC and 2 x  Isolators"]
[null,"a)","Supply","No",{"v":9,"d":"9.00"}]
[null,"4.1.7","Painting of final container RAL-7035 Light grey, including base coats(Black)"]
[null,"a)","Supply","No",{"v":1,"d":"1.00"}]
[null,"4.1.10","12x3m Wood to steel for container floor"]
[null,"a)","Supply","No",{"v":1,"d":"1.00"}]
[null,"4.1.11","2 x 1.5m Galvinised steel steps and landings with guard rails for the small doors"]
[null,"a)","Supply","No",{"v":2,"d":"2.00"}]
[]
[null,4.2,"2 Aircon Units single phase 9000 BTU",{"$nulls":6},{"$f":"#REF!*20%","v":{"$error":"#REF!"}},{"$f":"J89/10","v":{"$error":"#REF!"}}]
[null,"a)","Supply","No",{"v":2,"d":"2.00"}]
[]
[null,4.3,"1x 220V Battery Tripping Unit",{"$nulls":6},{"$f":"81000-J89","v":{"$error":"#REF!"}}]
[null,"a)","Supply","No",{"v":1,"d":"1.00"}]
[]
[null,4.4,"Final testing of the mobile container,stripping for shipping"]
[null,"a)","Testing with detailed report signed by PReng ,stripping for shipping ","No",{"v":1,"d":"1.00"},{"$nulls":4},{"$f":"J92-#REF!","v":{"$error":"#REF!"}}]
[]
[null,"GRAND-TOTAL",{"$nulls":4},{"$f":"G13+G42+G60+G66","v":0},null,{"v":2700697.1797493994,"d":"2,700,697.18"}]
[{"$nulls":8},{"$f":"I98*15%","v":{"v":405104.5769624099,"d":"405,104.58"}}]
[{"$nulls":8},{"$f":"I99+I98","v":{"v":3105801.7567118094,"d":"3,105,801.76"}}]