{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["BoQ","Summary"],"not_rendered":{"external_links":1,"defined_names":3},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"BoQ","index":0,"n_rows":432,"n_cols":11,"rows_kept":432,"merged":[[0,1,0,2],[37,0,37,5],[38,0,38,5],[81,0,81,5],[120,0,120,5],[121,0,121,5],[161,0,161,5],[162,0,162,5],[191,0,191,5],[228,0,228,5],[229,0,229,5],[273,0,273,5],[306,0,306,5],[307,0,307,5],[352,0,352,5],[353,0,353,5],[388,0,388,5]],"flags":["formulas_cached_only"]}
["ITEM","PAYMENT",null,"DESCRIPTION","UNIT"," QTY","RATE","AMOUNT"]
[null,"SABS 1200 AA ",null,"SECTION A: PRELIMINARY AND GENERAL "]
[]
["A.1","PSAA 8.2.1",null,"Fixed - Charge Items (A.1 - A.11)"]
[]
["A.1.1","8.3.1",null,"Contractual requirements","Sum",1]
[]
[null,"8.3.2",null,"Establish Facilities on Site"]
["A.2","8.3.2 (a)",null,"Facilities for the Engineer (SABS 1200 AB):"]
["A.2.1",null,null,"Nameboard as detailed on Drawing No. J154-D02","Sum",1]
["A2.2","PS-8.1",null,"Furnished Site Office, M60341 from M Projects or similar approved (refer to Drawing No. J154-D03)","Sum",1]
["A2.3","PS QMS",null,"Compliance with Engineer's Quality Management System","Sum",1]
["A2.4","PS9.1",null,"Provision of a laptop and printer for use in connection with the contract","Sum",1]
["A2.5",null,null,"Survey equipment","Sum",1]
["A.3","8.3.2 (b)",null,"Facilities for the Contractor:"]
["A.3.1",null,null,"Offices, storage sheds, workshops and living accommodation.","Sum",1]
["A.3.2",null,null,"Ablution and latrine facilities","Sum",1]
["A.3.3",null,null,"Tools, equipment and plant","Sum",1]
["A.3.4",null,null,"Water supplies, electric power, communications and access","Sum",1]
["A.4",null,null,"Dealing with water:"]
["A.4.1",null,null,"Generally on site","Sum",1]
["A.4.2",null,null,"At stream/river crossings","Sum",1]
["A.5","8.3.3",null,"Other fixed charge obligations","Sum",1]
["A.6","8.3.4",null,"Remove Contractor's site establishment on completion","Sum",1]
["A.7",null,null,"Accommodation of traffic including road signage as necessary","Sum",1]
["A.8","PE",null,"Preparation of risk assessments, safe work procedures, the project H&S File, the H&S plan, the provision of PPE and protective clothing.The sum shall include all fixed costs necessary in complying with the OHS Act (1993 as amended) and the Construction Regulations (2003) and the Health and Safety Specifications.  Rate to include for COVID-19 Virus as detailed in the specifications","Sum",1]
["A.9",null,null,"Appointment of a construction health and safety officer for the duration of construction works","Sum",1]
["A.10","PE",null,"Completing and checking the Project H&S File and handing over the Client on completion of the works","Sum",1]
["A11","PES",null,"Compliance with requirements of the project Environmental Management Plan","Sum",1]
[null,"PSAA 8.2.2",null,"Time Related Items"]
["A.12","8.4.1",null,"Contractual requirements","Sum"]
["A.13","8.4.2",null,"Operate and maintain facilities on the site for the duration of construction:"]
["A.13.1","8.4.2 (a)",null,"Facilities for the Engineer-"]
["A.13.1.1",null,null,"Nameboard ","Sum",1]
["A.13.1.2",null,null,"Survey equipment (Including the use of a trained survey assistant)","Sum",1]
["A.13.1.3",null,null,"Engineer's site offices including consumables for laptop printer ","Sum",1]
["A.13.1.4",null,null,"Compliance with Engineer's Quality management system","Sum",1]
["SUBTOTAL CARRIED FORWARD"]
["SUBTOTAL BROUGHT FORWARD"]
["A.13.1.5","PSAB8.2.1",null,"Other time related obligations including R125 per week for Engineer's cellular telephone calls and rental cost","Sum",1]
["A.14","8.4.2 (b)",null,"Facilities for the Contractor-"]
["A.14.1",null,null,"Contractor's establishment as per Item A.3","Sum",1]
["A.15","PSAA 5.3",null,"Dealing with water:"]
["A.15.1",null,null,"Generally on the site","Sum",1]
["A.15.2",null,null,"At stream/river crossings","Sum",1]
["A.16","8.4.3",null,"Supervision for duration of construction","Sum",1]
["A.17",null,null,"Accommodation of traffic and maintance of vehicular access to properties","Sum",1]
["A.18","8.4.3",null,"Company and head office overhead costs for the duration of the contract","Sum",1]
["A.19","PE",null,"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. Rate to include for COVID-19 Virus as detailed in the specifications","Sum",1]
["A.20","PE",null,"Full compliance with all H&S matters during the construction of the works under the contract including all COVID-19 Protocols and procedures","Sum",1]
["A.21",null,null,"Compliance with requirements of the project Environmental Management Plan","Sum",1]
["A.22","8.4.3",null,"Other time related obligations","Sum",1]
[]
[null,8.5,null,"Provisional Sums"]
["A.23",null,null,"Locate existing services where ordered","Sum",1,null,{"v":5000,"d":"5,000.00"}]
["A.24",null,null,"Relocation of existing services and fences where ordered","Sum",1,null,{"v":5000,"d":"5,000.00"}]
["A.25",null,null,"Inspection of Materials by Inspectors appointed by the Engineer including Geotech investigations","Sum",1,null,{"v":200000,"d":"200,000.00"}]
["A.27",null,null,"Water for testing  (1 filling)","Sum",1,null,{"v":10000,"d":"10,000.00"}]
["A.28",null,null,"Allowance for Engineer's technical Assistant for duration of construction works","Sum",1,null,{"v":30000,"d":"30,000.00"}]
["A.29",null,null,"Engineer's Representative cell phone calls","Sum",1,null,{"v":5000,"d":"5,000.00"}]
["A.30",null,null,"Engineer's Representative accomodation costs","Sum",1,null,{"v":15000,"d":"15,000.00"}]
["A.31",null,null,"Allowance for CLO","Sum",1,null,{"v":78000,"d":"78,000.00"}]
["A.32",null,null,"Allowance for ISD Consultant","Sum",1,null,{"v":200000,"d":"200,000.00"}]
["A.33",null,null,"Inspections by appointed Health and Safety and Environmental Auditors","Sum",1,null,{"v":510000,"d":"510,000.00"}]
["A.34",null,null,"Contractor's mark up on items A.25 to A31","%",{"v":1048000,"d":"1,048,000.00"}]
{"$rows_empty":16}
["TOTAL FOR SECTION A CARRIED TO SUMMARY"]
[null,"SABS 1200 DA",null,"SECTION B: EARTHWORKS"]
["B1",null,null,"Site Clearance"]
["B1.1","8.2.1","LI","Clear and grub vegetation ","m²",500]
["B1.2","8.3.1(a)","LI","Clear vegetation and trees of girth up to 1 m along route of pipeline","m",5000]
["B1.2",null,null,"Setting out of the works as per site plans issued by Engineer ","Sum",1]
[null,"SABS 1200D",null," Excavation",null," "]
["B2","8.3.1.2",null,"Remove topsoil to a nominal depth of 150mm, stockpile & maintain for further use","m²",14000]
["B3","8.3.2",null,"Bulk excavation for structures in all materials & use as backfill or embankment or dispose of on site  as ordered for:"]
["B3.1",null,"LI","Elevated Tank foundations ","m³",200]
["B3.5",null,"LI","Minor chambers and structures","m³",10]
["B4","8.3.3   ",null,"Extra-over Items B3 for (PROVISIONAL):"]
["B4.1",null,null,"Intermediate excavation","m³",10]
["B4.2",null,null,"Hard rock excavation","m³",80]
["B4.3",null,null,"Boulder excavation Class A","m³",5]
["B4.4",null,null,"Boulder excavation Class B","m³",5]
["B5",null,null,"Restricted Excavation"]
["B5.1","8.3.3","LI","Excavate for footings and restricted foundations in all materials and use as backfill or embankment or dispose, as ordered","m³",20]
["B5.2",null,"LI","Excavate trial holes along pipeline route for insosection by Geotech Engineer ","m³",30]
["B6","8.3.3   ",null,"Extra-over Items B5 for (PROV):"]
["B6.1",null,null,"Intermediate excavation","m³",5]
["B6.2",null,null,"Hard rock excavation","m³",5]
["B6.3",null,null,"Boulder excavation Class A","m³",2]
["B6.4",null,null,"Boulder excavation Class B","m³",2]
[{"$nulls":3},"Embankments"]
["B7",null,null,"Import suitable fill material (G5 quality) within 20km free haul radius and form embankments around structures including adding water and compacting to 96% MOD AASHTO (PROV) for use as engineered fill under structures","m³",0]
["B7.1","8.3.4",null,"Import hardcore 150mm thick from commercial sources, place and compact to 96% MOD AASHTO - G5 quality material","m³",0]
["B9",null,null,"Allow for the Engineer's compaction  soil tests on backfill along pipe tranches and where ordered","Sum",1,{"v":30000,"d":"R 30,000.00"},{"v":30000,"d":"30,000.00"}]
[{"$nulls":3},"Topsoiling and Grassing"]
["B10","8.3.10","LI","Topsoiling from stockpiles to a nominal depth of 100mm on embankments, terraces and designated areas","m²",14000]
[]
["B13","SABS 1200DB ",null,"Pipe Trenching"]
["B13.1","8.3.2",null,"Excavate in all materials for trenches, backfill, compact or dispose of surplus / unsuitable material, for:"]
[{"$nulls":3},"Pipes up to 200mm dia for depths by hand:"]
[{"$nulls":3},"Over   and   Up to:"]
["B13.1.1",null,"LI","0,0 m            1,0m","m",100]
["B13.1.2",null,"LI","1,0m             1,5m","m",100]
[]
[]
["SUBTOTAL CARRIED FORWARD"]
["SUBTOTAL BROUGHT FORWARD",{"$nulls":6},0]
["B13.2",null,null,"Excavate in all materials for trenches, backfill, compact, for pipes up to and including 200mm dia for depths :"]
["B13.2.1",null,"LI","0,0 m            1,0m","m",1100]
["B13.2.2",null,null,"1,0m             2,0m","m",1200]
["B13.2.3",null,null,"2,0m             3,0m","m",1000]
["B13.2.4",null,null,"3,0m             4,0m","m",1000]
["B13.2.5",null,null,"Greater than 4,0m deep","m",50,{"$nulls":3},4550]
["B.13.3","8.3.2",null,"Excavate in all materials beyond the limits of pipe trenches for thrust walls, valve chambers, anchor blocks and manholes where ordered by the Engineer:"]
[null,null,"LI","Over and Up to"]
["B13.3.1",null,null,"0,0m - 1,0m","m³",30]
["B13.3.2",null,null,"1,0m - 2,0m","m³",20]
["B13.3.3",null,null,"3,0m - 4,0m","m³",5]
["B13.3.4",null,null,"Greater than 4,0m deep","m³",5]
["B13.4","8.3.2 (b)",null,"EO Items B13.1 to B13.3 for :"]
["B13.4.1",null,null,"Hard rock excavation","m³",540]
["B13.5",null,null,"Removal of rock without the use of explosives (where ordered by the Engineer)","m³",30]
["B13.6",null,null,"Boulder excavation Class A","m³",5]
["B13.7",null,null,"Boulder excavation Class B","m³",5]
["B.14","SABS 1200 DB",null,"Imported Backfill Material"]
["B14.1","8.3.3.1",null,"Imported backfill material from commercial sources","m³",350]
["B14.2",null,null,"Imported backfill material from designated borrow pit  20km free haul radius","m³",200]
[{"$nulls":3},"Imported G7 quality material compacted to 98% MOD AASHTOO from sources identified by Contractor","m³",50]
["B14.3","8.3.3.3",null,"Compaction under roadways","m³",50]
["B14.4","DB 5.1.2.4","LI","Supply and install sack breakers in trenches","N°",80]
["B14.5",null,null,"Build cross embankments as specified where ordered","m³",10]
[{"$nulls":3},"Stone Bedding"]
["B11",null,null,"Supply and place stone bedding","m³",100]
["B12","SABS 1200 DK",null,"Gabions and Pitching"]
["B12.1","8.2.1 (a)",null,"Surface preparation - cavities filled with excavated material","m²",150]
["B12.2","8.2.2",null,"Gabions:",null," "]
["B12.2.1",null,null,"2m x 1m x 1m boxes","m³",5]
["B12.2.2",null,null,"2m x 2m x 0,23m boxes","m³",5]
["B13","8.2.4",null,"Geotexile where ordered","m²",150]
{"$rows_empty":7}
["SUBTOTAL CARRIED FORWARD"]
["SUBTOTAL BROUGHT FORWARD"]
["B14",null,"LI","Roadmesh geogrid\navailable from Maccaferri SA or similar approved ","m²",100]
["B15","8.2.5","LI","Ordinary stone pitching ","m²",25]
["B16","8.2.5 (a)",null,"Services that Intersect a Trench:"]
["B16.1",null,"LI","Stormwater pipes up to 600mm dia","Nº",2]
["B16.2",null,"LI","Water mains 20mm to 150mm dia","Nº",5]
["B16.3",null,"LI","Wire Fences (all types)","Nº",3]
["B17",null,null,"Services that adjoin a Trench:"]
["B17.1",null,null,"Stormwater pipes up to 600mm dia","m",5]
["B17.2",null,null,"Water mains 20mm to 150mm dia","m",5]
["B17.3",null,"LI","Wire Fences (all types)","m",5]
["B18",null,null,"Allow everything necessary for working within 1,0m from existing overhead services poles. Rate to include for supporting and maintaining pole during construction.","N°",4]
{"$rows_empty":17}
["TOTAL FOR SECTION B CARRIED TO SUMMARY"]
[null,"SABS 1200G 1982",null,"SECTION C:  CONCRETE WORK"]
[null,"8.1.3",null,"Concrete ",null," "]
["C1","8.4.2",null,"Blinding layer in 15 Mpa / 20mm concrete:",null," "]
["C1.1",null,"LI","50mm  minimum thickness","m²",100]
["C2","8.4.3",null,"Strength concrete Grade 10 Mpa/40mm:"]
["C2.1",null,null,"Mass filling of cavities where ordered(PROV.)","m³",20]
["C3","8.4.3",null,"Strength concrete Grade 15 Mpa/20mm:"]
["C3.1",null,null,"Encasing to pipes and thrust blocks","m³",15]
["C4","8.4.3",null,"Strength concrete Grade 30 Mpa/19mm:",null," "]
["C4.1","8.4.3",null,"Floors, foundations, roof beams and slabs ","m³",80]
[null,"8.1.2",null,"Reinforcement"]
["C5","8.1.2.2",null,"High tensile steel bars: "]
["C6","8.1.2.2","LI","14 mm and under","t",4]
["C7","8.1.2.3","LI","16mm and over","t",4]
["C8","8.1.2.3c","LI","High tensile welded mesh (PROV):"]
["C8.1",null,"LI","Type reference 395","m²",20]
["C8.2",null,"LI","Type reference 245","m²",10]
["C8.3",null,"LI","Type reference 617","m²",160]
[]
[null,"8.1.1",null,"Formwork:"]
["C9","8.2.1",null,"Rough vertical plane to concealed surfaces:"]
["C9.1",null,null,"External straight faces of structures","m²",80]
["C10","8.2.2",null,"Smooth vertical plane to:",null," "]
["C10.1",null,null,"External exposed faces ","m²",100]
["C11","8.2.2",null,"Smooth horizontal to:",null," "]
["C11.1",null,null,"Soffit of chamber roof slabs","m²",50]
["C12","8.2.5",null,"Narrow widths:"]
["C12.1",null,null,"Vertical 0 - 150 wide","m",60]
["C12.2",null,null,"Vertical 151-300 wide","m",60]
["C13",null,null,"Grooves and Ducts"]
["C13.1",null,null,"40 x 40mm rebate for open gridflooring","m",5]
["C14","8.2.6",null,"Box out holes of area up to and including 1,0m², for depths:",null," "]
[{"$nulls":3},"Over   and   Up to"]
["C14.1",null,null,"0,00m         0,25m","N°",3]
["C15",null,null,"Setting the following pipes or fittings into or through concrete work, including for forming formwork around the pipes and fixing the pipes to the designated lines and levels (pipes measured elsewhere)"]
["C26.1",null,null,"Pipes up to 150mm NB","N°",3]
["SUBTOTAL CARRIED FORWARD"]
["SUBTOTAL BROUGHT FORWARD",{"$nulls":6},0]
["C16","8.5",null,"Joints:",null," ",null," "]
["C16.1",null,null,"Provide DPC between brickwork and concrete joints","m",60]
["C17","8.4.4",null,"Unformed Surface Finishes",null," "]
["C17.1",null,null,"Wood floated finish","m²",60]
["C17.2",null,null,"Steel floated finish","m²",90]
["C18",null,null,"Supply and lay 30mm screed to chambers","m²",50]
[{"$nulls":3},"Elevated Steel Tanks"]
["C19",null,null,"Supply, handle, deliver to site, erect and commission elevated steel tanks (PresTank or similar approved) by specialist subcontractor.  Rate to include the following: "]
[{"$nulls":3},"(a) Corrosion and cathodic protection "]
[{"$nulls":3},"(b) 100mm dia inlet, outlet and overflow pipework"]
[{"$nulls":3},"(c ) Access ladders and walkway around tank"]
[{"$nulls":3},"(d) 15m high suitably designed tank stand"]
[{"$nulls":3},"(e) Level control "]
[{"$nulls":3},"For the following capacities:"]
["C19.1",null,null,"50 kl","No.",2]
["C19.2",null,null,"30 kl","No.",1]
["C19.3",null,null,"75 kl","No.",1]
["C19.4",null,null,"Allow for attendance by main Contractor for tanks","%",{"v":1200000,"d":"1,200,000.00"}]
[]
[{"$nulls":3},"Watertightness Testing"]
["C20",null,null,"Testing units for watertightness, including taking all precautions to ensure the soundness of the structures in this respect:"]
[{"$nulls":3},"Water for testing paid for elsewhere"]
["C20.1",null,null,"Elevated Steel Tank","No",2]
[{"$nulls":3},"Provisional Sum"]
["C21",null,null,"Provisoinal Sum for work to be ordered as instructed by Engineer on site","Sum",1,{"v":500000,"d":"R 500,000.00"},{"v":500000,"d":"500,000.00"}]
{"$rows_empty":18}
["TOTAL FOR SECTION C CARRIED TO SUMMARY"]
[null,"PA",null,"SECTION D:  PIPEWORK AND SUNDRIES"]
[]
[{"$nulls":3},"Brickwork "]
[{"$nulls":3},"All brickwork to include \"Brickforce\" in every third course"]
["D1",null,null,"Brickwork one brick thick (220mm thick) in foundation bricks"]
["D1.1",null,"LI","Chambers ","m²",120]
["D2",null,null,"Dampproof course to joints between brickwork and between brickwork and concrete in approved bituminous sheeting, cut to the full width of walls, including for laps and sealing at joints and angles","m²",50]
["D3",null,null,"Setting pipes up to150mm ND through brickwork and plaster including building brickwork around, for grouting solid with mortar and finishing plasterwork and for face brickwork neatly, pipes and ducts less than 50 mm dia not measured","N°",6]
["D4",null,null,"4-ply malthoid in 2 layers to top of walls under concrete roofs","m",50]
["D5",null,null,"20mm thick plaster to internal walls ","m²",120]
[{"$nulls":3},"Mild steel pipes and fittings. "]
["D6",null,null,"Supply , handle and install mild steel pipes and fittings. Rate to include for all gaskets , nuts , bolts and jointing material. Flanges to table 1000/3 SABS 1123"]
[{"$nulls":3},"3.3mm wall thickness for 150mm dia and smaller pipes and fittings and are to be heavy duty hot dipped galvanised, 4.5mm wall thickness for pipes and fittings larger than 150mm dia and are to be 350 micron epoxy coated and lined. "]
["D6.1",null,null,"Coupling / Flange adaptors"]
["D6.1.1",null,null,"100mm dia flange adaptor ","N°",6]
["D6.1.2",null,null,"50mm dia flange adaptor ","N°",3]
["D6.2",null,null,"Bends"]
["D6.2.1",null,null,"100mm dia x 90 deg bend","N°",2]
["D6.2.2",null,null,"50mm dia x 90 deg bend","N°",4]
["D6.3",null,null,"Valves"]
[{"$nulls":3},"Supply , handle and install SABS approved flanged wedge gate valves. Flanges to table 1600/3 SABS 1123. Rate to include all nuts , bolts , gaskets and jointing material."]
["D6.3.1",null,null,"100mm dia valve with square cap","N°",3]
["D6.3.2",null,null,"50mm dia valve with square cap","N°",3]
["D7",null,null,"PVC pipes and Fittings"]
["D7.1",null,null,"Pressure Pipes"]
[{"$nulls":3},"Supply, handle, lay and test uPVC pipes with Z lok joints in bedding for flexible pipes (SANS 966-1) in 6m lengths",{"$nulls":6},"Pipe Laying"]
["D7.1.1",null,null,"110mm dia uPVC class 16 Z lok pipes in 6m lengths","m",300,{"$nulls":3},"SANS 1200 L","PVC pipes and fittings"]
["D7.1.2",null,null,"160mm dia uPVC class 16 Z lok pipes in 6m lengths","m",150,{"$nulls":4},"Water Pipes:"]
["D7.2",null,null,"PVC Bends"]
["D7.2.1",null,null,"110mm dia x 90 deg Z Lok PVC bend","N°",4]
["D7.2.2",null,null,"50mm dia x 90 deg Z Lok PVC bend","N°",2,{"$nulls":3},"8.2.1","Supply, handle, lay and test uPVC pipes with Z lok joints in bedding for flexible pipes (SANS 966-1) in 6m lengths"]
[]
["SUBTOTAL CARRIED FORWARD"]
["SUBTOTAL BROUGHT FORWARD"]
[null,"SABS 1200L ",null,"PE 80 HDPE pipes (Type 4) and Fittings"]
["D8","8.2.1",null,"Supply, lay, joint, bed on Class C for flexible pipe bedding, test and disinfect.  Excavation and bedding measured elsewhere."]
[{"$nulls":3},"Class 16"]
["D8.1",null,null,"90mm dia","m",2500]
["D8.2",null,null,"75mm dia","m",500]
["D8.3",null,null,"50mm dia","m",1000]
["D8.4",null,null,"40mm dia","m",500]
["D8.5",null,null,"32mm dia","m",300,{"$nulls":4},4800]
["D9",null,null,"HDPE Fittings"]
[{"$nulls":3},"Fittings to be supplied complete with fiitings for joining onto HDPE pipes of respective sizes"]
[{"$nulls":3},"Reducing Couplings "]
["D9.1",null,null,"50 x 40 mm reducing coupling","No",5]
["D9.2",null,null,"75 x 50 mm reducing coupling","No",5]
["D9.3",null,null,"90 x 50 mm reducing coupling","No",5]
[{"$nulls":3},"Reducing Tees"]
["D9.4",null,null,"50 x 40 mm","No",8]
["D9.5",null,null,"50 x 32 mm ","No",5]
["D9.6",null,null,"40 x 32 mm ","No",5]
[{"$nulls":3},"End Caps"]
["D9.7",null,null,"On 50 mm diameter HDPE pipelines","No",3]
["D9.8",null,null,"On 40 mm diameter HDPE pipelines","No",3]
[]
["D10",null,null,"Provision of bedding"]
["D10.1","8.2.1",null,"Selected from trenches, and/or other excavations without the need for screening or other treatment:"," "]
["D10.2",null,null,"Selected granular material","m³",60]
["D10.3",null,null,"Selected fill material","m³",60]
[null,"8.2.1",null,"Selected from trenches, and/or other excavations including for screening or other treatment:"]
["D10.4",null,null,"Selected granular material","m³",40]
["D10.5",null,null,"Selected fill material","m³",40]
[{"$nulls":3},"Supply of bedding from commercial sources, where ordered"]
["D10.6",null,null,"Selected granular material","m³",60]
["D10.7",null,null,"Selected fill material","m³",60,{"$nulls":3},320]
["D10.8","8.2.3",null,"Concrete bedding cradle","m³",20]
["D10.9","8.2.4",null,"Concrete encasing of pipes in trenches in 20/19 concrete","m³",10]
["D11",null,null,"Water Meters "]
["D11.1",null,null,"100mm dia Meinecke water meter complete with strainer ","N°",2]
["D11.2",null,null,"50mm dia Meinecke water meter complete with strainer ","N°",2]
[{"$nulls":3},"Handrailing "]
["D11.3",null,null,"Galvanised access hand hold stanchions suitably braced with knee and handrails ","N°",3]
["D11.4",null,null,"Supply and install hot dip galvanised open grid flooring","m²",1]
["D11.5",null,null,"Supply and install manhole cover and frame 610 x 610 (refer Drawing. No.J154-D03)","Nº",3]
["D11.6",null,null,"600 x 600 Fiberite cover and frame with locking bar","Nº",3]
["D12",null,null,"Standpipes"]
["D12.1",null,null,"Supply all materais and construct standpipes complete as detailed in Drawing No J154-D03","No",10]
["SUBTOTAL CARRIED FORWARD"]
["SUBTOTAL BROUGHT FORWARD"]
["D13",null,null,"Valve Chambers"]
["D13.1",null,null,"Supply materials and construct complete chambers as shown on Drawing N° J154-D03. Pipes and fittings scheduled separately","Nº",3]
["D14",null,null,"Ladders "]
["D14.1",null,null,"Access ladder into meter chambers as detailed in Drawing J154-D03","Nº",3]
["D15",null,null,"Marker Posts"]
["D15.1",null,"LI","Supply and install marker beacons as shown on Drawing N° J154-D03 at all horizontal bends on pipeline and where ordered by the Engineer, incl. for painting twice with yellow road marking paint and concrete surround","N°",50]
["D15.2",null,"LI","Supply and install LV, SV and AV marker posts as per Drawing N°  J154-D03 (painted with brown marking paint) including for concrete surround","N°",6]
[{"$nulls":3},"Denso Protection"]
["D16",null,null,"Supply and apply Denso protection to SCJ's, flanges, VJ couplings and VJ adaptor joints :"]
["D16.1",null,"LI","0-200 mm dia","N°",12]
[{"$nulls":3},"Connection to Existing",null," "]
["D17",null,null,"Allow for everything necessary for connecting to existing pipes and / or structures including for dealing with the flow, cutting in, sealing and making good after (pipe fittings included elsewhere)","N°",6]
[{"$nulls":3},"Headwalls  "]
["D18",null,null,"Headwalls complete including for excavation and foundations to suit"]
["D18.1",null,"LI","a) 200 mm diameter","No.",3]
[]
["D19",null,null,"Fencing"]
["D19.1",null,"LI","Supply and erect anti-intruder fencing constructed of wire mesh fencing and prestressed concrete posts as shown on Drawing J154-D03","m",120]
["D19.2",null,"LI","Supply and erect double gate as shown on Drawing J154-D03","No.",3]
["D19.3",null,null,"Supply and install 50 mm Discus 0370 padlock as supplied by Southern Bolt - only one security key needed","No",4]
["D20",null,null,"Boreholes"]
["D20.1",null,null,"Provisional sum for Rotary Percussion Drilling, casing, yield testing and water quality testing of boreholes","Sum",1,{"v":250000,"d":"R 250,000.00"},{"v":250000,"d":"250,000.00"}]
["D20.2",null,null,"Provisional sum for equiping of boreholes","Sum",1,{"v":380000,"d":"R 380,000.00"},{"v":380000,"d":"380,000.00"}]
{"$rows_empty":11}
["TOTAL FOR SECTION D CARRIED TO SUMMARY"]
[{"$nulls":3},"SECTION H: DAYWORKS SCHEDULE"]
[]
["H1",null,null,"Labour"]
[]
["H1.1",null,null,"Plumber","hrs",16]
[]
["H1.2",null,null,"Foreman","hrs",16]
[]
["H1.3",null,null,"Bricklayer","hrs",16]
[]
["H1.4",null,null,"Carpenter","hrs",16]
[]
["H1.5",null,null,"General labour","hrs",16]
[]
["H1.6",null,null,"Watchmen ","hrs ",16]
[]
["H2",null,null,"Plant"]
[]
["H2.1",null,null,"Plate compactor","hrs",12]
[]
["H2.2",null,null,"Dewatering pump","hrs",15]
[]
["H2.3",null,null,"Generator","hrs",16]
[]
["H2.4",null,null,"Front End Loader/TLB","hrs",16]
[]
[{"$nulls":3},"Excavator","hrs",20]
[]
[{"$nulls":3},"Test Pump","hrs",20]
[]
["H3",null,null,"Materials"]
[]
["H3.1",null,null,"19mm stone","m³",20]
[]
["H3.2",null,null,"River sand","m³",50]
[]
["H3.3",null,null,"190mm Thick blockwork","m²",50]
[]
["H3.4",null,null,"Cement","Bag",10]
[]
[]
[]
["TOTAL SECTION E CARRIED FORWARD TO SUMMARY"]

{"sheet":"Summary","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"merged":[[0,0,0,2],[2,0,2,2],[3,0,3,2],[5,0,5,2],[7,0,8,0],[7,1,8,1],[7,2,8,2],[20,0,20,1],[22,0,22,1],[23,0,23,1]],"flags":["formulas_cached_only"]}
["MHLATHUZE WATER"]
[null,"CONTRACT MW/XXX"]
["  WATER INTERVENTIONS FOR HOT SPOT AREAS"]
["CONSTRUCTION OF 50 KL PREFABRICATED ELEVATED STEEL RESERVOIRS, RETICULATION PIPELINES AND DRILLING, EQUIPPING AND COMMISSIONING OF BOREHOLES AT EZINQENI AND THUNGWINI SUBWARDS UNDER THE UMHLABUYALINGANA MUNICIPALITY "]
[]
["SCHEDULE OF QUANTITIES SUMMARY"]
[]
["SECTION","DESCRIPTION","AMOUNT"]
[]
[]
["A","Preliminary & General",null,{"$error":"#DIV/0!"},{"v":0,"d":"R 0.00"}]
[]
["B","Earthworks",{"v":0,"d":"R 0.00"}]
[]
["C","Concrete Works",{"v":0,"d":"R 0.00"}]
[]
["D","Pipework and Sundries",{"v":0,"d":"R 0.00"}]
[]
["F","Dayworks",{"v":0,"d":"R 0.00"}]
["SubTotal",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
["Add: 10% Allowance for Contingencies & Escalation",null,{"v":0,"d":"R 0.00"}]
["SubTotal",null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
["Add: 15% VAT",null,{"v":0,"d":"R 0.00"},null,null,{"$error":"#REF!"}]
["TOTAL ESTIMATE",null,{"v":0,"d":"R 0.00"}]
[]
[]
[]
[null,null,{"v":4643478.260869565,"d":"R 4,643,478.26"}]