{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Tender Cover Sheet"," Preamble","PS5","Price List","X1- CPA","X3- Exchange Rates","Revised Forecast-OCT'23"],"not_rendered":{"images":1,"external_links":6,"defined_names":405},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":35,"n_cols":2,"rows_kept":35}
[]
[null,"INSTRUCTIONS FOR COMPLETING THE PRICING SCHEDULE:"]
[]
[1,"The Supplier must complete the following Sheets:"]
[]
[null,"Cover Page"]
[null,"PS5"]
[null,"Price List"]
[null,"Option X1 CPA Formulae"]
[null,"Option X3 Exchange rates"]
[]
[]
[]
[2,"Drop-down items are provided in cells highlighted in light blue"]
[]
[3,"The cells highlighted in light green are cells the Supplier can edit/manual inputs"]
[]
[5,"The Supplier shall verify the values in the PS5 Schedule"]
[]
[6,"The sheet 'Option X3' defines the different currencies and ruling Rates of Exchange (RoE) to be used as part of the contract."]
[]
[7,"The sheet 'Option X1' defines the formulas that shall be used for the calculation of price adjustments."]
{"$rows_empty":12}
[null,"Name of supplier & factory of origin:"]

{"sheet":"Tender Cover Sheet","index":1,"n_rows":25,"n_cols":4,"rows_kept":25}
[]
[null,"Enquiry No."]
[null,"Package Name:"]
[null,"Tenderer's Name:"]
[]
[null,"PRICING INFORMATION"]
[]
[null,"CATEGORY OF OFFER (MAIN OFFER ONLY):"]
[]
[null,"TENDERED PRICE:  IN ZAR"]
[null,"(excluding VAT)"]
[]
[null,"TENDERED PRICE:  IN ZAR"]
[null,"(including VAT)"]
[]
[null,"RAND VALUE IN WORDS","[Price in Words]"," "]
[]
[null,"DATE :"," "]
[]
[null,"FULL NAMES OF SIGNATORY:"," "]
[]
[]
[]
[null,"DESIGNATION OF SIGNATORY:"," "]
[{"$nulls":3}," "]

{"sheet":" Preamble","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"merged":[[6,2,6,11],[7,2,7,11],[8,2,8,11],[9,2,9,11],[10,2,10,11],[11,2,11,11],[12,2,12,11]]}
[]
[null,"Enquiry No.",null,{"$f":"'Tender Cover Sheet'!C2","v":0}]
[null,"Package Name:",null,{"$f":"'Tender Cover Sheet'!C3","v":0}]
[null,"Tenderer's Name:",null,{"$f":"'Tender Cover Sheet'!C4","v":0}]
[]
[null,"PREAMBLE TO PRICE SCHEDULE "]
[null,1,"The Price Schedule provides the basis of valuation and information for general contract progress monitoring. "]
[null,2,"All worksheets in this Pricing Schedule are to be submitted. "]
[null,3,"The Tenderer must check and take responsibility for all descriptions, formulae, etc."]
[null,4,"Prices to exclude VAT. "]
[null,5,"Quantities are estimated and non-committal."]
[null,6]
[null,7]

{"sheet":"PS5","index":3,"n_rows":90,"n_cols":17,"rows_kept":90,"merged":[[1,8,1,10],[4,0,4,2],[8,9,10,9],[8,10,10,10],[8,11,10,11],[8,12,10,12],[8,13,10,13],[8,14,10,14],[8,15,10,15],[8,16,10,16],[50,0,50,2],[54,9,56,9],[54,10,56,10],[54,11,56,11],[54,12,56,12],[54,13,56,13],[54,14,56,14],[54,15,56,15],[54,16,56,16]]}
["ENQUIRY NUMBER :"]
[{"$nulls":7},"Supplier:"]
[" PRICE SCHEDULE :  (PS5) : "]
[{"$nulls":7},"Prices inclusive of  VAT (Value Added Tax)"]
[" PRICE SCHEDULE FOR: "]
[]
[""]
[" REMARKS",{"$nulls":5},"                       ITEM NO",null,null,1,2,3,4,5,6,7,8]
[" *Eskom may effect this insurance which includes war",{"$nulls":5},"                  ITEM DESCRIPTION",null,null,"165054, ARRSTR SRG:DX;11 KV;1;20 MM;MOV","182607,ARRSTR SRG:DX;11 KV;1;31 MM;MOV","165055, ARRSTR SRG:DX;22 KV;1;20 MM;MOV","182608, ARRSTR SRG:DX;22 KV;1;31 MM;MOV","174780, ARRSTR SRG:DX;33 KV;1;20 MM;MOV","182610, ARRSTR SRG:DX;33 KV;1;31 MM;MOV","165093, ARRSTR SRG:DX; SWER;33 KV;1;20 MM;MOV","182609, ARRSTR SRG:DX; SWER;33/19 KV;1;31 MM;MOV"]
["   risk insurance"]
["**Please specify"]
["SUPPLIED FROM OUTSIDE R.S.A.:"]
["1: F.O.B. PRICE",{"$nulls":7},"(In ZAR)"]
["2: COST OF SEA  FREIGHT",{"$nulls":7},"(In ZAR)"]
["3: COST OF AIR  FREIGHT",{"$nulls":7},"(In ZAR)"]
["4: COST OF MARINE INSURANCES *",{"$nulls":7},"(In ZAR)"]
["5: TOTAL PRICE DELIVERED PORT R.S.A. ...",{"$nulls":5},"(1+2+3+4)",null,"(In ZAR)",{"$f":"SUM(J13:J16)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["6: WHARFAGE",{"$nulls":7},"(In ZAR)"]
["7: LANDING CHARGES",{"$nulls":7},"(In ZAR)"]
["8: CUSTOMS DUTIES",{"$nulls":7},"(In ZAR)"]
["9: IMPORT SURCHARGE",{"$nulls":7},"(In ZAR)"]
["10: OTHER**",{"$nulls":7},"(In ZAR)"]
["11: COST OF IMPORTATION ...",{"$nulls":5},"(6+7+8+9+10)",null,"(In ZAR)",{"$f":"SUM(J18:J22)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["12: COST OF RAIL TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
["13: COST OF ROAD TRANSPORT IN R.S.A.",{"$nulls":7},"(In ZAR)"]
["14: TOTAL COST OF TRANSPORT S.A. PORT TO WORK/SITE ...",{"$nulls":5},"(12+13)",null,"(In ZAR)",{"$f":"SUM(J24:J25)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["15: TOTAL PRICE (F.O.B.) DELIVERED TO WORKS/SITE...",{"$nulls":5},"(5+11+14)",null,"(In ZAR)",{"$f":"SUM(J17,J23,J26)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["SUPPLIED FROM INSIDE R.S.A."]
["16: F.O.R. PRICE-GOODS MANUFACTURED INSIDE R.S.A."]
["17: F.O.R. PRICE-GOODS SUPPLIED FROM IMPORTED ITEMS"]
["18: TOTAL F.O.R. PRICE ...",{"$nulls":5},"(16+17)",null,null,{"$f":"SUM(J30:J31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(K30:K31)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["19: COST OF RAIL TRANSPORT"]
["20: COST OF ROAD TRANSPORT"]
["21: COST OF TRANSPORT WORKS TO SITE ...          ",{"$nulls":5},"(19+20)",null,null,{"$f":"SUM(J33:J34)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["22: PRICE (F.O.R.) DELIVERED TO SITE ...          ",{"$nulls":5},"(18+21)",null,null,{"$f":"SUM(J32,J35)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[" SITE WORK (ERECTION / INSTALLATION INCL. COMMISSIONING) "]
["23: LOCAL LABOUR"]
["24: EXPATRIATE  LABOUR"]
["25: TOTAL PRICE FOR SITE WORK ...          ",{"$nulls":5},"(23+24)",null,null,{"$f":"SUM(J38:J39)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["26: OVERSEAS ENGINEERING SERVICES"]
["27: LOCAL ENGINEERING SERVICES"]
["28: TOTAL PRICE FOR ENGINEERING SERVICES...",{"$nulls":5},"(26+27)",null,null,{"$f":"SUM(J41:J42)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["28a: TOTAL PRICE DELIVERED TO SITE (EXCL VAT)",{"$nulls":5},"(15+22+25+28)"]
["29. VAT"]
["30: TOTAL  PRICE DELIVERED TO SITE",{"$nulls":5},"(28a+29)",null,null,{"$f":"+J44+J45","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["ENQUIRY NUMBER :                                                            ",{"$nulls":3},"                                      PRICES INCLUSIVE OF VAT (VALUE ADDED TAX)",{"$nulls":4},"\\","\\","\\","\\","\\","\\","\\","\\"]
[]
[{"$f":"A3","v":" PRICE SCHEDULE :  (PS5) : "}]
[]
[" PRICE SCHEDULE FOR :"]
[]
[]
[" REMARKS",{"$nulls":5},"                       ITEM NO",null,null,{"$f":"J8","v":1},2,3,4,5,6,7,8]
[" *Eskom may effect this insurance which includes war",{"$nulls":5},"                  ITEM DESCRIPTION",null,null,"165054, ARRSTR SRG:DX;11 KV;1;20 MM;MOV","182607,ARRSTR SRG:DX;11 KV;1;31 MM;MOV","165055, ARRSTR SRG:DX;22 KV;1;20 MM;MOV","182608, ARRSTR SRG:DX;22 KV;1;31 MM;MOV","174780, ARRSTR SRG:DX;33 KV;1;20 MM;MOV","182610, ARRSTR SRG:DX;33 KV;1;31 MM;MOV","165093, ARRSTR SRG:DX; SWER;33 KV;1;20 MM;MOV","182609, ARRSTR SRG:DX; SWER;33/19 KV;1;31 MM;MOV"]
["   risk insurance"]
["**Please specify"]
["PRICE DELIVERED TO PORT R.S.A. (LINE 5)"]
["31: CURRENCY A   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
["32: CURRENCY B   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
["33: CURRENCY C   1 ZAR=............",null,null,"(FOB)",{"$nulls":3},"(In Foreign Currency)"]
["34: CURRENCY D   1 ZAR=............",null,null,"(FREIGHT)",{"$nulls":3},"(In Foreign Currency)"]
["35: CURRENCY E   1 ZAR=............",null,null,"(INSURANCE)",{"$nulls":3},"(In Foreign Currency)"]
["36: TOTAL F.O.B. PRICE ",{"$nulls":5},"31+32+33+34+35)",null,null,{"$f":"SUM(J59:J63)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["PRICE EXPATRIATE LABOUR (LINE 25)"]
["37: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["38: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["39: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["40: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["41: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
["42.TOTAL PRICE EXPATRIATE LABOUR ",{"$nulls":5},"37+38+39+40+41)",null,null,{"$f":"SUM(J66:J70)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["PRICE OVERSEAS ENGINEERING SERVICES (LINE 27)"]
["43: CURRENCY A   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["44: CURRENCY B   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["45: CURRENCY C   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["46: CURRENCY D   1 ZAR=............",{"$nulls":6},"(In Foreign Currency)"]
["47: CURRENCY E   1 ZAR=.............",{"$nulls":6},"(In Foreign Currency)"]
["48: TOTAL PRICE OVERSEAS ENGINEERING SERVICES (LINE 26) ",{"$nulls":6},"(26=43+44+45+46+47)",null,{"$f":"SUM(J73:J77)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["49: FOREIGN CONTENT OF TOTAL PRICE",{"$nulls":5},"(36+42+48)",null,null,{"$f":"+J64+J71+J78","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["LOCAL PREFERENCE FOR ELECTRONICS ONLY"]
["50. FOR PRICE GOODS MANUFACTURED IN R.S.A. (LINE 16)"]
["51. PRICE FOR LOCAL DESIGN / ENGINEERING SERVICES (LINE 27) "]
["52. PERCENTAGE PREFERENCE CLAIMED (=................) ON LINE 50"]
["53. PERCENTAGE PREFERENCE CLAIMED (=................) ON LINE 51"]
["54. TOTAL AMOUNT CLAIMED ",null,null,"(52 + 53)",{"$nulls":5},{"$f":"SUM(J83:J84)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[]
["SIGNATURE...................................................................",{"$nulls":6},"CAPACITY........................................................................"]
[]
["DATE......................................................."]

{"sheet":"Price List","index":4,"n_rows":16,"n_cols":33,"rows_kept":16,"merged":[[0,2,0,3],[1,2,1,3],[2,2,2,3],[4,1,6,3],[4,4,7,4],[4,5,7,5],[4,6,4,15],[4,16,4,20],[4,21,4,30],[4,31,7,31],[4,32,7,32],[5,6,5,15],[5,16,5,20],[5,21,5,30],[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[6,12,7,12],[6,13,7,13],[6,14,7,14],[6,15,7,15],[6,16,7,16],[6,17,7,17],[6,18,7,18],[6,19,7,19],[6,20,7,20],[6,21,7,21],[6,22,7,22],[6,23,7,23],[6,24,7,24],[6,25,7,25],[6,26,7,26],[6,27,7,27],[6,28,7,28],[6,29,7,29],[6,30,7,30]]}
[null,"Enquiry No.",{"$f":"'Tender Cover Sheet'!C2","v":0}]
[null,"Package Name:",{"$f":"'Tender Cover Sheet'!C3","v":0}]
[null,"Tenderer's Name:",{"$f":"'Tender Cover Sheet'!C4","v":0}]
[]
[null,"DESCRIPTION",null,null,"Estimated Qty","Unit of measurement","SUPPLIED FROM OUTSIDE R.S.A.:",{"$nulls":9},"SUPPLIED FROM INSIDE R.S.A.",{"$nulls":4}," SITE WORK (ERECTION / INSTALLATION INCL. COMMISSIONING) ",{"$nulls":9},"Total Unit Rate","Total Amount (Excl.VAT)"]
[{"$nulls":6},"In Local Currency",{"$nulls":9},"In Local Currency",{"$nulls":4},"In Local Currency"]
[{"$nulls":6},"CPA Formula ref (Goods supplied from outside RSA)","1: F.O.B. PRICE","2: COST OF SEA  FREIGHT","3: COST OF AIR  FREIGHT","4: COST OF MARINE INSURANCES *","5: TOTAL PRICE DELIVERED PORT R.S.A. ...","CPA Formula ref (Local In-Land transportation for goods supplied from Outside RSA)","11: COST OF IMPORTATION ...","14: TOTAL COST OF TRANSPORT S.A. PORT TO WORK/SITE ...","15: TOTAL PRICE (F.O.B.) DELIVERED TO WORKS/SITE...","CPA Formula ref (Goods supplied from inside RSA)","18: TOTAL F.O.R. PRICE ...","CPA Formula ref (Local In-Land transportation for goods supplied from Outside RSA)","21: COST OF TRANSPORT WORKS TO SITE ...          ","22: PRICE (F.O.R.) DELIVERED TO SITE ...          ","CPA Formula ref (Site Work, Local Labour & Local Engineering)","23: LOCAL LABOUR","CPA Formula ref (Site Work, Expatriate Labour & Expatriate Engineering)","24: EXPATRIATE  LABOUR","25: TOTAL PRICE FOR SITE WORK","CPA Formula ref (Site Work, Expatriate Labour & Expatriate Engineering)","26: OVERSEAS ENGINEERING SERVICES","CPA Formula ref (Site Work, Local Labour & Local Engineering)","27: LOCAL ENGINEERING SERVICES","28: TOTAL PRICE FOR ENGINEERING SERVICES..."]
[null,"Item","SAP numbers","Item Description"]
[null,1,"165054","ARRSTR SRG:DX;11 KV;1;20 MM;MOV",41060,"No",null,{"$f":"'PS5'!J13","v":0},{"$f":"'PS5'!J14","v":0},{"$f":"'PS5'!J15","v":0},{"$f":"'PS5'!J16","v":0},{"$f":"SUM(H9:K9)","v":0},null,{"$f":"'PS5'!J23","v":0},{"$f":"'PS5'!J26","v":0},{"$f":"SUM(N9:O9)","v":0},null,{"$f":"'PS5'!J32","v":0},null,{"$f":"'PS5'!J35","v":0},{"$f":"SUM(R9,T9)","v":0},null,{"$f":"'PS5'!J38","v":0},null,{"$f":"'PS5'!J39","v":0},{"$f":"SUM(Y9,W9)","v":0},null,{"$f":"'PS5'!J41","v":0},null,{"$f":"'PS5'!J42","v":0},{"$f":"SUM(AB9,AD9)","v":0},{"$f":"SUM(L9,P9,U9,Z9,AE9)","v":0},{"$f":"AF9*E9","v":0}]
[null,2,"182607","ARRSTR SRG:DX;11 KV;1;31 MM;MOV",94598,"No",null,{"$f":"'PS5'!K13","v":0},{"$f":"'PS5'!K14","v":0},{"$f":"'PS5'!K15","v":0},{"$f":"'PS5'!K16","v":0},{"$f":"SUM(H10:K10)","v":0},null,{"$f":"'PS5'!K23","v":0},{"$f":"'PS5'!K26","v":0},{"$f":"SUM(N10:O10)","v":0},null,{"$f":"'PS5'!K32","v":0},null,{"$f":"'PS5'!K35","v":0},{"$f":"SUM(R10,T10)","v":0},null,{"$f":"'PS5'!K38","v":0},null,{"$f":"'PS5'!K39","v":0},{"$f":"SUM(Y10,W10)","v":0},null,{"$f":"'PS5'!K41","v":0},null,{"$f":"'PS5'!K42","v":0},{"$f":"SUM(AB10,AD10)","v":0},{"$f":"SUM(L10,P10,U10,Z10,AE10)","v":0},{"$f":"AF10*E10","v":0}]
[null,3,"165055","ARRSTR SRG:DX;22 KV;1;20 MM;MOV",61336,"No",null,{"$f":"'PS5'!L13","v":0},{"$f":"'PS5'!L14","v":0},{"$f":"'PS5'!L15","v":0},{"$f":"'PS5'!L16","v":0},0,null,{"$f":"'PS5'!L23","v":0},{"$f":"'PS5'!L26","v":0},0,null,{"$f":"'PS5'!L32","v":0},null,{"$f":"'PS5'!L35","v":0},0,null,{"$f":"'PS5'!L38","v":0},null,{"$f":"'PS5'!L39","v":0},0,null,{"$f":"'PS5'!L41","v":0},null,{"$f":"'PS5'!L42","v":0},0,0,0]
[null,4,"182608","ARRSTR SRG:DX;22 KV;1;31 MM;MOV",151400,"No",null,{"$f":"'PS5'!M13","v":0},{"$f":"'PS5'!M14","v":0},{"$f":"'PS5'!M15","v":0},{"$f":"'PS5'!M16","v":0},0,null,{"$f":"'PS5'!M23","v":0},{"$f":"'PS5'!M26","v":0},0,null,{"$f":"'PS5'!M32","v":0},null,{"$f":"'PS5'!M35","v":0},0,null,{"$f":"'PS5'!M38","v":0},null,{"$f":"'PS5'!M39","v":0},0,null,{"$f":"'PS5'!M41","v":0},null,{"$f":"'PS5'!M42","v":0},0,0,0]
[null,5,"174780","ARRSTR SRG:DX;33 KV;1;20 MM;MOV",1230,"No",null,{"$f":"'PS5'!N13","v":0},{"$f":"'PS5'!N14","v":0},{"$f":"'PS5'!N15","v":0},{"$f":"'PS5'!N16","v":0},0,null,{"$f":"'PS5'!N23","v":0},{"$f":"'PS5'!N26","v":0},0,null,{"$f":"'PS5'!N32","v":0},null,{"$f":"'PS5'!N35","v":0},0,null,{"$f":"'PS5'!N38","v":0},null,{"$f":"'PS5'!N39","v":0},0,null,{"$f":"'PS5'!N41","v":0},null,{"$f":"'PS5'!N42","v":0},0,0,0]
[null,6,"182610","ARRSTR SRG:DX;33 KV;1;31 MM;MOV",1445,"No",null,{"$f":"'PS5'!O13","v":0},{"$f":"'PS5'!O14","v":0},{"$f":"'PS5'!O15","v":0},{"$f":"'PS5'!O16","v":0},0,null,{"$f":"'PS5'!O23","v":0},{"$f":"'PS5'!O26","v":0},0,null,{"$f":"'PS5'!O32","v":0},null,{"$f":"'PS5'!O35","v":0},0,null,{"$f":"'PS5'!O38","v":0},null,{"$f":"'PS5'!O39","v":0},0,null,{"$f":"'PS5'!O41","v":0},null,{"$f":"'PS5'!O42","v":0},0,0,0]
[null,7,"165093","ARRSTR SRG:DX; SWER;33 KV;1;20 MM;MOV",275,"No",null,{"$f":"'PS5'!P13","v":0},{"$f":"'PS5'!P14","v":0},{"$f":"'PS5'!P15","v":0},{"$f":"'PS5'!P16","v":0},0,null,{"$f":"'PS5'!P23","v":0},{"$f":"'PS5'!P26","v":0},0,null,{"$f":"'PS5'!P32","v":0},null,{"$f":"'PS5'!P35","v":0},0,null,{"$f":"'PS5'!P38","v":0},null,{"$f":"'PS5'!P39","v":0},0,null,{"$f":"'PS5'!P41","v":0},null,{"$f":"'PS5'!P42","v":0},0,0,0]
[null,8,"182609","ARRSTR SRG:DX; SWER;33/19 KV;1;31 MM;MOV",350,"No",null,{"$f":"'PS5'!Q13","v":0},{"$f":"'PS5'!Q14","v":0},{"$f":"'PS5'!Q15","v":0},{"$f":"'PS5'!Q16","v":0},0,null,{"$f":"'PS5'!Q23","v":0},{"$f":"'PS5'!Q26","v":0},0,null,{"$f":"'PS5'!Q32","v":0},null,{"$f":"'PS5'!Q35","v":0},0,null,{"$f":"'PS5'!Q38","v":0},null,{"$f":"'PS5'!Q39","v":0},0,null,{"$f":"'PS5'!Q41","v":0},null,{"$f":"'PS5'!Q42","v":0},0,0,0]

{"sheet":"X1- CPA","index":5,"n_rows":147,"n_cols":14,"rows_kept":147,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[4,0,4,4],[7,2,7,3],[7,5,7,7],[8,2,8,4],[8,5,17,7],[9,2,9,4],[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],[20,1,20,6],[21,1,21,6],[24,1,24,6],[25,1,25,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],[32,1,32,6],[33,1,33,6],[34,1,34,6],[35,1,35,6],[39,1,39,6],[50,1,50,6],[61,1,61,6],[72,1,72,6],[83,1,83,6],[94,1,94,6],[105,1,105,6],[116,1,116,6],[127,1,127,6],[138,1,138,6]]}
["Enquiry No.",null,{"$f":"'Tender Cover Sheet'!C2","v":0}]
["Package Name:",null,{"$f":"'Tender Cover Sheet'!C3","v":0}]
["Tenderer's Name:",null,{"$f":"'Tender Cover Sheet'!C4","v":0}]
[]
["PART C_ 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,"A",{"$f":"B40","v":"CPA Formula ref (Goods supplied from outside RSA)"},null,null,"Type in the description of each formula in the tables below"]
[3,"B",{"$f":"B51","v":"CPA Formula ref (Local In-Land transportation for goods supplied from Outside RSA)"}]
[4,"C",{"$f":"B62","v":"CPA Formula ref (Local In-Land transportation for goods supplied from Outside RSA)"}]
[5,"D",{"$f":"B73","v":"CPA Formula ref (Site Work, Erection, Local Labour & Local Engineering)"}]
[6,"E",{"$f":"B84","v":"CPA Formula ref (Site Work, Erection, Expatriate Labour & Expatriate Engineering)"}]
[7,"F",{"$f":"B95","v":"CPA Formula ref (Site Work, Off-loading)"}]
[8,"G",{"$f":"B106","v":"CPA Formula ref (Site Work, Off-loading)"}]
[9,"H",{"$f":"B117","v":"CPA Formula ref (Site Work, Commissioning, De-Comissioning)"}]
[10,"I",{"$f":"B128","v":0}]
[11,"J",{"$f":"B139","v":0}]
[]
["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  Option X1 has to be populated by the tenderer (Formulae below, 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,"The tenderer must populate the CPA formula codes listed above in Columns G, L, P, R, U , X, AA & AC, of the \"PRICE LIST\" tab. This is to be done by selecting the appropriate CPA formula codes (e.g., Formula A–J) from the dropdown list developed by the tenderer in the Option X1_CPA Formulae worksheet."]
[5,"CPA will kick in after twelve (12) months being the first twelve (12) months of the contract period."]
[6,"The CPA escalation will be calculated as follows: The CPA escalation shall be calculated using the latest available index at the time of completion of each activity, subject to item 5 above. The base index shall be the index published one month prior to the 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.  "]
[5,"Base Date Index :   The base index or reference price must be inserted in the appropriate column."]
[" "," "]
[]
[]
["Formula A","CPA Formula ref (Goods supplied from outside RSA)"]
["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"]
["A1"]
["A2"]
["A3"]
["A4"]
["A5"]
["A6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B42:B47)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula B","CPA Formula ref (Local In-Land transportation for goods supplied from Outside RSA)"]
["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"]
["B1"]
["B2"," "]
["B3"]
["B4"," "]
["B5"," "]
["B6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B53:B58)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula C","CPA Formula ref (Local In-Land transportation for goods supplied from Outside RSA)"]
["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"]
["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(B64:B69)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula D","CPA Formula ref (Site Work, Erection, Local Labour & Local Engineering)"]
["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"]
["D1"," "]
["D2"," "]
["D3"]
["D4"," "]
["D5"," "]
["D6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B75:B80)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula E","CPA Formula ref (Site Work, Erection, Expatriate Labour & Expatriate Engineering)"]
["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"]
["E1"," "]
["E2"," "]
["E3"]
["E4"," "]
["E5"," "]
["E6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B86:B91)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula F","CPA Formula ref (Site Work, Off-loading)"]
["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"]
["F1"]
["F2"]
["F3"]
["F4"]
["F5"]
["F6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B97:B102)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula G","CPA Formula ref (Site Work, Off-loading)"]
["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"]
["G1"," "]
["G2"," "]
["G3"," "]
["G4"]
["G5"," "]
["G6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B108:B113)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["Formula H","CPA Formula ref (Site Work, Commissioning, De-Comissioning)"]
["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"]
["H1"," "]
["H2"," "]
["H3"," "]
["H4"," "]
["H5"," "]
["H6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B119:B124)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["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"]
["I1"," "]
["I2"," "]
["I3"," "]
["I4"]
["I5"," "]
["I6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B130:B135)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]
[]
[]
["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"]
["J1"," "]
["J2"]
["J3"," "]
["J4"," "]
["J5"," "]
["J6",{"v":0.15,"d":"15%"},"Fixed 15% minimum not subject to CPA (0.150)"]
[null,{"$f":"SUM(B141:B146)","v":{"v":0.15,"d":"15%"}},"Total","This Total is to add up to 100% for each CPA formula submitted by tenderer"]

{"sheet":"X3- Exchange Rates","index":6,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[1,3,1,6],[2,3,2,6],[3,3,3,6],[8,2,8,9],[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'!C2","v":0}]
[null,null,"Package Name:",{"$f":"'Tender Cover Sheet'!C3","v":0}]
[null,null,"Tenderer's Name:",{"$f":"'Tender Cover Sheet'!C4","v":0}]
[]
[null,"5.1.2 EXCHANGE RATES FOR MULTIPLE CURRENCIES"]
[null," "]
[null,"NOTES:"]
[null,1,"The table below needs to be completed if the Employer will be exposed to any currency influation as stipulated in Secondary Clause X3. For conversation of the foreign portion to Rand please use the South Africa Reserve Bank's (SARB) exchange rate on the day of advertisement of the bid. This is terms of the Preferential Procurement Policy Framework act(PPPFA which the Employer has to comply. NB: Tenderes must submit proof the SARB rate(s) of exchange used."]
[null,2,"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,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"]
[null,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"]
[null,5,"All information in the table below must conform with all other equivalent information in the offer. "]
[null,null,"Payment in terms of Payment Method 2  is considered as a \"foreign payment\" although it will be effected in South African Rand. However, amounts for  \"F.O.R. Price-Goods supplied from Imported Items\", are NOT considered as \"foreign payments\""]
[null,null,"If more than one payment method apply for a currency, the Tenderer must an additional row be inserted in the table in order to split the values and identify the relevant method.   "]
[null," "]
[null,"EXCHANGE RATES PUBLISHED BY SARB"]
[null,"NB: Tenderers must submit proof of the SARB rate (s) of exchange used."]
[null,"MULTIPLE CURRENCIES"]
[null,"No","Currency Description","Code","Exchange Rate\nCurrency 1,00 = R Amount","Amount in Foreign Currency","Amount in Rand","Payment Method 1a, 1b, 2 or Fixed Rand","Date Published","Source"]
[null,1,"Australian Dollar","AUD",0]
[null,{"$f":"B23+1","v":2},"Canadian Dollar","CAN",0]
[null,{"$f":"B24+1","v":3},"Swiss Franc","CHF",0]
[null,{"$f":"B25+1","v":4},"Danish Krone","DKK",0]
[null,5,"European Currency","EUR",0]
[null,6,"British Pound","GBP",0]
[null,7,"Hong Kong Dollar","HKD",0]
[null,8,"Japanese Yen","JPY",0]
[null,9,"Norwegian Krone","NOK",0]
[null,10,"New Zealand Dollar","NZD",0]
[null,11,"Swedish Krone","SEK",0]
[null,12,"Singapore Dollar","SGD",0]
[null,13,"United States Dollar","USD",0]
[null,14,"South African Rand","ZAR",0]
[{"$nulls":5},{"$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":"Revised Forecast-OCT'23","index":7,"n_rows":20,"n_cols":11,"rows_kept":20,"hidden":true,"merged":[[0,0,0,7]]}
["STATION CLASS POST INSULATORS - TDP (incl PDD ) FORECAST 2024 - 2028"]
["Material\nNumber","Description","FY2025","FY2026","FY2027","FY2028","FY2029","Total\nQuantity",null,"Previous QTY"]
[17529,"INSUL-STN POST;C4-150 22KV",null,null,3,3,null,{"$f":"SUM(C3:G3)","v":6},null,9]
[182646,"INSUL-STN POST;C4-200 33KV",null,null,3,3,null,6,null,9]
[17527,"INSUL:STN POST;C4-325;66 KV  C4-325",null,38,6,null,null,44,null,24]
[10439,"INSUL,POST  66KV EP315 TYPE C4-325",null,null,3,3,null,6,null,6]
[523600,"INSUL:STN POST;C10-550;132 KV  C10-550",null,416,{"$nulls":3},416,null,425]
[523601,"INSUL:STN POST;C12.5-550;132 KV  C12.5-550",null,null,3,3,null,6,null,19]
[17528,"INSUL:STN POST;C4-550;132 KV  C4-550",null,45,270,459,341,1115,null,12]
[523599,"INSUL:STN POST;C6-550;132 KV  C6-550",129,396,432,840,null,1797,null,148]
[523602,"INSUL:STN POST;C10-1050;275 KV  C10-1050",12,12,12,12,12,60,null,9]
[523605,"INSUL:STN POST;C10-1175;275 KV  C10-1175",9,9,12,9,10,49,null,12]
[523606,"INSUL:STN POST;C12.5-1175;275 KV  C12.5-1175",9,9,12,9,10,49,null,9]
[523604,"INSUL:STN POST;C4-1175;275 KV",9,9,12,9,10,49,null,15]
[523607,"INSUL:STN POST;C10-1425;400 KV  C10-1425",null,43,930,1077,1721,3771,null,15]
[523610,"INSUL:STN POST;C12.5-1550;400 KV  C12.5-1550",null,5,3,null,null,8,null,211]
[523608,"INSUL:STN POST;C6-1550;400 KV",37,50,{"$nulls":3},87,null,56]
[400525,"INSUL:C10-1550;POST;PORCELAIN;400 KV",null,291,{"$nulls":3},291,null,156]
[523612,"INSUL:STN POST;C8-2100;765 KV  C8-2100",null,3,466,2052,null,2521,null,36]
[null,"Grand Totals",{"$f":"SUM(C3:C19)","v":205},{"$f":"SUM(D3:D19)","v":1326},2167,4479,2104,{"$f":"SUM(H3:H19)","v":10281},null,1171,{"$f":"H20/J20","v":{"v":8.779675491033306,"d":"878%"}}]