{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Toel. wijz. NE6R (aug. 2016)","Toel. herstel NE6R (sep. 2014)","Toelichting","Data","Verrekening onder-boven","q-factoren","Parameters"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":36,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Toel. wijz. NE6R (aug. 2016)","index":0,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[[5,1,6,3]]}
[]
[null,"Toelichting bij berekening gewijzigde x-factoren, q-factoren en rekenvolumina NE6R d.d. 25 augustus 2016"]
[]
[null,"Toelichting bij dit bestand"]
[]
[null,"Dit bestand bevat het rekenmodel waarmee ACM de q-factoren berekent. Deze q-factoren heeft ACM vastgesteld in de volgende besluiten."]
[]
[]
[null,"Toelichting op de wijziging: op het blad 'q-factoren' zijn de Begininkomsten en x-factoren opnieuw ingevoerd (op basis van gewijzigd berekening augustus 2016)"]
[]
[null,"Wijziging besluiten 2014-2016 Elektriciteit (NE6R) d.d. 25 augustus 2016","Zaaknummer","Kenmerk"]
[null,"Cogas Infra & Beheer B.V. ","16.0786.52","ACM/DE/2016/204809"]
[null,"DELTA Netwerkbedrijf B.V. ","16.0788.52","ACM/DE/2016/204811"]
[null,"Enexis B.V. ","16.0791.52","ACM/DE/2016/204813"]
[null,"Liander N.V. ","16.0793.52","ACM/DE/2016/204815"]
[null,"Endinet B.V. ","16.0795.52","ACM/DE/2016/204817"]
[null,"RENDO Netbeheer B.V. ","16.0797.52","ACM/DE/2016/204819"]
[null,"Stedin Netbeheer B.V. ","16.0800.52","ACM/DE/2016/204821"]
[null,"Westland Infra Netbeheer B.V. ","16.0802.52","ACM/DE/2016/204823"]
[]
[null,"Legenda celkleuren"]
[]
[null,"Data en input"]
[]
[null,"Berekende waarde"]
[]
[null,"Waarde die zonder berekening wordt overgenomen uit een andere cel"]
[]
[null,"Berekende of overgenomen waarde en tevens resultaat"]
[]
[null,"Waarde of berekening die speciale aandacht vraagt (toelichting in opmerking)"]
[]
[null,"Waarde of berekening die (vooralsnog) kennelijk onjuist of onvolledig is"]

{"sheet":"Toel. herstel NE6R (sep. 2014)","index":1,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[5,1,6,3]]}
[]
[null,"Toelichting bij berekening gewijzigde x-factoren, q-factoren en rekenvolumina NE6R d.d. 11 september 2014"]
[]
[null,"Toelichting bij dit bestand"]
[]
[null,"Dit bestand bevat het rekenmodel waarmee ACM de q-factoren berekent. Deze q-factoren heeft ACM vastgesteld in de volgende besluiten."]
[]
[]
[null,"Herstel besluiten 2014-2016 Elektriciteit (NE6R) d.d. 11 september 2014","Zaaknummer","Kenmerk"]
[null,"Cogas Infra & Beheer B.V. ","14.0730.52","ACM/DE/2014/205161"]
[null,"DELTA Netwerkbedrijf B.V. ","14.0732.52","ACM/DE/2014/205163"]
[null,"Enexis B.V. ","14.0734.52","ACM/DE/2014/205165"]
[null,"Liander N.V. ","14.0736.52","ACM/DE/2014/205167"]
[null,"Endinet B.V. ","14.0738.52","ACM/DE/2014/205169"]
[null,"RENDO Netbeheer B.V. ","14.0740.52","ACM/DE/2014/205171"]
[null,"Stedin Netbeheer B.V. ","14.0742.52","ACM/DE/2014/205173"]
[null,"Westland Infra Netbeheer B.V. ","14.0744.52","ACM/DE/2014/205175"]
[]
[null,"Legenda celkleuren"]
[]
[null,"Data en input"]
[]
[null,"Berekende waarde"]
[]
[null,"Waarde die zonder berekening wordt overgenomen uit een andere cel"]
[]
[null,"Berekende of overgenomen waarde en tevens resultaat"]
[]
[null,"Waarde of berekening die speciale aandacht vraagt (toelichting in opmerking)"]
[]
[null,"Waarde of berekening die (vooralsnog) kennelijk onjuist of onvolledig is"]

{"sheet":"Toelichting","index":2,"n_rows":74,"n_cols":4,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Toelichting "]
[]
[]
[null,"Toelichting "]
[]
[null,"Dit Excel-bestand bevat het model waarmee de q-factoren voor regionale netbeheerders elektriciteit worden berekend, "]
[null,"zoals dat is beschreven in het methodebesluit regionale netbeheerders elektriciteit zesde reguleringsperiode: besluit van 26 september 2013 met kenmerk 103999/536."]
[null,"De q factoren zijn voor de verschillende netbeheerders vastgesteld in de x-factorbesluiten zoals onderaan deze pagina in een overzicht is weergegeven."]
[]
[null,"Legenda celkleuren"]
[]
[null,"Brondata"]
[]
[null,"Berekende waarde"]
[]
[null,"Waarde die zonder berekening wordt opgehaald uit een andere cel"]
[]
[null,"Berekende waarde en tevens resultaat"]
[]
[null,"Opbouw Excel-sheet"]
[]
[null,"Sheet: Data"]
[null,"Deze sheet bevat de data die als input gebruikt worden voor de berekeningen (kwaliteitsdata per netbeheerder). "]
[null,"De data betreft cijfers voor de transportzekerheid van de regionale netbeheerders voor wat betreft hun LS-afnemers."]
[null,"De afkorting TA betreft het totale aantal afnemers, zowel de eigen afnemers alsook de afnemers bij een eventuele onderliggende netbeheerder."]
[]
[null,"Sheet: Verrekening onder-boven"]
[null,"Deze sheet bevat de door de netbeheerders aangeleverde data met betrekking tot de aantallen LS-afnemers bij onder- en bovenliggende netbeheerders."]
[null,"Waar voor het jaar 2010 de data nog niet volledig consistent was, heeft ACM ervoor gekozen om de data van de onderliggende"]
[null,"netbeheerder te hanteren."]
[]
[null,"OPMERKING: De controle regel op het zero-sum effect geeft niet altijd precies 0 aan, omdat er voor enkele netbeheerders een inconsistentie bestaat"]
[null,"tussen het opgegeven totaal aantal afnemers op het MS- en LS-netvlak en de opgegeven aantallen onder- en bovenliggende LS-afnemers."]
[]
[null,"Sheet: q-factoren"]
[null,"Deze sheet bevat de berekening van de concept q-factoren inclusief een correctie van de SAIFI voor onder- en bovenliggende netbeheerders."]
[]
[null,"De Begininkomsten en de x-factoren zijn nodig om de q-factoren te berekenen. "]
[null,"Voor de defintieve berekening van de q-factoren zijn de vastgestelde x-factoren en de BeginInkomsten 2013 gebruikt."]
[]
[null,"Voor het berekenen van de waardering is gebruik gemaakt van een speciaal hiervoor geconstrueerde Excel-functie. "]
[null,"Deze functie (\"SEO\") heeft als input parameters:"]
[null,"- of de waardering voor Huishoudens (\"H\") of voor MKB (\"B\") berekend moet worden"]
[null,"- de SAIFI"]
[null,"- de CAIDI"]
[null,"De uitkomst van de functie is in prijspeil 2008."]
[]
[null,"Om de concept-q-factoren te berekenen wordt gebruikt gemaakt van de knop 'Doelzoeken'. "]
[null,"Achter deze knop zit een macro die:"]
[null,"-de regel met de naam 'doelzoekregel' voor alle netbeheerders gelijkstelt aan nul"]
[null,"- door de volgende regel (de concept q-factor) voor deze netbeheerder de juiste waarde te geven"]
[]
[null,"Sheet: Parameters"]
[null,"Deze sheet bevat de parameters die als input gebruikt worden voor de berekeningen, o.a.:"]
[null,"- parameters van de SEO-waarderingsfunctie"]
[null,"- relevante CPI's"]
[null,"- verhouding huishoudens / MKB-ers"]
[null,"- gewichten van boven- en onderliggende netbeheerders"]
[]
[null,"Overzicht X-factorbesluiten behorende bij methodebesluit regionale netbeheerders elektriciteit zesde reguleringsperiode: besluit van 26 september 2013 met kenmerk 103999/536"]
[]
[null,"X-factorbesluiten Elektriciteit","Zaaknummer","Kenmerk"]
[null,"Cogas Infra & Beheer B.V.","13.0789.52","ACM/DE/2013/204370"]
[null,"DELTA Netwerkbedrijf B.V.","13.0791.52","ACM/DE/2013/204372"]
[null,"Endinet B.V.","13.0797.52","ACM/DE/2013/204377"]
[null,"Enexis B.V.","13.0793.52","ACM/DE/2013/204374"]
[null,"Liander N.V.","13.0795.52","ACM/DE/2013/204368"]
[null,"N.V. RENDO","13.0799.52","ACM/DE/2013/204379"]
[null,"Stedin Netbeheer B.V.","13.0801.52","ACM/DE/2013/204383"]
[null,"Westland Infra Netbeheer B.V.","13.0803.52","ACM/DE/2013/204385"]

{"sheet":"Data","index":3,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Data"]
[]
[]
[]
[]
[null,"Data transportzekerheid per netbeheerder - LS-afnemers"]
[]
[null,"Bron: ingevulde CODATA NE-KDT (2010 en 2011) dataverzoeken en ingevulde CODATA NE-KWA (2012) dataverzoeken"]
[]
[null,2010,null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[null,"MS-netvlak","TA",52763,203281,105360,2826483,2742765,31637,2053470,67277]
[null,null,"ΣGA",3149,64879,21902,467242,754527,5744,299120,43920]
[null,null,"Σ(GAxT)",188345,4227347,902813,42935474,61705512,379128,35840202,1952696]
[null,null,"SAIFI MS",{"$f":"D15/D14","v":5.968197411064572E-2},{"$f":"E15/E14","v":0.31915919343175209},0.20787775246772969,0.16530861851990619,0.27509721029690842,0.18155956633056231,0.14566562939804331,0.65282340175691544]
[null,"LS-netvlak","TA",52699,203281,105324,2597100,2694813,31637,2053470,53190]
[null,null,"ΣGA",1466,14387,3361,91984,135651,936,69542,891]
[null,null,"Σ(GAxT)",126451,1120864,354385,15991339,21096440,133873,10488487,94947]
[null,null,"SAIFI LS",{"$f":"D19/D18","v":2.7818364674851517E-2},{"$f":"E19/E18","v":7.0773953296176223E-2},3.1911055409973035E-2,3.5417966193061493E-2,5.0337815648061668E-2,2.9585611783671018E-2,3.3865603101092295E-2,1.6751269035532996E-2]
[null,"Totaal","CAIDI",{"$f":"(D16+D20)/(D15+D19)","v":68.211484290357532},{"$f":"(E16+E20)/(E15+E19)","v":67.47169025811823},49.764398527490798,105.37209106872713,93.017297664062696,76.796556886227549,125.66711242276124,45.695097185958808]
[null,null,"SAIFI",{"$f":"D17+D21","v":8.7500338785497234E-2},{"$f":"E17+E21","v":0.38993314672792834},0.23978880787770274,0.20072658471296767,0.32543502594497009,0.21114517811423333,0.17953123249913561,0.66957467079244848]
[null,null,"TA",{"$f":"D18","v":52699},{"$f":"E18","v":203281},105324,2597100,2694813,31637,2053470,53190]
[]
[null,2011,null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[null,"MS-netvlak","TA",52630,208256,106066,2847159,2771415,31867,2066075,69764]
[null,null,"ΣGA",4426,36714,45813,527389,565290,1480,302884,17172]
[null,null,"Σ(GAxT)",196254,1841742,3450133,33746458,35962744,124687,36640859,822358]
[null,null,"SAIFI MS",{"$f":"D28/D27","v":8.4096522895686865E-2},{"$f":"E28/E27","v":0.17629263982790411},0.43192917617332605,0.18523342040258378,0.20397161738678618,4.6443028838610477E-2,0.14659874399525671,0.24614414311106014]
[null,"LS-netvlak","TA",52566,208256,106030,2616840,2771415,31867,2050254,53943]
[null,null,"ΣGA",1236,16099,2982,93155,129516,1147,63574,2787]
[null,null,"Σ(GAxT)",91359,1272912,292549,15459555,18522434,120136,6329372,207711]
[null,null,"SAIFI LS",{"$f":"D32/D31","v":2.3513297568770689E-2},{"$f":"E32/E31","v":7.7303895205900433E-2},2.8124115816278411E-2,3.5598278840127791E-2,4.6732806165803387E-2,3.599334734992312E-2,3.100786536692527E-2,5.1665647071909238E-2]
[null,"Totaal","CAIDI",{"$f":"(D29+D33)/(D28+D32)","v":50.79706817379018},{"$f":"(E29+E33)/(E28+E32)","v":58.975138696911742},76.70216210677323,79.294962162231855,78.417828861581512,93.194899124476592,117.25826970621463,51.609248960368753]
[null,null,"SAIFI",{"$f":"D30+D34","v":0.10760982046445755},{"$f":"E30+E34","v":0.25359653503380453},0.46005329198960443,0.22083169924271157,0.25070442355258959,8.2436376188533597E-2,0.17760660936218198,0.29780979018296938]
[null,null,"TA",{"$f":"D31","v":52566},{"$f":"E31","v":208256},106030,2616840,2771415,31867,2050254,53943]
[]
[null,2012,null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[null,"MS-netvlak","TA",52816,209102,107729,2867380,2947297,32125,2066813,70588]
[null,null,"ΣGA",10268,43609,8591,543631,700728,3773,403959,5989]
[null,null,"Σ(GAxT)",496174,2446626,676873,43466364,45707777,195256,56766608,290242]
[null,null,"SAIFI MS",{"$f":"D41/D40","v":0.19441078461072403},0.20855372019397231,7.9746400690621833E-2,0.18959154349964077,0.23775276125887551,0.11744747081712062,0.19545019312342238,8.4844449481498274E-2]
[null,"LS-netvlak","TA",52752,209102,107693,2635273,2898074,32125,2049207,54767]
[null,null,"ΣGA",1979,18624,2675,93708,149684,884,74158,2389]
[null,null,"Σ(GAxT)",185898,1602533,253714,16700424,23779668,105128,12100855,220590]
[null,null,"SAIFI LS",{"$f":"D45/D44","v":3.7515165301789506E-2},{"$f":"E45/E44","v":8.9066579946628921E-2},2.4839126034189779E-2,3.5559124234946435E-2,5.1649474789118563E-2,2.7517509727626458E-2,3.6188632968753277E-2,4.3621158726970623E-2]
[null,"Totaal","CAIDI",{"$f":"(D42+D46)/(D41+D45)","v":55.692986037396913},65.064499542043606,82.601366944789632,94.403116708690348,81.710329816606546,64.501610478849045,144.03893398477777,60.97302458820721]
[null,null,"SAIFI",{"$f":"D43+D47","v":0.23192594991251353},{"$f":"E43+E47","v":0.29762030014060126},0.10458552672481161,0.2251506677345872,0.28940223604799409,0.14496498054474707,0.23163882609217565,0.12846560820846889]
[null,null,"TA",{"$f":"D44","v":52752},209102,107693,2635273,2898074,32125,2049207,54767]

{"sheet":"Verrekening onder-boven","index":4,"n_rows":130,"n_cols":11,"rows_kept":130,"cut":false,"hidden":false,"merged":[[14,3,14,10],[16,1,23,1],[26,3,26,10],[28,1,35,1],[108,3,108,10],[110,1,117,1],[55,3,55,10],[57,1,64,1],[67,3,67,10],[69,1,76,1],[96,3,96,10],[98,1,105,1]]}
[]
[]
[null,"Verrekening aantallen onder- en"]
[null,"bovenliggende netbeheerders"]
[]
[]
[]
[]
[]
[null,"Verrekening 2010"]
[]
[null,"SectorSAIFI (MS)",{"$f":"SUM(Data!D15:K15)/SUM(Data!D18:K18)","v":0.21311429331962953}]
[]
[null,"Data aantallen onderliggende LS-afnemers"]
[null,null,null,"Bovenliggende netbeheerder"]
[null,null,null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[null,"Onderliggende netbeheerder","COGAS",null,null,null,52699]
[null,null,"DNWB"]
[null,null,"ENDINET",null,null,null,105324]
[null,null,"ENEXIS",64,null,36,null,22852]
[null,null,"LIANDER",null,null,null,18030]
[null,null,"RENDO",null,null,null,31637]
[null,null,"STEDIN",null,null,null,21876,24421,null,null,15825]
[null,null,"WESTLAND",null,null,null,null,null,null,1788]
[]
[null,"Berekening onderliggende GA o.b.v. SectorSAIFI (MS)"]
[null,null,null,"Bovenliggende netbeheerder"]
[null,null,null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[null,"Onderliggende netbeheerder","COGAS",null,{"$f":"E17*$C$12","v":0},0,11230.910143651157,0,0,0,0]
[null,null,"DNWB",{"$f":"D18*$C$12","v":0},null,0,0,0,0,0,0]
[null,null,"ENDINET",0,0,null,22446.049829596661,0,0,0,0]
[null,null,"ENEXIS",{"$f":"D20*$C$12","v":13.63931477245629},0,7.6721145595066629,null,4870.0878309401742,0,0,0]
[null,null,"LIANDER",0,0,0,3842.4507085529203,null,0,0,0]
[null,null,"RENDO",0,0,0,6742.2968977531191,0,null,0,0]
[null,null,"STEDIN",0,0,0,4662.0882806602158,5204.4641571586726,0,null,3372.5336917831373]
[null,null,"WESTLAND",0,0,0,0,0,0,381.04835645549758]
[]
[]
[null,"Berekening gecorrigeerde SAIFI",null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[]
[null,"Correctie ΣGA(MS)",null,{"$f":"AandeelOnder*SUM(D29:D36)+AandeelBoven*SUM(D29:K29)","v":574.50285621639136},{"$f":"AandeelOnder*SUM(E29:E36)+AandeelBoven*SUM(D30:K30)","v":0},{"$f":"AandeelOnder*SUM(F29:F36)+AandeelBoven*SUM(D31:K31)","v":1129.5910003113645},{"$f":"AandeelOnder*SUM(G29:G36)+AandeelBoven*SUM(D32:K32)","v":46722.176030216971},{"$f":"AandeelOnder*SUM(H29:H36)+AandeelBoven*SUM(D33:K33)","v":9762.9469241215502},{"$f":"AandeelOnder*SUM(I29:I36)+AandeelBoven*SUM(D34:K34)","v":337.11484488765598},{"$f":"AandeelOnder*SUM(J29:J36)+AandeelBoven*SUM(D35:K35)","v":1023.9502451128242},{"$f":"AandeelOnder*SUM(K29:K36)+AandeelBoven*SUM(D36:K36)","v":3222.9594250167552}]
[null,"Gecorrigeerde ΣGA(MS)",null,{"$f":"Data!D15+D41","v":3723.5028562163916},{"$f":"Data!E15+E41","v":64879},{"$f":"Data!F15+F41","v":23031.591000311364},{"$f":"Data!G15+G41","v":513964.17603021697},{"$f":"Data!H15+H41","v":764289.94692412158},{"$f":"Data!I15+I41","v":6081.1148448876556},{"$f":"Data!J15+J41","v":300143.95024511282},{"$f":"Data!K15+K41","v":47142.959425016757}]
[null,"Gecorrigeerde SAIFI (MS)",null,{"$f":"D42/Data!D14","v":7.0570340128809805E-2},{"$f":"E42/Data!E14","v":0.31915919343175209},{"$f":"F42/Data!F14","v":0.21859900341981173},{"$f":"G42/Data!G14","v":0.18183876429832302},{"$f":"H42/Data!H14","v":0.27865673760753168},{"$f":"I42/Data!I14","v":0.19221528099654378},{"$f":"J42/Data!J14","v":0.14616427327650894},{"$f":"K42/Data!K14","v":0.70072921540818944}]
[]
[null,"Gecorrigeerde SAIFI totaal",null,{"$f":"D43+Data!D21","v":9.8388704803661325E-2},{"$f":"E43+Data!E21","v":0.38993314672792834},{"$f":"F43+Data!F21","v":0.25051005882978478},{"$f":"G43+Data!G21","v":0.2172567304913845},{"$f":"H43+Data!H21","v":0.32899455325559335},{"$f":"I43+Data!I21","v":0.22180089278021481},{"$f":"J43+Data!J21","v":0.18002987637760123},{"$f":"K43+Data!K21","v":0.71748048444372248}]
[]
[null,"Oorspronkelijke SAIFI totaal",null,{"$f":"Data!D23","v":8.7500338785497234E-2},{"$f":"Data!E23","v":0.38993314672792834},{"$f":"Data!F23","v":0.23978880787770274},{"$f":"Data!G23","v":0.20072658471296767},{"$f":"Data!H23","v":0.32543502594497009},{"$f":"Data!I23","v":0.21114517811423333},{"$f":"Data!J23","v":0.17953123249913561},{"$f":"Data!K23","v":0.66957467079244848}]
[null,"Check op zero-sum effect",{"$f":"C12-SUM(D42:K42)/SUM(Data!D14:K14)","v":-7.988784273121885E-5}]
[]
[]
[null,"Verrekening 2011"]
[]
[null,"SectorSAIFI (MS)",{"$f":"SUM(Data!D28:K28)/SUM(Data!D31:K31)","v":0.19023387023294769}]
[]
[null,"Data aantallen onderliggende LS-afnemers"]
[null,null,null,"Bovenliggende netbeheerder"]
[null,null,null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[null,"Onderliggende netbeheerder","COGAS",null,null,null,52566]
[null,null,"DNWB"]
[null,null,"ENDINET",null,null,null,106030]
[null,null,"ENEXIS",64,null,36,null,23743]
[null,null,"LIANDER",null,null,null,17862]
[null,null,"RENDO",null,null,null,31867]
[null,null,"STEDIN",null,null,null,21893,24383,null,null,15821]
[null,null,"WESTLAND",null,null,null,null,null,null,1785]
[]
[null,"Berekening onderliggende GA o.b.v. SectorSAIFI (MS)"]
[null,null,null,"Bovenliggende netbeheerder"]
[null,null,null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[null,"Onderliggende netbeheerder","COGAS",null,{"$f":"E58*$C$53","v":0},0,9999.8336226651281,0,0,0,0]
[null,null,"DNWB",{"$f":"D59*$C$53","v":0},null,{"$f":"F59*$C$53","v":0},0,0,0,0,0]
[null,null,"ENDINET",0,{"$f":"E60*$C$53","v":0},null,{"$f":"G60*$C$53","v":20170.497260799442},{"$f":"H60*$C$53","v":0},{"$f":"I60*$C$53","v":0},{"$f":"J60*$C$53","v":0},{"$f":"K60*$C$53","v":0}]
[null,null,"ENEXIS",12.174967694908652,{"$f":"E61*$C$53","v":0},6.8484193283861163,null,{"$f":"H61*$C$53","v":4516.7227809408769},{"$f":"I61*$C$53","v":0},{"$f":"J61*$C$53","v":0},{"$f":"K61*$C$53","v":0}]
[null,null,"LIANDER",0,0,0,3397.9573901009117,null,{"$f":"I62*$C$53","v":0},{"$f":"J62*$C$53","v":0},{"$f":"K62*$C$53","v":0}]
[null,null,"RENDO",0,0,0,6062.1827427133439,0,null,{"$f":"J63*$C$53","v":0},{"$f":"K63*$C$53","v":0}]
[null,null,"STEDIN",0,0,0,4164.7901210099235,4638.4724578899632,0,null,{"$f":"K64*$C$53","v":3009.6900609554655}]
[null,null,"WESTLAND",0,0,0,0,0,0,{"$f":"J65*$C$53","v":339.5674583658116}]
[]
[]
[null,"Berekening gecorrigeerde SAIFI",null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[]
[null,"Correctie ΣGA(MS)",null,{"$f":"AandeelOnder*SUM(D70:D77)+AandeelBoven*SUM(D70:K70)","v":511.55790044341961},{"$f":"AandeelOnder*SUM(E70:E77)+AandeelBoven*SUM(D71:K71)","v":0},{"$f":"AandeelOnder*SUM(F70:F77)+AandeelBoven*SUM(D72:K72)","v":1015.030861401939},{"$f":"AandeelOnder*SUM(G70:G77)+AandeelBoven*SUM(D73:K73)","v":41832.285388822529},{"$f":"AandeelOnder*SUM(H70:H77)+AandeelBoven*SUM(D74:K74)","v":8867.3333463943436},{"$f":"AandeelOnder*SUM(I70:I77)+AandeelBoven*SUM(D75:K75)","v":303.1091371356672},{"$f":"AandeelOnder*SUM(J70:J77)+AandeelBoven*SUM(D76:K76)","v":913.23671744028866},{"$f":"AandeelOnder*SUM(K70:K77)+AandeelBoven*SUM(D77:K77)","v":2876.1839308259823}]
[null,"Gecorrigeerde ΣGA(MS)",null,{"$f":"Data!D28+D82","v":4937.5579004434194},{"$f":"Data!E28+E82","v":36714},{"$f":"Data!F28+F82","v":46828.030861401938},{"$f":"Data!G28+G82","v":569221.28538882255},{"$f":"Data!H28+H82","v":574157.33334639436},{"$f":"Data!I28+I82","v":1783.1091371356672},{"$f":"Data!J28+J82","v":303797.2367174403},{"$f":"Data!K28+K82","v":20048.18393082598}]
[null,"Gecorrigeerde SAIFI (MS)",null,{"$f":"D83/Data!D27","v":9.3816414600862999E-2},{"$f":"E83/Data!E27","v":0.17629263982790411},{"$f":"F83/Data!F27","v":0.44149898045935493},{"$f":"G83/Data!G27","v":0.19992606151915737},{"$f":"H83/Data!H27","v":0.20717118632409595},{"$f":"I83/Data!I27","v":5.5954722350257856E-2},{"$f":"J83/Data!J27","v":0.1470407592741988},{"$f":"K83/Data!K27","v":0.28737148000151913}]
[]
[null,"Gecorrigeerde SAIFI totaal",null,{"$f":"D84+Data!D34","v":0.11732971216963368},{"$f":"E84+Data!E34","v":0.25359653503380453},{"$f":"F84+Data!F34","v":0.46962309627563337},{"$f":"G84+Data!G34","v":0.23552434035928516},{"$f":"H84+Data!H34","v":0.25390399248989937},{"$f":"I84+Data!I34","v":9.1948069700180976E-2},{"$f":"J84+Data!J34","v":0.17804862464112406},{"$f":"K84+Data!K34","v":0.33903712707342837}]
[]
[null,"Oorspronkelijke SAIFI totaal",null,{"$f":"Data!D36","v":0.10760982046445755},{"$f":"Data!E36","v":0.25359653503380453},{"$f":"Data!F36","v":0.46005329198960443},{"$f":"Data!G36","v":0.22083169924271157},{"$f":"Data!H36","v":0.25070442355258959},{"$f":"Data!I36","v":8.2436376188533597E-2},{"$f":"Data!J36","v":0.17760660936218198},{"$f":"Data!K36","v":0.29780979018296938}]
[null,"Check op zero-sum effect",{"$f":"C53-SUM(D83:K83)/SUM(Data!D27:K27)","v":-7.9304244198463714E-4}]
[]
[]
[null,"Verrekening 2012"]
[]
[null,"SectorSAIFI (MS)",{"$f":"SUM(Data!D41:K41)/SUM(Data!D44:K44)","v":0.21402531386704779}]
[]
[null,"Data aantallen onderliggende LS-afnemers"]
[null,null,null,"Bovenliggende netbeheerder"]
[null,null,null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[null,"Onderliggende netbeheerder","COGAS",null,"-","-",52753,"-","-","-","-"]
[null,null,"DNWB","-",null,"-","-","-","-","-","-"]
[null,null,"ENDINET","-","-",null,107693,"-","-","-","-"]
[null,null,"ENEXIS",64,"-",36,null,23910,"-","-","-"]
[null,null,"LIANDER","-","-","-",18029,null,"-","-","-"]
[null,null,"RENDO","-","-","-",32125,"-",null,"-","-"]
[null,null,"STEDIN","-","-","-",21508,25313,"-",null,15821]
[null,null,"WESTLAND","-","-","-","-","-","-",1785]
[]
[null,"Berekening onderliggende GA o.b.v. SectorSAIFI (MS)"]
[null,null,null,"Bovenliggende netbeheerder"]
[null,null,null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[null,"Onderliggende netbeheerder","COGAS",null,"-","-",{"$f":"G99*$C$53","v":10035.407356398689},"-","-","-","-"]
[null,null,"DNWB","-",null,"-","-","-","-","-","-"]
[null,null,"ENDINET","-","-",null,{"$f":"G101*$C$53","v":20486.856186996836},"-","-","-","-"]
[null,null,"ENEXIS",{"$f":"D102*$C$53","v":12.174967694908652},"-",{"$f":"F102*$C$53","v":6.8484193283861163},null,{"$f":"H102*$C$53","v":4548.4918372697794},"-","-","-"]
[null,null,"LIANDER","-","-","-",{"$f":"G103*$C$53","v":3429.7264464298137},null,"-","-","-"]
[null,null,"RENDO","-","-","-",{"$f":"G104*$C$53","v":6111.2630812334446},"-",null,"-","-"]
[null,null,"STEDIN","-","-","-",{"$f":"G105*$C$53","v":4091.5500809702389},{"$f":"H105*$C$53","v":4815.3899572066048},"-",null,{"$f":"K105*$C$53","v":3009.6900609554655}]
[null,null,"WESTLAND","-","-","-","-","-","-",{"$f":"J106*$C$53","v":339.5674583658116}]
[]
[]
[null,"Berekening gecorrigeerde SAIFI",null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND"]
[]
[null,"Correctie ΣGA(MS)",null,{"$f":"AandeelOnder*SUM(D111:D118)+AandeelBoven*SUM(D111:K111)","v":513.33658713009777},{"$f":"AandeelOnder*SUM(E111:E118)+AandeelBoven*SUM(D112:K112)","v":0},{"$f":"AandeelOnder*SUM(F111:F118)+AandeelBoven*SUM(D113:K113)","v":1030.8488077118086},{"$f":"AandeelOnder*SUM(G111:G118)+AandeelBoven*SUM(D114:K114)","v":42175.438755642223},{"$f":"AandeelOnder*SUM(H111:H118)+AandeelBoven*SUM(D115:K115)","v":9067.1740270740538},{"$f":"AandeelOnder*SUM(I111:I118)+AandeelBoven*SUM(D116:K116)","v":305.56315406167226},{"$f":"AandeelOnder*SUM(J111:J118)+AandeelBoven*SUM(D117:K117)","v":918.42059040413642},{"$f":"AandeelOnder*SUM(K111:K118)+AandeelBoven*SUM(D118:K118)","v":2876.1839308259823}]
[null,"Gecorrigeerde ΣGA(MS)",null,{"$f":"Data!D41+D123","v":10781.336587130098},{"$f":"Data!E41+E123","v":43609},{"$f":"Data!F41+F123","v":9621.8488077118091},{"$f":"Data!G41+G123","v":585806.43875564227},{"$f":"Data!H41+H123","v":709795.17402707401},{"$f":"Data!I41+I123","v":4078.5631540616723},{"$f":"Data!J41+J123","v":404877.42059040413},{"$f":"Data!K41+K123","v":8865.1839308259823}]
[null,"Gecorrigeerde SAIFI (MS)",null,{"$f":"D124/Data!D40","v":0.20413012320376586},{"$f":"E124/Data!E40","v":0.20855372019397231},{"$f":"F124/Data!F40","v":8.9315307927408674E-2},{"$f":"G124/Data!G40","v":0.20430024578383132},{"$f":"H124/Data!H40","v":0.24082919842386907},{"$f":"I124/Data!I40","v":0.126959164328768},{"$f":"J124/Data!J40","v":0.1958945587193443},{"$f":"K124/Data!K40","v":0.1255905243217825}]
[]
[null,"Gecorrigeerde SAIFI totaal",null,{"$f":"D125+Data!D47","v":0.24164528850555536},{"$f":"E125+Data!E47","v":0.29762030014060126},{"$f":"F125+Data!F47","v":0.11415443396159845},{"$f":"G125+Data!G47","v":0.23985937001877777},{"$f":"H125+Data!H47","v":0.29247867321298765},{"$f":"I125+Data!I47","v":0.15447667405639445},{"$f":"J125+Data!J47","v":0.23208319168809757},{"$f":"K125+Data!K47","v":0.16921168304875311}]
[]
[null,"Oorspronkelijke SAIFI totaal",null,{"$f":"Data!D49","v":0.23192594991251353},{"$f":"Data!E49","v":0.29762030014060126},{"$f":"Data!F49","v":0.10458552672481161},{"$f":"Data!G49","v":0.2251506677345872},{"$f":"Data!H49","v":0.28940223604799409},{"$f":"Data!I49","v":0.14496498054474707},{"$f":"Data!J49","v":0.23163882609217565},{"$f":"Data!K49","v":0.12846560820846889}]
[null,"Check op zero-sum effect",{"$f":"C94-SUM(D124:K124)/SUM(Data!D40:K40)","v":1.2569536675170467E-3}]

{"sheet":"q-factoren","index":5,"n_rows":74,"n_cols":16,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Berekening Q-factoren"]
[null,"(inclusief de correctie voor"]
[null,"onder/boven-liggende netbeheerders)"]
[]
[]
[]
[null,null,null,"COGAS","DNWB","ENDINET","ENEXIS","LIANDER","RENDO","STEDIN","WESTLAND","TOTAAL/GEMIDDELD",null,"Verwijzing formuleblad"]
[]
[null,"Input x-factoren"]
[null,"Begininkomsten 2013 met toepassing van aanpassing naar efficiënte kosten",null,16538248,70510233,32819915,900136332,973297947,11131359,665106177,47230367,null,null,null,null,"Bron: gewijzigd X-factormodel 2014-2016 elektriciteit (aug 2016) "]
[null,"X-factor voor de periode 2014-2016",null,4.8,4.46,5.01,4.66,4.3600000000000003,4.88,4.3499999999999996,4.63,null,null,null,null,"Bron: gewijzigd X-factormodel 2014-2016 elektriciteit (aug 2016) "]
[]
[]
[null,"Kwaliteitsprestatie 2010"]
[]
[null,"CAIDI",null,{"$f":"Data!D22","v":68.211484290357532},{"$f":"Data!E22","v":67.47169025811823},{"$f":"Data!F22","v":49.764398527490798},{"$f":"Data!G22","v":105.37209106872713},{"$f":"Data!H22","v":93.017297664062696},{"$f":"Data!I22","v":76.796556886227549},{"$f":"Data!J22","v":125.66711242276124},{"$f":"Data!K22","v":45.695097185958808},null,null,"(51)"]
[null,"SAIFI gecorrigeerd",null,{"$f":"'Verrekening onder-boven'!$D45","v":9.8388704803661325E-2},{"$f":"'Verrekening onder-boven'!$E45","v":0.38993314672792834},{"$f":"'Verrekening onder-boven'!$F45","v":0.25051005882978478},{"$f":"'Verrekening onder-boven'!$G45","v":0.2172567304913845},{"$f":"'Verrekening onder-boven'!$H45","v":0.32899455325559335},{"$f":"'Verrekening onder-boven'!$I45","v":0.22180089278021481},{"$f":"'Verrekening onder-boven'!$J45","v":0.18002987637760123},{"$f":"'Verrekening onder-boven'!$K45","v":0.71748048444372248},null,null,"(50), (53), (54), (55) en (56)"]
[null,"Waardering Huishoudens",null,{"$f":"-1*SEO(\"H\",D$19,D$18/60)","v":10.62189289088831},{"$f":"-1*SEO(\"H\",E$19,E$18/60)","v":-3.8380044030653582},{"$f":"-1*SEO(\"H\",F$19,F$18/60)","v":-1.7974822803426811},-2.7188501582712501,-4.1893699998381795,-2.2618942845529344,-2.1117356984892912,-3.8905266634531039,null,null,"(59)"]
[null,"Waardering Bedrijven",null,{"$f":"-1*SEO(\"B\",D$19,D$18/60)","v":-4.990738731434833},{"$f":"-1*SEO(\"B\",E$19,E$18/60)","v":-41.747155489367636},{"$f":"-1*SEO(\"B\",F$19,F$18/60)","v":-23.841316788753453},-33.244711945542818,-44.771058602461963,-28.580023366140715,-29.114477632564682,-43.872077008838275,null,null,"(60)"]
[null,"Kwaliteitsprestatie",null,{"$f":"(D20*PercH2010+D21*PercB2010)","v":8.5922507799863013},{"$f":"(E20*PercH2010+E21*PercB2010)","v":-8.7661940442846547},-4.6631807664360814,-6.6872121906165543,-9.4649895181792711,-5.6832510651593457,-5.6220921499190926,-9.0881282083531758,{"$f":"SUMPRODUCT(D22:K22,D23:K23)/L23","v":-7.3030831001336143},null,"(61) en (62)"]
[null,"# Afnemers",null,{"$f":"Data!$D24","v":52699},{"$f":"Data!$E24","v":203281},{"$f":"Data!$F24","v":105324},{"$f":"Data!$G24","v":2597100},{"$f":"Data!$H24","v":2694813},{"$f":"Data!$I24","v":31637},{"$f":"Data!$J24","v":2053470},{"$f":"Data!$K24","v":53190},{"$f":"SUM(D23:K23)","v":7791514}]
[]
[null,"Q-bedrag (prijspeil 2008)",null,{"$f":"(D22-$L22)*D23","v":837668.20014843938},{"$f":"(E22-$L22)*E23","v":-297422.65583796764},278045.07339435897,1599478.3391067565,-5825933.5201328704,51246.626090480931,3451864.4865370141,-94946.549306198474,{"$f":"SUM(D25:K25)","v":1.3518729247152805E-8},null,"(63) en (64)"]
[]
[]
[null,"Kwaliteitsprestatie 2011"]
[]
[null,"CAIDI",null,{"$f":"Data!D35","v":50.79706817379018},{"$f":"Data!E35","v":58.975138696911742},{"$f":"Data!F35","v":76.70216210677323},{"$f":"Data!G35","v":79.294962162231855},{"$f":"Data!H35","v":78.417828861581512},{"$f":"Data!I35","v":93.194899124476592},{"$f":"Data!J35","v":117.25826970621463},{"$f":"Data!K35","v":51.609248960368753},null,null,"(51)"]
[null,"SAIFI gecorrigeerd",null,{"$f":"'Verrekening onder-boven'!$D86","v":0.11732971216963368},{"$f":"'Verrekening onder-boven'!$E86","v":0.25359653503380453},{"$f":"'Verrekening onder-boven'!$F86","v":0.46962309627563337},{"$f":"'Verrekening onder-boven'!$G86","v":0.23552434035928516},{"$f":"'Verrekening onder-boven'!$H86","v":0.25390399248989937},{"$f":"'Verrekening onder-boven'!$I86","v":9.1948069700180976E-2},{"$f":"'Verrekening onder-boven'!$J86","v":0.17804862464112406},{"$f":"'Verrekening onder-boven'!$K86","v":0.33903712707342837},null,null,"(50), (53), (54), (55) en (56)"]
[null,"Waardering Huishoudens",null,{"$f":"-1*SEO(\"H\",D$31,D$30/60)","v":10.45411932906633},{"$f":"-1*SEO(\"H\",E$31,E$30/60)","v":-2.1810751479409101},-4.9204204640971749,-2.5330725574277744,-2.780670314245334,10.581228663432253,-1.9797019170141028,-2.6182129498239859,null,null,"(59)"]
[null,"Waardering Bedrijven",null,{"$f":"-1*SEO(\"B\",D$31,D$30/60)","v":-7.7557006702770233},{"$f":"-1*SEO(\"B\",E$31,E$30/60)","v":-27.394615492252136},-50.744482398231135,-30.914500518650769,-32.945203082825138,-3.9024841870017886,-27.785460686985775,-31.356406396948628,null,null,"(60)"]
[null,"Kwaliteitsprestatie",null,{"$f":"(D32*PercH2011+D33*PercB2011)","v":7.9047445291582603},-5.7109707961444816,-11.335789134875931,-6.5064724719989941,-7.0037049018465076,8.5535088643714872,-5.5925081448101377,-6.6415600324214363,{"$f":"SUMPRODUCT(D34:K34,D35:K35)/L35","v":-6.3316433390085392},null,"(61) en (62)"]
[null,"# Afnemers",null,{"$f":"Data!$D37","v":52566},{"$f":"Data!$E37","v":208256},{"$f":"Data!$F37","v":106030},{"$f":"Data!$G37","v":2616840},{"$f":"Data!$H37","v":2771415},{"$f":"Data!$I37","v":31867},{"$f":"Data!$J37","v":2050254},{"$f":"Data!$K37","v":53943},{"$f":"SUM(D35:K35)","v":7891171}]
[]
[null,"Q-bedrag (prijspeil 2008)",null,{"$f":"(D34-$L34)*D35","v":748349.96467805596},{"$f":"(E34-$L34)*E35","v":129258.78108669718},-530589.57873581955,-457499.86837474222,-1862561.4961725883,474345.14526511135,1515414.8884460493,-16717.836192771912,{"$f":"SUM(D37:K37)","v":-8.5019564721733332E-9},null,"(63) en (64)"]
[]
[]
[null,"Kwaliteitsprestatie 2012"]
[]
[null,"CAIDI",null,{"$f":"Data!D48","v":55.692986037396913},{"$f":"Data!E48","v":65.064499542043606},{"$f":"Data!F48","v":82.601366944789632},{"$f":"Data!G48","v":94.403116708690348},{"$f":"Data!H48","v":81.710329816606546},{"$f":"Data!I48","v":64.501610478849045},{"$f":"Data!J48","v":144.03893398477777},{"$f":"Data!K48","v":60.97302458820721},null,null,"(51)"]
[null,"SAIFI gecorrigeerd",null,{"$f":"'Verrekening onder-boven'!$D127","v":0.24164528850555536},{"$f":"'Verrekening onder-boven'!$E127","v":0.29762030014060126},{"$f":"'Verrekening onder-boven'!$F127","v":0.11415443396159845},{"$f":"'Verrekening onder-boven'!$G127","v":0.23985937001877777},{"$f":"'Verrekening onder-boven'!$H127","v":0.29247867321298765},{"$f":"'Verrekening onder-boven'!$I127","v":0.15447667405639445},{"$f":"'Verrekening onder-boven'!$J127","v":0.23208319168809757},{"$f":"'Verrekening onder-boven'!$K127","v":0.16921168304875311},null,null,"(50), (53), (54), (55) en (56)"]
[null,"Waardering Huishoudens",null,{"$f":"-1*SEO(\"H\",D$43,D$42/60)","v":-1.9332514945474906},{"$f":"-1*SEO(\"H\",E$43,E$42/60)","v":-2.8803404695872477},10.190060901634705,-2.9369467466510697,-3.3900903849158435,-0.87114384037144166,-3.5848162177600602,-1.0867283103574894,null,null,"(59)"]
[null,"Waardering Bedrijven",null,{"$f":"-1*SEO(\"B\",D$43,D$42/60)","v":-25.14068881731378},{"$f":"-1*SEO(\"B\",E$43,E$42/60)","v":-33.546693946707364},-9.9291596826041104,-34.664671346916265,-38.061458225038194,-16.223016912312353,-41.103805849784919,-17.876455127785217,null,null,"(60)"]
[null,"Kwaliteitsprestatie",null,{"$f":"(D44*PercH2012+D45*PercB2012)","v":-5.1822927197347717},{"$f":"(E44*PercH2012+E45*PercB2012)","v":-7.1736299563840644},{"$f":"(F44*PercH2012+F45*PercB2012)","v":7.3733700198412704},-7.3788281906881981,-8.2440818825329725,-3.0204060704431694,-8.8374747662435418,-3.4372900647973714,{"$f":"SUMPRODUCT(D46:K46,D47:K47)/L47","v":-7.8009295645169976},null,"(61) en (62)"]
[null,"# Afnemers",null,{"$f":"Data!$D50","v":52752},{"$f":"Data!$E50","v":209102},{"$f":"Data!$F50","v":107693},{"$f":"Data!$G50","v":2635273},{"$f":"Data!$H50","v":2898074},{"$f":"Data!$I50","v":32125},{"$f":"Data!$J50","v":2049207},{"$f":"Data!$K50","v":54767},{"$f":"SUM(D47:K47)","v":8038993}]
[]
[null,"Q-bedrag (prijspeil 2008)",null,{"$f":"(D46-$L46)*D47","v":138138.33083595199},{"$f":"(E46-$L46)*E47","v":131169.6026598126},1634165.8451382949,1112352.353713942,-1284288.2108818283,153574.31724712171,-2124095.6831944464,238983.4444811448,{"$f":"SUM(D49:K49)","v":-6.8394001573324203E-9},null,"(63) en (64)"]
[]
[]
[null,"Berekening Q-factor"]
[]
[null,"CPI van 2008 naar 2013",null,{"$f":"Parameters!C30","v":0.1027312117791197}]
[null,"CPI van 2010 naar 2013",null,{"$f":"Parameters!D30","v":6.5341969999999749E-2}]
[]
[null,"Totale Q-bedrag (prijspeil 2008)",null,{"$f":"D25+D37+D49","v":1724156.4956624473},{"$f":"E25+E37+E49","v":-36994.272091457853},1381621.3397968342,2254330.8244459564,-8972783.2271872871,679166.08860271401,2843183.6917886166,127319.05898217442,{"$f":"SUM(D57:K57)","v":-1.3533281162381172E-9}]
[null,"Totale Q-bedrag (prijspeil 2013)",null,{"$f":"D57*(1+$D$54)","v":1901281.1817586911},{"$f":"E57*(1+$D$54)","v":-40794.738492299788},1523556.9742540538,2485920.9617923116,-9894568.1211475972,748937.64388415578,3135267.3977566925,140398.7001939904,{"$f":"SUM(D58:K58)","v":-1.9499566406011581E-9}]
[null,"2/3 van Q-bedrag (prijspeil 2013)",null,{"$f":"D58*2/3","v":1267520.7878391275},{"$f":"E58*2/3","v":-27196.49232819986},1015704.6495027025,1657280.6411948744,-6596378.7474317318,499291.76258943719,2090178.2651711283,93599.133462660262,-1.6152625903487206E-9]
[]
[null,"Q-bedrag NE5R (prijspeil 2010)",null,1986260.9014868981,279912.5754132985,2407396.5926489304,882800.43460276653,-10577722.157340894,852998.76485631312,4313524.0197631344,-145171.13143045304,{"$f":"SUM(D61:K61)","v":-5.9371814131736755E-9}]
[null,"Q-bedrag NE5R (prijspeil 2013)",null,{"$f":"D61*(1+$D$55)","v":2116047.1017240277},{"$f":"E61*(1+$D$55)","v":298202.61451857694},2564700.6285838983,940484.35411656729,-11268891.361214194,908735.38455959118,4595378.1768567758,-154656.89914524773,{"$f":"SUM(D62:K62)","v":-4.9767550081014633E-9}]
[null,"1/3 Q-bedrag NE5R (prijspeil 2013)",null,{"$f":"D61/3","v":662086.96716229932},{"$f":"E61/3","v":93304.191804432834},802465.53088297683,294266.81153425551,-3525907.3857802977,284332.92161877104,1437841.3399210449,-48390.377143484344,{"$f":"SUM(D63:K63)","v":-1.4333636499941349E-9}]
[]
[null,"Totale bedrag dat verrekend moet worden in q-factor NE6R",null,{"$f":"D59+D63","v":1929607.7550014267},{"$f":"E59+E63","v":66107.69947623297},1818170.1803856795,1951547.4527291299,-10122286.13321203,783624.68420820823,3528019.6050921734,45208.756319175918]
[]
[null,"Doelzoeken"]
[null,"links (BI - x + 1/3 Q-bedrag NE5R + 2/3 Q-bedrag NE6R)",null,{"$f":"D12*(1-D13/100)+D12*(1-D13/100)^2+D12*(1-D13/100)^3+D65","v":46931923.826646604},193283037.46534908,90737634.837208331,2458410136.2155256,2662476945.0526161,31023180.800533496,1830233280.2601964,129016015.1170665,null,null,"(65) links"]
[null,"rechts (BI - x + q)",null,{"$f":"D12*(1-D13/100+D71/100)+D12*(1-D13/100+D71/100)^2+D12*(1-D13/100+D71/100)^3","v":46931923.82664647},193283037.46534881,90737634.837208301,2458410136.2155256,2662476945.0526156,31023180.800533481,1830233280.2601967,129016015.11706629,null,null,"(65) rechts"]
[null,"links - rechts = nul",null,{"$f":"D68-D69","v":1.3411045074462891E-7},{"$f":"E68-E69","v":2.6822090148925781E-7},0,0,0,0,0,2.0861625671386719E-7]
[null,"q-factor 2014-2017 (niet afgerond)",null,2.0461375503352315,1.659457451356745E-2,0.98143881528246557,3.8473481835340551E-2,-0.18407760820312766,1.2427283780167195,9.3696548382403419E-2,1.6981550366981329E-2]
[]
["Resultaat (ongecorrigeerd)"]
[null,"q-factor 2014-2017 (afgerond)",null,{"$f":"IF(D71>0,ROUNDUP(D71,2),ROUNDDOWN(D71,2))","v":2.0499999999999998},{"$f":"IF(E71>0,ROUNDUP(E71,2),ROUNDDOWN(E71,2))","v":0.02},0.99,0.04,-0.18,1.25,9.9999999999999992E-2,0.02]

{"sheet":"Parameters","index":6,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"PARAMETERS SEO-WAARDERINGSFUNCTIE"]
[]
[null,"De volgende parameters worden in de waarderingsfunctie van SEO (update 2009, prijspeil 2008) gebruikt:"]
[]
[null,null,"Huishoudens","Bedrijven",null,"DEZE TABEL NIET VERPLAASTEN VANWEGE MACRO!"]
[null,"µ1",0.08,0.11]
[null,"µ2",100,100]
[null,"λ0",2.8,18.18]
[null,"λ0*",5.77,43.01]
[null,"λ1",2.89,4.1900000000000004]
[null,"P0",-12.53,-86.97]
[]
[null,"CPI Data (bron CBS)"]
[]
[null,2009,3.2000000000000001E-2]
[null,2010,3.0000000000000001E-3]
[null,2011,1.4999999999999999E-2]
[null,2012,2.5999999999999999E-2]
[null,2013,2.3E-2]
[]
[]
[null,"CPI van/naar","van 2008","van 2010"]
[null,"naar 2013",{"$f":"(1+C22)*(1+C23)*(1+C24)*(1+C25)*(1+C26)-1","v":0.1027312117791197},{"$f":"(1+C24)*(1+C25)*(1+C26)-1","v":6.5341969999999749E-2}]
[]
[]
[null,"VERDELING HUISHOUDENS/MKB"]
[]
[null,null,"% Huishoudens","% MKB"]
[null,2010,0.87,0.13]
[null,2011,0.86,0.14000000000000001]
[null,2012,0.86,0.14000000000000001]
[]
[null,"Gewichten onder- en bovenliggende netbeheerders"]
[]
[null,null,"Aandeel"]
[null,"Onderliggende",0.95]
[null,"Bovenliggend",0.05]
[]
[null,"Volgorde netbeheerders in data-tabel"]
[]
[null,"COGAS",1]
[null,"DNWB",2]
[null,"ENDINET",3]
[null,"ENEXIS",4]
[null,"LIANDER",5]
[null,"RENDO",6]
[null,"STEDIN",7]
[null,"WESTLAND",8]