{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["COVER PAGE","Preamble to the BOQ","Schedule 1 OHS","Schedule 2 P n G's General","Schedule 3 Valve Chambers","Schedule 4 Mechanical","Summary All","G CALCS","Factor for rates","Sheet1"],"not_rendered":{"images":1,"external_links":5,"defined_names":94},"read":"whole","date_system":"1900"}

{"sheet":"COVER PAGE","index":0,"n_rows":23,"n_cols":4,"rows_kept":23,"merged":[[6,1,7,1],[17,3,18,6]]}
{"$rows_empty":11}
[{"$nulls":3},"BILL OF QUANTITIES"]
[]
[]
["DATE:",null,null,"2023-10-01"]
[]
[]
["PROJECT TITLE:",null,null,"A14 AND A19 CARRIAGE WATER TIE-IN"]
[]
[]
["SAP PROJECT NUMBER:",null,null,"P. 03753"]
[]
["CONTRACT NUMBER ",null,null,"RW "]

{"sheet":"Preamble to the BOQ","index":1,"n_rows":166,"n_cols":2,"rows_kept":166,"merged":[[40,0,40,1],[41,0,41,1],[82,0,82,1],[83,0,83,1],[128,0,128,1],[129,0,129,1]]}
[null,"Preamble and Pricing Instructions"]
[1,"Definition of The Scope of Scheduled Items"]
[1.1,"Preamble and Pricing Instructions"]
["1.1.1","The prices and rates to be inserted in Bills of Quantities are to be the fully inclusive prices for the work described under the Price Schedules therein. Such prices and rates shall cover all costs and expenses that may be required in and for the execution of the work described, and shall cover the cost of all general risks, liabilities, and obligations set forth or implied in the documents on which the tender is based, as well as overhead charges and profit. This shall include any documentation or attendance of mandatory safety induction. Reasonable prices shall be inserted, as these will be used as a basis for assessment of payment for additional work that may have to be carried out."]
[]
["1.1.2","A price or rate is to be entered against each item in Bills of Quantities, whether the quantities are stated or not. Items that are required to be inserted in the Provisional Bills of Quantities by the Contractor, and which have not been duly inserted, shall be considered as covered by other rates or prices in the Provisional Bills of Quantities."]
[]
["1.1.3","Except where rates only are required, insert all amounts to be included in the total tendered price in the \"Amount\" column and show the corresponding total tendered price."]
[]
["1.1.4","The units of measurement described in the Bills of Quantities are in metric units."]
[]
["1.1.5","The Price Schedule is provisional and shall be subject to finalisation of the requirements on site and accurate measurement of actual quantities installed on site by the Contractor. The Contractor shall verify all quantities, dimensions, etc by actual measurement on site before the ordering of material, etc.  Rand Water does not accept responsibility for under or over measure as a result of the failure of the Contractor to verify quantities and dimensions before ordering. Jointing of e g cables which have resulted due to erroneous measurements will not be accepted."]
[]
["1.1.6","The quantities in the Provisional Schedules are estimates of the final quantities to enable the Contractor to determine the magnitude and scope of the works.  Payment will be made on final measurement of quantities of each item of the work on site."]
[]
["1.1.7","The Contractor in executing the work or in ordering any Contractors equipment or in ordering any plant shall not be guided by or work to any descriptions, dimensions or quantities as set forth in the Provisional Bills of Quantities.  He/she shall be guided by and work to the drawings supplied for the works, specifications and by the instructions of the Engineer and measurements taken on site."]
[]
["1.1.8","Where Provisional Sums appear in the Bills of Quantities the contractor shall provide competitive quotations with breakdowns of costs for work required and agreed, and payments will be against these quotations taking into account the contractors mark up. All items described as \"Provisional\" shall be measured as executed and paid for according to prices in the Bills of Quantities and any unexpended amounts shall be deducted from the amount of the Contract Sum.  No work for which \"Provisional\" items are provided shall be commenced without written instructions from the Engineer."]
[]
["1.1.9","System Specification Clause column is provided to make it easier for the Contractor to quickly locate some of the major clauses pertaining to that equipment/works within the System Specifications document. It is still the responsibility of the Contractor to thoroughly read through the entire System Specification document (including the entire Tender Documents, Drawings, Applicable Standards and Site Information) identify other applicable clauses pertaining to an equipment/works that have not been stated in the System Specification Clause column."]
[]
["1.1.10","These Bills of Quantities shall be used to assist both parties in administering and agreeing any changes/variations, which may arise during the course of the Contract."]
[]
["1.1.11","These Bills of Quantities shall be used to calculate the value of work completed in the evaluation of interim/final payments."]
[]
["1.1.12","The Contractor is deemed to have allowed opposite each item contained in these Bills of Quantities whatever costs and charges it may consider necessary for the carrying out, complying with and due observance of the provisions, conditions and requirements set out in the Contract."]
[]
["1.1.13","No claim whatsoever will be entertained in respect of errors or omissions in pricing due to the brevity of a description of any item contained in these Bills of Quantities which items are fully described or can reasonably inferred when read in conjunction with the relevant clauses provided for in the Conditions of Contract, Specifications, Drawings or other relevant documentation.  "]
[]
["1.1.14","Any item left un-priced will be deemed to be provided for elsewhere and no claim for any extras arising out of the Contractor’s omission to price any item will be entertained."]
["1.1.15","Whatever rate the tenderer puts in the Bill of Quantities as “rate only” shall be subject to verification by Rand Water quantity surveyors during project implementation."]
[]
["1.1.16","For the purposes of this schedule of quantities, the following words shall have the meaning hereby assigned to them:"]
[]
[null,"·         Unit: The unit of measurement for each item of work as defined in the specifications."]
[]
[null,"·         Quantity: The number of units of work for each item."]
[]
[null,"·         Rate: The payment per unit of work for which the tenderer tenders to do the work."]
[]
[]
[]
[null,"·         Amount: An amount tendered for an item, the extent of which is described in the schedule of quantities, the specification or elsewhere, but of which the quantity of work is not measured in units."]
[]
["1.1.17","The Form of Tender, the General and Particular Conditions of Contract, the Specification            and Drawings shall be read in conjunction with the price schedule."]
[]
["1.1.18","The price schedules and summary of price schedules shall be priced, extended, totalled and signed by the Tenderer. The total tender price shall be carried to the Form of Tender.  The Form of Tender and the Schedules shall be completed and signed."]
[]
["1.1.19","The tender price will be taken to be the price entered in the Form of Tender.  In the event of discrepancies between tendered rates and extended amounts in the price schedule, the amounts will be deemed to be correct and the rates will be corrected accordingly.  In the event of discrepancies between extended amounts and the total tender price entered in the Form of Tender, the total tender price will be deemed to be correct and adjustments made by agreement to rates and extended amounts."]
[]
["1.1.20","The quantities set out in the Schedule of Quantities are the estimated quantities of the Contract Works, but the Contractor will be required to undertake whatever quantities may be directed by the Engineer from time to time.  The Contract Price for the completed contract shall be computed from the actual quantities of work done, valued at the relevant unit rates and prices. The validity of the contract shall in no way be affected by differences between the quantities in the schedule of quantities and the quantities finally certified for payment.  Work shall be valued at the rates or lump sums tendered, subject only to the provisions of the general conditions of contract."]
[]
["1.1.21","All rates and sums of money quoted in the schedule of quantities shall be in Rands and whole cents.  Fractions of a cent shall be discarded."]
["1.1.22","The Employer shall without prejudice retain the rights to exclude and/or include certain aspects of the Bill of Quantities"]
[]
["1.1.23","The items included in Bills of Quantities are a guideline to the contractor.  It is the Contractor’s responsibility to thoroughly familiarise himself with all of the works information and specifications for this Contact so as to ascertain the scope and extent of the works and ensure that any items that are required to achieve the functional requirements of this Contract are included in the Bill of Quantities."]
[]
["1.1.24","Where no requirement has been stated in the documentation for Technical Data Sheets, Tenderers shall provide for items as reflected in the “measurement and payment” clauses of the applicable standard specification (e.g. SABS 1200 series specifications)."]
[]
["1.1.25","The description of each item shall, unless otherwise stated herein, be held to include making, conveying and delivering, unloading, storing, unpacking, hoisting, setting, fitting and fixing in position, cutting and waste, patterns, models and templates, plant, temporary works, return of packings, establishment charges, profit and all other obligations arising out of the Conditions of Contract."]
[]
["1.1.26","Unless a separate rate for the supply and for the installation of any item is specifically called for, the supply, delivery and installation costs of any item shall be fully included in the unit price."]
[]
["1.1.27","No alteration, erasure or addition is to be made in the typed text of the Bills of Quantities.  Should any alteration, erasure or addition be made other than in the areas allowed for this, it will not be recognised but the original wording of the Bill of Quantities will be adhered to."]
[]
["1.1.28","The Tenderer shall not be relieved of responsibility for measuring quantities at the Tender stage, and the Tender Sum submitted shall be in respect of the quantities set out in the Bills of Quantities.  The Tenderer shall be required to make his assessment and allowance of sundry equipment such as gaskets, bolts, nuts, brackets, fixing, etc., to form part of his pricing and shall include in the item prices for such small installation materials as are required for complete installation in accordance with the Specification."]
[]
["1.1.29","The following abbreviations are used in the schedule of quantities:"]
[null,"mm = millimetre"]
[null,"m = metre"]
[null,"m² = square metre"]
[null,"m³ = cubic metre"]
[null,"t = tons"]
[null,"No = number"]
[null,"PC Sum = prime cost sum"]
[null,"Prov Sum = provisional sum"]
[2,"Electrical Preamble"]
[2.1,"Design and detailing of the installation"]
[null,"Items are provided in the Provisional Bills of Quantities for final design suitable for construction of the Substation Distribution Board and the Mimic Panel. Included is marking up Rand Water’s schematic diagrams, general arrangement layout, door layouts, selection of equipment and planning the chassis layouts with wiring channels, labels, terminals etc."]
[null,"The final planning of cable routes, detailed cable racking layouts and design considering cable runs to minimise cross overs, mechanical strength of the racking system wherever required is included. Also included is detailed liaison with Eskom with respect to cable runs in their switchyard."]
[null,"The contractor shall also determine the best positions for installation of the Distribution Board, Mimic Panel and UPS, and core drilling into the Engine Room basements where required for cable access."]
[2.2,"Documentation"]
[]
[]
[null,"The contractor shall provide as built drawings in latest version Autocad format of all distribution boards inclusive of dimensioned general arrangements, schematic diagrams, labels etc."]
[null,"Detailed as installed cable schedules and earthing conductors with installed lengths of cable shall be provided in electronic and hard copy format."]
[null,"Marked up dimensioned cable route drawings shall be provided for updating by Rand Water."]
[null,"Certification inclusive of test certificates, FAT certificates, assembly assessors certificate and Certificates of Compliance shall be provided in hard copy and electronic formats."]
[2.3,"Supply and delivery of cables"]
[null,"In determining the length of cable installed the gland to gland distance will be measured plus additional cable per end as determined below:"]
[null,"a) End at 400 V and 11kV switchgear - 1,5 metres"]
[null,"b) End at any other device - 0,5 metre"]
[null,"Separate items will be scheduled for each type, size and number of cores of cables supplied and/or installed.  The rates shall apply for installation of cables at all levels.  Should cable be required to be installed at levels above two metres completed working platforms (and ground level) an additional rate will be applied reflecting actual costs for scaffolding, scaffold planks, boarding, labour to erect scaffolding etc."]
[]
[2.4,"Cables - supply and install"]
[null,"a) Rates shall include full compensation for the procurement, delivery to site, unloading and on site storage, protection, handling, craneage, measurement of cable runs, cutting, installing the cable in accordance with the specification (including cable jacks and rollers) laying in cable ducts or on cable racking complete with identification tagging and labelling.  Rates shall also include the supply and fixing of all clamps, trefoil clamps for single core cables, cable straps or cable ties etc.  The testing of Medium Voltage cables will be by the Overvoltage Low Frequency Method and by On Line Partial Discharge three months after commissioning. The testing of all 600/1 000 V PVC, PVC, SWA, PVC cable with 1 000 V DC megger shall also be included in the rates.  Instrumentation signal cables shall not be tested with a megger."]
[]
[null,"b) All power and control cables supplied shall comply with SABS 1507 and 1339 Type A and B where applicable and shall bear the SABS mark. Cables shall be 6.35/11 kV XLPE and 600/1 000V PVC, PVC, SWA, PVC with copper conductors and flame retardant, outer sheaths.  "]
[2.5,"Cables - installation only"]
[null,"The rates for the installation only of cables shall include full compensation for the unloading and on site storage, protection, handling, cranage, measurement of cable runs, cutting, installing the cable in accordance with the specification (including cable jacks and rollers) fixing the cable to cable racking with cable ties, complete with identification tagging and labelling. "]
[2.6,"Cable termination"]
[null,"A termination rate is defined as one cable end.  Separate rates shall be supplied for each type of cable end.  Rates shall include full compensation for the supply of all cable glands, tapes, shrouds, termination kits, cutting, stripping, lacing/harnessing crimping, lugs and cable core numbering ferrules in accordance with the specification. The drilling of gland plates shall also be included in rates as well as the treatment of metal parts with cold galvanising paint "]
[2.7,"Cable trenches - excavation and backfill"]
[null,"The excavation and backfilling of cable trenches shall be measured on a cubic meter basis."]
[]
[null,"Rates shall include full compensation for the setting out, supervision, labour, materials, provision of all necessary equipment to complete the backfilling process including the cleaning out of trenches, supply and laying sieved stone free soil or sand, supply, backfilling and compaction of trenches in accordance with the specifications."]
[]
[null,"The rates shall include for the barricading of open cable trenches with orange netting type barricade (danger tape not acceptable)."]
[]
[null,"The contractor shall also protect open cable trenches against subsidence and filling with storm water."]
[]
[null,"The contractor shall repair the tar roads after installation of sleeves as per the Rand Water specification."]
[]
[null,"The contractor shall also measure on a per meter basis for the supply and installation of concrete paving slabs and danger tape in all cable trenches."]
[]
[null,"The excavation of trenches is defined in the terms of the specification as Class 1 soft pickable material or Class 2 Hard Rock. Unless otherwise stated all excavation shall be carried out by hand."]
[]
[null,"Excavations will be classified in two categories only."]
[]
[null,"a) Class 1: Pickable, Earth, hand pickable and soft rock. All ground types including hand pickable rock which do not have to be removed by pneumatic drill, blasting, wedging or other mechanical means. The material may contain significant proportions of boulders and rock which can be removed manually."]
[]
[null,"b) Class 2: Hard Rock, All ground types which can only be broken by pneumatic drill, wedging or other mechanical means."]
[]
[null,"Excavations are measured in the Bills as Class 1 (Pickable) and Class 2 (Hard Rock). No excavations shall be deemed to be Hard Rock unless certified by the Engineer. The Engineer shall be called to site by the Contractor to inspect and certify occurrence of Hard Rock."]
[]
[null,"Cable markers will be measured separately and measured by number. Rates for cable markers shall include full compensation of the manufacture, delivery to site, handling, storage and installation on completion of cable trenching."]
[]
[2.8,"Cable racking - supply and install"]
[]
[]
[null,"Cable racking will be measured by length as installed between fittings which will be measured by number. Separate items are scheduled for each type and size of cable rack, cable rack fittings such as 90 degree bends, tees, elbows, reducers etc for each type and size of rack."]
[]
[null,"Rates shall include full compensation for supply, delivery, storage, installation, cutting, application of corrosion protection, splices, nuts and bolts, drilling, support brackets including spring nuts and bolts, steelwork, tools and hilti/rawl bolts necessary to complete the installation."]
[]
[null,"Where cable racks are installed in the horizontal plane, racks shall be supported at a minimum of 1,2 metre intervals. Where cable racks are installed in the vertical plane, racking shall be supported at a minimum of 1, 5 metre intervals. The support brackets, unistrut supports, painting and treatment of steelwork are inclusive in the cable racking and rates are to be calculated on this basis."]
[]
[null,"The earthing of cable racks shall be measured as a separate item."]
[2.9,"Cable joints - supply and install"]
[null,"Cable joints will be measured by number.  Separate items will be scheduled for each type of kit and cable to be joined."]
[]
[null,"Rates shall cover full compensation for the jointing kits, all labour including specialist labour as required, ferrules, crimping, tape, materials, tools and necessary protection covers for outdoors whilst jointing."]
[]
[2.1,"Earthing and Suppression - supply and install"]
[null,"The Contractor shall connect each plant item e.g. 11kV switchboard and distribution board, etc to the applicable station earth bar.  No allowance will be made for slack, at joints or connections to equipment etc. Earthing will be measured from lug to lug and separate items will be scheduled for copper coated steel wire or insulated earth wire for each size of conductor run with individual circuits.  Rates shall include full compensation for installing the earthing including supply, delivery, measuring of runs, installing in terms of the specification and strapping and supporting as necessary."]
[]
[2.11,"Miscellaneous equipment - supply and installation"]
[null,"The supply and installation of miscellaneous items such as statutory labels, equipment labels and any other piece of equipment not covered in previous clauses will be measured by number  where possible, alternatively by a sum amount."]
[]
[null,"Rates shall include full compensation for the supply, delivery to site, storage, transport, labour handling, brackets, bolts, corrosive protection and fixings."]
[]
[2.12,"Testing and Commissioning"]
[null,"Separate items will be scheduled for the testing and commissioning of MV and LV switchgear, UPS, Mimic Panel and all power cables. Test equipment to be supplied for commissioning shall include but be limited to the following and shall be available on site at all times:"]
[]
[null,"Two off portable electronic instruments (Fluke or approved equivalent)"]
[null,"Two off clip on tong testers (Robin mod 2006F, Fluke or approved equivalent)"]
[null,"500 V / 1 000 V megger"]
[]
[3,"Architecture Preamble"]
[]
[null,"Refer to Standard System of Measuring Building Work 7th Ed: ISBN: 978-0-86886-837-0; The Asscociation of South African Quantity Surveyors"]
[]
[4,"Civil and Pipeline Preamble"]
[]
[4.1,"All tenderers are to ensure that they familiarise themselves with the variations and additions to SANS 1200 which are provided as part of the contract documentation."]
[]
[4.2,"The Tenderer shall state separately against each item the rate per metre of pipe that shall be deemed to include the full inclusive cost of providing the material and of carrying out the work required to manufacture the steel pipe shell, provide the coatings and for the transport to the route of the pipelines, all in accordance with Sub- Clause 7.1 of the Conditions of Contract Fidic Redbook.  The rate shall include all conditions, liabilities, general risks and obligations set forth or implied in the Contract Documents. The preamble hereafter headed Methods of Measurement and Payment regarding the scope of the prices and rates shall be taken as amplifying but not limiting Sub-Clause 7.1 of the Conditions of Contract Fidic Redbook."]

{"sheet":"Schedule 1 OHS","index":2,"n_rows":31,"n_cols":7,"rows_kept":31}
[]
["Item No.","Description","Unit ","Qty (A)","Rate (B)","Amount"]
[]
[1,"SECTION OHS: OCCUPATIONAL HEALTH AND SAFETY"]
[]
[1.1,"Preparation of the Contractor's site specific Health and Safety Plan","Sum",1,null,{"$f":"E6*D6","v":0}]
[]
[1.2,"Principal Contractor's time related obligations in respect of the Occupational Health and Safety Act 85 of 1993 and all applicable  regulations","Sum",1,null,{"$f":"E8*D8","v":0}]
[]
[1.3,"Provision of Personal Protective Equipment (PPE)","Sum",1,null,{"$f":"E10*D10","v":0}]
[]
[]
[1.4,"Cost of medical certificates and medical surveillance"]
[]
["1.4.1","(a) Initial (baseline) medical examinations","Sum",1,null,{"$f":"E15*D15","v":0}]
[]
[]
["1.4.2","(d) Exit examinations","Sum",1,null,{"$f":"E18*D18","v":0}]
[]
[1.5,"Induction training","Sum",1,null,{"$f":"E20*D20","v":0}]
[]
[1.6,"Provision of First Aid Boxes to GSR requirements and other emergency safety equipment such as fire extinguishers.","Sum",1,null,{"$f":"E22*D22","v":0}]
[]
[1.7,"Transportation of Workers","Sum",1,null,{"$f":"E24*D24","v":0}]
[]
[]
[1.8,"Barricading","Sum",1,null,{"$f":"E27*D27","v":0}]
[]
[{"v":1.9,"d":"1.90"},"Safety notices and signs","Sum",1,null,{"$f":"E29*D29","v":0}]
[]
[null,"SECTION 1 CARRIED FORWARD TO SUMMARY",{"$nulls":4},{"$f":"SUM(G30:G30)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Schedule 2 P n G's General","index":3,"n_rows":39,"n_cols":13,"rows_kept":39,"merged":[[1,2,2,5],[1,9,1,11],[2,9,2,11],[3,9,3,11],[8,1,9,1],[8,2,9,2]]}
[]
["Contract No:RW",null,"Description: A14 and A19 Carriage Water Tie-in for the new Chlorine Plant at Vereeniging Pumping Station",{"$nulls":3},"Schedule 2 :  P&G Time Related",null,null,"No Rates or with rates",null,null,0]
[{"$nulls":6},{"$f":"+'COVER PAGE'!D15","v":"2023-10-01"}]
[]
[]
["Item","Payment","Description","Unit","Qty","Rate","Amount"]
["No.","Refers"]
[]
[2,"SABS 1200AA","SECTION A:  PRELIMINARY & GENERAL - GENERAL (Small Works)"]
[]
[]
["2.1",null,"SCHEDULED FIXED-CHARGE AND VALUE-RELATED ITEMS"]
[]
[]
["2.1.1",null,"Guided Wave Ultrasonic Survey to determine the residual pipe wall thickness and condition of the pipe at the tie-in connections.  ","Sum",1]
[]
["2.1.2",null,"Contractual Requirements (items to be broken down and qualified by Contractor during pricing of document)","Sum",1]
["2.1.3",null,"Provision of Facilities on Site"]
[]
["2.1.3.1",null,"a) Facilities required by the Engineer","Sum",1]
["2.1.3.2",null,"b) Facilities required by the Contractor","Sum",1]
[]
["2.1.4",null,"General Responsibilities and other fixed-charge obligations","Sum",1]
[]
["2.1.5",null,"Removal of site establishment","Sum",1]
[]
["2.2",null,"SCHEDULED TIME-RELATED ITEMS"]
[]
["2.2.1",null,"Contractual Requirements (items to be broken down and qualified by Contractor during pricing of document)","Sum",1]
[]
["2.2.2",null,"Operation and Maintenance of Facilities on Site"]
[]
["2.2.2.1",null,"a) Facilities required by the Engineer","Sum",1]
["2.2.2.2",null,"b) Facilities required by the Contractor","Sum",1]
[]
["2.2.3",null,"General Responsibilities and other time-related obligations (items to be broken down and qualified by Contractor during pricing of document)","Sum",1]
[]
[]
[null,null,"SECTION 2 CARRIED FORWARD TO SUMMARY",{"$nulls":3},{"$f":"SUM(G38:G38)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Schedule 3 Valve Chambers","index":4,"n_rows":248,"n_cols":7,"rows_kept":248,"merged":[[1,0,1,1],[1,2,2,5],[247,2,247,4]]}
[]
["Contract No.: RW ",null,"Description: A14 and A19 Carriage Water Tie-in for the new Chlorine Plant at Vereeniging Pumping Station",{"$nulls":3},"Schedule 3:  Valve Chambers"]
[]
["ITEM        NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[3.1,"SANS 1200 C","SECTION C: SITE CLEARANCE"]
[]
["3.1.1",null,"Clear and grub site (and remove any obstruction that may occur. Only areas indicated in writing by the Engineer)"]
[]
["3.1.1.1",null,"i) A14 tie-in chamber","m2",19]
["3.1.1.2",null,"ii) A19 tie-in chamber","m2",19]
{"$rows_empty":31}
[null,null,"Carried Forward "]
[null,null,"Brought Forward"]
[]
[3.2,"SABS      1200DA","SECTION DA: EARTHWORKS"]
[]
["3.2.1",null,"Excavation"]
["3.2.1.1",null,"a) Remove topsoil to nominal depth 150mm, stockpile and maintain"]
[]
["3.2.1.1.1",null,"i) A14 tie-in chamber","m2",{"$f":"0.15*E10","v":{"v":2.85,"d":"3"}}]
["3.2.1.1.2",null,"ii) A19 tie-in chamber","m2",{"$f":"0.15*E11","v":{"v":2.85,"d":"3"}}]
[]
["3.2.1.2",null,"b) Excavate in all materials and use for embankment or backfill or dispose, as ordered ","m3"]
[]
["3.2.1.2.1",null,"i) A14 tie-in chamber","m3",{"$f":"32*1.2","v":{"v":38.4,"d":"38"}}]
["3.2.1.2.2",null,"ii) A19 tie-in chamber","m3",{"$f":"46*1.2","v":{"v":55.199999999999996,"d":"55"}}]
[]
["3.2.2",null,"Importing of material from commercial sources or from borrow pits"]
["3.2.2.1",null,"a) Importing of backfill G7 Material compacted in layers not exceeding 150mm in thickness compacted to 93% MOD AASHTO density at -1% to +2% OMC"]
[]
["3.2.2.1.1",null,"i) A14 tie-in chamber","m3",{"$f":"10*1.2","v":12}]
["3.2.2.1.2",null,"ii) A19 tie-in chamber","m3",{"$f":"10*1.2","v":12}]
[]
["3.2.2.2",null,"b) Suitable stage 1 fill material (refer to DRG. R027141)"]
[]
["3.2.2.2.1",null,"i) A19 tie-in chamber","m3",9.2]
[]
["3.2.3",null,"Topsoiling"]
[]
["3.2.3.1",null,"i) A14 tie-in chamber","m2",{"$f":"+E51","v":{"v":2.85,"d":"3"}}]
["3.2.3.2",null,"ii) A19 tie-in chamber","m2",{"$f":"+E52","v":{"v":2.85,"d":"3"}}]
[]
[]
["3.2.4",null,"Shoring of deep excavations "]
[]
["3.2.4.1",null,"i) A14 tie-in chamber","Sum",1]
["3.2.4.2",null,"ii) A19 tie-in chamber","Sum",1]
[]
[]
[{"$nulls":5},"R"]
[null,null,"Carried Forward "]
[null,null,"Brought Forward",null,null,"R"]
[]
[]
[3.3,"SABS 1200GA","SECTION GA: CONCRETE (SMALL WORKS)"]
[]
["3.3.1",null,"Scheduled Formwork Items"]
["3.3.1.1",null,"Narrow widths"]
["3.3.1.1.1",null,"a) Sides of base slab (250mm high)"]
[]
[]
["3.3.1.1.1.1",null,"i) A14 tie-in chamber","m",7.3]
["3.3.1.1.1.2",null,"ii) A19 tie-in chamber","m",7.3]
["3.3.1.1.1.3",null,"iii) Plinth at A19","m",4]
[]
["3.3.1.2",null,"Box out Holes / Form Voids"]
["3.3.1.2.1",null,"a) Box out hole for 500mm x 500mm x 150mm (deep) sump"]
[]
["3.3.1.2.1.1",null,"i) A14 tie-in chamber","No.",1]
["3.3.1.2.1.2",null,"ii) A19 tie-in chamber","No.",1]
[]
["3.3.2",null,"Scheduled Concrete Items"]
["3.3.2.1",null,"High Tensile Welded Mesh (Mesh Ref. 395)"]
[]
["3.3.2.1.1",null,"i) A14 tie-in chamber","m2",15]
["3.3.2.1.2",null,"ii) A19 tie-in chamber","m2",15]
["3.3.2.1.3",null,"iii) Plinth at A19","m2",2]
[]
[]
["3.3.3",null,"Scheduled Concrete Items"]
["3.3.3.1",null,"Blinding Layer in ….. Concrete"]
[null,null,"(50mm Class 15/19MPa Blinding Layer)"]
[]
["2.3.3.1.1",null,"i) A14 tie-in chamber","m2",8]
["2.3.3.1.2",null,"ii) A19 tie-in chamber","m2",8]
[]
["3.3.3.2",null,"Strength Concrete"]
["2.3.3.2.1",null,"a) Grade 35MPa/19mm"]
[]
["2.3.3.2.1.1",null,"i) A14 tie-in chamber","m3",2]
["2.3.3.2.1.2",null,"ii) A19 tie-in chamber","m3",2]
["2.3.3.2.1.3",null,"iii) Plinth at A19","m2",2]
[]
["2.3.3.2.2",null,"b) Grade 15MPa/19mm"]
[]
["2.3.3.2.2.1",null,"i) A14 tie-in chamber","m3",9]
["2.3.3.2.2.2",null,"ii) A19 tie-in chamber","m3",3]
[]
["3.3.3.3",null,"Unformed surface finishes"]
[null,null,"Wood-floated finish to floor slab"]
[]
["3.3.3.3.1",null,"i) A14 tie-in chamber","m2",8]
["3.3.3.3.2",null,"ii) A19 tie-in chamber","m2",8]
["3.3.3.3.3",null,"iii) Plinth at A19","m2",1]
[]
["3.3.4",null,"Miscellaneous"]
["3.3.4.1",null,"Cast in PVC sleeves:"]
["2.3.4.1.1",null,"a) 110mm diameter x 150mm long including vermin proof mesh"]
[]
["2.3.4.1.1.1",null,"i) A14 tie-in chamber","No.",4]
["2.3.4.1.1.2",null,"ii) A19 tie-in chamber","No.",4]
[]
["3.3.4.2",null,"Cast in standard Rand Water manhole frame and cover (Contractor to collect from Rand Water Central Deport)"]
[]
["3.3.4.2.1",null,"i) A14 tie-in chamber","No.",1]
["3.3.4.2.2",null,"ii) A19 tie-in chamber","No.",1]
[]
["3.3.4.3",null,"Supply and cast in standard Rand Water frame and sump cover (as per DGR No. A8879)"]
[]
["3.3.4.3.1",null,"i) A14 tie-in chamber","No.",1]
["3.3.4.3.2",null,"ii) A19 tie-in chamber","No.",1]
[]
[]
["3.3.4.4",null,"Atactic polypropylene plastic modified asphalt torch-on waterproofing membrane, to be installed by the manufacture (1m width)"]
[]
["3.3.4.4.1",null,"i) A14 tie-in chamber","m",28]
["3.3.4.4.2",null,"ii) A19 tie-in chamber","m",28]
[]
[]
[]
[]
[null,null,"Carried Forward "]
[null,null,"Brought Forward"]
[]
[3.4,"SABS\n1200GE","SECTION GE: PRECAST CONCRETE (STRUCTURAL)"]
[]
["3.4.1",null,"SCHEDULED ITEMS"]
[]
["3.4.1.1",null,"Provide Structural Precast Units"]
[]
["3.4.4.1.1",null,"a) 2000x2000x500x150mm thick precast square units/rings"]
[]
["3.4.4.1.1.1",null,"i) A14 tie-in chamber","No.",5]
["3.4.4.1.1.2",null,"ii) A19 tie-in chamber","No.",5]
[]
["3.4.4.1.2",null,"b) 2300x2300x150mm thick precast square roof slab"]
[]
["3.4.4.1.2.1",null,"i) A14 tie-in chamber","No.",1]
["3.4.4.1.2.2",null,"ii) A19 tie-in chamber","No.",1]
[]
[]
[]
["3.4.1.2",null,"Erection of Structural Precast Units"]
[]
["3.4.1.2.1",null,"a) 2000x2000x500x150mm thick precast square units/rings"]
[]
["3.4.1.2.1.1",null,"i) A14 tie-in chamber","No.",5]
["3.4.1.2.1.2",null,"ii) A19 tie-in chamber","No.",5]
[]
["3.4.1.2.2",null,"b) 2300x2300x150mm thick precast square roof slab"]
[]
["3.4.1.2.2.1",null,"i) A14 tie-in chamber","No.",1]
["3.4.1.2.2.2",null,"ii) A19 tie-in chamber","No.",1]
{"$rows_empty":9}
[null,null,"Carried Forward "]
[null,null,"Brought Forward"]
[]
[3.5,"SABS\n1200HA","SECTION HA: STRUCTURAL STEELWORK (SUNDRY ITEMS)"]
[]
["3.5.1",null,"Scheduled Items"]
["3.5.1.1",null,"Ladders complete and installed"]
[null,null,"Supply and Install Standard Rand Water Catladder (as per DRG No. A7406) "]
[null,null,"2300mm high"]
[]
["3.5.1.1.1",null,"i) A14 tie-in chamber","No.",1]
["3.5.1.1.2",null,"ii) A19 tie-in chamber","No.",1]
[]
["3.5.1.2",null,"Supply and install Grab Rails as detailed on Rand Water Detail (as per DRG. No. A9858)"]
[]
["3.5.1.2.1",null,"i) A14 tie-in chamber","No.",1]
["3.5.1.2.2",null,"ii) A19 tie-in chamber","No.",1]
{"$rows_empty":25}
[null,null,"Carried Forward "]
[]
[null,null,"SECTION 3 CARRIED FORWARD TO SUMMARY",null,null,"R"]

{"sheet":"Schedule 4 Mechanical","index":5,"n_rows":70,"n_cols":7,"rows_kept":70,"merged":[[1,0,1,1],[1,2,2,5],[69,2,69,4]]}
[]
["Contract No.: RW ",null,"Description: A14 and A19 Carriage Water Tie-in for the new Chlorine Plant at Vereeniging Pumping Station",{"$nulls":3},"Schedule 4:  Mechanical Works"]
[]
["ITEM        NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY","RATE","AMOUNT"]
[]
[4,null,"Supply, deliver and install Pipe Specials with lining & coating, Valves as per Rand Water Valve Specifications (including bolts, studs, nuts and washers, gaskets and loose flanges as per Rand Water Flange drawing A11791 and A9548):"]
[]
[]
[]
[4.1,null,"A14 PIPELINE – Dwg RA 61224"]
[]
["4.1.1",null,"200mm NB x OD = 219.1mm x ID = 206.4mm x t = 6.35mm x h= 240mm Grade X42 stub pipe flanged on one end to A11791 and A9548","No.",1]
[]
["4.1.2",null,"200mm NB x OD = 219.1mm x ID = 206.4mm x t = 6.35mm Grade X42 90 deg bend flanged on both ends to A11791 and A9548","No.",1]
[]
["4.1.3",null,"200mm  NB x OD = 425mm x ID = 224mm x t = 8mm Grade X42 compenstaion plate ","No.",1]
[]
["4.1.4",null,"200mm NB x 5 000kPa TP isolation valve complete with gearbox assembly. Valve flanges to RW drawing A11791 and A9548. ","No.",1]
[]
["4.1.5",null,"200mm NB x OD = 219.1mm x ID = 206.4mm x t = 6.35mm x h= 800mm Grade X42 stub pipe flanged on one end to RW drawing A11791 and A9548","No.",1]
[]
["4.1.6",null,"200mm NB loose Flange (5 000kPa TP) as per RW drawing A11791 and A9548","No.",4]
[]
["4.1.7",null,"Flange gaskets, bolts, nuts and washers as per RW Valve Spec RW/0310/AS0460","Sum",1]
[]
["4.1.8",null,"Insulating Flange Kit complete with spark gaps, cable and supporting bracket as per RW drawing A9548","No.",2]
[]
[]
[4.2,null,"A19 PIPELINE – Dwg RA 61223"]
[]
["4.2.1",null,"200mm NB x OD = 219.1mm x ID = 206.4mm x t = 6.35mm x h= 240mm Grade X42 stub pipe flanged on one end to A11791 and A9548","No.",1]
[]
["4.2.2",null,"200mm NB x OD = 219.1mm x ID = 206.4mm x t = 6.35mm Grade X42 90 deg bend flanged on both ends to A11791 and A9548","No.",1]
[]
["4.2.3",null,"200mm  NB x OD = 425mm x ID = 224mm x t = 8mm Grade X42 compenstaion plate ","No.",1]
[]
["4.2.4",null,"200mm NB x 5 000kPa TP isolation valve complete with gearbox assembly. Valve flanges to RW drawing A11791 and A9548. ","No.",1]
[]
["4.2.5",null,"200mm NB x OD = 219.1mm x ID = 206.4mm x t = 6.35mm x h= 800mm Grade X42 stub pipe flanged on one end to RW drawing A11791 and A9548","No.",1]
[]
["4.2.6",null,"200mm NB loose Flange (5 000kPa TP) as per RW drawing A11791 and A9548","No.",4]
[]
["4.2.7",null,"Flange gaskets, bolts, nuts and washers as per RW Valve Spec RW/0310/AS0460","Sum",1]
[]
["4.2.8",null,"Insulating Flange Kit complete with spark gaps, cable and supporting bracket as per RW drawing A9548","No.",2]
{"$rows_empty":24}
[null,null,"SECTION 4 CARRIED FORWARD TO SUMMARY",null,null,"R"]

{"sheet":"Summary All","index":6,"n_rows":41,"n_cols":3,"rows_kept":41,"merged":[[0,2,1,2],[28,0,28,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[36,0,36,1],[38,0,38,2],[40,0,40,2]]}
[null,null,"A14 & A19 Carriage Water Tie-in"]
["Contract No.:","RW"]
["Description:","A14 and A19 Carriage Water Tie-in for the new Chlorine Plant at Vereeniging Pumping Station",{"$f":"+'COVER PAGE'!D15","v":"2023-10-01"}]
[]
[]
[]
[null,"SUMMARY OF PRICING SCHEDULES"]
[]
["Schedule","Description","Amount"]
[]
["Schedule 1","Occupational Health and Safety"]
[]
["Schedule 2","Preliminary and General (Fixed and Time Related Items)"]
[]
["Schedule 3","Valve Chamber"]
[]
["Schedule 4","Mechanical Works "]
{"$rows_empty":11}
["SUBTOTAL E ……………………………………..……………………………………………"]
[]
[]
["VALUE ADDED TAX"]
["Add 15% of Subtotal ………..…….……………………..………...……..………………"]
["(Provisional sum based on current rate of VAT)"]
[]
[]
[]
[]
[]
[]
["SIGNED ON BEHALF OF TENDERER: ……………………………………………..……………………………………………."]

{"sheet":"G CALCS","index":7,"n_rows":60,"n_cols":10,"rows_kept":60,"hidden":true,"merged":[[59,2,59,4]]}
["ITEM NO","PAYMENT REFERS","SHORT DESCRIPTION","UNIT","QUANTITY"]
[]
[null,"SABS","SECTION G: CONCRETE (STRUCTURAL)"]
[null,"1200 GA"]
["GA1","8.2","FORMWORK"]
[null,"8.2.2","Especially Smooth and buffed vertical plane to :"]
["GA1.1",null,"Inside of chamber walls","m²",{"$f":"2*((H26-H34)*(H27-H34*2)+(H26-H34)*(H28-H34*2))+2*((I26-H34)*(I27-H34*2)+(I26-I34)*(I28-I34*2))+2*((J26-J34)*(J27-J34*2)+(J26-J34)*(J28-J34*2))","v":{"v":19.280000000000005,"d":"19"}}]
["GA1.2",null,"Inside of manhole void in chamber cover","m²",{"$f":"((H32*H29+H33*H29)*2)*3","v":{"v":0.9899999999999999,"d":"1"}}]
["GA1.3",null,"Outside of chamber cover","m²",{"$f":"(H30*H29+H31*H29)*2+(I30*I29+I31*I29)*2+(J30*J29+J31*J29)*2","v":{"v":1.7400000000000002,"d":"2"}}]
[]
[null,"8.2.1","Rough below ground"]
[null,null,"Vertical plane to:"]
["GA1.4",null,"Outside of chamber walls","m²",{"$f":"((H26-H34)*H27+(H26-H34)*H28)*2+((I26-I34)*I27+(I26-I34)*I28)*2+((J26-J34)*J27+(J26-J34)*J28)*2","v":{"v":22.944000000000006,"d":"23"}}]
["GA1.5",null,"Outside of chamber floor","m²",{"$f":"(H27*H34+H28*H34)*2+(I27*I34+I28*I34)*2+(J27*J34+J28*J34)*2","v":{"v":1.9200000000000004,"d":"2"}}]
[]
[null,"8.2.2","Especially Smooth and buffed horizontal plane to :"]
["GA1.1",null,"Soffit of chamber cover","m²",{"$f":"H31*H30+I31*I30+J31*J30","v":{"v":8.410000000000002,"d":"8"}}]
[]
["GA2","8.3","REINFORCEMENT"]
[null,null,"Mild steel bars:"]
["GA2.1",null,"Diameters 8 mm to 40 mm: Average price as indicated on schedules","t",{"$f":"E25*0.2","v":{"v":0.13149800000000003,"d":"0.13"}}]
[]
[null,"8.3.2","High-tensile steel bars average"]
[null,null,"price:"]
["GA2.2",null,"Diameters 8 mm to 40 mm: Average price as indicated on schedules","t",{"$f":"E34*0.1","v":{"v":0.6574900000000001,"d":"0.66"}},null,null,"Chamber1","Chamber2","Chamber3"]
[{"$nulls":6},"D1",{"$f":"2.39+0.2","v":2.5900000000000003},0,0]
["GA3","8.4","CONCRETE",{"$nulls":3},"W1",{"$f":"2+0.2+0.2","v":2.4000000000000004},0,0]
[null,"8.4.2","Blinding layer in 15 MPa/19 mm concrete:",{"$nulls":3},"B1",{"$f":"2+0.2+0.2","v":2.4000000000000004},0,0]
["GA3.1",null,"50 mm minimum thickness","m²",{"$f":"H27*H28+I27*I28+J27*J28","v":{"v":5.760000000000002,"d":"6"}},null,"D2",0.15,0,0]
[{"$nulls":6},"W2",{"$f":"H27+0.25+0.25","v":2.9000000000000004},0,0]
[{"$nulls":6},"B2",{"$f":"H28+0.25+0.25","v":2.9000000000000004},0,0]
[null,"8.4.3","Strength concrete: 25MPa/19 mm:",{"$nulls":3},"W3",{"$f":"0.5","v":0.5},0,0]
[{"$nulls":6},"B3",0.6,0,0]
["GA3.4",null,"30MPa/19mm concrete for chambers","m³",{"$f":"(H27*H28*H34+2*((H26-H34)*(H28-H34*2)*H34)+2*((H26-H34)*H27*H34)+(H29*H30*H31-H32*H33*H29))+(I27*I28*I34+2*((I26-I34)*(I28-I34*2)*I34)+2*((I26-I34)*I27*I34)+(I29*I30*I31-I32*I33*I29))+(J27*J28*J34+2*((J26-J34)*(J28-J34*2)*J34)+2*((J26-J34)*J27*J34)+(J29*J30*J31-J32*J33*J29))","v":{"v":6.574900000000001,"d":"7"}},null,"T",0.2,0,0]
[]
[]
[null,"8.4.4","Unformed surface finishings:"]
["GA3.6",null,"Wood floated finish","m²",{"$f":"(H27*H28+H30*H31)+(I27*I28+I30*I31)+(J27*J28+J30*J31)","v":{"v":14.170000000000003,"d":"14"}}]
["GA3.7",null,"Steel floated finish","m²","-"]
[]
["GA4",null,"CONCRETE CUBE-TESTING MACHINE"]
["GA4.1",null,"Testing of concrete cubes","No",{"$f":"3*6","v":18}]
["GA4.2",null,"Supply cube-testing machine on site with recent calibration certificate and water trough","Sum","-"]
{"$rows_empty":16}
[null,null,"TOTAL FOR SECTION GA CARRIED TO SUMMARY"]

{"sheet":"Factor for rates","index":8,"n_rows":1,"n_cols":4,"rows_kept":1,"hidden":true}
["Factor for rates",null,"=",2]

{"sheet":"Sheet1","index":9,"n_rows":58,"n_cols":9,"rows_kept":58,"hidden":true,"merged":[[3,2,3,4]]}
[null,"Mankge-Makuwa Construction cc"]
[null,"SUMMARY OF SCHEDULE OF QUANTITIES"]
[]
[null,"SECTION","DESCRIPTION",{"$nulls":5},"TOTAL"]
[null,"SECTION A",": PRELIMINARY AND GENERAL",{"$nulls":5},{"v":579785,"d":"R 579,785.00"}]
[]
[null,"SECTION C",": SITE CLEARANCE",{"$nulls":5},{"v":269,"d":"R 269.00"}]
[]
[null,"SECTION D",": EARTHWORKS",{"$nulls":5},{"v":21770.98,"d":"R 21,770.98"}]
[]
[null,"SECTION DB",": EARTHWORKS (PIPE TRENCHES)",{"$nulls":5},{"v":7360,"d":"R 7,360.00"}]
[]
[null,"SECTION GA",": CONCRETE (SMALL WORKS)",{"$nulls":5},{"v":140055.8,"d":"R 140,055.80"}]
[]
[null,"TOTAL FOR SCHEDULE OF QUANTITIES",{"$nulls":6},{"$f":"SUM(I5:I14)","v":{"v":749240.78,"d":"R 749,240.78"}}]
[]
[null,"CONTINGENCIES",{"$nulls":6},{"$f":"+I15*0.05","v":{"v":37462.039000000004,"d":"R 37,462.04"}}]
[]
[null,"CONTRACT PRICE ADJUSTMENT",{"$nulls":6},"FIXED"]
[]
[null,"SUB TOTAL",{"$nulls":6},{"$f":"SUM(I15:I19)","v":{"v":786702.819,"d":"R 786,702.82"}}]
[]
[null,"ADD 14 % VAT",{"$nulls":6},{"$f":"+I21*0.14","v":{"v":110138.39466000002,"d":"R 110,138.39"}}]
[]
[null,"TOTAL FOR TENDER ",{"$nulls":6},{"$f":"SUM(I21:I23)","v":{"v":896841.21366,"d":"R 896,841.21"}}]
{"$rows_empty":9}
[null,"SUMMARY OF SCHEDULE OF QUANTITIES"]
[]
[null,"SECTION","DESCRIPTION",{"$nulls":5},"TOTAL"]
[null,"SECTION A",": PRELIMINARY AND GENERAL",{"$nulls":5},{"v":893800,"d":"R 893,800.00"}]
[]
[null,"SECTION C",": SITE CLEARANCE",{"$nulls":5},{"v":440000,"d":"R 440,000.00"}]
[]
[null,"SECTION D",": EARTHWORKS",{"$nulls":5},{"v":3560,"d":"R 3,560.00"}]
[]
[null,"SECTION DB",": EARTHWORKS (PIPE TRENCHES)",{"$nulls":5},{"v":1200,"d":"R 1,200.00"}]
[]
[null,"SECTION GA",": CONCRETE (SMALL WORKS)",{"$nulls":5},{"v":50932,"d":"R 50,932.00"}]
[]
[null,"TOTAL FOR SCHEDULE OF QUANTITIES",{"$nulls":6},{"$f":"SUM(I38:I47)","v":{"v":1389492,"d":"R 1,389,492.00"}}]
[]
[null,"CONTINGENCIES",{"$nulls":6},{"$f":"+I48*0.05","v":{"v":69474.6,"d":"R 69,474.60"}}]
[]
[null,"CONTRACT PRICE ADJUSTMENT",{"$nulls":6},"FIXED"]
[]
[null,"SUB TOTAL",{"$nulls":6},{"$f":"SUM(I48:I52)","v":{"v":1458966.6,"d":"R 1,458,966.60"}}]
[]
[null,"ADD 14 % VAT",{"$nulls":6},{"$f":"+I54*0.14","v":{"v":204255.32400000002,"d":"R 204,255.32"}}]
[]
[null,"TOTAL FOR TENDER ",{"$nulls":6},{"$f":"SUM(I54:I56)","v":{"v":1663221.924,"d":"R 1,663,221.92"}}]