{"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":1086,"n_cols":7,"rows_kept":1086,"merged":[[0,0,0,6],[1,0,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],[82,1,82,5],[83,1,83,5],[151,1,151,5],[152,1,152,5],[232,1,232,5],[294,0,294,5],[295,0,295,5],[331,0,331,5],[375,0,375,5],[376,0,376,5],[412,0,412,5],[449,0,449,5],[518,0,518,5],[519,0,519,5],[580,0,580,5],[581,0,581,5],[650,0,650,5],[651,0,651,5],[711,0,711,5],[712,0,712,5],[761,0,761,5],[762,0,762,5],[815,0,815,5],[816,0,816,5],[848,0,848,5],[924,0,924,5],[967,0,967,5],[1003,1,1003,5],[1004,0,1005,0],[1004,1,1005,1],[1004,2,1005,2],[1004,3,1005,3],[1004,4,1005,4],[1004,5,1005,5],[1004,6,1005,6],[1050,0,1050,5],[1051,0,1052,0],[1051,1,1052,1],[1051,2,1052,2],[1051,3,1052,3],[1051,4,1052,4],[1051,5,1052,5],[1051,6,1052,6],[1085,0,1085,5]]}
[{"$f":"SUMMARY!A1","v":"JOHANNESBURG WATER"}]
[{"$f":"SUMMARY!A3","v":"SOWETO (ORLANDO) STS PREPAYMENT WATER METER AND RETROFITTING INSTALLATIONS "}]
["Item No.","Payment Clause ","Description","Unit","Qty","Rate","Amount"]
[]
["1.","SANS 1200A & 1200AB","SCHEDULE A:  PRELIMINARY AND GENERAL"]
[{"$f":"IF(E6=0,\"\",$A$5&COUNTIF(#REF!,\"><*\")+1)","v":""},"8.3","FIXED-CHARGE ITEMS"]
[{"$f":"IF(E7=0,\"\",$A$5&COUNTIF($A$6:A6,\"><*\")+1)","v":""}]
["1.1","8.3.1","Contractual requirements","Sum",1]
[{"$f":"IF(E9=0,\"\",$A$5&COUNTIF($A$6:A8,\"><*\")+1)","v":""}]
[{"$f":"IF(E10=0,\"\",$A$5&COUNTIF($A$6:A9,\"><*\")+1)","v":""},"8.3.2","ESTABLISHMENT OF FACILITIES ON SITE"]
[{"$f":"IF(E11=0,\"\",$A$5&COUNTIF($A$6:A10,\"><*\")+1)","v":""},"8.3.2.1","Facilities for Engineer:"]
[{"$f":"IF(E12=0,\"\",$A$5&COUNTIF($A$6:A11,\"><*\")+1)","v":""}]
["1.2","PSA 8.3.2.1","a) Engineers Office Type 2 ","Sum",1]
[{"$f":"IF(E14=0,\"\",$A$5&COUNTIF($A$6:A13,\"><*\")+1)","v":""}]
[null,null,"b) JW Engineering Team (No.2) ","Sum",1]
[{"$f":"IF(E16=0,\"\",$A$5&COUNTIF($A$6:A15,\"><*\")+1)","v":""}]
[null,null,"c) QCO's and CLO Office (No.2)","Sum",1]
[]
[null,null,"d) Boardroom (No:1)","Sum",1]
[{"$f":"IF(E20=0,\"\",$A$5&COUNTIF($A$6:A19,\"><*\")+1)","v":""}]
[null,null,"e) Parking (No.2)","Sum",1]
[{"$f":"IF(E22=0,\"\",$A$5&COUNTIF($A$6:A21,\"><*\")+1)","v":""}]
[null,null,"f) Nameboards (No.4)","Sum",1]
[{"$f":"IF(E24=0,\"\",$A$5&COUNTIF($A$6:A23,\"><*\")+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(E30=0,\"\",$A$5&COUNTIF($A$6:A26,\"><*\")+1)","v":""}]
["1.3","8.3.2.2","Facilities for the Contractor"]
[{"$f":"IF(E32=0,\"\",$A$5&COUNTIF($A$6:A31,\"><*\")+1)","v":""}]
[null,null,"a) Offices and storage sheds","Sum",1]
[]
[null,null,"b) Workshops","Sum",1]
[{"$f":"IF(E36=0,\"\",$A$5&COUNTIF($A$6:A33,\"><*\")+1)","v":""}]
[null,null,"e) Ablution and latrine facilities","Sum",1]
[{"$f":"IF(E38=0,\"\",$A$5&COUNTIF($A$6:A37,\"><*\")+1)","v":""}]
[null,null,"f) Tools and equipment","Sum",1]
[{"$f":"IF(E40=0,\"\",$A$5&COUNTIF($A$6:A39,\"><*\")+1)","v":""}]
[null,null,"g) Water supplies, electric power and communications","Sum",1]
[{"$f":"IF(E42=0,\"\",$A$5&COUNTIF($A$6:A41,\"><*\")+1)","v":""}]
[null,null,"h) Dealing with water (SANS 1200A 5.5)","Sum",1]
[{"$f":"IF(E44=0,\"\",$A$5&COUNTIF($A$6:A43,\"><*\")+1)","v":""}]
[null,null,"i) Access (see sub-clause 5.8)","Sum",1]
[]
["1.4","PSA 8.3.2.2","Facilities For SMMES Fixed Charge 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(E56=0,\"\",$A$5&COUNTIF($A$6:A53,\"><*\")+1)","v":""}]
["1.5","PSA 8.3.2.3","Satellite Facilities for CLO & QCO Team"]
[]
[null,null,"a) Office for CLO & QCO Team Type 2 (No,4)","Sum",1]
[]
[null,null,"b) Water supplies and electric power ","Sum",1]
[]
[null,null,"c) Ablution & Latrine facilities","Sum",1]
[]
[null,null,"d) Removal of facilities","Sum",1]
[]
["1.6","PSA 8.3.5.1","OHS Act Obligations ","Sum",1]
[{"$f":"IF(E68=0,\"\",$A$5&COUNTIF($A$6:A67,\"><*\")+1)","v":""}]
["1.7","PSA 8.3.5.2","EMP Obligations ","Sum",1]
[]
["1.8","PSA 8.3.5.3","Issuing of notices to Customers","Sum",1]
[]
["1.9","PSA 8.5.3.4","Other fixed charged obligations \n","Sum",1]
[{"$f":"IF(E74=0,\"\",$A$5&COUNTIF($A$6:A69,\"><*\")+1)","v":""}]
["1.10","8.3.4","Removal of site Establishment","Sum",1]
[{"$f":"IF(E76=0,\"\",$A$5&COUNTIF($A$6:A75,\"><*\")+1)","v":""}]
["1.11","PSA 8.4","TIME RELATED ITEMS"]
[{"$f":"IF(E78=0,\"\",$A$5&COUNTIF($A$6:A77,\"><*\")+1)","v":""}]
["1.12","8.4.1","Contractual requirements","Month",18]
[{"$f":"IF(E80=0,\"\",$A$5&COUNTIF($A$6:A79,\"><*\")+1)","v":""}]
["1.13","PSA 8.4.3b","Contractor's Supervision for the duration of construction","Month",18]
[]
[{"$f":"IF(E83=0,\"\",$A$2&COUNTIF($A$3:A82,\"><*\")+1)","v":""},"TOTAL CARRIED FORWARD ",{"$nulls":4},{"$f":"SUM(G5:G82)","v":0}]
[{"$f":"IF(E84=0,\"\",$A$2&COUNTIF($A$3:A83,\"><*\")+1)","v":""},"TOTAL BROUGHT FORWARD",{"$nulls":4},{"$f":"G83","v":0}]
[null,null,"Operation & Maintenance of Facilities on Site"]
[]
["1.14","PSA 8.4.2","Facilities for Engineer:"]
[{"$f":"IF(E88=0,\"\",$A$5&COUNTIF($A$6:A85,\"><*\")+1)","v":""}]
[null,null,"a) Engineers Office Type 2 ","Month",18]
[{"$f":"IF(E90=0,\"\",$A$5&COUNTIF($A$6:A89,\"><*\")+1)","v":""}]
[null,null,"b) JW Engineering Team (No.2) ","Month",18]
[]
[null,null,"c) QCO's and CLO Office (No.2)","Month",18]
[]
[null,null,"d) Boardroom (No:1)","Month",18]
[{"$f":"IF(E96=0,\"\",$A$5&COUNTIF($A$6:A95,\"><*\")+1)","v":""}]
[null,null,"e) Parking (No.2)","Month",18]
[{"$f":"IF(E98=0,\"\",$A$5&COUNTIF($A$6:A97,\"><*\")+1)","v":""}]
[null,null,"f) Nameboards (No.4)","Month",18]
[{"$f":"IF(E100=0,\"\",$A$5&COUNTIF($A$6:A99,\"><*\")+1)","v":""}]
[null,null,"g) Communication ","Month",18]
[]
[null,null,"h) Telephone and Computer facilities for Complaints Handler Team (No.4)","Month",18]
[]
[null,null,"i) Ablution and latrine facilities","Month",18]
[]
["1.15","PSA 8.4.3","Facilities for the Contractor:"]
[null,null,"a)Contractor's head office overhead costs for the duration of the Contract","Month",18]
[]
[null,null,"c) Offices and storage sheds","Month",18]
[{"$f":"IF(E111=0,\"\",$A$5&COUNTIF($A$6:A110,\"><*\")+1)","v":""}]
[null,null,"d) Ablution and latrine facilities","Month",18]
[{"$f":"IF(E113=0,\"\",$A$5&COUNTIF($A$6:A112,\"><*\")+1)","v":""}]
[null,null,"e) Tools and equipment","Month",18]
[{"$f":"IF(E115=0,\"\",$A$5&COUNTIF($A$6:A114,\"><*\")+1)","v":""}]
[null,null,"f) Water supplies, electric power and communications","Month",18]
[{"$f":"IF(E117=0,\"\",$A$5&COUNTIF($A$6:A116,\"><*\")+1)","v":""}]
[null,null,"g) Dealing with water (SANS 1200A 5.5)","Month",18]
[{"$f":"IF(E119=0,\"\",$A$5&COUNTIF($A$6:A118,\"><*\")+1)","v":""}]
[null,null,"h) Access (see sub-clause 5.8)","Month",18]
[]
["1.16","PSA 8.4.4","OHS Act Obligations","Month",18]
[{"$f":"IF(E123=0,\"\",$A$5&COUNTIF($A$6:A120,\"><*\")+1)","v":""}]
["1.17","PSA 8.4.5","EMP Obligations","Month",18]
[]
["1.18","PSA 8.4.6","Security Services","Month",18]
[]
["1.19","PSA 8.4.7","Contractor's Supervision of SMMEs for the duration of construction","Month",18]
[]
["1.20","PSA 8.4.8","Facilities for SMMEs Time Related Items"]
[]
[null,null,"a) Storage Facilitities","Month",18]
[]
[null,null,"b) Tools and equipment","Month",18]
[]
[null,null,"c) Other time related obligations","Month",18]
[]
["1.21","PSA 8.4.9","Satellite Facilities for CLO & QCO Team"]
[]
[null,null,"a) Office for CLO & QCO Team Type 2 (No,4)","Month",18]
[]
[null,null,"b) Water supplies and electric power ","Month",18]
[]
[null,null,"c) Ablution & Latrine facilities","Month",18]
[]
[null,null,"d) Security services","Month",18]
[]
[]
[]
[]
[]
[{"$f":"IF(E152=0,\"\",$A$2&COUNTIF($A$3:A151,\"><*\")+1)","v":""},"TOTAL CARRIED FORWARD ",{"$nulls":4},{"$f":"SUM(G84:G151)","v":0}]
[{"$f":"IF(E153=0,\"\",$A$2&COUNTIF($A$3:A152,\"><*\")+1)","v":""},"TOTAL BROUGHT FORWARD",{"$nulls":4},{"$f":"G152","v":0}]
[{"$f":"IF(E154=0,\"\",$A$5&COUNTIF($A$6:A151,\"><*\")+1)","v":""}]
["1.23","PSA 8.5","PROVISIONAL SUMS STATED BY ENGINEER"]
[{"$f":"IF(E156=0,\"\",$A$5&COUNTIF($A$6:A155,\"><*\")+1)","v":""}]
[null,null,"a) Community Liaison Officer\nSalaries and cellphone allowance(No 6)","Prov. Sum",1,{"v":1404000,"d":"R1,404,000.00"},{"$f":"E157*F157","v":{"v":1404000,"d":"R1,404,000.00"}}]
[{"$f":"IF(E158=0,\"\",$A$5&COUNTIF($A$6:A157,\"><*\")+1)","v":""}]
[null,null,"b) JW Communications and Complaints Handling team","Prov. Sum",1,{"v":1433300,"d":"R1,433,300.00"},{"$f":"E159*F159","v":{"v":1433300,"d":"R1,433,300.00"}}]
[{"$f":"IF(E160=0,\"\",$A$5&COUNTIF($A$6:A159,\"><*\")+1)","v":""}]
[null,null,"c) Community awareness material ","Prov. Sum",1,{"v":100000,"d":"R100,000.00"},{"$f":"E161*F161","v":{"v":100000,"d":"R100,000.00"}}]
[{"$f":"IF(E162=0,\"\",$A$5&COUNTIF($A$6:A161,\"><*\")+1)","v":""}]
[null,null,"d) QCF and QCO(No:5)","Prov. Sum",1,{"v":1980000,"d":"R1,980,000.00"},{"$f":"E163*F163","v":{"v":1980000,"d":"R1,980,000.00"}}]
[]
[null,null,"e) Training but not limited to the following: Plumbing ","Prov. Sum",1,{"v":300000,"d":"R300,000.00"},{"v":300000,"d":"R300,000.00"}]
[]
[null,null,"f) MIS System or similar approved Training","Prov. Sum",1,{"v":100000,"d":"R100,000.00"},{"$f":"E167*F167","v":{"v":100000,"d":"R100,000.00"}}]
[]
[null,null,"g) Reinstatement of Asphalt by JRA","Prov. Sum",1,{"v":200000,"d":"R200,000.00"},{"$f":"E169*F169","v":{"v":200000,"d":"R200,000.00"}}]
[]
[]
["1.23.1",null,"Overheads, charges and profit on item 1.23 (a) to 1.23 (g)","%",{"$f":"SUM(G157:G170)","v":{"v":5517300,"d":"R5,517,300.00"}}]
[]
["1.24","8.8","TEMPORARY WORKS"]
[]
[null,"8.8.4","Existing Services"]
[]
[null,"PSA 8.4.12","a) Excavation by hand in all material to expose existing services","m3",{"v":2000,"d":"2,000.00"}]
[{"$f":"IF(E179=0,\"\",$A$5&COUNTIF($A$6:A172,\"><*\")+1)","v":""}]
[null,"PSA 8.4.13","b) Temporary protection of services","Sum",1]
[]
[null,"PSA 8.4.14","c)Accomodation of traffic ","Sum",1]
[]
[null,"PSA 8.4.15","d) Provision of photographic records","Sum",1]
[]
["1.25","PSA 8.16","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 Employer's Agent)"]
[{"$f":"IF(E187=0,\"\",$A$5&COUNTIF($A$6:A186,\"><*\")+1)","v":""}]
["1.25.1",null,"Labour"]
[{"$f":"IF(E189=0,\"\",$A$5&COUNTIF($A$6:A188,\"><*\")+1)","v":""}]
[null,null,"a) Unskilled","hr",150]
[{"$f":"IF(E191=0,\"\",$A$5&COUNTIF($A$6:A190,\"><*\")+1)","v":""}]
[null,null,"b) Semi skilled","hr",150]
[{"$f":"IF(E193=0,\"\",$A$5&COUNTIF($A$6:A192,\"><*\")+1)","v":""}]
[null,null,"c) Skilled","hr",150]
[{"$f":"IF(E195=0,\"\",$A$5&COUNTIF($A$6:A194,\"><*\")+1)","v":""}]
[null,null,"d) Armed Security guard","hr",150]
[{"$f":"IF(E197=0,\"\",$A$5&COUNTIF($A$6:A196,\"><*\")+1)","v":""}]
["1.25.2",null,"TLB's (Tractor loader backhoe)"]
[{"$f":"IF(E199=0,\"\",$A$5&COUNTIF($A$6:A198,\"><*\")+1)","v":""}]
[null,null,"a) 2x4","hr",150]
[{"$f":"IF(E201=0,\"\",$A$5&COUNTIF($A$6:A200,\"><*\")+1)","v":""}]
[null,null,"b) 4x4","hr",150]
[{"$f":"IF(E203=0,\"\",$A$5&COUNTIF($A$6:A202,\"><*\")+1)","v":""}]
["1.25.3",null,"Compactors"]
[{"$f":"IF(E205=0,\"\",$A$5&COUNTIF($A$6:A204,\"><*\")+1)","v":""}]
[null,null,"a) Wacker","hr",48]
[{"$f":"IF(E207=0,\"\",$A$5&COUNTIF($A$6:A206,\"><*\")+1)","v":""}]
[null,null,"b) Plate compactor","hr",48]
[{"$f":"IF(E209=0,\"\",$A$5&COUNTIF($A$6:A208,\"><*\")+1)","v":""}]
["1.25.4",null,"Generator (Wet Rate)"]
[{"$f":"IF(E211=0,\"\",$A$5&COUNTIF($A$6:A210,\"><*\")+1)","v":""}]
[null,null,"a) 3kVA","hr",100]
[{"$f":"IF(E213=0,\"\",$A$5&COUNTIF($A$6:A212,\"><*\")+1)","v":""}]
[null,null,"b) 5kVa","hr",100]
{"$rows_empty":18}
[{"$f":"IF(E233=0,\"\",$A$5&COUNTIF($A$6:A208,\"><*\")+1)","v":""},"TOTAL CARRIED FORWARD TO SUMMARY"]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[]
[2,"SANS 1200C","SCHEDULE B:  SITE CLEARANCE"]
[]
["2.1","PSC 8.2.1","Clear and grub (2 metre width)","m",8300]
[]
["2.2","PSC 8.2.14","Protection of trees as ordered by Engineer","No",200]
[]
["2.3","8.2.10","Remove topsoil to nominal depth of 150mm and stockpile for re-use as directed by Engineer","m3",{"v":2177.641463414634,"d":"2178"}]
[]
["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",{"v":2021.9512195121952,"d":"2022"}]
[]
[null,null,"ii) Asphalt (≥  50 - 100mm thickness)","m2",{"v":1213.1707317073171,"d":"1213"}]
[]
[null,null,"iii) Interlocking concrete segmental paving blocks (all colours)","m2",{"v":6065.8536585365855,"d":"6066"}]
[]
[null,null,"iv) Concrete slabs (450 x 450mm)","m2",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"v) Brick paving","m2",{"v":3235.121951219512,"d":"3235"}]
[]
[null,null,"vi) Grassing and vegetation","m2",{"v":1617.560975609756,"d":"1618"}]
[]
[null,null,"vii) Unreinforced concrete <75mm thick","m³",{"v":4043.9024390243903,"d":"4044"}]
[]
[null,null,"viii) Reinforced concrete <75mm thick","m³",{"v":1010.9756097560976,"d":"1011"}]
[]
[null,null,"ix) Kerbing (All types of kerbs)","m",{"v":3235.121951219512,"d":"3235"}]
[]
[null,null,"x) Dump rock/Stone pitching","m³",{"v":485.2682926829268,"d":"485"}]
[]
[null,null,"xi) Steel palisade","m",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"xii) Concrete palisade","m",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"xiii) Removal of all other fences","m",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"xiv) Demolish of 115mm brick boundary wall","m",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"xv) Demolish of 230mm brick boundary wall","m",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"xvi) Tiles ","m2",{"v":2021.9512195121952,"d":"2022"}]
[]
["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":4246.09756097561,"d":"4246"}]
[]
[null,null,"ii) Concrete slabs (450 x 450mm)","m2",{"v":283.0731707317073,"d":"283"}]
[]
[null,null,"iii) Brick paving","m2",{"v":2264.5853658536585,"d":"2265"}]
[]
[null,null,"iv) Grassing and vegetation","m2",{"v":808.780487804878,"d":"809"}]
[]
[null,null,"v) Kerbing (All types of kerbs)","m",{"v":2264.5853658536585,"d":"2265"}]
[]
[null,null,"vi) Dump rock/Stone pitching","m³",{"v":242.6341463414634,"d":"243"}]
["TOTAL CARRIED FORWARD ",{"$nulls":5},{"$f":"SUM(G238:G294)","v":0}]
["TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"G295","v":0}]
[]
["2.6","PSC 8.2.12","a) Backfilling and reinstatement of footways and driveways using new materials "]
[]
[null,null,"i) Asphalt (≤ 50mm thickness)","m2",{"v":2021.9512195121952,"d":"2022"}]
[]
[null,null,"ii) Asphalt (≥  50 - 100mm thickness)","m2",{"v":1213.1707317073171,"d":"1213"}]
[]
[null,null,"iii) Interlocking concrete segmental paving blocks (all colours)","m2",{"v":1819.7560975609756,"d":"1820"}]
[]
[null,null,"iv) Concrete slabs (450 x 450mm)","m2",{"v":121.3170731707317,"d":"121"}]
[]
[null,null,"v) Brick paving all colours","m2",{"v":970.5365853658536,"d":"971"}]
[]
[null,null,"vi) Grassing and vegetation","m2",{"v":808.780487804878,"d":"809"}]
[]
[null,null,"vii) Unreinforced concrete <75mm thick","m³",{"v":4043.9024390243903,"d":"4044"}]
[]
[null,null,"viii) Reinforced concrete <75mm thick","m³",{"v":1010.9756097560976,"d":"1011"}]
[]
[null,null,"ix) Kerbing (All types of kerbs)","m",{"v":970.5365853658536,"d":"971"}]
[]
[null,null,"x) Dump rock/Stone pitching","m³",{"v":242.6341463414634,"d":"243"}]
[]
[null,null,"xi) Steel palisade","m",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"xii) Concrete palisade","m",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"xiii) All other fences","m",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"xiv) 115mm brick boundary wall including plastering","m",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"xv) 230mm brick boundary wall including plastering","m",{"v":404.390243902439,"d":"404"}]
[]
[null,null,"xvi) Tiles ","m2",{"v":2021.9512195121952,"d":"2022"}]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G296:G331)","v":0}]
["Item No.","Payment Clause","Description","Unit","Qty","RATE","AMOUNT"]
[3,"SANS 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³",{"v":10595.024390243903,"d":"10595"}]
[]
[null,null,"b) Over 1,5m and up to 2,5m","m³",{"v":2119.0048780487805,"d":"2119"}]
[]
[null,null,"c) Over 2,5m","m³",{"v":529.7512195121951,"d":"530"}]
[]
["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³",{"v":7076.829268292683,"d":"7077"}]
[]
[null,null,"b) Over 1,0m and up to 1,5m","m³",{"v":3538.4146341463415,"d":"3538"}]
[]
[null,null,"c) Over 1,5m","m³",{"v":1769.2073170731708,"d":"1769"}]
[]
["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³",{"v":4238.009756097561,"d":"4238"}]
[]
[null,null,"b) Hard excavation.","m³",{"v":3178.5073170731707,"d":"3179"}]
[]
[null,null,"c) Rock excavation","m³",{"v":1059.5024390243902,"d":"1060"}]
[]
["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³",{"v":2264.5853658536585,"d":"2265"}]
[]
[null,null,"b) by importation from designated borrow pits","m³",{"v":452.9170731707317,"d":"453"}]
[]
[null,null,"c) by importation from commercial or off site sources selected by the Contractor","m³",{"v":1132.2926829268292,"d":"1132"}]
[null,null," "]
["3.3","PSDB 8.3.3.3","a) Additional compaction to 95% mod AASHTO density in road crossings","m³",{"v":808.780487804878,"d":"809"}]
[]
["3.4","PSDB 8.3.4 (a)","a)Shore trench opposite structure or service for depths:","m",{"v":808.780487804878,"d":"809"}]
[]
["TOTAL CARRIED FORWARD ",{"$nulls":5},{"$f":"SUM(G334:G375)","v":0}]
["TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"G376","v":0}]
["3.5","PSDB 8.3.5(a)","a) Services that intersect a trench"]
[]
[null,null,"i) Water house connections.","No.",5000]
[]
[null,null,"ii) Sewer pipes up to 300mm Dia.","No.",2500]
[]
[null,null,"iii) Cables.","No.",{"v":6065.8536585365855,"d":"6066"}]
[]
[null,null,"iv) Stormwater pipes up to 1050mm dia.","No.",1500]
[]
[null,null,"v) Kerbs and Channels","No.",500]
[]
[null,null,"vi) Water pipes of any diameter","No.",2500]
[]
[null,null,"vii) Irrigation pipes","No.",250]
[]
["3.6","PSDB 8.3.5 (b)","b) Services that adjoin a trench"]
[]
[null,null,"i) Water house connections","m",{"v":1617.560975609756,"d":"1618"}]
[]
[null,null,"ii) Sewer pipes up to 600mm Dia.","m",{"v":3235.121951219512,"d":"3235"}]
[]
[null,null,"iii) Cables.","m",{"v":8087.804878048781,"d":"8088"}]
[]
[null,null,"iv) Stormwater pipes up to 1050mm dia.","m",{"v":3235.121951219512,"d":"3235"}]
[]
[null,null,"v) Kerbs and Channels","m",{"v":3235.121951219512,"d":"3235"}]
[]
[null,null,"vi) Water pipes of any diameter","m",{"v":4043.9024390243903,"d":"4044"}]
[]
[null,null,"vii) Irrigation pipes","m",{"v":1617.560975609756,"d":"1618"}]
[]
["3.7","PSDB 8.3.5( c )","Services that require special care","No",{"v":202.1951219512195,"d":"202"}]
[]
["3.8","PSDB 8.3.6","Trimming of tree roots on pipe alignment( This item will be measured as number of trees)","No",200]
["CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G377:G412)","v":0}]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[4,"SANS 1200LB","SCHEDULE D: BEDDING (PIPES)"]
[]
["4.1"," PSLB 8.2.1","Provision of bedding from trench excavation"]
[]
[null,null,"a) Selected granular material","m³",{"v":2354.36,"d":"2,354"}]
[]
[null,null,"b) Selected fill material","m³",{"v":1148.4682926829269,"d":"1,148"}]
[]
[null,"PSLB 8.2.1.1","c) Extra over item 4.1(a) and (b) for sieving where ordered by Engineer","m³",{"v":1177.18,"d":"1,177"}]
[]
["4.2","8.2.2.3","Provision of bedding imported from commercial sources (Provisional) "]
[]
[null,null,"a) Selected granular material ","m³",{"v":1177.18,"d":"1,177"}]
[null,null,"b) Selected fill material ","m³",{"v":574.2341463414634,"d":"574"}]
[null,"PSLB 8.2.2.3  (c )","c) 19mm Crushed stones bedding ","m³",{"v":235.436,"d":"235"}]
[]
["4.3","8.2.4","a) Encasing of pipe in 20MPa concrete (Provisional)","m³",{"v":404.390243902439,"d":"404"}]
[]
[]
[null,"PSLB 8.2.3","b) Concrete for Thrust/anchor blocks (including all required formwork) as per detail JW100-DET05-W01","m³",{"v":404.390243902439,"d":"404"}]
{"$rows_empty":15}
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G415:G449)","v":0}]
["Item No.","Payment Clause","Description","Unit"," Qty","Rate","Amount"]
[5,"SANS 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",{"$f":"2050+2310","v":4360}]
[null,null,"ii) DN160","m",870]
[null,null,"iii) DN200","m",725]
[null,null,"iv) DN250","m",1615]
[null,null,"v) DN315","m",60]
[]
[null,null,"b) Supply, lay, bed (class B bedding), all test and disinfect, backfill complete joints to be butt welded or electro fusion, HDPE PE100 SDR11 PN16 pipes:"]
[]
[null,null,"i) DN110","m",50]
[null,null,"ii) DN160","m",10]
[null,null,"iii) DN180","m",10]
[null,null,"iv) DN200","m",10]
[null,null,"v) DN225","m",10]
[null,null,"vi) DN250","m",10]
[null,null,"vii) DN315","m",10]
[null,null,"viii) DN355","m",10]
[]
[null,null,"c) Supply, handle, lay, bed (Class B bedding), backfill complete, all test and disinfect 10mm thick Grade X42/300WA continuosly welded steel pipes, cement mortar lining or similar approved, fusion bonded medium density polyethylene (sintakote 2) or polyclad 777 coating or similar approved with Spigot and Socket Joints "]
[null,null,"i) DN400","m",450]
[null,null,"ii) DN600","m",10]
[null,null,"iii) DN760","m",265]
[]
[]
["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":"E482*F482","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":"G482","v":{"v":2000000,"d":"R2,000,000.00"}}]
[]
["5.1.5","PSL 8.2.4","River Crossings ","Prov.Sum",1,{"v":1500000,"d":"R1,500,000.00"},{"$f":"E486*F486","v":{"v":1500000,"d":"R1,500,000.00"}}]
[]
["5.1.6",null,"Extra over items 5.1.5 above for overhead charges and profit","%",{"v":1500000,"d":"R1,500,000.00"}]
[]
["5.2",null,"Fittings to suit High Impact Class 16 mPVC 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",50]
[null,null,"ii) 22.5°","No",50]
[null,null,"iii) 45°","No",50]
[null,null,"iv) 90°","No",50]
[null,null,"DN160"]
[null,null,"i) 11¼°","No",20]
[null,null,"ii) 22.5°","No",20]
[null,null,"iii) 45°","No",20]
[null,null,"iv) 90°","No",20]
[null,null,"DN200"]
[null,null,"i) 11¼°","No",20]
[null,null,"ii) 22.5°","No",20]
[null,null,"iii) 45°","No",20]
[null,null,"iv) 90°","No",20]
[null,null,"DN250"]
[null,null,"i) 11¼°","No",20]
[null,null,"ii) 22.5°","No",20]
[null,null,"iii) 45°","No",20]
[null,null,"iv) 90°","No",20]
[null,null,"DN315"]
[null,null,"i) 11¼°","No",1]
[null,null,"ii) 22.5°","No",1]
[null,null,"iii) 45°","No",1]
[null,null,"iv) 90°","No",1]
["TOTAL CARRIED FORWARD "]
["TOTAL BROUGHT FORWARD"]
[]
["5.2.2","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",10]
[null,null,"ii) 200mm x 100mm dia.","No",5]
[null,null,"iii) 200mm x 150mm dia.","No",5]
[null,null,"iv) 250mm x 100mm dia.","No",5]
[null,null,"v) 250mm x 150mm dia.","No",5]
[null,null,"vi) 250mm x 200mm dia.","No",5]
[null,null,"vii) 300mm x 100mm dia.","No",5]
[null,null,"viii) 300mm x 150mm dia.","No",5]
[null,null,"ix) 300mm x 200mm dia.","No",5]
[null,null,"x) 300mm x 250mm dia.","No",5]
[]
["5.2.3","8.2.2","c) Steel Tees Fusion Bonded Epoxy coated 250 microns to suit High Impact mPVC piping including thrust block"]
[]
[null,null,"i) 100mm dia. equal tee","No",25]
[null,null,"ii) 150mm dia. equal tee","No",5]
[null,null,"iii) 200mm dia. equal tee","No",5]
[null,null,"iv) 150mm x 100mm dia. reducing tee","No",5]
[null,null,"v) 200mm x 100mm dia. reducing tee","No",5]
[null,null,"vi) 200mm x 150mm dia. reducing tee","No",5]
[null,null,"vii) 250mm equal Tee","No",5]
[null,null,"viii) 250mm x 100mm dia reducing Tee","No",5]
[null,null,"ix) 250mm x 150mm dia reducing Tee","No",5]
[null,null,"x)  250mm x 200mm dia reducing Tee","No",5]
[null,null,"xi) 300mm equal Tee","No",5]
[null,null,"xii) 300mm x 100mm dia reducing Tee","No",5]
[null,null,"xiii) 300mm x 150mm dia reducing Tee","No",5]
[null,null,"xiv)  300mm x 200mm dia reducing Tee","No",5]
[null,null,"xv)  300mm x 250mm dia reducing Tee","No",5]
[]
["5.2.4",null,"d) 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",10]
[null,null,"ii) 150mm dia. equal cross","No",5]
[null,null,"iii) 200mm dia. equal cross","No",5]
[null,null,"iv) 150mm x 100mm dia. unequal cross","No",5]
[null,null,"v) 200mm x 100mm dia. unequal cross","No",5]
[null,null,"vi) 200mm x 150mm dia. unequal cross","No",5]
[null,null,"vii) 250mm equal cross","No",5]
[null,null,"viii) 250mm x 100mm dia unequal cross","No",5]
[null,null,"ix) 250mm x 150mm dia unequal cross","No",5]
[null,null,"x)  250mm x 200mm dia. unequal cross","No",5]
[null,null,"xi) 300mm equal cross","No",5]
[null,null,"xii) 300mm x 100mm dia. unequal cross","No",5]
[null,null,"xiii) 300mm x 150mm dia unequal cross","No",5]
[null,null,"xiv)  300mm x 200mm dia unequal cross","No",5]
[null,null,"xv)  300mm x 250mm dia unequal cross","No",5]
[]
["5.2.5",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",10]
[null,null,"ii) DN160","No",5]
[null,null,"iii) DN200","No",5]
[null,null,"iv) DN250","No",5]
[null,null,"v) DN315","No",5]
[]
[null,null,"Extra-over item 8.2.2 for encasing joints (Denso wrapping or similar approved of metal joints).","No",200]
[]
["TOTAL CARRIED FORWARD ",{"$nulls":5},{"$f":"SUM(G520:G580)","v":0}]
["TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"G581","v":0}]
[]
["5.2.6",null,"Fittings to suit HDPE PN 16 SDR 11 PE 100 pipes"]
[null,"8.2.2","a) Extruded bends for HDPE pipe PN16 SDR11 PE100"]
[null,null,"i) 90⁰ bend for 110 diameter pipe","No",1]
[null,null,"ii) 90⁰ bend for 160 diameter pipe","No",1]
[null,null,"iv) 90⁰ bend for 200 diameter pipe","No",1]
[null,null,"v) 90⁰ bend for 225 diameter pipe","No",1]
[null,null,"vi) 90⁰ bend for 250 diameter pipe","No",1]
[null,null,"vii) 90⁰ bend for 315 diameter pipe","No",1]
[null,null,"ix) 45⁰ bend for 110 diameter pipe","No",1]
[null,null,"x) 45⁰ bend for 160 diameter pipe","No",1]
[null,null,"xii) 45⁰ bend for 200 diameter pipe","No",1]
[null,null,"xiii) 45⁰ bend for 225 diameter pipe","No",1]
[null,null,"xiv) 45⁰ bend for 250 diameter pipe","No",1]
[null,null,"xv) 45⁰ bend for 315 diameter pipe","No",1]
[null,null,"xvii) 22.5⁰ bend for 110 diameter pipe","No",1]
[null,null,"xviii) 22.5⁰ bend for 160 diameter pipe","No",1]
[null,null,"xx) 22.5⁰ bend for 200 diameter pipe","No",1]
[null,null,"xxi) 22.5⁰ bend for 225 diameter pipe","No",1]
[null,null,"xxii) 22.5⁰ bend for 250 diameter pipe","No",1]
[null,null,"xxii) 22.5⁰ bend for 315 diameter pipe","No",1]
[null,null,"xxv) 11¼⁰ bend for 110 diameter pipe","No",1]
[null,null,"xxvii) 11¼⁰ bend for 180 diameter pipe","No",1]
[null,null,"xxviii) 11¼⁰ bend for 200 diameter pipe","No",1]
[null,null,"xxix) 11¼⁰ bend for 225 diameter pipe","No",1]
[null,null,"xxx) 11¼⁰ bend for 250 diameter pipe","No",1]
[null,null,"xxxi) 11¼⁰ bend for 315 diameter pipe","No",1]
[]
["5.2.7","8.2.2","b) Stub and Flange for HDPE PN16 PE100 SDR11"]
[null,null,"i) Stub and Flange for 110 diameter pipe","No",1]
[null,null,"ii) Stub and Flange for 160 diameter pipe","No",1]
[null,null,"iii) Stub and Flange for 180 diameter pipe","No",1]
[null,null,"iv) Stub and Flange for 200 diameter pipe","No",1]
[null,null,"v) Stub and Flange for 225 diameter pipe","No",1]
[null,null,"vi) Stub and Flange for 250 diameter pipe","No",1]
[null,null,"vii) Stub and Flange for 315 diameter pipe","No",1]
[]
["5.2.8","8.2.2","c) HDPE Equal Tees for PN16 PE100 SDR11"]
[null,null,"i) DN 110mm","No",1]
[null,null,"ii) DN 160mm","No",1]
[null,null,"iii) DN 180mm","No",1]
[null,null,"iv) DN 200mm","No",1]
[null,null,"v) DN 225mm","No",1]
[null,null,"vi) DN 250mm","No",1]
[null,null,"vii) DN 315mm","No",1]
[]
["5.2.9",null,"d) HDPE Reducing Tees for PN16 PE100 SDR11"]
[null,null,"i) 160mm x 110mm","No",1]
[null,null,"ii) 180mm x 110mm","No",1]
[null,null,"iii) 180mm x 160mm","No",1]
[null,null,"iv) 200mm x 110mm","No",1]
[null,null,"v) 200mm x 160mm","No",1]
[null,null,"vi) 200mm x 180mm","No",1]
[null,null,"vii) 225mm x 110mm","No",1]
[null,null,"viii) 225mm x 160mm","No",1]
[null,null,"ix) 225mm x 180mm","No",1]
[null,null,"x) 225mm x 200mm","No",1]
[null,null,"xi) 250mm x 110mm","No",1]
[null,null,"xii) 250mm x 160mm","No",1]
[null,null,"xiii) 250mm x 180mm","No",1]
[null,null,"xiv) 250mm x 200mm","No",1]
[null,null,"xv) 315mm x 110mm","No",1]
[null,null,"xvi) 315mm x 160mm","No",1]
[null,null,"xvii) 315mm x 180mm","No",1]
[null,null,"xviii) 315mm x 200mm","No",1]
[null,null,"xix) 315mm x 225mm","No",1]
[null,null,"xx) 315mm x 250mm","No",1]
[]
["TOTAL CARRIED FORWARD ",{"$nulls":5},{"$f":"SUM(G582:G650)","v":0}]
["TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"G651","v":0}]
["5.2.10",null,"e) HDPE Reducers for PN16 PE100 SDR11"]
[null,null,"i) 125mm x 110mm","No",1]
[null,null,"ii) 160mm x 110mm","No",1]
[null,null,"iii) 180mm x 110mm","No",1]
[null,null,"iv) 180mm x 160mm","No",1]
[null,null,"v) 200mm x 110mm","No",1]
[null,null,"vi) 200mm x 160mm","No",1]
[null,null,"vii) 200mm x 180mm","No",1]
[null,null,"viii) 225mm x 110mm","No",1]
[null,null,"ix) 225mm x 160mm","No",1]
[null,null,"x) 225mm x 180mm","No",1]
[null,null,"xi) 225mm x 200mm","No",1]
[null,null,"xii) 250mm x 110mm","No",1]
[null,null,"xiii) 250mm x 160mm","No",1]
[null,null,"xiv) 250mm x 180mm","No",1]
[null,null,"xv) 250mm x 200mm","No",1]
[null,null,"xvi) 250mm x 225mm","No",1]
[null,null,"xvii) 315mm x 110mm","No",1]
[null,null,"xviii) 315mm x 160mm","No",1]
[null,null,"xix) 315mm x 180mm","No",1]
[null,null,"xx) 315mm x 200mm","No",1]
[null,null,"xxi) 315mm x 225mm","No",1]
[null,null,"xxii) 315mm x 250mm","No",1]
[]
["5.2.11",null,"f) HDPE Equal Crosses for PN16 PE100 SDR11"]
[null,null,"i) DN 110mm","No",1]
[null,null,"ii) DN 160mm","No",1]
[null,null,"iii) DN 180mm","No",1]
[null,null,"iv) DN 200mm","No",1]
[null,null,"v) DN 225mm","No",1]
[null,null,"vi) DN 250mm","No",1]
[null,null,"vii) DN 315mm","No",1]
[]
["5.2.12",null,"g) HDPE Unequal Crosses for PN16 PE100 SDR11"]
[]
[null,null,"i) 160mm x 110mm","No",1]
[null,null,"ii) 180mm x 110mm","No",1]
[null,null,"iii) 180mm x 160mm","No",1]
[null,null,"iv) 200mm x 110mm","No",1]
[null,null,"v) 200mm x 160mm","No",1]
[null,null,"vi) 200mm x 180mm","No",1]
[null,null,"vii) 225mm x 110mm","No",1]
[null,null,"viii) 225mm x 160mm","No",1]
[null,null,"ix) 225mm x 180mm","No",1]
[null,null,"x) 225mm x 200mm","No",1]
[null,null,"xi) 250mm x 110mm","No",1]
[null,null,"xii) 250mm x 160mm","No",1]
[null,null,"xiii) 250mm x 180mm","No",1]
[null,null,"xiv) 250mm x 200mm","No",1]
[null,null,"xv) 315mm x 110mm","No",1]
[null,null,"xvi) 315mm x 160mm","No",1]
[null,null,"xvii) 315mm x 180mm","No",1]
[null,null,"xviii) 315mm x 200mm","No",1]
[null,null,"xix) 315mm x 225mm","No",1]
[null,null,"xx) 315mm x 250mm","No",1]
[]
[]
[]
[]
["TOTAL CARRIED FORWARD ",{"$nulls":5},{"$f":"SUM(G652:G711)","v":0}]
["TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"G712","v":0}]
["5.3",null,"VALVES AND FIRE HYDRANTS"]
[]
["5.3.1","PSL 8.2.19 (a)","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",10]
[null,null,"ii) DN150 RSV Class 16 Non rising spindle Detail JW100-DET03-W01","No",5]
[null,null,"iii) DN200 Wedge Type Class 16 Non rising spindle Detail JW100-DET03-W01","No",5]
[null,null,"iv) DN 250 Wedge Type Class 16 Non rising spindle Detail JW100-DET03-W01","No",5]
[null,null,"v) DN 300 Wedge Type Class 16 Non rising spindle, geared Detail JW100-DET03-W01","No",5]
[null,null,"vi) DN 700 Wedge Type Class 16 Non rising spindle, geared Detail JW100-DET03-W01","No",1]
[]
[]
["5.3.2","PSL 8.2.19.1","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",10]
[null,null,"ii) DN80 fire Hydrant mailine 160mm dia","No",5]
[null,null,"iii) DN80 fire Hyadrant mainline 200mm dia","No",5]
[null,null,"iv) DN80 fire Hydrant mainline 250mm dia","No",5]
[null,null,"v) DN80 fire Hydrant mainline 315mm dia","No",1]
[]
["5.3.3","PSL 8.2.19 (b)","Supply, handle, fixing, lay, bed of single chamber flanged double acting air release valves, complete with all fittings for connection to main line as per detail JW100-DET14-W01. (Rate to include all fittings required including isolation valve, couplings,  wrapping of joints, chamber and cover , etc.) Air valves to be PN16 and Double Fusion  Epoxy Bonded  coated."]
[]
[null,null,"i) DN80","No",1]
[null,null,"ii) DN100","No",1]
[null,null,"iii) DN150","No",1]
[null,null,"iv) DN200","No",1]
[null,null,"v) DN250","No",1]
[]
["5.4","8.2.4","Extra-over 5.3.3 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",10]
[null,null,"ii) DN160","No",1]
[null,null,"iii) DN200","No",1]
[null,null,"iv) DN250","No",1]
[null,null,"v) DN315","No",1]
[]
["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",1]
[null,null,"ii) DN160","No",1]
[null,null,"iii) DN200","No",1]
[null,null,"iv) DN250","No",1]
[null,null,"v) DN315","No",1]
[]
["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",1]
[null,null,"ii) DN160","No",1]
[null,null,"iii) DN200","No",1]
[null,null,"iv) DN250","No",1]
[null,null,"v) DN315","No",1]
["TOTAL CARRIED FORWARD ",{"$nulls":5},{"$f":"SUM(G713:G761)","v":0}]
["TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"G762","v":0}]
[]
[]
["5.5","8.2.15","Special wrapping in corrosive soil per joint and as instructed by the Engineer","No",20]
[]
["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 HDPE/mPVC into existing steel/HDPE/AC/uPVC pipes for the following pipe sizes:"]
[null,null,"i) 100mm to 200mm","No",5]
[null,null,"ii) 201mm to 400mm","No",1]
[]
[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",5]
[null,null,"ii) 201mm to 400mm","No",5]
[]
[null,null,"c) Tying new 315mm-355mm HDPE/MPVC/OPVC into existing steel/HDPE/AC/uPVC pipe for the following pipe sizes:"]
[null,null,"i) 100mm to 200mm","No",5]
[null,null,"ii) 201mm to 400mm","No",5]
[]
["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",1]
[null,null,"ii) 201mm to 400mm","No",1]
[null,null,"iii) 401mm to 600mm","No",1]
[]
[null,null,"b) Tying new 200mm-250mm HDPE/MPVC into existing steel/HDPE pipe for the following pipe sizes:"]
[]
[null,null,"i) 100mm to 200mm","No",1]
[null,null,"ii) 201mm to 400mm","No",1]
[null,null,"iii) 401mm to 600mm","No",1]
[]
[null,null,"c) Tying new 315mm-355mm HDPE/MPVC/OPVC into existing steel/HDPE pipe for the following pipe sizes:"]
[]
[null,null,"i) 100mm to 200mm","No",1]
[null,null,"ii) 201mm to 400mm","No",1]
[null,null,"iii) 401mm to 600mm","No",1]
[]
["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",1000]
[null,null,"b) DN160 (HDPE pipe, Class 16 PE100 SDR 11)","m",10]
[null,null,"c) DN180 (HDPE pipe, Class 16 PE100 SDR 11)","m",10]
[null,null,"d) DN200 (HDPE pipe, Class 16 PE100 SDR 11)","m",10]
[null,null,"e) DN225 (HDPE pipe, Class 16 PE100 SDR 11)","m",10]
[null,null,"f) DN250 (HDPE pipe, Class 16 PE100 SDR 11)","m",10]
[null,null,"g) DN315 (HDPE pipe, Class 16 PE100 SDR 11)","m",10]
[]
["5.7.1",null,"Extra over item 5.7 for Horizontal Direction Drilling in rock material","m",10]
[]
["5.8",null,"Excavate in all materials Launching and reception shafts/pits","m³",20]
[]
["TOTAL CARRIED FORWARD ",{"$nulls":5},{"$f":"SUM(G763:G815)","v":0}]
["TOTAL BROUGHT FORWARD",{"$nulls":5},{"$f":"G816","v":0}]
["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",10]
[null,null,"2) 301mm to 600mm","No",10]
[null,null,"ii) Fire Hydrants all sizes","No",10]
[]
["5.10",null,"Close of valves","No ",5]
[]
["5.11",null,"Disconnecting pipes","No ",7]
[]
["5.12","PSL 8.2.21","Supply and install PRV complete with all fittings, including PRV Chamber as per Standard Drawing JW1000-STD-PRV01 to 04"]
[]
[null,null,"a) 150mm diameter","No",1]
[]
[null,null,"b) 200mm diameter","No",1]
{"$rows_empty":15}
["CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G817:G848)","v":0}]
["Item No.","Payment Clause","Description","Unit"," Qty","Rate","Amount"]
["6.","SANS1200 LF","SCHEDULE F: ERF CONNECTIONS (WATER)"]
[]
["6.1","SANS1200 DB","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³",2800]
[]
[null,null,"b) > 40mm - 50mm diameter","m³",560]
[]
["6.2","8.3.2 (b) ","Extra-over items (8.3.1 (a)) for"]
[]
[null,null,"i) Intermediate excavation","m³",840]
[]
[null,null,"ii) Hard rock excavation","m³",280]
[]
["6.3","SANS1200 LF","ERF CONNECTIONS"]
[]
["6.3.1","PSLF 8.2.9","Illegal erf connection locating and removal","No.",3500]
[]
["6.3.2","PSLF 8.2.10","Erf connection provision and installation\n"]
[null,null,"Domestic erf connections"]
[]
[null,null,"All erf connections HDPE"]
[]
[null,null," a) Single short erf connections","No.",200]
[]
[null,null," b) Double short erf connections","No.",100]
[]
[null,null," c) Single long erf connections","No.",200]
[]
[null,null," d) Double long erf connections","No.",100]
[]
["6.3.3","PSLF 8.2.11","HORIZONTAL DRILLING (LONG ERF CONNECTIONS)"]
[]
[null,null,"Supply and installation of pipe through horizontal drilling\n"]
[null,null,"a)20 mm diameter HDPE pipes","m",10]
[]
[null,null,"b) 25 mm diameter HDPE pipes","m",10]
[]
[null,null,"c) 32 mm diameter HDPE pipes","m",1000]
[]
[null,null,"c) 40 mm diameter HDPE pipes","m",10]
[]
["6.3.3.1",null,"Extra-over item 6.4.3for horizontal drilling through hard rock","m",10]
[]
["6.4",null,"VALVES"]
[null,"PSLF 8.2.12","Provision and installation of ball valves"]
["6.4.1",null,"a) Provision and installation of ball valves on existing and new erf connections. (Less than 500mm deep)"]
[]
[null,null,"1) 20 mm diameter ball valve","No.",10]
[]
[null,null,"2) 25 mm diameter ball valve","No.",5250]
[]
[null,null,"3) 32mm diameter ball valve","No.",10]
[]
[null,null,"4) 40mm diameter ball valve","No.",10]
[]
["6.4.2",null,"b) Provision and installation of ball valves on existing erf connections (More than 500mm deep)"]
[]
[null,null,"1) 20mm diameter ball valve","No.",10]
[]
[null,null,"2) 25 mm diameter ball valve","No.",1750]
[]
[null,null,"3) 32mm diameter ball valve","No.",10]
[]
[null,null,"4) 40mm diameter ball valve","No.",10]
[]
["6.4.3",null,"Extra-over above item for ball valve installation for existing pipes other than HDPE."]
[]
[null,null,"1) 20 mm diameter ball valve","No.",10]
[null,null,"2) 25 mm diameter ball valve","No.",10]
[null,null,"3) 32 mm diameter ball valve","No.",10]
[null,null,"4) 40mm diameter ball valve","No.",10]
[]
["6,.4.4",null,"Supply and install valve boxes for ball valves","No.",7000]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G851:G924)","v":0}]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[7,null,"SCHEDULE G: YARD CONNECTIONS"]
[]
["7.1","PA 8.2.17","YARD CONNECTIONS"]
[]
["7.1.1",null,"Provision and installation of yard connections ","Prov.Sum",1,{"v":5600000,"d":"R5,600,000.00"},{"$f":"E931*F931","v":{"v":5600000,"d":"R5,600,000.00"}}]
[]
["7.1.2",null,"Extra over items 7.1.1 above for overhead charges and profit","%",{"v":5600000,"d":"R5,600,000.00"},null,0]
[]
["7.2",null,"LEAK DETECTION"]
[]
["7.2.1","PA 8.2.19","Leak free tests","No.",{"v":7000,"d":"7,000"},null,{"$f":"E937*F937","v":0}]
{"$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(E972=0,\"\",$A$6&COUNTIF($A$7:A971,\"><*\")+1)","v":""}]
["8.1","PA 8.2.20","Preparation and delivery of notice to owner","No.",{"v":7000,"d":"7,000"},null,{"$f":"E973*F973","v":0}]
[]
["8.2","PA 8.2.21 ","100% pre-intervention survey on customer properties","No.",{"v":7000,"d":"7,000"},null,{"$f":"E975*F975","v":0}]
[]
["8.3","PA 8.2.22","Provision and installation of on-property plumbing retrofitting ","Prov.Sum",1,{"v":14700000,"d":"R14,700,000.00"},{"$f":"E977*F977","v":{"v":14700000,"d":"R14,700,000.00"}}]
[]
["8.3.1",null,"Extra over items 8.3 above for overhead charges and profit","%",{"v":14700000,"d":"R14,700,000.00"},null,{"$f":"E979*F979","v":0}]
{"$rows_empty":24}
[{"$f":"IF(E1004=0,\"\",$A$6&COUNTIF($A$7:A1003,\"><*\")+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(E1009=0,\"\",$A$7&COUNTIF($A$8:A1008,\"><*\")+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":7000,"d":"7,000"}]
[]
["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":7000,"d":"7,000"}]
[]
["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":7000,"d":"7,000"}]
[{"$f":"IF(E1015=0,\"\",$A$7&COUNTIF($A$8:A1010,\"><*\")+1)","v":""}]
["9.4","PF22.8","b) Installation of meter per stand","No.",{"v":7000,"d":"7,000"}]
[]
["9.5","PF22.2","TRAINING"]
[{"$f":"IF(E1019=0,\"\",$A$7&COUNTIF($A$8:A1018,\"><*\")+1)","v":""}]
["9.5.1","PF22.2.1","Training for Employer’s staff per session (20 people per group)","No.",10]
[{"$f":"IF(E1021=0,\"\",$A$7&COUNTIF($A$8:A1020,\"><*\")+1)","v":""}]
["9.5.2","PF22.2.3","Meter demonstration per stand by the Supplier’s technicians","No.",{"v":7000,"d":"7,000"}]
[{"$f":"IF(E1023=0,\"\",$A$7&COUNTIF($A$8:A1022,\"><*\")+1)","v":""}]
[{"$f":"IF(E1024=0,\"\",$A$7&COUNTIF($A$8:A1023,\"><*\")+1)","v":""}]
["9.6","PF22.3","TECHNICAL SUPPORT"]
[{"$f":"IF(E1026=0,\"\",$A$7&COUNTIF($A$8:A1025,\"><*\")+1)","v":""}]
["9.6.1","PF22.3.1","On- Site Support during construction","Month",18]
[{"$f":"IF(E1028=0,\"\",$A$7&COUNTIF($A$8:A1027,\"><*\")+1)","v":""}]
["9.6.2","PF22.3.2.1","After hours On-Ste Support","No",{"v":1000,"d":"1,000"}]
[{"$f":"IF(E1030=0,\"\",$A$7&COUNTIF($A$8:A1029,\"><*\")+1)","v":""}]
["9.6.3","PF 22.3.4","On-Site Support-for 3 years after completion of the contract. ","No ",{"v":7000,"d":"7,000"}]
[]
["9.6.4","PF22.4","Removal of existing meters ","No ",{"v":7000,"d":"7,000"}]
[]
["9.6.6","PF22.5","Provision and installation of bulk Meinecke WPD meters complete with logging facilities, specials and fittings including construction of chamber "]
[]
[null,null,"a) 150mm diameter ","No ",2]
[]
[null,null,"b) 200mm diameter ","No ",1]
[]
[null,null,"c) 300mm diameter ","No ",1]
[]
[null,null,"d) 350mm diameter ","No ",2]
[]
[null,null,"e) 400mm diameter ","No ",1]
[]
[null,null,"f) 450mm diameter ","No ",1]
[]
[null,null,"g) 650mm diameter ","No ",1]
[]
["TOTAL CARRIED FORWARD TO SUMMARY",{"$nulls":5},{"$f":"SUM(G1007:G1050)","v":0}]
["Item No.","Payment Clause","Description","Unit","Qty","Rate","Amount"]
[]
[]
["10.",null,"SCHEDULE J: OCCUPATIONAL HEALTH AND SAFETY"]
[{"$f":"IF(E1056=0,\"\",$A$7&COUNTIF($A$8:A1055,\"><*\")+1)","v":""}]
[]
[{"$f":"IF(E1058=0,\"\",$A$7&COUNTIF($A$8:A1056,\"><*\")+1)","v":""},"PO 1.1","SUPPLY OF ALL ITEMS OF PERSONAL PROTECTIVE CLOTHING/EQUIPMENT & ENSURE USE THEREOF FOR FULL COMPLIANCE"]
[]
["10.1",null,"a)Steel toe capped safety boots","No.",200,null,{"$f":"E1060*F1060","v":0}]
[]
["10.2",null,"b) Appropriate protective clothing","No.",200,null,{"$f":"E1062*F1062","v":0}]
[{"$f":"IF(E1063=0,\"\",$A$7&COUNTIF($A$8:A1058,\"><*\")+1)","v":""}]
["10.3",null,"c) Safety gloves","No.",200,null,{"$f":"E1064*F1064","v":0}]
[]
["10.4",null,"d) Colour coded hardhats","No.",50,null,{"$f":"E1066*F1066","v":0}]
[]
["10.5",null,"e) Induction tags /cards","No.",200,null,{"$f":"E1068*F1068","v":0}]
[{"$f":"IF(E1069=0,\"\",$A$7&COUNTIF($A$8:A1068,\"><*\")+1)","v":""}]
["10.6",null,"f)Luminous high visibility safety vests","No.",200,null,{"$f":"E1070*F1070","v":0}]
[{"$f":"IF(E1071=0,\"\",$A$7&COUNTIF($A$8:A1070,\"><*\")+1)","v":""}]
["10.7",null,"g) Additional items: Contractor to specify  (To be approved by the Engineer)","No.",200,null,{"$f":"E1072*F1072","v":0}]
[{"$f":"IF(E1073=0,\"\",$A$7&COUNTIF($A$8:A1072,\"><*\")+1)","v":""}]
["10.8",null,"BARRICADING"]
[]
[{"$f":"IF(E1076=0,\"\",$A$7&COUNTIF($A$8:A1074,\"><*\")+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",150,null,{"$f":"E1078*F1078","v":0}]
[{"$f":"IF(E1079=0,\"\",$A$7&COUNTIF($A$8:A1078,\"><*\")+1)","v":""}]
["10.8.2",null,"Additional items: As specified by the Engineer ","Prov.Sum",1,{"v":200000,"d":"R200,000.00"},{"$f":"E1080*F1080","v":{"v":200000,"d":"R 200,000.00"}}]
[{"$f":"IF(E1081=0,\"\",$A$7&COUNTIF($A$8:A1080,\"><*\")+1)","v":""}]
["10.8.2.1",null,"Profit on item 10.8.2 above","%",{"$f":"G1080","v":{"v":200000,"d":"200,000"}},null,{"$f":"E1082*F1082","v":0}]
[]
[]
[]
["TOTAL CARRIED FORWARD TO SUMMARY"]

{"sheet":"SUMMARY","index":1,"n_rows":32,"n_cols":3,"rows_kept":32,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,2],[3,0,3,2],[4,0,4,1],[5,0,5,1],[7,0,7,1],[9,0,9,1],[11,0,11,1],[13,0,13,1],[15,0,15,1],[17,0,17,1],[18,0,18,1],[21,0,21,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1]]}
["JOHANNESBURG WATER"]
["CONTRACT NUMBER: JW14431"]
["SOWETO (ORLANDO) STS PREPAYMENT WATER METER AND RETROFITTING INSTALLATIONS "]
["DESCRIPTION"]
[]
[{"$f":"'Bill of Quantities'!C5","v":"SCHEDULE A:  PRELIMINARY AND GENERAL"},null,{"$f":"'Bill of Quantities'!G233","v":0}]
[]
["SCHEDULE B:  SITE CLEARANCE",null,{"$f":"'Bill of Quantities'!G332","v":0}]
[]
["SCHEDULE C:  EARTHWORKS (PIPE TRENCHES)",null,{"$f":"'Bill of Quantities'!G413","v":0}]
[]
["SCHEDULE D:  BEDDING (PIPES)",null,{"$f":"'Bill of Quantities'!G450","v":0}]
[]
["SCHEDULE E:  MEDIUM PRESSURE PIPELINES",null,{"$f":"'Bill of Quantities'!G849","v":0}]
[]
["SCHEDULE F: ERF CONNECTIONS",null,{"$f":"'Bill of Quantities'!G925","v":0}]
[]
["SCHEDULE G: YARD CONNECTIONS"]
[]
["SCHEDULE H: ON PROPERTY PLUMBING",null,{"$f":"'Bill of Quantities'!G1004","v":0}]
[]
["SCHEDULE I: METER INSTALLATION",null,{"$f":"'Bill of Quantities'!G1051","v":0}]
[]
["SCHEDULE J: OCCUPATIONAL HEALTH AND SAFETY",null,{"$f":"'Bill of Quantities'!G1086","v":0}]
[]
["SUBTOTAL 1……………………………………..……………………………………………",null,{"$f":"SUM(C6:C25)","v":0}]
["10% Escalation",null,{"$f":"C26*0.1","v":0}]
["SUBTOTAL 2……………………………………..……………………………………………",null,{"$f":"C26+C27","v":0}]
["10% Contingencies",null,{"$f":"10%*C28","v":0}]
["SUBTOTAL 3……………………………………..……………………………………………",null,{"$f":"C28+C29","v":0}]
["15% VAT",null,{"$f":"15%*C30","v":0}]
["Amount Incl.VAT",null,{"$f":"SUM(C30:C31)","v":0}]