{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduction","Data","Results I","Results II","Tariffs"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":5,"defined_names":103,"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":"Introduction","index":0,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"To obtain an optimal use of this document, it is recomended to download it before use."]
[]
[null,null,null,"With this simulator, Elia is aiming at giving more information to all market players, on the tariff conditions for"]
[null,null,null,"access to the grid (*), for public service obligations & for taxes and levies."]
[null,null,null,"Connection tariffs and tariffs for imbalance are not handled here."]
[]
[null,null,null,"This simulation shows how the amounts related to the access to the Elia-grid by grid users are computed."]
[null,null,null,"The region in which the access point is located, the infrastructure level and the type of access point is also"]
[null,null,null,"taken into account."]
[]
[null,null,null,"Tariffs are applicable from the 1st of January 2027 to the 31st of December 2027."]
[null,null,null,"Tariffs for Public Service Obligations and levies are validated for 2024 and will still be adapted for 2027."]
[null,null,null,"The simulation can be used by customers directly connected to the Elia grid, with or without local"]
[null,null,null,"production in the same access point.  The simulation is not intended for distribution grid operators."]
[]
[null,null,null,"To use the file, fill-in the description of the access profile, on the sheet \"Data\". Results are shown on the"]
[null,null,null,"sheets \"Results I\" (tariffs applicable in the given access point) and \"Results II\" (amounts linked to the terms"]
[null,null,null,"for access to the grid, for public service obligations & for taxes and levies in the given access point)."]
[]
[]
[null,null,null,"(*)   Except of the tariff for supplementary deliveries of reactive energy and the tariff for any exceeding"]
[null,null,null,"of the power put at disposal."]
[]
[]
[null,null,null,"Disclaimer :"]
[]
[null,null,null,"This file and the information included herein (including tariffs) are given for information purposes only."]
[null,null,null,"These elements are aiming at facilitating the computation of the use of system charges, for one given grid"]
[null,null,null,"user connected to one given point. The given information and tariffs, as well as the results of the"]
[null,null,null,"simulation, are not of contractual nature. They do not constitute an offer for the conclusion of any contract,"]
[null,null,null,"and do not engage Elia in any way."]
[]
[null,null,null,"Elia does not guarantee the adequacy, accurracy or completeness of the given information and/or"]
[null,null,null,"computed results, nor the period in wich the mentioned charges will be valid. Elia cannot be held"]
[null,null,null,"responsible for the consequences arising from the possible uncompleteness or inaccuracy of the given"]
[null,null,null,"information and tariffs, as well as in case these information and tariffs are not up to date."]

{"sheet":"Data","index":1,"n_rows":94,"n_cols":10,"rows_kept":94,"cut":false,"hidden":false,"merged":[[11,5,11,7],[88,5,88,7],[7,10,9,10],[60,8,60,10],[61,8,61,10],[62,8,62,10],[13,7,13,10],[24,9,24,11],[25,9,25,11],[26,9,26,11],[34,9,34,11],[35,9,35,11],[9,5,9,9],[13,5,13,6],[64,8,64,10],[46,6,46,10],[63,8,63,10],[71,8,71,10],[65,8,65,10],[66,8,66,10],[67,8,67,10],[68,8,68,10],[69,8,69,10],[70,8,70,10]]}
[]
[]
[null,null,"  Data to be provided by the user"]
[]
[null,null,null,"1. Description of the access point"]
[]
[null,null,null,null,"Please, fill in infrastructure level, region and type of access point."]
[]
[]
[null,null,null,null,"Infrastructure level:","On the 70/36/30 kV network"]
[]
[null,null,null,null,"Region:","Brussels"]
[]
[null,null,null,null,"Type of access point:","Principal"]
[]
[null,null,null,"2. Net offtake peak (in MW)"]
[]
[null,null,null,null,"Please, fill in the net offtake peak for each month (column A)."]
[null,null,null,null,"Please, fill also in the net offtake peak realised during the hours 17-20, weekend and holidays"]
[null,null,null,null,"excluded, only during the months of January to March and November to December (column B)"]
[]
[null,null,null,null,"P.S. : For each month, the value in column B is always smaller or equal to the value in column A for the year 2023."]
[]
[null,null,null,null,null,"A\n(year 2023)","B\n(year 2022)","B\n(year 2023)","Yearly peak"]
[null,null,null,null,"January",null,null,null,{"$f":"MAX($G$26:$G$36,H25)","v":0},{"$f":"IF(H25>F25,\"Peaks A and B incompatible\",\"\")","v":""}]
[null,null,null,null,"February",null,null,null,{"$f":"MAX($G27:$G$36,H$25:H26)","v":0},{"$f":"IF(H26>F26,\"Peaks A and B incompatible\",\"\")","v":""}]
[null,null,null,null,"March",null,null,null,{"$f":"MAX($G28:$G$36,H$25:H27)","v":0},{"$f":"IF(H27>F27,\"Peaks A and B incompatible\",\"\")","v":""}]
[null,null,null,null,"April",null,null,null,{"$f":"MAX($G29:$G$36,H$25:H28)","v":0}]
[null,null,null,null,"May",null,null,null,{"$f":"MAX($G30:$G$36,H$25:H29)","v":0}]
[null,null,null,null,"Jun",null,null,null,{"$f":"MAX($G31:$G$36,H$25:H30)","v":0}]
[null,null,null,null,"July",null,null,null,{"$f":"MAX($G32:$G$36,H$25:H31)","v":0}]
[null,null,null,null,"August",null,null,null,{"$f":"MAX($G33:$G$36,H$25:H32)","v":0}]
[null,null,null,null,"September",null,null,null,{"$f":"MAX($G34:$G$36,H$25:H33)","v":0}]
[null,null,null,null,"October",null,null,null,{"$f":"MAX($G35:$G$36,H$25:H34)","v":0}]
[null,null,null,null,"November",null,null,null,{"$f":"MAX($G36:$G$36,H$25:H35)","v":0},{"$f":"IF(H35>F35,\"Peaks A and B incompatible\",\"\")","v":""}]
[null,null,null,null,"December",null,null,null,{"$f":"MAX(H$25:H36)","v":0},{"$f":"IF(H36>F36,\"Peaks A and B incompatible\",\"\")","v":""}]
[]
[]
[null,null,null,"3. Power put at disposal (in MVA)"]
[]
[null,null,null,null,"Please fill in, the power put at disposal of the offtake point."]
[]
[null,null,null,null,"P.S. : The power put at disposal must be at least equal to the maximum offtake peak of the year."]
[null,null,null,null,"         The power at disposal needs to take into account the power of the installations"]
[null,null,null,null,"         situated behind the access point."]
[]
[null,null,null,null,null,null,{"$f":"IF(F47<MAX(F25:F36),\"        Error: lower than the maximum peak of 2019\",\"\")","v":""}]
[]
[]
[null,null,null,"4. Net offtaken energy (in MWh)"]
[]
[null,null,null,null,"Please, fill in the net offtaken energy for each month."]
[]
[null,null,null,null,"If you wish so, you can introduce an utilisation % for automatic calculation of the monthly energies based on the net offtake"]
[null,null,null,null,"peaks filled in above and thereupon push on the button."]
[]
[null,null,null,null,null,1]
[]
[]
[null,null,null,null,null,"Number of monthly hours","Maximum monthly energy","Monthly energy"]
[null,null,null,null,"January",744,{"$f":"F25*F61","v":0},null,{"$f":"IF(H61>G61,\"Energy and peak not compatible\",\"\")","v":""}]
[null,null,null,null,"February",696,0,null,{"$f":"IF(H62>G62,\"Energy and peak not compatible\",\"\")","v":""}]
[null,null,null,null,"March",743,0,null,""]
[null,null,null,null,"April",720,0,null,""]
[null,null,null,null,"May",744,0,null,""]
[null,null,null,null,"Jun",720,0,null,""]
[null,null,null,null,"July",744,0,null,""]
[null,null,null,null,"August",744,0,null,""]
[null,null,null,null,"September",720,0,null,""]
[null,null,null,null,"October",745,0,null,""]
[null,null,null,null,"November",720,0,null,""]
[null,null,null,null,"December",744,0,null,""]
[null,null,null,null,null,null,null,{"$f":"SUM(H61:H72)","v":0}]
[]
[]
[null,null,null,"5. Net injected energy (in MWh)"]
[]
[null,null,null,null,"Please, fill in the net injected energy for the year, if applicable."]
[]
[]
[]
[]
[null,null,null,"6. Data concerning the public service obligations and surcharges"]
[]
[null,null,null,null,"Are you Access Holder ?","No"]
[]
[null,null,null,null,"Do you have a sector agreement ?","No",null,"Taken into account in the calculation if access holder"]
[]
[null,null,null,null,"What is the type of your activity?","Other"]
[null,null,null,null,null,null,null,"Taken into account in the calculation if access holder in Wallonia"]
[null,null,null,null,null,null,null,"and sector agreement and/or convenant"]
[]
[null,null,null,null,"Thanks !"]
[null,null,null,null,"The results can be consulted on the sheets \"Results I\" et \"Results II\"."]

{"sheet":"Results I","index":2,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Tariffs for:"]
[null,"Type of customer:","Customer directly connected to the Elia grid"]
[null,"Infrastructure level:",{"$f":"D_Tension","v":"On the 70/36/30 kV network"}]
[null,"Region:",{"$f":"D_Region","v":"Brussels"}]
[null,"Type of access point:",{"$f":"D_Type","v":"Principal"}]
[]
[]
[]
[null,"A. Tariffs for the management and the development of the grid infrastructure "]
[]
[null,null,null,"€/kW net offtaken by month"]
[null,null,"1. Tariffs for the monthly peak",{"$f":"VLOOKUP($C$5,Tariffs!D9:F11,3,FALSE)","v":0.77300000000000002}]
[]
[null,null,null,"€/kW net offtaken by year"]
[null,null,"2. Tariffs for the yearly peak",{"$f":"VLOOKUP($C$5,Tariffs!D16:F18,3,FALSE)","v":18.755500000000001}]
[]
[null,null,null,"€/kVA at offtake by year"]
[null,null,"3. Tariffs for the power put at disposal",{"$f":"IF($C$7=\"Principal\",VLOOKUP($C$5,Tariffs!D24:G26,3,FALSE),VLOOKUP($C$5,Tariffs!D24:H26,4,FALSE))","v":17.381799999999998}]
[]
[null,"B. Tariffs for the management fo the electric system"]
[null,null,null,"€/MWh net offtaken"]
[null,null,null,{"$f":"VLOOKUP($C$5,Tariffs!D32:F34,3,FALSE)","v":4.1341000000000001}]
[]
[null,"C. Tariffs for the power reserves and black-start"]
[null,null,null,"€/MWh net offtaken"]
[null,null,"1. based on offtake",{"$f":"VLOOKUP($C$5,Tariffs!D41:F43,3,FALSE)","v":1.6203000000000001}]
[]
[null,null,null,"€/MWh net injected"]
[null,null,"2. based on injection",{"$f":"VLOOKUP($C$5,Tariffs!D47:F49,3,FALSE)","v":1.05}]
[]
[null,"D. Tariffs for market integration"]
[null,null,null,"€/MWh net offtaken"]
[null,null,null,{"$f":"VLOOKUP($C$5,Tariffs!D54:F56,3,FALSE)","v":0.66820000000000002}]
[]
[null,"E. Tariffs for public service obligations"]
[null,null,null,"€/MWh net offtaken"]
[null,null,"1. Tariffs for financing the support measures for renewable energy  in Flemish Region",{"$f":"IF($C$6=\"Flanders\",VLOOKUP($C$5,Tariffs!D63:F65,3,FALSE),0)","v":0}]
[]
[null,null,null,"€/MWh net offtaken"]
[null,null,"2. Tariffs for Financing measures for promotion of rational use of energy  in Flemish Region",{"$f":"IF($C$6=\"Flanders\",VLOOKUP($C$5,Tariffs!D70:F72,3,FALSE),0)","v":0}]
[]
[null,null,null,"First term","Second term"]
[null,null,null,"€/MWh net offtaken","€/MWh exempted"]
[null,null,"3. Tariffs  for financing the support measures for renewable energy in Walloon Region",{"$f":"IF($C$6=\"Wallonia\",VLOOKUP($C$5,Tariffs!D78:F80,3,FALSE),0)","v":0},{"$f":"IF($C$6=\"Wallonia\",VLOOKUP($C$5,Tariffs!D78:G80,4,FALSE),0)","v":0}]
[]
[null,null,null,"€/MWh net offtaken"]
[null,null,"4. Tariffs  for financing the support measures for renewable energy in Brussels",{"$f":"IF($C$6=\"Brussels\",VLOOKUP($C$5,Tariffs!D84:F86,3,FALSE),0)","v":0.59489999999999998}]
[]
[null,"F. Taxes and levies"]
[null,null,null,"€/MWh net offtaken"]
[null,null,"1. Occupying public domain in Walloon Region",{"$f":"IF($C$6=\"Wallonia\",VLOOKUP($C$5,Tariffs!D92:F94,3,FALSE),0)","v":0}]
[]
[null,null,null,"€/MWh net offtaken"]
[null,null,"2. Occupying road network in Brussels Region",{"$f":"IF($C$6=\"Brussels\",VLOOKUP($C$5,Tariffs!D99:F101,3,FALSE),0)","v":4.1778000000000004}]
[]
[null,null,null,"€/MWh net offtaken"]
[null,null,"3. Levie for the taxes \"pylons\" et \"trenches\" in Flemish region",{"$f":"IF($C$6=\"Flanders\",VLOOKUP($C$5,Tariffs!D106:F108,3,FALSE),0)","v":0}]

{"sheet":"Results II","index":3,"n_rows":317,"n_cols":13,"rows_kept":317,"cut":false,"hidden":false,"merged":[[314,1,314,8],[316,1,316,8],[97,3,97,8],[103,3,103,8],[310,1,310,8],[137,4,137,8],[176,4,176,8],[306,1,306,8],[308,1,308,8],[220,4,220,8],[239,4,239,8]]}
[]
[null,"Results"]
[]
[null,null,null,null,"Type of customer:","Customer directly connected to the Elia grid"]
[null,null,null,null,"Infrastructure level:",{"$f":"D_Tension","v":"On the 70/36/30 kV network"}]
[null,null,null,null,"Region:",{"$f":"D_Region","v":"Brussels"}]
[null,null,null,null,"Type of access point:",{"$f":"D_Type","v":"Principal"}]
[null,null,null,null,"Access Holder:   ",{"$f":"D_DA","v":"No"}]
[null,null,null,null,"Sector agreement:   ",{"$f":"D_DB","v":"No"}]
[null,null,null,null,"Type of activity:  ",{"$f":"D_TA","v":"Other"}]
[]
[]
[]
[null,"a. Terms for the management and the development of the grid infrastructure "]
[]
[null,null,"a.1) Terms for the monthly peak :"]
[]
[null,null,null,null,null,"Monthly peak",null,"Tariff",null,"Amount"]
[null,null,null,null,"January",{"$f":"Data!F25","v":0},"MW *",{"$f":"'Results I'!$D$14","v":0.77300000000000002},"€/kW =",{"$f":"F19*H19*1000","v":0},"€"]
[null,null,null,null,"February",{"$f":"Data!F26","v":0},"MW *",{"$f":"H19","v":0.77300000000000002},"€/kW =",{"$f":"F20*H20*1000","v":0},"€"]
[null,null,null,null,"March",{"$f":"Data!F27","v":0},"MW *",{"$f":"H20","v":0.77300000000000002},"€/kW =",0,"€"]
[null,null,null,null,"April",{"$f":"Data!F28","v":0},"MW *",0.77300000000000002,"€/kW =",0,"€"]
[null,null,null,null,"May",{"$f":"Data!F29","v":0},"MW *",0.77300000000000002,"€/kW =",0,"€"]
[null,null,null,null,"Jun",{"$f":"Data!F30","v":0},"MW *",0.77300000000000002,"€/kW =",0,"€"]
[null,null,null,null,"July",{"$f":"Data!F31","v":0},"MW *",0.77300000000000002,"€/kW =",0,"€"]
[null,null,null,null,"August",{"$f":"Data!F32","v":0},"MW *",0.77300000000000002,"€/kW =",0,"€"]
[null,null,null,null,"September",{"$f":"Data!F33","v":0},"MW *",0.77300000000000002,"€/kW =",0,"€"]
[null,null,null,null,"October",{"$f":"Data!F34","v":0},"MW *",0.77300000000000002,"€/kW =",0,"€"]
[null,null,null,null,"November",{"$f":"Data!F35","v":0},"MW *",0.77300000000000002,"€/kW =",0,"€"]
[null,null,null,null,"December",{"$f":"Data!F36","v":0},"MW *",0.77300000000000002,"€/kW =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for the monthly peak :  ",{"$f":"SUM(J19:J30)","v":0},"€"]
[]
[]
[null,null,"a.2) Terms for the yearly peak :"]
[]
[null,null,null,null,null,"Yearly peak",null,"Tariff",null,"Amount"]
[null,null,null,null,"January",{"$f":"Data!I25","v":0},"MW *",{"$f":"'Results I'!$D$17/12","v":1.5629583333333334},"€/kW =",{"$f":"F38*H38*1000","v":0},"€"]
[null,null,null,null,"February",{"$f":"Data!I26","v":0},"MW *",{"$f":"H38","v":1.5629583333333334},"€/kW =",0,"€"]
[null,null,null,null,"March",{"$f":"Data!I27","v":0},"MW *",{"$f":"H39","v":1.5629583333333334},"€/kW =",0,"€"]
[null,null,null,null,"April",{"$f":"Data!I28","v":0},"MW *",1.5629583333333334,"€/kW =",0,"€"]
[null,null,null,null,"May",{"$f":"Data!I29","v":0},"MW *",1.5629583333333334,"€/kW =",0,"€"]
[null,null,null,null,"Jun",{"$f":"Data!I30","v":0},"MW *",1.5629583333333334,"€/kW =",0,"€"]
[null,null,null,null,"July",{"$f":"Data!I31","v":0},"MW *",1.5629583333333334,"€/kW =",0,"€"]
[null,null,null,null,"August",{"$f":"Data!I32","v":0},"MW *",1.5629583333333334,"€/kW =",0,"€"]
[null,null,null,null,"September",{"$f":"Data!I33","v":0},"MW *",1.5629583333333334,"€/kW =",0,"€"]
[null,null,null,null,"October",{"$f":"Data!I34","v":0},"MW *",1.5629583333333334,"€/kW =",0,"€"]
[null,null,null,null,"November",{"$f":"Data!I35","v":0},"MW *",1.5629583333333334,"€/kW =",0,"€"]
[null,null,null,null,"December",{"$f":"Data!I36","v":0},"MW *",1.5629583333333334,"€/kW =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for the yearly peak :  ",{"$f":"SUM(J38:J49)","v":0},"€"]
[]
[]
[null,null,"a.3) Terms  for the power put at disposal :"]
[]
[null,null,null,null,null,"Power",null,"Tariff",null,"Amount"]
[null,null,null,null,null,{"$f":"Data!$F$47","v":0},"MVA *",{"$f":"'Results I'!$D$20","v":17.381799999999998},"€/kVA",{"$f":"F57*H57*1000","v":0},"€"]
[]
[null,null,null,null,null,null,null,null,"Total term  for the management and the development of the grid infrastructure  :",{"$f":"J32+J51+J57","v":0},"€"]
[]
[]
[null,"b) Terms for the management fo the electric system :"]
[]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff",null,"Amount"]
[null,null,null,null,"January",{"$f":"Data!H61","v":0},"MWh *",{"$f":"'Results I'!D24","v":4.1341000000000001},"€/MWh =",{"$f":"F65*H65","v":0},"€"]
[null,null,null,null,"February",{"$f":"Data!H62","v":0},"MWh *",{"$f":"H65","v":4.1341000000000001},"€/MWh =",{"$f":"F66*H66","v":0},"€"]
[null,null,null,null,"March",{"$f":"Data!H63","v":0},"MWh *",{"$f":"H66","v":4.1341000000000001},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Data!H64","v":0},"MWh *",4.1341000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"May",{"$f":"Data!H65","v":0},"MWh *",4.1341000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"Jun",{"$f":"Data!H66","v":0},"MWh *",4.1341000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"July",{"$f":"Data!H67","v":0},"MWh *",4.1341000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"August",{"$f":"Data!H68","v":0},"MWh *",4.1341000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Data!H69","v":0},"MWh *",4.1341000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"October",{"$f":"Data!H70","v":0},"MWh *",4.1341000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Data!H71","v":0},"MWh *",4.1341000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Data!H72","v":0},"MWh *",4.1341000000000001,"€/MWh =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for the management fo the electric system :  ",{"$f":"SUM(J65:J76)","v":0},"€"]
[]
[]
[null,"c) Terms for the power reserves and black-start :"]
[]
[null,null,null,"c.1. based on offtake :"]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff",null,"Amount"]
[null,null,null,null,"January",{"$f":"Data!H61","v":0},"MWh *",{"$f":"'Results I'!D28","v":1.6203000000000001},"€/MWh =",{"$f":"F85*H85","v":0},"€"]
[null,null,null,null,"February",{"$f":"Data!H62","v":0},"MWh *",{"$f":"H85","v":1.6203000000000001},"€/MWh =",{"$f":"F86*H86","v":0},"€"]
[null,null,null,null,"March",{"$f":"Data!H63","v":0},"MWh *",{"$f":"H86","v":1.6203000000000001},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Data!H64","v":0},"MWh *",1.6203000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"May",{"$f":"Data!H65","v":0},"MWh *",1.6203000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"Jun",{"$f":"Data!H66","v":0},"MWh *",1.6203000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"July",{"$f":"Data!H67","v":0},"MWh *",1.6203000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"August",{"$f":"Data!H68","v":0},"MWh *",1.6203000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Data!H69","v":0},"MWh *",1.6203000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"October",{"$f":"Data!H70","v":0},"MWh *",1.6203000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Data!H71","v":0},"MWh *",1.6203000000000001,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Data!H72","v":0},"MWh *",1.6203000000000001,"€/MWh =",0,"€"]
[]
[null,null,null,"Total term  for the power reserves and black-start based on offtake :",null,null,null,null,null,{"$f":"SUM(J85:J96)","v":0},"€"]
[]
[null,null,null,"c.2. based on injection :"]
[null,null,null,null,null,"Net injected energy",null,"Tariff",null,"Amount"]
[null,null,null,null,null,{"$f":"Data!F80","v":0},"MWh *",{"$f":"'Results I'!D31","v":1.05},"€/MWh =",{"$f":"F102*H102","v":0},"€"]
[]
[null,null,null,"Total term  for the power reserves and black-start :",null,null,null,null,null,{"$f":"J98+J102","v":0},"€"]
[]
[]
[null,"d) Terms for market integration :"]
[]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff",null,"Amount"]
[null,null,null,null,"January",{"$f":"Data!H61","v":0},"MWh *",{"$f":"'Results I'!D35","v":0.66820000000000002},"€/MWh =",{"$f":"F110*H110","v":0},"€"]
[null,null,null,null,"February",{"$f":"Data!H62","v":0},"MWh *",{"$f":"H110","v":0.66820000000000002},"€/MWh =",{"$f":"F111*H111","v":0},"€"]
[null,null,null,null,"March",{"$f":"Data!H63","v":0},"MWh *",{"$f":"H111","v":0.66820000000000002},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Data!H64","v":0},"MWh *",0.66820000000000002,"€/MWh =",0,"€"]
[null,null,null,null,"May",{"$f":"Data!H65","v":0},"MWh *",0.66820000000000002,"€/MWh =",0,"€"]
[null,null,null,null,"Jun",{"$f":"Data!H66","v":0},"MWh *",0.66820000000000002,"€/MWh =",0,"€"]
[null,null,null,null,"July",{"$f":"Data!H67","v":0},"MWh *",0.66820000000000002,"€/MWh =",0,"€"]
[null,null,null,null,"August",{"$f":"Data!H68","v":0},"MWh *",0.66820000000000002,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Data!H69","v":0},"MWh *",0.66820000000000002,"€/MWh =",0,"€"]
[null,null,null,null,"October",{"$f":"Data!H70","v":0},"MWh *",0.66820000000000002,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Data!H71","v":0},"MWh *",0.66820000000000002,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Data!H72","v":0},"MWh *",0.66820000000000002,"€/MWh =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for market integration :  ",{"$f":"SUM(J110:J121)","v":0},"€"]
[]
[]
[null,"e) Terms for public service obligations :"]
[]
[null,null,"e.1.) Financing the support measures for renewable energy  in Flemish Region"]
[null,null,null,"The determination of the tariff does not depend on the previous year but on the year selected by reference contrary to what is provided for in the tariffs."]
[null,null,null,{"$f":"IF($F$6=\"Flanders\",\"\",\"Not applicable in this region\")","v":"Not applicable in this region"}]
[null,null,null,null,"Range","Net offtaken energy by range",null,"Tariff",null,"Amount",null,null,"Degressivity"]
[null,null,null,null,"0-1000",{"$f":"IF($F$6<>\"Flanders\",\"\",IF(Data!H73<1000,Data!H73,0))","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$39)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",F132*H132*M132)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Flanders\",\"\",1)","v":""}]
[null,null,null,null,"1000-20000",{"$f":"IF($F$6<>\"Flanders\",\"\",IF(AND(1000<=Data!H73,Data!H73<20000),Data!H73,0))","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$39)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",F133*H133*M133)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Flanders\",\"\",0.53)","v":""}]
[null,null,null,null,"20000-100000",{"$f":"IF($F$6<>\"Flanders\",\"\",IF(AND(20000<=Data!H73,Data!H73<100000),Data!H73,0))","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$39)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",F134*H134*M134)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Flanders\",\"\",0.2)","v":""}]
[null,null,null,null,"100000-250000",{"$f":"IF($F$6<>\"Flanders\",\"\",IF(AND(100000<=Data!H73,Data!H73<250000),Data!H73,0))","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$39)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",F135*H135*M135)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Flanders\",\"\",0.2)","v":""}]
[null,null,null,null,">250000",{"$f":"IF($F$6<>\"Flanders\",\"\",IF(250000<=Data!H73,Data!H73,0))","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$39)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",F136*H136*M136)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Flanders\",\"\",0.02)","v":""}]
[]
[null,null,null,null,"Total term for financing the support measures for renewable energy :  ",null,null,null,null,{"$f":"SUM(J132:J136)","v":0},"€"]
[]
[null,null,"e.2.) Financing measures for promotion of rational use of energy  in Flemish Region"]
[null,null,null,{"$f":"IF($F$6=\"Flanders\",\"\",\"Not applicable in this region\")","v":"Not applicable in this region"}]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff",null,"Amount"]
[null,null,null,null,"January",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H61)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",F143*H143)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€\")","v":""}]
[null,null,null,null,"February",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H62)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H63)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H64)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H65)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H66)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H67)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H68)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H69)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H70)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H71)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H72)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$42)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Total term for financing measures for promotion of rational use of energy :  ",{"$f":"SUM(J143:J154)","v":0},"€"]
[]
[null,null,"e.3.) Financing the support measures for renewable energy in Walloon Region"]
[null,null,null,{"$f":"IF($F$6=\"Wallonia\",\"\",\"Not applicable in this region\")","v":"Not applicable in this region"}]
[]
[null,null,null,"e.3.a.) First term"]
[]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff for first term",null,"Amount"]
[null,null,null,null,"January",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H61)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",F164*H164)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€\")","v":""}]
[null,null,null,null,"February",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H62)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",F165*H165)","v":""},""]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H63)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H64)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"","",""]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H65)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"","",""]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H66)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"","",""]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H67)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"","",""]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H68)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H69)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"","",""]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H70)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H71)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H72)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$46)","v":""},"","",""]
[]
[null,null,null,null,"Total term for financing the support measures for renewable energy :  ",null,null,null,null,{"$f":"SUM(J164:J175)","v":0},"€"]
[]
[]
[null,null,null,"The credit of the exemption of the first component and the invoicing of the second component are made on a quarterly basis of a file received by the SPW"]
[null,null,null,"on the basis of the offtake and tariff defined by the SPW."]
[null,null,null,"The principles are described in the guidelines published by the SPW."]
[null,null,null,"For more information, visit https://www.elia.be/fr/clients/certificats-verts-et-surcharges/wallonie-exemptions-partielles#Partial exemptions. (n French)"]
[null,null,null,"The calculation below is purely indicative on the basis of the volume of offtake and on the basis of the tariff of the first component."]
[]
[null,null,null,"e.3.b.) Exemption of the first component"]
[]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff for first term",null,"Amount",null,null,"Exoneration"]
[null,null,null,null,"January",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H61)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",F189*H189)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Wallonia\",\"\",IF($F$8=\"No\",0,IF($F$9=\"Yes\",0.85,IF($F$10=\"Other\",0,IF($F$10=\"Culture and animal production (01)\",0.5,IF(Data!H73>1000,0.5,0))))))","v":""}]
[null,null,null,null,"February",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H62)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H63)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H64)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H65)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H66)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H67)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H68)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H69)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H70)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H71)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H72)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$189)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Total exemption :  ",{"$f":"SUM(J189:J200)","v":0},"€"]
[]
[null,null,null,"e.3.c.) Second component"]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff for second term",null,"Amount"]
[null,null,null,null,"January",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H61)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",F206*H206*$M$189)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€\")","v":""}]
[null,null,null,null,"February",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H62)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H63)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H64)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H65)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H66)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H67)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H68)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H69)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H70)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H71)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H72)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$E$46)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Total second component renewable energy support measures :  ",{"$f":"SUM(J206:J217)","v":0},"€"]
[]
[null,null,null,null,"Total first-component exemption and second-component billing for renewable energy support measures :  ",null,null,null,null,{"$f":"J202+J219","v":0},"€"]
[]
[null,null,"e.4.) Financing the support measures for renewable energy in Brussels"]
[null,null,null,{"$f":"IF($F$6=\"Brussels\",\"\",\"Not applicable in this region\")","v":""}]
[]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff for first term",null,"Amount"]
[null,null,null,null,"January",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H61)","v":0},{"$f":"IF($F$6<>\"Brussels\",\"\",\"MWh *\")","v":"MWh *"},{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},{"$f":"IF($F$6<>\"Brussels\",\"\",\"€/MWh =\")","v":"€/MWh ="},{"$f":"IF($F$6<>\"Brussels\",\"\",F227*H227)","v":0},{"$f":"IF($F$6<>\"Brussels\",\"\",\"€\")","v":"€"}]
[null,null,null,null,"February",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H62)","v":0},{"$f":"IF($F$6<>\"Brussels\",\"\",\"MWh *\")","v":"MWh *"},{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},{"$f":"IF($F$6<>\"Brussels\",\"\",\"€/MWh =\")","v":"€/MWh ="},{"$f":"IF($F$6<>\"Brussels\",\"\",F228*H228)","v":0},{"$f":"IF($F$6<>\"Brussels\",\"\",\"€\")","v":"€"}]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H63)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H64)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H65)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H66)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H67)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H68)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H69)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H70)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H71)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H72)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$49)","v":0.59489999999999998},"€/MWh =",0,"€"]
[]
[null,null,null,null,"Total term for financing the support measures for renewable energy :  ",null,null,null,null,{"$f":"SUM(J227:J238)","v":0},"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for public service obligations :  ",{"$f":"J138+J156+J177+J240","v":0},"€"]
[]
[]
[null,"f) Taxes and levies :"]
[]
[null,null,"f.1.) Occupying public domain in Walloon Region"]
[null,null,null,{"$f":"IF($F$6=\"Wallonia\",\"\",\"Not applicable in this region\")","v":"Not applicable in this region"}]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff",null,"Amount"]
[null,null,null,null,"January",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H61)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",F250*H250)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€\")","v":""}]
[null,null,null,null,"February",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H62)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H63)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H64)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H65)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H66)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H67)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H68)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H69)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H70)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H71)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H72)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$53)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Total term for occupying public domain in Walloon Region :  ",{"$f":"SUM(J250:J261)","v":0},"€"]
[]
[]
[null,null,"f.2.) Occupying road network in Brussels Region"]
[null,null,null,{"$f":"IF($F$6=\"Brussels\",\"\",\"Not applicable in this region\")","v":""}]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff",null,"Amount"]
[null,null,null,null,"January",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H61)","v":0},{"$f":"IF($F$6<>\"Brussels\",\"\",\"MWh *\")","v":"MWh *"},{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},{"$f":"IF($F$6<>\"Brussels\",\"\",\"€/MWh =\")","v":"€/MWh ="},{"$f":"IF($F$6<>\"Brussels\",\"\",F269*H269)","v":0},{"$f":"IF($F$6<>\"Brussels\",\"\",\"€\")","v":"€"}]
[null,null,null,null,"February",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H62)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H63)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H64)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H65)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H66)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H67)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H68)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H69)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H70)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H71)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Brussels\",\"\",Data!H72)","v":0},"MWh *",{"$f":"IF($F$6<>\"Brussels\",\"\",'Results I'!$D$56)","v":4.1778000000000004},"€/MWh =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for occupying road network :  ",{"$f":"SUM(J269:J280)","v":0},"€"]
[]
[]
[null,null,"f.3.) Levie for the taxes \"pylons\" et \"trenches\" in Flemish region"]
[null,null,null,{"$f":"IF($F$6=\"Flanders\",\"\",\"Not applicable in this region\")","v":"Not applicable in this region"}]
[null,null,null,null,null,"Net offtaken energy",null,"Tariff",null,"Amount"]
[null,null,null,null,"January",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H61)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",F288*H288)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€\")","v":""}]
[null,null,null,null,"February",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H62)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H63)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H64)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H65)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H66)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H67)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H68)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H69)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H70)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H71)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H72)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$59)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Total term for levie for the taxes \"pylons\" et \"trenches\" :  ",{"$f":"SUM(J288:J299)","v":0},"€"]
[]
[null,null,null,null,null,null,null,null,"Total for taxes and levies :  ",{"$f":"J263+J282+J301","v":0},"€"]
[]
[]
[]
[null,"Yearly total (except public service obligations & taxes and levies) :  ",null,null,null,null,null,null,null,{"$f":"J59+J78+J104+J123","v":0},"€"]
[]
[null,"Total for public service obligations  & taxes and levies :  ",null,null,null,null,null,null,null,{"$f":"J242+J303","v":0},"€"]
[]
[null,"Annual total (with public service obligations & taxes and surcharges excluding first-component exemption and second-component billing for renewable energy support measures (Wallonia)):",null,null,null,null,null,null,null,{"$f":"J307+J309","v":0},"€"]
[]
[]
[]
[null,"Total first-component exemption and second-component billing for renewable energy support measures (Wallonia):",null,null,null,null,null,null,null,{"$f":"$J$221","v":0},"€"]
[]
[null,"Annual total (with public service obligations & taxes and surcharges including first-component exemption and second-component billing for renewable energy support measures (Wallonia)):",null,null,null,null,null,null,null,{"$f":"$J$311+J315","v":0},"€"]

{"sheet":"Tariffs","index":4,"n_rows":108,"n_cols":7,"rows_kept":108,"cut":false,"hidden":false,"merged":[[17,3,17,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[15,3,15,4],[16,3,16,4],[32,3,32,4],[105,3,105,4],[106,3,106,4],[107,3,107,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[31,3,31,4],[33,3,33,4],[40,3,40,4],[41,3,41,4],[46,3,46,4],[47,3,47,4],[53,3,53,4],[54,3,54,4],[42,3,42,4],[48,3,48,4],[55,3,55,4],[70,3,70,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[69,3,69,4],[71,3,71,4],[77,3,77,4],[78,3,78,4],[93,3,93,4],[98,3,98,4],[100,3,100,4],[79,3,79,4],[91,3,91,4],[92,3,92,4],[99,3,99,4],[83,3,83,4],[84,3,84,4],[85,3,85,4]]}
[]
[null,"TARIFFS"]
[]
[]
[null,"A. Tariffs for the management and the development of the grid infrastructure "]
[]
[null,null,"1. Tariffs for the monthly peak"]
[null,null,null,null,null,"€/kW net offtaken by month"]
[null,null,null,"On the 380/220/150 kV network",null,0.5292]
[null,null,null,"On the 70/36/30 kV network",null,0.77300000000000002]
[null,null,null,"At transformer output to medium voltage",null,1.0275000000000001]
[]
[]
[null,null,"2. Tariffs for the yearly peak"]
[null,null,null,null,null,"€/kW net offtaken by year"]
[null,null,null,"On the 380/220/150 kV network",null,12.9893]
[null,null,null,"On the 70/36/30 kV network",null,18.755500000000001]
[null,null,null,"At transformer output to medium voltage",null,24.6648]
[]
[]
[null,null,"3. Tariffs for the power put at disposal"]
[null,null,null,null,null,"Principal AP","Additional AP"]
[null,null,null,null,null,"€/kVA at offtake by year","€/kVA at offtake by year"]
[null,null,null,"On the 380/220/150 kV network",null,10.0215,2.0043000000000002]
[null,null,null,"On the 70/36/30 kV network",null,17.381799999999998,3.4763999999999999]
[null,null,null,"At transformer output to medium voltage",null,31.0837,6.2167000000000003]
[]
[]
[null,"B. Tariffs for the management fo the electric system"]
[]
[null,null,null,null,null,"€/MWh net offtaken"]
[null,null,null,"On the 380/220/150 kV network",null,2.7263999999999999]
[null,null,null,"On the 70/36/30 kV network",null,4.1341000000000001]
[null,null,null,"At transformer output to medium voltage",null,7.2319000000000004]
[]
[]
[null,"C. Tariffs for the power reserves and black-start"]
[]
[null,null,"1. based on offtake"]
[null,null,null,null,null,"€/MWh net offtaken"]
[null,null,null,"On the 380/220/150 kV network",null,1.6203000000000001]
[null,null,null,"On the 70/36/30 kV network",null,1.6203000000000001]
[null,null,null,"At transformer output to medium voltage",null,1.6203000000000001]
[]
[null,null,"2. based on injection"]
[null,null,null,null,null,"€/MWh net injected"]
[null,null,null,"On the 380/220/150 kV network",null,1.05]
[null,null,null,"On the 70/36/30 kV network",null,1.05]
[null,null,null,"At transformer output to medium voltage",null,1.05]
[]
[]
[null,"D. Tariffs for market integration"]
[null,null,null,null,null,"€/MWh net offtaken"]
[null,null,null,"On the 380/220/150 kV network",null,0.66820000000000002]
[null,null,null,"On the 70/36/30 kV network",null,0.66820000000000002]
[null,null,null,"At transformer output to medium voltage",null,0.66820000000000002]
[]
[]
[null,"E. Tariffs for public service obligations"]
[]
[null,null,"1. Tariffs for financing the support measures for renewable energy  in Flemish Region"]
[null,null,null,null,null,"€/MWh net offtaken"]
[null,null,null,"On the 380/220/150 kV network",null,0]
[null,null,null,"On the 70/36/30 kV network",null,0.37219999999999998]
[null,null,null,"At transformer output to medium voltage",null,0.37219999999999998]
[]
[]
[null,null,"2. Tariffs for financing measures for promotion of rational use of energy  in Flemish Region"]
[null,null,null,null,null,"€/MWh net offtaken"]
[null,null,null,"On the 380/220/150 kV network",null,0]
[null,null,null,"On the 70/36/30 kV network",null,4.2999999999999997E-2]
[null,null,null,"At transformer output to medium voltage",null,4.2999999999999997E-2]
[]
[]
[null,null,"3. Tariffs  for financing the support measures for renewable energy in Walloon Region"]
[null,null,null,null,null,"First term","Second term"]
[null,null,null,null,null,"€/MWh net offtaken","€/MWh exempted"]
[null,null,null,"On the 380/220/150 kV network",null,0,0]
[null,null,null,"On the 70/36/30 kV network",null,5.9249000000000001,0]
[null,null,null,"At transformer output to medium voltage",null,5.9249000000000001,0]
[]
[null,null,"4. Tariffs  for financing the support measures for renewable energy in Brussels"]
[null,null,null,null,null,"€/MWh net offtaken"]
[null,null,null,"On the 380/220/150 kV network",null,0]
[null,null,null,"On the 70/36/30 kV network",null,0.59489999999999998]
[null,null,null,"At transformer output to medium voltage",null,0.59489999999999998]
[]
[null,"F. Taxes and levies"]
[]
[null,null,"1. Occupying public domain in Walloon Region"]
[null,null,null,null,null,"€/MWh net offtaken"]
[null,null,null,"On the 380/220/150 kV network",null,0]
[null,null,null,"On the 70/36/30 kV network",null,0.39800000000000002]
[null,null,null,"At transformer output to medium voltage",null,0.39800000000000002]
[]
[]
[null,null,"2. Occupying road network in Brussels Region"]
[null,null,null,null,null,"€/MWh net offtaken"]
[null,null,null,"On the 380/220/150 kV network",null,4.1778000000000004]
[null,null,null,"On the 70/36/30 kV network",null,4.1778000000000004]
[null,null,null,"At transformer output to medium voltage",null,0]
[]
[]
[null,null,"3. Levie for the taxes \"pylons\" et \"trenches\" in Flemish region"]
[null,null,null,null,null,"€/MWh net offtaken"]
[null,null,null,"On the 380/220/150 kV network",null,0.54290000000000005]
[null,null,null,"On the 70/36/30 kV network",null,0.54290000000000005]
[null,null,null,"At transformer output to medium voltage",null,0.54290000000000005]