{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Summary","P & Gs","Sludge Lagoons - Earth Works","Sludge Lagoons - Structur Works","OHS","Sludge Lagoons - Pipeline","Sludge Lagoons - Prov Sums ","Summary (FANIE)","P&G","Mechanical Works","Civil & General SIte  Works","Eskom Power Supply & Electrical"],"not_rendered":{"external_links":6,"defined_names":507},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":36,"n_cols":3,"rows_kept":36,"merged":[[1,0,1,2],[25,0,25,1],[27,0,27,1],[29,0,29,1],[31,0,31,1],[33,0,33,1],[35,0,35,1]]}
[]
["SUMMARY"]
["SECTION","DESCRIPTION","AMOUNT"]
[]
[]
["SECTION 1","PRELIMINARY AND GENERAL"]
[]
[]
["SECTION 2","EARTHWORKS"]
[]
[]
["SECTION 3","CONCRETE WORKS"]
[]
[]
["SECTION 4","PIPELINE WORKS"]
[]
[]
["SECTION 5","PROVISIONAL SUMS"]
{"$rows_empty":7}
["[a] SUB-TOTAL 1 (SECTION 1+2+3+4+5)",null,{"$f":"SUM(C6:C18)","v":0}]
[]
["[b] CONTRACT PRICE ADJUSTMENT (CPA) (5% of [a])",null,{"$f":"C26*0.05","v":0}]
[]
["[c] CONTINGENCIES (5% of [a])",null,{"$f":"C26*0.05","v":0}]
[]
["[d] SUB-TOTAL 2 (a] + [b] + [c])",null,{"$f":"SUM(C26:C30)","v":0}]
[]
[" [e] VAT (15% of [d])",null,{"$f":"C32*15%","v":0}]
[]
["TOTAL CARRIED TO FORM OF OFFER AND ACCEPTANCE ([d] + [e])",null,{"$f":"C32+C34","v":0}]

{"sheet":"P & Gs","index":1,"n_rows":92,"n_cols":17,"rows_kept":92,"merged":[[0,0,0,6],[44,0,44,5],[45,0,45,5],[91,0,91,5]]}
["SECTION 1: PRELIMINARY & GENERAL -SANS 1200A / 1200AB"]
["ITEM\nNo","PAYMENT\nREF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
["1.1",null,"Scheduled Fixed-Time Charge Items"]
["1.1.1",null,"Fixed Preliminary and Genaral charges","Sum",{"v":1,"d":"1.00"}]
[null,"  SANS1200A"]
["1.1.2",null,"Establishing Facilities for Engineer","Sum",{"v":1,"d":"1.00"}]
["1.1.3","  SANS 1200A","Establishing Facilities for Contractor ","Sum",{"v":1,"d":"1.00"}]
["1.1.4",null,"Removal of Site Establishment","Sum",{"v":1,"d":"1.00"}]
["1.1.6",null,"The preparation of risk assessments, safe work procedures, and plan. Provision of Personal Protection Equipment and Clothing and any other health and safety matters according to the Project specifications","Sum",{"v":1,"d":"1.00"}]
["1.1.7",null,"Compliance with Environmental Management Plan ","Sum",{"v":1,"d":"1.00"}]
["1.2",null,"Scheduled Value -Related Charge Items"]
["1.2.1",null,"Value Preliminary and Genaral charges","Sum",{"v":1,"d":"1.00"}]
["1.3",null,"Scheduled Time Raleted Items"]
["1.3.1",null,"Time related preliminary and general","Month",{"v":12,"d":"12.00"}]
[null,"SANS 1200A"]
[null,null,"Operation and Maintenance of Facilities for Engineer","Month",{"v":12,"d":"12.00"}]
[null,"SANS 1200A      "]
["1.3.2",null,"Operation and Maintenance of Facilities for Contractor","Month",{"v":12,"d":"12.00"}]
["1.3.3",null,"Supervision for The Duration of Construction","Month",{"v":12,"d":"12.00"}]
["1.3.4",null,"Company and Head office Overhead for Duration of Construction","Month",{"v":12,"d":"12.00"}]
["1.3.5",null,"Supervision and Training of Nominated Sub-contractors","Month",{"v":12,"d":"12.00"}]
["1.3.6",null,"Salary for Labour Desk office","Prov Sum",{"v":1,"d":"1.00"},{"v":100000,"d":"R100,000.00"},{"$f":"F23*E23","v":{"v":100000,"d":"R100,000.00"}}]
["1.3.7",null,"Artisans and Skills accredited Training","Month",{"v":12,"d":"12.00"},{"$nulls":8},"V.O. 1",{"$f":"#REF!","v":{"$error":"#REF!"}},"Biznet",{"v":1000000,"d":"R1,000,000.00"}]
["1.3.8",null,"Plant, tools and Equipment ","Month",{"v":12,"d":"12.00"},{"$nulls":8},"V.O. 2",{"$f":"#REF!","v":{"$error":"#REF!"}},"Aubrey",{"v":300000,"d":"R300,000.00"}]
["1.3.9",null,"Full Compliance with all Health and Safety specifications","Month",{"v":12,"d":"12.00"},{"$nulls":8},"V.O. 3",{"$f":"#REF!","v":{"$error":"#REF!"}},"Aubrey",{"v":300000,"d":"R300,000.00"}]
["1.4",null,"Sums Stated Provisionally by Engineer",{"$nulls":11},{"$f":"SUM(O24:O26)","v":{"$error":"#REF!"}},null,{"$f":"SUM(Q24:Q26)","v":{"v":1600000,"d":"R1,600,000.00"}}]
["1.3.1",null,"Cellular communications and data bundles","Prov Sum",{"v":1,"d":"1.00"},{"v":24000,"d":"R24,000.00"},{"$f":"E28*F28","v":{"v":24000,"d":"R24,000.00"}}]
["1.3.2",null,"Supply of computer, printer and associated equipment to become property of the Engineer at the end of the Contract","Prov Sum",{"v":1,"d":"1.00"},{"v":30000,"d":"R30,000.00"},{"$f":"E29*F29","v":{"v":30000,"d":"R30,000.00"}}]
["1.3.3",null,"Relocation of Existing Services (inclusive all Discussions, Liaison, Labour and Material)","Prov Sum",{"v":1,"d":"1.00"},{"v":30000,"d":"R30,000.00"},{"$f":"F30*E30","v":{"v":30000,"d":"R30,000.00"}}]
["1.3.6",null,"Percentage (%) mark-up on item 1.3.1 to 1.3.3 above for Contractor's overheads, administration charges and profit","%",null,{"$f":"SUM(F28:F30)","v":{"v":84000,"d":"R84,000.00"}},{"$f":"F31*E31/100","v":0}]
["1.5",null,"Prime Cost Sums"]
["1.5.1",null,"Community Liaison Officers (CLO)","PC Sum",{"v":1,"d":"1.00"},{"v":180000,"d":"R180,000.00"},{"$f":"F33*E33","v":{"v":180000,"d":"R180,000.00"}}]
["1.5.2",null,"Construction Specialist Services","PC Sum",{"v":1,"d":"1.00"},{"v":1000000,"d":"R1,000,000.00"},{"$f":"F34*E34","v":{"v":1000000,"d":"R1,000,000.00"}}]
["1.5.3",null,"Percentage (%) mark-up on item 1.4.1 to 1.4.3 above for Contractor's overheads, administration charges and profit","%",null,{"$f":"SUM(F33:F34)","v":{"v":1180000,"d":"R1,180,000.00"}},{"$f":"F35*E35/100","v":0}]
{"$rows_empty":9}
["Carried Forward"]
[" Brought Forward"]
[]
["1.7",null,"(a) Day Works Using The Contractor's Labour force"]
["1.7.1",null,"1.  Labourer","hour",{"v":100,"d":"100.00"}]
["1.7.2",null,"2.  Driver","hour",{"v":100,"d":"100.00"}]
["1.7.3",null,"3.  Operator","hour",{"v":100,"d":"100.00"}]
["1.7.4",null,"4.  Artisan","hour",{"v":100,"d":"100.00"}]
["1.7.5",null,"5.  Welder","hour",{"v":100,"d":"100.00"}]
["1.7.6",null,"6.  Foreman","hour",{"v":100,"d":"100.00"}]
["1.7.7",null,"7.  Security Guard","day",{"v":100,"d":"100.00"}]
["1.7.8",null,"Medicals entry & Exit ","SUM",{"v":1,"d":"1.00"}]
["1.7.9",null,"PPE","SUM",{"v":1,"d":"1.00"}]
["1.7.10",null,"Training ","SUM",{"v":1,"d":"1.00"}]
[]
["1.8",null,"(b)  Day Works Using Contractor's Plant"]
["1.8.1",null,"1.  Ldv (1 ton)","hour",{"v":40,"d":"40.00"}]
["1.8.2",null,"2.  Flat Truck (3 to 5 ton)","hour",{"v":40,"d":"40.00"}]
["1.8.3",null,"3.  Tip Truck (10m3)","hour",{"v":40,"d":"40.00"}]
["1.8.4",null,"4. Backhoe ","hour",{"v":40,"d":"40.00"}]
["1.8.5",null,"4. Backhoe ","hour",{"v":40,"d":"40.00"}]
["1.8.6",null,"5.  Trench Vibrating Roller","hour",{"v":40,"d":"40.00"}]
["1.8.7",null,"7.  Air compressor, including all tools (Drills, Jackhammers, etc)","hour",{"v":40,"d":"40.00"}]
["1.8.8",null,"8.  Pump, including all Necessary Hosing and Pipes","hour",{"v":40,"d":"40.00"}]
["1.8.9",null,"9.  Concrete Mixer","hour",{"v":40,"d":"40.00"}]
["1.8.10",null,"10.  Water Truck (10 000 L)","hour",{"v":40,"d":"40.00"}]
["1.8.11",null,"11. Welding Machine","hour",{"v":40,"d":"40.00"}]
["1.8.12",null,"12. Flood Lights","hour",{"v":40,"d":"40.00"}]
["1.8.13",null,"13. Staff Bus","hour",{"v":40,"d":"40.00"}]
{"$rows_empty":18}
["Total Section 1 Carried to Summary"]

{"sheet":"Sludge Lagoons - Earth Works","index":2,"n_rows":56,"n_cols":7,"rows_kept":56,"merged":[[0,0,0,6],[1,0,1,6],[55,0,55,5]]}
["SECTION 2: EARTHWORKS"]
[]
["ITEM\nNo","PAYMENT\nREF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[2.1,null,"Site Clearance"]
["2.1.1",null,"Clearing and Grubbing","ha",{"v":1,"d":"1.00"}]
["2.1.2",null,"Removal and grubbing of large tress and stumps"]
["2.1.2.1",null,"Girth not exceeding 1 m ","No",{"v":35,"d":"35.00"}]
["2.1.2.2",null,"Girth exceeding 1 m up to and including 1 m","No",{"v":3,"d":"3.00"}]
["2.1.3",null,"Clearing and Shaping Banks and Dykes","m3",{"v":50,"d":"50.00"}]
["2.1.4",null,"Clearing and shaping existing open drains","m3",{"v":20,"d":"20.00"}]
[]
["2.2.",null,"Mass Earthworks"]
[null,null,"Excavate, borrow, backfill, compact and Dispose of Surplus Material ; "]
["2.2.1",null,"Cut and borrow to fill, including free-haul  up to 0.5km"]
["2.2.1.1",null,"Material in compacted layer thicknesses of 200mm and less :"]
[null,null,"a) Compacted to 90% of modified AASHTO density","m3",{"v":3000,"d":"3,000.00"}]
[null,null,"b) Eight-roller passes compaction","m3",{"v":3000,"d":"3,000.00"}]
[null,null,"c) Rock Fill","m3",{"v":100,"d":"100.00"}]
["2.2.2",null,"Extra over item 2.2.1 for Cut and borrow to fill, including free-haul  up to 0.5km:"]
[null,null,"a) Intermediate excavation","m3",{"v":500,"d":"500.00"}]
[null,null,"b) Hard excavation","m3",{"v":100,"d":"100.00"}]
["2.2.3",null,"Cut to spoil, including free-haul up to 0.5km."]
[null,null,"a) Soft excavation","m3",{"v":2000,"d":"2,000.00"}]
[null,null,"b) Intermediate excavation","m3",{"v":1000,"d":"1,000.00"}]
[null,null,"b) Hard excavation","m3",{"v":100,"d":"100.00"}]
["2.2.4",null,"Roadbed preparation and compaction of material:"]
[null,null,"a) Compacted to 90% of modified AASHTO density","m3",{"v":350,"d":"350.00"}]
["2.2.5",null,"In situ treatment of roadbed"]
[null,null,"a) In situ treatment by ripping","m3",{"v":180,"d":"180.00"}]
[null,null,"b) In situ treatment by blasting","m3",{"v":50,"d":"50.00"}]
["2.2.6",null,"Interchange areas"]
[null,null,"a) Cut Slopes","m3",{"v":1500,"d":"1,500.00"}]
[null,null,"b) Fill Slopes","m3",{"v":1500,"d":"1,500.00"}]
[]
["2.2.7",null,"Overhaul on material hauled in excess of a free-haul distance of 0,5 km, for haul up to \tor through 1,0 km (restricted overhaul)\t\t","m3",{"v":2000,"d":"2,000.00"}]
["2.2.8",null,"Overhaul on material hauled in excess of 1,0 km (ordinary overhaul)\t\t","m³-km",{"v":4000,"d":"4,000.00"}]
[]
[2.3,null,"Pavement layers of gravel material"]
["2.3.1",null,"Pavement layers constructed from gravel taken from cut or borrow, including free-haul up to 1,0 km:\t\t"]
[null,null,"a) Gravel selected layer compacted to 93% modified AASHTO density for compacted layer thickenss of 150mm","m3",{"v":1000,"d":"1,000.00"}]
["2.3.2",null,"HDPE Geomembrane for lining sludge lagoons"]
[null,null,"a) 0.5mm thick HDPE Geomembrane","m²",{"v":9000,"d":"9,000.00"}]
[]
[2.4,null,"Gabions"]
["2.4.1",null,"Foundation trench excavation and backfilling:"]
[null,null,"a) In all other classes material","m3",{"v":100,"d":"100.00"}]
["2.4.2",null,"Surface preparation for bedding the gabions","m3",{"v":120,"d":"120.00"}]
["2.4.3",null,"Galvanised Gabions"]
[null,null,"a) Galvanized gabion boxes, 1,0 m x 1,0 m x 2,0 m with 80 mm x 100 mm mesh and 2,7 dia mesh wire\t","m3",{"v":10,"d":"10.00"}]
[null,null,"b) Galvanized gabion mattresses, 0,3 m deep with 80 mm x 100 mm mesh and diaphragms at 1,0 centres and 2,7 dia mesh wire","m3",{"v":15,"d":"15.00"}]
[null,null,"c) Backfilling behind gabion erosion protection walls, including all haul","m3",{"v":30,"d":"30.00"}]
["2.4.4",null,"Filter Fabric"]
[null,null,"a) Filter fabric, Kaymat U24 or approved ","m²",{"v":100,"d":"100.00"}]
[]
[]
["SECTION 2 : CARRIED TO SUMMARY :  EARTHWORKS "]

{"sheet":"Sludge Lagoons - Structur Works","index":3,"n_rows":61,"n_cols":7,"rows_kept":61,"merged":[[0,0,0,6],[1,0,1,6],[60,0,60,5]]}
["SECTION 3: STRUCTURAL WORKS"]
[]
["ITEM\nNo","PAYMENT\nREF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[3.1,null,"Foundation for Structures (Concrete Channel)"]
["3.1.1",null,"Excavating soft material situated within the following successive depth ranges"]
[null,null,"a) 0 m up to 2 m ","m3",{"v":350,"d":"350.00"}]
[null,null,"b) Exceeding 2 m and up to 4 m","m3",{"v":2,"d":"2.00"}]
[null,null,"c) Extra over sub-items a) & b) above for excavation in hard material irrespective of depth ","m3",{"v":5,"d":"5.00"}]
[null,null,"d) Extra over sub-items a) & b) above for excavation by hand","m3",{"v":10,"d":"10.00"}]
["3.1.2",null,"Access and Drainage"]
[null,null,"a) Access","Prov Sum",{"v":1,"d":"1.00"},{"v":30000,"d":"R30,000.00"},{"$f":"F11*E11","v":{"v":30000,"d":"R30,000.00"}}]
["3.1.3",null,"Backfill to excavations utilising "]
[null,null,"a) Material from the excavation","m3",{"v":30,"d":"30.00"}]
[null,null,"b) Imported material","m3",{"v":5,"d":"5.00"}]
["3.1.4",null,"Fill within restricted area (Extra over item 3.1.3)","m3",{"v":5,"d":"5.00"}]
["3.1.5",null," Overhaul in excess of 1,0 km on 'excavated material and  on material imported for backfill, foundation fill and  fill for caissons \t\t","m³.km",{"v":300,"d":"300.00"}]
["3.1.6",null,"Foundation fill and under channel consisting of:"]
[null,null,"a) Compacted granular material","m3",{"v":60,"d":"60.00"}]
[null,null,"b) Mass concrete (class 15/19)","m3",{"v":10,"d":"10.00"}]
[]
[3.2,null,"Falsework, Formwork and Concrete Finish"]
["3.2.1",null,"Vertical formwork to provide:"]
[null,null,"a) Class F1 surface finish to Channel Floor","     m²",{"v":130,"d":"130.00"}]
["3.2.2",null,"Sloping formwork to provide:"]
[null,null,"a) Class F1 surface finish to Spillways and Channels","     m²",{"v":200,"d":"200.00"}]
[null,null,"b) Class F1 surface finish to Lagoons","     m²",{"v":350,"d":"350.00"}]
["3.2.3",null,"Horizontal formwork to provide:"]
[null,null,"a) Class F1 surface finish to bottom of Channel ","     m²",{"v":60,"d":"60.00"}]
[null,null,"b) Class F1 surface finish to top of channel walls","     m²",{"v":25,"d":"25.00"}]
[null,null,"c) Class F1 surface finish to ramps","     m²",{"v":20,"d":"20.00"}]
[null,null,"d) Class F1 surface finish to lagoon","     m²",{"v":100,"d":"100.00"}]
[]
[3.3,null,"Steel, Reinforcement for Structures"]
["3.3.1",null,"Steel Reinforcement for Spillways and channels, access ramps and manholes"]
[null,null,"a) Welded steel fabric mesh (Ref 617)","     m²",{"v":8500,"d":"8,500.00"}]
[null,null,"b) Welded steel fabric mesh (Ref 395)","     m²",{"v":500,"d":"500.00"}]
[]
[3.4,null,"Concrete for Structures"]
["3.4.1",null,"Cast in Situ Concrete Class 25/19 "]
[null,null,"a) Concrete channel","m3",30]
[null,null,"b) Concrete ramp","m3",10]
[null,null,"c) Decanting Structure","m3",2]
[null,null,"d) Overflow Structures","m3",8]
[null,null,"e) Lagoon","m3",{"v":1200,"d":"1,200.00"}]
[]
["3.4.2",null,"Concrete Testing","Prov Sum",{"v":1,"d":"1.00"},{"v":35000,"d":"R35,000.00"},{"$f":"F46*E46","v":{"v":35000,"d":"R35,000.00"}}]
["3.4.3",null,"Contractors markup on item 3.4.2 above","%",{"v":35000,"d":"35,000.00"},null,{"$f":"F47*E47","v":0}]
["3.4.4",null,"Expansion Joints and Approved Sealents","Prov Sum",{"v":1,"d":"1.00"},{"v":85000,"d":"R85,000.00"},{"$f":"F48*E48","v":{"v":85000,"d":"R85,000.00"}}]
["3.4.5",null,"Contractors markup on item 3.4.4 above","%",{"v":85000,"d":"85,000.00"},null,{"$f":"F49*E49","v":0}]
[]
[3.5,null,"Unformed Surface Finish"]
[null,null,"a) Steel floated finish to Floor and Walls","     m²",600]
[]
[3.6,null,"Sluice and Gate Valves"]
[null,null,"a) 1000mm wide x 850mmm deep opening, Adjustable overflow Weir with 300mm Travel","Prov sum",1,{"v":240000,"d":"R240,000.00"},{"$f":"F55*E55","v":{"v":240000,"d":"R240,000.00"}}]
[null,null,"b) 700mm high Penstock in 600 mm x 600mmm deep channel, including frame, 3CR12 Stainless Steel, PN10. ","Prov sum",1,{"v":850000,"d":"R850,000.00"},{"$f":"F56*E56","v":{"v":850000,"d":"R850,000.00"}}]
[]
[3.7,null,"Handrail & Grating"]
[null,null,"a) 3CR12 handrail assembly complete with 100mm high kicker plates and GRP Grating over channels","Prov sum",1,{"v":650000,"d":"R650,000.00"},{"$f":"F59*E59","v":{"v":650000,"d":"R650,000.00"}}]
[]
["SECTION 3 : CARRIED TO SUMMARY :  STRUCTURAL WORKS "]

{"sheet":"OHS","index":4,"n_rows":145,"n_cols":15,"rows_kept":145,"hidden":true,"merged":[[0,0,0,6],[0,7,0,9],[0,10,0,12],[140,0,140,5]]}
["OHS",{"$nulls":6},"UNITS",null,null,"AMOUNTS"]
["ITEM\nNo","PAYMENT\nREF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT","PREVIOUS","CURRENT","TOTAL","PREVIOUS","CURRENT","TOTAL"]
[null,"SANS 1200A","SECTION 8: OHS COMPLIANCE "]
[1.1,8.3,"FIXED CHARGE ITEMS"]
["1.1.1","CR 7(1) (a). H&S Spec  (10)","'Project specific SHE plan based on the H&S specification.","Sum",{"v":1,"d":"1.00"},{"v":15000,"d":"R15,000.00"},{"$f":"F5*E5","v":{"v":15000,"d":"R15,000.00"}},{"v":1,"d":"1.00"},{"$f":"J5-H5","v":0},{"v":1,"d":"1.00"},{"$f":"H5*F5","v":{"v":15000,"d":"R15,000.00"}},{"$f":"I5*F5","v":0},{"$f":"J5*F5","v":{"v":15000,"d":"R15,000.00"}}]
["1.1.1.1","COIDA. H&S Spec (7)","Workmen's compensation letter.","Sum",{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},{"$f":"F6*E6","v":{"v":10000,"d":"R10,000.00"}},{"v":1,"d":"1.00"},{"$f":"J6-H6","v":0},{"v":1,"d":"1.00"},{"$f":"H6*F6","v":{"v":10000,"d":"R10,000.00"}},{"$f":"I6*F6","v":0},{"$f":"J6*F6","v":{"v":10000,"d":"R10,000.00"}}]
["1.1.1.2","CR 4. H&S Spec (b)","Notification of construction work","Sum",{"v":1,"d":"1.00"},{"v":15000,"d":"R15,000.00"},{"v":15000,"d":"R15,000.00"},{"v":1,"d":"1.00"},{"$f":"J7-H7","v":0},{"v":1,"d":"1.00"},{"$f":"H7*F7","v":{"v":15000,"d":"R15,000.00"}},{"$f":"I7*F7","v":0},{"$f":"J7*F7","v":{"v":15000,"d":"R15,000.00"}}]
[4,null,"Site Establishment",{"$nulls":3},0,0,0,0,0,0,0]
[4.1,null,"Fencing to the construction site ( 1.8m high)","Sum",{"v":1,"d":"1.00"},{"v":35000,"d":"R35,000.00"},{"v":35000,"d":"R35,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":35000,"d":"R35,000.00"},0,{"v":35000,"d":"R35,000.00"}]
[4.2,null,"Hoarding with a green net (1.8m high)","Sum",{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},{"v":10000,"d":"R10,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},0,{"v":10000,"d":"R10,000.00"}]
[4.3,null,"Site Clearance and waste disposal","Sum",{"v":1,"d":"1.00"},{"v":15000,"d":"R15,000.00"},{"v":15000,"d":"R15,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":15000,"d":"R15,000.00"},0,{"v":15000,"d":"R15,000.00"}]
[4.4,"GSR 3(2). H&S Spec (z)","First aid boxes","No",{"v":5,"d":"5.00"},{"v":5000,"d":"R5,000.00"},{"v":25000,"d":"R25,000.00"},{"v":5,"d":"5.00"},0,{"v":5,"d":"5.00"},{"v":25000,"d":"R25,000.00"},0,{"v":25000,"d":"R25,000.00"}]
[4.5,"GSR 4. BRA 15, 35. CR 29","Fire Extinguishers ( 7x9kgs and 3x5kgs)","No",{"v":5,"d":"5.00"},{"v":2000,"d":"R2,000.00"},{"v":10000,"d":"R10,000.00"},{"v":5,"d":"5.00"},0,{"v":5,"d":"5.00"},{"v":10000,"d":"R10,000.00"},0,{"v":10000,"d":"R10,000.00"}]
[4.6,"CR 30.BRA 2.H&S SPEC (u)","Toilets ( 1 per 15 people, each toilet per gender)","No",{"v":2,"d":"2.00"},{"v":40000,"d":"R40,000.00"},{"v":80000,"d":"R80,000.00"},{"v":2,"d":"2.00"},0,{"v":2,"d":"2.00"},{"v":80000,"d":"R80,000.00"},0,{"v":80000,"d":"R80,000.00"}]
[4.7,"CR27","Waste bins ( Plastic overlapping waste bins 100L)","No",{"v":4,"d":"4.00"},{"v":1500,"d":"R1,500.00"},{"v":6000,"d":"R6,000.00"},{"v":4,"d":"4.00"},0,{"v":4,"d":"4.00"},{"v":6000,"d":"R6,000.00"},0,{"v":6000,"d":"R6,000.00"}]
[4.8,"CR30","Shadding net for an eating area ( Green net 5m long)","No",{"v":3,"d":"3.00"},{"v":15000,"d":"R15,000.00"},{"v":45000,"d":"R45,000.00"},{"v":3,"d":"3.00"},0,{"v":3,"d":"3.00"},{"v":45000,"d":"R45,000.00"},0,{"v":45000,"d":"R45,000.00"}]
[null,"CR30","Benches for an eating area ( 4m long)","No",{"v":5,"d":"5.00"},0,"included ",{"v":5,"d":"5.00"},0,{"v":5,"d":"5.00"},0,0,0]
[4.2,"H&S SPEC (g). CR 7(6). GSR 2","Personal Protective Equipment",{"$nulls":3},{"$f":"F18*E18","v":0},0,0,0,0,0,0]
["4.2.1",null,"Overalls( Blue/Orange/Green)","No ",{"v":120,"d":"120.00"},{"v":500,"d":"R500.00"},{"$f":"F19*E19","v":{"v":60000,"d":"R60,000.00"}},{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},{"v":45000,"d":"R45,000.00"},0,{"v":45000,"d":"R45,000.00"}]
["4.2.2",null,"Hard hats","No ",{"v":120,"d":"120.00"},{"v":150,"d":"R150.00"},{"v":18000,"d":"R18,000.00"},{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},{"v":13500,"d":"R13,500.00"},0,{"v":13500,"d":"R13,500.00"}]
["4.2.3",null,"Boots",{"$nulls":3},0,{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},0,0,0]
["4.2.3.1",null,"water boots","No",{"v":120,"d":"120.00"},{"v":250,"d":"R250.00"},{"v":30000,"d":"R30,000.00"},{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},{"v":22500,"d":"R22,500.00"},0,{"v":22500,"d":"R22,500.00"}]
["4.2.3.2",null,"Safety boots","No",{"v":120,"d":"120.00"},{"v":325,"d":"R325.00"},{"v":39000,"d":"R39,000.00"},{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},{"v":29250,"d":"R29,250.00"},0,{"v":29250,"d":"R29,250.00"}]
["4.2.4",null,"Gloves ( General and Skilled activities)","No",{"v":120,"d":"120.00"},{"v":250,"d":"R250.00"},{"v":30000,"d":"R30,000.00"},{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},{"v":22500,"d":"R22,500.00"},0,{"v":22500,"d":"R22,500.00"}]
["4.2.5",null,"Googles","No",{"v":120,"d":"120.00"},{"v":50,"d":"R50.00"},{"v":6000,"d":"R6,000.00"},{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},{"v":4500,"d":"R4,500.00"},0,{"v":4500,"d":"R4,500.00"}]
["4.2.6",null,"Earplugs","No",{"v":500,"d":"500.00"},{"v":20,"d":"R20.00"},{"v":10000,"d":"R10,000.00"},{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},{"v":1800,"d":"R1,800.00"},0,{"v":1800,"d":"R1,800.00"}]
["4.2.7",null,"Reflector vests","No",{"v":120,"d":"120.00"},{"v":100,"d":"R100.00"},{"v":12000,"d":"R12,000.00"},{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},{"v":9000,"d":"R9,000.00"},0,{"v":9000,"d":"R9,000.00"}]
["4.2.8",null,"Sun-block hats","No",{"v":120,"d":"120.00"},{"v":150,"d":"R150.00"},{"v":18000,"d":"R18,000.00"},{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},{"v":13500,"d":"R13,500.00"},0,{"v":13500,"d":"R13,500.00"}]
["4.2.9",null,"Dust mask","No",{"v":500,"d":"500.00"},{"v":20,"d":"R20.00"},{"v":10000,"d":"R10,000.00"},{"v":90,"d":"90.00"},0,{"v":90,"d":"90.00"},{"v":1800,"d":"R1,800.00"},0,{"v":1800,"d":"R1,800.00"}]
[4.3," H&S SPEC (9),(ii). CR 23(K)","Inductions, Toolbox talks, Checklists, Registers and Risk asessments",{"$nulls":3},0,0,0,0,0,0,0]
["4.3.1",null,"Stationary","Sum",{"v":1,"d":"1.00"},{"v":4000,"d":"R4,000.00"},{"v":4000,"d":"R4,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":4000,"d":"R4,000.00"},0,{"v":4000,"d":"R4,000.00"}]
["4.3.2",null,"Printer"," Sum",{"v":1,"d":"1.00"},{"v":5000,"d":"R5,000.00"},{"v":5000,"d":"R5,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":5000,"d":"R5,000.00"},0,{"v":5000,"d":"R5,000.00"}]
["4.3.3",null,"Laptop","Sum",{"v":1,"d":"1.00"},{"v":15000,"d":"R15,000.00"},{"v":15000,"d":"R15,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":15000,"d":"R15,000.00"},0,{"v":15000,"d":"R15,000.00"}]
[4.4,"CR 7(g). H&S SPEC (16)","Medical Fitness examinations","Sum",{"v":1,"d":"1.00"},{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":50000,"d":"R50,000.00"},0,{"v":50000,"d":"R50,000.00"}]
[4.5,"H&S SPEC (17).BRA (10).GSR(2B)","Signage and boards",{"$nulls":3},0,0,0,0,0,0,0]
["4.5.1",null,"Construction Safety Board","No",{"v":5,"d":"5.00"},{"v":1500,"d":"R1,500.00"},{"v":7500,"d":"R7,500.00"},{"v":5,"d":"5.00"},0,{"v":5,"d":"5.00"},{"v":7500,"d":"R7,500.00"},0,{"v":7500,"d":"R7,500.00"}]
["4.5.2",null,"First aid Box","No",{"v":5,"d":"5.00"},{"v":1500,"d":"R1,500.00"},{"v":7500,"d":"R7,500.00"},{"v":5,"d":"5.00"},0,{"v":5,"d":"5.00"},{"v":7500,"d":"R7,500.00"},0,{"v":7500,"d":"R7,500.00"}]
["4.5.3",null,"Fire extinguisher","No",{"v":12,"d":"12.00"},{"v":1500,"d":"R1,500.00"},{"v":18000,"d":"R18,000.00"},{"v":12,"d":"12.00"},0,{"v":12,"d":"12.00"},{"v":18000,"d":"R18,000.00"},0,{"v":18000,"d":"R18,000.00"}]
["4.5.4",null,"Assembly Point","No",{"v":4,"d":"4.00"},{"v":1500,"d":"R1,500.00"},{"v":6000,"d":"R6,000.00"},{"v":2,"d":"2.00"},0,{"v":2,"d":"2.00"},{"v":3000,"d":"R3,000.00"},0,{"v":3000,"d":"R3,000.00"}]
["4.5.5",null,"Excavation","No",{"v":12,"d":"12.00"},{"v":1500,"d":"R1,500.00"},{"v":18000,"d":"R18,000.00"},{"v":10,"d":"10.00"},0,{"v":10,"d":"10.00"},{"v":15000,"d":"R15,000.00"},0,{"v":15000,"d":"R15,000.00"}]
["4.5.6",null,"Plant and Construction vehicle","No",{"v":10,"d":"10.00"},{"v":1500,"d":"R1,500.00"},{"v":15000,"d":"R15,000.00"},0,0,0,0,0,0]
["4.5.7",null,"Chemicals, Gas and Liquids Flammables","No",{"v":10,"d":"10.00"},{"v":1500,"d":"R1,500.00"},{"v":15000,"d":"R15,000.00"},{"v":10,"d":"10.00"},0,{"v":10,"d":"10.00"},{"v":15000,"d":"R15,000.00"},0,{"v":15000,"d":"R15,000.00"}]
["4.5.8",null,"Toilets information signs ( male and female)","No",{"v":8,"d":"8.00"},{"v":1500,"d":"R1,500.00"},{"v":12000,"d":"R12,000.00"},{"v":4,"d":"4.00"},0,{"v":4,"d":"4.00"},{"v":6000,"d":"R6,000.00"},0,{"v":6000,"d":"R6,000.00"}]
["4.5.9",null,"Eating area information Sign","No",{"v":5,"d":"5.00"},{"v":1500,"d":"R1,500.00"},{"v":7500,"d":"R7,500.00"},{"v":5,"d":"5.00"},0,{"v":5,"d":"5.00"},{"v":7500,"d":"R7,500.00"},0,{"v":7500,"d":"R7,500.00"}]
["4.5.10",null,"Blasting","No",{"v":5,"d":"5.00"},{"v":1500,"d":"R1,500.00"},{"v":7500,"d":"R7,500.00"},0,0,0,0,0,0]
["4.5.11",null,"Escape routes/ evacuation","No",{"v":6,"d":"6.00"},{"v":1500,"d":"R1,500.00"},{"v":9000,"d":"R9,000.00"},{"v":3,"d":"3.00"},0,{"v":3,"d":"3.00"},{"v":4500,"d":"R4,500.00"},0,{"v":4500,"d":"R4,500.00"}]
["4.5.12",null,"Scaffold safe/unsafe use","No",{"v":6,"d":"6.00"},{"v":1500,"d":"R1,500.00"},{"v":9000,"d":"R9,000.00"},{"v":4,"d":"4.00"},0,{"v":4,"d":"4.00"},{"v":6000,"d":"R6,000.00"},0,{"v":6000,"d":"R6,000.00"}]
["4.5.13",null,"Access control","No",{"v":4,"d":"4.00"},{"v":1500,"d":"R1,500.00"},{"v":6000,"d":"R6,000.00"},{"v":4,"d":"4.00"},0,{"v":4,"d":"4.00"},{"v":6000,"d":"R6,000.00"},0,{"v":6000,"d":"R6,000.00"}]
["4.5.14",null,"No smoking","No",{"v":5,"d":"5.00"},{"v":1500,"d":"R1,500.00"},{"v":7500,"d":"R7,500.00"},{"v":5,"d":"5.00"},0,{"v":5,"d":"5.00"},{"v":7500,"d":"R7,500.00"},0,{"v":7500,"d":"R7,500.00"}]
[4.6,null,"Storage Container","No",{"v":3,"d":"3.00"},{"v":1500,"d":"R1,500.00"},{"v":4500,"d":"R4,500.00"},{"v":3,"d":"3.00"},0,{"v":3,"d":"3.00"},{"v":4500,"d":"R4,500.00"},0,{"v":4500,"d":"R4,500.00"},null,{"$f":"N50/2","v":0}]
[4.7,null,"Boundry wall ( Hazadours chemicals, liquids and cement mixing area)","No",{"v":4,"d":"4.00"},{"v":1500,"d":"R1,500.00"},{"v":6000,"d":"R6,000.00"},0,0,0,0,0,0,null,{"$f":"N51/G51","v":0}]
[4.8,null,"Site Offices","No",{"v":2,"d":"2.00"},{"v":1500,"d":"R1,500.00"},{"v":3000,"d":"R3,000.00"},0,0,0,0,0,0]
[5,"BRA (1).H&S SPEC (8)","Training and awareness",{"$nulls":3},0,0,0,0,0,0,0]
[5.1,null,"SHE rep Training","Sum",{"v":2,"d":"2.00"},{"v":15000,"d":"R15,000.00"},{"v":30000,"d":"R30,000.00"},0,0,0,0,0,0]
[5.2,null,"First aid level 1,2,3","Sum",{"v":2,"d":"2.00"},{"v":15000,"d":"R15,000.00"},{"v":30000,"d":"R30,000.00"},0,0,0,0,0,0]
[5.3,null,"Scaffolding Supervisor","Sum",{"v":2,"d":"2.00"},{"v":15000,"d":"R15,000.00"},{"v":30000,"d":"R30,000.00"},0,0,0,0,0,0]
[5.4,null,"Working at heights","Sum",{"v":3,"d":"3.00"},{"v":15000,"d":"R15,000.00"},{"v":45000,"d":"R45,000.00"},0,0,0,0,0,0]
[5.5,null,"Risk assessment analyses","Sum",{"v":1,"d":"1.00"},{"v":15000,"d":"R15,000.00"},{"v":15000,"d":"R15,000.00"},0,0,0,0,0,0]
[5.6,null,"Environmental awareness campaign","Sum",{"v":2,"d":"2.00"},{"v":25000,"d":"R25,000.00"},{"v":50000,"d":"R50,000.00"},0,0,0,0,0,0]
[5.7,null,"HIV/AIDS awareness and accomodation needs, posters and distribution of condoms. X90 employees","Sum",{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},{"v":10000,"d":"R10,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},0,{"v":10000,"d":"R10,000.00"}]
[6,"H&S SPEC (i)","Appointments with remunirations",{"$nulls":3},0,0,0,0,0,0,0]
[6.1,"CR8(5)","Registered construction health and safety officer","Months",{"v":12,"d":"12.00"},{"v":16500,"d":"R16,500.00"},{"v":198000,"d":"R198,000.00"},{"v":4,"d":"4.00"},{"v":1,"d":"1.00"},{"v":5,"d":"5.00"},{"v":66000,"d":"R66,000.00"},{"v":16500,"d":"R16,500.00"},{"v":82500,"d":"R82,500.00"}]
[6.2,"OHSA(17)","Competent SHE rep with a SHE certificate","Months",{"v":12,"d":"12.00"},{"v":12500,"d":"R12,500.00"},{"v":150000,"d":"R150,000.00"},{"v":4,"d":"4.00"},{"v":1,"d":"1.00"},{"v":5,"d":"5.00"},{"v":50000,"d":"R50,000.00"},{"v":12500,"d":"R12,500.00"},{"v":62500,"d":"R62,500.00"}]
[6.3,"GSR 3(6)","First aider with level 1,2,3 certificate","Months",{"v":12,"d":"12.00"},{"v":7250,"d":"R7,250.00"},{"v":87000,"d":"R87,000.00"},{"v":4,"d":"4.00"},{"v":1,"d":"1.00"},{"v":5,"d":"5.00"},{"v":29000,"d":"R29,000.00"},{"v":7250,"d":"R7,250.00"},{"v":36250,"d":"R36,250.00"}]
[6.4,"H&S SPEC(i)","Scaffold erector","Months",{"v":2,"d":"2.00"},{"v":7300,"d":"R7,300.00"},{"v":14600,"d":"R14,600.00"},0,0,0,0,0,0]
[6.5,"H&S SPEC (17)","Site Security (Security Officer)","Months",{"v":12,"d":"12.00"},{"v":15000,"d":"R15,000.00"},{"v":180000,"d":"R180,000.00"},{"v":4,"d":"4.00"},{"v":1,"d":"1.00"},{"v":5,"d":"5.00"},{"v":60000,"d":"R60,000.00"},{"v":15000,"d":"R15,000.00"},{"v":75000,"d":"R75,000.00"}]
["6.5.1",null,"Mobile guard-house","No",{"v":1,"d":"1.00"},{"v":12555,"d":"R12,555.00"},{"v":12555,"d":"R12,555.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":12555,"d":"R12,555.00"},0,{"v":12555,"d":"R12,555.00"}]
[7,"H&S SPEC(y).CR27","Housekeeping",{"$nulls":3},0,0,0,0,0,0,0]
[7.1,null,"Barricading of ruble, use a 1m height and 200m long orange net","Sum",{"v":1,"d":"1.00"},{"v":8125,"d":"R8,125.00"},{"v":8125,"d":"R8,125.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":8125,"d":"R8,125.00"},0,{"v":8125,"d":"R8,125.00"}]
[7.2,"BRA(13)","Removal of waste off site once a week",{"$nulls":3},0,0,0,0,0,0,0]
["7.2.1",null,"Transportation once a week","Sum",{"v":1,"d":"1.00"},{"v":120000,"d":"R120,000.00"},{"v":120000,"d":"R120,000.00"},{"v":0.4,"d":"0.40"},{"$f":"J71-H71","v":0},{"v":0.4,"d":"0.40"},{"$f":"H71*F71","v":{"v":48000,"d":"R48,000.00"}},{"$f":"I71*F71","v":0},{"$f":"J71*F71","v":{"v":48000,"d":"R48,000.00"}}]
[7.3,"CR27.H&S SPEC(y)","Cleaning materials and chemicals",{"$nulls":3},0,0,0,0,0,0,0]
["7.3.1",null,"Broom","No",{"v":10,"d":"10.00"},{"v":100,"d":"R100.00"},{"v":1000,"d":"R1,000.00"},{"v":4,"d":"4.00"},{"v":1,"d":"1.00"},{"v":5,"d":"5.00"},{"v":400,"d":"R400.00"},{"v":100,"d":"R100.00"},{"v":500,"d":"R500.00"}]
["7.3.2",null,"Mop","No",{"v":4,"d":"4.00"},{"v":100,"d":"R100.00"},{"v":400,"d":"R400.00"},{"v":3,"d":"3.00"},0,{"v":3,"d":"3.00"},{"v":300,"d":"R300.00"},0,{"v":300,"d":"R300.00"}]
["7.3.3",null,"Sunlight liquid ( 25L)","No",{"v":3,"d":"3.00"},{"v":50,"d":"R50.00"},{"v":150,"d":"R150.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":50,"d":"R50.00"},0,{"v":50,"d":"R50.00"}]
["7.3.4",null,"Handy andy (25)","No",{"v":3,"d":"3.00"},{"v":50,"d":"R50.00"},{"v":150,"d":"R150.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":50,"d":"R50.00"},0,{"v":50,"d":"R50.00"}]
[8,"H&S SPEC(i) SABS Code 085.SANS 10085","Scaffolding",{"$nulls":3},0,0,0,0,0,0,0]
[null,null,"Scaffolding to include shutter boards, toe",{"$nulls":3},0,0,0,0,0,0,0]
[null,null,"boards, base jacks, access stairs/ladders,",{"$nulls":3},0,0,0,0,0,0,0]
[null,null,"braces and safety harnesses","Sum",{"v":1,"d":"1.00"},{"v":128400,"d":"R128,400.00"},{"v":128400,"d":"R128,400.00"},0,0,0,0,0,0]
[9,"ER","Environmental",{"$nulls":3},0,0,0,0,0,0,0]
[9.1,null,"Dust suppression around the plant and site ( twice a day) during construction","Sum",{"v":1,"d":"1.00"},{"v":157300,"d":"R157,300.00"},{"v":157300,"d":"R157,300.00"},{"v":0.4,"d":"0.40"},{"v":0.09999999999999998,"d":"0.10"},{"v":0.5,"d":"0.50"},{"v":62920,"d":"R62,920.00"},{"v":15729.999999999996,"d":"R15,730.00"},{"v":78650,"d":"R78,650.00"}]
[9.2,null,"Waste Management around the plant and site during construction","Sum",{"v":1,"d":"1.00"},{"v":95000,"d":"R95,000.00"},{"$f":"F83*E83","v":{"v":95000,"d":"R95,000.00"}},{"v":0.4,"d":"0.40"},{"v":0.09999999999999998,"d":"0.10"},{"v":0.5,"d":"0.50"},{"v":38000,"d":"R38,000.00"},{"v":9499.999999999998,"d":"R9,500.00"},{"v":47500,"d":"R47,500.00"}]
[9.3,null,"Environmental Complience during construction in terms of the project","Sum",{"v":1,"d":"1.00"},{"v":55000,"d":"R55,000.00"},{"v":55000,"d":"R55,000.00"},{"v":0.4,"d":"0.40"},{"v":0.09999999999999998,"d":"0.10"},{"v":0.5,"d":"0.50"},{"v":22000,"d":"R22,000.00"},{"v":5499.999999999999,"d":"R5,500.00"},{"v":27500,"d":"R27,500.00"}]
[9.4,null,"Environmental Officer","Sum",{"v":1,"d":"1.00"},{"v":160000,"d":"R160,000.00"},{"v":160000,"d":"R160,000.00"},{"v":0.4,"d":"0.40"},{"v":0.09999999999999998,"d":"0.10"},{"v":0.5,"d":"0.50"},{"v":64000,"d":"R64,000.00"},{"v":15999.999999999996,"d":"R16,000.00"},{"v":80000,"d":"R80,000.00"}]
[10,"H&S SPEC(18).CR","Emergency Prepareredness",{"$nulls":3},0,0,0,0,0,0,0]
[10.1,null,"Plastic spine board-heavy duty","No",{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},{"v":10000,"d":"R10,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},0,{"v":10000,"d":"R10,000.00"}]
[10.2,null,"Emergecny board","No",{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},{"v":10000,"d":"R10,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},0,{"v":10000,"d":"R10,000.00"}]
[10.3,null,"Emergency Alarm","No",{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},{"v":10000,"d":"R10,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":10000,"d":"R10,000.00"},0,{"v":10000,"d":"R10,000.00"}]
[11,"H&S SPEC (h). CR23(g), CR13","Excavation",{"$nulls":3},0,0,0,0,0,0,0]
[11.1,null,"Barricading(use orange netting) 900mm high","Sum",{"v":1,"d":"1.00"},{"v":150000,"d":"R150,000.00"},{"v":150000,"d":"R150,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":150000,"d":"R150,000.00"},0,{"v":150000,"d":"R150,000.00"}]
[12,null,"Blasting",{"$nulls":3},0,0,0,0,0,0,0]
[12.1,null,"Blasting permit (Department of labour)","Sum",{"v":1,"d":"1.00"},{"v":60000,"d":"R60,000.00"},{"v":60000,"d":"R60,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":60000,"d":"R60,000.00"},0,{"v":60000,"d":"R60,000.00"}]
["12,2",null,"Blasting specialist","Sum",{"v":1,"d":"1.00"},{"v":90500,"d":"R90,500.00"},{"v":90500,"d":"R90,500.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":90500,"d":"R90,500.00"},0,{"v":90500,"d":"R90,500.00"}]
[13,"H&S SPEC(v).CR17","Formwork and Suspended platform","Sum",{"v":1,"d":"1.00"},{"v":100000,"d":"R100,000.00"},{"v":100000,"d":"R100,000.00"},0,0,0,0,0,0]
[13.1,null,"Temporary handrails/Guardrails( If the form work exceeds 3m height)","Sum",{"v":1,"d":"1.00"},{"v":40000,"d":"R40,000.00"},{"v":40000,"d":"R40,000.00"},0,0,0,0,0,0]
[13.2,null,"Safety harnesses","No",{"v":8,"d":"8.00"},{"v":15000,"d":"R15,000.00"},{"v":120000,"d":"R120,000.00"},0,0,0,0,0,0]
[14,"CR24.H&S SPEC (p).","Electricall Installations","Sum",{"v":1,"d":"1.00"},{"v":13100,"d":"R13,100.00"},{"v":13100,"d":"R13,100.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":13100,"d":"R13,100.00"},0,{"v":13100,"d":"R13,100.00"}]
[15,"CR14.H&S SPEC (20).","Demolitions","Sum",{"v":1,"d":"1.00"},{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},0,0,0,0,0,0]
[16,"GSR13A.CR12(3)(m).","Ladders(Not exceeding 5m)","Sum",{"v":1,"d":"1.00"},{"v":9764.59,"d":"R9,764.59"},{"v":9764.59,"d":"R9,764.59"},{"v":0.4,"d":"0.40"},{"v":0.09999999999999998,"d":"0.10"},{"v":0.5,"d":"0.50"},{"v":3905.8360000000002,"d":"R3,905.84"},{"v":976.4589999999998,"d":"R976.46"},{"v":4882.295,"d":"R4,882.30"}]
[17,"H&S SPEC (11)CR7(1)(b)","Health and Safety File inline with Costruction Regulation 2014","Sum",{"v":1,"d":"1.00"},{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"},{"v":1,"d":"1.00"},0,{"v":1,"d":"1.00"},{"v":50000,"d":"R50,000.00"},{"$f":"I101*F101","v":0},{"$f":"J101*F101","v":{"v":50000,"d":"R50,000.00"}}]
[null,null,"TIME RELATED CHARGE ITEMS",{"$nulls":3},0,0,0,0,0,0,0]
[18,null,"Site Establishment",{"$nulls":3},0,0,0,0,0,0,0]
[18.1,null,"Fencing to the construction site ( 1.8m high)","Month",{"v":12,"d":"12.00"},{"v":5000,"d":"R5,000.00"},{"v":60000,"d":"R60,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":25000,"d":"R25,000.00"},{"v":5000,"d":"R5,000.00"},{"v":30000,"d":"R30,000.00"}]
[18.2,null,"Hoarding with a green net (1.8m high)","Month",{"v":12,"d":"12.00"},{"v":5000,"d":"R5,000.00"},{"v":60000,"d":"R60,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":25000,"d":"R25,000.00"},{"v":5000,"d":"R5,000.00"},{"v":30000,"d":"R30,000.00"}]
[18.3,null,"Site Clearance and waste disposal","Month",{"v":12,"d":"12.00"},{"v":10000,"d":"R10,000.00"},{"v":120000,"d":"R120,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":50000,"d":"R50,000.00"},{"v":10000,"d":"R10,000.00"},{"v":60000,"d":"R60,000.00"}]
[18.4,"GSR 3(2). H&S Spec (z)","First aid boxes","Month",{"v":12,"d":"12.00"},{"v":2500,"d":"R2,500.00"},{"v":30000,"d":"R30,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":12500,"d":"R12,500.00"},{"v":2500,"d":"R2,500.00"},{"v":15000,"d":"R15,000.00"}]
[18.5,"GSR 4. BRA 15, 35. CR 29","Fire Extinguishers ( 7x 9kgs and 3x 5kgs)","Month",{"v":12,"d":"12.00"},{"v":2500,"d":"R2,500.00"},{"v":30000,"d":"R30,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":12500,"d":"R12,500.00"},{"v":2500,"d":"R2,500.00"},{"v":15000,"d":"R15,000.00"}]
[18.6,"CR 30.BRA 2.H&S SPEC (u)","Water Flushing Toilets ( 1 per 15 people, each toilet per gender)","Month",{"v":12,"d":"12.00"},{"v":2700,"d":"R2,700.00"},{"v":32400,"d":"R32,400.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":13500,"d":"R13,500.00"},{"v":2700,"d":"R2,700.00"},{"v":16200,"d":"R16,200.00"}]
[18.7,"CR27","Waste bins ( Plastic overlapping waste bins 100L)","Month",{"v":12,"d":"12.00"},{"v":1000,"d":"R1,000.00"},{"v":12000,"d":"R12,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":5000,"d":"R5,000.00"},{"v":1000,"d":"R1,000.00"},{"v":6000,"d":"R6,000.00"}]
[18.8,"CR30","Shadding net for an eating area ( Green net 5m long)","Month",{"v":12,"d":"12.00"},{"v":1000,"d":"R1,000.00"},{"v":12000,"d":"R12,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":5000,"d":"R5,000.00"},{"v":1000,"d":"R1,000.00"},{"v":6000,"d":"R6,000.00"}]
[18.9,"CR30","Benches for an eating area ( 4m long)","Month",{"v":12,"d":"12.00"},{"v":500,"d":"R500.00"},{"v":6000,"d":"R6,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":2500,"d":"R2,500.00"},{"v":500,"d":"R500.00"},{"v":3000,"d":"R3,000.00"}]
[19,"H&S SPEC (g). CR 7(6). GSR 2","Personal Protective Equipment",{"$nulls":3},0,0,0,0,0,0,0]
[19.1,null,"Overalls( Blue/Orange/Green)","Month",{"v":12,"d":"12.00"},{"v":3500,"d":"R3,500.00"},{"v":42000,"d":"R42,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":17500,"d":"R17,500.00"},{"v":3500,"d":"R3,500.00"},{"v":21000,"d":"R21,000.00"}]
[19.2,null,"Hart hats","Month",{"v":12,"d":"12.00"},{"v":650,"d":"R650.00"},{"v":7800,"d":"R7,800.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":3250,"d":"R3,250.00"},{"v":650,"d":"R650.00"},{"v":3900,"d":"R3,900.00"}]
[19.3,null,"Boots",{"$nulls":3},0,{"$nulls":3},0,0,0]
["19.3.1",null,"water boots","Month",{"v":12,"d":"12.00"},{"v":5000,"d":"R5,000.00"},{"v":60000,"d":"R60,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":25000,"d":"R25,000.00"},{"v":5000,"d":"R5,000.00"},{"v":30000,"d":"R30,000.00"}]
["19.3.2",null,"Safety boots","Month",{"v":12,"d":"12.00"},{"v":5000,"d":"R5,000.00"},{"v":60000,"d":"R60,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":25000,"d":"R25,000.00"},{"v":5000,"d":"R5,000.00"},{"v":30000,"d":"R30,000.00"}]
[19.4,null,"Gloves ( General and Skilled activities)","Month",{"v":12,"d":"12.00"},{"v":500,"d":"R500.00"},{"v":6000,"d":"R6,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":2500,"d":"R2,500.00"},{"v":500,"d":"R500.00"},{"v":3000,"d":"R3,000.00"}]
[19.5,null,"Goggles","Month",{"v":12,"d":"12.00"},{"v":500,"d":"R500.00"},{"v":6000,"d":"R6,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":2500,"d":"R2,500.00"},{"v":500,"d":"R500.00"},{"v":3000,"d":"R3,000.00"}]
[19.6,null,"Earplugs","Month",{"v":12,"d":"12.00"},{"v":500,"d":"R500.00"},{"v":6000,"d":"R6,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":2500,"d":"R2,500.00"},{"v":500,"d":"R500.00"},{"v":3000,"d":"R3,000.00"}]
[19.7,null,"Reflector vests","Month",{"v":12,"d":"12.00"},{"v":500,"d":"R500.00"},{"v":6000,"d":"R6,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":2500,"d":"R2,500.00"},{"v":500,"d":"R500.00"},{"v":3000,"d":"R3,000.00"}]
[19.8,null,"Sun-block hats","Month",{"v":12,"d":"12.00"},{"v":500,"d":"R500.00"},{"v":6000,"d":"R6,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":2500,"d":"R2,500.00"},{"v":500,"d":"R500.00"},{"v":3000,"d":"R3,000.00"}]
[19.9,null,"Dust mask","Month",{"v":12,"d":"12.00"},{"v":500,"d":"R500.00"},{"v":6000,"d":"R6,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":2500,"d":"R2,500.00"},{"v":500,"d":"R500.00"},{"v":3000,"d":"R3,000.00"}]
[19.1,null,"Medical Vaccination for all Labourers working on site, specific for Waste Water Treatment Works","Month",{"v":12,"d":"12.00"},{"v":500,"d":"R500.00"},{"v":6000,"d":"R6,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":2500,"d":"R2,500.00"},{"v":500,"d":"R500.00"},{"v":3000,"d":"R3,000.00"}]
[20," H&S SPEC (9),(ii). CR 23(K)","Inductions, Toolbox talks, Checklists, Registers and Risk asessments",{"$nulls":3},0,0,0,0,0,0,0]
[20.1,null,"Stationary","Month",{"v":12,"d":"12.00"},{"v":5000,"d":"R5,000.00"},{"v":60000,"d":"R60,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":25000,"d":"R25,000.00"},{"v":5000,"d":"R5,000.00"},{"v":30000,"d":"R30,000.00"}]
[20.2,null,"Printer","Month",{"v":12,"d":"12.00"},{"v":5000,"d":"R5,000.00"},{"v":60000,"d":"R60,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":25000,"d":"R25,000.00"},{"v":5000,"d":"R5,000.00"},{"v":30000,"d":"R30,000.00"}]
[20.3,null,"Laptop","Month",{"v":12,"d":"12.00"},{"v":5000,"d":"R5,000.00"},{"v":60000,"d":"R60,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":25000,"d":"R25,000.00"},{"v":5000,"d":"R5,000.00"},{"v":30000,"d":"R30,000.00"}]
[21,"CR 7(g). H&S SPEC (16)","Medical Fitness examinations","Month",{"v":12,"d":"12.00"},{"v":15000,"d":"R15,000.00"},{"v":180000,"d":"R180,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":75000,"d":"R75,000.00"},{"v":15000,"d":"R15,000.00"},{"v":90000,"d":"R90,000.00"}]
[22,"H&S SPEC(y).CR27","Housekeeping",{"$nulls":3},0,0,0,0,0,0,0]
[22.1,null,"Barricading of ruble, use a 1m height and 200m long orange net","Month",{"v":12,"d":"12.00"},{"v":1000,"d":"R1,000.00"},{"v":12000,"d":"R12,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":5000,"d":"R5,000.00"},{"v":1000,"d":"R1,000.00"},{"v":6000,"d":"R6,000.00"}]
[23,"BRA(13)","Removal of waste off site once a week",{"$nulls":3},0,0,0,null,0,0,0]
[23.1,null,"Transportation once a week","Month",{"v":12,"d":"12.00"},{"v":1500,"d":"R1,500.00"},{"v":18000,"d":"R18,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":7500,"d":"R7,500.00"},{"v":1500,"d":"R1,500.00"},{"v":9000,"d":"R9,000.00"}]
[24,"H&S SPEC (h). CR23(g), CR13","Excavation",{"$nulls":3},0,0,{"$f":"J135-H135","v":0},0,{"$f":"H135*F135","v":0},{"$f":"I135*F135","v":0},{"$f":"J135*F135","v":0}]
[24.1,null,"Barricading (use orange netting) 900mm high","Month",{"v":12,"d":"12.00"},{"v":1000,"d":"R1,000.00"},{"v":12000,"d":"R12,000.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"v":5000,"d":"R5,000.00"},{"v":1000,"d":"R1,000.00"},{"v":6000,"d":"R6,000.00"}]
[]
[]
[]
[]
["Total Section 1 Carried to Summary",{"$nulls":5},{"$f":"SUM(G3:G140)","v":{"v":3999244.59,"d":"R3,999,244.59"}},{"$nulls":3},{"$f":"SUM(K5:K140)","v":{"v":1887005.836,"d":"R1,887,005.84"}},{"$f":"SUM(L5:L140)","v":{"v":180406.459,"d":"R180,406.46"}},{"v":2067412.295,"d":"R2,067,412.30"}]
[]
[{"$nulls":6},{"v":3999244.59,"d":"R3,999,244.59"}]
[]
[{"$nulls":6},{"$f":"G143-G141","v":0}]

{"sheet":"Sludge Lagoons - Pipeline","index":5,"n_rows":61,"n_cols":7,"rows_kept":61,"merged":[[0,0,0,6],[1,0,1,6],[60,0,60,5]]}
["SECTION 4: PIPELINE"]
[]
["ITEM\nNo","PAYMENT\nREF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[4.1,null,"Trenches for Water Pipes"]
["4.1.1",null,"Excavate in all materials for trenches backfill, compact and dispose of surplus material"]
[null,null,"a) Pipes up to 300mm dia for depths up to 1.0m","m",{"v":500,"d":"500.00"}]
[null,null,"b) Extra over item a) above for  intermediate excavation","m3",{"v":150,"d":"150.00"}]
[null,null,"c) Extra over item a) above for  hard rock excavation","m3",{"v":50,"d":"50.00"}]
[null,null,"d) Extra over item a) above for  hand excavation and backfill where odered by engineer","m3",{"v":10,"d":"10.00"}]
[null,null,"e) Extra over item a) above for  backfill stabilized with 55 cement where directed by the engineer","m3",{"v":5,"d":"5.00"}]
[null,null,"f) Extra over item a) above for soilcrete backfill where directed by the engineer","m3",{"v":5,"d":"5.00"}]
[]
["4.1.2",null,"Medium-Pressure Pipelines"]
[null,null,"a) Supply, lay and bed on bedding for flexible pipes complete with copuplings and bends : uPVC class 9 Pipe, 300mm diameter","m",{"v":500,"d":"500.00"}]
["3.1.3",null,"b) Supply, lay and bed perforated subsurface drain pipe complete with fittings : uPVC class 9 Pipe, 160mm diameter","m",{"v":150,"d":"150.00"}]
[]
["4.1.3",null,"Valve Chambers"]
[null,null,"a) Allow sum for Valve and flow meter chambers, complete with foundations, concrete works, catladder and manhole covers. ","Prov Sum",{"v":1,"d":"1.00"},{"v":350000,"d":"R350,000.00"},{"$f":"F18*E18","v":{"v":350000,"d":"R350,000.00"}}]
[]
["4.1.4",null,"Bedding & Anchors for Water Pipes"]
[null,null,"a) Class 25MPa/19mm concrete cast in situ for Anchor blocks","m3",{"v":5,"d":"5.00"}]
[null,null,"b) Bedding from trench excavations :"]
[null,null,"i) Selected granualr material","m3",{"v":30,"d":"30.00"}]
[null,null,"ii) Selected fill material","m3",{"v":80,"d":"80.00"}]
{"$rows_empty":36}
["SECTION 4 : CARRIED TO SUMMARY :  PIPELINE WORKS"]

{"sheet":"Sludge Lagoons - Prov Sums ","index":6,"n_rows":57,"n_cols":7,"rows_kept":57,"merged":[[0,0,0,6],[1,0,1,6],[56,0,56,5]]}
["SECTION 5: PROVISIONAL SUMS"]
[]
["ITEM\nNo","PAYMENT\nREF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[5.1,null,"Building Works to Chlorine House"]
["5.1.1",null,"Building works including new doors, waterproofing, stormwater drainage and paintwork. ","Prov sum",{"v":1,"d":"1.00"},{"v":200000,"d":"R200,000.00"},{"$f":"F5*E5","v":{"v":200000,"d":"R200,000.00"}}]
[]
[5.2,null,"Access Roads"]
["5.2.1",null,"Allow Sum for New Access roads around the lagoons","Prov sum",{"v":1,"d":"1.00"},{"v":600000,"d":"R600,000.00"},{"$f":"F8*E8","v":{"v":600000,"d":"R600,000.00"}}]
[]
[5.3,null,"Eectro-Mechanical works to the Pumpstation"]
["5.3.1",null,"Allow sum for Electro-Mechanical works to pumpstation, which includes pumps, motors, cables, control panels, pumps shed, piping, valves and fittings. ","Prov sum",{"v":1,"d":"1.00"},{"v":2500000,"d":"R2,500,000.00"},{"$f":"F11*E11","v":{"v":2500000,"d":"R2,500,000.00"}}]
[]
[5.4,null,"Disinfection "]
["5.4.1",null,"Allow sum for Disinfection equipment, including ventilation, to chlorine house, scrubber commissioning, and repairs to chlorination system. ","Prov sum",{"v":1,"d":"1.00"},{"v":800000,"d":"R800,000.00"},{"$f":"F14*E14","v":{"v":800000,"d":"R800,000.00"}}]
[]
[5.5,null,"Percentage (%) mark-up on item 4.1 to 4.4 above for Contractor's overheads, administration charges and profit","%",null,{"$f":"SUM(F5:F15)","v":{"v":4100000,"d":"R4,100,000.00"}},{"$f":"F16*E16/100","v":0}]
[" "]
{"$rows_empty":39}
["SECTION 5 : CARRIED TO SUMMARY :  PROVISIONAL SUMS"]

{"sheet":"Summary (FANIE)","index":7,"n_rows":28,"n_cols":7,"rows_kept":28,"hidden":true,"merged":[[0,0,0,2],[0,4,0,6]]}
["SUMMARY REFURBISHMENT AND COMMISSINING OF A 10 ML/DAY PACKAGE PLANT. ",{"$nulls":3},"CLAIM 1 - 29 Feb 2024"]
["ITEM","DESCRIPTION","AMOUNT",null,"AMOUNT\nTO DATE","AMOUNT\nPREVIOUS","AMOUNT\nCURRENT"]
[]
[1,"Preliminary and General",{"$f":"'P&G'!G55","v":{"v":1012901,"d":"1,012,901.00"}},null,{"$f":"'P&G'!K55","v":{"v":269250,"d":"269,250.00"}},{"$f":"'P&G'!L55","v":0},{"$f":"'P&G'!M55","v":{"v":269250,"d":"269,250.00"}}]
[]
[]
[2,"Civil and General Site Works",{"$f":"'Civil & General SIte  Works'!G35","v":{"v":825360,"d":"825,360.00"}},null,{"$f":"'Civil & General SIte  Works'!K35","v":{"v":11000,"d":"11,000.00"}},{"$f":"'Civil & General SIte  Works'!L35","v":0},{"$f":"'Civil & General SIte  Works'!M35","v":{"v":11000,"d":"11,000.00"}}]
[]
[]
[3,"Eskom Power Supply and Electrical Works",{"$f":"'Eskom Power Supply & Electrical'!G29","v":{"v":2405273,"d":"2,405,273.00"}},null,{"$f":"'Eskom Power Supply & Electrical'!K29","v":{"v":340595.89999999997,"d":"340,595.90"}},{"$f":"'Eskom Power Supply & Electrical'!L29","v":0},{"$f":"'Eskom Power Supply & Electrical'!M29","v":{"v":340595.89999999997,"d":"340,595.90"}}]
[]
[]
[4,"Mechanical Works ",{"$f":"'Mechanical Works'!G32","v":{"v":2366484,"d":"2,366,484.00"}},null,{"$f":"'Mechanical Works'!K32","v":{"v":192277.3,"d":"192,277.30"}},{"$f":"'Mechanical Works'!L32","v":0},{"$f":"'Mechanical Works'!M32","v":{"v":192277.3,"d":"192,277.30"}}]
[]
[]
[]
[null,"Sub Total A",{"$f":"SUM(C4:C13)","v":{"v":6610018,"d":"6,610,018.00"}},null,{"$f":"SUM(E4:E13)","v":{"v":813123.2,"d":"813,123.20"}},{"$f":"SUM(F4:F13)","v":0},{"$f":"SUM(G4:G13)","v":{"v":813123.2,"d":"813,123.20"}}]
[]
[]
[]
[null,"CONTIGENCIES AT 10%",{"$f":"C17*15%","v":{"v":991502.7,"d":"991,502.70"}},null,0,0,0]
[]
[]
[null,"Sub Total B",{"$f":"C17+C21","v":{"v":7601520.7,"d":"7,601,520.70"}},null,{"$f":"E17+E21","v":{"v":813123.2,"d":"813,123.20"}},{"$f":"F17+F21","v":0},{"$f":"G17+G21","v":{"v":813123.2,"d":"813,123.20"}}]
[]
[null,"15 % VAT",{"$f":"C24*15%","v":{"v":1140228.105,"d":"1,140,228.11"}},null,{"$f":"E24*15%","v":{"v":121968.47999999998,"d":"121,968.48"}},{"$f":"F24*15%","v":0},{"$f":"G24*15%","v":{"v":121968.47999999998,"d":"121,968.48"}}]
[]
[null,"TOTAL PRICE VAT INCLUSIVE",{"$f":"C26+C24","v":{"v":8741748.805,"d":"8,741,748.81"}},null,{"$f":"E26+E24","v":{"v":935091.6799999999,"d":"935,091.68"}},{"$f":"F26+F24","v":0},{"$f":"G26+G24","v":{"v":935091.6799999999,"d":"935,091.68"}}]

{"sheet":"P&G","index":8,"n_rows":55,"n_cols":13,"rows_kept":55,"hidden":true,"merged":[[0,0,0,12],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[54,0,54,5],[55,0,55,6]]}
["REFURBISHMENT AND COMMISSINING OF A 10 ML/DAY PACKAGE PLANT. "]
["ITEM NO","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT","QTY\nTO DATE","QTY\nPREVIOUS","QTY\nCURRENT","AMOUNT\nTO DATE","AMOUNT\nPREVIOUS","AMOUNT\nCURRENT"]
[]
[]
[1,"1200A","SECTION 1 : PRELIMINARY & GENERAL"]
[1.1,8.3,"FIXED-CHARGE ITEMS"]
[]
["1.1.1","8.3.1","Contractual Requirements","Sum",1,{"v":228850,"d":"R228,850.00"},{"$f":"E8*F8","v":{"v":228850,"d":"R228,850.00"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"$f":"H8-I8","v":{"v":1,"d":"100%"}},{"$f":"F8*H8","v":{"v":228850,"d":"228,850.00"}},{"$f":"F8*I8","v":0},{"$f":"F8*J8","v":{"v":228850,"d":"228,850.00"}}]
[1.2,"8.3.2","Establishment of Facilities on the Site","Sum",1,{"v":35000,"d":"R35,000.00"},{"$f":"E9*F9","v":{"v":35000,"d":"R35,000.00"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"$f":"H9-I9","v":{"v":1,"d":"100%"}},{"$f":"F9*H9","v":{"v":35000,"d":"35,000.00"}},{"$f":"F9*I9","v":0},{"$f":"F9*J9","v":{"v":35000,"d":"35,000.00"}}]
[]
["1.2.1","8.3.2.2","Facilities required by the Contractor"]
["1.2.1.1",null,"a) Offices & Storage Sheds","Sum","Rate Only",{"v":36000,"d":"R36,000.00"},"Rate Only"]
["1.2.1.3",null,"b) Ablution and latrine facilities","Sum","Rate Only",{"v":25000,"d":"R25,000.00"},"Rate Only"]
["1.2.1.6",null,"c) Dealing with water","Sum","Rate Only",{"v":15000,"d":"R15,000.00"},"Rate Only"]
["1.2.1.7",null,"d) Plant","Sum","Rate Only",{"v":35000,"d":"R35,000.00"},"Rate Only"]
[]
[]
["1.1.10","8.3.4","Removal of Site Establishment","Sum",1,{"v":55602,"d":"R55,602.00"},{"$f":"F18*E18","v":{"v":55602,"d":"R55,602.00"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H18-I18","v":{"v":0,"d":"0%"}},{"$f":"F18*H18","v":0},{"$f":"F18*I18","v":0},{"$f":"F18*J18","v":0}]
["1.1.11",null,"Clear rubble and waste from site ","Sum",1,{"v":15800,"d":"R15,800.00"},{"$f":"F19*E19","v":{"v":15800,"d":"R15,800.00"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H19-I19","v":{"v":0,"d":"0%"}},{"$f":"F19*H19","v":0},{"$f":"F19*I19","v":0},{"$f":"F19*J19","v":0}]
[]
[1.2,8.4,"TIME-RELATED ITEMS"]
[]
["1.2.1","8.4.1","Contractual Requirements","Sum",1,{"v":168560,"d":"R168,560.00"},{"v":168560,"d":"R168,560.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H23-I23","v":{"v":0,"d":"0%"}},{"$f":"F23*H23","v":0},{"$f":"F23*I23","v":0},{"$f":"F23*J23","v":0}]
["1.2.2","8.4.2","Operation and Maintenance of Package Plant for a period of 12 months; complete with inspections during the defects liability period.","Sum",1,{"v":408589,"d":"R408,589.00"},{"v":408589,"d":"R408,589.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H24-I24","v":{"v":0,"d":"0%"}},{"$f":"F24*H24","v":0},{"$f":"F24*I24","v":0},{"$f":"F24*J24","v":0}]
[{"$nulls":7},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H25-I25","v":{"v":0,"d":"0%"}},{"$f":"F25*H25","v":0},{"$f":"F25*I25","v":0},{"$f":"F25*J25","v":0}]
["1.2.3","8.4.2.2","Facilities required by the Contractor",{"$nulls":4},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H26-I26","v":{"v":0,"d":"0%"}},{"$f":"F26*H26","v":0},{"$f":"F26*I26","v":0},{"$f":"F26*J26","v":0}]
["1.2.3.1",null,"a) Offices & Storage Sheds","Sum",1,{"v":36000,"d":"R36,000.00"},"Rate Only"]
["1.2.3.2",null,"b) Ablution and latrine facilities","Sum",1,{"v":25000,"d":"R25,000.00"},"Rate Only"]
["1.2.3.3",null,"c) Dealing with water","Sum",1,{"v":15000,"d":"R15,000.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H29-I29","v":{"v":0,"d":"0%"}},{"$f":"F29*H29","v":0},{"$f":"F29*I29","v":0},{"$f":"F29*J29","v":0}]
["1.2.3.4",null,"d) Plant","Sum",1,{"v":35000,"d":"R35,000.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H30-I30","v":{"v":0,"d":"0%"}},{"$f":"F30*H30","v":0},{"$f":"F30*I30","v":0},{"$f":"F30*J30","v":0}]
["1.2.3.5",null,"e) Construction Name Board","No.",1,{"v":18000,"d":"R18,000.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H31-I31","v":{"v":0,"d":"0%"}},{"$f":"F31*H31","v":0},{"$f":"F31*I31","v":0},{"$f":"F31*J31","v":0}]
["1.2.3.6",null,"f) Security until project completion","months ",5,{"v":16500,"d":"R16,500.00"},{"$f":"F32*E32","v":{"v":82500,"d":"R82,500.00"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H32-I32","v":{"v":0,"d":"0%"}},{"$f":"F32*H32","v":0},{"$f":"F32*I32","v":0},{"$f":"F32*J32","v":0}]
[]
[1.3,8.7,"DAYWORKS  (Provisional)"]
["1.3.1",null,"a) Labour","h",1,{"v":35,"d":"R35.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H35-I35","v":{"v":0,"d":"0%"}},{"$f":"F35*H35","v":0},{"$f":"F35*I35","v":0},{"$f":"F35*J35","v":0}]
["1.3.2",null,"b) Skilled","h",1,{"v":155,"d":"R155.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["1.3.3",null,"c) Semi-skilled","h",1,{"v":85,"d":"R85.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["1.3.4",null,"d) Unskilled","h",1,{"v":55,"d":"R55.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["1.3.5",null,"e) Materials","Prov",1,{"v":25000,"d":"R25,000.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["1.3.6",null,"f) Nett costs of Materials (Prov Sum)","Sum",1,{"v":35000,"d":"R35,000.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["1.3.7",null,"g) Percentage Adjustment","%",1,{"v":10,"d":"R10.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["1.3.8",null,"h) Plants (incl. overheads, profits etc)","h",1,{"v":55000,"d":"R55,000.00"},"Rate Only",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
[]
[1.4,"PSA8.3","Compliance with Occupational Health & Safety Act (Act 85 of 1993 and amendments)"]
[]
["1.4.1",null,"Preparation and implementation of Health and Safety Plan","Sum",1,{"v":10000,"d":"R10,000.00"},{"$f":"F46*E46","v":{"v":10000,"d":"R10,000.00"}},{"v":0.3,"d":"30%"},{"v":0,"d":"0%"},{"$f":"H46-I46","v":{"v":0.3,"d":"30%"}},{"$f":"F46*H46","v":{"v":3000,"d":"3,000.00"}},{"$f":"F46*I46","v":0},{"$f":"F46*J46","v":{"v":3000,"d":"3,000.00"}}]
[]
["1.4.2",null,"Personnel and Protective clothing and equipments","Sum",1,{"v":8000,"d":"R8,000.00"},{"$f":"E48*F48","v":{"v":8000,"d":"R8,000.00"}},{"v":0.3,"d":"30%"},{"v":0,"d":"0%"},{"$f":"H48-I48","v":{"v":0.3,"d":"30%"}},{"$f":"F48*H48","v":{"v":2400,"d":"2,400.00"}},{"$f":"F48*I48","v":0},{"$f":"F48*J48","v":{"v":2400,"d":"2,400.00"}}]
[]
["1.5",null,"Additional Items - specify and cost"]
[]
["1.5.1",null,"…...................................................................","Sum",1]
["1.5.2",null,"…...................................................................","Sum",1]
[]
[" Total Carried to Summary",{"$nulls":5},{"$f":"SUM(G4:G54)","v":{"v":1012901,"d":"R1,012,901.00"}},{"$nulls":3},{"$f":"SUM(K4:K54)","v":{"v":269250,"d":"269,250.00"}},{"$f":"SUM(L4:L54)","v":0},{"$f":"SUM(M4:M54)","v":{"v":269250,"d":"269,250.00"}}]

{"sheet":"Mechanical Works","index":9,"n_rows":32,"n_cols":13,"rows_kept":32,"hidden":true,"merged":[[0,0,0,12],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[31,0,31,5]]}
["REFURBISHMENT AND COMMISSINING OF A 10 ML/DAY PACKAGE PLANT. "]
["ITEM NO","PAYMENT","DESCRIPTION.   REFURBISHMENT AND COMMISSINING OF A 10 ML/DAY PACKAGE PLANT.","UNIT","QTY","RATE","AMOUNT","QTY\nTO DATE","QTY\nPREVIOUS","QTY\nCURRENT","AMOUNT\nTO DATE","AMOUNT\nPREVIOUS","AMOUNT\nCURRENT"]
[]
[5,null,"MECHANICAL WORKS"]
[]
[5.1,null,"Repair of Mixers "]
["5,1,1",null,"Test, recondition/refurbishment and commission of Clarifier mixers complete with gearboxs and motors","Sum",4,{"v":46562,"d":"46,562.00"},{"$f":"F7*E7","v":{"v":186248,"d":"186,248.00"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"$f":"H7-I7","v":{"v":1,"d":"100%"}},{"$f":"F7*H7","v":{"v":46562,"d":"46,562.00"}},{"$f":"F7*I7","v":0},{"$f":"F7*J7","v":{"v":46562,"d":"46,562.00"}}]
[]
[5.2,null,"PUMP REPAIRS "]
["5,2,1",null,"Test, recondition/refurbishment and commission of Backwash pumps by KSB complete with motors","Sum",2,{"v":55800,"d":"55,800.00"},{"$f":"F10*E10","v":{"v":111600,"d":"111,600.00"}},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"$f":"H10-I10","v":{"v":0.5,"d":"50%"}},{"$f":"F10*H10","v":{"v":27900,"d":"27,900.00"}},{"$f":"F10*I10","v":0},{"$f":"F10*J10","v":{"v":27900,"d":"27,900.00"}}]
["5,2,3",null,"Test, recondition/refurbishment and commission of High lift pumps by KSB complete with motors","Sum",2,{"v":128682,"d":"128,682.00"},{"v":257364,"d":"257,364.00"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"$f":"H11-I11","v":{"v":0.5,"d":"50%"}},{"$f":"F11*H11","v":{"v":64341,"d":"64,341.00"}},{"$f":"F11*I11","v":0},{"$f":"F11*J11","v":{"v":64341,"d":"64,341.00"}}]
["5,2,4",null,"Test, recondition/refurbishment and commission of active sludge flow pumps complete with motors","Sum",2,{"v":25235,"d":"25,235.00"},{"v":50470,"d":"50,470.00"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":12617.5,"d":"12,617.50"},0,{"v":12617.5,"d":"12,617.50"}]
["5,2,5",null,"Test, recondition/refurbishment and commission of compressors complete.","Sum",2,{"v":7850,"d":"7,850.00"},{"v":15700,"d":"15,700.00"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"v":0.5,"d":"50%"},{"v":3925,"d":"3,925.00"},0,{"v":3925,"d":"3,925.00"}]
[]
[5.3,null,"REPLACEMENT OF ACTUATORS AND VALVES"]
["5,3,1",null,"Repairs of valves, complete with electric actuators for electrical control, various sizes- bidder to list the number of actuators at the inlet and filters. (Replace pnumatic actuators completely)","Sum",16,{"v":54856,"d":"54,856.00"},{"v":877696,"d":"877,696.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["5,3,2",null,"Repairs of valves, complete with gaskets and bolts in all installations. ","Sum",24,{"v":6852,"d":"6,852.00"},{"v":164448,"d":"164,448.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
[]
[5.4,null,"COMMISSIONING OF FILTERS "]
["5,4,1",null,"Replacement of filter media in each of the filters ","Sum",5,{"v":65832,"d":"65,832.00"},{"v":329160,"d":"329,160.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H20-I20","v":{"v":0,"d":"0%"}},{"$f":"F20*H20","v":0},{"$f":"F20*I20","v":0},{"$f":"F20*J20","v":0}]
["5,4,2",null,"Recondition filter pipes and fittings","Sum",1,{"v":66032,"d":"66,032.00"},{"v":66032,"d":"66,032.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H21-I21","v":{"v":0,"d":"0%"}},{"$f":"F21*H21","v":0},{"$f":"F21*I21","v":0},{"$f":"F21*J21","v":0}]
[]
[5.5,null,"COMMISSIONING OF CHEMICAL DOSING SYSTEM"]
["5.5.1",null,"Repairs of chemical dosing tanks complete with pipes and connections","Sum",4,{"v":14562,"d":"14,562.00"},{"v":58248,"d":"58,248.00"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"$f":"H24-I24","v":{"v":0.1,"d":"10%"}},{"$f":"F24*H24","v":{"v":1456.2,"d":"1,456.20"}},{"$f":"F24*I24","v":0},{"$f":"F24*J24","v":{"v":1456.2,"d":"1,456.20"}}]
["5.5.2",null,"Replace of pipe tubes across the plant for chemcial dosing poInts ","Sum",4,{"v":18035,"d":"18,035.00"},{"v":72140,"d":"72,140.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H25-I25","v":{"v":0,"d":"0%"}},{"$f":"F25*H25","v":0},{"$f":"F25*I25","v":0},{"$f":"F25*J25","v":0}]
[]
[5.6,null,"COMMISSIONON OF TANKS"]
["5.6.1",null,"Test and Recondition the Backwash water tank, complete with repairs to tank structure, pipe fittings and linners","Sum",1,{"v":88689,"d":"88,689.00"},{"v":88689,"d":"88,689.00"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"$f":"H28-I28","v":{"v":0.2,"d":"20%"}},{"$f":"F28*H28","v":{"v":17737.8,"d":"17,737.80"}},{"$f":"F28*I28","v":0},{"$f":"F28*J28","v":{"v":17737.8,"d":"17,737.80"}}]
["5.6.2",null,"Test and Recondition the Final  water tank, complete with repairs to tank structure, pipe fittings and linners","Sum",1,{"v":88689,"d":"88,689.00"},{"v":88689,"d":"88,689.00"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"$f":"H29-I29","v":{"v":0.2,"d":"20%"}},{"$f":"F29*H29","v":{"v":17737.8,"d":"17,737.80"}},{"$f":"F29*I29","v":0},{"$f":"F29*J29","v":{"v":17737.8,"d":"17,737.80"}}]
[]
[null,null,"Note : Bidder will be required to provide cost breakdown for all sums and actual quantities in each certificate "]
[" Total Carried Forward Summary",{"$nulls":5},{"$f":"SUM(G4:G31)","v":{"v":2366484,"d":"2,366,484.00"}},{"$nulls":3},{"$f":"SUM(K7:K31)","v":{"v":192277.3,"d":"192,277.30"}},{"$f":"SUM(L7:L31)","v":0},{"$f":"SUM(M7:M31)","v":{"v":192277.3,"d":"192,277.30"}}]

{"sheet":"Civil & General SIte  Works","index":10,"n_rows":35,"n_cols":13,"rows_kept":35,"hidden":true,"merged":[[0,0,0,12],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[34,0,34,5]]}
["REFURBISHMENT AND COMMISSINING OF A 10 ML/DAY PACKAGE PLANT. "]
["ITEM NO","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","AMOUNT","QTY\nTO DATE","QTY\nPREVIOUS","QTY\nCURRENT","AMOUNT\nTO DATE","AMOUNT\nPREVIOUS","AMOUNT\nCURRENT"]
[]
[]
[2,null,"CIVIL  - GENERAL SITE WORKS",{"$nulls":4},0,0,{"$f":"H5-I5","v":0},{"$f":"F5*H5","v":0},{"$f":"F5*I5","v":0},{"$f":"F5*J5","v":0}]
[2.1,null,"Repairs to concrete plinths around the entire plant - actuve flow settleing tank, back wash tank, filters and final water tank.","Sum",1,{"v":55000,"d":"R55,000.00"},{"$f":"E6*F6","v":{"v":55000,"d":"R55,000.00"}},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"$f":"H6-I6","v":{"v":0.2,"d":"20%"}},{"$f":"F6*H6","v":{"v":11000,"d":"11,000.00"}},{"$f":"F6*I6","v":0},{"$f":"F6*J6","v":{"v":11000,"d":"11,000.00"}}]
["2.1.1",null,"Sealing of concrete structures","Sum",1,{"v":35000,"d":"R35,000.00"},{"$f":"E7*F7","v":{"v":35000,"d":"R35,000.00"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H7-I7","v":{"v":0,"d":"0%"}},{"$f":"F7*H7","v":0},{"$f":"F7*I7","v":0},{"$f":"F7*J7","v":0}]
[{"$nulls":9},{"$f":"H8-I8","v":0},{"$f":"F8*H8","v":0},{"$f":"F8*I8","v":0},{"$f":"F8*J8","v":0}]
[2.2,null,"SECTION 2: CIVIL WORKS",{"$nulls":6},0,0,0,0]
[null,null,"SITE CLEARANCE",{"$nulls":6},0,0,0,0]
["2.2.1",null,"Remove and grub and tree stumps:","m²",1500,{"v":12,"d":"R12.00"},{"$f":"E11*F11","v":{"v":18000,"d":"R18,000.00"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H11-I11","v":{"v":0,"d":"0%"}},{"$f":"F11*H11","v":0},{"$f":"F11*I11","v":0},{"$f":"F11*J11","v":0}]
["2.2.1",null,"Soil poisening of various sections along concrete structures ","Sum",1,{"v":6000,"d":"R6,000.00"},{"$f":"E12*F12","v":{"v":6000,"d":"R6,000.00"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H12-I12","v":{"v":0,"d":"0%"}},{"$f":"F12*H12","v":0},{"$f":"F12*I12","v":0},{"$f":"F12*J12","v":0}]
[]
[2.3,null,"PAVEMENT "]
["2.3.1",null,"Extention of pavement around structures, complete with gabions and Stormwater channels.","m²",266,{"v":385,"d":"R385.00"},{"$f":"E15*F15","v":{"v":102410,"d":"R102,410.00"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H15-I15","v":{"v":0,"d":"0%"}},{"$f":"F15*H15","v":0},{"$f":"F15*I15","v":0},{"$f":"F15*J15","v":0}]
[]
[2.4,null,"PLATFORMS AND WALKWAYS"]
["2.4.1",null,"Active Flow- settleing tanks : repainting and reconditioning of platforms and walk way.","Sum",1,{"v":355662,"d":"R355,662.00"},{"$f":"F18*E18","v":{"v":355662,"d":"R355,662.00"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H18-I18","v":{"v":0,"d":"0%"}},{"$f":"F18*H18","v":0},{"$f":"F18*I18","v":0},{"$f":"F18*J18","v":0}]
[]
[2.5,null,"CONTAINERS"]
["2.5.1",null,"Repair and renovation of the laboratory and office - complete with doors, windows and wall insultors","Sum",1,{"v":20300,"d":"R20,300.00"},{"$f":"F21*E21","v":{"v":20300,"d":"R20,300.00"}},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H21-I21","v":{"v":0,"d":"0%"}},{"$f":"F21*H21","v":0},{"$f":"F21*I21","v":0},{"$f":"F21*J21","v":0}]
["2.5.2",null,"Repair of ablution facilities - complete with doors, windows and wall insultors","Sum",1,{"v":12000,"d":"R12,000.00"},{"v":12000,"d":"R12,000.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["2.5.3",null,"Installation of air conditioners in lab/ office","Sum",1,{"v":25000,"d":"R25,000.00"},{"v":25000,"d":"R25,000.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["2.5.4",null,"Instrallation of vantilation in the instrumentation container and air conditioner","Sum",1,{"v":65000,"d":"R65,000.00"},{"v":65000,"d":"R65,000.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["2.5.5",null,"Instrallation of vantilation in the storage container and air conditioner","Sum",1,{"v":25000,"d":"R25,000.00"},{"v":25000,"d":"R25,000.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["2.5.6",null,"MCC platform repairs","Sum",1,{"v":25000,"d":"R25,000.00"},{"v":25,"d":"R25.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
[]
[2.6,null,"PUMP STATION BUILDING "]
["2.6.1",null,"Repainting of internal walls ","m²",200,{"v":255,"d":"R255.00"},{"v":51000,"d":"R51,000.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H29-I29","v":{"v":0,"d":"0%"}},{"$f":"F29*H29","v":0},{"$f":"F29*I29","v":0},{"$f":"F29*J29","v":0}]
["2.6.2",null,"Repair of roof and sealing for any leaks","m²",80,{"v":105,"d":"R105.00"},{"v":8400,"d":"R8,400.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H30-I30","v":{"v":0,"d":"0%"}},{"$f":"F30*H30","v":0},{"$f":"F30*I30","v":0},{"$f":"F30*J30","v":0}]
["2.6.3",null,"Repair of floors  and aprons","m²",80,{"v":220,"d":"R220.00"},{"v":17600,"d":"R17,600.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H31-I31","v":{"v":0,"d":"0%"}},{"$f":"F31*H31","v":0},{"$f":"F31*I31","v":0},{"$f":"F31*J31","v":0}]
["2.6.4",null,"Repair of cable racks on the MCC wall","Sum",1,{"v":28963,"d":"R28,963.00"},{"v":28963,"d":"R28,963.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H32-I32","v":{"v":0,"d":"0%"}},{"$f":"F32*H32","v":0},{"$f":"F32*I32","v":0},{"$f":"F32*J32","v":0}]
[]
[null,null,"Note : Bidder will be required to provide cost breakdown for all sums and actual quantities in each certificate "]
[" Total Carried to Summary",{"$nulls":5},{"$f":"SUM(G4:G34)","v":{"v":825360,"d":"R825,360.00"}},{"$nulls":3},{"$f":"SUM(K4:K34)","v":{"v":11000,"d":"R11,000.00"}},{"$f":"SUM(L4:L34)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(M4:M34)","v":{"v":11000,"d":"R11,000.00"}}]

{"sheet":"Eskom Power Supply & Electrical","index":11,"n_rows":29,"n_cols":13,"rows_kept":29,"hidden":true,"merged":[[0,0,0,12],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[1,9,2,9],[1,10,2,10],[1,11,2,11],[1,12,2,12],[28,0,28,5]]}
["REFURBISHMENT AND COMMISSINING OF A 10 ML/DAY PACKAGE PLANT. "]
["ITEM NO","PAYMENT","DESCRIPTION.                       Tender no.: REFURBISHMENT AND COMMISSINING OF A 10 ML/DAY PACKAGE PLANT. ","UNIT","QTY","RATE","AMOUNT","QTY\nTO DATE","QTY\nPREVIOUS","QTY\nCURRENT","AMOUNT\nTO DATE","AMOUNT\nPREVIOUS","AMOUNT\nCURRENT"]
[]
[{"v":4,"d":"4.00"},null,"ESKOM CONNECTION & ELECTRICAL WORKS "]
[]
[4.1,null,"Recondition, Test and Commission - Pole Number STR/THA 180/30 Transformer 1250kVA; complete trasnformer test and reporting by nominated manufacturer. Bidder to include Eskom connection for live connection. ","SUM",1,{"v":425869,"d":"R425,869.00"},{"$f":"F6*E6","v":{"v":425869,"d":"R425,869.00"}},{"v":0.4,"d":"40%"},{"v":0,"d":"0%"},{"$f":"H6-I6","v":{"v":0.4,"d":"40%"}},{"$f":"F6*H6","v":{"v":170347.6,"d":"170,347.60"}},{"$f":"F6*I6","v":0},{"$f":"F6*J6","v":{"v":170347.6,"d":"170,347.60"}}]
[{"$nulls":9},{"$f":"H7-I7","v":0},{"$f":"F7*H7","v":0},{"$f":"F7*I7","v":0},{"$f":"F7*J7","v":0}]
["4.2 ",null,"Installation of incomer cable from Transfromer to KIOSK, complete with tags, cable markers  and lables","SUM",1,{"v":106800,"d":"R106,800.00"},{"$f":"F8*E8","v":{"v":106800,"d":"R106,800.00"}},{"v":1,"d":"100%"},{"v":0,"d":"0%"},{"$f":"H8-I8","v":{"v":1,"d":"100%"}},{"$f":"F8*H8","v":{"v":106800,"d":"106,800.00"}},{"$f":"F8*I8","v":0},{"$f":"F8*J8","v":{"v":106800,"d":"106,800.00"}}]
[{"$nulls":9},0,0,0,0]
["4.3",null,"Installation of incomer cable from Transfromer/Kiosk to MCC in the pump Station, complete with tags, cable markers  and lables","SUM",1,{"v":111523,"d":"R111,523.00"},{"v":111523,"d":"R111,523.00"},{"v":0.5,"d":"50%"},{"v":0,"d":"0%"},{"$f":"H10-I10","v":{"v":0.5,"d":"50%"}},{"$f":"F10*H10","v":{"v":55761.5,"d":"55,761.50"}},{"$f":"F10*I10","v":0},{"$f":"F10*J10","v":{"v":55761.5,"d":"55,761.50"}}]
[]
["4.4",null,"Schneider Electric masterpact NW 2000A ACB - fixed Pattern type ","No",1,{"v":88956,"d":"R88,956.00"},{"v":88956,"d":"R88,956.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H12-I12","v":{"v":0,"d":"0%"}},{"$f":"F12*H12","v":0},{"$f":"F12*I12","v":0},{"$f":"F12*J12","v":0}]
["4.5",null,"Busbar retrofit and installation of CB - Labour and materials","No",1,{"v":35600,"d":"R35,600.00"},{"v":35600,"d":"R35,600.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["4.6",null,"MVAA 21D1BA0797A - Relats for Bucholtz and temperature interference","No",1,{"v":42356,"d":"R42,356.00"},{"v":42356,"d":"R42,356.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["4.7",null,"Lightning protection","No",1,{"v":12300,"d":"R12,300.00"},{"v":12300,"d":"R12,300.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["4.8",null,"Installation of MVAA relays, cocntrol between TRF and MCC","No",2,{"v":16503,"d":"R16,503.00"},{"v":33006,"d":"R33,006.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["4.9",null,"Supply & iinstallation of power meter, complete with CCTs and fuse protection PM 5100","No",1,{"v":38956,"d":"R38,956.00"},{"v":38956,"d":"R38,956.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
["4.10",null,"Replace MCC with Softstarters for both the high lift pumps 350kW, complete with cables","No",2,{"v":446563,"d":"R446,563.00"},{"v":893126,"d":"R893,126.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},0,0,0]
[]
["4.11",null,"SCADA and PLC for both Automation and manual operation","Sum",1,{"v":167289,"d":"R167,289.00"},{"v":167289,"d":"R167,289.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H20-I20","v":{"v":0,"d":"0%"}},{"$f":"F20*H20","v":0},{"$f":"F20*I20","v":0},{"$f":"F20*J20","v":0}]
["4.12",null,"Programming of the entire plant for ease of monitoring and control by instrumentation Technician","Sum",1,{"v":88956,"d":"R88,956.00"},{"v":88956,"d":"R88,956.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H21-I21","v":{"v":0,"d":"0%"}},{"$f":"F21*H21","v":0},{"$f":"F21*I21","v":0},{"$f":"F21*J21","v":0}]
["4.13",null,"Power cables and communciation cables for actuators and sensors","Sum",1,{"v":223668,"d":"R223,668.00"},{"v":223668,"d":"R223,668.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H22-I22","v":{"v":0,"d":"0%"}},{"$f":"F22*H22","v":0},{"$f":"F22*I22","v":0},{"$f":"F22*J22","v":0}]
[]
["4.14",null,"Repiars and Reconditioniong of the electrical control container","Sum",1,{"v":18956,"d":"R18,956.00"},{"v":18956,"d":"R18,956.00"},{"v":0.1,"d":"10%"},{"v":0,"d":"0%"},{"$f":"H24-I24","v":{"v":0.1,"d":"10%"}},{"$f":"F24*H24","v":{"v":1895.6000000000001,"d":"1,895.60"}},{"$f":"F24*I24","v":0},{"$f":"F24*J24","v":{"v":1895.6000000000001,"d":"1,895.60"}}]
["4.15",null,"Replacement of level sensors and instruments ","Sum",1,{"v":88956,"d":"R88,956.00"},{"v":88956,"d":"R88,956.00"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"$f":"H25-I25","v":{"v":0,"d":"0%"}},{"$f":"F25*H25","v":0},{"$f":"F25*I25","v":0},{"$f":"F25*J25","v":0}]
["4.16",null,"Aerial Lighting around the site and lights in each container and pump station","Sum",1,{"v":28956,"d":"R28,956.00"},{"v":28956,"d":"R28,956.00"},{"v":0.2,"d":"20%"},{"v":0,"d":"0%"},{"$f":"H26-I26","v":{"v":0.2,"d":"20%"}},{"$f":"F26*H26","v":{"v":5791.200000000001,"d":"5,791.20"}},{"$f":"F26*I26","v":0},{"$f":"F26*J26","v":{"v":5791.200000000001,"d":"5,791.20"}}]
[]
[null,null,"Note : Bidder will be required to provide cost breakdown for all sums and actual quantities in each certificate "]
[" Total Carried Forward Summary",{"$nulls":5},{"$f":"SUM(G4:G28)","v":{"v":2405273,"d":"R2,405,273.00"}},{"$nulls":3},{"$f":"SUM(K4:K28)","v":{"v":340595.89999999997,"d":"340,595.90"}},{"$f":"SUM(L4:L28)","v":0},{"$f":"SUM(M4:M28)","v":{"v":340595.89999999997,"d":"340,595.90"}}]