{"text_format":"3","workbook":"xlsx","n_sheets":11,"sheets":["Tender Cover Sheet"," (PS5) ","5.1.1 Pricing schedule","Summary","5.1.2 CPA Formulae","5.1.4 PS5","5.1.2 CPA Formula","5.1.3  Exchange Rates","Transport and Offloading Matrix","Bharat's grouping -Hardware PS5","Categories- \"Type\""],"not_rendered":{"images":1,"external_links":7,"defined_names":373},"read":"whole","date_system":"1900"}

{"sheet":"Tender Cover Sheet","index":0,"n_rows":35,"n_cols":5,"rows_kept":35}
[]
[]
[null,null,"Enquiry No.","MWP2593TX"]
[null,null,"Package Name:","THE DESIGN, MANUFACTURE, TESTING, SUPPLY AND DELIVERY OF ESTIMATED QUANTITIES OF 400KV 400KN - 765KV COMPOSITE INSULATORS (LONG ROD) ON AN “AS AND WHEN” REQUIRED BASIS FOR A PERIOD OF 5 (FIVE) YEARS FOR TRANSMISSION DIVISION"]
[null,null,"Tenderer's Name:"]
[]
[]
[]
[]
[]
[]
[null,null,"PRICING INFORMATION"]
[]
[null,null,"RAND VALUE IN WORDS","[Price in Words]"," "]
[]
[]
[null,null,"TENDERED PRICE:  IN ZAR"]
[null,null,"(excluding VAT)"]
[]
[null,null,"TENDERED PRICE:  IN ZAR"]
[null,null,"(including VAT)"]
[]
[]
[]
[null,null,"DATE :"," "]
[]
[]
[null,null,"FULL NAMES OF SIGNATORY:"," "]
[]
[]
[null,null,"DESIGNATION OF SIGNATORY:"," "]
[]
[]
[null,null,"SIGNATURE :"]
[{"$nulls":4}," "]

{"sheet":" (PS5) ","index":1,"n_rows":97,"n_cols":20,"rows_kept":97,"merged":[[9,7,9,9],[10,10,12,10],[10,11,12,11],[10,12,12,12],[10,13,12,13],[10,14,12,14],[10,15,12,15],[10,16,12,16],[10,17,12,17],[10,18,12,18],[10,19,12,19],[11,7,11,9],[62,7,62,9],[63,10,65,10],[63,11,65,11],[63,12,65,12],[63,13,65,13],[63,14,65,14],[63,15,65,15],[63,16,65,16],[63,17,65,17],[63,18,65,18],[63,19,65,19],[64,7,64,9]]}
[]
[]
[null,"ENQUIRY NUMBER : ",{"$nulls":15},"SUPPLIER NAME:"]
[]
[null,"PRICE SCHEDULE : "]
[]
[null,"PRICE SCHEDULE FOR GOODS MANUFACTURED IN AND OUTSIDE THE R.S.A.  PRICE PER UNIT FOR SUPPLY, DELIVERY AND ERECTION / INSTALLATION.  ALL AMOUNTS EXPRESSED IN RANDS"]
[null,""]
[null," REMARKS",{"$nulls":5},"                       ITEM NO",null,null,1,2,3,4]
[{"$nulls":7},"SAP NO",null,null,{"$f":"'5.1.1 Pricing schedule'!C7","v":"TBA"},{"$f":"'5.1.1 Pricing schedule'!C8","v":600012},{"$f":"'5.1.1 Pricing schedule'!C9","v":600013},{"$f":"'5.1.1 Pricing schedule'!C10","v":600014}]
[null," *Eskom may effect this insurance which includes war",{"$nulls":8},{"$f":"'5.1.1 Pricing schedule'!D7","v":"INSUL: COMPOSITE 400kV 400kN 25mm/kV"},{"$f":"'5.1.1 Pricing schedule'!D8","v":"INSUL: COMPOSITE 400kV 400kN 31mm/kV"},{"$f":"'5.1.1 Pricing schedule'!D9","v":"INSUL: COMPOSITE 765kV 300kN 31mm/kV"},{"$f":"'5.1.1 Pricing schedule'!D10","v":"INSUL: COMPOSITE 765kV 400kN 31mm/kV"}]
[null,"   risk insurance",{"$nulls":5}," ITEM DESCRIPTION"]
[null,"**Please specify"]
[null,"SUPPLIED FROM OUTSIDE R.S.A.:",{"$nulls":7},"(In ZAR)"]
[null,"1: F.O.B. PRICE",{"$nulls":7},"(In ZAR)"]
[null,"2: COST OF SEA  FREIGHT",{"$nulls":7},"(In ZAR)"]
[null,"3: COST OF AIR  FREIGHT",{"$nulls":7},"(In ZAR)"]
[null,"4: COST OF MARINE INSURANCES *",{"$nulls":7},"(In ZAR)"]
[null,"5: TOTAL PRICE DELIVERED PORT R.S.A. ...",{"$nulls":5},"(1+2+3+4)",null,"(In ZAR)",{"$f":"SUM(K15:K18)","v":0},{"$f":"SUM(L15:L18)","v":0},0,0]
[null,"6: WHARFAGE",{"$nulls":7},"(In ZAR)"]
[null,"7: LANDING CHARGES",{"$nulls":7},"(In ZAR)"]
[null,"8: CUSTOMS DUTIES",{"$nulls":7},"(In ZAR)"]
[null,"9: IMPORT SURCHARGE",{"$nulls":7},"(In ZAR)"]
[null,"10: OTHER**",{"$nulls":7},"(In ZAR)"]
[null,"11: COST OF IMPORTATION ...",{"$nulls":5},"(6+7+8+9+10)",null,"(In ZAR)",{"$f":"SUM(K20:K24)","v":0},{"$f":"SUM(L20:L24)","v":0},{"$f":"SUM(M20:M24)","v":0},{"$f":"SUM(N20:N24)","v":0}]
[null,"12: COST OF RAIL TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
[null,"13: COST OF ROAD TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
[null,"14: TOTAL COST OF TRANSPORT S.A. PORT TO WORK/SITE ...",{"$nulls":5},"(12+13)",null,"(In ZAR)",{"$f":"SUM(K26:K27)","v":0},{"$f":"SUM(L26:L27)","v":0},0,0]
[null,"15: TOTAL PRICE (F.O.B.) DELIVERED TO WORKS/SITE...",{"$nulls":5},"(5+11+14)",null,"(In ZAR)",{"$f":"K19+K25+K28","v":0},{"$f":"L19+L25+L28","v":0},0,0]
[]
[null,"SUPPLIED FROM INSIDE R.S.A."]
[null,"16: F.O.R. PRICE-GOODS MANUFACTURED INSIDE R.S.A."]
[null,"17: F.O.R. PRICE-GOODS SUPPLIED FROM IMPORTED ITEMS"]
[null,"18: TOTAL F.O.R. PRICE ...",{"$nulls":5},"(16+17)",null,null,{"$f":"SUM(K32:K33)","v":0},{"$f":"SUM(L32:L33)","v":0},0,0]
[null,"19: COST OF RAIL TRANSPORT"]
[null,"20: COST OF ROAD TRANSPORT"]
[null,"21: COST OF TRANSPORT WORKS TO SITE ...          ",{"$nulls":5},"(19+20)",null,null,{"$f":"SUM(K35:K36)","v":0},{"$f":"SUM(L35:L36)","v":0},{"$f":"SUM(M35:M36)","v":0},0]
[null,"22: PRICE (F.O.R.) DELIVERED TO SITE ...          ",{"$nulls":5},"(18+21)",null,null,{"$f":"K34+K37","v":0},0,0,0]
[null,"SITE WORK (ERECTION / INSTALLATION INCL. COMMISSIONING) "]
[null,"23: LOCAL LABOUR"]
[null,"24: EXPATRIATE  LABOUR"]
[null,"25: TOTAL PRICE FOR SITE WORK ...          ",{"$nulls":5},"(23+24)",null,null,{"$f":"SUM(K40:K41)","v":0},{"$f":"SUM(L40:L41)","v":0},0,0]
[null,"26: OVERSEAS ENGINEERING SERVICES",{"$nulls":8},0,0,0,0]
[null,"27: LOCAL ENGINEERING SERVICES"]
[null,"28: TOTAL PRICE FOR ENGINEERING SERVICES...",{"$nulls":5},"(26+27)",null,null,{"$f":"SUM(K43:K44)","v":0},{"$f":"SUM(L43:L44)","v":0},0,0]
[null,"29: TOTAL PRICE EXCLUDING VAT",{"$nulls":8},{"$f":"K36+K42+K45+K29","v":0},{"$f":"L36+L42+L45+L29","v":0},{"$f":"M36+M42+M45+M29","v":0},0]
[null,"29. VAT AT 15%",{"$nulls":8},{"$f":"K46*0.15","v":0},{"$f":"L46*0.15","v":0},{"$f":"M46*0.15","v":0},{"$f":"N46*0.15","v":0}]
[null,"30: TOTAL  PRICE INCLUDING VAT",{"$nulls":5},"(27+36+46)",null,null,{"$f":"SUM(K46:K47)","v":0},{"$f":"SUM(L46:L47)","v":0},0,0]
[]
[null,"SIGNATURE...................................................................",{"$nulls":6},"CAPACITY........................................................................",{"$nulls":5},"DATE......................................................."]
[]
[]
[]
[]
[null,{"$f":"B3","v":"ENQUIRY NUMBER : "},null,{"$f":"D3","v":0},null,"                                      PRICES INCLUSIVE OF VAT (VALUE ADDED TAX)"]
[{"$nulls":17},"SUPPLIER NAME:",null,{"$f":"T3","v":0}]
[null,{"$f":"B5","v":"PRICE SCHEDULE : "}]
[]
[null,"PRICE SCHEDULE FOR GOODS MANUFACTURED OUTSIDE THE R.S.A.  PRICE PER UNIT FOR ENGINEERING, MANUFACTURE, SUPPLY AND DELIVERY.  ALL AMOUNTS EXPRESSED IN FOREIGN CURRENCY (UP TO LINE 49)."]
[]
[]
[null," REMARKS",{"$nulls":5},"                       ITEM NO",null,null,{"$f":"K9","v":1},2,3,4,0,0,0,0,0,0]
[{"$nulls":7},"SAP NO",null,null,{"$f":"K10","v":"TBA"},600012,600013,600014,0,0,0,0,0,0]
[null," *Eskom may effect this insurance which includes war",{"$nulls":8},{"$f":"K11","v":"INSUL: COMPOSITE 400kV 400kN 25mm/kV"},"INSUL: COMPOSITE 400kV 400kN 31mm/kV","INSUL: COMPOSITE 765kV 300kN 31mm/kV","INSUL: COMPOSITE 765kV 400kN 31mm/kV",0,0,0,0,0,0]
[null,"   risk insurance",{"$nulls":5}," ITEM DESCRIPTION"]
[null,"**Please specify"]
[null,"PRICE DELIVERED TO PORT R.S.A. (LINE 5)",{"$nulls":6},"(In Foreign Currency)"]
[null,"31: CURRENCY A   1 ZAR=",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[null,"32: CURRENCY B   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[null,"33: CURRENCY C   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
[null,"34: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"35: CURRENCY E   1 ZAR=............",null,null,"(INSURANCE)",{"$nulls":3},"(In Foreign Currency)"]
[null,"36: TOTAL F.O.B. PRICE ",{"$nulls":5},"(5=31+32+33+34+35)"]
[null,"PRICE EXPATRIATE LABOUR (LINE 25)",{"$nulls":6},"(In Foreign Currency)"]
[null,"37: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"38: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"39: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"40: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"41: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
[null,"42.TOTAL PRICE EXPATRIATE LABOUR ",{"$nulls":5},"(24=37+38+39+40+41)"]
[null,"PRICE OVERSEAS ENGINEERING SERVICES (LINE 27)",{"$nulls":6},"(In Foreign Currency)"]
[null,"43: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"44: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"45: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"46: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
[null,"47: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
[null,"48: TOTAL PRICE OVERSEAS ENGINEERING SERVICES (LINE 26) ",{"$nulls":6},"(26=43+44+45+46+47)"]
[null,"49: FOREIGN CONTENT OF TOTAL PRICE",{"$nulls":5},"(36+42+48)"]
[null,"LOCAL PREFERENCE FOR ELECTRONICS ONLY"]
[null,"50. FOR PRICE GOODS MANUFACTURED IN R.S.A. (LINE 16)"]
[null,"51. PRICE FOR LOCAL DESIGN / ENGINEERING SERVICES (LINE 27) "]
[null,"52. PERCENTAGE PREFERENCE CLAIMED (=................) ON LINE 50"]
[null,"53. PERCENTAGE PREFERENCE CLAIMED (=................) ON LINE 51"]
[null,"54. TOTAL AMOUNT CLAIMED ",null,null,"(52 + 53)"]
[]
[]
[null,"SIGNATURE...................................................................",{"$nulls":6},"CAPACITY........................................................................",{"$nulls":5},"DATE......................................................."]

{"sheet":"5.1.1 Pricing schedule","index":2,"n_rows":10,"n_cols":24,"rows_kept":10,"merged":[[2,1,2,5],[2,6,2,14],[2,16,2,22],[2,23,4,23],[3,6,3,7],[3,8,3,9],[3,10,3,11],[3,12,3,13],[3,14,4,14],[3,16,3,17],[3,18,3,19],[3,20,3,21],[3,22,4,22]]}
[]
[null,"COMPOSITE INSULATOR"]
[null,"Long Rods 400kV 400kN- 765kV",{"$nulls":14},"SUPPLIED FROM INSIDE R.S.A.",{"$nulls":6},"TOTAL PRICE- LOCAL + FOREGN"]
[null,"ITEM","SAP NO.","DESCRIPTION","Unit","QTY",{"$f":"' (PS5) '!B15","v":"1: F.O.B. PRICE"},null,"2: COST OF  FREIGHT SEA/AIR",null,{"$f":"' (PS5) '!B25","v":"11: COST OF IMPORTATION ..."},null,{"$f":"' (PS5) '!B28","v":"14: TOTAL COST OF TRANSPORT S.A. PORT TO WORK/SITE ..."},null,"TOTALPRICE",null,"18: TOTAL F.O.R. PRICE ...",null,"LABOUR",null,"TRANSPORT",null,"TOTAL PRICE"]
[{"$nulls":6},"Unit Price"," Total Price ","Unit Price"," Total Price ","Unit Price"," Total Price "," Unit Price "," Total Price ",null,null," Unit Price ","Total "," Unit Price ","Total "," Unit Price ","Total "]
[]
[null,1,"TBA","INSUL: COMPOSITE 400kV 400kN 25mm/kV","No",100,null,{"$f":"G7*F7","v":0},null,{"$f":"I7*F7","v":0},null,{"$f":"K7*F7","v":0},null,{"$f":"M7*F7","v":0},{"$f":"H7+J7+L7+N7","v":{"v":0,"d":"R0.00"}},null,null,{"$f":"Q7*F7","v":0},null,{"$f":"S7*F7","v":0},null,{"$f":"U7*F7","v":0},{"$f":"V7+T7+R7","v":0},{"$f":"O7+W7","v":0}]
[null,2,600012,"INSUL: COMPOSITE 400kV 400kN 31mm/kV","No",100,{"$nulls":8},{"$f":"H8+J8+L8+N8","v":{"v":0,"d":"R0.00"}},{"$nulls":8},{"$f":"O8+W8","v":0}]
[null,3,600013,"INSUL: COMPOSITE 765kV 300kN 31mm/kV","No",100,{"$nulls":8},{"v":0,"d":"R0.00"}]
[null,4,600014,"INSUL: COMPOSITE 765kV 400kN 31mm/kV","No",100,{"$nulls":8},{"v":0,"d":"R0.00"}]

{"sheet":"Summary","index":3,"n_rows":14,"n_cols":7,"rows_kept":14,"merged":[[1,3,1,5],[2,3,2,5],[3,3,3,5],[6,1,6,3],[6,4,6,6],[7,1,8,1],[7,2,8,2],[11,1,11,5],[12,1,12,5],[13,1,13,5]]}
[]
[null,null,"Enquiry No.",{"$f":"'Tender Cover Sheet'!D3","v":"MWP2593TX"}]
[null,null,"Package Name:",{"$f":"'Tender Cover Sheet'!D4","v":"THE DESIGN, MANUFACTURE, TESTING, SUPPLY AND DELIVERY OF ESTIMATED QUANTITIES OF 400KV 400KN - 765KV COMPOSITE INSULATORS (LONG ROD) ON AN “AS AND WHEN” REQUIRED BASIS FOR A PERIOD OF 5 (FIVE) YEARS FOR TRANSMISSION DIVISION"}]
[null,null,"Tenderer's Name:",{"$f":"'Tender Cover Sheet'!D5","v":0}]
[]
[]
[null,"SUMMARY",null,null,"All prices in ZAR"]
[null,"Item No.","DESCRIPTION","Total Foreign Currency","Total Foreign Currency","Total Local Currency","Total Tendered Value "]
[{"$nulls":3},"FC","ZAR","ZAR","ZAR"]
[null,1,"LONG ROD ",{"$nulls":3},{"$f":"E10+F10","v":{"v":0,"d":"R0.00"}}]
[{"$nulls":6},{"$f":"E11+F11","v":{"v":0,"d":"R0.00"}}]
[null,"TOTAL EXCL VAT",{"$nulls":4},{"$f":"SUM(G10:G11)","v":{"v":0,"d":"R0.00"}}]
[null,"ADD VAT AT 15%",{"$nulls":3},"ADDED VAT",{"$f":"G12*0.15","v":{"v":0,"d":"R0.00"}}]
[null,"TOTAL INCL VAT",{"$nulls":4},{"$f":"SUM(G12:G13)","v":{"v":0,"d":"R0.00"}}]

{"sheet":"5.1.2 CPA Formulae","index":4,"n_rows":254,"n_cols":8,"rows_kept":254,"hidden":true,"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,28,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],[17,3,17,5],[18,3,18,5],[26,3,26,5],[27,3,27,5],[28,3,28,5],[31,2,31,7],[32,2,32,7],[35,2,35,7],[36,2,36,7],[37,2,37,7],[39,1,39,7],[40,2,40,7],[41,2,41,7],[42,2,42,7],[43,2,43,7],[44,2,44,7],[45,2,45,7],[46,2,46,7],[47,2,47,7],[49,2,49,7],[60,2,60,7],[71,2,71,7],[82,2,82,7],[93,2,93,7],[104,2,104,7],[115,2,115,7],[126,2,126,7],[137,2,137,7],[148,2,148,7],[159,2,159,7],[170,2,170,7],[180,2,180,7],[191,2,191,7],[202,2,202,7],[213,2,213,7],[224,2,224,7],[235,2,235,7],[245,2,245,7]]}
[]
[null,null,"Enquiry No."]
[null,null,"Package Name:"]
[null,null,"Tenderer's Name:",{"$f":"'[1]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,1,"Fixed & Firm",{"$nulls":3},"Prices are 100 % fixed and firm. CPA is not applicable. Note( Cell B9 must be a blank cell)."]
[null,2,"A",{"$f":"C72","v":"Tenderer's description of Formula A- "},null,null,"Type in the description of each formula in the tables below"]
[null,3,"B",{"$f":"C83","v":"Tenderer's description of Formula B"}]
[null,4,"C",{"$f":"C94","v":"Tenderer's description of Formula C"}]
[null,5,"D",{"$f":"C105","v":"Tenderer's description of Formula D"}]
[null,6,"E",{"$f":"C116","v":"Tenderer's description of Formula E"}]
[null,7,"F",{"$f":"C127","v":"Tenderer's description of Formula F"}]
[null,8,"G",{"$f":"C138","v":"Tenderer's description of Formula G"}]
[null,9,"H",{"$f":"C149","v":"Tenderer's description of Formula H"}]
[null,10,"I",{"$f":"C160","v":"Tenderer's description of Formula I"}]
[null,11,"J",{"$f":"C171","v":"Tenderer's description of Formula J"}]
[null,12,"K",{"$f":"C181","v":"Tenderer's description of Formula K"}]
[null,13,"L",{"$f":"C192","v":"Tenderer's description of Formula L"}]
[null,14,"M",{"$f":"C203","v":"Tenderer's description of Formula M"}]
[null,15,"N",{"$f":"C214","v":"Tenderer's description of Formula N"}]
[null,16,"O",{"$f":"C225","v":"Tenderer's description of Formula O"}]
[null,17,"P",{"$f":"C236","v":"Tenderer's description of Formula P"}]
[null,18,"Q",{"$f":"C246","v":"Tenderer's description of Formula Q"}]
[null,19,"Ex -Local","Example of Local CPA description for Transformer"]
[null,20,"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.15,"d":"15%"},"Labour","C3- All hourly-paid employees","SEIFSA","2018-01-01"]
[null,"J2",{"v":0.2,"d":"20%"},"Transformer","J3- ETSA Distribution Transformer ","SEIFSA","2018-01-01"]
[null,"J3",{"v":0.2,"d":"20%"},"Copper","F- Metric ton","SEIFSA","2018-01-01"]
[null,"J4",{"v":0.3,"d":"30%"},"Steel","E-EX Plates HR Grade S355JR","SEIFSA","2018-01-01"]
[null,"J5"," "]
[null,"J6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C52:C57)","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%"},"transformer","Large Power Transformer","BEMA","2018-01-01"]
[null,"J2"," ",{"$nulls":3},"2018-01-01"]
[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(C63:C68)","v":{"v":1,"d":"100%"}},"Total"]
[]
[]
[null,"Formula A","Tenderer's description of Formula A- "]
[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,"A1"," "]
[null,"A2"," "]
[null,"A3"," "]
[null,"A4"," "]
[null,"A5"," "]
[null,"A6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C74:C79)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula B","Tenderer's description of Formula B"]
[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,"B1"," "]
[null,"B2"," "]
[null,"B3"," "]
[null,"B4"," "]
[null,"B5"," "]
[null,"B6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C85:C90)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula C","Tenderer's description of Formula C"]
[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,"C1"," "," "," "," "," "," "]
[null,"C2"," "]
[null,"C3"," "]
[null,"C4"," "]
[null,"C5"," "]
[null,"C6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C96:C101)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula D","Tenderer's description of Formula D"]
[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,"D1"," "]
[null,"D2"," "]
[null,"D3"," "]
[null,"D4"," "]
[null,"D5"," "]
[null,"D6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C107:C112)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula E","Tenderer's description of Formula E"]
[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,"E1"," "]
[null,"E2"," "]
[null,"E3"," "]
[null,"E4"," "]
[null,"E5"," "]
[null,"E6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C118:C123)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula F","Tenderer's description of Formula F"]
[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,"F1"," "]
[null,"F2"," "]
[null,"F3"," "]
[null,"F4"," "]
[null,"F5"," "]
[null,"F6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C129:C134)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula G","Tenderer's description of Formula G"]
[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,"G1"," "]
[null,"G2"," "]
[null,"G3"," "]
[null,"G4"," "]
[null,"G5"," "]
[null,"G6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C140:C145)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula H","Tenderer's description of Formula H"]
[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,"H1"," "]
[null,"H2"," "]
[null,"H3"," "]
[null,"H4"," "]
[null,"H5"," "]
[null,"H6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C151:C156)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula I","Tenderer's description of Formula I"]
[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,"I1"," "]
[null,"I2"," "]
[null,"I3"," "]
[null,"I4"," "]
[null,"I5"," "]
[null,"I6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C162:C167)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula J","Tenderer's description of Formula J"]
[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"," "]
[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(C173:C178)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[null,"Formula K","Tenderer's description of Formula K"]
[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,"E1"," "]
[null,"E2"," "]
[null,"E3"," "]
[null,"E4"," "]
[null,"E5"," "]
[null,"E6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C183:C188)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula L","Tenderer's description of Formula L"]
[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,"F1"," "]
[null,"F2"," "]
[null,"F3"," "]
[null,"F4"," "]
[null,"F5"," "]
[null,"F6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C194:C199)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula M","Tenderer's description of Formula M"]
[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,"G1"," "]
[null,"G2"," "]
[null,"G3"," "]
[null,"G4"," "]
[null,"G5"," "]
[null,"G6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C205:C210)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula N","Tenderer's description of Formula N"]
[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,"H1"," "]
[null,"H2"," "]
[null,"H3"," "]
[null,"H4"," "]
[null,"H5"," "]
[null,"H6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C216:C221)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula O","Tenderer's description of Formula O"]
[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,"I1"," "]
[null,"I2"," "]
[null,"I3"," "]
[null,"I4"," "]
[null,"I5"," "]
[null,"I6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C227:C232)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[]
[null,"Formula P","Tenderer's description of Formula P"]
[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"," "]
[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(C238:C243)","v":{"v":0.15,"d":"15%"}},"Total"]
[]
[null,"Formula Q","Tenderer's description of Formula Q"]
[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"," "]
[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(C248:C253)","v":{"v":0.15,"d":"15%"}},"Total"]

{"sheet":"5.1.4 PS5","index":5,"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":"#REF!","v":{"$error":"#REF!"}}]
["Package Name:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Tenderer's Name:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
["Category of Offer:",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[]
["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.2 CPA Formula","index":6,"n_rows":148,"n_cols":15,"rows_kept":148,"merged":[[1,1,1,2],[1,3,1,5],[2,1,2,2],[2,3,2,5],[3,1,3,2],[3,3,3,5],[5,1,5,5],[8,3,8,4],[8,6,8,8],[9,3,9,5],[9,6,18,8],[10,3,10,5],[11,3,11,5],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[16,3,16,5],[17,3,17,5],[18,3,18,5],[21,2,21,7],[22,2,22,7],[25,2,25,7],[26,2,26,7],[27,2,27,7],[28,2,28,7],[29,2,29,7],[30,2,30,7],[32,2,32,7],[33,2,33,7],[34,2,34,7],[35,2,35,7],[36,2,36,7],[40,2,40,7],[51,2,51,7],[62,2,62,7],[73,2,73,7],[84,2,84,7],[95,2,95,7],[106,2,106,7],[117,2,117,7],[128,2,128,7],[139,2,139,7]]}
[]
[null,"Enquiry No.",null,{"$f":"'Tender Cover Sheet'!D3","v":"MWP2593TX"}]
[null,"Package Name:",null,{"$f":"'Tender Cover Sheet'!D4","v":"THE DESIGN, MANUFACTURE, TESTING, SUPPLY AND DELIVERY OF ESTIMATED QUANTITIES OF 400KV 400KN - 765KV COMPOSITE INSULATORS (LONG ROD) ON AN “AS AND WHEN” REQUIRED BASIS FOR A PERIOD OF 5 (FIVE) YEARS FOR TRANSMISSION DIVISION"}]
[null,"Tenderer's Name:",null,{"$f":"'Tender Cover Sheet'!D5","v":0}]
[]
[null,"CONTRACT PRICE ADJUSTMENT (CPA) FOR INFLATION"]
[]
[null,"No.","Formula Code","Summary of the description of the Tenderer's Formulae"]
[null,1,"Fixed","Firm and Fixed and Firm for the full duration of Contract",null,null,"Prices are 100 % fixed and firm. CPA is not applicable. "]
[null,2,"A",{"$f":"C41","v":"Tenderer's description of Formula A"},null,null,"Type in the description of each formula in the tables below"]
[null,3,"B",{"$f":"C52","v":"Tenderer's description of Formula B"}]
[null,4,"C",{"$f":"C63","v":"Tenderer's description of Formula C"}]
[null,5,"D",{"$f":"C74","v":"Tenderer's description of Formula D"}]
[null,6,"E",{"$f":"C85","v":"Tenderer's description of Formula E"}]
[null,7,"F",{"$f":"C96","v":"Tenderer's description of Formula F"}]
[null,8,"G",{"$f":"C107","v":"Tenderer's description of Formula G"}]
[null,9,"H",{"$f":"C118","v":"Tenderer's description of Formula H"}]
[null,10,"I",{"$f":"C129","v":"Tenderer's description of Formula I"}]
[null,11,"J",{"$f":"C140","v":"Tenderer's description of Formula J"}]
[]
[null,"SPECIFIC REQUIREMENTS"]
[null,{"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."]
[null,{"v":2,"d":"2."},"No ALTERNATIVE offers are accepted."]
[]
[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,"The worksheet  CPA Formula in PS5 Summary has to be populated by the tenderer (Row 9:9), 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"]
[null,4,"CPA Formulae Codes B8:B19 above is to be populated by the tenderer in the \"PS5 Summary\" tab, row 9:9, by selecting the respecting the correct formula code from the dropdown list as developed by Tenderer hereunder. Codes and descriptions must be selected by the tenderer and inserted into each row of activity. "]
[null,5,"CPA will kick in after sixteen (16) months from the contract base date (contract base date is one month prior to enquiry closing), for commodities with prices that are less volatile. The sixteen months comprises of one (1) month prior to enquiry closing, three (3) months normal tender validity period as prescribed by the CIDB Act, and the twelve (12) months being the first twelve (12) months of the contract period."]
[null,6,"The CPA escalation will be calculated as follows: The base date for CPA calculation purposes will be one month prior to enquiry closing or as agreed to between the parties (if there is a need to move the base date during contract negotiations). The latest / ruling index used for CPA calculation purposes will be aligned to the delivery dates of the equipment on the assessment for payment on a particular payment certificate month."]
[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%.  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," "," "]
[]
[]
[null,"Formula A","Tenderer's description of Formula A"]
[null,"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"]
[null,"A1",{"v":0.85,"d":"85%"},"C3A"]
[null,"A2"]
[null,"A3"]
[null,"A4"," "]
[null,"A5"]
[null,"A6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C43:C48)","v":{"v":1,"d":"100%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula B","Tenderer's description of Formula B"]
[null,"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"]
[null,"B1"]
[null,"B2"," "]
[null,"B3"]
[null,"B4"," "]
[null,"B5"," "]
[null,"B6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C54:C59)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula C","Tenderer's description of Formula C"]
[null,"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"]
[null,"C1",{"$nulls":4}," "," "," "]
[null,"C2"," "]
[null,"C3"]
[null,"C4"," "]
[null,"C5"," "]
[null,"C6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C65:C70)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula D","Tenderer's description of Formula D"]
[null,"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"]
[null,"D1"," "]
[null,"D2"," "]
[null,"D3"]
[null,"D4"," "]
[null,"D5"," "]
[null,"D6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C76:C81)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula E","Tenderer's description of Formula E"]
[null,"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"]
[null,"E1"," "]
[null,"E2"," "]
[null,"E3"]
[null,"E4"," "]
[null,"E5"," "]
[null,"E6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C87:C92)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula F","Tenderer's description of Formula F"]
[null,"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"]
[null,"F1"]
[null,"F2"]
[null,"F3"]
[null,"F4"]
[null,"F5"]
[null,"F6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C98:C103)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula G","Tenderer's description of Formula G"]
[null,"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"]
[null,"G1"," "]
[null,"G2"," "]
[null,"G3"," "]
[null,"G4"]
[null,"G5"," "]
[null,"G6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C109:C114)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula H","Tenderer's description of Formula H"]
[null,"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"]
[null,"H1"," "]
[null,"H2"," "]
[null,"H3"," "]
[null,"H4"," "]
[null,"H5"," "]
[null,"H6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C120:C125)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula I","Tenderer's description of Formula I"]
[null,"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"]
[null,"I1"," "]
[null,"I2"," "]
[null,"I3"," "]
[null,"I4"]
[null,"I5"," "]
[null,"I6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,null,{"$f":"SUM(C131:C136)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
[null,"Formula J","Tenderer's description of Formula J"]
[null,"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"]
[null,"J1"," "]
[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(C142:C147)","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.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.",{"$f":"'Tender Cover Sheet'!D3","v":"MWP2593TX"}]
[null,null,"Package Name:",{"$f":"'Tender Cover Sheet'!D4","v":"THE DESIGN, MANUFACTURE, TESTING, SUPPLY AND DELIVERY OF ESTIMATED QUANTITIES OF 400KV 400KN - 765KV COMPOSITE INSULATORS (LONG ROD) ON AN “AS AND WHEN” REQUIRED BASIS FOR A PERIOD OF 5 (FIVE) YEARS FOR TRANSMISSION DIVISION"}]
[null,null,"Tenderer's Name:",{"$f":"'Tender Cover Sheet'!D5","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",{"v":0,"d":"0.0000"}]
[null,{"$f":"B23+1","v":2},"Canadian Dollar","CAN",{"v":0,"d":"0.0000"}]
[null,{"$f":"B24+1","v":3},"Swiss Franc","CHF",{"v":0,"d":"0.0000"}]
[null,{"$f":"B25+1","v":4},"Danish Krone","DKK",{"v":0,"d":"0.0000"}]
[null,5,"European Currency","EUR",{"v":0,"d":"0.0000"}]
[null,6,"British Pound","GBP",{"v":0,"d":"0.0000"}]
[null,7,"Hong Kong Dollar","HKD",{"v":0,"d":"0.0000"}]
[null,8,"Japanese Yen","JPY",{"v":0,"d":"0.0000"}]
[null,9,"Norwegian Krone","NOK",{"v":0,"d":"0.0000"}]
[null,10,"New Zealand Dollar","NZD",{"v":0,"d":"0.0000"}]
[null,11,"Swedish Krone","SEK",{"v":0,"d":"0.0000"}]
[null,12,"Singapore Dollar","SGD",{"v":0,"d":"0.0000"}]
[null,13,"United States Dollar","USD",{"v":0,"d":"0.0000"}]
[null,14,"South African Rand","ZAR",{"v":0,"d":"0.0000"}]
[null,15,"Example Purposes European Currency  (EURO for this example)","EURO",{"v":14.22,"d":"14.2200"},{"$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"}}," "]

{"sheet":"Transport and Offloading Matrix","index":8,"n_rows":34,"n_cols":12,"rows_kept":34,"merged":[[0,0,0,11],[2,0,3,4],[2,5,3,11],[4,0,5,4],[4,5,5,11],[6,0,7,4],[6,5,7,11],[8,0,11,0],[8,1,11,1],[8,2,8,11],[9,2,9,11],[10,2,10,11],[33,0,33,11],[34,0,34,11],[35,0,35,11],[36,0,36,11]]}
["TRANSPORT AND OFF LOADING COSTS"]
[]
[" ENQUIRY NO"]
[]
["COMMODITY",{"$nulls":4},"400kV 400kN - 765kV Composite Insulators (Long Rods)"]
[]
["SUPPLIER"]
[]
["Item","Round Trip Distance [km]","Prices in South African Currency (Excluding VAT)"]
[null,null,"Transport to site or regional store and off-loading"]
[null,null,"Total Units [No]"]
[null,null,"0-10","11 - 20","21 - 30","31 - 40","41 - 50","51 - 60","61-70","71 - 80","81 - 90","91 - 100"]
[1,"0 - 100"]
[2,"101 - 200"]
[3,"201 - 300"]
[4,"301 - 400"]
[5,"401 - 500"]
[6,"501 - 600"]
[7,"601 - 700"]
[8,"701 - 800"]
[9,"801 - 900"]
[10,"901 - 1000"]
[11,"1001 - 1100"]
[12,"1101 - 1200"]
[13,"1201 - 1300"]
[14,"1301 - 1400"]
[15,"1401 - 1500"]
[16,"1501 - 2000"]
[17,"2001 - 2500"]
[18,"2501 - 3000"]
[19,"3001 - 3500"]
[]
[]
["COMMENTS:"]

{"sheet":"Bharat's grouping -Hardware PS5","index":9,"n_rows":112,"n_cols":8,"rows_kept":112,"hidden":true}
[]
[]
[{"$nulls":3},"10KA GROUPING"]
[]
[null,null,"ITEM NO","DESCRIPTION","GROUPING","QTY","RATE","AMOUNT"]
[null,2,1,"Insulated Strain Assembly complete with insulator","10KA",{"v":240,"d":"240.00"},{"v":1566.26,"d":"R 1,566.26"},{"$f":"F6*G6","v":{"v":375902.4,"d":"R375,902.40"}}]
[null,8,2,"Non-Insulated Strain Assembly complete with earthbonds","10KA",{"v":240,"d":"240.00"},{"v":1280.11,"d":"R 1,280.11"},{"$f":"F7*G7","v":{"v":307226.39999999997,"d":"R307,226.40"}}]
[null,14,3,"Non-Insulated Suspension Assembly for self-supporting tower- landing plate orientation 90 degrees to conductor, complete with earthbonds","10KA",{"v":14.4,"d":"14.40"},{"v":894.2700000000001,"d":"R 894.27"},{"v":12877.488000000001,"d":"R12,877.49"}]
[null,20,4,"Non-Insulated Suspension Assembly for self-supporting tower-landing plate orientation 0 degrees to conductor, complete with earthbonds.","10KA",{"v":136,"d":"136.00"},{"v":963.98,"d":"R 963.98"},{"v":131101.28,"d":"R131,101.28"}]
[null,26,5,"Insulated Suspension Assembly for self-supporting tower- landing plate orientation 90 degrees to conductor complete with insulator.","10KA",{"v":30,"d":"30.00"},{"v":1633.0700000000002,"d":"R 1,633.07"},{"v":48992.100000000006,"d":"R48,992.10"}]
[null,32,6,"Insulated Suspension Assembly for self-supporting tower-landing plate orientation 0 degrees to conductor, complete with insulator.","10KA",{"v":57.6,"d":"57.60"},{"v":1718.6399999999999,"d":"R 1,718.64"},{"v":98993.66399999999,"d":"R98,993.66"}]
[null,38,7,"Insulated Strain Assembly for Joint-complete with earths and insulator","10KA",{"v":14.285714285714286,"d":"14.29"},{"v":1582.5500000000002,"d":"R 1,582.55"},{"v":22607.857142857145,"d":"R22,607.86"}]
[null,44,8," Non-Insulated Strain Assembly for Joint-complete with earths.","10KA",{"v":53,"d":"53.00"},{"v":1280.11,"d":"R 1,280.11"},{"v":67845.83,"d":"R67,845.83"}]
[null,50,9,"Assembly for crossrope towers.-Insulated (With post insulator)","10KA",{"v":108,"d":"108.00"},{"v":3403.89,"d":"R 3,403.89"},{"v":367620.12,"d":"R367,620.12"}]
[null,56,10,"Assembly for crossrope towers - Non-Insulated (Same as non-insulated suspension but with long bolts and spacers)","10KA",{"v":108,"d":"108.00"},{"v":1294.93,"d":"R 1,294.93"},{"v":139852.44,"d":"R139,852.44"}]
[null,62,11,"Assembly for crossrope towers - Non-Insulated post type.","10KA",{"v":108,"d":"108.00"},{"v":1294.93,"d":"R 1,294.93"},{"v":139852.44,"d":"R139,852.44"}]
[null,68,12,"Non-Insulated assembly for conversion of suspension tower to non-insulated joint position.","10KA",{"v":14.285714285714286,"d":"14.29"},{"v":2877.7799999999997,"d":"R 2,877.78"},{"v":41111.142857142855,"d":"R41,111.14"}]
[null,74,13,"Insulated Assembly for conversion of suspension tower to insulated joint position.","10KA",{"v":14.285714285714286,"d":"14.29"},{"v":3760.3199999999997,"d":"R 3,760.32"},{"v":53718.857142857145,"d":"R53,718.86"}]
[null,80,14,"Vibration dampers - Stockbridge preformed type.","10KA",{"v":2400,"d":"2400.00"},{"v":421.74,"d":"R 421.74"},{"v":1012176,"d":"R1,012,176.00"}]
[null,98,15,"Down lead clamps non-insulated","10KA",{"v":571.4285714285714,"d":"571.43"},{"v":308.12,"d":"R 308.12"},{"v":176068.57142857145,"d":"R176,068.57"}]
[null,104,16,"Down lead clamps insulated","10KA",{"v":571.4285714285714,"d":"571.43"},{"v":333.71,"d":"R 333.71"},{"v":190691.42857142855,"d":"R190,691.43"}]
[null,134,17,"1m Earthbonds  with two lugs per m","10KA",{"v":250,"d":"250.00"},{"v":195.89,"d":"R 195.89"},{"v":48972.5,"d":"R48,972.50"}]
[null,140,18,"Earthbonds  with two  transfer saddles per m","10KA",{"v":771,"d":"771.00"},{"v":541.8237274953077,"d":"R 541.82"},{"v":417746.0938988822,"d":"R417,746.09"}]
[null,146,19,"Earthbonds  with one lug and one transfer saddle per m","10KA",{"v":200,"d":"200.00"},{"v":427.99148801879346,"d":"R 427.99"},{"v":85598.29760375869,"d":"R85,598.30"}]
[]
[{"$nulls":3},"12KA GROUPING"]
[]
[null,3,1,"Insulated Strain Assembly complete with insulator","12KA",{"v":2707.2000000000003,"d":"2707.20"},{"v":1806.19,"d":"R 1,806.19"},{"$f":"F28*G28","v":{"v":4889717.568000001,"d":"R4,889,717.57"}}]
[null,9,2,"Non-Insulated Strain Assembly complete with earthbonds","12KA",{"v":2707.2000000000003,"d":"2707.20"},{"v":1533.06,"d":"R 1,533.06"},{"v":4150300.032,"d":"R4,150,300.03"}]
[null,15,3,"Non-Insulated Suspension Assembly for self-supporting tower- landing plate orientation 90 degrees to conductor, complete with earthbonds","12KA",{"v":162.43200000000002,"d":"162.43"},{"v":987.14,"d":"R 987.14"},{"v":160343.12448000003,"d":"R160,343.12"}]
[null,21,4,"Non-Insulated Suspension Assembly for self-supporting tower-landing plate orientation 0 degrees to conductor, complete with earthbonds.","12KA",{"v":838,"d":"838.00"},{"v":1056.9099999999999,"d":"R 1,056.91"},{"v":885690.5799999998,"d":"R885,690.58"}]
[null,27,5,"Insulated Suspension Assembly for self-supporting tower- landing plate orientation 90 degrees to conductor complete with insulator.","12KA",{"v":162.43200000000002,"d":"162.43"},{"v":1746.98,"d":"R 1,746.98"},{"v":283765.45536,"d":"R283,765.46"}]
[null,33,6,"Insulated Suspension Assembly for self-supporting tower-landing plate orientation 0 degrees to conductor, complete with insulator.","12KA",{"v":649.7280000000001,"d":"649.73"},{"v":1832.52,"d":"R 1,832.52"},{"v":1190639.55456,"d":"R1,190,639.55"}]
[null,39,7,"Insulated Strain Assembly for Joint-complete with earths and insulator","12KA",{"v":161.14285714285714,"d":"161.14"},{"v":1822.48,"d":"R 1,822.48"},{"v":293679.6342857143,"d":"R293,679.63"}]
[null,45,8," Non-Insulated Strain Assembly for Joint-complete with earths.","12KA",{"v":394,"d":"394.00"},{"v":1533.06,"d":"R 1,533.06"},{"v":604025.64,"d":"R604,025.64"}]
[null,51,9,"Assembly for crossrope towers.-Insulated (With post insulator)","12KA",{"v":1218.2399999999998,"d":"1218.24"},{"v":3518.46,"d":"R 3,518.46"},{"v":4286328.710399999,"d":"R4,286,328.71"}]
[null,57,10,"Assembly for crossrope towers - Non-Insulated (Same as non-insulated suspension but with long bolts and spacers)","12KA",{"v":1218.2399999999998,"d":"1218.24"},{"v":1764.64,"d":"R 1,764.64"},{"v":2149755.0335999997,"d":"R2,149,755.03"}]
[null,63,11,"Assembly for crossrope towers - Non-Insulated post type.","12KA",{"v":1218.2399999999998,"d":"1218.24"},{"v":1667.8200000000002,"d":"R 1,667.82"},{"v":2031805.0368,"d":"R2,031,805.04"}]
[null,69,12,"Non-Insulated assembly for conversion of suspension tower to non-insulated joint position.","12KA",{"v":161.14285714285714,"d":"161.14"},{"v":3383.67,"d":"R 3,383.67"},{"v":545254.2514285714,"d":"R545,254.25"}]
[null,75,13,"Insulated Assembly for conversion of suspension tower to insulated joint position.","12KA",{"v":161.14285714285714,"d":"161.14"},{"v":4164.32,"d":"R 4,164.32"},{"v":671050.4228571428,"d":"R671,050.42"}]
[null,81,14,"Vibration dampers - Stockbridge preformed type.","12KA",{"v":27072,"d":"27072.00"},{"v":424.52,"d":"R 424.52"},{"v":11492605.44,"d":"R11,492,605.44"}]
[null,99,15,"Down lead clamps non-insulated","12KA",{"v":9654,"d":"9654.00"},{"v":308.12,"d":"R 308.12"},{"v":2974590.48,"d":"R2,974,590.48"}]
[null,105,16,"Down lead clamps insulated","12KA",{"v":6445.714285714285,"d":"6445.71"},{"v":388.04,"d":"R 388.04"},{"v":2501194.9714285713,"d":"R2,501,194.97"}]
[null,135,17,"1m Earthbonds  with two lugs per m","12KA",{"v":300,"d":"300.00"},{"v":195.89,"d":"R 195.89"},{"v":58766.99999999999,"d":"R58,767.00"}]
[null,141,18,"Earthbonds  with two  transfer saddles per m","12KA",{"v":200,"d":"200.00"},{"v":541.8237274953077,"d":"R 541.82"},{"v":108364.74549906154,"d":"R108,364.75"}]
[null,147,19,"Earthbonds  with one lug and one transfer saddle per m","12KA",{"v":200,"d":"200.00"},{"v":427.99148801879346,"d":"R 427.99"},{"v":85598.29760375869,"d":"R85,598.30"}]
[]
[]
[{"$nulls":3},"16KA GROUPING"]
[null,4,1,"Insulated Strain Assembly complete with insulator","16KA",{"v":1224,"d":"1224.00"},{"v":1952.42,"d":"R 1,952.42"},{"$f":"F50*G50","v":{"v":2389762.08,"d":"R2,389,762.08"}}]
[null,10,2,"Non-Insulated Strain Assembly complete with earthbonds","16KA",{"v":1224,"d":"1224.00"},{"v":1687.22,"d":"R 1,687.22"},{"v":2065157.28,"d":"R2,065,157.28"}]
[null,16,3,"Non-Insulated Suspension Assembly for self-supporting tower- landing plate orientation 90 degrees to conductor, complete with earthbonds","16KA",{"v":73.44000000000001,"d":"73.44"},{"v":1587.08,"d":"R 1,587.08"},{"v":116555.15520000001,"d":"R116,555.16"}]
[null,22,4,"Non-Insulated Suspension Assembly for self-supporting tower-landing plate orientation 0 degrees to conductor, complete with earthbonds.","16KA",{"v":1269,"d":"1269.00"},{"v":1657.1899999999998,"d":"R 1,657.19"},{"v":2102974.11,"d":"R2,102,974.11"}]
[null,28,5,"Insulated Suspension Assembly for self-supporting tower- landing plate orientation 90 degrees to conductor complete with insulator.","16KA",{"v":73.44000000000001,"d":"73.44"},{"v":2482.73,"d":"R 2,482.73"},{"v":182331.69120000003,"d":"R182,331.69"}]
[null,34,6,"Insulated Suspension Assembly for self-supporting tower-landing plate orientation 0 degrees to conductor, complete with insulator.","16KA",{"v":293.76000000000005,"d":"293.76"},{"v":2568.27,"d":"R 2,568.27"},{"v":754454.9952000001,"d":"R754,455.00"}]
[null,40,7,"Insulated Strain Assembly for Joint-complete with earths and insulator","16KA",{"v":186,"d":"186.00"},{"v":1960.17,"d":"R 1,960.17"},{"v":364591.62,"d":"R364,591.62"}]
[null,46,8," Non-Insulated Strain Assembly for Joint-complete with earths.","16KA",{"v":417,"d":"417.00"},{"v":1687.22,"d":"R 1,687.22"},{"v":703570.74,"d":"R703,570.74"}]
[null,52,9,"Assembly for crossrope towers.-Insulated (With post insulator)","16KA",{"v":550.8,"d":"550.80"},{"v":3557.23,"d":"R 3,557.23"},{"v":1959322.2839999998,"d":"R1,959,322.28"}]
[null,58,10,"Assembly for crossrope towers - Non-Insulated (Same as non-insulated suspension but with long bolts and spacers)","16KA",{"v":550.8,"d":"550.80"},{"v":1835.67,"d":"R 1,835.67"},{"v":1011087.036,"d":"R1,011,087.04"}]
[null,64,11,"Assembly for crossrope towers - Non-Insulated post type.","16KA",{"v":550.8,"d":"550.80"},{"v":1543.67,"d":"R 1,543.67"},{"v":850253.436,"d":"R850,253.44"}]
[null,70,12,"Non-Insulated assembly for conversion of suspension tower to non-insulated joint position.","16KA",{"v":72.85714285714286,"d":"72.86"},{"v":3691.9700000000003,"d":"R 3,691.97"},{"v":268986.3857142858,"d":"R268,986.39"}]
[null,76,13,"Insulated Assembly for conversion of suspension tower to insulated joint position.","16KA",{"v":72.85714285714286,"d":"72.86"},{"v":4532.639999999999,"d":"R 4,532.64"},{"v":330235.19999999995,"d":"R330,235.20"}]
[null,82,14,"Vibration dampers - Stockbridge preformed type.","16KA",{"v":12240,"d":"12240.00"},{"v":426.36,"d":"R 426.36"},{"v":5218646.4,"d":"R5,218,646.40"}]
[null,100,15,"Down lead clamps non-insulated","16KA",{"v":10797,"d":"10797.00"},{"v":249.57,"d":"R 249.57"},{"v":2694607.29,"d":"R2,694,607.29"}]
[null,106,16,"Down lead clamps insulated","16KA",{"v":2914.2857142857147,"d":"2914.29"},{"v":333.71,"d":"R 333.71"},{"v":972526.2857142858,"d":"R972,526.29"}]
[null,136,17,"1m Earthbonds  with two lugs per m","16KA",{"v":500,"d":"500.00"},{"v":195.89,"d":"R 195.89"},{"v":97945,"d":"R97,945.00"}]
[null,142,18,"Earthbonds  with two  transfer saddles per m","16KA",{"v":200,"d":"200.00"},{"v":541.8237274953077,"d":"R 541.82"},{"v":108364.74549906154,"d":"R108,364.75"}]
[null,148,19,"Earthbonds  with one lug and one transfer saddle per m","16KA",{"v":200,"d":"200.00"},{"v":427.99148801879346,"d":"R 427.99"},{"v":85598.29760375869,"d":"R85,598.30"}]
[]
[]
[{"$nulls":3},"18KA GROUPING"]
[null,5,null,"Insulated Strain Assembly complete with insulator","18KA",{"v":480,"d":"480.00"},{"v":2078.08,"d":"R 2,078.08"},{"v":997478.3999999999,"d":"R 997,478.40"}]
[null,11,null,"Non-Insulated Strain Assembly complete with earthbonds","18KA",{"v":480,"d":"480.00"},{"v":1819.6799999999998,"d":"R 1,819.68"},{"v":873446.3999999999,"d":"R 873,446.40"}]
[null,17,null,"Non-Insulated Suspension Assembly for self-supporting tower- landing plate orientation 90 degrees to conductor, complete with earthbonds","18KA",{"v":28.8,"d":"28.80"},{"v":1663.88,"d":"R 1,663.88"},{"v":47919.744000000006,"d":"R 47,919.74"}]
[null,23,null,"Non-Insulated Suspension Assembly for self-supporting tower-landing plate orientation 0 degrees to conductor, complete with earthbonds.","18KA",{"v":300,"d":"300.00"},{"v":1733.6399999999999,"d":"R 1,733.64"},{"v":520091.99999999994,"d":"R 520,092.00"}]
[null,29,null,"Insulated Suspension Assembly for self-supporting tower- landing plate orientation 90 degrees to conductor complete with insulator.","18KA",{"v":28.8,"d":"28.80"},{"v":2576.9300000000003,"d":"R 2,576.93"},{"v":74215.58400000002,"d":"R 74,215.58"}]
[null,35,null,"Insulated Suspension Assembly for self-supporting tower-landing plate orientation 0 degrees to conductor, complete with insulator.","18KA",{"v":115.2,"d":"115.20"},{"v":2662.4700000000003,"d":"R 2,662.47"},{"v":306716.54400000005,"d":"R 306,716.54"}]
[null,41,null,"Insulated Strain Assembly for Joint-complete with earths and insulator","18KA",{"v":28.571428571428573,"d":"28.57"},{"v":2094.36,"d":"R 2,094.36"},{"v":59838.85714285715,"d":"R 59,838.86"}]
[null,47,null," Non-Insulated Strain Assembly for Joint-complete with earths.","18KA",{"v":28.571428571428573,"d":"28.57"},{"v":1819.6799999999998,"d":"R 1,819.68"},{"v":51990.85714285714,"d":"R 51,990.86"}]
[null,53,null,"Assembly for crossrope towers.-Insulated (With post insulator)","18KA",{"v":216,"d":"216.00"},{"v":3908.86,"d":"R 3,908.86"},{"v":844313.76,"d":"R 844,313.76"}]
[null,59,null,"Assembly for crossrope towers - Non-Insulated (Same as non-insulated suspension but with long bolts and spacers)","18KA",{"v":216,"d":"216.00"},{"v":2122.4,"d":"R 2,122.40"},{"v":458438.4,"d":"R 458,438.40"}]
[null,65,null,"Assembly for crossrope towers - Non-Insulated post type.","18KA",{"v":216,"d":"216.00"},{"v":2122.4,"d":"R 2,122.40"},{"v":458438.4,"d":"R 458,438.40"}]
[null,71,null,"Non-Insulated assembly for conversion of suspension tower to non-insulated joint position.","18KA",{"v":28.571428571428573,"d":"28.57"},{"v":3956.9,"d":"R 3,956.90"},{"v":113054.28571428572,"d":"R 113,054.29"}]
[null,77,null,"Insulated Assembly for conversion of suspension tower to insulated joint position.","18KA",{"v":28.571428571428573,"d":"28.57"},{"v":4783.95,"d":"R 4,783.95"},{"v":136684.2857142857,"d":"R 136,684.29"}]
[null,83,null,"Vibration dampers - Stockbridge preformed type.","18KA",{"v":4800,"d":"4800.00"},{"v":429.75,"d":"R 429.75"},{"v":2062800,"d":"R 2,062,800.00"}]
[null,101,null,"Down lead clamps non-insulated","18KA",{"v":1142.857142857143,"d":"1142.86"},{"v":308.12,"d":"R 308.12"},{"v":352137.1428571429,"d":"R 352,137.14"}]
[null,107,null,"Down lead clamps insulated","18KA",{"v":1142.857142857143,"d":"1142.86"},{"v":388.04,"d":"R 388.04"},{"v":443474.28571428574,"d":"R 443,474.29"}]
[null,137,null,"1m Earthbonds  with two lugs per m","18KA",{"v":250,"d":"250.00"},{"v":520,"d":"R 520.00"},{"v":130000,"d":"R 130,000.00"}]
[null,143,null,"Earthbonds  with two  transfer saddles per m","18KA",{"v":200,"d":"200.00"},{"v":541.8237274953077,"d":"R 541.82"},{"v":108364.74549906154,"d":"R 108,364.75"}]
[null,149,null,"Earthbonds  with one lug and one transfer saddle per m","18KA",{"v":200,"d":"200.00"},{"v":427.99148801879346,"d":"R 427.99"},{"v":85598.29760375869,"d":"R 85,598.30"}]
[]
[]
[{"$nulls":3},"21KA GROUPING"]
[null,6,null,"Insulated Strain Assembly complete with insulator","21KA",{"v":240,"d":"240.00"},{"v":2455.07,"d":"R 2,455.07"},{"v":589216.8,"d":"R 589,216.80"}]
[null,12,null,"Non-Insulated Strain Assembly complete with earthbonds","21KA",{"v":240,"d":"240.00"},{"v":2217.09,"d":"R 2,217.09"},{"v":532101.6000000001,"d":"R 532,101.60"}]
[null,18,null,"Non-Insulated Suspension Assembly for self-supporting tower- landing plate orientation 90 degrees to conductor, complete with earthbonds","21KA",{"v":14.4,"d":"14.40"},{"v":1750.19,"d":"R 1,750.19"},{"v":25202.736,"d":"R 25,202.74"}]
[null,24,null,"Non-Insulated Suspension Assembly for self-supporting tower-landing plate orientation 0 degrees to conductor, complete with earthbonds.","21KA",{"v":57.6,"d":"57.60"},{"v":1819.96,"d":"R 1,819.96"},{"v":104829.69600000001,"d":"R 104,829.70"}]
[null,30,null,"Insulated Suspension Assembly for self-supporting tower- landing plate orientation 90 degrees to conductor complete with insulator.","21KA",{"v":14.4,"d":"14.40"},{"v":2681.26,"d":"R 2,681.26"},{"v":38610.14400000001,"d":"R 38,610.14"}]
[null,36,null,"Insulated Suspension Assembly for self-supporting tower-landing plate orientation 0 degrees to conductor, complete with insulator.","21KA",{"v":57.6,"d":"57.60"},{"v":2768.31,"d":"R 2,768.31"},{"v":159454.656,"d":"R 159,454.66"}]
[null,42,null,"Insulated Strain Assembly for Joint-complete with earths and insulator","21KA",{"v":14.285714285714286,"d":"14.29"},{"v":2471.33,"d":"R 2,471.33"},{"v":35304.71428571429,"d":"R 35,304.71"}]
[null,48,null," Non-Insulated Strain Assembly for Joint-complete with earths.","21KA",{"v":14.285714285714286,"d":"14.29"},{"v":2217.09,"d":"R 2,217.09"},{"v":31672.71428571429,"d":"R 31,672.71"}]
[null,54,null,"Assembly for crossrope towers.-Insulated (With post insulator)","21KA",{"v":108,"d":"108.00"},{"v":1397.55,"d":"R 1,397.55"},{"v":150935.4,"d":"R 150,935.40"}]
[null,60,null,"Assembly for crossrope towers - Non-Insulated (Same as non-insulated suspension but with long bolts and spacers)","21KA",{"v":108,"d":"108.00"},{"v":2166.4300000000003,"d":"R 2,166.43"},{"v":233974.44000000003,"d":"R 233,974.44"}]
[null,66,null,"Assembly for crossrope towers - Non-Insulated post type.","21KA",{"v":108,"d":"108.00"},{"v":2166.4300000000003,"d":"R 2,166.43"},{"v":233974.44000000003,"d":"R 233,974.44"}]
[null,72,null,"Non-Insulated assembly for conversion of suspension tower to non-insulated joint position.","21KA",{"v":14.285714285714286,"d":"14.29"},{"v":4751.74,"d":"R 4,751.74"},{"v":67882,"d":"R 67,882.00"}]
[null,78,null,"Insulated Assembly for conversion of suspension tower to insulated joint position.","21KA",{"v":14.285714285714286,"d":"14.29"},{"v":5537.91,"d":"R 5,537.91"},{"v":79113,"d":"R 79,113.00"}]
[null,84,null,"Vibration dampers - Stockbridge preformed type.","21KA",{"v":2400,"d":"2400.00"},{"v":433.65,"d":"R 433.65"},{"v":1040760,"d":"R 1,040,760.00"}]
[null,102,null,"Down lead clamps non-insulated","21KA",{"v":571.4285714285714,"d":"571.43"},{"v":308.12,"d":"R 308.12"},{"v":176068.57142857145,"d":"R 176,068.57"}]
[null,108,null,"Down lead clamps insulated","21KA",{"v":571.4285714285714,"d":"571.43"},{"v":388.04,"d":"R 388.04"},{"v":221737.14285714287,"d":"R 221,737.14"}]
[null,138,null,"1m Earthbonds  with two lugs per m","21KA",{"v":200,"d":"200.00"},{"v":520,"d":"R 520.00"},{"v":104000,"d":"R 104,000.00"}]
[null,144,null,"Earthbonds  with two  transfer saddles per m","21KA",{"v":200,"d":"200.00"},{"v":541.8237274953077,"d":"R 541.82"},{"v":108364.74549906154,"d":"R 108,364.75"}]
[null,150,null,"Earthbonds  with one lug and one transfer saddle per m","21KA",{"v":200,"d":"200.00"},{"v":410.75,"d":"R 410.75"},{"v":82150,"d":"R 82,150.00"}]

{"sheet":"Categories- \"Type\"","index":10,"n_rows":23,"n_cols":7,"rows_kept":23,"hidden":true}
["Enquiry No.",{"$f":"'[1]Read Me'!#REF!","v":{"$error":"#REF!"}}]
["Package Name:",{"$f":"'[1]Read Me'!D1","v":0}]
["Tenderer's Name:",{"$f":"'[1]Read Me'!D2","v":"MWP 1970 TX - REQUEST FOR PROPOSAL"}]
[]
["OEM Fees"]
[]
["No.","Formula Code","Description of Tenderer's OEM Fees",null,"No.","Formula Code","Description of Tenderer's OEM Fees"]
[1,null,"None",null,1,null,"None"]
[{"$f":"A8+1","v":2},"A","Bundle",null,{"$f":"E8+1","v":2},"A","Item has a price"]
[{"$f":"A9+1","v":3},"B","Support",null,{"$f":"E9+1","v":3},"B","Default in combo"]
[4,"C","Software"]
[5,"D","Component"]
[6,"E","Power supply"]
[7,"F","Cable"]
[8,"G","Miscellaneous"]
[9,"H","Module"]
[10,"I","Subscription"]
[11,"J","Service"]
[null,"K","Server"]
[null,"L","Training"]
[null,"M","Hardware"]
[null,"N","Workstation"]
[null,"O","OEM Fees"]