{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Title","Model_E"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title","index":0,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[[4,8,9,14]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"GAZ-SYSTEM \nthe system that connects"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Simplified tariff model for gaseous fuels transmission of the Polish Section of the Transit Gas Pipeline System Yamal - Europe"]
["Publication in fulfilment of Article 30 of TAR NC"]
["Tariff for year 2026"]
[]
["November, 2025"]

{"sheet":"Model_E","index":1,"n_rows":73,"n_cols":22,"rows_kept":73,"cut":false,"hidden":false,"merged":[[13,3,13,5],[13,7,13,9],[49,1,51,9]]}
[]
[]
[]
[]
[null,"Simplified Tariff Model for Gaseous fuels transmission of the Polish Section of the Transit Gas Pipeline System Yamal - Europe"]
[null,"Please fill in the orange fields only "]
[]
[null,{"$f":"IF(OR($I$37=\"\",$I$37=0,I39=\"\",I39=0),\"Please enter forecasted entry and exit capacity\",\"\")","v":""}]
[]
[]
[]
[]
[]
[null,null,null,"Tariff year 2025",null,null,null,"Tariff year 2026"]
[]
[]
[null,"Allowed revenue (Projection)  ","PLN",null,205252470.14231512,null,null,null,{"$f":"I20+I22+I23+I24+I25","v":211499420.18000004}]
[null,"RAB",null,null,{"$f":"E20/E19","v":6625470.7737211986},null,null,null,{"$f":"I20/I19","v":1201325}]
[null,"WACC",null,null,8.2290000000000016E-2,null,null,null,9.3600000000000003E-2]
[null,"ZNK",null,null,545209.98996951757,null,null,null,112444.02]
[]
[null,"Depreciation",null,null,361720.45999999996,null,null,null,322678.03000000003]
[null,"Operating expenditures",null,null,204345539.69234556,null,null,null,214680856.77000001]
[null,"Adjustments not involving the regulatory account",null,null,{"$f":"0","v":0},null,null,null,0]
[null,"Regulatory account settlement",null,null,0,null,null,null,-3616558.64]
[]
[]
[]
[]
[]
[null,"Entry/Exit split"]
[null,"Entry","%",null,0.5,null,null,null,0.5]
[null,null,null,null,null,null,null,null,17833010]
[null,"Exit","%",null,{"$f":"1-E32","v":0.5},null,null,null,{"$f":"1-$I$32","v":0.5}]
[]
[null,"Forecast of capacity sales"]
[null,"Entry Points","[kWh/h]",null,942655.65726027405,null,null,null,3350016,null,null,null,null,null,24380878.280215837]
[]
[null,"Exit Points","[kWh/h]",null,942685.78876712336,null,null,null,3350016,null,null,null,null,null,21468227.760000002]
[]
[]
[null,"Reserve prices"]
[null,"Entry Points","[gr/kWh/h]",null,1.2427999999999999,null,null,null,{"$f":"ROUNDDOWN(IFERROR((I17*$I$32)/($I$37*8760)*100,0),4)","v":0.36030000000000001},null,null,null,null,null,false,false]
[]
[null,"Exit Points","[gr/kWh/h]",null,1.2426999999999999,null,null,null,{"$f":"ROUND(IFERROR((I17*$I$34)/($I$39*8760)*100,0),4)","v":0.3604},null,null,null,null,null,false,false]
[]
[]
[]
[]
[null,"Gas transmission simplified tariff model allows for estimation of reserve prices for firm yearly contracts only. \n\nWe hereby inform that all data calculated above has been given for information only and it does not constitute an offer within the meaning of Article 66 and subsequent articles of Polish Civil Code. \n\nThe above calculated reserve prices are net prices. Above prices shall be increased by the value-added tax (VAT), at the amount applicable under the relevant tax regulations. \n\nSimplified tariff model for gas transmission can only be used for estimating reserve prices for standard product for an exemplary client. Due to variety of products including interruptible products and short-term products the applicable tariff may vary from calculated. \n\nPresented reserve prices for tariff year 2026 are prices approved by the President of Energy Regulatory Office within the Tariff No. 1/2026 for gaseous fuels transmission.",null,null,null,null,null,null,null,null,null,null,null,"nie kasowac!!"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"komórki robocze - nie dodawać wierszy ani kolumn w tym skoroszycie!!!"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Discount","Split",null,null,"Moc do kalkulacji ","Revenue","Tariff "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0.05,null,"Entry Points",{"$f":"I37","v":3350016},{"$f":"$I$17*$I$32*$R$55/SUM($R$55:$R$57)","v":{"$error":"#REF!"}},{"$f":"IF(ISERROR($S$55/($I$37*8760)*100),0,$S$55/($I$37*8760)*100)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.1,0.1,null,"Entry UGS",{"$f":"$I$39*(1-#REF!)","v":{"$error":"#REF!"}},{"$f":"$I$17*$I$32*$R$56/SUM($R$55:$R$57)","v":{"$error":"#REF!"}},{"$f":"IF(ISERROR($S$56/($I$39*8760)*100),0,$S$56/($I$39*8760)*100)","v":0},{"$f":"T56/T55","v":{"$error":"#DIV/0!"}},{"$f":"IF(U56=(1-#REF!),\"ok\",\"check\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.2,0.15,null,"Entry LNG ",{"$f":"#REF!*(1-#REF!)","v":{"$error":"#REF!"}},{"$f":"$I$17*$I$32*$R$57/SUM($R$55:$R$57)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=0,0,$S$57/(#REF!*8760)*100)","v":{"$error":"#REF!"}},{"$f":"T57/T55","v":{"$error":"#REF!"}},{"$f":"IF(U57=(1-#REF!),\"ok\",\"check\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,0.2,null,"Exit Points",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$I$17*$I$34*$R$58/SUM($R$58:$R$59)","v":{"$error":"#REF!"}},{"$f":"IF(ISERROR($S$58/(#REF!*8760)*100),0,$S$58/(#REF!*8760)*100)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.4,0.25,null,"Exit UGS",{"$f":"#REF!*(1-#REF!)","v":{"$error":"#REF!"}},{"$f":"$I$17*$I$34*$R$59/SUM($R$58:$R$59)","v":{"$error":"#REF!"}},{"$f":"IF(ISERROR($S$59/(#REF!*8760)*100),0,$S$59/(#REF!*8760)*100)","v":0},{"$f":"T59/T58","v":{"$error":"#DIV/0!"}},{"$f":"IF(U59=(1-#REF!),\"ok\",\"check\")","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,0.3,null,"Commodity ",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"$I$17*#REF!","v":{"$error":"#REF!"}},{"$f":"$S$60/#REF!*100","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.6,0.35,null,null,null,{"$f":"SUM(S55:S60)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.7,0.4,null,null,null,{"$f":"IF($S$61=$E$17,\"ok.\",\"check\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.8,0.45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0.9,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.65]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.75]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]