{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Cover Page","Final Summary","Preambles","Bill 1 - P&G","Bill 2 - Dismantling of Equipme","Bill 3 - Equipment Erection","Bill 4 - Yardworks & Earthing","Bill 5 - Stringing & Cabling","Bill 6 - Supply & Install Clamp","Bill 7 - Labels & Miscellaneous","Bill 8 - Dayworks & Prov","Bill 9 - Project Stability"],"not_rendered":{"images":3,"external_links":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Cover Page","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"merged":[[1,1,1,2],[9,2,10,2],[14,1,17,1]]}
[]
[null,"MOOKODI 500MVA TRANSFORMER: STRINGING & CABLING"]
[]
[]
[]
[null,"BILL OF QUANTITIES"]
[]
[null,"ENQUIRY No.:"]
[]
[null,"TENDERER’S NAME:  "]
[]
[]
[null,"THE PRICE:  IN ZAR:",{"$f":"'Final Summary'!G34","v":{"v":2700000,"d":"2 700 000  RAND"}}]
[null,"(excluding VAT)"]
[null,"RAND VALUE IN WORDS:"]
[]
[]
[]
[]
[null,"DATE :"]

{"sheet":"Final Summary","index":1,"n_rows":34,"n_cols":7,"rows_kept":34,"merged":[[3,3,3,4],[9,1,11,1],[9,3,11,4],[9,5,11,6]]}
[]
[]
[null,"EMPLOYER:",null,"NTCSA"]
[null,"PROJECT NAME:",null,"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"]
[null,"PROJECT LOCATION:",null,"NORTH WEST"]
[null,"DISCIPLINE / TRADE:",null,"ELECTRICAL WORKS"]
[]
[null,"MAIN OFFER "]
[null,"FINAL SUMMARY "]
[null,"BILL NUMBER",null,"DESCRIPTION",null,"AMOUNT"]
[]
[]
[]
[null,{"$f":"IF(C14<>\"\",1,\"\")","v":1},"PRELIMINARIES AND GENERAL",null,null,"R",{"$f":"'Bill 1 - P&G'!G69","v":0}]
[]
[null,{"$f":"IF(C16<>\"\",B14+1,\"\")","v":2},"DISMANTLING OF EQUIPMENT",null,null,{"$f":"IF(B16<>\"\",\"R\",\"\")","v":"R"},{"$f":"'Bill 2 - Dismantling of Equipme'!$G$50","v":0}]
[]
[null,{"$f":"IF(C18<>\"\",B16+1,\"\")","v":3},"EQUIPMENT ERECTION",null,null,{"$f":"IF(B18<>\"\",\"R\",\"\")","v":"R"},{"$f":"'Bill 3 - Equipment Erection'!G221","v":0}]
[]
[null,{"$f":"IF(C20<>\"\",B18+1,\"\")","v":4},"YARDWORKS & EARTHING",null,null,{"$f":"IF(B20<>\"\",\"R\",\"\")","v":"R"},{"$f":"'Bill 4 - Yardworks & Earthing'!G50","v":0}]
[]
[null,{"$f":"IF(C22<>\"\",B20+1,\"\")","v":5},"STRINGING & CABLING",null,null,{"$f":"IF(B22<>\"\",\"R\",\"\")","v":"R"},{"$f":"'Bill 5 - Stringing & Cabling'!$G$136","v":{"v":500000,"d":"500,000.00"}}]
[]
[null,{"$f":"IF(C24<>\"\",B22+1,\"\")","v":6},"SUPPLY AND INSTALLATION OF CLAMPS & SPACERS",null,null,{"$f":"IF(B24<>\"\",\"R\",\"\")","v":"R"},{"$f":"'Bill 6 - Supply & Install Clamp'!$G$144","v":0}]
[]
[null,{"$f":"IF(C26<>\"\",B24+1,\"\")","v":7},"LABELS & MISCELLANEOUS",null,null,{"$f":"IF(B26<>\"\",\"R\",\"\")","v":"R"},{"$f":"'Bill 7 - Labels & Miscellaneous'!$G$68","v":0}]
[]
[null,{"$f":"IF(C28<>\"\",B26+1,\"\")","v":8},"DAYWORKS & PROVISIONAL SUMS",null,null,{"$f":"IF(B28<>\"\",\"R\",\"\")","v":"R"},{"$f":"'Bill 8 - Dayworks & Prov'!$G$56","v":0}]
[]
[null,{"$f":"IF(C30<>\"\",B28+1,\"\")","v":9},"PROJECT STABILITY",null,null,{"$f":"IF(B30<>\"\",\"R\",\"\")","v":"R"},{"$f":"'Bill 9 - Project Stability'!$G$15","v":{"v":2200000,"d":"2,200,000.00"}}]
[]
[]
[]
[{"$nulls":4},"SUB-TOTAL  CARRIED TO FORM OF OFFER  (EXCLUDING VAT)","R",{"$f":"SUBTOTAL(9,G13:G30)","v":{"v":2700000,"d":"2,700,000.00"}}]

{"sheet":"Preambles","index":2,"n_rows":57,"n_cols":3,"rows_kept":57}
[]
[]
[null,"NATIONAL TRANSMISION COMPANY SOUTH AFRICA"]
[null,"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"]
[null,"ELECTRICAL WORKS"]
[]
[null,"PREAMBLES"]
[]
[null,1,"The Tenderer is advised to read and understand all aspects and documentation associated with this Enquiry BEFORE inserting his Prices and or Rates and or Amounts. "]
[]
[null,2,"The Bill of Quantities provides the basis of all  valuations of the work, price adjustment (CPA - if applicable) and general progress monitoring. "]
[]
[null,3,"The amount due at each application for payment is measured in terms of the Bill of Quantities. The Contractor provides all  necessary  information which is required to determine amounts due at each application for payment relative to the completed works."]
[]
[null,4,"The total of the prices includes for all direct and indirect costs; overheads, profits, on costs, risks, liabilities, obligations, etc. relative to the contract."]
[]
[null,5,"All values are total values prior to any retention and excludes VAT. Retention is not calculated in the Forecast Rate of Payment (FRP). "]
[]
[null,"A","FREE ISSUE OF MATERIAL BY THE EMPLOYER"]
[]
[null,1,"Tenderers are advised that the Employer may provide certain Free Issue Materials and or Components and or Plant and or Equipment to the Contractor at no cost to the Contractor. The Contractor shall price for the taking delivery, protection, inspection, testing, storing as required and installation complete as more fully described within this Enquiry Documentation."]
[]
[null,"B","GUIDANCE BEFORE PRICING AND MEASURING "]
[]
[null,1,"The NEC's approach to the Preliminary & General (P&G) section of the bill of quantities assumes use will be made of method related charges for project applied for providing the works based on durations shown in the Accepted Programme. Fixed charges for the use of Equipment that are required throughout the construction phase, time related charges for people working in a managerial and supervisory capacity for the period required, and lump sum charges for other facilities or services not directly related to performing work items typically included in other parts of the bill of quantities."]
[]
[]
[null,"C","PROJECT STABILITY"]
[]
[null,1,"All costs will be reimbursed on an actual cost plus fee basis, subject to the submission of valid proof of payment."]
[]
[null,2,"Approval must be obtained from the Employer for any matters related to Project Stability."]
[]
[null,"D","METHOD OF MEASUREMENT "]
[]
[null,1,"The Bill of Quantities comprises of a list of work items and quantities, based on standard methods of measurement, which are either published or stated herein and state the items to be included and how quantities are to be calculated and the items and activities that are deemed to be included within the Rates and Prices inserted by the Tenderer."]
[]
[null,2,"Tenderers shall price the items, taking into account all of the information within and associated with the tender documents and shall include for all matters, which are at the Contractors risk."]
[]
[null,3,"All enquiry documents supplied must be considered for pricing the items in the Bills of Quantities for the completion of the works."]
[]
[null,4,"Unless otherwise stated, items are measured net in accordance with the contract drawings, and no allowance has been made for waste or bulking or compaction or evaporation or loss by any means whatsoever."]
[]
[null,5,"The quantities contained in the Bill of Quantities are provisional and shall not be used for ordering purposes. No claims whatsoever, however arising will be entertained, should the Bill of Quantities have been used for ordering and or procurement purposes. "]
[]
[null,"E","RATES AND PRICES"]
[]
[null,1,"Rates and Prices shall be expressed to two decimal places (i.e. cents) except in the case of a NIL rate or price."]
[]
[null,2,"The Tenderers Rates and Prices shall be inserted in the Bill of Quantities and are deemed to be the fully inclusive Rates and Prices to the Employer for the work described under the several items. Such Rates and Prices shall cover all costs and expenses that may be required in, and for the prompt and efficient and safe execution of the work described, and shall cover the cost of all general risks, liabilities and obligations set forth or implied in this Enquiry document."]
[]
[null,3,"Rates and Prices for items which are required to be inserted in the bill of quantities by the Tenderer and which have not been duly inserted, are deemed to be covered by other Rates and Prices in the bill of quantities. "]
[]
[null,4,"The Tenderers omission to insert Rates and Prices shall not be deemed to be a qualified exclusion to execute such work, activity or responsibility."]
[]
[null,5,"The Rates and Prices are deemed to include (unless otherwise specifically stated in the Bill of Quantities or herein) all the relevant costs associated with the Clauses of Contract as amended and shall include but not be limited to the following cost components:"]
[null,null,"› The Tenderer is deemed to have obtained all the necessary information required to adequately price the scope of work  associated with this Enquiry and no claim shall be considered resulting from lack of knowledge in this respect."]

{"sheet":"Bill 1 - P&G","index":3,"n_rows":69,"n_cols":7,"rows_kept":69,"merged":[[3,1,3,4]]}
[]
[]
[null,{"$f":"Preambles!B3","v":"NATIONAL TRANSMISION COMPANY SOUTH AFRICA"}]
[null,{"$f":"Preambles!B4","v":"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"}]
[null,{"$f":"Preambles!B5","v":"ELECTRICAL WORKS"}]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[]
[null,null,"BILL NO. 1 - PRELIMINARIES AND GENERAL"]
[]
[null,null,"(Applicable to the whole of the Works) "]
[]
[null,null,"Notes to Tenderers:"]
[]
[null,null,"The following bills in this section, are according to the \"SANS 1200 System for Measuring Civil Works\" as published by the SANS."]
[]
[null,null,"The Contractor shall price Bill No. 1 - Preliminary and General in respect of all payment required for any work, risk, contingency or obligation whatsoever, that is not described in the Bill of Quantities and which is his responsibility under the Contract"]
[null,null,"PRELIMINARIES AND GENERAL "]
[]
[null,null,"SCHEDULED FIXED CHARGE ITEMS"]
[]
[null,1,"Contractual requirements.","sum","1",null,{"$f":"SUM(E22:F22)","v":0}]
[]
[null,{"$f":"B22+1","v":2},"Site establishment.","sum","1",null,{"$f":"SUM(E24:F24)","v":0}]
[]
[null,{"$f":"B24+1","v":3},"Removal of site establishment.","sum","1",null,{"$f":"SUM(E26:F26)","v":0}]
[]
[null,{"$f":"B26+1","v":4},"Water supplies, electric power and\ncommunications.","sum","1",null,{"$f":"SUM(E28:F28)","v":0}]
[]
[null,null,"SCHEDULED TIME RELATED ITEMS"]
[]
[null,null,"Operation and maintenance of facilities on site for duration of construction, (unless otherwise stated)."]
[]
[null,null,"Establishment of Facilities on the Site"]
[]
[null,null,"Facilities for the Engineer:"]
[]
[null,{"$f":"B28+1","v":5},"Name boards.","sum","1",null,{"$f":"SUM(E38:F38)","v":0}]
[]
[null,{"$f":"B38+1","v":6},"Operation and maintenance of Employer's fully furnished site offices water and electricity supplies, printer, internet connection, etc. ","sum","1",null,{"$f":"SUM(E40:F40)","v":0}]
[]
[null,null,"Facilities for the Contractor:"]
[]
[null,{"$f":"B40+1","v":7},"Operation and maintenance of offices and storage sheds.","sum","1",null,{"$f":"SUM(E44:F44)","v":0}]
[]
[null,{"$f":"B44+1","v":8},"Living accommodation. ","sum","1",null,{"$f":"SUM(E46:F46)","v":0}]
[]
[null,{"$f":"B46+1","v":9},"Ablution and latrine facilities (chemical portable toilets to be well maintained / serviced for the entire duration of the contract).","sum","1",null,{"$f":"SUM(E48:F48)","v":0}]
[]
[null,{"$f":"B48+1","v":10},"Water supplies (including transporting of water to site in water cart for construction purposes and supplying of potable water), electric power, compressed air supply and communications (are ALL to be made available from the beginning of the contract and for the entire duration of the contract).","sum","1",null,{"$f":"SUM(E50:F50)","v":0}]
[]
[null,{"$f":"B50+1","v":11},"Security for the works for the duration of the contract. ","sum","1",null,{"$f":"SUM(E52:F52)","v":0}]
[]
[null,{"$f":"B52+1","v":12},"Complying with Health and Safety Specifications.","sum","1",null,{"$f":"SUM(E54:F54)","v":0}]
[]
[null,{"$f":"B54+1","v":13},"Complying with Environmental Management Programme Act and all other statutory environmental requirements.","sum","1",null,{"$f":"SUM(E56:F56)","v":0}]
[]
[null,{"$f":"B56+1","v":14},"Contractor's transport.","sum","1",null,{"$f":"SUM(E58:F58)","v":0}]
[]
[null,{"$f":"B58+1","v":15},"Supervision for duration of construction. ","sum","1",null,{"$f":"SUM(E60:F60)","v":0}]
[]
[null,{"$f":"B60+1","v":16},"Operation and maintenance of plant.","sum","1",null,{"$f":"SUM(E62:F62)","v":0}]
[]
[null,{"$f":"B62+1","v":17},"Tools and equipment.","sum","1",null,{"$f":"SUM(E64:F64)","v":0}]
[]
[null,{"$f":"B64+1","v":18},"Company and head office overhead costs for duration of construction.","sum","1",null,{"$f":"SUM(E66:F66)","v":0}]
[]
[]
[null,null,"Total Carried Forward to Main Summary Page",{"$nulls":3},{"$f":"SUM(G22:G66)","v":0}]

{"sheet":"Bill 2 - Dismantling of Equipme","index":4,"n_rows":50,"n_cols":7,"rows_kept":50,"merged":[[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6]]}
[]
[null,{"$f":"'Bill 1 - P&G'!B3","v":"NATIONAL TRANSMISION COMPANY SOUTH AFRICA"}]
[null,"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"]
[null,{"$f":"'Bill 1 - P&G'!B5","v":"ELECTRICAL WORKS"}]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[]
[]
[null,null,"BILL NO. 2 - DISMANTLING OF EQUIPMENT, CONDUCTOR, CLAMPS, FOUNDATIONS, ETC."]
[]
[null,null,"Equipment"]
[]
[null,null,"Dismantle the following (complete):"]
[]
[null,1,"Current transformer (400kV).","no.","48",null,{"$f":"E15*F15","v":0}]
[]
[null,{"$f":"1+B15","v":2},"Current transformer (132kV).","no.","6",null,{"$f":"E17*F17","v":0}]
[]
[null,{"$f":"1+B17","v":3},"Capactive voltage transformer (400kV).","no.","51",null,{"$f":"E19*F19","v":0}]
[]
[null,{"$f":"1+B19","v":4},"Circuit breaker.","no.","3",null,{"$f":"E21*F21","v":0}]
[]
[null,{"$f":"1+B21","v":5},"Earth switch.","no.",{"$f":"(1*6)","v":6},null,{"$f":"E23*F23","v":0}]
[]
[null,{"$f":"1+B23","v":6},"Plug box.","no.","10",null,{"$f":"E25*F25","v":0}]
[]
[null,{"$f":"1+B25","v":7},"Junction box (incl. copper).","no.",{"$f":"(2*6)+(1*6)","v":18},null,{"$f":"E27*F27","v":0}]
[]
[null,{"$f":"1+B27","v":8},"2 × 800 mm² Bull conductor.","m",{"v":2800,"d":"2,800"},null,{"$f":"E29*F29","v":0}]
[]
[null,{"$f":"1+B29","v":9},"Clamps (Provisional).","no.",150,null,{"$f":"E31*F31","v":0}]
[]
[]
[null,null,"Support Steelwork"]
[]
[null,null,"Dismantle existing support structures (complete):"]
[]
[null,"10","Structural steel.","kg",{"v":3500,"d":"3,500"},null,{"$f":"E38*F38","v":0}]
[]
[]
[null,null,"Foundations"]
[]
[null,null,"Dismantle existing foundations below 100mm, cover with yardstone and dispose off other material to nearest registered dump site (complete):"]
[]
[null,"11","Junction box (400kV).","no.",{"$f":"(2*6)+(1*6)","v":18},null,{"$f":"E45*F45","v":0}]
[]
[null,"12","Base equipment foundations (Provisional).","no.","45",null,{"$f":"E47*F47","v":0}]
[]
[]
[null,null,"Total Carried Forward to Main Summary Page",{"$nulls":3},{"$f":"SUM(G15:G49)","v":0}]

{"sheet":"Bill 3 - Equipment Erection","index":5,"n_rows":221,"n_cols":7,"rows_kept":221,"merged":[[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6]]}
[]
[null,{"$f":"'Bill 2 - Dismantling of Equipme'!B2","v":"NATIONAL TRANSMISION COMPANY SOUTH AFRICA"}]
[null,"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"]
[null,{"$f":"'Bill 1 - P&G'!B5","v":"ELECTRICAL WORKS"}]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[]
[]
[null,null,"BILL NO. 3 - EQUIPMENT ERECTION"]
[]
[null,null,"Note to tenderer: Unless otherwise stated below, equipment to be supplied by NTCSA including the storage for these items."]
[]
[null,null,"Note: It is the contractor’s responsibility to verify all quantities from the issued drawings and through physical site measurements prior to placing any material or equipment orders."]
[]
[null,null,"HV Primary Plant Equipment"]
[]
[null,null,"Erect the following equipment in the 400kV yard:"]
[]
[null,1,"Auto transformer 500MVA","no.",1,null,{"$f":"E19*F19","v":0}]
[]
[null,{"$f":"1+B19","v":2},"Tertiary transformer 315mVA","no.",1,null,{"$f":"E21*F21","v":0}]
[]
[null,{"$f":"1+B21","v":3},"Capactive voltage transformer.","no.",6,null,{"$f":"E23*F23","v":0}]
[]
[null,{"$f":"1+B23","v":4},"Circuit Breaker (set).","no.",4,null,{"$f":"E25*F25","v":0}]
[]
[null,{"$f":"1+B25","v":5},"Conventional isolator LHES.","no.",1,null,{"$f":"E27*F27","v":0}]
[]
[null,{"$f":"1+B27","v":6},"Conventional isolator RHES.","no.",1,null,{"$f":"E29*F29","v":0}]
[]
[null,{"$f":"1+B29","v":7},"Conventional isolator 2ES.","no.",3,null,{"$f":"E31*F31","v":0}]
[]
[null,{"$f":"1+B31","v":8},"Current transformer.","no.",12,null,{"$f":"E33*F33","v":0}]
[]
[null,{"$f":"1+B33","v":9},"Earth switch.","no.",1,null,{"$f":"E35*F35","v":0}]
[]
[null,{"$f":"1+B35","v":10},"Isolator, pantograph 0ES (set).","no.",2,null,{"$f":"E37*F37","v":0}]
[]
[null,{"$f":"1+B37","v":11},"Isolator, pantograph 1ES (set).","no.",2,null,{"$f":"E39*F39","v":0}]
[]
[null,{"$f":"1+B39","v":12},"Post insulators C6-1550 with PI fittings.","no.",30,null,{"$f":"E41*F41","v":0}]
[]
[null,{"$f":"1+B41","v":13},"Post insulators C10-1550 with PI fittings.","no.",117,null,{"$f":"E43*F43","v":0}]
[]
[null,{"$f":"1+B43","v":14},"Stub insulators epoxy resin.","no.","21",null,{"$f":"E45*F45","v":0}]
[]
[null,{"$f":"1+B45","v":15},"Surge arrestor.","no.",3,null,{"$f":"E47*F47","v":0}]
[]
[null,{"$f":"1+B47","v":16},"Junction boxes.","no.",6,null,{"$f":"E49*F49","v":0}]
[]
[null,{"$f":"1+B49","v":17},"Plug boxes.","no.",2,null,{"$f":"E51*F51","v":0}]
[]
[null,{"$f":"1+B51","v":18},"TDB.","no.",1,null,{"$f":"E53*F53","v":0}]
[]
[]
[null,null,"Erect the following equipment in the 132kV yard:"]
[]
[null,{"$f":"1+B53","v":19},"Auxiliary transformer.","no.",2,null,{"$f":"E58*F58","v":0}]
[]
[null,{"$f":"1+B58","v":20},"Circuit Breaker (set).","no.",3,null,{"$f":"E60*F60","v":0}]
[]
[null,{"$f":"1+B60","v":21},"Conventional isolator RHES.","no.",1,null,{"$f":"E62*F62","v":0}]
[]
[null,{"$f":"1+B62","v":22},"Conventional isolator 1ES.","no.",2,null,{"$f":"E64*F64","v":0}]
[]
[null,{"$f":"1+B64","v":23},"Current transformer.","no.",9,null,{"$f":"E66*F66","v":0}]
[]
[null,{"$f":"1+B66","v":24},"Earth switch.","no.",1,null,{"$f":"E68*F68","v":0}]
[]
[null,{"$f":"1+B68","v":25},"Isolator, pantograph 0ES (set).","no.",1,null,{"$f":"E70*F70","v":0}]
[]
[null,{"$f":"1+B70","v":26},"Isolator, pantograph 1ES (set).","no.",2,null,{"$f":"E72*F72","v":0}]
[]
[null,{"$f":"1+B72","v":27},"Post insulators C6-550.","no.",16,null,{"$f":"E74*F74","v":0}]
[]
[null,{"$f":"1+B74","v":28},"Post insulators C10-550.","no.",72,null,{"$f":"E76*F76","v":0}]
[]
[null,{"$f":"1+B76","v":29},"Surge arrestor.","no.",6,null,{"$f":"E78*F78","v":0}]
[]
[null,{"$f":"1+B78","v":30},"Voltage transformer.","no.",3,null,{"$f":"E80*F80","v":0}]
[]
[null,{"$f":"1+B80","v":31},"Junction boxes.","no.",2,null,{"$f":"E82*F82","v":0}]
[]
[null,{"$f":"1+B82","v":32},"Plug boxes.","no.",1,null,{"$f":"E84*F84","v":0}]
[]
[]
[null,null,"Strain Clamps:"]
[]
[null,null,"Supply and deliver the following:"]
[]
[null,{"$f":"1+B84","v":33},"Polymeric longrod - 400kV.","no.",30,null,{"$f":"E91*F91","v":0}]
[]
[null,{"$f":"1+B91","v":34},"Polymeric longrod - 132kV.","no.",120,null,{"$f":"E93*F93","v":0}]
[]
[null,{"$f":"1+B93","v":35},"Polymeric longrod - 22kV.","no.",3,null,{"$f":"E95*F95","v":0}]
[]
[null,null,"Install the following:"]
[]
[null,{"$f":"1+B95","v":36},"Polymeric longrod - 400kV.","no.",30,null,{"$f":"E99*F99","v":0}]
[]
[null,{"$f":"1+B99","v":37},"Polymeric longrod - 132kV.","no.",120,null,{"$f":"E101*F101","v":0}]
[]
[null,{"$f":"1+B101","v":38},"Polymeric longrod - 22kV.","no.",3,null,{"$f":"E103*F103","v":0}]
[]
[]
[null,null,"Strain Clamps:"]
[]
[null,null,"Supply and deliver the following:"]
[]
[null,{"$f":"1+B103","v":39},"EW1, 10-21.5mm.","no.","75",null,{"$f":"E110*F110","v":0}]
[]
[null,{"$f":"1+B110","v":40},"EW1, 10-21.5mm c/w twited clevis tongue.","no.","25",null,{"$f":"E112*F112","v":0}]
[]
[null,{"$f":"1+B112","v":41},"3.7 – 14.3 Dia. (PG clamp) for overhead E/W Hare Conductor.","no.","40",null,{"$f":"E114*F114","v":0}]
[]
[null,null,"Install the following:"]
[]
[null,{"$f":"1+B114","v":42},"EW1, 10-21.5mm.","no.","75",null,{"$f":"E118*F118","v":0}]
[]
[null,{"$f":"1+B118","v":43},"EW1, 10-21.5mm c/w twited clevis tongue.","no.","25",null,{"$f":"E120*F120","v":0}]
[]
[null,{"$f":"1+B120","v":44},"3.7 – 14.3 Dia. (PG clamp) for overhead E/W Hare Conductor.","no.","40",null,{"$f":"E122*F122","v":0}]
[]
[]
[null,null,"Single Strain Assembly:"]
[]
[null,null,"Supply and deliver the following:"]
[]
[null,{"$f":"1+B122","v":45},"A40; 26mm single conductor.","no.","5",null,{"$f":"E129*F129","v":0}]
[]
[null,{"$f":"1+B129","v":46},"B45; 38 x 150mm twin conductor.","no.","140",null,{"$f":"E131*F131","v":0}]
[]
[null,{"$f":"1+B131","v":47},"38mm Triple conductor.","no.","45",null,{"$f":"E133*F133","v":0}]
[]
[null,null,"Install the following:"]
[]
[null,{"$f":"1+B133","v":48},"A40; 26mm single conductor.","no.","5",null,{"$f":"E137*F137","v":0}]
[]
[null,{"$f":"1+B137","v":49},"B45; 38 x 150mm twin conductor.","no.","140",null,{"$f":"E139*F139","v":0}]
[]
[null,{"$f":"1+B139","v":50},"38mm Triple conductor.","no.","45",null,{"$f":"E141*F141","v":0}]
[]
[]
[null,null,"\"V\" Suspension Assembly:"]
[]
[null,null,"Supply and deliver the following:"]
[]
[null,{"$f":"1+B141","v":51},"38 x 150mm Twin conductor.","no.","5",null,{"$f":"E148*F148","v":0}]
[]
[null,null,"Install the following:"]
[]
[null,{"$f":"1+B148","v":52},"38 x 150mm Twin conductor.","no.","5",null,{"$f":"E152*F152","v":0}]
[]
[]
[null,null,"Protection Schemes:"]
[]
[null,null,"Install the following:"]
[]
[null,{"$f":"1+B152","v":53},"5FZ3910.","no.","4",null,{"$f":"E159*F159","v":0}]
[]
[null,{"$f":"1+B159","v":54},"6BC-2010-M1.","no.","1",null,{"$f":"E161*F161","v":0}]
[]
[null,{"$f":"1+B161","v":55},"6BC-2010-M2.","no.","1",null,{"$f":"E163*F163","v":0}]
[]
[null,{"$f":"1+B163","v":56},"6TA-2300-M1.","no.","1",null,{"$f":"E165*F165","v":0}]
[]
[null,{"$f":"1+B165","v":57},"6TA7300-M2.","no.","1",null,{"$f":"E167*F167","v":0}]
[]
[null,{"$f":"1+B167","v":58},"6BC-2210-M1.","no.","2",null,{"$f":"E169*F169","v":0}]
[]
[null,{"$f":"1+B169","v":59},"6BC-2210-M2.","no.","2",null,{"$f":"E171*F171","v":0}]
[]
[null,{"$f":"1+B171","v":60},"6BC-2310-M1.","no.","1",null,{"$f":"E173*F173","v":0}]
[]
[null,{"$f":"1+B173","v":61},"6BC-2310-M2.","no.","1",null,{"$f":"E175*F175","v":0}]
[]
[null,{"$f":"1+B175","v":62},"6BC-2910-M1.","no.","1",null,{"$f":"E177*F177","v":0}]
[]
[null,{"$f":"1+B177","v":63},"6BC-2910-M2.","no.","1",null,{"$f":"E179*F179","v":0}]
[]
[null,null,"TeleControl (SCADA):"]
[]
[null,null,"Supply and deliver the following:"]
[]
[null,{"$f":"1+B175","v":62},"Supply and install patch panels, boxes and leads.","no.","42",null,{"$f":"E185*F185","v":0}]
[]
[null,{"$f":"1+B185","v":63},"Supply and install Ethernet switches, patch panels, boxes and leads.","no.","14",null,{"$f":"E187*F187","v":0}]
[]
[null,null,"Install the following:"]
[]
[null,{"$f":"1+B187","v":64},"Supply and install patch panels, boxes and leads.","no.","42",null,{"$f":"E191*F191","v":0}]
[]
[null,{"$f":"1+B191","v":65},"Supply and install Ethernet switches, patch panels, boxes and leads.","no.","14",null,{"$f":"E193*F193","v":0}]
[]
[]
[null,null,"Miscellaneous:"]
[]
[null,null,"Install the following:"]
[]
[null,{"$f":"1+B193","v":66},"Breaker PIU IED (Main 1 - EHV & HV).","no.","4",null,{"$f":"E200*F200","v":0}]
[]
[null,{"$f":"1+B200","v":67},"Breaker PIU IED (Main 2 - EHV & HV).","no.","4",null,{"$f":"E202*F202","v":0}]
[]
[null,{"$f":"1+B202","v":68},"VT selection modules.","no.","12",null,{"$f":"E204*F204","v":0}]
[]
[null,{"$f":"1+B204","v":69},"Breaker PIU IED (Main 1 - EHV & HV).","no.","4",null,{"$f":"E206*F206","v":0}]
[]
[null,{"$f":"1+B206","v":70},"Breaker PIU IED (Main 2 - EHV & HV) .","no.","4",null,{"$f":"E208*F208","v":0}]
[]
[null,{"$f":"1+B208","v":71},"Transformer PIU.","no.","7",null,{"$f":"E210*F210","v":0}]
[]
[null,{"$f":"1+B210","v":72},"Transformer PIU IED (Main 2 - EHV & HV) .","no.","4",null,{"$f":"E212*F212","v":0}]
[]
[null,{"$f":"1+B212","v":73},"TC PIU.","no.","8",null,{"$f":"E214*F214","v":0}]
[]
[null,{"$f":"1+B214","v":74},"Reactor PIU IED (Main 1 - EHV & HV) .","no.","4",null,{"$f":"E216*F216","v":0}]
[]
[null,{"$f":"1+B216","v":75},"Reactor PIU IED (Main 2 - EHV & HV) .","no.","4",null,{"$f":"E218*F218","v":0}]
[]
[]
[null,null,"Total Carried Forward to Main Summary Page",{"$nulls":3},{"$f":"SUM(G19:G220)","v":0}]

{"sheet":"Bill 4 - Yardworks & Earthing","index":6,"n_rows":50,"n_cols":7,"rows_kept":50,"merged":[[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6]]}
[]
[null,{"$f":"'Bill 3 - Equipment Erection'!B2","v":"NATIONAL TRANSMISION COMPANY SOUTH AFRICA"}]
[null,"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"]
[null,{"$f":"'Bill 1 - P&G'!B5","v":"ELECTRICAL WORKS"}]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[]
[]
[null,null,"BILL NO. 4 - YARDWORKS & EARTHING"]
[]
[null,null,"Note: It is the contractor’s responsibility to verify all quantities from the issued drawings and through physical site measurements prior to placing any material or equipment orders."]
[]
[null,null,"EARTHING"]
[]
[null,null,"Supply, deliver and lay copper earth mat, equipment earthing, earth straps, including excavation in all material, risk of collapse, bedding, backfill, compaction and testing at depths up to (See Earth Mat Specifications).  annealed black copper (0.701kg/m): "]
[]
[null,"1","Supply and install 1 x 10mm diameter round copper.                                                                                   ","m",{"v":2300,"d":"2,300"},null,{"$f":"E17*F17","v":0}]
[]
[null,{"$f":"1+B17","v":2},"Supply and install 50 x 3mm flat copper.                                                                                   ","m","580",null,{"$f":"E19*F19","v":0}]
[]
[null,{"$f":"1+B19","v":3},"Supply and install crimp joints 10mm round to round (refer to 0.54/393 C5).","no.","310",null,0]
[]
[null,{"$f":"1+B21","v":4},"Earthtail clamp","no.","400",null,0]
[]
[null,{"$f":"1+B23","v":5},"Braze connection of flat copper (flat to flat)","no.","600",null,0]
[]
[null,{"$f":"1+B25","v":6},"Terminate earth strap at both ends and securing strap to steelwork or wall where required, including all necessary accessories.","no.",{"v":1800,"d":"1,800"},null,0]
[]
[null,{"$f":"1+B27","v":7},"Supply and install copper earthing studs, 20kA.                                                                                ","no.",200,null,0]
[]
[]
[null,null,"TRENCHING"]
[]
[]
[null,{"$f":"1+B29","v":8},"Excavating, backfilling and consolidation in pickable ground.","m³",{"v":1550,"d":"1,550"},null,{"$f":"E35*F35","v":0}]
[]
[null,{"$f":"1+B35","v":9},"Safely remove yardstone and stockpile for re-use later.","m²",{"v":70000,"d":"70,000"},null,0]
[]
[null,{"$f":"1+B37","v":10},"Reinstate previously removed yardstone.","m²",{"v":70000,"d":"70,000"},null,0]
[]
[null,{"$f":"1+B39","v":11},"Supply and spread yardstone (Provisional).","m²",{"v":5000,"d":"5,000"},null,0]
[]
[null,{"$f":"1+B41","v":12},"Open and close trench covers.","no.",{"v":12000,"d":"12,000"},null,0]
[]
[null,{"$f":"1+B43","v":13},"Construct complete single trench.","m","500",null,0]
[]
[null,{"$f":"1+B45","v":14},"Construct complete double trench.","m","500",null,0]
[]
[]
[null,null,"Total Carried Forward to Main Summary Page",{"$nulls":3},{"$f":"SUM(G17:G47)","v":0}]

{"sheet":"Bill 5 - Stringing & Cabling","index":7,"n_rows":136,"n_cols":7,"rows_kept":136,"merged":[[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6]]}
[]
[null,{"$f":"'Bill 4 - Yardworks & Earthing'!B2","v":"NATIONAL TRANSMISION COMPANY SOUTH AFRICA"}]
[null,"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"]
[null,{"$f":"'Bill 1 - P&G'!B5","v":"ELECTRICAL WORKS"}]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[]
[]
[null,null,"BILL NO. 5 - STRINGING & CABLING"]
[]
[null,null,"Note: It is the contractor’s responsibility to verify all quantities from the issued drawings and through physical site measurements prior to placing any material or equipment orders."]
[]
[null,null,"Conductor"]
[]
[null,null,"Supply and deliver:"]
[]
[null,{"$f":"1","v":1},"Bull - 61/4.26mm AL (38.3mm Dia.)","m",{"v":6021,"d":"6,021"},null,{"$f":"E17*F17","v":0}]
[]
[null,{"$f":"1+B17","v":2},"Centipede - 37/3.78mm AL (26.5mm Dia.)","m",{"v":4162,"d":"4,162"},null,{"$f":"E19*F19","v":0}]
[]
[null,{"$f":"1+B19","v":3},"Hare - 6/4.72mm AL ¼, 72mm ST (14.16 Dia.)","m",{"v":2500,"d":"2,500"},null,{"$f":"E21*F21","v":0}]
[]
[null,{"$f":"1+B21","v":4},"PVC insulated Centipede - 37/3.78mm AL (36MM O/D)","m",18,null,{"$f":"E23*F23","v":0}]
[]
[null,{"$f":"1+B23","v":5},"PVC insulated Hornet 19/3.25mm AL (29mm O/D)","m",3,null,{"$f":"E25*F25","v":0}]
[]
[null,{"$f":"1+B25","v":6},"Bull - 61/4.26mm AL (38.3mm Dia.) on Project Manager's instruction.","m",{"v":1500,"d":"1,500"},null,{"$f":"E27*F27","v":0}]
[]
[null,null,"Rolling out and install:"]
[]
[null,{"$f":"1+B27","v":7},"Bull - 61/4.26mm AL (38.3mm Dia.)","m",{"v":6021,"d":"6,021"},null,{"$f":"E31*F31","v":0}]
[]
[null,{"$f":"1+B31","v":8},"Centipede - 37/3.78mm AL (26.5mm Dia.)","m",{"v":4162,"d":"4,162"},null,{"$f":"E33*F33","v":0}]
[]
[null,{"$f":"1+B33","v":9},"Hare - 6/4.72mm AL ¼, 72mm ST (14.16 Dia.)","m",{"v":2500,"d":"2,500"},null,{"$f":"E35*F35","v":0}]
[]
[null,{"$f":"1+B35","v":10},"PVC insulated Centipede - 37/3.78mm AL (36MM O/D)","m",18,null,{"$f":"E37*F37","v":0}]
[]
[null,{"$f":"1+B37","v":11},"PVC insulated Hornet 19/3.25mm AL (29mm O/D)","m",3,null,{"$f":"E39*F39","v":0}]
[]
[null,{"$f":"1+B39","v":12},"Bull - 61/4.26mm AL (38.3mm Dia.) (Provisional)","m",{"v":1500,"d":"1,500"},null,{"$f":"E41*F41","v":0}]
[]
[]
[null,null,"Cabling"]
[]
[null,null,"NTCSA has the responsibility to dispose all the cable that is removed."]
[]
[null,{"$f":"1+B41","v":13},"BVX 2 ECV   (Disconnect and remove existing cable) (Provisional).","m",{"v":7000,"d":"7,000"},null,{"$f":"E48*F48","v":0}]
[null,{"$f":"1+B48","v":14},"BVX 2 ECV   (Supply and deliver).","m",{"v":29200,"d":"29,200"},null,{"$f":"E49*F49","v":0}]
[null,{"$f":"1+B49","v":15},"BVX 2 ECV   (Installing and testing new cable).","m",{"v":29200,"d":"29,200"},null,{"$f":"E50*F50","v":0}]
[null,{"$f":"1+B50","v":16},"BVX 2 ECV   (Gland supply).","no.",200,null,0]
[null,{"$f":"1+B51","v":17},"BVX 2 ECV   (Terminations).","no.",200,null,0]
[]
[null,{"$f":"1+B52","v":18},"BVX 4 ECV   (Disconnect and remove existing cable) (Provisional).","m",{"v":5400,"d":"5,400"},null,0]
[null,{"$f":"1+B54","v":19},"BVX 4 ECV   (Supply and deliver).","m",{"v":21000,"d":"21,000"},null,{"$f":"E55*F55","v":0}]
[null,{"$f":"1+B55","v":20},"BVX 4 ECV   (Installing and testing new cable)","m",{"v":21000,"d":"21,000"},null,0]
[null,{"$f":"1+B56","v":21},"BVX 4 ECV   (Gland supply)","no.",122,null,0]
[null,{"$f":"1+B57","v":22},"BVX 4 ECV   (Terminations)","no.",122,null,0]
[]
[null,{"$f":"1+B58","v":23},"BVX 4 HCV (Disconnect and remove existing cable) (Provisional).","m",{"v":1700,"d":"1,700"},null,0]
[null,{"$f":"1+B60","v":24},"BVX 4 HCV (Supply and deliver).","m",{"v":7100,"d":"7,100"},null,{"$f":"E61*F61","v":0}]
[null,{"$f":"1+B61","v":25},"BVX 4 HCV (Installing and testing new cable)","m",{"v":7100,"d":"7,100"},null,0]
[null,{"$f":"1+B62","v":26},"BVX 4 HCV (Gland supply)","no.",42,null,0]
[null,{"$f":"1+B63","v":27},"BVX 4 HCV (Terminations)","no.",42,null,0]
[]
[null,{"$f":"1+B64","v":28},"BVX 4 LCV   (Disconnect and remove existing cable) (Provisional).","m",140,null,{"$f":"E66*F66","v":0}]
[null,{"$f":"1+B66","v":29},"BVX 4 LCV  (Supply and deliver).","m",140,null,0]
[null,{"$f":"1+B67","v":30},"BVX 4 LCV   (Installing and testing new cable)","m",140,null,0]
[null,{"$f":"1+B68","v":31},"BVX 4 LCV   (Gland supply)","no.",32,null,0]
[null,{"$f":"1+B69","v":32},"BVX 4 LCV   (Terminations)","no.",32,null,0]
[]
[null,{"$f":"1+B70","v":33},"BVX 4 NCV   (Disconnect and remove existing cable) (Provisional).","m",200,null,{"$f":"E72*F72","v":0}]
[null,{"$f":"1+B72","v":34},"BVX 4 NCV   (Supply and deliver).","m",200,null,0]
[null,{"$f":"1+B73","v":35},"BVX 4 NCV   (Installing and testing new cable)","m",200,null,0]
[null,{"$f":"1+B74","v":36},"BVX 4 NCV   (Gland supply)","no.",34,null,0]
[null,{"$f":"1+B75","v":37},"BVX 4 NCV   (Terminations)","no.",34,null,0]
[]
[null,{"$f":"1+B76","v":38},"BVX 4 QCV   (Disconnect and remove existing cable) (Provisional).","m",470,null,0]
[null,{"$f":"1+B78","v":39},"BVX 4 QCV   (Supply and deliver).","m",470,null,{"$f":"E79*F79","v":0}]
[null,{"$f":"1+B79","v":40},"BVX 4 QCV   (Installing and testing new cable)","m",470,null,0]
[null,{"$f":"1+B80","v":41},"BVX 4 QCV   (Gland supply)","no.",38,null,0]
[null,{"$f":"1+B81","v":42},"BVX 4 QCV   (Terminations)","no.",38,null,0]
[]
[null,{"$f":"1+B82","v":43},"BVX 7 DCV   (Disconnect and remove existing cable)","m",{"v":9800,"d":"9,800"},null,{"$f":"E84*F84","v":0}]
[null,{"$f":"1+B84","v":44},"BVX 7 DCV   (Supply and deliver).","m",{"v":24300,"d":"24,300"},null,0]
[null,{"$f":"1+B85","v":45},"BVX 7 DCV   (Installing and testing new cable)","m",{"v":24300,"d":"24,300"},null,0]
[null,{"$f":"1+B86","v":46},"BVX 7 DCV   (Gland supply)","no.",190,null,0]
[null,{"$f":"1+B87","v":47},"BVX 7 DCV   (Terminations)","no.",190,null,0]
[]
[null,{"$f":"1+B88","v":48},"BVX 7 ECV   (Disconnect and remove existing cable)","m",570,null,{"$f":"E90*F90","v":0}]
[null,{"$f":"1+B90","v":49},"BVX 7 ECV  (Supply and deliver).","m",570,null,0]
[null,{"$f":"1+B91","v":50},"BVX 7 ECV   (Installing and testing new cable)","m",570,null,0]
[null,{"$f":"1+B92","v":51},"BVX 7 ECV   (Gland supply)","no.",40,null,0]
[null,{"$f":"1+B93","v":52},"BVX 7 ECV   (Terminations)","no.",40,null,0]
[]
[null,{"$f":"1+B94","v":53},"BVX 12 DCV   (Disconnect and remove existing cable) (Provisional).","m",{"v":4300,"d":"4,300"},null,{"$f":"E96*F96","v":0}]
[null,{"$f":"1+B96","v":54},"BVX 12 DCV   (Supply and deliver).","m",{"v":12700,"d":"12,700"},null,0]
[null,{"$f":"1+B97","v":55},"BVX 12 DCV   (Installing and testing new cable)","m",{"v":12700,"d":"12,700"},null,0]
[null,{"$f":"1+B98","v":56},"BVX 12 DCV   (Gland supply)","no.",92,null,0]
[null,{"$f":"1+B99","v":57},"BVX 12 DCV   (Terminations)","no.",92,null,0]
[]
[null,{"$f":"1+B100","v":58},"BVX 12 ECV   (Disconnect and remove existing cable) (Provisional).","m",600,null,{"$f":"E102*F102","v":0}]
[null,{"$f":"1+B102","v":59},"BVX 12 ECV  (Supply and deliver).","m",920,null,0]
[null,{"$f":"1+B103","v":60},"BVX 12 ECV   (Installing and testing new cable)","m",920,null,0]
[null,{"$f":"1+B104","v":61},"BVX 12 ECV   (Gland supply)","no.",46,null,0]
[null,{"$f":"1+B105","v":62},"BVX 12 ECV   (Terminations)","no.",46,null,0]
[]
[null,{"$f":"1+B106","v":63},"BVX 19 DCV   (Disconnect and remove existing cable) (Provisional).","m",{"v":4300,"d":"4,300"},null,0]
[null,{"$f":"1+B108","v":64},"BVX 19 DCV  (Supply and deliver).","m",{"v":11260,"d":"11,260"},null,{"$f":"E109*F109","v":0}]
[null,{"$f":"1+B109","v":65},"BVX 19 DCV   (Installing and testing new cable)","m",{"v":11260,"d":"11,260"},null,0]
[null,{"$f":"1+B110","v":66},"BVX 19 DCV   (Gland supply)","no.",86,null,0]
[null,{"$f":"1+B111","v":67},"BVX 19 DCV   (Terminations)","no.",86,null,0]
[]
[null,{"$f":"1+B112","v":68},"TPH10AX  (Disconnect and remove existing cable)","m",180,null,0]
[null,{"$f":"1+B114","v":69},"TPH10AX  (Supply and deliver).","m",590,null,{"$f":"E115*F115","v":0}]
[null,{"$f":"1+B115","v":70},"TPH10AX  (Installing and testing new cable)","m",580,null,0]
[null,{"$f":"1+B116","v":71},"TPH10AX (Gland supply)","no.",46,null,0]
[null,{"$f":"1+B117","v":72},"TPH10AX (Terminations)","no.",46,null,0]
[]
[null,{"$f":"1+B118","v":73},"12 CORE MM Duct Fibre (Disconnect and remove existing cable) (Provisional).","m",{"v":16400,"d":"16,400"},null,0]
[null,{"$f":"1+B120","v":74},"12 CORE MM Duct Fibre (Supply and deliver).","m",{"v":16400,"d":"16,400"},null,{"$f":"E121*F121","v":0}]
[null,75,"12 CORE MM Duct Fibre (Installing and testing new cable)","m",{"v":16400,"d":"16,400"},null,0]
[null,76,"12 CORE MM Duct Fibre (Gland supply)","no.",82,null,0]
[null,77,"12 CORE MM Duct Fibre (Terminations)","no.",82,null,0]
[]
[null,{"$f":"1+B124","v":78},"Supply and install T-bar cable support.","no.",750,null,{"$f":"E126*F126","v":0}]
[]
[null,{"$f":"1+B126","v":79},"Supply and install cable sleeves.","no.",{"v":5400,"d":"5,400"},null,{"$f":"E128*F128","v":0}]
[]
[]
[null,null,"Provisional Sums"]
[]
[null,{"$f":"1+B128","v":80},"Provide a Provisional Sum amount of  of R 500 000,00 (Five Hundred Thousand Rand) for the entire works.","sum",1,{"v":500000,"d":"R 500,000.00"},{"$f":"E133*F133","v":{"v":500000,"d":"R 500,000.00"}}]
[]
[]
[null,null,"Total Carried Forward to Main Summary Page",{"$nulls":3},{"$f":"SUM(G17:G135)","v":{"v":500000,"d":"R 500,000.00"}}]

{"sheet":"Bill 6 - Supply & Install Clamp","index":8,"n_rows":144,"n_cols":7,"rows_kept":144,"merged":[[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[143,2,143,5]]}
[]
[null,"NATIONAL TRANSMISSION COMPANY SOUTH AFRICA "]
[null,"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"]
[null,"ELECTRICAL WORKS"]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[]
[]
[null,null,"BILL NO. 6 - SUPPLY AND INSTALLATION OF CLAMPS & SPACERS"]
[]
[null,null,"Note: It is the contractor’s responsibility to verify all quantities from the issued drawings and through physical site measurements prior to placing any material or equipment orders."]
[]
[null,null,"Conventional Clamps"]
[]
[null,null,"Supply and deliver clamps and spacers:"]
[]
[null,{"$f":"1+B15","v":1},"EX-A","no.",3,null,{"$f":"E17*F17","v":0}]
[]
[null,{"$f":"1+B17","v":2},"EX-B","no.",6,null,{"$f":"E19*F19","v":0}]
[]
[null,{"$f":"1+B19","v":3},"EX-D","no.",18,null,{"$f":"E21*F21","v":0}]
[]
[null,{"$f":"1+B21","v":4},"EX-E","no.",12,null,{"$f":"E23*F23","v":0}]
[]
[null,{"$f":"1+B23","v":5},"ETC-J","no.",3,null,{"$f":"E25*F25","v":0}]
[]
[null,{"$f":"1+B25","v":6},"ETC-K","no.",183,null,{"$f":"E27*F27","v":0}]
[]
[null,{"$f":"1+B27","v":7},"EY-D","no.",3,null,{"$f":"E29*F29","v":0}]
[]
[null,{"$f":"1+B29","v":8},"EYC-D","no.",6,null,{"$f":"E31*F31","v":0}]
[]
[null,{"$f":"1+B31","v":9},"EYC-H","no.",18,null,{"$f":"E33*F33","v":0}]
[]
[null,{"$f":"1+B33","v":10},"EYC-R","no.",6,null,{"$f":"E35*F35","v":0}]
[]
[null,{"$f":"1+B35","v":11},"EYC-S","no.",39,null,{"$f":"E37*F37","v":0}]
[]
[null,{"$f":"1+B37","v":12},"EYC-T","no.",21,null,{"$f":"E39*F39","v":0}]
[]
[null,{"$f":"1+B39","v":13},"EYC3-G","no.",18,null,{"$f":"E41*F41","v":0}]
[]
[null,{"$f":"1+B41","v":14},"EYC3-H","no.",36,null,{"$f":"E43*F43","v":0}]
[]
[null,{"$f":"1+B43","v":15},"EYC3-J","no.",18,null,{"$f":"E45*F45","v":0}]
[]
[null,{"$f":"1+B45","v":16},"ES-B","no.",457,null,{"$f":"E47*F47","v":0}]
[]
[null,{"$f":"1+B47","v":17},"ES-E","no.",276,null,{"$f":"E49*F49","v":0}]
[]
[null,{"$f":"1+B49","v":18},"EXCP2-D","no.",26,null,{"$f":"E51*F51","v":0}]
[]
[null,{"$f":"1+B51","v":19},"EXCP3-C","no.",20,null,{"$f":"E53*F53","v":0}]
[]
[null,{"$f":"1+B53","v":20},"EYCDT-B","no.",6,null,{"$f":"E55*F55","v":0}]
[]
[null,{"$f":"1+B55","v":21},"ECJW-A","no.",138,null,{"$f":"E57*F57","v":0}]
[]
[]
[null,null,"Supply and deliver non-standard clamps, clamp covers and universal corona rings:"]
[]
[null,{"$f":"1+B57","v":22},"Lug for 22kV surge arrestor (16.25mm Hornet)","no.",3,null,{"$f":"E62*F62","v":0}]
[]
[null,{"$f":"1+B62","v":23},"26mm Stem (38.3mm Bull)","no.",3,null,{"$f":"E64*F64","v":0}]
[]
[null,{"$f":"1+B64","v":24},"ACC1","no.",6,null,{"$f":"E66*F66","v":0}]
[]
[null,{"$f":"1+B66","v":25},"ACC4","no.",6,null,{"$f":"E68*F68","v":0}]
[]
[null,{"$f":"1+B68","v":26},"ACC6","no.",3,null,{"$f":"E70*F70","v":0}]
[]
[null,{"$f":"1+B70","v":27},"EUC","no.",6,null,{"$f":"E72*F72","v":0}]
[]
[null,{"$f":"1+B72","v":28},"ECRST-LH","no.",30,null,{"$f":"E74*F74","v":0}]
[]
[null,{"$f":"1+B74","v":29},"ECRST-RH","no.",30,null,{"$f":"E76*F76","v":0}]
[]
[]
[]
[null,null,"Install clamps and spacers:"]
[]
[null,{"$f":"1+B76","v":30},"EX-A","no.",3,null,{"$f":"E82*F82","v":0}]
[]
[null,{"$f":"1+B82","v":31},"EX-B","no.",6,null,{"$f":"E84*F84","v":0}]
[]
[null,{"$f":"1+B84","v":32},"EX-D","no.",18,null,{"$f":"E86*F86","v":0}]
[]
[null,{"$f":"1+B86","v":33},"EX-E","no.",12,null,{"$f":"E88*F88","v":0}]
[]
[null,{"$f":"1+B88","v":34},"ETC-J","no.",3,null,{"$f":"E90*F90","v":0}]
[]
[null,{"$f":"1+B90","v":35},"ETC-K","no.",183,null,{"$f":"E92*F92","v":0}]
[]
[null,{"$f":"1+B92","v":36},"EY-D","no.",3,null,{"$f":"E94*F94","v":0}]
[]
[null,{"$f":"1+B94","v":37},"EYC-D","no.",6,null,{"$f":"E96*F96","v":0}]
[]
[null,{"$f":"1+B96","v":38},"EYC-H","no.",18,null,{"$f":"E98*F98","v":0}]
[]
[null,{"$f":"1+B98","v":39},"EYC-R","no.",6,null,{"$f":"E100*F100","v":0}]
[]
[null,{"$f":"1+B100","v":40},"EYC-S","no.",39,null,{"$f":"E102*F102","v":0}]
[]
[null,{"$f":"1+B102","v":41},"EYC-T","no.",21,null,{"$f":"E104*F104","v":0}]
[]
[null,{"$f":"1+B104","v":42},"EYC3-G","no.",18,null,{"$f":"E106*F106","v":0}]
[]
[null,{"$f":"1+B106","v":43},"EYC3-H","no.",36,null,{"$f":"E108*F108","v":0}]
[]
[null,{"$f":"1+B108","v":44},"EYC3-J","no.",18,null,{"$f":"E110*F110","v":0}]
[]
[null,{"$f":"1+B110","v":45},"ES-B","no.",457,null,{"$f":"E112*F112","v":0}]
[]
[null,{"$f":"1+B112","v":46},"ES-E","no.",276,null,{"$f":"E114*F114","v":0}]
[]
[null,{"$f":"1+B114","v":47},"EXCP2-D","no.",26,null,{"$f":"E116*F116","v":0}]
[]
[null,{"$f":"1+B116","v":48},"EXCP3-C","no.",20,null,{"$f":"E118*F118","v":0}]
[]
[null,{"$f":"1+B118","v":49},"EYCDT-B","no.",6,null,{"$f":"E120*F120","v":0}]
[]
[null,{"$f":"1+B120","v":50},"ECJW-A","no.",138,null,{"$f":"E122*F122","v":0}]
[]
[]
[null,null,"Install non-standard clamps, clamp covers and universal corona rings:"]
[]
[null,{"$f":"1+B122","v":51},"Lug for 22kV surge arrestor (16.25mm Hornet)","no.",3,null,{"$f":"E127*F127","v":0}]
[]
[null,{"$f":"1+B127","v":52},"26mm Stem (38.3mm Bull)","no.",3,null,{"$f":"E129*F129","v":0}]
[]
[null,{"$f":"1+B129","v":53},"ACC1","no.",6,null,{"$f":"E131*F131","v":0}]
[]
[null,{"$f":"1+B131","v":54},"ACC4","no.",6,null,{"$f":"E133*F133","v":0}]
[]
[null,{"$f":"1+B133","v":55},"ACC6","no.",3,null,{"$f":"E135*F135","v":0}]
[]
[null,{"$f":"1+B135","v":56},"EUC","no.",6,null,{"$f":"E137*F137","v":0}]
[]
[null,{"$f":"1+B137","v":57},"ECRST-LH","no.",30,null,{"$f":"E139*F139","v":0}]
[]
[null,{"$f":"1+B139","v":58},"ECRST-RH","no.",30,null,{"$f":"E141*F141","v":0}]
[]
[]
[null,null,"Total Carried to Final Summary",{"$nulls":3},{"$f":"SUM(G17:G141)","v":0}]

{"sheet":"Bill 7 - Labels & Miscellaneous","index":9,"n_rows":68,"n_cols":7,"rows_kept":68,"merged":[[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6]]}
[]
[null,{"$f":"'Bill 6 - Supply & Install Clamp'!B2","v":"NATIONAL TRANSMISSION COMPANY SOUTH AFRICA "}]
[null,"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"]
[null,{"$f":"'Bill 1 - P&G'!B5","v":"ELECTRICAL WORKS"}]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[]
[]
[null,null,"BILL NO. 7 - LABELS & MISCELLANEOUS"]
[]
[null,null,"Note: It is the contractor’s responsibility to verify all quantities from the issued drawings and through physical site measurements prior to placing any material or equipment orders."]
[]
[null,null,"LABELS"]
[]
[null,null,"Supply and deliver:"]
[]
[null,"1","Yard labels incl. steelwork, bolts, nuts, washers, all necessary accessories, etc.","no.","220",null,{"$f":"E17*F17","v":0}]
[]
[null,{"$f":"B17+1","v":2},"Phase discs (per set - Red, Blue & White).","no.","200",null,{"$f":"E19*F19","v":0}]
[]
[null,{"$f":"1+B19","v":3},"Panel labels (per set)","no.","200",null,{"$f":"E21*F21","v":0}]
[]
[null,{"$f":"1+B21","v":4},"Busbar labels.","no.","24",null,{"$f":"E23*F23","v":0}]
[]
[null,{"$f":"1+B23","v":5},"Labels for cables (Provisional).","no.","200",null,{"$f":"E25*F25","v":0}]
[]
[null,{"$f":"1+B25","v":6},"JB labels.","no.","12",null,{"$f":"E27*F27","v":0}]
[]
[]
[null,null,"Supply and deliver:"]
[]
[null,{"$f":"B27+1","v":7},"Yard labels incl. steelwork, bolts, nuts, washers, all necessary accessories, etc.","no.","220",null,{"$f":"E32*F32","v":0}]
[]
[null,{"$f":"B32+1","v":8},"Phase discs (per set - Red, Blue & White).","no.","200",null,{"$f":"E34*F34","v":0}]
[]
[null,{"$f":"1+B34","v":9},"Panel labels (per set)","no.","200",null,{"$f":"E36*F36","v":0}]
[]
[null,{"$f":"1+B36","v":10},"Busbar labels.","no.","24",null,{"$f":"E38*F38","v":0}]
[]
[null,{"$f":"1+B38","v":11},"Labels for cables (Provisional).","no.","200",null,{"$f":"E40*F40","v":0}]
[]
[null,{"$f":"1+B40","v":12},"JB labels.","no.","12",null,{"$f":"E42*F42","v":0}]
[]
[]
[null,null,"MISCELLANEOUS"]
[]
[null,{"$f":"1+B42","v":13},"Supply and install 6mm thick checker plate 600mm wide and 1600mm long including cutting to accommodate the panel.","no.",75,null,{"$f":"E47*F47","v":0}]
[]
[null,{"$f":"1+B47","v":14},"Supply and install L-shape brackets - Type A.","no.","70",null,{"$f":"E49*F49","v":0}]
[]
[null,{"$f":"1+B49","v":15},"Supply and install M12 x 70 mm high tensile stainless steel bolts including  nuts, washers, etc.","no.",{"v":4200,"d":"4,200"},null,{"$f":"E51*F51","v":0}]
[]
[null,{"$f":"1+B51","v":16},"M20 Stainless Steel Bolts, Nuts & Washers.","no.",215,null,{"$f":"E53*F53","v":0}]
[]
[null,{"$f":"1+B53","v":17},"M12 Stainless Steel Bolts, Nuts & Washers.","no.",215,null,{"$f":"E55*F55","v":0}]
[]
[null,{"$f":"1+B55","v":18},"M10 Galvanised  Bolts, Nuts & Washers.","no.",215,null,{"$f":"E57*F57","v":0}]
[]
[null,{"$f":"1+B57","v":19},"Cut existing cables on the existing junction box and connect to the new junction box.","item",18,null,{"$f":"E59*F59","v":0}]
[]
[null,{"$f":"1+B59","v":20},"Cut existing earthmat connected to existing junction box 150mm below terrace level.","m",60,null,{"$f":"E61*F61","v":0}]
[]
[null,{"$f":"1+B61","v":21},"Continuity Testing (Provisional).","no.","10",null,{"$f":"E63*F63","v":0}]
[]
[null,{"$f":"1+B63","v":22},"Earthmat testing.","bay","15",null,{"$f":"E65*F65","v":0}]
[]
[]
[null,null,"Total Carried Forward to Main Summary Page",{"$nulls":3},{"$f":"SUM(G53:G67)","v":0}]

{"sheet":"Bill 8 - Dayworks & Prov","index":10,"n_rows":56,"n_cols":7,"rows_kept":56,"merged":[[3,1,3,4]]}
[]
[]
[null,{"$f":"'Bill 7 - Labels & Miscellaneous'!B2","v":"NATIONAL TRANSMISSION COMPANY SOUTH AFRICA "}]
[null,{"$f":"'Bill 7 - Labels & Miscellaneous'!B3","v":"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"}]
[null,"ELECTRICAL WORKS "]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[]
[null,null,"BILL NO. 8 - DAYWORKS & PROVISIONAL SUMS"]
[]
[null,null,"Notes to Tenderers:"]
[]
[null,null,"This is applicable only for works to be carried on Project Manager's instruction."]
[]
[null,null,"DAYWORKS (PROVISIONAL)"]
[]
[null,1,"Saturday overtime: Supervisor.","hr","180",null,{"$f":"E17*F17","v":0}]
[]
[null,{"$f":"B17+1","v":2},"Sunday overtime: Supervisor.","hr","90",null,{"$f":"E19*F19","v":0}]
[]
[null,{"$f":"B19+1","v":3},"Saturday overtime: Authorised Person.","hr","180",null,{"$f":"E21*F21","v":0}]
[]
[null,{"$f":"B21+1","v":4},"Sunday overtime: Authorised Person.","hr","90",null,{"$f":"E23*F23","v":0}]
[]
[null,{"$f":"B23+1","v":5},"Saturday overtime: Safety Officer.","hr","180",null,{"$f":"E25*F25","v":0}]
[]
[null,{"$f":"B25+1","v":6},"Sunday overtime: Safety Officer.","hr","90",null,{"$f":"E27*F27","v":0}]
[]
[null,{"$f":"B27+1","v":7},"Saturday overtime: Quality Officer.","hr","180",null,{"$f":"E29*F29","v":0}]
[]
[null,{"$f":"B29+1","v":8},"Sunday overtime: Quality Officer.","hr","90",null,{"$f":"E31*F31","v":0}]
[]
[null,{"$f":"B31+1","v":9},"Saturday overtime: Environmental Officer.","hr","180",null,{"$f":"E33*F33","v":0}]
[]
[null,{"$f":"B33+1","v":10},"Sunday overtime: Environmental Officer.","hr","90",null,{"$f":"E35*F35","v":0}]
[]
[null,{"$f":"B35+1","v":11},"Saturday overtime: Skilled labourer.","hr","540",null,{"$f":"E37*F37","v":0}]
[]
[null,{"$f":"B37+1","v":12},"Sunday overtime: Skilled labourer.","hr","270",null,{"$f":"E39*F39","v":0}]
[]
[null,{"$f":"B39+1","v":13},"Saturday overtime: Semi-skilled labourer.","hr","1080",null,{"$f":"E41*F41","v":0}]
[]
[null,{"$f":"B41+1","v":14},"Sunday overtime: Semi-skilled labourer.","hr","525",null,{"$f":"E43*F43","v":0}]
[]
[null,{"$f":"B43+1","v":15},"Saturday overtime: Unskilled labourer.","hr",{"v":1080,"d":"1,080"},null,{"$f":"E45*F45","v":0}]
[]
[null,{"$f":"B45+1","v":16},"Sunday overtime: Unskilled labourer.","hr","525",null,{"$f":"E47*F47","v":0}]
[]
[null,{"$f":"B47+1","v":17},"Site return for the entire team including plant and equipment on Project Manager's instruction.","no.","15",null,{"$f":"E49*F49","v":0}]
[]
[null,{"$f":"B49+1","v":18},"Supply or hire and use of specialist equipment for the detection of a particular service (Provisional).","sum","1",null,{"$f":"E51*F51","v":0}]
[]
[null,{"$f":"B51+1","v":19},"Transport of equipment/material from stores to site incl. labour on Project Manager's instruction.","km",{"v":25000,"d":"25,000"},null,{"$f":"E53*F53","v":0}]
[]
[]
[null,null,"Total Carried Forward to Main Summary Page",{"$nulls":3},{"$f":"SUM(G17:G54)","v":0}]

{"sheet":"Bill 9 - Project Stability","index":11,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[4,1,4,4]]}
[]
[]
[null,{"$f":"[1]Preambles!B3","v":"NATIONAL TRANSMISION COMPANY SOUTH AFRICA"}]
[null,"MOOKODI SUBSTATION 500MVA TRANSFORMER: STRINGING & CABLING"]
[null,"ELECTRICAL WORKS "]
[null,"ITEM","DESCRIPTION","UNIT","QTY","RATE","AMOUNT"]
[]
[]
[null,null,"BILL NO. 9 - PROJECT STABILITY"]
[]
[null,null,"Refer to the Preambles for payment of Stakeholder Management Engagements"]
[]
[null,"1","Allow a budgetary allowance of R2 200 000.00 (Two Million and Two Hundred Thousand  Rands) for Project Stability (eg. CLO, HR, PSC venue hire and catering, etc.)","sum","1",{"v":2200000,"d":"R 2,200,000.00"},{"$f":"SUM(E13:F13)","v":{"v":2200000,"d":"R 2,200,000.00"}}]
[]
[null,null,"Total Carried to Final Summary",{"$nulls":3},{"$f":"SUM(G11:G13)","v":{"v":2200000,"d":"R 2,200,000.00"}}]