{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Tender Cover Sheet"," 5.1.0 Preamble","Pricing Instruction ","Tender Cover Sheet ","5.1.0 Summary","5.1.1 Pricing schedule","5.1.2 CPA Formulae ","5.1.3  Exchange Rates"],"not_rendered":{"images":1,"external_links":8,"defined_names":360},"read":"whole","date_system":"1900"}

{"sheet":"Tender Cover Sheet","index":0,"n_rows":35,"n_cols":4,"rows_kept":35,"hidden":true}
[]
[null,"Enquiry No."]
[null,"Package Name:"]
[null,"Tenderer's Name:",{"$f":"'[8]Read Me'!D4","v":0}]
[]
[]
[]
[]
[]
[]
[null,"PRICING INFORMATION"]
[]
[null,"RAND VALUE IN WORDS","[Price in Words]"," "]
[]
[]
[null,"TENDERED PRICE:  IN ZAR"]
[null,"(excluding VAT)"]
[]
[null,"TENDERED PRICE:  IN ZAR"]
[null,"(including VAT)"]
[]
[]
[]
[null,"DATE :"," "]
[]
[null,"FULL NAMES OF SIGNATORY:"," "]
[]
[]
[]
[null,"DESIGNATION OF SIGNATORY:"," "]
[]
[]
[]
[null,"SIGNATURE :"]
[{"$nulls":3}," "]

{"sheet":" 5.1.0 Preamble","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"hidden":true,"merged":[[5,1,5,10],[7,2,7,11],[8,2,8,11],[9,2,9,11],[10,2,10,11],[11,2,11,11],[12,2,12,11],[13,2,13,11],[14,2,14,11],[15,2,15,11]]}
[]
[null,"Enquiry No."]
[null,"Package Name:"]
[null,"Tenderer's Name:",null,{"$f":"'[8]Read Me'!D4","v":0}]
[]
[null,"ALL THE PRICES TO BE PRICED AS PER DETAILED SCOPE OF WORK AND COMPLIANT TO THE BASIC CONTRACTUAL REQUIREMENT DOCUMENTS"]
[null,"PREAMBLE TO PRICE SCHEDULE "]
[null,1,"The Price Schedule provides the basis of valuation and information for general contract progress monitoring. "]
[null,{"$f":"B8+1","v":2},"The Prices are the amounts stated in the unit column of the Price Schedule in section A,B and C.  Where an estimated quantity is stated for an item in the Price Schedule, the Price is calculated by multiplying the estimated quantity by the unit rate."]
[null,{"$f":"B9+1","v":3},"If the Supplier has decided not to identify a particular item in the price schedule at the time of tender the cost to the Supplier of doing the work is assumed to be included in, or spread across, the other Prices and rates in the price schedule in order to fulfil the obligation to Provide the Goods and Services for the tendered total of the Prices.  "]
[null,4,"The total of the prices must include for all direct and indirect costs, overheads, profit on costs, risks, liabilities, obligations, etc. relative to the contract."]
[null,5,"The Tenderer must allow for all necessary costs to complete the pricing shedule as required in terms of the specifications, technical scope and conditions of contract whether expressly stated or not in the Price Schedules. The Tenderer must provide any breakdown of prices as may be required for specific items not detailed in the Price Schedule prior to or after contract award."]
[null,6,"All worksheets in this Pricing Schedule are to be submitted. "]
[null,7,"The Tenderer must check and take responsibility for all descriptions, formulae, etc."]
[null,8,"Prices to exclude VAT. "]
[null,9,"Quantities are estimated and non-committal."]

{"sheet":"Pricing Instruction ","index":2,"n_rows":21,"n_cols":4,"rows_kept":21,"merged":[[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,1,16,1],[11,2,11,3],[17,1,20,1]]}
[]
[null,null,"Enquiry No."]
[null,null,"Package Name:"]
[null,null,"Tenderer's Name:"]
[]
[]
[]
[null,"PRICING INSRUCTION"]
[null,1,"Read these notes BEFORE you commence input or make any changes to this workbook."]
[null,2,"There must be a separate Excel and PDF file for the pricing schedule. The tenderer may not delete any columns or rows on the pricing schedule."]
[null,3,"NOTE:  ALL CALCULATIONS ARE THE RESPONSIBILITY OF THE TENDERER, AND MUST BE CHECKED THOROUGHLY.  ANY DISCREPANCY FOUND IN THE CALCULATIONS IN THIS WORKBOOK MUST BE BROUGHT TO THE ATTENTION OF ESKOM, THROUGH THE DESIGNATED BUYER!"]
[null,4,"This workbook contains the following sheets:"]
[null,null,"Tender Cover Sheet ","The cover sheet provides the total tendered price which is mandatory be completed. (Only Light Green areas are to be completed by Tenderer)"]
[null,null,"5.1.0 SUMMARY"]
[null,null,"5.1.1 PRICING","These are the main data entry sheet for the Tenderer to complete. The Tenderer takes responsibility for ensuring correct inputs.The overview will make it easy to understand the document and comments are to be made on this tab.(Only Light Green areas are to be completed by Tenderer)"]
[null,null,"5.1.2 CPA Formulae","This sheet must be completed by the Tenderer for the proposed contract price adjustment (CPA) formulae, (where applicable) and will be carried forward to worksheet (5.1.1 Pricing). Details of the CPA Formulae to be determined in accordance with the CPA conditions with reference to the NOTES. The Tenderer must clearly identify the requirements for the main offer.  If the CPA Formulae are not inputted, in worksheet 5.1.2 CPA formulae, the tendered prices will be deemed \"Fixed and Firm\" for the duration of the contract. "]
[null,null,"5.1.3 Exchange Rates","This sheet is provided for rates of exchange details"]
[null,5,"Conventions used in this workbook:"]
[{"$nulls":3},"Only Light Green highlighted cells are to be used by the Tenderer for input."]
[{"$nulls":3},"Formulae based and It is the tenderer's responsibility to make sure they tie up."]
[{"$nulls":3},"Formulae based for Totals and It is the tenderer's responsibility to make sure they tie up."]

{"sheet":"Tender Cover Sheet ","index":3,"n_rows":35,"n_cols":4,"rows_kept":35}
[]
[null,"Enquiry No."]
[null,"Package Name:"]
[null,"Tenderer's Name:",{"$f":"'[1]Read Me'!D4","v":0}]
[]
[]
[]
[]
[]
[]
[null,"PRICING INFORMATION"]
[]
[null,"RAND VALUE IN WORDS","[Price in Words]"," "]
[]
[]
[null,"TENDERED PRICE:  IN ZAR"]
[null,"(excluding VAT)"]
[]
[null,"TENDERED PRICE:  IN ZAR"]
[null,"(including VAT)"]
[]
[]
[]
[null,"DATE :"," "]
[]
[null,"FULL NAMES OF SIGNATORY:"," "]
[]
[]
[]
[null,"DESIGNATION OF SIGNATORY:"," "]
[]
[]
[]
[null,"SIGNATURE :"]
[{"$nulls":3}," "]

{"sheet":"5.1.0 Summary","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"merged":[[1,3,1,5],[2,3,2,5],[3,3,3,5],[5,1,5,3],[5,4,5,6],[6,1,7,1],[6,2,7,2],[13,1,13,2],[14,4,14,5],[15,4,15,5],[16,1,16,6]]}
[]
[null,null,"Enquiry No."]
[null,null,"Package Name:"]
[null,null,"Tenderer's Name:",{"$f":"'[8]Read Me'!D4","v":0}]
[]
[null,"SUMMARY",null,null,"All prices in ZAR"]
[null,"Item No."," Description","Total Foreign Currency","Total Converted Foreign Currency","Local","Total Tendered Value "]
[{"$nulls":3},"FC","ZAR","ZAR","ZAR"]
[null,1,{"$f":"'5.1.1 Pricing schedule'!C9","v":"PERSONNEL REQUIRED"},{"$nulls":3},{"$f":"E9+F9","v":{"v":0,"d":"R0.00"}}]
[null,2,"RETURNABLES",{"$nulls":3},{"$f":"E10+F10","v":{"v":0,"d":"R0.00"}}]
[null,3,"TRAVELING AND ACCOMODATION",{"$nulls":3},{"v":0,"d":"R0.00"}]
[null,4,{"$f":"'5.1.1 Pricing schedule'!C33","v":"TOOLS AND MATERIAL"},{"$nulls":3},{"v":0,"d":"R0.00"}]
[null,5,{"$f":"'5.1.1 Pricing schedule'!C40","v":"TRAINING"},{"$nulls":3},{"v":0,"d":"R0.00"}]
[null,"Sub-Total",null,{"$f":"SUM(D9:D13)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(E9:E13)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(F9:F13)","v":{"v":0,"d":"R0.00"}},{"$f":"SUM(G9:G13)","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Excl VAT",null,{"$f":"G14*0.15","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":4},"Total Incl VAT@ 15% ",null,{"$f":"G15+G14","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.1 Pricing schedule","index":5,"n_rows":138,"n_cols":13,"rows_kept":138,"merged":[[2,3,2,4],[3,3,3,4],[4,1,4,4],[4,5,4,9],[4,10,4,11],[5,1,6,1],[5,2,6,2],[5,3,6,3],[5,4,6,4],[41,2,41,4]]}
[]
[]
[]
[]
[null,"ISO 5501 GAP ASSESSMENT PRICING SCHEDULE",{"$nulls":3},"FOREIGN CURRENCY",{"$nulls":4},"LOCAL CURRENCY",null,"LOCAL + FOREIGN"]
[null,"ITEM NO.","DESCRIPTION","UNIT","QTY","Currency code","ROE Currency ","Unit Rate","Total Foreign Price","Total Converted Price ","Unit Rate","Total Local Price ","Total Price Excl. VAT"]
[{"$nulls":5}," Ref:Sheet 5.1.3","1,00 = ZAR","FC","FC","ZAR","ZAR","ZAR","ZAR"]
[null,null," ESTIMATED QUANTITIES (36 months)"]
[null,1,"PERSONNEL REQUIRED"]
[null,null,"Asset Management Expert 20 years or more","Hrs",1952]
[null,null,"Asset Management Professional Experience  10 - 20 years ","Hrs",1952]
[null,null,"Asset Management Practitioner 5 - 9 years ","Hrs",1952]
[{"$nulls":12},{"$f":"SUM(M10:M12)","v":{"v":0,"d":"R 0.00"}}]
[null,2,"RETURNABLES"]
[null,null,"Detailed gap assessment report with all the requirements outlined in the clauses of ISO55001","No",1]
[null,null,"Revise and update Asset Management Policy artifacts aligning with the requirements of ISO55001 ","No",1]
[null,null,"Revise and update Strategic Asset Management Plan artifacts aligning with the requirements of ISO55001","No",1]
[null,null,"Revise and update Asset Management Plan for Transformers artifacts aligning with the requirements of ISO55001 ","No",1]
[null,null,"Revise and update Asset Management Plan for Power Lines artifacts aligning with the requirements of ISO55001 ","No",1]
[null,null,"Revise and update Asset Management Plan for Protection Systems artifacts aligning with the requirements of ISO55001 ","No",1]
[null,null,"Revise and update Asset Management Plan for Circuit Breakers artifacts aligning with the requirements of ISO55001 ","No",1]
[null,null,"Revise and update   Asset Management Plan for Refurbishment artifacts aligning with the requirements of ISO55001 ","No",1]
[null,null,"Supply asset management artifacts templates (AM policy,SAMP,AMP’S and other relevant templates) that are aligned with the requirements of ISO55001.","No",5]
[null,null,"Compile a change management plan for transmission to assist with the adoption of ISO55001 requirements","No",1]
[{"$nulls":12},{"$f":"SUM(M15:M24)","v":{"v":0,"d":"R 0.00"}}]
[null,3,"TRAVELING AND ACCOMODATION"]
[null,null,"Hotel Accomodation [ 3 Star], including dinner, breakfast & parking","No",31]
[null,null,"Air Travel [Economy Class]","No",12]
[null,null,"Meals Supported by invoices and receipts","No"]
[null,null,"Car Hire [Class A/B]","Days",31]
[null,null,"Travel Expenses based on Eskom rate of R3.18/km. Supported by trip sheet.","Kilos",10000]
[{"$nulls":12},{"$f":"SUM(M27:M30)","v":{"v":0,"d":"R 0.00"}}]
[null,4,"TOOLS AND MATERIAL"]
[null,null,"Learner guides/books, (Soft copy per course)\n","No",3]
[null,null,"Certificate  ","No",95]
[null,null,"Facilitator guides (Soft copy per course)","No",3]
[null,null,"Presentations (Soft copy per course)","No",3]
[null,null,"Evaluation Material (Soft copy per course)","No",3]
[{"$nulls":12},{"$f":"SUM(M34:M37)","v":{"v":0,"d":"R 0.00"}}]
[null,5,"TRAINING"]
[null,null,"Course attendance cost per head (As per the Minimum nr of attendees per training intervention on Annexure A)","No",95]
[null,null,"TOTAL "]
{"$rows_empty":95}
[{"$nulls":7},"['''''''''''''''''''''''''''''''''''''''"]

{"sheet":"5.1.2 CPA Formulae ","index":6,"n_rows":57,"n_cols":8,"rows_kept":57,"merged":[[1,3,1,5],[2,3,2,5],[3,3,3,5],[9,3,9,4],[9,6,9,7],[10,3,10,5],[10,6,16,7],[11,3,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[19,2,19,7],[20,2,20,7],[23,2,23,7],[24,2,24,7],[25,2,25,7],[27,1,27,7],[28,2,28,7],[29,2,29,7],[30,2,30,7],[31,2,31,7],[32,2,32,7],[33,2,33,7],[34,2,34,7],[35,2,35,7],[37,2,37,7],[48,2,48,7]]}
[]
[null,null,"Enquiry No."]
[null,null,"Package Name:"]
[null,null,"Tenderer's Name:",{"$f":"'[8]Read Me'!D4","v":0}]
[]
[]
[]
[null," CONTRACT PRICE ADJUSTMENT (CPA) FOR INFLATION"]
[null,"Item No","Formula Code","Summary of the description of the Tenderer's Formulae"]
[null,null,"Fixed & Firm",{"$nulls":3},"Prices are 100 % fixed and firm. CPA is not applicable. Note( Cell B9 must be a blank cell)."]
[null,1,"A",{"$nulls":3},"Type in the description of each formula in the tables below"]
[null,2,"B"]
[null,3,"C"]
[null,4,"D"]
[null,5,"E"]
[null,6,"Ex -Local","Example of Local CPA description for Transformer"]
[null,7,"Ex -Foreign","Example of  Foreign CPA description for Transformer"]
[]
[null,"SPECIFIC REQUIREMENTS"]
[null,{"v":1,"d":"1."},"For the Main offer tenderers are to fully comply with the requirements in the General Notes and CPA Formulae Notes below."]
[null,{"v":2,"d":"2."},"Deviations from the Notes below are to be included in a separate ALTERNATIVE offer."]
[]
[null,"GENERAL NOTES :"]
[null,1,"References to \"indices\" below mean \"cost indices or reference prices\"."]
[null,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."]
[null,3,"Each formula is related to  a ZAR currency."]
[]
[null,"CPA FORMULA NOTES :"]
[null,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%.   "]
[null,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."]
[null,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. "]
[null,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.  "]
[null,5,"Base Date Index :   The base index or reference price must be inserted in the appropriate column."]
[null,6,"Foreign Price Adjustments: In the case of foreign price adjustments, the Tenderer is to submit 5 years' historical data for the tendered indices.  Where a formula is linked to indices in a country, payment of the amounts for that formula must be in the currency of the same country.  A formula may not be linked to indices of more than one country."]
[null,7,"Commodity Price Linked Payments: The reference price is considered as the base price (index) for purpose of the CPA formula and is included in the applicable tables below and must be in the currency in which the CPA will be payable.  The exchange rate applied to convert the base price in a foreign currency into that of the currency of the formula must also be indicated in the tables below if the price is not in the same currency as the applicable formula.. ie exposure to the movement in a reference price is in the same currency as that of the CPA formula.  The Tenderer is to submit 5 years' historical price data for such commodity."]
[null,8,"London Metal Exchange (LME) Prices: For metals traded on the LME, the tonnage will be required before contract award in order for Eskom to hedge the metal price fluctuations.  This applies also for prices linked to local indices or reference prices. Though these metals are traded in US$, prices are daily quoted in various other currencies. The LME price in the currency of the formula must apply and thus not the US$ unless the amount payable in terms of the formula is US$.  Refer to the \"LME\" Sheet in this file for more detail regarding this aspect.  By indicating any of these metals in the formulae below, the Tenderer declares that neither he nor any other body avails or will avail of forward price and/or currency cover for the metal(s).  "]
[null," "," "]
[null,"Formula Ex Local","Tenderer's description of Formula EX Local"]
[null,"Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Full title/definition of index Table as per publisher","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)"]
[null,"J1",{"v":0.85,"d":"85%"},"Labour","C3- All hourly-paid employees","SEIFSA","2018-01-01"]
[null,"J2"]
[null,"J3"]
[null,"J4"]
[null,"J5"," "]
[null,"J6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C40:C45)","v":{"v":1,"d":"100%"}},"Total"]
[]
[]
[null,"Formula Ex Foreign","Tenderer's description of Formula EX Foreign"]
[null,"Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Full title/definition of index as per publisher","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)"]
[null,"J1",{"v":0.85,"d":"85%"},"Labour","Large Power Transformer","BEMA","2018-01-01"]
[null,"J2"," "]
[null,"J3"," "]
[null,"J4"," "]
[null,"J5"," "]
[null,"J6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C51:C56)","v":{"v":1,"d":"100%"}},"Total"]

{"sheet":"5.1.3  Exchange Rates","index":7,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[1,3,1,6],[2,3,2,6],[3,3,3,6],[9,1,11,1],[9,2,9,9],[9,15,9,20],[10,2,10,9],[11,2,11,9],[12,2,12,9],[13,2,13,9],[14,1,16,1],[14,2,14,9],[15,2,15,9],[16,2,16,9],[20,1,20,9]]}
[]
[null,null,"Enquiry No."]
[null,null,"Package Name:"]
[null,null,"Tenderer's Name:",{"$f":"'[8]Read Me'!D4","v":0}]
[]
[]
[null,"5.1.2 EXCHANGE RATES FOR MULTIPLE CURRENCIES"]
[null," "]
[null,"NOTES:"]
[null,1,"The following URL (electronic route) is to be followed to access the relevant SARB rates on their web pages:\n"]
[null,null,"www.resbank.co.za"]
[null,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"]
[null,2,"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"]
[null,{"$f":"B13+1","v":3},"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"]
[null,4,"All information in the table below must conform with all other equivalent information in the offer. "]
[null,null,"Payment in terms of Payment Method 2  is considered as a \"foreign payment\" although it will be effected in South African Rand. However, amounts for  \"F.O.R. Price-Goods supplied from Imported Items\", are NOT considered as \"foreign payments\""]
[null,null,"If more than one payment method apply for a currency, the Tenderer must an additional row be inserted in the table in order to split the values and identify the relevant method.   "]
[null," "]
[null,"EXCHANGE RATES PUBLISHED BY SARB"]
[null,"NB: Tenderers must submit proof of the SARB rate (s) of exchange used."]
[null,"MULTIPLE CURRENCIES"]
[null,"No","Currency Description","Code","Exchange Rate\nCurrency 1,00 = R Amount","Amount in Foreign Currency","Amount in Rand","Payment Method 1a, 1b, 2 or Fixed Rand","Date Published","Source"]
[null,1,"Australian Dollar","AUD",0]
[null,{"$f":"B23+1","v":2},"Canadian Dollar","CAN",0]
[null,{"$f":"B24+1","v":3},"Swiss Franc","CHF",0]
[null,{"$f":"B25+1","v":4},"Danish Krone","DKK",0]
[null,5,"European Currency","EUR",0]
[null,6,"British Pound","GBP",0]
[null,7,"Hong Kong Dollar","HKD",0]
[null,8,"Japanese Yen","JPY",0]
[null,9,"Norwegian Krone","NOK",0]
[null,10,"New Zealand Dollar","NZD",0]
[null,11,"Swedish Krone","SEK",0]
[null,12,"Singapore Dollar","SGD",0]
[null,13,"United States Dollar","USD",0]
[null,14,"South African Rand","ZAR",0]
[null,15,"Example Purposes European Currency  (EURO for this example)","EURO",14.22,{"$f":"SUM(F24:F36)","v":0}," "]
[null,null,"TOTAL RAND  -  MUST AGREE WITH TOTAL PRICE EXCLUDING VAT",{"$nulls":3},{"$f":"SUM(G23:G37)","v":{"v":0,"d":"R 0.00"}}," "]