{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Tender Cover Sheet","Preambles","Pricing Schedule","Option X3 Exchange Rates"],"not_rendered":{"images":1,"external_links":144,"defined_names":3577},"read":"whole","date_system":"1900"}

{"sheet":"Tender Cover Sheet","index":0,"n_rows":35,"n_cols":5,"rows_kept":35}
[]
[]
[]
[]
[null,null,"Enquiry No."]
[null,null,"Package Name:"]
[null,null,"Tenderer's Name:"]
[]
[]
[]
[]
[null,null,"PRICING INFORMATION"]
[]
[null,null,"RAND VALUE IN WORDS","RATE ONLY"," "]
[]
[]
[null,null,"TENDERED PRICE:  IN ZAR",{"$f":"D14","v":"RATE ONLY"}]
[null,null,"(excluding VAT)"]
[]
[null,null,"TENDERED PRICE:  IN ZAR"]
[null,null,"(including VAT)",{"$f":"D17","v":"RATE ONLY"}]
[]
[]
[]
[null,null,"DATE :"," "]
[]
[]
[null,null,"FULL NAMES OF SIGNATORY:"," "]
[]
[]
[null,null,"DESIGNATION OF SIGNATORY:"," "]
[]
[]
[null,null,"SIGNATURE :"]
[{"$nulls":4}," "]

{"sheet":"Preambles","index":1,"n_rows":17,"n_cols":2,"rows_kept":17,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[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],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2]]}
["Enquiry No."]
["Package Name:"]
["Tenderer's Name:"]
[]
["PREAMBLE TO PRICE SCHEDULE "]
[]
[1,"The Price Schedule provides the basis of valuation, price adjustment (CPA) formulae and information for general contract progress monitoring.No alternative offers are accepted."]
[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) to populate all required information on the Cover sheet and also populate  as stipulated in (Pricing Schedule and Exchange rates)."]
[3,"This is a RATE ONLY tender"]
[4,"The total rate must include for all direct and indirect costs, overheads, profit on costs, risks, liabilities, obligations, etc. relative to the contract."]
[5,"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 contract award."]
[6,"The Prices quoted by the supplier should be exclusive and inclusive of VAT."]
[7,"All worksheets in this Pricing Schedule are to be submitted. Tenderers are not allowed to omit a worksheet."]
[8,"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 ntcsa, through the designated buyer!"]
[9,"Only Light Green highlighted cells are to be inputted by the Tenderer."]
[10,"There will be no inputting in Grey highlighted cells."]
[11,"Obsolete items should be identified by the respective suppliers and we are requesting them to propose an alternative to be used. The alternative solution will not be automatically accepted as it will have to be accepted as fit for use by the respective custodians."]

{"sheet":"Pricing Schedule","index":2,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[1,2,1,8],[2,2,2,8],[3,2,3,8],[5,0,5,8],[6,0,9,0],[6,1,9,1],[6,2,9,2],[6,4,6,7],[7,4,8,4],[8,3,9,3],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8]]}
[]
[null,"Enquiry No."]
[null,"Package Name:"]
[null,"Tenderer's Name:"]
[]
["PRICING SCHEDULE"]
["No.","Description","Unit of Measure","LOCAL CURRENCY","FOREIGN CURRENCY"]
[{"$nulls":3},1,"Currency Code",2,3,"4=2*3","5=1+4"]
[{"$nulls":3},"Unit Rate (ZAR)",null,"Unit Rate (Foreign Currency)","Rate of Exchange","Unit Rate in Local Currency (ZAR)","Total Unit Rate/ Item"]
[{"$nulls":4},"Use drop down menu"]
[1,"Inception and Data Gathering, meetings with relevant stakeholders, gathering of network models etc + Inception Report.","Item",null,"ZAR",null,{"$f":"IF(E11<>\"\",VLOOKUP(E11,'Option X3 Exchange Rates'!$C$23:$D$36,2,FALSE))","v":{"v":1,"d":"R1.00"}},{"$f":"F11*G11","v":0},{"$f":"D11+H11","v":0}]
[2,"Grid Synchronous Zones Definition - Methodology Development, Preliminary zoning, Refinement and validation + Draft Synchronous Zones Definition Report.","Item",null,"ZAR",null,{"$f":"IF(E12<>\"\",VLOOKUP(E12,'Option X3 Exchange Rates'!$C$23:$D$36,2,FALSE))","v":{"v":1,"d":"R1.00"}},{"$f":"F12*G12","v":0},{"$f":"D12+H12","v":0}]
[3,"PMU Placement Study - Optimal placement criteria, Modelling and Analysis, Cost-Benefit Analysis + Draft PMU Placement Strategy Report.","Item",null,"ZAR",null,{"$f":"IF(E13<>\"\",VLOOKUP(E13,'Option X3 Exchange Rates'!$C$23:$D$36,2,FALSE))","v":{"v":1,"d":"R1.00"}},0,0]
[4,"Simulation and Validation.","Item",null,"ZAR",null,{"$f":"IF(E14<>\"\",VLOOKUP(E14,'Option X3 Exchange Rates'!$C$23:$D$36,2,FALSE))","v":{"v":1,"d":"R1.00"}},0,0]
[5,"Reporting and Recommendations: Technical Report, Integration Roadmap, Workshops etc + Final Comprehensive Report (including Synchronous Zones & PMU Placement), Presentation and Stakeholder Workshops.","Item",null,"ZAR",null,{"$f":"IF(E15<>\"\",VLOOKUP(E15,'Option X3 Exchange Rates'!$C$23:$D$36,2,FALSE))","v":{"v":1,"d":"R1.00"}},0,0]
[6,"Recommendations for Future Inertia Mitigation + Inertia Mitigation Recommendations, Interim Progress Reports.","Item",null,"ZAR",null,{"$f":"IF(E16<>\"\",VLOOKUP(E16,'Option X3 Exchange Rates'!$C$23:$D$36,2,FALSE))","v":{"v":1,"d":"R1.00"}},0,0]
[]
[]
[]
[null,"Notes to Tenderer"]
[]
[1,"Foreign currency to be used where applicable ONLY"]
[2,"Select the drop down menu to choose the applicable Exchange rate which is linked to X3."]
[3,"Travel and related expenses will be claimed on actuals costs as per the NEC."]
[4,"The use of all necessary software, tools and licenses is deemed inclusive on above costs."]

{"sheet":"Option X3 Exchange Rates","index":3,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[0,0,0,1],[0,2,0,6],[1,0,1,1],[1,2,1,6],[2,0,2,1],[2,2,2,6],[7,1,7,6],[8,0,10,0],[8,1,8,6],[8,14,8,19],[9,1,9,6],[10,1,10,6],[11,1,11,6],[12,1,12,6],[13,0,15,0],[13,1,13,6],[14,1,14,6],[15,1,15,6],[20,7,20,12]]}
["Enquiry No."]
["Package Name:"]
["Tenderer's Name:"]
[]
["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":4},"Date for which the rates are published :",null,null,"Date to be inserted in the following format: Day, Month and Year.\n\nMust be the SARB rate at 12:00 on day of advertisement of bid"]
["No","Currency Description","Code","Exchange Rate\nCurrency 1,00 = R Amount","Payment Method 1a, 1b or 2","Source"]
[1,"South African Rand","ZAR",{"v":1,"d":"R 1.0000"}]
[2,"Australian Dollar","AUD",{"v":0,"d":"R 0.0000"}]
[3,"Canadian Dollar","CAN",{"v":0,"d":"R 0.0000"}]
[4,"Swiss Franc","CHF",{"v":0,"d":"R 0.0000"}]
[5,"Danish Krone","DKK",{"v":0,"d":"R 0.0000"}]
[6,"European Currency","EUR",{"v":0,"d":"R 0.0000"}]
[7,"British Pound","GBP",{"v":0,"d":"R 0.0000"}]
[8,"Hong Kong Dollar","HKD",{"v":0,"d":"R 0.0000"}]
[9,"Japanese Yen","JPY",{"v":0,"d":"R 0.0000"}]
[10,"Norwegian Krone","NOK",{"v":0,"d":"R 0.0000"}]
[11,"New Zealand Dollar","NZD",{"v":0,"d":"R 0.0000"}]
[12,"Swedish Krone","SEK",{"v":0,"d":"R 0.0000"}]
[13,"Singapore Dollar","SGD",{"v":0,"d":"R 0.0000"}]
[14,"United States Dollar","USD",{"v":0,"d":"R 0.0000"}]