{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Titel","Invulinstructie","Vragenlijst","Produktenlijst","Resultaat","Bijdrage per eigenaar","Hulpblad"],"not_rendered":{"charts":0,"images":95,"macros":1,"external_links":0,"defined_names":15,"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":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Rekenmodel voor het berekenen van de plankosten"]
[null,null,null,"bij kostenverhaal met tijdvak 2024-2"]
[]
[null,null,null,"Dit rekenmodel kan worden toegepast bij omgevingsplannen, projectbesluiten en omgevingsvergunningen voor buitenplanse omgevingsplanactiviteiten "]
[null,null,null,"waarover na 1 oktober 2024 een besluit wordt genomen. Het rekenmodel bevat de nieuwe, geindexeerde tarieven voor de plankosten"]
[null,null,null,"die op 29 december 2023 bekend zijn gemaakt in de Staatscourant."]
[null,null,null,"In het rekenmodel is ook de voorgenomen wijziging van het hoofdstuk kostenverhaal van de Omgevingsregeling verwerkt."]

{"sheet":"Invulinstructie","index":1,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Uitgangspunten plankostenregels kostenverhaal MET tijdvak"]
[]
[null,null,"De plankosten worden bepaald voor de voorbereiding en ontwikkeling van het gehele kostenverhaalsgebied zoals dat in het Omgevingsplan is aangewezen."]
[null,null,"Het bedrag van de plankosten dat met behulp van dit rekenmodel wordt berekend, s het maximum van de te verhalen plankosten in het kostenverhaalsgebied als geheel."]
[]
[null,"Let op"]
[null,null,"De plankosten voor het aanleggen van bovenwijkse voorzieningen worden NIET met deze regeling geraamd, maar worden separaat in de kostenverhaalsregels opgenomen (artikel 13.1 Or)."]
[null,null,"De plankosten voor het (laten) uitvoeren van onderzoeken ten behoeve van het Omgevingsplan worden NIET met deze regeling geraamd maar worden separaat in de kostenverhaalsregels opgenomen (artikel 13.1 Or)."]
[]
[null,null,"De plankosten die te maken hebben met individuele  dienstverlening  (lees aanvraag omgevingsvergunning) worden NIET via deze regeling geraamd maar worden via de legesverordening berekend."]
[]
[null,null,"Het systeem berekent zelf over hoeveer jaren plankosten die voorafgaand aan de vaststelling van het omgevingsplan zijn gemaakt mogen worden doorberekend (artikel 13.3 Or)"]
[]
[null,null,"Dit rekenmodel wordt niet gebruikt bij kleine plannen. Dat zijn plannen voor het bouwen, verbouwen of uitbreiden van gebouwen met een klein oppervlakte (artikel 13.5 Or)."]
[]
[]
[null,"Invulinstructie"]
[null,null,"Om het kostenverhaal te bepalen bij het kostenverhaalsgebied zoals dat in het Omgevingsplan is aangegeven worden de volgende stappen gezet:"]
[]
[null,"vragenlijst","1e stap","Alle vragen in de vragenlijst beantwoorden. De gemeente heeft een actieve rol."]
[]
[null,"produktenlijst","2e stap","Met de button op de produktenlijst moeten de antwoorden uit de vragenlijst opgehaald worden. "]
[]
[null,"resultaat","3e stap","In het resultaatblad is het bedrag aan plankosten te zien dat onderdeel is van de kostenverhaalsregel in het Omgevingsplan."]
[null,"bijdrage per eigenaar","4e stap","Wanneer blijkt dat de eigenaar van de grond bepaalde werkzaamheden zelf heeft uitgevoerd, met goedkeuring van de gemeente  is artikel 13.8  van toepassing ('plankosten bij zelfrealisatie'). "]
[null,"bijdrage per eigenaar",null,"In dit tabblad is het ook mogelijk de plankosten per eigenaar te bepalen, eventueel met toepassing van artikel 13.8 Or."]
[]
[null,null,"Overige"]
[null,"vragenlijst",null,"In de kolommen M tm O in het tabblad vragenlijst kunnen notities worden opgenomen."]
[null,"hulpblad",null,"In het hulpblad zijn enkele kengetallen weergegeven en is de berekening van de vtu kosten bij sloop, ophogen/voorbelasten en bouw-en woonrijpmaken te zien."]
[]
[]
[]
[]
[null,null,"Ministerie van Binnenlandse Zaken en Koninkrijksrelaties"]

{"sheet":"Vragenlijst","index":2,"n_rows":148,"n_cols":25,"rows_kept":148,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"deze kolommen worden verborgen, en zijn niet opvraagbaar"]
[null,null,"Plankostenregels bij kostenverhaal MET tijdvak"]
[]
[null,null,"Vragenlijst "]
[null,null,null,null,"Datum",{"$f":"TODAY()","v":"2024-02-28"}]
[null,null,null,null,"Gemeente:","…."]
[null,null,null,null,"Projectnaam:","…."]
[null,null,null,null,"Kostenverhaalsgebied:","…."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"AANTEKENINGEN"]
[]
[null,null,null,null,"Algemeen"]
[]
[null,null,null,1,"Wat is de looptijd van het project vanaf het moment van vaststellen van het ruimtelijk besluit ?",null,null,null,"jaar",null,null,{"$f":"+D19","v":1},"aantekeningen",null,null,null,{"$f":"+H19","v":0}]
[null,null,null,null,"De voorbereidingstijd wordt door het systeem zelf berekend",null,null,"de totale looptijd van het project is dan",null,{"$f":"IF(H19>0,+Q20+H19,0)","v":0},"jaar",null,null,null,null,null,{"$f":"+IF(Produktenlijst!M14<=130%,2,IF(Produktenlijst!M14<150%,3,IF(Produktenlijst!M14>=150%,4,0)))","v":2},"jaar voorbereidingstijd"]
[]
[]
[null,null,null,2,"Wat is de omvang van het kostenverhaalsgebied ?",null,null,null,"m2",{"$f":"+H23/10000","v":0},"ha",{"$f":"+D23","v":2},"aantekeningen",null,null,null,{"$f":"+H23/10000","v":0},"ha"]
[null,null,null,null,"Exclusief te handhaven percelen"]
[]
[null,null,null,3,"Wat voor een kostenverhaalsgebied is het?",null,null,null,null,null,null,{"$f":"+D26","v":3},"aantekeningen",null,null,null,false,false,false,false,false,{"$f":"+IF(Q26=TRUE,1,IF(R26=TRUE,0.5,IF(S26=TRUE,0.25,0)))","v":0},"IF I"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(Q26=TRUE,\"historisch\", \"\")","v":""},{"$f":"+IF(R26=TRUE,\"binnenstedelijk\", \"\")","v":""},{"$f":"+IF(S26=TRUE,\"inbreiding\", \"\")","v":""},{"$f":"+IF(T26=TRUE,\"uitbreiding\", \"\")","v":""},{"$f":"+IF(U26=TRUE,\"uitleg\", \"\")","v":""}]
[null,null,null,4,"Betreft het een herstructurerings/transformatie opgave ?",null,null,null,null,null,null,{"$f":"+D30","v":4},"aantekeningen",null,null,null,false,false,null,null,null,{"$f":"IF(Q30=TRUE,1.5,0)","v":0},"IF II"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(Q30=TRUE,\"herstructurering/transformatie\", \"\")","v":""}]
[]
[null,null,null,5,"Zijn de volgende onderzoeken nodig voor het kostenverhaalsgebied?",null,null,null,null,null,null,{"$f":"+D33","v":5},"aantekeningen",null,null,null,false,{"$f":"+IF(Q33=TRUE,\"MER\", \"\")","v":""},null,null,{"$f":"+IF(Q33=TRUE,0.5,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"+IF(Q34=TRUE,\" /Nader luchtonderzoek/\", \"\")","v":""},null,null,{"$f":"+IF(Q34=TRUE,0.4,0)","v":0},{"$f":"+MAX(U33:U36)","v":0},"IF V"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"+IF(Q35=TRUE,\" Aanvullend archeologisch onderzoek \", \"\")","v":""},null,null,{"$f":"+IF(Q35=TRUE,0.3,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(Q147=TRUE,0.2,0)","v":0},{"$f":"IF(U36>0,\"bodemsanering\",\"\")","v":""}]
[]
[]
[]
[null,null,null,6,"Wat zijn de (maximaal) beoogde kostenverhaalsplichtige bouwactiviteiten ?","woonfunctie",null,null,"aantal",null,null,{"$f":"+D40","v":6},"aantekeningen",null,null,null,{"$f":"+H40","v":0},{"$f":"IF(Q40>1,1,0)","v":0},{"$f":"IF(Q40>0,F40,\"\")","v":""},null,{"$f":"+IF(R45>1,0.1,0)*R40","v":0}]
[null,null,null,null,null,"(lichte) industriefunctie",null,null,"m2 uitgeefbaar",null,null,null,null,null,null,null,{"$f":"+H41","v":0},{"$f":"IF(Q41>1,1,0)","v":0},{"$f":"IF(Q41>0,F41,\"\")","v":""},null,{"$f":"+IF(R45>1,0.1,-0.25)*R41","v":0}]
[null,null,null,null,null,"kantoorfunctie/winkelfunctie/sportfunctie",null,null,"m2 bvo",null,null,null,null,null,null,null,{"$f":"+H42","v":0},{"$f":"IF(Q42>1,1,0)","v":0},"",null,{"$f":"0.1*R42","v":0},{"$f":"SUM(U40:U44)","v":0},"IF IV"]
[null,null,null,null,null,"gezondheidszorgfunctie/onderwijsfunctie",null,null,"m2 bvo",null,null,null,null,null,null,null,{"$f":"+H43","v":0},{"$f":"IF(Q43>1,1,0)","v":0},"",null,{"$f":"0.25*R43","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q41:Q44)","v":0},{"$f":"SUM(R40:R44)","v":0}]
[null,null,null,null,"De dichtheid is",{"$f":"IF(H23>0,+(H40+((H41+H42+H43)/100))/H23*10000,0)","v":0},null,"won(equivalent) per ha: ",{"$f":"IF(F46<31,\"suburbaan\",IF(F46>100,\"hoogstedelijk\",\"stedelijk\"))","v":"suburbaan"},"woon-werkmlieu"]
[]
[]
[null,null,null,7,"Hoeveel  m2 openbaar gebied  wordt in het kostenverhaalsgebied aangelegd? ",{"$f":"IF(H49>0,H49/H23,0)","v":0},null,null,"m2 openbaar gebied (groen, verharding en water)",null,null,{"$f":"+D49","v":7},"aantekeningen",null,null,null,{"$f":"IF(F49>40%,F49/40%,1)","v":1}]
[null,null,null,"a","Hoeveel hiervan is m2 verharding?",null,null,null,"m2 verharding",{"$f":"IF(H50>0,H50/H49,0)","v":0}]
[null,null,null,null,"Dus is hiervan m2 groen/water:",null,null,{"$f":"+H49-H50","v":0},"m2 groen/water",{"$f":"IF(H51>0,H51/H49,0)","v":0}]
[]
[]
[null,null,null,8,"Stelt de gemeente bij het Omgevingsplan ook de volgende plannen op?",null,null,null,null,null,null,{"$f":"+D54","v":8},"aantekeningen",null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
[]
[null,null,null,null,"Omgevingsrecht"]
[]
[null,null,null,9,"Welk type plan wordt opgesteld?",null,null,null,null,null,null,{"$f":"+D62","v":9},"aantekeningen",null,null,null,false,false,false]
[]
[]
[]
[null,null,null,10,"Maakt dit kostenverhaalsbesluit deel uit van een groter Omgevingsplan ? ",null,null,null,null,null,null,{"$f":"+D66","v":10},"aantekeningen",null,null,null,false,false]
[null,null,null,null,"zo ja, wat is de verhouding in oppervlakte ten opzichte van dit Omgevingsplan ?",null,null,null,"% van het totale Omgevingsplan",null,null,null,null,null,null,null,{"$f":"+H67","v":0},{"$f":"+J23/Q67","v":{"$error":"#DIV/0!"}},"ha"]
[null,null,null,null,"Het totale Omgevingsplan is dus",{"$f":"IF(H67>0,J23/Q67,J23)","v":0},null,"ha groot"]
[]
[]
[null,null,null,null,"Inbreng en verwerving van onroerende zaken "]
[null,null,null,null,null,null,null,"Waardering via Wet WOZ",null,"via onafhankelijke taxatie"]
[null,null,null,11,"Uit hoeveel kadastrale percelen bestaat het kostenverhaalsgebied en hoeveel daarvan zijn onbebouwd en bebouwd?",null,null,null,"totaal",null,"totaal",{"$f":"+D73","v":11},"aantekeningen",null,null,null,{"$f":"+J73+H73","v":0}]
[null,null,null,"a","aantal onbebouwde percelen",null,"a",null,"stuks",null,"stuks"]
[null,null,null,"b","aantal bebouwde percelen",null,"b",null,"stuks",null,"stuks"]
[null,null,null,null,null,null,null,{"$f":"IF(SUM(H74:H75)<>H73,\"a+b <> totaal\",\"\")","v":""},{"$f":"IF(AND(H73>0,J73>0),\"klopt dit?\",\"\")","v":""},{"$f":"IF(SUM(J74:J75)<>J73,\"a+b<> totaal\",\"\")","v":""}]
[null,null,null,12,"Hoeveel onroerende zaken is de gemeente van plan daadwerkelijk te verwerven ?",null,null,null,"totaal",null,null,{"$f":"+D77","v":12},"aantekeningen",null,null,null,{"$f":"+H77","v":0}]
[null,null,null,"a","waarvan onbebouwde percelen",null,"a",null,"stuks"]
[null,null,null,"b","waarvan gebouwen met een woonfunctie",null,"b",null,"stuks"]
[null,null,null,"c","waarvan gebouwen met een industriefunctie, winkelfunctie of kantoorfunctie ",null,"c",null,"stuks"]
[null,null,null,"d","waarvan bijzondere objecten",null,"d",null,"stuks"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H78:H81)<>H77,\"a+b+c+d<> totaal\",\"\")","v":""}]
[null,null,null,13,"Van hoeveel huur(pacht)ontbindingen is sprake ?",null,null,null,"stuks",null,null,{"$f":"+D83","v":13},"aantekeningen"]
[]
[null,null,null,14,"Indien er met een onteigeningsplan wordt gewerkt  ",null,null,null,null,null,null,{"$f":"+D85","v":14},"aantekeningen"]
[null,null,null,"a","voor hoeveel onroerende zaken wordt een onteigeningsbeschikking voorbereid?",{"$f":"IF(H86>H77,\"meer dan aantal verwervingen?\",\"\")","v":""},"a",null,"stuks",null,null,null,null,null,null,null,{"$f":"+H86","v":0}]
[null,null,null,"b","in hoeveel van die gevallen komt het tot een bekrachtingsprocedure onteigeningsbeschikking ?",{"$f":"IF(H87>H86,\"meer dan 14a?\",\"\")","v":""},"b",null,"stuks",null,null,null,null,null,null,null,{"$f":"+H87","v":0},null,null,{"$f":"IF(H87=1,0.1,(IF(H87>1,0.2,0)))","v":0},"IF III"]
[]
[]
[null,null,null,15,"Wordt of is een voorkeursrecht gevestigd ?",null,null,null,null,null,null,{"$f":"+D90","v":15},"aantekeningen",null,null,null,false,false,{"$f":"+IF(Q90=TRUE,1,0)","v":0}]
[]
[]
[]
[null,null,null,null,"Civiele en cultuurtechniek ten behoeve van uitvoering van het omgevingsplan"]
[]
[]
[null,null,null,null,"Slopen"]
[]
[null,null,null,16,"Is sprake van sloop van onroerende zaken ?",null,null,null,null,null,null,{"$f":"+D99","v":16},"aantekeningen",null,null,null,false,false,null,{"$f":"IF(Q99=TRUE,1,0)","v":0}]
[null,null,null,null,null,{"$f":"+IF(R99=TRUE,\"ga door naar vraag 17\",\"\")","v":""}]
[null,null,null,"a","Zo ja, hoeveel m3 moet er gesloopt worden ?",null,null,null,"m3",null,null,null,null,null,null,null,null,null,null,{"$f":"+H101","v":0}]
[]
[null,null,null,"b","Wat voor een soort te slopen onroerende zaken zijn het?  Het gaat hoofdzakelijk om:"]
[null,null,null,null,"Meerdere antwoorden zijn mogelijk",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invloedsfactor ",null,{"$f":"+AVERAGE(W105:W106)","v":0}]
[null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,false,{"$f":"+H105/100","v":0},null,null,null,{"$f":"IF(Q105=TRUE,-1,0)","v":0},{"$f":"+V105*R105","v":0}]
[null,null,null,null,{"$f":"IF(AND(Q105=FALSE,R105>0),\"aanvinken \",\"\")","v":""},null,null,null,{"$f":"IF(AND(Q105=TRUE,R105=0),\"% invullen\",\"\")","v":""},null,null,null,null,null,null,null,false,{"$f":"+H107/100","v":0},null,null,null,{"$f":"IF(Q106=TRUE,0,0)","v":0},{"$f":"+V106*R106","v":0}]
[null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,{"$f":"SUM(R105:R106)","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(Q106=FALSE,R106>0),\"aanvinken \",\"\")","v":""},null,null,{"$f":"IF(AND(Q99=TRUE,H105+H107<>100),\" het totaal is meer of minder dan 100%\",\"\")","v":""}]
[null,null,null,"c","In hoeveel bestekken worden deze m3 gesloopt?",{"$f":"IF(AND(Q99=TRUE,H109=0),\"invullen \",\"\")","v":""},null,null,{"$f":"IF(H109>0,H101/H109,\"\")","v":""},{"$f":"IF(H109>0,\"m3 gemiddeld per bestek\",\"\")","v":""},null,null,null,null,null,null,{"$f":"+H109","v":0}]
[null,null,null,null,{"$f":"IF(R111=TRUE,\"ga door naar vraag 16f\",\"\")","v":""}]
[null,null,null,"d","Is er sprake van asbest in de te slopen onroerende zaken?",null,null,null,null,null,null,null,null,null,null,null,false,false,null,{"$f":"+IF(Q111=TRUE,1,0)","v":0}]
[null,null,null,"e","Zo ja, in hoeveel procent van het totaal aantal te slopen m3 is sprake van asbest ? ",null,null,null,"%",{"$f":"IF(AND(Q111=FALSE,T112>0),\"er is geen sprake van asbest\",\"\")","v":""},{"$f":"IF(AND(Q111=TRUE,T112>100%),\"meer dan 100%\",\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"+H112/100","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(T111=1,T112<=0),\"percentage invullen \",\"\")","v":""}]
[null,null,null,"f","Op welke wijze wordt het slopen aanbesteed ?",null,null,"procentueel aantal aanbestedingen",null,null,null,null,null,null,null,null,null,null,null,null,null,"IF",null,{"$f":"IF(Q99=TRUE,AVERAGE(W115:W119),0)","v":0}]
[null,null,null,null,"Meerdere antwoorden zijn mogelijk",null,null,null,"%",null,null,null,null,null,null,null,false,{"$f":"+H115","v":0},null,null,null,{"$f":"IF(Q115=TRUE,0,0)","v":0},{"$f":"V115*(R115/R118)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF(AND(Q115=FALSE,R115>0),\"aanvinken \",\"\")","v":""},null,null,{"$f":"IF(AND(Q115=TRUE,R115=0),\"percentage invullen\",\"\")","v":""},null,null,null,null,null,null,null,null,false,{"$f":"+H117","v":0}]
[null,null,null,null,{"$f":"IF(AND(Q116=FALSE,R116>0),\"aanvinken \",\"\")","v":""},null,null,null,"%",null,null,null,null,null,null,null,false,{"$f":"+H119","v":0},null,null,null,{"$f":"IF(Q116=TRUE,0.25,0)","v":0},{"$f":"V117*(R116/R118)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(Q116=TRUE,R116=0),\"percentage invullen\",\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(R115:R117)","v":0}]
[null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q117=TRUE,1,0)","v":0},{"$f":"V119*(R117/R118)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF(AND(Q117=FALSE,R117>0),\"aanvinken \",\"\")","v":""},null,null,{"$f":"IF(AND(Q117=TRUE,R117=0),\"percentage invullen\",\"\")","v":""},{"$f":"IF(AND(Q99=TRUE,H119+H117+H115<>100),\"het totaal is meer of minder dan  100%\",\"\")","v":""}]
[]
[null,null,null,null,"Ophogen/voorbelasten"]
[null,null,null,null,{"$f":"IF(R124=TRUE,\" ga door naar vraag 18\",\" \")","v":" "}]
[null,null,null,17,"Is sprake van ophoging danwel voorbelasting ?",null,null,null,null,null,null,{"$f":"+D124","v":17},"aantekeningen",null,null,null,false,false,{"$f":"IF(Q124=TRUE,1,0)","v":0}]
[null,null,null,"a","Wordt er integraal of partieel opgehoogd?",null,null,null,null,null,null,null,null,null,null,null,false,false]
[]
[]
[null,null,null,"b","In hoeveel deelplannen/fasen wordt er opgehoogd/voorbelast?",null,"b",null,"deelplan/fase"]
[null,null,null,"c","Wat is de gemiddelde te verwachten zettingstijd?",null,"c",null,"jaar"]
[null,null,null,"d","Wat is de gemiddelde hoogte van de voorbelasting?",null,"d",null,"m1"]
[]
[]
[null,null,null,null,"Bouw en woonrijpmaken"]
[]
[null,null,null,18,"Is sprake van bouw-en of woonrijpmaken ?",null,null,null,null,null,null,{"$f":"+D135","v":18},"aantekeningen",null,null,null,false,false,null,{"$f":"IF(Q135=TRUE,1,0)","v":0}]
[]
[null,null,null,null,null,{"$f":"IF(R135=TRUE,\" ga door naar de produktenlijst\",\" \")","v":" "}]
[null,null,null,"a","Op welke wijze wordt het bouw-en woonrijpmaken aanbesteed ? ",null,null,"procentueel aantal aanbestedingen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IF",null,{"$f":"IF(Q135=FALSE,0,+AVERAGE(X139:X141))","v":0}]
[null,null,null,null,"Meerdere antwoorden zijn mogelijk",null,null,null,"%",null,null,null,null,null,null,null,false,{"$f":"+H139","v":0},null,null,null,null,{"$f":"IF(Q139=TRUE,0,0)","v":0},{"$f":"W139*(R139/R142)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF(AND(Q139=FALSE,R139>0),\"aanvinken \",\"\")","v":""},null,null,{"$f":"IF(AND(Q139=TRUE,R139=0),\"percentage invullen \",\"\")","v":""},null,null,null,null,null,null,null,null,false,{"$f":"+H141","v":0},null,null,null,null,{"$f":"IF(Q140=TRUE,0.25,0)","v":0},{"$f":"W140*(R140/R142)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF(AND(Q140=FALSE,R140>0),\"aanvinken \",\"\")","v":""},null,null,null,"%",null,null,null,null,null,null,null,false,{"$f":"+H143","v":0},null,null,null,null,{"$f":"IF(Q141=TRUE,1,0)","v":0},{"$f":"W141*(R141/R142)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(Q140=TRUE,R140=0),\"percentage invullen \",\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(R139:R141)","v":0}]
[null,null,null,null,{"$f":"IF(AND(Q141=FALSE,R141>0),\"aanvinken \",\"\")","v":""},null,null,null,"%"]
[null,null,null,null,null,null,null,{"$f":"IF(AND(Q141=TRUE,R141=0),\"percentage invullen \",\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(AND(Q135=TRUE,H143+H141+H139<>100),\" het totaal is meer of minder dan 100%\",\"\")","v":""}]
[]
[null,null,null,"b","Is er sprake van bodemsanering ? ",null,null,null,{"$f":"IF(AND(Q147=TRUE,S148>100),\"fout\",\" \")","v":" "},null,null,null,null,null,null,null,false,false,null,{"$f":"IF(Q147=TRUE,1,0)","v":0}]
[null,null,null,"c","Zo ja, in hoeveel procent van het openbaar gebied is hier sprake van ? ",{"$f":"IF(AND(Q147=TRUE,S148=0),\"% aangeven\",\"\")","v":""},null,null,"%",null,{"$f":"IF(AND(Q147=FALSE,S148>0),\"zet vraag 18 b op ja\",\"\")","v":""},null,null,null,null,null,null,null,{"$f":"+H148","v":0}]

{"sheet":"Produktenlijst","index":3,"n_rows":131,"n_cols":22,"rows_kept":131,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"+Vragenlijst!C7","v":"Plankostenregels bij kostenverhaal MET tijdvak"},null,null,null,null,null,"Invloedsfactoren :",null,"omschrijving:",null,null,null,null,"Tarieven na 1 oktober 2024 excl btw","€€/uur",null,"Tarieven na 1 oktober 2024 excl btw","€€/uur"]
[null,null,null,null,"Produkten/werkzaamheden",null,null,null,null,null,"I Ligging kostenverhaalsgebied",{"$f":"+Vragenlijst!V26","v":0},{"$f":"+Hulpblad!F59","v":""},null,null,null,null,"Beleidsafdelingen",151,null,"Bestekschrijven/calculeren",119]
[null,null,null,null,null,null,null,null,null,null,"II Type opgave",{"$f":"+Vragenlijst!V30","v":0},{"$f":"+Vragenlijst!Q31","v":""},null,null,null,null,"Communicatie",132,null,"Civiel technische ontwerpen",151]
[null,null,null,null,"Datum",null,{"$f":"+Vragenlijst!F10","v":"2024-02-28"},null,null,null,"III Verwervingssituatie",{"$f":"+Vragenlijst!T87","v":0},{"$f":"+Vragenlijst!Q87","v":0},"onteigeningsbeschikking(en)",null,null,null,"Civiel technisch projectleiden",151,null,"Civiel technisch tekenen",107]
[null,null,null,null,"Gemeente:",null,{"$f":"+Vragenlijst!F11","v":"…."},null,null,null,"IV Type programma",{"$f":"+Vragenlijst!V42","v":0},{"$f":"CONCATENATE(Vragenlijst!S40,  Vragenlijst!S41,  Vragenlijst!S42, Vragenlijst!S43)","v":""},null,null,null,null,"Grondzaken",151,null,"Directievoeren",132]
[null,null,null,null,"Projectnaam:",null,{"$f":"+Vragenlijst!F12","v":"…."},null,null,null,"V Onderzoeken",{"$f":"+Vragenlijst!V34","v":0},{"$f":"CONCATENATE(Vragenlijst!R33,  Vragenlijst!R34)","v":""},null,{"$f":"CONCATENATE(Vragenlijst!R35, Vragenlijst!V36)","v":""},null,null,"Landmeten/vastgoedinformatie",119,null,"Toezichthouden",107]
[null,null,null,null,"Kostenverhaalsgebied:",null,{"$f":"+Vragenlijst!F13","v":"…."},null,null,null,"VI Woon-werkmilieu",{"$f":"+IF(Vragenlijst!I46=\"suburbaan\",0%,IF(Vragenlijst!I46=\"stedelijk\",-100%,-150%))","v":0},{"$f":"+Vragenlijst!I46","v":"suburbaan"},null,null,null,null,"Omgevingsrecht",151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Planeconomie",151]
[null,null,null,null,null,null,null,null,null,null,"(I tm V) complexiteitsfactor","algemeen",{"$f":"1+AVERAGE(L7:L11)","v":1},null,null,null,null,"Projectmanagement",171]
[null,null,null,null,null,null,null,null,null,null,"(I,II,V, VI) complexiteitsfactor ","stedenbouw",{"$f":"1+(L7+L8+L11+L12)/4","v":1},null,null,null,null,"Projectmanagementassistentie",119]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stedenbouw",151]
[]
[null,null,null,null,null,null,"Produkten/werkzaamheden",null,null,null,"welke discilines werken aan het produkt?","Aantal","Uren of bedrag ","Tarief","complexiteitsfactor ?",null,null,"Totaal in euro's",{"$f":"S20+S69","v":0},null,"Totaal in uren",{"$f":"V20+V69","v":0}]
[]
[null,"tbv macro",null,null,null,1,"Omgevingsplan, projectbesluit of omgevingsvergunning voor het kostenverhaalsgebied",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S22:S66)","v":0},null,null,{"$f":"SUM(V22:V66)","v":0}]
[]
[null,true,{"$f":"+IF(D22=TRUE,1,0)","v":0},false,null,"A","Opstellen en vaststellen gedetailleerd omgevingsplan",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R23:R28)","v":0},null,null,{"$f":"SUM(U23:U28)","v":0}]
[null,null,null,null,null,null,null,"opstellen en vaststellen omgevingsplan",null,null,"Omgevingsrecht jurist incl digitalisering/kaartmateriaal",{"$f":"+IF(Vragenlijst!Q62=TRUE,100%,0)","v":0},{"$f":"+Hulpblad!I165","v":100},{"$f":"+S12","v":151},"ja",{"$f":"+IF(O23=\"ja\",$M$14,100%)","v":1},null,{"$f":"P23*N23*M23*L23*D22","v":0},null,null,{"$f":"D$22*L23*M23*P23","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",7.4999999999999997E-2,{"$f":"+$M$23*$L$23","v":0},{"$f":"+S14","v":171},"ja",1,null,{"$f":"P24*N24*M24*L24*D$22","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Stedenbouw",0.1,{"$f":"+$M$23*$L$23","v":0},{"$f":"+S16","v":151},"ja",1,null,{"$f":"P25*N25*M25*L25*D$22","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.01,0,{"$f":"+S13","v":151},"ja",1,null,{"$f":"P26*N26*M26*L26*D$22","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Beleidsafdelingen",0.1,0,{"$f":"+S7","v":151},"ja",1,null,{"$f":"P27*N27*M27*L27*D$22","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Communicatie",0.05,0,{"$f":"+S8","v":132},"ja",1,null,{"$f":"P28*N28*M28*L28*D$22","v":0},null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R31:R32)","v":0},null,null,{"$f":"SUM(U31:U32)","v":0}]
[null,null,null,null,null,null,null,"opstellen regels kostenverhaal",null,null,"Grondzaken en planeconomie",{"$f":"+L23","v":0},{"$f":"+Hulpblad!B185","v":38},{"$f":"+S10","v":151},"ja",{"$f":"+IF(O31=\"ja\",$M$14,100%)","v":1},null,{"$f":"P31*N31*M31*L31*D22","v":0},null,null,{"$f":"D$22*L31*M31*P31","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+M31*L31","v":0},{"$f":"+S14","v":171},"ja",{"$f":"+IF(O32=\"ja\",$M$14,100%)","v":1},null,{"$f":"P32*N32*M32*L32*D$22","v":0},null,null,{"$f":"D$22*L32*M32*P32","v":0}]
[]
[]
[null,null,null,null,null,"B","Opstellen en vaststellen projectbesluit of verlenen omgevingsvergunning voor een buitenplanse omgevingsplanactiviteit",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R36:R41)","v":0},null,null,{"$f":"SUM(U36:U41)","v":0}]
[null,null,null,null,null,null,null,"Opstellen en vaststellen projectbesluit of verlenen omgevingsvergunning voor een buitenplanse omgevingsplanactiviteit",null,null,"Omgevingsrecht jurist incl digitalisering/kaartmateriaal",{"$f":"+IF(Vragenlijst!R62=TRUE,1,0)+IF(Vragenlijst!S62=TRUE,100%,0)","v":0},{"$f":"+Hulpblad!B165","v":60},{"$f":"+S12","v":151},"ja",{"$f":"+IF(O36=\"ja\",$M$14,100%)","v":1},null,{"$f":"P36*N36*M36*L36*D22","v":0},null,null,{"$f":"D$22*L36*M36*P36","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",7.4999999999999997E-2,{"$f":"+M$36*L$36","v":0},{"$f":"+S14","v":171},"ja",{"$f":"+IF(O37=\"ja\",$M$14,100%)","v":1},null,{"$f":"P37*N37*M37*L37*D$22","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Stedenbouw",0.1,{"$f":"+M$36*L$36","v":0},{"$f":"+S16","v":151},"ja",1,null,{"$f":"P38*N38*M38*L38*D$22","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.01,0,{"$f":"+S13","v":151},"ja",1,null,{"$f":"P39*N39*M39*L39*D$22","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Beleidsafdelingen",0.1,0,{"$f":"+S7","v":151},"ja",1,null,{"$f":"P40*N40*M40*L40*D$22","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,"Communicatie",0.05,0,{"$f":"+S8","v":132},"ja",1,null,{"$f":"P41*N41*M41*L41*D$22","v":0},null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R44:R45)","v":0},null,null,{"$f":"SUM(U44:U45)","v":0}]
[null,null,null,null,null,null,null,"opstellen regels kostenverhaal",null,null,"Grondzaken en planeconomie",{"$f":"+L36","v":0},{"$f":"+Hulpblad!H185","v":25},{"$f":"+S10","v":151},"ja",{"$f":"+IF(O44=\"ja\",$M$14,100%)","v":1},null,{"$f":"P44*N44*M44*L44*D22","v":0},null,null,{"$f":"D$22*L44*M44*P44","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+M44*L44","v":0},{"$f":"+S14","v":171},"ja",{"$f":"+IF(O45=\"ja\",$M$14,100%)","v":1},null,{"$f":"P45*N45*M45*L45*D$22","v":0},null,null,{"$f":"D$22*L45*M45*P45","v":0}]
[]
[]
[]
[null,{"$f":"+Vragenlijst!Q54","v":false},{"$f":"+IF(D49=TRUE,1,0)","v":0},false,null,"1.2","Stedenbouwkundig plan",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R50:R57)","v":0},null,null,{"$f":"SUM(U50:U57)","v":0}]
[null,null,null,null,null,null,null,"uur per gebouw met een woonfunctie (aantal woningen)",null,null,"Stedenbouw",{"$f":"+Vragenlijst!H40","v":0},2.5,{"$f":"+S16","v":151},"CF stedenbouw",{"$f":"+M15","v":1},null,{"$f":"P50*N50*M50*L50*C49","v":0},null,null,{"$f":"C49*L50*M50*P50","v":0}]
[null,null,null,null,null,null,null,"uur per 100 m2 grond of 100 m2 bvo met andere kostenverhaalsplichtige bouwactiviteiten dan woningbouw",null,null,"Stedenbouw",{"$f":"+Vragenlijst!Q45/100","v":0},0.5,{"$f":"+S16","v":151},"CF stedenbouw",{"$f":"+M15","v":1},null,{"$f":"P51*N51*M51*L51*C49","v":0},null,null,{"$f":"C49*L51*M51*P51","v":0}]
[null,null,null,null,null,null,null,"uur bij maatschappelijke functies",null,null,"Stedenbouw",{"$f":"+IF(Vragenlijst!Q43>0,1,0)","v":0},{"$f":"40","v":40},{"$f":"+S16","v":151},"CF stedenbouw",{"$f":"+M15","v":1},null,{"$f":"P52*N52*M52*L52*C49","v":0},null,null,{"$f":"C49*L52*M52*P52","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.15,{"$f":"+M50*L50+M51*L51+M52*L52","v":0},{"$f":"+S14","v":171},"CF stedenbouw",{"$f":"+M15","v":1},null,{"$f":"P53*N53*M53*L53*C49","v":0},null,null,{"$f":"C49*L53*M53*P53","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.1,{"$f":"+M53","v":0},{"$f":"+S13","v":151},"CF stedenbouw",{"$f":"+M15","v":1},null,{"$f":"P54*N54*M54*L54*C49","v":0},null,null,{"$f":"C49*L54*M54*P54","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Communicatie",7.4999999999999997E-2,{"$f":"+M54","v":0},{"$f":"+S8","v":132},"CF stedenbouw",{"$f":"+M15","v":1},null,{"$f":"P55*N55*M55*L55*C49","v":0},null,null,{"$f":"C49*L55*M55*P55","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Civiele techniek",0.1,{"$f":"+M55","v":0},{"$f":"+S9","v":151},"CF stedenbouw",{"$f":"+M15","v":1},null,{"$f":"P56*N56*M56*L56*C49","v":0},null,null,{"$f":"C49*L56*M56*P56","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+M56","v":0},{"$f":"+S11","v":119},"CF stedenbouw",{"$f":"+M15","v":1},null,{"$f":"P57*N57*M57*L57*C49","v":0},null,null,{"$f":"C49*L57*M57*P57","v":0}]
[]
[null,{"$f":"+Vragenlijst!Q55","v":false},{"$f":"+IF(D59=TRUE,1,0)","v":0},false,null,"1.3","Beeldkwaliteitsplan",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R60:R65)","v":0},null,null,{"$f":"SUM(U60:U65)","v":0}]
[null,null,null,null,null,null,null,"uur per gebouw met een woonfunctie (aantal woningen)",null,null,"Stedenbouw",{"$f":"+Vragenlijst!H40","v":0},1,{"$f":"+S16","v":151},"nee",{"$f":"+IF(O60=\"ja\",$M$14,100%)","v":1},null,{"$f":"P60*N60*M60*L60*C59","v":0},null,null,{"$f":"C59*L60*M60*P60","v":0}]
[null,null,null,null,null,null,null,"uur per 100 m2 grond of 100 m2 bvo met andere kostenverhaalsplichtige bouwactiviteiten dan woningbouw",null,null,"Stedenbouw",{"$f":"+Vragenlijst!Q45/100","v":0},0.25,{"$f":"+S16","v":151},"nee",{"$f":"+IF(O61=\"ja\",$M$14,100%)","v":1},null,{"$f":"P61*N61*M61*L61*C59","v":0},null,null,{"$f":"C59*L61*M61*P61","v":0}]
[null,null,null,null,null,null,null,"uur bij maatschappelijke functies",null,null,"Stedenbouw",{"$f":"+IF(Vragenlijst!Q43>0,1,0)","v":0},{"$f":"40","v":40},{"$f":"+S16","v":151},"nee",{"$f":"+IF(O62=\"ja\",$M$14,100%)","v":1},null,{"$f":"P62*N62*M62*L62*C59","v":0},null,null,{"$f":"C59*L62*M62*P62","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+M60*L60+M61*L61+M62*L62","v":0},{"$f":"+S14","v":171},"nee",{"$f":"+IF(O63=\"ja\",$M$14,100%)","v":1},null,{"$f":"P63*N63*M63*L63*C59","v":0},null,null,{"$f":"C59*L63*M63*P63","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Planeconomie",2.5000000000000001E-2,{"$f":"+M63","v":0},{"$f":"+S13","v":151},"nee",1,null,{"$f":"P64*N64*M64*L64*C59","v":0},null,null,{"$f":"C59*L64*M64*P64","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+M64","v":0},{"$f":"+S11","v":119},"nee",{"$f":"+IF(O65=\"ja\",$M$14,100%)","v":1},null,{"$f":"P65*N65*M65*L65*C59","v":0},null,null,{"$f":"C59*L65*M65*P65","v":0}]
[]
[]
[]
[null,null,null,null,null,null,"Werkzaamheden ten behoeve van het uitvoeren van het omgevingsplan",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S71:S133)","v":0},null,null,{"$f":"SUM(V71:V133)","v":0}]
[]
[null,{"$f":"+IF(Vragenlijst!Q73=0,FALSE,TRUE)","v":false},{"$f":"+IF(D71=TRUE,1,0)","v":0},false,null,"2.1","Taxatie inbrengwaarde percelen","Via  onafhankelijke taxatie",null,null,null,null,null,null,null,null,null,null,{"$f":"IF((R72+R73)<(4*S9),((4*S9)+R74+R75+R76)*L74,SUM(R72:R76))","v":0},null,null,{"$f":"IF((U72+U73)<4,(4+U74+U75+U76)*L74,SUM(U72:U76))","v":0}]
[null,null,{"$f":"+L72+L73","v":0},null,null,null,null,"uur per onbebouwd perceel",null,null,"Taxateur",{"$f":"+Vragenlijst!J74","v":0},1,{"$f":"+S10","v":151},"nee",{"$f":"+IF(O72=\"ja\",$M$14,100%)","v":1},null,{"$f":"P72*N72*M72*L72*C71","v":0},null,null,{"$f":"C$71*L72*M72*P72","v":0}]
[null,null,null,null,null,null,null,"uur per bebouwd perceel",null,null,"Taxateur",{"$f":"+Vragenlijst!J75","v":0},2,{"$f":"+S10","v":151},"nee",{"$f":"+IF(O73=\"ja\",$M$14,100%)","v":1},null,{"$f":"P73*N73*M73*L73*C71","v":0},null,null,{"$f":"C$71*L73*M73*P73","v":0}]
[null,null,null,null,null,null,null,"ambtelijke begeleiding onderzoek",null,null,"Planeconomie",{"$f":"IF(C72>=1,1,0)","v":0},16,{"$f":"+S13","v":151},"nee",{"$f":"+IF(O74=\"ja\",$M$14,100%)","v":1},null,{"$f":"P74*N74*M74*L74*C71","v":0},null,null,{"$f":"C$71*L74*M74*P74","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.05,{"$f":"+M72*L72+M73*L73+M74*L74","v":0},{"$f":"+S14","v":171},"nee",{"$f":"+IF(O75=\"ja\",$M$14,100%)","v":1},null,{"$f":"P75*N75*M75*L75*C71","v":0},null,null,{"$f":"C71*L75*M75*P75","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+M75","v":0},{"$f":"+S11","v":119},"nee",{"$f":"+IF(O76=\"ja\",$M$14,100%)","v":1},null,{"$f":"P76*N76*M76*L76*C71","v":0},null,null,{"$f":"C71*L76*M76*P76","v":0}]
[]
[null,null,null,null,null,null,null,"Via  Wet WOZ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R79:R82)","v":0},null,null,{"$f":"SUM(U79:U82)","v":0}]
[null,null,null,null,null,null,null,"uur per onbebouwd perceel",null,null,"Planeconomie/grondzaken",{"$f":"+Vragenlijst!H74","v":0},0.25,{"$f":"+S13","v":151},"nee",{"$f":"+IF(O79=\"ja\",$M$14,100%)","v":1},null,{"$f":"P79*N79*M79*L79*C71","v":0},null,null,{"$f":"C$71*L79*M79*P79","v":0}]
[null,null,null,null,null,null,null,"uur per bebouwd perceel",null,null,"Planeconomie/grondzaken",{"$f":"+Vragenlijst!H75","v":0},0.25,{"$f":"+S13","v":151},"nee",{"$f":"+IF(O80=\"ja\",$M$14,100%)","v":1},null,{"$f":"P80*N80*M80*L80*C71","v":0},null,null,{"$f":"C$71*L80*M80*P80","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.05,{"$f":"M79*L79+M80*L80","v":0},{"$f":"+S14","v":171},"nee",{"$f":"+IF(O81=\"ja\",$M$14,100%)","v":1},null,{"$f":"P81*N81*M81*L81*C71","v":0},null,null,{"$f":"C$71*L81*M81*P81","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+M81","v":0},{"$f":"+S11","v":119},"nee",{"$f":"+IF(O82=\"ja\",$M$14,100%)","v":1},null,{"$f":"P82*N82*M82*L82*C71","v":0},null,null,{"$f":"C71*L82*M82*P82","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+R85","v":0},null,null,{"$f":"+U85+U86","v":0}]
[null,null,null,null,null,null,null,"Hertaxatie inbrengwaarde (vijfjaarlijks)",null,null,null,{"$f":"+IF(Vragenlijst!H19<=5,0,(IF(Vragenlijst!H19<=10,1,(IF(Vragenlijst!H19<=15,2,(IF(Vragenlijst!H19<=20,3,(IF(Vragenlijst!H19<=25,4,(IF(Vragenlijst!H19<=30,5,(IF(Vragenlijst!H19<=35,6,(IF(Vragenlijst!H19<=40,7,IF(Vragenlijst!H19<=45,8,(IF(Vragenlijst!H19<=50,9,(IF(Vragenlijst!H19<=55,10,IF(Vragenlijst!H19<=60,11,12)))))))))))))))))))))","v":0},{"$f":"+S71+S78","v":0},null,"nee",{"$f":"+IF(O85=\"ja\",$M$14,100%)","v":1},null,{"$f":"M85*L85*C71*P85","v":0},null,null,{"$f":"(+V71+V78)*L85","v":0}]
[]
[]
[null,{"$f":"+IF(Vragenlijst!Q77=0,FALSE,TRUE)","v":false},{"$f":"+IF(D88=TRUE,1,0)","v":0},false,null,"2.2","Taxatie en aankoop onroerende zaak",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R89:R98)","v":0},null,null,{"$f":"SUM(U89:U98)","v":0}]
[null,null,null,null,null,null,null,"uur per onbebouwde perceel",null,null,"Grondzaken",{"$f":"+Vragenlijst!H78","v":0},24,{"$f":"+S10","v":151},"nee",{"$f":"+IF(O89=\"ja\",$M$14,100%)","v":1},null,{"$f":"P89*N89*M89*L89*C$88","v":0},null,null,{"$f":"C$88*L89*M89*P89","v":0}]
[null,null,null,null,null,null,null,"uur per gebouw met een woonfunctie ",null,null,"Grondzaken",{"$f":"+Vragenlijst!H79","v":0},48,{"$f":"+S10","v":151},"nee",1,null,0,null,null,0]
[null,null,null,null,null,null,null,"uur per gebouw met een industriefunctie, winkelfunctie of kantoorfunctie ",null,null,"Grondzaken",{"$f":"IF(Vragenlijst!Q30=TRUE,0,Vragenlijst!H80)","v":0},80,{"$f":"+S10","v":151},"nee",1,null,0,null,null,0]
[null,null,null,null,null,null,null,"uur per gebouw met een industriefunctie, winkelfunctie of kantoorfunctie in herstructurering",null,null,"Grondzaken",{"$f":"IF(Vragenlijst!Q30=TRUE,Vragenlijst!H80,0)","v":0},100,{"$f":"+S10","v":151},"nee",1,null,0,null,null,0]
[null,null,null,null,null,null,null,"uur per byzonder object",null,null,"Grondzaken",{"$f":"IF(Vragenlijst!Q30=TRUE,0,Vragenlijst!H81)","v":0},80,{"$f":"+S10","v":151},"nee",1,null,0,null,null,0]
[null,null,null,null,null,null,null,"uur per byzonder object in herstructurering",null,null,"Grondzaken",{"$f":"IF(Vragenlijst!Q30=TRUE,Vragenlijst!H81,0)","v":0},100,{"$f":"S10","v":151},"nee",1,null,0,null,null,0]
[null,null,null,null,null,null,null,"uur per huur/pachtontbinding",null,null,"Grondzaken",{"$f":"Vragenlijst!H83","v":0},48,{"$f":"S10","v":151},"nee",{"$f":"+IF(O95=\"ja\",$M$14,100%)","v":1},null,{"$f":"P95*N95*M95*L95*C$88","v":0},null,null,{"$f":"C$88*L95*M95*P95","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+M91*L91+M92*L92+M89*L89+M90*L90+M93*L93+M94*L94+L95*M95","v":0},{"$f":"+S14","v":171},"nee",1,null,{"$f":"P96*N96*M96*L96*C88","v":0},null,null,{"$f":"C88*L96*M96*P96","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.05,{"$f":"+M96","v":0},{"$f":"+S13","v":151},"nee",1,null,{"$f":"P97*N97*M97*L97*C88","v":0},null,null,{"$f":"C88*L97*M97*P97","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+M97","v":0},{"$f":"+S11","v":119},"nee",{"$f":"+IF(O98=\"ja\",$M$14,100%)","v":1},null,{"$f":"P98*N98*M98*L98*C88","v":0},null,null,{"$f":"C88*L98*M98*P98","v":0}]
[]
[null,{"$f":"+IF(Vragenlijst!Q86=0,FALSE,TRUE)","v":false},{"$f":"+IF(D100=TRUE,1,0)","v":0},false,null,"2.3","Onteigenen van onroerende zaken",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R101:R106)","v":0},null,null,{"$f":"SUM(U101:U106)","v":0}]
[null,null,null,null,null,null,null,"uur per procedure van de voorbereiding van een onteigeningsbeschikking",null,null,"Grondzaken",{"$f":"+Vragenlijst!H86","v":0},134,{"$f":"S10","v":151},"nee",{"$f":"+IF(O101=\"ja\",$M$14,100%)","v":1},null,{"$f":"P101*N101*M101*L101*C$100","v":0},null,null,{"$f":"C$100*L101*M101*P101","v":0}]
[null,null,null,null,null,null,null,"uur per bekrachtigingsprocedure onteigeningsbeschikking",null,null,"Grondzaken",{"$f":"+Vragenlijst!H87","v":0},50,{"$f":"S10","v":151},"nee",{"$f":"+IF(O102=\"ja\",$M$14,100%)","v":1},null,{"$f":"P102*N102*M102*L102*C$100","v":0},null,null,{"$f":"C$100*L102*M102*P102","v":0}]
[null,null,null,null,null,null,null,"vast bedrag advocaatkosten per onteigeningsbeschikking",null,null,"Advocatuur",{"$f":"+L102","v":0},38532,null,"nee",{"$f":"+IF(O103=\"ja\",$M$14,100%)","v":1},null,{"$f":"P103*M103*L103*C$100","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+L101*M101+M102*L102","v":0},{"$f":"+S14","v":171},"nee",{"$f":"+IF(O104=\"ja\",$M$14,100%)","v":1},null,{"$f":"P104*N104*M104*L104*C100","v":0},null,null,{"$f":"C100*L104*M104*P104","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.05,{"$f":"+M104","v":0},{"$f":"+S13","v":151},"nee",1,null,{"$f":"P105*N105*M105*L105*C100","v":0},null,null,{"$f":"C100*L105*M105*P105","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+M105","v":0},{"$f":"+S11","v":119},"nee",{"$f":"+IF(O106=\"ja\",$M$14,100%)","v":1},null,{"$f":"P106*N106*M106*L106*C100","v":0},null,null,{"$f":"C100*L106*M106*P106","v":0}]
[]
[null,{"$f":"+Vragenlijst!Q90","v":false},{"$f":"+IF(D108=TRUE,1,0)","v":0},false,null,"2.4","Vestigen voorkeursrecht ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R109:R112)","v":0},null,null,{"$f":"SUM(U109:U112)","v":0}]
[null,null,null,null,null,null,null,"uur voor vestiging voorkeursrecht",null,null,"Grondzaken",{"$f":"+Vragenlijst!S90","v":0},60,{"$f":"+S10","v":151},"nee",{"$f":"+IF(O109=\"ja\",$M$14,100%)","v":1},null,{"$f":"P109*N109*M109*L109*C$108","v":0},null,null,{"$f":"C$108*L109*M109*P109","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+L109*M109","v":0},{"$f":"+S14","v":171},"nee",{"$f":"+IF(O110=\"ja\",$M$14,100%)","v":1},null,{"$f":"P110*N110*M110*L110*C108","v":0},null,null,{"$f":"C108*L110*M110*P110","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.05,{"$f":"+M110","v":0},{"$f":"+S13","v":151},"nee",1,null,{"$f":"P111*N111*M111*L111*C108","v":0},null,null,{"$f":"C108*L111*M111*P111","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+M111","v":0},{"$f":"+S11","v":119},"nee",{"$f":"+IF(O112=\"ja\",$M$14,100%)","v":1},null,{"$f":"P112*N112*M112*L112*C108","v":0},null,null,{"$f":"C108*L112*M112*P112","v":0}]
[]
[null,{"$f":"+Vragenlijst!Q56","v":false},{"$f":"+IF(D114=TRUE,1,0)","v":0},false,null,"2.5","Inrichtingsplan Openbare ruimte ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R115:R120)","v":0},null,null,{"$f":"SUM(U115:U120)","v":0}]
[null,null,null,null,null,null,null,"uur per 100 m2 verharding",null,null,"Stedenbouw, civiele techniek",{"$f":"+Vragenlijst!H50/100","v":0},1.5,{"$f":"+S16","v":151},"nee",{"$f":"+IF(O115=\"ja\",$M$14,100%)","v":1},null,{"$f":"P115*N115*M115*L115*C114","v":0},null,null,{"$f":"C$114*L115*M115*P115","v":0}]
[null,null,null,null,null,null,null,"uur per 100 m2 groen/water",null,null,"Stedenbouw, civiele techniek",{"$f":"(+Vragenlijst!H49-Vragenlijst!H50)/100","v":0},1,{"$f":"+S16","v":151},"nee",{"$f":"+IF(O116=\"ja\",$M$14,100%)","v":1},null,{"$f":"P116*N116*M116*L116*C114","v":0},null,null,{"$f":"C$114*L116*M116*P116","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.05,{"$f":"+M115*L115+M116*L116","v":0},{"$f":"+S14","v":171},"nee",{"$f":"+IF(O117=\"ja\",$M$14,100%)","v":1},null,{"$f":"P117*N117*M117*L117*C114","v":0},null,null,{"$f":"C114*L117*M117*P117","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Planeconomie",2.5000000000000001E-2,{"$f":"+M117","v":0},{"$f":"+S13","v":151},"nee",1,null,{"$f":"P118*N118*M118*L118*C114","v":0},null,null,{"$f":"C114*L118*M118*P118","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Communicatie",0.05,{"$f":"+M117","v":0},{"$f":"+S8","v":132},"nee",1,null,{"$f":"P119*N119*M119*L119*C114","v":0},null,null,{"$f":"C114*L119*M119*P119","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+M119","v":0},{"$f":"+S11","v":119},"nee",{"$f":"+IF(O120=\"ja\",$M$14,100%)","v":1},null,{"$f":"P120*N120*M120*L120*C114","v":0},null,null,{"$f":"C114*L120*M120*P120","v":0}]
[]
[null,{"$f":"+IF(Vragenlijst!T99+Vragenlijst!S124+Vragenlijst!T135>0,TRUE,FALSE)","v":false},{"$f":"+IF(D122=TRUE,1,0)","v":0},false,null,"2.6","Voorbereiding, toezicht en directievoering bij civiel en cultuurtechnische werken",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R123:R125)","v":0},null,null,{"$f":"SUM(U123:U125)","v":0}]
[null,null,null,null,null,null,"a","slopen",null,null,"Ingenieursbureau",1,{"$f":"+Hulpblad!G48","v":0},1,"ja",{"$f":"+M14","v":1},null,{"$f":"P123*N123*M123*L123*C$122","v":0},null,null,{"$f":"+Hulpblad!I48*C122*P123","v":0}]
[null,null,null,null,null,null,"b","ophogen/voorbelasten",null,null,"Ingenieursbureau",{"$f":"+Vragenlijst!S124","v":0},{"$f":"+Hulpblad!G158","v":0},1,"nee",{"$f":"+IF(O124=\"ja\",$M$14,100%)","v":1},null,{"$f":"P124*N124*M124*L124*C$122","v":0}]
[null,null,null,null,null,null,"c","bouw en woonrijpmaken",null,null,"Ingenieursbureau",1,{"$f":"+Hulpblad!G104","v":0},1,"ja",{"$f":"+M14","v":1},null,{"$f":"P125*N125*M125*L125*C$122","v":0},null,null,{"$f":"+Hulpblad!I104*C122*P125","v":0}]
[]
[]
[null,null,null,null,null,"2.7","Algemene en financiele verantwoording en aansturing  van het project",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R129:R131)","v":0},null,null,{"$f":"SUM(U129:U131)","v":0}]
[null,true,{"$f":"+IF(D129=TRUE,1,0)","v":0},false,null,null,"inclusief bestuurlijke besluitvorming","a.projectmanagement uur per jaar",null,null,"Projectmanagement",{"$f":"+Vragenlijst!J20","v":0},{"$f":"30","v":30},{"$f":"+S14","v":171},"ja",{"$f":"+IF(O129=\"ja\",$M$14,100%)","v":1},null,{"$f":"P129*N129*M129*L129*C129","v":0},null,null,{"$f":"C$129*L129*M129*P129","v":0}]
[null,null,null,null,null,null,null,"b. projectassistentie uur per jaar, mits complexiteitsfactor > 130%",null,null,"Projectassistentie",{"$f":"+IF(M14>130%,Vragenlijst!J20,0)","v":0},100,{"$f":"+S15","v":119},"ja",{"$f":"+IF(O130=\"ja\",$M$14,100%)","v":1},null,{"$f":"P130*N130*M130*L130*C129","v":0},null,null,{"$f":"C$129*L130*M130*P130","v":0}]
[null,null,null,null,null,null,null,"c. financieel management uur per jaar",null,null,"Planeconomie",{"$f":"+Vragenlijst!J20","v":0},64,{"$f":"+S13","v":151},"ja",{"$f":"+IF(O131=\"ja\",$M$14,100%)","v":1},null,{"$f":"P131*N131*M131*L131*C129","v":0},null,null,{"$f":"C$129*L131*M131*P131","v":0}]

{"sheet":"Resultaat","index":4,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":"+Vragenlijst!C7","v":"Plankostenregels bij kostenverhaal MET tijdvak"}]
[]
[null,null,"Resultaat"]
[null,null,null,"Datum",{"$f":"+Vragenlijst!F10","v":"2024-02-28"}]
[null,null,null,"Gemeente:",{"$f":"+Vragenlijst!F11","v":"…."}]
[null,null,null,"Projectnaam:",{"$f":"+Vragenlijst!F12","v":"…."}]
[null,null,null,"Kostenverhaalsgebied:",{"$f":"+Vragenlijst!F13","v":"…."}]
[null,null,null,"looptijd in jaren:",{"$f":"+Vragenlijst!J20","v":0}]
[null,null,null,"Complexiteit van het project:",{"$f":"+Produktenlijst!M14","v":1}]
[]
[null,null,null,null,"uren","euro's"]
[null,null,null,{"$f":"+Produktenlijst!G20","v":"Omgevingsplan, projectbesluit of omgevingsvergunning voor het kostenverhaalsgebied"},{"$f":"SUM(E15:E17)","v":0},{"$f":"SUM(F15:F17)","v":0}]
[null,null,"1.1",{"$f":"+Produktenlijst!G22","v":"Opstellen en vaststellen gedetailleerd omgevingsplan"},{"$f":"+Produktenlijst!V22+Produktenlijst!V30+Produktenlijst!V35+Produktenlijst!V43","v":0},{"$f":"+Produktenlijst!S22+Produktenlijst!S30+Produktenlijst!S35+Produktenlijst!S43","v":0},null,true]
[null,null,{"$f":"+Produktenlijst!F49","v":"1.2"},{"$f":"+Produktenlijst!G49","v":"Stedenbouwkundig plan"},{"$f":"+Produktenlijst!V49","v":0},{"$f":"+Produktenlijst!S49","v":0}]
[null,null,{"$f":"+Produktenlijst!F59","v":"1.3"},{"$f":"+Produktenlijst!G59","v":"Beeldkwaliteitsplan"},{"$f":"+Produktenlijst!V59","v":0},{"$f":"+Produktenlijst!S59","v":0},null,true]
[null,null,null,null,null,null,null,true]
[null,null,null,{"$f":"+Produktenlijst!G69","v":"Werkzaamheden ten behoeve van het uitvoeren van het omgevingsplan"},{"$f":"SUM(E20:E26)","v":0},{"$f":"SUM(F20:F26)","v":0}]
[null,null,{"$f":"+Produktenlijst!F71","v":"2.1"},{"$f":"+Produktenlijst!G71","v":"Taxatie inbrengwaarde percelen"},{"$f":"+Produktenlijst!V71+Produktenlijst!V78+Produktenlijst!V84","v":0},{"$f":"+Produktenlijst!S71+Produktenlijst!S78+Produktenlijst!S84","v":0}]
[null,null,{"$f":"+Produktenlijst!F88","v":"2.2"},{"$f":"+Produktenlijst!G88","v":"Taxatie en aankoop onroerende zaak"},{"$f":"+Produktenlijst!V88","v":0},{"$f":"+Produktenlijst!S88","v":0}]
[null,null,{"$f":"+Produktenlijst!F100","v":"2.3"},{"$f":"+Produktenlijst!G100","v":"Onteigenen van onroerende zaken"},{"$f":"+Produktenlijst!V100","v":0},{"$f":"+Produktenlijst!S100","v":0}]
[null,null,{"$f":"+Produktenlijst!F108","v":"2.4"},{"$f":"+Produktenlijst!G108","v":"Vestigen voorkeursrecht "},{"$f":"+Produktenlijst!V108","v":0},{"$f":"+Produktenlijst!S108","v":0},null,true]
[null,null,{"$f":"+Produktenlijst!F114","v":"2.5"},{"$f":"+Produktenlijst!G114","v":"Inrichtingsplan Openbare ruimte "},{"$f":"+Produktenlijst!V114","v":0},{"$f":"+Produktenlijst!S114","v":0},null,false]
[null,null,{"$f":"+Produktenlijst!F122","v":"2.6"},{"$f":"+Produktenlijst!G122","v":"Voorbereiding, toezicht en directievoering bij civiel en cultuurtechnische werken"},{"$f":"+Produktenlijst!V122","v":0},{"$f":"+Produktenlijst!S122","v":0}]
[null,null,{"$f":"+Produktenlijst!F128","v":"2.7"},{"$f":"+Produktenlijst!G128","v":"Algemene en financiele verantwoording en aansturing  van het project"},{"$f":"+Produktenlijst!V128","v":0},{"$f":"+Produktenlijst!S128","v":0},null,false]
[]
[null,null,null,"Totaal kostenverhaal",{"$f":"+E19+E14","v":0},{"$f":"+F19+F14","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E48:E49)","v":0}]

{"sheet":"Bijdrage per eigenaar","index":5,"n_rows":109,"n_cols":45,"rows_kept":109,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":"+Vragenlijst!C7","v":"Plankostenregels bij kostenverhaal MET tijdvak"}]
[]
[null,null,"De plankostenbijdrage per eigenaar."]
[null,null,"Wanneer de eigenaar zelf produkten/activiteiten heeft uitgevoerd heeft de aanvrager van de beschikking "]
[null,null,"recht op (maximale) aftrek van kosten, mits de gemeente akkoord heeft gegeven op het geleverde produkt (artikel 13.8 Or)"]
[null,null,null,"Datum",null,{"$f":"+Vragenlijst!F10","v":"2024-02-28"}]
[null,null,null,"Gemeente:",null,{"$f":"+Vragenlijst!F11","v":"…."}]
[null,null,null,"Projectnaam:",null,{"$f":"+Vragenlijst!F12","v":"…."},null,{"$f":"IF(F109-L109-T109-AB109-AJ109-AR109<0,\"fout, er wordt meer verhaald dan is toegestaan\",\"\")","v":""}]
[null,null,null,"Kostenverhaalsgebied:",null,{"$f":"+Vragenlijst!F13","v":"…."},null,{"$f":"IF(F13<>I16+Q16+Y16+AG16+AO16,\"het totaal aan opbrengstpotenties in de beschikkingen is niet gelijk aan die de kostenverhaalsgebieden\",\"\")","v":""}]
[]
[null,null,null,null,"Totale opbrengstpotentie in het kostenverhaalsgebied:",1]
[]
[null,null,null,null,null,null,null,null,"…","naam grondeigenaar",null,null,null,null,null,null,"…","naam grondeigenaar",null,null,null,null,null,null,"…","naam grondeigenaar",null,null,null,null,null,null,"…","naam grondeigenaar",null,null,null,null,null,null,"…","naam grondeigenaar"]
[null,null,null,null,null,null,null,null,1,"opbrengstpotentie beschikking",null,null,null,null,null,null,0,"opbrengstpotentie beschikking",null,null,null,null,null,null,0,"opbrengstpotentie beschikking",null,null,null,null,null,null,0,"opbrengstpotentie beschikking",null,null,null,null,null,null,0,"opbrengstpotentie beschikking"]
[null,null,null,"Totaal resultaat plankosten",null,null,null,"aandeel in de plankosten is;","eigenaar voert onderstaande activiteiten uit: cf art 13.8 Or",null,"vergoeding voor deze activiteiten","te vergoeden voor werkzaamheden gemeente",null,null,null,"aandeel in de plankosten is;","eigenaar voert onderstaande activiteiten uit: cf art 13.8 Or",null,"vergoeding voor deze activiteiten","te vergoeden voor werkzaamheden gemeente",null,null,null,"aandeel in de plankosten is;","eigenaar voert onderstaande activiteiten uit: cf art 13.8 Or",null,"vergoeding voor deze activiteiten","te vergoeden voor werkzaamheden gemeente",null,null,null,"aandeel in de plankosten is;","eigenaar voert onderstaande activiteiten uit: cf art 13.8 Or",null,"vergoeding voor deze activiteiten","te vergoeden voor werkzaamheden gemeente",null,null,null,"aandeel in de plankosten is;","eigenaar voert onderstaande activiteiten uit: cf art 13.8 Or",null,"vergoeding voor deze activiteiten","te vergoeden voor werkzaamheden gemeente"]
[null,null,null,null,null,null,null,{"$f":"I16/F13","v":1},null,null,null,null,null,null,null,{"$f":"Q16/F13","v":0},null,null,null,null,null,null,null,{"$f":"Y16/F13","v":0},null,null,null,null,null,null,null,{"$f":"AG16/F13","v":0},null,null,null,null,null,null,null,{"$f":"AO16/F13","v":0}]
[null,null,null,null,null,"euro's",null,"euro's","zelf vergoedingspercentage invoeren","vermindering bedraagt ten hoogste volgens art 13.8 Or:","euro's","euro's",null,null,"prod.","euro's","zelf vergoedingspercentage invoeren","vermindering bedraagt ten hoogste volgens art 13.8 Or:","euro's","euro's",null,null,"prod.","euro's","zelf vergoedingspercentage invoeren","vermindering bedraagt ten hoogste volgens art 13.8 Or:","euro's","euro's",null,null,"prod.","euro's","zelf vergoedingspercentage invoeren","vermindering bedraagt ten hoogste volgens art 13.8 Or:","euro's","euro's",null,null,"prod.","euro's","zelf vergoedingspercentage invoeren","vermindering bedraagt ten hoogste volgens art 13.8 Or:","euro's","euro's"]
[null,null,null,{"$f":"Produktenlijst!G20","v":"Omgevingsplan, projectbesluit of omgevingsvergunning voor het kostenverhaalsgebied"}]
[null,null,"1.1","Opstellen en procedure gedetailleerd omgevingsplan",null,{"$f":"SUM(F22:F27)","v":0},null,{"$f":"SUM(H22:H27)","v":0},null,null,{"$f":"SUM(K22:K27)","v":0},{"$f":"SUM(L22:L27)","v":0},null,null,"1.1",{"$f":"SUM(P22:P27)","v":0},null,null,{"$f":"SUM(S22:S27)","v":0},{"$f":"SUM(T22:T27)","v":0},null,null,"1.1",{"$f":"SUM(X22:X27)","v":0},null,null,{"$f":"SUM(AA22:AA27)","v":0},{"$f":"SUM(AB22:AB27)","v":0},null,null,"1.1",{"$f":"SUM(AF22:AF27)","v":0},null,null,{"$f":"SUM(AI22:AI27)","v":0},{"$f":"SUM(AJ22:AJ27)","v":0},null,null,"1.1",{"$f":"SUM(AN22:AN27)","v":0},null,null,{"$f":"SUM(AQ22:AQ27)","v":0},{"$f":"SUM(AR22:AR27)","v":0}]
[null,null,null,{"$f":"Produktenlijst!H23","v":"opstellen en vaststellen omgevingsplan"},{"$f":"Produktenlijst!K23","v":"Omgevingsrecht jurist incl digitalisering/kaartmateriaal"},{"$f":"Produktenlijst!R23","v":0},null,{"$f":"F22*$H$18","v":0},0,"maximaal 60%",{"$f":"I22*H22","v":0},{"$f":"H22-K22","v":0},{"$f":"IF(I22>60%,\"X\",\"\")","v":""},null,"jur",{"$f":"F22*$P$18","v":0},0,"maximaal 60%",{"$f":"Q22*P22","v":0},{"$f":"P22-S22","v":0},{"$f":"IF(Q22>60%,\"X\",\"\")","v":""},null,"jur",{"$f":"F22*$X$18","v":0},0,"maximaal 60%",{"$f":"Y22*X22","v":0},{"$f":"X22-AA22","v":0},{"$f":"IF(Y22>60%,\"X\",\"\")","v":""},null,"jur",{"$f":"F22*$AF$18","v":0},0,"maximaal 60%",{"$f":"AG22*AF22","v":0},{"$f":"AF22-AI22","v":0},{"$f":"IF(AG22>60%,\"X\",\"\")","v":""},null,"jur",{"$f":"F22*$AN$18","v":0},0,"maximaal 60%",{"$f":"AO22*AN22","v":0},{"$f":"AN22-AQ22","v":0},{"$f":"IF(AO22>60%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K24","v":"Projectmanagement"},{"$f":"Produktenlijst!R24","v":0},null,0,0,"maximaal 60%",{"$f":"I23*H23","v":0},{"$f":"H23-K23","v":0},"",null,"pm",0,0,"maximaal 60%",{"$f":"Q23*P23","v":0},{"$f":"P23-S23","v":0},"",null,"pm",0,0,"maximaal 60%",{"$f":"Y23*X23","v":0},{"$f":"X23-AA23","v":0},"",null,"pm",0,0,"maximaal 60%",{"$f":"AG23*AF23","v":0},{"$f":"AF23-AI23","v":0},"",null,"pm",0,0,"maximaal 60%",{"$f":"AO23*AN23","v":0},{"$f":"AN23-AQ23","v":0},""]
[null,null,null,null,{"$f":"Produktenlijst!K25","v":"Stedenbouw"},{"$f":"Produktenlijst!R25","v":0},null,0,0,"maximaal 60%",0,0,{"$f":"IF(I24>60%,\"X\",\"\")","v":""},null,"sted",0,0,"maximaal 60%",0,0,{"$f":"IF(Q24>60%,\"X\",\"\")","v":""},null,"sted",0,0,"maximaal 60%",0,0,{"$f":"IF(Y24>60%,\"X\",\"\")","v":""},null,"sted",0,0,"maximaal 60%",0,0,{"$f":"IF(AG24>60%,\"X\",\"\")","v":""},null,"sted",0,0,"maximaal 60%",0,0,{"$f":"IF(AO24>60%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K26","v":"Planeconomie"},{"$f":"Produktenlijst!R26","v":0},null,0,0,"maximaal 60%",0,0,{"$f":"IF(I25>60%,\"X\",\"\")","v":""},null,"pe",0,0,"maximaal 60%",0,0,{"$f":"IF(Q25>60%,\"X\",\"\")","v":""},null,"pe",0,0,"maximaal 60%",0,0,{"$f":"IF(Y25>60%,\"X\",\"\")","v":""},null,"pe",0,0,"maximaal 60%",0,0,{"$f":"IF(AG25>60%,\"X\",\"\")","v":""},null,"pe",0,0,"maximaal 60%",0,0,{"$f":"IF(AO25>60%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K27","v":"Beleidsafdelingen"},{"$f":"Produktenlijst!R27","v":0},null,0,0,"maximaal 60%",0,0,"",null,"bel",0,0,"maximaal 60%",0,0,"",null,"bel",0,0,"maximaal 60%",0,0,"",null,"bel",0,0,"maximaal 60%",0,0,"",null,"bel",0,0,"maximaal 60%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K28","v":"Communicatie"},{"$f":"Produktenlijst!R28","v":0},null,0,0,"maximaal 60%",0,0,"",null,"com",0,0,"maximaal 60%",0,0,"",null,"com",0,0,"maximaal 60%",0,0,"",null,"com",0,0,"maximaal 60%",0,0,"",null,"com",0,0,"maximaal 60%",0,0,""]
[]
[null,null,null,null,null,{"$f":"SUM(F30:F31)","v":0},null,{"$f":"SUM(H30:H31)","v":0},null,null,{"$f":"SUM(K30:K31)","v":0},{"$f":"SUM(L30:L31)","v":0},null,null,null,{"$f":"SUM(P30:P31)","v":0},null,null,{"$f":"SUM(S30:S31)","v":0},{"$f":"SUM(T30:T31)","v":0},null,null,null,{"$f":"SUM(X30:X31)","v":0},null,null,{"$f":"SUM(AA30:AA31)","v":0},{"$f":"SUM(AB30:AB31)","v":0},null,null,null,{"$f":"SUM(AF30:AF31)","v":0},null,null,{"$f":"SUM(AI30:AI31)","v":0},{"$f":"SUM(AJ30:AJ31)","v":0},null,null,null,{"$f":"SUM(AN30:AN31)","v":0},null,null,{"$f":"SUM(AQ30:AQ31)","v":0},{"$f":"SUM(AR30:AR31)","v":0}]
[null,null,null,{"$f":"Produktenlijst!H31","v":"opstellen regels kostenverhaal"},{"$f":"Produktenlijst!K31","v":"Grondzaken en planeconomie"},{"$f":"Produktenlijst!R31","v":0},null,{"$f":"F30*$H$18","v":0},0,"maximaal 60%",0,0,"",null,"gz/pe",{"$f":"F30*$P$18","v":0},0,"maximaal 60%",{"$f":"Q30*P30","v":0},{"$f":"P30-S30","v":0},{"$f":"IF(Q30>60%,\"X\",\"\")","v":""},null,"gz/pe",{"$f":"F30*$X$18","v":0},0,"maximaal 60%",{"$f":"Y30*X30","v":0},{"$f":"X30-AA30","v":0},{"$f":"IF(Y30>60%,\"X\",\"\")","v":""},null,"gz/pe",{"$f":"F30*$AF$18","v":0},0,"maximaal 60%",{"$f":"AG30*AF30","v":0},{"$f":"AF30-AI30","v":0},{"$f":"IF(AG30>60%,\"X\",\"\")","v":""},null,"gz/pe",{"$f":"F30*$AN$18","v":0},0,"maximaal 60%",{"$f":"AO30*AN30","v":0},{"$f":"AN30-AQ30","v":0},{"$f":"IF(AO30>60%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K32","v":"Projectmanagement"},{"$f":"Produktenlijst!R32","v":0},null,{"$f":"F31*$H$18","v":0},0,"maximaal 60%",0,0,"",null,"pm",{"$f":"F31*$P$18","v":0},0,"maximaal 60%",0,0,"",null,"pm",{"$f":"F31*$X$18","v":0},0,"maximaal 60%",0,0,"",null,"pm",{"$f":"F31*$AF$18","v":0},0,"maximaal 60%",0,0,"",null,"pm",{"$f":"F31*$AN$18","v":0},0,"maximaal 60%",0,0,""]
[]
[null,null,null,{"$f":"Produktenlijst!G35","v":"Opstellen en vaststellen projectbesluit of verlenen omgevingsvergunning voor een buitenplanse omgevingsplanactiviteit"},null,{"$f":"SUM(F34:F39)","v":0},null,{"$f":"SUM(H34:H39)","v":0},null,null,{"$f":"SUM(K34:K39)","v":0},{"$f":"SUM(L34:L39)","v":0},null,null,null,{"$f":"SUM(P34:P39)","v":0},null,null,{"$f":"SUM(S34:S39)","v":0},{"$f":"SUM(T34:T39)","v":0},null,null,null,{"$f":"SUM(X34:X39)","v":0},null,null,{"$f":"SUM(AA34:AA39)","v":0},{"$f":"SUM(AB34:AB39)","v":0},null,null,null,{"$f":"SUM(AF34:AF39)","v":0},null,null,{"$f":"SUM(AI34:AI39)","v":0},{"$f":"SUM(AJ34:AJ39)","v":0},null,null,null,{"$f":"SUM(AN34:AN39)","v":0},null,null,{"$f":"SUM(AQ34:AQ39)","v":0},{"$f":"SUM(AR34:AR39)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K36","v":"Omgevingsrecht jurist incl digitalisering/kaartmateriaal"},{"$f":"Produktenlijst!R36","v":0},null,{"$f":"F34*$H$18","v":0},0,"maximaal 60%",{"$f":"I34*H34","v":0},{"$f":"H34-K34","v":0},{"$f":"IF(I34>60%,\"X\",\"\")","v":""},null,"jur",{"$f":"F34*$P$18","v":0},0,"maximaal 60%",{"$f":"Q34*P34","v":0},{"$f":"P34-S34","v":0},{"$f":"IF(Q34>60%,\"X\",\"\")","v":""},null,"jur",{"$f":"F34*$X$18","v":0},0,"maximaal 60%",{"$f":"Y34*X34","v":0},{"$f":"X34-AA34","v":0},{"$f":"IF(Y34>60%,\"X\",\"\")","v":""},null,"jur",{"$f":"F34*$AF$18","v":0},0,"maximaal 60%",{"$f":"AG34*AF34","v":0},{"$f":"AF34-AI34","v":0},{"$f":"IF(AG34>60%,\"X\",\"\")","v":""},null,"jur",{"$f":"F34*$AN$18","v":0},0,"maximaal 60%",{"$f":"AO34*AN34","v":0},{"$f":"AN34-AQ34","v":0},{"$f":"IF(AO34>60%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K37","v":"Projectmanagement"},{"$f":"Produktenlijst!R37","v":0},null,0,0,"maximaal 60%",{"$f":"I35*H35","v":0},{"$f":"H35-K35","v":0},"",null,"pm",0,0,"maximaal 60%",{"$f":"Q35*P35","v":0},{"$f":"P35-S35","v":0},"",null,"pm",0,0,"maximaal 60%",{"$f":"Y35*X35","v":0},{"$f":"X35-AA35","v":0},"",null,"pm",0,0,"maximaal 60%",{"$f":"AG35*AF35","v":0},{"$f":"AF35-AI35","v":0},"",null,"pm",0,0,"maximaal 60%",{"$f":"AO35*AN35","v":0},{"$f":"AN35-AQ35","v":0},""]
[null,null,null,null,{"$f":"Produktenlijst!K38","v":"Stedenbouw"},{"$f":"Produktenlijst!R38","v":0},null,0,0,"maximaal 60%",0,0,{"$f":"IF(I36>60%,\"X\",\"\")","v":""},null,"sted",0,0,"maximaal 60%",0,0,{"$f":"IF(Q36>60%,\"X\",\"\")","v":""},null,"sted",0,0,"maximaal 60%",0,0,{"$f":"IF(Y36>60%,\"X\",\"\")","v":""},null,"sted",0,0,"maximaal 60%",0,0,{"$f":"IF(AG36>60%,\"X\",\"\")","v":""},null,"sted",0,0,"maximaal 60%",0,0,{"$f":"IF(AO36>60%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K39","v":"Planeconomie"},{"$f":"Produktenlijst!R39","v":0},null,0,0,"maximaal 60%",0,0,{"$f":"IF(I37>60%,\"X\",\"\")","v":""},null,"pe",0,0,"maximaal 60%",0,0,{"$f":"IF(Q37>60%,\"X\",\"\")","v":""},null,"pe",0,0,"maximaal 60%",0,0,{"$f":"IF(Y37>60%,\"X\",\"\")","v":""},null,"pe",0,0,"maximaal 60%",0,0,{"$f":"IF(AG37>60%,\"X\",\"\")","v":""},null,"pe",0,0,"maximaal 60%",0,0,{"$f":"IF(AO37>60%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K40","v":"Beleidsafdelingen"},{"$f":"Produktenlijst!R40","v":0},null,0,0,"maximaal 60%",0,0,"",null,"bel",0,0,"maximaal 60%",0,0,"",null,"bel",0,0,"maximaal 60%",0,0,"",null,"bel",0,0,"maximaal 60%",0,0,"",null,"bel",0,0,"maximaal 60%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K41","v":"Communicatie"},{"$f":"Produktenlijst!R41","v":0},null,0,0,"maximaal 60%",0,0,"",null,"com",0,0,"maximaal 60%",0,0,"",null,"com",0,0,"maximaal 60%",0,0,"",null,"com",0,0,"maximaal 60%",0,0,"",null,"com",0,0,"maximaal 60%",0,0,""]
[]
[null,null,null,{"$f":"Produktenlijst!H44","v":"opstellen regels kostenverhaal"},null,{"$f":"SUM(F42:F43)","v":0},null,{"$f":"SUM(H42:H43)","v":0},null,null,{"$f":"SUM(K42:K43)","v":0},{"$f":"SUM(L42:L43)","v":0},null,null,null,{"$f":"SUM(P42:P43)","v":0},null,null,{"$f":"SUM(S42:S43)","v":0},{"$f":"SUM(T42:T43)","v":0},null,null,null,{"$f":"SUM(X42:X43)","v":0},null,null,{"$f":"SUM(AA42:AA43)","v":0},{"$f":"SUM(AB42:AB43)","v":0},null,null,null,{"$f":"SUM(AF42:AF43)","v":0},null,null,{"$f":"SUM(AI42:AI43)","v":0},{"$f":"SUM(AJ42:AJ43)","v":0},null,null,null,{"$f":"SUM(AN42:AN43)","v":0},null,null,{"$f":"SUM(AQ42:AQ43)","v":0},{"$f":"SUM(AR42:AR43)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K44","v":"Grondzaken en planeconomie"},{"$f":"Produktenlijst!R44","v":0},null,{"$f":"F42*$H$18","v":0},0,"maximaal 60%",{"$f":"I42*H42","v":0},{"$f":"H42-K42","v":0},{"$f":"IF(I42>60%,\"X\",\"\")","v":""},null,"gz/pe",{"$f":"F42*$P$18","v":0},0,"maximaal 60%",{"$f":"Q42*P42","v":0},{"$f":"P42-S42","v":0},{"$f":"IF(Q42>60%,\"X\",\"\")","v":""},null,"gz/pe",{"$f":"F42*$X$18","v":0},0,"maximaal 60%",{"$f":"Y42*X42","v":0},{"$f":"X42-AA42","v":0},{"$f":"IF(Y42>60%,\"X\",\"\")","v":""},null,"gz/pe",{"$f":"F42*$AF$18","v":0},0,"maximaal 60%",{"$f":"AG42*AF42","v":0},{"$f":"AF42-AI42","v":0},{"$f":"IF(AG42>60%,\"X\",\"\")","v":""},null,"gz/pe",{"$f":"F42*$AN$18","v":0},0,"maximaal 60%",{"$f":"AO42*AN42","v":0},{"$f":"AN42-AQ42","v":0},{"$f":"IF(AO42>60%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K45","v":"Projectmanagement"},{"$f":"Produktenlijst!R45","v":0},null,{"$f":"F43*$H$18","v":0},0,"maximaal 60%",0,0,"",null,"pm",{"$f":"F43*$P$18","v":0},0,"maximaal 60%",0,0,"",null,"pm",{"$f":"F43*$X$18","v":0},0,"maximaal 60%",0,0,"",null,"pm",{"$f":"F43*$AF$18","v":0},0,"maximaal 60%",0,0,"",null,"pm",{"$f":"F43*$AN$18","v":0},0,"maximaal 60%",0,0,""]
[]
[null,null,"1.2",{"$f":"Produktenlijst!G49","v":"Stedenbouwkundig plan"},null,{"$f":"SUM(F46:F51)","v":0},null,{"$f":"SUM(H46:H51)","v":0},null,null,{"$f":"SUM(K46:K51)","v":0},{"$f":"SUM(L46:L51)","v":0},null,null,"1.2",{"$f":"SUM(P46:P51)","v":0},null,null,{"$f":"SUM(S46:S51)","v":0},{"$f":"SUM(T46:T51)","v":0},null,null,"1.2",{"$f":"SUM(X46:X51)","v":0},null,null,{"$f":"SUM(AA46:AA51)","v":0},{"$f":"SUM(AB46:AB51)","v":0},null,null,"1.2",{"$f":"SUM(AF46:AF51)","v":0},null,null,{"$f":"SUM(AI46:AI51)","v":0},{"$f":"SUM(AJ46:AJ51)","v":0},null,null,"1.2",{"$f":"SUM(AN46:AN51)","v":0},null,null,{"$f":"SUM(AQ46:AQ51)","v":0},{"$f":"SUM(AR46:AR51)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K50","v":"Stedenbouw"},{"$f":"Produktenlijst!R50+Produktenlijst!R51+Produktenlijst!R52","v":0},null,{"$f":"F46*$H$18","v":0},0,"maximaal 90%",{"$f":"I46*H46","v":0},{"$f":"H46-K46","v":0},{"$f":"IF(I46>90%,\"X\",\"\")","v":""},null,"sted",{"$f":"F46*$P$18","v":0},0,"maximaal 90%",{"$f":"Q46*P46","v":0},{"$f":"P46-S46","v":0},{"$f":"IF(Q46>90%,\"X\",\"\")","v":""},null,"sted",{"$f":"F46*$X$18","v":0},0,"maximaal 90%",{"$f":"Y46*X46","v":0},{"$f":"X46-AA46","v":0},{"$f":"IF(Y46>90%,\"X\",\"\")","v":""},null,"sted",{"$f":"F46*$AF$18","v":0},0,"maximaal 90%",{"$f":"AG46*AF46","v":0},{"$f":"AF46-AI46","v":0},{"$f":"IF(AG46>90%,\"X\",\"\")","v":""},null,"sted",{"$f":"F46*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO46*AN46","v":0},{"$f":"AN46-AQ46","v":0},{"$f":"IF(AO46>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K53","v":"Projectmanagement"},{"$f":"Produktenlijst!R53","v":0},null,0,0,"maximaal 90%",{"$f":"I47*H47","v":0},{"$f":"H47-K47","v":0},{"$f":"IF(I47>90%,\"X\",\"\")","v":""},null,"pm",0,0,"maximaal 90%",0,0,{"$f":"IF(Q47>90%,\"X\",\"\")","v":""},null,"pm",0,0,"maximaal 90%",0,0,{"$f":"IF(Y47>90%,\"X\",\"\")","v":""},null,"pm",0,0,"maximaal 90%",0,0,{"$f":"IF(AG47>90%,\"X\",\"\")","v":""},null,"pm",0,0,"maximaal 90%",0,0,{"$f":"IF(AO47>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K54","v":"Planeconomie"},{"$f":"Produktenlijst!R54","v":0},null,0,0,"maximaal 90%",0,0,"",null,"pe",0,0,"maximaal 90%",0,0,"",null,"pe",0,0,"maximaal 90%",0,0,"",null,"pe",0,0,"maximaal 90%",0,0,"",null,"pe",0,0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K55","v":"Communicatie"},{"$f":"Produktenlijst!R55","v":0},null,0,0,"maximaal 90%",0,0,"",null,"com",0,0,"maximaal 90%",0,0,"",null,"com",0,0,"maximaal 90%",0,0,"",null,"com",0,0,"maximaal 90%",0,0,"",null,"com",0,0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K56","v":"Civiele techniek"},{"$f":"Produktenlijst!R56","v":0},null,0,0,"maximaal 90%",0,0,"",null,"civ",0,0,"maximaal 90%",0,0,"",null,"civ",0,0,"maximaal 90%",0,0,"",null,"civ",0,0,"maximaal 90%",0,0,"",null,"civ",0,0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K57","v":"Landmeten/vastgoedinformatie"},{"$f":"Produktenlijst!R57","v":0},null,0,0,"maximaal 90%",0,0,"",null,"vgi",0,0,"maximaal 90%",0,0,"",null,"vgi",0,0,"maximaal 90%",0,0,"",null,"vgi",0,0,"maximaal 90%",0,0,"",null,"vgi",0,0,"maximaal 90%",0,0,""]
[]
[null,null,"1.3",{"$f":"Produktenlijst!G59","v":"Beeldkwaliteitsplan"},null,{"$f":"SUM(F54:F57)","v":0},null,{"$f":"SUM(H54:H57)","v":0},null,null,{"$f":"SUM(K54:K57)","v":0},{"$f":"SUM(L54:L57)","v":0},null,null,"1.3",{"$f":"SUM(P54:P57)","v":0},null,null,{"$f":"SUM(S54:S57)","v":0},{"$f":"SUM(T54:T57)","v":0},null,null,"1.3",{"$f":"SUM(X54:X57)","v":0},null,null,{"$f":"SUM(AA54:AA57)","v":0},{"$f":"SUM(AB54:AB57)","v":0},null,null,"1.3",{"$f":"SUM(AF54:AF57)","v":0},null,null,{"$f":"SUM(AI54:AI57)","v":0},{"$f":"SUM(AJ54:AJ57)","v":0},null,null,"1.3",{"$f":"SUM(AN54:AN57)","v":0},null,null,{"$f":"SUM(AQ54:AQ57)","v":0},{"$f":"SUM(AR54:AR57)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K60","v":"Stedenbouw"},{"$f":"Produktenlijst!R60+Produktenlijst!R61+Produktenlijst!R62","v":0},null,{"$f":"F54*$H$18","v":0},0,"maximaal 90%",{"$f":"I54*H54","v":0},{"$f":"H54-K54","v":0},{"$f":"IF(I54>90%,\"X\",\"\")","v":""},null,"sted",{"$f":"F54*$P$18","v":0},0,"maximaal 90%",{"$f":"Q54*P54","v":0},{"$f":"P54-S54","v":0},{"$f":"IF(Q54>90%,\"X\",\"\")","v":""},null,"sted",{"$f":"F54*$X$18","v":0},0,"maximaal 90%",{"$f":"Y54*X54","v":0},{"$f":"X54-AA54","v":0},{"$f":"IF(Y54>90%,\"X\",\"\")","v":""},null,"sted",{"$f":"F54*$AF$18","v":0},0,"maximaal 90%",{"$f":"AG54*AF54","v":0},{"$f":"AF54-AI54","v":0},{"$f":"IF(AG54>90%,\"X\",\"\")","v":""},null,"sted",{"$f":"F54*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO54*AN54","v":0},{"$f":"AN54-AQ54","v":0},{"$f":"IF(AO54>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K63","v":"Projectmanagement"},{"$f":"Produktenlijst!R63","v":0},null,{"$f":"F55*$H$18","v":0},0,"maximaal 90%",{"$f":"I55*H55","v":0},{"$f":"H55-K55","v":0},{"$f":"IF(I55>90%,\"X\",\"\")","v":""},null,"pm",{"$f":"F55*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F55*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F55*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F55*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO55*AN55","v":0},0,{"$f":"IF(AO55>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K64","v":"Planeconomie"},{"$f":"Produktenlijst!R64","v":0},null,{"$f":"F56*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F56*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F56*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F56*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F56*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K65","v":"Landmeten/vastgoedinformatie"},{"$f":"Produktenlijst!R65","v":0},null,{"$f":"F57*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F57*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F57*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F57*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F57*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[]
[null,null,"2.1",{"$f":"Produktenlijst!G71","v":"Taxatie inbrengwaarde percelen"},{"$f":"Produktenlijst!H71","v":"Via  onafhankelijke taxatie"},{"$f":"SUM(F60:F63)","v":0},null,{"$f":"SUM(H60:H63)","v":0},null,null,{"$f":"SUM(K60:K63)","v":0},{"$f":"SUM(L60:L63)","v":0},null,null,"2.1",{"$f":"SUM(P60:P63)","v":0},null,null,{"$f":"SUM(S60:S63)","v":0},{"$f":"SUM(T60:T63)","v":0},null,null,"2.1",{"$f":"SUM(X60:X63)","v":0},null,null,{"$f":"SUM(AA60:AA63)","v":0},{"$f":"SUM(AB60:AB63)","v":0},null,null,"2.1",{"$f":"SUM(AF60:AF63)","v":0},null,null,{"$f":"SUM(AI60:AI63)","v":0},{"$f":"SUM(AJ60:AJ63)","v":0},null,null,"2.1",{"$f":"SUM(AN60:AN63)","v":0},null,null,{"$f":"SUM(AQ60:AQ63)","v":0},{"$f":"SUM(AR60:AR63)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K72","v":"Taxateur"},{"$f":"Produktenlijst!R72+Produktenlijst!R73","v":0},null,{"$f":"F60*$H$18","v":0},0,"maximaal 90%",{"$f":"I60*H60","v":0},{"$f":"H60-K60","v":0},{"$f":"IF(I60>90%,\"X\",\"\")","v":""},null,"tax",{"$f":"F60*$P$18","v":0},0,"maximaal 90%",{"$f":"Q60*P60","v":0},{"$f":"P60-S60","v":0},{"$f":"IF(Q60>90%,\"X\",\"\")","v":""},null,"tax",{"$f":"F60*$X$18","v":0},0,"maximaal 90%",{"$f":"Y60*X60","v":0},{"$f":"X60-AA60","v":0},{"$f":"IF(Y60>90%,\"X\",\"\")","v":""},null,"tax",{"$f":"F60*$AF$18","v":0},0,"maximaal 90%",{"$f":"AG60*AF60","v":0},{"$f":"AF60-AI60","v":0},{"$f":"IF(AG60>90%,\"X\",\"\")","v":""},null,"tax",{"$f":"F60*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO60*AN60","v":0},{"$f":"AN60-AQ60","v":0},{"$f":"IF(AO60>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K74","v":"Planeconomie"},{"$f":"Produktenlijst!R74","v":0},null,{"$f":"F61*$H$18","v":0},0,"maximaal 90%",{"$f":"I61*H61","v":0},{"$f":"H61-K61","v":0},{"$f":"IF(I61>90%,\"X\",\"\")","v":""},null,"pe",{"$f":"F61*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F61*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F61*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F61*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K75","v":"Projectmanagement"},{"$f":"Produktenlijst!R75","v":0},null,{"$f":"F62*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F62*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F62*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F62*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F62*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K76","v":"Landmeten/vastgoedinformatie"},{"$f":"Produktenlijst!R76","v":0},null,{"$f":"F63*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F63*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F63*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F63*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F63*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[]
[null,null,null,null,{"$f":"Produktenlijst!H78","v":"Via  Wet WOZ"},{"$f":"SUM(F66:F68)","v":0},null,{"$f":"SUM(H66:H68)","v":0},null,null,{"$f":"SUM(K66:K68)","v":0},{"$f":"SUM(L66:L68)","v":0},null,null,null,{"$f":"SUM(P66:P68)","v":0},null,null,{"$f":"SUM(S66:S68)","v":0},{"$f":"SUM(T66:T68)","v":0},null,null,null,{"$f":"SUM(X66:X68)","v":0},null,null,{"$f":"SUM(AA66:AA68)","v":0},{"$f":"SUM(AB66:AB68)","v":0},null,null,null,{"$f":"SUM(AF66:AF68)","v":0},null,null,{"$f":"SUM(AI66:AI68)","v":0},{"$f":"SUM(AJ66:AJ68)","v":0},null,null,null,{"$f":"SUM(AN66:AN68)","v":0},null,null,{"$f":"SUM(AQ66:AQ68)","v":0},{"$f":"SUM(AR66:AR68)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K79","v":"Planeconomie/grondzaken"},{"$f":"Produktenlijst!R79+Produktenlijst!R80","v":0},null,{"$f":"F66*$H$18","v":0},0,"maximaal 90%",{"$f":"I66*H66","v":0},{"$f":"H66-K66","v":0},{"$f":"IF(I66>90%,\"X\",\"\")","v":""},null,"pe/gz",{"$f":"F66*$P$18","v":0},0,"maximaal 90%",{"$f":"Q66*P66","v":0},{"$f":"P66-S66","v":0},{"$f":"IF(Q66>90%,\"X\",\"\")","v":""},null,"pe/gz",{"$f":"F66*$X$18","v":0},0,"maximaal 90%",{"$f":"Y66*X66","v":0},{"$f":"X66-AA66","v":0},{"$f":"IF(Y66>90%,\"X\",\"\")","v":""},null,"pe/gz",{"$f":"F66*$AF$18","v":0},0,"maximaal 90%",{"$f":"AG66*AF66","v":0},{"$f":"AF66-AI66","v":0},{"$f":"IF(AG66>90%,\"X\",\"\")","v":""},null,"pe/gz",{"$f":"F66*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO66*AN66","v":0},{"$f":"AN66-AQ66","v":0},{"$f":"IF(AO66>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K81","v":"Projectmanagement"},{"$f":"Produktenlijst!R81","v":0},null,{"$f":"F67*$H$18","v":0},0,"maximaal 90%",{"$f":"I67*H67","v":0},{"$f":"H67-K67","v":0},{"$f":"IF(I67>90%,\"X\",\"\")","v":""},null,"pm",{"$f":"F67*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F67*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F67*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F67*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K82","v":"Landmeten/vastgoedinformatie"},{"$f":"Produktenlijst!R82","v":0},null,{"$f":"F68*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F68*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F68*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F68*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F68*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[]
[null,null,null,null,{"$f":"Produktenlijst!H85","v":"Hertaxatie inbrengwaarde (vijfjaarlijks)"},{"$f":"Produktenlijst!R85","v":0},null,{"$f":"F70*$H$18","v":0},0,"maximaal 90%",0,0,"",null,null,{"$f":"F70*$P$18","v":0},0,"maximaal 90%",{"$f":"Q70*P70","v":0},{"$f":"P70-S70","v":0},{"$f":"IF(Q70>90%,\"X\",\"\")","v":""},null,null,{"$f":"F70*$X$18","v":0},0,"maximaal 90%",{"$f":"Y70*X70","v":0},{"$f":"X70-AA70","v":0},{"$f":"IF(Y70>90%,\"X\",\"\")","v":""},null,null,{"$f":"F70*$AF$18","v":0},0,"maximaal 90%",{"$f":"AG70*AF70","v":0},{"$f":"AF70-AI70","v":0},{"$f":"IF(AG70>90%,\"X\",\"\")","v":""},null,null,{"$f":"F70*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO70*AN70","v":0},{"$f":"AN70-AQ70","v":0},{"$f":"IF(AO70>90%,\"X\",\"\")","v":""}]
[]
[null,null,"2.2",{"$f":"Produktenlijst!G88","v":"Taxatie en aankoop onroerende zaak"},null,{"$f":"SUM(F73:F76)","v":0},null,{"$f":"SUM(H73:H76)","v":0},null,null,{"$f":"SUM(K73:K76)","v":0},{"$f":"SUM(L73:L76)","v":0},null,null,"2.2",{"$f":"SUM(P73:P76)","v":0},null,null,{"$f":"SUM(S73:S76)","v":0},{"$f":"SUM(T73:T76)","v":0},null,null,"2.2",{"$f":"SUM(X73:X76)","v":0},null,null,{"$f":"SUM(AA73:AA76)","v":0},{"$f":"SUM(AB73:AB76)","v":0},null,null,"2.2",{"$f":"SUM(AF73:AF76)","v":0},null,null,{"$f":"SUM(AI73:AI76)","v":0},{"$f":"SUM(AJ73:AJ76)","v":0},null,null,"2.2",{"$f":"SUM(AN73:AN76)","v":0},null,null,{"$f":"SUM(AQ73:AQ76)","v":0},{"$f":"SUM(AR73:AR76)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K89","v":"Grondzaken"},{"$f":"Produktenlijst!R89+Produktenlijst!R90+Produktenlijst!R91+Produktenlijst!R92+Produktenlijst!R93+Produktenlijst!R94+Produktenlijst!R95","v":0},null,{"$f":"F73*$H$18","v":0},0,"maximaal 90%",{"$f":"I73*H73","v":0},{"$f":"H73-K73","v":0},{"$f":"IF(I73>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F73*$P$18","v":0},0,"maximaal 90%",{"$f":"Q73*P73","v":0},{"$f":"P73-S73","v":0},{"$f":"IF(Q73>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F73*$X$18","v":0},0,"maximaal 90%",{"$f":"Y73*X73","v":0},{"$f":"X73-AA73","v":0},{"$f":"IF(Y73>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F73*$AF$18","v":0},0,"maximaal 90%",{"$f":"AG73*AF73","v":0},{"$f":"AF73-AI73","v":0},{"$f":"IF(AG73>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F73*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO73*AN73","v":0},{"$f":"AN73-AQ73","v":0},{"$f":"IF(AO73>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K96","v":"Projectmanagement"},{"$f":"Produktenlijst!R96","v":0},null,{"$f":"F74*$H$18","v":0},0,"maximaal 90%",{"$f":"I74*H74","v":0},{"$f":"H74-K74","v":0},{"$f":"IF(I74>90%,\"X\",\"\")","v":""},null,"pm",{"$f":"F74*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F74*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F74*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F74*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K97","v":"Planeconomie"},{"$f":"Produktenlijst!R97","v":0},null,{"$f":"F75*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F75*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F75*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F75*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F75*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K98","v":"Landmeten/vastgoedinformatie"},{"$f":"Produktenlijst!R98","v":0},null,{"$f":"F76*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F76*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F76*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F76*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F76*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[]
[null,null,"2.3",{"$f":"Produktenlijst!G100","v":"Onteigenen van onroerende zaken"},null,{"$f":"SUM(F79:F83)","v":0},null,{"$f":"SUM(H79:H83)","v":0},null,null,{"$f":"SUM(K79:K83)","v":0},{"$f":"SUM(L79:L83)","v":0},null,null,"2.3",{"$f":"SUM(P79:P83)","v":0},null,null,{"$f":"SUM(S79:S83)","v":0},{"$f":"SUM(T79:T83)","v":0},null,null,"2.3",{"$f":"SUM(X79:X83)","v":0},null,null,{"$f":"SUM(AA79:AA83)","v":0},{"$f":"SUM(AB79:AB83)","v":0},null,null,"2.3",{"$f":"SUM(AF79:AF83)","v":0},null,null,{"$f":"SUM(AI79:AI83)","v":0},{"$f":"SUM(AJ79:AJ83)","v":0},null,null,"2.3",{"$f":"SUM(AN79:AN83)","v":0},null,null,{"$f":"SUM(AQ79:AQ83)","v":0},{"$f":"SUM(AR79:AR83)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K101","v":"Grondzaken"},{"$f":"Produktenlijst!R101+Produktenlijst!R102","v":0},null,{"$f":"F79*$H$18","v":0},0,"maximaal 90%",{"$f":"I79*H79","v":0},{"$f":"H79-K79","v":0},{"$f":"IF(I79>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F79*$P$18","v":0},0,"maximaal 90%",{"$f":"Q79*P79","v":0},{"$f":"P79-S79","v":0},{"$f":"IF(Q79>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F79*$X$18","v":0},0,"maximaal 90%",{"$f":"Y79*X79","v":0},{"$f":"X79-AA79","v":0},{"$f":"IF(Y79>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F79*$AF$18","v":0},0,"maximaal 90%",{"$f":"AG79*AF79","v":0},{"$f":"AF79-AI79","v":0},{"$f":"IF(AG79>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F79*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO79*AN79","v":0},{"$f":"AN79-AQ79","v":0},{"$f":"IF(AO79>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K103","v":"Advocatuur"},{"$f":"Produktenlijst!R103","v":0},null,{"$f":"F80*$H$18","v":0},0,"maximaal 90%",{"$f":"I80*H80","v":0},{"$f":"H80-K80","v":0},{"$f":"IF(I80>90%,\"X\",\"\")","v":""},null,"adv",{"$f":"F80*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"adv",{"$f":"F80*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"adv",{"$f":"F80*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"adv",{"$f":"F80*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K104","v":"Projectmanagement"},{"$f":"Produktenlijst!R104","v":0},null,{"$f":"F81*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F81*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F81*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F81*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F81*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K105","v":"Planeconomie"},{"$f":"Produktenlijst!R105","v":0},null,{"$f":"F82*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F82*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F82*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F82*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F82*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K106","v":"Landmeten/vastgoedinformatie"},{"$f":"Produktenlijst!R106","v":0},null,{"$f":"F83*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F83*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F83*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F83*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F83*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[]
[null,null,"2.4",{"$f":"Produktenlijst!G108","v":"Vestigen voorkeursrecht "},null,{"$f":"SUM(F86:F89)","v":0},null,{"$f":"SUM(H86:H89)","v":0},null,null,{"$f":"SUM(K86:K89)","v":0},{"$f":"SUM(L86:L89)","v":0},null,null,"2.4",{"$f":"SUM(P86:P89)","v":0},null,null,{"$f":"SUM(S86:S89)","v":0},{"$f":"SUM(T86:T89)","v":0},null,null,"2.4",{"$f":"SUM(X86:X89)","v":0},null,null,{"$f":"SUM(AA86:AA89)","v":0},{"$f":"SUM(AB86:AB89)","v":0},null,null,"2.4",{"$f":"SUM(AF86:AF89)","v":0},null,null,{"$f":"SUM(AI86:AI89)","v":0},{"$f":"SUM(AJ86:AJ89)","v":0},null,null,"2.4",{"$f":"SUM(AN86:AN89)","v":0},null,null,{"$f":"SUM(AQ86:AQ89)","v":0},{"$f":"SUM(AR86:AR89)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K109","v":"Grondzaken"},{"$f":"Produktenlijst!R109","v":0},null,{"$f":"F86*$H$18","v":0},0,"maximaal 90%",{"$f":"I86*H86","v":0},{"$f":"H86-K86","v":0},{"$f":"IF(I86>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F86*$P$18","v":0},0,"maximaal 90%",{"$f":"Q86*P86","v":0},{"$f":"P86-S86","v":0},{"$f":"IF(Q86>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F86*$X$18","v":0},0,"maximaal 90%",{"$f":"Y86*X86","v":0},{"$f":"X86-AA86","v":0},{"$f":"IF(Y86>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F86*$AF$18","v":0},0,"maximaal 90%",{"$f":"AG86*AF86","v":0},{"$f":"AF86-AI86","v":0},{"$f":"IF(AG86>90%,\"X\",\"\")","v":""},null,"gz",{"$f":"F86*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO86*AN86","v":0},{"$f":"AN86-AQ86","v":0},{"$f":"IF(AO86>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K110","v":"Projectmanagement"},{"$f":"Produktenlijst!R110","v":0},null,{"$f":"F87*$H$18","v":0},0,"maximaal 90%",{"$f":"I87*H87","v":0},{"$f":"H87-K87","v":0},{"$f":"IF(I87>90%,\"X\",\"\")","v":""},null,"pm",{"$f":"F87*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F87*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F87*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F87*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K111","v":"Planeconomie"},{"$f":"Produktenlijst!R111","v":0},null,{"$f":"F88*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F88*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F88*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F88*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F88*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K112","v":"Landmeten/vastgoedinformatie"},{"$f":"Produktenlijst!R112","v":0},null,{"$f":"F89*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F89*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F89*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F89*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F89*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[]
[null,null,"2.5",{"$f":"Produktenlijst!G114","v":"Inrichtingsplan Openbare ruimte "},null,{"$f":"SUM(F92:F96)","v":0},null,{"$f":"SUM(H92:H96)","v":0},null,null,{"$f":"SUM(K92:K96)","v":0},{"$f":"SUM(L92:L96)","v":0},null,null,"2.5",{"$f":"SUM(P92:P96)","v":0},null,null,{"$f":"SUM(S92:S96)","v":0},{"$f":"SUM(T92:T96)","v":0},null,null,"2.5",{"$f":"SUM(X92:X96)","v":0},null,null,{"$f":"SUM(AA92:AA96)","v":0},{"$f":"SUM(AB92:AB96)","v":0},null,null,"2.5",{"$f":"SUM(AF92:AF96)","v":0},null,null,{"$f":"SUM(AI92:AI96)","v":0},{"$f":"SUM(AJ92:AJ96)","v":0},null,null,"2.5",{"$f":"SUM(AN92:AN96)","v":0},null,null,{"$f":"SUM(AQ92:AQ96)","v":0},{"$f":"SUM(AR92:AR96)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K115","v":"Stedenbouw, civiele techniek"},{"$f":"Produktenlijst!R115+Produktenlijst!R116","v":0},null,{"$f":"F92*$H$18","v":0},0,"maximaal 90%",{"$f":"I92*H92","v":0},{"$f":"H92-K92","v":0},{"$f":"IF(I92>90%,\"X\",\"\")","v":""},null,"sted/civ",{"$f":"F92*$P$18","v":0},0,"maximaal 90%",{"$f":"Q92*P92","v":0},{"$f":"P92-S92","v":0},{"$f":"IF(Q92>90%,\"X\",\"\")","v":""},null,"sted/civ",{"$f":"F92*$X$18","v":0},0,"maximaal 90%",{"$f":"Y92*X92","v":0},{"$f":"X92-AA92","v":0},{"$f":"IF(Y92>90%,\"X\",\"\")","v":""},null,"sted/civ",{"$f":"F92*$AF$18","v":0},0,"maximaal 90%",{"$f":"AG92*AF92","v":0},{"$f":"AF92-AI92","v":0},{"$f":"IF(AG92>90%,\"X\",\"\")","v":""},null,"sted/civ",{"$f":"F92*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO92*AN92","v":0},{"$f":"AN92-AQ92","v":0},{"$f":"IF(AO92>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K117","v":"Projectmanagement"},{"$f":"Produktenlijst!R117","v":0},null,{"$f":"F93*$H$18","v":0},0,"maximaal 90%",{"$f":"I93*H93","v":0},{"$f":"H93-K93","v":0},{"$f":"IF(I93>90%,\"X\",\"\")","v":""},null,"pm",{"$f":"F93*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F93*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F93*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pm",{"$f":"F93*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K118","v":"Planeconomie"},{"$f":"Produktenlijst!R118","v":0},null,{"$f":"F94*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F94*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F94*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F94*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F94*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K119","v":"Communicatie"},{"$f":"Produktenlijst!R119","v":0},null,{"$f":"F95*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"com",{"$f":"F95*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"com",{"$f":"F95*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"com",{"$f":"F95*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"com",{"$f":"F95*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K120","v":"Landmeten/vastgoedinformatie"},{"$f":"Produktenlijst!R120","v":0},null,{"$f":"F96*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F96*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F96*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F96*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"vgi",{"$f":"F96*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[]
[null,null,"2.6",{"$f":"Produktenlijst!G122","v":"Voorbereiding, toezicht en directievoering bij civiel en cultuurtechnische werken"},null,{"$f":"SUM(F99:F101)","v":0},null,{"$f":"SUM(H99:H101)","v":0},null,null,{"$f":"SUM(K99:K101)","v":0},{"$f":"SUM(L99:L101)","v":0},null,null,"2.6",{"$f":"SUM(P99:P101)","v":0},null,null,{"$f":"SUM(S99:S101)","v":0},{"$f":"SUM(T99:T101)","v":0},null,null,"2.6",{"$f":"SUM(X99:X101)","v":0},null,null,{"$f":"SUM(AA99:AA101)","v":0},{"$f":"SUM(AB99:AB101)","v":0},null,null,"2.6",{"$f":"SUM(AF99:AF101)","v":0},null,null,{"$f":"SUM(AI99:AI101)","v":0},{"$f":"SUM(AJ99:AJ101)","v":0},null,null,"2.6",{"$f":"SUM(AN99:AN101)","v":0},null,null,{"$f":"SUM(AQ99:AQ101)","v":0},{"$f":"SUM(AR99:AR101)","v":0}]
[null,null,null,{"$f":"Produktenlijst!H123","v":"slopen"},{"$f":"Produktenlijst!K123","v":"Ingenieursbureau"},{"$f":"Produktenlijst!R123","v":0},null,{"$f":"F99*$H$18","v":0},0,"maximaal 80%",{"$f":"I99*H99","v":0},{"$f":"H99-K99","v":0},{"$f":"IF(I99>80%,\"X\",\"\")","v":""},null,"ib",{"$f":"F99*$P$18","v":0},0,"maximaal 80%",{"$f":"Q99*P99","v":0},{"$f":"P99-S99","v":0},{"$f":"IF(Q99>80%,\"X\",\"\")","v":""},null,"ib",{"$f":"F99*$X$18","v":0},0,"maximaal 80%",{"$f":"Y99*X99","v":0},{"$f":"X99-AA99","v":0},{"$f":"IF(Y99>80%,\"X\",\"\")","v":""},null,"ib",{"$f":"F99*$AF$18","v":0},0,"maximaal 80%",{"$f":"AG99*AF99","v":0},{"$f":"AF99-AI99","v":0},{"$f":"IF(AG99>80%,\"X\",\"\")","v":""},null,"ib",{"$f":"F99*$AN$18","v":0},0,"maximaal 80%",{"$f":"AO99*AN99","v":0},{"$f":"AN99-AQ99","v":0},{"$f":"IF(AO99>80%,\"X\",\"\")","v":""}]
[null,null,null,{"$f":"Produktenlijst!H124","v":"ophogen/voorbelasten"},{"$f":"Produktenlijst!K124","v":"Ingenieursbureau"},{"$f":"Produktenlijst!R124","v":0},null,{"$f":"F100*$H$18","v":0},0,"maximaal 80%",{"$f":"I100*H100","v":0},{"$f":"H100-K100","v":0},{"$f":"IF(I100>80%,\"X\",\"\")","v":""},null,"ib",{"$f":"F100*$P$18","v":0},0,"maximaal 80%",0,0,{"$f":"IF(Q100>80%,\"X\",\"\")","v":""},null,"ib",{"$f":"F100*$X$18","v":0},0,"maximaal 80%",0,0,{"$f":"IF(Y100>80%,\"X\",\"\")","v":""},null,"ib",{"$f":"F100*$AF$18","v":0},0,"maximaal 80%",0,0,{"$f":"IF(AG100>80%,\"X\",\"\")","v":""},null,"ib",{"$f":"F100*$AN$18","v":0},0,"maximaal 80%",0,0,{"$f":"IF(AO100>80%,\"X\",\"\")","v":""}]
[null,null,null,{"$f":"Produktenlijst!H125","v":"bouw en woonrijpmaken"},{"$f":"Produktenlijst!K125","v":"Ingenieursbureau"},{"$f":"Produktenlijst!R125","v":0},null,{"$f":"F101*$H$18","v":0},0,"maximaal 80%",0,0,"",null,"ib",{"$f":"F101*$P$18","v":0},0,"maximaal 80%",0,0,"",null,"ib",{"$f":"F101*$X$18","v":0},0,"maximaal 80%",0,0,"",null,"ib",{"$f":"F101*$AF$18","v":0},0,"maximaal 80%",0,0,"",null,"ib",{"$f":"F101*$AN$18","v":0},0,"maximaal 80%",0,0,""]
[]
[null,null,"2.7",{"$f":"Produktenlijst!G128","v":"Algemene en financiele verantwoording en aansturing  van het project"},null,{"$f":"SUM(F104:F106)","v":0},null,{"$f":"SUM(H104:H106)","v":0},null,null,{"$f":"SUM(K104:K106)","v":0},{"$f":"SUM(L104:L106)","v":0},null,null,"2.7",{"$f":"SUM(P104:P106)","v":0},null,null,{"$f":"SUM(S104:S106)","v":0},{"$f":"SUM(T104:T106)","v":0},null,null,"2.7",{"$f":"SUM(X104:X106)","v":0},null,null,{"$f":"SUM(AA104:AA106)","v":0},{"$f":"SUM(AB104:AB106)","v":0},null,null,"2.7",{"$f":"SUM(AF104:AF106)","v":0},null,null,{"$f":"SUM(AI104:AI106)","v":0},{"$f":"SUM(AJ104:AJ106)","v":0},null,null,"2.7",{"$f":"SUM(AN104:AN106)","v":0},null,null,{"$f":"SUM(AQ104:AQ106)","v":0},{"$f":"SUM(AR104:AR106)","v":0}]
[null,null,null,null,{"$f":"Produktenlijst!K129","v":"Projectmanagement"},{"$f":"Produktenlijst!R129","v":0},null,{"$f":"F104*$H$18","v":0},0,"maximaal 90%",{"$f":"I104*H104","v":0},{"$f":"H104-K104","v":0},{"$f":"IF(I104>90%,\"X\",\"\")","v":""},null,"pm",{"$f":"F104*$P$18","v":0},0,"maximaal 90%",{"$f":"Q104*P104","v":0},{"$f":"P104-S104","v":0},{"$f":"IF(Q104>90%,\"X\",\"\")","v":""},null,"pm",{"$f":"F104*$X$18","v":0},0,"maximaal 90%",{"$f":"Y104*X104","v":0},{"$f":"X104-AA104","v":0},{"$f":"IF(Y104>90%,\"X\",\"\")","v":""},null,"pm",{"$f":"F104*$AF$18","v":0},0,"maximaal 90%",{"$f":"AG104*AF104","v":0},{"$f":"AF104-AI104","v":0},{"$f":"IF(AG104>90%,\"X\",\"\")","v":""},null,"pm",{"$f":"F104*$AN$18","v":0},0,"maximaal 90%",{"$f":"AO104*AN104","v":0},{"$f":"AN104-AQ104","v":0},{"$f":"IF(AO104>90%,\"X\",\"\")","v":""}]
[null,null,null,null,{"$f":"Produktenlijst!K130","v":"Projectassistentie"},{"$f":"Produktenlijst!R130","v":0},null,{"$f":"F105*$H$18","v":0},0,"maximaal 90%",{"$f":"I105*H105","v":0},{"$f":"H105-K105","v":0},{"$f":"IF(I105>90%,\"X\",\"\")","v":""},null,"pa",{"$f":"F105*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pa",{"$f":"F105*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pa",{"$f":"F105*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pa",{"$f":"F105*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[null,null,null,null,{"$f":"Produktenlijst!K131","v":"Planeconomie"},{"$f":"Produktenlijst!R131","v":0},null,{"$f":"F106*$H$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F106*$P$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F106*$X$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F106*$AF$18","v":0},0,"maximaal 90%",0,0,"",null,"pe",{"$f":"F106*$AN$18","v":0},0,"maximaal 90%",0,0,""]
[]
[]
[null,null,null,"TOTAAL PLANKOSTEN",null,{"$f":"F103+F91+F98+F85+F78+F72+F65+F59+F53+F45+F21+F41+F33+F29+F70","v":0},null,{"$f":"H103+H91+H98+H85+H78+H72+H65+H59+H53+H45+H21+H41+H33+H29+H70","v":0},null,null,{"$f":"K103+K91+K98+K85+K78+K72+K65+K59+K53+K45+K21+K41+K33+K29+K70","v":0},{"$f":"L103+L91+L98+L85+L78+L72+L65+L59+L53+L45+L21+L41+L33+L29+L70","v":0},null,null,null,{"$f":"P103+P91+P98+P85+P78+P72+P65+P59+P53+P45+P21+P41+P33+P29+P70","v":0},null,null,{"$f":"S103+S91+S98+S85+S78+S72+S65+S59+S53+S45+S21+S41+S33+S29+S70","v":0},{"$f":"T103+T91+T98+T85+T78+T72+T65+T59+T53+T45+T21+T41+T33+T29+T70","v":0},null,null,null,{"$f":"X103+X91+X98+X85+X78+X72+X65+X59+X53+X45+X21+X41+X33+X29+X70","v":0},null,null,{"$f":"AA103+AA91+AA98+AA85+AA78+AA72+AA65+AA59+AA53+AA45+AA21+AA41+AA33+AA29+AA70","v":0},{"$f":"AB103+AB91+AB98+AB85+AB78+AB72+AB65+AB59+AB53+AB45+AB21+AB41+AB33+AB29+AB70","v":0},null,null,null,{"$f":"AF103+AF91+AF98+AF85+AF78+AF72+AF65+AF59+AF53+AF45+AF21+AF41+AF33+AF29+AF70","v":0},null,null,{"$f":"AI103+AI91+AI98+AI85+AI78+AI72+AI65+AI59+AI53+AI45+AI21+AI41+AI33+AI29+AI70","v":0},{"$f":"AJ103+AJ91+AJ98+AJ85+AJ78+AJ72+AJ65+AJ59+AJ53+AJ45+AJ21+AJ41+AJ33+AJ29+AJ70","v":0},null,null,null,{"$f":"AN103+AN91+AN98+AN85+AN78+AN72+AN65+AN59+AN53+AN45+AN21+AN41+AN33+AN29+AN70","v":0},null,null,{"$f":"AQ103+AQ91+AQ98+AQ85+AQ78+AQ72+AQ65+AQ59+AQ53+AQ45+AQ21+AQ41+AQ33+AQ29+AQ70","v":0},{"$f":"AR103+AR91+AR98+AR85+AR78+AR72+AR65+AR59+AR53+AR45+AR21+AR41+AR33+AR29+AR70","v":0}]

{"sheet":"Hulpblad","index":6,"n_rows":195,"n_cols":17,"rows_kept":195,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"+Vragenlijst!C7","v":"Plankostenregels bij kostenverhaal MET tijdvak"}]
[]
[null,null,"HULPBLAD"]
[]
[null,"Plankosten SLOPEN"]
[]
[null,"Op te halen variabelen uit vragen- en produktenlijst"]
[null,null,"Is sprake van slopen?",null,null,{"$f":"IF(+Vragenlijst!Q99=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"+IF(F8=\"nee\",0,1)","v":0}]
[null,null,"Aantal m3",null,null,{"$f":"+Vragenlijst!H101","v":0},"m3"]
[null,null,"Verrekenfactor",null,null,{"$f":"1+Vragenlijst!X104","v":1},"gemiddeld type te slopen onroerende zaak"]
[null,null,"Aantal bestekken sloop",null,null,{"$f":"+Vragenlijst!H109","v":0},"antwoord op vraag in vragenlijst"]
[null,null,"Verrekenfactor",null,null,{"$f":"1+Vragenlijst!X114","v":1},"wijze van aanbesteding"]
[null,null,"Verrekenfactor",null,null,{"$f":"IF(Vragenlijst!Q111=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"1+Vragenlijst!H112/100","v":1},"aanwezigheid asbest"]
[]
[null,null,"Tarief CT projectleider",null,null,{"$f":"+Produktenlijst!S9","v":151},"per uur"]
[null,null,"Tarief bestekschrijver/calculator",null,null,{"$f":"+Produktenlijst!V7","v":119},"per uur"]
[null,null,"Tarief directievoerder",null,null,{"$f":"+Produktenlijst!V10","v":132},"per uur"]
[null,null,"Tarief toezichthouder",null,null,{"$f":"+Produktenlijst!V11","v":107},"per uur"]
[]
[null,"Uitgangspunten slopen"]
[]
[null,"Voorbereiding, aanbesteding en gunning"]
[null,null,"Bestekschrijver/calculator",null,null,12,"uur per bestek "]
[null,null,"Verrekenfactor",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":"+F9/300*F27","v":0},"uur"]
[null,null,"Verrekenfactor",null,null,{"$f":"+F10","v":1},"type te slopen onroerende zaak"]
[null,null,"Verrekenfactor",null,null,{"$f":"+F12","v":1},"wijze van aanbesteding"]
[null,null,"Verrekenfactor",null,null,{"$f":"+G13","v":1},"aanwezigheid asbest"]
[null,null,"Directievoering",null,null,{"$f":"1","v":1},"uur per week gedurende uitvoeringstijd"]
[null,null,"Ttoezichthouden",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,"Verrekenfactor",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,"Verrekenfactor",null,null,{"$f":"+F10","v":1},"type te slopen onroerende zaak"]
[null,null,"Verrekenfactor",null,null,{"$f":"+G13","v":1},"aanwezigheid asbest"]
[]
[null,"Plankosten ",null,null,null,null,"euro's",null,"uren"]
[]
[null,null,"Aanbesteding en gunning",null,null,null,{"$f":"(+F23*F11*F24*F16)*G8","v":0},null,{"$f":"(+F23*F11*F24)*G8","v":0}]
[null,null,"Directievoering en toezicht",null,null,null,{"$f":"(+(((F28)/40*(F29)*(F30)*F31*F32*F17)+((F28)/40*(F29)*(F30)*F31*F33*F18))*G8)","v":0},null,{"$f":"(+(((F28)/40*(F29)*(F30)*F31*F32)+((F28)/40*(F29)*(F30)*F31*F33))*G8)","v":0}]
[null,null,"Projectleiding",null,null,null,{"$f":"(+(F36*F11*F15*(F37)+F38*(F28)/40*F15*F39)*F40)*G8","v":0},null,{"$f":"(+(F36*F11*(F37)+F38*(F28)/40*F39)*F40)*G8","v":0}]
[]
[null,"Totaal plankosten SLOPEN",null,null,null,null,{"$f":"SUM(G44:G46)*G8","v":0},null,{"$f":"SUM(I44:I46)*G8","v":0}]
[]
[]
[]
[null,"Plankosten BOUW EN WOONRIJPMAKEN"]
[]
[null,"Op te halen variabelen uit vragen- en produktenlijst"]
[null,null,"Is sprake van bouw-en woonrijpmaken?",null,null,{"$f":"IF(+Vragenlijst!Q135=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"+IF(F55=\"nee\",0,1)","v":0}]
[null,null,"Kostenverhaalsgebied",null,null,{"$f":"+Vragenlijst!H23/10000","v":0},"ha"]
[null,null,"Aantal deelgebieden volgens de norm",null,null,{"$f":"+(F56/2.5)","v":0},"(2,5 ha per deelgebied)",null,null,null,null,null,"verhouding openbaar/uitgeefbaar tov norm",{"$f":"+Vragenlijst!Q49","v":1}]
[null,null,"Aantal deelgebieden cf verhouding grondgebruik",null,null,{"$f":"+F57*N69","v":0},null,null,null,null,null,null,"hulptabel te berekenen aantal deelgebieden"]
[null,null,"Type locatie",null,null,{"$f":"CONCATENATE(Vragenlijst!Q29,Vragenlijst!R29,Vragenlijst!S29,Vragenlijst!T29,Vragenlijst!U29)","v":""},null,null,null,null,null,null,"% t.o.v. norm","verrekeningsfactor"]
[null,null,"Aantal bestekken dat bij type locatie hoort",null,null,{"$f":"IF(F59=\"uitleg\",2*F58,IF(F59=\"uitbreiding\",2*F58,1.5*F58))","v":0},null,null,null,null,null,null,1,1]
[null,null,"Verrekenfactor",null,null,{"$f":"1+Vragenlijst!Y138","v":1},"wijze van aanbesteden",null,null,null,null,null,1.1200000000000001,1.05]
[null,null,"Bodemsanering ?",null,null,{"$f":"+IF(Vragenlijst!Q147=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"+Vragenlijst!S148/100","v":0},"van het exploitatiegebied",null,null,null,null,1.25,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,1.38,1.1499999999999999]
[null,null,"Tarief CT projectleider",null,null,{"$f":"+Produktenlijst!S9","v":151},"per uur",null,null,null,null,null,1.5,1.2]
[null,null,"Tarief CT ontwerper",null,null,{"$f":"+Produktenlijst!V8","v":151},"per uur",null,null,null,null,null,1.5,1.2]
[null,null,"Tarief bestekschrijver/calculator",null,null,{"$f":"+Produktenlijst!V7","v":119},"per uur"]
[null,null,"Tarief CT tekenaar",null,null,{"$f":"+Produktenlijst!V9","v":107},"per uur"]
[null,null,"Tarief directievoerder",null,null,{"$f":"+Produktenlijst!V10","v":132},"per uur"]
[null,null,"Ttarief toezichthouder",null,null,{"$f":"+Produktenlijst!V11","v":107},"per uur",null,null,null,null,null,"te hanteren verreken % t.o.v. norm deelgebieden:",{"$f":"IF(N57<$M$60,$N$60,IF(N57<$M$61,$N60+((N57-$M$60)/($M$61-$M$60))*($N$61-$N$60),\nIF(N57<$M$62,$N$61+((N57-$M$61)/($M$62-$M$61))*($N$62-$N$61),\nIF(N57<$M$63,$N$62+((N57-$M$62)/($M$63-$M$62))*($N$63-$N$62),\nIF(N57<$M$64,$N$63+((N57-$M$63)/($M$64-$M$63))*($N$64-$N$63),\nIF(N57<$M$65,$N$64+((N57-$M$64)/($M$65-$M$64))*($N$65-$N$64),$N$65))))))","v":1}]
[]
[null,"Uitgangspunten BOUW EN WOONRIJPMAKEN"]
[]
[null,"Ontwerp VO en DO:"]
[null,null,"Aantal deelgebieden",null,null,{"$f":"+F57","v":0},"deelgebieden"]
[null,null,"Uren CT ontwerper",null,null,160,"per ontwerp VO en DO  per deelgebied "]
[null,null,"Rioleringsplan",null,null,7.5,"uur per ha"]
[]
[null,"Aanbesteding en gunning"]
[null,null,"Aantal bestekken",null,null,{"$f":"+F60","v":0},"brm en wrm"]
[null,null,"Verrekenfactor",null,null,{"$f":"+F61","v":1},"wijze van aanbesteding"]
[null,null,"Bestekschrijver/calculator",null,null,40,"uur per bestek"]
[null,null,"CT 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(F62=\"ja\",2*G62,0)","v":0},"maanden "]
[null,null,"Totaal uitvoeringstijd bestekken",null,null,{"$f":"+(F85+F86)*F60/2","v":0},"maanden"]
[null,null,"Verrekenfactor",null,null,{"$f":"+F61","v":1},"wijze van aanbesteding"]
[null,null,"Directievoering",null,null,5,"uur per week gedurende uitvoeringstijd"]
[null,null,"Toezichthouden",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,"Verrekenfactor",null,null,{"$f":"+F61","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":"(+F74*F75*F65+F76*F56*F65)*G55","v":0},null,{"$f":"(+F74*F75+F76*F56)*G55","v":0}]
[null,null,"Aanbesteding en gunning",null,null,null,{"$f":"(+F79*F81*F66*(F80)+F79*F82*F67*(F80))*G55","v":0},null,{"$f":"(+F79*F81*(F80)+F79*F82*(F80))*G55","v":0}]
[null,null,"Directievoering en toezicht",null,null,null,{"$f":"(+F87*4*F89*F68*F88+F87*4*F90*F69*F88)*G55","v":0},null,{"$f":"(+F87*4*F89+F87*4*F90*F88)*G55","v":0}]
[null,null,"Projectleiding",null,null,null,{"$f":"(+F93*F58*F64+F94*F60*F64*(F95)+F96*F87*4*F64)*G55","v":0},null,{"$f":"(+F93*F58+F94*F60*(F95)+F96*F87*4)*G55","v":0}]
[]
[null,"Totaal plankosten BOUW EN WOONRIJPMAKEN",null,null,null,null,{"$f":"SUM(G99:G102)*G55","v":0},null,{"$f":"SUM(I99:I102)*G55","v":0}]
[]
[]
[]
[]
[]
[]
[null,"PLANKOSTEN OPHOGEN/VOORBELASTEN"]
[]
[null,"Op te halen variabelen uit plankostenscan"]
[null,null,"Is sprake van ophogen/voorbelasten?",null,null,{"$f":"IF(+Vragenlijst!Q124=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"+IF(F114=\"nee\",0,1)","v":0}]
[null,null,"Omvang plangebied",null,null,{"$f":"+Vragenlijst!H23/10000","v":0},"ha"]
[null,null,"Integraal of partieel",null,null,{"$f":"IF(Vragenlijst!Q125=TRUE,\"integraal\",\"partieel\")","v":"partieel"}]
[null,null,"Hoogte ophogen",null,null,{"$f":"+Vragenlijst!H130","v":0},"m1"]
[null,null,"Aantal fases/deelplannen",null,null,{"$f":"+Vragenlijst!H128","v":0},"stuks"]
[null,null,"Zettingstijd",null,null,{"$f":"+Vragenlijst!H129","v":0},"jaar"]
[null,null,"Tarief directievoerder ",null,null,{"$f":"+Produktenlijst!V10","v":132},"per uur"]
[null,null,"Tarief toezichthouder",null,null,{"$f":"+Produktenlijst!V11","v":107},"per uur"]
[]
[null,"Basiskosten ophogen"]
[null,"uitgangspunt: 10 ha en 1 m1 ophogen"]
[null,null,"Bestek",null,null,12844,"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,6422,"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+F149)","v":19266},{"$f":"L131","v":19266},{"$f":"CEILING(M131/I131,25)","v":1950},{"$f":"basisbedrag_rapportage","v":6422},{"$f":"basisbedrag_rapportage","v":6422},{"$f":"CEILING(P131/I131,25)","v":650}]
[null,null,null,null,null,null,{"$f":"I131","v":10},{"$f":"H131","v":"ha"},15,{"$f":"J131","v":"ha"},0.9,{"$f":"M131","v":19266},{"$f":"I132*K132*$N$131","v":26325},{"$f":"CEILING(M132/I132,25)","v":1775},{"$f":"P131","v":6422},{"$f":"I132*K132*$Q$131","v":8775},{"$f":"CEILING(P132/I132,25)","v":600}]
[null,null,null,null,null,null,{"$f":"I132","v":15},{"$f":"H132","v":"ha"},50,{"$f":"J132","v":"ha"},0.75,{"$f":"M132","v":26325},{"$f":"I133*K133*$N$131","v":73125},1475,{"$f":"P132","v":8775},{"$f":"I133*K133*$Q$131","v":24375},500]
[null,null,null,null,null,null,{"$f":"I133","v":50},{"$f":"H133","v":"ha"},100,"ha",0.5,{"$f":"M133","v":73125},{"$f":"I134*K134*$N$131","v":97500},975,{"$f":"P133","v":24375},{"$f":"I134*K134*$Q$131","v":32500},325]
[]
[null,null,"Veldonderzoeken",null,null,2569,"per ha"]
[null,null,"Monitoring",null,null,1606,"per ha per jaar zettingstijd"]
[null,null,"Inmeting",null,null,642,"per ha"]
[null,null,"Directievoering",null,null,{"$f":"(10*10000*$F$117)/$F$145/5*($F$120*4)","v":0},"1/2 dag per week, gedurende aanbrengtijd, is dus afhankelijk van hoogte en groote werk"]
[null,null,"Toezichthouder",null,null,{"$f":"(10*10000*$F$117)/$F$145/5*($F$121*4)","v":0},"1/2 dag per week, gedurende aanbrengtijd, is dus afhankelijk van hoogte en groote werk"]
[null,"Totaal basiskosten ophogen",null,null,null,{"$f":"SUM(F125:F140)","v":24083},"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(F116=\"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$131,$M$131,IF(AND(grootte_fase>$G$132,grootte_fase<=$I$132),IF($N$132*grootte_fase<$L$132,$L$132,$N$132*grootte_fase),IF(AND(grootte_fase>$G$133,grootte_fase<=$I$133),IF($N$133*grootte_fase<$L$133,$L$133,$N$133*grootte_fase),IF(grootte_fase>G134,IF(IF($N$134*grootte_fase<$L$134,$L$134,$N$134*grootte_fase)>$M$134,$M$134,IF($N$134*grootte_fase<$L$134,$L$134,$N$134*grootte_fase)),0))))*aantal_fases","v":0}]
[null,null,"Rapportage",null,null,null,{"$f":"IF(grootte_fase<=$I$131,$P$131,IF(AND(grootte_fase>$G$132,grootte_fase<=$I$132),IF($Q$132*grootte_fase<$O$132,$O$132,$Q$132*grootte_fase),IF(AND(grootte_fase>$G$133,grootte_fase<=$I$133),IF($Q$133*grootte_fase<$O$133,$O$133,$Q$133*grootte_fase),IF(grootte_fase>G134,IF(IF($Q$134*grootte_fase<$O$134,$O$134,$Q$134*grootte_fase)>$P$134,$P$134,IF($Q$134*grootte_fase<$O$134,$O$134,$Q$134*grootte_fase)),0))))*aantal_fases","v":0}]
[null,null,"Veldonderzoeken",null,null,null,{"$f":"IF(basisbedrag_veldonderzoeken*plangebied*IF(F116=\"partieel\",F148,1)<5137,5137,basisbedrag_veldonderzoeken*plangebied*IF(F116=\"partieel\",F148,1))","v":5137}]
[null,null,"Monitoring",null,null,null,{"$f":"IF(+basisbedrag_monitoring*zettingstijd*plangebied*IF(F116=\"partieel\",F148,1)<3211,3211,plangebied*zettingstijd*basisbedrag_monitoring*IF(F116=\"partieel\",F148,1))","v":3211}]
[null,null,"Inmeting",null,null,null,{"$f":"IF(+basisbedrag_inmeting*plangebied*IF(F116=\"partieel\",F148,1)<1285,1285,basisbedrag_inmeting*plangebied*IF(F116=\"partieel\",F148,1))","v":1285}]
[null,null,"Directievoering",null,null,null,{"$f":"(((+plangebied*IF(F116=\"partieel\",F148,1)*ophooghoogte*10000/levering_per_as_per_dag)/5)*tarief_civiel*uren_per_week_directievoering)","v":0}]
[null,null,"Toezichthouder",null,null,null,{"$f":"((plangebied*IF(F116=\"partieel\",F148,1)*ophooghoogte*10000/levering_per_as_per_dag/5)*F121*uren_per_week_toezichthouden)","v":0}]
[null,"Totaal plankosten ophogen ",null,null,null,null,{"$f":"SUM(G151:G157)*G114","v":0}]
[]
[]
[]
[null,"Hulptabel kosten projectbesluit en omgevingsvergunning",null,null,null,null,null,null,"Hulptabel kosten Omgevingsplan"]
[]
[null,{"$f":"+Vragenlijst!Q23","v":0},"ha kostenverhaalsgebied",null,null,{"$f":"+IF(Vragenlijst!Q66=TRUE,Vragenlijst!H67,1)","v":1},"onderdeel van groter omgevingsplan",null,{"$f":"+Vragenlijst!Q23","v":0},"ha kostenverhaalsgebied",null,null,{"$f":"+IF(Vragenlijst!Q66=TRUE,Vragenlijst!H67,1)","v":1},"onderdeel van groter omgevingsplan"]
[null,{"$f":"IF(B164<0.5,B167,(IF(B164<1,B168,IF(B164<3,B169,(IF(B164<5,B170,(IF(B164<10,B171,IF(B164<15,B172,IF(B164<20,B173,IF(B164<=50,B174,B175)))))))))))*F164","v":60},"uur projectbesluit of omgevingsvergunning voor een buitenplanse omgevingsactiviteit",null,null,null,null,null,{"$f":"IF(I164<0.5,I167,(IF(I164<1,I168,IF(I164<3,I169,(IF(I164<5,I170,(IF(I164<10,I171,IF(I164<15,I172,IF(I164<20,I173,IF(I164<=50,I174,I175)))))))))))*M164","v":100},"uur voor gedetailleerd omgevingsplan"]
[]
[null,60,"uur voor kostenverhaalgebied < 0,5 ha",null,null,null,null,null,100,"uur voor kostenverhaalgebied < 0,5 ha"]
[null,120,"uur voor kostenverhaalgebied tussen 0,5 ha en 1 ha",null,null,null,null,null,200,"uur voor kostenverhaalgebied tussen 0,5 ha en 1 ha"]
[null,200,"uur voor kostenverhaalgebied tussen 1 ha en 3 ha",null,null,null,null,null,300,"uur voor kostenverhaalgebied tussen 1 ha en 3 ha"]
[null,300,"uur voor kostenverhaalgebied tussen 3 ha en 5 ha",null,null,null,null,null,400,"uur voor kostenverhaalgebied tussen 3 ha en 5 ha"]
[null,350,"uur voor kostenverhaalgebied tussen 5 ha en 10 ha",null,null,null,null,null,450,"uur voor kostenverhaalgebied tussen 5 ha en 10 ha"]
[null,400,"uur voor kostenverhaalgebied tussen 10 ha en 15 ha",null,null,null,null,null,500,"uur voor kostenverhaalgebied tussen 10 ha en 15 ha"]
[null,450,"uur voor kostenverhaalgebied tussen 15 ha en 20 ha",null,null,null,null,null,550,"uur voor kostenverhaalgebied tussen 15 ha en 20 ha"]
[null,500,"uur voor kostenverhaalgebied tussen 20 ha en 50 ha",null,null,null,null,null,600,"uur voor kostenverhaalgebied tussen 20 ha en 50 ha"]
[null,550,"uur voor kostenverhaalgebied groter dan 50 ha",null,null,null,null,null,700,"uur voor kostenverhaalgebied groter dan 50 ha"]
[]
[]
[]
[]
[]
[null,"hulptabel opstellen regels kostenverhaal",null,null,null,null,null,"hulptabel opstellen regles kostenverhaal"]
[null,"bij een omgevingsplan",null,null,{"$f":"+M164","v":1},"onderdeel van groter omgevingsplan",null,null,null,null,{"$f":"+F164","v":1},"onderdeel van groter omgevingsplan"]
[null,null,null,null,null,null,null,"projectbesluit of omgevingsvergunning voor een buitenplanse omgevingsactiviteit"]
[null,{"$f":"+Vragenlijst!Q23","v":0},"ha kostenverhaalsgebied",null,null,null,null,{"$f":"+Vragenlijst!Q23","v":0},"ha kostenverhaalsgebied"]
[null,{"$f":"IF(B184<0.5,B187,(IF(B184<1,B188,IF(B184<3,B189,(IF(B184<5,B190,(IF(B184<10,B191,IF(B184<15,B192,IF(B184<20,B193,IF(B184<=50,B194,B195)))))))))))*E182","v":38},"uur voor opstellen kostenverhaalsregels",null,null,null,null,{"$f":"IF(H184<0.5,H187,(IF(H184<1,H188,IF(H184<3,H189,(IF(H184<5,H190,(IF(H184<10,H191,IF(H184<15,H192,IF(H184<20,H193,IF(H184<=50,H194,H195)))))))))))*K182","v":25},"uur voor opstellen kostenverhaalsregels"]
[]
[null,38,"uur voor kostenverhaalgebied < 0,5 ha",null,null,null,null,{"$f":"25","v":25},"uur voor kostenverhaalgebied < 0,5 ha"]
[null,75,"uur voor kostenverhaalgebied tussen 0,5 ha en 1 ha",null,null,null,null,{"$f":"50","v":50},"uur voor kostenverhaalgebied tussen 0,5 ha en 1 ha"]
[null,113,"uur voor kostenverhaalgebied tussen 1 ha en 3 ha",null,null,null,null,{"$f":"75","v":75},"uur voor kostenverhaalgebied tussen 1 ha en 3 ha"]
[null,150,"uur voor kostenverhaalgebied tussen 3 ha en 5 ha",null,null,null,null,{"$f":"100","v":100},"uur voor kostenverhaalgebied tussen 3 ha en 5 ha"]
[null,173,"uur voor kostenverhaalgebied tussen 5 ha en 10 ha",null,null,null,null,{"$f":"115","v":115},"uur voor kostenverhaalgebied tussen 5 ha en 10 ha"]
[null,188,"uur voor kostenverhaalgebied tussen 10 ha en 15 ha",null,null,null,null,{"$f":"125","v":125},"uur voor kostenverhaalgebied tussen 10 ha en 15 ha"]
[null,300,"uur voor kostenverhaalgebied tussen 15 ha en 20 ha",null,null,null,null,{"$f":"200","v":200},"uur voor kostenverhaalgebied tussen 15 ha en 20 ha"]
[null,375,"uur voor kostenverhaalgebied tussen 20 ha en 50 ha",null,null,null,null,{"$f":"250","v":250},"uur voor kostenverhaalgebied tussen 20 ha en 50 ha"]
[null,450,"uur voor kostenverhaalgebied groter dan 50 ha",null,null,null,null,{"$f":"300","v":300},"uur voor kostenverhaalgebied groter dan 50 ha"]