{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Titel","Invulinstructie","Vragenlijst","Produktenlijst","Resultaat","Hulpblad"],"not_rendered":{"charts":0,"images":90,"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":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Rekenmodel voor het berekenen van de plankosten"]
[null,null,null,"bij kostenverhaal zonder tijdvak 2024-2"]
[]
[]
[null,null,null,"Dit rekenmodel kan worden toegepast bij omgevingsplannen waarover na 1 oktober 2024 een besluit wordt genomen."]
[null,null,null,"Het rekenmodel bevat de nieuwe, geindexeerde tarieven voor de plankosten 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":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Uitgangspunten plankostenregels kostenverhaal ZONDER 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, is 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 uren 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)."]
[]
[null,null,"De uren die te maken hebben met individuele  dienstverlening  (lees aanvraag omgevingsvergunning) worden NIET via deze regeling geraamd maar dienen via de legesverordening te worden verhaald."]
[]
[null,null,"Het systeem berekent zelf over hoeveel jaren plankosten die voorafgaand aan de vastelling 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,null,"De plankosten bij kostenverhaal zonder tijdvak, zijn alleen de plankosten voor gronden die een openbare functie krijgen en niet de plankosten voor de gronden waar de bouwactiviteiten plaatsvinden."]
[]
[]
[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 (het te bepalen kostenplafond)."]
[]
[]
[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":157,"n_cols":25,"rows_kept":157,"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 ZONDER 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,"Scenario","….",null,null,null,null,null,null,"AANTEKENINGEN"]
[]
[]
[null,null,null,"I","Algemeen",null,null,null,null,null,null,"vraag:",null,"Algemeen"]
[]
[null,null,null,1,"Wat is de looptijd van de ontwikkeling vanaf het moment van vaststellen van het omgevingsplan ?",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 de ontwikkeling is dan",null,{"$f":"IF(H19>0,+Q20+H19,0)","v":0},"jaar",null,null,null,null,null,{"$f":"+IF(Produktenlijst!N20<=130%,2,IF(Produktenlijst!N20<150%,3,IF(Produktenlijst!N20>=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":"J23","v":0}]
[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 gebied\", \"\")","v":""},{"$f":"+IF(R26=TRUE,\"binnenstedelijke locatie\", \"\")","v":""},{"$f":"+IF(S26=TRUE,\"inbreidingslocatie\", \"\")","v":""},{"$f":"+IF(T26=TRUE,\"uitbreidingslocatie\", \"\")","v":""},{"$f":"+IF(U26=TRUE,\"uitleglocatie\", \"\")","v":""}]
[null,null,null,4,"Betreft het een herstructurerings danwel transformatie opgave ?",null,null,null,null,null,null,4,"aantekeningen",null,null,null,false,false,null,null,null,{"$f":"IF(Q31=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(Q31=TRUE,\"herstructurering/transformatie\", \"\")","v":""}]
[]
[]
[null,null,null,5,"Zijn de volgende onderzoeken nodig voor het kostenverhaalsgebied?",null,null,null,null,null,null,5,"aantekeningen",null,null,null,false,{"$f":"+IF(Q35=TRUE,\"MER\", \"\")","v":""},null,null,{"$f":"+IF(Q35=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(Q36=TRUE,\" /Nader luchtonderzoek\", \"\")","v":""},null,null,{"$f":"+IF(Q36=TRUE,0.4,0)","v":0},{"$f":"+MAX(U35:U38)","v":0},"IF V"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"+IF(Q37=TRUE,\" Aanvullend archeologisch onderzoek \", \"\")","v":""},null,null,{"$f":"+IF(Q37=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(Q154=TRUE,0.2,0)","v":0},{"$f":"IF(U38>0,\"bodemsanering\",\"\")","v":""}]
[]
[]
[null,null,null,6,"Wat zijn de  (maximaal) beoogde kostenverhaalsplichtige bouwactiviteiten in het kostenverhaalsgebied volgens het gekozen scenario ?","woonfunctie",null,null,"aantal",null,null,6,"aantekeningen",null,null,null,{"$f":"+H41","v":0},{"$f":"IF(Q41>1,1,0)","v":0},{"$f":"+IF(Q41>0,F41,\"\")","v":""},null,{"$f":"+IF(R46>1,0.1,0)*R41","v":0}]
[null,null,null,null,null,"(lichte) industriefunctie",null,null,"m2 uitgeefbaar",null,null,null,null,null,null,null,{"$f":"+H42","v":0},{"$f":"IF(Q42>1,1,0)","v":0},{"$f":"+IF(Q42>0,F42,\"\")","v":""},null,{"$f":"+IF(R46>1,0.1,-0.25)*R42","v":0}]
[null,null,null,null,null,"kantoorfunctie/winkelfunctie/sportfunctie",null,null,"m2 bvo",null,null,null,null,null,null,null,{"$f":"+H43","v":0},{"$f":"IF(Q43>1,1,0)","v":0},{"$f":"+IF(Q43>0,F43,\"\")","v":""},null,{"$f":"0.1*R43","v":0},{"$f":"SUM(U41:U45)","v":0},"IF IV"]
[null,null,null,null,null,"gezondheidszorgfunctie/onderwijsfunctie",null,null,"m2 bvo",null,null,null,null,null,null,null,{"$f":"+H44","v":0},{"$f":"IF(Q44>1,1,0)","v":0},{"$f":"+IF(Q44>0,F44,\"\")","v":""},null,{"$f":"0.25*R44","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(Q45>0,F45,\"\")","v":""},null,{"$f":"0.1*R45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q42:Q45)","v":0},{"$f":"SUM(R41:R45)","v":0}]
[null,null,null,null,"De dichtheid is",{"$f":"IF(H23>0,+(H41+(H42+H43+H44)/100)/H23*10000,0)","v":0},null,"won(equivalent) per ha: ",{"$f":"IF(F47<31,\"suburbaan\",IF(F47>100,\"hoogstedelijk\",\"stedelijk\"))","v":"suburbaan"},"woon-werkmlieu"]
[null,null,null,null,null,null,null,null,null,null,null,null,"aantekeningen"]
[]
[null,null,null,7,"Stelt de gemeente bij het Omgevingsplan ook de volgende plannen op?",null,null,null,null,null,null,7]
[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,null,null,null,null,null,null,null,null,"aantekeningen"]
[null,null,null,8,"Maakt dit kostenverhaalsbesluit deel uit van een groter Omgevingsplan ? ",null,null,null,null,null,null,{"$f":"+D56","v":8},null,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":"+H57","v":0},{"$f":"J23/Q57","v":{"$error":"#DIV/0!"}},"ha groot is het omgevingsplan"]
[null,null,null,null,"Het totale Omgevingsplan is dus",{"$f":"IF(H57>0%,J23/Q57,J23)","v":0},null,"ha groot"]
[]
[]
[]
[]
[null,null,null,"II","aanleg van nieuwe openbare voorzieningen door de gemeente",null,null,null,null,null,null,"II","aanleg van nieuwe openbare voorzieningen door de gemeente"]
[]
[null,null,null,null,"Inbreng en verwerving van onroerende zaken ten behoeve van toekomstig openbare voorzieningen die door de gemeente worden aangelegd",null,null,null,null,null,null,"vraag"]
[null,null,null,null,null,null,null,"Waardering via Wet WOZ",null,"waardering via onafhankelijke taxatie"]
[null,null,null,1,"Uit hoeveel kadastrale percelen bestaat het toekomstig openbaar gebied binnen het kostenverhaals gebied en hoeveel daarvan zijn onbebouwd en bebouwd?",null,null,null,"totaal",null,"totaal",{"$f":"+D67","v":1},"aantekeningen",null,null,null,{"$f":"+H67+J67","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(H68:H69)<>H67,\"fout\",\"\")","v":""},{"$f":"IF(AND(H67>0,J67>0),\"klopt dit\",\"\")","v":""},{"$f":"IF(SUM(J68:J69)<>J67,\"fout\",\"\")","v":""}]
[null,null,null,2,"Hoeveel onroerende zaken is de gemeente van plan daadwerkelijk te verwerven tbv het toekomstige openbaar gebied ?",null,null,null,"totaal",null,null,{"$f":"+D71","v":2},"aantekeningen",null,null,null,{"$f":"+H71","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 percelen met bijzondere objecten",null,"d",null,"stuks"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUM(H72:H75)<>H71,\"fout optelling a tm d komt niet overeen met het totaal\",\"\")","v":""}]
[null,null,null,3,"Van hoeveel huur(pacht)ontbindingen is sprake ?",null,null,null,"stuks",null,null,{"$f":"+D77","v":3},"aantekeningen"]
[]
[null,null,null,4,"Indien er met een onteigeningsplan wordt gewerkt  ",null,null,null,null,null,null,{"$f":"+D79","v":4},"aantekeningen"]
[null,null,null,"a","voor hoeveel onroerende zaken wordt een onteigeningsbeschikking voorbereid?",{"$f":"IF(H80>H71,\"meer dan het aantal verwervingen\",\"\")","v":""},"a",null,"stuks",null,null,null,null,null,null,null,{"$f":"+H80","v":0}]
[null,null,null,"b","in hoeveel van die gevallen komt het tot een bekrachtingsprocedure onteigeningsbeschikking ?",{"$f":"IF(H81>H80,\"meer dan vraag 4a\",\"\")","v":""},"b",null,"stuks",null,null,null,null,null,null,null,{"$f":"+H81","v":0},null,null,{"$f":"IF(H81=1,0.1,(IF(H81>1,0.2,0)))","v":0},"IF III"]
[]
[]
[null,null,null,5,"Wordt of is een voorkeursrecht gevestigd ?",null,null,null,null,null,null,{"$f":"+D84","v":5},"aantekeningen",null,null,null,false,false,{"$f":"+IF(Q84=TRUE,1,0)","v":0}]
[]
[null,null,null,null,"Omvang toekomstig openbaar gebied dat door de gemeente wordt aangelegd"]
[]
[null,null,null,6,"Hoeveel  m2 openbaar gebied  van het kostenverhaalsgebied wordt door de gemeente aangelegd? Zoals ook in het scenario danwel stedenbouwkundig plan is aangegeven.",{"$f":"IF(H23>0,+H88/H23,0)","v":0},null,null,"m2 openbaar gebied (groen, verharding en water)",null,null,{"$f":"+D88","v":6},"aantekeningen",null,null,null,{"$f":"IF(F88>40%,F88/40%,1)","v":1}]
[null,null,null,"a","Hoeveel hiervan is m2 verharding?",null,null,null,"m2 verharding",{"$f":"IF(H89>0,H89/H88,\"\")","v":""}]
[null,null,null,null,"Dus is hiervan m2 groen/water: ",null,null,{"$f":"+H88-H89","v":0},"m2 groen/water",{"$f":"IF(H90>0,H90/H88,\"\")","v":""}]
[]
[null,null,null,7,"Stelt de gemeente hiervoor een inrichtingsplan openbare ruimte op ?",null,null,null,null,null,null,{"$f":"+D92","v":7},"aantekeningen",null,null,null,false,false]
[]
[]
[null,null,null,null,"Civiele en cultuurtechniek ten behoeve van de toekomstige openbare voorzieningen die door de gemeente worden aangelegd "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(#REF!=TRUE,1,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,true]
[]
[]
[null,null,null,null,"Slopen ten behoeve van de toekomstige openbare voorzieningen die door de gemeente worden aangelegd"]
[]
[null,null,null,8,"Is sprake van sloop van onroerende zaken ?",null,null,null,null,null,null,{"$f":"+D103","v":8},"aantekeningen",null,null,null,false,false,null,{"$f":"IF(Q103=TRUE,1,0)","v":0}]
[null,null,null,null,null,{"$f":"+IF(R103=TRUE,\"ga door naar vraag 9\",\"\")","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":"+H105","v":0}]
[]
[null,null,null,"b","Wat voor een soort te slopen onroerende zaken zijn het?  Het gaat hoofdzakelijk om:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Invloedsfactor ",null,{"$f":"+AVERAGE(W109:W110)","v":0}]
[null,null,null,null,"Meerdere antwoorden zijn mogelijk",null,null,null,"%",null,null,null,null,null,null,null,false,{"$f":"+H109/100","v":0},null,null,null,{"$f":"IF(Q109=TRUE,-1,0)","v":0},{"$f":"+V109*R109","v":0}]
[null,null,null,null,{"$f":"IF(AND(Q109=FALSE,R109>0),\"aanzetten \",\"\")","v":""},null,null,{"$f":"IF(AND(Q109=TRUE,R109=0),\"% invullen\",\"\")","v":""},null,null,null,null,null,null,null,null,false,{"$f":"+H111/100","v":0},null,null,null,{"$f":"IF(Q110=TRUE,0,0)","v":0},{"$f":"+V110*R110","v":0}]
[null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,{"$f":"SUM(R109:R110)","v":0}]
[null,null,null,null,null,{"$f":"IF(AND(Q110=FALSE,R110>0),\"aanzetten \",\"\")","v":""},null,{"$f":"IF(AND(Q110=TRUE,R110=0),\"% invullen\",\"\")","v":""},{"$f":"IF(AND(Q103=TRUE,(R111<>100%)),\"fout totaal is niet 100%\",\" \")","v":" "}]
[]
[null,null,null,"c","In hoeveel bestekken worden deze m3 gesloopt?",null,null,null,{"$f":"IF(H114>0,H105/H114,\"\")","v":""},{"$f":"IF(H114>0,\"m3 per bestek\",\"\")","v":""},null,null,null,null,null,null,{"$f":"+H114","v":0}]
[]
[]
[null,null,null,null,{"$f":"IF(R118=TRUE,\"ga door naar vraag 8f\",\"\")","v":""}]
[null,null,null,"d","Is er sprake van asbest in de te slopen onroerende zaken?",null,null,null,{"$f":"IF(AND(Q118=FALSE,T120>0),\"fout er is geen sprake van asbest\",\"\")","v":""},null,null,null,null,null,null,null,false,false,null,{"$f":"+IF(Q118=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,"%",null,{"$f":"IF(AND(Q118=TRUE,T120>100%),\"fout\",\" \")","v":" "},null,null,null,null,null,null,null,null,{"$f":"+H120/100","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(T118=1,T120<=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(Q103=TRUE,+AVERAGE(W123:W127),0)","v":0}]
[null,null,null,null,"Meerdere antwoorden zijn mogelijk",null,null,null,"%",null,null,null,null,null,null,null,false,{"$f":"+H123","v":0},null,null,null,{"$f":"IF(Q123=TRUE,0,0)","v":0},{"$f":"V123*(R123/R126)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF(AND(Q123=FALSE,R123>0),\"aanzetten \",\"\")","v":""},null,null,{"$f":"IF(AND(Q123=TRUE,R123=0),\"percentage invullen\",\"\")","v":""},null,null,null,null,null,null,null,null,false,{"$f":"+H125","v":0}]
[null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,false,{"$f":"+H127","v":0},null,null,null,{"$f":"IF(Q124=TRUE,0.25,0)","v":0},{"$f":"V125*(R124/R126)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF(AND(Q124=FALSE,R124>0),\"aanzetten \",\"\")","v":""},null,null,{"$f":"IF(AND(Q124=TRUE,R124=0),\"percentage invullen\",\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(R123:R125)","v":0}]
[null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q125=TRUE,1,0)","v":0},{"$f":"V127*(R125/R126)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF(AND(Q125=FALSE,R125>0),\"aanzetten \",\"\")","v":""},null,null,{"$f":"IF(AND(Q125=TRUE,R125=0),\"percentage invullen\",\"\")","v":""},{"$f":"IF(AND(Q103=TRUE,H127+H125+H123<>100),\"het totaal is meer of minder dan  100%\",\"\")","v":""}]
[]
[null,null,null,null,"Ophogen/voorbelasten ten behoeve van de toekomstige openbare voorzieningen die door de gemeente worden aangelegd"]
[null,null,null,null,{"$f":"IF(R132=TRUE,\" ga door naar vraag 10\",\" \")","v":" "}]
[null,null,null,9,"Is sprake van ophoging danwel voorbelasting ?",null,null,null,null,null,null,{"$f":"+D132","v":9},"aantekeningen",null,null,null,false,false,{"$f":"IF(Q132=TRUE,1,0)","v":0}]
[]
[]
[null,null,null,"a","In hoeveel deelplannen/fasen wordt er opgehoogd/voorbelast?",null,"a",null,"deelplan/fase"]
[null,null,null,"b","Wat is de gemiddelde te verwachten zettingstijd?",null,"b",null,"jaar"]
[null,null,null,"c","Wat is de gemiddelde hoogte van de voorbelasting?",null,"c",null,"m1"]
[]
[]
[null,null,null,null,"Bouw en woonrijpmaken ten behoeve van de toekomstige openbare voorzieningen die door de gemeente worden aangelegd"]
[]
[null,null,null,10,"Is sprake van bouw-en of woonrijpmaken ?",null,null,null,null,null,null,{"$f":"+D142","v":10},"aantekeningen",null,null,null,false,false,{"$f":"IF(Q142=TRUE,1,0)","v":0}]
[]
[null,null,null,null,{"$f":"IF(R142=TRUE,\" ga door naar 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(Q142=TRUE,+AVERAGE(X146:X148),0)","v":0}]
[null,null,null,null,"Meerdere antwoorden zijn mogelijk",null,null,null,"%",null,null,null,null,null,null,null,false,{"$f":"+H146","v":0},null,null,null,null,{"$f":"IF(Q146=TRUE,0,0)","v":0},{"$f":"W146*(R146/R149)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF(AND(Q146=FALSE,R146>0),\"aanzetten \",\"\")","v":""},null,null,{"$f":"IF(AND(Q146=TRUE,R146=0),\"percentage invullen\",\"\")","v":""},null,null,null,null,null,null,null,null,false,{"$f":"+H148","v":0},null,null,null,null,{"$f":"IF(Q147=TRUE,0.25,0)","v":0},{"$f":"W147*(R147/R149)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,false,{"$f":"+H150","v":0},null,null,null,null,{"$f":"IF(Q148=TRUE,1,0)","v":0},{"$f":"W148*(R148/R149)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF(AND(Q147=FALSE,R147>0),\"aanzetten \",\"\")","v":""},null,null,{"$f":"IF(AND(Q147=TRUE,R147=0),\"percentage invullen\",\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"SUM(R146:R148)","v":0}]
[null,null,null,null,{"$f":"IF(AND(Q148=FALSE,R148>0),\"aanzetten \",\"\")","v":""},null,null,null,"%"]
[null,null,null,null,null,null,null,{"$f":"IF(AND(Q148=TRUE,R148=0),\"percentage invullen\",\"\")","v":""},{"$f":"IF(AND(Q142=TRUE,H150+H148+H146<>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(Q154=FALSE,S156>0),\"fout\",\"\")","v":""},null,null,null,null,null,null,null,false,false,null,{"$f":"IF(Q154=TRUE,1,0)","v":0}]
[]
[null,null,null,"c","Zo ja, in hoeveel procent van het openbaar gebied is hier sprake van ? ",null,null,null,"%",{"$f":"IF(AND(Q154=FALSE,S156>0),\"zet vraag 10 b op ja\",\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"+H156","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(AND(Q154=TRUE,H156=0),\"% aangeven\",\"\")","v":""}]

{"sheet":"Produktenlijst","index":3,"n_rows":122,"n_cols":22,"rows_kept":122,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"+Vragenlijst!C7","v":"Plankostenregels bij kostenverhaal ZONDER tijdvak "}]
[]
[]
[null,null,null,null,null,"Produkten/werkzaamheden"]
[null,null,null,null,null,null,null,null,null,null,null,"Invloedsfactoren :",null,"omschrijving:",null,null,null,"Tarieven na 1 oktober 2024 excl btw","€€/uur",null,"Tarieven na 1 oktober 2024 excl btw","€€/uur"]
[null,null,null,null,null,"Datum",null,{"$f":"+Vragenlijst!F10","v":"2024-02-28"},null,null,null,null,null,null,null,null,null,"Beleidsafdelingen",151,null,"Bestekschrijven/calculeren",119]
[null,null,null,null,null,"Gemeente",null,{"$f":"+Vragenlijst!F11","v":"…."},null,null,null,"I Ligging kostenverhaalsgebied",{"$f":"+Vragenlijst!V26","v":0},{"$f":"+Hulpblad!F60","v":""},null,null,null,"Communicatie",132,null,"Civiel technisch ontwerpen",151]
[null,null,null,null,null,"Projectnaam",null,{"$f":"+Vragenlijst!F12","v":"…."},null,null,null,"II Type opgave",{"$f":"+Vragenlijst!V31","v":0},{"$f":"+Vragenlijst!Q32","v":""},null,null,null,"Civiel technisch projectleiden",151,null,"Civiel technisch tekenen",107]
[null,null,null,null,null,"Kostenverhaalsgebied",null,{"$f":"+Vragenlijst!F13","v":"…."},null,null,null,"III Verwervingssituatie",{"$f":"+Vragenlijst!T81","v":0},{"$f":"+Vragenlijst!Q81","v":0},"onteigeningsbeschikkingen",null,null,"Grondzaken",151,null,"Directievoeren",132]
[null,null,null,null,null,"Scenario",null,{"$f":"+Vragenlijst!F14","v":"…."},null,null,null,"IV Type programma",{"$f":"+Vragenlijst!V43","v":0},{"$f":"CONCATENATE(Vragenlijst!S41,  Vragenlijst!S42,  Vragenlijst!S43, Vragenlijst!S44,Vragenlijst!S45)","v":""},null,null,null,"Landmeten/vastgoedinformatie",119,null,"Toezichthouden",107]
[null,null,null,null,null,null,null,null,null,null,null,"V Onderzoeken",{"$f":"+Vragenlijst!V36","v":0},{"$f":"CONCATENATE(Vragenlijst!R35,  Vragenlijst!R36)","v":""},null,{"$f":"CONCATENATE(Vragenlijst!R37, Vragenlijst!V38)","v":""},null,"Omgevingsrecht",151]
[null,null,null,null,null,null,null,null,null,null,null,"VI Woon-werkmilieu",{"$f":"+IF(Vragenlijst!I47=\"suburbaan\",0%,IF(Vragenlijst!I47=\"stedelijk\",-100%,-150%))","v":0},{"$f":"+Vragenlijst!I47","v":"suburbaan"},null,null,null,"Planeconomie",151]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",171]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Projectmanagementassistentie",119]
[null,null,null,null,null,null,null,null,null,null,null,"(I tm V) complexiteitsfactor","algemeen",{"$f":"1+AVERAGE(M12:M16)","v":1},null,null,null,"Stedenbouw",151]
[null,null,null,null,null,null,null,null,null,null,null,"(I,II,V, VI) complexiteitsfactor","stedenbouw",{"$f":"1+(M12+M13+M16+M17)/4","v":1}]
[]
[null,"tbv macro",null,null,null,null,"Produkten/werkzaamheden",null,null,null,null,"welke discilines werken aan het produkt?","Aantal","Uren of bedrag ","Tarief","complexiteitsfactor  van toepassing?",null,"Totaal in euro's",{"$f":"S25+S62","v":0},null,"Totaal in uren",{"$f":"V25+V62","v":0}]
[]
[null,null,null,null,null,null,1,"Omgevingsplan",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S27:S60)","v":0},null,null,{"$f":"SUM(V27:V60)","v":0}]
[]
[null,true,{"$f":"+IF(D27=TRUE,1,0)","v":0},false,null,null,"1.1","Opstellen van een scenario tbv vaststellen kostenplafond",null,null,null,"Stedenbouw,beleid, ",null,null,null,null,null,null,{"$f":"SUM(R28:R30)","v":0},null,null,{"$f":"SUM(U28:U30)","v":0}]
[null,null,null,null,null,null,null,null,"Opstellen scenario",null,null,"civiel, planeconomie",1,{"$f":"IF(Vragenlijst!Q51=TRUE,Hulpblad!B188,Hulpblad!B195)","v":132},{"$f":"+S20","v":151},"ja",{"$f":"+IF(P28=\"ja\",$N$20,100%)","v":1},{"$f":"Q28*O28*N28*M28*C$27","v":0},null,null,{"$f":"C$27*M28*N28*Q28","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+N28","v":132},{"$f":"+S18","v":171},"ja",{"$f":"+IF(P29=\"ja\",$N$20,100%)","v":1},{"$f":"Q29*O29*N29*M29*C$27","v":0},null,null,{"$f":"C$27*M29*N29*Q29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+N29","v":132},{"$f":"+S15","v":119},"ja",{"$f":"+IF(P30=\"ja\",$N$20,100%)","v":1},{"$f":"Q30*O30*N30*M30*C27","v":0},null,null,{"$f":"C27*M30*N30*Q30","v":0}]
[null,true,{"$f":"+IF(D31=TRUE,1,0)","v":0},false,null,null,"1.2","Opstellen en vaststellen omgevingsplan",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R32:R37)","v":0},null,null,{"$f":"SUM(U32:U37)","v":0}]
[null,null,null,null,null,null,null,null,"opstellen en vaststellen omgevingsplan",null,null,"Omgevingsrecht jurist incl digitalisering/kaartmateriaal ",1,{"$f":"+Hulpblad!B165","v":60},{"$f":"+S16","v":151},"ja",{"$f":"+IF(P32=\"ja\",$N$20,100%)","v":1},{"$f":"Q32*O32*N32*M32*D31","v":0},null,null,{"$f":"C$31*M32*N32*Q32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",7.4999999999999997E-2,{"$f":"+N32","v":60},{"$f":"+S18","v":171},"ja",{"$f":"+IF(P33=\"ja\",$N$20,100%)","v":1},{"$f":"Q33*O33*N33*M33*D$31","v":0},null,null,{"$f":"C$31*M33*N33*Q33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Stedenbouw",0.1,{"$f":"+N32","v":60},{"$f":"+S20","v":151},"ja",{"$f":"+IF(P34=\"ja\",$N$20,100%)","v":1},{"$f":"Q34*O34*N34*M34*D$31","v":0},null,null,{"$f":"C$31*M34*N34*Q34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.01,{"$f":"+N33","v":60},{"$f":"+S17","v":151},"ja",{"$f":"+IF(P35=\"ja\",$N$20,100%)","v":1},{"$f":"Q35*O35*N35*M35*D$31","v":0},null,null,{"$f":"C$31*M35*N35*Q35","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Beleldsafdelingen",0.1,{"$f":"+N34","v":60},{"$f":"+S11","v":151},"ja",{"$f":"+IF(P36=\"ja\",$N$20,100%)","v":1},{"$f":"Q36*O36*N36*M36*D$31","v":0},null,null,{"$f":"C$31*M36*N36*Q36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Communicatie",0.05,{"$f":"+N35","v":60},{"$f":"+S12","v":132},"ja",{"$f":"+IF(P37=\"ja\",$N$20,100%)","v":1},{"$f":"Q37*O37*N37*M37*D$31","v":0},null,null,{"$f":"C$31*M37*N37*Q37","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R39:R40)","v":0},null,null,{"$f":"SUM(U39:U40)","v":0}]
[null,null,null,null,null,null,null,null,"opstellen regels kostenverhaal",null,null,"Grondzaken en planeconomie",1,{"$f":"+Hulpblad!H188","v":38},{"$f":"+S14","v":151},"ja",{"$f":"+IF(P39=\"ja\",$N$20,100%)","v":1},{"$f":"Q39*O39*N39*M39*D31","v":0},null,null,{"$f":"D$31*M39*N39*Q39","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+N39","v":38},{"$f":"+S18","v":171},"ja",{"$f":"+IF(P40=\"ja\",$N$20,100%)","v":1},{"$f":"Q40*O40*N40*M40*D$31","v":0},null,null,{"$f":"D$31*M40*N40*Q40","v":0}]
[]
[null,{"$f":"+Vragenlijst!Q51","v":false},{"$f":"+IF(D42=TRUE,1,0)","v":0},false,null,null,"1.3","Stedenbouwkundig plan",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R43:R50)","v":0},null,null,{"$f":"SUM(U43:U50)","v":0}]
[null,null,null,null,null,null,null,null,"uur per gebouw met een woonfunctie (aantal woningen)",null,null,"Stedenbouw",{"$f":"+Vragenlijst!H41","v":0},1.5,{"$f":"+S20","v":151},"CF stedenbouw",{"$f":"+N21","v":1},{"$f":"Q43*O43*N43*M43*C42","v":0},null,null,{"$f":"C42*M43*N43*Q43","v":0}]
[null,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!Q46/100","v":0},0.25,{"$f":"+S20","v":151},"CF stedenbouw",{"$f":"+N21","v":1},{"$f":"Q44*O44*N44*M44*C42","v":0},null,null,{"$f":"C42*M44*N44*Q44","v":0}]
[null,null,null,null,null,null,null,null,"opslag uren bij maatschappelijke functies",null,null,"Stedenbouw",{"$f":"IF(Vragenlijst!Q44>1,1,0)","v":0},{"$f":"40","v":40},{"$f":"+S20","v":151},"CF stedenbouw",{"$f":"+N21","v":1},{"$f":"Q45*O45*N45*M45*C42","v":0},null,null,{"$f":"C42*M45*N45*Q45","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.15,{"$f":"+N43*M43+N44*M44+N45*M45","v":0},{"$f":"+S18","v":171},"CF stedenbouw",{"$f":"+N21","v":1},{"$f":"Q46*O46*N46*M46*C42","v":0},null,null,{"$f":"C42*M46*N46*Q46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.1,{"$f":"+N46","v":0},{"$f":"+S17","v":151},"CF stedenbouw",{"$f":"+N21","v":1},{"$f":"Q47*O47*N47*M47*C42","v":0},null,null,{"$f":"C42*M47*N47*Q47","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Communicatie",7.4999999999999997E-2,{"$f":"+N47","v":0},{"$f":"+S12","v":132},"CF stedenbouw",{"$f":"+N21","v":1},{"$f":"Q48*O48*N48*M48*C42","v":0},null,null,{"$f":"C42*M48*N48*Q48","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Civiele techniek",0.1,{"$f":"+N48","v":0},{"$f":"+S13","v":151},"CF stedenbouw",{"$f":"+N21","v":1},{"$f":"Q49*O49*N49*M49*C42","v":0},null,null,{"$f":"C42*M49*N49*Q49","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+N49","v":0},{"$f":"+S15","v":119},"CF stedenbouw",{"$f":"+N21","v":1},{"$f":"Q50*O50*N50*M50*C42","v":0},null,null,{"$f":"C42*M50*N50*Q50","v":0}]
[]
[]
[null,{"$f":"+Vragenlijst!Q52","v":false},{"$f":"+IF(D53=TRUE,1,0)","v":0},false,null,null,"1.4","Beeldkwaliteitsplan",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R54:R59)","v":0},null,null,{"$f":"SUM(U54:U59)","v":0}]
[null,null,null,null,null,null,null,null,"uur per gebouw met een woonfunctie",null,null,"Stedenbouw",{"$f":"+Vragenlijst!H41","v":0},0.5,{"$f":"+S20","v":151},"nee",{"$f":"+IF(P54=\"ja\",$N$20,100%)","v":1},{"$f":"Q54*O54*N54*M54*C53","v":0},null,null,{"$f":"C53*M54*N54*Q54","v":0}]
[null,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!Q46/100","v":0},{"$f":"0.25","v":0.25},{"$f":"+S20","v":151},"nee",{"$f":"+IF(P55=\"ja\",$N$20,100%)","v":1},{"$f":"Q55*O55*N55*M55*C53","v":0},null,null,{"$f":"C53*M55*N55*Q55","v":0}]
[null,null,null,null,null,null,null,null,"opslag uren bij maatschappelijke functies",null,null,"Stedenbouw",{"$f":"IF(Vragenlijst!Q44>1,1,0)","v":0},{"$f":"40","v":40},{"$f":"+S20","v":151},"nee",{"$f":"+IF(P56=\"ja\",$N$20,100%)","v":1},{"$f":"Q56*O56*N56*M56*C53","v":0},null,null,{"$f":"C53*M56*N56*Q56","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+N54*M54+N55*M55+N56*M56","v":0},{"$f":"+S18","v":171},"nee",{"$f":"+IF(P57=\"ja\",$N$20,100%)","v":1},{"$f":"Q57*O57*N57*M57*C53","v":0},null,null,{"$f":"C53*M57*N57*Q57","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Planeconomie",2.5000000000000001E-2,{"$f":"+N57","v":0},{"$f":"+S17","v":151},"nee",{"$f":"+IF(P58=\"ja\",$N$20,100%)","v":1},{"$f":"Q58*O58*N58*M58*C53","v":0},null,null,{"$f":"C53*M58*N58*Q58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+N58","v":0},{"$f":"+S15","v":119},"nee",{"$f":"+IF(P59=\"ja\",$N$20,100%)","v":1},{"$f":"Q59*O59*N59*M59*C53","v":0},null,null,{"$f":"C53*M59*N59*Q59","v":0}]
[]
[]
[null,null,null,null,null,null,2,"Werkzaamheden ten behoeve van het uitvoeren van het omgevingsplan",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S64:S123)","v":0},null,null,{"$f":"SUM(V64:V123)","v":0}]
[]
[null,{"$f":"+IF(Vragenlijst!Q67>0,TRUE,FALSE)","v":false},{"$f":"+IF(D64=TRUE,1,0)","v":0},false,null,null,"2.1","Taxatie inbrengwaarde percelen","Via  onafhankelijke taxatie",null,null,null,null,null,null,null,null,null,{"$f":"IF((R65+R66)<(4*S14),((4*S14)+R67+R68+R69)*M67,SUM(R65:R69))","v":0},null,null,{"$f":"IF((U65+U66)<4,(4+U67+U69+U68)*M67,SUM(U65:U69))","v":0}]
[null,null,{"$f":"+M65+M66","v":0},null,null,null,null,null,"uur per onbebouwd perceel",null,null,"Taxateur",{"$f":"+Vragenlijst!J68","v":0},1,{"$f":"+S14","v":151},"nee",{"$f":"+IF(P65=\"ja\",$N$20,100%)","v":1},{"$f":"Q65*O65*N65*M65*C64","v":0},null,null,{"$f":"C$64*M65*N65*Q65","v":0}]
[null,null,null,null,null,null,null,null,"uur per bebouwd perceel",null,null,"Taxateur",{"$f":"+Vragenlijst!J69","v":0},2,{"$f":"+S14","v":151},"nee",{"$f":"+IF(P66=\"ja\",$N$20,100%)","v":1},{"$f":"Q66*O66*N66*M66*C64","v":0},null,null,{"$f":"C$64*M66*N66*Q66","v":0}]
[null,null,null,null,null,null,null,null,"ambtelijke begeleiding onderzoek",null,null,"Planeconomie",{"$f":"IF(C65>=1,1,0)","v":0},16,{"$f":"+S14","v":151},"nee",{"$f":"+IF(P67=\"ja\",$N$20,100%)","v":1},{"$f":"Q67*O67*N67*M67*C64","v":0},null,null,{"$f":"C$64*M67*N67*Q67","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.05,{"$f":"+N65*M65+N66*M66+N67*M67","v":0},{"$f":"+S18","v":171},"nee",{"$f":"+IF(P68=\"ja\",$N$20,100%)","v":1},{"$f":"Q68*O68*N68*M68*C64","v":0},null,null,{"$f":"C64*M68*N68*Q68","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+N68","v":0},{"$f":"+S15","v":119},"nee",{"$f":"+IF(P69=\"ja\",$N$20,100%)","v":1},{"$f":"Q69*O69*N69*M69*C64","v":0},null,null,{"$f":"C64*M69*N69*Q69","v":0}]
[]
[null,null,null,null,null,null,null,null,"Via  Wet WOZ",null,null,null,null,null,null,null,null,null,{"$f":"SUM(R72:R75)","v":0},null,null,{"$f":"SUM(U72:U75)","v":0}]
[null,null,null,null,null,null,null,null,"uur per onbebouwd perceel",null,null,"Planeconomie/grondzaken",{"$f":"+Vragenlijst!H68","v":0},0.25,{"$f":"+S14","v":151},"nee",{"$f":"+IF(P72=\"ja\",$N$20,100%)","v":1},{"$f":"Q72*O72*N72*M72*C64","v":0},null,null,{"$f":"C$64*M72*N72*Q72","v":0}]
[null,null,null,null,null,null,null,null,"uur per bebouwd perceel",null,null,"Planeconomie/grondzaken",{"$f":"+Vragenlijst!H69","v":0},0.25,{"$f":"+S14","v":151},"nee",{"$f":"+IF(P73=\"ja\",$N$20,100%)","v":1},{"$f":"Q73*O73*N73*M73*C64","v":0},null,null,{"$f":"C$64*M73*N73*Q73","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.05,{"$f":"N72*M72+N73*M73","v":0},{"$f":"+S18","v":171},"nee",{"$f":"+IF(P74=\"ja\",$N$20,100%)","v":1},{"$f":"Q74*O74*N74*M74*C64","v":0},null,null,{"$f":"C$64*M74*N74*Q74","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+N74","v":0},{"$f":"+S15","v":119},"nee",{"$f":"+IF(P75=\"ja\",$N$20,100%)","v":1},{"$f":"Q75*O75*N75*M75*C64","v":0},null,null,{"$f":"C64*M75*N75*Q75","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+R77","v":0},null,null,{"$f":"+U77","v":0}]
[null,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":"+S64+S71","v":0},null,"nee",{"$f":"+IF(P77=\"ja\",$N$20,100%)","v":1},{"$f":"N77*M77*C64","v":0},null,null,{"$f":"(+V64+V71)*M77","v":0}]
[]
[null,{"$f":"+IF(Vragenlijst!Q71>0,TRUE,FALSE)","v":false},{"$f":"+IF(D79=TRUE,1,0)","v":0},false,null,null,"2.2","Taxatie en aankoop onroerende zaak",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R80:R89)","v":0},null,null,{"$f":"SUM(U80:U89)","v":0}]
[null,null,null,null,null,null,null,null,"uur per onbebouwde perceel",null,null,"Grondzaken",{"$f":"+Vragenlijst!H72","v":0},24,{"$f":"+S14","v":151},"nee",{"$f":"+IF(P80=\"ja\",$N$20,100%)","v":1},{"$f":"Q80*O80*N80*M80*C$79","v":0},null,null,{"$f":"C$79*M80*N80*Q80","v":0}]
[null,null,null,null,null,null,null,null,"uur per gebouw met een woonfunctie ",null,null,"Grondzaken",{"$f":"+Vragenlijst!H73","v":0},48,{"$f":"+S14","v":151},"nee",1,{"$f":"Q81*O81*N81*M81*C$79","v":0},null,null,{"$f":"C$79*M81*N81*Q81","v":0}]
[null,null,null,null,null,null,null,null,"uur per gebouw met een industriefunctie, winkelfunctie of kantoorfunctie",null,null,"Grondzaken",{"$f":"IF(Vragenlijst!Q31=TRUE,0,Vragenlijst!H74)","v":0},80,{"$f":"+S14","v":151},"nee",1,0,null,null,0]
[null,null,null,null,null,null,null,null,"uur per gebouw met een industriefunctie, winkelfunctie of kantoorfunctie in herstructurering",null,null,"Grondzaken",{"$f":"IF(Vragenlijst!Q31=TRUE,Vragenlijst!H74,0)","v":0},100,{"$f":"+S14","v":151},"nee",1,0,null,null,0]
[null,null,null,null,null,null,null,null,"uur per byzonder object",null,null,"Grondzaken",{"$f":"IF(Vragenlijst!Q31=TRUE,0,Vragenlijst!H75)","v":0},80,{"$f":"+S14","v":151},"nee",1,0,null,null,0]
[null,null,null,null,null,null,null,null,"uur per byzonder object in herstructurering",null,null,"Grondzaken",{"$f":"IF(Vragenlijst!Q31=TRUE,Vragenlijst!H75,0)","v":0},100,{"$f":"S14","v":151},"nee",1,0,null,null,0]
[null,null,null,null,null,null,null,null,"uur per huur of pachtontbinding",null,null,"Grondzaken",{"$f":"+Vragenlijst!H77","v":0},48,{"$f":"S14","v":151},"nee",{"$f":"+IF(P86=\"ja\",$N$20,100%)","v":1},{"$f":"Q86*O86*N86*M86*C$79","v":0},null,null,{"$f":"C$79*M86*N86*Q86","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+N82*M82+N83*M83+N80*M80+N81*M81+N84*M84+N85*M85+M86*N86","v":0},{"$f":"+S18","v":171},"nee",1,{"$f":"Q87*O87*N87*M87*C79","v":0},null,null,{"$f":"C79*M87*N87*Q87","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.05,{"$f":"+N87","v":0},{"$f":"+S17","v":151},"nee",1,{"$f":"Q88*O88*N88*M88*C79","v":0},null,null,{"$f":"C79*M88*N88*Q88","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+N88","v":0},{"$f":"+S15","v":119},"nee",1,{"$f":"Q89*O89*N89*M89*C79","v":0},null,null,{"$f":"C79*M89*N89*Q89","v":0}]
[]
[null,{"$f":"IF(Vragenlijst!Q80>0,TRUE,FALSE)","v":false},{"$f":"+IF(D91=TRUE,1,0)","v":0},false,null,null,"2.3","Onteigenen van onroerende zaken",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R92:R97)","v":0},null,null,{"$f":"SUM(U92:U97)","v":0}]
[null,null,null,null,null,null,null,null,"uur per procedure van de voorbereiding van een onteigeningsbeschikking",null,null,"Grondzaken",{"$f":"+Vragenlijst!H80","v":0},134,{"$f":"S14","v":151},"nee",{"$f":"+IF(P92=\"ja\",$N$20,100%)","v":1},{"$f":"Q92*O92*N92*M92*C$91","v":0},null,null,{"$f":"C$91*M92*N92*Q92","v":0}]
[null,null,null,null,null,null,null,null,"uur per bekrachtigingsprocedure onteigeningsbeschikking",null,null,"Grondzaken",{"$f":"+Vragenlijst!H81","v":0},50,{"$f":"S14","v":151},"nee",{"$f":"+IF(P93=\"ja\",$N$20,100%)","v":1},{"$f":"Q93*O93*N93*M93*C$91","v":0},null,null,{"$f":"C$91*M93*N93*Q93","v":0}]
[null,null,null,null,null,null,null,null,"vast bedrag advocaatkosten per onteigeningsbeschikking",null,null,"Advocatuur",{"$f":"+M93","v":0},38532,null,"nee",{"$f":"+IF(P94=\"ja\",$N$20,100%)","v":1},{"$f":"Q94*N94*M94*C$91","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+M92*N92+N93*M93","v":0},{"$f":"+S18","v":171},"nee",{"$f":"+IF(P95=\"ja\",$N$20,100%)","v":1},{"$f":"Q95*O95*N95*M95*C91","v":0},null,null,{"$f":"C91*M95*N95*Q95","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.05,{"$f":"+N95","v":0},{"$f":"+S17","v":151},"nee",{"$f":"+IF(P96=\"ja\",$N$20,100%)","v":1},{"$f":"Q96*O96*N96*M96*C91","v":0},null,null,{"$f":"C91*M96*N96*Q96","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+N96","v":0},{"$f":"+S15","v":119},"nee",{"$f":"+IF(P97=\"ja\",$N$20,100%)","v":1},{"$f":"Q97*O97*N97*M97*C91","v":0},null,null,{"$f":"C91*M97*N97*Q97","v":0}]
[]
[null,{"$f":"+Vragenlijst!Q84","v":false},{"$f":"+IF(D99=TRUE,1,0)","v":0},false,null,null,"2.4","Vestigen voorkeursrecht",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R100:R103)","v":0},null,null,{"$f":"SUM(U100:U103)","v":0}]
[null,null,null,null,null,null,null,null,"uur voor vestiging voorkeursrecht",null,null,"Grondzaken",{"$f":"+Vragenlijst!S84","v":0},60,{"$f":"+S14","v":151},"nee",{"$f":"+IF(P100=\"ja\",$N$20,100%)","v":1},{"$f":"Q100*O100*N100*M100*C$99","v":0},null,null,{"$f":"C$99*M100*N100*Q100","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.1,{"$f":"+M100*N100","v":0},{"$f":"+S18","v":171},"nee",{"$f":"+IF(P101=\"ja\",$N$20,100%)","v":1},{"$f":"Q101*O101*N101*M101*C99","v":0},null,null,{"$f":"C99*M101*N101*Q101","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Planeconomie",0.05,{"$f":"+N101","v":0},{"$f":"+S17","v":151},"nee",{"$f":"+IF(P102=\"ja\",$N$20,100%)","v":1},{"$f":"Q102*O102*N102*M102*C99","v":0},null,null,{"$f":"C99*M102*N102*Q102","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+N102","v":0},{"$f":"+S15","v":119},"nee",{"$f":"+IF(P103=\"ja\",$N$20,100%)","v":1},{"$f":"Q103*O103*N103*M103*C99","v":0},null,null,{"$f":"C99*M103*N103*Q103","v":0}]
[]
[null,{"$f":"+Vragenlijst!Q92","v":false},{"$f":"+IF(D105=TRUE,1,0)","v":0},false,null,null,"2.5","Inrichtingsplan Openbare ruimte (openbare voorzieningen die de gemeente aanlegt)",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R106:R111)","v":0},null,null,{"$f":"SUM(U106:U111)","v":0}]
[null,null,null,null,null,null,null,null,"uur per 100 m2 verharding",null,null,"Stedenbouw,civiel",{"$f":"+Vragenlijst!H89/100","v":0},1.5,{"$f":"+S20","v":151},"nee",{"$f":"+IF(P106=\"ja\",$N$20,100%)","v":1},{"$f":"Q106*O106*N106*M106*C105","v":0},null,null,{"$f":"C$105*M106*N106*Q106","v":0}]
[null,null,null,null,null,null,null,null,"uur per 100 m2 groen/water",null,null,"Stedenbouw,civiel",{"$f":"+(Vragenlijst!H88-Vragenlijst!H89)/100","v":0},1,{"$f":"+S20","v":151},"nee",{"$f":"+IF(P107=\"ja\",$N$20,100%)","v":1},{"$f":"Q107*O107*N107*M107*C105","v":0},null,null,{"$f":"C$105*M107*N107*Q107","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Projectmanagement",0.05,{"$f":"+N106*M106+N107*M107","v":0},{"$f":"+S18","v":171},"nee",{"$f":"+IF(P108=\"ja\",$N$20,100%)","v":1},{"$f":"Q108*O108*N108*M108*C105","v":0},null,null,{"$f":"C105*M108*N108*Q108","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Planeconomie",2.5000000000000001E-2,{"$f":"+N108","v":0},{"$f":"+S17","v":151},"nee",{"$f":"+IF(P109=\"ja\",$N$20,100%)","v":1},{"$f":"Q109*O109*N109*M109*C105","v":0},null,null,{"$f":"C105*M109*N109*Q109","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Communicatie",0.05,{"$f":"+N108","v":0},{"$f":"+S12","v":132},"nee",{"$f":"+IF(P110=\"ja\",$N$20,100%)","v":1},{"$f":"Q110*O110*N110*M110*C105","v":0},null,null,{"$f":"C105*M110*N110*Q110","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Landmeten/vastgoedinformatie",0.01,{"$f":"+N110","v":0},{"$f":"+S15","v":119},"nee",{"$f":"+IF(P111=\"ja\",$N$20,100%)","v":1},{"$f":"Q111*O111*N111*M111*C105","v":0},null,null,{"$f":"C105*M111*N111*Q111","v":0}]
[]
[null,{"$f":"IF((Vragenlijst!T103+Vragenlijst!S132+Vragenlijst!S142)>0,TRUE,FALSE)","v":false},{"$f":"+IF(D113=TRUE,1,0)","v":0},false,null,null,"2.6","Voorbereiding, toezicht en directievoering  (openbare voorzieningen die de gemeente aanlegt)",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R114:R116)","v":0},null,null,{"$f":"SUM(U114:U116)","v":0}]
[null,null,null,null,null,null,null,"a","slopen",null,null,"Ingenieursbureau",1,{"$f":"+Hulpblad!G48","v":0},1,"ja",{"$f":"+N20","v":1},{"$f":"Q114*O114*N114*M114*C$113","v":0},null,null,{"$f":"+Hulpblad!I48*C113*Q114","v":0}]
[null,null,null,null,null,null,null,"b","ophogen/voorbelasten",null,null,"Ingenieursbureau",{"$f":"+Vragenlijst!S132","v":0},{"$f":"+Hulpblad!G158","v":0},1,"nee",{"$f":"+IF(P115=\"ja\",$N$20,100%)","v":1},{"$f":"Q115*O115*N115*M115*C$113","v":0}]
[null,null,null,null,null,null,null,"c","bouw en woonrijpmaken",null,null,"Ingenieursbureau",1,{"$f":"+Hulpblad!G107","v":0},1,"ja",{"$f":"+N20","v":1},{"$f":"Q116*O116*N116*M116*C$113","v":0},null,null,{"$f":"+Hulpblad!I107*C113*Q116","v":0}]
[]
[null,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,{"$f":"SUM(R120:R122)","v":0},null,null,{"$f":"SUM(U120:U122)","v":0}]
[null,true,{"$f":"+IF(D119=TRUE,1,0)","v":0},false,null,null,null,"inclusief bestuurlijke besluitvorming"]
[null,null,null,null,null,null,null,null,"a. projectmanagement uur per jaar",null,null,"Projectmanagement",{"$f":"+Vragenlijst!J20","v":0},{"$f":"30","v":30},{"$f":"+S18","v":171},"ja",{"$f":"+IF(P120=\"ja\",$N$20,100%)","v":1},{"$f":"Q120*O120*N120*M120*C119","v":0},null,null,{"$f":"C$119*M120*N120*Q120","v":0}]
[null,null,null,null,null,null,null,null,"b. projectassistentie uur per jaar mits complexiteitsfactor > 130%",null,null,"Projectassistentie",{"$f":"+IF(N20>130%,Vragenlijst!J20,0)","v":0},100,{"$f":"+S19","v":119},"ja",{"$f":"+IF(P121=\"ja\",$N$20,100%)","v":1},{"$f":"Q121*O121*N121*M121*C119","v":0},null,null,{"$f":"C$119*M121*N121*Q121","v":0}]
[null,null,null,null,null,null,null,null,"c. financieel management uur per jaar",null,null,"Planeconomie",{"$f":"+Vragenlijst!J20","v":0},{"$f":"64","v":64},{"$f":"+S17","v":151},"ja",{"$f":"+IF(P122=\"ja\",$N$20,100%)","v":1},{"$f":"Q122*O122*N122*M122*C119","v":0},null,null,{"$f":"C$119*M122*N122*Q122","v":0}]

{"sheet":"Resultaat","index":4,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,{"$f":"+Vragenlijst!C7","v":"Plankostenregels bij kostenverhaal ZONDER 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,"Scenario",{"$f":"+Vragenlijst!F14","v":"…."}]
[]
[null,null,null,"Complexiteit van het project",{"$f":"+Produktenlijst!N20","v":1}]
[null,null,null,"looptijd in jaren: ",{"$f":"+Vragenlijst!J20","v":0}]
[null,null,null,null,"uren","euro's"]
[null,null,null,{"$f":"+Produktenlijst!H25","v":"Omgevingsplan"},{"$f":"SUM(E16:E19)","v":0},{"$f":"SUM(F16:F19)","v":0}]
[null,null,{"$f":"+Produktenlijst!G27","v":"1.1"},{"$f":"+Produktenlijst!H27","v":"Opstellen van een scenario tbv vaststellen kostenplafond"},{"$f":"+Produktenlijst!V27","v":0},{"$f":"+Produktenlijst!S27","v":0}]
[null,null,{"$f":"+Produktenlijst!G31","v":"1.2"},{"$f":"+Produktenlijst!H31","v":"Opstellen en vaststellen omgevingsplan"},{"$f":"+Produktenlijst!V31+Produktenlijst!V38","v":0},{"$f":"+Produktenlijst!S31+Produktenlijst!S38","v":0},null,true]
[null,null,{"$f":"+Produktenlijst!G42","v":"1.3"},{"$f":"+Produktenlijst!H42","v":"Stedenbouwkundig plan"},{"$f":"+Produktenlijst!V42","v":0},{"$f":"+Produktenlijst!S42","v":0}]
[null,null,{"$f":"+Produktenlijst!G53","v":"1.4"},{"$f":"+Produktenlijst!H53","v":"Beeldkwaliteitsplan"},{"$f":"+Produktenlijst!V53","v":0},{"$f":"+Produktenlijst!S53","v":0},null,true]
[null,null,null,null,null,null,null,true]
[null,null,null,{"$f":"+Produktenlijst!H62","v":"Werkzaamheden ten behoeve van het uitvoeren van het omgevingsplan"},{"$f":"SUM(E22:E28)","v":0},{"$f":"SUM(F22:F28)","v":0}]
[null,null,{"$f":"+Produktenlijst!G64","v":"2.1"},{"$f":"+Produktenlijst!H64","v":"Taxatie inbrengwaarde percelen"},{"$f":"+Produktenlijst!V64+Produktenlijst!V71+Produktenlijst!V76","v":0},{"$f":"+Produktenlijst!S64+Produktenlijst!S71+Produktenlijst!S76","v":0}]
[null,null,{"$f":"+Produktenlijst!G79","v":"2.2"},{"$f":"+Produktenlijst!H79","v":"Taxatie en aankoop onroerende zaak"},{"$f":"+Produktenlijst!V79","v":0},{"$f":"+Produktenlijst!S79","v":0}]
[null,null,{"$f":"+Produktenlijst!G91","v":"2.3"},{"$f":"+Produktenlijst!H91","v":"Onteigenen van onroerende zaken"},{"$f":"+Produktenlijst!V91","v":0},{"$f":"+Produktenlijst!S91","v":0}]
[null,null,{"$f":"+Produktenlijst!G99","v":"2.4"},{"$f":"+Produktenlijst!H99","v":"Vestigen voorkeursrecht"},{"$f":"+Produktenlijst!V99","v":0},{"$f":"+Produktenlijst!S99","v":0},null,true]
[null,null,{"$f":"+Produktenlijst!G105","v":"2.5"},{"$f":"+Produktenlijst!H105","v":"Inrichtingsplan Openbare ruimte (openbare voorzieningen die de gemeente aanlegt)"},{"$f":"+Produktenlijst!V105","v":0},{"$f":"+Produktenlijst!S105","v":0},null,false]
[null,null,{"$f":"+Produktenlijst!G113","v":"2.6"},{"$f":"+Produktenlijst!H113","v":"Voorbereiding, toezicht en directievoering  (openbare voorzieningen die de gemeente aanlegt)"},{"$f":"+Produktenlijst!V113","v":0},{"$f":"+Produktenlijst!S113","v":0}]
[null,null,{"$f":"+Produktenlijst!G118","v":"2.7"},{"$f":"+Produktenlijst!H118","v":"Algemene en financiele verantwoording en aansturing  van het project"},{"$f":"+Produktenlijst!V118","v":0},{"$f":"+Produktenlijst!S118","v":0},null,false]
[]
[null,null,null,"Totaal kostenverhaal",{"$f":"+E21+E15","v":0},{"$f":"+F21+F15","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,false]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E50:E51)","v":0}]

{"sheet":"Hulpblad","index":5,"n_rows":199,"n_cols":17,"rows_kept":199,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"+Vragenlijst!C7","v":"Plankostenregels bij kostenverhaal ZONDER 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!Q103=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"+IF(F8=\"nee\",0,1)","v":0}]
[null,null,"Aantal m3",null,null,{"$f":"+Vragenlijst!H105","v":0},"m3"]
[null,null,"Verrekenfactor",null,null,{"$f":"1+Vragenlijst!X108","v":1},"gemiddeld type te slopen onroerende zaak"]
[null,null,"Aantal bestekken vlg vragenlijst",null,null,{"$f":"+Vragenlijst!H114","v":0},"stuks "]
[null,null,"Verrekenfactor",null,null,{"$f":"1+Vragenlijst!X122","v":1},"wijze van aanbesteding"]
[null,null,"Verrekenfactor",null,null,{"$f":"IF(Vragenlijst!Q118=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"IF(F13=\"ja\",(1+Vragenlijst!H120/100),0)","v":0},"aanwezigheid asbest"]
[]
[null,null,"Tarief CT projectleider",null,null,{"$f":"+Produktenlijst!S13","v":151},"per uur"]
[null,null,"Tarief bestekschrijver/calculator",null,null,{"$f":"+Produktenlijst!V11","v":119},"per uur"]
[null,null,"Tarief directievoerder",null,null,{"$f":"+Produktenlijst!V14","v":132},"per uur"]
[null,null,"Tarief toezichthouder",null,null,{"$f":"+Produktenlijst!V15","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,"Directievoeren en toezichthouden"]
[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":0},"aanwezigheid asbest"]
[null,null,"Directievoering",null,null,{"$f":"1","v":1},"uur per week gedurende uitvoeringstijd"]
[null,null,"Toezichthouden",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 de 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":0},"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","v":0},null,{"$f":"+F23*F11*F24","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))","v":0},null,{"$f":"+(((F28)/40*(F29)*(F30)*F31*F32)+((F28)/40*(F29)*(F30)*F31*F33))","v":0}]
[null,null,"Projectleiding",null,null,null,{"$f":"+(F36*F11*F15*(F37)+(F38*(F28)/40*F15*F39*F40))","v":0},null,{"$f":"+(F36*F11*(F37)+(F38*(F28)/40*F39*F40))","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!Q142=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,"Ha openbaar gebied",null,null,{"$f":"+Vragenlijst!H88/10000","v":0},"ha"]
[null,null,"Aantal kostenverhaalsdeelgebieden openbaar gebied volgens de norm",null,null,{"$f":"+(F57/2)","v":0},"(2 ha per deelgebied openbaar gebied)",null,null,null,null,null,"verhouding openbaar/uitgeefbaar tov norm",{"$f":"+Vragenlijst!Q88","v":1}]
[null,null,"Aantal kostenverhaalsdeelgebieden openbaar gebied cf verhouding grondgebruik",null,null,{"$f":"+F58*N71","v":0},null,null,null,null,null,null,"hulptabel te berekenen aantal deelgebieden"]
[null,null,"Type locatie",null,null,{"$f":"CONCATENATE(Vragenlijst!Q30,Vragenlijst!R30,Vragenlijst!S30,Vragenlijst!T30,Vragenlijst!U30)","v":""},null,null,null,null,null,null,"% t.o.v. norm","verrekeningsfactor"]
[null,null,"Aantal bestekken dat bij het type locatie hoort",null,null,{"$f":"IF(F60=\"uitleglocatie\",2*F59,IF(F60=\"uitbreidingslocatie\",2*F59,1.5*F59))","v":0},null,null,null,null,null,null,1,1]
[]
[null,null,"Verrekenfactor",null,null,{"$f":"1+Vragenlijst!Y145","v":1},"wijze van aanbesteden",null,null,null,null,null,1.1200000000000001,1.05]
[null,null,"Is sprake van bodemsanering ?",null,null,{"$f":"+IF(Vragenlijst!Q154=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"+Vragenlijst!S156/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!S13","v":151},"per uur",null,null,null,null,null,1.5,1.2]
[null,null,"Tarief CT ontwerper",null,null,{"$f":"+Produktenlijst!V12","v":151},"per uur",null,null,null,null,null,1.5,1.2]
[null,null,"Tarief bestekschrijver/calculator",null,null,{"$f":"+Produktenlijst!V11","v":119},"per uur"]
[null,null,"Tarief CT tekenaar",null,null,{"$f":"+Produktenlijst!V13","v":107},"per uur"]
[null,null,"Tarief directievoerder",null,null,{"$f":"+Produktenlijst!V14","v":132},"per uur"]
[null,null,"Tarief toezichthouder",null,null,{"$f":"+Produktenlijst!V15","v":107},"per uur",null,null,null,null,null,"te hanteren verreken % t.o.v. norm deelgebieden:",{"$f":"IF(N58<$M$61,$N$61,IF(N58<$M$63,$N61+((N58-$M$61)/($M$63-$M$61))*($N$63-$N$61),\nIF(N58<$M$64,$N$63+((N58-$M$63)/($M$64-$M$63))*($N$64-$N$63),\nIF(N58<$M$65,$N$64+((N58-$M$64)/($M$65-$M$64))*($N$65-$N$64),\nIF(N58<$M$66,$N$65+((N58-$M$65)/($M$66-$M$65))*($N$66-$N$65),\nIF(N58<$M$67,$N$66+((N58-$M$66)/($M$67-$M$66))*($N$67-$N$66),$N$67))))))","v":1}]
[]
[null,"Uitgangspunten BOUW EN WOONRIJPMAKEN"]
[]
[null,"Ontwerp VO en DO:"]
[null,null,"Aantal kostenverhaalsdeelgebieden",null,null,{"$f":"+F59","v":0},"deelgebieden"]
[null,null,"Uren CT ontwerper",null,null,160,"per ontwerp VO en DO  per kostenverhaalsdeelgebied "]
[null,null,"Rioleringsplan",null,null,7.5,"uur per ha"]
[]
[null,"Aanbesteding en gunning"]
[null,null,"Aantal bestekken",null,null,{"$f":"+F61","v":0},"brm en wrm"]
[null,null,"Verrekenfactor",null,null,{"$f":"+F63","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 (2 bestekken)",null,null,12,"maanden  "]
[null,null,"Extra uitvoeringstijd BRM ivm bodemsanering",null,null,{"$f":"+IF(F64=\"ja\",2*G64,0)","v":0},"maanden "]
[null,null,"Totaal uitvoeringstijd bestekken",null,null,{"$f":"+(F87+F88)*F61/2","v":0},"maanden"]
[null,null,"Verrekenfactor",null,null,{"$f":"+F63","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":"+F63","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":"(+F76*F77*F67+F78*F56*F67)*G55","v":0},null,{"$f":"(+F76*F77+F78*F56)*G55","v":0}]
[null,null,"Aanbesteding en gunning",null,null,null,{"$f":"+F81*F83*F68*(F82)+F81*F84*F69*(F82)","v":0},null,{"$f":"+F81*F83*(F82)+F81*F84*(F82)","v":0}]
[null,null,"Directievoering en toezicht",null,null,null,{"$f":"+F89*4*F91*F70*F90+F89*4*F92*F71*F90","v":0},null,{"$f":"+F89*4*F91*F90+F89*4*F92*F90","v":0}]
[null,null,"Projectleiding",null,null,null,{"$f":"+F95*F59*F66+F96*F61*F66*(F97)+F98*F89*4*F66","v":0},null,{"$f":"+F95*F58+F96*F61*(F97)+F98*F89*4","v":0}]
[]
[null,"Totaal plankosten BOUW EN WOONRIJPMAKEN",null,null,null,null,{"$f":"SUM(G102:G105)*G55","v":0},null,{"$f":"SUM(I102:I105)*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!Q132=TRUE,\"ja\",\"nee\")","v":"nee"},{"$f":"+IF(F117=\"nee\",0,1)","v":0}]
[null,null,"Omvang verharding",null,null,{"$f":"+Vragenlijst!H89/10000","v":0},"ha"]
[null,null,"Hoogte ophogen",null,null,{"$f":"+Vragenlijst!H137","v":0},"m1"]
[null,null,"Aantal fases/deelplannen",null,null,{"$f":"+Vragenlijst!H135","v":0},"stuks"]
[null,null,"Zettingstijd",null,null,{"$f":"+Vragenlijst!H136","v":0},"jaar"]
[null,null,"Tarief directievoerder",null,null,{"$f":"+Produktenlijst!V14","v":132},"per uur"]
[null,null,"Tarief toezichthouder",null,null,{"$f":"+Produktenlijst!V15","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","v":12844},{"$f":"L133","v":12844},{"$f":"CEILING(M133/I133,25)","v":1300},{"$f":"basisbedrag_rapportage","v":6422},{"$f":"basisbedrag_rapportage","v":6422},{"$f":"CEILING(P133/I133,25)","v":650}]
[null,null,null,null,null,null,{"$f":"I133","v":10},{"$f":"H133","v":"ha"},15,{"$f":"J133","v":"ha"},0.9,{"$f":"M133","v":12844},{"$f":"I134*K134*$N$133","v":17550},{"$f":"CEILING(M134/I134,25)","v":1175},{"$f":"P133","v":6422},{"$f":"I134*K134*$Q$133","v":8775},{"$f":"CEILING(P134/I134,25)","v":600}]
[null,null,null,null,null,null,{"$f":"I134","v":15},{"$f":"H134","v":"ha"},50,{"$f":"J134","v":"ha"},0.75,{"$f":"M134","v":17550},{"$f":"I135*K135*$N$133","v":48750},975,{"$f":"P134","v":8775},{"$f":"I135*K135*$Q$133","v":24375},500]
[null,null,null,null,null,null,{"$f":"I135","v":50},{"$f":"H135","v":"ha"},100,"ha",0.5,{"$f":"M135","v":48750},{"$f":"I136*K136*$N$133","v":65000},650,{"$f":"P135","v":24375},{"$f":"I136*K136*$Q$133","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$119)/$F$147/5*($F$122*4)","v":0},"1/2 dag per week, gedurende aanbrengtijd, is dus afhankelijk van hoogte en groote werk"]
[null,null,"Toezichthouden",null,null,{"$f":"(10*10000*$F$119)/$F$147/5*($F$123*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(F127:F142)","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,"Plankosten ophogen"]
[null,null,"Bestek",null,null,null,{"$f":"IF(grootte_fase<=$I$133,$M$133,IF(AND(grootte_fase>$G$134,grootte_fase<=$I$134),IF($N$134*grootte_fase<$L$134,$L$134,$N$134*grootte_fase),IF(AND(grootte_fase>$G$135,grootte_fase<=$I$135),IF($N$135*grootte_fase<$L$135,$L$135,$N$135*grootte_fase),IF(grootte_fase>G136,IF(IF($N$136*grootte_fase<$L$136,$L$136,$N$136*grootte_fase)>$M$136,$M$136,IF($N$136*grootte_fase<$L$136,$L$136,$N$136*grootte_fase)),0))))*aantal_fases","v":0}]
[null,null,"Rapportage",null,null,null,{"$f":"IF(grootte_fase<=$I$133,$P$133,IF(AND(grootte_fase>$G$134,grootte_fase<=$I$134),IF($Q$134*grootte_fase<$O$134,$O$134,$Q$134*grootte_fase),IF(AND(grootte_fase>$G$135,grootte_fase<=$I$135),IF($Q$135*grootte_fase<$O$135,$O$135,$Q$135*grootte_fase),IF(grootte_fase>G136,IF(IF($Q$136*grootte_fase<$O$136,$O$136,$Q$136*grootte_fase)>$P$136,$P$136,IF($Q$136*grootte_fase<$O$136,$O$136,$Q$136*grootte_fase)),0))))*aantal_fases","v":0}]
[null,null,"Veldonderzoeken",null,null,null,{"$f":"IF(+basisbedrag_veldonderzoeken*plangebied<5137,5137,plangebied*basisbedrag_veldonderzoeken)","v":5137}]
[null,null,"Monitoring",null,null,null,{"$f":"IF(+basisbedrag_monitoring*zettingstijd*plangebied<3211,3211,plangebied*zettingstijd*basisbedrag_monitoring)","v":3211}]
[null,null,"Inmeting",null,null,null,{"$f":"IF(+basisbedrag_inmeting*plangebied<1285,1285,basisbedrag_inmeting*plangebied)","v":1285}]
[null,null,"Directievoering",null,null,null,{"$f":"(((+plangebied*ophooghoogte*10000/levering_per_as_per_dag)/5)*tarief_civiel*uren_per_week_directievoering)","v":0}]
[null,null,"Toezichthouder",null,null,null,{"$f":"(((plangebied*+ophooghoogte*10000/levering_per_as_per_dag/5)*F123*uren_per_week_toezichthouden))","v":0}]
[null,"Totaal plankosten ophogen tbv plankostenscan",null,null,null,null,{"$f":"SUM(G151:G157)*G117","v":0}]
[]
[]
[]
[null,"Hulptabel kosten Omgevingsplan"]
[]
[null,{"$f":"+Vragenlijst!J23","v":0},"ha kostenverhaalsgebied",null,null,{"$f":"+IF(Vragenlijst!Q56=TRUE,Vragenlijst!Q57,1)","v":1},"onderdeel van groter"]
[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 voor aanpassen omgevingsplanregels",null,null,null,"Omgevingsplan"]
[]
[null,60,"uur voor kostenverhaalgebied < 0,5 ha"]
[null,120,"uur voor kostenverhaalgebied tussen 0,5 ha en 1 ha"]
[null,200,"uur voor kostenverhaalgebied tussen 1 ha en 3 ha"]
[null,300,"uur voor kostenverhaalgebied tussen 3 ha en 5 ha"]
[null,350,"uur voor kostenverhaalgebied tussen 5 ha en 10 ha"]
[null,400,"uur voor kostenverhaalgebied tussen 10 ha en 15 ha"]
[null,450,"uur voor kostenverhaalgebied tussen 15 ha en 20 ha"]
[null,500,"uur voor kostenverhaalgebied tussen 20 ha en 50 ha"]
[null,550,"uur voor kostenverhaalgebied groter dan 50 ha"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"hulptabel opstellen scenario",null,null,null,null,null,"hulptabel opstellen kostenverhaalsregels"]
[null,"wel een stedenbouwkundig plan:"]
[null,{"$f":"+Vragenlijst!Q23","v":0},"ha kostenverhaalsgebied",null,null,null,null,{"$f":"+Vragenlijst!Q23","v":0},"ha kostenverhaalsgebied",null,{"$f":"+F164","v":1},{"$f":"+G164","v":"onderdeel van groter"}]
[null,{"$f":"IF(B187<5,B190,(IF(B187<=20,B191,B192)))","v":56},"uur voor opstellen scenario tbv het omgevingsplan",null,null,null,null,{"$f":"IF(H187<0.5,H190,(IF(H187<1,H191,IF(H187<3,H192,(IF(H187<5,H193,(IF(H187<10,H194,IF(H187<15,H195,IF(H187<20,H196,IF(H187<=50,H197,H198)))))))))))*K187","v":38},"uur voor opstellen kostenverhaalsregels",null,null,{"$f":"+G165","v":"Omgevingsplan"}]
[]
[null,56,"uur voor kostenverhaalgebied < 5 ha",null,null,null,null,38,"uur voor kostenverhaalgebied < 0,5 ha"]
[null,84,"uur voor kostenverhaalgebied tussen 5 ha en 20  ha",null,null,null,null,75,"uur voor kostenverhaalgebied tussen 0,5 ha en 1 ha"]
[null,100,"uur voor kostenverhaalgebied groter dan 20 ha",null,null,null,null,113,"uur voor kostenverhaalgebied tussen 1 ha en 3 ha"]
[null,null,null,null,null,null,null,150,"uur voor kostenverhaalgebied tussen 3 ha en 5 ha"]
[null,"geen stedenbouwkundig plan:",null,null,null,null,null,173,"uur voor kostenverhaalgebied tussen 5 ha en 10 ha"]
[null,{"$f":"IF(B187<5,B197,(IF(B187<=20,B198,B199)))","v":132},"uur voor opstellen scenario tbv het omgevingsplan",null,null,null,null,188,"uur voor kostenverhaalgebied tussen 10 ha en 15 ha"]
[null,null,null,null,null,null,null,300,"uur voor kostenverhaalgebied tussen 15 ha en 20 ha"]
[null,132,"uur voor kostenverhaalgebied < 5 ha",null,null,null,null,375,"uur voor kostenverhaalgebied tussen 20 ha en 50 ha"]
[null,160,"uur voor kostenverhaalgebied tussen 5 ha en 20  ha",null,null,null,null,450,"uur voor kostenverhaalgebied groter dan 50 ha"]
[null,192,"uur voor kostenverhaalgebied groter dan 20 ha"]