{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Schedule 1 - P&Gs","Schedule 2 -Masibekela RWPS&WTW","Schedule 3 - Hoyi Bulk Line","Schedule 4 - Mbangwane BPS","Schedule 5 - Mbangwane Bulkline","Schedule 6 - Reticulation","Summary","Sheet2"],"not_rendered":{"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Schedule 1 - P&Gs","index":0,"n_rows":177,"n_cols":13,"rows_kept":177,"merged":[[0,1,0,7],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[57,3,58,3],[61,1,61,6],[62,1,62,6],[86,3,87,3],[121,1,121,6],[122,1,122,6],[169,1,169,6]]}
[null,"SCHEDULE 1 : PRELIMINARY AND GENERAL"]
[null,"ITEM","REF","DESCRIPTION","UNIT","QUANT","RATE","AMOUNT"]
[null,"NO."]
[null,null,"SABS","SCHEDULE 1 : PRELIMINARY AND GENERAL"]
[null,null,"1200A"]
[null,"1.1","8.3","FIXED CHARGE AND VALUE RELATED ITEMS"]
[null,"1.1.1","PSA 4.1","Contractual Requirements ","Sum",1]
[]
[null,"1.1.2","8.3.2","Establish facilities on the site"]
[null,"1.1.2.1","8.3.2.1","i)   Facilities for Engineer"]
[{"$nulls":3},"     a)   Engineer's office (PSA 4.3.1)","Sum",1]
[]
[{"$nulls":3},"     b)   Name board (PSA 4.3.2)","No",2]
[]
[{"$nulls":3},"     c)   Survey assistants and material","Sum",1]
[]
[null,"1.1.2.2","8.3.2.2","ii)   Facilities for Contractor"]
[{"$nulls":3},"     a)   Offices and storage sheds","Sum",1]
[]
[{"$nulls":3},"     b)   Workshops","Sum",1]
[]
[{"$nulls":3},"     c)   Laboratories","Sum",1]
[]
[{"$nulls":3},"     d)   Living accommodation","Sum",1]
[]
[{"$nulls":3},"     e)   Ablution and latrine facilities","Sum",1]
[]
[{"$nulls":3},"     f)   Tools and equipment","Sum",1]
[]
[{"$nulls":3},"     g)   Water supplies, electric power"]
[{"$nulls":3},"           & communications","Sum",1]
[]
[{"$nulls":3},"     h)   Dealing with water","Sum",1]
[]
[{"$nulls":3},"     i)   Access","Sum",1]
[]
[{"$nulls":3},"     j)   Plant","Sum",1]
[]
[null,"1.1.3","8.3.3","Other fixed charge obligations","Sum",1]
[]
[null,"1.1.4","8.3.4"," Removal of Engineer's and Contractor's site"]
[{"$nulls":3}," establishment from site on completion of works.","Sum",1]
[]
[null,null,"SABS"]
[null,null,"1200A"]
[null,"1.2","8.4","TIME RELATED ITEMS"]
[null,"1.2.1","PSA 4.2","Contractual requirements","month",15]
[]
[null,"1.2.2","8.4.2","Operations and maintenance of facilities on site"," "]
[null,"1.2.2.1","8.4.2.1","Facilities for Engineer for duration of construction (SANS 1200 AB)"]
[{"$nulls":3},"     a) Engineer's office ","Month",15]
[]
[{"$nulls":3},"     b)   Name board","Month",15]
[]
[{"$nulls":3},"     c) Survey assistants and material","Month",15]
[]
[null,"1.2.3","8.4.2","Operations and maintenance of facilities on site"," "]
[null,"1.2.3.1","8.4.2.2","Facilities for the Contractor for the duration of the Contract, except where otherwise stated"]
[]
[{"$nulls":3},"     a)   Offices and storage sheds","Month",15]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[]
[{"$nulls":3},"      b)   Workshops","Month",15]
[]
[{"$nulls":3},"      c)   Laboratories","Month",15]
[]
[{"$nulls":3},"      d)   Ablution and latrine facilities","Month",15]
[]
[{"$nulls":3},"      e)   Tools and equipment","Month",15]
[]
[{"$nulls":3},"      f)   Water supplies, electric power & communications","Month",15]
[]
[{"$nulls":3},"      g)   Dealing with water","Month",15]
[]
[{"$nulls":3},"      h)   Access","Month",15]
[]
[{"$nulls":3},"      i)   Plant","Month",15]
[]
[null,"1.2.4","8.4.3","Supervision for duration of the construction","Month",15]
[]
[null,"1.2.5","8.4.4","Company and Head Office overhead costs for the duration of the Contract","Month",15]
[]
[null,"1.2.6","8.4.5","Other time related obligations","Month",15]
[]
[null,"1.2.7","PSA","Excavation by hand in all materials to expose existing services"]
[null,null,4.4,null,"m³",150]
[]
[null,"1.3","PSA","Occupational Health and Safety "]
[null,null,4.5,"Provision for the cost related to the Occupational Health "]
[{"$nulls":3},"and Safety Act, 85 of 1993, and the relevant Regulations:"]
[{"$nulls":3},"      a) Preparation of a Health & safety Plan","Sum",1]
[]
[{"$nulls":3},"      b) Compilation of a Risk Assessment prior to Construction","Sum",1]
[]
[{"$nulls":3},"      c) Health & Safety induction Training of employees","Sum",1]
[]
[{"$nulls":3},"      d) Compilation and keeping up to date the Health &            "]
[{"$nulls":3},"           Safety file which shall include all documentation "]
[{"$nulls":3},"           required in terms of the act","Sum",1]
[]
[{"$nulls":3},"      e)  Implementation of the Health and Safety Plan over the "]
[{"$nulls":3},"           entire construction period","Sum",1]
[]
[null,null,"PSA"]
[null,"1.4",1.4,"SUMS STATED PROVISIONALLY BY THE ENGINEER"]
[null,null,"1.4.1","a) Community Liaison Officer","Prov. Sum",1,{"$f":"8000*15","v":{"v":120000,"d":"120,000.00"}},{"$f":"8000*15","v":{"v":120000,"d":"R 120,000.00"}}]
[{"$nulls":3},"( Allowance for one person at R8000 a month)"]
[]
[null,null,"1.4.2","b) Underground water services survey and logging using GSM loggers","Prov. Sum",1,{"v":150000,"d":"150,000.00"},{"v":150000,"d":"R 150,000.00"}]
[{"$nulls":3},"loggers"]
[]
[{"$nulls":3},"Extra-over item 1.4.1 to 1.4.6 for:"]
[{"$nulls":3},"Contractor's handling fee ","%",{"$f":"SUM(H108:H112)","v":{"v":270000,"d":"R 270,000.00"}}]
[]
[null,1.5,null,"MATERIAL"]
[{"$nulls":3},"Actual cost of materials delivered to site inclusive of transport charges. (supporting invoices to be supplied)","Prov. Sum",1,{"v":100000,"d":"100,000.00"},{"$f":"G118*F118","v":{"v":100000,"d":"R 100,000.00"}}]
[]
[{"$nulls":3},"Percentage adjustment to item 1.5.1 for materials","%",{"$f":"H118","v":{"v":100000,"d":"R 100,000.00"}}]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[null,1.6,null,"QUALIFIED CIVIL ENGINEERING TECHNICIAN"]
[]
[{"$nulls":3},"Allowance for payment of a Qualified Civil Engineering technician","Prov. Sum",1,{"v":120000,"d":"120,000.00"},{"$f":"G126*F126","v":{"v":120000,"d":"R 120,000.00"}}]
[]
[{"$nulls":3},"Contractor's markup to item 1.10.1","%",{"$f":"H126","v":{"v":120000,"d":"R 120,000.00"}}]
[]
[null,1.7,null,"TRAINING "]
[]
[{"$nulls":3},"Allowance for training","Prov. Sum",1,{"v":250000,"d":"250,000.00"},{"$f":"G132*F132","v":{"v":250000,"d":"R 250,000.00"}}]
[]
[{"$nulls":3},"Contractor's markup to item 1.10.1","%",{"$f":"H132","v":{"v":250000,"d":"R 250,000.00"}}]
[]
[]
[null,1.8,null,"PLANT"]
[]
[{"$nulls":3},"a) Compressor"]
[]
[null,"1.8.1",null,"With 2 Breakers and 2 Operators","day",20,{"$nulls":6},{"$f":"SUM(H141:H155)","v":{"v":0,"d":"R 0.00"}}]
[]
[null,"1.8.2",null,"Establishment / Destablishment for item 1.8.1","No",2]
[]
[null,"1.8.3",null,"b) TLB","hr",20]
[]
[null,"1.8.4",null,"Establishment / Destablishment for item 1.8.3","No",2]
[]
[null,"1.8.5",null,"c) 10kl Water Tanker","hr",100]
[]
[null,"1.8.6",null,"Establishment / Destablishment for item 1.8.5","No",2]
[]
[null,"1.8.7",null,"c) Wacker","day",10]
[]
[null,"1.8.8",null,"d) Water Pump","day",10]
[]
[null,1.9,null,"SURVEY"]
[]
[null,"1.9.1",null,"Allowance for any As-Built\" survey\"","Prov. Sum",1,{"v":80000,"d":"R 80,000.00"},{"$f":"F159*G159","v":{"v":80000,"d":"R 80,000.00"}}]
[]
[null,"1.9.2",null,"Contractor's markup to item 1.9.1","%",{"$f":"H159","v":{"v":80000,"d":"R 80,000.00"}}]
{"$rows_empty":8}
[null,"TOTAL SCHEDULE 1 CARRIED FORWARD TO SUMMARY                         "]
[]
[]
[]
[]
[]
[]
[{"$nulls":12},{"$f":"SUM(M2:M172)","v":0}]

{"sheet":"Schedule 2 -Masibekela RWPS&WTW","index":1,"n_rows":210,"n_cols":13,"rows_kept":210,"merged":[[0,1,0,8],[1,2,2,2],[1,3,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[57,1,57,7],[58,1,58,7],[117,1,117,7],[118,1,118,7],[169,3,169,4],[176,1,176,7],[177,1,177,7],[209,1,209,7]]}
[null,"SCHEDULE 2 : MASIBEKELA RAW WATER PUMP STATION AND WATER TREATMENT WORKS"]
[null,"ITEM","REF","DESCRIPTION",null,"UNIT","QUANT","RATE","AMOUNT"]
[null,"NO."]
[null,2,"SANS\n1200",null,"MASIBEKELA RWPS AND WTW"]
[null,2.1,null,null,"Raw Water Pump Station"]
[null,2.1,null,null,"Refurbishment of KSB ETANORM centrifugal pump"]
[{"$nulls":4},"set.","No.",{"v":2,"d":"2.00"}]
[]
[null,2.2,null,null,"Refurbishment of MCC units","Sum",{"v":1,"d":"1.00"}]
[]
[null,2.3,null,null,"Removal of the suction pipes 500mmØ for cleaning","Sum",{"v":1,"d":"1.00"}]
[]
[null,2.4,null,null,"Fabrication of  galvanized suction pipe inlet screen "]
[{"$nulls":4},"and installation","Sum",{"v":1,"d":"1.00"}]
[]
[null,2,null,null,"Water Treatment Works"]
[null,2.1,null,null,"Removal of dislodging DN300 PN10 butterfly valves "]
[{"$nulls":4},"on sedimentation tank and replacement with new","No.",{"v":1,"d":"1.00"}]
[]
[null,2.2,null,null,"Removal of D300 PN10 Okzan butterfly valves "]
[{"$nulls":4},"complete with gearbox and replace from sand filters  "]
[{"$nulls":4},"and replacement with new","No.",{"v":8,"d":"8.00"}]
[]
[null,2.3,null,null,"Removal of DN150 PN gate valve from sand filters"]
[{"$nulls":4},"and replacement with new","No.",{"v":3,"d":"3.00"}]
[]
[null,2.4,null,null,"Removal of sand media from filters and disposal"]
[{"$nulls":4},"at a dedicated dump site","m³",{"v":100,"d":"100.00"}]
[]
[null,2.5,null,null,"Supply, delivery and application of silica sand media","m³",{"v":100,"d":"100.00"}]
[]
[null,2.6,null,null,"Supply, delivery, installation and commissioning of "]
[{"$nulls":4},"booster pump set with capacity of 171m³/h and"]
[{"$nulls":4}," duty head of 92.94m"]
[{"$nulls":4},"(The rate to include removal of existing pump sets, pipework and "]
[{"$nulls":4},"storage onsite)","Set",{"v":2,"d":"2.00"}]
[]
[null,2.7,null,null,"Installation of pre-chlronation system at the inlet\n(System to include pipework, provision of cage to chlorine cylinders\ndosing 2 dosing pumps)","Sum",{"v":1,"d":"1.00"}]
[]
[null,2.8,null,null,"Supply, delivery and installation of 250mmØ ultrasonic"]
[{"$nulls":4},"flow meter ","No",{"v":1,"d":"1.00"}]
[]
[null,2.9,null,null,"Upgrading of existing soft starter MCC panel to suit"]
[{"$nulls":4},"the new pump set","No",{"v":2,"d":"2.00"},{"$nulls":3},450000,{"$f":"G44*K44","v":{"v":900000,"d":"900,000.00"}},{"$f":"L44-I44","v":{"v":900000,"d":"900,000.00"}}]
[]
[null,{"v":2.1,"d":"2.10"},null,null,"Truckfilling Station and Guardhouse"]
[null,null,"SABS"]
[null,null,"1200 D","SITE PREPARATION"]
[{"$nulls":3},"Site Clearance"]
[null,null,"8.3.1.1","Clear and strip site"]
[null,"2.10.1",null,"i)","All structures","m²",{"v":150,"d":"150.00"}]
[]
[{"$nulls":3},"Remove topsoil"]
[null,null,"8.3.1.2","Remove topsoil to a nominal depth of 150mm"]
[{"$nulls":3},"stockpile and maintain"]
[null,"2.10.2",null,"i)","All structures","m²",{"v":100,"d":"100.00"}]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[{"$nulls":3},"RESTRICTED EXCAVATION"]
[null,null,"8.3.3 a) ","Excavate for restricted foundations, footings and pipe "]
[null,null,"PSD 2.1","trenches in all materials and backfill to 95% Mod "]
[{"$nulls":3},"AASHTO density:"]
[null,"2.10.3",null,"iii)","Guardhouse","m³",{"v":10,"d":"10.00"}]
[]
[null,null,"8.3.3 a) ","Excavate for restricted foundations, footings and pipe "]
[null,null,"PSD 2.1","trenches in all materials and dispose:"]
[null,"2.10.4",null,"iii)","Truckfilling station","m³",{"v":20,"d":"20.00"}]
[]
[null,null,"8.3.3 b)","Extra-over items 2.10.3 to 2.10.4 for excavation in:"]
[null,"2.10.5",null,"a)  Intermediate excavation (Provisional)",null,"m³",{"$f":"(G64+G68)*0.4","v":{"v":12,"d":"12.00"}}]
[]
[null,"2.10.5",null,"b)  Hard rock excavation (Provisional)",null,"m³",{"$f":"(G71+G64)*0.2","v":{"v":4.4,"d":"4.40"}}]
[]
[null,null,"8.3.4 a)","Importing of materials"]
[null,"2.10.7",null,"i)","Extra-over for importation of materials from ","m³",{"v":50,"d":"50.00"}]
[{"$nulls":4},"borrow pit for foundation filling and under truckfilling point slab"]
[{"$nulls":4},"Material to have a minimum quality of G6"]
[null,null,"SABS"]
[null,null,"1200G","CONCRETE WORK"]
[{"$nulls":3},"Concrete"]
[null,null,"8.4.2","Blinding layer in class 15MPa/19mm to a minimum"]
[{"$nulls":3},"thickness of 50mm underneath structures"]
[null,"2.10.8",null,"i)","Guard house","m²",{"v":15,"d":"15.00"}]
[]
[{"$nulls":3},"ii)","Truckfilling point","m²",{"v":40,"d":"40.00"}]
[]
[null,null,"8.4.3","Strength concrete - class 25MPa/19mm"]
[]
[null,"2.10.9",null,"iii)","Guardhouse footings","m³",{"v":4,"d":"4.00"}]
[]
[null,null,"8.4.3","Strength concrete - Class 25 MPa/19mm"]
[null,"2.10.10",null,"i)","All structures (provisional)","m³",{"v":18,"d":"18.00"}]
[]
[null,null,"8.4.3","Strength concrete - class 15MPa/10mm Mass"]
[{"$nulls":3},"concrete to:"]
[null,"2.10.11",null,"i)","All structures (provisional)","m³",{"v":2,"d":"2.00"}]
[]
[null,null,"8.4.3","Screed to:"]
[null,"2.10.12",null,"i)","All structures","m³",null,null,"Rate only"]
[null,null,"SABS"]
[null,null,"1200G","CONCRETE: Formwork"]
[null,null,"8.2.2","Formwork - Smooth:"]
[{"$nulls":3},"a)","Vertical plane"]
[]
[null,"2.10.13",null,"iii)","Pump Station","m²",{"v":23,"d":"23.00"}]
[]
[{"$nulls":3},"c)","Inclined "]
[null,"2.10.14",null,"i)","Staircase","m²",null,null,"Rate Only"]
[]
[{"$nulls":3},"d)","Horizontal plane "]
[]
[null,"2.10.15",null,"iii)","Guardhouse coverslabs and roof","m²",{"v":5,"d":"5.00"}]
[]
[null,null,"8.2.5","d)","Narrow widths (up to 300mm wide) to:"]
[null,"2.10.16",null,"ii)","Guardhouse","m",null,null,"Rate Only"]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[null,null,"8.2.5","e)","Curved narrow widths (up to 300mm wide) to:"]
[null,"2.10.17",null,"i)","Guardhouse","m",null,null,"Rate Only"]
[]
[{"$nulls":3},"REINFORCEMENT"]
[null,null,"8.3.1","Reinforcement, high tensile steel"]
[null,"2.10.18",null,"iii)","Guardhouse and truckfilling point","t",{"v":4.5,"d":"4.50"}]
[]
[null,null,"8.3.1","Reinforcement, mild steel"]
[null,"2.10.19",null,"iii)","Guardhouse and truckfilling point","t",{"v":1.5,"d":"1.50"}]
[]
[null,null,"8.3.2","High tensile welded mesh - Ref No 295 (Provisional)"]
[null,"2.10.20",null,"i)","v-drains and aprons","m²",{"v":45,"d":"45.00"}]
[]
[null,null,"8.4.4","Unformed surface finish"]
[null,"2.10.21",null,"iii)","Guardhouse, v-drains, and truckfilling point slab","m²",{"v":110,"d":"110.00"}]
[]
[null,null,"PART","PARTICULAR SPECIFICATION"]
[null,null,"SPEC PB","BUILDING WORK"]
[null,null,"PB9","Brickwork"]
[null,null,"PB9.1.1","Walls (including brickforcing every fourth course)"]
[]
[null,"2.10.22",null,"a)","One brick walls  (230 mm wide)","m²",{"v":65,"d":"65.00"}]
[{"$nulls":4},"Face bricks Type FBS external with 6 mm half"]
[{"$nulls":4},"round ruled joints and type NFP internal, the"]
[{"$nulls":4},"latter with joints raked for cement plaster"]
[]
[null,"2.10.23",null,"b)","Half brick walls  (115 mm wide)","m²",{"v":20,"d":"20.00"}]
[{"$nulls":4},"NFP bricks with joints raked for cement plaster "]
[{"$nulls":4},"both sides"]
[]
[null,"2.10.24",null,"Damp Proofing"]
[{"$nulls":3},"a)","Single layer 375 micron \"Gundle Brickgrip\" plastic","m",{"v":60,"d":"60.00"}]
[{"$nulls":4},"waterproof sheeting under all walls at top of floor"]
[{"$nulls":4},"level, and underneath window cills:"]
[]
[null,null,"PB9.1.3","Windows"]
[null,"2.10.25",null,"a)","Standard aluminium windowPT69 at guard house","no",null,null,"Rate Only"]
[]
[null,"2.10.26",null,"b)","Standard aluminium windowPT99 at guard house","no",{"v":1,"d":"1.00"}]
[]
[null,"2.10.27",null,"c)","Standard aluminium window PT129 at guard house","no",{"v":1,"d":"1.00"}]
[]
[null,"2.10.28",null,"d)","Standard aluminium window PT159 at guard house","no",{"v":4,"d":"4.00"}]
[]
[null,"2.10.29",null,"e)","Standard aluminium window PT219 at guard house","no",null,null,"Rate only"]
[]
[null,null,"PB9.1.3","Doors and Frames"]
[null,"2.10.30",null,"a)","Standard double sided FL&B 815x2 032mm solid meranti door and","no",{"v":3,"d":"3.00"}]
[{"$nulls":4},"frame, 3 lever lockset, chrome plated handles and painted"]
[{"$nulls":3},"Roof and celing"]
[{"$nulls":3},"0.6mm IBR Chromadek roof sheeting on wooden rafters and fixed to wooden purlins."]
[null,"2.10.31",null,"a)","Chromadek IBR Roof Sheeting","m²",{"v":38,"d":"38.00"}]
[]
[null,"2.10.32",null,"b)","Roof trussees","Sum",{"v":1,"d":"1.00"}]
[]
[null,"2.10.33",null,"c)","Ceiling","m²",{"v":20,"d":"20.00"}]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[null,null,"PB9.1.2","Plaster"]
[null,"2.10.34",null,"a)","One layer cement plaster rendered 12 mm thick","m²",{"v":89,"d":"89.00"}]
[null,null," ",null,"and finished smooth with steel trowel"]
[]
[null,null,"PB9.1.2","Painting wall finishes"]
[null,"2.10.35",null,"a)","One coat universal undercoat, Type 1 to SABS 681","m²",{"v":89,"d":"89.00"}]
[]
[null,"2.10.36",null,"b)","Two coats of Plascon Double Velvet (Camel Hair)","m²",{"v":89,"d":"89.00"}]
[]
[]
[{"$nulls":3},"Waterproofing of pump station roof"]
[null,"2.10.39",null,"\"Acrylastic\" as supplied by \"Gundle\" coatings,  supplied",null,"m²",null,null,"Rate only"]
[{"$nulls":3},"and applied to manufacturer's specifications"]
[]
[null,"2.10.40",null,"Plumbing works (guardhouse)",null,"Sum",{"v":1,"d":"1.00"}]
[]
[null,"2.10.41",null,"Electrifical works (guardhouse)",null,"Sum",{"v":1,"d":"1.00"}]
[]
[null,"2.10.42",null,"Septic Tank as per drawing STD-SEPT/01",null,"Sum",{"v":1,"d":"1.00"}]
[]
[null,"2.10.43",null,"DN100 smart-token-meter for truckfilling point"]
[{"$nulls":3},"Rate to include modification of pipework,connection and commissioning",null,"Sum",{"v":1,"d":"1.00"}]
[]
[null,"2.10.44",null,"Fencing of truckfilling point"]
[]
[{"$nulls":3},"i)","Deliver and erect 1.8m high 50x50x2.5mm weldedmesh fence "]
[{"$nulls":4},"complete as per drawing DET/TFP-01","m",{"v":50,"d":"50.00"}]
[]
[{"$nulls":3},"ii)","Gate - 5m double swing gate as per drawing DET/TFP-01","No",{"v":2,"d":"2.00"}]
[]
[]
[null,"TOTAL SCHEDULE 2 CARRIED FORWARD TO SUMMARY                 "]

{"sheet":"Schedule 3 - Hoyi Bulk Line","index":2,"n_rows":184,"n_cols":8,"rows_kept":184,"merged":[[0,1,0,7],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[52,1,52,6],[53,1,53,6],[105,1,105,6],[106,1,106,6],[156,1,156,6],[157,1,157,6],[183,1,183,6]]}
[null,"SCHEDULE 3 : HOYI BULKLINE"]
[null,"ITEM","REF","DESCRIPTION","UNIT","QUANT","RATE","AMOUNT"]
[null,"NO."]
[null,3.1,"SANS 1200DB","SITE CLEARANCE"]
[null,1.1,"8.3.1                   LI","a) Clear vegetation and tress of girth up to 1 m, stockpile and reinstate topsoil (150mm deep) along route of pipeline","m",{"v":2350,"d":"2,350.00"}]
[]
[null,1.2,"8.3.1            LI","b) Clear trees of girth over 1,0m and designated obstacles","No.",{"v":4,"d":"4.00"}]
[null,3.2,"SANS 1200DB","Earthworks:  Pipe Trenches"]
[null,null,"8.3.2","EXCAVATION"]
[null,"3.2.1","8.3.2 a)","a) Excavate in all materials for trenches for 315ND pipes and smaller.  Rates to include backfill, compact, and dispose of surplus material"]
[{"$nulls":3},"        Over            Up to and including"]
[]
[null,"3.2.1.1",null,"1)    0,00                     1,50m","m",{"v":352.5,"d":"352.50"}]
[]
[null,"3.2.1.2",null,"2)    1,50                     2,00m","m",{"v":822.5,"d":"822.50"}]
[]
[null,"3.2.1.3",null,"3)    2,00                     2,50m","m",{"v":1175,"d":"1,175.00"}]
[]
[null,"3.2.1.4",null,"4)    2,50                     3,00m","m",{"v":500,"d":"500.00"}]
[]
[null,"3.2.2","8.3.2","b) Extra over Item 2.2.1 above for:"]
[]
[null,"3.2.2.1",null,"1) Intermediate excavation","m3",{"$f":"587.5+1500","v":{"v":2087.5,"d":"2,087.50"}}]
[]
[null,"3.2.2.2",null,"2) Hard rock excavation","m3",{"$f":"587.5+1000","v":{"v":1587.5,"d":"1,587.50"}}]
[]
[null,"3.2.3","8.3.2","c) Excavate and dispose of unsuitable material from trench bottom (Prov)","m3",{"v":95,"d":"95.00"}]
[]
[null,"3.2.4","8.3.3","Excavation ancillaries (Prov)"]
[]
[null,"3.2.4.1","8.3.3.1","Make up deficiency in backfill material"]
[]
[{"$nulls":3},"a) From other necessary excavations on site","m³",{"v":125,"d":"125.00"}]
[]
[{"$nulls":3},"b) by importation from designated borrow pits","m³",{"$f":"F25","v":{"v":1587.5,"d":"1,587.50"}}]
[]
[{"$nulls":3},"c) by importation from commercial or off-site sources selected by the contractor","m³",{"$f":"130+800","v":{"v":930,"d":"930.00"}}]
[]
[null,3.3,"SANS 1200LB","BEDDING"]
[null,3.1,"8.2.1","Provision of bedding from trench excavation:"]
[]
[null,"3.1.1",null,"a)  Selected granular material","m3",{"v":150,"d":"150.00"}]
[]
[null,"3.1.2",null,"b)  Selected fill material","m3",{"v":500,"d":"500.00"}]
[]
[null,3.2,"8.2.2.2","Provision from approved borrow pits including all costs for additional handling and transport."]
[]
[null,"3.2.1",null,"a) Selected granular material (Prov)","m3",{"v":85,"d":"85.00"}]
[]
[null,"3.2.2",null,"b) Selected fill material (Prov)","m3",{"v":200,"d":"200.00"}]
[]
[null,3.3,"8.2.2.3","Provision from commercial or off-site sources, where ordered by the Engineer (Prov)"]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOUNT BROUGHT FORWARD"]
[null,"3.3.1",null,"a) Selected granular material","m3",{"v":50,"d":"50.00"}]
[]
[null,"3.3.2",null,"b) Selected fill material","m3",{"v":150,"d":"150.00"}]
[]
[null,"3.3.3",null,"c) 19mm crushed stone","m3",{"$f":"100+200","v":{"v":300,"d":"300.00"}}]
[]
[null,3.4,"SANS 1200DB 8.3.3.4","Overhaul"]
[null,"3.4.1",null,"a) Short haul over 0,5km up to 1,0km (Prov.)","m3",{"$f":"F55+F48+F42","v":{"v":285,"d":"285.00"}}]
[]
[null,"3.4.2",null,"b) Truck haul over 1,0km (Prov.)","m3.km",{"$f":"(F25+F35+F48+F50)*6","v":{"v":20760,"d":"20,760.00"}}]
[]
[null,3.5,"SANS \n1200L","Medium Pressure Pipelines"]
[{"$nulls":3},"uPVC PIPES"]
[null,"3.5.1","8.2.1\nLI","Supply, handle, lay, bed, joint, test  and disinfect uPVC Class \"12\" pipe with spigot and socket ends to SABS 966, Part 2 (1988)"]
[]
[{"$nulls":3},"a) 315mmØ class 16 (u-PVC)","m",{"v":2300,"d":"2,300.00"}]
[]
[null,"3.5.2","8.2.2","Extra over Item D4.1 for the Supplying, Laying, and Bedding of Specials Complete with Couplings including jointing, cutting of pipes to length where required, testing and disinfecting."]
[]
[null,"3.5.2.1",null,"Specials and Fittings in uPVC"]
[]
[null,"3.5.2.1.1",null,"Bends:"]
[]
[{"$nulls":3},"a) 45°","No",{"v":2,"d":"2.00"}]
[]
[{"$nulls":3},"b) 22.5°","No",{"v":4,"d":"4.00"}]
[]
[{"$nulls":3},"c) 11.25°","No",{"v":4,"d":"4.00"}]
[]
[{"$nulls":3},"Specials and Fittings in SG Iron"]
[]
[null,"3.5.2.1.2",null,"Reducers (for uPVC pipe)"]
[]
[{"$nulls":3},"a) 315 - 250mmØ","No",{"v":2,"d":"2.00"}]
[]
[{"$nulls":3},"b) 200 - 160mmØ","No",{"v":1,"d":"1.00"}]
[]
[null,"3.5.2.1.3",null,"Equal Tees (Cast iron)"]
[]
[{"$nulls":3},"a) 315mmØ","No",{"v":1,"d":"1.00"}]
[]
[null,"3.5.2.1.4",null,"Reducing Tees (for uPVC pipe)"]
[]
[{"$nulls":3},"a) 315 x 200mm diameter","No",{"v":1,"d":"1.00"}]
[]
[null,"3.5.2.1.5",null,"Flange Adaptor (for uPVC pipes)"]
[]
[{"$nulls":3},"a) 315mm diameter","No",{"v":8,"d":"8.00"}]
[]
[{"$nulls":3},"b) 250mm diameter","No",{"v":8,"d":"8.00"}]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOUNT BROUGHT FORWARD"]
[null,"3.5.2.1.6",null,"Valves"]
[{"$nulls":3},"PN16 300 mm ND flanged resilient seal gate valve (Drawing No. CON/DET-01)","No",{"v":3,"d":"3.00"}]
[]
[{"$nulls":3},"Valve key for opening isolating valves","No",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"Supply and install the following material complete as per drawing:"]
[{"$nulls":3},"a) 80mm Airvalve on 315mm diameter ","No",{"v":3,"d":"3.00"}]
[]
[{"$nulls":3},"Valve Chambers"]
[{"$nulls":3},"Supply all material labour and equipment for the construction "]
[{"$nulls":3},"of valve chambers as per drawings:"]
[{"$nulls":3},"Valve chamber","No",{"v":3,"d":"3.00"}]
[]
[{"$nulls":3},"Connection chamber","No",{"v":3,"d":"3.00"}]
[]
[null,null,"SANS 1200L 8.2.11","Construct anchor/thrust blocks to detail on D for tees, 90° bends and end caps:"]
[{"$nulls":3},"a) 315mmØ","No",{"v":10,"d":"10.00"}]
[]
[{"$nulls":3},"b) 250mmØ ","No",{"v":4,"d":"4.00"}]
[]
[null,3.6,null,"HORIZONTAL DIRECTIONAL DRILLING"]
[{"$nulls":3},"Horizontal directional drilling underneath a road to "]
[{"$nulls":3},"accommodate 300mmØ Steel pipe 18m long ((SABS 719, "]
[{"$nulls":3},"Grade B, 4,5 mm wall thickness), both end flanged, internally"]
[{"$nulls":3}," lined and externally coated with carboline 891, minimum "]
[{"$nulls":3},"thickness 250 microns as per drawing (HDD/01)"]
[]
[{"$nulls":3},"a) Railway Crossing","Sum",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"b) Road D2953","Sum",{"v":1,"d":"1.00"}]
[]
[null,3.7,null,"ROAD D2953 CROSSING"]
[{"$nulls":3},"Clearance, earthworks, beddings and medium pressure pipes are "]
[{"$nulls":3},"covered under item no. 3.1, 3,2, 3,3 3.4.and 3.5"]
[{"$nulls":3},"a) Traffic accomodation","Sum",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"b) Reinstatement of the road pavement structure:"]
[]
[{"$nulls":3},"i) 150mm G7 Lower selected layer,93% ModAASHTO","m³",0,null,"Rate only"]
[]
[{"$nulls":3},"ii) 150mm G6 Upper selected layer, 95% ModAASHTO","m³",0,null,"Rate only"]
[]
[{"$nulls":3},"iii) 150mm C4 Subbase layer, 98% ModAASHTO","m³",0,null,"Rate only"]
[]
[{"$nulls":3},"iv) 150mm G2 base layer","m³",0,null,"Rate only"]
[]
[{"$nulls":3},"v) 30mm Medium Continoiusly Graded Asphalt including"]
[{"$nulls":3},"prime @ 1l/m²","m²",0,null,"Rate only"]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOUNT BROUGHT FORWARD"]
[]
[null,3.8,null,"PN16 200 mm ND flanged electromagentic flow meter "]
[{"$nulls":3},"(Proline Promag 50P, 53P compact or approved "]
[{"$nulls":3},"similar) (Item No. 7 on Drawing no. CON/DET-01 )","No",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"Pipe marker posts as shown on Drawing No. STD/PLM01","No",{"v":8,"d":"8.00"}]
[]
[null,3.9,null,"Removal of unathorized connections on the existing DN315 uPVC"]
[{"$nulls":3},"pipeline and repairs as and when required (ordered by the Engineer)","Prov. Sum",{"v":1,"d":"1.00"},{"v":350000,"d":"350,000.00"},{"$f":"G167*F167","v":{"v":350000,"d":"R350,000.00"}}]
[]
[null,{"v":3.1,"d":"3.10"},null,"Sealing of 2Ml concrete reservoir (Hoyi Reservoir) by specialist","Prov. Sum",{"v":1,"d":"1.00"},{"v":250000,"d":"250,000.00"},{"$f":"G169*F169","v":{"v":250000,"d":"R250,000.00"}}]
[]
[null,3.11,null,"Sealing of 2Ml concrete reservoir (KaMandulo Reservoir) by specialist","Prov. Sum",{"v":1,"d":"1.00"},{"v":250000,"d":"250,000.00"},{"$f":"G171*F171","v":{"v":250000,"d":"R250,000.00"}}]
[]
[null,3.12,null,"Contractor's markup to item 3.9 and 3.10","%",{"$f":"H169+H171","v":{"v":500000,"d":"500,000.00"}}]
{"$rows_empty":10}
[null,"TOTAL SCHEDULE 3 CARRIED FORWARD TO SUMMARY    "]

{"sheet":"Schedule 4 - Mbangwane BPS","index":3,"n_rows":275,"n_cols":14,"rows_kept":275,"merged":[[0,1,0,8],[1,2,2,2],[1,3,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,8,2,8],[59,1,59,7],[60,1,60,7],[109,1,109,7],[110,1,110,7],[147,3,147,4],[159,1,159,7],[160,1,160,7],[224,1,224,7],[225,1,225,7],[274,1,274,7]]}
[null,"SCHEDULE 4 : MBANGWANE BOOSTER PUMP STTION"]
[null,"ITEM","REF","DESCRIPTION",null,"UNIT","QUANT","RATE","AMOUNT"]
[null,"NO."]
[null,null,"SANS"]
[null,4.1,"1200 D","SITE PREPARATION"]
[{"$nulls":3},"Site Clearance"]
[null,"4.1.1","8.3.1.1","Clear and strip site"]
[{"$nulls":3},"i)","All structures","m²",{"v":40,"d":"40.00"}]
[]
[{"$nulls":3},"Remove topsoil"]
[null,"4.1.2","8.3.1.2","Remove topsoil to a nominal depth of 150mm"]
[{"$nulls":3},"stockpile and maintain"]
[{"$nulls":3},"i)","All structures","m²",{"v":40,"d":"40.00"}]
[]
[{"$nulls":3},"RESTRICTED EXCAVATION"]
[null,"4.1.3","8.3.3 a) ","Excavate for restricted foundations, footings and pipe "]
[null,null,"PSD 2.1","trenches in all materials and backfill to 95% Mod "]
[{"$nulls":3},"AASHTO density:"]
[]
[{"$nulls":3},"i)","Pump Station","m³",7.35]
[]
[null,"4.1.4","8.3.3 a) ","Excavate for restricted foundations, footings and pipe "]
[null,null,"PSD 2.1","trenches in all materials and dispose:"]
[]
[{"$nulls":3},"i)","Pump Station","m³",{"v":20,"d":"20.00"},{"$nulls":6},1900]
[]
[null,"4.1.5","8.3.3 b)","Extra-over items 2.3.1 to 2.3.2 for excavation in:"]
[{"$nulls":3},"a)  Intermediate excavation (Provisional)",null,"m³",{"v":3.7,"d":"3.70"}]
[]
[{"$nulls":3},"b)  Hard rock excavation (Provisional)",null,"m³",{"v":3.7,"d":"3.70"}]
[]
[null,"4.1.6","8.3.4 a)","Importing of materials"]
[{"$nulls":3},"i)","Extra-over for importation of materials from ","m³",{"v":13.3,"d":"13.30"}]
[{"$nulls":4},"commercial sources for reservoir terrace. "]
[{"$nulls":4},"Material to have a minimum quality of G5."]
[]
[null,null,"SANS"]
[null,"4.1.7","1200G","CONCRETE WORK"]
[{"$nulls":3},"Concrete"]
[null,null,"8.4.2","Blinding layer in class 15MPa/19mm to a minimum"]
[{"$nulls":3},"thickness of 50mm underneath structures"]
[]
[{"$nulls":3},"i)","Pump Station","m²",{"v":56,"d":"56.00"}]
[]
[]
[null,"4.1.8","8.4.3","Strength concrete - class 35MPa/19mm"]
[]
[{"$nulls":3},"iii)","Pump Station","m³",{"v":8.5,"d":"8.50"}]
[]
[null,"4.1.9","8.4.3","Strength concrete - Class 25 MPa/19mm"]
[{"$nulls":3},"i)","All structures (provisional)","m³",{"$f":"2.5+1.1+3.5","v":{"v":7.1,"d":"7.10"}}]
[]
[null,"4.1.10","8.4.3","Strength concrete - class 15MPa/10mm Mass"]
[{"$nulls":3},"concrete to:"]
[{"$nulls":3},"i)","All structures (provisional)","m³",{"v":2,"d":"2.00"}]
[]
[null,"4.1.11","8.4.3","Screed to:"]
[{"$nulls":3},"i)","All structures","m³",{"v":3,"d":"3.00"}]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[]
[null,null,"SABS"]
[null,null,"1200G","CONCRETE: Formwork"]
[null,null,"8.2.2","Formwork - Smooth:"]
[null,"4.1.12",null,"a)","Vertical plane"]
[]
[{"$nulls":3},"i)","Pump Station","m²",{"v":7,"d":"7.00"}]
[]
[null,"4.1.13",null,"b)","Inclined - to staircases"]
[{"$nulls":3},"i)","Pump Station staircase","m²",null,null,"Rate Only"]
[]
[null,"4.1.14",null,"d)","Horizontal plane - elevated to walkways and slabs"]
[]
[{"$nulls":3},"iii)","Pump Station walkway and roof","m²",{"v":32,"d":"32.00"}]
[]
[null,"4.1.15","8.2.5","d)","Narrow widths (up to 300mm wide) to:"]
[{"$nulls":3},"ii)","Pump Station","m",null,null,"Rate Only"]
[]
[null,"4.1.16","8.2.5","e)","Curved narrow widths (up to 300mm wide) to:"]
[{"$nulls":3},"i)","Reservoir","m",null,null,"Rate Only"]
[]
[null,"4.1.17",null,"Box-out holes for pipes"]
[null,null,"8.2.6","Box-out holes, rectangular through concrete 200 to"]
[{"$nulls":3},"500 mm thick: for pipework supplied and installed"]
[{"$nulls":3},"by the Mechanical Contractor :"]
[{"$nulls":3},"i)","280 x 280mm box-out for 80mm flanged steel pipe","no",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"ii)","370 x 370mm box-out for 150mm flanged steel pipe","no",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"iii)","420 x 420mm box-out for 200mm flanged steel pipe","no",null,null,"Rate Only"]
[]
[null,"4.1.18",null,"REINFORCEMENT"]
[null,null,"8.3.1","Reinforcement, high tensile steel"]
[]
[{"$nulls":3},"iii)","Pump Station","t",4.75]
[]
[null,null,"8.3.1","Reinforcement, mild steel"]
[]
[{"$nulls":3},"iii)","Pump Station","t",{"v":1.5,"d":"1.50"}]
[]
[null,null,"8.3.2","High tensile welded mesh - Ref No 295 (Provisional)"]
[{"$nulls":3},"i)","All structures","m²",{"v":56,"d":"56.00"}]
[]
[null,"4.1.19","8.4.4","Unformed surface finish"]
[]
[{"$nulls":3},"iii)","Pump Station","m²",{"v":135,"d":"135.00"}]
[]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[]
[null,null,"PART","PARTICULAR SPECIFICATION"]
[null,null,"SPEC PB","BUILDING WORK"]
[null,null,"PB9","Brickwork"]
[null,"4.1.20","PB9.1.1","Walls (including brickforcing every fourth course)"]
[]
[{"$nulls":3},"a)","One brick walls  (230 mm wide)","m²",{"v":85,"d":"85.00"}]
[{"$nulls":4},"Face bricks Type FBS external with 6 mm half"]
[{"$nulls":4},"round ruled joints and type NFP internal, the"]
[{"$nulls":4},"latter with joints raked for cement plaster"]
[]
[{"$nulls":3},"b)","Half brick walls  (115 mm wide)","m²",{"v":17.5,"d":"17.50"}]
[{"$nulls":4},"NFP bricks with joints raked for cement plaster "]
[{"$nulls":4},"both sides"]
[]
[{"$nulls":3},"Damp Proofing"]
[{"$nulls":3},"a)","Single layer 375 micron \"Gundle Brickgrip\" plastic","m",{"v":25,"d":"25.00"}]
[{"$nulls":4},"waterproof sheeting under all walls at top of floor"]
[{"$nulls":4},"level, and underneath window cills:"]
[]
[null,"4.1.21","PB9.1.3","Windows"]
[]
[{"$nulls":3},"a)","Standard aluminium windowPT69 at guard house","no",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"b)","Standard aluminium windowPT99 at guard house","no",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"c)","Standard aluminium window PT129 at guard house","no",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"d)","Standard aluminium window PT159 at guard house","no",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"e)","Standard aluminium window PT219 at guard house","no",{"v":1,"d":"1.00"}]
[]
[null,"4.1.22","PB9.1.3","Doors and Frames"]
[{"$nulls":3},"a)","Standard double sided FL&B 815x2 032mm solid meranti door and frame","no",{"v":3,"d":"3.00"}]
[]
[null,"4.1.23",null,"Roof and celing"]
[{"$nulls":3},"0.6mm Chromadek IBR roof sheeting on wooden rafters and fixed to wooden purlins."]
[{"$nulls":3},"a)","Chromadek IBR Roof Sheeting","m²",{"v":60,"d":"60.00"}]
[]
[{"$nulls":3},"b)","Roof trussees","Sum",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"c)","Ceiling","m²",{"v":35,"d":"35.00"}]
[]
[null,"4.1.24","PB9.1.2","Plaster"]
[{"$nulls":3},"a)","One layer cement plaster rendered 12 mm thick"]
[null,null," ",null,"and finished smooth with steel trowel","m²",{"v":45,"d":"45.00"}]
[]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[]
[null,"4.1.25","PB9.1.2","Painting wall finishes"]
[{"$nulls":3},"a)","One coat universal undercoat, Type 1 to SABS 681","m²",{"v":150,"d":"150.00"}]
[]
[{"$nulls":3},"b)","Two coats of Plascon Double Velvet (Camel Hair)","m²",{"v":150,"d":"150.00"}]
[]
[]
[null,"4.1.26","PB9.1.3","Doors and Frames"]
[{"$nulls":3},"a)","Steel and door frame,","no",{"v":1,"d":"1.00"}]
[{"$nulls":4},"815 mm wide x 2 032 mm high"]
[{"$nulls":4},"thick complete with standard mild steel frame,"]
[{"$nulls":4},"3 lever lockset, chrome plated handles and painted"]
[]
[{"$nulls":3},"b)","Mild steel and door frame,","no",{"v":1,"d":"1.00"}]
[{"$nulls":4},"2400 mm wide x 3000 mm high"]
[{"$nulls":4},"thick complete with standard mild steel frame,"]
[{"$nulls":4},"3 lever lockset, chrome plated handles and"]
[{"$nulls":4},"painted"]
[]
[null,"4.1.27",null,"Waterproofing of pump station roof"]
[{"$nulls":3},"\"Acrylastic\" as supplied by \"Gundle\" coatings,  supplied",null,"m²",{"v":40,"d":"40.00"}]
[{"$nulls":3},"and applied to manufacturer's specifications"]
[]
[null,"4.1.28",null,"Plumbing works",null,"Sum",{"v":1,"d":"1.00"}]
[]
[null,"4.1.29",null,"Electrifical works",null,"Sum",{"v":1,"d":"1.00"}]
[]
[null,"4.1.30",null,"Septic Tank",null,"Sum",{"v":1,"d":"1.00"}]
[]
[null,4.2,null,"Pump Sets"]
[]
[null,"4.2.1",null,"Supply, delivery, installation and commissioning of booster pump"]
[{"$nulls":3},"set with capacity of 65m³/h and  duty head of 93.46m"]
[{"$nulls":3},"(The rate to include removal of existing pump set and "]
[{"$nulls":3},"storage onsite)",null,"No",{"v":2,"d":"2.00"}]
[]
[null,"4.2.2",null,"Pipework",null,"Sum",{"v":1,"d":"1.00"}]
[]
[null,"4.2.3",null,"Upgrading of existing soft starter MCC panel to suit"]
[{"$nulls":3},"the new pump set",null,"Sum",{"v":1,"d":"1.00"}]
[]
[null,"4.2.4",null,"Supply, delivery and installation of 150mmØ electromagnetic "]
[{"$nulls":3},"flow meter ",null,"No",{"v":2,"d":"2.00"}]
[]
[null,4.3,null,"Steel Tanks "]
[null,"4.3.1",null,"Resealing of existing steel tanks"]
[{"$nulls":3},"(Dismantling of the tank, Re-assembling of the tanks with new "]
[{"$nulls":3},"rubber seals, sealants, bolt and nuts including replacement of "]
[{"$nulls":3},"rusted steel panels)"]
[]
[{"$nulls":3},"i)","1 424kl","Prov. Sum",{"v":1,"d":"1.00"},{"$f":"863000*1.2","v":{"v":1035600,"d":"1,035,600.00"}},{"$f":"H212*G212","v":{"v":1035600,"d":"R1,035,600.00"}},{"$nulls":4},{"$f":"H212-450000","v":{"v":585600,"d":"R585,600.00"}}]
[]
[{"$nulls":3},"ii)","565 kl","Prov. Sum",{"v":1,"d":"1.00"},{"v":450000,"d":"450,000.00"},{"$f":"H214*G214","v":{"v":450000,"d":"R450,000.00"}},{"$nulls":4},{"$f":"H214-350000","v":{"v":100000,"d":"100,000.00"}}]
[]
[{"$nulls":3},"iii)","Contractor's handling fee for steel tanks","%",{"$f":"I212+I214","v":{"v":1485600,"d":"1,485,600.00"}}]
[]
[null,"4.3.2",null,"Steel tank base slab"]
[]
[{"$nulls":3},"i)","Demolition of existing base slab","Sum",{"v":1,"d":"1.00"},{"$nulls":6},30000]
[]
[{"$nulls":3},"ii)","Ground preparation","m²",{"v":180,"d":"180.00"}]
[]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[]
[{"$nulls":3},"iii)","Formwork","m²",{"v":25,"d":"25.00"}]
[]
[{"$nulls":3},"iv)","Strength concrete - class 30MPa/19mm","m³",{"v":52.5,"d":"52.50"}]
[]
[{"$nulls":3},"v) ","Reinforcement, high tensile steel","t",{"v":5,"d":"5.00"}]
[]
[{"$nulls":3},"vi)","Unformed surface finish","m²",{"v":205,"d":"205.00"}]
[]
[null,4.4,null,"Fencing "]
[]
[{"$nulls":3},"i)","Removal of existing barbwire fence and storing on-site","m",{"v":160,"d":"160.00"}]
[]
[{"$nulls":3},"ii)","Removal of existing concrete palisade and re-erection"]
[{"$nulls":4},"(The rate to include new bolts and nuts)","m",{"v":115,"d":"115.00"}]
[]
[{"$nulls":3},"iii)","Relocation of existing gate","No",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"iv)","Deliver and erect 2.4m high concrete palisade fence complete "]
[{"$nulls":4},"as per manufacturers specifications","m",{"v":321,"d":"321.00"}]
[]
[{"$nulls":3},"v)","Gate - Install 6m sliding vehicle gate complete","No",{"v":1,"d":"1.00"}]
[]
[null,4.5,null,"Mastlight"]
[]
[{"$nulls":3},"i)","Construction of mastlight base, supply and erection of 12m high"]
[{"$nulls":4},"mastlight with 4 100w floodlights and electrification","Sum",{"v":1,"d":"1.00"},{"$nulls":6},200000]
[]
[null,4.6,null,"Pump Station Crane"]
[]
[{"$nulls":3},"i)","254x146x37 I-beam","m",{"v":6,"d":"6.00"}]
[]
[{"$nulls":3},"ii)","1.5T Electric chain hoist complete with trolley to suit to beam","Sum",{"v":1,"d":"1.00"}]
{"$rows_empty":15}
[null,"TOTAL SCHEDULE 4 CARRIED FORWARD TO SUMMARY    ",{"$nulls":11},{"$f":"SUM(N1:N261)","v":917500}]

{"sheet":"Schedule 5 - Mbangwane Bulkline","index":4,"n_rows":194,"n_cols":14,"rows_kept":194,"merged":[[0,1,0,7],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[50,1,50,6],[51,1,51,6],[101,1,101,6],[102,1,102,6],[156,1,156,6],[157,1,157,6],[193,1,193,6]]}
[null,"SCHEDULE 5 : MBANGWANE BULKLINE"]
[null,"ITEM","REF","DESCRIPTION","UNIT","QUANT","RATE","AMOUNT"]
[null,"NO."]
[null,5.1,"SANS 1200DB","SITE CLEARANCE"]
[null,"5.1.1","8.3.1                   LI","a) Clear vegetation and tress of girth up to 1 m, stockpile and reinstate topsoil (150mm deep) along route of pipeline","m",{"v":1670,"d":"1,670.00"}]
[]
[null,"5.1.2","8.3.1            LI","b) Clear trees of girth over 1,0m and designated obstacles","No.",{"v":8,"d":"8.00"}]
[]
[null,5.2,"SANS 1200DB","Earthworks:  Pipe Trenches"]
[null,null,"8.3.2","EXCAVATION"]
[null,"5.2.1","8.3.2 a)","a) Excavate in all materials for trenches for 315ND pipes and smaller.  Rates to include backfill, compact, and dispose of surplus material"]
[{"$nulls":3},"        Over            Up to and including"]
[]
[{"$nulls":3},"1)    0,00                     1,50m","m",{"v":450,"d":"450.00"}]
[]
[{"$nulls":3},"2)    1,50                     2,00m","m",{"v":1220,"d":"1,220.00"}]
[]
[{"$nulls":3},"3)    2,00                     2,50m","m"]
[]
[null,"5.2.2","8.3.2","b) Extra over Item 2.2.1 above for:"]
[]
[{"$nulls":3},"1) Intermediate excavation","m3",{"$f":"762+300","v":{"v":1062,"d":"1,062.00"}},{"$nulls":7},{"$f":"K22","v":0}]
[]
[{"$nulls":3},"2) Hard rock excavation","m3",{"$f":"1220+300","v":{"v":1520,"d":"1,520.00"}},{"$nulls":7},{"$f":"K24","v":0}]
[]
[null,"5.2.3","8.3.2","c) Excavate and dispose of unsuitable material from trench bottom (Prov)","m3",{"v":153,"d":"153.00"}]
[]
[null,"5.2.4","8.3.3","Excavation ancillaries (Prov)"]
[]
[null,"2.4.1","8.3.3.1","Make up deficiency in backfill material"]
[]
[{"$nulls":3},"a) From other necessary excavations on site","m³",{"v":244,"d":"244.00"}]
[]
[{"$nulls":3},"b) by importation from designated borrow pits","m³",{"v":826,"d":"826.00"},{"$nulls":7},{"$f":"K34","v":0}]
[]
[{"$nulls":3},"c) by importation from commercial or off-site sources selected by the contractor","m³",{"$f":"250+50","v":{"v":300,"d":"300.00"}},{"$nulls":7},{"$f":"K36","v":0}]
[]
[null,5.3,"SANS 1200LB","BEDDING"]
[null,"5.3.1","8.2.1","Provision of bedding from trench excavation:"]
[]
[{"$nulls":3},"a)  Selected granular material","m3",{"v":75,"d":"75.00"}]
[]
[{"$nulls":3},"b)  Selected fill material","m3",{"v":138,"d":"138.00"}]
[]
[null,"5.3.2","8.2.2.2","Provision from approved borrow pits including all costs for additional handling and transport."]
[{"$nulls":3},"a) Selected granular material (Prov)","m3",{"v":77.5,"d":"77.50"}]
[]
[{"$nulls":3},"b) Selected fill material (Prov)","m3",{"v":160,"d":"160.00"}]
[]
[null,"5.3.3","8.2.2.3","Provision from commercial or off-site sources, where ordered by the Engineer (Prov)"]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOUNT BROUGHT FORWARD"]
[{"$nulls":3},"a) Selected granular material","m3",{"v":77.5,"d":"77.50"}]
[]
[{"$nulls":3},"b) Selected fill material","m3",{"v":160,"d":"160.00"}]
[]
[{"$nulls":3},"c) 19mm crushed stone","m3",{"v":38,"d":"38.00"}]
[]
[null,"5.3.4","SANS 1200DB 8.3.3.4","Overhaul"]
[{"$nulls":3},"a) Short haul over 0,5km up to 1,0km (Prov.)","m3",{"v":230,"d":"230.00"}]
[]
[{"$nulls":3},"b) Truck haul over 1,0km (Prov.)","m3.km",{"$f":"(F24+F34+F46+F48)*6","v":{"v":15501,"d":"15,501.00"}}]
[]
[null,5.4,"SANS \n1200L","Medium Pressure Pipelines"]
[{"$nulls":3},"uPVC PIPES"]
[null,"5.4.1","8.2.1\nLI","Supply, handle, lay, bed, joint, test  and disinfect uPVC Class \"12\" pipe with spigot and socket ends to SABS 966, Part 2 (1988)"]
[{"$nulls":3},"a) 250mmØ class 12 (u-PVC)","m",{"v":1670,"d":"1,670.00"}]
[]
[null,"5.4.2","8.2.2","Extra over Item D4.1 for the Supplying, Laying, and Bedding of Specials Complete with Couplings including jointing, cutting of pipes to length where required, testing and disinfecting."]
[{"$nulls":3},"Specials and Fittings in uPVC"]
[]
[null,"5.4.2.1",null,"Bends:"]
[]
[{"$nulls":3},"a) 45°","No",{"v":2,"d":"2.00"}]
[]
[{"$nulls":3},"b) 22.5°","No",{"v":3,"d":"3.00"}]
[]
[{"$nulls":3},"c) 11.25°","No",{"v":4,"d":"4.00"}]
[]
[{"$nulls":3},"Specials and Fittings in SG Iron"]
[]
[null,"5.4.2.2",null,"Reducers (for uPVC pipe)"]
[]
[{"$nulls":3},"a) 315 - 250mmØ","No",null,null,"Rate Only"]
[]
[{"$nulls":3},"b) 200 - 160mmØ","No",null,null,"Rate Only"]
[]
[{"$nulls":3},"Equal Tees (Cast iron)"]
[]
[{"$nulls":3},"a) 315mmØ","No",null,null,"Rate Only"]
[]
[null,"5.4.2.3",null,"Reducing Tees (for uPVC pipe)"]
[]
[{"$nulls":3},"a) 315 x 200mm diameter","No",null,null,"Rate Only"]
[]
[null,"5.4.2.4",null,"Flange Adaptor (for uPVC pipes)"]
[]
[{"$nulls":3},"a) 315mm diameter","No",null,null,"Rate Only"]
[]
[{"$nulls":3},"b) 250mm diameter","No",{"v":7,"d":"7.00"}]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOUNT BROUGHT FORWARD"]
[null,"5.4.3",null,"Valves"]
[]
[{"$nulls":3},"a) PN16 250 mm ND flanged resilient seal gate valve ( Drawing No. CON/DE-02)","No",{"v":3,"d":"3.00"}]
[]
[{"$nulls":3},"b) Valve key for opening isolating valves","No",null,null,"Rate Only"]
[]
[null,"5.4.4",null,"Supply and install the following material complete as per drawing:"]
[]
[{"$nulls":3},"a) 80mm Airvalve on 250mm diameter ","No",{"v":5,"d":"5.00"}]
[]
[null,"5.4.5",null,"Valve Chambers"]
[{"$nulls":3},"Supply all material labour and equipment for the construction "]
[{"$nulls":3},"of valve chambers as per drawings:"]
[]
[{"$nulls":3},"a) Valve chamber","No",{"v":5,"d":"5.00"}]
[]
[{"$nulls":3},"b) Connection chamber","No",{"v":1,"d":"1.00"}]
[]
[null,"5.4.6","SABS 1200L 8.2.11","Construct anchor/thrust blocks to detail on D for tees, 90° bends and end caps:"]
[{"$nulls":3},"a) 315mmØ","No",null,null,"Rate Only"]
[]
[{"$nulls":3},"b) 250mmØ ","No",null,null,"Rate Only"]
[]
[null,5.5,null,"ROAD D2950 CROSSING"]
[{"$nulls":3},"Clearance, earthworks, beddings and medium pressure pipes are "]
[{"$nulls":3},"covered under item no. 3.1, 3,2, 3,3 3.4.and 3.5"]
[null,"5.5.1",null,"a) Traffic accomodation","Sum",{"v":1,"d":"1.00"}]
[]
[null,"5.5.2",null,"b) Reinstatement of the road pavement structure:"]
[]
[{"$nulls":3},"i) 150mm G7 Lower selected layer,93% ModAASHTO","m³",{"v":10,"d":"10.00"}]
[]
[{"$nulls":3},"ii) 150mm G6 Upper selected layer, 95% ModAASHTO","m³",{"v":10,"d":"10.00"}]
[]
[{"$nulls":3},"iii) 150mm C4 Subbase layer, 98% ModAASHTO","m³",{"v":10,"d":"10.00"}]
[]
[{"$nulls":3},"iv) 150mm G2 base layer","m³",{"v":10,"d":"10.00"}]
[]
[{"$nulls":3},"v) 30mm Medium Continoiusly Graded Asphalt including"]
[{"$nulls":3},"prime @ 1l/m²","m³",{"$f":"10*3","v":{"v":30,"d":"30.00"}}]
[]
[null,5.6,null,"Steel pipes"]
[{"$nulls":3},"Steel short pieces (SABS 719, Grade B, 4,5 mm wall "]
[{"$nulls":3},"thickness), both end flanged, internally lined and "]
[{"$nulls":3},"externally coated with carboline 891, minimum "]
[{"$nulls":3},"thickness 250 microns as per drawing (CON/DET-01)"]
[]
[null,"5.6.1",null,"200-250mmØ","Sum",{"v":1,"d":"1.00"}]
[]
[{"$nulls":3},"PN16 200 mm ND flanged electromagentic flow meter "]
[{"$nulls":3},"(Proline Promag 50P, 53P compact or approved "]
[null,"5.6.2",null,"similar) (Item No. 7 on Drawing No. CON/DET-02)","No",{"v":2,"d":"2.00"}]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOUNT BROUGHT FORWARD"]
[]
[null,5.7,null,"Pipe marker posts as shown on Drawing No. STD/PM01","No",{"v":9,"d":"9.00"}]
[]
[null,5.8,null,"Removal of unathorized connections on the existing DN250 uPVC"]
[{"$nulls":3},"pipeline and repairs as and when required ","Prov. Sum",{"v":1,"d":"1.00"},{"v":250000,"d":"250,000.00"},{"$f":"G163*F163","v":{"v":250000,"d":"R250,000.00"}}]
[{"$nulls":3},"(ordered by the Engineer)"]
{"$rows_empty":29}
[null,"TOTAL SCHEDULE 5 CARRIED FORWARD TO SUMMARY    "]

{"sheet":"Schedule 6 - Reticulation","index":5,"n_rows":281,"n_cols":8,"rows_kept":281,"merged":[[0,1,0,7],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,7,2,7],[50,1,50,6],[51,1,51,6],[101,1,101,6],[102,1,102,6],[157,1,157,6],[158,1,158,6],[211,1,211,6],[212,1,212,6],[250,1,250,6],[251,1,251,6],[280,1,280,6]]}
[null,"SCHEDULE 6 : WATER RETICULATION "]
[null,"ITEM","REF","DESCRIPTION","UNIT","QUANT","RATE","AMOUNT"]
[null,"NO."]
[null,6.1,"SANS 1200DB","SITE CLEARANCE"]
[null,"6.1.1","8.3.1                   LI","a) Clear vegetation and tress of girth up to 1 m, stockpile and reinstate topsoil (150mm deep) along route of pipeline","m",27995]
[]
[null,"6.1.2","8.3.1            LI","b) Clear trees of girth over 1,0m and designated obstacles","No.",20]
[]
[null,6.2,"SANS 1200DB","Earthworks:  Pipe Trenches"]
[null,null,"8.3.2","EXCAVATION"]
[null,"6.2.1","8.3.2 a)","a) Excavate in all materials for trenches for 200ND pipes and smaller.  Rates to include backfill, compact, and dispose of surplus material"]
[{"$nulls":3},"        Over            Up to and including"]
[]
[{"$nulls":3},"1)    0,00                     1,50m","m",27000]
[]
[{"$nulls":3},"2)    1,50                     2,00m","m",995]
[]
[{"$nulls":3},"3)    2,00                     2,50m","m"]
[]
[{"$nulls":3},"4)    2,50                     3,00m","m"]
[]
[null,"6.2.2","8.3.2","b) Extra over Item 2.2.1 above for:"]
[]
[{"$nulls":3},"1) Intermediate excavation","m3",5590]
[]
[{"$nulls":3},"2) Hard rock excavation","m3",6998]
[]
[null,"6.2.3","8.3.2","c) Excavate and dispose of unsuitable material from trench bottom (Prov)","m3",1895]
[]
[null,null,"8.3.3","Excavation ancillaries (Prov)"]
[]
[null,"6.2.4","8.3.3.1","Make up deficiency in backfill material"]
[]
[{"$nulls":3},"a) From other necessary excavations on site","m³",{"$f":"F26*0.5","v":3499}]
[]
[{"$nulls":3},"b) by importation from designated borrow pits","m³",{"$f":"F26*0.2","v":{"v":1399.6000000000001,"d":"1400"}}]
[]
[{"$nulls":3},"c) by importation from commercial or off-site sources selected by the contractor","m³",{"$f":"F26*0.3","v":{"v":2099.4,"d":"2099"}}]
[]
[null,6.3,"SANS 1200LB","BEDDING"]
[null,"6.3.1","8.2.1","Provision of bedding from trench excavation:"]
[]
[{"$nulls":3},"a)  Selected granular material","m3",{"$f":"2800*0.5","v":1400}]
[]
[{"$nulls":3},"b)  Selected fill material","m3",{"$f":"8400*0.5","v":4200}]
[]
[null,"6.3.2","8.2.2.2","Provision from approved borrow pits including all costs for additional handling and transport."]
[]
[{"$nulls":3},"a) Selected granular material (Prov)","m3",{"$f":"2800*0.3","v":840}]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[{"$nulls":3},"b) Selected fill material (Prov)","m3",{"$f":"8400*0.3","v":2520}]
[]
[null,"6.3.3","8.2.2.3","Provision from commercial or off-site sources, where ordered by the Engineer (Prov)"]
[{"$nulls":3},"a) Selected granular material","m3",{"$f":"2800*0.2","v":560}]
[]
[{"$nulls":3},"b) Selected fill material","m3",{"$f":"8400*0.2","v":1680}]
[]
[{"$nulls":3},"c) 19mm crushed stone","m3",400]
[]
[null,"6.3.4","SANS 1200DB 8.3.3.4","Overhaul"]
[{"$nulls":3},"a) Short haul over 0,5km up to 1,0km (Prov.)","m3",200]
[]
[{"$nulls":3},"b) Truck haul over 1,0km (Prov.)","m3.km",{"$f":"(F49+F53+F36+F26)*6","v":{"v":70545.6,"d":"70546"}}]
[]
[null,6.4,"SANS \n1200L","Medium Pressure Pipelines"]
[{"$nulls":3},"uPVC PIPES"]
[null,"6.4.1","8.2.1\nLI","Supply, handle, lay, bed, joint, test  and disinfect uPVC pipe with spigot and socket ends to SABS 966, Part 2 (1988)"]
[]
[{"$nulls":3},"a) 63mm diameter class 9 (u-PVC)","m",1437]
[]
[{"$nulls":3},"b) 75mm diameter class 9 (u-PVC)","m",6147]
[]
[{"$nulls":3},"c) 75mm diameter class 12 (u-PVC)","m",12000]
[]
[{"$nulls":3},"d) 110mm diameter class 12 (u-PVC)","m",5944]
[]
[{"$nulls":3},"e) 160mm diameter class 12 (u-PVC)","m",2406]
[]
[null,"6.4.2","8.2.2","Extra over Item D4.1 for the Supplying, Laying, and Bedding of Specials Complete with Couplings including jointing, cutting of pipes to length where required, testing and disinfecting."]
[{"$nulls":3},"Specials and Fittings in uPVC"]
[null,"6.4.2.1",null,"90° Bends:"]
[]
[{"$nulls":3},"a) 63 mm diameter","No.",4]
[]
[{"$nulls":3},"b) 75 mm diameter","No.",35]
[]
[{"$nulls":3},"c) 110mm diameter ","No.",9]
[]
[{"$nulls":3},"d) 160mm diameter ","No.",7]
[]
[null,"6.4.2.2",null,"45° Bends"]
[{"$nulls":3},"a) 63 mm diameter","No.",null,null,"Rate Only"]
[]
[{"$nulls":3},"b) 75 mm diameter","No.",15]
[]
[{"$nulls":3},"c) 110mm diameter ","No.",9]
[]
[{"$nulls":3},"d) 160mm diameter ","No.",0,null,"Rate Only"]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[]
[null,"6.4.2.3",null,"22½° Bends:"]
[{"$nulls":3},"a) 63 mm diameter","No.",2,null,"Rate Only"]
[]
[{"$nulls":3},"b) 75 mm diameter","No.",38]
[]
[{"$nulls":3},"c) 110mm diameter ","No.",14]
[]
[{"$nulls":3},"d) 160mm diameter ","No.",5]
[]
[null,"6.4.2.4",null,"11¼° Bends:"]
[{"$nulls":3},"a) 63 mm diameter","No.",9]
[]
[{"$nulls":3},"b) 75 mm diameter","No.",68]
[]
[{"$nulls":3},"c) 110mm diameter ","No.",25]
[]
[{"$nulls":3},"d) 160mm diameter ","No.",12]
[]
[{"$nulls":3},"Specials and Fittings in SG Iron"]
[]
[null,"6.4.2.5",null,"Reducers (for uPVC pipe)"]
[{"$nulls":3},"a) 200 x 160mm diameter","No.",null,null,"Rate Only"]
[]
[{"$nulls":3},"b) 160 x 110mm diameter","No.",4]
[]
[{"$nulls":3},"c) 110 x 75mm diameter","No.",9]
[]
[{"$nulls":3},"d) 75 x 63mm diameter","No.",6]
[]
[null,"6.4.2.6",null,"Reducing Tees (for uPVC pipe)"]
[{"$nulls":3},"a) 200 x 160mm diameter","No.",null,null,"Rate Only"]
[]
[{"$nulls":3},"b) 160 x 63mm diameter","No.",4]
[]
[{"$nulls":3},"c) 110 x 75mm diameter","No.",9]
[]
[{"$nulls":3},"d) 75 x 63mm diameter","No.",6]
[]
[{"$nulls":3},"e) 63 x 50mm diameter","No.",null,null,"Rate Only"]
[]
[null,"6.4.2.7",null,"Equal Tees (for uPVC pipe)"]
[{"$nulls":3},"a) 200mm diameter","No.",null,null,"Rate Only"]
[]
[{"$nulls":3},"b) 160mm diameter","No.",null,null,"Rate Only"]
[]
[{"$nulls":3},"c) 110mm diameter","No.",5]
[]
[{"$nulls":3},"d) 75mm diameter","No.",54]
[]
[{"$nulls":3},"e) 63mm diameter","No.",4]
[]
[null,"6.4.2.8",null,"Socketed Hydrant tees (for uPVC pipes) as per detail on drawing  (if flanged, the branch should be flanged to SABS, 1123 Table 1600/3, include for \"Denso-wrapping\" bolted connections in accordance with PSL.5.3 and 5.4)"]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[{"$nulls":3},"a) 160 x 80mm diameter","No.",1]
[]
[{"$nulls":3},"b) 110 x 80mm diameter","No.",2]
[]
[{"$nulls":3},"c) 75 x 80mm diameter","No.",2]
[]
[null,"6.4.2.9",null,"End Caps (for uPVC pipes):"]
[{"$nulls":3},"a) 63 mm diameter","No.",15]
[]
[{"$nulls":3},"b) 75 mm diameter","No.",49]
[]
[{"$nulls":3},"c) 110mm diameter ","No.",2]
[]
[{"$nulls":3},"d) 160mm diameter ","No.",2]
[]
[null,"6.4.2.10",null,"Flange Adaptor (for uPVC pipes)"]
[{"$nulls":3},"a) 160mm diameter","No.",null,null,"Rate Only"]
[]
[{"$nulls":3},"b) 110mm diameter","No.",null,null,"Rate Only"]
[]
[{"$nulls":3},"c) 75mm diameter","No.",null,null,"Rate Only"]
[]
[{"$nulls":3},"d) 63mm diamter","No.",null,null,"Rate Only"]
[]
[null,null,"8.2.3","Extra over Item D4.1 for the Supplying, Fixing, and Bedding of Valves"]
[]
[null,"6.4.3","SANS 1200L 8.2.3","Supply and Install CI RSV gate valves (socketed ends for uPVC pipe) to SABS 1123 Table 1600/3 and a cap top for key operation for the following diameters (include 15 Mpa concrete anchor block):"]
[{"$nulls":3},"a) 63mm diameter","No.",3]
[]
[{"$nulls":3},"b) 75mm diameter","No.",10]
[]
[{"$nulls":3},"c) 110mm diameter","No.",8]
[]
[{"$nulls":3},"d) 160mm diameter","No.",1]
[]
[{"$nulls":3},"e) 200mm diameter","No.",null,null,"Rate Only"]
[]
[{"$nulls":3},"Hydrants"]
[null,"6.4.4",null,"a) Supply and install complete standard fire hydrant installation complete to detail,  Installation to include all fittings. Hydrant Tee and Chamber measured separately.","No.",4]
[]
[null,"6.4.5","8.2.11","Anchor/Thrust Blocks and Pedestals"]
[]
[null,"6.4.5.1","SABS 1200L 8.2.11","Construct anchor/thrust blocks to detail on D for tees, 90° bends and end caps:"]
[{"$nulls":3},"a) 63mm diameter","No.",5]
[]
[{"$nulls":3},"b) 75mm diameter","No.",25]
[]
[{"$nulls":3},"c) 110mm diameter","No.",15]
[]
[{"$nulls":3},"d) 160mm diameter","No.",15]
[]
[]
[null,"AMOUNT CARRIED FORWARD"]
[null,"AMOOUNT BROUGHT FORWARD"]
[null,"6.4.5.2",null,"As for Items D4.5.1 above but for lesser bends:"]
[{"$nulls":3},"a) 63mm diameter","No.",2]
[]
[{"$nulls":3},"b) 75mm diameter","No.",5]
[]
[{"$nulls":3},"c) 110mm diameter","No.",5]
[]
[{"$nulls":3},"d) 160mm diameter"]
[]
[null,"6.4.5.3",null,"As for Items D4.5.1 above but for reducers:"]
[{"$nulls":3},"a) 63mm diameter","No.",null,null,"Rate Only"]
[]
[{"$nulls":3},"b) 75mm diameter","No.",5]
[]
[{"$nulls":3},"c) 110mm diameter","No.",10]
[]
[{"$nulls":3},"d) 160mm diameter","No.",10]
[]
[null,null,"8.2.13","Valve Chambers"]
[null,"6.4.6",null,"Construct valve chamber complete to detail on Dwg No. STD/VLVCH01 including manhole cover and locking bar.  Allow for painting above ground section of chamber with two coats of yellow road marking paint.","No.",5]
[]
[null,null,"8.2.13","Meter Chambers"]
[null,"6.4.7",null,"Construct meter chamber complete to detail on Dwg No. STD/MTRCH01 including manhole cover and locking bar.  Allow for painting above ground section of chamber with two coats of yellow road marking paint.","No.",3]
[]
[null,"6.4.8","8.2.8","Markings or Marker Posts","No.",8]
[]
[null,6.5,"SANS 1200LF","ERF CONNECTIONS AND PIPEWORK"]
[null,"6.5.1","8.2.1","Supply and Install ERF Connections Complete with all saddles and clamps, HDPE Connection Pipes, Reducers, Tees, Couplings and all sundries including for excavation and backfill. Allow for Double ERF Connections that cross the road.","No.",67]
[]
[null,"6.5.2","8.2.1","Supply and Install ERF Connections Complete with all saddles and clamps, HDPE Connection Pipes, Reducers, Tees, Couplings and all sundries including for excavation and backfill. Allow for Single ERF Connections that cross the road.","No.",45]
[]
[null,"6.5.3","8.2.1","Supply and Install ERF Connections Complete with all saddles and clamps, HDPE Connection Pipes, Reducers, Tees, Couplings and all sundries including for excavation and backfill. Allow for Double ERF Connections on near side from the road.","No.",215]
[]
[null,"6.5.4","8.2.1","Supply and Install ERF Connections Complete with all saddles and clamps, HDPE Connection Pipes, Reducers, Tees, Couplings and all sundries including for excavation and backfill. Allow for Single ERF Connections on near side from the road..","No.",80]
[]
[null,"6.5.5","8.2.4","Supply and Install Meters Complete with Couplings Including Yard Tap"]
[]
[null,"AMOUNT CARRIED FORWARD",{"$nulls":5},{"$f":"SUM(H213:H250)","v":0}]
[null,"AMOOUNT BROUGHT FORWARD",{"$nulls":5},{"$f":"H251","v":0}]
[]
[null,"6.5.5","8.2.4","Supply and Install Meters Complete with Couplings Including Yard Tap"]
[]
[{"$nulls":3},"Supply and install Elster Kent V130 water meter complete with ball valve, meter box, with Consumer Valve Box complete as per Detail on Drawing No. for Ø15mm size house connection pipe complete with all fittings and sundries including complete yard tap located a minimum of 1.0m and maximum of 5m inside property boundary to detail on Dwg No. STD/ERFCON01","No.",882]
[]
[null,"6.5.6","8.2.8","Markings or Marker Posts","No.",882]
[]
[null,6.6,null,"Supply and Install PRV valves  (socketed ends for uPVC pipe) to SABS 1123 Table 1600/3 and a cap top for key operation for the following diameters (include 15 Mpa concrete anchor block) as per drawing:"]
[]
[{"$nulls":3},"i) DN100","No",2]
{"$rows_empty":18}
[null,"TOTAL SCHEDULE 6 CARRIED FORWARD TO SUMMARY                         "]

{"sheet":"Summary","index":6,"n_rows":24,"n_cols":6,"rows_kept":24,"merged":[[0,2,0,4],[1,2,1,4],[2,2,2,4],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4]]}
[null,"Schedule","Description",null,null,"Amount"]
[null,1,"Preliminary and Generals"]
[null,2,"Masibekela Raw Water Pump Station and Water Treatment Works"]
[null,3,"Hoyi Bulkline"]
[null,4,"Mbangwane Booster Pump Station"]
[null,5,"Mbangwane Bulkline"]
[null,6,"Mbangwane Water Reticulation Network"]
[null,"Sub-Total"]
[null,"10% Contingencies"]
[null,"5% Contract Price Adjustment"]
[null,"Sub-Total"]
[null,"15% VAT"]
[null,"Total Tender Offer"]
[]
[]
[]
[]
[null,"Name of Services Provider:","_______________________________________________",null,"Name of Authorized Representative:","____________________________________________"]
[]
[]
[]
[]
[]
[null,"Signature: ","_______________________________________________",null,"Date:","____________________________________________"]

{"sheet":"Sheet2","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true}