{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["SANS 1200 MEASUREMENT DESCRIPTI","Preliminary and General","1-ACCESS ROAD","2-INTERNAL ROADS","3-CONCERVANCY TANKS","4-SEWER LINES","5-WATER NETWORK","SUMMARY"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"SANS 1200 MEASUREMENT DESCRIPTI","index":0,"n_rows":149,"n_cols":1,"rows_kept":149}
["SANS 1200 MEASUREMENT DESCRIPTION"]
[]
["WATER RETICULATION, BOREHOLE, STORAGE AND FIRE PROTECTION SYSTEM"]
[]
["All work shall be carried out in accordance with the latest editions of SANS 1200, SANS 10252, SANS 10299, SANS 10400, SANS 2001, Occupational Health and Safety Act, Local Authority Requirements, Water Services Act and all applicable regulations."]
[]
["A. PRELIMINARIES AND GENERAL"]
[]
["Allow for establishment of site offices, temporary facilities, supervision, setting out, health and safety requirements, quality control, environmental management, testing, commissioning, as-built drawings, operation manuals and final handover of the complete installation."]
[]
["Measured as:"]
["Item"]
[]
["B. BOREHOLE EQUIPPING"]
[]
["Supply, install, test and commission complete borehole equipping including stainless steel submersible pumps, rising mains, safety cables, borehole headworks, flow meters, isolation valves, non-return valves, electrical connections and all accessories necessary for a fully operational system."]
[]
["Measured as:"]
["Number"]
["Metre"]
["Item"]
[]
["C. AUTOMATION AND CONTROL"]
[]
["Supply and install complete automatic control system comprising pump control panels, motor protection, level monitoring equipment, pressure sensors, telemetry system, remote monitoring capability, surge protection, alarms and all associated instrumentation."]
[]
["Measured as:"]
["Number"]
["Item"]
[]
[]
[]
["F. HDPE WATER RETICULATION PIPEWORK"]
[]
["Supply, deliver, lay, joint, test and commission 50mm HDPE PE100 PN16 pipework including all cutting, welding, fittings, anchors, supports and thrust restraints complete."]
[]
["Pipework to comply with SANS 4427."]
[]
["Measured as:"]
["Metre"]
[]
["G. VALVES AND APPURTENANCES"]
[]
["Supply and install gate valves, air release valves, washout valves, non-return valves, pressure regulating valves, valve chambers, marker posts and all associated fittings complete."]
[]
["Valve chambers to include concrete surrounds, covers and identification markers."]
[]
["Measured as:"]
["Number"]
["Item"]
[]
["H. BUILDING WATER CONNECTIONS"]
[]
["Provide complete water connections to buildings including tees, reducers, service connections, pressure reducing valves, isolation valves, meter connections, valve boxes, fittings and accessories complete."]
[]
["Measured as:"]
["Number"]
["Metre"]
["Item"]
[]
["I. ELEVATED WATER STORAGE TANK"]
[]
["Supply and install 20,000 litre elevated steel water storage tank complete with inlet pipework, outlet pipework, scour pipe, overflow pipe, level indicators, ladders, access hatches, vent screens and all accessories."]
[]
["Tank to comply with SANS 1731 and relevant water storage standards."]
[]
["Measured as:"]
["Number"]
["Item"]
[]
["J. STEEL WATER TANK TOWER"]
[]
["Design, fabricate, supply and erect structural steel tank support tower including reinforced concrete foundations, anchor bolts, ladders, safety cages, platforms, handrails, corrosion protection and associated structural components."]
[]
["Structural steelwork to comply with SANS 10162 and SANS 2001."]
[]
["Measured as:"]
["Ton"]
["Item"]
[]
["K. FIRE HYDRANT INSTALLATION"]
[]
["Supply and install complete fire hydrant system including hydrant assembly, landing valves, chambers, isolation valves, pipework, fittings and identification signage."]
[]
["Installation to comply with SANS 1128 and local fire authority requirements."]
[]
["Measured as:"]
["Number"]
["Item"]
[]
["L. FIRE BOOSTER PUMP SYSTEM"]
[]
["Supply and install complete booster pump system including pumps, control panels, pressure vessels, pipework, valves, non-return valves, electrical controls and all accessories."]
[]
["System to be fully tested and commissioned."]
[]
["Measured as:"]
["Number"]
["Item"]
[]
["M. FIRE HOSE REELS"]
[]
["Supply and install complete fire hose reel units comprising hose reel cabinet, 30m hose, nozzle, isolation valve, mounting brackets, pipework connections and signage."]
[]
["Installation to comply with SANS 543."]
[]
["Measured as:"]
["Number"]
[]
["N. FIRE EXTINGUISHERS"]
[]
["Supply and install portable fire extinguishers complete with wall brackets, identification signage and mounting accessories."]
[]
["Extinguishers to comply with SANS 1910 and SANS 1475."]
[]
["Measured as:"]
["Number"]
[]
["O. SAFETY SIGNAGE"]
[]
["Supply and install emergency evacuation signage, directional signage, assembly point signs, fire equipment identification signs and statutory notices complete."]
[]
["Measured as:"]
["Number"]
[]
["P. TESTING, COMMISSIONING AND HANDOVER"]
[]
["Allow for pressure testing of pipelines, flushing, chlorination, disinfection, functional testing of pumps, fire protection equipment, automation systems, training of client personnel, preparation of operation manuals, as-built drawings and final handover."]
[]
["Measured as:"]
["Item"]
[]
["GENERAL NOTES"]
[]
["1. Rates shall include labour, materials, plant, transport, supervision, testing, wastage, overheads and profit."]
[]
["2. All fittings, couplings, adaptors, flanges, bolts, gaskets, supports and sundry items necessary for complete installations shall be deemed included unless separately measured."]
[]
["3. Excavation rates shall include temporary support, dewatering, trimming and disposal where applicable."]
[]
["4. All pipework shall be hydrostatically tested in accordance with SANS requirements."]
[]
["5. All electrical work shall be supplied complete with Certificates of Compliance."]
[]
["6. All fire protection systems shall be tested and approved by the relevant authority having jurisdiction."]
[]
["7. Contractor shall provide as-built drawings and operation manuals upon completion."]
[]
["This format is suitable for inclusion in a professional BOQ, tender document, GCC contract schedule, or mine/lodge infrastructure project measured in accordance with SANS 1200 and SANS 2001."]

{"sheet":"Preliminary and General","index":1,"n_rows":57,"n_cols":6,"rows_kept":57,"merged":[[0,0,0,16383],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[56,0,56,4]]}
[]
["Item","Item Description","Unit","Quantities","Rate","Amount"]
["number",{"$nulls":4},"Rands.cents"]
[null,"Schedule 1"]
[null,"Preliminary & General and Health & Safety schedules"]
[]
[]
[]
[1.1,"Preliminary & General allowances"]
[]
[null,"GENERAL"]
[]
["1.1.1","Contractual requirements","sum",1]
["1.1.2","The Contractor to provide a name board","No",1]
["1.1.3","The contractor to provide furbished office","sum",1]
["1.1.4","The Contractor to provide survey assistant","sum",1]
["1.1.5","The Contractor to provide survey equipments","sum",1]
["1.1.6","The Contractor to provide offices and storage sheds","sum",1]
["1.1.7","The Contractor to provide workshops","sum",1]
["1.1.8","The Contractor to provide living accommodations","sum",1]
["1.1.9","The Contractor to provide ablution and latrine facilities","sum",1]
["1.1.10","The Contractor to supply tools and equipments","sum",1]
["1.1.11","The Contractor to provide water, electricity & communications","sum",1]
["1.1.12","Deal with water as described in SANS 1 200 A section 5.5","sum",1]
["1.1.13","The Contractor to establish access road to site ","sum",1]
["1.1.14","Other fixed charge obligations by the Contractor","sum",1]
["1.1.15","The Contractor to remove site establishment","sum",1]
["1.1.16","The Contractor to make provision for traffic control","sum",1]
[]
["1.2","Time related items"]
[]
["1.2.1","Contractual requirements","sum",1]
["1.2.2","The Contractor to maintain all facilities on the site","sum",1]
["1.2.3","The Contractor's supervision of the site","sum",1]
["1.2.4","The Contractor's company and head office overhead costs","sum",1]
["1.2.5","Other time related obligations by the Contractor","sum",1]
["1.2.6","Time related costs for traffic control","sum",1]
["1.2.7","Communication facilities (cell phone) for the Engineer","Prov ",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[null,"Contractor's overhead and profit on Item 1.2.7","%",{"v":20000,"d":"20,000"}]
["1.2.8","Provisional sum for community involvement/CLO payment","Prov ",1,{"v":50000,"d":"50,000.00"},{"v":50000,"d":"50,000.00"}]
[null,"Contractor's overhead and profit on Item 1.2.8","%",{"v":50000,"d":"50,000"}]
[]
["1.3","Provisional sums by the Engineer"]
[]
["1.3.1","Provisional sum for various tests requested by the Engineer","Prov",1,{"v":50000,"d":"50,000.00"},{"v":50000,"d":"R50,000.00"}]
["1.3.1.1","Contractor's overhead and profit on Item 1.3.1","%",{"v":50000,"d":"50,000"}]
["1.3.2","Telephone calls and Rental for the Engineers Representative","Prov",1,{"v":40000,"d":"40,000.00"},{"$f":"E47","v":{"v":40000,"d":"R40,000.00"}}]
["1.3.2.1","Contractor's overhead and profit on Item 1.3.2","%",{"v":40000,"d":"40,000"}]
["1.3.3","Contractor to provide the as built drawings","Prov",1,{"v":85000,"d":"85,000.00"},{"$f":"E49","v":{"v":85000,"d":"85,000.00"}}]
["13.3.1","Contractor's overhead and profit on Item 1.3.3","%",{"$f":"F49","v":{"v":85000,"d":"85,000"}}]
[]
[]
[]
[]
[]
[]
[{"$f":"B4&\" total carried to summary page\"","v":"Schedule 1 total carried to summary page"}]

{"sheet":"1-ACCESS ROAD","index":2,"n_rows":63,"n_cols":6,"rows_kept":63,"merged":[[0,0,0,5],[2,0,2,5],[10,0,10,4],[12,0,12,5],[19,0,19,4],[21,0,21,5],[26,0,26,4],[28,0,28,5],[34,0,34,4],[36,0,36,5],[43,0,43,4],[45,0,45,5],[50,0,50,4],[52,0,52,5],[53,1,53,4],[54,1,54,4],[55,1,55,4],[56,1,56,4],[57,1,57,4],[58,1,58,4],[59,1,59,4],[60,1,60,4],[61,1,61,4],[62,0,62,4]]}
["ACCESS ROAD"]
[]
["A. SITE CLEARANCE & EARTHWORKS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["A1","Clear & grub 6 m × 650 m road reserve","m²",{"v":2400,"d":"2,400"}]
["A2","Strip topsoil 150 mm and stockpile","m³",360]
["A3","Shape & trim subgrade to 2% cross fall","m²",{"v":2400,"d":"2,400"}]
["A4","Compact subgrade to 93% Mod AASHTO","m²",{"v":2400,"d":"2,400"}]
["A5","Minor cut/fill to achieve levels (Provisional)","m³",62]
["Sub-Total A"]
[]
["B. PAVEMENT LAYERS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["B1","150 mm Roadbed – Rip, level & compact to 95% Mod AASHTO","m²",{"v":2400,"d":"2,400"}]
["B2","150 mm G5 imported filling compacted to 90% Mod AASHTO","m³",360]
["B3","150 mm G5 imported subbase compacted to 93% Mod AASHTO","m³",360]
["B4","Proof rolling & density testing","Item",1]
["Sub-Total B"]
[]
["C. KERBS & EDGING"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["C1","200×300 mm precast concrete kerbs both sides incl. bedding & backing","m",800]
["C2","Cutting & edging to paving","m",800]
["Sub-Total C"]
[]
["D. PAVING WORKS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["D1","25 mm paving sand layer","m³",60]
["D2","80 mm interlocking grey concrete pavers","m²",{"v":2400,"d":"2,400"}]
["D3","Joint filling with kiln‑dried sand & final compaction","m²",{"v":2400,"d":"2,400"}]
["Sub-Total D"]
[]
["E. TIE‑IN TO EXISTING TAR ROAD & STORMWATER"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["E1","Saw‑cut & break out existing tar","m",6]
["E2","Construct tie‑in detail between new paving & existing tar","Item",1]
["E3","Local drainage shaping at tie‑in","Item",1]
["E4","Ground channels & stormwater shaping along road edges","Item",1]
["Sub-Total E"]
[]
["F. TESTING & QUALITY CONTROL"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["F1","Density tests on G5 layers","Item",1]
["F2","Kerb concrete cube tests","Item",1]
["Sub-Total F"]
[]
["SUMMARY ACCESS ROAD"]
[]
[null,"Section",{"$nulls":3},"Amount (R)"]
[null,{"$f":"A3","v":"A. SITE CLEARANCE & EARTHWORKS"}]
[null,{"$f":"A13","v":"B. PAVEMENT LAYERS"}]
[null,{"$f":"A22","v":"C. KERBS & EDGING"}]
[null,{"$f":"A29","v":"D. PAVING WORKS"}]
[null,{"$f":"A37","v":"E. TIE‑IN TO EXISTING TAR ROAD & STORMWATER"}]
[null,{"$f":"A46","v":"F. TESTING & QUALITY CONTROL"}]
[]
["TOTAL CARRIED TO SUMMARY PAGE"]

{"sheet":"2-INTERNAL ROADS","index":3,"n_rows":63,"n_cols":6,"rows_kept":63,"merged":[[0,0,0,5],[1,0,1,5],[10,0,10,4],[12,0,12,5],[19,0,19,4],[21,0,21,5],[26,0,26,4],[28,0,28,5],[34,0,34,4],[36,0,36,5],[43,0,43,4],[45,0,45,5],[50,0,50,4],[51,0,51,4],[52,0,52,5],[53,1,53,4],[54,1,54,4],[55,1,55,4],[56,1,56,4],[57,1,57,4],[58,1,58,4],[59,1,59,4],[60,1,60,4],[62,0,62,4]]}
["INTERNAL ROADS"]
["A. SITE CLEARANCE & EARTHWORKS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["A1","Clear & grub 3 m × 1 400 m road reserve","m²",{"v":5100,"d":"5,100"}]
["A2","Strip topsoil 150 mm and stockpile","m³",765]
["A3","Shape & trim subgrade to 2% cross fall","m²",{"v":5100,"d":"5,100"}]
["A4","Compact subgrade to 93% Mod AASHTO","m²",{"v":5100,"d":"5,100"}]
["A5","Rock formation outcrop – break, remove & level (Provisional)","m³",182]
["A6","Minor cut/fill to achieve levels (Provisional)","m³",146]
["Sub-Total A"]
[]
["B. PAVEMENT LAYERS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["B1","150 mm Roadbed – Rip, level & compact to 95% Mod AASHTO","m²",{"v":5100,"d":"5,100"}]
["B2","150 mm G5 imported filling compacted to 90% Mod AASHTO","m³",765]
["B3","150 mm G5 imported subbase compacted to 93% Mod AASHTO","m³",765]
["B4","Proof rolling & density testing","Item",1]
["Sub-Total B"]
[]
["C. KERBS & EDGING"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["C1","200×300 mm precast concrete kerbs both sides incl. bedding & backing","m",{"v":3400,"d":"3,400"}]
["C2","Cutting & edging to paving","m",{"v":3400,"d":"3,400"}]
["Sub-Total C"]
[]
["D. PAVING WORKS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["D1","25 mm paving sand layer","m³",127.5]
["D2","60 mm interlocking grey concrete pavers","m²",{"v":5100,"d":"5,100"}]
["D3","Joint filling with kiln‑dried sand & final compaction","m²",{"v":5100,"d":"5,100"}]
["Sub-Total D"]
[]
["E. TIE‑IN TO EXISTING PAVED ROAD & STORMWATER"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["E1","Saw‑cut & break out existing paving","m",10]
["E2","Construct tie‑in detail between new paving & existing paving","Item",1]
["E3","Local drainage shaping at tie‑in","Item",1]
["E4","Ground channels & stormwater shaping along road edges","Item",1]
["Sub-Total E"]
[]
["F. TESTING & QUALITY CONTROL"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["F1","Density tests on G5 layers","Item",1]
["F2","Kerb concrete cube tests (if required)","Item",1]
["Sub-Total F"]
[]
["SUMMARY ACCESS ROAD"]
[]
[null,"Section",{"$nulls":3},"Amount (R)"]
[null,{"$f":"A2","v":"A. SITE CLEARANCE & EARTHWORKS"}]
[null,{"$f":"A13","v":"B. PAVEMENT LAYERS"}]
[null,{"$f":"A22","v":"C. KERBS & EDGING"}]
[null,{"$f":"A29","v":"D. PAVING WORKS"}]
[null,{"$f":"A37","v":"E. TIE‑IN TO EXISTING PAVED ROAD & STORMWATER"}]
[null,{"$f":"A46","v":"F. TESTING & QUALITY CONTROL"}]
[]
["TOTAL CARRIED TO SUMMARY PAGE"]

{"sheet":"3-CONCERVANCY TANKS","index":4,"n_rows":67,"n_cols":6,"rows_kept":67,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[10,0,10,4],[12,0,12,5],[23,0,23,4],[25,0,25,5],[36,0,36,4],[38,0,38,5],[44,0,44,4],[46,0,46,5],[53,0,53,4],[55,0,55,5],[57,0,57,5],[59,1,59,4],[60,1,60,4],[61,1,61,4],[62,1,62,4],[63,1,63,4],[64,1,64,4],[65,1,65,4],[66,0,66,4]]}
["CONSERVANCY TANK BOQ"]
[]
["A. EXCAVATION, ROCK & EARTHWORKS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["A1","Excavate in soft material for tank","m³",70]
["A2","Excavate in rock (50% of total)","m³",70]
["A3","Cart away surplus material","m³",87.5]
["A4","On-site filling/backfilling compacted","m³",70]
["A5","Compact formation under tank","m²",42]
["Sub-Total A"]
[]
["B. TANK STRUCTURE (CONCRETE + BRICKWORK)"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["B1","75 mm blinding concrete","m³",4]
["B2","150 mm reinforced concrete base slab","m³",7]
["B3","220 mm brick/block tank walls","m²",95]
["B4","20 mm internal plaster to tank walls","m²",95]
["B5","Cementitious waterproofing to walls & floor","m²",115]
["B6","150 mm reinforced concrete cover slab","m³",7]
["B7","Heavy-duty lockable access covers","No",7]
["B8","Internal ladder rungs","Item",4]
["Sub-Total B"]
[]
["C. PIPEWORK & CONNECTIONS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["C1","110 mm uPVC sewer pipes incl. bedding","m",{"$f":"60*4","v":240}]
["C2","160 mm uPVC main sewer line","m",{"$f":"30*4","v":120}]
["C3","110 mm uPVC fittings","Item",4]
["C4","160 mm uPVC fittings","Item",4]
["C5","Inspection eyes / rodding points","No",{"$f":"6*4","v":24}]
["C6","Precast manholes / inspection chambers","No",{"$f":"3*4","v":12}]
["C7","Inlet pipework incl. benching","Item",4]
["C8","Vacuum truck outlet connection","Item",4]
["Sub-Total C"]
[]
["D. VENTILATION & SAFETY"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["D1","110 mm vent pipe to 2.5 m height","Item",4]
["D2","Vent cowl & fly-screen","Item",4]
["D3","Safety signage & locking","Item",4]
["Sub-Total D"]
[]
["E. TESTING & REINSTATEMENT"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["E1","Water-tightness test","Item",4]
["E2","Testing & flushing of sewer lines","Item",4]
["E3","Reinstatement of surrounding area","Item",4]
["E4","Final cleaning & handover","Item",4]
["Sub-Total E"]
[]
["TOTAL PROJECT COST"]
[]
["SUMMARY CONSERVANCY TANKS"]
[]
[null,"Section",{"$nulls":3},"Amount (R)"]
[null,{"$f":"A3","v":"A. EXCAVATION, ROCK & EARTHWORKS"}]
[null,{"$f":"A13","v":"B. TANK STRUCTURE (CONCRETE + BRICKWORK)"}]
[null,{"$f":"A26","v":"C. PIPEWORK & CONNECTIONS"}]
[null,{"$f":"A39","v":"D. VENTILATION & SAFETY"}]
[null,{"$f":"A47","v":"E. TESTING & REINSTATEMENT"}]
[]
["TOTAL CARRIED TO SUMMARY PAGE"]

{"sheet":"4-SEWER LINES","index":5,"n_rows":84,"n_cols":6,"rows_kept":84,"merged":[[0,0,0,5],[2,0,2,5],[13,0,13,4],[15,0,15,5],[22,0,22,4],[24,0,24,5],[31,0,31,4],[33,0,33,5],[43,0,43,4],[45,0,45,5],[52,0,52,4],[54,0,54,5],[60,0,60,4],[62,0,62,5],[70,0,70,4],[72,0,72,5],[74,1,74,4],[75,1,75,4],[76,1,76,4],[77,1,77,4],[78,1,78,4],[79,1,79,4],[80,1,80,4],[81,1,81,4],[82,1,82,4],[83,0,83,4]]}
["SEWER LINES"]
[]
["A. EARTHWORKS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["A1","Clear and grub pipeline route","m",790]
["A2","Excavate trenches in soft material (50%)","m³",355]
["A3","Excavate trenches in hard rock (50%)","m³",355]
["A4","Trim, level and prepare trench bottoms","m",790]
["A5","Dispose surplus excavated material","m³",200]
["A6","Imported selected fill where required","m³",80]
["A7","Backfill and compact trenches","m³",511]
[]
["Sub-Total B"]
[]
["B. PIPE BEDDING"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["B1","River sand bedding 100mm below pipe","m³",53]
["B2","Selected sand surround to spring line","m³",47]
["B3","Warning tape above sewer line","m",790]
[]
["Sub-Total B "]
[]
["C. 110MM uPVC SEWER PIPELINE"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["C1","Supply and install 110mm uPVC Class 34 sewer pipe","m",790]
["C2","Pipe jointing and solvent welding","m",790]
["C3","Pipe laying, alignment and grading","m",790]
[]
["Sub-Total C "]
[]
["D. FITTINGS & CONNECTIONS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["D1","110mm Long radius bends","No",{"$f":"24*2","v":48}]
["D2","110mm Junctions/Y-pieces","No",{"$f":"16*2","v":32}]
["D3","110mm Couplers","No",{"$f":"40*2","v":80}]
["D4","110mm Inspection eyes","No",{"$f":"16*2","v":32}]
["D5","Connections into conservancy tanks","No",{"$f":"4*2","v":8}]
["D6","Flexible pipe couplings","No",{"$f":"8*2","v":16}]
[]
["Sub-Total D"]
[]
["E. MANHOLES"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["E1","1050mm dia precast manholes complete (1–2m deep)","No",22]
["E2","Class D heavy-duty manhole covers and frames","No",22]
["E3","Concrete benching and channels","No",22]
[]
["Sub-Total E "]
[]
["F. CONCRETE WORKS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["F1","Concrete encasement at road crossings","m",40]
["F2","Concrete thrust blocks and protection","m³",5]
[]
["Sub-Total F"]
[]
["G. TESTING & COMMISSIONING"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["G1","Sewer line flushing and cleaning","Item",1]
["G2","Water tightness testing","Item",1]
["G3","CCTV inspection allowance","Item","P Sum",{"v":65000,"d":"R65,000.00"},{"v":65000,"d":"R65,000.00"}]
["G4","Final commissioning and handover","Item",1]
[]
["Sub-Total G "]
[]
["PROJECT COST SUMMARY"]
[]
[null,"Section",{"$nulls":3},"Amount (R)"]
[null,{"$f":"A3","v":"A. EARTHWORKS"}]
[null,{"$f":"A16","v":"B. PIPE BEDDING"}]
[null,{"$f":"A25","v":"C. 110MM uPVC SEWER PIPELINE"}]
[null,{"$f":"A34","v":"D. FITTINGS & CONNECTIONS"}]
[null,{"$f":"A46","v":"E. MANHOLES"}]
[null,{"$f":"A55","v":"F. CONCRETE WORKS"}]
[null,{"$f":"A63","v":"G. TESTING & COMMISSIONING"}]
[]
["TOTAL CARRIED TO SUMMARY PAGE"]

{"sheet":"5-WATER NETWORK","index":6,"n_rows":180,"n_cols":6,"rows_kept":180,"merged":[[0,0,0,5],[2,0,2,5],[9,0,9,4],[12,0,12,5],[23,0,23,4],[25,0,25,5],[34,0,34,4],[36,0,36,5],[45,0,45,4],[47,0,47,5],[58,0,58,4],[60,0,60,5],[62,0,62,5],[69,0,69,4],[71,0,71,5],[81,0,81,4],[83,0,83,5],[95,0,95,4],[97,0,97,5],[106,0,106,4],[108,0,108,5],[116,0,116,4],[118,0,118,5],[127,0,127,4],[129,0,129,5],[136,0,136,4],[138,0,138,5],[148,0,148,4],[150,0,150,5],[159,0,159,4],[161,0,161,5],[163,1,163,4],[164,1,164,4],[165,1,165,4],[166,1,166,4],[167,1,167,4],[168,1,168,4],[169,1,169,4],[170,1,170,4],[171,1,171,4],[172,1,172,4],[173,1,173,4],[174,1,174,4],[175,1,175,4],[176,1,176,4],[177,1,177,4],[179,0,179,4]]}
["LODGE WATER RETICULATION, BOREHOLE, STORAGE & FIRE PROTECTION SYSTEM"]
[]
["A. PROVISIONALSUMS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["A1","Provisional Sum for Dealing with hard rocks","Item",1,{"v":250000,"d":"R250,000.00"},{"$f":"E6","v":{"v":250000,"d":"R250,000.00"}}]
["A2","Provisional Sum for Extra Surveying","Item",1,{"v":40000,"d":"R40,000.00"},{"$f":"E7","v":{"v":40000,"d":"R40,000.00"}}]
["A3","Provisional Sum for Extra Test Ordered by the Engineer","Item",1,{"v":30000,"d":"R30,000.00"},{"$f":"E8","v":{"v":30000,"d":"R30,000.00"}}]
[]
["Sub-Total A"]
[]
[]
["B. BOREHOLE EQUIPPING"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["B1","Stainless steel submersible pump complete","No",2]
["B2","Borehole rising main pipework","m",160]
["B3","Stainless steel safety cable","m",160]
["B4","Borehole headworks complete","No",2]
["B5","Non-return valves","No",2]
["B6","Isolation valves","No",2]
["B7","Bulk water meters","No",2]
[]
["Sub-Total B"]
[]
["C. AUTOMATION & CONTROL"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["C1","Automatic borehole control panel","No",1]
["C2","GSM telemetry system","No",1]
["C3","Tank level monitoring system","No",1]
["C4","Pressure monitoring equipment","Item",1]
["C5","Surge protection devices","Item",1]
[]
["Sub-Total C"]
[]
["D. ELECTRICAL INSTALLATION"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["D1","Power supply to boreholes","m",200]
["D2","Pump cabling and terminations","Item",1]
["D3","MCC and protection equipment","Item",1]
["D4","Earthing and lightning protection","Item",1]
["D5","Electrical testing and COC","Item",1]
[]
["Sub-Total D "]
[]
["E. EARTHWORKS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["E1","Site clearing along servitude","m",1200]
["E2","Trench excavation in soft material","m³",360]
["E3","Rock excavation (50%)","m³",360]
["E4","Imported bedding sand","m³",90]
["E5","Backfilling and compaction","m³",600]
["E6","Cart away surplus material","m³",120]
["E7","Warning tape","m",1200]
[]
["Sub-Total E "]
[]
["F. WATER RETICULATION PIPEWORK"]
[]
["50mm HDPE PE100 PN16"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["F1","Supply and install 50mm HDPE PE100 PN16","m",1200]
["F2","Pipe welding and jointing","m",1200]
["F3","Pressure testing","Item",1]
[]
["Sub-Total F "]
[]
["G. VALVES & FITTINGS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["G1","50mm gate valves","No",12]
["G2","50mm air release valves","No",6]
["G3","50mm non-return valves","No",6]
["G4","50mm washout valves","No",4]
["G5","Valve chambers","No",12]
["G6","Tees, bends, reducers and couplings","Item",1]
[]
["Sub-Total G "]
[]
["H. BUILDING CONNECTIONS (20 BUILDINGS)"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["H1","50mm HDPE tees","No",20]
["H2","50x20mm reducers","No",20]
["H3","20mm HDPE service pipe","m",200]
["H4","20mm brass shut-off valves","No",20]
["H5","20mm pressure reducing valves","No",20]
["H6","Valve boxes","No",20]
["H7","Meter connection points","No",20]
["H8","Compression fittings complete","Item",1]
[]
["Sub-Total H "]
[]
["I. 20,000L ELEVATED WATER TANK"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["I1","20,000L steel sectional water tank","No",1]
["I2","Internal ladder","No",1]
["I3","External ladder with cage","No",1]
["I4","Tank instrumentation","Item",1]
["I5","Overflow, scour and outlet fittings","Item",1]
[]
["Sub-Total I "]
[]
["J. 20M HIGH TANK STAND"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["J1","Excavation and foundations","Item",1]
["J2","Structural steel tower","Ton",8]
["J3","Fabrication and erection","Item",1]
["J4","Corrosion protection system","Item",1]
[]
["Sub-Total J "]
[]
["K. FIRE HYDRANT & BOOSTER PUMP"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["K1","Fire hydrant complete","No",1]
["K2","Hydrant valve chamber","No",1]
["K3","Booster pump set","No",1]
["K4","Fire pump control panel","No",1]
["K5","Suction and discharge pipework","Item",1]
[]
["Sub-Total K"]
[]
["L. FIRE HOSE REELS"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["L1","30m fire hose reel complete","No",5]
["L2","Connections and brackets","No",5]
["L3","Fire hose reel signage","No",5]
[]
["Sub-Total L "]
[]
["M. FIRE EXTINGUISHERS & SIGNAGE"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["M1","9kg DCP fire extinguishers","No",20]
["M2","Mounting brackets","No",20]
["M3","Fire extinguisher signs","No",20]
["M4","Directional emergency signs","No",40]
["M5","Assembly point signs","No",4]
["M6","Evacuation boards","No",4]
[]
["Sub-Total M"]
[]
["N. TESTING & COMMISSIONING"]
[]
["Item","Description","Unit","Qty","Rate (R)","Amount (R)"]
["N1","Hydrostatic testing","Item",1]
["N2","Flushing and disinfection","Item",1]
["N3","Fire system testing","Item",1]
["N4","Operator training","Item",1]
["N5","As-built drawings","Item",1]
[]
["Sub-Total N "]
[]
["PROJECT COST SUMMARY"]
[]
[null,"Section",{"$nulls":3},"Amount (R)"]
[null,{"$f":"A3","v":"A. PROVISIONALSUMS"}]
[null,{"$f":"A13","v":"B. BOREHOLE EQUIPPING"}]
[null,{"$f":"A26","v":"C. AUTOMATION & CONTROL"}]
[null,{"$f":"A37","v":"D. ELECTRICAL INSTALLATION"}]
[null,{"$f":"A48","v":"E. EARTHWORKS"}]
[null,{"$f":"A61","v":"F. WATER RETICULATION PIPEWORK"}]
[null,{"$f":"A72","v":"G. VALVES & FITTINGS"}]
[null,{"$f":"A84","v":"H. BUILDING CONNECTIONS (20 BUILDINGS)"}]
[null,{"$f":"A98","v":"I. 20,000L ELEVATED WATER TANK"}]
[null,{"$f":"A109","v":"J. 20M HIGH TANK STAND"}]
[null,{"$f":"A119","v":"K. FIRE HYDRANT & BOOSTER PUMP"}]
[null,{"$f":"A130","v":"L. FIRE HOSE REELS"}]
[null,{"$f":"A139","v":"M. FIRE EXTINGUISHERS & SIGNAGE"}]
[null,{"$f":"A151","v":"N. TESTING & COMMISSIONING"}]
[]
["TOTAL CARRIED TO SUMMARY PAGE"]

{"sheet":"SUMMARY","index":7,"n_rows":18,"n_cols":2,"rows_kept":18,"merged":[[0,0,0,2]]}
["PROJECT SUMMARY"]
[]
[1,"PRELIMINARY AND GENERAL"]
["2","ACCESS ROAD"]
[2,"INTERNAL ROADS"]
["3","CONSERVANCY TANKS"]
[3,"SEWER LINES"]
["4","WATER NETWORK"]
[]
["A","SUB TOTAL ( 1 + 2 + 3 + 4 + 5 + 6) "]
[]
["B","ADD 10% of CONTINGENCIES ( 10% of A)"]
[]
["C","SUB TOTAL ( A + B)"]
[]
["D","ADD 15% VAT ( 15% of C)"]
[]
["E","TOTAL TENDER AMOUNT CARRIED TO FORM OF OFFER (C+D) INCL VAT"]