{"text_format":"3","workbook":"xlsx","n_sheets":19,"sheets":["1200A","1200A SMME","1200C","1200D","1200DB","1200DK","2001 CC1","1200HA","1200L","1200LB","1200LE","1200LG","1200ME","1200MF ","PART PC","PART PD","ELECTRICAL","MECHANICAL","SANS-SUM"],"not_rendered":{"images":2,"external_links":34,"defined_names":510},"read":"whole","date_system":"1900"}

{"sheet":"1200A","index":0,"n_rows":383,"n_cols":7,"rows_kept":383}
[]
[]
[{"$nulls":6},"GENERAL"]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["REFERS","NO"]
[]
[]
["SANS 1200 A","110.00","GENERAL",{"$nulls":3},{"$f":"IF($E9>0,IF($E9=\"-\",\"Rate Only\",$E9*F9),\"\")","v":""}]
[]
[null,null,"FIXED CHARGE ITEMS"]
[]
["8.3","110.01","Contractual Requirements ","Sum",1]
[]
["8.3.2","110.02","Establishment of Facilities on Site"]
[]
["SANS 1200 AB","110.02.01","Facilities for the Engineer"]
[]
["PSA 8.2.1","110.02.01.01","Furnished offices (3 No - 1 No Type 1, 1 No Type 2, 1 No Type 3)","Sum",1]
[]
["PSA 8.2.1","110.02.01.02","Computer equipment","Sum",1]
[]
["PSA 8.2.1","110.02.01.03","Nameboards (2 No)","Sum",1]
[]
["PSA 8.2.1","110.02.01.04","Carport","Sum",1]
[]
["SANS 1200 A"]
["8.3.2.1","110.02.01.05","Kitchen","Sum",1]
[]
[null,"110.02.01.06","Ablution and latrine facilities both male and female","Sum",1]
[]
[null,"110.02.01.07","Survey equipment and assistance","Sum",1]
[]
[null,"110.02.01.08","Safety equipment, including safety shoes, hard hat, eye protection, gloves, ear protection, dust mask, removable revolving orange light for vehicle & reflective vest for 10 No people","Prov sum ",1,{"v":30000,"d":"30,000.00"},{"$f":"E34*F34","v":{"v":30000,"d":"30,000.00"}}]
[]
[null,"110.02.01.09","Overheads, charges and profit on safety equipment","%",{"$f":"F34","v":{"v":30000,"d":"30,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E36*F36","v":{"v":3000,"d":"3,000.00"}}]
[]
["8.3.2.2","110.02.02","Facilities for the Contractor"]
[]
[null,"110.02.02.01","Offices and storage sheds","Sum",1]
[]
[null,"110.02.02.02","Workshops","Sum",1]
[]
[null,"110.02.02.03","Laboratories","Sum",1]
[]
[null,"110.02.02.04","Ablution and latrine facilities","Sum",1]
[]
[null,"110.02.02.05","Tools and equipment","Sum",1]
[]
[null,"110.02.02.06","Water Supply, Electrical power and  communications","Sum",1]
[]
[null,"110.02.02.07","Dealing with water","Sum",1]
[]
[null,"110.02.02.08","Access","Sum",1]
[]
[null,"110.02.02.09","Transport to and establish on site all Construction plant and equipment","Sum",1]
[]
[null,"110.02.02.10","Mobile Toilets on Site","Sum",1]
[]
[]
["1200 A","Carried forward"]
[]
[]
[{"$nulls":6},"GENERAL"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["REFERS","NO"]
[]
[]
[null,null,"Brought forward"]
[]
["SANS 1200A"]
["8.3.4","110.03","Remove Contractors Site Establishment and make good","Sum",1]
[]
[null,"110.03.01","Other fixed charge obligations not covered above (Tenderer to list)"]
[]
[null,"110.03.01.01",null,"Sum",1]
[]
[null,"110.03.01.02",null,"Sum",1]
[]
[null,"110.03.01.03",null,"Sum",1]
[]
[null,"110.03.01.04",null,"Sum",1]
[]
["PSA 8.3.5","110.04","Additional Contractual Obligations"]
[]
["PSA 8.3.5.1","110.04.01","Notice and warning to consumers","Sum",1]
[]
["PSA 8.3.5.2","110.04.02","OHS Act Obligations","Sum",1]
[]
["PSA 8.3.5.3","110.04.03","EMP Obligations","Sum",1]
[]
["8.3.5.4","110.04.04","Dilapidation Survey","Sum",1]
[]
[null,null,"TIME RELATED ITEMS"]
[]
["PSA 8.4.1","110.05","Contractual Requirements ","Sum",1]
[]
["8.4.2","110.06","Operation and maintenance of facilities on site, for duration of construction, except where otherwise stated"]
[]
["SANS 1200 AB","110.06.01","Facilities for the Engineer"]
[]
["PSAB 8.2.2","110.06.01.01","Furnished offices (3 No - 1 No Type 1, 1 No Type 2, 1 No Type 3)","Sum",1]
[]
["PSAB 8.2.2","110.06.01.02","Telephone (and computer equipment)","Sum",1]
[]
["PSAB 8.2.2","110.06.01.03","Carport","Sum",1]
[]
["SANS 1200 A"]
["PSAB 8.3.2.1","110.06.01.04","Kitchen","Sum",1]
[]
[null,"110.06.01.06","Ablution and latrine facilities both male and female","Sum",1]
[]
[null,"110.06.01.07","Survey equipment and assistance","Sum",1]
[]
[null,"110.06.01.08","Safety equipment, including safety shoes, hard hat, eye protection, gloves, ear protection, dust mask, removable revolving orange light for vehicle & reflective vest for 10 No people","Sum",1]
{"$rows_empty":7}
["1200 A","Carried forward"]
[]
[]
[{"$nulls":6},"GENERAL"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["REFERS","NO"]
[]
[]
[null,null,"Brought forward"]
[]
["SANS 1200A"]
["8.4.2.2","110.06.02","Facilities for the Contractor"]
[]
[null,"110.06.02.01","Offices and storage sheds","Sum",1]
[]
[null,"110.06.02.02","Workshops","Sum",1]
[]
[null,"110.06.02.03","Laboratories","Sum",1]
[]
[null,"110.06.02.04","Ablution and latrine facilities","Sum",1]
[]
[null,"110.06.02.05","Tools and equipment","Sum",1]
[]
[null,"110.06.02.06","Water Supply, Electrical power and  communications","Sum",1]
[]
[null,"110.06.02.07","Dealing with water","Sum",1]
[]
[null,"110.06.02.08","Plant","Sum",1]
[]
[null,"110.06.02.09","First aid & medical services","Sum",1]
[]
[null,"110.06.02.10","Transport arrangements for labour from all communities to and from workplace to central collection / drop-off point","Sum",1]
[]
[null,"110.07","Supervision for Duration of Contract"]
[]
["8.4.3","110.07.01","Company and head office overhead costs for the duration of the Contract","months",18]
[]
["8.4.5","110.08","Other time related obligations not covered above (Tenderer to list)"]
[]
[null,"110.08.01",null,"months",18]
[]
[null,"110.08.02",null,"months",18]
[]
[null,"110.08.03",null,"months",18]
[]
[null,"110.08.04",null,"months",18]
[]
["PSA 8.4.6","110.09","Additional Obligations"]
[]
["PSA 8.4.6.1","110.09.01","OHS Act Obligations","Sum",1]
[]
["PSA 8.4.6.2","110.09.02","Security Services Costs","Month",18]
[]
["PSA 8.4.6.3","110.09.03","Electrical Safety Officer","Month",18]
[]
["PSA 8.4.6.4","110.09.04","CLO ","Prov sum ",1,{"v":900000,"d":"900,000.00"},{"$f":"E182*F182","v":{"v":900000,"d":"900,000.00"}}]
[]
[null,"110.09.05","Overheads, charges and profit on item\n110.09.04","%",{"$f":"F182","v":{"v":900000,"d":"900,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E184*F184","v":{"v":90000,"d":"90,000.00"}}]
{"$rows_empty":7}
["1200 A","Carried forward"]
[]
[]
[{"$nulls":6},"GENERAL"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["REFERS","NO"]
[]
[]
[null,null,"Brought forward"]
[]
[]
["SANS 1200 A"]
["PSA 8.5","110.10","Sums stated provisionally by the Engineer:"]
[]
[null,"110.10.01","Works executed by Nominated Subcontractors"]
[]
["PSA 8.5.2","110.10.01.01","Alteration to existing services by authorities","Prov sum ",1,{"v":714609.6,"d":"714,609.60"},{"$f":"E210*F210","v":{"v":714609.6,"d":"714,609.60"}}]
[]
[null,"110.10.01.02","Overheads, charges and profit on item 110.10.01.01","%",{"$f":"F210","v":{"v":714609.6,"d":"714,609.60"}},{"v":0.1,"d":"10%"},{"$f":"E212*F212","v":{"v":71460.96,"d":"71,460.96"}}]
[]
[null,"110.10.01.03","Control survey by independent surveyor","Prov sum ",1,{"v":360000,"d":"360,000.00"},{"$f":"E214*F214","v":{"v":360000,"d":"360,000.00"}}]
[]
[null,"110.10.01.04","Overheads, charges and profit on item 110.10.01.03","%",{"$f":"F214","v":{"v":360000,"d":"360,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E216*F216","v":{"v":36000,"d":"36,000.00"}}]
[]
[null,"110.10.01.05","Control tests by independent laboratory","Prov sum ",1,{"v":119101.6,"d":"119,101.60"},{"$f":"E218*F218","v":{"v":119101.6,"d":"119,101.60"}}]
[]
[null,"110.10.01.06","Overheads, charges and profit on item 110.10.01.05","%",{"$f":"F218","v":{"v":119101.6,"d":"119,101.60"}},{"v":0.1,"d":"10%"},{"$f":"E220*F220","v":{"v":11910.16,"d":"11,910.16"}}]
[]
[null,"110.10.01.07","Provision of photographic records","Prov sum ",1,{"v":100000,"d":"100,000.00"},{"$f":"E222*F222","v":{"v":100000,"d":"100,000.00"}}]
[]
[null,"110.10.01.08","Overheads, charges and profit on item 110.10.01.07","%",{"$f":"F222","v":{"v":100000,"d":"100,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E224*F224","v":{"v":10000,"d":"10,000.00"}}]
[]
[null,"110.10.01.09","Temporary protection of services","Prov sum ",1,{"v":595508,"d":"595,508.00"},{"$f":"E226*F226","v":{"v":595508,"d":"595,508.00"}}]
[]
[null,"110.10.01.10","Overheads, charges and profit on item 110.10.01.09","%",{"$f":"F226","v":{"v":595508,"d":"595,508.00"}},{"v":0.1,"d":"10%"},{"$f":"E228*F228","v":{"v":59550.8,"d":"59,550.80"}}]
[]
[null,"110.10.01.11","Reinstatement of asphalt by JRA","Prov sum ",1,{"v":2000000,"d":"2,000,000.00"},{"$f":"E230*F230","v":{"v":2000000,"d":"2,000,000.00"}}]
[]
[null,"110.10.01.12","Overheads, charges and profit on item 110.10.01.11","%",{"$f":"F230","v":{"v":2000000,"d":"2,000,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E232*F232","v":{"v":200000,"d":"200,000.00"}}]
[]
[null,"110.10.01.13","Supply or hire of specialist equipment","Prov sum ",1,{"v":2000000,"d":"2,000,000.00"},{"$f":"E234*F234","v":{"v":2000000,"d":"2,000,000.00"}}]
[]
[null,"110.10.01.14","Overheads, charges and profit on item 110.10.01.13","%",{"v":2000000,"d":"2,000,000.00"},{"v":0.1,"d":"10%"},{"$f":"E236*F236","v":{"v":200000,"d":"200,000.00"}}]
[]
[null,"110.10.01.15","Training of labour and SMMEs","Prov sum ",1]
[]
[null,"110.10.01.16","Overheads, charges and profit on item 110.10.01.15","%",{"$f":"+F238","v":0}]
[]
["PSA 8.4.2","110.10.01.17","Telephone and data charges for Engineers Representative","Prov sum ",1,{"v":50000,"d":"50,000.00"},{"$f":"E242*F242","v":{"v":50000,"d":"50,000.00"}}]
[]
[null,"110.10.01.18","Overheads, charges and profit on item 110.10.01.17","%",{"$f":"F242","v":{"v":50000,"d":"50,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E244*F244","v":{"v":5000,"d":"5,000.00"}}]
[]
["PSA 8.5.2","110.10.01.19","Fixed-Charge items for the sub-contractors Contractual Requirements","Prov sum ",1,{"v":297754,"d":"297,754.00"},{"$f":"E246*F246","v":{"v":297754,"d":"297,754.00"}}]
[]
[null,"110.10.01.20","Overhead, charges and profit for the Main Contractor to provide for fixed-charge items for the sub-contractors Contractual Requirements","%",{"$f":"F246","v":{"v":297754,"d":"297,754.00"}},{"v":0.1,"d":"10%"},{"$f":"E248*F248","v":{"v":29775.4,"d":"29,775.40"}}]
[]
[]
["1200 A","Carried forward"]
[]
[]
[{"$nulls":6},"GENERAL"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["REFERS","NO"]
[]
[]
[null,null,"Brought forward"]
[]
[]
["SANS 1200 A"]
["PSA 8.5.2","110.10.01.21","Time Related items for the sub-contractors Contractual Requirements","Prov sum ",1,{"v":535960,"d":"535,960.00"},{"$f":"E265*F265","v":{"v":535960,"d":"535,960.00"}}]
[]
[null,"110.10.01.22","Overhead, charges and profit for the Main Contractor to provide for time related items for the sub-contractors Contractual Requirements","%",{"$f":"F265","v":{"v":535960,"d":"535,960.00"}},{"v":0.1,"d":"10%"},{"$f":"E267*F271","v":{"v":53596,"d":"53,596.00"}}]
[]
["PSA 8.5.2","110.10.01.23","Specials and fittings for tie-in to existing Water meter Chamber (Dale Road)","Prov sum ",1,{"v":100000,"d":"100,000.00"},{"$f":"F269","v":{"v":100000,"d":"100,000.00"}}]
[]
[null,"110.10.01.24","Overheads, charges and profit on item 110.10.01.23","%",{"$f":"F269","v":{"v":100000,"d":"100,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E271*F271","v":{"v":10000,"d":"10,000.00"}}]
[]
["PSA 8.5.2","110.10.01.25","Specials and fittings for tie-in to existing water pipe (Harry Galaun Drive)","Prov sum ",1,{"v":100000,"d":"100,000.00"},{"$f":"F273","v":{"v":100000,"d":"100,000.00"}}]
[]
[null,"110.10.01.26","Overheads, charges and profit on item 110.10.01.25","%",{"$f":"F273","v":{"v":100000,"d":"100,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E275*F275","v":{"v":10000,"d":"10,000.00"}}]
[]
["PSA 8.5.2","110.11","Remove and grub trees as instructed by JPCZ","Prov sum ",1,{"v":200000,"d":"200,000.00"},{"$f":"E277*F277","v":{"v":200000,"d":"200,000.00"}}]
[]
[null,"110.11.01","Overheads, charges and profit on control tests by independent laboratory","%",{"$f":"F277","v":{"v":200000,"d":"200,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E279*F279","v":{"v":20000,"d":"20,000.00"}}]
[]
["PSA 8.7","110.12","Daywork (Provisional)"]
[]
[null,"110.12.01","Allowance for labour","Prov sum ",1,{"v":595510,"d":"595,510.00"},{"$f":"F283","v":{"v":595510,"d":"595,510.00"}}]
[]
[null,"110.12.02","Percentage adjustment to item 110.12.01","%",{"$f":"F283","v":{"v":595510,"d":"595,510.00"}},{"v":0.1,"d":"10%"},{"$f":"E285*F285","v":{"v":59551,"d":"59,551.00"}}]
[]
[null,"110.12.03","Alowance for material","Prov sum ",1,{"v":595510,"d":"595,510.00"},{"$f":"F287","v":{"v":595510,"d":"595,510.00"}}]
[]
[null,"110.12.04","Percentage adjustment to item 110.12.03","%",{"$f":"F287","v":{"v":595510,"d":"595,510.00"}},{"v":0.1,"d":"10%"},{"$f":"E289*F289","v":{"v":59551,"d":"59,551.00"}}]
[]
[null,"110.12.05","Allowance for plant","Prov sum ",1,{"v":595510,"d":"595,510.00"},{"$f":"F291","v":{"v":595510,"d":"595,510.00"}}]
[]
[null,"110.12.06","Percentage adjustment to item 110.12.05","%",{"$f":"F291","v":{"v":595510,"d":"595,510.00"}},{"v":0.1,"d":"10%"},{"$f":"E293*F293","v":{"v":59551,"d":"59,551.00"}}]
[]
["PSA 8.8","110.13","Temporary Works"]
[]
["PSA 8.8.2","110.13.01","Accommodation of traffic","Sum",1]
[]
[null,"110.13.02","Location and protection of existing services"]
[]
["PSA 8.8.4","110.13.02.01","Electrical and other cables","Sum",1]
[]
["PSA 8.8.5","110.13.03","Survey and setting out of works","Sum",1]
[]
["PSA 8.8.6","110.13.04","Special water control","Sum",1]
[]
["PSA 8.8.7","110.13.05","Dealing with other service authorities, application for wayleaves, etc.","Sum",1]
[]
[]
[]
["1200 A","Carried forward"]
[]
[]
[{"$nulls":6},"GENERAL"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["REFERS","NO"]
[]
[]
[null,null,"Brought forward"]
[]
["SANS 1200A"]
["PSA 8.9","110.14","Compliance with OHS Act Regulations (including the Construction Regulations, 2014)","Sum",1]
[]
["PSA 8.10","110.15","Quality Assurance and Management Plan","Sum",1]
[]
["PSA 8.11","110.16","Compliance with the Environmental Management Plan","Sum",1]
{"$rows_empty":54}
[null,"TOTAL SECTION 1200 A CARRIED TO SUMMARY"]

{"sheet":"1200A SMME","index":1,"n_rows":67,"n_cols":7,"rows_kept":67}
[]
[{"$nulls":6},"GENERAL"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
["REFERS","NO"]
[]
[]
["SANS 1200 A ",{"v":111,"d":"111.00"},"GENERAL",{"$nulls":3},{"$f":"IF($E9>0,IF($E9=\"-\",\"Rate Only\",$E9*F9),\"\")","v":""}]
["SMME"]
["PSSC 1","110.11.01.19","Value of Subcontracted works","Prov sum ",1,{"v":12959777.02,"d":"12,959,777.02"},{"$f":"F11","v":{"v":12959777.02,"d":"12,959,777.02"}}]
[]
["PSSC 2","110.11.01.20","Management fee for the Main Contractor to oversee sub-contracted works. (the main contractor will retain liability and responsibility for the management, scheduling, and quality)","%",{"$f":"F11","v":{"v":12959777.02,"d":"12,959,777.02"}}]
{"$rows_empty":53}
[null,"TOTAL SECTION 1200 A SMME CARRIED TO SUMMARY",{"$nulls":4},{"$f":"SUM(G8:G65)","v":{"v":12959777.02,"d":"12,959,777.02"}}]

{"sheet":"1200C","index":2,"n_rows":224,"n_cols":9,"rows_kept":224}
[]
[]
[{"$nulls":8},"SECTION 1200 C"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SANS","130.00","SITE CLEARANCE",{"$nulls":5},""]
["1200 C",{"$nulls":7},""]
[{"$nulls":8},""]
["PSC","130.01","Clear and grub:",{"$nulls":5},""]
["8.2.1",{"$nulls":7},""]
[null,null,".01","Areas (chambers, structures, etc)",null,"m²",{"v":1322,"d":"1,322"}]
[{"$nulls":8},""]
[null,null,".02","Strips, 3,0 m wide (water)",null,"m",{"v":6847,"d":"6,847"}]
[{"$nulls":8},""]
["8.2.2","130.02","Remove and grub large trees and tree ",{"$nulls":5},""]
[null,null,"stumps of girth:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Over 1,0 m and up to and including ",{"$nulls":4},""]
[{"$nulls":3},"2,0 m",null,"number",50]
[{"$nulls":8},""]
[null,null,".02","Over 2,0 m and up to and including ",{"$nulls":4},""]
[{"$nulls":3},"3,0 m",null,"number",10]
[]
[null,130.03,"Extra over item 130.02 above to Reinstate"]
[null,null,"Trees:"]
[]
[null,null,".01","Over 1,0 m and up to and including "]
[{"$nulls":3},"2,0 m",null,"number",30]
[{"$nulls":8},""]
["8.2.4","130.04","Reclear surfaces (only on instructions ",{"$nulls":5},""]
[null,null,"from the Engineer):",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Areas",null,"m²",50]
[]
[null,null,".02","Strips, 3,0 m wide (water)          ",null,"m",100]
[{"$nulls":8},""]
["8.2.5","130.05","Take down existing fences",null,null,"km",10]
[{"$nulls":8},""]
["8.2.8","130.06","Demolish and remove structures",{"$nulls":5},""]
[null,null,"or buildings and dismantle steelwork etc."]
[]
[null,null,".01","Carport and Name Boards",null,"Number",115]
[]
[null,null,".02","Carefully remove paving blocks for ",null,"m²",{"v":28187,"d":"28,187"}]
[{"$nulls":3},"re-use (car parking)"]
[]
[null,null,".03","Asphalt surfacing (car parking)",null,"m²",{"v":1000,"d":"1,000"}]
[]
[null,null,".04","Carefully remove paving blocks for "]
[{"$nulls":3},"re-use ( Erf 3544)",null,"m²",775]
[]
[null,null,".05","Remove existing block retaining wall, 2300mm high",null,"m",20]
[]
[null,null,".06","Carefully remove kerb for re-use",null,"m",100]
[]
[null,"130.07","Extra over item 130.06 above for:"]
[]
[null,null,".01","Re-erection and Reinstatement of Carport",null,"Number",115]
[]
[null,null,".02","Reinstatement of Paving Blocks "]
[{"$nulls":3},"(car parking)",null,"m²",{"v":14094,"d":"14,094"}]
[]
[null,null,".03","Reinstatement of Asphalt/ concrete paving",null,"m²",{"v":1000,"d":"1,000"}]
[{"$nulls":3},"(car parking)"]
[]
[null,null,".04","Reinstatement of paving blocks for "]
[{"$nulls":3},"re-use (Erf 3544)",null,"m²",775]
[]
[null,null,".05","Reinstate kerbs",null,"m",100]
[]
[null,"130.08","Transport materials and debris to "]
[null,null,"unspecified site and dump",null,null,"m³",10]
[]
[]
["1200 C","Carried forward"]
[]
[]
[{"$nulls":8},"SECTION 1200 C"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
["8.2.10","130.09","Remove topsoil to nominal depth of "]
[null,null,"150 mm and stockpile                ",null,null,"m³",{"v":3074,"d":"3,074"}]
[]
["PSC","130.10","Temporary fencing or hoarding:"]
["8.2.11"]
[null,null,".01","1,8 m barbed wire class B fence",null,"m",{"v":2730,"d":"2,730"}]
[]
["PSC","130.11","Take down and re-erect existing fences "]
["8.2.12"]
[null,null,".01","Weldmesh fencing",null,"m",30]
[]
[null,null,".02","Boundary Brick wall ",null,"m",30]
[]
[null,null,".03","Double Brick wall with Palisade fence",null,"m",30]
[]
[null,null,".04","Palisade fence",null,"m",60]
[]
[null,null,".05","Clear View(vu) fence or similar",null,"m",150]
[]
[null,null,".06","Electrical fence, 5 lines installed above clear "]
[{"$nulls":3},"view fence",null,"m",150]
[]
[null,null,".07","Sliding gates with clearview fencing",null,"number",2]
[]
[null,null,".08","Turnstile gate",null,"Number",1]
[]
[null,"130.12","Re-erect fences"]
[]
[null,null,".01","Weldmesh fencing",null,"m",15]
[]
[null,null,".02","Palisade fence",null,"m",30]
[]
[null,null,".03","Clear View(vu) fence or similar",null,"m",75]
[]
[null,null,".04","Electrical fence, 5 lines installed above clear ",null,"m",75]
[{"$nulls":3},"view fence"]
[]
[null,null,".05","Turnstile gate",null,"Number",1]
[]
[null,"130.13","Extra over for supply and erection of new "]
[null,null,"fencing material"]
[]
[null,null,".01","Supply and install complete weldmesh "]
[{"$nulls":3},"fencing including excavation, concrete "]
[{"$nulls":3},"and backfill to posts, etc",null,"m",15]
[]
[null,null,".02","Excavate for boundry wall, "]
[{"$nulls":3},"including excvation, concrete and backfilling",null,"m",15]
[]
[null,null,".03","Construct boundry wall complete, "]
[{"$nulls":3},"including plaster and paint",null,"m²",36]
[]
[null,null,".04","Construct double Brick wall with Palisade "]
[{"$nulls":3},"fence complete, including excvation, concrete "]
[{"$nulls":3},"and backfilling",null,"m",30]
[]
[null,null,".05","Supply and install complete palisade fence"]
[{"$nulls":3},"including excvation, concrete and backfilling",null,"m",15]
[]
[]
[]
["1200 C","Carried forward"]
[]
[]
[{"$nulls":8},"SECTION 1200 C"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
["PSC","130.13",".06","Supply and install complete clear-vu fence or "]
["8.2.12",null,null,"similar including excvation, concrete ",null,"m",75]
[{"$nulls":3},"and backfilling"]
[]
[null,null,".07 ","Supply and install complete electrical fence ",null,"m",75]
[{"$nulls":3},"with five lines above clear view fence"]
[]
[null,null,".08","Supply and install complete sliding gate",null,"number",2]
[]
[null,null,".09","Construct new block retaining wall",null,"m²",23]
[]
["PSC","130.14","Final finishing and cleaning up of the"]
["8.2.13",null,"Site of the Works",null,null,"sum",1]
{"$rows_empty":47}
[{"$nulls":8},{"$f":"IF(OR(AND(G222=\"Prov\",H222=\"Sum\"),(H222=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G222*H222),\"\",IF(G222*H222=0,\"\",ROUND(G222*H222,2))))","v":""}]
[]
[null,"TOTAL SECTION 1200 C CARRIED TO SUMMARY"]

{"sheet":"1200D","index":3,"n_rows":82,"n_cols":9,"rows_kept":82}
[]
[{"$nulls":8},"SECTION 1200 D"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SANS","140.00","EARTHWORKS",{"$nulls":5},""]
["1200 D",{"$nulls":7},""]
["",{"$nulls":7},""]
["PSD","140.01","Restricted excavation:",{"$nulls":5},""]
["8.3.3",{"$nulls":7},""]
[null,null,".01","Excavate for chambers, restricted foundations, ",{"$nulls":4},""]
[{"$nulls":3},"etc. in all materials, and use for backfill or"]
[{"$nulls":3},"embankment, or dispose:"]
[]
[{"$nulls":3},".01","Depth up to 2,0 m        ","m³",362,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".02","Depth over 2,0 m and up to 4,0 m ","m³",362,null,""]
[]
[{"$nulls":3},".03","Depth over 4,0 m and not exceeding 6m deep","m³",362,null,""]
[]
[{"$nulls":3},".04","Depth over 6,0 m and up to 15,0 m","m³",228,null,""]
[{"$nulls":8},""]
[null,null,".02","Excavate for gabion boxes or mattresses in all",{"$nulls":4},""]
[{"$nulls":3},"all materials, and use for backfill or embankment,",{"$nulls":4},""]
[{"$nulls":3},"or dispose ",null,"m³",126,null,""]
[]
[null,null,".03","Extra over items 140.01.01 to ",{"$nulls":4},""]
[{"$nulls":3},"140.01.03 above for:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Intermediate excavation  ","m³",394,null,""]
[]
[{"$nulls":3},".02","Hard rock excavation     ","m³",131,null,""]
[{"$nulls":8},""]
[null,null,".04","Extra over item 140.01 for hand ",{"$nulls":4},""]
[{"$nulls":3},"excavation",null,"m³",50,null,""]
[]
["8.3.5","140.02","Extra excavation in all materials to "]
[null,null,"provide working space around structure       ",null,null,"m²",263,null,""]
[]
["8.3.9",140.04,"Extra over items 140.01 and 140.02 for backfill or"]
[null,null,"for fill material against structures",null,null,"m³",166]
[]
["PSD","140.05","Existing services:"]
["8.3.8"]
[null,null,".01","Hand excavation for locating and"]
[{"$nulls":3},"exposing existing services:"]
[]
[{"$nulls":3},".01","In roadways","m³",50,null,""]
[]
[{"$nulls":3},".02","In all other areas","m³",50,null,""]
["PSD"]
["8.3.10","140.06","Topsoiling               ",null,null,"m³",{"v":3074,"d":"3,074"}]
[{"$nulls":8},{"$f":"IF(OR(AND(G55=\"Prov\",H55=\"Sum\"),(H55=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G55*H55),\"\",IF(G55*H55=0,\"\",ROUND(G55*H55,2))))","v":""}]
["8.3.11","140.07","Grassing or other vegetation cover:",null,null,"m²",{"v":2700,"d":"2,700"}]
[]
["PSD","140.08","Extra over items 140.02.01 and",{"$nulls":5},{"$f":"IF(OR(AND(G58=\"Prov\",H58=\"Sum\"),(H58=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G58*H58),\"\",IF(G58*H58=0,\"\",ROUND(G58*H58,2))))","v":""}]
["8.3.14",null,"140.02 for temporary stockpiling",null,null,"m³",{"v":1313,"d":"1,313"},null,""]
[{"$nulls":8},""]
["PSD","140.09","Extra over items 140.02.01 and 140.02 for disposing",{"$nulls":5},""]
["8.3.15",null,"of spoil material on site provided by the Contractor",null,null,"m³",{"v":1146,"d":"1,146"}]
[]
["SANS","140.10","Treatment of roadbed:"]
["1200 DM"]
["8.3.3",null,".01","Roadbed preparation and compaction "]
[{"$nulls":3},"of material to (under structure floor"]
[{"$nulls":3},"slabs):"]
[]
[{"$nulls":3},".01","Minimum of 90% of modified"]
[{"$nulls":4},"AASHTO maximum density","m³",10]
[]
[{"$nulls":3},".02","Minimum of 93% of modified "]
[{"$nulls":4},"AASHTO maximum density","m³",81]
[]
[null,null,".02","Stone layer preparation and compaction of material to "]
[{"$nulls":3},"(under floor slab)"]
[]
[{"$nulls":3},".01","100mm Thick stone layer","m²",{"$f":"181*0.1","v":{"v":18.1,"d":"18"}}]
[]
[]
[null,"TOTAL SECTION 1200 D CARRIED TO SUMMARY"]

{"sheet":"1200DB","index":4,"n_rows":226,"n_cols":9,"rows_kept":226}
[]
[{"$nulls":8},"                  SECTION 1200 DB"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SANS","142.00","EARTHWORKS (PIPE TRENCHES)",{"$nulls":5},""]
["1200 DB",{"$nulls":7},""]
[{"$nulls":8},""]
[null,null,"TRENCHES FOR WATER PIPES",{"$nulls":5},""]
[{"$nulls":8},""]
["PSDB","142.01","Excavate in all materials for trenches, ",{"$nulls":5},""]
["8.3.2",null,"backfill, compact and dispose of surplus ",{"$nulls":5},""]
[null,null,"material:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Pipes over 125 mm dia up to 400 mm ",{"$nulls":4},""]
[{"$nulls":3},"dia for depths:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".02","Over 1,0 m up to 2,0 m    ","m",62]
[{"$nulls":8},""]
[null,null,".02","Pipes over 500 mm dia up to 850 mm ",{"$nulls":4},""]
[{"$nulls":3},"dia for depths:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Up to 1,0 m","m",28,null,{"$f":"IF(OR(AND(G25=\"Prov\",H25=\"Sum\"),(H25=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G25*H25),\"\",IF(G25*H25=0,\"\",ROUND(G25*H25,2))))","v":""}]
[]
[{"$nulls":3},".02","Over 1,0 m up to 2,0 m    ","m",838,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".03","Over 2,0 m up to 3,0 m    ","m",{"v":4152,"d":"4,152"},null,""]
[{"$nulls":8},""]
[{"$nulls":3},".04","Over 3,0 m up to 4,0 m    ","m",{"v":1311,"d":"1,311"},null,""]
[]
[{"$nulls":3},".05","Over 4,0 m ","m",513,null,""]
[{"$nulls":8},""]
["PSDB","142.02","Extra over item 142.01 above for:",{"$nulls":5},""]
["8.3.2",{"$nulls":7},""]
[null,null,".01","Intermediate excavation  ",null,"m³",{"v":3377,"d":"3,377"},null,""]
[{"$nulls":8},""]
[null,null,".02","Hard rock excavation     ",null,"m³",{"v":3608,"d":"3,608"},null,""]
[{"$nulls":8},""]
[null,null,".03","Hand excavation where ordered by the",{"$nulls":4},""]
[{"$nulls":3},"Engineer:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Soft material","m³",200,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".02","Intermediate material","m³",100,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".03","Hard material","m³",10,null,""]
[]
[null,null,".04","Backfill stabilized with 5% cement "]
[{"$nulls":3},"where directed by the Engineer   ",null,"m³",10,null,{"$f":"IF(OR(AND(G51=\"Prov\",H51=\"Sum\"),(H51=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G51*H51),\"\",IF(G51*H51=0,\"\",ROUND(G51*H51,2))))","v":""}]
[]
[null,null,".05                       Soilcrete backfill where directed by ","Soilcrete backfill where directed by the"]
[{"$nulls":3},"Engineer ",null,"m³",100,null,{"$f":"IF(OR(AND(G54=\"Prov\",H54=\"Sum\"),(H54=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G54*H54),\"\",IF(G54*H54=0,\"\",ROUND(G54*H54,2))))","v":""}]
[]
["8.3.2","142.03","Excavate and dispose of unsuitable ",{"$nulls":5},{"$f":"IF(OR(AND(G56=\"Prov\",H56=\"Sum\"),(H56=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G56*H56),\"\",IF(G56*H56=0,\"\",ROUND(G56*H56,2))))","v":""}]
[null,null,"material from trench bottom ",null,null,"m³",{"v":3608,"d":"3,608"},null,{"$f":"IF(OR(AND(G57=\"Prov\",H57=\"Sum\"),(H57=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G57*H57),\"\",IF(G57*H57=0,\"\",ROUND(G57*H57,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G58=\"Prov\",H58=\"Sum\"),(H58=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G58*H58),\"\",IF(G58*H58=0,\"\",ROUND(G58*H58,2))))","v":""}]
[null,"142.04","Excavation ancillaries:",{"$nulls":5},{"$f":"IF(OR(AND(G59=\"Prov\",H59=\"Sum\"),(H59=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G59*H59),\"\",IF(G59*H59=0,\"\",ROUND(G59*H59,2))))","v":""}]
["8.3.3",{"$nulls":7},""]
[null,null,".01","Make up deficiency in backfill material:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","From other necessary excavations ",{"$nulls":3},""]
[{"$nulls":4},"on Site","m³",10,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".02","By importation from commercial or ",{"$nulls":3},""]
[{"$nulls":4},"off-site sources selected by the ",{"$nulls":3},""]
[{"$nulls":4},"Contractor","m³",10,null,""]
[]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G71=\"Prov\",H71=\"Sum\"),(H71=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G71*H71),\"\",IF(G71*H71=0,\"\",ROUND(G71*H71,2))))","v":""}]
[{"$nulls":8},""]
[]
["1200 DB","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                  SECTION 1200 DB"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G85=\"Prov\",H85=\"Sum\"),(H85=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G85*H85),\"\",IF(G85*H85=0,\"\",ROUND(G85*H85,2))))","v":""}]
["8.3.3","142.04",".02","Compaction in road crossings     "]
[null,"(cont)"]
[{"$nulls":3},".01","93% of modified AASHTO density","m³",150]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G90=\"Prov\",H90=\"Sum\"),(H90=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G90*H90),\"\",IF(G90*H90=0,\"\",ROUND(G90*H90,2))))","v":""}]
[]
["8.3.4","142.05","Particular items:",{"$nulls":5},""]
[]
[null,null,".01","Shore trench opposite structure or service",null,"m",{"v":2730,"d":"2,730"}]
[{"$nulls":8},""]
[null,null,".02","Temporary Works: Control water ",{"$nulls":4},""]
[{"$nulls":3},"inflow in pipeline:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","For new tie-in connection to existing",{"$nulls":3},""]
[{"$nulls":4},"chamber pipework (Feeder pipeline)","sum",1,null,""]
[]
[{"$nulls":3},".02","For new tie-in connection into"]
[{"$nulls":4},"exisitng water pipes (Supply pipeline)","sum",5,null,""]
["PSDB",{"$nulls":7},""]
["8.3.5","142.06","Existing services that intersect or  ",{"$nulls":5},""]
[null,null,"adjoin a pipe trench:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Services that intersect a trench:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Fence crossings (all types)","number",12,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".02","Eskom electrical cable crossings","number",10,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".03 ","DFA cable crossings","number",5,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".04","Stormwater pipe crossings","number",5,null,""]
[]
[{"$nulls":3},".05","Water pipe crossings","number",5,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".06","Sewer pipe crossings","number",3,null,""]
[]
[{"$nulls":3},".07","3 m wide driveways containing"]
[{"$nulls":4},"block paving","number",2,null,""]
[]
[{"$nulls":3},".08","3 m wide driveways containing"]
[{"$nulls":4},"concrete paving","number",2,null,{"$f":"IF(OR(AND(G126=\"Prov\",H126=\"Sum\"),(H126=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G126*H126),\"\",IF(G126*H126=0,\"\",ROUND(G126*H126,2))))","v":""}]
[]
[{"$nulls":3},".09","6 m wide driveways containing"]
[{"$nulls":4},"block paving","number",8,null,{"$f":"IF(OR(AND(G129=\"Prov\",H129=\"Sum\"),(H129=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G129*H129),\"\",IF(G129*H129=0,\"\",ROUND(G129*H129,2))))","v":""}]
[]
[{"$nulls":3},".10","6 m wide driveways containing"]
[{"$nulls":4},"concrete paving","number",2,null,{"$f":"IF(OR(AND(G132=\"Prov\",H132=\"Sum\"),(H132=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G132*H132),\"\",IF(G132*H132=0,\"\",ROUND(G132*H132,2))))","v":""}]
[]
["PSDB","142.06",".02","Services that adjoin a trench:",{"$nulls":4},{"$f":"IF(OR(AND(G134=\"Prov\",H134=\"Sum\"),(H134=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G134*H134),\"\",IF(G134*H134=0,\"\",ROUND(G134*H134,2))))","v":""}]
["8.3.5",{"$nulls":7},""]
[{"$nulls":3},".01","Fencing (all types)","m",{"v":2817,"d":"2,817"},null,""]
[{"$nulls":8},""]
[{"$nulls":3},".02","Stormwater pipes","m",100,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".03","Water pipes","m",485,null,""]
[]
[{"$nulls":3},".04","Sewer pipes","m",580,null,{"$f":"IF(OR(AND(G142=\"Prov\",H142=\"Sum\"),(H142=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G142*H142),\"\",IF(G142*H142=0,\"\",ROUND(G142*H142,2))))","v":""}]
[]
[{"$nulls":3},".05","Eskom electrical cable crossings","m",200,null,{"$f":"IF(OR(AND(G144=\"Prov\",H144=\"Sum\"),(H144=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G144*H144),\"\",IF(G144*H144=0,\"\",ROUND(G144*H144,2))))","v":""}]
[]
[]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G148=\"Prov\",H148=\"Sum\"),(H148=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G148*H148),\"\",IF(G148*H148=0,\"\",ROUND(G148*H148,2))))","v":""}]
[]
["1200 DB","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                  SECTION 1200 DB"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
["PSDB"]
["8.3.6",142.07,"Finishing:",{"$nulls":5},{"$f":"IF(OR(AND(G162=\"Prov\",H162=\"Sum\"),(H162=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G162*H162),\"\",IF(G162*H162=0,\"\",ROUND(G162*H162,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","Reinstate road surfaces complete with ",{"$nulls":4},""]
[{"$nulls":3},"all courses:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Gravel on shoulders      ","m³",10]
[]
["8.3.6",142.07,null,".02","Asphalt of thickness 40 mm in ",{"$nulls":3},{"$f":"IF(OR(AND(G169=\"Prov\",H169=\"Sum\"),(H169=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G169*H169),\"\",IF(G169*H169=0,\"\",ROUND(G169*H169,2))))","v":""}]
[null,"(cont)",null,null,"parking area             ","m²",450]
[]
[{"$nulls":3},".03","Gravel surfacing         ","m³",10]
[{"$nulls":8},{"$f":"IF(OR(AND(G173=\"Prov\",H173=\"Sum\"),(H173=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G173*H173),\"\",IF(G173*H173=0,\"\",ROUND(G173*H173,2))))","v":""}]
["PSDB",{"$nulls":7},{"$f":"IF(OR(AND(G174=\"Prov\",H174=\"Sum\"),(H174=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G174*H174),\"\",IF(G174*H174=0,\"\",ROUND(G174*H174,2))))","v":""}]
["8.3.6","142.06",null,".04","Paving blocks/bricks     ","m²",450]
[{"$nulls":8},{"$f":"IF(OR(AND(G176=\"Prov\",H176=\"Sum\"),(H176=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G176*H176),\"\",IF(G176*H176=0,\"\",ROUND(G176*H176,2))))","v":""}]
[{"$nulls":3},".05","Kerbing ","m",50]
[]
["PSDB","142.07","Accommodation of traffic ",null,null,"sum",1]
["8.3.7",{"$nulls":7},{"$f":"IF(OR(AND(G180=\"Prov\",H180=\"Sum\"),(H180=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G180*H180),\"\",IF(G180*H180=0,\"\",ROUND(G180*H180,2))))","v":""}]
[]
["PSDB ","142.08","Supply all barricading and support ",null,null,"Sum",1]
["8.3.13",null,"as required for the construction of the "]
[null,null,"bulk water line (within Erven 3544, "]
[null,null,"Juskei View Property)"]
{"$rows_empty":36}
[{"$nulls":8},""]
[]
[]
[]
[null,"TOTAL SECTION 1200 DB CARRIED TO SUMMARY"]

{"sheet":"1200DK","index":5,"n_rows":79,"n_cols":9,"rows_kept":79}
[]
[{"$nulls":8},"                  SECTION 1200 DK"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SANS","146.00","GABIONS AND PITCHING",{"$nulls":5},""]
["1200 DK",{"$nulls":7},""]
[{"$nulls":8},""]
["8.2.1","146.01","Surface preparation for bedding of ",{"$nulls":5},""]
[null,null,"gabions: 5 no. Scour Valves",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Cavities filled with approved excavated ",{"$nulls":4},""]
[{"$nulls":3},"material or rock",null,"m²",126]
[{"$nulls":8},""]
["8.2.2","146.02","Gabions:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Gabion boxes of galvanized wire:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","100 mm x 100 mm mesh, ",{"$nulls":3},""]
[{"$nulls":4},"2,7 mm dia wire, 1,0 m x ",{"$nulls":3},""]
[{"$nulls":4},"1,0 m x 0,5 m boxes    ","m³",25]
[{"$nulls":8},""]
[null,null,".02","Gabion mattresses of galvanized wire, ",{"$nulls":4},""]
[{"$nulls":3},"up to 0,3 m deep:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","80 mm x 100 mm mesh, ",{"$nulls":3},""]
[{"$nulls":4},"2,6 mm dia wire, 6,0 m x ",{"$nulls":3},""]
[{"$nulls":4},"2,0 m x 0,3 m mattress","m³",38]
[{"$nulls":8},""]
["8.2.4","146.03","Geotextile:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Grade 4 or approved equivalent ",null,"m²",147]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
{"$rows_empty":16}
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
{"$rows_empty":14}
[{"$nulls":8},""]
[{"$nulls":8},""]
[]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[]
[null,"TOTAL SECTION 1200 DK CARRIED TO SUMMARY"]

{"sheet":"2001 CC1","index":6,"n_rows":386,"n_cols":9,"rows_kept":386}
[]
[]
[{"$nulls":8},"SECTION 2001 CC1"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SANS","170.00","CONCRETE (STRUCTURAL)",{"$nulls":5},""]
["2001 CC1",{"$nulls":7},""]
[{"$nulls":8},""]
[null,null,"SCHEDULED FORMWORK ITEMS",{"$nulls":5},""]
[{"$nulls":8},""]
["SD8.2.1","170.01","Rough:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Vertical formwork to:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Outsides of sumps (floor edge ",{"$nulls":3},""]
[{"$nulls":4},"and sides)","m²",9,null,""]
[]
[{"$nulls":3},".02","Outsides of base","m²",47,null,""]
[]
[{"$nulls":3},".03","Footing","m²",47]
[]
[{"$nulls":3},".04","Outsides of access chamber 1 walls ",{"$nulls":3},""]
[{"$nulls":4},"upto 14m high","m²",333]
[]
[{"$nulls":3},".05","Outsides of access chamber 2 walls "]
[{"$nulls":4},"upto 6m high","m²",{"v":308.6349,"d":"309"}]
[]
[null,null,".02","Boxing out",{"$nulls":4},""]
[]
[{"$nulls":3},".01","600 x 600 x 750mm deep Sump","number",5,null,""]
[]
["SD8.2.2","170.02","Smooth:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Vertical formwork to:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Insides of chamber walls","m²",10,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".02","Insides of access chamber 1 walls ",{"$nulls":3},""]
[{"$nulls":4},"up to 14m high","m²",292,null,""]
[]
[{"$nulls":3},".03","Insides of access chamber 2 walls "]
[{"$nulls":4},"up to 6m high","m²",{"v":293.2713,"d":"293"}]
[]
[{"$nulls":3},".04","Outsides of chamber walls","m²",10,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".05","Insides of sumps","m²",6,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".06","Outsides of plinths and thrust "]
[{"$nulls":4},"blocks","m²",853,null,""]
[]
[{"$nulls":3},".07","Outsides of roof slabs","m²",{"v":20.7,"d":"21"},null,""]
[]
[{"$nulls":3},".08","Sides of downstand and upstand beams","m²",{"v":20.25,"d":"20"},null,{"$f":"IF(OR(AND(G55=\"Prov\",H55=\"Sum\"),(H55=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G55*H55),\"\",IF(G55*H55=0,\"\",ROUND(G55*H55,2))))","v":""}]
[]
[{"$nulls":3},".09","Sides of Capping Beams","m²",{"v":16.2,"d":"16"},null,{"$f":"IF(OR(AND(G57=\"Prov\",H57=\"Sum\"),(H57=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G57*H57),\"\",IF(G57*H57=0,\"\",ROUND(G57*H57,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".04","Horizontal formwork to:",{"$nulls":4},""]
[null,null,"",{"$nulls":5},""]
[{"$nulls":3},".01","Soffits of roof slabs (propped up exceeding",{"$nulls":3},""]
[{"$nulls":4},"6,0m up to 7,5m)","m²",14]
[]
[{"$nulls":3},".02","Soffits of roof slabs (propped up exceeding",{"$nulls":3},""]
[{"$nulls":4},"12,5m up to 14m)","m²",64]
[]
[{"$nulls":3},".03","Soffits of beams (propped up exceeding",{"$nulls":3},""]
[{"$nulls":4},"6,0m up to 7,5m)","m²",{"v":3.6,"d":"4"}]
[]
[{"$nulls":3},".04","Soffits of Capping Beams (propped up ",{"$nulls":3},""]
[{"$nulls":4},"exceeding 6,0m up to 7,5m)","m²",{"v":11.16,"d":"11"}]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G73=\"Prov\",H73=\"Sum\"),(H73=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G73*H73),\"\",IF(G73*H73=0,\"\",ROUND(G73*H73,2))))","v":""}]
[]
[]
[]
["2001 CC1","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 2001 CC1"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G88=\"Prov\",H88=\"Sum\"),(H88=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G88*H88),\"\",IF(G88*H88=0,\"\",ROUND(G88*H88,2))))","v":""}]
["SD8.2.6","170.04","Box out holes/form voids:"]
[]
[null,null,".01","Small circular, of diameter up to and including"]
[{"$nulls":3},"0,35 m, and in the following depth ranges:"]
[]
[{"$nulls":3},".01","0 m up to and including 0,5 m   "]
[{"$nulls":4},"(for 100 mm dia ventilator sleeve"]
[{"$nulls":4},"in roof slab)","number",18,null,{"$f":"IF(OR(AND(G96=\"Prov\",H96=\"Sum\"),(H96=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G96*H96),\"\",IF(G96*H96=0,\"\",ROUND(G96*H96,2))))","v":""}]
[]
[null,null,".02","Large, circular, of diameter over  0,35 m up to and",{"$nulls":4},""]
[{"$nulls":3},"including 0,7 m and in the following depth ranges:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","0 m up to and including 0,5 m  ",{"$nulls":3},""]
[{"$nulls":4},"(for 700 mm dia manhole cover",{"$nulls":3},""]
[{"$nulls":4},"and frame in roof slab)","number",16,null,""]
[{"$nulls":8},""]
[null,null,"SCHEDULED REINFORCEMENT ITEMS",{"$nulls":5},""]
[{"$nulls":8},""]
["SD8.3.1","170.05","Mild-steel and high-tensile steel bars",{"$nulls":5},""]
[null,null,"(all diameters)",null,null,"t",37,null,""]
[{"$nulls":8},""]
[null,null,"SCHEDULED CONCRETE ITEMS",{"$nulls":5},""]
[{"$nulls":8},""]
["SD8.4.2","170.06","Blinding layer:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Class 15 MPa/19 mm concrete of:",{"$nulls":4},{"$f":"IF(OR(AND(G114=\"Prov\",H114=\"Sum\"),(H114=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G114*H114),\"\",IF(G114*H114=0,\"\",ROUND(G114*H114,2))))","v":""}]
[{"$nulls":8},""]
[{"$nulls":3},".01","50 mm thickness   ","m²",{"v":65.178,"d":"65"}]
[{"$nulls":8},""]
[{"$nulls":3},".02","75 mm thickness   ","m²",181,null,""]
[{"$nulls":8},""]
["SD8.4.3","170.07","Strength concrete:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Class 20 MPa/19 mm concrete in:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Thrust blocks","m³",311,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".02","Plinths","m³",3,null,""]
[{"$nulls":8},""]
[null,null,".02","Class 30 MPa/19 mm concrete in:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Footing","m³",{"v":22.368,"d":"22"}]
[]
[{"$nulls":3},".02","Surface bed","m³",{"v":48.954,"d":"49"}]
[]
[{"$nulls":3},".03","Floor slabs and sumps","m³",2,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".04","Walls","m³",202,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".05","Roof slabs and upstands","m³",{"v":23.67,"d":"24"},null,""]
[]
[{"$nulls":3},".06","Beams","m³",{"v":3.78,"d":"4"},null,""]
[]
[{"$nulls":3},".07","Capping Beams","m³",{"v":7.9416,"d":"8"},null,{"$f":"IF(OR(AND(G142=\"Prov\",H142=\"Sum\"),(H142=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G142*H142),\"\",IF(G142*H142=0,\"\",ROUND(G142*H142,2))))","v":""}]
[]
["SD8.4.4","170.08","Unformed surface finishes:"]
[]
[null,null,".01","Wood-floated finishes to:"]
[]
[{"$nulls":3},".01","Floors and sumps","m²",130,null,{"$f":"IF(OR(AND(G148=\"Prov\",H148=\"Sum\"),(H148=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G148*H148),\"\",IF(G148*H148=0,\"\",ROUND(G148*H148,2))))","v":""}]
[]
[null,null,".02","Steel-floated finishes to:"]
[]
[{"$nulls":3},".01","Roof slabs and upstands","m²",78,null,{"$f":"IF(OR(AND(G152=\"Prov\",H152=\"Sum\"),(H152=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G152*H152),\"\",IF(G152*H152=0,\"\",ROUND(G152*H152,2))))","v":""}]
[]
[{"$nulls":3},".02","Plinths and thrust blocks including forming half"]
[{"$nulls":4},"round segments for pipes","m²",67]
[{"$nulls":8},{"$f":"IF(OR(AND(G156=\"Prov\",H156=\"Sum\"),(H156=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G156*H156),\"\",IF(G156*H156=0,\"\",ROUND(G156*H156,2))))","v":""}]
[]
["2001 CC1","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 2001 CC1"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G169=\"Prov\",H169=\"Sum\"),(H169=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G169*H169),\"\",IF(G169*H169=0,\"\",ROUND(G169*H169,2))))","v":""}]
["SD8.4.4","170.08",null,".03","Capping beams","m²",30,null,{"$f":"IF(OR(AND(G170=\"Prov\",H170=\"Sum\"),(H170=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G170*H170),\"\",IF(G170*H170=0,\"\",ROUND(G170*H170,2))))","v":""}]
[null,"(cont)"]
[]
["SD8.4.8","170.09","Screeds"]
[]
[null,null,".01","50mm thick average screed to falls",{"$nulls":4},{"$f":"IF(OR(AND(G175=\"Prov\",H175=\"Sum\"),(H175=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G175*H175),\"\",IF(G175*H175=0,\"\",ROUND(G175*H175,2))))","v":""}]
[{"$nulls":3},"on roof slab (16-75mm thick)",null,"m²",76]
[]
[null,null,".02","25mm thick average screed to falls on surface bed ",null,"m²",{"v":128.47,"d":"128"},null,{"$f":"IF(OR(AND(G178=\"Prov\",H178=\"Sum\"),(H178=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G178*H178),\"\",IF(G178*H178=0,\"\",ROUND(G178*H178,2))))","v":""}]
[]
[null,null,".03","Cement : sand floor screeds with "]
[{"$nulls":3},"falls including a smooth towelled ",{"$nulls":4},{"$f":"IF(OR(AND(G181=\"Prov\",H181=\"Sum\"),(H181=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G181*H181),\"\",IF(G181*H181=0,\"\",ROUND(G181*H181,2))))","v":""}]
[{"$nulls":3},"finish to inside of jacked culvert",null,"m²",234]
[]
["SD8.6","170.11","Manufacture (or supply) and erect precast elements",{"$nulls":5},""]
[null,null,"for units bigger than 0,5 m³ of formed concrete:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","The following types and sizes, complete with",{"$nulls":4},""]
[{"$nulls":3}," box-outs for covers, etc, lifting handles or hooks,",{"$nulls":4},""]
[{"$nulls":3},"reinforcing (allow 120 kg/m³), smooth off-shutter",{"$nulls":4},""]
[{"$nulls":3},"finish to all surfaces, drip grooves, etc:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","3,275 m x 1,370 m x 200 mm thick roof slab",{"$nulls":3},""]
[{"$nulls":4},"panel as shown on Drawing No.",{"$nulls":3},""]
[{"$nulls":4},"111242-0000-DRG-WW-0501","number",15]
[{"$nulls":8},""]
[{"$nulls":3},".02","2,820 m x 1,350 m x 200 mm thick roof slab",{"$nulls":3},""]
[{"$nulls":4},"panel as shown on Drawing No.",{"$nulls":3},""]
[{"$nulls":4},"111242-0000-DRG-WW-0502","number",5]
[{"$nulls":8},""]
[{"$nulls":3},".03","2,820 m x 1,050 m x 200 mm thick roof slab",{"$nulls":3},""]
[{"$nulls":4},"panel as shown on Drawing No.",{"$nulls":3},""]
[{"$nulls":4},"111242-0000-DRG-WW-0502","number",20]
[{"$nulls":8},""]
[{"$nulls":3},".04","2,45 m x 2,45 m x 150 mm thick roof slab",{"$nulls":3},""]
[{"$nulls":4},"panel, tapered down to 125 mm thick around",{"$nulls":3},""]
[{"$nulls":4},"edges as shown on Drawing No.",{"$nulls":3},""]
[{"$nulls":4},"111242-0000-DRG-WW-0500","number",9]
[]
[{"$nulls":3},".05","2,700 m x 1,443 m x 150 mm thick "]
[{"$nulls":4},"roof slab panel as shown on "]
[{"$nulls":4},"Drawing No. "]
[{"$nulls":4},"111242-0000-DRG-WW-0508","number",6]
[]
[{"$nulls":3},".06","Square manhole shaft unit size"]
[{"$nulls":4},"2,0 m x 2,0 m x 1,0 m high internally with "]
[{"$nulls":4},"125 mm thick walls complete with toggle type"]
[{"$nulls":4},"joints as supplied by SPC or equal approved"]
[{"$nulls":4},"as shown on Drawing No."]
[{"$nulls":4},"111242-0000-DRG-WW-0500","number",18]
[]
[{"$nulls":3},".07","5600 m x 1,200 m x 150 mm thick roof slab"]
[{"$nulls":4},"complete with and including 12mm stainless "]
[{"$nulls":4},"round bar lifting hooks,removable slab "]
[{"$nulls":4},"111242-0000-DRG-WW-0513","number",2,null,{"$f":"IF(OR(AND(G224=\"Prov\",H224=\"Sum\"),(H224=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G224*H224),\"\",IF(G224*H224=0,\"\",ROUND(G224*H224,2))))","v":""}]
[]
[{"$nulls":3},".08","8759 x 1200 x 150mm Precast pre-stressed slab "]
[{"$nulls":4},"complete with and including 12mm stainless "]
[{"$nulls":4},"round bar lifting hooks,removable slab "]
[{"$nulls":4},"111242-0000-DRG-WW-0513","number",3]
[]
[]
["2001 CC1","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 2001 CC1"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
["SD8.6","170.11",null,".09","4379 m x 1200 m x 150 mm thick precast "]
[null,"(cont)",null,null,"lockable lid over concrete slab "]
[{"$nulls":4},"111242-0000-DRG-WW-0513","number",2]
[{"$nulls":8},{"$f":"IF(OR(AND(G247=\"Prov\",H247=\"Sum\"),(H247=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G247*H247),\"\",IF(G247*H247=0,\"\",ROUND(G247*H247,2))))","v":""}]
["SD8.8","170.12","HD bolts and miscellaneous metal work:"]
[]
[null,null,".01","Steel strap pipe fixing bracket complete with"]
[{"$nulls":3},"malthoid packings as shown on Drawing No's"]
[{"$nulls":3},"111242-0000-DRG-WW-0502-0503"]
[]
[{"$nulls":3},".01","200 mm dia pipe","number",10]
[]
[{"$nulls":3},".02","700 mm dia pipe","number",48,null,{"$f":"IF(OR(AND(G256=\"Prov\",H256=\"Sum\"),(H256=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G256*H256),\"\",IF(G256*H256=0,\"\",ROUND(G256*H256,2))))","v":""}]
[]
[null,null,".02","10 mm thick x 2.020 m long x 1,60 m girth L-shaped",{"$nulls":4},{"$f":"IF(OR(AND(G258=\"Prov\",H258=\"Sum\"),(H258=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G258*H258),\"\",IF(G258*H258=0,\"\",ROUND(G258*H258,2))))","v":""}]
[{"$nulls":3},"galvanized steel plate fixed with chemical anchors",{"$nulls":4},""]
[{"$nulls":3},"at maximum 200 mm centres in both directions to",{"$nulls":4},""]
[{"$nulls":3},"concrete walls and floors as shown on Drawing No.",{"$nulls":4},""]
[{"$nulls":3},"111242-0000-DRG-WW-0502",null,"number",5]
[{"$nulls":8},{"$f":"IF(OR(AND(G263=\"Prov\",H263=\"Sum\"),(H263=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G263*H263),\"\",IF(G263*H263=0,\"\",ROUND(G263*H263,2))))","v":""}]
[null,null,".03","Galvanized mild steel grid formed of 100 mm x ",{"$nulls":4},""]
[{"$nulls":3},"3 mm thick x 1 600 mm long flat section base plate",{"$nulls":4},""]
[{"$nulls":3},"with 20 mm dia x 150 mm long studs welded on at",{"$nulls":4},""]
[{"$nulls":3},"150 mm centres and six times bolted to concrete",{"$nulls":4},""]
[{"$nulls":3},"with chemical anchors as shown on Drawing No.",{"$nulls":4},""]
[{"$nulls":3},"111242-0000-DRG-WW-0502",null,"number",70]
[]
["SD8.12","170.13","Cast in of pipes with or without puddle"]
[null,null,"flanges:"]
[]
[null,null,".01","Up to 300 mm nominal bore:",{"$nulls":4},{"$f":"IF(OR(AND(G274=\"Prov\",H274=\"Sum\"),(H274=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G274*H274),\"\",IF(G274*H274=0,\"\",ROUND(G274*H274,2))))","v":""}]
[{"$nulls":8},""]
[{"$nulls":3},".01","Through 200 mm thick wall","number",10]
[{"$nulls":8},{"$f":"IF(OR(AND(G277=\"Prov\",H277=\"Sum\"),(H277=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G277*H277),\"\",IF(G277*H277=0,\"\",ROUND(G277*H277,2))))","v":""}]
[{"$nulls":3},".02","Through 300 mm thick wall","number",5]
[]
[null,null,".02","Over 300 mm up to 700 mm nominal"]
[{"$nulls":3},"bore:"]
[]
[{"$nulls":3},".01","Through 200 mm thick floor slab","number",9]
[]
[{"$nulls":3},".02","Through 250 mm thick wall","number",10]
[]
[{"$nulls":3},".03","Through 450 mm thick wall","number",2,null,{"$f":"IF(OR(AND(G287=\"Prov\",H287=\"Sum\"),(H287=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G287*H287),\"\",IF(G287*H287=0,\"\",ROUND(G287*H287,2))))","v":""}]
[{"$nulls":8},""]
["SD8.13","170.14","Miscellaneous work other than metal ",{"$nulls":5},{"$f":"IF(OR(AND(G289=\"Prov\",H289=\"Sum\"),(H289=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G289*H289),\"\",IF(G289*H289=0,\"\",ROUND(G289*H289,2))))","v":""}]
[null,null,"work:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Malthoid insulation between steel pipes and steel",{"$nulls":4},""]
[{"$nulls":3},"straps:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","3 mm thick x 50 mm wide strips","m",119]
[{"$nulls":8},{"$f":"IF(OR(AND(G296=\"Prov\",H296=\"Sum\"),(H296=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G296*H296),\"\",IF(G296*H296=0,\"\",ROUND(G296*H296,2))))","v":""}]
[{"$nulls":3},".02","3 mm thick x 60 mm wide strips","m",119,null,""]
[]
[{"$nulls":3},".03","10 mm thick x 70 mm wide strips","m",10]
[]
[null,null,".02","Malthoid insulation between steel pipes and",{"$nulls":4},{"$f":"IF(OR(AND(G301=\"Prov\",H301=\"Sum\"),(H301=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G301*H301),\"\",IF(G301*H301=0,\"\",ROUND(G301*H301,2))))","v":""}]
[{"$nulls":3},"concrete surfaces:",{"$nulls":4},""]
[]
[{"$nulls":3},".01","3 mm thick x 200 mm wide strips","m",80]
[]
[{"$nulls":3},".02","3 mm thick x 250 mm wide strips","m",80,null,{"$f":"IF(OR(AND(G306=\"Prov\",H306=\"Sum\"),(H306=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G306*H306),\"\",IF(G306*H306=0,\"\",ROUND(G306*H306,2))))","v":""}]
[]
[]
["2001 CC1","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 2001 CC1"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
["SD8.8","170.13",".02",".03","HPDE insulation pads 1,6 mm thick between"]
[null,"(cont)",null,null,"steel pipes and concrete surfaces (at thrust"]
[{"$nulls":4},"blocks)","m²",10]
[]
["SANS",170.15,"Accessories:",{"$nulls":5},{"$f":"IF(OR(AND(G325=\"Prov\",H325=\"Sum\"),(H325=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G325*H325),\"\",IF(G325*H325=0,\"\",ROUND(G325*H325,2))))","v":""}]
["1200 LE",{"$nulls":7},""]
["8.2.10",null,".01","Manhole covers including frames:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","700mm diameter manhole cover and frame with",{"$nulls":3},""]
[{"$nulls":4},"lockable cover to SANS 558 Type 4 Mild Steel",{"$nulls":3},""]
[{"$nulls":4},"as seen on Drawing No."]
[{"$nulls":4},"111242-0000-DRG-WW-0501 (Detail B)","number",29]
[]
[null,null,".02","Step irons:",{"$nulls":4},{"$f":"IF(OR(AND(G334=\"Prov\",H334=\"Sum\"),(H334=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G334*H334),\"\",IF(G334*H334=0,\"\",ROUND(G334*H334,2))))","v":""}]
[{"$nulls":8},""]
[{"$nulls":3},".01","Calcamite 4 Ever type step irons","number",310]
[]
[null,null,".03","Air breather as shown on Drawing No.",{"$nulls":4},{"$f":"IF(OR(AND(G338=\"Prov\",H338=\"Sum\"),(H338=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G338*H338),\"\",IF(G338*H338=0,\"\",ROUND(G338*H338,2))))","v":""}]
[{"$nulls":3},"111242-0000-DRG-WW-0502 complete including",{"$nulls":4},""]
[{"$nulls":3},"casting into precast or in-situ concrete roof slabs",null,"number",35]
[]
[null,null,".04","Submersible pump connected to 160mm dia pipe",null,"number",1,null,{"$f":"IF(OR(AND(G342=\"Prov\",H342=\"Sum\"),(H342=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G342*H342),\"\",IF(G342*H342=0,\"\",ROUND(G342*H342,2))))","v":""}]
[]
["SANS",170.16,"Soilcrete:"]
["1200 DB"]
["PSDB 8.3.2",null,".01","Soilcrete backfill where directed by the"]
[{"$nulls":3},"Engineer",null,"m³",100]
[]
["SANS",170.17,"Pipes in subsurface drains:"]
["1200 DB"]
["PSDB 8.3.2",null,".01","Normal duty uPVC pipes complete with couplings:"]
[]
[{"$nulls":3},".01","160 mm internal dia, perforated","m",100]
[]
[null,170.18,"Temporary gunite lateral support"]
[null,null," including soil nails to specialists' details"]
[]
[null,null,".01","150mm Thick gunite",null,"m²",276,{"v":1400,"d":"1,400.00"},{"$f":"IF(OR(AND(G358=\"Prov\",H358=\"Sum\"),(H358=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G358*H358),\"\",IF(G358*H358=0,\"\",ROUND(G358*H358,2))))","v":{"v":386400,"d":"386,400.00"}}]
[]
[{"$nulls":3},".01","200 mm thick average","m²",109,{"v":1400,"d":"1,400.00"},{"$f":"IF(OR(AND(G360=\"Prov\",H360=\"Sum\"),(H360=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G360*H360),\"\",IF(G360*H360=0,\"\",ROUND(G360*H360,2))))","v":{"v":152600,"d":"152,600.00"}}]
[]
[{"$nulls":3},".02","200 mm thick average gunite between piles ","m²",{"v":276.479,"d":"276"},{"v":1400,"d":"1,400.00"},{"$f":"IF(OR(AND(G362=\"Prov\",H362=\"Sum\"),(H362=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G362*H362),\"\",IF(G362*H362=0,\"\",ROUND(G362*H362,2))))","v":{"v":387070.6,"d":"387,070.60"}}]
{"$rows_empty":23}
[null,"TOTAL SECTION 2001 CC1 CARRIED TO SUMMARY"]

{"sheet":"1200HA","index":7,"n_rows":164,"n_cols":9,"rows_kept":164}
[]
[]
[{"$nulls":8},"                 SECTION 1200 HA"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SANS","181.00","STRUCTURAL STEELWORK (SUNDRY ",{"$nulls":5},""]
["1200 HA",null,"ITEMS)",{"$nulls":5},""]
["PSHA",{"$nulls":7},""]
[]
["8.3.1","181.01","Structural steel:"]
[]
[null,null,".01","Pipe support brackets complete with"]
[{"$nulls":3},"100 x 10mm flat bar clamp lined with"]
[{"$nulls":3},"990 x 100 x 10mm thick rubber strip"]
[{"$nulls":3},"including 6mm thick gusset connected by "]
[{"$nulls":3},"M16 SS bolts with nyloc nuts and 10mm"]
[{"$nulls":3},"thick plate connected to 75 x 75 x 6mm"]
[{"$nulls":3},"SS angle with 6mm thick ribs. Fixed to"]
[{"$nulls":3},"concrete using 80 x 80 x 8mm SS angle"]
[{"$nulls":3},"and M16 stainless steel chemical anchors",null,"number",10]
[]
[null,null,".02","254 x 146 x 32 I- Section Crawl Beam with "]
[{"$nulls":3},"manual chain blocks fixed to soffits of culverts"]
[{"$nulls":3},"with \"Hilti Hit RE-500 inside the jacking tunnel "]
[{"$nulls":3},"drawing no. 111242-0000-DRG-WW-0512",null,"m",92]
[]
["8.3.2","181.02","Handrails"]
[]
[null,null,".01","Stainless steel balustrading formed with 43mm "]
[{"$nulls":3},"diameter x 3mm thick stanchions at 1200mm "]
[{"$nulls":3},"centres, 33mm diameter x 2.6mm thick top and  "]
[{"$nulls":3},"bottom rails, filled with 15mm diameter vertical"]
[{"$nulls":3},"bars at 125mm centres, finished on all surfaces "]
[{"$nulls":3},"with epoxy coated painted finish and erected "]
[{"$nulls":3},"complete in strict accordance with manufactures "]
[{"$nulls":3},"instructions as per drwg 111242-0000-DRG-SS-3002:"]
[]
[{"$nulls":3},".01","Horizontal","m",33]
[]
["8.3.3","181.03","Ladders, complete and installed:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Stainless steel access ladders ",{"$nulls":4},""]
[{"$nulls":3},"bolted to concrete walls complete as",{"$nulls":4},""]
[{"$nulls":3},"shown on Drawings ",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Air Valve Chambers, exceeding 1m and not ",{"$nulls":3},{"$f":"IF(OR(AND(G48=\"Prov\",H48=\"Sum\"),(H48=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G48*H48),\"\",IF(G48*H48=0,\"\",ROUND(G48*H48,2))))","v":""}]
[{"$nulls":4},"exceeding 2m high, drawing "]
[{"$nulls":4},"111242-0000-DRG-WW-0500","number",6]
[{"$nulls":8},""]
[{"$nulls":3},".02","Air Valve Chambers, exceeding 2m and not ",{"$nulls":3},""]
[{"$nulls":4},"exceeding 3m high, drawing "]
[{"$nulls":4},"111242-0000-DRG-WW-0500","number",3]
[{"$nulls":8},{"$f":"IF(OR(AND(G55=\"Prov\",H55=\"Sum\"),(H55=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G55*H55),\"\",IF(G55*H55=0,\"\",ROUND(G55*H55,2))))","v":""}]
[{"$nulls":3},".03","Isolating Valve Chambers, exceeding 2m "]
[{"$nulls":4},"and not exceeding 3m high, drawing "]
[{"$nulls":4},"111242-0000-DRG-WW-0501","number",1]
[]
[{"$nulls":3},".04","Isolating Valve Chambers, exceeding 3m "]
[{"$nulls":4},"and not exceeding 4m high, drawing "]
[{"$nulls":4},"111242-0000-DRG-WW-0501","number",4]
[]
[{"$nulls":3},".05","Scour Valve Chambers, exceeding 2m "]
[{"$nulls":4},"and not exceeding 3m high, drawing "]
[{"$nulls":4},"111242-0000-DRG-WW-0502","number",3]
[]
[{"$nulls":3},".06","Scour Valve Chambers, exceeding 3m "]
[{"$nulls":4},"and not exceeding 4m high, drawing "]
[{"$nulls":4},"111242-0000-DRG-WW-0502","number",1]
[]
[{"$nulls":3},".07","Scour Valve Chambers, exceeding 4m "]
[{"$nulls":4},"and not exceeding 5m high, drawing "]
[{"$nulls":4},"111242-0000-DRG-WW-0502","number",1]
[]
[{"$nulls":3},".08","Water Meter Chambers, exceeding 2m "]
[{"$nulls":4},"and not exceeding 3m high, drawing "]
[{"$nulls":4},"111242-0000-DRG-WW-0508","number",1]
[]
[]
["2001 CC1","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                 SECTION 1200 HA"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
["8.3.3","181.03",".01",".09","Water Meter Chambers, exceeding 3m "]
[null,"(Cont)",null,null,"and not exceeding 4m high, drawing "]
[{"$nulls":4},"111242-0000-DRG-WW-0508","number",3]
[]
[{"$nulls":3},".10","Water Meter Chambers, exceeding 4m "]
[{"$nulls":4},"and not exceeding 5m high, drawing "]
[{"$nulls":4},"111242-0000-DRG-WW-0508","number",1]
[]
[null,null,".02","Galvanized mild steel ladders "]
[{"$nulls":3},"bolted to concrete walls complete as"]
[{"$nulls":3},"shown on Drawing no. "]
[{"$nulls":3},"111242-0000-DRG-WW-0515"]
[]
[{"$nulls":3},".01","Access Chamber 1 (10m high "]
[{"$nulls":4},"cat-ladder)","number",2]
[]
[null,null,".03","Galvanized mild steel ladders "]
[{"$nulls":3},"bolted to concrete walls complete as"]
[{"$nulls":3},"shown on Drawing no. "]
[{"$nulls":3},"111242-0000-DRG-WW-0513"]
[]
[{"$nulls":3},".01","Access Chamber 1 (4.45m high "]
[{"$nulls":4},"cat-ladder)","number",1]
[]
["8.3.4",181.04,"25 x 4.5mm Galvanised banded grating, including "]
[null,null,"structural beams and posts complete and "]
[null,null,"installed with frames:"]
[]
[null,null,".01","As shown on Drawing No "]
[{"$nulls":3},"111242-0000-DRG-SS-3002 & 3003",null,"m²",8]
[]
[null,null,"40 x 3mm Galvanised and banded mentis grating,"]
[null,null," including angle and fishtail lugs complete as per "]
[null,null,"drawing 111242-DRG-SS-3001"]
[]
[null,null,".01","Sump cover",null,"m²",2]
[]
[null,181.05,"Staircases, complete and installed :"]
[]
[null,null,".01","Galvanised ladder, 1.5m high, as shown on  "]
[{"$nulls":3},"Drawing No 111242-0000-DRG-SS-3002 & 3003",null,"number",5]
{"$rows_empty":30}
[null,"TOTAL SECTION 1200 HA CARRIED TO SUMMARY"]

{"sheet":"1200L","index":8,"n_rows":628,"n_cols":9,"rows_kept":628}
[]
[]
[{"$nulls":8},"SECTION 1200 L"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},""]
["SANS","210.00","MEDIUM-PRESSURE PIPELINES",{"$nulls":5},""]
["1200 L",{"$nulls":7},""]
[null,null,1,"Fittings are regarded as special pipes ",{"$nulls":4},""]
[{"$nulls":3},"and not measured as extra over items",{"$nulls":4},""]
[{"$nulls":8},""]
[null,null,2,"Direction changes < 5° not measured ",{"$nulls":4},""]
[{"$nulls":3},"as specials and must be ",{"$nulls":4},""]
[{"$nulls":3},"accommodated in the laying of the ",{"$nulls":4},""]
[{"$nulls":3},"pipes",{"$nulls":4},""]
[{"$nulls":8},""]
[null,null,3,"All new specials to be manufactured",{"$nulls":4},""]
[{"$nulls":3},"and lined and coated as per ",{"$nulls":4},""]
[{"$nulls":3},"pipe specifications included in this",{"$nulls":4},""]
[{"$nulls":3},"Project Document",{"$nulls":4},""]
[{"$nulls":8},""]
[null,null,"4","All Steel Pipelines shall be Spirally ",{"$nulls":4},""]
[{"$nulls":3},"welded and butt welded (Longitudinal",{"$nulls":4},""]
[{"$nulls":3},"Welded pipes shall not be considered in",{"$nulls":4},""]
[{"$nulls":3},"these circumstances)",{"$nulls":4},""]
[{"$nulls":8},""]
["8.2.1","210.01","Supply, lay and bed on bedding as shown on",{"$nulls":5},""]
[null,null,"Drawings no. 111242-0000-DRG-WW-0301 to -0310",{"$nulls":5},""]
[null,null,"or fixed above ground inside structures, complete",{"$nulls":5},""]
[null,null,"with on-site welding joints, testing, etc:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Grade X42 to API 5L welded steel pipes, ",{"$nulls":4},""]
[{"$nulls":3},"with Single Coat Solvent Free Liquid Epoxy",{"$nulls":4},""]
[{"$nulls":3},"lining (600 microns DFT) and coating with Rigid "]
[{"$nulls":3},"Polyurethane (2000 microns DFT) or similar "]
[{"$nulls":3},"approved by JW:"]
[]
[{"$nulls":3},".01","610 mm dia x 8 mm thickness","m",{"v":3166,"d":"3,166"}]
[]
[{"$nulls":3},".02","710 mm dia x 8 mm thickness","m",{"v":2886,"d":"2,886"}]
[]
["8.2.1","210.02","Supply, lay, joint and install inside concrete"]
[null,null,"sleeve pipe including skids, steel straps, malthoid"]
[null,null,"packings, sand, cement, bentonite, grout, etc."]
[null,null,"complete with on-site welding joints, testing, etc"]
[null,null,"as shown on Drawing no 111242-0000-"]
[null,null,"WW-DRG-0506"]
[]
[null,null,".01","Grade X42 to API 5L welded steel pipes, "]
[{"$nulls":3},"with Single Coat Solvent Free Liquid Epoxy"]
[{"$nulls":3},"lining (600 microns DFT) and coating with Rigid "]
[{"$nulls":3},"Polyurethane (2000 microns DFT) or similar "]
[{"$nulls":3},"approved by JW:"]
[]
[{"$nulls":3},".01","609 mm dia x 8 mm thickness"]
[{"$nulls":4},"(pipes in 18 m lengths)","m",371]
[]
[{"$nulls":3},".02","710 mm dia x 8 mm thickness"]
[{"$nulls":4},"(pipes in 18 m lengths)","m",291]
[]
["8.2.1","210.03","Supply, joint Horizontal Drilling pipes:"]
[]
[null,null,".01","HDPE PE 100 PN 16 SDR11 pipes, to"]
[{"$nulls":3},"SANS 4427, butt welded to SANS 0269"]
[]
[{"$nulls":3},".01","630 mm dia (pipes in 6 m lengths)","m",371]
[]
[{"$nulls":3},".02","710 mm dia (pipes in 6 m lengths)","m",291]
[]
[]
[]
[]
[{"$nulls":8},""]
[]
["1200 L","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 1200 L"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},""]
["8.2.1","210.03","Supply, lay and bed on flexible pipe"]
[null,null,"bedding, complete with couplings:"]
[]
[null,null,".02","mPVC class 16, to SANS 966 Part 2",{"$nulls":4},""]
[{"$nulls":3},"pipes with spigot and socket ends:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","315 mm dia pipe","m",62]
[]
["8.2.2","210.04","Extra over items 210.01 and 210.02 for the",{"$nulls":5},""]
[null,null,"supplying laying, jointing and bedding below",{"$nulls":5},""]
[null,null,"ground or installed in structures, of fittings,",{"$nulls":5},""]
[null,null,"specials and valves on Grade X42 to API 5L",{"$nulls":5},""]
[null,null,"welded or flanged steel pipes, with Single Coat",{"$nulls":5},""]
[null,null,"Solvent Free Liquid Epoxy lining and coating",{"$nulls":5},""]
[null,null,"with Rigid Polyurethane (2000 microns DFT) or",{"$nulls":5},""]
[null,null,"similar approved by JW:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"ISOLATING VALVE CHAMBER ( x 5):",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Drawing No. 111242-0000-DRG-WW-0501:",{"$nulls":4},""]
[{"$nulls":3},"Steel grade X42, 8 mm wall thickness, Single",{"$nulls":4},""]
[{"$nulls":3},"Coat  Solvent Free Liquid Epoxy lined and coated",{"$nulls":4},""]
[{"$nulls":3},"with Rigid Polyurethane, flange drilling to"]
[{"$nulls":3},"SANS 1123 T1600/3:"]
[]
[{"$nulls":3},".01","711 mm dia x 610 mm dia x "]
[{"$nulls":4},"430 mm steel reducer with "]
[{"$nulls":4},"1 500 mm long integral straight"]
[{"$nulls":4},"pipe, item 1","number",10]
[]
[{"$nulls":3},".02","610 mm dia  x 1500mm integral"]
[{"$nulls":4},"straight pipe, item 1","number",10]
[]
[{"$nulls":3},".03","610 mm dia x 1 450 mm steel"]
[{"$nulls":4},"puddle pipe, flanged one end, "]
[{"$nulls":4},"item 2","number",10]
[]
[{"$nulls":3},".04","610 mm dia x 219 mm dia steel"]
[{"$nulls":4},"tee, all ends flanged, item 3","number",5]
[]
[{"$nulls":3},".05","600 mm dia VOSA non-rising "]
[{"$nulls":4},"wedge gate valve or similar"]
[{"$nulls":4},"approved, item 4 (Mech)","number",5]
[]
[{"$nulls":3},".06","610 mm dia x 219 mm dia steel"]
[{"$nulls":4},"tee, all ends flanged, item 5","number",5]
[]
[{"$nulls":3},".07","219 mm dia x 90 degree steel "]
[{"$nulls":4},"bend, flanged, item 6","number",10]
[]
[{"$nulls":3},".08","219 mm dia x 446 mm steel"]
[{"$nulls":4},"straight pipe, flanged both sides,"]
[{"$nulls":4},"item 7","number",10]
[]
[{"$nulls":3},".09","200 mm dia VOSA non-rising "]
[{"$nulls":4},"wedge gate valve or similar"]
[{"$nulls":4},"approved, item 8 (Mech)","number",5]
{"$rows_empty":9}
["1200 L","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 1200 L"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},""]
[null,null,"AIR VALVE CHAMBERS ( x 9):"]
[]
["8.2.2","210.04",".02","Drawing No. 111242-0000-DRG-WW-0500:"]
[null,"(cont)",null,"Steel grade X42, 8 mm wall thickness, Single Coat"]
[{"$nulls":3},"Solvent Free Liquid Epoxy lining and coating with "]
[{"$nulls":3},"Rigid Polyurethane, flange drilling to SANS 1123 "]
[{"$nulls":3},"T1600/3:"]
[]
[{"$nulls":3},".01","711 mm dia x 355 mm dia x "]
[{"$nulls":4},"1181 mm steel tee, flanged both ends,"]
[{"$nulls":4},"with crotch plates, item 1","number",5]
[]
[{"$nulls":3},".02","610 mm dia x 355 mm dia x 1181 mm steel"]
[{"$nulls":4},"tee, flanged both ends, with crotch plates,"]
[{"$nulls":4},"item 1","number",4]
[]
[{"$nulls":3},".03","150 mm x 60 mm x 25 mm triangular shaped"]
[{"$nulls":4},"support bracket welded on, item 2","number",36]
[]
[{"$nulls":3},".04","520 mm dia x 30 mm thick flange one end"]
[{"$nulls":4},"fitting with 100 mm dia x 250 mm steel"]
[{"$nulls":4},"spool pipe with 220 mm dia x 14 mm thick"]
[{"$nulls":4},"flange one end, and lifting hooks, item 3","number",7]
[]
[{"$nulls":3},".05","520 mm dia x 30 mm thick flange one end"]
[{"$nulls":4},"fitting with 200 mm dia x 250 mm steel"]
[{"$nulls":4},"spool pipe with 340 mm dia x 22 mm thick"]
[{"$nulls":4},"flange one end, and lifting hooks, item 3","number",2]
[]
[{"$nulls":3},".06","100 mm dia non-rising spindle"]
[{"$nulls":4},"resilient seal gate valve, item 4","number",7]
[]
[{"$nulls":3},".07","200 mm dia VOSA non-rising spindle wedge"]
[{"$nulls":4},"gate valve, or similar approved, item 4","number",2]
[]
[{"$nulls":3},".08","100 mm dia Vent-O-Mat Series RBX double"]
[{"$nulls":4},"orifice air valve with anti shock orifice"]
[{"$nulls":4},"mechanism, item 5","number",7]
[]
[{"$nulls":3},".09","200 mm dia Vent-O-Mat Series RBX double"]
[{"$nulls":4},"RBX double orifice air valve with anti shock"]
[{"$nulls":4},"orifice mechanism, item 5","number",2]
[]
[{"$nulls":3},".10","Site welding, testing and repairs:"]
[]
[{"$nulls":4},".01  711 mm dia pipe to fitting or special","number",7]
[{"$nulls":3}," "]
[{"$nulls":4},".02  610 mm dia pipe to fitting or special","number",2]
{"$rows_empty":12}
["1200 L","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 1200 L"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},""]
[null,null,"SCOUR VALVE CHAMBERS ( x 5):",{"$nulls":5},""]
[{"$nulls":8},""]
["8.2.2","210.04",".03","Drawing No. ",{"$nulls":4},""]
[null,"(cont)",null,"111242-0000-DRG-WW-0502: Steel ",{"$nulls":4},""]
[{"$nulls":3},"grade X42, 8 mm wall thickness, Single Coat",{"$nulls":4},""]
[{"$nulls":3},"Solvent Free Liquid Epoxy lining and coating ",{"$nulls":4},""]
[{"$nulls":3},"with Rigid Polyurethane, flange drilling to "]
[{"$nulls":3},"SANS 1123 T1600/3:"]
[{"$nulls":8},""]
[{"$nulls":3},".01","711 mm dia x 4 800 mm double puddle pipe"]
[{"$nulls":4},"combination fitting with CP connection point,"]
[{"$nulls":4},"comprising 711 mm dia x 219 mm dia flanged"]
[{"$nulls":4},"scour outlet, item 1","number",3]
[]
[{"$nulls":3},".02","610 mm dia x 4 800 mm double puddle pipe"]
[{"$nulls":4},"combination fitting with CP connection point,"]
[{"$nulls":4},"comprising 610 mm dia x 219 mm dia flanged"]
[{"$nulls":4},"scour outlet, item 1","number",2]
[]
[{"$nulls":3},".03","200 mm dia wedge gate valve, both ends,"]
[{"$nulls":4},"flanged, item 2 (Mech)","number",10]
[]
[{"$nulls":3},".04","219 mm dia x 614 mm spool pipe, both ends"]
[{"$nulls":4},"flanged, item 3","number",5]
[]
[{"$nulls":3},".05","219 mm dia x 1 062 mm puddle pipe with CP"]
[{"$nulls":4},"connection point, item 5","number",5]
[]
[{"$nulls":3},".06","Site welding, testing and repairs:"]
[]
[{"$nulls":4},".01  711 mm dia pipe to fitting or special","number",3]
[]
[{"$nulls":4},".02  610 mm dia pipe to fitting or special","number",2]
[]
[null,null,"WATER METER CHAMBERS ( x 5):",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".06","Drawing No. 111242-0000-DRG-WW-0508:",{"$nulls":4},""]
[{"$nulls":3},"Steel grade X42, 8 mm wall thickness, 16 bar, ",{"$nulls":4},""]
[{"$nulls":3},"Single Coat Solvent Free Liquid Epoxy lining and ",{"$nulls":4},""]
[{"$nulls":3},"coating with Rigid Polyurethane, flange drilling to "]
[{"$nulls":3},"SANS 1123 T1600/3:"]
[]
[{"$nulls":3},".01","315 mm dia x 219 mm dia steel reducer with"]
[{"$nulls":4},"315 mm dia integral straight mPVC pipe,"]
[{"$nulls":4},"both ends flanged, item 1","number",10]
[]
[{"$nulls":3},".02","219 mm dia x 1 200 mm steel puddle pipe,"]
[{"$nulls":4},"both ends flanged, item 2","number",10]
[]
[{"$nulls":3},".03","200 mm dia VOSA non-rising wedge gate"]
[{"$nulls":4},"valve or similar approved, item 3 (Mech)","number",10]
[]
[{"$nulls":3},".04","219 mm dia x 1 000 mm dia steel"]
[{"$nulls":4},"pipe, both ends flanged, item 4","number",5]
[]
[{"$nulls":3},".05","Woltman WP-type water meter or"]
[{"$nulls":4},"similar approved, item 5","number",5]
[]
[{"$nulls":3},".06","219 mm dia x 582 mm dia steel"]
[{"$nulls":4},"pipe, one end flanged, item 6","number",5]
[]
[{"$nulls":3},".07","219 mm dia x 200 mm dia steel straight pipe,"]
[{"$nulls":4},"flanged both ends, item 7","number",5]
[]
[{"$nulls":3},".08","Sensus DN200 water strainer or "]
[{"$nulls":4},"similar approved, item 8","number",5]
[]
[]
["1200 L","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 1200 L"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},""]
[null,null,"ACCESS CHAMBER 1 ( x 1):"]
[]
["8.2.2","210.04",".07","Drawing No. 111242-0000-DRG-WW-0509:"]
[null,"(cont)",null,"Steel grade X42, 8 mm wall thickness, Single Coat"]
[{"$nulls":3},"Solvent Free Liquid Epoxy lining and coating with"]
[{"$nulls":3},"Rigid Polyurethane, flange drilling to "]
[{"$nulls":3},"SANS 1123 T1600/3:"]
[]
[{"$nulls":3},".01","711 mm dia  x 1500mm integral"]
[{"$nulls":4},"straight pipe, flanged one end, item 1","number",1]
[]
[{"$nulls":3},".02","711 mm dia x 1 550 mm steel puddle pipe,"]
[{"$nulls":4},"flanged both ends, item 2","number",1]
[]
[{"$nulls":3},".03","711 mm dia x 90 degree steel "]
[{"$nulls":4},"bend, flanged both ends, item 3","number",2]
[]
[{"$nulls":3},".04","711 mm dia x 8 389 mm steel straight pipe,"]
[{"$nulls":4},"flanged both ends, (length to be confirmed on "]
[{"$nulls":4},"site), item 4","number",1]
[]
[{"$nulls":3},".05","711 mm dia x 1 420 mm steel straight pipe,"]
[{"$nulls":4},"flanged both ends, item 5","number",1]
[]
[{"$nulls":3},".06","711 mm dia x 4 000 mm steel"]
[{"$nulls":4},"straight pipe, flanged both ends, "]
[{"$nulls":4},"item 6","number",1]
[]
[null,null,"ACCESS CHAMBER 2 ( x 1):"]
[]
[null,null,".08","Drawing No. 111242-0000-DRG-WW-0513:"]
[{"$nulls":3},"Steel grade X42, 8 mm wall thickness, Single Coat"]
[{"$nulls":3},"Solvent Free Liquid Epoxy lining and coating "]
[{"$nulls":3},"with Rigid Polyurethane, flange drilling to "]
[{"$nulls":3},"SANS 1123 T1600/3:"]
[]
[{"$nulls":3},".01","711 mm dia x 1 000 mm steel straight pipe,"]
[{"$nulls":4},"flanged both ends, item 1","number",1]
[]
[{"$nulls":3},".02","711 mm dia x 2 795 mm steel puddle pipe,"]
[{"$nulls":4},"flanged both ends, item 2","number",1]
[]
[{"$nulls":3},".03","711 mm dia x 4 540 mm steel straight pipe,"]
[{"$nulls":4},"flanged both ends, item 3","number",1]
[]
[{"$nulls":3},".04","711 mm dia x 4 000 mm steel"]
[{"$nulls":4},"flanged both ends, item 5","number",1]
[]
["8.2.2","210.05","Extra over item 210.01.01 for the supplying"]
[null,null,"laying, jointing and bedding below ground"]
[null,null,"or installed in structures, of fittings, specials"]
[null,null,"and valves on Grade X42 to API 5L (16 bar)"]
[null,null,"flanged steel pipes with Single Coat Solvent "]
[null,null,"Free Liquid Epoxy lining and external coating "]
[null,null,"with Rigid Polyurethane or similar approved:"]
[]
[null,null,".01","Bends:"]
[]
[{"$nulls":3},".01","Bends in change of 610 mm dia"]
[{"$nulls":4},"pipe directions:"]
[]
[{"$nulls":4},".01  Over 5° up to 10°","number",8]
[]
[{"$nulls":4},".02  Over 10° up to 15°","number",4]
[]
[{"$nulls":4},".03  Over 15° up to 20°","number",4]
[]
[{"$nulls":4},".04  Over 20° up to 25°","number",2]
[]
[]
["1200 L","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 1200 L"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
["8.2.2","210.05",".01",".01",".05  Over 25° up to 30°","number",5]
[null,"(cont)"]
[{"$nulls":4},".06  Over 30° up to 35°","number",3]
[]
[{"$nulls":4},".07  Over 35° up to 40°","number",2]
[]
[{"$nulls":4},".08  Over 40° up to 45°","number",3]
[]
[{"$nulls":4},".09  Over 45° up to 50°","number",1]
[]
[{"$nulls":4},".10  Over 50° up to 55°","number",1]
[]
[{"$nulls":4},".11  Over 55° up to 60°","number",1]
[]
[{"$nulls":4},".12  Over 70° up to 75°","number",1]
[]
[{"$nulls":4},".13  Over 75° up to 80°","number",1]
[]
[{"$nulls":4},".14  Over 80° up to 85°","number",3]
[]
[{"$nulls":4},".15  Over 85° up to 90°","number",4]
[]
[{"$nulls":4},".16  Over 95° up to 100°","number",1]
[]
[null,null,".01",".02","Bends in change of 711 mm dia"]
[{"$nulls":4},"pipe directions:"]
[]
[{"$nulls":4},".01  Over 5° up to 10°","number",18]
[]
[{"$nulls":4},".02  Over 10° up to 15°","number",5]
[]
[{"$nulls":4},".03  Over 15° up to 20°","number",3]
[]
[{"$nulls":4},".04  Over 20° up to 25°","number",2]
[]
[{"$nulls":4},".05  Over 25° up to 30°","number",3]
[]
[{"$nulls":4},".06  Over 40° up to 45°","number",2]
[]
[{"$nulls":4},".07  Over 45° up to 50°","number",1]
[]
[{"$nulls":4},".08  Over 55° up to 60°","number",1]
[]
[{"$nulls":4},".09  Over 65° up to 70°","number",1]
[]
[{"$nulls":4},".10  Over 70° up to 75°","number",1]
[]
[{"$nulls":4},".11  Over 80° up to 85°","number",2]
[]
[{"$nulls":4},".12  Over 85° up to 90°","number",4]
[]
[{"$nulls":4},".13  Over 90° up to 95°","number",4]
[]
[{"$nulls":4},".14  Over 105° up to 110°","number",2]
[]
[{"$nulls":3},".03","Site welding, testing and repairs:"]
[]
[{"$nulls":4},".01  711 mm dia pipe to pipe fitting"]
[{"$nulls":3}," ","       or special","number",10]
[]
[{"$nulls":4},".02  610 mm dia pipe to pipe fitting"]
[{"$nulls":4},"       or special","number",10]
[]
[]
[]
[]
[]
["1200 L","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 1200 L"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},""]
["8.2.2","210.05",".02","Tees:"]
[null,"(cont)"]
[{"$nulls":3},".01","610 mm dia x 610 mm dia ","number",2]
[]
[{"$nulls":3},".02","711 mm dia x 711 mm dia ","number",3]
[]
[{"$nulls":3},".03","812 mm dia x 711 mm dia ","number",1]
[]
[null,null,".03","Reducers:"]
[]
[{"$nulls":3},".01","610 mm dia x 315 mm dia ","number",2]
[]
[{"$nulls":3},".02","610 mm dia x 500 mm dia ","number",3]
[]
[{"$nulls":3},".03","711 mm dia x 315 mm dia ","number",3]
[]
[{"$nulls":3},".04","711 mm dia x 610 mm dia ","number",1]
[]
[null,null,".04","Blank flange:"]
[]
[{"$nulls":3},".01","610 mm dia","number",2]
[]
[{"$nulls":3},".02","711 mm dia","number",3]
[]
["8.2.2","210.06","Extra over item 210.03.01 for the supplying,"]
[null,null,"laying and bedding of mPVC specials complete"]
[null,null,"with couplings:"]
[]
[null,null,".01","Flange adaptor:"]
[]
[{"$nulls":3},".01","315 mm dia","number",3]
[]
[null,null,".02","Blank flange:"]
[]
[{"$nulls":3},".01","315 mm dia","number",3]
[]
[null,null,".03","End caps:"]
[]
[{"$nulls":3},".01","315 mm dia","number",3]
[]
[null,"210.07","Extra over item 210.03.02 for the supplying laying,"]
[null,null,"jointing and bedding below ground or installed in "]
[null,null,"structures, of fittings, specials and valves on "]
[null,null,"PE 100 PN 16 SDR11, SANS 10269 HDPE pipes, "]
[null,null,"butt welded:"]
[]
[null,null,".01","HDPE stubs and backing rings for the"]
[{"$nulls":3},"following sizes:"]
[]
[{"$nulls":3},".01","630 mm dia","number",12]
[]
[{"$nulls":3},".02","710 mm dia","number",4]
[]
[{"$nulls":3},".03","800 mm dia","number",2]
[]
["8.2.15","210.09","Special wrapping in corrosive soil: "]
[]
[null,null,".01","Denso tape wrapping to steel pipes, fittings etc:"]
[]
[{"$nulls":3},".01","610 mm dia ","m",200]
[]
[{"$nulls":3},".02","711 mm dia ","m",200]
[]
[{"$nulls":3},".03","812 mm dia","m",100]
[]
[]
[]
["1200 L","Carried forward"]
[]
[]
[]
[{"$nulls":8},"SECTION 1200 L"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},""]
[null,"210.10","Extra over item 210.01 above for on-site cutting of"]
[null,null,"straight pipes to suite fixed chainage lengths,"]
[null,null,"fittings or specials and chamber positions "]
[null,null,"including site welding, testing and repairing of new"]
[null,null,"joints, for:"]
[]
[{"$nulls":3},".01","610 mm dia x 8 mm thickness","number",30]
[]
[{"$nulls":3},".02","711 mm dia x 8 mm thickness","number",40]
[]
["PSL","210.11","Pipeline route markers:",{"$nulls":5},""]
["8.2.18",{"$nulls":7},""]
[null,null,".01","Type as shown on Drawing No.",{"$nulls":4},""]
[{"$nulls":3},"111242-0000-DRG-WW-0507",null,"number",160]
["PSL"]
["8.2.19","210.12","Connection to existing main supply pipe:",{"$nulls":5},""]
[]
[null,null,".01","Supply and install fittings and specials on bedding,"]
[{"$nulls":3},"complete with on-site welding, couplings, testing"]
[{"$nulls":3},"etc at existing water meter chamber tie-in:",null,"number",1]
[]
[null,null,".02","Supply and install fittings and specials on bedding,"]
[{"$nulls":3},"complete with on-site welding, couplings, testing"]
[{"$nulls":3},"etc at existing 800mm dia. water pipeline at"]
[{"$nulls":3},"Bridal Veil Road tie-in:",null,"number",1]
[]
[null,null,".03","Supply and install fittings and specials on bedding,"]
[{"$nulls":3},"complete with on-site welding, couplings, testing"]
[{"$nulls":3},"etc at existing water pipeline at Harry Galaun "]
[{"$nulls":3},"Drive tie-in:",null,"number",1]
[]
["SD8.7",210.13,"Grouting"]
[]
[null,null,".01","Non shrink grout for water tightness on both "]
[{"$nulls":3},"sides of jacked culverts",null,"m³",{"v":3.63451231084922,"d":"4"}]
[]
["SD8.8",210.14,"HD bolts and miscellaneous metal work:"]
[]
[null,null,".01","80mm Thick polystyrene strip",null,"m²",{"v":18.1725615542461,"d":"18"}]
[]
["PSL",210.15,"Cathodic Protection Work by Sub-Contractor",null,null,"Prov sum",1,{"v":875000,"d":"875,000.00"},{"$f":"G598*H598","v":{"v":875000,"d":"875,000.00"}}]
["8.2.20"]
[null,210.16,"Overheads, charges and profit on safety equipment",null,null,"%",{"v":0.1,"d":"10%"},{"$f":"I598","v":{"v":875000,"d":"875,000.00"}},{"$f":"G600*H600","v":{"v":87500,"d":"87,500.00"}}]
[]
["PSL",210.17,"AC Mitigation Work by Sub-Contractor",null,null,"Prov sum",1,{"v":875000,"d":"875,000.00"},{"$f":"G602*H602","v":{"v":875000,"d":"875,000.00"}}]
["8.2.22"]
[null,210.18,"Overheads, charges and profit on safety equipment",null,null,"%",{"v":0.1,"d":"10%"},{"$f":"I602","v":{"v":875000,"d":"875,000.00"}},{"$f":"G604*H604","v":{"v":87500,"d":"87,500.00"}}]
[]
[null,"210.19","CCTV pipe inspections",null,null,"m",{"v":6847,"d":"6,847"}]
[]
[null,"210.20","Non-Destructive Testing (NDT) for pipe ",null,null,"sum",194]
[null,null,"welding on site"]
{"$rows_empty":15}
[{"$nulls":8},""]
[]
[]
[null,"TOTAL SECTION 1200 L CARRIED TO SUMMARY"]

{"sheet":"1200LB","index":9,"n_rows":74,"n_cols":9,"rows_kept":74,"merged":[[45,3,45,4]]}
[]
[{"$nulls":8},"                  SECTION 1200 LB"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SANS","211.00","BEDDING (PIPES)",{"$nulls":5},""]
["1200 LB",{"$nulls":7},""]
[{"$nulls":8},""]
[null,null,"BEDDING FOR WATER PIPES",{"$nulls":5},""]
[]
[null,null,"Note:",null,"Beddings as shown on Drawing"]
[{"$nulls":4},"No 111242-0000-DRG-WW-0504"]
["PSLB",{"$nulls":7},""]
["8.2.1","211.01","Provision of bedding from trench ",{"$nulls":5},""]
[null,null,"excavation:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Selected granular material ",null,"m³",20,null,""]
[{"$nulls":8},""]
[null,null,".02","Selected fill material",null,"m³",20,null,""]
[{"$nulls":8},""]
["PSLB","211.02","Supply only of bedding by importation:",{"$nulls":5},""]
["8.2.2",{"$nulls":7},{"$f":"IF(OR(AND(G24=\"Prov\",H24=\"Sum\"),(H24=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G24*H24),\"\",IF(G24*H24=0,\"\",ROUND(G24*H24,2))))","v":""}]
[null,null,".01","From other necessary excavations:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Selected granular material","m³",100,null,""]
[{"$nulls":8},""]
[{"$nulls":3},".02","Selected fill material","m³",100,null,""]
[{"$nulls":8},""]
[null,null,".02","From commercial sources:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","Selected granular material","m³",{"v":3389,"d":"3,389"},null,""]
[{"$nulls":8},""]
[{"$nulls":3},".02","Selected fill material ","m³",{"v":4612,"d":"4,612"},null,""]
[{"$nulls":8},""]
["8.2.4","211.04","Encasing of pipes in concrete:",{"$nulls":5},{"$f":"IF(OR(AND(G37=\"Prov\",H37=\"Sum\"),(H37=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G37*H37),\"\",IF(G37*H37=0,\"\",ROUND(G37*H37,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","30MPa/19mm concrete encasing, incl ",{"$nulls":4},""]
[{"$nulls":3},"formwork",{"$nulls":4},""]
[]
[{"$nulls":3},".01","710 mm dia steel pipe","m³",100,null,""]
[]
["8.2.7",211.05,"Extra over item 211.04 above for:"]
[]
[null,null,".01","Mild steel reinforcement",null,"t",10]
[{"$nulls":8},""]
["SANS",211.07,"High-tensile welded mesh in the ",{"$nulls":5},""]
["2001 CC",null,"following:",{"$nulls":5},""]
["8.3.2",{"$nulls":7},""]
[null,null,".01","Ref 395 in concrete encasing around",{"$nulls":4},""]
[{"$nulls":3},"pipes",null,"m²",100,null,""]
[{"$nulls":8},{"$f":"IF(OR(AND(G53=\"Prov\",H53=\"Sum\"),(H53=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G53*H53),\"\",IF(G53*H53=0,\"\",ROUND(G53*H53,2))))","v":""}]
{"$rows_empty":18}
[{"$nulls":8},""]
[]
[null,"TOTAL SECTION 1200 LB CARRIED TO SUMMARY"]

{"sheet":"1200LE","index":10,"n_rows":85,"n_cols":9,"rows_kept":85}
[]
[{"$nulls":8},"                  SECTION 1200 LE"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SANS","214.00","STORMWATER DRAINAGE",{"$nulls":5},""]
["1200 LE",{"$nulls":7},""]
[{"$nulls":8},""]
["8.2.10",214.01,"Accessories:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Submersible pump connected to 160mm dia pipe",null,"No",2,null,{"$f":"IF(OR(AND(G13=\"Prov\",H13=\"Sum\"),(H13=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G13*H13),\"\",IF(G13*H13=0,\"\",ROUND(G13*H13,2))))","v":""}]
[{"$nulls":8},""]
["PSLE",214.02,"Pipes in subsurface drains:",{"$nulls":5},""]
["8.2.14",{"$nulls":7},""]
[null,null,".01","Normal duty uPVC pipes complete ",{"$nulls":4},""]
[{"$nulls":3},"with couplings:",{"$nulls":4},""]
[{"$nulls":8},""]
[{"$nulls":3},".01","150 mm internal dia, perforated   ","m",40,null,{"$f":"IF(OR(AND(G20=\"Prov\",H20=\"Sum\"),(H20=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G20*H20),\"\",IF(G20*H20=0,\"\",ROUND(G20*H20,2))))","v":""}]
[{"$nulls":8},""]
["PSLE",214.03,"Geofabric",{"$nulls":5},""]
["8.2.15",{"$nulls":7},""]
[null,null,".01","A4 Bidum Geotextile or similar approved",null,"m²",66,null,{"$f":"IF(OR(AND(G24=\"Prov\",H24=\"Sum\"),(H24=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G24*H24),\"\",IF(G24*H24=0,\"\",ROUND(G24*H24,2))))","v":""}]
[{"$nulls":8},""]
["PSLE",214.04,"Crushed stone in subsurface drains   ",{"$nulls":5},""]
["8.2.16",{"$nulls":7},""]
[null,null,".01","Single sized crushed stone, ,nominal  size",{"$nulls":4},""]
[{"$nulls":3},"19mm clean washed aggregate",null,"m³",15,null,{"$f":"IF(OR(AND(G29=\"Prov\",H29=\"Sum\"),(H29=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G29*H29),\"\",IF(G29*H29=0,\"\",ROUND(G29*H29,2))))","v":""}]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
{"$rows_empty":27}
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[]
[{"$nulls":8},""]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},""]
[]
[{"$nulls":8},""]
[]
[null,"TOTAL SECTION 1200 LE CARRIED TO SUMMARY"]

{"sheet":"1200LG","index":11,"n_rows":706,"n_cols":9,"rows_kept":706,"merged":[[375,2,375,4]]}
[]
[]
[{"$nulls":8},"                 SECTION 1200 LG"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SANS","216.00","PIPE JACKING",{"$nulls":5},""]
["1200 LG",{"$nulls":7},""]
[null,null,"ROAD CROSSING:1"]
[{"$nulls":8},""]
["8.2.1","216.01","Jacking establishment:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Fixed charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Time-related charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
["8.2.2","216.02","Supply of pipes to be jacked:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",77]
[{"$nulls":8},{"$f":"IF(OR(AND(G22=\"Prov\",H22=\"Sum\"),(H22=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G22*H22),\"\",IF(G22*H22=0,\"\",ROUND(G22*H22,2))))","v":""}]
["8.2.3","216.03","Jacking of pipes:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",77]
[{"$nulls":8},""]
["8.2.4","216.04","Excavation for jacking:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Soft excavation          ",null,"m³",69,null,""]
[{"$nulls":8},""]
[null,null,".02","Intermediate excavation  ",null,"m³",34,null,""]
[{"$nulls":8},""]
[null,null,".03","Hard rock excavation     ",null,"m³",11,null,""]
[{"$nulls":8},""]
["8.2.5","216.05","Extra over items 216.01 and 216.04 for ",{"$nulls":5},{"$f":"IF(OR(AND(G36=\"Prov\",H36=\"Sum\"),(H36=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G36*H36),\"\",IF(G36*H36=0,\"\",ROUND(G36*H36,2))))","v":""}]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[{"$nulls":8},""]
["8.2.9","216.06","Stabilization of unstable areas or ",{"$nulls":5},""]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Provision and establishment of equipment on",{"$nulls":4},""]
[{"$nulls":3},"site, and removal on completion of operation",null,"sum",1]
[{"$nulls":8},""]
[null,null,".02","Operation of equipment ",null,"day",2,null,{"$f":"IF(OR(AND(G45=\"Prov\",H45=\"Sum\"),(H45=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G45*H45),\"\",IF(G45*H45=0,\"\",ROUND(G45*H45,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",53,null,""]
[{"$nulls":8},""]
["8.2.10","216.07","Standing time for pipe jacking gang and the",{"$nulls":5},""]
[null,null,"jacking equipment covered by item 216.01",null,null,"h",40]
[]
[null,null,"ROAD CROSSING:2"]
[{"$nulls":8},{"$f":"IF(OR(AND(G53=\"Prov\",H53=\"Sum\"),(H53=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G53*H53),\"\",IF(G53*H53=0,\"\",ROUND(G53*H53,2))))","v":""}]
["8.2.1",216.11,"Jacking establishment:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Fixed charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Time-related charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
["8.2.2",216.12,"Supply of pipes to be jacked:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",46]
[]
["8.2.3",216.13,"Jacking of pipes:",{"$nulls":5},{"$f":"IF(OR(AND(G65=\"Prov\",H65=\"Sum\"),(H65=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G65*H65),\"\",IF(G65*H65=0,\"\",ROUND(G65*H65,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",46]
[]
["8.2.4",216.14,"Excavation for jacking:",{"$nulls":5},{"$f":"IF(OR(AND(G70=\"Prov\",H70=\"Sum\"),(H70=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G70*H70),\"\",IF(G70*H70=0,\"\",ROUND(G70*H70,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","Soft excavation          ",null,"m³",42,null,""]
[{"$nulls":8},""]
[null,null,".02","Intermediate excavation  ",null,"m³",20,null,""]
[{"$nulls":8},""]
[null,null,".03","Hard rock excavation     ",null,"m³",7,null,""]
[]
["1200 LG","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                 SECTION 1200 LG"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
["8.2.5",216.15,"Extra over items 216.11 and 216.14 for ",{"$nulls":5},{"$f":"IF(OR(AND(G90=\"Prov\",H90=\"Sum\"),(H90=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G90*H90),\"\",IF(G90*H90=0,\"\",ROUND(G90*H90,2))))","v":""}]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[]
["8.2.9",216.16,"Stabilization of unstable areas or ",{"$nulls":5},{"$f":"IF(OR(AND(G93=\"Prov\",H93=\"Sum\"),(H93=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G93*H93),\"\",IF(G93*H93=0,\"\",ROUND(G93*H93,2))))","v":""}]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Provision and establishment of equipment on",{"$nulls":4},""]
[{"$nulls":3},"site, and removal on completion of operation",null,"sum",1]
[]
[null,null,".02","Operation of equipment ",null,"day",2,null,{"$f":"IF(OR(AND(G99=\"Prov\",H99=\"Sum\"),(H99=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G99*H99),\"\",IF(G99*H99=0,\"\",ROUND(G99*H99,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",32,null,""]
[]
["8.2.10",216.17,"Standing time for pipe jacking gang and the"]
[null,null," jacking equipment covered by item 216.11",null,null,"h",40]
[]
[null,null,"ROAD CROSSING:3"]
[{"$nulls":8},{"$f":"IF(OR(AND(G107=\"Prov\",H107=\"Sum\"),(H107=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G107*H107),\"\",IF(G107*H107=0,\"\",ROUND(G107*H107,2))))","v":""}]
["8.2.1",216.21,"Jacking establishment:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Fixed charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Time-related charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
["8.2.2",216.22,"Supply of pipes to be jacked:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",62]
[]
["8.2.3",216.23,"Jacking of pipes:",{"$nulls":5},{"$f":"IF(OR(AND(G119=\"Prov\",H119=\"Sum\"),(H119=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G119*H119),\"\",IF(G119*H119=0,\"\",ROUND(G119*H119,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",62]
[]
["8.2.4",216.24,"Excavation for jacking:",{"$nulls":5},{"$f":"IF(OR(AND(G124=\"Prov\",H124=\"Sum\"),(H124=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G124*H124),\"\",IF(G124*H124=0,\"\",ROUND(G124*H124,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","Soft excavation          ",null,"m³",56,null,""]
[{"$nulls":8},""]
[null,null,".02","Intermediate excavation  ",null,"m³",28,null,""]
[{"$nulls":8},""]
[null,null,".03","Hard rock excavation     ",null,"m³",9,null,""]
[]
["8.2.5",216.25,"Extra over items 216.21 and 216.24 for ",{"$nulls":5},{"$f":"IF(OR(AND(G132=\"Prov\",H132=\"Sum\"),(H132=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G132*H132),\"\",IF(G132*H132=0,\"\",ROUND(G132*H132,2))))","v":""}]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[{"$nulls":8},{"$f":"IF(OR(AND(G134=\"Prov\",H134=\"Sum\"),(H134=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G134*H134),\"\",IF(G134*H134=0,\"\",ROUND(G134*H134,2))))","v":""}]
["8.2.9",216.26,"Stabilization of unstable areas or ",{"$nulls":5},""]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[]
[null,null,".01","Provision and establishment of equipment on",{"$nulls":4},{"$f":"IF(OR(AND(G138=\"Prov\",H138=\"Sum\"),(H138=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G138*H138),\"\",IF(G138*H138=0,\"\",ROUND(G138*H138,2))))","v":""}]
[{"$nulls":3},"site, and removal on completion of operation",null,"sum",1]
[]
[null,null,".02","Operation of equipment ",null,"day",2,null,{"$f":"IF(OR(AND(G141=\"Prov\",H141=\"Sum\"),(H141=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G141*H141),\"\",IF(G141*H141=0,\"\",ROUND(G141*H141,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",43,null,""]
[]
["8.2.10",216.27,"Standing time for pipe jacking gang "]
[null,null,"and the jacking equipment covered "]
[null,null,"by item 216.21",null,null,"h",40]
[]
[null,null,"ROAD CROSSING:4"]
[{"$nulls":8},{"$f":"IF(OR(AND(G150=\"Prov\",H150=\"Sum\"),(H150=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G150*H150),\"\",IF(G150*H150=0,\"\",ROUND(G150*H150,2))))","v":""}]
["8.2.1",216.31,"Jacking establishment:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Fixed charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Time-related charges    ",null,"sum",1,null,""]
[]
[]
["1200 LG","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                 SECTION 1200 LG"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G169=\"Prov\",H169=\"Sum\"),(H169=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G169*H169),\"\",IF(G169*H169=0,\"\",ROUND(G169*H169,2))))","v":""}]
["8.2.2",216.32,"Supply of pipes to be jacked:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to ",{"$nulls":4},""]
[{"$nulls":3},"SANS 677",null,"m",49,null,""]
[]
["8.2.3",216.33,"Jacking of pipes:",{"$nulls":5},{"$f":"IF(OR(AND(G176=\"Prov\",H176=\"Sum\"),(H176=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G176*H176),\"\",IF(G176*H176=0,\"\",ROUND(G176*H176,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to ",{"$nulls":4},""]
[{"$nulls":3},"SANS 677",null,"m",49,null,""]
[]
["8.2.4",216.34,"Excavation for jacking:",{"$nulls":5},{"$f":"IF(OR(AND(G182=\"Prov\",H182=\"Sum\"),(H182=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G182*H182),\"\",IF(G182*H182=0,\"\",ROUND(G182*H182,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","Soft excavation          ",null,"m³",45,null,""]
[{"$nulls":8},""]
[null,null,".02","Intermediate excavation  ",null,"m³",22,null,""]
[{"$nulls":8},""]
[null,null,".03","Hard rock excavation     ",null,"m³",7,null,""]
[]
["8.2.5",216.35,"Extra over items 216.31 and 216.34 for ",{"$nulls":5},{"$f":"IF(OR(AND(G190=\"Prov\",H190=\"Sum\"),(H190=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G190*H190),\"\",IF(G190*H190=0,\"\",ROUND(G190*H190,2))))","v":""}]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[{"$nulls":8},{"$f":"IF(OR(AND(G192=\"Prov\",H192=\"Sum\"),(H192=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G192*H192),\"\",IF(G192*H192=0,\"\",ROUND(G192*H192,2))))","v":""}]
["8.2.9",216.36,"Stabilization of unstable areas or ",{"$nulls":5},""]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[]
[null,null,".01","Provision and establishment of ",{"$nulls":4},{"$f":"IF(OR(AND(G196=\"Prov\",H196=\"Sum\"),(H196=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G196*H196),\"\",IF(G196*H196=0,\"\",ROUND(G196*H196,2))))","v":""}]
[{"$nulls":3},"equipment on site, and removal on ",{"$nulls":4},""]
[{"$nulls":3},"completion of operation",null,"sum",1,null,""]
[]
[null,null,".02","Operation of equipment ",null,"day",2,null,{"$f":"IF(OR(AND(G200=\"Prov\",H200=\"Sum\"),(H200=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G200*H200),\"\",IF(G200*H200=0,\"\",ROUND(G200*H200,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",34,null,""]
[]
["8.2.10",216.37,"Standing time for pipe jacking gang "]
[null,null,"and the jacking equipment covered "]
[null,null,"by item 216.31",null,null,"h",40]
[]
[null,null,"ROAD CROSSING:5"]
[{"$nulls":8},{"$f":"IF(OR(AND(G209=\"Prov\",H209=\"Sum\"),(H209=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G209*H209),\"\",IF(G209*H209=0,\"\",ROUND(G209*H209,2))))","v":""}]
["8.2.1",216.41,"Jacking establishment:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Fixed charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Time-related charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
["8.2.2",216.42,"Supply of pipes to be jacked:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to ",{"$nulls":4},""]
[{"$nulls":3},"SANS 677",null,"m",52,null,""]
[]
["8.2.3",216.43,"Jacking of pipes:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to ",{"$nulls":4},""]
[{"$nulls":3},"SANS 677",null,"m",52,null,""]
[]
["8.2.4",216.44,"Excavation for jacking:",{"$nulls":5},{"$f":"IF(OR(AND(G228=\"Prov\",H228=\"Sum\"),(H228=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G228*H228),\"\",IF(G228*H228=0,\"\",ROUND(G228*H228,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","Soft excavation          ",null,"m³",47,null,""]
[{"$nulls":8},""]
[null,null,".02","Intermediate excavation  ",null,"m³",23,null,""]
[{"$nulls":8},""]
[null,null,".03","Hard rock excavation     ",null,"m³",8,null,""]
[]
[]
[]
["1200 LG","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                 SECTION 1200 LG"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
["8.2.5",216.45,"Extra over items 216.41 and 216.44 for ",{"$nulls":5},{"$f":"IF(OR(AND(G250=\"Prov\",H250=\"Sum\"),(H250=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G250*H250),\"\",IF(G250*H250=0,\"\",ROUND(G250*H250,2))))","v":""}]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[]
["8.2.9",216.46,"Stabilization of unstable areas or ",{"$nulls":5},{"$f":"IF(OR(AND(G253=\"Prov\",H253=\"Sum\"),(H253=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G253*H253),\"\",IF(G253*H253=0,\"\",ROUND(G253*H253,2))))","v":""}]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[]
[null,null,".01","Provision and establishment of equipment on",{"$nulls":4},{"$f":"IF(OR(AND(G256=\"Prov\",H256=\"Sum\"),(H256=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G256*H256),\"\",IF(G256*H256=0,\"\",ROUND(G256*H256,2))))","v":""}]
[{"$nulls":3},"site, and removal on completion of operation",null,"sum",1]
[]
[null,null,".02","Operation of equipment ",null,"day",2,null,{"$f":"IF(OR(AND(G259=\"Prov\",H259=\"Sum\"),(H259=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G259*H259),\"\",IF(G259*H259=0,\"\",ROUND(G259*H259,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",36,null,""]
[]
["8.2.10",216.47,"Standing time for pipe jacking gang and the"]
[null,null,"jacking equipment covered by item 216.41",null,null,"h",40]
[]
[null,null,"ROAD CROSSING:6"]
[]
[null,"216.51","Jacking establishment:"]
[]
[null,null,".01","Fixed charges    ",null,"sum",1,null,{"$f":"IF(OR(AND(G270=\"Prov\",H270=\"Sum\"),(H270=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G270*H270),\"\",IF(G270*H270=0,\"\",ROUND(G270*H270,2))))","v":""}]
[]
[null,null,".02","Time-related charges    ",null,"sum",1,null,{"$f":"IF(OR(AND(G272=\"Prov\",H272=\"Sum\"),(H272=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G272*H272),\"\",IF(G272*H272=0,\"\",ROUND(G272*H272,2))))","v":""}]
[]
["8.2.2",216.52,"Supply of pipes to be jacked:"]
[]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve"]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",65]
[]
["8.2.3",216.53,"Jacking of pipes:",{"$nulls":5},{"$f":"IF(OR(AND(G279=\"Prov\",H279=\"Sum\"),(H279=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G279*H279),\"\",IF(G279*H279=0,\"\",ROUND(G279*H279,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",65]
[{"$nulls":8},""]
["8.2.4",216.54,"Excavation for jacking:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Soft excavation          ",null,"m³",60,null,""]
[{"$nulls":8},""]
[null,null,".02","Intermediate excavation  ",null,"m³",30,null,""]
[{"$nulls":8},""]
[null,null,".03","Hard rock excavation     ",null,"m³",10,null,""]
[]
["8.2.5",216.55,"Extra over items 216.51 and 216.54 for ",{"$nulls":5},{"$f":"IF(OR(AND(G292=\"Prov\",H292=\"Sum\"),(H292=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G292*H292),\"\",IF(G292*H292=0,\"\",ROUND(G292*H292,2))))","v":""}]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[{"$nulls":8},{"$f":"IF(OR(AND(G294=\"Prov\",H294=\"Sum\"),(H294=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G294*H294),\"\",IF(G294*H294=0,\"\",ROUND(G294*H294,2))))","v":""}]
["8.2.9",216.56,"Stabilization of unstable areas or ",{"$nulls":5},""]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Provision and establishment of equipment on ",{"$nulls":4},""]
[{"$nulls":3},"site, and removal on completion of operation",null,"sum",1]
[{"$nulls":8},""]
[null,null,".02","Operation of equipment ",null,"day",10,null,""]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",38,null,""]
[]
["8.2.10",216.57,"Standing time for pipe jacking gang and the"]
[null,null,"jacking equipment covered by item 216.51",null,null,"h",40]
[]
[null,null,"ROAD CROSSING:8"]
[]
["8.2.1",216.61,"Jacking establishment:"]
[]
[null,null,".01","Fixed charges    ",null,"sum",1,null,{"$f":"IF(OR(AND(G312=\"Prov\",H312=\"Sum\"),(H312=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G312*H312),\"\",IF(G312*H312=0,\"\",ROUND(G312*H312,2))))","v":""}]
[]
[null,null,".02","Time-related charges    ",null,"sum",1,null,{"$f":"IF(OR(AND(G314=\"Prov\",H314=\"Sum\"),(H314=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G314*H314),\"\",IF(G314*H314=0,\"\",ROUND(G314*H314,2))))","v":""}]
[]
[]
[]
["1200 LG","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                 SECTION 1200 LG"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G329=\"Prov\",H329=\"Sum\"),(H329=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G329*H329),\"\",IF(G329*H329=0,\"\",ROUND(G329*H329,2))))","v":""}]
["8.2.2",216.62,"Supply of pipes to be jacked:"]
[]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve"]
[{"$nulls":3},"pipe (in-the-wall joint), according to "]
[{"$nulls":3},"SANS 677",null,"m",61,null,{"$f":"IF(OR(AND(G334=\"Prov\",H334=\"Sum\"),(H334=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G334*H334),\"\",IF(G334*H334=0,\"\",ROUND(G334*H334,2))))","v":""}]
[]
["8.2.3",216.63,"Jacking of pipes:"]
[]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve"]
[{"$nulls":3},"pipe (in-the-wall joint), according to "]
[{"$nulls":3},"SANS 677",null,"m",61,null,{"$f":"IF(OR(AND(G340=\"Prov\",H340=\"Sum\"),(H340=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G340*H340),\"\",IF(G340*H340=0,\"\",ROUND(G340*H340,2))))","v":""}]
[]
["8.2.4",216.64,"Excavation for jacking:"]
[]
[null,null,".01","Soft excavation          ",null,"m³",55,null,{"$f":"IF(OR(AND(G344=\"Prov\",H344=\"Sum\"),(H344=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G344*H344),\"\",IF(G344*H344=0,\"\",ROUND(G344*H344,2))))","v":""}]
[]
[null,null,".02","Intermediate excavation  ",null,"m³",27,null,{"$f":"IF(OR(AND(G346=\"Prov\",H346=\"Sum\"),(H346=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G346*H346),\"\",IF(G346*H346=0,\"\",ROUND(G346*H346,2))))","v":""}]
[]
[null,null,".03","Hard rock excavation     ",null,"m³",9,null,{"$f":"IF(OR(AND(G348=\"Prov\",H348=\"Sum\"),(H348=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G348*H348),\"\",IF(G348*H348=0,\"\",ROUND(G348*H348,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G349=\"Prov\",H349=\"Sum\"),(H349=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G349*H349),\"\",IF(G349*H349=0,\"\",ROUND(G349*H349,2))))","v":""}]
["8.2.5",216.65,"Extra over items 216.61 and 216.64 for ",{"$nulls":5},""]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[{"$nulls":8},{"$f":"IF(OR(AND(G352=\"Prov\",H352=\"Sum\"),(H352=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G352*H352),\"\",IF(G352*H352=0,\"\",ROUND(G352*H352,2))))","v":""}]
["8.2.9",216.66,"Stabilization of unstable areas or ",{"$nulls":5},""]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Provision and establishment of ",{"$nulls":4},""]
[{"$nulls":3},"equipment on site, and removal on ",{"$nulls":4},""]
[{"$nulls":3},"completion of operation",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Operation of equipment ",null,"day",2,null,""]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",{"v":34.92,"d":"35"},null,""]
[{"$nulls":8},""]
["8.2.10",216.67,"Standing time for pipe jacking gang ",{"$nulls":5},""]
[null,null,"and the jacking equipment covered ",{"$nulls":5},""]
[null,null,"by item 216.61",null,null,"h",40]
[]
[null,null,"ROAD CROSSING:9 (N1 Crossing)"]
[]
[null,null,"Appointment of a specialist jacking contractor for the "]
[null,null,"full N1 Crossing jacking scope of 3000 mm dia x"]
[null,null,"2500 mm dia x 275 mm thick concrete box culverts."]
[null,null,"Complete inlcuding pre-casting of culverts units on"]
[null,null,"site as well as trust and reception pits",null,null,"Prov sum",1,{"v":12650000,"d":"12,650,000.00"},{"$f":"G374*H374","v":{"v":12650000,"d":"12,650,000.00"}}]
[]
[null,null,"Overheads, charges and profit on subitem above",null,null,"%",{"v":12650000,"d":"12,650,000"},{"v":0.1,"d":"10%"},{"$f":"IF(OR(AND(G376=\"Prov\",H376=\"Sum\"),(H376=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G376*H376),\"\",IF(G376*H376=0,\"\",ROUND(G376*H376,2))))","v":{"v":1265000,"d":"1,265,000.00"}}]
[]
["8.2.1",216.71,"Jacking establishment:",{"$nulls":5},{"$f":"IF(OR(AND(G378=\"Prov\",H378=\"Sum\"),(H378=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G378*H378),\"\",IF(G378*H378=0,\"\",ROUND(G378*H378,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","Fixed charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Time-related charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
["8.2.2",216.72,"Supply of culverts to be jacked:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","3000 mm dia x 2500 mm dia x 275mm thick, ",{"$nulls":4},""]
[{"$nulls":3},"concrete jacking box culvert with bolts",{"$nulls":4},""]
[{"$nulls":3},"holes for longitudinal ties interlocking joint",null,"m",83,null,""]
{"$rows_empty":10}
[{"$nulls":8},{"$f":"IF(OR(AND(G399=\"Prov\",H399=\"Sum\"),(H399=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G399*H399),\"\",IF(G399*H399=0,\"\",ROUND(G399*H399,2))))","v":""}]
[]
["1200 LG","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                 SECTION 1200 LG"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
["8.2.3",216.73,"Jacking of culverts:"]
[]
[null,null,".01","3000 mm dia x 2500 mm dia x 275mm thick, "]
[{"$nulls":3},"concrete jacking box culvert with bolts"]
[{"$nulls":3},"holes for longitudinal ties interlocking joint,"]
[{"$nulls":3},"including but not limited to drag sheet"]
[{"$nulls":3},"inserted in slots on jacking shield",null,"m",83]
[]
["8.2.4",216.74,"Excavation for jacking:"]
[]
[null,null,".01","Soft excavation          ",null,"m³",709]
[]
[null,null,".02","Intermediate excavation  ",null,"m³",285]
[]
[null,null,".03","Hard rock excavation     ",null,"m³",95]
[]
["8.2.5",216.75,"Extra over items 216.71 and 216.74 for "]
[null,null,"unforeseen rock or boulders  ",null,null,"Sum",1]
[]
["8.2.9",216.76,"Stabilization of unstable areas or grouting of ",{"$nulls":5},{"$f":"IF(OR(AND(G432=\"Prov\",H432=\"Sum\"),(H432=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G432*H432),\"\",IF(G432*H432=0,\"\",ROUND(G432*H432,2))))","v":""}]
[null,null,"voids where ordered:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Provision and establishment of equipment on",{"$nulls":4},""]
[{"$nulls":3},"site, and removal on completion of operation",null,"sum",1]
[{"$nulls":8},""]
[null,null,".02","Operation of equipment ",null,"day",40,null,""]
[]
[null,null,".03","Grouting to voids with cement/bentonite mix",null,"m³",93,null,{"$f":"IF(OR(AND(G440=\"Prov\",H440=\"Sum\"),(H440=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G440*H440),\"\",IF(G440*H440=0,\"\",ROUND(G440*H440,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",163,null,""]
[{"$nulls":8},""]
["8.2.10",216.77,"Standing time for pipe jacking gang and the ",{"$nulls":5},""]
[null,null,"jacking equipment covered by item 216.71",null,null,"h",120]
[]
[null,216.78,"Miscellaneous"]
[]
[null,null,".01","Risk allowance for potential cracking of road",null,"sum",1]
[]
[null,null,"ROAD CROSSING:10"]
[{"$nulls":8},{"$f":"IF(OR(AND(G452=\"Prov\",H452=\"Sum\"),(H452=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G452*H452),\"\",IF(G452*H452=0,\"\",ROUND(G452*H452,2))))","v":""}]
["8.2.1",216.81,"Jacking establishment:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Fixed charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Time-related charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
["8.2.2",216.82,"Supply of pipes to be jacked:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",39]
[{"$nulls":8},""]
["8.2.3",216.83,"Jacking of pipes:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",39]
[]
["8.2.4",216.84,"Excavation for jacking:",{"$nulls":5},{"$f":"IF(OR(AND(G469=\"Prov\",H469=\"Sum\"),(H469=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G469*H469),\"\",IF(G469*H469=0,\"\",ROUND(G469*H469,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","Soft excavation          ",null,"m³",35,null,""]
[]
[null,null,".02","Intermediate excavation  ",null,"m³",17,null,{"$f":"IF(OR(AND(G473=\"Prov\",H473=\"Sum\"),(H473=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G473*H473),\"\",IF(G473*H473=0,\"\",ROUND(G473*H473,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".03","Hard rock excavation     ",null,"m³",6,null,""]
[]
[]
["1200 LG","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                 SECTION 1200 LG"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
["8.2.5",216.85,"Extra over items 216.01 and 216.04 for ",{"$nulls":5},{"$f":"IF(OR(AND(G490=\"Prov\",H490=\"Sum\"),(H490=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G490*H490),\"\",IF(G490*H490=0,\"\",ROUND(G490*H490,2))))","v":""}]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"$f":"IF(OR(AND(G491=\"Prov\",H491=\"Sum\"),(H491=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G491*H491),\"\",IF(G491*H491=0,\"\",ROUND(G491*H491,2))))","v":{"v":20000,"d":"20,000.00"}}]
[]
["8.2.9",216.86,"Stabilization of unstable areas or ",{"$nulls":5},{"$f":"IF(OR(AND(G493=\"Prov\",H493=\"Sum\"),(H493=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G493*H493),\"\",IF(G493*H493=0,\"\",ROUND(G493*H493,2))))","v":""}]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Provision and establishment of equipment on",{"$nulls":4},""]
[{"$nulls":3},"site, and removal on completion of operation",null,"sum",1]
[]
[null,null,".02","Operation of equipment ",null,"day",2,null,{"$f":"IF(OR(AND(G499=\"Prov\",H499=\"Sum\"),(H499=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G499*H499),\"\",IF(G499*H499=0,\"\",ROUND(G499*H499,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",22,null,""]
[{"$nulls":8},""]
["8.2.10",216.87,"Standing time for pipe jacking gang and the ",{"$nulls":5},""]
[null,null,"jacking equipment covered by item 216.81",null,null,"h",40]
[]
[null,null,"ROAD CROSSING:11"]
[{"$nulls":8},{"$f":"IF(OR(AND(G507=\"Prov\",H507=\"Sum\"),(H507=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G507*H507),\"\",IF(G507*H507=0,\"\",ROUND(G507*H507,2))))","v":""}]
["8.2.1",216.91,"Jacking establishment:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Fixed charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Time-related charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
["8.2.2",216.92,"Supply of pipes to be jacked:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",45]
[]
["8.2.3",216.93,"Jacking of pipes:",{"$nulls":5},{"$f":"IF(OR(AND(G519=\"Prov\",H519=\"Sum\"),(H519=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G519*H519),\"\",IF(G519*H519=0,\"\",ROUND(G519*H519,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",45]
[]
["8.2.4",216.94,"Excavation for jacking:",{"$nulls":5},{"$f":"IF(OR(AND(G524=\"Prov\",H524=\"Sum\"),(H524=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G524*H524),\"\",IF(G524*H524=0,\"\",ROUND(G524*H524,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","Soft excavation          ",null,"m³",41,null,""]
[{"$nulls":8},""]
[null,null,".02","Intermediate excavation  ",null,"m³",20,null,""]
[{"$nulls":8},""]
[null,null,".03","Hard rock excavation     ",null,"m³",7,null,""]
[{"$nulls":8},""]
["8.2.5",216.95,"Extra over items 216.91 and 216.94 for ",{"$nulls":5},""]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[]
["8.2.9",216.96,"Stabilization of unstable areas or ",{"$nulls":5},{"$f":"IF(OR(AND(G535=\"Prov\",H535=\"Sum\"),(H535=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G535*H535),\"\",IF(G535*H535=0,\"\",ROUND(G535*H535,2))))","v":""}]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Provision and establishment of equipment on",{"$nulls":4},""]
[{"$nulls":3},"site, and removal on completion of operation",null,"sum",1]
[{"$nulls":8},""]
[null,null,".02","Operation of equipment ",null,"day",2,null,""]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",26,null,""]
[]
["8.2.10",216.97,"Standing time for pipe jacking gang and the"]
[null,null,"jacking equipment covered by item 216.91",null,null,"h",40]
{"$rows_empty":7}
["1200 LG","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                 SECTION 1200 LG"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G565=\"Prov\",H565=\"Sum\"),(H565=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G565*H565),\"\",IF(G565*H565=0,\"\",ROUND(G565*H565,2))))","v":""}]
[null,null,"ROAD CROSSING:12"]
[{"$nulls":8},{"$f":"IF(OR(AND(G567=\"Prov\",H567=\"Sum\"),(H567=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G567*H567),\"\",IF(G567*H567=0,\"\",ROUND(G567*H567,2))))","v":""}]
["8.2.1",217.01,"Jacking establishment:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Fixed charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Time-related charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
["8.2.2",217.02,"Supply of pipes to be jacked:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",30]
[]
["8.2.3",217.03,"Jacking of pipes:",{"$nulls":5},{"$f":"IF(OR(AND(G579=\"Prov\",H579=\"Sum\"),(H579=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G579*H579),\"\",IF(G579*H579=0,\"\",ROUND(G579*H579,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",30]
[]
["8.2.4",217.04,"Excavation for jacking:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Soft excavation          ",null,"m³",18,null,""]
[{"$nulls":8},""]
[null,null,".02","Intermediate excavation  ",null,"m³",13,null,""]
[{"$nulls":8},""]
[null,null,".03","Hard rock excavation     ",null,"m³",4,null,""]
[]
["8.2.5",217.05,"Extra over items 217.01 and 217.04 for ",{"$nulls":5},{"$f":"IF(OR(AND(G592=\"Prov\",H592=\"Sum\"),(H592=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G592*H592),\"\",IF(G592*H592=0,\"\",ROUND(G592*H592,2))))","v":""}]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[]
["8.2.9",217.06,"Stabilization of unstable areas or ",{"$nulls":5},{"$f":"IF(OR(AND(G595=\"Prov\",H595=\"Sum\"),(H595=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G595*H595),\"\",IF(G595*H595=0,\"\",ROUND(G595*H595,2))))","v":""}]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Provision and establishment of equipment on",{"$nulls":4},""]
[{"$nulls":3},"site, and removal on completion of operation",null,"sum",1]
[{"$nulls":8},""]
[null,null,".02","Operation of equipment ",null,"day",2,null,""]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",21,null,""]
[]
["8.2.10",217.07,"Standing time for pipe jacking gang and the "]
[null,null,"jacking equipment covered by item 217.01",null,null,"h",40]
[]
[null,null,"ROAD CROSSING:13"]
[{"$nulls":8},{"$f":"IF(OR(AND(G609=\"Prov\",H609=\"Sum\"),(H609=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G609*H609),\"\",IF(G609*H609=0,\"\",ROUND(G609*H609,2))))","v":""}]
["8.2.1",217.21,"Jacking establishment:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Fixed charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
[null,null,".02","Time-related charges    ",null,"sum",1,null,""]
[{"$nulls":8},""]
["8.2.2",217.22,"Supply of pipes to be jacked:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",55]
[]
["8.2.3",217.23,"Jacking of pipes:",{"$nulls":5},{"$f":"IF(OR(AND(G621=\"Prov\",H621=\"Sum\"),(H621=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G621*H621),\"\",IF(G621*H621=0,\"\",ROUND(G621*H621,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","1 371 mm dia (OD), 100D concrete sleeve",{"$nulls":4},""]
[{"$nulls":3},"pipe (in-the-wall joint), according to SANS 677",null,"m",55]
[]
[]
[]
[]
[]
["1200 LG","Carried forward"]
[]
[]
[]
[{"$nulls":8},"                 SECTION 1200 LG"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G641=\"Prov\",H641=\"Sum\"),(H641=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G641*H641),\"\",IF(G641*H641=0,\"\",ROUND(G641*H641,2))))","v":""}]
["8.2.4",217.24,"Excavation for jacking:",{"$nulls":5},{"$f":"IF(OR(AND(G642=\"Prov\",H642=\"Sum\"),(H642=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G642*H642),\"\",IF(G642*H642=0,\"\",ROUND(G642*H642,2))))","v":""}]
[{"$nulls":8},""]
[null,null,".01","Soft excavation          ",null,"m³",50,null,""]
[{"$nulls":8},""]
[null,null,".02","Intermediate excavation  ",null,"m³",24,null,""]
[{"$nulls":8},""]
[null,null,".03","Hard rock excavation     ",null,"m³",8,null,""]
[]
["8.2.5",217.25,"Extra over items 217.21 and 217.24 for ",{"$nulls":5},{"$f":"IF(OR(AND(G650=\"Prov\",H650=\"Sum\"),(H650=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G650*H650),\"\",IF(G650*H650=0,\"\",ROUND(G650*H650,2))))","v":""}]
[null,null,"unforeseen rock or boulders  ",null,null,"Prov sum",1,{"v":20000,"d":"20,000.00"},{"v":20000,"d":"20,000.00"}]
[]
["8.2.9",217.26,"Stabilization of unstable areas or ",{"$nulls":5},{"$f":"IF(OR(AND(G653=\"Prov\",H653=\"Sum\"),(H653=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G653*H653),\"\",IF(G653*H653=0,\"\",ROUND(G653*H653,2))))","v":""}]
[null,null,"grouting of voids where ordered:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Provision and establishment of equipment on ",{"$nulls":4},""]
[{"$nulls":3},"site, and removal on completion of operation",null,"sum",1]
[{"$nulls":8},""]
[null,null,".02","Operation of equipment ",null,"day",2,null,""]
[{"$nulls":8},""]
[null,null,".03","Materials used    ",null,"m³",38,null,""]
[]
["8.2.10",217.27,"Standing time for pipe jacking gang "]
[null,null,"and the jacking equipment covered "]
[null,null,"by item 217.21",null,null,"h",40]
[]
[]
["SANS ",217.28,"Brickwork:"]
["1200LE"]
["8.2.9",null,".01","230mm Thick engineering bricks",null,"m²",35]
{"$rows_empty":33}
[{"$nulls":8},{"$f":"IF(OR(AND(G704=\"Prov\",H704=\"Sum\"),(H704=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G704*H704),\"\",IF(G704*H704=0,\"\",ROUND(G704*H704,2))))","v":""}]
[]
[null,"TOTAL SECTION 1200 LG CARRIED TO SUMMARY"]

{"sheet":"1200ME","index":12,"n_rows":80,"n_cols":9,"rows_kept":80}
[]
[{"$nulls":8},"                 SECTION 1200 ME"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SABS","223.00","SUBBASE",{"$nulls":5},""]
["1200 ME",{"$nulls":7},""]
[{"$nulls":8},""]
["PSDM 8.3.3",223.01,"Treatment of roadbed ",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"Roadbed preparation and compaction of ",{"$nulls":5},""]
[null,null,"material to (Rip and compact in-situ) :",{"$nulls":5},""]
[{"$nulls":8},""]
["PSME 8.3.3",223.02,".01","Minimum of 90% of modified AASHTO ",{"$nulls":4},""]
[{"$nulls":3},"maximum density ",null,"m³",{"v":20,"d":"20 "},null,""]
[{"$nulls":8},""]
[{"$nulls":8},""]
["PSME",223.03,"Construct the subbase course with ",{"$nulls":5},""]
["8.3.3",null,"material from commercial sources      ",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","G5 material compacted to 97% ",{"$nulls":4},""]
[{"$nulls":3}," modified AASHTO",null,"m³",{"v":20,"d":"20 "},null,""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
{"$rows_empty":16}
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[]
[]
[]
[]
[]
[]
[{"$nulls":8},""]
[]
[null,"TOTAL SECTION 1200 ME CARRIED TO SUMMARY"]

{"sheet":"1200MF ","index":13,"n_rows":82,"n_cols":9,"rows_kept":82}
[]
[{"$nulls":8},"                 SECTION 1200 MF"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["SANS","224.00","BASE",{"$nulls":5},""]
["1200 MF",{"$nulls":7},""]
[{"$nulls":8},""]
["8.3.3",224.01,"Construct base with material from ",{"$nulls":5},""]
[null,null,"commercial sources or designated ",{"$nulls":5},""]
[null,null,"borrow areas:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Graded crushed stone     ",null,"m³",14,null,""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G36=\"Prov\",H36=\"Sum\"),(H36=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G36*H36),\"\",IF(G36*H36=0,\"\",ROUND(G36*H36,2))))","v":""}]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
{"$rows_empty":26}
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[]
[null,"TOTAL SECTION 1200 MF CARRIED TO SUMMARY"]

{"sheet":"PART PC","index":14,"n_rows":306,"n_cols":12,"rows_kept":306}
[]
[{"$nulls":8},"             PARTICULAR SPECIFICATION PC"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["PART PC","PC 10","DIRECTIONAL DRILLING",{"$nulls":5},{"$f":"IF(OR(AND(G8=\"Prov\",H8=\"Sum\"),(H8=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G8*H8),\"\",IF(G8*H8=0,\"\",ROUND(G8*H8,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G9=\"Prov\",H9=\"Sum\"),(H9=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G9*H9),\"\",IF(G9*H9=0,\"\",ROUND(G9*H9,2))))","v":""}]
[null,null,"DRILLING: ROAD CROSSING 2"]
[]
[null,"PC.11","Design and site establishment",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G12=\"Prov\",H12=\"Sum\"),(H12=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G12*H12),\"\",IF(G12*H12=0,\"\",ROUND(G12*H12,2))))","v":""}]
[]
[null,"PC.12","Temporary works for directional drilling",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G14=\"Prov\",H14=\"Sum\"),(H14=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G14*H14),\"\",IF(G14*H14=0,\"\",ROUND(G14*H14,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G15=\"Prov\",H15=\"Sum\"),(H15=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G15*H15),\"\",IF(G15*H15=0,\"\",ROUND(G15*H15,2))))","v":""}]
[null,"PC.13","Directional drilling and installation of "]
[null,null,"pipe or cable sleeve:",{"$nulls":5},{"$f":"IF(OR(AND(G17=\"Prov\",H17=\"Sum\"),(H17=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G17*H17),\"\",IF(G17*H17=0,\"\",ROUND(G17*H17,2))))","v":""}]
[]
[null,null,".01","630 mm dia hdpe pipe",null,"m",46,null,{"$f":"IF(OR(AND(G19=\"Prov\",H19=\"Sum\"),(H19=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G19*H19),\"\",IF(G19*H19=0,\"\",ROUND(G19*H19,2))))","v":""}]
[]
[null,"PC.14","Extra over items PC 12 and PC 13 for "]
[null,null,"unforeseen rock or boulders ",null,null,"m³",14]
[{"$nulls":8},{"$f":"IF(OR(AND(G23=\"Prov\",H23=\"Sum\"),(H23=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G23*H23),\"\",IF(G23*H23=0,\"\",ROUND(G23*H23,2))))","v":""}]
[null,"PC.16","De-establish quipment on site",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G24=\"Prov\",H24=\"Sum\"),(H24=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G24*H24),\"\",IF(G24*H24=0,\"\",ROUND(G24*H24,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G25=\"Prov\",H25=\"Sum\"),(H25=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G25*H25),\"\",IF(G25*H25=0,\"\",ROUND(G25*H25,2))))","v":""}]
[null,"PC.17","Standing time for directional drilling ",{"$nulls":5},{"$f":"IF(OR(AND(G26=\"Prov\",H26=\"Sum\"),(H26=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G26*H26),\"\",IF(G26*H26=0,\"\",ROUND(G26*H26,2))))","v":""}]
[null,null,"team and equipment",null,null,"h",40]
[]
[null,"PC.18","Stabilization of unstable areas or "]
[null,null,"grouting of voids where ordered:"]
[]
[null,null,".01","Provision and establishment of equipment on "]
[{"$nulls":3},"Site, and removal on completion of operation",null,"sum  ",1]
[{"$nulls":8},{"$f":"IF(OR(AND(G34=\"Prov\",H34=\"Sum\"),(H34=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G34*H34),\"\",IF(G34*H34=0,\"\",ROUND(G34*H34,2))))","v":""}]
[null,null,".02","Operation of equipment ",null,"day",10,null,{"$f":"IF(OR(AND(G35=\"Prov\",H35=\"Sum\"),(H35=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G35*H35),\"\",IF(G35*H35=0,\"\",ROUND(G35*H35,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G36=\"Prov\",H36=\"Sum\"),(H36=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G36*H36),\"\",IF(G36*H36=0,\"\",ROUND(G36*H36,2))))","v":""}]
[null,null,".03","Materials used    ",null,"m³",10,null,{"$f":"IF(OR(AND(G37=\"Prov\",H37=\"Sum\"),(H37=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G37*H37),\"\",IF(G37*H37=0,\"\",ROUND(G37*H37,2))))","v":""}]
[]
[null,"PC 20","DIRECTIONAL DRILLING",{"$nulls":5},{"$f":"IF(OR(AND(G39=\"Prov\",H39=\"Sum\"),(H39=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G39*H39),\"\",IF(G39*H39=0,\"\",ROUND(G39*H39,2))))","v":""}]
[]
[null,null,"DRILLING: ROAD CROSSING 3"]
[]
[null,"PC.21","Design and site establishment",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G43=\"Prov\",H43=\"Sum\"),(H43=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G43*H43),\"\",IF(G43*H43=0,\"\",ROUND(G43*H43,2))))","v":""}]
[]
[null,"PC.22","Temporary works for directional drilling",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G45=\"Prov\",H45=\"Sum\"),(H45=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G45*H45),\"\",IF(G45*H45=0,\"\",ROUND(G45*H45,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G46=\"Prov\",H46=\"Sum\"),(H46=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G46*H46),\"\",IF(G46*H46=0,\"\",ROUND(G46*H46,2))))","v":""}]
[null,"PC.23","Directional drilling and installation of ",{"$nulls":5},{"$f":"IF(OR(AND(G47=\"Prov\",H47=\"Sum\"),(H47=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G47*H47),\"\",IF(G47*H47=0,\"\",ROUND(G47*H47,2))))","v":""}]
[null,null,"pipe or cable sleeve:"]
[{"$nulls":8},{"$f":"IF(OR(AND(G49=\"Prov\",H49=\"Sum\"),(H49=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G49*H49),\"\",IF(G49*H49=0,\"\",ROUND(G49*H49,2))))","v":""}]
[null,null,".01","630 mm dia hdpe pipe",null,"m",62,null,{"$f":"IF(OR(AND(G50=\"Prov\",H50=\"Sum\"),(H50=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G50*H50),\"\",IF(G50*H50=0,\"\",ROUND(G50*H50,2))))","v":""}]
[]
[null,"PC.24","Extra over items PC 22 and PC 23 for "]
[null,null,"unforeseen rock or boulders ",null,null,"m³",19,null,{"$f":"IF(OR(AND(G53=\"Prov\",H53=\"Sum\"),(H53=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G53*H53),\"\",IF(G53*H53=0,\"\",ROUND(G53*H53,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G54=\"Prov\",H54=\"Sum\"),(H54=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G54*H54),\"\",IF(G54*H54=0,\"\",ROUND(G54*H54,2))))","v":""}]
[null,"PC.26","De-establish quipment on site",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G55=\"Prov\",H55=\"Sum\"),(H55=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G55*H55),\"\",IF(G55*H55=0,\"\",ROUND(G55*H55,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G56=\"Prov\",H56=\"Sum\"),(H56=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G56*H56),\"\",IF(G56*H56=0,\"\",ROUND(G56*H56,2))))","v":""}]
[null,"PC.27","Standing time for directional drilling "]
[null,null,"team and equipment",null,null,"h",40]
[]
[null,"PC.28","Stabilization of unstable areas or "]
[null,null,"grouting of voids where ordered:"]
[]
[null,null,".01","Provision and establishment of equipment on "]
[{"$nulls":3},"Site, and removal on completion of operation",null,"sum  ",1]
[]
[null,null,".02","Operation of equipment ",null,"day",10]
[]
[null,null,".03","Materials used    ",null,"m³",10]
{"$rows_empty":7}
["PART PC","Carried forward"]
[]
[]
[{"$nulls":8},"             PARTICULAR SPECIFICATION PC"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[]
[null,"PC 30","DIRECTIONAL DRILLING",{"$nulls":5},{"$f":"IF(OR(AND(G88=\"Prov\",H88=\"Sum\"),(H88=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G88*H88),\"\",IF(G88*H88=0,\"\",ROUND(G88*H88,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G89=\"Prov\",H89=\"Sum\"),(H89=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G89*H89),\"\",IF(G89*H89=0,\"\",ROUND(G89*H89,2))))","v":""}]
[null,null,"DRILLING: ROAD CROSSING 4"]
[]
[null,"PC.31","Design and site establishment",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G92=\"Prov\",H92=\"Sum\"),(H92=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G92*H92),\"\",IF(G92*H92=0,\"\",ROUND(G92*H92,2))))","v":""}]
[]
[null,"PC.32","Temporary works for directional drilling",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G94=\"Prov\",H94=\"Sum\"),(H94=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G94*H94),\"\",IF(G94*H94=0,\"\",ROUND(G94*H94,2))))","v":""}]
[]
[null,"PC.33","Directional drilling and installation of "]
[null,null,"pipe or cable sleeve:",{"$nulls":5},{"$f":"IF(OR(AND(G97=\"Prov\",H97=\"Sum\"),(H97=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G97*H97),\"\",IF(G97*H97=0,\"\",ROUND(G97*H97,2))))","v":""}]
[]
[null,null,".01","630 mm dia hdpe pipe",null,"m",49,null,{"$f":"IF(OR(AND(G99=\"Prov\",H99=\"Sum\"),(H99=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G99*H99),\"\",IF(G99*H99=0,\"\",ROUND(G99*H99,2))))","v":""}]
[]
[null,"PC.34","Extra over items PC 32 and PC 33 for "]
[null,null,"unforeseen rock or boulders ",null,null,"m³",15,null,{"$f":"IF(OR(AND(G102=\"Prov\",H102=\"Sum\"),(H102=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G102*H102),\"\",IF(G102*H102=0,\"\",ROUND(G102*H102,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G103=\"Prov\",H103=\"Sum\"),(H103=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G103*H103),\"\",IF(G103*H103=0,\"\",ROUND(G103*H103,2))))","v":""}]
[null,"PC.36","De-establish quipment on site",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G104=\"Prov\",H104=\"Sum\"),(H104=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G104*H104),\"\",IF(G104*H104=0,\"\",ROUND(G104*H104,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G105=\"Prov\",H105=\"Sum\"),(H105=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G105*H105),\"\",IF(G105*H105=0,\"\",ROUND(G105*H105,2))))","v":""}]
[null,"PC.37","Standing time for directional drilling ",{"$nulls":5},{"$f":"IF(OR(AND(G106=\"Prov\",H106=\"Sum\"),(H106=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G106*H106),\"\",IF(G106*H106=0,\"\",ROUND(G106*H106,2))))","v":""}]
[null,null,"team and equipment",null,null,"h",40]
[]
[null,"PC.38","Stabilization of unstable areas or "]
[null,null,"grouting of voids where ordered:"]
[]
[null,null,".01","Provision and establishment of equipment on "]
[{"$nulls":3},"Site, and removal on completion of operation",null,"sum  ",1]
[{"$nulls":8},{"$f":"IF(OR(AND(G114=\"Prov\",H114=\"Sum\"),(H114=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G114*H114),\"\",IF(G114*H114=0,\"\",ROUND(G114*H114,2))))","v":""}]
[null,null,".02","Operation of equipment ",null,"day",10,null,{"$f":"IF(OR(AND(G115=\"Prov\",H115=\"Sum\"),(H115=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G115*H115),\"\",IF(G115*H115=0,\"\",ROUND(G115*H115,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G116=\"Prov\",H116=\"Sum\"),(H116=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G116*H116),\"\",IF(G116*H116=0,\"\",ROUND(G116*H116,2))))","v":""}]
[null,null,".03","Materials used    ",null,"m³",10,null,{"$f":"IF(OR(AND(G117=\"Prov\",H117=\"Sum\"),(H117=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G117*H117),\"\",IF(G117*H117=0,\"\",ROUND(G117*H117,2))))","v":""}]
[]
[null,"PC 40","DIRECTIONAL DRILLING",{"$nulls":5},{"$f":"IF(OR(AND(G119=\"Prov\",H119=\"Sum\"),(H119=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G119*H119),\"\",IF(G119*H119=0,\"\",ROUND(G119*H119,2))))","v":""}]
[]
[null,null,"DRILLING: ROAD CROSSING 5"]
[]
[null,"PC.41","Design and site establishment",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G123=\"Prov\",H123=\"Sum\"),(H123=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G123*H123),\"\",IF(G123*H123=0,\"\",ROUND(G123*H123,2))))","v":""}]
[]
[null,"PC.42","Temporary works for directional drilling",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G125=\"Prov\",H125=\"Sum\"),(H125=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G125*H125),\"\",IF(G125*H125=0,\"\",ROUND(G125*H125,2))))","v":""}]
[]
[null,"PC.43","Directional drilling and installation of ",{"$nulls":5},{"$f":"IF(OR(AND(G127=\"Prov\",H127=\"Sum\"),(H127=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G127*H127),\"\",IF(G127*H127=0,\"\",ROUND(G127*H127,2))))","v":""}]
[null,null,"pipe or cable sleeve:"]
[{"$nulls":8},{"$f":"IF(OR(AND(G129=\"Prov\",H129=\"Sum\"),(H129=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G129*H129),\"\",IF(G129*H129=0,\"\",ROUND(G129*H129,2))))","v":""}]
[null,null,".01","630 mm dia hdpe pipe",null,"m",52,null,{"$f":"IF(OR(AND(G130=\"Prov\",H130=\"Sum\"),(H130=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G130*H130),\"\",IF(G130*H130=0,\"\",ROUND(G130*H130,2))))","v":""}]
[]
[null,"PC.44","Extra over items PC 42 and PC 43 for "]
[null,null,"unforeseen rock or boulders ",null,null,"m³",16,null,{"$f":"IF(OR(AND(G133=\"Prov\",H133=\"Sum\"),(H133=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G133*H133),\"\",IF(G133*H133=0,\"\",ROUND(G133*H133,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G134=\"Prov\",H134=\"Sum\"),(H134=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G134*H134),\"\",IF(G134*H134=0,\"\",ROUND(G134*H134,2))))","v":""}]
[null,"PC.46","De-establish quipment on site",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G135=\"Prov\",H135=\"Sum\"),(H135=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G135*H135),\"\",IF(G135*H135=0,\"\",ROUND(G135*H135,2))))","v":""}]
[]
[null,"PC.47","Standing time for directional drilling "]
[null,null,"team and equipment",null,null,"h",40]
[]
[null,"PC.48","Stabilization of unstable areas or "]
[null,null,"grouting of voids where ordered:"]
[]
[null,null,".01","Provision and establishment of "]
[{"$nulls":3},"equipment on Site, and removal on "]
[{"$nulls":3},"completion of operation",null,"sum  ",1]
[]
[null,null,".02","Operation of equipment ",null,"day",10]
[]
[null,null,".03","Materials used    ",null,"m³",10]
[{"$nulls":8},{"$f":"IF(OR(AND(G150=\"Prov\",H150=\"Sum\"),(H150=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G150*H150),\"\",IF(G150*H150=0,\"\",ROUND(G150*H150,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G151=\"Prov\",H151=\"Sum\"),(H151=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G151*H151),\"\",IF(G151*H151=0,\"\",ROUND(G151*H151,2))))","v":""}]
[]
["PART PC","Carried forward"]
[]
[]
[]
[{"$nulls":8},"             PARTICULAR SPECIFICATION PC"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G164=\"Prov\",H164=\"Sum\"),(H164=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G164*H164),\"\",IF(G164*H164=0,\"\",ROUND(G164*H164,2))))","v":""}]
[null,"PC 50","DIRECTIONAL DRILLING",{"$nulls":5},{"$f":"IF(OR(AND(G165=\"Prov\",H165=\"Sum\"),(H165=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G165*H165),\"\",IF(G165*H165=0,\"\",ROUND(G165*H165,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G166=\"Prov\",H166=\"Sum\"),(H166=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G166*H166),\"\",IF(G166*H166=0,\"\",ROUND(G166*H166,2))))","v":""}]
[null,null,"DRILLING: ROAD CROSSING 10"]
[]
[null,"PC.51","Design and site establishment",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G169=\"Prov\",H169=\"Sum\"),(H169=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G169*H169),\"\",IF(G169*H169=0,\"\",ROUND(G169*H169,2))))","v":""}]
[]
[null,"PC.52","Temporary works for directional drilling",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G171=\"Prov\",H171=\"Sum\"),(H171=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G171*H171),\"\",IF(G171*H171=0,\"\",ROUND(G171*H171,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G172=\"Prov\",H172=\"Sum\"),(H172=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G172*H172),\"\",IF(G172*H172=0,\"\",ROUND(G172*H172,2))))","v":""}]
[null,"PC.53","Directional drilling and installation of "]
[null,null,"pipe or cable sleeve:",{"$nulls":5},{"$f":"IF(OR(AND(G174=\"Prov\",H174=\"Sum\"),(H174=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G174*H174),\"\",IF(G174*H174=0,\"\",ROUND(G174*H174,2))))","v":""}]
[]
[null,null,".01","710 mm dia hdpe pipe",null,"m",38,null,{"$f":"IF(OR(AND(G176=\"Prov\",H176=\"Sum\"),(H176=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G176*H176),\"\",IF(G176*H176=0,\"\",ROUND(G176*H176,2))))","v":""}]
[]
[null,"PC.54","Extra over items PC 52 and PC 53 for "]
[null,null,"unforeseen rock or boulders ",null,null,"m³",15]
[{"$nulls":8},{"$f":"IF(OR(AND(G180=\"Prov\",H180=\"Sum\"),(H180=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G180*H180),\"\",IF(G180*H180=0,\"\",ROUND(G180*H180,2))))","v":""}]
[null,"PC.56","De-establish quipment on site",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G181=\"Prov\",H181=\"Sum\"),(H181=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G181*H181),\"\",IF(G181*H181=0,\"\",ROUND(G181*H181,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G182=\"Prov\",H182=\"Sum\"),(H182=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G182*H182),\"\",IF(G182*H182=0,\"\",ROUND(G182*H182,2))))","v":""}]
[null,"PC.57","Standing time for directional drilling ",{"$nulls":5},{"$f":"IF(OR(AND(G183=\"Prov\",H183=\"Sum\"),(H183=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G183*H183),\"\",IF(G183*H183=0,\"\",ROUND(G183*H183,2))))","v":""}]
[null,null,"team and equipment",null,null,"h",40]
[]
[null,"PC.58","Stabilization of unstable areas or "]
[null,null,"grouting of voids where ordered:"]
[]
[null,null,".01","Provision and establishment of "]
[{"$nulls":3},"equipment on Site, and removal on "]
[{"$nulls":3},"completion of operation",null,"sum  ",1,null,{"$f":"IF(OR(AND(G191=\"Prov\",H191=\"Sum\"),(H191=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G191*H191),\"\",IF(G191*H191=0,\"\",ROUND(G191*H191,2))))","v":""}]
[]
[null,"PC.58",".02","Operation of equipment ",null,"day",10,null,{"$f":"IF(OR(AND(G193=\"Prov\",H193=\"Sum\"),(H193=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G193*H193),\"\",IF(G193*H193=0,\"\",ROUND(G193*H193,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G194=\"Prov\",H194=\"Sum\"),(H194=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G194*H194),\"\",IF(G194*H194=0,\"\",ROUND(G194*H194,2))))","v":""}]
[null,null,".03","Materials used    ",null,"m³",10,null,{"$f":"IF(OR(AND(G195=\"Prov\",H195=\"Sum\"),(H195=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G195*H195),\"\",IF(G195*H195=0,\"\",ROUND(G195*H195,2))))","v":""}]
[]
[null,"PC 60","DIRECTIONAL DRILLING",{"$nulls":5},{"$f":"IF(OR(AND(G197=\"Prov\",H197=\"Sum\"),(H197=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G197*H197),\"\",IF(G197*H197=0,\"\",ROUND(G197*H197,2))))","v":""}]
[]
[null,null,"DRILLING: ROAD CROSSING 11"]
[{"$nulls":11},"`"]
[null,"PC.61","Design and site establishment",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G201=\"Prov\",H201=\"Sum\"),(H201=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G201*H201),\"\",IF(G201*H201=0,\"\",ROUND(G201*H201,2))))","v":""}]
[]
[null,"PC.62","Temporary works for directional drilling",null,null,"sum  ",1]
[]
[null,"PC.63","Directional drilling and installation of "]
[null,null,"pipe or cable sleeve:"]
[]
[null,null,".01","710 mm dia hdpe pipe",null,"m",45]
[]
[null,"PC.64","Extra over items PC 62 and PC 63 for "]
[null,null,"unforeseen rock or boulders ",null,null,"m³",18]
[]
[null,"PC.66","De-establish quipment on site",null,null,"sum  ",1]
[]
[null,"PC.67","Standing time for directional drilling "]
[null,null,"team and equipment",null,null,"h",40]
[]
[null,"PC.68","Stabilization of unstable areas or "]
[null,null,"grouting of voids where ordered:"]
[]
[null,null,".01","Provision and establishment of "]
[{"$nulls":3},"equipment on Site, and removal on "]
[{"$nulls":3},"completion of operation",null,"sum  ",1]
[]
[null,null,".02","Operation of equipment ",null,"day",10]
[]
[null,null,".03","Materials used    ",null,"m³",10]
[{"$nulls":8},{"$f":"IF(OR(AND(G228=\"Prov\",H228=\"Sum\"),(H228=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G228*H228),\"\",IF(G228*H228=0,\"\",ROUND(G228*H228,2))))","v":""}]
[]
["PART PC","Carried forward"]
[]
[]
[]
[{"$nulls":8},"             PARTICULAR SPECIFICATION PC"]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"Brought forward"]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G241=\"Prov\",H241=\"Sum\"),(H241=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G241*H241),\"\",IF(G241*H241=0,\"\",ROUND(G241*H241,2))))","v":""}]
[null,"PC 70","DIRECTIONAL DRILLING",{"$nulls":5},{"$f":"IF(OR(AND(G242=\"Prov\",H242=\"Sum\"),(H242=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G242*H242),\"\",IF(G242*H242=0,\"\",ROUND(G242*H242,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G243=\"Prov\",H243=\"Sum\"),(H243=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G243*H243),\"\",IF(G243*H243=0,\"\",ROUND(G243*H243,2))))","v":""}]
[null,null,"DRILLING: ROAD CROSSING 12"]
[]
[null,"PC.71","Design and site establishment",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G246=\"Prov\",H246=\"Sum\"),(H246=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G246*H246),\"\",IF(G246*H246=0,\"\",ROUND(G246*H246,2))))","v":""}]
[]
[null,"PC.72","Temporary works for directional drilling",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G248=\"Prov\",H248=\"Sum\"),(H248=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G248*H248),\"\",IF(G248*H248=0,\"\",ROUND(G248*H248,2))))","v":""}]
[]
[null,"PC.73","Directional drilling and installation of "]
[null,null,"pipe or cable sleeve:"]
[]
[null,null,".01","630 mm dia hdpe pipe",null,"m",30,null,{"$f":"IF(OR(AND(G253=\"Prov\",H253=\"Sum\"),(H253=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G253*H253),\"\",IF(G253*H253=0,\"\",ROUND(G253*H253,2))))","v":""}]
[]
[null,"PC.74","Extra over items PC 72 and PC 73 for "]
[null,null,"unforeseen rock or boulders ",null,null,"m³",9,null,{"$f":"IF(OR(AND(G256=\"Prov\",H256=\"Sum\"),(H256=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G256*H256),\"\",IF(G256*H256=0,\"\",ROUND(G256*H256,2))))","v":""}]
[]
[null,"PC.76","De-establish quipment on site",null,null,"sum  ",1,null,{"$f":"IF(OR(AND(G258=\"Prov\",H258=\"Sum\"),(H258=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G258*H258),\"\",IF(G258*H258=0,\"\",ROUND(G258*H258,2))))","v":""}]
[]
[null,"PC.77","Standing time for directional drilling ",{"$nulls":5},{"$f":"IF(OR(AND(G260=\"Prov\",H260=\"Sum\"),(H260=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G260*H260),\"\",IF(G260*H260=0,\"\",ROUND(G260*H260,2))))","v":""}]
[null,null,"team and equipment",null,null,"h",80]
[]
[null,"PC.78","Stabilization of unstable areas or "]
[null,null,"grouting of voids where ordered:"]
[]
[null,null,".01","Provision and establishment of "]
[{"$nulls":3},"equipment on Site, and removal on "]
[{"$nulls":3},"completion of operation",null,"sum  ",1,null,{"$f":"IF(OR(AND(G268=\"Prov\",H268=\"Sum\"),(H268=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G268*H268),\"\",IF(G268*H268=0,\"\",ROUND(G268*H268,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G269=\"Prov\",H269=\"Sum\"),(H269=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G269*H269),\"\",IF(G269*H269=0,\"\",ROUND(G269*H269,2))))","v":""}]
[null,null,".02","Operation of equipment ",null,"day",10,null,{"$f":"IF(OR(AND(G270=\"Prov\",H270=\"Sum\"),(H270=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G270*H270),\"\",IF(G270*H270=0,\"\",ROUND(G270*H270,2))))","v":""}]
[{"$nulls":8},{"$f":"IF(OR(AND(G271=\"Prov\",H271=\"Sum\"),(H271=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G271*H271),\"\",IF(G271*H271=0,\"\",ROUND(G271*H271,2))))","v":""}]
[null,null,".03","Materials used    ",null,"m³",10,null,{"$f":"IF(OR(AND(G272=\"Prov\",H272=\"Sum\"),(H272=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G272*H272),\"\",IF(G272*H272=0,\"\",ROUND(G272*H272,2))))","v":""}]
{"$rows_empty":31}
[{"$nulls":8},{"$f":"IF(OR(AND(G304=\"Prov\",H304=\"Sum\"),(H304=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G304*H304),\"\",IF(G304*H304=0,\"\",ROUND(G304*H304,2))))","v":""}]
[]
[null,"TOTAL SECTION PARTICULAR SPECIFICATION PC CARRIED TO SUMMARY"]

{"sheet":"PART PD","index":15,"n_rows":70,"n_cols":9,"rows_kept":70}
[]
[{"$nulls":8},"             PARTICULAR SPECIFICATION PD"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
["PD 10",null,"BUILDING WORK",{"$nulls":5},""]
[{"$nulls":8},""]
[null,"PD.08","Miscellaneous work:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,".01","Cast-in 50mm dia sleeves for electric cable access ",null,"sum",1,null,{"$f":"IF(OR(AND(G12=\"Prov\",H12=\"Sum\"),(H12=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G12*H12),\"\",IF(G12*H12=0,\"\",ROUND(G12*H12,2))))","v":""}]
[{"$nulls":3},"to the water meter"]
[{"$nulls":8},""]
[null,"PD.09","Miscellaneous items:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"Measured by area:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"Soil insecticide",{"$nulls":5},""]
[]
[null,null,".01","Soil insecticide poisoning under footings,",{"$nulls":4},""]
[{"$nulls":3}," bases, floors, etc as specified by the",{"$nulls":4},""]
[{"$nulls":3},"Architect with a ten year guarantee",null,"m²",{"v":256,"d":"256 "},null,""]
[]
[null,null,"Waterproofing",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"250 Micron damp proof sheeting to under floor slab"]
[]
[null,null,".01","Chamber 1 & 2",null,"m²",{"v":181,"d":"181 "}]
[]
[null,null,"Derbigum (or similar approved) fusion bonded "]
[null,null,"waterproofing including turn-ups, sealing along"]
[null,null,"edges andbituminous paint coat:"]
[]
[null,null,".02","Flat roofs including sides and"]
[{"$nulls":3},"tops of upstand beams",null,"m²",{"v":82,"d":"82 "}]
{"$rows_empty":23}
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[]
[]
[]
[]
[]
[{"$nulls":8},""]
[]
[null,"TOTAL PARTICULAR SPECIFICATION PD CARRIED TO SUMMARY"]

{"sheet":"ELECTRICAL","index":16,"n_rows":1064,"n_cols":9,"rows_kept":1064,"merged":[[51,2,51,4],[53,2,53,4],[54,2,54,4],[136,2,136,4],[536,2,536,4],[999,2,999,4],[1001,2,1001,4],[1003,2,1003,4],[1005,2,1005,4],[1007,2,1007,4],[1009,2,1009,4],[1011,2,1011,4],[1013,2,1013,4]]}
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G7=\"Prov\",H7=\"Sum\"),(H7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G7*H7),\"\",IF(G7*H7=0,\"\",ROUND(G7*H7,2))))","v":""}]
[null,null,"ELECTRICAL WORKS",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"BILL 1: ELECTRICAL APPLICATION",{"$nulls":5},""]
[]
[null,null,"1. This Bill of Quantities shall be read in "]
[null,null,"conjunction with the Installer's Scope of "]
[null,null,"Work, Technical Specifications and the "]
[null,null,"Engineer design drawings with all other"]
[null,null,"Engineering decipline drawings."]
[null,null,"2. All rates shall include Supply and Install."]
[null,null,"The items in this Bill shall "]
[null,null,"include all wiring, cabling, connections,"]
[null,null,"terminations, installation and termination"]
[null,null,"accessories, possible cable-joints, cable-"]
[null,null,"glands, cable-ties, cable-clips, clamps,"]
[null,null,"shrouds, couplers, lugs, screw-caps, nuts, "]
[null,null,"connectors, terminal strips, heat-shrink, "]
[null,null,"insulating material, etc.  for the electrical "]
[null,null,"cables and conductors. It is the"]
[null,null,"responsibility of the contractor to make a"]
[null,null,"fully working system."]
[null,null,"3. It is the responsibility of the contractor to "]
[null,null,"ensure all items are allowed for in this Bill of"]
[null,null,"Quantities."]
[null,null,"4. NB: It is the responsibility of the "]
[null,null,"contractor to supply a fully operational and"]
[null,null,"compliant system."]
[null,null,"5. All items in this Bill of quantities are "]
[null,null,"remeasurable and only installed Quantities"]
[null,null,"will be paid for."]
[]
[null,{"v":100,"d":"100.00"},"Electricity application"]
[]
[null,{"$f":"B39+0.01","v":100.01},"Application to the electricity power supply",null,null,"Sum",1]
[null,null,"authority of Eskom for an 80A 400V coonection"]
[]
[null,{"$f":"B41+0.01","v":100.02},"Liaison with Eskom including all documentation",null,null,"Sum",1,null,""]
[null,null,"as may be required.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B44+0.01","v":100.03},"Liaison with main contractor",null,null,"Sum",1,null,""]
[]
[null,{"$f":"B47+0.01","v":100.04},"Notices and safety / danger signs as per the",null,null,"Sum",1]
[null,null,"OHS Act."]
[]
[null,{"$f":"B39+1","v":{"v":101,"d":"101.00"}},"Ancillaries and accessories"]
[]
[null,{"$f":"B52+0.01","v":101.01},"Any other item required for completion of the installation, ",null,null,"Sum",1]
[null,null,"not specified else where - specify"]
{"$rows_empty":19}
[{"$nulls":8},""]
[]
[null,"Total carried to summary"]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G85=\"Prov\",H85=\"Sum\"),(H85=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G85*H85),\"\",IF(G85*H85=0,\"\",ROUND(G85*H85,2))))","v":""}]
[null,null,"BILL 2: PRELIMINARY AND GENERAL",{"$nulls":5},""]
[]
[null,null,"1. This Bill of Quantities shall be read in "]
[null,null,"conjunction with the Installer's Scope of "]
[null,null,"Work, Technical Specifications and the "]
[null,null,"Engineer design drawings with all other"]
[null,null,"Engineering decipline drawings."]
[]
[null,null,"2. All rates shall include Supply and Install."]
[null,null,"These items shall  the items in this Bill shall "]
[null,null,"include all wiring, cabling, connections,"]
[null,null,"terminations, installation and termination"]
[null,null,"accessories, possible cable-joints, cable-"]
[null,null,"glands, cable-ties, cable-clips, clamps,"]
[null,null,"shrouds, couplers, lugs, screw-caps, nuts, "]
[null,null,"connectors, terminal strips, heat-shrink, "]
[null,null,"insulating material, etc.  for the electrical "]
[null,null,"cables and conductors. It is the"]
[null,null,"responsibility of the contractor to make a"]
[null,null,"fully working system."]
[]
[null,null,"3. It is the responsibility of the contractor to "]
[null,null,"ensure all items are allowed for in this Bill of"]
[null,null,"Quantities."]
[]
[null,null,"4. NB: It is the responsibility of the "]
[null,null,"contractor to supply a fully operational and"]
[null,null,"compliant system."]
[]
[null,null,"5. All items in this Bill of quantities are "]
[null,null,"remeasurable and only installed Quantities"]
[null,null,"will be paid for."]
[]
[null,{"v":200,"d":"200.00"},"Liason with other parties"]
[{"$nulls":8},{"$f":"IF(OR(AND(G120=\"Prov\",H120=\"Sum\"),(H120=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G120*H120),\"\",IF(G120*H120=0,\"\",ROUND(G120*H120,2))))","v":""}]
[null,{"$f":"B119+0.01","v":200.01},"Liaison with main contractor",null,null,"Sum",1,null,""]
[{"$nulls":8},""]
[null,{"$f":"B119+1","v":{"v":201,"d":"201.00"}},"Documentation",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B123+0.01","v":201.01},"For Construction drawings, hard copy and CD",null,null,"Sets",3,null,""]
[]
[null,{"$f":"B125+0.01","v":201.02},"Detailed Scope of Works, Project Safety Plan",null,null,"Sets",3]
[null,null,"and Safe Work Method Statement"]
[]
[null,{"$f":"B127+0.01","v":201.03},"As-built drawings in Auto CAD/Revit format,",null,null,"Sets",3]
[null,null,"on a CD"]
[]
[null,{"$f":"B130+0.01","v":201.04},"Operators and Maintenance Manuals,",null,null,"Sets",3]
[null,null,"hard copy and CD"]
[]
[null,{"$f":"B133+0.01","v":201.05},"Commissioning Sheets and Installation",null,null,"Sets",3]
[null,null,"Checklists"]
[]
[null,201.06,"Labeling of all devices, equipment and cables",null,null,"Sum",1]
[]
[null,201.07,"Drawings for approval (Engineers approval)",null,null,"Sum",1]
[]
[null,{"v":202,"d":"202.00"},"Testing and commissioning"]
[]
[null,202.01,"Test and commission of the electrical installation",null,null,"Sum",1]
[null,null,"and area lighting system and issue reports"]
[null,null,"and certificates as required by the standards"]
[null,null,"and specifications"]
[]
[]
[null,"Carried forward"]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,{"$f":"B143+1","v":{"v":203,"d":"203.00"}},"Training"]
[]
[null,{"$f":"B160+0.01","v":203.01},"End-user training",null,null,"Sum",1]
[]
[null,{"$f":"B160+1","v":{"v":204,"d":"204.00"}},"Warranty"]
[]
[null,{"$f":"B164+0.01","v":204.01},"Mounting structure: Workmanship",null,null,"Sum",1]
[null,null,"guarantee/Product replacement warranty"]
[null,null,"of 10 years"]
[]
[null,{"$f":"B166+0.01","v":204.02},"All inclusive post practical completion 12 month",null,null,"Sum",1]
[null,null,"SLA for complete installation"]
[]
[null,{"$f":"B170+0.01","v":204.03},"Balance of mechanical and electrical Works:",null,null,"Sum",1]
[null,null,"Workmanship guarantee/Product replacement"]
[null,null,"warranty of 10 years"]
[]
[null,{"$f":"B164+1","v":{"v":205,"d":"205.00"}},"Preliminary and General"]
[]
[null,{"$f":"B177+0.01","v":205.01},"Time related P&G's",null,null,"Sum",1]
[]
[null,{"$f":"B179+0.01","v":205.02},"Fixed P&G's",null,null,"Sum",1]
[]
[null,{"$f":"B181+0.01","v":205.03},"Site establishment and disestablishment",null,null,"Sum",1]
[]
[null,{"$f":"B177+1","v":{"v":206,"d":"206.00"}},"Other costs"]
[]
[null,{"$f":"B185+0.01","v":206.01},"Allow for all costs which the Contractor may",null,null,"Sum",1]
[null,null,"incur in terms of any or all of description in"]
[null,null,"these documents and of the drawings which"]
[null,null,"costs are not specifically covered in the"]
[null,null,"schedule below.  Submit full details."]
["",{"$nulls":7},{"$f":"IF(OR(AND(G192=\"Prov\",H192=\"Sum\"),(H192=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G192*H192),\"\",IF(G192*H192=0,\"\",ROUND(G192*H192,2))))","v":""}]
[null,null,"NOTE: Value related P&G's should be\n"]
[null,null,"included in the tendered rates\n"]
{"$rows_empty":25}
[{"$nulls":8},""]
[]
[null,"Total carried to summary"]
[]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G231=\"Prov\",H231=\"Sum\"),(H231=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G231*H231),\"\",IF(G231*H231=0,\"\",ROUND(G231*H231,2))))","v":""}]
[null,null,"BILL 3: DISTRIBUTION BOARDS",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"1. This Bill of Quantities shall be read in ",{"$nulls":5},""]
[null,null,"conjunction with the Installer's Scope of ",{"$nulls":5},""]
[null,null,"Work, Technical Specifications and the ",{"$nulls":5},""]
[null,null,"Engineer design drawings with all other",{"$nulls":5},""]
[null,null,"Engineering decipline drawings.",{"$nulls":5},""]
[null,null,"2. All rates shall include Supply and Install.",{"$nulls":5},""]
[null,null,"These items shall  the items in this Bill shall ",{"$nulls":5},""]
[null,null,"include all wiring, cabling, connections,",{"$nulls":5},""]
[null,null,"terminations, installation and termination",{"$nulls":5},""]
[null,null,"accessories, possible cable-joints, cable-",{"$nulls":5},""]
[null,null,"glands, cable-ties, cable-clips, clamps,",{"$nulls":5},""]
[null,null,"shrouds, couplers, lugs, screw-caps, nuts, ",{"$nulls":5},""]
[null,null,"connectors, terminal strips, heat-shrink, ",{"$nulls":5},""]
[null,null,"insulating material, etc.  for the electrical ",{"$nulls":5},""]
[null,null,"cables and conductors. It is the",{"$nulls":5},""]
[null,null,"responsibility of the contractor to make a",{"$nulls":5},""]
[null,null,"fully working system.",{"$nulls":5},""]
[null,null,"3. It is the responsibility of the contractor to ",{"$nulls":5},""]
[null,null,"ensure all items are allowed for in this Bill of",{"$nulls":5},""]
[null,null,"Quantities.",{"$nulls":5},""]
[null,null,"4. NB: It is the responsibility of the ",{"$nulls":5},""]
[null,null,"contractor to supply a fully operational and",{"$nulls":5},""]
[null,null,"compliant system.",{"$nulls":5},""]
[null,null,"5. The electrical cable and wiring shall",{"$nulls":5},""]
[null,null,"comply with the SANS wiring colour codes:",{"$nulls":5},""]
[null,null,"Protective earth (PE) - green-yellow",{"$nulls":5},""]
[null,null,"Neutral (N) - black",{"$nulls":5},""]
[null,null,"Line, single phase (L) - red",{"$nulls":5},""]
[null,null,"Line, three phase (L1) - red",{"$nulls":5},""]
[null,null,"Line, three phase (L2) - yellow",{"$nulls":5},""]
[null,null,"Line, three phase (L3) - blue",{"$nulls":5},""]
[null,null,"6. Supply, testing, deliver, off-loading, and",{"$nulls":5},""]
[null,null,"commissioning of distribution boards",{"$nulls":5},""]
[null,null,"complete with test certifications as per SANS",{"$nulls":5},""]
[null,null,"61439-1 and IEC 61439-1 standards for",{"$nulls":5},""]
[null,null,"distribution boars, including factory",{"$nulls":5},""]
[null,null,"inspection, all equipment pre fitted in the",{"$nulls":5},""]
[null,null,"factory complete with busbars, accessories,",{"$nulls":5},""]
[null,null,"earthing and conduit terminations in",{"$nulls":5},""]
[null,null,"accordance with electrical specifications.",{"$nulls":5},""]
[null,null,"7. The distribution board requirements are",{"$nulls":5},""]
[null,null,"shown on the single line diagrams",{"$nulls":5},""]
[null,null,"(schematic diagrams) drawings.",{"$nulls":5},""]
[null,null,"8. Shop drawings shall be submitted to the",{"$nulls":5},""]
[null,null,"Engineer for formal approval before any",{"$nulls":5},""]
[null,null,"manufacturing commences.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"v":300,"d":"300.00"},"Distribution Boards",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B281+0.01","v":300.01},"DB - 01 (Valve Access Chamber)",{"$nulls":5},""]
[null,null,"Refer to single line diagram for size and rating",null,null,"No",1,null,""]
[{"$nulls":8},""]
[null,{"$f":"B281+1","v":{"v":301,"d":"301.00"}},"Ancillaries and accessories",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B286+0.01","v":301.01},"Any other item required for completion of the",{"$nulls":5},""]
[null,null," installation, not specified else where - specify",null,null,"Sum",1,null,""]
[{"$nulls":8},""]
[null,{"$f":"B286+1","v":{"v":302,"d":"302.00"}},"Certificate of Compliance"]
[]
[null,{"$f":"B291+0.01","v":302.01},"Issue CoC completion of complete electrical",null,null,"Sum",1]
[null,null,"installation"]
[]
[]
[]
[null,"Total carried to summary"]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G306=\"Prov\",H306=\"Sum\"),(H306=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G306*H306),\"\",IF(G306*H306=0,\"\",ROUND(G306*H306,2))))","v":""}]
[null,null,"BILL 4: LOW VOLTAGE CABLES",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"1. This Bill of Quantities shall be read in ",{"$nulls":5},""]
[null,null,"conjunction with the Installer's Scope of ",{"$nulls":5},""]
[null,null,"Work, Technical Specifications and the ",{"$nulls":5},""]
[null,null,"Engineer design drawings with all other",{"$nulls":5},""]
[null,null,"Engineering decipline drawings.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"2. All rates shall include Supply and Install.",{"$nulls":5},""]
[null,null,"These items shall  the items in this Bill shall ",{"$nulls":5},""]
[null,null,"include all wiring, cabling, connections,",{"$nulls":5},""]
[null,null,"terminations, installation and termination",{"$nulls":5},""]
[null,null,"accessories, possible cable-joints, cable-",{"$nulls":5},""]
[null,null,"glands, cable-ties, cable-clips, clamps,",{"$nulls":5},""]
[null,null,"shrouds, couplers, lugs, screw-caps, nuts, ",{"$nulls":5},""]
[null,null,"connectors, terminal strips, heat-shrink, ",{"$nulls":5},""]
[null,null,"insulating material, etc.  for the electrical ",{"$nulls":5},""]
[null,null,"cables and conductors. It is the",{"$nulls":5},""]
[null,null,"responsibility of the contractor to make a",{"$nulls":5},""]
[null,null,"fully working system.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"3. It is the responsibility of the contractor to ",{"$nulls":5},""]
[null,null,"ensure all items are allowed for in this Bill of",{"$nulls":5},""]
[null,null,"Quantities.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"4. NB: It is the responsibility of the ",{"$nulls":5},""]
[null,null,"contractor to supply a fully operational and",{"$nulls":5},""]
[null,null,"compliant system.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"5. The electrical cable and wiring shall",{"$nulls":5},""]
[null,null,"comply with the SANS wiring colour codes:",{"$nulls":5},""]
[null,null,"Protective earth (PE) - green-yellow",{"$nulls":5},""]
[null,null,"Neutral (N) - black",{"$nulls":5},""]
[null,null,"Line, single phase (L) - red",{"$nulls":5},""]
[null,null,"Line, three phase (L1) - red",{"$nulls":5},""]
[null,null,"Line, three phase (L2) - yellow",{"$nulls":5},""]
[null,null,"Line, three phase (L3) - blue",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"6. The Contractor shall supply, install and",{"$nulls":5},""]
[null,null,"commission all the reticulation and",{"$nulls":5},""]
[null,null,"distribution cables as specified in the cable",{"$nulls":5},""]
[null,null,"schedules. The rate shall include for all the",{"$nulls":5},""]
[null,null,"labeling materials required to complete the",{"$nulls":5},""]
[null,null,"instalaltion. All cables will be installed in the",{"$nulls":5},""]
[null,null,"ground and enter the DB's via sleeves.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"v":400,"d":"400.00"},"PVC/PVC/SWA/PVC Cu",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B353+0.01","v":400.01},"25mm², 4-Core",null,null,"m",300]
[{"$nulls":8},""]
[null,{"$f":"B355+0.01","v":400.02},"10mm², 4-Core",null,null,"m",250]
[{"$nulls":8},""]
[null,{"$f":"B357+0.01","v":400.03},"6mm², 3-Core",null,null,"m",100]
[{"$nulls":8},""]
[null,{"$f":"B359+0.01","v":400.04},"4mm², 4-Core",null,null,"m",300]
[]
[null,{"$f":"B361+0.01","v":400.05},"4mm², 3-Core",null,null,"m",100]
[{"$nulls":8},""]
[null,{"$f":"B353+1","v":{"v":401,"d":"401.00"}},"BCEW (Bare Cu Earth Wire)",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B365+0.01","v":401.01},"16mm², 1-Core",null,null,"m",300]
[]
[]
[]
[]
[]
[null,"Carried forward"]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,{"$f":"B367+0.01","v":401.02},"6mm², 1-Core",null,null,"m",250]
[{"$nulls":8},{"$f":"IF(OR(AND(G383=\"Prov\",H383=\"Sum\"),(H383=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G383*H383),\"\",IF(G383*H383=0,\"\",ROUND(G383*H383,2))))","v":""}]
[null,{"$f":"B382+0.01","v":401.03},"4mm², 1-Core",null,null,"m",100]
[]
[null,{"$f":"B384+0.01","v":401.04},"2.5mm², 1-Core",null,null,"m",300]
[{"$nulls":8},{"$f":"IF(OR(AND(G387=\"Prov\",H387=\"Sum\"),(H387=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G387*H387),\"\",IF(G387*H387=0,\"\",ROUND(G387*H387,2))))","v":""}]
[null,{"$f":"B365+1","v":{"v":402,"d":"402.00"}},"Ancillaries and accessories",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B388+0.01","v":402.01},"Any other item required for completion of the",null,null,"Sum",1]
[null,null,"installation, not specified else where - specify",{"$nulls":5},{"$f":"IF(OR(AND(G391=\"Prov\",H391=\"Sum\"),(H391=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G391*H391),\"\",IF(G391*H391=0,\"\",ROUND(G391*H391,2))))","v":""}]
{"$rows_empty":56}
[null,"Total carried to summary  "]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G456=\"Prov\",H456=\"Sum\"),(H456=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G456*H456),\"\",IF(G456*H456=0,\"\",ROUND(G456*H456,2))))","v":""}]
[null,null,"BILL 5: CABLE ROUTING & WIRE WAYS",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"1. This Bill of Quantities shall be read in ",{"$nulls":5},""]
[null,null,"conjunction with the Installer's Scope of ",{"$nulls":5},""]
[null,null,"Work, Technical Specifications and the ",{"$nulls":5},""]
[null,null,"Engineer design drawings with all other",{"$nulls":5},""]
[null,null,"Engineering decipline drawings.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"2. All rates shall include Supply and Install.",{"$nulls":5},""]
[null,null,"These items shall  the items in this Bill shall ",{"$nulls":5},""]
[null,null,"include all wiring, cabling, connections,",{"$nulls":5},""]
[null,null,"terminations, installation and termination",{"$nulls":5},""]
[null,null,"accessories, possible cable-joints, cable-",{"$nulls":5},""]
[null,null,"glands, cable-ties, cable-clips, clamps,",{"$nulls":5},""]
[null,null,"shrouds, couplers, lugs, screw-caps, nuts, ",{"$nulls":5},""]
[null,null,"connectors, terminal strips, heat-shrink, ",{"$nulls":5},""]
[null,null,"insulating material, etc.  for the electrical ",{"$nulls":5},""]
[null,null,"cables and conductors. It is the",{"$nulls":5},""]
[null,null,"responsibility of the contractor to make a",{"$nulls":5},""]
[null,null,"fully working system.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"3. It is the responsibility of the contractor to ",{"$nulls":5},""]
[null,null,"ensure all items are allowed for in this Bill of",{"$nulls":5},""]
[null,null,"Quantities.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"4. NB: It is the responsibility of the ",{"$nulls":5},""]
[null,null,"contractor to supply a fully operational and",{"$nulls":5},""]
[null,null,"compliant system.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"5. All items in this Bill of quantities are ",{"$nulls":5},""]
[null,null,"remeasurable and only installed Quantities",{"$nulls":5},""]
[null,null,"will be paid for.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"v":500,"d":"500.00"},"Marker tape",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B490+0.01","v":500.01},"Supply and install PVC marker type suitably to",null,null,"m",450]
[null,null,"be laid in cable trenches, 150mm wide, yellow",{"$nulls":5},""]
[null,null,"coloured and marked",{"$nulls":5},""]
[null,null,"\"DANGER: ELECTRIC CABLE BELOW\" ",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B490+1","v":{"v":501,"d":"501.00"}},"Cable route marker",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B497+0.01","v":501.01},"500x300x300mm Concrete cable route marker",null,null,"No",4]
[null,null,"plate as per specification drawing",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B497+1","v":{"v":502,"d":"502.00"}},"Cable trenching",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B502+0.01","v":502.01},"Excavation, backfilling, leveling and carting away",null,null,"m",450]
[null,null,"of excess material to cable trenches as specified,",{"$nulls":5},""]
[null,null,"600mm deep for LV cabling.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B504+0.01","v":502.02},"Extra over excavation for excavation in soft rock",null,null,"m",225]
[null,null,"(Provisional)",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B508+0.01","v":502.03},"Extra over excavation for excavation in hard rock",null,null,"m",100]
[null,null,"(Provisional)"]
[]
[null,{"$f":"B511+0.01","v":502.04},"Backfilling and compact of  trench with imported",null,null,"m",225]
[null,null,"soil (Provisional)"]
[]
[null,{"$f":"B514+0.01","v":502.05},"Backfilling of cable trench with imported  sifted",null,null,"m",225]
[null,null,"soft soil 200mm thick (Provisional)"]
[]
[]
[]
[]
[null,"Carried forward"]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,{"$f":"B502+1","v":{"v":503,"d":"503.00"}},"Services holes (Man holes)"]
[]
[null,{"$f":"B532+0.01","v":503.01},"800mm deep, 800mm x 800mm services",null,null,"No",6]
[null,null,"holes (manhole) with a heavy duty cast iron"]
[null,null,"cover and frame  for sleeves and to pull cabling"]
[null,null,"and wiring through "]
[]
[null,{"$f":"B532+1","v":{"v":504,"d":"504.00"}},"Trunking, for Electrical Wiring-(Gray)"]
[null,null,"Cross-arm supports shall be wide enough to "]
[null,null,"accommodate specified tray only, unless"]
[null,null,"otherwise satted. Hangers to be M8, not"]
[null,null,"not exceeding 1,2m spacings"]
[]
[null,{"$f":"B539+0.01","v":504.01},"P9000",null,null,"m",150]
[]
[null,{"$f":"B545+0.01","v":504.02},"Bend",null,null,"No",20]
[]
[null,{"$f":"B547+0.01","v":504.03},"T-Off",null,null,"No.",10]
[]
[null,{"$f":"B539+1","v":{"v":505,"d":"505.00"}},"Cable tray",{"$nulls":5},""]
[null,null,"MILD STEEL HOT DIPTED GALV. ",{"$nulls":5},""]
[null,null," PT-76 mild duty",{"$nulls":5},""]
[null,null,"Supply and install galv steel cable trays",{"$nulls":5},""]
[null,null,"complete with all wall and floor mounting"]
[null,null,"P2000 supports, splicing other fixing",{"$nulls":5},{"$f":"IF(OR(AND(G556=\"Prov\",H556=\"Sum\"),(H556=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G556*H556),\"\",IF(G556*H556=0,\"\",ROUND(G556*H556,2))))","v":""}]
[null,null,"materials required as per suppliers",{"$nulls":5},""]
[null,null,"speifications. Cable tray earth wire at",{"$nulls":5},""]
[null,null,"every joint.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B551+0.01","v":505.01},"300mm x 76mm  - striaght runs",null,null,"m",150]
[null,null,"(excluding cover)",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B551+1","v":{"v":506,"d":"506.00"}},"Cable tray - Wire Mesh",{"$nulls":5},""]
[null,null,"MILD STEEL HOT DIPTED GALV. ",{"$nulls":5},""]
[null,null," GS-50 gridspan Wire Mesh",{"$nulls":5},""]
[null,null,"Supply and install galv steel cable trays",{"$nulls":5},""]
[null,null,"complete with all wall and floor mounting",{"$nulls":5},""]
[null,null,"P2000 supports, splicing other fixing",{"$nulls":5},""]
[null,null,"materials required as per suppliers",{"$nulls":5},""]
[null,null,"speifications. Cable tray earth wire at",{"$nulls":5},""]
[null,null,"every joint.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B564+0.01","v":506.01},"300mm x 50mm  - striaght runs",null,null,"m",300]
[{"$nulls":8},""]
[null,{"$f":"B574+0.01","v":506.02},"300mm - T-off",null,null,"No",4]
[]
[null,{"$f":"B564+1","v":{"v":507,"d":"507.00"}},"Cable ladder - "]
[null,null,"MILD STEEL HOT DIPTED GALV. "]
[null,null,"Supply and install galv steel cable ladders"]
[null,null,"complete with all wall and floor mounting"]
[null,null,"supports, splicing other fixing"]
[null,null,"materials required as per suppliers"]
[null,null,"speifications. Cable tray earth wire at"]
[null,null,"every joint."]
[]
[null,{"$f":"B578+0.01","v":507.01},"300mm x 76mm",null,null,"m",300]
[]
[null,{"$f":"B587+0.01","v":507.02},"T-offs",null,null,"No",12]
[]
[null,{"$f":"B578+1","v":{"v":508,"d":"508.00"}},"Conduits & Wire Ways"]
[]
[null,{"$f":"B591+0.01","v":508.01},"110mm diameter PVC sleeves",null,null,"m",250]
[]
[]
[]
[]
[null,"Carried forward"]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,{"$f":"B593+0.01","v":508.02},"50mm diameter PVC sleeves",null,null,"m",250]
[]
[null,{"$f":"B607+0.01","v":508.03},"25mm GALV. steel conduit",null,null,"m",500]
[]
[null,{"$f":"B609+0.01","v":508.04},"32mm GALV. steel conduit",null,null,"m",300]
[]
[null,{"$f":"B611+0.01","v":508.05},"25mm PVC. conduit",null,null,"m",300]
[]
[null,{"$f":"B591+1","v":{"v":509,"d":"509.00"}},"Ancillaries and accessories"]
[]
[null,{"$f":"B615+0.01","v":509.01},"Any other item required for completion of the",null,null,"Sum",1]
[null,null," installation, not specified else where - specify"]
{"$rows_empty":54}
[null,"Total carried to summary"]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G681=\"Prov\",H681=\"Sum\"),(H681=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G681*H681),\"\",IF(G681*H681=0,\"\",ROUND(G681*H681,2))))","v":""}]
[null,null,"BILL 6: SMALL POWER & LIGHTING",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"1. This Bill of Quantities shall be read in ",{"$nulls":5},""]
[null,null,"conjunction with the Installer's Scope of ",{"$nulls":5},""]
[null,null,"Work, Technical Specifications and the ",{"$nulls":5},""]
[null,null,"Engineer design drawings with all other",{"$nulls":5},""]
[null,null,"Engineering decipline drawings.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"2. All rates shall include Supply and Install.",{"$nulls":5},""]
[null,null,"These items shall  the items in this Bill shall ",{"$nulls":5},""]
[null,null,"include all wiring, cabling, connections,",{"$nulls":5},""]
[null,null,"terminations, installation and termination",{"$nulls":5},""]
[null,null,"accessories, possible cable-joints, cable-",{"$nulls":5},""]
[null,null,"glands, cable-ties, cable-clips, clamps,",{"$nulls":5},""]
[null,null,"shrouds, couplers, lugs, screw-caps, nuts, ",{"$nulls":5},""]
[null,null,"connectors, terminal strips, heat-shrink, ",{"$nulls":5},""]
[null,null,"insulating material, etc.  for the electrical ",{"$nulls":5},""]
[null,null,"cables and conductors. It is the",{"$nulls":5},""]
[null,null,"responsibility of the contractor to make a",{"$nulls":5},""]
[null,null,"fully working system.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"3. It is the responsibility of the contractor to ",{"$nulls":5},""]
[null,null,"ensure all items are allowed for in this Bill of",{"$nulls":5},""]
[null,null,"Quantities.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"4. NB: It is the responsibility of the ",{"$nulls":5},""]
[null,null,"contractor to supply a fully operational and",{"$nulls":5},""]
[null,null,"compliant system.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"5. All items in this Bill of quantities are ",{"$nulls":5},""]
[null,null,"remeasurable and only installed Quantities",{"$nulls":5},""]
[null,null,"will be paid for.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"v":600,"d":"600.00"},"Supply, and install switched & unswitched",{"$nulls":5},""]
[null,null,"socket outlets points, surface/flush mounted",{"$nulls":5},""]
[null,null,"or flush in power skirting mounted, complete",{"$nulls":5},""]
[null,null,"with cradle, galvanized wall-draw box, cover",{"$nulls":5},""]
[null,null,"plate, including PVC/GALV. conduits and all",{"$nulls":5},""]
[null,null,"conduit accessories,  all mounting",{"$nulls":5},""]
[null,null,"accessories, and 2.5mm² wiring:",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B715+0.01","v":600.01},"16A, Dual switched socket outlet, New ZA Plug",null,null,"No",6]
[null,null,"recessed in wall. (SANS-164-1&2)",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B723+0.01","v":600.02},"16A, Dedicated switched socket outlet (RED)",null,null,"No",6]
[{"$nulls":8},""]
[null,{"$f":"B726+0.01","v":600.03},"16A, IP65 (water & dust proof)",null,null,"No",6]
[null,null,"single switched socket outlet,",{"$nulls":5},""]
[null,null,"surface mounted on wall. (SANS-164-1&2)",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B728+0.01","v":600.04},"32A, IP65 (water & dust proof) 5-PIN, ",null,null,"No",6]
[null,null,"400V, industrial welding socket outlet,",{"$nulls":5},""]
[null,null,"surface mounted on wall. (IEC 60 309-1, -2, -4)",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"$f":"B732+0.01","v":600.05},"Power Skirting 2 Tier - Grey",null,null,"m",20]
[]
[null,{"$f":"B715+1","v":{"v":601,"d":"601.00"}},"Supply, and install isolator switch power"]
[null,null,"outlets points, surface/flush mounted,"]
[null,null,"complete with conduits and all conduit"]
[null,null,"accessories, mounting accessories, "]
[null,null,"and 4mm² wiring:"]
[]
[]
[]
[]
[]
[null,"Carried forward"]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,{"$f":"B738+0.01","v":601.01},"32A, IP65 (water & dust proof) 3-Ph",null,null,"No",6]
[null,null,"lockable isolator switch, for extractor fans,"]
[null,null,"surface mounted."]
[]
[null,{"$f":"B738+1","v":{"v":602,"d":"602.00"}},"Supply, deliver and install luminaires,"]
[null,null,"complete with all mounting accessories,"]
[null,null,"2.5mm² wiringand  terminations. Install luminaires"]
[null,null,"as per luminaire schedule in Annexure 3"]
[]
[null,{"$f":"B761+0.01","v":602.01},"Type L5: 49W LED, 4000K (2.5M INSTALLATION)",null,null,"No",30]
[null,null,"LED vapor proof industrial luminaire, surface "]
[null,null,"mounted, IP66,"]
[]
[null,{"$f":"B766+0.01","v":602.02},"Type L5E: 49W LED, 4000K",null,null,"No",10]
[null,null,"LED vapour proof industrial luminaire, surface"]
[null,null,"mounted IP66, with electronic control gear,"]
[null,null,"60min self maintained battery back-up, "]
[]
[null,{"$f":"B770+0.01","v":602.03},"Type L6: 52W LED, 4000K (6M INSTALLATION)",null,null,"No",15]
[null,null,"LED Linear Floodlight industrial luminaire, surface "]
[null,null,"mounted, IP66,"]
[]
[null,{"$f":"B775+0.01","v":602.04},"Type L6E: 52W LED, 4000K",null,null,"No",5]
[null,null,"LED Linear Floodlight industrial luminaire, surface"]
[null,null,"mounted IP66, with electronic control gear,"]
[null,null,"60min self maintained battery back-up, "]
[]
[null,{"$f":"B779+0.01","v":602.05},"Type L8: 15-18W LED LINEAR VAPORPROOF 4000K",null,null,"No",10]
[null,null,"LED industrial luminaire, surface mounted, IP65,"]
[]
[null,{"$f":"B784+0.01","v":602.06},"Type L9: 170-200W LED LOW BAY LIGHT FITTING 4000K",null,null,"No",2]
[null,null,"LED industrial luminaire, surface mounted "]
[null,null,"IP65 (14M INSTALLATION)"]
[]
[null,{"$f":"B787+0.01","v":602.07},"Type L9E: 170-200W LED LOW BAY LIGHT FITTING 4000K",null,null,"No",1]
[null,null,"LED industrial luminaire, surface mounted, IP65,"]
[]
[null,{"$f":"B791+0.01","v":602.08},"Allow for a Jerry picker for installation of 6m & 14m",null,null,"Sum",1]
[null,null,"high installations"]
[]
[null,{"$f":"B761+1","v":{"v":603,"d":"603.00"}},"Supply, deliver and install light switch points",{"$nulls":5},{"$f":"IF(OR(AND(G797=\"Prov\",H797=\"Sum\"),(H797=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G797*H797),\"\",IF(G797*H797=0,\"\",ROUND(G797*H797,2))))","v":""}]
[null,null,"complete with cradle, cover plate, including",{"$nulls":5},""]
[null,null,"all mounting and installation accessories with",{"$nulls":5},""]
[null,null,"PVC/GALV. conduits and all conduit",{"$nulls":5},""]
[null,null,"accessories, wall boxes, wiring, etc.:"]
[]
[null,{"$f":"B797+0.01","v":603.01},"1 lever 1 way light switch, surface mounted",null,null,"No.",2]
[]
[null,{"$f":"B803+0.01","v":603.02},"1 lever 1 way WATER TIGHT light switch",null,null,"No.",2]
[null,null,"(water & dust proof), surface mounted"]
[]
[null,{"$f":"B805+0.01","v":603.03},"Weather proof photo-cell light switch",null,null,"No.",2]
[]
[null,{"$f":"B797+1","v":{"v":604,"d":"604.00"}},"Ancillaries and accessories"]
[]
[null,{"$f":"B810+0.01","v":604.01},"Any other item required for completion of the",null,null,"Sum",1]
[null,null,"installation, not specified else where - specify"]
[]
[null,{"$f":"B810+1","v":{"v":605,"d":"605.00"}},"Test Commission and Issue CoC",null,null,"Sum",1]
{"$rows_empty":11}
[{"$nulls":8},{"$f":"IF(OR(AND(G827=\"Prov\",H827=\"Sum\"),(H827=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G827*H827),\"\",IF(G827*H827=0,\"\",ROUND(G827*H827,2))))","v":""}]
[]
[null,"Total carried to summary"]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[]
[null,null,"BILL 7: CCTV"]
[]
[null,null,"1. This Bill of Quantities shall be read in "]
[null,null,"conjunction with the Installer's Scope of "]
[null,null,"Work, Technical Specifications and the "]
[null,null,"Engineer design drawings with all other"]
[null,null,"Engineering decipline drawings."]
[]
[null,null,"2. It is the responsibility of the contractor to "]
[null,null,"ensure all items are allowed for in this Bill of"]
[null,null,"Quantities."]
[]
[null,null,"3. NB: It is the responsibility of the "]
[null,null,"contractor to supply a fully operational and"]
[null,null,"compliant system."]
[]
[null,null,"4. All items in this Bill of quantities are "]
[null,null,"remeasurable and only installed Quantities"]
[null,null,"will be paid for."]
[]
[null,null,"Design, supply, deliver and install all"]
[null,null,"equipment and materials required to"]
[null,null,"complete a remote based CCTV monitoring"]
[null,null,"installation for the complete pump station"]
[null,null,"by a specialist installation contractor."]
[null,null,"All rates shall allow for material and labour"]
[null,null,"required per item to complete the"]
[null,null,"installation."]
[]
[null,{"v":700,"d":"700.00"},"Design, Supply and Install"]
[]
[null,700.01,"Design, supply, install and commissioning of a",null,null,"Sum",1]
[null,null,"complete CCTV system by a specialist contractor"]
[]
[null,{"v":701,"d":"701.00"},"Cameras"]
[]
[null,701.01,"Surface mounted IP dome camera, with HD ",null,null,"No",8]
[null,null,"resolution, wide dynamic range, PoE, PTZr "]
[null,null,"(Pan Tilt Rotate) with remote adjustment "]
[null,null,"functionality at processor, 15m range, IP 66, "]
[null,null,"vandal proof, including brackets, mounting pipes "]
[null,null,"and accessories."]
[]
[null,{"v":702,"d":"702.00"},"Network Video Recorder"]
[]
[null,702.01,"NVR with at least 30 days storage capacity",null,null,"No",1]
[null,null,"c/w 24 channels pre-licensed, video management"]
[null,null,"system, including CPU, Hardware, Software,"]
[]
[null,702.02,"2kVA Rack mounted UPS with 120min ",null,null,"No",1]
[null,null,"battery back up"]
[]
[null,{"v":703,"d":"703.00"},"Ethernet Switch and Network"]
[]
[null,703.01,"Access Switch with the minimum requirements of:layer 3 ",null,null,"No",2]
[null,null,"routing. VLAN technology will be used to separate voice, "]
[null,null,"data or video traffic from interfering with each other. "]
[null,null,"(installed in 19\" cabinet supplied by others)"]
[null,null,"IP Based, SFP based Gigabit Ethernet Ports & "]
[null,null,"c/w transmitter module for remote montioring of "]
[null,null,"the CCTV."]
[]
[null,703.02,"Ethernet to Optical Fibre Converters",null,null,"No",6]
[]
[null,{"v":704,"d":"704.00"},"Accessories"]
[]
[null,704.01,"All accessories required for a complete working ",null,null,"Sum",1]
[null,null,"system"]
[]
[]
[{"$nulls":8},{"$f":"IF(OR(AND(G908=\"Prov\",H908=\"Sum\"),(H908=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G908*H908),\"\",IF(G908*H908=0,\"\",ROUND(G908*H908,2))))","v":""}]
[]
[null,"Total carried to summary"]
[]
[]
["ELECTRICAL WORKS"]
[]
["PAYMENT"]
["REFERS","ITEM",null,null,"DESCRIPTION","UNIT","QUAN-","RATE","AMOUNT"]
["TO","NO",{"$nulls":4},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G918=\"Prov\",H918=\"Sum\"),(H918=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G918*H918),\"\",IF(G918*H918=0,\"\",ROUND(G918*H918,2))))","v":""}]
[null,null,"BILL 8: EARTHING & BONDING",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"1. This Bill of Quantities shall be read in ",{"$nulls":5},""]
[null,null,"conjunction with the Installer's Scope of ",{"$nulls":5},""]
[null,null,"Work, Technical Specifications and the ",{"$nulls":5},""]
[null,null,"Engineer design drawings with all other",{"$nulls":5},""]
[null,null,"Engineering decipline drawings.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"2. It is the responsibility of the contractor to ",{"$nulls":5},""]
[null,null,"ensure all items are allowed for in this Bill of",{"$nulls":5},""]
[null,null,"Quantities.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"3. NB: It is the responsibility of the ",{"$nulls":5},""]
[null,null,"contractor to supply a fully operational and",{"$nulls":5},""]
[null,null,"compliant system.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,null,"4. All items in this Bill of quantities are ",{"$nulls":5},""]
[null,null,"remeasurable and only installed Quantities",{"$nulls":5},""]
[null,null,"will be paid for.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"v":800,"d":"800.00"},"Design, supply, deliver and install all",{"$nulls":5},""]
[null,null,"equipment and materials required to",{"$nulls":5},""]
[null,null,"complete the earthing and bonding",{"$nulls":5},""]
[null,null,"installation system for the complete valve",{"$nulls":5},""]
[null,null,"valve, reservior, water tower, guard house",{"$nulls":5},""]
[null,null,"and external light poles as indicated below,",{"$nulls":5},""]
[null,null,"by a specialist installation contractor. ",{"$nulls":5},""]
[null,null,"All rates shall allow for material and labour",{"$nulls":5},""]
[null,null,"required per item to complete the",{"$nulls":5},""]
[null,null,"installation.",{"$nulls":5},""]
[{"$nulls":8},""]
[null,800.01,"E&L, Bonding Protection: Access Chamber",null,null,"Sum",1,null,""]
[null,null,"Including cable containment"]
[{"$nulls":8},""]
[null,800.02,"E&L, Bonding Protection: All conductive equipment",null,null,"Sum",1,null,""]
[null,null,"in the Valve chambers inlcuding cable containment"]
[{"$nulls":8},""]
[null,800.03,"Final testing of equipment earth grid systems on",null,null,"Sum",1,null,""]
[null,null,"completion and issuing of test certificate",{"$nulls":5},""]
[{"$nulls":8},""]
[null,{"v":801,"d":"801.00"},"Ancillaries and accessories",{"$nulls":5},""]
[{"$nulls":8},""]
[null,801.01,"Any other item required for completion of the",null,null,"Sum",1,null,""]
[null,null,"installation, not specified else where - specify",{"$nulls":5},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},""]
{"$rows_empty":20}
[{"$nulls":8},""]
[{"$nulls":8},""]
[{"$nulls":8},{"$f":"IF(OR(AND(G989=\"Prov\",H989=\"Sum\"),(H989=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G989*H989),\"\",IF(G989*H989=0,\"\",ROUND(G989*H989,2))))","v":""}]
[]
[null,"Total carried to summary"]
[]
["ELECTRICAL WORKS"]
[]
[]
["REFERENCES","BILL",null,null,"ITEM","UNIT","QUAN-","RATE","AMOUNT"]
[{"$nulls":6},"TITY"]
[{"$nulls":8},{"$f":"IF(OR(AND(G998=\"Prov\",H998=\"Sum\"),(H998=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G998*H998),\"\",IF(G998*H998=0,\"\",ROUND(G998*H998,2))))","v":""}]
[]
[null,"Bill 1:","ELECTRICAL APPLICATION"]
[]
[null,"Bill 2:","PRELIMINARY AND GENERAL"]
[]
[null,"Bill 3:","DISTRIBUTION BOARDS"]
[]
[null,"Bill 4:","LOW VOLTAGE CABLES"]
[{"$nulls":8},""]
[null,"Bill 5:","CABLE ROUTING & WIRE WAYS"]
[{"$nulls":8},""]
[null,"Bill 6:","SMALL POWER & LIGHTING"]
[{"$nulls":8},""]
[null,"Bill 7:","CCTV"]
[{"$nulls":8},""]
[null,"Bill 8:","EARTHING & BONDING"]
[]
[]
[{"$nulls":8},""]
{"$rows_empty":43}
[{"$nulls":8},""]
[{"$nulls":8},{"$f":"IF(OR(AND(G1062=\"Prov\",H1062=\"Sum\"),(H1062=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(G1062*H1062),\"\",IF(G1062*H1062=0,\"\",ROUND(G1062*H1062,2))))","v":""}]
[]
[null,"TOTAL ELECTRICAL WORKS CARRIED TO SUMMARY"]

{"sheet":"MECHANICAL","index":17,"n_rows":411,"n_cols":7,"rows_kept":411}
[]
[{"$nulls":6},"OPERATING AND MAINTENANCE MANUALS"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT"," QUAN- "," RATE ","AMOUNT"]
["REFERS","NO",null,null," TITY "]
[]
[]
["ZUT 0002",20,"OPERATING AND MAINTENANCE MANUALS",{"$nulls":3},{"$f":"IF($E9>0,IF($E9=\"-\",\"Rate Only\",$E9*F9),\"\")","v":""}]
[]
[null,null,"DRAWING 111242-0000-DR-WW-0516 to 0519"]
[]
[null,20.01,"Supply and Deliver O&M manual (for all components shown and referenced in drawings)","Sum",1]
{"$rows_empty":48}
["Total carried to summary"]
[]
[]
[{"$nulls":6},"MANUALLY OPERATED CHAIN HOIST"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT"," QUAN- "," RATE ","AMOUNT"]
["REFERS","NO",null,null," TITY "]
[]
[]
["ZUT 1003",30,"MANUALLY OPERATED CHAIN HOIST",{"$nulls":3},{"$f":"IF($E72>0,IF($E72=\"-\",\"Rate Only\",$E72*F72),\"\")","v":""}]
[]
["1003.15.1",30.01,"Supply and Deliver"]
[]
[null,"30.01.01","1 Ton manually operated chain hoist complete with accessories ","No.",1]
[]
["1003.15.2",30.02,"Installation, Testing and Commissioning"]
[]
[null,"30.02.01","1 Ton manually operated chain hoist complete with accessories ","No.",1]
{"$rows_empty":39}
["Total carried to summary"]
[]
[]
[{"$nulls":6},"VENTILATION"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT"," QUAN- "," RATE ","AMOUNT"]
["REFERS","NO",null,null," TITY "]
[]
[]
["ZUT 1008",40,"VENTILATION",{"$nulls":3},{"$f":"IF($E130>0,IF($E130=\"-\",\"Rate Only\",$E130*F130),\"\")","v":""}]
[]
[null,null,"DRAWING 111242-0000-DR-WW-0516 and 0518",{"$nulls":3},{"$f":"IF($E132>0,IF($E132=\"-\",\"Rate Only\",$E132*F132),\"\")","v":""}]
[]
["1008.17.1",40.01,"Supply and Deliver"]
[]
[null,"40.01.01","Louvred roof cowls, complete with shoe, upstand base bracket and vermin mesh 1000 mm (W) x 1000 mm (B) x 660 mm (H)","No.",2]
[]
[null,"40.01.02","400 Diam. Jet Fans, complete with anti-vibration ceiling mount foot brackets and earthing connections","No.",3]
[]
["1008.17.2",40.02,"Installation, Testing and Commissioning"]
[]
[null,"40.02.01","Louvred roof cowls, complete with shoe, upstand base bracket and vermin mesh 1000 mm (W) x 1000 mm (B) x 660 mm (H)","No.",2]
[]
[null,"40.02.02","400 Diam. Jet Fans, complete with anti-vibration ceiling mount foot brackets and earthing connections","No.",3]
[]
[null,null,"DRAWING 111242-0000-DR-WW-0516 to 0517"]
[]
["1008.17.1",40.03,"Supply and Deliver"]
[]
[null,"40.03.01","Ventilation supply system for Chamber 1:\n- 2 x Axial fans complete with floor mouted foot brackets and earthing connection - 3240 l/s @ 400 Pa.\n- 2 x 2.2 kW, 3 phase isolators.\n- Associated air terminals, spiral ducting, fittings, plenums, filter banks, support brackets and ancillaries as per drawing 111242-DR-WW-0516\n","No.",1]
[]
[null,"40.03.02","Ventilation extraction system for the Chamber 2:\n- 2 x Axial fans complete with floor mouted foot brackets and earthing connection - 3240 l/s @ 200 Pa.\n- 2 x 2.2 kW, 3 phase isolators.\n- Associated air terminals, spiral ducting, fittings, support brackets and ancillaries as per drawing 111242-DR-WW-0517.\n","No.",1]
[]
[null,"40.03.03","Control panel, thermostats and connections","No.",1]
[]
["Total carried to summary"]
[]
[]
[{"$nulls":6},"VENTILATION"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT"," QUAN- "," RATE ","AMOUNT"]
["REFERS","NO",null,null," TITY "]
[]
[]
["1008.17.2",40.04,"Installation, Testing and Commissioning"]
[]
[null,"40.04.01","Ventilation system for the Pressure Reducing Valve Chamber (see item 40.03.01 and 40.03.03)","No.",1]
[]
[null,40.05,"Others"]
[]
[null,"40.05.01","Others (please state any other items necessary to complete the installation and allow full functionality the ventilation system)","Sum",1]
[null,null,"P&G's for Ventilation system","Sum",1]
{"$rows_empty":44}
["Total carried to summary"]
[]
[]
[{"$nulls":6},"PRESSURE REDUCING VALVE SYSTEM"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT"," QUAN- "," RATE ","AMOUNT"]
["REFERS","NO",null,null," TITY "]
[]
[]
[null,900,"PRESSURE REDICUNG VALVE SYSTEM"]
[]
[null,null,"DRAWING 111242-0000-DR-WW-0519 and 0520"]
[]
[null,900.01,"Supply, Deliver "]
[]
[null,"900.01.01","Concentric Reducer, DN700 x DN300 x 6 mm SANS 719 Grade C; Flanged both ends SANS 1123 Table 1600/3 (RF)","No",2]
[]
[null,"900.01.02","DN300 x 6 mm 90 Degree Elbow SANS 719 Grade C; Flanged both ends SANS 1123 Table 1600/3 (RF)","No",4]
[]
[null,"900.01.03","DN300 x 10 mm Cross-Tee SANS 719 Grade C; Flanged all ends SANS 1123 Table 1600/3 (RF)","No",2]
[]
[null,"900.01.04","Resilient Seal Gate Valve DN300 PN16; Flanged SANS 1123 Table 1600/3 (RF)","No",6]
[]
[null,"900.01.05","Dismantling Joint DN300 PN16; Flanged SANS 1123 Table 1600/3 (RF)","No",9]
[]
[null,"900.01.06","Spool Piece DN300 x 6 mm SANS 719 Grade C; Flanged both ends SANS 1123 Table 1600/3 (RF)","No",3]
[]
[null,"900.01.07","Orifice Plate DN300 with 159 mm Opening","No",3]
[]
[null,"900.01.08","Spool Piece DN300 x 6 mm SANS 719 Grade C; Flanged both ends SANS 1123 Table 1600/3 (RF) With pipe anchor support","No",3]
[]
[null,"900.01.09","Pressure Reducing Valve DN300 PN16, Flanged both ends SANS 1123 Table 1600/3 (RF)","No",3]
[]
[null,"900.01.10","Spool Piece DN300 x 6 mm SANS 719 Grade C; Flanged both ends SANS 1123 Table 1600/3 (RF) With pipe anchor support","No",3]
[]
[null,"900.01.11","Strainer DN300 PN16; Flanged both ends SANS 1123 Table 1600/3 (RF)","No",3]
[]
[null,900.02,"Installation Testing and Commissioning "]
[]
[null,"900.02.01","Concentric Reducer, DN700 x DN300 x 6 mm SANS 719 Grade C; flanged both ends SANS 1123 Table 1600/3 (RF)","No",2]
[]
[null,"900.02.02","DN300 x 6 mm 90 Degree Elbow SANS 719 Grade C; Flanged both ends SANS 1123 Table 1600/3 (RF)","No",4]
[]
[null,"900.02.03","DN300 x 10 mm Cross-Tee SANS 719 Grade C; Flanged all ends SANS 1123 Table 1600/3 (RF)","No",2]
[]
[null,"900.02.04","Resilient Seal Gate Valve DN300 PN16; Flanged SANS 1123 Table 1600/3 (RF)","No",6]
[]
[null,"900.02.05","Dismantling Joint DN300 PN16; Flanged SANS 1123 Table 1600/3 (RF)","No",9]
[]
[null,"900.02.06","Spool Piece DN300 x 6 mm SANS 719 Grade C; Flanged both ends SANS 1123 Table 1600/3 (RF)","No",3]
[]
[]
[]
[]
["Total carried to summary"]
[]
[]
[{"$nulls":6},"PRESSURE REDUCING VALVE SYSTEM"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT"," QUAN- "," RATE ","AMOUNT"]
["REFERS","NO",null,null," TITY "]
[]
[]
[null,"900.02.07","Orifice Plate DN300 with 159 mm Opening","No",3]
[]
[null,"900.02.08","Spool Piece DN300 x 6 mm SANS 719 Grade C; Flanged both ends SANS 1123 Table 1600/3 (RF) With pipe anchor support","No",3]
[]
[null,"900.02.09","Pressure Reducing Valve DN300 PN16, Flanged both ends SANS 1123 Table 1600/3 (RF)","No",3]
[]
[null,"900.02.10","Spool Piece DN300 x 6 mm SANS 719 Grade C; Flanged both ends SANS 1123 Table 1600/3 (RF) With pipe anchor support","No",3]
[]
[null,"900.02.11","Strainer DN300 PN16; Flanged both ends SANS 1123 Table 1600/3 (RF)","No",3]
{"$rows_empty":51}
["Total carried to summary"]
[]
[]
[{"$nulls":6},"SUMMARY"]
[]
[]
["PAYMENT","ITEM","DESCRIPTION","UNIT"," QUAN- "," RATE ","AMOUNT"]
["REFERS","NO",null,null," TITY "]
[]
[]
["SUM",null,"SUMMARY"]
[]
["ZUT 0002",null,"Operating and Maintenance Manuals"]
[]
["ZUT 1003",null,"Lifting Equipment"]
[]
["ZUT 1008",null,"Ventilation"]
[]
["ZUT",null,"Pressure Reducing Valve System"]
{"$rows_empty":49}
["TOTAL MECHANICAL WORKS CARRIED TO SUMMARY"]

{"sheet":"SANS-SUM","index":18,"n_rows":65,"n_cols":8,"rows_kept":65,"merged":[[2,2,2,4]]}
["JOHANNESBURG WATER"]
[]
["CONTRACT NO",null,"JW 14463"]
[]
["FOR",null,"HALFWAY HOUSE WATER UPGRADE PROJECT"]
[]
["SUMMARY OF SCHEDULE OF QUANTITIES: BULK WATER PIPELINE"]
[]
["SANS 1200 A",":","GENERAL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"R",null,{"v":566652.45,"d":"566,652.45"},{"$f":"F9+G9","v":{"v":566652.45,"d":"566,652.45"}}]
[]
["SANS 1200 A.1",":","GENERAL (SMME VALUE OF WORK) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"R"]
[]
["SANS 1200 C",":","SITE CLEARANCE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"R",null,{"v":3593438,"d":"3,593,438.00"},{"$f":"F13+G13","v":{"v":3593438,"d":"3,593,438.00"}}]
[]
["SANS 1200 D",":","EARTHWORKS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"R",null,{"v":59400,"d":"59,400.00"},{"$f":"F15+G15","v":{"v":59400,"d":"59,400.00"}}]
[]
["SANS 1200 DB",":","EARTHWORKS (PIPE TRENCHES) . . . . . . . . . . . . . . . . . . . . . . .  . . . . . . . . .",null,"R",null,null,{"$f":"F17+G17","v":{"v":0,"d":"0.00"}}]
[]
["SANS 1200 DK",":","GABIONS AND PITCHING . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"R",null,{"v":124845,"d":"124,845.00"},{"$f":"F19+G19","v":{"v":124845,"d":"124,845.00"}}]
[]
["SANS 2001 CC1",":","CONCRETE (STRUCTURAL) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"R",null,null,{"$f":"F21+G21","v":{"v":0,"d":"0.00"}}]
[]
["SANS 1200 HA",":","STRUCTURAL STEELWORK (SUNDRY ITEMS) . . . . . . . . . . . . . . . . . . . . . . .",null,"R",null,null,{"$f":"F23+G23","v":{"v":0,"d":"0.00"}}]
[]
["SANS 1200 L",":","MEDIUM-PRESSURE PIPELINES. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"R",null,null,{"$f":"F25+G25","v":{"v":0,"d":"0.00"}}]
[]
["SANS 1200 LB",":","BEDDING (PIPES) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"R",null,null,{"$f":"F27+G27","v":{"v":0,"d":"0.00"}}]
[]
["SANS 1200 LE",":","STORMWATER DRAINAGE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"R",null,null,{"$f":"F29+G29","v":{"v":0,"d":"0.00"}}]
[]
["SANS 1200 LG",":","PIPE JACKING . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ",null,"R",null,null,{"$f":"F31+G31","v":{"v":0,"d":"0.00"}}]
[]
["SANS 1200 ME",":","SUBBASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"R"]
[]
["SANS 1200 MF",":","BASE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"R",null,null,{"$f":"F35+G35","v":{"v":0,"d":"0.00"}}]
[]
["PARTICULAR SPECIFICATION PC: DIRECTIONAL DRILLING . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",{"$nulls":3},"R",null,null,{"$f":"F37+G37","v":{"v":0,"d":"0.00"}}]
[]
["PARTICULAR SPECIFICATION PD: BUILDING WORK . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",{"$nulls":3},"R",null,null,{"$f":"F39+G39","v":{"v":0,"d":"0.00"}}]
[]
["ELECTRICAL          :     . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . ",null," . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"R",null,null,{"$f":"F41+G41","v":{"v":0,"d":"0.00"}}]
[]
["MECHANICAL          :     . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . ",null," . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  . . . . . . . . . . . . . . . . . . . . . . . . . . . .",null,"R"]
[]
[]
["TOTAL OF SCHEDULE OF QUANTITIES CARRIED TO CALCULATION OF TENDER SUM",{"$nulls":3},"R",null,{"$f":"SUM(G9:G44)","v":{"v":4344335.45,"d":"4,344,335.45"}},{"$f":"F46+G46","v":{"v":4344335.45,"d":"4,344,335.45"}}]
[]
[]
["CALCULATION OF TENDER SUM"]
[]
["TOTAL OF SCHEDULE OF QUANTITIES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",{"$nulls":3},"R",null,{"$f":"G46/F46","v":{"$error":"#DIV/0!"}},{"$f":"H46","v":{"v":4344335.45,"d":"4,344,335.45"}}]
[]
["CONTINGENCIES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",{"$nulls":3},"R"]
["The tenderer shall add 10% of the total of Schedule of Quantities for Contingencies"]
[]
["ESCALATION (6.7%). . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",{"$nulls":3},"R"]
[]
[]
["SUBTOTAL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",{"$nulls":3},"R",null,null,{"$f":"SUM(H50:H58)","v":{"v":4344335.45,"d":"4,344,335.45"}}]
[]
["VALUE-ADDED TAX (VAT) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .  . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .",{"$nulls":3},"R"]
["The tenderer shall add 15% of the subtotal for value-added tax",{"$nulls":6},{"$f":"H59*0.15","v":{"v":651650.3175,"d":"651,650.32"}}]
[]
[]
["TENDER SUM CARRIED TO FORM OF TENDER",{"$nulls":3},"R",null,null,{"$f":"SUM(H59:H64)","v":{"v":4995985.7675,"d":"4,995,985.77"}}]