{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Summary","S1 - P & G","S2 - Repairs to 560mm Pipeline","S3 -  Valve Chambers","OHS","Summary (FANIE)","P&G","Mechanical Works","Civil & General SIte  Works","Eskom Power Supply & Electrical"],"not_rendered":{"external_links":6,"defined_names":505},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"merged":[[1,0,1,2],[13,0,13,1],[15,0,15,1],[20,0,20,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1]]}
[]
["SUMMARY"]
["SECTION","DESCRIPTION","AMOUNT"]
[]
["SECTION 1","PRELIMINARY AND GENERAL"]
[]
["SECTION 2","REPAIRS TO 560MM RISING MAIN"]
[null,"SECTION 2A: EARTHWORKS (PIPE TRENCHES) - SANS 1200DB",{"$f":"'S2 - Repairs to 560mm Pipeline'!G56","v":0}]
[]
[null,"SECTION 2B:  MEDIUM PRESSURE PIPELINES - SANS 1200L",{"$f":"'S2 - Repairs to 560mm Pipeline'!G136","v":0}]
[]
["SECTION 3","VALVE CHAMBERS",{"$f":"'S3 -  Valve Chambers'!G111","v":0}]
[]
["[a] SUB-TOTAL 1 (SECTION 1+2+3)",null,{"$f":"SUM(C5:C12)","v":0}]
[]
["[b] COMPLIANCE WITH CIDB B.U.I.I.D STANDARDS"]
[null,"Allow Amount Contract Participation Goals (CPG) @ 5% of the Contract Amount [5% x (a)] =",{"$f":"C14*0.05","v":0}]
[]
[null,"Allow Amount Contract Skills Development Goals (CSDG) @ 0.25% of the Contract Amount [0.25% x (a)] =",{"$f":"C14*0.25/100","v":0}]
[]
["[c] SUB-TOTAL 2 (SUB-TOTAL 1 + CPG + CSDG)",null,{"$f":"SUM(C14:C19)","v":0}]
[]
["[d] CONTRACT PRICE ADJUSTMENT (CPA) (5% of [c])",null,{"$f":"C21*0.05","v":0}]
["[c] CONTINGENCIES (5% of [e])",null,{"$f":"C21*0.05","v":0}]
["[f] SUB-TOTAL 3 (c] + [d] + [e])",null,{"$f":"SUM(C21:C24)","v":0}]
[" [g] VAT (15% of [f])",null,{"$f":"C25*15%","v":0}]
["TOTAL CARRIED TO FORM OF OFFER AND ACCEPTANCE ([f] + [g])",null,{"$f":"C25+C26","v":0}]

{"sheet":"S1 - P & G","index":1,"n_rows":104,"n_cols":17,"rows_kept":104,"merged":[[0,0,0,6],[57,0,57,5],[58,0,58,5],[103,0,103,5]]}
["SECTION 1: PRELIMINARY & GENERAL -SANS 1200A / 1200AB"]
["ITEM\nNo","PAYMENT\nREF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[null,"SANS1200"]
["1.1","PSA 8.3","Scheduled Fixed-Time Charge & Value Related Items"]
["1.1.1","PSA 8.3.1","Fixed Preliminary and Genaral charges","Sum",{"v":1,"d":"1.00"}]
[null,"SANS 1200AB"]
["1.1.2","PSAB","Establishing Facilities for Engineer","Sum",{"v":1,"d":"1.00"}]
[]
[null,"SANS 1200A"]
[null,"8.3.2.2","Facilities for Contractor"]
["1.1.3","8.3.2.1 c)","Nameboards","Sum",{"v":1,"d":"1.00"}]
["1.1.4","a)","Offices and Storage Sheds","Sum",{"v":1,"d":"1.00"}]
["1.1.5","b)","Workshops","Sum",{"v":1,"d":"1.00"}]
["1.1.6","c)","Laboratories","Sum",{"v":1,"d":"1.00"}]
["1.1.7","d)","Living Accomodation","Sum",{"v":1,"d":"1.00"}]
["1.1.8","e)","Ablution and latrine facilities","Sum",{"v":1,"d":"1.00"}]
["1.1.9","f)","Tools and Equipment","Sum",{"v":1,"d":"1.00"}]
["1.1.10","PSA 8.3.2","Plant (All required plant for the duration of the project)","Sum",{"v":1,"d":"1.00"}]
["1.1.11","8.3.3","Other Fixed charge Obligations","Sum",{"v":1,"d":"1.00"}]
["1.1.12","8.3.4","Removal of Site Establishment","Sum",{"v":1,"d":"1.00"}]
[]
[null,"SANS 1200A"]
["1.2","PSA 8.4","Scheduled Time Related Items"]
["1.2.1","PSA 8.4.1","Time Related Preliminary and General charges","Sum",{"v":1,"d":"1.00"}]
["1.2.2","8.4.2.1","Facilities for Engineer","Sum",{"v":1,"d":"1.00"}]
["1.2.3","8.4.2.2","Facilities for Contractor"]
["1.2.4","a)","Offices and Storage Sheds","Sum",{"v":1,"d":"1.00"}]
["1.2.5","b)","Workshops","Sum",{"v":1,"d":"1.00"}]
["1.2.6","c)","Laboratories","Sum",{"v":1,"d":"1.00"}]
["1.2.7","d)","Living Accommodation","Sum",{"v":1,"d":"1.00"}]
["1.2.8","e)","Ablution & Latrines","Sum",{"v":1,"d":"1.00"}]
["1.2.9","f)","Tools and Equipment","Sum",{"v":1,"d":"1.00"}]
["1.2.10","g)","Water Suppliers, Electricity and Communications","Sum",{"v":1,"d":"1.00"}]
["1.2.11","h)","Dealing With Water","Sum",{"v":1,"d":"1.00"}]
["1.2.12","8.4.3","Supervision for Project Duration","Sum",{"v":1,"d":"1.00"}]
["1.2.13","8.4.4","Company Costs & Overheads","Sum",{"v":1,"d":"1.00"}]
["1.2.14","8.4.5","Other Time Related Obligations","Sum",{"v":1,"d":"1.00"}]
[]
["1.2.7","PSA 8.4.5.1","Supervision and Training of Nominated Sub-contractors","Sum",{"v":1,"d":"1.00"}]
["1.2.8","PSA 8.4.5.2","Salary for Labour Desk office and Community Liaison officer","Sum",{"v":1,"d":"1.00"}]
["1.2.9","PSA 8.4.5.3","Artisans and Skills accredited Training","Sum",{"v":1,"d":"1.00"},{"$nulls":8},"V.O. 1",{"$f":"#REF!","v":{"$error":"#REF!"}},"Biznet",{"v":1000000,"d":"R1,000,000.00"}]
["1.2.10","PSA 8.9","Full compliance wih the environmental management plan (EMP)","Sum",{"v":1,"d":"1.00"},{"$nulls":8},"V.O. 2",{"$f":"#REF!","v":{"$error":"#REF!"}},"Aubrey",{"v":300000,"d":"R300,000.00"}]
["1.2.11","PSA 8.8","Full Compliance with all Health and Safety regulations and specifications","Sum",{"v":1,"d":"1.00"},{"$nulls":8},"V.O. 3",{"$f":"#REF!","v":{"$error":"#REF!"}},"Aubrey",{"v":300000,"d":"R300,000.00"}]
["1.3","PSA 8.5","Sums Stated Provisionally by Engineer",{"$nulls":11},{"$f":"SUM(O41:O43)","v":{"$error":"#REF!"}},null,{"$f":"SUM(Q41:Q43)","v":{"v":1600000,"d":"R1,600,000.00"}}]
["1.3.1","PSA 8.5.1","Cellular communications and data bundles","Prov Sum",{"v":1,"d":"1.00"},{"v":24000,"d":"R24,000.00"},{"$f":"E45*F45","v":{"v":24000,"d":"R24,000.00"}}]
["1.3.2","PSA 8.5.1","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":45000,"d":"R45,000.00"},{"$f":"E46*F46","v":{"v":45000,"d":"R45,000.00"}}]
["1.3.3","PSA 8.6 (a)","Relocation of Existing Services (inclusive all Discussions, Liaison, Labour and Material)","Prov Sum",{"v":1,"d":"1.00"},{"$f":"G47","v":{"v":150000,"d":"R150,000.00"}},{"v":150000,"d":"R150,000.00"}]
["1.3.6","PSA 8.6 (b)","Percentage (%) mark-up on item 1.3.1 to 1.3.3 above for Contractor's overheads, administration charges and profit","%",null,{"$f":"SUM(F45:F47)","v":{"v":219000,"d":"R219,000.00"}},{"$f":"F48*E48/100","v":0}]
[]
["1.4","PSA 8.6","Prime Cost Sums"]
["1.4.1","PSA 8.6 (a)","Community Liaison Officers (CLO)","PC Sum",{"v":1,"d":"1.00"},{"v":360000,"d":"R360,000.00"},{"$f":"F51*E51","v":{"v":360000,"d":"R360,000.00"}}]
["1.4.2","PSA 8.6 (a)","Construction Specialist Services (On instruction by LNW)","PC Sum",{"v":1,"d":"1.00"},{"v":1000000,"d":"R1,000,000.00"},{"$f":"F52","v":{"v":1000000,"d":"R1,000,000.00"}}]
["1.4.3","PSA 8.6 (b)","Percentage (%) mark-up on item 1.4.1 to 1.4.2 above for Contractor's overheads, administration charges and profit","%",null,{"$f":"SUM(F51:F52)","v":{"v":1360000,"d":"R1,360,000.00"}},{"$f":"F53*E53/100","v":0}]
[]
["1.5",null,"Allowance for Contractor's Designs & Construction Drawings"]
["1.5.1",null,"Contractor to allow for Contractor's Designs and Construction Drawings inc Shop Drawings for the entire project, c/w sign off by a registered professional with a valid Professional Indemnity. ","Sum",{"v":1,"d":"1.00"},null,{"$f":"F56*E56","v":0}]
[]
["Carried Forward"]
[" Brought Forward",{"$nulls":5},{"$f":"G58","v":0}]
[]
["1.6","PSA 8.7","(a) Day Works Using The Contractor's Labour force"]
["1.6.1",null,"1.  Labourer","hour",{"v":200,"d":"200.00"},null,{"$f":"F62*E62","v":0}]
["1.6.2",null,"2.  Driver","hour",{"v":200,"d":"200.00"},null,0]
["1.6.3",null,"3.  Operator","hour",{"v":200,"d":"200.00"},null,0]
["1.6.4",null,"4.  Artisan","hour",{"v":200,"d":"200.00"},null,0]
["1.6.5",null,"5.  Welder","hour",{"v":200,"d":"200.00"},null,0,null,{"$f":"4069.92+4069.92+4069.92","v":12209.76},{"$f":"2543.7+2543.7+2543.7","v":{"v":7631.099999999999,"d":"7,631.10"}},{"$f":"I66+J66","v":{"v":19840.86,"d":"19,840.86"}},{"$f":"K66/F66","v":{"$error":"#DIV/0!"}}]
["1.6.6",null,"6.  Foreman","hour",{"v":200,"d":"200.00"},null,0,null,{"$f":"10162.38+10162.38+10162.38","v":30487.14},{"$f":"6251.48+6351.48+6351.48","v":{"v":18954.44,"d":"18,954.44"}},{"v":49441.58,"d":"49,441.58"},{"$f":"K67/F67","v":{"$error":"#DIV/0!"}}]
["1.6.7",null,"7.  Security Guard","day",{"v":200,"d":"200.00"},null,0,{"$nulls":3},0,{"$f":"K68/F68","v":{"$error":"#DIV/0!"}}]
["1.6.8",null,"Medicals entry & Exit ","SUM",{"v":1,"d":"1.00"},null,0]
["1.6.9",null,"PPE","SUM",{"v":1,"d":"1.00"},null,0]
["1.6.10",null,"Training ","SUM",{"v":1,"d":"1.00"},null,0]
[]
["1.7","PSA 8.7","(b)  Day Works Using Contractor's Plant",{"$nulls":3},0,{"$nulls":3},0]
["1.7.1",null,"1.  Ldv (1 ton)","hour",{"v":200,"d":"200.00"},null,0,null,6057.6,{"v":3786,"d":"3,786.00"},{"v":9843.6,"d":"9,843.60"},{"$f":"K74/F74","v":{"$error":"#DIV/0!"}}]
["1.7.2",null,"2.  Flat Truck (3 to 5 ton)","hour",{"v":50,"d":"50.00"},null,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["1.7.3",null,"3.  Tip Truck (10m3)","hour",{"v":50,"d":"50.00"},null,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["1.7.4",null,"4. Backhoe ","hour",{"v":50,"d":"50.00"},null,0,null,36961.27,{"v":23100.79,"d":"23,100.79"},{"v":60062.06,"d":"60,062.06"},{"$error":"#DIV/0!"}]
["1.7.5",null,"4. Backhoe ","hour",{"v":50,"d":"50.00"},null,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["1.7.6",null,"5.  Trench Vibrating Roller","hour",{"v":50,"d":"50.00"},null,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["1.7.7",null,"7.  Air compressor, including all tools (Drills, Jackhammers, etc)","hour",{"v":50,"d":"50.00"},null,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["1.7.8",null,"8.  Pump, including all Necessary Hosing and Pipes","hour",{"v":200,"d":"200.00"},null,0,null,1003.36,{"v":627.1,"d":"627.10"},{"v":1630.46,"d":"1,630.46"},{"$error":"#DIV/0!"}]
["1.7.9",null,"9.  Concrete Mixer","hour",{"v":20,"d":"20.00"},null,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["1.7.10",null,"10.  Water Truck (10 000 L)","hour",{"v":50,"d":"50.00"},null,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["1.7.11",null,"11. Welding Machine","hour",{"v":200,"d":"200.00"},null,0,null,5666.28,{"v":3541.43,"d":"3,541.43"},{"v":9207.71,"d":"9,207.71"},{"$error":"#DIV/0!"}]
["1.7.12",null,"12. Flood Lights","hour",{"v":200,"d":"200.00"},null,0,null,2520,{"v":1575,"d":"1,575.00"},{"v":4095,"d":"4,095.00"},{"$error":"#DIV/0!"}]
["1.7.13",null,"13. Staff Bus","hour",{"v":200,"d":"200.00"},null,0]
{"$rows_empty":17}
["Total Section 1 Carried to Summary"]

{"sheet":"S2 - Repairs to 560mm Pipeline","index":2,"n_rows":136,"n_cols":7,"rows_kept":136,"merged":[[0,0,0,6],[1,0,1,6],[55,0,55,5],[57,0,57,6],[93,0,93,5],[97,0,97,6],[135,0,135,5]]}
["SECTION 2: WORKS TO 560MM PIPELINE"]
["SECTION 2A: EARTHWORKS (PIPE TRENCHES) - SANS 1200DB"]
["ITEM\nNo","PAYMENT\nREF","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["A1","8.3.1","Site Clearance"]
["A1.1","8.3.1 (a)","Clear Vegetation and Trees of Girth Up to 1m (4m  Wide Strip)","m",{"v":9520,"d":"9,520.00"},null,{"$f":"F5*E5","v":0}]
["A1.2","8.3.1 (b)","Clear Trees of Girth Over 1,0 m and Designated Obstacles","No",{"v":9,"d":"9.00"},null,{"$f":"F6*E6","v":0}]
["A1.3","PSDB.            8.3.1 (c)","Remove topsoil (strip to 150 mm Deep x 1.5m wide), Stockpile, Prevent Dust Nuisance and Reinstate on Upon Completion","m²",{"v":7000,"d":"7,000.00"},null,{"$f":"F7*E7","v":0}]
["A2","8.3.2","Excavation",{"$nulls":3},0]
[null,"8.3.2 (a)","Excavate in all Materials for Trenches, Backfill, Compact and Dispose of Surplus Material with Depth Over and Up to:",{"$nulls":3},0]
["A2.1",null,"        1.0 m          2.0 m","m3",{"v":12000,"d":"12,000.00"},null,0]
["A2.2",null,"        2.0 m          3.0 m","m3",{"v":4000,"d":"4,000.00"},null,0]
[]
[null,"PSDB.            8.3.2","Extra-over Item (a) above for:",{"$nulls":3},0]
["A2.6","8.3.2 (b) (2)","Hard Rock Excavation","m³",{"v":100,"d":"100.00"},null,0]
["A2.7","PSDB.            8.3.2","Excavate and Dispose of Boulders Class A","m³",{"v":50,"d":"50.00"},null,0]
["A2.8","8.3.2 (c)","Excavate and Dispose of Unsuitable Material From Trench Bottom (provisional)","m³",{"v":100,"d":"100.00"},null,0]
["A3","8.3.3","Excavation ancillaries",{"$nulls":3},0]
[null,"8.3.3.1","Make Up Deficiency in Backfill Material (provisional)",{"$nulls":3},0]
["A3.1","a)","From Other Necessary Excavations On Site","m³",{"v":500,"d":"500.00"},null,0]
[null,"8.3.3.3.","Compaction in Road Reserves",{"$nulls":3}," "]
["A3.2",null,"Under roadways to 93% MOD AASHTO","m³",{"v":100,"d":"100.00"},null,0]
[]
["A4","8.3.5","Existing Services that intersect or adjoin Pipe Trench",{"$nulls":3},0]
["A4.1","8.3.5 (a)","Services That intersect a Trench",{"$nulls":3},0]
["A4.1.1",null,"1)    Stock Fences","No",{"v":5,"d":"5.00"},null,0]
["A4.1.2",null,"2)    Storm Water Pipes","No",{"v":1,"d":"1.00"},null,{"$f":"F26*E26","v":0}]
["A4.1.3",null,"3)    Water Pipes","No",{"v":2,"d":"2.00"},null,0]
["A4.1.4",null,"4)    Overhead Electrical Lines","No",{"v":3,"d":"3.00"},null,0]
["A4.1.5",null,"5)    Overhead Telephone Lines","No",{"v":2,"d":"2.00"},null,0]
["A4.1.6",null,"6)    Gravel Roads","No",{"v":5,"d":"5.00"},null,0]
["A4.2","8.3.5 (b)","Services That adjoin a Trench",{"$nulls":3},0]
["A4.2.1",null,"1)    Stock Fence","m",{"v":1000,"d":"1,000.00"},null,0]
["A4.2.2",null,"2)    Water / Storm Water Pipes","m",{"v":9500,"d":"9,500.00"},null,{"$f":"F33*E34","v":0}]
["A4.2.3",null,"3)    Overhead Electrical Lines","m",{"v":1000,"d":"1,000.00"},null,{"$f":"F34*E35","v":0}]
["A4.2.4",null,"4)    Overhead Telephone Lines","m",{"v":30,"d":"30.00"},null,0]
[]
["A5","8.3.6","Finishing",{"$nulls":3},0]
["A5.1","8.3.6.1","Reinstate Road Surfaces Complete",{"$nulls":3},0]
["A5.1.1","8.3.6.1 (a)","Gravel Road Surfaces","m²",{"v":100,"d":"100.00"},null,0]
["A5.1.2","8.3.6.1 (b)","Tarred Road Surfaces (30mm thick)","m²",{"v":20,"d":"20.00"},null,0]
[]
["A6","PSDB 8.3.7","Accommodation of traffic including bypass and signage","Sum",{"v":1,"d":"1.00"},null,0]
{"$rows_empty":13}
["SECTION 2A CARRIED TO SUMMARY :  EARTHWORKS (PIPE TRENCHES) - SANS 1200DB",{"$nulls":5},{"$f":"SUM(G5:G50)","v":0}]
[]
["SECTION 2B:   PIPELINES - SANS 1200L"]
[]
["B1",null,"Pipeline Section Replacement"]
["B1.1","8.2.1","Steel Pipes"]
["B1.1.1",null,"Supply, Lay, Bed, Join and Test 560 ND / 6 mm Wall Thickness Grade X42   Steel Pipes,  Pipes are to be continously Welded with Coating and Lining as per PSCL Specifications","m",{"v":2000,"d":"2,000.00"},null,{"$f":"F62*E62","v":0}]
[]
["B1.2","8.2.2","Steel Bends",{"$nulls":3},0]
["B1.2.1",null,"Extra-Over for Item B1.1.1 to Supply, Lay, Join, Test and Bed 560 mm ND / 6 mm Wall Thickness Grade X42 Steel Bends with Lining and Coating as per specifications. ",{"$nulls":3},0]
["B1.2.1.1",null,"0º - 5º","No",{"v":8,"d":"8.00"},null,0]
["B1.2.1.2",null,"5º - 15º","No",{"v":5,"d":"5.00"},null,0]
["B1.2.1.3",null,"15º - 45º","No",{"v":5,"d":"5.00"},null,0]
["B1.2.1.4",null,"45º - 60º","No",{"v":5,"d":"5.00"},null,0]
["B1.2.1.5",null,"60º - 90º","No",{"v":5,"d":"5.00"},null,0]
[]
["B2",null,"Pipeline Repairs"]
["B2.1",null,"Pipe Pieces"]
["B2.1.1",null,"Supply, Lay, Join, Test and Bed  560 mm ND / 6 mm Wall Thickness Grade X42 straight Steel pipe piece, 750mm long, c/w stacker rings welded either end (Stackers = 584mm O/D x 10mm thisck x 50mm wide) both ends suitable for welding to replace the couplings with Lining and Coating as per PSCL specifications. Pipe pieces to be specially manufactured to specifed size before delivery to site, ordering a longer section and cutting on site will not be accepted. "]
["B2.1.1.1",null,"750mm Long, Pipe Pieces (560mm ND ), with factory welded stacker rings, 10mm thick x 50mm Wide","No",{"v":1100,"d":"1,100.00"}]
["B2.1.1.2",null,"Stacker Rings, 584 O/D x 6mm thick x 100mm wide (to be weld on existing pipe on site)","No",{"v":2200,"d":"2,200.00"}]
["B2.1.1.3",null,"Site Weld Sleeves\\collar, 598mm O/D x 6mm Thick x 100mm wide","No",{"v":2200,"d":"2,200.00"}]
[]
["B3",null,"Cut-in and Connect to Existing Water infrastructure within Stipulated Time Frame including all Pipework as Specified. Inclusive for both Start and End points.","Sum",{"v":1,"d":"1.00"}]
[]
["B4",null,"Radiographic Examination and Testing of Pipe Welded  Joints","No",{"v":250,"d":"250.00"}]
[]
["B5",null,"Provide Pipeline Markers along The Pipeline Route","No",{"v":10,"d":"10.00"}]
{"$rows_empty":10}
["SECTION 2B CARRIED TO SUMMARY :  PIPELINES  - SANS 1200L",{"$nulls":5},{"$f":"SUM(G62:G78)","v":0}]
[]
[]
[]
["SECTION 2C:   BEDDING - SANS 1200LB"]
[]
["C1","8.2.1","Provision of Bedding from Trench Excavation"]
["C1.1",null,"a) Selected granular material","m³",{"v":100,"d":"100.00"},null,{"$f":"F101*E101","v":0}]
["C1.2",null,"b) Selected fill material","m³",{"v":600,"d":"600.00"},null,0]
[]
["C2","8.2.2","Supply only of Bedding By Importation"]
["B1.2.1","8.2.2.3","From Commercial Sources"]
["B1.2.1.1",null,"a)    Selected Granular Material","m³",{"v":3300,"d":"3,300.00"},null,{"$f":"F106*E106","v":0}]
["B1.2.1.2",null,"b)    Selected Fill Material","m³",{"v":100,"d":"100.00"},null,0]
{"$rows_empty":28}
["SECTION 2B CARRIED TO SUMMARY :  BEDDING  - SANS 1200LB",{"$nulls":5},{"$f":"SUM(G102:G117)","v":0}]

{"sheet":"S3 -  Valve Chambers","index":3,"n_rows":111,"n_cols":7,"rows_kept":111,"merged":[[0,0,0,6],[53,0,53,5],[54,0,54,5],[110,0,110,5]]}
["SECTION 3: VALVE CHAMBERS"]
["B4",null,"VALVE CHAMBERS"]
["B4.1",null,"Demolition of Existing Chambers"]
["B4.1.1",null,"Demolish Air Valve Chambers Servicing 560mm Pipeline, incl safe disposal of rubble","No",{"v":15,"d":"15.00"},null,{"$f":"F4*E4","v":0}]
["B4.1.2",null,"Demolish Air Isolation Valve & Non Return Valve Chambers Servicing 560mm Pipeline, incl safe disposal of rubble","No",{"v":4,"d":"4.00"},null,{"$f":"F5*E5","v":0}]
[]
["B4.2",null,"New Air Valve Chambers"]
["B4.2.1",null,"Air Valve Chamber - PN25, Complete as Shown on TYPICAL DRAWING , Construction shop drawing to be finalised by Contractor. Construct Chambers around the pipe, Complete including Excavation, Reinforcement and Concrete Work, Supply Material and install Air Vents, access Ladders, relevant typical drawings attached as a guide, for The Following: Chamber depth = Fixed at 2m","No",{"v":17,"d":"17.00"},null,{"$f":"F8*E8","v":0}]
["B4.2.2",null,"Extra Over B.4.2.1 for Pipe Specials as Per Typical drawing LNW 08/25/26 -AVC-01, final drawing to be finalised with Contractor,for Supply and installation of Air Valve Chamber pipeworks and specials"]
["B4.2.2.1","PSPM","AV 1: 560mm X 350mm Unequal Tee, PN25","No",{"v":17,"d":"17.00"},null,{"$f":"F10*E10","v":0}]
["B4.2.2.2","PSPM","AV 2: 350mm Blank Flange with 150mm drilled opening  with a 150mm Flanged Pipe Section,PN25","No",{"v":17,"d":"17.00"},null,{"$f":"F11*E11","v":0}]
["B4.2.2.3","PSVA","AV 3:  150mm RSV Gate Valve,PN25 ","No",{"v":17,"d":"17.00"},null,0]
["B4.2.2.4","PSVA","AV 4:  150mm Air Valve, PN25","No",{"v":17,"d":"17.00"},null,0]
["B4.2.2.5","PSPM","AV 4: 560mm Flanged Pipe Section, 1500mm Long, PN25","No",{"v":17,"d":"17.00"},null,0]
["B4.2.2.6","PSPM","AV 5: 560mm Straight pipe, both ends suitable for welding, with Paddle Flange, PN25","No",{"$f":"E10*2","v":{"v":34,"d":"34.00"}},null,0]
[]
["B4.3",null,"Scour Valve Chambers"]
["B4.3.1",null,"Scour Valve Chamber for PN25, Construct Chambers Complete including Excavation, Reinforcement and Concrete Work, Supply Material and install Air Vents, access Ladders, for The Following: Chamber depth = 3m","No",{"v":3,"d":"3.00"},null,0]
["B4.3.2",null,"Extra Over B4.3.1 for Pipe Specials for The Scour Valve Chamber"]
["B4.3.2.1","PSPM","CSV 1: 560mm X 350mm Unequal Tee, PN25","No",{"v":3,"d":"3.00"},null,0]
["B4.3.2.2","PSPM","CSV 2: 350mm NB Straight Section, both ends flanged with Paddle flange, PN25","No",{"v":3,"d":"3.00"},null,0]
["B4.3.2.3","PSVA","CSV 3:   350mm Wedge Gate Valve, PN25","No",{"v":3,"d":"3.00"},null,{"$f":"F22*E22","v":0}]
["B4.3.2.4","PSVA","CSV 4:  350mm Dismantling Coupling, PN25","No",{"v":3,"d":"3.00"},null,0]
["B4.3.2.5","PSPM","CSV 5:  350mm Straight Pipe paddle Flange, both ends flanged, PN25","No",{"v":3,"d":"3.00"},null,0]
["B4.3.2.6","PSPM","CSV 6:  560mm ND Existing Straight pipe Section","No",{"v":1,"d":"1.00"},null,0]
[]
["B4.4",null,"Isolation Valve Chambers"]
["B4.4.1",null,"Isolation Valve Chamber for PN25, Construct Chambers Complete including Excavation, Reinforcement and Concrete Work, Supply Material and install Air Vents, access Ladders, for The Following: Chamber depth = 3.3m","No",{"v":3,"d":"3.00"},null,0]
["B4.4.2",null,"Extra Over B4.4.1 for Pipe Specials as Per Drawing 'LNW 08/25/26-IVC-03 for The Isolation Valve Chamber Supply and install the following"]
["B4.4.2.1","PSPM","IV 1:  560mm ND Straight Section, flanged one end, and weld on the other with Paddle flange, PN25","No",{"v":6,"d":"6.00"},null,0]
["B4.4.2.2","PSPM","IV 2:  560mm X 560mm  x 100mm Unequal Tee, All ends Flanged, PN25","No",{"v":6,"d":"6.00"},null,0]
["B4.4.2.3","PSVA","IV 3: 550mm Butterfly Isolation Valve, PN25","No",{"v":3,"d":"3.00"},null,0]
["B4.4.2.4","PSVA","IV 4:  560mm Dismantling Joint, PN25","No",{"v":3,"d":"3.00"},null,0]
["B4.4.2.5","PSPM","IV 5:   100mm Medium Radius Bend, PN25","No",{"v":6,"d":"6.00"},null,0]
["B4.4.2.6","PSVA","IV 6:  100mm Wedge Gate Valve, PN25","No",{"v":3,"d":"3.00"},null,0]
["B4.4.2.7","PSVA","IV 7:  100mm Dismantling Joint, PN25","No",{"v":3,"d":"3.00"},null,0]
["B4.4.2.8","PSPM","IV 8:   100mm ND Straight Pipe Section, PN25","No",{"v":3,"d":"3.00"},null,0]
[]
["B4.5",null,"Non Return Valve Chamber"]
["B4.5.1",null,"Non Return Valve Chamber for PN25, Construct Chambers Complete including Excavation, Reinforcement and Concrete Work, Supply Material and install Air Vents, access Ladders, for The Following: Chamber depth = 3.3m","No",{"v":1,"d":"1.00"},null,{"$f":"F40*E40","v":0}]
["B4.5.2",null,"Extra Over B4.5.1 for Pipe Specials Non Return Valve Chamber Supply and install the following"]
["B4.5.2.1","PSPM","560mm ND Straight Section, flanged one end, and weld on the other with paddle flange","No",{"v":2,"d":"2.00"},null,{"$f":"F42*E42","v":0}]
["B4.5.2.2","PSVA","560mm Nozzle Type Non Return Valve ","No",{"v":1,"d":"1.00"},null,0]
["B4.5.2.3","PSVA","560mm Dismantling Joint","No",{"v":1,"d":"1.00"},null,0]
[]
["B4.6",null,"Other Valve Chambers"]
["B4.6.1",null,"Relocation of PMC Juction (Junction 42) with all its valves and fittings to a new location, away from the wetland, including connections of all pipelines ","Prov Sum",{"v":1,"d":"1.00"},{"v":6000000,"d":"R6,000,000.00"},{"v":1000000,"d":"R1,000,000.00"}]
["B4.6.2",null,"New Pre-cast ring manhole for the Airvalve near the Phalaborwa WTP Guard House","Prov Sum",{"v":1,"d":"1.00"},{"v":350000,"d":"R350,000.00"},{"v":1000000,"d":"R1,000,000.00"}]
["B4.6.3",null,"Allow for overheads,  charges and profits on item B4.6.1 to B4.6.2 above","%"]
[]
[]
[]
[]
["Carried Forward"]
["Brought Forward"]
[]
["B4.7",null,"Refurbishment of Existing Valve Chambers (Those not being demolished)"]
["B4.7.1",null,"Refurbishment of existing valves at Phalaborwa 560 Pipelineincluding the required modification of the pipe fittings","Prov Sum",{"v":1,"d":"1.00"},{"v":1000000,"d":"R1,000,000.00"},{"v":1000000,"d":"R1,000,000.00"}]
[null,null,"Allow for overheads,  charges and profits on item B4.7.1 above","%"]
[]
["B4.8",null,"Anchor, Thrust Blocks, Plinths and Pedestals"]
["B4.8.1",null,"Concrete Grade 15/19","m³",{"v":30,"d":"30.00"},null,{"$f":"F62*E62","v":0}]
["B4.8.2",null,"Formwork (rough Vertical)","m2",{"v":120,"d":"120.00"},null,0]
["B4.8.3",null,"Steel Mesh Ref No 100","m2",{"v":100,"d":"100.00"},null,0]
[]
["B4.9",null,"General"]
["B4.9.1",null,"Provide Pipeline Markers along The Pipeline Route","No",{"v":50,"d":"50.00"},null,{"$f":"F67*E67","v":0}]
["B4.9.2",null,"Radiographic Examination and Testing of Pipe Welded  Joints","No",{"v":200,"d":"200.00"},null,0]
{"$rows_empty":42}
["Total Section 3 Carried to Summary"]

{"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":"Summary (FANIE)","index":5,"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":6,"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":7,"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":8,"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":9,"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"}}]