{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Read Me","Tender Cover Sheet","5.1.0 Preamble","5.1.1 Table 1 Services","5.1.1Table 2Training","5.1.1 Table 3 OEM Fees","5.1.2 CPA Formulae","5.1.4 PS5","5.1.3 Summary","5.1.4 Exchange Rates"],"not_rendered":{"images":1,"external_links":2,"defined_names":11},"read":"whole","date_system":"1900"}

{"sheet":"Read Me","index":0,"n_rows":25,"n_cols":3,"rows_kept":25,"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],[21,1,21,2],[22,1,22,2]]}
["Enquiry No.",null,{"$f":"'Tender Cover Sheet'!C12","v":0}]
["Package Name:",null,{"$f":"'Tender Cover Sheet'!C14","v":0}]
["Tenderer's Name:",null,{"$f":"'Tender Cover Sheet'!C16","v":0}]
["Category of Offer ( Main Offer Only):",null,"Main Offer Only"]
[]
["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."]
[2,"Only The Main Offer shall be accepted. No alternative offers are accepted. There must be a separate Excel and PDF file for the main offer."]
[3,"Main offer is = The pricing schedule may not be changed or altered. Tenderer(s) to populate all required information on the Tender cover sheet and also populate as stipulated in (5.1.1 Pricing, 5.1.2 CPA Formulae, 5.1.3 Summary (VATPortion) and 5.1.4 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 NTCSA, 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 to a single supplier for this price list and.This contract is an \"as and when\" required contract. The units quantities herein are estimates only and are non-committal."]
[null,"Tender Cover Sheet","This is the cover sheet for Worksheets 5.1.0 to 5.1.4 and provides the total tendered price which is mandatory 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. Worksheets Tender Cover Sheet, 5.1.1 Pricing, 5.1.2 CPA Formulae, 5.1.3 Summary and 5.1.4 Exchange Rates 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 as stipulated in  (5.1.1 Pricing ), (5.1.4 Exchange rates) and  (5.1.2 CPA Formulae). "]
[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. 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\". Rate of exchange (ROE) cannot be accepted by NTCSA to form part of any CPA formulae."]
[]
[]
[6,"Conventions used in this workbook"]
[null,"The following conventions have been used in this workbook to facilitate its accurate use:"]
[null,null,"Only Light Green highlighted cells are to be inputted by the Tenderer."]
[null,null,"There will be no inputting in Grey highlighted cells."]

{"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:"]
[]
[null,"TENDERER’S NAME:  "]
[]
[null,"CATEGORY OF OFFER (MAIN OFFER ONLY):",{"$f":"'Read Me'!C4","v":"Main Offer Only"}]
[]
[null,"TENDERED PRICE:  IN ZAR",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"(excluding VAT)"]
[]
[null,"RAND VALUE IN WORDS","[Price in Words]"]
[]
[]
[]
[]
[null,"TENDERED PRICE:  IN ZAR",{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"(including VAT)"]
[]
[null,"DATE :"]
[]
[]
[]
[null,"FULL NAMES OF SIGNATORY:"]
[]
[]
[]
[null,"DESIGNATION OF SIGNATORY:"]
[]
[]
[]
[null,"SIGNATURE :"]
[{"$nulls":3}," "]

{"sheet":"5.1.0 Preamble","index":2,"n_rows":18,"n_cols":3,"rows_kept":18,"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]]}
["Enquiry No."]
["Package Name:",null,{"$f":"'Tender Cover Sheet'!C14","v":0}]
["Tenderer's Name:",null,{"$f":"'Tender Cover Sheet'!C16","v":0}]
["Category of Offer:",null,{"$f":"'Read Me'!C4","v":"Main Offer Only"}]
[]
["5.1.0 PREAMBLE TO PRICE SCHEDULE "]
[]
[1,"The Price Schedule provides the basis of valuation, price adjustment (CPA) formulae and information for general contract progress monitoring. This contract is an \"as and when\" required contract.The tender will be awarded to a single supplier for this price list.The units quantities herein are estimates only and are non-committal.  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 Tender cover sheet and also populate  as stipulated in  (5.1.1 Pricing )  (5.1.2 CPA Formulae) and (5.1.4 Exchange rates). CPA Formulae should represent cost breakdown of the goods/commodities/components/items being sourced."]
[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 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."]
[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 ommit a worksheet. If specifically worksheets, 5.1.1 or 5.1.2 are ommited, it will be deemed that CPA  are not applicable to this tender. Rate of exchange (ROE) cannot be accepted by NTCSA to form part of any CPA formulae."]
[10,"Only Light Green highlighted cells are to be inputted by the Tenderer."]
[11,"There will be no inputting in Grey highlighted cells."]

{"sheet":"5.1.1 Table 1 Services","index":3,"n_rows":28,"n_cols":18,"rows_kept":28,"merged":[[11,4,11,5],[11,6,11,10],[11,11,11,13],[11,14,11,17],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,14,13,16],[12,17,13,17],[26,0,26,3],[26,6,26,8]]}
["Enquiry No."]
["Package Name:"]
["Tenderer's Name:"]
["Category of Offer:"]
[]
["5.1.1. Pricing"]
[]
["NOTES:"]
[1]
[2]
[]
[{"$nulls":4},"Local Currency",null,"Foreign Currency",{"$nulls":4},"Local + Foreign",null,null,"CPA"]
["Line No.","Activity description","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","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)","Tendered Price Excld. Vat (ZAR)","Vat ","Tendered Price Including Vat (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)",null,null,"CPA Description\n(See Sheet 5.1.2)"]
[]
[]
["Table 1","Services(Including OHS cost)"]
[1,"SLA as detailed in section 3.5.2  of 240-135089195","Months",60,null,{"$f":"E17*D17","v":0},"ZAR",{"$f":"IF(G17<>\"\",VLOOKUP(G17,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,{"$f":"D17*I17","v":0},{"$f":"D17*H17*I17","v":0},{"$f":"K17+F17","v":0},{"$f":"L17*15%","v":0},{"$f":"L17+M17","v":0},{"$nulls":3},{"$f":"IF(O17=\"\",\"Fixed\",VLOOKUP(O17,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[2,"Major Upgrade ","(1xPer Annum)",5,null,{"$f":"E18*D18","v":0},"ZAR",{"$f":"IF(G18<>\"\",VLOOKUP(G18,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,{"$f":"K18+F18","v":0},0,0,{"$nulls":3},{"$f":"IF(O18=\"\",\"Fixed\",VLOOKUP(O18,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[3,"Ad hoc Support  (Planning/Engineering) ","Per Hour",3,null,0,"ZAR",{"$f":"IF(G19<>\"\",VLOOKUP(G19,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O19=\"\",\"Fixed\",VLOOKUP(O19,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[4,"Ad hoc Support (Technical/Operations) ","Per Hour",3,null,0,"ZAR",{"$f":"IF(G20<>\"\",VLOOKUP(G20,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O20=\"\",\"Fixed\",VLOOKUP(O20,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[5,"Ad hoc Support (Installation & Commissioning including SHEQ) ","Per Hour",3,null,0,"ZAR",{"$f":"IF(G21<>\"\",VLOOKUP(G21,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O21=\"\",\"Fixed\",VLOOKUP(O21,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[6,"Ad hoc Support (Project Management)","Per Hour",3,null,0,"ZAR",{"$f":"IF(G22<>\"\",VLOOKUP(G22,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O22=\"\",\"Fixed\",VLOOKUP(O22,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[7,"Adhoc SHEQ Support","Per Hour",3,null,0,"ZAR",{"$f":"IF(G23<>\"\",VLOOKUP(G23,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O23=\"\",\"Fixed\",VLOOKUP(O23,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[8,"Operating Regulations for High Voltage System (ORHVS)","Per Hour",3,null,{"$f":"E24*D24","v":0},"ZAR",{"$f":"IF(G24<>\"\",VLOOKUP(G24,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,{"$f":"D24*I24","v":0},{"$f":"D24*H24*I24","v":0},{"$f":"K24+F24","v":0},{"$f":"L24*15%","v":0},{"$f":"L24+M24","v":0},{"$nulls":3},{"$f":"IF(O24=\"\",\"Fixed\",VLOOKUP(O24,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
["TOTAL",{"$nulls":4},{"$f":"SUM(F17:F24)","v":0},"ZAR",{"$f":"IF(G25<>\"\",VLOOKUP(G25,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,{"$f":"SUM(J17:J24)","v":0},{"$f":"SUM(K17:K24)","v":0},{"$f":"SUM(L17:L24)","v":0},{"$f":"SUM(M17:M24)","v":0},{"$f":"SUM(N17:N24)","v":0},{"$nulls":3},{"$f":"IF(O25=\"\",\"Fixed\",VLOOKUP(O25,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[]
["Total Tendered Value",{"$nulls":4},{"$f":"F25","v":0},{"$nulls":3},{"$f":"J25","v":0},0,0,0,0]
[{"$nulls":11},"Must agree with Price (Excl. VAT) on Tender Cover Page",null,"Must agree with Price (Incl. VAT) on Tender Cover Page"]

{"sheet":"5.1.1Table 2Training","index":4,"n_rows":24,"n_cols":18,"rows_kept":24,"merged":[[11,4,11,5],[11,6,11,10],[11,11,11,13],[11,14,11,17],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,14,13,16],[12,17,13,17],[22,0,22,4],[22,6,22,8]]}
["Enquiry No."]
["Package Name:"]
["Tenderer's Name:"]
["Category of Offer:"]
[]
["5.1.1. Pricing"]
[]
["NOTES:"]
[1]
[2]
[]
[{"$nulls":4},"Local Currency",null,"Foreign Currency",{"$nulls":4},"Local + Foreign",null,null,"CPA"]
["Line No.","Activity description","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","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)","Tendered Price Excld. Vat (ZAR)","Vat ","Tendered Price Including Vat (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)",null,null,"CPA Description\n(See Sheet 5.1.2)"]
[]
[]
["Table 2","Training 240-135089195 Section 3.8(Including OHS cost)"]
[1,"Design Engineer","Per Attendee",10,null,{"$f":"E17*D17","v":0},"ZAR",{"$f":"IF(G17<>\"\",VLOOKUP(G17,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,{"$f":"D17*I17","v":0},{"$f":"D17*H17*I17","v":0},{"$f":"K17+F17","v":0},{"$f":"L17*15%","v":0},{"$f":"L17+M17","v":0},{"$nulls":3},{"$f":"IF(O17=\"\",\"Fixed\",VLOOKUP(O17,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[2,"Planning Engineer","Per Attendee",10,null,{"$f":"E18*D18","v":0},"ZAR",{"$f":"IF(G18<>\"\",VLOOKUP(G18,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O18=\"\",\"Fixed\",VLOOKUP(O18,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[3,"Installation Technician","Per Attendee",10,null,{"$f":"E19*D19","v":0},"ZAR",{"$f":"IF(G19<>\"\",VLOOKUP(G19,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O19=\"\",\"Fixed\",VLOOKUP(O19,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[4,"Network Management Center Support Technician","Per Attendee",8,null,{"$f":"E20*D20","v":0},"ZAR",{"$f":"IF(G20<>\"\",VLOOKUP(G20,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O20=\"\",\"Fixed\",VLOOKUP(O20,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[5,"Maintenance Technician","Per Attendee",8,null,{"$f":"E21*D21","v":0},"ZAR",{"$f":"IF(G21<>\"\",VLOOKUP(G21,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,{"$f":"D21*I21","v":0},{"$f":"D21*H21*I21","v":0},{"$f":"K21+F21","v":0},{"$f":"L21*15%","v":0},{"$f":"L21+M21","v":0},{"$nulls":3},{"$f":"IF(O21=\"\",\"Fixed\",VLOOKUP(O21,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
["Total ",{"$nulls":4},{"$f":"SUM(F17:F21)","v":0},{"$nulls":3},{"$f":"SUM(J17:J21)","v":0},{"$f":"SUM(K17:K21)","v":0},{"$f":"SUM(L17:L21)","v":0},{"$f":"SUM(M17:M21)","v":0},{"$f":"SUM(N17:N21)","v":0}]
["Total Tendered Value",{"$nulls":4},{"$f":"F22","v":0},{"$nulls":3},{"$f":"J22","v":0},0,0,0,0]
[{"$nulls":11},"Must agree with Price (Excl. VAT) on Tender Cover Page",null,"Must agree with Price (Incl. VAT) on Tender Cover Page"]

{"sheet":"5.1.1 Table 3 OEM Fees","index":5,"n_rows":26,"n_cols":18,"rows_kept":26,"merged":[[11,4,11,5],[11,6,11,10],[11,11,11,13],[11,14,11,17],[12,0,13,0],[12,1,13,1],[12,2,13,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[12,10,13,10],[12,11,13,11],[12,12,13,12],[12,13,13,13],[12,14,13,16],[12,17,13,17],[24,0,24,4],[24,6,24,8]]}
["Enquiry No."]
["Package Name:"]
["Tenderer's Name:"]
["Category of Offer:"]
[]
["5.1.1. Pricing"]
[]
["NOTES:"]
[1]
[2]
[]
[{"$nulls":4},"Local Currency",null,"Foreign Currency",{"$nulls":4},"Local + Foreign",null,null,"CPA"]
["Line No.","Activity description","Unit of measure","Estimated Quantities","Tendered Rates (ZAR)","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)","Tendered Price Excld. Vat (ZAR)","Vat ","Tendered Price Including Vat (ZAR)","CPA Formula No.\n(See Sheet 5.1.2)",null,null,"CPA Description\n(See Sheet 5.1.2)"]
[]
[]
["Table 3","OEM Fees for Repair/Raplcement 240-135089195 3.5.2.5 & 240-128505297 Section 4.3, 4.6, 4.7"]
[1,"Small  size multiplexer","Once-off",50,null,{"$f":"E17*D17","v":0},"ZAR",{"$f":"IF(G17<>\"\",VLOOKUP(G17,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,{"$f":"D17*I17","v":0},{"$f":"D17*H17*I17","v":0},{"$f":"K17+F17","v":0},{"$f":"L17*15%","v":0},{"$f":"L17+M17","v":0},{"$nulls":3},{"$f":"IF(O17=\"\",\"Fixed\",VLOOKUP(O17,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[2,"Medium size multiplexer","Once-off",44,null,{"$f":"E18*D18","v":0},"ZAR",{"$f":"IF(G18<>\"\",VLOOKUP(G18,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O18=\"\",\"Fixed\",VLOOKUP(O18,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[3,"Large size multiplexer","Once-off",22,null,{"$f":"E19*D19","v":0},"ZAR",{"$f":"IF(G19<>\"\",VLOOKUP(G19,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O19=\"\",\"Fixed\",VLOOKUP(O19,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[4,"Network Management System","Once-off",1,null,{"$f":"E20*D20","v":0},"ZAR",{"$f":"IF(G20<>\"\",VLOOKUP(G20,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O20=\"\",\"Fixed\",VLOOKUP(O20,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[5,"Network Simulator","Once-off",1,null,{"$f":"E21*D21","v":0},"ZAR",{"$f":"IF(G21<>\"\",VLOOKUP(G21,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,{"$f":"K21+F21","v":0},0,0,{"$nulls":3},{"$f":"IF(O21=\"\",\"Fixed\",VLOOKUP(O21,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[6,"Security Management System","Once-off",1,null,{"$f":"E22*D22","v":0},"ZAR",{"$f":"IF(G22<>\"\",VLOOKUP(G22,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,{"$f":"D22*I22","v":0},{"$f":"D22*H22*I22","v":0},{"$f":"K22+F22","v":0},{"$f":"L22*15%","v":0},{"$f":"L22+M22","v":0},{"$nulls":3},{"$f":"IF(O22=\"\",\"Fixed\",VLOOKUP(O22,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
[7,"Any other OEM fees not listed above","Once-off",1,null,0,"ZAR",{"$f":"IF(G23<>\"\",VLOOKUP(G23,'5.1.4 Exchange Rates'!$C$23:$D$37,2,FALSE),\"\")","v":1},null,0,0,0,0,0,{"$nulls":3},{"$f":"IF(O23=\"\",\"Fixed\",VLOOKUP(O23,'5.1.2 CPA Formulae'!$B$9:$E$19,2,FALSE))","v":"Fixed"}]
["Total ",{"$nulls":4},{"$f":"SUM(F17:F23)","v":0},{"$nulls":3},{"$f":"SUM(J17:J23)","v":0},0,0,0,0]
["Total Tendered Value",{"$nulls":4},{"$f":"F24","v":0},{"$nulls":3},{"$f":"J24","v":0},0,0,0,0]
[{"$nulls":11},"Must agree with Price (Excl. VAT) on Tender Cover Page",null,"Must agree with Price (Incl. VAT) on Tender Cover Page"]

{"sheet":"5.1.2 CPA Formulae","index":6,"n_rows":149,"n_cols":67,"rows_kept":149,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[5,0,5,4],[8,2,8,3],[8,5,8,7],[9,5,19,7],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[14,2,14,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,4],[19,2,19,4],[22,1,22,6],[23,1,23,6],[26,1,26,6],[27,1,27,6],[28,1,28,6],[29,1,29,6],[30,1,30,6],[31,1,31,6],[33,1,33,6],[34,1,34,6],[35,1,35,6],[36,1,36,6],[37,1,37,6],[41,1,41,6],[52,1,52,6],[63,1,63,6],[74,1,74,6],[85,1,85,6],[96,1,96,6],[107,1,107,6],[118,1,118,6],[129,1,129,6],[140,1,140,6]]}
["Enquiry No.",null,{"$f":"'[1]Tender Cover Sheet'!C12","v":0}]
["Package Name:",null,{"$f":"'[1]Tender Cover Sheet'!C14","v":0}]
["Tenderer's Name:",null,{"$f":"'[1]Tender Cover Sheet'!C16","v":0}]
["Category of Offer:",null,{"$f":"'[1]Read Me'!C4","v":"Main Offer Only"}]
[]
["5.1.2 CONTRACT PRICE ADJUSTMENT (CPA) FOR INFLATION"]
[]
["No.","Formula Code","Summary of the description of the Tenderer's Formulae"]
[1,"Fixed","Firm and Fixed ",null,null,"Prices are 100 % fixed and firm. CPA is not applicable. "]
[2,"A1","Tenderer's description of Multiple Formulae",null,null,"Type in the description of each formula in the tables below"]
[3,"A",{"$f":"B42","v":"Tenderer's description of Formula A"}]
[4,"B",{"$f":"B53","v":"Tenderer's description of Formula B"}]
[5,"C",{"$f":"B64","v":"Tenderer's description of Formula C"}]
[6,"D",{"$f":"B75","v":"Tenderer's description of Formula D"}]
[7,"E",{"$f":"B86","v":"Tenderer's description of Formula E"}]
[8,"F",{"$f":"B97","v":"Tenderer's description of Formula F"}]
[9,"G",{"$f":"B108","v":"Tenderer's description of Formula G"}]
[10,"H",{"$f":"B119","v":"Tenderer's description of Formula H"}]
[11,"I",{"$f":"B130","v":"Tenderer's description of Formula I"}]
[12,"J",{"$f":"B141","v":"Tenderer's description of Formula J"}]
[]
["SPECIFIC REQUIREMENTS"]
[{"v":1,"d":"1."},"Only Main Offer is to be submitted. Main offer tenderers are to fully comply with the requirements in the General Notes and CPA Formulae Notes below."]
[{"v":2,"d":"2."},"No ALTERNATIVE offers are accepted."]
[]
["GENERAL NOTES :"]
[1,"References to \"indices\" below mean \"cost indices or reference prices\"."]
[2,"Where 5 year historical information must be provided as instructed below, internet address references which are accessible to the general public may be submitted by the Tenderer instead, with the specific electronic route and web page reflecting the applicable data."]
[3,"The worksheet  CPA Formula in 5.1.2. has to be populated by the tenderer (columns B - J), unless the tenderer’s prices are fixed and firm for the duration of the contract. Each CPA formula must add up to a total of 100%.  All columns are to be populated. No inhouse CPA indices may be used. Tenderers are to provide all requested information.CPA Formulae should represent cost breakdown of the goods/commodities/components/items being sourced.\n"]
[4,"CPA Formulae Codes Column N 5.1.1 Pricing is to be populated by the tenderer by selecting the respective drop down codes CPA formula as  developed by Tenderer in 5.1.2 CPA formulae worksheet   (e.g. Formula A-J ) then  the tenderer must populate their respective CPA formula in  5.1.2 CPA Formulae Worksheet. Codes and descriptions must be selected by the tenderer and inserted into each row of activity. "]
[5,"Prices will be fixed for the first twelve (12) months after contract signing date and CPA will be applicable and will be applied on the contract 16 months from base date on an annual basis based on the CPA formula agreed on with tenderer."]
[6,"The CPA escalation will be calculated as follows: latest index which is the latest available index at the end of each contractual year vs. the base index which is one month prior to tender closing date. "]
["CPA FORMULA NOTES :"]
[1,"Proportions/weightings in CPA Formulae: The fixed portion of each formula, not subject to CPA, must be at least 15% but Tenderers may submit higher fixed portion percentages.  The other constituent indices and their proportions in each formula must be realistic and relative to the applicable work. The fixed portion and other proportions must add up to 100%.   "]
[2,"Formulae must be linked to independent cost indices or other benchmarks (\"reference prices\") and must be clearly and completely defined. The source must be a recognised and independent statistical publishing organisation.  The Tenderers' in-house indices may not be used."]
[3,"Local Price CPA: Where local indices other than those published by SEIFSA or Statistics SA are specified, the Tenderer must submit 5 years' of month by month historical data for such indices.  The Tenderer must ensure that indices are published and recommended by the source thereof as applicable to the work involved and that they are still in force/use and applicable at the date of submission of the tender. "]
[4,"CPA Base Date: The CPA base date for calculating price movements will be the Base Date, Month before Tender closes. For indices or reference prices published as at certain dates, and where such a date is not the Base Date, the latest date for which it is published before the Base Date will be considered as the Base Date index or reference price.  In instances where the figure or value is not as at the Base Date or considered as the Base Date Index or reference price as explained herein, the date, figure or value as well as the reason for the deviation must be clearly separately stated and must be realistic for purposes of CPA.  ",{"$nulls":10}," "]
[5,"Base Date Index :   The base index or reference price must be inserted in the appropriate column."]
[" "," "]
[]
[]
["Formula A","Tenderer's description of Formula A"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide http link)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["A1"]
["A2"]
["A3"]
["A4"," "]
["A5"]
["A6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B44:B49)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula B","Tenderer's description of Formula B"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["B1"]
["B2"," "]
["B3"]
["B4"," "]
["B5"," "]
["B6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B55:B60)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula C","Tenderer's description of Formula C"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["C1",{"$nulls":4}," "," "," "]
["C2"," "]
["C3"]
["C4"," "]
["C5"," "]
["C6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B66:B71)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula D","Tenderer's description of Formula D"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["D1"," "]
["D2"," "]
["D3"]
["D4"," "]
["D5"," "]
["D6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B77:B82)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula E","Tenderer's description of Formula E"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["E1"," "]
["E2"," "]
["E3"]
["E4"," "]
["E5"," "]
["E6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B88:B93)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula F","Tenderer's description of Formula F"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["F1"]
["F2"]
["F3"]
["F4"]
["F5"]
["F6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B99:B104)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula G","Tenderer's description of Formula G"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["G1"," "]
["G2"," "]
["G3"," "]
["G4"]
["G5"," "]
["G6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B110:B115)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula H","Tenderer's description of Formula H"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["H1"," "]
["H2"," "]
["H3"," "]
["H4"," "]
["H5"," "]
["H6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B121:B126)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula I","Tenderer's description of Formula I"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["I1"," "]
["I2"," "]
["I3"," "]
["I4"]
["I5"," "]
["I6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B132:B137)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula J","Tenderer's description of Formula J"]
["Index Ref.","Proportions / weightings for each index (refer note 1)","Description / scope of index (e.g. Labour)","Title/Definition : Linked to the index, e.g., Table C3, All hourly paid employees.  Must be completely defined","Source/publisher of index (e.g. SEIFSA, StatsSA, LME)","Base Month for CPA if not Base Date as defined (refer note 4)","Base Date Index (refer note 5)","Historical data provided (Yes or No- provide Internet address)","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd","yy/mm/dd"]
["J1"," "]
["J2"]
["J3"," "]
["J4"," "]
["J5"," "]
["J6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B143:B148)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]

{"sheet":"5.1.4 PS5","index":7,"n_rows":83,"n_cols":19,"rows_kept":83,"hidden":true,"merged":[[8,1,8,7],[11,1,11,7],[12,1,12,7],[54,1,54,7]]}
["Enquiry No.",null,{"$f":"'Tender Cover Sheet'!C12","v":0}]
["Package Name:",null,{"$f":"'Tender Cover Sheet'!C14","v":0}]
["Tenderer's Name:",null,{"$f":"'Tender Cover Sheet'!C16","v":0}]
["Category of Offer:",null,{"$f":"'Tender Cover Sheet'!C18","v":"Main Offer Only"}]
[]
["5.1.4. PS 5 "]
[]
["NOTES:"]
[1,"The exchange rates inputted below must be the same as per Worksheet 5.1.6   Exchange Rates."]
[]
[{"$nulls":10},1,2,3,4,5,6,7,8]
["No.","Description",{"$nulls":6}," ",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null," *Eskom may effect this insurance which includes war",{"$nulls":6}," "]
[null,"   risk insurance"]
[null,"**Please specify"]
[null,"SUPPLIED FROM OUTSIDE R.S.A.:",{"$nulls":7},"(In ZAR)"]
[1,"1: F.O.B. PRICE",{"$nulls":7},"(In ZAR)",{"v":1000,"d":"1,000.00"}]
[2,"2: COST OF SEA  FREIGHT",{"$nulls":7},"(In ZAR)"]
[3,"3: COST OF AIR  FREIGHT",{"$nulls":7},"(In ZAR)"]
[4,"4: COST OF MARINE INSURANCES *",{"$nulls":7},"(In ZAR)"]
[5,"5: TOTAL PRICE DELIVERED PORT R.S.A. ...",{"$nulls":5},"(1+2+3+4)",null,"(In ZAR)",{"$f":"SUM(K17:K20)","v":{"v":1000,"d":"1,000.00"}},{"$f":"SUM(L17:L20)","v":0},0,0,0,0,0,0]
[6,"6: WHARFAGE",{"$nulls":7},"(In ZAR)"]
[7,"7: LANDING CHARGES",{"$nulls":7},"(In ZAR)"]
[8,"8: CUSTOMS DUTIES",{"$nulls":7},"(In ZAR)"]
[9,"9: IMPORT SURCHARGE",{"$nulls":7},"(In ZAR)"]
[10,"10: OTHER**",{"$nulls":7},"(In ZAR)"]
[11,"11: COST OF IMPORTATION ...",{"$nulls":5},"(6+7+8+9+10)",null,"(In ZAR)",{"$f":"SUM(K22:K26)","v":0},0,0,0,0,0,0,0]
[12,"12: COST OF RAIL TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
[13,"13: COST OF ROAD TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
[14,"14: TOTAL COST OF TRANSPORT S.A. PORT TO WORK/SITE ...",{"$nulls":5},"(12+13)",null,"(In ZAR)",{"$f":"SUM(K28:K29)","v":0},0,0,0,0,0,{"$f":"SUM(Q28:Q29)","v":0},{"$f":"SUM(R28:R29)","v":0}]
[15,"15: TOTAL PRICE (F.O.B.) DELIVERED TO WORKS/SITE...",{"$nulls":5},"(5+11+14)",null,"(In ZAR)",{"$f":"K21+K27+K30","v":{"v":1000,"d":"1,000.00"}},0,0,0,0,0,{"$f":"Q21+Q27+Q30","v":0},{"$f":"R21+R27+R30","v":0}]
[]
[" ","SUPPLIED FROM INSIDE R.S.A."]
[16,"16: F.O.R. PRICE-GOODS MANUFACTURED INSIDE R.S.A."]
[17,"17: F.O.R. PRICE-GOODS SUPPLIED FROM IMPORTED ITEMS"]
[18,"18: TOTAL F.O.R. PRICE ...",{"$nulls":5},"(16+17)",null,null,{"$f":"SUM(K34:K35)","v":0},0,0,0,0,0,{"$f":"SUM(Q34:Q35)","v":0},{"$f":"SUM(R34:R35)","v":0}]
[19,"19: COST OF RAIL TRANSPORT"]
[20,"20: COST OF ROAD TRANSPORT"]
[21,"21: COST OF TRANSPORT WORKS TO SITE ...          ",{"$nulls":5},"(19+20)",null,null,{"$f":"SUM(K37:K38)","v":0},0,0,0,0,0,{"$f":"SUM(Q37:Q38)","v":0},{"$f":"SUM(R37:R38)","v":0}]
[22,"22: PRICE (F.O.R.) DELIVERED TO SITE ...          ",{"$nulls":5},"(18+21)",null,null,{"$f":"K36+K39","v":0},0,0,0,0,0,{"$f":"Q36+Q39","v":0},{"$f":"R36+R39","v":0}]
[" "," SITE WORK (ERECTION / INSTALLATION INCL. COMMISSIONING) "]
[23,"23: LOCAL LABOUR"]
[24,"24: EXPATRIATE  LABOUR"]
[25,"25: TOTAL PRICE FOR SITE WORK ...          ",{"$nulls":5},"(23+24)",null,null,{"$f":"SUM(K42:K43)","v":0},{"$f":"SUM(L42:L43)","v":0},0,0,0,0,0,0]
[26,"26: OVERSEAS ENGINEERING SERVICES"]
[27,"27: LOCAL ENGINEERING SERVICES"]
[28,"28: TOTAL PRICE FOR ENGINEERING SERVICES...",{"$nulls":5},"(26+27)",null,null,{"$f":"SUM(K45:K46)","v":0},0,0,0,0,0,0,0]
[29,"29: TOTAL PRICE DELIVERED TO SITE (EXCL VAT)",{"$nulls":5},"(15+22+25+28)",null,null," ",{"$f":"L31+L40+L44+L47","v":0},0,0,0,0,0,0]
[30,"30. VAT",{"$nulls":8}," "," "]
[31,"31: TOTAL  PRICE DELIVERED TO SITE (INCLD) VAT",{"$nulls":5},"(29+30)",null,null,{"$f":"SUM(K48:K49)","v":0},0,0,0,0,0,0,0,"Must agree with Price (Including VAT) on Tender Cover Page"]
[null," ",null," ",null,"                "]
[]
[null," "]
[]
[" "," ",{"$nulls":8},1,2,3,4,5,6,7,8]
[null," *Eskom may effect this insurance which includes war",{"$nulls":5}," "," ",null,"DISTRIBUTION CLASS SURGE ARRESTERS FOR 11KV SYSTEMS (INLAND)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 11KV SYSTEMS (COASTAL)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 22KV SYSTEMS (INLAND)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 22KV SYSTEMS (COASTAL)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 33KV SYSTEMS (COASTAL)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 33KV SYSTEMS (COASTAL)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 19KV SWER SYSTEMS (INLAND)","DISTRIBUTION CLASS SURGE ARRESTERS FOR 19KV SWER SYSTEMS (COASTAL)"]
[null,"   risk insurance"]
[null,"**Please specify"]
[null,"PRICE DELIVERED TO PORT R.S.A. (LINE 5)",{"$nulls":6},"(In Foreign Currency)"]
[32,"32: CURRENCY A   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[33,"33: CURRENCY B   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[34,"34: CURRENCY C   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[35,"35: CURRENCY D   1 ZAR=............",null,null,"(FREIGHT)",{"$nulls":3},"(In Foreign Currency)"]
[36,"36: CURRENCY E   1 ZAR=............",null,null,"(INSURANCE)",{"$nulls":3},"(In Foreign Currency)"]
[37,"37: TOTAL F.O.B. PRICE ",{"$nulls":5},"(5=32+33+34+35+36)",null,null,{"$f":"SUM(K60:K64)","v":0},{"$f":"SUM(L60:L64)","v":0},0,0,0,0,0,0]
[null,"PRICE EXPATRIATE LABOUR (LINE 25)",{"$nulls":6},"(In Foreign Currency)"]
[38,"38: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[39,"39: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[40,"40: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[41,"41: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[42,"42: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
[43,"43.TOTAL PRICE EXPATRIATE LABOUR ",{"$nulls":5},"(24=38+39+40+41+42)",null,null,{"$f":"SUM(K67:K71)","v":0},0,0,0,0,0,0,0]
[null,"PRICE OVERSEAS ENGINEERING SERVICES (LINE 27)",{"$nulls":6},"(In Foreign Currency)"]
[44,"44: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[45,"45: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[46,"46: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[47,"47: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[48,"48: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
[49,"49: TOTAL PRICE OVERSEAS ENGINEERING SERVICES (LINE 26) ",{"$nulls":6},"(26=44+45+46+47+48)",null,{"$f":"SUM(K74:K78)","v":0},0,0,0,0,0,0,0]
[50,"50: FOREIGN CONTENT OF TOTAL PRICE",{"$nulls":5},"(37+43+49)",null,null,{"$f":"K65+K72+K79","v":0},0,0,0,0,0,{"$f":"Q65+Q72+Q79","v":0},0]
[]
[]
[null,"SIGNATURE...................................................................",{"$nulls":6},"CAPACITY........................................................................"]

{"sheet":"5.1.3 Summary","index":8,"n_rows":15,"n_cols":8,"rows_kept":15,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[3,0,3,1],[7,3,7,5],[12,6,12,8],[14,6,14,8]]}
["Enquiry No.",null,{"$f":"'Tender Cover Sheet'!C12","v":0}]
["Package Name:",null,{"$f":"'Tender Cover Sheet'!C14","v":0}]
["Tenderer's Name:",null,{"$f":"'Tender Cover Sheet'!C16","v":0}]
["Category of Offer:",null,{"$f":"'[2]Read Me'!C4","v":"Main Offer Only"}]
[]
["5.1.3 Summary ",{"$nulls":6},"Manual input required"]
[]
[{"$nulls":3},"All prices in ZAR"]
["Table No.","Section Description","Total Foreign Currency","Total Foreign Currency (ZAR)","Local","Total Tendered Value "]
[1,"Services",{"$f":"'5.1.1 Table 1 Services'!J27","v":0},{"$f":"'5.1.1 Table 1 Services'!K27","v":0},{"$f":"'5.1.1 Table 1 Services'!F27","v":0},{"$f":"'5.1.1 Table 1 Services'!L27","v":0}]
[2,"Training",{"$f":"'5.1.1 Table 1 Services'!J27","v":0},{"$f":"'5.1.1Table 2Training'!K23","v":0},{"$f":"'5.1.1Table 2Training'!F23","v":0},{"$f":"'5.1.1Table 2Training'!L23","v":0}]
[3,"OEM Fees",{"$f":"'5.1.1 Table 3 OEM Fees'!J25","v":0},{"$f":"'5.1.1 Table 3 OEM Fees'!K25","v":0},{"$f":"'5.1.1 Table 3 OEM Fees'!F25","v":0},{"$f":"'5.1.1 Table 3 OEM Fees'!L25","v":0}]
[null,"TOTAL PRICE EXCLUDING VAT",{"$f":"SUM(C10:C12)","v":0},{"$f":"SUM(D10:D12)","v":0},{"$f":"SUM(E10:E12)","v":0},{"$f":"SUM(F10:F12)","v":0},"Must agree with Price (Excl. VAT) on Tender Cover Page"]
[null,"SOUTH AFRICAN VAT - ON IMPORTED GOODS",{"$f":"C13*15%","v":0},{"$f":"D13*15%","v":0},{"$f":"E13*15%","v":0},{"$f":"F13*15%","v":0}," "]
[null,"TOTAL PRICES INCLUDING VAT",{"$f":"C13+C14","v":0},{"$f":"D13+D14","v":0},{"$f":"E13+E14","v":0},{"$f":"F13+F14","v":0},"Must agree with Price (Incl. VAT) on Tender Cover Page"]

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