{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Bill of Quantities","SUMMARY"],"not_rendered":{"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Bill of Quantities","index":0,"n_rows":870,"n_cols":7,"rows_kept":870,"merged":[[0,0,0,4],[1,0,1,4],[1,5,1,6],[2,0,3,0],[2,1,3,1],[2,2,3,2],[2,3,3,3],[2,4,3,4],[2,5,3,5],[2,6,3,6],[70,1,70,5],[71,1,71,5],[132,1,132,5],[133,1,133,5],[176,1,176,5],[177,1,177,5],[205,1,205,5],[267,0,267,5],[268,0,268,5],[302,0,302,5],[346,0,346,5],[347,0,347,5],[383,0,383,5],[415,0,415,5],[420,8,422,9],[474,0,474,5],[475,0,475,5],[535,0,535,5],[585,8,586,9],[608,0,608,5],[609,0,609,5],[623,0,623,5],[666,0,666,5],[733,0,733,5],[734,0,734,5],[791,1,791,5],[792,0,793,0],[792,1,793,1],[792,2,793,2],[792,3,793,3],[792,4,793,4],[792,5,793,5],[792,6,793,6],[830,0,830,5],[831,0,832,0],[831,1,832,1],[831,2,832,2],[831,3,832,3],[831,4,832,4],[831,5,832,5],[831,6,832,6],[869,0,869,5]]}
[{"$f":"SUMMARY!A1","v":"JOHANNESBURG WATER"}]
[{"$f":"SUMMARY!A3","v":"GREATER ORANGE FARM PHASE 3D WATER INFRASTRUCTURE UPGRADE"}]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[]
["A.","SABS 1200A & 1200AB","SCHEDULE A:  PRELIMINARY AND GENERAL"]
[{"$f":"IF(E6=0,\"\",$A$5&COUNTIF($A5:A$6,\"><*\")+1)","v":""}]
[{"$f":"IF(E7=0,\"\",$A$5&COUNTIF($A$6:A6,\"><*\")+1)","v":""},8.3,"FIXED-CHARGE ITEMS"]
[{"$f":"IF(E8=0,\"\",$A$5&COUNTIF($A$6:A7,\"><*\")+1)","v":""}]
["1.1","8.3.1","Contractual requirements (sureties, insurance of the\nWorks and plant, third party or public liability insurance and unemployment insurance to cover his compliance with the requirements of the Workmen's Compensation Act, 1941 (Act NO. 30 of 1941) and any other initial financing obligations of a preliminary and general nature, such as contributions to the CEITB)","Sum",1]
[{"$f":"IF(E10=0,\"\",$A$5&COUNTIF($A$6:A9,\"><*\")+1)","v":""}]
[{"$f":"IF(E11=0,\"\",$A$5&COUNTIF($A$6:A10,\"><*\")+1)","v":""},"8.3.2","PROVISION OF FACILITIES ON SITE:"]
[{"$f":"IF(E12=0,\"\",$A$5&COUNTIF($A$6:A11,\"><*\")+1)","v":""},"8.3.2.1","Facilities for Engineer:"]
[{"$f":"IF(E13=0,\"\",$A$5&COUNTIF($A$6:A12,\"><*\")+1)","v":""}]
["1.2","PSA 8.3.2.1.a","a) Facilities for the Engineer (No:1) and Parking","Sum",1]
[{"$f":"IF(E15=0,\"\",$A$5&COUNTIF($A$6:A14,\"><*\")+1)","v":""}]
[null,null,"b) JW ISD Team (No:1) ","Sum",1]
[{"$f":"IF(E17=0,\"\",$A$5&COUNTIF($A$6:A16,\"><*\")+1)","v":""}]
[null,null,"c) QCO's and CLO Office (No.1)","Sum",1]
[]
[null,null,"d) Boardroom (No:1)","Sum",1]
[{"$f":"IF(E21=0,\"\",$A$5&COUNTIF($A$6:A20,\"><*\")+1)","v":""}]
[null,null,"e) Parking (No.2)","Sum",1]
[{"$f":"IF(E23=0,\"\",$A$5&COUNTIF($A$6:A22,\"><*\")+1)","v":""}]
[null,null,"f) Nameboards (No=2)","Sum",1]
[{"$f":"IF(E25=0,\"\",$A$5&COUNTIF($A$6:A24,\"><*\")+1)","v":""}]
[null,null,"g) Communication","Sum",1]
[]
[null,null,"h) Telephone and Computer facilities for Complaints Handler Team (No.4)","Sum",1]
[]
[null,null,"i) Ablution and latrine facilities","Sum",1]
[{"$f":"IF(E31=0,\"\",$A$5&COUNTIF($A$6:A30,\"><*\")+1)","v":""}]
[1.3,"8.3.2.2","Facilities for the Contractor"]
[{"$f":"IF(E33=0,\"\",$A$5&COUNTIF($A$6:A32,\"><*\")+1)","v":""}]
[null,null,"a) Offices and storage sheds","Sum",1]
[]
[null,null,"b) Workshops",null,1]
[{"$f":"IF(E37=0,\"\",$A$5&COUNTIF($A$6:A34,\"><*\")+1)","v":""}]
[null,null,"c) Ablution and latrine facilities","Sum",1]
[{"$f":"IF(E39=0,\"\",$A$5&COUNTIF($A$6:A38,\"><*\")+1)","v":""}]
[null,null,"d) Tools and equipment","Sum",1]
[{"$f":"IF(E41=0,\"\",$A$5&COUNTIF($A$6:A40,\"><*\")+1)","v":""}]
[null,null,"e) Water supplies, electric power and communications","Sum",1]
[{"$f":"IF(E43=0,\"\",$A$5&COUNTIF($A$6:A42,\"><*\")+1)","v":""}]
[null,null,"f) Dealing with water (SANS 1200A 5.5)","Sum",1]
[{"$f":"IF(E45=0,\"\",$A$5&COUNTIF($A$6:A44,\"><*\")+1)","v":""}]
[null,"PS 7","g) Access (see SANS sub-clause 5.8)","Sum",1]
[]
["1.4",null,"FACILITIES FOR SMME Fixed Charged Items"]
[]
[null,null,"a) Establishment of storage and Facilities for the SMMEs","Sum",1]
[]
[null,null,"b) Tools and equipment","Sum",1]
[]
[null,null,"c) Other Fixed related obligations","Sum",1]
[]
[null,null,"d) Removal of Facilities","Sum",1]
[{"$f":"IF(E57=0,\"\",$A$5&COUNTIF($A$6:A54,\"><*\")+1)","v":""}]
["1.5","PSA 8.3.5.2","OHS Act Obligations (Compilation of OHSAct file)","Sum",1]
[{"$f":"IF(E59=0,\"\",$A$5&COUNTIF($A$6:A58,\"><*\")+1)","v":""}]
["1.6","PSA 8.3.5.3","EMP Obligations (Compilation of environmental file)","Sum",1]
[]
["1.8","PSA 8.3.5.3","Issuing of notices to Customers","Sum",1]
[]
["1.8","8.3.4","Removal of site Establishment","Sum",1]
[{"$f":"IF(E65=0,\"\",$A$5&COUNTIF($A$6:A64,\"><*\")+1)","v":""}]
["1.9",8.4,"TIME RELATED ITEMS"]
[{"$f":"IF(E67=0,\"\",$A$5&COUNTIF($A$6:A66,\"><*\")+1)","v":""}]
["1.10","8.4.1","Contractual requirements","Month",21]
[{"$f":"IF(E69=0,\"\",$A$5&COUNTIF($A$6:A68,\"><*\")+1)","v":""}]
["1.11","8.4.2","Contractor's Supervision for the duration of construction","Month",21]
[{"$f":"IF(E71=0,\"\",$A$2&COUNTIF($A$3:A70,\"><*\")+1)","v":""},"TOTAL CARRIED FORWARD "]
[{"$f":"IF(E72=0,\"\",$A$2&COUNTIF($A$3:A71,\"><*\")+1)","v":""},"TOTAL BROUGHT FORWARD"]
["1.12","8.4.2.1","Facilities for Engineer:"]
[{"$f":"IF(E74=0,\"\",$A$5&COUNTIF($A$6:A73,\"><*\")+1)","v":""}]
[{"$f":"IF(E75=0,\"\",$A$5&COUNTIF($A$6:A74,\"><*\")+1)","v":"A.12"},null,"a) Facilities for the Engineer (No:1) and Parking ","Month",21]
[{"$f":"IF(E76=0,\"\",$A$5&COUNTIF($A$6:A75,\"><*\")+1)","v":""}]
[null,null,"c) JW ISD Team (No:1) ","Month",21]
[]
[null,null,"d) QCO's and CLO Office (No.1)","Month",21]
[]
[{"$f":"IF(E81=0,\"\",$A$5&COUNTIF($A$6:A79,\"><*\")+1)","v":"A.13"},null,"e) Boardroom (No:1)","Month",21]
[{"$f":"IF(E82=0,\"\",$A$5&COUNTIF($A$6:A81,\"><*\")+1)","v":""}]
[{"$f":"IF(E83=0,\"\",$A$5&COUNTIF($A$6:A82,\"><*\")+1)","v":"A.14"},null,"f) Parking (No.2)","Month",21]
[{"$f":"IF(E84=0,\"\",$A$5&COUNTIF($A$6:A83,\"><*\")+1)","v":""}]
[{"$f":"IF(E85=0,\"\",$A$5&COUNTIF($A$6:A84,\"><*\")+1)","v":"A.15"},null,"g) Nameboards (No=2)","Month",21]
[{"$f":"IF(E86=0,\"\",$A$5&COUNTIF($A$6:A85,\"><*\")+1)","v":""}]
[null,null,"h) Communication","Month",21]
[]
[null,null,"h) Telephone and Computer facilities for Complaints Handler Team (No.4)","Month",21]
[]
[null,null,"i) Ablution and latrine facilities","Month",21]
[]
[]
["1.13","8.4.2.2","Facilities for the Contractor:"]
[null,"8.4.4","Contractor's head office overhead costs for the duration of the Contract","Month",21]
[]
[{"$f":"IF(E97=0,\"\",$A$5&COUNTIF($A$6:A96,\"><*\")+1)","v":"A.17"},null,"a) Offices and storage sheds","Month",21]
[{"$f":"IF(E98=0,\"\",$A$5&COUNTIF($A$6:A97,\"><*\")+1)","v":""}]
[{"$f":"IF(E99=0,\"\",$A$5&COUNTIF($A$6:A98,\"><*\")+1)","v":"A.18"},null,"b) Ablution and latrine facilities","Month",21]
[{"$f":"IF(E100=0,\"\",$A$5&COUNTIF($A$6:A99,\"><*\")+1)","v":""}]
[{"$f":"IF(E101=0,\"\",$A$5&COUNTIF($A$6:A100,\"><*\")+1)","v":"A.19"},null,"c) Tools and equipment","Month",21]
[{"$f":"IF(E102=0,\"\",$A$5&COUNTIF($A$6:A101,\"><*\")+1)","v":""}]
[{"$f":"IF(E103=0,\"\",$A$5&COUNTIF($A$6:A102,\"><*\")+1)","v":"A.20"},null,"d) Water supplies, electric power and communications","Month",21]
[{"$f":"IF(E104=0,\"\",$A$5&COUNTIF($A$6:A103,\"><*\")+1)","v":""}]
[{"$f":"IF(E105=0,\"\",$A$5&COUNTIF($A$6:A104,\"><*\")+1)","v":"A.21"},null,"e) Dealing with water (SANS 1200A 5.5)","Month",21]
[{"$f":"IF(E106=0,\"\",$A$5&COUNTIF($A$6:A105,\"><*\")+1)","v":""}]
[{"$f":"IF(E107=0,\"\",$A$5&COUNTIF($A$6:A106,\"><*\")+1)","v":"A.22"},null,"f) Access (see sub-clause 5.8)","Month",21]
[]
["1.14","PSA 8.4.4","OHS Act Obligations","Month",21]
[{"$f":"IF(E110=0,\"\",$A$5&COUNTIF($A$6:A107,\"><*\")+1)","v":""}]
["1.15","PSA 8.4.5","EMP Obligations","Month",21]
[]
["1.16","PSA 8.4.6","Security Services","Month",21]
[]
[]
["1.17","PSA 8.4.6.1","g)Compliance with OHS & EM Plans including Safety Officer and Environmental Offcier Salaries","Month",21]
[{"$f":"IF(E117=0,\"\",$A$5&COUNTIF($A$6:A107,\"><*\")+1)","v":""}]
["1.18",null,"Facilities for SMMEs Time Related Items"]
[]
[null,null,"a) Storage Facilitities","Month",21]
[]
[null,null,"b) Tools and equipment","Month",21]
[]
[null,"8.4.3","c) Contractor's Supervision of SMMEs for the duration of construction","Month",21]
[]
[null,null,"d) Other time related obligations","Month",21]
[]
["1.19","PS 3.2.8       ","SMME's Preliminary and General","Prov.Sum",1,{"v":8290942.57,"d":"8,290,943"},{"$f":"E128*F128","v":{"v":8290942.57,"d":"8,290,943"}}]
[]
[{"$f":"IF(E130=0,\"\",$A$5&COUNTIF($A$6:A129,\"><*\")+1)","v":"A.29"},null,"a) Extra over items 1.19 above for overhead charges and profit","%",{"$f":"+F128","v":{"v":8290942.57,"d":"8,290,943"}}]
[]
["1.20","PSA 8.4.6.2","Security Services on-site for SMMEs facilities","Month",0,null,"Rate only"]
[{"$f":"IF(E133=0,\"\",$A$2&COUNTIF($A$3:A132,\"><*\")+1)","v":""},"TOTAL CARRIED FORWARD "]
[{"$f":"IF(E134=0,\"\",$A$2&COUNTIF($A$3:A133,\"><*\")+1)","v":""},"TOTAL BROUGHT FORWARD"]
[{"$f":"IF(E135=0,\"\",$A$5&COUNTIF($A$6:A132,\"><*\")+1)","v":""}]
["1.21","PSA 8.5","PROVISIONAL SUMS STATED BY ENGINEER"]
[{"$f":"IF(E137=0,\"\",$A$5&COUNTIF($A$6:A136,\"><*\")+1)","v":""}]
[null,null,"a) Community Liaison Officer \nSalaries and cellphone allowance (No 3)","Prov. Sum",1,{"v":945000,"d":"945,000.00"},{"$f":"E138*F138","v":{"v":945000,"d":"R945,000.00"}}]
[{"$f":"IF(E139=0,\"\",$A$5&COUNTIF($A$6:A138,\"><*\")+1)","v":""}]
[null,null,"b) JW ISD representative (Community facilitator-including team leader and Complaints handler)","Prov. Sum",1,{"v":378700,"d":"378,700.00"},{"$f":"E140*F140","v":{"v":378700,"d":"R378,700.00"}}]
[{"$f":"IF(E141=0,\"\",$A$5&COUNTIF($A$6:A140,\"><*\")+1)","v":""}]
[null,null,"c) Community awareness material ","Prov. Sum",1,{"v":100000,"d":"100,000.00"},{"$f":"E142*F142","v":{"v":100000,"d":"R100,000.00"}}]
[{"$nulls":4},1]
[null,null,"d) QCF and QCO(No:5)","Prov. Sum",1,{"v":660000,"d":"660,000.00"},{"$f":"E144*F144","v":{"v":660000,"d":"R660,000.00"}}]
[]
[null,null,"e) Training but not limited to the following: Plumbing ","Prov. Sum",1,{"v":600000,"d":"600,000.00"},{"v":600000,"d":"R600,000.00"}]
[]
[null,null,"f) MIS System or similar approved Training","Prov. Sum",1,{"v":100000,"d":"100,000.00"},{"$f":"E148*F148","v":{"v":100000,"d":"R100,000.00"}}]
[]
[null,null,"g) Reinstatement of Asphalt by JRA","Prov. Sum",1,{"v":350000,"d":"350,000.00"},{"$f":"E150*F150","v":{"v":350000,"d":"R350,000.00"}}]
[]
[null,null,"h) Overheads, charges and profit on item 1.21 (a) to 1.21 (g)","%",{"$f":"SUM(F138:F150)","v":{"v":3133700,"d":"3,133,700"}}]
[]
["1.22",null,"TEMPORARY WORKS"]
[]
["1.22.1",null,"Existing Services"]
[]
[null,null,"a) Excavation by hand in all material to expose existing services","m3",{"v":1000,"d":"1,000"}]
[{"$f":"IF(E159=0,\"\",$A$5&COUNTIF($A$6:A152,\"><*\")+1)","v":""}]
[null,null,"b) Temporary protection of services","Sum",1]
[]
[null,null,"c)Accomodation of traffic ","Sum",1]
[]
[null,"PSA 8.4.15","d) Provision of photographic records","Sum",1]
[]
["1.23","8.7","DAY WORKS \n(the rate shall cover overhead charges and profit of all day works itesm listed)  \n(to be executed on instruction from the Engineer)"]
[{"$f":"IF(E167=0,\"\",$A$5&COUNTIF($A$6:A166,\"><*\")+1)","v":""}]
["1.23.1",null,"Labour"]
[{"$f":"IF(E169=0,\"\",$A$5&COUNTIF($A$6:A168,\"><*\")+1)","v":""}]
[null,null,"a) Unskilled","hr",150]
[{"$f":"IF(E171=0,\"\",$A$5&COUNTIF($A$6:A170,\"><*\")+1)","v":""}]
[null,null,"b) Semi skilled","hr",150]
[{"$f":"IF(E173=0,\"\",$A$5&COUNTIF($A$6:A172,\"><*\")+1)","v":""}]
[null,null,"c) Skilled","hr",150]
[{"$f":"IF(E175=0,\"\",$A$5&COUNTIF($A$6:A174,\"><*\")+1)","v":""}]
[null,null,"d) Armed Security guard","hr",150]
[{"$f":"IF(E177=0,\"\",$A$5&COUNTIF($A$6:A176,\"><*\")+1)","v":""},"TOTAL CARRIED FORWARD "]
[{"$f":"IF(E178=0,\"\",$A$5&COUNTIF($A$6:A177,\"><*\")+1)","v":""},"TOTAL BROUGHT FORWARD"]
[{"$f":"IF(E179=0,\"\",$A$5&COUNTIF($A$6:A178,\"><*\")+1)","v":""}]
["1.23.2",null,"TLB's (Tractor loader backhoe)"]
[{"$f":"IF(E181=0,\"\",$A$5&COUNTIF($A$6:A180,\"><*\")+1)","v":""}]
[null,null,"a) 2x4","hr",150]
[{"$f":"IF(E183=0,\"\",$A$5&COUNTIF($A$6:A182,\"><*\")+1)","v":""}]
[null,null,"b) 4x4","hr",150]
[{"$f":"IF(E185=0,\"\",$A$5&COUNTIF($A$6:A184,\"><*\")+1)","v":""}]
[{"$f":"IF(E186=0,\"\",$A$5&COUNTIF($A$6:A185,\"><*\")+1)","v":""},null,"Compactors"]
[{"$f":"IF(E187=0,\"\",$A$5&COUNTIF($A$6:A186,\"><*\")+1)","v":""}]
["1.23.3",null,"a) Wacker","hr",48]
[{"$f":"IF(E189=0,\"\",$A$5&COUNTIF($A$6:A188,\"><*\")+1)","v":""}]
[null,null,"b) Plate compactor","hr",48]
[{"$f":"IF(E191=0,\"\",$A$5&COUNTIF($A$6:A190,\"><*\")+1)","v":""}]
["1.23.4",null,"Generator (Wet Rate)"]
[{"$f":"IF(E193=0,\"\",$A$5&COUNTIF($A$6:A192,\"><*\")+1)","v":""}]
[null,null,"a) 3kVA","hr",100]
[{"$f":"IF(E195=0,\"\",$A$5&COUNTIF($A$6:A194,\"><*\")+1)","v":""}]
[null,null,"b) 5kVa","hr",100]
{"$rows_empty":9}
[{"$f":"IF(E206=0,\"\",$A$5&COUNTIF($A$6:A190,\"><*\")+1)","v":""},"TOTAL CARRIED FORWARD TO SUMMARY"]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[]
[2,"SABS 1200C","SCHEDULE B:  SITE CLEARANCE"]
[]
["2.1","8.2.1","Clear and grub (2 metre width)","m",{"v":1800,"d":"1,800"}]
[]
["2.2","PSC 8.2.14","Protection of trees as ordered by Engineer","No",50]
[]
["2.3","8.2.10","Remove topsoil to nominal depth of 150mm and stockpile for re-use as directed by Engineer","m3",{"v":1200,"d":"1,200"}]
[]
["2.4","PSC 8.2.11b","Removal of man-made surfaces, stockpile materials for later re-use"]
[]
[null,null,"a) Footways and driveways"]
[]
[null,null,"i) Asphalt (≤ 50mm thickness)","m2",200]
[]
[null,null,"ii) Asphalt (≥  50 - 100mm thickness)","m2",200]
[]
[null,null,"iii) Interlocking concrete segmental paving blocks (all colours)","m2",{"v":2400,"d":"2,400"}]
[]
[null,null,"iv) Concrete slabs (450 x 450mm)","m2",120]
[]
[null,null,"v) Brick paving","m2",{"v":2400,"d":"2,400"}]
[]
[null,null,"vi) Grassing and vegetation","m2",{"v":1200,"d":"1,200"}]
[]
[null,null,"vii) Unreinforced concrete <75mm thick","m³",45]
[]
[null,null,"viii) Reinforced concrete <75mm thick","m³",45]
[]
[null,null,"ix) Kerbing (All types of kerbs)","m",{"v":2000,"d":"2,000"}]
[]
[null,null,"x) Dump rock/Stone pitching","m³",60]
[]
[null,null,"xi) Steel palisade","m",400]
[]
[null,null,"xii) Concrete palisade","m",400]
[]
[null,null,"xiii) Removal of all other fences","m",{"v":4000,"d":"4,000"}]
[]
[null,null,"xiv) Demolish of 115mm brick boundary wall","m",{"v":2500,"d":"2,500"}]
[]
[null,null,"xv) Demolish of 230mm brick boundary wall","m",{"v":2000,"d":"2,000"}]
[]
[null,null,"xvi) Tiles ","m2",1000]
[]
["2.5","PSC 8.2.12","Backfilling and reinstatement of man-made surfaces"]
[]
[null,null,"a) Backfilling and reinstatement of footways and driveways using materials recovered in item 2.4 above"]
[]
[null,null,"i) Interlocking concrete segmental paving blocks (all colours)","m2",{"v":2400,"d":"2,400"}]
[]
[null,null,"ii) Concrete slabs (450 x 450mm)","m2",120]
[]
[null,null,"iii) Brick paving","m2",{"v":2400,"d":"2,400"}]
[]
[null,null,"iv) Grassing and vegetation","m2",{"v":1200,"d":"1,200"}]
[]
[null,null,"v) Kerbing (All types of kerbs)","m",{"v":2000,"d":"2,000"}]
[]
[null,null,"vi) Dump rock/Stone pitching","m³",60]
["TOTAL CARRIED FORWARD "]
["TOTAL BROUGHT FORWARD"]
["2.6","PSC 8.2.12","a) Backfilling and reinstatement of footways and driveways using new materials "]
[]
[null,null,"i) Asphalt (≤ 50mm thickness)","m2",{"$f":"+E221","v":200}]
[]
[null,null,"ii) Asphalt (≥  50 - 100mm thickness)","m2",{"$f":"+E223","v":200}]
[]
[null,null,"iii) Interlocking concrete segmental paving blocks (all colours)","m2",{"$f":"+E257*0.3","v":720}]
[]
[null,null,"iv) Concrete slabs (450 x 450mm)","m2",{"$f":"+E259*0.3","v":36}]
[]
[null,null,"v) Brick paving all colours","m2",{"$f":"+E261*0.3","v":720}]
[]
[null,null,"vi) Grassing and vegetation","m2",{"$f":"+E263*0.3","v":360}]
[]
[null,null,"vii) Unreinforced concrete <75mm thick","m³",{"$f":"+E233","v":45}]
[]
[null,null,"viii) Reinforced concrete <75mm thick","m³",{"$f":"+E235","v":45}]
[]
[null,null,"ix) Kerbing (All types of kerbs)","m",{"$f":"+E265*0.3","v":600}]
[]
[null,null,"x) Dump rock/Stone pitching","m³",{"$f":"+E267*0.3","v":18}]
[]
[null,null,"xi) Steel palisade","m",{"$f":"+E241","v":400}]
[]
[null,null,"xii) Concrete palisade","m",{"$f":"+E243","v":400}]
[]
[null,null,"xiii) All other fences","m",{"$f":"+E245","v":{"v":4000,"d":"4,000"}}]
[]
[null,null,"xiv) 115mm brick boundary wall including plastering","m",{"$f":"+E247","v":{"v":2500,"d":"2,500"}}]
[]
[null,null,"xv) 230mm brick boundary wall including plastering","m",{"$f":"+E249","v":{"v":2000,"d":"2,000"}}]
[]
[null,null,"xvi) Tiles ","m2",1000]
["TOTAL CARRIED FORWARD TO SUMMARY"]
["Item No.","Payment Clause","Description","Unit","Qty","RATE","AMOUNT"]
[3,"SABS 1200DB","SCHEDULE C: EARTHWORKS (PIPE TRENCHES)"]
[]
["3.1","8.3.2","Excavation"]
[]
["3.1.1","PSDB 8.3.2(a)","Excavate in all material for trenches, shore and dispose of surplus material using labour intensive construction methods for the depths of:"]
[]
[null,null,"a) Over 0,0m and up to 1,5m","m³",{"$f":"+(E$421+E$422)*1.5*0.9*1.1","v":{"v":14850.000000000002,"d":"14,850"}}]
[]
[null,null,"b) Over 1,5m and up to 2,5m","m³",10]
[]
[null,null,"c) Over 2,5m","m³",10]
[]
["3.1.2","PSDB 8.3.2(3)","Excavate by hand  in all material for tie-ins, house connections, backfill and compact including disposal of surplus unsuitable material for depth: "]
[]
[null,null,"a) Over 0,0m and up to 1,0m","m³",{"$f":"+E$311*0.15","v":{"v":2227.5,"d":"2,228"}}]
[]
[null,null,"b) Over 1,0m and up to 1,5m","m³",{"$f":"+E$313*0.2","v":2}]
[]
[null,null,"c) Over 1,5m","m³",{"$f":"+E$315*0.2","v":2}]
[]
["3.1.3","8.3.2(b)","Extra over Item 3.1.1 above for : Please refer to PSD 3.1.3 for Classification of materials for hand excavations"]
[]
[null,null,"a) Intermediate excavation.","m³",{"$f":"+E$311*0.35","v":{"v":5197.5,"d":"5,198"}}]
[]
[null,null,"b) Hard excavation.","m³",{"$f":"+E$311*0.3","v":{"v":4455,"d":"4,455"}}]
[]
[null,null,"c) Rock excavation","m³",{"$f":"+E$311*0.1","v":{"v":1485.0000000000002,"d":"1,485"}}]
[]
["3.2","8.3.3","Excavation Ancillaries"]
[]
["3.2.1","8.3.3.1","Make up deficiency in backfill material (Provisional)"]
[]
[null,null,"a) from other necessary excavations on site","m³",{"$f":"+E329*0.8","v":{"v":3564,"d":"3,564"}}]
[]
[null,null,"b) by importation from designated borrow pits","m³",{"$f":"+E331+E329/2","v":{"v":3712.5,"d":"3,713"}}]
[]
[null,null,"c) by importation from commercial or off site sources selected by the Contractor","m³",{"$f":"+E331","v":{"v":1485.0000000000002,"d":"1,485"}}]
[null,null," "]
["3.3","8.3.3.3","a) Additional compaction to 95% mod AASHTO density in road crossings","m³",{"$f":"+E311*0.07","v":{"v":1039.5000000000002,"d":"1,040"}}]
[]
["3.4","8.3.4 (a)","a)Shore trench opposite structure or service (Provisional)","m",{"$f":"+E421*0.15","v":{"v":1500,"d":"1,500"}}]
[]
["TOTAL CARRIED FORWARD "]
["TOTAL BROUGHT FORWARD"]
["3.5","PSDB 8.3.5(a)","a) Services that intersect a trench"]
[]
[null,null,"i) Water house connections.","No.",757]
[]
[null,null,"ii) Sewer pipes up to 300mm Dia.","No.",{"$f":"+E$421*0.1","v":{"v":1000,"d":"1,000"}}]
[]
[null,null,"iii) Cables.","No.",{"$f":"+E$421*0.14","v":{"v":1400.0000000000002,"d":"1,400"}}]
[]
[null,null,"iv) Stormwater pipes up to 1050mm dia.","No.",{"$f":"+E$421*0.03","v":300}]
[]
[null,null,"v) Kerbs and Channels","No.",{"$f":"+E$421*0.05","v":500}]
[]
[null,null,"vi) Water pipes of any diameter","No.",{"$f":"+E$421*0.08","v":800}]
[]
[null,null,"vii) Irrigation pipes","No.",{"$f":"+E$421*0.01","v":100}]
[]
["3.6","8.3.5(b)","b) Services that adjoin a trench"]
[]
[null,null,"i) Water house connections","m",{"v":1892,"d":"1,892"}]
[]
[null,null,"ii) Sewer pipes up to 600mm Dia.","m",{"$f":"+E$421*0.2","v":{"v":2000,"d":"2,000"}}]
[]
[null,null,"iii) Cables.","m",{"$f":"+E$421*0.3","v":{"v":3000,"d":"3,000"}}]
[]
[null,null,"iv) Stormwater pipes up to 1050mm dia.","m",{"$f":"+E$421*0.15","v":{"v":1500,"d":"1,500"}}]
[]
[null,null,"v) Kerbs and Channels","m",{"$f":"+E$421*0.4","v":{"v":4000,"d":"4,000"}}]
[]
[null,null,"vi) Water pipes of any diameter","m",{"$f":"+E$421*0.6","v":{"v":6000,"d":"6,000"}}]
[]
[null,null,"vii) Irrigation pipes","m",{"$f":"+E$421*0.02","v":200}]
[]
["3.7","PSDB 8.3.5( c )","Services that require special care","No",200]
[]
["3.8",null,"Trimming of tree roots on pipe alignment( This item will be measured as number of trees)","No",100]
["CARRIED FORWARD TO SUMMARY"]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[4,"SABS 1200LB","SCHEDULE D: BEDDING (PIPES)"]
[]
["4.1"," 8.2.1","Provision of bedding from trench excavation"]
[]
[null,null,"a) Selected granular material","m³",{"$f":"+(E421+E422)*0.25*1","v":2500}]
[]
[null,null,"b) Selected fill material","m³",{"$f":"+(E421+E422)*0.41*1-((((E421+E422)*(PI()*0.11^2)/4)))","v":{"v":4004.9668222289088,"d":"4005"}}]
[]
[null,null,"c) Extra over item 4.1(a) and (b) for sieving where ordered by Engineer","m³",{"$f":"+(E390+E392)*0.25","v":{"v":1626.2417055572273,"d":"1626"}}]
[]
["4.2","8.2.2.3","Provision of bedding imported from commercial sources (Provisional) "]
[]
[null,null,"a) Selected granular material ","m³",{"$f":"+E390*0.35","v":875}]
[null,null,"b) Selected fill material ","m³",{"$f":"+(E392)*0.3","v":{"v":1201.4900466686727,"d":"1201"}}]
[null,null,"c) 19mm Crushed stones bedding ","m³",{"$f":"+(E392+E390)*0.15","v":{"v":975.7450233343363,"d":"976"}}]
[]
["4.3","8.2.4","a) Encasing of pipe in 20MPa concrete (Provisional)","m³",{"$f":"+E392*0.12","v":{"v":480.596018667469,"d":"481"}}]
[]
[]
[null,null,"b) Concrete for Thrust/anchor blocks (including all required formwork) as per detail JW100-DET05-W01","m³",{"$f":"+E392*0.09","v":{"v":360.44701400060177,"d":"360"}}]
{"$rows_empty":10}
["TOTAL CARRIED FORWARD TO SUMMARY"]
["Item No.","Payment Clause","Description","Unit"," Qty","Rate","Amount"]
[5,"SABS 1200L","SCHEDULE E: MEDIUM PRESSURE PIPELINES"]
[]
["5.1","8.2.1","a) Supply, lay, bed (class B bedding), all test and disinfect, backfill complete with victaulic couplings denso wrapped including knock on collars at joints, high impact mPVC Class 16 pipes:"]
[null,null,"i) DN110","m",{"v":10000,"d":"10,000"}]
[null,null,"ii) DN160","m",0,null,"Rate only"]
[null,null,"iii) DN200","m",0,null,"Rate only"]
[null,null,"iv) DN250","m",0,null,"Rate only"]
[]
["5.1.1","PSL 8.2.1","Pressure Testing of existing pipes","m",23000]
[]
["5.1.2","PSL 8.2.2","Commissioning (Locating, disinfecting and commisioning of existing road reserve water pipes of all materials with diameters ranging from 110 mm to 250mm)","m",23000]
[]
["5.1.3","PSL 8.2.3","Decomissioning Material for existing pipes","Prov.Sum",1,{"v":2000000,"d":"R2,000,000.00"},{"$f":"F430","v":{"v":2000000,"d":"R2,000,000.00"}}]
[]
["5.1.4",null,"Extra over items 5.1.3 above for overhead charges and profit","%",{"$f":"G430","v":{"v":2000000,"d":"R2,000,000.00"}}]
[]
[null,null,"Fittings to suit High Impact Class 16 uPVC pipes"]
[]
["5.2.1","8.2.2","a) Shouldered end Steel Bends Fusion Bonded Epoxy coated 250 microns including thrust blocks to suit high impact mPVC pipe:"]
[]
[null,null,"DN110"]
[null,null,"i) 11¼°","No",25]
[null,null,"ii) 22.5°","No",20]
[null,null,"iii) 45°","No",90]
[null,null,"iv) 90°","No",25]
[]
[null,"8.2.2","b) Shouldered end Steel Reducer Fusion Bonded Epoxy coated 250 microns to suit High Impact mPVC pipe:"]
[]
[null,null,"i) 150mm x 100mm dia.","No",{"$f":"+E$421*0.0025","v":25}]
[null,null,"ii) 200mm x 100mm dia.","No",{"$f":"+E$421*0.0025","v":25}]
[]
[null,null,"c) Steel Flanged Crosses, Fusion Bonded Epoxy coated 250 microns to suit High Impact mPVC piping including thrust block"]
[]
[null,null,"i) 100mm dia. equal cross","No",{"$f":"+E$421*0.0045","v":45}]
[null,null,"ii) 150mm dia. equal cross","No",3]
[]
[null,null,"e) Steel End Caps Fusion Bonded Epoxy coated 250 microns to suit High Impact mPVC piping including thrust block"]
[]
[null,null,"i)DN110","No",{"$f":"+E$421*0.0008","v":8}]
[null,null,"ii) DN160","No",2]
[]
[null,null,"Extra-over item 8.2.2 for encasing joints (Denso wrapping or similar approved of metal joints).","No",{"$f":"+E$421*0.05","v":500}]
[]
["5.3"]
["5.3.1","PSL 8.2.19","a) Supply, fixing and bedding of valves with its fittings complete (including chambers as per drawing JW100-DET03-W01. Gate Valves Class 16, anti-clockwise closing (except for Midrand Depot) for the following pipe sizes: Valves to be manufactured in accordance with SANS 664"]
[]
[null,null,"i) DN100 RSV Class 16 Non rising spindle Detail JW100-DET03-W01","No",{"$f":"+E$421*0.016","v":160}]
[null,null,"ii) DN150 RSV Class 16 Non rising spindle Detail JW100-DET03-W01","No",2]
[]
["5.3.2","PSL 8.2.19","b) Supply, fixing and bedding of above ground fire hydrants with fittings and galvanised pipe for connection to the main line as per detail JW100-DET06-W01 (Rate to include all fittings required to connect to main line e.g. tees, bends, distance piece, approved coating on the fire hydrant etc.)"]
[null,null,"i) DN80 fire Hydrant mainline 110mm dia","No",140]
[null,null,"ii) DN80 fire Hydrant mailine 160mm dia","No",5]
[]
["5.4","8.2.4","Extra-over 5.1 for cutting and joining of pipes to length where required:"]
["5.4.1",null,"a) '\"Press on\" shouldered end collars including 1 victaulic coupling for mPVC pressure pipe:"]
[null,null,"i) DN110","No",{"$f":"+E$421*0.024","v":240}]
[null,null,"ii) DN160","No",10]
["TOTAL CARRIED FORWARD "]
["TOTAL BROUGHT FORWARD"]
[]
["5.4.2",null,"b) Steel Flanged Adaptors with victaulic ends, Fusion Bonded Epoxy coated 250 microns to suit High Impact mPVC piping including thrust block"]
[null,null,"i) DN110","No",{"$f":"+E$421*0.05","v":500}]
[null,null,"ii) DN160","No",14]
[]
["5.4.3",null,"c) Steel flanged adaptors (VJ type), Fusion Bonded Epoxy coated 250 microns to suit High Impact mPVC piping including thrust block"]
[null,null,"i) DN110","No",{"$f":"+E$421*0.009","v":90}]
[null,null,"ii) DN160","No",2]
[]
["5.5","8.2.15","Special wrapping in corrosive soil per joint and as instructed by the Engineer","No",{"$f":"+E$421*0.0315","v":315}]
[]
["5.6",null,"Tying into existing Pipes"]
[]
["5.6.1","PSL 8.2.17","Tying into existing water line. Supply all fittings to suit pipe size including labour for the following pipe sizes, excavations will be allowed under pipe excavations:"]
[]
[null,null,"a) Tying new 110mm-160mm uPVC/HDPE/mPVC into existing steel/HDPE/AC/uPVC pipes for the following pipe sizes:"]
[null,null,"i) 100mm to 200mm","No",{"$f":"+E$421*0.0015","v":15}]
[null,null,"ii) 201mm to 400mm","No",{"$f":"+E$421*0.001","v":10}]
[]
[null,null,"b) Tying new 200mm-250mm HDPE/MPVC into existing steel/HDPE/AC/uPVC pipe for the following pipe sizes:"]
[null,null,"i) 100mm to 200mm","No",null,null,"Rate Only"]
[null,null,"ii) 201mm to 400mm","No",null,null,"Rate Only"]
[]
[]
["5.6.2",null,"Tying into existing water line using under pressure drilling. Supply all fittings to suit pipe sizes including labour for the following pipe sizes:"]
[null,null,"a) Tying new 110mm-160mm HDPE/MPVC into existing steel/HDPE pipe for the following pie sizes:"]
[]
[null,null,"i) 100mm to 200mm","No",2]
[null,null,"ii) 201mm to 400mm","No",null,null,"Rate Only"]
[]
[]
["5.7","PSL 8.2.24.2","Supply, handle, install the following HDPE pipes using Horizontal Directional Drilling (HDD) in soft and intermediate material for any depth"]
[null,null,"a) DN110 (HDPE pipe, Class 16 PE100 SDR 11)","m",{"$f":"+E$421*0.03","v":300}]
[null,null,"b) DN160 (HDPE pipe, Class 16 PE100 SDR 11)","m",null,null,"Rate Only"]
[]
["5.8",null,"Extra over item 5.7 for Horizontal Direction Drilling in rock material","m",{"$f":"+E$421*0.045","v":450}]
[]
["5.8.1",null,"Excavate in all materials Launching and reception shafts/pits","m³",{"$f":"1.5*1.5*1*450","v":{"v":1012.5,"d":"1,013"}}]
[]
["5.9","PSL 8.2.18","a) Recover valves, fittings, meters, specials of all sizes etc and deliver to the respective Depot or as instructed by the Employer's Agent."]
[]
[null,null,"i) Valves following sizes:"]
[null,null,"1) 100mm to 300mm","No",{"$f":"+E$421*0.045","v":450}]
[null,null,"2) 301mm to 600mm","No",null,null,"Rate Only"]
[null,null,"ii) Fire Hydrants all sizes","No",{"$f":"+E$421*0.022","v":220}]
{"$rows_empty":14}
["CARRIED FORWARD TO SUMMARY"]
["Item No.","Payment Clause","Description","Unit"," Qty","Rate","Amount"]
["6.","SABS1200","SCHEDULE F: ERF CONNECTIONS (WATER)"]
[null,"DB"]
["6.2",null,"EXCAVATIONS"]
[]
[null,"8.3.2(a)","Excavate in all materials for trenches 400mm wide, backfill, compact, dispose of surplus / unsuitable material, levelling and cleaning for the following pipe diameters:"]
[]
[null,null,"a) 0 - 40mm diameter","m³",{"v":5297.6,"d":"5,298"}]
[]
[null,null,"b) > 40mm - 50mm diameter","m³",560]
[]
["6.3","PSDB 8.3.2 (b) ","Extra-over items (8.3.1 (a)) for"]
[]
[null,null,"i) Intermediate excavation","m³",{"v":1854.16,"d":"1,854"}]
[]
[null,null,"ii) Hard rock excavation","m³",{"v":529.7600000000001,"d":"530"}]
[]
["6.4",null,"ERF CONNECTIONS"]
[]
["6.4.1",null,"Illegal erf connection locating and removal","No.",{"v":2270.4,"d":"2,270"}]
[]
["6.4.2",null,"Erf connection provision and installation\n"]
[null,null,"1) Domestic erf connections"]
[]
[null,null,"All erf connections HDPE"]
[]
[null,null," a) Single short erf connections","No.",{"v":3027.2000000000003,"d":"3,027"}]
[]
[null,null," b) Double short erf connections","No.",{"v":1513.6000000000001,"d":"1,514"}]
[]
[null,null," c) Single long erf connections","No.",{"v":1892,"d":"1,892"}]
[]
[null,null," d) Double long erf connections","No.",{"v":1135.2,"d":"1,135"}]
["6.4.3"]
[null,"PS4.2.2","HORIZONTAL DRILLING (LONG ERF CONNECTIONS)"]
[]
[null,"C2.1.3.1","Supply and installation of pipe through horizontal drilling\n"]
[]
[null,null,"a)20 mm diameter HDPE pipes","m",{"v":1229.8000000000002,"d":"1,230"}]
[]
[null,null,"b) 25 mm diameter HDPE pipes","m",{"v":2705.56,"d":"2,706"}]
[]
[null,null,"c) 32 mm diameter HDPE pipes","m",{"v":19172.448552648002,"d":"19,172"}]
[]
[null,null,"c) 40 mm diameter HDPE pipes","m",{"v":1000,"d":"1,000"}]
[]
["6.4.4",null,"Extra-over item for horizontal drilling.","m",{"v":3689.4,"d":"3,689"}]
[]
["6.5",null,"VALVES"]
[null,"PF22.9","Provision and installation of ball valves"]
[null,null,"a) Provision and installation of ball valves on "]
[null,null,"existing and new erf connections. (Less than 500mm deep)"]
[]
[null,null,"1) 20 mm diameter ball valve","No.",{"v":1895.673786407768,"d":"1896"}]
[]
[null,null,"2) 25 mm diameter ball valve","No.",{"v":1138.873786407768,"d":"1139"}]
[]
[null,null,"3) 32mm diameter ball valve","No.",{"v":1400.4473786407736,"d":"1400"}]
[]
[null,null,"4) 40mm diameter ball valve","No.",20]
[]
["6.6",null,"b) Provision and installation of ball valves on existing erf connections (More than 500mm deep)"]
[]
[null,null,"1) 20mm diameter ball valve","No.",{"v":4915.526213592232,"d":"4,916"}]
[]
[null,null,"2) 25 mm diameter ball valve","No.",{"v":6429.126213592232,"d":"6,429"}]
[]
[null,null,"3) 32mm diameter ball valve","No.",{"v":7185.926213592233,"d":"7,186"}]
[]
[null,null,"4) 40mm diameter ball valve","No.",20]
[]
[]
["TOTAL CARRIED FORWARD ",{"$nulls":5}," "]
["TOTAL BROUGHT FORWARD"]
[]
["6.7",null,"Extra-over above item for ball valve installation for existing pipes other than HDPE."]
[null,null,"1) 20 mm diameter ball valve","No.",0,null,"Rate only"]
[null,null,"2) 25 mm diameter ball valve","No.",{"v":2270,"d":"2,270"}]
[null,null,"3) 32 mm diameter ball valve","No.",0,null,"Rate only"]
[]
[null,null,"4) 40mm diameter ball valve","No.",20]
[]
["6.8",null,"Supply and install valve boxes for ball valves","No.",{"v":7568,"d":"7,568"}]
[]
[null,null,"Additional items pertaining to bulk water meters and appeurtenances to be procured on instruction from the Engineer","Prov. Sum",1,{"v":100000,"d":"R100,000"},{"$f":"E621*F621","v":{"v":100000,"d":"R100,000"}}]
[]
[null,null,"Overheads, charges and profit on item 6.5","%",{"$f":"F621","v":{"v":100000,"d":"R100,000.00"}}]
["TOTAL CARRIED FORWARD TO SUMMARY"]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[7,null,"SCHEDULE G: YARD CONNECTIONS"]
[]
["7.1","PS1.3 (A)","YARD CONNECTIONS"]
[]
["7.1.1",null,"Provision and installation of yard connections ","Prov.Sum",1,{"v":5640421.001,"d":"R5,640,421"},{"$f":"+F630*E630","v":{"v":5640421.001,"d":"R5,640,421"}}]
[]
["7.1.2",null,"Extra over items C1 above for overhead charges and profit","%",{"$f":"G630","v":{"v":5640421.001,"d":"5,640,421"}}]
[]
["7.2",null,"LEAK DETECTION"]
[]
[null,"PA8.2.19","Leak free tests","No.",{"v":7000,"d":"7,000"}]
{"$rows_empty":30}
["TOTAL CARRIED FORWARD TO SUMMARY"]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[]
[8,null,"SCHEDULE H: ON-PROPERTY PLUMBING RETROFITTING"]
[{"$f":"IF(E671=0,\"\",$A$7&COUNTIF($A$8:A670,\"><*\")+1)","v":""}]
["8.1","PA8.2.8 ","Preparation and delivery of notice to owner","No.",{"v":7568,"d":"7,568"}]
[]
["8.2","PA 8.2.20 ","100% pre-intervention survey on customer properties","No.",{"v":7568,"d":"7,568"}]
[]
["8.3","PA8.2.2 ","Provision and installation of on-property plumbing retrofitting ","Prov.Sum",1,{"v":957263.634578593,"d":"R957,264"},{"$f":"E676*F676","v":{"v":957263.634578593,"d":"R957,264"}}]
[]
["8.4",null,"Extra over items 8.3 above for overhead charges and profit","%",{"$f":"+G676","v":{"v":957263.634578593,"d":"957,264"}}]
[]
[null,null,"Remove and replace or refurbish existing and test plumbing fittings"]
[]
["8.5","PA 8.2.22 ","Water closet (WC) pans","No.",{"v":4541,"d":"4,541"}]
[]
["8.5.1","PA 8.2.23 ","Water closet (WC) cistern and flushing mechanism"]
[]
[null,null,"a) 6-Litre plastic unit","No.",{"v":2649,"d":"2,649"}]
[]
[null,null,"b) 6-Litre porcelain unit","No.",{"v":2649,"d":"2,649"}]
[]
["8.5.2",null,"Flushing unit only"]
[]
[null,null,"a) Plastic flushing unit","No.",{"v":2649,"d":"2,649"}]
[]
[null,null,"b) Ceramic flushing unit","No.",{"v":2649,"d":"2,649"}]
[]
["8.5.3","PA 8.2.24 ","Water closet (WC) cistern peripherals"]
[]
[null,null,"a) Cistern-pan connection (Flush pipe)","No.",{"v":4541,"d":"4,541"}]
[]
[null,null,"b) Flexible cistern tank supply connection 20X20mm pipe.","No.",{"v":4541,"d":"4,541"}]
[]
[null,null,"c) Rubber cone for flush pipe (black)","No.",{"v":4541,"d":"4,541"}]
[]
["8.5,4","PA 8.2.25 ","Draw-offs (taps) and stop taps (also known as stopcocks) 1) Bib taps"]
[]
[null,null,"i) Internal Taps","No.",{"v":3784,"d":"3,784"}]
[]
[null,null,"ii) External taps","No.",{"v":3784,"d":"3,784"}]
[]
["8.5,5",null," 2) Pillar taps"]
[]
[null,null,"i) Internal Taps","No.",{"v":3784,"d":"3,784"}]
[]
[null,null,"ii) External taps","No.",{"v":3784,"d":"3,784"}]
[]
["8.6",null,"3) Mixers","No.",{"v":1514,"d":"1,514"}]
[]
["8.7",null,"4) Stoptaps","No.",{"v":1514,"d":"1,514"}]
[]
["8.9",null,"5) Rubber washers","No.",{"v":5298,"d":"5,298"}]
[]
["8.10","PA8.2.2 ","PIPEWORK"]
[{"$f":"IF(E723=0,\"\",$A$7&COUNTIF($A$8:A722,\"><*\")+1)","v":""},null,"Cut, remove and dispose of existing pipe section/s. Supply, handle, thread/couple, install and test new pipe sections for  diameters 15-20mm for the following pipe;"]
[]
[null,null,"a) I.P.S threaded union system","m",{"v":3500,"d":"3,500"}]
[]
[null,null,"b) HDPE","m",{"v":7000,"d":"7,000"}]
[]
[null,null,"Cut, remove and dispose of polytube pipe section/s. Supply, handle, thread/couple, install and test new pipe sections for diameters 15-20mm.","m",{"v":4000,"d":"4,000"}]
[]
[]
[]
[]
["TOTAL CARRIED FORWARD "]
["TOTAL BROUGHT FORWARD"]
[]
["8.11",null,"EXTRA-OVER ITEM FOR THE REMOVAL AND RE-INSTATEMENT OF SURFACES"]
[null,null," "]
[null,null,"a) Remove, temporarily store and re-instate all types of tiles","m²",{"v":7000,"d":"7,000"}]
[]
[null,null,"b) Remove, temporarily store and re-instate all types of brickwork, and re-plaster","m²",{"v":7000,"d":"7,000"}]
[]
[]
["8.12","PA8.2.26 ","PLUMBING FITTINGS"]
[]
["8.12.1",null,"Remove and dispose damaged item.  Supply new, install, test and commission."]
[]
[null,null,"a) Equal tees for 0 -40mm diameter and the following materials"]
[]
[null,null," i) I.P.S threaded union system","No.",{"v":10595,"d":"10,595"}]
[]
[null,null," ii) HDPE","No.",{"v":7946,"d":"7,946"}]
[]
[null,null," iii) Copper","No.",{"v":10595,"d":"10,595"}]
[]
["8.12.2",null,"b) Unequal tees for 0-40mm diameter and the following materials"]
[]
[]
[null,null," i) I.P.S threaded union system","No.",{"v":5298,"d":"5,298"}]
[]
[null,null," ii) HDPE","No.",{"v":7946,"d":"7,946"}]
[]
[null,null," iii) Copper","No.",{"v":7946,"d":"7,946"}]
[]
["8.12.3",null,"c) Reducing bush 0 to 40mm diameter for the following pipe materials:"]
[]
[null,null," i) I.P.S threaded union system","No.",{"v":10595,"d":"10,595"}]
[]
[null,null," ii) HDPE","No.",{"v":5298,"d":"5,298"}]
[]
[null,null," iii) Copper","No.",{"v":7946,"d":"7,946"}]
[]
["8.12.4",null,"d) 90 degree Bends/Elbows"]
[]
[null,null," i) I.P.S threaded union system","No.",{"v":5298,"d":"5,298"}]
[]
[null,null," ii) HDPE","No.",{"v":7946,"d":"7,946"}]
[]
[null,null," iii) Copper","No.",{"v":10595,"d":"10,595"}]
[]
["8.15",null,"ELECTRICAL EARTHING AND BONDING"]
[]
[]
[null,null,"Electrical Earthing","No.",{"v":7946,"d":"7,946"}]
[]
[null,null,"Electrical Bonding"]
[null,null,"a) U-Clamp","No/Set of 2"]
[null,null,"b) Galvanised stay wire/ copper earth peg","m",{"v":10595,"d":"10,595"}]
[]
[null,null,"c) Copper earth peg","No.",{"v":5298,"d":"5,298"}]
[]
[{"$f":"IF(E792=0,\"\",$A$7&COUNTIF($A$8:A791,\"><*\")+1)","v":""},"TOTAL CARRIED FORWARD TO SUMMARY"]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[]
[]
["9.",null,"SCHEDULE I: CUSTOMER METER INSTALLATION"]
[{"$f":"IF(E797=0,\"\",$A$8&COUNTIF($A$9:A796,\"><*\")+1)","v":""}]
["9.1","PF22.7","a) Supply of 15mm diameter  STS Pre-payment water meter as per JW Metering Guidelines complete inclusive of couplings and Meter Box Unit (MBU)","No.",{"v":7568,"d":"7,568"}]
[]
["9.2","PF22.9","STS Customer Interface Unit (CIU-IOT)  (Supply and pairing of STS meter & Switching of meters from Conventional to Prepaid Mode )","No.",{"v":7568,"d":"7,568"}]
[]
["9.3","PF22.10","\tAnnual Data Management Fee IOT Network Hosting for 3 years after completion of the contract. (To cover cost for meter reading, meter performance audit and reporting) Please refer to Schedule A and B in the specifications.","No.",{"v":7568,"d":"7,568"}]
[{"$f":"IF(E803=0,\"\",$A$8&COUNTIF($A$9:A798,\"><*\")+1)","v":""}]
["9.4","PF22.8","b) Installation of meter per stand","No.",{"v":7568,"d":"7,568"}]
[]
["9.5",null,"TRAINING"]
[{"$f":"IF(E807=0,\"\",$A$8&COUNTIF($A$9:A806,\"><*\")+1)","v":""}]
["9.5.1","PF22.2.1","Training for Employer’s staff per session (20 people per group)","No.",15]
[{"$f":"IF(E809=0,\"\",$A$8&COUNTIF($A$9:A808,\"><*\")+1)","v":""}]
["9.5.2","PF22.2.3","Meter demonstration per stand by the Supplier’s technicians","No.",{"v":7568,"d":"7,568"}]
[{"$f":"IF(E811=0,\"\",$A$8&COUNTIF($A$9:A810,\"><*\")+1)","v":""}]
[{"$f":"IF(E812=0,\"\",$A$8&COUNTIF($A$9:A811,\"><*\")+1)","v":""}]
["9.6",null,"TECHNICAL SUPPORT"]
[{"$f":"IF(E814=0,\"\",$A$8&COUNTIF($A$9:A813,\"><*\")+1)","v":""}]
["9.6.1","PF22.3.1","On- Site Support during construction","Month",21]
[{"$f":"IF(E816=0,\"\",$A$8&COUNTIF($A$9:A815,\"><*\")+1)","v":""}]
["9.6.2","PF22.3.2","After hours On-Site Support","No",{"v":1000,"d":"1,000"}]
[{"$f":"IF(E818=0,\"\",$A$8&COUNTIF($A$9:A817,\"><*\")+1)","v":""}]
["9.6.3","PF 22.3.4","On-Site Support-for 12 months after completion of the contract. ","No ",{"v":3500,"d":"3,500"}]
[]
["9.6.4","PF 22.4","Removal of existing meters ","No ",{"v":7568,"d":"7,568"}]
{"$rows_empty":9}
["TOTAL CARRIED FORWARD TO SUMMARY"]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[]
[]
["10.",null,"SCHEDULE J: OCCUPATIONAL HEALTH AND SAFETY"]
[{"$f":"IF(E836=0,\"\",$A$8&COUNTIF($A$9:A835,\"><*\")+1)","v":""}]
[]
[{"$f":"IF(E838=0,\"\",$A$8&COUNTIF($A$9:A836,\"><*\")+1)","v":""},null,"SUPPLY OF ALL ITEMS OF PERSONAL PROTECTIVE CLOTHING/EQUIPMENT & ENSURE USE THEREOF FOR FULL COMPLIANCE"]
[]
["10.1",null,"Steel toe capped safety boots","No.",60]
[]
["10.2",null,"Appropriate protective clothing","No.",{"$f":"+E840","v":60}]
[{"$f":"IF(E843=0,\"\",$A$8&COUNTIF($A$9:A838,\"><*\")+1)","v":""}]
["10.3",null,"Gloves","No.",{"$f":"+E842","v":60}]
[]
["10.4",null,"Colour coded hardhats","No.",{"$f":"+E844","v":60}]
[]
["10.5",null,"Induction tags /cards","No.",{"$f":"+E846","v":60}]
[{"$f":"IF(E849=0,\"\",$A$8&COUNTIF($A$9:A848,\"><*\")+1)","v":""}]
["10.6",null,"Luminous high visibility safety vests","No.",{"$f":"+E848","v":60}]
[{"$f":"IF(E851=0,\"\",$A$8&COUNTIF($A$9:A850,\"><*\")+1)","v":""}]
["10.7",null,"Additional items: Contractor to specify  (To be approved by the Engineer)","No.",{"$f":"+E850","v":60}]
[{"$f":"IF(E853=0,\"\",$A$8&COUNTIF($A$9:A852,\"><*\")+1)","v":""}]
["10.8",null,"BARRICADING"]
[]
[{"$f":"IF(E856=0,\"\",$A$8&COUNTIF($A$9:A854,\"><*\")+1)","v":""},null,"Supply & install Proper Safety Nets, including removal upon completion to ensure full compliance to legislation"]
[]
["10.8.1",null,"Rigid type barricading","m",300]
[{"$f":"IF(E859=0,\"\",$A$8&COUNTIF($A$9:A858,\"><*\")+1)","v":""}]
["10.8.2",null,"Additional items: As specified by the Engineer ","Prov.Sum",1,{"v":400000,"d":"400,000"},{"$f":"+F860*E860","v":{"v":400000,"d":"400,000"}}]
[{"$f":"IF(E861=0,\"\",$A$8&COUNTIF($A$9:A860,\"><*\")+1)","v":""}]
["10.8.3",null,"Profit on item 10.8.2 above","%",{"$f":"+G860","v":{"v":400000,"d":"400,000"}}]
{"$rows_empty":7}
["TOTAL CARRIED FORWARD TO SUMMARY"]

{"sheet":"SUMMARY","index":1,"n_rows":821,"n_cols":7,"rows_kept":821,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,5],[3,0,3,3],[3,4,3,5],[4,0,4,3],[5,0,5,3],[7,0,7,3],[9,0,9,3],[11,0,11,3],[13,0,13,3],[15,0,15,3],[17,0,17,3],[18,0,18,3],[21,0,21,3],[23,0,23,3],[24,0,24,3],[25,0,25,3],[26,0,26,3],[27,0,27,3],[28,0,28,3],[29,0,29,3],[30,0,30,3],[31,0,31,3],[32,0,32,3],[33,0,33,3]]}
["JOHANNESBURG WATER"]
["CONTRACT NUMBER: JW14427D"]
["GREATER ORANGE FARM PHASE 3D WATER INFRASTRUCTURE UPGRADE"]
["DESCRIPTION",{"$nulls":3},"AMOUNT"]
[]
[{"$f":"'Bill of Quantities'!C5","v":"SCHEDULE A:  PRELIMINARY AND GENERAL"},{"$nulls":3},"R"]
[]
["SCHEDULE B:  SITE CLEARANCE",{"$nulls":3},"R"]
[]
["SCHEDULE C:  EARTHWORKS (PIPE TRENCHES)",{"$nulls":3},"R"]
[]
["SCHEDULE D:  BEDDING (PIPES)",{"$nulls":3},"R"]
[]
["SCHEDULE E:  MEDIUM PRESSURE PIPELINES",{"$nulls":3},"R"]
[]
["SCHEDULE F: ERF CONNECTIONS",{"$nulls":3},"R"]
[]
["SCHEDULE G: YARD CONNECTIONS",{"$nulls":3},"R"]
[]
["SCHEDULE H: ON PROPERTY PLUMBING",{"$nulls":3},"R"]
[]
["SCHEDULE I: METER INSTALLATION",{"$nulls":3},"R"]
[]
["SCHEDULE J: OCCUPATIONAL HEALTH AND SAFETY",{"$nulls":3},"R"]
[]
["SUBTOTAL 1……………………………………..………………………………",{"$nulls":3},"R"]
["Escalation"]
["SUBTOTAL 2……………………………………..………………………………"]
["Add Estimated Escalation (@ 7% of Subtotal 1)",{"$nulls":3},"R"]
["SUBTOTAL 2",{"$nulls":3},"R",null,{"$f":"F30*30%","v":0}]
["Add Contigencies (@ 10% of Subtotal 2)",{"$nulls":3},"R",null,{"$f":"20%*G30","v":0}]
["SUBTOTAL 3……………………………………..………………………………",{"$nulls":3},"R"]
["Add VAT (15% of Subtotal 3)",{"$nulls":3},"R"]
["AMOUNT INCL.VAT",{"$nulls":3},"R"]
{"$rows_empty":74}
["1.14"]
[]
["1.15"]
[]
["1.16"]
[]
[]
["1.17",null,"g)Compliance with OHS & EM Plans including Safety Officer and Environmental Offcier Salaries",null,21]
[]
["1.18"]
[]
[{"$nulls":4},21]
[]
[]
[]
[{"$nulls":4},21]
[]
[]
[]
["1.19"]
[]
[null,null,"a) Extra over items 1.19 above for overhead charges and profit"]
[]
["1.20",{"$nulls":5},"Rate only"]
[]
[]
[]
["1.21"]
{"$rows_empty":15}
[null,null,"h) Overheads, charges and profit on item 1.21 (a) to 1.21 (g)"]
[]
["1.22"]
[]
["1.22.1"]
{"$rows_empty":9}
["1.23"]
[]
["1.23.1"]
{"$rows_empty":11}
["1.23.2"]
{"$rows_empty":7}
["1.23.3"]
[]
[]
[]
["1.23.4"]
{"$rows_empty":158}
[{"$nulls":4},757]
{"$rows_empty":15}
[{"$nulls":4},1892]
{"$rows_empty":54}
[{"$nulls":4},0,null,"Rate only"]
[{"$nulls":4},0,null,"Rate only"]
[{"$nulls":4},0,null,"Rate only"]
{"$rows_empty":188}
[{"$nulls":4},0,null,"Rate only"]
[{"$nulls":4},2270]
[{"$nulls":4},0,null,"Rate only"]
[]
[]
[]
[{"$nulls":4},7568]
[]
[{"$nulls":4},1]
{"$rows_empty":50}
[{"$nulls":4},7568]
[]
[{"$nulls":4},7568]
{"$rows_empty":7}
[{"$nulls":4},4541]
[]
[]
[]
[{"$nulls":4},2649]
[]
[{"$nulls":4},2649]
[]
[]
[]
[{"$nulls":4},2649]
[]
[{"$nulls":4},2649]
[]
[]
[]
[{"$nulls":4},4541]
[]
[{"$nulls":4},4541]
[]
[{"$nulls":4},4541]
[]
["8.5,4"]
[]
[{"$nulls":4},3784]
[]
[{"$nulls":4},3784]
[]
["8.5,5"]
[]
[{"$nulls":4},3784]
[]
[{"$nulls":4},3784]
[]
[{"$nulls":4},1514]
[]
[{"$nulls":4},1514]
[]
[{"$nulls":4},5298]
{"$rows_empty":29}
[{"$nulls":4},10595]
[]
[{"$nulls":4},7946]
[]
[{"$nulls":4},10595]
[]
[]
[]
[]
[{"$nulls":4},5298]
[]
[{"$nulls":4},7946]
[]
[{"$nulls":4},7946]
[]
[]
[]
[{"$nulls":4},10595]
[]
[{"$nulls":4},5298]
[]
[{"$nulls":4},7946]
[]
[]
[]
[{"$nulls":4},5298]
[]
[{"$nulls":4},7946]
[]
[{"$nulls":4},10595]
[]
[]
[]
[]
[{"$nulls":4},7946]
[]
[]
[]
[{"$nulls":4},10595]
[]
[{"$nulls":4},5298]
{"$rows_empty":7}
[null,"PF22.7",null,null,7568]
[]
[null,"PF22.9",null,null,7568]
[]
[null,"PF22.10",null,null,7568]
[]
[null,"PF22.8",null,null,7568]
[]
[]
[]
[null,"PF22.2.1"]
[]
[null,"PF22.2.3",null,null,7568]
[]
[]
[]
[]
[]
[]
[null,"PF22.3.2"]
[]
[]
[]
[null,"PF 22.4",null,null,7568]