{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Titel","Toelichting","Vragenlijst","Productenlijst","Resultaat","hulpblad","Exploitatiebijdrage"],"not_rendered":{"charts":0,"images":226,"macros":1,"external_links":0,"defined_names":20,"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":"Titel","index":0,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Rekenmodel "]
[null,null,"behorende bij de Regeling plankosten exploitatieplan versie 2023"]
[]
[]
[null,null,"2023-04-06"]

{"sheet":"Toelichting","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Vragenlijst","index":2,"n_rows":353,"n_cols":24,"rows_kept":353,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"deze kolommen worden verborgen, en zijn niet opvraagbaar"]
[null,"Regeling plankosten exploitatieplan 2023"]
[null,"Vragenlijst "]
[null,null,null,"Datum",{"$f":"TODAY()","v":"2023-08-15"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hulp tabel invloedsfctor omvang gebied invloedsfactor A"]
[null,null,null,"Gemeente","…,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1ste deel"]
[null,null,null,"Projectnaam","….",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",{"$f":"0.9/15","v":6.0000000000000005E-2}]
[null,null,null,"Projectnummer","….",null,null,null,null,null,null,null,null,"Hulp tabel looptijd",null,null,null,"Invloedsfactor A",null,null,null,"b",-0.9]
[null,null,null,"Datum prijspeil","2023-01-01",null,null,null,null,null,null,null,null,{"$f":"IF(W59<=30%,2,N14)","v":2},null,null,null,{"$f":"IF($K$25<=15,K25*W11+W12,R14)","v":-0.9}]
[null,null,null,"Looptijd project in jaren",{"$f":"IF(G20>0,(G20+N13),0)","v":0},null,null,null,null,null,null,null,null,{"$f":"IF(W59>30%,(IF(W59<=50%,3,N15)),N15)","v":0},null,null,null,{"$f":"IF(K25>15,(IF(K25<=50,K25*W15+W16,R15)),R15)","v":0},null,null,null,"2de deel"]
[null,null,null,"Aantal werkweken per jaar",42,null,null,null,null,null,null,null,null,{"$f":"IF(W59>50%,4,0)","v":0},null,null,null,{"$f":"IF(K25>50,(IF(K25<=70,K25*W20+W21,R16)),R16)","v":0},null,null,null,"a",{"$f":"0.5/(50-15)","v":1.4285714285714285E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K25>70,(IF(K25<=150,K25*W24+W25,R17)),R17)","v":0},null,null,null,"b",{"$f":"-W15*15","v":-0.21428571428571427}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K25>150,K25*W28+X22,0)","v":0}]
[null,null,"A","Algemeen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3de deel"]
[]
[null,null,1,"Wat is de looptijd van het project vanaf het moment van vaststellen van het ruimtelijk besluit ?",null,null,null,"jaren",null,null,{"$f":"+G20","v":0},null,null,null,null,null,null,null,null,null,null,"a",{"$f":"(0.65-0.5)/(70-50)","v":7.5000000000000015E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",{"$f":"(0.5-(W20*50))","v":0.12499999999999994}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4de deel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",{"$f":"(0.8-0.65)/(150-70)","v":1.8750000000000004E-3}]
[null,null,2,"Wat is de grootte van het exploitatiegebied in m2 (netto) ?",null,null,null,"m2",null,null,{"$f":"+G25/10000","v":0},"ha",null,null,null,null,null,null,null,null,null,"b",{"$f":"(0.65-(W24*70))","v":0.51875000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"invloedsfactor B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5de deel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"a",0]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B"]
[null,null,3,"Wat voor een locatie is het exploitatiegebied?",null,null,null,null,null,null,false,false,false,{"$f":"IF(K33=TRUE,1,0)","v":0},null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,false,false,null,{"$f":"IF(L33=TRUE,1,0)","v":0},null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M33=TRUE,1,0)","v":0},null,null,null,0.25]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N33:N37)>1,\"fout\",\"\")","v":""},null,null,null,null,{"$f":"IF(K34=TRUE,1,0)","v":0},null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L34=TRUE,1,0)","v":0},null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"invloedsfactor C"]
[null,null,4,"Betreft het een herstructureringsopgave ?",null,null,null,null,null,null,false,false,null,{"$f":"IF(K40=TRUE,1,0)","v":0},null,null,null,1.5]
[]
[]
[null,null,"B","Inbreng en verwerving"]
[]
[null,null,5,"Uit hoeveel kadastrale percelen bestaat het exploitatieplan en hoeveel daarvan zijn onbebouwd en bebouwd?",null,null,null,"totaal",null,null,null,{"$f":"+G45","v":0}]
[null,null,"a","aantal onbebouwde percelen",null,"a",null,"stuks",null,null,{"$f":"G46","v":0}]
[null,null,"b","aantal bebouwde percelen",null,"b",null,"stuks",null,null,{"$f":"G47","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(L48<>L45,\"fout\",\"\")","v":""},null,null,null,{"$f":"SUM(K46:K47)","v":0},null,{"$f":"IF(L48>0,1,0)","v":0}]
[null,null,6,"Hoeveel onroerende zaken is de gemeente van plan daadwerkelijk te verwerven ?",null,null,null,"totaal",null,null,null,{"$f":"+G49","v":0},null,{"$f":"IF(G49>0,1,0)","v":0}]
[null,null,"a","waarvan onbebouwde percelen",null,"a",null,"stuks",null,null,{"$f":"+G50","v":0},null,null,null,null,null,null,null,null,null,"A","A. Omvang exploitatiegebied",{"$f":"R13","v":-0.9}]
[null,null,"b","waarvan percelen met woningen",null,"b",null,"stuks",null,null,{"$f":"+G51","v":0},null,null,null,null,null,null,null,null,null,"B","B. Ligging",{"$f":"N33*R33+N34*R34+N35*R35+N36*R36+N37*R37","v":0}]
[null,null,"c","waarvan percelen met (agrarische) bedrijven/winkels/kantoren (inclusief bijbehorende bedrijfswoning)",null,"c",null,"stuks",null,null,{"$f":"+G52","v":0},null,null,null,null,null,null,null,null,null,"C","C. Herstructurering",{"$f":"IF(K40=TRUE,150%,0)","v":0}]
[null,null,"d","waarvan percelen met bijzondere objecten",null,"d",null,"stuks",null,null,{"$f":"+G53","v":0},null,null,null,null,null,null,null,null,null,"D","D. Verwervingsituatie",{"$f":"IF(K59>0,K59*R59,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(L54<>L49,\"fout\",\"\")","v":""},null,null,null,{"$f":"SUM(K50:K53)","v":0},null,null,null,null,null,null,null,null,"E","E. Programma",{"$f":"N66*R66+N67*R67+N68*R68+N69*R69+N70*R70","v":0}]
[null,null,7,"Van hoeveel huur(pacht)ontbindingen is sprake ?",null,null,null,"stuks",null,null,{"$f":"+G55","v":0},null,null,null,null,null,null,null,null,null,"F","F. Onderzoeken",{"$f":"U92","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G","G. Bodemgesteldheid",{"$f":"N111*R111+N112*R112+N110*R110","v":0}]
[null,null,8,"Indien er met een onteigeningsplan wordt gewerkt (administratieve procedure) "]
[null,null,"a","voor hoeveel onroerende zaken ?",{"$f":"IF(G58>SUM(G50:G53),\"fout\",\"\")","v":""},"a",null,"stuks",null,null,{"$f":"+G58","v":0},null,null,null,null,null,null,"invloedsfactor D"]
[null,null,"b","in hoeveel van die gevallen komt het tot een gerechtelijke procedure ?",{"$f":"IF(G59>G58,\"fout\",\"\")","v":""},"b",null,"stuks",null,null,{"$f":"+G59","v":0},null,null,null,null,null,null,0.1,null,null,"A tm F","Complexiteitsfactor",{"$f":"(SUM(W50:W55)/6)","v":-0.15}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+K59+K58","v":0}]
[null,null,9,"Wordt of is een voorkeursrecht gevestigd (Wvg) ?",null,null,null,null,null,null,false,false,null,{"$f":"IF(K61=TRUE,1,0)","v":0},null,null,null,null,null,null,"B, C, E en  F","CF tbv ruimtelijke ordening",{"$f":"(W51+W52+W54+W55)/4","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"E"]
[null,null,"C","Beoogde programma",null,null,null,null,null,null,null,null,null,null,null,null,null,"Invloedsfactor E",null,null,null,"Omrekentabel m2 /woningen",100]
[]
[null,null,10,"Wat is het beoogde programma volgens het ruimtelijk besluit ?","woningen",null,null,"aantal",null,null,null,null,null,{"$f":"IF(G66>0,1,0)","v":0},null,null,null,{"$f":"IF(N71>1,0.1,0)","v":0}]
[null,null,null,null,"bedrijvigheid",null,null,"m2 uitgeefbaar",null,null,null,null,null,{"$f":"IF(G67>0,1,0)","v":0},null,null,null,{"$f":"IF(N71>1,0.1,-0.25)","v":-0.25},null,null,"B tm F","CF tbv civiele techniek",{"$f":"(SUM(W51:W55)/5)","v":0}]
[null,null,null,null,"commercieel/retail",null,null,"m2 bvo",null,null,null,null,null,{"$f":"IF(G68>0,1,0)","v":0},null,null,null,0.1]
[null,null,null,null,"maatschappelijk",null,null,"m2 bvo",null,null,null,null,null,{"$f":"IF(G69>0,1,0)","v":0},null,null,null,0.25]
[null,null,null,null,"recreatie",null,null,"m2",null,null,null,null,null,{"$f":"IF(G70>0,1,0)","v":0},null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N66:N70)","v":0}]
[]
[]
[null,null,11,"Wat is de beoogde verdeling tussen uitgeefbaar en openbaar gebied ?",null,null,null,"m2 uitgeefbaar",{"$f":"+G74/G25","v":{"$error":"#DIV/0!"}},null,{"$f":"+G74/($K$25*10000)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(K75>40%,K75/40%,1)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"+IF(K76<>K25*10000,\"fout\",\"\")","v":""},null,null,"m2 openbaar",{"$f":"+G75/G25","v":{"$error":"#DIV/0!"}},null,{"$f":"+G75/($K$25*10000)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+G74+G75","v":0},"m2"]
[null,null,"D","Stedenbouwkundige planvorming"]
[]
[null,null,12,"Wordt er een prijsvraag georganiseerd ?",null,null,null,null,null,null,false,false]
[null,null,13,"Worden de volgende produkten opgesteld ?",null,null,null,null,null,null,false,null,null,{"$f":"IF(K80=TRUE,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,false,null,null,{"$f":"IF(K81=TRUE,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,false,null,null,{"$f":"IF(K82=TRUE,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,false,null,null,{"$f":"IF(K83=TRUE,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,false,null,null,{"$f":"IF(K84=TRUE,1,0)","v":0}]
[]
[null,null,"E","Onderzoeken",null,null,null,null,null,null,null,null,null,null,null,null,null,"Invloedsfactor F","Hulptabel voor invloedsfactor F"]
[]
[null,null,14,"Zijn de volgende onderzoeken nodig?",null,null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,false,null,null,{"$f":"IF(K89=TRUE,1,0)","v":0},null,null,null,0.5,{"$f":"N89*R89","v":0}]
[null,null,null,null,null,null,null,null,null,null,false,null,null,{"$f":"IF(K90=TRUE,1,0)","v":0},null,null,null,0.4,{"$f":"N90*R90","v":0}]
[null,null,null,null,null,null,null,null,null,null,false,null,null,{"$f":"IF(K91=TRUE,1,0)","v":0},null,null,null,0.3,{"$f":"N91*R91","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K168=TRUE,1,0)","v":0},null,null,null,0.2,{"$f":"N92*R92","v":0},null,{"$f":"MAX(S89:S92)","v":0}]
[]
[null,null,"F","Ruimtelijke ordening procedures "]
[]
[null,null,15,"Wordt het ruimtelijk besluit opgesteld via een globaal uit te werken plan, "]
[null,null,null,"een 'omgevingsvergunning in afwijking van het bestemmingsplan' of een projectuitvoeringsbesluit ?",null,null,null,null,{"$f":"IF(SUM(N103+N101+N97)<1,\"fout\",\"\")","v":"fout"},null,false,false,null,{"$f":"IF(K97=TRUE,1,0)","v":0}]
[]
[null,null,"a","Indien sprake is van een globaal uit te werken plan, hoeveel uitwerkingsplannen verwacht u?      ",null,null,null,"aantal",null,null,null,null,null,{"$f":"G99","v":0}]
[]
[null,null,16,"Of wordt het ruimtelijk besluit herzien via een gedetailleerd bestemmingsplan ?",null,null,null,null,{"$f":"IF((N97+N101)>1,\"fout\",\"\")","v":""},null,false,false,null,{"$f":"IF(K101=TRUE,1,0)","v":0}]
[]
[null,null,17,"Of kan gebruik gemaakt worden van een wijziging van het ruimtelijk besluit ?",null,null,null,null,{"$f":"IF(SUM(N101+N97+N103)>=2,\"fout\",\"\")","v":""},null,false,false,null,{"$f":"IF(K103=TRUE,1,0)","v":0}]
[]
[null,null,18,"Maakt dit exploitatieplan deel uit van een groter ruimtelijk besluit ? ",null,null,null,null,null,null,false,false,null,{"$f":"IF(K105=TRUE,1,0)","v":0}]
[null,null,null,"zo ja, wat is de verhouding in oppervlakte ten opzichte van dit ruimtelijk besluit ?",null,null,null,"% van het totale ruimtelijke besluit",null,null,null,null,null,{"$f":"G106/100","v":0},{"$f":"K25/(N106)","v":{"$error":"#DIV/0!"}},"grootte bp ha"]
[null,null,null,null,null,null,null,{"$f":"IF(N106>1,\"fout\",\"\")","v":""}]
[null,null,"G","Civiele en cultuurtechniek",null,null,null,null,null,null,null,null,null,null,null,null,null,"Invloedsfactor G"]
[]
[null,null,19,"Wat is de (te verwachten) bodemgesteldheid in het gebied?",null,null,null,null,null,null,false,false,false,{"$f":"IF(K110=TRUE,1,0)","v":0},null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L110=TRUE,1,0)","v":0},null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M110=TRUE,1,0)","v":0},null,null,null,0]
[]
[]
[]
[null,null,null,"Slopen"]
[]
[null,null,20,"Is sprake van sloop van onroerende zaken ?",null,null,null,null,null,null,false,false,null,{"$f":"IF(K118=TRUE,1,0)","v":0}]
[null,null,null,null,{"$f":"+IF(L118=TRUE,\"ga door naar vraag 23\",\"\")","v":""}]
[null,null,"a","Zo ja, hoeveel m3 moet er gesloopt worden ?",null,null,null,"m3",null,null,null,null,null,{"$f":"+G120","v":0}]
[]
[null,null,"b","Wat voor een soort te slopen onroerende zaken zijn het?  Het gaat hoofdzakelijk om:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invloedsfactor ",null,{"$f":"+AVERAGE(Q124,(S124))","v":0}]
[null,null,null,"Meerdere antwoorden zijn mogelijk",null,null,null,"%",null,null,false,{"$f":"+G126/100","v":0},false,{"$f":"+G124/100","v":0},null,{"$f":"IF(K124=TRUE,0,0)","v":0},{"$f":"+P124*L124","v":0},{"$f":"IF(M124=TRUE,-1,0)","v":0},{"$f":"+R124*N124","v":0}]
[null,null,null,null,{"$f":"IF(AND(M124=FALSE,N124>0),\"aanzetten \",\"\")","v":""},null,null,{"$f":"IF(AND(M124=TRUE,N124=0),\"% invullen\",\"\")","v":""},null,null,null,null,null,{"$f":"+N124+L124","v":0}]
[null,null,null,null,null,null,null,"%"]
[null,null,null,null,{"$f":"IF(AND(K124=FALSE,L124>0),\"aanzetten \",\"\")","v":""},null,null,{"$f":"IF(AND(K124=TRUE,L124=0),\"% invullen\",\"\")","v":""}]
[]
[]
[null,null,21,"Is er sprake van asbest in de te slopen onroerende zaken?",{"$f":"IF(L130=TRUE,\"ga door naar vraag 22\",\"\")","v":""},null,null,{"$f":"IF(AND(K130=FALSE,N131>0),\"fout\",\"\")","v":""},null,null,false,false,null,{"$f":"+IF(K130=TRUE,1,0)","v":0}]
[null,null,"a","Zo ja, in hoeveel procent van het totaal aantal te slopen m3 is sprake van asbest ? ",null,null,null,"%",{"$f":"IF(AND(K130=TRUE,N131>100%),\"fout\",\" \")","v":" "},null,null,null,null,{"$f":"+G131/100","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND(N130=1,N131<=0),\"percentage invullen \",\"\")","v":""}]
[null,null,22,"Op welke wijze wordt het slopen aanbesteed ?",null,null,null,null,null,null,null,null,null,null,null,"Invloedsfactor ",null,{"$f":"+AVERAGE(Q134:Q140,(S134:S136))","v":0}]
[null,null,null,"Meerdere antwoorden zijn mogelijk",null,"%",null,null,"%",null,false,{"$f":"+E134/100","v":0},false,{"$f":"+H134/100","v":0},null,{"$f":"IF(K134=TRUE,0.25,0)","v":0},{"$f":"P134*L134","v":0},{"$f":"IF(M134=TRUE,3,0)","v":0},{"$f":"R134*N134","v":0}]
[null,null,null,{"$f":"IF(AND(K134=FALSE,L134>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(K134=TRUE,L134=0),\"% invullen\",\"\")","v":""},null,{"$f":"IF(AND(M134=FALSE,N134>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(M134=TRUE,N134=0),\"% invullen\",\"\")","v":""}]
[null,null,null,null,null,"%",null,null,"%",null,false,{"$f":"+E136/100","v":0},false,{"$f":"+H136/100","v":0},null,{"$f":"IF(K136=TRUE,0,0)","v":0},{"$f":"P136*L136","v":0},{"$f":"IF(M136=TRUE,3,0)","v":0},{"$f":"R136*N136","v":0}]
[null,null,null,{"$f":"IF(AND(K136=FALSE,L136>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(K136=TRUE,L136=0),\"% invullen\",\"\")","v":""},null,{"$f":"IF(AND(M136=FALSE,N136>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(M136=TRUE,N136=0),\"% invullen\",\"\")","v":""}]
[null,null,null,null,null,"%",null,null,"%",null,false,{"$f":"+E138/100","v":0},false,{"$f":"+H138/100","v":0},null,{"$f":"IF(K138=TRUE,0,0)","v":0},{"$f":"P138*L138","v":0}]
[null,null,null,{"$f":"IF(AND(K138=FALSE,L138>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(K138=TRUE,L138=0),\"% invullen\",\"\")","v":""},null,{"$f":"IF(AND(M138=FALSE,N138>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(M138=TRUE,N138=0),\"% invullen\",\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(K140=FALSE,L140>0),\"afvinken \",\"\")","v":""},{"$f":"+IF(AND(K118=TRUE,N140<>1),\"fout, totaal moet 100% zijn\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"+N136+N134+L134+L136+L138+N138","v":0},null,{"$f":"IF(M138=TRUE,1,0)","v":0},{"$f":"P140*N138","v":0}]
[null,null,null,null,{"$f":"IF(AND(K140=TRUE,L140=0),\"% aangeven\",\"\")","v":""}]
[]
[null,null,null,"Ophogen/voorbelasten"]
[]
[null,null,23,"Is sprake van ophoging danwel voorbelasting?",{"$f":"IF(N145=0,\" ga door naar vraag 24\",\" \")","v":" ga door naar vraag 24"},null,null,null,null,null,false,false,null,{"$f":"IF(K145=TRUE,1,0)","v":0}]
[null,null,null,{"$f":"IF(AND(N112=1,N145=1),\"Klopt dit? De bodemgesteldheid is goed\",\"\")","v":""}]
[null,null,"a","Wordt er integraal of partieel opgehoogd?",null,null,null,null,{"$f":"IF(AND(N145=1,SUM(N147:N148)<1),\"fout\",\"\")","v":""},null,false,false,null,{"$f":"IF(K147=TRUE,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L147=TRUE,1,0)","v":0}]
[]
[null,null,"b","In hoeveel deelplannen/fasen wordt er opgehoogd/voorbelast?",null,"b",null,"deelplan/fase",null,null,null,null,null,{"$f":"G150","v":0}]
[null,null,"c","Wat is de gemiddelde te verwachten zettingstijd?",null,"c",null,"jaar",null,null,null,null,null,{"$f":"G151","v":0}]
[null,null,"d","Wat is de gemiddelde hoogte van de voorbelasting?",null,"d",null,"m1",null,null,null,null,null,{"$f":"G152","v":0}]
[]
[]
[null,null,null,"Bouw-en woonrijpmaken"]
[]
[null,null,24,"Is sprake van bouw-en of woonrijpmaken ?",{"$f":"IF(L157=TRUE,\"ga door naar vraag 26\",\" \")","v":" "},null,null,null,null,null,false,false,null,{"$f":"IF(K157=TRUE,1,0)","v":0}]
[]
[null,null,25,"Op welke wijze wordt het bouw-en woonrijpmaken aanbesteed ? ",null,null,null,null,null,null,null,null,null,null,null,null,"Invloedsfactor ",null,{"$f":"+AVERAGE(R160:R164,(T160:T164))","v":0}]
[null,null,null,"Meerdere antwoorden zijn mogelijk",null,"%",null,null,"%",null,false,{"$f":"+E160/100","v":0},false,{"$f":"+H160/100","v":0},null,null,{"$f":"IF(K160=TRUE,0.25,0)","v":0},{"$f":"Q160*L160","v":0},{"$f":"IF(M160=TRUE,3,0)","v":0},{"$f":"S160*N160","v":0}]
[null,null,null,{"$f":"IF(AND(K160=FALSE,L160>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(K160=TRUE,L160=0),\"% invullen\",\"\")","v":""},null,{"$f":"IF(AND(M160=FALSE,N160>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(M160=TRUE,N160=0),\"% invullen\",\"\")","v":""}]
[null,null,null,null,null,"%",null,null,"%",null,false,{"$f":"+E162/100","v":0},false,{"$f":"+H162/100","v":0},null,null,{"$f":"IF(K162=TRUE,0,0)","v":0},{"$f":"Q162*L162","v":0},{"$f":"IF(M162=TRUE,3,0)","v":0},{"$f":"S162*N162","v":0}]
[null,null,null,{"$f":"IF(AND(K162=FALSE,L162>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(K162=TRUE,L162=0),\"% invullen\",\"\")","v":""},null,{"$f":"IF(AND(M162=FALSE,N162>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(M162=TRUE,N162=0),\"% invullen\",\"\")","v":""}]
[null,null,null,null,null,"%",null,null,"%",null,false,{"$f":"+E164/100","v":0},false,{"$f":"+H164/100","v":0},null,null,{"$f":"IF(K164=TRUE,0,0)","v":0},{"$f":"Q164*L164","v":0},{"$f":"IF(M164=TRUE,1,0)","v":0},{"$f":"S164*N164","v":0}]
[null,null,null,{"$f":"IF(AND(K164=FALSE,L164>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(K164=TRUE,L164=0),\"% invullen\",\"\")","v":""},null,{"$f":"IF(AND(M164=FALSE,N164>0),\"aanzetten \",\"\")","v":""},{"$f":"IF(AND(M164=TRUE,N164=0),\"% invullen\",\"\")","v":""}]
[null,null,null,{"$f":"IF(AND(K166=FALSE,L166>0),\"afvinken \",\"\")","v":""},null,null,{"$f":"+IF(AND(K157=TRUE,N166<>1),\"fout, totaal moet 100% zijn\",\"\")","v":""},null,null,null,null,null,null,{"$f":"+N164+L164+L162+L160+N160+N162","v":0}]
[null,null,null,null,{"$f":"IF(AND(K166=TRUE,L166=0),\"% aangeven\",\"\")","v":""}]
[null,null,26,"Is er sprake van bodemsanering ? ",null,null,null,{"$f":"IF(AND(K168=TRUE,M169>100),\"fout\",\" \")","v":" "},null,null,false,false,null,{"$f":"IF(K168=TRUE,1,0)","v":0}]
[null,null,"a","Zo ja, in hoeveel procent van het exploitatiegebied is sprake van bodemsanering ? ",null,null,null,"%",{"$f":"IF(AND(K168=FALSE,M169>0),\"fout\",\"\")","v":""},null,null,null,{"$f":"+G169","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,true]

{"sheet":"Productenlijst","index":3,"n_rows":114,"n_cols":30,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"Regeling plankosten exploitatieplan versie 2023",null,null,null,null,null,null,null,"Tarieven 2023 excl btw","€€/uur",null,"Tarieven 2023 excl btw",null,"€€/uur",null,"Complexiteitsfactor (A tm F)",null,null,{"$f":"(1+Vragenlijst!W59)","v":0.85},"Invloedsfactoren (IF):"]
[null,"Produkten/activiteitenlijst",null,null,null,null,null,null,null,"Verwerving/juridisch",142,null,"Civiel technisch projectleiden",null,142,null,"Complexiteitsfactor ruimtelijke ordening",null,null,{"$f":"1+Vragenlijst!W61","v":1},{"$f":"Vragenlijst!V50","v":"A. Omvang exploitatiegebied"},null,{"$f":"Vragenlijst!W50","v":-0.9}]
[null,null,null,null,null,null,null,null,null,"Stedenbouw",142,null,"Civiel technische ontwerpen",null,142,null,"Complexiteitsfactor civiele techniek",null,null,{"$f":"1+Vragenlijst!W67","v":1},{"$f":"Vragenlijst!V51","v":"B. Ligging"},null,{"$f":"Vragenlijst!W51","v":0}]
[null,"Datum",null,{"$f":"TODAY()","v":"2023-08-15"},null,null,null,null,null,"Ruimtelijke Ordening",142,null,"Bestekschrijven/calculeren",null,113,null,null,null,null,null,{"$f":"Vragenlijst!V52","v":"C. Herstructurering"},null,{"$f":"Vragenlijst!W52","v":0}]
[null,"Gemeente",null,{"$f":"Vragenlijst!E10","v":"…,"},null,null,null,null,null,"Civiele en Cultuurtechniek",142,null,"Tekenen",null,101,null,null,null,null,null,{"$f":"Vragenlijst!V53","v":"D. Verwervingsituatie"},null,{"$f":"Vragenlijst!W53","v":0}]
[null,"Projectnaam",null,{"$f":"Vragenlijst!E11","v":"…."},null,null,null,null,null,"Landmeten/Vastgoedinformatie",113,null,"Directievoeren",null,124,null,null,null,null,null,{"$f":"Vragenlijst!V54","v":"E. Programma"},null,{"$f":"Vragenlijst!W54","v":0}]
[null,"Projectnummer",null,{"$f":"Vragenlijst!E12","v":"…."},null,null,null,null,null,"Communicatie",124,null,"Toezichthouden",null,101,null,null,null,null,null,{"$f":"Vragenlijst!V55","v":"F. Onderzoeken"},null,{"$f":"Vragenlijst!W55","v":0}]
[null,"Datum prijspeil",null,{"$f":"Vragenlijst!E13","v":"2023-01-01"},null,null,null,null,null,"Projectmanagement",161,null,null,null,null,null,null,null,null,null,{"$f":"Vragenlijst!V56","v":"G. Bodemgesteldheid"},null,{"$f":"Vragenlijst!W56","v":0}]
[null,"Looptijd in jaren",null,{"$f":"+Vragenlijst!E14","v":0},null,null,null,null,null,"Projectmanagementassistentie",113]
[null,null,null,null,null,null,null,null,null,"Planeconomie",142]
[]
[null,null,"Produkt / Activiteit",null,null,null,null,null,null,"Aantal","Uren of bedrag ","Tarief",null,"IF ?","IF ","CF ?","CF",null,"Totaal in euro's",null,null,"Totaal in uren",null,null,null,null,null,null,null,"link vragenlijst"]
[null,null,null,"Verwerving",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T40)","v":0},null,null,{"$f":"SUM(W20:W40)","v":0}]
[]
[null,null,"1.1","Taxatie inbrengwaarde percelen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((S21+S22)<(4*K7),((4*K7)+S23+S24)*AB20,SUM(S21:S24))","v":0},null,null,{"$f":"IF((V21+V22)<4,(4+V23+V24)*AB20,SUM(V21:V24))","v":0},null,false,null,null,{"$f":"IF(Y20=TRUE,1,0)","v":0},null,{"$f":"IF(Vragenlijst!L48>0,TRUE,FALSE)","v":false}]
[null,null,null,null,"uur per onbebouwd perceel",null,null,null,null,{"$f":"Vragenlijst!K46","v":0},1,{"$f":"+K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q21*O21*L21*K21*J21*AB20","v":0},null,null,{"$f":"AB20*J21*K21*O21*Q21","v":0}]
[null,null,null,null,"uur per bebouwd perceel",null,null,null,null,{"$f":"Vragenlijst!K47","v":0},2,{"$f":"+K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q22*O22*L22*K22*J22*AB20","v":0},null,null,{"$f":"AB20*J22*K22*O22*Q22","v":0}]
[null,null,null,null,"ambtelijke begeleiding onderzoek",null,null,null,null,1,16,{"$f":"+K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q23*O23*L23*K23*J23*AB20","v":0},null,null,{"$f":"AB20*J23*K23*O23*Q23","v":0}]
[null,null,null,null,"jaarlijkse herziening (plus 1 maal per 5 jaar hertaxatie)",null,null,null,null,1,{"$f":"((+K21*J21+K22*J22)*0.15+4)*Vragenlijst!K20+IF(Vragenlijst!K20>5,(J21*K21+J22*K22+J23*K23-((J21*K21+J22*K22)*0.15)),0)","v":0},{"$f":"+K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q24*O24*L24*K24*J24*AB20","v":0},null,null,{"$f":"AB20*J24*K24*O24*Q24","v":0}]
[]
[null,null,"1.2","Taxatie en aankoop onroerende zaak",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S27:S32)","v":0},null,null,{"$f":"SUM(V27:V32)","v":0},null,false,null,null,{"$f":"IF(Y26=TRUE,1,0)","v":0},null,{"$f":"IF(Vragenlijst!L54>0,TRUE,FALSE)","v":false}]
[null,null,null,null,"uur per onbebouwde perceel",null,null,null,null,{"$f":"Vragenlijst!G50","v":0},24,{"$f":"+K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q27*O27*L27*K27*J27*AB26","v":0},null,null,{"$f":"AB26*J27*K27*O27*Q27","v":0}]
[null,null,null,null,"uur per woning (ook huur/pachtontbinding)",null,null,null,null,{"$f":"Vragenlijst!G51+Vragenlijst!G55","v":0},48,{"$f":"+K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q28*O28*L28*K28*J28*AB26","v":0},null,null,{"$f":"AB26*J28*K28*O28*Q28","v":0}]
[null,null,null,null,"uur per agrarisch/bedrijf/winkel/kantoor",null,null,null,null,{"$f":"IF(Vragenlijst!N40=0,Vragenlijst!G52,0)","v":0},80,{"$f":"+K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q29*O29*L29*K29*J29*AB26","v":0},null,null,{"$f":"S29/L29","v":0}]
[null,null,null,null,"uur per agrarisch/bedrijf/winkel/kantoor in herstructurering",null,null,null,null,{"$f":"IF(Vragenlijst!N40=1,Vragenlijst!G52,0)","v":0},100,{"$f":"+K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q30*O30*L30*K30*J30*AB26","v":0},null,null,{"$f":"S30/L30","v":0}]
[null,null,null,null,"uur per byzonder object",null,null,null,null,{"$f":"IF(Vragenlijst!N40=0,Vragenlijst!G53,0)","v":0},80,{"$f":"+K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q31*O31*L31*K31*J31*AB26","v":0},null,null,{"$f":"S31/L31","v":0}]
[null,null,null,null,"uur per byzonder object in herstructurering",null,null,null,null,{"$f":"IF(Vragenlijst!N40=1,Vragenlijst!G53,0)","v":0},100,{"$f":"K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q32*O32*L32*K32*J32*AB26","v":0},null,null,{"$f":"S32/L32","v":0}]
[]
[null,null,"1.3","Onteigenen van onroerende zaken",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S35:S37)","v":0},null,null,{"$f":"SUM(V35:V36)","v":0},null,false,null,null,{"$f":"IF(Y34=TRUE,1,0)","v":0},null,{"$f":"IF(Vragenlijst!L60>0,TRUE,FALSE)","v":false}]
[null,null,null,null,"uur per administratieve procedure",null,null,null,null,{"$f":"Vragenlijst!G58","v":0},110,{"$f":"K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q35*O35*L35*K35*J35*AB34","v":0},null,null,{"$f":"AB34*J35*K35*O35*Q35","v":0}]
[null,null,null,null,"uur per gerechtelijke procedure",null,null,null,null,{"$f":"Vragenlijst!G59","v":0},50,{"$f":"K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q36*O36*L36*K36*J36*AB34","v":0},null,null,{"$f":"AB34*J36*K36*O36*Q36","v":0}]
[null,null,null,null,"vast bedrag advocaatkosten per onteigening",null,null,null,null,{"$f":"Vragenlijst!G59","v":0},36297,null,null,"nee",1,"nee",1,null,{"$f":"Q37*O37*K37*J37*AB34","v":0}]
[]
[null,null,"1.4","Toepassen Wet voorkeursrecht gemeente",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S40:S41)","v":0},null,null,{"$f":"SUM(V40:V41)","v":0},null,false,null,null,{"$f":"IF(Y39=TRUE,1,0)","v":0},null,{"$f":"+Vragenlijst!K61","v":false}]
[null,null,null,null,"uur voor vestiging voorkeursrecht",null,null,null,null,{"$f":"Vragenlijst!N61","v":0},60,{"$f":"K7","v":142},null,"nee",1,"nee",1,null,{"$f":"Q40*O40*L40*K40*J40*AB39","v":0},null,null,{"$f":"AB39*J40*K40*O40*Q40","v":0}]
[]
[]
[null,null,null,"Stedenbouw",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T45:T66)","v":0},null,null,{"$f":"SUM(W45:W66)","v":0}]
[]
[null,null,"2.1","Programma van Eisen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S46:S47)","v":0},null,null,{"$f":"SUM(V46:V47)","v":0},null,false,null,null,{"$f":"IF(Y45=TRUE,1,0)","v":0},null,{"$f":"+Vragenlijst!K80","v":false}]
[null,null,null,null,"uur voor opstellen pve",null,null,null,null,1,80,{"$f":"K8","v":142},null,"herstruct+programma",{"$f":"1+(W9+W11)/2","v":1},"nee",1,null,{"$f":"Q46*O46*L46*K46*J46*AB45","v":0},null,null,{"$f":"AB45*J46*K46*O46*Q46","v":0}]
[null,null,null,null,"uur bij maatschappelijk programma",null,null,null,null,{"$f":"IF(Vragenlijst!G69>0,1,0)","v":0},40,{"$f":"K8","v":142},null,"herstruct+programma",{"$f":"1+(W9+W11)/2","v":1},"nee",1,null,{"$f":"Q47*O47*L47*K47*J47*AB45","v":0},null,null,{"$f":"AB45*J47*K47*O47*Q47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V49)","v":0}]
[null,null,"2.2","Prijsvraag","uur voor organiseren",null,null,null,null,1,200,{"$f":"K8","v":142},null,"herstruct+programma",{"$f":"1+(W9+W11)/2","v":1},"nee",1,null,null,{"$f":"Q49*O49*L49*K49*J49*AB49","v":0},null,{"$f":"AB49*J49*K49*O49*Q49","v":0},null,null,false,null,null,{"$f":"IF(Y49=TRUE,1,0)","v":0},null,{"$f":"+Vragenlijst!K79","v":false}]
[]
[null,null,"2.3","Masterplan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S52:S53)","v":0},null,null,{"$f":"SUM(V52:V53)","v":0},null,false,null,null,{"$f":"IF(Y51=TRUE,1,0)","v":0},null,{"$f":"+Vragenlijst!K81","v":false}]
[null,null,null,null,"uur per woning",null,null,null,null,{"$f":"Vragenlijst!G66","v":0},1.5,{"$f":"K8","v":142},null,"nee",1,"ja",{"$f":"T6","v":0.85},null,{"$f":"Q52*O52*L52*K52*J52*AB51","v":0},null,null,{"$f":"AB51*J52*K52*O52*Q52","v":0}]
[null,null,null,null,"uur per 100 m2 uitgeefbaar niet woningbouw",null,null,null,null,{"$f":"(Vragenlijst!G67+Vragenlijst!G68+Vragenlijst!G69+Vragenlijst!G70)/Vragenlijst!W64","v":0},0.25,{"$f":"K8","v":142},null,"nee",1,"ja",{"$f":"T6","v":0.85},null,{"$f":"Q53*O53*L53*K53*J53*AB51","v":0},null,null,{"$f":"AB51*J53*K53*O53*Q53","v":0}]
[]
[null,null,"2.4","Beeldkwaliteitsplan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S56:S57)","v":0},null,null,{"$f":"SUM(V56:V57)","v":0},null,false,null,null,{"$f":"IF(Y55=TRUE,1,0)","v":0},null,{"$f":"+Vragenlijst!K82","v":false}]
[null,null,null,null,"uur per woning",null,null,null,null,{"$f":"Vragenlijst!G66","v":0},1,{"$f":"K8","v":142},null,"nee",1,"nee",1,null,{"$f":"Q56*O56*L56*K56*J56*AB55","v":0},null,null,{"$f":"AB55*J56*K56*O56*Q56","v":0}]
[null,null,null,null,"uur per 100 m2 uitgeefbaar niet woningbouw",null,null,null,null,{"$f":"(Vragenlijst!G67+Vragenlijst!G68+Vragenlijst!G69+Vragenlijst!G70)/Vragenlijst!W64","v":0},0.25,{"$f":"K8","v":142},null,"nee",1,"nee",1,null,{"$f":"Q57*O57*L57*K57*J57*AB55","v":0},null,null,{"$f":"AB55*J57*K57*O57*Q57","v":0}]
[]
[null,null,"2.5","Stedenbouwkundig plan",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S60:S62)","v":0},null,null,{"$f":"SUM(V60:V62)","v":0},null,false,null,null,{"$f":"IF(Y59=TRUE,1,0)","v":0},null,{"$f":"+Vragenlijst!K83","v":false}]
[null,null,null,null,"uur per woning",null,null,null,null,{"$f":"Vragenlijst!G66","v":0},2.5,{"$f":"K8","v":142},null,"herstruct+programma",{"$f":"1+(W9+W11)/2","v":1},"nee",1,null,{"$f":"Q60*O60*L60*K60*J60*AB59","v":0},null,null,{"$f":"AB59*J60*K60*O60*Q60","v":0}]
[null,null,null,null,"uur per 100 m2 uitgeefbaar niet woningbouw",null,null,null,null,{"$f":"(Vragenlijst!G67+Vragenlijst!G68+Vragenlijst!G69+Vragenlijst!G70)/Vragenlijst!W64","v":0},0.5,{"$f":"K8","v":142},null,"herstruct+programma",{"$f":"1+(W9+W11)/2","v":1},"nee",1,null,{"$f":"Q61*O61*L61*K61*J61*AB59","v":0},null,null,{"$f":"AB59*J61*K61*O61*Q61","v":0}]
[null,null,null,null,"uur bij maatschappelijk programma",null,null,null,null,{"$f":"IF(Vragenlijst!G69>0,1,0)","v":0},40,{"$f":"K8","v":142},null,"herstruct+programma",{"$f":"1+(W9+W11)/2","v":1},"nee",1,null,{"$f":"Q62*O62*L62*K62*J62*AB59","v":0},null,null,{"$f":"AB59*J62*K62*O62*Q62","v":0}]
[]
[null,null,"2.6","Inrichtingsplan Openbare ruimte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S65:S66)","v":0},null,null,{"$f":"SUM(V65:V66)","v":0},null,false,null,null,{"$f":"IF(Y64=TRUE,1,0)","v":0},null,{"$f":"+Vragenlijst!K84","v":false}]
[null,null,null,null,"uur per woning",null,null,null,null,{"$f":"Vragenlijst!G66","v":0},1.5,{"$f":"K8","v":142},null,"nee",1,"nee",1,null,{"$f":"Q65*O65*L65*K65*J65*AB64","v":0},null,null,{"$f":"AB64*J65*K65*O65*Q65","v":0}]
[null,null,null,null,"uur per 100 m2 uitgeefbaar niet woningbouw",null,null,null,null,{"$f":"(Vragenlijst!G67+Vragenlijst!G68+Vragenlijst!G69+Vragenlijst!G70)/Vragenlijst!W64","v":0},0.5,{"$f":"K8","v":142},null,"nee",1,"nee",1,null,{"$f":"Q66*O66*L66*K66*J66*AB64","v":0},null,null,{"$f":"AB64*J66*K66*O66*Q66","v":0}]
[]
[]
[null,null,null,"Ruimtelijke ordening",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T70:T79)","v":0},null,null,{"$f":"SUM(W70:W79)","v":0}]
[null,null,"3.1","Opstellen en procedure bestemmingsplan, omgevingsvergunning of projectuitvoeringsbesluit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S71:S74)","v":0},null,null,{"$f":"SUM(V71:V74)","v":0},null,false,null,null,{"$f":"IF(Y70=TRUE,1,0)","v":0},null,{"$f":"IF(SUM(Vragenlijst!N97:N101)>0,TRUE,FALSE)","v":false}]
[null,null,null,null,"- uur per globaal uit te werken plan,  ",null,null,null,null,{"$f":"IF(Vragenlijst!N105=1,Vragenlijst!N106,Vragenlijst!N97)*Vragenlijst!N97","v":0},{"$f":"hulpblad!B185","v":60},{"$f":"K9","v":142},null,"nee",1,"ja",{"$f":"T7","v":1},null,{"$f":"Q71*O71*L71*K71*J71*AB70","v":0},null,null,{"$f":"AB70*J71*K71*O71*Q71","v":0}]
[null,null,null,null," omgevingsvergunning of projectuitvoeringsbesluit"]
[null,null,null,null,"- uur per uitwerkingsplan ",null,null,null,null,{"$f":"Vragenlijst!N99*Vragenlijst!N97","v":0},90,{"$f":"K9","v":142},null,"nee",1,"nee",1,null,{"$f":"Q73*O73*L73*K73*J73*AB70","v":0},null,null,{"$f":"AB70*J73*K73*O73*Q73","v":0}]
[null,null,null,null,"- uur per gedetailleerd bestemmingsplan",null,null,null,null,{"$f":"IF(Vragenlijst!N105=1,Vragenlijst!N106,Vragenlijst!N101)*Vragenlijst!N101","v":0},{"$f":"hulpblad!B171","v":100},{"$f":"K9","v":142},null,"nee",1,"ja",{"$f":"T7","v":1},null,{"$f":"Q74*O74*L74*K74*J74*AB70","v":0},null,null,{"$f":"AB70*J74*K74*O74*Q74","v":0}]
[]
[null,null,"3.2","Opstellen en procedure wijzigingsplan","uur per plan  (art 3.6.1.a Wro)",null,null,null,null,{"$f":"Vragenlijst!N103","v":0},90,{"$f":"K9","v":142},null,"nee",1,"nee",1,null,null,{"$f":"Q76*O76*L76*K76*J76*AB76","v":0},null,null,{"$f":"AB76*J76*K76*O76*Q76","v":0},null,false,null,null,{"$f":"IF(Y76=TRUE,1,0)","v":0},null,{"$f":"Vragenlijst!K103","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S79:S80)","v":0},null,null,{"$f":"SUM(V79:V80)","v":0}]
[null,null,"3.3","Opstellen en procedure exploitatieplan","uur per exploitatieplan",null,null,null,null,1,{"$f":"hulpblad!B200","v":25},{"$f":"K9","v":142},null,"nee",1,"ja",{"$f":"T7","v":1},null,{"$f":"Q79*O79*L79*K79*J79*AB79","v":0},null,null,{"$f":"AB79*J79*K79*O79*Q79","v":0},null,null,false,null,null,{"$f":"IF(Y79=TRUE,1,0)","v":0},null,true]
[null,null,null,null,"jaarlijkse actualisatie",null,null,null,null,{"$f":"+Vragenlijst!K20","v":0},{"$f":"0.15*K79","v":3.75},{"$f":"+K9","v":142},null,"nee",1,"ja",{"$f":"T7","v":1},null,{"$f":"Q80*O80*L80*K80*J80*AB79","v":0},null,null,{"$f":"AB79*J80*K80*O80*Q80","v":0}]
[]
[]
[null,null,null,"Civiele en cultuur techniek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T84:T89)","v":0},null,null,{"$f":"SUM(W84:W90)","v":0}]
[null,null,"4.1","Planontwikkeling","uur per week",null,null,null,null,{"$f":"Vragenlijst!E14*Vragenlijst!E15","v":0},2,{"$f":"K10","v":142},null,"bodemgesteldheid",{"$f":"1+W13","v":1},"ja",{"$f":"T6","v":0.85},null,null,{"$f":"Q84*O84*L84*K84*J84*AB84","v":0},null,null,{"$f":"AB84*J84*K84*O84*Q84","v":0},null,false,null,null,{"$f":"IF(Y84=TRUE,1,0)","v":0},null,{"$f":"IF(SUM(Vragenlijst!N83:N84)>0,TRUE,FALSE)","v":false}]
[]
[null,null,"4.2","Voorbereiding, toezicht en directievoering ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S87:S89)","v":0},null,null,{"$f":"SUM(V87:V89)","v":0},null,false,null,null,{"$f":"IF(Y86=TRUE,1,0)","v":0},null,{"$f":"IF(SUM(Vragenlijst!N113+Vragenlijst!N145+Vragenlijst!N157)>0,TRUE,FALSE)","v":false}]
[null,null,null,null,"uren en bedragen slopen",null,null,null,null,1,{"$f":"+hulpblad!G48","v":0},1,null,"nee",1,"ja",{"$f":"+T8","v":1},null,{"$f":"Q87*O87*L87*K87*J87*AB86","v":0},null,null,{"$f":"+hulpblad!I48*O87*Q87","v":0}]
[null,null,null,null,"bedragen ophogen/voorbelasten",null,null,null,null,1,{"$f":"hulpblad!G161","v":0},1,null,"nee",1,"nee",1,null,{"$f":"Q88*O88*L88*K88*J88*AB86","v":0}]
[null,null,null,null,"uren en bedragen bouw en woonrijpmaken",null,null,null,null,1,{"$f":"+hulpblad!G107","v":0},1,null,"nee",1,"ja",{"$f":"+T8","v":1},null,{"$f":"Q89*O89*L89*K89*J89*AB86","v":0},null,null,{"$f":"+hulpblad!I107*O89*Q89","v":0}]
[]
[]
[null,null,null,"Landmeten/vastgoedinformatie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T93)","v":0},null,null,{"$f":"SUM(W93)","v":0}]
[null,null,"5.1","Kaartmateriaal","uur per week",null,null,null,null,{"$f":"Vragenlijst!E14*Vragenlijst!E15","v":0},1,{"$f":"K11","v":113},null,"omvang",{"$f":"(1+W7)","v":9.9999999999999978E-2},"ja",{"$f":"T6","v":0.85},null,null,{"$f":"Q93*O93*L93*K93*J93*AB93","v":0},null,null,{"$f":"AB93*J93*K93*O93*Q93","v":0},null,false,null,null,{"$f":"IF(Y93=TRUE,1,0)","v":0},null,{"$f":"IF((SUM(Vragenlijst!N81:N84)+Vragenlijst!N48+Vragenlijst!N49)>0,TRUE,FALSE)","v":false}]
[]
[]
[null,null,null,"Communicatie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T97)","v":0},null,null,{"$f":"SUM(W98)","v":0}]
[null,null,"6.1","Omgevingsmanagement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S98:S100)","v":0},null,null,null,null,false,null,null,{"$f":"IF(AD97=TRUE,1,0)","v":0},null,{"$f":"IF(T6>130%,TRUE,FALSE)","v":false}]
[null,null,null,null,"uur per week ",null,null,null,null,{"$f":"Vragenlijst!E14*Vragenlijst!E15*AB97","v":0},1,{"$f":"K12","v":124},null,"nee",1,"ja",{"$f":"T6","v":0.85},null,{"$f":"Q98*O98*L98*K98*J98*AB97","v":0},null,null,null,{"$f":"AB97*J98*K98*O98*Q98","v":0}]
[null,null,null,null,"kosten gemid per jaar woningbouw",null,null,null,null,{"$f":"Vragenlijst!E14*AB97","v":0},6050,{"$f":"IF(Vragenlijst!N66=1,1,0)","v":0},null,"nee",1,"ja",{"$f":"T6","v":0.85},null,{"$f":"Q99*O99*L99*K99*J99*AB97","v":0}]
[null,null,null,null,"kosten gemid per jaar bedrijvigheid/commercieel",null,null,null,null,{"$f":"Vragenlijst!E14*AB97","v":0},12110,{"$f":"IF(Vragenlijst!N67=1,1,IF(Vragenlijst!N68=1,1,0))","v":0},null,"nee",1,"ja",{"$f":"T6","v":0.85},null,{"$f":"Q100*O100*L100*K100*J100*AB97","v":0}]
[]
[]
[null,null,null,"Management",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T104:T106)","v":0},null,null,{"$f":"SUM(W104:W106)","v":0}]
[null,null,"7.1","Projectmanagement","uur per week",null,null,null,null,{"$f":"Vragenlijst!$E$14*Vragenlijst!$E$15","v":0},8,{"$f":"K13","v":161},null,"omvang",{"$f":"1+W7","v":9.9999999999999978E-2},"ja",{"$f":"T6","v":0.85},null,null,{"$f":"Q104*O104*L104*K104*J104*AB104","v":0},null,null,{"$f":"AB104*J104*K104*O104*Q104","v":0},null,false,null,null,{"$f":"IF(Y104=TRUE,1,0)","v":0},null,true]
[]
[null,null,"7.2","Projectmanagementassistentie","uur per week",null,null,null,null,{"$f":"Vragenlijst!$E$14*Vragenlijst!$E$15*AB106","v":0},6,{"$f":"K14","v":113},null,"omvang",{"$f":"1+W7","v":9.9999999999999978E-2},"ja",{"$f":"T6","v":0.85},null,null,{"$f":"Q106*O106*L106*K106*J106*AB106","v":0},null,null,{"$f":"AB106*J106*K106*O106*Q106","v":0},null,false,null,null,{"$f":"IF(AD106=TRUE,1,0)","v":0},null,{"$f":"IF(T6>130%,TRUE,FALSE)","v":false}]
[]
[]
[null,null,null,"Planeconomie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T110)","v":0},null,null,{"$f":"SUM(W110)","v":0}]
[null,null,"8.1","Planeconomie","uur per week",null,null,null,null,{"$f":"Vragenlijst!$E$14*Vragenlijst!$E$15","v":0},4,{"$f":"K15","v":142},null,"omvang",{"$f":"1+W7","v":9.9999999999999978E-2},"ja",{"$f":"T6","v":0.85},null,null,{"$f":"Q110*O110*L110*K110*J110*AB110","v":0},null,null,{"$f":"AB110*J110*K110*O110*Q110","v":0},null,false,null,null,{"$f":"IF(Y110=TRUE,1,0)","v":0},null,true]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T18:T111)","v":0},{"$f":"SUM(U18:U111)","v":0},null,{"$f":"SUM(W18:W111)","v":0},{"$f":"SUM(X18:X111)","v":0}]

{"sheet":"Resultaat","index":4,"n_rows":49,"n_cols":15,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Regeling plankosten exploitatieplan 2023"]
[null,null,"Resultaat"]
[null,null,null,"Datum",{"$f":"TODAY()","v":"2023-08-15"},"Complexiteit",{"$f":"Productenlijst!T6","v":0.85}]
[null,null,null,"Gemeente",{"$f":"Vragenlijst!E10","v":"…,"}]
[null,null,null,"Projectnaam",{"$f":"Vragenlijst!E11","v":"…."}]
[null,null,null,"Projectnummer",{"$f":"Vragenlijst!E12","v":"…."}]
[null,null,null,"Datum prijspeil",{"$f":"Vragenlijst!E13","v":"2023-01-01"}]
[null,null,null,"Looptijd project in jaren",{"$f":"Vragenlijst!E14","v":0}]
[null,null,null,null,null,null,"euro's"]
[null,null,null,"Produkt/activiteit","uren","euro's","in %"]
[null,null,null,"Verwerving",{"$f":"SUM(E14:E17)","v":0},{"$f":"SUM(F14:F17)","v":0},{"$f":"F13/$F$49","v":{"$error":"#DIV/0!"}}]
[null,null,"1.1","Taxatie inbrengwaarde percelen",{"$f":"Productenlijst!W20","v":0},{"$f":"Productenlijst!T20","v":0},{"$f":"F14/$F$49","v":{"$error":"#DIV/0!"}},true,null,null,null,null,null,null,{"$f":"IF(F14>0,TRUE,FALSE)","v":false}]
[null,null,"1.2",{"$f":"Productenlijst!D26","v":"Taxatie en aankoop onroerende zaak"},{"$f":"Productenlijst!W26","v":0},{"$f":"Productenlijst!T26","v":0},{"$f":"F15/$F$49","v":{"$error":"#DIV/0!"}},true,null,null,null,null,null,null,{"$f":"IF(F15>0,TRUE,FALSE)","v":false}]
[null,null,"1.3",{"$f":"Productenlijst!D34","v":"Onteigenen van onroerende zaken"},{"$f":"Productenlijst!W34","v":0},{"$f":"Productenlijst!T34","v":0},{"$f":"F16/$F$49","v":{"$error":"#DIV/0!"}},true,null,null,null,null,null,null,{"$f":"IF(F16>0,TRUE,FALSE)","v":false}]
[null,null,"1.4",{"$f":"Productenlijst!D39","v":"Toepassen Wet voorkeursrecht gemeente"},{"$f":"Productenlijst!W39","v":0},{"$f":"Productenlijst!T39","v":0},{"$f":"F17/$F$49","v":{"$error":"#DIV/0!"}},false,null,null,null,null,null,null,{"$f":"IF(F17>0,TRUE,FALSE)","v":false}]
[]
[null,null,null,"Stedenbouw",{"$f":"SUM(E20:E25)","v":0},{"$f":"SUM(F20:F25)","v":0},{"$f":"F19/$F$49","v":{"$error":"#DIV/0!"}}]
[null,null,"2.1",{"$f":"Productenlijst!D45","v":"Programma van Eisen"},{"$f":"Productenlijst!W45","v":0},{"$f":"Productenlijst!T45","v":0},{"$error":"#DIV/0!"},true,null,null,null,null,null,null,{"$f":"IF(F20>0,TRUE,FALSE)","v":false}]
[null,null,"2.2",{"$f":"Productenlijst!D49","v":"Prijsvraag"},{"$f":"Productenlijst!W48","v":0},{"$f":"Productenlijst!T49","v":0},{"$error":"#DIV/0!"},false,null,null,null,null,null,null,false]
[null,null,"2.3",{"$f":"Productenlijst!D51","v":"Masterplan"},{"$f":"Productenlijst!W51","v":0},{"$f":"Productenlijst!T51","v":0},{"$error":"#DIV/0!"},false,null,null,null,null,null,null,false]
[null,null,"2.4","Beeldkwaliteitsplan",{"$f":"Productenlijst!W55","v":0},{"$f":"Productenlijst!T55","v":0},{"$error":"#DIV/0!"},true,null,null,null,null,null,null,false]
[null,null,"2.5",{"$f":"Productenlijst!D59","v":"Stedenbouwkundig plan"},{"$f":"Productenlijst!W59","v":0},{"$f":"Productenlijst!T59","v":0},{"$error":"#DIV/0!"},false,null,null,null,null,null,null,false]
[null,null,"2.6",{"$f":"Productenlijst!D64","v":"Inrichtingsplan Openbare ruimte"},{"$f":"Productenlijst!W64","v":0},{"$f":"Productenlijst!T64","v":0},{"$error":"#DIV/0!"},true,null,null,null,null,null,null,false]
[]
[null,null,null,"Ruimtelijke Ordening",{"$f":"SUM(E28:E30)","v":0},{"$f":"SUM(F28:F30)","v":0},{"$f":"F27/$F$49","v":{"$error":"#DIV/0!"}}]
[null,null,"3.1",{"$f":"Productenlijst!D70","v":"Opstellen en procedure bestemmingsplan, omgevingsvergunning of projectuitvoeringsbesluit"},{"$f":"Productenlijst!W70","v":0},{"$f":"Productenlijst!T70","v":0},{"$f":"F28/$F$49","v":{"$error":"#DIV/0!"}},true,null,null,null,null,null,null,{"$f":"IF(F28>0,TRUE,FALSE)","v":false}]
[null,null,"3.2",{"$f":"Productenlijst!D76","v":"Opstellen en procedure wijzigingsplan"},{"$f":"Productenlijst!W76","v":0},{"$f":"Productenlijst!T76","v":0},{"$f":"F29/$F$49","v":{"$error":"#DIV/0!"}},false,null,null,null,null,null,null,{"$f":"IF(F29>0,TRUE,FALSE)","v":false}]
[null,null,"3.3",{"$f":"Productenlijst!D79","v":"Opstellen en procedure exploitatieplan"},{"$f":"Productenlijst!W78","v":0},{"$f":"Productenlijst!T78","v":0},{"$f":"F30/$F$49","v":{"$error":"#DIV/0!"}},true,null,null,null,null,null,null,{"$f":"IF(F30>0,TRUE,FALSE)","v":false}]
[]
[null,null,null,"Civiele en cultuur techniek ",{"$f":"SUM(E33:E34)","v":0},{"$f":"SUM(F33:F34)","v":0},{"$f":"F32/$F$49","v":{"$error":"#DIV/0!"}}]
[null,null,"4.1",{"$f":"Productenlijst!D84","v":"Planontwikkeling"},{"$f":"Productenlijst!W84","v":0},{"$f":"Productenlijst!T84","v":0},{"$f":"F33/$F$49","v":{"$error":"#DIV/0!"}},true,null,null,null,null,null,null,{"$f":"IF(F33>0,TRUE,FALSE)","v":false}]
[null,null,"4.2",{"$f":"Productenlijst!D86","v":"Voorbereiding, toezicht en directievoering "},{"$f":"Productenlijst!W86","v":0},{"$f":"Productenlijst!T86","v":0},{"$f":"F34/$F$49","v":{"$error":"#DIV/0!"}},true,null,null,null,null,null,null,{"$f":"IF(F34>0,TRUE,FALSE)","v":false}]
[]
[null,null,null,"Landmeten/vastgoedinformatie",{"$f":"SUM(E37)","v":0},{"$f":"SUM(F37)","v":0},{"$f":"F36/$F$49","v":{"$error":"#DIV/0!"}}]
[null,null,"5.1",{"$f":"Productenlijst!D93","v":"Kaartmateriaal"},{"$f":"Productenlijst!X92","v":0},{"$f":"Productenlijst!U92","v":0},{"$f":"F37/$F$49","v":{"$error":"#DIV/0!"}},true,null,null,null,null,null,null,{"$f":"IF(F37>0,TRUE,FALSE)","v":false}]
[]
[null,null,null,"Communicatie",{"$f":"SUM(E40)","v":0},{"$f":"SUM(F40)","v":0},{"$f":"F39/$F$49","v":{"$error":"#DIV/0!"}}]
[null,null,"6.1",{"$f":"Productenlijst!D97","v":"Omgevingsmanagement"},{"$f":"Productenlijst!X96","v":0},{"$f":"Productenlijst!U96","v":0},{"$f":"F40/$F$49","v":{"$error":"#DIV/0!"}},false,null,null,null,null,null,null,{"$f":"IF(F40>0,TRUE,FALSE)","v":false}]
[]
[null,null,null,"Management",{"$f":"SUM(E43:E44)","v":0},{"$f":"SUM(F43:F44)","v":0},{"$f":"F42/$F$49","v":{"$error":"#DIV/0!"}}]
[null,null,"7.1",{"$f":"Productenlijst!D104","v":"Projectmanagement"},{"$f":"Productenlijst!W104","v":0},{"$f":"Productenlijst!T104","v":0},{"$f":"F43/$F$49","v":{"$error":"#DIV/0!"}},false,null,null,null,null,null,null,{"$f":"IF(F43>0,TRUE,FALSE)","v":false}]
[null,null,"7.2",{"$f":"Productenlijst!D106","v":"Projectmanagementassistentie"},{"$f":"Productenlijst!W106","v":0},{"$f":"Productenlijst!T106","v":0},{"$f":"F44/$F$49","v":{"$error":"#DIV/0!"}},false,null,null,null,null,null,null,{"$f":"IF(F44>0,TRUE,FALSE)","v":false}]
[]
[null,null,null,"Planeconomie",{"$f":"SUM(E47)","v":0},{"$f":"SUM(F47)","v":0},{"$f":"F46/$F$49","v":{"$error":"#DIV/0!"}}]
[null,null,"8.1",{"$f":"Productenlijst!D110","v":"Planeconomie"},{"$f":"Productenlijst!X109","v":0},{"$f":"Productenlijst!U109","v":0},{"$f":"F47/$F$49","v":{"$error":"#DIV/0!"}},false,null,null,null,null,null,null,{"$f":"IF(F47>0,TRUE,FALSE)","v":false}]
[]
[null,null,null,"totaal",{"$f":"E46+E42+E39+E36+E32+E27+E19+E13","v":0},{"$f":"F46+F42+F39+F36+F32+F27+F19+F13","v":0},{"$f":"G46+G42+G39+G36+G32+G27+G19+G13","v":{"$error":"#DIV/0!"}}]

{"sheet":"hulpblad","index":5,"n_rows":210,"n_cols":17,"rows_kept":210,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Plankosten SLOPEN"]
[]
[null,"Op te halen variabelen uit vragen- en produktenlijst"]
[null,null,"Omvang plangebied",null,null,{"$f":"+Vragenlijst!K25","v":0},"ha"]
[null,null,"aantal m3",null,null,{"$f":"+Vragenlijst!N120","v":0},"m3"]
[null,null,"invloedsfactor",null,null,{"$f":"1+Vragenlijst!R123","v":1},"gemiddeld type te slopen onroerende zaak"]
[null,null,"aantal bestekken sloop volgens norm",null,null,{"$f":"F6/2.5*0.5","v":0},"stuks (norm: 0,5 per deelgebied, 6 deelgebieden per 15 ha)"]
[null,null,"te rekenen aantal bestekken",null,null,{"$f":"IF(Vragenlijst!K118=TRUE,F9,0)","v":0},"stuks"]
[]
[null,null,"invloedsfactor",null,null,{"$f":"1+Vragenlijst!R133","v":1},"wijze van aanbesteding"]
[null,null,"asbest ?",null,null,{"$f":"+IF(Vragenlijst!K130=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"+Vragenlijst!N131+1","v":1},"asbest"]
[]
[null,null,"tarief projectleider",null,null,{"$f":"+Productenlijst!O7","v":142},"per uur"]
[null,null,"tarief bestekschrijver/calculator",null,null,{"$f":"+Productenlijst!O9","v":113},"per uur"]
[null,null,"tarief directievoerder",null,null,{"$f":"+Productenlijst!O11","v":124},"per uur"]
[null,null,"tarief toezichthouder",null,null,{"$f":"+Productenlijst!O12","v":101},"per uur"]
[]
[null,"Uitgangspunten slopen"]
[]
[null,"Voorbereiding, aanbesteding en gunning"]
[null,null,"bestekschrijver/calculator",null,null,12,"uur per bestek "]
[null,null,"invloedsfactor",null,null,{"$f":"+F12","v":1},"wijze van aanbesteding"]
[]
[null,"Directievoering en toezicht"]
[null,null,"uitvoeringstijd ",null,null,8,"uur per 300 m3 (1 woning) "]
[null,null,"totaal uitvoeringstijd",null,null,{"$f":"+F7/300*F27","v":0},"uur"]
[null,null,"invloedsfactor",null,null,{"$f":"+F8","v":1},"type te slopen onroerende zaak"]
[null,null,"invloedsfactor",null,null,{"$f":"+F12","v":1},"wijze van aanbesteding"]
[null,null,"invloedsfactor",null,null,{"$f":"+G13","v":1},"asbest"]
[null,null,"Directievoering",null,null,{"$f":"1","v":1},"uur per week gedurende uitvoeringstijd"]
[null,null,"Toezichthouder",null,null,{"$f":"4*1","v":4},"uur per week gedurende uitvoeringstijd"]
[]
[null,"Projectleiding"]
[null,null,"begeleiding aanbesteding",null,null,4,"uur per bestek "]
[null,null,"Invloedsfactor",null,null,{"$f":"+F12","v":1},"wijze van aanbesteding"]
[null,null,"werkzaamheden tijdens uitvoering",null,null,{"$f":"0.25*1","v":0.25},"uur per week gedurende uitvoeringstijd "]
[null,null,"Invloedsfactor",null,null,{"$f":"+F8","v":1},"type te slopen onroerende zaak"]
[null,null,"Invloedsfactor",null,null,{"$f":"+G13","v":1},"asbest"]
[]
[null,"Plankosten ",null,null,null,null,"euro's",null,"uren"]
[]
[null,null,"Aanbesteding en gunning",null,null,null,{"$f":"+F23*F10*F24*F16","v":0},null,{"$f":"+F23*F10*F24","v":0}]
[null,null,"Directievoering en toezicht",null,null,null,{"$f":"+(((F28)/40*(F29)*(F30)*F32*F17)+((F28)/40*(F29)*(F30)*F33*F18))*F31","v":0},null,{"$f":"+(((F28)/40*(F29)*(F30)*F32)+((F28)/40*(F29)*(F30)*F33))*F31","v":0}]
[null,null,"Projectleiding",null,null,null,{"$f":"+(F36*F10*F15*(F37)+F38*(F28)/40*F15*F39)*F40","v":0},null,{"$f":"+(F36*F10*(F37)+F38*(F28)/40*F39)*F40","v":0}]
[]
[null,"Totaal plankosten SLOPEN",null,null,null,null,{"$f":"SUM(G44:G46)","v":0},null,{"$f":"SUM(I44:I47)","v":0}]
[]
[]
[]
[null,"Plankosten BOUW EN WOONRIJPMAKEN"]
[]
[null,"Op te halen variabelen uit vragen- en produktenlijst"]
[]
[null,null,"Omvang plangebied",null,null,{"$f":"+Vragenlijst!K25","v":0},"ha"]
[null,null,"Programma",null,null,{"$f":"+Vragenlijst!G66+(Vragenlijst!G67+Vragenlijst!G68+Vragenlijst!G69+Vragenlijst!G70)/100","v":0},"woning(equivalenten)"]
[null,null,"aantal deelgebieden volgens norm",null,null,{"$f":"+F56/2.5","v":0},"stuks (6 deelgebieden per 15 ha, )",null,null,null,null,null,"verhouding openbaar/uitgeefbaar tov norm",{"$f":"+Vragenlijst!M74","v":{"$error":"#DIV/0!"}}]
[null,null,"aantal deelgebieden cf verhouding grondgebruik",null,null,{"$f":"hulpblad!F58*N70","v":{"$error":"#DIV/0!"}},"stuks 40% openbaar is norm",null,null,null,null,null,"hulptabel te berekenen aantal deelgebieden"]
[null,null,"te rekenen aantal deelgebieden",null,null,{"$f":"IF(Vragenlijst!K157=TRUE,F59,0)","v":0},"stuks",null,null,null,null,null,"% t.o.v. norm","verrekeningsfactor"]
[null,null,"aantal bestekken bwrm volgens norm",null,null,{"$f":"F60*2","v":0},"stuks (2 bestekken per deelplan)",null,null,null,null,null,1,1]
[null,null,"te rekenen aantal bestekken",null,null,{"$f":"IF(Vragenlijst!K157=TRUE,F61,0)","v":0},"stuks",null,null,null,null,null,1.1200000000000001,1.05]
[null,null,null,null,null,null,null,null,null,null,null,null,1.25,1.1000000000000001]
[null,null,"invloedsfactor ",null,null,{"$f":"1+Vragenlijst!S159","v":1},"wijze van aanbesteden",null,null,null,null,null,1.38,1.1499999999999999]
[null,null,"bodemsanering ?",null,null,{"$f":"+IF(Vragenlijst!K168=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"+Vragenlijst!G169/100","v":0},"van het exploitatiegebied",null,null,null,null,1.5,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,1.5,1.2]
[null,null,"tarief projectleider",null,null,{"$f":"+Productenlijst!O7","v":142},"per uur"]
[null,null,"tarief ontwerper",null,null,{"$f":"+Productenlijst!O8","v":142},"per uur"]
[null,null,"tarief bestekschrijver/calculator",null,null,{"$f":"+Productenlijst!O9","v":113},"per uur"]
[null,null,"tarief tekenaar",null,null,{"$f":"+Productenlijst!O10","v":101},"per uur",null,null,null,null,null,"te hanteren verreken % t.o.v. norm deelgebieden:",{"$f":"IF(N58<$M$61,$N$61,IF(N58<$M$62,$N61+((N58-$M$61)/($M$62-$M$61))*($N$62-$N$61),\nIF(N58<$M$63,$N$62+((N58-$M$62)/($M$63-$M$62))*($N$63-$N$62),\nIF(N58<$M$64,$N$63+((N58-$M$63)/($M$64-$M$63))*($N$64-$N$63),\nIF(N58<$M$65,$N$64+((N58-$M$64)/($M$65-$M$64))*($N$65-$N$64),\nIF(N58<$M$66,$N$65+((N58-$M$65)/($M$66-$M$65))*($N$66-$N$65),$N$66))))))","v":{"$error":"#DIV/0!"}}]
[null,null,"tarief directievoerder",null,null,{"$f":"+Productenlijst!O11","v":124},"per uur"]
[null,null,"tarief toezichthouder",null,null,{"$f":"+Productenlijst!O12","v":101},"per uur"]
[]
[null,"Uitgangspunten BOUW EN WOONRIJPMAKEN"]
[]
[null,"Ontwerp VO en DO:"]
[null,null,"aantal deelgebieden",null,null,{"$f":"+F60","v":0},"deelgebieden"]
[null,null,"uren ontwerper",null,null,160,"per ontwerp VO en DO  per deelgebied "]
[null,null,"Rioleringsplan",null,null,0.25,"uur per woning(equivalent)"]
[]
[null,"Aanbesteding en gunning"]
[null,null,"Aantal bestekken",null,null,{"$f":"+F62","v":0},"brm en wrm"]
[null,null,"invloedsfactor",null,null,{"$f":"+F64","v":1},"wijze van aanbesteding"]
[null,null,"bestekschrijver/calculator",null,null,40,"uur per bestek"]
[null,null,"tekenaar",null,null,24,"uur per bestek"]
[]
[null,"Directievoering en toezicht"]
[null,null,"uitvoeringstijd BWRM",null,null,12,"maanden "]
[null,null,"extra uitvoeringstijd BRM ivm bodemsanering",null,null,{"$f":"+IF(F65=\"ja\",2*G65,0)","v":0},"maanden "]
[null,null,"totaal uitvoeringstijd bestekken",null,null,{"$f":"+(F88+F89)*F62/2","v":0},"maanden"]
[null,null,"invloedsfactor",null,null,{"$f":"+F64","v":1},"wijze van aanbesteding"]
[null,null,"Directievoering",null,null,5,"uur per week gedurende uitvoeringstijd"]
[null,null,"Toezichthouder",null,null,10,"uur per week gedurende uitvoeringstijd"]
[]
[null,"Projectleiding"]
[null,null,"begeleiding ontwerp",null,null,24,"uur per ontwerp VO en DO"]
[null,null,"begeleiding aanbesteding",null,null,16,"uur per bestek"]
[null,null,"Invloedsfactor",null,null,{"$f":"+F64","v":1},"wijze van aanbesteding"]
[null,null,"werkzaamheden tijdens uitvoering",null,null,1,"uur per week gedurende uitvoeringstijd"]
[]
[null,"Plankosten ",null,null,null,null,"euro's",null,"uren"]
[null,null,"Ontwerpen",null,null,null,{"$f":"+F77*F78*F68+F79*F57*F68*Productenlijst!AB86","v":0},null,{"$f":"+F77*F78+F79*F57*Productenlijst!AB86","v":0}]
[null,null,"Aanbesteding en gunning",null,null,null,{"$f":"+F82*F84*F69*(F83)+F82*F85*F70*(F83)","v":0},null,{"$f":"+F82*F84*(F83)+F82*F85*(F83)","v":0}]
[null,null,"Directievoering en toezicht",null,null,null,{"$f":"+F90*4*F92*F71+F90*4*F93*F72*F91","v":0},null,{"$f":"+F90*4*F92+F90*4*F93*F91","v":0}]
[null,null,"Projectleiding",null,null,null,{"$f":"+F96*F60*F67+F97*F62*F67*(F98)+F99*F90*4*F67","v":0},null,{"$f":"+F96*F60+F97*F62*(F98)+F99*F90*4","v":0}]
[]
[null,"Totaal plankosten BOUW EN WOONRIJPMAKEN",null,null,null,null,{"$f":"SUM(G102:G105)","v":0},null,{"$f":"SUM(I102:I106)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"PLANKOSTEN OPHOGEN/VOORBELASTEN"]
[]
[null,"Op te halen variabelen uit plankostenscan"]
[null,null,"Grootte plangebied",null,null,{"$f":"Vragenlijst!K25","v":0},"ha"]
[null,null,"Integraal of partieel",null,null,{"$f":"IF(Vragenlijst!N147=1,\"integraal\",\"partieel\")","v":"partieel"}]
[null,null,"Hoogte ophogen",null,null,{"$f":"Vragenlijst!N152","v":0},"m1"]
[null,null,"Aantal fases/deelplannen",null,null,{"$f":"Vragenlijst!N150","v":0},"stuks"]
[null,null,"Zettingstijd",null,null,{"$f":"Vragenlijst!N151","v":0},"jaar"]
[null,null,"Tarief Directievoering ",null,null,{"$f":"Productenlijst!O11","v":124},"per uur"]
[null,null,"Tarief toezichthouden",null,null,{"$f":"Productenlijst!O12","v":101},"per uur"]
[]
[null,"Basiskosten ophogen"]
[null,"uitgangspunt: 10 ha en 1 m1 ophogen"]
[null,null,"Bestek",null,null,12110,"is afhankelijk van grootte werk, naarmate werk groter wordt nemen kosten niet lineair toe, basisprijs wel afhankelijk van integraal of partieel"]
[null,null,null,null,null,null,"en aantal fases"]
[null,null,"Rapportage",null,null,6055,"is afhankelijk van grootte werk, naarmate werk groter wordt nemen kosten niet lineair toe (zie tabel bij bestek)"]
[]
[null,null,null,null,null,null,"hulptabel curve grootte werk",null,null,null,null,"hulptabel bestek",null,null,"hulptabel rapportage"]
[null,null,null,null,null,null,"min oppervlak",null,"max oppervlak",null,"percentage","minimaal","maximaal","per ha","minimaal","maximaal","per ha"]
[null,null,null,null,null,null,0,"ha",10,"ha",1,{"$f":"basisbedrag_bestek*(1+opslag_partieel)","v":18165},{"$f":"L133","v":18165},{"$f":"CEILING(M133/I133,25)","v":1825},{"$f":"basisbedrag_rapportage","v":6055},{"$f":"basisbedrag_rapportage","v":6055},{"$f":"CEILING(P133/I133,25)","v":625}]
[null,null,null,null,null,null,{"$f":"I133","v":10},{"$f":"H133","v":"ha"},15,{"$f":"J133","v":"ha"},0.9,{"$f":"M133","v":18165},{"$f":"I134*K134*$N$133","v":24637.5},{"$f":"CEILING(M134/I134,25)","v":1650},{"$f":"P133","v":6055},{"$f":"I134*K134*$Q$133","v":8437.5},{"$f":"CEILING(P134/I134,25)","v":575}]
[null,null,null,null,null,null,{"$f":"I134","v":15},{"$f":"H134","v":"ha"},50,{"$f":"J134","v":"ha"},0.75,{"$f":"M134","v":24637.5},{"$f":"I135*K135*$N$133","v":68437.5},{"$f":"CEILING(M135/I135,25)","v":1375},{"$f":"P134","v":8437.5},{"$f":"I135*K135*$Q$133","v":23437.5},{"$f":"CEILING(P135/I135,25)","v":475}]
[null,null,null,null,null,null,{"$f":"I135","v":50},{"$f":"H135","v":"ha"},100,"ha",0.5,{"$f":"M135","v":68437.5},{"$f":"I136*K136*$N$133","v":91250},{"$f":"CEILING(M136/I136,25)","v":925},{"$f":"P135","v":23437.5},{"$f":"I136*K136*$Q$133","v":31250},{"$f":"CEILING(P136/I136,25)","v":325}]
[]
[null,null,"Veldonderzoeken",null,null,2422,"per ha"]
[null,null,"Monitoring",null,null,1514,"per ha per jaar zettingstijd"]
[null,null,"Inmeting",null,null,606,"per ha"]
[null,null,"Directievoering",null,null,{"$f":"CEILING((10*10000*$F$119)/$F$147/5*($F$122*4),500)","v":0},"1/2 dag per week, gedurende aanbrengtijd, is dus afhankelijk van hoogte en grootte werk"]
[null,null,"Toezichthouder",null,null,{"$f":"CEILING((10*10000*$F$119)/$F$147/5*($F$123*4),500)","v":0},"1/2 dag per week, gedurende aanbrengtijd, is dus afhankelijk van hoogte en grootte werk"]
[null,"Totaal basiskosten ophogen",null,null,null,{"$f":"SUM(F127:F142)","v":22707},"plangebied 10 ha en 1 m1 integraal ophogen"]
[]
[null,"Rekenkundige uitgangspunten"]
[null,null,"Grootte van een fase",null,null,{"$f":"IF(aantal_fases=0,0,plangebied/aantal_fases)","v":0},"ha"]
[null,null,"Levering per as",null,null,1000,"m3 per dag"]
[null,null,"Uren per week directievoering",null,null,4]
[null,null,"Uren per week toezichthouden",null,null,4]
[null,null,"Indien partieel grootte plangebied",null,null,0.35]
[null,null,"Opslag partieel",null,null,{"$f":"IF(F118=\"Integraal\",0,50%)","v":0.5},"als partiële ophoging dan opslag 50% voor bestek"]
[]
[null,"Plankosten ophogen"]
[null,null,"Bestek",null,null,null,{"$f":"IF(grootte_fase<=$I$133,$M$133,IF(AND(grootte_fase>$G$134,grootte_fase<=$I$134),IF($N$134*grootte_fase<$L$134,$L$134,$N$134*grootte_fase),IF(AND(grootte_fase>$G$135,grootte_fase<=$I$135),IF($N$135*grootte_fase<$L$135,$L$135,$N$135*grootte_fase),IF(grootte_fase>G136,IF(IF($N$136*grootte_fase<$L$136,$L$136,$N$136*grootte_fase)>$M$136,$M$136,IF($N$136*grootte_fase<$L$136,$L$136,$N$136*grootte_fase)),0))))*aantal_fases","v":0}]
[null,null,"Rapportage",null,null,null,{"$f":"IF(grootte_fase<=$I$133,$P$133,IF(AND(grootte_fase>$G$134,grootte_fase<=$I$134),IF($Q$134*grootte_fase<$O$134,$O$134,$Q$134*grootte_fase),IF(AND(grootte_fase>$G$135,grootte_fase<=$I$135),IF($Q$135*grootte_fase<$O$135,$O$135,$Q$135*grootte_fase),IF(grootte_fase>G136,IF(IF($Q$136*grootte_fase<$O$136,$O$136,$Q$136*grootte_fase)>$P$136,$P$136,IF($Q$136*grootte_fase<$O$136,$O$136,$Q$136*grootte_fase)),0))))*aantal_fases","v":0}]
[null,null,"Veldonderzoeken",null,null,null,{"$f":"IF(basisbedrag_veldonderzoeken*plangebied*IF(F118=\"partieel\",F150,1)<4844,4844,basisbedrag_veldonderzoeken*plangebied*IF(F118=\"partieel\",F150,1))","v":4844}]
[null,null,"Monitoring",null,null,null,{"$f":"IF(basisbedrag_monitoring*plangebied*zettingstijd*IF(F118=\"partieel\",F150,1)<3028,3028,basisbedrag_monitoring*plangebied*zettingstijd*IF(F118=\"partieel\",F150,1))","v":3028}]
[null,null,"Inmeting",null,null,null,{"$f":"IF(basisbedrag_inmeting*plangebied*IF(F118=\"partieel\",F150,1)<1211,1211,basisbedrag_inmeting*plangebied*IF(F118=\"partieel\",F150,1))","v":1211}]
[null,null,"Directievoering",null,null,null,{"$f":"CEILING(((((plangebied*IF($F$118=\"Integraal\",1,$F$150))*ophooghoogte*10000)/levering_per_as_per_dag)/5)*(tarief_civiel*uren_per_week_directievoering),500)","v":0}]
[null,null,"Toezichthouder",null,null,null,{"$f":"CEILING(((((plangebied*IF($F$118=\"Integraal\",1,$F$150))*ophooghoogte*10000)/levering_per_as_per_dag)/5)*(F123*uren_per_week_toezichthouden),500)","v":0}]
[null,"Totaal plankosten ophogen tbv plankostenscan",null,null,null,null,{"$f":"SUM(G154:G160)*Vragenlijst!N145","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Hulptabel kosten Ruimtelijke ordening"]
[]
[null,{"$f":"IF(Vragenlijst!N105=1,Vragenlijst!O106,Vragenlijst!K25)","v":0},"ha exploitatiegebied"]
[null,{"$f":"IF(B170<0.5,B173,(IF(B170<1,B174,IF(B170<3,B175,(IF(B170<5,B176,(IF(B170<10,B177,IF(B170<15,B178,IF(B170<20,B179,IF(B170<50,B180,B181)))))))))))","v":100},"uur voor gedetailleerd bestemmingsplan"]
[]
[null,100,"uur voor exploitatiegebied < 0,5 ha"]
[null,200,"uur voor exploitatiegebied tussen 0,5 ha en 1 ha"]
[null,300,"uur voor exploitatiegebied tussen 1 ha en 3 ha"]
[null,400,"uur voor exploitatiegebied tussen 3 ha en 5 ha"]
[null,450,"uur voor exploitatiegebied tussen 5 ha en 10 ha"]
[null,500,"uur voor exploitatiegebied tussen 10 ha en 15 ha"]
[null,550,"uur voor exploitatiegebied tussen 15 ha en 20 ha"]
[null,600,"uur voor exploitatiegebied tussen 20 ha en 50 ha"]
[null,700,"uur voor exploitatiegebied groter dan 50 ha"]
[]
[]
[null,{"$f":"IF(Vragenlijst!N105=1,Vragenlijst!O106,Vragenlijst!K25)","v":0},"ha exploitatiegebied"]
[null,{"$f":"IF(B184<0.5,B188,(IF(B184<1,B189,IF(B184<3,B190,(IF(B184<5,B191,(IF(B184<10,B192,IF(B184<15,B193,IF(B184<20,B194,IF(B184<50,B195,B196)))))))))))","v":60},"uur voor globaal bestemmingsplan met uitwerkingsplicht "]
[null,null,"of project (afwijkings)besluit"]
[]
[null,60,"uur voor exploitatiegebied < 0,5 ha"]
[null,120,"uur voor exploitatiegebied tussen 0,5 ha en 1 ha"]
[null,200,"uur voor exploitatiegebied tussen 1 ha en 3 ha"]
[null,300,"uur voor exploitatiegebied tussen 3 ha en 5 ha"]
[null,350,"uur voor exploitatiegebied tussen 5 ha en 10 ha"]
[null,400,"uur voor exploitatiegebied tussen 10 ha en 15 ha"]
[null,450,"uur voor exploitatiegebied tussen 15 ha en 20 ha"]
[null,500,"uur voor exploitatiegebied tussen 20 ha en 50 ha"]
[null,550,"uur voor exploitatiegebied groter dan 50 ha"]
[]
[]
[null,{"$f":"Vragenlijst!K25","v":0},"ha exploitatiegebied"]
[null,{"$f":"IF(B199<0.5,B202,(IF(B199<1,B203,IF(B199<3,B204,(IF(B199<5,B205,(IF(B199<10,B206,IF(B199<15,B207,IF(B199<20,B208,IF(B199<50,B209,B210)))))))))))","v":25},"uur voor exploitatieplan "]
[]
[null,25,"uur voor exploitatiegebied < 0,5 ha"]
[null,50,"uur voor exploitatiegebied tussen 0,5 ha en 1 ha"]
[null,75,"uur voor exploitatiegebied tussen 1 ha en 3 ha"]
[null,100,"uur voor exploitatiegebied tussen 3 ha en 5 ha"]
[null,115,"uur voor exploitatiegebied tussen 5 ha en 10 ha"]
[null,125,"uur voor exploitatiegebied tussen 10 ha en 15 ha"]
[null,200,"uur voor exploitatiegebied tussen 15 ha en 20 ha"]
[null,250,"uur voor exploitatiegebied tussen 20 ha en 50 ha"]
[null,300,"uur voor exploitatiegebied groter dan 50 ha"]

{"sheet":"Exploitatiebijdrage","index":6,"n_rows":56,"n_cols":34,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+Resultaat!C2","v":0},{"$f":"+Resultaat!D2","v":0},{"$f":"+Resultaat!F2","v":0}]
[null,null,"Regeling plankosten exploitatieplan 2023"]
[null,null,"Overzicht plankosten ingeval een omgevingsvergunning"]
[null,null,"Overzicht plankosten ingeval een omgevingsvergunning  wordt aangevraagd en de eigenaar zelf produkten/activiteiten heeft uitgevoerd"]
[null,null,"In dat geval heeft de vergunningaanvrager recht op aftrek van kosten, mits de gemeente accoord gegeven heeft op het geleverde product !"]
[null,null,{"$f":"+Resultaat!D5","v":"Datum"},{"$f":"+Resultaat!E5","v":"2023-08-15"}]
[null,null,{"$f":"+Resultaat!D6","v":"Gemeente"},{"$f":"+Resultaat!E6","v":"…,"}]
[null,null,{"$f":"+Resultaat!D7","v":"Projectnaam"},{"$f":"+Resultaat!E7","v":"…."}]
[null,null,{"$f":"+Resultaat!D8","v":"Projectnummer"},{"$f":"+Resultaat!E8","v":"…."}]
[null,null,"Totaal aantal gewogen eenheden"]
[]
[null,null,null,null,null,"Naam grondeigenaar:",null,null,null,null,null,"Naam grondeigenaar:",null,null,null,null,null,"Naam grondeigenaar:",null,null,null,null,null,"Naam grondeigenaar:",null,null,null,null,null,"Naam grondeigenaar:"]
[null,null,null,null,null,"Aantal gewogen eenheden:",null,{"$f":"IF(($D$11-$G$14)<0,\"fout, meer dan totaal gewogen eenheden\",\"\")","v":""},null,null,null,"Aantal gewogen eenheden:",null,{"$f":"IF(($D$11-$G$14-$M$14)<0,\"fout, meer dan totaal gewogen eenheden\",\"\")","v":""},null,null,null,"Aantal gewogen eenheden:",null,{"$f":"IF(($D$11-$G$14-$M$14-$S$14)<0,\"fout, meer dan totaal gewogen eenheden\",\"\")","v":""},null,null,null,"Aantal gewogen eenheden:",null,{"$f":"IF(($D$11-$G$14-$M$14-$S$14-$Y$14)<0,\"fout, meer dan totaal gewogen eenheden\",\"\")","v":""},null,null,null,"Aantal gewogen eenheden:",null,{"$f":"IF(($D$11-$G$14-$M$14-$S$14-$Y$14-AE14)<0,\"fout, meer dan totaal gewogen eenheden\",\"\")","v":""}]
[]
[null,null,null,null,null,"aandeel in de ","voert zelf onderstaande","vergoeding voor","te betalen",null,null,"aandeel in de ","voert zelf onderstaande","vergoeding voor","te betalen",null,null,"aandeel in de ","voert zelf onderstaande","vergoeding voor","te betalen",null,null,"aandeel in de ","voert zelf onderstaande","vergoeding voor","te betalen",null,null,"aandeel in de ","voert zelf onderstaande","vergoeding voor","te betalen"]
[null,null,null,null,null,"plankosten","produkten uit:","deze produkten","aan de gemeente",null,null,"plankosten","produkten uit:","deze produkten","aan de gemeente",null,null,"plankosten","produkten uit:","deze produkten","aan de gemeente",null,null,"plankosten","produkten uit:","deze produkten","aan de gemeente",null,null,"plankosten","produkten uit:","deze produkten","aan de gemeente"]
[null,"totaal resultaat exploitatieplan",null,null,null,{"$f":"+G$14/$D$11","v":{"$error":"#DIV/0!"}},"conform art 8 regeling",null,null,null,null,{"$f":"+M$14/$D$11","v":{"$error":"#DIV/0!"}},"conform art 8 regeling",null,null,null,null,{"$f":"+S$14/$D$11","v":{"$error":"#DIV/0!"}},"conform art 8 regeling",null,null,null,null,{"$f":"+Y$14/$D$11","v":{"$error":"#DIV/0!"}},"conform art 8 regeling",null,null,null,null,{"$f":"+AE$14/$D$11","v":{"$error":"#DIV/0!"}},"conform art 8 regeling"]
[null,null,null,{"$f":"+Resultaat!F12","v":"euro's"},null,"euro's","vergoedingspercentages zelf invoeren","euro's ","euro's ",null,null,"euro's","vergoedingspercentages zelf invoeren","euro's ","euro's ",null,null,"euro's","vergoedingspercentages zelf invoeren","euro's ","euro's ",null,null,"euro's","vergoedingspercentages zelf invoeren","euro's ","euro's ",null,null,"euro's","vergoedingspercentages zelf invoeren","euro's ","euro's "]
[null,null,{"$f":"+Resultaat!D13","v":"Verwerving"},{"$f":"+Resultaat!F13","v":0},null,{"$f":"SUM(F21:F24)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(H21:H24)","v":0},{"$f":"SUM(I21:I24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(L21:L24)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(N21:N24)","v":0},{"$f":"SUM(O21:O24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(R21:R24)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(T21:T24)","v":0},{"$f":"SUM(U21:U24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X21:X24)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(Z21:Z24)","v":0},{"$f":"SUM(AA21:AA24)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AD21:AD24)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(AF21:AF24)","v":0},{"$f":"SUM(AG21:AG24)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Resultaat!C14","v":"1.1"},{"$f":"+Resultaat!D14","v":"Taxatie inbrengwaarde percelen"},{"$f":"+Resultaat!F14","v":0},null,{"$f":"+D21*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J21=TRUE,+G21*F21,0)","v":0},{"$f":"+F21-H21","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D21*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P21=TRUE,+M21*L21,0)","v":0},{"$f":"+L21-N21","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D21*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V21=TRUE,+S21*R21,0)","v":0},{"$f":"+R21-T21","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D21*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB21=TRUE,+Y21*X21,0)","v":0},{"$f":"+X21-Z21","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D21*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH21=TRUE,+AE21*AD21,0)","v":0},{"$f":"+AD21-AF21","v":{"$error":"#DIV/0!"}},false]
[null,{"$f":"+Resultaat!C15","v":"1.2"},{"$f":"+Resultaat!D15","v":"Taxatie en aankoop onroerende zaak"},{"$f":"+Resultaat!F15","v":0},null,{"$f":"+D22*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J22=TRUE,+G22*F22,0)","v":0},{"$f":"+F22-H22","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D22*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P22=TRUE,+M22*L22,0)","v":0},{"$f":"+L22-N22","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D22*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V22=TRUE,+S22*R22,0)","v":0},{"$f":"+R22-T22","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D22*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB22=TRUE,+Y22*X22,0)","v":0},{"$f":"+X22-Z22","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+$D22*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH22=TRUE,+AE22*AD22,0)","v":0},{"$f":"+AD22-AF22","v":{"$error":"#DIV/0!"}},false]
[null,{"$f":"+Resultaat!C16","v":"1.3"},{"$f":"+Resultaat!D16","v":"Onteigenen van onroerende zaken"},{"$f":"+Resultaat!F16","v":0},null,{"$f":"+D23*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J23=TRUE,+G23*F23,0)","v":0},{"$f":"+F23-H23","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D23*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P23=TRUE,+M23*L23,0)","v":0},{"$f":"+L23-N23","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D23*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V23=TRUE,+S23*R23,0)","v":0},{"$f":"+R23-T23","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D23*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB23=TRUE,+Y23*X23,0)","v":0},{"$f":"+X23-Z23","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+$D23*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH23=TRUE,+AE23*AD23,0)","v":0},{"$f":"+AD23-AF23","v":{"$error":"#DIV/0!"}},false]
[null,{"$f":"+Resultaat!C17","v":"1.4"},{"$f":"+Resultaat!D17","v":"Toepassen Wet voorkeursrecht gemeente"},{"$f":"+Resultaat!F17","v":0},null,{"$f":"+D24*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J24=TRUE,+G24*F24,0)","v":0},{"$f":"+F24-H24","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D24*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P24=TRUE,+M24*L24,0)","v":0},{"$f":"+L24-N24","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D24*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V24=TRUE,+S24*R24,0)","v":0},{"$f":"+R24-T24","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D24*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB24=TRUE,+Y24*X24,0)","v":0},{"$f":"+X24-Z24","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+$D24*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH24=TRUE,+AE24*AD24,0)","v":0},{"$f":"+AD24-AF24","v":{"$error":"#DIV/0!"}},false]
[]
[null,null,{"$f":"+Resultaat!D19","v":"Stedenbouw"},{"$f":"+Resultaat!F19","v":0},null,{"$f":"SUM(F27:F32)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(H27:H32)","v":0},{"$f":"SUM(I27:I32)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(L27:L32)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(N27:N32)","v":0},{"$f":"SUM(O27:O32)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(R27:R32)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(T27:T32)","v":0},{"$f":"SUM(U27:U32)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X27:X32)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(Z27:Z32)","v":0},{"$f":"SUM(AA27:AA32)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AD27:AD32)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(AF27:AF32)","v":0},{"$f":"SUM(AG27:AG32)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Resultaat!C20","v":"2.1"},{"$f":"+Resultaat!D20","v":"Programma van Eisen"},{"$f":"+Resultaat!F20","v":0},null,{"$f":"+D27*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J27=TRUE,+G27*F27,0)","v":0},{"$f":"+F27-H27","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D27*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P27=TRUE,+M27*L27,0)","v":0},{"$f":"+L27-N27","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D27*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V27=TRUE,+S27*R27,0)","v":0},{"$f":"+R27-T27","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D27*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB27=TRUE,+Y27*X27,0)","v":0},{"$f":"+X27-Z27","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D27*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH27=TRUE,+AE27*AD27,0)","v":0},{"$f":"+AD27-AF27","v":{"$error":"#DIV/0!"}},false]
[null,{"$f":"+Resultaat!C21","v":"2.2"},{"$f":"+Resultaat!D21","v":"Prijsvraag"},{"$f":"+Resultaat!F21","v":0},null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false]
[null,{"$f":"+Resultaat!C22","v":"2.3"},{"$f":"+Resultaat!D22","v":"Masterplan"},{"$f":"+Resultaat!F22","v":0},null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false]
[null,{"$f":"+Resultaat!C23","v":"2.4"},{"$f":"+Resultaat!D23","v":"Beeldkwaliteitsplan"},{"$f":"+Resultaat!F23","v":0},null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false]
[null,{"$f":"+Resultaat!C24","v":"2.5"},{"$f":"+Resultaat!D24","v":"Stedenbouwkundig plan"},{"$f":"+Resultaat!F24","v":0},null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false]
[null,{"$f":"+Resultaat!C25","v":"2.6"},{"$f":"+Resultaat!D25","v":"Inrichtingsplan Openbare ruimte"},{"$f":"+Resultaat!F25","v":0},null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false,null,{"$error":"#DIV/0!"},"…%",0,{"$error":"#DIV/0!"},false]
[]
[null,null,{"$f":"+Resultaat!D27","v":"Ruimtelijke Ordening"},{"$f":"+Resultaat!F27","v":0},null,{"$f":"SUM(F35:F37)","v":{"$error":"#DIV/0!"}},"Maximaal 60%",{"$f":"SUM(H35:H37)","v":0},{"$f":"SUM(I35:I37)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(L35:L37)","v":{"$error":"#DIV/0!"}},"Maximaal 60%",{"$f":"SUM(N35:N37)","v":0},{"$f":"SUM(O35:O37)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(R35:R37)","v":{"$error":"#DIV/0!"}},"Maximaal 60%",{"$f":"SUM(T35:T37)","v":0},{"$f":"SUM(U35:U37)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X35:X37)","v":{"$error":"#DIV/0!"}},"Maximaal 60%",{"$f":"SUM(Z35:Z37)","v":0},{"$f":"SUM(AA35:AA37)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AD35:AD37)","v":{"$error":"#DIV/0!"}},"Maximaal 60%",{"$f":"SUM(AF35:AF37)","v":0},{"$f":"SUM(AG35:AG37)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Resultaat!C28","v":"3.1"},{"$f":"+Resultaat!D28","v":"Opstellen en procedure bestemmingsplan, omgevingsvergunning of projectuitvoeringsbesluit"},{"$f":"+Resultaat!F28","v":0},null,{"$f":"+D35*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J35=TRUE,+G35*F35,0)","v":0},{"$f":"+F35-H35","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D35*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P35=TRUE,+M35*L35,0)","v":0},{"$f":"+L35-N35","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D35*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V35=TRUE,+S35*R35,0)","v":0},{"$f":"+R35-T35","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D35*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB35=TRUE,+Y35*X35,0)","v":0},{"$f":"+X35-Z35","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D35*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH35=TRUE,+AE35*AD35,0)","v":0},{"$f":"+AD35-AF35","v":{"$error":"#DIV/0!"}},false]
[null,{"$f":"+Resultaat!C29","v":"3.2"},{"$f":"+Resultaat!D29","v":"Opstellen en procedure wijzigingsplan"},{"$f":"+Resultaat!F29","v":0},null,{"$f":"+D36*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J36=TRUE,+G36*F36,0)","v":0},{"$f":"+F36-H36","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D36*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P36=TRUE,+M36*L36,0)","v":0},{"$f":"+L36-N36","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D36*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V36=TRUE,+S36*R36,0)","v":0},{"$f":"+R36-T36","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D36*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB36=TRUE,+Y36*X36,0)","v":0},{"$f":"+X36-Z36","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D36*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH36=TRUE,+AE36*AD36,0)","v":0},{"$f":"+AD36-AF36","v":{"$error":"#DIV/0!"}},false]
[null,{"$f":"+Resultaat!C30","v":"3.3"},{"$f":"+Resultaat!D30","v":"Opstellen en procedure exploitatieplan"},{"$f":"+Resultaat!F30","v":0},null,{"$f":"+D37*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J37=TRUE,+G37*F37,0)","v":0},{"$f":"+F37-H37","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D37*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P37=TRUE,+M37*L37,0)","v":0},{"$f":"+L37-N37","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D37*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V37=TRUE,+S37*R37,0)","v":0},{"$f":"+R37-T37","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D37*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB37=TRUE,+Y37*X37,0)","v":0},{"$f":"+X37-Z37","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D37*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH37=TRUE,+AE37*AD37,0)","v":0},{"$f":"+AD37-AF37","v":{"$error":"#DIV/0!"}},false]
[]
[null,null,{"$f":"+Resultaat!D32","v":"Civiele en cultuur techniek "},{"$f":"+Resultaat!F32","v":0},null,{"$f":"SUM(F40:F41)","v":{"$error":"#DIV/0!"}},"Maximaal 80%",{"$f":"SUM(H40:H41)","v":0},{"$f":"SUM(I40:I41)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(L40:L41)","v":{"$error":"#DIV/0!"}},"Maximaal 80%",{"$f":"SUM(N40:N41)","v":0},{"$f":"SUM(O40:O41)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(R40:R41)","v":{"$error":"#DIV/0!"}},"Maximaal 80%",{"$f":"SUM(T40:T41)","v":0},{"$f":"SUM(U40:U41)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X40:X41)","v":{"$error":"#DIV/0!"}},"Maximaal 80%",{"$f":"SUM(Z40:Z41)","v":0},{"$f":"SUM(AA40:AA41)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AD40:AD41)","v":{"$error":"#DIV/0!"}},"Maximaal 80%",{"$f":"SUM(AF40:AF41)","v":0},{"$f":"SUM(AG40:AG41)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Resultaat!C33","v":"4.1"},{"$f":"+Resultaat!D33","v":"Planontwikkeling"},{"$f":"+Resultaat!F33","v":0},null,{"$f":"+D40*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J40=TRUE,+G40*F40,0)","v":0},{"$f":"+F40-H40","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D40*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P40=TRUE,+M40*L40,0)","v":0},{"$f":"+L40-N40","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D40*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V40=TRUE,+S40*R40,0)","v":0},{"$f":"+R40-T40","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D40*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB40=TRUE,+Y40*X40,0)","v":0},{"$f":"+X40-Z40","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D40*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH40=TRUE,+AE40*AD40,0)","v":0},{"$f":"+AD40-AF40","v":{"$error":"#DIV/0!"}},false]
[null,{"$f":"+Resultaat!C34","v":"4.2"},{"$f":"+Resultaat!D34","v":"Voorbereiding, toezicht en directievoering "},{"$f":"+Resultaat!F34","v":0},null,{"$f":"+D41*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J41=TRUE,+G41*F41,0)","v":0},{"$f":"+F41-H41","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D41*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P41=TRUE,+M41*L41,0)","v":0},{"$f":"+L41-N41","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D41*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V41=TRUE,+S41*R41,0)","v":0},{"$f":"+R41-T41","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D41*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB41=TRUE,+Y41*X41,0)","v":0},{"$f":"+X41-Z41","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D41*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH41=TRUE,+AE41*AD41,0)","v":0},{"$f":"+AD41-AF41","v":{"$error":"#DIV/0!"}},false]
[]
[null,null,{"$f":"+Resultaat!D36","v":"Landmeten/vastgoedinformatie"},{"$f":"+Resultaat!F36","v":0},null,{"$f":"SUM(F44)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(H44)","v":0},{"$f":"+I44","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(L44)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(N44)","v":0},{"$f":"+O44","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(R44)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(T44)","v":0},{"$f":"+U44","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X44)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(Z44)","v":0},{"$f":"+AA44","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AD44)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(AF44)","v":0},{"$f":"+AG44","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Resultaat!C37","v":"5.1"},{"$f":"+Resultaat!D37","v":"Kaartmateriaal"},{"$f":"+Resultaat!F37","v":0},null,{"$f":"+D44*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J44=TRUE,+G44*F44,0)","v":0},{"$f":"+F44-H44","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D44*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P44=TRUE,+M44*L44,0)","v":0},{"$f":"+L44-N44","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D44*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V44=TRUE,+S44*R44,0)","v":0},{"$f":"+R44-T44","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D44*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB44=TRUE,+Y44*X44,0)","v":0},{"$f":"+X44-Z44","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D44*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH44=TRUE,+AE44*AD44,0)","v":0},{"$f":"+AD44-AF44","v":{"$error":"#DIV/0!"}},false]
[]
[null,null,{"$f":"+Resultaat!D39","v":"Communicatie"},{"$f":"+Resultaat!F39","v":0},null,{"$f":"+F47","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(H47)","v":0},{"$f":"+I47","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+L47","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(N47)","v":0},{"$f":"+O47","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+R47","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(T47)","v":0},{"$f":"+U47","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+X47","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(Z47)","v":0},{"$f":"+AA47","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+AD47","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(AF47)","v":0},{"$f":"+AG47","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Resultaat!C40","v":"6.1"},{"$f":"+Resultaat!D40","v":"Omgevingsmanagement"},{"$f":"+Resultaat!F40","v":0},null,{"$f":"+D47*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J47=TRUE,+G47*F47,0)","v":0},{"$f":"+F47-H47","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D47*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P47=TRUE,+M47*L47,0)","v":0},{"$f":"+L47-N47","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D47*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V47=TRUE,+S47*R47,0)","v":0},{"$f":"+R47-T47","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D47*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB47=TRUE,+Y47*X47,0)","v":0},{"$f":"+X47-Z47","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D47*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH47=TRUE,+AE47*AD47,0)","v":0},{"$f":"+AD47-AF47","v":{"$error":"#DIV/0!"}},false]
[]
[null,null,{"$f":"+Resultaat!D42","v":"Management"},{"$f":"+Resultaat!F42","v":0},null,{"$f":"SUM(F50:F51)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(H50:H51)","v":0},{"$f":"SUM(I50:I51)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(L50:L51)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(N50:N51)","v":0},{"$f":"SUM(O50:O51)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(R50:R51)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(T50:T51)","v":0},{"$f":"SUM(U50:U51)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(X50:X51)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(Z50:Z51)","v":0},{"$f":"SUM(AA50:AA51)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(AD50:AD51)","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"SUM(AF50:AF51)","v":0},{"$f":"SUM(AG50:AG51)","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Resultaat!C43","v":"7.1"},{"$f":"+Resultaat!D43","v":"Projectmanagement"},{"$f":"+Resultaat!F43","v":0},null,{"$f":"+D50*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J50=TRUE,+G50*F50,0)","v":0},{"$f":"+F50-H50","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D50*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P50=TRUE,+M50*L50,0)","v":0},{"$f":"+L50-N50","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D50*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V50=TRUE,+S50*R50,0)","v":0},{"$f":"+R50-T50","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D50*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB50=TRUE,+Y50*X50,0)","v":0},{"$f":"+X50-Z50","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D50*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH50=TRUE,+AE50*AD50,0)","v":0},{"$f":"+AD50-AF50","v":{"$error":"#DIV/0!"}},false]
[null,{"$f":"+Resultaat!C44","v":"7.2"},{"$f":"+Resultaat!D44","v":"Projectmanagementassistentie"},{"$f":"+Resultaat!F44","v":0},null,{"$f":"+D51*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J51=TRUE,+G51*F51,0)","v":0},{"$f":"+F51-H51","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D51*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P51=TRUE,+M51*L51,0)","v":0},{"$f":"+L51-N51","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D51*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V51=TRUE,+S51*R51,0)","v":0},{"$f":"+R51-T51","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D51*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB51=TRUE,+Y51*X51,0)","v":0},{"$f":"+X51-Z51","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+$D51*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH51=TRUE,+AE51*AD51,0)","v":0},{"$f":"+AD51-AF51","v":{"$error":"#DIV/0!"}},false]
[]
[null,null,{"$f":"+Resultaat!D46","v":"Planeconomie"},{"$f":"+Resultaat!F46","v":0},null,{"$f":"+F54","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"+H54","v":0},{"$f":"+I54","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+L54","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"+N54","v":0},{"$f":"+O54","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+R54","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"+T54","v":0},{"$f":"+U54","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+X54","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"+Z54","v":0},{"$f":"+AA54","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+AD54","v":{"$error":"#DIV/0!"}},"Maximaal 90%",{"$f":"+AF54","v":0},{"$f":"+AG54","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"+Resultaat!C47","v":"8.1"},{"$f":"+Resultaat!D47","v":"Planeconomie"},{"$f":"+Resultaat!F47","v":0},null,{"$f":"+D54*$F$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(J54=TRUE,+G54*F54,0)","v":0},{"$f":"+F54-H54","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D54*L$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(P54=TRUE,+M54*L54,0)","v":0},{"$f":"+L54-N54","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D54*R$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(V54=TRUE,+S54*R54,0)","v":0},{"$f":"+R54-T54","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D54*X$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AB54=TRUE,+Y54*X54,0)","v":0},{"$f":"+X54-Z54","v":{"$error":"#DIV/0!"}},false,null,{"$f":"+$D54*AD$18","v":{"$error":"#DIV/0!"}},"…%",{"$f":"IF(AH54=TRUE,+AE54*AD54,0)","v":0},{"$f":"+AD54-AF54","v":{"$error":"#DIV/0!"}},false]
[]
[null,null,{"$f":"+Resultaat!D49","v":"totaal"},{"$f":"+Resultaat!F49","v":0},null,{"$f":"F53+F49+F46+F43+F39+F34+F26+F20","v":{"$error":"#DIV/0!"}},null,{"$f":"H53+H49+H46+H43+H39+H34+H26+H20","v":0},{"$f":"I53+I49+I46+I43+I39+I34+I26+I20","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L53+L49+L46+L43+L39+L34+L26+L20","v":{"$error":"#DIV/0!"}},null,{"$f":"N53+N49+N46+N43+N39+N34+N26+N20","v":0},{"$f":"O53+O49+O46+O43+O39+O34+O26+O20","v":{"$error":"#DIV/0!"}},null,null,{"$f":"R53+R49+R46+R43+R39+R34+R26+R20","v":{"$error":"#DIV/0!"}},null,{"$f":"T53+T49+T46+T43+T39+T34+T26+T20","v":0},{"$f":"U53+U49+U46+U43+U39+U34+U26+U20","v":{"$error":"#DIV/0!"}},null,null,{"$f":"X53+X49+X46+X43+X39+X34+X26+X20","v":{"$error":"#DIV/0!"}},null,{"$f":"Z53+Z49+Z46+Z43+Z39+Z34+Z26+Z20","v":0},{"$f":"AA53+AA49+AA46+AA43+AA39+AA34+AA26+AA20","v":{"$error":"#DIV/0!"}},null,null,{"$f":"AD53+AD49+AD46+AD43+AD39+AD34+AD26+AD20","v":{"$error":"#DIV/0!"}},null,{"$f":"AF53+AF49+AF46+AF43+AF39+AF34+AF26+AF20","v":0},{"$f":"AG53+AG49+AG46+AG43+AG39+AG34+AG26+AG20","v":{"$error":"#DIV/0!"}}]