{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Summary Turnkey","PG","Earthworks","Galvanised Fittings","HDPE","PVC","DRIP","Sprinkler","Filters","Non-SABS LDPE","Valves & Meters","Shadenet ","Tunnels","Centre Pivot","Building","Electricals & Plumning","Energy","Pumps & Controllers","Dams","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":30,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Summary Turnkey","index":0,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[4,0,4,4],[2,0,2,4]]}
["LIMPOPO DEPARTMENT OF AGRICULTURE AND RURAL DEVELOPMENT"]
[]
["FRAMEWORK AGREEMENT FOR DEVELOPMENT AND MAINTENANCE OF IRRIGATION PROJECTS"]
[]
["SUMMARY OF SCHEDULE OF QUANTITIES AND CALCULATION OF CONTRACT AMOUNT"]
["SECTION AND DESCRIPTION",null,null,null,"AMOUNT"]
[]
["SECTION A  : PRELIMINARY AND GENERAL"]
[]
["SECTION B: EARTHWORKS"]
[]
["SECTION C : STEEL PIPES AND FITTINGS"]
[]
["SECTION D : HDPE PIPES AND FITTINGS"]
[]
["SECTION E : PVC PIPES AND FITTINGS"]
[]
["SECTION F : DRIP IRRIGATION"]
[]
["SECTION G : SPRINKLER IRRIGATION"]
[]
["SECTION H : FILTERS & AIRVALVES"]
[]
["SECTION J : LDPE PIPES AND FITTINGS"]
[]
["SECTION K : VALVES & METERS"]
[]
["SECTION L : SHADENET"]
[]
["SECTION M : TUNNELS & RESEVOIRS"]
[]
["SECTION N: CENTRE PIVOTS IRRIGATION"]
[]
["SECTION P : BUILDING"]
[]
["SECTION R : ELECTRICALS AND PLUMBING"]
[]
["SECTION S : POWER GENERATION EQUIPMNET"]
[]
["SECTION T : PUMPS & MOTORS,CONTROLS & CABLES"]
[]
["SECTION U : DAMS"]
[]
["TOTAL SCHEDULE OF QUANTITIES"]
[]
["ADD 10% CONTINGENCIES"]
[]
["SUB TOTAL"]
[]
["ADD 15% VAT"]
[]
["TOTAL TENDER AMOUNT"]

{"sheet":"PG","index":1,"n_rows":110,"n_cols":7,"rows_kept":110,"cut":false,"hidden":false,"merged":[[109,2,109,5],[2,2,2,5],[3,2,3,5]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION A: PRELIMINARY & GENERAL"]
[null,null,"Note: Contractor to Hire at least 10 LOCAL personnel/labour at not less than R200/day labour rate for a 6 months Contract Period with Sub Total Task Order Amount of R3 000 000,00 before VAT and Contingencies"]
[null,null,"Note: For the purpose of costing, assume a 5 months construction period, with a total value of works (excl. P&G) of R3 000 000,00. "]
[]
["A.1","SANS 1200A","SCHEDULED FIXED-CHARGE AND VALUE RELATED ITEMS (Max. 5% of R 3000 000,00)"]
["A.1.1","8.3.1","Contractual Requirements","Sum",1]
[null,"8.3.2","Establishment of Facilities on Site"]
[null,"8.3.2.2","FACILITIES FOR CONTRACTOR"]
["A.1.2",null,"a) Offices and storage shed","Sum",1]
["A.1.3",null,"d) Living accommodation","Sum",1]
["A.1.4",null,"e) Ablution and Latrine Facilities","Sum",1]
["A.1.5",null,"f) Tools and equipment","Sum",1]
["A.1.6",null,"g) Water supplies, electrical power and communication","Sum",1]
["A.1.7","5,1,1","Setting out of the works","Sum",1]
["A.1.8","8.3.4","Removal of Site Establishment","Sum",1]
[]
[null,"8.4","SCHEDULED TIME-RELATED ITEMS (Max. 5% of R 3000 000,00)"]
["A.1.9","8.4.1","Contractual Requirements","Sum",1]
["A.1.10",null,"Insurance of the works","Sum",1]
[null,"8.4.2","Operation and Maintenance of Facilities on Site"]
[null,"8.4.2.2","FACILITIES FOR CONTRACTOR"]
["A.1.11",null,"a) Offices and storage shed","Sum",1]
["A.1.12",null,"d) Living accommodation","Sum",1]
["A.1.13",null,"e) Ablution and Latrine Facilities","Sum",1]
["A.1.14",null,"f) Tools and equipment","Sum",1]
["A.1.15",null,"g) Water supplies, electrical power and communication","Sum",1]
["A.1.16","8.4.3","Supervision for Duration of Construction","Sum",1]
["A",null,"Carried forward"]
["A",null,"Brought forward"]
[null,8.5,"SUMS STATED PROVISIONALLY BY ENGINEER"]
["A.1.17","8.5 (b)","a)  Topgraphical Survey","Prov Sum",1,15000,"Rate only"]
["A.1.18",null,"b)  Remuneration of Community Liaison Officer  (CLO)","Prov Sum",1,{"$f":"6500*5","v":32500},"Rate only"]
["A.1.19",null,"c)  Overheads, charges and profit on a) to  b) above","%",{"$f":"SUM(F32:F33)","v":47500}]
[]
[null,null,"OCCUPATIONAL HEALTH AND SAFETY "]
["A.1.20",null,"Contractor’s initial obligations in respect of  the Occupational Health and Safety Act and Construction Regulations","Sum ",1]
["A.1.21",null,"Contractor’s time related obligations in respect of the Occupational Health and Safety Act and Construction Regulations","Month",5]
["A.1.22",null,"Submission of the Health and Safety File  ","Sum ",1]
["A.1.23",null,"Dust suppression by water spraying construction site, with 10 000L Tanker","Day",1]
["A.1.24",null,"SANS approved weld mesh type temporary barrier fencing 1,8m high covered with a net fixed to and including 100mm diameter gum poles set securely min 300mm deep in ground at max 3m spacing including excavation, backfilling, etc","m",200]
["A.1.25",null,"Extra over mesh fence for pedestrian gate size 1.8 x 1,8m high.","No",1]
[null,null,"Provision for Personal Protective Equipment and Protective Clothing per each person:"]
["A.1.26",null,"Reflective vests.","No",10]
["A.1.27",null,"Hard hats.","No",10]
["A.1.28",null,"Protective foot wear.","No",10]
["A.1.29",null,"Ear Plugs.","No",10]
["A.1.30",null,"Dust Masks.","No",10]
["A.1.31",null,"Working suite - jacket and pants","No",10]
[null,null,"Costs of Medical Certificates and Medical Surveillance:"]
["A.1.32",null,"Entry medical fitness examinations per employee","No",10]
["A.1.33",null,"Respiritory prevention kit allocation and routine screening ","No",10]
["A.1.34",null,"Exit Examinations per employee","No",10]
[]
["A",null,"Carried forward"]
["A",null,"Brought forward"]
[null,"SANS 1200A","DAYWORKS "]
["A.2",8.6999999999999993,"Daywork Labour ",null,""]
["A.2.1",null,"Contractor's Representative","hour",1]
["A.2.2",null," Surveyor ","hour",1]
["A.2.3",null," Irrigation engineer","hour",1]
["A.2.4",null," Plumber","hour",1]
["A.2.5",null," Boilermaker","hour",1]
["A.2.6",null," Bricklayer","hour",1]
["A.2.7",null," Plasterer","hour",1]
["A.2.8",null," Welder with API 1104 Certificate","hour",1]
["A.2.9",null," Electrician","hour",1]
["A.2.10",null," Semi-skilled labourer","hour",1]
["A.2.11",null," Labourer","hour",1]
[]
["A,3",8.6999999999999993,"Plant hire  :  Work Rates on Site ",null,""]
["A.3.1",null,"Crane 20 t - 35 t capacity ","hour",1]
["A.3.2",null,"Tractor 60 kW - 90 kW ","hour",1]
["A.3.3",null,"TLB 60 kW - 70 kW ","hour",1]
["A.3.4",null,"Motor graders 150 kW - 160 kW ","hour",1]
["A.3.6",null,"Wheel excavators 0,4 - 1,25m³ bucket size ","hour",1]
["A.3.7",null,"Water tankers 4 000  - 20 000 litre ","hour",1]
["A.3.8",null,"Drilling rig up to 200 metres","hour",1]
["A.3.9",null,"Borehole Testing equipment up 10 litres/s","hour",1]
["A.3.10",null,"Dumpers 0,5m³ (Hydraulic tip) ","hour",1]
["A.3.11",null,"Mono pump with 80mm DN outlet (diesel driven) 2.2 - 7.5 kW","hour",1]
["A.3.12",null,"Arc-welding unit (300 A) ","hour",1]
["A.3.13",null,"10 kVA (petrol) 220V Generator","hour",1]
["A.3.14",null,"30 kVA (diesel) 380V - 3ph Generator","hour",1]
["A",null,"Carried forward"]
["A",null,"Brought forward"]
["A,4",null,"TRAINING AND OTHER MARKUPS"]
["A.4.1",null,"SUMS STATED PROVISIONALLY BY ENGINEER (Employer)"]
["A.4.2",null,"SABI ACCREDITED TRAINING"]
["A.4.3",null,"Provision of M1 - Basic principles and installation of irrigation systems by an SABI accredited training service provider / institute (25 People)","Sum",1,150000,"Rate only"]
["A.4.4",null,"Provision of M2 - Irrigation Scheduling and management of irrigation systems an SABI accredited training service provider / institute (5 People)","Sum",1,60000,"Rate only"]
["A.4.5",null,"Provision of refresher training on the irrigation equipment installed. Training to be done by the Supplier of an SABI accredited training service provider / institue","Sum",1,40000,"Rate only"]
["A.4.6",null,"Training allowance for direct payments to targeted labour in terms of formal training days","Sum",1,30000,"Rate only"]
["A.4.7",null,"Transport & accommodation of workers for training where it is not possible to undertake the training in close proximity to the site","Sum",1,20000,"Rate only"]
["A.4.8",null,"Extra over A.4.3 to A.4.7 above for the administration payment of training, allowances transport and venue arrangements","%",{"$f":"SUM(F90:F94)","v":300000}]
[]
["A,5",null,"Mark up on other specialists services"]
["A.5.1",null,"Geohydrological services","PC sum",100000,1,"Rate only"]
[null,null,"Mark up on above","%",{"$f":"E98","v":100000},null,{"$f":"F99*E99","v":0}]
["A.5.2",null,"Electrical and mechanical engineering services","PC sum",100000,1,"Rate only"]
[null,null,"Mark up on above","%",{"$f":"E100","v":100000},null,{"$f":"F101*E101","v":0}]
["A.5.3",null,"Geotechnical services","PC sum",100000,1,"Rate only"]
[null,null,"Mark up on above","%",{"$f":"E102","v":100000},null,0]
["A.5.4",null,"Agricultural Engineering (Anciliry works)","PC sum",100000,1,"Rate only"]
[null,null,"Mark up on above","%",{"$f":"E104","v":100000},null,0]
["A.5.5",null,"Provision of Operation and maintenance manual for Irrigation Development Works","PC sum",20000,1,"Rate only"]
[null,null,"Mark up on above","%",{"$f":"E106","v":20000},null,0]
["A.5.6",null,"Structural engineering services","PC sum",100000,1,"Rate only"]
[null,null,"Mark up on above","%",{"$f":"E108","v":100000},null,0]
[null,null,"TOTAL SECTION \"A\" CARRIED FORWARD TO SUMMARY"]

{"sheet":"Earthworks","index":2,"n_rows":74,"n_cols":7,"rows_kept":74,"cut":false,"hidden":false,"merged":[[73,2,73,5]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION B: EARTHWORKS"]
["B.1",null,"SITE CLEARANCE"]
["B.1.1",null,"Clear and grub site including vegetation, trees and tree stumps of girth up to 1m  ","m2",1]
["B.1.2",null,"Clear and grub vegetation on the pipeline path, 2m wide clearing","m",1]
["B.1.3",null,"De-bushing of virgin land with congested high dense bush/trees","ha",1]
["B.1.4",null,"De-bushing of virgin land with scattered bush/trees","ha",1]
[null,null,"Remove Topsoil "]
["B.1.5",null,"Strip to 150 mm deep x 1 m wide on single pipe and 2 m wide on double on pipeline centre line, stockpile and prevent dust ","m²",2000]
[]
[null,null,"Dams De-Silting"]
["B.1.6",null,"Removal of silt in dam basin including free haul of 2km and dumping on approved site as per Engineers instruction.","m³",100]
[]
[null,null,"Keeping excavations free of water:"]
["B.1.7",null,"Keeping excavations free from mud and storm water ","Sum",1]
["B.1.8",null,"Handling and Keeping excavations free from subterranean sources.","Sum",1]
[]
["B.2","SANS 1200D","EXCAVATION"]
["B.2.1",null,"Excavations in all materials for trenches to a depth less than1000 mm for removal of unsuitable material  and dispose of material for 600mm wide trenches","m",1]
["B.2.2",null,"Excavations in all materials for trenches to a depth less than 1000 mm for removal of unsuitable material  and dispose of material for 800mm wide trenches","m",1]
["B.2.3",null,"Excavations in all materials for trenches to a depth less than 1500 mm for removal of unsuitable material  and dispose of material for 600mm wide trenches","m",1]
["B.2.4",null,"Excavations in all materials for trenches to a depth less 1500 mm for removal of unsuitable material  and dispose of material for 800mm wide trenches","m",1]
["B.2.5",null,"Excavations in all materials for trenches to a depth over 1500 mm for removal of unsuitable material  and dispose of material for 600mm wide trenches","m",1]
["B",null,"Carried forward"]
["B",null,"Brought forward"]
["B.2.6",null,"Excavations in all materials for trenches to a depth over 1500 mm for removal of unsuitable material  and dispose of material for 800mm wide trenches","m",1]
[]
["B.2.7",null,"Extra-over Item above (Items B.2.1 - B.2.6)"]
["B.2.8",null,"Intermediate excavations","mᶾ",1]
["B.2.9",null,"Hard excavations","mᶾ",1]
["B.2.10",null,"Boulder excavation, Class A","mᶾ",1]
["B.2.11",null,"Boulder excavation, Class B","mᶾ",1]
[]
[null,null,"BEDDING (PIPES) "]
[null,null,"Provision of bedding from trench excavation:"]
["B.2.12",null,"Selected granular material","m³",1]
["B.2.13",null,"Selected fill material","m³",1]
[]
[null,null,"Supply only of bedding by importation From other necessary excavations (Provisional)"]
["B.2.14",null,"Selected granular material","m³",1]
["B.2.15",null,"Selected fill material","m³",1]
[]
[null,null,"Dealing with Services that intersect a trench to complete works:"]
["B.2.16",null,"Stock fences","No",1]
["B.2.17",null,"Water Pipes","No",1]
["B.2.18",null,"Roads","No",1]
["B.2.19",null,"Power cables","No",1]
[]
[null,null,"Finishing"]
[null,null,"Reinstate road surfaces complete with all courses:"]
["B.2.20",null,"Gravel road surfaces","m²",1]
["B.2.21",null,"Paved road surfaces","m²",1]
[]
["B",null,"Carried forward"]
["B",null,"Brought forward"]
["B.3",null,"Soil Preparation "]
["B.3.1",null,"Plough land earmarked for irrigation to a depth of 300 mm","ha",1]
["B.3.2",null,"Disk land earmarked for irrigation ","ha",1]
["B.3.3",null,"Rip the land earmarked for irrigaion to a depth of 600 mm, One way ","ha",1]
["B.3.4",null,"Rip the land earmarked for irrigaion to a depth of 600 mm, 2nd Cross Ripping at 45deg ","ha",1]
["B.3.5",null,"Vegetable crops ridges making with less than 0,5m wide width and 0,5m height in the field ","ha",1]
["B.3.6",null,"Citrus ochard ridges making with over 1m wide width and 1m height in the field ","ha",1]
["B.3.7",null,"Extra over above for operations under Shadenets and Tunnels (Items B.3.1 - B.3.6)","ha",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL SECTION \"B\" CARRIED FORWARD TO SUMMARY",null,null,null,{"$f":"SUM(G3:G66)","v":0}]

{"sheet":"Galvanised Fittings","index":3,"n_rows":337,"n_cols":7,"rows_kept":337,"cut":false,"hidden":false,"merged":[[2,2,2,5],[336,2,336,5]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION C : STEEL PIPES AND FITTINGS"]
["C",null,"Supply, deliver,install and test the following steel pipes, fittings and specials complete with gaskets, bolts, nuts and washers. Conforming to SABS 719, SABS 62-1989 and BS534. All steel pipes and fittings to have a wall thickness of 4.5mm and galvanized according to specification SABS 1461 and SABS ISO 14713. All flanges Table D"]
[]
["C.1",null,"Barrel Nipple"]
["C.1.1",null,"40 mm","no",1]
["C.1.2",null,"50 mm","no",1]
["C.1.3",null,"65 mm","no",1]
["C.1.4",null,"80 mm","no",1]
["C.1.5",null,"100 mm","no",1]
[]
["C.2",null,"Nipple Galvanised Hexagonal"]
["C.2.1",null,"40 mm","no",1]
["C.2.2",null,"50 mm","no",1]
["C.2.3",null,"65 mm","no",1]
["C.2.4",null,"80 mm","no",1]
["C.2.5",null,"100 mm","no",1]
[]
["C.3",null,"Elbow Galvanised Female/Female 900"]
["C.3.1",null,"40 mm","no",1]
["C.3.2",null,"50 mm","no",1]
["C.3.3",null,"65 mm","no",1]
["C.3.4",null,"80 mm","no",1]
["C.3.5",null,"100 mm","no",1]
[]
["C.4",null,"Elbow Galvanised Male/Female 900"]
["C.4.1",null,"40 mm","no",1]
["C.4.2",null,"50 mm","no",1]
["C.4.3",null,"65 mm","no",1]
["C",null,"Brought forward"]
["C",null,"Brought forward"]
["C.4.4",null,"80 mm","no",1]
["C.4.5",null,"100 mm","no",1]
[]
["C.5",null,"Elbow Galvanised Gemale/Female 45"]
["C.5.1",null,"40 mm","no",1]
["C.5.2",null,"50 mm","no",1]
["C.5.3",null,"65 mm","no",1]
["C.5.4",null,"80 mm","no",1]
["C.5.5",null,"100 mm","no",1]
[]
["C.6",null,"Coupling galvanised swage"]
["C.6.1",null,"40 mm","no",1]
["C.6.2",null,"50 mm","no",1]
["C.6.3",null,"65 mm","no",1]
["C.6.4",null,"80 mm","no",1]
["C.6.5",null,"100 mm","no",1]
[]
["C.7",null,"Crosses galvanised"]
["C.7.1",null,"40 mm","no",1]
["C.7.2",null,"50 mm","no",1]
["C.7.3",null,"65 mm","no",1]
["C.7.4",null,"80 mm","no",1]
["C.7.5",null,"100 mm","no",1]
[]
["C.8",null,"Backnut galvanised"]
["C.8.1",null,"40 mm","no",1]
["C.8.2",null,"50 mm","no",1]
["C.8.3",null,"65 mm","no",1]
["C.8.4",null,"80 mm","no",1]
["C",null,"Brought forward"]
["C",null,"Brought forward"]
["C.8.5",null,"100 mm","no",1]
[]
["C.9",null,"Union galvanised conical"]
["C.9.1",null,"40 mm","no",1]
["C.9.2",null,"50 mm","no",1]
["C.9.3",null,"65 mm","no",1]
["C.9.4",null,"80 mm","no",1]
["C.9.5",null,"100 mm","no",1]
[]
["C.10",null,"Union galvanised conical"]
["C.10.1",null,"40 mm","no",1]
["C.10.2",null,"50 mm","no",1]
["C.10.3",null,"65 mm","no",1]
["C.10.4",null,"80 mm","no",1]
["C.10.5",null,"100 mm","no",1]
[]
["C.11",null,"Coupling Galvanised Johnson"]
["C.11.1",null,"40 mm","no",1]
["C.11.2",null,"50 mm","no",1]
["C.11.3",null,"65 mm","no",1]
["C.11.4",null,"80 mm","no",1]
["C.11.5",null,"100 mm","no",1]
[]
["C.12",null,{"$f":"PROPER(\"NIPPLE GALVANISED LONGSCREW\")","v":"Nipple Galvanised Longscrew"}]
["C.12.1",null,"40 mm","no",1]
["C.12.2",null,"50 mm","no",1]
["C.12.3",null,"65 mm","no",1]
["C.12.4",null,"80 mm","no",1]
["C.12.5",null,"100 mm","no",1]
["C",null,"Carried forward"]
["C",null,"Brought forward"]
["C.13",null,{"$f":"PROPER(\"ADAPTOR GALVANISED SWAGE\")","v":"Adaptor Galvanised Swage"}]
["C.13.1",null,"40 mm","no",1]
["C.13.2",null,"50 mm","no",1]
["C.13.3",null,"65 mm","no",1]
["C.13.4",null,"80 mm","no",1]
["C.13.5",null,"100 mm","no",1]
[]
["C.14",null,"Plug Galvanised Hollow"]
["C.14.1",null,"40 mm","no",1]
["C.14.2",null,"50 mm","no",1]
["C.14.3",null,"65 mm","no",1]
["C.14.4",null,"80 mm","no",1]
["C.14.5",null,"100 mm","no",1]
[]
["C.15",null,"Socket Galvanised"]
["C.15.1",null,"40 mm","no",1]
["C.15.2",null,"50 mm","no",1]
["C.15.3",null,"65 mm","no",1]
["C.15.4",null,"80 mm","no",1]
["C.15.5",null,"100 mm","no",1]
[]
["C.16",null,"Endcap Galvanised "]
["C.16.1",null,"40 mm","no",1]
["C.16.2",null,"50 mm","no",1]
["C.16.3",null,"65 mm","no",1]
["C.16.4",null,"80 mm","no",1]
["C.16.5",null,"100 mm","no",1]
[]
[]
["C",null,"Carried forward"]
["C",null,"Brought forward"]
["C.17",null,"Holderbat Galvanised"]
["C.17.1",null,"40 mm","no",1]
["C.17.2",null,"50 mm","no",1]
["C.17.3",null,"65 mm","no",1]
["C.17.4",null,"80 mm","no",1]
["C.17.5",null,"100 mm","no",1]
[]
["C.18",null,"Socket Galvanised Sprinkler"]
["C.18.1",null,"20 mm","no",1]
["C.18.2",null,"25 mm","no",1]
["C.18.3",null,"32 mm","no",1]
["C.18.4",null,"40 mm","no",1]
["C.18.5",null,"50 mm","no",1]
["C.18.6",null,"65 mm","no",1]
["C.18.7",null,"80 mm","no",1]
["C.18.8",null,"100 mm","no",1]
[]
["C.19",null,"Tee Galvanised"]
["C.19.1",null,"40 mm","no",1]
["C.19.2",null,"50 mm","no",1]
["C.19.3",null,"65 mm","no",1]
["C.19.4",null,"80 mm","no",1]
["C.19.5",null,"100 mm","no",1]
[]
["C.20",null,"Socket Steel"]
["C.20.1",null,"40 mm","no",1]
["C.20.2",null,"50 mm","no",1]
["C.20.3",null,"65 mm","no",1]
["C.20.4",null,"80 mm","no",1]
["C",null,"Carried forward"]
["C",null,"Brought forward"]
["C.20.5",null,"100 mm","no",1]
[]
["C.21",null,"Socket Galvanised Reducing"]
["C.21.1",null,"40x25mm","no",1]
["C.21.2",null,"40x32mm","no",1]
["C.21.3",null,"50x25mm","no",1]
["C.21.4",null,"50x32mm","no",1]
["C.21.5",null,"50x40mm","no",1]
["C.21.6",null,"65x25mm","no",1]
["C.21.7",null,"65x32mm","no",1]
["C.21.8",null,"65x40mm","no",1]
["C.21.9",null,"65x50mm","no",1]
["C.21.10",null,"80x40mm","no",1]
[]
["C.22",null,"Tee Galvanised Reducing"]
["C.22.1",null,"40x25mm","no",1]
["C.22.2",null,"40x32mm","no",1]
["C.22.3",null,"50x25mm","no",1]
["C.22.4",null,"50x32mm","no",1]
["C.22.5",null,"50x40mm","no",1]
["C.22.6",null,"65x25mm","no",1]
["C.22.7",null,"65x32mm","no",1]
["C.22.8",null,"65x40mm","no",1]
["C.22.9",null,"65x50mm","no",1]
["C.22.10",null,"80x40mm","no",1]
[]
["C.23",null,"Standpipe Galvanised"]
["C.23.1",null,"25mm x 150mm","no",1]
["C.23.2",null,"25mm x 200mm","no",1]
["C",null,"Carried forward"]
["C",null,"Brought forward"]
["C.23.3",null,"25mm x 300mm","no",1]
["C.23.4",null,"25mm x 400mm","no",1]
["C.23.5",null,"25mm x 450mm","no",1]
["C.23.6",null,"25mm x 500mm","no",1]
["C.23.7",null,"25mm x 600mm","no",1]
["C.23.8",null,"25mm x 750mm","no",1]
["C.23.9",null,"25mm x 900mm","no",1]
["C.23.10",null,"25mm x 1000mm","no",1]
["C.23.11",null,"32mm x 150mm","no",1]
["C.23.12",null,"32mm x 200mm","no",1]
["C.23.13",null,"32mm x 300mm","no",1]
["C.23.14",null,"32mm x 400mm","no",1]
["C.23.15",null,"32mm x 450mm","no",1]
["C.23.16",null,"32mm x 500mm","no",1]
["C.23.17",null,"32mm x 600mm","no",1]
["C.23.18",null,"32mm x 750mm","no",1]
["C.23.19",null,"32mm x 900mm","no",1]
["C.23.20",null,"32mm x 1000mm","no",1]
["C.23.21",null,"40mm x 150mm","no",1]
["C.23.22",null,"40mm x 200mm","no",1]
["C.23.23",null,"40mm x 300mm","no",1]
["C.23.24",null,"40mm x 400mm","no",1]
["C.23.25",null,"40mm x 450mm","no",1]
["C.23.26",null,"40mm x 500mm","no",1]
["C.23.27",null,"40mm x 600mm","no",1]
["C.23.28",null,"40mm x 750mm","no",1]
["C.23.29",null,"40mm x 900mm","no",1]
["C.23.30",null,"40mm x 1000mm","no",1]
["C.23.31",null,"50mm x 150mm","no",1]
["C",null,"Carried forward"]
["C",null,"Brought forward"]
["C.23.32",null,"50mm x 200mm","no",1]
["C.23.33",null,"50mm x 300mm","no",1]
["C.23.34",null,"50mm x 400mm","no",1]
["C.23.35",null,"50mm x 450mm","no",1]
["C.23.36",null,"50mm x 500mm","no",1]
["C.23.37",null,"50mm x 600mm","no",1]
["C.23.38",null,"50mm x 750mm","no",1]
["C.23.39",null,"50mm x 900mm","no",1]
["C.23.40",null,"50mm x 1000mm","no",1]
["C.23.41",null,"65mm x 150mm","no",1]
["C.23.42",null,"65mm x 200mm","no",1]
["C.23.43",null,"65mm x 300mm","no",1]
["C.23.44",null,"65mm x 400mm","no",1]
["C.23.45",null,"65mm x 450mm","no",1]
["C.23.46",null,"65mm x 500mm","no",1]
["C.23.47",null,"65mm x 600mm","no",1]
["C.23.48",null,"65mm x 750mm","no",1]
["C.23.49",null,"65mm x 900mm","no",1]
["C.23.50",null,"65mm x 1000mm","no",1]
["C.23.51",null,"80mm x 150mm","no",1]
["C.23.52",null,"80mm x 200mm","no",1]
["C.23.53",null,"80mm x 300mm","no",1]
["C.23.54",null,"80mm x 400mm","no",1]
["C.23.55",null,"80mm x 450mm","no",1]
["C.23.56",null,"80mm x 500mm","no",1]
["C.23.57",null,"80mm x 600mm","no",1]
["C.23.58",null,"80mm x 750mm","no",1]
["C.23.59",null,"80mm x 900mm","no",1]
["C.23.60",null,"80mm x 1000mm","no",1]
["C",null,"Carried forward"]
["C",null,"Brought forward"]
["C.23.61",null,"100mm x 150mm","no",1]
["C.23.62",null,"100mm x 200mm","no",1]
["C.23.63",null,"100mm x 300mm","no",1]
["C.23.64",null,"100mm x 400mm","no",1]
["C.23.65",null,"100mm x 450mm","no",1]
["C.23.66",null,"100mm x 500mm","no",1]
["C.23.67",null,"100mm x 600mm","no",1]
["C.23.68",null,"100mm x 750mm","no",1]
["C.23.69",null,"100mm x 900mm","no",1]
["C.23.70",null,"100mm x 1000mm","no",1]
[]
["C.24",null,"Flange Screwed "]
["C.24.1",null,"40mm","no",1]
["C.24.2",null,"50mm","no",1]
["C.24.3",null,"65mm","no",1]
["C.24.4",null,"80mm","no",1]
["C.24.5",null,"100mm","no",1]
[]
["C.25",null,"Flange Screwed On "]
["C.25.1",null,"40mm","no",1]
["C.25.2",null,"50mm","no",1]
["C.25.3",null,"65mm","no",1]
["C.25.4",null,"80mm","no",1]
["C.25.5",null,"100mm","no",1]
[]
["C.26",null,"Flange Weld On "]
["C.26.1",null,"40mm","no",1]
["C.26.2",null,"50mm","no",1]
["C.26.3",null,"65mm","no",1]
["C",null,"Carried forward"]
["C",null,"Brought forward"]
["C.26.4",null,"80mm","no",1]
["C.26.5",null,"100mm","no",1]
[]
["C.27",null,"Flange Weld On (Table 1600/3)"]
["C.27.1",null,"50mm","no",1]
["C.27.2",null,"65mm","no",1]
["C.27.3",null,"80mm","no",1]
["C.27.4",null,"100mm","no",1]
[]
["C.28",null,"Back Ring (Used With UPV Stubs) "]
["C.28.1",null,"50mm","no",1]
["C.28.2",null,"65mm","no",1]
["C.28.3",null,"80mm","no",1]
["C.28.4",null,"100mm","no",1]
[]
["C.29",null,"Insertion Ring Gasket"]
["C.29.1",null,"50mm","no",1]
["C.29.2",null,"65mm","no",1]
["C.29.3",null,"80mm","no",1]
["C.29.4",null,"100mm","no",1]
[]
["C.30",null,"Insertion Ring Full Face Gasket"]
["C.30.1",null,"50mm","no",1]
["C.30.2",null,"65mm","no",1]
["C.30.3",null,"80mm","no",1]
["C.30.4",null,"100mm","no",1]
[]
["C.31",null,"Galvanised steel pipe "]
["C.31.1",null,"40 mm","m",1]
["C",null,"Carried forward"]
["C",null,"Brought forward"]
["C.31.2",null,"50 mm","m",1]
["C.31.3",null,"65 mm","m",1]
["C.31.4",null,"80 mm","m",1]
["C.31.5",null,"100 mm","m",1]
[]
["C.32",null,"Galvanised steel quick coupling perrot pipe"]
["C.32.1",null,"50 mm","m",1]
["C.32.2",null,"70 mm","m",1]
["C.32.3",null,"89 mm","m",1]
["C.32.4",null,"108 mm","m",1]
["C.32.5",null,"159 mm","m",1]
[]
["C.33",null,"Galvanised steel Special fittings"]
["C.33.1",null,"Allow a sum for fabrication of special galvanised steel pipes as specified by the Engineer.                           (3 Quotations from reputable suppliers)","Prov sum",1,10000,{"$f":"F324","v":10000}]
["C.33.2",null,"Profit over above Item C.33.1","%",10000]
["C.33.3",null,"Extra over Item C.33.2: Deliver,install and test fabricated special galvanised steel pipes.","Sum",1]
[]
["C.34",null,"Other Galvanised Steel Pipes and Fittings"]
["C.34.1",null,"Other Galvanised Steel Pipes and Fittings not priced in the above Items. Mark up on other pipes & fitting as specified by the Engineer (3 Quotations from reputable suppliers)","Prov sum",1,10000,{"$f":"F329","v":10000}]
["C.34.2",null,"Mark up on other Galvanised Steel Pipes and Fittings for Item C.34.1","%",10000]
["C.34.3",null,"Extra over Item C.34.2: Deliver,install and test other Galvanised Steel Pipes and Fittings","Sum",1]
[]
[]
[]
[]
[]
[null,null,"TOTAL SECTION \"C\" CARRIED FORWARD TO SUMMARY"]

{"sheet":"HDPE","index":4,"n_rows":263,"n_cols":7,"rows_kept":263,"cut":false,"hidden":false,"merged":[[262,2,262,5]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION D : HDPE PIPES AND FITTINGS"]
["D",null,"Supply, deliver,install and test the following SABS approved HDPE pipes, fittings."]
[]
["D.1",null,"Coupling Compression"]
["D.1.4",null,"32mm","no",1]
["D.1.5",null,"40mm","no",1]
["D.1.6",null,"50mm","no",1]
["D.1.7",null,"63mm","no",1]
["D.1.8",null,"75mm","no",1]
["D.1.9",null,"90mm","no",1]
[]
["D.2",null,"Endcap Compression"]
["D.2.4",null,"32mm","no",1]
["D.2.5",null,"40mm","no",1]
["D.2.6",null,"50mm","no",1]
["D.2.7",null,"63mm","no",1]
["D.2.8",null,"75mm","no",1]
["D.2.9",null,"90mm","no",1]
[]
["D.3",null,"Equal Tee Compression"]
["D.3.4",null,"32mm","no",1]
["D",null,"Carried forward"]
["D",null,"Brought forward"]
["D.3.5",null,"40mm","no",1]
["D.3.6",null,"50mm","no",1]
["D.3.7",null,"63mm","no",1]
["D.3.8",null,"75mm","no",1]
["D.3.9",null,"90mm","no",1]
[]
["D.4",null,"Elbow Compression"]
["D.4.4",null,"32mm","no",1]
["D.4.5",null,"40mm","no",1]
["D.4.6",null,"50mm","no",1]
["D.4.7",null,"63mm","no",1]
["D.4.8",null,"75mm","no",1]
["D.4.9",null,"90mm","no",1]
[]
["D.5",null,"Male Adaptors"]
["D.5.8",null,"32mm x 25mm","no",1]
["D.5.9",null,"32mm x 32mm","no",1]
["D.5.10",null,"40mm x 25mm","no",1]
["D.5.11",null,"40mm x 32mm","no",1]
["D",null,"Carried forward"]
["D",null,"Brought forward"]
["D.5.12",null,"40mm x 40mm","no",1]
["D.5.13",null,"50mm x 32mm","no",1]
["D.5.14",null,"50mm x 40mm","no",1]
["D.5.15",null,"50mm x 50mm","no",1]
["D.5.16",null,"63mm x 40mm","no",1]
["D.5.17",null,"63mm x 50mm","no",1]
["D.5.18",null,"63mm x 65mm","no",1]
["D.5.19",null,"75mm x 50mm","no",1]
["D.5.20",null,"75mm x 65mm","no",1]
["D.5.21",null,"75mm x 80mm","no",1]
["D.5.22",null,"90mm x 50mm","no",1]
["D.5.23",null,"90mm x 65mm","no",1]
["D.5.24",null,"90mm x 80mm","no",1]
["D.5.25",null,"110mm x 80mm","no",1]
["D.5.26",null,"110mm x 100mm","no",1]
[]
["D.6",null,"Female Adaptors"]
["D.6.8",null,"32mm x 25mm","no",1]
["D.6.9",null,"32mm x 32mm","no",1]
["D.6.10",null,"40mm x 25mm","no",1]
["D.6.11",null,"40mm x 32mm","no",1]
["D.6.12",null,"40mm x 40mm","no",1]
["D",null,"Carried forward"]
["D",null,"Brought forward"]
["D.6.13",null,"50mm x 32mm","no",1]
["D.6.14",null,"50mm x 40mm","no",1]
["D.6.15",null,"50mm x 50mm","no",1]
["D.6.16",null,"63mm x 40mm","no",1]
["D.6.17",null,"63mm x 50mm","no",1]
["D.6.18",null,"75mm x 50mm","no",1]
["D.6.19",null,"75mm x 65mm","no",1]
["D.6.20",null,"75mm x 80mm","no",1]
["D.6.21",null,"90mm x 50mm","no",1]
["D.6.22",null,"90mm x 65mm","no",1]
["D.6.23",null,"90mm x 80mm","no",1]
["D.6.24",null,"110mm x 80mm","no",1]
["D.6.25",null,"110mm x 100mm","no",1]
[]
["D.7",null,"Reducing Coupling"]
["D.7.4",null,"40mm x 25mm","no",1]
["D.7.5",null,"40mm x 32mm","no",1]
["D.7.6",null,"50mm x 32mm","no",1]
["D.7.7",null,"50mm x 40mm","no",1]
["D.7.8",null,"63mm x 32mm","no",1]
["D.7.9",null,"63mm x 40mm","no",1]
["D.7.10",null,"63mm x 50mm","no",1]
["D.7.11",null,"75mm x 50mm","no",1]
["D.7.12",null,"75mm x 63mm","no",1]
["D.7.13",null,"90mm x 63mm","no",1]
["D.7.14",null,"90mm x 75mm","no",1]
["D",null,"Carried forward"]
["D",null,"Brought forward"]
["D.7.15",null,"110mm x 90mm","no",1]
[]
["D.8",null,"Reducing Tee"]
["D.8.1",null,"25mm x 20mm","no",1]
["D.8.2",null,"32mm x 25mm","no",1]
["D.8.3",null,"40mm x 32mm","no",1]
["D.8.4",null,"50mm x 32mm","no",1]
["D.8.5",null,"50mm x 40mm","no",1]
["D.8.6",null,"63mm x 50mm","no",1]
["D.8.7",null,"75mm x 63mm","no",1]
["D.8.8",null,"90mm x 75mm","no",1]
["D.8.9",null,"110mm x 90mm","no",1]
[]
["D.9",null,"Single Union Ball Valve (Compression)"]
["D.9.1",null,"20mm","no",1]
["D.9.2",null,"25mm","no",1]
["D.9.3",null,"32mm","no",1]
["D.9.4",null,"40mm","no",1]
["D.9.5",null,"50mm","no",1]
["D.9.6",null,"63mm","no",1]
[]
["D.10",null,"Clamp Saddles (6 BAR)"]
["D.10.1",null,"25mm x 15mm","no",1]
["D.10.2",null,"25mm x 20mm","no",1]
["D.10.3",null,"32mm x 15mm","no",1]
["D.10.4",null,"32mm x 20mm","no",1]
["D.10.5",null,"32mm x 25mm","no",1]
["D.10.6",null,"40mm x 15mm","no",1]
["D.10.7",null,"40mm x 20mm","no",1]
["D",null,"Carried forward"]
["D",null,"Brought forward"]
["D.10.8",null,"40mm x 25mm","no",1]
["D.10.9",null,"50mm x 15mm","no",1]
["D.10.10",null,"50mm x 20mm","no",1]
["D.10.11",null,"50mm x 25mm","no",1]
["D.10.12",null,"50mm x 32mm","no",1]
["D.10.13",null,"63mm x 15mm","no",1]
["D.10.14",null,"63mm x 20mm","no",1]
["D.10.15",null,"63mm x 25mm","no",1]
["D.10.16",null,"63mm x 32mm","no",1]
["D.10.17",null,"63mm x 40mm","no",1]
["D.10.18",null,"75mm x 15mm","no",1]
["D.10.19",null,"75mm x 20mm","no",1]
["D.10.20",null,"75mm x 25mm","no",1]
["D.10.21",null,"75mm x 32mm","no",1]
["D.10.22",null,"75mm x 40mm","no",1]
["D.10.23",null,"75mm x 50mm","no",1]
["D.10.24",null,"90mm x 15mm","no",1]
["D.10.25",null,"90mm x 20mm","no",1]
["D.10.26",null,"90mm x 25mm","no",1]
["D.10.27",null,"90mm x 32mm","no",1]
["D.10.28",null,"90mm x 40mm","no",1]
["D.10.29",null,"90mm x 50mm","no",1]
["D.10.30",null,"110mm x 15mm","no",1]
["D.10.31",null,"110mm x 20mm","no",1]
["D.10.32",null,"110mm x 25mm","no",1]
["D.10.33",null,"110mm x 32mm","no",1]
["D.10.34",null,"110mm x 40mm","no",1]
["D.10.35",null,"110mm x 50mm","no",1]
["D.10.36",null,"110mm x 80mm","no",1]
["D",null,"Carried forward"]
["D",null,"Brought forward"]
["D.11",null,"Reinforced Clamp Saddles (10 Bar)"]
["D.11.1",null,"25mm x 15mm","no",1]
["D.11.2",null,"25mm x 20mm","no",1]
["D.11.3",null,"32mm x 15mm","no",1]
["D.11.4",null,"32mm x 20mm","no",1]
["D.11.5",null,"32mm x 25mm","no",1]
["D.11.6",null,"40mm x 15mm","no",1]
["D.11.7",null,"40mm x 20mm","no",1]
["D.11.8",null,"40mm x 25mm","no",1]
["D.11.9",null,"50mm x 15mm","no",1]
["D.11.10",null,"50mm x 20mm","no",1]
["D.11.11",null,"50mm x 25mm","no",1]
["D.11.12",null,"50mm x 32mm","no",1]
["D.11.13",null,"63mm x 15mm","no",1]
["D.11.14",null,"63mm x 20mm","no",1]
["D.11.15",null,"63mm x 25mm","no",1]
["D.11.16",null,"63mm x 32mm","no",1]
["D.11.17",null,"63mm x 40mm","no",1]
["D.11.18",null,"75mm x 15mm","no",1]
["D.11.19",null,"75mm x 20mm","no",1]
["D.11.20",null,"75mm x 25mm","no",1]
["D.11.21",null,"75mm x 32mm","no",1]
["D.11.22",null,"75mm x 40mm","no",1]
["D.11.23",null,"75mm x 50mm","no",1]
["D.11.24",null,"90mm x 15mm","no",1]
["D.11.25",null,"90mm x 20mm","no",1]
["D.11.26",null,"90mm x 25mm","no",1]
["D.11.27",null,"90mm x 32mm","no",1]
["D.11.28",null,"90mm x 40mm","no",1]
["D",null,"Carried forward"]
["D",null,"Brought forward"]
["D.11.29",null,"90mm x 50mm","no",1]
["D.11.30",null,"110mm x 15mm","no",1]
["D.11.31",null,"110mm x 20mm","no",1]
["D.11.32",null,"110mm x 25mm","no",1]
["D.11.33",null,"110mm x 32mm","no",1]
["D.11.34",null,"110mm x 40mm","no",1]
["D.11.35",null,"110mm x 50mm","no",1]
["D.11.36",null,"110mm x 80mm","no",1]
[]
["D.12",null,"Other Compression Fittings"]
["D.12.1",null,"Mark up on other compression fitting as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,5000,{"$f":"F201","v":5000}]
["D.12.2",null,"Mark up on other compression fitting","%",5000]
["D.12.3",null,"Extra over Item D.12.2: Deliver,install and test other Compression Fittings","Sum",1]
[]
["D.13",null,"HDPE pipe complete with fittings (Class 6)"]
["D.13.3",null,"32mm","m",1]
["D.13.4",null,"40mm","m",1]
["D.13.5",null,"50mm","m",1]
["D.13.6",null,"63mm","m",1]
["D.13.7",null,"75mm","m",1]
["D.13.8",null,"90mm","m",1]
["D.13.9",null,"110mm","m",1]
[]
["D.14",null,"HDPE pipe complete with fittings (Class 10)"]
["D",null,"Carried forward"]
["D",null,"Brought forward"]
["D.14.3",null,"32mm","m",1]
["D.14.4",null,"40mm","m",1]
["D.14.5",null,"50mm","m",1]
["D.14.6",null,"63mm","m",1]
["D.14.7",null,"75mm","m",1]
["D.14.8",null,"90mm","m",1]
["D.14.9",null,"110mm","m",1]
[]
["D.15",null,"HDPE pipe complete with fittings (Class 12)"]
["D.15.3",null,"32mm","m",1]
["D.15.4",null,"40mm","m",1]
["D.15.5",null,"50mm","m",1]
["D.15.6",null,"63mm","m",1]
["D.15.7",null,"75mm","m",1]
["D.15.8",null,"90mm","m",1]
["D.15.9",null,"110mm","m",1]
[]
["D.16",null,"HDPE pipe complete with fittings (Class 16)"]
["D.16.3",null,"32mm","m",1]
["D.16.4",null,"40mm","m",1]
["D.16.5",null,"50mm","m",1]
["D.16.6",null,"63mm","m",1]
["D.16.7",null,"75mm","m",1]
["D.16.8",null,"90mm","m",1]
["D.16.9",null,"110mm","m",1]
["D",null,"Carried forward"]
["D",null,"Brought forward"]
["D.17",null,"HDPE quick coupling pipe (Class 10)"]
["D.17.1",null,"50 mm","m",1]
["D.17.2",null,"63 mm","m",1]
["D.17.3",null,"75 mm","m",1]
["D.17.4",null,"90 mm","m",1]
["D.17.5",null,"110 mm","m",1]
[]
["D.18",null,"HDPE WELDED PIPES (Class 12 minimum)"]
["D.18.1",null,"150mm ","m",1]
["D.18.2",null,"200mm","m",1]
["D.18.3",null,"250 mm","m",1]
["D.18.4",null,"300 mm","m",1]
["D.18.5",null,"Welding of HDPE joints (ø 150 to 300 mm)","no",1]
[]
["D.19",null,"Special HDPE pipes and fittings"]
["D.19.1",null,"Mark up on the fabrication of special HDPE pipes and fittings as specified by the Engineer                (3 Quotations from reputable suppliers)","Prov sum",1,10000,{"$f":"F259","v":10000}]
["D.19.2",null,"Mark up on Special HDPE pipes","%",{"$f":"F259","v":10000}]
["D.19.3",null,"Extra over Item D.19.2: Deliver,install and test Special HDPE pipes and fittings","Sum",1]
[]
[null,null,"TOTAL SECTION \"D\" CARRIED FORWARD TO SUMMARY"]

{"sheet":"PVC","index":5,"n_rows":440,"n_cols":7,"rows_kept":440,"cut":false,"hidden":false,"merged":[[439,2,439,4],[439,5,439,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
["SANS 1200C",null,"SECTION E : PVC PIPES AND FITTINGS"]
["E",null,"Supply, deliver,install and test the following SABS approved PVC pipes and fittings."]
[]
["E.1",null,"uPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 6) "]
["E.1.1",null," 50 mm ","m",1]
["E.1.2",null," 63 mm ","m",1]
["E.1.3",null," 75 mm ","m",1]
["E.1.4",null," 90 mm ","m",1]
["E.1.5",null," 110 mm ","m",1]
["E.1.6",null," 125 mm ","m",1]
["E.1.7",null," 140 mm ","m",1]
["E.1.8",null," 160 mm ","m",1]
["E.1.9",null," 200 mm ","m",1]
["E.1.10",null," 250 mm ","m",1]
["E.1.11",null," 315 mm ","m",1]
[]
["E.2",null,"uPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 09) "]
["E.2.1",null," 50 mm ","m",1]
["E.2.2",null," 63 mm ","m",1]
["E.2.3",null," 75 mm ","m",1]
["E.2.4",null," 90 mm ","m",1]
["E.2.5",null," 110 mm ","m",1]
["E.2.6",null," 125 mm ","m",1]
["E.2.7",null," 140 mm ","m",1]
["E.2.8",null," 160 mm ","m",1]
["E.2.9",null," 200 mm ","m",1]
["E.2.10",null," 250 mm ","m",1]
["E.2.11",null," 315 mm ","m",1]
[]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.3",null,"uPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 12) "]
["E.3.1",null," 50 mm ","m",1]
["E.3.2",null," 63 mm ","m",1]
["E.3.3",null," 75 mm ","m",1]
["E.3.4",null," 90 mm ","m",1]
["E.3.5",null," 110 mm ","m",1]
["E.3.6",null," 125 mm ","m",1]
["E.3.7",null," 140 mm ","m",1]
["E.3.8",null," 160 mm ","m",1]
["E.3.9",null," 200 mm ","m",1]
["E.3.10",null," 250 mm ","m",1]
["E.3.11",null," 315 mm ","m",1]
[]
["E.4",null,"uPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 16) "]
["E.4.1",null," 50 mm ","m",1]
["E.4.2",null," 63 mm ","m",1]
["E.4.3",null," 75 mm ","m",1]
["E.4.4",null," 90 mm ","m",1]
["E.4.5",null," 110 mm ","m",1]
["E.4.6",null," 125 mm ","m",1]
["E.4.7",null," 140 mm ","m",1]
["E.4.8",null," 160 mm ","m",1]
["E.4.9",null," 200 mm ","m",1]
["E.4.10",null," 250 mm ","m",1]
["E.4.11",null," 315 mm ","m",1]
[]
["E.5",null,"uPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 20) "]
["E.5.1",null," 50 mm ","m",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.5.2",null," 63 mm ","m",1]
["E.5.3",null," 75 mm ","m",1]
["E.5.4",null," 90 mm ","m",1]
["E.5.5",null," 110 mm ","m",1]
["E.5.6",null," 125 mm ","m",1]
["E.5.7",null," 140 mm ","m",1]
["E.5.8",null," 160 mm ","m",1]
["E.5.9",null," 200 mm ","m",1]
["E.5.10",null," 250 mm ","m",1]
["E.5.11",null," 315 mm ","m",1]
[]
["E.6",null,"mPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 6) "]
["E.6.1",null," 50 mm ","m",1]
["E.6.2",null," 63 mm ","m",1]
["E.6.3",null," 75 mm ","m",1]
["E.6.4",null," 90 mm ","m",1]
["E.6.5",null," 110 mm ","m",1]
["E.6.6",null," 125 mm ","m",1]
["E.6.7",null," 140 mm ","m",1]
["E.6.8",null," 160 mm ","m",1]
["E.6.9",null," 200 mm ","m",1]
["E.6.10",null," 250 mm ","m",1]
["E.6.11",null," 315 mm ","m",1]
[]
["E.7",null,"mPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 09) "]
["E.7.1",null," 50 mm ","m",1]
["E.7.2",null," 63 mm ","m",1]
["E.7.3",null," 75 mm ","m",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.7.4",null," 90 mm ","m",1]
["E.7.5",null," 110 mm ","m",1]
["E.7.6",null," 125 mm ","m",1]
["E.7.7",null," 140 mm ","m",1]
["E.7.8",null," 160 mm ","m",1]
["E.7.9",null," 200 mm ","m",1]
["E.7.10",null," 250 mm ","m",1]
["E.7.11",null," 315 mm ","m",1]
[]
["E.8",null,"mPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 12) "]
["E.8.1",null," 50 mm ","m",1]
["E.8.2",null," 63 mm ","m",1]
["E.8.3",null," 75 mm ","m",1]
["E.8.4",null," 90 mm ","m",1]
["E.8.5",null," 110 mm ","m",1]
["E.8.6",null," 125 mm ","m",1]
["E.8.7",null," 140 mm ","m",1]
["E.8.8",null," 160 mm ","m",1]
["E.8.9",null," 200 mm ","m",1]
["E.8.10",null," 250 mm ","m",1]
["E.8.11",null," 315 mm ","m",1]
[]
["E.9",null,"mPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 16) "]
["E.9.1",null," 50 mm ","m",1]
["E.9.2",null," 63 mm ","m",1]
["E.9.3",null," 75 mm ","m",1]
["E.9.4",null," 90 mm ","m",1]
["E.9.5",null," 110 mm ","m",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.9.6",null," 125 mm ","m",1]
["E.9.7",null," 140 mm ","m",1]
["E.9.8",null," 160 mm ","m",1]
["E.9.9",null," 200 mm ","m",1]
["E.9.10",null," 250 mm ","m",1]
["E.9.11",null," 315 mm ","m",1]
[]
["E.10",null,"mPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 20) "]
["E.10.1",null," 50 mm ","m",1]
["E.10.2",null," 63 mm ","m",1]
["E.10.3",null," 75 mm ","m",1]
["E.10.4",null," 90 mm ","m",1]
["E.10.5",null," 110 mm ","m",1]
["E.10.6",null," 125 mm ","m",1]
["E.10.7",null," 140 mm ","m",1]
["E.10.8",null," 160 mm ","m",1]
["E.10.9",null," 200 mm ","m",1]
["E.10.10",null," 250 mm ","m",1]
["E.10.11",null," 315 mm ","m",1]
[]
["E.11",null,"COUPLINGS DOUBLE & REPAIR"]
["E.11.1",null," 50 mm ","no",1]
["E.11.2",null," 63 mm ","no",1]
["E.11.3",null," 75 mm ","no",1]
["E.11.4",null," 90 mm ","no",1]
["E.11.5",null," 110 mm ","no",1]
["E.11.6",null," 125 mm ","no",1]
["E.11.7",null," 140 mm ","no",1]
["E.11.8",null," 160 mm ","no",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.11.9",null," 200 mm ","no",1]
["E.11.10",null," 250 mm ","no",1]
["E.11.11",null," 315 mm ","no",1]
[]
["E.12",null,"Pipe seal to female thread elbow"]
["E.12.1",null," 50 mm x 2 inch","no",1]
["E.12.2",null," 63 mm x 2 inch","no",1]
["E.12.3",null," 75 mm x 2 inch ","no",1]
["E.12.4",null," 75 mm x 3 inch ","no",1]
["E.12.5",null," 90 mm x 3 inch","no",1]
["E.12.6",null," 110 mm x 3 inch","no",1]
["E.12.7",null," 110 mm x 4 inch","no",1]
["E.12.8",null," 125 mm x 3 inch","no",1]
["E.12.9",null," 125 mm x 4 inch","no",1]
["E.12.10",null," 140 mm x 3 inch ","no",1]
["E.12.11",null," 140 mm x 4 inch ","no",1]
["E.12.12",null," 160 mm x 3 inch ","no",1]
["E.12.13",null," 160 mm x 4 inch ","no",1]
["E.12.14",null," 200 mm x 3 inch ","no",1]
["E.12.15",null," 200 mm x 4 inch ","no",1]
[]
["E.13",null,"FLANGE ADAPTORS EPOXY COATED ALUMINIUM  (TABLE D)"]
["E.13.1",null,"50mm","no",1]
["E.13.2",null,"63mm","no",1]
["E.13.3",null,"75mm","no",1]
["E.13.4",null,"90mm","no",1]
["E.13.5",null,"110mm","no",1]
["E.13.6",null,"125mm","no",1]
["E.13.7",null,"140mm","no",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.13.8",null,"160mm","no",1]
["E.13.9",null,"200mm","no",1]
["E.13.10",null,"250mm","no",1]
["E.13.11",null,"315mm","no",1]
[]
["E.14",null,"FLANGE ADAPTORS CAST IRON BITUMEN COATED (TABLE D)"]
["E.14.1",null,"50mm","no",1]
["E.14.2",null,"63mm","no",1]
["E.14.3",null,"75mm","no",1]
["E.14.4",null,"90mm","no",1]
["E.14.5",null,"110mm","no",1]
["E.14.6",null,"125mm","no",1]
["E.14.7",null,"140mm","no",1]
["E.14.8",null,"160mm","no",1]
["E.14.9",null,"200mm","no",1]
["E.14.10",null,"250mm","no",1]
["E.14.11",null,"315mm","no",1]
[]
["E.15",null," BENDS EPOXY COATED ALUMINIUM  (64-45)"]
["E.15.1",null,"50mm","no",1]
["E.15.2",null,"63mm","no",1]
["E.15.3",null,"75mm","no",1]
["E.15.4",null,"90mm","no",1]
["E.15.5",null,"110mm","no",1]
["E.15.6",null,"125mm","no",1]
["E.15.7",null,"140mm","no",1]
["E.15.8",null,"160mm","no",1]
["E.15.9",null,"200mm","no",1]
["E.15.10",null,"250mm","no",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.16",null," BENDS CAST IRON BITUMEN COATED           (11,5-90 Degrees)"]
["E.16.1",null,"50mm","no",1]
["E.16.2",null,"63mm","no",1]
["E.16.3",null,"75mm","no",1]
["E.16.4",null,"90mm","no",1]
["E.16.5",null,"110mm","no",1]
["E.16.6",null,"125mm","no",1]
["E.16.7",null,"140mm","no",1]
["E.16.8",null,"160mm","no",1]
["E.16.9",null,"200mm","no",1]
["E.16.10",null,"250mm","no",1]
[]
["E.17",null," COUPLING EPOXY COATED ALUMINIUM             (9 BAR)"]
["E.17.1",null,"50mm","no",1]
["E.17.2",null,"63mm","no",1]
["E.17.3",null,"75mm","no",1]
["E.17.4",null,"90mm","no",1]
["E.17.5",null,"110mm","no",1]
["E.17.6",null,"125mm","no",1]
["E.17.7",null,"140mm","no",1]
["E.17.8",null,"160mm","no",1]
["E.17.9",null,"200mm","no",1]
["E.17.10",null,"250mm","no",1]
[]
["E.18",null," COUPLING CAST IRON BITUMEN COATED             (16 BAR)"]
["E.18.1",null,"50mm","no",1]
["E.18.2",null,"63mm","no",1]
["E.18.3",null,"75mm","no",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.18.4",null,"90mm","no",1]
["E.18.5",null,"110mm","no",1]
["E.18.6",null,"125mm","no",1]
["E.18.7",null,"140mm","no",1]
["E.18.8",null,"160mm","no",1]
["E.18.9",null,"200mm","no",1]
["E.18.10",null,"250mm","no",1]
[]
["E.19",null,"ADAPTOR B.S.P MALE &FEMALE"]
["E.19.1",null,"50mm x 2\" ","no",1]
["E.19.2",null,"63mm x 2\"","no",1]
["E.19.3",null,"75mm x 2\"","no",1]
["E.19.4",null,"75mm x 3\" ","no",1]
["E.19.5",null,"90mm x 3\"","no",1]
["E.19.6",null,"90mm x 4\"","no",1]
["E.19.7",null,"110mm x 3\"","no",1]
["E.19.8",null,"110mm x 4\"","no",1]
["E.19.9",null,"125mm x 4\"","no",1]
["E.19.10",null,"125mm x 5\" ","no",1]
["E.19.11",null,"140mm x 4\"","no",1]
["E.19.12",null,"140mm x 5\" ","no",1]
["E.19.13",null,"140mm x 6\" ","no",1]
["E.19.14",null,"160mm x 6\" ","no",1]
["E.19.15",null,"160mm x 6\" ","no",1]
[]
["E.20",null,"END CAPS"]
["E.20.1",null,"50mm","no",1]
["E.20.2",null,"63mm","no",1]
["E.20.3",null,"75mm","no",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.20.4",null,"90mm","no",1]
["E.20.5",null,"110mm","no",1]
["E.20.6",null,"125mm","no",1]
["E.20.7",null,"140mm","no",1]
["E.20.8",null,"160mm","no",1]
["E.20.9",null,"200mm","no",1]
["E.20.10",null,"250mm","no",1]
["E.20.11",null,"315mm","no",1]
[]
["E.21",null,"EQUAL TEES"]
["E.21.1",null,"50mm","no",1]
["E.21.2",null,"63mm","no",1]
["E.21.3",null,"75mm","no",1]
["E.21.4",null,"90mm","no",1]
["E.21.5",null,"110mm","no",1]
["E.21.6",null,"125mm","no",1]
["E.21.7",null,"140mm","no",1]
["E.21.8",null,"160mm","no",1]
["E.21.9",null,"200mm","no",1]
["E.21.10",null,"250mm","no",1]
["E.21.11",null,"315mm","no",1]
[]
["E.22",null,"BENDS - 22 & 11.25 DEGREES"]
["E.22.1",null,"50mm","no",1]
["E.22.2",null,"63mm","no",1]
["E.22.3",null,"75mm","no",1]
["E.22.4",null,"90mm","no",1]
["E.22.5",null,"110mm","no",1]
["E.22.6",null,"125mm","no",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.22.7",null,"140mm","no",1]
["E.22.8",null,"160mm","no",1]
["E.22.9",null,"200mm","no",1]
["E.22.10",null,"250mm","no",1]
["E.22.11",null,"315mm","no",1]
[]
["E.23",null,"BENDS - 90 & 45 DEGREES"]
["E.23.1",null,"50mm","no",1]
["E.23.2",null,"63mm","no",1]
["E.23.3",null,"75mm","no",1]
["E.23.4",null,"90mm","no",1]
["E.23.5",null,"110mm","no",1]
["E.23.6",null,"125mm","no",1]
["E.23.7",null,"140mm","no",1]
["E.23.8",null,"160mm","no",1]
["E.23.9",null,"200mm","no",1]
["E.23.10",null,"250mm","no",1]
["E.23.11",null,"315mm","no",1]
[]
["E.24",null,"Male/Female Reducer class 9"]
["E.24.1",null,"50mm x 40mm","no",1]
["E.24.2",null,"63mm x 40mm","no",1]
["E.24.3",null,"63mm x 50mm","no",1]
["E.24.4",null,"75mm x 50mm","no",1]
["E.24.5",null,"75mm x 63mm","no",1]
["E.24.6",null,"90mm x 63mm","no",1]
["E.24.7",null,"90mm x 75mm","no",1]
["E.24.8",null,"110mm x 75mm","no",1]
["E.24.9",null,"110mm x 90mm","no",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.24.10",null,"125mm x 90mm","no",1]
["E.24.11",null,"125mm x 110mm","no",1]
["E.24.12",null,"140mm x 110mm","no",1]
["E.24.13",null,"140mm x 125mm","no",1]
["E.24.14",null,"160mm x 110mm","no",1]
["E.24.15",null,"160mm x 125mm","no",1]
["E.24.16",null,"160mm x 140mm","no",1]
["E.24.17",null,"200mm x 160mm","no",1]
["E.24.18",null,"250mm x 200mm","no",1]
[]
["E.25",null,"Reducing Cross"]
["E.25.1",null,"50mm x 40mm","no",1]
["E.25.2",null,"63mm x 40mm","no",1]
["E.25.3",null,"63mm x 50mm","no",1]
["E.25.4",null,"75mm x 50mm","no",1]
["E.25.5",null,"75mm x 63mm","no",1]
["E.25.6",null,"90mm x 63mm","no",1]
["E.25.7",null,"90mm x 75mm","no",1]
["E.25.8",null,"110mm x 75mm","no",1]
["E.25.9",null,"110mm x 90mm","no",1]
["E.25.10",null,"125mm x 90mm","no",1]
["E.25.11",null,"125mm x 110mm","no",1]
["E.25.12",null,"140mm x 110mm","no",1]
["E.25.13",null,"140mm x 125mm","no",1]
["E.25.14",null,"160mm x 110mm","no",1]
["E.25.15",null,"160mm x 125mm","no",1]
["E.25.16",null,"160mm x 140mm","no",1]
["E.25.17",null,"200mm x 160mm","no",1]
["E.25.18",null,"250mm x 200mm","no",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.26",null,"Reducing Tee"]
["E.26.1",null,"50mm x 40mm","no",1]
["E.26.2",null,"63mm x 40mm","no",1]
["E.26.3",null,"63mm x 50mm","no",1]
["E.26.4",null,"75mm x 50mm","no",1]
["E.26.5",null,"75mm x 63mm","no",1]
["E.26.6",null,"90mm x 63mm","no",1]
["E.26.7",null,"90mm x 75mm","no",1]
["E.26.8",null,"110mm x 75mm","no",1]
["E.26.9",null,"110mm x 90mm","no",1]
["E.26.10",null,"125mm x 90mm","no",1]
["E.26.11",null,"125mm x 110mm","no",1]
["E.26.12",null,"140mm x 110mm","no",1]
["E.26.13",null,"140mm x 125mm","no",1]
["E.26.14",null,"160mm x 110mm","no",1]
["E.26.15",null,"160mm x 125mm","no",1]
["E.26.16",null,"160mm x 140mm","no",1]
["E.26.17",null,"200mm x 160mm","no",1]
["E.26.18",null,"250mm x 200mm","no",1]
[]
["E.27",null,"FLANGED ON BRANCH TEE (Table D)"]
["E.27.1",null,"50mm","no",1]
["E.27.2",null,"63mm","no",1]
["E.27.3",null,"75mm","no",1]
["E.27.4",null,"90mm","no",1]
["E.27.5",null,"110mm","no",1]
["E.27.6",null,"125mm","no",1]
["E.27.7",null,"140mm","no",1]
["E.27.8",null,"160mm","no",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.27.9",null,"200mm","no",1]
["E.27.10",null,"250mm","no",1]
["E.27.11",null,"315mm","no",1]
[]
["E.28",null,"ADAPTOR PVC-AC"]
["E.28.1",null,"50mm","no",1]
["E.28.2",null,"63mm","no",1]
["E.28.3",null,"75mm","no",1]
["E.28.4",null,"90mm","no",1]
["E.28.5",null,"110mm","no",1]
["E.28.6",null,"125mm","no",1]
["E.28.7",null,"140mm","no",1]
["E.28.8",null,"160mm","no",1]
["E.28.9",null,"200mm","no",1]
["E.28.10",null,"250mm","no",1]
["E.28.11",null,"315mm","no",1]
[]
["E.29",null,"ADAPTOR FLANGED (Table D)"]
["E.29,1",null,"50mm","no",1]
["E.29,2",null,"63mm","no",1]
["E.29,3",null,"75mm","no",1]
["E.29,4",null,"90mm","no",1]
["E.29,5",null,"110mm","no",1]
["E.29,6",null,"125mm","no",1]
["E.29,7",null,"140mm","no",1]
["E.29,8",null,"160mm","no",1]
["E.29,9",null,"200mm","no",1]
["E.29,10",null,"250mm","no",1]
["E.29,11",null,"315mm","no",1]
["E",null,"Carried forward"]
["E",null,"Brought forward"]
["E.30",null,"Other PVC fittings and pipes"]
["E.30.1",null,"Mark up on other PVC fittings and pipes as specified by the Engineer  (3 Quotations from reputable suppliers)","PC Sum",1,10000,{"$f":"F433","v":10000}]
["E.30.2",null,"Mark up on other PVC fittings and pipes","%",{"$f":"F433","v":10000}]
["E.30.3",null,"Extra over Item E.30.2: Deliver,install and test other PVC pipes.","no",1]
["E.30.4",null,"Extra over Item E.30.2: Deliver,install and test other PVC fittings.","Sum",1]
[null,null,null,null,null,null,{"$f":"F437*E437","v":0}]
[]
[]
[null,null,"TOTAL SECTION \"E\" CARRIED FORWARD TO SUMMARY"]

{"sheet":"DRIP","index":6,"n_rows":144,"n_cols":7,"rows_kept":144,"cut":false,"hidden":false,"merged":[[2,2,2,5],[4,2,4,4],[10,2,10,4],[16,2,16,4],[24,2,24,5],[30,2,30,5],[36,2,36,5],[51,2,51,3],[143,2,143,4],[143,5,143,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION F : DRIP IRRIGATION"]
["F",null,"Supply, deliver,install and test the following drippers and dripperlines complete with fittings."]
[]
["F.1",null,"Pressure Compensating (PC) Inline (Integral) Drippers,                     Thick wall dripline (wall thikness 0.9 mm and more),                           Flow rate between 0.5 and 4 l/h."]
["F.1.1",null,"0.3 meter dripper spacing","m",1]
["F.1.2",null,"0.4 meter dripper spacing","m",1]
["F.1.3",null,"0.5 meter dripper spacing","m",1]
["F.1.4",null,"0.6 meter dripper spacing","m",1]
[]
["F.2",null,"Pressure Compensating (PC) Inline (Integral) Drippers, Meduim wall dripline (wall thikness 0.5 to 0.89 mm),      Flow rate between 0.5 and 4 l/h."]
["F.2.1",null,"0.3 meter dripper spacing","m",1]
["F.2.2",null,"0.4 meter dripper spacing","m",1]
["F.2.3",null,"0.5 meter dripper spacing","m",1]
["F.2.4",null,"0.6 meter dripper spacing","m",1]
[]
["F.3",null,"Pressure Compensating (PC) Inline (Integral) Drippers, Thin wall dripline (wall thikness 0.45 mm and less),       Flow rate between 0.5 and 4 l/h."]
["F.3.1",null,"0.3 meter dripper spacing","m",1]
["F.3.2",null,"0.4 meter dripper spacing","m",1]
["F.3.3",null,"0.5 meter dripper spacing","m",1]
["F.3.4",null,"0.6 meter dripper spacing","m",1]
[]
["F",null,"Carried forward"]
["F",null,"Brought forward"]
["F.4",null,"Non Pressure Compensating (NPC) Inline (Integral) Drippers,           Thick wall dripline (wall thikness 0.9 mm and more),                           Flow rate between 0.5 and 4 l/h."]
["F.4.1",null,"0.3 meter dripper spacing","m",1]
["F.4.2",null,"0.4 meter dripper spacing","m",1]
["F.4.3",null,"0.5 meter dripper spacing","m",1]
["F.4.4",null,"0.6 meter dripper spacing","m",1]
[]
["F.5",null,"Non Pressure Compensating (NPC) Inline (Integral) Drippers,        Meduim wall dripline (wall thikness 0.5 to 0.89 mm),                           Flow rate between 0.5 and 4 l/h."]
["F.5.1",null,"0.3 meter dripper spacing","m",1]
["F.5.2",null,"0.4 meter dripper spacing","m",1]
["F.5.3",null,"0.5 meter dripper spacing","m",1]
["F.5.4",null,"0.6 meter dripper spacing","m",1]
[]
["F.6",null,"Non Pressure Compensating (NPC) Inline (Integral) Drippers,              Thin wall dripline (wall thikness 0.45 mm and less),                            Flow rate between 0.5 and 4 l/h."]
["F.6.1",null,"0.3 meter dripper spacing","m",1]
["F.6.2",null,"0.4 meter dripper spacing","m",1]
["F.6.3",null,"0.5 meter dripper spacing","m",1]
["F.6.4",null,"0.6 meter dripper spacing","m",1]
[]
[]
[]
["F",null,"Carried forward"]
["F",null,"Brought forward"]
["F.7",null,"Other Inline (Integral) Drippers PC and NPC"]
["F.7.1",null,"Mark up on other Inline (Integral) Drippers PC and NPC as specified by the Engineer              (3 Quotations from reputable suppliers)","PC Sum",1]
["F.7.2",null,"Mark up on other Inline (Integral) Drippers PC and NPC","%",{"$f":"F48","v":0}]
["F.7.3",null,"Extra over Item F.7.1: Deliver,install and test Other Inline (Integral) Drippers PC and NPC.","m",1]
[]
[null,null,"Supply, deliver,install and test the following  online drippers and pipes complete with fittings."]
["F.8",null,"INSERT FITTINGS"]
["F.8.1",null,"12mm short coupling","no",1]
["F.8.2",null,"16mm short coupling","no",1]
["F.8.3",null,"12mm long coupling","no",1]
["F.8.4",null,"16mm long coupling","no",1]
["F.8.5",null,"17mm long coupling ","no",1]
["F.8.6",null,"20mm long coupling","no",1]
["F.8.7",null,"16/12mm long reducing","no",1]
["F.8.8",null,"17/16mm long reducing","no",1]
["F.8.9",null,"20/16mm long reducing","no",1]
["F.8.10",null,"20/17mm long reducing","no",1]
["F.8.11",null,"12mm elbow long insert","no",1]
["F.8.12",null,"16mm elbow long insert","no",1]
["F.8.13",null,"20mm elbow long insert","no",1]
["F",null,"Carried forward"]
["F",null,"Brought forward"]
["F.8.14",null,"17mm elbow long insert","no",1]
["F.8.15",null,"12x12x12 long insert T","no",1]
["F.8.16",null,"16x16x16 long insert T","no",1]
["F.8.17",null,"17x17x17 long insert T ","no",1]
["F.8.18",null,"20x20x20 long insert T","no",1]
["F.8.19",null,"16x12x16 reducing T","no",1]
["F.8.20",null,"Dripline LPD Barb 17mm","no",1]
["F.8.21",null,"Dripline LPD Barb 16mm","no",1]
["F.8.22",null,"Barb Connector 17mm x ½” Male","no",1]
["F.8.23",null,"Barb Connector 16mm x ½” Male","no",1]
["F.8.24",null,"Dripline Flush VLV Barb20 W/Snap Clip","no",1]
["F.8.25",null,"Dripline Flush VLV Barb17 W/Snap Clip","no",1]
["F.8.26",null,"Dripline Flush VLV Barb16 W/Snap Clip","no",1]
["F.8.27",null,"Multi Outlet 3/4” x 6 x 12mm   6 way","no",1]
["F.8.28",null,"Multi Outlet 1” x 6 x 16mm   6 way","no",1]
["F.8.29",null,"Combination saddle + nut 32mm poly pipe or bigger","no",1]
["F.8.30",null,"Stopper  -  12/16/17mm","no",1]
["F.8.31",null,"Stopper figure 8 20mm","no",1]
["F.8.32",null,"2 way angle barb connector - 16 X 3/4 MALE","no",1]
[]
[]
["F",null,"Carried forward"]
["F",null,"Brought forward"]
["F.9",null,"BLIND PIPE (LDPE)"]
["F.9.1",null,"12 mm","m",1]
["F.9.2",null,"16 mm","m",1]
["F.9.3",null,"17 mm","m",1]
["F.9.4",null,"20 mm","m",1]
[]
["F.10",null,"Pressure compensating and Non Drain online drippers"]
["F.10.1",null,"1.0 l/h (seal 0.2 bar, fully open 0.6 - 3.5 bar)","no",1]
["F.10.2",null,"2.2 l/h (seal 0.2 bar, fully open 0.6 - 3.5 bar)","no",1]
["F.10.3",null,"3.8 l/h (seal 0.2 bar, fully open 0.6 - 3.5 bar)","no",1]
["F.10.4",null,"8.0 l/h (seal 0.2 bar, fully open 0.6 - 3.5 bar)","no",1]
["F.10.5",null,"3.1 l/h (seal 0.4 bar, fully open 1.1 - 3.5 bar)","no",1]
["F.10.6",null,"5.3 l/h (seal 0.2 bar, fully open 1.1- 3.5 bar)","no",1]
["F.10.7",null,"11 l/h (seal 0.4 bar, fully open 1.1 - 3.5 bar)","no",1]
[]
["F.11",null,"Non Pressure compensating Button Dripper "]
["F.11.1",null,"2 l/h ","no",10]
["F.11.2",null,"4 l/h ","no",10]
["F.11.3",null,"8 l/h","no",10]
[]
[]
["F",null,"Carried forward"]
["F",null,"Brought forward"]
["F.12",null,"BUTTON DRIPPER ACCESSORIES (3x5 mm tube)"]
["F.12.1",null,"Single Threaded outlet adaptor","no",1]
["F.12.2",null,"2-way threaded branch adaptor","no",1]
["F.12.3",null,"2-way barbed branch adaptor","no",1]
["F.12.4",null,"4-way threaded branch adaptor","no",1]
["F.12.5",null,"4-way barbed branch adaptor","no",1]
["F.12.6",null,"Barb adaptor for multi outlet","no",1]
["F.12.7",null,"Connector JDW 3x5mm (used with 5mm Odx 3mm ID flex tube)","no",1]
["F.12.8",null,"Dripeg - flow equalizer or dripper (30 degree diagonal labyrinth)","no",1]
["F.12.9",null,"Snapeg (30 degree diagonal external grip)","no",1]
["F.12.10",null,"Flextubing 5mm OD x 3mm ID ","m",1]
["F.12.11",null,"Flextubing 5mm OD x 3mm ID ","m",1]
["F.12.12",null,"Manifold 4-way complete with 400mm tube and peg","no",1]
["F.12.13",null,"Manifold 4-way complete with 600mm tube and peg","no",1]
["F.12.14",null,"Manifold 2-way complete with 400mm tube and peg","no",1]
["F.12.15",null,"Manifold 2-way complete with 600mm tube and peg","no",1]
[]
[]
[]
[]
[]
["F",null,"Carried forward"]
["F",null,"Brought forward"]
["F.13",null,"Other Online Drippers, fittings and pipes"]
["F.13.1",null,"Mark up on other Online Drippers, fittings and LDPE pipes as specified by the Engineer              (3 Quotations from reputable suppliers)","PC Sum",1,15000,{"$f":"F139","v":15000}]
["F.13.2",null,"Mark up on other Online Drippers, fittings and LDPE pipes","%",{"$f":"F139","v":15000}]
["F.13.3",null,"Extra over Item F.13.1: Deliver,install and test Other Online Drippers and fittings.","Sum",1]
["F.13.4",null,"Extra over Item F.13.1: Deliver,install and test Other LDPE pipes.","m",1]
[]
[null,null,"TOTAL SECTION \"F\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G3:G143)","v":15000}]

{"sheet":"Sprinkler","index":7,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[51,2,51,4],[51,5,51,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION G : SPRINKLER IRRIGATION"]
["G",null,"Supply, deliver,install and test the following  sprinklers complete with all fittings."]
[]
["G.1",null,"Mirco Sprinkler: Pressure compensating 1.5 - 4 bar, Flow rate 20 - 110 l/h, Wetting diameter 4 - 8m."]
["G.1.1",null,"Micro Sprinkler complete with all nozzles, rotors / swivels, fittings, stake and 60 cm long micro tube.","no",1]
["G.1.2",null,"Micro Sprinkler complete with all nozzles, rotors / swivels, fittings, stake and ≥90 cm long micro tube.","no",1]
["G.2",null,"Mirco Sprinkler: Pressure compensating 1.5 - 4 bar, Flow rate 20 - 110 l/h, Wetting diameter 4 - 8m. With Stream Deflector for 1 - 2m wetting diameter."]
["G.2.1",null,"Micro Sprinkler complete with all nozzles, rotors / swivels, fittings, stake and 60 cm long micro tube.","no",1]
["G.2.2",null,"Micro Sprinkler complete with all nozzles, rotors / swivels, fittings, stake and ≥90 cm long micro tube.","no",1]
[]
["G.3",null,"Mirco Sprinkler: Operating preasure 0.75 - 2 bar, Flow rate 10 - 110 l/h, Wetting diameter 0.5 - 8m."]
["G.3.1",null,"Micro Sprinkler complete with all nozzles, rotors / swivels, fittings, stake and 60 cm long micro tube.","no",1]
["G.3.2",null,"Micro Sprinkler complete with all nozzles, rotors / swivels, fittings, stake and ≥90 cm long micro tube.","no",1]
["G.4",null,"Mirco Sprinkler: Operating preasure 0.75 - 2 bar, Flow rate 10 - 110 l/h, Wetting diameter 0.5 - 8m. With Stream Deflector 0.5 - 2m wetting diameter."]
["G.4.1",null,"Micro Sprinkler complete with all nozzles, rotors / swivels, fittings, stake and 60 cm long micro tube.","no",1]
["G.4.2",null,"Micro Sprinkler complete with all nozzles, rotors / swivels, fittings, stake and ≥90 cm long micro tube.","no",1]
["G",null,"Carried forward"]
["G",null,"Brought forward"]
["G.5",null,"Mirco Sprinkler: Operating preasure 2 - 2.5 bar, Flow rate 150 - 300 l/h, Wetting diameter 8 - 11m."]
["G.5.1",null,"Micro Sprinkler complete with all nozzles, rotors / swivels, fittings, stake and 60 cm long micro tube.","no",1]
["G.5.2",null,"Micro Sprinkler complete with all nozzles, rotors / swivels, fittings, stake and ≥90 cm long micro tube.","no",1]
[]
["G.6",null,"Impact Sprinkler: Operating preasure 2 - 3 bar, Flow rate 200 - 750 l/h, Wetting diameter 11 - 19m.  "]
["G.6.1",null,"Sprinkler with trajectory of ≤15 degrees, Popup mechanism with insect protection and integral filter. (Netafim, Meganet 15D or similar)","no",1]
["G.6.2",null,"Sprinkler with trajectory of ≤24 degrees, Popup mechanism with insect protection and integral filter. (Netafim, Meganet 24D or similar)","no",1]
[]
["G.7",null,"Supply, deliver,install and test Impact Sprinklers complete with all fittings."]
["G.7.1",null,"Impact Sprinkler: Operating preasure 2 - 3 bar, Flow rate 510 - 1275 l/h, Wetting diameter 18 - 22m.  ","no",1]
["G.7.2",null,"Impact Sprinkler: Operating preasure 2 - 4 bar, Flow rate 1200 - 2000 l/h, Wetting diameter 22 - 29m.  ","no",1]
["G.7.3",null,"Impact Sprinkler: Operating preasure 3 - 4 bar, Flow rate 2150 - 3060 l/h, Wetting diameter 29 - 35m.  ","no",1]
["G.7.4",null,"Impact Sprinkler: Adjustable Arc, Operating preasure 2 - 3 bar, Flow rate 500 - 630 l/h, Wetting diameter  20m.  ","no",1]
["G.7.5",null,"Impact Sprinkler: Low preasure, Operating preasure 1 - 2 bar, Flow rate 350 - 450 l/h, Wetting diameter 17 - 22m.  ","no",1]
[]
["G",null,"Carried forward"]
["G",null,"Brought forward"]
["G.8",null,"Other Impact Sprinklers"]
["G.8.1",null,"Mark up on other Impact Sprinklers as specified by the Engineer  (3 Quotations from reputable suppliers)","PC Sum",1,15000,{"$f":"F38","v":15000}]
["G.8.2",null,"Mark up on other Impact Sprinklers","%",{"$f":"F38","v":15000}]
["G.8.3",null,"Extra over Item G.8.1: Deliver,install and test Other Impact Sprinklers","Sum",1]
[]
["G.9",null,"PVC riser pipe threaded both ends"]
["G.9.1",null,"300 mm x 15 mm","no",1]
["G.9.2",null,"600 mm x 15 mm","no",1]
["G.9.3",null,"900 mm x 15 mm","no",1]
["G.9.4",null,"1200 mm x 15 mm","no",1]
["G.9.5",null,"300 mm x 20 mm","no",1]
["G.9.6",null,"600 mm x 20 mm","no",1]
["G.9.7",null,"900 mm x 20 mm","no",1]
["G.9.8",null,"1200 mm x 20 mm","no",1]
[]
[null,null,"TOTAL SECTION \"G\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G51)","v":15000}]

{"sheet":"Filters","index":8,"n_rows":58,"n_cols":7,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,2,57,4],[57,5,57,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION H : FILTERS & AIRVALVES"]
["H",null,"Supply, deliver, install and test the following filters complete with all fittings and valves."]
[]
["H.1",null,"Plastic manual In-Line (Y-Type) screen filters complete with polyester screen and drain valve"]
["H.1.1",null,"20mm Filter with minimum 3,5 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 160 cm²","no",1]
["H.1.2",null,"25mm Filter with minimum 4,5 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 160 cm²","no",1]
["H.1.3",null,"32mm  Filter with minimum 10 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 590 cm²","no",1]
["H.1.4",null,"40mm  Filter with minimum 7 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 300 cm²","no",1]
["H.1.5",null,"50mm  Filter with minimum 16 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 510 cm²","no",1]
[]
["H.2",null,"Plastic manual (On-Line) screen filters complete with polyester screen and drain valve"]
["H.2.1",null,"50mm  Filter with minimum 15 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 800 cm²","no",1]
["H.2.2",null,"50 - 63mm  Filter with min 20 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 1200 cm²","no",1]
["H.2.3",null,"50 - 63mm  Filter with min 25 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 1600 cm²","no",1]
["H.2.4",null,"63 - 80mm  Filter with min 25 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 1200 cm²","no",1]
["H.2.5",null,"63 - 80mm  Filter with min 30 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 1600 cm²","no",1]
["H.2.6",null,"80 - 100mm  Filter with min 45 m³/h flow, 100 - 300 micron  screen, Filtration Surface minimum 2400 cm²","no",1]
[]
["H",null,"Carried forward"]
["H",null,"Brought forward"]
[]
["H.3",null,"Manual In-Line (Y-Type) screen filters complete with Stainless-steel screen and drain valve (10 bar)"]
["H.3.1",null,"40mm  Filter with minimum 15 m³/h flow, 130 - 500 micron  screen, Filtration Surface minimum 800 cm²","no",1]
["H.3.2",null,"50mm  Filter with minimum 25 m³/h flow, 100 - 500 micron  screen, Filtration Surface minimum 800 cm²","no",1]
["H.3.3",null,"80mm  Filter with minimum 50 m³/h flow, 100 - 500 micron  screen, Filtration Surface minimum 1700 cm²","no",1]
["H.3.4",null,"100mm  Filter with minimum 80 m³/h flow, 100 - 500 micron  screen, Filtration Surface minimum 2500 cm²","no",1]
[]
["H.4",null,"Manual On-Line screen filters complete with  Stainless-steel screen and drain valve (10 bar)"]
["H.4.1",null,"40mm  Filter with minimum 15 m³/h flow, 130 - 500 micron  screen, Filtration Surface minimum 800 cm²","no",1]
["H.4.2",null,"50mm  Filter with minimum 25 m³/h flow, 100 - 500 micron  screen, Filtration Surface minimum 800 cm²","no",1]
["H.4.3",null,"80mm  Filter with minimum 50 m³/h flow, 100 - 500 micron  screen, Filtration Surface minimum 1700 cm²","no",1]
["H.4.4",null,"100mm  Filter with minimum 80 m³/h flow, 100 - 500 micron  screen, Filtration Surface minimum 2500 cm²","no",1]
[]
["H.5",null,"Manual Disc filters complete with discs and drain valve"]
["H.5.1",null,"20mm Filter with minimum 4 m³/h flow, 100 - 400 micron, Filtration Surface minimum 160 cm²","no",1]
["H.5.2",null,"25mm Filter with minimum 6 m³/h flow, 100 - 400 micron, Filtration Surface minimum 170 cm²","no",1]
["H.5.3",null,"25mm  Filter with minimum 8 m³/h flow, 100 - 400 micron, Filtration Surface minimum 500 cm²","no",1]
[]
["H",null,"Carried forward"]
["H",null,"Brought forward"]
[]
["H.5.4",null,"40mm  Filter with minimum 8 m³/h flow, 100 - 400 micron, Filtration Surface minimum 300 cm²","no",1]
["H.5.5",null,"40mm  Filter with minimum 12 m³/h flow, 100 - 400 micron, Filtration Surface minimum 500 cm²","no",1]
["H.5.6",null,"50mm  Filter with minimum 25 m³/h flow, 100 - 400 micron, Filtration Surface minimum 950 cm²","no",1]
["H.5.7",null,"80mm  Filter with minimum 50 m³/h flow, 100 - 400 micron, Filtration Surface minimum 1 900 cm²","no",1]
["H.5.8",null,"100mm Filter with minimum 70 m³/h flow, 100 - 400 micron, Filtration Surface minimum 2 600 cm²","no",1]
[]
["H.6",null,"Other Filters"]
["H.6.1",null,"Mark up on other Filters as specified by the Engineer   (3 Quotations from reputable suppliers)","PC Sum",1,200000,"rate only"]
["H.6.2",null,"Mark up on other Filters  ","%",{"$f":"F50","v":200000}]
["H.6.3",null,"Extra over Item H.6.1: Deliver,install and test other Filters:                    Up to 2 Unit filter bank ","no",1]
["H.6.4",null,"Extra over Item H.6.1: Deliver,install and test other Filters:                     3 Unit filter bank ","no",1]
["H.6.5",null,"Extra over Item H.6.1: Deliver,install and test other Filters:                      4 Unit filter bank ","no",1]
["H.6.6",null,"Extra over Item H.6.1: Deliver,install and test other Filters:                       5 Unit filter bank ","no",1]
["H.6.7",null,"Extra over Item H.6.1: Deliver,install and test other Filters:                        6 Unit filter bank ","no",1]
[]
[null,null,"TOTAL SECTION \"H\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G3:G57)","v":0}]

{"sheet":"Non-SABS LDPE","index":9,"n_rows":124,"n_cols":7,"rows_kept":124,"cut":false,"hidden":false,"merged":[[123,2,123,4],[123,5,123,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION J : LDPE PIPES AND FITTINGS"]
["J",null,"Supply, deliver,install and test the following non SABS approved LDPE pipes and fittings (Poly Prop) subject to engineers approval . A two year warranty for pipe and fittings . All material to be manufactured from virgin plastic."]
[]
["J.1",null,"Coupling Insert"]
["J.1.4",null,"32mm","no",1]
["J.1.5",null,"40mm","no",1]
["J.1.6",null,"50mm","no",1]
[]
["J.2",null,"Endplug Insert"]
["J.2.4",null,"32mm","no",1]
["J.2.5",null,"40mm","no",1]
["J.2.6",null,"50mm","no",1]
[]
["J.3",null,"Equal Tee insert"]
["J.3.4",null,"32mm","no",1]
["J.3.5",null,"40mm","no",1]
["J.3.6",null,"50mm","no",1]
[]
[]
["J",null,"Carried forward"]
["J",null,"Brought forward"]
[]
["J.4",null,"Elbow insert"]
["J.4.4",null,"32mm","no",1]
["J.4.5",null,"40mm","no",1]
["J.4.6",null,"50mm","no",1]
[]
["J.5",null,"Male Adaptors"]
["J.5.4",null,"32mm","no",1]
["J.5.5",null,"40mm","no",1]
["J.5.6",null,"50mm","no",1]
[]
["J.6",null,"Reducing Male Adaptors"]
["J.6.3",null,"32mm x 25mm","no",1]
["J.6.4",null,"40mm x 32mm","no",1]
["J.6.5",null,"40mm x 50mm","no",1]
["J.6.6",null,"50mm x 40mm","no",1]
[null,null,null,null,null,null,{"$f":"F39*E39","v":0}]
[null,null,null,null,null,null,0]
["J",null,"Carried forward",null,null,null,0]
["J",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["J.8",null,"Female Adaptors"]
["J.8.4",null,"32mm","no",1]
["J.8.5",null,"40mm","no",1]
[]
["J.9",null,"Reducing Insert couplings"]
["J.9.4",null,"40mm x 25mm","no",1]
["J.9.5",null,"40mm x 32mm","no",1]
["J.9.6",null,"50mm x 25mm","no",1]
["J.9.7",null,"50mm x 32mm","no",1]
["J.9.8",null,"50mm x 40mm","no",1]
[]
["J.10",null,"Male Combination Elbow Adaptor"]
["J.10.6",null,"32mm x 32mm","no",1]
["J.10.7",null,"40mm x 40mm","no",1]
["J.10.8",null,"50mm x 50mm","no",1]
[]
[]
["J",null,"Carried forward"]
["J",null,"Brought forward"]
[]
["J.11",null,"Female Combination Elbow Adaptor"]
["J.11.5",null,"32mm x 32mm","no",1]
["J.11.6",null,"40mm x 40mm","no",1]
["J.11.7",null,"40mm x 50mm","no",1]
["J.11.8",null,"50mm x 40mm","no",1]
["J.11.9",null,"50mm x 50mm","no",1]
[null,null,null,null,null,null,0]
["J.12",null,"Male Combination Tee",null,null,null,{"$f":"F71*E71","v":0}]
["J.12.9",null,"32mm x 32mm","no",1]
["J.12.10",null,"40mm x 25mm","no",1]
["J.12.11",null,"40mm x 32mm","no",1]
["J.12.12",null,"40mm x 40mm","no",1]
["J.12.13",null,"50mm x 25mm","no",1]
["J.12.15",null,"50mm x 40mm","no",1]
["J.12.16",null,"50mm x 50mm","no",1]
["J",null,"Carried forward"]
["J",null,"Brought forward"]
[]
["J.13",null,"Female Combination Tee"]
["J.13.9",null,"32mm x 32mm","no",1]
["J.13.10",null,"40mm x 25mm","no",1]
["J.13.11",null,"40mm x 32mm","no",1]
["J.13.12",null,"40mm x 40mm","no",1]
["J.13.13",null,"50mm x 25mm","no",1]
["J.13.14",null,"50mm x 32mm","no",1]
["J.13.15",null,"50mm x 40mm","no",1]
["J.13.16",null,"50mm x 50mm","no",1]
[]
["J.14",null,"Reducing Tee"]
["J.14.4",null,"40mm x 25mm","no",1]
["J.14.5",null,"40mm x 32mm","no",1]
["J.14.6",null,"50mm x 25mm","no",1]
["J.14.7",null,"50mm x 32mm","no",1]
["J.14.8",null,"50mm x 40mm","no",1]
[]
["J",null,"Carried forward"]
["J",null,"Brought forward"]
[]
["J.15",null,"LDPE pipe complete with fittings (Class 6)"]
["J.15.3",null,"32mm","m",1]
["J.15.4",null,"40mm","m",1]
["J.15.5",null,"50mm","m",1]
[]
["J.16",null,"LDPE pipe complete with fittings (Class 3)"]
["J.16.3",null,"32mm","m",1]
["J.16.4",null,"40mm","m",1]
["J.16.5",null,"50mm","m",1]
[]
["J.17",null,"Other LDPE Pipes"]
["J.17.1",null,"Mark up on other LDPE Pipes as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1]
["J.17.2",null,"Mark up on other LDPE Pipes. ","%",{"$f":"F113","v":0}]
["J.17.3",null,"Extra over Item J.17.2: Deliver, Install, Testing and Commission other LDPE Pipes.","m",100]
[]
["J.18",null,"Other Insert Fittings (Poly Prop) for LDPE Pipes"]
["J.18.1",null,"Mark up on other Insert Fittings (Poly Prop) for LDPE Pipes as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,10000,"Rate only"]
["J.18.2",null,"Mark up on other  Insert Fittings (Poly Prop) for LDPE Pipes. ","%",{"$f":"F118","v":10000}]
["J.18.3",null,"Extra over Item J.18.2: Deliver, Install, Testing and Commission other  Insert Fittings (Poly Prop) for LDPE Pipes.","no",1]
[null,null,null,null,null,null,0]
[]
[]
[null,null,"TOTAL SECTION \" J \" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G5:G122)","v":0}]

{"sheet":"Valves & Meters","index":10,"n_rows":140,"n_cols":7,"rows_kept":140,"cut":false,"hidden":false,"merged":[[139,2,139,4],[139,5,139,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION K : VALVES & METERS"]
["K",null,"Supply, deliver,install and test the following  valves"]
["K.1",null,"PVC ball valve (PN 16)"]
["K.1.1",null,"15mm","no",1]
["K.1.2",null,"20mm","no",1]
["K.1.3",null,"25mm","no",1]
["K.1.4",null,"32mm","no",1]
["K.1.5",null,"40mm","no",1]
["K.1.6",null,"50mm","no",1]
[]
["K.2",null,"Solvent Weld PVC ball valve  (PN16)"]
["K.2.1",null,"15mm","no",1]
["K.2.2",null,"20mm","no",1]
["K.2.3",null,"25mm","no",1]
["K.2.4",null,"32mm","no",1]
["K.2.5",null,"40mm","no",1]
["K.2.6",null,"50mm","no",1]
["K.2.7",null,"63mm","no",1]
["K.2.8",null,"80mm","no",1]
["K.2.9",null,"90mm","no",1]
["K.2.10",null,"100mm","no",1]
[]
["K.3",null,"Stainless Steel ball valve  (PN16)"]
["K.3.1",null,"15mm","no",1]
["K.3.2",null,"20mm","no",1]
["K.3.3",null,"25mm","no",1]
["K.3.4",null,"32mm","no",1]
["K.3.5",null,"40mm","no",1]
["K.3.6",null,"50mm","no",1]
[]
["K",null,"Carried forward"]
["K",null,"Brought forward"]
["K.4",null,"Flanged cast iron gate valve  (PN25)           (SANS 664)"]
["K.4.1",null,"50 mm","no",1]
["K.4.2",null,"80 mm","no",1]
["K.4.3",null,"100 mm","no",1]
["K.4.4",null,"150 mm","no",1]
["K.4.5",null,"200 mm","no",1]
["K.4.6",null,"250 mm","no",1]
[]
["K.5",null,"Wafer butterfly valve with lever handle (PN16)"]
["K.5.1",null,"50 mm","no",1]
["K.5.2",null,"65 mm","no",1]
["K.5.3",null,"80 mm","no",1]
["K.5.4",null,"100 mm","no",1]
["K.5.5",null,"125 mm","no",1]
["K.5.6",null,"150 mm","no",1]
["K.5.7",null,"200 mm","no",1]
["K.5.8",null,"250 mm","no",1]
[]
["K.6",null,"Wafer Butterfly valve, Stainless Steel with lever handle (PN16)"]
["K.6.1",null,"50 mm","no",1]
["K.6.2",null,"65 mm","no",1]
["K.6.3",null,"80 mm","no",1]
["K.6.4",null,"100 mm","no",1]
["K.6.5",null,"125 mm","no",1]
["K.6.6",null,"150 mm","no",1]
["K.6.7",null,"200 mm","no",1]
["K.6.8",null,"250 mm","no",1]
[]
["K",null,"Carried forward"]
["K",null,"Brought forward"]
["K.7",null,"Supply, deliver, install and test the following diaphram irrigation control valves"]
[]
["K.7.1",null,"Manually Controlled Valve complete with 3-way selector (Closed, Outo, Open) PN 10"]
[null,null,"a) 50 mm","no",1]
[null,null,"b) 65 mm","no",1]
[null,null,"c) 80 mm","no",1]
[null,null,"d) 100 mm","no",1]
[]
["K.7.2",null,"Solenoid Controlled Valve complete with 3-way solenoid (PN 10)"]
[null,null,"a) 50 mm","no",1]
[null,null,"b) 65 mm","no",1]
[null,null,"c) 80 mm","no",1]
[null,null,"d) 100 mm","no",1]
[]
["K.7.3",null,"Pressure Reducing Valve complete with 3-way selector and 3-way Pilot valve"]
[null,null,"a) 50 mm","no",1]
[null,null,"b) 65 mm","no",1]
[null,null,"c) 80 mm","no",1]
[null,null,"d) 100 mm","no",1]
[null,null,"e) 150 mm","no",1]
[null,null,"f) 200 mm","no",1]
[]
["K.7.4",null,"Other Valves"]
["K.7.4.1",null,"Mark up on other Valves as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,15000,"Rate only"]
["K.7.4.2",null,"Mark up on other Valves. ","%",{"$f":"F87","v":15000}]
["K.7.4.3",null,"Extra over Item K.7.4.2: Deliver, Install, Testing and Commission other Valves.","set",1]
[]
["K",null,"Carried forward"]
["K",null,"Brought forward"]
["K.8",null,"Supply deliver and install the following water meters"]
["K.8.1",null,"Cast Iron , Epoxy coated (Flange Table D)"]
[null,null,"a) 40 mm","no",1]
[null,null,"b) 50 mm","no",1]
[null,null,"c) 65 mm","no",1]
[null,null,"d) 80 mm","no",1]
[null,null,"e) 90 mm","no",1]
[null,null,"f) 100 mm","no",1]
[]
["K.8.2",null,"Other Water Meters"]
["K.8.2.1",null,"Mark up on other Water Meters as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,15000,"Rate only"]
["K.8.2.2",null,"Mark up on other Water Meters. ","%",{"$f":"F103","v":15000}]
["K.8.2.3",null,"Extra over Item K.8.2.2: Deliver, Install, Testing and Commission other Water Meters.","set",1]
[]
["K.9",null,"Supply, deliver,install and test the following air valves and fittings."]
["K.9.1",null,"Double purpose air valves"]
[null,null,"a) 25 mm","no",1]
[null,null,"b) 32 mm","no",1]
[null,null,"c) 40 mm","no",1]
[null,null,"d) 50 mm","no",1]
[]
["K.9.2",null,"Vacuum breakers"]
[null,null,"a) 25 mm","no",1]
[null,null,"b) 32 mm","no",1]
[null,null,"c) 40 mm","no",1]
[null,null,"d) 50 mm","no",1]
[null,null,null,null,null,null,{"$f":"F119*E119","v":0}]
["K",null,"Carried forward",null,null,null,0]
["K",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["K.9.3",null,"Automatic air valves,",null,null,null,0]
[null,null,"a) 25 mm","no",1]
[null,null,"b) 32 mm","no",1]
[null,null,"c) 40 mm","no",1]
[null,null,"d) 50 mm","no",1]
[]
["K.9.4",null,"Other Air Valves"]
["K.9.4.1",null,"Mark up on other Air Valves as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,10000,"Rate only"]
["K.9.4.2",null,"Mark up on other Air Valves. ","%",{"$f":"F130","v":10000}]
["K.9.4.3",null,"Extra over Item K.9.4.2: Deliver, Install, Testing and Commission other Air Valves.","set",1]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"F134*E134","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
[]
[null,null,"TOTAL SECTION \"K\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G138)","v":0}]

{"sheet":"Shadenet ","index":11,"n_rows":113,"n_cols":7,"rows_kept":113,"cut":false,"hidden":false,"merged":[[112,2,112,4],[112,5,112,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION L : SHADENET"]
["L",null,"Supply deliver and install the following SABS approved shadenet materials and accessories. Shade Cloth to be manufactured from HDPE (High-Density Polyethylene) with  UV stabiliser"]
[]
["L.1",null,"Shade Cloth"]
["L.1.1",null,"20% Shade White","m2",1]
["L.1.2",null,"40% Shade White","m2",1]
["L.1.3",null,"20%  Green","m2",1]
["L.1.4",null,"40%  Green","m2",1]
["L.1.5",null,"50%  Green","m2",1]
["L.1.6",null,"80%  Green","m2",1]
["L.1.7",null,"20%  Black","m2",1]
["L.1.8",null,"40%  Black","m2",1]
["L.1.9",null,"50%  Black","m2",1]
["L.1.10",null,"80%  Black","m2",1]
[]
["L.2",null,"CCA Grade H4 poles  (75-100)"]
["L.2.1",null,"2.1 m","no",1]
["L.2.2",null,"2.4 m","no",1]
["L.2.3",null,"2.7 m","no",1]
["L.2.4",null,"3 m","no",1]
["L.2.5",null,"3.6 m","no",1]
["L.2.6",null,"4,2 m","no",1]
["L.2.7",null,"4.8 m","no",1]
[]
["L.3.1",null,"CCA Grade H4 poles  (100-125)"]
["L.3.1",null,"2.1 m","no",1]
["L.3.2",null,"2.4 m","no",1]
["L.3.3",null,"2.7 m","no",1]
["L",null,"Carried forward"]
["L",null,"Brought forward"]
["L.3.4",null,"3 m","no",1]
["L.3.5",null,"3.3 m","no",1]
["L.3.6",null,"3.6 m","no",1]
["L.3.7",null,"3.9 m","no",1]
["L.3.8",null,"4.2 m","no",1]
[]
["L.4",null,"CCA Grade H4 poles  (125-150)"]
["L.4.1",null,"2.1 m","no",1]
["L.4.2",null,"2.4 m","no",1]
["L.4.3",null,"2.7 m","no",1]
["L.4.4",null,"3 m","no",1]
["L.4.5",null,"3.6 m","no",1]
["L.4.6",null,"4,2 m","no",1]
["L.4.7",null,"4.8 m","no",1]
[]
["L.5",null,"CCA Grade H4 poles  (150-175)"]
["L.5.1",null,"2.1 m","no",1]
["L.5.2",null,"2.4 m","no",1]
["L.5.3",null,"2.7 m","no",1]
["L.5.4",null,"3 m","no",1]
["L.5.5",null,"3.6 m","no",1]
["L.5.6",null,"4,2 m","no",1]
["L.5.7",null,"4.8 m","no",1]
[]
["L.6",null,"ANCHORS"]
["L.6.1",null,"Duckbill type - minimum Model 88 - installed as per manufactures specifications","no",1]
["L.6.2",null,"Manta Ray type - minimum MR2 type - installed as per manufactures specifications.","no",1]
["L",null,"Carried forward"]
["L",null,"Brought forward"]
["L.6.3",null,"Tyre type - minimum vehicle tyre size 14\" installed and secured at minimum depth of 800mm","no",1]
["L.6.4",null,"Casted concrete blocks - min 15Mpa/19, min of 0.5m x 0.5m x 0.5m,installed at miimum depth of 800mm","no",1]
[]
["L.7",null,"ACCESSORIES"]
["L.7.1",null,"M10 Wire tensioners with shackles on both ends","no",1]
["L.7.2",null,"M12 Wire tensioners with shackles on both ends","no",1]
["L.7.3",null,"2.5 x 25mm Nail staples","no",1]
["L.7.4",null,"2.5 x 30mm Nail staples","no",1]
["L.7.5",null,"2.5 x 40mm Nail staples","no",1]
["L.7.6",null,"3 x 30mm Nail staples","no",1]
["L.7.7",null,"3.5 x 30mm Nail staples","no",1]
["L.7.8",null,"4 x 30mm Nail staples","no",1]
["L.7.9",null,"2.5 x 40mm Nail staples","no",1]
["L.7.10",null,"3 x 40mm Nail staples","no",1]
["L.7.11",null,"3.5 x 40mm Nail staples","no",1]
["L.7.12",null,"4 x 40mm Nail staples","no",1]
["L.7.13",null,"25mm Flat head ceiling nails","no",1]
["L.7.14",null,"4,0mm Roof Wire for anchor poles","m",1]
["L.7.15",null,"2,24mm high tensile Steel wire for netting","no",1]
["L.7.16",null,"2,0mm Galvanized wire clamps for net wire (fabricate from wire)","no",1]
["L.7.17",null,"40mm Wire Staples","no",1]
["L.7.18",null,"32mm Wire staples","no",1]
["L.7.19",null,"M12 x 1 000mm long galvanized round bar","no",1]
["L.7.20",null,"M10 x 1 000mm Long galvanized round bar","no",1]
["L.7.21",null,"M12 galvanized washers","no",1]
["L",null,"Carried forward"]
["L",null,"Brought forward"]
["L.7.22",null,"M10 Galvanized washers","no",1]
["L.7.23",null,"M12 Galvanized nuts","no",1]
["L.7.24",null,"M10 Galvanized nuts","no",1]
["L.7.25",null,"M10 x 2 000mm Galvanized anchors made from round bar ","no",1]
["L.7.26",null,"1500mm Long Y-standard Iron fencing poles ","no",1]
["L.7.27",null,"150,000 Galv hogrings(15 boxes)","no",1]
["L.7.28",null,"3000 x 5 mm Aluminium Ferrules","no",1]
["L.7.29",null,"2000 x 6 mm Aluminium Ferrules","no",1]
["L.7.30",null,"7 x 1.6 mm Galvanised staywire","m",1]
["L.7.31",null,"7 x 2 mm Galvanised staywire","m",1]
["L.7.32",null,"7 x 2.65 mm Galvanised staywire","m",1]
["L.7.33",null,"7 x 3.25 mm Galvanised staywire","m",1]
["L.7.34",null,"7 x 4 mm Galvanised staywire","m",1]
["L.7.35",null,"M10 Galv. Straining bolts","no",1]
["L.7.36",null,"M12 Turnbuckle & Eye Hook","no",1]
["L.7.37",null,"M16 Turnbuckle & Eye Hook","no",1]
["L.7.38",null,"1500m x 12mm rust treated anchor steel","no",1]
["L.7.39",null,"vine grips","no",1]
["L.7.40",null,"Double wrap grip","no",1]
["L.7.41",null,"2,24mm high tension steel wire.Full galvanised","m",1]
["L.7.42",null,"10mm Crosby Clamps","no",1]
["L.7.43",null,"Ref 888 mesh for ground anchor blocks","m2",1]
["L.7.44",null,"25MPa concrete for anchoring ","m3",1]
["L.7.45",null,"500x500x150mm depth concrete shutter for shuttering anchor blocks","no",1]
[]
[null,null,"TOTAL SECTION \"L\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G111)","v":0}]

{"sheet":"Tunnels","index":12,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":false,"merged":[[75,2,75,4],[75,5,75,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION M : TUNNELS & RESEVOIRS"]
[]
["M.1",null,"Greenhouse Tunnel"]
[null,null,"Supply deliver and install complete Greenhouse Tunnel, inclusive of 200-micron UV protected, 3 layer Greenhouse  plastic, door (minimum 1,9 x 2 m), front and rear - end ventilation flap, concrete footings (minimum 500 x 300 mm), and manufactured from galvanised steel members with the following minimum specifications:\n\na) Side pole - 48 mm x 2 mm\nb) Arches - 42 mm x 2 mm\nc) Tie beams - 34 mm x 2 mm\nd) Connecting poles - 42 mm x 2 mm\ne) Other connecting poles = 34 mm x 2 mm"]
["M.1.1",null,"15 m x 10 m x 4 m (Minimum)","Sum",1]
["M.1.2",null,"30 m x 10 m x 4 m (Minimum)","Sum",1]
["M.1.3",null,"30 m x 20 m x 4 m (Minimum)","Sum",1]
[]
["M.2",null,"Greenhouse Tunnel Accessories"]
["M.2.1",null,"10 L (125 - 150 micron) black planting bag","no",1]
["M.2.2",null,"Trellising hooks ","no",1]
["M.2.3",null,"Heavy duty polypropolyne trellising twine, 5kg roll","roll",1]
["M.2.4",null,"All in one pH and EC meter (Bluelab OnePen or similar approved)","no",1]
["M.2.5",null,"4 mm Galvanised Wire (50kg x 4mm x 500)  for Crop Support in the Tunnels","roll",1]
["M.2.6",null,"200 Micron UV protected, 3 layer Greenhouse plastic","m²",1]
["M.2.7",null,"Floor plastic, UV stabilized 200 Micron, Roll 11,5m x 31m.","roll",1]
[]
[]
[]
[]
["M",null,"Carried forward"]
["M",null,"Brought forward"]
[]
["M.3",null,"Provisional Sum"]
["M.3.1",null,"Allow Provisional sum for the installation of tunnel equipment such as fertigation, pumping unit. Computer aided monitoring, ventilation controls by specialist manufacturing company","Prov sum",1,200000,"rate only"]
["M.3.2",null,"Profit Over Item M.3.1","%",{"$f":"F26","v":200000}]
["M.3.3",null,"Allow Provisional sum for the erection of Semi-automated Ventilated Tunnel House by specialist manufacturing company","Prov sum",1,5000000,"rate only"]
["M.3.4",null,"Profit Over Item M.3.3","%",{"$f":"F28","v":5000000}]
[]
["M.4",null,"Polyethylene Water Tank"]
[null,null,"Supply, erect and anchored elevated polyethylene water tank onto tank stand (3,6 & 9m high):"]
["M.4.1",null,"5 000 Litres LDPE Tank","sum",1]
["M.4.2",null,"10 000 Litres LDPE Tank","sum",1]
["M.4.4",null,"Install and test all the pipe work and fittings for an elevated tank installation and connect to a water supply for a 10 000 or 5 000 litre tank.","sum",1]
[]
["M.5",null,"Steel Tank Stand"]
[null,null,"Supply and erect a prefabricated complete elevated steel tank stand (painted) with Engineers Certificate suitable for a 10 000-storage tank:"]
["M.5.1",null,"3 meter high for 10 000 litres","sum",1]
["M.5.2",null,"6 meter high for 10 000 litres","sum",1]
["M.5.3",null,"9 meter high for 10 000 litres","sum",1]
[]
[null,null,"Supply and erect a prefabricated complete elevated steel tank stand (painted) with Engineers Certificate suitable for a 5 000-storage tank:"]
["M.5.4",null,"3 meter high for 5 000 litres","sum",1]
["M.5.5",null,"6 meter high for 5 000 litres","sum",1]
["M.5.6",null,"9 meter high for 5 000 litres","sum",1]
[]
[]
["M",null,"Carried forward"]
["M",null,"Brought forward"]
[]
["M.6",null,"Concrete"]
[null,"SANS 1200G","Casting of concrete footings, inclusive of excavations (1m x 1m x 1m per footing)"]
["M.6.1",null,"Class 25/19 concrete","m³",1]
[]
["M.7",null,"Prefabricated Galvanized steel water reservoir"]
[null,null,"Prefabricated Galvanized steel water reservoir complete with roof, internal ladder, external cat ladder with safety cage, 1x inlet (50 mm) including galvanized steel inlet pipe and fittings, outlet (80 mm) including valve, overflow, manhole, scour valve, whirlybird or similar approved ventilator, water level indicator, concrete ring beam or slab with Engineers Certificate were applicable and PVC lining in the following size categories:"]
["M.7.1",null,"240 000 to 260 000 Litres capacity","litre",1]
["M.7.2",null,"260 000 to 280 000 Litres capacity","litre",1]
["M.7.3",null,"490 000 to 550 000 Litres capacity","litre",1]
["M.7.4",null,"740 000 to 800 000 Litres capacity","litre",1]
["M.7.5",null,"1 000 000  to  1 100 000 Litres capacity","litre",1]
[]
["M.8",null,"HDPE Dam Linning"]
[null,null,"Supply, deliver, install and commission HDPE Dam Linnings. Including on-site plastic welding."]
["M.8.1",null,"HDPE Dam Linning 1,5mm","m²",1]
["M.8.2",null,"HDPE Dam Linning 2,0mm","m²",1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL SECTION \"M\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G3:G75)","v":0}]

{"sheet":"Centre Pivot","index":13,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,2,42,4],[42,5,42,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION N : CENTRE PIVOT"]
[]
["N",null,"CENTRE PIVOT IRRIGATION"]
[null,null,"Provisional sum for the Supply, deliver, install, test, and commission of a complete Centre Pivot Irrigation by a reputable supplier as specified by the Engineer. (Turn-key solution)"]
[]
["N.1",null,"Non-towable Centre Pivot"]
["N.1.1",null,"Single span Centre Pivot cover up to 3,0 Ha.","PC sum",1,400000,"rate only"]
["N.1.2",null,"Two span Centre Pivot cover up to 8,6 Ha.","PC sum",1,700000,"rate only"]
["N.1.3",null,"Three span Centre Pivot cover up to 17,0 Ha.","PC sum",1,2000000,"rate only"]
[null,null,"Mark up on above","%",{"$f":"F10+F9+F8","v":3100000}]
["N.2",null,"Towable Centre Pivot"]
["N.2.1",null,"Single span Centre Pivot cover up to 3,0 Ha.","sum",1,450000,"rate only"]
["N.2.2",null,"Two span Centre Pivot cover up to 8,6 Ha.","sum",1,700000,"rate only"]
["N.2.3",null,"Three span Centre Pivot cover up to 17,0 Ha.","sum",1,2200000,"rate only"]
[null,null,"Mark up on above","%",{"$f":"F15+F14+F13","v":3350000}]
["N.3",null,"Other Centre Pivot components"]
["N.3.1",null,"Mark up on other Centre Pivot components as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,90000,"rate only"]
["N.3.2",null,"Mark up on other Centre Pivot components. ","%",{"$f":"F18","v":90000}]
[]
[]
[]
[]
["N",null,"Carried forward"]
["N",null,"Brought forward"]
[]
["N.5",null,"Concrete"]
[null,"SANS 1200G","Casting of concrete footings / platforms as specified by Centre Pivot Supplier, inclusive of excavations."]
["N.5.1",null,"Class 25/19 concrete","m³",1]
["N.5.2",null,"Escavation for footings / platforms","m³",1]
["N.5.3",null,"Pipeline marker, Concrete (Class 25/19), 150x100mm top and 250x250mm base, 2m long (Supply and install)","no",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL SECTION \"N\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G39)","v":0}]

{"sheet":"Building","index":14,"n_rows":282,"n_cols":7,"rows_kept":282,"cut":false,"hidden":false,"merged":[[281,2,281,4],[281,5,281,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION P : BUILDING"]
[]
["P.1",null,"DEMOLISHING AND REMOVING"]
["P.1.1",null,"Demolish existing building structures comprising of brickwork, roofing, closures and foundations. and dispose safely.","m2",1]
["P.1.2",null,"Demolision of non-reinforced concrete","m2",1]
["P.1.3",null,"Demolision of reinforced concrete","m2",1]
["P.1.4",null,"Cart away rubble from demolitions and dispose off site.","m3",1]
["P.1.5",null,"Restore site with soil material filling and compaction.","m3",1]
["P.1.6",null,"Empty Sewage Septic tank and dispose in line with regulations.","m3",1]
["P.1.7",null,"Decommission a pit toilet, including treatment, removal and disposal of sludge waste.","no",1]
[]
["P.2",null,"EARTHWORKS "]
[null,null,"Excavation in earth not exceeding 1,5m deep:"]
["P.2.1",null,"Foundation Trenches","m3",1]
["P.2.2",null,"Footing Holes.","m3",1]
["P.2.3",null,"Cut levels and depositing excavated material in prescribed stock piles on site.","m3",1]
[null,null,"Extra over trench and hole excavations in earth for excavation in:"]
["P.2.4",null,"Intermediate excavation","m3",1]
["P.2.5",null,"Soft/loose rock","m3",1]
["P.2.6",null,"Hard rock","m3",1]
[null,null,"Extra over all excavations for carting away:"]
["P.2.7",null,"Surplus material from excavations and/or stock piles on site to a dumping site to be located by the contractor.","m3",1]
[null,null,"Risk of collapse of excavations:"]
["P.2.8",null,"Shoring Sides of trench and hole excavations not exceeding 1,5m deep.","m2",1]
["P.2.9",null,"Shoring Sides of trench and hole excavations exceeding 1,5m deep.","m2",1]
[]
[]
["P",null,"Carried forward"]
["P",null,"Brought forward"]
[]
[null,null,"Keeping excavations free of water:"]
["P.2.10",null,"Keeping excavations free from mud and storm water ","Sum",1]
["P.2.11",null,"Handling and Keeping excavations free from water irrespective of source.","Sum",1]
[]
["P.3",null,"SOIL POISONING"]
[null,null,"Vegetation herbicide and anti-termite soil poisoning applied by a Registered Pest Control company utilizing complaint chemicals"]
["P.3.1",null,"Surrouding area, foundation trenches/ furrows, under floors, forming agaisnt foundation walls.","m2",1]
["P.3.2",null,"To bottoms and sides of trenches, holes, etc.","m2",1]
[]
["P.4",null,"BACK FILLING"]
["P.4.1",null,"Back filling obtained from the excavations and / or prescribed stock piles on site (minimum G7 material) compacted to 93% Mod. AASHTO density.","m3",1]
["P.4.2",null,"Imported G5 filling, selected and supplied by the Contractor, including depositing in layers not exceeding 150mm thick and compacting to 98% modified AASHTO dry densit.","m3",1]
["P.4.3",null,"Imported G7 filling, selected and supplied by the Contractor, including depositing in layers not exceeding 150mm thick and compacting to 98% modified AASHTO dry density. ","m3",1]
["P.4.4",null,"Coarse river sand filling supplied by the contractor.","m3",1]
["P.4.5",null,"Compaction of in-situ material under floors etc including scarifying for a depth of 150mm, breaking down oversize material, adding suitable material where necessary and compacting to 93% Mod AASHTO density.","m3",1]
["P.4.6",null,"Allow for Prescribed density tests on filling compaction by an approved laboratory to determine density of filling material.","no",1]
["P.4.7",null,"Allow for sample collection and submitting for test by an approved laboratory to determine material class, for site stock piled and borrowing materials","no",1]
[]
[]
[]
["P",null,"Carried forward"]
["P",null,"Brought forward"]
[]
["P.5",null,"CONCRETE"]
["P.5.1",null,"Surface blinding layer under footings and bases (15Mpa/19mm Concrete).","m3",1]
["P.5.2",null,"Surface screeds (20Mpa/19mm), limited to 30mm thick","m3",1]
["P.5.3",null,"25Mpa/19mm Un-Reinforced concrete casting and vibrated for Foundations, footings, etc. ","m3",1]
["P.5.4",null,"25Mpa/19mm Reinforced concrete casting and vibrated for Foundations, footings, etc. ","m3",1]
["P.5.5",null,"30Mpa/19mm Un-Reinforced concrete casting and vibrated for Foundations, footings, etc. ","m3",1]
["P.5.6",null,"30Mpa/19mm Reinforced concrete casting and vibrated for Foundations, footings, etc. ","m3",1]
["P.5.7",null,"Making and testing of 150x150x150mm concrete strength test cubes ","no",1]
["P.5.8",null,"Concrete Top Surface Finishing: Smooth wood floated finish","m2",1]
["P.5.9",null,"Concrete Top Surface Finishing: Steel Floated Finish","m2",1]
["P.5.10",null,"Charmfers at corners:  19 x 19mm triangular fillet at corners forming","m",1]
[]
["P.6",null,"ROUGH FORMWORK "]
["P.6.1",null,"Permanent Formwork:"]
["P.6.1.1",null,"To sides, edging, risers, ends and reveals, not exceeding 300mm height","m2",1]
["P.6.1.2",null,"To sides, edging, risers, ends and reveals, not exceeding 600mm height","m2",1]
["P.6.1.3",null,"To sides, edging, risers, ends and reveals, not exceeding 1500mm height","m2",1]
["P.6.1.4",null,"Circular columns shuttering","m2",1]
["P.6.1.5",null,"Suspended slabs shuttering","m2",1]
["P.6.2",null,"Temporary Formwork:"]
["P.6.2.1",null,"To sides, edging, risers, ends and reveals, not exceeding 300mm height","m2",1]
["P.6.2.2",null,"To sides, edging, risers, ends and reveals, not exceeding 600mm height","m2",1]
["P.6.2.3",null,"To sides, edging, risers, ends and reveals, not exceeding 1500mm height","m2",1]
["P.6.2.4",null,"Circular columns shuttering","m2",1]
["P.6.2.5",null,"Suspended slabs shuttering","m2",1]
[]
["P",null,"Carried forward"]
["P",null,"Brought forward"]
[]
["P.7",null,"SMOOTH FORMWORK"]
["P.7.1",null,"Permanent Formwork:"]
["P.7.1.1",null,"To sides, edging, risers, ends and reveals, not exceeding 300mm height","m2",1]
["P.7.1.2",null,"To sides, edging, risers, ends and reveals, not exceeding 600mm height","m2",1]
["P.7.1.3",null,"To sides, edging, risers, ends and reveals, not exceeding 1500mm height","m2",1]
["P.7.1.4",null,"Circular columns shuttering","m2",1]
["P.7.1.5",null,"Suspended slabs shuttering","m2",1]
["P.7.2",null,"Temporary Formwork:"]
["P.7.2.1",null,"To sides, edging, risers, ends and reveals, not exceeding 300mm height","m2",1]
["P.7.2.2",null,"To sides, edging, risers, ends and reveals, not exceeding 600mm height","m2",1]
["P.7.2.3",null,"To sides, edging, risers, ends and reveals, not exceeding 1500mm height","m2",1]
["P.7.2.4",null,"Circular columns shuttering","m2",1]
["P.7.2.5",null,"Suspended slabs shuttering","m2",1]
["P.7.2.6",null,"Reinforced precasted rib and block Slabs as permanent shutters - top ref mesh and concrete topping measured elsewhere","m2",1]
[]
["P.8",null,"CONCRETE JOINTS"]
["P.8.1",null,"Saw cut joints: 6mm wide x 50mm deep Saw cut joints on top of concrete","m",1]
["P.8.2",null,"Construction Joints: 6mm Soft board, not exceeding ","m",1]
[]
["P.9",null,"CONCRETE REINFORCEMENT"]
["P.9.1",null,"High tensile steel reinforcement bars to structural concrete work.","t",1]
["P.9.2",null,"Fabric reinforcement:"]
["P.9.2.1",null,"REF. 193 fabric reinforcement in concrete surface beds, raft slabs etc.","m2",1]
["P.9.2.2",null,"REF. 245 fabric reinforcement in concrete surface beds, raft slabs etc.","m2",1]
[]
["P",null,"Carried forward"]
["P",null,"Brought forward"]
[]
["P.9.2.3",null,"REF. 395 fabric reinforcement in concrete surface beds, raft slabs etc.","m2",1]
["P.9.2.4",null,"REF. 617 fabric reinforcement in concrete surface beds, raft slabs etc.","m2",1]
["P.9.2.5",null,"REF. 888 fabric reinforcement in concrete surface beds, raft slabs etc.","m2",1]
[]
["P.10",null,"MASONRY BRICKWORK"]
[null,null,"Supply, Deliver, and Construct Brickwork consisting of solid clay bricks to SABS 227-1986, with 10.5 MPa minimum nominal compressive strength in Class I mortar.  (Cement to be 42.5N all-purpose cement): "]
["P.10.1",null,"Stock Brick 220mm wide (One brick) wall, complete with mortar, ties, etc.","m2",1]
["P.10.2",null,"Stock Brick 110mm wide (Half brick) wall, complete with mortar, ties, etc.","m2",1]
["P.10.3",null,"150mm wide (one brick) using maxi bricks walls.","m2",1]
[null,null,"FACE BRICK: FBS clay face brick , bedded and jointed in Class II mortar and pointed with recessed vertical and horizontal joints (Cement to be 42.5N all-purpose cement): "]
["P.10.6",null,"Supply, Deliver, and Construct Brickwork: Face Brick outside and inside, 220mm wide (One brick) wall, complete with mortar, ties, pointed outside and inside, etc.","m2",1]
["P.10.7",null,"Supply, Deliver, and Construct Brickwork: Face Brick outside and Stock Brick inside, 220mm wide (One brick) wall, complete with mortar, ties, pointed outside, etc.","m2",1]
["P.10.8",null,"Supply, Deliver, and Construct Brickwork: Face Brick outside, 110mm wide (Half brick) wall, complete with mortar, ties, pointed outside, etc.","m2",1]
[]
["P.11",null,"BRICKFORCE"]
["P.11.1",null,"NHBRC Galvanized brickforce: 150 x 2.8 mm","m",1]
["P.11.2",null,"NHBRC Galvanized brickforce: 75 x 2.8 mm","m",1]
[]
["P",null,"Carried forward"]
["P",null,"Brought forward"]
[]
["P.12",null,"ROOF TIES (Bracing Strap)"]
["P.12.1",null,"Bracing Strap (MiTek or similar approved) Galvanized roof tie with one end fixed to timber and other built into brickwork or concrete.","m",1]
[]
["P.13",null,"WATERPROOFING"]
["P.13.1",null,"Sealing of walls with 1:3 cement and sand mixture","m2",1]
["P.13.2",null,"Sealing of walls with two coats of bitumen emulsion waterproofing","m2",1]
["P.13.3",null,"Coprox masonry waterproofing or equal approved waterproof cement additive","kg",10]
[]
["P.14",null,"LINTOLS"]
["P.14.1",null,"Pre-Cast Concrete lintols 75 x 110"]
["P.14.1.1",null,"Lintels 0.9 m","no",1]
["P.14.1.2",null,"Lintels 1.2 m","no",1]
["P.14.1.3",null,"Lintels 1.8 m","no",1]
["P.14.1.4",null,"Lintels 2.4 m","no",1]
["P.14.1.5",null,"Lintels 3 m","no",1]
["P.14.1.6",null,"Lintels 4 m","no",1]
[]
["P.14.2",null,"Pre-Cast Concrete lintols 75 x 150mm"]
["P.14.2.1",null,"Lintels 0.9 m","no",1]
["P.14.2.2",null,"Lintels 1.2 m","no",1]
["P.14.2.3",null,"Lintels 1.8 m","no",1]
["P.14.2.4",null,"Lintels 2.4 m","no",1]
["P.14.2.5",null,"Lintels 3 m","no",1]
["P.14.2.6",null,"Lintels 4 m","no",1]
[]
[]
["P",null,"Carried forward"]
["P",null,"Brought forward"]
[]
["P.15",null,"DAMP PROOFING"]
["P.15.1",null,"One layer of 250 micron waterproof plastic sheeting (For floors)","m2",1]
["P.15.2",null,"Damp proof 110mm x 250 mcron (For walls)","m",1]
[]
["P.16",null,"JOINT SEALANTS"]
["P.16.1",null,"Clear Neutral silicone sealant for joint sealing around windows, door frames, etc.","m",1]
["P.16.2",null,"Two-part grey polysulphide sealing compound (10x12mm) including backing cord, bond breaker, primer, etc for joints in floors, walls, etc. ","m",1]
[]
["P.17",null,"ROOF COVERINGS"]
[null,null,"Galvanised profiled metal sheeting with \"Chromadek\" finish, screws and all accessories, supply and install complete, fixed to roof / clading members."]
["P.17.1",null,"Galvanised IBR profile 0,58mm Z200, with \"Chromadek\" finish.","m²",1]
[null,null,"Galvanised (0.58mm) Flashings \"Chromadek\" finish fixed in strict accordance with manufacturer's instructions  including installation accessories :"]
["P.17.2",null,"Mono pitched ridge capping (\"Chromadek\" finish) with 225mm lapping secured onto the roof.","m",1]
["P.17.3",null,"Ridge cover, 0,58mm (\"Chromadek\" finish). ","m",1]
["P.17.4",null,"Ridge Closures (\"Chromadek\" finish), 0,58mm ridge closures fixed under the ridge line.","m",1]
[]
[null,null,"Galvanised profiled metal sheeting, screws and all accessories, supply and install complete, fixed to roof / clading members."]
["P.17.5",null,"Galvanised IBR profile 0,58mm Z200.","m²",1]
[null,null,"Galvanised (0.58mm) Flashings, fixed in strict accordance with manufacturer's instructions  including installation accessories :"]
["P.17.6",null,"Mono pitched ridge capping with 225mm lapping secured onto the roof.","m",1]
["P.17.7",null,"Ridge cover, 0,58mm. ","m",1]
["P.17.8",null,"Ridge Closures, 0,58mm ridge closures fixed under the ridge line.","m",1]
[null,null,null,null,null,null,{"$f":"F184*E184","v":0}]
["P",null,"Carried forward",null,null,null,0]
["P",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["P.18",null,"ROOF INSULATION",null,null,null,0]
[null,null,"Insulation laid and strained by 2mm galvanized wires on timber roof trusses/ steel purlins",null,null,null,0]
["P.18.1",null,"\"Alububble\"  or equal approved insulation","m2",1]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["P.19",null,"PROVISIONAL SUM FOR STEEL STRUCTURES",null,null,null,0]
["P.19.1",null,"Provisional Sum, as specified by the Engineer, for the fabrication, supply, delivery, erection of a complete Steel Structure with roof and side cladding, doors, insulation, vetilators, steel members treated and painted,etc. Engineers Certificate to be iincluded.","Prov sum",1,800000,"rate only"]
["P.19.2",null,"Profit Over Item P.19.1","%",{"$f":"F194","v":800000}]
[]
["P",null,"Brought forward"]
["P.21",null,"DOORS"]
[null,null,"Supply, deliver and install the following doors complete."]
["P.21.1",null,"Frame and ledge open back solid Meranti door, size 813 x 2032mm. (Exterior use)","no",1]
["P.21.2",null,"Light Duty Hardboard door, size 813 x 2032mm. (Interior use)","no",1]
[]
[]
["P.23",null,"METALWORK"]
[null,null,"STEEL BURGLAR GATES TO DOORS"]
[null,null,"Security Gate (mild steel) consisting of 25 x 25 x 2mm steel frame with 12mm square bars infill placed at 109mm centres, hung with one pair of galvanised hinges including locks, handles, ironmongery complete and fixed to brickwork:"]
["P.23.1",null,"Security gate size 900 x 2050mm high","no",1]
["P.23.2",null,"Security double gate size 1800 x 2050mm high.","no",1]
[]
["P.24",null,"PLASTERING"]
["P.24.1",null,"SCREED: 30mm thick, Untinted granolithic, on concrete.","m2",1]
["P.24.2",null,"SKIRTING: 75mm high coved granolithic skirting","m",1]
["P.24.3",null,"INTERNAL PLASTER: 10mm thick, 1:4 sand cement mixture","m2",1]
[]
["P",null,"Carried forward"]
["P",null,"Brought forward"]
[]
["P.25",null,"PAINTWORK"]
["P.25.1",null,"Prepare wood surfaces (stop, sand down, etc.)  and apply one coat wood primer, one undercoat and two coats eggshell enamel paint (Plascon or equal approved) (Doors, door frames, etc.)","m2",1]
["P.25.2",null,"Prepare and apply two coats carbolenium on exposed timber.","m2",1]
["P.25.3",null,"Prepare and apply two coats pure acrylic roof paint on fascias and barge boards.","m2",1]
["P.25.4",null,"Prepare and apply two coats enamel paint on windows frames, putty, door frames, etc.","m2",1]
[]
["P.26",null,"ROLLER DOORS"]
["P.26.1",null,"Industrial Roller door, Chain operated, 2400 x 3000mm high galvanized with locking mechanism","no",1]
["P.26.2",null,"Industrial Sliding Door on track and guide, 2400 x 3000mm high galvanized with locking mechanism","no",1]
["P.26.3",null,"Standard Garage roll up door 2400 x 2000mm, with a pedestrian lock mechanism","no",1]
[]
["P.27",null,"STEEL WINDOW FRAMES"]
["P.27.1",null,"Supply, deliver and install the following complete steel window frames and glazing."]
["P.27.2",null,"Window frame NC2 (1022 x 949 mm)","no",1]
["P.27.3",null,"Window frame NC4F (1511 x 949 mm)","no",1]
["P.27.4",null,"Window frame C1H (533 x 949 mm)","no",1]
["P.27.5",null,"Window frame NE1 (533 x 359 mm)","no",1]
["P.27.6",null,"Window frame NE11 (1975 x 629 mm)","no",1]
["P.27.7",null,"Glazing including putty, 3 - 4mm clear glass","m2",1]
["P.27.8",null,"Glazing including putty, 4mm frosted glass","m2",1]
[]
["P",null,"Carried forward"]
["P",null,"Brought forward"]
[]
["P.29",null,"STRONG ROOM DOOR"]
["P.29.1",null,"Supply, deliver & install Strong room door, 120mm thick, 6mm outer plate, 2032.5H x 1000W, Outward opening, one key lock with emergency inner release, Mass 150 to 300kg and 7 Lever security keylock 8 bolt, 180 degree opening","no",1]
[null,null,null,null,null,null,{"$f":"F244*E244","v":0}]
["P.30",null,"PRESSED STEEL DOOR FRAMES ",null,null,null,0]
[null,null,"Supply, deliver & install the following mild steel (1,2mm thick) door frames  complete with standard butt hinges and factory applied primer:",null,null,null,0]
["P.30.1",null,"Double rebated frame suitable for half brick (110mm) walls for door 813 x 2032mm high ","no",1]
["P.30.2",null,"Double rebated frame suitable for one brick (220mm) walls for door 813 x 2032mm high ","no",1]
["P.30.3",null,"Double rebated frame suitable for one brick (220mm) walls for door 1511 x 2032mm high ","no",1]
["P.30.4",null,"Combination Door and Frame, Double Door, 1511 x 2 032mm high","no",1]
["P.30.5",null,"Combination Door and Frame, Single Door, 813 x 2 032mm high","no",1]
[null,null,null,null,null,null,0]
["P.31",null,"LOCKS ",null,null,null,0]
["P.31.1",null,"Supply 50 mm \"Viro\" Padlocks and Keys (or equal approved )","no",1]
["P.31.2",null,"Three lever double cylinder lockset code 2222 or similar with Gower Handel code CZ682-05 SC complete with striking plate.","no",1]
["P.31.3",null,"Four- lever double cylinder lockset, with Gower Handel code CZ682-05 SC or similar complete with striking plate.","no",1]
["P.31.4",null,"DMWS-SS-008 or similar Bathroom /WC small case deadlock","no",1]
["P.31.5",null,"Aluminuim door stop with rubber insert","no",1]
[]
["P.32",null,"SIGNAGE PLATES"]
["P.32.1",null,"Wheelchair, pictogram Engraved on 152 x 152 mm stainless steel plate.","no",1]
["P.32.2",null,"Female, pictogram Engraved on 152 x 152 mm stainless steel plate. ","no",1]
["P.32.3",null,"Male, pictogram  Engraved on 152 x 152 mm stainless steel plate. ","no",1]
[]
[null,null,null,null,null,null,{"$f":"F265*E265","v":0}]
["P",null,"Carried forward",null,null,null,0]
["P",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["P.37",null,"HAND RAILS IN TOILETS",null,null,null,0]
["P.37.1",null,"Mark up on Grab Rails as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,5000,"rate only"]
["P.37.2",null,"Mark up on Grab rails. ","%",{"$f":"F270","v":5000}]
["P.37.3",null,"Extra over Item P.37.2: Deliver, and Install Grab Rails.","no",1]
[]
["P.38",null,"FIRE SERVICES"]
["P.38.1",null,"DCP dry powder portable fire extinguisher (4,5kg), including a formed Saligna Wood backboard size 450 x 100 x 22mm thick plugged and screwed to wall and finished with two coats of polyurethane varnish, including 120 x 20 x 2mm Stainless or Galvanised Steel  \"J\" Wall Bracket. ","Set",1]
["P.38.2",null,"Fixed type Fire hose reel complete with ID 20mm x 30m PVC hose (SANS 1086), chromium plated stopcock( 25mm BSP), shut-off nozzle and wall bracket bolted to wall with and including expansion bolts.","Set",1]
[]
["P.39",null,"FIELD SANITATION UNITS"]
[null,null,"Earth-, Concrete-, and Building-works are measured elsewhere."]
["P.39.1",null,"Supply, deliver ,Install and commission a \"Rocla Ama Loo Loo\" or similar approved  Precast Concrete Panel Toilet, 900mm W x 1100mm L x 2000mm H, Complete with prefabricated  walls, roof, door, seat, pit slab cover, and handwash basin.","Sum",1]
["P.39.2",null,"Supply, deliver ,Install ,and commission an \"ENVIRO LOO VIP\", or similar approved.  Prefabricated unit with toilet seat, extraction pipe and fan, collector pit plate setup, back inspection chamber/cover.  Concrete Panel Toilet, 900mm W x 1100mm L x 2000mm H, Complete with prefabricated  walls, roof, door, seat, pit slab cover, and handwash basin.","Sum",1]
[null,null,"TOTAL SECTION \"P\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G281)","v":0}]

{"sheet":"Electricals & Plumning","index":15,"n_rows":157,"n_cols":7,"rows_kept":157,"cut":false,"hidden":false,"merged":[[156,2,156,4],[156,5,156,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[]
[null,null,"ELECTRICAL"]
["R.1",null,"ELECTRICAL - GENERAL"]
["R.1.1",null,"Test the complete electrical works and issue a Certificate of Compliance (CoC) by an applicable certified and registered electrical person.","Sum",1]
["R.1.2",null,"Earth Spike (Include Conductor Termination Clamp)","Sum",1]
[]
["R.2",null,"ELECTRICAL - TRENCHING & EARTHWORKS"]
[null,null,"Trenching (450mm width by 500mm depth for LV Cables) Danger tape: Orange/Yellow PVC material-300mm above cable."]
["R.2.1",null,"Hand pickable soil (soft soil)","m³",1]
["R.2.2",null,"Machine excavation (soft rock)","m³",1]
[]
["R.3",null,"ELECTRICAL CABLES"]
[null,null,"Supply, deliver, install, and test SABS approved copper cables. Inclusive of all terminations and glands."]
["R.3.1",null,"Surfix cable - 1.5mm² x 2 + Earth (Black, White)","m",1]
["R.3.2",null,"Surfix cable - 1.5mm² x 3 + Earth (Black, White)","m",1]
["R.3.3",null,"Surfix cable - 1.5mm² x 4 + Earth (Black, White)","m",1]
["R.3.4",null,"Surfix cable - 2.5mm² x 2 + Earth (Black, White)","m",1]
["R.3.5",null,"Surfix cable - 2.5mm² x 3 + Earth (Black, White)","m",1]
["R.3.6",null,"Surfix cable -2.5mm² x 4 + Earth (Black, White)","m",1]
["R.3.7",null,"Insulated Housewire 1,5mm², 1core cable; red, black, yellow, brown, etc","m",1]
["R.3.8",null,"Insulated Housewire 2,5mm², 1core cable; red, black, yellow, brown, etc","m",1]
["R.3.9",null,"Insulated Housewire 4mm², 1core cable; red, black, yellow, brown, etc","m",1]
["R.3.10",null,"Insulated Housewire 6mm², 1core cable; red, black, yellow, brown, etc","m",1]
["R.3.11",null,"Bare copper Earth wire  (SANS 1411)"]
[null,null,"a) 1.5 mm2","m",1]
[null,null,"b) 2.5 mm2","m",1]
[null,null,"c) 4 mm2","m",1]
["R",null,"Carried forward",null,null,null,{"$f":"F29*E29","v":0}]
["R",null,"Brought forward",null,null,null,0]
["R.4",null,"LIGHT FITTINGS",null,null,null,0]
[null,null,"Supply, deliver, install, and test the following SABS approved light fittings complete with bulbs.",null,null,null,0]
["R.4.1",null,"Bulkhead Rectangular, Including 9w LED globe","no",1]
["R.4.2",null,"Batten Fitting 1,2m (4Ft) for 2 LED lamps, Including 2 x 18 w LED lamps","no",1]
["R.4.3",null,"Dust / Damp Proof 1,2 (4Ft) 2 LED lamps (Frosted UV stabilized polycarbonate), Including 2 x 18 LED lamps.","no",1]
[null,null,null,null,null,null,0]
["R.5",null,"OTHER LIGHT FITTINGS",null,null,null,0]
["R.5.1",null,"Mark up on other Light fittings as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,10000,"rate only"]
["R.5.2",null,"Mark up on other Light Fittings. ","%",{"$f":"F38","v":10000}]
["R.5.3",null,"Extra over Item R.5.2: Deliver, Install, and test other light fittings.","no",1]
[]
["R.6",null,"ENCLOSURES"]
[null,null,"Supply, deliver, install, and test the following Enclosures complete with fittings, etc."]
["R.6.1",null,"Wall Box 100 x 50mm (4 x 2)","no",1]
["R.6.2",null,"Wall Box 100 x 100mm (4 x 4)","no",1]
["R.6.3",null,"Indoor 24 Way DB Box, steel and coated, flash mounted.","no",1]
["R.6.4",null,"Indoor 12 Way DB Box, steel and coated, flash mounted.","no",1]
["R.6.5",null,"Indoor 6 Way DB Box, steel and coated, flash mounted.","no",1]
["R.6.6",null,"Supply, deliver, and install, Mild Steel, Single Door, Lockable Enclosure, IP66, Out door, Powder coating, Including Galvanized Mounting plate."]
[null,null,"a) 200 H x 200 W x 155 D mm","no",1]
[null,null,"b) 300 H x 250 W x 155 D mm","no",1]
[null,null,"c) 350 H x 250 W x 155 D mm","no",1]
[null,null,null,null,null,null,0]
["R.7",null,"OTHER ENCLOSURES",null,null,null,0]
["R.7.1",null,"Mark up on other Enclosures as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,10000,"rate only"]
["R.7.2",null,"Mark up on other Enclosures. ","%",{"$f":"F55","v":10000}]
["R.7.3",null,"Extra over Item R.7.2: Deliver, and Install other Enclosures.","no",1,null,0]
["R",null,"Carried forward",null,null,null,0]
["R",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["R.8",null,"ELECTRICAL SWITCHGEAR",null,null,null,0]
[null,null,"Supply, deliver, install, and test the following Electrical Switchgear, etc.",null,null,null,0]
["R.8.1",null,"Main switch (60Amp)","no",1]
["R.8.2",null,"Earth Leakage circuit breaker (63Amp)","no",1]
["R.8.3",null,"Overload with Earth Leakage circuit breaker (63Amp)","no",1]
["R.8.4",null,"Circuit breaker (10Amp) ","no",1]
["R.8.5",null,"Circuit breaker (15Amp) ","no",1]
["R.8.6",null,"Circuit breaker (20Amp) ","no",1]
["R.8.7",null,"Circuit breaker (25Amp) ","no",1]
["R.8.8",null,"Circuit breaker (30Amp) ","no",1]
["R.8.9",null,"Surge Protection breaker","no",1]
["R.8.10",null,"Waterproof Industrial socket (3 pin), Eurolux or similar","no",1]
["R.8.11",null,"Single socket 3 pin wall plug, 15Amp","no",1]
["R.8.12",null,"Double socket 3 pin wall plug, 15Amp","no",1]
["R.8.13",null,"2 Lever 1 way light switch","no",1]
["R.8.14",null,"3 Lever 1 way light switch","no",1]
[null,null,null,null,null,null,{"$f":"F77*E77","v":0}]
["R.9",null,"CONDUIT PIPES",null,null,null,0]
[null,null,"Supply, deliver, and install the following Conduit pipes, inclusive of all couplings, adaptors, bends, etc.",null,null,null,0]
["R.9.1",null,"PVC Conduit 20mm (Inclusive of all fittings)","m",1]
["R.9.2",null,"PVC Conduit 25mm (Inclusive of all fittings)","m",1]
["R.9.3",null,"PVC Conduit 32mm (Inclusive of all fittings)","m",1]
[null,null,null,null,null,null,0]
["R.10",null,"OTHER ELECTRICAL MATERIAL",null,null,null,0]
["R.10.1",null,"Mark up on other Electrical Material as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,10000,"rate only"]
["R.10.2",null,"Mark up on other Electrical Material. ","%",{"$f":"F85","v":10000}]
["R.10.3",null,"Extra over Item R.10.2: Deliver, and Install other Electrical Material.","no",1]
["R",null,"Carried forward",null,null,null,0]
["R",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,"PLUMBING AND SEWAGE  ",null,null,null,0]
["R.11",null,"Supply, deliver, install, and test the following sanitary fixtures.",null,null,null,0]
["R.11.1",null,"Miami Close Couple Toilet Suit or similar approved, complete with all fittings.","no",1]
["R.11.2",null,"Solo Tamarin Basin and Full Pedestal or similar approved, complete with all fittings.","no",1]
["R.11.3",null,"Icon Urinal Large or similar approved, complete with all fittings.","no",1]
["R.11.4",null,"Supply & install shower head complete with chrome shower arm & Rose, and all accessories to control valves for hot and cold water","no",1]
["R.11.5",null,"Supply & install 450x600x6mm \"GG\"QUALITY POLISHED GLASS MIRROR: Fixed with round nose chromium plated mirrow screws.","no",1]
["R.11.6",null,"Mark up on other Bathroom Accessories as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,10000,"rate only"]
["R.11.7",null,"Mark up on other Bathroom Accessories. ","%",{"$f":"F98","v":10000}]
["R.11.8",null,"Extra over Item R.11.8: Deliver, and Install other Bathroom Accessories.","no",1]
[null,null,null,null,null,null,0]
["R.12",null,"Sewage Pipeline: Supply, deliver, install, and test complete pipelines inclusive of all bends, couplings, saddles, etc.",null,null,null,0]
["R.12.1",null,"Sewage pipe, 50mm PVC, including all fittings.","m",1]
["R.12.2",null,"Sewage pipe, 110mm PVC, including all fittings.","m",1]
["R.12.3",null,"Mark up on other sewer fittings as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,3000,"rate only"]
["R.12.4",null,"Mark up on other sewer fittings. ","%",{"$f":"F105","v":3000}]
["R.12.5",null,"Extra over Item R.12.4: Deliver, and Install other Sewer fittings.","no",1,null,0]
[null,null,null,null,null,null,0]
["R.13",null,"Copper pipes: Supply, deliver, install (Chased into brickwalls), and testing, including joints, bends, sockets, and etc.",null,null,null,0]
["R.13.1",null,"Copper pipe 15mm","m",1]
["R.13.2",null,"Copper pipe 22mm","m",1]
["R.13.3",null,"Copper pipe Joints, Bends, Tees, etc. for 15mm pipe","no",1]
["R.13.4",null,"Copper pipe Joints, Bends, Tees, etc. for 20mm pipe","no",1]
["R",null,"Carried forward",null,null,null,0]
["R",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["R.14",null,"OTHER PIPES AND FITTINGS",null,null,null,0]
["R.14.1",null,"Mark up on other pipes & fittings as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,10000,"rate only"]
["R.14.2",null,"Mark up on other Pipes and Fittings. ","%",{"$f":"F118","v":10000},null,0]
["R.14.3",null,"Extra over Item R.14.2: Deliver, and Install other Pipes and Fittings.","no",1,null,0]
[null,null,null,null,null,null,0]
["R.15",null,"VALVES",null,null,null,0]
[null,null,"Supply, deliver, install, and test the following valves.",null,null,null,0]
["R.15.1",null,"Pressure control valve for 600kPA, on 15 or 20mm pipes","no",1]
["R.15.2",null,"15mm Ball-o-stop valve.","no",1]
["R.15.3",null,"22mm Non Return valve.","no",1]
[null,null,null,null,null,null,0]
["R",null,"Carried forward",null,null,null,0]
["R",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["R.20",null,"PROVISIONAL SUMS",null,null,null,0]
["R.20.1",null,"Allow for a provisional sum for Mechanical/Electrical or processing Equipment required works to be instructed by the engineer for purchase of materials and installation, Below R100 000,00","Prov Sum",1,{"$f":"E134","v":100000},"rate only"]
["R.20.2",null,"Profit over above","%",100000]
["R.20.3",null,"Allow for a provisional sum for Mechanical/Electrical or processing Equipment required works to be instructed by the engineer for purchase of materials and installation, Below R250 000,00","Prov Sum",1,{"$f":"E136","v":250000},"rate only"]
["R.20.4",null,"Profit over above","%",250000]
["R.20.5",null,"Allow for a provisional sum for Mechanical/Electrical or processing Equipment required works to be instructed by the engineer for purchase of materials and installation.                                                          More than R250 000 and Below R1 000 000,00.","Prov Sum",1,{"$f":"E138","v":500000},"rate only"]
["R.20.6",null,"Profit over above","%",500000]
[null,null,null,null,null,null,{"$f":"F139*E139","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["R",null,"Carried forward",null,null,null,0]
["R",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["R.20.7",null,"Allow for a provisional sum for Mechanical/Electrical or processing Equipment required works to be instructed by the engineer for purchase of materials and installation , More than R1 000 000","Prov Sum",1,{"$f":"E146","v":1000000},"rate only"]
["R.20.8",null,"Profit over above","%",1000000,null,0]
["R.20.9",null,"Allow for a provisional sum for Fencing Repairs works to be instructed by the engineer for purchase of materials and installation.","Prov Sum",1,{"$f":"E148","v":60000},"rate only"]
["R.20.10",null,"Profit over above","%",60000,null,0]
[null,null,null,null,null,null,0]
["R.21",null,"TESTING",null,null,null,0]
["R.21.1",null,"Supply all necessary testing apparatus, water, materials, etc. and allow for testing  of plumbing works and issue Certificate of Compliance (COC)","no",1]
[null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,"TOTAL SECTION \"R\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G155)","v":0}]

{"sheet":"Energy","index":16,"n_rows":112,"n_cols":7,"rows_kept":112,"cut":false,"hidden":false,"merged":[[111,2,111,4],[111,5,111,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION S : POWER GENERATION EQUIPMNET"]
["S.1",null,"SOLAR SYSTEM "]
[null,null,"Supply, deliver, install, and test, Pure sine wave invertor complete with: AC/DC compatibility, Overvoltage and undervoltage protection, Overload protection and overcurrent protection, Overtemperature protection, No-load protection, Operating history memory, Detachable control panel, Enclosure class IP66, Automatic generator start, Display of function."]
["S.1.1",null,"Pure sine wave invertor 3kVA","sum",1]
["S.1.2",null,"Pure sine wave invertor 5kVA","sum",1]
["S.1.3",null,"Pure sine wave invertor 8kVA","sum",1]
["S.1.4",null,"Other Pure sine wave invertor","Prov Sum",1,60000,"rate only"]
["S.1.5",null,"Mark-up on Item S.1.4","%",60000]
["S.1.6",null,"Supply and install DC Cicuit breakers and surge protector","sum",1]
["S.1.7",null,"Supply and install Combined Junction Box for solar panels","sum",1]
["S.1.8",null,"Supply and install arrray to array cable for solar panels:  Flexible single core cable for photovoltaic or solar systems, Halogen free, double insulated, zone & UV resistant (AC 1000V & DC 1500V) (Black/Red)"]
[null,null,"a) 1.5 mm2","m",1]
[null,null,"b) 2.5 mm2","m",1]
[null,null,"c) 4 mm2","m",1]
[null,null,"d) 6 mm2","m",1]
[null,null,"e) 10 mm2","m",1]
[]
["S.2",null,"SOLAR PANELS (PV)"]
[null,null,"Supply, deliver, install, and test monocrystalline solar panels complete with all cables, connectors, Junction boxes, surge protectors and Circuit breakers. (Ground, Roof, Elevated or floating installation)"]
[null,null,"a) 300 to 395 W","no",1]
[null,null,"b) 400 to 450 W","no",1]
[null,null,"c) 455 to 495 W","no",1]
[null,null,"d) 500 to 550 W","no",1]
["S",null,"Carried forward"]
["S",null,"Brought forward"]
[null,null,"e) 555 - 595 W","no",1]
[null,null,"f) 600 to 650 W","no",1]
[]
["S.3",null,"SOLAR (PV) MOUNTING SYSTEMS"]
[null,null,"Supply, deliver, install a complete Solar (PV) mounting system including all rails, brackets, fasteners, and steel support structure. (Galvanised or Aluminium)"]
["S.3.1",null,"Roof Top mounting system for PV Solar panels."]
[null,null,"a) One (1) PV solar panel.","Sum",1]
[null,null,"b) Set of two (2) PV solar panels.","Sum",1]
[null,null,"c) Set of three (3) PV solar panels.","Sum",1]
[null,null,"d) Set of four (4) PV solar panels.","Sum",1]
["S.3.2",null,"Ground mounting structure for PV Solar panels."]
[null,null,"a) One (1) PV solar panel.","Sum",1]
[null,null,"b) Set of two (2) PV solar panels.","Sum",1]
[null,null,"c) Set of three (3) PV solar panels.","Sum",1]
[null,null,"d) Set of four (4) PV solar panels.","Sum",1]
["S.3.3",null,"Mounting structure on top of water tank and  tank stand for PV Solar panels."]
[null,null,"a) One (1) PV solar panel.","Sum",1]
[null,null,"b) Set of two (2) PV solar panels.","Sum",1]
[null,null,"c) Set of three (3) PV solar panels.","Sum",1]
[null,null,"d) Set of four (4) PV solar panels.","Sum",1]
["S.3.4",null,"Single Pole mounting structure for PV panels."]
[null,null,"a) One (1) PV solar panel.","Sum",1]
[null,null,"b) Set of two (2) PV solar panels.","Sum",1]
[null,null,"c) Set of three (3) PV solar panels.","Sum",1]
[null,null,"d) Set of four (4) PV solar panels.","Sum",1]
["S.3.5",null,"Floating HDPE platform for PV panels. (Tilted)"]
[null,null,"a) Float for one (1) PV solar panel.","Sum",1]
[null,null,"b) Float for Set of two (2) PV solar panels.","Sum",1]
["S",null,"Carried forward"]
["S",null,"Brought forward"]
[null,null,"c) Float for Set of three (3) PV solar panels.","Sum",1]
[null,null,"d) Float for Set of four (4) PV solar panels.","Sum",1]
["S.3.6",null,"Solar DB Board",null,null,null,{"$f":"F59*E59","v":0}]
[null,null,"Supply, deliver, install, and test complete solar DB Board",null,null,null,0]
["S.3.6.1",null,"Complete combiner box, MCE CB1-1, 32 A, 1000 VDC, Input Strings 1, Output Strings 1","Sum",1]
["S.3.6.2",null,"Complete combiner box, MCE CB2-1, 32 A, 1000 VDC, Input Strings 2, Output Strings 1","Sum",1]
["S.3.6.3",null,"Complete combiner box, MCE CB2-2, 32 A, 1000 VDC, Input Strings 2, Output Strings 2","Sum",1]
["S.3.6.4",null,"Complete combiner box, MCE CB4-1, 32 A, 1000 VDC, Input Strings 4, Output Strings 1","Sum",1]
["S.3.6.5",null,"Complete combiner box, MCE CB4-2, 32 A, 1000 VDC, Input Strings 4, Output Strings 2","Sum",1]
[null,null,null,null,null,null,0]
["S.3.7",null,"Batteries",null,null,null,0]
["S.3.7.1",null,"Mark up on the supply, installation, and testing of Batteries as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,60000,"rate only"]
["S.3.7.2",null,"Mark up on Item S.3.7.1","%",{"$f":"F68","v":60000}]
[null,null,null,null,null,null,0]
["S.3.8",null,"Other Solar Equipment",null,null,null,0]
["S.3.8.1",null,"Mark up on other Solar Equipment set as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,60000,"rate only"]
["S.3.8.2",null,"Mark up on other Solar Equipment. ","%",{"$f":"F72","v":60000}]
[null,null,null,null,null,null,0]
["S.4",null,"FUEL GENERATORS",null,null,null,0]
[null,null,"Supply, deliver, install, test, and commission diesel generators with electric start, automatic voltage regulator, and automatic transfer switch.",null,null,null,{"$f":"F76*E76","v":0}]
["S.4.1",null,"5kVA","sum",1]
["S.4.2",null,"8kVA","sum",1]
["S.4.3",null,"15kVA","sum",1]
["S.4.4",null,"25kVA","sum",1]
["S.4.5",null,"50kVA","sum",1]
["S.4.6",null,"65kVA","sum",1]
["S.4.7",null,"100kVA","sum",1]
["S",null,"Carried forward",null,null,null,0]
["S",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["S.4.8",null,"Other Fuel Generators",null,null,null,0]
["S.4.8.1",null,"Mark up on other Fuel Generator set as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,500000,"rate only"]
["S.4.8.2",null,"Mark up on other Fuel Generator. ","%",{"$f":"F88","v":500000}]
["S.4.8.3",null,"Extra over Item S.4.8.2: Deliver, Install, Testing and Commission other Fuel Generator.","set",1]
[null,null,null,null,null,null,0]
["S.4.9",null,"Service of Generators",null,null,null,0]
["S.4.9.1",null,"Mark up on the Service and repair of Generators as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,10000,"rate only"]
["S.4.9.2",null,"Mark up on the Service and repair of Generators. ","%",{"$f":"F93","v":10000}]
[]
["S.5",null,"POWER TRANSFORMERS"]
[null,null,"Supply, installation, registration and commission of new transformer including 12m treated poles"]
["S.5.1",null,"25kVA","sum",1]
["S.5.2",null,"50kVA","sum",1]
["S.5.3",null,"100kVA","sum",1]
[null,null,null,null,null,null,0]
["S.6",null,"GRID POWER SUPPLY",null,null,null,0]
["S.6.1",null,"Mark up on the replacement, upgrade or installation of power grid line and transfomers by a Eskom registered contractor as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,200000,"rate only"]
["S.6.2",null,"Mark up on Item S.6.1. ","%",{"$f":"F103","v":200000}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[]
[]
[]
[]
[null,null,"TOTAL SECTION \"S\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G111)","v":0}]

{"sheet":"Pumps & Controllers","index":17,"n_rows":316,"n_cols":7,"rows_kept":316,"cut":false,"hidden":false,"merged":[[315,2,315,4],[315,5,315,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION T : PUMPS & MOTORS,CONTROLS & CABLES"]
["T.1",null,"Submersible Borehole Pump and Motor set"]
[null,null,"Supply, Install, Testing and Commission a complete submersible pump and motor set, up to 100m depth, inclusive of riser pipe (priced  elsewhere), electrical submersible cable (priced  elsewhere), recovery rope, flow inducer (cooling) sleeve, accessories and all fittings to connect to the electricity supply point and delivery pipe as per                                           Drawing No. 1701321-TY-06"]
[]
["T.1.1",null,"Single phase, Single stage Submersible Pump & Motor "]
[null,null,"a) 0,25 kW","sum",1]
[null,null,"b) 0,37 kW","sum",1]
[null,null,"c) 0,55 kW","sum",1]
[null,null,"d) 0,75 kW","sum",1]
[null,null,"e) 1,1 kW","sum",1]
[null,null,"f) 1,5 kW","sum",1]
[null,null,"g) 2,2 kW","sum",1]
[]
["T.1.2",null,"Single phase, Multi stage Submersible Pump & Motor "]
[null,null,"a) 0,25 kW","sum",1]
[null,null,"b) 0,37 kW","sum",1]
[null,null,"c) 0,55 kW","sum",1]
[null,null,"d) 0,75 kW","sum",1]
[null,null,"e) 1,1 kW","sum",1]
[null,null,"f) 1,5 kW","sum",1]
[null,null,"g) 2,2 kW","sum",1]
[]
["T.1.3",null,"Three phase, Single stage Submersible Pump & Motor "]
[null,null,"a) 0,25 kW","sum",1]
[null,null,"b) 0,37 kW","sum",1]
[null,null,"c) 0,55 kW","sum",1]
["T",null,"Carried forward"]
["T",null,"Brought forward"]
[null,null,"d) 0,75 kW","sum",1]
[null,null,"e) 1,1 kW","sum",1]
[null,null,"f) 1,5 kW","sum",1]
[null,null,"g) 2,2 kW","sum",1]
[]
["T.1.4",null,"Three phase, Multi stage Submersible Pump & Motor "]
[null,null,"a) 1,5 kW","sum",1]
[null,null,"b) 2,2 kW","sum",1]
[null,null,"c) 3 kW","sum",1]
[null,null,"d) 3,7 kW","sum",1]
[null,null,"e) 4 kW","sum",1]
[null,null,"f) 5,5 kW","sum",1]
[null,null,"g) 7,5 kW","sum",1]
[null,null,"h) 11 kW","sum",1]
[null,null,null,null,null,null,{"$f":"F44*E44","v":0}]
["T.1.5",null,"Other Submersible Borehole pump and motor set",null,null,null,0]
["T.1.5.1",null,"Mark up on other Submersible Borehole pump and motor set as specified by the Engineer                      (3 Quotations from reputable suppliers)","PC Sum",1,20000,"rate only"]
["T.1.5.2",null,"Mark up on other Submersible pump and motor set. ","%",{"$f":"F46","v":20000}]
["T.1.5.3",null,"Extra over Item T.1.5.2: Deliver, Install, Testing and Commission a complete submersible pump and motor set.","sum",1]
[]
["T",null,"Carried forward"]
["T",null,"Brought forward"]
[]
["T.1.6",null,"Flexible borehole pipe"]
[null,null,"Supply, deliver and install flexible borehole pipe, complete with all applicable fittings to connect to the pump and motor set and base plate up to 100 meter deep installation."]
[null,null,"a) 50 mm inside diameter","sum",1]
[null,null,"b) 64 mm inside diameter","sum",1]
[null,null,"c) 76 mm inside diameter","sum",1]
[null,null,null,null,null,null,0]
["T.1.7",null,"STEEL PIPES AND FITTINGS ",null,null,null,0]
[null,null,"Supply, deliver, install, and test the following steel pipes, fittings, and specials complete. (Conforming to SABS 719, SABS 62-1989 and BS534.) (All steel pipes and fittings to be galvanized according to SABS 1461 and SABS ISO 14713.)",null,null,null,0]
["T.1.7.1",null,"Base plates epoxy coated (split type) "]
[null,null,"a) 50 mm","no",1]
[null,null,"b) 65 mm","no",1]
[null,null,"c) 80 mm","no",1]
[]
["T.1.7.2",null,"Base plates galvanised  "]
[null,null,"a) 50 mm","no",1]
[null,null,"b) 65 mm","no",1]
[null,null,"c) 80 mm","no",1]
[null,null,null,null,null,null,0]
["T.1.8",null,"Lockable Steel Manhole Cover",null,null,null,0]
["T.1.8.1",null,"Supply and install complete lockable fabricated steel manhole cover for submersible pump as per Drawing No. 1701321-TY-05","PC Sum",1,10000,"rate only"]
["T.1.8.2",null,"Mark up on Item T.1.8.1. ","%",{"$f":"F72","v":10000}]
[null,null,null,null,null,null,{"$f":"F74*E74","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["T",null,"Carried forward",null,null,null,0]
["T",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["T.2",null,"Close coupled centrifugal pump and motor (Three phase, 2 or 4 pole motor)"]
[null,null,"Supply, deliver,install and test the following three phase close coupled end-suction centrifugal pump and motor (2 or 4  pole) complete with cast iron impeller, and cast iron & coated casing. (Including trimming of the Impeller)"]
["T.2.1",null,"Suction - 50mm; Discharge - 32mm; Impeller - 125mm (Q - 25³/h; H - 23m; P - 2,2kW)","set",1]
["T.2.2",null,"Suction - 50mm; Discharge - 32mm; Impeller - 160mm (Q - 20³/h; H - 35m; P - 4kW)","set",1]
["T.2.3",null,"Suction - 50mm; Discharge - 32mm; Impeller - 200mm (Q - 14³/h; H - 50m; P - 5,5kW)","set",1]
["T.2.4",null,"Suction - 50mm; Discharge - 32mm; Impeller - 250mm (Q - 16³/h; H - 75m; P - 7,5kW)","set",1]
[null,null,null,null,null,null,0]
["T.3",null,"Close coupled centrifugal pump and motor (Single phase, 2 pole motor)",null,null,null,0]
[null,null,"Supply, deliver,install and test the following single phase close coupled end-suction centrifugal pump and motor (2 pole) complete with cast iron impeller, and cast iron & coated casing. (Including trimming of Impeller)",null,null,null,0]
["T.3.1",null,"Suction - 50mm; Discharge - 32mm; Impeller - 125mm (Q - 25³/h; H - 23m; P - 2,2kW)","set",1,null,{"$f":"F89*E89+G81:FF89","v":0}]
[null,null,null,null,null,null,0]
["T",null,"Carried forward",null,null,null,0]
["T",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["T.4",null,"Other Close coupled centrifugal pump and motor",null,null,null,0]
["T.4.1",null,"Mark up on other Close coupled pump and motor set as specified by the Engineer                                      (3 Quotations from reputable suppliers)","PC Sum",1,60000,"rate only"]
["T.4.2",null,"Mark up on other Close coupled pump and motor set. ","%",{"$f":"F95","v":60000}]
["T.4.3",null,"Extra over Item T.4.2: Deliver, Install, Testing and Commission a complete Close coupled pump and motor set.","set",1]
[]
["T.5",null,"Centrifugal pump and motor set with base plate and flexible coupling (Three phase, 2 pole motor)"]
["T.5.3",null,"Suction - 50mm; Discharge - 32mm; Impeller - 200mm (Q - 14³/h; H - 50m; P - 5,5kW)","set",1]
["T.5.4",null,"Suction - 50mm; Discharge - 32mm; Impeller - 250mm (Q - 16³/h; H - 75m; P - 7,5kW)","set",1]
["T.5.5",null,"Suction - 65mm; Discharge - 40mm; Impeller - 125mm (Q - 28³/h; H - 20m; P - 11kW)","set",1]
["T.5.7",null,"Suction - 65mm; Discharge - 40mm; Impeller - 200mm (Q - 40³/h; H - 58m; P - 15kW)","set",1]
["T.5.8",null,"Suction - 65mm; Discharge - 50mm; Impeller - 160mm (Q - 50³/h; H - 36m; P - 18kW)","set",1]
["T.5.9",null,"Suction - 65mm; Discharge - 50mm; Impeller - 200mm (Q - 60³/h; H - 58m; P - 22kW)","set",1]
["T.5.10",null,"Suction - 65mm; Discharge - 50mm; Impeller - 250mm (Q - 80³/h; H - 80m; P - 30kW)","set",1]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["T",null,"Carried forward",null,null,null,0]
["T",null,"Brought forward",null,null,null,0]
[null,null,null,null,null,null,0]
["T.7",null,"Other Centrifugal pump and motor set with base plate and flexible coupling.",null,null,null,0]
["T.7.1",null,"Mark up on other Centrifugal pump and motor set with base plate and flexible coupling as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,60000,"rate only"]
["T.7.2",null,"Mark up on other Centrifugal pump and motor set. ","%",{"$f":"F116","v":60000}]
["T.7.3",null,"Extra over Item T.7.2: Deliver, Install, Testing and Commission a complete Centrifugal pump and motor set with base plate and flexible coupling.","set",1]
[]
["T.8",null,"Supply, deliver, install and test the following three phase 2 or 4 pole motors."]
["T.8.4",null,"5.5 kW","no",1]
["T.8.5",null,"7.5 kW","no",1]
["T.8.6",null,"11 kW","no",1]
[]
["T",null,"Carried forward"]
["T",null,"Brought forward"]
[]
["T.8.7",null,"15 kW","no",1]
["T.8.8",null,"18.5 kW","no",1]
["T.8.9",null,"22 kW","no",1]
["T.8.10",null,"30 kW","no",1]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["T.10",null,"Other Electrical motor.",null,null,null,0]
["T.10.1",null,"Mark up on other Electrical motor as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,60000,"rate only"]
["T.10.2",null,"Mark up on other Electrical motor. ","%",{"$f":"F135","v":60000}]
["T.10.3",null,"Extra over Item T.10.2: Deliver, Install, Testing and Commission a complete Electrical motor and flexible coupling.","set",1]
[]
["T.11",null,"ELECTRICAL - GENERAL"]
["T.11.1",null,"Test the complete electrical works and issue a Certificate of Compliance (CoC) by an applicable certified and registered electrical person.","sum",1]
["T.11.2",null,"Electrical Connection Fee (Provisional Sum)","sum",1,50000,"rate only"]
["T.11.3",null,"Handling Cost and profit in respect of Item T.11.2","%",50000]
["T.11.4",null,"Earth Spike (Include Conductor Termination Clamp)","sum",1]
[]
[]
[]
["T",null,"Carried forward"]
["T",null,"Brought forward"]
[]
[]
["T.13",null,"Electrical Motor Control and Starters"]
[null,null,"Supply, deliver, install, and test a complete DB Board in a lockable IP55 powder coated mild steel enclosure (or similar approved by Engineer) for a pump and motor set with all applicable switch gear and starters with protections for Dry run, Pump stall, Overload, Under voltage, Over voltage, Phase failure, Phase rotation and short circuit. Inclusive of all wiring, terminations, and glands."]
["T.13.1",null,"Single Phase Direct on Line"]
[null,null,"a) 0,25 kW","sum",1]
[null,null,"b) 0,37 kW","sum",1]
[null,null,"c) 0,55 kW","sum",1]
[null,null,"d) 0,75 kW","sum",1]
[null,null,"e) 1,1 kW","sum",1]
[null,null,"f) 1,5 kW","sum",1]
[null,null,"g) 2,2 kW","sum",1]
[]
["T.13.2",null,"Three Pphase Direct on Line"]
[null,null,"a) 0,25 kW","sum",1]
[null,null,"b) 0,37 kW","sum",1]
[]
["T",null,"Carried forward"]
["T",null,"Brought forward"]
[null,null,"c) 0,55 kW","sum",1]
[null,null,"d) 0,75 kW","sum",1]
[null,null,"e) 1,1 kW","sum",1]
[null,null,"f) 1,5 kW","sum",1]
[null,null,"g) 2,2 kW","sum",1]
[]
["T.13.3",null,"Star Delta Starter (Complete with relays & timers)"]
[null,null,"a) 3 kW","sum",1]
[null,null,"b) 3,7 kW","sum",1]
[null,null,"c) 4 kW","sum",1]
[null,null,"d) 5,5 kW","sum",1]
[null,null,"e) 7,5 kW","sum",1]
[]
["T.13.4",null,"Soft Starter"]
[null,null,"a) 1,5 kW","sum",1]
[null,null,"b) 2,2 kW","sum",1]
[null,null,"c) 3 kW","sum",1]
[null,null,"d) 3,7 kW","sum",1]
[null,null,"e) 4 kW","sum",1]
[null,null,"f) 5,5 kW","sum",1]
[null,null,"g) 7,5 kW","sum",1]
[]
["T.13.5",null,"Variable Speed Drives (VSDs) "]
[null,null,"a) 1,5 kW","sum",1]
[null,null,"b) 2,2 kW","sum",1]
[null,null,"c) 3 kW","sum",1]
[null,null,"d) 3,7 kW","sum",1]
[null,null,"e) 4 kW","sum",1]
[null,null,"f) 5,5 kW","sum",1]
["T",null,"Carried forward"]
["T",null,"Brought forward"]
[null,null,"g) 7,5 kW","sum",1]
[]
["T.13.6",null,"Solar-Powered Variable Speed Drives (VSDs)"]
[null,null,"a) 1,5 kW","sum",1]
[null,null,"b) 2,2 kW","sum",1]
[null,null,"c) 3 kW","sum",1]
[null,null,"d) 3,7 kW","sum",1]
[null,null,"e) 4 kW","sum",1]
[null,null,"f) 5,5 kW","sum",1]
[null,null,"g) 7,5 kW","sum",1]
[]
["T.13.7",null,"Other Electrical Motor Control and Starters"]
["T.13.7.1",null,"Mark up on other Electrical motor Control and Starters as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1]
["T.13.7.2",null,"Mark up on other Electrical motor Control and Starters. ","%",{"$f":"F211","v":0}]
["T.13.7.3",null,"Extra over Item T.13.7.2: Deliver, Install, Testing and Commission a complete Electrical motor Control and Starter.","set",1]
[]
[null,null,"Three Core Cable"]
[null,null,"Supply, deliver, install and test three core SABS approved copper cables. Inclusive of all terminations and glands."]
["T.14.3",null,"Three Core Submersible pump cable (SANS 1574)"]
[null,null,"a) 1.5 mm2","m",1]
[null,null,"b) 2.5 mm2","m",1]
[null,null,"c) 4 mm2","m",1]
[null,null,"d) 6 mm2","m",1]
[null,null,"e) 10 mm2","m",1]
[null,null,"f) 16 mm2","m",1]
[null,null,"g) 25 mm2","m",1]
[null,null,"h) 35 mm2","m",1]
[null,null,"I) 50 mm2","m",1]
[]
["T",null,"Carried forward"]
["T",null,"Brought forward"]
[]
["T.14.4",null,"Three Core Armoured copper cable  (SANS 1507)"]
[null,null,"a) 1.5 mm2","m",1]
[null,null,"b) 2.5 mm2","m",1]
[null,null,"c) 4 mm2","m",1]
[null,null,"d) 6 mm2","m",1]
[null,null,"e) 10 mm2","m",1]
[null,null,"f) 16 mm2","m",1]
[null,null,"g) 25 mm2","m",1]
[null,null,"h) 35 mm2","m",1]
[null,null,"I) 50 mm2","m",1]
[]
["T.14.5",null,"Three Core Armoured copper cable with Earth continuity Conductor in the armour.  (SANS 1507)"]
[null,null,"a) 1.5 mm2","m",1]
[null,null,"b) 2.5 mm2","m",1]
[null,null,"c) 4 mm2","m",1]
[null,null,"d) 6 mm2","m",1]
[null,null,"e) 10 mm2","m",1]
[null,null,"f) 16 mm2","m",1]
[null,null,"g) 25 mm2","m",1]
[null,null,"h) 35 mm2","m",1]
[null,null,"I) 50 mm2","m",1]
[]
[null,null,"Four Core Cable"]
[null,null,"Supply, deliver, install and test four core SABS approved copper cables. Inclusive of all terminations and glands."]
["T.14.6",null,"Four Core Submersible pump cable (SANS 1574)"]
[null,null,"a) 1.5 mm2","m",1]
["T",null,"Carried forward"]
["T",null,"Brought forward"]
[null,null,"b) 2.5 mm2","m",1]
[null,null,"c) 4 mm2","m",1]
[null,null,"d) 6 mm2","m",1]
[null,null,"e) 10 mm2","m",1]
[null,null,"f) 16 mm2","m",1]
[null,null,"g) 25 mm2","m",1]
[null,null,"h) 35 mm2","m",1]
[null,null,"I) 50 mm2","m",1]
[]
["T.14.7",null,"Four Core Armoured copper cable  (SANS 1507)"]
[null,null,"a) 1.5 mm2","m",1]
[null,null,"b) 2.5 mm2","m",1]
[null,null,"c) 4 mm2","m",1]
[null,null,"d) 6 mm2","m",1]
[null,null,"e) 10 mm2","m",1]
[null,null,"f) 16 mm2","m",1]
[null,null,"g) 25 mm2","m",1]
[null,null,"h) 35 mm2","m",1]
[null,null,"I) 50 mm2","m",1]
[]
["T.14.8",null,"Four Core Armoured copper cable with Earth continuity Conductor in the armour.               (SANS 1507)"]
[null,null,"a) 1.5 mm2","m",1]
[null,null,"b) 2.5 mm2","m",1]
[null,null,"c) 4 mm2","m",1]
[null,null,"d) 6 mm2","m",1]
[null,null,"e) 10 mm2","m",1]
[null,null,"f) 16 mm2","m",1]
[null,null,"g) 25 mm2","m",1]
["T",null,"Carried forward"]
["T",null,"Brought forward"]
[null,null,"h) 35 mm2","m",1]
[null,null,"I) 50 mm2","m",1]
[]
[null,null,"Supply, deliver, install and test SABS approved copper cables. Inclusive of all terminations and glands."]
["T.14.9",null,"Bare copper Earth wire  (SANS 1411)"]
[null,null,"a) 1.5 mm2","m",1]
[null,null,"b) 2.5 mm2","m",1]
[null,null,"c) 4 mm2","m",1]
[null,null,"d) 6 mm2","m",1]
[null,null,"e) 10 mm2","m",1]
[null,null,"f) 16 mm2","m",1]
[null,null,"g) 25 mm2","m",1]
[null,null,"h) 35 mm2","m",1]
[null,null,"I) 50 mm2","m",1]
[null,null,null,null,null,null,{"$f":"F303*E303","v":0}]
["T.14.10",null,"Other Electrical Cables ",null,null,null,0]
["T.14.10.1",null,"Mark up on other Electrical Cables, terminations, and glands as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,20000,"rate only"]
["T.14.10.2",null,"Mark up on other Electrical Cables. ","%",{"$f":"F305","v":20000}]
["T.14.10.3",null,"Extra over Item T.14.10.2: Deliver, install and test other cables.","set",1]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL SECTION \"T\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G315)","v":0}]

{"sheet":"Dams","index":18,"n_rows":235,"n_cols":7,"rows_kept":235,"cut":false,"hidden":false,"merged":[[85,0,85,4],[86,0,86,6],[234,2,234,4],[234,5,234,6],[33,0,33,4],[34,0,34,4],[144,0,144,4],[197,0,197,4],[198,0,198,6],[199,0,199,4],[87,0,87,4],[142,0,142,4],[143,0,143,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION U : DAMS"]
["U1","SABS ","SUMS STATED PROVISIONALLY",null,null,null,{"$f":"F3*E3","v":0}]
[null,"1200AD","BY ENGINEER",null,null,null,{"$f":"F4*E4","v":0}]
[null,null,null,null,null,null,{"$f":"F5*E5","v":0}]
["U1.1",null,"For work to be done by Engineer;"]
[]
["U1.1.1",null,"Project Management"]
[null,null,"Engineering Fees and Disbursements for Project Manahement"]
[null,null,"and Part-time Construction Supervision and Quality Control"]
[null,null,"(Includes all legal compliance, borrow pit evaluation, as-built"]
[null,null,"survey, OMM updating etc.)","PC sum",1,150000,"Rate Only"]
["U1.1.2",null,"contractor's overheads, charges and profit on items","%",{"$f":"F12","v":150000}]
[]
["U2","SABS ","SUMS STATED PROVISIONALLY"]
[null,"1200AD","BY EMPLOYER"]
[]
[null,null,"Auditing of Compliance by the Contractor of the Health and"]
[null,null,"Safety Regulations"]
[null,null,"The provisional sum for the appointment os an OSH Auditor on"]
["U2.1",null,"behalf of LDARD to conduct monthly inspections and to present"]
[null,null,"reports at the monthly meetings. Appointment to be approved by"]
[null,null,"the Engineer in writing (Provisional Sum).","PC sum",1,200000,"Rate Only"]
[]
["U2.2",null,"Contractor's overheads, charges and profit on Item above"]
[null,null,"(Max 10%)","%",{"$f":"F23","v":200000}]
[]
[]
[]
[]
[]
[]
[]
["Sub-total carried forward",null,null,null,null,null,{"$f":"SUM(G1:G26)","v":0}]
["Sub-total brought over "]
["U3","SABS 1200","SECTION B: SMALL EARTH DAMS (DE)",null,null,null,{"$f":"F36*E36","v":0}]
[null,"PSDE",null,null,null,null,{"$f":"F37*E37","v":0}]
[]
["U3.1","8.3.1","SITE CLEARANCE AND PREPARATION",null,null,null,{"$f":"F39*E39","v":0}]
[null,null,null,null,null,null,{"$f":"F40*E40","v":0}]
["U3.1.1","8.3.1.1","Clear, grub and strip  area to be covered by:",null,null,null,{"$f":"F41*E41","v":0}]
[null,null,null,null,null,null,{"$f":"E42*F42","v":0}]
[null,null,"a. Dam solumn (slopes, crest and toe areas)(plan area measured)","m²",1]
[null,null,"b. Spillway (plan area measured)","m²",1]
[null,null,"c. Borrow areas ","m²","Rate Only"]
[]
["U3.1.2","8.3.4","Preparation of exposed surfaces to be covered by;"]
[null,null,"a. New embankment fill (plan area measured)","m²",1]
[]
["U4",null,"EXCAVATION"]
["U4.1","8.3.3(b)","Material suitable for embankment"]
[null,null,"From essential excavation and place in embankment,"]
[null,null,"or stockpiles or spoil as directed, material from:"]
[]
[null,null,"a. Excavation by removal of 1m thickness of existing embankment;"]
[null,null,"- soft excavation","m³",1]
[]
[null,null,"b. From Borrow areas","m³",1]
[]
["U4.2","8.1.2 (a)","EMBANKMENT (FORMING)"]
[]
[null,"8.3.5","Form embankment and level embankment crest to"]
[null,null,"join with spillway structure"]
[]
["U4.3",null,"Using material from designated borrow area / stock","m³",1]
[null,null,"piles (inclusive of core zone) (fill)"]
[null,null,"All material to be compacted to 98 % Proctor "]
[null,null,"Density @ 2% wet of OMC"]
[]
["U4.4",null,"Construction of blanket / chimney filter zones","m³",1]
[null,null,"(from commercial source)"]
[]
["U4.5","8.3.5 d","Rip-rap (rock from commercial source)","m³",1]
[null,null,"(200mm thick - rock sizes 20-300mm)"]
[]
["U4.6",null,"Geotextile Bidum for item B 2.2.3 above ","m²",1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Sub-total carried forward ",null,null,null,null,null,{"$f":"SUM(G42:G76)","v":0}]
[]
["Sub-total brought over "]
[]
["U5","SABS 1200","SECTION C: CONCRETE SMALL WORKS (GA)"]
[null,"PSGA"]
[null,null,"Repair to existing concrete ogee overflow structure"]
[null,null,"and related concrete works"]
[]
["U5.1",8.1999999999999993,"Formwork"]
[]
[null,"8.2.1","a) Rough","m2",1]
[]
[null,"8.2.2","b) Smooth","m2",1]
[]
["U5.2",null,"Reinforcing"]
[]
[null,"8.1.2","High Tensile steel bars"]
[]
["U5.3",null,"a) Nominal reinforcement for ogee","ton",1]
[]
["U5.4",null,"b) Nominal reinforcement for proposed new retaining walls","ton",1]
[]
["U6","P002","DRILLING AND GROUTING OF"]
[null,null,"DOWEL BARS"]
[]
[null,"P002-4.1.1","Drilling of dowel bars into rock"]
[]
[null,null,"a) 40mm-diameter (0.5M DEEP)","m",1]
[]
[null,"P002-4.1.1","Chemical Anchorage of dowel bars into holes",null,null,null,{"$f":"F116*E116","v":0}]
[null,null,"(inclusive of dowels)",null,null,null,0]
[]
[null,null,"a) 32mm-diameter dowels, 500mm"]
[null,null,"    deep hole","No",1]
[]
[null,null,"40mm diam. Holes drilled into rock bed (500mm deep)"]
[null,null,"with Y32 reinforcing chemically anchored into holes"]
[null,null,"(1200mm dowel lenghts) spaced at 1,5m c/c or"]
[null,null,"practically dictated by bedrock, dowels to be bent"]
[null,null,"to shape code 39 with dimensions A-1200mm B-300mm"]
[]
["U7",8.4,"Concrete"]
[]
[null,"8.4.2","Blinding Layer: Mass Concrete","m³",1]
[]
[null,"8.4.3","a) Concrete for repair of ogee spillway Class 25/19","m³",1]
[null,null,"(See detail drawing)"]
[]
[null,null,"b) Concrete Class 25/19 for new proposed retaining walls","m³",1]
[null,null,"(See detail drawing)"]
[]
[]
[]
[]
[]
[]
["Sub-total carried forward ",null,null,null,null,null,{"$f":"SUM(G95:G152)","v":0}]
[]
["Sub-total brought over "]
[]
["U8","8.4.4","Uniform surface finishes"]
["U8.1",null,"Wood floated","m2",1]
[]
["U8.2",null,"Steel floated","m2",1]
[]
["U8.3",8.6,"PRECAST ELEMENTS","Prov. Sum",1,30000,"Rate Only"]
[null,null,"Provide and install DamsforAfrica type antitheft manhole lids"]
[null,null,"at Inlet tower and downstream outlet work chamber"]
[]
["U9",null,"SECTION D: UPGRADING OF INLET TOWER",null,null,null,{"$f":"F156*E156","v":0}]
[]
["U9.1",null,"Allow for the service and test of existing specials / components:","Prov. Sum",1,100000,"Rate Only"]
[]
["U9.2",null,"Contractor's overheads, charges and profit on Item above","%",{"$f":"F158","v":100000}]
[]
["U9.3","SABS","Supply, install and test of the following fittings"]
[null,"1200 L","and pipe specials;"]
[]
[null,null,"a) 600mm dia flange adapter","No",1]
[null,null,"b) 600mm gasket","No",1]
[null,null,"c) 600mm dia gate valve","No",1]
[]
["U9.4",null,"Allow for the refurbishment of inlet tower, and to replace all","Prov Sum",1,20000,"Rate Only"]
[null,null,"steel components with FIBRE GLASS components as "]
[null,null,"specified by Engineer and indicated on drawings"]
[null,null,"(with regard to access and security at Inlet tower)"]
[]
["U9.5",null,"Allow for the removal of the walkway stucture","Prov Sum",1,10000,"Rate Only"]
[]
["U9.7",null,"Raising of concrete intel tower by 1.0m (complete with anchoring","Prov Sum",1,15000,"Rate Only"]
[null,null,"and grouting to existing structure and shuttering) "]
[]
["U9.6",null,"Profit for prov. Sum above","%",{"$f":"F174+F169+F176","v":45000}]
[]
[]
["U10",null,"SECTION E: MISCELLANEOUS",null,null,null,{"$f":"F182*E182","v":0}]
[null,null,null,null,null,null,{"$f":"F183*E183","v":0}]
["U10.1",null,"Installation of toe drains"]
[null,null,"- Install complete toe drain with measuring structure","m",1]
[null,null,"Inclusive of trench excavation, preparation and "]
[null,null,"backfilling (refer to drawings for detail)"]
[]
["U10.2",null,"Installation of 1.4m high fence as per the engineer's determination","Prov Sum",1,50000,"Rate Only"]
[null,null,"(as per drawings)"]
[]
["U10.3",null,"Allow for specialised termite treatment","Prov Sum",1,30000,"Rate Only"]
[]
["U10.4",null,"Allow for Signage at Inlet Tower as directed by Engineer","Prov Sum",1,15000,"Rate Only"]
[]
[]
[]
["Sub-total carried forward ",null,null,null,null,null,{"$f":"SUM(G148:G207)","v":0}]
[]
["Sub-total brought over "]
[]
[]
["U10.5",null,"Divers: Allow for the services from divers to \"plug\" inlet to inlet tower","Prov Sum",1,30000,"Rate Only"]
[null,null,"for the refurbishment of the inlet/outlet works and removal of "]
[null,null,"the \"plug\" after refurbishment"]
[null,null,"(divers to be approved by Engineer)"]
[]
["U10.6",null,"Dealing with Hospital water supply pipeline across embankment:","Prov Sum",1,100000,"Rate Only"]
[null,null,"Removal before embankment upgrading and reinstatement of "]
[null,null,"pipeline after construction (inclusive of temporary hose pipe to"]
[null,null,"ensure continued water supply during the construction phase)"]
[]
["U10.7",null,"Lifting / extension of one powerline pylon (pole) which is near the","Prov Sum",1,100000,"Rate Only"]
[null,null,"embankment. Electricity lines to be raised to comply with safety"]
[null,null,"standards"]
[]
["U10.8",null,"Provision for the supply, delivery and spreading of bentonite in dams for sealing of dams, including compaction per layer to the recommendations by the engineer","Prov Sum",1,250000,"Rate Only "]
[]
["U10.9",null,"Profit for provisions above","%",{"$f":"F192+F194+F203+F208+F213+F213+F217","v":625000}]
[null,null,"(Not higher than 10%)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"TOTAL SECTION \"U\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G234)","v":0}]

{"sheet":"Sheet2","index":19,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["50 mm Universal Flange","20 m³/h"," 500 micron","disc","filter","complete with backwash valve and controller",null,null,{"$f":"CONCATENATE(A1,\", \",B1,\" \",C1,\" \",D1,\" \",E1,\" \",F1)","v":"50 mm Universal Flange, 20 m³/h  500 micron disc filter complete with backwash valve and controller"}]
["80 mm Universal Flange","50 m³/h"," 300 micron","disc","filter","complete with backwash valve and controller",null,null,{"$f":"CONCATENATE(A2,\", \",B2,\" \",C2,\" \",D2,\" \",E2,\" \",F2)","v":"80 mm Universal Flange, 50 m³/h  300 micron disc filter complete with backwash valve and controller"}]
["80 mm Universal Flange","50 m³/h"," 200 micron","disc","filter","complete with backwash valve and controller",null,null,"80 mm Universal Flange, 50 m³/h  200 micron disc filter complete with backwash valve and controller"]
["80 mm Universal Flange","300 m³/h"," 130 micron","disc","filter","complete with backwash valve and controller",null,null,"80 mm Universal Flange, 300 m³/h  130 micron disc filter complete with backwash valve and controller"]
["80 mm Universal Flange","300 m³/h"," 100 micron","disc","filter","complete with backwash valve and controller",null,null,"80 mm Universal Flange, 300 m³/h  100 micron disc filter complete with backwash valve and controller"]
["80 mm Universal Flange"]
["80 mm Universal Flange"]
[]
[]
[]
["50 mm threaded, 20 m³/h  130 micron disc filter complete with backwash valve and controller "]
["80 mm Universal Flange, 50 m³/h  500 micron  disc filter complete with backwash valve and controller "]
["80 mm Universal Flange, 50 m³/h  300 micron  disc filter complete with backwash valve and controller "]
["80 mm Universal Flange, 50 m³/h  200 micron  disc filter complete with backwash valve and controller "]
["80 mm Universal Flange, 50 m³/h  130 micron  disc filter complete with backwash valve and controller "]
["80 mm Universal Flange, 50 m³/h  100 micron  disc filter complete with backwash valve and controller "]
["100 mm Universal Flange, 80 m³/h  500 micron  disc filter complete with backwash valve and controller "]
["100 mm Universal Flange, 80 m³/h  300 micron  disc filter complete with backwash valve and controller "]