{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Explanatory notes","Seasonal factors"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":4,"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":"Explanatory notes","index":0,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Consultation on discounts, multipliers, and seasonal factors"]
[null,"on the basis of Article 28 of Commission Regulation (EU) 2017/460 of 16 March 2017 establishing a network code on harmonised transmission tariff structures for gas"]
[]
[]
[]
[null,"Annex 1"]
[null,"Determination of seasonal factors "]

{"sheet":"Seasonal factors","index":1,"n_rows":190,"n_cols":7,"rows_kept":190,"cut":false,"hidden":false,"merged":[[38,7,38,9],[141,2,141,4],[166,3,166,4],[176,3,176,6],[157,1,157,6],[162,1,162,6],[114,1,115,1],[141,1,142,1],[18,2,18,6],[18,1,19,1],[3,1,3,5],[4,1,4,5],[136,1,136,6],[114,2,114,4],[38,1,38,6],[2,1,2,5],[34,1,34,6],[34,7,34,9],[162,7,162,9],[41,1,41,6],[41,7,41,9],[59,1,59,6],[59,7,59,9],[78,1,78,6],[78,7,78,8],[95,1,95,6],[95,7,95,9],[112,1,112,6],[112,7,112,9],[132,1,132,6],[132,7,132,9]]}
[]
[]
[null,"Determination of seasonal factors in line with Article 15"]
[null,"of Commission Regulation (EU) 2017/460"]
[null,"of 16 March 2017 establishing a network code on harmonised transmission tariff structures for gas"]
[]
[null,"Calculation parameters"]
[null,null,null,null,"Values"]
[null,"Multipliers for quarterly standard capacity products",null,null,1.4000000000000001]
[null,"Multipliers for monthly standard capacity products (max 1.5)",null,null,1.5]
[null,"Multipliers for daily standard capacity products (max 3)",null,null,3]
[null,"Multipliers for the within-day standard capacity products (max 3)",null,null,3]
[null,"Power E (0 <= E <= 2)",null,null,1.5]
[]
[]
[]
[null,"Average hourly allocation for each month [kWh]"]
[]
[null,"Gas month","Year"]
[null,null,"2014","2015","2016","2017","2018*"]
[null,"January",2486862.7567741927,2821679.7182056447,3500363.1081908597,4116951.5595362904,1938809.4722782264]
[null,"February",2342931.9977678573,2938983.7887723208,3117740.4901293097,3555490.1545624998,2422655.3620543159]
[null,"March",1906810.1789314512,2377780.2645233166,3048177.7283100458,2784431.9965890893,2145703.4443789446]
[null,"April ",1889695.6549722219,1836989.7379750002,2431677.5449895835,2454214.8166222223,1284763.4861125001]
[null,"May",1656322.5139247312,1730779.8283125001,1956984.550830645,2236618.4947620966,1117768.2224220431]
[null,"June ",1800781.6047222218,1715589.2310027783,2078140.0353993059,2374953.8225874999,1045506.1645824481]
[null,"July",1869861.3641129034,1822829.0661626342,1355156.7893044353,2511863.9107022858,953024.29099462472]
[null,"August",1878408.4612903227,1349329.0082560484,1943557.3439946237,2643421.3518689522,941550.52018548397]
[null,"September",2102434.1444166671,1806583.2310972223,2331034.844167361,2421504.0970277772,1051704.752875]
[null,"October",2415251.2674193545,2572760.6397849466,2935681.6641532243,1819172.9111129034,1223645.4515268817]
[null,"November",2708023.9140625,2925143.5335895843,3327375.0536590279,1938760.2594569447,1568609.5499861112]
[null,"December",2955218.6382258064,3614889.9518870967,3577382.2814516132,2435287.8359381724,1775922.6913467741]
[null,"Average",{"$f":"AVERAGE(C21:C32)","v":2167716.8747183522},{"$f":"AVERAGE(D21:D32)","v":2292778.1666307575},2633605.9528816701,2607722.6008972279,1455805.2840619462]
[]
[null,"* part of data for 2018 determined on the basis of forecasted flows."]
[]
[]
[null,"The prescribed calculation procedure in line with Article 15 (paragraph from 2 to 5)"]
[null,"Note: The procedure for calculating seasonal factors for monthly standard capacity products for firm capacity for 2019 is based on the forecasted flows"]
[]
[null,"Article 15 (3) points a & b"]
[null,"(a) “the average data on the forecasted flows or the forecasted contracted capacity, \n       where the seasonal factors are calculated for some or all of the interconnection points”\n(b) the resulting values referred to in point (a) shall be summed up”"]
[]
[null,"Gas month","Forecasted average hourly gas  flow in 2019 \n[kWh]"]
[null,"January",2093914.2300604847]
[null,"February",2083483.6113667116]
[null,"March",2038418.2721599971]
[null,"April ",1284763.4861125001]
[null,"May",1101001.6990857124]
[null,"June ",1029823.5721137114]
[null,"July",938728.92662970535]
[null,"August",927427.26238270174]
[null,"September",1035929.181581875]
[null,"October",1223645.4515268817]
[null,"November",1607824.7887357639]
[null,"December",1989033.4143083871]
[null,"Sum",{"$f":"SUM(C45:C56)","v":17353993.89606443}]
[]
[null,"Article 15 (3) point c"]
[null,"“the usage rate shall be calculated by dividing each of the resulting values referred to in point (a) by the resulting value referred to in point (b);"]
[]
[]
[null,"Gas month","The usage rate","Correction of the usage rate In case the value is 0"]
[null,"January",{"$f":"C45/$C$57","v":0.1206589239688131},{"$f":"IF(C45/$C$57=0,0.1,C45/$C$57)","v":0.1206589239688131}]
[null,"February",{"$f":"C46/$C$57","v":0.12005787393063494},{"$f":"IF(C46/$C$57=0,0.1,C46/$C$57)","v":0.12005787393063494}]
[null,"March",0.11746104581852326,0.11746104581852326]
[null,"April ",7.403272663383044E-2,7.403272663383044E-2]
[null,"May",6.3443706715570508E-2,6.3443706715570508E-2]
[null,"June ",5.934216516851816E-2,5.934216516851816E-2]
[null,"July",5.4092961669336068E-2,5.4092961669336068E-2]
[null,"August",5.3441718830673633E-2,5.3441718830673633E-2]
[null,"September",5.9693992506059647E-2,5.9693992506059647E-2]
[null,"October",7.051088405674627E-2,7.051088405674627E-2]
[null,"November",9.2648689308366602E-2,9.2648689308366602E-2]
[null,"December",0.11461531139292745,0.11461531139292745]
[]
[]
[null,"Article 15(3) point d"]
[null,"“each of the resulting values referred to in point (c) shall be multiplied by 12. Where the resulting values are equal to 0, these values shall be adjusted to whichever of the following is the lower: 0,1 or the lowest of the resulting values other than 0”"]
[]
[null,"Gas month","The usage rate x 12"]
[null,"January",{"$f":"IF(C64=0,MIN($D$64:$D$75),C64)*12","v":1.4479070876257571}]
[null,"February",1.4406944871676193]
[null,"March",1.4095325498222793]
[null,"April ",0.88839271960596533]
[null,"May",0.7613244805868461]
[null,"June ",0.71210598202221798]
[null,"July",0.64911554003203276]
[null,"August",0.64130062596808357]
[null,"September",0.71632791007271579]
[null,"October",0.84613060868095524]
[null,"November",1.1117842717003992]
[null,"December",1.3753837367151294]
[]
[null,"Article 15(3) point e"]
[null,"“the initial level of the respective seasonal factors shall be calculated by raising each of the resulting values referred to in point (d) to the same power which is no less than 0 and no more than 2”"]
[]
[null,"Gas month","Seasonal factor"]
[null,"January",{"$f":"POWER(C82,$E$13)","v":1.7422522780181731}]
[null,"February",{"$f":"POWER(C83,$E$13)","v":1.7292502276122348}]
[null,"March",1.673449703785201]
[null,"April ",0.83735089000531604]
[null,"May",0.66428537690639877]
[null,"June ",0.60092040474921471]
[null,"July",{"$f":"POWER(C88,$E$13)","v":0.52297750594467607}]
[null,"August",0.51356154384391095]
[null,"September",0.60627241583112379]
[null,"October",0.77831626956213651]
[null,"November",1.1722784697500659]
[null,"December",1.6130054213051581]
[]
[null,"Article 15(3) point f"]
[null,"“the arithmetic mean of the products of the resulting values referred to in point (e) and the multiplier for monthly standard capacity products shall be calculated”"]
[]
[null,"Gas month","The initial level of a seasonal factor x multiplier"]
[null,null,"Monthly","Daily","Within-day"]
[null,"January",{"$f":"C99*$E$10","v":2.6133784170272598},{"$f":"C99*$E$11","v":5.2267568340545196},{"$f":"C99*$E$12","v":5.2267568340545196}]
[null,"February",{"$f":"C100*$E$10","v":2.593875341418352},{"$f":"C100*$E$11","v":5.1877506828367039},{"$f":"C100*$E$12","v":5.1877506828367039}]
[null,"March",2.5101745556778017,5.0203491113556034,5.0203491113556034]
[null,"April ",1.2560263350079741,2.5120526700159482,2.5120526700159482]
[null,"May",0.99642806535959816,1.9928561307191963,1.9928561307191963]
[null,"June ",0.90138060712382206,1.8027612142476441,1.8027612142476441]
[null,"July",0.78446625891701416,1.5689325178340283,1.5689325178340283]
[null,"August",0.77034231576586643,1.5406846315317329,1.5406846315317329]
[null,"September",0.90940862374668563,1.8188172474933713,1.8188172474933713]
[null,"October",1.1674744043432048,2.3349488086864096,2.3349488086864096]
[null,"November",1.7584177046250988,3.5168354092501977,3.5168354092501977]
[null,"December",2.4195081319577372,4.8390162639154743,4.8390162639154743]
[null,"Average",{"$f":"AVERAGE(C117:C128)","v":1.5567400634142012},{"$f":"AVERAGE(D117:D128)","v":3.1134801268284025},{"$f":"AVERAGE(E117:E128)","v":3.1134801268284025}]
[]
[null,"Article 15(3) point g"]
[null,"“the resulting value referred to in point (f) shall be compared with the range referred to in Article 13(1), as follows:"]
[null,"(i) if this value falls within this range then the level of seasonal factors shall be equal to with the respective resulting values referred to in point (e); (ii) if this value falls outside of this range then point (h) shall apply”"]
[]
[null,"Article 15(3) point h"]
[null,"\"the level of seasonal factors shall be calculated as the product of the respective resulting values referred to in point (e) and the correction factor calculated as follows:"]
[null,"i) where the resulting value referred to in point (f) is more than 1.5, the correction factor shall be calculated as 1.5 divided by this value; ii) where the resulting value referred to in point (f) is less than 1, the correction factor shall be calculated as 1 divided by this value.\""]
[]
[null,null,"Monthly","Daily","Within-day"]
[null,"Correction factor",{"$f":"1.5/C129","v":0.96355199898320831},{"$f":"3/D129","v":0.96355199898320831},{"$f":"3/E129","v":0.96355199898320831}]
[]
[null,"Gas month","Seasonal factor"]
[null,null,"Monthly","Daily","Within-day"]
[null,"January",{"$f":"IF($C$129>1.5,C99*$C$140,C99)","v":1.6787506652174591},{"$f":"IF($D$129>3,C99*$D$140,C99)","v":1.6787506652174591},{"$f":"IF($E$129>3,C99*$E$140,C99)","v":1.6787506652174591}]
[null,"February",{"$f":"IF($C$129>1.5,C100*$C$140,C100)","v":1.6662225135579367},{"$f":"IF($D$129>3,C100*$D$140,C100)","v":1.6662225135579367},{"$f":"IF($E$129>3,C100*$E$140,C100)","v":1.6662225135579367}]
[null,"March",1.6124558072800883,1.6124558072800883,1.6124558072800883]
[null,"April ",0.8068311239149909,0.8068311239149909,0.8068311239149909]
[null,"May",0.64007350281347453,0.64007350281347453,0.64007350281347453]
[null,"June ",0.57901805722590449,0.57901805722590449,0.57901805722590449]
[null,"July",0.50391602127624535,0.50391602127624535,0.50391602127624535]
[null,"August",0.494843252171703,0.494843252171703,0.494843252171703]
[null,"September",0.58417499820245822,0.58417499820245822,0.58417499820245822]
[null,"October",0.7499481973777502,0.7499481973777502,0.7499481973777502]
[null,"November",1.1295512628926525,1.1295512628926525,1.1295512628926525]
[null,"December",1.5542145980693371,1.5542145980693371,1.5542145980693371]
[]
[null,"Article 15(4)"]
[null,"“For daily standard capacity products for firm capacity and within-day standard capacity products for firm capacity, the seasonal factors shall be calculated by carrying out the steps set out in paragraph 3(f) to (h), mutatis mutandis.”"]
[]
[]
[null,"Article 15(5)"]
[null,"“For quarterly standard capacity products for firm capacity, the seasonal factors shall be calculated in sequential steps as follows:"]
[null,"(a) the initial level of the respective seasonal factors shall be calculated as either of the following:\n     (i) equal to the arithmetic mean of the respective seasonal factors applicable for the three relevant months; \n     (ii) (ii) no less than the lowest and no more than the highest level of the respective seasonal factors applicable for the three relevant months.”"]
[]
[null,"“(b) the steps set out in paragraph 3(f) to (h) shall be carried out, using the resulting values referred to in point (a), mutatis mutandis.”"]
[]
[null,null,"(i) Arithmetic mean","(ii) Minimum <=seasonal factor <= maximum"]
[null,"Gas quarter","Seasonal factor","Seasonal factorminimum","Seasonal factormaximum"]
[null,"Q2",{"$f":"AVERAGE($C$144:$C$146)","v":1.6524763286851616},{"$f":"MIN($C$144:$C$146)","v":1.6124558072800883},{"$f":"MAX($C$144:$C$146)","v":1.6787506652174591}]
[null,"Q3",{"$f":"AVERAGE($C$147:$C$149)","v":0.67530756131812331},{"$f":"MIN($C$147:$C$149)","v":0.57901805722590449},{"$f":"MAX($C$147:$C$149)","v":0.8068311239149909}]
[null,"Q4",{"$f":"AVERAGE($C$150:$C$152)","v":0.52764475721680215},{"$f":"MIN($C$150:$C$152)","v":0.494843252171703},{"$f":"MAX($C$150:$C$152)","v":0.58417499820245822}]
[null,"Q1",{"$f":"AVERAGE($C$153:$C$155)","v":1.1445713527799133},{"$f":"MIN($C$153:$C$155)","v":0.7499481973777502},{"$f":"MAX($C$153:$C$155)","v":1.5542145980693371}]
[]
[null,"Article 15(6)"]
[null,"“For all non-yearly standard capacity products for firm capacity, the values resulting from the calculation referred to in paragraphs 3 to 5 may be rounded up or down.”"]
[]
[null,null,null,"Seasonal factor"]
[null,"Gas month",{"$f":"C44","v":"Forecasted average hourly gas  flow in 2019 \n[kWh]"},"Quarterly","Monthly","Daily","Within-day"]
[null,"January",{"$f":"C45","v":2093914.2300604847},{"$f":"ROUND($C$169,3)","v":1.6519999999999999},{"$f":"ROUND(C144,3)","v":1.679},{"$f":"ROUND(D144,3)","v":1.679},{"$f":"ROUND(E144,3)","v":1.679}]
[null,"February",{"$f":"C46","v":2083483.6113667116},{"$f":"ROUND($C$169,3)","v":1.6519999999999999},1.6659999999999999,1.6659999999999999,1.6659999999999999]
[null,"March",2038418.2721599971,1.6519999999999999,1.6120000000000001,1.6120000000000001,1.6120000000000001]
[null,"April ",1284763.4861125001,{"$f":"ROUND($C$170,3)","v":0.67500000000000004},0.80700000000000005,0.80700000000000005,0.80700000000000005]
[null,"May",1101001.6990857124,{"$f":"ROUND($C$170,3)","v":0.67500000000000004},0.64,0.64,0.64]
[null,"June ",1029823.5721137114,0.67500000000000004,0.57899999999999996,0.57899999999999996,0.57899999999999996]
[null,"July",938728.92662970535,{"$f":"ROUND($C$171,3)","v":0.52800000000000002},0.504,0.504,0.504]
[null,"August",927427.26238270174,{"$f":"ROUND($C$171,3)","v":0.52800000000000002},0.495,0.495,0.495]
[null,"September",1035929.181581875,0.52800000000000002,0.58399999999999996,0.58399999999999996,0.58399999999999996]
[null,"October",1223645.4515268817,{"$f":"ROUND($C$172,3)","v":1.145},0.75,0.75,0.75]
[null,"November",1607824.7887357639,{"$f":"ROUND($C$172,3)","v":1.145},1.1299999999999999,1.1299999999999999,1.1299999999999999]
[null,"December",1989033.4143083871,1.145,1.554,1.554,1.554]