{"text_format":"3","workbook":"xlsx","n_sheets":16,"sheets":["Sheet1","PRELIMINARIES AND GENERAL","EARTHWORKS","ROADS","STORMWATER","SEWER&POTABLE","SCOUR","COLLECTION CHAMBER","BULK PIPE_PHASE1","BULK PIPE_PHASE2","BULK PIPE_PHASE3","BULK PIPE_PHASE4","BULK PIPE_PHASE5","LANDSCAPE","RESERVOIR","TOTAL SUMMARY PAGE"],"not_rendered":{"external_links":37,"defined_names":864},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[0,0,58,0]]}
["                         Bill of Quantities\n\nIt is the Tenderer's responsibility to price all items in the Bill of Quantities in accordance with the enquiry document requirements, including but not limited to the Scope of works, drawings and conditions of contract . All items should be priced and where items are not required, they should be stated as Not Required."]

{"sheet":"PRELIMINARIES AND GENERAL","index":1,"n_rows":249,"n_cols":7,"rows_kept":249}
["ITEM NO.","PAY REF.","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION NO. 1 - PRELIMINARIES AND GENERAL"]
[]
[null,null,"PRELIMINARIES AND GENERAL "]
[]
[null,null,"Note: It is the Tenderer's responsibility to price the Preliminaries and General in accordance with all the information provided in the enquiry document and complaince to all the OHS Acts, Environmental and Quality plans and Construction regulations"]
[]
[null,null,"BILL NO. 1.1"]
[]
[null,null,"FIXED CHARGE ITEMS "]
[]
[null,null,"Value Added Tax "]
[]
[null,null,"All rates and prices shall be net, exclusive of Value Added Tax"]
[]
[null,null,"Reference to contract "]
[]
[null,null,"The items in the bill of provisional quantities shall be read in conjunction with all other relevant parts of this document."]
[]
[null,null,"Note: All requirements not specified are deemed to be included in the general pricing."]
[]
[null,null,"Fixed Charge Items "]
[]
[null,null,"The sums stated for items under this heading shall cover the cost of providing, establishing and commissioning on the site the facilities adequately equipped to enable all the work to commence and to proceed to completion as required in terms of the contract. The sums shall also cover (where appropriate) the cost of demolition of and  the removal from site of all items established and shall include for making good and restoring the site to the satisfaction of the Project Manager and/or Engineer"]
[]
[]
["","8.3.3","Specific requirements"]
[""]
[1,null,"Provision of security for Contract duration","Months",18]
{"$rows_empty":43}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"PRELIMINARIES AND GENERAL "]
[]
[null,null,"BILL NO. 1.2"]
[]
[null,null,"TIME RELATED ITEMS "]
[]
[null,"8.4.1","Contractual Requirements ","Sum",1]
[]
[null,8.5,"Sums stated provisionally by the Engineer"]
[]
[1,"8.5.2","Training of labour","Prov sum",1,{"v":250000,"d":"250,000.00"},{"$f":"E86*F86","v":{"v":250000,"d":"250,000.00"}}]
[]
[{"$f":"A86+1","v":2},null,"Overheads, charges and profit on item 84","%",{"$f":"F86","v":{"v":250000,"d":"250,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E88*F88","v":{"v":25000,"d":"25,000.00"}}]
[]
[{"$f":"A88+1","v":3},"PSSC 9","Provide administrative, planning and on the job training to SMME's","Prov sum",{"v":1,"d":"1.00"},{"v":216000,"d":"216,000.00"},{"$f":"F90","v":{"v":216000,"d":"216,000.00"}}]
[]
[{"$f":"A90+1","v":4},"PSSC 10","Overhead, charges and profit on SMME training","%",{"$f":"F90","v":{"v":216000,"d":"216,000.00"}},{"v":0.1,"d":"10%"},{"$f":"E92*F92","v":{"v":21600,"d":"21,600.00"}}]
[]
[null,8.7,"Daywork (Provisional)"]
[]
[{"$f":"A92+1","v":5},null,"Allowance for labour","Prov sum",1,{"v":2000000,"d":"2,000,000.00"},{"$f":"E96*F96","v":{"v":2000000,"d":"2,000,000.00"}}]
{"$rows_empty":64}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL PRELIMINARIES AND GENERAL"]
[]
[null,null,"PRELIMINARIES (FIXED CHARGE ITEMS)"]
[]
[null,null,"PRELIMINARIES (TIME RELATED ITEMS)"]
{"$rows_empty":81}
[null,null,"TOTAL SECTION"]

{"sheet":"EARTHWORKS","index":2,"n_rows":446,"n_cols":7,"rows_kept":446}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null,"SECTION 2.1 :  BULK EARTHWORKS"]
[]
[null,"SANS 1200 C","BILL NO.1 :SITE CLEARANCE"]
[]
[null,null,"Reference Drawing.: Reservoir and tower"]
[]
[null,"PSC 8.2.1","Clear and grub:"]
[]
[1,null,"Total Site Areas","m²",13600]
[]
[null,"8.2.2","Remove and grub large trees and tree stumps of girth:"]
[]
[2,null,"Over 2,0 m and up to and including 3,0 m","No.",3]
{"$rows_empty":72}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 HA","BILL NO.3 STRUCTURAL STEELWORK (SUNDRY ITEMS)"]
[]
[null,"8.3.2","Handrails:"]
[]
[null,null,"Handrail assembly complete:"]
[]
[1,null,"Horizontal       ","m",50]
[]
[2,null,"Sloping (measured on slope)  ","m",10]
[]
[3,null,"Shaped Ends","No.",8]
{"$rows_empty":76}
[null,null,"Total - Carried to Summary"]
[]
[null,"PZ","BILL NO.4 : PATENTED EARTH RETAINING SYSTEMS"]
[]
[null,"PZ.01","Patented earth retaining systems:"]
[]
[null,null,"Loffelstein precast concrete blocks of type:"]
[]
[1,null,"L300, at 35°","m²",80]
{"$rows_empty":80}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 2001 CC1 ","BILL NO. 5 : CONCRETE (STRUCTURAL)"]
[]
[null,"SD8.6","Manufacture (or supply) and erect precast concrete units:"]
[]
[1,null,"Concrete access steps","No",1]
{"$rows_empty":82}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL BULK EARTHWORKS"]
[]
[null,null,"SITE CLEARANCE"]
[]
[null,null,"STRUCTURAL STEELWORK (SUNDRY ITEMS)"]
[]
[null,null,"PATENTED EARTH RETAINING SYSTEMS"]
[]
[null,null,"CONCRETE (STRUCTURAL)"]
{"$rows_empty":78}
[null,null,"TOTAL SECTION"]

{"sheet":"ROADS","index":3,"n_rows":706,"n_cols":10,"rows_kept":706}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null,"SECTION 2.2 : ROADS"]
[]
[null,"SANS 1200 D","BILL NO.1 : EARTHWORKS"]
[]
[null,null,"Reference Drawing.: 113503-0000-DRG-1300"]
[]
[null,"PSD 8.3.2","Bulk excavation:"]
[]
[null,null,"Excavate in all materials and use for embankment or backfill as ordered from:"]
[]
[1,null,"Necessary excavations","m³",{"$f":"+J15*0.15","v":{"v":1402.17,"d":"1402"}},{"$nulls":3},{"$f":"4249*1.1","v":{"v":4673.900000000001,"d":"4674"}},{"$f":"+I15/0.5","v":{"v":9347.800000000001,"d":"9,347.80"}}]
[]
[null,"PSD 8.3.2","Extra over items 1 to 2 above for :"]
[]
[{"$f":"+A15+1","v":2},null,"Hard rock excavation     ","m³",0]
[]
[{"$f":"+A19+1","v":3},null,"Extra over item 140.02 for hand excavation","m³",10]
[]
[{"$f":"+A21+1","v":4},"8.3.9","Extra over items 1 for backfill or for fill material against structures ","m³",{"$f":"+(3.5+20)*0.5*1*1.1","v":{"v":12.925,"d":"13"}}]
[]
[{"$f":"+A23+1","v":5},"PSD 8.3.15","Extra over items 1 for disposing of spoil material on a site provided by the Contractor","m³",{"$f":"+I15-E15","v":{"v":3271.7300000000005,"d":"3272"}}]
{"$rows_empty":62}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 DM","BILL NO. 2 : EARTHWORKS (ROADS, SUBGRADE)"]
[]
[null,"PSDM 8.3.3","Treatment of roadbed:"]
[]
[null,null,"Roadbed preparation and compaction of material to:"]
[]
[1,null,"Scarify insitu material 150mm deep and recompact to 90% modified AASHTO maximum density","m³",{"$f":"+J15*0.15*1.1","v":{"v":1542.3870000000002,"d":"1542"}}]
[]
[{"$f":"+A96+1","v":2},"PSDM 8.3.5","C4 layer compacted to 95% of modified AASHTO maximum density","m³",{"$f":"+E96","v":{"v":1542.3870000000002,"d":"1542"}}]
[]
[{"$f":"+A98+1","v":3},null,"G7 compacted to 93% of modified AASHTO maximum density","m³",{"$f":"+E96","v":{"v":1542.3870000000002,"d":"1542"}}]
{"$rows_empty":74}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 2001 CC1 ","BILL NO.3 : PRECAST CONCRETE"]
[]
[]
[null,"SD8.6","Provide structral precast unit"]
[]
[1,null,"300mm x 300mm Anchor Beams","m",35]
{"$rows_empty":81}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 ME","BILL NO.4  : SUBBASE"]
[]
[null,"PSME 8.3.5","Process subbase material by one of the following processes, as relevant, and use in the subbase:"]
[]
[1,null,"Stabilization   ","m³",{"$f":"+E96","v":{"v":1542.3870000000002,"d":"1542"}}]
[]
[null,"PSME 8.3.8","Stabilizing agent:"]
[]
[{"$f":"+A270+1","v":2},null,"Portland cement           ","t",{"v":5.7,"d":"6"}]
[]
[null,"PSME 8.3.11","Treatment of subbase with:"]
[]
[{"$f":"+A274+1","v":3},null,"Weed killer              ","m²",{"$f":"+J15","v":{"v":9347.800000000001,"d":"9348"}}]
[]
[{"$f":"+A278+1","v":4},null,"Insecticide              ","m²",{"$f":"+E278","v":{"v":9347.800000000001,"d":"9348"}}]
{"$rows_empty":71}
[null,null,"Total - Carried to Summary"]
[]
[]
[null,"SANS 1200 MJ","BILL NO.5  : SEGMENTED PAVING"]
[]
[null,"PSMJ 8.2.1","Provision of edge restraints:"]
[]
[null,"PSMJ 8.2.2","Construction of paving complete:"]
[]
[1,null,"Type S-A blocks, 80 mm thick, grey interlocking pavers","m²",{"$f":"+J15","v":{"v":9347.800000000001,"d":"9348"}}]
[]
[null,"PSMJ 8.2.3","Cutting blocks to fit edge restraints:"]
[]
[{"$f":"+A361+1","v":2},null,"Straight cutting","m",{"$f":"156+((35+65+23)*2*1.1)+(36*2*1.1)","v":{"v":505.8,"d":"506"}}]
[]
[{"$f":"+A365+1","v":3},null,"Circular cutting","m",{"$f":"+(31+7)*2*1.1","v":{"v":83.60000000000001,"d":"84"}}]
[]
[{"$f":"+A367+1","v":4},"PSMJ 8.2.4","Rolling to locked-up condition as specified in Clause 5.6.2","m²",{"$f":"+E280","v":{"v":9347.800000000001,"d":"9348"}}]
{"$rows_empty":71}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 MM","BILL NO.6 : ANCILLARY ROADWORKS"]
[]
[null,null,"ROAD MARKINGS"]
[]
[null,"8.4.1","Proprietary brand road marking material applied at nominal rate of 0,42 litre/m²:"]
[]
[null,null,"White lines (broken or unbroken):"]
[]
[1,null,"100 mm wide ","m",300]
[]
[null,"8.4.1","Non-reflectorized paint applied at nominal rate of 0,42 litre/m²:"]
[]
[null,null,"White lines (broken or unbroken):"]
[]
[2,null,"100 mm wide ","m",300]
{"$rows_empty":70}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 MK","BILL NO.7 : KERBING AND CHANNELLING"]
[]
[]
[null,"PSMK 8.2.1","Precast concrete kerbing:"]
[]
[1,null,"Non mountable kerbs","m",650]
[]
[2,null,"Mountable Kerb","m",20]
{"$rows_empty":79}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL ROADS"]
[]
[null,null,"EARTHWORKS"]
[]
[null,null,"EARTHWORKS (ROADS,SUBGRADE)"]
[]
[null,null,"PRECAST ONCRETE (STRUCTURAL)"]
[]
[null,null,"SUBBASE"]
[]
[null,null,"SEGMENTED PAVING"]
[]
[null,null,"ANCILLARY ROADWORKS"]
[]
[null,null,"KERBING AND CHANNELING"]
{"$rows_empty":72}
[null,null,"TOTAL SECTION"]

{"sheet":"STORMWATER","index":4,"n_rows":862,"n_cols":11,"rows_kept":862}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null,"SECTION 2.3 :  STORMWATER"]
[]
[null,"SANS 1200 D","BILL NO.1 : EARTHWORKS"]
[]
[null,"PSD 8.3.2","Bulk excavation:"]
[]
[null,null,"Excavate in all materials for stormwater attenuation pond and use for embankment or backfill as ordered from:"]
[]
[1,null,"   Necessary excavations","m³",{"$f":"K13*I13","v":{"v":657.9913971539457,"d":"658"}},{"$nulls":3},{"v":0.3667529107373868,"d":"37%"},null,{"$f":"1631*1.1","v":{"v":1794.1000000000001,"d":"1,794.10"}}]
[]
[2,null,"Excavate in all materials for stormwater attenuation pond and dispose","m³",{"$f":"K13*I15","v":{"v":1136.1086028460545,"d":"1136"}},{"$nulls":3},{"v":0.6332470892626132,"d":"63%"}]
[]
[null,null,"Extra over items 1 and 2 for:"]
[]
[3,null,"    Intermediate excavation  ","m³",{"$f":"K13*I19","v":{"v":807.0838923027169,"d":"807"}},{"$nulls":3},{"v":0.44985446313065985,"d":"45%"}]
[]
[4,null,"    Hard rock excavation    ","m³",{"$f":"K13*I21","v":{"v":987.0161076972834,"d":"987"}},{"$nulls":3},{"v":0.5501455368693402,"d":"55%"}]
[]
[null,"PSD 8.3.3","Restricted excavation:"]
[]
[null,null,"Excavate for stormwater attenuation pond spillway in all materials, and use for backfill or embankment, or dispose:"]
[]
[5,null,"    Depth up to 1,0 m      ","m³",{"v":10.23,"d":"10"}]
[]
[6,null,"    Depth over 1,0 m and up to 2,0 m ","m³",{"v":10.23,"d":"10"}]
[]
[7,null,"    Depth over 2,0 m and up to 3,0 m ","m³",{"v":13.640000000000002,"d":"14"}]
[]
[null,"PSD 8.3.3","Extra over items 5, 6, and 7 for:"]
[]
[8,null,"   Intermediate excavation  ","m³",{"$f":"E27+E29+E31","v":{"v":34.1,"d":"34"}}]
[]
[9,null,"Extra over items 5, 6, and 7 for hand excavation","m³",{"v":3.41,"d":"3"}]
[]
[null,"PSD 8.3.6","Overhaul:"]
[]
[10,null,"Limited overhaul","m³",null,null,"Rate only"]
[{"$nulls":6},{"$f":"IF(OR(AND(E42=\"Prov\",F42=\"Sum\"),(F42=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E42*F42),\"\",IF(E42*F42=0,\"\",ROUND(E42*F42,2))))","v":""}]
[11,null,"Long overhaul","m³-km",null,null,"Rate only"]
[]
[null,"PSD 8.3.8","Existing services:"]
[]
[null,null,"Hand excavation for locating and exposing existing services:"]
[]
[12,null,"    In all other areas for stormwater attenuation pond and spillway","m³",null,null,"Rate only"]
[]
[null,"8.3.9","Extra over items 1, 2, 5, 6, and 7 for backfill or for fill material against "]
[]
[13,null,"    Attenuation pond and compact to 93% MOD AASHTO density","m³",{"$f":"1103*1.1*0.15","v":{"v":181.99500000000003,"d":"182"}}]
[]
[14,null,"    Attenuation pond cement stabilised and compact to\n    95% MOD AASHTO density","m³",{"$f":"E53","v":{"v":181.99500000000003,"d":"182"}}]
[]
[15,null,"    Stormwater attenuation pond spillway and compact to \n    95% MOD AASHTO density","m³",{"$f":"30*1.1*0.15","v":{"v":4.95,"d":"5"}}]
[]
[null,"PSD 8.3.10","Topsoiling:  "]
[]
[null,null,"Use topsoil material for:"]
[]
[16,null,"   Preparation layer for grassing at attenuation pond","m³",{"$f":"E53","v":{"v":181.99500000000003,"d":"182"}}]
[]
[null,"8.3.11","Grassing or other vegetation cover:"]
[]
[17,null,"Planting of grass cuttings on attenuation pond surface","m²",{"$f":"1103*1.1","v":{"v":1213.3000000000002,"d":"1213"}}]
[]
[18,"PSD 8.3.14","Extra over items 1, 5, 6, and 7 for temporary stockpiling","m³",{"$f":"+E13+E27+E29+E31","v":{"v":692.0913971539458,"d":"692"}}]
[]
[19,"PSD 8.3.15","Extra over item 2 for disposing of spoil material on a site provided by the Contractor","m³",{"$f":"E15","v":{"v":1136.1086028460545,"d":"1136"}}]
{"$rows_empty":11}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 DB","BILL NO.2 : EARTHWORKS (PIPE TRENCHES)"]
[]
[null,"PSDB 8.3.2","Excavate in all materials for trenches, backfill, compact and dispose of surplus material:"]
[]
[null,null," Pipes over 400 mm dia up to 675 mm dia for depths:"]
[]
[1,null,"    Up to 1,0 m      ","m",{"$f":"141*1.1","v":{"v":155.10000000000002,"d":"155"}}]
[]
[{"$f":"+A91+1","v":2},null,"    Over 1,0 m up to 2,0 m    ","m",{"$f":"271*1.1","v":{"v":298.1,"d":"298"}}]
[]
[{"$f":"+A93+1","v":3},null,"    Over 2,0 m up to 3,0 m    ","m",{"$f":"6*1.1","v":{"v":6.6000000000000005,"d":"7"}}]
[]
[{"$f":"A95+1","v":4},"PSDB 8.3.2","Excavate in all materials for stormwater junction boxes and the like, irrespective of depth, and backfill around structures","m³",{"$f":"52*(1*1)*2*1.1","v":{"v":114.4,"d":"114"}}]
[]
[null,"PSDB 8.3.2","Excavate open drains in all materials     "]
[]
[{"$f":"+A97+1","v":5},null,"Concrete stormwater channel","m³",{"$f":"353*0.5*1*1.1","v":{"v":194.15,"d":"194"}}]
[]
[null,"PSDB 8.3.2","Extra over items 4 and 5 for excavating in:"]
[]
[{"$f":"A101+1","v":6},null,"   Intermediate material","m³",{"$f":"+E101","v":{"v":194.15,"d":"194"}}]
[]
[null,"PSDB 8.3.3","Excavation ancillaries:"]
[]
[null,null,"Make up deficiency in backfill material:"]
[]
[{"$f":"+A105+1","v":7},null,"    From other necessary excavations on site for fill material \n    against concrete stormwater channels and compact to\n    95% MOD","m³",{"$f":"353*0.15*1*1.1","v":{"v":58.245,"d":"58"}}]
[]
[null,null,"    Overhaul:"]
[]
[{"$f":"A111+1","v":8},null,"    Limited overhaul        ","m³",null,null,"Rate only"]
[{"$nulls":6},{"$f":"IF(OR(AND(E116=\"Prov\",F116=\"Sum\"),(F116=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E116*F116),\"\",IF(E116*F116=0,\"\",ROUND(E116*F116,2))))","v":""}]
[{"$f":"+A115+1","v":9},null,"    Long overhaul","m³-km",null,null,"Rate only"]
[]
[null,"PSD 8.3.8","Existing services:"]
[]
[null,null,"Hand excavation for locating and exposing existing services:"]
[]
[{"$f":"+A117+1","v":10},null,"    In all other areas for stormwater channel 5","m³"]
{"$rows_empty":43}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 DK","BILL NO.3 : GABIONS AND PITCHING"]
[]
[null,"PSDK 8.2.5","Pitching:"]
[]
[null,null,"Grouted pitching:"]
[]
[1,null,"    Light pitching at attenuation pond headwalls","m²",{"v":39.7694,"d":"40"}]
{"$rows_empty":80}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 DM","BILL NO.4 : EARTHWORKS (ROADS, SUBGRADE)"]
[]
[null,null,"Preparation of site:"]
[]
[1,"8.3.2","Removal of topsoil to a depth of 150 mm, at attenuation pond and the stockpiling and maintenance thereof","m³",{"$f":"1118*0.15*1.1","v":{"v":184.47,"d":"184"}}]
[]
[null,"PSDM 8.3.3","Treatment of roadbed (stormwater channel layerworks):"]
[]
[null,null,"Layerworks preparation and compaction of material in 150mm layers to:"]
[]
[{"$f":"A262+1","v":2},null,"    Minimum of 90% MOD AASHTO maximum density for\n    stone pitching","m³",{"v":9.529905,"d":"10"}]
[]
[{"$f":"A268+1","v":3},null,"    Minimum of 93% MOD AASHTO maximum density for \n    attenuation pond","m³",{"$f":"+E262","v":{"v":184.47,"d":"184"}}]
[]
[{"$f":"A270+1","v":4},null,"    Minimum of 95% MOD AASHTO maximum density for \n    rectangular concrete channels","m³",{"$f":"353*0.15*1*1.1","v":{"v":58.245,"d":"58"}}]
[]
[{"$f":"A272+1","v":5},"8.3.11","    Extra over item 1 for temporary stockpiling of material","m³",{"$f":"+E262","v":{"v":184.47,"d":"184"}}]
[]
[null,null," Overhaul:"]
[]
[{"$f":"A274+1","v":6},null,"    Limited overhaul         ","m³",null,null,"Rate only"]
[{"$nulls":6},{"$f":"IF(OR(AND(E279=\"Prov\",F279=\"Sum\"),(F279=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E279*F279),\"\",IF(E279*F279=0,\"\",ROUND(E279*F279,2))))","v":""}]
[{"$f":"A278+1","v":7},null,"    Long overhaul     ","m³-km",null,null,"Rate only"]
{"$rows_empty":59}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 2001 CC1","BILL NO.5 : CONCRETE (STRUCTURAL)"]
[]
[null,null,"SCHEDULED FORMWORK ITEMS"]
[]
[null,"SD8.2.1","Rough:"]
[]
[null,null,"Sloping formwork to:"]
[]
[1,null,"    Attenuation pond spillway","m²",{"$f":"15*1.5*4*1.1","v":{"v":99.00000000000001,"d":"99"}}]
[]
[{"$f":"+A350+1","v":2},null,"   Concrete stormwater channels","m²",{"$f":"354*4*0.35*1.1","v":{"v":545.16,"d":"545"}}]
[]
[null,null,"SCHEDULED REINFORCEMENT ITEMS"]
[]
[null,"SD8.3.2","High-tensile welded mesh in the following:"]
[]
[{"$f":"+A352+1","v":3},null,"Stormwater channel mesh ref. 395","m²",{"$f":"354*1*1.1","v":{"v":389.40000000000003,"d":"389"}}]
[]
[{"$f":"+A358+1","v":4},null,"Attenuation pond spillway mesh ref. 395","m²",{"$f":"((15*5)+(15*1.5*2))*1.1","v":132}]
[]
[null,null,"SCHEDULED CONCRETE ITEMS"]
[]
[null,"SD8.4.3","Strength concrete:"]
[]
[null,null,"Class 25 MPa/ 19 mm concrete in:"]
[]
[{"$f":"+A360+1","v":5},null,"   Stormwater channel","m³",{"$f":"354*0.15*1*1.1","v":{"v":58.410000000000004,"d":"58"}}]
[]
[{"$f":"+A368+1","v":6},null,"   Attenuation pond spillway","m³",{"$f":"15*5*0.15*1.1","v":{"v":12.375000000000002,"d":"12"}}]
[]
[null,"SD8.4.4","Unformed surface finishes:"]
[]
[null,null,"Wood-floated finishes to:"]
[]
[{"$f":"+A370+1","v":7},null,"    Stormwater channels","m²",{"$f":"+E358","v":{"v":389.40000000000003,"d":"389"}}]
[]
[{"$f":"+A376+1","v":8},null,"    Attenuation pond spillway","m²",{"$f":"+E360","v":132}]
[]
[null,"SD8.5","Joints:"]
[]
[null,null,"5mm thick 'Jointex' or similar approved joint former with 10mm tear-off strip, and sealing of joints with 10x10 'Flexolastic T' hot poured primerless tar based joint sealant or similar approved:"]
[]
[{"$f":"+A378+1","v":9},null,"    Stormwater channel","m²",{"$f":"+(118)*0.15*1*1.1","v":{"v":19.470000000000002,"d":"19"}}]
[]
[{"$f":"+A384+1","v":10},null,"    Attenuation pond spillway","m²",{"$f":"+(5)*0.15*5*1.1","v":{"v":4.125,"d":"4"}}]
[]
[null,"SD8.4.8","Screeds:"]
[null,null,"Channel floor screeds (1:3) with falls including V-joints to form panels and a smooth steel-trowelled finish/power float finish to top:"]
[]
[{"$f":"+A386+1","v":11},null,"15 Mpa stormwater rectangular channel","m²",{"$f":"354*1*1.1","v":{"v":389.40000000000003,"d":"389"}}]
{"$rows_empty":33}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 HA","BILL NO.6 : STRUCTURAL STEELWORK (SUNDRY ITEMS)"]
[]
[null,"8.3.4","Flooring, complete and installed with frames: "]
[]
[1,null,"Galvanised steel rectagrid RS40 with 50 x 4.5mm bearers","m²",{"$f":"207*0.3*1.1","v":{"v":68.31,"d":"68"}}]
{"$rows_empty":82}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 LB","BILL NO.7 : BEDDING (PIPES)"]
[]
[null,"8.2.2","Supply of bedding by importation:"]
[]
[null,null,"From commercial sources:"]
[]
[1,null,"Selected granular material       ","m³",{"$f":"1.05*1.2*354*J522*1.1","v":{"v":215.68697362204728,"d":"216"}},{"$nulls":4},{"v":0.4395997375328084,"d":"0.44"}]
[]
[2,null,"Selected fill material   ","m³",{"$f":"1.05*1.2*354*J524*1.1","v":{"v":274.9570263779528,"d":"275"}},{"$nulls":4},{"v":0.5604002624671915,"d":"0.56"}]
[]
[null,null,"Encasing of pipes in concrete:"]
[]
[3,null,"Class 25 MPa/19 mm","m³",{"$f":"45*1.2*1.05*1.1","v":{"v":62.37000000000001,"d":"62"}}]
{"$rows_empty":74}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 LE","BILL NO.8 : STORMWATER DRAINAGE"]
[]
[null,"8.2.1","Supply and lay concrete pipe culverts on class B bedding:"]
[]
[null,null,"Type SC 75D-load pipes with Spigot and Socket joints"]
[]
[1,null,"450mm dia","m",{"$f":"93*1.1","v":{"v":102.30000000000001,"d":"102"}}]
[]
[{"$f":"A611+1","v":2},null,"600mm dia","m",{"$f":"172*1.1","v":{"v":189.20000000000002,"d":"189"}}]
[]
[{"$f":"A613+1","v":3},null,"675mm dia","m",{"$f":"9*1.1","v":{"v":9.9,"d":"10"}}]
[]
[null,null,"Type SC 100D-load pipes with Spigot and Socket joints"]
[]
[{"$f":"A615+1","v":4},null,"450mm dia","m",{"$f":"109*1.1","v":{"v":119.9,"d":"120"}}]
[]
[{"$f":"A619+1","v":5},null,"600mm dia","m",{"$f":"16*1.1","v":{"v":17.6,"d":"18"}}]
[]
[{"$f":"A621+1","v":6},null,"675mm dia","m",{"$f":"20*1.1","v":22}]
[]
[null,"8.2.8","Supply and install manholes and the like:"]
[]
[null,null,"Brickwork manholes as shown on drawing no. 113503-0000-DRG-WD-1461"]
[]
[{"$f":"A623+1","v":7},null,"Up to 1.0m depth","number",0]
[]
[{"$f":"A629+1","v":8},null,"1.0m to 1.5m depth","number",8]
[]
[{"$f":"A631+1","v":9},null,"1.5m to 2.0m depth","number",3]
[]
[{"$f":"A633+1","v":10},null,"2.0m to 2.5m depth","number",2]
[]
[{"$f":"A635+1","v":11},null,"2.5m to 3.0m depth","number",0]
[]
[{"$f":"A637+1","v":12},null,"3.0m to 3.5m depth","number",2]
[]
[null,null,"Grid inlets as shown on drawing no. 113503-0000-DRG-WD-1462"]
[]
[{"$f":"A639+1","v":13},null,"Up to 1.0m depth","number",1]
[]
[{"$f":"A643+1","v":14},null,"1.0m to 1.5m depth","number",9]
[]
[{"$f":"A645+1","v":15},null,"1.5m to 2.0m depth","number",1]
[]
[{"$f":"A647+1","v":16},null,"2.0m to 2.5m depth","number",11]
[]
[null,null,"Inlet or Outlet structure (headwalls) as shown on drawing no. 113503-0000-DRG-WD-1463"]
[]
[{"$f":"A649+1","v":17},null,"Up to 1.0m depth","number",3]
[]
[null,null,"Supply and install manholes and the like:"]
[]
[null,null,"Double grid inlets:"]
[]
[{"$f":"A653+1","v":18},null,"As shown on drawing no 113503-0000-DRG-WD-1462 standard depth 1m     ","number",{"v":1.1,"d":"1"}]
[]
[null,null,"Junction boxes:"]
[]
[{"$f":"A659+1","v":19},null,"As shown on drawing no 113503-0000-DRG-WD-1461 standard depth 2m ","number",5]
[]
[null,null,"Extra over or under items 17, 18 and 19 for variation in depth of manholes from the standard depth designated for purposes of tendering:"]
[]
[null,null,"Double grid inlets:"]
[]
[{"$f":"A663+1","v":20},null,"As shown on drawing no 113503-0000-DRG-WD-1462 standard depth 1m      ","m",null,null,"Rate Only"]
[]
[null,null,"Junction boxes:"]
[]
[{"$f":"A669+1","v":21},null,"As shown on drawing no 113503-0000-DRG-WD-1461 standard depth 2m ","m",null,null,"Rate Only"]
[]
[null,"8.2.10","Accessories:"]
[]
[null,null,"Manhole covers including frames:"]
[]
[{"$f":"A673+1","v":22},null,"SANS 558 type 2A ","number",{"$f":"SUM(E629:E639)","v":15}]
[]
[null,null,"Grid inlet cover frames:"]
[]
[{"$f":"A679+1","v":23},null,"600mm x 600mm","number",{"$f":"SUM(E643:E649)","v":22}]
[]
[]
[]
[{"$f":"A683+1","v":24},null,"520mm x 790mm","number",{"$f":"E659","v":{"v":1.1,"d":"1"}}]
[]
[]
[{"$f":"A687+1","v":25},null,"Step irons  ","number",240]
[]
[null,"PSLE \n8.2.21","Break into existing stormwater kerb inlet, install new pipe and build new kerb inlet","sum",1]
{"$rows_empty":80}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL FOR STORMWATER"]
[]
[null,null,"EARTHWORKS"]
[]
[null,null,"EARTHWORKS (PIPE TRENCHES)"]
[]
[null,null,"GABIONS AND PITCHING"]
[]
[null,null,"EARTHWORKS (ROADS, SUBGRADE)"]
[]
[null,null,"CONCRETE (STRUCTURAL)"]
[]
[null,null,"STRUCTURAL STEELWORK (SUNDRY ITEMS)"]
[]
[null,null,"BEDDING (PIPES)"]
[]
[null,null,"STORMWATER DRAINAGE"]
{"$rows_empty":70}
[null,null,"TOTAL SECTION"]

{"sheet":"SEWER&POTABLE","index":5,"n_rows":617,"n_cols":7,"rows_kept":617}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,"SANS 1200 C","SECTION 2.4 : SEWER & POTABLE"]
[]
[null,null,"BILL NO.1 : SITE CLEARANCE"]
[]
[null,"8.2.8","Demolish and remove structures/buildings:",{"$nulls":3},""]
[]
[1,null,"Demolish and remove existing sewer pipe and manhole","sum  ",1]
{"$rows_empty":78}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 DB","BILL NO.2 : EARTHWORKS (PIPE TRENCHES)"]
[]
[null,null,"TRENCHES FOR WATER PIPES"]
[]
[null,"PSDB 8.3.2","Excavate in all materials for trenches, backfill, compact and dispose of surplus material:",{"$nulls":3},""]
[]
[null,null,"Pipes up to 125 mm dia for depths:",{"$nulls":3},""]
[]
[1,null,"Up to 1,0 m      ","m",{"$f":"(5+67+14+17+1+4+4+1)*1.1","v":{"v":124.30000000000001,"d":"124"}}]
[]
[null,null,"TRENCHES FOR SEWER PIPES"]
[]
[null,"PSDB 8.3.2","Excavate in all materials for trenches, backfill, compact and dispose of surplus material:"]
[]
[null,null,"Pipes up to 125 mm dia for depths:"]
[]
[2,null,"Up to 1,0 m      ","m",{"$f":"+(37+24+3)*1.1","v":{"v":70.4,"d":"70"}}]
{"$rows_empty":67}
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 L","BILL NO.3 : MEDIUM-PRESSURE PIPELINES"]
[]
[null,"8.2.1","Supply, lay and bed on flexible bedding, complete with couplings:",{"$nulls":3},""]
[]
[null,null,"HDPE PE 100 PN 12.5 SDR 13.6 pipes:"]
[]
[1,null,"25 mm dia","m",{"$f":"+E100","v":{"v":124.30000000000001,"d":"124"}}]
[]
[null,"8.2.2","Extra over items 1 for supplying, laying and bedding of HDPE specials complete with couplings:"]
[]
[null,null,"90° elbows:"]
[]
[{"$f":"+A184+1","v":2},null,"25mm dia ","No.",3]
[]
[null,null,"45° elbows:"]
[]
[{"$f":"+A190+1","v":3},null,"25mm dia ","No.",4]
[]
[null,null,"Tees:"]
[]
[{"$f":"+A194+1","v":4},null,"25 mm dia x 100 mm dia ","No.",1]
[]
[null,"PSL 8.2.11","Anchor/thrust blocks and pedestals:"]
[]
[null,null,"Concrete:"]
[]
[{"$f":"+A198+1","v":5},null,"Class 30MPa/19 mm","m³",1]
{"$rows_empty":56}
[{"$nulls":6},{"$f":"IF(OR(AND(E261=\"Prov\",F261=\"Sum\"),(F261=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E261*F261),\"\",IF(E261*F261=0,\"\",ROUND(E261*F261,2))))","v":""}]
[]
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 LB","BILL NO.4 : BEDDING (PIPES)"]
[]
[null,null,"BEDDING FOR WATER PIPES"]
[]
[null,"PSLB 8.2.2","Supply only of bedding by importation:",{"$nulls":3},{"$f":"IF(OR(AND(E269=\"Prov\",F269=\"Sum\"),(F269=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E269*F269),\"\",IF(E269*F269=0,\"\",ROUND(E269*F269,2))))","v":""}]
[{"$nulls":6},""]
[null,null,"From commercial sources:"]
[]
[1,null,"Selected granular material       ","m³",{"$f":"124*0.65*0.25*1.1","v":{"v":22.165000000000003,"d":"22"}}]
[]
[{"$f":"+A273+1","v":2},null,"Selected fill material   ","m³",{"$f":"124*0.2*0.25*1.1","v":{"v":6.820000000000001,"d":"7"}}]
[]
[null,"8.2.1","BEDDING FOR SEWER PIPES"]
[]
[null,"PSLB 8.2.2","Supply only of bedding by importation:"]
[]
[null,null,"From commercial sources:"]
[]
[{"$f":"+A275+1","v":3},null,"Selected granular material       ","m³",{"$f":"70*0.71*0.31*1.1","v":{"v":16.9477,"d":"17"}}]
[]
[{"$f":"+A283+1","v":4},null,"Selected fill material   ","m³",{"$f":"70*0.2*0.71*1.1","v":{"v":10.934000000000001,"d":"11"}}]
{"$rows_empty":65}
[{"$nulls":6},""]
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 LD","BILL NO.5 : SEWERS"]
[]
[null,null,"Reference Drawing: 113503-0000-DRG-WS-1500"]
[]
[null,"8.2.1","Supply, lay, joint, bed on a flexible bedding and test pipeline:",{"$nulls":3},""]
[]
[null,null,"uPVC heavy duty class 34 to SANS 791 pipes:"]
[]
[1,null,"110mm dia","m",{"$f":"+E108","v":{"v":70.4,"d":"70"}}]
[]
[null,"8.2.3","Precast concrete manhole:"]
[]
[null,null,"With cover and frame:"]
[]
[{"$f":"+A362+1","v":2},null,"Depth 1 m up to 1.5 m","No.",2]
[]
[{"$f":"+A368+1","v":3},null,"Depth 1.5 m up to 2.0 m","No.",0]
[]
[{"$f":"+A370+1","v":4},null,"Depth 2.0 m up to 2.5 m","No.",1]
[]
[null,"8.2.5","Cleaning eyes as shown on drawing 113503-0000-DRG-WS-1560 for:"]
[]
[{"$f":"+A372+1","v":5},null,"Erf connections","No.",1]
[]
[null,"8.2.6","Erf connections:"]
[]
[null,null,"uPVC pipes complete"]
[]
[{"$f":"+A376+1","v":6},null,"110mm dia","No.",1]
[]
[null,"8.2.10","Accessories:"]
[]
[null,null,"Manhole covers including frames:"]
[]
[{"$f":"+A382+1","v":7},null,"SANS 448 Type 4","No.",{"$f":"+E368+E370+E372","v":3}]
[]
[{"$f":"+A388+1","v":8},"PSLD 8.2.11","Connection to existing sewer","Sum",1]
[]
[{"$f":"+A390+1","v":9},"PSLD 8.2.13","Breaking into existing sewer and building a new manhole","No.",1]
{"$rows_empty":45}
[{"$nulls":6},{"$f":"IF(OR(AND(E438=\"Prov\",F438=\"Sum\"),(F438=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E438*F438),\"\",IF(E438*F438=0,\"\",ROUND(E438*F438,2))))","v":""}]
[null,null,"Total - Carried to Summary"]
[]
[null,"SANS 1200 LF","BILL NO.6 : ERF CONNECTIONS (WATER)"]
[]
[null,null,"Reference Drawing: 113503-0000-DRG-WW-1600"]
[]
[1,"8.2.1","Provide erf connections complete:","No.",1]
{"$rows_empty":82}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL SEWER AND POTABLE WATER"]
[]
[null,null,"SITE CLEARANCE"]
[]
[null,null,"EARTHWORKS (PIPE TRENCHES)"]
[]
[null,null,"MEDIUM-PRESSURE PIPELINES"]
[]
[null,null,"BEDDING (PIPES)"]
[]
[null,null,"SEWERS"]
[]
[null,null,"ERF CONNECTIONS (WATER)"]
{"$rows_empty":74}
[null,null,"TOTAL SECTION"]

{"sheet":"SCOUR","index":6,"n_rows":179,"n_cols":7,"rows_kept":179}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null,"SECTION 2.5 : SCOUR PIPELINE  "]
[]
[null,"SANS 1200 C","BILL NO .1 : SITE CLEARANCE"]
[]
[null,null,"Clear and grub:"]
[]
[1,"PSC 8.2.1","Strips, 3m wide","m",{"$f":"42*1.1","v":{"v":46.2,"d":"46"}}]
[]
[2,"8.2.5","Take down existing fences","m"]
{"$rows_empty":76}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL SCOUR PIPELINE"]
[]
[null,null,"SITE CLEARANCE"]
{"$rows_empty":84}
[null,null,"TOTAL SECTION"]

{"sheet":"COLLECTION CHAMBER","index":7,"n_rows":178,"n_cols":7,"rows_kept":178}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null,"SECTION 2.6 : COLLECTION CHAMBER"]
[]
[null,"SANS 1200 HA","BILL NO.3  : STRUCTURAL STEELWORK (SUNDRY ITEMS)",{"$nulls":3},{"$f":"IF(OR(AND(E7=\"Prov\",F7=\"Sum\"),(F7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E7*F7),\"\",IF(E7*F7=0,\"\",ROUND(E7*F7,2))))","v":""}]
[]
[null,"8.3.3","Ladders, complete and installed"]
[]
["1",null,"Access ladders, complete with corrosion protection, as per drawing: 113503-0000-DRG-WD-1760","No",1]
[]
[null,"8.3.4","Flooring, complete and installed with frames: "]
[]
["2",null,"Frame, complete with corrosion protection","No.",1]
[]
["3",null,"Grating (rectagrid), complete with corrosion protection","m²",{"$f":"2.98*2.48*1.1","v":{"v":8.12944,"d":"8"}}]
[]
[null,"8.3.5","Erection or installation only:"]
[]
[null,null,"Flooring, complete and installed with frames:"]
[]
["4",null,"Ladders","Sum",1]
[]
[null,"8.3.6","Corrosion protection:"]
[]
["5",null,"Ladders","Sum",1]
{"$rows_empty":61}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL SCOUR COLLECTION CHAMBER"]
[]
[null,null,"STRUCTURAL STEELWORK (SUNDRY ITEMS)"]
{"$rows_empty":84}
[null,null,"TOTAL SECTION"]

{"sheet":"BULK PIPE_PHASE1","index":8,"n_rows":198,"n_cols":7,"rows_kept":198}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null,"SECTION 2.7 : BULK PIPELINE PHASE 1"]
[]
[null,"SANS 1200C","BILL NO 1 : SITE CLEARANCE  ",{"$nulls":3},{"$f":"IF(OR(AND(E7=\"Prov\",F7=\"Sum\"),(F7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E7*F7),\"\",IF(E7*F7=0,\"\",ROUND(E7*F7,2))))","v":""}]
[null,null,"  ",{"$nulls":3},""]
[null,null,"  "]
[null,"PSC 8.2.1","Clear and grub:  "]
[]
[1,null,"Areas (chambers, structures, etc) ","m²",48]
[null,null,"  "]
[2,null,"Strips, 1,5 m wide (water) Paving/Asphalt ","m",880]
[null,null,"  "]
[null,"8.2.2","Remove and grub large trees and tree stumps of girth: "]
[null,null,"  "]
[3,null,"Over 1,0 m and up to and including 2,0 m ","No",15]
[null,null,"  "]
[4,null,"Over 2,0 m and up to and including 3,0m","No",15]
[null,null,"  "]
[null,"8.2.4","Reclear surfaces (only on instructions from the Engineer):  "]
[]
[5,"8.2.10","Remove topsoil to nominal depth of 150 mm and stockpile                  ","m³",396]
[]
[6,"PSC 8.2.14","Final finishing and cleaning up of the site of the Works","Sum",1]
{"$rows_empty":72}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL BULK PIPELINE PHASE 1"]
[]
[null,null,"SITE CLEARANCE"]
{"$rows_empty":93}
[{"$nulls":6},""]
[null,null,"TOTAL SECTION"]

{"sheet":"BULK PIPE_PHASE2","index":9,"n_rows":273,"n_cols":7,"rows_kept":273}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null,"SECTION 2.8: BULK PIPELINE PHASE 2"]
[]
[null,"SANS 1200C","BILL NO.1 : SITE CLEARANCE  ",{"$nulls":3},{"$f":"IF(OR(AND(E7=\"Prov\",F7=\"Sum\"),(F7=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E7*F7),\"\",IF(E7*F7=0,\"\",ROUND(E7*F7,2))))","v":""}]
[null,null,"  ",{"$nulls":3},""]
[null,"PSC 8.2.1","Clear and grub:  "]
[null,null,"  "]
[1,null," Areas (chambers, structures, etc) ","m²",{"v":55.577,"d":"56"}]
[null,null,"  "]
[2,null,"Strips, 1,5 m wide (water) Paving/Asphalt ","m",1030]
[null,null,"  "]
[null,"8.2.2","Remove and grub large trees and tree  stumps of girth:  "]
[]
[3,null,"Over 1,0 m and up to and including  2,0 m   ","No",10]
[null,null,"  "]
[4,null,"Over 2,0 m and up to and including 3,0 m ","No",10]
[null,null,"  "]
[5,"8.2.10","Remove topsoil to nominal depth of 150 mm and stockpile                  ","m³",{"v":463.5,"d":"464"}]
[]
[6,"PSC 8.2.14","Final finishing and cleaning up of the Site of the Works","Sum",1]
{"$rows_empty":74}
[null,null,"Total - Carried to Summary"]
[{"$nulls":6},{"$f":"IF(OR(AND(E99=\"Prov\",F99=\"Sum\"),(F99=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E99*F99),\"\",IF(E99*F99=0,\"\",ROUND(E99*F99,2))))","v":""}]
[null,"SANS 1200DK","BILL NO. 4 : GABIONS AND PITCHING  ",{"$nulls":3},""]
[null,null,"  ",{"$nulls":3},""]
[null,null,"  ",{"$nulls":3},""]
[null,"8.2.1","Surface preparation for bedding of  gabions: 1 no. Scour Valves  ",{"$nulls":3},""]
[null,null,"  "]
[1,null,"Cavities filled with approved excavated material or rock ","m²",{"v":25.2,"d":"25"}]
[null,null,"  "]
[null,"8.2.2","Gabions:  "]
[null,null,"  "]
[null,null,"Gabion boxes of galvanized wire: "]
[null,null," "]
[2,null,"100 mm x 100 mm mesh, 2,7 mm dia wire, 1,0 m x 1,0 m x 0,5 m boxes    ","m³",5]
[null,null,"  "]
[null,null,"Gabion mattresses of galvanized wire,  up to 0,3 m deep: "]
[]
[3,null,"80 mm x 100 mm mesh, 2,6 mm dia wire, 6,0 m x 2,1 m x 0,3 m mattress","m³",{"v":7.56,"d":"8"}]
[null,null,"  "]
[null,"8.2.4","Geotextile:  "]
[null,null,"  "]
[4,null,"Grade 4 or approved equivalent  ","m²",{"v":30.8,"d":"31"}]
{"$rows_empty":64}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL BULK PIPELINE PHASE 2"]
[]
[null,null,"SITE CLEARANCE"]
[]
[null,null,"GABIONS AND PITCHING"]
{"$rows_empty":82}
[null,null,"TOTAL SECTION"]

{"sheet":"BULK PIPE_PHASE3","index":10,"n_rows":265,"n_cols":7,"rows_kept":265}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null," SECTION 2.9 : BULK PIPLINE PHASE 3"]
[]
[null,"SANS 1200C","BILL NO.1 : SITE CLEARANCE"]
[null,null,"  "]
[null,null,"  "]
[null,"PSC 8.2.1","Clear and grub:  "]
[null,null,"  "]
[1,null,"Areas (chambers, structures, etc) ","m²",{"v":50.924,"d":"51"}]
[null,null,"  "]
[2,null,"Strips, 1,5 m wide (water) Paving/Asphalt ","m",1407]
[null,null,"  "]
[null,"8.2.2","Remove and grub large trees and tree  stumps of girth:   "]
[null,null," "]
[3,null,"Over 1,0 m and up to and including  2,0 m ","No",10]
[]
[4,null,"Over 2,0 m and up to and including  3,0 m ","No",10]
[null,null,"  "]
[5,"8.2.10","Remove topsoil to nominal depth of 150 mm and stockpile                  ","m³",{"v":318.22,"d":"318"}]
[]
[6,"PSC 8.2.14","Final finishing and cleaning up of the","Sum",1]
{"$rows_empty":65}
[null,null,"Total - Carried to Summary"]
[null,null,"  "]
[null,"SANS 1200 DK","BILL NO.4 : GABIONS AND PITCHING  "]
[null,null,"  "]
[]
[null,"8.2.1","Surface preparation for bedding of  gabions: 1 no. Scour Valves  "]
[]
[1,null,"Cavities filled with approved excavated material or rock ","m²",{"v":23.824,"d":"24"}]
[]
[null,"8.2.2","Gabions:  "]
[null,null,"  "]
[null,null,"Gabion boxes of galvanized wire:"]
[null,null,"  "]
[2,null,"100 mm x 100 mm mesh, 2,7 mm dia wire, 1,0 m x 1,0 m x 0,5 m boxes    ","m³",5]
[null,null,"  "]
[null,null,"Gabion mattresses of galvanized wire, up to 0,3 m deep: "]
[]
[3,null,"80 mm x 100 mm mesh, 2,6 mm dia wire, 6,0 m x 2,0 m x 0,3 m mattress","m³",{"v":7.2,"d":"7"}]
[null,null,"  "]
[null,"8.2.4","Geotextile:  "]
[null,null,"  "]
[4,null,"Grade 4 or approved equivalent  ","m²",39]
[]
[{"$nulls":6},{"$f":"IF(OR(AND(E113=\"Prov\",F113=\"Sum\"),(F113=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E113*F113),\"\",IF(E113*F113=0,\"\",ROUND(E113*F113,2))))","v":""}]
{"$rows_empty":61}
[null,null,"  "]
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL BULK PIPELINE PHASE 3"]
[]
[null,null,"SITE CLEARANCE"]
[]
[null,null,"GABIONS AND PITCHING"]
{"$rows_empty":80}
[null,null,"  "]
[null,null,"  "]
[null,null,"TOTAL SECTION"]

{"sheet":"BULK PIPE_PHASE4","index":11,"n_rows":179,"n_cols":7,"rows_kept":179}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null,"SECTION 2.10 : BULK PIPELINE PHASE 4"]
[]
[null,"SANS 1200 C","BILL NO.1 : SITE CLEARANCE  "]
[null,null,"  "]
[null,"PSC 8.2.1","Clear and grub:  "]
[null,null,"  "]
[1,null,"Strips, 1,5 m wide (water) Paving/Asphalt ","m",2137]
[null,null,"  "]
[null,"8.2.2","Remove and grub large trees and tree  stumps of girth:  "]
[null,null,"  "]
[2,null,"Over 1,0 m and up to and including  2,0 m ","No",10]
[null,null,"  "]
[3,null,"Over 2,0 m and up to and including  3,0 m ","No",10]
[]
[4,"8.2.10","Remove topsoil to nominal depth of 150 mm and stockpile     ","m³",{"v":480.825,"d":"481"}]
[]
[5,"PSC 8.2.14","Final finishing and cleaning up of the Site of the Works","Sum",1]
[]
[]
[{"$nulls":6},{"$f":"IF(OR(AND(E24=\"Prov\",F24=\"Sum\"),(F24=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E24*F24),\"\",IF(E24*F24=0,\"\",ROUND(E24*F24,2))))","v":""}]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
{"$rows_empty":47}
[null,null,"  "]
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL BULK PIPELINE PHASE 4"]
[]
[null,null,"SITE CLEARANCE"]
{"$rows_empty":84}
[null,null,"TOTAL SECTION"]

{"sheet":"BULK PIPE_PHASE5","index":12,"n_rows":179,"n_cols":7,"rows_kept":179}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null,"SECTION 2.11 : BULK PIPELINE PHASE 5"]
[null,"SANS 1200 C"]
[null,null,"BILL NO .1 : SITE CLEARANCE  ",{"$nulls":3},""]
[]
[null,null,"  ",{"$nulls":3},""]
[null,"PSC 8.2.1","Clear and grub:  ",{"$nulls":3},""]
[null,null,"  "]
[1,null,"Strips, 1,5 m wide (water) Paving/Asphalt ","m",1836]
[null,null,"  "]
[null,"8.2.2","Remove and grub large trees and tree stumps of girth:     "]
[]
[2,null,"Over 1,0 m and up to and including 2,0 m ","No",10]
[]
[3,null,"Over 2,0 m and up to and including 3,0 m ","No",10]
[null,null,"  "]
[4,"8.2.10","Remove topsoil to nominal depth of 150 mm and stockpile                  ","m³",{"v":413.1,"d":"413"}]
[]
[5,"PSC 8.2.14","Final finishing and cleaning up of the Site of the Works","Sum",1]
[]
[]
[]
[{"$nulls":6},{"$f":"IF(OR(AND(E26=\"Prov\",F26=\"Sum\"),(F26=\"PC Sum\")),\". . . . . . . . .00\",IF(ISERR(E26*F26),\"\",IF(E26*F26=0,\"\",ROUND(E26*F26,2))))","v":""}]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
[{"$nulls":6},""]
{"$rows_empty":56}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL BULK PIPELINE PHASE 5"]
[]
[null,null,"SITE CLEARANCE"]
{"$rows_empty":84}
[null,null,"TOTAL SECTION"]

{"sheet":"LANDSCAPE","index":13,"n_rows":528,"n_cols":7,"rows_kept":528}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 2 : EXTERNAL WORKS"]
[]
[null,null,"SECTION  2.13 : LANDSCAPE"]
[]
[null,"SANS 1200 C","BILL NO.1 : SITE CLEARANCE"]
[]
[]
[1,"8.2.1","Clear and grub (areas)","m²"]
[]
[2,"8.2.9","Transport materials and debris to unspecified sites and dump (Provisional)","m3-Km",1,null,"Rate Only"]
{"$rows_empty":76}
[null,null,"Total - Carried to Summary"]
[]
[null,"PLS 9","BILL NO. 5  : LANDSCAPE SOFTSCAPING"]
[]
[1,"9.7.1","Soil test","No",1]
[]
[2,"9.7.2","Clearing of area for planting","m²",4863]
[]
[3,"9.7.4","Topsoil from stockpile","m3",1,null,"Rate Only"]
[]
[null,null,"150mm thick"]
[]
[4,"9.7.5","Topsoil imported to site","m³",{"v":64.35,"d":"64"}]
[]
[null,null,"150mm thick"]
[]
[5,"9..7.6","Compost to lawn","m³",{"v":10.73,"d":"11"}]
[]
[null,null,"25mm thick"]
[]
[6,"9.7.6","Compost to trees","m³",1.54]
[]
[null,null,"0.07/m3 tree"]
[]
[7,"9.7.7","Planter mix","m³",{"v":4.65,"d":"5"}]
[]
[8,"9.7.8","Scarifying of areas","m²",429]
[]
[null,null,"300mm deep"]
[]
[9,"9.7.9","Shaping and trimming","m²",1217]
[]
[10,"9.7.10","Fine grading of the following areas: Lawn (hydroseeding and sods)","m²",4863]
[]
[null,"9.7.11","Fertilizer "]
[]
[11,null," Agricultural lime at 300kg/ha ","kg",{"v":12.87,"d":"13"}]
[]
[12,null," Super phosphate at 0.15kg/m² ","kg",{"v":182.55,"d":"183"}]
[]
[13,null," Superphosphate at 0.15kg/tree","kg",{"v":3.3,"d":"3"}]
[]
[14,null,"  2:3:2 (22) at 0.15kg/m² ","kg",{"v":182.55,"d":"183"}]
[]
[15,null," 2:3:2 (22) at 0.15kg/tree","kg",{"v":0.9,"d":"1"}]
[]
[16,null," Agriform tablets (2yr release) at 2 x21g tablets per tree","No",44]
[]
[17,null," Bonemeal at 0.1kg/tree ","kg",2.2]
[]
[18,"9.7.12","Mulch 50mm thick bark chips","m3",1,null,"Rate Only"]
[]
[19,"9.7.14","Trees Deliver and plant Combretum erythrophyllum","No",22]
[null,null,"(100L)"]
[]
[20,"9.7.15","Tree stakes and ties","No",22]
[]
[21,"9.7.17","Groundcovers Tulbaghia violecea 4L @ 9/mÂ²","No",86]
[]
[22,"9.7.18","Cynodon dactylon plugs","m²",226]
[]
[23,"9.7.19","Hydroseeding Cynodon dactylon","m²",788]
[]
[24,null,"Highveld grass mix","m²",3781]
{"$rows_empty":24}
[null,null,"Total - Carried to Summary"]
[]
[null,"PIR 14","BILL NO. 7 : IRRIGATION"]
[]
["1","14.3.2","Provide 110 mm irrigation sleeves at positions","m",298]
[]
[null,null,"Indicated on drawing no. 113503 0000 DRG AL 7001 T0"]
[]
[2,"14.3.1","Supply, deliver and install irrigation as per specialist BOQ","Sum",1]
[]
[null,null,"Refer to drawing no: 113503 0000 DRG AL 7007 T0"]
{"$rows_empty":78}
[null,null,"Total - Carried to Summary"]
[]
[null,"PLM 15","BILL NO.8 : LANDSCAPE MAINTENANCE"]
[]
[1,null,"Landscape Maintenance","month",3]
{"$rows_empty":84}
[null,null,"Total - Carried to Summary"]
[]
[null,"PA","BILL NO.9 : FENCING"]
[]
[null,"PA 12.1","Supply and erection of new fencing material complete to Drawing No:113503-0000-DRG-CC-1062:"]
[]
["1",null,"Clearvu Mesh panel 3297 wide x 2100mm high","No",{"$f":"550/3.383*1.1","v":{"v":178.8353532367721,"d":"179"}}]
[]
[{"$f":"A361+1","v":2},null,"Galvanized post, 2700 mm long","No",{"$f":"(550/3.383+1)*1.1","v":{"v":179.9353532367721,"d":"180"}}]
[]
[{"$f":"A363+1","v":3},null,"Concrete post foundation (400x400x600)mm","m³",{"$f":"(0.4*0.4*0.6)*E363*1.1","v":{"v":19.00117330180314,"d":"19"}}]
[]
[{"$f":"A365+1","v":4},null,"Shark tooth spike rail, 100mm high","m",{"$f":"550*1.1","v":605}]
[]
[{"$f":"A367+1","v":5},null,"Anti Burrow Ripper Flatwrap, 500mm wide","m",{"$f":"E367/3","v":{"v":201.66666666666666,"d":"202"}}]
[]
[null,"PA 12.2","New gates:"]
[]
[{"$f":"A369+1","v":6},null,"Double Leaf Swing Gates with Clearvu Fencing complete to drawing 113503-0000-DRG-CC-1062","No",1]
[]
[{"$f":"A373+1","v":7},null,"Sliding Gates with Clearvu Fencing complete to drawing 113503-0000-DRG-CC-1062","No",3]
[]
["8","PA 12.3","Drilling and blasting holes for posts and anchors","No",{"$f":"E363*0.4","v":{"v":71.97414129470884,"d":"72"}}]
{"$rows_empty":63}
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL LANDSCAPE"]
[]
[null,null," SITE CLEARANCE"]
[]
[null,null," SUBBASE"]
[]
[null,null," SEGMENTED PAVING"]
[]
[null,null," LANDSCAPE SOFTSCAPING"]
[]
[null,null," LANDSCAPE HARDSCAPING"]
[]
[null,null," IRRIGATION"]
[]
[null,null," LANDSCAPE MAINTENANCE"]
[]
[null,null,"FENCING"]
{"$rows_empty":68}
[null,null,"TOTAL SECTION"]

{"sheet":"RESERVOIR","index":14,"n_rows":159,"n_cols":7,"rows_kept":159}
["ITEM NO.","PAYREF","DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[null,null,"SECTION 4 : RESERVOIR"]
[]
[null,"PD.01","BILL NO. 11 : BUILDING WORK"]
[]
[null,"PD 10.01","Brickwork:"]
[]
[{"v":1,"d":"1 "},null,"230mm thick NFX load-bearing engineering bricks with 14Mpa mortar (1:4 cement:sand)","m²",{"v":351,"d":"351 "}]
[]
[null,"PD 10.02","Plaster work:"]
[]
[null,null,"Internal Plaster"]
[]
[{"v":2,"d":"2 "},null,"15mm thick internal cement plaster, steel-float finish","m²",{"v":172,"d":"172 "}]
[]
[null,null,"External Plaster"]
[]
[{"v":3,"d":"3 "},null,"15mm thick, external cement plaster wood float finish","m²",{"v":278,"d":"278 "}]
[]
[null,"PD 10.03","Floor screeds:"]
[]
[{"v":4,"d":"4 "},null,"Average 75mm Thick 20Mpa screed to falls - Reservoir","m²",{"v":4711,"d":"4,711 "}]
[]
[{"v":5,"d":"5 "},null,"Average 75mm Thick 25Mpa screed to falls - Pumphouse","m²",{"v":44,"d":"44 "}]
[]
[null,"PD 10.04","Doors and windows:"]
[]
[null,null,"Aluminium louvres complete with frame and glazed panels:"]
[]
[{"v":7,"d":"7 "},null,"900 x 900mm \"Trox\" or similar approved aluminium lourvers","No",{"v":9,"d":"9 "}]
[]
[null,"PD 10.07","Joinery:"]
[]
[null,null,"Items measured by number:"]
[]
[{"v":8,"d":"8 "},null,"Semi solid core flush panelled single door size 813 x 2032 x 44mm thick, cut 100mm short, with commercial veneered finish suitable for painting   on both sides including pressed steel double rebated door frame suitable for 230mm wall, including all necessary ironmongery.","No",{"v":3,"d":"3 "}]
[]
[null,"PD 10.08","Miscellaneous work:"]
[]
[null,null,"(a) Paintwork"]
[]
[null,null,"One coat wood primer and two coats eggshell enamel paint:"]
[]
[{"v":9,"d":"9 "},null,"Timber doors","m²",{"v":10,"d":"10 "}]
[]
[null,null,"One coat universal undercoat and two coats eggshell enamel paint:"]
[]
[{"v":10,"d":"10 "},null,"Steel door frames","m²",{"v":1,"d":"1 "}]
[]
[null,null,"One coat primer, one undercoat and two coats PVA emulsion paint on:"]
[]
[{"v":11,"d":"11 "},null,"Internal plastered walls","m²",{"v":278,"d":"278 "}]
[]
[{"v":12,"d":"12 "},null,"External plastered walls","m²",{"v":172,"d":"172 "}]
[]
[null,"PD 10.09","Miscellaneous items:"]
[]
[null,null,"Items measured by number:"]
[]
[{"v":13,"d":"13 "},null,"4800 x 3400mm high Purpose made Motorised galvanised steel security gates comprising 60kg/m2 steel frame and guide frame, complete with and including wheels, rails, cover plates, motor etc. as per drawings and specifications.","No",{"v":1,"d":"1 "}]
[]
[null,null,"Items measured by length:"]
[]
[{"v":14,"d":"14 "},null,"150mm Wide brick reinforcement built in horizontally","m",{"v":356,"d":"356 "}]
[]
[{"v":15,"d":"15 "},null,"75 x 110mm Wide precast presstresed concrete lintels","m",{"v":38,"d":"38 "}]
[]
[{"v":16,"d":"16 "},null,"300mm wide Precast sills","m",{"v":22,"d":"22 "}]
[]
[]
[]
[]
[]
[null,null,"Total - Carried to Summary"]
[]
[null,null,"SUMMARY TOTAL RESERVOIR"]
[]
[null,null,"BUILDING WORK"]
{"$rows_empty":79}
[null,null,"TOTAL SECTION"]

{"sheet":"TOTAL SUMMARY PAGE","index":15,"n_rows":399,"n_cols":6,"rows_kept":399}
["ITEM NO.","DESCRIPTION","AMOUNT","Smme"]
[]
[null,"FINAL SUMMARY"]
[]
["SECTION 1","PRELIMINARIES AND GENERAL",{"$f":"SUM(C9:C35)*0.15","v":0},{"$f":"SUM(D9:D35)*0.15","v":{"v":1564237.8090000001,"d":"1,564,237.81"}}]
[]
["SECTION 2","EXTERNAL WORKS"]
[]
["SECTION 2.1","BULK EARTHWORKS ",{"$f":"EARTHWORKS!G446","v":0},{"v":249300,"d":"249,300.00"}]
[]
["SECTION 2.2","ROADS",{"$f":"ROADS!G706","v":0},{"v":2684100,"d":"2,684,100.00"}]
[]
["SECTION 2.3","STORMWATER",{"$f":"STORMWATER!G862","v":0},{"v":2781214.8,"d":"2,781,214.80"}]
[]
["SECTION 2.4","SEWER & POTABLE",{"$f":"'SEWER&POTABLE'!G617","v":0},{"v":100967.5,"d":"100,967.50"}]
[]
["SECTION 2.5","SCOUR PIPELINE",{"$f":"SCOUR!G179","v":0},{"v":900,"d":"900.00"}]
[]
["SECTION 2.6","COLLECTION CHAMBER",{"$f":"'COLLECTION CHAMBER'!G178","v":0},{"v":29250,"d":"29,250.00"}]
[]
["SECTION 2.7","BULK PIPELINE PHASE 1",{"$f":"'BULK PIPE_PHASE1'!G198","v":0},{"v":89380,"d":"89,380.00"}]
[]
["SECTION 2.8","BULK PIPELINE PHASE 2",{"$f":"'BULK PIPE_PHASE2'!G273","v":0},{"v":91580,"d":"91,580.00"}]
[]
["SECTION 2.9","BULK PIPELINE PHASE 3",{"$f":"'BULK PIPE_PHASE3'!G265","v":0},{"v":90462.32,"d":"90,462.32"}]
[]
["SECTION 2.10","BULK PIPELINE PHASE 4",{"$f":"'BULK PIPE_PHASE4'!G179","v":0},{"v":72097.38,"d":"72,097.38"}]
[]
["SECTION 2.11","BULK PIPELINE PHASE 5",{"$f":"'BULK PIPE_PHASE5'!G179","v":0},{"v":69576.5,"d":"69,576.50"}]
[]
["SECTION 2.13","LANDSCAPE AND FENCING",{"$f":"LANDSCAPE!G528","v":0},{"v":3034519.32,"d":"3,034,519.32"}]
[]
["SECTION 4","RESERVOIR"]
[]
["SECTION 4.1","RESERVOIR",{"$f":"RESERVOIR!G159","v":0},{"v":1134904.2399999998,"d":"1,134,904.24"}]
{"$rows_empty":22}
[null,"TOTAL VALUE",{"$f":"SUM(C4:C57)","v":0},{"$f":"SUM(D5:D57)","v":{"v":11992489.869,"d":"11,992,489.87"}}]
{"$rows_empty":340}
[{"$nulls":5},2251222.64]