{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Read Me FIRST","1.1Tender Cover Sheet","1.1.1 Preamble","1.1.2 Summary","1.1.3 BOQ -Price List","1.1.4 CPA Formulae"],"not_rendered":{"images":1,"external_links":4,"defined_names":42},"read":"whole","date_system":"1900"}

{"sheet":"Read Me FIRST","index":0,"n_rows":28,"n_cols":3,"rows_kept":28,"merged":[[8,1,8,2],[10,1,10,2],[12,1,12,2],[25,1,25,2]]}
["Project:",null,"NATIONAL TRANSMISSION COMPANY OF SOUTH AFRICA"]
["Enquiry No.",null,{"$f":"'1.1Tender Cover Sheet'!C19","v":0}]
["Project  Name:",null,"Scope of Work for the Calibration and Repairs (Rate to Include All Spares, Labour,equipment etc)_Contractor/Supplier to provide rate/price breakdown Labour, Equipment and Spares\n"]
["Tenderer's Name:",null,{"$f":"'1.1Tender Cover Sheet'!C23","v":0}]
[]
[]
["READ ME"]
[]
[null,"Read these notes BEFORE you commence input or make any changes to this workbook"]
[]
[null,"The Tenderer must provide a clear indication on the Cover Sheet as to whether the offer is \"main\" or \"alternative\" (and if there are several alternatives, to number them). There must be a separate Excel file for each offer if applicable"]
[]
[null,"NOTE:  ALL CALCULATIONS ARE THE RESPONSIBILITY OF THE TENDERER, AND MUST BE CHECKED THOROUGHLY.  ANY DISCREPANCY FOUND IN THE CALCULATIONS IN THIS WORKBOOK MUST BE BROUGHT TO THE ATTENTION OF ESKOM, THROUGH THE DESIGNATED BUYER!"]
[]
[]
[1,"This workbook contains the following sheets:"]
[null,"Read Me","This sheet provides an overview to the Tenderer of the content and role of the sheets making up the Price Schedules.  It will not form part of the tender or contract."]
[null,"1.1 Tender Cover Sheet","This is the cover sheet for Section 5.1 and provides the total tender price.  It is also the source of the package name, tenderer name etc for the other sheets."]
[null,"1.1.1 Preamble","This sheet provides general guidelines for this section."]
[null,"1.1.2 Summary","This is where the total amounts of all the trades are shown"]
[null,"1.1.3 BOQ","This is the main data entry sheet for the Tenderer to complete. "]
[null,"1.1.4 CPA Formulae","This is where the tenderer selects the CPA Formulae"]
[]
[]
[2,"Conventions used in this workbook"]
[null,"The following conventions have been used in this workbook to facilitate its accurate use:"]
[null,"Red","This GREEN shading is used for cells where DATA ENTRY is required from the Tenderer.  The Tenderer must complete the information in these GREEN shaded cells."]
[null,null,"PLEASE REFRAIN from tampering with ANY other cells contained in this workbook as it may affect Eskom's standard formulae and lead to data integrity issues."]

{"sheet":"1.1Tender Cover Sheet","index":1,"n_rows":48,"n_cols":4,"rows_kept":48,"merged":[[1,1,1,2]]}
[]
[null,"ESKOM TRANSMISION - CENTRAL GRID"]
{"$rows_empty":12}
[null,"PRICING INFORMATION"]
[]
[null,"TENDER INFORMATION"]
[]
[null,"ENQUIRY No."]
[]
[null,"NAME OF PROJECT:",{"$f":"'Read Me FIRST'!C3","v":"Scope of Work for the Calibration and Repairs (Rate to Include All Spares, Labour,equipment etc)_Contractor/Supplier to provide rate/price breakdown Labour, Equipment and Spares\n"}]
[]
[null,"TENDERER’S NAME:  "]
[]
[]
[null,"1.1 Price Schedules "]
[]
[]
[null,"THE PRICE:  IN ZAR",{"$f":"'1.1.2 Summary'!G34","v":{"v":0,"d":"  0  RAND"}}]
[null,"(excluding VAT)"]
[null,"RAND VALUE IN WORDS"]
[]
[]
[]
[]
[null,"DATE :"]
[]
[]
[]
[null,"FULL NAMES OF SIGNATORY:"]
[]
[]
[]
[null,"DESIGNATION OF SIGNATORY:"]
[]
[]
[null,"SIGNATURE :"]
[{"$nulls":3}," "]

{"sheet":"1.1.1 Preamble","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"merged":[[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2]]}
["Project:",null,"ESKOM TRANSMISION - CENTRAL GRID"]
["Enquiry No.",null,{"$f":"'1.1Tender Cover Sheet'!C19","v":0}]
["Project Name:",null,{"$f":"'Read Me FIRST'!C3","v":"Scope of Work for the Calibration and Repairs (Rate to Include All Spares, Labour,equipment etc)_Contractor/Supplier to provide rate/price breakdown Labour, Equipment and Spares\n"}]
["Tenderer's Name:",null,{"$f":"'1.1Tender Cover Sheet'!C23","v":0}]
[]
["1.1.1 PREAMBLE TO PRICE SCHEDULE "]
[]
[1,"The Provisional Price Schedule provides the basis of valuation of all the work activities and inputs and information for general contract progress monitoring. "]
[2,"The amount due at each application for payment date is based on activities and/or milestones completed as indicated on the Price Schedule/Bills of Quantities. The Tenderer must provide all necessary information which is required to determine amounts due in respect of each application for payment relative to the activities."]
[3,"The total of the prices must include for all direct and indirect costs, overheads, profits, on costs, risks, liabilities, obligations, etc. relative to the contract."]

{"sheet":"1.1.2 Summary","index":3,"n_rows":34,"n_cols":7,"rows_kept":34,"merged":[[5,3,5,5],[33,1,33,5]]}
[null,"Project:",null,"National  Transmission Company of South Africa - Central Grid"]
[null,"Enquiry No.",null,{"$f":"'1.1Tender Cover Sheet'!C19","v":0}]
[null,"Project  Name:",null,{"$f":"'Read Me FIRST'!C3","v":"Scope of Work for the Calibration and Repairs (Rate to Include All Spares, Labour,equipment etc)_Contractor/Supplier to provide rate/price breakdown Labour, Equipment and Spares\n"}]
[null,"Tenderer's Name:"]
[]
[{"$nulls":3},"Final Summary Provision of the Repair and Calibiration of Machines"]
[]
[null,"ITEM","STG Numbers","BILL DISCRIPTION",null,"UNIT","AMOUNT"]
[]
[null,"1.1.1",null,{"$f":"D3","v":"Scope of Work for the Calibration and Repairs (Rate to Include All Spares, Labour,equipment etc)_Contractor/Supplier to provide rate/price breakdown Labour, Equipment and Spares\n"}]
[]
[null,"1.1.2",null,"Hydraulic crimping machine","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I24","v":0}]
[null,"1.1.3",null,"Hydraulic crimper hoses","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I34","v":0}]
[null,"1.1.4",null,"Hydraulic conductor cutter","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I47","v":0}]
[null,"1.1.5",null,"Liver hoist 1.5T - 6T","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I61","v":0}]
[null,"1.1.6",null,"Unleaded generators","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I78","v":0}]
[null,"1.1.7",null,"Magnetic drilling machine","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I92","v":0}]
[null,"1.1.8",null,"Hydraulic swage bolt machine","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I117","v":0}]
[null,"1.1.9",null,"Hydraulic swage bolt machine hoses","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I129","v":0}]
[null,"1.1.10",null,"Hydraulic swage bolt punching nose assembly","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I143","v":0}]
[null,"1.1.11",null,"Drill Machine","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I157","v":0}]
[null,"1.1.12",null,"Industrial grinder","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I172","v":0}]
[null,"1.1.13",null,"Brush cutters ","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I186","v":0}]
[null,"1.1.14",null,"Chainsaw","Repair Only","Sum",{"$f":"'1.1.3 BOQ -Price List'!I203","v":0}]
[null,"1.1.15",null,"Earth Resistance Tester","Repair and Calibirations As per Manufacture's specification","Sum",{"$f":"'1.1.3 BOQ -Price List'!I216","v":0}]
[null,"1.1.16",null,"High Voltage Earth Leads Tester","Repair and Calibirations As per Manufacture's specification","Sum",{"$f":"'1.1.3 BOQ -Price List'!I229","v":0}]
[null,"1.1.17",null,"Voltage Detector","Repair and Calibirations As per Manufacture's specification","Sum",{"$f":"'1.1.3 BOQ -Price List'!I235","v":0}]
[null,"1.1.18",null,"Hot Stick Tester","Repair and Calibirations As per Manufacture's specification","Sum",{"$f":"'1.1.3 BOQ -Price List'!I247","v":0}]
[null,"1.1.19",null,"Super Ruler","Repair and Calibirations As per Manufacture's specification","Sum",{"$f":"'1.1.3 BOQ -Price List'!I258","v":0}]
[null,"1.1.20",null,"Dynamometer","Repair and Calibirations As per Manufacture's specification","Sum",{"$f":"'1.1.3 BOQ -Price List'!I273","v":0}]
[null,"1.1.21",null,"Camera","Repair and Calibirations As per Manufacture's specification","Sum",{"$f":"'1.1.3 BOQ -Price List'!I288","v":0}]
[null,"1.1.22",null,"Binoculars","Repair and Calibirations As per Manufacture's specification","Sum",{"$f":"'1.1.3 BOQ -Price List'!I301","v":0}]
[]
[null,"TOTAL AMOUNT",{"$nulls":4},{"$f":"SUM(G10:G33)","v":0}]

{"sheet":"1.1.3 BOQ -Price List","index":4,"n_rows":301,"n_cols":9,"rows_kept":301,"merged":[[1,1,1,8],[5,2,5,3],[7,1,22,1],[7,2,22,2],[11,4,22,4],[24,1,32,1],[24,2,32,2],[28,4,32,4],[34,1,45,1],[34,2,45,2],[38,4,45,4],[47,1,59,1],[47,2,59,2],[51,4,59,4],[61,1,76,1],[61,2,76,2],[65,4,76,4],[78,1,90,1],[78,2,90,2],[82,4,90,4],[92,1,115,1],[92,2,115,2],[96,4,115,4],[117,1,127,1],[117,2,127,2],[121,4,127,4],[129,1,141,1],[129,2,141,2],[133,4,141,4],[143,1,155,1],[143,2,155,2],[147,4,155,4],[157,1,170,1],[157,2,170,2],[161,4,170,4],[172,1,184,1],[172,2,184,2],[176,4,184,4],[186,1,201,1],[186,2,201,2],[190,4,201,4],[203,1,214,1],[203,2,214,2],[207,4,214,4],[216,1,227,1],[216,2,227,2],[220,4,227,4],[229,1,233,1],[229,2,233,2],[235,1,245,1],[235,2,245,2],[239,4,245,4],[247,1,256,1],[247,2,256,2],[251,4,256,4],[258,1,271,1],[258,2,271,2],[262,4,271,4],[273,1,286,1],[273,2,286,2],[277,4,286,4],[288,1,299,1],[288,2,299,2],[292,4,299,4]]}
[]
[null,"Scope of Work for the Repair and Calibration of Various Machine for Lines and Servitudes  as an when required "]
[]
[null,"Item ","Machine or Equipment Name","Bill Discription","Machine Scope","Unit","Quantity ",null,"Rate"]
[]
[null,"1.1.1","Calibration and Repairs (Rate to Include All Spares, Labour,equipment etc)_Contractor/Supplier to provide rate/price breakdown Labour, Equipment and Spares)"]
[]
[null,"1.1.2","Hydraulic crimping machine","Diameter 200, Height 350mm, Ram Stroke – 22mm, Force at die face: 980 kN, Oil Volume required: 314cc "]
[]
[{"$nulls":3},"Items to repares but not limited to the following (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a) Relay Switches","Repair Only","Sum",1,null,{"$f":"H12*G12","v":0}]
[{"$nulls":3},"b) Crimping Dies",null,"Sum",1,null,{"$f":"H13*G13","v":0}]
[{"$nulls":3},"c) Hydraulic Hoses",null,"Sum",1,null,0]
[{"$nulls":3},"d) Pressure Plates",null,"Sum",1,null,0]
[{"$nulls":3},"e) Electric Pumps",null,"Sum",1,null,0]
[{"$nulls":3},"f) Micrometres",null,"Sum",1,null,0]
[{"$nulls":3},"g) Relay Switches",null,"Sum",1,null,0]
[{"$nulls":3},"h) Hydraulic oil",null,"Sum",1,null,0]
[{"$nulls":3},"i) Starter switch",null,"Sum",1,null,0]
[{"$nulls":3},"j) Starter pull cord",null,"Sum",1,null,0]
[{"$nulls":3},"k) Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"l) Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I5:I23)","v":0}]
[null,"1.1.3","Hydraulic crimper hoses"," \n3/8\" X 20 FT 10,000 PSI HYDRAULIC JACK HOSE OTC ENERPAC MALE & FEMALE COUPLER "]
[]
[{"$nulls":3},"Items to repares but not limited to the following (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     O-Rings and Seals.","Repair Only","Sum",1,null,{"$f":"H29*G29","v":0}]
[{"$nulls":3},"b)     Protective Sleeves",null,"Sum",1,null,{"$f":"H30*G30","v":0}]
[{"$nulls":3},"c)      Hydraulic Fluid",null,"Sum",1,null,0]
[{"$nulls":3},"e) Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"f) Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I25:I33)","v":0}]
[null,"1.1.4","Hydraulic conductor cutter","Working pressure of 700 bar max TC series, 50 mm conductor, 331 mm crimping force (kN) 112 mm "]
[]
[{"$nulls":3},"Items to repares but not limited to the following (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a) Cutting Blades","Repair Only","Sum",1,null,{"$f":"H39*G39","v":0}]
[{"$nulls":3},"b) Hydraulic Seals ",null,"Sum",1,null,{"$f":"H40*G40","v":0}]
[{"$nulls":3},"c) Hydraulic Hoses ",null,"Sum",{"$f":"G40","v":1},null,0]
[{"$nulls":3},"d) Pressure Gauges",null,"Sum",{"$f":"G41","v":1},null,0]
[{"$nulls":3},"e) Couplings and Fittings ",null,"Sum",1,null,0]
[{"$nulls":3},"f) O-Rings",null,"Sum",1,null,0]
[{"$nulls":3},"g) Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"h) Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I35:I46)","v":0}]
[null,"1.1.5","Liver hoist 1.5T - 6T","Liver hoist 1.5T - 6T "]
[]
[{"$nulls":3},"Items to repares but not limited to the following (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     Load Chain","Repair Only","Sum",1,null,{"$f":"H52*G52","v":0}]
[{"$nulls":3},"b)     Hooks",null,"Sum",1,null,{"$f":"H53*G53","v":0}]
[{"$nulls":3},"c)      Brake System",null,"Sum",{"$f":"G53","v":1},null,0]
[{"$nulls":3},"d)     Gears and Bearings",null,"Sum",{"$f":"G54","v":1},null,0]
[{"$nulls":3},"e)     Lever Handle",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Safety Latches",null,"Sum",1,null,0]
[{"$nulls":3},"g)     Chain Guide and Sprockets",null,"Sum",1,null,0]
[{"$nulls":3},"h) Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"i) Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I48:I60)","v":0}]
[null,"1.1.6","Unleaded generators","16kVA, noise Level (7), no-load 72dB, rated power factor 0.8, Engine Type=twin cylinder air cooled petrol "]
[]
[{"$nulls":3},"Items to repares but not limited to the following (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     Air Filter","Repair Only","Sum",1,null,{"$f":"H66*G66","v":0}]
[{"$nulls":3},"b)     Spark Plug",null,"Sum",1,null,{"$f":"H67*G67","v":0}]
[{"$nulls":3},"c)      Fuel Filter",null,"Sum",{"$f":"G67","v":1},null,0]
[{"$nulls":3},"d)     Oil Filter",null,"Sum",{"$f":"G68","v":1},null,0]
[{"$nulls":3},"e)     Battery",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Carburettor",null,"Sum",1,null,0]
[{"$nulls":3},"g)     Exhaust System ",null,"Sum",1,null,0]
[{"$nulls":3},"h)     Control Panel ",null,"Sum",1,null,0]
[{"$nulls":3},"i)       Recoil pull starter",null,"Sum",1,null,0]
[{"$nulls":3},"j) On/off selector switch",null,"Sum",1,null,0]
[{"$nulls":3},"k) Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"l) Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I62:I77)","v":0}]
[null,"1.1.7","Magnetic drilling machine","230v/50Hz, 1.8 KW (2.4 HP) power output, 75mm max cutting diameter, 260-460 RPM no-load speed, MT3 \nchuck "]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a) Cutting Tools (Annular Cutters)","Repair Only","Sum",1,null,{"$f":"H83*G83","v":0}]
[{"$nulls":3},"b) Magnetic Base",null,"Sum",1,null,{"$f":"H84*G84","v":0}]
[{"$nulls":3},"c) Motor Brushes",null,"Sum",{"$f":"G84","v":1},null,0]
[{"$nulls":3},"d) Gearbox",null,"Sum",{"$f":"G85","v":1},null,0]
[{"$nulls":3},"e) Coolant System",null,"Sum",1,null,0]
[{"$nulls":3},"f) Control Switches",null,"Sum",1,null,0]
[{"$nulls":3},"g) Feed Handles and Knobs",null,"Sum",1,null,0]
[{"$nulls":3},"h) Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"i) Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I79:I91)","v":0}]
[null,"1.1.8","Hydraulic swage bolt machine","Hoffman HP78 Diesel Engen, 12 volts DC Trigger Operated pump capacity 5.4min at 3000rpm"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)      Swaging Dies","Repair Only","Sum",1,null,{"$f":"H97*G97","v":0}]
[{"$nulls":3},"b)     Hydraulic Seals",null,"Sum",1,null,{"$f":"H98*G98","v":0}]
[{"$nulls":3},"c)      Hydraulic Hoses",null,"Sum",{"$f":"G98","v":1},null,0]
[{"$nulls":3},"d)     Pressure Gauges",null,"Sum",{"$f":"G99","v":1},null,0]
[{"$nulls":3},"e)     Couplings and Fittings",null,"Sum",1,null,0]
[{"$nulls":3},"f)       O-Rings",null,"Sum",1,null,0]
[{"$nulls":3},"g)     Gun nipples",null,"Sum",1,null,0]
[{"$nulls":3},"h)     Battery",null,"Sum",1,null,0]
[{"$nulls":3},"i)       Fuse",null,"Sum",1,null,0]
[{"$nulls":3},"j)       Hydraulic oil",null,"Sum",1,null,0]
[{"$nulls":3},"k)      Axel",null,"Sum",1,null,0]
[{"$nulls":3},"l)       Solid wheels",null,"Sum",1,null,0]
[{"$nulls":3},"m)    Collect lock",null,"Sum",1,null,0]
[{"$nulls":3},"n)     Jaws",null,"Sum",1,null,0]
[{"$nulls":3},"o)     Flexinol",null,"Sum",1,null,0]
[{"$nulls":3},"p)     Electrical wiring",null,"Sum",1,null,0]
[{"$nulls":3},"q)     Spider",null,"Sum",1,null,0]
[{"$nulls":3},"r)      Release/ejector ",null,"Sum",1,null,0]
[{"$nulls":3},"s)    Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"u)   Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I93:I116)","v":0}]
[null,"1.1.9","Hydraulic swage bolt machine hoses","12.5kg hose and cord kit Hs14 15m length "]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     Wear and tear on the outer cover","Repair Only","Sum",1,null,{"$f":"H122*G122","v":0}]
[{"$nulls":3},"b)     Fluid Incompatibility",null,"Sum",1,null,{"$f":"H123*G123","v":0}]
[{"$nulls":3},"c)      Tube Erosion",null,"Sum",{"$f":"G123","v":1},null,0]
[{"$nulls":3},"d)     Faulty hose couplings",null,"Sum",{"$f":"G124","v":1},null,0]
[{"$nulls":3},"e)     Protective Sleeves",null,"Sum",1,null,0]
[{"$nulls":3},"f) Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"g) Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I118:I128)","v":0}]
[null,"1.1.10","Hydraulic swage bolt punching nose assembly","T104 hydraulic installation tool for pins & collars (pistol & cylinder) "]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)      Punching Dies","Repair Only","Sum",1,null,{"$f":"H134*G134","v":0}]
[{"$nulls":3},"b)     Hydraulic Seals",null,"Sum",1,null,{"$f":"H135*G135","v":0}]
[{"$nulls":3},"c)      Hydraulic Hoses",null,"Sum",{"$f":"G135","v":1},null,0]
[{"$nulls":3},"d)     Pressure Gauges",null,"Sum",{"$f":"G136","v":1},null,0]
[{"$nulls":3},"f)      Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"g)     Couplings and Fittings",null,"Sum",{"$f":"G138","v":1},null,0]
[{"$nulls":3},"h)     O-Rings",null,"Sum",{"$f":"G139","v":1},null,0]
[{"$nulls":3},"i)       Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"j)      Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I130:I142)","v":0}]
[null,"1.1.11","Drill Machine","800w Impact Drill (POWP2030)  "]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)      Chuck/Arbor and Chuck key","Repair Only","Sum",1,null,{"$f":"H148*G148","v":0}]
[{"$nulls":3},"b)     Motor Brushes",null,"Sum",1,null,{"$f":"H149*G149","v":0}]
[{"$nulls":3},"c)      Power Cord",null,"Sum",{"$f":"G149","v":1},null,0]
[{"$nulls":3},"d)     Bearings",null,"Sum",{"$f":"G150","v":1},null,0]
[{"$nulls":3},"e)     Switches",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Gearbox",null,"Sum",{"$f":"G152","v":1},null,0]
[{"$nulls":3},"g)      Drill Bit",null,"Sum",{"$f":"G153","v":1},null,0]
[{"$nulls":3},"h)       Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"i)      Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I144:I156)","v":0}]
[null,"1.1.12","Industrial grinder","2200W,230mm (SGRIND-230) "]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     Grinding Wheels","Repair Only","Sum",1,null,{"$f":"H162*G162","v":0}]
[{"$nulls":3},"b)     Spindles",null,"Sum",1,null,{"$f":"H163*G163","v":0}]
[{"$nulls":3},"c)      Bearings",null,"Sum",{"$f":"G163","v":1},null,0]
[{"$nulls":3},"d)     Belts and Pulleys",null,"Sum",{"$f":"G164","v":1},null,0]
[{"$nulls":3},"e)     Coolant System",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Control Switches",null,"Sum",{"$f":"G166","v":1},null,0]
[{"$nulls":3},"g)     Dust Collection System",null,"Sum",{"$f":"G167","v":1},null,0]
[{"$nulls":3},"h)     Carbon Brushes",null,"Sum",1,null,0]
[{"$nulls":3},"i)       Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"j)      Inspection of the machine before repairs",null,"Sum",{"$f":"G169","v":1},null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I158:I171)","v":0}]
[null,"1.1.13","Brush cutters ","Petrold7:d22w/2.2hp7.7kg"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     Air Filter","Repair Only","Sum",1,null,{"$f":"H177*G177","v":0}]
[{"$nulls":3},"b)     Spark Plug",null,"Sum",1,null,{"$f":"H178*G178","v":0}]
[{"$nulls":3},"c)      Trimmer Head and Line",null,"Sum",{"$f":"G178","v":1},null,0]
[{"$nulls":3},"d)     Fuel Filter ",null,"Sum",{"$f":"G179","v":1},null,0]
[{"$nulls":3},"e)     Blades ",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Primer Bulb",null,"Sum",{"$f":"G181","v":1},null,0]
[{"$nulls":3},"g)     Throttle and Control Cables",null,"Sum",{"$f":"G182","v":1},null,0]
[{"$nulls":3},"h)       Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"i)      Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I173:I185)","v":0}]
[null,"1.1.14","Chainsaw","Cylinder displacement=27 -40.9cm³ weight (excl. Cutting equipment)=2.7- 4.4 kg \npower output= 1.1 - 1.8 kw\nrecommended bar length, max=12-18inch"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)      Chain","Repair Only","Sum",1,null,{"$f":"H191*G191","v":0}]
[{"$nulls":3},"b)     Guide Bar",null,"Sum",1,null,{"$f":"H192*G192","v":0}]
[{"$nulls":3},"c)      Air Filter",null,"Sum",{"$f":"G192","v":1},null,0]
[{"$nulls":3},"d)     Spark Plug",null,"Sum",{"$f":"G193","v":1},null,0]
[{"$nulls":3},"e)     Fuel Filter",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Oil Filter",null,"Sum",{"$f":"G195","v":1},null,0]
[{"$nulls":3},"g)     Carburettor",null,"Sum",{"$f":"G196","v":1},null,0]
[{"$nulls":3},"h)     Recoil Starter",null,"Sum",1,null,0]
[{"$nulls":3},"i)      Chain Tensioner",null,"Sum",1,null,0]
[{"$nulls":3},"j)     Anti-Vibration Mounts",null,"Sum",1,null,0]
[{"$nulls":3},"k)       Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"l)      Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I187:I202)","v":0}]
[null,"1.1.15","Earth Resistance Tester","  Low frequency tower footing impedance meters with flexible current sensors"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     Test Leads","Repair and Calibirations As per Manufacture's specification","Sum",1,null,{"$f":"H208*G208","v":0}]
[{"$nulls":3},"b)     Auxiliary Earth Bars",null,"Sum",1,null,{"$f":"H209*G209","v":0}]
[{"$nulls":3},"c)      Batteries",null,"Sum",{"$f":"G209","v":1},null,0]
[{"$nulls":3},"d)     Display Screen",null,"Sum",{"$f":"G210","v":1},null,0]
[{"$nulls":3},"e)     Control Buttons",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Protective Holster",null,"Sum",{"$f":"G212","v":1},null,0]
[{"$nulls":3},"g)       Other (Contractor to specify)",null,"Sum",{"$f":"G213","v":1},null,0]
[{"$nulls":3},"h)      Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I204:I215)","v":0}]
[null,"1.1.16","High Voltage Earth Leads Tester","Tester:microhmmeter;100-265 v;50/60 hz"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)      Test Leads","Repair and Calibirations As per Manufacture's specification","Sum",1,null,{"$f":"H221*G221","v":0}]
[{"$nulls":3},"b)     Kelvin Probes",null,"Sum",1,null,{"$f":"H222*G222","v":0}]
[{"$nulls":3},"c)      Power Adapters",null,"Sum",{"$f":"G222","v":1},null,0]
[{"$nulls":3},"d)     Display Screen",null,"Sum",{"$f":"G223","v":1},null,0]
[{"$nulls":3},"e)     Control Buttons",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Internal Batteries",null,"Sum",{"$f":"G225","v":1},null,0]
[{"$nulls":3},"g)       Other (Contractor to specify)",null,"Sum",{"$f":"G226","v":1},null,0]
[{"$nulls":3},"h)      Inspection of the machine before repairs",null,"Sum",1,null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I217:I228)","v":0}]
[null,"1.1.17","Voltage Detector"," Multirange Voltage detector"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a) All defective components ","Repair and Calibirations As per Manufacture's specification","Sum",1,null,{"$f":"H234*G234","v":0}]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I230:I234)","v":0}]
[null,"1.1.18","Hot Stick Tester","Wet/Dry hot stick tester 230Volts"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)      Test Leads","Repair and Calibirations As per Manufacture's specification","Sum",1,null,{"$f":"H240*G240","v":0}]
[{"$nulls":3},"b)     Batteries",null,"Sum",1,null,{"$f":"H241*G241","v":0}]
[{"$nulls":3},"c)      Display Screen",null,"Sum",{"$f":"G241","v":1},null,0]
[{"$nulls":3},"d)     Control Buttons",null,"Sum",{"$f":"G242","v":1},null,0]
[{"$nulls":3},"e)     Protective Holster",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Other (Contractor to specify)",null,"Sum",{"$f":"G244","v":1},null,0]
[{"$nulls":3},"g)      Inspection of the machine before repairs",null,"Sum",{"$f":"G245","v":1},null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I236:I246)","v":0}]
[null,"1.1.19","Super Ruler","Height meter"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     Measurement Markings","Repair and Calibirations As per Manufacture's specification","Sum",1,null,{"$f":"H252*G252","v":0}]
[{"$nulls":3},"b)     Protective Coating",null,"Sum",1,null,{"$f":"H253*G253","v":0}]
[{"$nulls":3},"c)     Edges",null,"Sum",1,null,0]
[{"$nulls":3},"d)     Non-Slip Pads ",null,"Sum",1,null,0]
[{"$nulls":3},"e)     Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"f)     Inspection of the machine before repairs",null,"Sum",{"$f":"G256","v":1},null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I248:I257)","v":0}]
[null,"1.1.20","Dynamometer","Dynamometer:electronic;0-6.5 t; battery"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     Load Cells","Repair and Calibirations As per Manufacture's specification","Sum",1,null,{"$f":"H263*G263","v":0}]
[{"$nulls":3},"b)     Sensors",null,"Sum",1,null,{"$f":"H264*G264","v":0}]
[{"$nulls":3},"c)      Bearings",null,"Sum",1,null,0]
[{"$nulls":3},"d)     Cooling System",null,"Sum",1,null,0]
[{"$nulls":3},"e)     Control Electronics",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Drive Belts and Pulleys",null,"Sum",1,null,0]
[{"$nulls":3},"g)     Data Acquisition System",null,"Sum",1,null,0]
[{"$nulls":3},"h)     Non-Slip Pads ",null,"Sum",1,null,0]
[{"$nulls":3},"i)     Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"j)     Inspection of the machine before repairs",null,"Sum",{"$f":"G271","v":1},null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I259:I272)","v":0}]
[null,"1.1.21","Camera","Camera dgtl:8 gb;2x/4x zoom capability"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     Lens and Lens Mount","Repair and Calibirations As per Manufacture's specification","Sum",1,null,{"$f":"H278*G278","v":0}]
[{"$nulls":3},"b)     Sensor",null,"Sum",1,null,{"$f":"H279*G279","v":0}]
[{"$nulls":3},"c)      Shutter Mechanism",null,"Sum",1,null,0]
[{"$nulls":3},"d)     Viewfinder",null,"Sum",1,null,0]
[{"$nulls":3},"e)     Buttons and Dials",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Battery Compartment",null,"Sum",1,null,0]
[{"$nulls":3},"g)     Ports and Connectors",null,"Sum",1,null,0]
[{"$nulls":3},"h)     Firmware Updates",null,"Sum",1,null,0]
[{"$nulls":3},"i)     Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"j)     Inspection of the machine before repairs",null,"Sum",{"$f":"G286","v":1},null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I274:I287)","v":0}]
[null,"1.1.22","Binoculars","Stabilizer: type: image; size: wd 152 x lg 193 x ht 81 mm"]
[]
[{"$nulls":3},"Items to repares but not limited to the following Rates to included all required such as spare etc. (Contractor or supplier to add any items that may have been ommited"]
[]
[{"$nulls":3},"a)     Stabilization System","Repair and Calibirations As per Manufacture's specification","Sum",1,null,{"$f":"H293*G293","v":0}]
[{"$nulls":3},"b)     Optics",null,"Sum",1,null,{"$f":"H294*G294","v":0}]
[{"$nulls":3},"c)      Focusing Mechanism",null,"Sum",1,null,0]
[{"$nulls":3},"d)     Battery and Power System",null,"Sum",1,null,0]
[{"$nulls":3},"e)     Housing and Seals",null,"Sum",1,null,0]
[{"$nulls":3},"f)       Buttons and Controls",null,"Sum",1,null,0]
[{"$nulls":3},"g)     Other (Contractor to specify)",null,"Sum",1,null,0]
[{"$nulls":3},"h)     Inspection of the machine before repairs",null,"Sum",{"$f":"G299","v":1},null,0]
[{"$nulls":7},"Sub-total ",{"$f":"SUM(I289:I300)","v":0}]

{"sheet":"1.1.4 CPA Formulae","index":5,"n_rows":69,"n_cols":11,"rows_kept":69,"merged":[[12,2,12,11],[60,2,60,7],[60,8,60,9]]}
[null,"ESKOM TRANSMISSION - CENTRAL GRID"]
[null,"ENQUIRY No.",null,null,{"$f":"'1.1Tender Cover Sheet'!C19","v":0}]
[null,"TENDERER NAME:",null,null,{"$f":"'1.1Tender Cover Sheet'!C23","v":0}]
[null,"NAME OF PROJECT:",null,null,{"$f":"'1.1Tender Cover Sheet'!C21","v":"Scope of Work for the Calibration and Repairs (Rate to Include All Spares, Labour,equipment etc)_Contractor/Supplier to provide rate/price breakdown Labour, Equipment and Spares\n"}]
[null,"PRICE ADJUSTMENT FOR INFLATION"]
[null,"Summary"]
[null,"No","Description"]
[null,"A",0,null,null,"Type in description of formula which is carried through below"]
[]
[]
[]
[null,"GENERAL NOTES :"]
[null,"a.","CPA conditions may apply if the contractual duration is to be longer than 12 months. Eskom's default position is for Prices to be Fixed for the first 12 months, then CP be applicable thereafter."]
[null,"b.","References to \"indices\" below have the meaning of \"cost indices or reference prices\",  unless otherwise stated."]
[null,null,"Where historical information is applicable as requested below, internet address references which are accessible to the"]
[null,"c.","general public may be submitted instead, with the specific electronic route and web page reflecting the applicable data."]
[null,"d.","Each formula is related to one unique currency. Mixing of currencies in a specific formula is not acceptable."]
[null,"CPA FORMULA REQUIREMENTS :"]
[null,"i.","Formulae must be linked to independent cost indices or other benchmarks (\"reference prices\") and must be clearly and"]
[null,null,"completely defined. The source must be a recognised statistical publishing source and must not be in-house indices."]
[null,"ii.","Local Indices: Where local indices other than SEIFSA or StatsSA are specified, the tenderer is to submit 5 years' historical data"]
[null,null,"for such indices.  Note that the Contractor must ensure that indices are published and recommended by the \"Source\" as"]
[null,null,"applicable to the work involved. For example SEIFSA has terminated the publication of Table E and is replaced by Table E-A and"]
[null,null,"or E-EX and the specific sub breakdown of such must be identified. Also SEIFSA recommends utilisation of Table L-2 for road"]
[null,null,"transport rather than Table L-1.  "]
[null,"iii.","Foreign Price Adjustments: In the case of foreign price adjustments, the Contractor is to submit 5 years' historical data for the"]
[null,null,"tendered indices.  Where a formula is linked to indices in a country, payment of the amounts for that formula must be in the "]
[null,null,"currency of the same country.  A formula may not be linked to indices of more than one country."]
[null,"iv.","Commodity Price Linked Payments: The reference price is considered as the base price (index) for purpose of the CPA formula"]
[null,null,"and is incuded in the applicable tables below and must be in the currency in which the CPA will be payable.  The exchange"]
[null,null,"rate applied to convert the base price in a foreign currency into that of the currency of the formula must also be indicated in"]
[null,null,"the tables below if the price is not in the same currency as the applicable formula.. ie exposure to the movement in a"]
[null,null,"reference price is in the same currency as that of the CPA formula.  The Contractor is to submit 5 years' historical price data"]
[null,null,"for such commodity, "]
[null,"v.","London Metal Exchange (LME) Prices: For metals traded on the LME, the tonnage will be required before contract award in"]
[null,null,"order for Eskom to hedge the metal price fluctuations.  This applies also for prices linked to local indices or reference prices. "]
[null,null,"Though these metals are traded in US$, prices are daily quoted in various other currencies. "]
[null,null,"The LME price in the currency of the formula must apply and thus not the US$ unless the amount payable in terms of the"]
[null,null,"formula is US$.  Refer to the \"LME\" Sheet in this file for more detail regarding this aspect.  By indicating any of these metals in"]
[null,null,"the formulae below, the contractor declares that neither he nor any other body avails or will avail of forward price and/or"]
[null,null,"currency cover for the metal(s).  "]
[null,"vi.","CPA Base Date: The CPA base date for calculating price movements is the Base Date as defined in the Particular Conditions,"]
[null,null,"Clause 1.1.3.1. For indices or reference prices published as at certain dates, and where such a date is not the Base Date, the"]
[null,null,"latest date for which it is published before the Base Date will be considered as the Base Date index or reference price.  In"]
[null,null,"instances where the figure or value is not as at the Base Date or considered as the Base Date index or reference price as"]
[null,null,"explained herein, the date, figure or value as well as the reason for the deviation must be clearly separately stated and must"]
[null,null,"be realistic for purposes of the price adjustment. "]
[null,"vii.","Period for Movement in Indices: The period for which the movement in indices or reference prices is considered, is the period"]
[null,null,"until the last day of the month prior to the  month in which the work in question was executed or completed (or in which an"]
[null,null,"event or activity for which the adjustment applies, took place).  For indices or reference prices published as at certain dates,"]
[null,null,"and where such a date is not the last day of the month prior to the month in which the work was executed or completed (or an"]
[null,null,"event or activity took place),  then latest date for which the indices or price references are published before the last day of the"]
[null,null,"month prior to the execution or completion of work (or an event or activity took place) is considered as the last day index"]
[null,null,"or reference price of the month prior to execution or completion of work (or event or activity). "]
[null,"viii.","Proportions/weighting/coefficients/base reference in CPA Formulae: The fixed portion of each formula, not subject to inflation,"]
[null,null,"is at least 15% and contractors may submit higher fixed portion percentages.  The indices or other benchmarks and their"]
[null,null,"proportions in the formula must be realistic and relative to the applicable work. The fixed portion and other proportions must add"]
[null,null,"up to 100%."]
[null,"ix.","Base Index or Reference Price :   The base index or reference price must be inserted in the appropriate column"]
[null,"FORMULA No:"]
[null," A ",{"$nulls":6},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula"]
[null,"Index","Proportion / Coefficient / Weight / Base reference price","Description / Scope of Index (eg Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source of Index ((indices prepared by (e.g. SEIFSA, StatsSA, LME)","Base month for CPA if not Base Date as defined (See Note vi above)","Formula Currency Code","Currency Code","Exchange Rate Currency 1,00 =","Historical Data provided (Yes/No/Internet address)"]
[null,"A1"]
[null,"A2"]
[null,"A3"]
[null,"A4"]
[null,"A5"]
[null,"A6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,null,{"$f":"SUM(C63:C68)","v":{"v":0.15,"d":"0.150"}},"Total"]