{"text_format":"3","workbook":"xls","n_sheets":14,"sheets":["Read Me FIRST","5.1 Tender Cover Sheet","5.1.1 Preambles","5.1.1.1 Summary of Payments","5.1.1.2Summary  of Sections","5.1.1.3SummaryofCurrency&CPA","5.1.1.4SummaryofCostAllocation","5.1.2 Activity Schedule","5.1.3 Rate of Exchange"," 5.1.4Price adjustment formulae","5.1.5  PS5 Schedule"," 5.1.6 LME","5.1.7 Spares Activity Schedule","5.1.8 Life Cycle costing"],"not_rendered":{"images":2,"external_links":2,"defined_names":18},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Read Me FIRST","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[4,0,4,2],[5,0,5,2],[8,1,8,2],[10,1,10,2],[12,1,12,2]],"flags":["formulas_cached_only"]}
["Project: ",null,"KUSILE POWER STATION"]
["Enquiry No.:",null,0]
["Package Name:",null,"OPTIMIZATION CONVEYOR LINK"]
["Tenderer's Name:",null,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 ooffer 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 DEIGNATED 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,"5.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,"5.1.1 Preamble","This sheet provides general guidelines for this section."]
[null,"5.1.1.1 Summary of Payments","This is a manual summary sheet. Data from sheet 5.1.2 may be used to assist with compilation"]
[null,"5.1.1.2 Summary of Sections","This is a summary sheet for use for summarising of data. "]
[null,"5.1.1.3 Summary Currency & CPA","This is a summary sheet for use for summarising of data. "]
[null,"5.1.1.4 Summary Cost Allocation","This is a summary sheet for use for summarising of data.  "]
[null,"5.1.2 Activity Schedule","This is the main data entry sheet for the Tenderer to complete. "]
[null,"5.1.3 Rate of Exchange","This sheet is provided to for Rate of Exchange which are carried forward to the Activity schedule and Spares schedule"]
[null,"5.1.4 Price adjustment formulae","This sheet is provided to for the Price adjustment formulae which are carried forward to the Activity schedule and Spares schedule"]
[null,"5.1.5 PS5 Schedule","To be completed by the Tenderer"]
[null,"5.1.6 LME","London Metal Exchange information"]
[null,"5.1.7 Spares schedule","Sheet to be completed by the Tenderer for Spares"]
[null,"5.1.8 Life Cycle Costing","Sheet to be completed by the Tenderer for determining life cycle costing"]

{"sheet":"5.1 Tender Cover Sheet","index":1,"n_rows":48,"n_cols":2,"rows_kept":48,"merged":[[1,0,1,3],[14,0,14,1],[16,0,16,1],[27,7,27,8]],"flags":["formulas_cached_only"]}
[]
["             KUSILE POWER STATION PROJECT "]
{"$rows_empty":12}
["PRICING INFORMATION"]
[]
["TENDER INFORMATION"]
[]
[" ENQUIRY NO:"]
[]
["NAME OF PACKAGE:","OPTIMIZATION CONVEYOR LINK"]
[]
["TENDERER’S NAME:  "]
[]
[]
["Annexure IT 5.1 Price Schedules "]
[]
["THE PRICE:  IN ZAR"]
["(excluding VAT)"]
[]
["RAND VALUE IN WORDS"]
[]
[]
[]
[]
["DATE :"]
[]
[]
[]
["FULL NAMES OF SIGNATORY:"]
[]
[]
[]
["DESIGNATION OF SIGNATORY:"]
[]
[]
[]
["SIGNATURE :"]

{"sheet":"5.1.1 Preambles","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2]],"flags":["formulas_cached_only"]}
["                        ",null,"KUSILE POWER STATION PROJECT"]
["ENQUIRY N0. ",null,"FOR:"]
["TENDERER'S NAME:"]
["5.1.1 PREAMBLE TO PRICE SCHEDULE "]
[]
[1,"The price schedule provides the basis of all valuations of the work, payments in multiple currencies, price adjustment (CPA) and general 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. The Contractor provides all necessary information which is required to determine amounts due at each application for payment relative to the activities and/or milestones completed or to be completed."]
[3,"The price schedule work breakdown structure provided by the Contractor is based on the price schedule provided by the Engineer.  The items listed by the Engineer are the minimum activities acceptable and identify the specific items of work which are required to achieve Completion. No deletion of any items is permitted. The price schedule work breakdown structure is compiled to the satisfaction of the Engineer with any additions and/or amendments deemed necessary."]
[4,"The Contractor’s detailed price schedule summates back to the summary of prices and PS5 schedules provided and is in sufficient detail to monitor completion of items related to the accepted programme and or milestones in order that payment of completed work may be assessed."]
[5,"The price schedule is integrated with the required rate of exchange and price adjustment information and the forecast rate of payment schedule (FRP)."]
[6,"Clear unique identification of work in multiple currencies is separately identified in the price schedule and for each currency and uniquely associated price adjustment formula. The combination of currencies and or price adjustment formulae in single rows is not permissible."]
[7,"The total of the prices includes for all direct and indirect costs, overheads, profits, on costs, risks, liabilities, obligations, etc. relative to the contract."]
[8,"The Contractor allows for all necessary costs to complete the Works as required in terms of the specifications, scope of work and conditions of contract whether expressly stated or not in the price schedules. The Contractor provides the Engineer with any breakdown of prices as may be required for specific items not detailed in the price schedules prior to or after contract award."]

{"sheet":"5.1.1.1 Summary of Payments","index":3,"n_rows":57,"n_cols":6,"rows_kept":57,"flags":["formulas_cached_only"]}
["               ","KUSILE POWER STATION PROJECT"]
["ENQUIRY No: ",null,"PROJECT:"]
["TENDERER NAME:"]
[]
[]
[]
["SUMMARY OF \"STATEMENTS FOR CERTIFICATION\" : TOTAL      "]
["The Summary is detailed with unique currency and price adjustment identification per row."]
["Additional rows are added as required"]
[null,null,"Currency",null,"CPA","Total Cost"]
["No","Cost Allocation Description","Code","Foreign / Local","Formulae","in"]
[null,null,"one per row",null,"one per row","ZAR"]
[1.1,"Design (Including Simulation and Studies)"]
[1.2]
[1.3]
[]
[2.1,"Procurement"]
[2.2]
[2.3]
[]
[3.1,"Engineering, Manufacturing and Assembly"]
[3.1]
[3.1]
[]
[]
[4.1,"Transportation"]
[4.2]
[4.3]
[]
[5.1,"Construction, Erection, Installation"]
[5.2]
[5.3]
[]
[6.1,"Commissioning & Testing"]
[6.2]
[6.3]
[]
[7.1,"Data Books"]
[7.2]
[7.3]
[]
[8.1,"Other"]
[8.2]
[8.3]
[]
["SUMMARY OF TOTALS IN EACH UNIQUE CURRENCY AND ASSOCIATED UNIQUE PRICE ADJUSTMENT FORMULA"]
[{"v":0,"d":"00"},"TOTAL"]
[{"v":0,"d":"00"},"TOTAL"]
[{"v":0,"d":"00"},"TOTAL"]
[{"v":0,"d":"00"},"TOTAL"]
[{"v":0,"d":"00"},"TOTAL"]
[{"v":0,"d":"00"},"TOTAL"]
[{"v":0,"d":"00"},"TOTAL"]
[{"v":0,"d":"00"},"TOTAL"]
[null,"OVERALL TOTAL (ALL IN ZAR)"]
[]
[null,"then below -   summary per unit -   if more than one unit"]

{"sheet":"5.1.1.2Summary  of Sections","index":4,"n_rows":23,"n_cols":22,"rows_kept":23,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2],[7,0,7,2]],"flags":["formulas_cached_only"]}
["                               POWER STATION PROJECT"]
["ENQUIRY No: "]
["TENDERER NAME:"]
["PROJECT:"]
[]
["Summary of Sections",null,null,"2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01"]
[]
[{"$nulls":3},"Data"]
["Foreign/Local","Currency","Section Description","Sum of May-22","Sum Jun-22","Sum of Jul-22","Sum of Aug-22","Sum of Sep-22","Sum of Oct-22","Sum of Nov-22","Sum of Dec-22","Sum of Jan-23","Sum of Feb-23","Sum of Mar-23","Sum of Apr-23","Sum of May-23","Sum of Jun-23","Sum of Jul-23","Sum of Aug-23","Sum of Sep-23","Sum of Oct-23","Sum of Nov-23"]
[null,null,"Link Conveyor 1 (LC1)"]
[null,null,"Link Conveyor 2 (LC2)"]
[null,null,"Extendable Link  Conveyor (ELC1) Part of ( LC1)"]
[null,null,"Extendable Link  Conveyor (ELC2) Part of ( LC2)"]
[null,null,"Crawler Mounted Radial Stacker to Conveyor 1 (CMRSC1)"]
[null,null,"Crawler Mounted Radial Stacker to Conveyor 2 (CMRSC2)"]
[null,null,"Transfer House 9"]
[null,null,"KKS Plant  Labeling"]
[null,null,"Commissioning"]
[null,null,"General Activities "]
[null,null,"Operating Manuals"]
[null,null,"Craneage"]
[null,null,"Scaffolding"]
[null,null,"RAM Study"]

{"sheet":"5.1.1.3SummaryofCurrency&CPA","index":5,"n_rows":9,"n_cols":22,"rows_kept":9,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2]],"flags":["formulas_cached_only"]}
[null,"KUSILE POWER STATION PROJECT"]
["ENQUIRY No: "]
["TENDERER NAME:"]
["PROJECT:"]
[]
["Summary of Currencies & CPA Formulae",null,null,"2022-05-01","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-01-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01"]
[]
[{"$nulls":3},"Data"]
["Foreign/Local","Currency Type","Formula No's","Sum of May-22","Sum Jun-22","Sum of Jul-22","Sum of Aug-22","Sum of Sep-22","Sum of Oct-22","Sum of Nov-22","Sum of Dec-22","Sum of Jan-23","Sum of Feb-23","Sum of Mar-23","Sum of Apr-23","Sum of May-23","Sum of Jun-23","Sum of Jul-23","Sum of Aug-23","Sum of Sep-23","Sum of Oct-23","Sum of Nov-23"]

{"sheet":"5.1.1.4SummaryofCostAllocation","index":6,"n_rows":18,"n_cols":24,"rows_kept":18,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2]],"flags":["formulas_cached_only"]}
[null,"                                            KUSILE POWER STATION PROJECT"]
["ENQUIRY No: "]
["TENDERER NAME:"]
["PROJECT:"]
[]
["Summary of Cost Allocation, Currencies & CPA Formulae"]
[{"$nulls":5},"Data"]
["Item No","Cost Allocation ","Foreign/Local","Currency Type","Formula No's","Sum of May-22","Sum Jun-22","Sum of Jul-22","Sum of Aug-22","Sum of Sep-22","Sum of Oct-22","Sum of Nov-22","Sum of Dec-22","Sum of Jan-23","Sum of Feb-23","Sum of Mar-23","Sum of Apr-23","Sum of May-23","Sum of Jun-23","Sum of Jul-23","Sum of Aug-23","Sum of Sep-23","Sum of Oct-23","Sum of Nov-23"]
[1,"Design (Including Simulation and Studies)"]
[2,"Procurement"]
[3,"Engineering, Manufacturing and Assembly"]
[4,"Transportation"]
[5,"Construction, Erection, Installation"]
[6,"Commissioning & Testing"]
[7,"Data Books"]
[8,"Other"]
[]
["Grand Total"]

{"sheet":"5.1.2 Activity Schedule","index":7,"n_rows":167,"n_cols":30,"rows_kept":167,"flags":["formulas_cached_only"]}
[null,null,"KUSILE POWER STATION PROJECT",{"$nulls":5},"Code","Exchange Rate Currency 1,00 ="]
["ENQUIRY No: ",{"$nulls":4},"Method","A Description of formula","Foreign","ZAR",{"v":0,"d":"R 0.000000"}]
["TENDERER NAME:",{"$nulls":4},"1a","B Description of formula","Local","EUR",{"v":0,"d":"R 0.0000"}]
["PROJECT:",{"$nulls":4},"1b","C Description of formula",null,"GBP",{"v":0,"d":"R 0.0000"}]
["NOTES:",{"$nulls":4},2,"D Description of formula",null,"USD",{"v":0,"d":"R 0.0000"}]
["The detail activity cashflow is summarised with unique currency and price adjustment identification",{"$nulls":5},"E Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["and any freight, insurances and importation costs are separately identified",{"$nulls":5},"F Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["The PS5 breakdown is indicated in the schedule ",{"$nulls":5},"G Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["The activity items detailed are the minimum required by the Employer. The tenderer",{"$nulls":5},"H Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["provides detailed activity breakdown in accordance with the programme and cashflow",{"$nulls":5},"I Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["requirements in terms of the contract",{"$nulls":5},"J Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["Tenderer to check and take responsibility for all descriptions, formulae, etc",{"$nulls":5},"K Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["The Tenderer can add rows as required to cater for specific requirements but is",{"$nulls":5},"L Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["to adhere to the basic requirements identified above.",{"$nulls":7},0,{"v":0,"d":"R 0.0000"},{"$nulls":4},"ENQUIRY No: ",{"$nulls":6},"ENQUIRY No: "]
["A sub-description column is provided for additional detail descriptions if required",{"$nulls":7},0,{"v":0,"d":"R 0.0000"}]
["Ensure clear Indicatation whether offer is main or alternative tender",{"$nulls":13},"FORECAST RATE OF PAYMENT",null,null,"YEAR 2022",{"$nulls":3},"FORECAST RATE OF PAYMENT",{"$nulls":5},"YEAR 2023"]
[{"$nulls":6},"Price cost allocation - Note Unique currencies and CPA formula per line must be compiled",{"$nulls":7},"Certification date",{"$nulls":6},"Certification date"]
[{"$nulls":6},"with ie only one currency with one associated CPA formula",{"$nulls":7},"2022-05-25","2022-06-25","2022-07-25","2022-08-25","2022-09-25","2022-10-25","2022-11-25","2023-01-25","2023-02-25","2023-03-25","2023-04-25","2023-06-25","2023-07-25","2023-08-25","2023-09-25","2023-11-25"]
[{"$nulls":6},"Price adjustment","Rate of exchange Data",{"$nulls":3},"ACTIVITY","ACTIVITY",null,"Payment Month:",{"$nulls":6},"Payment Month:"]
["Ref","Section Description","Activity Description","No","Cost allocation ","Payment method 1a, 1b or 2","FORMULA NOs","Foreign / Local","Currency Type","RoE Currency 1,00 = R","Total Cost in ZAR","START  DATE","COMPLETION DATE","DURATION","2022-06-01","2022-07-01","2022-08-01","2022-09-01","2022-10-01","2022-11-01","2022-12-01","2023-02-01","2023-03-01","2023-04-01","2023-05-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-12-01"]
[1,"Link Conveyor 1 (LC1)",null,10,"Design (Including Simulation and Studies)"]
[2,"Link Conveyor 1 (LC1)",null,20,"Procurement"]
[3,"Link Conveyor 1 (LC1)",null,30,"Engineering, Manufacturing and Assembly"]
[4,"Link Conveyor 1 (LC1)",null,40,"Transportation"]
[5,"Link Conveyor 1 (LC1)",null,50,"Construction, Erection, Installation"]
[6,"Link Conveyor 1 (LC1)",null,60,"Commissioning & Testing"]
[7,"Link Conveyor 1 (LC1)",null,70,"Data Books"]
[8,"Link Conveyor 1 (LC1)",null,80,"Other"]
[]
[]
[9,"Link Conveyor 2 (LC2)",null,10,"Design (Including Simulation and Studies)"]
[10,"Link Conveyor 2 (LC2)",null,20,"Procurement"]
[12,"Link Conveyor 2 (LC2)",null,30,"Engineering, Manufacturing and Assembly"]
[14,"Link Conveyor 2 (LC2)",null,40,"Transportation"]
[15,"Link Conveyor 2 (LC2)",null,50,"Construction, Erection, Installation"]
[16,"Link Conveyor 2 (LC2)",null,60,"Commissioning & Testing"]
[17,"Link Conveyor 2 (LC2)",null,70,"Data Books"]
[18,"Link Conveyor 2 (LC2)",null,80,"Other"]
[]
[]
[19,"Extendable Link  Conveyor (ELC1) Part of ( LC1)",null,10,"Design (Including Simulation and Studies)"]
[20,"Extendable Link  Conveyor (ELC1) Part of ( LC1)",null,20,"Procurement"]
[20,"Extendable Link  Conveyor (ELC1) Part of ( LC1)",null,30,"Engineering, Manufacturing and Assembly"]
[21,"Extendable Link  Conveyor (ELC1) Part of ( LC1)",null,40,"Transportation"]
[21,"Extendable Link  Conveyor (ELC1) Part of ( LC1)",null,50,"Construction, Erection, Installation"]
[22,"Extendable Link  Conveyor (ELC1) Part of ( LC1)",null,60,"Commissioning & Testing"]
[22,"Extendable Link  Conveyor (ELC1) Part of ( LC1)",null,70,"Data Books"]
[23,"Extendable Link  Conveyor (ELC1) Part of ( LC1)",null,80,"Other"]
[]
[]
[24,"Extendable Link  Conveyor (ELC2) Part of ( LC2)",null,10,"Design (Including Simulation and Studies)"]
[25,"Extendable Link  Conveyor (ELC2) Part of ( LC2)",null,20,"Procurement"]
[26,"Extendable Link  Conveyor (ELC2) Part of ( LC2)",null,30,"Engineering, Manufacturing and Assembly"]
[27,"Extendable Link  Conveyor (ELC2) Part of ( LC2)",null,40,"Transportation"]
[28,"Extendable Link  Conveyor (ELC2) Part of ( LC2)",null,50,"Construction, Erection, Installation"]
[29,"Extendable Link  Conveyor (ELC2) Part of ( LC2)",null,60,"Commissioning & Testing"]
[30,"Extendable Link  Conveyor (ELC2) Part of ( LC2)",null,70,"Data Books"]
[31,"Extendable Link  Conveyor (ELC2) Part of ( LC2)",null,80,"Other"]
[]
[]
[32,"Crawler Mounted Radial Stacker to Conveyor 1 (CMRSC1)",null,10,"Design (Including Simulation and Studies)"]
[33,"Crawler Mounted Radial Stacker to Conveyor 1 (CMRSC1)",null,20,"Procurement"]
[34,"Crawler Mounted Radial Stacker to Conveyor 1 (CMRSC1)",null,30,"Engineering, Manufacturing and Assembly"]
[35,"Crawler Mounted Radial Stacker to Conveyor 1 (CMRSC1)",null,40,"Transportation"]
[36,"Crawler Mounted Radial Stacker to Conveyor 1 (CMRSC1)",null,50,"Construction, Erection, Installation"]
[37,"Crawler Mounted Radial Stacker to Conveyor 1 (CMRSC1)",null,60,"Commissioning & Testing"]
[38,"Crawler Mounted Radial Stacker to Conveyor 1 (CMRSC1)",null,70,"Data Books"]
[{"$nulls":3},80,"Other"]
[]
[39,"Crawler Mounted Radial Stacker to Conveyor 2 (CMRSC2)",null,10,"Design (Including Simulation and Studies)"]
[40,"Crawler Mounted Radial Stacker to Conveyor 2 (CMRSC2)",null,20,"Procurement"]
[41,"Crawler Mounted Radial Stacker to Conveyor 2 (CMRSC2)",null,30,"Engineering, Manufacturing and Assembly"]
[42,"Crawler Mounted Radial Stacker to Conveyor 2 (CMRSC2)",null,40,"Transportation"]
[43,"Crawler Mounted Radial Stacker to Conveyor 2 (CMRSC2)",null,50,"Construction, Erection, Installation"]
[44,"Crawler Mounted Radial Stacker to Conveyor 2 (CMRSC2)",null,60,"Commissioning & Testing"]
[45,"Crawler Mounted Radial Stacker to Conveyor 2 (CMRSC2)",null,70,"Data Books"]
[46,"Crawler Mounted Radial Stacker to Conveyor 2 (CMRSC2)",null,80,"Other"]
[]
[53,"Transfer House 9",null,10,"Design (Including Simulation and Studies)"]
[54,"Transfer House 9",null,20,"Procurement"]
[55,"Transfer House 9",null,30,"Engineering, Manufacturing and Assembly"]
[56,"Transfer House 9",null,40,"Transportation"]
[57,"Transfer House 9",null,50,"Construction, Erection, Installation"]
[58,"Transfer House 9",null,60,"Commissioning & Testing"]
[59,"Transfer House 9",null,70,"Data Books"]
[{"$nulls":3},80,"Other"]
[]
[60,"KKS Plant  Labeling",null,10,"Design (Including Simulation and Studies)"]
[61,"KKS Plant  Labeling",null,20,"Procurement"]
[62,"KKS Plant  Labeling",null,30,"Engineering, Manufacturing and Assembly"]
[63,"KKS Plant  Labeling",null,40,"Transportation"]
[64,"KKS Plant  Labeling",null,50,"Construction, Erection, Installation"]
[65,"KKS Plant  Labeling",null,60,"Commissioning & Testing"]
[66,"KKS Plant  Labeling",null,70,"Data Books"]
[67,"KKS Plant  Labeling",null,80,"Other"]
[]
[68,"Commissioning",null,10,"Design (Including Simulation and Studies)"]
[69,"Commissioning",null,20,"Procurement"]
[70,"Commissioning",null,30,"Engineering, Manufacturing and Assembly"]
[71,"Commissioning",null,40,"Transportation"]
[72,"Commissioning",null,50,"Construction, Erection, Installation"]
[73,"Commissioning",null,60,"Commissioning & Testing"]
[74,"Commissioning",null,70,"Data Books"]
[75,"Commissioning",null,80,"Other"]
[]
[76,"Perfomance Test",null,10,"Design (Including Simulation and Studies)"]
[77,"Perfomance Test",null,20,"Procurement"]
[78,"Perfomance Test",null,30,"Engineering, Manufacturing and Assembly"]
[79,"Perfomance Test",null,40,"Transportation"]
[80,"Perfomance Test",null,50,"Construction, Erection, Installation"]
[81,"Perfomance Test",null,60,"Commissioning & Testing"]
[82,"Perfomance Test",null,70,"Data Books"]
[83,"Perfomance Test",null,80,"Other"]
[]
[84,"Hazop Study",null,10,"Design (Including Simulation and Studies)"]
[85,"Hazop Study",null,20,"Procurement"]
[86,"Hazop Study",null,30,"Engineering, Manufacturing and Assembly"]
[87,"Hazop Study",null,40,"Transportation"]
[88,"Hazop Study",null,50,"Construction, Erection, Installation"]
[89,"Hazop Study",null,60,"Commissioning & Testing"]
[90,"Hazop Study",null,70,"Data Books"]
[91,"Hazop Study",null,80,"Other"]
[]
[91,"General Activities ",null,10,"Design (Including Simulation and Studies)"]
[92,"General Activities ",null,20,"Procurement"]
[93,"General Activities ",null,30,"Engineering, Manufacturing and Assembly"]
[94,"General Activities ",null,40,"Transportation"]
[95,"General Activities ",null,50,"Construction, Erection, Installation"]
[96,"General Activities ",null,60,"Commissioning & Testing"]
[97,"General Activities ",null,70,"Data Books"]
[98,"General Activities ",null,80,"Other"]
[]
[99,"Operating Manuals",null,10,"Design (Including Simulation and Studies)"]
[100,"Operating Manuals",null,20,"Procurement"]
[101,"Operating Manuals",null,30,"Engineering, Manufacturing and Assembly"]
[102,"Operating Manuals",null,40,"Transportation"]
[103,"Operating Manuals",null,50,"Construction, Erection, Installation"]
[104,"Operating Manuals",null,60,"Commissioning & Testing"]
[105,"Operating Manuals",null,70,"Data Books"]
[106,"Operating Manuals",null,80,"Other"]
[]
[107,"Craneage",null,10,"Design (Including Simulation and Studies)"]
[108,"Craneage",null,20,"Procurement"]
[109,"Craneage",null,30,"Engineering, Manufacturing and Assembly"]
[110,"Craneage",null,40,"Transportation"]
[111,"Craneage",null,50,"Construction, Erection, Installation"]
[112,"Craneage",null,60,"Commissioning & Testing"]
[113,"Craneage",null,70,"Data Books"]
[114,"Craneage",null,80,"Other"]
[]
[115,"Scaffolding",null,10,"Design (Including Simulation and Studies)"]
[116,"Scaffolding",null,20,"Procurement"]
[117,"Scaffolding",null,30,"Engineering, Manufacturing and Assembly"]
[118,"Scaffolding",null,40,"Transportation"]
[119,"Scaffolding",null,50,"Construction, Erection, Installation"]
[120,"Scaffolding",null,60,"Commissioning & Testing"]
[121,"Scaffolding",null,70,"Data Books"]
[122,"Scaffolding",null,80,"Other"]
[]
[123,"RAM Study",null,10,"Design (Including Simulation and Studies)"]
[124,"RAM Study",null,20,"Procurement"]
[125,"RAM Study",null,30,"Engineering, Manufacturing and Assembly"]
[126,"RAM Study",null,40,"Transportation"]
[127,"RAM Study",null,50,"Construction, Erection, Installation"]
[128,"RAM Study",null,60,"Commissioning & Testing"]
[129,"RAM Study",null,70,"Data Books"]
[130,"RAM Study",null,80,"Other"]

{"sheet":"5.1.3 Rate of Exchange","index":8,"n_rows":33,"n_cols":12,"rows_kept":33,"flags":["formulas_cached_only"]}
[{"$nulls":3},"KUSILE POWER STATION PROJECT"]
["ENQUIRY No: ",{"$nulls":3},"PROJECT:"]
["TENDERER NAME:"]
[null,"Notes: "]
[null,1,"For conformity please notify Eskom regarding any currencies to be used and not identified on the attached"]
[null,null,"list prior to enquiry closing in order that the applicable rate is provided by Eskom."]
[null,2,"All information in this table must conform with all other equivalent information in the offer (eg the detail in the"]
[null,null,"PS5 Schedule sheet included in this Excel file)"]
[null,3,"Payment for foreign commitments must be in terms of  CPA (IG) Rev 28 where applicable. Refer Tender Returnables "]
[null,4,"Indicate the currency per row in the Prices but only one currency per row is allowed Exchange rates must"]
[null,null,"be stipulated in the format of Currency 1,00 = ZAR \"value\" and rounded to four decimals. The exchange"]
[null,null,"rates in the tables below must be used to convert foreign currency amounts to Rand"]
[]
[]
[null,"RATE OF EXCHANGE FOR MULTIPLE CURRENCIES",{"$nulls":7},"Source Eskom Treasury",null,"Published:"]
[null,"Summary",{"$nulls":7},"LISTED CURRENCIES (Refer item 1. above)",null,"2008-05-16"]
[null,"No","Currency Description","Code","Exchange Rate Currency 1,00 =","Rand value","Currency value","Payment method 1a, 1b or 2",null,"Currency","Code","RoE Currency 1,00 ="]
[null,1,"South African Rand","ZAR",{"v":0,"d":"ZAR 0.0000"},{"$nulls":4},"South African Rand","ZAR"]
[null,2,"European Currency","EUR",{"v":0,"d":"ZAR 0.0000"},"Example of usage",{"$nulls":3},"Austrialian Dollar","AUD"]
[null,3,"British Pound","GBP",{"v":0,"d":"ZAR 0.0000"},{"$nulls":4},"Canadian Dollar","CAD"]
[null,4,"United States Dollars","USD",{"v":0,"d":"ZAR 0.0000"},{"$nulls":4},"Swiss Franc","CHF"]
[null,5,{"$nulls":7},"Danish Krone","DKK"]
[null,6,{"$nulls":7},"European Currency","EUR"]
[null,7,{"$nulls":7},"British Pound","GBP"]
[null,8,{"$nulls":7},"Japanese Yen","JPY"]
[null,9,{"$nulls":7},"New Zealand Dollar","."]
[null,10,{"$nulls":7},"Norwegian Krone","NOK"]
[null,11,{"$nulls":7},"Swedish Krone","SEK"]
[null,12,{"$nulls":7},"Singapore Dollar","SGD"]
[null,13,{"$nulls":7},"United States Dollars","USD"]
[null,14]
[null,null,"TOTAL RAND VALUE OF ALL CURRENCIES",null,null,{"v":0,"d":"R 0.00"}]
[null,null,"Check that value balances with Summary of tendered values"]

{"sheet":" 5.1.4Price adjustment formulae","index":9,"n_rows":199,"n_cols":49,"rows_kept":199,"merged":[[69,7,69,8],[80,7,80,8],[91,7,91,8],[102,7,102,8],[113,7,113,8],[124,7,124,8],[135,7,135,8],[146,7,146,8],[157,7,157,8],[168,7,168,8],[179,7,179,8],[190,7,190,8]],"flags":["formulas_cached_only"]}
["                                ",null,"KUSILE POWER STATION PROJECT"]
["ENQUIRY No: ",null,null,"PROJECT:"]
["TENDERER NAME:"]
["PRICE ADJUSTMENT FOR INFLATION"]
["Summary"]
["No","Description"]
["A","Description of formula",null,null,"Type in description of formula which is carried through below"]
["B","Description of formula"]
["C","Description of formula"]
["D","Description of formula"]
["E","Description of formula"]
["F","Description of formula"]
["G","Description of formula"]
["H","Description of formula"]
["I","Description of formula"]
["J","Description of formula"]
["K","Description of formula"]
["L","Description of formula"]
["M","Description of formula"]
["N","Description of formula"]
[]
["GENERAL NOTES :"]
["a.","References to \"indices\" below have the meaning of \"cost indices or reference prices\",  unless otherwise stated."]
["b.","Where historical information is applicable as requested below, internet address references which are accessible to the"]
[null,"general public may be submitted instead, with the specific electronic route and web page reflecting the applicable data."]
["c.","Each formula is related to one unique currency. Mixing of currencies in a specific formula is not acceptable."]
["CPA FORMULA REQUIREMENTS :"]
["i.","Formulae must be linked to independent cost indices or other benchmarks (\"reference prices\") and must be clearly and"]
[null,"completely defined. The source must be a recognised statistical publishing source and must not be in-house indices."]
["ii.","Local Indices: Where local indices other than SEIFSA or StatsSA are specified, the tenderer is to submit 5 years' historical data"]
[null,"for such indices.  Note that the Contractor must ensure that indices are published and recommended by the \"Source\" as"]
[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,"or E-EX and the specific sub breakdown of such must be identified. Also SEIFSA recommends utilisation of Table L-2 for road"]
[null,"transport rather than Table L-1.  "]
["iii.","Foreign Price Adjustments: In the case of foreign price adjustments, the Contractor is to submit 5 years' historical data for the"]
[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,"currency of the same country.  A formula may not be linked to indices of more than one country."]
["iv.","Commodity Price Linked Payments: The reference price is considered as the base price (index) for purpose of the CPA formula"]
[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,"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,"the tables below if the price is not in the same currency as the applicable formula.. ie exposure to the movement in a"]
[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,"for such commodity, "]
["v.","London Metal Exchange (LME) Prices: For metals traded on the LME, the tonnage will be required before contract award in"]
[null,"order for Eskom to hedge the metal price fluctuations.  This applies also for prices linked to local indices or reference prices. "]
[null,"Though these metals are traded in US$, prices are daily quoted in various other currencies. "]
[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,"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,"the formulae below, the contractor declares that neither he nor any other body avails or will avail of forward price and/or"]
[null,"currency cover for the metal(s).  "]
["vi.","CPA Base Date: The CPA base date for calculating price movements is the Base Date as defined in the Particular Conditions,"]
[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,"latest date for which it is published before the Base Date will be considered as the Base Date index or reference price.  In"]
[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,"explained herein, the date, figure or value as well as the reason for the deviation must be clearly separately stated and must"]
[null,"be realistic for purposes of the price adjustment. "]
["vii.","Period for Movement in Indices: The period for which the movement in indices or reference prices is considered, is the period"]
[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,"event or activity for which the adjustment applies, took place).  For indices or reference prices published as at certain dates,"]
[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,"event or activity took place),  then latest date for which the indices or price references are published before the last day of the"]
[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,"or reference price of the month prior to execution or completion of work (or event or activity). "]
["viii.","Proportions/weighting/coefficients/base reference in CPA Formulae: The fixed portion of each formula, not subject to inflation,"]
[null,"is at least 15% and contractors may submit higher fixed portion percentages.  The indices or other benchmarks and their"]
[null,"proportions in the formula must be realistic and relative to the applicable work. The fixed portion and other proportions must add"]
[null,"up to 100%."]
["ix.","Base Index or Reference Price :   The base index or reference price must be inserted in the appropriate column"]
["FORMULA No:"]
["A","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["A1"]
["A2"]
["A3"]
["A4"]
["A5"]
["A6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["B","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["B1"]
["B2"]
["B3"]
["B4"]
["B5"]
["B6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["C","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["C1"]
["C2"]
["C3"]
["C4"]
["C5"]
["C6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["D","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["D1"]
["D2"]
["D3"]
["D4"]
["D5"]
["D6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["E","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["E1"]
["E2"]
["E3"]
["E4"]
["E5"]
["E6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["F","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["F1"]
["F2"]
["F3"]
["F4"]
["F5"]
["F6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["G","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["G1"]
["G2"]
["G3"]
["G4"]
["G5"]
["G6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["H","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["H1"]
["H2"]
["H3"]
["H4"]
["H5"]
["H6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["I","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["I1"]
["I2"]
["I3"]
["I4"]
["I5"]
["I6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["J","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["J1"]
["J2"]
["J3"]
["J4"]
["J5"]
["J6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["K","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["K1"]
["K2"]
["K3"]
["K4"]
["K5"]
["K6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]
[]
["FORMULA No:"]
["L","Description of formula",{"$nulls":5},"Exchange rate for converting base reference price (eg US$ LME price) to the currency of this formula",null,null,"Historical index data provided for items not linked to SEIFSA or StatsSA Indices"]
["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)","2003-01-01","2003-02-01","2003-03-01","2003-04-01","2003-05-01","2003-06-01","2003-07-01","2003-08-01","2003-09-01","2003-10-01","2003-11-01","2003-12-01","2004-01-01","2004-02-01","2004-03-01","2004-04-01","2004-05-01","2004-06-01","2004-07-01","2004-08-01","2004-09-01","2004-10-01","2004-11-01","2004-12-01","2005-01-01","2005-02-01","2005-03-01","2005-04-01","2005-05-01","2005-06-01","2005-07-01","2005-08-01","2005-09-01","2005-10-01","2005-11-01","2005-12-01","2006-01-01","2006-02-01","2006-03-01"]
["L1"]
["L2"]
["L3"]
["L4"]
["L5"]
["L6",{"v":0.15,"d":"0.150"},"Fixed Non-adjustable (0.15 minimum)"]
[null,{"v":0.15,"d":"0.150"},"Total"]

{"sheet":"5.1.5  PS5 Schedule","index":10,"n_rows":76,"n_cols":14,"rows_kept":76,"merged":[[9,1,9,2]],"flags":["formulas_cached_only"]}
["                                            ","KISILE POWER STATION PROJECT"]
["ENQUIRY No:",null,"PROJECT:"]
["TENDERER NAME:"]
[]
[null,"1.1.           PS5  Price Schedule - page 1"]
[null,"PRICE SCHEDULE FOR GOODS MANUFACTURED IN AND OUTSIDE THE R.S.A.                                ",{"$nulls":11},"PAGE 1 OF 2"]
[null,"SUPPLY, DELIVERY & ERECTION / INSTALLATION (PS5)                                                                                "]
[null,"ENQUIRY NO: ",null,null,"Total","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6"]
[null,"REMARKS:                                                                       ",null,"ITEM",{"$nulls":7},"Spare"]
["Ref No","   *  ESKOM may effect this insurance,\n      which Includes war risk Insurance \n   ** Please specify",null,"DESCRIPTION","GRAND TOTAL"]
[1,"1.    Ex Works Price (Overseas)"]
[2,"2.    Inland Transport Cost "]
[null,"3.    FOB Price",null,"(= 1+2)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[4,"4.    Cost of seafreight"]
[5,"5.    Cost of airfreight"]
[6,"6.    Cost of Marine Insurance*"]
[null,"7.    Total price delivered port R.S.A.",null,"(= 3+4+5+6)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[8,"8.    Wharfage"]
[9,"9.    Landing charges"]
[10,"10.  Customs duties"]
[11,"11.  Surcharge"]
[null,"12   Cost of Importation",null,"(= 8+9+10+11)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[13,"13.   Other ** ",null,"(= 13)"]
[14,"14.  Cost of Rail transport In R.S.A."]
[15,"15.  Cost of Road transport In R.S.A."]
[null,"16.  Cost of transport works to site",null,"(=14+15)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"17.  Price (FOB) delivered to works/site",null,"(= 7+12+13+16)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"Supplied from Inside R.S.A."]
[18,"18.  F.O.R. Price-Goods manufactured Inside R.S.A."]
[19,"19.  F.O.R. Price-Goods supplied from Imported Items"]
[null,"20.  Total F.O.R. price",null,"(=18+19)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[21,"21.  Cost of Rail transport"]
[22,"22.  Cost of Road transport"]
[null,"23.  Cost of transport works to site",null,"(=21+22)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"24.  Price (F.O.R.) delivered to site",null,"(=20+23)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"Site work (Erection/Installation)"]
[25,"25.  Local labour"]
[26,"26.  Expatriate labour"]
[null,"27.  Total price for site work",null,"(= 25+26)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[28,"28.  Overseas Engineering Service"]
[29,"29.  Local Engineering Service/Design"]
[null,"30.  Total price for Engineering Service",null,"(= 28+29)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"30.1.  Total price delivered to site before VAT",null,"(=17+24+27+30)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"31.  VAT"]
[null,"32.  Total price delivered to site including VAT",null,null,{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"",null,null,"","","","","",null,""]
[null,"1.2.      PS5  Price Schedule - page 2     "]
[null,"PRICE SCHEDULE FOR GOODS MANUFACTURED IN AND OUTSIDE THE R.S.A.                                ",{"$nulls":11},"PAGE 2 OF 2"]
[null,"SUPPLY, DELIVERY & ERECTION / INSTALLATION (PS5)                                                                                "]
[null,"ENQUIRY NO:",null,"ITEM NO.",{"v":0,"d":"000"},100,200,300,400,500,600,"Spare",0,0]
[null,"REMARKS:",null,"DESCRIPTION","GRAND TOTAL",0,0,0,0,0,0,0,0,0]
[null,"CIF Price"]
[null,"33.    Currency           A:  1  ZAR  =",null,"(FOB)"]
[null,"34.    Currency           B:  1  ZAR  =",null,"(FOB)"]
[null,"35.    Currency           C:  1  ZAR  =",null,"(FOB)"]
[null,"36.     Currency          D:  1  ZAR  =",null,"(Freight)"]
[null,"37.     Currency          E:  1  ZAR  =",null," (Ins)"]
[null,"38.    Total CIF price",null,"(7 = 33+34+35+36+37)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"Price Expatriate Labour (Line 26)"]
[null,"39.    Currency           A:  1  ZAR  ="]
[null,"40.    Currency           B:  1  ZAR  ="]
[null,"41.     Currency           C:  1  ZAR  ="]
[null,"42.     Currency          D:  1  ZAR  ="]
[null,"43.     Currency          E:  1  ZAR  ="]
[null,"44. Total Price Expatriate Labour",null,"(26 = 39+40+41+42+43)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"Price Overseas Engineering Services (Line 28)"]
[null,"45.    Currency           A:  1  ZAR  ="]
[null,"46.     Currency          B:  1  ZAR  ="]
[null,"47.     Currency          C:  1  ZAR  ="]
[null,"48.     Currency          D:  1  ZAR  ="]
[null,"49.     Currency          E:  1  ZAR  ="]
[null,"50.  Total Price O/seas Engineering Services",null,"(28 = 45+46+47+48+49)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[null,"51.    Foreign content of total price",null,"(38+44+50)",{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"},{"v":0,"d":"R 0.00"}]
[]
[]
[null,"SIGNATURE:",null,null,"CAPACITY:",{"$nulls":7},"DATE:"]

{"sheet":" 5.1.6 LME","index":11,"n_rows":27,"n_cols":5,"rows_kept":27,"flags":["formulas_cached_only"]}
["                   ","KUSILE POWER STATION PROJECT"]
["ENQUIRY No: ",{"$nulls":3},"PROJECT:"]
["TENDERER NAME:"]
[]
["Commodities Traded on the London Metal Exchange (LME)"]
[]
["Notes  :"]
[1,"The metals listed are traded in US Dollar.  If the Dollar prices are converted to other currencies,"]
[null,"including South African Rand, the exchange rates must be indicated in the CPA sheet.  "]
[2,"Under normal instances Eskom hedges its exposure to price movements even in instances where"]
[null,"the local portion of contract prices are subject to fluctuations in local indices, e.g. SEIFSA Table F"]
[null,"(for copper, zinc and lead), Table R (for aluminium), etc.  In such instances the exchange rates are"]
[null,"not required.  The tonnage needs to be stipulated as per Note v. in the CPA Sheet of this Excel file"]
[null,"before contract award."]
[3,"The reference to aluminium must be clearly stipulated in the CPA Sheet, ie \"Aluminium\" or "]
[null,"\"Aluminium Alloy\".  Furthermore, Eskom can only accept Aluminium Alloy (instead of Aluminium) if"]
[null,"the material consists of aluminium alloy, otherwise Eskom accepts only the Aluminium LME prices"]
[null,"as adjustment benchmark"]
[]
[null,"The LME metals are :"]
[null,"- Copper"]
[null,"- Aluminium (Primary or First Grade)"]
[null,"- Aluminium Alloy "]
[null,"- Lead"]
[null,"- Zinc"]
[null,"- Nickel"]
[null,"- Tin"]

{"sheet":"5.1.7 Spares Activity Schedule","index":12,"n_rows":405,"n_cols":47,"rows_kept":405,"merged":[[13,15,13,17],[13,24,13,26],[13,36,13,38]],"flags":["formulas_cached_only"]}
[null,null,"POWER STATION PROJECT",{"$nulls":7},"Code","Exchange Rate Currency 1,00 ="]
["ENQUIRY No: ",null,null,"PROJECT:",null,"No","Cost allocation (Payment Milestones)",null,"A-Description of formula","Foreign","ZAR",{"v":1,"d":"R 1.000000"}]
["TENDERER NAME:",null,null,"SPARES ",null,{"v":0,"d":"00"},"Total",null,"B-Description of formula","Local","EUR",{"v":12.4188,"d":"R 12.4188"}]
[{"$nulls":5},10,"Design",null,"C-Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["NOTES:",{"$nulls":4},20,"Procurement",null,"D-Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["The detail activity cashflow is summarised with unique currency and price adjustment",{"$nulls":4},30,"Engineering, manufacture and assembly",null,"E-Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["identification per row and any freight, insurances and importation costs are separately",{"$nulls":4},40,"Transport",null,"F-Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["identified",{"$nulls":4},50,"Construction, Erection, Installation",null,"G-Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["The PS5 breakdown is indicated in the schedule and is summarised in the PS5 Schedule sheet",{"$nulls":7},"H-Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["The activity items detailed are the minimum required by the Employer. The tenderer provides",{"$nulls":4},"Spares are detailed in this sheet",null,null,"I-Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["detailed activity breakdown in accordance with the programme and cashflow requirements in",{"$nulls":7},"J-Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["terms of the contract",{"$nulls":7},"K-Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["Tenderer to check and take responsibility for all descriptions, formulae, etc",{"$nulls":7},"L-Description of formula",null,0,{"v":0,"d":"R 0.0000"}]
["The Tenderer can add rows as required to cater for specific requirements but is to adhere to",{"$nulls":7},"-",null,0,{"v":0,"d":"R 0.0000"},{"$nulls":3},"ENQUIRY No: CED0055/SN",{"$nulls":8},"ENQUIRY No: CED0055/SN",{"$nulls":11},"ENQUIRY No: CED0055/SN"]
["the basic requirements identified above.",{"$nulls":7},"-",null,0,{"v":0,"d":"R 0.0000"}]
["A sub-description column is provided or may be added for additional detail descriptions if required",{"$nulls":14},"FORECAST RATE OF PAYMENT",null,null,"YEAR 2008",{"$nulls":5},"FORECAST RATE OF PAYMENT",{"$nulls":3},"YEAR 2009",{"$nulls":7},"FORECAST RATE OF PAYMENT",{"$nulls":3},"YEAR 2010"]
["Ensure clear Indicatation whether offer is main or alternative tender",{"$nulls":7},"Price cost allocation - Note Unique currencies and CPA formula per line must be compiled",{"$nulls":6},"Certification date",{"$nulls":8},"Certification date",{"$nulls":11},"Certification date"]
[{"$nulls":8},"with ie only one currency with one associated CPA formula",{"$nulls":6},"2008-05-25","2008-06-25","2008-07-25","2008-08-25","2008-09-25","2008-10-25","2008-11-25","2008-12-25","2009-01-25","2009-02-25","2009-03-25","2009-04-25","2009-05-25","2009-06-25","2009-07-25","2009-08-25","2009-09-25","2009-10-25","2009-11-25","2009-12-25","2010-01-25","2010-02-25","2010-03-25","2010-04-25","2010-05-25","2010-06-25","2010-07-25","2010-08-25","2010-09-25","2010-10-25","2010-11-25","2010-12-25"]
[{"$nulls":8},"Price adjustment","Rate of exchange Data",{"$nulls":3},"ACTIVITY","ACTIVITY","Payment Month:",{"$nulls":8},"Payment Month:",{"$nulls":11},"Payment Month:"]
["Ref","Section ID","Section Description","Act ID","Spares Description","No","Cost allocation ","Payment method 1a, 1b or 2","FORMULA NOs","Foreign / Local","Currency Type","RoE Currency 1,00 = R","Total Cost in ZAR","START  DATE","COMPLETION DATE","2008-06-01","2008-07-01","2008-08-01","2008-09-01","2008-10-01","2008-11-01","2008-12-01","2009-01-01","2009-02-01","2009-03-01","2009-04-01","2009-05-01","2009-06-01","2009-07-01","2009-08-01","2009-09-01","2009-10-01","2009-11-01","2009-12-01","2010-01-01","2010-02-01","2010-03-01","2010-04-01","2010-05-01","2010-06-01","2010-07-01","2010-08-01","2010-09-01","2010-10-01","2010-11-01","2010-12-01","2011-01-01"]
[1,{"$nulls":4},90,"Spares"]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]
[101]
[102]
[103]
[104]
[105]
[106]
[107]
[108]
[109]
[110]
[111]
[112]
[113]
[114]
[115]
[116]
[117]
[118]
[119]
[120]
[121]
[122]
[123]
[124]
[125]
[126]
[127]
[128]
[129]
[130]
[131]
[132]
[133]
[134]
[135]
[136]
[137]
[138]
[139]
[140]
[141]
[142]
[143]
[144]
[145]
[146]
[147]
[148]
[149]
[150]
[151]
[152]
[153]
[154]
[155]
[156]
[157]
[158]
[159]
[160]
[161]
[162]
[163]
[164]
[165]
[166]
[167]
[168]
[169]
[170]
[171]
[172]
[173]
[174]
[175]
[176]
[177]
[178]
[179]
[180]
[181]
[182]
[183]
[184]
[185]
[186]
[187]
[188]
[189]
[190]
[191]
[192]
[193]
[194]
[195]
[196]
[197]
[198]
[199]
[200]
[201]
[202]
[203]
[204]
[205]
[206]
[207]
[208]
[209]
[210]
[211]
[212]
[213]
[214]
[215]
[216]
[217]
[218]
[219]
[220]
[221]
[222]
[223]
[224]
[225]
[226]
[227]
[228]
[229]
[230]
[231]
[232]
[233]
[234]
[235]
[236]
[237]
[238]
[239]
[240]
[241]
[242]
[243]
[244]
[245]
[246]
[247]
[248]
[249]
[250]
[251]
[252]
[253]
[254]
[255]
[256]
[257]
[258]
[259]
[260]
[261]
[262]
[263]
[264]
[265]
[266]
[267]
[268]
[269]
[270]
[271]
[272]
[273]
[274]
[275]
[276]
[277]
[278]
[279]
[280]
[281]
[282]
[283]
[284]
[285]
[286]
[287]
[288]
[289]
[290]
[291]
[292]
[293]
[294]
[295]
[296]
[297]
[298]
[299]
[300]
[301]
[302]
[303]
[304]
[305]
[306]
[307]
[308]
[309]
[310]
[311]
[312]
[313]
[314]
[315]
[316]
[317]
[318]
[319]
[320]
[321]
[322]
[323]
[324]
[325]
[326]
[327]
[328]
[329]
[330]
[331]
[332]
[333]
[334]
[335]
[336]
[337]
[338]
[339]
[340]
[341]
[342]
[343]
[344]
[345]
[346]
[347]
[348]
[349]
[350]
[351]
[352]
[353]
[354]
[355]
[356]
[357]
[358]
[359]
[360]
[361]
[362]
[363]
[364]
[365]
[366]
[367]
[368]
[369]
[370]
[371]
[372]
[373]
[374]
[375]
[376]
[377]
[378]
[379]
[380]
[381]
[382]
[383]
[384]
[385]

{"sheet":"5.1.8 Life Cycle costing","index":13,"n_rows":16,"n_cols":13,"rows_kept":16,"flags":["formulas_cached_only"]}
["                                                POWER STATION PROJECT"]
["ENQUIRY No: "]
["TENDERER NAME:","NB:   INFO ON LIFECYCLE COST TO BE FINALISED"]
["PROJECT:"]
["INFORMATION FOR LIFECYCLE COSTING"]
["Contractor to provide required information in table",null,null,"BASE DATA",{"$nulls":6},"FORECAST RATE OF PAYMENT"]
[null,null,"Ref No","Unit 1","Unit 2","Unit 3","Unit 4","Unit 5","Unit 6","Spares",2022,2023,2024]
["Data for lifecycle costing determination"]
["Description"]
["Capital cost ","C"]
["Maintenance component","mc"]
["Interest rate","i","Employer"]
["Year( from date of asset acquisition) in which sum of money is spent (e.g 7 for year 7)","n "]
["Present Value of a future sum of money","P ","Calculation"]
["Where:"]
[" Life Cycle Cost formula:"]