{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["EXPLANATION","Period booking","Total prices","Transmission tariffs","Neutrality charge","bladen rechts alleen voor inter","Optimisation","Multipliers and SF","Validation"],"not_rendered":{"images":9,"macros":1,"external_links":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"EXPLANATION","index":0,"n_rows":66,"n_cols":9,"rows_kept":66,"merged":[[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[25,1,27,10],[29,1,32,10],[34,2,36,10],[38,2,40,10],[42,2,44,10],[48,2,48,10],[50,2,51,10],[53,2,54,10],[56,2,58,10],[61,1,62,10],[65,1,67,10]]}
[]
[]
[]
[null,"DISCLAIMER"]
[]
[null,"- GTS only provide's this file as service, no rights whatsoever may be derived from these calculations, shipper' bookings and GTS Invoices are leading."]
[null,"- Tariffs used in the calculation are the total prices for 2027"]
[null,"- Total price is the sum of the all-in transmission tariff and the neutrality charge, whereby:"]
[null,"- transmission tariffs for 2027 are established by the Dutch regulator ACM (26 May 2026)"]
[null,"- neutrality charges for 2027 are established by GTS in accordance with the calculation methodology as stated in de Transmission Code Gas TSO"]
[null,null,"Tariff decision 2027 › Gasunie Transport Services"]
[null,"- Multipliers and seasonal factors used as established by the Duth regulator ACM in the NC TAR decision (25 April 2024):"]
[null,null,"https://www.acm.nl/nl/publicaties/codebesluit-ter-uitvoering-van-nc-tar",{"$nulls":5},"(Dutch)"]
[]
[null,"LEGEND"]
[]
[null,"GREEN",null,null,"Input cells to be filled out by user"]
[null,"BLUE",null,null,"Fixed input data"]
[null,"YELLOW",null,null,"Calculated value "]
[null,"ORANGE",null,null,"Calculated resulting value"]
[null,"BLACK",null,null,"Information sheets (this explanation sheet and sheets with calculation of the total prices)"]
[]
[null,"EXPLANATION CALCULATION TOOL PERIOD BOOKING"]
[]
[null,"Introduction"]
[null,"This tool converts a flat (non-profiled) booking for a booking period of less than one year into an optimum combination of yearly, quarterly, monthly and daily capacity products. The tool determines the cheapest combination in line with (a) - (c) of the 'optimisation paragraphs' of described in article 2.1.2. of the Transmission Code Gas TSO (quote): "]
[]
[]
[]
[null,"“If a recognised programme-responsible party or connected parties with exit capacity at domestic entry and exit points contract entry or exit capacity at an entry or exit point on the same day in any given combination of quarterly, monthly, and daily capacity products, the network operator of the national gas transmission grid shall, at the request of the recognised programme-responsible party or connected parties with exit capacity, do the following for each tranche of the same quantity of contracted entry or exit capacity: "]
[]
[]
[]
[]
[null,"a.","If the payable price for the combination of contracted quarterly, monthly, and daily capacity products is greater than the price of a yearly capacity product, then the yearly capacity product shall be contracted for the tranche in question, provided the required capacity is available at the relevant entry or exit point; "]
[]
[]
[]
[null,"b.","If the payable price for the combination of contracted monthly and daily capacity products in one gas quarter is greater than the price of the relevant quarterly capacity product, then the relevant quarterly capacity product shall be contracted, provided the required capacity is available at the relevant entry or exit point; or "]
[]
[]
[]
[null,"c.","If the payable price for the combination of contracted daily capacity products in one month is greater than the payable price for the monthly capacity product, then the relevant monthly capacity product shall be contracted, provided the required capacity is available at the relevant entry or exit point.”"]
[]
[]
[]
[null,"The main steps in the optimisation are"]
[]
[null,"*","the period booking is converted into non-optimised subsequent capacity products;"]
[]
[null,"*","if the payable price for the combination of daily capacity products in one month is greater than the payable price for the monthly capacity product, then the relevant monthly capacity products applies;"]
[]
[]
[null,"*","if the payable price for the combination of monthly and daily capacity products in one gas quarter is greater than the price of the relevant quarterly capacity products, then the relevant quarterly capacity product applies;"]
[]
[]
[null,"*","if the payable price for the combination of quarterly, monthly and daily capacity products is greater than the price for a yearly capacity product, then the relevant yearly capacity product applies. When the by the shipper chosen period leads to less than 12 consecutive months in the yearly booking, shipper is requested to adjust the start or end date creating 12 consecutive months in the yearly booking."]
[]
[]
[]
[null,"Output"]
[null,"For the period of shipper’s choosing the resulting capacity products are shown including the corresponding estimated monthly invoice \n(based on 2027 total price)."]
[]
[]
[null,"Disclaimer"]
[null,"This calculation tool advises shippers the cheapest combination of capacity products, based on the given input. Shippers obviously remain responsible for (timely) contracting the right (combination of) capacity products themselves. No rights or whatsoever can be derived from this calculation tool. "]

{"sheet":"Period booking","index":1,"n_rows":42,"n_cols":8,"rows_kept":42,"merged":[[3,1,4,10],[12,1,12,7],[17,13,17,14]]}
[]
[]
[]
[null,"CALCULATION TOOL FOR OPTIMISATION OF PERIOD BOOKINGS INTO (Y, Q, M, DA) FIRM CAPACITY PRODUCTS"]
[]
[null,"Please fill in the appropriate values in the GREEN fields and find the optimalisation results below"]
[]
[null,"Start date",{"$f":"IF(OR(ISERROR(DAY($D$8)),ISERROR(DAY($D$9))),1,IF(OR($D$9<$D$8,$D$9>$D$8+366,$D$11<0),1,0))","v":0},"2027-03-01",{"$f":"IF(OR(ISERROR(DAY($D$8)),ISERROR(DAY($D$9))),\"WARNING: calculation not reliable due to incorrect start or end date; please correct!\",IF(D9<D8,\"WARNING: calculation not reliable due to incorrect start and end date (start date NOT before end date); please correct!\",IF(D9>D8+366,\" WARNING: calculation not reliable due to incorrect start and end date (period > 1 year), please correct!\",\"\")))","v":""}]
[null,"End date (including)",null,"2027-07-01",{"$f":"IF(Optimisation!$T$53=11,\"REMARK: for this period a yearly booking is cheaper; please add 12th month to period for monthly cost estimate!\",IF(Optimisation!$T$53=10,\"REMARK: for this period a yearly booking is cheaper; please add 11th and 12th month to period for monthly cost estimate!\",IF(Optimisation!$T$53=9,\"REMARK: for this period a yearly booking is cheaper; please add 10th, 11th and 12th month to period for monthly cost estimate!\",\"\")))","v":""}]
[null,"Postage stamp point",null,"Exit non-storage","For all dates/periods, the prices used in the calculation tool are the total prices 2027 (see sheet 'Explanation')"]
[null,"Quantity ","kWh/h",{"v":500000,"d":"500,000"},{"$f":"IF(D11<0,\"WARNING: quantity is negative, please correct to positive value!\",\"\")","v":""}]
[]
[null,"PERIOD BOOKING CONVERTED INTO OPTIMISED COMBINATION OF Y, Q, M, DA CAPACITY PRODUCTS"]
[]
[null,"Month","Year","Yearly capacity booking","Quarterly capacity booking","Monthly capacity booking","Daily capacity \nbooking","Cost/month\nbased on 2027 tariffs"]
[{"$nulls":3},"kWh/h","kWh/h","kWh/h","kWh/h","EUR"]
[]
[{"$nulls":6},"Total cost:",{"$f":"SUM(H19:H42)","v":{"v":1019090.43,"d":"€ 1,019,090"}}]
[null,"January",{"$f":"IF($C$8=1,\"\",YEAR(D$8))","v":2027},{"$f":"IF($C$8=1,\"\",Optimisation!Y29)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z29)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA29)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB29)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X29)","v":{"v":0,"d":"€ 0"}}]
[null,"February",{"$f":"IF($C$8=1,\"\",YEAR(D$8))","v":2027},{"$f":"IF($C$8=1,\"\",Optimisation!Y30)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z30)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA30)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB30)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X30)","v":{"v":0,"d":"€ 0"}}]
[null,"March",2027,{"$f":"IF($C$8=1,\"\",Optimisation!Y31)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z31)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA31)","v":"M3"},{"$f":"IF($C$8=1,\"\",Optimisation!AB31)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X31)","v":{"v":388978.915,"d":"€ 388,979"}}]
[null,"April",2027,{"$f":"IF($C$8=1,\"\",Optimisation!Y32)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z32)","v":"Q2"},{"$f":"IF($C$8=1,\"\",Optimisation!AA32)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB32)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X32)","v":{"v":205116.80934065938,"d":"€ 205,117"}}]
[null,"May",2027,{"$f":"IF($C$8=1,\"\",Optimisation!Y33)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z33)","v":"Q2"},{"$f":"IF($C$8=1,\"\",Optimisation!AA33)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB33)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X33)","v":{"v":211954.03631868132,"d":"€ 211,954"}}]
[null,"June",2027,{"$f":"IF($C$8=1,\"\",Optimisation!Y34)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z34)","v":"Q2"},{"$f":"IF($C$8=1,\"\",Optimisation!AA34)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB34)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X34)","v":{"v":205116.80934065938,"d":"€ 205,117"}}]
[null,"July",2027,{"$f":"IF($C$8=1,\"\",Optimisation!Y35)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z35)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA35)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB35)","v":1},{"$f":"IF($C$8=1,\"\",Optimisation!X35)","v":{"v":7923.86,"d":"€ 7,924"}}]
[null,"August",2027,{"$f":"IF($C$8=1,\"\",Optimisation!Y36)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z36)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA36)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB36)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X36)","v":{"v":0,"d":"€ 0"}}]
[null,"September",2027,{"$f":"IF($C$8=1,\"\",Optimisation!Y37)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z37)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA37)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB37)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X37)","v":{"v":0,"d":"€ 0"}}]
[null,"October",2027,{"$f":"IF($C$8=1,\"\",Optimisation!Y38)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z38)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA38)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB38)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X38)","v":{"v":0,"d":"€ 0"}}]
[null,"November",2027,{"$f":"IF($C$8=1,\"\",Optimisation!Y39)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z39)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA39)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB39)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X39)","v":{"v":0,"d":"€ 0"}}]
[null,"December",2027,{"$f":"IF($C$8=1,\"\",Optimisation!Y40)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z40)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA40)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB40)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X40)","v":{"v":0,"d":"€ 0"}}]
[null,"January",{"$f":"IF($C$8=1,\"\",YEAR(D$8)+1)","v":2028},{"$f":"IF($C$8=1,\"\",Optimisation!Y41)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z41)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA41)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB41)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X41)","v":{"v":0,"d":"€ 0"}}]
[null,"February",{"$f":"IF($C$8=1,\"\",YEAR(D$8)+1)","v":2028},{"$f":"IF($C$8=1,\"\",Optimisation!Y42)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z42)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA42)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB42)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X42)","v":{"v":0,"d":"€ 0"}}]
[null,"March",2028,{"$f":"IF($C$8=1,\"\",Optimisation!Y43)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z43)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA43)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB43)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X43)","v":{"v":0,"d":"€ 0"}}]
[null,"April",2028,{"$f":"IF($C$8=1,\"\",Optimisation!Y44)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z44)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA44)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB44)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X44)","v":{"v":0,"d":"€ 0"}}]
[null,"May",2028,{"$f":"IF($C$8=1,\"\",Optimisation!Y45)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z45)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA45)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB45)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X45)","v":{"v":0,"d":"€ 0"}}]
[null,"June",2028,{"$f":"IF($C$8=1,\"\",Optimisation!Y46)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z46)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA46)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB46)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X46)","v":{"v":0,"d":"€ 0"}}]
[null,"July",2028,{"$f":"IF($C$8=1,\"\",Optimisation!Y47)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z47)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA47)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB47)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X47)","v":{"v":0,"d":"€ 0"}}]
[null,"August",2028,{"$f":"IF($C$8=1,\"\",Optimisation!Y48)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z48)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA48)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB48)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X48)","v":{"v":0,"d":"€ 0"}}]
[null,"September",2028,{"$f":"IF($C$8=1,\"\",Optimisation!Y49)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z49)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA49)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB49)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X49)","v":{"v":0,"d":"€ 0"}}]
[null,"October",2028,{"$f":"IF($C$8=1,\"\",Optimisation!Y50)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z50)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA50)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB50)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X50)","v":{"v":0,"d":"€ 0"}}]
[null,"November",2028,{"$f":"IF($C$8=1,\"\",Optimisation!Y51)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z51)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA51)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB51)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X51)","v":{"v":0,"d":"€ 0"}}]
[null,"December",2028,{"$f":"IF($C$8=1,\"\",Optimisation!Y52)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!Z52)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AA52)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!AB52)","v":""},{"$f":"IF($C$8=1,\"\",Optimisation!X52)","v":{"v":0,"d":"€ 0"}}]

{"sheet":"Total prices","index":2,"n_rows":42,"n_cols":19,"rows_kept":42,"merged":[[7,2,7,6],[7,8,7,12],[7,14,7,18],[12,2,23,2],[12,3,14,3],[12,8,23,8],[12,9,14,9],[12,14,23,14],[12,15,14,15],[15,3,17,3],[15,9,17,9],[15,15,17,15],[18,3,20,3],[18,9,20,9],[18,15,20,15],[21,3,23,3],[21,9,23,9],[21,15,23,15],[25,2,25,6],[25,8,25,12],[30,2,41,2],[30,3,32,3],[30,8,41,8],[30,9,32,9],[33,3,35,3],[33,9,35,9],[36,3,38,3],[36,9,38,9],[39,3,41,3],[39,9,41,9]]}
[]
[]
[]
[null,"TOTAL PRICES 2027 FIRM CAPACITY (which is sum of the all-in transmission tariffs and the neutrality charges)"]
[]
[]
[]
[null,"Total prices FIRM capacity for interconnection points","ENTRY REGULAR",{"$nulls":5},"ENTRY STORAGE",{"$nulls":5},"ENTRY LNG"]
[null,"Payable total prices FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"January",{"$f":"'Transmission tariffs'!C13+'Neutrality charge'!C13","v":{"v":5.4725366399999995,"d":"5.47253664"}},{"$f":"'Transmission tariffs'!D13+'Neutrality charge'!D13","v":{"v":2.4997497799999997,"d":"2.49974978"}},{"$f":"'Transmission tariffs'!E13+'Neutrality charge'!E13","v":1.19567429},{"$f":"'Transmission tariffs'!F13+'Neutrality charge'!F13","v":0.04652031},{"$f":"'Transmission tariffs'!G13+'Neutrality charge'!G13","v":0.00193835},null,{"$f":"'Transmission tariffs'!I13+'Neutrality charge'!I13","v":{"v":1.3681341699999998,"d":"1.36813417"}},{"$f":"'Transmission tariffs'!J13+'Neutrality charge'!J13","v":{"v":0.6249374499999999,"d":"0.62493745"}},{"$f":"'Transmission tariffs'!K13+'Neutrality charge'!K13","v":0.29891858},{"$f":"'Transmission tariffs'!L13+'Neutrality charge'!L13","v":{"v":0.011630080000000001,"d":"0.01163008"}},{"$f":"'Transmission tariffs'!M13+'Neutrality charge'!M13","v":0.00048459},null,{"$f":"'Transmission tariffs'!O13+'Neutrality charge'!O13","v":{"v":5.4725366399999995,"d":"5.47253664"}},{"$f":"'Transmission tariffs'!P13+'Neutrality charge'!P13","v":{"v":2.4997497799999997,"d":"2.49974978"}},{"$f":"'Transmission tariffs'!Q13+'Neutrality charge'!Q13","v":1.19567429},{"$f":"'Transmission tariffs'!R13+'Neutrality charge'!R13","v":0.04652031},{"$f":"'Transmission tariffs'!S13+'Neutrality charge'!S13","v":0.00193835}]
[null,"February",null,null,{"$f":"'Transmission tariffs'!E14+'Neutrality charge'!E14","v":0.96535546},{"$f":"'Transmission tariffs'!F14+'Neutrality charge'!F14","v":0.04158753},{"$f":"'Transmission tariffs'!G14+'Neutrality charge'!G14","v":{"v":1.73281E-3,"d":"0.00173281"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K14+'Neutrality charge'!K14","v":0.24133887},{"$f":"'Transmission tariffs'!L14+'Neutrality charge'!L14","v":{"v":0.010396879999999999,"d":"0.01039688"}},{"$f":"'Transmission tariffs'!M14+'Neutrality charge'!M14","v":{"v":0.0004332,"d":"0.00043320"}},{"$nulls":3},{"$f":"'Transmission tariffs'!Q14+'Neutrality charge'!Q14","v":0.96535546},{"$f":"'Transmission tariffs'!R14+'Neutrality charge'!R14","v":0.04158753},{"$f":"'Transmission tariffs'!S14+'Neutrality charge'!S14","v":{"v":1.73281E-3,"d":"0.00173281"}}]
[null,"March",null,null,{"$f":"'Transmission tariffs'!E15+'Neutrality charge'!E15","v":0.83592623},{"$f":"'Transmission tariffs'!F15+'Neutrality charge'!F15","v":0.03250911},{"$f":"'Transmission tariffs'!G15+'Neutrality charge'!G15","v":{"v":1.35454E-3,"d":"0.00135454"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K15+'Neutrality charge'!K15","v":{"v":0.20898155000000002,"d":"0.20898155"}},{"$f":"'Transmission tariffs'!L15+'Neutrality charge'!L15","v":{"v":0.008127279999999999,"d":"0.00812728"}},{"$f":"'Transmission tariffs'!M15+'Neutrality charge'!M15","v":0.00033863},{"$nulls":3},{"$f":"'Transmission tariffs'!Q15+'Neutrality charge'!Q15","v":0.83592623},{"$f":"'Transmission tariffs'!R15+'Neutrality charge'!R15","v":0.03250911},{"$f":"'Transmission tariffs'!S15+'Neutrality charge'!S15","v":{"v":1.35454E-3,"d":"0.00135454"}}]
[null,"April",null,{"$f":"'Transmission tariffs'!D16+'Neutrality charge'!D16","v":1.33709813},{"$f":"'Transmission tariffs'!E16+'Neutrality charge'!E16","v":{"v":0.6031785,"d":"0.60317850"}},{"$f":"'Transmission tariffs'!F16+'Neutrality charge'!F16","v":{"v":0.024244079999999998,"d":"0.02424408"}},{"$f":"'Transmission tariffs'!G16+'Neutrality charge'!G16","v":0.00101017},null,null,{"$f":"'Transmission tariffs'!J16+'Neutrality charge'!J16","v":0.33427453},{"$f":"'Transmission tariffs'!K16+'Neutrality charge'!K16","v":0.15079462},{"$f":"'Transmission tariffs'!L16+'Neutrality charge'!L16","v":{"v":0.006061029999999999,"d":"0.00606103"}},{"$f":"'Transmission tariffs'!M16+'Neutrality charge'!M16","v":0.00025255},null,null,{"$f":"'Transmission tariffs'!P16+'Neutrality charge'!P16","v":1.33709813},{"$f":"'Transmission tariffs'!Q16+'Neutrality charge'!Q16","v":{"v":0.6031785,"d":"0.60317850"}},{"$f":"'Transmission tariffs'!R16+'Neutrality charge'!R16","v":{"v":0.024244079999999998,"d":"0.02424408"}},{"$f":"'Transmission tariffs'!S16+'Neutrality charge'!S16","v":0.00101017}]
[null,"May",null,null,{"$f":"'Transmission tariffs'!E17+'Neutrality charge'!E17","v":0.55217145},{"$f":"'Transmission tariffs'!F17+'Neutrality charge'!F17","v":{"v":0.021489079999999997,"d":"0.02148908"}},{"$f":"'Transmission tariffs'!G17+'Neutrality charge'!G17","v":0.00089538},{"$nulls":3},{"$f":"'Transmission tariffs'!K17+'Neutrality charge'!K17","v":{"v":0.13804286999999998,"d":"0.13804287"}},{"$f":"'Transmission tariffs'!L17+'Neutrality charge'!L17","v":{"v":0.005372259999999999,"d":"0.00537226"}},{"$f":"'Transmission tariffs'!M17+'Neutrality charge'!M17","v":{"v":2.2384E-4,"d":"0.00022384"}},{"$nulls":3},{"$f":"'Transmission tariffs'!Q17+'Neutrality charge'!Q17","v":0.55217145},{"$f":"'Transmission tariffs'!R17+'Neutrality charge'!R17","v":{"v":0.021489079999999997,"d":"0.02148908"}},{"$f":"'Transmission tariffs'!S17+'Neutrality charge'!S17","v":0.00089538}]
[null,"June",null,null,{"$f":"'Transmission tariffs'!E18+'Neutrality charge'!E18","v":{"v":0.44867303999999997,"d":"0.44867304"}},{"$f":"'Transmission tariffs'!F18+'Neutrality charge'!F18","v":0.01805187},{"$f":"'Transmission tariffs'!G18+'Neutrality charge'!G18","v":0.00075216},{"$nulls":3},{"$f":"'Transmission tariffs'!K18+'Neutrality charge'!K18","v":{"v":0.11216825999999999,"d":"0.11216826"}},{"$f":"'Transmission tariffs'!L18+'Neutrality charge'!L18","v":0.00451296},{"$f":"'Transmission tariffs'!M18+'Neutrality charge'!M18","v":{"v":1.8804E-4,"d":"0.00018804"}},{"$nulls":3},{"$f":"'Transmission tariffs'!Q18+'Neutrality charge'!Q18","v":{"v":0.44867303999999997,"d":"0.44867304"}},{"$f":"'Transmission tariffs'!R18+'Neutrality charge'!R18","v":0.01805187},{"$f":"'Transmission tariffs'!S18+'Neutrality charge'!S18","v":0.00075216}]
[null,"July",null,{"$f":"'Transmission tariffs'!D19+'Neutrality charge'!D19","v":{"v":1.0845368100000001,"d":"1.08453681"}},{"$f":"'Transmission tariffs'!E19+'Neutrality charge'!E19","v":{"v":0.43783290999999996,"d":"0.43783291"}},{"$f":"'Transmission tariffs'!F19+'Neutrality charge'!F19","v":0.01702858},{"$f":"'Transmission tariffs'!G19+'Neutrality charge'!G19","v":0.00070952},null,null,{"$f":"'Transmission tariffs'!J19+'Neutrality charge'!J19","v":{"v":0.2711342,"d":"0.27113420"}},{"$f":"'Transmission tariffs'!K19+'Neutrality charge'!K19","v":0.10945823},{"$f":"'Transmission tariffs'!L19+'Neutrality charge'!L19","v":{"v":4.2571499999999995E-3,"d":"0.00425715"}},{"$f":"'Transmission tariffs'!M19+'Neutrality charge'!M19","v":0.00017738},null,null,{"$f":"'Transmission tariffs'!P19+'Neutrality charge'!P19","v":{"v":1.0845368100000001,"d":"1.08453681"}},{"$f":"'Transmission tariffs'!Q19+'Neutrality charge'!Q19","v":{"v":0.43783290999999996,"d":"0.43783291"}},{"$f":"'Transmission tariffs'!R19+'Neutrality charge'!R19","v":0.01702858},{"$f":"'Transmission tariffs'!S19+'Neutrality charge'!S19","v":0.00070952}]
[null,"August",null,null,{"$f":"'Transmission tariffs'!E20+'Neutrality charge'!E20","v":0.41622015},{"$f":"'Transmission tariffs'!F20+'Neutrality charge'!F20","v":{"v":0.0162152,"d":"0.01621520"}},{"$f":"'Transmission tariffs'!G20+'Neutrality charge'!G20","v":0.00067564},{"$nulls":3},{"$f":"'Transmission tariffs'!K20+'Neutrality charge'!K20","v":0.10405504},{"$f":"'Transmission tariffs'!L20+'Neutrality charge'!L20","v":{"v":0.0040538,"d":"0.00405380"}},{"$f":"'Transmission tariffs'!M20+'Neutrality charge'!M20","v":0.00016891},{"$nulls":3},{"$f":"'Transmission tariffs'!Q20+'Neutrality charge'!Q20","v":0.41622015},{"$f":"'Transmission tariffs'!R20+'Neutrality charge'!R20","v":{"v":0.0162152,"d":"0.01621520"}},{"$f":"'Transmission tariffs'!S20+'Neutrality charge'!S20","v":0.00067564}]
[null,"September",null,null,{"$f":"'Transmission tariffs'!E21+'Neutrality charge'!E21","v":0.44732365},{"$f":"'Transmission tariffs'!F21+'Neutrality charge'!F21","v":{"v":0.017999400000000002,"d":"0.01799940"}},{"$f":"'Transmission tariffs'!G21+'Neutrality charge'!G21","v":0.00074997},{"$nulls":3},{"$f":"'Transmission tariffs'!K21+'Neutrality charge'!K21","v":0.11183091},{"$f":"'Transmission tariffs'!L21+'Neutrality charge'!L21","v":{"v":4.4998500000000006E-3,"d":"0.00449985"}},{"$f":"'Transmission tariffs'!M21+'Neutrality charge'!M21","v":{"v":1.8749999999999998E-4,"d":"0.00018750"}},{"$nulls":3},{"$f":"'Transmission tariffs'!Q21+'Neutrality charge'!Q21","v":0.44732365},{"$f":"'Transmission tariffs'!R21+'Neutrality charge'!R21","v":{"v":0.017999400000000002,"d":"0.01799940"}},{"$f":"'Transmission tariffs'!S21+'Neutrality charge'!S21","v":0.00074997}]
[null,"October",null,{"$f":"'Transmission tariffs'!D22+'Neutrality charge'!D22","v":1.90526738},{"$f":"'Transmission tariffs'!E22+'Neutrality charge'!E22","v":{"v":0.5305586800000001,"d":"0.53055868"}},{"$f":"'Transmission tariffs'!F22+'Neutrality charge'!F22","v":{"v":0.020649459999999998,"d":"0.02064946"}},{"$f":"'Transmission tariffs'!G22+'Neutrality charge'!G22","v":0.00086039},null,null,{"$f":"'Transmission tariffs'!J22+'Neutrality charge'!J22","v":0.47631685},{"$f":"'Transmission tariffs'!K22+'Neutrality charge'!K22","v":{"v":0.13263967000000002,"d":"0.13263967"}},{"$f":"'Transmission tariffs'!L22+'Neutrality charge'!L22","v":0.00516237},{"$f":"'Transmission tariffs'!M22+'Neutrality charge'!M22","v":{"v":2.1509E-4,"d":"0.00021509"}},null,null,{"$f":"'Transmission tariffs'!P22+'Neutrality charge'!P22","v":1.90526738},{"$f":"'Transmission tariffs'!Q22+'Neutrality charge'!Q22","v":{"v":0.5305586800000001,"d":"0.53055868"}},{"$f":"'Transmission tariffs'!R22+'Neutrality charge'!R22","v":{"v":0.020649459999999998,"d":"0.02064946"}},{"$f":"'Transmission tariffs'!S22+'Neutrality charge'!S22","v":0.00086039}]
[null,"November",null,null,{"$f":"'Transmission tariffs'!E23+'Neutrality charge'!E23","v":{"v":0.7624068199999999,"d":"0.76240682"}},{"$f":"'Transmission tariffs'!F23+'Neutrality charge'!F23","v":0.03064621},{"$f":"'Transmission tariffs'!G23+'Neutrality charge'!G23","v":{"v":1.27692E-3,"d":"0.00127692"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K23+'Neutrality charge'!K23","v":{"v":0.19060170999999998,"d":"0.19060171"}},{"$f":"'Transmission tariffs'!L23+'Neutrality charge'!L23","v":0.00766155},{"$f":"'Transmission tariffs'!M23+'Neutrality charge'!M23","v":0.00031923},{"$nulls":3},{"$f":"'Transmission tariffs'!Q23+'Neutrality charge'!Q23","v":{"v":0.7624068199999999,"d":"0.76240682"}},{"$f":"'Transmission tariffs'!R23+'Neutrality charge'!R23","v":0.03064621},{"$f":"'Transmission tariffs'!S23+'Neutrality charge'!S23","v":{"v":1.27692E-3,"d":"0.00127692"}}]
[null,"December",null,null,{"$f":"'Transmission tariffs'!E24+'Neutrality charge'!E24","v":0.99279312},{"$f":"'Transmission tariffs'!F24+'Neutrality charge'!F24","v":0.03862262},{"$f":"'Transmission tariffs'!G24+'Neutrality charge'!G24","v":{"v":1.6092699999999999E-3,"d":"0.00160927"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K24+'Neutrality charge'!K24","v":0.24819828},{"$f":"'Transmission tariffs'!L24+'Neutrality charge'!L24","v":{"v":9.65565E-3,"d":"0.00965565"}},{"$f":"'Transmission tariffs'!M24+'Neutrality charge'!M24","v":0.00040232},{"$nulls":3},{"$f":"'Transmission tariffs'!Q24+'Neutrality charge'!Q24","v":0.99279312},{"$f":"'Transmission tariffs'!R24+'Neutrality charge'!R24","v":0.03862262},{"$f":"'Transmission tariffs'!S24+'Neutrality charge'!S24","v":{"v":1.6092699999999999E-3,"d":"0.00160927"}}]
[]
[null,"Total prices FIRM capacity for interconnection points","EXIT NON-STORAGE",{"$nulls":5},"EXIT STORAGE"]
[null,"Payable total prices FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"January",{"$f":"'Transmission tariffs'!C31+'Neutrality charge'!C31","v":5.09303642},{"$f":"'Transmission tariffs'!D31+'Neutrality charge'!D31","v":2.32640137},{"$f":"'Transmission tariffs'!E31+'Neutrality charge'!E31","v":1.11275869},{"$f":"'Transmission tariffs'!F31+'Neutrality charge'!F31","v":{"v":0.0432943,"d":"0.04329430"}},{"$f":"'Transmission tariffs'!G31+'Neutrality charge'!G31","v":{"v":1.80393E-3,"d":"0.00180393"}},null,{"$f":"'Transmission tariffs'!I31+'Neutrality charge'!I31","v":{"v":1.2732591100000001,"d":"1.27325911"}},{"$f":"'Transmission tariffs'!J31+'Neutrality charge'!J31","v":0.58160034},{"$f":"'Transmission tariffs'!K31+'Neutrality charge'!K31","v":0.27818967},{"$f":"'Transmission tariffs'!L31+'Neutrality charge'!L31","v":0.01082358},{"$f":"'Transmission tariffs'!M31+'Neutrality charge'!M31","v":{"v":4.5097999999999997E-4,"d":"0.00045098"}}]
[null,"February",null,null,{"$f":"'Transmission tariffs'!E32+'Neutrality charge'!E32","v":0.89841163},{"$f":"'Transmission tariffs'!F32+'Neutrality charge'!F32","v":0.03870358},{"$f":"'Transmission tariffs'!G32+'Neutrality charge'!G32","v":{"v":1.61265E-3,"d":"0.00161265"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K32+'Neutrality charge'!K32","v":{"v":0.22460291000000002,"d":"0.22460291"}},{"$f":"'Transmission tariffs'!L32+'Neutrality charge'!L32","v":{"v":0.0096759,"d":"0.00967590"}},{"$f":"'Transmission tariffs'!M32+'Neutrality charge'!M32","v":{"v":4.0317E-4,"d":"0.00040317"}}]
[null,"March",null,null,{"$f":"'Transmission tariffs'!E33+'Neutrality charge'!E33","v":0.77795783},{"$f":"'Transmission tariffs'!F33+'Neutrality charge'!F33","v":0.03025473},{"$f":"'Transmission tariffs'!G33+'Neutrality charge'!G33","v":0.00126062},{"$nulls":3},{"$f":"'Transmission tariffs'!K33+'Neutrality charge'!K33","v":0.19448945},{"$f":"'Transmission tariffs'!L33+'Neutrality charge'!L33","v":0.00756369},{"$f":"'Transmission tariffs'!M33+'Neutrality charge'!M33","v":0.00031515}]
[null,"April",null,{"$f":"'Transmission tariffs'!D34+'Neutrality charge'!D34","v":{"v":1.2443753100000001,"d":"1.24437531"}},{"$f":"'Transmission tariffs'!E34+'Neutrality charge'!E34","v":0.56135029},{"$f":"'Transmission tariffs'!F34+'Neutrality charge'!F34","v":0.02256285},{"$f":"'Transmission tariffs'!G34+'Neutrality charge'!G34","v":{"v":9.4012000000000013E-4,"d":"0.00094012"}},null,null,{"$f":"'Transmission tariffs'!J34+'Neutrality charge'!J34","v":0.31109383},{"$f":"'Transmission tariffs'!K34+'Neutrality charge'!K34","v":0.14033757},{"$f":"'Transmission tariffs'!L34+'Neutrality charge'!L34","v":0.00564071},{"$f":"'Transmission tariffs'!M34+'Neutrality charge'!M34","v":{"v":2.3503E-4,"d":"0.00023503"}}]
[null,"May",null,null,{"$f":"'Transmission tariffs'!E35+'Neutrality charge'!E35","v":{"v":0.5138804,"d":"0.51388040"}},{"$f":"'Transmission tariffs'!F35+'Neutrality charge'!F35","v":{"v":0.019998890000000002,"d":"0.01999889"}},{"$f":"'Transmission tariffs'!G35+'Neutrality charge'!G35","v":0.00083328},{"$nulls":3},{"$f":"'Transmission tariffs'!K35+'Neutrality charge'!K35","v":{"v":0.1284701,"d":"0.12847010"}},{"$f":"'Transmission tariffs'!L35+'Neutrality charge'!L35","v":{"v":4.99973E-3,"d":"0.00499973"}},{"$f":"'Transmission tariffs'!M35+'Neutrality charge'!M35","v":0.00020832}]
[null,"June",null,null,{"$f":"'Transmission tariffs'!E36+'Neutrality charge'!E36","v":0.41755922},{"$f":"'Transmission tariffs'!F36+'Neutrality charge'!F36","v":{"v":0.016800040000000002,"d":"0.01680004"}},{"$f":"'Transmission tariffs'!G36+'Neutrality charge'!G36","v":{"v":7.000000000000001E-4,"d":"0.00070000"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K36+'Neutrality charge'!K36","v":{"v":0.1043898,"d":"0.10438980"}},{"$f":"'Transmission tariffs'!L36+'Neutrality charge'!L36","v":{"v":4.2000200000000005E-3,"d":"0.00420002"}},{"$f":"'Transmission tariffs'!M36+'Neutrality charge'!M36","v":{"v":1.75E-4,"d":"0.00017500"}}]
[null,"July",null,{"$f":"'Transmission tariffs'!D37+'Neutrality charge'!D37","v":1.00932819},{"$f":"'Transmission tariffs'!E37+'Neutrality charge'!E37","v":0.40747082},{"$f":"'Transmission tariffs'!F37+'Neutrality charge'!F37","v":0.01584772},{"$f":"'Transmission tariffs'!G37+'Neutrality charge'!G37","v":0.00066032},null,null,{"$f":"'Transmission tariffs'!J37+'Neutrality charge'!J37","v":0.25233205},{"$f":"'Transmission tariffs'!K37+'Neutrality charge'!K37","v":0.10186771},{"$f":"'Transmission tariffs'!L37+'Neutrality charge'!L37","v":0.00396193},{"$f":"'Transmission tariffs'!M37+'Neutrality charge'!M37","v":{"v":1.6507999999999998E-4,"d":"0.00016508"}}]
[null,"August",null,null,{"$f":"'Transmission tariffs'!E38+'Neutrality charge'!E38","v":0.38735681},{"$f":"'Transmission tariffs'!F38+'Neutrality charge'!F38","v":0.01509074},{"$f":"'Transmission tariffs'!G38+'Neutrality charge'!G38","v":{"v":6.2878000000000012E-4,"d":"0.00062878"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K38+'Neutrality charge'!K38","v":0.09683921},{"$f":"'Transmission tariffs'!L38+'Neutrality charge'!L38","v":{"v":3.77268E-3,"d":"0.00377268"}},{"$f":"'Transmission tariffs'!M38+'Neutrality charge'!M38","v":{"v":1.5718999999999998E-4,"d":"0.00015719"}}]
[null,"September",null,null,{"$f":"'Transmission tariffs'!E39+'Neutrality charge'!E39","v":{"v":0.4163034,"d":"0.41630340"}},{"$f":"'Transmission tariffs'!F39+'Neutrality charge'!F39","v":0.01675121},{"$f":"'Transmission tariffs'!G39+'Neutrality charge'!G39","v":{"v":6.9796000000000007E-4,"d":"0.00069796"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K39+'Neutrality charge'!K39","v":0.10407585},{"$f":"'Transmission tariffs'!L39+'Neutrality charge'!L39","v":{"v":0.0041878,"d":"0.00418780"}},{"$f":"'Transmission tariffs'!M39+'Neutrality charge'!M39","v":0.00017449}]
[null,"October",null,{"$f":"'Transmission tariffs'!D40+'Neutrality charge'!D40","v":1.77314412},{"$f":"'Transmission tariffs'!E40+'Neutrality charge'!E40","v":0.49376639},{"$f":"'Transmission tariffs'!F40+'Neutrality charge'!F40","v":0.01921749},{"$f":"'Transmission tariffs'!G40+'Neutrality charge'!G40","v":0.00080072},null,null,{"$f":"'Transmission tariffs'!J40+'Neutrality charge'!J40","v":0.44328603},{"$f":"'Transmission tariffs'!K40+'Neutrality charge'!K40","v":{"v":0.1234416,"d":"0.12344160"}},{"$f":"'Transmission tariffs'!L40+'Neutrality charge'!L40","v":0.00480438},{"$f":"'Transmission tariffs'!M40+'Neutrality charge'!M40","v":{"v":2.0018E-4,"d":"0.00020018"}}]
[null,"November",null,null,{"$f":"'Transmission tariffs'!E41+'Neutrality charge'!E41","v":0.70953672},{"$f":"'Transmission tariffs'!F41+'Neutrality charge'!F41","v":{"v":0.028520999999999998,"d":"0.02852100"}},{"$f":"'Transmission tariffs'!G41+'Neutrality charge'!G41","v":0.00118838},{"$nulls":3},{"$f":"'Transmission tariffs'!K41+'Neutrality charge'!K41","v":0.17738418},{"$f":"'Transmission tariffs'!L41+'Neutrality charge'!L41","v":0.00713025},{"$f":"'Transmission tariffs'!M41+'Neutrality charge'!M41","v":{"v":0.0002971,"d":"0.00029710"}}]
[null,"December",null,null,{"$f":"'Transmission tariffs'!E42+'Neutrality charge'!E42","v":{"v":0.9239465800000001,"d":"0.92394658"}},{"$f":"'Transmission tariffs'!F42+'Neutrality charge'!F42","v":0.03594428},{"$f":"'Transmission tariffs'!G42+'Neutrality charge'!G42","v":{"v":1.49767E-3,"d":"0.00149767"}},{"$nulls":3},{"$f":"'Transmission tariffs'!K42+'Neutrality charge'!K42","v":{"v":0.23098665000000002,"d":"0.23098665"}},{"$f":"'Transmission tariffs'!L42+'Neutrality charge'!L42","v":0.00898607},{"$f":"'Transmission tariffs'!M42+'Neutrality charge'!M42","v":0.00037442}]

{"sheet":"Transmission tariffs","index":3,"n_rows":42,"n_cols":19,"rows_kept":42,"merged":[[7,2,7,6],[7,8,7,12],[7,14,7,18],[12,2,23,2],[12,3,14,3],[12,8,23,8],[12,9,14,9],[12,14,23,14],[12,15,14,15],[15,3,17,3],[15,9,17,9],[15,15,17,15],[18,3,20,3],[18,9,20,9],[18,15,20,15],[21,3,23,3],[21,9,23,9],[21,15,23,15],[25,2,25,6],[25,8,25,12],[30,2,41,2],[30,3,32,3],[30,8,41,8],[30,9,32,9],[33,3,35,3],[33,9,35,9],[36,3,38,3],[36,9,38,9],[39,3,41,3],[39,9,41,9]]}
[]
[]
[]
[null,"ALL-IN TRANSMISSION TARIFFS 2027 (as established by the Dutch regulator ACM)"]
[]
[null,"Tariffs are all rounded to 8 decimals. Within-day prices are rounded up. "]
[]
[null,"Reserve prices FIRM capacity for interconnection points","ENTRY REGULAR",{"$nulls":5},"ENTRY STORAGE",{"$nulls":5},"ENTRY LNG"]
[null,"Payable prices FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"Januari",5.48094638,2.50359119,{"v":1.1975117,"d":"1.19751170"},{"v":0.0465918,"d":"0.04659180"},{"v":1.94133E-3,"d":"0.00194133"},null,{"v":1.3702366,"d":"1.37023660"},{"v":0.6258978,"d":"0.62589780"},0.29937793,0.01164795,0.00048534,null,5.48094638,2.50359119,{"v":1.1975117,"d":"1.19751170"},{"v":0.0465918,"d":"0.04659180"},{"v":1.94133E-3,"d":"0.00194133"}]
[null,"Februari",null,null,0.96683894,0.04165144,{"v":1.73548E-3,"d":"0.00173548"},{"$nulls":3},0.24170974,0.01041286,0.00043387,{"$nulls":3},0.96683894,0.04165144,{"v":1.73548E-3,"d":"0.00173548"}]
[null,"Maart",null,null,0.83721081,0.03255907,0.00135663,{"$nulls":3},{"v":0.2093027,"d":"0.20930270"},0.00813977,{"v":3.3915999999999997E-4,"d":"0.00033916"},{"$nulls":3},0.83721081,0.03255907,0.00135663]
[null,"April",null,1.33915287,0.60410541,0.02428134,{"v":1.01173E-3,"d":"0.00101173"},null,null,0.33478822,0.15102635,0.00607034,{"v":2.5294E-4,"d":"0.00025294"},null,null,1.33915287,0.60410541,0.02428134,{"v":1.01173E-3,"d":"0.00101173"}]
[null,"Mei",null,null,0.55301998,{"v":0.0215221,"d":"0.02152210"},0.00089676,{"$nulls":3},{"v":0.138255,"d":"0.13825500"},0.00538052,0.00022419,{"$nulls":3},0.55301998,{"v":0.0215221,"d":"0.02152210"},0.00089676]
[null,"Juni",null,null,0.44936252,0.01807961,0.00075332,{"$nulls":3},0.11234063,{"v":0.0045199,"d":"0.00451990"},0.00018833,{"$nulls":3},0.44936252,0.01807961,0.00075332]
[null,"Juli",null,1.08620344,0.43850574,0.01705475,0.00071062,null,null,0.27155086,0.10962644,0.00426369,{"v":1.7766E-4,"d":"0.00017766"},null,null,1.08620344,0.43850574,0.01705475,0.00071062]
[null,"Augustus",null,null,0.41685976,0.01624012,0.00067668,{"$nulls":3},0.10421494,0.00406003,0.00016917,{"$nulls":3},0.41685976,0.01624012,0.00067668]
[null,"September",null,null,0.44801106,0.01802706,0.00075113,{"$nulls":3},0.11200276,0.00450676,0.00018779,{"$nulls":3},0.44801106,0.01802706,0.00075113]
[null,"Oktober",null,1.90819524,{"v":0.531374,"d":"0.53137400"},0.02068119,{"v":8.6172000000000006E-4,"d":"0.00086172"},null,null,0.47704881,{"v":0.1328435,"d":"0.13284350"},{"v":0.0051703,"d":"0.00517030"},0.00021543,null,null,1.90819524,{"v":0.531374,"d":"0.53137400"},0.02068119,{"v":8.6172000000000006E-4,"d":"0.00086172"}]
[null,"November",null,null,0.76357842,{"v":0.0306933,"d":"0.03069330"},{"v":1.27889E-3,"d":"0.00127889"},{"$nulls":3},0.19089461,{"v":7.67332E-3,"d":"0.00767332"},{"v":3.1973E-4,"d":"0.00031973"},{"$nulls":3},0.76357842,{"v":0.0306933,"d":"0.03069330"},{"v":1.27889E-3,"d":"0.00127889"}]
[null,"December",null,null,0.99431876,0.03868197,0.00161175,{"$nulls":3},0.24857969,0.00967049,0.00040294,{"$nulls":3},0.99431876,0.03868197,0.00161175]
[]
[null,"Reserve prices FIRM capacity for interconnection points","EXIT NON-STORAGE",{"$nulls":5},"EXIT STORAGE"]
[null,"Payable prices FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"Januari",5.10086298,2.32997639,1.11446869,0.04336083,{"v":1.80671E-3,"d":"0.00180671"},null,1.27521575,{"v":0.5824941,"d":"0.58249410"},0.27861717,0.01084021,0.00045168]
[null,"Februari",null,null,0.89979223,0.03876306,{"v":1.61513E-3,"d":"0.00161513"},{"$nulls":3},0.22494806,0.00969077,0.00040379]
[null,"Maart",null,null,0.77915333,0.03030122,{"v":1.26256E-3,"d":"0.00126256"},{"$nulls":3},0.19478833,{"v":7.57531E-3,"d":"0.00757531"},0.00031564]
[null,"April",null,1.24628756,0.56221293,0.02259752,{"v":9.4157000000000008E-4,"d":"0.00094157"},null,null,0.31157189,0.14055323,0.00564938,{"v":2.354E-4,"d":"0.00023540"}]
[null,"Mei",null,null,0.51467009,0.02002962,{"v":8.3457000000000008E-4,"d":"0.00083457"},{"$nulls":3},0.12866752,0.00500741,{"v":2.0865E-4,"d":"0.00020865"}]
[null,"Juni",null,null,0.41820089,0.01682586,{"v":7.0108000000000008E-4,"d":"0.00070108"},{"$nulls":3},0.10455022,0.00420647,0.00017527]
[null,"Juli",null,1.01087924,0.40809699,0.01587207,{"v":6.6134000000000006E-4,"d":"0.00066134"},null,null,0.25271981,0.10202425,0.00396802,{"v":1.6533999999999999E-4,"d":"0.00016534"}]
[null,"Augustus",null,null,0.38795207,0.01511393,{"v":6.297500000000001E-4,"d":"0.00062975"},{"$nulls":3},0.09698802,0.00377848,{"v":1.5743999999999998E-4,"d":"0.00015744"}]
[null,"September",null,null,0.41694314,0.01677695,{"v":6.9904000000000006E-4,"d":"0.00069904"},{"$nulls":3},0.10423579,0.00419424,0.00017476]
[null,"Oktober",null,1.77586894,0.49452517,0.01924702,{"v":8.0196E-4,"d":"0.00080196"},null,null,0.44396724,0.12363129,{"v":4.81176E-3,"d":"0.00481176"},{"v":2.0049E-4,"d":"0.00020049"}]
[null,"November",null,null,0.71062708,0.02856483,0.00119021,{"$nulls":3},0.17765677,0.00714121,0.00029756]
[null,"December",null,null,0.92536642,0.03599952,0.00149998,{"$nulls":3},0.23134161,{"v":8.99988E-3,"d":"0.00899988"},{"v":0.000375,"d":"0.00037500"}]

{"sheet":"Neutrality charge","index":4,"n_rows":42,"n_cols":19,"rows_kept":42,"merged":[[7,2,7,6],[7,8,7,12],[7,14,7,18],[12,2,23,2],[12,3,14,3],[12,8,23,8],[12,9,14,9],[12,14,23,14],[12,15,14,15],[15,3,17,3],[15,9,17,9],[15,15,17,15],[18,3,20,3],[18,9,20,9],[18,15,20,15],[21,3,23,3],[21,9,23,9],[21,15,23,15],[25,2,25,6],[25,8,25,12],[30,2,41,2],[30,3,32,3],[30,8,41,8],[30,9,32,9],[33,3,35,3],[33,9,35,9],[36,3,38,3],[36,9,38,9],[39,3,41,3],[39,9,41,9]]}
[]
[]
[]
[null,"NEUTRALITY CHARGE 2027 (as established by GTS in accordance with calculation methodology as stated in the Transmission Code Gas - TSO)"]
[]
[null,"Charges are all rounded to 8 decimals. Within-day prices are rounded up. "]
[]
[null,"Charge FIRM capacity for interconnection points","ENTRY REGULAR",{"$nulls":5},"ENTRY STORAGE",{"$nulls":5},"ENTRY LNG"]
[null,"Payable charge FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"Januari",-0.00840974,{"v":-3.84141E-3,"d":"-0.00384141"},{"v":-1.83741E-3,"d":"-0.00183741"},{"v":-7.149e-05,"d":"-0.00007149"},{"v":-2.98e-06,"d":"-0.00000298"},null,-0.00210243,-0.00096035,-0.00045935,{"v":-1.787E-5,"d":"-0.00001787"},{"v":-7.5e-07,"d":"-0.00000075"},null,-0.00840974,{"v":-3.84141E-3,"d":"-0.00384141"},{"v":-1.83741E-3,"d":"-0.00183741"},{"v":-7.149e-05,"d":"-0.00007149"},{"v":-2.98e-06,"d":"-0.00000298"}]
[null,"Februari",null,null,-0.00148348,{"v":-6.391e-05,"d":"-0.00006391"},{"v":-2.67e-06,"d":"-0.00000267"},{"$nulls":3},-0.00037087,{"v":-1.598e-05,"d":"-0.00001598"},{"v":-6.7e-07,"d":"-0.00000067"},{"$nulls":3},-0.00148348,{"v":-6.391e-05,"d":"-0.00006391"},{"v":-2.67e-06,"d":"-0.00000267"}]
[null,"Maart",null,null,{"v":-1.28458E-3,"d":"-0.00128458"},{"v":-4.996e-05,"d":"-0.00004996"},{"v":-2.09e-06,"d":"-0.00000209"},{"$nulls":3},-0.00032115,{"v":-1.249e-05,"d":"-0.00001249"},{"v":-5.3e-07,"d":"-0.00000053"},{"$nulls":3},{"v":-1.28458E-3,"d":"-0.00128458"},{"v":-4.996e-05,"d":"-0.00004996"},{"v":-2.09e-06,"d":"-0.00000209"}]
[null,"April",null,-0.00205474,-0.00092691,{"v":-3.726e-05,"d":"-0.00003726"},{"v":-1.5599999999999999E-6,"d":"-0.00000156"},null,null,-0.00051369,-0.00023173,{"v":-9.31e-06,"d":"-0.00000931"},{"v":-3.9e-07,"d":"-0.00000039"},null,null,-0.00205474,-0.00092691,{"v":-3.726e-05,"d":"-0.00003726"},{"v":-1.5599999999999999E-6,"d":"-0.00000156"}]
[null,"Mei",null,null,-0.00084853,{"v":-3.302e-05,"d":"-0.00003302"},{"v":-1.38e-06,"d":"-0.00000138"},{"$nulls":3},-0.00021213,{"v":-8.26e-06,"d":"-0.00000826"},{"v":-3.5e-07,"d":"-0.00000035"},{"$nulls":3},-0.00084853,{"v":-3.302e-05,"d":"-0.00003302"},{"v":-1.38e-06,"d":"-0.00000138"}]
[null,"Juni",null,null,-0.00068948,{"v":-2.774e-05,"d":"-0.00002774"},{"v":-1.16e-06,"d":"-0.00000116"},{"$nulls":3},{"v":-1.7237E-4,"d":"-0.00017237"},{"v":-6.94e-06,"d":"-0.00000694"},{"v":-2.9000000000000003E-7,"d":"-0.00000029"},{"$nulls":3},-0.00068948,{"v":-2.774e-05,"d":"-0.00002774"},{"v":-1.16e-06,"d":"-0.00000116"}]
[null,"Juli",null,-0.00166663,-0.00067283,{"v":-2.617e-05,"d":"-0.00002617"},{"v":-1.0999999999999998E-6,"d":"-0.00000110"},null,null,-0.00041666,-0.00016821,{"v":-6.54e-06,"d":"-0.00000654"},{"v":-2.8e-07,"d":"-0.00000028"},null,null,-0.00166663,-0.00067283,{"v":-2.617e-05,"d":"-0.00002617"},{"v":-1.0999999999999998E-6,"d":"-0.00000110"}]
[null,"Augustus",null,null,-0.00063961,{"v":-2.492e-05,"d":"-0.00002492"},{"v":-1.04E-6,"d":"-0.00000104"},{"$nulls":3},{"v":-0.0001599,"d":"-0.00015990"},{"v":-6.23e-06,"d":"-0.00000623"},{"v":-2.6E-7,"d":"-0.00000026"},{"$nulls":3},-0.00063961,{"v":-2.492e-05,"d":"-0.00002492"},{"v":-1.04E-6,"d":"-0.00000104"}]
[null,"September",null,null,-0.00068741,{"v":-2.766e-05,"d":"-0.00002766"},{"v":-1.16e-06,"d":"-0.00000116"},{"$nulls":3},{"v":-1.7185E-4,"d":"-0.00017185"},{"v":-6.91e-06,"d":"-0.00000691"},{"v":-2.9000000000000003E-7,"d":"-0.00000029"},{"$nulls":3},-0.00068741,{"v":-2.766e-05,"d":"-0.00002766"},{"v":-1.16e-06,"d":"-0.00000116"}]
[null,"Oktober",null,{"v":-2.92786E-3,"d":"-0.00292786"},-0.00081532,{"v":-3.173e-05,"d":"-0.00003173"},{"v":-1.33E-6,"d":"-0.00000133"},null,null,-0.00073196,-0.00020383,{"v":-7.93e-06,"d":"-0.00000793"},{"v":-3.4000000000000003E-7,"d":"-0.00000034"},null,null,{"v":-2.92786E-3,"d":"-0.00292786"},-0.00081532,{"v":-3.173e-05,"d":"-0.00003173"},{"v":-1.33E-6,"d":"-0.00000133"}]
[null,"November",null,null,{"v":-0.0011716,"d":"-0.00117160"},{"v":-4.709e-05,"d":"-0.00004709"},{"v":-1.9699999999999998E-6,"d":"-0.00000197"},{"$nulls":3},{"v":-0.0002929,"d":"-0.00029290"},{"v":-1.177e-05,"d":"-0.00001177"},{"v":-5e-07,"d":"-0.00000050"},{"$nulls":3},{"v":-0.0011716,"d":"-0.00117160"},{"v":-4.709e-05,"d":"-0.00004709"},{"v":-1.9699999999999998E-6,"d":"-0.00000197"}]
[null,"December",null,null,{"v":-1.52564E-3,"d":"-0.00152564"},{"v":-5.935e-05,"d":"-0.00005935"},{"v":-2.48E-6,"d":"-0.00000248"},{"$nulls":3},{"v":-3.8141E-4,"d":"-0.00038141"},{"v":-1.484E-5,"d":"-0.00001484"},{"v":-6.2e-07,"d":"-0.00000062"},{"$nulls":3},{"v":-1.52564E-3,"d":"-0.00152564"},{"v":-5.935e-05,"d":"-0.00005935"},{"v":-2.48E-6,"d":"-0.00000248"}]
[]
[null,"Charge FIRM capacity for interconnection points","EXIT NON-STORAGE",{"$nulls":5},"EXIT STORAGE"]
[null,"Payable charge FIRM capacity for domestic points"]
[null,null,"Year","Quarter","Month","Day","Within-day",null,"Year","Quarter","Month","Day","Within-day"]
[null,null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID",null,"EUR/kWh/h/Y","EUR/kWh/h/Q","EUR/kWh/h/M","EUR/kWh/h/DA","EUR/kWh/h/WID"]
[]
[null,"Januari",-0.00782656,-0.00357502,{"v":-0.00171,"d":"-0.00171000"},{"v":-6.653e-05,"d":"-0.00006653"},{"v":-2.78e-06,"d":"-0.00000278"},null,-0.00195664,-0.00089376,{"v":-0.0004275,"d":"-0.00042750"},{"v":-1.663e-05,"d":"-0.00001663"},{"v":-7e-07,"d":"-0.00000070"}]
[null,"Februari",null,null,{"v":-0.0013806,"d":"-0.00138060"},{"v":-5.948E-5,"d":"-0.00005948"},{"v":-2.48E-6,"d":"-0.00000248"},{"$nulls":3},-0.00034515,{"v":-1.487E-5,"d":"-0.00001487"},{"v":-6.2e-07,"d":"-0.00000062"}]
[null,"Maart",null,null,{"v":-0.0011955,"d":"-0.00119550"},{"v":-4.649e-05,"d":"-0.00004649"},{"v":-1.94e-06,"d":"-0.00000194"},{"$nulls":3},-0.00029888,{"v":-1.162e-05,"d":"-0.00001162"},{"v":-4.9e-07,"d":"-0.00000049"}]
[null,"April",null,-0.00191225,-0.00086264,{"v":-3.467e-05,"d":"-0.00003467"},{"v":-1.4499999999999999E-6,"d":"-0.00000145"},null,null,-0.00047806,-0.00021566,{"v":-8.67E-6,"d":"-0.00000867"},{"v":-3.7E-7,"d":"-0.00000037"}]
[null,"Mei",null,null,-0.00078969,{"v":-3.073e-05,"d":"-0.00003073"},{"v":-1.29e-06,"d":"-0.00000129"},{"$nulls":3},-0.00019742,{"v":-7.68e-06,"d":"-0.00000768"},{"v":-3.3e-07,"d":"-0.00000033"}]
[null,"Juni",null,null,{"v":-6.4167E-4,"d":"-0.00064167"},{"v":-2.582E-5,"d":"-0.00002582"},{"v":-1.0799999999999998E-6,"d":"-0.00000108"},{"$nulls":3},-0.00016042,{"v":-6.45e-06,"d":"-0.00000645"},{"v":-2.7e-07,"d":"-0.00000027"}]
[null,"Juli",null,{"v":-1.55105E-3,"d":"-0.00155105"},{"v":-6.2617E-4,"d":"-0.00062617"},{"v":-2.435e-05,"d":"-0.00002435"},{"v":-1.02E-6,"d":"-0.00000102"},null,null,-0.00038776,-0.00015654,{"v":-6.09e-06,"d":"-0.00000609"},{"v":-2.6E-7,"d":"-0.00000026"}]
[null,"Augustus",null,null,-0.00059526,{"v":-2.319E-5,"d":"-0.00002319"},{"v":-9.6999999999999982E-7,"d":"-0.00000097"},{"$nulls":3},-0.00014881,{"v":-5.8e-06,"d":"-0.00000580"},{"v":-2.5e-07,"d":"-0.00000025"}]
[null,"September",null,null,-0.00063974,{"v":-2.574e-05,"d":"-0.00002574"},{"v":-1.0799999999999998E-6,"d":"-0.00000108"},{"$nulls":3},-0.00015994,{"v":-6.44e-06,"d":"-0.00000644"},{"v":-2.7e-07,"d":"-0.00000027"}]
[null,"Oktober",null,-0.00272482,-0.00075878,{"v":-2.953E-5,"d":"-0.00002953"},{"v":-1.24E-6,"d":"-0.00000124"},null,null,-0.00068121,-0.00018969,{"v":-7.38e-06,"d":"-0.00000738"},{"v":-3.1E-7,"d":"-0.00000031"}]
[null,"November",null,null,-0.00109036,{"v":-4.383e-05,"d":"-0.00004383"},{"v":-1.8299999999999998E-6,"d":"-0.00000183"},{"$nulls":3},-0.00027259,{"v":-1.096E-5,"d":"-0.00001096"},{"v":-4.6e-07,"d":"-0.00000046"}]
[null,"December",null,null,-0.00141984,{"v":-5.524E-5,"d":"-0.00005524"},{"v":-2.31e-06,"d":"-0.00000231"},{"$nulls":3},-0.00035496,{"v":-1.381E-5,"d":"-0.00001381"},{"v":-5.8000000000000006E-7,"d":"-0.00000058"}]

{"sheet":"bladen rechts alleen voor inter","index":5,"n_rows":4,"n_cols":2,"rows_kept":4,"hidden":true}
[]
[]
[]
[null,"De tabbladen rechts zijn alleen voor intern gebruik beschikbaar. Voor extern gebruik zullen deze worden verborgen."]

{"sheet":"Optimisation","index":6,"n_rows":83,"n_cols":28,"rows_kept":83,"hidden":true,"merged":[[24,24,24,27],[25,15,25,16],[25,17,25,18],[25,19,25,21],[25,22,25,23],[56,5,56,8],[56,10,56,13]]}
[]
[]
[]
[null,"COLLECTING DATA FOR OPTIMALISATION"]
[]
[null,"Helping cell: row number","Numbers of months applicable","Month number","Final \nmonth","Year","Month \nname","Helping cell: \ncode Y&M","Days per month in desired period"]
[{"$nulls":11},"date","year","quarter","month","day"]
[null,0,null,{"$f":"O8","v":3},null,{"$f":"M8","v":2027},{"$f":"IF(D8=\"\",D8,INDEX(C$60:C$71,$D8,1))","v":"March"},{"$f":"CONCATENATE(F8,G8)","v":"2027March"},{"$f":"P19","v":31},null,"Start date",{"$f":"'Period booking'!D8","v":"2027-03-01"},{"$f":"YEAR(L8)","v":2027},"n.a.",{"$f":"MONTH(L8)","v":3},{"$f":"DAY(L8)","v":1}]
[null,{"$f":"B8+1","v":1},{"$f":"IF(B9>P$18,\"\",B9)","v":1},{"$f":"IF($C9=\"\",$C9,IF($D8+1=13,1,IF($D8+1>13,$D8+1-12,$D8+1)))","v":4},{"$f":"IF(AND(D10=\"\",D9<>\"\"),\"END\",\"\")","v":""},{"$f":"IF(D9=\"\",\"\",IF(AND($D9>$D8,$F8<$M$9),$M$8,$M$9))","v":2027},{"$f":"IF(D9=\"\",D9,INDEX(C$60:C$71,D9,1))","v":"April"},"2027April",{"$f":"IF($E9=\"END\",$P$9,IF($D9=\"\",\"\",VLOOKUP($H9,$D$60:$I$83,5,FALSE)))","v":30},null,"End date",{"$f":"'Period booking'!D9","v":"2027-07-01"},{"$f":"YEAR(L9)","v":2027},"n.a.",{"$f":"MONTH(L9)","v":7},{"$f":"DAY(L9)","v":1}]
[null,2,2,5,"",2027,"May","2027May",31]
[null,3,3,6,"",2027,"June","2027June",30,null,"Capacity",{"$nulls":3},"kWh/h",{"$f":"'Period booking'!D11","v":{"v":500000,"d":"500,000"}}]
[null,4,4,7,"END",2027,"July","2027July",1,null,"Applicable yearly reserve price",{"$nulls":3},"EUR/kWh/h/y",{"$f":"K60","v":{"v":5.09303642,"d":"5.0930"}}]
[null,5,"","","","","","","",null,"Payable amount in case of yearly (flat) booking",{"$nulls":3},"EUR/y",{"$f":"P11*P12","v":{"v":2546518.21,"d":"2,546,518"}}]
[null,6,"","","","","","","",null,"Payable amount after optimalisation",{"$nulls":3},"EUR/y",{"$f":"X53","v":{"v":1019090.43,"d":"1,019,090"}}]
[null,7,"","","","","","","",null,"Optimisation to yearly booking?",{"$nulls":4},{"$f":"IF(P13<P14,\"Yes\", \"No\")","v":"No"}]
[null,8,"","","","","","",""]
[null,9,"","","","","","","",null,"Check same month:",{"$nulls":4},{"$f":"IF(AND(M8=M9,O8=O9),\"ZELFDEMAAND\",\"No\")","v":"No"}]
[null,10,"","","","","","","",null,"Number of months involved after starting month:",{"$nulls":4},{"$f":"IF(($O$9-$O$8)>0,($O$9-$O$8),IF(($O$9-$O$8)<0,IF($P$8=1,12+($O$9-$O$8),12+($O$9-$O$8)),IF($M$9=$M$8,0,13)))","v":4}]
[null,11,"","","","","","","",null,"Number of days involved in starting month",{"$nulls":4},{"$f":"IF(P$17=\"ZELFDEMAAND\",$P$9-$P$8+1,_xlfn.DAYS(EOMONTH($L$8,0),$L$8)+1)","v":31}]
[null,12,"","","","","","",""]
[]
[]
[null,"OPTIMISATION FOR DESIRED PERIOD BOOKING INTO NON-YEARLY CAPACITY PRODUCTS"]
[]
[{"$nulls":24},"Optimised non-yearly product"]
[null,"Helping cell: row number","Year","Month","Helping cell: \ncode Y&M","Month number","Days per month in desired period","Days in month","Quarter number","Days in quarter","Days in year","Reserve price for daily products","Reserve price for monthly products","Reserve price for quarterly products","Reserve price for a yearly product","Optimisation 2.1.2. (c) ",null,"Optimisation 2.1.2. (b) ",null,"Optimisation 2.1.2. (a) ",null,null,"Optimised period booking",null,"Year","Quarter","Month","Day-ahead"]
[{"$nulls":11},"EUR/month","EUR/month","EUR/quarter","EUR/year","MIN \n(D vs M)","EUR/month","MIN \n(D;M vs Q)","EUR/month","MIN \n(D;M;Q vs Y)","correction yearly product","EUR/month","Product type","EUR/month"]
[{"$nulls":20},{"$f":"IF($T$53=12,IF($T28=\"Y\",$T28,\"\"),IF($T$53=13,IF($T28=\"\",\"\",IF(OR(AND($T28=\"Y\",$T27=\"\"),AND($T28=\"Y\",$T29=\"\")),IF($S28<$S40,$P28,IF(COUNTIF($U27:$U$29,\"Y\")=12,$P27)),\"Y\")),IF($T$53=11,IF(OR(AND($T28=\"\",$T27=\"Y\"),AND($T28=\"\",$T29=\"Y\")),\"?\",IF($T28=\"Y\",$T28,\"\")),\"\")))","v":""}]
[null,1,{"$f":"M$8","v":2027},"January",{"$f":"CONCATENATE(C29,D29)","v":"2027January"},1,{"$f":"_xlfn.IFNA(VLOOKUP(E29,H$8:I$20,2,FALSE),0)","v":0},{"$f":"INDEX($B$60:$J$83,$B29,7)","v":31},{"$f":"INDEX($B$60:$J$83,$B29,6)","v":1},{"$f":"INDEX($B$60:$J$83,$B29,8)","v":90},{"$f":"IF(U29=\"Y\",SUMIF($U$29:$U$52,\"Y\",$H$29:$H$52),\"\")","v":""},{"$f":"N60*G29","v":0},{"$f":"IF($G29<>0,M60,0)","v":0},{"$f":"IF($G29<>0,L60,0)","v":0},{"$f":"IF($G29<>0,K60,0)","v":0},{"$f":"IF($G29<>0,IF(L29<M29,\"D\", \"M\"),\"\")","v":""},{"$f":"IF(P29=\"D\",L29,M29)","v":0},{"$f":"IF($G29=0,\"\",IF($I29<>$I28,IF(SUM($Q29:$Q31)>=$N29,\"Q\",\"\"),IF($R28=\"Q\",\"Q\",\"\")))","v":""},{"$f":"IF($R29=\"Q\",$N29*$H29/$J29,$Q29)","v":0},{"$f":"IF($G29=0,\"\",IF(SUM($S29:$S40)>=$O29,\"Y\",IF($T28=\"Y\",\"Y\",\"\")))","v":""},{"$f":"IF($T$53=12,IF($T29=\"Y\",$T29,\"\"),IF($T$53=13,IF($T29=\"\",\"\",IF(AND($T29=\"Y\",$T28=\"\"),IF($S29<$S41,$P29,\"Y\"),IF(AND($T29=\"Y\",$T30=\"\"),IF($S29<$S17,$P29,\"Y\"),\"Y\"))),IF($T$53=11,IF(OR(AND($T29=\"\",$T28=\"Y\"),AND($T29=\"\",$T30=\"Y\")),\"?\",IF($T29=\"Y\",$T29,\"\")),IF($T$53=10,IF(OR(AND($T29=\"\",$T28=\"Y\"),AND($T29=\"\",$T30=\"Y\"),AND($T29=\"\",$T28=\"\",$T27=\"Y\"),AND($T29=\"\",$T30=\"\",$T31=\"Y\")),\"?\",IF($T29=\"Y\",$T29,\"\")),IF($T$53=9,IF(OR(AND($T29=\"\",$T28=\"Y\"),AND($T29=\"\",$T30=\"Y\"),AND($T29=\"\",$T28=\"\",$T27=\"Y\"),AND($T29=\"\",$T30=\"\",$T31=\"Y\"),AND($T29=\"\",$T28=\"\",$T27=\"\",$T26=\"Y\"),AND($T29=\"\",$T30=\"\",$T31=\"\",$T32=\"Y\")),\"?\",IF($T29=\"Y\",$T29,\"\")),\"\")))))","v":""},{"$f":"IF($U29=\"\",0,IF($T$53=11,\"no 12th month in yearly booking\",IF($T$53=10,\"no 11th and 12th month in yearly booking\",IF($T$53=9,\"no 10th, 11th and 12th month in yearly booking\",IF($U29=\"Y\",$O29*$H29/$K29,$S29)))))","v":0},{"$f":"IF(AND($G29=0,$U29=\"\"),\"\",IF(OR($U29=\"Y\",$U29=\"?\"),$U29,IF($R29=\"Q\",$R29,$P29)))","v":""},{"$f":"IFERROR(IF(AND($G29=0,$U29=\"\"),\"\",IF(OR($U29=\"Y\",$U29=\"?\"),$V29,IF($R29=\"Q\",$S29,$Q29)))*$P$11,$V29)","v":0},{"$f":"IF($W29=\"Y\",\"Y\",IF($W29=\"?\",$W29,\"\"))","v":""},{"$f":"IF($W29=\"Q\",\"Q\"&$I29,\"\")","v":""},{"$f":"IF($W29=\"M\",\"M\"&$F29,\"\")","v":""},{"$f":"IF($W29=\"D\",$G29,\"\")","v":""}]
[null,{"$f":"B29+1","v":2},2027,"February","2027February",2,{"$f":"_xlfn.IFNA(VLOOKUP(E30,H$8:I$20,2,FALSE),0)","v":0},{"$f":"INDEX($B$60:$J$83,$B30,7)","v":28},{"$f":"INDEX($B$60:$J$83,$B30,6)","v":1},{"$f":"INDEX($B$60:$J$83,$B30,8)","v":90},{"$f":"IF(U30=\"Y\",SUMIF($U$29:$U$52,\"Y\",$H$29:$H$52),\"\")","v":""},0,0,0,0,{"$f":"IF($G30<>0,IF(L30<M30,\"D\", \"M\"),\"\")","v":""},{"$f":"IF(P30=\"D\",L30,M30)","v":0},{"$f":"IF($G30=0,\"\",IF($I30<>$I29,IF(SUM($Q30:$Q32)>=$N30,\"Q\",\"\"),IF($R29=\"Q\",\"Q\",\"\")))","v":""},{"$f":"IF($R30=\"Q\",$N30*$H30/$J30,$Q30)","v":0},{"$f":"IF($G30=0,\"\",IF(SUM($S30:$S41)>=$O30,\"Y\",IF($T29=\"Y\",\"Y\",\"\")))","v":""},"",0,"",{"$f":"IFERROR(IF(AND($G30=0,$U30=\"\"),\"\",IF(OR($U30=\"Y\",$U30=\"?\"),$V30,IF($R30=\"Q\",$S30,$Q30)))*$P$11,$V30)","v":0},{"$f":"IF($W30=\"Y\",\"Y\",IF($W30=\"?\",$W30,\"\"))","v":""},"","",""]
[null,3,2027,"March","2027March",3,31,31,{"$f":"INDEX($B$60:$J$83,$B31,6)","v":1},90,"",{"v":0.93789663,"d":"€ 0.938"},{"v":0.77795783,"d":"€ 0.778"},{"v":2.32640137,"d":"€ 2.326"},{"v":5.09303642,"d":"€ 5.093"},"M",{"$f":"IF(P31=\"D\",L31,M31)","v":{"v":0.77795783,"d":"€ 0.778"}},"",{"$f":"IF($R31=\"Q\",$N31*$H31/$J31,$Q31)","v":{"v":0.77795783,"d":"€ 0.778"}},{"$f":"IF($G31=0,\"\",IF(SUM($S31:$S42)>=$O31,\"Y\",IF($T30=\"Y\",\"Y\",\"\")))","v":""},"",0,"M",{"v":388978.915,"d":"€ 388,979"},"","","M3",""]
[null,4,2027,"April","2027April",4,30,30,2,91,"",{"v":0.6768854999999999,"d":"€ 0.677"},{"v":0.56135029,"d":"€ 0.561"},{"v":1.2443753100000001,"d":"€ 1.244"},{"v":5.09303642,"d":"€ 5.093"},"M",{"$f":"IF(P32=\"D\",L32,M32)","v":{"v":0.56135029,"d":"€ 0.561"}},"Q",{"$f":"IF($R32=\"Q\",$N32*$H32/$J32,$Q32)","v":{"v":0.41023361868131875,"d":"€ 0.410"}},{"$f":"IF($G32=0,\"\",IF(SUM($S32:$S43)>=$O32,\"Y\",IF($T31=\"Y\",\"Y\",\"\")))","v":""},"",0,"Q",{"v":205116.80934065938,"d":"€ 205,117"},"","Q2","",""]
[null,5,2027,"May","2027May",5,31,31,2,91,{"$f":"IF(U33=\"Y\",SUMIF($U$29:$U$52,\"Y\",$H$29:$H$52),\"\")","v":""},{"v":0.6199655900000001,"d":"€ 0.620"},{"v":0.5138804,"d":"€ 0.514"},{"v":1.2443753100000001,"d":"€ 1.244"},{"v":5.09303642,"d":"€ 5.093"},"M",{"$f":"IF(P33=\"D\",L33,M33)","v":{"v":0.5138804,"d":"€ 0.514"}},"Q",{"$f":"IF($R33=\"Q\",$N33*$H33/$J33,$Q33)","v":{"v":0.42390807263736263,"d":"€ 0.424"}},{"$f":"IF($G33=0,\"\",IF(SUM($S33:$S44)>=$O33,\"Y\",IF($T32=\"Y\",\"Y\",\"\")))","v":""},"",0,"Q",{"v":211954.03631868132,"d":"€ 211,954"},{"$f":"IF($W33=\"Y\",\"Y\",IF($W33=\"?\",$W33,\"\"))","v":""},"Q2","",""]
[null,6,2027,"June","2027June",6,30,30,2,91,{"$f":"IF(U34=\"Y\",SUMIF($U$29:$U$52,\"Y\",$H$29:$H$52),\"\")","v":""},{"v":0.5040012,"d":"€ 0.504"},{"v":0.41755922,"d":"€ 0.418"},{"v":1.2443753100000001,"d":"€ 1.244"},{"v":5.09303642,"d":"€ 5.093"},"M",{"v":0.41755922,"d":"€ 0.418"},"Q",{"$f":"IF($R34=\"Q\",$N34*$H34/$J34,$Q34)","v":{"v":0.41023361868131875,"d":"€ 0.410"}},{"$f":"IF($G34=0,\"\",IF(SUM($S34:$S45)>=$O34,\"Y\",IF($T33=\"Y\",\"Y\",\"\")))","v":""},"",0,{"$f":"IF(AND($G34=0,$U34=\"\"),\"\",IF(OR($U34=\"Y\",$U34=\"?\"),$U34,IF($R34=\"Q\",$R34,$P34)))","v":"Q"},{"v":205116.80934065938,"d":"€ 205,117"},"","Q2","",""]
[null,7,2027,"July","2027July",7,1,31,3,92,"",{"v":0.01584772,"d":"€ 0.016"},{"v":0.40747082,"d":"€ 0.407"},{"v":1.00932819,"d":"€ 1.009"},{"v":5.09303642,"d":"€ 5.093"},"D",{"$f":"IF(P35=\"D\",L35,M35)","v":{"v":0.01584772,"d":"€ 0.016"}},"",{"v":0.01584772,"d":"€ 0.016"},{"$f":"IF($G35=0,\"\",IF(SUM($S35:$S46)>=$O35,\"Y\",IF($T34=\"Y\",\"Y\",\"\")))","v":""},"",0,{"$f":"IF(AND($G35=0,$U35=\"\"),\"\",IF(OR($U35=\"Y\",$U35=\"?\"),$U35,IF($R35=\"Q\",$R35,$P35)))","v":"D"},{"v":7923.86,"d":"€ 7,924"},"","","",1]
[null,8,2027,"August","2027August",8,0,31,3,92,"",0,0,0,0,"",0,"",0,{"$f":"IF($G36=0,\"\",IF(SUM($S36:$S47)>=$O36,\"Y\",IF($T35=\"Y\",\"Y\",\"\")))","v":""},"",0,{"$f":"IF(AND($G36=0,$U36=\"\"),\"\",IF(OR($U36=\"Y\",$U36=\"?\"),$U36,IF($R36=\"Q\",$R36,$P36)))","v":""},0,"","","",""]
[null,9,2027,"September","2027September",9,0,30,3,92,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,10,2027,"October","2027October",10,0,31,4,92,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,11,2027,"November","2027November",11,0,30,4,92,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,12,2027,"December","2027December",12,0,31,4,92,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,13,{"$f":"YEAR(L$8+366)","v":2028},"January","2028January",1,0,31,{"$f":"INDEX($B$60:$J$83,$B41,6)","v":1},91,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,{"$f":"B41+1","v":14},2028,"February","2028February",2,0,29,{"$f":"INDEX($B$60:$J$83,$B42,6)","v":1},91,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,15,2028,"March","2028March",3,0,31,{"$f":"INDEX($B$60:$J$83,$B43,6)","v":1},91,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,16,2028,"April","2028April",4,0,30,2,91,"",0,0,0,0,"",0,"",0,{"$f":"IF($G44=0,\"\",IF(SUM($S44:$S55)>=$O44,\"Y\",IF($T43=\"Y\",\"Y\",\"\")))","v":""},"",0,"",0,"","","",""]
[null,17,2028,"May","2028May",5,0,31,2,91,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,18,2028,"June","2028June",6,0,30,2,91,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,19,2028,"July","2028July",7,0,31,3,92,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,20,2028,"August","2028August",8,0,31,3,92,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,21,2028,"September","2028September",9,0,30,3,92,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,22,2028,"October","2028October",10,0,31,4,92,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,23,2028,"November","2028November",11,0,30,4,92,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[null,24,2028,"December","2028December",12,0,31,4,92,"",0,0,0,0,"",0,"",0,"","",0,"",0,"","","",""]
[{"$nulls":19},{"$f":"COUNTIF($T$29:$T$52,\"Y\")","v":0},{"$nulls":3},{"$f":"SUM(X29:X52)","v":{"v":1019090.43,"d":"€ 1,019,090"}}]
[]
[null,"HELPING TABLE: COLLECTING DATES, NUMBER OF DAYS IN MONTH AND QUARTER AND RESERVE PRICES"]
[]
[{"$nulls":5},"DATE INFORMATION",{"$nulls":4},"RESERVE PRICES"]
[]
[null,"Year","Month","Helping cell: \ncode Y&M",null,"Month \nnumber","Quarter \nnumber","Number of days in month","Number of days in quarter",null,"Year","Quarter","Month","Day"]
[null,{"$f":"M$8","v":2027},"January",{"$f":"CONCATENATE(B60,C60)","v":"2027January"},null,1,1,{"$f":"DAY(EOMONTH(DATE(B60,F60,1),0))","v":31},{"$f":"IF(G60<>G59,SUM(H60:H62),I59)","v":90},null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G60,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G60,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G60,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G60,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G60,2))))))","v":2.32640137},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F60,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F60,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F60,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F60,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F60,3))))))","v":1.11275869},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F60,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F60,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F60,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F60,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F60,4)))))))","v":0.0432943}]
[null,2027,"February",{"$f":"CONCATENATE(B61,C61)","v":"2027February"},null,2,1,{"$f":"DAY(EOMONTH(DATE(B61,F61,1),0))","v":28},{"$f":"IF(G61<>G60,SUM(H61:H63),I60)","v":90},null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G61,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G61,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G61,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G61,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G61,2))))))","v":2.32640137},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F61,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F61,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F61,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F61,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F61,3))))))","v":0.89841163},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F61,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F61,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F61,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F61,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F61,4)))))))","v":0.03870358}]
[null,2027,"March","2027March",null,3,1,31,{"$f":"IF(G62<>G61,SUM(H62:H64),I61)","v":90},null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G62,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G62,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G62,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G62,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G62,2))))))","v":2.32640137},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F62,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F62,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F62,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F62,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F62,3))))))","v":0.77795783},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F62,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F62,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F62,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F62,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F62,4)))))))","v":0.03025473}]
[null,2027,"April","2027April",null,4,4,30,91,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G63,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G63,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G63,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G63,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G63,2))))))","v":1.2443753100000001},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F63,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F63,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F63,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F63,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F63,3))))))","v":0.56135029},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F63,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F63,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F63,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F63,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F63,4)))))))","v":0.02256285}]
[null,2027,"May","2027May",null,5,4,31,91,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G64,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G64,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G64,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G64,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G64,2))))))","v":1.2443753100000001},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F64,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F64,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F64,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F64,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F64,3))))))","v":0.5138804},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F64,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F64,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F64,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F64,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F64,4)))))))","v":0.019998890000000002}]
[null,2027,"June","2027June",null,6,4,30,91,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G65,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G65,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G65,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G65,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G65,2))))))","v":1.2443753100000001},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F65,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F65,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F65,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F65,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F65,3))))))","v":0.41755922},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F65,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F65,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F65,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F65,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F65,4)))))))","v":0.016800040000000002}]
[null,2027,"July","2027July",null,7,7,31,92,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G66,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G66,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G66,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G66,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G66,2))))))","v":1.00932819},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F66,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F66,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F66,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F66,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F66,3))))))","v":0.40747082},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F66,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F66,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F66,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F66,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F66,4)))))))","v":0.01584772}]
[null,2027,"August","2027August",null,8,7,31,92,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G67,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G67,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G67,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G67,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G67,2))))))","v":1.00932819},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F67,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F67,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F67,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F67,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F67,3))))))","v":0.38735681},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F67,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F67,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F67,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F67,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F67,4)))))))","v":0.01509074}]
[null,2027,"September","2027September",null,9,7,30,92,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G68,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G68,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G68,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G68,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G68,2))))))","v":1.00932819},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F68,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F68,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F68,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F68,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F68,3))))))","v":0.4163034},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F68,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F68,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F68,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F68,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F68,4)))))))","v":0.01675121}]
[null,2027,"October","2027October",null,10,10,31,92,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G69,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G69,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G69,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G69,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G69,2))))))","v":1.77314412},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F69,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F69,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F69,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F69,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F69,3))))))","v":0.49376639},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F69,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F69,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F69,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F69,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F69,4)))))))","v":0.01921749}]
[null,2027,"November","2027November",null,11,10,30,92,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G70,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G70,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G70,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G70,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G70,2))))))","v":1.77314412},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F70,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F70,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F70,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F70,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F70,3))))))","v":0.70953672},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F70,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F70,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F70,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F70,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F70,4)))))))","v":0.028520999999999998}]
[null,2027,"December","2027December",null,12,10,31,92,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G71,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G71,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G71,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G71,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G71,2))))))","v":1.77314412},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F71,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F71,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F71,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F71,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F71,3))))))","v":0.9239465800000001},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F71,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F71,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F71,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F71,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F71,4)))))))","v":0.03594428}]
[null,{"$f":"YEAR(L$8+366)","v":2028},"January","2028January",null,1,1,31,91,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G72,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G72,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G72,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G72,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G72,2))))))","v":2.32640137},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F72,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F72,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F72,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F72,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F72,3))))))","v":1.11275869},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F72,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F72,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F72,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F72,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F72,4)))))))","v":0.0432943}]
[null,2028,"February","2028February",null,2,1,29,91,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G73,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G73,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G73,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G73,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G73,2))))))","v":2.32640137},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F73,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F73,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F73,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F73,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F73,3))))))","v":0.89841163},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F73,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F73,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F73,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F73,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F73,4)))))))","v":0.03870358}]
[null,2028,"March","2028March",null,3,1,31,91,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G74,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G74,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G74,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G74,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G74,2))))))","v":2.32640137},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F74,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F74,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F74,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F74,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F74,3))))))","v":0.77795783},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F74,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F74,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F74,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F74,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F74,4)))))))","v":0.03025473}]
[null,2028,"April","2028April",null,4,4,30,91,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G75,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G75,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G75,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G75,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G75,2))))))","v":1.2443753100000001},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F75,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F75,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F75,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F75,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F75,3))))))","v":0.56135029},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F75,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F75,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F75,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F75,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F75,4)))))))","v":0.02256285}]
[null,2028,"May","2028May",null,5,4,31,91,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G76,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G76,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G76,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G76,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G76,2))))))","v":1.2443753100000001},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F76,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F76,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F76,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F76,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F76,3))))))","v":0.5138804},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F76,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F76,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F76,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F76,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F76,4)))))))","v":0.019998890000000002}]
[null,2028,"June","2028June",null,6,4,30,91,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G77,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G77,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G77,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G77,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G77,2))))))","v":1.2443753100000001},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F77,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F77,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F77,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F77,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F77,3))))))","v":0.41755922},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F77,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F77,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F77,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F77,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F77,4)))))))","v":0.016800040000000002}]
[null,2028,"July","2028July",null,7,7,31,92,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G78,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G78,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G78,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G78,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G78,2))))))","v":1.00932819},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F78,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F78,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F78,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F78,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F78,3))))))","v":0.40747082},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F78,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F78,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F78,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F78,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F78,4)))))))","v":0.01584772}]
[null,2028,"August","2028August",null,8,7,31,92,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G79,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G79,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G79,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G79,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G79,2))))))","v":1.00932819},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F79,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F79,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F79,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F79,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F79,3))))))","v":0.38735681},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F79,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F79,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F79,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F79,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F79,4)))))))","v":0.01509074}]
[null,2028,"September","2028September",null,9,7,30,92,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G80,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G80,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G80,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G80,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G80,2))))))","v":1.00932819},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F80,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F80,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F80,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F80,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F80,3))))))","v":0.4163034},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F80,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F80,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F80,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F80,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F80,4)))))))","v":0.01675121}]
[null,2028,"October","2028October",null,10,10,31,92,null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G81,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G81,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G81,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G81,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G81,2))))))","v":1.77314412},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F81,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F81,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F81,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F81,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F81,3))))))","v":0.49376639},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F81,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F81,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F81,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F81,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F81,4)))))))","v":0.01921749}]
[null,2028,"November","2028November",null,11,10,30,{"$f":"IF(G82<>G81,SUM(F84:F84),I81)","v":92},null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G82,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G82,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G82,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G82,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G82,2))))))","v":1.77314412},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F82,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F82,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F82,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F82,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F82,3))))))","v":0.70953672},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F82,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F82,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F82,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F82,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F82,4)))))))","v":0.028520999999999998}]
[null,2028,"December","2028December",null,12,10,31,{"$f":"IF(G83<>G82,SUM(F84:F85),I82)","v":92},null,{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,1,1),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,1,1),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,1,1),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,1,1))))))","v":5.09303642},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$G83,2),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$G83,2),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$G83,2),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$G83,2),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$G83,2))))))","v":1.77314412},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F83,3),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F83,3),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F83,3),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F83,3),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F83,3))))))","v":0.9239465800000001},{"$f":"IF('Period booking'!$D$10=\"Exit storage\",INDEX(exitstorage,$F83,4),IF('Period booking'!$D$10=\"Exit non-storage\",INDEX(exit,$F83,4),IF('Period booking'!$D$10=\"Entry storage\",INDEX(entrystorage,$F83,4),IF('Period booking'!$D$10=\"Entry Regular\",INDEX(entry,$F83,4),IF('Period booking'!$D$10=\"Entry non-storage\",INDEX(entry,1,1),IF('Period booking'!$D$10=\"Entry LNG\",INDEX(entryLNG,$F83,4)))))))","v":0.03594428}]

{"sheet":"Multipliers and SF","index":7,"n_rows":31,"n_cols":6,"rows_kept":31,"hidden":true}
[]
[]
[]
[null,"MULTIPLIERS AND SEASONAL FACTORS"]
[]
[null,"Multipliers (M)"]
[]
[null,"Quarterly multiplier","M-Q",1.25]
[null,"Monthly multiplier","M-M",1.5]
[null,"Daily multiplier","M-DA",1.75]
[null,"Within-day multiplier","M-WID",1.75]
[]
[null,"Seasonal factors (SF)",null,"Month","Day","WID"]
[]
[null,"SF - Jan",null,1.715,1.773,1.773]
[null,"SF - Feb",null,1.533,1.585,1.585]
[null,"SF - March",null,1.199,1.239,1.239]
[null,"SF - April",null,0.894,0.924,0.924]
[null,"SF - May",null,0.792,0.819,0.819]
[null,"SF - June",null,0.665,0.688,0.688]
[null,"SF - July",null,0.628,0.649,0.649]
[null,"SF - August",null,0.597,0.618,0.618]
[null,"SF - Sept",null,0.663,0.686,0.686]
[null,"SF - Oct",null,0.761,0.787,0.787]
[null,"SF - Nov",null,{"v":1.13,"d":"1.130"},1.168,1.168]
[null,"SF - Dec",null,1.424,1.472,1.472]
[]
[null,"SF - Jan - March",null,1.482]
[null,"SF - April - June",null,0.784]
[null,"SF - July - Sept",null,0.629]
[null,"SF - Oct - Dec",null,1.105]

{"sheet":"Validation","index":8,"n_rows":15,"n_cols":3,"rows_kept":15,"hidden":true}
[]
[]
[]
[null,"VALIDATION POSTAGE STAMP POINTS"]
[]
[null,null,"Entry Regular"]
[null,null,"Entry Storage"]
[null,null,"Entry LNG"]
[null,null,"Exit non-storage"]
[null,null,"Exit storage"]
[]
[null,"VALIDATION FEBRUARY IN LEAP YEAR"]
[]
[null,null,"Yes"]
[null,null,"No"]