{"text_format":"3","workbook":"xls","n_sheets":10,"sheets":["Cover","Schedule A - P&G","Schedule B - Quality","Schedule C - Environmental","Schedule D - H & S","Schedule E- Arch","Schedule F - Civil","Schedule G - Electrical","Schedule H - Automation","Summary"],"not_rendered":{"images":10,"external_links":1,"defined_names":40},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Cover","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"merged":[[1,7,2,7],[6,1,7,1],[17,3,18,6]],"flags":["formulas_cached_only"]}
{"$rows_empty":11}
[{"$nulls":3},"BILL OF QUANTITIES"]
[]
[]
["DATE:",null,null,"April 2020"]
[]
[]
["PROJECT TITLE:",null,null,"Construction of a new generator structure at Zuikerbosch Pumping Station - System 2 Flocculators "]
[]
[]
[]
["SAP PROJECT NUMBER:",null,null,"P.02550"]

{"sheet":"Schedule A - P&G","index":1,"n_rows":41,"n_cols":7,"rows_kept":41,"merged":[[1,7,2,7],[3,2,4,2],[6,1,7,1],[39,0,39,3],[40,0,40,3]],"flags":["formulas_cached_only"]}
[null,"Zuikerbosch Pump Station (System 2): ",{"$nulls":4},"SANS 1200AA"]
[null,"Generator Structure at Zuikerbosch Pumping Station",{"$nulls":3},"Schedule A:","P and G's"]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No","Refers"]
[]
["A","SANS 1200AA","PRELIMINARY & GENERAL"]
[null,null,"FIXED CHARGES"]
[]
["A1","8.3.1","Contractual Requirements","Sum",1]
[]
["A2",null,"Provision of facilities on site"]
[]
["A2.1","8.3.2 (b)","Facilities required by Contractor","Sum",1]
[]
["A3","8.3.3","General responsibilities and other fixed-charge obligations","Sum",1]
[]
["A4","8.3.4","Removal of site establishment","Sum",1]
[]
[]
[null,null,"TIME RELATED CHARGES"]
[]
["A5","8.4.1","Contractual Requirements","Sum",1]
[]
["A6",null,"Operation and maintenance of facilities on site"]
[]
["A6.1","8.4.2 (b)","Facilities for contractor","Sum",1]
[]
["A7",8.5,"Temporary Works"]
[]
["A7.1","8.5.1","Access to works including all temporary roads, ramps, excavations and reinstatement of road/s etc.","Sum",1]
{"$rows_empty":9}
["Schedule A: Total amount excluding Value-Added Tax (VAT) to be carried to SUMMARY ",{"$nulls":5},0]

{"sheet":"Schedule B - Quality","index":2,"n_rows":50,"n_cols":7,"rows_kept":50,"merged":[[49,0,49,3]],"flags":["formulas_cached_only"]}
[null,"Zuikerbosch Pump Station (System 2): "]
[null,"Generator Structure at Zuikerbosch Pumping Station",null,null,"Schedule B:","Quality"]
[]
["Item No.","Payment Refers","Description","Unit","Qty","Rate","Amount"]
["B",null,"SCHEDULE B : QUALITY MANAGEMENT"]
["B1",null,"Preparation and submission of Contractors Quality Management Plan (CQMP), for review and approval prior to commencement of works ","  lump sum",1]
[]
["B1.1",null,"Provision of Qualified Quality Officer ( The contractor shall provide RW with relevant to the scope of work  qualified Quality Officer )","Month ",3]
[]
["B1.2",null,"Maintenance of documents and final documentation for submission - Provision of Document controller ","  Month",3]
[]
["B1.3",null,"Provision of Compliance Audits ( The contractor to audit the project once a year for the duration of the project ) Quartely for the duration of contract ","Rate ",1]
[]
["B1.4",null,"Testing Equipment calibration ( The testing Equipments should be calibrated as per the manual ) ","Rate ",1]
{"$rows_empty":9}
[{"$nulls":5}," "]
{"$rows_empty":25}
["Schedule B: Total amount excluding Value-Added Tax (VAT) to be carried to SUMMARY "]

{"sheet":"Schedule C - Environmental","index":3,"n_rows":54,"n_cols":10,"rows_kept":54,"merged":[[8,3,12,3],[8,4,12,4],[17,3,23,3],[17,4,23,4],[24,3,25,3],[24,4,25,4],[53,0,53,3]],"flags":["formulas_cached_only"]}
[null,"Zuikerbosch Pump Station (System 2): "]
[null,"Generator Structure at Zuikerbosch Pumping Station",{"$nulls":3},"Schedule C:","Environmental"]
[]
["Item No.","Payment Refers","Description","Unit","Qty","Rate","Amount"]
["C",null,"SCHEDULE C : ENVIRONMENTAL MANAGEMENT"]
["C1",9.1,"Administrative requirements as per environmental specification.                                             • Understanding of compliance\n• Preparation of environmental file and work program approval.\n• Preparations of method statements (management of all waste, Keeping the site clean and weed free, final clean up of site and campsite). \n• Maintaining of auditing of site compliances\n• Reporting of environmental incidence\n• Signing off of work for payment \n• Emergency preparedness retainement for external services\n• Programme scheduling details of administrative matters:\n","Sum",1]
["C1.1"]
[null,9.2,"Emergency preparedness funding"]
["C1.2",null,"a)          Provision for bee, snake and other fauna removal","Sum",1]
[null,null,"b)          Provision for hydrocarbon spillages that require intervention from professional clean up provider"]
["C1.3",null,"c)           Provision to clean up sewage spillages"]
[null,null,"d)          Equipment for fire fighting"]
["C1.4",null,"e)          Call out of fire department"]
[null,"9.1.4","Environmental awareness and training "]
["C1.5",null,"The rate for this item shall include costs for inductions and environmental awareness and training","Sum",1]
[null,9.2,"Social integration of the project to the public "]
["C1.6",null,"The rate for this item shall include costs for establishment of construction campsite and working areas","Sum",1]
[null,9.3,"Establishment of site camp and works area.","Sum",1]
["C1.7",null,"Signage The rate for this item must cover all expenses incurred in preparing signage at the entrance of the site offices indicating the following information "]
[null,null,"·        The contractor’s contact numbers"]
["C1.8",null,"·        ECO details "]
[null,null,"·        Emergency numbers and provision for: – snake removal, bee removal, fire, large hydrocarbon spillages, sewerage spillages"]
["C1.9",null,"Signage measuring a minimum of 30mmx30mm must also be made available for no go areas."]
[null,"9.3.4 to 9.3.4.2","Barricading and demarcation"]
["C1.10",null,"a.      Screening for unsightly works","sum",1]
[null,null,"b.     Clear demarcating of the working foot print"]
[{"$nulls":9}," "]
["C1.11","9.4 to 9.4.6","Pollution prevention and preservation of environmental resources "]
[null,null,"The rate for this item shall include costs for  pollution prevention and preservation of environmental resources","sum",1]
["C1.12",null,"C)          Waste bins and receptacles that comply with the waste clauses of the Environmental specification.","sum",1]
[]
["C1.13",null,"c)  Appropriate skips for waste separation","sum",1]
[]
["C1.14",null,"d)General waste Waste removal","sum",1]
[]
["C1.15",null,"e)Hazardous waste Waste removal","sum",1]
[]
["C1.16",null,"f)Recycled waste management  Waste removal","sum",1]
[]
["C1.17",null,"g) Spillage kits to clean up spillages  ","sum",1]
[]
["C1.18",null,"h) Hard impervious surfaces for storage of chemicals","sum",1]
[]
["C1.19",null,"i)Bunding facility for hazardous products","sum",1]
[]
["C1.20",null,"J)          Labelled containers for decanting of liquids","sum",1]
[]
["C1.21",null,"K) Drip trays for all vehicles staying on site over night","sum",1]
[]
[]
[]
[]
[]
["Schedule C: Total amount excluding Value-Added Tax (VAT) carried to SUMMARY "]

{"sheet":"Schedule D - H & S","index":4,"n_rows":76,"n_cols":7,"rows_kept":76,"merged":[[36,0,37,5],[40,0,40,5],[75,0,75,5]],"flags":["formulas_cached_only"]}
[null,"Zuikerbosch Pump Station (System 2): "]
[null,"Generator Structure at Zuikerbosch Pumping Station",{"$nulls":3},"Schedule D:","H & S"]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No","Refers"]
[]
["D",null,"SCHEDULE D :  OCCUPATIONAL HEALTH AND SAFETY "]
[]
["D.01","2.4 & 2.5.","Preparation of the Contractor's site specific Health and Safety Plan","lump sum",1]
[]
["D.02",3.2,"Principal Contractor's initial obligations in respect of the Occupational Health and Safety Act and Construction Regulations","lump sum",1]
[]
["D.03",4,"Principal Contractor's time related obligations in respect of the Occupational Health and Safety Act and Construction Regulations","month",3]
[]
["D.04","10.d","Provision of Personal Protective Equipment (PPE)","Sum",1]
[]
["D.05","3.2.1","Provision of a full-time Construction Health and Safety Officer","month",3]
[]
["D.06",15,"Cost of medical certificates and medical surveillance"]
[]
["D.07",15,"(a) Initial (baseline) medical examinations","lump sum",1]
[]
["D.08",15,"(c)Exit examinations","lump sum",1]
[]
["D.09",16,"Provision of First Aid Boxes to GSR requirements and other emergency safety equipment such as fire extinguishers.","lump sum",1]
[]
["D.10","24 C09","Transportation of Workers","lump sum",1]
[]
["D.11",11,"Welfare Facilities","lump sum",1]
[]
["D.12",12,"Security requirements including the security risk assessment (before site establishment)","lump sum",1]
[]
["D.13","24 C14, 7 ","Employee wellness programs","lump sum",1]
[]
[]
[]
["Total Carried Forward "]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No","Refers"]
["Total brought forward "]
[]
["D.14","Part B 10 k","Barricading","lump sum",1]
[]
["D.15","Part B 10 a ","Safety notices and signs","lump sum",1]
[]
["D.16","3.2.1 & 5C","COVID-19 Prevention and Management: The Engineer to advise at the relevant stage after award","PC SUM"]
[]
["D.17","Part B 10n,6.6 ","Adequate ventilation and lighting during construction","lump sum"]
[]
["D.18",2.9,"Submission of the Health and Safety File (hard and soft copies)","lump sum"]
{"$rows_empty":24}
["Schedule D: Total amount excluding Value-Added Tax (VAT) carried to SCHEDULE SUMMARY "]

{"sheet":"Schedule E- Arch","index":5,"n_rows":57,"n_cols":7,"rows_kept":57,"merged":[[1,9,1,11],[2,9,2,11]],"flags":["formulas_cached_only"]}
[null,"Zuikerbosch Pump Station (System 2): "]
[null,"Generator Structure at Zuikerbosch Pumping Station",{"$nulls":3},"Schedule E:","Architectural "]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No","Refers"]
[]
["E"]
[]
["E1"]
[]
["E1.1"]
[]
["E1.2"]
[]
[]
["E1.3"]
[]
["E1.4"]
[]
["E2"]
[]
["E2.1"]
[]
["E3"]
[]
["E3.1"]
[]
["E3.2"]
{"$rows_empty":28}
[null,null,"Section Carried Forward to Summary",{"$nulls":3},0]

{"sheet":"Schedule F - Civil","index":6,"n_rows":101,"n_cols":7,"rows_kept":101,"merged":[[1,7,2,7],[6,1,7,1],[13,1,14,1],[47,0,47,2],[51,0,51,2],[100,0,100,3]],"flags":["formulas_cached_only"]}
[null,"Zuikerbosch Pump Station (System 2): ",{"$nulls":4},"SANS 1200"]
[null,"Generator Structure at Zuikerbosch Pumping Station",{"$nulls":3},"Schedule F:","Civil "]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No","Refers"]
["F"]
["F1","SANS 1200C","SITE CLEARANCE"]
[]
[]
["F1.1","8.2.1","Clear and grub within area where works are to be carried out","m2",75]
[]
["F1.2","8.2.4","Reclear surfaces (only on instructions from the engineer)","m2",15]
[]
["F2","SANS 1200DA","EARTHWORKS"]
[]
[]
["F2.1","8.3.2","Restricted Excavation"]
[]
["F2.1.1",null,"Excavate for generator raft foundation as shown on drawing number R029329/005 and remove in-situ material to spoil off site (including removal of paving)","m3",28]
[]
["F2.1.2",null,"Scarify in-situ material 100 mm deep for generator raft foundation (drawing numberRA23046 / 002 - layer 3) and re-compact to 93% Mod AASHTO density"," m3",3]
[]
["F2.1.3",null,"Backfill selected in-situ material for generator raft foundation in 100 mm layers to 93% Mod AASHTO density (drawing number R029329/005 - layer 3) at –1% to +2% OMC"," m2",30]
[]
["F2.1.4",null,"Scarify in-situ material 100 mm deep for ramp and apron slab (drawing number R029329/005 - layer 3) and re-compact to 93% Mod AASHTO density"," m3",3]
[]
["F2.1.5",null,"Backfill selected topsoil for ramp in 100 mm layers to 93% Mod AASHTO density (drawing number R029329/005 - layer 3) at –1% to +2% OMC"," m2",24]
[]
["F2.2","8.3.4","Import Materials"]
[]
["F2.2.1",null,"Import suitable G7 material from an external source for generator raft foundation"," m3",16]
[]
["F2.2.2",null,"Construct 150 mm thick selected granular layer (drawing number R029329/005 - layer 2) using imported G7 material from an external source and compact to 93% Mod AASHTO density at –1% to +2% OMC. For generator raft foundation."," m3",16]
[]
[]
[]
[]
[null,null,"NOTE:"]
[null,null,"Disposal"]
[]
[null,null,"All haul for this contract shall be regarded as freehaul.  The cost of transportation of all materials will be deemed to be included in the rates and prices tendered."]
[]
[]
[]
[]
[]
[]
["Total Carried Forward "]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No","Refers"]
[]
["Total brought forward "]
[]
["F3","SANS\n1200G","CONCRETE (STRUCTURAL)"]
[]
[null,8.3,"SCHEDULED REINFORCEMENT ITEMS"]
[]
["F3.1","8.3.1","Steel bars"]
[]
["F3.1.1",null,"Mild steel reinforcement"," t",2]
[]
["F3.1.2",null,"High-tensile reinforcement"," t",5]
[]
["F3.2","8.3.2","High-tensile welded mesh"]
[]
["F3.2.1",null,"Mesh ref.395"," m2",25]
[]
[null,8.4,"SCHEDULED CONCRETE ITEMS"]
[]
["F3.2.2","8.4.2","Construct 50 mm thick 15 MPa grade concrete blinding layer generator room raft foundation"," m2",48]
[]
["F3.3","8.4.3","Strength Concrete, 30MPa/19"]
[]
["F3.3.1",null,"Construct 170 mm thick unreinforced concrete generator plinth with 30 MPa grade concrete (price to include formwork) "," m3",0.6]
[]
["F3.3.2",null,"Construct reinforced concrete generator foundation, ramp and apron with 30 MPa grade concrete (price to include formwork)"," m3",20]
[]
["F3.4","8.4.4","Unformed surface finishes"]
[]
["F3.4.1",null,"Wood-floated finish on generator plinth, exposed raft foundation, ramp and apron slab"," m2",48]
[]
["F3.5",8.5,"JOINTS"]
[]
["F3.5.1",null,"10 mm thick E.J. between concrete apron slab and masonry wall (impregnated fiberboard joint filler sealed with polyurethane sealant)","m",20]
[]
["F3.5.2",null,"10 mm thick E.J. between concrete apron slab and concrete ramp (impregnated fiberboard joint filler sealed with polyurethane sealant)","m",3]
[]
["F3.5.3",null,"10 mm thick E.J. between concrete ramp and generator floor slab (impregnated fiberboard joint filler sealed with polyurethane sealant)","m",3]
[]
["F3.5.4",null,"10 mm thick E.J. between apron slabs (impregnated fiberboard joint filler sealed with polyurethane sealant)","m",12]
[]
[]
["F3.6","8.3.6","Holding down (HD) bolts"]
[]
["F3.6.1",null,"Supply and install 16xM16 commercial quality holding down (HD) bolts with anchor plates to connect square circular hollow section columns to reinforced concrete raft foundation as per detail 1, drawing number R029329/005 (price to include grouting)","No.",4]
[]
[]
[]
[]
[]
["Schedule F: Total amount excluding Value-Added Tax (VAT) to be carried to SUMMARY "]

{"sheet":"Schedule G - Electrical","index":7,"n_rows":143,"n_cols":8,"rows_kept":143,"merged":[[3,0,3,7],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,4,5,4],[4,5,5,5],[4,7,5,7],[4,8,5,8],[6,0,6,1],[7,0,7,1],[8,0,8,1],[11,0,11,1],[12,0,12,1],[17,0,17,1],[18,0,18,1],[23,0,23,1],[26,0,26,1],[32,0,32,1],[51,0,52,0],[51,1,52,1],[51,2,52,2],[51,3,52,3],[51,4,52,4],[51,5,52,5],[51,6,52,6],[51,8,52,8],[58,0,58,1],[69,0,69,1],[131,8,132,8],[141,0,142,0],[141,2,142,2]],"flags":["formulas_cached_only"]}
[null,"Zuikerbosch Pump Station (System 2): "]
[null,"Generator Structure at Zuikerbosch Pumping Station",{"$nulls":4},"Schedule G:","Electrical"]
[]
["PRICE SCHEDULE:  SUPPLY, DELIVERY, INSTALLATION AND COMMISSIONING OF ELECTRICAL EQUIPMENT"]
["Item No","Description","Pay Ref","Qty","UOM","Rate supply (B)","Rate install ","Total A*(B+C)"]
[{"$nulls":3},"(A)",null,null,"(C)"]
["REFERENCE SHALL BE MADE TO THE PREAMBLE TO AND PRICING INSTRUCTIONS FOR THE ELECTRICAL BILL OF QUANTITIES WHICH IS AN INTEGRAL PART OF THIS BILL"]
["G1        ELECTRICAL DESIGN VERIFICATION AND OTHER SERVICES",null,2]
["Verify available electrical equipment documentation, liaise with OEM suppliers for outstanding information. Review design of installation including inspection, tracing on site etc in accordance with the design criteria. Prepare or update drawings and documents, as-built (record) drawings, reports and certificates"]
["G1.1         ","Existing Standby diesel generator set",null,1,"Sum"]
["G1.2         ","Existing cable installation for all power and control cables, including cable routing and cable schedules",null,1,"Sum"]
["G2        ELECTRICAL DESIGN",null,2]
["Design electrical systems in accordance with the design criteria. To include preparation of calculations, drawings and documents, as-built (record) drawings, reports and certificates"]
["G2.1         ","Changeover panel",null,1,"Sum"]
["G2.2         ","Earthing and Lightning protection system",null,1,"Sum"]
["G2.3         ","Low Voltage Cable Installation",null,1,"Sum"]
["G2.4         ","Design of on-board bunding and spillage containment system for the existing diesel generator",null,1,"Sum"]
["G3        CONSTRUCTION SUPERVISION ( Labour costs only)",null,3]
["Supervise the refurbishment, manufacture, installation, testing of electrical equipment at works or on site as per specification to ensure compliance to the final approved design, design criteria, and as per Construction Regulations. "]
["G3.1         ","Standby diesel generator set including modifications",null,1,"Sum"]
["G3.2         ","Changeover panel",null,1,"Sum"]
["G3.3         ","Earthing and lightning protection",null,1,"Sum"]
["G3.4         ","Cable installation for all power and control cables, including cable routing and cable schedules",null,1,"Sum"]
["G4        OTHER SERVICES"]
["G4.1         ","Detection of all services (pipes, cables, sewers, fibre optic cables) along the main cable route to the generator and to the valve chamber buildings",null,1,"Sum"]
["G4.2         ","Exposure and protection of all services (pipes, cables, sewers, fibre optic cables) where applicable",null,1,"Sum"]
["G5        QUALITY CONTROL PLANS",null,3]
[null,"Develop Quality Control Plans, monitor, action snag lists and complete sign offs and acceptances for the following including all documentation."]
["G5.1         ","Standby diesel generator set including modifications",null,1,"Sum"]
["G5.2         ","Changeover panel",null,1,"Sum"]
["G5.3         ","Earthing and lightning protection",null,1,"Sum"]
["G5.4         ","Cable installation for all power and control cables, including cable routing and cable schedules",null,1,"Sum"]
["G6        DIESEL EMERGENCY GENERATOR",null,4]
["G6.1         ","CLEAN AND ASSESS CONDITION OF GENERATOR",4]
["G6.1.1        ","Clean generator exterior, disconnect cables, inspect control panel and clean as per specification. Carry out a visual inspection of any defects or missing components or signs of corrosion.",null,1,"No"]
["G6.2         ","RECONDITIONING AT OEM",4]
["G6.2.1        ","Disconnect cables, load and transport generator to OEM",null,1,"No"]
["G6.2.2        ","Service generator engine as per manufacturers specification",null,1,"No"]
["G6.2.3        ","Refurbish generator set as per specification and manufacturer’s recommendations",null,1,"No"]
["G6.2.4        ","Test engine turbocharger and after cooler where applicable",null,1,"No"]
["G6.2.5        ","Open and clean alternator, check brush gear and test alternator as per manufacturer’s specification",null,1,"No"]
["G6.2.6        ","Check all bearings for signs of corrosion and brinelling",null,1,"No"]
["G6.2.7        ","Replace alternator drive and non-drive end bearings",null,1,"Set"]
["G6.2.8       ","Provision to replace battery of generator.",null,1,"Set"]
["G6.2.9  ","Clean and test generator controller",null,1,"No"]
["G6.2.10     ","Provision to supply and install an uprated generator controller with required communications capabilities",null,1,"No"]
["G6.2.11   ","Clean, test and modify generator control panel where required and specified",null,1,"No"]
["G6.3         ","ON BOARD SPILLAGE CONTAINMENT TANK",4]
["G6.3.1        ","Supply, manufacture, retrofit and install an on-board diesel and oil spillage containment tank as per specification",null,1,"No"]
["G6.3.2        ","Supply and install additional wiring for spillage containment tank signals and test installation",null,1,"No"]
["G6.3.3        ","COMPONENT REPLACEMENT",4]
["G6.3.4        ","Provisional sum to supply and install replacement control relays, indication lamps and switches"]
[{"$nulls":7},"R10000.00"]
["G6.4         ","TESTING OF GENERATOR AT OEM WORKS",4]
["G6.4.1        ","Carry out a full functional test of the generator at the works and provide full record with measurement of the test",null,1,"No"]
["G6.5         ","DELIVERY, INSTALLATION AND COMMISSIONING ON SITE",4]
["G6.5.1        ","Load and deliver generator set to site",null,1,"No"]
["G6.5.2        ","Install generator set on site on manufactured base/plinth",null,1,"No"]
["G7       CHANGEOVER PANEL"]
["G7.1         ","SUPPLY THE CHANGEOVER PANEL",5]
["G7.1.1        ","Supply and manufacture a changeover panel fully equipped as per drawings, specification and specific requirements and in accordance with Rand Water specification",null,1,"No"]
["G7.2         ","FACTORY ACCEPTANCE TEST THE CHANGEOVER PANEL",5]
["G7.2.1        ","Test a changeover panel fully equipped as per drawings, specification and specific requirements and in accordance with Rand Water specification",null,1,"No"]
["G7.3         ","DELIVER AND OFF-LOAD THE CHANGEOVER PANEL",5]
["G7.3.1        ","Deliver and off load to site a changeover panel",null,1,"No"]
["G7.4         ","INSTALL THE CHANGEOVER PANEL",5]
["G7.4.1        ","Install on site a changeover panel as per specification",null,1,"No"]
["G7.7         ","TEST AND COMMISSION THE CHANGEOVER PANEL ON SITE",5]
["G7.7.1        ","Test and commission a changeover panel",null,1,"No"]
["G8     CABLE INSTALLATION AND ASSOCIATED WORKS",null,6]
[null,"Low voltage cabling and earthing:"]
["G8.1      ","SUPPLY CABLE",7]
["G8.1.1     ","35 mm2, 4 core 600/1000V PVCPVCSWAPVC cable to SANS 1507",null,100,"m"]
["G8.1.2     ","1,5 mm2, 7 core 600/1000V PVCPVCSWAPVC cable to SANS 1507",null,20,"m"]
["G8.1.3     ","16 mm2, copper clad steel anti-theft earthing conductor or insulated bare copper earth conductor",null,100,"m"]
["G8.2      ","CABLE TERMINATIONS"]
[null,"Supply and install cable terminations for 600/1 000 V PVC PVC SWA PVC cable with Cu conductors",7]
["G8.2.1     ","35 mm2, 4 core 600/1000V PVCPVCSWAPVC cable to SANS 1507",null,8,"Each"]
["G8.2.2     ","1,5 mm2, 7 core 600/1000V PVCPVCSWAPVC cable to SANS 1507",null,2,"Each"]
[null,"Supply and install cable through joints for 600/1 000 V PVC PVC SWA PVC cable with Cu conductors",7]
["G8.2.3     ","35 mm2, 4 core 600/1000V PVCPVCSWAPVC cable to SANS 1507",null,4,"Each"]
[null,"Supply and install cable terminations for earth conductors",7]
["G8.2.4     ","16 mm2, copper clad steel anti-theft earthing conductor or insulated bare copper earth conductor",null,8,"Each"]
[null,"Supply and install cable through joints for earth conductors",7]
["G8.2.5     ","16 mm2, copper clad steel anti-theft earthing conductor or insulated bare copper earth conductor",null,4,"Each"]
["G8.3      ","Cable installation and associated works",7]
["G8.3.1     ","Locate existing supply cables and earth conductors to the valve chambers outside the paved area and expose same",null,1,"Sum"]
["G8.3.2     ","Obtain permit to isolate cables, spike cables, cut in preparation for two through joints. Cancel permit and return cables to service after completion of joint and end.",null,2,"Each"]
["G8.3.3     ","Trench by hand in Soft Pickable (Class 1) soil and to expose cables for connection to the generator and changeover panel",null,10,"m3"]
["G8.3.4     ","Provision to trench by hand in Soft Pickable (Class 1) soil in the vicinity of the Valve Chamber buildings as may be required.",null,15,"m3"]
["G8.3.5     ","Provision to lift and re-install existing paving",null,15,"m2"]
["G8.3.6     ","Backfill and compact after installation of all cables as per required QCP specified.",null,25,"m3"]
["G8.4      ","CONTINUITY AND INSULATION RESISTANCE TESTS",7]
[null,"Carry out continuity and insulation resistance tests on all cores of a 600/1000V PVCPVCSWAPVC cable and provide signed test certificate",7]
["G8.4.1     ","35 mm2, 4 core 600/1000V PVCPVCSWAPVC Cu cable to SANS 1507",null,5,"No"]
["G8.5      ","CONTINUITY TESTS ON EARTH CONDUCTORS",7]
[null,"Carry out continuity tests on earth conductors and provide signed test certificate",7]
["G8.5.1     ","70 mm2 copper coated steel earth conductor to SANS specifications ",null,5,"No"]
["G8.6      ","COMPACTION TESTS FOR BACKFILLED CABLE TRENCHES",7]
["G8.6.1     ","Carry out compaction tests on backfilled cable trenches and submit test results to the Engineer. Tests to be directed by the Engineer",null,2,"No"]
["G8.6.2     ","Danger warning tape",null,30,"m"]
["G8.6.3     ","Concrete cable markers with engraved cast in plates",null,6,"No"]
["G8.7      ","LADDER TYPE CABLE RACKING",7]
[null,"Provision to supply and install O-Line or equivalent heavy duty galvanised ladder type cable racking"]
["G8.7.1     ","150 mm wide straight run",null,10,"m"]
["G8.7.2     ","150 mm wide 90° internal bends",null,2,"No"]
["G8.7.3     ","150 mm wide 90° external bends",null,2,"No"]
["G8.7.4     ","150 mm wide horizontal bends",null,2,"No"]
["G8.8      "," EARTHING AND LIGHTNING PROTECTION"]
[null,"SOIL RESISTIVITY SURVEYS",8]
["G8.8.1     ","Carry out a soil resistivity surveys for earthing and lightning protection purposes and submit findings in a report to Rand Water",null,1,"No"]
["G8.9      ","LIGHTNING PROTECTION SYSTEM",8]
["G8.9.1     ","Lightning protection system",null,1,"No"]
["G8.9.2     ","Test installed lightning protection system",null,1,"No"]
["G8.10   ","EARTHING SYSTEM",8]
["G8.10.1   ","Earthing systems",null,1,"No"]
["G8.10.2   ","Test installed earth system",null,1,"No"]
["G8.12   ","COMMISSIONING THE INSTALLATION",9]
[null,"Inclusive of the supply of skilled persons, test equipment and completion of test and commissioning certificates"]
["G8.12.1   ","Commissioning of the complete installed and connected electrical installation",null,1,"No"]
["G8.12.2   ","Commissioning certificates complete",null,1,"Lot"]
["G8.13   ","TOOLS AND SPARES",10]
["G8.13.1   ","Spare generator controller",null,1,"No"]
["G8.14   ","DOCUMENTATION",11]
[null,"Supply of all As-Built (Supplied and generated) general arrangement and schematic drawings in electronic and hard copy formats and all test certificates for all equipment in the Engine Room"]
["G8.14.1   ","400 V Changeover Panel",null,1,"No"]
["G8.14.2   ","Diesel Standby Generator",null,1,"No"]
["G8.14.3   ","Complete Cable Installation for the entire installation",null,1,"No"]
["G8.14.4   ","Earthing and Lightning Protection",null,1,"No"]
[null,"Operating and Maintenance Manuals for all equipment ",11]
["G8.15   ","400 V Changeover Panel",null,1,"No"]
["G8.16   ","Diesel Standby Generator",null,1,"No"]
["G8.17   ","Earthing and Lightning Protection",null,1,"No"]
["G8.18   ","Provide Certificates of Compliance and Assembly Assessor Certificated for all completed LV installations",null,1,"No"]
["G8.19   ","OTHER"]
[null,"Provide the details of any additional spares, design, supply, manufacture, testing, delivery, installation and commissioning work that in the opinion of the tenderer is required to complete all the work as specified as required on the applicable drawings and the system specification. If no details are provided below, the contractor shall not be allowed any claims to complete any outstanding work which may be identified as being part of the specification during contract execution as specified."]
["G8.19.1   ",null,null,1,"No"]
["G8.19.2   ",null,null,1,"No"]
["G8.19.3   ",null,null,1,"No"]
["G8.19.4   ",null,null,1,"No"]
["G8.19.5   ",null,null,1,"No"]
[null,"Total amount excluding Value-Added Tax (VAT) to be carried to "]
[null,"Summary of Price Schedules ###"]

{"sheet":"Schedule H - Automation","index":8,"n_rows":21,"n_cols":9,"rows_kept":21,"merged":[[3,0,4,0],[3,1,4,1],[3,5,4,5],[3,6,4,6],[3,7,4,7],[3,8,4,8],[20,0,20,5]],"flags":["formulas_cached_only"]}
[null,"Zuikerbosch Pump Station (System 2): "]
[null,"Generator Structure at Zuikerbosch Pumping Station",{"$nulls":5},"Schedule H:","Automation"]
[]
["Item   No.","System Specifcation Clause","Description","Unit","Qty","Design Rate","Manufacture, Supply & Delivery Rate","Installation, Configuration, Testing & Commissioning Rate","Total Amount"]
[]
[]
["H",null,"Automation Equipment"]
[]
["H1","SS 3.1.1","The Contractor shall design and supply all Automation design requirements and quality documents including, but not limited to all the items.",1,"Sum"]
["H2","SS 3.1.2","The Contractor shall be responsible for the correctness of the installation (comply with Automation Asset Management Standard Specification).",1,"Sum"]
["H3","SS 3.1.3","The Contractor shall produce all drawings according to Electrical Drawings Standards Specification.",1,"Sum"]
["H4","SS 3.2.1","The Contractor shall install, test and commission the Modbus TCP/IP interface for the Generator as shown on the Zuikerbosch Pumping Station System-2 Flocculator Plant Automation Network layout drawing RA_23265.",1,"Sum"]
["H5","SS 3.3.1","The Contractor shall put into operation the Ethernet network system as shown on the Zuikerbosch Pumping Station System-2 Flocculator Plant Automation Network layout drawing RA_23265.",1,"Sum"]
["H6","SS 3.4.1","The Contractor shall update, test and commission existing PLC application as shown on the Zuikerbosch Pumping Station System-2 Flocculator Plant Automation Network layout drawing RA_23265.",1,"Sum"]
["H7","SS 3.5.1","The Contractor shall update, test and commission existing SCADA system at Slaker House-2 Control Room as shown on the Zuikerbosch Pumping Station System-2 Flocculator Plant Automation Network layout drawing RA_23265.",1,"Sum"]
["H8","SS 3.6.1","The Contractor shall design, supply, deliver, install, test and commission of all low voltage power and control cabling including earthing.",1,"Sum"]
["H9","SS 3.6.2.1","The Contractor shall design, supply, deliver, install, test and commission all the heavy-duty PVC sleeves where required.",1,"Sum"]
["H10","SS 3.6.3.1","The Contractor shall design, supply, deliver, install, test and commission all the flexible steel galvanized cable conduits as required.",1,"Sum"]
["H11","SS 3.6.4.1","The Contractor shall be responsible for providing all cable trenching in soil condition as per the Rand Water SAM AAM 00001 Standard Specification where required.",1,"Sum"]
["H12","SS 3.6.5.1","The Contractor shall design, supply, deliver, install, test and commission all the cable sealing system where all cables are entering and exiting buildings and chambers below ground level.",1,"Sum"]
["Schedule H: TOTAL AMOUNT EXLCLUDING VALUE - ADDED TAX (VAT) TO BE CARRIED TO SUMMARY"]

{"sheet":"Summary","index":9,"n_rows":58,"n_cols":3,"rows_kept":58,"merged":[[19,5,19,7],[31,0,31,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[39,0,39,1],[42,0,42,1],[45,0,45,1],[48,0,48,1],[49,0,49,1],[50,0,50,1],[53,0,53,1],[55,0,55,2],[57,0,57,2]],"flags":["formulas_cached_only"]}
[null,"Zuikerbosch Pump Station (System 2): "]
[null,"Generator Structure at Zuikerbosch Pumping Station","SUMMARY"]
[]
["Schedule","Description","Amount"]
[]
["A","PRELIMINARY AND GENERAL"]
[]
["B","QUALITY"]
[]
["C","ENVIRONMENTAL"]
[]
["D","HEALTH AND SAFETY"]
[]
["E","ARCHITECTURE","Not Applicable"]
[]
["F","CIVIL"]
[]
["G","ELECTRICAL"]
[]
["H","AUTOMATION"]
{"$rows_empty":11}
["SUBTOTAL A ……………………………………..……………………………………………"]
[]
[]
["CONTINGENCIES"]
["Add 10% of SUBTOTAL A …………..…………………...…...……………………………."]
["(The Provisional Sum provided here may only be expended at the sole discretion of the Engineer, and the Employer reserves the right, during the execution of the works, to adjust the stated sum downwards or to omit it entirely without affecting the validity of the contract.)"]
[]
[]
["SUBTOTAL B ……..…………..………………………..………….…………………………"]
[]
[]
["CONTRACT PRICE ADJUSTMENT (Provisional Allowance)………………………….."]
[]
[]
["SUBTOTAL C ……………………...…..……………………………….……………………."]
[]
[]
["VALUE ADDED TAX"]
["Add 15% of Subtotal C ………..…….……………………..………...……..………………"]
["(Provisional sum based on current rate of VAT)"]
[]
[]
["TOTAL CARRIED TO FORM C1.1, FORM OF OFFER"]
[]
[]
[]
["SIGNED ON BEHALF OF TENDERER: ……………………………………………..……………………………………………."]