{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Content","Notice","Matrix metholodogy","CALC"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":44,"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":"Content","index":0,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Annex 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Entry and exit network charge tariffs for the natural gas transmission system in Slovenia"]
[null,"The simplified tariff model represents the matrix model for determination of network charge tariffs and is prepared on the basis of Article 30(2)(b) of the Commission Regulation (EU) 2017/460 of 16 March 2017 establishing a Network Code on Harmonised Transmission Tariff Structures for Gas "]
[]
[]
[]
[null,"Content"]
[null,"Setting the entry and exit network charge tariffs with the use of a matrix methodology "]
[]
[]
[]
[null,"Date of last modification:"]
[null,"2022-02-23"]

{"sheet":"Notice","index":1,"n_rows":54,"n_cols":2,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,{"$f":"Content!B20","v":"Setting the entry and exit network charge tariffs with the use of a matrix methodology "}]
[]
[null,"A user can use a simplified calculation of entry and exit natwork charge tariffs for an individual entry or exit point on the basis of the entry of an average daily booking in an individual entry or exit point (green coloured fields) "]
[]
[null,"When looking for the appropriate correction factor for entry and exit tariffs to achieve the expected target revenue  \"Excel Solver\" is used, which  must be enabled beforehand by the user prior  (File → Options →Add-ins → Excel add-ins → Solver)"]
[]
[null,"User Account Process:"]
[]
[null,"Input of average daily booked capacity in an individual entry or exit point , which must not exceed the technical capacity of an individual point of the transmission system. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Table for the input of average daily booked capacityin an individual entry/exit point"]
[]
[null,"Activation of Excel Solver and setting the target eligible revenue of the TSO (eligible revenue of the TSO for year 20XX is e.g. EUR XX.XXX.XXX). In case if only the average daily booking is changed in a single point, only the command Solver is executed, which calculates the appropriate correction factor - factor of entry/exit tariffs to achieve the expected the target revenue and consequently the calculation of the appropriate entry and exit tariffs.   "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Excel Solver window "]

{"sheet":"Matrix metholodogy","index":2,"n_rows":86,"n_cols":8,"rows_kept":86,"cut":false,"hidden":false,"merged":[[33,1,34,1],[32,6,32,7],[33,6,34,6],[33,7,34,7],[78,5,79,7],[42,4,42,5],[66,1,68,1],[66,2,66,3],[67,2,68,2],[67,3,68,3],[58,1,59,1],[43,2,44,2],[43,3,44,3],[42,1,44,1],[43,4,44,4],[43,5,44,5],[42,2,42,3]]}
[null,null,null,null,null,null,null,{"$f":"Content!B25","v":"2022-02-23"}]
[null,{"$f":"Content!B14","v":"Entry and exit network charge tariffs for the natural gas transmission system in Slovenia"}]
[]
[null,{"$f":"Content!B20","v":"Setting the entry and exit network charge tariffs with the use of a matrix methodology "}]
[]
[]
[]
[]
[null,{"$f":"\"Natural gas transmission system in Slovenia - Entry/Exit in tariffs for the regulatory year 2020\"","v":"Natural gas transmission system in Slovenia - Entry/Exit in tariffs for the regulatory year 2020"}]
[]
[]
[null,"Table 1. Peak load at the occurance of the transmisssion system peak load"]
[]
[null,"Consumption of natural gas","Flow [kWh/day] "]
[null,"Consumption in point C (Section B-C)",25125837]
[null,"Consumption in point E (Section D-E)",44547539]
[null,"Consumption in point F (Section D-F)",4916431]
[null,"Total",{"$f":"SUM(C15:C17)","v":74589807}]
[]
[null,"Supply of natural gas",79592408]
[null,"Supply in point A (Section A-B)",74254609]
[null," Total",{"$f":"C21","v":74254609}]
[]
[null,"Opomba:"]
[null,"Flows at peak load on 26/2/2018"]
[null,null,null,null,null,"Shema prenosnega sistema porazdeljena po odsekih (na dan 1.1.2019)"]
[]
[null,"Determination of entry/exit tariffs of the transmission system (Entry-Exit tarif)"]
[]
[null,"Entry-Exit tariffs - without taking into account the correction factor of the entry/exit tariffs"]
[]
[]
[null,"Entry/exit tariffs  [EUR/(kWh/day)]",null,null,null,0.9,"Techical capacity of entry/exit points"]
[null,"Entry/exit tariffs ","Entry tariffs ",{"$f":"CALC!D3+CALC!D6","v":0.10491407253699614},{"$f":"C38*$F$33","v":2.005944937027343E-2},{"$f":"C39*$F$33","v":1.8267263064224846},"Entry capacity\n[kWh/day]","Exit capacity\n[kWh/day]"]
[null,null,"Exit tariffs","Ceršak","Rogatec","Šempeter pri Gorici"]
[null,"Slovenia",{"$f":"CALC!C9","v":0.47491944087240939},{"$f":"D$34+$C36","v":0.57983351340940548},{"$f":"$E$34+C36","v":0.49497889024268282},{"$f":"F$34+$C36","v":2.3016457472948941},0,81252000]
[null,"Ceršak",{"$f":"D34*$F$33","v":9.4422665283296528E-2},0,{"$f":"CALC!$F$11+C37","v":9.4422665283296528E-2},{"$f":"F$34+$C37","v":1.921148971705781},139216000,0]
[null,"Rogatec",{"$f":"CALC!C8","v":2.2288277078081589E-2},{"$f":"D$34+$C38","v":0.12720234961507773},0,{"$f":"F$34+$C38","v":1.8490145835005662},7731000,68289000]
[null,"Šempeter pri Gorici",{"$f":"CALC!C10","v":2.0296958960249829},{"$f":"D$34+$C39","v":2.1346099685619793},{"$f":"CALC!$F$11+C39","v":2.0296958960249829},0,28534000,25940000]
[]
[]
[]
[null,"Entry/Exit points","Average booking of transmission capacity [kWh/day]",null,"Revenues from booking of transmission capacity [€]"]
[null,null,"Entry capacity\n[kWh/day]","Exit capacity\n[kWh/day]","Entry capacity\n[€]","Exit capacity\n[€]"]
[]
[null,"Slovenia",0,61414974,{"$f":"$C$46*C36*F33","v":0},{"$f":"$D$46*C36","v":29167165.113273561}]
[null,"Ceršak",52012099,0,{"$f":"$C$47*D34","v":5456801.1272874242},{"$f":"$D$47*C37","v":0}]
[null,"Rogatec",3466924,6207000,{"$f":"$C$48*E34","v":69544.586448585847},{"$f":"$D$48*C38","v":138343.33582365242}]
[null,"Šempeter pri Gorici",1692726,0,{"$f":"$C$49*F34","v":3092147.1137653068},{"$f":"$D$49*C39","v":0}]
[null,"Skupaj",{"$f":"SUM(C46:C49)","v":57171749},{"$f":"SUM(D46:D49)","v":67621974},8618492.8275013156,29305508.449097212]
[null,null,null,null,"Total revenue (uncorrected)",{"$f":"E50+F50","v":37924001.276598528}]
[null,"Note:"]
[null,{"$f":"\"Indeterminable entry/exit tariffs are determined as 90% value of determinable tariffs. \"","v":"Indeterminable entry/exit tariffs are determined as 90% value of determinable tariffs. "}]
[]
[null,"Entry-Exit tariffs - with taking into account the correction factor of the entry/exit tariffs"]
[]
[]
[null,"Entry-Exit tariffs [EUR/(kWh/day)]",null,null,null,0.9]
[null,"Entry/Exit points","Entry tariffs",{"$f":"D34*D79","v":0.10904525188171686},{"$f":"C63*$F$58","v":2.0849326084626717E-2},{"$f":"C64*$F$58","v":1.8986569235748154}]
[null,null,"Exit tariffs","Ceršak","Rogatec","Šempeter pri Gorici"]
[null,"Slovenia",{"$f":"C36*$D$79","v":0.49362024370175867},{"$f":"D$59+$C61","v":0.60266549558347549},{"$f":"E$59+$C61","v":0.51446956978638536},{"$f":"F$59+$C61","v":2.3922771672765739}]
[null,"Ceršak",{"$f":"D59*$F$58","v":9.8140726693545177E-2},0,{"$f":"C62+E59","v":0.1189900527781719},{"$f":"C62+F59","v":1.9967976502683606}]
[null,"Rogatec",{"$f":"C38*$D$79","v":2.3165917871807461E-2},{"$f":"D$59+$C63","v":0.13221116975352432},0,{"$f":"$C$63+F59","v":1.921822841446623}]
[null,"Šempeter pri Gorici",{"$f":"C39*$D$79","v":2.1096188039720172},{"$f":"E$59+$C64","v":2.1304681300566437},{"$f":"C64+E59","v":2.1304681300566437},0]
[]
[]
[null,"Entry/Exit points","Revenues from transmission capacity booking  [€]"]
[null,null,"Entry capacity \n[€]","Exit capacity\n[€]"]
[]
[null,"Slovenia",{"$f":"$C$46*C61","v":0},{"$f":"$D$46*C61","v":30315674.432817172}]
[null,"Ceršak",{"$f":"$C$47*D59","v":5671672.4363517938},{"$f":"$D$47*C62","v":0}]
[null,"Rogatec",{"$f":"$C$48*E59","v":72283.028986618388},{"$f":"$D$48*C63","v":143790.8522303089}]
[null,"Šempeter pri Gorici",{"$f":"$C$49*F59","v":3213905.939615103},{"$f":"$D$49*C64","v":0}]
[null,"Skupaj",{"$f":"SUM(C70:C73)","v":8957861.4049535152},{"$f":"SUM(D70:D73)","v":30459465.285047483}]
[null,null,"Expected target revenue [€]",{"$f":"C74+D74","v":39417326.690000996}]
[]
[]
[null,null,null,"Correction factor of entry/exit points to achieve target revenue"]
[null,null,"Correction factor of entry/exit tariffs Kf(EE)",1.0393767894508521]
[]
[null,"Entry/Exit tariffs - Tariffs table"]
[]
[null,"tbl_Entry-Exit"]
[null,"Entry/Exit tariffs [EUR/(kWh/day)]","Ceršak","Rogatec","Šempeter pri Gorici","Slovenija"]
[null,"Entry tariff",{"$f":"ROUND(D59,5)*100","v":10.904999999999999},{"$f":"ROUND(E59,5)*100","v":2.085},{"$f":"ROUND(F59,5)*100","v":189.86600000000001},{"$f":"ROUND(AVERAGE(C85:E85),5)","v":67.618669999999995}]
[null,"Exit tariff",{"$f":"ROUND(C62,5)*100","v":9.8140000000000001},{"$f":"ROUND(C63,5)*100","v":2.3170000000000002},{"$f":"ROUND(C64,5)*100","v":210.96200000000002},{"$f":"ROUND(C61,5)*100","v":49.362000000000002}]

{"sheet":"CALC","index":3,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":true,"merged":[[6,3,6,4]]}
[null,null,null,"  Strošek enote ob vršni obremenitvi \n[EUR/(kWh/dan)]","Pričakovan prihodek \n[EUR]"]
[null,null,null," A do B  "," A do B  "]
[null,"Odsek dostopa do prenosnega sistema","Ceršak",0.10491407253699614,7790353.4348322861]
[null,"Skupaj  ",null," ",7790353.4348322861]
[null,null,"Sistemska vstopna točka"," B  "," B "]
[null,null,"Sistemska vstopna tarifa (Entry tariffs) ",0," "]
[null,"Sistemska izstopna točka",null,"Vstopna + Izstopna"]
[null,"Rogatec",2.2288277078081589E-2,2.2288277078081589E-2,560011.61687471427]
[null,"Slovenija",0.47491944087240939,0.47491944087240939,21156492.31412185]
[null,"Šempeter pri Gorici",2.0296958960249829,2.0296958960249829,9978859.8237900026]
[null,"Skupaj  ",null,null,31695363.754786566]
[null," Skupaj  ",null,null,39485717.189618856]