{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Read Me","Tender Cover Sheet"," Preamble","5.1.1 Price Schedule","5.1.3 Exchange Rates"],"not_rendered":{"images":1,"external_links":2,"defined_names":41},"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"merged":[[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[15,8,15,15],[16,8,16,15]]}
["Enquiry No."]
["Package Name:",null,{"$f":"'Tender Cover Sheet'!C14","v":"Supply, delivery and off-loading of caustic soda to various power stations for period of up to four months / ending 29 February 2024 as a back-up on an as and when required basis "}]
["Tenderer's Name:"]
["Category of Offer :",null,"Main Offer"]
[]
["READ ME"]
[]
[1,"Read these notes BEFORE you commence input  to this workbook. Changes may not be made to this workbook. No columns may be removed, edited, added or changed on this workbook. Cells C1-C4 only need to be inputted once, in this \"Read Me Sheet\"."]
[2,"Only The Main Offer shall be accepted. No alternative offers are accepted. "]
[3,"Main offer is = The pricing schedule may not be changed or altered. Tenderer(s) to populate  first, all required information on the Tender cover sheet - where applicable and also populate as stipulated in (5.1.1 Pricing Schedule and 5.1.3 Exchange Rates). "]
[4,"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!"]
[]
[]
[5,"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 Schedule.  It will not form part of the tender or contract. The tender will be awarded wholly to one tenderer for this price list and will not split amongst tenderers. This contract is an \"as and when\" required contract. The units herein are estimates only and are non-committal."]
[null,"Tender Cover Sheet","This is the cover sheet for Worksheets 5.1.1 to 5.1.3 and provides the total tendered price which is mandatory to be completed. It is also the source of the package name, tenderer name etc. for the other worksheets. It will form part of the tender or contract. All worksheets are compulsory tender returnables as they are loaded onto the Eskom Tender Bulletin and they may not be changed or altered."]
[null,"5.1.0 Preamble","This sheet provides general guidelines for this section."]
[null,"5.1.1 Pricing","This is the main data entry sheet for the Tenderer to complete. The Tenderer takes responsibility for ensuring correct inputs. Tenderers are to populate their pricing information as stipulated in the pricing schedule. The pricing schedule may not be changed or altered. Tenderer(s) to populate all required information on the Tender cover sheet and as stipulated in Sheet 5.1.1."]
[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 Schedule). Details of the CPA Formulae to be determined in accordance with the CPA conditions with reference to the NOTES. If the CPA Formulae are not inputted, in worksheet 5.1.2 CPA formulae, the tendered prices will be deemed \"Fixed and Firm\". If the CPA formulae is inputted in worksheet (5.1.2 CPA Formulae) but is not reflected, using the drop downs, in worksheet (5.1.1 Pricing), the tendered prices will be deemed \"Fixed and Firm\"."]
[null,"5.1.3 Exchange Rates","This sheet needs to be completed if the tenderer will be exposed to any currency fluctuations"]
[]
[]
[6,"Conventions used in this workbook"]
["The following conventions have been used in this workbook to facilitate its accurate use:"]
[null,"Only Light Green highlighted cells are to be inputted by the Tenderer."]
[null,"There will be no inputting in Grey highlighted cells."]
[null,"Read Me : Very Important"]

{"sheet":"Tender Cover Sheet","index":1,"n_rows":44,"n_cols":4,"rows_kept":44}
{"$rows_empty":9}
[null,"PRICING INFORMATION"]
[]
[null,"ENQUIRY No."]
[]
[null,"NAME OF PACKAGE:","Supply, delivery and off-loading of caustic soda to various power stations for period of up to four months / ending 29 February 2024 as a back-up on an as and when required basis "]
[]
[null,"TENDERER’S NAME:  "]
[]
[null,"CATEGORY OF OFFER (MAIN/ALTERNATIVE OFFER):",{"$f":"'[1]Read Me'!C4","v":"Main Offer"}]
[]
[null,"TENDERED PRICE:  IN ZAR",{"$f":"'5.1.1 Price Schedule'!O33","v":{"v":0,"d":"  0  RAND"}}]
[null,"(excluding VAT)"]
[]
[null,"RAND VALUE IN WORDS","[Price in Words]"]
[null,"(Including VAT)"]
[]
[]
[]
[null,"TENDERED PRICE:  IN ZAR",{"$f":"'5.1.1 Price Schedule'!Q33","v":{"v":0,"d":"  0  RAND"}}]
[null,"(including VAT)"]
[]
[null,"DATE :"]
[]
[]
[]
[null,"FULL NAMES OF SIGNATORY:"]
[]
[]
[]
[null,"DESIGNATION OF SIGNATORY:"]
[]
[]
[]
[null,"SIGNATURE :"]
[{"$nulls":3}," "]

{"sheet":" Preamble","index":2,"n_rows":19,"n_cols":3,"rows_kept":19,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2]]}
["Enquiry No."]
["Package Name:",null,{"$f":"'Tender Cover Sheet'!C14","v":"Supply, delivery and off-loading of caustic soda to various power stations for period of up to four months / ending 29 February 2024 as a back-up on an as and when required basis "}]
["Tenderer's Name:",null,{"$f":"'[1]Tender Cover Sheet'!C16","v":0}]
["Category of Offer:",null,{"$f":"'[1]Read Me'!C4","v":"Main Offer"}]
[]
["5.1.0 PREAMBLE TO PRICE SCHEDULE "]
[]
[1,"The Price Schedule provides the basis of valuation, and information for general contract progress monitoring. This contract is an \"as and when\" required contract. The contract will be allocated based on the 90/10 scoring methodology per station per Caustic soda system and tenderers are encouraged to tender for each power station in full. Eskom reserves the right to allocate a station/s to multiple tenderers that provides the best and most efficient solution. The units herein are estimates only and are non-committal. No alternative offers are accepted. Eskom will exercise its right to utilize payment method 1 for all payments."]
[2,"This is the main data entry sheet for the Tenderer to complete. The Tenderer takes responsibility for ensuring correct inputs. Tenderers are to populate their pricing information as stipulated in the pricing schedule. The pricing schedule may not be changed or altered. Tenderer(s) are to populate all required information on the Tender cover sheet ."]
[3,"The Prices are the amounts stated in the price column of the Price Schedule. Where an estimated quantity is stated for an item in the Price Schedule, the Price is calculated by multiplying the estimated quantity by the rate."]
[4,"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.  "]
[5,"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."]
[6,"The Tenderer must allow for all necessary costs to complete the pricing schedule 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."]
[7,"The Prices quoted by the supplier should be exclusive and inclusive of VAT."]
[8,"Please note, that the Tenderer is to input the VAT amount as no formulae has been provided for the VAT portion."]
[9,"All worksheets in this Pricing Schedule are to be submitted. Tenderers are not allowed to omit any worksheet. CPA is not applicable to this tender."]
[10,"Only Light Green highlighted cells are to be inputted by the Tenderer."]
[11,"There will be no inputting in Grey highlighted cells."]
[12,"Read Me : Very Important"]

{"sheet":"5.1.1 Price Schedule","index":3,"n_rows":33,"n_cols":24,"rows_kept":33,"merged":[[0,0,0,1],[0,2,0,3],[1,0,1,1],[1,2,1,3],[2,0,2,1],[2,2,2,3],[3,0,3,1],[3,2,3,3],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[12,1,12,5],[14,7,14,8],[14,9,14,14],[14,15,14,16],[15,0,16,0],[15,1,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[15,7,16,7],[15,8,16,8],[15,9,16,9],[15,10,16,10],[15,11,16,11],[15,12,16,12],[15,13,16,13],[15,14,16,14],[15,15,16,15],[15,16,16,16],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2]]}
["Enquiry No."]
["Package Name:",null,{"$f":"'[2]Tender Cover Sheet'!C13","v":0}]
["Tenderer's Name:",null,{"$f":"' Preamble'!C2","v":"Supply, delivery and off-loading of caustic soda to various power stations for period of up to four months / ending 29 February 2024 as a back-up on an as and when required basis "}]
["Category of Offer:",null,{"$f":"'[2]Tender Cover Sheet'!C15","v":0}]
[]
["5.1.1. Pricing"]
[]
["NOTES:"]
[1,"This is the main data entry sheet for the Tenderer to complete. The Tenderer takes responsibility for ensuring correct inputs. Tenderers are to populate their pricing information as stipulated in the pricing schedule. The pricing schedule may not be changed or altered. Tenderer(s) to populate all required information on the Tender cover sheet as stipulated in (5.1.1 Pricing Schedule). This contract is an \"as and when\" required contract. The units herein are estimates only and are non-committal. This is a whole tender for each price list where tenderers are required to tender for every item appearing on each price list. "]
[2,"NB - It is the Tenderer's responsibility to ensure that Column M \"Total Tendered Price Excl Vat\" correctly reflects the intention of the Tenderer."]
[3,"The tender prices are fixed and not subject to Cost Price Adjustment (CPA), as it is less than 12 months.  "]
[4,"The tenderer must tender for each power station in full which will be ranked in line with the PPPFA. Tenderer's are to price for all the items listed in the Pricing Schedule that they want to tender in. "]
[5,"Quantities are estimated and non-committal."]
[]
[{"$nulls":7},"Local Currency",null,"Foreign Currency",{"$nulls":5},"Local + Foreign",{"$nulls":7},"ZAR"]
["Line No.","Power Station",null,"Unit of Measurement","Estimated Quantities","Product Tendered Rates (ZAR)","Road Transport Tendered Rates (ZAR) / 30 Ton Tanker","Total Tendered Value (ZAR)","Currency Code (See Sheet 5.1.4 Rate of Exchange)","RoE Currency 1,00 = ZAR","Unit Price in Foreign Currency","Total Foreign Price in Foreign Currency","Total Foreign Price in Local Currency (ZAR)","Import Charges in Local Currency (ZAR)","Total Tendered Price Excld. Vat (ZAR)","VAT","Tendered Price Including VAT (ZAR)",{"$nulls":4},"A","AUD"]
[{"$nulls":21},"B","CAN"]
[1,"Kendal",null,"Ton",540,null,null,{"$f":"(F18+G18)*E18","v":0},"ZAR",{"$f":"IF(I18<>\"\",VLOOKUP(I18,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,{"$f":"E18*K18","v":0},{"$f":"L18*J18","v":0},null,{"$f":"M18+H18+N18","v":0},null,{"$f":"O18+P18","v":0},{"$nulls":4},"C","CHF"]
[2,"Lethabo",300,"Ton",240,null,null,0,"ZAR",{"$f":"IF(I19<>\"\",VLOOKUP(I19,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,{"$f":"M19+H19+N19","v":0},null,0,{"$nulls":4},"C","CHF"]
[3,"Majuba",450,"Ton",390,null,null,0,"ZAR",{"$f":"IF(I20<>\"\",VLOOKUP(I20,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0,{"$nulls":4},"D","DKK"]
[4,"Matla",300,"Ton",270,null,null,0,"ZAR",{"$f":"IF(I21<>\"\",VLOOKUP(I21,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0,{"$nulls":4},"D","DKK"]
[5,"Tutuka",300,"Ton",270,null,null,0,"ZAR",{"$f":"IF(I22<>\"\",VLOOKUP(I22,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0,{"$nulls":4},"F","EUR"]
[6,"Duvha",300,"Ton",270,null,null,0,"ZAR",{"$f":"IF(I23<>\"\",VLOOKUP(I23,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0,{"$nulls":4},"F","EUR"]
[7,"Matimba",540,"Ton",450,null,null,0,"ZAR",{"$f":"IF(I24<>\"\",VLOOKUP(I24,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0,{"$nulls":4},"F","EUR"]
[8,"Arnot",300,"Ton",270,null,null,0,"ZAR",{"$f":"IF(I25<>\"\",VLOOKUP(I25,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0,{"$nulls":4},"F","EUR"]
[9,"Hendrina",150,"Ton",120,null,null,0,"ZAR",{"$f":"IF(I26<>\"\",VLOOKUP(I26,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0,{"$nulls":4},"G","GBP"]
[10,"Grootvlei",150,"Ton",120,null,null,0,"ZAR",{"$f":"IF(I27<>\"\",VLOOKUP(I27,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0,{"$nulls":4},"G","GBP"]
[11,"Camden",300,"Ton",270,null,null,0,"ZAR",{"$f":"IF(I28<>\"\",VLOOKUP(I28,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0]
[12,"Kriel",600,"Ton",540,null,null,0,"ZAR",{"$f":"IF(I29<>\"\",VLOOKUP(I29,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0,{"$nulls":4},"H","HKD"]
[13,"Kusile",300,"Ton",270,null,null,0,"ZAR",{"$f":"IF(I30<>\"\",VLOOKUP(I30,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0,{"$nulls":4},"H","HKD"]
[14,"Medupi",240,"Ton",180,null,null,0,"ZAR",{"$f":"IF(I31<>\"\",VLOOKUP(I31,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,0,null,0]
[15,"Koeberg",150,"Ton",120,null,null,0,"ZAR",{"$f":"IF(I32<>\"\",VLOOKUP(I32,'[2]5.1.3 Exchange Rates'!$C$23:$E$38,2,FALSE),\"\")","v":0},null,0,0,null,{"$f":"M32+H32+N32","v":0},null,0]
[null,"TOTAL ",null,null,4320,null,null,{"$f":"SUM(H18:H32)","v":0},null,{"$f":"SUM(J18:J32)","v":0},null,{"$f":"SUM(L18:L32)","v":0},{"$f":"SUM(M18:M32)","v":0},null,{"$f":"SUM(O18:O32)","v":0},null,{"$f":"SUM(Q18:Q32)","v":0}]

{"sheet":"5.1.3 Exchange Rates","index":4,"n_rows":41,"n_cols":8,"rows_kept":41,"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],[14,0,16,0],[14,1,14,6],[15,1,15,6],[16,1,16,6],[21,7,21,12],[22,7,22,12]]}
["Enquiry No."]
["Package Name:",null,{"$f":"'Tender Cover Sheet'!C14","v":"Supply, delivery and off-loading of caustic soda to various power stations for period of up to four months / ending 29 February 2024 as a back-up on an as and when required basis "}]
["Tenderer's Name:",null,{"$f":"'[1]Tender Cover Sheet'!C16","v":0}]
["Category of Offer:",null,{"$f":"'[1]Read Me'!C4","v":"Main Offer"}]
[]
["5.1.6 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"]
[5,"All information in the table below must conform with all other equivalent information in the offer. "]
[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,"If more than one payment method apply for a currency, the Tenderer must request an additional row be inserted in the table in order to split the values and identify the relevant method.   "]
[" "]
[" "]
["EXCHANGE RATES PUBLISHED BY SARB"]
["NB: Tenderers must submit proof of the SARB rate (s) of exchange used."]
[{"$nulls":5},"Date for which the rates are published :",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","Amount in Foreign Currency","Amount in Rand","Payment Method 1a, 1b or 2"]
[1,"South African Rand","ZAR",{"v":0,"d":"R 0.00"}]
[2,"Australian Dollar","AUD",{"v":0,"d":"R 0.00"},null,{"$f":"D25*E25","v":{"v":0,"d":"R 0.00"}}]
[3,"Canadian Dollar","CAN",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[4,"Swiss Franc","CHF",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[5,"Danish Krone","DKK",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[6,"European Currency","EUR",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[7,"British Pound","GBP",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[8,"Hong Kong Dollar","HKD",{"v":10,"d":"R 10.00"},0,{"v":0,"d":"R 0.00"}]
[9,"Japanese Yen","JPY",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[10,"Norwegian Krone","NOK",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[11,"New Zealand Dollar","NZD",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[12,"Swedish Krone","SEK",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[13,"Singapore Dollar","SGD",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[14,"United States Dollar","USD",{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[{"$nulls":3},{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[{"$nulls":3},{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[{"$nulls":3},{"v":0,"d":"R 0.00"},0,{"v":0,"d":"R 0.00"}]
[null,"TOTAL RAND  -  MUST AGREE WITH TOTAL FOREIGN PRICE IN ZAR (EXCL. VAT)",{"$nulls":3},{"$f":"SUM(F25:F40)","v":{"v":0,"d":"R 0.00"}}]