{"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":4,"defined_names":101,"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 2023 to the 31st of December 2023."]
[]
[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":92,"n_cols":10,"rows_kept":92,"cut":false,"hidden":false,"merged":[[11,5,11,7],[86,5,86,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 380/220/150 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,"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":56,"n_cols":5,"rows_kept":56,"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 380/220/150 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.2099}]
[]
[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":5.2957999999999998}]
[]
[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":4.5060000000000002}]
[]
[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":0.91949999999999998}]
[]
[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":0.84279999999999999}]
[]
[null,null,null,"€/MWh net injected"]
[null,null,"2. based on injection",{"$f":"VLOOKUP($C$5,Tariffs!D47:F49,3,FALSE)","v":0.6169}]
[]
[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.37059999999999998}]
[]
[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,"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!D86:F88,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!D93:F95,3,FALSE),0)","v":4.0837000000000003}]
[]
[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!D100:F102,3,FALSE),0)","v":0}]

{"sheet":"Results II","index":3,"n_rows":298,"n_cols":13,"rows_kept":298,"cut":false,"hidden":false,"merged":[[295,1,295,8],[297,1,297,8],[96,3,96,8],[102,3,102,8],[291,1,291,8],[136,4,136,8],[175,4,175,8],[287,1,287,8],[289,1,289,8],[222,4,222,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 380/220/150 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,"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.2099},"€/kW =",{"$f":"F18*H18*1000","v":0},"€"]
[null,null,null,null,"February",{"$f":"Data!F26","v":0},"MW *",{"$f":"H18","v":0.2099},"€/kW =",{"$f":"F19*H19*1000","v":0},"€"]
[null,null,null,null,"March",{"$f":"Data!F27","v":0},"MW *",{"$f":"H19","v":0.2099},"€/kW =",0,"€"]
[null,null,null,null,"April",{"$f":"Data!F28","v":0},"MW *",0.2099,"€/kW =",0,"€"]
[null,null,null,null,"May",{"$f":"Data!F29","v":0},"MW *",0.2099,"€/kW =",0,"€"]
[null,null,null,null,"Jun",{"$f":"Data!F30","v":0},"MW *",0.2099,"€/kW =",0,"€"]
[null,null,null,null,"July",{"$f":"Data!F31","v":0},"MW *",0.2099,"€/kW =",0,"€"]
[null,null,null,null,"August",{"$f":"Data!F32","v":0},"MW *",0.2099,"€/kW =",0,"€"]
[null,null,null,null,"September",{"$f":"Data!F33","v":0},"MW *",0.2099,"€/kW =",0,"€"]
[null,null,null,null,"October",{"$f":"Data!F34","v":0},"MW *",0.2099,"€/kW =",0,"€"]
[null,null,null,null,"November",{"$f":"Data!F35","v":0},"MW *",0.2099,"€/kW =",0,"€"]
[null,null,null,null,"December",{"$f":"Data!F36","v":0},"MW *",0.2099,"€/kW =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for the monthly peak :  ",{"$f":"SUM(J18:J29)","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":0.44131666666666663},"€/kW =",{"$f":"F37*H37*1000","v":0},"€"]
[null,null,null,null,"February",{"$f":"Data!I26","v":0},"MW *",{"$f":"H37","v":0.44131666666666663},"€/kW =",0,"€"]
[null,null,null,null,"March",{"$f":"Data!I27","v":0},"MW *",{"$f":"H38","v":0.44131666666666663},"€/kW =",0,"€"]
[null,null,null,null,"April",{"$f":"Data!I28","v":0},"MW *",0.44131666666666663,"€/kW =",0,"€"]
[null,null,null,null,"May",{"$f":"Data!I29","v":0},"MW *",0.44131666666666663,"€/kW =",0,"€"]
[null,null,null,null,"Jun",{"$f":"Data!I30","v":0},"MW *",0.44131666666666663,"€/kW =",0,"€"]
[null,null,null,null,"July",{"$f":"Data!I31","v":0},"MW *",0.44131666666666663,"€/kW =",0,"€"]
[null,null,null,null,"August",{"$f":"Data!I32","v":0},"MW *",0.44131666666666663,"€/kW =",0,"€"]
[null,null,null,null,"September",{"$f":"Data!I33","v":0},"MW *",0.44131666666666663,"€/kW =",0,"€"]
[null,null,null,null,"October",{"$f":"Data!I34","v":0},"MW *",0.44131666666666663,"€/kW =",0,"€"]
[null,null,null,null,"November",{"$f":"Data!I35","v":0},"MW *",0.44131666666666663,"€/kW =",0,"€"]
[null,null,null,null,"December",{"$f":"Data!I36","v":0},"MW *",0.44131666666666663,"€/kW =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for the yearly peak :  ",{"$f":"SUM(J37:J48)","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":4.5060000000000002},"€/kVA",{"$f":"F56*H56*1000","v":0},"€"]
[]
[null,null,null,null,null,null,null,null,"Total term  for the management and the development of the grid infrastructure  :",{"$f":"J31+J50+J56","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":0.91949999999999998},"€/MWh =",{"$f":"F64*H64","v":0},"€"]
[null,null,null,null,"February",{"$f":"Data!H62","v":0},"MWh *",{"$f":"H64","v":0.91949999999999998},"€/MWh =",{"$f":"F65*H65","v":0},"€"]
[null,null,null,null,"March",{"$f":"Data!H63","v":0},"MWh *",{"$f":"H65","v":0.91949999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Data!H64","v":0},"MWh *",0.91949999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"May",{"$f":"Data!H65","v":0},"MWh *",0.91949999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"Jun",{"$f":"Data!H66","v":0},"MWh *",0.91949999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"July",{"$f":"Data!H67","v":0},"MWh *",0.91949999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"August",{"$f":"Data!H68","v":0},"MWh *",0.91949999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Data!H69","v":0},"MWh *",0.91949999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"October",{"$f":"Data!H70","v":0},"MWh *",0.91949999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Data!H71","v":0},"MWh *",0.91949999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Data!H72","v":0},"MWh *",0.91949999999999998,"€/MWh =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for the management fo the electric system :  ",{"$f":"SUM(J64:J75)","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":0.84279999999999999},"€/MWh =",{"$f":"F84*H84","v":0},"€"]
[null,null,null,null,"February",{"$f":"Data!H62","v":0},"MWh *",{"$f":"H84","v":0.84279999999999999},"€/MWh =",{"$f":"F85*H85","v":0},"€"]
[null,null,null,null,"March",{"$f":"Data!H63","v":0},"MWh *",{"$f":"H85","v":0.84279999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Data!H64","v":0},"MWh *",0.84279999999999999,"€/MWh =",0,"€"]
[null,null,null,null,"May",{"$f":"Data!H65","v":0},"MWh *",0.84279999999999999,"€/MWh =",0,"€"]
[null,null,null,null,"Jun",{"$f":"Data!H66","v":0},"MWh *",0.84279999999999999,"€/MWh =",0,"€"]
[null,null,null,null,"July",{"$f":"Data!H67","v":0},"MWh *",0.84279999999999999,"€/MWh =",0,"€"]
[null,null,null,null,"August",{"$f":"Data!H68","v":0},"MWh *",0.84279999999999999,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Data!H69","v":0},"MWh *",0.84279999999999999,"€/MWh =",0,"€"]
[null,null,null,null,"October",{"$f":"Data!H70","v":0},"MWh *",0.84279999999999999,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Data!H71","v":0},"MWh *",0.84279999999999999,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Data!H72","v":0},"MWh *",0.84279999999999999,"€/MWh =",0,"€"]
[]
[null,null,null,"Total term  for the power reserves and black-start based on offtake :",null,null,null,null,null,{"$f":"SUM(J84:J95)","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":0.6169},"€/MWh =",{"$f":"F101*H101","v":0},"€"]
[]
[null,null,null,"Total term  for the power reserves and black-start :",null,null,null,null,null,{"$f":"J97+J101","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.37059999999999998},"€/MWh =",{"$f":"F109*H109","v":0},"€"]
[null,null,null,null,"February",{"$f":"Data!H62","v":0},"MWh *",{"$f":"H109","v":0.37059999999999998},"€/MWh =",{"$f":"F110*H110","v":0},"€"]
[null,null,null,null,"March",{"$f":"Data!H63","v":0},"MWh *",{"$f":"H110","v":0.37059999999999998},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Data!H64","v":0},"MWh *",0.37059999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"May",{"$f":"Data!H65","v":0},"MWh *",0.37059999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"Jun",{"$f":"Data!H66","v":0},"MWh *",0.37059999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"July",{"$f":"Data!H67","v":0},"MWh *",0.37059999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"August",{"$f":"Data!H68","v":0},"MWh *",0.37059999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Data!H69","v":0},"MWh *",0.37059999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"October",{"$f":"Data!H70","v":0},"MWh *",0.37059999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Data!H71","v":0},"MWh *",0.37059999999999998,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Data!H72","v":0},"MWh *",0.37059999999999998,"€/MWh =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for market integration :  ",{"$f":"SUM(J109:J120)","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\",\"\",F131*H131*M131)","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\",\"\",F132*H132*M132)","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\",\"\",F133*H133*M133)","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\",\"\",F134*H134*M134)","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\",\"\",F135*H135*M135)","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(J131:J135)","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\",\"\",F142*H142)","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(J142:J153)","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\",\"\",F163*H163)","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\",\"\",F164*H164)","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(J163:J174)","v":0},"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for public service obligations :  ",{"$f":"J137+J155+J176","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$191)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",F191*H191)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Wallonia\",\"\",IF($F$8=\"No\",0,IF(#REF!=\"Yes\",0.85,IF($F$9=\"Other\",0,IF($F$9=\"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$191)","v":""},"","",""]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H63)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$191)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H64)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$191)","v":""},"","",""]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H65)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$191)","v":""},"","",""]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H66)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$191)","v":""},"","",""]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H67)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$191)","v":""},"","",""]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H68)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$191)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H69)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$191)","v":""},"","",""]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H70)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$191)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H71)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$191)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H72)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",-'Results I'!$D$46*$M$191)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Total exemption :  ",{"$f":"SUM(J191:J202)","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\",\"\",F208*H208*$M$191)","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(J208:J219)","v":0},"€"]
[]
[null,null,null,null,"Total first-component exemption and second-component billing for renewable energy support measures :  ",null,null,null,null,{"$f":"J204+J221","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$50)","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Wallonia\",\"\",F231*H231)","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$50)","v":""},"","",""]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H63)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$50)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H64)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$50)","v":""},"","",""]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H65)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$50)","v":""},"","",""]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H66)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$50)","v":""},"","",""]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H67)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$50)","v":""},"","",""]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H68)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$50)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H69)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$50)","v":""},"","",""]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H70)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$50)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H71)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$50)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Wallonia\",\"\",Data!H72)","v":""},"",{"$f":"IF($F$6<>\"Wallonia\",\"\",'Results I'!$D$50)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Total term for occupying public domain in Walloon Region :  ",{"$f":"SUM(J231:J242)","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$53)","v":4.0837000000000003},{"$f":"IF($F$6<>\"Brussels\",\"\",\"€/MWh =\")","v":"€/MWh ="},{"$f":"IF($F$6<>\"Brussels\",\"\",F250*H250)","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$53)","v":4.0837000000000003},"€/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$53)","v":4.0837000000000003},"€/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$53)","v":4.0837000000000003},"€/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$53)","v":4.0837000000000003},"€/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$53)","v":4.0837000000000003},"€/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$53)","v":4.0837000000000003},"€/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$53)","v":4.0837000000000003},"€/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$53)","v":4.0837000000000003},"€/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$53)","v":4.0837000000000003},"€/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$53)","v":4.0837000000000003},"€/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$53)","v":4.0837000000000003},"€/MWh =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Total term for occupying road network :  ",{"$f":"SUM(J250:J261)","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$56)","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Flanders\",\"\",F269*H269)","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$56)","v":""},"","",""]
[null,null,null,null,"March",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H63)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$56)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H64)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$56)","v":""},"","",""]
[null,null,null,null,"May",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H65)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$56)","v":""},"","",""]
[null,null,null,null,"Jun",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H66)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$56)","v":""},"","",""]
[null,null,null,null,"July",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H67)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$56)","v":""},"","",""]
[null,null,null,null,"August",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H68)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$56)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H69)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$56)","v":""},"","",""]
[null,null,null,null,"October",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H70)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$56)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H71)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$56)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Flanders\",\"\",Data!H72)","v":""},"",{"$f":"IF($F$6<>\"Flanders\",\"\",'Results I'!$D$56)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Total term for levie for the taxes \"pylons\" et \"trenches\" :  ",{"$f":"SUM(J269:J280)","v":0},"€"]
[]
[null,null,null,null,null,null,null,null,"Total for taxes and levies :  ",{"$f":"J244+J263+J282","v":0},"€"]
[]
[]
[]
[null,"Yearly total (except public service obligations & taxes and levies) :  ",null,null,null,null,null,null,null,{"$f":"J58+J77+J103+J122","v":0},"€"]
[]
[null,"Total for public service obligations  & taxes and levies :  ",null,null,null,null,null,null,null,{"$f":"J178+J284","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":"J288+J290","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$223","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$292+J296","v":0},"€"]

{"sheet":"Tariffs","index":4,"n_rows":102,"n_cols":7,"rows_kept":102,"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],[99,3,99,4],[100,3,100,4],[101,3,101,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],[87,3,87,4],[92,3,92,4],[94,3,94,4],[79,3,79,4],[85,3,85,4],[86,3,86,4],[93,3,93,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.2099]
[null,null,null,"On the 70/36/30 kV network",null,0.38690000000000002]
[null,null,null,"At transformer output to medium voltage",null,0.56979999999999997]
[]
[]
[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,5.2957999999999998]
[null,null,null,"On the 70/36/30 kV network",null,9.6423000000000005]
[null,null,null,"At transformer output to medium voltage",null,14.0387]
[]
[]
[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,4.5060000000000002,0.9012]
[null,null,null,"On the 70/36/30 kV network",null,8.6494999999999997,1.7299]
[null,null,null,"At transformer output to medium voltage",null,15.9436,3.1886999999999999]
[]
[]
[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,0.91949999999999998]
[null,null,null,"On the 70/36/30 kV network",null,1.4444999999999999]
[null,null,null,"At transformer output to medium voltage",null,2.2717000000000001]
[]
[]
[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,0.84279999999999999]
[null,null,null,"On the 70/36/30 kV network",null,0.84279999999999999]
[null,null,null,"At transformer output to medium voltage",null,0.84279999999999999]
[]
[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,0.6169]
[null,null,null,"On the 70/36/30 kV network",null,0.6169]
[null,null,null,"At transformer output to medium voltage",null,0.6169]
[]
[]
[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.37059999999999998]
[null,null,null,"On the 70/36/30 kV network",null,0.37059999999999998]
[null,null,null,"At transformer output to medium voltage",null,0.37059999999999998]
[]
[]
[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,1.4655]
[null,null,null,"At transformer output to medium voltage",null,1.4655]
[]
[]
[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,3.9199999999999999E-2]
[null,null,null,"At transformer output to medium voltage",null,3.9199999999999999E-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,10.376099999999999,0]
[null,null,null,"At transformer output to medium voltage",null,10.376099999999999,0]
[]
[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.40179999999999999]
[null,null,null,"At transformer output to medium voltage",null,0.40179999999999999]
[]
[]
[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.0837000000000003]
[null,null,null,"On the 70/36/30 kV network",null,4.0837000000000003]
[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.41620000000000001]
[null,null,null,"On the 70/36/30 kV network",null,0.41620000000000001]
[null,null,null,"At transformer output to medium voltage",null,0.41620000000000001]