{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Summary Turnkey","PG","Dayworks","Earthworks","Galvanised Fittings","HDPE","PVC","DRIP","Sprinkler","Filters","Non-SABS LDPE","Valves & Meters","Shadenet ","Tunnels","Building","Electricals & Plumbing","Energy","Pumps & Controllers","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":27,"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":49,"n_cols":5,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[4,0,4,4],[2,0,2,4],[7,0,8,3],[7,4,8,4],[9,0,10,3],[11,0,12,3],[13,0,14,3],[15,0,16,3],[17,0,19,3],[20,0,20,3],[21,0,22,3],[23,0,24,3],[25,0,26,3],[27,0,28,3],[29,0,30,3],[31,0,32,3],[33,0,34,3],[35,0,36,3],[37,0,38,3],[39,0,40,3],[39,4,40,4],[17,4,19,4],[9,4,10,4],[11,4,12,4],[13,4,14,4],[15,4,16,4],[21,4,22,4],[23,4,24,4],[25,4,26,4],[27,4,28,4],[29,4,30,4],[31,4,32,4],[33,4,34,4],[35,4,36,4],[37,4,38,4],[43,0,44,3],[43,4,44,4],[48,0,49,3],[48,4,49,4],[41,4,42,4],[41,0,42,3],[46,0,47,3],[46,4,47,4],[45,0,45,3]]}
["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 A1  : PRELIMINARY AND GENERAL",null,null,null,{"$f":"PG!G52","v":0}]
[]
["SECTION A2  : DAYWORKS",null,null,null,{"$f":"Dayworks!G47","v":0}]
[]
["SECTION B: EARTHWORKS",null,null,null,{"$f":"Earthworks!G54","v":0}]
[]
["SECTION C : STEEL PIPES AND FITTINGS",null,null,null,{"$f":"'Galvanised Fittings'!F258","v":0}]
[]
["SECTION D : HDPE PIPES AND FITTINGS",null,null,null,{"$f":"HDPE!G211","v":0}]
[]
["SECTION E : PVC PIPES AND FITTINGS",null,null,null,{"$f":"PVC!F168","v":0}]
[]
[]
["SECTION F : DRIP IRRIGATION",null,null,null,{"$f":"DRIP!F110","v":0}]
["SECTION G : SPRINKLER IRRIGATION",null,null,null,{"$f":"Sprinkler!F46","v":0}]
[]
["SECTION H : FILTERS & AIRVALVES",null,null,null,{"$f":"Filters!F39","v":0}]
[]
["SECTION J : LDPE PIPES AND FITTINGS",null,null,null,{"$f":"'Non-SABS LDPE'!$F$105","v":0}]
[]
["SECTION K : VALVES & METERS",null,null,null,{"$f":"'Valves & Meters'!$F$84","v":0}]
[]
["SECTION L : SHADENET",null,null,null,{"$f":"'Shadenet '!$F$104","v":0}]
[]
["SECTION M : TUNNELS & RESEVOIRS",null,null,null,{"$f":"Tunnels!F53","v":0}]
[]
["SECTION P : BUILDING",null,null,null,{"$f":"Building!F279","v":0}]
[]
["SECTION R : ELECTRICALS AND PLUMBING",null,null,null,{"$f":"'Electricals & Plumbing'!$F$134","v":0}]
[]
["SECTION S : POWER GENERATION EQUIPMENT",null,null,null,{"$f":"Energy!F54","v":0}]
[]
["SECTION T : PUMPS & MOTORS,CONTROLS & CABLES",null,null,null,{"$f":"'Pumps & Controllers'!$F$215","v":0}]
[]
["TOTAL SCHEDULE OF QUANTITIES",null,null,null,{"$f":"SUM(E8:E41)","v":0}]
[]
["ADD 10% CONTIGENCIES"]
[]
["SUB-TOTAL"]
["ADD 15% VAT"]
[]
["TOTAL TENDER AMOUNT"]

{"sheet":"PG","index":1,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,2,2,5],[3,2,3,5],[51,2,51,5]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION A: PRELIMINARY & GENERAL"]
[null,null,"Note: Contractor to Hire at least 5 LOCAL personnel/labour at not less than R200/day labour rate for a 4 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 4 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,{"$f":"IF(AND(ISBLANK(D7),ISBLANK(E7)),0,IF(AND(ISTEXT(D7),ISBLANK(E7)),\"error\",IF(OR(D7=\"prov sum\",D7=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D7=\"prov sum\",D7=\"pc sum\"),\"rate only\",F7*E7)","v":0}]
[null,"8.3.2","Establishment of Facilities on Site",null,null,{"$f":"IF(AND(ISBLANK(D8),ISBLANK(E8)),0,IF(AND(ISTEXT(D8),ISBLANK(E8)),\"error\",IF(OR(D8=\"prov sum\",D8=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D8=\"prov sum\",D8=\"pc sum\"),\"rate only\",F8*E8)","v":0}]
[null,"8.3.2.2","FACILITIES FOR CONTRACTOR",null,null,0,0]
["A.1.2",null,"a) Offices and storage shed","Sum",1,0,0]
["A.1.3",null,"b) Living accommodation","Sum",1,0,0]
["A.1.4",null,"c) Ablution and Latrine Facilities","Sum",1,0,0]
["A.1.5",null,"d) Tools and equipment","Sum",1,0,0]
["A.1.6",null,"e) Water supplies, electrical power and communication","Sum",1,0,0]
["A.1.7","5,1,1","Setting out of the works","Sum",1,0,0]
["A.1.8","8.3.4","Removal of Site Establishment","Sum",1,0,0]
[null,null,null,null,null,0,0]
[null,"8.4","SCHEDULED TIME-RELATED ITEMS (Max. 5% of R 3000 000,00)",null,null,0,0]
["A.1.9","8.4.1","Contractual Requirements","months",4,0,0]
["A.1.10",null,"All risk Insurance of the works","months",4,0,0]
[null,"8.4.2","Operation and Maintenance of Facilities on Site",null,null,0,0]
[null,"8.4.2.2","FACILITIES FOR CONTRACTOR",null,null,0,0]
["A.1.11",null,"a) Offices and storage shed","months",4,0,0]
["A.1.12",null,"d) Living accommodation","months",4,0,0]
["A.1.13",null,"e) Ablution and Latrine Facilities","months",4,0,0]
["A.1.14",null,"f) Tools and equipment","months",4,0,0]
["A.1.15",null,"g) Water supplies, electrical power and communication","months",4,0,0]
["A.1.16","8.4.3","Supervision for Duration of Construction","months",4,0,0]
[null,8.5,"SUMS STATED PROVISIONALLY BY ENGINEER",null,null,0,0]
["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,15000,"rate only"]
["A.1.19",null,"c)  Overheads, charges and profit on a) to  b) above","%",{"$f":"F31+F30","v":30000},0,0]
[null,null,null,null,null,0,0]
[null,null,"OCCUPATIONAL HEALTH AND SAFETY ",null,null,0,0]
["A.1.20",null,"Contractor’s initial obligations in respect of  the Occupational Health and Safety Act and Construction Regulations","Sum ",1,0,0]
["A.1.21",null,"Contractor’s time related obligations in respect of the Occupational Health and Safety Act and Construction Regulations","Month",4,0,0]
["A.1.23",null,"Dust suppression by water spraying construction site, with 10 000L Tanker","Day",1,0,0]
["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,0,0]
["A.1.25",null,"Extra over mesh fence for pedestrian gate size 1.8 x 1,8m high.","No",1,0,0]
[null,null,"Provision for Personal Protective Equipment and Protective Clothing per each person:",null,null,0,0]
["A.1.26",null,"Reflective vests.","No",5,0,0]
["A.1.27",null,"Hard hats.","No",5,0,0]
["A.1.28",null,"Protective foot wear.","No",5,0,0]
["A.1.29",null,"Ear Plugs.","No",5,0,0]
["A.1.30",null,"Dust Masks.","No",5,0,0]
["A.1.31",null,"Working suite - jacket and pants","No",5,0,0]
[null,null,"Costs of Medical Certificates and Medical Surveillance:",null,null,0,0]
["A.1.32",null,"Entry medical fitness examinations per employee","No",5,0,0]
["A.1.33",null,"Respiritory prevention kit allocation and routine screening ","No",5,0,0]
["A.1.34",null,"Exit Examinations per employee","No",5,0,0]
[]
["A",null,"TOTAL SECTION \"A1\" CARRIED FORWARD TO SUMMARY"]

{"sheet":"Dayworks","index":2,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,2,46,5]]}
[null,"SANS 1200A","DAYWORKS "]
["A.2",8.6999999999999993,"Daywork Labour ",null,""]
["A.2.1",null,"Contractor's Representative","hour",1,{"$f":"IF(AND(ISBLANK(D3),ISBLANK(E3)),0,IF(AND(ISTEXT(D3),ISBLANK(E3)),\"error\",IF(OR(D3=\"prov sum\",D3=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D3=\"prov sum\",D3=\"pc sum\"),\"rate only\",F3*E3)","v":0}]
["A.2.2",null," Surveyor ","hour",1,{"$f":"IF(AND(ISBLANK(D4),ISBLANK(E4)),0,IF(AND(ISTEXT(D4),ISBLANK(E4)),\"error\",IF(OR(D4=\"prov sum\",D4=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D4=\"prov sum\",D4=\"pc sum\"),\"rate only\",F4*E4)","v":0}]
["A.2.3",null," Irrigation engineer","hour",1,0,0]
["A.2.4",null," Plumber","hour",1,0,0]
["A.2.5",null," Boilermaker","hour",1,0,0]
["A.2.6",null," Bricklayer","hour",1,0,0]
["A.2.7",null," Plasterer","hour",1,0,0]
["A.2.8",null," Welder with API 1104 Certificate","hour",1,0,0]
["A.2.9",null," Electrician","hour",1,0,0]
["A.2.10",null," Semi-skilled labourer","hour",1,0,0]
["A.2.11",null," Labourer","hour",1,0,0]
[null,null,null,null,null,0,0]
["A,3",8.6999999999999993,"Plant hire (dry rates)  :  Work Rates on Site ",null,""]
["A.3.1",null,"Crane 20 t - 35 t capacity ","hour",1,0,0]
["A.3.2",null,"Tractor 60 kW - 90 kW ","hour",1,0,0]
["A.3.3",null,"TLB 60 kW - 70 kW ","hour",1,0,0]
["A.3.4",null,"Motor graders 150 kW - 160 kW ","hour",1,0,0]
["A.3.6",null,"Wheel excavators 0,4 - 1,25m³ bucket size ","hour",1,0,0]
["A.3.7",null,"Water tankers 4 000  - 20 000 litre ","hour",1,0,0]
["A.3.8",null,"Drilling rig up to 200 metres(rotary air percussion)","hour",1,0,0]
["A.3.9",null,"Borehole Testing equipment up 10 litres/s","hour",1,0,0]
["A.3.10",null,"Dumpers 0,5m³ (Hydraulic tip) ","hour",1,0,0]
["A.3.11",null,"Mono pump with 80mm DN outlet (diesel driven) 2.2 - 7.5 kW","hour",1,0,0]
["A.3.12",null,"Arc-welding unit (300 A) ","hour",1,0,0]
["A.3.13",null,"10 kVA (petrol) 220V Generator","hour",1,0,0]
["A.3.14",null,"30 kVA (diesel) 380V - 3ph Generator","hour",1,0,0]
["A,4",null,"TRAINING AND OTHER MARKUPS",null,null,0,0]
["A.4.1",null,"SUMS STATED PROVISIONALLY BY ENGINEER (Employer)",null,null,0,0]
["A.4.2",null,"SABI ACCREDITED TRAINING",null,null,0,0]
["A.4.3",null,"Provision of M1 - Basic principles and installation of irrigation systems by an SABI accredited training service provider / institute (25 People)","PC Sum",1,15000,"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)","PC Sum",1,15000,"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","PC Sum",1,15000,"rate only"]
["A.4.6",null,"Training allowance for direct payments to targeted labour in terms of formal training days","PC Sum",1,15000,"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","PC Sum",1,15000,"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(F32:F36)","v":75000},0,0]
[null,null,null,null,null,0,0]
["A,5",null,"Mark up on other specialists services",null,null,0,0]
["A.5.1",null,"Geohydrological services","PC sum",1,15000,"rate only"]
["A.5.2",null,"Electrical and mechanical engineering services","PC sum",1,15000,"rate only"]
["A.5.3",null,"Geotechnical services","PC sum",1,15000,"rate only"]
["A.5.4",null,"Agricultural Engineering (Anciliry works)","PC sum",1,15000,"rate only"]
["A.5.5",null,"Provision of Operation and maintenance manual for Irrigation Development Works","PC sum",1,15000,"rate only"]
["A.5.6",null,"Structural engineering services","PC sum",1,15000,"rate only"]
["A.5.7",null,"Mark up on above","%",{"$f":"SUM(F40:F45)","v":90000},0,0]
[null,null,"TOTAL SECTION \"A2\" CARRIED FORWARD TO SUMMARY"]

{"sheet":"Earthworks","index":3,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,2,53,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,{"$f":"IF(AND(ISBLANK(D4),ISBLANK(E4)),0,IF(AND(ISTEXT(D4),ISBLANK(E4)),\"error\",IF(OR(D4=\"prov sum\",D4=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D4=\"prov sum\",D4=\"pc sum\"),\"rate only\",F4*E4)","v":0}]
["B.1.2",null,"Clear and grub vegetation on the pipeline path, 2m wide clearing","m",1,{"$f":"IF(AND(ISBLANK(D5),ISBLANK(E5)),0,IF(AND(ISTEXT(D5),ISBLANK(E5)),\"error\",IF(OR(D5=\"prov sum\",D5=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D5=\"prov sum\",D5=\"pc sum\"),\"rate only\",F5*E5)","v":0}]
["B.1.3",null,"De-bushing of virgin land with congested high dense bush/trees","ha",1,0,0]
["B.1.4",null,"De-bushing of virgin land with scattered bush/trees","ha",1,0,0]
[null,null,"Remove Topsoil ",null,null,0,0]
["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²",1,0,0]
[null,null,"Dams De-Silting",null,null,0,0]
["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³",1,0,0]
[null,null,"Keeping excavations free of water:",null,null,0,0]
["B.1.7",null,"Keeping excavations free from mud and storm water ","Sum",1,0,0]
["B.1.8",null,"Handling and Keeping excavations free from subterranean sources.","Sum",1,0,0]
[null,null,null,null,null,0,0]
["B.2","SANS 1200D","EXCAVATION",null,null,0,0]
["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,0,0]
["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,0,0]
["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,0,0]
["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,0,0]
[null,null,null,null,null,0,0]
[null,null,"Extra-over Item above (Items B.2.1 - B.2.6)",null,null,0,0]
["B.2.5",null,"Intermediate excavations","mᶾ",1,0,0]
["B.2.6",null,"Hard excavations","mᶾ",1,0,0]
["B.2.7",null,"Boulder excavation, Class A","mᶾ",1,0,0]
["B.2.8",null,"Boulder excavation, Class B","mᶾ",1,0,0]
[null,null,"BEDDING (PIPES) ",null,null,0,0]
[null,null,"Provision of bedding from trench excavation:",null,null,0,0]
["B.2.9",null,"Selected granular material","m³",1,0,0]
["B.2.10",null,"Selected fill material","m³",1,0,0]
[null,null,"Supply only of bedding by importation From other necessary excavations (Provisional)",null,null,0,0]
["B.2.11",null,"Selected granular material","m³",1,0,0]
["B.2.12",null,"Selected fill material","m³",1,0,0]
[null,null,null,null,null,0,0]
[null,null,"Dealing with Services that intersect a trench to complete works:",null,null,0,0]
["B.2.13",null,"Stock fences","No",1,0,0]
["B.2.14",null,"Water Pipes","No",1,0,0]
["B.2.15",null,"Roads","No",1,0,0]
["B.2.16",null,"Power cables","No",1,0,0]
[null,null,"Finishing",null,null,0,0]
[null,null,"Reinstate road surfaces complete with all courses:",null,null,0,0]
["B.2.17",null,"Gravel road surfaces","m²",1,0,0]
["B.2.18",null,"Paved road surfaces","m²",1,0,0]
[null,null,null,null,null,0,0]
["B.3",null,"Soil Preparation ",null,null,0,0]
["B.3.1",null,"Plough land earmarked for irrigation to a depth of 300 mm","ha",1,0,0]
["B.3.2",null,"Disk land earmarked for irrigation ","ha",1,0,0]
["B.3.3",null,"Rip the land earmarked for irrigaion to a depth of 600 mm, One way ","ha",1,0,0]
["B.3.4",null,"Rip the land earmarked for irrigaion to a depth of 600 mm, 2nd Cross Ripping at 45deg ","ha",1,0,0]
["B.3.5",null,"Vegetable crops ridges making with less than 0,5m wide width and 0,5m height in the field ","ha",1,0,0]
["B.3.6",null,"Citrus ochard ridges making with over 1m wide width and 1m height in the field ","ha",1,0,0]
["B.3.7",null,"Extra over above for operations under Shadenets and Tunnels (Items B.3.1 - B.3.6)","ha",1,0,0]
[null,null,null,null,null,0,0]
[null,null,"TOTAL SECTION \"B\" CARRIED FORWARD TO SUMMARY"]

{"sheet":"Galvanised Fittings","index":4,"n_rows":258,"n_cols":7,"rows_kept":258,"cut":false,"hidden":false,"merged":[[2,2,2,5],[257,5,257,6],[257,2,257,4]]}
["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,{"$f":"IF(AND(ISBLANK(D6),ISBLANK(E6)),0,IF(AND(ISTEXT(D6),ISBLANK(E6)),\"error\",IF(OR(D6=\"prov sum\",D6=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D6=\"prov sum\",D6=\"pc sum\"),\"rate only\",F6*E6)","v":0}]
["C.1.2",null,"50 mm","no",1,{"$f":"IF(AND(ISBLANK(D7),ISBLANK(E7)),0,IF(AND(ISTEXT(D7),ISBLANK(E7)),\"error\",IF(OR(D7=\"prov sum\",D7=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D7=\"prov sum\",D7=\"pc sum\"),\"rate only\",F7*E7)","v":0}]
["C.1.3",null,"65 mm","no",1,0,0]
["C.1.4",null,"80 mm","no",1,0,0]
["C.1.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.2",null,"Nipple Galvanised Hexagonal",null,null,0,0]
["C.2.1",null,"40 mm","no",1,0,0]
["C.2.2",null,"50 mm","no",1,0,0]
["C.2.3",null,"65 mm","no",1,0,0]
["C.2.4",null,"80 mm","no",1,0,0]
["C.2.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.3",null,"Elbow Galvanised Female/Female 900",null,null,0,0]
["C.3.1",null,"40 mm","no",1,0,0]
["C.3.2",null,"50 mm","no",1,0,0]
["C.3.3",null,"65 mm","no",1,0,0]
["C.3.4",null,"80 mm","no",1,0,0]
["C.3.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.4",null,"Elbow Galvanised Male/Female 900",null,null,0,0]
["C.4.1",null,"40 mm","no",1,0,0]
["C.4.2",null,"50 mm","no",1,0,0]
["C.4.3",null,"65 mm","no",1,0,0]
["C.4.4",null,"80 mm","no",1,0,0]
["C.4.5",null,"100 mm","no",1,0,0]
["C.5",null,"Elbow Galvanised Gemale/Female 45",null,null,0,0]
["C.5.1",null,"40 mm","no",1,0,0]
["C.5.2",null,"50 mm","no",1,0,0]
["C.5.3",null,"65 mm","no",1,0,0]
["C.5.4",null,"80 mm","no",1,0,0]
["C.5.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.6",null,"Coupling galvanised swage",null,null,0,0]
["C.6.1",null,"40 mm","no",1,0,0]
["C.6.2",null,"50 mm","no",1,0,0]
["C.6.3",null,"65 mm","no",1,0,0]
["C.6.4",null,"80 mm","no",1,0,0]
["C.6.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.7",null,"Crosses galvanised",null,null,0,0]
["C.7.1",null,"40 mm","no",1,0,0]
["C.7.2",null,"50 mm","no",1,0,0]
["C.7.3",null,"65 mm","no",1,0,0]
["C.7.4",null,"80 mm","no",1,0,0]
["C.7.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.8",null,"Backnut galvanised",null,null,0,0]
["C.8.1",null,"40 mm","no",1,0,0]
["C.8.2",null,"50 mm","no",1,0,0]
["C.8.3",null,"65 mm","no",1,0,0]
["C.8.4",null,"80 mm","no",1,0,0]
["C.8.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.9",null,"Union galvanised conical",null,null,0,0]
["C.9.1",null,"40 mm","no",1,0,0]
["C.9.2",null,"50 mm","no",1,0,0]
["C.9.3",null,"65 mm","no",1,0,0]
["C.9.4",null,"80 mm","no",1,0,0]
["C.9.5",null,"100 mm","no",1,0,0]
[]
["C.10",null,"Union galvanised conical",null,null,{"$f":"IF(AND(ISBLANK(D67),ISBLANK(E67)),0,IF(AND(ISTEXT(D67),ISBLANK(E67)),\"error\",IF(OR(D67=\"prov sum\",D67=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D67=\"prov sum\",D67=\"pc sum\"),\"rate only\",F67*E67)","v":0}]
["C.10.1",null,"40 mm","no",1,0,0]
["C.10.2",null,"50 mm","no",1,0,0]
["C.10.3",null,"65 mm","no",1,0,0]
["C.10.4",null,"80 mm","no",1,0,0]
["C.10.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.11",null,"Coupling Galvanised Johnson",null,null,0,0]
["C.11.1",null,"40 mm","no",1,0,0]
["C.11.2",null,"50 mm","no",1,0,0]
["C.11.3",null,"65 mm","no",1,0,0]
["C.11.4",null,"80 mm","no",1,0,0]
["C.11.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.12",null,{"$f":"PROPER(\"NIPPLE GALVANISED LONGSCREW\")","v":"Nipple Galvanised Longscrew"},null,null,0,0]
["C.12.1",null,"40 mm","no",1,0,0]
["C.12.2",null,"50 mm","no",1,0,0]
["C.12.3",null,"65 mm","no",1,0,0]
["C.12.4",null,"80 mm","no",1,0,0]
["C.12.5",null,"100 mm","no",1,0,0]
[]
["C.13",null,{"$f":"PROPER(\"ADAPTOR GALVANISED SWAGE\")","v":"Adaptor Galvanised Swage"},null,null,0,0]
["C.13.1",null,"40 mm","no",1,0,0]
["C.13.2",null,"50 mm","no",1,0,0]
["C.13.3",null,"65 mm","no",1,0,0]
["C.13.4",null,"80 mm","no",1,0,0]
["C.13.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.14",null,"Plug Galvanised Hollow",null,null,0,0]
["C.14.1",null,"40 mm","no",1,0,0]
["C.14.2",null,"50 mm","no",1,0,0]
["C.14.3",null,"65 mm","no",1,0,0]
["C.14.4",null,"80 mm","no",1,0,0]
["C.14.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.15",null,"Socket Galvanised",null,null,0,0]
["C.15.1",null,"40 mm","no",1,0,0]
["C.15.2",null,"50 mm","no",1,0,0]
["C.15.3",null,"65 mm","no",1,0,0]
["C.15.4",null,"80 mm","no",1,0,0]
["C.15.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.16",null,"Endcap Galvanised ",null,null,0,0]
["C.16.1",null,"40 mm","no",1,0,0]
["C.16.2",null,"50 mm","no",1,0,0]
["C.16.3",null,"65 mm","no",1,0,0]
["C.16.4",null,"80 mm","no",1,0,0]
["C.16.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.17",null,"Holderbat Galvanised",null,null,0,0]
["C.17.1",null,"40 mm","no",1,0,0]
["C.17.2",null,"50 mm","no",1,0,0]
["C.17.3",null,"65 mm","no",1,0,0]
["C.17.4",null,"80 mm","no",1,0,0]
["C.17.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.18",null,"Socket Galvanised Sprinkler",null,null,0,0]
["C.18.1",null,"20 mm","no",1,0,0]
["C.18.2",null,"25 mm","no",1,0,0]
["C.18.3",null,"32 mm","no",1,{"$f":"IF(AND(ISBLANK(D126),ISBLANK(E126)),0,IF(AND(ISTEXT(D126),ISBLANK(E126)),\"error\",IF(OR(D126=\"prov sum\",D126=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D126=\"prov sum\",D126=\"pc sum\"),\"rate only\",F126*E126)","v":0}]
["C.18.4",null,"40 mm","no",1,0,0]
["C.18.5",null,"50 mm","no",1,0,0]
["C.18.6",null,"65 mm","no",1,0,0]
["C.18.7",null,"80 mm","no",1,0,0]
["C.18.8",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.19",null,"Tee Galvanised",null,null,0,0]
["C.19.1",null,"40 mm","no",1,0,0]
["C.19.2",null,"50 mm","no",1,0,0]
["C.19.3",null,"65 mm","no",1,0,0]
["C.19.4",null,"80 mm","no",1,0,0]
["C.19.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.20",null,"Socket Steel",null,null,0,0]
["C.20.1",null,"40 mm","no",1,0,0]
["C.20.2",null,"50 mm","no",1,0,0]
["C.20.3",null,"65 mm","no",1,0,0]
["C.20.4",null,"80 mm","no",1,0,0]
["C.20.5",null,"100 mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.21",null,"Socket Galvanised Reducing",null,null,0,0]
["C.21.1",null,"40x25mm","no",1,0,0]
["C.21.2",null,"40x32mm","no",1,0,0]
["C.21.3",null,"50x25mm","no",1,0,0]
["C.21.4",null,"50x32mm","no",1,0,0]
["C.21.5",null,"50x40mm","no",1,0,0]
["C.21.6",null,"65x25mm","no",1,0,0]
["C.21.7",null,"65x32mm","no",1,0,0]
["C.21.8",null,"65x40mm","no",1,0,0]
["C.21.9",null,"65x50mm","no",1,0,0]
["C.21.10",null,"80x40mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.22",null,"Tee Galvanised Reducing",null,null,0,0]
["C.22.1",null,"40x25mm","no",1,0,0]
["C.22.2",null,"40x32mm","no",1,0,0]
["C.22.3",null,"50x25mm","no",1,0,0]
["C.22.4",null,"50x32mm","no",1,0,0]
["C.22.5",null,"50x40mm","no",1,0,0]
["C.22.6",null,"65x25mm","no",1,0,0]
["C.22.7",null,"65x32mm","no",1,0,0]
["C.22.8",null,"65x40mm","no",1,0,0]
["C.22.9",null,"65x50mm","no",1,0,0]
["C.22.10",null,"80x40mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.23",null,"Standpipe Galvanised",null,null,0,0]
["C.23.1",null,"25mm x 750mm","no",1,0,0]
["C.23.2",null,"25mm x 1000mm","no",1,0,0]
["C.23.3",null,"32mm x 500mm","no",1,0,0]
["C.23.4",null,"32mm x 750mm","no",1,0,0]
["C.23.5",null,"32mm x 900mm","no",1,0,0]
["C.23.6",null,"32mm x 1000mm","no",1,0,0]
["C.23.7",null,"40mm x 500mm","no",1,0,0]
["C.23.8",null,"40mm x 750mm","no",1,0,0]
["C.23.9",null,"40mm x 1000mm","no",1,0,0]
["C.23.10",null,"50mm x 500mm","no",1,0,0]
["C.23.11",null,"50mm x 1000mm","no",1,0,0]
["C.23.12",null,"65mm x 500mm","no",1,0,0]
["C.23.13",null,"65mm x 1000mm","no",1,0,0]
["C.23.14",null,"80mm x 500mm","no",1,0,0]
["C.23.15",null,"80mm x 1000mm","no",1,0,0]
["C.23.16",null,"100mm x 500mm","no",1,0,0]
["C.23.17",null,"100mm x 1000mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.24",null,"Flange Screwed ",null,null,{"$f":"IF(AND(ISBLANK(D190),ISBLANK(E190)),0,IF(AND(ISTEXT(D190),ISBLANK(E190)),\"error\",IF(OR(D190=\"prov sum\",D190=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D190=\"prov sum\",D190=\"pc sum\"),\"rate only\",F190*E190)","v":0}]
["C.24.1",null,"40mm","no",1,0,0]
["C.24.2",null,"50mm","no",1,0,0]
["C.24.3",null,"65mm","no",1,0,0]
["C.24.4",null,"80mm","no",1,0,0]
["C.24.5",null,"100mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.25",null,"Flange Screwed On ",null,null,0,0]
["C.25.1",null,"40mm","no",1,0,0]
["C.25.2",null,"50mm","no",1,0,0]
["C.25.3",null,"65mm","no",1,0,0]
["C.25.4",null,"80mm","no",1,0,0]
["C.25.5",null,"100mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.26",null,"Flange Weld On ",null,null,0,0]
["C.26.1",null,"40mm","no",1,0,0]
["C.26.2",null,"50mm","no",1,0,0]
["C.26.3",null,"65mm","no",1,0,0]
["C.26.4",null,"80mm","no",1,0,0]
["C.26.5",null,"100mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.27",null,"Flange Weld On (Table 1600/3)",null,null,0,0]
["C.27.1",null,"50mm","no",1,0,0]
["C.27.2",null,"65mm","no",1,0,0]
["C.27.3",null,"80mm","no",1,0,0]
["C.27.4",null,"100mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.28",null,"Back Ring (Used With UPV Stubs) ",null,null,0,0]
["C.28.1",null,"50mm","no",1,0,0]
["C.28.2",null,"65mm","no",1,0,0]
["C.28.3",null,"80mm","no",1,0,0]
["C.28.4",null,"100mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.29",null,"Insertion Ring Gasket",null,null,0,0]
["C.29.1",null,"50mm","no",1,0,0]
["C.29.2",null,"65mm","no",1,0,0]
["C.29.3",null,"80mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.30",null,"Insertion Ring Full Face Gasket",null,null,0,0]
["C.30.1",null,"50mm","no",1,0,0]
["C.30.2",null,"65mm","no",1,0,0]
["C.30.3",null,"80mm","no",1,0,0]
[null,null,null,null,null,0,0]
["C.31",null,"Galvanised steel pipe ",null,null,0,0]
["C.31.1",null,"40 mm","m",1,0,0]
["C.31.2",null,"50 mm","m",1,0,0]
["C.31.3",null,"65 mm","m",1,0,0]
["C.31.4",null,"80 mm","m",1,0,0]
[null,null,null,null,null,0,0]
["C.32",null,"Galvanised steel quick coupling perrot pipe",null,null,0,0]
["C.32.1",null,"50 mm","m",1,0,0]
["C.32.2",null,"70 mm","m",1,0,0]
["C.32.3",null,"89 mm","m",1,0,0]
[null,null,null,null,null,0,0]
["C.33",null,"Galvanised steel Special fittings",null,null,0,0]
["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,15000,"rate only"]
["C.33.2",null,"Profit over above Item C.33.1","%",{"$f":"F245","v":15000},0,0]
["C.33.3",null,"Extra over Item C.33.2: Deliver,install and test fabricated special galvanised steel pipes.","Sum",1,0,0]
[null,null,null,null,null,0,0]
["C.34",null,"Other Galvanised Steel Pipes and Fittings",null,null,0,0]
["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,15000,"rate only"]
["C.34.2",null,"Mark up on other Galvanised Steel Pipes and Fittings for Item C.34.1","%",{"$f":"F250","v":15000},0,0]
["C.34.3",null,"Extra over Item C.34.2: Deliver,install and test other Galvanised Steel Pipes and Fittings","Sum",1,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,{"$f":"IF(AND(ISBLANK(D254),ISBLANK(E254)),0,IF(AND(ISTEXT(D254),ISBLANK(E254)),\"error\",IF(OR(D254=\"prov sum\",D254=\"pc sum\"),15000,0)))","v":0},{"$f":"IF(OR(D254=\"prov sum\",D254=\"pc sum\"),\"rate only\",F254*E254)","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[]
[null,null,"TOTAL SECTION \"C\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G5:G252)","v":0}]

{"sheet":"HDPE","index":5,"n_rows":211,"n_cols":7,"rows_kept":211,"cut":false,"hidden":false,"merged":[[210,2,210,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.1",null,"32mm","no",1]
["D.1.2",null,"40mm","no",1]
["D.1.3",null,"50mm","no",1]
["D.1.4",null,"63mm","no",1]
["D.1.5",null,"75mm","no",1]
["D.1.6",null,"90mm","no",1]
[]
["D.2",null,"Endcap Compression"]
["D.2.1",null,"32mm","no",1]
["D.2.2",null,"40mm","no",1]
["D.2.3",null,"50mm","no",1]
["D.2.4",null,"63mm","no",1]
["D.2.5",null,"75mm","no",1]
["D.2.6",null,"90mm","no",1]
[]
["D.3",null,"Equal Tee Compression"]
["D.3.1",null,"32mm","no",1]
["D.3.2",null,"40mm","no",1]
["D.3.3",null,"50mm","no",1]
["D.3.4",null,"63mm","no",1]
["D.3.5",null,"75mm","no",1]
["D.3.6",null,"90mm","no",1]
[]
["D.4",null,"Elbow Compression"]
["D.4.1",null,"32mm","no",1]
["D.4.2",null,"40mm","no",1]
["D.4.3",null,"50mm","no",1]
["D.4.4",null,"63mm","no",1]
["D.4.5",null,"75mm","no",1]
["D.4.6",null,"90mm","no",1]
[]
["D.5",null,"Male Adaptors"]
["D.5.1",null,"32mm x 25mm","no",1]
["D.5.2",null,"32mm x 32mm","no",1]
["D.5.3",null,"40mm x 25mm","no",1]
["D.5.4",null,"40mm x 32mm","no",1]
["D.5.5",null,"40mm x 40mm","no",1]
["D.5.6",null,"50mm x 32mm","no",1]
["D.5.7",null,"50mm x 40mm","no",1]
["D.5.8",null,"50mm x 50mm","no",1]
["D.5.9",null,"63mm x 40mm","no",1]
["D.5.10",null,"63mm x 50mm","no",1]
["D.5.11",null,"63mm x 65mm","no",1]
["D.5.12",null,"75mm x 50mm","no",1]
["D.5.13",null,"75mm x 65mm","no",1]
["D.5.14",null,"75mm x 80mm","no",1]
["D.5.15",null,"90mm x 50mm","no",1]
["D.5.16",null,"90mm x 65mm","no",1]
["D.5.17",null,"90mm x 80mm","no",1]
[]
["D.6",null,"Female Adaptors"]
["D.6.1",null,"32mm x 25mm","no",1]
["D.6.2",null,"32mm x 32mm","no",1]
["D.6.3",null,"40mm x 25mm","no",1]
["D.6.4",null,"40mm x 32mm","no",1]
["D.6.5",null,"40mm x 40mm","no",1]
["D.6.6",null,"50mm x 32mm","no",1]
["D.6.7",null,"50mm x 40mm","no",1]
["D.6.8",null,"50mm x 50mm","no",1]
["D.6.9",null,"63mm x 40mm","no",1]
["D.6.10",null,"63mm x 50mm","no",1]
["D.6.11",null,"75mm x 50mm","no",1]
["D.6.12",null,"75mm x 65mm","no",1]
["D.6.13",null,"75mm x 80mm","no",1]
["D.6.14",null,"90mm x 50mm","no",1]
["D.6.15",null,"90mm x 65mm","no",1]
["D.6.16",null,"90mm x 80mm","no",1]
[]
["D.7",null,"Reducing Coupling"]
["D.7.1",null,"40mm x 25mm","no",1]
["D.7.2",null,"40mm x 32mm","no",1]
["D.7.3",null,"50mm x 32mm","no",1]
["D.7.4",null,"50mm x 40mm","no",1]
["D.7.5",null,"63mm x 32mm","no",1]
["D.7.6",null,"63mm x 40mm","no",1]
["D.7.7",null,"63mm x 50mm","no",1]
["D.7.8",null,"75mm x 50mm","no",1]
["D.7.9",null,"75mm x 63mm","no",1]
["D.7.10",null,"90mm x 63mm","no",1]
["D.7.11",null,"90mm x 75mm","no",1]
["D.7.12",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.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.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]
[null,null,null,null,null,null,{"$f":"F167*E167","v":0}]
["D.12",null,"Other Compression Fittings",null,null,null,0]
["D.12.1",null,"Mark up on other compression fitting as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,5000,"rate only"]
["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]
[null,null,null,null,null,null,0]
["D.13",null,"HDPE pipe complete with fittings (Class 6)",null,null,null,0]
["D.13.1",null,"32mm","m",1]
["D.13.2",null,"40mm","m",1]
["D.13.3",null,"50mm","m",1]
["D.13.4",null,"63mm","m",1]
["D.13.5",null,"75mm","m",1]
[null,null,null,null,null,null,0]
["D.14",null,"HDPE pipe complete with fittings (Class 10)",null,null,null,0]
["D.14.1",null,"32mm","m",1]
["D.14.2",null,"40mm","m",1]
["D.14.3",null,"50mm","m",1]
["D.14.4",null,"63mm","m",1]
["D.14.5",null,"75mm","m",1]
[null,null,null,null,null,null,0]
["D.15",null,"HDPE pipe complete with fittings (Class 12)",null,null,null,0]
["D.15.1",null,"32mm","m",1]
["D.15.2",null,"40mm","m",1]
["D.15.3",null,"50mm","m",1]
["D.15.4",null,"63mm","m",1]
["D.15.5",null,"75mm","m",1]
[null,null,null,null,null,null,0]
["D.16",null,"HDPE pipe complete with fittings (Class 16)",null,null,null,0]
["D.16.1",null,"32mm","m",1]
["D.16.2",null,"40mm","m",1]
["D.16.3",null,"50mm","m",1]
["D.16.4",null,"63mm","m",1]
["D.16.5",null,"75mm","m",1]
[]
["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]
[null,null,null,null,null,null,0]
["D.18",null,"Special HDPE pipes and fittings",null,null,null,0]
["D.18.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,"rate only"]
["D.18.2",null,"Mark up on Special HDPE pipes","%",{"$f":"F207","v":10000}]
["D.18.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":6,"n_rows":168,"n_cols":7,"rows_kept":168,"cut":false,"hidden":false,"merged":[[167,2,167,4],[167,5,167,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.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.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.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.5",null,"uPVC  pipe complete with spigot, integral socket and rubber ring seal (Class 20) "]
["E.5.1",null," 50 mm ","m",1]
["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.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.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.7.4",null," 90 mm ","m",1]
[]
["E.8",null,"COUPLINGS DOUBLE & REPAIR"]
["E.8.1",null," 50 mm ","no",1]
["E.8.2",null," 63 mm ","no",1]
["E.8.3",null," 75 mm ","no",1]
["E.8.4",null," 90 mm ","no",1]
[]
["E.9",null,"Pipe seal to female thread elbow"]
["E.9.1",null," 50 mm x 2 inch","no",1]
["E.9.2",null," 63 mm x 2 inch","no",1]
["E.9.3",null," 75 mm x 2 inch ","no",1]
["E.9.4",null," 75 mm x 3 inch ","no",1]
["E.9.5",null," 90 mm x 3 inch","no",1]
[]
["E.10",null,"FLANGE ADAPTORS EPOXY COATED ALUMINIUM  (TABLE D)"]
["E.10.1",null,"50mm","no",1]
["E.10.2",null,"63mm","no",1]
["E.10.3",null,"75mm","no",1]
["E.10.4",null,"90mm","no",1]
[]
["E.11",null,"FLANGE ADAPTORS CAST IRON BITUMEN COATED (TABLE D)"]
["E.11.1",null,"50mm","no",1]
["E.11.2",null,"63mm","no",1]
["E.11.3",null,"75mm","no",1]
["E.11.4",null,"90mm","no",1]
[]
["E.12",null," BENDS EPOXY COATED ALUMINIUM  (64-45)"]
["E.12.1",null,"50mm","no",1]
["E.12.2",null,"63mm","no",1]
["E.12.3",null,"75mm","no",1]
["E.12.4",null,"90mm","no",1]
[]
["E.13",null," BENDS CAST IRON BITUMEN COATED           (11,5-90 Degrees)"]
["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.14",null," COUPLING EPOXY COATED ALUMINIUM             (9 BAR)"]
["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.15",null," COUPLING CAST IRON BITUMEN COATED             (16 BAR)"]
["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.16",null,"ADAPTOR B.S.P MALE &FEMALE"]
["E.16.1",null,"50mm x 2\" ","no",1]
["E.16.2",null,"63mm x 2\"","no",1]
["E.16.3",null,"75mm x 2\"","no",1]
["E.16.4",null,"75mm x 3\" ","no",1]
["E.16.5",null,"90mm x 3\"","no",1]
["E.16.6",null,"90mm x 4\"","no",1]
[]
["E.17",null,"END CAPS"]
["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.18",null,"EQUAL TEES"]
["E.18.1",null,"50mm","no",1]
["E.18.2",null,"63mm","no",1]
["E.18.3",null,"75mm","no",1]
["E.18.4",null,"90mm","no",1]
[]
["E.19",null,"BENDS - 22 & 11.25 DEGREES"]
["E.19.1",null,"50mm","no",1]
["E.19.2",null,"63mm","no",1]
["E.19.3",null,"75mm","no",1]
[]
["E.20",null,"BENDS - 90 & 45 DEGREES"]
["E.20.1",null,"50mm","no",1]
["E.20.2",null,"63mm","no",1]
["E.20.3",null,"75mm","no",1]
[]
["E.21",null,"Male/Female Reducer class 9"]
["E.21.1",null,"50mm x 40mm","no",1]
["E.21.2",null,"63mm x 40mm","no",1]
["E.21.3",null,"63mm x 50mm","no",1]
["E.21.4",null,"75mm x 50mm","no",1]
["E.21.5",null,"75mm x 63mm","no",1]
[]
["E.22",null,"Reducing Cross"]
["E.22.1",null,"50mm x 40mm","no",1]
["E.22.2",null,"63mm x 40mm","no",1]
["E.22.3",null,"63mm x 50mm","no",1]
["E.22.4",null,"75mm x 50mm","no",1]
["E.22.5",null,"75mm x 63mm","no",1]
["E.22.6",null,"90mm x 63mm","no",1]
["E.22.7",null,"90mm x 75mm","no",1]
[]
["E.23",null,"Reducing Tee"]
["E.23.1",null,"50mm x 40mm","no",1]
["E.23.2",null,"63mm x 40mm","no",1]
["E.23.3",null,"63mm x 50mm","no",1]
["E.23.4",null,"75mm x 50mm","no",1]
["E.23.5",null,"75mm x 63mm","no",1]
["E.23.6",null,"90mm x 63mm","no",1]
["E.23.7",null,"90mm x 75mm","no",1]
[]
["E.24",null,"FLANGED ON BRANCH TEE (Table D)"]
["E.24.1",null,"50mm","no",1]
["E.24.2",null,"63mm","no",1]
["E.24.3",null,"75mm","no",1]
["E.24.4",null,"90mm","no",1]
[]
["E.25",null,"ADAPTOR FLANGED (Table D)"]
["E.25.1",null,"50mm","no",1]
["E.25.2",null,"63mm","no",1]
["E.25.3",null,"75mm","no",1]
[]
["E.26",null,"Other PVC fittings and pipes",null,null,null,{"$f":"F162*E162","v":0}]
["E.26.1",null,"Mark up on other PVC fittings and pipes as specified by the Engineer  (3 Quotations from reputable suppliers)","PC Sum",1,10000,"rate only"]
["E.26.2",null,"Mark up on other PVC fittings and pipes","%",{"$f":"F163","v":10000}]
["E.26.3",null,"Extra over Item E.30.2: Deliver,install and test other PVC pipes.","no",1]
["E.26.4",null,"Extra over Item E.30.2: Deliver,install and test other PVC fittings.","Sum",1,null,0]
[null,null,null,null,null,null,0]
[null,null,"TOTAL SECTION \"E\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G6:G167)","v":0}]

{"sheet":"DRIP","index":7,"n_rows":110,"n_cols":7,"rows_kept":110,"cut":false,"hidden":false,"merged":[[22,2,22,5],[33,2,33,3],[109,2,109,4],[109,5,109,6],[2,2,2,5],[4,2,4,4],[10,2,10,4],[16,2,16,5]]}
["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,"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.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.4",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.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,"Other Inline (Integral) Drippers PC and NPC"]
["F.5.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,10000,"rate only"]
["F.5.2",null,"Mark up on other Inline (Integral) Drippers PC and NPC","%",{"$f":"F30","v":10000}]
["F.5.3",null,"Extra over Item F.7.1: Deliver,install and test Other Inline (Integral) Drippers PC and NPC.","m",1]
[null,null,null,null,null,null,{"$f":"F33*E33","v":0}]
[null,null,"Supply, deliver,install and test the following  online drippers and pipes complete with fittings.",null,null,null,0]
["F.6",null,"INSERT FITTINGS",null,null,null,0]
["F.6.1",null,"12mm short coupling","no",1]
["F.6.2",null,"16mm short coupling","no",1]
["F.6.3",null,"12mm long coupling","no",1]
["F.6.4",null,"16mm long coupling","no",1]
["F.6.5",null,"17mm long coupling ","no",1]
["F.6.6",null,"20mm long coupling","no",1]
["F.6.7",null,"16/12mm long reducing","no",1]
["F.6.8",null,"17/16mm long reducing","no",1]
["F.6.9",null,"20/16mm long reducing","no",1]
["F.6.10",null,"20/17mm long reducing","no",1]
["F.6.11",null,"12mm elbow long insert","no",1]
["F.6.12",null,"16mm elbow long insert","no",1]
["F.6.13",null,"20mm elbow long insert","no",1]
["F.6.14",null,"17mm elbow long insert","no",1]
["F.6.15",null,"12x12x12 long insert T","no",1]
["F.6.16",null,"16x16x16 long insert T","no",1]
["F.6.17",null,"17x17x17 long insert T ","no",1]
["F.6.18",null,"20x20x20 long insert T","no",1]
["F.6.19",null,"16x12x16 reducing T","no",1]
["F.6.20",null,"Dripline LPD Barb 17mm","no",1]
["F.6.21",null,"Dripline LPD Barb 16mm","no",1]
["F.6.22",null,"Barb Connector 17mm x ½” Male","no",1]
["F.6.23",null,"Barb Connector 16mm x ½” Male","no",1]
["F.6.24",null,"Dripline Flush VLV Barb20 W/Snap Clip","no",1]
["F.6.25",null,"Dripline Flush VLV Barb17 W/Snap Clip","no",1]
["F.6.26",null,"Dripline Flush VLV Barb16 W/Snap Clip","no",1]
["F.6.27",null,"Multi Outlet 3/4” x 6 x 12mm   6 way","no",1]
["F.6.28",null,"Multi Outlet 1” x 6 x 16mm   6 way","no",1]
["F.6.29",null,"Combination saddle + nut 32mm poly pipe or bigger","no",1]
["F.6.30",null,"Stopper  -  12/16/17mm","no",1]
["F.6.31",null,"Stopper figure 8 20mm","no",1]
["F.6.32",null,"2 way angle barb connector - 16 X 3/4 MALE","no",1]
[]
["F.7",null,"BLIND PIPE (LDPE)"]
["F.7.1",null,"12 mm","m",1]
["F.7.2",null,"16 mm","m",1]
["F.7.3",null,"17 mm","m",1]
["F.7.4",null,"20 mm","m",1]
[]
["F.8",null,"Pressure compensating and Non Drain online drippers"]
["F.8.1",null,"1.0 l/h (seal 0.2 bar, fully open 0.6 - 3.5 bar)","no",1]
["F.8.2",null,"2.2 l/h (seal 0.2 bar, fully open 0.6 - 3.5 bar)","no",1]
["F.8.3",null,"3.8 l/h (seal 0.2 bar, fully open 0.6 - 3.5 bar)","no",1]
["F.8.4",null,"8.0 l/h (seal 0.2 bar, fully open 0.6 - 3.5 bar)","no",1]
["F.8.5",null,"3.1 l/h (seal 0.4 bar, fully open 1.1 - 3.5 bar)","no",1]
["F.8.6",null,"5.3 l/h (seal 0.2 bar, fully open 1.1- 3.5 bar)","no",1]
["F.8.7",null,"11 l/h (seal 0.4 bar, fully open 1.1 - 3.5 bar)","no",1]
[]
["F.9",null,"Non Pressure compensating Button Dripper "]
["F.9.1",null,"2 l/h ","no",10]
["F.9.2",null,"4 l/h ","no",10]
["F.9.3",null,"8 l/h","no",10]
[]
["F.10",null,"BUTTON DRIPPER ACCESSORIES (3x5 mm tube)"]
["F.10.1",null,"Single Threaded outlet adaptor","no",1]
["F.10.2",null,"2-way threaded branch adaptor","no",1]
["F.10.3",null,"2-way barbed branch adaptor","no",1]
["F.10.4",null,"4-way threaded branch adaptor","no",1]
["F.10.5",null,"4-way barbed branch adaptor","no",1]
["F.10.6",null,"Barb adaptor for multi outlet","no",1]
["F.10.7",null,"Connector JDW 3x5mm (used with 5mm Odx 3mm ID flex tube)","no",1]
["F.10.8",null,"Dripeg - flow equalizer or dripper (30 degree diagonal labyrinth)","no",1]
["F.10.9",null,"Snapeg (30 degree diagonal external grip)","no",1]
["F.10.10",null,"Flextubing 5mm OD x 3mm ID ","m",1]
["F.10.11",null,"Manifold 4-way complete with 400mm tube and peg","no",1]
["F.10.12",null,"Manifold 4-way complete with 600mm tube and peg","no",1]
["F.10.13",null,"Manifold 2-way complete with 400mm tube and peg","no",1]
["F.10.14",null,"Manifold 2-way complete with 600mm tube and peg","no",1]
[]
["F.11",null,"Other Online Drippers, fittings and pipes"]
["F.11.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,5000,"rate only"]
["F.11.2",null,"Mark up on other Online Drippers, fittings and LDPE pipes","%",{"$f":"F106","v":5000}]
["F.11.3",null,"Extra over Item F.13.1: Deliver,install and test Other Online Drippers and fittings.","Sum",1]
[]
[null,null,"TOTAL SECTION \"F\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G3:G109)","v":0}]

{"sheet":"Sprinkler","index":8,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,2,45,4],[45,5,45,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,"Micro 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,"Micro 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,"Micro Sprinkler: Operating preasure 0.75 - 2 bar, Flow rate 10 - 110 l/h, Wetting diameter 0.5 - 8m.",null,null,null,{"$f":"F12*E12","v":0}]
["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,"Micro 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.",null,null,null,0]
["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.5",null,"Micro 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]
[null,null,null,null,null,null,0]
["G.6",null,"Impact Sprinkler: Operating preasure 2 - 3 bar, Flow rate 200 - 750 l/h, Wetting diameter 11 - 19m.  ",null,null,null,0]
["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]
[null,null,null,null,null,null,0]
["G.8",null,"Other Impact Sprinklers",null,null,null,0]
["G.8.1",null,"Mark up on other Impact Sprinklers as specified by the Engineer  (3 Quotations from reputable suppliers)","PC Sum",1,5000,"rate only"]
["G.8.2",null,"Mark up on other Impact Sprinklers","%",{"$f":"F36","v":5000}]
["G.8.3",null,"Extra over Item G.8.1: Deliver,install and test Other Impact Sprinklers","Sum",1]
[null,null,null,null,null,null,0]
["G.9",null,"PVC riser pipe threaded both ends",null,null,null,0]
["G.9.1",null,"300 mm x 15 mm","no",1]
["G.9.4",null,"1200 mm x 15 mm","no",1]
["G.9.6",null,"600 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:G45)","v":0}]

{"sheet":"Filters","index":9,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[[38,2,38,4],[38,5,38,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.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.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.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.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.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,20000,"rate only"]
["H.6.2",null,"Mark up on other Filters  ","%",{"$f":"F34","v":20000}]
["H.6.3",null,"Extra over Item H.6.1: Deliver,install and test other Filters:                    Up to 2 Unit filter bank ","no",1,null,{"$f":"F36*E36","v":0}]
["H.6.4",null,"Extra over Item H.6.1: Deliver,install and test other Filters:                     3 Unit filter bank ","no",1]
[]
[null,null,"TOTAL SECTION \"H\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G3:G38)","v":0}]

{"sheet":"Non-SABS LDPE","index":10,"n_rows":105,"n_cols":7,"rows_kept":105,"cut":false,"hidden":false,"merged":[[104,2,104,4],[104,5,104,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.1",null,"32mm","no",1]
["J.1.2",null,"40mm","no",1]
["J.1.3",null,"50mm","no",1]
[]
["J.2",null,"Endplug Insert"]
["J.2.1",null,"32mm","no",1]
["J.2.2",null,"40mm","no",1]
["J.2.3",null,"50mm","no",1]
[]
["J.3",null,"Equal Tee insert"]
["J.3.1",null,"32mm","no",1]
["J.3.2",null,"40mm","no",1]
["J.3.3",null,"50mm","no",1]
[]
["J.4",null,"Elbow insert"]
["J.4.1",null,"32mm","no",1]
["J.4.2",null,"40mm","no",1]
["J.4.3",null,"50mm","no",1]
[]
["J.5",null,"Male Adaptors"]
["J.5.1",null,"32mm","no",1]
["J.5.2",null,"40mm","no",1]
["J.5.3",null,"50mm","no",1]
[]
["J.6",null,"Reducing Male Adaptors"]
["J.6.1",null,"32mm x 25mm","no",1]
["J.6.2",null,"40mm x 32mm","no",1]
["J.6.3",null,"40mm x 50mm","no",1]
["J.6.4",null,"50mm x 40mm","no",1]
[null,null,null,null,null,null,{"$f":"F35*E35","v":0}]
["J.7",null,"Female Adaptors",null,null,null,0]
["J.7.1",null,"32mm","no",1]
["J.7.2",null,"40mm","no",1]
[]
["J.8",null,"Reducing Insert couplings"]
["J.8.1",null,"40mm x 25mm","no",1]
["J.8.2",null,"40mm x 32mm","no",1]
["J.8.3",null,"50mm x 25mm","no",1]
["J.8.4",null,"50mm x 32mm","no",1]
["J.8.5",null,"50mm x 40mm","no",1]
[]
["J.9",null,"Male Combination Elbow Adaptor"]
["J.9.1",null,"32mm x 32mm","no",1]
["J.9.2",null,"40mm x 40mm","no",1]
["J.9.3",null,"50mm x 50mm","no",1]
[]
["J.10",null,"Female Combination Elbow Adaptor"]
["J.10.1",null,"32mm x 32mm","no",1]
["J.10.2",null,"40mm x 40mm","no",1]
["J.10.3",null,"40mm x 50mm","no",1]
["J.10.4",null,"50mm x 40mm","no",1]
["J.10.5",null,"50mm x 50mm","no",1]
[]
["J.11",null,"Male Combination Tee"]
["J.11.1",null,"32mm x 32mm","no",1]
["J.11.2",null,"40mm x 25mm","no",1]
["J.11.3",null,"40mm x 32mm","no",1]
["J.11.4",null,"40mm x 40mm","no",1]
["J.11.5",null,"50mm x 25mm","no",1]
["J.11.6",null,"50mm x 40mm","no",1]
["J.11.7",null,"50mm x 50mm","no",1]
[null,null,null,null,null,null,{"$f":"F67*E67","v":0}]
["J.12",null,"Female Combination Tee",null,null,null,0]
["J.12.1",null,"32mm x 32mm","no",1]
["J.12.2",null,"40mm x 25mm","no",1]
["J.12.3",null,"40mm x 32mm","no",1]
["J.12.4",null,"40mm x 40mm","no",1]
["J.12.5",null,"50mm x 25mm","no",1]
["J.12.6",null,"50mm x 32mm","no",1]
["J.12.7",null,"50mm x 40mm","no",1]
["J.12.8",null,"50mm x 50mm","no",1]
[]
["J.13",null,"Reducing Tee"]
["J.13.1",null,"40mm x 25mm","no",1]
["J.13.2",null,"40mm x 32mm","no",1]
["J.13.3",null,"50mm x 25mm","no",1]
["J.13.4",null,"50mm x 32mm","no",1]
["J.13.5",null,"50mm x 40mm","no",1]
[]
["J.14",null,"LDPE pipe complete with fittings (Class 6)"]
["J.14.1",null,"32mm","m",1]
["J.14.2",null,"40mm","m",1]
["J.14.3",null,"50mm","m",1]
[]
["J.15",null,"LDPE pipe complete with fittings (Class 3)"]
["J.15.1",null,"32mm","m",1]
["J.15.2",null,"40mm","m",1]
["J.15.3",null,"50mm","m",1]
[null,null,null,null,null,null,0]
["J.16",null,"Other LDPE Pipes",null,null,null,0]
["J.16.1",null,"Mark up on other LDPE Pipes as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,10000,"rate only"]
["J.16.2",null,"Mark up on other LDPE Pipes. ","%",{"$f":"F96","v":10000}]
["J.16.3",null,"Extra over Item J.17.2: Deliver, Install, Testing and Commission other LDPE Pipes.","m",100]
[null,null,null,null,null,null,0]
["J.17",null,"Other Insert Fittings (Poly Prop) for LDPE Pipes",null,null,null,0]
["J.17.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.17.2",null,"Mark up on other  Insert Fittings (Poly Prop) for LDPE Pipes. ","%",{"$f":"F101","v":10000}]
["J.17.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:G104)","v":0}]

{"sheet":"Valves & Meters","index":11,"n_rows":84,"n_cols":7,"rows_kept":84,"cut":false,"hidden":false,"merged":[[83,2,83,4],[83,5,83,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,"32mm","no",1]
["K.1.2",null,"40mm","no",1]
["K.1.3",null,"50mm","no",1]
[]
["K.2",null,"Solvent Weld PVC ball valve  (PN16)",null,null,null,{"$f":"F9*E9","v":0}]
["K.2.1",null,"32mm","no",1]
["K.2.2",null,"40mm","no",1]
["K.2.3",null,"50mm","no",1]
["K.2.4",null,"63mm","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]
[null,null,null,null,null,null,0]
["K.4",null,"Flanged cast iron gate valve  (PN25)           (SANS 664)",null,null,null,0]
["K.4.1",null,"50 mm","no",1]
["K.4.2",null,"65 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.6",null,"Supply, deliver, install and test the following diaphram irrigation control valves",null,null,null,0]
[null,null,"Manually Controlled Valve complete with 3-way selector (Closed, Outo, Open) PN 10",null,null,null,0]
["K.6.1",null,"a) 50 mm","no",1]
["K.6.2",null,"b) 65 mm","no",1]
[]
[null,null,"Solenoid Controlled Valve complete with 3-way solenoid (PN 10)"]
["K.6.3",null,"a) 50 mm","no",1]
["K.6.4",null,"b) 65 mm","no",1]
[]
[null,null,"Pressure Reducing Valve complete with 3-way selector and 3-way Pilot valve",null,null,null,{"$f":"F40*E40","v":0}]
["K.6.5",null,"a) 50 mm","no",1]
["K.6.6",null,"b) 65 mm","no",1]
[]
["K.7",null,"Other Valves",null,null,null,0]
["K.7.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.2",null,"Mark up on other Valves. ","%",{"$f":"F45","v":15000}]
["K.7.3",null,"Extra over Item K.7.4.2: Deliver, Install, Testing and Commission other Valves.","set",1]
[null,null,null,null,null,null,0]
["K.8",null,"Supply deliver and install the following water meters",null,null,null,0]
[null,null,"Cast Iron , Epoxy coated (Flange Table D)",null,null,null,0]
["K.8.1",null,"a) 40 mm","no",1]
["K.8.2",null,"b) 50 mm","no",1]
["K.8.3",null,"c) 65 mm","no",1]
[]
["K.9",null,"Other Water Meters",null,null,null,0]
["K.9.1",null,"Mark up on other Water Meters as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,8000,"rate only"]
["K.9.2",null,"Mark up on other Water Meters. ","%",{"$f":"F56","v":8000}]
["K.9.3",null,"Extra over Item K.8.2.2: Deliver, Install, Testing and Commission other Water Meters.","set",1]
[null,null,null,null,null,null,0]
["K.10",null,"Supply, deliver,install and test the following air valves and fittings.",null,null,null,0]
[null,null,"Double purpose air valves",null,null,null,0]
["K.10.1",null,"a) 25 mm","no",1]
["K.10.2",null,"b) 32 mm","no",1]
["K.10.3",null,"c) 40 mm","no",1]
["K.10.4",null,"d) 50 mm","no",1]
[]
[null,null,"Vacuum breakers"]
["K.10.5",null,"a) 25 mm","no",1]
["K.10.6",null,"b) 32 mm","no",1]
["K.10.7",null,"c) 40 mm","no",1]
["K.10.8",null,"d) 50 mm","no",1]
[null,null,null,null,null,null,0]
[null,null,"Automatic air valves,",null,null,null,0]
["K.10.9",null,"a) 25 mm","no",1]
["K.10.10",null,"b) 32 mm","no",1]
["K.10.11",null,"c) 40 mm","no",1]
["K.10.12",null,"d) 50 mm","no",1]
[]
["K.11",null,"Other Air Valves",null,null,null,0]
["K.11.1",null,"Mark up on other Air Valves as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,6000,"rate only"]
["K.11.2",null,"Mark up on other Air Valves. ","%",{"$f":"F80","v":6000}]
["K.11.3",null,"Extra over Item K.9.4.2: Deliver, Install, Testing and Commission other Air Valves.","set",1]
[]
[null,null,"TOTAL SECTION \"K\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G82)","v":0}]

{"sheet":"Shadenet ","index":12,"n_rows":104,"n_cols":7,"rows_kept":104,"cut":false,"hidden":false,"merged":[[103,2,103,4],[103,5,103,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]
[null,null,null,null,null,null,{"$f":"F16*E16","v":0}]
["L.2",null,"CCA Grade H4 poles  (75-100)",null,null,null,0]
["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",null,"CCA Grade H4 poles  (100-125)",null,null,null,0]
["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.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]
[null,null,null,null,null,null,0]
["L.4",null,"CCA Grade H4 poles  (125-150)",null,null,null,0]
["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,"ANCHORS",null,null,null,0]
["L.5.1",null,"Duckbill type - minimum Model 88 - installed as per manufactures specifications","no",1]
["L.5.2",null,"Manta Ray type - minimum MR2 type - installed as per manufactures specifications.","no",1]
["L.5.3",null,"Tyre type - minimum vehicle tyre size 14\" installed and secured at minimum depth of 800mm","no",1]
["L.5.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.6",null,"ACCESSORIES"]
["L.6.1",null,"M10 Wire tensioners with shackles on both ends","no",1]
["L.6.2",null,"M12 Wire tensioners with shackles on both ends","no",1]
["L.6.3",null,"2.5 x 25mm Nail staples","no",1]
["L.6.4",null,"2.5 x 30mm Nail staples","no",1]
["L.6.5",null,"2.5 x 40mm Nail staples","no",1]
["L.6.6",null,"3 x 30mm Nail staples","no",1]
["L.6.7",null,"3.5 x 30mm Nail staples","no",1]
["L.6.8",null,"4 x 30mm Nail staples","no",1]
["L.6.9",null,"2.5 x 40mm Nail staples","no",1]
["L.6.10",null,"3 x 40mm Nail staples","no",1]
["L.6.11",null,"3.5 x 40mm Nail staples","no",1]
["L.6.12",null,"4 x 40mm Nail staples","no",1]
["L.6.13",null,"25mm Flat head ceiling nails","no",1]
["L.6.14",null,"4,0mm Roof Wire for anchor poles","m",1]
["L.6.15",null,"2,24mm high tensile Steel wire for netting","no",1]
["L.6.16",null,"2,0mm Galvanized wire clamps for net wire (fabricate from wire)","no",1]
["L.6.17",null,"40mm Wire Staples","no",1]
["L.6.18",null,"32mm Wire staples","no",1]
["L.6.19",null,"M12 x 1 000mm long galvanized round bar","no",1]
["L.6.20",null,"M10 x 1 000mm Long galvanized round bar","no",1]
["L.6.21",null,"M12 galvanized washers","no",1]
["L.6.22",null,"M10 Galvanized washers","no",1]
["L.6.23",null,"M12 Galvanized nuts","no",1]
["L.6.24",null,"M10 Galvanized nuts","no",1]
["L.6.25",null,"M10 x 2 000mm Galvanized anchors made from round bar ","no",1]
["L.6.26",null,"1500mm Long Y-standard Iron fencing poles ","no",1]
["L.6.27",null,"150,000 Galv hogrings(15 boxes)","no",1]
["L.6.28",null,"3000 x 5 mm Aluminium Ferrules","no",1]
["L.6.29",null,"2000 x 6 mm Aluminium Ferrules","no",1]
["L.6.30",null,"7 x 1.6 mm Galvanised staywire","m",1]
["L.6.31",null,"7 x 2 mm Galvanised staywire","m",1]
["L.6.32",null,"7 x 2.65 mm Galvanised staywire","m",1]
["L.6.33",null,"7 x 3.25 mm Galvanised staywire","m",1]
["L.6.34",null,"7 x 4 mm Galvanised staywire","m",1]
["L.6.35",null,"M10 Galv. Straining bolts","no",1]
["L.6.36",null,"M12 Turnbuckle & Eye Hook","no",1]
["L.6.37",null,"M16 Turnbuckle & Eye Hook","no",1]
["L.6.38",null,"1500m x 12mm rust treated anchor steel","no",1]
["L.6.39",null,"vine grips","no",1]
["L.6.40",null,"Double wrap grip","no",1]
["L.6.41",null,"2,24mm high tension steel wire.Full galvanised","m",1]
["L.6.42",null,"10mm Crosby Clamps","no",1]
["L.6.43",null,"Ref 888 mesh for ground anchor blocks","m2",1]
["L.6.44",null,"25MPa concrete for anchoring ","m3",1]
["L.6.45",null,"500x500x150mm depth concrete shutter for shuttering anchor blocks","no",1]
[]
["L.7",null,"Shadenet Sums"]
["L.7.1",null,"Allow for a provisional sum for other Tunnels related works not specified above, instructed by the engineer for purchase of materials and installation.","Prov Sum",1,250000,"rate only"]
["L.7.2",null,"Profit over above","%",{"$f":"F99","v":250000}]
["L.7.3",null,"Allow for a provisional sum for other Tunnels related materials supply and delivery as instructed by the engineer ","Prov Sum",1,100000,"rate only"]
["L.7.4",null,"Profit over above","%",{"$f":"F101","v":100000}]
[]
[null,null,"TOTAL SECTION \"L\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G96)","v":0}]

{"sheet":"Tunnels","index":13,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,2,52,4],[52,5,52,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)","PC Sum",1,60000,"rate only"]
["M.1.2",null,"Mark up on other tunnels. ","%",{"$f":"F6","v":60000}]
["M.1.3",null,"30 m x 10 m x 4 m (Minimum)","PC Sum",1,120000,"rate only"]
["M.1.4",null,"Mark up on other tunnels. ","%",{"$f":"F8","v":120000}]
[]
["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.3",null,"Polyethylene Water Tank"]
[null,null,"Supply, erect and anchored elevated polyethylene water tank onto tank stand (3,6 & 9m high):"]
["M.3.1",null,"5 000 Litres LDPE Tank","sum",1]
["M.3.2",null,"10 000 Litres LDPE Tank","sum",1]
["M.3.3",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.4",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.4.1",null,"3 meter high for 10 000 litres","sum",1]
["M.4.2",null,"6 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.4.3",null,"3 meter high for 5 000 litres","sum",1]
["M.4.4",null,"6 meter high for 5 000 litres","sum",1]
[]
["M.5",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.5.1",null,"200 000 to 300 000 Litres capacity","PC Sum",1,300000,"rate only"]
["M.5.2",null,"300 001 to 500 000 Litres capacity","PC Sum",1,500000,"rate only"]
["M.5.3",null,"500 001 to 750 000 Litres capacity","PC Sum",1,800000,"rate only"]
["M.5.4",null,"Profit over above (limited to 20 %)","%",{"$f":"SUM(F37:F39)","v":1600000}]
[]
["M.6",null,"HDPE Dam Linning"]
[null,null,"Supply, deliver, install and commission HDPE Dam Linnings. Including on-site plastic welding."]
["M.6.1",null,"HDPE Dam Linning 1,5mm","m²",1]
["M.6.2",null,"HDPE Dam Linning 2,0mm","m²",1]
[]
["M.7",null,"Tunnels Sums"]
["M.7.1",null,"Allow for a provisional sum for other Tunnels related works not specified above, instructed by the engineer for purchase of materials and installation.","Prov Sum",1,25000,"rate only"]
["M.7.2",null,"Profit over above limited to 20%","%",{"$f":"F48","v":25000}]
["M.7.3",null,"Allow for a provisional sum for other Tunnels related materials supply and delivery as instructed by the engineer ","Prov Sum",1,100000,"rate only"]
["M.7.4",null,"Profit over above","%",{"$f":"F50","v":100000}]
[]
[null,null,"TOTAL SECTION \"M\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G3:G52)","v":0}]

{"sheet":"Building","index":14,"n_rows":279,"n_cols":7,"rows_kept":279,"cut":false,"hidden":false,"merged":[[278,2,278,4],[278,5,278,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]
[null,null,null,null,null,null,{"$f":"F12*E12","v":0}]
["P.2",null,"EARTHWORKS ",null,null,null,0]
[null,null,"Excavation in earth not exceeding 1,5m deep:",null,null,null,0]
["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:",null,null,null,0]
["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:",null,null,null,0]
["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]
[null,null,null,null,null,null,0]
[null,null,"Keeping excavations free of water:",null,null,null,0]
["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]
[null,null,null,null,null,null,0]
["P.3",null,"SOIL POISONING",null,null,null,0]
[null,null,"Vegetation herbicide and anti-termite soil poisoning applied by a Registered Pest Control company utilizing complaint chemicals",null,null,null,0]
["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.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]
[null,null,null,null,null,null,0]
["P.6",null,"ROUGH FORMWORK ",null,null,null,0]
["P.6.1",null,"Permanent Formwork:",null,null,null,0]
["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.7",null,"SMOOTH FORMWORK"]
[null,null,"Permanent Formwork:"]
["P.7.1",null,"To sides, edging, risers, ends and reveals, not exceeding 300mm height","m2",1]
["P.7.2",null,"To sides, edging, risers, ends and reveals, not exceeding 600mm height","m2",1]
["P.7.3",null,"To sides, edging, risers, ends and reveals, not exceeding 1500mm height","m2",1]
["P.7.4",null,"Circular columns shuttering","m2",1]
["P.7.5",null,"Suspended slabs shuttering","m2",1]
[null,null,"Temporary Formwork:"]
["P.7.6",null,"To sides, edging, risers, ends and reveals, not exceeding 300mm height","m2",1]
["P.7.7",null,"To sides, edging, risers, ends and reveals, not exceeding 600mm height","m2",1]
["P.7.8",null,"To sides, edging, risers, ends and reveals, not exceeding 1500mm height","m2",1]
["P.7.9",null,"Circular columns shuttering","m2",1]
["P.7.10",null,"Suspended slabs shuttering","m2",1]
["P.7.11",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.","kg",1]
[null,null,"Fabric reinforcement:"]
["P.9.2",null,"REF. 193 fabric reinforcement in concrete surface beds, raft slabs etc.","m2",1]
["P.9.3",null,"REF. 245 fabric reinforcement in concrete surface beds, raft slabs etc.","m2",1]
["P.9.4",null,"REF. 395 fabric reinforcement in concrete surface beds, raft slabs etc.","m2",1]
["P.9.5",null,"REF. 617 fabric reinforcement in concrete surface beds, raft slabs etc.","m2",1]
["P.9.6",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," Supply, Deliver, and Construct Brickwork 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.4",null,"FBS: Face Brick outside and NFP inside, 220mm wide wall, complete with mortar, ties, pointed outside and inside, etc.","m2",1]
["P.10.5",null,"FBA: Face Brick outside and NFP inside, 220mm wide wall, complete with mortar, ties, pointed outside and inside, etc.","m2",1]
["P.10.6",null,"FBX: Face Brick outside and NFP inside, 220mm wide wall, complete with mortar, ties, pointed outside and inside, etc.","m2",1]
["P.10.7",null,"NFP: NFP outside and NFP inside, 220mm wide wall, complete with mortar, ties, pointed outside and inside, etc.","m2",1]
["P.10.8",null,"NFX: NFX outside and NFX inside, 220mm wide wall, complete with mortar, ties, pointed outside and inside, etc.","m2",1]
["P.10.9",null,"FBS: Facebrick outside and FBS inside, 220mm wide wall, complete with mortar, ties, pointed outside and inside, etc.","m2",1]
["P.10.10",null,"NFP: 110mm wide wall, complete with mortar, ties, pointed outside and inside, etc.","m2",1]
[null,null,null,null,null,null,{"$f":"F114*E114","v":0}]
["P.11",null,"BRICKFORCE",null,null,null,0]
["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.12",null,"ROOF TIES (Bracing Strap)",null,null,null,0]
["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]
[null,null,null,null,null,null,{"$f":"F126*E126","v":0}]
["P.14",null,"LINTELS",null,null,null,0]
["P.14.1",null,"Pre-Cast Concrete lintols 75 x 110",null,null,null,0]
["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]
[null,null,null,null,null,null,0]
["P.14.2",null,"Pre-Cast Concrete lintels 75 x 150mm",null,null,null,0]
["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.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,"IBR profiled metal sheeting with the following finishes, screws and all accessories, supply and install complete, fixed to roof / clading members."]
[null,null,"Galvanised IBR "]
["P.17.1",null,"0.4 mm","m²",1]
["P.17.2",null,"0.47 mm","m²",1]
["P.17.3",null,"0.5 mm","m²",1]
["P.17.4",null,"0.58 mm","m²",1]
[null,null,"IBR - Chromadek",null,null,null,{"$f":"F159*E159","v":0}]
["P.17.5",null,"0.4 mm","m²",1]
["P.17.6",null,"0.47 mm","m²",1]
["P.17.7",null,"0.5 mm","m²",1]
["P.17.8",null,"0.58 mm","m²",1]
[null,null,"IBR - Zincalume"]
["P.17.9",null,"0.4 mm","m²",1]
["P.17.10",null,"0.47 mm","m²",1]
["P.17.11",null,"0.5 mm","m²",1]
["P.17.12",null,"0.58 mm","m²",1]
[]
["P.18",null,"Steelworks for the supply, fabricate, surface preparation, shop priming, delivery to site & installation of a complete steel structure. Including all necessary columns, frame members, cleats, brackets, gussets, packs, nuts, bolts, washers, roof screws, roof washers, ridging, side flashing, insulation, etc. Cut off losses not included for pricing. Actual work constructed quantities considered"]
["P.18.1",null,"H Sections","kg",1]
["P.18.2",null,"IPE sections","kg",1]
["P.18.3",null,"Flat bars","kg",1]
["P.18.4",null,"Angle Irons","kg",1]
["P.18.5",null,"Round Bars","kg",1]
["P.18.6",null,"Square Bars","kg",1]
["P.18.7",null,"Channel","kg",1]
["P.18.8",null,"Lipped Channel for roof purlins","kg",1]
["P.18.9",null,"Round Tubes","kg",1]
["P.18.10",null,"Square Tubes","kg",1]
["P.18.11",null,"Rectangular Tube","kg",1]
["P.18.12",null,"Expanded Metal sheet for security","kg",1]
["P.18.13",null,"Welded Mesh","kg",1]
["P.18.14",null,"Plates","kg",1]
["P.18.15",null,"Threated Bars","kg",1]
["P.18.16",null,"Bolt and nut and washers","kg",1]
["P.18.17",null,"Cold formed sections","kg",1]
["P.19",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.19.1",null,"\"Alububble\"  or equal approved insulation","m2",1]
[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 Structural works including roofing and side cladding, roller doors, insulation, roof ventilators, steel members treated and painted, IBR side wall cladding, etc. Engineers Certificate to be included or boiler maker certifiacte if the Client Engineer's specifications are followed,","Prov sum",1,600000,"rate only"]
["P.19.2",null,"Profit Over Item P.19.1","%",{"$f":"F193","v":600000}]
[null,null,null,null,null,null,0]
["P.20",null,"DOORS",null,null,null,{"$f":"F196*E196","v":0}]
[null,null,"Supply, deliver and install the following doors complete.",null,null,null,0]
["P.20.1",null,"Frame and ledge open back solid Meranti door, size 813 x 2032mm. (Exterior use)","no",1]
["P.20.2",null,"Light Duty Hardboard door, size 813 x 2032mm. (Interior use)","no",1]
[null,null,null,null,null,null,0]
["P.21",null,"METALWORK",null,null,null,0]
[null,null,"STEEL BURGLAR GATES TO DOORS",null,null,null,0]
[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:",null,null,null,0]
["P.21.1",null,"Security gate size 900 x 2050mm high","no",1]
["P.21.2",null,"Security double gate size 1800 x 2050mm high.","no",1]
[]
["P.22",null,"PLASTERING"]
["P.22.1",null,"SCREED: 30mm thick, Untinted granolithic, on concrete.","m2",1]
["P.22.2",null,"SKIRTING: 75mm high coved granolithic skirting","m",1]
["P.22.3",null,"INTERNAL PLASTER: 10mm thick, 1:4 sand cement mixture","m2",1]
[]
["P.23",null,"PAINTWORK"]
["P.23.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.23.2",null,"Prepare and apply two coats carbolenium on exposed timber.","m2",1]
["P.23.3",null,"Prepare and apply two coats pure acrylic roof paint on fascias and barge boards.","m2",1]
["P.23.4",null,"Prepare and apply two coats enamel paint on windows frames, putty, door frames, etc.","m2",1]
["P.23.5",null,"Prepare and apply two coats of wall primer paint on plastered walls, and ceiling boards","m2",1]
["P.23.6",null,"Prepare and apply two coats of internal washable paint on plastered walls.","m2",1]
["P.23.7",null,"Prepare and apply two coats of external weather proof washable paint on plastered walls.","m2",1]
[]
["P.24",null,"ROLLER DOORS"]
["P.24.1",null,"Industrial Roller door, Chain operated, 2400 x 3000mm high galvanized with locking mechanism","no",1]
["P.24.2",null,"Industrial Sliding Door on track and guide, 2400 x 3000mm high galvanized with locking mechanism","no",1]
["P.24.3",null,"Standard Garage roll up door 2400 x 2000mm, with a pedestrian lock mechanism","no",1]
[]
["P.25",null,"STEEL WINDOW FRAMES"]
["P.25.1",null,"Supply, deliver and install the following complete steel window frames and glazing."]
["P.25.2",null,"Window frame NC2 (1022 x 949 mm)","no",1]
["P.25.3",null,"Window frame NC4F (1511 x 949 mm)","no",1]
["P.25.4",null,"Window frame C1H (533 x 949 mm)","no",1]
["P.25.5",null,"Window frame NE1 (533 x 359 mm)","no",1]
["P.25.6",null,"Window frame NE11 (1975 x 629 mm)","no",1]
["P.25.7",null,"Glazing including putty, 3 - 4mm clear glass","m2",1]
["P.25.8",null,"Glazing including putty, 4mm frosted glass","m2",1]
[]
["P.26",null,"STRONG ROOM DOOR"]
["P.26.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]
[]
["P.27",null,"PRESSED STEEL DOOR FRAMES "]
[null,null,"Supply, deliver & install the following mild steel (1,2mm thick) door frames  complete with standard butt hinges and factory applied primer:"]
["P.27.1",null,"Double rebated frame suitable for half brick (110mm) walls for door 813 x 2032mm high ","no",1]
["P.27.2",null,"Double rebated frame suitable for one brick (220mm) walls for door 813 x 2032mm high ","no",1]
["P.27.3",null,"Double rebated frame suitable for one brick (220mm) walls for door 1511 x 2032mm high ","no",1]
["P.27.4",null,"Combination Door and Frame, Double Door, 1511 x 2 032mm high","no",1]
["P.27.5",null,"Combination Door and Frame, Single Door, 813 x 2 032mm high","no",1]
[null,null,null,null,null,null,0]
["P.28",null,"LOCKS ",null,null,null,0]
["P.28.1",null,"Supply 50 mm \"Viro\" Padlocks and Keys (or equal approved )","no",1]
["P.28.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.28.3",null,"Four- lever double cylinder lockset, with Gower Handel code CZ682-05 SC or similar complete with striking plate.","no",1]
["P.28.4",null,"DMWS-SS-008 or similar Bathroom /WC small case deadlock","no",1]
["P.28.5",null,"Aluminuim door stop with rubber insert","no",1]
[]
["P.29",null,"SIGNAGE PLATES"]
["P.29.1",null,"Wheelchair, pictogram Engraved on 152 x 152 mm stainless steel plate.","no",1]
["P.29.2",null,"Female, pictogram Engraved on 152 x 152 mm stainless steel plate. ","no",1]
["P.29.3",null,"Male, pictogram  Engraved on 152 x 152 mm stainless steel plate. ","no",1]
[null,null,null,null,null,null,{"$f":"F258*E258","v":0}]
["P.30",null,"HAND RAILS IN TOILETS",null,null,null,0]
["P.30.1",null,"Mark up on Grab Rails as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,5000,"rate only"]
["P.30.2",null,"Mark up on Grab rails. ","%",{"$f":"F260","v":5000}]
["P.30.3",null,"Extra over Item P.30.2: Deliver, and Install Grab Rails.","no",1]
[null,null,null,null,null,null,0]
["P.31",null,"FIRE SERVICES",null,null,null,0]
["P.31.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.31.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]
[null,null,null,null,null,null,0]
["P.32",null,"FIELD SANITATION UNITS",null,null,null,0]
[null,null,"Earth-, Concrete-, and Building-works are measured elsewhere.",null,null,null,0]
["P.32.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.32.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]
[]
["P.33",null,"Building Sums"]
["P.33.1",null,"Allow for a provisional sum for other building related works not specified above, instructed by the engineer for purchase of materials and installation.","Prov Sum",1,50000,"rate only"]
["P.33.2",null,"Profit over above","%",{"$f":"F274","v":50000}]
["P.33.3",null,"Allow for a provisional sum for other building related materials supply and delivery as instructed by the engineer ","Prov Sum",1,100000,"rate only"]
["P.33.4",null,"Profit over above","%",{"$f":"F276","v":100000}]
[]
[null,null,"TOTAL SECTION \"P\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G271)","v":0}]

{"sheet":"Electricals & Plumbing","index":15,"n_rows":134,"n_cols":7,"rows_kept":134,"cut":false,"hidden":false,"merged":[[133,2,133,4],[133,5,133,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION R: ELECTRICAL & PLUMBING"]
[]
["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]
[null,null,null,null,null,null,{"$f":"F7*E7","v":0}]
["R.2",null,"ELECTRICAL - TRENCHING & EARTHWORKS",null,null,null,0]
[null,null,"Trenching (450mm width by 500mm depth for LV Cables) Danger tape: Orange/Yellow PVC material-300mm above cable.",null,null,null,0]
["R.2.1",null,"Hand pickable soil (soft soil)","m³",1]
["R.2.2",null,"Machine excavation (soft rock)","m³",1]
[null,null,null,null,null,null,0]
["R.3",null,"ELECTRICAL CABLES",null,null,null,0]
[null,null,"Supply, deliver, install, and test SABS approved copper cables. Inclusive of all terminations and glands.",null,null,null,0]
["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]
[null,null,"Bare copper Earth wire  (SANS 1411)"]
["R.3.11",null,"a) 1.5 mm2","m",1]
["R.3.12",null,"b) 2.5 mm2","m",1]
["R.3.13",null,"c) 4 mm2","m",1]
[]
["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":"F37","v":10000}]
["R.5.3",null,"Extra over Item R.5.2: Deliver, Install, and test other light fittings.","no",1]
[null,null,null,null,null,null,0]
["R.6",null,"ENCLOSURES",null,null,null,0]
[null,null,"Supply, deliver, install, and test the following Enclosures complete with fittings, etc.",null,null,null,0]
["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.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]
[null,null,"Supply, deliver, and install, Mild Steel, Single Door, Lockable Enclosure, IP66, Out door, Powder coating, Including Galvanized Mounting plate.",null,null,null,0]
["R.6.6",null,"a) 200 H x 200 W x 155 D mm","no",1]
["R.6.7",null,"b) 300 H x 250 W x 155 D mm","no",1]
["R.6.8",null,"c) 350 H x 250 W x 155 D mm","no",1]
[]
["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":"F53","v":10000}]
["R.7.3",null,"Extra over Item R.7.2: Deliver, and Install other Enclosures.","no",1]
[]
["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]
[]
["R.9",null,"CONDUIT PIPES"]
[null,null,"Supply, deliver, and install the following Conduit pipes, inclusive of all couplings, adaptors, bends, etc."]
["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,{"$f":"F79*E79","v":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,"Supply , deliver and install early warning security system","PC Sum",1,25000,"rate only"]
["R.10.3",null,"Mark up on other Electrical Material. ","%",{"$f":"SUM(F81:F82)","v":35000}]
["R.10.4",null,"Extra over Item R.10.2: Deliver, and Install other Electrical Material.","no",1]
[]
[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":"F93","v":10000}]
["R.11.8",null,"Extra over Item R.11.8: Deliver, and Install other Bathroom Accessories.","no",1]
["R.11.9",null,"Sewage pipe, 50mm PVC, including all fittings.","m",1]
["R.11.10",null,"Sewage pipe, 110mm PVC, including all fittings.","m",1]
["R.11.11",null,"Mark up on other sewer fittings as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,3000,"rate only"]
["R.11.12",null,"Mark up on other sewer fittings. ","%",{"$f":"F98","v":3000}]
["R.11.13",null,"Extra over Item R.12.4: Deliver, and Install other Sewer fittings.","no",1]
[null,null,null,null,null,null,0]
["R.12",null,"Copper pipes: Supply, deliver, install (Chased into brickwalls), and testing, including joints, bends, sockets, and etc.",null,null,null,0]
["R.12.1",null,"Copper pipe 15mm","m",1]
["R.12.2",null,"Copper pipe 22mm","m",1]
["R.12.3",null,"Copper pipe Joints, Bends, Tees, etc. for 15mm pipe","no",1]
["R.12.4",null,"Copper pipe Joints, Bends, Tees, etc. for 20mm pipe","no",1]
[null,null,null,null,null,null,0]
["R.13",null,"OTHER PIPES AND FITTINGS",null,null,null,0]
["R.13.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.13.2",null,"Mark up on other Pipes and Fittings. ","%",{"$f":"F109","v":10000}]
["R.13.3",null,"Extra over Item R.14.2: Deliver, and Install other Pipes and Fittings.","no",1]
[null,null,null,null,null,null,0]
["R.14",null,"VALVES",null,null,null,0]
[null,null,"Supply, deliver, install, and test the following valves.",null,null,null,0]
["R.14.1",null,"Pressure control valve for 600kPA, on 15 or 20mm pipes","no",1]
["R.14.2",null,"15mm Ball-o-stop valve.","no",1]
["R.14.3",null,"22mm Non Return valve.","no",1]
[null,null,null,null,null,null,0]
["R.15",null,"PROVISIONAL SUMS",null,null,null,0]
["R.15.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":"E121","v":100000},"rate only"]
["R.15.2",null,"Profit over above","%",100000]
["R.15.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":"E123","v":250000},"rate only"]
["R.15.4",null,"Profit over above","%",250000]
["R.15.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":"E125","v":500000},"rate only"]
["R.15.6",null,"Profit over above","%",500000]
["R.15.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","Prov Sum",1,1000000,"rate only"]
["R.15.8",null,"Profit over above","%",{"$f":"F126","v":1000000}]
["R.15.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":"E129","v":60000},"rate only"]
["R.15.10",null,"Profit over above","%",60000]
[null,null,null,null,null,null,{"$f":"F130*E130","v":0}]
["R.16",null,"TESTING",null,null,null,0]
["R.16.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,"TOTAL SECTION \"R\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G132)","v":0}]

{"sheet":"Energy","index":16,"n_rows":54,"n_cols":7,"rows_kept":54,"cut":false,"hidden":false,"merged":[[53,2,53,4],[53,5,53,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION S : POWER GENERATION EQUIPMNET"]
[]
[]
["S.1",null,"SOLAR SYSTEM ",null,null,null,{"$f":"F5*E5","v":0}]
[null,null,"Supply, deliver, install, and test hybrid solar systems complete with all panels,cables, connectors, Junction boxes, surge protectors and Circuit breakers,mppt chargers etc",null,null,null,0]
["S.1.1",null,"a) 5kVA","PC sum",1,100000,"rate only"]
["S.1.2",null,"a) 8kVA","PC sum",1,150000,"rate only"]
["S.1.3",null,"a) 10kVA","PC sum",1,200000,"rate only"]
["S.1.4",null,"Mark up on other Solar system. ","%",{"$f":"SUM(F7:F9)","v":450000}]
[]
["S.2",null,"SOLAR (PV) MOUNTING SYSTEMS",null,null,null,0]
[null,null,"Supply, deliver, install a complete Solar (PV) mounting system including all rails, brackets, fasteners, and steel support structure. (Galvanised or Aluminium)",null,null,null,0]
[null,null,"Roof Top mounting system for PV Solar panels.",null,null,null,0]
["S.2.1",null,"a) four (4) PV solar panel.","Sum",1]
["S.2.2",null,"b) Set of Eight (8) PV solar panels.","Sum",1]
["S.2.3",null,"c) Set of twelve (12) PV solar panels.","Sum",1]
["S.2.4",null,"d) Set of Sixteen (16) PV solar panels.","Sum",1]
[null,null,"Ground mounting structure for PV Solar panels."]
["S.2.5",null,"a) four (4) PV solar panel.","Sum",1]
["S.2.6",null,"b) Set of Eight (8) PV solar panels.","Sum",1]
["S.2.7",null,"c) Set of twelve (12) PV solar panels.","Sum",1]
["S.2.8",null,"d) Set of Sixteen (16) PV solar panels.","Sum",1]
[null,null,null,null,null,null,0]
["S.3",null,"Batteries",null,null,null,0]
["S.3.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.2",null,"Mark up on Item S.3.7.1","%",{"$f":"F26","v":60000}]
[null,null,null,null,null,null,0]
["S.4",null,"Other Solar Equipment",null,null,null,0]
["S.4.1",null,"Mark up on other Solar Equipment set as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,16000,"rate only"]
["S.4.2",null,"Mark up on other Solar Equipment. ","%",{"$f":"F30","v":16000}]
[null,null,null,null,null,null,0]
["S.5",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":"F34*E34","v":0}]
["S.5.1",null,"5kVA","sum",1]
["S.5.2",null,"8kVA","sum",1]
["S.5.3",null,"15kVA and above","sum",1,100000,"rate only"]
["S.5.4",null,"Mark up on other Fuel Generator set as specified by the Engineer (3 Quotations from reputable suppliers)","%",{"$f":"F37","v":100000}]
["S.5.5",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]
[null,null,"Service of Generators",null,null,null,0]
["S.5.6",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.5.7",null,"Mark up on the Service and repair of Generators. ","%",{"$f":"F42","v":10000}]
[null,null,null,null,null,null,0]
["S.6",null,"POWER TRANSFORMERS",null,null,null,0]
[null,null,"Supply, installation, registration and commission of new transformer including 12m treated poles",null,null,null,0]
["S.6.1",null,"25kVA","PC sum",1,100000,"rate only"]
["S.6.2",null,"Mark up on above","%",{"$f":"F47","v":100000}]
[]
["S.7",null,"GRID POWER SUPPLY",null,null,null,0]
["S.7.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.7.2",null,"Mark up on Item S.6.1. ","%",{"$f":"F51","v":200000}]
[]
[null,null,"TOTAL SECTION \"S\" CARRIED FORWARD TO SUMMARY",null,null,{"$f":"SUM(G4:G53)","v":0}]

{"sheet":"Pumps & Controllers","index":17,"n_rows":215,"n_cols":7,"rows_kept":215,"cut":false,"hidden":false,"merged":[[214,2,214,4],[214,5,214,6]]}
["No.","Clause","DESCRIPTION","Unit","Qty","Rate","Amount"]
[null,null,"SECTION I : PUMPS & MOTORS,CONTROLS & CABLES"]
[null,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",null,"Single phase, Multi stage Submersible Pump & Motor ",null,null,null,{"$f":"F5*E5","v":0}]
["T.1.1",null,"a) 1,1 kW","sum",1]
["T.1.2",null,"b) 1,5 kW","sum",1]
["T.1.3",null,"c) 2,2 kW","sum",1]
[null,null,null,null,null,null,0]
["T.2",null,"Three phase, Single stage Submersible Pump & Motor ",null,null,null,0]
["T.2.1",null,"a) 0,25 kW","sum",1,null,0]
["T.2.2",null,"b) 0,37 kW","sum",1,null,0]
["T.2.3",null,"c) 0,55 kW","sum",1,null,0]
["T.2.4",null,"d) 0,75 kW","sum",1,null,0]
["T.2.5",null,"e) 1,1 kW","sum",1,null,0]
["T.2.6",null,"f) 1,5 kW","sum",1,null,0]
["T.2.7",null,"g) 2,2 kW","sum",1,null,0]
[null,null,null,null,null,null,0]
["T.3",null,"Three phase, Multi stage Submersible Pump & Motor ",null,null,null,0]
["T.3.1",null,"a) 1,5 kW","sum",1,null,0]
["T.3.2",null,"b) 2,2 kW","sum",1,null,0]
["T.3.3",null,"c) 3 kW","sum",1,null,0]
["T.3.4",null,"d) 3,7 kW","sum",1,null,0]
["T.3.5",null,"e) 4 kW","sum",1,null,0]
["T.3.6",null,"f) 5,5 kW","sum",1,null,0]
["T.3.7",null,"g) 7,5 kW","sum",1,null,0]
["T.3.8",null,"h) 11 kW","sum",1,null,0]
[null,null,null,null,null,null,0]
["T.4",null,"Other Submersible Borehole pump and motor set",null,null,null,0]
["T.4.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.4.2",null,"Mark up on other Submersible pump and motor set. ","%",{"$f":"F30","v":20000},null,0]
["T.4.3",null,"Extra over Item T.1.5.2: Deliver, Install, Testing and Commission a complete submersible pump and motor set.","sum",1]
[null,null,null,null,null,null,0]
["T.5",null,"Flexible borehole pipe",null,null,null,0]
["T.5.1",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 according to the Engineer's instruction","PC sum",1,20000,"rate only"]
["T.5.2",null,"Mark up on Item T.1.6.1.","%",{"$f":"F35","v":20000}]
[null,null,null,null,null,null,0]
["T.6",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]
[null,null,"Base plates epoxy coated (split type) ",null,null,null,0]
["T.6.1",null,"a) 50 mm","no",1,null,0]
["T.6.2",null,"b) 65 mm","no",1,null,0]
["T.6.3",null,"c) 80 mm","no",1,null,0]
[null,null,null,null,null,null,0]
["T.7",null,"Base plates galvanised  ",null,null,null,0]
["T.7.1",null,"a) 50 mm","no",1,null,0]
["T.7.2",null,"b) 65 mm","no",1,null,0]
["T.7.3",null,"c) 80 mm","no",1,null,0]
[null,null,null,null,null,null,0]
["T.8",null,"Lockable Steel Manhole Cover",null,null,null,0]
["T.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.8.2",null,"Mark up on Item T.1.8.1. ","%",{"$f":"F51","v":10000}]
[null,null,null,null,null,null,{"$f":"F53*E53","v":0}]
["T.9",null,"Close coupled centrifugal pump and motor (Three phase, 2 or 4 pole motor)",null,null,null,0]
[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)",null,null,null,0]
["T.9.1",null,"Suction - 50mm; Discharge - 32mm; Impeller - 125mm (Q - 25³/h; H - 23m; P - 2,2kW)","set",1]
["T.9.2",null,"Suction - 50mm; Discharge - 32mm; Impeller - 160mm (Q - 20³/h; H - 35m; P - 4kW)","set",1]
["T.9.3",null,"Suction - 50mm; Discharge - 32mm; Impeller - 200mm (Q - 14³/h; H - 50m; P - 5,5kW)","set",1]
["T.9.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.10",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.10.1",null,"Suction - 50mm; Discharge - 32mm; Impeller - 125mm (Q - 25³/h; H - 23m; P - 2,2kW)","set",1]
[null,null,null,null,null,null,0]
["T.11",null,"Other Close coupled centrifugal pump and motor",null,null,null,0]
["T.11.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.11.2",null,"Mark up on other Close coupled pump and motor set. ","%",{"$f":"F66","v":60000}]
["T.11.3",null,"Extra over Item T.4.2: Deliver, Install, Testing and Commission a complete Close coupled pump and motor set.","set",1]
[null,null,null,null,null,null,0]
["T.12",null,"Centrifugal pump and motor set with base plate and flexible coupling (Three phase, 2 pole motor)",null,null,null,0]
["T.12.1",null,"Suction - 50mm; Discharge - 32mm; Impeller - 200mm (Q - 14³/h; H - 50m; P - 5,5kW)","set",1]
["T.12.2",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.13",null,"Other Centrifugal pump and motor set with base plate and flexible coupling.",null,null,null,0]
["T.13.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.13.2",null,"Mark up on other Centrifugal pump and motor set. ","%",{"$f":"F75","v":60000}]
["T.13.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]
[null,null,null,null,null,null,0]
["T.14",null,"Supply, deliver, install and test the following three phase 2 or 4 pole motors.",null,null,null,0]
["T.14.1",null,"5.5 kW","no",1]
["T.14.2",null,"7.5 kW","no",1]
["T.14.3",null,"11 kW","no",1]
[]
["T.15",null,"Other Electrical motor.",null,null,null,0]
["T.15.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.15.2",null,"Mark up on other Electrical motor. ","%",{"$f":"F85","v":60000}]
["T.15.3",null,"Extra over Item T.10.2: Deliver, Install, Testing and Commission a complete Electrical motor and flexible coupling.","set",1]
[null,null,null,null,null,null,{"$f":"F88*E88","v":0}]
["T.16",null,"ELECTRICAL - GENERAL",null,null,null,0]
["T.16.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.16.2",null,"Electrical Connection Fee (Provisional Sum)","sum",1,50000,"rate only"]
["T.16.3",null,"Handling Cost and profit in respect of Item T.11.2","%",50000]
["T.16.4",null,"Earth Spike (Include Conductor Termination Clamp)","sum",1]
[null,null,null,null,null,null,0]
["T.17",null,"Electrical Motor Control and Starters",null,null,null,0]
[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.",null,null,null,0]
[null,null,"Single Phase Direct on Line",null,null,null,0]
["T.17.1",null,"a) 1,1 kW","sum",1]
["T.17.2",null,"b) 1,5 kW","sum",1]
["T.17.3",null,"c) 2,2 kW","sum",1]
[null,null,null,null,null,null,0]
["T.18",null,"Three Phase Direct on Line"]
["T.18.1",null,"a) 1,1 kW","sum",1]
["T.18.2",null,"b) 1,5 kW","sum",1]
["T.18.3",null,"c) 2,2 kW","sum",1]
[null,null,null,null,null,null,0]
["T.19",null,"Star Delta Starter (Complete with relays & timers)",null,null,null,0]
["T.19.1",null,"a) 3 kW","sum",1]
["T.19.2",null,"b) 3,7 kW","sum",1]
["T.19.3",null,"c) 4 kW","sum",1]
[]
["T.20",null,"Soft Starter"]
["T.20.1",null,"a) 1,5 kW","sum",1]
["T.20.2",null,"b) 2,2 kW","sum",1]
["T.20.3",null,"c) 3 kW","sum",1]
["T.20.4",null,"d) 3,7 kW","sum",1]
["T.20.5",null,"e) 4 kW","sum",1]
[null,null,null,null,null,null,0]
["T.21",null,"Variable Speed Drives (VSDs) ",null,null,null,0]
["T.21.1",null,"a) 1,5 kW","sum",1]
["T.21.2",null,"b) 2,2 kW","sum",1]
["T.21.3",null,"c) 3 kW","sum",1]
["T.21.4",null,"d) 3,7 kW","sum",1]
["T.21.5",null,"e) 4 kW","sum",1]
["T.21.6",null,"f) 5,5 kW","sum",1]
[]
["T.22",null,"Solar-Powered Variable Speed Drives (VSDs)"]
["T.22.1",null,"a) 1,5 kW","sum",1]
["T.22.2",null,"b) 2,2 kW","sum",1]
["T.22.3",null,"c) 3 kW","sum",1]
["T.22.4",null,"d) 3,7 kW","sum",1]
["T.22.5",null,"e) 4 kW","sum",1]
[]
["T.23",null,"Other Electrical Motor Control and Starters",null,null,null,{"$f":"F134*E134","v":0}]
["T.23.1",null,"Mark up on other Electrical motor Control and Starters as specified by the Engineer (3 Quotations from reputable suppliers)","PC Sum",1,90000,"rate only"]
["T.23.2",null,"Mark up on other Electrical motor Control and Starters. ","%",{"$f":"F135","v":90000}]
["T.23.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,null,null,null,null,0]
["T.24",null,"Three Core Cable",null,null,null,0]
[null,null,"Supply, deliver, install and test three core SABS approved copper cables. Inclusive of all terminations and glands.",null,null,null,0]
[null,null,"Three Core Submersible pump cable (SANS 1574)",null,null,null,0]
["T.24.1",null,"a) 1.5 mm2","m",1]
["T.24.2",null,"b) 2.5 mm2","m",1]
["T.24.3",null,"c) 4 mm2","m",1]
["T.24.4",null,"d) 6 mm2","m",1]
["T.24.5",null,"e) 10 mm2","m",1]
["T.24.6",null,"f) 16 mm2","m",1]
[null,null,null,null,null,null,0]
["T.25",null,"Three Core Armoured copper cable  (SANS 1507)",null,null,null,0]
["T.25.1",null,"a) 1.5 mm2","m",1]
["T.25.2",null,"b) 2.5 mm2","m",1]
["T.25.3",null,"c) 4 mm2","m",1]
["T.25.4",null,"d) 6 mm2","m",1]
["T.25.5",null,"e) 10 mm2","m",1]
["T.25.6",null,"f) 16 mm2","m",1]
[null,null,null,null,null,null,0]
["T.26",null,"Three Core Armoured copper cable with Earth continuity Conductor in the armour.  (SANS 1507)",null,null,null,0]
["T.26.1",null,"a) 1.5 mm2","m",1]
["T.26.2",null,"b) 2.5 mm2","m",1]
["T.26.3",null,"c) 4 mm2","m",1]
["T.26.4",null,"d) 6 mm2","m",1]
["T.26.5",null,"e) 10 mm2","m",1]
["T.26.6",null,"f) 16 mm2","m",1]
[null,null,null,null,null,null,0]
["T.27",null,"Four Core Cable",null,null,null,0]
[null,null,"Supply, deliver, install and test four core SABS approved copper cables. Inclusive of all terminations and glands.",null,null,null,0]
[null,null,"Four Core Submersible pump cable (SANS 1574)",null,null,null,0]
["T.27.1",null,"a) 1.5 mm2","m",1]
["T.27.2",null,"b) 2.5 mm2","m",1]
["T.27.3",null,"c) 4 mm2","m",1]
["T.27.4",null,"d) 6 mm2","m",1]
["T.27.5",null,"e) 10 mm2","m",1]
["T.27.6",null,"f) 16 mm2","m",1]
["T.27.7",null,"g) 25 mm2","m",1]
[null,null,null,null,null,null,{"$f":"F175*E175","v":0}]
[null,null,"Four Core Armoured copper cable  (SANS 1507)",null,null,null,0]
["T.27.8",null,"a) 1.5 mm2","m",1]
["T.27.9",null,"b) 2.5 mm2","m",1]
["T.27.10",null,"c) 4 mm2","m",1]
["T.27.11",null,"d) 6 mm2","m",1]
["T.27.12",null,"e) 10 mm2","m",1]
["T.27.13",null,"f) 16 mm2","m",1]
["T.27.14",null,"g) 25 mm2","m",1]
["T.27.15",null,"h) 35 mm2","m",1]
["T.27.16",null,"I) 50 mm2","m",1]
[]
[null,null,"Four Core Armoured copper cable with Earth continuity Conductor in the armour.               (SANS 1507)"]
["T.27.17",null,"a) 1.5 mm2","m",1]
["T.27.18",null,"b) 2.5 mm2","m",1]
["T.27.19",null,"c) 4 mm2","m",1]
["T.27.20",null,"d) 6 mm2","m",1]
["T.27.21",null,"e) 10 mm2","m",1]
["T.27.22",null,"f) 16 mm2","m",1]
["T.27.23",null,"g) 25 mm2","m",1]
["T.27.24",null,"h) 35 mm2","m",1]
["T.27.25",null,"I) 50 mm2","m",1]
[]
["T.28",null,"Supply, deliver, install and test SABS approved copper cables. Inclusive of all terminations and glands."]
[null,null,"Bare copper Earth wire  (SANS 1411)"]
["T.28.1",null,"a) 1.5 mm2","m",1]
["T.28.2",null,"b) 2.5 mm2","m",1]
["T.28.3",null,"c) 4 mm2","m",1]
["T.28.4",null,"d) 6 mm2","m",1]
["T.28.5",null,"e) 10 mm2","m",1]
["T.28.6",null,"f) 16 mm2","m",1]
["T.28.7",null,"g) 25 mm2","m",1]
["T.28.8",null,"h) 35 mm2","m",1]
["T.28.9",null,"I) 50 mm2","m",1]
[null,null,null,null,null,null,0]
["T.29",null,"Other Electrical Cables ",null,null,null,0]
["T.29.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.29.2",null,"Mark up on other Electrical Cables. ","%",{"$f":"F211","v":20000}]
["T.29.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:G214)","v":0}]

{"sheet":"Sheet2","index":18,"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 "]