{"text_format":"3","workbook":"xls","n_sheets":19,"sheets":["Instructies","Q%","A1","A2","A3","A4","B1","D1","D2","E1","E2","Totaalscore","Data","Berekeningsmodel Q E","Berekeningsmodel Q G","U G","U E","O G","O E"],"not_rendered":{"charts":11,"macros":1,"external_links":2,"defined_names":16},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instructies","index":0,"n_rows":27,"n_cols":1,"rows_kept":27,"flags":["formulas_cached_only"]}
["Invulinstructies VREG"]
[]
["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. Vervolgens invullen kwaliteitsdata per kwaliteitsindicator door de VREG:"]
["a. Tabbladen 'A1', 'A2' ,'A3' en 'A4' volgens rapportering distributienetbeheerders;"]
["b. Tabblad 'B1' volgens rapportering Ombudsdienst voor Energie;"]
["d. Tabbladen 'D1' en 'D2' volgens rapportering distributienetbeheerders;"]
["e. Tabbladen 'E1' en 'E2' volgens evaluatie panel."]
["3. Verificatie formules door de VREG in tabbladen 'A1' t.e.m. 'D2':"]
["a. Nazicht of gemiddelden correct berekend blijven (0-waarden versus blanco cellen);"]
["b. Tabblad B1 uitvoeren macro’s voor puntentoekenning."]
["4. Tabblad 'Totaalscore': "]
["a. Uitvoeren macro door de VREG teneinde de distributienetbeheerders te ordenen."]
["5. 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 niet-exogene kosten' in te vullen door de VREG volgens definitieve berekening VREG."]
["6. Tabblad 'Berekeningsmodel Q E'"]
["a. Uitvoeren macro 'cap/floor' door de VREG;"]
["7.  Tabblad 'Berekeningsmodel Q G'"]
["a. Uitvoeren macro 'cap/floor' door de VREG;"]
[]
[]
["De waarden ingevuld in de gele, blauwe en rode velden in dit bestand zijn fictief en bedoeld voor transparantiedoeleinden. Eventuele gelijkenissen met bestaande distributienetbeheerders of werkmaatschappijen is toeval."]
["Versie 15/2/2016."]

{"sheet":"Q%","index":1,"n_rows":34,"n_cols":16,"rows_kept":34,"merged":[[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],[10,13,13,13],[10,15,13,15],[12,8,12,9],[14,3,17,3],[14,4,17,4],[14,9,22,9],[14,15,17,15],[19,4,20,4],[21,2,21,3],[21,4,22,4],[22,2,22,3]],"flags":["formulas_cached_only"]}
["Waardering kwaliteitsindicatoren distributienetbeheerders Vlaanderen"]
[]
[null,"Waarden in blauwe cellen in te vullen door de VREG."]
[]
[{"$nulls":3},"Het jaar waarin de q-factor wordt bepaald:",2021]
[]
[]
[{"$nulls":4},"jaar 1","jaar 2","jaar 3","jaar 4","jaar 5","jaar 6","jaar 7"]
[null,"Jaren van de volgende reguleringsperiode:",3,":",2022,2023,2024,"","","",""]
[]
["Code","Kwaliteitsindicator","Voor activiteit",null,"Te verdelen punten onder de distributienet-beheerders per jaar observatie van de indicator",null,null,"Minimum aantal jaren beoordeling van de indicator","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,"Activiteit elektriciteit",null,"Activiteit aardgas"]
[]
[{"$nulls":8},"beoordelingsperiode"]
[{"$nulls":4},"globaal","weging",null,null,"van","tot en met"]
["A1","Onderbrekingsfrequentie middenspanningsnet in jaar j","Elekt.","n.v.t.",400,{"v":0.385,"d":"38.50%"},154,3,2018,2020,3,462,null,462,null,"n.v.t."]
["A2","Onderbrekingsduur middenspanningsnet in jaar j","Elekt.",null,null,{"v":0.315,"d":"31.50%"},126,3,2018,null,3,378,null,378]
["A3","Onderbrekingsfrequentie laagspanningsnet in jaar j","Elekt.",null,null,{"v":0.165,"d":"16.50%"},66,3,2018,null,3,198,null,198]
["A4","Onderbrekingsduur laagspanningsnet in jaar j","Elekt.",null,null,{"v":0.135,"d":"13.50%"},54,3,2018,null,3,162,null,162]
["B1","Het aantal gegronde en gedeeltelijk gegronde tweedelijnsklachten ontvangen tegen het netbedrijf door de Federale Ombudsdienst, relatief t.o.v. het aantal actieve toegangspunten.","Elekt.","Aardgas",50,{"v":1,"d":"100%"},50,2,2018,null,3,150,null,150,null,150]
["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,{"v":0.8,"d":"80%"},20,2,2018,null,3,60,null,60,null,60]
["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,{"v":0.19999999999999996,"d":"20%"},4.999999999999999,2,2018,null,3,{"v":14.999999999999996,"d":"15"},null,{"v":14.999999999999996,"d":"15"},null,{"v":14.999999999999996,"d":"15"}]
["E1","Nota over geleverde inspanningen ter bevordering van de klantentevredenheid","Elektriciteit en aardgas",null,125,{"v":0.8,"d":"80%"},100,1,2018,null,3,300,null,300,null,300]
["E2","Nota over geleverde inspanningen voor het betrekken van belanghebbenden ","Elektriciteit en aardgas",null,null,{"v":0.19999999999999996,"d":"20%"},24.999999999999993,1,2018,null,3,{"v":74.99999999999997,"d":"75"},null,{"v":74.99999999999997,"d":"75"},null,{"v":74.99999999999997,"d":"75"}]
[]
[{"$nulls":3},"aantal punten per beoordelingsjaar voor elektriciteit:",600,{"$nulls":8},1800,null,600]
[{"$nulls":3},"aantal punten per beoordelingsjaar voor aardgas:",200]
[{"$nulls":12},"normale waarde per beoordelingsjaar",600,null,200]
[{"$nulls":3}," %TI in de balans voor kwaliteit per volledig beoordelingsjaar (Q-bedrag):"]
[{"$nulls":3},"Elektriciteit:",{"v":0.01125,"d":"1.1250%"},{"$nulls":7},"Equivalent aantal jaren beoordeling",{"v":3,"d":"3.00"},null,{"v":3,"d":"3.00"}]
[{"$nulls":3},"Aardgas:",{"v":0.00375,"d":"0.3750%"},{"$nulls":7},"correctiefactor beoordelingsperiode / lengte volgende reguleringsperiode",{"v":1,"d":"100.00%"},null,{"v":1,"d":"100.00%"}]
[]
[{"$nulls":3},"pro rata cap/floor impact op TI:",{"$nulls":8}," %TI in de balans voor kwaliteit per volledig beoordelingsjaar (Q%):",{"v":0.01125,"d":"1.1250%"},null,{"v":0.00375,"d":"0.3750%"}]
[{"$nulls":3},"Elektriciteit: +/-",{"v":0.015,"d":"1.5000%"}]
[{"$nulls":3},"Aardgas:+/-",{"v":0.005,"d":"0.5000%"},{"$nulls":7},"cap/floor in reguleringsperiode",{"v":0.015,"d":"1.5000%"},null,{"v":0.005,"d":"0.5000%"}]

{"sheet":"A1","index":2,"n_rows":21,"n_cols":15,"rows_kept":21,"merged":[[5,12,5,14]],"flags":["formulas_cached_only"]}
["Onderbrekingsfrequentie middenspanning"]
[]
[{"$nulls":3},"Waarden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[{"$nulls":3},"distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[]
[{"$nulls":12},"Puntenverdeling"]
[null,null,2018,2019,2020,"n.v.t.","n.v.t.","n.v.t.","Gemiddelde","Normalisatie","Formule inverse exponent",null," 1 basis","2 prestatie beter dan gemiddelde","3 herverdeling"]
[null,"dnb2",0.35,0.23,{"v":0.4,"d":"0.40"},{"$nulls":3},{"v":0.32666666666666666,"d":"0.3267"},{"v":0.4949494949494949,"d":"0.4949"},{"v":0.6096016944832164,"d":"0.6096"},null,55.22,"ja",{"v":46.98166666666666,"d":"46.98"}]
[null,"dnb1",0.33,{"v":0.5,"d":"0.50"},{"v":0.4,"d":"0.40"},{"$nulls":3},{"v":0.41,"d":"0.4100"},{"v":0.6212121212121211,"d":"0.6212"},{"v":0.5372927787554612,"d":"0.5373"},null,48.67,"ja",{"v":46.98166666666666,"d":"46.98"}]
[null,"dnb3",0.43,0.54,{"v":0.3,"d":"0.30"},{"$nulls":3},{"v":0.42333333333333334,"d":"0.4233"},{"v":0.6414141414141414,"d":"0.6414"},{"v":0.5265472849790284,"d":"0.5265"},null,{"v":47.7,"d":"47.70"},"ja",{"v":46.98166666666666,"d":"46.98"}]
[null,"dnb4",{"v":0.4,"d":"0.40"},{"v":0.5,"d":"0.50"},0.47,{"$nulls":3},{"v":0.4566666666666667,"d":"0.4567"},{"v":0.6919191919191919,"d":"0.6919"},{"v":0.5006143714637623,"d":"0.5006"},null,45.35,"ja",{"v":46.98166666666666,"d":"46.98"}]
[null,"dnb5",{"v":0.3,"d":"0.30"},{"v":0.6,"d":"0.60"},0.56,{"$nulls":3},{"v":0.48666666666666664,"d":"0.4867"},{"v":0.7373737373737373,"d":"0.7374"},{"v":0.4783685887954514,"d":"0.4784"},null,43.33,"ja",{"v":46.98166666666666,"d":"46.98"}]
[null,"dnb6",0.59,{"v":0.4,"d":"0.40"},0.55,{"$nulls":3},{"v":0.5133333333333333,"d":"0.5133"},{"v":0.7777777777777777,"d":"0.7778"},{"v":0.4594258240359267,"d":"0.4594"},null,41.62,"ja",{"v":46.98166666666666,"d":"46.98"}]
[null,"dnb7",0.61,{"v":0.5,"d":"0.50"},{"v":0.5,"d":"0.50"},{"$nulls":3},{"v":0.5366666666666666,"d":"0.5367"},{"v":0.813131313131313,"d":"0.8131"},{"v":0.44346725498777134,"d":"0.4435"},null,40.17,"nee",40.17]
[null,"dnb8",0.53,0.55,{"v":0.6,"d":"0.60"},{"$nulls":3},{"v":0.56,"d":"0.5600"},{"v":0.8484848484848485,"d":"0.8485"},{"v":0.4280630211831759,"d":"0.4281"},null,38.78,"nee",38.78]
[null,"dnb9",0.97,0.25,{"v":0.7,"d":"0.70"},{"$nulls":3},{"v":0.64,"d":"0.6400"},{"v":0.9696969696969697,"d":"0.9697"},{"v":0.3791979291581653,"d":"0.3792"},null,34.35,"nee",34.35]
[null,"dnb10",0.48,{"v":0.7,"d":"0.70"},{"v":0.8,"d":"0.80"},{"$nulls":3},{"v":0.66,"d":"0.6600"},{"v":1,"d":"1.0000"},{"v":0.36787944117144233,"d":"0.3679"},null,33.32,"nee",33.32]
[null,"dnb11",0.72,{"v":0.6,"d":"0.60"},0.65,{"$nulls":3},{"v":0.6566666666666666,"d":"0.6567"},{"v":0.9949494949494948,"d":"0.9949"},{"v":0.36974211791684447,"d":"0.3697"},null,33.49,"nee",33.49]
[{"$nulls":7},"gemiddelde:",{"v":0.5154545454545455,"d":"0.5155"},"Totaal:",{"v":5.100200306930246,"d":"5.1002"},null,{"v":462.00000000000006,"d":"462.00"},null,{"v":462.00000000000006,"d":"462.00"}]
[]
[{"$nulls":8},"Totaal te verdelen punten:",null,{"v":462,"d":"462.00"}]

{"sheet":"A2","index":3,"n_rows":21,"n_cols":15,"rows_kept":21,"merged":[[5,12,5,14]],"flags":["formulas_cached_only"]}
["Onderbrekingsduur middenspanning"]
[]
[null,null,"hh:mm:ss","Waarden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[{"$nulls":3},"distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[]
[{"$nulls":12},"Puntenverdeling"]
[null,null,2018,2019,2020,"n.v.t.","n.v.t.","n.v.t.","Gemiddelde","Normalisatie","Formule inverse exponent",null," 1 basis","2 prestatie beter dan gemiddelde","3 herverdeling"]
[null,"dnb2",0.02289351851851852,0.0221875,0.017361111111111112,{"$nulls":3},"00:29:58.333",{"v":0.4797687861271676,"d":"0.4798"},{"v":0.6189264796519147,"d":"0.6189"},null,40.51,"ja",{"v":37.53333333333334,"d":"37.53"}]
[null,"dnb1",0.020474537037037038,0.020162037037037037,0.027314814814814816,{"$nulls":3},"00:32:37",{"v":0.5220987105380169,"d":"0.5221"},{"v":0.593274129824047,"d":"0.5933"},null,38.83,"ja",{"v":37.53333333333334,"d":"37.53"}]
[null,"dnb3",0.023587962962962963,0.02273148148148148,0.023217592592592592,{"$nulls":3},"00:33:22.667",{"v":0.5342819030680301,"d":"0.5343"},{"v":0.5860900085053986,"d":"0.5861"},null,38.36,"ja",{"v":37.53333333333334,"d":"37.53"}]
[null,"dnb4",0.02318287037037037,0.024305555555555556,0.02549768518518519,{"$nulls":3},"00:35:02",{"v":0.5607825700311249,"d":"0.5608"},{"v":0.570762227617066,"d":"0.5708"},null,37.35,"ja",{"v":37.53333333333334,"d":"37.53"}]
[null,"dnb5",0.02480324074074074,0.022997685185185187,0.03300925925925926,{"$nulls":3},"00:38:47.333",{"v":0.620898176967541,"d":"0.6209"},{"v":0.5374614852118309,"d":"0.5375"},null,35.17,"ja",{"v":37.53333333333334,"d":"37.53"}]
[null,"dnb6",0.027951388888888887,0.02202546296296296,0.03155092592592592,{"$nulls":3},"00:39:08",{"v":0.6264117385504666,"d":"0.6264"},{"v":0.5345063124644068,"d":"0.5345"},null,34.98,"ja",{"v":37.53333333333334,"d":"37.53"}]
[null,"dnb7",0.02388888888888889,0.021354166666666664,0.041608796296296297,{"$nulls":3},"00:41:41.333",{"v":0.6673188083592707,"d":"0.6673"},{"v":0.5130824074751175,"d":"0.5131"},null,33.58,"nee",33.58]
[null,"dnb8",0.028680555555555553,0.03710648148148148,0.024166666666666666,{"$nulls":3},"00:43:10.667",{"v":0.6911516229435304,"d":"0.6912"},{"v":0.5009987750333222,"d":"0.5010"},null,32.79,"nee",32.79]
[null,"dnb9",0.030763888888888886,0.030775462962962966,0.032337962962962964,{"$nulls":3},"00:45:03.667",{"v":0.7212983548243663,"d":"0.7213"},{"v":0.48612068890796,"d":"0.4861"},null,31.81,"nee",31.81]
[null,"dnb10",0.03193287037037037,0.031041666666666665,0.03621527777777778,{"$nulls":3},"00:47:36.667",{"v":0.7621164962205423,"d":"0.7621"},{"v":0.46667765951510437,"d":"0.4667"},null,30.54,"nee",30.54]
[null,"dnb11",0.021597222222222223,0.07778935185185186,0.030763888888888886,{"$nulls":3},"01:02:28.333",{"v":1,"d":"1.0000"},{"v":0.36787944117144233,"d":"0.3679"},null,24.08,"nee",24.08]
[{"$nulls":7},"gemiddelde:","00:40:48.727","Totaal:",{"v":5.77577961537761,"d":"5.7758"},null,{"v":378.00000000000006,"d":"378.00"},null,{"v":378.00000000000006,"d":"378.00"}]
[]
[{"$nulls":8},"Totaal te verdelen punten:",null,{"v":378,"d":"378.00"}]

{"sheet":"A3","index":4,"n_rows":21,"n_cols":15,"rows_kept":21,"merged":[[5,12,5,14]],"flags":["formulas_cached_only"]}
["Onderbrekingsfrequentie laagspanning"]
[]
[{"$nulls":3},"Waarden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[{"$nulls":3},"distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[]
[{"$nulls":12},"Puntenverdeling"]
[null,null,2018,2019,2020,"n.v.t.","n.v.t.","n.v.t.","Gemiddelde","Normalisatie","Formule inverse exponent",null," 1 basis","2 prestatie beter dan gemiddelde","3 herverdeling"]
[null,"dnb2",0.03,0.02,0.03,{"$nulls":3},{"v":0.02666666666666667,"d":"0.0267"},{"v":0.22222222222222224,"d":"0.2222"},{"v":0.8007374029168081,"d":"0.8007"},null,22.33,"ja",{"v":20.683333333333334,"d":"20.68"}]
[null,"dnb1",0.03,0.02,0.04,{"$nulls":3},{"v":0.03,"d":"0.0300"},{"v":0.25,"d":"0.2500"},{"v":0.7788007830714049,"d":"0.7788"},null,21.71,"ja",{"v":20.683333333333334,"d":"20.68"}]
[null,"dnb3",0.05,0.03,0.03,{"$nulls":3},{"v":0.03666666666666667,"d":"0.0367"},{"v":0.3055555555555556,"d":"0.3056"},{"v":0.7367139751383992,"d":"0.7367"},null,20.54,"ja",{"v":20.683333333333334,"d":"20.68"}]
[null,"dnb4",0.04,0.03,0.06,{"$nulls":3},{"v":0.043333333333333335,"d":"0.0433"},{"v":0.36111111111111116,"d":"0.3611"},{"v":0.696901560658112,"d":"0.6969"},null,19.43,"ja",{"v":20.683333333333334,"d":"20.68"}]
[null,"dnb5",0.02,0.03,0.04,{"$nulls":3},{"v":0.03,"d":"0.0300"},{"v":0.25,"d":"0.2500"},{"v":0.7788007830714049,"d":"0.7788"},null,21.71,"ja",{"v":20.683333333333334,"d":"20.68"}]
[null,"dnb6",0.06,0.04,0.05,{"$nulls":3},{"v":0.05000000000000001,"d":"0.0500"},{"v":0.41666666666666674,"d":"0.4167"},{"v":0.6592406302004438,"d":"0.6592"},null,18.38,"ja",{"v":20.683333333333334,"d":"20.68"}]
[null,"dnb7",0.08,0.07,0.06,{"$nulls":3},{"v":0.07,"d":"0.0700"},{"v":0.5833333333333334,"d":"0.5833"},{"v":0.5580351457700471,"d":"0.5580"},null,15.56,"nee",15.56]
[null,"dnb8",0.07,0.06,0.06,{"$nulls":3},{"v":0.06333333333333334,"d":"0.0633"},{"v":0.5277777777777778,"d":"0.5278"},{"v":0.5899144351448397,"d":"0.5899"},null,16.45,"nee",16.45]
[null,"dnb9",0.06,0.06,0.06,{"$nulls":3},{"v":0.06,"d":"0.0600"},{"v":0.5,"d":"0.5000"},{"v":0.6065306597126334,"d":"0.6065"},null,16.91,"nee",16.91]
[null,"dnb10",0.08,0.08,0.07,{"$nulls":3},{"v":0.07666666666666667,"d":"0.0767"},{"v":0.638888888888889,"d":"0.6389"},{"v":0.5278786301239432,"d":"0.5279"},null,14.72,"nee",14.72]
[null,"dnb11",0.05,{"v":0.2,"d":"0.20"},0.11,{"$nulls":3},{"v":0.12,"d":"0.1200"},{"v":1,"d":"1.0000"},{"v":0.36787944117144233,"d":"0.3679"},null,10.26,"nee",10.26]
[{"$nulls":7},"gemiddelde:",{"v":0.05515151515151515,"d":"0.0552"},"Totaal:",{"v":7.1014334469794775,"d":"7.1014"},null,{"v":197.99999999999997,"d":"198.00"},null,{"v":197.99999999999997,"d":"198.00"}]
[]
[{"$nulls":8},"Totaal te verdelen punten:",null,{"v":198,"d":"198.00"}]

{"sheet":"A4","index":5,"n_rows":21,"n_cols":15,"rows_kept":21,"merged":[[5,12,5,14]],"flags":["formulas_cached_only"]}
["Onderbrekingsduur laagspanning"]
[]
[null,null,"hh:mm:ss","Waarden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[{"$nulls":3},"distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[{"$nulls":7},"01:00:00"]
[{"$nulls":12},"Puntenverdeling"]
[null,null,2018,2019,2020,"n.v.t.","n.v.t.","n.v.t.","Gemiddelde","Normalisatie","Formule inverse exponent",null," 1 basis","2 prestatie beter dan gemiddelde","3 herverdeling"]
[null,"dnb2",0.050243055555555555,0.05902777777777778,0.06351851851851852,{"$nulls":3},0.05759645061728395,{"v":0.5020345024716684,"d":"0.5020"},{"v":0.6052979260113974,"d":"0.6053"},null,18.66,"ja",{"v":17.563333333333333,"d":"17.56"}]
[null,"dnb1",0.041666666666666664,0.06583333333333334,0.06874999999999999,{"$nulls":3},0.058750000000000004,{"v":0.5120893163399133,"d":"0.5121"},{"v":0.5992422633295852,"d":"0.5992"},null,18.48,"ja",{"v":17.563333333333333,"d":"17.56"}]
[null,"dnb3",0.1070949074074074,0.063125,0.06541666666666666,{"$nulls":3},0.07854552469135802,{"v":0.684635302821401,"d":"0.6846"},{"v":0.504274103386403,"d":"0.5043"},null,15.55,"ja",{"v":17.563333333333333,"d":"17.56"}]
[null,"dnb4",0.07761574074074074,0.07865740740740741,0.10453703703703704,{"$nulls":3},0.08693672839506172,{"v":0.7577765073813768,"d":"0.7578"},{"v":0.4687074367682114,"d":"0.4687"},null,14.45,"nee",14.45]
[null,"dnb5",0.07984953703703704,0.08204861111111111,0.10002314814814815,{"$nulls":3},0.08730709876543209,{"v":0.761004808824024,"d":"0.7610"},{"v":0.4671967476658419,"d":"0.4672"},null,{"v":14.4,"d":"14.40"},"nee",{"v":14.4,"d":"14.40"}]
[null,"dnb6",0.08445601851851853,0.08128472222222222,0.09886574074074074,{"$nulls":3},0.08820216049382716,{"v":0.7688065373104215,"d":"0.7688"},{"v":0.46356598701133495,"d":"0.4636"},null,14.29,"nee",14.29]
[null,"dnb7",0.08883101851851853,0.08263888888888889,0.09331018518518519,{"$nulls":3},0.08826003086419754,{"v":0.7693109594108352,"d":"0.7693"},{"v":0.46333221304782,"d":"0.4633"},null,14.28,"nee",14.28]
[null,"dnb8",0.08650462962962963,0.1044675925925926,0.07818287037037037,{"$nulls":3},0.08971836419753086,{"v":0.7820223963412585,"d":"0.7820"},{"v":0.45747986949372116,"d":"0.4575"},null,{"v":14.1,"d":"14.10"},"nee",{"v":14.1,"d":"14.10"}]
[null,"dnb9",0.08318287037037037,0.08756944444444444,0.10252314814814815,{"$nulls":3},0.09109182098765432,{"v":0.7939940141910752,"d":"0.7940"},{"v":0.45203574781493006,"d":"0.4520"},null,13.94,"nee",13.94]
[null,"dnb10",0.10486111111111111,0.11041666666666666,0.09541666666666666,{"$nulls":3},0.10356481481481482,{"v":0.9027137909002254,"d":"0.9027"},{"v":0.4054678104681806,"d":"0.4055"},null,{"v":12.5,"d":"12.50"},"nee",{"v":12.5,"d":"12.50"}]
[null,"dnb11",0.10193287037037037,0.10269675925925925,0.1395486111111111,{"$nulls":3},0.11472608024691357,{"v":1,"d":"1.0000"},{"v":0.36787944117144233,"d":"0.3679"},null,11.34,"nee",11.34]
[{"$nulls":7},"gemiddelde:","02:03:40.182","Totaal:",{"v":5.254479546168868,"d":"5.2545"},null,161.99,null,161.99]
[]
[{"$nulls":8},"Totaal te verdelen punten:",null,{"v":162,"d":"162.00"}]

{"sheet":"B1","index":6,"n_rows":119,"n_cols":26,"rows_kept":119,"merged":[[8,0,40,0],[8,1,9,1],[8,2,8,4],[8,5,8,7],[8,8,8,10],[8,11,8,13],[8,14,8,16],[8,17,8,19],[8,20,8,22],[8,23,8,25],[15,1,16,1],[15,2,15,4],[15,5,15,7],[15,8,15,10],[15,11,15,13],[15,14,15,16],[15,17,15,19],[15,20,15,22],[15,23,15,25],[22,1,23,1],[22,2,22,4],[22,5,22,7],[22,8,22,10],[22,11,22,13],[22,14,22,16],[22,17,22,19],[22,20,22,22],[22,23,22,25],[29,1,30,1],[29,2,29,4],[29,5,29,7],[29,8,29,10],[29,11,29,13],[29,14,29,16],[29,17,29,19],[29,20,29,22],[29,23,29,25],[36,1,37,1],[36,2,36,4],[36,5,36,7],[36,8,36,10],[36,11,36,13],[36,14,36,16],[36,17,36,19],[36,20,36,22],[36,23,36,25],[43,1,44,1],[43,2,43,4],[43,5,43,7],[43,8,43,10],[43,11,43,13],[50,1,51,1],[50,2,50,4],[50,5,50,7],[50,8,50,10],[50,11,50,13],[57,1,58,1],[57,2,57,6],[57,7,57,11],[57,12,57,13]],"flags":["formulas_cached_only"]}
["Klachten tegen de distributienetbeheerder"]
[]
[null,"Aantal jaren met data beschikbaar (zie tab 'Q%'):",3]
[]
[{"$nulls":3},"Cellen in te vullen door de VREG op basis van ontvangen informatie door federale Ombudsdienst voor Energie."]
[{"$nulls":3},"Cellen in te vullen door de VREG op basis van door de VREG geregistreerde informatie."]
[]
[null,"jaar:",2018,{"$nulls":11},2018]
["federale Ombudsdienst voor Energie","Klachten door federale Ombudsdienst voor Energie afgesloten in boekjaar tegen","Aantal ontvankelijke klachten",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten",null,null,"Aantal klachten m.b.t. bevoegdheid Vlaanderen",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten"]
[null,null,"Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas"]
[null,"netbedrijf1 (alleen klachten uit Vlaanderen)",{"v":3000,"d":"3,000"},10,null,{"v":3000,"d":"3,000"},{"$nulls":5},0,10,0,10,10,null,2,2,2,2,2,2,6,6,-4]
[null,"netbedrijf2 (alleen klachten uit Vlaanderen)",300,2,null,300,{"$nulls":5},0,2,0,2,2,null,2,0,1,1,0,0,-1,2,-1]
[]
[]
[null,"jaar",2019,{"$nulls":11},2019]
[null,"Klachten door federale Ombudsdienst voor Energie afgesloten in boekjaar tegen","Aantal ontvankelijke klachten",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten",null,null,"Aantal klachten m.b.t. bevoegdheid Vlaanderen",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten"]
[null,null,"Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas"]
[null,"netbedrijf1 (alleen klachten uit Vlaanderen)",10,10,null,null,200,{"$nulls":4},10,-190,0,10,10,{"$nulls":7},10,10,0]
[null,"netbedrijf2 (alleen klachten uit Vlaanderen)",2,2,null,null,28,{"$nulls":4},2,-26,0,2,2,{"$nulls":7},2,2,0]
[]
[]
[null,"jaar",2020,{"$nulls":11},2020]
[null,"Klachten door federale Ombudsdienst voor Energie afgesloten in boekjaar tegen","Aantal ontvankelijke klachten",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten",null,null,"Aantal klachten m.b.t. bevoegdheid Vlaanderen",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten"]
[null,null,"Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas"]
[null,"netbedrijf1 (alleen klachten uit Vlaanderen)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"netbedrijf2 (alleen klachten uit Vlaanderen)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"jaar","n.v.t.",{"$nulls":11},"n.v.t."]
[null,"Klachten door federale Ombudsdienst voor Energie afgesloten in boekjaar tegen","Aantal ontvankelijke klachten",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten",null,null,"Aantal klachten m.b.t. bevoegdheid Vlaanderen",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten"]
[null,null,"Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas"]
[null,"netbedrijf1 (alleen klachten uit Vlaanderen)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"netbedrijf2 (alleen klachten uit Vlaanderen)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"jaar","n.v.t.",{"$nulls":11},"n.v.t."]
[null,"Klachten door federale Ombudsdienst voor Energie afgesloten in boekjaar tegen","Aantal ontvankelijke klachten",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten",null,null,"Aantal klachten m.b.t. bevoegdheid Vlaanderen",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten"]
[null,null,"Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas"]
[null,"netbedrijf1 (alleen klachten uit Vlaanderen)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"netbedrijf2 (alleen klachten uit Vlaanderen)",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"Totaal aantal klachten door federale Ombudsdienst voor Energie afgesloten tegen","totaal",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten"]
[null,null,"Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas"]
[null,"netbedrijf1 (alleen klachten uit Vlaanderen)",{"v":3030,"d":"3,030"},40,0,{"v":3002,"d":"3,002"},202,2,2,2,2,26,-164,-4]
[null,"netbedrijf2 (alleen klachten uit Vlaanderen)",306,8,0,302,28,1,1,0,0,3,-20,-1]
[]
[null,"Totaal",{"v":3336,"d":"3,336"},48,0,3304,230,3,3,2,2,29,-184,-5]
[]
[null,"Gemiddeld jaarlijks aantal klachten over de 3 jaar door federale Ombudsdienst voor Energie afgesloten tegen","Aantal ontvankelijke klachten en klachten m.b.t. bevoegdheid Vlaanderen",null,null,"waarvan gegronde klachten",null,null,"waarvan gedeeltelijk gegronde klachten",null,null,"waarvan niet-gegronde klachten"]
[null,null,"Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas","Elektriciteit","Gas","Elek. & Gas"]
[null,"netbedrijf1 (alleen klachten uit Vlaanderen)",{"v":1010,"d":"1,010.0"},{"v":13.333333333333334,"d":"13.3"},{"v":0,"d":"0.0"},{"v":1000.6666666666666,"d":"1,000.7"},{"v":67.33333333333333,"d":"67.3"},{"v":0.6666666666666666,"d":"0.7"},{"v":0.6666666666666666,"d":"0.7"},{"v":0.6666666666666666,"d":"0.7"},{"v":0.6666666666666666,"d":"0.7"},{"v":8.666666666666705,"d":"9"},{"v":-54.66666666666666,"d":"-55"},{"v":-1.3333333333333333,"d":"-1"}]
[null,"netbedrijf2 (alleen klachten uit Vlaanderen)",{"v":102,"d":"102.0"},{"v":2.6666666666666665,"d":"2.7"},{"v":0,"d":"0.0"},{"v":100.66666666666667,"d":"100.7"},{"v":9.333333333333334,"d":"9.3"},{"v":0.3333333333333333,"d":"0.3"},{"v":0.3333333333333333,"d":"0.3"},{"v":0,"d":"0.0"},{"v":0,"d":"0.0"},{"v":0.9999999999999953,"d":"1"},{"v":-6.666666666666668,"d":"-7"},{"v":-0.3333333333333333,"d":"-0"}]
[]
[null,"Totaal",{"v":1112,"d":"1,112.0"},{"v":16,"d":"16.0"},{"v":0,"d":"0.0"},{"v":1101.3333333333333,"d":"1,101.3"},{"v":76.66666666666666,"d":"76.7"},{"v":1,"d":"1.0"},{"v":1,"d":"1.0"},{"v":0.6666666666666666,"d":"0.7"},{"v":0.6666666666666666,"d":"0.7"},{"v":9.6666666666667,"d":"10"},{"v":-61.33333333333333,"d":"-61"},{"v":-1.6666666666666665,"d":"-2"}]
[]
[null,"Aantal actieve toegangspunten per 01 juli voor","Elektriciteit",{"$nulls":4},"Gas",1.606904521218755e+44,{"$nulls":3},"Gemiddeld"]
[null,null,2018,2019,2020,"n.v.t.","n.v.t.",2018,2019,2020,"n.v.t.","n.v.t.","Elektriciteit","Gas"]
[null,"netbedrijf1 ",{"v":3016199,"d":"3,016,199"},{"v":3016199,"d":"3,016,199"},{"v":3016199,"d":"3,016,199"},"","",{"v":1699675,"d":"1,699,675"},{"v":1699675,"d":"1,699,675"},{"v":1699675,"d":"1,699,675"},"","",{"v":3016199,"d":"3,016,199"},{"v":1699675,"d":"1,699,675"}]
[null,"netbedrijf2",{"v":310905,"d":"310,905"},{"v":310905,"d":"310,905"},{"v":310905,"d":"310,905"},"","",{"v":341651,"d":"341,651"},{"v":341651,"d":"341,651"},{"v":341651,"d":"341,651"},"","",{"v":310905,"d":"310,905"},{"v":341651,"d":"341,651"}]
[]
[null,"Totaal",{"v":3327104,"d":"3,327,104 "},{"v":3327104,"d":"3,327,104 "},{"v":3327104,"d":"3,327,104 "},0,0,{"v":2041326,"d":"2,041,326 "},{"v":2041326,"d":"2,041,326 "},{"v":2041326,"d":"2,041,326 "},0,0,{"v":3327104,"d":"3,327,104"},{"v":2041326,"d":"2,041,326"}]
[]
[]
[null,"Gemiddeld aantal klachten tegen"]
[null,null,"Elektriciteit","Gas"]
[null,"netbedrijf1 ",{"v":1002.6666666666665,"d":"1,003"},{"v":69.33333333333334,"d":"69"}]
[null,"netbedrijf2",{"v":101.33333333333333,"d":"101"},{"v":9.666666666666668,"d":"10"}]
[]
[null,"Totaal",{"v":1103.9999999999998,"d":"1,104"},{"v":79.00000000000001,"d":"79"}]
[]
[null,"Verwachting aantal klachten tegen"]
[null,null,"Elektriciteit","Gas"]
[null,"netbedrijf1 ",{"v":1000.8354701265725,"d":"1,000.84"},{"v":65.77799185431431,"d":"65.78"}]
[null,"netbedrijf2",{"v":103.16452987342745,"d":"103.16"},{"v":13.222008145685697,"d":"13.22"}]
[]
[]
[]
[null,"Variantie van het aantal klachten tegen"]
[null,null,"Elektriciteit","Gas"]
[null,"netbedrijf1 ",{"v":93.4931984729495,"d":"93.49"},{"v":11.008657111373367,"d":"11.01"}]
[null,"netbedrijf2",{"v":93.4931984729495,"d":"93.49"},{"v":11.008657111373367,"d":"11.01"}]
[]
[]
[]
[null,"Puntenverdeling voor de gereguleerde activiteit elektriciteit"]
[]
[null,"Netbedrijf (werkmaatschappij of distributienetbeheerder zonder werkmaatschappij)","Actieve toegangspunten","Aantal klachten (a)","Verwachting aantal klachten (b)","Variantie","Verschil (a) - (b) = c","c / variantie = x","Score: e-x","Puntenverdeling per dnb (niet afgerond)","Aantal dnb's","Puntenverdeling per netbedrijf","Puntenverdeling per dnb (afgerond)"]
[null,"netbedrijf1 ",{"v":3016199,"d":"3,016,199 "},{"v":1002.6666666666665,"d":"1,003"},{"v":1000.8354701265725,"d":"1,000.84"},{"v":93.4931984729495,"d":"93.49"},{"v":1.8311965400939698,"d":"1.83"},{"v":0.019586414520022993,"d":"0.01959"},{"v":0.9806041530900232,"d":"0.98060"},{"v":13.441100123204697,"d":"13.441100"},7,{"v":94.08770086243288,"d":"94.09"},13.44]
[null,"netbedrijf2",{"v":310905,"d":"310,905 "},{"v":101.33333333333333,"d":"101"},{"v":103.16452987342745,"d":"103.16"},{"v":93.4931984729495,"d":"93.49"},{"v":-1.8311965400941261,"d":"-1.83"},{"v":-0.019586414520024666,"d":"-0.01959"},{"v":1.0197794868080656,"d":"1.01978"},{"v":13.978074784391783,"d":"13.978075"},4,{"v":55.91229913756713,"d":"55.91"},13.98]
[]
[{"$nulls":7},"Totaal",{"v":2.000383639898089,"d":"2.00038"},null,null,{"v":150,"d":"150.00"}]
[]
[{"$nulls":7},"Doelzoekwaarde waarbij een totaal aantal van 150 punten moet worden verdeeld:",{"v":27.41917490759648,"d":"27.4192"}]
[{"$nulls":7},"saldo:",{"v":0,"d":"0.00"}]
[]
[null,"Puntenverdeling voor de gereguleerde activiteit aardgas"]
[]
[null,"Netbedrijf (werkmaatschappij of distributienetbeheerder zonder werkmaatschappij)","Actieve toegangspunten","Aantal klachten (a)","Verwachting aantal klachten (b)","Variantie","Verschil (a) - (b) = c","c / variantie = x","Score: e-x","Puntenverdeling per dnb (niet afgerond)","Aantal dnb's","Puntenverdeling per netbedrijf","Puntenverdeling per dnb (afgerond)"]
[null,"netbedrijf1 ",{"v":1699675,"d":"1,699,675 "},{"v":69.33333333333334,"d":"69"},{"v":65.77799185431431,"d":"65.78"},{"v":11.008657111373367,"d":"11.01"},{"v":3.5553414790190345,"d":"3.56"},{"v":0.32295868997008786,"d":"0.32296"},{"v":0.7240037623672407,"d":"0.72400"},{"v":11.789478547331651,"d":"11.789479"},7,{"v":82.52634983132155,"d":"82.53"},11.79]
[null,"netbedrijf2",{"v":341651,"d":"341,651 "},{"v":9.666666666666668,"d":"10"},{"v":13.222008145685697,"d":"13.22"},{"v":11.008657111373367,"d":"11.01"},{"v":-3.555341479019029,"d":"-3.56"},{"v":-0.3229586899700874,"d":"-0.32296"},{"v":1.381208291971228,"d":"1.38121"},{"v":22.49121672289279,"d":"22.491217"},3,{"v":67.47365016867838,"d":"67.47"},22.49]
[{"$nulls":7},"Totaal",{"v":2.1052120543384687,"d":"2.10521"},null,null,{"v":149.99999999999994,"d":"150.00"}]
[]
[{"$nulls":7},"Doelzoekwaarde waarbij een totaal aantal van 150 punten moet worden verdeeld:",{"v":34.28069527022444,"d":"34.2807"}]
[{"$nulls":7},"saldo:",{"v":0,"d":"0.00"}]
{"$rows_empty":10}
[null,"Netbedrijf","klachten elek","klachten gas","punten/dnb elek","punten/dnb gas"]
[null,"Netbedr1",{"v":0.0018296679072159424,"d":"0.18%"},{"v":0.05405062360209228,"d":"5%"},{"v":0.4901531728665207,"d":"49%"},{"v":0.3439323220536756,"d":"34%"}]
[null,"Netbedr2",{"v":-0.017750253331652078,"d":"-1.78%"},{"v":-0.26889572596271066,"d":"-27%"},{"v":0.5098468271334792,"d":"51%"},{"v":0.6560676779463244,"d":"66%"}]

{"sheet":"D1","index":7,"n_rows":43,"n_cols":28,"rows_kept":43,"merged":[[2,3,2,5],[3,3,3,5],[4,3,4,5],[8,1,9,1],[8,2,8,4],[8,5,8,7],[8,8,8,10],[8,11,8,13],[8,14,8,16],[8,17,8,19],[23,23,23,25],[28,1,29,1],[28,2,28,4],[28,5,28,7],[28,8,28,10],[28,11,28,13],[28,14,28,16],[28,17,28,19],[42,23,42,25]],"flags":["formulas_cached_only"]}
["Forfaitaire vergoedingen wegens laattijdige aansluiting"]
[]
[{"$nulls":3},"Waarden af te leiden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[{"$nulls":3},"door distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[{"$nulls":3},"=> Bedragen EUR gecorrigeerd voor indexatie"]
[]
[null,"Forfaitaire vergoedingen wegens laattijdige aansluiting voor de gereguleerde activiteit elektriciteit"]
[]
[null,null,2018,null,null,2019,null,null,2020,null,null,"n.v.t.",null,null,"n.v.t.",null,null,"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,"dnb2",0,100,0,0,100,0,0,100,0,null,null,"",null,null,"",null,null,"",null,0,null,"dnb2",0,{"v":0,"d":"0.00000"},{"v":1,"d":"1.00000"},7.55]
[null,"dnb1",{"v":1,"d":"1.00 €"},100,{"v":0.01,"d":"0.01 €"},{"v":1,"d":"1.00 €"},100,{"v":0.01,"d":"0.01 €"},{"v":1,"d":"1.00 €"},100,{"v":0.01,"d":"0.01 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.01,"d":"0.01 €"},null,"dnb1",{"v":0.01,"d":"0.01 €"},{"v":0.09090909090909091,"d":"0.09091"},{"v":0.9454545454545454,"d":"0.94545"},7.14]
[null,"dnb3",{"v":2,"d":"2.00 €"},100,{"v":0.02,"d":"0.02 €"},{"v":2,"d":"2.00 €"},100,{"v":0.02,"d":"0.02 €"},{"v":2,"d":"2.00 €"},100,{"v":0.02,"d":"0.02 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.02,"d":"0.02 €"},null,"dnb3",{"v":0.02,"d":"0.02 €"},{"v":0.18181818181818182,"d":"0.18182"},{"v":0.8909090909090909,"d":"0.89091"},6.73]
[null,"dnb10",{"v":3,"d":"3.00 €"},100,{"v":0.03,"d":"0.03 €"},{"v":3,"d":"3.00 €"},100,{"v":0.03,"d":"0.03 €"},{"v":3,"d":"3.00 €"},100,{"v":0.03,"d":"0.03 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.03,"d":"0.03 €"},null,"dnb10",{"v":0.03,"d":"0.03 €"},{"v":0.2727272727272727,"d":"0.27273"},{"v":0.8363636363636364,"d":"0.83636"},6.32]
[null,"dnb8",{"v":4,"d":"4.00 €"},100,{"v":0.04,"d":"0.04 €"},{"v":4,"d":"4.00 €"},100,{"v":0.04,"d":"0.04 €"},{"v":4,"d":"4.00 €"},100,{"v":0.04,"d":"0.04 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.04,"d":"0.04 €"},null,"dnb8",{"v":0.04,"d":"0.04 €"},{"v":0.36363636363636365,"d":"0.36364"},{"v":0.7818181818181819,"d":"0.78182"},{"v":5.9,"d":"5.90"}]
[null,"dnb4",{"v":5,"d":"5.00 €"},100,{"v":0.05,"d":"0.05 €"},{"v":5,"d":"5.00 €"},100,{"v":0.05,"d":"0.05 €"},{"v":5,"d":"5.00 €"},100,{"v":0.05,"d":"0.05 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.05000000000000001,"d":"0.05 €"},null,"dnb4",{"v":0.05000000000000001,"d":"0.05 €"},{"v":0.45454545454545464,"d":"0.45455"},{"v":0.7272727272727273,"d":"0.72727"},5.49]
[null,"dnb9",{"v":6,"d":"6.00 €"},100,{"v":0.06,"d":"0.06 €"},{"v":6,"d":"6.00 €"},100,{"v":0.06,"d":"0.06 €"},{"v":6,"d":"6.00 €"},100,{"v":0.06,"d":"0.06 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.06,"d":"0.06 €"},null,"dnb9",{"v":0.06,"d":"0.06 €"},{"v":0.5454545454545454,"d":"0.54545"},{"v":0.6727272727272728,"d":"0.67273"},5.08]
[null,"dnb5",{"v":7,"d":"7.00 €"},100,{"v":0.07,"d":"0.07 €"},{"v":7,"d":"7.00 €"},100,{"v":0.07,"d":"0.07 €"},{"v":7,"d":"7.00 €"},100,{"v":0.07,"d":"0.07 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.07,"d":"0.07 €"},null,"dnb5",{"v":0.07,"d":"0.07 €"},{"v":0.6363636363636365,"d":"0.63636"},{"v":0.6181818181818182,"d":"0.61818"},4.67]
[null,"dnb6",{"v":8,"d":"8.00 €"},100,{"v":0.08,"d":"0.08 €"},{"v":8,"d":"8.00 €"},100,{"v":0.08,"d":"0.08 €"},{"v":8,"d":"8.00 €"},100,{"v":0.08,"d":"0.08 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.08,"d":"0.08 €"},null,"dnb6",{"v":0.08,"d":"0.08 €"},{"v":0.7272727272727273,"d":"0.72727"},{"v":0.5636363636363637,"d":"0.56364"},4.26]
[null,"dnb11",{"v":9,"d":"9.00 €"},100,{"v":0.09,"d":"0.09 €"},{"v":9,"d":"9.00 €"},100,{"v":0.09,"d":"0.09 €"},{"v":9,"d":"9.00 €"},100,{"v":0.09,"d":"0.09 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.09000000000000001,"d":"0.09 €"},null,"dnb11",{"v":0.09000000000000001,"d":"0.09 €"},{"v":0.8181818181818182,"d":"0.81818"},{"v":0.509090909090909,"d":"0.50909"},3.84]
[null,"dnb7",{"v":11,"d":"11.00 €"},100,{"v":0.11,"d":"0.11 €"},{"v":11,"d":"11.00 €"},100,{"v":0.11,"d":"0.11 €"},{"v":11,"d":"11.00 €"},100,{"v":0.11,"d":"0.11 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.11,"d":"0.11 €"},null,"dnb7",{"v":0.11,"d":"0.11 €"},{"v":1,"d":"1.00000"},{"v":0.4,"d":"0.40000"},3.02]
[{"$nulls":20},"Maximum:",{"v":0.11,"d":"0.11 €"},{"$nulls":3},"Totaal:",{"v":7.945454545454545,"d":"7.94545"},{"v":60.00000000000001,"d":"60.00"}]
[]
[{"$nulls":23},"Aantal te verdelen punten:",null,null,{"v":60,"d":"60.00"}]
[]
[]
[null,"Forfaitaire vergoedingen wegens laattijdige aansluiting voor de gereguleerde activiteit aardgas"]
[]
[null,null,2018,null,null,2019,null,null,2020,null,null,"n.v.t.",null,null,"n.v.t.",null,null,"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,"dnb2",{"v":10,"d":"10.00 €"},200,{"v":0.05,"d":"0.05 €"},{"v":10,"d":"10.00 €"},200,{"v":0.05,"d":"0.05 €"},{"v":10,"d":"10.00 €"},200,{"v":0.05,"d":"0.05 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.05000000000000001,"d":"0.05 €"},null,"dnb2",{"v":0.05000000000000001,"d":"0.05 €"},{"v":0.29411764705882354,"d":"0.29412"},{"v":0.8235294117647058,"d":"0.82353"},8.08]
[null,"dnb1",{"v":20,"d":"20.00 €"},200,{"v":0.1,"d":"0.10 €"},{"v":9,"d":"9.00 €"},200,{"v":0.045,"d":"0.05 €"},{"v":9,"d":"9.00 €"},200,{"v":0.045,"d":"0.05 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.06333333333333334,"d":"0.06 €"},null,"dnb1",{"v":0.06333333333333334,"d":"0.06 €"},{"v":0.37254901960784315,"d":"0.37255"},{"v":0.7764705882352941,"d":"0.77647"},7.62]
[null,"dnb3",{"v":30,"d":"30.00 €"},200,{"v":0.15,"d":"0.15 €"},{"v":8,"d":"8.00 €"},200,{"v":0.04,"d":"0.04 €"},{"v":8,"d":"8.00 €"},200,{"v":0.04,"d":"0.04 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.07666666666666667,"d":"0.08 €"},null,"dnb3",{"v":0.07666666666666667,"d":"0.08 €"},{"v":0.45098039215686275,"d":"0.45098"},{"v":0.7294117647058824,"d":"0.72941"},7.15]
[null,"dnb10",{"v":40,"d":"40.00 €"},200,{"v":0.2,"d":"0.20 €"},{"v":7,"d":"7.00 €"},200,{"v":0.035,"d":"0.04 €"},{"v":7,"d":"7.00 €"},200,{"v":0.035,"d":"0.04 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.09000000000000001,"d":"0.09 €"},null,"dnb10",{"v":0.09000000000000001,"d":"0.09 €"},{"v":0.5294117647058824,"d":"0.52941"},{"v":0.6823529411764706,"d":"0.68235"},6.69]
[null,"dnb8",{"v":50,"d":"50.00 €"},200,{"v":0.25,"d":"0.25 €"},{"v":6,"d":"6.00 €"},200,{"v":0.03,"d":"0.03 €"},{"v":6,"d":"6.00 €"},200,{"v":0.03,"d":"0.03 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.10333333333333335,"d":"0.10 €"},null,"dnb8",{"v":0.10333333333333335,"d":"0.10 €"},{"v":0.607843137254902,"d":"0.60784"},{"v":0.6352941176470588,"d":"0.63529"},6.23]
[null,"dnb4",{"v":60,"d":"60.00 €"},200,{"v":0.3,"d":"0.30 €"},{"v":5,"d":"5.00 €"},200,{"v":0.025,"d":"0.03 €"},{"v":5,"d":"5.00 €"},200,{"v":0.025,"d":"0.03 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.11666666666666668,"d":"0.12 €"},null,"dnb4",{"v":0.11666666666666668,"d":"0.12 €"},{"v":0.6862745098039216,"d":"0.68627"},{"v":0.5882352941176471,"d":"0.58824"},5.77]
[null,"dnb9",{"v":70,"d":"70.00 €"},200,{"v":0.35,"d":"0.35 €"},{"v":4,"d":"4.00 €"},200,{"v":0.02,"d":"0.02 €"},{"v":4,"d":"4.00 €"},200,{"v":0.02,"d":"0.02 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.13,"d":"0.13 €"},null,"dnb9",{"v":0.13,"d":"0.13 €"},{"v":0.7647058823529411,"d":"0.76471"},{"v":0.5411764705882354,"d":"0.54118"},5.31]
[null,"dnb5",{"v":80,"d":"80.00 €"},200,{"v":0.4,"d":"0.40 €"},{"v":3,"d":"3.00 €"},200,{"v":0.015,"d":"0.02 €"},{"v":3,"d":"3.00 €"},200,{"v":0.015,"d":"0.02 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.14333333333333334,"d":"0.14 €"},null,"dnb5",{"v":0.14333333333333334,"d":"0.14 €"},{"v":0.8431372549019608,"d":"0.84314"},{"v":0.49411764705882355,"d":"0.49412"},4.85]
[null,"dnb6",{"v":90,"d":"90.00 €"},200,{"v":0.45,"d":"0.45 €"},{"v":2,"d":"2.00 €"},200,{"v":0.01,"d":"0.01 €"},{"v":2,"d":"2.00 €"},200,{"v":0.01,"d":"0.01 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.15666666666666668,"d":"0.16 €"},null,"dnb6",{"v":0.15666666666666668,"d":"0.16 €"},{"v":0.9215686274509803,"d":"0.92157"},{"v":0.44705882352941184,"d":"0.44706"},4.38]
[null,"dnb7",{"v":100,"d":"100.00 €"},200,{"v":0.5,"d":"0.50 €"},{"v":1,"d":"1.00 €"},200,{"v":0.005,"d":"0.01 €"},{"v":1,"d":"1.00 €"},200,{"v":0.005,"d":"0.01 €"},null,null,"",null,null,"",null,null,"",null,{"v":0.17,"d":"0.17 €"},null,"dnb7",{"v":0.17,"d":"0.17 €"},{"v":1,"d":"1.00000"},{"v":0.4,"d":"0.40000"},3.92]
[{"$nulls":20},"Maximum:",{"v":0.17,"d":"0.17 €"},{"$nulls":3},"Totaal:",{"v":6.11764705882353,"d":"6.11765"},{"v":60.000000000000014,"d":"60.00"}]
[]
[{"$nulls":23},"Aantal te verdelen punten:",null,null,{"v":60,"d":"60.00"}]

{"sheet":"D2","index":8,"n_rows":43,"n_cols":28,"rows_kept":43,"merged":[[2,3,2,5],[3,3,3,5],[4,3,4,5],[8,1,9,1],[8,2,8,4],[8,5,8,7],[8,8,8,10],[8,11,8,13],[8,14,8,16],[8,17,8,19],[23,23,23,25],[28,1,29,1],[28,2,28,4],[28,5,28,7],[28,8,28,10],[28,11,28,13],[28,14,28,16],[28,17,28,19],[42,23,42,25]],"flags":["formulas_cached_only"]}
["Forfaitaire vergoedingen wegens laattijdige heraansluiting"]
[]
[{"$nulls":3},"Waarden af te leiden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[{"$nulls":3},"door distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[{"$nulls":3},"=> Bedragen EUR gecorrigeerd voor indexatie"]
[]
[null,"Forfaitaire vergoedingen wegens laattijdige heraansluiting voor de gereguleerde activiteit elektriciteit"]
[]
[null,null,2018,null,null,2019,null,null,2020,null,null,"n.v.t.",null,null,"n.v.t.",null,null,"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,"dnb2",{"v":11,"d":"11.00 €"},100,{"v":0.11,"d":"0.11 €"},0,200,0,{"v":11,"d":"11.00 €"},100,{"v":0.11,"d":"0.11 €"},{"v":11,"d":"11.00 €"},100,{"v":0.11,"d":"0.11 €"},null,null,"",null,null,"",null,{"v":0.0825,"d":"0.08 €"},null,"dnb2",{"v":0.0825,"d":"0.08 €"},{"v":1,"d":"1.00000"},{"v":0.4,"d":"0.40000"},0.86]
[null,"dnb1",{"v":10,"d":"10.00 €"},100,{"v":0.1,"d":"0.10 €"},{"v":1,"d":"1.00 €"},200,{"v":0.005,"d":"0.01 €"},{"v":10,"d":"10.00 €"},100,{"v":0.1,"d":"0.10 €"},{"v":10,"d":"10.00 €"},100,{"v":0.1,"d":"0.10 €"},null,null,"",null,null,"",null,{"v":0.07625000000000001,"d":"0.08 €"},null,"dnb1",{"v":0.07625000000000001,"d":"0.08 €"},{"v":0.9242424242424243,"d":"0.92424"},{"v":0.44545454545454544,"d":"0.44545"},0.96]
[null,"dnb3",{"v":9,"d":"9.00 €"},100,{"v":0.09,"d":"0.09 €"},{"v":2,"d":"2.00 €"},200,{"v":0.01,"d":"0.01 €"},{"v":9,"d":"9.00 €"},100,{"v":0.09,"d":"0.09 €"},{"v":9,"d":"9.00 €"},100,{"v":0.09,"d":"0.09 €"},null,null,"",null,null,"",null,{"v":0.07,"d":"0.07 €"},null,"dnb3",{"v":0.07,"d":"0.07 €"},{"v":0.8484848484848485,"d":"0.84848"},{"v":0.49090909090909096,"d":"0.49091"},1.06]
[null,"dnb10",{"v":8,"d":"8.00 €"},100,{"v":0.08,"d":"0.08 €"},{"v":3,"d":"3.00 €"},200,{"v":0.015,"d":"0.02 €"},{"v":8,"d":"8.00 €"},100,{"v":0.08,"d":"0.08 €"},{"v":8,"d":"8.00 €"},100,{"v":0.08,"d":"0.08 €"},null,null,"",null,null,"",null,{"v":0.06375,"d":"0.06 €"},null,"dnb10",{"v":0.06375,"d":"0.06 €"},{"v":0.7727272727272727,"d":"0.77273"},{"v":0.5363636363636364,"d":"0.53636"},1.16]
[null,"dnb8",{"v":7,"d":"7.00 €"},100,{"v":0.07,"d":"0.07 €"},{"v":4,"d":"4.00 €"},200,{"v":0.02,"d":"0.02 €"},{"v":7,"d":"7.00 €"},100,{"v":0.07,"d":"0.07 €"},{"v":7,"d":"7.00 €"},100,{"v":0.07,"d":"0.07 €"},null,null,"",null,null,"",null,{"v":0.05750000000000001,"d":"0.06 €"},null,"dnb8",{"v":0.05750000000000001,"d":"0.06 €"},{"v":0.696969696969697,"d":"0.69697"},{"v":0.5818181818181818,"d":"0.58182"},1.26]
[null,"dnb4",{"v":6,"d":"6.00 €"},100,{"v":0.06,"d":"0.06 €"},{"v":5,"d":"5.00 €"},200,{"v":0.025,"d":"0.03 €"},{"v":6,"d":"6.00 €"},100,{"v":0.06,"d":"0.06 €"},{"v":6,"d":"6.00 €"},100,{"v":0.06,"d":"0.06 €"},null,null,"",null,null,"",null,{"v":0.05125,"d":"0.05 €"},null,"dnb4",{"v":0.05125,"d":"0.05 €"},{"v":0.6212121212121211,"d":"0.62121"},{"v":0.6272727272727274,"d":"0.62727"},1.35]
[null,"dnb9",{"v":5,"d":"5.00 €"},100,{"v":0.05,"d":"0.05 €"},{"v":6,"d":"6.00 €"},200,{"v":0.03,"d":"0.03 €"},{"v":5,"d":"5.00 €"},100,{"v":0.05,"d":"0.05 €"},{"v":5,"d":"5.00 €"},100,{"v":0.05,"d":"0.05 €"},null,null,"",null,null,"",null,{"v":0.045,"d":"0.05 €"},null,"dnb9",{"v":0.045,"d":"0.05 €"},{"v":0.5454545454545454,"d":"0.54545"},{"v":0.6727272727272728,"d":"0.67273"},1.45]
[null,"dnb5",{"v":4,"d":"4.00 €"},100,{"v":0.04,"d":"0.04 €"},{"v":7,"d":"7.00 €"},200,{"v":0.035,"d":"0.04 €"},{"v":4,"d":"4.00 €"},100,{"v":0.04,"d":"0.04 €"},{"v":4,"d":"4.00 €"},100,{"v":0.04,"d":"0.04 €"},null,null,"",null,null,"",null,{"v":0.03875000000000001,"d":"0.04 €"},null,"dnb5",{"v":0.03875000000000001,"d":"0.04 €"},{"v":0.4696969696969698,"d":"0.46970"},{"v":0.7181818181818181,"d":"0.71818"},1.55]
[null,"dnb6",{"v":3,"d":"3.00 €"},100,{"v":0.03,"d":"0.03 €"},{"v":8,"d":"8.00 €"},200,{"v":0.04,"d":"0.04 €"},{"v":3,"d":"3.00 €"},100,{"v":0.03,"d":"0.03 €"},{"v":3,"d":"3.00 €"},100,{"v":0.03,"d":"0.03 €"},null,null,"",null,null,"",null,{"v":0.0325,"d":"0.03 €"},null,"dnb6",{"v":0.0325,"d":"0.03 €"},{"v":0.3939393939393939,"d":"0.39394"},{"v":0.7636363636363637,"d":"0.76364"},1.65]
[null,"dnb11",{"v":2,"d":"2.00 €"},100,{"v":0.02,"d":"0.02 €"},{"v":9,"d":"9.00 €"},200,{"v":0.045,"d":"0.05 €"},{"v":2,"d":"2.00 €"},100,{"v":0.02,"d":"0.02 €"},{"v":2,"d":"2.00 €"},100,{"v":0.02,"d":"0.02 €"},null,null,"",null,null,"",null,{"v":0.026250000000000002,"d":"0.03 €"},null,"dnb11",{"v":0.026250000000000002,"d":"0.03 €"},{"v":0.3181818181818182,"d":"0.31818"},{"v":0.8090909090909091,"d":"0.80909"},1.75]
[null,"dnb7",0,100,0,{"v":11,"d":"11.00 €"},200,{"v":0.055,"d":"0.06 €"},0,100,0,0,100,0,null,null,"",null,null,"",null,{"v":0.01375,"d":"0.01 €"},null,"dnb7",{"v":0.01375,"d":"0.01 €"},{"v":0.16666666666666666,"d":"0.16667"},{"v":0.9,"d":"0.90000"},1.94]
[{"$nulls":20},"Maximum:",{"v":0.0825,"d":"0.08 €"},{"$nulls":3},"Totaal:",{"v":6.945454545454545,"d":"6.94545"},14.99]
[]
[{"$nulls":23},"Aantal te verdelen punten:",null,null,{"v":14.999999999999996,"d":"15.00"}]
[]
[]
[null,"Forfaitaire vergoedingen wegens laattijdige heraansluiting voor de gereguleerde activiteit aardgas"]
[]
[null,null,2018,null,null,2019,null,null,2020,null,null,"n.v.t.",null,null,"n.v.t.",null,null,"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,"dnb2",{"v":10,"d":"10.00 €"},200,{"v":0.05,"d":"0.05 €"},{"v":1,"d":"1.00 €"},150,{"v":0.006666666666666667,"d":"0.01 €"},{"v":10,"d":"10.00 €"},200,{"v":0.05,"d":"0.05 €"},{"v":10,"d":"10.00 €"},200,{"v":0.05,"d":"0.05 €"},null,null,"",null,null,"",null,{"v":0.03916666666666667,"d":"0.04 €"},null,"dnb2",{"v":0.03916666666666667,"d":"0.04 €"},{"v":1,"d":"1.00000"},{"v":0.4,"d":"0.40000"},{"v":1.1,"d":"1.10"}]
[null,"dnb1",{"v":9,"d":"9.00 €"},200,{"v":0.045,"d":"0.05 €"},{"v":2,"d":"2.00 €"},150,{"v":0.013333333333333334,"d":"0.01 €"},{"v":9,"d":"9.00 €"},200,{"v":0.045,"d":"0.05 €"},{"v":9,"d":"9.00 €"},200,{"v":0.045,"d":"0.05 €"},null,null,"",null,null,"",null,{"v":0.03708333333333333,"d":"0.04 €"},null,"dnb1",{"v":0.03708333333333333,"d":"0.04 €"},{"v":0.9468085106382977,"d":"0.94681"},{"v":0.4319148936170214,"d":"0.43191"},1.19]
[null,"dnb3",{"v":8,"d":"8.00 €"},200,{"v":0.04,"d":"0.04 €"},{"v":3,"d":"3.00 €"},150,{"v":0.02,"d":"0.02 €"},{"v":8,"d":"8.00 €"},200,{"v":0.04,"d":"0.04 €"},{"v":8,"d":"8.00 €"},200,{"v":0.04,"d":"0.04 €"},null,null,"",null,null,"",null,{"v":0.035,"d":"0.04 €"},null,"dnb3",{"v":0.035,"d":"0.04 €"},{"v":0.8936170212765958,"d":"0.89362"},{"v":0.46382978723404256,"d":"0.46383"},1.28]
[null,"dnb10",{"v":7,"d":"7.00 €"},200,{"v":0.035,"d":"0.04 €"},{"v":4,"d":"4.00 €"},150,{"v":0.02666666666666667,"d":"0.03 €"},{"v":7,"d":"7.00 €"},200,{"v":0.035,"d":"0.04 €"},{"v":7,"d":"7.00 €"},200,{"v":0.035,"d":"0.04 €"},null,null,"",null,null,"",null,{"v":0.03291666666666667,"d":"0.03 €"},null,"dnb10",{"v":0.03291666666666667,"d":"0.03 €"},{"v":0.8404255319148937,"d":"0.84043"},{"v":0.4957446808510638,"d":"0.49574"},1.37]
[null,"dnb8",{"v":6,"d":"6.00 €"},200,{"v":0.03,"d":"0.03 €"},{"v":5,"d":"5.00 €"},150,{"v":0.03333333333333333,"d":"0.03 €"},{"v":6,"d":"6.00 €"},200,{"v":0.03,"d":"0.03 €"},{"v":6,"d":"6.00 €"},200,{"v":0.03,"d":"0.03 €"},null,null,"",null,null,"",null,{"v":0.03083333333333333,"d":"0.03 €"},null,"dnb8",{"v":0.03083333333333333,"d":"0.03 €"},{"v":0.7872340425531914,"d":"0.78723"},{"v":0.5276595744680852,"d":"0.52766"},1.46]
[null,"dnb4",{"v":5,"d":"5.00 €"},200,{"v":0.025,"d":"0.03 €"},{"v":6,"d":"6.00 €"},150,{"v":0.04,"d":"0.04 €"},{"v":5,"d":"5.00 €"},200,{"v":0.025,"d":"0.03 €"},{"v":5,"d":"5.00 €"},200,{"v":0.025,"d":"0.03 €"},null,null,"",null,null,"",null,{"v":0.028749999999999998,"d":"0.03 €"},null,"dnb4",{"v":0.028749999999999998,"d":"0.03 €"},{"v":0.7340425531914893,"d":"0.73404"},{"v":0.5595744680851065,"d":"0.55957"},1.54]
[null,"dnb9",{"v":4,"d":"4.00 €"},200,{"v":0.02,"d":"0.02 €"},{"v":7,"d":"7.00 €"},150,{"v":0.04666666666666667,"d":"0.05 €"},{"v":4,"d":"4.00 €"},200,{"v":0.02,"d":"0.02 €"},{"v":4,"d":"4.00 €"},200,{"v":0.02,"d":"0.02 €"},null,null,"",null,null,"",null,{"v":0.02666666666666667,"d":"0.03 €"},null,"dnb9",{"v":0.02666666666666667,"d":"0.03 €"},{"v":0.6808510638297872,"d":"0.68085"},{"v":0.5914893617021277,"d":"0.59149"},1.63]
[null,"dnb5",{"v":3,"d":"3.00 €"},200,{"v":0.015,"d":"0.02 €"},{"v":8,"d":"8.00 €"},150,{"v":0.05333333333333334,"d":"0.05 €"},{"v":3,"d":"3.00 €"},200,{"v":0.015,"d":"0.02 €"},{"v":3,"d":"3.00 €"},200,{"v":0.015,"d":"0.02 €"},null,null,"",null,null,"",null,{"v":0.024583333333333332,"d":"0.02 €"},null,"dnb5",{"v":0.024583333333333332,"d":"0.02 €"},{"v":0.6276595744680851,"d":"0.62766"},{"v":0.623404255319149,"d":"0.62340"},1.72]
[null,"dnb6",{"v":2,"d":"2.00 €"},200,{"v":0.01,"d":"0.01 €"},{"v":9,"d":"9.00 €"},150,{"v":0.06,"d":"0.06 €"},{"v":2,"d":"2.00 €"},200,{"v":0.01,"d":"0.01 €"},{"v":2,"d":"2.00 €"},200,{"v":0.01,"d":"0.01 €"},null,null,"",null,null,"",null,{"v":0.022499999999999996,"d":"0.02 €"},null,"dnb6",{"v":0.022499999999999996,"d":"0.02 €"},{"v":0.5744680851063828,"d":"0.57447"},{"v":0.6553191489361703,"d":"0.65532"},1.81]
[null,"dnb7",{"v":1,"d":"1.00 €"},200,{"v":0.005,"d":"0.01 €"},{"v":10,"d":"10.00 €"},150,{"v":0.06666666666666667,"d":"0.07 €"},{"v":1,"d":"1.00 €"},200,{"v":0.005,"d":"0.01 €"},{"v":1,"d":"1.00 €"},200,{"v":0.005,"d":"0.01 €"},null,null,"",null,null,"",null,{"v":0.02041666666666667,"d":"0.02 €"},null,"dnb7",{"v":0.02041666666666667,"d":"0.02 €"},{"v":0.5212765957446809,"d":"0.52128"},{"v":0.6872340425531915,"d":"0.68723"},{"v":1.9,"d":"1.90"}]
[{"$nulls":20},"Maximum:",{"v":0.03916666666666667,"d":"0.04 €"},{"$nulls":3},"Totaal:",{"v":5.4361702127659575,"d":"5.43617"},{"v":15.000000000000002,"d":"15.00"}]
[]
[{"$nulls":23},"Aantal te verdelen punten:",null,null,{"v":14.999999999999996,"d":"15.00"}]

{"sheet":"E1","index":9,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[7,1,13,1],[7,3,13,3],[14,1,17,1],[14,3,17,3]],"flags":["formulas_cached_only"]}
["Klantentevredenheid"]
[]
[{"$nulls":4},"Cellen in te vullen door de VREG volgens evaluatie door panel"]
[]
[null,"Klantentevredenheid voor de gereguleerde activiteiten elektriciteit en aardgas"]
[]
[null,"Netbedrijf (werkmaatschappij of distributienetbeheerder zonder werkmaatschappij)","Distributienetbeheerder","Gemiddelde score van het panel voor de beoordeelde periode 2018 t.e.m. 2020","Verschil t.o.v. minimale score 3","Puntenverdeling"]
[null,"Netbedrijf 1","dnb2",{"v":8.5,"d":"8.50"},{"v":5.5,"d":"5.50"},{"v":29,"d":"29.00"}]
[null,null,"dnb1",null,{"v":5.5,"d":"5.50"},{"v":29,"d":"29.00"}]
[null,null,"dnb3",null,{"v":5.5,"d":"5.50"},{"v":29,"d":"29.00"}]
[null,null,"dnb4",null,{"v":5.5,"d":"5.50"},{"v":29,"d":"29.00"}]
[null,null,"dnb5",null,{"v":5.5,"d":"5.50"},{"v":29,"d":"29.00"}]
[null,null,"dnb6",null,{"v":5.5,"d":"5.50"},{"v":29,"d":"29.00"}]
[null,null,"dnb7",null,{"v":5.5,"d":"5.50"},{"v":29,"d":"29.00"}]
[null,"Netbedrijf 2","dnb10",{"v":7.6,"d":"7.60"},{"v":4.6,"d":"4.60"},24.25]
[null,null,"dnb8",null,{"v":4.6,"d":"4.60"},24.25]
[null,null,"dnb9",null,{"v":4.6,"d":"4.60"},24.25]
[null,null,"dnb11",null,{"v":4.6,"d":"4.60"},24.25]
[]
[{"$nulls":3},"Totaal:",{"v":56.900000000000006,"d":"56.90"},{"v":300,"d":"300.00"}]
[]
[]
[{"$nulls":3},"Te verdelen punten:",{"v":300,"d":"300.00"}]

{"sheet":"E2","index":10,"n_rows":23,"n_cols":6,"rows_kept":23,"merged":[[7,1,13,1],[7,3,13,3],[14,1,17,1],[14,3,17,3]],"flags":["formulas_cached_only"]}
["Betrekken van belanghebbenden"]
[]
[{"$nulls":4},"Cellen in te vullen door de VREG volgens evaluatie door panel"]
[]
[null,"Betrekken van belanghebbenden voor de gereguleerde activiteiten elektriciteit en aardgas"]
[]
[null,"Netbedrijf (werkmaatschappij of distributienetbeheerder zonder werkmaatschappij)","Distributienetbeheerder","Gemiddelde score van het panel voor de beoordeelde periode 2018 t.e.m. 2020","Verschil t.o.v. minimale score 3","Puntenverdeling"]
[null,"Netbedrijf 1","dnb2",{"v":7.5,"d":"7.50"},{"v":4.5,"d":"4.50"},6.22]
[null,null,"dnb1",null,{"v":4.5,"d":"4.50"},6.22]
[null,null,"dnb3",null,{"v":4.5,"d":"4.50"},6.22]
[null,null,"dnb4",null,{"v":4.5,"d":"4.50"},6.22]
[null,null,"dnb5",null,{"v":4.5,"d":"4.50"},6.22]
[null,null,"dnb6",null,{"v":4.5,"d":"4.50"},6.22]
[null,null,"dnb7",null,{"v":4.5,"d":"4.50"},6.22]
[null,"Netbedrijf 2","dnb10",{"v":8.7,"d":"8.70"},{"v":5.699999999999999,"d":"5.70"},7.87]
[null,null,"dnb8",null,{"v":5.699999999999999,"d":"5.70"},7.87]
[null,null,"dnb9",null,{"v":5.699999999999999,"d":"5.70"},7.87]
[null,null,"dnb11",null,{"v":5.699999999999999,"d":"5.70"},7.87]
[]
[{"$nulls":3},"Totaal:",{"v":54.30000000000001,"d":"54.30"},75.02]
[]
[]
[{"$nulls":3},"Te verdelen punten:",{"v":74.99999999999997,"d":"75.00"}]

{"sheet":"Totaalscore","index":11,"n_rows":46,"n_cols":13,"rows_kept":46,"merged":[[16,3,16,11],[34,3,34,7]],"flags":["formulas_cached_only"]}
["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,"Noodzakelijke ordening"]
[]
[]
[]
[]
[]
[null,"Totaalscore voor de gereguleerde activiteit elektriciteit"]
[]
[]
[{"$nulls":3},"Punten op kwaliteitsindicator"]
[null,"Distributienetbeheerder","Netbedrijf","A1","A2","A3","A4","B1","D1","D2","E1","E2","Totaal punten"]
[1,"dnb2","netbedrijf1 ",{"v":46.98166666666666,"d":"46.98"},{"v":37.53333333333334,"d":"37.53"},{"v":20.683333333333334,"d":"20.68"},{"v":17.563333333333333,"d":"17.56"},13.44,{"v":1,"d":"1.00"},{"v":0.4,"d":"0.40"},{"v":29,"d":"29.00"},6.22,172.82]
[2,"dnb1","netbedrijf1 ",{"v":46.98166666666666,"d":"46.98"},{"v":37.53333333333334,"d":"37.53"},{"v":20.683333333333334,"d":"20.68"},{"v":17.563333333333333,"d":"17.56"},13.44,{"v":0.9454545454545454,"d":"0.95"},{"v":0.44545454545454544,"d":"0.45"},{"v":29,"d":"29.00"},6.22,172.81]
[3,"dnb3","netbedrijf1 ",{"v":46.98166666666666,"d":"46.98"},{"v":37.53333333333334,"d":"37.53"},{"v":20.683333333333334,"d":"20.68"},{"v":17.563333333333333,"d":"17.56"},13.44,{"v":0.8909090909090909,"d":"0.89"},{"v":0.49090909090909096,"d":"0.49"},{"v":29,"d":"29.00"},6.22,{"v":172.8,"d":"172.80"}]
[4,"dnb4","netbedrijf1 ",{"v":46.98166666666666,"d":"46.98"},{"v":37.53333333333334,"d":"37.53"},{"v":20.683333333333334,"d":"20.68"},14.45,13.44,{"v":0.7272727272727273,"d":"0.73"},{"v":0.6272727272727274,"d":"0.63"},{"v":29,"d":"29.00"},6.22,169.66]
[5,"dnb5","netbedrijf1 ",{"v":46.98166666666666,"d":"46.98"},{"v":37.53333333333334,"d":"37.53"},{"v":20.683333333333334,"d":"20.68"},{"v":14.4,"d":"14.40"},13.44,{"v":0.6181818181818182,"d":"0.62"},{"v":0.7181818181818181,"d":"0.72"},{"v":29,"d":"29.00"},6.22,169.59]
[6,"dnb6","netbedrijf1 ",{"v":46.98166666666666,"d":"46.98"},{"v":37.53333333333334,"d":"37.53"},{"v":20.683333333333334,"d":"20.68"},14.29,13.44,{"v":0.5636363636363637,"d":"0.56"},{"v":0.7636363636363637,"d":"0.76"},{"v":29,"d":"29.00"},6.22,169.48]
[7,"dnb7","netbedrijf1 ",40.17,33.58,15.56,14.28,13.44,{"v":0.4,"d":"0.40"},{"v":0.9,"d":"0.90"},{"v":29,"d":"29.00"},6.22,153.55]
[8,"dnb8","netbedrijf2",38.78,32.79,16.45,{"v":14.1,"d":"14.10"},13.98,{"v":0.7818181818181819,"d":"0.78"},{"v":0.5818181818181818,"d":"0.58"},24.25,7.87,149.58]
[9,"dnb9","netbedrijf2",34.35,31.81,16.91,13.94,13.98,{"v":0.6727272727272728,"d":"0.67"},{"v":0.6727272727272728,"d":"0.67"},24.25,7.87,144.46]
[10,"dnb10","netbedrijf2",33.32,30.54,14.72,{"v":12.5,"d":"12.50"},13.98,{"v":0.8363636363636364,"d":"0.84"},{"v":0.5363636363636364,"d":"0.54"},24.25,7.87,138.55]
[11,"dnb11","netbedrijf2",33.49,24.08,10.26,11.34,13.98,{"v":0.509090909090909,"d":"0.51"},{"v":0.8090909090909091,"d":"0.81"},24.25,7.87,126.59]
[]
[]
[null,"Totaalscore voor de gereguleerde activiteit aardgas"]
[]
[]
[{"$nulls":3},"Punten op kwaliteitsindicator"]
[null,"Distributienetbeheerder","Netbedrijf","B1","D1","D2","E1","E2","Totaal punten"]
[1,"dnb2","netbedrijf1 ",11.79,{"v":0.8235294117647058,"d":"0.82"},{"v":0.4,"d":"0.40"},{"v":29,"d":"29.00"},6.22,48.23]
[2,"dnb1","netbedrijf1 ",11.79,{"v":0.7764705882352941,"d":"0.78"},{"v":0.4319148936170214,"d":"0.43"},{"v":29,"d":"29.00"},6.22,48.22]
[3,"dnb3","netbedrijf1 ",11.79,{"v":0.7294117647058824,"d":"0.73"},{"v":0.46382978723404256,"d":"0.46"},{"v":29,"d":"29.00"},6.22,{"v":48.2,"d":"48.20"}]
[4,"dnb4","netbedrijf1 ",11.79,{"v":0.5882352941176471,"d":"0.59"},{"v":0.5595744680851065,"d":"0.56"},{"v":29,"d":"29.00"},6.22,48.16]
[5,"dnb5","netbedrijf1 ",11.79,{"v":0.49411764705882355,"d":"0.49"},{"v":0.623404255319149,"d":"0.62"},{"v":29,"d":"29.00"},6.22,48.13]
[6,"dnb6","netbedrijf1 ",11.79,{"v":0.44705882352941184,"d":"0.45"},{"v":0.6553191489361703,"d":"0.66"},{"v":29,"d":"29.00"},6.22,48.11]
[7,"dnb7","netbedrijf1 ",11.79,{"v":0.4,"d":"0.40"},{"v":0.6872340425531915,"d":"0.69"},{"v":29,"d":"29.00"},6.22,{"v":48.1,"d":"48.10"}]
[8,"dnb10","netbedrijf2",22.49,{"v":0.6823529411764706,"d":"0.68"},{"v":0.4957446808510638,"d":"0.50"},24.25,7.87,55.79]
[9,"dnb8","netbedrijf2",22.49,{"v":0.6352941176470588,"d":"0.64"},{"v":0.5276595744680852,"d":"0.53"},24.25,7.87,55.77]
[10,"dnb9","netbedrijf2",22.49,{"v":0.5411764705882354,"d":"0.54"},{"v":0.5914893617021277,"d":"0.59"},24.25,7.87,55.74]

{"sheet":"Data","index":12,"n_rows":34,"n_cols":11,"rows_kept":34,"merged":[[0,1,0,5],[6,1,7,1],[6,2,7,2],[6,3,6,8],[21,1,22,1],[21,2,22,2],[21,3,21,8]],"flags":["formulas_cached_only"]}
[null,"Gegevens betreffende aantal actieve toegangspunten en oorspronkelijk toegelaten inkomen niet-exogene kosten in volgende reguleringsperiode"]
[]
[{"$nulls":4},"Waarden uit jaarlijkse rapportering m.b.t. kwaliteit dienstverlening door iedere "]
[{"$nulls":4},"distributienetbeheerder afzonderlijk (in te vullen door de VREG)."]
[]
[]
[null,"Distributienetbeheerder","Netbedrijf","Aantal actieve toegangspunten elektriciteit op 1 juli van het jaar",{"$nulls":5},"Aantal actieve toegangspunten elektriciteit op 1 januari 2021","Oorspronkelijk toegelaten inkomen voor niet-exogene kosten (zonder kwaliteitsprestatie-invloed) voor het eerste jaar van de volgende reguleringsperiode 2022"]
[{"$nulls":3},2017,{"$nulls":5},2021,2022]
[null,"dnb1","Netbedr1",{"v":313620,"d":"313,620"},{"v":313620,"d":"313,620"},{"v":313620,"d":"313,620"},{"$nulls":3},{"v":313620,"d":"313,620"},{"v":65000000,"d":"65,000,000.00 €"}]
[null,"dnb3","Netbedr1",{"v":590984,"d":"590,984"},{"v":590984,"d":"590,984"},{"v":590984,"d":"590,984"},{"$nulls":3},{"v":590984,"d":"590,984"},{"v":160000000,"d":"160,000,000.00 €"}]
[null,"dnb4","Netbedr1",{"v":300708,"d":"300,708"},{"v":300708,"d":"300,708"},{"v":300708,"d":"300,708"},{"$nulls":3},{"v":300708,"d":"300,708"},{"v":80000000,"d":"80,000,000.00 €"}]
[null,"dnb5","Netbedr1",{"v":375443,"d":"375,443"},{"v":375443,"d":"375,443"},{"v":375443,"d":"375,443"},{"$nulls":3},{"v":375443,"d":"375,443"},{"v":110000000,"d":"110,000,000.00 €"}]
[null,"dnb6","Netbedr1",{"v":516756,"d":"516,756"},{"v":516756,"d":"516,756"},{"v":516756,"d":"516,756"},{"$nulls":3},{"v":516756,"d":"516,756"},{"v":145000000,"d":"145,000,000.00 €"}]
[null,"dnb7","Netbedr1",{"v":61010,"d":"61,010"},{"v":61010,"d":"61,010"},{"v":61010,"d":"61,010"},{"$nulls":3},{"v":61010,"d":"61,010"},{"v":20000000,"d":"20,000,000.00 €"}]
[null,"dnb2","Netbedr1",{"v":438104,"d":"438,104"},{"v":438104,"d":"438,104"},{"v":438104,"d":"438,104"},{"$nulls":3},{"v":438104,"d":"438,104"},{"v":160000000,"d":"160,000,000.00 €"}]
[null,"dnb8","Netbedr1",{"v":419574,"d":"419,574"},{"v":419574,"d":"419,574"},{"v":419574,"d":"419,574"},{"$nulls":3},{"v":419574,"d":"419,574"},{"v":105000000,"d":"105,000,000.00 €"}]
[null,"dnb9","Netbedr2",{"v":87612,"d":"87,612"},{"v":87612,"d":"87,612"},{"v":87612,"d":"87,612"},{"$nulls":3},{"v":87612,"d":"87,612"},{"v":30000000,"d":"30,000,000.00 €"}]
[null,"dnb10","Netbedr2",{"v":133701,"d":"133,701"},{"v":133701,"d":"133,701"},{"v":133701,"d":"133,701"},{"$nulls":3},{"v":133701,"d":"133,701"},{"v":40000000,"d":"40,000,000.00 €"}]
[null,"dnb11","Netbedr3",{"v":2110,"d":"2,110"},{"v":2110,"d":"2,110"},{"v":2110,"d":"2,110"},{"$nulls":3},{"v":10000,"d":"10,000"},{"v":1300000,"d":"1,300,000.00 €"}]
[{"$nulls":3},{"v":3239622,"d":"3,239,622"},{"v":3239622,"d":"3,239,622"},{"v":3239622,"d":"3,239,622"},null,0,0,{"v":3247512,"d":"3,247,512"},{"v":916300000,"d":"916,300,000.00 €"}]
[]
[null,"Distributienetbeheerder","Netbedrijf","Aantal actieve toegangspunten aardgas 1 juli van het jaar",{"$nulls":5},"Aantal actieve toegangspunten aardgas op 1 januari 2021","Oorspronkelijk toegelaten inkomen voor niet-exogene kosten (zonder kwaliteitsprestatie-invloed) voor het eerste jaar van de volgende reguleringsperiode 2022"]
[{"$nulls":9},2021,2022]
[null,"dnb1","Netbedr1",{"v":234075,"d":"234,075"},{"v":234075,"d":"234,075"},{"v":234075,"d":"234,075"},{"$nulls":3},{"v":234075,"d":"234,075"},{"v":35000000,"d":"35,000,000.00 €"}]
[null,"dnb3","Netbedr1",{"v":379939,"d":"379,939"},{"v":379939,"d":"379,939"},{"v":379939,"d":"379,939"},{"$nulls":3},{"v":379939,"d":"379,939"},{"v":85000000,"d":"85,000,000.00 €"}]
[null,"dnb4","Netbedr1",{"v":185007,"d":"185,007"},{"v":185007,"d":"185,007"},{"v":185007,"d":"185,007"},{"$nulls":3},{"v":185007,"d":"185,007"},{"v":40000000,"d":"40,000,000.00 €"}]
[null,"dnb5","Netbedr1",{"v":252083,"d":"252,083"},{"v":252083,"d":"252,083"},{"v":252083,"d":"252,083"},{"$nulls":3},{"v":252083,"d":"252,083"},{"v":55000000,"d":"55,000,000.00 €"}]
[null,"dnb6","Netbedr1",{"v":324583,"d":"324,583"},{"v":324583,"d":"324,583"},{"v":324583,"d":"324,583"},{"$nulls":3},{"v":324583,"d":"324,583"},{"v":80000000,"d":"80,000,000.00 €"}]
[null,"dnb7","Netbedr1",{"v":43766,"d":"43,766"},{"v":43766,"d":"43,766"},{"v":43766,"d":"43,766"},{"$nulls":3},{"v":43766,"d":"43,766"},{"v":12000000,"d":"12,000,000.00 €"}]
[null,"dnb2","Netbedr1",{"v":280222,"d":"280,222"},{"v":280222,"d":"280,222"},{"v":280222,"d":"280,222"},{"$nulls":3},{"v":280222,"d":"280,222"},{"v":70000000,"d":"70,000,000.00 €"}]
[null,"dnb8","Netbedr2",{"v":217312,"d":"217,312"},{"v":217312,"d":"217,312"},{"v":217312,"d":"217,312"},{"$nulls":3},{"v":217312,"d":"217,312"},{"v":45000000,"d":"45,000,000.00 €"}]
[null,"dnb9","Netbedr2",{"v":72935,"d":"72,935"},{"v":72935,"d":"72,935"},{"v":72935,"d":"72,935"},{"$nulls":3},{"v":72935,"d":"72,935"},{"v":12000000,"d":"12,000,000.00 €"}]
[null,"dnb10","Netbedr2",{"v":51404,"d":"51,404"},{"v":51404,"d":"51,404"},{"v":51404,"d":"51,404"},{"$nulls":3},{"v":51404,"d":"51,404"},{"v":12000000,"d":"12,000,000.00 €"}]
[{"$nulls":3},{"v":2041326,"d":"2,041,326"},{"v":2041326,"d":"2,041,326"},{"v":2041326,"d":"2,041,326"},null,0,0,{"v":2041326,"d":"2,041,326"},{"v":446000000,"d":"446,000,000.00 €"}]

{"sheet":"Berekeningsmodel Q E","index":13,"n_rows":28,"n_cols":237,"rows_kept":28,"merged":[[0,0,0,6],[3,3,3,4],[5,1,5,6],[5,16,5,18],[7,20,7,27],[7,28,7,34]],"flags":["formulas_cached_only"]}
["Berekeningsmodel verdeling kwaliteitsbedrag elektriciteit",{"$nulls":235},"elektriciteit"]
[{"$nulls":236},"aardgas"]
[]
[null,null,"Gereguleerde activiteit:","elektriciteit"]
[]
[null,"Resultaat impact kwaliteitsprestaties in periode 2018-2020 naar toegelaten inkomen in reguleringsperiode 2022-2024",{"$nulls":6},"Bijdrage aan kwaliteitsbedrag Q",null,null,"Recuperatie uit kwaliteitsbedrag Q",{"$nulls":4},"Invloed kwaliteitsbedrag",{"$nulls":3},"Beperking impact cap/floor",{"$nulls":16},"q-factor"]
[]
[{"$nulls":20},"Marge tot cap",{"$nulls":7},"Marge tot floor",{"$nulls":6},"Cap & floor"]
[null,"Distributienetbeheerder","Totaal aantal punten voor kwaliteitsprestatie (hoog>laag)","Aantal actieve toegangspunten elektriciteit 1 jan. 2021","Oorspronkelijk toegelaten inkomen niet-exogene kosten elektriciteit 2022 (zonder q-factor)","qi-waarde 2022-2024","EUR/tp/jaar (appr.)",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,"Oorspronkelijk toegelaten inkomen niet-exogene kosten elektriciteit 2022 (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)","Aantal actieve toegangspunten elektriciteit 1 jan. 2021","potentieel+/tp","score","overflow/tp","bedrag ontvangen","Voorlopige impact na toepassing cap","bedrag onder floor te ontvangen (positieve waarde)","bedrag mogelijk af te staan (positieve waarde)","Aantal actieve toegangspunten elektriciteit 1 jan. 2021","potentieel-/tp","score","underflow/tp","bedrag af te staan (negatieve waarde)","Cap & floor correctie",null,"Oorspronkelijk toegelaten inkomen niet-exogene kosten elektriciteit","Gecorrigeerd toegelaten inkomen niet-exogene kosten elektriciteit","Effect kwaliteit dienstverlening op TI jaar 2022","qi-waarde 2022-2024","Impact per toegangspunt"]
[1,"dnb2",172.82,{"v":438104,"d":"438,104 "},{"v":160000000,"d":"160,000,000.00 €"},{"v":0.0004,"d":"0.0400%"},{"v":0.13,"d":"0.13 €"},null,{"v":-1390646.23,"d":"-1,390,646.23 €"},{"v":-3.1742376924200646,"d":"-3.17 €"},null,{"v":23.314196615747687,"d":"23.31 "},{"v":0.1405020332065895,"d":"14.05%"},{"v":1448347.65,"d":"1,448,347.65 €"},{"v":3.305944821320965,"d":"3.31 €"},null,{"v":160000000,"d":"160,000,000.00 €"},{"v":57701.419999999925,"d":"57,701.42 €"},{"v":0.00036063387499999955,"d":"0.0361%"},null,0,{"v":2342298.58,"d":"2,342,298.58 €"},{"v":438104,"d":"438,104 "},{"v":5.346444177638187,"d":"5.35 €"},{"v":172.82,"d":"172.82 "},0,0,{"v":0.0003606338750001825,"d":"0.04%"},0,{"v":2457701.42,"d":"2,457,701.42 €"},{"v":438104,"d":"438,104.00 €"},{"v":5.609858435439986,"d":"5.61 €"},{"v":172.82,"d":"172.82 "},0,0,0,null,{"v":160000000,"d":"160,000,000.00 €"},{"v":160057701.42000002,"d":"160,057,701.42 €"},{"v":57701.42000001669,"d":"57,701.42 €"},{"v":0.0004,"d":"0.0400%"},{"v":0.13,"d":"0.13 €"}]
[2,"dnb1",172.81,{"v":313620,"d":"313,620 "},{"v":65000000,"d":"65,000,000.00 €"},{"v":0.0006,"d":"0.0600%"},{"v":0.13,"d":"0.13 €"},null,{"v":-995504.43,"d":"-995,504.43 €"},{"v":-3.1742377080543336,"d":"-3.17 €"},null,{"v":16.68867496101631,"d":"16.69 "},{"v":0.10057360337962025,"d":"10.06%"},{"v":1036750.42,"d":"1,036,750.42 €"},{"v":3.305753523372234,"d":"3.31 €"},null,{"v":65000000,"d":"65,000,000.00 €"},{"v":41245.98999999999,"d":"41,245.99 €"},{"v":0.0006345536923076921,"d":"0.0635%"},null,0,{"v":933754.01,"d":"933,754.01 €"},{"v":313620,"d":"313,620 "},{"v":2.977342038135323,"d":"2.98 €"},{"v":172.81,"d":"172.81 "},0,0,{"v":0.0006345536923078043,"d":"0.06%"},0,{"v":1016245.99,"d":"1,016,245.99 €"},{"v":313620,"d":"313,620.00 €"},{"v":3.240373668771124,"d":"3.24 €"},{"v":172.81,"d":"172.81 "},0,0,0,null,{"v":65000000,"d":"65,000,000.00 €"},{"v":65041245.99,"d":"65,041,245.99 €"},{"v":41245.990000002086,"d":"41,245.99 €"},{"v":0.0006,"d":"0.0600%"},{"v":0.13,"d":"0.13 €"}]
[3,"dnb3",{"v":172.8,"d":"172.80"},{"v":590984,"d":"590,984 "},{"v":160000000,"d":"160,000,000.00 €"},{"v":0.0005,"d":"0.0500%"},{"v":0.13,"d":"0.13 €"},null,{"v":-1875923.69,"d":"-1,875,923.69 €"},{"v":-3.1742376950983444,"d":"-3.17 €"},null,{"v":31.44623798156866,"d":"31.45 "},{"v":0.18950944121850377,"d":"18.95%"},{"v":1953534.39,"d":"1,953,534.39 €"},{"v":3.3055622318032296,"d":"3.31 €"},null,{"v":160000000,"d":"160,000,000.00 €"},{"v":77610.69999999995,"d":"77,610.70 €"},{"v":0.0004850668749999997,"d":"0.0485%"},null,0,{"v":2322389.3000000003,"d":"2,322,389.30 €"},{"v":590984,"d":"590,984 "},{"v":3.929699111989496,"d":"3.93 €"},{"v":172.8,"d":"172.80 "},0,0,{"v":0.0004850668749998288,"d":"0.05%"},0,{"v":2477610.7,"d":"2,477,610.70 €"},{"v":590984,"d":"590,984.00 €"},{"v":4.192348185399267,"d":"4.19 €"},{"v":172.8,"d":"172.80 "},0,0,0,null,{"v":160000000,"d":"160,000,000.00 €"},{"v":160077610.7,"d":"160,077,610.70 €"},{"v":77610.69999998808,"d":"77,610.70 €"},{"v":0.0005,"d":"0.0500%"},{"v":0.13,"d":"0.13 €"}]
[4,"dnb4",169.66,{"v":300708,"d":"300,708 "},{"v":80000000,"d":"80,000,000.00 €"},{"v":0.0003,"d":"0.0300%"},{"v":0.07,"d":"0.07 €"},null,{"v":-954518.67,"d":"-954,518.67 €"},{"v":-3.1742376990302885,"d":"-3.17 €"},null,{"v":15.709909395253968,"d":"15.71 "},{"v":0.09467511353290944,"d":"9.47%"},{"v":975946.57,"d":"975,946.57 €"},{"v":3.2454958630964255,"d":"3.25 €"},null,{"v":80000000,"d":"80,000,000.00 €"},{"v":21427.899999999907,"d":"21,427.90 €"},{"v":0.00026784874999999885,"d":"0.0268%"},null,0,{"v":1178572.1,"d":"1,178,572.10 €"},{"v":300708,"d":"300,708 "},{"v":3.9193240618806287,"d":"3.92 €"},{"v":169.66,"d":"169.66 "},0,0,{"v":0.000267848749999855,"d":"0.03%"},0,{"v":1221427.9,"d":"1,221,427.90 €"},{"v":300708,"d":"300,708.00 €"},{"v":4.061840390012903,"d":"4.06 €"},{"v":169.66,"d":"169.66 "},0,0,0,null,{"v":80000000,"d":"80,000,000.00 €"},{"v":80021427.89999999,"d":"80,021,427.90 €"},{"v":21427.89999999106,"d":"21,427.90 €"},{"v":0.0003,"d":"0.0300%"},{"v":0.07,"d":"0.07 €"}]
[5,"dnb5",169.59,{"v":375443,"d":"375,443 "},{"v":110000000,"d":"110,000,000.00 €"},{"v":0.0002,"d":"0.0200%"},{"v":0.07,"d":"0.07 €"},null,{"v":-1191745.32,"d":"-1,191,745.32 €"},{"v":-3.1742376872121736,"d":"-3.17 €"},null,{"v":19.606202646826247,"d":"19.61 "},{"v":0.11815596225515321,"d":"11.82%"},{"v":1217995.97,"d":"1,217,995.97 €"},{"v":3.2441568227400697,"d":"3.24 €"},null,{"v":110000000,"d":"110,000,000.00 €"},{"v":26250.649999999907,"d":"26,250.65 €"},{"v":0.00023864227272727187,"d":"0.0239%"},null,0,{"v":1623749.35,"d":"1,623,749.35 €"},{"v":375443,"d":"375,443 "},{"v":4.324889130973277,"d":"4.32 €"},{"v":169.59,"d":"169.59 "},0,0,{"v":0.00023864227272740735,"d":"0.02%"},0,{"v":1676250.65,"d":"1,676,250.65 €"},{"v":375443,"d":"375,443.00 €"},{"v":4.4647274020290695,"d":"4.46 €"},{"v":169.59,"d":"169.59 "},0,0,0,null,{"v":110000000,"d":"110,000,000.00 €"},{"v":110026250.65,"d":"110,026,250.65 €"},{"v":26250.65000000596,"d":"26,250.65 €"},{"v":0.0002,"d":"0.0200%"},{"v":0.07,"d":"0.07 €"}]
[6,"dnb6",169.48,{"v":516756,"d":"516,756 "},{"v":145000000,"d":"145,000,000.00 €"},{"v":0.0002,"d":"0.0200%"},{"v":0.07,"d":"0.07 €"},null,{"v":-1640306.37,"d":"-1,640,306.37 €"},{"v":-3.174237686645148,"d":"-3.17 €"},null,{"v":26.96827814031172,"d":"26.97 "},{"v":0.16252320306140228,"d":"16.25%"},{"v":1675350.12,"d":"1,675,350.12 €"},{"v":3.242052574135569,"d":"3.24 €"},null,{"v":145000000,"d":"145,000,000.00 €"},{"v":35043.75,"d":"35,043.75 €"},{"v":0.00024168103448275863,"d":"0.0242%"},null,0,{"v":2139956.25,"d":"2,139,956.25 €"},{"v":516756,"d":"516,756 "},{"v":4.141134790887769,"d":"4.14 €"},{"v":169.48,"d":"169.48 "},0,0,{"v":0.00024168103448274358,"d":"0.02%"},0,{"v":2210043.75,"d":"2,210,043.75 €"},{"v":516756,"d":"516,756.00 €"},{"v":4.2767645658686115,"d":"4.28 €"},{"v":169.48,"d":"169.48 "},0,0,0,null,{"v":145000000,"d":"145,000,000.00 €"},{"v":145035043.75,"d":"145,035,043.75 €"},{"v":35043.75,"d":"35,043.75 €"},{"v":0.0002,"d":"0.0200%"},{"v":0.07,"d":"0.07 €"}]
[7,"dnb7",153.55,{"v":61010,"d":"61,010 "},{"v":20000000,"d":"20,000,000.00 €"},{"v":-0.0007,"d":"-0.0700%"},{"v":-0.24,"d":"-0.24 €"},null,{"v":-193660.24,"d":"-193,660.24 €"},{"v":-3.1742376659564004,"d":"-3.17 €"},null,{"v":2.8846961920387053,"d":"2.88 "},{"v":0.01738450124809271,"d":"1.74%"},{"v":179205.96,"d":"179,205.96 €"},{"v":2.937321094902475,"d":"2.94 €"},null,{"v":20000000,"d":"20,000,000.00 €"},{"v":-14454.279999999999,"d":"-14,454.28 €"},{"v":-0.000722714,"d":"-0.0723%"},null,0,{"v":314454.27999999997,"d":"314,454.28 €"},{"v":61010,"d":"61,010 "},{"v":5.1541432552040645,"d":"5.15 €"},{"v":153.55,"d":"153.55 "},0,0,{"v":-0.0007227139999999022,"d":"-0.07%"},0,{"v":285545.72,"d":"285,545.72 €"},{"v":61010,"d":"61,010.00 €"},{"v":4.680310113096214,"d":"4.68 €"},{"v":153.55,"d":"153.55 "},0,0,0,null,{"v":20000000,"d":"20,000,000.00 €"},{"v":19985545.720000003,"d":"19,985,545.72 €"},{"v":-14454.279999997467,"d":"-14,454.28 €"},{"v":-0.0007,"d":"-0.0700%"},{"v":-0.24,"d":"-0.24 €"}]
[8,"dnb8",149.58,{"v":419574,"d":"419,574 "},{"v":105000000,"d":"105,000,000.00 €"},{"v":-0.0013,"d":"-0.1300%"},{"v":-0.31,"d":"-0.31 €"},null,{"v":-1331827.61,"d":"-1,331,827.61 €"},{"v":-3.1742377030035227,"d":"-3.17 €"},null,{"v":19.32552640914029,"d":"19.33 "},{"v":0.11646447861891177,"d":"11.65%"},{"v":1200559.52,"d":"1,200,559.52 €"},{"v":2.8613773017393833,"d":"2.86 €"},null,{"v":105000000,"d":"105,000,000.00 €"},{"v":-131268.09000000008,"d":"-131,268.09 €"},{"v":-0.0012501722857142866,"d":"-0.1250%"},null,0,{"v":1706268.09,"d":"1,706,268.09 €"},{"v":419574,"d":"419,574 "},{"v":4.066667834517868,"d":"4.07 €"},{"v":149.58,"d":"149.58 "},0,0,{"v":-0.001250172285714335,"d":"-0.13%"},0,{"v":1443731.91,"d":"1,443,731.91 €"},{"v":419574,"d":"419,574.00 €"},{"v":3.440947031989589,"d":"3.44 €"},{"v":149.58,"d":"149.58 "},0,0,0,null,{"v":105000000,"d":"105,000,000.00 €"},{"v":104868731.91,"d":"104,868,731.91 €"},{"v":-131268.09000000358,"d":"-131,268.09 €"},{"v":-0.0013,"d":"-0.1300%"},{"v":-0.31,"d":"-0.31 €"}]
[9,"dnb9",144.46,{"v":87612,"d":"87,612 "},{"v":30000000,"d":"30,000,000.00 €"},{"v":-0.0012,"d":"-0.1200%"},{"v":-0.41,"d":"-0.41 €"},null,{"v":-278101.31,"d":"-278,101.31 €"},{"v":-3.174237661507556,"d":"-3.17 €"},null,{"v":3.897269515863221,"d":"3.90 "},{"v":0.023486732138262127,"d":"2.35%"},{"v":242110.04,"d":"242,110.04 €"},{"v":2.7634346893119663,"d":"2.76 €"},null,{"v":30000000,"d":"30,000,000.00 €"},{"v":-35991.26999999999,"d":"-35,991.27 €"},{"v":-0.0011997089999999998,"d":"-0.1200%"},null,0,{"v":485991.26999999996,"d":"485,991.27 €"},{"v":87612,"d":"87,612 "},{"v":5.547085673195452,"d":"5.55 €"},{"v":144.46,"d":"144.46 "},0,0,{"v":-0.0011997089999999933,"d":"-0.12%"},0,{"v":414008.73,"d":"414,008.73 €"},{"v":87612,"d":"87,612.00 €"},{"v":4.725479728804273,"d":"4.73 €"},{"v":144.46,"d":"144.46 "},0,0,0,null,{"v":30000000,"d":"30,000,000.00 €"},{"v":29964008.73,"d":"29,964,008.73 €"},{"v":-35991.26999999955,"d":"-35,991.27 €"},{"v":-0.0012,"d":"-0.1200%"},{"v":-0.41,"d":"-0.41 €"}]
[11,"dnb10",138.55,{"v":133701,"d":"133,701 "},{"v":40000000,"d":"40,000,000.00 €"},{"v":-0.0018,"d":"-0.1800%"},{"v":-0.52,"d":"-0.52 €"},null,{"v":-424398.75,"d":"-424,398.75 €"},{"v":-3.174237664639756,"d":"-3.17 €"},null,{"v":5.704143217946539,"d":"5.70 "},{"v":0.0343757811187767,"d":"3.44%"},{"v":354358.44,"d":"354,358.44 €"},{"v":2.6503798774878273,"d":"2.65 €"},null,{"v":40000000,"d":"40,000,000.00 €"},{"v":-70040.31,"d":"-70,040.31 €"},{"v":-0.00175100775,"d":"-0.1751%"},null,0,{"v":670040.3099999999,"d":"670,040.31 €"},{"v":133701,"d":"133,701 "},{"v":5.011483160185787,"d":"5.01 €"},{"v":138.55,"d":"138.55 "},0,0,{"v":-0.0017510077500000332,"d":"-0.18%"},0,{"v":529959.69,"d":"529,959.69 €"},{"v":133701,"d":"133,701.00 €"},{"v":3.9637675858819303,"d":"3.96 €"},{"v":138.55,"d":"138.55 "},0,0,0,null,{"v":40000000,"d":"40,000,000.00 €"},{"v":39929959.69,"d":"39,929,959.69 €"},{"v":-70040.31000000238,"d":"-70,040.31 €"},{"v":-0.0018,"d":"-0.1800%"},{"v":-0.52,"d":"-0.52 €"}]
[12,"dnb11",126.59,{"v":10000,"d":"10,000 "},{"v":1300000,"d":"1,300,000.00 €"},{"v":-0.0058,"d":"-0.5800%"},{"v":-0.75,"d":"-0.75 €"},null,{"v":-31742.38,"d":"-31,742.38 €"},{"v":-3.174238,"d":"-3.17 €"},null,{"v":0.38980610387274933,"d":"0.39 "},{"v":0.002349150221778031,"d":"0.23%"},{"v":24215.92,"d":"24,215.92 €"},{"v":2.421592,"d":"2.42 €"},null,{"v":1300000,"d":"1,300,000.00 €"},{"v":-7526.460000000003,"d":"-7,526.46 €"},{"v":-0.005789584615384618,"d":"-0.5790%"},null,0,{"v":27026.460000000003,"d":"27,026.46 €"},{"v":10000,"d":"10,000 "},{"v":2.702646,"d":"2.70 €"},{"v":126.59,"d":"126.59 "},0,0,{"v":-0.005789584615384591,"d":"-0.58%"},0,{"v":11973.54,"d":"11,973.54 €"},{"v":10000,"d":"10,000.00 €"},{"v":1.197354,"d":"1.20 €"},{"v":126.59,"d":"126.59 "},0,0,0,null,{"v":1300000,"d":"1,300,000.00 €"},{"v":1292473.54,"d":"1,292,473.54 €"},{"v":-7526.459999999963,"d":"-7,526.46 €"},{"v":-0.0058,"d":"-0.5800%"},{"v":-0.75,"d":"-0.75 €"}]
[null,"Totaal:",null,{"v":3247512,"d":"3,247,512 "},{"v":916300000,"d":"916,300,000.00 €"},{"$nulls":3},{"v":-10308375.000000002,"d":"-10,308,375.00 €"},null,null,{"v":165.93494117958613,"d":"165.93 "},{"v":0.9999999999999997,"d":"100.00%"},{"v":10308374.999999998,"d":"10,308,375.00 €"},{"$nulls":3},{"v":-3.892637323588133e-10,"d":"-0.00 €"},null,null,0,{"$nulls":5},0,null,0,{"$nulls":5},0,0,null,{"v":916300000,"d":"916,300,000.00 €"},{"v":916300000,"d":"916,300,000.00 €"},{"v":9.313225746154785e-10,"d":"0.00 €"}]
[{"$nulls":25},"saldo:",0,{"$nulls":6},"saldo:",0]
[{"$nulls":3}," %TI in balans voor kwaliteitsprikkel:",{"v":0.01125,"d":"1.1250%"},{"$nulls":12},"cap elek:",{"v":0.015,"d":"1.50%"},{"$nulls":7},"floor elek:",{"v":-0.015,"d":"-1.50%"},{"$nulls":11},"cap/floor elek:","+/- 1,5%"]
[{"$nulls":3},"Te verdelen kwaliteitsbedrag Q:",{"v":10308375,"d":"10,308,375.00 €"}]
[]
[{"$nulls":3},"cap/floor/jaar in reguleringsperiode:",{"v":0.015,"d":"1.5000%"}]
[]
[{"$nulls":3},"cap/floor controle:"]

{"sheet":"Berekeningsmodel Q G","index":14,"n_rows":27,"n_cols":237,"rows_kept":27,"merged":[[0,0,0,6],[3,3,3,4],[5,1,5,6],[5,16,5,18],[7,20,7,27],[7,28,7,34]],"flags":["formulas_cached_only"]}
["Berekeningsmodel verdeling kwaliteitsbedrag aardgas",{"$nulls":235},"elektriciteit"]
[{"$nulls":236},"aardgas"]
[]
[null,null,"Gereguleerde activiteit:","aardgas"]
[]
[null,"Resultaat impact kwaliteitsprestaties in periode 2018-2020 naar toegelaten inkomen in reguleringsperiode 2022-2024",{"$nulls":6},"Bijdrage aan kwaliteitsbedrag Q",null,null,"Recuperatie uit kwaliteitsbedrag Q",{"$nulls":4},"Netto invloed kwaliteitsbedrag",{"$nulls":3},"Beperking impact cap/floor",{"$nulls":16},"q-factor"]
[]
[{"$nulls":20},"Marge tot cap",{"$nulls":7},"Marge tot floor",{"$nulls":6},"Cap & floor"]
[null,"Distributienetbeheerder","Totaal aantal punten voor kwaliteitsprestatie (hoog>laag)","Aantal actieve toegangspunten aardgas 1 jan. 2021","Oorspronkelijk toegelaten inkomen niet-exogene kosten aardgas 2022 (zonder q-factor)","qi-waarde 2022-2024","EUR/tp/jaar (appr.)",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,"Oorspronkelijk toegelaten inkomen niet-exogene kosten aardgas 2022 (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)","Aantal actieve toegangspunten aardgas 1 jan. 2021","potentieel+/tp","score","overflow/tp","bedrag ontvangen","Voorlopige impact na toepassing cap","bedrag onder floor te ontvangen (positieve waarde)","bedrag mogelijk af te staan (positieve waarde)","Aantal actieve toegangspunten aardgas 1 jan. 2021","potentieel-/tp","score","underflow/tp","bedrag af te staan (negatieve waarde)","Cap & floor correctie",null,"Oorspronkelijk toegelaten inkomen niet-exogene kosten aardgas","Gecorrigeerd toegelaten inkomen niet-exogene kosten aardgas","Effect kwaliteit dienstverlening op TI jaar 2022","qi-waarde 2022-2024","Impact per toegangspunt"]
[1,"dnb2",48.23,{"v":280222,"d":"280,222 "},{"v":70000000,"d":"70,000,000.00 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"},null,{"v":-229591.6,"d":"-229,591.60 €"},{"v":-0.8193203959717653,"d":"-0.82 €"},null,{"v":6.620748993546351,"d":"6.62 "},{"v":0.13390375139786756,"d":"13.39%"},{"v":223954.0242129335,"d":"223,954.02 €"},{"v":0.7992021476291422,"d":"0.80 €"},null,{"v":70000000,"d":"70,000,000.00 €"},{"v":-5637.575787066511,"d":"-5,637.58 €"},{"v":-8.053679695809301e-05,"d":"-0.0081%"},null,0,{"v":355637.57578706654,"d":"355,637.58 €"},{"v":280222,"d":"280,222 "},{"v":1.2691279620695968,"d":"1.27 €"},{"v":48.23,"d":"48.23 "},0,0,{"v":-8.053679695807503e-05,"d":"-0.01%"},0,{"v":344362.42,"d":"344,362.42 €"},{"v":280222,"d":"280,222.00 €"},{"v":1.2288914503500796,"d":"1.23 €"},{"v":48.23,"d":"48.23 "},0,0,0,null,{"v":70000000,"d":"70,000,000.00 €"},{"v":69994362.42421293,"d":"69,994,362.42 €"},{"v":-5637.575787067413,"d":"-5,637.58 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"}]
[2,"dnb1",48.22,{"v":234075,"d":"234,075 "},{"v":35000000,"d":"35,000,000.00 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"},null,{"v":-191782.42,"d":"-191,782.42 €"},{"v":-0.819320388764285,"d":"-0.82 €"},null,{"v":5.529296398517435,"d":"5.53 "},{"v":0.1118292705362958,"d":"11.18%"},{"v":187034.45497195472,"d":"187,034.45 €"},{"v":0.7990364411917322,"d":"0.80 €"},null,{"v":35000000,"d":"35,000,000.00 €"},{"v":-4747.965028045292,"d":"-4,747.97 €"},{"v":-0.0001356561436584369,"d":"-0.0136%"},null,0,{"v":179747.9650280453,"d":"179,747.97 €"},{"v":234075,"d":"234,075 "},{"v":0.7679075724790998,"d":"0.77 €"},{"v":48.22,"d":"48.22 "},0,0,{"v":-0.00013565614365851353,"d":"-0.01%"},0,{"v":170252.03,"d":"170,252.03 €"},{"v":234075,"d":"234,075.00 €"},{"v":0.7273396560931326,"d":"0.73 €"},{"v":48.22,"d":"48.22 "},0,0,0,null,{"v":35000000,"d":"35,000,000.00 €"},{"v":34995252.03497195,"d":"34,995,252.03 €"},{"v":-4747.965028047562,"d":"-4,747.97 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"}]
[3,"dnb3",{"v":48.2,"d":"48.20"},{"v":379939,"d":"379,939 "},{"v":85000000,"d":"85,000,000.00 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"},null,{"v":-311291.77,"d":"-311,291.77 €"},{"v":-0.8193203909048559,"d":"-0.82 €"},null,{"v":8.971158844790102,"d":"8.97 "},{"v":0.18144047219952117,"d":"18.14%"},{"v":303459.1897536992,"d":"303,459.19 €"},{"v":0.7987050283169118,"d":"0.80 €"},null,{"v":85000000,"d":"85,000,000.00 €"},{"v":-7832.580246300844,"d":"-7,832.58 €"},{"v":-9.2148002897657e-05,"d":"-0.0092%"},null,0,{"v":432832.58024630084,"d":"432,832.58 €"},{"v":379939,"d":"379,939 "},{"v":1.1392159800554849,"d":"1.14 €"},{"v":48.2,"d":"48.20 "},0,0,{"v":-9.21480028976962e-05,"d":"-0.01%"},0,{"v":417167.42,"d":"417,167.42 €"},{"v":379939,"d":"379,939.00 €"},{"v":1.097985255527861,"d":"1.10 €"},{"v":48.2,"d":"48.20 "},0,0,0,null,{"v":85000000,"d":"85,000,000.00 €"},{"v":84992167.4197537,"d":"84,992,167.42 €"},{"v":-7832.580246299505,"d":"-7,832.58 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"}]
[4,"dnb4",48.16,{"v":185007,"d":"185,007 "},{"v":40000000,"d":"40,000,000.00 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"},null,{"v":-151580.01,"d":"-151,580.01 €"},{"v":-0.8193204040928181,"d":"-0.82 €"},null,{"v":4.364779128860358,"d":"4.36 "},{"v":0.08827706652936511,"d":"8.83%"},{"v":147643.39377036315,"d":"147,643.39 €"},{"v":0.7980422025672712,"d":"0.80 €"},null,{"v":40000000,"d":"40,000,000.00 €"},{"v":-3936.6162296368566,"d":"-3,936.62 €"},{"v":-9.841540574092141e-05,"d":"-0.0098%"},null,0,{"v":203936.61622963686,"d":"203,936.62 €"},{"v":185007,"d":"185,007 "},{"v":1.1023183783837198,"d":"1.10 €"},{"v":48.16,"d":"48.16 "},0,0,{"v":-9.84154057409592e-05,"d":"-0.01%"},0,{"v":196063.38,"d":"196,063.38 €"},{"v":185007,"d":"185,007.00 €"},{"v":1.059761954953056,"d":"1.06 €"},{"v":48.16,"d":"48.16 "},0,0,0,null,{"v":40000000,"d":"40,000,000.00 €"},{"v":39996063.38377036,"d":"39,996,063.38 €"},{"v":-3936.6162296384573,"d":"-3,936.62 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"}]
[5,"dnb5",48.13,{"v":252083,"d":"252,083 "},{"v":55000000,"d":"55,000,000.00 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"},null,{"v":-206536.74,"d":"-206,536.74 €"},{"v":-0.8193203825724067,"d":"-0.82 €"},null,{"v":5.943565501051768,"d":"5.94 "},{"v":0.12020780700877755,"d":"12.02%"},{"v":201047.55722218045,"d":"201,047.56 €"},{"v":0.7975450832550408,"d":"0.80 €"},null,{"v":55000000,"d":"55,000,000.00 €"},{"v":-5489.182777819544,"d":"-5,489.18 €"},{"v":-9.980332323308261e-05,"d":"-0.0100%"},null,0,{"v":280489.1827778196,"d":"280,489.18 €"},{"v":252083,"d":"252,083 "},{"v":1.1126858327527822,"d":"1.11 €"},{"v":48.13,"d":"48.13 "},0,0,{"v":-9.980332323311636e-05,"d":"-0.01%"},0,{"v":269510.82,"d":"269,510.82 €"},{"v":252083,"d":"252,083.00 €"},{"v":1.0691352451375142,"d":"1.07 €"},{"v":48.13,"d":"48.13 "},0,0,0,null,{"v":55000000,"d":"55,000,000.00 €"},{"v":54994510.81722218,"d":"54,994,510.82 €"},{"v":-5489.182777822018,"d":"-5,489.18 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"}]
[6,"dnb6",48.11,{"v":324583,"d":"324,583 "},{"v":80000000,"d":"80,000,000.00 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"},null,{"v":-265937.47,"d":"-265,937.47 €"},{"v":-0.8193203895459712,"d":"-0.82 €"},null,{"v":7.649776728459834,"d":"7.65 "},{"v":0.15471569792109005,"d":"15.47%"},{"v":258762.0047730231,"d":"258,762.00 €"},{"v":0.7972136703802205,"d":"0.80 €"},null,{"v":80000000,"d":"80,000,000.00 €"},{"v":-7175.46522697687,"d":"-7,175.47 €"},{"v":-8.969331533721088e-05,"d":"-0.0090%"},null,0,{"v":407175.4652269769,"d":"407,175.47 €"},{"v":324583,"d":"324,583 "},{"v":1.254457150334358,"d":"1.25 €"},{"v":48.11,"d":"48.11 "},0,0,{"v":-8.96933153372581e-05,"d":"-0.01%"},0,{"v":392824.53,"d":"392,824.53 €"},{"v":324583,"d":"324,583.00 €"},{"v":1.2102436972977637,"d":"1.21 €"},{"v":48.11,"d":"48.11 "},0,0,0,null,{"v":80000000,"d":"80,000,000.00 €"},{"v":79992824.53477302,"d":"79,992,824.53 €"},{"v":-7175.465226978064,"d":"-7,175.47 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"}]
[7,"dnb7",{"v":48.1,"d":"48.10"},{"v":43766,"d":"43,766 "},{"v":12000000,"d":"12,000,000.00 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"},null,{"v":-35858.38,"d":"-35,858.38 €"},{"v":-0.8193204770826669,"d":"-0.82 €"},null,{"v":1.0312633063018841,"d":"1.03 "},{"v":0.02085716065167177,"d":"2.09%"},{"v":34883.601189921035,"d":"34,883.60 €"},{"v":0.7970479639428103,"d":"0.80 €"},null,{"v":12000000,"d":"12,000,000.00 €"},{"v":-974.7788100789621,"d":"-974.78 €"},{"v":-8.123156750658018e-05,"d":"-0.0081%"},null,0,{"v":60974.77881007896,"d":"60,974.78 €"},{"v":43766,"d":"43,766 "},{"v":1.3931997169053365,"d":"1.39 €"},{"v":48.1,"d":"48.10 "},0,0,{"v":-8.123156750672322e-05,"d":"-0.01%"},0,{"v":59025.22,"d":"59,025.22 €"},{"v":43766,"d":"43,766.00 €"},{"v":1.3486546634373715,"d":"1.35 €"},{"v":48.1,"d":"48.10 "},0,0,0,null,{"v":12000000,"d":"12,000,000.00 €"},{"v":11999025.22118992,"d":"11,999,025.22 €"},{"v":-974.7788100801408,"d":"-974.78 €"},{"v":-0.0001,"d":"-0.0100%"},{"v":-0.02,"d":"-0.02 €"}]
[8,"dnb10",55.79,{"v":51404,"d":"51,404 "},{"v":12000000,"d":"12,000,000.00 €"},{"v":0.0005,"d":"0.0500%"},{"v":0.11,"d":"0.11 €"},null,{"v":-42116.34,"d":"-42,116.34 €"},{"v":-0.8193202863590381,"d":"-0.82 €"},null,{"v":1.4048854323121345,"d":"1.40 "},{"v":0.02841361753091399,"d":"2.84%"},{"v":47521.77532045365,"d":"47,521.78 €"},{"v":0.9244762143112141,"d":"0.92 €"},null,{"v":12000000,"d":"12,000,000.00 €"},{"v":5405.435320453653,"d":"5,405.44 €"},{"v":0.0004504529433711377,"d":"0.0450%"},null,0,{"v":54594.56467954635,"d":"54,594.56 €"},{"v":51404,"d":"51,404 "},{"v":1.0620684125660718,"d":"1.06 €"},{"v":55.79,"d":"55.79 "},0,0,{"v":0.00045045294337109354,"d":"0.05%"},0,{"v":65405.44,"d":"65,405.44 €"},{"v":51404,"d":"51,404.00 €"},{"v":1.2723803595050969,"d":"1.27 €"},{"v":55.79,"d":"55.79 "},0,0,0,null,{"v":12000000,"d":"12,000,000.00 €"},{"v":12005405.435320454,"d":"12,005,405.44 €"},{"v":5405.435320453718,"d":"5,405.44 €"},{"v":0.0005,"d":"0.0500%"},{"v":0.11,"d":"0.11 €"}]
[9,"dnb8",55.77,{"v":217312,"d":"217,312 "},{"v":45000000,"d":"45,000,000.00 €"},{"v":0.0005,"d":"0.0500%"},{"v":0.1,"d":"0.10 €"},null,{"v":-178048.15,"d":"-178,048.15 €"},{"v":-0.8193203780739213,"d":"-0.82 €"},null,{"v":5.937067494363958,"d":"5.94 "},{"v":0.12007638570388375,"d":"12.01%"},{"v":200827.75508974557,"d":"200,827.76 €"},{"v":0.9241448014363935,"d":"0.92 €"},null,{"v":45000000,"d":"45,000,000.00 €"},{"v":22779.60508974557,"d":"22,779.61 €"},{"v":0.0005062134464387905,"d":"0.0506%"},null,0,{"v":202220.39491025443,"d":"202,220.39 €"},{"v":217312,"d":"217,312 "},{"v":0.9305532824245989,"d":"0.93 €"},{"v":55.77,"d":"55.77 "},0,0,{"v":0.0005062134464388635,"d":"0.05%"},0,{"v":247779.61,"d":"247,779.61 €"},{"v":217312,"d":"217,312.00 €"},{"v":1.1402021517449565,"d":"1.14 €"},{"v":55.77,"d":"55.77 "},0,0,0,null,{"v":45000000,"d":"45,000,000.00 €"},{"v":45022779.60508975,"d":"45,022,779.61 €"},{"v":22779.605089746416,"d":"22,779.61 €"},{"v":0.0005,"d":"0.0500%"},{"v":0.1,"d":"0.10 €"}]
[10,"dnb9",55.74,{"v":72935,"d":"72,935 "},{"v":12000000,"d":"12,000,000.00 €"},{"v":0.0006,"d":"0.0600%"},{"v":0.1,"d":"0.10 €"},null,{"v":-59757.13,"d":"-59,757.13 €"},{"v":-0.8193203537396312,"d":"-0.82 €"},null,{"v":1.9915471120242432,"d":"1.99 "},{"v":0.040278770520613356,"d":"4.03%"},{"v":67366.24369572583,"d":"67,366.24 €"},{"v":0.923647682124163,"d":"0.92 €"},null,{"v":12000000,"d":"12,000,000.00 €"},{"v":7609.113695725835,"d":"7,609.11 €"},{"v":0.0006340928079771529,"d":"0.0634%"},null,0,{"v":52390.886304274165,"d":"52,390.89 €"},{"v":72935,"d":"72,935 "},{"v":0.7183229766816229,"d":"0.72 €"},{"v":55.74,"d":"55.74 "},0,0,{"v":0.0006340928079771047,"d":"0.06%"},0,{"v":67609.11,"d":"67,609.11 €"},{"v":72935,"d":"72,935.00 €"},{"v":0.926977582779187,"d":"0.93 €"},{"v":55.74,"d":"55.74 "},0,0,0,null,{"v":12000000,"d":"12,000,000.00 €"},{"v":12007609.113695726,"d":"12,007,609.11 €"},{"v":7609.113695725799,"d":"7,609.11 €"},{"v":0.0006,"d":"0.0600%"},{"v":0.1,"d":"0.10 €"}]
[null,"Totaal:",null,{"v":2041326,"d":"2,041,326 "},{"v":446000000,"d":"446,000,000.00 €"},{"$nulls":3},{"v":-1672500.0099999998,"d":"-1,672,500.01 €"},null,null,{"v":49.44408894022806,"d":"49.44 "},{"v":1.0000000000000002,"d":"100.00%"},{"v":1672500.0000000005,"d":"1,672,500.00 €"},{"$nulls":3},{"v":-0.009999999820138328,"d":"-0.01 €"},null,null,0,{"$nulls":5},0,null,0,{"$nulls":5},0,0,null,{"v":446000000,"d":"446,000,000.00 €"},{"v":445999999.98999995,"d":"445,999,999.99 €"},{"v":-0.010000007227063179,"d":"-0.01 €"}]
[{"$nulls":25},"saldo:",0,{"$nulls":6},"saldo:",0]
[{"$nulls":3}," %TI in balans voor kwaliteitsprikkel:",{"v":0.00375,"d":"0.3750%"},{"$nulls":12},"cap gas:",{"v":0.005,"d":"0.50%"},{"$nulls":7},"floor gas:",{"v":-0.005,"d":"-0.50%"},{"$nulls":11},"cap/floor gas:","+/- 0,5%"]
[{"$nulls":3},"Te verdelen kwaliteitsbedrag Q:",{"v":1672500,"d":"1,672,500.00 €"}]
[]
[{"$nulls":3},"cap/floor/jaar in reguleringsperiode:",{"v":0.005,"d":"0.5000%"}]
[]
[{"$nulls":3},"cap/floor controle:"]

{"sheet":"U G","index":15,"n_rows":35,"n_cols":23,"rows_kept":35,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,null,"Macro:","laag>hoog",{"$nulls":5},"laag>hoog"]
[]
[null,null,"Distributienet-beheerder","finale score","Aantal actieve toegangspunten gas","Toegelaten niet-exogene kosten gas","Underflow","max bedrag","Aantal actieve toegangspunten gas","potentieel/tp","ontvanger?","dnb1","dnb2","dnb3","dnb4","dnb5","dnb6","dnb7","dnb8","dnb9","dnb10","overflow EUR","overflow EUR/tp"]
[null,"dnb1","dnb9",{"v":55.74,"d":"55.74 "},{"v":72935,"d":"72,935 "},{"v":12000000,"d":"12,000,000.00 €"},0,{"v":67609.11,"d":"67,609.11 €"},{"v":72935,"d":"72,935 "},{"v":0.926977582779187,"d":"0.93 €"},"j",{"v":72935,"d":"72,935 "},{"$nulls":9},0,0]
[null,"dnb2","dnb8",{"v":55.77,"d":"55.77 "},{"v":217312,"d":"217,312 "},{"v":45000000,"d":"45,000,000.00 €"},0,{"v":247779.61,"d":"247,779.61 €"},{"v":217312,"d":"217,312 "},{"v":1.1402021517449565,"d":"1.14 €"},"j",0,{"v":217312,"d":"217,312 "},{"$nulls":8},0,0]
[null,"dnb3","dnb10",{"v":55.79,"d":"55.79 "},{"v":51404,"d":"51,404 "},{"v":12000000,"d":"12,000,000.00 €"},0,{"v":65405.44,"d":"65,405.44 €"},{"v":51404,"d":"51,404 "},{"v":1.2723803595050969,"d":"1.27 €"},"j",0,0,{"v":51404,"d":"51,404 "},{"$nulls":7},0,0]
[null,"dnb4","dnb7",{"v":48.1,"d":"48.10 "},{"v":43766,"d":"43,766 "},{"v":12000000,"d":"12,000,000.00 €"},0,{"v":59025.22,"d":"59,025.22 €"},{"v":43766,"d":"43,766 "},{"v":1.3486546634373715,"d":"1.35 €"},"j",0,0,0,{"v":43766,"d":"43,766 "},{"$nulls":6},0,0]
[null,"dnb5","dnb6",{"v":48.11,"d":"48.11 "},{"v":324583,"d":"324,583 "},{"v":80000000,"d":"80,000,000.00 €"},0,{"v":392824.53,"d":"392,824.53 €"},{"v":324583,"d":"324,583 "},{"v":1.2102436972977637,"d":"1.21 €"},"j",0,0,0,0,{"v":324583,"d":"324,583 "},{"$nulls":5},0,0]
[null,"dnb6","dnb5",{"v":48.13,"d":"48.13 "},{"v":252083,"d":"252,083 "},{"v":55000000,"d":"55,000,000.00 €"},0,{"v":269510.82,"d":"269,510.82 €"},{"v":252083,"d":"252,083 "},{"v":1.0691352451375142,"d":"1.07 €"},"j",0,0,0,0,0,{"v":252083,"d":"252,083 "},{"$nulls":4},0,0]
[null,"dnb7","dnb4",{"v":48.16,"d":"48.16 "},{"v":185007,"d":"185,007 "},{"v":40000000,"d":"40,000,000.00 €"},0,{"v":196063.38,"d":"196,063.38 €"},{"v":185007,"d":"185,007 "},{"v":1.059761954953056,"d":"1.06 €"},"j",0,0,0,0,0,0,{"v":185007,"d":"185,007 "},{"$nulls":3},0,0]
[null,"dnb8","dnb3",{"v":48.2,"d":"48.20 "},{"v":379939,"d":"379,939 "},{"v":85000000,"d":"85,000,000.00 €"},0,{"v":417167.42,"d":"417,167.42 €"},{"v":379939,"d":"379,939 "},{"v":1.097985255527861,"d":"1.10 €"},"j",0,0,0,0,0,0,0,{"v":379939,"d":"379,939 "},null,null,0,0]
[null,"dnb9","dnb1",{"v":48.22,"d":"48.22 "},{"v":234075,"d":"234,075 "},{"v":35000000,"d":"35,000,000.00 €"},0,{"v":170252.03,"d":"170,252.03 €"},{"v":234075,"d":"234,075 "},{"v":0.7273396560931326,"d":"0.73 €"},"j",0,0,0,0,0,0,0,0,{"v":234075,"d":"234,075 "},null,0,0]
[null,"dnb10","dnb2",{"v":48.23,"d":"48.23 "},{"v":280222,"d":"280,222 "},{"v":70000000,"d":"70,000,000.00 €"},0,{"v":344362.42,"d":"344,362.42 €"},{"v":280222,"d":"280,222 "},{"v":1.2288914503500796,"d":"1.23 €"},"j",0,0,0,0,0,0,0,0,0,{"v":280222,"d":"280,222 "},0,0]
[{"$nulls":6},0,{"$nulls":4},{"v":72935,"d":"72,935 "},{"v":217312,"d":"217,312 "},{"v":51404,"d":"51,404 "},{"v":43766,"d":"43,766 "},{"v":324583,"d":"324,583 "},{"v":252083,"d":"252,083 "},{"v":185007,"d":"185,007 "},{"v":379939,"d":"379,939 "},{"v":234075,"d":"234,075 "},{"v":280222,"d":"280,222 "},0]
[{"$nulls":10},"beschikbaar gebied toegangspunten",{"v":72935,"d":"72,935 "},{"v":217312,"d":"217,312 "},{"v":51404,"d":"51,404 "},{"v":43766,"d":"43,766 "},{"v":324583,"d":"324,583 "},{"v":252083,"d":"252,083 "},{"v":185007,"d":"185,007 "},{"v":379939,"d":"379,939 "},{"v":234075,"d":"234,075 "},{"v":280222,"d":"280,222 "}]
[{"$nulls":10},"beschikbaar potentieel per tp",{"v":0.926977582779187,"d":"0.93 €"},{"v":1.1402021517449565,"d":"1.14 €"},{"v":1.2723803595050969,"d":"1.27 €"},{"v":1.3486546634373715,"d":"1.35 €"},{"v":1.2102436972977637,"d":"1.21 €"},{"v":1.0691352451375142,"d":"1.07 €"},{"v":1.059761954953056,"d":"1.06 €"},{"v":1.097985255527861,"d":"1.10 €"},{"v":0.7273396560931326,"d":"0.73 €"},{"v":1.2288914503500796,"d":"1.23 €"}]
[{"$nulls":10},"volledige vulling van dit gebied",{"v":67609.11,"d":"67,609.11 €"},{"v":247779.61,"d":"247,779.61 €"},{"v":65405.44,"d":"65,405.44 €"},{"v":59025.22,"d":"59,025.22 €"},{"v":392824.53,"d":"392,824.53 €"},{"v":269510.82,"d":"269,510.82 €"},{"v":196063.38,"d":"196,063.38 €"},{"v":417167.42,"d":"417,167.42 €"},{"v":170252.03,"d":"170,252.03 €"},{"v":344362.42000000004,"d":"344,362.42 €"}]
[{"$nulls":10},"beschikbaar te vullen",0,0,0,0,0,0,0,0,0,0,"nvt"]
[{"$nulls":10},"effectieve vulling",0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},"overflow/tp",0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":10},"overflow","dnb1","dnb2","dnb3","dnb4","dnb5","dnb6","dnb7","dnb8","dnb9","dnb10"]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},"saldo:",0]

{"sheet":"U E","index":16,"n_rows":39,"n_cols":25,"rows_kept":39,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,null,"Macro:","laag>hoog",{"$nulls":5},"laag>hoog"]
[{"$nulls":11},"gebied aan samen op te vullen toegangspunten"]
[null,null,"Distributienet-beheerder","finale score","Aantal actieve toegangspunten elektriciteit","Toegelaten niet-exogene kosten elektriciteit","Underflow","max bedrag","Aantal actieve toegangspunten elektriciteit","potentieel/tp","ontvanger?","dnb1","dnb2","dnb3","dnb4","dnb5","dnb6","dnb7","dnb8","dnb9","dnb10","dnb11","dnb12","overflow EUR","overflow EUR/tp"]
[null,"dnb1","dnb11",{"v":126.59,"d":"126.59 "},{"v":10000,"d":"10,000 "},{"v":1300000,"d":"1,300,000.00 €"},0,{"v":-11973.54,"d":"-11,973.54 €"},{"v":10000,"d":"10,000 "},{"v":-1.197354,"d":"-1.20 €"},"j",{"v":10000,"d":"10,000 "},{"$nulls":11},0,0]
[null,"dnb2","dnb10",{"v":138.55,"d":"138.55 "},{"v":133701,"d":"133,701 "},{"v":40000000,"d":"40,000,000.00 €"},0,{"v":-529959.69,"d":"-529,959.69 €"},{"v":133701,"d":"133,701 "},{"v":-3.9637675858819303,"d":"-3.96 €"},"j",0,{"v":133701,"d":"133,701 "},{"$nulls":10},0,0]
[null,"dnb3","dnb9",{"v":144.46,"d":"144.46 "},{"v":87612,"d":"87,612 "},{"v":30000000,"d":"30,000,000.00 €"},0,{"v":-414008.73,"d":"-414,008.73 €"},{"v":87612,"d":"87,612 "},{"v":-4.725479728804273,"d":"-4.73 €"},"j",0,0,{"v":87612,"d":"87,612 "},{"$nulls":9},0,0]
[null,"dnb4","dnb8",{"v":149.58,"d":"149.58 "},{"v":419574,"d":"419,574 "},{"v":105000000,"d":"105,000,000.00 €"},0,{"v":-1443731.91,"d":"-1,443,731.91 €"},{"v":419574,"d":"419,574 "},{"v":-3.440947031989589,"d":"-3.44 €"},"j",0,0,0,{"v":419574,"d":"419,574 "},{"$nulls":8},0,0]
[null,"dnb5","dnb7",{"v":153.55,"d":"153.55 "},{"v":61010,"d":"61,010 "},{"v":20000000,"d":"20,000,000.00 €"},0,{"v":-285545.72,"d":"-285,545.72 €"},{"v":61010,"d":"61,010 "},{"v":-4.680310113096214,"d":"-4.68 €"},"j",0,0,0,0,{"v":61010,"d":"61,010 "},{"$nulls":7},0,0]
[null,"dnb6","dnb6",{"v":169.48,"d":"169.48 "},{"v":516756,"d":"516,756 "},{"v":145000000,"d":"145,000,000.00 €"},0,{"v":-2210043.75,"d":"-2,210,043.75 €"},{"v":516756,"d":"516,756 "},{"v":-4.2767645658686115,"d":"-4.28 €"},"j",0,0,0,0,0,{"v":516756,"d":"516,756 "},{"$nulls":6},0,0]
[null,"dnb7","dnb5",{"v":169.59,"d":"169.59 "},{"v":375443,"d":"375,443 "},{"v":110000000,"d":"110,000,000.00 €"},0,{"v":-1676250.65,"d":"-1,676,250.65 €"},{"v":375443,"d":"375,443 "},{"v":-4.4647274020290695,"d":"-4.46 €"},"j",0,0,0,0,0,0,{"v":375443,"d":"375,443 "},{"$nulls":5},0,0]
[null,"dnb8","dnb4",{"v":169.66,"d":"169.66 "},{"v":300708,"d":"300,708 "},{"v":80000000,"d":"80,000,000.00 €"},0,{"v":-1221427.9,"d":"-1,221,427.90 €"},{"v":300708,"d":"300,708 "},{"v":-4.061840390012903,"d":"-4.06 €"},"j",0,0,0,0,0,0,0,{"v":300708,"d":"300,708 "},{"$nulls":4},0,0]
[null,"dnb9","dnb3",{"v":172.8,"d":"172.80 "},{"v":590984,"d":"590,984 "},{"v":160000000,"d":"160,000,000.00 €"},0,{"v":-2477610.7,"d":"-2,477,610.70 €"},{"v":590984,"d":"590,984 "},{"v":-4.192348185399267,"d":"-4.19 €"},"j",0,0,0,0,0,0,0,0,{"v":590984,"d":"590,984 "},{"$nulls":3},0,0]
[null,"dnb10","dnb1",{"v":172.81,"d":"172.81 "},{"v":313620,"d":"313,620 "},{"v":65000000,"d":"65,000,000.00 €"},0,{"v":-1016245.99,"d":"-1,016,245.99 €"},{"v":313620,"d":"313,620 "},{"v":-3.240373668771124,"d":"-3.24 €"},"j",0,0,0,0,0,0,0,0,0,{"v":313620,"d":"313,620 "},null,null,0,0]
[null,"dnb11","dnb2",{"v":172.82,"d":"172.82 "},{"v":438104,"d":"438,104 "},{"v":160000000,"d":"160,000,000.00 €"},0,{"v":-2457701.42,"d":"-2,457,701.42 €"},{"v":438104,"d":"438,104 "},{"v":-5.609858435439986,"d":"-5.61 €"},"j",0,0,0,0,0,0,0,0,0,0,{"v":438104,"d":"438,104 "},null,0,0]
[]
[{"$nulls":6},0,{"$nulls":4},{"v":10000,"d":"10,000 "},{"v":133701,"d":"133,701 "},{"v":87612,"d":"87,612 "},{"v":419574,"d":"419,574 "},{"v":61010,"d":"61,010 "},{"v":516756,"d":"516,756 "},{"v":375443,"d":"375,443 "},{"v":300708,"d":"300,708 "},{"v":590984,"d":"590,984 "},{"v":313620,"d":"313,620 "},{"v":438104,"d":"438,104 "},0,0]
[{"$nulls":10},"beschikbaar gebied toegangspunten",{"v":10000,"d":"10,000 "},{"v":133701,"d":"133,701 "},{"v":87612,"d":"87,612 "},{"v":419574,"d":"419,574 "},{"v":61010,"d":"61,010 "},{"v":516756,"d":"516,756 "},{"v":375443,"d":"375,443 "},{"v":300708,"d":"300,708 "},{"v":590984,"d":"590,984 "},{"v":313620,"d":"313,620 "},{"v":438104,"d":"438,104 "},0]
[{"$nulls":10},"beschikbaar potentieel per tp",{"v":-1.197354,"d":"-1.20 €"},{"v":-3.9637675858819303,"d":"-3.96 €"},{"v":-4.725479728804273,"d":"-4.73 €"},{"v":-3.440947031989589,"d":"-3.44 €"},{"v":-4.680310113096214,"d":"-4.68 €"},{"v":-4.2767645658686115,"d":"-4.28 €"},{"v":-4.4647274020290695,"d":"-4.46 €"},{"v":-4.061840390012903,"d":"-4.06 €"},{"v":-4.192348185399267,"d":"-4.19 €"},{"v":-3.240373668771124,"d":"-3.24 €"},{"v":-5.609858435439986,"d":"-5.61 €"},0]
[{"$nulls":10},"volledige vulling van dit gebied",{"v":11973.54,"d":"11,973.54 €"},{"v":529959.69,"d":"529,959.69 €"},{"v":414008.73,"d":"414,008.73 €"},{"v":1443731.91,"d":"1,443,731.91 €"},{"v":285545.72,"d":"285,545.72 €"},{"v":2210043.75,"d":"2,210,043.75 €"},{"v":1676250.65,"d":"1,676,250.65 €"},{"v":1221427.9000000001,"d":"1,221,427.90 €"},{"v":2477610.7,"d":"2,477,610.70 €"},{"v":1016245.99,"d":"1,016,245.99 €"},{"v":2457701.42,"d":"2,457,701.42 €"},0]
[{"$nulls":10},"beschikbaar te vullen",0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},"effectieve vulling",0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},"overflow/tp",0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[]
[{"$nulls":10},"overflow","dnb1","dnb2","dnb3","dnb4","dnb5","dnb6","dnb7","dnb8","dnb9","dnb10","dnb11","dnb12"]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},"saldo:",0]

{"sheet":"O G","index":17,"n_rows":35,"n_cols":23,"rows_kept":35,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,null,"Macro:","hoog>laag",{"$nulls":5},"laag>hoog"]
[]
[null,null,"Distributienet-beheerder","finale score","Aantal actieve toegangspunten gas","Toegelaten niet-exogene kosten aardgas","Overflow","max bedrag","Aantal actieve toegangspunten gas","marge/tp","ontvanger?","dnb1","dnb2","dnb3","dnb4","dnb5","dnb6","dnb7","dnb8","dnb9","dnb10","overflow EUR","overflow EUR/tp"]
[null,"dnb1","dnb2",{"v":48.23,"d":"48.23 "},{"v":280222,"d":"280,222 "},{"v":70000000,"d":"70,000,000.00 €"},0,{"v":355637.57578706654,"d":"355,637.58 €"},{"v":280222,"d":"280,222 "},{"v":1.2691279620695968,"d":"1.27 €"},"j",{"v":280222,"d":"280,222 "},{"$nulls":9},0,0]
[null,"dnb2","dnb1",{"v":48.22,"d":"48.22 "},{"v":234075,"d":"234,075 "},{"v":35000000,"d":"35,000,000.00 €"},0,{"v":179747.9650280453,"d":"179,747.97 €"},{"v":234075,"d":"234,075 "},{"v":0.7679075724790998,"d":"0.77 €"},"j",0,{"v":234075,"d":"234,075 "},{"$nulls":8},0,0]
[null,"dnb3","dnb3",{"v":48.2,"d":"48.20 "},{"v":379939,"d":"379,939 "},{"v":85000000,"d":"85,000,000.00 €"},0,{"v":432832.58024630084,"d":"432,832.58 €"},{"v":379939,"d":"379,939 "},{"v":1.1392159800554849,"d":"1.14 €"},"j",0,0,{"v":379939,"d":"379,939 "},{"$nulls":7},0,0]
[null,"dnb4","dnb4",{"v":48.16,"d":"48.16 "},{"v":185007,"d":"185,007 "},{"v":40000000,"d":"40,000,000.00 €"},0,{"v":203936.61622963686,"d":"203,936.62 €"},{"v":185007,"d":"185,007 "},{"v":1.1023183783837198,"d":"1.10 €"},"j",0,0,0,{"v":185007,"d":"185,007 "},{"$nulls":6},0,0]
[null,"dnb5","dnb5",{"v":48.13,"d":"48.13 "},{"v":252083,"d":"252,083 "},{"v":55000000,"d":"55,000,000.00 €"},0,{"v":280489.1827778196,"d":"280,489.18 €"},{"v":252083,"d":"252,083 "},{"v":1.1126858327527822,"d":"1.11 €"},"j",0,0,0,0,{"v":252083,"d":"252,083 "},{"$nulls":5},0,0]
[null,"dnb6","dnb6",{"v":48.11,"d":"48.11 "},{"v":324583,"d":"324,583 "},{"v":80000000,"d":"80,000,000.00 €"},0,{"v":407175.4652269769,"d":"407,175.47 €"},{"v":324583,"d":"324,583 "},{"v":1.254457150334358,"d":"1.25 €"},"j",0,0,0,0,0,{"v":324583,"d":"324,583 "},{"$nulls":4},0,0]
[null,"dnb7","dnb7",{"v":48.1,"d":"48.10 "},{"v":43766,"d":"43,766 "},{"v":12000000,"d":"12,000,000.00 €"},0,{"v":60974.77881007896,"d":"60,974.78 €"},{"v":43766,"d":"43,766 "},{"v":1.3931997169053365,"d":"1.39 €"},"j",0,0,0,0,0,0,{"v":43766,"d":"43,766 "},{"$nulls":3},0,0]
[null,"dnb8","dnb10",{"v":55.79,"d":"55.79 "},{"v":51404,"d":"51,404 "},{"v":12000000,"d":"12,000,000.00 €"},0,{"v":54594.56467954635,"d":"54,594.56 €"},{"v":51404,"d":"51,404 "},{"v":1.0620684125660718,"d":"1.06 €"},"j",0,0,0,0,0,0,0,{"v":51404,"d":"51,404 "},null,null,0,0]
[null,"dnb9","dnb8",{"v":55.77,"d":"55.77 "},{"v":217312,"d":"217,312 "},{"v":45000000,"d":"45,000,000.00 €"},0,{"v":202220.39491025443,"d":"202,220.39 €"},{"v":217312,"d":"217,312 "},{"v":0.9305532824245989,"d":"0.93 €"},"j",0,0,0,0,0,0,0,0,{"v":217312,"d":"217,312 "},null,0,0]
[null,"dnb10","dnb9",{"v":55.74,"d":"55.74 "},{"v":72935,"d":"72,935 "},{"v":12000000,"d":"12,000,000.00 €"},0,{"v":52390.886304274165,"d":"52,390.89 €"},{"v":72935,"d":"72,935 "},{"v":0.7183229766816229,"d":"0.72 €"},"j",0,0,0,0,0,0,0,0,0,{"v":72935,"d":"72,935 "},0,0]
[{"$nulls":6},0,{"$nulls":4},{"v":280222,"d":"280,222 "},{"v":234075,"d":"234,075 "},{"v":379939,"d":"379,939 "},{"v":185007,"d":"185,007 "},{"v":252083,"d":"252,083 "},{"v":324583,"d":"324,583 "},{"v":43766,"d":"43,766 "},{"v":51404,"d":"51,404 "},{"v":217312,"d":"217,312 "},{"v":72935,"d":"72,935 "},0]
[{"$nulls":10},"beschikbaar gebied toegangspunten",{"v":280222,"d":"280,222 "},{"v":234075,"d":"234,075 "},{"v":379939,"d":"379,939 "},{"v":185007,"d":"185,007 "},{"v":252083,"d":"252,083 "},{"v":324583,"d":"324,583 "},{"v":43766,"d":"43,766 "},{"v":51404,"d":"51,404 "},{"v":217312,"d":"217,312 "},{"v":72935,"d":"72,935 "}]
[{"$nulls":10},"beschikbaar potentieel per tp",{"v":1.2691279620695968,"d":"1.27 €"},{"v":0.7679075724790998,"d":"0.77 €"},{"v":1.1392159800554849,"d":"1.14 €"},{"v":1.1023183783837198,"d":"1.10 €"},{"v":1.1126858327527822,"d":"1.11 €"},{"v":1.254457150334358,"d":"1.25 €"},{"v":1.3931997169053365,"d":"1.39 €"},{"v":1.0620684125660718,"d":"1.06 €"},{"v":0.9305532824245989,"d":"0.93 €"},{"v":0.7183229766816229,"d":"0.72 €"}]
[{"$nulls":10},"volledige vulling van dit gebied",{"v":355637.57578706654,"d":"355,637.58 €"},{"v":179747.9650280453,"d":"179,747.97 €"},{"v":432832.58024630084,"d":"432,832.58 €"},{"v":203936.61622963686,"d":"203,936.62 €"},{"v":280489.1827778196,"d":"280,489.18 €"},{"v":407175.4652269769,"d":"407,175.47 €"},{"v":60974.778810078955,"d":"60,974.78 €"},{"v":54594.564679546354,"d":"54,594.56 €"},{"v":202220.39491025443,"d":"202,220.39 €"},{"v":52390.886304274165,"d":"52,390.89 €"}]
[{"$nulls":10},"beschikbaar te vullen",0,0,0,0,0,0,0,0,0,0,"nvt"]
[{"$nulls":10},"effectieve vulling",0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},"overflow/tp",0,0,0,0,0,0,0,0,0,0]
[]
[{"$nulls":10},"overflow","dnb1","dnb2","dnb3","dnb4","dnb5","dnb6","dnb7","dnb8","dnb9","dnb10"]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},"saldo:",0]

{"sheet":"O E","index":18,"n_rows":39,"n_cols":25,"rows_kept":39,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,null,"Macro:","hoog>laag",{"$nulls":5},"laag>hoog"]
[{"$nulls":11},"gebied aan samen op te vullen toegangspunten"]
[null,null,"Distributienet-beheerder","finale score","Aantal actieve toegangspunten elektriciteit","Toegelaten niet-exogene kosten elektriciteit","Overflow","max bedrag","Aantal actieve toegangspunten elektriciteit","marge/tp","ontvanger?","dnb1","dnb2","dnb3","dnb4","dnb5","dnb6","dnb7","dnb8","dnb9","dnb10","dnb11","dnb12","overflow EUR","overflow EUR/tp"]
[null,"dnb1","dnb2",{"v":172.82,"d":"172.82 "},{"v":438104,"d":"438,104 "},{"v":160000000,"d":"160,000,000.00 €"},0,{"v":2342298.58,"d":"2,342,298.58 €"},{"v":438104,"d":"438,104 "},{"v":5.346444177638187,"d":"5.35 €"},"j",{"v":438104,"d":"438,104 "},{"$nulls":11},0,0]
[null,"dnb2","dnb1",{"v":172.81,"d":"172.81 "},{"v":313620,"d":"313,620 "},{"v":65000000,"d":"65,000,000.00 €"},0,{"v":933754.01,"d":"933,754.01 €"},{"v":313620,"d":"313,620 "},{"v":2.977342038135323,"d":"2.98 €"},"j",0,{"v":313620,"d":"313,620 "},{"$nulls":10},0,0]
[null,"dnb3","dnb3",{"v":172.8,"d":"172.80 "},{"v":590984,"d":"590,984 "},{"v":160000000,"d":"160,000,000.00 €"},0,{"v":2322389.3000000003,"d":"2,322,389.30 €"},{"v":590984,"d":"590,984 "},{"v":3.929699111989496,"d":"3.93 €"},"j",0,0,{"v":590984,"d":"590,984 "},{"$nulls":9},0,0]
[null,"dnb4","dnb4",{"v":169.66,"d":"169.66 "},{"v":300708,"d":"300,708 "},{"v":80000000,"d":"80,000,000.00 €"},0,{"v":1178572.1,"d":"1,178,572.10 €"},{"v":300708,"d":"300,708 "},{"v":3.9193240618806287,"d":"3.92 €"},"j",0,0,0,{"v":300708,"d":"300,708 "},{"$nulls":8},0,0]
[null,"dnb5","dnb5",{"v":169.59,"d":"169.59 "},{"v":375443,"d":"375,443 "},{"v":110000000,"d":"110,000,000.00 €"},0,{"v":1623749.35,"d":"1,623,749.35 €"},{"v":375443,"d":"375,443 "},{"v":4.324889130973277,"d":"4.32 €"},"j",0,0,0,0,{"v":375443,"d":"375,443 "},{"$nulls":7},0,0]
[null,"dnb6","dnb6",{"v":169.48,"d":"169.48 "},{"v":516756,"d":"516,756 "},{"v":145000000,"d":"145,000,000.00 €"},0,{"v":2139956.25,"d":"2,139,956.25 €"},{"v":516756,"d":"516,756 "},{"v":4.141134790887769,"d":"4.14 €"},"j",0,0,0,0,0,{"v":516756,"d":"516,756 "},{"$nulls":6},0,0]
[null,"dnb7","dnb7",{"v":153.55,"d":"153.55 "},{"v":61010,"d":"61,010 "},{"v":20000000,"d":"20,000,000.00 €"},0,{"v":314454.27999999997,"d":"314,454.28 €"},{"v":61010,"d":"61,010 "},{"v":5.1541432552040645,"d":"5.15 €"},"j",0,0,0,0,0,0,{"v":61010,"d":"61,010 "},{"$nulls":5},0,0]
[null,"dnb8","dnb8",{"v":149.58,"d":"149.58 "},{"v":419574,"d":"419,574 "},{"v":105000000,"d":"105,000,000.00 €"},0,{"v":1706268.09,"d":"1,706,268.09 €"},{"v":419574,"d":"419,574 "},{"v":4.066667834517868,"d":"4.07 €"},"j",0,0,0,0,0,0,0,{"v":419574,"d":"419,574 "},{"$nulls":4},0,0]
[null,"dnb9","dnb9",{"v":144.46,"d":"144.46 "},{"v":87612,"d":"87,612 "},{"v":30000000,"d":"30,000,000.00 €"},0,{"v":485991.26999999996,"d":"485,991.27 €"},{"v":87612,"d":"87,612 "},{"v":5.547085673195452,"d":"5.55 €"},"j",0,0,0,0,0,0,0,0,{"v":87612,"d":"87,612 "},{"$nulls":3},0,0]
[null,"dnb10","dnb10",{"v":138.55,"d":"138.55 "},{"v":133701,"d":"133,701 "},{"v":40000000,"d":"40,000,000.00 €"},0,{"v":670040.3099999999,"d":"670,040.31 €"},{"v":133701,"d":"133,701 "},{"v":5.011483160185787,"d":"5.01 €"},"j",0,0,0,0,0,0,0,0,0,{"v":133701,"d":"133,701 "},null,null,0,0]
[null,"dnb11","dnb11",{"v":126.59,"d":"126.59 "},{"v":10000,"d":"10,000 "},{"v":1300000,"d":"1,300,000.00 €"},0,{"v":27026.460000000003,"d":"27,026.46 €"},{"v":10000,"d":"10,000 "},{"v":2.702646,"d":"2.70 €"},"j",0,0,0,0,0,0,0,0,0,0,{"v":10000,"d":"10,000 "},null,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":6},0,{"$nulls":4},{"v":438104,"d":"438,104 "},{"v":313620,"d":"313,620 "},{"v":590984,"d":"590,984 "},{"v":300708,"d":"300,708 "},{"v":375443,"d":"375,443 "},{"v":516756,"d":"516,756 "},{"v":61010,"d":"61,010 "},{"v":419574,"d":"419,574 "},{"v":87612,"d":"87,612 "},{"v":133701,"d":"133,701 "},{"v":10000,"d":"10,000 "},0,0]
[{"$nulls":10},"beschikbaar gebied toegangspunten",{"v":438104,"d":"438,104 "},{"v":313620,"d":"313,620 "},{"v":590984,"d":"590,984 "},{"v":300708,"d":"300,708 "},{"v":375443,"d":"375,443 "},{"v":516756,"d":"516,756 "},{"v":61010,"d":"61,010 "},{"v":419574,"d":"419,574 "},{"v":87612,"d":"87,612 "},{"v":133701,"d":"133,701 "},{"v":10000,"d":"10,000 "},0]
[{"$nulls":10},"beschikbaar potentieel per tp",{"v":5.346444177638187,"d":"5.35 €"},{"v":2.977342038135323,"d":"2.98 €"},{"v":3.929699111989496,"d":"3.93 €"},{"v":3.9193240618806287,"d":"3.92 €"},{"v":4.324889130973277,"d":"4.32 €"},{"v":4.141134790887769,"d":"4.14 €"},{"v":5.1541432552040645,"d":"5.15 €"},{"v":4.066667834517868,"d":"4.07 €"},{"v":5.547085673195452,"d":"5.55 €"},{"v":5.011483160185787,"d":"5.01 €"},{"v":2.702646,"d":"2.70 €"},0]
[{"$nulls":10},"volledige vulling van dit gebied",{"v":2342298.58,"d":"2,342,298.58 €"},{"v":933754.01,"d":"933,754.01 €"},{"v":2322389.3000000003,"d":"2,322,389.30 €"},{"v":1178572.1,"d":"1,178,572.10 €"},{"v":1623749.35,"d":"1,623,749.35 €"},{"v":2139956.25,"d":"2,139,956.25 €"},{"v":314454.27999999997,"d":"314,454.28 €"},{"v":1706268.0899999999,"d":"1,706,268.09 €"},{"v":485991.26999999996,"d":"485,991.27 €"},{"v":670040.3099999999,"d":"670,040.31 €"},{"v":27026.460000000003,"d":"27,026.46 €"},0]
[{"$nulls":10},"beschikbaar te vullen",0,0,0,0,0,0,0,0,0,0,0,0,"nvt"]
[{"$nulls":10},"effectieve vulling",0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},"overflow/tp",0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[]
[{"$nulls":10},"overflow","dnb1","dnb2","dnb3","dnb4","dnb5","dnb6","dnb7","dnb8","dnb9","dnb10","dnb11","dnb12"]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":10},0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":9},"saldo:",0]