{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["MPG combinatiegebouw"],"not_rendered":{"images":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"MPG combinatiegebouw","index":0,"n_rows":220,"n_cols":29,"rows_kept":220,"merged":[[2,1,2,3],[5,2,5,3],[6,2,6,3],[6,6,13,6],[7,2,7,3],[8,2,8,3],[10,2,13,4],[15,23,15,25],[20,14,20,17],[21,14,21,17],[22,14,22,17],[127,2,127,4],[169,8,169,11],[170,8,170,11],[171,8,171,11],[173,8,173,11],[175,8,175,11],[185,8,185,11],[199,8,199,11]]}
[]
[null,"Berekenen MPG-eis combinatiegebouw"]
[null,"2025-10-04"]
[]
[null,null,"Projectkenmerken",{"$nulls":5},"Werkwijze"]
[null,null,"Projectnaam",{"$nulls":3},"Projectnotities",null,1,"Stel het gebouw samen. Selecteer één voor één de aanwezige gebruiksfuncties binnen het gebouw."]
[null,null,"Projectcode",{"$nulls":5},2,"Voer het aantal eenheden van herhalende ruimtes in. Bijvoorbeeld bij appartementen. "]
[null,null,"Locatie",{"$nulls":5},3,"Voer de gebruiksoppervlakte (GO) in."]
[null,null,"Datum",{"$nulls":5},4,"Indien de gebruiksfunctie Wonen wordt geselecteerd, selecteer het type."]
[null,null,"Omschrijving gebouw",{"$nulls":5},5,"Indien de gebruiksfunctie Kantoor wordt geselecteerd, voer dan ook de schiloppervlakte in. "]
[{"$nulls":9},"Dit hoeft maar één keer te gebeuren, voor het hele gebouw (niet alleen de specifieke functie)"]
[{"$nulls":8},6,"Indien de gebruiksfunctie Gemeenschappelijke Ruimte wordt geselecteerd, kies dan ook de sub-functie."]
[{"$nulls":8},7,"Lees de gewogen maximale MPG-score af. Lees de correctiefactor MPG af om in te vullen in GPR Gebouw 4.5"]
[{"$nulls":8},"…","Zie het blad onder de berekening voor aanvullende informatie en achtergronddata"]
[]
[{"$nulls":8},"Aantal eenheden","GO per eenheid",null,"Als;gebouw [m2]",{"$nulls":7},"MPG-eis gebouw",{"$nulls":3},"Verbergen in eindversie"]
[null,null,"Gebouw",{"$nulls":5},{"$f":"SUM(I$28:I$127)","v":1},{"$f":"SUMPRODUCT($J$28:$J$127,$I$28:$I$127)","v":50},{"$nulls":4},{"$f":"SUM($O$28:$O$127)","v":50},{"$f":"SUMIFS($P$28:$P$127,$D$28:$D$127,$D$168)","v":0},{"$f":"SUM($Q$28:$Q$127)","v":50},{"$f":"IFERROR(IF(AND($L$17<>0,SUM($Q$28:$Q$127)<>0),$L$17/SUM($Q$28:$Q$127),\"Vul GO in\"),\"\")","v":"Vul GO in"},null,{"$f":"T21","v":{"v":-0.32499999999999996,"d":"-0.33"}}]
["verbergen"]
["verbergen",null,"Hulprij, verbergen in eindversie",{"$nulls":11},{"$f":"SUM($O$28:$O$127)-IFERROR(SUM(_xlfn._xlws.FILTER($O$28:$O$127,$D$28:$D$127=$D$169)),0)","v":50},{"$f":"SUM(IF($E$28:$E$127=$E$209,$I$28:$I$127*$J$28:$J$127,0))","v":0},{"$f":"SUM(Q28:Q127)","v":50},{"$f":"Q19-P19-O19","v":0},null,{"$f":"IFERROR(SUMPRODUCT(Q28:Q127,T28:T127),0)","v":-16.249999999999996},{"$nulls":3},{"$f":"IFERROR(SUMPRODUCT(Q28:Q127,X28:X127),0)","v":77.5}]
["verbergen",null,"Hulprij, verbergen in eindversie",{"$nulls":8},"zijn er fouten:",null,{"$f":"IF(COUNTBLANK($C$130:$C$132)=3,FALSE,TRUE)","v":false},"excl gem. ruimte","GR naar rato","totaal","GR naar functie",null,{"$f":"$T$19/$Q$19","v":-0.32499999999999996},{"$nulls":3},{"$f":"$X$19/$Q$19","v":1.55}]
[{"$nulls":14},"MPG-eis gebouw",{"$nulls":4},{"$f":"IFERROR(IF($N$20=TRUE,\"Verwerk fouten\",$T$20),\"Data invoeren\")","v":{"v":-0.32499999999999996,"d":"-0.33"}},{"$nulls":3},{"$f":"X20","v":1.55}]
[{"$nulls":14},"Berekende MPG-waarde gebouw"]
[{"$nulls":14},"Correctiefactor MPG-waarde in GPR Gebouw 4.5",{"$nulls":4},{"$f":"IFERROR(X21/T21,\"-\")","v":{"v":-4.76923076923077,"d":"-4.77"}}]
[]
[null,null,"Nr.","Gebruiksfunctie: Bbl","Specificeer type/toewijzing aan:",null,"Kenmerk/notitie",null,"Aantal eenheden","GO per eenheid",null,"Als;gebouw",null,"Afwijkende eis?","Gebruiks-oppervlakte","Gebruiks-oppervlakte","Gebruiks-oppervlakte","Compactheid",null,"MPG-eis",{"$nulls":3},"Eis_functie","Eis_wonen","Eis_kantoor","Toegewezen GO obv functie","Toegewezen GO obv naar rato","Som toegewezen GO"]
[{"$nulls":3},"(selecteer)","(bij wonen & gem. ruimte)",null,"(Optioneel, voor eigen referentie)",null,"-","[m2]",null,"[m2]",null,null,"Gebr. Functie","Gem. Ruimte","Totaal","-",null,"Per gebruiksfunctie"]
[{"$nulls":11},"i",null,null,"i","i","i","i"]
[null,null,1,"Kantoor",null,{"$f":"IF(AND(OR(D28=$D$157,D28=$D$168),E28=\"\"),\"!!\",\"\")","v":""},null,null,1,50,{"$f":"IF(OR(AND(E28=$D$173,J28>=$F$174),AND(E28=$D$174,J28<$F$173),AND(E28=$D$175,J28>=$F$176),AND(E28=$D$176,J28<$F$175)),\"!\",\"\")","v":""},null,null,{"$f":"IF(OR(E28=$D$173,E28=$D$175,AND(D28=$D$162,$R$17>2.5)),\"Ja\",\"\")","v":"Ja"},{"$f":"IF(OR(D28=$D$156,D28=$D$168),0,I28*J28)","v":50},{"$f":"IFERROR(IF(D28=$D$168,I28*J28,IF(OR(D28=$D$156,D28=$D$169),0,$AC28)),\"\")","v":0},{"$f":"IFERROR(IF(D28=$D$168,0,O28+P28),\"\")","v":50},null,null,{"$f":"IFERROR(IF(D28=$D$157,Y28,IF(D28=$D$162,Z28,X28)),\"Data ontbreekt!\")","v":{"v":-0.32499999999999996,"d":"-0.33"}},{"$nulls":3},{"$f":"IF(D28=$D$157,VLOOKUP(E28,$D$173:$E$177,2,FALSE),VLOOKUP(D28,$D$156:$E$169,2,FALSE))","v":1.55},{"$f":"IFERROR(IF(E28=$D$173,1.6+0.015*(60-J28),IF(E28=$D$175,1.6+0.015*(80-J28),VLOOKUP(E28,$D$173:$E$177,2,FALSE))),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF(D28=$D$162,IF(($R$17<2.5),$E$162,1.55+0.75*(($L$17/SUMPRODUCT($J$28:$J$127,$I$28:$I$127))-2.5)),0),\"Invoeren data\")","v":{"v":-0.32499999999999996,"d":"-0.33"}},{"$f":"IF(D28<>$D$168, IF(MATCH(D28,D$28:D28,0)=ROW(D28)-ROW(D$28)+1, _xlfn.XLOOKUP(D28,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(NOT(D28=$D$168),$P$19*(O28/$O$19),0)","v":{"v":0,"d":"0.00"}},{"$f":"AB28+AA28","v":{"v":0,"d":"0.00"}}]
[null,null,2,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,{"$f":"IFERROR(IF(D29=$D$157,Y29,IF(D29=$D$162,Z29,X29)),\"Data ontbreekt!\")","v":"-"},{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D29<>$D$168, IF(MATCH(D29,D$28:D29,0)=ROW(D29)-ROW(D$28)+1, _xlfn.XLOOKUP(D29,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"AB29+AA29","v":{"v":0,"d":"0.00"}}]
[null,null,3,"Voeg functie toe:","Verdeel naar rato GO","",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D30<>$D$168, IF(MATCH(D30,D$28:D30,0)=ROW(D30)-ROW(D$28)+1, _xlfn.XLOOKUP(D30,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,4,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D31<>$D$168, IF(MATCH(D31,D$28:D31,0)=ROW(D31)-ROW(D$28)+1, _xlfn.XLOOKUP(D31,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,5,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D32<>$D$168, IF(MATCH(D32,D$28:D32,0)=ROW(D32)-ROW(D$28)+1, _xlfn.XLOOKUP(D32,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,6,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D33<>$D$168, IF(MATCH(D33,D$28:D33,0)=ROW(D33)-ROW(D$28)+1, _xlfn.XLOOKUP(D33,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,7,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D34<>$D$168, IF(MATCH(D34,D$28:D34,0)=ROW(D34)-ROW(D$28)+1, _xlfn.XLOOKUP(D34,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,8,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D35<>$D$168, IF(MATCH(D35,D$28:D35,0)=ROW(D35)-ROW(D$28)+1, _xlfn.XLOOKUP(D35,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,9,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D36<>$D$168, IF(MATCH(D36,D$28:D36,0)=ROW(D36)-ROW(D$28)+1, _xlfn.XLOOKUP(D36,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,10,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D37<>$D$168, IF(MATCH(D37,D$28:D37,0)=ROW(D37)-ROW(D$28)+1, _xlfn.XLOOKUP(D37,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,11,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D38<>$D$168, IF(MATCH(D38,D$28:D38,0)=ROW(D38)-ROW(D$28)+1, _xlfn.XLOOKUP(D38,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,12,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D39<>$D$168, IF(MATCH(D39,D$28:D39,0)=ROW(D39)-ROW(D$28)+1, _xlfn.XLOOKUP(D39,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,13,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D40<>$D$168, IF(MATCH(D40,D$28:D40,0)=ROW(D40)-ROW(D$28)+1, _xlfn.XLOOKUP(D40,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,14,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D41<>$D$168, IF(MATCH(D41,D$28:D41,0)=ROW(D41)-ROW(D$28)+1, _xlfn.XLOOKUP(D41,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,15,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D42<>$D$168, IF(MATCH(D42,D$28:D42,0)=ROW(D42)-ROW(D$28)+1, _xlfn.XLOOKUP(D42,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,16,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D43<>$D$168, IF(MATCH(D43,D$28:D43,0)=ROW(D43)-ROW(D$28)+1, _xlfn.XLOOKUP(D43,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,17,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D44<>$D$168, IF(MATCH(D44,D$28:D44,0)=ROW(D44)-ROW(D$28)+1, _xlfn.XLOOKUP(D44,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,18,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D45<>$D$168, IF(MATCH(D45,D$28:D45,0)=ROW(D45)-ROW(D$28)+1, _xlfn.XLOOKUP(D45,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,19,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D46<>$D$168, IF(MATCH(D46,D$28:D46,0)=ROW(D46)-ROW(D$28)+1, _xlfn.XLOOKUP(D46,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,20,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D47<>$D$168, IF(MATCH(D47,D$28:D47,0)=ROW(D47)-ROW(D$28)+1, _xlfn.XLOOKUP(D47,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,21,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D48<>$D$168, IF(MATCH(D48,D$28:D48,0)=ROW(D48)-ROW(D$28)+1, _xlfn.XLOOKUP(D48,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,22,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D49<>$D$168, IF(MATCH(D49,D$28:D49,0)=ROW(D49)-ROW(D$28)+1, _xlfn.XLOOKUP(D49,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,23,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D50<>$D$168, IF(MATCH(D50,D$28:D50,0)=ROW(D50)-ROW(D$28)+1, _xlfn.XLOOKUP(D50,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,24,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D51<>$D$168, IF(MATCH(D51,D$28:D51,0)=ROW(D51)-ROW(D$28)+1, _xlfn.XLOOKUP(D51,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,25,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D52<>$D$168, IF(MATCH(D52,D$28:D52,0)=ROW(D52)-ROW(D$28)+1, _xlfn.XLOOKUP(D52,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,26,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D53<>$D$168, IF(MATCH(D53,D$28:D53,0)=ROW(D53)-ROW(D$28)+1, _xlfn.XLOOKUP(D53,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,27,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D54<>$D$168, IF(MATCH(D54,D$28:D54,0)=ROW(D54)-ROW(D$28)+1, _xlfn.XLOOKUP(D54,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,28,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D55<>$D$168, IF(MATCH(D55,D$28:D55,0)=ROW(D55)-ROW(D$28)+1, _xlfn.XLOOKUP(D55,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,29,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D56<>$D$168, IF(MATCH(D56,D$28:D56,0)=ROW(D56)-ROW(D$28)+1, _xlfn.XLOOKUP(D56,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,30,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D57<>$D$168, IF(MATCH(D57,D$28:D57,0)=ROW(D57)-ROW(D$28)+1, _xlfn.XLOOKUP(D57,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,31,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D58<>$D$168, IF(MATCH(D58,D$28:D58,0)=ROW(D58)-ROW(D$28)+1, _xlfn.XLOOKUP(D58,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,32,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D59<>$D$168, IF(MATCH(D59,D$28:D59,0)=ROW(D59)-ROW(D$28)+1, _xlfn.XLOOKUP(D59,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,33,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D60<>$D$168, IF(MATCH(D60,D$28:D60,0)=ROW(D60)-ROW(D$28)+1, _xlfn.XLOOKUP(D60,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,34,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D61<>$D$168, IF(MATCH(D61,D$28:D61,0)=ROW(D61)-ROW(D$28)+1, _xlfn.XLOOKUP(D61,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,35,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D62<>$D$168, IF(MATCH(D62,D$28:D62,0)=ROW(D62)-ROW(D$28)+1, _xlfn.XLOOKUP(D62,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,36,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D63<>$D$168, IF(MATCH(D63,D$28:D63,0)=ROW(D63)-ROW(D$28)+1, _xlfn.XLOOKUP(D63,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,37,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D64<>$D$168, IF(MATCH(D64,D$28:D64,0)=ROW(D64)-ROW(D$28)+1, _xlfn.XLOOKUP(D64,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,38,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D65<>$D$168, IF(MATCH(D65,D$28:D65,0)=ROW(D65)-ROW(D$28)+1, _xlfn.XLOOKUP(D65,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,39,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D66<>$D$168, IF(MATCH(D66,D$28:D66,0)=ROW(D66)-ROW(D$28)+1, _xlfn.XLOOKUP(D66,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,40,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D67<>$D$168, IF(MATCH(D67,D$28:D67,0)=ROW(D67)-ROW(D$28)+1, _xlfn.XLOOKUP(D67,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,41,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D68<>$D$168, IF(MATCH(D68,D$28:D68,0)=ROW(D68)-ROW(D$28)+1, _xlfn.XLOOKUP(D68,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,42,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D69<>$D$168, IF(MATCH(D69,D$28:D69,0)=ROW(D69)-ROW(D$28)+1, _xlfn.XLOOKUP(D69,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,43,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D70<>$D$168, IF(MATCH(D70,D$28:D70,0)=ROW(D70)-ROW(D$28)+1, _xlfn.XLOOKUP(D70,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,44,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D71<>$D$168, IF(MATCH(D71,D$28:D71,0)=ROW(D71)-ROW(D$28)+1, _xlfn.XLOOKUP(D71,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,45,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D72<>$D$168, IF(MATCH(D72,D$28:D72,0)=ROW(D72)-ROW(D$28)+1, _xlfn.XLOOKUP(D72,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,46,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D73<>$D$168, IF(MATCH(D73,D$28:D73,0)=ROW(D73)-ROW(D$28)+1, _xlfn.XLOOKUP(D73,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,47,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D74<>$D$168, IF(MATCH(D74,D$28:D74,0)=ROW(D74)-ROW(D$28)+1, _xlfn.XLOOKUP(D74,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,48,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D75<>$D$168, IF(MATCH(D75,D$28:D75,0)=ROW(D75)-ROW(D$28)+1, _xlfn.XLOOKUP(D75,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,49,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D76<>$D$168, IF(MATCH(D76,D$28:D76,0)=ROW(D76)-ROW(D$28)+1, _xlfn.XLOOKUP(D76,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,50,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D77<>$D$168, IF(MATCH(D77,D$28:D77,0)=ROW(D77)-ROW(D$28)+1, _xlfn.XLOOKUP(D77,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,51,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D78<>$D$168, IF(MATCH(D78,D$28:D78,0)=ROW(D78)-ROW(D$28)+1, _xlfn.XLOOKUP(D78,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,52,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D79<>$D$168, IF(MATCH(D79,D$28:D79,0)=ROW(D79)-ROW(D$28)+1, _xlfn.XLOOKUP(D79,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,53,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D80<>$D$168, IF(MATCH(D80,D$28:D80,0)=ROW(D80)-ROW(D$28)+1, _xlfn.XLOOKUP(D80,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,54,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D81<>$D$168, IF(MATCH(D81,D$28:D81,0)=ROW(D81)-ROW(D$28)+1, _xlfn.XLOOKUP(D81,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,55,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D82<>$D$168, IF(MATCH(D82,D$28:D82,0)=ROW(D82)-ROW(D$28)+1, _xlfn.XLOOKUP(D82,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,56,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D83<>$D$168, IF(MATCH(D83,D$28:D83,0)=ROW(D83)-ROW(D$28)+1, _xlfn.XLOOKUP(D83,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,57,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D84<>$D$168, IF(MATCH(D84,D$28:D84,0)=ROW(D84)-ROW(D$28)+1, _xlfn.XLOOKUP(D84,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,58,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D85<>$D$168, IF(MATCH(D85,D$28:D85,0)=ROW(D85)-ROW(D$28)+1, _xlfn.XLOOKUP(D85,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,59,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D86<>$D$168, IF(MATCH(D86,D$28:D86,0)=ROW(D86)-ROW(D$28)+1, _xlfn.XLOOKUP(D86,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,60,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D87<>$D$168, IF(MATCH(D87,D$28:D87,0)=ROW(D87)-ROW(D$28)+1, _xlfn.XLOOKUP(D87,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,61,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D88<>$D$168, IF(MATCH(D88,D$28:D88,0)=ROW(D88)-ROW(D$28)+1, _xlfn.XLOOKUP(D88,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,62,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D89<>$D$168, IF(MATCH(D89,D$28:D89,0)=ROW(D89)-ROW(D$28)+1, _xlfn.XLOOKUP(D89,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,63,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D90<>$D$168, IF(MATCH(D90,D$28:D90,0)=ROW(D90)-ROW(D$28)+1, _xlfn.XLOOKUP(D90,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,64,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D91<>$D$168, IF(MATCH(D91,D$28:D91,0)=ROW(D91)-ROW(D$28)+1, _xlfn.XLOOKUP(D91,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,65,"Voeg functie toe:",null,{"$f":"IF(AND(OR(D92=$D$157,D92=$D$168),E92=\"\"),\"!!\",\"\")","v":""},{"$nulls":4},{"$f":"IF(OR(AND(E92=$D$173,J92>=$F$174),AND(E92=$D$174,J92<$F$173),AND(E92=$D$175,J92>=$F$176),AND(E92=$D$176,J92<$F$175)),\"!\",\"\")","v":""},null,null,{"$f":"IF(OR(E92=$D$173,E92=$D$175,AND(D92=$D$162,$R$17>2.5)),\"Ja\",\"\")","v":""},{"$f":"IF(OR(D92=$D$156,D92=$D$168),0,I92*J92)","v":0},{"$f":"IFERROR(IF(D92=$D$168,I92*J92,IF(OR(D92=$D$156,D92=$D$169),0,$AC92)),\"\")","v":0},{"$f":"IFERROR(IF(D92=$D$168,0,O92+P92),\"\")","v":0},null,null,"-",{"$nulls":3},{"$f":"IF(D92=$D$157,VLOOKUP(E92,$D$173:$E$177,2,FALSE),VLOOKUP(D92,$D$156:$E$169,2,FALSE))","v":"-"},{"$f":"IFERROR(IF(E92=$D$173,1.6+0.015*(60-J92),IF(E92=$D$175,1.6+0.015*(80-J92),VLOOKUP(E92,$D$173:$E$177,2,FALSE))),0)","v":{"v":0,"d":"0.00"}},{"$f":"IFERROR(IF(D92=$D$162,IF(($R$17<2.5),$E$162,1.55+0.75*(($L$17/SUMPRODUCT($J$28:$J$127,$I$28:$I$127))-2.5)),0),\"Invoeren data\")","v":{"v":0,"d":"0.00"}},{"$f":"IF(D92<>$D$168, IF(MATCH(D92,D$28:D92,0)=ROW(D92)-ROW(D$28)+1, _xlfn.XLOOKUP(D92,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"$f":"IF(NOT(D92=$D$168),$P$19*(O92/$O$19),0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"}]
[null,null,66,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,{"$f":"IFERROR(IF(D93=$D$157,Y93,IF(D93=$D$162,Z93,X93)),\"Data ontbreekt!\")","v":"-"},{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D93<>$D$168, IF(MATCH(D93,D$28:D93,0)=ROW(D93)-ROW(D$28)+1, _xlfn.XLOOKUP(D93,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"$f":"AB93+AA93","v":{"v":0,"d":"0.00"}}]
[null,null,67,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D94<>$D$168, IF(MATCH(D94,D$28:D94,0)=ROW(D94)-ROW(D$28)+1, _xlfn.XLOOKUP(D94,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,68,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D95<>$D$168, IF(MATCH(D95,D$28:D95,0)=ROW(D95)-ROW(D$28)+1, _xlfn.XLOOKUP(D95,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,69,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D96<>$D$168, IF(MATCH(D96,D$28:D96,0)=ROW(D96)-ROW(D$28)+1, _xlfn.XLOOKUP(D96,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,70,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D97<>$D$168, IF(MATCH(D97,D$28:D97,0)=ROW(D97)-ROW(D$28)+1, _xlfn.XLOOKUP(D97,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,71,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D98<>$D$168, IF(MATCH(D98,D$28:D98,0)=ROW(D98)-ROW(D$28)+1, _xlfn.XLOOKUP(D98,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,72,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D99<>$D$168, IF(MATCH(D99,D$28:D99,0)=ROW(D99)-ROW(D$28)+1, _xlfn.XLOOKUP(D99,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,73,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D100<>$D$168, IF(MATCH(D100,D$28:D100,0)=ROW(D100)-ROW(D$28)+1, _xlfn.XLOOKUP(D100,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,74,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D101<>$D$168, IF(MATCH(D101,D$28:D101,0)=ROW(D101)-ROW(D$28)+1, _xlfn.XLOOKUP(D101,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,75,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D102<>$D$168, IF(MATCH(D102,D$28:D102,0)=ROW(D102)-ROW(D$28)+1, _xlfn.XLOOKUP(D102,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,76,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D103<>$D$168, IF(MATCH(D103,D$28:D103,0)=ROW(D103)-ROW(D$28)+1, _xlfn.XLOOKUP(D103,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,77,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D104<>$D$168, IF(MATCH(D104,D$28:D104,0)=ROW(D104)-ROW(D$28)+1, _xlfn.XLOOKUP(D104,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,78,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D105<>$D$168, IF(MATCH(D105,D$28:D105,0)=ROW(D105)-ROW(D$28)+1, _xlfn.XLOOKUP(D105,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,79,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D106<>$D$168, IF(MATCH(D106,D$28:D106,0)=ROW(D106)-ROW(D$28)+1, _xlfn.XLOOKUP(D106,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,80,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D107<>$D$168, IF(MATCH(D107,D$28:D107,0)=ROW(D107)-ROW(D$28)+1, _xlfn.XLOOKUP(D107,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,81,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D108<>$D$168, IF(MATCH(D108,D$28:D108,0)=ROW(D108)-ROW(D$28)+1, _xlfn.XLOOKUP(D108,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,82,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D109<>$D$168, IF(MATCH(D109,D$28:D109,0)=ROW(D109)-ROW(D$28)+1, _xlfn.XLOOKUP(D109,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,83,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D110<>$D$168, IF(MATCH(D110,D$28:D110,0)=ROW(D110)-ROW(D$28)+1, _xlfn.XLOOKUP(D110,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,84,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D111<>$D$168, IF(MATCH(D111,D$28:D111,0)=ROW(D111)-ROW(D$28)+1, _xlfn.XLOOKUP(D111,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,85,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D112<>$D$168, IF(MATCH(D112,D$28:D112,0)=ROW(D112)-ROW(D$28)+1, _xlfn.XLOOKUP(D112,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,86,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D113<>$D$168, IF(MATCH(D113,D$28:D113,0)=ROW(D113)-ROW(D$28)+1, _xlfn.XLOOKUP(D113,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,87,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D114<>$D$168, IF(MATCH(D114,D$28:D114,0)=ROW(D114)-ROW(D$28)+1, _xlfn.XLOOKUP(D114,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,88,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D115<>$D$168, IF(MATCH(D115,D$28:D115,0)=ROW(D115)-ROW(D$28)+1, _xlfn.XLOOKUP(D115,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,89,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D116<>$D$168, IF(MATCH(D116,D$28:D116,0)=ROW(D116)-ROW(D$28)+1, _xlfn.XLOOKUP(D116,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,90,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D117<>$D$168, IF(MATCH(D117,D$28:D117,0)=ROW(D117)-ROW(D$28)+1, _xlfn.XLOOKUP(D117,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,91,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D118<>$D$168, IF(MATCH(D118,D$28:D118,0)=ROW(D118)-ROW(D$28)+1, _xlfn.XLOOKUP(D118,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,92,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D119<>$D$168, IF(MATCH(D119,D$28:D119,0)=ROW(D119)-ROW(D$28)+1, _xlfn.XLOOKUP(D119,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,93,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D120<>$D$168, IF(MATCH(D120,D$28:D120,0)=ROW(D120)-ROW(D$28)+1, _xlfn.XLOOKUP(D120,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,94,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D121<>$D$168, IF(MATCH(D121,D$28:D121,0)=ROW(D121)-ROW(D$28)+1, _xlfn.XLOOKUP(D121,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,95,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D122<>$D$168, IF(MATCH(D122,D$28:D122,0)=ROW(D122)-ROW(D$28)+1, _xlfn.XLOOKUP(D122,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,96,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D123<>$D$168, IF(MATCH(D123,D$28:D123,0)=ROW(D123)-ROW(D$28)+1, _xlfn.XLOOKUP(D123,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,97,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D124<>$D$168, IF(MATCH(D124,D$28:D124,0)=ROW(D124)-ROW(D$28)+1, _xlfn.XLOOKUP(D124,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,98,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D125<>$D$168, IF(MATCH(D125,D$28:D125,0)=ROW(D125)-ROW(D$28)+1, _xlfn.XLOOKUP(D125,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,99,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D126<>$D$168, IF(MATCH(D126,D$28:D126,0)=ROW(D126)-ROW(D$28)+1, _xlfn.XLOOKUP(D126,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,100,"Voeg functie toe:",null,"",{"$nulls":4},"",null,null,"",0,0,0,null,null,"-",{"$nulls":3},"-",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"IF(D127<>$D$168, IF(MATCH(D127,D$28:D127,0)=ROW(D127)-ROW(D$28)+1, _xlfn.XLOOKUP(D127,$E$28:$E$127,$P$28:$P$127,0,0), 0), 0)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"< Klik hier voor meer invoervelden.",null,null,{"$f":"IF(AND(OR(D128=$D$157,D128=$D$168),E128=\"\"),\"!!!\",\"\")","v":""},{"$nulls":4},{"$f":"IF(OR(AND(E128=$D$173,J128>=60),AND(E128=$D$174,J128<60),AND(E128=$D$175,J128>=80),AND(E128=$D$176,J128<80)),\"!\",\"\")","v":""}]
[null,null,"Foutmeldingen:"]
[null,null,{"$f":"IF(COUNTIF(K28:K128,\"!\")>0,\"!\",\"\")","v":""},{"$f":"IF($C$130=\"!\",\"Let op! Eén of meerdere ingevoerde GO's voldoen niet aan de criteria. Let goed op de ingevoerde woonfunctie.\",\"\")","v":""}]
[null,null,{"$f":"IF(COUNTIF(F28:F128,\"!!\")>0,\"!!\",\"\")","v":""},{"$f":"IF($C$131=\"!!\",\"Let op dat bij alle functies 'wonen' of 'gemeenschappelijke ruimte' een subfunctie wordt ingevuld\",\"\")","v":""}]
[null,null,{"$f":"IF(AND(SUM(Q28:Q127)<50,SUM(Q28:Q127)),\"!!!\",\"\")","v":""},{"$f":"IF($C$132=\"!!!\",\"Let op! Voor gebouwen kleiner dan 50 m2 geldt géén MPG eis\",\"\")","v":""}]
[]
[null,{"$f":"\"© W/E adviseurs, Utrecht/Eindhoven\"","v":"© W/E adviseurs, Utrecht/Eindhoven"}]
[]
[]
[]
[null,null,"Ondersteunende data en informatie"]
[]
[{"$nulls":3},"Informatie"]
[{"$nulls":3},"Alle berekeningen worden gedaan op basis van de aangepaste Omgevingsregeling en Bbl-besluit van datum 02-04-2025. Deze kunnen via onderstaande links bekeken worden. "]
[null,null,"a","Omgevingsregeling dd 02-04-2025"]
[null,null,"b","Bbl-besluit dd 02-04-2025"]
[]
[null,null,1,"Meer gebruiksfuncties kunnen worden toegevoegd door de rijen uit te klappen."]
[null,null,2,"Rood gearceerde cellen moeten worden ingevuld. Deze lichten automatisch op als een functie wordt geselecteerd."]
[null,null,3,"Gemeenschappelijke ruimtes kunnen automatisch  worden verdeeld naar rato over alle gebruiksfuncties, of worden toegewezen aan maximaal één gebruiksfunctie"]
[null,null,4,"Een gemeenschappelijke ruimte kan niet worden toegekend aan een andere gemeenschappelijke ruimte."]
[null,null,5,"Een gemeenschappelijke ruimte kan niet worden toegekend aan een functie zonder eis."]
[null,null,6,"Een gemeenschappelijke ruimte wordt toegewezen aan de éérste (bovenste) gebruiksfunctie, als die gebruiksfunctie meerdere keren voorkomt."]
[null,null,7,"Bij kantoorfuncties moet het verliesoppervlak van het hele gebouw worden ingevoerd, niet alleen het deel dat direct betrekking heeft op de ingevoerde ruimte."]
[null,null,8,"Een subfunctie kan worden verwijderd met Delete."]
[]
[{"$nulls":3},"Tabel 1"]
[null,null,"Nr.","Gebruiksfunctie","MPG eis","specificeren?","Notitie"]
[null,null,1,"Voeg functie toe:","-",0,{"$nulls":17},"Voeg functie toe:",null,"Wordt naar verwezen in formules: term moet in deze regel staan"]
[null,null,2,"Woon",{"v":1.6,"d":"1.60"},1,"tenzij klein gebruiksoppervlakte, zie Tabel 2 en 4",{"$nulls":16},"Woon",null,"Wordt naar verwezen in formules: term moet in deze regel staan"]
[null,null,3,"Bijeenkomst",1.85,0]
[null,null,4,"Cel",1.85,0]
[null,null,5,"Gezondheidzorg",1.85,0]
[null,null,6,"Industrie",1.85,0]
[null,null,7,"Kantoor",1.55,0,"tenzij afwijkende vormfactor, zie Tabel 3",{"$nulls":16},"Kantoor",null,"Wordt naar verwezen in formules: term moet in deze regel staan"]
[null,null,8,"Logies",1.85,0]
[null,null,9,"Onderwijs",1.85,0]
[null,null,10,"Sport",1.85,0]
[null,null,11,"Winkel",1.85,0]
[null,null,12,"Overige gebruiksfunctie",{"v":1.8,"d":"1.80"},0]
[null,null,14,"Gemeenschappelijke Ruimte","GO verdeeld",1,{"$nulls":17},"Gemeenschappelijke Ruimte",null,"Wordt naar verwezen in formules: term moet in deze regel staan"]
[null,null,15,"Bouwwerk geen gebouw zijnde","geen eis",0,"kan niet gekozen worden want heeft geen eis (buiten beschouwing)",{"$nulls":16},"Bouwwerk geen gebouw zijnde",null,"Wordt naar verwezen in formules: term moet in deze regel staan"]
[]
[{"$nulls":3},"Tabel 2"]
[null,null,"Nr.","Wonen","MPG eis","grens m2"]
[null,null,"a1",{"$f":"\"Woongebouw, <\"&$F173&\"m2\"","v":"Woongebouw, <60m2"},{"v":1.6,"d":"1.60"},{"v":60,"d":"60.0"},"Afwijkende MPG is van toepassing. Zie formule omgevingsregeling. Bepalen met formule Omgevingsregeling art. 5.32b(a)",{"$nulls":16},"Grenswaarde woongebouw kleiner dan"]
[null,null,"a2",{"$f":"\"Woongebouw,  ≥ \"&$F174& \"m2\"","v":"Woongebouw,  ≥ 60m2"},{"v":1.6,"d":"1.60"},{"v":60,"d":"60.0"},{"$nulls":17},"Grenswaarde woongebouw groter of gelijk aan"]
[null,null,"c1",{"$f":"\"Andere Woonfunctie, <\"&$F175&\"m2\"","v":"Andere Woonfunctie, <80m2"},{"v":1.6,"d":"1.60"},{"v":80,"d":"80.0"},"Afwijkende MPG is van toepassing. Zie formule omgevingsregeling. Bepalen met formule Omgevingsregeling art. 5.32b(b)",{"$nulls":16},"Grenswaarde andere woonfunctie kleiner dan"]
[null,null,"c1",{"$f":"\"Andere Woonfunctie, ≥\"&$F176&\"m2\"","v":"Andere Woonfunctie, ≥80m2"},{"v":1.6,"d":"1.60"},{"v":80,"d":"80.0"},{"$nulls":17},"Grenswaarde andere woonfunctie groter of gelijk aan"]
[null,null,"b","Woonwagen","geen eis","grens m2","kan niet gekozen worden want heeft geen eis (buiten beschouwing)"]
[]
[]
[{"$nulls":3},"Kantoorfunctie:"]
[{"$nulls":3},"MPG eis is afhankelijk van de vormfactor (m.a.w. de compactheid van het gebouw):"]
[{"$nulls":3},"Compactheid","MPG eis"]
[{"$nulls":3},"<2,5",1.55]
[{"$nulls":3},">2,5","1,55+0,75*(As/Ag-2,5)",null,"Afwijkende MPG is van toepassing. Zie formule omgevingsregeling. Bepalen met formule Omgevingsregeling art. 5.32b(c)"]
[]
[{"$nulls":3},"Tabel 3"]
[null,null,"Nr.","Voorbeeld","g.o.gebouw [m2]",null,"Als;gebouw [m2]","Compactheid",null,"MPG eis"]
[null,null,1,"kantoorgebouw 1",100,null,120,{"$f":"G188/E188","v":{"v":1.2,"d":"1.20"}},null,{"$f":"IF(H188<2.5,$E$183,1.55+0.75*(H188-2.5))","v":1.55}]
[null,null,2,"kantoorgebouw 2",500,null,1500,{"$f":"G189/E189","v":{"v":3,"d":"3.00"}},null,{"$f":"IF(H189<2.5,$E$183,1.55+0.75*(H189-2.5))","v":{"v":1.925,"d":"1.93"}}]
[null,null,3,"Kantoorgebouw 3",1000,null,600,{"$f":"G190/E190","v":{"v":0.6,"d":"0.60"}},null,1.55]
[null,null,4,"Kantoorgebouw 4",1000,null,2600,{"$f":"G191/E191","v":{"v":2.6,"d":"2.60"}},null,{"v":1.625,"d":"1.63"}]
[]
[{"$nulls":3},"Woonfunctie:"]
[{"$nulls":3},"MPG eis is afhankelijk van de gebruiksoppervlakte:"]
[{"$nulls":3},"Subfunctie","MPG eis"]
[{"$nulls":3},"Woongebouw, <60m2","1,6 + 0,015 * (60 - g.o.functie)"]
[{"$nulls":3},"Andere Woonfunctie, <80m2","1,6 + 0,015 * (60 - g.o.functie)"]
[]
[]
[{"$nulls":3},"Tabel 4"]
[null,null,"Nr.","Voorbeeld","g.o.gebouw [m2]",null,"MPG eis"]
[null,null,1,"Woongebouw 1",50,null,{"$f":"1.6+0.015*(60-E202)","v":1.75}]
[null,null,2,"Woongebouw 2",70,null,{"v":1.6,"d":"1.60"}]
[null,null,3,"Andere Woonfunctie 1",70,null,{"$f":"1.6+0.015*(80-E204)","v":1.75}]
[null,null,4,"Andere Woonfunctie 2",100,null,{"v":1.6,"d":"1.60"}]
[]
["verbergen",null,null,"Tabel 5 (verbergen in eindversie)"]
["verbergen",null,null,{"$f":"$D$157","v":"Woon"},{"$f":"$D$168","v":"Gemeenschappelijke Ruimte"},null,"uitsluiten",null,"hoe GR verdelen?"]
["verbergen",null,0,"Woongebouw, <60m2","Verdeel naar rato GO",null,"Voeg functie toe:",null,{"$f":"_xlfn.XLOOKUP($G$210,$D$28:$D$127,$E$28:$E$127,,0)","v":{"$error":"#N/A"}},{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER($E$28:$E$127, COUNTIF($D$209:$D$213, $E$28:$E$127)=0,\"\"))","v":0}]
["verbergen",null,1,"Woongebouw,  ≥ 60m2",{"$f":"_xlfn.UNIQUE(_xlfn._xlws.FILTER($D$28:$D$127, COUNTIF($G$209:$G$210, $D$28:$D$127)=0))","v":"Kantoor"},null,"Gemeenschappelijke Ruimte",null,null,"Verdeel naar rato GO"]
["verbergen",null,2,"Andere Woonfunctie, <80m2"]
["verbergen",null,3,"Andere Woonfunctie, ≥80m2"]
["verbergen",null,4]
["verbergen",null,5]
["verbergen",null,6]
["verbergen",null,7]
["verbergen",null,8]
["verbergen",null,9]
["verbergen",null,10]
["verbergen",null,11]