{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Works","1 P&G","2 OHS","3 Tower","4 Pump","5 Fence","6 Chambers","7 Pipe","8 Special Equipment","9 Road","10 Alterations","11 Site Works","12 Electrical & Generator","Sum"],"not_rendered":{"images":3,"defined_names":13,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Works","index":0,"n_rows":59,"n_cols":6,"rows_kept":59,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[11,0,15,6],[56,0,56,6],[58,0,58,6]]}
["CONTRACT JW14402",{"$nulls":4},"Date :08/09/2025"]
["JOBURG WATER",{"$nulls":4},"Rev 8"]
["Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"]
{"$rows_empty":8}
["Bill of Quantities"]
{"$rows_empty":46}
[{"v":8,"d":"Bill of Quantities page number 8"}]

{"sheet":"1 P&G","index":1,"n_rows":118,"n_cols":9,"rows_kept":118,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[11,2,15,2],[55,0,55,5],[56,0,56,6],[66,2,67,2],[66,3,67,3],[66,4,67,4],[66,5,67,5],[70,0,70,2],[116,0,116,5],[117,0,117,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"},null,null,{"v":0.4,"d":"40%"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 1"]
[null,1200,"Preliminary and general"]
["1.1",null,"Fixed charge items"]
[]
["1.1.1","A8.3.1","Contractual requirements:","sum"]
[null,null,"All Contractual requirements affecting the Contractor: The sum shall cover the Contractor's initial cost of providing surities, insurances as per the GCC and the Contract Data and any other financial obligations  of a preliminary and general nature."]
[]
[]
[]
[]
["1.1.2",null,"Establishment of Facilities  in the site:"]
[]
["1.1.2.1","A8.3.2","Facilities for the Contractor: ","sum"]
[null,null,"Offices & storage facilities, workshops, ablutions, tools and equipment, "]
[null,null,"plant, cranes,  water and electicity and any other facilities required"]
[null,null," by the Contractor for the succesful completion of the project."]
[null,null,"Deal with rain and/or ground water in all type of excavations on site"]
[null,null,"as described in SANS 1 200 A section 5.5"]
[]
["1.1.2.2",null,"Facilities for the Client's agent","sum"]
[null,null,"Client's Agent facilities as described in PSAB 3.2  Engineer's Office in"]
[null,null,"the Project Specifications:"]
[null,"PSAB 3.1","Name board (2 number) as specified in the Tender Document"]
[null,"PSA8.3.2.1 ","Furnished office for the Project Manager's use (see item PSAB3.2 in the document)"]
[null,null,"including carport and board room for site meetings as well as equipment  "]
[null,null,"as described in PSAB 4"]
[null,"PSA8.3.2.1 ","Furnished office for the Client's use (see item PSAB3.2 in the document)"]
[]
["1.1.3","A8.3.4","Removal of site establishment"]
[null,null,"Removal of all items established in terms of 1.1.2.1 above and shall"]
[null,null,"provide for the restoring the Site to it's origonal state","sum"]
[]
["1.2",null,"Time related items"]
[]
["1.2.1","A8.4.1","Contractual requirements on a monthly bases affecting the Contractor","month",24]
[]
[null,null,"The Contractor to maintain the following items or as amended in the"]
[null,null,"Tender Document - for the duration of the Contract :"]
["1.2.2","A8.4.2.2","All facilities on the site for the Engineer & for the Contractor","month",24]
[]
[null,null,"Other obligations by the Contractor on a time bases for the duration"]
[null,null,"of the Contract :"]
["1.2.3","A8.4.3","Full time supervision of the site as specified in the Tender Document","month",24]
["1.2.4","A8.4.4","Company & head office administration costs pertaining to the Contract","month",24]
["1.2.5","A8.4.5","Other time related obligations by the Contractor ","month",24]
["1.2.6","PS2.13","Accomodation of traffic","month",24]
["1.2.7",null,"Provide security for the duration of the project","month",24]
[]
[]
[{"v":10,"d":"Schedule sub total carried forward to page 10"}]
[{"$f":"Works!A59+1","v":{"v":9,"d":"Bill of Quantities page number 9"}}]
[]
[]
[]
[]
[]
["CONTRACT JW14402",{"$nulls":4},"Date :08/08/2025",null,null,{"v":0.4,"d":"40%"}]
["JOBURG WATER"]
["Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 1 continued"]
[null,1200,{"$f":"C8","v":"Preliminary and general"}]
[{"$f":"A57","v":{"v":9,"d":"-\\schedule continued from page 9"}}]
["1.3",null,"Provisional sums by the Engineer"]
[]
["1.3.1","A8.5a","Provisional sum for various tests requested by the Engineer","Prov",1,{"v":140000,"d":"140,000.00"},{"v":140000,"d":"140,000.00"}]
["1.3.2","PSA5.10.2","Prov sum for SC and CLO payments ","Prov",1,{"v":240000,"d":"240,000.00"},{"v":240000,"d":"240,000.00"}]
["1.3.3","PSA5.10.2","Prov sum for JW trainee payments","Prov",1,{"v":288000,"d":"288,000.00"},{"v":288000,"d":"288,000.00"}]
["1.3.4","PSA5.10.3","Accredited skills training (concrete works)","Prov",1,{"v":70000,"d":"70,000.00"},{"v":70000,"d":"70,000.00"}]
["1.3.5","PSA5.10.3","Accredited construction management training","Prov",1,{"v":50000,"d":"50,000.00"},{"v":50000,"d":"50,000.00"}]
["1.3.9",null,"Provisional sums for Electrical supply (City Power)","Prov",1,{"v":700000,"d":"700,000.00"},{"v":700000,"d":"700,000.00"}]
[]
[null,null,"Mark-up and Handling fee on otems 1.3.1 to 13.5 above",null,"%"]
{"$rows_empty":35}
["Schedule 1 total carried to summary page"]
[{"$f":"A57+1","v":{"v":10,"d":"Bill of Quantities page number 10"}}]

{"sheet":"2 OHS","index":2,"n_rows":246,"n_cols":10,"rows_kept":246,"merged":[[4,2,5,2],[4,3,5,3],[4,5,5,5],[56,0,56,5],[57,0,57,6],[63,2,64,2],[63,3,64,3],[63,4,64,4],[63,5,64,5],[68,0,68,6],[119,0,119,5],[120,0,120,6],[126,2,127,2],[126,3,127,3],[126,4,127,4],[126,5,127,5],[131,0,131,6],[181,0,181,5],[182,0,182,6],[188,2,189,2],[188,3,189,3],[188,4,189,4],[188,5,189,5],[193,0,193,6],[244,0,244,5],[245,0,245,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"},{"$nulls":3},{"v":0.4,"d":"40%"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",null,null,"tender",null,"Rands.cents"]
[null,"SANS","Schedule 2"]
[null,"1 200","Occupational health and safety requirements"]
["2.1",null,"Notification of construction work"]
[]
[null,null,"Quantities are re-measurable- proof shall be supplied by the"]
[null,null,"contractor of quantities claimed"]
["2.1.1",null,"Notification of Construction work to the Provincial Director as ","sum",1]
[null,null,"requested by the Engineer under the Construction Regulations "]
[null,null,"of the Occupational Health & Safety (Regulation 3) Act no. 85/1993"]
[]
["2.2",null,"Health and safety plan"]
[]
["2.2.1",null,"Based on the Occupational Health and Safety specification,","sum",1]
[null,null,"setting up a job and site specific  Health and Safety Plan  "]
[null,null,"under the Construction Regulations (Regulation 5) of the "]
[null,null,"Occupational Health & Safety Act no. 85/1993 "]
[]
["2.3",null,"Health and safety main file"]
[]
["2.3.1",null,"Setting up a job and site specific  Health & Safety Main file as","sum",1]
[null,null,"speicied under the Construction Regulations"]
[null,null,"(Regulation 5) of the Occupational Health & Safety Act no. 85/1993"]
[null,null,"NOT TO BE REMOVED FROM SITE"]
[null,null,"File to be a lever arch file with original colour document of"]
[null,null,"acceptable standards including dividers. Emergency telephone"]
[null,null,"numbers to be displayed on back of file. The file will be"]
[null,null,"expanded during the project as and when required by the"]
[null,null,"Client"]
[null,null,"File to include the following:"]
[null,null,"Copy of H&S Act "]
[null,null,"Proof of registration with COID Insurer"]
[null,null,"Notification of construction work"]
[null,null,"Mandatory Agreement"]
[null,null,"H&S Specifications provided by client"]
[null,null,"Copy of tender document, drawings etc"]
[null,null,"Company Safety Policy to be signed by CEO"]
[null,null,"Company organogrammme with respect to H&S on specific site"]
[null,null,"Letters of appointment for specific site"]
[null,null,"List of subcontractors"]
[null,null,"Evacuation plan"]
[null,null,"Risk assessments and method statements"]
[null,null,"Safe work procedures and material safety data sheets"]
[null,null,"Fall protection plan"]
[null,null,"Incident recordings"]
[null,null,"Medical records"]
[null,null,"Minutes of H&S meetings"]
[]
[]
[]
[]
[{"v":12,"d":"Schedule sub total carried forward to page 12"}]
[{"$f":"'1 P&G'!A118+1","v":{"v":11,"d":"Bill of Quantities page number 11"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 2 continued"]
[null,"1 200",{"$f":"C8","v":"Occupational health and safety requirements"}]
[{"$f":"A58","v":{"v":11,"d":"-\\schedule continued from page 11"}}]
[]
[2.4,null,"Health & safety register file"]
[]
["2.4.1",null,"Setting up a job and site specific  Health & Safety Register File as","sum",1]
[null,null,"requested by the Engineer under the Construction Regulations"]
[null,null,"(Regulation 5) of the Occupational Health & Safety Act no. 85/1993 "]
[null,null,"File to be a lever arch file with original colour document of "]
[null,null,"acceptable standards including dividers."]
[null,null,"NOT TO BE REMOVED FROM SITE"]
[]
[2.5,null,"Health & Safety training file"]
[]
["2.5.1",null,"Setting up a job and site specific  Health & Safety Training File as","sum",1]
[null,null,"requested by the Engineer under the Construction Regulations"]
[null,null,"(Regulation 5) of the Occupational Health & Safety Act no. 85/1993 "]
[null,null,"File to be a lever arch file with original colour document of "]
[null,null,"acceptable standards including dividers."]
[null,null,"NOT TO BE REMOVED FROM SITE"]
[]
[2.6,null,"Service Provider appointments"]
[]
["2.6.1",null,"Appointment of a competent person to perform risk assessment ","sum",1]
[null,null,"and training on site under Construction Regulations (Regulation 7)"]
[null,null,"of the Occupational Health & Safety Act no. 85/1993 "]
[]
[2.7,null,"Training on site"]
[]
["2.7.1",null,"Allow for monthly salary for the H&S representative as required by ","sum",1]
[null,null,"law for the duration of the project for training"]
[null,null,"The H&S Representative to perform the following :"]
[null,null,"H&S duties on site"]
[null,null,"Appointee to be permanently on site and under supervision of"]
[null,null,"Contractor's Site Supervisor. Appointment to be for the duration of"]
[null,null,"the Contract. Induction training of all workers of Sub-Contractors. "]
[null,null,"Public awareness training."]
[null,null,"Toolbox talks on environmental awareness "]
[null,null,"First aid awareness"]
[null,null,"Fire fighting awareness"]
[null,null,"Tool box talks on hand tools and hand tool accidents"]
[null,null,"Hold tool box talks on machine guarding "]
[null,null,"Tool box talks on lifting materials by hand "]
[null,null,"Tool box talks on safe loading "]
[null,null,"Tool box talks on safety signs "]
[null,null,"Tool box talks on ten commandments of safety"]
[null,null,"Community training"]
[null,null,"Tool box talks on working on heights"]
[null,null,"Tool box talks on working with safety harness"]
[null,null,"Tool box talks on working with hydraulic elevators"]
[]
[]
[]
[{"$f":"A121+1","v":{"v":13,"d":"Schedule sub total carried forward to page 13"}}]
[{"$f":"A58+1","v":{"v":12,"d":"Bill of Quantities page number 12"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS",{"$f":"C66","v":"Schedule 2 continued"}]
[null,"1 200",{"$f":"C8","v":"Occupational health and safety requirements"}]
[{"$f":"A121","v":{"v":12,"d":"-\\schedule continued from page 12"}}]
[]
[2.8,null,"First aid equipment"]
[]
["2.8.1",null,"First aid box","no",3]
["2.8.2",null,"First aid boxes for Sub contractors","no",2]
["2.8.3",null,"Stretcher","no",1]
[]
[2.9,null,"Fire fighting equipment"]
[]
["2.9.1",null,"Fire extinguishers","no",3]
["2.9.2",null,"Fire extinguishers for Sub Contractors if applicable","no",2]
["2.9.3",null,"Fire extinguishers test certificate for main and sub contractors ","no",{"$f":"+E141+E142","v":5}]
[]
["2.10",null,"Personal protective clothing"]
[]
[null,null,"Allow for the cost of the following PPE as required on site by","sum",1]
[null,null,"workers (number of each to be determined by the Tenderer)"]
["2.10.1",null,"Hard hats"]
["2.10.2",null,"Safety Shoes"]
["2.10.3",null,"Dust Masks"]
["2.10.4",null,"Safety Goggles"]
["2.10.5",null,"Gum Boots "]
["2.10.6",null,"Overalls"]
["2.10.7",null,"Safety harnasses"]
[]
[2.11,null,"Chemical toilets"]
[]
[null,null,"Allow for toilet facilities on site as required by specifications"]
["2.11.1",null,"For male workers","no",3]
["2.11.2",null,"For female workers","no",3]
[]
[2.12,null,"Eating facilities"]
[]
["2.12.1",null,"Allow for eating facilities on site in the form of a shaded net, table","no",1]
[null,null,"and chairs"]
[]
["2.13",null,"Signs"]
[]
[null,null,"Allow for signboards to be displayed on site as required","sum",1]
["2.13.1",null,"SMI board"]
["2.13.2",null,"No entry signs"]
["2.13.3",null,"First Aid signs"]
["2.13.4",null,"Fire equipment signs"]
["2.13.5",null,"Warning signs (Construction area boards)"]
["2.13.6",null,"Traffic control signs (mechanical & pedestrian)"]
["2.13.7",null,"Fire siren"]
["2.13.8",null,"Name boards on construction vehicles"]
[]
[]
[]
[{"$f":"A183+1","v":{"v":14,"d":"Schedule sub total carried forward to page 14"}}]
[{"$f":"A121+1","v":{"v":13,"d":"Bill of Quantities page number 13"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS",{"$f":"C129","v":"Schedule 2 continued"}]
[null,"1 200",{"$f":"C8","v":"Occupational health and safety requirements"}]
[{"$f":"A183","v":{"v":13,"d":"-\\schedule continued from page 13"}}]
[]
[2.14,null,"Medical tests"]
[]
[null,null,"Appointment of a competent person to perform medical tests to"]
[null,null,"all employees"]
["2.14.1",null,"Allow for medical tests of workers as medical fitness tests for ","sum",1,{"$nulls":4},{"v":65236.21,"d":"65,236.21"}]
[null,null,"all employees"]
[]
[2.15,null,"Barricading & demarcation"]
[]
["2.15.1",null,"Allow for proper barricading and demarcation of streets to direct","sum",1,{"$nulls":4},{"v":10851,"d":"10,851.00"}]
[null,null,"public and vehicles"]
[]
[2.16,null,"Health & Safety agent"]
[]
["2.16.1",null,"Provisional sum for the appointment of a Health & Safety Agent to ","Prov",1,null,{"v":130000,"d":"130,000.00"}]
[null,null,"act on behalf of the Employer to ensure adherence of the "]
[null,null,"Contractor to all Health & Safety requirements"]
{"$rows_empty":33}
["Schedule 2 total carried to summary page"]
[{"$f":"A183+1","v":{"v":14,"d":"Bill of Quantities page number 14"}}]

{"sheet":"3 Tower","index":3,"n_rows":371,"n_cols":11,"rows_kept":371,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[56,0,56,5],[57,0,57,6],[63,2,64,2],[63,3,64,3],[63,4,64,4],[63,5,64,5],[69,0,69,6],[118,0,118,5],[119,0,119,6],[125,2,126,2],[125,3,126,3],[125,4,126,4],[125,5,126,5],[181,0,181,5],[182,0,182,6],[188,2,189,2],[188,3,189,3],[188,4,189,4],[188,5,189,5],[243,0,243,5],[244,0,244,6],[250,2,251,2],[250,3,251,3],[250,4,251,4],[250,5,251,5],[305,0,305,5],[306,0,306,6],[312,2,313,2],[312,3,313,3],[312,4,313,4],[312,5,313,5],[318,0,318,6],[369,0,369,5],[370,0,370,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"},{"$nulls":3},{"v":0.6,"d":"60.0%"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 3"]
[null,"1 200","2,5 Mℓ capacity elevated water tower "]
[null,null,"Drawing reference : T01 to T05"]
[null,null,"Tower"]
[3.1,null,"Earthworks"]
[]
["3.1.1","D8.3.1.1","Clear and strip site","m²",{"v":1500,"d":"1,500"},{"$nulls":4},5.73,{"$f":"E13*J13","v":8595}]
[]
["3.1.2","D8.3.2","Excavate in all materials and stockpile for later use for backfill or embankment"]
[null,null,"or dispose surplus material to remote site found by Contractor","m³",{"v":1530,"d":"1,530"},{"$nulls":4},31.42,{"$f":"E16*J16","v":48072.600000000006}]
[]
["3.1.3","D8.3.2.b1","Extra over for excavation in intermediate material","m³",100,{"$nulls":4},11.55,{"$f":"E18*J18","v":1155}]
[]
["3.1.4","D8.3.2.b2","Extra over for excavation in hard rock material","m³",350,{"$nulls":4},376.47,{"$f":"E20*J20","v":131764.5}]
[]
["3.1.5","D8.3.2","Backfill over completed foundation in layers of 150mm with material from"]
[null,null,"stockpile, compacted to 95% Mod AASHTO ","m³",{"v":1216,"d":"1,216"},{"$nulls":4},58.7,{"$f":"E23*J23","v":71379.2}]
[]
["3.1.6","ME8.3.5","Compact final layer to 97% Mod AASHTO, stabilised with 3% cement","m³",40,{"$nulls":4},30.84,{"$f":"E25*J25","v":1233.6}]
[null,null,"Stabilizing agent: Portland cement","t",{"v":2.5,"d":"3"},{"$nulls":4},2257.25,{"$f":"E26*J26","v":5643.125}]
[]
["3.1.7",null,"Apply weed killer and insecticide soil poisening over compacted "]
[null,null,"area below tower","m²",340,{"$nulls":4},11.03,{"$f":"E29*J29","v":3750.2}]
[]
["3.1.8",null,"Pave area below tower with 450 x 450 x 50 pre-cast concrete blocks on",null," "]
[null,null,"25mm sand/cement bedding","m²",450,{"$nulls":4},557.33,{"$f":"E32*J32","v":250798.50000000003}]
[]
["3.1.9",null,"Storm water channel around reservoir, 1,5m wide dished  and laid"]
[null,null,"to falls to discharge water on paved road, from 25MPa concrete","m³",12,{"$nulls":4},2346.51,{"$f":"E35*J35","v":28158.120000000003}]
[]
[null,null,"Existing services"]
[]
["3.1.10","D8.3.8","Dig open by hand to expose the following services and backfill:"]
[null,null,"Electrical cables","m",100,{"$nulls":4},150,{"$f":"E40*J40","v":15000}]
[]
["3.1.11",null,"Install 2 x 110mm sleeves in trench including 600 x 600 encasing 600 x600","m",100,{"$nulls":4},50,{"$f":"E42*J42","v":5000}]
[]
["3.1.12","DB8.3.2","Dig new trench, 0,6m wide and 1,0m deep by hand at new position "]
[null,null,"of electrical cable, backfill and re-compact after installation of new cable","m",100,{"$nulls":4},150,{"$f":"E45*J45","v":15000}]
[]
["3.1.13","D8.3.8","Dig open by hand to expose the following services:"]
[null,null,"Water lines","m",75,{"$nulls":4},200,{"$f":"E48*J48","v":15000}]
[]
["3.1.14",null,"Provisional sum for additional Geotech investigation","Prov",1,{"v":120000,"d":"120,000.00"},{"v":120000,"d":"120,000.00"},null,null,100,{"$f":"#REF!*J50","v":{"$error":"#REF!"}}]
["3.1.15",null,"Provisional sum for Geotech inspections","Prov",1,{"v":100000,"d":"100,000.00"},{"v":100000,"d":"100,000.00"}]
[]
["1.3.11",null,"Provisional sum for the rehabilitation of old tower","Prov",1,{"v":4000000,"d":"4,000,000.00"},{"v":4000000,"d":"4,000,000.00"}]
[]
[]
[]
[{"v":16,"d":"Schedule sub total carried forward to page 16"},{"$nulls":9},{"$f":"SUM(K13:K56)","v":{"$error":"#REF!"}}]
[{"$f":"'2 OHS'!A246+1","v":{"v":15,"d":"Bill of Quantities page number 15"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 3 continued"]
[null,"1 200",{"$f":"C8","v":"2,5 Mℓ capacity elevated water tower "}]
[null,null,{"$f":"C9","v":"Drawing reference : T01 to T05"}]
[{"$f":"A58","v":{"v":15,"d":"-\\schedule continued from page 15"}}]
[]
[3.2,null,"Concrete works"]
[null,null,"Foundations"]
["3.2.1","G8.4.2","75 mm blinding layer laid on excavation platform from 15 MPa concrete","m³",90,{"$nulls":4},107.61,{"$f":"E73*J73","v":9684.9}]
[null,null,"at reduced level built with radius of 8 m"]
["3.2.2","G8.4.2","500 mm circular foundation slab from 35 MPa concrete cast at reduced","m³",205,{"$nulls":4},1606.96,{"$f":"E75*J75","v":329426.8}]
[null,null,"level built with radius of 8m"]
["3.2.3","G8.4.3","Column foundations from 35 MPa concrete - 2,0m x 2,0m x 1,5m high","m³",168,{"$nulls":4},1606.96,{"$f":"E77*J77","v":269969.28}]
[null,null,"cast at reduced level with sloping top surface to take 0,6 x 1,05 columns"]
["3.2.4","G8.4.3","Shaft foundation from 35 Mpa concrete - 6,4m x 6,4m x 0,5m cast on ","m³",21,{"$nulls":4},1606.96,{"$f":"E79*J79","v":33746.16}]
[null,null,"Circular base at reduced level"]
["3.2.5","G8.4.3","350mm thick circular shaft foundation wall from 35MPa concrete to 2.35m Inside  ","m³",{"v":19.5,"d":"20"},{"$nulls":4},1793.92,{"$f":"E81*J81","v":34981.44}]
[null,null,"radius up to shaft floor level"]
["3.2.6","G8.4.2","1500mm thick mass concrete infill from 15MPa concrete into cylinder","m³",60,{"$nulls":4},1434.75,{"$f":"E83*J83","v":86085}]
[null,null,"as formed with walls as per item 3.1.5, from foundation level to floor level"]
["3.2.7","G8.4.2","170mm thick floor slab in shaft from 35PMa concrete","m³",{"v":4.5,"d":"5"},{"$nulls":4},1793.92,{"$f":"E85*J85","v":8072.64}]
[]
[null,null,"Access shafts"]
["3.2.8","G8.4.3","350mm access shaft from 35 Mpa concrete between raduises 2,35m and","m³",119,{"$nulls":4},1793.92,{"$f":"E88*J88","v":213476.48}]
[null,null,"2,7m to 21m above ground level - onto walls as per item 3.1.5"]
["3.2.9","G8.4.3","250mm final shaft from 35 Mpa concrete between radiuses 1,0m and ","m³",18,{"$nulls":4},1893.38,{"$f":"E90*J90","v":34080.840000000004}]
[null,null,"1,25m at heights from 21m to 29,4m above ground level"]
["3.2.10","G8.4.3","250mm thick staircase landings at various levels including final","m³",7,{"$nulls":4},2000.67,{"$f":"E92*J92","v":14004.69}]
[null,null,"landing at 18,6m above ground level"]
[]
[null,null,"Columns"]
["3.2.11","G8.4.3","12 no. of perimeter columns from 35 MPa concrete with depth ranging","m³",150,{"$nulls":4},1893.38,{"$f":"E96*J96","v":284007}]
[null,null,"from 1,05m at the base to 0,7m at springing level and constant width  "]
[null,null,"of 0,6m "]
["3.2.12","G8.4.3","24 no. of 350 x 350 inside columns from 35MPa starting on the tank floor","m³",40,{"$nulls":4},1893.38,{"$f":"E99*J99","v":75735.20000000001}]
[null,null,"21m above ground level and supporting the tank roof slab"]
[]
[null,null,"Stiffner beams"]
["3.2.13","G8.4.3","Stiffner beams of sizes 500mm x 750mm with flat soffit from 35MPa concrete","m³",92,{"$nulls":4},1793.92,{"$f":"E103*J103","v":165040.64}]
[null,null,"at 6m & 13m above ground level - Beam type T5 & Beam type T6"]
["3.2.14","G8.4.3","Arched beams with circular soffit above springing level at 17,6 to 19,6m ","m³",93,{"$nulls":4},1893.38,{"$f":"E105*J105","v":176084.34}]
[null,null,"above ground level - Beam type T3"]
[]
[null,null,"Tank floor and beams"]
["3.2.15","G8.4.3","350mm circular tank floor slab from 350MPa concrete, cast at 21,5m above","m³",130,{"$nulls":4},1893.38,{"$f":"E109*J109","v":246139.40000000002}]
[null,null,"ground level built with radius of 10.75m"]
[]
["3.2.16","G8.4.3","Beams of various sizes with flat soffit from 35MPa concrete at tank floor ","m³",80,{"$nulls":4},1893.38,{"$f":"E112*J112","v":151470.40000000002}]
[null,null,"level, cast monolithic with floor slab as per item 3.2.15"]
[]
[null,null,"Tank roof slab, beams and access manholes"]
["3.2.17","G8.4.3","200mm circular roof slab cast at a slope of 8° from 35MPa concrete","m³",60,{"$nulls":4},2000.67,{"$f":"E116*J116","v":120040.20000000001}]
[null,null," from 29m to 30m above ground level - Lower roof"]
[]
[{"$f":"A183","v":{"v":17,"d":"Schedule sub total carried forward to page 17"}},{"$nulls":8},{"$f":"SUM(J73:J118)","v":28900.540000000008}]
[{"$f":"A58+1","v":{"v":16,"d":"Bill of Quantities page number 16"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 3 continued"]
[null,"1 200",{"$f":"C8","v":"2,5 Mℓ capacity elevated water tower "}]
[null,null,{"$f":"C9","v":"Drawing reference : T01 to T05"}]
[{"$f":"A120","v":{"v":16,"d":"-\\schedule continued from page 16"}}]
[]
["3.2.18","G8.4.3","150mm circular roof slab with flat soffit from 35MPa concrete","m³",{"v":4.5,"d":"5"},{"$nulls":4},2000.67,{"$f":"E133*J133","v":9003.015}]
[null,null," cast at 30m above ground level - Upper roof"]
[]
["3.2.19","G8.4.3","Beams of various sizes with flat soffit from 35MPa concrete at tank roof","m³",13,{"$nulls":4},2000.67,{"$f":"E136*J136","v":26008.71}]
[null,null,"level, cast monolithic with roof slab as per item 3.1.15 & 3.1.16 -"]
[null,null,"Beam type R1 & Beam type R2 "]
[]
["3.2.20","G8.4.3","150mm x 450mm sloping ledge with flat soffit from 35MPa concrete","m³",11,{"$nulls":4},2000.67,{"$f":"E140*J140","v":22007.370000000003}]
[null,null,"cast at tank roof level along perimeter of tank"]
[]
[null,null,"Tank Wall"]
["3.2.21","G8.4.3","350mm tank wall from 35 Mpa concrete between raduises 10.4m and 10.75m","m³",185,{"$nulls":4},1893.38,{"$f":"E144*J144","v":350275.30000000005}]
[null,null,"cast at 22m above ground level with 50mm recesses as shown"]
[]
["3.2.22","PSG3.5.1","Extra over items 3.2.8 to 3.2.21 for Penetron waterproofing additive "]
[null,null,"as specified in PSG 3.5.1 at a rate of 0,8% by weight of cementitious content","m³",{"v":1500,"d":"1,500"},{"$nulls":3},{"v":0,"d":"0.0"},380.54,{"$f":"E148*J148","v":570810}]
[null,null,"in the concrete mix"]
[3.3,null,"Reinforcement - see drawings R01 to R06"]
[]
["3.3.1","G8.3.1","High tensile reinforcement of various diameter for foundation slab & footings","kg",{"v":24000,"d":"24,000"},{"$nulls":4},{"v":21,"d":"21.00"},{"$f":"E152*J152","v":504000}]
[]
["3.3.2","G8.3.1","Hight tensile reinforcement of various diameter for shafts & tank wall","kg",{"v":24700,"d":"24,700"},{"$nulls":4},{"v":21,"d":"21.00"},{"$f":"E154*J154","v":518700}]
[]
["3.3.3","G8.3.1","Hight tensile reinforcement of various diameter for columns","kg",{"v":22200,"d":"22,200"},{"$nulls":4},{"v":21,"d":"21.00"},{"$f":"E156*J156","v":466200}]
[]
["3.3.4","G8.3.1","Hight tensile reinforcement of various diameter for beams T5 & T6","kg",{"v":8000,"d":"8,000"},{"$nulls":4},{"v":21,"d":"21.00"},{"$f":"E158*J158","v":168000}]
[]
["3.3.5","G8.3.1","Hight tensile reinforcement of various diameter for tank floor slab & beams","kg",{"v":30000,"d":"30,000"},{"$nulls":4},{"v":21,"d":"21.00"},{"$f":"E160*J160","v":630000}]
[]
["3.3.6","G8.3.1","Hight tensile reinforcement of various diameter for tank roof slab & beams","kg",{"v":15000,"d":"15,000"},{"$nulls":4},{"v":21,"d":"21.00"},{"$f":"E162*J162","v":315000}]
[]
["3.3.9","G8.3.1","Hight tensile reinforcement of various diameter for landings","kg",{"v":1000,"d":"1,000"},{"$nulls":3},{"$f":"SUM(E152:E164)","v":{"v":124900,"d":"124,900"}},{"v":21,"d":"21.00"},{"$f":"E164*J164","v":21000}]
{"$rows_empty":17}
[{"$f":"A183+1","v":{"v":18,"d":"Schedule sub total carried forward to page 18"}}]
[{"$f":"A120+1","v":{"v":17,"d":"Bill of Quantities page number 17"}},{"$nulls":9},{"$f":"SUM(K133:K182)","v":3601004.395}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 3 continued"]
[null,"1 200",{"$f":"C129","v":"2,5 Mℓ capacity elevated water tower "}]
[null,null,{"$f":"C130","v":"Drawing reference : T01 to T05"}]
[{"$f":"A183","v":{"v":17,"d":"-\\schedule continued from page 17"}}]
[]
[3.4,null,"Form work"]
["3.4.1","G8.2.2","Smooth vertical curving form work to foundation slab sides","m²",40,{"$nulls":4},426.31,{"$f":"E197*J197","v":17052.4}]
[null,null,"with radius of 10.8 m - 500mm high at reduced level"]
["3.4.2","G8.2.2","Smooth vertical form work to column footings - 3500mm high","m²",364,{"$nulls":4},426.31,{"$f":"E199*J199","v":155176.84}]
[null,null,"at reduced level (12No.)"]
["3.4.3","G8.2.2","Smooth vertical form work to center footing - 500mm high","m²",{"v":12.8,"d":"13"},{"$nulls":4},426.31,{"$f":"E201*J201","v":5456.768}]
[null,null,"at reduced level"]
["3.4.4","G8.2.2","Smooth vertical form work to tapered columns from ground level","m²",886,{"$nulls":4},494.58,{"$f":"E203*J203","v":438197.88}]
[null,null,"to 22m above ground including arched shape as shown (12No.)"]
[null,null,"including 25 x 25 chamfer along all corners "]
["3.4.5","G8.2.2","Smooth vertical curving form work to inside of access shaft","m²",347,{"$nulls":4},851.82,{"$f":"E206*J206","v":295581.54000000004}]
[null,null,"with radius of 2.35 m from ground level to 22m above ground"]
["3.4.6","G8.2.2","Smooth vertical curving form work to outside of access shaft","m²",400,{"$nulls":4},851.82,{"$f":"E208*J208","v":340728}]
[null,null,"with radius of 2.7 m from ground level to 22m above ground"]
["3.4.7","G8.2.2","Smooth vertical curving form work to inside of final shaft","m²",64,{"$nulls":4},1064.82,{"$f":"E210*J210","v":68148.48}]
[null,null,"with radius of 1.0 m from 22m to 30m above ground"]
["3.4.8","G8.2.2","Smooth vertical curving form work to outside of final shaft","m²",79,{"$nulls":4},1064.82,{"$f":"E212*J212","v":84120.78}]
[null,null,"with radius of 1.25 m from 22m to 30m above ground"]
["3.4.9","G8.2.2","Smooth vertical curving form work to inside of tank wall","m²",510,{"$nulls":4},1064.82,{"$f":"E214*J214","v":543058.2}]
[null,null,"with radius of10.4 m from 22m to 28m above ground"]
["3.4.10","G8.2.2","Smooth vertical curving form work to outside of tank wall","m²",525,{"$nulls":4},1064.82,{"$f":"E216*J216","v":559030.5}]
[null,null,"with radius of 10.75 m from 22m to 28m above ground"]
["3.4.11","G8.2.2","Smooth vertical form work to sides of stiffner beams at 6m & 13m","m²",370,{"$nulls":4},1064.82,{"$f":"E218*J218","v":393983.39999999997}]
[null,null,"above ground level (Beams T5 & T6) - 24No. Each"]
["3.4.12","G8.2.2","Smooth horizontal form work to soffits of stiffner beams at 6m & 13m","m²",125,{"$nulls":4},1699.46,{"$f":"E220*J220","v":212432.5}]
[null,null,"above ground level (Beams T5 & T6) - 24No. Each"]
[null,null,"including 25 x 25 chamfer along all corners "]
["3.4.13","G8.2.2","Smooth horizontal form work to soffits of landings at various levels","m²",16,{"$nulls":4},1699.46,{"$f":"E223*J223","v":27191.36}]
[null,null,"up to 19m above ground level"]
[null,null,"including 25 x 25 chamfer along all corners "]
["3.4.14","G8.2.2","Smooth vertical form work to sides of landings at various levels","m²",7,{"$nulls":4},424.11,{"$f":"E226*J226","v":2968.77}]
[null,null,"up to 19m above ground level - 300mm high"]
["3.4.15","G8.2.2","Smooth horizontal form work to soffit of tank floor slab at 22m ","m²",290,{"$nulls":4},1806.79,{"$f":"E228*J228","v":523969.1}]
[null,null,"above ground level"]
["3.4.16","G8.2.2","Smooth vertical form work to sides of tank floor beams at 22m","m²",200,{"$nulls":4},706.46,{"$f":"E230*J230","v":141292}]
[null,null,"above ground level (Beams T1 & T2 & T4) - 12No. Each"]
["3.4.17","G8.2.2","Smooth horizontal form work to soffits of tank floor beams at 22m","m²",74,{"$nulls":4},1806.79,{"$f":"E232*J232","v":133702.46}]
[null,null,"above ground level (Beams T1 & T2 & T4) - 12No. Each"]
[null,null,"including 25 x 25 chamfer along all corners "]
["3.4.18","G8.2.2","Smooth vertical form work to sides of arched tank floor beams at","m²",210,{"$nulls":4},706.46,{"$f":"E235*J235","v":148356.6}]
[null,null,"22m above ground level (Beam T3) - 12No."]
["3.4.19","G8.2.2","Smooth horizontal curved form work to soffits of arched tank floor","m²",39,{"$nulls":4},1806.79,{"$f":"E237*J237","v":70464.81}]
[null,null,"beams at 22m above ground level (Beam T3) - 12No."]
[null,null,"including 25 x 25 chamfer along all corners "]
["3.4.20","G8.2.2","Smooth vertical form work to roof support columns at 0m to 7m","m²",279,{"$nulls":4},447.83,{"$f":"E240*J240","v":124944.56999999999}]
[null,null,"above tank floor level - 12No. & 12No."]
[null,null,"including 25 x 25 chamfer along all corners "]
[]
[{"$f":"A182+1","v":{"v":19,"d":"Schedule sub total carried forward to page 19"}},{"$nulls":9},{"$f":"SUM(K197:K243)","v":4285856.958000001}]
[{"$f":"A183+1","v":{"v":18,"d":"Bill of Quantities page number 18"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule3 continued"]
[null,"1 200",{"$f":"C192","v":"2,5 Mℓ capacity elevated water tower "}]
[null,null,{"$f":"C193","v":"Drawing reference : T01 to T05"}]
[{"$f":"A245","v":{"v":18,"d":"-\\schedule continued from page 18"}}]
[]
["3.4.21","G8.2.2","Smooth horizontal form work to soffit of roof slab at an angle of 10.8°","m²",340,{"$nulls":4},1705.24,{"$f":"E258*J258","v":579781.6}]
[null,null,"at 6m to 8m above tank floor level"]
["3.4.22","G8.2.2","Smooth vertical form work to sides of tank roof beams at 6m","m²",92,{"$nulls":4},534.15,{"$f":"E260*J260","v":49141.799999999996}]
[null,null,"above tank floor level (Beams R1 & R2) - 12No. Each"]
["3.4.23","G8.2.2","Smooth horizontal form work to soffits of tank roof beams at 6m","m²",38,{"$nulls":4},1274.56,{"$f":"E262*J262","v":48433.28}]
[null,null,"above tank floor level (Beams R1 & R2) - 12No. Each"]
[null,null,"including 25 x 25 chamfer along all corners "]
["3.4.24","G8.2.2","Smooth horizontal formwork to soffit of perimeter ledge at 29m above","m²",31,{"$nulls":4},1806.79,{"$f":"E265*J265","v":56010.49}]
[null,null,"ground level including drip groove & chamfers"]
["3.4.25","G8.2.2","Smooth vertical curving form work to roof ledge at 29m above ","m²",7,{"$nulls":4},945.73,{"$f":"E267*J267","v":6620.110000000001}]
[null,null,"ground level - 100mm high"]
["3.4.26","G8.2.2","Smooth vertical form work to roof access ","m²",2,{"$nulls":4},639.15,{"$f":"E269*J269","v":1278.3}]
["3.4.27","G8.2.2","Form 4,60m x 1,65m x 50mm deep reccesses to outside of",{"$nulls":5},{"v":1150.2727757769774,"d":"R 1,150.27"}]
[null,null,"tank wall to match existing","no",24,{"$nulls":3},{"v":4.185929648241206,"d":"4.2"},1565.93,{"$f":"E271*J271","v":37582.32}]
[]
[3.5,null,"Concrete surface finishing"]
[]
["3.5.1","G8.4.4","Uniform wood float finish on foundation slab","m²",462,{"$nulls":4},19.62,{"$f":"E275*J275","v":9064.44}]
["3.5.2","G8.4.4","Uniform wood float finish on top face column footings","m²",125,{"$nulls":4},19.62,2452.5]
["3.5.3","G8.4.4","Uniform wood float finish on top face of centre footing","m²",41,{"$nulls":4},19.62,804.4200000000001]
["3.5.4","G8.4.4","Uniform wood float finish to top of landing surfaces","m²",17,{"$nulls":4},19.62,333.54]
["3.5.5","G8.4.4","Uniform steel trowel finish on top of tank floor","m²",339,{"$nulls":4},19.62,6651.18]
["3.5.6","G8.4.4","Uniform wood float finish to top of tank roof","m²",387,{"$nulls":4},19.62,7592.9400000000005]
[]
[3.6,null,"Waterproofing"]
[]
["3.6.1",null,"Joint between tank wall and floor with 200mm wide combiflex "]
[null,null,"bandage system (Sikaflex of similar) both sides of concrete fillet","m",100,{"$nulls":4},596.81,{"$f":"E285*J285","v":59680.99999999999}]
[]
["3.6.2",null,"Joint between tank floor and shaft with 200mm wide combiflex"]
[null,null,"bandage system and 50 x 50 polyethelene foam trinagular fillet","m",8,{"$nulls":4},596.81,{"$f":"E288*J288","v":4774.48}]
[]
["3.6.3",null,"Horizontal wall construction jount with 150mm wide combiflex "]
[null,null,"bandage system","m",65,{"$nulls":4},{"v":531.7,"d":"531.70"},{"$f":"E291*J291","v":34560.5}]
[]
["3.6.4",null,"Horizontal jount between wall and roof beam with 150mm wide "]
[null,null,"Combiflex bandage system","m",50,{"$nulls":4},{"v":531.7,"d":"531.70"},{"$f":"E294*J294","v":26585.000000000004}]
[]
["3.6.5",null,"10 x 20 Swellable sealant (Penetron penebar or Sikaswell) around"]
[null,null,"pipes passing through tank floor","m",10,{"$nulls":4},596.81,{"$f":"E297*J297","v":5968.099999999999}]
{"$rows_empty":8}
[{"$f":"A244+1","v":{"v":20,"d":"Schedule sub total carried forward to page 20"}},{"$nulls":9},{"$f":"SUM(K258:K305)","v":937316}]
[{"$f":"A245+1","v":{"v":19,"d":"Bill of Quantities page number 19"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS",{"$f":"C7","v":"Schedule 3"}]
[null,"1 200",{"$f":"C254","v":"2,5 Mℓ capacity elevated water tower "}]
[null,null,{"$f":"C255","v":"Drawing reference : T01 to T05"}]
[{"$f":"A307","v":{"v":19,"d":"-\\schedule continued from page 19"}}]
[]
[3.7,null,"Steel works"]
[null,null,"Manufacture, deliver and install the following:"]
["3.7.1","HA8.3.1","Steel staircase in main shaft including handrails, all"]
[null,null,"from stainless steel 304 L as detailed on drg. St01","Item",{"$nulls":4},3,100000,{"$f":"I323*J323","v":300000}]
[]
["3.7.2","HA8.3.1","Steel cat ladder in access shaft from SS 304L as per drg. St02 ","Item"]
[{"$nulls":8},0.3,100000,{"$f":"I326*J326","v":30000}]
["3.7.3","HA8.3.1","Steel cat ladder to inside of tank from SS 304L as per drg. St03","Item"]
[{"$nulls":8},0.3,100000,{"$f":"I328*J328","v":30000}]
["3.7.4",null,"Steel hand grip from SS 304L on roof at manholes","Set",2]
[]
["3.7.4","HA8.3.1","Stainless steel Mentis handrailing system, 1m high on following:"]
[null,null,"1) Straight on edge of final landing","m",{"v":6.7,"d":"7"},{"$nulls":4},485.97,{"$f":"E332*J332","v":3255.9990000000003}]
[null,null,"2) Curved at 2,7m radius around roof access manhole","m",17,{"$nulls":4},660.88,{"$f":"E333*J333","v":11234.96}]
[]
["3.7.5","HA8.3.1","Steel cover on access shaft, including access lid, hinges, handles"]
[null,null,"lock etc. from stainless steel 3CR12 as detailed on drg. St03","Item",1,{"$nulls":4},{"v":30175.82,"d":"30,175.82"},10000]
[]
["3.7.6","HA8.3.1","Steel cover to tank access manhole including lid, hinges, handles "]
[null,null,"lock etc. from stainless steel 3CR12 as detailed on drg. St03","Item",1,{"$nulls":4},{"v":16356.58,"d":"16,356.58"},10000]
[]
["3.7.7","HA8.3.1","2,1m x 0,9m vandal proof security door with relative protection"]
[null,null,"level of 5, including frame with hidden hinges and security lock, "]
[null,null,"all from 304L stainless steel ","no",1,{"$nulls":4},10976.98,{"$f":"E343*J343","v":10976.98}]
[]
["3.7.8","HA8.3.1","0,4m wide x 1,0m high vandal proof large airflow louvres with "]
[null,null,"with double bent blades and fitted with vermin proofing inside,  "]
[null,null,"all from 304L stainless steel","no",16,{"$nulls":4},{"v":5978.2,"d":"5978.20"},{"$f":"E347*J347","v":95651.2}]
[]
["3.7.9","HA8.3.1","4.5mm x 250mm x 7.8m SS 304L plate perforated with 6mm holes "]
[null,null,"@ 50mm c/c, bent at a radius 1.25m as vent for final shaft","no ",1,{"$nulls":4},{"v":14640.71,"d":"14,640.71"},10000]
[]
[3.8,null,"Miscellaneous items"]
[null,null,"Manufacture, deliver and install the following:"]
[]
["3.8.1","HA8.3.1","500Ø Stainless steel pipe clamps as detailed","no",16,{"$nulls":4},3181.08,{"$f":"E355*J355","v":50897.28}]
["3.8.2","HA8.3.1","Ditto but 450Ø","no",5,{"$nulls":4},2464.42,{"$f":"E356*J356","v":12322.1}]
["3.8.3","HA8.3.1","Ditto but 150Ø","no",5,{"$nulls":4},2102.11,{"$f":"E357*J357","v":10510.550000000001}]
[]
["3.8.4","HA8.3.1","50mm Stainless steel safety hook cast in roof slab","no",2,{"$nulls":4},487.42,{"$f":"E359*J359","v":974.84}]
[]
["3.8.5","HA8.3.1","100Ø 304L SS roof ventilator as detailed on drg St03","no",4,{"$nulls":4},2813.64,{"$f":"E361*J361","v":11254.56}]
[]
["3.8.6","HA8.3.1","100Ø 304L SS sleeve with cover flange cast in roof slab","no",3,{"$nulls":4},{"v":1065.3,"d":"1065.30"},{"$f":"E363*J363","v":3195.8999999999996}]
[]
["3.8.7",null,"110Ø class 9 HDPE scour pipe to towers","m",30,{"$nulls":4},254.74,{"$f":"E365*J365","v":7642.200000000001}]
[]
["3.8.8",null,"Steel inspection tower on roof, 300Ø x 1,0m high, closed on top "]
[null,null,"with hinged lid ","no",3,{"$nulls":4},5321.93]
[]
["Schedule 3 total carried to summary page",{"$nulls":9},{"$f":"SUM(K323:K367)","v":607916.569}]
[{"$f":"A307+1","v":{"v":20,"d":"Bill of Quantities page number 20"}},{"$nulls":9},0]

{"sheet":"4 Pump","index":4,"n_rows":179,"n_cols":11,"rows_kept":179,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[56,0,56,5],[57,0,57,6],[63,2,64,2],[63,3,64,3],[63,4,64,4],[63,5,64,5],[117,0,117,5],[118,0,118,6],[124,2,125,2],[124,3,125,3],[124,4,125,4],[124,5,125,5],[177,0,177,5],[178,0,178,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"},{"$nulls":3},{"v":0.4,"d":"40.00%"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 4"]
[null,"1 200","Pump station and guard hut"]
[null,null,"Drawing reference: P01 to P03"]
[4.1,null,"Pump station"]
["4.1.1",null,"Earthworks for pump station"]
[]
["4.1.1.1","D8.3.2a","Excavate in bulk and stockpile for later use for backfill or embankment",{"$nulls":6},32.42,{"$f":"E13*J13","v":0}]
[null,null,"or dispose surplus material to remote site found by Contractor","m³",326]
[]
["4.1.1.2","D8.3.2.b1","Extra over for excavation in intermediate material","m³",20,{"$nulls":4},11.55,{"$f":"E16*J16","v":231}]
["4.1.1.3","D8.3.2.b2","Extra over for excavation in hard rock material","m³",5,{"$nulls":4},376.47,{"$f":"E17*J17","v":1882.3500000000001}]
[]
["4.1.1.4","D8.3.5","Extra over excavations for working space","m²",62,{"$nulls":4},89.07,{"$f":"E19*J19","v":5522.339999999999}]
["4.1.2",null,"Concrete works"]
["4.1.2.1","G8.4.2","75 mm thick blinding layer under floor slabs from 15 mPa concrete","m²",150,{"$nulls":4},{"v":144.2,"d":"144.20"},{"$f":"E21*J21","v":21630}]
["4.1.2.2","G8.4.3","250 mm floor slab from 30 Mpa concrete","m³",50,{"$nulls":4},2189.49,109474.49999999999]
["4.1.2.3","G8.4.3","250 and 300 mm walls from 30 Mpa concrete","m³",35,{"$nulls":4},2430.46,85066.1]
["4.1.2.4","G8.4.3","150mm floor slab and steps from 30MPa ","m³",6,{"$nulls":4},2558.54,15351.24]
["4.1.2.5","G8.4.3","200 - 255 roof slab with upstand beams","m³",62,{"$nulls":4},2697.45,167241.9]
["4.1.2.6","G8.4.3","100mm Concrete work top in telemetry room","m³",1.5,{"$nulls":4},{"v":3385.7,"d":"3385.70"}]
["4.1.2.7","G8.4.3","Pipe encasings from 25 Mpa concrete","m³",4,{"$nulls":4},{"v":2210.2,"d":"2210.20"},8840.8]
[]
["4.1.2.8","PSG3.5.1","Extra over 4.1.2.2 - 4.1.2.5 for Penetron waterproofing additive","m³",145,{"$nulls":4},515.53,74751.84999999999]
[null,null,"as specified in PSG 3.5.1 at a rate of 0,8% by weight of cementitious"]
[null,null,"content in the concrete mix"]
["4.1.2.8","G8.3.1","High tensile reinforcement for floor, walls & roof","kg",{"$f":"8800+4850+214+373+103+680+279+1","v":{"v":15300,"d":"15,300"}},{"$nulls":4},17.45,{"$f":"E32*J32","v":266985}]
["4.1.2.9","G8.1.2.2","Mild steel reinforcement for floor, walls & roof","kg",{"$f":"167+131+85+48+4","v":435},{"$nulls":4},17.45,{"$f":"E33*J33","v":7590.75}]
[]
["4.1.2.10","G8.2.2","Smooth vertical form work to walls","m²",155,{"$nulls":4},550.03,{"$f":"E35*J35","v":85254.65}]
["4.1.2.11","G8.2.2","Smooth vertical form work to roof upstands & channel sides","m²",115,{"$nulls":4},550.03,{"$f":"E36*J36","v":63253.45}]
["4.1.2.12","G8.2.2","Smooth horizontal form work to underside of roof slab","m²",230,{"$nulls":4},2424.88,{"$f":"E37*J37","v":557722.4}]
[]
["4.1.2.13","G8.4.4","Uniform wood float finish on roof slab","m²",230,{"$nulls":4},25.27,{"$f":"E39*J39","v":5812.099999999999}]
[]
["4.1.2.14","G8.1.1.2","Construct 25 mm x 25 mm chamfers on exposed concrete edges","m",280,{"$nulls":4},111.19,{"$f":"E41*J41","v":31133.2}]
["4.1.2.15","G8.1.1.2","Construct drip groof at roof slab","m",65,{"$nulls":4},136.91,{"$f":"E42*J42","v":8899.15}]
["4.1.2.16","G8.2.6","Form opening in wall for 700 mm Ø pipe and repair after"]
[null,null,"positioning of pipe with 30MPa concrete and water proof","no",1,{"$nulls":4},1649.28,{"$f":"E44*J44","v":1649.28}]
["4.1.2.17","G8.2.6","Form opening in wall for 400 mm Ø pipes and repair after"]
[null,null,"positioning of pipes with 30MPa concrete and water proof","no",4,{"$nulls":4},1484.33,{"$f":"E46*J46","v":5937.32}]
["4.1.2.18",null,"Form 450 x 450 x 450 de-watering sump in floor","no",1,{"$nulls":4},824.64,{"$f":"E47*J47","v":824.64}]
[]
["4.1.2.19",null,"Apply 2 layers epoxy based floor paint on pump station floor","m²",105,{"$nulls":4},63.27,{"$f":"E49*J49","v":6643.35}]
["4.1.3",null,"Building work"]
["4.1.3.1",null,"230mm Wide brick work using solid clay bricks of 10MPa (min.) in "]
[null,null,"class II mortar. Brickforce every 4th layer and damp course"]
[null,null,"at the bottom. Pre-cast lintols over all door openings.","m²",255,{"$nulls":4},596.47,{"$f":"E53*J53","v":152099.85}]
[]
["4.1.3.2",null,"Extra over item 4.3.1 for facebrick on outside with bricks matching"]
[null,null,"existing buildings on the site","m²",210,{"$nulls":4},219.34,{"$f":"E56*J56","v":46061.4}]
[{"v":22,"d":"Schedule sub total carried forward to page 22"},{"$nulls":9},{"$f":"SUM(K13:K56)","v":1729858.6199999999}]
[{"v":21,"d":"Bill of Quantities page number 21"}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 4 continued"]
[null,"1 200",{"$f":"C8","v":"Pump station and guard hut"}]
[null,null,{"$f":"C9","v":"Drawing reference: P01 to P03"}]
[{"$f":"A58","v":{"v":21,"d":"-\\schedule continued from page 21"}}]
["4.1.4",null,"Steel works"]
[]
["4.1.3.3",null,"Extra over item 4.3.1 for plastering on inside with 1:5 sand/cement"]
[null,null,"plaster and painted with one layer undercoat and 2 layers "]
[null,null,"low-gloss enamel paint","m²",295]
[]
[null,null,"Manufacture, deliver and install the following:"]
["4.1.4.1","HA8.3.1","2,1m x 0,9m vandal proof security door with relative protection"]
[null,null,"level of 5, including frame with hidden hinges and security lock, "]
[null,null,"all from 304L stainless steel ","no",2,{"$nulls":4},15010.62,{"$f":"E79*J79","v":30021.24}]
[]
["4.1.4.2","HA8.3.1","3m x 1,5m vandal proof security door with relative protection"]
[null,null,"level of 5, including frame with hidden hinges and security lock, "]
[null,null,"all from 304L stainless steel ","no",1,{"$nulls":4},24996.33,{"$f":"E83*J83","v":24996.33}]
[]
["4.1.4.3","HA8.3.1","0,87m wide x 0,5m high vandal proof large airflow louvres with "]
[null,null,"double bent blades and fitted with vermin proofing inside,  "]
[null,null,"all from 304L stainless steel","no",12,{"$nulls":4},8160.39,{"$f":"E87*J87","v":97924.68000000001}]
[]
["4.1.4.4","HA8.3.1","Overhead crane structure consisting of 152 x 152 x 23kg/m "]
[null,null,"I-columns with 250 x 250 x16 baseplate, 254 x 146 x 31kg/m and "]
[null,null,"203 x 133 x 23kg/m I-beams, all from heavy duty galvinised ",{"$nulls":6},{"v":67.8,"d":"67.80"},{"$f":"E91*J91","v":0}]
[null,null,"grade W350 mild steel","kg",{"v":3600,"d":"3,600"}]
[]
["4.1.5",null,"Miscellaneous items"]
[null,null,"Manufacture, deliver and install the following:"]
[]
["4.1.5.1","HA8.3.1","200x75x25kg/m back to back channel crawl beam fixed "]
[null,null,"to concrete roof slab and cantilevering 1,5m one end","kg",250,{"$nulls":4},{"v":67.8,"d":"67.80"},{"$f":"E98*J98","v":16950}]
[]
["4.1.5.2","HA8.3.1","3 Ton single crane beam on hand geared trolleys, including 3 ton","no",1,{"$nulls":4},5293.32,{"$f":"E100*J100","v":5293.32}]
[null,null,"mechanical hoist"]
[]
["4.1.5.3","HA8.3.1","3 Ton mechanical operated hoist for crawl beam","no",1,{"$nulls":4},3998.08,{"$f":"E103*J103","v":3998.08}]
[]
["4.1.5.4","HA8.3.1","Stainless steel Mentis handrailing system, 1m high ","m",20,{"$nulls":4},712.92,{"$f":"E105*J105","v":14258.4}]
[]
["4.1.5.5","HA8.3.1","Stainless steel rectgrid trench grid with 40 x 40 angle frame"]
[null,null,"to cover 450mm wide cable trench, in lengths of 2,0m max.","m",24,{"$nulls":4},2204.46,{"$f":"E108*J108","v":52907.04}]
[]
["4.1.5.6","HA8.3.1","Stainless steel rectgrid trench grid with 40 x 40 angle frame",{"$nulls":7},{"$f":"SUM(K70:K109)","v":246349.09}]
[null,null,"to cover 700mm wide cable trench, in lengths of 2,0m max.","m",5]
[]
["4.1.5.7","HA8.3.1","200x75x25kg/m back to back channel beam in cable"]
[null,null,"trench to support MCC cabinets","kg",{"v":1000,"d":"1,000"}]
[]
[]
[]
[{"$f":"A57+1","v":{"v":23,"d":"Schedule sub total carried forward to page 23"}}]
[{"$f":"A58+1","v":{"v":22,"d":"Bill of Quantities page number 22"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS",{"$f":"C7","v":"Schedule 4"}]
[null,"1 200",{"$f":"C67","v":"Pump station and guard hut"}]
[null,null,{"$f":"C68","v":"Drawing reference: P01 to P03"}]
[{"$f":"A69+1","v":{"v":22,"d":"-\\schedule continued from page 22"}}]
[]
["4.1.2.10",null,"Supply and install 100Ø uPVC sleeves for electrical and"]
[null,null,"telemetry cables","m",60,{"$nulls":4},66.08,{"$f":"E133*J133","v":3964.7999999999997}]
[]
["4.1.2.11",null,"Supply and install 100Ø uPVC lang radius bends for electrical"]
[null,null,"and telemetry cables","no",10,{"$nulls":4},{"v":88.2,"d":"88.20"},{"$f":"E136*J136","v":882}]
[]
[4.2,null,"Guard hut"]
[]
["4.2.1",null,"Construct guard hut as detailed on drawing P03, complete "]
[null,null,"with foundations, walls, doors and windows, roof slab and"]
[null,null,"electrical and plumbing installations","Item",1,{"$nulls":4},{"v":179451.09,"d":"179,451.09"},50000]
{"$rows_empty":33}
[{"$nulls":10},{"$f":"SUM(K133:K175)","v":54846.8}]
[]
["schedule 4 total carried to summary page",{"$nulls":9},0]
[{"$f":"A119+1","v":{"v":23,"d":"Bill of Quantities page number 23"}}]

{"sheet":"5 Fence","index":5,"n_rows":57,"n_cols":11,"rows_kept":57,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[55,0,55,5],[56,0,56,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"},{"$nulls":3},{"v":0.4,"d":"40.00%"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 5"]
[null,"1 200","Security wall"]
[]
[5.1,null,"Site clearance and Earthworks"]
[]
["5.1.1","C8.2.5","Take down existing concrete palisade fence, including concrete"]
[null,null,"bases and existing security gate and dispose to dumping site"]
[null,null,"found by Contractor","m",460,{"$nulls":4},{"v":103.9,"d":"103.90"},{"$f":"E14*J14","v":47794}]
[]
["5.1.2","C8.2.1","Clear and grub fence route, 2m wide and dispose to dumping ","m",460,{"$nulls":4},11.11,{"$f":"E16*J16","v":5110.599999999999}]
[null,null,"site found by Contractor"]
[]
["5.1.3","D8.3.2","Excavate in all materials and dispose for posts and ground beam","m³",140,{"$nulls":4},338.28,{"$f":"E19*J19","v":47359.2}]
[null,null,"below fence route"]
[]
[5.2,null,"Concrete works"]
[]
["5.2.1","G8.4.1","Formwork: Rough to sides of bases where required","m²",100,{"$nulls":4},{"v":268.8,"d":"268.80"},{"$f":"E24*J24","v":26880}]
[]
["5.2.2","G8.4.2","High tensile reinforcement in bases","kg",{"v":8000,"d":"8,000"},{"$nulls":4},{"v":43.4,"d":"43.40"},{"$f":"E26*J26","v":347200}]
[]
["5.2.3","G8.4.3","Cast from 25MPa concrete, 1,75m x 1,5m x0,35  bases for posts","m³",100]
[]
["5.2.4",null,"Supply and install 860mm high Precast Concrete Crash Barriers"]
[null,null,"along street edge","m",80]
[]
[5.3,null,"Precast wall"]
[]
["5.3.1","G8.4.1","Supply and install 460 x 460 x 4.0m long precast normal reinforced "]
[null,null,"concrete columns from 35MPa concrete with cast-in steel baseplate "]
[null,null,"and 4 x M20 holding down bolts. ","no",100,{"$nulls":4},1154.89,{"$f":"E37*J37","v":115489.00000000001}]
[]
[null,"G8.4.3","Supply and install 150mm thick x 1,2m wide precast, prestressed"]
[null,null,"hollowcore slabs from 60MPa concrete, cut in suitable lengths not"]
[null,null,"exceeding 6m, stressed to 25MPa internal stress after losses","m",{"v":1700,"d":"1,700"}]
[]
[null,null,"Supply and install razor wire flat wrap coil on top of precast boundary wall","m",600]
[]
["5.3.2",null,"Electrical fence on inside, attached to 75 x 75 posts with "]
[null,null,"energizer fitted in guard house","m",460,{"$nulls":4},{"v":179.2,"d":"179.20"},{"$f":"E46*J46","v":82432}]
[]
["5.3.3",null,"Manual operated security sliding gate with same specification as"]
[null,null,"aboce in 75 x 100 square tubing frame with wheels and rail."]
[null,null,"Slider support should be able to support 10 ton truck.","no",2,{"$nulls":4},{"v":16800,"d":"16800.00"},{"$f":"E50*J50","v":33600}]
[null,null,"Must be lockable with lock protection (anti-cut and anti-tamper)"]
[]
[]
[]
[]
["Schedule 5 total carried to summary page",{"$nulls":9},{"$f":"SUM(K14:K55)","v":705864.8}]
[{"$f":"'4 Pump'!A179+1","v":{"v":24,"d":"Bill of Quantities page number 24"}}]

{"sheet":"6 Chambers","index":6,"n_rows":120,"n_cols":11,"rows_kept":120,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[55,0,55,5],[56,0,56,6],[62,2,63,2],[62,3,63,3],[62,4,63,4],[62,5,63,5],[68,0,68,6],[118,0,118,5],[119,0,119,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"},{"$nulls":3},{"v":0.5,"d":"50.00%"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 6"]
[null,"1 200","Chambers"]
[null,null,"Drawing references S06"]
[6.1,null,"Earthworks"]
[]
["6.1.1","D8.3.2a","Excavate in bulk and dispose excess material to remote","m³",260,{"$nulls":4},32.42,{"$f":"E12*J12","v":8429.2}]
[null,null,"site found by Contractor"]
["6.1.2","D8.3.2.b1","Extra over for excavation in intermediate material","m³",20,{"$nulls":4},11.55,{"$f":"E14*J14","v":231}]
["6.1.3","D8.3.2.b2","Extra over for excavation in hard rock material","m³",10,{"$nulls":4},376.47,{"$f":"E15*J15","v":3764.7000000000003}]
["6.1.4","D8.3.5","Extra over excavations for working space","m³",113,{"$nulls":4},89.07,{"$f":"E16*J16","v":10064.91}]
[]
[6.2,null,"Concrete works"]
[]
["6.2.1","G8.4.2","75 mm thick blinding layer under floor slabs from 15 mPa concrete","m²",100,{"$nulls":4},{"v":144.2,"d":"144.20"},{"$f":"E20*J20","v":14419.999999999998}]
["6.2.2","G8.4.3","250 mm floor slab from 30 Mpa concrete","m³",30,{"$nulls":4},2189.49,{"$f":"E21*J21","v":65684.7}]
["6.2.3","G8.4.3","250mm walls from 30 Mpa concrete","m³",25,{"$nulls":4},2430.46,{"$f":"E22*J22","v":60761.5}]
["6.2.4","G8.4.3","100mm Concrete work top in telemetry room","m³",5,{"$nulls":4},{"v":3385.7,"d":"3385.70"},{"$f":"E23*J23","v":16928.5}]
[]
["6.2.5","PSG3.5.1","Extra over 6.2.3 for Penetron waterproofing additive"]
[null,null,"as specified in PSG 3.5.1 at a rate of 0,8% by weight of cementitious"]
[null,null,"content in the concrete mix","m³",30,{"$nulls":4},515.53,{"$f":"E27*J27","v":15465.9}]
[]
["6.2.6","G8.4.3","Cast and install 200mm thick precast roof slabs in the following"]
[null,null,"sizes, including formwork, openings, holes etc. with wood float"]
[null,null,"finish: (Reinforcing measured elsewhere)"]
[null,null,"3.5m x 2,5m","no",2,{"$nulls":4},{"v":7488.9,"d":"7488.90"},{"$f":"E32*J32","v":14977.8}]
[null,null,"3.5m x 1.75m","no",10,{"$nulls":4},6770.89,{"$f":"E33*J33","v":67708.90000000001}]
[null,null,"3.5m x 1.25m","no",4,{"$nulls":4},2727.26,{"$f":"E34*J34","v":10909.04}]
[null,null,"2.5m x 1.75m","no",2]
[]
["6.2.7","G8.3.1","High tensile reinforcement for floor, walls & roof","kg",{"v":9950,"d":"9,950"},{"$nulls":4},17.45,{"$f":"E37*J37","v":173627.5}]
[]
["6.2.8","G8.1.2.2","Mild steel reinforcement for floor, walls & roof","kg",225,{"$nulls":4},17.45,{"$f":"E39*J39","v":3926.25}]
[]
["6.2.9","G8.2.2","Smooth vertical form work to walls","m²",300,{"$nulls":4},550.03,{"$f":"E41*J41","v":165009}]
[]
["6.2.10","G8.4.4","Uniform wood float finish on floor slab","m²",100,{"$nulls":4},25.27,{"$f":"E43*J43","v":2527}]
[]
["6.2.11","G8.1.1.2","Construct 25 mm x 25 mm chamfers on exposed concrete edges","m",300,{"$nulls":4},111.19,{"$f":"E45*J45","v":33357}]
[]
["6.2.12","G8.2.6","Form opening in walls for 700mm Ø pipe and repair after"]
[null,null,"positioning of pipe with 30MPa concrete and water proof","no",1,{"$nulls":4},1649.28,{"$f":"E48*J48","v":1649.28}]
[]
["6.2.13","G8.2.6","Form opening in walls for 600mm Ø pipe and repair after"]
[null,null,"positioning of pipe with 30MPa concrete and water proof","no",2,{"$nulls":4},1236.96,{"$f":"E51*J51","v":2473.92}]
[]
["6.2.14","G8.2.6","Form opening in wall for 500 mm Ø pipes and repair after"]
[null,null,"positioning of pipes with 30MPa concrete and water proof","no",4,{"$nulls":4},{"v":907.1,"d":"907.10"}]
[]
[{"$f":"A120","v":{"v":26,"d":"Schedule sub total carried forward to page 26"}},{"$nulls":9},{"$f":"SUM(K12:K54)","v":671916.1}]
[{"v":25,"d":"Bill of Quantities page number 25"}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 6 continued"]
[null,"1 200",{"$f":"C8","v":"Chambers"}]
[null,null,{"$f":"C9","v":"Drawing references S06"}]
[{"$f":"A56","v":{"v":26,"d":"-\\schedule continued from page 26"}},{"$nulls":9},0]
[]
[6.3,null,"Miscellaneous items"]
[]
["6.2.15","G8.2.6","Form opening in wall for 350 mm Ø pipes and repair after"]
[null,null,"positioning of pipes with 30MPa concrete and water proof","no",2,{"$nulls":4},824.64,{"$f":"E73*J73","v":1649.28}]
[]
["6.2.16","G8.2.6","Form openings in wall for 500 x 300 vents","no",18]
[]
["6.2.17","G8.2.6","Form 400 x 400 x 650 de-watering sump in chambers","no",6]
[]
["6.3.1","HA8.3.1","Manufacture and install steel cat ladders to inside of chambers "]
[null,null,"from stainless steel 3CR12 as detailed on drg. St04, as follows:"]
[]
[null,null,"3.0m long","no",3,{"$nulls":4},11462.56,{"$f":"E82*J82","v":34387.68}]
[]
[null,null,"3.5m long","no",1,{"$nulls":4},13218.16,{"$f":"E84*J84","v":13218.16}]
[]
["6.3.2","HA8.3.1","Steel cover to openings in  pre-cast roof slabs, including frame,"]
[null,null,"access lid, hinges, handles, lock etc from"]
[null,null,"stainless steel 3CR12 as detailed on drg. St03","no",5,{"$nulls":4},9809.16,{"$f":"E88*J88","v":49045.8}]
[]
["6.3.4","HA8.3.1","Steel rectogrid cover to storm water junction box, including"]
[null,null,"steel frome and hinged access cover, all from SS304L as detailed"]
[null,null,"on drg S06","no",8,{"$nulls":4},4751.39,{"$f":"E92*J92","v":38011.12}]
[]
["6.3.5","HA8.3.1","0.5m wide x 0.3m high vandal proof large airflow louvres with "]
[null,null,"with double bent blades and fitted with vermin proofing inside,  "]
[null,null,"all from 304L stainless steel","no",18,{"$nulls":4},3638.39,{"$f":"E96*J96","v":65491.02}]
{"$rows_empty":22}
["schedule 6 total carried to summary page",{"$nulls":9},{"$f":"SUM(K68:K118)","v":201803.06}]
[{"$f":"A57+1","v":{"v":26,"d":"Bill of Quantities page number 26"}}]

{"sheet":"7 Pipe","index":7,"n_rows":304,"n_cols":7,"rows_kept":304,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[8,2,8,6],[48,0,48,5],[49,0,49,6],[55,2,56,2],[55,3,56,3],[55,4,56,4],[55,5,56,5],[113,0,113,5],[114,0,114,6],[120,2,121,2],[120,3,121,3],[120,4,121,4],[120,5,121,5],[124,0,124,2],[174,0,174,5],[175,0,175,6],[181,2,182,2],[181,3,182,3],[181,4,182,4],[181,5,182,5],[186,0,186,6],[238,0,238,5],[239,0,239,6],[245,2,246,2],[245,3,246,3],[245,4,246,4],[245,5,246,5],[250,0,250,6],[302,0,302,5],[303,0,303,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 7"]
[null,"1 200","Pipe work"]
[7.1,null,"Pipe work to water tower - See dwg W01, W02 for layouts and W05 for pipe schedule"]
[]
[null,null,"Manufacture, corrosion protect, deliver and install the following items as specified in CITWIF. Lining: Solvent Free Epoxy, minimum dft 500 microns. Coating: Polyisobutene Visco (PIB) Elastic System with coating thickness of 2300 microns"]
[null,null,"All steel pipe to be Grade X42, Pipe wall thickness for pipes with nominal diameter  ≤500mm – t = 4.5mm, Pipe wall thickness for pipes with nominal diameter  ⟩500mm - ≤700mm  – t = 5.2mm, Pipe wall thickness for pipes with nominal diameter  ⟩700mm - ≤900mm  – t = 6.0mm"]
[null,null,"Note for clarification – Pipe specials: Where JIS fittings is not available, Manufactured fittings will be allowed upon submission and approval of shop drawings, submitted by the contractor (manufactured as per BS 534-1990 as amended)."]
[null,null,"Note for clarification – Corrosion protection of pipe couplings: System used shall be compatible with PIB coating system as specified for all pipework. Cost for material and labour for corrosion protection of couplings included in cost of pipe elements as per specification."]
[]
["7.1.1",null,"Item T01 - 500Ø FLANGED BELLMOUTH WITH PUDDLE FLANGE","no",1]
["7.1.2",null,"Item T02 - 500Ø EXPANSION JOINT COUPLING","no",2]
["7.1.3",null,"Item T03 - 500Ø PIPE, FLANGED BOTH ENDS","no",12]
["7.1.4",null,"Item T04 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.1.5",null,"Item T05 - 500Ø LONG RADIUS FLANGED BEND EXTENDED WITH DUCKFOOT","no",1]
["7.1.6",null,"Item T06 - 500Ø PIPE, FLANGED BOTH ENDS","no",4]
["7.1.7",null,"Item T07 - 500Ø x 90° LONG RADIUS BEND ONE END FLANGED OTHER END PLAIN","no",1]
["7.1.8",null,"Item T08 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.1.9",null,"Item T09 - 500Ø PIPE, FLANGED BOTH ENDS WITH PUDDLE FLANGE","no",1]
["7.1.10",null,"Item T10 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.1.11",null,"Item T11 - 500Ø LONG RADIUS FLANGED BEND EXTENDED WITH DUCKFOOT","no",1]
["7.1.12",null,"Item T12 - 150Ø FLANGED BELLMOUTH WITH PUDDLE FLANGE","no",1]
["7.1.13",null,"Item T13 - 150Ø PIPE, FLANGED BOTH ENDS","no",4]
["7.1.14",null,"Item T15 - 150Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.1.15",null,"Item T16 - 150Ø LONG RADIUS FLANGED BEND WITH DUCKFOOT","no",1]
["7.1.16",null,"Item T17 - 150Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.1.17",null,"Item T18 - 150Ø LONG RADIUS FLANGED BEND","no",1]
["7.1.18",null,"Item T19 - 450Ø FLANGED BELLMOUTH ","no",1]
["7.1.19",null,"Item T20 - 450Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.1.20",null,"Item T21 - 450Ø PIPE, FLANGED BOTH ENDS WITH PUDDLE FLANGE","no",1]
["7.1.21",null,"Item T22 - 450Ø EXPANSION JOINT COUPLING","no",1]
["7.1.22",null,"Item T23 - 450Ø PIPE, FLANGED BOTH ENDS","no",5]
["7.1.23",null,"Item T24 - 450Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.1.24",null,"Item T25 - 450Ø LONG RADIUS FLANGED BEND ONE END EXTENDED WITH DUCKFOOT","no",1]
["7.1.25",null,"Item T26 - 450Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.1.26",null,"Item T27 - 450Ø TO 150Ø UNEQUAL FLANGED TEE","no",1]
["7.1.27",null,"Item T28 - 450Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.1.28",null,"Paint items 1 to 27 above with re-coatable polyurethane paint","Item",null,"Incl"]
[]
[7.2,null,"Pipe work to pump station - see dwg W03 for layouts, W06 for pipe schedule"]
[]
["7.2.1",null,"Item P01 - 700Ø FLANGED PIPE WITH PUDDLE FLANGE AND 50mm SOCKET","no",1]
[]
[{"v":28,"d":"Schedule sub total carried forward to page 28"}]
[{"v":27,"d":"Bill of Quantities page number 27"}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 7 continued"]
[null,"1 200",{"$f":"C8","v":"Pipe work"}]
[{"$f":"A50","v":{"v":27,"d":"-\\schedule continued from page 27"}}]
[]
[7.3,null,"Pipe work to site works"]
[]
["7.2.2",null,"Item P02 - 700ømm x 450mm x 45° ECCENTRIC Y-PIECE","no",3]
["7.2.3",null,"Item P03 - 700Ø FLANGED PIPE WITH  50mm SOCKET","no",2]
["7.2.4",null,"Item P04 - 700Ø x 400Ø CONCENTRIC FLANGED LONG REDUCER","no",1]
["7.2.5",null,"Item P05 - 400Ø BLANC FLANGE","no",1]
["7.2.6",null,"Item P07 - 450Ø FLANGED PIPE WITH 3 x 50mm SOCKETS","no",3]
["7.2.7",null,"Item P08 - 450Ø x 300Ø ECCENTRIC FLANGED LONG REDUCER","no",3]
["7.2.8",null,"Item P09 - 400Ø x 250Ø CONCENTRIC FLANGED REDUCER","no",3]
["7.2.9",null,"Item P10 - 400Ø x 90° FLANGED LONG RADIUS JIS ELBOW.","no",3]
["7.2.10",null,"Item P11 - 400Ø FLANGED PIPE WITH 3 x 50mm SOCKETS","no",3]
["7.2.11",null,"Item P13 - 400Ø ONE-END FLANGED PIPE WITH No.4 80 x 60 x 6mm ANGLE CLEATS","no",3]
["7.2.12",null,"Item P15 - 400Ø FLANGED PIPE","no",3]
["7.2.13",null,"Item P17 - 400Ø FLANGED PIPE WITH PUDDLE FLANGE","no",4]
["7.2.14",null,"Item P18 - 400Ø FLANGED PIPE","no",3]
["7.2.15",null,"Item P19 - 4400Ø x 90° FLANGED LONG RADIUS JIS ELBOW","no",4]
["7.2.16",null,"Item P20 - 700Ømm x 400mm SWIFT T-PIECE","no",4]
["7.2.17",null,"Item P21 -700Ø FLANGED PIPE","no",3]
["7.2.18",null,"Item P22 - 700Ø FLANGED PIPE","no",2]
["7.2.19",null,"Paint items 1 to 18 above with re-coatable polyurethane paint","Item",null,"Incl"]
[]
[null,null,"See dwg W04 for pipe layout and W07 to W08 for pipe schedules"]
[null,null,"1. Pipe work - Sution from existing 700dia pipe"]
["7.3.1",null,"Item 1.1 - 700Ø  FLANGE WELDED SKEW ONTO EXISTING PIPE","no",1]
["7.3.2",null,"Item 1.2 - 700Ø PIPE, FLANGED BOTH ENDS ONE SIDE WELDED SKEW MATCHING EXISTING","no",1]
["7.3.3",null,"Item 1.3 - 700Ø PIPE, FLANGED BOTH ENDS","no",{"$f":"4+9","v":13}]
["7.3.4",null,"Item S01- 700Ø LONG RADIUS FLANGED","no",1]
[]
[null,null,"2. Pipe work - 700dia pipe aligned with pump station"]
["7.3.5",null,"Item 2.1 - 700Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.6",null,"Item 2.2 - 700Ø TO 450Ø FLANGED UNEQUAL TEE","no",4]
["7.3.7",null,"Item 2.3 - 700Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.8",null,"Item 2.5 - 700Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.9",null,"Item 2.6 - 700Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.10",null,"Item 2.7 - 700Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.11",null,"Item 2.8 - 450Ø LONG RADIUS FLANGED","no",1]
["7.3.12",null,"Item 2.9 - 450Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.13",null,"Item 2.11 - 450Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.14",null,"Item 2.12 - 700Ø TO 450Ø ECCENTRIC FLANGED REDUCER","no",1]
["7.3.15",null,"Item 2.13 - 450Ø PIPE, FLANGED BOTH ENDS","no",4]
["7.3.16",null,"Item 2.14 - 700Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.17",null,"Item 2.15 - 700Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.18",null,"Item S02 - 700Ø LONG RADIUS FLANGED","no",1]
[]
[null,null,"3. Pipe work through outlet chamber to new tower inlet"]
["7.3.19",null,"Item 3.1 - 700Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.20",null,"Item 3.2 - 700Ø PIPE, FLANGED BOTH ENDS WITH PUDDLE FLANGE","no",1]
["7.3.21",null,"Item 3.3 - 700Ø TO 600Ø ECCENTRIC FLANGED REDUCER","no",1]
["7.3.22",null,"Item 3.4 - 600Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.23",null,"Item 3.6 - 600Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.24",null,"Item 3.7 - 600Ø PIPE, FLANGED BOTH ENDS WITH PUDDLE FLANGE","no",1]
[]
[{"$f":"A49+1","v":{"v":29,"d":"Schedule sub total carried forward to page 29"}}]
[{"$f":"A50+1","v":{"v":28,"d":"Bill of Quantities page number 28"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 7 continued"]
[null,"1 200",{"$f":"C59","v":"Pipe work"}]
[{"$f":"A115","v":{"v":28,"d":"-\\schedule continued from page 28"}}]
[7.3,null,"Pipe work to site works"]
[]
["7.3.25",null,"Item 3.8 - 600Ø PIPE, FLANGED BOTH ENDS","no",2]
["7.3.26",null,"Item 3.9 - 600Ø SHORT RADIUS FLANGED BEND","no",2]
["7.3.27",null,"Item 3.10 - 600Ø TO 250Ø FLANGED TEE","no",1]
["7.3.28",null,"Item 3.11 - 250Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.29",null,"Item 3.13 - 600Ø PIPE, FLANGED BOTH ENDS WITH PUDDLE FLANGE","no",1]
["7.3.30",null,"Item 3.14 - 600Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.31",null,"Item 3.15 - 600Ø PIPE, FLANGED BOTH ENDS","no",2]
["7.3.32",null,"Item 3.16 - 600Ø TO 350Ø FLANGED, GUSSETTED TEE","no",1]
["7.3.33",null,"Item S03 - 600mm x 500mm SWIFT T-PIECE","no",1]
["7.3.34",null,"Item 3.17 - 600Ø TO 500Ø ECCENTRIC FLANGED REDUCER","no",1]
["7.3.35",null,"Item 3.18 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.36",null,"Item 3.20 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.37",null,"Item 3.21 - 500Ø PIPE, FLANGED BOTH ENDS WITH PUDDLE FLANGE","no",1]
["7.3.38",null,"Item 3.22 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.39",null,"Item 3.23 - 500Ø LONG RADIUS 30° BEND FLANGED BOTH ENDS","no",1]
["7.3.40",null,"Item 3.24 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
[]
[null,null,"4. Pipe work to existing 600dia pipe to existing tower and network"]
["7.3.41",null,"Item 4.1 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.42",null,"Item 4.3 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.43",null,"Item 4.4 - 500Ø PIPE, FLANGED BOTH ENDS WITH PUDDLE FLANGE","no",1]
["7.3.44",null,"Item 4.5 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.45",null,"Item 4.6 - 500Ø PURPOSE MADE Z-PIECE FROM 2 x SHORT RADIUS, FLANGED BOTH ENDS","no",1]
["7.3.46",null,"Item 4.7 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.47",null,"Item S04 - 600Ø TO 500Ø x 60° ECCENTRIC Y-PIECE, FLANGED ALL ENDS","no",1]
[]
[null,null,"5. Pipe work - existing 600dia pipe connecting new pumpstation existing tower/network"]
["7.3.48",null,"Item 5.1 - 600Ø  FLANGE WELDED ONTO EXISTING PIPE","no",2]
[]
["7.3.49",null,"Paint items 1 to 48 above with re-coatable polyurethane paint","Item",null,"Incl"]
[]
[null,null,"6. Pipe work - Overflow and scour from new tower to junction box"]
["7.3.50",null,"Item 6.1 - 450Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.51",null,"Item 6.2 - 600Ø PIPE ONE END FLANGED OTHER END PLAIN WITH PUDDLE FLANGE","no",1]
[]
[null,null,"7. Pipe work - Outlet from new tower to existing 700dia pipe network"]
["7.3.52",null,"Item 7.1 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.53",null,"Item 7.2 - 500Ø LONG RADIUS 45° BEND FLANGED BOTH ENDS","no",1]
["7.3.54",null,"Item 7.3 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.55",null,"Item 7.4 - 500Ø PIPE, FLANGED BOTH ENDS","no",2]
["7.3.56",null,"Item 7.5 - 500Ø PIPE, FLANGED BOTH ENDS","no",2]
["7.3.57",null,"Item 7.7 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.58",null,"Item 7.8 - 500Ø PIPE, FLANGED BOTH ENDS","no",1]
["7.3.59",null,"Item 7.9 - 500Ø LONG RADIUS FLANGED","no",1]
["7.3.60",null,"Item 7.10 - 500Ø PIPE FLANGED ONE END AND CURVED PLATE OTHER END "]
[null,null,"                      TO FIT 700mm EXISTING PIPE","no",1]
[]
[{"$f":"A114+1","v":{"v":30,"d":"Schedule sub total carried forward to page 30"}}]
[{"$f":"A115+1","v":{"v":29,"d":"Bill of Quantities page number 29"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 7 continued"]
[null,"1 200",{"$f":"C124","v":"Pipe work"}]
[{"$f":"A176","v":{"v":29,"d":"-\\schedule continued from page 29"}}]
[]
[]
[null,null,"8. Pipe work to reservoir bypass"]
["7.3.61",null,"Item 8.1 - 350Ø PIPE, FLANGED BOTH SIDES","no",1]
["7.3.62",null,"Item 8.2 - 350Ø PIPE, FLANGED BOTH SIDES WITH PUDDLE FLANGE","no",1]
["7.3.63",null,"Item 8.3  - 350Ø PURPOSE MADE Z-PIECE FROM 2 x SHORT RADIUS JIS BENDS","no",1]
["7.3.64",null,"Item 8.4 - 350Ø PIPE, FLANGED BOTH SIDES","no",1]
["7.3.65",null,"Item 8.5 - 350Ø PIPE, FLANGED BOTH SIDES WITH PUDDLE FLANGE","no",2]
["7.3.66",null,"Item 8.6 - 350Ø PIPE, FLANGED BOTH SIDES","no",{"$f":"4+7","v":11}]
["7.3.67",null,"Item 8.7 - 350Ø PIPE, FLANGED BOTH SIDES","no",1]
["7.3.68",null,"Item 8.8 - 350Ø x 50° PURPOSE MADE ECCENTRIC Y-PIECE","no",1]
["7.3.69",null,"Item 8.9 - 350Ø FLANGE WELDED ONTO EXISTING PIPE","no",2]
[]
["7.3.70",null,"Paint items 50 to 69 above with re-coatable polyurethane paint","Item",null,"Incl."]
[]
["7.3.71",null,"Provisional sum third party inspections on pipe work","Prov",1,{"v":250000,"d":"250,000.00"},{"v":250000,"d":"250,000.00"}]
["7.3.72","A8.5a","Provisional sums cathodic protection","Prov",1,{"v":1000000,"d":"1,000,000.00"},{"v":1000000,"d":"1,000,000.00"}]
[]
[7.4,null,"Connections to existing pipe work"]
[]
["7.4.1",null,"Cut into 75Ø scour to existing tower and connect to new 150Ø "]
[null,null,"balancing pipe","no"]
["7.4.2",null,"Cut into existing 700Ø underground pipe and connect new"]
[null,null,"700Ø pipe supply from RW reservoir","no"]
["7.4.3",null,"Cut into existing 700Ø underground pipe and connect new"]
[null,null,"500Ø pipe (new tower outlet)","no"]
["7.4.4",null,"Cut into existing 350Ø underground pipe and connect new"]
[null,null,"350Ø pipe (RW bypass to towers)","no"]
["7.4.5",null,"Cut into existing 600Ø underground pipe and connect new"]
[null,null,"500Ø pipe (old tower inlet)","no"]
["7.4.6",null,"Cut into existing 350Ø underground pipe and connect new"]
[null,null,"350Ø pipe","no"]
[]
[7.5,null,"Earthworks to new pipe works"]
[]
["7.5.1","8.3.2(a)","Trench excavate in soft material to"]
[null,null,"authorised trench width (1200mm) for"]
[null,null,"depth intervals:"]
[null,null,"   Over      and       Up to"]
[null,null,"  1,0 m             2,5 m","m"]
[]
["7.5.2","8.3.2(b)","Extra-over for excavation in: (provisional)"]
[null,null,"Intermediate material","m3"]
[null,null,"Hard rock material","m3"]
[]
["7.5.3","SABS","PIPE BEDDING & BACKFILLING"]
[null,"1200 LB","Granular material (G5) for bedding layer and cradle with material"]
[null,null,"from trench excavations, compacted to 90% Mod AASHTO","m3"]
[]
["7.5.4",null,"Selected fill material (G5) for blanket layer including placing "]
[null,null,"and compaction to 90% Mod AASHTO","m3"]
[]
[{"$f":"A175+1","v":{"v":31,"d":"Schedule sub total carried forward to page 31"}}]
[{"$f":"A176+1","v":{"v":30,"d":"Bill of Quantities page number 30"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 7 continued"]
[null,"1 200",{"$f":"C185","v":"Pipe work"}]
[{"$f":"A240","v":{"v":30,"d":"-\\schedule continued from page 30"}}]
[]
[]
["7.5.5",null,"General backfill material from trench excavations"]
[null,null,"including screening, placing and compaction to"]
[null,null,"90% Mod AASHTO density:","m3"]
[]
["7.5.6",null,"25MPa concrete in pipe encasing, support blocks, kick blocks"]
[null,null,"including shuttering where required","m3"]
[]
[7.6,null,"Concrete work to pipe supports"]
[]
["7.6.1","G8.4.3","Concrete to pipe supports of varies sizes from 30MPa concrete"]
[null,null,"on site, in chambers and in pump station","m3"]
[]
["7.6.2","G8.2.2","Smooth vertical formwork to side of concrete supports","m²"]
[]
["7.6.3","G8.2.6","High tensile reinforcement in concrete supports","kg"]
{"$rows_empty":35}
["schedule 7 total carried to summary page"]
[{"$f":"A240+1","v":{"v":31,"d":"Bill of Quantities page number 31"}}]

{"sheet":"8 Special Equipment","index":8,"n_rows":125,"n_cols":11,"rows_kept":125,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[54,3,54,6],[59,0,59,5],[60,0,60,6],[66,2,67,2],[66,3,67,3],[66,4,67,4],[66,5,67,5],[123,0,123,5],[124,0,124,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"},{"$nulls":3},{"v":0.4,"d":"40.00%"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 8"]
[null,"1 200","Special equipment"]
[8.1,null,"Pumps"]
[]
[null,null,"NOTE: SEE PARTICULAR SPECIFICATION  PP: PUMPS FOR "]
[null,null,"COMPLETE SPECIFICATION FOR THE PUMP SETS."]
[]
[null,null,"Supply following pumps with duty point 833m³/hr @ 35m head:"]
[null,null,"Horizontal volute casing, single-stage pumps, with ratings and "]
[null,null,"main dimensions to EN 733, long-coupled in back pull-out design"]
[null,null,"or similar. Pump shall flanged to SANS 1123 table 1600/3 "]
[null,null,"and fitted with digital pump meter."]
[null,null,"Pump shall be fitted with a 3-phase 110kW WEG motor suitable"]
[null,null,"to be used in conjunction with a VSD, and fitted with all  "]
[null,null,"required instrumentaion as per Partictular Specification PP."]
[null,null,"The tendered price shall include the supply, installation, testing"]
[null,null,"and commissioning of the complete pump set."]
[null,null,"Full technical specifications of the proposed pump shall"]
[null,null,"be submitted with the Tender.","no",3,{"$nulls":4},{"$f":"672192/2","v":{"v":336096,"d":"336096.00"}},{"$f":"E25*J25","v":1008288}]
[]
[8.2,null,"Flow meters"]
[]
[null,null,"SUPPLY AND INSTALL THE FOLLOWING  FULLBORE TURBINE "]
[null,null,"BULK FLOW METERS, FLANGED TO SANS 1123 TABLE 1600/3"]
[null,null,"FITTED WITH 4 - 20 mA TRANSMITTERS:"]
[]
["8.2.1",null,"600mmØ Full bore flow in inlet chamber","no",1,{"$nulls":4},84988.08,{"$f":"E33*J33","v":84988.08}]
[]
["8.2.2",null,"350mmØ Flow meter on reservoir bypass line","no",1,{"$nulls":4},{"v":51444.39,"d":"51,444.39"},{"$f":"E35*J35","v":51444.39}]
[]
[null,null,"SUPPLY AND INSTALL THE FOLLOWING CLAMP-ON ULTRASONIC FLOW METERS WITH 4 - 20 mA TRANSMITTERS:",{"$nulls":6},51444.39,{"$f":"E37*J37","v":0}]
[]
["8.2.3",null,"500mmØ on inlet & outlet to new tower","no",2,{"$nulls":4},51444.39]
[]
["8.3.4",null,"300mmØ on inlet & outlet to old tower","no",2,{"$nulls":4},51444.39]
[]
[8.3,null,"Pressure reducing valves"]
[]
[null,null,"SUPPLY AND INSTALL THE FOLLOWING SINGER S206-PR OR"]
[null,null,"EQUIVALENT PRESSURE REDUCING VALVES, FLANGED  TO"]
[null,null,"SANS 1123 TABLE 1600/3:"]
[]
["8.3.1",null,"350mmØ Singer PRV","no",2,{"$nulls":4},125613.21,{"$f":"E49*J49","v":251226.42}]
[]
[8.4,null,"VARIABLE SPEED DRIVES"]
[]
["8.4.1",null,"Supply variable speed drives suitable to control the speed of"]
[null,null,"3 phase 380V 110kW induction motors."]
[null,null,"The tendered price shall include the supply, installation, testing","Measured in Electrical Bill item 12.5.1",{"$nulls":5},99000,{"$f":"E55*J55","v":0}]
[null,null,"and commissioning of the complete pump set."]
[null,null,"Full technical specifications of the proposed controller shall"]
[null,null,"be submitted with the Tender."]
[]
[{"v":33,"d":"Schedule sub total carried forward to page 33"},{"$nulls":9},{"$f":"SUM(K25:K58)","v":1395946.89}]
[{"v":32,"d":"Bill of Quantities page number 32"}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS",{"$f":"C7","v":"Schedule 8"}]
[null,"1 200",{"$f":"C8","v":"Special equipment"}]
[{"$f":"A60-1","v":{"v":32,"d":"-\\schedule continued from page 32"}}]
[8.5,null,"Non-return valves"]
[]
["8.5.1",null,"450mmØ Diaphragm  TOP-STOP non-return valve flanged to"]
[null,null," SANS 1123 table 1600/3","no",1,{"$nulls":4},{"v":134672.64,"d":"134,673"}]
[]
["8.5.2",null,"350mmØ Diaphragm TOP-STOP non-return valve flanged to","no",1]
[null,null,"SANS 1123 table 1600/3"]
[]
["8.5.3",null,"400mmØ  Slanted seat Tilting Disk Valve","no",3,{"$nulls":4},{"v":90025.53,"d":"90,025.53"}]
[]
[8.6,null,"Isolating valves"]
[]
[null,null,"Supply and install the following Wedge-type isolating gate"]
[null,null,"valve, left-hand closing and non-rising spindle"]
[]
["8.6.1",null,"700mmØ Gate valve with gearbox","no",1,{"$nulls":4},{"v":153901.16,"d":"153,901.16"}]
[]
["8.6.2",null,"500mmØ Gate valve with gearbox","no",3,{"$nulls":4},{"v":119029.8,"d":"119,029.80"}]
[]
["8.6.3",null,"450mmØ Gate valve with gearbox","no",3,{"$nulls":4},{"v":97582.84,"d":"97,582.84"}]
[]
["8.6.4",null,"400mmØ Gate valve with gearbox","no",3,{"$nulls":4},{"v":53294.7,"d":"53,294.70"}]
[]
["8.6.5",null,"350mmØ Gate valve with gearbox","no",1,{"$nulls":4},{"v":30000,"d":"30,000.00"}]
[]
["8.6.6",null,"150mmØ Gate valve with handwheel","no",2,{"$nulls":4},{"v":27527.86,"d":"27,527.86"}]
[]
[8.7,null,"Expansion joint couplings"]
[]
[null,null,"Supply and install the following POSIFLEX or similar"]
[null,null,"expansion joint couplings:"]
[]
["8.7.1",null,"500mmØ","no",2,{"$nulls":4},{"v":18011.79,"d":"18,011.79"}]
["8.7.2",null,"450mmØ","no",1,{"$nulls":4},{"v":6477.18,"d":"6,477.18"}]
["8.7.3",null,"150mmØ","no",1,{"$nulls":4},{"v":3525.71,"d":"3,525.71"}]
[]
[8.8,null,"Fexible couplings"]
[]
[null,null,"Supply and install the following flanged adaptors couplings with"]
[null,null,"restrainer bolts"]
["8.8.1",null,"700mmØ","no",1,{"$nulls":4},{"v":4770.97,"d":"4,770.97"}]
["8.8.2",null,"500mmØ","no",1]
["8.8.3",null,"450mmØ","no",4,{"$nulls":4},{"v":4078.67,"d":"4,078.67"}]
["8.8.4",null,"400mmØ","no",3,{"$nulls":4},{"v":4078.67,"d":"4,078.67"}]
["8.8.5",null,"350mmØ","no",1,{"$nulls":4},{"v":4770.97,"d":"4,770.97"}]
[]
[8.9,null,"Air Valve"]
[]
[null,null,"150mmØ  PN16 air release valve including"]
[null,null,"150mmØ  isolating valve with handwheel"]
[null,null,"flanged to SANS 1123 table 1600/3","no",2,{"$nulls":4},28556.79]
[]
["schedule 8 total carried to summary page"]
[{"$f":"A61+1","v":{"v":33,"d":"Bill of Quantities page number 33"}}]

{"sheet":"9 Road","index":9,"n_rows":119,"n_cols":11,"rows_kept":119,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[54,0,54,5],[55,0,55,6],[61,2,62,2],[61,3,62,3],[61,4,62,4],[61,5,62,5],[117,0,117,5],[118,0,118,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"},{"$nulls":3},{"v":0.7,"d":"70.00%"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 9"]
[null,"1 200","Road works, kerbing & storm water"]
[null,null,"Drawing reference S03 & S04"]
[]
[9.1,null,"Road works"]
[]
["9.1.1","DM8.3.7a","Cut in all materials to stockpile","m³\n",750,{"$nulls":4},26.91,{"$f":"E13*J13","v":20182.5}]
[]
["9.1.2","DM8.3.7b","Extra-over item 9.1.1 for intermediate excavations","m³\n",230,{"$nulls":4},11.55,{"$f":"E15*J15","v":2656.5}]
[]
["9.1.3","DM8.3.7c","Extra-over item 9.1.1 for hard excavations","m³\n",380,{"$nulls":4},376.47,{"$f":"E17*J17","v":143058.6}]
[]
["9.1.4","DM8.3.3","Roadbed preparation compacted to 93% mod AASHTO","m³\n",210,{"$nulls":4},67.87,{"$f":"E19*J19","v":14252.7}]
[]
["9.1.5","DM8.3.5","Selected layer from stockpile compacted to 95% mod AASHTO","m³\n",210,{"$nulls":4},94.57,{"$f":"E21*J21","v":19859.699999999997}]
[]
["9.1.6","ME8.3.3","Construct subbase with G6 material from stockpile and compact"]
[null,null,"to 97% mod AASHTO.","m³\n",210,{"$nulls":4},{"v":110,"d":"110.00"},{"$f":"E24*J24","v":23100}]
[]
["9.1.7","ME8.3.3","Construct base with G5 material from stockpile and compact"]
[null,null,"to 97% mod AASHTO, stabilized with 3% cement by weight ","m³\n",210,{"$nulls":4},148.86,{"$f":"E27*J27","v":31260.600000000002}]
[]
["9.1.8","ME8.3.8","Stabilizing agent: Portland cement","ton",13,{"$nulls":4},2257.25,{"$f":"E29*J29","v":29344.25}]
[]
["9.1.8",null,"Apply weed killer and insecticide soil poisening over compacted "]
[null,null,"base layer","m²",{"v":1370,"d":"1,370"},{"$nulls":4},11.03,{"$f":"E32*J32","v":15111.099999999999}]
[]
["9.1.9","MJ8.2.2","Construct paving complete with 80mm interlocking blocks"]
[null,null,"using SABS approved blocks on 25mm sand bedding","m²",{"v":1370,"d":"1,370"},{"$nulls":4},{"v":327.1,"d":"327.10"},{"$f":"E35*J35","v":448127.00000000006}]
[]
["9.1.10","MJ8.2.3","Cut units to fit edge restraint","m",360,{"$nulls":4},{"v":21,"d":"21.00"},{"$f":"E37*J37","v":7560}]
[]
[9.2,null,"Kerbings"]
[]
[null,"MK8.2.1","Concrete kerbing with the following pre-cast kerbing:"]
["9.2.1",null,"a) Figure 7 semi-mountable kerbs","m",60,{"$nulls":4},229.02,{"$f":"E42*J42","v":13741.2}]
[]
["9.2.2",null,"b) Figure 8 mountable kerbs","m",300,{"$nulls":4},232.49,{"$f":"E44*J44","v":69747}]
{"$rows_empty":10}
[{"v":35,"d":"Schedule sub total carried forward to page 35"},{"$nulls":9},{"$f":"SUM(K13:K54)","v":838001.1499999999}]
[{"v":34,"d":"Bill of Quantities page number 34"}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule 9 continued"]
[null,"1 200",{"$f":"C8","v":"Road works, kerbing & storm water"}]
[null,null,{"$f":"C9","v":"Drawing reference S03 & S04"}]
[{"$f":"A56","v":{"v":34,"d":"-\\schedule continued from page 34"}}]
[]
[9.3,null,"Stormwater drainage"]
[]
["9.3.1","8.3.2(a)","Trench excavate in soft material to authorised trench width"]
[null,null,"for depth intervals:"]
["9.3.2",null,"   1,0 m             1,5 m","m3",80,{"$nulls":4},111.85,{"$f":"E73*J73","v":8948}]
[]
["9.3.3",null,"   1,5 m             2,0 m    ","m3",300,{"$nulls":4},134.22,{"$f":"E75*J75","v":40266}]
[]
["9.3.4",null,"   2,0 m             2,5 m","m3",0,null,"rate only",null,null,155.47]
[]
["9.3.5","8.3.2(b)","Extra-over for excavation in: (provisional)"]
[]
[null,null,"Intermediate material","m3",110,{"$nulls":4},11.55,{"$f":"E81*J81","v":1270.5}]
[]
[null,null,"Hard rock material","m3",190,{"$nulls":4},376.47,{"$f":"E83*J83","v":71529.3}]
[]
["9.3.6","LE8.2.1","Supply and lay 450Ø class 75D stormwater pipes ","m",210,{"$nulls":4},543.23,{"$f":"E85*J85","v":114078.3}]
[]
["9.3.7","LE8.2.8","Supply and install S/W junction boxes ","no",6,{"$nulls":4},11123.38,{"$f":"E87*J87","v":66740.28}]
[]
["9.3.8","LE8.2.8","Supply and install 3m wide kerb inlet","no",1,{"$nulls":4},25584.98,{"$f":"E89*J89","v":25584.98}]
[]
["9.3.9",null,"Construct s/w outlet headwall on 450Ø pipe","no",1,{"$nulls":4},{"v":7500,"d":"7500.00"},{"$f":"E91*J91","v":7500}]
{"$rows_empty":24}
[{"$nulls":10},{"$f":"SUM(K71:K115)","v":335917.36}]
[]
["schedule 9 total carried to summary page",{"$nulls":9},0]
[{"$f":"A56+1","v":{"v":35,"d":"Bill of Quantities page number 35"}}]

{"sheet":"10 Alterations","index":10,"n_rows":116,"n_cols":11,"rows_kept":116,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[51,0,51,5],[52,0,52,6],[58,2,59,2],[58,3,59,3],[58,4,59,4],[58,5,59,5],[62,0,62,5],[63,0,63,6],[114,0,114,5],[115,0,115,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"},{"$nulls":3},{"v":0.6,"d":"60.00%"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule10"]
[null,"1 200","Alterations and refurbishment of existing buildings"]
[10.1,null,"Dismantle. Remove and dispose the following:"]
[]
[null,null,"Dismantle, remove and dispatch to Joburg Water's designated"]
[null,null,"depot:"]
[]
["10.1.1",null,"All above ground pipes ranging from 225mmØ to 600mmØ"]
[null,null,"under and around existing tower, including valves, meters, etc.","Item",1]
[]
["10.1.2",null,"All pipe work in existing pump station mainly 450mmØ,"]
[null,null,"including valves and other equipment","Item",1]
[]
["10.1.3",null,"Carefully remove existing pump sets and deliver to designated"]
[null,null,"depot.","No ",3]
[]
["10.1.4",null,"Dismantle overhead crane beam and stantions","Item",1]
[]
["10.1.5",null,"Remove security door to existing tower ","Item",1]
[]
["10.1.5",null,"Dismantle, remove and dispose staircase in existing tower","Item",1]
[]
["10.1.6",null,"Disconnect and remove electrical cables in existing tower","Item",1]
{"$rows_empty":21}
[{"$nulls":10},300000]
[{"v":37,"d":"Schedule sub total carried forward to page 37"}]
[{"v":36,"d":"Bill of Quantities page number 36"}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule10 Continue"]
[null,"1 200","Alterations and refurbishment of existing buildings"]
[{"$f":"A53","v":{"v":36,"d":"-\\schedule continued from page 36"}}]
[]
[10.2,null,"Steel works"]
[]
[null,null,"Manufacture, deliver and install the following:"]
["10.2.1","HA8.3.1","Steel staircase in main shaft including handrails, all"]
[null,null,"from stainless steel 304 L as detailed on drg. St01","Item",1]
[]
["10.2.2","HA8.3.1","Steel cat ladder in access shaft from SS 304L as per drg. St02 ","Item",1]
[]
["10.2.3","HA8.3.1","Steel cat ladder to inside of tank from SS 304L as per drg. St03","Item",1]
[]
["10.2.4","HA8.3.1","2,1m x 0,9m vandal proof security door with relative protection"]
[null,null,"level of 5, including frame with hidden hinges and security lock, "]
[null,null,"all from 304L stainless steel ","no",1]
[]
["10.3",null,"Building work"]
[]
["10.3.1",null,"Break out pipes and other equipment in existing pump station, repair brickwork"]
[null,null,"repaint walls and prepare for new generator","Item",1]
[]
["10.3.2",null,"Fill up floor in pump existing pump room with 30MPa concrete","m³",20]
[]
["10.3.3",null,"Break out existing door to allow installation of new generator "]
[null,null,"re[lace door and brick up to match existing building","Item",1]
{"$rows_empty":27}
["Schedule 10 total carried to summary"]
[{"$f":"A53+1","v":{"v":37,"d":"Bill of Quantities page number 37"}}]

{"sheet":"11 Site Works","index":11,"n_rows":123,"n_cols":7,"rows_kept":123,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[56,0,56,5],[57,0,57,6],[63,2,64,2],[63,3,64,3],[63,4,64,4],[63,5,64,5],[67,0,67,5],[68,0,68,6],[121,0,121,5],[122,0,122,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule11"]
[null,"1 200","Site Works (Earthworks & Retaining Wall)"]
["11.1",null,"Site Clearance"]
[]
["11.1.1",null,"Clear and grub:"]
[]
[null,null,"Areas including removal of trees and shrubs up to 1,0 m girth, transport and"]
[null,null,"disposal of debris to designated dumping site within 60 km radius of site","m²",{"v":3400,"d":"3,400"}]
[]
["11.1.2",null,"Remove and grub large trees and tree stumps of girth:"]
[]
["11.1.2.1",null,"Over 1,0 m and up to and including 2,0 m","no",4]
[]
["11.1.2.2",null,"Over 2,0 m and up to and including 3,0 m","no",1]
[]
["11.1.3",null,"Reclear surfaces (only on instructions from Engineer):"]
[]
[null,null,"Areas","m²",{"v":2250,"d":"2,250"}]
[]
["11.1.3",null,"Take down existing fences","km",0.2]
[]
["11.1.4",null,"Remove topsoil to nominal depth of 150 mm and stockpile","m³",340]
[]
["11.2",null,"Bulk Earthworks "]
[]
["11.2.1",null,"Fill and compact with material from stockpile to 95% Mod AASHTO density","m³",300]
[]
["11.2.2",null,"Fill and compact with crushed building rubble stockpiled on site","m³",50]
[]
["11.2.3",null,"Fill with imported G5 material from source found by Contractor","m³",{"v":6000,"d":"6,000"}]
{"$rows_empty":20}
[{"$f":"A58+1","v":{"v":39,"d":"Schedule sub total carried forward to page 39"}}]
[{"$f":"'10 Alterations'!A116+1","v":{"v":38,"d":"Bill of Quantities page number 38"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule11 Continue"]
[null,"1 200","Site Works (Earthworks & Retaining Wall)"]
[{"$f":"A58","v":{"v":38,"d":"-\\schedule continued from page 38"}}]
[]
["10.3",null,"Retaining Wall"]
[]
[null,null,"Design Assumptions"]
[]
[null,null,"Wall length","m",160]
[null,null,"Maximum Wall height ","m",4]
[null,null,"Average Wall height ","m",2]
[null,null,"Face Angle","deg",70]
[null,null,"Loading conditions","kPa",5]
[null,null,"Ground surface behind the retaining wall","Level","0°"]
[null,null,"Insitu embankment","Fill"]
[]
[]
["11.3.1",null,"Foundations"]
[]
["11.3.1.1",null,"Excavate and hand trim for foundations"]
[null,null,"Soft material","m³",15]
[null,null,"Intermediate material","m³",10]
[null,null,"Hard rock material","m³",5]
[]
[null,null,"Concrete"]
[]
["11.3.1.2",null,"Supply and place 20MPa concrete in foundations"]
[]
["11.3.2",null,"Wall & Facings"]
[]
["11.3.2.1",null,"Supply and install ENVIROWALL precast concrete blocks","m²",350]
[]
["11.3.3",null,"Backfill"]
[]
["11.3.3.1",null,"Place, spread & compact backfill material to Manufacturer's specifications","m³",400]
[]
["11.3.3.2",null,"Supply and install geogrid mesh reinforcement","m³",{"v":1600,"d":"1,600"}]
[]
["11.3.4",null,"Steel Reinforcement"]
[]
["11.3.4.1",null,"High tensile steel reinforcement to structural concrete work"]
[null,null,"Various diameter bars ( To be specified by engineer )","ton",1.6]
[]
["11.3.5",null,"Erosion Protection & Drainage"]
[]
["11.3.5.1",null,"Supply and install bidim A2 for erosion protection","m²",750]
[]
["11.3.5.2",null,"Supply & place subsoil drain, incl. 19 mm no fines concrete"]
[null,null,"& 110Dia Flopipe all wrapped in bidim A2","m",160]
[]
["11.3.5.3",null,"Outlet pipes every 5m ","m",25]
[]
["11.3.5.4",null,"Engineers certificate for Retaining Wall","sum",1]
[]
[]
[]
["Schedule 11 total carried to summary"]
[{"$f":"A58+1","v":{"v":39,"d":"Bill of Quantities page number 39"}}]

{"sheet":"12 Electrical & Generator","index":12,"n_rows":428,"n_cols":10,"rows_kept":428,"merged":[[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[54,0,54,5],[55,0,55,6],[61,2,62,2],[61,3,62,3],[61,4,62,4],[61,5,62,5],[66,0,66,5],[119,0,119,5],[120,0,120,6],[126,2,127,2],[126,3,127,3],[126,4,127,4],[126,5,127,5],[130,0,130,5],[180,0,180,5],[181,0,181,6],[190,2,191,2],[190,3,191,3],[190,4,191,4],[190,5,191,5],[194,0,194,5],[241,0,241,5],[242,0,242,6],[248,2,249,2],[248,3,249,3],[248,4,249,4],[248,5,249,5],[252,0,252,5],[305,0,305,5],[306,0,306,6],[316,2,317,2],[316,3,317,3],[316,4,317,4],[316,5,317,5],[320,0,320,5],[366,0,366,5],[367,0,367,6],[376,2,377,2],[376,3,377,3],[376,4,377,4],[376,5,377,5],[380,0,380,5],[426,0,426,5],[427,0,427,6]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},{"$nulls":4},{"$f":"Works!F1","v":"Date :08/09/2025"},{"$nulls":3},{"v":0.3,"d":"30.00%"}]
["JOBURG WATER"]
[{"$f":"Works!A3","v":"Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"}]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule12"]
[null,"1 200","ELECTRICAL INSTALLATIONS"]
[12.1,null,"PRELIMINARIES"]
[]
["12.1.1",null,"Site facilities and workshop","Sum",1]
[]
["12.1.2",null,"Water, electricity and telecommunication services","Sum",1]
[]
["12.1.3",null,"Guarding of material","Sum",1]
[]
["12.1.4",null,"Setting out of works","Sum",1]
[]
["12.1.5",null,"Construction programme","Sum",1]
[]
["12.1.6",null,"Workshop drawings and \"As Built\" drawings and operating manuals","Sum",1]
[]
["12.1.7",null,"Off-loading of material","Sum",1]
[]
["12.1.8",null,"Cleaning of site upon completion of project","Sum",1]
[]
["12.1.9",null,"Testing and commissioning of the total project including "]
[null,null,"certificate of compliance","Sum",1]
[]
["12.1.10",null,"Supply and installation of signs and notices.","Sum",1]
[]
["12.1.11",null,"Site Meetings","Sum",1]
[]
["12.1.12",null,"Co-ordination with Civil Contractor, Mechanical Sub-Contractor and Client","Sum",1]
[]
["12.1.13",null,"Co-ordination with City Power (Upgrade of CB)","Sum",1]
[]
["12.1.14",null,"Amount to comply with all requirements of the OHS Act ","Sum",1]
[null,null,"and the specification"]
[]
["12.1.15",null,"Insurances as required by the contract.","Sum",1]
[]
["12.1.16",null,"Other Preliminary and general costs required by the contractor"]
[null,null,"(furnish details)"]
[null,null,"a)  Training","Prov",null,{"v":4500,"d":"4,500.00"},{"$f":"F45","v":{"v":4500,"d":"4,500.00"}}]
[]
["12.1.17",null,"Provisional Sum for Lightning Protection (Reinstating) on Existing Tower","Sum",1,{"v":50000,"d":"50,000.00"},{"$f":"E47*F47","v":{"v":50000,"d":"50,000.00"}}]
[]
["12.1.18",null,"Provisional Sum for Lightning Protection on New Tower","Sum",1,{"v":100000,"d":"100,000.00"},{"$f":"E49*F49","v":{"v":100000,"d":"100,000.00"}}]
[]
[]
[]
[]
[]
[{"$f":"A56+1","v":{"v":41,"d":"Schedule sub total carried forward to page 41"}}]
[{"$f":"'11 Site Works'!A123+1","v":{"v":40,"d":"Bill of Quantities page number 40"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule12 Continue"]
[null,"1 200",{"$f":"C8","v":"ELECTRICAL INSTALLATIONS"}]
[]
[{"$f":"A56","v":{"v":40,"d":"-\\schedule continued from page 40"}}]
[]
[12.2,null,"SITE RETICULATION, SITE LIGHTING, MANHOLES AND SLEEVES PIPES"]
[]
["12.2.1",null,"600/1000V PVC PVC SWA (ECC) PVC cable installed in cable sleeves "]
[null,null,"or in cable trenches with BCEW as specified"]
[]
[null,null,"185mm² 4 core with copper conductors  - ECC","m",400]
[null,null,"4mm² 3 core with copper conductors (Tower-Aviation lights)","m",260]
[null,null,"6mm2 3 core with copper conductor (Towers)","m",182]
[null,null,"6mm2 4 core with copper conductor (ECC) (Perimeter Lighting)","m",590]
[null,null,"25mm² 4 core with copper conductors (ECC) (Generator room/Gatehouse)","m",180]
[]
["12.2.2",null,"Termination of 600/1000V PVC PVC SWA (ECC) PVC cable"]
[]
[null,null,"185mm² 4 core with copper conductors","Each",8]
[null,null,"4mm² 3 core with copper conductors","Each",12]
[null,null,"6mm² 4 core with copper conductors","Each",30]
[null,null,"6mm² 3 core with copper conductors","Each",24]
[null,null,"25mm² 4core with copper conductors","Each",16]
[]
["12.2.3",null,"Cable joints for 600/1000V PVC PVC SWA (ECC) PVC cable"]
[]
[null,null,"185mm² 4 core with Cu conductors","Each",1]
[]
["12.2.4",null,"Cable sleeve pipes:"]
[]
[null,null,"160mm diameter sleeve pipe","m",75]
[null,null,"110mm diameter sleeve pipe","m",200]
[null,null,"50mm diameter sleeve pipe","m",100]
[]
["12.2.5",null,"Long radius bends for cable sleeve pipes:"]
[]
[null,null,"160mm diameter","Each",18]
[null,null,"110mm diameter","Each",6]
[null,null,"50mm diameter","Each",2]
[]
["12.2.6",null,"Excavation of cable sleeve pipe and cable trenches including backfilling"]
[null,null,"and compaction in the following soil types"]
[]
[null,null,"Soft and pickable material","m²",150]
[null,null,"Rock","m²",50]
[]
["12.2.7",null,"Perimeter light pole 7,5m MH with 1.5m overhang including","Each",15]
[null,null,"Beka LEDLume XP1 45W (6790 Lm)"]
[]
["12.2.8",null,"20 m High Mast light with 6 x 230W LED flood lights at 360Deg.","Each",1]
[]
["12.2.9",null,"Manhole complete as per detail","Each",8]
[]
["12.2.10",null,"2mm diameter galvanised steel draw wire","m",500]
[]
[]
[{"$f":"A121+1","v":{"v":42,"d":"Schedule sub total carried forward to page 42"}}]
[{"$f":"A56+1","v":{"v":41,"d":"Bill of Quantities page number 41"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule12 Continue"]
[null,"1 200",{"$f":"C65","v":"ELECTRICAL INSTALLATIONS"}]
[{"$f":"A121","v":{"v":41,"d":"-\\schedule continued from page 41"}}]
[]
[12.3,null,"SITE RETICULATION, SITE LIGHTING, MANHOLES AND SLEEVES PIPES"]
[]
["12.3.1",null,"Distribution boards complete as specified:"]
[null,null,"DB-1 (Pump station) Provisional sum","Each",1]
[null,null,"DB-G (Generator Room) Provisional sum","Each",1]
[null,null,"DB-GH (Gate House) Provisional sum","Each",1]
[null,null,"DB-T1 & T2 (Tower DBs) Provisional sum","Each",2]
[]
["12.3.2",null,"Light fittings complete with conduit outlet box and connection to"]
[null,null,"conduit and wiring"]
[null,null,"Type L1 (Pump Station + Towers 1 and 2)","Each",30]
[null,null,"Type L2","Each",14]
[]
["12.3.3",null,"Light switch complete with outlet box, cover plate and connection to conduit"]
[null,null,"and wiring"]
[null,null,"1 lever 1 way flush mounted","Each",2]
[null,null,"1 lever 1 way industrial","Each",2]
[null,null,"1 lever 1 way with IP65 rating industrial","Each",2]
[]
[null,null,"Switched socket outlets including outlet box, cover plate and connection"]
[null,null,"to conduit and wiring"]
[null,null,"Double flush mounted","Each",2]
[null,null,"Double surface mounted galvanised","Each",8]
[null,null,"40A 3 phase Surface Mount welding socket","Each",2]
[null,null,"Industrial single","Each",10]
[]
["12.3.4",null,"Isolators including outlet box, cover plate and connection"]
[null,null,"to conduit and wiring"]
[null,null,"30A double pole flush mounted ","Each",2]
[]
["12.3.5",null,"Conduit surface mounted on spacer bar saddles or installed recessed in"]
[null,null,"concrete slabs or walls-Galvanised"]
[null,null,"20mm diameter galvanised ","m",100]
[null,null,"25mm diameter galvanised ","m",100]
[]
["12.3.6",null,"PVC insulated conductor installed in conduit"]
[null,null,"2,5mm²","m",300]
[null,null,"4mm²","m",300]
[]
["12.3.7",null,"2,5mm² bare copper earth wire installed in conduit","m",300]
[]
["12.3.8",null,"Labelling of all power outlets (lights, switches, socket outlets and welding","Sum",1]
[]
["12.3.9",null,"Socket outlets","Sum",1]
[]
["12.3.10",null,"Telecom/LAN outlet (100x100 flush draw box with cover plate)","Each",1]
[]
[]
[{"$f":"A182+1","v":{"v":43,"d":"Schedule sub total carried forward to page 43"}}]
[{"$f":"A121+1","v":{"v":42,"d":"Bill of Quantities page number 42"}}]
[]
[]
[]
[]
["CONTRACT JW14402",{"$nulls":4},"Date :08/08/2025",{"$nulls":3},{"v":0.3,"d":"30.00%"}]
["JOBURG WATER"]
["Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule12 Continue"]
[null,"1 200",{"$f":"C8","v":"ELECTRICAL INSTALLATIONS"}]
[{"$f":"A182","v":{"v":42,"d":"-\\schedule continued from page 42"}}]
[]
[12.4,null,"EARTHING"]
[]
["12.4.1",null,"Supply and install earthmat- Resistance < 1 Ohm Provisional Amount","Sum",1]
[]
["12.4.2",null," 70mm² bare copper earth wire with terminations","m",10]
[]
["12.4.3",null,"Bonding of all metalwork in pump station and towers to earth","Sum",1]
[]
["12.4.4",null,"20mm diameter galvanised conduit surface mounted on spacer"]
[null,null,"bar saddles","m",30]
[]
["12.4.5",null,"Excavation, bedding, blanketing, backfilling and compaction of"]
[null,null,"earthmats in the following soil types:"]
[]
[null,null,"Soft and pickable material","m²",10]
[null,null,"Rock","m²",5]
[]
[12.5,null,"TOWERS (2X) AND PUMPSTATION"]
[]
["12.5.1",null,"Motor Control Centre (MCC) complete as specified: VSD-3 x 110kW"]
[null,null,"(Specification to be studied in detail and understood to price MCC)"]
[]
[null,null,"MCC 1 ","Each",1]
["12.5.2",null,"600/1000V PVC PVC SWA PVC cable installed in cable sleeves or in"]
[null,null,"cable trenches"]
[]
[null,null,"120mm² 4 core with copper conductors + 70 mm2 BCEW","m",60]
[null,null,"6mm² 4 core + 2.5 mm2 BCEW (Welding Sockets)","m",60]
[null,null,"2,5mm² 3 core with copper conductors (control)","m",750]
[null,null,"1,5mm² 12 core with copper conductors (control)","m",60]
[null,null,"1,5mm² 4 core with copper conductors (E/Stops)","m",170]
[null,null,"1,5mm² 7 core with copper conductors (E/Stops)","m",60]
[]
[12.5,null,"TOWERS (2X) AND PUMPSTATION"]
[]
["12.5.3",null,"Termination of 600/1000V PVC PVC SWA (ECC) PVC cable"]
[]
[null,null,"120mm² 4 core + 70 mm2 BCEW","Each",8]
[null,null,"4mm² 4 core + 2.5 mm2 BCEW (Welding Sockets)","Each",4]
[null,null,"1,5mm² 4 core","Each",6]
[null,null,"1,5mm² 12 core","Each",6]
[null,null,"1,5mm² 12 core","Each",12]
[null,null,"2,5mm² 3 core","Each",6]
[null,null,"6mm² 4 core","Each",4]
[]
[{"$f":"A243+1","v":{"v":44,"d":"Schedule sub total carried forward to page 44"}}]
[{"$f":"A182+1","v":{"v":43,"d":"Bill of Quantities page number 43"}}]
[]
[]
[]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule12 Continue"]
[null,"1 200",{"$f":"C194","v":"ELECTRICAL INSTALLATIONS"}]
[{"$f":"A243","v":{"v":43,"d":"-\\schedule continued from page 43"}}]
[]
["12.5.4",null,"Supply and install emergency stops at each motor on pedestal or on"]
[null,null,"motor terminal box."]
[]
[null,null,"Supply and Install emergency stop bottons","Each",3]
[]
["12.5.5",null,"JUNCTION BOXES"]
[]
[null,null,"At each motor to accommodate power and instrumentation","Each",3]
[null,null,"At pressure transducers -Pratley type 1 cable connection box","Each",12]
[null,null,"At ultrasonic transmitter (Size to suit application-IP65)","Each",7]
[]
["12.5.6",null,"300 x 50mm wide cable wire mesh tray and accessories (including all  "]
[null,null,"splices, mounting brackets, and fixing material)"]
[]
[null,null,"Cable tray","m",160]
[null,null,"External bend ","Each",4]
[null,null,"Internal bend ","Each",4]
[null,null,"T-piece","Each",4]
[null,null,"Horizontal bend","Each",4]
[]
["12.5.7",null,"200 x 50mm wide cable wire mesh tray and accessories (including all "]
[null,null,"splices, mounting brackets and fixing material):"]
[]
[null,null,"Cable tray","m",15]
[null,null,"External bend","Each",1]
[null,null,"Internal bend","Each",2]
[null,null,"T-piece","Each",2]
[null,null,"Horizontal bend","Each",3]
[]
["12.5.8",null,"50 x 50mm wide cable wire mesh tray and accessories (including all"]
[null,null,"splices, mounting brackets and fixing materials)"]
[]
[null,null,"Cable tray","m",80]
[null,null,"External bend","Each",2]
[null,null,"Internal bend","Each",4]
[null,null,"T-piece","Each",2]
[null,null,"Horizontal bend","Each",3]
[]
["12.5.9",null,"Galvanised conduit surface mounted on spacer bar saddles"]
[]
[null,null,"20mm diamter","m",50]
[null,null,"25mm diamter","m",50]
[]
["12.5.10",null,"Aviation warning lights"]
[]
[null,null,"Type C light","Each",4]
[null,null,"Mounting pole as per detail","Each",4]
[]
["12.5.11",null,"20m length of 5 core cable and special plug on one end for connection"]
[null,null,"of pump monitor to telemetry marshalling cubicle","Each",3]
[]
[{"$f":"A307+1","v":{"v":45,"d":"Schedule sub total carried forward to page 45"}}]
[{"$f":"A243+1","v":{"v":44,"d":"Bill of Quantities page number 44"}}]
[]
[]
[]
[]
["CONTRACT JW14402",{"$nulls":4},"Date :08/08/2025",{"$nulls":3},{"v":0.3,"d":"30.00%"}]
["JOBURG WATER"]
["Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"]
[]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule12 Continue"]
[null,"1 200",{"$f":"C252","v":"ELECTRICAL INSTALLATIONS"}]
[{"$f":"A307","v":{"v":44,"d":"-\\schedule continued from page 44"}}]
[]
[12.6,null,"INSTRUMENTATION , SENSORS AND TELEMETRY"]
[]
["12.5.12",null,"Testing and commissioning of complete pumpstation","Sum",1]
[]
["12.5.13",null,"Operating and maintenance manuals","Set",1]
[]
["12.5.14",null,"Framed drawings","Sum",1]
[]
["12.5.15",null,"Induction probe for flood alarm","Sum",1]
[]
["12.5.16",null,"Changing over of supply from old pump station to new pump station","Sum",1]
[null,null,"Stripping out, making safe, transport and delivery to stores of "]
[]
["12.5.17",null,"Electrical equipment in existing pump station","Sum",1]
[]
["12.5.18",null,"Training of operators","Sum",1]
[]
[null,null,"Complete with transducers but without control panels (Supplied by others)","Each",6]
[]
["12.6.2",null,"Pressure transducers including pipe fittings, bleeding valve and"]
[null,null,"connection to junction boxes. "]
[]
[null,null,"Pump suction side with display (Telemetry)","Each",3]
[null,null,"Pump suction side without display (control)","Each",3]
[null,null,"Pump delivery side with display (Telemetry)","Each",3]
[null,null,"Pump delivery side without display (control)","Each",3]
[null,null,"Supply manifold","Each",1]
[null,null,"Suction manifold","Each",1]
[]
["12.6.3",null,"Hydrostatic level probes for towers"]
[]
[null,null,"Supply and install 4-20mA output ","Each",3]
[]
["12.6.4",null,"Supply and install complete telemetry system including  24V DC supply"]
[null,null,"all instrumentation -and associated power -  supply cable from MCC "]
[null,null,"marshalling cubicle to sensors and to telemetry room. "]
[null,null,"Refer to detailed specification. "]
[null,null,"Preliminary Amount","Prov",1,{"v":1300000,"d":"1,300,000.00"},{"$f":"E360*F360","v":{"v":1300000,"d":"1,300,000.00"}}]
[]
["12.6.5",null,"Junction Boxes"]
[]
[null,null,"At pressure transducers -Pratley type 1 cable connection box","Each"]
[null,null,"At ultrasonic transmitter (Size to suit application-IP65)","Each"]
[]
[{"$f":"A368+1","v":{"v":46,"d":"Schedule sub total carried forward to page 46"}}]
[{"$f":"A307+1","v":{"v":45,"d":"Bill of Quantities page number 45"}}]
[]
[]
[]
[]
["CONTRACT JW14402",{"$nulls":4},"Date :08/08/2025",{"$nulls":3},{"v":0.3,"d":"30.00%"}]
["JOBURG WATER"]
["Turffontein Corridors of Freedom - Water Upgrade (Forest Hill New Tower and Pumpstation)"]
[]
["Item","Payment","Item Description","Unit","Quantities","Rate","Amount"]
["number","reference",{"$nulls":4},"Rands.cents"]
[null,"SANS","Schedule12 Continue"]
[null,"1 200",{"$f":"C320","v":"ELECTRICAL INSTALLATIONS"}]
[{"$f":"A368","v":{"v":45,"d":"-\\schedule continued from page 45"}}]
[]
[12.6,null,"INSTRUMENTATION , SENSORS AND TELEMETRY"]
[]
["12.6.6",null,"Pressure switches including pipe fittings, bleeding valve and"]
[null,null,"connection to junction boxes. (Back up for control purposes)"]
[]
[null,null,"Pump suction side 1B","Each",3]
[null,null,"Pump delivery side 3.5B","Each",3]
[]
[12.7,null,"GENERATOR INSTALLATION"]
[]
["12.7.1",null,"Supply and install an emergency power supply generator rated at 75% "]
[null,null,"of full load complete with automatic change over panel, complete "]
[null,null,"with 24 hour day tank and communication of all status parameters via"]
[null,null,"telemetry facility at pump station "]
[null,null,"Rating: 600 kVA, 420V, 50Hz @ PF=0.8","EA","Sum"]
[]
["12.7.2",null,"Civil works related to the mounting of the generator inside an existing"]
[null,null,"room incl. plinths for generator and control panels (if separate)","EA","Sum"]
[]
["12.7.3",null,"Termination and connection of power supply cables measured elsewhere.","EA","Sum"]
[]
["12.7.4",null,"Termination and connection of communication cables to MCC/telemetry","EA","Sum"]
{"$rows_empty":22}
["Schedule 12 total carried to summary"]
[{"$f":"A368+1","v":{"v":46,"d":"Bill of Quantities page number 46"}}]

{"sheet":"Sum","index":13,"n_rows":38,"n_cols":7,"rows_kept":38,"merged":[[2,0,2,2],[22,0,22,1],[24,0,24,1],[26,0,26,1],[28,0,28,1],[30,0,30,1],[37,0,37,2]]}
[{"$f":"Works!A1","v":"CONTRACT JW14402"},null,{"$f":"Works!F1","v":"Date :08/09/2025"}]
["JOBURG WATER"]
["Turffontein Corridors of Freedom - Water Upgrade (Foresthill New Tower and Pumpstation)"]
[]
["Summary of the Schedule of  Quantities"]
[null,"Description","Total:"]
["Schedule 1","Preliminary and general",{"$nulls":4},{"v":24900000,"d":"R 24,900,000.00"}]
["Schedule 2","Occupational health and safety requirements",{"$nulls":4},{"v":1500000,"d":"R 1,500,000.00"}]
["Schedule 3","2,5 Mℓ capacity elevated water tower ",{"$nulls":4},{"v":21300000,"d":"R 21,300,000.00"}]
["Schedule 4","Pump station and guard hut",{"$nulls":4},{"v":3850000,"d":"R 3,850,000.00"}]
["Schedule 5","Security fencing",{"$nulls":4},{"v":3000000,"d":"R 3,000,000.00"}]
["Schedule 6","Chambers",{"$nulls":4},{"v":1650000,"d":"R 1,650,000.00"}]
["Schedule 7","Pipe work",{"$nulls":4},{"v":10000000,"d":"R 10,000,000.00"}]
["Schedule 8","Special equipment",{"$nulls":4},{"v":5200000,"d":"R 5,200,000.00"}]
["Schedule 9","Road works, kerbing & storm water",{"$nulls":4},{"v":2100000,"d":"R 2,100,000.00"}]
["Schedule10","Alterations and refurbishment of existing buildings",{"$nulls":4},{"v":1200000,"d":"R 1,200,000.00"}]
["Schedule 11","Site Works",{"$nulls":4},{"v":3700000,"d":"R 3,700,000.00"}]
["Schedule 12","electrical & Emergency Generator installation",{"$nulls":4},{"v":8300000,"d":"R 8,300,000.00"}]
[{"$nulls":6},{"v":4000000,"d":"R 4,000,000.00"}]
[]
[]
[]
["Sub - total : construction value",{"$nulls":5},{"$f":"SUM(G7:G21)","v":{"v":90700000,"d":"R 90,700,000.00"}}]
[]
["Add -10% Contingencies"]
[]
["Sub - total",{"$nulls":5},{"$f":"G23+G25","v":{"v":90700000,"d":"R 90,700,000.00"}}]
[]
["Add - 10% for Escalation"]
[]
["Sub - total",{"$nulls":5},{"$f":"G27+G29","v":{"v":90700000,"d":"R 90,700,000.00"}}]
[]
["Add 15% Value Added Tax ",{"$nulls":5},{"$f":"G27*0.15","v":{"v":13605000,"d":"R 13,605,000.00"}}]
[]
["Total value of project carried to form of offer :",{"$nulls":5},{"$f":"G27+G33","v":{"v":104305000,"d":"R 104,305,000.00"}}]
[]
[]
[{"v":47,"d":"BOQ page number 47"}]