{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Stappenplan","import Alg. uitgangspunten KSDW","import DATA-CoP KSDW ","A Scope parameters","B Nw en Renovatie parameters","C  Begrotingsblad","D Presentatie+grafieken","E Rekenblad","Bijlage Begrippen SSK","F Redundantietoeslag"],"not_rendered":{"charts":6,"images":6,"macros":1,"external_links":1,"defined_names":3,"comments":7,"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":"Stappenplan","index":0,"n_rows":84,"n_cols":13,"rows_kept":84,"cut":false,"hidden":false,"merged":[[5,0,5,2],[21,0,21,2],[44,0,44,2],[50,0,50,2],[60,0,60,2],[51,0,51,2],[55,0,55,2]]}
["Kostenmodel",null,"KSDW raming budget en renovaties"]
["Versiedatum",null,"7-11-2025"]
["Vragen over beheer",null,"Marcel Bakker / Babette Schep / Reinier Frölke"]
[]
["Start","#","Importeren data uit KSDW"]
["Met deze tool kunnen ramingen uit de kostenstandaard drinkwater (KSDW) worden \"doorvertaald\" naar daadwerkelijke investeringen, waar ook rekening wordt gehouden met de verhouding nieuwbouw en renovatie. De basis van deze berekening is de input vanuit de kostenstandaard webtool . Stap 1 omvat het importeren van de juiste gegevens uit de KSDW export naar het voorliggende excelbestand. We gebruiken de uitgangspunten uit tabblad Algemene uitgangspunten en de grove ramingsdata uit tabblad Data CoP KSDW.\n\nVoor het gebruik van deze raming budget en renovatietool is het van belang dat in het project in de KSDW:\n- De processen voor 100% capaciteit ingevoerd worden, ookal wordt een deel van de capaciteit gerenoveerd of met rust gelaten. Dit kan later in dit Excel sjabloon  worden verwerkt.\n- Een eventuele redundantiefactor voor het strikt scheiden van straten buiten de KSDW wordt gehouden. Het effect hiervan op de kosten kan later in dit Excel sjabloon toegevoegd worden.\n\nOp tabblad Bijlage Begrippen SSK wordt door middel van een voorbeeld uitleg gegeven over de verschillende termen binnen de SSK systematiek, deze worden ook gebruikt in deze budget- en renovatietool."]
[]
["1) Algemene uitgangspunten","1.1","Exporteer het alternatief (als Excel) vanaf de kostenstandaard webtool (www.kostenstandaard.nl), zie figuur rechts"]
[null,"1.2","Selecteer in deze Excel export uit de kostenstandaard webtool het tabblad \"Algemene uitgangspunten\""]
[null,"1.3","Ga op cel A1 staan en typ \"Ctrl+a\" en vervolgens \"Ctrl+c\" om alle gegevens te selecteren en te kopieren."]
[null,"1.4","Vervolgens kies Excel \"KSDW-Raming Budget en renovaties\" en open het tabblad \"import Alg. uitgangspunten KSDW\"  "]
[null,"1.5","Ga op cel A1 staan en typ \"Ctrl+v\". De uitgangspunten zijn nu geimporteerd en worden gebruikt in de rest van de stappen"]
[]
["2) Data CoP KDSW","2.1","Selecteer in de Excel export uit de kostenstandaard webtool het tabblad \"DATA-CoP KSDW\""]
[null,"2.2","Ga op cel A1 staan en typ \"Ctrl+a\" en  \"Ctrl+c\""]
[null,"2.3","Vervolgens kies Excel \"KSDW-Raming Budget en renovaties\" en open hier het tabblad \"import DATA-CoP KSDW\"  "]
[null,"2.4","Ga op cel A1 staan en typ \"Ctrl+v\""]
[]
[]
[]
["A",null,"Tabblad A Scope parameters"]
["Om de ramingen uit de KSDW te vertalen naar daadwerkelijke investeringen (of investeringsbudgetten) moeten meer aspecten worden meegenomen. Dit tabblad geeft de mogelijkheid om verschillende onderdelen toe te voegen aan de raming uit de kostenstandaard, waaronder sloopkosten, indirecte bouwkosten, projectkosten, toeslagen, etc. Hiervoor zijn defaultwaarden opgenomen, deze kunnen naar eigen inzicht en situatie worden aangepast."]
[null,null,"Er zijn vijf categorieen die kunnen worden ingevuld: 1) bouwkosten, 2) vastgoedkosten, 3) projectkosten, 4) bijkomende kosten en 5) scope toeslagen"]
[null,null,"De lichtgeel gemarkeerde cellen kunnen worden ingevuld. "]
[null,null,"Als de cel niet overeenkomt met de ingestelde waarde kleurt de cel oranje. "]
[]
["1) Bouwkosten","A.1","Vul in cel C2 de sloopkosten in (€)"]
[null,"A.2","Vul in cel C3 het percentage verwachte indirecte bouwkosten in specifiek voor de discipline CTB, gerekend over de directe bouwkosten."]
[null,"A.3","Vul in cel C4 het percentage verwachte indirecte bouwkosten in specifiek voor de discipline WTB, gerekend over de directe bouwkosten."]
[null,"A.4","Vul in cel C5 het percentage verwachte indirecte bouwkosten in specifiek voor de discipline E&I, gerekend over de directe bouwkosten."]
[null,"A.5","Vul in cel C6 het percentage verwachte indirecte bouwkosten in specifiek voor de discipline PA, gerekend over de directe bouwkosten."]
[]
[null," ","Vul waarden in voor de volgende posten. Let op: voorkom dubbelingen bij het invullen, waar sommige kostenposten mogelijk onder twee categorieën kunnen vallen."]
["2) Vastgoedkosten ","A.6","Vul in cel C8 een bedrag voor vastgoedkosten in."]
["3) Projectkosten","A.7","Vul in cel C11 een percentage in voor de algemene projectkosten, gerekend over de totale bouwkosten (1) + toeslagen (5)"]
[null,"A.8","Vul in cel C12 een percentage in voor interne uren, gerekend over de totale bouwkosten (1) + toeslagen (5)"]
["4) Overige bijkomende kosten ","A.9","Vul in cel C14 een percentage in voor overige bijkomende kosten, gerekend over de totale bouwkosten (1) + toeslagen (5)"]
[]
["5) Scope toeslagen",null,"Hier kunnen extra scope toeslagen die voor het project gelden ingevoerd worden in cel C21 - C28 per onderwerp."]
[null,"A.10","In E20 - G27 staan de verwachte bandbreedtes per toeslag"]
[null,"A.11","In H20 - M27 kunnen indien gewenst de default waardes per discipline worden aangepast. Voor een simpele werkwijze wordt aangeraden hier geen gebruik van te maken."]
[null,"A.12","Cel B27 bevat een reserve optie om handmatig een toeslag toe te voegen, nog genoemd nader te detailleren. Hier kan naar wens een aanvullende toeslag kunnen worden toegevoegd die invloed heeft op de kosten (positief of negatief)."]
[]
["B",null,"Tabblad Nieuwbouw (NW) en Renovatie parameters"]
["De ramingen uit de KSDW gaan uit van het bouwen van volledig nieuwe processtappen. In de praktijk kan het echter voorkomen dat slechts een deel nieuwbouw betreft, en het andere deel renovatie. Dit werkt uiteraard door in de uiteindelijke kosten. Het tabblad Renovatie parameters biedt de mogelijkheid om de verhouding nieuwbouw en renovatie mee te nemen in de raming. Dit kan met het eenvoudig aangeven van het niewbouw- en renovatie deel (B.1), en als gewenst diepgaander door percentages per discipline aan te passen (B.2 en B.3)."]
[null,null,"In kolom C staan de processtappen uit de kostenstandaard opgesomd."]
[]
["1) Aandeel nieuwbouw en renovatie ","B.1.","Bepaal per processtap welk % nieuwbouw betreft en welk % van de processtap die reeds aanwezig gerenoveerd dient te worden. Vul in kolom C (vanaf gele cel C14) per processtap het percentage van de installatie wat nieuw gebouwd dient te worden. \nVoorbeeld: In de huidige situatie zijn 5 snelfilters opgesteld. Om de gewenste capaciteit (zoals ingevuld in de KSDW) te behalen moeten voor de processtap Snelfiltratie 5 nieuwe snelfilters worden bijgebouwd en de 5 bestaande worden gerenoveerd. In dit geval moet het percentage nieuwbouw op 50% worden gezet."]
[null,null,"Vervolgens wordt in kolom L automatisch het percentage renovatie bepaald (= 100% - % nieuwbouw). Het percentage voor nieuwbouw en renovatie vormen worden vervolgens vermenigvuldigd met kostenverhogende default waarden (indien van toepassing). Deze komen tot uiting in de volgende tabbladen.\nVoorbeeld: In de huidige situatie zijn 10 snelfilters opgesteld. Om de gewenste capaciteit (zoals ingevuld in de KSDW) te behalen moeten voor de processtap Snelfiltratie 5 nieuwe snelfilters worden bijgebouwd en 5 van de 10 bestaande worden gerenoveerd. In dit geval moet het percentage nieuwbouw op 33% staan, en het percentage nieuwbouw (handmatig) op 33% worden gezet. Hierbij blijft voor 33% aan snelfilters waar niks mee gebeurd buiten de raming"]
[]
["Indien gewenst kan meer detail worden aangebracht in deze percentages, specifiek op discipline niveau. Wanneer de gewenste raming hoog-over van karakter is wordt deze stap afgeraden om onnodige complexiteit te vermijden. Als dit wel gewenst is kan het + symbool in rij 70 worden aangeklikt. Vervolgens verschijnen opties om aanvullende kosten per discipline toe te wijzen, zowel voor het deel nieuwbouw (B.2) en het deel renovatie (B.3). "]
["2) Aandeel nieuwbouw, werkzaamheden gespecificeerd per discipline "]
[{"$error":"#VALUE!"},null,"Indien nog niet geopend; klap de kolommen D tot I open door te klikken op het + symbool in kolom I."]
[null,null,"De eerder in kolom C ingevulde waarde wordt gebruikt voor het aandeel nieuwbouw voor alle disciplines. Deze waarde wordt aangenomen voor alle disciplines. De kolommen D t/m I bieden de mogelijkheid om per discipline het percentage aan te passen. Dit kan in het geval bepaalde werkzaamheden voor een processtap minder (of meer) kosten meebrengen in het geval van nieuwbouw.Ook kan een percentage voor vulmaterialen worden ingevuld. Voorbeeld: Door het aanpassen van de eerder opgegeven waarde kan rekening worden gehouden met een reeds aanwezig en beschikbaar gebouw waar een nieuw te bouwen processtap in wordt geplaatst. In dat geval kan het percentage voor C&B sterk worden verlaagd van 100% naar bijvoorbeeld 20% (kleine aanpassingen aan gebouw)."]
[null,"B.2","Standaard wordt de waarde uit kolom C overgenomen voor alle disciplines, deze kan handmatig worden overschreven worden indien gewenst. \nLet op: in deze cellen is geen automatische aanpassing ingebouwd naar andere cellen. "]
["3) Aandeel renovatie, werkzaamheden gespecificeerd per discipline "]
[{"$error":"#VALUE!"},null,"Indien nog niet geopend; klap de kolommen K tot P open door te klikken op het + symbool in kolom P."]
[null,null,"Automatisch staat hier het percentage voor renovatie (= 100% - % nieuwbouw). Als er bij geen enkele processtap sprake is van renovatie is het niet mogelijk (en nodig) om B.3 uit te voeren. Voorbeeld: Bij renovatie van een processtap kan gebruik worden gemaakt van nog aanwezige mechanische onderdelen. De kosten voor renovatie vallen daardoor lager uit dan wanneer deze onderdelen niet beschikbaar zouden zijn. In dat geval kan het percentage voor WTB worden verlaagd."]
[null,"B.3","Standaard wordt de waarde uit kolom L overgenomen voor alle disciplines, deze kan handmatig worden overschreven worden indien gewenst. "]
[]
["Indien gewenst kunnen de kostenverhogende factoren worden aangepast (ten opzichte van een defaultwaarde)."]
["3.1) Toeslagpercentage renovatie(default per discpl)",null,"Ten opzichte van nieuwbouwkosten zijn renovatiekosten hoger voor dezelfde items. Dit komt vanwege moeilijkere aanpassingen in/rondom bestaande bouwwerken ten opzichte van nieuwbouw (green field). Tabel 3.1 (AD1-AJ7) geeft aan met welk percentage renovatiekosten hoger worden gerekend dan nieuwbouwkosten. Deze percentages komen bovenop de kosten die voor nieuwbouw gelden."]
[null,"B.4","De tabel roont default toeslagpercentages. Indien gewenst kan in de gele cellen (rij 4) een ander percentage worden ingevuld. De roodgekleurde waarden in rij 5 tot 7 tonen aangeraden bandbreedtes. "]
[]
["3a) Toeslagpercentage renovatie\n(per processtap)",null,"De default waarden in regel 5 worden in de regels 13-23 als waarden overgenomen."]
[null,null,"In cel AD5-AI 9 staan de verwachte bandbreedtes voor de extra renovatiekosten per discipline",null,null,null,null,null,null,null,null,null,"Er staat een standaard waarde ingevuld. Deze mag overschreven worden indien gewenst"]
[null,"B.5","Wijzig de default waarden in cellen AD13-AI33 indien gewenst",null,null,null,null,null,null,null,null,null,"Wanneer de waarde overschreven is en je het weer terug wilt zetten kopieer je simpelweg een formule uit de regels eronder in dezelfde kolom"]
[]
[]
["C",null,"Tabblad C Begrotingsblad"]
[null,null,"Hier staat het overzicht van totaalkosten, opgesplitst in nieuwbouw en renovatie (inclusief evt toeslagen)."]
[]
["D",null,"Tabblad D Presentatie+grafieken"]
[null,null,"Hier zijn grafieken te vinden van:"]
[null,null,"Bouwkosten per processtap (inclusief indirecte bouwkosten, exclusief toeslagen)"]
[null,null,"Bouwkosten per discipline (inclusief indirecte bouwkosten, exclusief toeslagen)"]
[null,null,"Investeringskosten (totale kosten)"]
[null,null,"Toeslagen per onderwerp"]
[null,null,"Toeslagen per discipline"]
[null,null,"Projectkosten"]
[]
["E ",null,"Tabblad E Rekenblad"]
[null,null,"Hier is het overzicht gegeven van de verschillende kosten (nieuwbouw/renovatie/toeslag/algemene kosten etc.), berekend aan de hand van de eerder ingevulde gegevens."]
[null,null,"Dit tabblad is beveiligd zodat de input alleen kan worden aangepast op de daarvoor bestemde plekken. ","Nog beveiligen"]

{"sheet":"import Alg. uitgangspunten KSDW","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Algemene uitgangspunten"]
[]
["Auteur:"]
["Bedrijf:"]
["Datum:"]
[]
["Project naam:"]
["Alternatief:"]
[]
["Project kengetallen"]
["Berekening op basis van:"]
["Ontwerpdebiet productie:",null,"m³/uur"]
["Ontwerpdebiet distributie:",null,"m³/uur"]
["Inname:",null,"m³/uur"]
["Dag piekfactor:"]
["Uur piekfactor:"]
[]
["Land: "]

{"sheet":"import DATA-CoP KSDW ","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["PLAK HIER"]

{"sheet":"A Scope parameters","index":3,"n_rows":29,"n_cols":24,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[1,"Bouwkosten","Default waarde","Toelichting ","Minimum","Default","Maximum"]
[null,"Sloopkosten",0,"Vul de totale sloopkosten. Let op: boekhoudkundig zijn dit GEEN investeringskosten en worden apart gehouden. Voor de volledigheid worden deze kosten hier wel meegenomen.","-","-","-",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Origineel KSDW"]
[null,"Indirecte bouwkosten discipline Civiele techniek en Bouwkunde (CTB)",0.25,"Voor het meenemen van indirecte bouwkosten bij huidige marktsituatie. Dit komt bovenop de directe bouwkosten voor deze discipline uit de KSDW-raming.",0.15,0.25,0.45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",0.2]
[null,"Indirecte bouwkosten discipline Werktuigbouwkunde (WTB)",0.3,"Voor het meenemen van indirecte bouwkosten bij huidige marktsituatie. Dit komt bovenop de directe bouwkosten voor deze discipline uit de KSDW-raming.",0.2,0.3,0.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"w",0.25]
[null,"Indirecte bouwkosten discipline Elektro & Instrumentatie (E&I)",0.4,"Voor het meenemen van indirecte bouwkosten bij huidige marktsituatie. Dit komt bovenop de directe bouwkosten voor deze discipline uit de KSDW-raming.",0.25,0.4,0.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"e",0.35]
[null,"Indirecte bouwkosten discipline Procesautomatisering (PA)",0.4,"Voor het meenemen van indirecte bouwkosten bij huidige marktsituatie. Dit komt bovenop de directe bouwkosten voor deze discipline uit de KSDW-raming.",0.25,0.4,0.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pa",0.35]
[]
[2,"Vastgoedkosten (grondaankoop, zakelijk recht e.d.)",0,"Bedrag in €","-","-","-"]
[]
[3,"Engineeringskosten (OG+IB)","Default waarde","Toelichting ","Minimum","Default","Maximum"]
[null,"Kosten t.b.v. (voor)onderzoek, engineering/ontwerp, adviesdiensten, evt toezicht door IB en/of OG.",0.2,"percentage over bouwk+toeslagen",0.08,0.2,0.35]
[null,"Interne uren opdrachtgever (specificeren, toetsen, administratie, toezicht)",0.1,"percentage over bouwk+toeslagen",0.05,0.1,0.15]
[]
[4,"Overige bijkomende kosten (leges/verzekeringen/archeologie/NGO e.d.)",0.04,"percentage over bouwk+toeslagen",0,0.01,0.02]
[]
[]
[null,null,null,null,null,null,null,"Toeslagpercentage per discipline (%)"]
[5,"Scope toeslagen","Toeslag percentage %\n","Toelichting ","Minimum\n","Default \n","Maximum\n","CTB","WTB","E&I","PA"]
[null,"Onderwerpen","Default waarde",null,"%","%","%","%","%","%","%",null,"Verdere toelichting"]
[null,"Duurzame materialen / circulair bouwen",0.1,"Extra kosten door toepassing van duurzame materialen of technieken (duurzame materialen, circulariteit, natuurinclusief bouwen etc.). Dit is exclusief de extra kosten voor het gebruik van elektrisch materieel (zie volgende rij) .",0,0.1,0.25,{"$f":"$C20","v":0.1},0.1,0.1,0.1,null,"De geel gemarkeerde cellen mogen overschreven worden. \nWanneer de cel in kolommen H-K overschreven is dan kleurt het oranje. \nToeslagen worden berekend over de Totale Bouwkosten (BK) incl. toeslagen"]
[null,"Elektrisch werken (emissieloos bouwen)",0.06,"Meerkosten door inzet elektrische apparatuur en materieel in verband met emissieloos bouwen",0,0.06,0.15,{"$f":"$C21","v":0.06},0.06,0.06,0.06,null,"Wanneer je de automatische invulling weer terug wil zetten kopieer je een andere cel uit de kolom waar de formule of  verwijzing nog in staat. Automatisch zal de formule het voor die regel goed weergeven"]
[null,"Volledig onafhankelijke straten (keuzelijst)",{"$f":"IF('F Redundantietoeslag'!X9=1,'F Redundantietoeslag'!W5,IF('F Redundantietoeslag'!X9=2,'F Redundantietoeslag'!W6,IF('F Redundantietoeslag'!X9=3,'F Redundantietoeslag'!W7,'F Redundantietoeslag'!W8)))","v":0},"1 default onafh straat  = 0% toeslag\n2 volledig onafh straten = +20% toeslag\n3 volledig onafh straten = +39% toeslag\n4 volledig onafh straten = +52% toeslag",0,0,0.52,0,0,0,0]
[null,"Extra kosten standaardisatie",0.05,"Extra kosten t.g.v. standaardisatie eisen",0,0.05,0.1,0.05,0.05,0.05,0.05]
[null,"Extra kosten langere BOUWTIJD  t.o.v. normaal",0,"De extra tijd die benodigd is door omstandigheden.  ",0,0,0.05,0,0,0,0]
[null,"Object overstijgende Risicoreservering (bv door marktsituatie)",0.15,"Overspannen markt",0.05,0.15,0.3,0.15,0.15,0.15,0.15]
[null,"Object overstijgende Risicoreservering scope change",0.05,null,0,0.05,0.1,0.05,0.05,0.05,0.05]
[null,"Nader te detailleren",0,"Naar eigen invulling te gebruiken (bv inrichting terrein met infra leidingen/wegen etc","- ","- ","- ",0,0,0,0]
[]
[null,null,null,null,null,null,"Totaal",{"$f":"SUM(H20:H27)","v":0.41},0.41,0.41,0.41]

{"sheet":"B Nw en Renovatie parameters","index":4,"n_rows":34,"n_cols":30,"rows_kept":34,"cut":false,"hidden":false,"merged":[[3,16,4,20],[2,29,3,29],[9,29,10,29],[10,4,11,4],[10,5,11,5],[10,6,11,6],[3,9,4,9],[3,3,4,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabel 3.1 Default toeslagpercentages renovatie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$D12","v":"CTB"},{"$f":"$E11","v":"WTB"},{"$f":"$F11","v":"E & I"},{"$f":"$G11","v":"PA"},null,"Verdere toelichting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%","%","%","%",null,"De default toeslagpercentagen kunnen gewijzigd worden n.a.v. werkzaamheden binnen project. Tabel 3.1 (links) geeft richtlijnen voor deze percentages."]
[null,null,null,"Let op! Na overschrijving vervalt de formule die nieuwbouw en renovatie aan elkaar linkt (100% - nieuwbouw % = renovatie %). Deze formule kan weer worden terug gekopieerd uit de regel daaronder of -boven.",null,null,null,null,null,"Let op! Na handmatige overschrijving van het renovatie % vervalt de formule die nieuwbouw en renovatie aan elkaar linkt (100% - nieuwbouw % = renovatie %). Deze formule kan weer worden terug gekopieerd uit de regel daaronder of -boven.",null,null,null,null,null,null,"Let op! Deze tabel geldt als rekenblad, maak hier geen aanpassingen ",null,null,null,null,null,null,"Default toeslagpercentage renovatie",0.3,0.25,0.25,0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum richtlijn",0.2,0.15,0.15,0.01]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gemiddeld",0.3,0.25,0.25,0.02]
[null,null,"NIEUWBOUW",null,null,null,null,null,null,"RENOVATIE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum richtlijn",0.4,0.35,0.35,0.05]
[null,null,null,null,null,null,null,null,null,"Invullen wat te doen n.a.v. scope project",null,null,null,null,null,null,"Totale som deel nieuwbouw en deel renovatie"]
[null,null,"Tabel 1.  Aandeel NIEUWBOUW binnen project","Evt. Invullen scope per discipline indien gewenst",null,null,null,null,null,"Tabel 2.  Aandeel RENOVATIE  binnen project","Evt. Invullen scope per discipline indien gewenst",null,null,null,null,null,"Let op: hier geen aanpassingen maken",null,null,null,null,null,null,null,"Tabel 3.2 Toeslagpercentage renovatie per procesdeel",null,null,null,null,"Verdere toelichting"]
[null,null,null,"(bestaande situatie/scope = 100%)",null,null,null,null,null,null,{"$f":"D10","v":"(bestaande situatie/scope = 100%)"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In tabel 3.2 (links) kunnen de  toeslagpercentagen per processtap gewijzigd worden n.a.v. werkzaamheden binnen project"]
[null,null,null,null,"WTB","E & I","PA"]
[null,null,"Gemiddelde alle disciplines","CTB",null,null,null,"Vulmaterialen",null,"Gemiddelde alle disciplines","CTB",{"$f":"$E11","v":"WTB"},{"$f":"$F11","v":"E & I"},{"$f":"$G11","v":"PA"},{"$f":"$H12","v":"Vulmaterialen"},null,{"$f":"$D12","v":"CTB"},{"$f":"$E11","v":"WTB"},{"$f":"$F11","v":"E & I"},{"$f":"$G11","v":"PA"},{"$f":"$H12","v":"Vulmaterialen"},null,null,null,{"$f":"$D12","v":"CTB"},{"$f":"$E11","v":"WTB"},{"$f":"$F11","v":"E & I"},{"$f":"$G11","v":"PA"}]
[null,"Processtapbenaming","%","%","%","%","%",null,null,"%","%","%","%","%",null,null,"%","%","%","%",null,null,null,null,"%","%","%","%"]
[{"$f":"'import DATA-CoP KSDW '!D6","v":0},{"$f":"'import DATA-CoP KSDW '!E6","v":0},{"$f":"IF(A14=0,0,1)","v":0},{"$f":"$C14","v":0},{"$f":"$C14","v":0},{"$f":"$C14","v":0},{"$f":"$C14","v":0},{"$f":"$C14","v":0},null,{"$f":"IF(A14=0,0,1-C14)","v":0},{"$f":"IF((D14<>$C14),(1-D14),$J14)","v":0},{"$f":"IF((E14<>$C14),(1-E14),$J14)","v":0},0,0,0,null,{"$f":"D14+K14","v":0},{"$f":"E14+L14","v":0},{"$f":"F14+M14","v":0},{"$f":"G14+N14","v":0},{"$f":"H14+O14","v":0},null,null,null,{"$f":"IF($A14=0,0,Y$4)","v":0},{"$f":"IF($A14=0,0,Z$4)","v":0},0,0]
[{"$f":"'import DATA-CoP KSDW '!D7","v":0},{"$f":"'import DATA-CoP KSDW '!E7","v":0},{"$f":"IF(A15=0,0,1)","v":0},0,0,0,0,0,null,{"$f":"IF(A15=0,0,1-C15)","v":0},0,0,{"$f":"IF((F15<>$C15),(1-F15),$J15)","v":0},{"$f":"IF((G15<>$C15),(1-G15),$J15)","v":0},{"$f":"IF((H15<>$C15),(1-H15),$J15)","v":0},null,{"$f":"D15+K15","v":0},{"$f":"E15+L15","v":0},{"$f":"F15+M15","v":0},0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D8","v":0},{"$f":"'import DATA-CoP KSDW '!E8","v":0},0,0,0,0,0,0,null,{"$f":"IF(A16=0,0,1-C16)","v":0},0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D9","v":0},{"$f":"'import DATA-CoP KSDW '!E9","v":0},0,0,0,0,0,0,null,0,0,{"$f":"IF((E17<>$C17),(1-E17),$J17)","v":0},0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D10","v":0},{"$f":"'import DATA-CoP KSDW '!E10","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D11","v":0},{"$f":"'import DATA-CoP KSDW '!E11","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D12","v":0},{"$f":"'import DATA-CoP KSDW '!E12","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D13","v":0},{"$f":"'import DATA-CoP KSDW '!E13","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D14","v":0},{"$f":"'import DATA-CoP KSDW '!E14","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D15","v":0},{"$f":"'import DATA-CoP KSDW '!E15","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D16","v":0},{"$f":"'import DATA-CoP KSDW '!E16","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D17","v":0},{"$f":"'import DATA-CoP KSDW '!E17","v":0},0,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D18","v":0},{"$f":"'import DATA-CoP KSDW '!E18","v":0},null,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D19","v":0},{"$f":"'import DATA-CoP KSDW '!E19","v":0},null,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D20","v":0},{"$f":"'import DATA-CoP KSDW '!E20","v":0},null,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D21","v":0},{"$f":"'import DATA-CoP KSDW '!E21","v":0},null,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D22","v":0},{"$f":"'import DATA-CoP KSDW '!E22","v":0},null,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,{"$f":"IF($A30=0,0,Z$4)","v":0},0,0]
[{"$f":"'import DATA-CoP KSDW '!D23","v":0},{"$f":"'import DATA-CoP KSDW '!E23","v":0},null,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D24","v":0},{"$f":"'import DATA-CoP KSDW '!E24","v":0},null,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D25","v":0},{"$f":"'import DATA-CoP KSDW '!E25","v":0},null,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]
[{"$f":"'import DATA-CoP KSDW '!D26","v":0},{"$f":"'import DATA-CoP KSDW '!E26","v":0},null,0,0,0,0,0,null,0,0,0,0,0,0,null,0,0,0,0,0,null,null,null,0,0,0,0]

{"sheet":"C  Begrotingsblad","index":5,"n_rows":59,"n_cols":6,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["RAMINGSOVERZICHT"]
["Projectnummer:",null,null,"Prijspeil:",null,{"$f":"'import Alg. uitgangspunten KSDW'!B5","v":"00:00:00"}]
["Projectomschrijving: ",null,null,"Datum:"]
["Project fase:",null,null,"Opgesteld door:"]
[null,null,null,"Versie:"]
[]
[]
[null,"NIEUWBOUW",null,"RENOVATIE",null,"TOTAAL"]
[null,"GEDEELTE",null,"GEDEELTE",null,"NW+RENOVATIE"]
[null,"KSDW+aanpassing",null,"KSDW+aanpassing",null,"KSDW+aanpassing"]
["Omschrijving"]
["Totaal bouwkosten Civiel+Bouwk (+vul mat+ alg voorz.)",{"$f":"IF('E Rekenblad'!$V$68=0,0,'E Rekenblad'!N$30*(1+'E Rekenblad'!$U$5))","v":0},null,{"$f":"IF('E Rekenblad'!$AF$68=0,0,'E Rekenblad'!X$30*(1+'E Rekenblad'!$AE$5))","v":0},null,{"$f":"ROUND(B12+D12,-3)","v":0}]
["Totaal bouwkosten Werktuigbouwkunde",{"$f":"IF('E Rekenblad'!$V$68=0,0,'E Rekenblad'!O$30*(1+'E Rekenblad'!$U$5))","v":0},null,{"$f":"IF('E Rekenblad'!$AF$68=0,0,'E Rekenblad'!Y$30*(1+'E Rekenblad'!$AE$5))","v":0},null,{"$f":"ROUND(B13+D13,-3)","v":0}]
["Totaal bouwkosten Elektro & Instrumentatie",{"$f":"IF('E Rekenblad'!$V$68=0,0,'E Rekenblad'!P$30*(1+'E Rekenblad'!$U$5))","v":0},null,{"$f":"IF('E Rekenblad'!$AF$68=0,0,'E Rekenblad'!Z$30*(1+'E Rekenblad'!$AE$5))","v":0},null,0]
["Totaal bouwkosten Proces Automatisering",{"$f":"IF('E Rekenblad'!$V$68=0,0,'E Rekenblad'!Q$30*(1+'E Rekenblad'!$U$5))","v":0},null,{"$f":"IF('E Rekenblad'!$AF$68=0,0,'E Rekenblad'!AA$30*(1+'E Rekenblad'!$AE$5))","v":0},null,0]
["Totaal vulmaterialen",{"$f":"IF('E Rekenblad'!$V$68=0,0,'E Rekenblad'!R$30*(1+'E Rekenblad'!$U$5))","v":0},null,{"$f":"IF('E Rekenblad'!$AF$68=0,0,'E Rekenblad'!AB$30*(1+'E Rekenblad'!$AE$5))","v":0},null,0]
["Totaal algemene voorzieningen",{"$f":"IF('E Rekenblad'!$V$68=0,0,'E Rekenblad'!S$30*(1+'E Rekenblad'!$U$5))","v":0},null,{"$f":"IF('E Rekenblad'!$AF$68=0,0,'E Rekenblad'!AC$30*(1+'E Rekenblad'!$AE$5))","v":0},null,0]
[]
["SUBTOTAAL BOUWKOSTEN",{"$f":"SUM(B12:B18)","v":0},null,{"$f":"SUM(D12:D18)","v":0},null,{"$f":"SUM(F12:F18)","v":0}]
[]
["Extra bouwkosten door"]
[{"$f":"'E Rekenblad'!B36","v":"Duurzame materialen / circulair bouwen"},{"$f":"'E Rekenblad'!V36","v":0},null,{"$f":"'E Rekenblad'!AF36","v":0},null,{"$f":"ROUND(B22+D22,-3)","v":0}]
[{"$f":"'E Rekenblad'!B37","v":"Elektrisch werken (emissieloos bouwen)"},{"$f":"'E Rekenblad'!V37","v":0},null,{"$f":"'E Rekenblad'!AF37","v":0},null,0]
[{"$f":"'E Rekenblad'!B38","v":"Volledig onafhankelijke straten (keuzelijst)"},{"$f":"'E Rekenblad'!V38","v":0},null,{"$f":"'E Rekenblad'!AF38","v":0},null,0]
[{"$f":"'E Rekenblad'!B39","v":"Extra kosten standaardisatie"},{"$f":"'E Rekenblad'!V39","v":0},null,{"$f":"'E Rekenblad'!AF39","v":0},null,0]
[{"$f":"'E Rekenblad'!B40","v":"Extra kosten langere BOUWTIJD  t.o.v. normaal"},{"$f":"'E Rekenblad'!V40","v":0},null,{"$f":"'E Rekenblad'!AF40","v":0},null,0]
[{"$f":"'E Rekenblad'!B41","v":"Object overstijgende Risicoreservering scope change"},{"$f":"'E Rekenblad'!V41","v":0},null,{"$f":"'E Rekenblad'!AF41","v":0},null,0]
[{"$f":"'E Rekenblad'!B42","v":"Nader te detailleren"},{"$f":"'E Rekenblad'!V42","v":0},null,{"$f":"'E Rekenblad'!AF42","v":0}]
[]
["TOTAAL BOUWKOSTEN",{"$f":"SUM(B19:B28)","v":0},null,{"$f":"SUM(D19:D28)","v":0},null,{"$f":"SUM(F19:F28)","v":0}]
[]
[]
["TOTAAL VASTGOEDKOSTEN",{"$f":"'E Rekenblad'!V51","v":0},null,{"$f":"'E Rekenblad'!AF51","v":0},null,{"$f":"ROUND(B33+D33,-3)","v":0}]
[]
[]
[{"$f":"'E Rekenblad'!B56","v":"Engineeringskosten IB  (incl onderzoeken/adv)"},{"$f":"'E Rekenblad'!V56","v":0},null,{"$f":"'E Rekenblad'!AF56","v":0},null,{"$f":"ROUND(B36+D36,-3)","v":0}]
[{"$f":"'E Rekenblad'!B57","v":"Engineeringskosten OG (interne uren)"},{"$f":"'E Rekenblad'!V57","v":0},null,{"$f":"'E Rekenblad'!AF57","v":0},null,0]
[{"$f":"'E Rekenblad'!B58","v":"Totaal Engineerinskosten (OG+IB)"},{"$f":"'E Rekenblad'!V58","v":0},null,{"$f":"'E Rekenblad'!AF58","v":0},null,0]
[]
[]
[{"$f":"'E Rekenblad'!B62","v":"Overige bijkomende kosten"},{"$f":"'E Rekenblad'!V62","v":0},null,{"$f":"'E Rekenblad'!AF62","v":0},null,{"$f":"ROUND(B41+D41,-3)","v":0}]
[]
[]
[{"$f":"'E Rekenblad'!B65","v":"Object overstijgende Risicoreservering"},{"$f":"'E Rekenblad'!V65","v":0},null,{"$f":"'E Rekenblad'!AF65","v":0},null,{"$f":"ROUND(B44+D44,-3)","v":0}]
[]
[]
[]
[{"$f":"'E Rekenblad'!B68","v":"Totaal investeringskosten"},{"$f":"B30+B38+B41+B44","v":0},null,{"$f":"D30+D38+D41+D44","v":0},null,{"$f":"F30+F38+F41+F44","v":0}]
[]
[]
["Percentage onnauwkeurigheid",0.35,null,0.5,null,{"$f":"F52/F48","v":{"$error":"#DIV/0!"}}]
["Onnauwkeurigheid",{"$f":"ROUND(B48*B51,-5)","v":0},null,{"$f":"ROUND(D48*D51,-5)","v":0},null,{"$f":"ROUND(B52+D52,-3)","v":0}]
["Ondergrens",{"$f":"ROUND(B48-B52,-5)","v":0},null,{"$f":"ROUND(D48-D52,-5)","v":0},null,{"$f":"ROUND(F48-F52,-5)","v":0}]
["Bovengrens",{"$f":"ROUND(B48+B52,-5)","v":0},null,{"$f":"ROUND(D48+D53,-5)","v":0},null,{"$f":"ROUND(F48+F52,-5)","v":0}]
[]
[]
[]
[]
[{"$f":"'E Rekenblad'!B73","v":"Sloopkosten"},null,null,null,null,{"$f":"'E Rekenblad'!AP73","v":0}]

{"sheet":"D Presentatie+grafieken","index":6,"n_rows":114,"n_cols":6,"rows_kept":114,"cut":false,"hidden":false,"merged":[[86,5,87,6]]}
[]
[]
[1,"Bouwkosten per processtap (inclusief indirecte bouwkosten, exclusief toeslagen)"]
["Totaal BK bij 100% nieuwbouw","Processtap","Deel Nieuwbouw BK","Deel Renovatie BK","Totaal (Deel nieuwbouw BK + Deel Renovatie BK)"]
[{"$f":"'E Rekenblad'!L9","v":0},{"$f":"'E Rekenblad'!B9","v":0},{"$f":"'E Rekenblad'!V9","v":0},{"$f":"'E Rekenblad'!AF9","v":0},{"$f":"'E Rekenblad'!AP9","v":0}]
[{"$f":"'E Rekenblad'!L10","v":0},{"$f":"'E Rekenblad'!B10","v":0},{"$f":"'E Rekenblad'!V10","v":0},{"$f":"'E Rekenblad'!AF10","v":0},{"$f":"'E Rekenblad'!AP10","v":0}]
[{"$f":"'E Rekenblad'!L11","v":0},{"$f":"'E Rekenblad'!B11","v":0},{"$f":"'E Rekenblad'!V11","v":0},{"$f":"'E Rekenblad'!AF11","v":0},{"$f":"'E Rekenblad'!AP11","v":0}]
[{"$f":"'E Rekenblad'!L12","v":0},{"$f":"'E Rekenblad'!B12","v":0},{"$f":"'E Rekenblad'!V12","v":0},{"$f":"'E Rekenblad'!AF12","v":0},{"$f":"'E Rekenblad'!AP12","v":0}]
[{"$f":"'E Rekenblad'!L13","v":0},{"$f":"'E Rekenblad'!B13","v":0},{"$f":"'E Rekenblad'!V13","v":0},{"$f":"'E Rekenblad'!AF13","v":0},{"$f":"'E Rekenblad'!AP13","v":0}]
[{"$f":"'E Rekenblad'!L14","v":0},{"$f":"'E Rekenblad'!B14","v":0},{"$f":"'E Rekenblad'!V14","v":0},{"$f":"'E Rekenblad'!AF14","v":0},{"$f":"'E Rekenblad'!AP14","v":0}]
[{"$f":"'E Rekenblad'!L15","v":0},{"$f":"'E Rekenblad'!B15","v":0},{"$f":"'E Rekenblad'!V15","v":0},{"$f":"'E Rekenblad'!AF15","v":0},{"$f":"'E Rekenblad'!AP15","v":0}]
[{"$f":"'E Rekenblad'!L16","v":0},{"$f":"'E Rekenblad'!B16","v":0},{"$f":"'E Rekenblad'!V16","v":0},{"$f":"'E Rekenblad'!AF16","v":0},{"$f":"'E Rekenblad'!AP16","v":0}]
[{"$f":"'E Rekenblad'!L17","v":0},{"$f":"'E Rekenblad'!B17","v":0},{"$f":"'E Rekenblad'!V17","v":0},{"$f":"'E Rekenblad'!AF17","v":0},{"$f":"'E Rekenblad'!AP17","v":0}]
[{"$f":"'E Rekenblad'!L18","v":0},{"$f":"'E Rekenblad'!B18","v":0},{"$f":"'E Rekenblad'!V18","v":0},{"$f":"'E Rekenblad'!AF18","v":0},{"$f":"'E Rekenblad'!AP18","v":0}]
[{"$f":"'E Rekenblad'!L19","v":0},{"$f":"'E Rekenblad'!B19","v":0},{"$f":"'E Rekenblad'!V19","v":0},{"$f":"'E Rekenblad'!AF19","v":0},{"$f":"'E Rekenblad'!AP19","v":0}]
[{"$f":"'E Rekenblad'!L20","v":0},{"$f":"'E Rekenblad'!B20","v":0},{"$f":"'E Rekenblad'!V20","v":0},{"$f":"'E Rekenblad'!AF20","v":0},{"$f":"'E Rekenblad'!AP20","v":0}]
[{"$f":"'E Rekenblad'!L21","v":0},{"$f":"'E Rekenblad'!B21","v":0},{"$f":"'E Rekenblad'!V21","v":0},{"$f":"'E Rekenblad'!AF21","v":0},{"$f":"'E Rekenblad'!AP21","v":0}]
[{"$f":"'E Rekenblad'!L22","v":0},{"$f":"'E Rekenblad'!B22","v":0},{"$f":"'E Rekenblad'!V22","v":0},{"$f":"'E Rekenblad'!AF22","v":0},{"$f":"'E Rekenblad'!AP22","v":0}]
[{"$f":"'E Rekenblad'!L23","v":0},{"$f":"'E Rekenblad'!B23","v":0},{"$f":"'E Rekenblad'!V23","v":0},{"$f":"'E Rekenblad'!AF23","v":0},{"$f":"'E Rekenblad'!AP23","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"Bouwkosten per discipline (inclusief indirecte bouwkosten, exclusief toeslagen)"]
[{"$f":"A4","v":"Totaal BK bij 100% nieuwbouw"},"Discipline","Deel Nieuwbouw BK",{"$f":"D4","v":"Deel Renovatie BK"},"Totaal (Deel nieuwbouw BK + Deel Renovatie BK)"]
[{"$f":"'E Rekenblad'!D30","v":0},{"$f":"'E Rekenblad'!D7","v":"CTB"},{"$f":"'E Rekenblad'!N30","v":0},{"$f":"'E Rekenblad'!X30","v":0},{"$f":"C37+D37","v":0}]
[{"$f":"'E Rekenblad'!E30","v":0},{"$f":"'E Rekenblad'!E7","v":"WTB"},{"$f":"'E Rekenblad'!O30","v":0},{"$f":"'E Rekenblad'!Y30","v":0},{"$f":"C38+D38","v":0}]
[{"$f":"'E Rekenblad'!F30","v":0},{"$f":"'E Rekenblad'!F7","v":"E & I"},{"$f":"'E Rekenblad'!P30","v":0},{"$f":"'E Rekenblad'!Z30","v":0},0]
[{"$f":"'E Rekenblad'!G30","v":0},{"$f":"'E Rekenblad'!G7","v":"PA"},{"$f":"'E Rekenblad'!Q30","v":0},{"$f":"'E Rekenblad'!AA30","v":0},0]
[{"$f":"'E Rekenblad'!I30","v":0},{"$f":"'E Rekenblad'!I7","v":"Alg. Voorzieningen"},{"$f":"'E Rekenblad'!S30+'E Rekenblad'!R30","v":0},{"$f":"'E Rekenblad'!AC30+'E Rekenblad'!AB30","v":0},0]
[{"$f":"'E Rekenblad'!J30","v":0},{"$f":"'E Rekenblad'!J7","v":"Totaal"},{"$f":"'E Rekenblad'!T30","v":0},{"$f":"'E Rekenblad'!AD30","v":0},0]
[{"$f":"'E Rekenblad'!K30","v":0},{"$f":"'E Rekenblad'!K7","v":"Indirecte BK"},{"$f":"'E Rekenblad'!U30","v":0},{"$f":"'E Rekenblad'!AE30","v":0},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[3,"Investeringskosten (totale kosten)"]
["Totale kosten bij 100% nieuwbouw","Investeringskosten (nw/ ren)","Deel Nieuwbouw BK","Deel Renovatie BK","Totaal (Deel nieuwbouw BK + Deel Renovatie BK)"]
[{"$f":"'E Rekenblad'!L30","v":0},"Totaal voorziene BK",{"$f":"'E Rekenblad'!V30","v":0},{"$f":"'E Rekenblad'!AF30","v":0},{"$f":"ROUND(C55+D55,-5)","v":0}]
[{"$f":"'E Rekenblad'!L43","v":0},{"$f":"'E Rekenblad'!Z45","v":"Toeslagen BK"},{"$f":"'E Rekenblad'!V43","v":0},{"$f":"'E Rekenblad'!AF43","v":0},0]
[{"$f":"'E Rekenblad'!L58","v":0},{"$f":"'E Rekenblad'!N58","v":"Totaal Engineerinskosten (OG+IB)"},{"$f":"'E Rekenblad'!V58","v":0},{"$f":"'E Rekenblad'!AF58","v":0},0]
[{"$f":"'E Rekenblad'!L62","v":0},{"$f":"'E Rekenblad'!B62","v":"Overige bijkomende kosten"},{"$f":"'E Rekenblad'!V62","v":0},{"$f":"'E Rekenblad'!AF62","v":0},0]
[{"$f":"'E Rekenblad'!L65","v":0},{"$f":"'E Rekenblad'!B65","v":"Object overstijgende Risicoreservering"},{"$f":"'E Rekenblad'!V65","v":0},{"$f":"'E Rekenblad'!AF65","v":0},0]
[null,{"$f":"'E Rekenblad'!N68","v":"Totaal investeringskosten"},{"$f":"'E Rekenblad'!V68","v":0},{"$f":"'E Rekenblad'!AF68","v":0},0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[4,"Toeslagen per onderwerp"]
["Totaal BK bij 100% nieuwbouw","Toeslagen per onderwerp","Deel Nieuwbouw BK","Deel Renovatie BK","Totaal (Deel nieuwbouw BK + Deel Renovatie BK)"]
[{"$f":"'E Rekenblad'!L36","v":0},{"$f":"'E Rekenblad'!B36","v":"Duurzame materialen / circulair bouwen"},{"$f":"'E Rekenblad'!V36","v":0},{"$f":"'E Rekenblad'!AF36","v":0},{"$f":"'E Rekenblad'!AP36","v":0}]
[{"$f":"'E Rekenblad'!L37","v":0},{"$f":"'E Rekenblad'!B37","v":"Elektrisch werken (emissieloos bouwen)"},{"$f":"'E Rekenblad'!V37","v":0},{"$f":"'E Rekenblad'!AF37","v":0},{"$f":"'E Rekenblad'!AP37","v":0}]
[{"$f":"'E Rekenblad'!L38","v":0},{"$f":"'E Rekenblad'!B38","v":"Volledig onafhankelijke straten (keuzelijst)"},{"$f":"'E Rekenblad'!V38","v":0},{"$f":"'E Rekenblad'!AF38","v":0},{"$f":"'E Rekenblad'!AP38","v":0}]
[{"$f":"'E Rekenblad'!L39","v":0},{"$f":"'E Rekenblad'!B39","v":"Extra kosten standaardisatie"},{"$f":"'E Rekenblad'!V39","v":0},{"$f":"'E Rekenblad'!AF39","v":0},{"$f":"'E Rekenblad'!AP39","v":0}]
[{"$f":"'E Rekenblad'!L40","v":0},{"$f":"'E Rekenblad'!B40","v":"Extra kosten langere BOUWTIJD  t.o.v. normaal"},{"$f":"'E Rekenblad'!V40","v":0},{"$f":"'E Rekenblad'!AF40","v":0},{"$f":"'E Rekenblad'!AP40","v":0}]
[{"$f":"'E Rekenblad'!L41","v":0},{"$f":"'E Rekenblad'!B41","v":"Object overstijgende Risicoreservering scope change"},{"$f":"'E Rekenblad'!V41","v":0},{"$f":"'E Rekenblad'!AF41","v":0},{"$f":"'E Rekenblad'!AP41","v":0}]
[{"$f":"'E Rekenblad'!L42","v":0},{"$f":"'E Rekenblad'!B42","v":"Nader te detailleren"},{"$f":"'E Rekenblad'!V42","v":0},{"$f":"'E Rekenblad'!AF42","v":0},{"$f":"'E Rekenblad'!AP42","v":0},"Regel verwijderen als niet van toepassing"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[5,"Toeslagen per discipline"]
["Totaal Bouwkosten bij 100% nieuwbouw",null,"Deel Nieuwbouw BK","Renovatie BK","Totaal (Deel nieuwbouw BK + Deel Renovatie BK)"]
[{"$f":"'E Rekenblad'!D43","v":0},{"$f":"'E Rekenblad'!X35","v":"CTB"},{"$f":"'E Rekenblad'!N43","v":0},{"$f":"'E Rekenblad'!X43","v":0},{"$f":"'E Rekenblad'!AH43","v":0}]
[{"$f":"'E Rekenblad'!E43","v":0},{"$f":"'E Rekenblad'!Y35","v":"WTB"},{"$f":"'E Rekenblad'!O43","v":0},{"$f":"'E Rekenblad'!Y43","v":0},{"$f":"'E Rekenblad'!AI43","v":0}]
[{"$f":"'E Rekenblad'!F43","v":0},{"$f":"'E Rekenblad'!Z35","v":"E & I"},{"$f":"'E Rekenblad'!P43","v":0},{"$f":"'E Rekenblad'!Z43","v":0},{"$f":"'E Rekenblad'!AJ43","v":0}]
[{"$f":"'E Rekenblad'!G43","v":0},{"$f":"'E Rekenblad'!AA35","v":"PA"},{"$f":"'E Rekenblad'!Q43","v":0},{"$f":"'E Rekenblad'!AA43","v":0},{"$f":"'E Rekenblad'!AK43","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[6,"Projectkosten"]
["Totaal projectkosten bij 100% nieuwbouw",null,"Deel Nieuwbouw BK","Renovatie BK","Totaal (Deel nieuwbouw BK + Deel Renovatie BK)"]
[{"$f":"'E Rekenblad'!L56","v":0},{"$f":"'E Rekenblad'!X56","v":"Engineeringskosten IB  (incl onderzoeken/adv)"},{"$f":"'E Rekenblad'!V56","v":0},{"$f":"'E Rekenblad'!AF56","v":0},{"$f":"'E Rekenblad'!AP56","v":0}]
[{"$f":"'E Rekenblad'!L57","v":0},{"$f":"'E Rekenblad'!X57","v":"Totaal interne uren "},{"$f":"'E Rekenblad'!V57","v":0},{"$f":"'E Rekenblad'!AF57","v":0},{"$f":"'E Rekenblad'!AP57","v":0}]

{"sheet":"E Rekenblad","index":7,"n_rows":102,"n_cols":42,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"NIEUWBOUW uit kostenstandaard",null,null,null,null,null,"EXPORT KSDW",null,null,null,"DEEL NIEUWBOUW ",null,null,null,null,null,"DEEL NIEUWBOUW ",null,null,null,"DEEL RENOVATIE",null,null,null,null,null,"DEEL RENOVATIE",null,null,null,"TOTAAL PROJECT",null,null,null,null,null,"TOTAAL PROJECT"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K30/J30","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"U30/T30","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"AE30/AD30","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,{"$f":"AO30/AN30","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Nieuw (bouwkosten) uit kostenstandaard",null,null,null,null,null,null,null,"Totaal  ",null,"Nieuw (bouwkosten) uit kostenstandaard",null,null,null,null,null,null,null,"Totaal  ",null,"Renovatie- (bouwkosten)(omgerekend o.b.v. KSDW)",null,null,null,null,null,null,null,"Totaal  ",null,"Totaal Bouwkosten (deel nieuw + deel renovatie)",null,null,null,null,null,null,null,"Totaal  "]
[null,null,null,"CTB","WTB","E & I","PA","Vulmaterialen","Alg. Voorzieningen","Totaal","Indirecte BK","Bouwkosten\n(nieuwbouw)",null,"CTB","WTB","E & I","PA","Vul materialen","Alg. Voorzieningen","Totaal","Indirecte BK","Bouwkosten\n(DEEL NIEUWBOUW)",null,"CTB","WTB","E & I","PA","Vul materialen","Alg. Voorzieningen","Totaal","Indirecte BK","Bouwkosten\n(DEEL RENOVATIE)",null,"CTB","WTB","E & I","PA","Vul materialen","Alg.voorz.","Totaal","Indirecte BK","Bouwkosten (TOTAAL PROJECT)"]
[null,"Processtapbenaming",null,"Directe BK",{"$f":"$D$8","v":"Directe BK"},{"$f":"$D$8","v":"Directe BK"},{"$f":"$D$8","v":"Directe BK"},"Directe BK","Directe BK","Directe BK","Indirecte BK","Totale VBK",null,"Directe BK",{"$f":"$D$8","v":"Directe BK"},{"$f":"$D$8","v":"Directe BK"},{"$f":"$D$8","v":"Directe BK"},"Directe BK","Directe BK","Directe BK","Indirecte BK","Totale VBK",null,{"$f":"$D$8","v":"Directe BK"},{"$f":"$D$8","v":"Directe BK"},"Directe BK","Directe BK","Directe BK","Directe BK","Directe BK",{"$f":"K8","v":"Indirecte BK"},{"$f":"D8","v":"Directe BK"},null,{"$f":"$D$8","v":"Directe BK"},{"$f":"$D$8","v":"Directe BK"},"Directe BK","Directe BK","Directe BK","Directe BK","Directe BK",{"$f":"U8","v":"Indirecte BK"},{"$f":"N8","v":"Directe BK"}]
[{"$f":"IF(B9=\"Infra\",27,'import DATA-CoP KSDW '!D6)","v":0},{"$f":"'import DATA-CoP KSDW '!E6","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O6)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q6/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S6/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U6/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V6/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A9=27,0,(SUM(D9:G9)+H9)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},{"$f":"SUM(D9:I9)","v":0},{"$f":"'A Scope parameters'!C$3*D9+'A Scope parameters'!C$4*E9+'A Scope parameters'!C$5*F9+'A Scope parameters'!C$6*G9+'A Scope parameters'!C$3*(H9+I9)","v":0},{"$f":"J9+K9","v":0},null,{"$f":"D9*'B Nw en Renovatie parameters'!D14","v":0},{"$f":"E9*'B Nw en Renovatie parameters'!E14","v":0},{"$f":"F9*'B Nw en Renovatie parameters'!F14","v":0},{"$f":"G9*'B Nw en Renovatie parameters'!G14","v":0},{"$f":"H9*'B Nw en Renovatie parameters'!H14","v":0},{"$f":"IF(A9=27,0,IF(A9=0,0,I9*SUM(N9:R9)/SUM(D9:H9)))","v":0},{"$f":"SUM(N9:S9)","v":0},{"$f":"'A Scope parameters'!C$3*N9+'A Scope parameters'!C$4*O9+'A Scope parameters'!C$5*P9+'A Scope parameters'!C$6*Q9+'A Scope parameters'!C$3*(R9+S9)","v":0},{"$f":"T9+U9","v":0},null,{"$f":"D9*'B Nw en Renovatie parameters'!K14*(1+'B Nw en Renovatie parameters'!Y14)","v":0},{"$f":"E9*'B Nw en Renovatie parameters'!L14*(1+'B Nw en Renovatie parameters'!Z14)","v":0},{"$f":"F9*'B Nw en Renovatie parameters'!M14*(1+'B Nw en Renovatie parameters'!AA14)","v":0},{"$f":"G9*'B Nw en Renovatie parameters'!N14*(1+'B Nw en Renovatie parameters'!AB14)","v":0},{"$f":"H9*'B Nw en Renovatie parameters'!O14","v":0},{"$f":"IF(A9=27,0,IF(A9=0,0,I9*SUM(X9:AB9)/SUM(D9:H9)))","v":0},{"$f":"SUM(X9:AC9)","v":0},{"$f":"'A Scope parameters'!C$3*X9+'A Scope parameters'!C$4*Y9+'A Scope parameters'!C$5*Z9+'A Scope parameters'!C$6*AA9+'A Scope parameters'!C$3*(AB9+AC9)","v":0},{"$f":"AD9+AE9","v":0},null,{"$f":"N9+X9","v":0},{"$f":"O9+Y9","v":0},{"$f":"P9+Z9","v":0},{"$f":"Q9+AA9","v":0},{"$f":"R9+AB9","v":0},{"$f":"S9+AC9","v":0},{"$f":"T9+AD9","v":0},{"$f":"U9+AE9","v":0},{"$f":"V9+AF9","v":0}]
[{"$f":"IF(B10=\"Infra\",27,'import DATA-CoP KSDW '!D7)","v":0},{"$f":"'import DATA-CoP KSDW '!E7","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O7)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q7/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S7/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U7/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V7/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A10=27,0,(SUM(D10:G10)+H10)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D10+'A Scope parameters'!C$4*E10+'A Scope parameters'!C$5*F10+'A Scope parameters'!C$6*G10+'A Scope parameters'!C$3*(H10+I10)","v":0},0,null,{"$f":"D10*'B Nw en Renovatie parameters'!D15","v":0},{"$f":"E10*'B Nw en Renovatie parameters'!E15","v":0},{"$f":"F10*'B Nw en Renovatie parameters'!F15","v":0},{"$f":"G10*'B Nw en Renovatie parameters'!G15","v":0},{"$f":"H10*'B Nw en Renovatie parameters'!H15","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N10+'A Scope parameters'!C$4*O10+'A Scope parameters'!C$5*P10+'A Scope parameters'!C$6*Q10+'A Scope parameters'!C$3*(R10+S10)","v":0},0,null,{"$f":"D10*'B Nw en Renovatie parameters'!K15*(1+'B Nw en Renovatie parameters'!Y15)","v":0},{"$f":"E10*'B Nw en Renovatie parameters'!L15*(1+'B Nw en Renovatie parameters'!Z15)","v":0},{"$f":"F10*'B Nw en Renovatie parameters'!M15*(1+'B Nw en Renovatie parameters'!AA15)","v":0},{"$f":"G10*'B Nw en Renovatie parameters'!N15*(1+'B Nw en Renovatie parameters'!AB15)","v":0},{"$f":"H10*'B Nw en Renovatie parameters'!O15","v":0},0,{"$f":"SUM(X10:AC10)","v":0},{"$f":"'A Scope parameters'!C$3*X10+'A Scope parameters'!C$4*Y10+'A Scope parameters'!C$5*Z10+'A Scope parameters'!C$6*AA10+'A Scope parameters'!C$3*(AB10+AC10)","v":0},{"$f":"AD10+AE10","v":0},null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B11=\"Infra\",27,'import DATA-CoP KSDW '!D8)","v":0},{"$f":"'import DATA-CoP KSDW '!E8","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O8)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q8/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S8/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U8/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V8/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A11=27,0,(SUM(D11:G11)+H11)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D11+'A Scope parameters'!C$4*E11+'A Scope parameters'!C$5*F11+'A Scope parameters'!C$6*G11+'A Scope parameters'!C$3*(H11+I11)","v":0},0,null,{"$f":"D11*'B Nw en Renovatie parameters'!D16","v":0},{"$f":"E11*'B Nw en Renovatie parameters'!E16","v":0},{"$f":"F11*'B Nw en Renovatie parameters'!F16","v":0},{"$f":"G11*'B Nw en Renovatie parameters'!G16","v":0},{"$f":"H11*'B Nw en Renovatie parameters'!H16","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N11+'A Scope parameters'!C$4*O11+'A Scope parameters'!C$5*P11+'A Scope parameters'!C$6*Q11+'A Scope parameters'!C$3*(R11+S11)","v":0},0,null,{"$f":"D11*'B Nw en Renovatie parameters'!K16*(1+'B Nw en Renovatie parameters'!Y16)","v":0},{"$f":"E11*'B Nw en Renovatie parameters'!L16*(1+'B Nw en Renovatie parameters'!Z16)","v":0},{"$f":"F11*'B Nw en Renovatie parameters'!M16*(1+'B Nw en Renovatie parameters'!AA16)","v":0},{"$f":"G11*'B Nw en Renovatie parameters'!N16*(1+'B Nw en Renovatie parameters'!AB16)","v":0},{"$f":"H11*'B Nw en Renovatie parameters'!O16","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X11+'A Scope parameters'!C$4*Y11+'A Scope parameters'!C$5*Z11+'A Scope parameters'!C$6*AA11+'A Scope parameters'!C$3*(AB11+AC11)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B12=\"Infra\",27,'import DATA-CoP KSDW '!D9)","v":0},{"$f":"'import DATA-CoP KSDW '!E9","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O9)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q9/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S9/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U9/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V9/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A12=27,0,(SUM(D12:G12)+H12)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D12+'A Scope parameters'!C$4*E12+'A Scope parameters'!C$5*F12+'A Scope parameters'!C$6*G12+'A Scope parameters'!C$3*(H12+I12)","v":0},0,null,{"$f":"D12*'B Nw en Renovatie parameters'!D17","v":0},{"$f":"E12*'B Nw en Renovatie parameters'!E17","v":0},{"$f":"F12*'B Nw en Renovatie parameters'!F17","v":0},{"$f":"G12*'B Nw en Renovatie parameters'!G17","v":0},{"$f":"H12*'B Nw en Renovatie parameters'!H17","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N12+'A Scope parameters'!C$4*O12+'A Scope parameters'!C$5*P12+'A Scope parameters'!C$6*Q12+'A Scope parameters'!C$3*(R12+S12)","v":0},0,null,{"$f":"D12*'B Nw en Renovatie parameters'!K17*(1+'B Nw en Renovatie parameters'!Y17)","v":0},{"$f":"E12*'B Nw en Renovatie parameters'!L17*(1+'B Nw en Renovatie parameters'!Z17)","v":0},{"$f":"F12*'B Nw en Renovatie parameters'!M17*(1+'B Nw en Renovatie parameters'!AA17)","v":0},{"$f":"G12*'B Nw en Renovatie parameters'!N17*(1+'B Nw en Renovatie parameters'!AB17)","v":0},{"$f":"H12*'B Nw en Renovatie parameters'!O17","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X12+'A Scope parameters'!C$4*Y12+'A Scope parameters'!C$5*Z12+'A Scope parameters'!C$6*AA12+'A Scope parameters'!C$3*(AB12+AC12)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B13=\"Infra\",27,'import DATA-CoP KSDW '!D10)","v":0},{"$f":"'import DATA-CoP KSDW '!E10","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O10)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q10/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S10/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U10/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V10/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A13=27,0,(SUM(D13:G13)+H13)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D13+'A Scope parameters'!C$4*E13+'A Scope parameters'!C$5*F13+'A Scope parameters'!C$6*G13+'A Scope parameters'!C$3*(H13+I13)","v":0},0,null,{"$f":"D13*'B Nw en Renovatie parameters'!D18","v":0},{"$f":"E13*'B Nw en Renovatie parameters'!E18","v":0},{"$f":"F13*'B Nw en Renovatie parameters'!F18","v":0},{"$f":"G13*'B Nw en Renovatie parameters'!G18","v":0},{"$f":"H13*'B Nw en Renovatie parameters'!H18","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N13+'A Scope parameters'!C$4*O13+'A Scope parameters'!C$5*P13+'A Scope parameters'!C$6*Q13+'A Scope parameters'!C$3*(R13+S13)","v":0},0,null,{"$f":"D13*'B Nw en Renovatie parameters'!K18*(1+'B Nw en Renovatie parameters'!Y18)","v":0},{"$f":"E13*'B Nw en Renovatie parameters'!L18*(1+'B Nw en Renovatie parameters'!Z18)","v":0},{"$f":"F13*'B Nw en Renovatie parameters'!M18*(1+'B Nw en Renovatie parameters'!AA18)","v":0},{"$f":"G13*'B Nw en Renovatie parameters'!N18*(1+'B Nw en Renovatie parameters'!AB18)","v":0},{"$f":"H13*'B Nw en Renovatie parameters'!O18","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X13+'A Scope parameters'!C$4*Y13+'A Scope parameters'!C$5*Z13+'A Scope parameters'!C$6*AA13+'A Scope parameters'!C$3*(AB13+AC13)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B14=\"Infra\",27,'import DATA-CoP KSDW '!D11)","v":0},{"$f":"'import DATA-CoP KSDW '!E11","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O11)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q11/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S11/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U11/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V11/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A14=27,0,(SUM(D14:G14)+H14)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D14+'A Scope parameters'!C$4*E14+'A Scope parameters'!C$5*F14+'A Scope parameters'!C$6*G14+'A Scope parameters'!C$3*(H14+I14)","v":0},0,null,{"$f":"D14*'B Nw en Renovatie parameters'!D19","v":0},{"$f":"E14*'B Nw en Renovatie parameters'!E19","v":0},{"$f":"F14*'B Nw en Renovatie parameters'!F19","v":0},{"$f":"G14*'B Nw en Renovatie parameters'!G19","v":0},{"$f":"H14*'B Nw en Renovatie parameters'!H19","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N14+'A Scope parameters'!C$4*O14+'A Scope parameters'!C$5*P14+'A Scope parameters'!C$6*Q14+'A Scope parameters'!C$3*(R14+S14)","v":0},0,null,{"$f":"D14*'B Nw en Renovatie parameters'!K19*(1+'B Nw en Renovatie parameters'!Y19)","v":0},{"$f":"E14*'B Nw en Renovatie parameters'!L19*(1+'B Nw en Renovatie parameters'!Z19)","v":0},{"$f":"F14*'B Nw en Renovatie parameters'!M19*(1+'B Nw en Renovatie parameters'!AA19)","v":0},{"$f":"G14*'B Nw en Renovatie parameters'!N19*(1+'B Nw en Renovatie parameters'!AB19)","v":0},{"$f":"H14*'B Nw en Renovatie parameters'!O19","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X14+'A Scope parameters'!C$4*Y14+'A Scope parameters'!C$5*Z14+'A Scope parameters'!C$6*AA14+'A Scope parameters'!C$3*(AB14+AC14)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B15=\"Infra\",27,'import DATA-CoP KSDW '!D12)","v":0},{"$f":"'import DATA-CoP KSDW '!E12","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O12)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q12/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S12/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U12/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V12/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A15=27,0,(SUM(D15:G15)+H15)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D15+'A Scope parameters'!C$4*E15+'A Scope parameters'!C$5*F15+'A Scope parameters'!C$6*G15+'A Scope parameters'!C$3*(H15+I15)","v":0},0,null,{"$f":"D15*'B Nw en Renovatie parameters'!D20","v":0},{"$f":"E15*'B Nw en Renovatie parameters'!E20","v":0},{"$f":"F15*'B Nw en Renovatie parameters'!F20","v":0},{"$f":"G15*'B Nw en Renovatie parameters'!G20","v":0},{"$f":"H15*'B Nw en Renovatie parameters'!H20","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N15+'A Scope parameters'!C$4*O15+'A Scope parameters'!C$5*P15+'A Scope parameters'!C$6*Q15+'A Scope parameters'!C$3*(R15+S15)","v":0},0,null,{"$f":"D15*'B Nw en Renovatie parameters'!K20*(1+'B Nw en Renovatie parameters'!Y20)","v":0},{"$f":"E15*'B Nw en Renovatie parameters'!L20*(1+'B Nw en Renovatie parameters'!Z20)","v":0},{"$f":"F15*'B Nw en Renovatie parameters'!M20*(1+'B Nw en Renovatie parameters'!AA20)","v":0},{"$f":"G15*'B Nw en Renovatie parameters'!N20*(1+'B Nw en Renovatie parameters'!AB20)","v":0},{"$f":"H15*'B Nw en Renovatie parameters'!O20","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X15+'A Scope parameters'!C$4*Y15+'A Scope parameters'!C$5*Z15+'A Scope parameters'!C$6*AA15+'A Scope parameters'!C$3*(AB15+AC15)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B16=\"Infra\",27,'import DATA-CoP KSDW '!D13)","v":0},{"$f":"'import DATA-CoP KSDW '!E13","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O13)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q13/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S13/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U13/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V13/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A16=27,0,(SUM(D16:G16)+H16)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D16+'A Scope parameters'!C$4*E16+'A Scope parameters'!C$5*F16+'A Scope parameters'!C$6*G16+'A Scope parameters'!C$3*(H16+I16)","v":0},0,null,{"$f":"D16*'B Nw en Renovatie parameters'!D21","v":0},{"$f":"E16*'B Nw en Renovatie parameters'!E21","v":0},{"$f":"F16*'B Nw en Renovatie parameters'!F21","v":0},{"$f":"G16*'B Nw en Renovatie parameters'!G21","v":0},{"$f":"H16*'B Nw en Renovatie parameters'!H21","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N16+'A Scope parameters'!C$4*O16+'A Scope parameters'!C$5*P16+'A Scope parameters'!C$6*Q16+'A Scope parameters'!C$3*(R16+S16)","v":0},0,null,{"$f":"D16*'B Nw en Renovatie parameters'!K21*(1+'B Nw en Renovatie parameters'!Y21)","v":0},{"$f":"E16*'B Nw en Renovatie parameters'!L21*(1+'B Nw en Renovatie parameters'!Z21)","v":0},{"$f":"F16*'B Nw en Renovatie parameters'!M21*(1+'B Nw en Renovatie parameters'!AA21)","v":0},{"$f":"G16*'B Nw en Renovatie parameters'!N21*(1+'B Nw en Renovatie parameters'!AB21)","v":0},{"$f":"H16*'B Nw en Renovatie parameters'!O21","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X16+'A Scope parameters'!C$4*Y16+'A Scope parameters'!C$5*Z16+'A Scope parameters'!C$6*AA16+'A Scope parameters'!C$3*(AB16+AC16)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B17=\"Infra\",27,'import DATA-CoP KSDW '!D14)","v":0},{"$f":"'import DATA-CoP KSDW '!E14","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O14)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q14/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S14/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U14/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V14/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A17=27,0,(SUM(D17:G17)+H17)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D17+'A Scope parameters'!C$4*E17+'A Scope parameters'!C$5*F17+'A Scope parameters'!C$6*G17+'A Scope parameters'!C$3*(H17+I17)","v":0},0,null,{"$f":"D17*'B Nw en Renovatie parameters'!D22","v":0},{"$f":"E17*'B Nw en Renovatie parameters'!E22","v":0},{"$f":"F17*'B Nw en Renovatie parameters'!F22","v":0},{"$f":"G17*'B Nw en Renovatie parameters'!G22","v":0},{"$f":"H17*'B Nw en Renovatie parameters'!H22","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N17+'A Scope parameters'!C$4*O17+'A Scope parameters'!C$5*P17+'A Scope parameters'!C$6*Q17+'A Scope parameters'!C$3*(R17+S17)","v":0},0,null,{"$f":"D17*'B Nw en Renovatie parameters'!K22*(1+'B Nw en Renovatie parameters'!Y22)","v":0},{"$f":"E17*'B Nw en Renovatie parameters'!L22*(1+'B Nw en Renovatie parameters'!Z22)","v":0},{"$f":"F17*'B Nw en Renovatie parameters'!M22*(1+'B Nw en Renovatie parameters'!AA22)","v":0},{"$f":"G17*'B Nw en Renovatie parameters'!N22*(1+'B Nw en Renovatie parameters'!AB22)","v":0},{"$f":"H17*'B Nw en Renovatie parameters'!O22","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X17+'A Scope parameters'!C$4*Y17+'A Scope parameters'!C$5*Z17+'A Scope parameters'!C$6*AA17+'A Scope parameters'!C$3*(AB17+AC17)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B18=\"Infra\",27,'import DATA-CoP KSDW '!D15)","v":0},{"$f":"'import DATA-CoP KSDW '!E15","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O15)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q15/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S15/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U15/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V15/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A18=27,0,(SUM(D18:G18)+H18)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D18+'A Scope parameters'!C$4*E18+'A Scope parameters'!C$5*F18+'A Scope parameters'!C$6*G18+'A Scope parameters'!C$3*(H18+I18)","v":0},0,null,{"$f":"D18*'B Nw en Renovatie parameters'!D23","v":0},{"$f":"E18*'B Nw en Renovatie parameters'!E23","v":0},{"$f":"F18*'B Nw en Renovatie parameters'!F23","v":0},{"$f":"G18*'B Nw en Renovatie parameters'!G23","v":0},{"$f":"H18*'B Nw en Renovatie parameters'!H23","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N18+'A Scope parameters'!C$4*O18+'A Scope parameters'!C$5*P18+'A Scope parameters'!C$6*Q18+'A Scope parameters'!C$3*(R18+S18)","v":0},0,null,{"$f":"D18*'B Nw en Renovatie parameters'!K23*(1+'B Nw en Renovatie parameters'!Y23)","v":0},{"$f":"E18*'B Nw en Renovatie parameters'!L23*(1+'B Nw en Renovatie parameters'!Z23)","v":0},{"$f":"F18*'B Nw en Renovatie parameters'!M23*(1+'B Nw en Renovatie parameters'!AA23)","v":0},{"$f":"G18*'B Nw en Renovatie parameters'!N23*(1+'B Nw en Renovatie parameters'!AB23)","v":0},{"$f":"H18*'B Nw en Renovatie parameters'!O23","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X18+'A Scope parameters'!C$4*Y18+'A Scope parameters'!C$5*Z18+'A Scope parameters'!C$6*AA18+'A Scope parameters'!C$3*(AB18+AC18)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B19=\"Infra\",27,'import DATA-CoP KSDW '!D16)","v":0},{"$f":"'import DATA-CoP KSDW '!E16","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O16)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q16/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S16/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U16/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V16/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A19=27,0,(SUM(D19:G19)+H19)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D19+'A Scope parameters'!C$4*E19+'A Scope parameters'!C$5*F19+'A Scope parameters'!C$6*G19+'A Scope parameters'!C$3*(H19+I19)","v":0},0,null,{"$f":"D19*'B Nw en Renovatie parameters'!D24","v":0},{"$f":"E19*'B Nw en Renovatie parameters'!E24","v":0},{"$f":"F19*'B Nw en Renovatie parameters'!F24","v":0},{"$f":"G19*'B Nw en Renovatie parameters'!G24","v":0},{"$f":"H19*'B Nw en Renovatie parameters'!H24","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N19+'A Scope parameters'!C$4*O19+'A Scope parameters'!C$5*P19+'A Scope parameters'!C$6*Q19+'A Scope parameters'!C$3*(R19+S19)","v":0},0,null,{"$f":"D19*'B Nw en Renovatie parameters'!K24*(1+'B Nw en Renovatie parameters'!Y24)","v":0},{"$f":"E19*'B Nw en Renovatie parameters'!L24*(1+'B Nw en Renovatie parameters'!Z24)","v":0},{"$f":"F19*'B Nw en Renovatie parameters'!M24*(1+'B Nw en Renovatie parameters'!AA24)","v":0},{"$f":"G19*'B Nw en Renovatie parameters'!N24*(1+'B Nw en Renovatie parameters'!AB24)","v":0},{"$f":"H19*'B Nw en Renovatie parameters'!O24","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X19+'A Scope parameters'!C$4*Y19+'A Scope parameters'!C$5*Z19+'A Scope parameters'!C$6*AA19+'A Scope parameters'!C$3*(AB19+AC19)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B20=\"Infra\",27,'import DATA-CoP KSDW '!D17)","v":0},{"$f":"'import DATA-CoP KSDW '!E17","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O17)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q17/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S17/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U17/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V17/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A20=27,0,(SUM(D20:G20)+H20)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D20+'A Scope parameters'!C$4*E20+'A Scope parameters'!C$5*F20+'A Scope parameters'!C$6*G20+'A Scope parameters'!C$3*(H20+I20)","v":0},0,null,{"$f":"D20*'B Nw en Renovatie parameters'!D25","v":0},{"$f":"E20*'B Nw en Renovatie parameters'!E25","v":0},{"$f":"F20*'B Nw en Renovatie parameters'!F25","v":0},{"$f":"G20*'B Nw en Renovatie parameters'!G25","v":0},{"$f":"H20*'B Nw en Renovatie parameters'!H25","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N20+'A Scope parameters'!C$4*O20+'A Scope parameters'!C$5*P20+'A Scope parameters'!C$6*Q20+'A Scope parameters'!C$3*(R20+S20)","v":0},0,null,{"$f":"D20*'B Nw en Renovatie parameters'!K25*(1+'B Nw en Renovatie parameters'!Y25)","v":0},{"$f":"E20*'B Nw en Renovatie parameters'!L25*(1+'B Nw en Renovatie parameters'!Z25)","v":0},{"$f":"F20*'B Nw en Renovatie parameters'!M25*(1+'B Nw en Renovatie parameters'!AA25)","v":0},{"$f":"G20*'B Nw en Renovatie parameters'!N25*(1+'B Nw en Renovatie parameters'!AB25)","v":0},{"$f":"H20*'B Nw en Renovatie parameters'!O25","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X20+'A Scope parameters'!C$4*Y20+'A Scope parameters'!C$5*Z20+'A Scope parameters'!C$6*AA20+'A Scope parameters'!C$3*(AB20+AC20)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B21=\"Infra\",27,'import DATA-CoP KSDW '!D18)","v":0},{"$f":"'import DATA-CoP KSDW '!E18","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O18)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q18/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S18/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U18/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V18/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A21=27,0,(SUM(D21:G21)+H21)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D21+'A Scope parameters'!C$4*E21+'A Scope parameters'!C$5*F21+'A Scope parameters'!C$6*G21+'A Scope parameters'!C$3*(H21+I21)","v":0},0,null,{"$f":"D21*'B Nw en Renovatie parameters'!D26","v":0},{"$f":"E21*'B Nw en Renovatie parameters'!E26","v":0},{"$f":"F21*'B Nw en Renovatie parameters'!F26","v":0},{"$f":"G21*'B Nw en Renovatie parameters'!G26","v":0},{"$f":"H21*'B Nw en Renovatie parameters'!H26","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N21+'A Scope parameters'!C$4*O21+'A Scope parameters'!C$5*P21+'A Scope parameters'!C$6*Q21+'A Scope parameters'!C$3*(R21+S21)","v":0},0,null,{"$f":"D21*'B Nw en Renovatie parameters'!K26*(1+'B Nw en Renovatie parameters'!Y26)","v":0},{"$f":"E21*'B Nw en Renovatie parameters'!L26*(1+'B Nw en Renovatie parameters'!Z26)","v":0},{"$f":"F21*'B Nw en Renovatie parameters'!M26*(1+'B Nw en Renovatie parameters'!AA26)","v":0},{"$f":"G21*'B Nw en Renovatie parameters'!N26*(1+'B Nw en Renovatie parameters'!AB26)","v":0},{"$f":"H21*'B Nw en Renovatie parameters'!O26","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X21+'A Scope parameters'!C$4*Y21+'A Scope parameters'!C$5*Z21+'A Scope parameters'!C$6*AA21+'A Scope parameters'!C$3*(AB21+AC21)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B22=\"Infra\",27,'import DATA-CoP KSDW '!D19)","v":0},{"$f":"'import DATA-CoP KSDW '!E19","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O19)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q19/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S19/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U19/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V19/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A22=27,0,(SUM(D22:G22)+H22)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D22+'A Scope parameters'!C$4*E22+'A Scope parameters'!C$5*F22+'A Scope parameters'!C$6*G22+'A Scope parameters'!C$3*(H22+I22)","v":0},0,null,{"$f":"D22*'B Nw en Renovatie parameters'!D27","v":0},{"$f":"E22*'B Nw en Renovatie parameters'!E27","v":0},{"$f":"F22*'B Nw en Renovatie parameters'!F27","v":0},{"$f":"G22*'B Nw en Renovatie parameters'!G27","v":0},{"$f":"H22*'B Nw en Renovatie parameters'!H27","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N22+'A Scope parameters'!C$4*O22+'A Scope parameters'!C$5*P22+'A Scope parameters'!C$6*Q22+'A Scope parameters'!C$3*(R22+S22)","v":0},0,null,{"$f":"D22*'B Nw en Renovatie parameters'!K27*(1+'B Nw en Renovatie parameters'!Y27)","v":0},{"$f":"E22*'B Nw en Renovatie parameters'!L27*(1+'B Nw en Renovatie parameters'!Z27)","v":0},{"$f":"F22*'B Nw en Renovatie parameters'!M27*(1+'B Nw en Renovatie parameters'!AA27)","v":0},{"$f":"G22*'B Nw en Renovatie parameters'!N27*(1+'B Nw en Renovatie parameters'!AB27)","v":0},{"$f":"H22*'B Nw en Renovatie parameters'!O27","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X22+'A Scope parameters'!C$4*Y22+'A Scope parameters'!C$5*Z22+'A Scope parameters'!C$6*AA22+'A Scope parameters'!C$3*(AB22+AC22)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B23=\"Infra\",27,'import DATA-CoP KSDW '!D20)","v":0},{"$f":"'import DATA-CoP KSDW '!E20","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O20)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q20/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S20/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U20/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V20/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A23=27,0,(SUM(D23:G23)+H23)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D23+'A Scope parameters'!C$4*E23+'A Scope parameters'!C$5*F23+'A Scope parameters'!C$6*G23+'A Scope parameters'!C$3*(H23+I23)","v":0},0,null,{"$f":"D23*'B Nw en Renovatie parameters'!D28","v":0},{"$f":"E23*'B Nw en Renovatie parameters'!E28","v":0},{"$f":"F23*'B Nw en Renovatie parameters'!F28","v":0},{"$f":"G23*'B Nw en Renovatie parameters'!G28","v":0},{"$f":"H23*'B Nw en Renovatie parameters'!H28","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N23+'A Scope parameters'!C$4*O23+'A Scope parameters'!C$5*P23+'A Scope parameters'!C$6*Q23+'A Scope parameters'!C$3*(R23+S23)","v":0},0,null,{"$f":"D23*'B Nw en Renovatie parameters'!K28*(1+'B Nw en Renovatie parameters'!Y28)","v":0},{"$f":"E23*'B Nw en Renovatie parameters'!L28*(1+'B Nw en Renovatie parameters'!Z28)","v":0},{"$f":"F23*'B Nw en Renovatie parameters'!M28*(1+'B Nw en Renovatie parameters'!AA28)","v":0},{"$f":"G23*'B Nw en Renovatie parameters'!N28*(1+'B Nw en Renovatie parameters'!AB28)","v":0},{"$f":"H23*'B Nw en Renovatie parameters'!O28","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X23+'A Scope parameters'!C$4*Y23+'A Scope parameters'!C$5*Z23+'A Scope parameters'!C$6*AA23+'A Scope parameters'!C$3*(AB23+AC23)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B24=\"Infra\",27,'import DATA-CoP KSDW '!D21)","v":0},{"$f":"'import DATA-CoP KSDW '!E21","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O21)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q21/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S21/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U21/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V21/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A24=27,0,(SUM(D24:G24)+H24)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D24+'A Scope parameters'!C$4*E24+'A Scope parameters'!C$5*F24+'A Scope parameters'!C$6*G24+'A Scope parameters'!C$3*(H24+I24)","v":0},0,null,{"$f":"D24*'B Nw en Renovatie parameters'!D29","v":0},{"$f":"E24*'B Nw en Renovatie parameters'!E29","v":0},{"$f":"F24*'B Nw en Renovatie parameters'!F29","v":0},{"$f":"G24*'B Nw en Renovatie parameters'!G29","v":0},{"$f":"H24*'B Nw en Renovatie parameters'!H29","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N24+'A Scope parameters'!C$4*O24+'A Scope parameters'!C$5*P24+'A Scope parameters'!C$6*Q24+'A Scope parameters'!C$3*(R24+S24)","v":0},0,null,{"$f":"D24*'B Nw en Renovatie parameters'!K29*(1+'B Nw en Renovatie parameters'!Y29)","v":0},{"$f":"E24*'B Nw en Renovatie parameters'!L29*(1+'B Nw en Renovatie parameters'!Z29)","v":0},{"$f":"F24*'B Nw en Renovatie parameters'!M29*(1+'B Nw en Renovatie parameters'!AA29)","v":0},{"$f":"G24*'B Nw en Renovatie parameters'!N29*(1+'B Nw en Renovatie parameters'!AB29)","v":0},{"$f":"H24*'B Nw en Renovatie parameters'!O29","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X24+'A Scope parameters'!C$4*Y24+'A Scope parameters'!C$5*Z24+'A Scope parameters'!C$6*AA24+'A Scope parameters'!C$3*(AB24+AC24)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B25=\"Infra\",27,'import DATA-CoP KSDW '!D22)","v":0},{"$f":"'import DATA-CoP KSDW '!E22","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O22)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q22/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S22/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U22/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V22/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A25=27,0,(SUM(D25:G25)+H25)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D25+'A Scope parameters'!C$4*E25+'A Scope parameters'!C$5*F25+'A Scope parameters'!C$6*G25+'A Scope parameters'!C$3*(H25+I25)","v":0},0,null,{"$f":"D25*'B Nw en Renovatie parameters'!D30","v":0},{"$f":"E25*'B Nw en Renovatie parameters'!E30","v":0},{"$f":"F25*'B Nw en Renovatie parameters'!F30","v":0},{"$f":"G25*'B Nw en Renovatie parameters'!G30","v":0},{"$f":"H25*'B Nw en Renovatie parameters'!H30","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N25+'A Scope parameters'!C$4*O25+'A Scope parameters'!C$5*P25+'A Scope parameters'!C$6*Q25+'A Scope parameters'!C$3*(R25+S25)","v":0},0,null,{"$f":"D25*'B Nw en Renovatie parameters'!K30*(1+'B Nw en Renovatie parameters'!Y30)","v":0},{"$f":"E25*'B Nw en Renovatie parameters'!L30*(1+'B Nw en Renovatie parameters'!Z30)","v":0},{"$f":"F25*'B Nw en Renovatie parameters'!M30*(1+'B Nw en Renovatie parameters'!AA30)","v":0},{"$f":"G25*'B Nw en Renovatie parameters'!N30*(1+'B Nw en Renovatie parameters'!AB30)","v":0},{"$f":"H25*'B Nw en Renovatie parameters'!O30","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X25+'A Scope parameters'!C$4*Y25+'A Scope parameters'!C$5*Z25+'A Scope parameters'!C$6*AA25+'A Scope parameters'!C$3*(AB25+AC25)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B26=\"Infra\",27,'import DATA-CoP KSDW '!D23)","v":0},{"$f":"'import DATA-CoP KSDW '!E23","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O23)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q23/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S23/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U23/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V23/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A26=27,0,(SUM(D26:G26)+H26)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D26+'A Scope parameters'!C$4*E26+'A Scope parameters'!C$5*F26+'A Scope parameters'!C$6*G26+'A Scope parameters'!C$3*(H26+I26)","v":0},0,null,{"$f":"D26*'B Nw en Renovatie parameters'!D31","v":0},{"$f":"E26*'B Nw en Renovatie parameters'!E31","v":0},{"$f":"F26*'B Nw en Renovatie parameters'!F31","v":0},{"$f":"G26*'B Nw en Renovatie parameters'!G31","v":0},{"$f":"H26*'B Nw en Renovatie parameters'!H31","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N26+'A Scope parameters'!C$4*O26+'A Scope parameters'!C$5*P26+'A Scope parameters'!C$6*Q26+'A Scope parameters'!C$3*(R26+S26)","v":0},0,null,{"$f":"D26*'B Nw en Renovatie parameters'!K31*(1+'B Nw en Renovatie parameters'!Y31)","v":0},{"$f":"E26*'B Nw en Renovatie parameters'!L31*(1+'B Nw en Renovatie parameters'!Z31)","v":0},{"$f":"F26*'B Nw en Renovatie parameters'!M31*(1+'B Nw en Renovatie parameters'!AA31)","v":0},{"$f":"G26*'B Nw en Renovatie parameters'!N31*(1+'B Nw en Renovatie parameters'!AB31)","v":0},{"$f":"H26*'B Nw en Renovatie parameters'!O31","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X26+'A Scope parameters'!C$4*Y26+'A Scope parameters'!C$5*Z26+'A Scope parameters'!C$6*AA26+'A Scope parameters'!C$3*(AB26+AC26)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B27=\"Infra\",27,'import DATA-CoP KSDW '!D24)","v":0},{"$f":"'import DATA-CoP KSDW '!E24","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O24)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q24/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S24/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U24/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V24/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A27=27,0,(SUM(D27:G27)+H27)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D27+'A Scope parameters'!C$4*E27+'A Scope parameters'!C$5*F27+'A Scope parameters'!C$6*G27+'A Scope parameters'!C$3*(H27+I27)","v":0},0,null,{"$f":"D27*'B Nw en Renovatie parameters'!D32","v":0},{"$f":"E27*'B Nw en Renovatie parameters'!E32","v":0},{"$f":"F27*'B Nw en Renovatie parameters'!F32","v":0},{"$f":"G27*'B Nw en Renovatie parameters'!G32","v":0},{"$f":"H27*'B Nw en Renovatie parameters'!H32","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N27+'A Scope parameters'!C$4*O27+'A Scope parameters'!C$5*P27+'A Scope parameters'!C$6*Q27+'A Scope parameters'!C$3*(R27+S27)","v":0},0,null,{"$f":"D27*'B Nw en Renovatie parameters'!K32*(1+'B Nw en Renovatie parameters'!Y32)","v":0},{"$f":"E27*'B Nw en Renovatie parameters'!L32*(1+'B Nw en Renovatie parameters'!Z32)","v":0},{"$f":"F27*'B Nw en Renovatie parameters'!M32*(1+'B Nw en Renovatie parameters'!AA32)","v":0},{"$f":"G27*'B Nw en Renovatie parameters'!N32*(1+'B Nw en Renovatie parameters'!AB32)","v":0},{"$f":"H27*'B Nw en Renovatie parameters'!O32","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X27+'A Scope parameters'!C$4*Y27+'A Scope parameters'!C$5*Z27+'A Scope parameters'!C$6*AA27+'A Scope parameters'!C$3*(AB27+AC27)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B28=\"Infra\",27,'import DATA-CoP KSDW '!D25)","v":0},{"$f":"'import DATA-CoP KSDW '!E25","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O25)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q25/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S25/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U25/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V25/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A28=27,0,(SUM(D28:G28)+H28)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D28+'A Scope parameters'!C$4*E28+'A Scope parameters'!C$5*F28+'A Scope parameters'!C$6*G28+'A Scope parameters'!C$3*(H28+I28)","v":0},0,null,{"$f":"D28*'B Nw en Renovatie parameters'!D33","v":0},{"$f":"E28*'B Nw en Renovatie parameters'!E33","v":0},{"$f":"F28*'B Nw en Renovatie parameters'!F33","v":0},{"$f":"G28*'B Nw en Renovatie parameters'!G33","v":0},{"$f":"H28*'B Nw en Renovatie parameters'!H33","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N28+'A Scope parameters'!C$4*O28+'A Scope parameters'!C$5*P28+'A Scope parameters'!C$6*Q28+'A Scope parameters'!C$3*(R28+S28)","v":0},0,null,{"$f":"D28*'B Nw en Renovatie parameters'!K33*(1+'B Nw en Renovatie parameters'!Y33)","v":0},{"$f":"E28*'B Nw en Renovatie parameters'!L33*(1+'B Nw en Renovatie parameters'!Z33)","v":0},{"$f":"F28*'B Nw en Renovatie parameters'!M33*(1+'B Nw en Renovatie parameters'!AA33)","v":0},{"$f":"G28*'B Nw en Renovatie parameters'!N33*(1+'B Nw en Renovatie parameters'!AB33)","v":0},{"$f":"H28*'B Nw en Renovatie parameters'!O33","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X28+'A Scope parameters'!C$4*Y28+'A Scope parameters'!C$5*Z28+'A Scope parameters'!C$6*AA28+'A Scope parameters'!C$3*(AB28+AC28)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[{"$f":"IF(B29=\"Infra\",27,'import DATA-CoP KSDW '!D26)","v":0},{"$f":"'import DATA-CoP KSDW '!E20","v":0},null,{"$f":"('import DATA-CoP KSDW '!$O26)/(1+'A Scope parameters'!X$3)","v":0},{"$f":"'import DATA-CoP KSDW '!Q26/(1+'A Scope parameters'!X$4)","v":0},{"$f":"'import DATA-CoP KSDW '!S26/(1+'A Scope parameters'!X$5)","v":0},{"$f":"'import DATA-CoP KSDW '!U26/(1+'A Scope parameters'!X$6)","v":0},{"$f":"'import DATA-CoP KSDW '!V26/(1+'A Scope parameters'!X$3)","v":0},{"$f":"IF(A29=27,0,(SUM(D29:G29)+H29)*(('import DATA-CoP KSDW '!W$5+'import DATA-CoP KSDW '!X$5+'import DATA-CoP KSDW '!Y$5)/100))","v":0},0,{"$f":"'A Scope parameters'!C$3*D29+'A Scope parameters'!C$4*E29+'A Scope parameters'!C$5*F29+'A Scope parameters'!C$6*G29+'A Scope parameters'!C$3*(H29+I29)","v":0},0,null,{"$f":"D29*'B Nw en Renovatie parameters'!D34","v":0},{"$f":"E29*'B Nw en Renovatie parameters'!E34","v":0},{"$f":"F29*'B Nw en Renovatie parameters'!F34","v":0},{"$f":"G29*'B Nw en Renovatie parameters'!G34","v":0},{"$f":"H29*'B Nw en Renovatie parameters'!H34","v":0},0,0,{"$f":"'A Scope parameters'!C$3*N29+'A Scope parameters'!C$4*O29+'A Scope parameters'!C$5*P29+'A Scope parameters'!C$6*Q29+'A Scope parameters'!C$3*(R29+S29)","v":0},0,null,{"$f":"D29*'B Nw en Renovatie parameters'!K34*(1+'B Nw en Renovatie parameters'!Y34)","v":0},{"$f":"E29*'B Nw en Renovatie parameters'!L34*(1+'B Nw en Renovatie parameters'!Z34)","v":0},{"$f":"F29*'B Nw en Renovatie parameters'!M34*(1+'B Nw en Renovatie parameters'!AA34)","v":0},{"$f":"G29*'B Nw en Renovatie parameters'!N34*(1+'B Nw en Renovatie parameters'!AB34)","v":0},{"$f":"H29*'B Nw en Renovatie parameters'!O34","v":0},0,0,{"$f":"'A Scope parameters'!C$3*X29+'A Scope parameters'!C$4*Y29+'A Scope parameters'!C$5*Z29+'A Scope parameters'!C$6*AA29+'A Scope parameters'!C$3*(AB29+AC29)","v":0},0,null,0,0,0,0,0,0,0,0,0]
[null,"Totale bouwkosten",null,{"$f":"SUM(D9:D29)","v":0},0,0,0,{"$f":"SUM(H9:H29)","v":0},{"$f":"SUM(I9:I29)","v":0},{"$f":"SUM(J9:J29)","v":0},0,{"$f":"J30+K30","v":0},null,{"$f":"SUM(N9:N29)","v":0},0,0,0,{"$f":"SUM(R9:R29)","v":0},0,{"$f":"SUM(T9:T29)","v":0},{"$f":"SUM(U9:U29)","v":0},{"$f":"SUM(V9:V29)","v":0},null,{"$f":"SUM(X9:X29)","v":0},{"$f":"SUM(Y9:Y29)","v":0},0,0,{"$f":"SUM(AB9:AB29)","v":0},0,0,0,{"$f":"AD30+AE30","v":0},null,{"$f":"SUM(AH9:AH29)","v":0},{"$f":"SUM(AI9:AI29)","v":0},0,0,{"$f":"SUM(AL9:AL29)","v":0},0,0,0,{"$f":"AN30+AO30","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,"check",{"$f":"SUM(L9:L29)","v":0},null,null,null,null,null,null,null,null,"check",{"$f":"SUM(V9:V29)","v":0},null,null,null,null,null,null,null,null,"check",{"$f":"SUM(AF9:AF29)","v":0},null,null,null,null,null,null,null,null,"check",{"$f":"SUM(AP9:AP29)","v":0}]
[]
[null,null,null,"Toeslagen nieuwbouw BK",null,null,null,null,null,"Totaal","Indirecte BK","Totaal  toeslag ( per categorie)",null,"Toeslagen nieuwbouw BK",null,null,null,null,null,"Totaal","Indirecte BK","Totaal  toeslag ( per categorie)",null,"Toeslagen met renovatie BK",null,null,null,null,null,"Totaal","Indirecte BK","Totaal  toeslag ( per categorie)",null,"Toeslagen totaal op BK",null,null,null,null,null,"Totaal","Indirecte BK","Totaal  toeslag ( per categorie)"]
[null,null,null,"CTB","WTB","E & I","PA",null,null,"Directe BK","Indirecte BK","Bouwkosten",null,"CTB","WTB","E & I","PA",null,null,"Directe BK","Indirecte BK","Bouwkosten",null,"CTB","WTB","E & I","PA",null,null,"Directe BK","Indirecte BK","Bouwkosten",null,"CTB","WTB","E & I","PA",null,null,"Directe BK","Indirecte BK","Bouwkosten"]
[null,{"$f":"'A Scope parameters'!B20","v":"Duurzame materialen / circulair bouwen"},null,{"$f":"$D$30*'A Scope parameters'!H20","v":0},{"$f":"$E$30*'A Scope parameters'!I20","v":0},{"$f":"$F$30*'A Scope parameters'!J20","v":0},{"$f":"$G$30*'A Scope parameters'!K20","v":0},null,null,{"$f":"SUM(D36:I36)","v":0},{"$f":"'A Scope parameters'!C$3*J36","v":0},{"$f":"J36+K36","v":0},null,{"$f":"$N$30*'A Scope parameters'!H20","v":0},{"$f":"$O$30*'A Scope parameters'!I20","v":0},{"$f":"$P$30*'A Scope parameters'!J20","v":0},{"$f":"$Q$30*'A Scope parameters'!K20","v":0},null,null,{"$f":"SUM(N36:S36)","v":0},{"$f":"'A Scope parameters'!C$3*T36","v":0},{"$f":"T36+U36","v":0},null,{"$f":"$X$30*'A Scope parameters'!H20","v":0},{"$f":"$Y$30*'A Scope parameters'!I20","v":0},{"$f":"$Z$30*'A Scope parameters'!J20","v":0},{"$f":"$AA$30*'A Scope parameters'!K20","v":0},null,null,{"$f":"SUM(X36:AC36)","v":0},{"$f":"'A Scope parameters'!C$3*SUM(X36:AC36)","v":0},{"$f":"AD36+AE36","v":0},null,{"$f":"N36+X36","v":0},0,0,0,null,null,{"$f":"T36+AD36","v":0},0,0]
[null,{"$f":"'A Scope parameters'!B21","v":"Elektrisch werken (emissieloos bouwen)"},null,{"$f":"$D$30*'A Scope parameters'!H21","v":0},{"$f":"$E$30*'A Scope parameters'!I21","v":0},{"$f":"$F$30*'A Scope parameters'!J21","v":0},{"$f":"$G$30*'A Scope parameters'!K21","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*J37","v":0},{"$f":"J37+K37","v":0},null,{"$f":"$N$30*'A Scope parameters'!H21","v":0},{"$f":"$O$30*'A Scope parameters'!I21","v":0},{"$f":"$P$30*'A Scope parameters'!J21","v":0},{"$f":"$Q$30*'A Scope parameters'!K21","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*T37","v":0},0,null,{"$f":"$X$30*'A Scope parameters'!H21","v":0},{"$f":"$Y$30*'A Scope parameters'!I21","v":0},{"$f":"$Z$30*'A Scope parameters'!J21","v":0},{"$f":"$AA$30*'A Scope parameters'!K21","v":0},null,null,{"$f":"SUM(X37:AC37)","v":0},{"$f":"'A Scope parameters'!C$3*SUM(X37:AC37)","v":0},{"$f":"AD37+AE37","v":0},null,0,0,0,0,null,null,0,0,0]
[null,{"$f":"'A Scope parameters'!B22","v":"Volledig onafhankelijke straten (keuzelijst)"},null,{"$f":"$D$30*'A Scope parameters'!H22","v":0},{"$f":"$E$30*'A Scope parameters'!I22","v":0},{"$f":"$F$30*'A Scope parameters'!J22","v":0},{"$f":"$G$30*'A Scope parameters'!K22","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*J38","v":0},0,null,{"$f":"$N$30*'A Scope parameters'!H22","v":0},{"$f":"$O$30*'A Scope parameters'!I22","v":0},{"$f":"$P$30*'A Scope parameters'!J22","v":0},{"$f":"$Q$30*'A Scope parameters'!K22","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*T38","v":0},0,null,{"$f":"$X$30*'A Scope parameters'!H22","v":0},{"$f":"$Y$30*'A Scope parameters'!I22","v":0},{"$f":"$Z$30*'A Scope parameters'!J22","v":0},{"$f":"$AA$30*'A Scope parameters'!K22","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*SUM(X38:AC38)","v":0},0,null,0,0,0,0,null,null,0,0,0]
[null,{"$f":"'A Scope parameters'!B23","v":"Extra kosten standaardisatie"},null,{"$f":"$D$30*'A Scope parameters'!H23","v":0},{"$f":"$E$30*'A Scope parameters'!I23","v":0},{"$f":"$F$30*'A Scope parameters'!J23","v":0},{"$f":"$G$30*'A Scope parameters'!K23","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*J39","v":0},0,null,{"$f":"$N$30*'A Scope parameters'!H23","v":0},{"$f":"$O$30*'A Scope parameters'!I23","v":0},{"$f":"$P$30*'A Scope parameters'!J23","v":0},{"$f":"$Q$30*'A Scope parameters'!K23","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*T39","v":0},0,null,{"$f":"$X$30*'A Scope parameters'!H23","v":0},{"$f":"$Y$30*'A Scope parameters'!I23","v":0},{"$f":"$Z$30*'A Scope parameters'!J23","v":0},{"$f":"$AA$30*'A Scope parameters'!K23","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*SUM(X39:AC39)","v":0},0,null,0,0,0,0,null,null,0,0,0]
[null,{"$f":"'A Scope parameters'!B24","v":"Extra kosten langere BOUWTIJD  t.o.v. normaal"},null,{"$f":"$D$30*'A Scope parameters'!H24","v":0},{"$f":"$E$30*'A Scope parameters'!I24","v":0},{"$f":"$F$30*'A Scope parameters'!J24","v":0},{"$f":"$G$30*'A Scope parameters'!K24","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*J40","v":0},0,null,{"$f":"$N$30*'A Scope parameters'!H24","v":0},{"$f":"$O$30*'A Scope parameters'!I24","v":0},{"$f":"$P$30*'A Scope parameters'!J24","v":0},{"$f":"$Q$30*'A Scope parameters'!K24","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*T40","v":0},0,null,{"$f":"$X$30*'A Scope parameters'!H24","v":0},{"$f":"$Y$30*'A Scope parameters'!I24","v":0},{"$f":"$Z$30*'A Scope parameters'!J24","v":0},{"$f":"$AA$30*'A Scope parameters'!K24","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*SUM(X40:AC40)","v":0},0,null,0,0,0,0,null,null,0,0,0]
[null,{"$f":"'A Scope parameters'!B26","v":"Object overstijgende Risicoreservering scope change"},null,{"$f":"$D$30*'A Scope parameters'!H26","v":0},{"$f":"$E$30*'A Scope parameters'!I26","v":0},{"$f":"$F$30*'A Scope parameters'!J26","v":0},{"$f":"$G$30*'A Scope parameters'!K26","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*J41","v":0},{"$f":"J41+K41","v":0},null,{"$f":"$N$30*'A Scope parameters'!H26","v":0},{"$f":"$O$30*'A Scope parameters'!I26","v":0},{"$f":"$P$30*'A Scope parameters'!J26","v":0},{"$f":"$Q$30*'A Scope parameters'!K26","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*T41","v":0},{"$f":"T41+U41","v":0},null,{"$f":"$X$30*'A Scope parameters'!H26","v":0},{"$f":"$Y$30*'A Scope parameters'!I26","v":0},{"$f":"$Z$30*'A Scope parameters'!J26","v":0},{"$f":"$AA$30*'A Scope parameters'!K26","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*SUM(X41:AC41)","v":0},{"$f":"AD41+AE41","v":0},null,0,0,0,0,null,null,0,0,0]
[null,{"$f":"'A Scope parameters'!B27","v":"Nader te detailleren"},null,{"$f":"$D$30*'A Scope parameters'!H27","v":0},{"$f":"$E$30*'A Scope parameters'!I27","v":0},{"$f":"$F$30*'A Scope parameters'!J27","v":0},{"$f":"$G$30*'A Scope parameters'!K27","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*J42","v":0},{"$f":"J42+K42","v":0},null,{"$f":"$N$30*'A Scope parameters'!H27","v":0},{"$f":"$O$30*'A Scope parameters'!I27","v":0},{"$f":"$P$30*'A Scope parameters'!J27","v":0},{"$f":"$Q$30*'A Scope parameters'!K27","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*T42","v":0},{"$f":"T42+U42","v":0},null,{"$f":"$X$30*'A Scope parameters'!H27","v":0},{"$f":"$Y$30*'A Scope parameters'!I27","v":0},{"$f":"$Z$30*'A Scope parameters'!J27","v":0},{"$f":"$AA$30*'A Scope parameters'!K27","v":0},null,null,0,{"$f":"'A Scope parameters'!C$3*SUM(X42:AC42)","v":0},{"$f":"AD42+AE42","v":0},null,0,0,0,0,null,null,0,0,0]
[null,null,null,{"$f":"SUM(D36:D42)","v":0},{"$f":"SUM(E36:E42)","v":0},0,0,0,0,0,0,{"$f":"SUM(L36:L42)","v":0},null,{"$f":"SUM(N36:N42)","v":0},{"$f":"SUM(O36:O42)","v":0},{"$f":"SUM(P36:P42)","v":0},{"$f":"SUM(Q36:Q42)","v":0},null,{"$f":"SUM(S36:S42)","v":0},{"$f":"SUM(T36:T42)","v":0},{"$f":"SUM(U36:U42)","v":0},{"$f":"SUM(V36:V42)","v":0},null,{"$f":"SUM(X36:X42)","v":0},{"$f":"SUM(Y36:Y42)","v":0},{"$f":"SUM(Z36:Z42)","v":0},{"$f":"SUM(AA36:AA42)","v":0},null,{"$f":"SUM(AC36:AC42)","v":0},{"$f":"SUM(AD36:AD42)","v":0},{"$f":"SUM(AE36:AE42)","v":0},{"$f":"SUM(AF36:AF42)","v":0},null,{"$f":"SUM(AH36:AH42)","v":0},{"$f":"SUM(AI36:AI42)","v":0},{"$f":"SUM(AJ36:AJ42)","v":0},{"$f":"SUM(AK36:AK42)","v":0},null,{"$f":"SUM(AM36:AM42)","v":0},{"$f":"SUM(AN36:AN42)","v":0},{"$f":"SUM(AO36:AO42)","v":0},{"$f":"SUM(AP36:AP42)","v":0}]
[]
[null,null,null,null,null,"Toeslagen BK",{"$f":"SUM(D43:G43)","v":0},null,null,null,null,null,null,null,null,"Toeslagen BK",{"$f":"SUM(N43:Q43)","v":0},null,null,null,null,null,null,null,null,"Toeslagen BK",{"$f":"SUM(X43:AA43)","v":0},null,null,null,null,null,null,null,null,"Toeslagen BK",{"$f":"SUM(AH43:AK43)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaal bouwkosten",null,null,null,null,null,null,null,null,null,"Totaal bouwkosten",null,null,null,null,null,null,null,null,null,"Totaal bouwkosten"]
[null,null,null,"Totaal bouwkosten",null,null,null,null,null,null,null,{"$f":"L30+L43","v":0},null,{"$f":"N30+N43","v":0},0,0,0,0,0,0,0,0,null,{"$f":"X30+X43","v":0},0,0,0,0,0,0,0,0,null,{"$f":"AH30+AH43","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"Vastgoedkosten",null,"Totaal vastgoedkosten",null,null,null,null,null,null,null,{"$f":"'A Scope parameters'!C8","v":0},null,"Totaal vastgoedkosten",null,null,null,null,null,null,null,{"$f":"'A Scope parameters'!N8","v":0},null,"Totaal vastgoedkosten",null,null,null,null,null,null,null,{"$f":"'A Scope parameters'!U8","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'A Scope parameters'!C8","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Ingestelde waarde",null,null,null,null,null,null,null,null,null,"Ingestelde waarde",null,null,null,null,null,null,null,null,null,"Ingestelde waarde",null,null,null,null,null,null,null,null,null,"Ingestelde waarde"]
[null,{"$f":"$D56","v":"Engineeringskosten IB  (incl onderzoeken/adv)"},null,"Engineeringskosten IB  (incl onderzoeken/adv)",null,null,null,null,null,null,{"$f":"'A Scope parameters'!$C$11","v":0.2},{"$f":"L$47*K56","v":0},null,{"$f":"$D56","v":"Engineeringskosten IB  (incl onderzoeken/adv)"},null,null,null,null,null,null,{"$f":"'A Scope parameters'!$C$11","v":0.2},{"$f":"V$47*U56","v":0},null,{"$f":"$D56","v":"Engineeringskosten IB  (incl onderzoeken/adv)"},null,null,null,null,null,null,{"$f":"'A Scope parameters'!$C$11","v":0.2},{"$f":"AF$47*AE56","v":0},null,{"$f":"$D56","v":"Engineeringskosten IB  (incl onderzoeken/adv)"},null,null,null,null,null,null,{"$f":"'A Scope parameters'!$C$11","v":0.2},{"$f":"AP$47*AO56","v":0}]
[null,{"$f":"D57","v":"Engineeringskosten OG (interne uren)"},null,"Engineeringskosten OG (interne uren)",null,null,null,null,null,null,{"$f":"'A Scope parameters'!C12","v":0.1},{"$f":"L$47*K57","v":0},null,{"$f":"$D$57","v":"Engineeringskosten OG (interne uren)"},null,null,null,null,null,null,{"$f":"'A Scope parameters'!C12","v":0.1},{"$f":"V$47*U57","v":0},null,"Totaal interne uren ",null,null,null,null,null,null,{"$f":"'A Scope parameters'!C12","v":0.1},{"$f":"AF$47*AE57","v":0},null,"Totaal interne uren ",null,null,null,null,null,null,{"$f":"'A Scope parameters'!C12","v":0.1},{"$f":"AP$47*AO57","v":0}]
[null,{"$f":"$D58","v":"Totaal Engineerinskosten (OG+IB)"},null,"Totaal Engineerinskosten (OG+IB)",null,null,null,null,null,null,null,{"$f":"SUM(L56:L57)","v":0},null,{"$f":"$D58","v":"Totaal Engineerinskosten (OG+IB)"},null,null,null,null,null,null,null,{"$f":"SUM(V56:V57)","v":0},null,{"$f":"$D58","v":"Totaal Engineerinskosten (OG+IB)"},null,null,null,null,null,null,null,{"$f":"SUM(AF56:AF57)","v":0},null,{"$f":"$D58","v":"Totaal Engineerinskosten (OG+IB)"},null,null,null,null,null,null,null,{"$f":"SUM(AP56:AP57)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K56:K57)","v":0.30000000000000004},null,null,null,null,null,null,null,null,null,{"$f":"SUM(U56:U57)","v":0.30000000000000004},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE56:AE57)","v":0.30000000000000004},null,null,null,null,null,null,null,null,null,{"$f":"SUM(AO56:AO57)","v":0.30000000000000004}]
[]
[]
[null,"Overige bijkomende kosten",null,"Overige bijkomende kosten",null,null,null,null,null,null,null,{"$f":"'A Scope parameters'!$C$14*'E Rekenblad'!L47","v":0},null,"Overige bijkomende kosten",null,null,null,null,null,null,null,{"$f":"'A Scope parameters'!$C$14*'E Rekenblad'!V47","v":0},null,"Overige bijkomende kosten",null,null,null,null,null,null,null,{"$f":"'A Scope parameters'!$C$14*'E Rekenblad'!AF47","v":0},null,"Overige bijkomende kosten",null,null,null,null,null,null,null,{"$f":"'A Scope parameters'!$C$14*'E Rekenblad'!AP47","v":0}]
[]
[]
[null,"Object overstijgende Risicoreservering",null,null,null,null,null,null,null,null,null,{"$f":"(L47+L51+L58+L62)*'A Scope parameters'!$C$25","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(V47+V51+V58+V62)*'A Scope parameters'!$C$25","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(AF47+AF51+AF58+AF62)*'A Scope parameters'!$C$25","v":0},null,null,null,null,null,null,null,null,null,{"$f":"V65+AF65","v":0}]
[]
[]
[null,{"$f":"$D68","v":"Totaal investeringskosten"},null,"Totaal investeringskosten",null,null,null,null,null,null,null,{"$f":"L47+L51+L58+L62+L65","v":0},null,{"$f":"$D68","v":"Totaal investeringskosten"},null,null,null,null,null,null,null,{"$f":"V47+V51+V58+V62+V65","v":0},null,{"$f":"$D68","v":"Totaal investeringskosten"},null,null,null,null,null,null,null,{"$f":"AF47+AF51+AF58+AF62+AF65","v":0},null,{"$f":"$D68","v":"Totaal investeringskosten"},null,null,null,null,null,null,null,{"$f":"AP47+AP51+AP58+AP62+AP65","v":0}]
[]
[]
[]
[]
[null,"Sloopkosten",null,"Totaal sloopkosten",null,null,null,null,null,null,null,{"$f":"'A Scope parameters'!C2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaal sloopkosten",null,null,null,null,null,null,null,{"$f":"'A Scope parameters'!$C$2","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["mjwmbakker"]

{"sheet":"Bijlage Begrippen SSK","index":8,"n_rows":83,"n_cols":10,"rows_kept":83,"cut":false,"hidden":false,"merged":[]}
["SSK Methodiek in a nutshell"]
["Voorbeeld  ","Kostenopbouw nieuwbouw van een garage"]
["Van: ","Marcel Bakker RHDHV"]
["Datum: ","2025-04-09"]
[]
["ALGEMEEN:","Hieronder de onderverdeling van de kosten op een objectblad ( in dit geval per discipline maar kan bv ook geografisch)"]
[null,"In het summary blad SSK worden de totalen van deze objectbladen overzichtelijke weergegeven. "]
[null,"De kleuren in de onderstaande tabel corresponderen met de kleuren in de figuur rechts (\"SSK methodiek in a nutshell - OPBOUW BOUWKOSTEN\")"]
["1) BOUWKOSTEN"]
["A"]
[null,"BDBK=","Benoemde Direkte bouwkosten",null,null,null,"Prijzen"]
[null,null,null,null,"Hoeveelheid","eenheid","uren / materialen","Totalen"]
[]
["Benoemde directe bouwkosten",null,"INV-BK-Civ","Heipalen",null,null,null,1500]
[{"$f":"A14","v":"Benoemde directe bouwkosten"},null,"INV-BK-Civ","bekisting",null,null,null,2500]
[{"$f":"A15","v":"Benoemde directe bouwkosten"},null,"INV-BK-Civ","wapening",null,null,null,800]
["Benoemde directe bouwkosten",null,"INV-BK-Civ","beton",null,null,null,2000]
["Benoemde directe bouwkosten"]
["Benoemde directe bouwkosten",null,"INV-BK-Civ","Halfsteens muur",null,null,null,5000]
["Benoemde directe bouwkosten",null,"INV-BK-Civ","isolatie",null,null,null,1000]
["Benoemde directe bouwkosten",null,"INV-BK-Civ","Loopdeur",null,null,null,500]
["Benoemde directe bouwkosten",null,"INV-BK-Civ","gordingen",null,null,null,1000]
["Benoemde directe bouwkosten",null,"INV-BK-Civ","dakplaten geisoleerd",null,null,null,3000]
["Benoemde directe bouwkosten",null,"INV-BK-Civ","Bitumen",null,null,null,1500]
["Benoemde directe bouwkosten",null,"INV-BK-Civ","Zinkrand",null,null,null,400]
[]
[{"$f":"A14","v":"Benoemde directe bouwkosten"},null,"E&I","Electrakabels",null,null,null,600]
[{"$f":"A15","v":"Benoemde directe bouwkosten"},null,"E&I","Wandcontacdozen",null,null,null,200]
["Benoemde directe bouwkosten",null,"E&I","Aarding",null,null,null,150]
[]
[{"$f":"A14","v":"Benoemde directe bouwkosten"},null,"WTB","Automatische kanteldeur",null,null,null,3000]
[]
[]
["A","BDBK=","Benoemde Direkte bouwkosten",null,null,null,null,{"$f":"SUM(H13:H33)","v":23150}]
[]
["B","NTDBK=","Nader te detailleren bouwkosten",null,null,null,0.1,{"$f":"G36*H34","v":2315}]
[]
["C  (=A+B)","DBK=","Direkte bouwkosten (directe bouwkosten aannemer)",null,null,null,null,{"$f":"H34+H36","v":25465}]
[]
["D","BIBK=","Benoemde Indirekte bouwkosten (staartkosten aannemer)"]
["Benoemde Indirecte bouwkosten",null,"INV-IBK","Bouwkeet",null,null,null,1500]
["Benoemde Indirecte bouwkosten",null,{"$f":"C41","v":"INV-IBK"},"Overleg",null,null,null,500]
["Benoemde Indirecte bouwkosten",null,{"$f":"C42","v":"INV-IBK"},"Inkoop",null,null,null,600]
["Benoemde Indirecte bouwkosten",null,"INV-IBK","Begroten",null,null,null,150]
["Benoemde Indirecte bouwkosten",null,"INV-IBK","Administratie ",null,null,null,150]
["Benoemde Indirecte bouwkosten",null,{"$f":"C41","v":"INV-IBK"},"Toezicht",null,null,null,2000]
[null,null,"Benoemde Indirekte bouwkosten (staartkosten aannemer)",null,null,null,null,{"$f":"SUM(H41:H46)","v":4900}]
[]
["E (=C+D)","VBK=","Voorziene bouwkosten",null,null,null,null,{"$f":"H38+H47","v":30365}]
[]
["F","NBORB+BORB=","Niet benoemde en benoemde object risico reservering BK",null,null,null,0.1,{"$f":"G51*H49","v":3036.5}]
[]
["G (=E+F)","BK=","1) Totale bouwkosten",null,null,null,null,{"$f":"H49+H51","v":33401.5}]
[null,null,"(kosten aannemer)"]
[]
[]
[]
[]
[]
[null,null,"4 Hoofdgroepen in de SSK "]
[null,null,"Zelfde methode van kosten opbouw voor de volgende rubrieken"]
[]
[null,null,"1) Totale bouwkosten",null,null,null,null,{"$f":"H53","v":33401.5}]
[null,null,"2) VASTGOED KOSTEN",null,null,null,null,8000,"    2) ingeklapt"]
[null,null,"3) ENGINEERINGSKOSTEN ( normaal OG+IB)",null,null,null,null,700,"    3) ingeklapt"]
[null,null,"4) OVERIGE KOSTEN",null,null,null,null,300,"    4) ingeklapt"]
[]
[null,null,"SUBTOTAAL  INVESTERINGSKOSTEN",null,null,null,null,{"$f":"SUM(H63:H67)","v":42401.5}]
[]
[null,null,"OBJECT OVERSTIJGENDE RISICO'S",null,null,null,0.1,{"$f":"H68*G70","v":4240.1500000000005},"(vallen niet toe te delen aan 1 object)"]
[]
[null,null,"INVESTERINGSKOSTEN DETERMINISTISCH",null,null,null,null,{"$f":"H68+H70","v":46641.65}]
[]
[null,null,"Bandbreedte raming",null,"P15",null,41000,null,"P85",53000]
[null,null,"(probabilistisch uit te rekenen)",null,null,null,"voorbeeld",null,null,"voorbeeld"]
[]
[null,null,"PROBABILISTISCH RAMEN"]
[null,null,"P15","15e percentiel. Dit betekent dat de kans 15% is dat de kosten LAGER uitvallen dan het bij P15 genoemde bedrag"]
[null,null,"P50","50e percentiel. De kans dat de werkelijke kosten hoger of lager uitvallen dan dit bedrag zijn beide 50%. Dit wordt tevens de mediaan genoemd."]
[null,null,"P85","85e percentiel. Dit betekent dat de kans 15% is dat de kosten HOGER uitvallen dan het bij P85 genoemde bedrag"]
[]
[null,null,"Betrouwbaarheidsinterval P15 tot P85.  Dit betekent dat de kans 70% is dat de kosten binnen deze 2 waarden vallen. "]
[null,null,"Dit noemen we ook wel de bandbreedte van de raming maar daarbij moet wel de betrouwbaarheid (uitgedrukt in kans) opgegeven worden."]

{"sheet":"F Redundantietoeslag","index":9,"n_rows":9,"n_cols":24,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,null,"Uitleg redundantie factoren"]
[null,null,null,"Kosten/ straat"]
[null,null,null,"Y(mln)","=","a","*","x","^","b",null,"Kosten x",null,null,null,null,null,"Meest waarschijnlijk",null,null,null,null,"Pull down menu"]
["Machtfactor",null,null,null,null,null,null,null,null,0.7,null,"aantal straten","Verhouding",null,null,"Machtfactor",0.6,0.65,0.7,0.75,0.8,null,"Tabblad A"]
["1 van",1,"Straat",{"$f":"H5^J5","v":5.0118723362727229},"=",1,"*",10,"^",{"$f":"J$4","v":0.7},null,{"$f":"B5*D5","v":5.0118723362727229},{"$f":"L5/L$5","v":1},null,null,1,1,1,1,1,1,null,0]
["1 van",2,"Straten",{"$f":"H6^J6","v":3.0851693136000478},"=",1,"*",{"$f":"H5/B6","v":5},"^",{"$f":"J$4","v":0.7},null,{"$f":"B6*D6","v":6.1703386272000955},{"$f":"L6/L$5","v":1.2311444133449161},null,null,2,1.319507910772894,1.274560627319262,1.2,1.1892071150027206,1.1486983549970347,null,{"$f":"S6-1","v":0.19999999999999996}]
["1 van",3,"Straten",{"$f":"H7^J7","v":2.3228176731198298},"=",1,"*",{"$f":"H5/B7","v":3.3333333333333335},"^",{"$f":"J$4","v":0.7},null,{"$f":"B7*D7","v":6.9684530193594894},{"$f":"L7/L$5","v":1.3903891703159093},null,null,3,1.5509142802625859,1.467945751979395,1.3937999999999999,1.3150868340094011,1.2447342551654641,null,{"$f":"S7-1","v":0.39379999999999993}]
["1 van",4,"Straten",{"$f":"H8^J8","v":1.8991444823309347},"=",1,"*",{"$f":"H5/B8","v":2.5},"^",{"$f":"J$4","v":0.7},null,{"$f":"B8*D8","v":7.5965779293237388},{"$f":"L8/L$5","v":1.515716566510398},null,null,4,1.7411011265922482,1.6245047927124709,1.52,1.4142135623730949,1.319507910772894,null,{"$f":"S8-1","v":0.52}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Keuze",1]