{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Inleiding","Gegevens","Resultaten I","Resultaten II","Tarieven"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":66,"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":"Inleiding","index":0,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,"Voor het optimale werking van dit bestand, gelieve het eerst te downloaden alvorens gebruik."]
[]
[null,null,null,"Deze simulator heeft tot doel bijkomende informatie te verschaffen aan de marktspelers met betrekking"]
[null,null,null,"tot de toepassingsmodaliteiten van de tarieven voor toegang tot het net (*), de tarieven voor "]
[null,null,null,"openbare dienstverplichtingen en de toeslagen. Wat niet beoogd wordt met dit programma: "]
[null,null,null,"de aansluitingstarieven en de tarieven voor compensatie van kwartier-onevenwichten."]
[]
[null,null,null,"Het simulatie-programma illustreert de berekening van de bedragen met betrekking tot de toegang tot"]
[null,null,null,"het Elia-net door netgebruikers die hierop aangesloten zijn. Het houdt bovendien rekening met de regio"]
[null,null,null,"waarbinnen het betrokken toegangspunt gesitueerd is, het infrastructuurniveau en het type toegangspunt."]
[]
[null,null,null,"De tarieven zijn van toepassing van 1 januari 2021 tot 31 december 2021."]
[]
[null,null,null,"De simulatie kan gehanteerd worden voor netgebruikers die direct aangesloten zijn op het Elia-net,"]
[null,null,null,"met of zonder lokale productie in hetzelfde toegangspunt.  De simulatie is niet bedoeld voor distributienetbeheerders."]
[]
[null,null,null,"De simulatie is niet bedoeld voor offshore toegangspunten die zijn aangesloten op de MOG en toegangspunten uit het GD Luxemburg. Neem contact op met uw KAM als u een simulatie voor deze toegangspunten wilt ontvangen."]
[]
[null,null,null,"Voor het bekomen van een simulatie dienen vooreerst de profielkarakteristieken van de toegang ingevoerd"]
[null,null,null,"te worden in het blad “Gegevens”. De resultaten kunnen vervolgens bekeken worden op het blad"]
[null,null,null,"“Resultaten I” (tarieven van toepassing op het betrokken toegangspunt) en “Resultaten II” (bedragen met"]
[null,null,null,"betrekking tot de termen voor toegang tot het net, de openbare dienstverplichtingen en de toeslagen voor "]
[null,null,null,"het betrokken toegangspunt)."]
[]
[]
[null,null,null,"(*)   Buiten het tarief voor bijkomende levering van reactieve energie en het tarief voor eventuele"]
[null,null,null,"overschrijding van het ter beschikking gestelde vermogen."]
[]
[]
[null,null,null,"Disclaimer :"]
[]
[null,null,null,"Het hierboven weergegeven hulpmiddel en de daarin vervatte informatie en tarieven worden enkel "]
[null,null,null,"meegedeeld voor informatieve doeleinden en beogen de berekening van de kostprijs voor toegang tot het"]
[null,null,null,"net voor een gegeven toegangspunt voor een netgebruiker te vergemakkelijken. Echter, noch de"]
[null,null,null,"opgegeven informatie en tarieven noch de berekende resultaten zijn van contractuele aard. Zij vormen"]
[null,null,null,"geen aanbod tot het sluiten van een contract en kunnen Elia niet binden noch van Elia worden"]
[null,null,null,"afgedwongen. "]
[]
[null,null,null,"ELIA verstrekt geen enkele garantie over het adequaat karakter, de accuraatheid, de volledigheid en de"]
[null,null,null,"correctheid van de verschafte en/of de berekende informatie noch over de geldigheidsduur van de"]
[null,null,null,"weergeven tarieven. ELIA zal dan ook niet aansprakelijk zijn voor de gevolgen voortvloeiend uit het"]
[null,null,null,"eventueel niet volledig of correct zijn of het up to date zijn van de verschafte informatie en de tarieven."]

{"sheet":"Gegevens","index":1,"n_rows":97,"n_cols":10,"rows_kept":97,"cut":false,"hidden":false,"merged":[[91,6,91,8],[72,8,72,10],[66,8,66,10],[67,8,67,10],[68,8,68,10],[69,8,69,10],[70,8,70,10],[71,8,71,10],[65,8,65,10],[47,6,47,10],[64,8,64,10],[7,10,9,10],[61,8,61,10],[62,8,62,10],[63,8,63,10],[13,7,13,10],[25,9,25,11],[26,9,26,11],[27,9,27,11],[35,9,35,11],[36,9,36,11],[9,5,9,9],[11,5,11,6],[13,5,13,6]]}
[]
[]
[null,null,"  Gegevens in te vullen door de gebruiker"]
[]
[null,null,null,"1. Karakteristieken van het toegangspunt"]
[]
[null,null,null,null,"Vul hierna het infrastructuurniveau, de regio en het type toegangspunt in."]
[]
[]
[null,null,null,null,"Infrastructuurniveau :","In 380/220/150 kV-netten"]
[]
[null,null,null,null,"Regio :  ","Het Brussels Gewest"]
[]
[null,null,null,null,"Type toegangspunt :","Hoofdtoegangspunt"]
[]
[null,null,null,"2. Netto afgename piek (in MW)"]
[]
[null,null,null,null,"Vul hierna de pieken voor afname in per maand (kolom A)."]
[null,null,null,null,"Vul eveneens de pieken voor afname in tijdens de uren 17 tot 20, buiten weekend en feestdagen, "]
[null,null,null,null,"enkel voor de maanden januari tot maart en november tot december (kolom B)."]
[]
[null,null,null,null,"N.B. : Per maand is de waarde in kolom B minstens gelijk aan de waarde in kolom A voor het jaar 2020."]
[]
[]
[null,null,null,null,null,"A\n(jaar 2020)","B\n(jaar 2019)","B\n(jaar 2020)","Jaarpiek"]
[null,null,null,null,"Januari",null,null,null,{"$f":"MAX($G$27:$G$37,H26)","v":0},{"$f":"IF(H26>F26,\"Combinatie pieken A en B NOK\",\"\")","v":""}]
[null,null,null,null,"Februari",null,null,null,{"$f":"MAX($G28:$G$37,H$26:H27)","v":0},{"$f":"IF(H27>F27,\"Combinatie pieken A en B NOK\",\"\")","v":""}]
[null,null,null,null,"Maart",null,null,null,{"$f":"MAX($G29:$G$37,H$26:H28)","v":0},{"$f":"IF(H28>F28,\"Combinatie pieken A en B NOK\",\"\")","v":""}]
[null,null,null,null,"April",null,null,null,{"$f":"MAX($G30:$G$37,H$26:H29)","v":0}]
[null,null,null,null,"Mei",null,null,null,{"$f":"MAX($G31:$G$37,H$26:H30)","v":0}]
[null,null,null,null,"Juni",null,null,null,{"$f":"MAX($G32:$G$37,H$26:H31)","v":0}]
[null,null,null,null,"Juli",null,null,null,{"$f":"MAX($G33:$G$37,H$26:H32)","v":0}]
[null,null,null,null,"Augustus",null,null,null,{"$f":"MAX($G34:$G$37,H$26:H33)","v":0}]
[null,null,null,null,"September",null,null,null,{"$f":"MAX($G35:$G$37,H$26:H34)","v":0}]
[null,null,null,null,"Oktober",null,null,null,{"$f":"MAX($G36:$G$37,H$26:H35)","v":0}]
[null,null,null,null,"November",null,null,null,{"$f":"MAX($G37:$G$37,H$26:H36)","v":0},{"$f":"IF(H36>F36,\"Combinatie pieken A en B NOK\",\"\")","v":""}]
[null,null,null,null,"December",null,null,null,{"$f":"MAX(H$26:H37)","v":0},{"$f":"IF(H37>F37,\"Combinatie pieken A en B NOK\",\"\")","v":""}]
[]
[]
[null,null,null,"3. Ter beschikking gestelde vermogen (in MVA)"]
[]
[null,null,null,null,"Vul hierna het ter beschikking gestelde vermogen bij afname in."]
[]
[null,null,null,null,"N.B. : Het ter beschikking gestelde vermogen moet minstens gelijk zijn aan het maximum van de afgenomen"]
[null,null,null,null,"         piek van het jaar. Het ter beschikking gestelde vermogen moet rekening houden met het vermogen van de "]
[null,null,null,null,"         achterliggende installaties."]
[]
[null,null,null,null,null,null,{"$f":"IF(F48<MAX(F26:F37),\"        Fout: lager dan de maximale piek 2019\",\"\")","v":""}]
[]
[]
[null,null,null,"4. Netto afgenomen energie (in MWh)"]
[]
[null,null,null,null,"Vul hierna de netto afgenomen energie in per maand."]
[]
[null,null,null,null,"Indien u wenst, kunt u een gebruiks-% inbrengen voor de automatische berekening van de maandelijkse energie"]
[null,null,null,null,"op basis van de netto afgenomen pieken hierboven ingevuld en vervolgens op de knop klikken."]
[]
[null,null,null,null,null,1]
[]
[]
[null,null,null,null,null,"Aantal uren per maand","Maximale maandelijkse energie","Afgenomen energie"]
[null,null,null,null,"Januari",744,{"$f":"F26*F62","v":0},null,{"$f":"IF(H62>G62,\"Energie en piek onverenigbaar\",\"\")","v":""}]
[null,null,null,null,"Februari",696,0,null,{"$f":"IF(H63>G63,\"Energie en piek onverenigbaar\",\"\")","v":""}]
[null,null,null,null,"Maart",743,0,null,""]
[null,null,null,null,"April",720,0,null,""]
[null,null,null,null,"Mei",744,0,null,""]
[null,null,null,null,"Juni",720,0,null,""]
[null,null,null,null,"Juli",744,0,null,""]
[null,null,null,null,"Augustus",744,0,null,""]
[null,null,null,null,"September",720,0,null,""]
[null,null,null,null,"Oktober",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(H62:H73)","v":0}]
[]
[]
[null,null,null,"5. Netto geïnjecteerde energie (en MWh)"]
[]
[null,null,null,null,"Vul hierna de netto geïnjecteerde energie in voor een jaar, indien van toepassing."]
[]
[]
[]
[]
[null,null,null,"6. Gegevens betreffende de federale bijdrage"]
[]
[null,null,null,null,"Bent u toegangshouder ?",null,"Nee"]
[]
[null,null,null,null,"Beschikt u over een sectorakkoord ?",null,"Nee","Opgenomen in berekening indien toegangshouder"]
[]
[null,null,null,null,"Beschikt u over een (Kyoto) convenant ?",null,"Nee","Opgenomen in berekening indien toegangshouder"]
[]
[null,null,null,null,"Welk soort activiteit oefent u uit?",null,"Ander"]
[null,null,null,null,null,null,null,"Opgenomen in berekening indien toegangshouder"]
[null,null,null,null,null,null,null,"in Wallonië en sectorakkoord en/of convenant"]
[]
[null,null,null,null,"Dank u !"]
[null,null,null,null,"De resultaten kunnen geconsulteerd worden op de worksheets “Resultaten I (Std)” en \"Resultaten II (Std)”."]

{"sheet":"Resultaten I","index":2,"n_rows":68,"n_cols":5,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Tarieven voor :"]
[null,"Type klant :","Klant direct aan het Elia-net aangesloten"]
[null,"Infrastructuurniveau : ",{"$f":"D_Tension","v":"In 380/220/150 kV-netten"}]
[null,"Regio : ",{"$f":"D_Region","v":"Het Brussels Gewest"}]
[null,"Type toegangspunt :",{"$f":"D_Type","v":"Hoofdtoegangspunt"}]
[]
[]
[]
[null,"A. Tarieven voor het beheer en de ontwikkeling van de netinfrastructuur "]
[]
[null,null,null,"€/kW netto afgenomen per maand"]
[null,null,"1. Tarief voor de maandpiek voor afname",{"$f":"VLOOKUP($C$5,Tarieven!D9:F11,3,FALSE)","v":0.2157}]
[]
[null,null,null,"€/kW netto afgenomen per jaar"]
[null,null,"2. Tarief voor de jaarpiek voor afname",{"$f":"VLOOKUP($C$5,Tarieven!D16:F18,3,FALSE)","v":5.6881000000000004}]
[]
[null,null,null,"€/kVA voor afname per jaar"]
[null,null,"3. Tarief voor het ter beschikking gestelde vermogen voor afname",{"$f":"IF($C$7=\"Hoofdtoegangspunt\",VLOOKUP($C$5,Tarieven!D24:G26,3,FALSE),VLOOKUP($C$5,Tarieven!D24:H26,4,FALSE))","v":4.4843999999999999}]
[]
[null,"B. Tarief voor het beheer van het elektrisch systeem"]
[null,null,null,"€/kW netto afgenomen"]
[null,null,null,{"$f":"VLOOKUP($C$5,Tarieven!D32:F34,3,FALSE)","v":0.92679999999999996}]
[]
[null,"C. Tarieven voor de vermogensreserves en de black start"]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,"1. voor de afname",{"$f":"VLOOKUP($C$5,Tarieven!D41:F43,3,FALSE)","v":0.69289999999999996}]
[]
[null,null,null,"€/MWh netto geïnjecteerd"]
[null,null,"2. voor de injectie",{"$f":"VLOOKUP($C$5,Tarieven!D47:F49,3,FALSE)","v":0.6169}]
[]
[null,"D. Tarief voor integratie van de elektriciteitsmarkt"]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,null,{"$f":"VLOOKUP($C$5,Tarieven!D54:F56,3,FALSE)","v":0.36670000000000003}]
[]
[null,"E. Tarieven voor Openbare Dienstverplichtingen"]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,"1. Tarief voor openbare dienstverplichtingen voor de financiering van de aansluiting van offshore windturbineparken (federaal)",{"$f":"VLOOKUP($C$5,Tarieven!D63:F65,3,FALSE)","v":8.4000000000000005E-2}]
[]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,"2. Tarief voor openbare dienstverplichtingen voor de financiering van groenestroomcertificaten (federaal)",{"$f":"VLOOKUP($C$5,Tarieven!D70:F72,3,FALSE)","v":11.6852}]
[]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,"3. Tarief voor openbare dienstverplichtingen voor de financiering van Strategische Reserves",{"$f":"VLOOKUP($C$5,Tarieven!D77:F79,3,FALSE)","v":5.0999999999999997E-2}]
[]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,"4. Tarief voor openbare dienstverplichtingen voor de financiering van de steunmaatregelen voor hernieuwbare energie en warmtekrachtkoppeling in Vlaanderen",{"$f":"IF($C$6=\"Vlaanderen\",VLOOKUP($C$5,Tarieven!D84:F86,3,FALSE),0)","v":0}]
[]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,"5. Tarief voor openbare dienstverplichtingen voor de financiering van de maatregelen ter bevordering van rationeel energiegebruik in Vlaanderen",{"$f":"IF($C$6=\"Vlaanderen\",VLOOKUP($C$5,Tarieven!D91:F93,3,FALSE),0)","v":0}]
[]
[null,null,null,"Eerste component","Tweede component"]
[null,null,null,"€/MWh netto afgenomen","€/MWh netto afgenomen"]
[null,null,"6. Tarief voor openbare dienstverplichtingen voor de financiering van de steunmaatregelen voor hernieuwbare energie in Wallonië",{"$f":"IF($C$6=\"Wallonië\",VLOOKUP($C$5,Tarieven!D99:F101,3,FALSE),0)","v":0},{"$f":"IF($C$6=\"Wallonië\",VLOOKUP($C$5,Tarieven!D99:G101,4,FALSE),0)","v":0}]
[]
[null,"F. Taksen en Toeslagen"]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,"1. Federale bijdrage",{"$f":"VLOOKUP($C$5,Tarieven!D107:F109,3,FALSE)","v":3.47}]
[]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,"2. Toeslag voor het gebruik van het openbaar domein in Wallonië",{"$f":"IF($C$6=\"Wallonië\",VLOOKUP($C$5,Tarieven!D114:F116,3,FALSE),0)","v":0}]
[]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,"3. Toeslag retributie wegenisrecht in Brussel",{"$f":"IF($C$6=\"Het Brussels Gewest\",VLOOKUP($C$5,Tarieven!D121:F123,3,FALSE),0)","v":3.5247999999999999}]
[]
[null,null,null,"€/MWh netto afgenomen"]
[null,null,"4. Toeslag voor de taksen “masten” en “sleuven” in Vlaanderen",{"$f":"IF($C$6=\"Vlaanderen\",VLOOKUP($C$5,Tarieven!D128:F130,3,FALSE),0)","v":0}]

{"sheet":"Resultaten II","index":3,"n_rows":370,"n_cols":15,"rows_kept":370,"cut":false,"hidden":false,"merged":[[367,1,367,8],[369,1,369,8],[98,3,98,8],[104,3,104,8],[363,1,363,8],[193,4,193,8],[232,4,232,8],[359,1,359,8],[361,1,361,8],[144,3,144,8],[211,4,211,8],[278,4,278,8],[183,3,183,9]]}
[]
[null,"Resultaten"]
[]
[null,null,null,null,"Type klant :","Klant direct aan het Elia-net aangesloten"]
[null,null,null,null,"Infrastructuurniveau : ",{"$f":"D_Tension","v":"In 380/220/150 kV-netten"}]
[null,null,null,null,"Regio : ",{"$f":"D_Region","v":"Het Brussels Gewest"}]
[null,null,null,null,"Type toegangspunt :",{"$f":"D_Type","v":"Hoofdtoegangspunt"}]
[null,null,null,null,"Toegangshouder :",{"$f":"D_DA","v":"Nee"}]
[null,null,null,null,"Sectorakkoord :",{"$f":"D_AB","v":"Nee"}]
[null,null,null,null,"Convenant :",{"$f":"D_CK","v":"Nee"}]
[null,null,null,null,"Soort activiteit :",{"$f":"D_TA","v":"Ander"}]
[]
[]
[]
[null,"a. Term voor het beheer en de ontwikkeling van de netinfrastructuur :"]
[]
[null,null,"a.1) Term voor maandselijke piek :"]
[]
[null,null,null,null,null,"Maandselijke piek",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"Gegevens!F26","v":0},"MW *",{"$f":"'Resultaten I'!$D$14","v":0.2157},"€/kW =",{"$f":"F20*H20*1000","v":0},"€"]
[null,null,null,null,"Februari",{"$f":"Gegevens!F27","v":0},"MW *",{"$f":"H20","v":0.2157},"€/kW =",{"$f":"F21*H21*1000","v":0},"€"]
[null,null,null,null,"Maart",{"$f":"Gegevens!F28","v":0},"MW *",{"$f":"H21","v":0.2157},"€/kW =",0,"€"]
[null,null,null,null,"April",{"$f":"Gegevens!F29","v":0},"MW *",0.2157,"€/kW =",0,"€"]
[null,null,null,null,"Mei",{"$f":"Gegevens!F30","v":0},"MW *",0.2157,"€/kW =",0,"€"]
[null,null,null,null,"Juni",{"$f":"Gegevens!F31","v":0},"MW *",0.2157,"€/kW =",0,"€"]
[null,null,null,null,"Juli",{"$f":"Gegevens!F32","v":0},"MW *",0.2157,"€/kW =",0,"€"]
[null,null,null,null,"Augustus",{"$f":"Gegevens!F33","v":0},"MW *",0.2157,"€/kW =",0,"€"]
[null,null,null,null,"September",{"$f":"Gegevens!F34","v":0},"MW *",0.2157,"€/kW =",0,"€"]
[null,null,null,null,"Oktober",{"$f":"Gegevens!F35","v":0},"MW *",0.2157,"€/kW =",0,"€"]
[null,null,null,null,"November",{"$f":"Gegevens!F36","v":0},"MW *",0.2157,"€/kW =",0,"€"]
[null,null,null,null,"December",{"$f":"Gegevens!F37","v":0},"MW *",0.2157,"€/kW =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor maandselijke piek :  ",{"$f":"SUM(J20:J31)","v":0},"€"]
[]
[]
[null,null,"a.2) Term voor jaarlijkse piek :"]
[]
[null,null,null,null,null,"Jaarlijkse piek",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"Gegevens!I26","v":0},"MW *",{"$f":"'Resultaten I'!$D$17/12","v":0.47400833333333336},"€/kW =",{"$f":"F39*H39*1000","v":0},"€"]
[null,null,null,null,"Februari",{"$f":"Gegevens!I27","v":0},"MW *",{"$f":"H39","v":0.47400833333333336},"€/kW =",0,"€"]
[null,null,null,null,"Maart",{"$f":"Gegevens!I28","v":0},"MW *",{"$f":"H40","v":0.47400833333333336},"€/kW =",0,"€"]
[null,null,null,null,"April",{"$f":"Gegevens!I29","v":0},"MW *",0.47400833333333336,"€/kW =",0,"€"]
[null,null,null,null,"Mei",{"$f":"Gegevens!I30","v":0},"MW *",0.47400833333333336,"€/kW =",0,"€"]
[null,null,null,null,"Juni",{"$f":"Gegevens!I31","v":0},"MW *",0.47400833333333336,"€/kW =",0,"€"]
[null,null,null,null,"Juli",{"$f":"Gegevens!I32","v":0},"MW *",0.47400833333333336,"€/kW =",0,"€"]
[null,null,null,null,"Augustus",{"$f":"Gegevens!I33","v":0},"MW *",0.47400833333333336,"€/kW =",0,"€"]
[null,null,null,null,"September",{"$f":"Gegevens!I34","v":0},"MW *",0.47400833333333336,"€/kW =",0,"€"]
[null,null,null,null,"Oktober",{"$f":"Gegevens!I35","v":0},"MW *",0.47400833333333336,"€/kW =",0,"€"]
[null,null,null,null,"November",{"$f":"Gegevens!I36","v":0},"MW *",0.47400833333333336,"€/kW =",0,"€"]
[null,null,null,null,"December",{"$f":"Gegevens!I37","v":0},"MW *",0.47400833333333336,"€/kW =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor jaarlijkse piek :  ",{"$f":"SUM(J39:J50)","v":0},"€"]
[]
[]
[null,null,"a.3) Term voor het ter beschikking gestelde vermogen voor afname :"]
[]
[null,null,null,null,null,"Vermogen",null,"Tarief",null,"Bedrag"]
[null,null,null,null,null,{"$f":"Gegevens!$F$48","v":0},"MVA *",{"$f":"'Resultaten I'!$D$20","v":4.4843999999999999},"€/kVA",{"$f":"F58*H58*1000","v":0},"€"]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor het beheer en de ontwikkeling van de netinfrastructuur : ",{"$f":"J33+J52+J58","v":0},"€"]
[]
[]
[null,"b) Term voor het beheer van het elektrisch systeem :"]
[]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"Gegevens!H62","v":0},"MWh *",{"$f":"'Resultaten I'!D24","v":0.92679999999999996},"€/MWh =",{"$f":"F66*H66","v":0},"€"]
[null,null,null,null,"Februari",{"$f":"Gegevens!H63","v":0},"MWh *",{"$f":"H66","v":0.92679999999999996},"€/MWh =",{"$f":"F67*H67","v":0},"€"]
[null,null,null,null,"Maart",{"$f":"Gegevens!H64","v":0},"MWh *",{"$f":"H67","v":0.92679999999999996},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Gegevens!H65","v":0},"MWh *",0.92679999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"Mei",{"$f":"Gegevens!H66","v":0},"MWh *",0.92679999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"Juni",{"$f":"Gegevens!H67","v":0},"MWh *",0.92679999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"Juli",{"$f":"Gegevens!H68","v":0},"MWh *",0.92679999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"Augustus",{"$f":"Gegevens!H69","v":0},"MWh *",0.92679999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Gegevens!H70","v":0},"MWh *",0.92679999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"Oktober",{"$f":"Gegevens!H71","v":0},"MWh *",0.92679999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Gegevens!H72","v":0},"MWh *",0.92679999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Gegevens!H73","v":0},"MWh *",0.92679999999999996,"€/MWh =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor het beheer van het elektrisch systeem : ",{"$f":"SUM(J66:J77)","v":0},"€"]
[]
[]
[null,"c) Term voor de vermogensreserves en de black start :"]
[]
[null,null,null,"c.1. Voor de afname :"]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"Gegevens!H62","v":0},"MWh *",{"$f":"'Resultaten I'!D28","v":0.69289999999999996},"€/MWh =",{"$f":"F86*H86","v":0},"€"]
[null,null,null,null,"Februari",{"$f":"Gegevens!H63","v":0},"MWh *",{"$f":"H86","v":0.69289999999999996},"€/MWh =",{"$f":"F87*H87","v":0},"€"]
[null,null,null,null,"Maart",{"$f":"Gegevens!H64","v":0},"MWh *",{"$f":"H87","v":0.69289999999999996},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Gegevens!H65","v":0},"MWh *",0.69289999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"Mei",{"$f":"Gegevens!H66","v":0},"MWh *",0.69289999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"Juni",{"$f":"Gegevens!H67","v":0},"MWh *",0.69289999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"Juli",{"$f":"Gegevens!H68","v":0},"MWh *",0.69289999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"Augustus",{"$f":"Gegevens!H69","v":0},"MWh *",0.69289999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Gegevens!H70","v":0},"MWh *",0.69289999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"Oktober",{"$f":"Gegevens!H71","v":0},"MWh *",0.69289999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Gegevens!H72","v":0},"MWh *",0.69289999999999996,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Gegevens!H73","v":0},"MWh *",0.69289999999999996,"€/MWh =",0,"€"]
[]
[null,null,null,"Totaal term voor de vermogensreserves en de black start voor de afname : ",null,null,null,null,null,{"$f":"SUM(J86:J97)","v":0},"€"]
[]
[null,null,null,"c.2. Voor de injectie :"]
[null,null,null,null,null,"Netto geïnjecteerde energie",null,"Tarief",null,"Bedrag"]
[null,null,null,null,null,{"$f":"Gegevens!F81","v":0},"MWh *",{"$f":"'Resultaten I'!D31","v":0.6169},"€/MWh =",{"$f":"F103*H103","v":0},"€"]
[]
[null,null,null,"Totaal term voor de vermogensreserves en de black start : ",null,null,null,null,null,{"$f":"J99+J103","v":0},"€"]
[]
[]
[null,"d) Term voor integratie van de elektriciteitsmarkt :"]
[]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"Gegevens!H62","v":0},"MWh *",{"$f":"'Resultaten I'!D35","v":0.36670000000000003},"€/MWh =",{"$f":"F111*H111","v":0},"€"]
[null,null,null,null,"Februari",{"$f":"Gegevens!H63","v":0},"MWh *",{"$f":"H111","v":0.36670000000000003},"€/MWh =",{"$f":"F112*H112","v":0},"€"]
[null,null,null,null,"Maart",{"$f":"Gegevens!H64","v":0},"MWh *",{"$f":"H112","v":0.36670000000000003},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Gegevens!H65","v":0},"MWh *",0.36670000000000003,"€/MWh =",0,"€"]
[null,null,null,null,"Mei",{"$f":"Gegevens!H66","v":0},"MWh *",0.36670000000000003,"€/MWh =",0,"€"]
[null,null,null,null,"Juni",{"$f":"Gegevens!H67","v":0},"MWh *",0.36670000000000003,"€/MWh =",0,"€"]
[null,null,null,null,"Juli",{"$f":"Gegevens!H68","v":0},"MWh *",0.36670000000000003,"€/MWh =",0,"€"]
[null,null,null,null,"Augustus",{"$f":"Gegevens!H69","v":0},"MWh *",0.36670000000000003,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Gegevens!H70","v":0},"MWh *",0.36670000000000003,"€/MWh =",0,"€"]
[null,null,null,null,"Oktober",{"$f":"Gegevens!H71","v":0},"MWh *",0.36670000000000003,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Gegevens!H72","v":0},"MWh *",0.36670000000000003,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Gegevens!H73","v":0},"MWh *",0.36670000000000003,"€/MWh =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor integratie van de elektriciteitsmarkt : ",{"$f":"SUM(J111:J122)","v":0},"€"]
[]
[]
[null,"e) Openbare Dienstverplichtingen :"]
[]
[null,null,"e.1.) De aansluiting van offshore windturbineparken (federaal niveau)"]
[]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"Gegevens!H62","v":0},"MWh *",{"$f":"'Resultaten I'!D39","v":8.4000000000000005E-2},"€/MWh =",{"$f":"F132*H132","v":0},"€"]
[null,null,null,null,"Februari",{"$f":"Gegevens!H63","v":0},"MWh *",{"$f":"H132","v":8.4000000000000005E-2},"€/MWh =",{"$f":"F133*H133","v":0},"€"]
[null,null,null,null,"Maart",{"$f":"Gegevens!H64","v":0},"MWh *",{"$f":"H133","v":8.4000000000000005E-2},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Gegevens!H65","v":0},"MWh *",8.4000000000000005E-2,"€/MWh =",0,"€"]
[null,null,null,null,"Mei",{"$f":"Gegevens!H66","v":0},"MWh *",8.4000000000000005E-2,"€/MWh =",0,"€"]
[null,null,null,null,"Juni",{"$f":"Gegevens!H67","v":0},"MWh *",8.4000000000000005E-2,"€/MWh =",0,"€"]
[null,null,null,null,"Juli",{"$f":"Gegevens!H68","v":0},"MWh *",8.4000000000000005E-2,"€/MWh =",0,"€"]
[null,null,null,null,"Augustus",{"$f":"Gegevens!H69","v":0},"MWh *",8.4000000000000005E-2,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Gegevens!H70","v":0},"MWh *",8.4000000000000005E-2,"€/MWh =",0,"€"]
[null,null,null,null,"Oktober",{"$f":"Gegevens!H71","v":0},"MWh *",8.4000000000000005E-2,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Gegevens!H72","v":0},"MWh *",8.4000000000000005E-2,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Gegevens!H73","v":0},"MWh *",8.4000000000000005E-2,"€/MWh =",0,"€"]
[]
[null,null,null,"Totaal term voor de aansluiting van offshore windturbineparken :  ",null,null,null,null,null,{"$f":"SUM(J132:J143)","v":0},"€"]
[]
[]
[null,null,"e.2.) Groenestroomcertificaten (federaal niveau)"]
[null,null,null,"\n\nDe berekening van de degressiviteit is gebaseerd op de volumes uit het lopende kalenderjaar"]
[null,null,null,"en niet op basis van volumes genomen van de laatste 11 maanden plus de huidige maand zoals gespecificeerd in het tarief."]
[null,null,null,"Voor de directe klanten is de berekening van de schijf per afgenomen energie om de degressiviteit en het maximum"]
[null,null,null,"van 250.000 € te bepalen berekend per toegangspunt en niet per verbruiksadres zoals gespecifieerd in het tarief."]
[]
[null,null,null,null,"Schijven","Netto afgenomen energie per schijf",null,"Tarief",null,"Bedrag",null,null,"Degressiviteit"]
[null,null,null,null,"0-20",{"$f":"MIN(20,Gegevens!H74)","v":0},"MWh *",{"$f":"'Resultaten I'!D42","v":11.6852},"€/MWh =",{"$f":"F155*H155*M155","v":0},"€",null,1,null,{"$f":"IF(Gegevens!O86=\"Ja\",\"\",\"\")","v":""}]
[null,null,null,null,"20-50",{"$f":"MIN(50,Gegevens!H74)-SUM($F$155:F155)","v":0},"MWh *",{"$f":"H155","v":11.6852},"€/MWh =",{"$f":"F156*H156*M156","v":0},"€",null,{"$f":"IF(AND($F$8=\"Ja\",OR($F$9=\"Ja\",$F$10=\"Ja\")),0.85,1)","v":1}]
[null,null,null,null,"50-1000",{"$f":"MIN(1000,Gegevens!H74)-SUM($F$155:F156)","v":0},"MWh *",{"$f":"H156","v":11.6852},"€/MWh =",{"$f":"F157*H157*M157","v":0},"€",null,{"$f":"IF(AND($F$8=\"Ja\",OR($F$9=\"Ja\",$F$10=\"Ja\")),0.8,1)","v":1}]
[null,null,null,null,"1000-25000",{"$f":"MIN(25000,Gegevens!H74)-SUM($F$155:F157)","v":0},"MWh *",{"$f":"H157","v":11.6852},"€/MWh =",{"$f":"F158*H158*M158","v":0},"€",null,{"$f":"IF(AND($F$8=\"Ja\",OR($F$9=\"Ja\",$F$10=\"Ja\")),0.75,1)","v":1}]
[null,null,null,null,">25000",{"$f":"Gegevens!H74-SUM($F$155:F158)","v":0},"MWh *",{"$f":"H158","v":11.6852},"€/MWh =",{"$f":"F159*H159*M159","v":0},"€",null,{"$f":"IF(AND($F$8=\"Ja\",OR($F$9=\"Ja\",$F$10=\"Ja\")),0.55,1)","v":1}]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor groenestroomcertificaten :  ",{"$f":"IF(AND($F$8=\"Ja\",OR($F$9=\"Ja\",$F$10=\"Ja\")),MIN(250000,SUM(J155:J159)),SUM(J155:J159))","v":0},"€"]
[]
[]
[null,null,"e.3.) Financiering van Strategische Reserves (federaal niveau)"]
[]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"Gegevens!H62","v":0},"MWh *",{"$f":"'Resultaten I'!D45","v":5.0999999999999997E-2},"€/MWh =",{"$f":"F167*H167","v":0},"€"]
[null,null,null,null,"Februari",{"$f":"Gegevens!H63","v":0},"MWh *",{"$f":"H167","v":5.0999999999999997E-2},"€/MWh =",{"$f":"F168*H168","v":0},"€"]
[null,null,null,null,"Maart",{"$f":"Gegevens!H64","v":0},"MWh *",{"$f":"H168","v":5.0999999999999997E-2},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"Gegevens!H65","v":0},"MWh *",5.0999999999999997E-2,"€/MWh =",0,"€"]
[null,null,null,null,"Mei",{"$f":"Gegevens!H66","v":0},"MWh *",5.0999999999999997E-2,"€/MWh =",0,"€"]
[null,null,null,null,"Juni",{"$f":"Gegevens!H67","v":0},"MWh *",5.0999999999999997E-2,"€/MWh =",0,"€"]
[null,null,null,null,"Juli",{"$f":"Gegevens!H68","v":0},"MWh *",5.0999999999999997E-2,"€/MWh =",0,"€"]
[null,null,null,null,"Augustus",{"$f":"Gegevens!H69","v":0},"MWh *",5.0999999999999997E-2,"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"Gegevens!H70","v":0},"MWh *",5.0999999999999997E-2,"€/MWh =",0,"€"]
[null,null,null,null,"Oktober",{"$f":"Gegevens!H71","v":0},"MWh *",5.0999999999999997E-2,"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"Gegevens!H72","v":0},"MWh *",5.0999999999999997E-2,"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"Gegevens!H73","v":0},"MWh *",5.0999999999999997E-2,"€/MWh =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor inanciering van Strategische Reserves :  ",{"$f":"SUM(J167:J178)","v":0},"€"]
[]
[]
[null,null,"e.4.) Financiering van de steunmaatregelen voor hernieuwbare energie en warmtekrachtkoppeling (Vlaams gewest)"]
[null,null,null,"De vaststelling van het tarief is niet afhankelijk van het voorgaande jaar, maar van het jaar dat bij referentie is gekozen, in tegenstelling tot wat in de tarieven is bepaald."]
[]
[null,null,null,{"$f":"IF($F$6=\"Vlaanderen\",\"\",\"Niet van toepassing in deze regio\")","v":"Niet van toepassing in deze regio"}]
[null,null,null,null,"Schijven","Netto afgenomen energie per schijf",null,"Tarief",null,"Bedrag",null,null,"Degressiviteit"]
[null,null,null,null,"0-1000",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",IF(Gegevens!H74<1000,Gegevens!H74,0))","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$48)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",F188*H188*M188)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Vlaanderen\",\"\",1)","v":""}]
[null,null,null,null,"1000-20000",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",IF(AND(1000<=Gegevens!H74,Gegevens!H74<20000),Gegevens!H74,0))","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$48)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",F189*H189*M189)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Vlaanderen\",\"\",0.53)","v":""}]
[null,null,null,null,"20000-100000",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",IF(AND(20000<=Gegevens!H74,Gegevens!H74<100000),Gegevens!H74,0))","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$48)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",F190*H190*M190)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Vlaanderen\",\"\",0.2)","v":""}]
[null,null,null,null,"100000-250000",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",IF(AND(100000<=Gegevens!H74,Gegevens!H74<250000),Gegevens!H74,0))","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$48)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",F191*H191*M191)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Vlaanderen\",\"\",0.2)","v":""}]
[null,null,null,null,">250000",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",IF(250000<=Gegevens!H74,Gegevens!H74,0))","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$48)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",F192*H192*M192)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Vlaanderen\",\"\",0.02)","v":""}]
[]
[null,null,null,null,"Totaal term voor Financiering van de steunmaatregelen voorhernieuwbare energie en warmtekrachtkoppeling :  ",null,null,null,null,{"$f":"SUM(J188:J192)","v":0},"€"]
[]
[null,null,"e.5.) Financiering van de maatregelen ter bevordering van rationeel energiegebruik (Vlaams gewest)"]
[null,null,null,{"$f":"IF($F$6=\"Vlaanderen\",\"\",\"Niet van toepassing in deze regio\")","v":"Niet van toepassing in deze regio"}]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H62)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",F199*H199)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€\")","v":""}]
[null,null,null,null,"Februari",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H63)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[null,null,null,null,"Maart",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H64)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H65)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[null,null,null,null,"Mei",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H66)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[null,null,null,null,"Juni",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H67)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[null,null,null,null,"Juli",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H68)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[null,null,null,null,"Augustus",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H69)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H70)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[null,null,null,null,"Oktober",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H71)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H72)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H73)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$51)","v":""},"","",""]
[]
[null,null,null,null,"Totaal term Financiering van de maatregelen ter bevordering van rationeel energiegebruik :  ",null,null,null,null,{"$f":"SUM(J199:J210)","v":0},"€"]
[]
[null,null,"e.6.) Financiering van de steunmaatregelen voor hernieuwbare energie (Waals gewest)"]
[null,null,null,{"$f":"IF($F$6=\"Wallonië\",\"\",\"Niet van toepassing in deze regio\")","v":"Niet van toepassing in deze regio"}]
[]
[null,null,null,"e.6.a.) Eerste component"]
[]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief voor eerste component",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H62)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",F220*H220)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"€\")","v":""}]
[null,null,null,null,"Februari",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H63)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",F221*H221)","v":""},""]
[null,null,null,null,"Maart",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H64)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H65)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"","",""]
[null,null,null,null,"Mei",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H66)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"","",""]
[null,null,null,null,"Juni",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H67)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"","",""]
[null,null,null,null,"Juli",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H68)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"","",""]
[null,null,null,null,"Augustus",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H69)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H70)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"","",""]
[null,null,null,null,"Oktober",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H71)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H72)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H73)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$55)","v":""},"","",""]
[]
[null,null,null,null,"Totaal term voor Financiering van de steunmaatregelen voor hernieuwbare energie :  ",null,null,null,null,{"$f":"SUM(J220:J231)","v":0},"€"]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor openbare Dienstverplichtingen :  ",{"$f":"J145+J161+J180+J194+J212+J233","v":0},"€"]
[]
[]
[]
[null,null,null,"De vrijstelling van de eerste component en de facturatie van de tweede component worden op kwartaalbasis gemaakt op basis van een door de SPW ontvangen bestand"]
[null,null,null,"op basis van de door de SPW vastgestelde heffing en tarief."]
[null,null,null,"De principes worden beschreven in de richtlijnen van de SPW."]
[null,null,null,"Voor meer informatie, zie https://www.elia.be/fr/clients/certificats-verts-et-surcharges/wallonie-exemptions-partielles#Partial exemptions. (in her Frans)"]
[null,null,null,"De onderstaande berekening is louter indicatief op basis van het gesimuleerde afname volume en op basis van het tarief voor de eerste component."]
[]
[null,null,null,"e.6.b.) Vrijstelling eerste component"]
[null,null,null,null,null,"Netto afgenomen energie",null,"Vrijgesteld tarief",null,"Bedrag",null,null,"Vrijstelling"]
[null,null,null,null,"Januari",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H62)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",F247*H247)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"€\")","v":""},null,{"$f":"IF($F$6<>\"Wallonië\",\"\",IF($F$8=\"Nee\",0,IF($F$9=\"Ja\",0.85,IF($F$11=\"Ander\",0,IF($F$11=\"Plantaardige en dierlijke productie (01)\",0.5,IF(Gegevens!H74>1000,0.5,0))))))","v":""}]
[null,null,null,null,"Februari",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H63)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[null,null,null,null,"Maart",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H64)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H65)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[null,null,null,null,"Mei",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H66)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[null,null,null,null,"Juni",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H67)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[null,null,null,null,"Juli",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H68)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[null,null,null,null,"Augustus",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H69)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H70)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[null,null,null,null,"Oktober",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H71)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H72)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H73)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",-'Resultaten I'!$D$55*$M$247)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Totaal vrijstelling eerste component :  ",{"$f":"SUM(J247:J258)","v":0},"€"]
[]
[null,null,null,"e.6.c.) Tweede component"]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief voor tweede component",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H62)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",F264*H264*$M$247)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"€\")","v":""}]
[null,null,null,null,"Februari",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H63)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[null,null,null,null,"Maart",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H64)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H65)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[null,null,null,null,"Mei",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H66)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[null,null,null,null,"Juni",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H67)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[null,null,null,null,"Juli",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H68)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[null,null,null,null,"Augustus",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H69)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H70)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[null,null,null,null,"Oktober",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H71)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H72)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H73)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$E$55)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Totaal facturatie tweede component van de hernieuwbare energie :",{"$f":"SUM(J264:J275)","v":0},"€"]
[]
[null,null,null,null,"Totaal vrijstelling eerste component en facturatie tweede component van de hernieuwbare energie :",null,null,null,null,{"$f":"J260+J277","v":0},"€"]
[]
[]
[null,"f) Taksen en Toeslagen :"]
[]
[null,null,"f.1.) Federale bijdrage (federaal niveau)"]
[null,null,null,"\n\nDe berekening van de degressiviteit is gebaseerd op de volumes uit het lopende kalenderjaar"]
[null,null,null,"en niet op basis van volumes genomen van de laatste 11 maanden plus de huidige maand zoals gespecificeerd in het tarief."]
[null,null,null,"Voor de directe klanten is de berekening van de schijf per afgenomen energie om de degressiviteit en het maximum"]
[null,null,null,"van 250.000 € te bepalen berekend per toegangspunt en niet per verbruiksadres zoals gespecifieerd in het tarief.",null,null,null,null,null,null,null,null,"Forfaitair aandeel"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($F$8=\"Ja\",0.011,0.001)","v":1E-3}]
[null,null,null,null,"Schijven","Netto afgenomen energie per schijf",null,"Tarief",null,"Bedrag",null,null,"Degressiviteit"]
[null,null,null,null,"0-20",{"$f":"MIN(20,Gegevens!H74)","v":0},"MWh *",{"$f":"'Resultaten I'!D59","v":3.47},"€/MWh =",{"$f":"F291*H291*M291","v":0},"€",null,1]
[null,null,null,null,"20-50",{"$f":"MIN(50,Gegevens!H74)-SUM($F$291:F291)","v":0},"MWh *",{"$f":"H291","v":3.47},"€/MWh =",{"$f":"F292*H292*M292","v":0},"€",null,{"$f":"IF(AND($F$8=\"Ja\",OR($F$9=\"Ja\",$F$10=\"Ja\")),0.85,1)","v":1}]
[null,null,null,null,"50-1000",{"$f":"MIN(1000,Gegevens!H74)-SUM($F$291:F292)","v":0},"MWh *",{"$f":"H292","v":3.47},"€/MWh =",{"$f":"F293*H293*M293","v":0},"€",null,{"$f":"IF(AND($F$8=\"Ja\",OR($F$9=\"Ja\",$F$10=\"Ja\")),0.8,1)","v":1}]
[null,null,null,null,"1000-25000",{"$f":"MIN(25000,Gegevens!H74)-SUM($F$291:F293)","v":0},"MWh *",{"$f":"H293","v":3.47},"€/MWh =",{"$f":"F294*H294*M294","v":0},"€",null,{"$f":"IF(AND($F$8=\"Ja\",OR($F$9=\"Ja\",$F$10=\"Ja\")),0.75,1)","v":1}]
[null,null,null,null,">25000",{"$f":"Gegevens!H74-SUM($F$291:F294)","v":0},"MWh *",{"$f":"H294","v":3.47},"€/MWh =",{"$f":"F295*H295*M295","v":0},"€",null,{"$f":"IF(AND($F$8=\"Ja\",OR($F$9=\"Ja\",$F$10=\"Ja\")),0.55,1)","v":1}]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor Federale bijdrage :  ",{"$f":"IF($F$8=\"Nee\",MIN(250000,SUM(J291:J295))*(1+M289),IF(AND($F$8=\"Ja\",OR($F$9=\"Ja\",$F$10=\"Ja\")),MIN(250000,SUM(J291:J295))*(1+M289),SUM(J291:J295)*(1+M289)))","v":0},"€"]
[]
[]
[null,null,"f.2.) Gebruik van het openbaar domein (Waals gewest)"]
[null,null,null,{"$f":"IF($F$6=\"Wallonië\",\"\",\"Niet van toepassing in deze regio\")","v":"Niet van toepassing in deze regio"}]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H62)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",F303*H303)","v":""},{"$f":"IF($F$6<>\"Wallonië\",\"\",\"€\")","v":""}]
[null,null,null,null,"Februari",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H63)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[null,null,null,null,"Maart",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H64)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H65)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[null,null,null,null,"Mei",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H66)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[null,null,null,null,"Juni",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H67)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[null,null,null,null,"Juli",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H68)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[null,null,null,null,"Augustus",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H69)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H70)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[null,null,null,null,"Oktober",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H71)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H72)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Wallonië\",\"\",Gegevens!H73)","v":""},"",{"$f":"IF($F$6<>\"Wallonië\",\"\",'Resultaten I'!$D$62)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor het gebruik van het openbaar domein :  ",{"$f":"SUM(J303:J314)","v":0},"€"]
[]
[]
[null,null,"f.3.) Retributie wegenisrecht (Brussels gewest)"]
[null,null,null,{"$f":"IF($F$6=\"Het Brussels Gewest\",\"\",\"Niet van toepassing in deze regio\")","v":""}]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H62)","v":0},{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",\"MWh *\")","v":"MWh *"},{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",\"€/MWh =\")","v":"€/MWh ="},{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",F322*H322)","v":0},{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",\"€\")","v":"€"}]
[null,null,null,null,"Februari",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H63)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"Maart",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H64)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H65)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"Mei",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H66)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"Juni",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H67)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"Juli",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H68)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"Augustus",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H69)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H70)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"Oktober",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H71)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H72)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",Gegevens!H73)","v":0},"MWh *",{"$f":"IF($F$6<>\"Het Brussels Gewest\",\"\",'Resultaten I'!$D$65)","v":3.5247999999999999},"€/MWh =",0,"€"]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor Retributie wegenisrecht :  ",{"$f":"SUM(J322:J333)","v":0},"€"]
[]
[]
[null,null,"f.4.) Taksen “masten” en “sleuven” (Vlaams gewest)"]
[null,null,null,{"$f":"IF($F$6=\"Vlaanderen\",\"\",\"Niet van toepassing in deze regio\")","v":"Niet van toepassing in deze regio"}]
[null,null,null,null,null,"Netto afgenomen energie",null,"Tarief",null,"Bedrag"]
[null,null,null,null,"Januari",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H62)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"MWh *\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€/MWh =\")","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",F341*H341)","v":""},{"$f":"IF($F$6<>\"Vlaanderen\",\"\",\"€\")","v":""}]
[null,null,null,null,"Februari",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H63)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[null,null,null,null,"Maart",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H64)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[null,null,null,null,"April",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H65)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[null,null,null,null,"Mei",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H66)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[null,null,null,null,"Juni",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H67)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[null,null,null,null,"Juli",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H68)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[null,null,null,null,"Augustus",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H69)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[null,null,null,null,"September",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H70)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[null,null,null,null,"Oktober",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H71)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[null,null,null,null,"November",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H72)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[null,null,null,null,"December",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",Gegevens!H73)","v":""},"",{"$f":"IF($F$6<>\"Vlaanderen\",\"\",'Resultaten I'!$D$68)","v":""},"","",""]
[]
[null,null,null,null,null,null,null,null,"Totaal term voor Taksen “masten” en “sleuven” :  ",{"$f":"SUM(J341:J352)","v":0},"€"]
[]
[null,null,null,null,null,null,null,null,"Totaal voor openbare dienstverplichtingen & taksen en toeslagen :  ",{"$f":"J297+J316+J335+J354","v":0},"€"]
[]
[]
[]
[null,"Jaarlijks totaal (zonder openbare dienstverplichtingen & taksen en toeslagen) :  ",null,null,null,null,null,null,null,{"$f":"J60+J79+J105+J124","v":0},"€"]
[]
[null,"Totaal openbare dienstverplichtingen & taksen en toeslagen :  ",null,null,null,null,null,null,null,{"$f":"J235+J356","v":0},"€"]
[]
[null,"Jaarlijks totaal (met openbare dienstverplichtingen & taksen en toeslagen maar zonder vrijstelling eerste component en facturatie tweede component voor de financiering van de steunmaatregelen voor hernieuwbare energie (Waals gewest) :",null,null,null,null,null,null,null,{"$f":"J360+J362","v":0},"€"]
[]
[]
[]
[null,"Totaal vrijstelling eerste component en facturatie tweede component voor de financiering van de steunmaatregelen voor hernieuwbare energie (Waals gewest) :",null,null,null,null,null,null,null,{"$f":"$J$279","v":0},"€"]
[]
[null,"Jaarlijks totaal (met openbare dienstverplichtingen & taksen en toeslagen en met vrijstelling eerste component en facturatie tweede component voor de financiering van de steunmaatregelen voor hernieuwbare energie (Waals gewest)) :  ",null,null,null,null,null,null,null,{"$f":"J364+J368","v":0},"€"]

{"sheet":"Tarieven","index":4,"n_rows":130,"n_cols":7,"rows_kept":130,"cut":false,"hidden":false,"merged":[[122,3,122,4],[100,3,100,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[113,3,113,4],[114,3,114,4],[121,3,121,4],[92,3,92,4],[98,3,98,4],[99,3,99,4],[115,3,115,4],[120,3,120,4],[91,3,91,4],[64,3,64,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[83,3,83,4],[84,3,84,4],[85,3,85,4],[90,3,90,4],[54,3,54,4],[42,3,42,4],[48,3,48,4],[55,3,55,4],[62,3,62,4],[17,3,17,4],[32,3,32,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[31,3,31,4],[63,3,63,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],[8,3,8,4],[9,3,9,4],[10,3,10,4],[15,3,15,4],[16,3,16,4]]}
[]
[null,"TARIFS"]
[]
[]
[null,"A. Tarieven voor het beheer en de ontwikkeling van de netinfrastructuur  "]
[]
[null,null,"1. Tarieven voor de maandpiek voor afname"]
[null,null,null,null,null,"€/kW netto afgenomen per maand"]
[null,null,null,"In 380/220/150 kV-netten",null,0.2157]
[null,null,null,"In 70/36/30 kV-netten",null,0.38869999999999999]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,0.56320000000000003]
[]
[]
[null,null,"2. Tarieven voor de jaarpiek voor afname"]
[null,null,null,null,null,"€/kW netto afgenomen per jaar"]
[null,null,null,"In 380/220/150 kV-netten",null,5.6881000000000004]
[null,null,null,"In 70/36/30 kV-netten",null,9.9198000000000004]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,14.1214]
[]
[]
[null,null,"3. Tarieven voor het ter beschikking gestelde vermogen voor afname"]
[null,null,null,null,null,"Hoofd TP","Bijkomend TP"]
[null,null,null,null,null,"€/kVA voor afname per jaar","€/kVA voor afname per jaar"]
[null,null,null,"In 380/220/150 kV-netten",null,4.4843999999999999,0.89690000000000003]
[null,null,null,"In 70/36/30 kV-netten",null,8.6525999999999996,1.7304999999999999]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,15.8735,3.1747000000000001]
[]
[]
[null,"B. Tarieven voor het beheer van het elektrisch systeem"]
[]
[null,null,null,null,null,"€/kW netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,0.92679999999999996]
[null,null,null,"In 70/36/30 kV-netten",null,1.4596]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,2.2869000000000002]
[]
[]
[null,"C. Tarieven voor de vermogensreserves en de black start"]
[]
[null,null,"1. voor de afname"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,0.69289999999999996]
[null,null,null,"In 70/36/30 kV-netten",null,0.69289999999999996]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,0.69289999999999996]
[]
[null,null,"2. voor de injectie"]
[null,null,null,null,null,"€/MWh netto geïnjecteerd"]
[null,null,null,"In 380/220/150 kV-netten",null,0.6169]
[null,null,null,"In 70/36/30 kV-netten",null,0.6169]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,0.6169]
[]
[]
[null,"D. Tarieven voor integratie van de elektriciteitsmarkt"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,0.36670000000000003]
[null,null,null,"In 70/36/30 kV-netten",null,0.36670000000000003]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,0.36670000000000003]
[]
[]
[null,"E. Tarieven voor Openbare Dienstverplichtingen"]
[]
[null,null,"1. Tarief voor openbare dienstverplichtingen voor de financiering van de aansluiting van offshore windturbineparken (federaal)"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,8.4000000000000005E-2]
[null,null,null,"In 70/36/30 kV-netten",null,8.4000000000000005E-2]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,8.4000000000000005E-2]
[]
[]
[null,null,"2. Tarief voor de financiering van groenestroomcertificaten (federaal)"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,11.6852]
[null,null,null,"In 70/36/30 kV-netten",null,11.6852]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,11.6852]
[]
[]
[null,null,"3. Tarief voor openbare dienstverplichtingen voor de financiering van Strategische Reserves (federaal)"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,5.0999999999999997E-2]
[null,null,null,"In 70/36/30 kV-netten",null,5.0999999999999997E-2]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,5.0999999999999997E-2]
[]
[]
[null,null,"4. Tarief voor openbare dienstverplichtingen voor de financiering van de steunmaatregelen voor hernieuwbare energie en warmtekrachtkoppeling in Vlaanderen"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,0]
[null,null,null,"In 70/36/30 kV-netten",null,0.55300000000000005]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,0.55300000000000005]
[]
[]
[null,null,"5. Tarief voor openbare dienstverplichtingen voor de financiering van de maatregelen ter bevordering van rationeel energiegebruik in Vlaanderen"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,0]
[null,null,null,"In 70/36/30 kV-netten",null,6.2799999999999995E-2]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,6.2799999999999995E-2]
[]
[]
[null,null,"6. Tarief voor openbare dienstverplichtingen voor de financiering van de steunmaatregelen voor hernieuwbare energie in Wallonië"]
[null,null,null,null,null,"Eerste component","Tweede component"]
[null,null,null,null,null,"€/MWh netto afgenomen","€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,0,0]
[null,null,null,"In 70/36/30 kV-netten",null,13.815900000000001,0]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,13.815900000000001,0]
[]
[null,"F. Taksen en Toeslagen"]
[]
[null,null,"1. Federale bijdrage"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,3.47]
[null,null,null,"In 70/36/30 kV-netten",null,3.47]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,3.47]
[]
[]
[null,null,"2. Toeslag voor het gebruik van het openbaar domein in Wallonië"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,0]
[null,null,null,"In 70/36/30 kV-netten",null,0.33379999999999999]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,0.33379999999999999]
[]
[]
[null,null,"3. Toeslag retributie wegenisrecht in Brussel"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,3.5247999999999999]
[null,null,null,"In 70/36/30 kV-netten",null,3.5247999999999999]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,0]
[]
[]
[null,null,"4. Toeslag voor de taksen “masten” en “sleuven” in Vlaanderen"]
[null,null,null,null,null,"€/MWh netto afgenomen"]
[null,null,null,"In 380/220/150 kV-netten",null,0.44450000000000001]
[null,null,null,"In 70/36/30 kV-netten",null,0.44450000000000001]
[null,null,null,"Bij de uitgang van de transformaties naar Middenspanning",null,0.44450000000000001]