{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["COVER  ","PREAMBLE","Typical Activity Schedule","Exchange rates","CPA Formula"],"not_rendered":{"images":1,"external_links":16,"defined_names":3829},"read":"whole","date_system":"1900"}

{"sheet":"COVER  ","index":0,"n_rows":37,"n_cols":3,"rows_kept":37,"merged":[[1,1,1,2],[11,1,11,2],[13,1,13,2],[26,8,26,9],[28,8,28,9]]}
{"$rows_empty":11}
[null,"PRICING INFORMATION"]
[]
[null,"REQUEST FOR BIDS"]
[]
[null,"RFB NO."]
[]
[null,"SITENAME","Tutuka Power Plant - Solar Photovoltaic  (Output:28.93MW)"]
[]
[null,"Design, Engineering, Supply, Construction, Installation, Testing, Commissioning, Operation and Maintenance (O&M) 28.93 MW Solar PV Facility at Tutuka Power Station, Mpumalanga"]
[]
[null,"BIDDER’S NAME:  "]
[]
[]
[null,"Design, Engineering,  Supply, Construction, Installation, Testing, Commissioning Cost (excluding VAT)",{"$f":"'Typical Activity Schedule'!M240","v":{"v":0,"d":"R 0.00"}}]
[null,"Operating and Maintenance Cost (O&M) (excluding VAT)",{"v":0,"d":"R 0.00"}]
[null,"THE PRICE:  IN RAND (excluding VAT)\n Grand  TOTALS"]
[null,"Value Added Tax  (VAT) Currently 15%",{"$f":"C25+C27","v":{"v":0,"d":"R 0.00"}}]
[null,"TOTAL RAND VALUE:  IN RAND (Including VAT)"]
[null,"TOTAL RAND VALUE IN WORDS (Including VAT)"]
[]
[]
[null,"DATE :"]
[]
[null,"SIGNATURE :"]
[]
[null,"DESIGNATION :"]

{"sheet":"PREAMBLE","index":1,"n_rows":43,"n_cols":5,"rows_kept":43,"merged":[[0,1,0,2],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[37,2,37,3],[38,2,38,3],[39,2,39,3],[40,2,40,3],[41,2,41,3],[42,2,42,3]]}
[null,{"$f":"'COVER  '!C18","v":"Tutuka Power Plant - Solar Photovoltaic  (Output:28.93MW)"}]
[null,"RFB No.",null,{"$f":"IF('COVER  '!C16=\"\",\"\",'COVER  '!C16)","v":""},{"$f":"IF('COVER  '!B17=\"\",\"\",'COVER  '!B17)","v":""}]
[null,"BIDDER'S NAME:",null,{"$f":"IF('COVER  '!C22=\"\",\"\",'COVER  '!C22)","v":""}]
[]
[null,"PREAMBLE TO PRICE SCHEDULE "]
[null,1,"SCOPE GENERALLY"]
[null,1.1,"The price activity schedule is for the Engineering, Procurement and Construction (EPC) , on a lump-sum basis under an EPC, It should include all studies, permitting, design, engineering, procurement, manufacturing, deliveries to Site, execution, erection, commissioning, testing, completion, operation and maintenance (O&M) until the end of the Defects Liability Period, making good defects and warranty cover during the Defects Liability Period, and other works necessary to construct a solar photovoltaic (PV) power Plant , the access road, the Site facilities and any additional infrastructure as per EMPLOYER’S REQUIREMENTS "]
[null,1.2,"The contract price shall be based upon the Bid that offers required capacity .\nThe provided activity schedule shall be deemed as a general guide only/ typical example. The Bidder's may  provide their own preferred breakdown as per Employer's requirements.  The Contractor shall use other documents provided as reference.  The prices provided shall include the cost of all required equipment, tools, material, labour, and supervision for the EPC of a complete commissioned component or system.  Any expected wastage of materials and components shall be included in the pricing provided."]
[null,2,"UNIT OF MEASUREMENT"]
[null,2.1,"Units of measurement  or quantity i.e., Number (no),  Lump Sum (Sum) or Item, are associated as applicable with the items as listed in the Activity Schedules."]
[null,3,"DOCUMENTS SHALL BE MUTUALLY SELF EXPLANATORY"]
[null,3.1,"The Conditions of Contract, together with the Employer's Requirements, etc. shall be read in conjunction with the Bidder's  Activity  Schedules and in so far as they are relevant."]
[null,4,"ACTIVITY SCHEDULES AND BID PRICES"]
[null,4.2,"The Bidder's Activity Schedules shall contains, as far as can be determined, full details of the work that is to be executed by the Contractor and the materials that are to be supplied.  It should, however, not be presumed that the Schedule includes and describes every detail of the Contract Works.  Where any work or activities to be executed are described or implied without corresponding items appearing in the Price Schedules, the Contractor shall add such items in the price activity schedule. "]
[null,4.3,"No claims arising from errors, omissions or misunderstandings, shall be accepted after the closing date of the BID."]
[null,5,"PRICES SHALL BE COMPREHENSIVE"]
[null,5.1,"The rates and prices inserted in the Activity Schedules shall be fully inclusive of the works as per Employer's requirements. Such prices shall cover all costs and expenses that may be required in and for the completion of the work described and shall cover the cost of all general risks, liabilities and obligations set forth or implied in the Contract Documents."]
[null,5.2," The Bidder can cost for supply , design etc. in local currency or combination of foreign and local currency."]
[null,5.3," Operation  & Maintenance (O&M)  shall be priced for Years 1 - 2 to determine the O&M Contract value.\n"]
[null,5.4,"A price or rate is to be entered against each item in the Activity Schedules.  Items against which no price or rate is entered by the Contractor will not be paid for when executed but will be considered as covered by prices and rates elsewhere in the Activity Schedules."]
[null,5.5,"The Activity Schedules shall be divided into various sections for the convenience of pricing and measurement of the work. "]
[null,5.6,"The Activity Schedule shall include but not limited to Description, Unit, Currency, RoE, Unit of measurements, Quantities,  Rates and Total  Amounts. As shown on typical Activity Schedule herein. "]
[null,6,"ALTERATIONS TO THE ACTIVITY SCHEDULES"]
[null,6.1,"Bidders may alter the Typical Activity schedule provided herein, and or the Bidder's may  provide their own preferred breakdown as per Employer's requirements."]
[null,7,"ERRORS"]
[null,7.1,"In the event of any arithmetical errors occurring in the totals from Submitted Activity Schedules such totals will be corrected on the assumption that the rates quoted are correct."]
[null,8,"VALUE ADDED TAX"]
[null,8.1,"The work under this Contract is classified as a taxable service under VAT and therefore the Contractor will collect VAT from the Employer and will pay the VAT over to the Receiver of Revenue for the work executed under this Contract. "]
[null,9,"ACTIVITY SCHEDULES "]
[null,9.1," The Bids shall be quoted in the currencies of the bidder's choice (limited to a total of 3 different currencies of which one shall be ZAR) and these currencies and quoted price have to be included in the Letter of Bid accordingly.  The different currencies will be stated in the \"Exchange Rates\" worksheets and indicated in the Price Schedules where applicable."]
[null,9.2,"The total of the prices shall include for all direct and indirect costs, overheads, profits, on costs, risks, liabilities, obligations, etc. relative to the contract and all taxes including customs duties on imported Plant to authorities and Excluding VAT on all items. \n \n"]
[null,9.3,"The Contractor shall allow for all necessary costs to complete the Works as required in terms of the Employer's requirements whether expressly stated or not in the Bidder's Activity schedule. "]
[null,9.4,"Contractor to check and take responsibility for all descriptions, formulae, and structure of their Activity Schedule."]
[null,9.5,"Where reference is made to the \"Contractor\" in these documents it will mean \"Bidder\" or \"Vice versa\" during the bidding process."]
[null,9.6,"The Bidder's Activity Schedule provides the basis of all valuations of the work, payments in multiple currencies, price adjustment (CPA) and general progress monitoring."]
[null,10,"INSURANCE"]
[null,10.1,"Insurances shall be as per NEC ECC contract"]
[null,11,"CONTRACT PRICE ADJUSTMENTS"]
[null,11.1,"For detailed instructions - refer to NEC ECC Contract  (X1) Clause"]
[null,11.2,"The Contractor shall propose CPA formula on the attached CPA template provided. "]
[null,13,"CURRENCY RATE OF EXCHANGE"]
[null,13.1,"For detailed instructions - refer to \"Currency ROE Rate of Exchange.- This sheet is provided herein as  Exchange Rates "]
[null,13.2,"This sheet is required to be completed by the BIDDER with the \"Exchange Rates\" in terms of Eskom's BID requirements"]

{"sheet":"Typical Activity Schedule","index":2,"n_rows":252,"n_cols":21,"rows_kept":252,"merged":[[0,1,0,14],[1,1,1,14],[2,1,2,14],[3,1,3,14],[4,1,4,14],[5,1,5,14],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,6],[6,7,6,12],[6,13,7,13],[6,14,7,14],[8,1,8,14],[22,1,22,4],[28,1,28,4],[35,1,35,14],[36,1,36,4],[36,8,36,11],[40,1,40,4],[40,8,40,11],[45,1,45,4],[45,8,45,11],[50,1,50,4],[50,8,50,11],[57,1,57,14],[58,1,58,4],[58,8,58,11],[65,1,65,4],[65,8,65,11],[72,1,72,4],[72,8,72,11],[79,1,79,4],[79,8,79,11],[86,1,86,14],[87,1,87,4],[87,8,87,11],[95,1,95,4],[95,8,95,11],[102,1,102,4],[102,8,102,11],[109,1,109,4],[109,8,109,11],[116,1,116,4],[116,8,116,11],[123,1,123,4],[123,8,123,11],[130,1,130,4],[130,8,130,11],[137,1,137,4],[137,8,137,11],[144,1,144,14],[145,1,145,4],[145,8,145,11],[152,1,152,4],[152,8,152,11],[159,1,159,4],[159,8,159,11],[166,1,166,4],[166,8,166,11],[173,1,173,4],[173,8,173,11],[180,1,180,14],[181,1,181,4],[181,8,181,11],[186,1,186,4],[186,8,186,11],[191,1,191,4],[191,8,191,11],[196,1,196,14],[197,1,197,4],[197,8,197,11],[204,1,204,4],[204,8,204,11],[211,1,211,14],[212,1,212,4],[212,8,212,11],[219,1,219,14],[220,1,220,4],[220,8,220,11],[227,1,227,14],[228,1,228,4],[230,1,230,4],[232,1,232,4],[234,1,234,14],[235,1,235,4],[239,1,239,11],[241,3,241,9],[242,1,242,4],[243,1,243,4],[243,8,243,11],[248,2,248,3],[248,4,248,5],[248,6,248,7],[248,8,248,9],[250,3,250,9],[251,3,251,9],[252,3,252,9]]}
[]
[null,"Tutuka Power Station "]
[null,{"$f":"PREAMBLE!B1","v":"Tutuka Power Plant - Solar Photovoltaic  (Output:28.93MW)"}]
[null,"Activity Schedule (Rev- 00) "]
[]
[{"$nulls":16},"Local "]
[null,"Item No.","Section Number","Description","Activity","Currency",{"$nulls":7},"CPA","CPA Description",null,"Foreign"]
[{"$nulls":7},"RoE Currency\n1,00 = ZAR","Unit","QTY","Local Currency Rate","Foreign Currency Rate","Total Amount converted to ZAR"]
[{"$nulls":15},"Month-01","Month-02","Month-03","Month-04","Month-05","Month-06"]
[]
[null,"Fixed Charges",{"$nulls":12},{"$f":"IF(D11<>\"\",VLOOKUP(D11,'[13]5.1.4 Price adjustment formulae'!$A$8:$B$19,2,FALSE),\"\")","v":""}]
[null,128,"KPV35","Establishment of facilities on site","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J12*L12*H12","v":0},"-","Fixed"]
[null,129,{"$f":"C12","v":"KPV35"},"Other contractual requirements","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J13*L13*H13","v":0},"-","Fixed"]
[null,130,{"$f":"C13","v":"KPV35"},"Environmental related costs","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B14+1","v":131},"KPV35","Health & Safety related costs","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B15+1","v":132},"KPV35","Quality related costs","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,133,"KPV35","Training related costs","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,134,"KPV35","Medical tests / Induction training","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,135,"KPV35","Staff transportation","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,136,"KPV35","Staff accommodation","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J20*L20*H20","v":0},"-","Fixed"]
[null,137,"KPV35","Access & permits","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,138,"KPV35","Site de-establishment","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Time Related Charges"]
[null,{"$f":"B22+1","v":139},{"$f":"C22","v":"KPV35"},"Management","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J24*L24*H24","v":0},"-","Fixed"]
[null,{"$f":"B24+1","v":140},{"$f":"C24","v":"KPV35"},"Project Management during construction period","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J25*L25*H25","v":0},"-","Fixed"]
[null,141,{"$f":"C25","v":"KPV35"},"Supervision during construction period","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J26*L26*H26","v":0},"-","Fixed"]
[null,142,{"$f":"C26","v":"KPV35"},"Specialist during construction period","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J27*L27*H27","v":0},"-","Fixed"]
[null,143,"KPV35","Site related cost","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J28*L28*H28","v":0},"-","Fixed"]
[null,"Value Related Charges",{"$nulls":7},1,null,0,{"$f":"J30*L30*H30","v":0}]
[null,{"$f":"B28+1","v":144},{"$f":"C28","v":"KPV35"},"Performance Bonds","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,null,"-","Fixed"]
[null,{"$f":"B30+1","v":145},{"$f":"C30","v":"KPV35"},"Retention Bonds","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J31*L31*H31","v":0},"-","Fixed"]
[null,{"$f":"B31+1","v":146},{"$f":"C31","v":"KPV35"},"Cost of SDL & I Performance Security","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B32+1","v":147},"KPV35","Workers Insurance","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B33+1","v":148},"KPV35","Works Insurance","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B34+1","v":149},"KPV35","Security for the Works","Preliminaries","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Civil Works"]
[null,"Site clearance"]
[null,{"$f":"1","v":1},"KPV02","Diggings including removal of trees, tree stumps and clearing of site ","Design","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"H38*J38*L38","v":0},"-","Fixed"]
[null,{"$f":"B38+1","v":2},{"$f":"C38","v":"KPV02"},"Diggings including removal of trees, tree stumps and clearing of site ","Construction, Erection, Installation","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"H39*J39*L39","v":0},"-","Fixed"]
[null,{"$f":"B39+1","v":3},{"$f":"C39","v":"KPV02"},"Diggings including removal of trees, tree stumps and clearing of site ","Site Acceptance Test","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Reinforced concrete foundation for solar panels"]
[null,{"$f":"B40+1","v":4},"KPV03","Foundation (Allowance)","Design","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"H42*J42*L42","v":0},"-","Fixed"]
[null,{"$f":"B42+1","v":5},{"$f":"C42","v":"KPV03"},"Foundation (Allowance)","Construction, Erection, Installation","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"H43*J43*L43","v":0},"-","Fixed"]
[null,{"$f":"B43+1","v":6},{"$f":"C43","v":"KPV03"},"Foundation (Allowance)","Factory Acceptance Test","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,7,{"$f":"C44","v":"KPV03"},"Foundation (Allowance)","Quality Inspection","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"H45*J45*L45","v":0},"-","Fixed"]
[null,"Access roads (Allowance)"]
[null,{"$f":"B45+1","v":8},"KPV04","Allowance for access roads","Design","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"H47*J47*L47","v":0},"-","Fixed"]
[null,{"$f":"B47+1","v":9},{"$f":"C47","v":"KPV04"},"Allowance for access roads","Construction, Erection, Installation","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"H48*J48*L48","v":0},"-","Fixed"]
[null,10,{"$f":"C48","v":"KPV04"},"Allowance for access roads","Factory Acceptance Test","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,11,{"$f":"C49","v":"KPV04"},"Allowance for access roads","Quality Inspection","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"H50*J50*L50","v":0},"-","Fixed"]
[null,"Steelwork for working platforms"]
[null,{"$f":"B50+1","v":12},"KPV05","Steelwork","Design","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J52*L52*H52","v":0},"-","Fixed"]
[null,{"$f":"B52+1","v":13},{"$f":"C52","v":"KPV05"},"Steelwork","Procurement","Local","ZAR",{"v":1,"d":"1.00"},{"$f":"I52","v":"Item"},1,null,0,0,"-","Fixed"]
[null,14,{"$f":"C53","v":"KPV05"},"Steelwork","Transport","Local","ZAR",{"v":1,"d":"1.00"},{"$f":"I53","v":"Item"},1,null,0,0,"-","Fixed"]
[null,15,{"$f":"C54","v":"KPV05"},"Steelwork","Construction, Erection, Installation","Local","ZAR",{"v":1,"d":"1.00"},{"$f":"I54","v":"Item"},1,null,0,0,"-","Fixed"]
[null,16,{"$f":"C55","v":"KPV05"},"Steelwork","Quality Test","Local","ZAR",{"v":1,"d":"1.00"},{"$f":"I55","v":"Item"},1,null,0,0,"-","Fixed"]
[null,17,{"$f":"C56","v":"KPV05"},"Steelwork","Site Acceptance Test","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Mechanical works"]
[null,"PV Modules"]
[null,{"$f":"B57+1","v":18},"KPV06","PV modules","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J60*L60*H60","v":0},"-","Fixed"]
[null,{"$f":"B60+1","v":19},{"$f":"C60","v":"KPV06"},"PV modules","Manufacture and Assembly / Procurement of material","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J61*L61*H61","v":0},"-","Fixed"]
[null,20,{"$f":"C61","v":"KPV06"},"PV modules","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,21,{"$f":"C62","v":"KPV06"},"PV modules","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,22,{"$f":"C63","v":"KPV06"},"PV modules","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,23,{"$f":"C64","v":"KPV06"},"PV modules","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Inverter"]
[null,{"$f":"B65+1","v":24},"KPV07","AC kW Inverter","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J67*L67*H67","v":0},"-","Fixed"]
[null,{"$f":"B67+1","v":25},{"$f":"C67","v":"KPV07"},"AC kW Inverter","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B68+1","v":26},{"$f":"C68","v":"KPV07"},"AC kW Inverter","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,27,{"$f":"C69","v":"KPV07"},"AC kW Inverter","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,28,{"$f":"C70","v":"KPV07"},"AC kW Inverter","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,29,{"$f":"C71","v":"KPV07"},"AC kW Inverter","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Horizontal Axis Tracking System"]
[null,{"$f":"B57+1","v":18},"KPV08","Tracking System","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J74*L74*H74","v":0},"-","Fixed"]
[null,{"$f":"B74+1","v":19},{"$f":"C74","v":"KPV08"},"Tracking System","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,20,{"$f":"C75","v":"KPV08"},"Tracking System","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,21,{"$f":"C76","v":"KPV08"},"Tracking System","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,22,{"$f":"C77","v":"KPV08"},"Tracking System","Site Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,23,{"$f":"C78","v":"KPV08"},"Tracking System","Commissioning","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Capacitor Banks"]
[null,{"$f":"B79+1","v":24},"KPV09",{"$f":"D67","v":"AC kW Inverter"},"Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J81*L81*H81","v":0},"-","Fixed"]
[null,{"$f":"B81+1","v":25},{"$f":"C81","v":"KPV09"},{"$f":"D81","v":"AC kW Inverter"},"Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B82+1","v":26},{"$f":"C82","v":"KPV09"},{"$f":"D82","v":"AC kW Inverter"},"Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,27,{"$f":"C83","v":"KPV09"},"AC kW Inverter","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,28,{"$f":"C84","v":"KPV09"},"AC kW Inverter","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,29,{"$f":"C85","v":"KPV09"},"AC kW Inverter","Quality Inspection","Local ","ZAR",{"v":19.5,"d":"19.50"},"Item",1,null,0,0,"-","Fixed"]
[null,"Electrical works"]
[null,"Transformers"]
[null,{"$f":"B86+1","v":30},"KPV10","Transformers","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J89*L89*H89","v":0},"-","Fixed"]
[null,{"$f":"B89+1","v":31},{"$f":"C89","v":"KPV10"},"Transformers","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J90*L90*H90","v":0},"-","Fixed"]
[null,{"$f":"B90+1","v":32},{"$f":"C90","v":"KPV10"},"Transformers","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B91+1","v":33},{"$f":"C91","v":"KPV10"},"Transformers","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B92+1","v":34},{"$f":"C92","v":"KPV10"},{"$f":"D92","v":"Transformers"},"Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J93*L93*H93","v":0},"-","Fixed"]
[null,{"$f":"B93+1","v":35},{"$f":"C92","v":"KPV10"},"Transformers","Site Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B94+1","v":36},{"$f":"C94","v":"KPV10"},"Transformers","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"LV Switchgear "]
[null,{"$f":"B94+1","v":36},"KPV11","Switchgear ","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",{"$f":"J89","v":1},null,0,{"$f":"J97*L97*H97","v":0},"-","Fixed"]
[null,{"$f":"B97+1","v":37},{"$f":"C97","v":"KPV11"},"Switchgear ","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",{"$f":"J97","v":1},null,0,0,"-","Fixed"]
[null,{"$f":"B98+1","v":38},{"$f":"C98","v":"KPV11"},"Switchgear ","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",{"$f":"J98","v":1},null,0,0,"-","Fixed"]
[null,{"$f":"B99+1","v":39},{"$f":"C99","v":"KPV11"},"Switchgear ","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B100+1","v":40},{"$f":"C100","v":"KPV11"},"Switchgear ","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B101+1","v":41},{"$f":"C101","v":"KPV11"},"Switchgear ","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"MV Switchgear "]
[null,{"$f":"B101+1","v":41},"KPV12","Switchgear ","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",{"$f":"J97","v":1},null,0,{"$f":"J104*L104*H104","v":0},"-","Fixed"]
[null,{"$f":"B104+1","v":42},{"$f":"C104","v":"KPV12"},"Switchgear ","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",{"$f":"J104","v":1},null,0,0,"-","Fixed"]
[null,{"$f":"B105+1","v":43},{"$f":"C105","v":"KPV12"},"Switchgear ","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",{"$f":"J105","v":1},null,0,0,"-","Fixed"]
[null,{"$f":"B106+1","v":44},{"$f":"C106","v":"KPV12"},"Switchgear ","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B107+1","v":45},{"$f":"C107","v":"KPV12"},"Switchgear ","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B108+1","v":46},{"$f":"C108","v":"KPV12"},"Switchgear ","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Transformer Junction Box"]
[null,{"$f":"B108+1","v":46},"KPV13","Current and Voltage Transformer Junction Box","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J111*L111*H111","v":0},"-","Fixed"]
[null,{"$f":"B111+1","v":47},{"$f":"C111","v":"KPV13"},"Current and Voltage Transformer Junction Box","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B112+1","v":48},{"$f":"C112","v":"KPV13"},"Current and Voltage Transformer Junction Box","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B113+1","v":49},{"$f":"C113","v":"KPV13"},"Telecommunication","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B113+1","v":49},{"$f":"C114","v":"KPV13"},"Current and Voltage Transformer Junction Box","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B115+1","v":50},{"$f":"C115","v":"KPV13"},"Current and Voltage Transformer Junction Box","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Protection (Allowance)"]
[null,{"$f":"B115+1","v":50},"KPV14","Transformer protection","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J118*L118*H118","v":0},"-","Fixed"]
[null,{"$f":"B118+1","v":51},{"$f":"C118","v":"KPV14"},"Transformer protection","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},{"$f":"I118","v":"Item"},1,null,0,0,"-","Fixed"]
[null,{"$f":"B119+1","v":52},{"$f":"C119","v":"KPV14"},"Transformer protection","Transport","Local ","ZAR",{"v":1,"d":"1.00"},{"$f":"I119","v":"Item"},1,null,0,0,"-","Fixed"]
[null,{"$f":"B120+1","v":53},{"$f":"C120","v":"KPV14"},"Transformer protection","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},{"$f":"I120","v":"Item"},1,null,0,0,"-","Fixed"]
[null,{"$f":"B121+1","v":54},{"$f":"C121","v":"KPV14"},"Transformer protection","Site Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},{"$f":"I121","v":"Item"},1,null,0,0,"-","Fixed"]
[null,{"$f":"B122+1","v":55},{"$f":"C122","v":"KPV14"},"Transformer protection","Commissioning","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Standby Power Systems & AC/DC Distribution Boards"]
[null,{"$f":"B122+1","v":55},"KPV15","Standby Power Systems ","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J125*L125*H125","v":0},"-","Fixed"]
[null,{"$f":"B125+1","v":56},{"$f":"C125","v":"KPV15"},"Standby Power Systems ","Manufacture ","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B126+1","v":57},{"$f":"C126","v":"KPV15"},"Standby Power Systems ","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B127+1","v":58},{"$f":"C127","v":"KPV15"},"Standby Power Systems ","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B128+1","v":59},{"$f":"C128","v":"KPV15"},"Standby Power Systems ","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B128+1","v":59},{"$f":"C129","v":"KPV15"},"Standby Power Systems ","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Cabling (Allowance)"]
[null,{"$f":"B129+1","v":60},"KPV16","Cabling","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J132*L132*H132","v":0},"-","Fixed"]
[null,{"$f":"B132+1","v":61},{"$f":"C132","v":"KPV16"},"Cabling","Manufacture ","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B133+1","v":62},{"$f":"C133","v":"KPV16"},"Cabling","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B134+1","v":63},{"$f":"C134","v":"KPV16"},"Cabling","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B135+1","v":64},{"$f":"C135","v":"KPV16"},"Cabling","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B135+1","v":64},{"$f":"C136","v":"KPV16"},"Cabling","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Information Techonology "]
[null,{"$f":"B136+1","v":65},"KPV17","Information Technology","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J139*L139*H139","v":0},"-","Fixed"]
[null,{"$f":"B139+1","v":66},{"$f":"C139","v":"KPV17"},"Information Technology","Procurement","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[" ",{"$f":"B140+1","v":67},{"$f":"C140","v":"KPV17"},"Information Technology","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B141+1","v":68},{"$f":"C141","v":"KPV17"},"Information Technology","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B142+1","v":69},{"$f":"C142","v":"KPV17"},"Information Technology","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B142+1","v":69},{"$f":"C143","v":"KPV17"},"Information Technology","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[]
[null,"Remote Engineering Access"]
[null,{"$f":"B144+1","v":70},"KPV18","Remote Engineering Access","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J147*L147*H147","v":0},"-","Fixed"]
[null,{"$f":"B147+1","v":71},{"$f":"C147","v":"KPV18"},"Remote Engineering Access","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},{"$f":"I147","v":"Item"},1,null,0,0,"-","Fixed"]
[null,{"$f":"B148+1","v":72},{"$f":"C148","v":"KPV18"},"Remote Engineering Access","Transport","Local ","ZAR",{"v":1,"d":"1.00"},{"$f":"I148","v":"Item"},1,null,0,0,"-","Fixed"]
[null,{"$f":"B149+1","v":73},{"$f":"C149","v":"KPV18"},"Remote Engineering Access","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},{"$f":"I149","v":"Item"},1,null,0,0,"-","Fixed"]
[null,{"$f":"B150+1","v":74},{"$f":"C150","v":"KPV18"},"Remote Engineering Access","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},{"$f":"I150","v":"Item"},1,null,0,0,"-","Fixed"]
[null,{"$f":"B151+1","v":75},{"$f":"C151","v":"KPV18"},"Remote Engineering Access","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Network Integration (SSB)"]
[null,{"$f":"B151+1","v":75},"KPV19","Network Integration Equipment","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J154*L154*H154","v":0},"-","Fixed"]
[null,{"$f":"B154+1","v":76},{"$f":"C154","v":"KPV19"},"Network Integration Equipment","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B155+1","v":77},{"$f":"C155","v":"KPV19"},"Network Integration Equipment","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B156+1","v":78},{"$f":"C156","v":"KPV19"},"Network Integration Equipment","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B157+1","v":79},{"$f":"C157","v":"KPV19"},"Network Integration Equipment","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B157+1","v":79},{"$f":"C154","v":"KPV19"},"Network Integration Equipment","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Network Integration (Substation 1)"]
[null,{"$f":"B158+1","v":80},"KPV20","Network Integration Equipment","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J161*L161*H161","v":0},"-","Fixed"]
[null,{"$f":"B161+1","v":81},{"$f":"C161","v":"KPV20"},"Network Integration Equipment","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B162+1","v":82},{"$f":"C162","v":"KPV20"},"Network Integration Equipment","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B163+1","v":83},{"$f":"C163","v":"KPV20"},"Network Integration Equipment","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B164+1","v":84},{"$f":"C164","v":"KPV20"},"Network Integration Equipment","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B164+1","v":84},{"$f":"C161","v":"KPV20"},"Network Integration Equipment","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Network Integration (Substation 2)"]
[null,{"$f":"B165+1","v":85},"KPV21","Network Integration Equipment","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J168*L168*H168","v":0},"-","Fixed"]
[null,{"$f":"B168+1","v":86},{"$f":"C168","v":"KPV21"},"Network Integration Equipment","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B169+1","v":87},{"$f":"C169","v":"KPV21"},"Network Integration Equipment","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B170+1","v":88},{"$f":"C170","v":"KPV21"},"Network Integration Equipment","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B171+1","v":89},{"$f":"C171","v":"KPV21"},"Network Integration Equipment","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B171+1","v":89},{"$f":"C168","v":"KPV21"},"Network Integration Equipment","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Allowance for other C&I requirements"]
[null,{"$f":"B172+1","v":90},"KPV22","C&I Requirements","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J175*L175*H175","v":0},"-","Fixed"]
[null,{"$f":"B175+1","v":91},{"$f":"C175","v":"KPV22"},"C&I Requirements","Manufacture and Assembly","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B176+1","v":92},{"$f":"C176","v":"KPV22"},"C&I Requirements","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B177+1","v":93},{"$f":"C177","v":"KPV22"},"C&I Requirements","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B178+1","v":94},{"$f":"C178","v":"KPV22"},"C&I Requirements","Site Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B179+1","v":95},{"$f":"C179","v":"KPV22"},"C&I Requirements","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[]
[null,"88/33kV Switching station (Allowance)"]
[null,{"$f":"B180+1","v":96},"KPV23","88/33kV Switching station","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J183*L183*H183","v":0},"-","Fixed"]
[null,{"$f":"B183+1","v":97},{"$f":"C183","v":"KPV23"},"88/33kV Switching station","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J184*L184*H184","v":0},"-","Fixed"]
[null,{"$f":"B184+1","v":98},{"$f":"C184","v":"KPV23"},"88/33kV Switching station","Site Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J185*L185*H185","v":0},"-","Fixed"]
[null,99,{"$f":"C183","v":"KPV23"},"88/33kV Switching station","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J186*L186*H186","v":0},"-","Fixed"]
[null,"Substation 01"]
[null,{"$f":"B186+1","v":100},"KPV25","Substation 01","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J188*L188*H188","v":0},"-","Fixed"]
[null,{"$f":"B188+1","v":101},{"$f":"C188","v":"KPV25"},"Substation 01","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J189*L189*H189","v":0},"-","Fixed"]
[null,{"$f":"B189+1","v":102},{"$f":"C189","v":"KPV25"},"Substation 01","Site Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J190*L190*H190","v":0},"-","Fixed"]
[null,103,"KPV25","Substation 01","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J191*L191*H191","v":0},"-","Fixed"]
[null,"Substation 02"]
[null,{"$f":"B191+1","v":104},"KPV26","Substation 02","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J193*L193*H193","v":0},"-","Fixed"]
[null,{"$f":"B193+1","v":105},{"$f":"C193","v":"KPV26"},"Substation 02","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J194*L194*H194","v":0},"-","Fixed"]
[null,{"$f":"B194+1","v":106},{"$f":"C194","v":"KPV26"},"Substation 02","Site Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J195*L195*H195","v":0},"-","Fixed"]
[null,107,"KPV26","Substation 02","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J196*L196*H196","v":0},"-","Fixed"]
[]
[null,"Signal lighting"]
[null,{"$f":"B196+1","v":108},"KPV28","Signal lighting","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J199*L199*H199","v":0},"-","Fixed"]
[null,{"$f":"B199+1","v":109},{"$f":"C199","v":"KPV28"},"Signal lighting","Procurement","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B199+1","v":109},{"$f":"C200","v":"KPV28"},"Signal lighting","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B201+1","v":110},{"$f":"C201","v":"KPV28"},"Signal lighting","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B201+1","v":110},"KPV28","Signal lighting","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B203+1","v":111},"KPV28","Signal lighting","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Lighting"]
[null,{"$f":"B203+1","v":111},"KPV29","Floodlighting","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J206*L206*H206","v":0},"-","Fixed"]
[null,{"$f":"B206+1","v":112},{"$f":"C206","v":"KPV29"},"Floodlighting","Procurement","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B206+1","v":112},"KPV29","Floodlighting","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B206+1","v":112},"KPV29","Floodlighting","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,{"$f":"B209+1","v":113},"KPV29","Floodlighting","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,113,"KPV29","Floodlighting","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[]
[null,"Water Supply and Reticulation (Allowance)"]
[null,{"$f":"B203+1","v":111},"KPV30","Water supply and Reticulation","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J214*L214*H214","v":0},"-","Fixed"]
[null,{"$f":"B214+1","v":112},{"$f":"C214","v":"KPV30"},"Water supply and Reticulation","Procurement","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J215*L215*H215","v":0},"-","Fixed"]
[null,113,"KPV30","Water supply and Reticulation","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J216*L216*H216","v":0},"-","Fixed"]
[null,114,"KPV30","Water supply and Reticulation","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,115,"KPV30","Water supply and Reticulation","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,116,"KPV30","Water supply and Reticulation","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,"Physical Security Systems"]
[null,"Security fence & Gates"]
[null,{"$f":"B211+1","v":114},"PV2031","Fence and Gates","Design","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J222*L222*H222","v":0},"-","Fixed"]
[null,{"$f":"B222+1","v":115},{"$f":"C222","v":"PV2031"},"Fence and Gates","Procurement","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J223*L223*H223","v":0},"-","Fixed"]
[null,116,"PV2031","Fence and Gates","Transport","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J224*L224*H224","v":0},"-","Fixed"]
[null,117,"PV2031","Fence and Gates","Construction, Erection, Installation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J225*L225*H225","v":0},"-","Fixed"]
[null,118,"PV2031","Fence and Gates","Factory Acceptance Test","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[null,119,"PV2031","Fence and Gates","Quality Inspection","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,0,"-","Fixed"]
[]
[null,"Geotechnical Investigation",{"$nulls":9},0,null,null,{"$f":"IF(D229<>\"\",VLOOKUP(D229,'[13]5.1.4 Price adjustment formulae'!$A$8:$B$19,2,FALSE),\"\")","v":""}]
[null,121,"KPV33","Geotechnical Investigation unit 1","Geotechnical investigation","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J230*L230*H230","v":0},"-","Fixed"]
[null,"Commissioning",{"$nulls":9},0,{"$f":"J231*L231*H231","v":0},null,{"$f":"IF(D231<>\"\",VLOOKUP(D231,'[13]5.1.4 Price adjustment formulae'!$A$8:$B$19,2,FALSE),\"\")","v":""}]
[null,122,{"$f":"C230","v":"KPV33"},"Commissioning of the plant","Performance Testing","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J232*L232*H232","v":0},"-","Fixed"]
[null,"Training",{"$nulls":9},0,{"$f":"J233*L233*H233","v":0},null,{"$f":"IF(D233<>\"\",VLOOKUP(D233,'[13]5.1.4 Price adjustment formulae'!$A$8:$B$19,2,FALSE),\"\")","v":""}]
[null,123,{"$f":"C232","v":"KPV33"},"Training related costs","Training","Local","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J234*L234*H234","v":0},"-","Fixed"]
[]
[null,"Other ",{"$nulls":9},0,null,null,{"$f":"IF(D236<>\"\",VLOOKUP(D236,'[13]5.1.4 Price adjustment formulae'!$A$8:$B$19,2,FALSE),\"\")","v":""}]
[null,"other ",{"$nulls":3},"Local ","ZAR",{"v":1,"d":"1.00"},"item",1]
[null,"other",{"$nulls":3},"Local ","ZAR",{"v":1,"d":"1.00"},"item",1]
[null,"other ",{"$nulls":3},"Local ","ZAR",{"v":1,"d":"1.00"},"item",1]
[null,"Total ",{"$nulls":12}," "]
[]
[]
[null,"Operating, Maintenance, Training & Manuals"]
[null,"Operation and Maintenance Building (O & M)"]
[null,null,"KPV34","Operating, Maintenance and Training.","Year 01 - O & M","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"L245","v":0},"-","Fixed"]
[null,null,"KPV34","Operating, Maintenance and Training.","Year 02 - O & M","Local ","ZAR",{"v":1,"d":"1.00"},"Item",1,null,0,{"$f":"J246*L246*H246","v":0},"-","Fixed"]
[]
[]
[null,null,"Notes:"]
[]
[{"$nulls":3}," - This is an example of Activity Schedule"]
[{"$nulls":3}," - The Bidder is welcomed to add or activities/description or items based on their design "]

{"sheet":"Exchange rates","index":3,"n_rows":33,"n_cols":8,"rows_kept":33,"merged":[[0,0,0,1],[0,2,0,4],[1,0,1,1],[1,2,1,4],[2,0,2,1],[2,2,2,4],[3,0,3,1],[3,2,3,4],[8,1,8,6],[9,0,11,0],[9,1,9,6],[9,14,9,19],[10,1,10,6],[11,1,11,6],[12,1,12,6],[13,1,13,6],[17,7,17,12]]}
["Enquiry No.",null,{"$f":"'[14]Tender Cover Sheet'!C12","v":0}]
["Package Name:",null,"Tutuka Power Plant - Solar Photovoltaic  (Output:28.93MW)"]
["Tenderer's Name:",null,{"$f":"'[15]Tender Cover Sheet'!C16","v":0}]
["Category of Offer:",null,{"$f":"'[15]Read Me'!C4","v":0}]
[]
["5.1.4 EXCHANGE RATES FOR MULTIPLE CURRENCIES"]
[]
["NOTES:"]
[1,"The table below needs to be completed if the Employer will be exposed to any currency fluctuation as stipulated in Secondary Clause X3.  For conversion of the foreign portions to Rand, please use the South African Reserve Bank's (SARB) exchange rate at 12:00 on the day of advertisement of the bid.  This is in terms of the Preferential Procurement Policy Framework Act (PPPFA) with which the Employer has to comply.\nNB: Tenderers must submit proof of the SARB rate(s) of exchange used  "]
[2,"The following URL (electronic route) is to be followed to access the relevant SARB rates on their web pages:\n"]
[null,"www.resbank.co.za"]
[null,"-  Select Research\n-  Then select Rates\n-  Click on \"Select historical exchange rates and other interest rates\"\n-  Clicking on the exchange rate in the following page opens the daily rates per currency and SA Rand"]
[3,"The Employer deals only in the currencies listed below unless other currencies are specifically approved for this tender.  Kindly notify the Employer of any currency that the tenderer intends to use, but is not stipulated in the table, to consider sanctioning such currency.  Sufficient time must be allowed for the assessment and to respond to such request.  The onus is on the tenderer to submit a bid with approved currencies"]
[4,"The format in which the exchange rate must be inserted in the table is:  1 (One) Foreign Currency = R Amount  (i.e. the Rand amount for one of each foreign currency applicable).  Exchange rates must be rounded to 4 decimals\n\nNB :  Only the USD/ZAR, GBP/ZAR and EUR/ZAR are published in this way on the SARB web pages above.  The Rand rate with the other currencies must be inverted (1/Foreign Currency Rate) in order to list it in the required format in the table below\n"]
[" "]
["EXCHANGE RATES PUBLISHED BY SARB"]
["NB: Tenderers must submit proof of the SARB rate (s) of exchange used."]
[{"$nulls":4},"Date for which the rates are published :",null,null,"Date to be inserted in the following format: Day, Month and Year.\n\nMust be the SARB rate at 12:00 on day of advertisement of bid"]
["No","Currency Description","Code","Exchange Rate\nCurrency 1,00 = R Amount","Payment Method 1a, 1b or 2","Source"]
[1,"South African Rand","ZAR",{"v":1,"d":"R 1.00"}]
[2,"Australian Dollar","AUD",{"v":0,"d":"R 0.00"}]
[3,"Canadian Dollar","CAN",{"v":0,"d":"R 0.00"}]
[4,"Swiss Franc","CHF",{"v":0,"d":"R 0.00"}]
[5,"Danish Krone","DKK",{"v":0,"d":"R 0.00"}]
[6,"European Currency","EUR",{"v":0,"d":"R 0.00"}]
[7,"British Pound","GBP",{"v":0,"d":"R 0.00"}]
[8,"Hong Kong Dollar","HKD",{"v":0,"d":"R 0.00"}]
[9,"Japanese Yen","JPY",{"v":0,"d":"R 0.00"}]
[10,"Norwegian Krone","NOK",{"v":0,"d":"R 0.00"}]
[11,"New Zealand Dollar","NZD",{"v":0,"d":"R 0.00"}]
[12,"Swedish Krone","SEK",{"v":0,"d":"R 0.00"}]
[13,"Singapore Dollar","SGD",{"v":0,"d":"R 0.00"}]
[14,"United States Dollar","USD",{"v":0,"d":"R 0.00"}]

{"sheet":"CPA Formula","index":4,"n_rows":148,"n_cols":14,"rows_kept":148,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,4],[8,2,8,3],[8,5,8,7],[9,2,9,4],[9,5,18,7],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[21,1,21,6],[22,1,22,6],[25,1,25,6],[26,1,26,6],[27,1,27,6],[28,1,28,6],[29,1,29,6],[30,1,30,6],[32,1,32,6],[33,1,33,6],[34,1,34,6],[35,1,35,6],[36,1,36,6],[40,1,40,6],[51,1,51,6],[62,1,62,6],[73,1,73,6],[84,1,84,6],[95,1,95,6],[106,1,106,6],[117,1,117,6],[128,1,128,6],[139,1,139,6]]}
["Enquiry No."]
["Project Name:",null,"Tutuka Power Plant - Solar Photovoltaic  (Output:28.93MW)"]
["Tenderer's Name:"]
["Category of Offer:",null,{"$f":"'[16]Read Me'!C4","v":"Main Offer Only"}]
[]
["5.1.2 CONTRACT PRICE ADJUSTMENT (CPA) FOR INFLATION"]
[]
["No.","Formula Code","Summary of the description of the Tenderer's Formulae"]
[1,"Fixed","Firm and Fixed ",null,null,"Prices are 100 % fixed and firm. CPA is not applicable. "]
[2,"A","Tenderer's description of Formula A",null,null,"Type in the description of each formula in the tables below"]
[3,"B","Tenderer's description of Formula B"]
[4,"C","Tenderer's description of Formula C"]
[5,"D","Tenderer's description of Formula A"]
[6,"E",{"$f":"B85","v":"Tenderer's description of Formula E"}]
[7,"F",{"$f":"B96","v":"Tenderer's description of Formula F"}]
[8,"G",{"$f":"B107","v":"Tenderer's description of Formula G"}]
[9,"H",{"$f":"B118","v":"Tenderer's description of Formula H"}]
[10,"I",{"$f":"B129","v":"Tenderer's description of Formula I"}]
[11,"J",{"$f":"B140","v":"Tenderer's description of Formula J"}]
[]
["SPECIFIC REQUIREMENTS"]
[{"v":1,"d":"1."},"Only Main Offer is to be submitted. Main offer tenderers are to fully comply with the requirements in the General Notes and CPA Formulae Notes below."]
[{"v":2,"d":"2."},"No ALTERNATIVE offers are accepted."]
[]
["GENERAL NOTES :"]
[1,"References to \"indices\" below mean \"cost indices or reference prices\"."]
[2,"Where 5 year historical information must be provided as instructed below, internet address references which are accessible to the general public may be submitted by the Tenderer instead, with the specific electronic route and web page reflecting the applicable data."]
[3,"The worksheet  CPA Formula in 5.1.2. has to be populated by the tenderer (columns B - J), unless the tenderer’s prices are fixed and firm for the duration of the contract. Each CPA formula must add up to a total of 100%.  All columns are to be populated. No inhouse CPA indices may be used. Tenderers are to provide all requested information.CPA Formulae should represent cost breakdown of the goods/commodities/components/items being sourced.\n"]
[4,"CPA Formulae Codes Column N 5.1.1 Pricing is to be populated by the tenderer by selecting the respective drop down codes CPA formula as  developed by Tenderer in 5.1.2 CPA formulae worksheet   (e.g. Formula A-J ) then  the tenderer must populate their respective CPA formula in  5.1.2 CPA Formulae Worksheet. Codes and descriptions must be selected by the tenderer and inserted into each row of activity. "]
[5,"Prices will be fixed and firm for the first twelve (12) months after contract signing date and escalated on an annual basis based on the CPA formula agreed on with tenderer."]
[6,"The CPA escalation will be calculated as follows: latest index which is the latest available index at the end of each contractual year vs. the base index which is one month prior to tender closing date. "]
["CPA FORMULA NOTES :"]
[1,"Proportions/weightings in CPA Formulae: The fixed portion of each formula, not subject to CPA, must be at least 15% but Tenderers may submit higher fixed portion percentages.  The other constituent indices and their proportions in each formula must be realistic and relative to the applicable work. The fixed portion and other proportions must add up to 100%.   "]
[2,"Formulae must be linked to independent cost indices or other benchmarks (\"reference prices\") and must be clearly and completely defined. The source must be a recognised and independent statistical publishing organisation.  The Tenderers' in-house indices may not be used."]
[3,"Local Price CPA: Where local indices other than those published by SEIFSA or Statistics SA are specified, the Tenderer must submit 5 years' of month by month historical data for such indices.  The Tenderer must ensure that indices are published and recommended by the source thereof as applicable to the work involved and that they are still in force/use and applicable at the date of submission of the tender. "]
[4,"CPA Base Date: The CPA base date for calculating price movements will be the Base Date, Month before Tender closes. For indices or reference prices published as at certain dates, and where such a date is not the Base Date, the latest date for which it is published before the Base Date will be considered as the Base Date index or reference price.  In instances where the figure or value is not as at the Base Date or considered as the Base Date Index or reference price as explained herein, the date, figure or value as well as the reason for the deviation must be clearly separately stated and must be realistic for purposes of CPA.  "]
[5,"Base Date Index :   The base index or reference price must be inserted in the appropriate column."]
[" "," "]
[]
[]
["Formula A","Tenderer's description of Formula A"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide http link)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["A1"]
["A2"]
["A3"]
["A4"]
["A5"]
["A6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B43:B48)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula B","Tenderer's description of Formula B"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["B1"]
["B2"]
["B3"]
["B4"," "]
["B5"," "]
["B6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B54:B59)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula C","Tenderer's description of Formula C"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["C1",{"$nulls":4}," "," "," "]
["C2"," "]
["C3"]
["C4"," "]
["C5"," "]
["C6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B65:B70)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula D","Tenderer's description of Formula D"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["D1"," "]
["D2"," "]
["D3"]
["D4"," "]
["D5"," "]
["D6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B76:B81)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula E","Tenderer's description of Formula E"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["E1"," "]
["E2"," "]
["E3"]
["E4"," "]
["E5"," "]
["E6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B87:B92)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula F","Tenderer's description of Formula F"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["F1"]
["F2"]
["F3"]
["F4"]
["F5"]
["F6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B98:B103)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula G","Tenderer's description of Formula G"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["G1"," "]
["G2"," "]
["G3"," "]
["G4"]
["G5"," "]
["G6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B109:B114)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula H","Tenderer's description of Formula H"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["H1"," "]
["H2"," "]
["H3"," "]
["H4"," "]
["H5"," "]
["H6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B120:B125)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula I","Tenderer's description of Formula I"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["I1"," "]
["I2"," "]
["I3"," "]
["I4"]
["I5"," "]
["I6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B131:B136)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula J","Tenderer's description of Formula J"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["J1"," "]
["J2"]
["J3"," "]
["J4"," "]
["J5"," "]
["J6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B142:B147)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]