{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Opening Remarks","Parameters","Calculating sheet - CWD method","Results - Estimated ref. prices"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":104,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Opening Remarks","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,1,18,10],[21,1,21,8]]}
[]
[null,"This \"Simplified Tariff Model Transmission Services\" has been prepared by Fluxys Belgium SA/NV for the public consultation organized in the context of the preparation of the next tariff proposal for the period 2020-2023. \nThis model is a simplified model only. It is not aimed at calculating accurate tariffs but giving tendencies only and is provided for indicative purposes only. \nNumbers and parameters contained in this document are indicative best estimates subject to possible changes or corrections. Under no circumstances shall any person, company, corporate body or other entity be entitled to assert any right, claim or other entitlement against Fluxys Belgium SA/NV (or either its directors, managing directors or employees) as a result, or on the basis of this model. ",null,null,null,null,null,null,null,null,null,null,"Version 1.0"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Release date : 15/10/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Author : Fluxys Belgium SA/NV"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Color codes"]
[null,"Input","Blue letter type: input data / parameter"]
[null,"Goalseek","Blue cell: result or objective of goalseek/solver"]
[null,"Instruction","Green letter type: instruction on how to run the calculation model"]

{"sheet":"Parameters","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,6],[7,1,7,6],[3,13,3,15],[8,13,19,15]]}
[]
[null,"Macro-economic parameters",null,null,null,null,null,2020,2021,2022,2023]
[null,"Y-on-Y tariff indexation","(Estimated impact as link with allowed revenue is not done in this simplifed model)",null,null,null,null,1.6E-2,1.7000000000000001E-2,1.7000000000000001E-2,1.7000000000000001E-2]
[]
[null,"Allowed Revenue for Transmission Services",null,null,null,null,null,2020,2021,2022,2023]
[null,"Revenue to be covered by Transmission Services after utilisation of Reg Account",null,null,"M EUR",null,null,237.76,237.88,234.07,236.02]
[]
[null,"Tariff parameters"]
[null,"Entry/exit ratio",null,null,null,null,null,null,null,null,null,null,null,"Instructions :\nTo test other hypotheses, change the parameters and then hit button 'RECALCULATE THE MODEL'\nAlternatively, you can copy cells F29:F34 in hard values to cells H29:H34 until values M29:M34 are at zero (an excel \"solver\" can be used)\n\nYou can always revert to initial values by hitting button 'RESET TO INITIAL VALUES'"]
[null,"entry",null,null,null,0.33]
[null,"exit",null,null,null,{"$f":"1-F10","v":0.66999999999999993}]
[]
[null,"Discount for storage"]
[null,"entry from storage",null,null,null,0.5,"(Estimated impact based based on low share in total expected capacity sales)"]
[null,"exit to storage",null,null,null,1,"(Estimated impact based based on low share in total expected capacity sales)"]
[]
[null,"interruptible/backhaul tariff",null,null,null,0.9,"(Estimated impact based based on low share in total expected capacity sales)"]
[]
[null,"OCUCs calculation",null,null,null,"discount","weighted average standard Entry + Exit tariff"]
[null,"Zelzate 1/2 - IZT/Zeebrugge",null,"€/kWh/h/y",null,-0.375,{"$f":"(('Results - Estimated ref. prices'!D10+'Results - Estimated ref. prices'!K12)*SUM('Calculating sheet - CWD method'!G23:J23)+('Results - Estimated ref. prices'!D13+'Results - Estimated ref. prices'!K9)*SUM('Calculating sheet - CWD method'!G24:J24))/(SUM('Calculating sheet - CWD method'!G23:J24))","v":1.6624603002819178}]
[null,"IZT/Zeebrugge - Zelzate 1/2",null,"€/kWh/h/y",null,-0.375,{"$f":"G20","v":1.6624603002819178}]
[null,"Dunkirk LNG Terminal/Alveringem - IZT/Zeebrugge",null,"€/kWh/h/y",null,-0.25,{"$f":"'Results - Estimated ref. prices'!D5+'Results - Estimated ref. prices'!K12","v":1.591165691024881}]
[null,"Blaregnies Segeo/Troll -  IZT/Zeebrugge",null,"€/kWh/h/y",null,-0.25,{"$f":"'Results - Estimated ref. prices'!D5+'Results - Estimated ref. prices'!K12","v":1.591165691024881}]
[null,"s Gravenvoeren - Eynatten 1/2",null,"€/kWh/h/y",null,-0.57499999999999996,{"$f":"(('Results - Estimated ref. prices'!D8+'Results - Estimated ref. prices'!K7)*SUM('Calculating sheet - CWD method'!G26:J26)+('Results - Estimated ref. prices'!D6+'Results - Estimated ref. prices'!K9)*SUM('Calculating sheet - CWD method'!G25:J25))/(SUM('Calculating sheet - CWD method'!G25:J26))","v":2.0250091104881069}]
[null,"Eynatten 1/2 - 's Gravenvoeren",null,"€/kWh/h/y",null,-0.57499999999999996,{"$f":"G24","v":2.0250091104881069}]
[]
[null,null,null,null,null,"copy",null,"paste"]
[null,null,null,null,null,null,null,"Year 2020","Year 2021","Year 2022","Year 2023",null,"Objective = should at zero"]
[null,null,null,null,null,{"$f":"G20*(1+F20)","v":1.0390376876761986},"->",1.0390468847605656,{"$f":"H29*(1+I$3)","v":1.0567106818014951},{"$f":"I29*(1+J$3)","v":1.0746747633921203},1.0929442343697862,null,{"$f":"H29-F29","v":9.1970843669741953E-6}]
[null,null,null,null,null,{"$f":"G21*(1+F21)","v":1.0390376876761986},"->",1.0390468847605656,1.0567106818014951,1.0746747633921203,1.0929442343697862,null,9.1970843669741953E-6]
[null,null,null,null,null,1.1933742682686608,"->",1.1933848354847436,1.2136723776879841,1.2343048081086796,1.255287989846527,null,1.0567216082835174E-5]
[null,null,null,null,null,1.1933742682686608,"->",1.1933848354847436,1.2136723776879841,1.2343048081086796,1.255287989846527,null,1.0567216082835174E-5]
[null,null,null,null,null,0.86062887195744553,"->",0.86063648300712992,0.87526730321825108,0.89014684737296124,0.90527934377830144,null,7.6110496843861952E-6]
[null,null,null,null,null,0.86062887195744553,"->",0.86063648300712992,0.87526730321825108,0.89014684737296124,0.90527934377830144,null,7.6110496843861952E-6]

{"sheet":"Calculating sheet - CWD method","index":2,"n_rows":131,"n_cols":14,"rows_kept":131,"cut":false,"hidden":false,"merged":[[45,3,46,3],[30,15,30,16],[12,3,12,4],[12,14,12,15],[12,16,12,17],[30,17,30,18],[30,8,30,9],[30,10,30,11],[30,12,30,13],[30,6,30,7],[53,17,53,18],[72,1,88,1],[72,2,85,2],[72,3,79,3],[72,5,73,5],[80,3,84,3],[71,3,71,4],[53,15,53,16],[70,6,70,9],[70,10,70,13],[86,2,88,2],[86,3,87,3],[51,1,65,1],[51,2,63,2],[51,3,58,3],[51,5,52,5],[114,1,130,1],[114,2,127,2],[114,3,121,3],[91,12,91,13],[91,8,91,9],[112,1,113,5],[111,6,111,9],[91,3,91,4],[91,6,91,7],[91,10,91,11],[93,1,109,1],[93,2,106,2],[93,3,100,3],[93,5,94,5],[101,3,105,3],[107,2,109,2],[114,5,115,5],[122,3,126,3],[128,3,129,3],[128,2,130,2],[11,6,11,9],[59,3,63,3],[64,2,65,2],[64,3,65,3],[90,6,90,13],[107,3,108,3],[49,1,50,5],[30,3,30,4],[32,1,46,1],[32,2,44,2],[32,3,39,3],[32,5,33,5],[11,10,11,13],[29,6,29,13],[48,6,48,9],[1,1,1,9],[5,1,5,4],[2,1,2,4],[9,1,9,4],[13,1,27,1],[13,2,25,2],[13,3,20,3],[13,5,14,5],[21,3,25,3],[26,2,27,2],[26,3,27,3],[45,2,46,2],[40,3,44,3]]}
[]
[null,"CWD proposed RPM - simplified ",null,null,null,null,null,null,null,null,2020,2021,2022,2023]
[null,"Allowed revenue transmission",null,null,null,null,null,null,null,null,{"$f":"Parameters!H6*1000000","v":237760000},{"$f":"Parameters!I6*1000000","v":237880000},{"$f":"Parameters!J6*1000000","v":234070000},{"$f":"Parameters!K6*1000000","v":236020000}]
[null,null,null,null,null,null,null,"Allowed revenue TRM - allocated to OCUC",null,null,{"$f":"SUM(G41:G45)+SUM(G102:G106)","v":21380713.957068007},{"$f":"SUM(I41:I45)+SUM(I102:I106)","v":20994166.314662419},{"$f":"SUM(K41:K45)+SUM(K102:K106)","v":20308207.810561538},{"$f":"SUM(M41:M45)+SUM(M102:M106)","v":18506626.784803085}]
[null,null,null,null,null,null,null,"Allowed revenue TRM - remaining ",null,null,{"$f":"K3-K4","v":216379286.042932},{"$f":"L3-L4","v":216885833.68533757},{"$f":"M3-M4","v":213761792.18943846},{"$f":"N3-N4","v":217513373.21519691}]
[null,"Entry/Exit ratio"]
[null,null,null,null,"Entry",{"$f":"Parameters!F10","v":0.33},null,"Allowed revenue - TRM - Entry",null,null,{"$f":"K5*$F7","v":71405164.394167557},{"$f":"L5*$F7","v":71572325.116161406},{"$f":"M5*$F7","v":70541391.422514692},{"$f":"N5*$F7","v":71779413.161014989}]
[null,null,null,null,"Exit",{"$f":"1-F7","v":0.66999999999999993},null,"Allowed revenue - TRM - Exit",null,null,{"$f":"K5*$F8","v":144974121.64876443},{"$f":"L5*$F8","v":145313508.56917617},{"$f":"M5*$F8","v":143220400.76692376},{"$f":"N5*$F8","v":145733960.0541819}]
[]
[null,"GCV ratio: L/H tariffs",null,null,null,{"$f":"11.3/9.8","v":1.153061224489796}]
[]
[null,null,null,null,null,null," Forecasted contracted capacity \"Firm H-Gas equivalent\" (in kWh/h/yr)",null,null,null," CWD Weight of points in %"]
[null,null,null,null,null,null,2020,2021,2022,2023,2020,2021,2022,2023]
[null,"ENTRY","H-grid","IP","Alveringem","Virtualys",1579102.7367574493,1828167.6250182856,2121763.3037999952,2357386.3929707329,1.9206930801364552E-2,2.3021253084239978E-2,2.6472659159355458E-2,2.9591053425084266E-2]
[null,null,null,null,"Blaregnies H (Segeo & Troll)",null,973928.73750766774,1023277.7038611573,1081449.8668460702,1128135.5156373791,7.6100299064766159E-3,8.2265914990998935E-3,8.8145468534778261E-3,9.8196136339952968E-3]
[null,null,null,null,"Zeebrugge (incl. IZT, ZPT, LNG-Terminal)",null,33033177.406005982,34097847.200116262,39492988.846254364,39377558.230458848,0.33045718539787644,0.36206505568564973,0.41722202421483834,0.42133632312788444]
[null,null,null,null,"Zelzate 1+2",null,3549182.8312433828,3837181.5923773693,4453417.5018137489,4550949.6100303484,3.7886783548420497E-2,4.3071416316950453E-2,4.9504819198867796E-2,5.1079498334733187E-2]
[null,null,null,null,"Zandvliet H",null,0.1,0.1,0.1,0.1,1.1601094038417569E-9,1.2053247682833029E-9,1.1935745052351972E-9,1.2033967799105364E-9]
[null,null,null,null,"'s Gravenvoeren",null,12292556.412348952,10511491.860301038,9841681.3134798333,10405383.5442004,0.14423341563028186,0.12408174439156416,0.11553213925084532,0.12570527381640162]
[null,null,null,null,"Eynatten 1+2",null,11066816.277347418,10806706.292759851,10864696.49741878,11722640.04965914,0.1357208161630683,0.13315312067909063,0.13288417591803348,0.14701022156530091]
[null,null,null,null,"Loenhout",null,2674480.5774063803,3037341.343421007,986914.53381616448,4.5000000000000005E-2,3.3452710907096637E-2,3.9205361243286121E-2,1.2597661027956361E-2,5.7710125208444767E-10]
[null,null,null,"OCUC","Virtualys -> Zeebrugge",null,9089244,9089244,9089244,8912859.3847031966]
[null,null,null,null,"Zelzate -> Zeebrugge",null,5780549.3130692169,5262056.2925799089,4291661,4310871]
[null,null,null,null,"Zeebrugge -> Zelzate",null,4357345.3130692169,4166070,4166070,2385190]
[null,null,null,null,"Eynatten 1+2 -> 's Gravenvoeren",null,0.1,0.1,0.1,0.1]
[null,null,null,null,"s Gravenvoeren -> Eynatten 1+2",null,0.1,0.1,0.1,0.1]
[null,null,"L-grid","IP","Hilvarenbeek L",null,26584041.003202107,23439236.663886037,20675746.270437058,18096449.401209291,0.2914321258063543,0.2671754552311798,0.23697197257246677,0.21545801375404372]
[null,null,null,null,"Blaregnies L",null,0.1,0.1,0.1,0.1,6.7895131186766491E-10,6.6361443678623993E-10,6.1058410260967898E-10,5.6205846525059096E-10]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K14:K28)","v":1},{"$f":"SUM(L14:L28)","v":0.99999999999999989},{"$f":"SUM(M14:M28)","v":1},{"$f":"SUM(N14:N28)","v":1}]
[null,null,null,null,null,null," Revenue per Entry point (in €) and non equalized pseudo Tariffs in quivalent H (in €/kWh/h/yr)"]
[null,null,null,null,null,null,2020,null,2021,null,2022,null,2023]
[null,null,null,null,null,null,"Revenue/point","Tariff","Revenue/point","Tariff","Revenue/point","Tariff","Revenue/point","Tariff"]
[null,"ENTRY","H-grid","IP","Alveringem","Virtualys",{"$f":"K14*$K$7","v":1371474.0513788362},{"$f":"G33/G14*1","v":0.86851477073305516},{"$f":"L14*$L$7","v":1647684.6103266573},{"$f":"I33/H14*1","v":0.90127655023437847},{"$f":"M14*$M$7","v":1867418.211754912},{"$f":"K33/I14*1","v":0.88012560515606941},{"$f":"N14*$N$7","v":2124028.4496687911},{"$f":"M33/J14*1","v":0.90100988790052849}]
[null,null,null,null,"Blaregnies H (Segeo & Troll)",null,543395.43651649437,0.55794168052487125,588796.28137142723,0.57540223846342853,621790.39980327454,0.57495998553928163,704846.10411608429,0.62478850665193097]
[null,null,null,null,"Zeebrugge (incl. IZT, ZPT, LNG-Terminal)",null,23596349.648569275,0.71432273555007952,25913837.878734406,0.75998457400108388,29431422.120232813,0.74523157097096182,30243274.017539334,0.76803324981552379]
[null,null,null,null,"Zelzate 1+2",null,2705312.0076412084,0.76223517814478392,3082721.4118503169,0.80338168461305004,3492138.8284081533,0.78414809008719832,3666456.4150261907,0.80564645386212941]
[null,null,null,null,"Zandvliet H",null,8.2837802696540369E-2,0.82837802696540364,8.6267896186134466E-2,0.86267896186134463,8.419640636573035E-2,0.84196406365730347,8.6379114661833414E-2,0.86379114661833412]
[null,null,null,null,"'s Gravenvoeren",null,10299010.754212573,0.83782497380823995,8880818.9505734667,0.84486760477014999,8149797.8567743534,0.82808999775392422,9023050.7857860122,0.86715215709805793]
[null,null,null,null,"Eynatten 1+2",null,9691167.1898344848,0.87569604003197032,9530078.4434753489,0.88186707265841013,9373834.6672923006,0.86277924740183254,10552307.43262809,0.9001647570791802]
[null,null,null,null,"Loenhout",null,2388696.3217517976,0.89314401530194454,2806018.8612010283,0.92384047228638566,888656.53758122842,0.90043920434022218,4.1423989209108635E-2,0.9205330935357473]
[null,null,null,"OCUC","Virtualys -> Zeebrugge",null,{"$f":"H41*G22","v":3579498.7653548289},{"$f":"Parameters!H31*$F$7","v":0.39381699570996542},{"$f":"J41*H22","v":3640350.2443658602},{"$f":"Parameters!I31*$F$7","v":0.40051188463703474},{"$f":"L41*I22","v":3702236.1985200793},{"$f":"Parameters!J31*$F$7","v":0.40732058667586429},{"$f":"N41*J22","v":3692107.7624669136},{"$f":"Parameters!K31*$F$7","v":0.41424503664935391}]
[null,null,null,null,"Zelzate -> Zeebrugge",null,{"$f":"H42*G23","v":1982066.3794633013},{"$f":"Parameters!H29*$F$7","v":0.34288547197098668},{"$f":"J42*H23","v":1834955.4605612878},{"$f":"Parameters!I29*$F$7","v":0.3487145249944934},{"$f":"L42*I23","v":1522006.124012283},{"$f":"Parameters!J29*$F$7","v":0.35464267191939974},{"$f":"N42*J23","v":1554808.7295054318},{"$f":"Parameters!K29*$F$7","v":0.36067159734202947}]
[null,null,null,null,"Zeebrugge -> Zelzate",null,{"$f":"H43*G24","v":1494070.4042123051},{"$f":"Parameters!H30*$F$7","v":0.34288547197098668},{"$f":"J43*H24","v":1452769.1211438091},{"$f":"Parameters!I30*$F$7","v":0.3487145249944934},{"$f":"L43*I24","v":1477466.1962032537},{"$f":"Parameters!J30*$F$7","v":0.35464267191939974},{"$f":"N43*J24","v":860270.28726423532},{"$f":"Parameters!K30*$F$7","v":0.36067159734202947}]
[null,null,null,null,"Eynatten 1+2 -> 's Gravenvoeren",null,{"$f":"H44*G25","v":2.8401003939235288E-2},{"$f":"Parameters!H34*$F$7","v":0.28401003939235286},{"$f":"J44*H25","v":2.8883821006202289E-2},{"$f":"Parameters!I34*$F$7","v":0.28883821006202287},{"$f":"L44*I25","v":2.9374845963307722E-2},{"$f":"Parameters!J34*$F$7","v":0.29374845963307722},{"$f":"N44*J25","v":2.9874218344683953E-2},{"$f":"Parameters!K34*$F$7","v":0.2987421834468395}]
[null,null,null,null,"'s Gravenvoeren -> Eynatten 1+2",null,{"$f":"H45*G26","v":2.8401003939235288E-2},{"$f":"Parameters!H33*$F$7","v":0.28401003939235286},{"$f":"J45*H26","v":2.8883821006202289E-2},{"$f":"Parameters!I33*$F$7","v":0.28883821006202287},{"$f":"L45*I26","v":2.9374845963307722E-2},{"$f":"Parameters!J33*$F$7","v":0.29374845963307722},{"$f":"N45*J26","v":2.9874218344683953E-2},{"$f":"Parameters!K33*$F$7","v":0.2987421834468395}]
[null,null,"L-grid","IP","Hilvarenbeek L",null,{"$f":"K27*$K$7","v":20809758.852944449},{"$f":"G46/G27*1","v":0.78279140671043457},{"$f":"L27*$L$7","v":19122368.544864427},{"$f":"I46/H27*1","v":0.81582727368964125},{"$f":"M27*$M$7","v":16716332.673399795},{"$f":"K46/I27*1","v":0.80849960406514665},{"$f":"N27*$N$7","v":15465449.788103154},{"$f":"M46/J27*1","v":0.85461238529308847}]
[null,null,null,null,"Blaregnies L",null,{"$f":"K28*$K$7","v":4.8480630039546342E-2},{"$f":"G47/G28*1","v":0.48480630039546341},{"$f":"L28*$L$7","v":4.7496428221443107E-2},{"$f":"I47/H28*1","v":0.47496428221443104},{"$f":"M28*$M$7","v":4.3071452178554237E-2},{"$f":"K47/I28*1","v":0.43071452178554237},{"$f":"N28*$N$7","v":4.0344226797868157E-2},{"$f":"M47/J28*1","v":0.40344226797868155}]
[null,null,null,null,null,null,{"$f":"SUM(G33:G47)-(K7+K4*F7)","v":0},null,{"$f":"SUM(I33:I47)-(L7+L4*F7)","v":0},null,{"$f":"SUM(K33:K47)-(M7+M4*F7)","v":0},null,{"$f":"SUM(M33:M47)-(N7+N4*F7)","v":0}]
[null,null,null,null,null,null,"\"virtual tariff\" for \"equivalent firm H-gas capacity\" (in €/kWh/h/yr)"]
[null,null,null,null,null,null,2020,{"$f":"G50+1","v":2021},{"$f":"H50+1","v":2022},{"$f":"I50+1","v":2023}]
[null,null,null,null,null,null,{"$f":"Parameters!H3","v":1.6E-2},{"$f":"Parameters!I3","v":1.7000000000000001E-2},{"$f":"Parameters!J3","v":1.7000000000000001E-2},{"$f":"Parameters!K3","v":1.7000000000000001E-2}]
[null,"ENTRY","H-grid","IP","Alveringem","Virtualys",{"$f":"'Calculating sheet - CWD method'!H33","v":0.86851477073305516},{"$f":"'Calculating sheet - CWD method'!J33","v":0.90127655023437847},{"$f":"'Calculating sheet - CWD method'!L33","v":0.88012560515606941},{"$f":"'Calculating sheet - CWD method'!N33","v":0.90100988790052849}]
[null,null,null,null,"Blaregnies H (Segeo & Troll)",null,{"$f":"'Calculating sheet - CWD method'!H34","v":0.55794168052487125},{"$f":"'Calculating sheet - CWD method'!J34","v":0.57540223846342853},{"$f":"'Calculating sheet - CWD method'!L34","v":0.57495998553928163},{"$f":"'Calculating sheet - CWD method'!N34","v":0.62478850665193097}]
[null,null,null,null,"Zeebrugge (incl. IZT, ZPT, LNG-Terminal)",null,{"$f":"'Calculating sheet - CWD method'!H35","v":0.71432273555007952},{"$f":"'Calculating sheet - CWD method'!J35","v":0.75998457400108388},{"$f":"'Calculating sheet - CWD method'!L35","v":0.74523157097096182},{"$f":"'Calculating sheet - CWD method'!N35","v":0.76803324981552379}]
[null,null,null,null,"Zelzate 1+2",null,{"$f":"'Calculating sheet - CWD method'!H36","v":0.76223517814478392},{"$f":"'Calculating sheet - CWD method'!J36","v":0.80338168461305004},{"$f":"'Calculating sheet - CWD method'!L36","v":0.78414809008719832},{"$f":"'Calculating sheet - CWD method'!N36","v":0.80564645386212941}]
[null,null,null,null,"Zandvliet H",null,0,0,0,0]
[null,null,null,null,"'s Gravenvoeren",null,{"$f":"'Calculating sheet - CWD method'!H38","v":0.83782497380823995},{"$f":"'Calculating sheet - CWD method'!J38","v":0.84486760477014999},{"$f":"'Calculating sheet - CWD method'!L38","v":0.82808999775392422},{"$f":"'Calculating sheet - CWD method'!N38","v":0.86715215709805793}]
[null,null,null,null,"Eynatten 1+2",null,{"$f":"'Calculating sheet - CWD method'!H39","v":0.87569604003197032},{"$f":"'Calculating sheet - CWD method'!J39","v":0.88186707265841013},{"$f":"'Calculating sheet - CWD method'!L39","v":0.86277924740183254},{"$f":"'Calculating sheet - CWD method'!N39","v":0.9001647570791802}]
[null,null,null,null,"Loenhout",null,{"$f":"'Calculating sheet - CWD method'!H40","v":0.89314401530194454},{"$f":"'Calculating sheet - CWD method'!J40","v":0.92384047228638566},{"$f":"'Calculating sheet - CWD method'!L40","v":0.90043920434022218},0]
[null,null,null,"OCUC","Virtualys -> Zeebrugge",null,{"$f":"'Calculating sheet - CWD method'!H41","v":0.39381699570996542},{"$f":"'Calculating sheet - CWD method'!J41","v":0.40051188463703474},{"$f":"'Calculating sheet - CWD method'!L41","v":0.40732058667586429},{"$f":"'Calculating sheet - CWD method'!N41","v":0.41424503664935391}]
[null,null,null,null,"Zelzate -> Zeebrugge",null,{"$f":"'Calculating sheet - CWD method'!H42","v":0.34288547197098668},{"$f":"'Calculating sheet - CWD method'!J42","v":0.3487145249944934},{"$f":"'Calculating sheet - CWD method'!L42","v":0.35464267191939974},{"$f":"'Calculating sheet - CWD method'!N42","v":0.36067159734202947}]
[null,null,null,null,"Zeebrugge -> Zelzate",null,{"$f":"'Calculating sheet - CWD method'!H43","v":0.34288547197098668},{"$f":"'Calculating sheet - CWD method'!J43","v":0.3487145249944934},{"$f":"'Calculating sheet - CWD method'!L43","v":0.35464267191939974},{"$f":"'Calculating sheet - CWD method'!N43","v":0.36067159734202947}]
[null,null,null,null,"Eynatten 1+2 -> 's Gravenvoeren",null,{"$f":"'Calculating sheet - CWD method'!H44","v":0.28401003939235286},{"$f":"'Calculating sheet - CWD method'!J44","v":0.28883821006202287},{"$f":"'Calculating sheet - CWD method'!L44","v":0.29374845963307722},{"$f":"'Calculating sheet - CWD method'!N44","v":0.2987421834468395}]
[null,null,null,null,"'s Gravenvoeren -> Eynatten 1+2",null,{"$f":"'Calculating sheet - CWD method'!H45","v":0.28401003939235286},{"$f":"'Calculating sheet - CWD method'!J45","v":0.28883821006202287},{"$f":"'Calculating sheet - CWD method'!L45","v":0.29374845963307722},{"$f":"'Calculating sheet - CWD method'!N45","v":0.2987421834468395}]
[null,null,"L-grid","IP","Hilvarenbeek L",null,{"$f":"'Calculating sheet - CWD method'!H46","v":0.78279140671043457},{"$f":"'Calculating sheet - CWD method'!J46","v":0.81582727368964125},{"$f":"'Calculating sheet - CWD method'!L46","v":0.80849960406514665},{"$f":"'Calculating sheet - CWD method'!N46","v":0.85461238529308847}]
[null,null,null,null,"Blaregnies L",null,0,{"$f":"G66","v":0},{"$f":"H66","v":0},{"$f":"I66","v":0}]
[]
[null,"Equalized entry tariffs (H/L) standardized as H",null,null,null,null,{"$f":"(SUMPRODUCT(G52:G59,'Calculating sheet - CWD method'!G14:G21)+SUMPRODUCT(G65:G66,'Calculating sheet - CWD method'!G27:G28))/(SUM('Calculating sheet - CWD method'!G14:G21,'Calculating sheet - CWD method'!G27:G28))","v":0.77823004749227009},{"$f":"(SUMPRODUCT(H52:H59,'Calculating sheet - CWD method'!H14:H21)+SUMPRODUCT(H65:H66,'Calculating sheet - CWD method'!H27:H28))/(SUM('Calculating sheet - CWD method'!H14:H21,'Calculating sheet - CWD method'!H27:H28))","v":0.8079850373883587},{"$f":"(SUMPRODUCT(I52:I59,'Calculating sheet - CWD method'!I14:I21)+SUMPRODUCT(I65:I66,'Calculating sheet - CWD method'!I27:I28))/(SUM('Calculating sheet - CWD method'!I14:I21,'Calculating sheet - CWD method'!I27:I28))","v":0.78800769144861249},{"$f":"(SUMPRODUCT(J52:J59,'Calculating sheet - CWD method'!J14:J21)+SUMPRODUCT(J65:J66,'Calculating sheet - CWD method'!J27:J28))/(SUM('Calculating sheet - CWD method'!J14:J21,'Calculating sheet - CWD method'!J27:J28))","v":0.81903969767421769}]
[null,null,"yearly change (%)",null,null,null,null,{"$f":"H68/G68-1","v":3.8234182799764094E-2},{"$f":"I68/H68-1","v":-2.4724895901932498E-2},{"$f":"J68/I68-1","v":3.9380334179934584E-2}]
[]
[null,null,null,null,null,null," Forecasted contracted capacity \"Firm H-Gas equivalent\" (in kWh/h/yr)",null,null,null," CWD Weight of points in %"]
[null,null,null,null,null,null,{"$f":"G13","v":2020},{"$f":"H13","v":2021},{"$f":"I13","v":2022},{"$f":"J13","v":2023},{"$f":"G72","v":2020},{"$f":"H72","v":2021},{"$f":"I72","v":2022},{"$f":"J72","v":2023}]
[null,"EXIT","H-grid","IP","Alveringem","Virtualys",0.1,0.1,0.1,0.1,1.0056283604444447E-9,1.0077775735666989E-9,9.5999555366846105E-10,1.0030775742134878E-9]
[null,null,null,null,"Blaregnies H (Segeo & Troll)",null,26094377.469263095,25506294.294425979,25360725.246437337,22457534.31324387,0.23426812211630726,0.2375883334822943,0.23451413456291617,0.21415561696869159]
[null,null,null,null,"Zeebrugge (incl. IZT, ZPT, LNG-Terminal)",null,8793948.3220628425,6452019.7499973765,6550087.8032635655,6880287.5800602669,5.3335887372917334E-2,3.8162808498904903E-2,3.4990185924886556E-2,3.9264880500599404E-2]
[null,null,null,null,"Zelzate 1+2",null,3753953.15268096,2772007.8265589625,3189315.4373666467,3510111.0937504619,2.5977526629777935E-2,1.9194206699719121E-2,2.1466680215861799E-2,2.4950292627693826E-2]
[null,null,null,null,"Zandvliet H",null,0.1,0.1,0.1,0.1,8.9170320604331726E-10,8.9909724291900265E-10,8.9476527339318496E-10,9.4704367541028634E-10]
[null,null,null,null,"'s Gravenvoeren",null,0.1,0.1,0.1,0.1,9.4683344047162793E-10,1.0283311351391782E-9,1.0718240250276965E-9,1.0818475024231683E-9]
[null,null,null,null,"Eynatten 1+2",null,4877549.7994483002,4646212.2129278174,4794135.9866842665,4289343.0357523616,4.8374085699290414E-2,4.9844095466388107E-2,5.3324173386172985E-2,4.8043474993754387E-2]
[null,null,null,null,"Loenhout",null,0.1,0.1,0.1,0.1,1.0128072598935E-9,1.0224682632081788E-9,1.0324585733528133E-9,1.0954632694667294E-9]
[null,null,null,"OCUC","Virtualys -> Zeebrugge",null,9089244,9089244,9089244,8912859.3847031966]
[null,null,null,null,"Zelzate -> Zeebrugge",null,5780549.3130692169,5262056.2925799089,4291661,4310871]
[null,null,null,null,"Zeebrugge -> Zelzate",null,4357345.3130692169,4166070,4166070,2385190]
[null,null,null,null,"Eynatten 1+2 -> 's Gravenvoeren",null,0.1,0.1,0.1,0.1]
[null,null,null,null,"'s Gravenvoeren -> Eynatten 1+2",null,0.1,0.1,0.1,0.1]
[null,null,null,"Dom",null,null,47920525.795558453,51331856.726112098,54520492.421657316,57539478.789406642,0.35431412216251074,0.39386288724587409,0.42139222877188393,0.45938129434432606]
[null,null,"L-grid","IP","Hilvarenbeek L",null,0.1,0.1,0.1,0.1,3.3416962091115043E-18,3.9331064293168582E-18,4.4914506699237588E-18,5.3007227073936008E-18]
[null,null,null,null,"Blaregnies L",null,12158113.435634915,11844618.979430983,11789972.665347608,11788842.070260219,0.10800756003321524,0.10919437262168889,0.10948651350107158,0.11308359549610666]
[null,null,null,"Dom",null,null,23766266.356075048,19830025.218608618,16150225.055058228,12665819.34037837,0.17572269212900882,0.15215329202745642,0.12482607967816356,0.1011208409413959]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K73:K89)","v":1},{"$f":"SUM(L73:L89)","v":1},{"$f":"SUM(M73:M89)","v":1},{"$f":"SUM(N73:N89)","v":1}]
[null,null,null,null,null,null," Revenue per Exit point (in €) and pseudo Tariffs in equivalent H (in €/kWh/h/yr)"]
[null,null,null,null,null,null,2020,null,2021,null,2022,null,2023]
[null,null,null,null,null,null,"Revenue/point","Tariff","Revenue/point","Tariff","Revenue/point","Tariff","Revenue/point","Tariff"]
[null,"EXIT","H-grid","IP","Alveringem","Virtualys",{"$f":"K73*$K$8","v":0.14579008826052045},{"$f":"G94/G73*1","v":1.4579008826052045},{"$f":"L73*$L$8","v":0.14644369507230806},{"$f":"I94/H73*1","v":1.4644369507230806},{"$f":"M73*$M$8","v":0.13749094793086186},{"$f":"K94/I73*1","v":1.3749094793086185},{"$f":"N73*$N$8","v":0.14618246713167413},{"$f":"M94/J73*1","v":1.4618246713167411}]
[null,null,null,null,"Blaregnies H (Segeo & Troll)",null,33962815.234117128,1.3015376693359466,34524794.333415657,1.3535793923996453,33587208.337609142,1.3243788579085474,31209746.128693979,1.3897227404118302]
[null,null,null,null,"Zeebrugge (incl. IZT, ZPT, LNG-Terminal)",null,7732323.4242461165,0.87927778752653674,5545571.5998294465,0.85950939623700029,5011308.4510714272,0.76507500381514804,5722226.5264065797,0.83168420793778164]
[null,null,null,null,"Zelzate 1+2",null,3766069.1057594437,1.0032275184547337,2789177.5197381731,1.0061939555201489,3074466.5436511203,0.96398948427304043,3636104.9491444812,1.0358945492119447]
[null,null,null,null,"Zandvliet H",null,0.12927388906751713,1.2927388906751713,0.13065097491343317,1.3065097491343316,0.12814864104769805,1.2814864104769803,0.13801642516180829,1.3801642516180828]
[null,null,null,null,"'s Gravenvoeren",null,0.13726634638005195,1.3726634638005193,0.14943040521799764,1.4943040521799762,0.153507066416084,1.5350706641608398,0.15766192070285448,1.5766192070285447]
[null,null,null,null,"Eynatten 1+2",null,7012990.584816684,1.4378101450875855,7243020.3936778232,1.5589086468165481,7637109.4829326244,1.5930106079895792,7001565.8656038893,1.6323166058868959]
[null,null,null,null,"Loenhout",null,0.14683084290255205,{"$f":"G101/G80*(1-Parameters!$F$15)*1","v":0},0.14857845072741238,{"$f":"I101/H80*(1-Parameters!$F$15)*1","v":0},0.14786913065083626,{"$f":"K101/I80*(1-Parameters!$F$15)*1","v":0},0.15964620035328786,{"$f":"M101/J80*(1-Parameters!$F$15)*1","v":0}]
[null,null,null,"OCUC","Virtualys -> Zeebrugge",null,{"$f":"H102*G81","v":7267467.1902658641},{"$f":"Parameters!H31*$F$8","v":0.79956783977477819},{"$f":"J102*H81","v":7391014.1325003821},{"$f":"Parameters!I31*$F$8","v":0.81316049305094928},{"$f":"L102*I81","v":7516661.3727528872},{"$f":"Parameters!J31*$F$8","v":0.82698422143281525},{"$f":"N102*J81","v":7496097.5783419153},{"$f":"Parameters!K31*$F$8","v":0.84104295319717304}]
[null,null,null,null,"Zelzate -> Zeebrugge",null,{"$f":"H103*G82","v":4024195.3764860956},{"$f":"Parameters!H29*$F$8","v":0.69616141278957888},{"$f":"J103*H82","v":3725515.6320486749},{"$f":"Parameters!I29*$F$8","v":0.70799615680700168},{"$f":"L103*I82","v":3090133.6457219073},{"$f":"Parameters!J29*$F$8","v":0.72003209147272051},{"$f":"N103*J82","v":3156732.8750564824},{"$f":"Parameters!K29*$F$8","v":0.73227263702775669}]
[null,null,null,null,"Zeebrugge -> Zelzate",null,{"$f":"H104*G83","v":3033415.6691583158},{"$f":"Parameters!H30*$F$8","v":0.69616141278957888},{"$f":"J104*H83","v":2949561.5489889453},{"$f":"Parameters!I30*$F$8","v":0.70799615680700168},{"$f":"L104*I83","v":2999704.0953217568},{"$f":"Parameters!J30*$F$8","v":0.72003209147272051},{"$f":"N104*J83","v":1746609.3711122349},{"$f":"Parameters!K30*$F$8","v":0.73227263702775669}]
[null,null,null,null,"Eynatten 1+2 -> 's Gravenvoeren",null,{"$f":"H105*G84","v":5.7662644361477701E-2},{"$f":"Parameters!H34*$F$8","v":0.576626443614777},{"$f":"J105*H84","v":5.864290931562282E-2},{"$f":"Parameters!I34*$F$8","v":0.58642909315622815},{"$f":"L105*I84","v":5.9639838773988402E-2},{"$f":"Parameters!J34*$F$8","v":0.59639838773988396},{"$f":"N105*J84","v":6.0653716033146191E-2},{"$f":"Parameters!K34*$F$8","v":0.60653716033146188}]
[null,null,null,null,"'s Gravenvoeren -> Eynatten 1+2",null,{"$f":"H106*G85","v":5.7662644361477701E-2},{"$f":"Parameters!H33*$F$8","v":0.576626443614777},{"$f":"J106*H85","v":5.864290931562282E-2},{"$f":"Parameters!I33*$F$8","v":0.58642909315622815},{"$f":"L106*I85","v":5.9639838773988402E-2},{"$f":"Parameters!J33*$F$8","v":0.59639838773988396},{"$f":"N106*J85","v":6.0653716033146191E-2},{"$f":"Parameters!K33*$F$8","v":0.60653716033146188}]
[null,null,null,"Dom",null,null,{"$f":"K86*$K$8","v":51366378.648263015},{"$f":"G107/G86*1","v":1.0719076595153709},{"$f":"L86*$L$8","v":57233598.040883794},{"$f":"I107/H86*1","v":1.1149722938381368},{"$f":"M86*$M$8","v":60351963.884776436},{"$f":"K107/I86*1","v":1.1069592588786425},{"$f":"N86*$N$8","v":66947455.199614391},{"$f":"M107/J86*1","v":1.1635047207264555}]
[null,null,"L-grid","IP","Hilvarenbeek L",null,{"$f":"K87*$K$8","v":4.8445947273294613E-10},{"$f":"G108/G87*Parameters!$F$17*'Calculating sheet - CWD method'!$F$10*1","v":5.0275028956061861E-9},{"$f":"L87*$L$8","v":5.7153349482001713E-10},{"$f":"I108/H87*Parameters!$F$17*'Calculating sheet - CWD method'!$F$10*1","v":5.9311180023669135E-9},{"$f":"M87*$M$8","v":6.4326736497134888E-10},{"$f":"K108/I87*Parameters!$F$17*'Calculating sheet - CWD method'!$F$10*1","v":6.6755398997536915E-9},{"$f":"N87*$N$8","v":7.7249531129759395E-10},{"$f":"M108/J87*Parameters!$F$17*'Calculating sheet - CWD method'!$F$10*1","v":8.0166095060168666E-9}]
[null,null,null,null,"Blaregnies L",null,{"$f":"K88*$K$8","v":15658301.147241574},{"$f":"G109/G88*1","v":1.2878890487522314},{"$f":"L88*$L$8","v":15867417.401667604},{"$f":"I109/H88*1","v":1.3396308846424267},{"$f":"M88*$M$8","v":15680702.342196681},{"$f":"K109/I88*1","v":1.3300032822200238},{"$f":"N88*$N$8","v":16480120.188812872},{"$f":"M109/J88*1","v":1.3979422313568326}]
[null,null,null,"Dom",null,null,{"$f":"K89*$K$8","v":25475242.945159305},{"$f":"G110/G89*1","v":1.0719076595153707},{"$f":"L89*$L$8","v":22109928.704860151},{"$f":"I110/H89*1","v":1.1149722938381368},{"$f":"M89*$M$8","v":17877641.157670543},{"$f":"K110/I89*1","v":1.1069592588786428},{"$f":"N89*$N$8","v":14736740.594398672},{"$f":"M110/J89*1","v":1.1635047207264553}]
[]
[null,null,null,null,null,null,"\"virtual tariff\" for \"equivalent firm H-gas capacity\" (in €/kWh/h/yr)"]
[null,null,null,null,null,null,2020,{"$f":"G113+1","v":2021},{"$f":"H113+1","v":2022},{"$f":"I113+1","v":2023}]
[null,null,null,null,null,null,{"$f":"Parameters!H3","v":1.6E-2},{"$f":"Parameters!I3","v":1.7000000000000001E-2},{"$f":"Parameters!J3","v":1.7000000000000001E-2},{"$f":"Parameters!K3","v":1.7000000000000001E-2}]
[null,"EXIT","H-grid","IP","Alveringem","Virtualys",{"$f":"G116","v":1.3015376693359466},{"$f":"H116","v":1.3535793923996453},{"$f":"I116","v":1.3243788579085474},{"$f":"J116","v":1.3897227404118302}]
[null,null,null,null,"Blaregnies H (Segeo & Troll)",null,{"$f":"'Calculating sheet - CWD method'!H95","v":1.3015376693359466},{"$f":"'Calculating sheet - CWD method'!J95","v":1.3535793923996453},{"$f":"'Calculating sheet - CWD method'!L95","v":1.3243788579085474},{"$f":"'Calculating sheet - CWD method'!N95","v":1.3897227404118302}]
[null,null,null,null,"Zeebrugge (incl. IZT, ZPT, LNG-Terminal)",null,{"$f":"'Calculating sheet - CWD method'!H96","v":0.87927778752653674},{"$f":"'Calculating sheet - CWD method'!J96","v":0.85950939623700029},{"$f":"'Calculating sheet - CWD method'!L96","v":0.76507500381514804},{"$f":"'Calculating sheet - CWD method'!N96","v":0.83168420793778164}]
[null,null,null,null,"Zelzate 1+2",null,{"$f":"'Calculating sheet - CWD method'!H97","v":1.0032275184547337},{"$f":"'Calculating sheet - CWD method'!J97","v":1.0061939555201489},{"$f":"'Calculating sheet - CWD method'!L97","v":0.96398948427304043},{"$f":"'Calculating sheet - CWD method'!N97","v":1.0358945492119447}]
[null,null,null,null,"Zandvliet H",null,{"$f":"G118","v":1.0032275184547337},{"$f":"H118","v":1.0061939555201489},{"$f":"I118","v":0.96398948427304043},{"$f":"J118","v":1.0358945492119447}]
[null,null,null,null,"'s Gravenvoeren",null,{"$f":"G118","v":1.0032275184547337},{"$f":"H118","v":1.0061939555201489},{"$f":"I118","v":0.96398948427304043},{"$f":"J118","v":1.0358945492119447}]
[null,null,null,null,"Eynatten 1+2",null,{"$f":"'Calculating sheet - CWD method'!H100","v":1.4378101450875855},{"$f":"'Calculating sheet - CWD method'!J100","v":1.5589086468165481},{"$f":"'Calculating sheet - CWD method'!L100","v":1.5930106079895792},{"$f":"'Calculating sheet - CWD method'!N100","v":1.6323166058868959}]
[null,null,null,null,"Loenhout",null,{"$f":"'Calculating sheet - CWD method'!H101","v":0},{"$f":"'Calculating sheet - CWD method'!J101","v":0},{"$f":"'Calculating sheet - CWD method'!L101","v":0},{"$f":"'Calculating sheet - CWD method'!N101","v":0}]
[null,null,null,"OCUC","Virtualys -> Zeebrugge",null,{"$f":"'Calculating sheet - CWD method'!H102","v":0.79956783977477819},{"$f":"'Calculating sheet - CWD method'!J102","v":0.81316049305094928},{"$f":"'Calculating sheet - CWD method'!L102","v":0.82698422143281525},{"$f":"'Calculating sheet - CWD method'!N102","v":0.84104295319717304}]
[null,null,null,null,"Zelzate -> Zeebrugge",null,{"$f":"'Calculating sheet - CWD method'!H103","v":0.69616141278957888},{"$f":"'Calculating sheet - CWD method'!J103","v":0.70799615680700168},{"$f":"'Calculating sheet - CWD method'!L103","v":0.72003209147272051},{"$f":"'Calculating sheet - CWD method'!N103","v":0.73227263702775669}]
[null,null,null,null,"Zeebrugge -> Zelzate",null,{"$f":"'Calculating sheet - CWD method'!H104","v":0.69616141278957888},{"$f":"'Calculating sheet - CWD method'!J104","v":0.70799615680700168},{"$f":"'Calculating sheet - CWD method'!L104","v":0.72003209147272051},{"$f":"'Calculating sheet - CWD method'!N104","v":0.73227263702775669}]
[null,null,null,null,"Eynatten 1+2 -> 's Gravenvoeren",null,{"$f":"'Calculating sheet - CWD method'!H105","v":0.576626443614777},{"$f":"'Calculating sheet - CWD method'!J105","v":0.58642909315622815},{"$f":"'Calculating sheet - CWD method'!L105","v":0.59639838773988396},{"$f":"'Calculating sheet - CWD method'!N105","v":0.60653716033146188}]
[null,null,null,null,"'s Gravenvoeren -> Eynatten 1+2",null,{"$f":"'Calculating sheet - CWD method'!H106","v":0.576626443614777},{"$f":"'Calculating sheet - CWD method'!J106","v":0.58642909315622815},{"$f":"'Calculating sheet - CWD method'!L106","v":0.59639838773988396},{"$f":"'Calculating sheet - CWD method'!N106","v":0.60653716033146188}]
[null,null,null,"Dom",null,null,{"$f":"'Calculating sheet - CWD method'!H107","v":1.0719076595153709},{"$f":"'Calculating sheet - CWD method'!J107","v":1.1149722938381368},{"$f":"'Calculating sheet - CWD method'!L107","v":1.1069592588786425},{"$f":"'Calculating sheet - CWD method'!N107","v":1.1635047207264555}]
[null,null,"L-grid","IP","Hilvarenbeek L",null,{"$f":"'Calculating sheet - CWD method'!H108","v":5.0275028956061861E-9},{"$f":"'Calculating sheet - CWD method'!J108","v":5.9311180023669135E-9},{"$f":"'Calculating sheet - CWD method'!L108","v":6.6755398997536915E-9},{"$f":"'Calculating sheet - CWD method'!N108","v":8.0166095060168666E-9}]
[null,null,null,null,"Blaregnies L",null,{"$f":"'Calculating sheet - CWD method'!H109","v":1.2878890487522314},{"$f":"'Calculating sheet - CWD method'!J109","v":1.3396308846424267},{"$f":"'Calculating sheet - CWD method'!L109","v":1.3300032822200238},{"$f":"'Calculating sheet - CWD method'!N109","v":1.3979422313568326}]
[null,null,null,"Dom",null,null,{"$f":"'Calculating sheet - CWD method'!H110","v":1.0719076595153707},{"$f":"'Calculating sheet - CWD method'!J110","v":1.1149722938381368},{"$f":"'Calculating sheet - CWD method'!L110","v":1.1069592588786428},{"$f":"'Calculating sheet - CWD method'!N110","v":1.1635047207264553}]

{"sheet":"Results - Estimated ref. prices","index":3,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,1,24,2],[25,1,25,2],[23,8,23,9],[8,8,9,8],[1,1,1,2],[5,1,6,1],[7,1,10,1],[14,1,15,1],[1,8,1,9],[4,8,5,8],[6,8,7,8],[21,8,21,9],[21,1,21,2],[22,1,22,2],[23,1,23,2],[18,8,20,9],[22,8,22,9],[1,3,1,6],[2,1,3,1],[2,2,3,2],[1,10,1,13],[18,3,18,6],[18,1,20,2],[2,8,3,8],[2,9,3,9],[18,10,18,13]]}
[]
[null,"  ENTRY",null,"Reference price in €/kWh/h/year - FIRM",null,null,null,null,"  EXIT",null,"Reference price in €/kWh/h/year - FIRM"]
[null,"Border with","Interconnection Point",2020,2021,2022,2023,null,"Border with","Interconnection Point",2020,2021,2022,2023]
[null,null,null,{"$f":"Parameters!H$3","v":1.6E-2},{"$f":"Parameters!I$3","v":1.7000000000000001E-2},{"$f":"Parameters!J$3","v":1.7000000000000001E-2},{"$f":"Parameters!K$3","v":1.7000000000000001E-2},null,null,null,{"$f":"Parameters!H$3","v":1.6E-2},{"$f":"Parameters!I$3","v":1.7000000000000001E-2},{"$f":"Parameters!J$3","v":1.7000000000000001E-2},{"$f":"Parameters!K$3","v":1.7000000000000001E-2}]
[null,"France","Virtualys",{"$f":"SUM('Calculating sheet - CWD method'!G68:J68)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":0.77824451482911161},{"$f":"D5*(1+E$4)","v":0.79147467158120643},{"$f":"E5*(1+F$4)","v":0.8049297409980869},0.81861354659505425,null,"France","Virtualys",{"$f":"SUM('Calculating sheet - CWD method'!G115,'Calculating sheet - CWD method'!H115,'Calculating sheet - CWD method'!I115,'Calculating sheet - CWD method'!J115)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":1.3085566893184066},{"$f":"K5*(1+L$4)","v":1.3308021530368195},1.3534257896384452,1.3764340280622986]
[null,"Germany","Eynatten 1",{"$f":"D5","v":0.77824451482911161},{"$f":"D6*(1+E$4)","v":0.79147467158120643},0.8049297409980869,0.81861354659505425,null,null,"Blaregnies L",{"$f":"SUM('Calculating sheet - CWD method'!G130,'Calculating sheet - CWD method'!H130,'Calculating sheet - CWD method'!I130,'Calculating sheet - CWD method'!J130)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))*'Calculating sheet - CWD method'!$F$10","v":1.5049810809108202},1.530565759286304,1.5565853771941711,1.5830473286064719]
[null,null,"Eynatten 2",{"$f":"D5","v":0.77824451482911161},{"$f":"D7*(1+E$4)","v":0.79147467158120643},0.8049297409980869,0.81861354659505425,null,"Germany","Eynatten 1",{"$f":"SUM('Calculating sheet - CWD method'!G121,'Calculating sheet - CWD method'!H121,'Calculating sheet - CWD method'!I121,'Calculating sheet - CWD method'!J121)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":1.5164031188899683},1.5421819719110976,1.5683990654335862,1.595061849545957]
[null,"The Netherlands","'s Gravenvoeren",{"$f":"D5","v":0.77824451482911161},{"$f":"D8*(1+E$4)","v":0.79147467158120643},0.8049297409980869,0.81861354659505425,null,null,"Eynatten 2",{"$f":"SUM('Calculating sheet - CWD method'!G121,'Calculating sheet - CWD method'!H121,'Calculating sheet - CWD method'!I121,'Calculating sheet - CWD method'!J121)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":1.5164031188899683},1.5421819719110976,1.5683990654335862,1.595061849545957]
[null,null,"Zandvliet H",{"$f":"D5","v":0.77824451482911161},{"$f":"D9*(1+E$4)","v":0.79147467158120643},0.8049297409980869,0.81861354659505425,null,"The Netherlands","Zelzate 1",{"$f":"SUM('Calculating sheet - CWD method'!G118,'Calculating sheet - CWD method'!H118,'Calculating sheet - CWD method'!I118,'Calculating sheet - CWD method'!J118)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":0.9771260724280223},0.99373721565929862,1.0106307483255066,1.0278114710470401]
[null,null,"Zelzate 1",{"$f":"D5","v":0.77824451482911161},{"$f":"D10*(1+E$4)","v":0.79147467158120643},0.8049297409980869,0.81861354659505425,null,null,"Zelzate 2",{"$f":"SUM('Calculating sheet - CWD method'!G118,'Calculating sheet - CWD method'!H118,'Calculating sheet - CWD method'!I118,'Calculating sheet - CWD method'!J118)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":0.9771260724280223},0.99373721565929862,1.0106307483255066,1.0278114710470401]
[null,null,"Hilvarenbeek L",{"$f":"D5*'Calculating sheet - CWD method'!$F$10","v":0.89736357322132265},{"$f":"D11*(1+E$4)","v":0.91261875396608505},0.92813327278350843,0.94391153842082798,null,"United Kingdom","IZT",{"$f":"SUM('Calculating sheet - CWD method'!G117,'Calculating sheet - CWD method'!H117,'Calculating sheet - CWD method'!I117,'Calculating sheet - CWD method'!J117)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":0.81292117619576953},0.82674083619109751,0.84079543040634608,0.85508895272325391]
[null,"United Kingdom","IZT",{"$f":"D5","v":0.77824451482911161},{"$f":"D12*(1+E$4)","v":0.79147467158120643},0.8049297409980869,0.81861354659505425,null,"Zeebrugge Area","Zeebrugge",{"$f":"SUM('Calculating sheet - CWD method'!G117,'Calculating sheet - CWD method'!H117,'Calculating sheet - CWD method'!I117,'Calculating sheet - CWD method'!J117)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":0.81292117619576953},0.82674083619109751,0.84079543040634608,0.85508895272325391]
[null,"Zeebrugge Area","Zeebrugge",{"$f":"D5","v":0.77824451482911161},{"$f":"D13*(1+E$4)","v":0.79147467158120643},0.8049297409980869,0.81861354659505425,null,"Storage","Loenhout",{"$f":"SUM('Calculating sheet - CWD method'!G122,'Calculating sheet - CWD method'!H122,'Calculating sheet - CWD method'!I122,'Calculating sheet - CWD method'!J122)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":0},0,0,0]
[null,"Norway","ZPT",{"$f":"D5","v":0.77824451482911161},{"$f":"D14*(1+E$4)","v":0.79147467158120643},0.8049297409980869,0.81861354659505425]
[null,"LNG Terminal","Dunkirk LNG Terminal",{"$f":"D5","v":0.77824451482911161},{"$f":"D15*(1+E$4)","v":0.79147467158120643},0.8049297409980869,0.81861354659505425]
[null,null,"Zeebrugge LNG Terminal",{"$f":"D5","v":0.77824451482911161},{"$f":"D16*(1+E$4)","v":0.79147467158120643},0.8049297409980869,0.81861354659505425]
[null,"Storage","Loenhout",{"$f":"D5*(1-Parameters!$F$14)","v":0.38912225741455581},{"$f":"D17*(1+E$4)","v":0.39573733579060322},0.40246487049904345,0.40930677329752713]
[]
[null,"  OCUC",null,"Reference price in €/kWh/h/year - FIRM",null,null,null,null,"  OTHER TRANSMISSION SERVICES",null,"Reference price in €/kWh/h/year - FIRM"]
[null,null,null,2020,2021,2022,2023,null,null,null,2020,2021,2022,2023]
[null,null,null,{"$f":"Parameters!H$3","v":1.6E-2},{"$f":"Parameters!I$3","v":1.7000000000000001E-2},{"$f":"Parameters!J$3","v":1.7000000000000001E-2},{"$f":"Parameters!K$3","v":1.7000000000000001E-2},null,null,null,{"$f":"Parameters!H$3","v":1.6E-2},{"$f":"Parameters!I$3","v":1.7000000000000001E-2},{"$f":"Parameters!J$3","v":1.7000000000000001E-2},{"$f":"Parameters!K$3","v":1.7000000000000001E-2}]
[null,"Zelzate 1/2/VIP BE-NL - IZT/Zeebrugge",null,{"$f":"SUM('Calculating sheet - CWD method'!G124,'Calculating sheet - CWD method'!H124,'Calculating sheet - CWD method'!I124,'Calculating sheet - CWD method'!J124)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))+SUM('Calculating sheet - CWD method'!G61,'Calculating sheet - CWD method'!H61,'Calculating sheet - CWD method'!I61,'Calculating sheet - CWD method'!J61)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":1.0390468847605656},{"$f":"D22*(1+E$21)","v":1.0567106818014951},1.0746747633921203,1.0929442343697862,null,"Domestic HP H-grid",null,{"$f":"SUM('Calculating sheet - CWD method'!G128,'Calculating sheet - CWD method'!H128,'Calculating sheet - CWD method'!I128,'Calculating sheet - CWD method'!J128)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":1.0863195539898163},{"$f":"K22*(1+L$21)","v":1.1047869864076429},1.1235683651765729,1.1426690273845745]
[null,"IZT/Zeebrugge - Zelzate 1/2/VIP BE-NL",null,{"$f":"SUM('Calculating sheet - CWD method'!G62,'Calculating sheet - CWD method'!H62,'Calculating sheet - CWD method'!I62,'Calculating sheet - CWD method'!J62)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))+SUM('Calculating sheet - CWD method'!G125,'Calculating sheet - CWD method'!H125,'Calculating sheet - CWD method'!I125,'Calculating sheet - CWD method'!J125)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":1.0390468847605656},1.0567106818014951,1.0746747633921203,1.0929442343697862,null,"Domestic HP L-grid",null,{"$f":"K22*'Calculating sheet - CWD method'!$F$10","v":1.2525929551107067},1.2738870353475886,1.2955431149484975,1.3175673479026218]
[null,"Dunkirk LNG Terminal/Vitrualys - IZT/Zeebrugge",null,{"$f":"SUM('Calculating sheet - CWD method'!G123,'Calculating sheet - CWD method'!H123,'Calculating sheet - CWD method'!I123,'Calculating sheet - CWD method'!J123)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))+SUM('Calculating sheet - CWD method'!G60,'Calculating sheet - CWD method'!H60,'Calculating sheet - CWD method'!I60,'Calculating sheet - CWD method'!J60)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":1.1933848354847436},1.2136723776879841,1.2343048081086796,1.255287989846527,null,"70% Entry + Domestic HP H-grid",null,{"$f":"0.7*D5+K22","v":1.6310907143701945},1.6588192565144877,1.6870191838752338,1.7156985100011126]
[null,"'s Gravenvoeren - Eynatten 1/2",null,{"$f":"SUM('Calculating sheet - CWD method'!G64,'Calculating sheet - CWD method'!H64,'Calculating sheet - CWD method'!I64,'Calculating sheet - CWD method'!J64)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))+SUM('Calculating sheet - CWD method'!G127,'Calculating sheet - CWD method'!H127,'Calculating sheet - CWD method'!I127,'Calculating sheet - CWD method'!J127)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":0.86063648300713003},0.87526730321825119,0.89014684737296135,0.90527934377830166]
[null,"Eynatten 1/2 - 's Gravenvoeren",null,{"$f":"SUM('Calculating sheet - CWD method'!G126,'Calculating sheet - CWD method'!H126,'Calculating sheet - CWD method'!I126,'Calculating sheet - CWD method'!J126)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))+SUM('Calculating sheet - CWD method'!G64,'Calculating sheet - CWD method'!H64,'Calculating sheet - CWD method'!I64,'Calculating sheet - CWD method'!J64)/(1+(1+'Calculating sheet - CWD method'!$H$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)+(1+'Calculating sheet - CWD method'!$H$51)*(1+'Calculating sheet - CWD method'!$I$51)*(1+'Calculating sheet - CWD method'!$J$51))","v":0.86063648300713003},0.87526730321825119,0.89014684737296135,0.90527934377830166]