{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["BOQ Summary","SUMMARY","P&G - Section 1","Site Clearance - Section 2","Earthworks - Section 3","Bedding - Section 4","Medium Pressure - Section 5","Pipe Fittings - Section 6","Valves - Section 7","Pumpstations - Section 8","Tanks - Section 9","Miscellaneous - Section 10"],"not_rendered":{"defined_names":22,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"BOQ Summary","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"hidden":true,"merged":[[4,0,4,2],[6,0,9,0],[6,1,9,1],[6,2,9,2]]}
[{"$f":"'P&G - Section 1'!A1","v":"UMKHANYAKUDE DISTRICT MUNICIPALITY"}]
[{"$f":"'P&G - Section 1'!A2","v":"NONDABUYA WSS PHASES 2 & 3"}]
[{"$f":"'P&G - Section 1'!A3","v":"CONTRACT No.:"}]
[]
["SUMMARY OF SECTIONS "]
[]
["SECTION","DESCRIPTION","AMOUNT (RAND)"]
[]
[{"$nulls":3},"Tendered","Varience"]
[]
[]
[1,{"$f":"'P&G - Section 1'!G5","v":"SECTION 1:  PRELIMINARY AND GENERAL"},{"$f":"'P&G - Section 1'!G168","v":0},{"v":2927200,"d":"R2,927,200.00"},{"$f":"C12-D12","v":{"v":-2927200,"d":"-R2,927,200.00"}}]
[{"$nulls":4},{"$f":"C13-D13","v":0}]
[2,{"$f":"'Site Clearance - Section 2'!G5","v":"SECTION 2 : SITE CLEARANCE"},{"$f":"'Site Clearance - Section 2'!G39","v":0},{"v":469625,"d":"R469,625.00"},{"v":-469625,"d":"-R469,625.00"}]
[{"$nulls":4},0]
[3,{"$f":"'Earthworks - Section 3'!G5","v":"SECTION 3 : EARTHWORKS"},{"$f":"'Earthworks - Section 3'!G86","v":0},{"v":5593657.98,"d":"R5,593,657.98"},{"v":-5593657.98,"d":"-R5,593,657.98"}]
[{"$nulls":4},0]
[4,{"$f":"'Bedding - Section 4'!G5","v":"SECTION 4 : BEDDING"},{"$f":"'Bedding - Section 4'!G50","v":0},{"v":2097070.12,"d":"R2,097,070.12"},{"v":-2097070.12,"d":"-R2,097,070.12"}]
[{"$nulls":4},0]
[5,{"$f":"'Medium Pressure - Section 5'!G5","v":"SECTION 5 : MEDIUM PRESSURE PIPELINES"},{"$f":"'Medium Pressure - Section 5'!G54","v":0},{"v":7189956,"d":"R7,189,956.00"},{"v":-7189956,"d":"-R7,189,956.00"}]
[{"$nulls":4},0]
[6,{"$f":"'Pipe Fittings - Section 6'!G5","v":"SECTION 6 : PIPE FITTINGS AND SPECIALS"},{"$f":"'Pipe Fittings - Section 6'!G171","v":0},{"v":938549.29,"d":"R938,549.29"},{"v":-938549.29,"d":"-R938,549.29"}]
[{"$nulls":4},0]
[7,{"$f":"'Valves - Section 7'!G5","v":"SECTION 7 : VALVES AND CHAMBERS"},{"$f":"'Valves - Section 7'!G50","v":0},{"v":1403556.34,"d":"R1,403,556.34"},{"v":-1403556.34,"d":"-R1,403,556.34"}]
[{"$nulls":4},0]
[8,{"$f":"'Pumpstations - Section 8'!G5","v":"SECTION 8 : PUMP STATIONS"},{"$f":"'Pumpstations - Section 8'!G19","v":0},{"v":7255250,"d":"R7,255,250.00"},{"v":-7255250,"d":"-R7,255,250.00"}]
[{"$nulls":4},0]
[9,{"$f":"'Tanks - Section 9'!G5","v":"SECTION 9 : PREFABRICATED STEEL TANKS"},{"$f":"'Tanks - Section 9'!G51","v":0},{"v":4539325.3,"d":"R4,539,325.30"},{"v":-4539325.3,"d":"-R4,539,325.30"}]
[10,"A SUB-TOTAL",{"$f":"SUM(C11:C28)-0.001","v":{"v":-1E-3,"d":"R(0.00)"}},{"$f":"SUM(D12:D28)","v":{"v":32414190.03,"d":"R32,414,190.03"}},{"$f":"C29-0.0001","v":{"v":-0.0011,"d":"-R0.00"}}]
[11,"B CONTINGENCIES (Add 5% of Sub-Total C)",{"$f":"C29*5%","v":{"v":-5e-05,"d":"R(0.00)"}}]
[12,"C SUB-TOTAL (A+B)",{"$f":"SUM(C29:C30)","v":{"v":-0.00105,"d":"R(0.00)"}}]
[13,"D VALUE ADDED TAX (Add 15 % of Sub-Total E)",{"$f":"0.15*C31","v":{"v":-1.5749999999999998E-4,"d":"R(0.00)"}}]
[14,"E TOTAL CARRIED TO FORM OF OFFER AND ACCEPTANCE (E+F)",{"$f":"C32+C31","v":{"v":-1.2074999999999998E-3,"d":"R(0.00)"}}]
[]
[null,null,{"v":32414190.03,"d":"R32,414,190.03"}]
[null,"Diff",{"$f":"C29-C35","v":{"v":-32414190.031,"d":"-R32,414,190.03"}}]

{"sheet":"SUMMARY","index":1,"n_rows":22,"n_cols":6,"rows_kept":22,"merged":[[4,0,4,4]]}
[{"$f":"'P&G - Section 1'!A1","v":"UMKHANYAKUDE DISTRICT MUNICIPALITY"}]
[{"$f":"'P&G - Section 1'!A2","v":"NONDABUYA WSS PHASES 2 & 3"}]
[{"$f":"'P&G - Section 1'!A3","v":"CONTRACT No.:"}]
[]
["SUMMARY OF SECTIONS "]
["SECTION","DESCRIPTION","ESTIMATE AMOUNT (PHASE 2)","ESTIMATE AMOUNT (PHASE 3)","AMOUNT"]
[1,{"$f":"'P&G - Section 1'!G5","v":"SECTION 1:  PRELIMINARY AND GENERAL"},{"$f":"'P&G - Section 1'!#REF!","v":{"$error":"#REF!"}},{"$f":"'P&G - Section 1'!#REF!","v":{"$error":"#REF!"}}]
[2,{"$f":"'Site Clearance - Section 2'!G5","v":"SECTION 2 : SITE CLEARANCE"},{"$f":"'Site Clearance - Section 2'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Site Clearance - Section 2'!#REF!","v":{"$error":"#REF!"}}]
[3,{"$f":"'Earthworks - Section 3'!G5","v":"SECTION 3 : EARTHWORKS"},{"$f":"'Earthworks - Section 3'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Earthworks - Section 3'!#REF!","v":{"$error":"#REF!"}}]
[4,{"$f":"'Bedding - Section 4'!G5","v":"SECTION 4 : BEDDING"},{"$f":"'Bedding - Section 4'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Bedding - Section 4'!#REF!","v":{"$error":"#REF!"}}]
[5,{"$f":"'Medium Pressure - Section 5'!G5","v":"SECTION 5 : MEDIUM PRESSURE PIPELINES"},{"$f":"'Medium Pressure - Section 5'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Medium Pressure - Section 5'!#REF!","v":{"$error":"#REF!"}}]
[6,{"$f":"'Pipe Fittings - Section 6'!G5","v":"SECTION 6 : PIPE FITTINGS AND SPECIALS"},{"$f":"'Pipe Fittings - Section 6'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Pipe Fittings - Section 6'!#REF!","v":{"$error":"#REF!"}}]
[7,{"$f":"'Valves - Section 7'!G5","v":"SECTION 7 : VALVES AND CHAMBERS"},{"$f":"'Valves - Section 7'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Valves - Section 7'!#REF!","v":{"$error":"#REF!"}}]
[8,{"$f":"'Pumpstations - Section 8'!G5","v":"SECTION 8 : PUMP STATIONS"},{"$f":"'Pumpstations - Section 8'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Pumpstations - Section 8'!#REF!","v":{"$error":"#REF!"}}]
[9,{"$f":"'Tanks - Section 9'!G5","v":"SECTION 9 : PREFABRICATED STEEL TANKS"},{"$f":"'Tanks - Section 9'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Tanks - Section 9'!#REF!","v":{"$error":"#REF!"}}]
[10,"SUB-TOTAL (A)",{"$f":"SUM(C7:C15)","v":{"$error":"#REF!"}},{"$f":"SUM(D7:D15)","v":{"$error":"#REF!"}}]
[11,"Add: Contingencies @ 5%",{"$f":"C16*0.05","v":{"$error":"#REF!"}},{"$f":"D16*0.05","v":{"$error":"#REF!"}}]
[12,"SUB-TOTAL (B): DIRECT COSTS - CONSTRUCTION",{"$f":"SUM(C16:C17)","v":{"$error":"#REF!"}},{"$f":"SUM(D16:D17)","v":{"$error":"#REF!"}}]
[13,"Add - 15% VAT",{"$f":"#REF!*0.15","v":{"$error":"#REF!"}},{"$f":"#REF!*0.15","v":{"$error":"#REF!"}}]
[14,"TOTALS CARRIED TO FORM OF TENDER",{"$f":"#REF!+C19","v":{"$error":"#REF!"}},{"$f":"#REF!+D19","v":{"$error":"#REF!"}},null,{"$f":"87000000*1.2","v":{"v":104400000,"d":"R104,400,000.00"}}]
[]
[null,"% of P&Gs",{"$f":"C7/C16","v":{"$error":"#REF!"}},{"$f":"D7/D16","v":{"$error":"#REF!"}},{"$f":"E7/E16","v":{"$error":"#DIV/0!"}}]

{"sheet":"P&G - Section 1","index":2,"n_rows":168,"n_cols":7,"rows_kept":168,"merged":[[0,0,0,2],[5,0,5,6],[46,0,46,5],[48,0,48,5],[90,0,90,5],[92,0,92,5],[127,0,127,5],[129,0,129,5],[167,0,167,3]]}
["UMKHANYAKUDE DISTRICT MUNICIPALITY"]
["NONDABUYA WSS PHASES 2 & 3"]
["CONTRACT No.:","SCMU 001/2026/2027"]
[]
[{"$nulls":6},"SECTION 1:  PRELIMINARY AND GENERAL"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[1,"SANS  1200 A","PRELIMINARY AND GENERAL"]
[]
["1.1",8.3,"Scheduled Fixed-Charge and Value-Related Items"]
[]
["1.1.1","8.3.1","Contractual Requirements","Sum",1]
[{"$nulls":4},""]
[null,null,"Provision for the site facilities:",null,""]
[{"$nulls":4},""]
["1.1.2","8.3.2.1 ","a) Facilities for the Engineer ",null,""]
[{"$nulls":4},""]
["1.1,3",null,"Survey equipment","Sum",1]
[{"$nulls":4},""]
["1.1.4",null,"Resident Engineer : Provision of data for site purposes","Sum",1]
[{"$nulls":4},""]
["1.1.5",null,"As-built data collection by profesional surveyor","Sum",1]
[{"$nulls":4},""]
["1.1.6",null,"2 x Name Boards (as per drawing)","Sum",4]
[{"$nulls":4},""]
["1.1.7","8.3.2.2","b) Facilities for the Contractor ",null,""]
[{"$nulls":4},""]
["1.1.8",null,"Supply and erection of 2 x Parkhome offices (6mx3m open plan Bolt Modular Parkhome or similar, as approved by the Engineer), storage sheds, workshops, ablution and latrine facilities, tools and equipment, water supplies, electric power, communications, access and fencing (The office to have at least two work stations of a table and three chairs each)","Sum",2]
["1.1.9",null,"Dealing with water generally on site and at river crossings","Sum",1]
[{"$nulls":4},""]
["1.1.10","8.3.4","Removal of site establishment on completion of the project","Sum",2]
[{"$nulls":4},""]
["1.1.11",null,"Accommodation of traffic and road crossings","Sum",1]
[{"$nulls":4},""]
["1.1.12",null,"As built drawings and operating and maintenance manuals","Sum",1]
[{"$nulls":4},""]
["1.1.13",null,"Provision of access to properties during construction","Sum",1]
[{"$nulls":4},""]
["1.1.14","PSA","Compliance with the OHS Act regulations (Rate to include for risk assessment specific to the COVID-19 Ependemic and other adjustments to ensure compliance for the assignment  including maintenance of a register  for  workers contacts, Provision of PPE & other H&S matters)","Sum",1]
["1.1.16",null,"Preparation of a OHS Plan","Sum",1]
[{"$nulls":4},""]
[null,null,"Costs of medical  certificate and Medical Surveillance including Screenings for  Employees with COVID-19Symptoms",null,""]
[{"$nulls":4},""]
["1.1.17",null,"Allowance for Health and Safety Officer (24 Months)","Sum",1]
[{"$nulls":4},"",null,""]
["Carried Forward"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["Brought Forward"]
[]
["1.2","8.4","SCHEDULED TIME-RELATED ITEMS ",null,"",null,""]
[{"$nulls":4},"",null,""]
["1.2.1","8.4.1","Contractual requirements and operating and maintaining facilities on site",null,"",null,""]
[{"$nulls":4},"",null,""]
[null,"8.4.2","Facilities for the Engineer-",null,"",null,""]
[{"$nulls":4},"",null,""]
["1.2.2",null,"a) Nameboards (2No) (Refer to Drawing)","No.",18]
[{"$nulls":4},""]
["1.2.3",null,"b) Survey assistants and materials","No.",18]
[{"$nulls":4},""]
["1.2.5","8.4.3","Facilities for the Contractor-",null,""]
[{"$nulls":4},""]
["1.2.6",null,"Offices, storage sheds, workshops, living accommodation, ablution and latrine facilities, tools and equipment, water supplies, electric power, communications, access and plant","No",18]
[{"$nulls":4},""]
["1.2.7",null,"Dealing with water generally on site and at river crossings","No",18]
[]
["1.2.8",null,"Accommodation of traffic and road crossings","No",18]
[]
["1.2.9",null,"Provision of access to properties during construction","No",18]
[]
["1.2.10","8.4.6","Updating and amending the risk assessments, safe work procedures, the project H&S File, the H&S plan, the provision of PPE and protective clothing and any other H&S matters that the contractor deems necessary","No",18]
[]
["1.2.11",null,"Allowance for Health and Safety Officer (24 Months)","No",18]
[]
["1.2.12","8.4.4","Supervision for duration of construction","No",18]
[{"$nulls":4},""]
["1.2.13","8.4.5","Company and head office overhead costs for the duration of the contract","No",18]
[]
["1.2.14",null,"24-hour security/ watchmen/woman on site","No",18]
[]
["1.3",null,"SUMS STATED PROVISIONALLY BY THE ENGINEER"]
[]
["1.3.1","PSA3","Employment of CLO for the duration of the Contract (R14500 pm plus R500 pm cellphone allowance) over 20 months","Prov. Sum",1,{"v":300000,"d":"R300,000.00"},{"v":300000,"d":"R300,000.00"}]
[]
["1.3.2",null,"Contractors markup on item 1.3.1","%",{"v":300000,"d":"R300,000.00"}]
[]
["1.3.3",null,"Payment of PSC members for attendance of meetings for the duration of the contract (8 No members per Ward over the five (5) Wards at R750 per member per meeting) over 12 months (Contractor's programme to ensure that no work within a ward exceeds 12-months)","Prov. Sum",1,{"v":360000,"d":"R360,000.00"},{"v":360000,"d":"R360,000.00"}]
[]
["1.3.4",null,"Contractors markup on item 1.3.3","%",{"v":360000,"d":"R360,000.00"}]
[{"$nulls":6},""]
["Carried Forward"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["Brought Forward"]
[]
["1.3.5",null,"Empowerment of local personnel through skills development and skills transfer by an accredited trainer/service provider to be appointed or nominated by client.","Prov Sum",1,{"v":70000,"d":"R70,000.00"},{"v":70000,"d":"R70,000.00"}]
[]
["1.3.6",null,"Contractors markup on item 1.3.5","%",{"v":70000,"d":"R70,000.00"}]
[]
["1.3.7",null,"Provisional sum for conforming with the requirements of EPWP","Prov Sum",1,{"v":48000,"d":"R48,000.00"},{"v":48000,"d":"R48,000.00"}]
[]
["1.3.8",null,"Contractors markup on item 1.3.7","%",{"v":48000,"d":"R48,000.00"}]
[]
["1.3.9",null,"Additional tests ordered by the Engineer","Prov Sum",1,{"v":100000,"d":"R100,000.00"},{"v":100000,"d":"R100,000.00"}]
[]
["1.3.10",null,"Contractors markup on item 1.3.9","%",{"v":100000,"d":"R100,000.00"}]
[]
["1.3.11",null,"Allow provisional sum for Water Treatment Works Process Engineer Specialist appointed by the Engineer"," Prov Sum",1,{"v":150000,"d":"R150,000.00"},{"v":150000,"d":"R150,000.00"}]
[]
["1.3.12",null,"Contractors markup on item 1.3.11","%",{"v":150000,"d":"R150,000.00"}]
[]
["1.3.13",null,"Allow provisional sum for Electromechanical Specialist appointed by the Engineer"," Prov Sum",1,{"v":250000,"d":"R250,000.00"},{"v":250000,"d":"R250,000.00"}]
[]
["1.3.14",null,"Contractors markup on item 1.3.13","%",{"v":250000,"d":"R250,000.00"}]
[{"$nulls":6},""]
["1.3.15",null,"Allow provisional sum for environmental rehabilitation at specific locations by a selected sub contractor"," Prov Sum",1,{"v":70000,"d":"R70,000.00"},{"v":70000,"d":"R70,000.00"}]
[]
["1.3.16",null,"Contractors markup on item 1.3.15","%",{"v":70000,"d":"R70,000.00"}]
[]
["1.3.17",null,"Provisional Sum for the provision of adequately armed security personnel together with 4x2 vehicle - Sourced and dedicated to the Engineer and paid for by the Contractor through the Engineer over 20 months"," Prov Sum",1,{"v":451100,"d":"R451,100.00"},{"v":451100,"d":"R451,100.00"}]
[]
["1.3.18",null,"Contractors markup on item 1.3.17","%",{"v":451100,"d":"R451,100.00"}]
[]
["1.3.19",null,"Allowance for removal and disposal of existing works complete and make good as directed by engineer"," Prov Sum",1,{"v":50000,"d":"R50,000.00"},{"v":50000,"d":"R50,000.00"}]
[]
["1.3.20",null,"Contractors markup on item 1.3.19","%",{"v":50000,"d":"R50,000.00"}]
[]
["1.3.21",null,"Allowance for water testing of pipelines complete and make good as directed by engineer (2 fillings)"," Prov Sum",1,{"v":100000,"d":"R100,000.00"},{"v":100000,"d":"R100,000.00"}]
["Carried Forward"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["Brought Forward"]
[]
["1.3.22",null,"Contractors markup on item 1.3.21","%",{"v":100000,"d":"R100,000.00"}]
[]
["1.3.23",null,"Allowance for compensating landowners for crop damage due to construction"," Prov Sum",1,{"v":100000,"d":"R100,000.00"},{"v":100000,"d":"R100,000.00"}]
[]
["1.3.24",null,"Contractors markup on item 1.3.23","%",{"v":100000,"d":"R100,000.00"}]
[]
[null,null,"Temporary Works"]
[]
["1.3.33",null,"Maintain all roads where construction activities will take place","Prov. Sum",1,{"v":200000,"d":"R200,000.00"},{"v":200000,"d":"R200,000.00"}]
[]
["1.3.34",null,"Contractors markup on item 1.3.33","%",{"v":200000,"d":"R200,000.00"}]
[{"$nulls":4},""]
["1.4","8.7","Dayworks",null,""]
[{"$nulls":4},""]
["1.4.1",null,"Foreman ","hr",60]
[{"$nulls":4},""]
["1.4.2",null,"Skilled ","hr",60]
[{"$nulls":4},""]
["1.4.3",null,"Semi-skilled ","hr",100]
[".",{"$nulls":3},""]
["1.4.4",null,"Unskilled ","hr",100]
[{"$nulls":4},""]
[null,"8.7","Plant",null,""]
[{"$nulls":4},""]
[null,null,"T L B","hr",60]
[{"$nulls":4},""]
[null,null,"Light Delivery Vehicle (1t or equialent)","hr",60]
[{"$nulls":4},""]
[null,null,"10Ton crane truck","hr",60]
[{"$nulls":4},""]
[null,null,"Generator set","hr",60]
[{"$nulls":4},""]
[null,null,"Plate compactor","hr",60]
[{"$nulls":4},""]
[]
[]
[" Total Carried Forward To Summary"]

{"sheet":"Site Clearance - Section 2","index":3,"n_rows":39,"n_cols":7,"rows_kept":39,"merged":[[5,0,5,6],[38,0,38,3]]}
["UMKHANYAKUDE DISTRICT MUNICIPALITY"]
["NONDABUYA WSS"]
["CONTRACT No.:","SCMU 001/2026/2027"]
[]
[{"$nulls":6},"SECTION 2 : SITE CLEARANCE"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[2,"SANS 1200 C & PSC","SITE CLEARANCE "]
[]
[2.1,null,"CLEAR SITE"]
[]
["2.1.1    ","8.2.1  ","Clear and grub vegetation in strip 2m wide on pipe route. Rate to include for trees of girth up to and including 1m.","m",160444]
[]
["2.1.2    ","8.2.2 ","Where instructed remove and grub large trees and tree stumps of girth:"]
[]
["2.1.2.1  ","8.2.2(a)","over 1m and up to 2m.                            ","No",60]
[{"$nulls":4},""]
[{"$nulls":4},""]
["2.1.3",null,"Excavation of trial holes 1,0 m x 1,0 m x 0,8 m deep as ordered","No",40]
[{"$nulls":4},""]
["2.1.4",null,"Remove and reinstate fences parallel to pipeline (fences comprising up to 3 strands wire/barbed wire or disjointed timber slats to be included in the normal rate for excavation)","m",2000]
[{"$nulls":4},""]
["2.1.5","PSC 8.2.13","Remove existing gravel layer works to stockpile and maintain (for use as selected layers) as instructed by the Engineer.",null,""]
[{"$nulls":4},""]
["2.1.5.1",null,"Gravel layer works to District Roads.               ","m³",560]
[{"$nulls":4},""]
["2.1.5.2",null,"Fill material","m³",0]
[{"$nulls":4},""]
["2.1.5.3",null,"Relocation of existing fences","m",4000]
[{"$nulls":4},""]
["2.1.5.4",null,"Working adjacent to existing services (stormwater pipes, stormwater v-drains, water pipes and electricaL and telecommunication services)","m",300]
[{"$nulls":4},""]
["2.1.5.5",null,"Working parallel to existing services (stormwater pipes, stormwater v-drains, water pipes and electrica and telecommunication services)","No",40]
[]
[]
[]
[]
[" Total Carried Forward To Summary"]

{"sheet":"Earthworks - Section 3","index":4,"n_rows":86,"n_cols":7,"rows_kept":86,"merged":[[5,0,5,6],[51,0,51,5],[53,0,53,5],[85,0,85,3]]}
["UMGENI - UTHUKELA WATER"]
["NONDABUYA WSS"]
["CONTRACT No.:","SCMU 001/2026/2027"]
[]
[{"$nulls":6},"SECTION 3 : EARTHWORKS"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[3,"SANS 1200 D  & 200 DB","PIPE TRENCHES, MINOR EARTHWORKS & TRENCHES"]
[]
[3.1,"PSDB 8.3.2","Excavation"]
["3.1.1","8.3.2(a)","Excavate in all materials for trenches, backfill, compact, and dispose of surplus/unsuitable material for pipes:"]
[]
[null,null,"Excavate by hand in confined areas for pipe trenches or to locate and expose existing services where ordered by the Engineer"]
[]
["3.1.1.1",null,"Up to and including 200mm ND for total trench depth:"]
[]
["3.1.1.1.1",null,"Exceeding 0,0m but not exceeding 1.5m","m³",{"$error":"#REF!"}]
[{"$nulls":4},""]
["3.1.1.1.2",null,"Extra over item for 3.1.1.1.1 for Intermediate rock","m³",{"$error":"#REF!"}]
[{"$nulls":4},""]
["3.1.1.1.3",null,"Extra over item for 3.1.1.1.1 for hard rock","m³",{"$error":"#REF!"}]
[{"$nulls":4},""]
["3.1.1.1.4",null,"Extra over item for 3.1.1.1.1 for bolder excavation","m³",{"$error":"#REF!"}]
[{"$nulls":4},""]
["3.2",null,"Slope Protection (Provisional)",null,""]
[{"$nulls":4},""]
["3.2.1",null,"Earth diversion berms as instructed by the Engineer","No",30]
[{"$nulls":4},""]
[3.3,null,"Excavate in all materials beyond the limits of pipe trenches for thrust walls, valve chambers, anchor blocks where ordered by the Engineer:",null,""]
[{"$nulls":4},""]
[null,null,"Over       and     up to ",null,""]
[{"$nulls":4},""]
["3.3.1",null,"0,0 m                1,0 m","m³",18]
[{"$nulls":4},""]
["3.3.2",null,"1,0 m                1,5 m","m³",21]
[{"$nulls":4},""]
[3.4,"SABS 1200DK","Gabions and Pitching",null,""]
[{"$nulls":4},""]
["3.4.1","8.2.1 (a)","Surface preparation - cavities filled with excavated material","m²",24]
[{"$nulls":4},""]
["3.4.2","8.2.2","Gabions:",null,""]
[{"$nulls":4},""]
["3.4.2.1",null,"2 m x 1 m x 1 m boxes","m³",10]
[{"$nulls":4},""]
["3.4.2.2",null,"2 m x 2 m x 0,23 m boxes","m³",10]
[{"$nulls":4},""]
["3.4.2.3","8.2.4","Geotexile where ordered","m²",40]
[{"$nulls":4},""]
["3.4.2.4","8.2.5","Ordinary stone pitching ","m²",40]
[{"$nulls":4},"",null,""]
[]
["Carried Forward"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["Brought Forward"]
[3.5,"8.2.5 (a)","Services that Intersect a Trench:",null,"",null,""]
[{"$nulls":4},"",null,""]
["3.5.1",null,"Stormwater pipes up to 450 mm dia","Nº",6]
[3.6,null,"Telkom and electric cables (underground) (no additional payment will be made for overhead telephone lines or poles)","Nº",6]
[{"$nulls":4},""]
[3.7,"8.3.5 (b)","Services that adjoin a trench:",null,""]
[{"$nulls":4},""]
["3.7.1",null,"Stormwater pipes up to 450 mm dia","m",100]
[{"$nulls":4},""]
[null,null,"Telkom cables (underground) (no additional payment will be made for overhead telephone lines or poles)","m",200]
[{"$nulls":4},""]
[null,"8.3.5","EO Items B.3.3 for excavating, backfilling, compacting and reinstating trenches parallel to and within 1,0 m from: (rates to incl. for reinstating if damaged in any way by the Contractor): ",null,""]
[{"$nulls":4},""]
[null,null,"Wire fences","m",400]
[{"$nulls":4},""]
[null,null,"EO Items B.3.3 for excavating, backfilling, compacting and reinstating trenches crossing beneath (rates to incl. for reinstating if damaged in any way by the Contractor):",null,""]
[{"$nulls":4},""]
[null,null,"Wire fences","Nº",40]
[]
[null,null,"Excavation across gravel roads"]
[]
[null,null,"Selective excavation in all materials for trenches, backfill with stabilised 5% cement, compact and dispose of surplus material for trenches under gravel roads for pipes up to 300mm diameter (only one half of the road is to be opened at any one time)"]
[]
[null,null,"1,5m - 2.0m","m",240]
{"$rows_empty":7}
[" Total Carried Forward To Summary"]

{"sheet":"Bedding - Section 4","index":5,"n_rows":50,"n_cols":7,"rows_kept":50,"merged":[[5,0,5,6],[49,0,49,3]]}
["UMGENI - UTHUKELA WATER"]
["NONDABUYA WSS"]
["CONTRACT No.:","SCMU 001/2026/2027"]
[]
[{"$nulls":6},"SECTION 4 : BEDDING"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[4,"SANS 1200 LB & PS LB","BEDDING "]
[]
[4.1,"8.2.1 & PS LB 3.1","Provision of Bedding from Trench Excavation"]
[]
["4.1.1","8.2.1 (a)","Selected granular material","m³",{"v":15727.276800000003,"d":"15727"}]
[{"$nulls":4},""]
["4.1.2","8.2.1 (b)","Selected fill material","m³",{"v":15727.276800000003,"d":"15727"}]
[{"$nulls":4},""]
[4.2,"8.2.2","Supply only of Bedding by Importation",null,""]
[{"$nulls":4},""]
["4.2.1","8.2.2.1","From other necessary excavations ",null,""]
[null,null,"(Provisional)",null,""]
[{"$nulls":4},""]
["4.2.1.1","8.2.2.1 (a)","Selected granular material","m³",{"v":7863.638400000002,"d":"7863.6"}]
[{"$nulls":4},""]
["4.2.1.2","8.2.2.1 (b)","Selected fill material","m³",{"v":7863.638400000002,"d":"7863.6"}]
[{"$nulls":4},""]
["4.2.2","8.2.2.3","From Commercial sources",null,""]
[{"$nulls":4},""]
["4.2.2.1","8.2.2.3 (a)","Selected granular material","m³",{"v":2621.2128000000007,"d":"2621.2"}]
[{"$nulls":4},""]
["4.2.2.2","8.2.2.3 (b)","Selected fill material","m³",{"v":2621.2128000000007,"d":"2621.2"}]
[{"$nulls":4},""]
[4.3,"8.2.3","Concrete Bedding Cradle (Provisional) ",null,""]
[{"$nulls":4},""]
["4.3.1",null,"15/19 Grade concrete","m³",{"v":0,"d":"0.0"}]
[{"$nulls":4},""]
[4.4,"8.2.4","Encasing of Pipes in Concrete (Provisional)",null,""]
[{"$nulls":4},""]
["4.4.1",null,"Encasement of Pipe in 25/19 Grade concrete including all formwork and reinforcement (100kg steel per m3 conctrete) for water crossings and road crossings.  Refer to standard detail ","m³",10]
[{"$nulls":4},""]
[4.5,"8.2.4","Thrust Blocks",null,""]
[{"$nulls":4},""]
["4.5.1",null,"Construct thrust blocks in 25/19 Grade concrete including all preparation work and formwork required. Refer to standard detail","m³",75]
[{"$nulls":4},""]
[4.6,"8.2.5","Overhaul of Material for Bedding Cradle and Selected Fill Blanket (Provisional)","m³/km",3000]
[]
[]
[]
[]
[]
[" Total Carried Forward To Summary"]

{"sheet":"Medium Pressure - Section 5","index":6,"n_rows":54,"n_cols":14,"rows_kept":54,"merged":[[5,0,5,6],[53,0,53,3]]}
["UMGENI - UTHUKELA WATER"]
["NONDABUYA WSS"]
["CONTRACT No.:","SCMU 001/2026/2027"]
[]
[{"$nulls":6},"SECTION 5 : MEDIUM PRESSURE PIPELINES"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[5,"SANS 1200 L","MEDIUM PRESSURE PIPELINES "]
[]
[5.1,"8.2.1","Supply, lay, backfill, disinfect, join and test potable water pipelines. All works inclusive in the rate, except where specific items are provided. All activites in accordance with project specifications.:"]
[]
[null,null,"HDPE Pipes"]
[{"$nulls":11},"Dia.","Ph 2","Ph 3"]
["5.1.1",null,"25mm dia. PN 12","m",{"v":305736.8,"d":"305737"},{"$nulls":6},50,{"v":40283.36769421108,"d":"40283"},{"v":52671.81323370107,"d":"52672"}]
[{"$nulls":11},63,{"v":6229.031915595916,"d":"6229"},{"v":7417.874211552028,"d":"7418"}]
["5.1.2",null,"50 mm dia. PN 12","m",97603,{"$nulls":6},75,{"v":2792.626408297436,"d":"2793"},{"v":6940.336600442442,"d":"6940"}]
[{"$nulls":4},"",{"$nulls":6},90,{"v":3274.292704087867,"d":"3274"},{"v":9295.870699742683,"d":"9296"}]
["5.1.3",null,"63 mm dia. PN 12","m",{"v":14329,"d":"14,329"},{"$nulls":6},110,{"v":1883.1335565346485,"d":"1883"},{"v":8435.614972061907,"d":"8436"}]
[{"$nulls":4},"",{"$nulls":6},160,{"v":7882.413791213208,"d":"7882"},{"v":5698.2409528520375,"d":"5698"}]
["5.1.4",null,"75 mm dia. PN 12","m",{"v":10219,"d":"10,219"},{"$nulls":6},200,0,68]
[{"$nulls":4},"",{"$nulls":6},300,0,0]
["5.1.5",null,"90 mm dia. PN 12","m",{"v":13199,"d":"13,199"},{"$nulls":7},62344.86606994015,90527.75067035216]
[{"$nulls":4},""]
[null,null,"PVC-U Pipes",null,""]
[{"$nulls":4},""]
[{"$nulls":4},""]
["5.1.6",null,"110mm dia. CL 12 uPVC","m",{"v":10834,"d":"10,834"}]
[{"$nulls":4},""]
["5.1.7",null,"160mm dia. CL 12 uPVC","m",{"v":14260,"d":"14,260"}]
[{"$nulls":4},""]
[5.2,"PSL 8.2.16","Pipeline Markers as per standard detail.  Work to be executed by a nominated SMME sub contractor","No",1765]
[{"$nulls":4},""]
["5.3.1",null,"Supply and install standpipe as per drawing UKDM-0056-08complete including HDPE saddle, 32mm HDPE pipe (20m), tap and galvanised riser pipe, concrete work including shuttering, elbows, nipples, etc, as per standard drawings. Work to be executed by a nominated SMME sub contractor","No",4706]
[{"$nulls":4},""]
["5.4",null,"Thrust Blocks",null,""]
[{"$nulls":4},""]
["5.4.1",null,"Construct anchor/thrust blocks to Drawing No. UKDM-0057-01",null,""]
[null,null,"For tees, end caps and 90 degree bends:",null,""]
[{"$nulls":4},""]
["5.4.1.1",null,"50mm Diameter","No",18]
[{"$nulls":4},""]
["5.4.1.2",null,"63mm Diameter","No",38]
[{"$nulls":4},""]
["5.4.1.3",null,"75mm Diameter","No",14]
[{"$nulls":4},""]
["5.4.1.4",null,"90mm Diameter","No",30]
[{"$nulls":4},""]
[]
["5.4.1.5",null,"110mm Diameter","No",18]
[{"$nulls":4},""]
["5.4.1.6",null,"160mm Diameter","No",16]
[{"$nulls":4},""]
["5.4.1.7",null,"200mm Diameter","No",3]
[" Total Carried Forward To Summary"]

{"sheet":"Pipe Fittings - Section 6","index":7,"n_rows":171,"n_cols":7,"rows_kept":171,"merged":[[5,0,5,6],[63,0,63,5],[65,0,65,5],[121,0,121,5],[123,0,123,5],[170,0,170,3]]}
["UMGENI - UTHUKELA WATER"]
["NONDABUYA WSS"]
["CONTRACT No.:","SCMU 001/2026/2027"]
[]
[{"$nulls":6},"SECTION 6 : PIPE FITTINGS AND SPECIALS"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[null,"SANS 1200 L","PIPE FITTINGS AND SPECIALS "]
[]
[null,"8.2.2                                PSL 8.2.4 PSL 8.2.5","Extra-over 8.2.1 for the Supplying, Laying and Bedding of Specials complete with Couplings as follows:-"]
[]
[5.2,"8.2.4                                       PSL 8.2.6","Supply, lay, joint and bed including cutting pipes where required for the following:"]
[]
[null,null,"HDPE Pipe Bends (PN 16)"]
[]
["5.2.1",null,"50mm dia. x 22.5° bends.","No.",87]
[{"$nulls":4},""]
["5.2.2",null,"50mm dia. x 45° bends.","No.",77]
[{"$nulls":4},""]
["5.2.3",null,"50mm dia. x 90° bends.","No.",113]
[{"$nulls":4},""]
["5.2.4",null,"63mm dia. x 22.5° bends.","No.",9]
[{"$nulls":4},""]
["5.2.5",null,"63mm dia. x 45° bends.","No.",12]
[{"$nulls":4},""]
["5.2.6",null,"63mm dia. x 90° bends.","No.",29]
[{"$nulls":4},""]
["5.2.7",null,"75mm dia. x 22.5° bends.","No.",30]
[{"$nulls":4},""]
["5.2.8",null,"75mm dia. x 45° bends.","No.",50]
[{"$nulls":4},""]
["5.2.9",null,"75mm dia. x 90° bends.","No.",0]
[{"$nulls":4},""]
["5.2.10",null,"90mm dia. x 22.5° bends.","No.",46]
[{"$nulls":4},""]
["5.2.11",null,"90mm dia. x 45° bends.","No.",32]
[{"$nulls":4},""]
["5.2.12",null,"90mm dia. x 90° bends.","No.",8]
[{"$nulls":4},""]
[null,null,"uPVC Pipe Bends (PN 16)"]
[]
["5.2.13",null,"110mm dia. x 22.5° bends.","No.",8]
[{"$nulls":4},""]
["5.2.14",null,"110mm dia. x 45° bends.","No.",11]
[{"$nulls":4},""]
["5.2.13",null,"110mm dia. x 90° bends.","No.",27]
[{"$nulls":4},""]
["5.2.14",null,"160mm dia. x 22.5° bends.","No.",2]
[{"$nulls":4},""]
["5.2.15",null,"160mm dia. x 45° bends.","No.",19]
[{"$nulls":4},""]
["5.2.16",null,"160mm dia. x 90° bends.","No.",15]
[{"$nulls":4},""]
["5.2.17",null,"200mm dia. x 22.5° bends.","No.",7]
[{"$nulls":4},""]
["5.2.18",null,"200mm dia. x 45° bends.","No.",8]
[{"$nulls":4},""]
["5.2.19",null,"300mm dia. x 22.5° bends.","No.",8]
[{"$nulls":4},""]
["5.2.20",null,"300mm dia. x 45° bends.","No.",8]
[{"$nulls":4},""]
["5.2.20a",null,"300mm dia. x 90° bends.","No.",8]
[]
["Carried Forward"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["Brought Forward"]
[]
[null,null,"Socketed Reducers (PN16)",null,""]
[{"$nulls":4},""]
["5.2.21",null,"63mm x 50mm","No.",50]
[{"$nulls":4},""]
["5.2.22",null,"75mm x 50 mm","No.",6]
[{"$nulls":4},""]
["5.2.23",null,"75mm x 63mm","No.",8]
[{"$nulls":4},""]
["5.2.24",null,"90mm x 50mm","No.",10]
[{"$nulls":4},""]
["5.2.25",null,"90mm x 63 mm","No.",24]
[{"$nulls":4},""]
["5.2.26",null,"90mm x 75mm","No.",36]
[{"$nulls":4},""]
["5.2.27",null,"110mm x 63mm","No.",10]
[{"$nulls":4},""]
["5.2.28",null,"110mm x 75mm","No.",10]
[{"$nulls":4},""]
["5.2.29",null,"110mm x 90mm","No.",14]
[{"$nulls":4},""]
["5.2.30",null,"160mm x 90mm","No.",6]
[{"$nulls":4},""]
["5.2.31",null,"160mm x 110mm","No.",2]
[{"$nulls":4},""]
["5.2.32",null,"200mm x 160mm","No.",4]
[{"$nulls":4},""]
[null,null,"Equal Tees (PN16)",null,""]
[{"$nulls":4},""]
["5.2.33",null,"50mm x 50mm","No.",36]
[{"$nulls":4},""]
["5.2.34",null,"63mm x 50mm","No.",20]
[{"$nulls":4},""]
["5.2.35",null,"63mm x 63mm","No.",40]
[{"$nulls":4},""]
["5.2.36",null,"75mm x 50mm","No.",24]
[{"$nulls":4},""]
["5.2.37",null,"75mm x 63mm","No.",12]
[{"$nulls":4},""]
["5.2.38",null,"75mm x 75mm","No.",18]
[{"$nulls":4},""]
["5.2.39",null,"90mm x 63mm","No.",50]
[{"$nulls":4},""]
["5.2.40",null,"90mm x 75mm","No.",10]
[]
["5.2.41",null,"90mm x 90mm","No.",26]
[{"$nulls":4},""]
["5.2.42",null,"110mm x 63mm","No.",18]
[{"$nulls":4},""]
["5.2.43",null,"110mm x 75mm","No.",2]
[{"$nulls":4},""]
["5.2.44",null,"110mm x 90mm","No.",18]
[{"$nulls":4},""]
["5.2.45",null,"110mm x 110mm","No.",10]
[]
["Carried Forward"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
["Brought Forward"]
["5.2.46",null,"160mm x 63mm","No.",14]
[{"$nulls":4},""]
["5.2.47",null,"160mm x 90mm","No.",10]
[{"$nulls":4},""]
["5.2.47",null,"160mm x 90mm","No.",4]
[{"$nulls":4},""]
["5.2.48",null,"160mm x 110mm","No.",20]
[{"$nulls":4},""]
["5.2.49",null,"160mm x 160mm","No.",10]
[{"$nulls":4},""]
["5.2.50",null,"200mm x 110mm","No.",4]
[{"$nulls":4},""]
["5.2.51",null,"200mm x 200mm","No.",2]
[{"$nulls":4},""]
[null,null,"Couplings (PN16)",null,""]
[{"$nulls":4},""]
["5.2.52",null,"40mm dia","No.",16]
[{"$nulls":4},""]
["5.2.53",null,"50mm dia","No.",20]
[{"$nulls":4},""]
["5.2.54",null,"63mm dia","No.",24]
[{"$nulls":4},""]
["5.2.55",null,"90mm dia","No.",32]
[{"$nulls":4},""]
["5.2.56",null,"110mm dia","No.",14]
[{"$nulls":4},""]
[null,null,"End Plugs (PN16)",null,""]
[{"$nulls":4},""]
["5.2.57",null,"50 mm dia, end plug (Class 16)","No",24]
[{"$nulls":4},""]
["5.2.58",null,"63 mm dia end plug (Class 16)","No",2]
[{"$nulls":4},""]
["5.2.59",null,"75 mm dia end plug (Class 16)","No",2]
[{"$nulls":4},""]
[null,null,"Flanged Adaptors",null,""]
[{"$nulls":4},""]
["5.2.60",null,"50 mm dia - flanged adaptor with galvinised backing ring","No",26]
[{"$nulls":4},""]
["5.2.61",null,"63 mm dia - Flanged adaptor with galvanised backing ring","No",16]
[{"$nulls":4},""]
["5.2.62",null,"90 mm dia - Flanged adaptor with galvanised backing ring Flange Table 1600/3\"","No",22]
[{"$nulls":4},""]
["5.2.63",null,"Allowance for installation of Bulk Meters at reservoir outlets and DMAs as per Drg Nond_001","Sum",2]
["5.2.64",null,"150mm diameter","No",1]
[]
["5.2.65",null,"100mm diameter","No",3]
[" Total Carried Forward To Summary"]

{"sheet":"Valves - Section 7","index":8,"n_rows":50,"n_cols":7,"rows_kept":50,"merged":[[5,0,5,6],[49,0,49,3]]}
["UMGENI - UTHUKELA WATER"]
["NONDABUYA WSS"]
["CONTRACT No.:","SCMU 001/2026/2027"]
[]
[{"$nulls":6},"SECTION 7 : VALVES AND CHAMBERS"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[7,null,"VALVES "]
[]
[null,"8.2.3","Extra-over 8.2.1 for the supplying, fixing and Bedding of Valves as indicated below:"]
[]
["7.1",null,"Isolation Valves Complete with Protective Chamber"]
[]
["7.1.1","PSL 3.13.2","Supply and install flanged Resilient seal  Gate valves complete with prefabricated  valve chamber as per drawing UKDM-0057-05, PN 16 with non-rising spindle, Clockwise closing, including all gaskets, bolts, nuts and washers as per detailed drawings","No."]
[]
["7.1.1.1",null,"50mm diameter","No.",9]
[]
["7.1.1.2",null,"63mm diameter","No.",3]
[]
["7.1.1.3",null,"75mm diameter","No.",8]
[]
["7.1.1.4",null,"90mm diameter","No.",10]
[]
["7.1.1.5",null,"110mm diameter","No.",6]
[]
["7.1.1.6",null,"160mm diameter","No.",2]
[]
["7.1.1.7",null,"200mm diameter","No.",3]
[]
["7.2",null,"Air Valves Complete with Protective Chamber",null,""]
[{"$nulls":4},""]
["7.2.1","8.2.5","Supply and install Air Valve assemblies complete with prefabricated chamber as per detailed drawing UKDM-0057-02 (25 mm dia air valve Vent-o-Matt RBX or similar approved)","No.",65]
[{"$nulls":4},""]
["7.3",null,"Scour Valves Complete with Protective Chamber",null,""]
[{"$nulls":4},""]
["7.3.1",null,"Supply and install Bulk Meter assemblies complete with preacast chamber as per detailed drawing UKDK-0057-03. Rate is inclusive of valve chamber and all specials.","No.",4]
[{"$nulls":4},""]
[7.4,null,"Check / Non Return Valves Complete",null,""]
[{"$nulls":4},""]
[null,"8.2.5","Supply and install Bulk Meter assemblies complete with preacast chamber as per detailed drawing UKDK-0057-04. Rate is inclusive of valve chamber and all specials.",null,""]
[{"$nulls":4},""]
["7.4.1",null,"100mm","No.",4]
[{"$nulls":4},""]
["7.4.2",null,"150mm","No.",2]
[{"$nulls":4},""]
[]
[]
[]
[" Total Carried Forward To Summary"]

{"sheet":"Pumpstations - Section 8","index":9,"n_rows":19,"n_cols":7,"rows_kept":19,"merged":[[18,0,18,3]]}
["UMGENI - UTHUKELA WATER"]
["NONDABUYA WSS"]
["CONTRACT No.:","SCMU 001/2026/2027"]
[]
[{"$nulls":6},"SECTION 8 : PUMP STATIONS"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[8,null,"PUMP STATIONS"]
[]
[8.1,null,"CONSTRUCTION OF ESINGENI RESERVOIR INLET BOOSTER PS"]
[]
["8.1.1",null,"Supply equipment & accessories material, remove old equipment, install, test, comissioning for the refurbishment of 2No. 3 phased centrifugal pump with Variable speed drive. Pump Duty to deliver 35L/s flow rate through a 1.3km 200mm ND steel pipeline. Complete pumpset installation with electro-mechanical components, power supply, MCC, DB panels and switchgear, pipe fittings and base frame mountings and other instrumentation assessories as needed and as directed by the Engineer. The tendered rate shall be inclusive of all supplier workshop vendor packaged equipment info, fabrication drawings, relevant tests, O&M manuals and 12 month warrantees required. All materials and workmanship to conform to specifications. Alow for pipe manifold for inlet and outlet into existing pipeline. Pump house inclusive.","Prov Sum",1,{"v":1700000,"d":"R1,700,000.00"},{"v":1700000,"d":"R1,700,000.00"}]
["8.1.2",null,"Contractor's mark up on item 8.1.1 above","%",{"v":1700000,"d":"R1,700,000.00"}]
[]
[]
[]
[]
[]
[" Total Carried Forward To Summary"]

{"sheet":"Tanks - Section 9","index":10,"n_rows":51,"n_cols":7,"rows_kept":51,"merged":[[50,0,50,3]]}
["UMGENI - UTHUKELA WATER"]
["NONDABUYA WSS"]
["CONTRACT No.:","SCMU 001/2026/2027"]
[]
[{"$nulls":6},"SECTION 9 : PREFABRICATED STEEL TANKS"]
[]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[9,null,"PREFABRICATED STEEL TANKS"]
[]
["9.1",null,"Storage Tanks (Including inlet/outlet control chamber)"]
["9.1.2","SANS 1039 &\nSANS 121","Provisional sum for the supply and erection of galvinised mild steel tank and stands or similar approveds with corrosion resistance qualities with handrails, walkway and lighting protection. The pressed steel to conform to SANS 1039:2004 all inclusive and be galvanised to SANS 121 as a minimum."]
[]
["9.1.2.1",null,"Provisional sum for the supply, delivery and erection and assembly of a 250kl Prestank or similar approved  pressed steel tank and associated pipework on a 20m Steel Structure, Incl Float Control Valve and elevated walkway and support structure.","No",2,{"v":2000000,"d":"R2,000,000.00"},{"v":4000000,"d":"R4,000,000.00"}]
[]
["9.1.2.2",null,"Contractor's mark up on item 9.1.2.1 above","%",{"v":4000000,"d":"R4,000,000.00"}]
[]
["9.1.2.3",null,"Provisional sum for the supply, delivery and erection and assembly of a 500kl Prestank or similar approved  pressed steel tank and associated pipework on a 20m Steel Structure, Incl Float Control Valve and elevated walkway and support structure.","No",1,{"v":4000000,"d":"R4,000,000.00"},{"v":4000000,"d":"R4,000,000.00"}]
[]
["9.1.2.4",null,"Contractor's mark up on item 9.1.2.3 above","%",{"v":4000000,"d":"R4,000,000.00"}]
[]
[9.2,null,"Monitoring System"]
[]
["9.2.1",null,"Provisional sums fo Implementation of a SCADA system covering reservoir levels, flow monitoring and pressure monitoring","Sum",1,{"v":400000,"d":"R400,000.00"},{"v":400000,"d":"R400,000.00"}]
[]
["9.2.1.1",null,"Contractor's mark up on item 9.2.1 above","%",{"v":400000,"d":"R400,000.00"}]
[{"$nulls":4},"",null,""]
["9.2.2",null,"Provisional sum for Automated water balance generation from collected data from flow and pressure","Sum",1,{"v":300000,"d":"R300,000.00"},{"v":300000,"d":"R300,000.00"}]
[]
["9.2.2.1",null,"Contractor's mark up on item 9.2.2 above'","%",{"v":300000,"d":"R300,000.00"}]
[]
["9.3","SANS 1200 G\n8.1.3","FOUNDATION REINFORCEMENT DETAILS:",null,"",null,""]
[{"$nulls":4},"",null,""]
["9.3.1",null,"Mild steel bars:",null,"",null,""]
[{"$nulls":4},"",null,""]
[null,null,{"v":8,"d":"R8"},"kg",1464]
[{"$nulls":4},""]
["9.3.2",null,"High tensile bars:",null,""]
[{"$nulls":4},""]
[null,null,"Y12","kg",{"v":2980.8,"d":"2981"}]
[{"$nulls":4},""]
[null,null,"Y16","kg",5184]
[{"$nulls":4},""]
["9.4",null,"FOUNDATION CONCRETE DETAILS:",null,""]
[{"$nulls":4},""]
["9.4.1","8.4.3","Strength concrete, Grade 30 MPa/19 mm:",null,""]
[null,null,"Tank stand","m3",270]
[{"$nulls":4},""]
["9.4.2",null,"Excavations and formwork preparations for ALL reservoir site pconcrete latforms","No",18]
[]
["Total Carried Forward To Summary"]

{"sheet":"Miscellaneous - Section 10","index":11,"n_rows":101,"n_cols":7,"rows_kept":101,"hidden":true,"merged":[[54,0,54,5],[55,0,55,5],[100,0,100,4]]}
["UMGENI - UTHUKELA WATER"]
["REFURBISHMENT AND AUGMENTATION OF WATER SUPPLY SCHEMES IN WARD 19 & 23 (NEW DEMARCATION) WITHIN JOZINI LM"]
[{"$f":"'P&G - Section 1'!A3","v":"CONTRACT No.:"}]
[]
[{"$nulls":6},"SECTION 11 : MISCELLANEOUS"]
["ITEM","PAYMENT","DESCRIPTION","UNIT","QTY","RATE","   AMOUNT"]
["NO",{"$nulls":5},"R"]
[]
[]
[11,null,"SECTION 11: MISCELLANEOUS"]
[]
["11.1",null,"MISCELLANEOUS ACTIVITIES"]
[]
[null,null,"Ward 19"]
[]
["11.1.1",null,"Allowance for refurbishments and upgrades to the Nondabuya Water Treatment Works","Prov Sum",1,{"v":2500000,"d":"R2,500,000.00"},{"$f":"IF((E16*F16)=0,\"Rate Only\",(E16*F16))","v":{"v":2500000,"d":"R2,500,000.00"}}]
[]
[]
["11.1.2",null,"Contractors markup on item 11.1.1","%",{"$f":"G16","v":{"v":2500000,"d":"R2,500,000.00"}},{"v":0.1,"d":"10%"},{"$f":"IF((E19*F19)=0,\"Rate Only\",(E19*F19))","v":{"v":250000,"d":"R250,000.00"}}]
[]
["11.1.3",null,"Establishment of existing water infrastructure, deficiencies, remedial works, fixing, testing, commisssioning and making good including pump station huts renovations, leakage detection and repairs"," Prov Sum",1,0,{"$f":"IF((E21*F21)=0,\"Rate Only\",(E21*F21))","v":"Rate Only"}]
[]
["11.1.4",null,"Contractors markup on item 11.1.3","%",null,null,{"$f":"IF((E23*F23)=0,\"Rate Only\",(E23*F23))","v":"Rate Only"}]
[]
["11.1.5",null,"Allowance for refurbishments and upgrades to pumps and installation of VSDs at the water treatment works","Prov Sum",1,{"v":600000,"d":"R600,000.00"},{"$f":"IF((E25*F25)=0,\"Rate Only\",(E25*F25))","v":{"v":600000,"d":"R600,000.00"}}]
[]
["11.1.6",null,"Contractors markup on item 11.1.5","%",{"$f":"G25","v":{"v":600000,"d":"R600,000.00"}},{"v":0.1,"d":"10%"},{"$f":"IF((E27*F27)=0,\"Rate Only\",(E27*F27))","v":{"v":60000,"d":"R60,000.00"}}]
[]
[null,null,"Ward 23"]
[]
["11.1.7",null,"Refurbishments and upgrades to the Shemula Water Treatment Works"]
[]
["11.1.8",null,"Supply and install new raw water meters suitable for measuring inflow in accordance with SANS 1529-1 standards."]
[]
["11.1.8.1",null,"200mm","No.",2,{"v":5809.35,"d":"R5,809.35"},{"$f":"IF((E35*F35)=0,\"Rate Only\",(E35*F35))","v":{"v":11618.7,"d":"R11,618.70"}}]
[]
["11.1.9",null,"Supply and install new final water meters suitable for measuring inflow in accordance with SANS 1529-1 standards."]
[]
["11.1.9.1",null,"200mm","No.",2,{"v":5809.35,"d":"R5,809.35"},{"$f":"IF((E39*F39)=0,\"Rate Only\",(E39*F39))","v":{"v":11618.7,"d":"R11,618.70"}}]
[]
["11.1.10",null,"Supply and install filter valves in accordance with SANS standards."]
[]
["11.1.10.1",null,"200mm","No.",10,{"v":5667,"d":"R5,667.00"},{"$f":"IF((E43*F43)=0,\"Rate Only\",(E43*F43))","v":{"v":56670,"d":"R56,670.00"}}]
[]
["11.2",null,"VALVES "]
[]
["11.2.1",null,"Air Valves Complete with Protective Chamber"]
[]
["11.2.1.1","8.2.5","Supply and install Air Valve assemblies complete with prefabricated chamber as per detailed drawings (25 mm dia air valve Vent-o-Matt RBX or similar approved) ","No.",{"v":6,"d":"6.0"},{"v":7500,"d":"R7,500.00"},{"$f":"IF((E49*F49)=0,\"Rate Only\",(E49*F49))","v":{"v":45000,"d":"R45,000.00"}}]
[]
[]
[]
[]
[]
["Carried Forward",{"$nulls":5},{"$f":"SUM(G9:G54)","v":{"v":3534907.4000000004,"d":"R3,534,907.40"}}]
["Brought Forward",{"$nulls":5},{"$f":"G55","v":{"v":3534907.4000000004,"d":"R3,534,907.40"}}]
[]
["11.2.2",null,"Pressure Sustaining Valves Complete with Protective Chamber"]
[]
["11.2.2.1",null,"Supply and install PSV assemblies complete with prefabricated/ Brick chamber as per detailed drawings (50mm Hydraulically Actuated PRV or similar approved)","No.",{"v":1,"d":"1.0"},{"v":4500,"d":"R4,500.00"},{"$f":"IF((E60*F60)=0,\"Rate Only\",(E60*F60))","v":{"v":4500,"d":"R4,500.00"}}]
{"$rows_empty":40}
[" Total Carried Forward To Summary",{"$nulls":5},{"$f":"SUM(G55:G100)","v":{"v":7074314.800000001,"d":"R7,074,314.80"}}]