{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructies","Q%","Data","A1","A2","A3","A4","D1","D2","Sorteren","Berekeningsmodel Q E","Berekeningsmodel Q G"],"not_rendered":{"charts":10,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Instructies","index":0,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Invulinstructies VREG","2020-08-13"]
[]
["1. Tabblad 'Q%': "]
["a. Jaar waarin q-factor wordt bepaald (voorafgaand aan nieuwe reguleringsperiode)"]
["b. Aantal jaren van de volgende reguleringsperiode"]
["a. Aantal jaren beoordeeld per kwaliteitsonderdeel."]
["2. Tabblad 'Data'"]
["a. Data m.b.t. 'aantal actieve toegangspunten' in te vullen door de VREG volgens rapportering door distributienetbeheerders;"]
["b. Data m.b.t. 'toegelaten inkomen endogene kosten' in te vullen door de VREG volgens definitieve berekening VREG."]
["3. Vervolgens invullen kwaliteitsdata per kwaliteitsindicator door de VREG:"]
["a. Tabbladen 'A1', 'A2' ,'A3' en 'A4' volgens rapportering distributienetbeheerders;"]
["b. Tabbladen 'D1' en 'D2' volgens rapportering distributienetbeheerders;"]
["4. Tabblad 'Sorteren': "]
["Manueel overzetten van de eindscore per distributienetbeheerder en rangschikken van hoog naar laag"]
["5. Tabblad 'Berekeningsmodel Q E'"]
["Manueel invullen van bedragen cap/floor (blauwe cellen)."]
["6.  Tabblad 'Berekeningsmodel Q G'"]
["Manueel invullen van bedragen cap/floor (blauwe cellen)."]

{"sheet":"Q%","index":1,"n_rows":31,"n_cols":16,"rows_kept":31,"cut":false,"hidden":false,"merged":[[10,13,13,13],[10,15,13,15],[12,8,12,9],[14,3,17,3],[14,4,17,4],[14,15,17,15],[18,4,19,4],[0,0,0,12],[10,0,13,0],[10,1,13,1],[10,2,13,3],[10,4,12,6],[10,7,13,7],[10,8,11,10],[10,11,13,11]]}
["Waardering kwaliteitsindicatoren distributienetbeheerders Vlaanderen"]
[]
[null,"Waarden in blauwe cellen in te vullen door de VREG."]
[]
[null,null,null,"Het jaar waarin de q-factor wordt bepaald:",2024]
[]
[]
[null,null,null,null,"jaar 1","jaar 2","jaar 3","jaar 4","jaar 5","jaar 6","jaar 7"]
[null,"Jaren van de volgende reguleringsperiode:",4,":",{"$f":"+E5+1","v":2025},{"$f":"IF($C9>1,$E5+2,\"\")","v":2026},{"$f":"IF($C9>2,$E5+3,\"\")","v":2027},{"$f":"IF($C9>3,$E5+4,\"\")","v":2028},{"$f":"IF($C9>4,$E5+5,\"\")","v":""},{"$f":"IF($C9>5,$E5+6,\"\")","v":""},{"$f":"IF($C9>6,$E5+7,\"\")","v":""}]
[]
["Code","Kwaliteitsindicator","Voor activiteit",null,"Te verdelen punten onder de distributienetbeheerders per activiteit en per beoordeeld jaar",null,null,"Minimum aantal jaren beoordeling van de indicator",{"$f":"\"Het aantal jaren waarvoor de distributienet-beheerders op dit kwaliteitsaspect beoordeeld worden\"","v":"Het aantal jaren waarvoor de distributienet-beheerders op dit kwaliteitsaspect beoordeeld worden"},null,null,"Te verdelen punten onder de distributienetbeheerders voor prestaties mbt deze indicator in de beoordelingsperiode",null,"ELEK",null,"AARDGAS"]
[]
[null,null,null,null,null,null,null,null,"beoordelingsperiode"]
[null,null,null,null,"totaal punten per jaar","verdeling","punten per jaar",null,"van","tot en met"]
["A1","Onderbrekingsfrequentie middenspanningsnet in jaar j","Elekt.","n.v.t.",400,0.38500000000000001,{"$f":"+F15*E15","v":154},3,2020,2023,{"$f":"+J15-I15+1","v":4},{"$f":"IF(K15<H15,0,K15*G15)","v":616},null,{"$f":"+L15","v":616},null,"n.v.t."]
["A2","Onderbrekingsduur middenspanningsnet in jaar j","Elekt.",null,null,0.315,{"$f":"+F16*E15","v":126},3,2020,2023,{"$f":"+J16-I16+1","v":4},{"$f":"IF(K16<H16,0,K16*G16)","v":504},null,504]
["A3","Onderbrekingsfrequentie laagspanningsnet in jaar j","Elekt.",null,null,0.16500000000000001,{"$f":"+F17*E15","v":66},3,2020,2023,4,264,null,264]
["A4","Onderbrekingsduur laagspanningsnet in jaar j","Elekt.",null,null,{"$f":"1-F17-F16-F15","v":0.13500000000000001},{"$f":"+F18*E15","v":54},3,2020,2023,4,216,null,216]
["D1","Som van de forfaitaire vergoedingen betaald door de distributienetbeheerder in jaar j wegens laattijdige nieuwe aansluiting, overeenkomstig Energiedecreet, relatief t.o.v. het aantal gerealiseerde aansluitingen","Elekt.","Aardgas",25,0.8,{"$f":"+F19*E19","v":20},2,2020,2023,4,80,null,80,null,{"$f":"+L19","v":80}]
["D2","Som van de forfaitaire vergoedingen betaald door de distributienetbeheerder in jaar j wegens laattijdige heraansluiting, overeenkomstig Energiedecreet, relatief t.o.v. het aantal gerealiseerde heraansluitingen","Elekt.","Aardgas",null,{"$f":"1-F19","v":0.19999999999999996},{"$f":"+F20*E19","v":4.9999999999999991},2,2020,2023,4,{"$f":"IF(K20<H20,0,K20*G20)","v":19.999999999999996},null,19.999999999999996,null,{"$f":"+L20","v":19.999999999999996}]
[]
[null,null,null,"aantal punten per beoordelingsjaar voor elektriciteit:",{"$f":"+E15+E19","v":425},null,null,null,null,null,null,null,"totaal punten",{"$f":"SUM(N15:N20)","v":1700},null,{"$f":"SUM(P19:P20)","v":100}]
[null,null,null,"aantal punten per beoordelingsjaar voor aardgas:",{"$f":"+E19","v":25},null,null,null,null,null,null,null,"max punten per jaar",{"$f":"+E22","v":425},null,{"$f":"+E23","v":25}]
[null,null,null,null,null,null,null,null,null,null,null,null,"equivalent aantal jaren",{"$f":"+ROUND(N22/N23,2)","v":4},null,{"$f":"+P22/P23","v":4}]
[null,null,null," % van basisgedeelte endogeen budget in de balans per volledig beoordelingsjaar (Q-bedrag):",null,null,null,null,null,null,null,null,"in vergelijking met de volgende reguleringsperiode ",{"$f":"+N24/C9","v":1},null,{"$f":"+P24/C9","v":1}]
[null,null,null,"Elektriciteit:",{"$f":"1.125%*(425/600)","v":7.9687500000000001E-3}]
[null,null,null,"Aardgas:",{"$f":"+E26*E23/E22","v":4.6874999999999998E-4},null,null,null,null,null,null,null," % basisgedeelte endogeen inkomen (Q%) in reguleringsperiode:",{"$f":"ROUND(E26*N25,5)","v":7.9699999999999997E-3},null,{"$f":"ROUND(E27*P25,5)","v":4.6999999999999999E-4}]
[]
[null,null,null,"pro rata cap/floor impact op TI:",null,null,null,null,null,null,null,null,"cap/floor in reguleringsperiode",{"$f":"+ROUND(N25*E30,5)","v":1.0630000000000001E-2},null,{"$f":"+ROUND(P25*E31,5)","v":6.3000000000000003E-4}]
[null,null,null,"Elektriciteit: +/-",{"$f":"1.5%*(0.708333333333333)","v":1.0624999999999996E-2}]
[null,null,null,"Aardgas:+/-",{"$f":"+E30*E23/E22","v":6.2499999999999969E-4}]

{"sheet":"Data","index":2,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[6,3,6,8],[20,3,20,8],[0,1,0,5],[6,1,7,1],[20,1,21,1]]}
[null,"Gegevens betreffende aantal actieve toegangspunten en oorspronkelijk toegelaten inkomen niet-exogene kosten in volgende reguleringsperiode"]
[]
[null,null,null,null,"Waarden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[null,null,null,null,"distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[]
[]
[null,"Distributienetbeheerder","Naam","Aantal actieve toegangspunten elektriciteit op 1 juli van het jaar",null,null,null,null,null,{"$f":"\"Aantal actieve toegangspunten elektriciteit op 1 januari \"&'Q%'!E5","v":"Aantal actieve toegangspunten elektriciteit op 1 januari 2024"},{"$f":"\"Totaal oorspronkelijk toegelaten inkomen endogene kosten (zonder kwaliteitsprestatie-invloed) voor het eerste jaar van de volgende reguleringsperiode \"&'Q%'!$E$5+1","v":"Totaal oorspronkelijk toegelaten inkomen endogene kosten (zonder kwaliteitsprestatie-invloed) voor het eerste jaar van de volgende reguleringsperiode 2025"},{"$f":"\"Oorspronkelijk toegelaten inkomen endogene kosten basisgedeelte (zonder kwaliteitsprestatie-invloed) voor het eerste jaar van de volgende reguleringsperiode \"&'Q%'!$E$5+1","v":"Oorspronkelijk toegelaten inkomen endogene kosten basisgedeelte (zonder kwaliteitsprestatie-invloed) voor het eerste jaar van de volgende reguleringsperiode 2025"}]
[null,null,null,{"$f":"DATE(MIN('Q%'!I15:I20),7,1)","v":"2020-07-01"},{"$f":"IF(2<=MAX('Q%'!$K$15:$K$20),DATE(YEAR(D8)+1,7,1),\"\")","v":"2021-07-01"},{"$f":"IF(3<=MAX('Q%'!$K$15:$K$20),DATE(YEAR(E8)+1,7,1),\"\")","v":"2022-07-01"},{"$f":"IF(4<=MAX('Q%'!$K$15:$K$20),DATE(YEAR(F8)+1,7,1),\"\")","v":"2023-07-01"},{"$f":"IF(5<=MAX('Q%'!$K$15:$K$20),DATE(YEAR(G8)+1,7,1),\"\")","v":""},{"$f":"IF(6<=MAX('Q%'!$K$15:$K$20),DATE(YEAR(H8)+1,7,1),\"\")","v":""},{"$f":"DATE('Q%'!E5,1,1)","v":"2024-01-01"},{"$f":"+'Q%'!$E$5+1","v":2025},{"$f":"+'Q%'!$E$5+1","v":2025}]
[null,"dnb1","Gaselwest",null,null,null,null,null,null,{"$f":"CEILING(G9*1.02,1)","v":0}]
[null,"dnb2","Fluvius Antwerpen",null,null,null,null,null,null,{"$f":"CEILING(G10*1.02,1)","v":0}]
[null,"dnb3","Fluvius Limburg",null,null,null,null,null,null,0]
[null,"dnb4","Fluvius West",null,null,null,null,null,null,0]
[null,"dnb5","Imewo",null,null,null,null,null,null,0]
[null,"dnb6","Intergem",null,null,null,null,null,null,0]
[null,"dnb7","Iveka",null,null,null,null,null,null,0]
[null,"dnb8","Iverlek",null,null,null,null,null,null,0]
[null,"dnb9","PBE",null,null,null,null,null,null,0]
[null,"dnb10","Sibelgas",null,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D9:D18)","v":0},{"$f":"SUM(E9:E18)","v":0},{"$f":"SUM(F9:F18)","v":0},null,{"$f":"SUM(H9:H18)","v":0},{"$f":"SUM(I9:I18)","v":0},{"$f":"SUM(J9:J18)","v":0},{"$f":"SUM(K9:K18)","v":0},{"$f":"SUM(L9:L18)","v":0}]
[]
[null,"Distributienetbeheerder",null,"Aantal actieve toegangspunten aardgas 1 juli van het jaar",null,null,null,null,null,{"$f":"\"Aantal actieve toegangspunten aardgas op 1 januari \"&'Q%'!E5","v":"Aantal actieve toegangspunten aardgas op 1 januari 2024"},{"$f":"+K7","v":"Totaal oorspronkelijk toegelaten inkomen endogene kosten (zonder kwaliteitsprestatie-invloed) voor het eerste jaar van de volgende reguleringsperiode 2025"},{"$f":"+L7","v":"Oorspronkelijk toegelaten inkomen endogene kosten basisgedeelte (zonder kwaliteitsprestatie-invloed) voor het eerste jaar van de volgende reguleringsperiode 2025"}]
[null,null,null,{"$f":"DATE(MIN('Q%'!I15:I20),7,1)","v":"2020-07-01"},{"$f":"IF(2<=MAX('Q%'!$K$15:$K$20),DATE(YEAR(D22)+1,7,1),\"\")","v":"2021-07-01"},{"$f":"IF(3<=MAX('Q%'!$K$15:$K$20),DATE(YEAR(E22)+1,7,1),\"\")","v":"2022-07-01"},{"$f":"IF(4<=MAX('Q%'!$K$15:$K$20),DATE(YEAR(F22)+1,7,1),\"\")","v":"2023-07-01"},{"$f":"IF(5<=MAX('Q%'!$K$15:$K$20),DATE(YEAR(G22)+1,7,1),\"\")","v":""},{"$f":"IF(6<=MAX('Q%'!$K$15:$K$20),DATE(YEAR(H22)+1,7,1),\"\")","v":""},{"$f":"+J8","v":"2024-01-01"},{"$f":"+'Q%'!$E$5+1","v":2025},{"$f":"+'Q%'!$E$5+1","v":2025}]
[null,"dnb1","Gaselwest"]
[null,"dnb2","Fluvius Antwerpen"]
[null,"dnb3","Fluvius Limburg"]
[null,"dnb4","Fluvius West"]
[null,"dnb5","Imewo"]
[null,"dnb6","Intergem"]
[null,"dnb7","Iveka"]
[null,"dnb8","Iverlek"]
[null,"dnb9","Sibelgas"]
[null,null,null,{"$f":"SUM(D23:D31)","v":0},{"$f":"SUM(E23:E31)","v":0},{"$f":"SUM(F23:F31)","v":0},null,{"$f":"SUM(H23:H31)","v":0},{"$f":"SUM(I23:I31)","v":0},{"$f":"SUM(J23:J31)","v":0},{"$f":"SUM(K23:K31)","v":0},{"$f":"SUM(L23:L31)","v":0}]

{"sheet":"A1","index":3,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,12,5,14]]}
["Onderbrekingsfrequentie middenspanning"]
[]
[null,null,null,"Waarden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[null,null,null,"distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Puntenverdeling"]
[null,null,{"$f":"IF('Q%'!$K$15<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$15)","v":2020},{"$f":"IF('Q%'!$K$15<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$15+1)","v":2021},{"$f":"IF('Q%'!$K$15<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$15+2)","v":2022},{"$f":"IF('Q%'!$K$15<=3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$15+3)","v":2023},{"$f":"IF('Q%'!$K$15<=4,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$15+4)","v":"n.v.t."},{"$f":"IF('Q%'!$K$15<=5,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$15+5)","v":"n.v.t."},"Gemiddelde","Normalisatie","Formule inverse exponent",null," 1 basis","2 prestatie beter dan gemiddelde","3 herverdeling"]
[null,{"$f":"+Data!C9","v":"Gaselwest"},null,null,null,null,null,null,{"$f":"AVERAGE(C8:H8)","v":{"$error":"#DIV/0!"}},{"$f":"+I8/MAX($I$8:$I$17)","v":{"$error":"#DIV/0!"}},{"$f":"1/EXP(J8)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($K$20*K8/$K$18,2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I8<$I$18,\"ja\",\"nee\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(N8=\"ja\",SUMIF($N$8:$N$17,\"ja\",$M$8:$M$17)/COUNTIF($N$8:$N$17,\"ja\"),M8)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Data!C10","v":"Fluvius Antwerpen"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"1/EXP(J9)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C11","v":"Fluvius Limburg"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C12","v":"Fluvius West"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C13","v":"Imewo"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C14","v":"Intergem"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C15","v":"Iveka"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C16","v":"Iverlek"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C17","v":"PBE"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C18","v":"Sibelgas"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,"gemiddelde:",{"$f":"AVERAGE(I8:I17)","v":{"$error":"#DIV/0!"}},"Totaal:",{"$f":"SUM(K8:K17)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(M8:M17)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(O8:O17)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"Totaal te verdelen punten:",null,{"$f":"+'Q%'!N15","v":616}]

{"sheet":"A2","index":4,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,12,5,14]]}
["Onderbrekingsduur middenspanning"]
[]
[null,null,"hh:mm:ss","Waarden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[null,null,null,"distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Puntenverdeling"]
[null,null,{"$f":"IF('Q%'!$K$16<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$16)","v":2020},{"$f":"IF('Q%'!$K$16<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$16+1)","v":2021},{"$f":"IF('Q%'!$K$16<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$16+2)","v":2022},{"$f":"IF('Q%'!$K$16<=3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$16+3)","v":2023},{"$f":"IF('Q%'!$K$16<=4,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$16+4)","v":"n.v.t."},{"$f":"IF('Q%'!$K$16<=5,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$16+5)","v":"n.v.t."},"Gemiddelde","Normalisatie","Formule inverse exponent",null," 1 basis","2 prestatie beter dan gemiddelde","3 herverdeling"]
[null,{"$f":"+Data!C9","v":"Gaselwest"},null,null,null,null,null,null,{"$f":"AVERAGE(C8:H8)","v":{"$error":"#DIV/0!"}},{"$f":"+I8/MAX($I$8:$I$17)","v":{"$error":"#DIV/0!"}},{"$f":"1/EXP(J8)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($K$20*K8/$K$18,2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I8<$I$18,\"ja\",\"nee\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(N8=\"ja\",SUMIF($N$8:$N$17,\"ja\",$M$8:$M$17)/COUNTIF($N$8:$N$17,\"ja\"),M8)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Data!C10","v":"Fluvius Antwerpen"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"1/EXP(J9)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C11","v":"Fluvius Limburg"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C12","v":"Fluvius West"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C13","v":"Imewo"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C14","v":"Intergem"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C15","v":"Iveka"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C16","v":"Iverlek"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C17","v":"PBE"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C18","v":"Sibelgas"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,"gemiddelde:",{"$f":"AVERAGE(I8:I17)","v":{"$error":"#DIV/0!"}},"Totaal:",{"$f":"SUM(K8:K17)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(M8:M17)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(O8:O17)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"Totaal te verdelen punten:",null,{"$f":"+'Q%'!N16","v":504}]

{"sheet":"A3","index":5,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,12,5,14]]}
["Onderbrekingsfrequentie laagspanning"]
[]
[null,null,null,"Waarden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[null,null,null,"distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Puntenverdeling"]
[null,null,{"$f":"IF('Q%'!$K$17<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$17)","v":2020},{"$f":"IF('Q%'!$K$17<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$17+1)","v":2021},{"$f":"IF('Q%'!$K$17<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$17+2)","v":2022},{"$f":"IF('Q%'!$K$17<=3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$17+3)","v":2023},{"$f":"IF('Q%'!$K$17<=4,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$17+4)","v":"n.v.t."},{"$f":"IF('Q%'!$K$17<=5,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$17+5)","v":"n.v.t."},"Gemiddelde","Normalisatie","Formule inverse exponent",null," 1 basis","2 prestatie beter dan gemiddelde","3 herverdeling"]
[null,{"$f":"+Data!C9","v":"Gaselwest"},null,null,null,null,null,null,{"$f":"AVERAGE(B8:H8)","v":{"$error":"#DIV/0!"}},{"$f":"+I8/MAX($I$8:$I$17)","v":{"$error":"#DIV/0!"}},{"$f":"1/EXP(J8)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($K$20*K8/$K$18,2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I8<$I$18,\"ja\",\"nee\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(N8=\"ja\",SUMIF($N$8:$N$17,\"ja\",$M$8:$M$17)/COUNTIF($N$8:$N$17,\"ja\"),M8)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Data!C10","v":"Fluvius Antwerpen"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"1/EXP(J9)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C11","v":"Fluvius Limburg"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C12","v":"Fluvius West"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C13","v":"Imewo"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C14","v":"Intergem"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C15","v":"Iveka"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C16","v":"Iverlek"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C17","v":"PBE"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C18","v":"Sibelgas"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,"gemiddelde:",{"$f":"AVERAGE(I8:I17)","v":{"$error":"#DIV/0!"}},"Totaal:",{"$f":"SUM(K8:K17)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(M8:M17)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(O8:O17)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"Totaal te verdelen punten:",null,{"$f":"+'Q%'!N17","v":264}]

{"sheet":"A4","index":6,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[5,12,5,14]]}
["Onderbrekingsduur laagspanning"]
[]
[null,null,"hh:mm:ss","Waarden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[null,null,null,"distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[null,null,null,null,null,null,null,"01:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Puntenverdeling"]
[null,null,{"$f":"IF('Q%'!$K$18<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$18)","v":2020},{"$f":"IF('Q%'!$K$18<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$18+1)","v":2021},{"$f":"IF('Q%'!$K$18<3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$18+2)","v":2022},{"$f":"IF('Q%'!$K$18<=3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$18+3)","v":2023},{"$f":"IF('Q%'!$K$18<=4,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$18+4)","v":"n.v.t."},{"$f":"IF('Q%'!$K$18<=5,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$18+5)","v":"n.v.t."},"Gemiddelde","Normalisatie","Formule inverse exponent",null," 1 basis","2 prestatie beter dan gemiddelde","3 herverdeling"]
[null,{"$f":"+Data!C9","v":"Gaselwest"},null,null,null,null,null,null,{"$f":"AVERAGE(C8:H8)","v":{"$error":"#DIV/0!"}},{"$f":"+I8/MAX($I$8:$I$17)","v":{"$error":"#DIV/0!"}},{"$f":"1/EXP(J8)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($K$20*K8/$K$18,2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(I8<$I$18,\"ja\",\"nee\")","v":{"$error":"#DIV/0!"}},{"$f":"IF(N8=\"ja\",SUMIF($N$8:$N$17,\"ja\",$M$8:$M$17)/COUNTIF($N$8:$N$17,\"ja\"),M8)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Data!C10","v":"Fluvius Antwerpen"},null,null,null,null,null,null,{"$f":"AVERAGE(C9:H9)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"1/EXP(J9)","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C11","v":"Fluvius Limburg"},null,null,null,null,null,null,{"$f":"AVERAGE(C10:H10)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C12","v":"Fluvius West"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C13","v":"Imewo"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C14","v":"Intergem"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C15","v":"Iveka"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C16","v":"Iverlek"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C17","v":"PBE"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C18","v":"Sibelgas"},null,null,null,null,null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,"gemiddelde:",{"$f":"AVERAGE(I8:I17)","v":{"$error":"#DIV/0!"}},"Totaal:",{"$f":"SUM(K8:K17)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(M8:M17)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(O8:O17)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,"Totaal te verdelen punten:",null,{"$f":"+'Q%'!N18","v":216}]

{"sheet":"D1","index":7,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":false,"merged":[[22,23,22,25],[40,23,40,25],[8,11,8,13],[27,11,27,13],[8,14,8,16],[27,14,27,16],[2,3,2,5],[3,3,3,5],[8,1,9,1],[8,2,8,4],[8,17,8,19],[4,3,4,5],[8,5,8,7],[27,1,28,1],[27,2,27,4],[27,17,27,19],[8,8,8,10],[27,8,27,10],[27,5,27,7]]}
["Forfaitaire vergoedingen wegens laattijdige aansluiting"]
[]
[null,null,null,"Waarden af te leiden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[null,null,null,"door distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[null,null,null,"=> Bedragen EUR gecorrigeerd voor indexatie"]
[]
[null,"Forfaitaire vergoedingen wegens laattijdige aansluiting voor de gereguleerde activiteit elektriciteit"]
[]
[null,null,{"$f":"IF('Q%'!$K$19<2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19)","v":2020},null,null,{"$f":"IF('Q%'!$K$19<2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19+1)","v":2021},null,null,{"$f":"IF('Q%'!$K$19<=2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19+2)","v":2022},null,null,{"$f":"IF('Q%'!$K$19<=3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19+3)","v":2023},null,null,{"$f":"IF('Q%'!$K$19<=4,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19+4)","v":"n.v.t."},null,null,{"$f":"IF('Q%'!$K$19<=5,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19+5)","v":"n.v.t."}]
[null,null,"Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting","Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting","Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting","Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting","Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting","Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting",null,"Gemiddelde EUR/gerealiseerde aansluiting",null,null,"Gemiddelde EUR/gerealiseerde aansluiting","Equivalente waarde","Score","Puntenverdeling"]
[null,{"$f":"+Data!C9","v":"Gaselwest"},null,null,{"$f":"IF(ISBLANK(C11),\"\",+C11/D11)","v":""},null,null,{"$f":"IF(ISBLANK(F11),\"\",+F11/G11)","v":""},null,null,{"$f":"IF(ISBLANK(I11),\"\",+I11/J11)","v":""},null,null,{"$f":"IF(ISBLANK(L11),\"\",+L11/M11)","v":""},null,null,{"$f":"IF(ISBLANK(O11),\"\",+O11/P11)","v":""},null,null,{"$f":"IF(ISBLANK(R11),\"\",+R11/S11)","v":""},null,{"$f":"+AVERAGE(E11,H11,K11,N11,Q11,T11)","v":{"$error":"#DIV/0!"}},null,{"$f":"+B11","v":"Gaselwest"},{"$f":"+V11","v":{"$error":"#DIV/0!"}},{"$f":"+Y11/$V$21","v":{"$error":"#DIV/0!"}},{"$f":"1-(Z11*0.6)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AA11*$AA$23/$AA$21,2)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Data!C10","v":"Fluvius Antwerpen"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$f":"+AVERAGE(E12,H12,K12,N12,Q12,T12)","v":{"$error":"#DIV/0!"}},null,{"$f":"+B12","v":"Fluvius Antwerpen"},{"$f":"+V12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"1-(Z12*0.6)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C11","v":"Fluvius Limburg"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Fluvius Limburg",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C12","v":"Fluvius West"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Fluvius West",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C13","v":"Imewo"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Imewo",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C14","v":"Intergem"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Intergem",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C15","v":"Iveka"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Iveka",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C16","v":"Iverlek"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Iverlek",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C17","v":"PBE"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"PBE",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C18","v":"Sibelgas"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Sibelgas",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum:",{"$f":"MAX(V11:V20)","v":{"$error":"#DIV/0!"}},null,null,null,"Totaal:",{"$f":"SUM(AA11:AA20)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AB11:AB20)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aantal te verdelen punten:",null,null,{"$f":"+'Q%'!N19","v":80}]
[]
[]
[null,"Forfaitaire vergoedingen wegens laattijdige aansluiting voor de gereguleerde activiteit aardgas"]
[]
[null,null,{"$f":"IF('Q%'!$K$19<2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19)","v":2020},null,null,{"$f":"IF('Q%'!$K$19<2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19+1)","v":2021},null,null,{"$f":"IF('Q%'!$K$19<=2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19+2)","v":2022},null,null,{"$f":"IF('Q%'!$K$19<=3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19+3)","v":2023},null,null,{"$f":"IF('Q%'!$K$19<=4,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19+4)","v":"n.v.t."},null,null,{"$f":"IF('Q%'!$K$19<=5,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$19+5)","v":"n.v.t."}]
[null,null,"Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting","Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting","Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting","Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting","Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting","Aantal EUR forfaitaire vergoedingen laattijdige aansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal aansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde aansluiting",null,"Gemiddelde EUR/gerealiseerde aansluiting",null,null,"Gemiddelde EUR/gerealiseerde aansluiting","Equivalente waarde","Score","Puntenverdeling"]
[null,{"$f":"+Data!C23","v":"Gaselwest"},null,null,{"$f":"IF(ISBLANK(C30),\"\",+C30/D30)","v":""},null,null,{"$f":"IF(ISBLANK(F30),\"\",+F30/G30)","v":""},null,null,{"$f":"IF(ISBLANK(I30),\"\",+I30/J30)","v":""},null,null,{"$f":"IF(ISBLANK(L30),\"\",+L30/M30)","v":""},null,null,{"$f":"IF(ISBLANK(O30),\"\",+O30/P30)","v":""},null,null,{"$f":"IF(ISBLANK(R30),\"\",+R30/S30)","v":""},null,{"$f":"+AVERAGE(E30,H30,K30,N30,Q30,T30)","v":{"$error":"#DIV/0!"}},null,{"$f":"+B30","v":"Gaselwest"},{"$f":"+V30","v":{"$error":"#DIV/0!"}},{"$f":"+Y30/$V$39","v":{"$error":"#DIV/0!"}},{"$f":"1-(Z30*0.6)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AA30*$AA$41/$AA$39,2)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Data!C24","v":"Fluvius Antwerpen"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Fluvius Antwerpen",{"$f":"+V31","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"1-(Z31*0.6)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C25","v":"Fluvius Limburg"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Fluvius Limburg",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C26","v":"Fluvius West"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Fluvius West",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C27","v":"Imewo"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Imewo",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C28","v":"Intergem"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Intergem",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C29","v":"Iveka"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Iveka",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C30","v":"Iverlek"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Iverlek",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C31","v":"Sibelgas"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Sibelgas",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum:",{"$f":"MAX(V30:V38)","v":{"$error":"#DIV/0!"}},null,null,null,"Totaal:",{"$f":"SUM(AA30:AA38)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AB30:AB38)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aantal te verdelen punten:",null,null,{"$f":"+'Q%'!P19","v":80}]

{"sheet":"D2","index":8,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":false,"merged":[[27,14,27,16],[8,8,8,10],[27,8,27,10],[22,23,22,25],[40,23,40,25],[8,11,8,13],[8,17,8,19],[27,17,27,19],[8,14,8,16],[2,3,2,5],[3,3,3,5],[8,1,9,1],[8,2,8,4],[8,5,8,7],[27,1,28,1],[4,3,4,5],[27,2,27,4],[27,5,27,7],[27,11,27,13]]}
["Forfaitaire vergoedingen wegens laattijdige heraansluiting"]
[]
[null,null,null,"Waarden af te leiden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[null,null,null,"door distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[null,null,null,"=> Bedragen EUR gecorrigeerd voor indexatie"]
[]
[null,"Forfaitaire vergoedingen wegens laattijdige heraansluiting voor de gereguleerde activiteit elektriciteit"]
[]
[null,null,{"$f":"IF('Q%'!$K$20<2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20)","v":2020},null,null,{"$f":"IF('Q%'!$K$20<2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20+1)","v":2021},null,null,{"$f":"IF('Q%'!$K$20<=2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20+2)","v":2022},null,null,{"$f":"IF('Q%'!$K$20<=3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20+3)","v":2023},null,null,{"$f":"IF('Q%'!$K$20<=4,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20+4)","v":"n.v.t."},null,null,{"$f":"IF('Q%'!$K$20<=5,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20+5)","v":"n.v.t."}]
[null,null,"Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting","Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting","Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting","Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting","Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting","Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting",null,"Gemiddelde EUR/gerealiseerde heraansluiting",null,null,"Gemiddelde EUR/gerealiseerde heraansluiting","Equivalente waarde","Score","Puntenverdeling"]
[null,{"$f":"+Data!C9","v":"Gaselwest"},null,null,{"$f":"IF(ISBLANK(C11),\"\",+C11/D11)","v":""},null,null,{"$f":"IF(ISBLANK(F11),\"\",+F11/G11)","v":""},null,null,{"$f":"IF(ISBLANK(I11),\"\",+I11/J11)","v":""},null,null,{"$f":"IF(ISBLANK(L11),\"\",+L11/M11)","v":""},null,null,{"$f":"IF(ISBLANK(O11),\"\",+O11/P11)","v":""},null,null,{"$f":"IF(ISBLANK(R11),\"\",+R11/S11)","v":""},null,{"$f":"+AVERAGE(E11,H11,K11,N11,Q11,T11)","v":{"$error":"#DIV/0!"}},null,{"$f":"+B11","v":"Gaselwest"},{"$f":"+V11","v":{"$error":"#DIV/0!"}},{"$f":"+V11/$V$21","v":{"$error":"#DIV/0!"}},{"$f":"1-(Z11*0.6)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AA11*$AA$23/$AA$21,2)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Data!C10","v":"Fluvius Antwerpen"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,{"$f":"IF(ISBLANK(R12),\"\",+R12/S12)","v":""},null,{"$f":"+AVERAGE(E12,H12,K12,N12,Q12,T12)","v":{"$error":"#DIV/0!"}},null,{"$f":"+B12","v":"Fluvius Antwerpen"},{"$f":"+V12","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"1-(Z12*0.6)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C11","v":"Fluvius Limburg"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Fluvius Limburg",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C12","v":"Fluvius West"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Fluvius West",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C13","v":"Imewo"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Imewo",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C14","v":"Intergem"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Intergem",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C15","v":"Iveka"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Iveka",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C16","v":"Iverlek"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Iverlek",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C17","v":"PBE"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"PBE",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C18","v":"Sibelgas"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,{"$f":"IF(ISBLANK(R20),\"\",+R20/S20)","v":""},null,{"$error":"#DIV/0!"},null,"Sibelgas",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum:",{"$f":"MAX(V11:V20)","v":{"$error":"#DIV/0!"}},null,null,null,"Totaal:",{"$f":"SUM(AA11:AA20)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AB11:AB20)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aantal te verdelen punten:",null,null,{"$f":"+'Q%'!N20","v":19.999999999999996}]
[]
[]
[null,"Forfaitaire vergoedingen wegens laattijdige heraansluiting voor de gereguleerde activiteit aardgas"]
[]
[null,null,{"$f":"IF('Q%'!$K$20<2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20)","v":2020},null,null,{"$f":"IF('Q%'!$K$20<2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20+1)","v":2021},null,null,{"$f":"IF('Q%'!$K$20<=2,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20+2)","v":2022},null,null,{"$f":"IF('Q%'!$K$20<=3,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20+3)","v":2023},null,null,{"$f":"IF('Q%'!$K$20<=4,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20+4)","v":"n.v.t."},null,null,{"$f":"IF('Q%'!$K$20<=5,\"n.v.t.\",'Q%'!$E$5-'Q%'!$K$20+5)","v":"n.v.t."}]
[null,null,"Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting","Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting","Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting","Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting","Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting","Aantal EUR forfaitaire vergoedingen laattijdige heraansluiting betaald in dat jaar (gecorrigeerd voor indexatie)","Aantal heraansluitingen gerealiseerd door de distributienetbeheerder in dat jaar","EUR/gerealiseerde heraansluiting",null,"Gemiddelde EUR/gerealiseerde heraansluiting",null,null,"Gemiddelde EUR/gerealiseerde heraansluiting","Equivalente waarde","Score","Puntenverdeling"]
[null,{"$f":"+Data!C23","v":"Gaselwest"},null,null,{"$f":"IF(ISBLANK(C30),\"\",+C30/D30)","v":""},null,null,{"$f":"IF(ISBLANK(F30),\"\",+F30/G30)","v":""},null,null,{"$f":"IF(ISBLANK(I30),\"\",+I30/J30)","v":""},null,null,{"$f":"IF(ISBLANK(L30),\"\",+L30/M30)","v":""},null,null,{"$f":"IF(ISBLANK(O30),\"\",+O30/P30)","v":""},null,null,{"$f":"IF(ISBLANK(R30),\"\",+R30/S30)","v":""},null,{"$f":"+AVERAGE(E30,H30,K30,N30,Q30,T30)","v":{"$error":"#DIV/0!"}},null,{"$f":"+B30","v":"Gaselwest"},{"$f":"+V30","v":{"$error":"#DIV/0!"}},{"$f":"+V30/$V$39","v":{"$error":"#DIV/0!"}},{"$f":"1-(Z30*0.6)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AA30*$AA$41/$AA$39,2)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Data!C24","v":"Fluvius Antwerpen"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Fluvius Antwerpen",{"$f":"+V31","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"1-(Z31*0.6)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C25","v":"Fluvius Limburg"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Fluvius Limburg",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C26","v":"Fluvius West"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Fluvius West",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C27","v":"Imewo"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Imewo",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C28","v":"Intergem"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Intergem",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C29","v":"Iveka"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Iveka",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C30","v":"Iverlek"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Iverlek",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"+Data!C31","v":"Sibelgas"},null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,null,"",null,{"$error":"#DIV/0!"},null,"Sibelgas",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum:",{"$f":"MAX(V30:V38)","v":{"$error":"#DIV/0!"}},null,null,null,"Totaal:",{"$f":"SUM(AA30:AA38)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AB30:AB38)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aantal te verdelen punten:",null,null,{"$f":"+'Q%'!P20","v":19.999999999999996}]

{"sheet":"Sorteren","index":9,"n_rows":40,"n_cols":16,"rows_kept":40,"cut":false,"hidden":false,"merged":[[12,2,12,8],[29,2,29,4]]}
["Totaalscore per distributienetbeheerder"]
[]
[null,"In onderstaande tabellen wordt een overzicht gegeven van de score op iedere kwaliteitsindicator per distributienetbeheerder "]
[null,"en per gereguleerde activiteit."]
[null,"Op die manier kan voor iedere distributienetbeheerder de totaalscore worden berekend, die vervolgens in rekening kan worden"]
[null,"genomen voor de bepaling van de kwaliteitsvergoeding in tabblad 'Berekeningsmodel Q'."]
[]
[]
[]
[null,"Totaalscore voor de gereguleerde activiteit elektriciteit"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"manueel overzetten"]
[null,null,"Punten op kwaliteitsindicator"]
[null,"Distributienetbeheerder","A1","A2","A3","A4","D1","D2","Totaal punten",null,null,null,"Distributienetbeheerder","Totaal punten",null,"hoog"]
[1,{"$f":"+Data!C9","v":"Gaselwest"},{"$f":"VLOOKUP(B15,'A1'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B15,'A2'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B15,'A3'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B15,'A4'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B15,'D1'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B15,'D2'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(SUM(C15:H15),2)","v":{"$error":"#DIV/0!"}},null,null,null,"Fluvius Limburg"]
[2,{"$f":"+Data!C10","v":"Fluvius Antwerpen"},{"$f":"VLOOKUP(B16,'A1'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B16,'A2'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B16,'A3'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B16,'A4'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B16,'D1'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B16,'D2'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"Gaselwest"]
[3,{"$f":"+Data!C11","v":"Fluvius Limburg"},{"$f":"VLOOKUP(B17,'A1'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B17,'A2'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B17,'A3'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B17,'A4'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B17,'D1'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B17,'D2'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"Imewo"]
[4,{"$f":"+Data!C12","v":"Fluvius West"},{"$f":"VLOOKUP(B18,'A1'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B18,'A2'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B18,'A3'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B18,'A4'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B18,'D1'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B18,'D2'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"Fluvius Antwerpen"]
[5,{"$f":"+Data!C13","v":"Imewo"},{"$f":"VLOOKUP(B19,'A1'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B19,'A2'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B19,'A3'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B19,'A4'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B19,'D1'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B19,'D2'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"Iveka"]
[6,{"$f":"+Data!C14","v":"Intergem"},{"$f":"VLOOKUP(B20,'A1'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B20,'A2'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B20,'A3'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B20,'A4'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B20,'D1'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B20,'D2'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"Intergem"]
[7,{"$f":"+Data!C15","v":"Iveka"},{"$f":"VLOOKUP(B21,'A1'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B21,'A2'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B21,'A3'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B21,'A4'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B21,'D1'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B21,'D2'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"Fluvius West"]
[8,{"$f":"+Data!C16","v":"Iverlek"},{"$f":"VLOOKUP(B22,'A1'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B22,'A2'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B22,'A3'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B22,'A4'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B22,'D1'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B22,'D2'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"Iverlek"]
[9,{"$f":"+Data!C17","v":"PBE"},{"$f":"VLOOKUP(B23,'A1'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B23,'A2'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B23,'A3'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B23,'A4'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B23,'D1'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B23,'D2'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"PBE"]
[10,{"$f":"+Data!C18","v":"Sibelgas"},{"$f":"VLOOKUP(B24,'A1'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B24,'A2'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B24,'A3'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B24,'A4'!$B$8:$O$17,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B24,'D1'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B24,'D2'!$X$11:$AB$20,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,"Sibelgas",null,null,"laag"]
[]
[]
[null,"Totaalscore voor de gereguleerde activiteit aardgas"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"manueel overzetten"]
[null,null,"Punten op kwaliteitsindicator"]
[null,"Distributienetbeheerder","D1","D2","Totaal punten",null,null,null,null,null,null,null,"Distributienetbeheerder","Totaal punten"]
[1,{"$f":"+Data!C23","v":"Gaselwest"},{"$f":"VLOOKUP(B32,'D1'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B32,'D2'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(SUM(C32:D32),2)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"Intergem",null,null,"hoog"]
[2,{"$f":"+Data!C24","v":"Fluvius Antwerpen"},{"$f":"VLOOKUP(B33,'D1'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B33,'D2'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Sibelgas"]
[3,{"$f":"+Data!C25","v":"Fluvius Limburg"},{"$f":"VLOOKUP(B34,'D1'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B34,'D2'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Fluvius Limburg"]
[4,{"$f":"+Data!C26","v":"Fluvius West"},{"$f":"VLOOKUP(B35,'D1'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B35,'D2'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Iveka"]
[5,{"$f":"+Data!C27","v":"Imewo"},{"$f":"VLOOKUP(B36,'D1'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B36,'D2'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Imewo"]
[6,{"$f":"+Data!C28","v":"Intergem"},{"$f":"VLOOKUP(B37,'D1'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B37,'D2'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Iverlek"]
[7,{"$f":"+Data!C29","v":"Iveka"},{"$f":"VLOOKUP(B38,'D1'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B38,'D2'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Fluvius West"]
[8,{"$f":"+Data!C30","v":"Iverlek"},{"$f":"VLOOKUP(B39,'D1'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B39,'D2'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Fluvius Antwerpen"]
[9,{"$f":"+Data!C31","v":"Sibelgas"},{"$f":"VLOOKUP(B40,'D1'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP(B40,'D2'!$X$30:$AB$38,5,FALSE)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},null,null,null,null,null,null,null,"Gaselwest",null,null,"laag"]

{"sheet":"Berekeningsmodel Q E","index":10,"n_rows":25,"n_cols":234,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,26,29,32],[7,26,7,32],[5,34,5,39],[5,1,5,5],[0,0,0,5],[7,19,7,25],[3,3,3,4],[5,15,5,17],[23,19,29,25]]}
["Berekeningsmodel verdeling kwaliteitsbedrag elektriciteit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"elektriciteit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aardgas"]
[]
[null,null,"Gereguleerde activiteit:","elektriciteit"]
[]
[null,{"$f":"\"Impact kwaliteitsprestaties in periode \"&MIN('Q%'!I15:I20)&\"-\"&'Q%'!E5-1&\" naar toegelaten inkomen in reguleringsperiode \"&'Q%'!E9&\"-\"&MAX('Q%'!E9:K9)","v":"Impact kwaliteitsprestaties in periode 2020-2023 naar toegelaten inkomen in reguleringsperiode 2025-2028"},null,null,null,null,null,"Bijdrage aan kwaliteitsbedrag Q",null,null,"Recuperatie uit kwaliteitsbedrag Q",null,null,null,null,"Invloed kwaliteitsbedrag",null,null,null,"Beperking impact cap/floor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q-factor"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marge tot cap",null,null,null,null,null,null,{"$f":"\"Marge tot floor\"","v":"Marge tot floor"}]
[null,"Distributienetbeheerder","Totaal aantal punten voor kwaliteitsprestatie (hoog>laag)",{"$f":"\"Aantal actieve toegangspunten \"&D4&\" 1 jan.\"&\" \"&'Q%'!E5","v":"Aantal actieve toegangspunten elektriciteit 1 jan. 2024"},{"$f":"\"Oorspronkelijk toegelaten inkomen endogene kosten \"&D4&\" \"&'Q%'!E9&\" (zonder q-factor)\"","v":"Oorspronkelijk toegelaten inkomen endogene kosten elektriciteit 2025 (zonder q-factor)"},null,null,"Bijdrage aan het te herverdelen kwaliteitsbedrag Q (negatief bedrag)","uitgedrukt per toegangspunt",null,"gewogen gemiddelde prestatie volgens aantal toegangspunten na reductie","aandeel in %","Ontvangst uit verdeling bedrag Q (positief bedrag)","uitgedrukt per toegangspunt",null,{"$f":"+E9","v":"Oorspronkelijk toegelaten inkomen endogene kosten elektriciteit 2025 (zonder q-factor)"},"- bijdrage Q + verdeling Q","Impact Q/TI",null,"bedrag boven cap af te staan (positieve waarde)","bedrag mogelijk te ontvangen (positieve waarde)",{"$f":"+D9","v":"Aantal actieve toegangspunten elektriciteit 1 jan. 2024"},"potentieel+/tp","score","bedrag ontvangen (positieve waarde)","Voorlopige impact na toepassing cap","bedrag onder floor te ontvangen (positieve waarde)","bedrag mogelijk af te staan (positieve waarde)",{"$f":"+V9","v":"Aantal actieve toegangspunten elektriciteit 1 jan. 2024"},"potentieel-/tp","score","bedrag af te staan (negatieve waarde)","Voorlopige impact na toepassing cap",null,{"$f":"\"Oorspronkelijk toegelaten inkomen niet-exogene kosten \"&D4","v":"Oorspronkelijk toegelaten inkomen niet-exogene kosten elektriciteit"},{"$f":"\"Gecorrigeerd toegelaten inkomen niet-exogene kosten \"&D4","v":"Gecorrigeerd toegelaten inkomen niet-exogene kosten elektriciteit"},{"$f":"\"Effect kwaliteit dienstverlening op TI jaar \"&'Q%'!E9","v":"Effect kwaliteit dienstverlening op TI jaar 2025"},{"$f":"\"basisgedeelte endoge kosten jaar \"&'Q%'!E9","v":"basisgedeelte endoge kosten jaar 2025"},{"$f":"\"qi-waarde \"&'Q%'!$E$9&\"-\"&('Q%'!$E$9+'Q%'!$C$9-1)","v":"qi-waarde 2025-2028"},"Impact per toegangspunt"]
[1,{"$f":"+Sorteren!M15","v":"Fluvius Limburg"},{"$f":"+Sorteren!N15","v":0},{"$f":"VLOOKUP($B10,Data!$C$9:$J$18,8,FALSE)","v":0},{"$f":"VLOOKUP($B10,Data!$C$9:$K$18,9,FALSE)","v":0},null,null,{"$f":"ROUND(-$E$23*D10/$D$20,2)","v":{"$error":"#DIV/0!"}},{"$f":"+H10/D10","v":{"$error":"#DIV/0!"}},null,{"$f":"+C10*D10/$D$20","v":{"$error":"#DIV/0!"}},{"$f":"+K10/$K$20","v":{"$error":"#DIV/0!"}},{"$f":"+ROUND(L10*$E$23,2)","v":{"$error":"#DIV/0!"}},{"$f":"+M10/D10","v":{"$error":"#DIV/0!"}},null,0,{"$f":"+H10+M10","v":{"$error":"#DIV/0!"}},{"$f":"+Q10/P10","v":{"$error":"#DIV/0!"}},null,{"$f":"MAX((R10-capelek)*P10,0)","v":{"$error":"#DIV/0!"}},{"$f":"MAX((capelek-R10)*P10,0)","v":{"$error":"#DIV/0!"}},0,{"$f":"+U10/V10","v":{"$error":"#DIV/0!"}},{"$f":"+C10","v":0},0,{"$f":"+(P10+Q10-T10+Y10)/P10-1","v":{"$error":"#DIV/0!"}},{"$f":"MAX((-capelek-Z10)*E10,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(-capelek<Z10,ROUND((Z10+capelek)*E10,2),0)","v":{"$error":"#DIV/0!"}},0,{"$f":"+AB10/AC10","v":{"$error":"#DIV/0!"}},{"$f":"+X10","v":0},0,{"$f":"+(P10+Q10-T10+Y10+AA10+AF10)/E10-1","v":{"$error":"#DIV/0!"}},null,{"$f":"+E10","v":0},{"$f":"+P10+Q10-T10+Y10+AA10+AF10","v":{"$error":"#DIV/0!"}},{"$f":"+AJ10-AI10","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($B10,Data!$C$9:$L$18,10,FALSE)","v":0},{"$f":"ROUND(AK10/AL10,6)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((AJ10-AI10)/D10,2)","v":{"$error":"#DIV/0!"}}]
[2,{"$f":"+Sorteren!M16","v":"Gaselwest"},{"$f":"+Sorteren!N16","v":0},{"$f":"VLOOKUP($B11,Data!$C$9:$J$18,8,FALSE)","v":0},{"$f":"VLOOKUP($B11,Data!$C$9:$K$18,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$f":"+Q11/P11","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$f":"+(P11+Q11-T11+Y11)/P11-1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$f":"+P11+Q11-T11+Y11+AA11+AF11","v":{"$error":"#DIV/0!"}},{"$f":"+AJ11-AI11","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($B11,Data!$C$9:$L$18,10,FALSE)","v":0},{"$f":"ROUND(AK11/AL11,6)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[3,{"$f":"+Sorteren!M17","v":"Imewo"},{"$f":"+Sorteren!N17","v":0},{"$f":"VLOOKUP($B12,Data!$C$9:$J$18,8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Data!$C$9:$K$18,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$f":"+U12/V12","v":{"$error":"#DIV/0!"}},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$f":"+AB12/AC12","v":{"$error":"#DIV/0!"}},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B12,Data!$C$9:$L$18,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[4,{"$f":"+Sorteren!M18","v":"Fluvius Antwerpen"},{"$f":"+Sorteren!N18","v":0},{"$f":"VLOOKUP($B13,Data!$C$9:$J$18,8,FALSE)","v":0},{"$f":"VLOOKUP($B13,Data!$C$9:$K$18,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$f":"+U13/V13","v":{"$error":"#DIV/0!"}},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$f":"+AB13/AC13","v":{"$error":"#DIV/0!"}},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B13,Data!$C$9:$L$18,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[5,{"$f":"+Sorteren!M19","v":"Iveka"},{"$f":"+Sorteren!N19","v":0},{"$f":"VLOOKUP($B14,Data!$C$9:$J$18,8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Data!$C$9:$K$18,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B14,Data!$C$9:$L$18,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[6,{"$f":"+Sorteren!M20","v":"Intergem"},{"$f":"+Sorteren!N20","v":0},{"$f":"VLOOKUP($B15,Data!$C$9:$J$18,8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Data!$C$9:$K$18,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B15,Data!$C$9:$L$18,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[7,{"$f":"+Sorteren!M21","v":"Fluvius West"},{"$f":"+Sorteren!N21","v":0},{"$f":"VLOOKUP($B16,Data!$C$9:$J$18,8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Data!$C$9:$K$18,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B16,Data!$C$9:$L$18,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[8,{"$f":"+Sorteren!M22","v":"Iverlek"},{"$f":"+Sorteren!N22","v":0},{"$f":"VLOOKUP($B17,Data!$C$9:$J$18,8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Data!$C$9:$K$18,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B17,Data!$C$9:$L$18,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[9,{"$f":"+Sorteren!M23","v":"PBE"},{"$f":"+Sorteren!N23","v":0},{"$f":"VLOOKUP($B18,Data!$C$9:$J$18,8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Data!$C$9:$K$18,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B18,Data!$C$9:$L$18,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[11,{"$f":"+Sorteren!M24","v":"Sibelgas"},{"$f":"+Sorteren!N24","v":0},{"$f":"VLOOKUP($B19,Data!$C$9:$J$18,8,FALSE)","v":0},{"$f":"VLOOKUP($B19,Data!$C$9:$K$18,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B19,Data!$C$9:$L$18,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Totaal:",null,{"$f":"SUM(D10:D19)","v":0},{"$f":"SUM(E10:E19)","v":0},null,null,{"$f":"SUM(H10:H19)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(K10:K19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L10:L19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M10:M19)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"SUM(Q10:Q19)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(T10:T19)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"SUM(Y10:Y19)","v":0},null,{"$f":"SUM(AA10:AA19)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"SUM(AF10:AF19)","v":0},null,null,{"$f":"SUM(AI10:AI19)","v":0},{"$f":"SUM(AJ10:AJ19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AK10:AK19)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AL10:AL19)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y10:Y19)-T20","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"+AF20+AA20","v":{"$error":"#DIV/0!"}}]
[null,null,null," %TI in balans voor kwaliteitsprikkel:",{"$f":"+'Q%'!N27","v":7.9699999999999997E-3},null,null,null,null,null,null,null,null,null,null,null,"cap elek:",{"$f":"+E25","v":1.0630000000000001E-2},null,null,null,null,null,null,"floor elek:",{"$f":"-capelek","v":-1.0630000000000001E-2},null,null,null,null,null,null,{"$f":"capelek","v":1.0630000000000001E-2}]
[null,null,null,"Te verdelen kwaliteitsbedrag Q:",{"$f":"+E22*E20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De overdracht vindt plaats in volgorde van de geleverde kwaliteitsprestaties, waarbij de overige distributienetbeheerder die het best presteerde als eerste de over te dragen inkomsten mag ontvangen. De overdracht naar zo’n ontvangende distributienetbeheerder stopt altijd zodra zijn toegelaten inkomen ook de maximumgrens (cap) heeft bereikt. Indien twee of meer overige en ontvangende distributienetbeheerders eenzelfde kwaliteitsscore hebben behaald, dan wordt het over te dragen inkomen aanvankelijk tegelijk aan beiden en pro rata hun aantal actieve toegangspunten toegewezen.",null,null,null,null,null,null,"Deze overdracht vindt plaats in volgorde van de geleverde kwaliteitsprestaties, waarbij de overige distributienetbeheerder die het slechtst presteerde als eerste inkomsten zal afstaan. De overdracht vanuit zo’n inkomsten overdragende overige distributienetbeheerder stopt altijd zodra zijn eigen toegelaten inkomen ook de minimumgrens (negatieve cap) heeft bereikt. Indien twee of meer overige en overdragende distributienetbeheerders eenzelfde kwaliteitsscore hebben behaald, dan wordt het over te dragen inkomen aanvankelijk tegelijk uit beiden en pro rata hun aantal actieve toegangspunten afgestaan."]
[null,null,null,"cap/floor/jaar in reguleringsperiode:",{"$f":"+capelek","v":1.0630000000000001E-2}]

{"sheet":"Berekeningsmodel Q G","index":11,"n_rows":24,"n_cols":235,"rows_kept":24,"cut":false,"hidden":false,"merged":[[22,19,28,25],[7,26,7,32],[22,26,28,32],[0,0,0,5],[3,3,3,4],[5,15,5,17],[7,19,7,25],[5,1,5,5]]}
["Berekeningsmodel verdeling kwaliteitsbedrag aardgas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"elektriciteit"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"aardgas"]
[]
[null,null,"Gereguleerde activiteit:","aardgas"]
[]
[null,{"$f":"\"Impact kwaliteitsprestaties in periode \"&MIN('Q%'!I15:I20)&\"-\"&'Q%'!E5-1&\" naar toegelaten inkomen in reguleringsperiode \"&'Q%'!E9&\"-\"&MAX('Q%'!E9:K9)","v":"Impact kwaliteitsprestaties in periode 2020-2023 naar toegelaten inkomen in reguleringsperiode 2025-2028"},null,null,null,null,null,"Bijdrage aan kwaliteitsbedrag Q",null,null,"Recuperatie uit kwaliteitsbedrag Q",null,null,null,null,"Netto invloed kwaliteitsbedrag",null,null,null,"Beperking impact cap/floor",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"q-factor"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marge tot cap",null,null,null,null,null,null,{"$f":"\"Marge tot floor\"","v":"Marge tot floor"}]
[null,"Distributienetbeheerder","Totaal aantal punten voor kwaliteitsprestatie (hoog>laag)",{"$f":"\"Aantal actieve toegangspunten \"&D4&\" 1 jan.\"&\" \"&'Q%'!E5","v":"Aantal actieve toegangspunten aardgas 1 jan. 2024"},{"$f":"\"Oorspronkelijk toegelaten inkomen endogene kosten \"&D4&\" \"&'Q%'!E9&\" (zonder q-factor)\"","v":"Oorspronkelijk toegelaten inkomen endogene kosten aardgas 2025 (zonder q-factor)"},null,null,"Bijdrage aan het te herverdelen kwaliteitsbedrag Q","uitgedrukt per toegangspunt",null,"gewogen gemiddelde prestatie volgens aantal toegangspunten na reductie","aandeel in %","Ontvangst uit verdeling bedrag Q","uitgedrukt per toegangspunt",null,{"$f":"+E9","v":"Oorspronkelijk toegelaten inkomen endogene kosten aardgas 2025 (zonder q-factor)"},"- bijdrage Q + verdeling Q","Impact Q/TI",null,"bedrag boven cap af te staan (positieve waarde)","bedrag mogelijk te ontvangen (positieve waarde)",{"$f":"+D9","v":"Aantal actieve toegangspunten aardgas 1 jan. 2024"},"potentieel+/tp","score","bedrag ontvangen (positieve waarde)","Voorlopige impact na toepassing cap","bedrag onder floor te ontvangen (positieve waarde)","bedrag mogelijk af te staan (positieve waarde)",{"$f":"+V9","v":"Aantal actieve toegangspunten aardgas 1 jan. 2024"},"potentieel-/tp","score","bedrag af te staan (negatieve waarde)","Voorlopige impact na toepassing cap",null,{"$f":"\"Oorspronkelijk toegelaten inkomen niet-exogene kosten \"&D4","v":"Oorspronkelijk toegelaten inkomen niet-exogene kosten aardgas"},{"$f":"\"Gecorrigeerd toegelaten inkomen niet-exogene kosten \"&D4","v":"Gecorrigeerd toegelaten inkomen niet-exogene kosten aardgas"},{"$f":"\"Effect kwaliteit dienstverlening op TI jaar \"&'Q%'!E9","v":"Effect kwaliteit dienstverlening op TI jaar 2025"},{"$f":"\"basisgedeelte endoge kosten jaar \"&'Q%'!E9","v":"basisgedeelte endoge kosten jaar 2025"},{"$f":"\"qi-waarde \"&'Q%'!$E$9&\"-\"&('Q%'!$E$9+'Q%'!$C$9-1)","v":"qi-waarde 2025-2028"},"Impact per toegangspunt"]
[1,{"$f":"+Sorteren!M32","v":"Intergem"},{"$f":"+Sorteren!N32","v":0},{"$f":"VLOOKUP($B10,Data!$C$23:$J$31,8,FALSE)","v":0},{"$f":"VLOOKUP($B10,Data!$C$23:$K$31,9,FALSE)","v":0},null,null,{"$f":"ROUND(-$E$22*D10/$D$19,2)","v":{"$error":"#DIV/0!"}},{"$f":"+H10/D10","v":{"$error":"#DIV/0!"}},null,{"$f":"+C10*D10/$D$19","v":{"$error":"#DIV/0!"}},{"$f":"+K10/$K$19","v":{"$error":"#DIV/0!"}},{"$f":"+L10*$E$22","v":{"$error":"#DIV/0!"}},{"$f":"+M10/D10","v":{"$error":"#DIV/0!"}},null,0,{"$f":"+H10+M10","v":{"$error":"#DIV/0!"}},{"$f":"+Q10/P10","v":{"$error":"#DIV/0!"}},null,{"$f":"MAX((R10-capgas)*P10,0)","v":{"$error":"#DIV/0!"}},{"$f":"MAX((capgas-R10)*P10,0)","v":{"$error":"#DIV/0!"}},0,{"$f":"+U10/V10","v":{"$error":"#DIV/0!"}},{"$f":"+C10","v":0},0,{"$f":"+(P10+Q10-T10+Y10)/E10-1","v":{"$error":"#DIV/0!"}},{"$f":"MAX((-capgas-Z10)*E10,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(-capgas<Z10,ROUND((Z10+capgas)*E10,2),0)","v":{"$error":"#DIV/0!"}},0,{"$f":"+AB10/AC10","v":{"$error":"#DIV/0!"}},{"$f":"+X10","v":0},0,{"$f":"+(P10+Q10-T10+Y10+AA10+AF10)/E10-1","v":{"$error":"#DIV/0!"}},null,{"$f":"+E10","v":0},{"$f":"+P10+Q10-T10+Y10+AA10+AF10","v":{"$error":"#DIV/0!"}},{"$f":"+AJ10-AI10","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($B10,Data!$C$23:$L$31,10,FALSE)","v":0},{"$f":"ROUND(AK10/AL10,6)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND((AJ10-AI10)/D10,2)","v":{"$error":"#DIV/0!"}}]
[2,{"$f":"+Sorteren!M33","v":"Sibelgas"},{"$f":"+Sorteren!N33","v":0},{"$f":"VLOOKUP($B11,Data!$C$23:$J$31,8,FALSE)","v":0},{"$f":"VLOOKUP($B11,Data!$C$23:$K$31,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$f":"+Q11/P11","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$f":"+U11/V11","v":{"$error":"#DIV/0!"}},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$f":"+AB11/AC11","v":{"$error":"#DIV/0!"}},0,0,{"$error":"#DIV/0!"},null,0,{"$f":"+P11+Q11-T11+Y11+AA11+AF11","v":{"$error":"#DIV/0!"}},{"$f":"+AJ11-AI11","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($B11,Data!$C$23:$L$31,10,FALSE)","v":0},{"$f":"ROUND(AK11/AL11,6)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[3,{"$f":"+Sorteren!M34","v":"Fluvius Limburg"},{"$f":"+Sorteren!N34","v":0},{"$f":"VLOOKUP($B12,Data!$C$23:$J$31,8,FALSE)","v":0},{"$f":"VLOOKUP($B12,Data!$C$23:$K$31,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B12,Data!$C$23:$L$31,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[4,{"$f":"+Sorteren!M35","v":"Iveka"},{"$f":"+Sorteren!N35","v":0},{"$f":"VLOOKUP($B13,Data!$C$23:$J$31,8,FALSE)","v":0},{"$f":"VLOOKUP($B13,Data!$C$23:$K$31,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B13,Data!$C$23:$L$31,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[5,{"$f":"+Sorteren!M36","v":"Imewo"},{"$f":"+Sorteren!N36","v":0},{"$f":"VLOOKUP($B14,Data!$C$23:$J$31,8,FALSE)","v":0},{"$f":"VLOOKUP($B14,Data!$C$23:$K$31,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B14,Data!$C$23:$L$31,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[6,{"$f":"+Sorteren!M37","v":"Iverlek"},{"$f":"+Sorteren!N37","v":0},{"$f":"VLOOKUP($B15,Data!$C$23:$J$31,8,FALSE)","v":0},{"$f":"VLOOKUP($B15,Data!$C$23:$K$31,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B15,Data!$C$23:$L$31,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[7,{"$f":"+Sorteren!M38","v":"Fluvius West"},{"$f":"+Sorteren!N38","v":0},{"$f":"VLOOKUP($B16,Data!$C$23:$J$31,8,FALSE)","v":0},{"$f":"VLOOKUP($B16,Data!$C$23:$K$31,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B16,Data!$C$23:$L$31,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[8,{"$f":"+Sorteren!M39","v":"Fluvius Antwerpen"},{"$f":"+Sorteren!N39","v":0},{"$f":"VLOOKUP($B17,Data!$C$23:$J$31,8,FALSE)","v":0},{"$f":"VLOOKUP($B17,Data!$C$23:$K$31,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B17,Data!$C$23:$L$31,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[9,{"$f":"+Sorteren!M40","v":"Gaselwest"},{"$f":"+Sorteren!N40","v":0},{"$f":"VLOOKUP($B18,Data!$C$23:$J$31,8,FALSE)","v":0},{"$f":"VLOOKUP($B18,Data!$C$23:$K$31,9,FALSE)","v":0},null,null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},null,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"VLOOKUP($B18,Data!$C$23:$L$31,10,FALSE)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Totaal:",null,{"$f":"SUM(D10:D18)","v":0},{"$f":"SUM(E10:E18)","v":0},null,null,{"$f":"SUM(H10:H18)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(K10:K18)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L10:L18)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(M10:M18)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"SUM(Q10:Q18)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(T10:T18)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"SUM(Y10:Y18)","v":0},null,{"$f":"SUM(AA10:AA18)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"SUM(AF10:AF18)","v":0},null,null,{"$f":"SUM(AI10:AI18)","v":0},{"$f":"SUM(AJ10:AJ18)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AK10:AK18)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(AL10:AL18)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y10:Y18)-T19","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"+AF19+AA19","v":{"$error":"#DIV/0!"}}]
[null,null,null," %TI in balans voor kwaliteitsprikkel:",{"$f":"+'Q%'!P27","v":4.6999999999999999E-4},null,null,null,null,null,null,null,null,null,null,null,"cap gas:",{"$f":"+capgas","v":6.3000000000000003E-4},null,null,null,null,null,null,"floor gas:",{"$f":"-capgas","v":-6.3000000000000003E-4},null,null,null,null,null,null,{"$f":"capgas","v":6.3000000000000003E-4}]
[null,null,null,"Te verdelen kwaliteitsbedrag Q:",{"$f":"+E21*E19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"De overdracht vindt plaats in volgorde van de geleverde kwaliteitsprestaties, waarbij de overige distributienetbeheerder die het best presteerde als eerste de over te dragen inkomsten mag ontvangen. De overdracht naar zo’n ontvangende distributienetbeheerder stopt altijd zodra zijn toegelaten inkomen ook de maximumgrens (cap) heeft bereikt. Indien twee of meer overige en ontvangende distributienetbeheerders eenzelfde kwaliteitsscore hebben behaald, dan wordt het over te dragen inkomen aanvankelijk tegelijk aan beiden en pro rata hun aantal actieve toegangspunten toegewezen.",null,null,null,null,null,null,"Deze overdracht vindt plaats in volgorde van de geleverde kwaliteitsprestaties, waarbij de overige distributienetbeheerder die het slechtst presteerde als eerste inkomsten zal afstaan. De overdracht vanuit zo’n inkomsten overdragende overige distributienetbeheerder stopt altijd zodra zijn eigen toegelaten inkomen ook de minimumgrens (negatieve cap) heeft bereikt. Indien twee of meer overige en overdragende distributienetbeheerders eenzelfde kwaliteitsscore hebben behaald, dan wordt het over te dragen inkomen aanvankelijk tegelijk uit beiden en pro rata hun aantal actieve toegangspunten afgestaan."]
[null,null,null,"cap/floor/jaar in reguleringsperiode:",{"$f":"+capgas","v":6.3000000000000003E-4}]