{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["COVER","Toelichting","Instructie","Input >>>","I_Contactinfo","I_Generiek","I_Verdeelsleutel","I_Kosten","I_Investeringen","I_Financiering","Calc >>>","C_Base","C_Scenario","Output >>>","O_Dashboard","O_Graph","CHECK"],"not_rendered":{"charts":7,"images":15,"macros":1,"external_links":0,"defined_names":6,"comments":0,"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":"COVER","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[12,2,12,4],[23,2,24,13],[5,2,5,4],[14,2,19,13]]}
[]
[]
[]
[]
[null,null,"BOVAG"]
[null,null,"Kostprijsmodel Aanhangwagenbedrijven"]
[]
[]
[]
[]
[]
[null,null,"Finale versie"]

{"sheet":"Toelichting","index":1,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | Toelichting"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"Toelichting"}]
[null,null,"Toelichting"]
[]
[]
[null,null,"1.","Toelichting van de verschillende celformats in dit inputtemplate"]
[]
[null,null,null,null,null,"Inputcellen, deze cellen dienen ingevuld te worden"]
[]
[null,null,null,null,null,"Inputcellen die o.b.v. de specifieke situatie niet ingevuld hoeven te worden (omdat de optie niet van toepassing is)"]
[]
[null,null,null,null,null,"Calculatiecellen, deze mogen niet gewijzigd worden"]
[]
[null,null,"2.","Toelichting gehanteerde terminologie"]
[]
[null,null,null,"Aftersales",null,null,"Aftersales omvat alle werkplaatsactiviteiten zoals (maar niet gelimiteerd tot) onderhoud, APK’s en bandenwissel"]
[null,null,null,"Direct personeel",null,null,"Direct personeel betreft het personeel dat werk uitvoert in de werkplaats (bv. monteurs)"]
[null,null,null,"Indirect personeel",null,null,"Indirect personeel betreft het personeel dat onder overhead valt (bv. Administratief-, HR en marketing medewerkers)"]
[null,null,null,"Nieuwe afschrijvingen",null,null,"Afschrijvingen die nog niet opgenomen zijn in de beschikbare data die u gebruikt om dit model te vullen, maar u wel wilt meenemen in de kostprijs berekening als gevolg van "]
[null,null,null,null,null,null,"extra investeringen"]
[null,null,null,"Nieuwe rentelasten",null,null,"Rentelasten die nog niet opgenomen zijn in de beschikbare data die u gebruikt om dit model te vullen, maar u wel wilt meenemen in de kostprijs berekening als gevolg van"]
[null,null,null,null,null,null,"nieuwe financiering"]
[null,null,null,"Leasekosten werkplaatsapparatuur",null,null,"Leasekosten van werkplaatsapparatuur, equipment etc."]
[null,null,null,"Management fee / ondernemersbeloning",null,null,"Een vergoeding van de directie (wanneer deze niet onder de personeelskosten zijn opgenomen)"]
[null,null,null,"Verdeelsleutel",null,null,"Dit is een percentage dat aangeeft hoeveel procent van de ingevulde kosten te koppelen is aan de aftersales activiteiten. Wanneer u bijvoorbeeld zowel aftersales "]
[null,null,null,null,null,null,"als sales activiteiten uitvoert en de kosten voor aftersales 45% (voorbeeld) van de door u ingevulde kosten bedragen, kunt u dit percentage als \"verdeelsleutel\" gebruiken"]

{"sheet":"Instructie","index":2,"n_rows":180,"n_cols":7,"rows_kept":180,"cut":false,"hidden":true,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | Instructie"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"Instructie"}]
[null,null,"Instructie"]
[]
[]
[null,null,"1.","Invullen van gegevens"]
[]
[null,null,null,"Allereerst dienen de gegevens die nodig zijn ingevuld te worden door de gebruiker. De verzameling van deze gegevens vindt plaats in 6 tabbladen en dienen qua volgorde zo doorlopen te worden zoals ze zijn"]
[null,null,null,"opgenomen in het inputtemplate."]
[]
[null,null,null,"I_Contactinfo"]
[null,null,null,"Op het eerste tabblad wordt algemene informatie over de gebruiker en het bedrijf gevraagd"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"I_Generiek"]
[null,null,null,{"$f":"\"Het tweede tabblad dat u dient in te vullen vraagt onder andere informatie over de gerealiseerde productie van jaar \"&I_Generiek!$F$9","v":"Het tweede tabblad dat u dient in te vullen vraagt onder andere informatie over de gerealiseerde productie van jaar "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"I_Verdeelsleutel"]
[null,null,null,"Hier heeft u de mogelijkheid meerdere verdeelsleutels in te voeren om de kosten die u invoert in deze inputtemplate, te koppelen aan de aftersales activiteiten."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"I_Kosten"]
[null,null,null,"Dit tabblad vraagt u om informatie aan te leveren over alle kostenelementen binnen uw bedrijf. Ook heeft u hier de mogelijkheid om kostenelementen zelf toe te voegen, mocht u dit nodig vinden."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"I_Investeringen"]
[null,null,null,"Wanneer u extra investeringen verwacht of al heeft gedaan, en de kosten hiervan zijn nog niet opgenomen in uw huidige kostenoverzicht, kunt u deze hier invullen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"I_Financiering"]
[null,null,null,"Wanneer u nieuwe financiering heeft afgesloten of dit verwachte te gaan doen, en de rentelasten hiervan zijn nog niet opgenomen in uw huidige kostenoverzicht, kunt u deze hier invullen."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2.","Materiaalkosten"]
[]
[null,null,null,"Let op! U dient materiaalkosten niet mee te nemen bij het invullen van de kosten op tabblad I_Kosten. De materiaalkosten worden namelijk niet meegenomen in de kostprijsberekening"]
[null,null,null,"(kostprijs per manuur) omdat de materiaalkosten 1-op-1 aan de klant worden doorbelast op de factuur. Zo wordt voorkomen dat (een deel van) de materiaalkosten ook verwerkt zitten in het uurtarief"]
[null,null,null,"dat door de klant betaald wordt."]
[]
[null,null,"3.","Dashboard en scenario analyse"]
[]
[null,null,null,"De uitkomsten van het kostprijsmodel vindt u op tabblad O_Dashboard. Hier kunt u ook de \"draaiknoppen\" vinden om wijzigingen door te voeren op verschillende kosten en direct te zien wat hiervan de impact"]
[null,null,null,"is op de kostprijs. Deze \"draaiknoppen\" zijn te vinden onder hoofdstuk 1 op dit tabblad."]
[null,null,null,"Hoofdstuk 2 t/m 6 op tabblad O_Dashboard geven de uitkomsten weer van de berekeningen in het model. Hierin is voor sommige weergaven een onderscheid gemaakt tussen:"]
[null,null,null,"- INPUT: Dit is de uitkomst die is gebaseerd op de informatie die u ingevuld heeft op de input tabbladen (zoals I_Kosten)."]
[null,null,null,"- SCENARIO: Dit is uitkomst die is gebaseerd op aanpassingen op kosten die u in Hoofdstuk 1 (de \"draaiknoppen\") heeft gemaakt. Zo kunt u INPUT en SCENARIO met elkaar vergelijken en direct zien wat de"]
[null,null,null,"  impact van 'draaien aan de knoppen' is op de berekende kostprijs."]
[]
[null,null,"4.","Bij vragen of onduidelijkheden"]
[]
[null,null,null,"Mochten er tijdens het invullen van dit inputtemplate vragen of onduidelijkheden zijn, kunt u contact opnemen met:"]
[null,null,null,null,"Naam ",null,"Tim Manders"]
[null,null,null,null,"Telefoonnummer ",null,"06 - 83 56 84 97"]
[null,null,null,null,"E-mailadres ",null,"manders.tim@kpmg.nl"]

{"sheet":"Input >>>","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Input >>>"]

{"sheet":"I_Contactinfo","index":4,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | I_Contactinfo"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"I_Contactinfo"}]
[null,null,"Contactinformatie"]
[null,null,null,null,null,null,null,null,null,"Ingevuld:"]
[]
[null,null,"1.","Contactinformatie van uw organisatie",null,null,null,null,null,null,null,null,"1ste contactpersoon","2de contactpersoon (indien van toepassing)"]
[]
[null,null,null,"1.1 ","Naam organisatie",null,null,null,null,{"$f":"M9<>\"\"","v":false}]
[]
[null,null,null,"1.2","Naam contactpersoon",null,null,null,null,{"$f":"M11<>\"\"","v":false}]
[]
[null,null,null,"1.3","Functie contactpersoon",null,null,null,null,{"$f":"M13<>\"\"","v":false}]
[]
[null,null,null,"1.4","Telefoonnummer contactpersoon",null,null,null,null,{"$f":"M15<>\"\"","v":false}]
[]
[null,null,null,"1.5","E-mailadres contactpersoon",null,null,null,null,{"$f":"M17<>\"\"","v":false}]

{"sheet":"I_Generiek","index":5,"n_rows":205,"n_cols":6,"rows_kept":205,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | I_Generiek"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"I_Generiek"}]
[null,null,"Generiek"]
[]
[]
[null,null,"0.","Het (volledige) jaar waarvoor de gegevens ingevuld worden"]
[]
[null,null,null,null,"Jaar"]
[]
[]
[null,null,"1.",{"$f":"\"Gefactureerde uren \"&$F$9","v":"Gefactureerde uren "}]
[]
[null,null,null,"1.1",{"$f":"\"Gefactureerde uren \"&$F$9","v":"Gefactureerde uren "}]
[]
[null,null,null,null,"Eenheid",{"$f":"\"Gefactureerde uren \"&$F$9","v":"Gefactureerde uren "}]
[]
[null,null,null,null,"Gefactureerde uren"]
[]
[]
[null,null,"2.","Toekenning directe en indirecte kosten"]
[]
[null,null,null,null,"Directe- / Indirecte kosten","Kosten item"]
[]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E21","v":"Opleidingskosten direct personeel"}]
[null,null,null,0,"Directe kosten",{"$f":"I_Kosten!E37","v":"Afschrijvingslasten - direct"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E57","v":"Huisvestingskosten"}]
[null,null,null,0,"Directe kosten",{"$f":"I_Kosten!E51","v":"Leasekosten werkplaatsapparatuur"}]
[null,null,null,{"$f":"D29+2","v":2},"Directe kosten",{"$f":"I_Kosten!E53","v":"Garantiekosten"}]
[null,null,null,0,{"$f":"IF(F31=\"\",\"\",\"Directe kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$71,$D31,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D31,))","v":""}]
[null,null,null,2,"",{"$f":"IF(OFFSET(I_Kosten!$F$71,$D32,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D32,))","v":""}]
[null,null,null,4,"",{"$f":"IF(OFFSET(I_Kosten!$F$71,$D33,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D33,))","v":""}]
[null,null,null,6,"",{"$f":"IF(OFFSET(I_Kosten!$F$71,$D34,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D34,))","v":""}]
[null,null,null,8,"",{"$f":"IF(OFFSET(I_Kosten!$F$71,$D35,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D35,))","v":""}]
[null,null,null,10,"",{"$f":"IF(OFFSET(I_Kosten!$F$71,$D36,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D36,))","v":""}]
[]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E27","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E33","v":"Opleidingskosten indirect personeel"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E39","v":"Afschrijvingslasten - indirect"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E45","v":"Rentelasten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E85","v":"Management fee / Ondernemersbeloning"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E87","v":"IT kosten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E89","v":"Energiekosten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E91","v":"Marketingkosten"}]
[null,null,null,0,{"$f":"IF(F46=\"\",\"\",\"Indirecte kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$93,$D46,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D46,))","v":""}]
[null,null,null,{"$f":"D46+2","v":2},{"$f":"IF(F47=\"\",\"\",\"Indirecte kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$93,$D47,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D47,))","v":""}]
[null,null,null,{"$f":"D47+2","v":4},{"$f":"IF(F48=\"\",\"\",\"Indirecte kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$93,$D48,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D48,))","v":""}]
[null,null,null,{"$f":"D48+2","v":6},"",{"$f":"IF(OFFSET(I_Kosten!$F$93,$D49,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D49,))","v":""}]
[null,null,null,8,"",{"$f":"IF(OFFSET(I_Kosten!$F$93,$D50,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D50,))","v":""}]
[null,null,null,10,"",{"$f":"IF(OFFSET(I_Kosten!$F$93,$D51,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D51,))","v":""}]
[null,null,null,12,"",{"$f":"IF(OFFSET(I_Kosten!$F$93,$D52,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D52,))","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Jeugdzorg"]
[null,null,null,null,"GHZ"]
[null,null,null,null,"GGZ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"ja"]
[null,null,null,null,"nee"]

{"sheet":"I_Verdeelsleutel","index":6,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | I_Verdeelsleutel"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"I_Verdeelsleutel"}]
[null,null,"Verdeelsleutel"]
[]
[]
[null,null,"1.","Verdeelsleutel voor kosten"]
[]
[null,null,null,null,"Verdeelsleutel","Eenheid","Totaal","Behorende aan werkplaats","Behorende aan Sales","% werkplaats","Check"]
[]
[null,null,null,null,"Percentage",{"$f":"IF(E11=\"\",\"\",\"%\")","v":"%"},1,null,null,{"$f":"IFERROR($H11/SUM($H11:$I11),\"\")","v":""},{"$f":"IF(SUM(H11:I11)=G11,TRUE,FALSE)","v":false},{"$f":"IF(AND($G11<>SUM($H11:$I11),SUM($H11:$I11)<>0),\"Let op: Het Totaal komt niet overeen met de optelling van werkplaats en Sales\",\"\")","v":""}]
[null,null,null,null,"Omzet","EUR",null,null,null,{"$f":"IFERROR($H12/SUM($H12:$I12),\"\")","v":""},{"$f":"IF(SUM(H12:I12)=G12,TRUE,FALSE)","v":true},{"$f":"IF(AND($G12<>SUM($H12:$I12),SUM($H12:$I12)<>0),\"Let op: Het Totaal komt niet overeen met de optelling van werkplaats en Sales\",\"\")","v":""}]
[null,null,null,null,"Kosten","EUR",null,null,null,"",true,""]
[null,null,null,null,"Aantal medewerkers","Aantal",null,null,null,"",true,""]
[null,null,null,null,"Gebruiksoppervlak","m²",null,null,null,"",true,""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(SUM(H16:I16)=G16,F16<>\"\"),TRUE,FALSE)","v":false},""]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(SUM(H20:I20)=G20,F20<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,null,null,null,null,null,"",false,""]

{"sheet":"I_Kosten","index":7,"n_rows":114,"n_cols":13,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | I_Kosten"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"I_Kosten"}]
[null,null,{"$f":"\"Kosten \"&I_Generiek!$F$9","v":"Kosten "}]
[null,null,null,null,null,null,"Keuze",null,"Eenheid",null,{"$f":"I_Generiek!$F$9","v":0},null,"Verdeelsleutel"]
[]
[null,null,"0.","Totale bedrijfskosten"]
[]
[null,null,null,"0.1","Totale bedrijfskosten (alle directe + indirecte kosten)"]
[]
[null,null,"1.","Personele lasten direct personeel"]
[]
[null,null,null,"1.1","Personeelskosten afzonderlijk invullen voor personeel in loondienst en ingehuurd personeel?"]
[]
[null,null,null,"1.2","Totale personeelskosten direct personeel (excl. opleidingskosten)",null,null,null,"EUR / jaar"]
[]
[null,null,null,null,"1.2.1","Totale personeelskosten direct personeel (excl. opleidingskosten) - In loondienst",null,null,"EUR / jaar"]
[]
[null,null,null,null,"1.2.2","Totale personeelskosten direct personeel (excl. opleidingskosten) - Ingehuurd personeel",null,null,"EUR / jaar"]
[]
[null,null,null,"1.3","Opleidingskosten direct personeel",null,null,null,"EUR / jaar"]
[]
[null,null,"2.","Personele lasten indirect personeel"]
[]
[null,null,null,"2.1","Personeelskosten afzonderlijk invullen voor personeel in loondienst en ingehuurd personeel?"]
[]
[null,null,null,"2.2","Totale personeelskosten indirect personeel (excl. opleidingskosten)",null,null,null,"EUR / jaar"]
[]
[null,null,null,null,"2.2.1","Totale personeelskosten indirect personeel (excl. opleidingskosten) - In loondienst",null,null,"EUR / jaar"]
[]
[null,null,null,null,"2.2.2","Totale personeelskosten indirect personeel (excl. opleidingskosten) - Ingehuurd personeel",null,null,"EUR / jaar"]
[]
[null,null,null,"2.3","Opleidingskosten indirect personeel",null,null,null,"EUR / jaar"]
[]
[null,null,"3.","Afschrijvingen"]
[]
[null,null,null,"3.1","Afschrijvingslasten - direct",null,null,null,"EUR / jaar"]
[]
[null,null,null,"3.2","Afschrijvingslasten - indirect",null,null,null,"EUR / jaar"]
[]
[null,null,null,"3.3","Zijn er extra investeringen die meegenomen moeten worden?",null,null,null,null,null,{"$f":"IF($G41=\"Ja\",\"Deze dient u in te vullen op tabblad 'I_Investeringen', waarna u dit tabblad weer verder kunt invullen\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K41=\"\",\"\",\"KLIK HIER\")","v":""}]
[null,null,"4.","Rentelasten"]
[]
[null,null,null,"4.1","Rentelasten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"4.2","Zijn er nieuwe rentelasten die meegenomen moeten worden?",null,null,null,null,null,{"$f":"IF($G47=\"Ja\",\"Deze dient u in te vullen op tabblad 'I_Financiering', waarna u dit tabblad weer verder kunt invullen\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K47=\"\",\"\",\"KLIK HIER\")","v":""}]
[null,null,"5.","Directe overige kosten"]
[]
[null,null,null,"5.1","Leasekosten werkplaatsapparatuur",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.2","Garantiekosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.3","Wilt u de huisvestingskosten op detail niveau invoeren?"]
[]
[null,null,null,"5.4","Huisvestingskosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.4.1","Huisvestingskosten - Huur",null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.4.2","Huisvestingskosten - Onderhoud",null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.4.3","Huisvestingskosten - Verzekeringen",null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.4.4",null,null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.4.5",null,null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.4.6",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.5",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.6",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.7",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.8",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.9",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.10",null,null,null,null,"EUR / jaar"]
[]
[null,null,"6.","Overige indirecte kosten"]
[]
[null,null,null,"6.1","Management fee / Ondernemersbeloning",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.2","IT kosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.3","Energiekosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.4","Marketingkosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.5",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.6",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.7",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.8",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.9",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.10",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.11",null,null,null,null,"EUR / jaar"]
[]
[null,null,"7.","Check totale kosten"]
[]
[null,null,null,"7.1","Ingevulde totale bedrijfskosten",null,null,null,"EUR / jaar",null,{"$f":"K9","v":0}]
[]
[null,null,null,"7.2","Optelling ingevulde individuele kosten",null,null,null,"EUR / jaar",null,{"$f":"SUM(IF(G13=\"Nee\",K15,IF(G13=\"Ja\",SUM(K17:K19),0)),K21,IF(G25=\"Nee\",K27,IF(G25=\"Ja\",SUM(K29:K31),0)),K33,K37,K39,K45,K51:K53,IF(G55=\"Nee\",K57,IF(G55=\"Ja\",K59:K69,0)),K71:K81,K85:K105)","v":0}]
[]
[null,null,null,"7.3","Controle of de ingevulde totale bedrijfskosten gelijk is aan de optelling van de ingevulde individuele kosten",null,null,null,null,null,{"$f":"K109=K111","v":true}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K113=FALSE,\"Let op, de ingevulde totale bedrijfskosten komen niet overeen met de optelling van de ingevulde individuele kosten\",\"\")","v":""}]

{"sheet":"I_Investeringen","index":8,"n_rows":72,"n_cols":15,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | I_Investeringen"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"I_Investeringen"}]
[null,null,{"$f":"\"Extra investeringen \"&I_Generiek!$F$9","v":"Extra investeringen "}]
[null,null,null,null,null,null,"Keuze",null,"Eenheid",null,{"$f":"I_Generiek!$F$9","v":0},null,"Verdeelsleutel",null,"Directe / indirecte afschrijvingslasten"]
[]
[null,null,"1.","Extra investeringen"]
[]
[null,null,null,"1.1","Eenvoudige invoer voor extra investeringen?",null,null,null,null,null,{"$f":"IF(AND($G9<>\"\",OR(I_Kosten!$G$41=\"\",I_Kosten!$G$41=\"Nee\")),\"Let op: de keuze op tabblad I_Kosten geeft aan dat er geen extra investeringen meegenomen hoeven te worden\",\"\")","v":""}]
[null,null,null,null,"Nieuwe directe afschrijvingslasten (eenvoudige invoer)",null,null,null,"EUR / jaar",null,null,null,null,null,"Direct"]
[null,null,null,null,"Nieuwe indirecte afschrijvingslasten (eenvoudige invoer)",null,null,null,"EUR / jaar",null,null,null,null,null,"Indirect"]
[]
[null,null,null,"1.2","Extra investeringen (detail invoer)"]
[]
[null,null,null,null,"1.2.1","Investeringscategorieën"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"1.2.1","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Investeringscategorie"]
[null,null,null,null,null,"Investering",null,null,"EUR"]
[null,null,null,null,null,"Afschrijftermijn",null,null,"# (jaren)"]
[null,null,null,null,null,"Restwaarde",null,null,"EUR",null,null,null,{"$f":"IF(K30>K28,\"Let op: De restwaarde is momenteel groter dan de investering\",\"\")","v":""}]
[]
[null,null,null,null,"1.2.2","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Investeringscategorie"]
[null,null,null,null,null,"Investering",null,null,"EUR"]
[null,null,null,null,null,"Afschrijftermijn",null,null,"# (jaren)"]
[null,null,null,null,null,"Restwaarde",null,null,"EUR",null,null,null,{"$f":"IF(K36>K34,\"Let op: De restwaarde is momenteel groter dan de investering\",\"\")","v":""}]
[]
[null,null,null,null,"1.2.3","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Investeringscategorie"]
[null,null,null,null,null,"Investering",null,null,"EUR"]
[null,null,null,null,null,"Afschrijftermijn",null,null,"# (jaren)"]
[null,null,null,null,null,"Restwaarde",null,null,"EUR",null,null,null,{"$f":"IF(K42>K40,\"Let op: De restwaarde is momenteel groter dan de investering\",\"\")","v":""}]
[]
[null,null,null,null,"1.2.4","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Investeringscategorie"]
[null,null,null,null,null,"Investering",null,null,"EUR"]
[null,null,null,null,null,"Afschrijftermijn",null,null,"# (jaren)"]
[null,null,null,null,null,"Restwaarde",null,null,"EUR",null,null,null,{"$f":"IF(K48>K46,\"Let op: De restwaarde is momenteel groter dan de investering\",\"\")","v":""}]
[]
[null,null,null,null,"1.2.5","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Investeringscategorie"]
[null,null,null,null,null,"Investering",null,null,"EUR"]
[null,null,null,null,null,"Afschrijftermijn",null,null,"# (jaren)"]
[null,null,null,null,null,"Restwaarde",null,null,"EUR",null,null,null,{"$f":"IF(K54>K52,\"Let op: De restwaarde is momenteel groter dan de investering\",\"\")","v":""}]
[]
[null,null,null,null,"1.2.6","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Investeringscategorie"]
[null,null,null,null,null,"Investering",null,null,"EUR"]
[null,null,null,null,null,"Afschrijftermijn",null,null,"# (jaren)"]
[null,null,null,null,null,"Restwaarde",null,null,"EUR",null,null,null,{"$f":"IF(K60>K58,\"Let op: De restwaarde is momenteel groter dan de investering\",\"\")","v":""}]
[]
[null,null,null,null,"1.2.7","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Investeringscategorie"]
[null,null,null,null,null,"Investering",null,null,"EUR"]
[null,null,null,null,null,"Afschrijftermijn",null,null,"# (jaren)"]
[null,null,null,null,null,"Restwaarde",null,null,"EUR",null,null,null,{"$f":"IF(K66>K64,\"Let op: De restwaarde is momenteel groter dan de investering\",\"\")","v":""}]
[]
[null,null,null,null,"1.2.8","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Investeringscategorie"]
[null,null,null,null,null,"Investering",null,null,"EUR"]
[null,null,null,null,null,"Afschrijftermijn",null,null,"# (jaren)"]
[null,null,null,null,null,"Restwaarde",null,null,"EUR",null,null,null,{"$f":"IF(K72>K70,\"Let op: De restwaarde is momenteel groter dan de investering\",\"\")","v":""}]

{"sheet":"I_Financiering","index":9,"n_rows":44,"n_cols":13,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | I_Financiering"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"I_Financiering"}]
[null,null,{"$f":"\"Nieuwe rentelasten \"&I_Generiek!$F$9","v":"Nieuwe rentelasten "}]
[null,null,null,null,null,null,"Keuze",null,"Eenheid",null,{"$f":"I_Generiek!$F$9","v":0},null,"Verdeelsleutel"]
[]
[null,null,"1.","Nieuwe rentelasten"]
[]
[null,null,null,"1.1","Eenvoudige invoer voor nieuwe rentelasten?",null,null,null,null,null,{"$f":"IF(AND($G9<>\"\",OR(I_Kosten!$G$47=\"\",I_Kosten!$G$47=\"Nee\")),\"Let op: de keuze op tabblad I_Kosten geeft aan dat er geen nieuwe rentelasten meegenomen hoeven te worden\",\"\")","v":""}]
[null,null,null,null,"Nieuwe rentelasten (eenvoudige invoer)",null,null,null,"EUR / jaar"]
[]
[null,null,null,"1.2","Nieuwe rentelasten (detail invoer)"]
[]
[null,null,null,null,"1.2.1","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Financieringsbedrag",null,null,"EUR"]
[null,null,null,null,null,"Rentepercentage ",null,null,"% / jaar"]
[]
[null,null,null,null,"1.2.2","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Financieringsbedrag",null,null,"EUR"]
[null,null,null,null,null,"Rentepercentage",null,null,"% / jaar"]
[]
[null,null,null,null,"1.2.3","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Financieringsbedrag",null,null,"EUR"]
[null,null,null,null,null,"Rentepercentage",null,null,"% / jaar"]
[]
[null,null,null,null,"1.2.4","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Financieringsbedrag",null,null,"EUR"]
[null,null,null,null,null,"Rentepercentage",null,null,"% / jaar"]
[]
[null,null,null,null,"1.2.5","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Financieringsbedrag",null,null,"EUR"]
[null,null,null,null,null,"Rentepercentage",null,null,"% / jaar"]
[]
[null,null,null,null,"1.2.6","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Financieringsbedrag",null,null,"EUR"]
[null,null,null,null,null,"Rentepercentage",null,null,"% / jaar"]
[]
[null,null,null,null,"1.2.7","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Financieringsbedrag",null,null,"EUR"]
[null,null,null,null,null,"Rentepercentage",null,null,"% / jaar"]
[]
[null,null,null,null,"1.2.8","Wilt u deze invoervelden activeren?"]
[null,null,null,null,null,"Financieringsbedrag",null,null,"EUR"]
[null,null,null,null,null,"Rentepercentage",null,null,"% / jaar"]

{"sheet":"Calc >>>","index":10,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Calc >>>"]

{"sheet":"C_Base","index":11,"n_rows":341,"n_cols":17,"rows_kept":341,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | C_Base"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"C_Base"}]
[null,null,"Calculatie_Base"]
[null,null,null,null,null,null,null,null,null,null,"Input",null,"Verdeelsleutel",null,"% werkplaats",null,"Berekening werkplaats"]
[]
[null,null,"1.","Personeelskosten"]
[]
[null,null,null,"1.1",null,"Direct personeel - personeelskosten (excl. opleidingskosten) - Eenvoudige invoer",null,null,null,{"$f":"IF(J13=\"Ja\",\"Nee\",IF(J13=0,0,\"Ja\"))","v":0}]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"IF($J$9=\"Ja\",I_Kosten!K15,0)","v":0},null,{"$f":"I_Kosten!M15","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M11,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M11,I_Verdeelsleutel!$E$11:$E$21,0))*$K11,0)","v":0}]
[]
[null,null,null,"1.2",null,"Direct personeel - personeelskosten (excl. opleidingskosten) - Detail invoer",null,null,null,{"$f":"I_Kosten!G13","v":0}]
[]
[null,null,null,null,null,{"$f":"I_Kosten!F17","v":"Totale personeelskosten direct personeel (excl. opleidingskosten) - In loondienst"},null,null,"EUR / jaar",null,{"$f":"IF($J$13=\"Ja\",I_Kosten!K17,0)","v":0},null,{"$f":"I_Kosten!M17","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M15,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M15,I_Verdeelsleutel!$E$11:$E$21,0))*$K15,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!F19","v":"Totale personeelskosten direct personeel (excl. opleidingskosten) - Ingehuurd personeel"},null,null,"EUR / jaar",null,{"$f":"IF($J$13=\"Ja\",I_Kosten!K19,0)","v":0},null,{"$f":"I_Kosten!M19","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M16,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M16,I_Verdeelsleutel!$E$11:$E$21,0))*$K16,0)","v":0}]
[]
[null,null,null,"1.3",null,"Totale personeelskosten direct personeel (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"SUM(K11,K15:K16)","v":0},null,null,null,null,null,{"$f":"SUM(Q11,Q15:Q16)","v":0}]
[]
[null,null,null,"1.4",null,"Direct personeel - opleidingskosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E21","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K21","v":0},null,{"$f":"I_Kosten!M21","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M24,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M24,I_Verdeelsleutel!$E$11:$E$21,0))*$K24,0)","v":0}]
[]
[null,null,null,"1.5",null,"Indirect personeel - personeelskosten (excl. opleidingskosten) - Eenvoudige invoer",null,null,null,{"$f":"IF(J30=\"Ja\",\"Nee\",IF(J30=0,0,\"Ja\"))","v":0}]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E27","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"IF($J$26=\"Ja\",I_Kosten!K27,0)","v":0},null,{"$f":"I_Kosten!M27","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M28,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M28,I_Verdeelsleutel!$E$11:$E$21,0))*$K28,0)","v":0}]
[]
[null,null,null,"1.6",null,"Indirect personeel - personeelskosten (excl. opleidingskosten) - Detail invoer",null,null,null,{"$f":"I_Kosten!G25","v":0}]
[]
[null,null,null,null,null,{"$f":"I_Kosten!F29","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten) - In loondienst"},null,null,"EUR / jaar",null,{"$f":"IF($J$30=\"Ja\",I_Kosten!K29,0)","v":0},null,{"$f":"I_Kosten!M29","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M32,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M32,I_Verdeelsleutel!$E$11:$E$21,0))*$K32,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!F31","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten) - Ingehuurd personeel"},null,null,"EUR / jaar",null,{"$f":"IF($J$30=\"Ja\",I_Kosten!K31,0)","v":0},null,{"$f":"I_Kosten!M31","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M33,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M33,I_Verdeelsleutel!$E$11:$E$21,0))*$K33,0)","v":0}]
[]
[null,null,null,"1.7",null,"Totale personeelskosten indirect personeel (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E27","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"SUM(K28,K32:K33)","v":0},null,null,null,null,null,{"$f":"SUM(Q28,Q32:Q33)","v":0}]
[]
[null,null,null,"1.8",null,"Indirect personeel - opleidingskosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E33","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K33","v":0},null,{"$f":"I_Kosten!M33","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M41,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M41,I_Verdeelsleutel!$E$11:$E$21,0))*$K41,0)","v":0}]
[]
[null,null,null,"1.9",null,"Totale personeelskosten"]
[]
[null,null,null,null,null,{"$f":"F20","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K20","v":0},null,null,null,null,null,{"$f":"Q20","v":0}]
[null,null,null,null,null,{"$f":"F24","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"K24","v":0},null,null,null,null,null,{"$f":"Q24","v":0}]
[null,null,null,null,null,{"$f":"F35","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K37","v":0},null,null,null,null,null,{"$f":"Q37","v":0}]
[null,null,null,null,null,{"$f":"F41","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"K41","v":0},null,null,null,null,null,{"$f":"Q41","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K45:K48)","v":0},null,null,null,null,null,{"$f":"SUM(Q45:Q48)","v":0}]
[]
[null,null,"2.",{"$f":"I_Kosten!D35","v":"Afschrijvingen"}]
[]
[null,null,null,"2.1",null,"Bestaande afschrijvingslasten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E37","v":"Afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K37","v":0},null,{"$f":"I_Kosten!M37","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M56,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M56,I_Verdeelsleutel!$E$11:$E$21,0))*$K56,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E39","v":"Afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K39","v":0},null,{"$f":"I_Kosten!M39","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M57,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M57,I_Verdeelsleutel!$E$11:$E$21,0))*$K57,0)","v":0}]
[]
[null,null,null,"2.2",null,"Nieuwe afschrijvingslasten (als gevolg van investeringen) - detail invoer",null,null,null,{"$f":"IF(J139=\"Ja\",\"Nee\",IF(J139=0,0,\"Ja\"))","v":0}]
[]
[null,null,null,null,"2.2.1",{"$f":"IF(I_Investeringen!G27=\"\",\"\",I_Investeringen!G27)","v":""}]
[null,null,null,null,null,{"$f":"I_Investeringen!F28","v":"Investering"},null,null,"EUR",null,{"$f":"I_Investeringen!K28","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F29","v":"Afschrijftermijn"},null,null,"# (jaren)",null,{"$f":"I_Investeringen!K29","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F30","v":"Restwaarde"},null,null,"EUR",null,{"$f":"I_Investeringen!K30","v":0}]
[null,null,null,null,null,"Direct of indirecte afschrijvingslasten?",null,null,null,{"$f":"I_Investeringen!O26","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$41","v":0},{"$f":"IF($J67=\"Ja\",IFERROR((K62-K64)/K63,0),0)","v":0},null,{"$f":"I_Investeringen!M26","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M67,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M67,I_Verdeelsleutel!$E$11:$E$21,0))*$K67,0)","v":0}]
[]
[null,null,null,null,"2.2.2",{"$f":"IF(I_Investeringen!G33=\"\",\"\",I_Investeringen!G33)","v":""}]
[null,null,null,null,null,{"$f":"I_Investeringen!F34","v":"Investering"},null,null,"EUR",null,{"$f":"I_Investeringen!K34","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F35","v":"Afschrijftermijn"},null,null,"# (jaren)",null,{"$f":"I_Investeringen!K35","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F36","v":"Restwaarde"},null,null,"EUR",null,{"$f":"I_Investeringen!K36","v":0}]
[null,null,null,null,null,"Direct of indirecte afschrijvingslasten?",null,null,null,{"$f":"I_Investeringen!O32","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$41","v":0},{"$f":"IF($J75=\"Ja\",IFERROR((K70-K72)/K71,0),0)","v":0},null,{"$f":"I_Investeringen!M32","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M75,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M75,I_Verdeelsleutel!$E$11:$E$21,0))*$K75,0)","v":0}]
[]
[null,null,null,null,"2.2.3",{"$f":"IF(I_Investeringen!G39=\"\",\"\",I_Investeringen!G39)","v":""}]
[null,null,null,null,null,{"$f":"I_Investeringen!F40","v":"Investering"},null,null,"EUR",null,{"$f":"I_Investeringen!K40","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F41","v":"Afschrijftermijn"},null,null,"# (jaren)",null,{"$f":"I_Investeringen!K41","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F42","v":"Restwaarde"},null,null,"EUR",null,{"$f":"I_Investeringen!K42","v":0}]
[null,null,null,null,null,"Direct of indirecte afschrijvingslasten?",null,null,null,{"$f":"I_Investeringen!O38","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$41","v":0},{"$f":"IF($J83=\"Ja\",IFERROR((K78-K80)/K79,0),0)","v":0},null,{"$f":"I_Investeringen!M38","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M83,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M83,I_Verdeelsleutel!$E$11:$E$21,0))*$K83,0)","v":0}]
[]
[null,null,null,null,"2.2.4",{"$f":"IF(I_Investeringen!G45=\"\",\"\",I_Investeringen!G45)","v":""}]
[null,null,null,null,null,{"$f":"I_Investeringen!F46","v":"Investering"},null,null,"EUR",null,{"$f":"I_Investeringen!K46","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F47","v":"Afschrijftermijn"},null,null,"# (jaren)",null,{"$f":"I_Investeringen!K47","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F48","v":"Restwaarde"},null,null,"EUR",null,{"$f":"I_Investeringen!K48","v":0}]
[null,null,null,null,null,"Direct of indirecte afschrijvingslasten?",null,null,null,{"$f":"I_Investeringen!O44","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$41","v":0},{"$f":"IF($J91=\"Ja\",IFERROR((K86-K88)/K87,0),0)","v":0},null,{"$f":"I_Investeringen!M44","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M91,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M91,I_Verdeelsleutel!$E$11:$E$21,0))*$K91,0)","v":0}]
[]
[null,null,null,null,"2.2.5",{"$f":"IF(I_Investeringen!G51=\"\",\"\",I_Investeringen!G51)","v":""}]
[null,null,null,null,null,{"$f":"I_Investeringen!F52","v":"Investering"},null,null,"EUR",null,{"$f":"I_Investeringen!K52","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F53","v":"Afschrijftermijn"},null,null,"# (jaren)",null,{"$f":"I_Investeringen!K53","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F54","v":"Restwaarde"},null,null,"EUR",null,{"$f":"I_Investeringen!K54","v":0}]
[null,null,null,null,null,"Direct of indirecte afschrijvingslasten?",null,null,null,{"$f":"I_Investeringen!O50","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$41","v":0},{"$f":"IF($J99=\"Ja\",IFERROR((K94-K96)/K95,0),0)","v":0},null,{"$f":"I_Investeringen!M50","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M99,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M99,I_Verdeelsleutel!$E$11:$E$21,0))*$K99,0)","v":0}]
[]
[null,null,null,null,"2.2.6",{"$f":"IF(I_Investeringen!G57=\"\",\"\",I_Investeringen!G57)","v":""}]
[null,null,null,null,null,{"$f":"I_Investeringen!F58","v":"Investering"},null,null,"EUR",null,{"$f":"I_Investeringen!K58","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F59","v":"Afschrijftermijn"},null,null,"# (jaren)",null,{"$f":"I_Investeringen!K59","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F60","v":"Restwaarde"},null,null,"EUR",null,{"$f":"I_Investeringen!K60","v":0}]
[null,null,null,null,null,"Direct of indirecte afschrijvingslasten?",null,null,null,{"$f":"I_Investeringen!O56","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$41","v":0},{"$f":"IF($J107=\"Ja\",IFERROR((K102-K104)/K103,0),0)","v":0},null,{"$f":"I_Investeringen!M56","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M107,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M107,I_Verdeelsleutel!$E$11:$E$21,0))*$K107,0)","v":0}]
[]
[null,null,null,null,"2.2.7",{"$f":"IF(I_Investeringen!G63=\"\",\"\",I_Investeringen!G63)","v":""}]
[null,null,null,null,null,{"$f":"I_Investeringen!F64","v":"Investering"},null,null,"EUR",null,{"$f":"I_Investeringen!K64","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F65","v":"Afschrijftermijn"},null,null,"# (jaren)",null,{"$f":"I_Investeringen!K65","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F66","v":"Restwaarde"},null,null,"EUR",null,{"$f":"I_Investeringen!K66","v":0}]
[null,null,null,null,null,"Direct of indirecte afschrijvingslasten?",null,null,null,{"$f":"I_Investeringen!O62","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$41","v":0},{"$f":"IF($J115=\"Ja\",IFERROR((K110-K112)/K111,0),0)","v":0},null,{"$f":"I_Investeringen!M62","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M115,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M115,I_Verdeelsleutel!$E$11:$E$21,0))*$K115,0)","v":0}]
[]
[null,null,null,null,"2.2.8",{"$f":"IF(I_Investeringen!G69=\"\",\"\",I_Investeringen!G69)","v":""}]
[null,null,null,null,null,{"$f":"I_Investeringen!F70","v":"Investering"},null,null,"EUR",null,{"$f":"I_Investeringen!K70","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F71","v":"Afschrijftermijn"},null,null,"# (jaren)",null,{"$f":"I_Investeringen!K71","v":0}]
[null,null,null,null,null,{"$f":"I_Investeringen!F72","v":"Restwaarde"},null,null,"EUR",null,{"$f":"I_Investeringen!K72","v":0}]
[null,null,null,null,null,"Direct of indirecte afschrijvingslasten?",null,null,null,{"$f":"I_Investeringen!O68","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$41","v":0},{"$f":"IF($J123=\"Ja\",IFERROR((K118-K120)/K119,0),0)","v":0},null,{"$f":"I_Investeringen!M68","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M123,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M123,I_Verdeelsleutel!$E$11:$E$21,0))*$K123,0)","v":0}]
[]
[null,null,null,null,"2.2.9","Totaal nieuwe afschrijvingslasten - detail invoer"]
[]
[null,null,null,null,null,{"$f":"F61","v":""},null,null,"EUR / jaar",{"$f":"J65","v":0},{"$f":"K67","v":0},null,null,null,null,null,{"$f":"Q67","v":0}]
[null,null,null,null,null,{"$f":"F69","v":""},null,null,"EUR / jaar",{"$f":"J73","v":0},{"$f":"K75","v":0},null,null,null,null,null,{"$f":"Q75","v":0}]
[null,null,null,null,null,{"$f":"F77","v":""},null,null,"EUR / jaar",{"$f":"J81","v":0},{"$f":"K83","v":0},null,null,null,null,null,{"$f":"Q83","v":0}]
[null,null,null,null,null,{"$f":"F85","v":""},null,null,"EUR / jaar",{"$f":"J89","v":0},{"$f":"K91","v":0},null,null,null,null,null,{"$f":"Q91","v":0}]
[null,null,null,null,null,{"$f":"F93","v":""},null,null,"EUR / jaar",{"$f":"J97","v":0},{"$f":"K99","v":0},null,null,null,null,null,{"$f":"Q99","v":0}]
[null,null,null,null,null,{"$f":"F101","v":""},null,null,"EUR / jaar",{"$f":"J105","v":0},{"$f":"K107","v":0},null,null,null,null,null,{"$f":"Q107","v":0}]
[null,null,null,null,null,{"$f":"F109","v":""},null,null,"EUR / jaar",{"$f":"J113","v":0},{"$f":"K115","v":0},null,null,null,null,null,{"$f":"Q115","v":0}]
[null,null,null,null,null,{"$f":"F117","v":""},null,null,"EUR / jaar",{"$f":"J121","v":0},{"$f":"K123","v":0},null,null,null,null,null,{"$f":"Q123","v":0}]
[]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - direct",null,null,"EUR / jaar","Direct",{"$f":"SUMIF($J$127:$J$134,$J136,K$127:K$134)","v":0},null,null,null,null,null,{"$f":"SUMIF($J$127:$J$134,$J136,Q$127:Q$134)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR / jaar","Indirect",{"$f":"SUMIF($J$127:$J$134,$J137,K$127:K$134)","v":0},null,null,null,null,null,{"$f":"SUMIF($J$127:$J$134,$J137,Q$127:Q$134)","v":0}]
[]
[null,null,null,"2.3",null,"Nieuwe afschrijvingslasten (als gevolg van investeringen) - eenvoudige invoer",null,null,null,{"$f":"I_Investeringen!G9","v":0}]
[]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - direct",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$41","v":0},{"$f":"IF($J141=\"Ja\",I_Investeringen!$K$10,0)","v":0},null,{"$f":"I_Investeringen!$M$10","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M141,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M141,I_Verdeelsleutel!$E$11:$E$21,0))*$K141,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$41","v":0},{"$f":"IF($J142=\"Ja\",I_Investeringen!$K$11,0)","v":0},null,{"$f":"I_Investeringen!$M$11","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M142,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M142,I_Verdeelsleutel!$E$11:$E$21,0))*$K142,0)","v":0}]
[]
[null,null,null,"2.4",null,"Totale afschrijvingslasten"]
[]
[null,null,null,null,null,"Bestaande afschrijvingslasten - direct",null,null,"EUR / jaar",null,{"$f":"K56","v":0},null,null,null,null,null,{"$f":"Q56","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - indirect",null,null,"EUR / jaar",null,{"$f":"K57","v":0},null,null,null,null,null,{"$f":"Q57","v":0}]
[null,null,null,null,null,{"$f":"F141","v":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"IF($J$59=\"Ja\",K136,K141)","v":0},null,null,null,null,null,{"$f":"IF($J$59=\"Ja\",Q136,Q141)","v":0}]
[null,null,null,null,null,{"$f":"F142","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"IF($J$59=\"Ja\",K137,K142)","v":0},null,null,null,null,null,{"$f":"IF($J$59=\"Ja\",Q137,Q142)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K146:K149)","v":0},null,null,null,null,null,{"$f":"SUM(Q146:Q149)","v":0}]
[]
[null,null,"3.",{"$f":"I_Kosten!D43","v":"Rentelasten"}]
[]
[null,null,null,"3.1",null,"Bestaande rentelasten"]
[]
[null,null,null,null,null,"Bestaande rentelasten",null,null,"EUR / jaar",null,{"$f":"I_Kosten!K45","v":0},null,{"$f":"I_Kosten!M45","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M157,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M157,I_Verdeelsleutel!$E$11:$E$21,0))*$K157,0)","v":0}]
[]
[null,null,null,"3.2",null,"Nieuwe rentelasten (als gevolg van nieuwe financiering) - detail invoer",null,null,null,{"$f":"IF(J209=\"Ja\",\"Nee\",IF(J209=0,0,\"Ja\"))","v":0}]
[]
[null,null,null,null,"3.2.1","Financiering 1"]
[null,null,null,null,null,{"$f":"I_Financiering!F15","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"I_Financiering!K15","v":0}]
[null,null,null,null,null,{"$f":"I_Financiering!F16","v":"Rentepercentage "},null,null,"% / jaar",null,{"$f":"I_Financiering!K16","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$47","v":0},{"$f":"IF($J165=\"Ja\",IFERROR(K162*K163,0),0)","v":0},null,{"$f":"I_Financiering!M14","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M165,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M165,I_Verdeelsleutel!$E$11:$E$21,0))*$K165,0)","v":0}]
[]
[null,null,null,null,"3.2.2","Financiering 2"]
[null,null,null,null,null,{"$f":"I_Financiering!F19","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"I_Financiering!K19","v":0}]
[null,null,null,null,null,{"$f":"I_Financiering!F20","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K20","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$47","v":0},{"$f":"IF($J171=\"Ja\",IFERROR(K168*K169,0),0)","v":0},null,{"$f":"I_Financiering!M18","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M171,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M171,I_Verdeelsleutel!$E$11:$E$21,0))*$K171,0)","v":0}]
[]
[null,null,null,null,"3.2.3","Financiering 3"]
[null,null,null,null,null,{"$f":"I_Financiering!F23","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"I_Financiering!K23","v":0}]
[null,null,null,null,null,{"$f":"I_Financiering!F24","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K24","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$47","v":0},{"$f":"IF($J177=\"Ja\",IFERROR(K174*K175,0),0)","v":0},null,{"$f":"I_Financiering!M22","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M177,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M177,I_Verdeelsleutel!$E$11:$E$21,0))*$K177,0)","v":0}]
[]
[null,null,null,null,"3.2.4","Financiering 4"]
[null,null,null,null,null,{"$f":"I_Financiering!F27","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"I_Financiering!K27","v":0}]
[null,null,null,null,null,{"$f":"I_Financiering!F28","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K28","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$47","v":0},{"$f":"IF($J183=\"Ja\",IFERROR(K180*K181,0),0)","v":0},null,{"$f":"I_Financiering!M26","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M183,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M183,I_Verdeelsleutel!$E$11:$E$21,0))*$K183,0)","v":0}]
[]
[null,null,null,null,"3.2.5","Financiering 5"]
[null,null,null,null,null,{"$f":"I_Financiering!F31","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"I_Financiering!K31","v":0}]
[null,null,null,null,null,{"$f":"I_Financiering!F32","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K32","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$47","v":0},{"$f":"IF($J189=\"Ja\",IFERROR(K186*K187,0),0)","v":0},null,{"$f":"I_Financiering!M30","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M189,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M189,I_Verdeelsleutel!$E$11:$E$21,0))*$K189,0)","v":0}]
[]
[null,null,null,null,"3.2.6","Financiering 6"]
[null,null,null,null,null,{"$f":"I_Financiering!F35","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"I_Financiering!K35","v":0}]
[null,null,null,null,null,{"$f":"I_Financiering!F36","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K36","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$47","v":0},{"$f":"IF($J195=\"Ja\",IFERROR(K192*K193,0),0)","v":0},null,{"$f":"I_Financiering!M34","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M195,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M195,I_Verdeelsleutel!$E$11:$E$21,0))*$K195,0)","v":0}]
[]
[null,null,null,null,"3.2.7","Financiering 7"]
[null,null,null,null,null,{"$f":"I_Financiering!F39","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"I_Financiering!K39","v":0}]
[null,null,null,null,null,{"$f":"I_Financiering!F40","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K40","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$47","v":0},{"$f":"IF($J201=\"Ja\",IFERROR(K198*K199,0),0)","v":0},null,{"$f":"I_Financiering!M38","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M201,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M201,I_Verdeelsleutel!$E$11:$E$21,0))*$K201,0)","v":0}]
[]
[null,null,null,null,"3.2.8","Financiering 8"]
[null,null,null,null,null,{"$f":"I_Financiering!F43","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"I_Financiering!K43","v":0}]
[null,null,null,null,null,{"$f":"I_Financiering!F44","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K44","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$47","v":0},{"$f":"IF($J207=\"Ja\",IFERROR(K204*K205,0),0)","v":0},null,{"$f":"I_Financiering!M42","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M207,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M207,I_Verdeelsleutel!$E$11:$E$21,0))*$K207,0)","v":0}]
[]
[null,null,null,"3.3",null,"Nieuwe rentelasten (als gevolg van nieuwe financiering) - eenvoudige invoer",null,null,null,{"$f":"I_Financiering!G9","v":0}]
[]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$47","v":0},{"$f":"IF(AND($J209=\"Ja\",$J211=\"Ja\"),I_Financiering!K10,0)","v":0},null,{"$f":"IF(J209=\"Ja\",I_Financiering!M10,\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M211,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M211,I_Verdeelsleutel!$E$11:$E$21,0))*$K211,0)","v":0}]
[]
[null,null,null,"3.4",null,"Totale rentelasten"]
[]
[null,null,null,null,null,{"$f":"F157","v":"Bestaande rentelasten"},null,null,"EUR / jaar",null,{"$f":"K157","v":0},null,null,null,null,null,{"$f":"Q157","v":0}]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / jaar",null,{"$f":"IF($J$159=\"Ja\",SUM(K165,K171,K177,K183,K189,K195,K201,K207),K211)","v":0},null,null,null,null,null,{"$f":"IF($J$159=\"Ja\",SUM(Q165,Q171,Q177,Q183,Q189,Q195,Q201,Q207),Q211)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K215:K216)","v":0},null,null,null,null,null,{"$f":"SUM(Q215:Q216)","v":0}]
[]
[null,null,"4.",{"$f":"I_Kosten!D49","v":"Directe overige kosten"}]
[]
[null,null,null,"4.1",null,"Huisvestingskosten - eenvoudige invoer",null,null,null,{"$f":"IF(J226=\"Ja\",\"Nee\",IF(J226=0,0,\"Ja\"))","v":0}]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E57","v":"Huisvestingskosten"},null,null,"EUR / jaar",null,{"$f":"IF($J$222=\"Ja\",I_Kosten!K57,0)","v":0},null,{"$f":"I_Kosten!M57","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M224,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M224,I_Verdeelsleutel!$E$11:$E$21,0))*$K224,0)","v":0}]
[]
[null,null,null,"4.2",null,"Huisvestingskosten - detail invoer",null,null,null,{"$f":"I_Kosten!G55","v":0}]
[]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F59=\"\",\"\",I_Kosten!F59)","v":"Huisvestingskosten - Huur"},null,null,"EUR / jaar",null,{"$f":"IF($J$226=\"Ja\",I_Kosten!K59,0)","v":0},null,{"$f":"I_Kosten!M59","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M228,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M228,I_Verdeelsleutel!$E$11:$E$21,0))*$K228,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F61=\"\",\"\",I_Kosten!F61)","v":"Huisvestingskosten - Onderhoud"},null,null,"EUR / jaar",null,{"$f":"IF($J$226=\"Ja\",I_Kosten!K61,0)","v":0},null,{"$f":"I_Kosten!M61","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M229,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M229,I_Verdeelsleutel!$E$11:$E$21,0))*$K229,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F63=\"\",\"\",I_Kosten!F63)","v":"Huisvestingskosten - Verzekeringen"},null,null,"EUR / jaar",null,{"$f":"IF($J$226=\"Ja\",I_Kosten!K63,0)","v":0},null,{"$f":"I_Kosten!M63","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M230,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M230,I_Verdeelsleutel!$E$11:$E$21,0))*$K230,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F65=\"\",\"\",I_Kosten!F65)","v":""},null,null,"EUR / jaar",null,{"$f":"IF($J$226=\"Ja\",I_Kosten!K65,0)","v":0},null,{"$f":"I_Kosten!M65","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M231,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M231,I_Verdeelsleutel!$E$11:$E$21,0))*$K231,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F67=\"\",\"\",I_Kosten!F67)","v":""},null,null,"EUR / jaar",null,{"$f":"IF($J$226=\"Ja\",I_Kosten!K67,0)","v":0},null,{"$f":"I_Kosten!M67","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M232,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M232,I_Verdeelsleutel!$E$11:$E$21,0))*$K232,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F69=\"\",\"\",I_Kosten!F69)","v":""},null,null,"EUR / jaar",null,{"$f":"IF($J$226=\"Ja\",I_Kosten!K69,0)","v":0},null,{"$f":"I_Kosten!M69","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M233,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M233,I_Verdeelsleutel!$E$11:$E$21,0))*$K233,0)","v":0}]
[]
[null,null,null,"4.3",null,"Huisvestingskosten - totaal"]
[]
[null,null,null,null,null,{"$f":"F224","v":"Huisvestingskosten"},null,null,"EUR / jaar",null,{"$f":"IF($J$222=\"Ja\",K224,SUM(K228:K233))","v":0},null,null,null,null,null,{"$f":"IF($J$222=\"Ja\",Q224,SUM(Q228:Q233))","v":0}]
[]
[null,null,null,"4.4",null,"Directe overige kosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E51","v":"Leasekosten werkplaatsapparatuur"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K51","v":0},null,{"$f":"I_Kosten!M51","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M241,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M241,I_Verdeelsleutel!$E$11:$E$21,0))*$K241,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E53","v":"Garantiekosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K53","v":0},null,{"$f":"I_Kosten!M53","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M242,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M242,I_Verdeelsleutel!$E$11:$E$21,0))*$K242,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F71=\"\",\"\",I_Kosten!F71)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K71","v":0},null,{"$f":"I_Kosten!M71","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M243,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M243,I_Verdeelsleutel!$E$11:$E$21,0))*$K243,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F73=\"\",\"\",I_Kosten!F73)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K73","v":0},null,{"$f":"I_Kosten!M73","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M244,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M244,I_Verdeelsleutel!$E$11:$E$21,0))*$K244,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F75=\"\",\"\",I_Kosten!F75)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K75","v":0},null,{"$f":"I_Kosten!M75","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M245,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M245,I_Verdeelsleutel!$E$11:$E$21,0))*$K245,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F77=\"\",\"\",I_Kosten!F77)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K77","v":0},null,{"$f":"I_Kosten!M77","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M246,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M246,I_Verdeelsleutel!$E$11:$E$21,0))*$K246,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F79=\"\",\"\",I_Kosten!F79)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K79","v":0},null,{"$f":"I_Kosten!M79","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M247,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M247,I_Verdeelsleutel!$E$11:$E$21,0))*$K247,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F81=\"\",\"\",I_Kosten!F81)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K81","v":0},null,{"$f":"I_Kosten!M81","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M248,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M248,I_Verdeelsleutel!$E$11:$E$21,0))*$K248,0)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K237,K241:K248)","v":0},null,null,null,null,null,{"$f":"SUM(Q237,Q241:Q248)","v":0}]
[]
[null,null,"5.",{"$f":"I_Kosten!D83","v":"Overige indirecte kosten"}]
[]
[null,null,null,"5.1",null,"Indirecte overige kosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E85","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K85","v":0},null,{"$f":"I_Kosten!M85","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M256,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M256,I_Verdeelsleutel!$E$11:$E$21,0))*$K256,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E87","v":"IT kosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K87","v":0},null,{"$f":"I_Kosten!M87","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M257,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M257,I_Verdeelsleutel!$E$11:$E$21,0))*$K257,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E89","v":"Energiekosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K89","v":0},null,{"$f":"I_Kosten!M89","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M258,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M258,I_Verdeelsleutel!$E$11:$E$21,0))*$K258,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E91","v":"Marketingkosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K91","v":0},null,{"$f":"I_Kosten!M91","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M259,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M259,I_Verdeelsleutel!$E$11:$E$21,0))*$K259,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F93=\"\",\"\",I_Kosten!F93)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K93","v":0},null,{"$f":"I_Kosten!M93","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M260,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M260,I_Verdeelsleutel!$E$11:$E$21,0))*$K260,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F95=\"\",\"\",I_Kosten!F95)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K95","v":0},null,{"$f":"I_Kosten!M95","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M261,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M261,I_Verdeelsleutel!$E$11:$E$21,0))*$K261,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F97=\"\",\"\",I_Kosten!F97)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K97","v":0},null,{"$f":"I_Kosten!M97","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M262,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M262,I_Verdeelsleutel!$E$11:$E$21,0))*$K262,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F99=\"\",\"\",I_Kosten!F99)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K99","v":0},null,{"$f":"I_Kosten!M99","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M263,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M263,I_Verdeelsleutel!$E$11:$E$21,0))*$K263,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F101=\"\",\"\",I_Kosten!F101)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K101","v":0},null,{"$f":"I_Kosten!M101","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M264,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M264,I_Verdeelsleutel!$E$11:$E$21,0))*$K264,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F103=\"\",\"\",I_Kosten!F103)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K103","v":0},null,{"$f":"I_Kosten!M103","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M265,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M265,I_Verdeelsleutel!$E$11:$E$21,0))*$K265,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F105=\"\",\"\",I_Kosten!F105)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K105","v":0},null,{"$f":"I_Kosten!M105","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M266,I_Verdeelsleutel!$E$11:$E$21,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$21,MATCH($M266,I_Verdeelsleutel!$E$11:$E$21,0))*$K266,0)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K256:K266)","v":0},null,null,null,null,null,{"$f":"SUM(Q256:Q266)","v":0}]
[]
[null,null,"6.","Totale kosten"]
[]
[null,null,null,"6.1",null,"Totale kosten"]
[]
[null,null,null,null,null,"Directe personeelskosten",null,null,"EUR / jaar",null,{"$f":"SUM(K45:K46)","v":0},null,null,null,null,null,{"$f":"SUM(Q45:Q46)","v":0}]
[null,null,null,null,null,"Indirecte personeelskosten",null,null,"EUR / jaar",null,{"$f":"SUM(K47:K48)","v":0},null,null,null,null,null,{"$f":"SUM(Q47:Q48)","v":0}]
[null,null,null,null,null,"Directe afschrijvingslasten",null,null,"EUR / jaar",null,{"$f":"K146+K148","v":0},null,null,null,null,null,{"$f":"Q146+Q148","v":0}]
[null,null,null,null,null,"Indirecte afschrijvingslasten",null,null,"EUR / jaar",null,{"$f":"SUM(K147,K149)","v":0},null,null,null,null,null,{"$f":"SUM(Q147,Q149)","v":0}]
[null,null,null,null,null,"Rentelasten",null,null,"EUR / jaar",null,{"$f":"K218","v":0},null,null,null,null,null,{"$f":"Q218","v":0}]
[null,null,null,null,null,"Directe overige kosten",null,null,"EUR / jaar",null,{"$f":"K250","v":0},null,null,null,null,null,{"$f":"Q250","v":0}]
[null,null,null,null,null,"Indirecte overige kosten",null,null,"EUR / jaar",null,{"$f":"K268","v":0},null,null,null,null,null,{"$f":"Q268","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K274:K280)","v":0},null,null,null,null,null,{"$f":"SUM(Q274:Q280)","v":0}]
[]
[null,null,"7.",{"$f":"\"Productie \"&I_Generiek!$F$9","v":"Productie "}]
[]
[null,null,null,"7.1",null,{"$f":"\"Productie \"&I_Generiek!$F$9","v":"Productie "}]
[]
[null,null,null,null,null,{"$f":"I_Generiek!E14","v":"Gefactureerde uren "},null,null,"Uren",null,{"$f":"I_Generiek!F18","v":0}]
[]
[null,null,"8.","Kostprijs"]
[]
[null,null,null,"8.1",null,"Hoofd kostenelementen"]
[]
[null,null,null,null,null,{"$f":"F274","v":"Directe personeelskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K274/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q274/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F275","v":"Indirecte personeelskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K275/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q275/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F276","v":"Directe afschrijvingslasten"},null,null,"EUR / uur",null,0,null,null,null,null,null,{"$f":"IFERROR(Q276/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F277","v":"Indirecte afschrijvingslasten"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F278","v":"Rentelasten"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"Directe overige kosten",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"Indirecte overige kosten",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / uur",null,{"$f":"SUM(K294:K300)","v":0},null,null,null,null,null,{"$f":"SUM(Q294:Q300)","v":0}]
[]
[null,null,null,"8.2",null,"Alle kostenelementen"]
[]
[null,null,null,null,null,{"$f":"F20","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / uur",null,{"$f":"IFERROR(K20/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q20/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten) - In loondienst"},null,null,"EUR / uur",null,{"$f":"IFERROR(K15/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q15/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F16","v":"Totale personeelskosten direct personeel (excl. opleidingskosten) - Ingehuurd personeel"},null,null,"EUR / uur",null,{"$f":"IFERROR(K16/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q16/$K$288,0)","v":0}]
[null,null,null,null,null,"Opleidingskosten direct personeel",null,null,"EUR / uur",null,{"$f":"IFERROR(K24/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q24/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F37","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / uur",null,{"$f":"IFERROR(K37/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q37/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F32","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten) - In loondienst"},null,null,"EUR / uur",null,{"$f":"IFERROR(K32/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q32/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F33","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten) - Ingehuurd personeel"},null,null,"EUR / uur",null,{"$f":"IFERROR(K33/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q33/$K$288,0)","v":0}]
[null,null,null,null,null,"Opleidingskosten indirect personeel",null,null,"EUR / uur",null,{"$f":"IFERROR(K41/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q41/$K$288,0)","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - direct",null,null,"EUR / uur",null,{"$f":"IFERROR(K146/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q146/$K$288,0)","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - indirect",null,null,"EUR / uur",null,{"$f":"IFERROR(K147/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q147/$K$288,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - direct",null,null,"EUR / uur",null,{"$f":"IFERROR(K148/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q148/$K$288,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR / uur",null,{"$f":"IFERROR(K149/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q149/$K$288,0)","v":0}]
[null,null,null,null,null,"Bestaande rentelasten",null,null,"EUR / uur",null,{"$f":"IFERROR(K215/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q215/$K$288,0)","v":0}]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / uur",null,{"$f":"IFERROR(K216/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q216/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F241","v":"Leasekosten werkplaatsapparatuur"},null,null,"EUR / uur",null,{"$f":"IFERROR(K241/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q241/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F242","v":"Garantiekosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K242/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q242/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F224","v":"Huisvestingskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K237/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q237/$K$288,0)","v":0}]
[null,null,null,null,null,{"$f":"F243","v":""},null,null,"EUR / uur",null,{"$f":"IFERROR(K243/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q243/$K$288,0)","v":0}]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F256","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / uur",null,{"$f":"IFERROR(K256/$K$288,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q256/$K$288,0)","v":0}]
[null,null,null,null,null,"IT kosten",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"Energiekosten",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"Marketingkosten",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / uur",null,{"$f":"SUM(K306,K309:K310,K313:K339)","v":0},null,null,null,null,null,{"$f":"SUM(Q306,Q309:Q310,Q313:Q339)","v":0}]

{"sheet":"C_Scenario","index":12,"n_rows":284,"n_cols":17,"rows_kept":284,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | C_Scenario"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"C_Scenario"}]
[null,null,"Calculatie_Scenario"]
[null,null,null,null,null,null,null,null,null,null,"Base werkplaats",null,"Gekozen draaiknop (%)",null,"Scenario werkplaats",null,"Scenario actief?"]
[]
[null,null,"1.","Personeelskosten"]
[]
[]
[null,null,null,"1.1",null,"Direct personeel - personeelskosten (excl. opleidingskosten) - Eenvoudige invoer",null,null,null,{"$f":"IF(J24=\"Ja\",\"Nee\",IF(J24=0,0,\"Ja\"))","v":0}]
[]
[null,null,null,null,"1.1.1","Draaiknoppen van toepassing - Directe personeelskosten (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$9","v":"CAO-ontwikkeling"},null,null,{"$f":"IF(O_Dashboard!$O$15=TRUE,O_Dashboard!$P$13,0)","v":0}]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$23","v":"Krapte arbeidsmarkt"},null,null,{"$f":"IF(O_Dashboard!$O$27=TRUE,O_Dashboard!$P$27,0)","v":0}]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$34","v":"Parttime werken"},null,null,{"$f":"IF(O_Dashboard!$O$38=TRUE,O_Dashboard!$P$38,0)","v":0}]
[]
[null,null,null,null,"1.1.2","Totale impact van de gekozen draaiknoppen",null,null,{"$f":"SUM(I14:I16)","v":0}]
[]
[null,null,null,null,"1.1.3","Totale personeelskosten direct personeel (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q11","v":0},null,{"$f":"I18","v":0},null,{"$f":"$K22*(1+$M22)","v":0},null,{"$f":"IF(AND(I14=0,I15=0,I16=0),CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,"1.2",null,"Direct personeel - personeelskosten (excl. opleidingskosten) - Detail invoer",null,null,null,{"$f":"I_Kosten!G13","v":0}]
[]
[null,null,null,null,"1.2.1","Draaiknoppen van toepassing - Direct personeel (excl. opleidingskosten) - in loondienst"]
[]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$9","v":"CAO-ontwikkeling"},null,null,{"$f":"IF(O_Dashboard!$O$20=TRUE,O_Dashboard!$P$20,0)","v":0}]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$23","v":"Krapte arbeidsmarkt"},null,null,{"$f":"IF(O_Dashboard!$O$31=TRUE,O_Dashboard!$P$31,0)","v":0}]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$34","v":"Parttime werken"},null,null,{"$f":"IF(O_Dashboard!$O$43=TRUE,O_Dashboard!$P$43,0)","v":0}]
[]
[null,null,null,null,"1.2.2","Totale impact van de gekozen draaiknoppen",null,null,{"$f":"SUM(I28:I30)","v":0}]
[]
[null,null,null,null,"1.2.3","Totale personeelskosten direct personeel (excl. opleidingskosten) - in loondienst"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!F17","v":"Totale personeelskosten direct personeel (excl. opleidingskosten) - In loondienst"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q15","v":0},null,{"$f":"I32","v":0},null,{"$f":"$K36*(1+$M36)","v":0},null,{"$f":"IF(AND(I28=0,I29=0,I30=0),CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,"1.2.4","Draaiknoppen van toepassing - Direct personeel (excl. opleidingskosten) - ingehuurd personeel"]
[]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$23","v":"Krapte arbeidsmarkt"},null,null,{"$f":"IF(O_Dashboard!$O$32=TRUE,O_Dashboard!$P$32,0)","v":0}]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$34","v":"Parttime werken"},null,null,{"$f":"IF(O_Dashboard!$O$44=TRUE,O_Dashboard!$P$44,0)","v":0}]
[]
[null,null,null,null,"1.2.5","Totale impact van de gekozen draaiknoppen",null,null,{"$f":"SUM(I40:I41)","v":0}]
[]
[null,null,null,null,"1.2.6","Totale personeelskosten direct personeel (excl. opleidingskosten) - ingehuurd personeel"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!F19","v":"Totale personeelskosten direct personeel (excl. opleidingskosten) - Ingehuurd personeel"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q16","v":0},null,{"$f":"I43","v":0},null,{"$f":"$K47*(1+$M47)","v":0},null,{"$f":"IF(AND(I40=0,I41=0),CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,"1.3",null,"Totale personeelskosten direct personeel (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"SUM(K22,K36,K47)","v":0},null,null,null,{"$f":"SUM(O22,O36,O47)","v":0}]
[]
[null,null,null,"1.4",null,"Direct personeel - opleidingskosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E21","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q24","v":0},null,null,null,{"$f":"K55","v":0}]
[]
[null,null,null,"1.5",null,"Indirect personeel - personeelskosten (excl. opleidingskosten) - Eenvoudige invoer",null,null,null,{"$f":"IF(J70=\"Ja\",\"Nee\",IF(J70=0,0,\"Ja\"))","v":0}]
[]
[null,null,null,null,"1.5.1","Draaiknoppen van toepassing - Indirecte personeelskosten (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$9","v":"CAO-ontwikkeling"},null,null,{"$f":"IF(O_Dashboard!$O$16=TRUE,O_Dashboard!$P$13,0)","v":0}]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$34","v":"Parttime werken"},null,null,{"$f":"IF(O_Dashboard!$O$39=TRUE,O_Dashboard!$P$39,0)","v":0}]
[]
[null,null,null,null,"1.5.2","Totale impact van de gekozen draaiknoppen",null,null,{"$f":"SUM(I61:I62)","v":0}]
[]
[null,null,null,null,"1.5.3","Totale personeelskosten indirect personeel (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"C_Base!F37","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q28","v":0},null,{"$f":"I64","v":0},null,{"$f":"$K68*(1+$M68)","v":0},null,{"$f":"IF(AND(I61=0,I62=0),CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,"1.6",null,"Indirect personeel - personeelskosten (excl. opleidingskosten) - Detail invoer",null,null,null,{"$f":"I_Kosten!G25","v":0}]
[]
[null,null,null,null,"1.6.1","Draaiknoppen van toepassing - Indirect personeel (excl. opleidingskosten) - in loondienst"]
[]
[null,null,null,null,null,"CAO-ontwikkeling",null,null,{"$f":"IF(O_Dashboard!$O$21=TRUE,O_Dashboard!$P$21,0)","v":0}]
[null,null,null,null,null,"Parttime werken",null,null,{"$f":"IF(O_Dashboard!$O$45=TRUE,O_Dashboard!$P$45,0)","v":0}]
[]
[null,null,null,null,"1.6.2","Totale impact van de gekozen draaiknoppen",null,null,{"$f":"SUM(I74:I75)","v":0}]
[]
[null,null,null,null,"1.6.3","Totale personeelskosten indirect personeel (excl. opleidingskosten) - in loondienst"]
[]
[null,null,null,null,null,{"$f":"C_Base!F32","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten) - In loondienst"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q32","v":0},null,{"$f":"I77","v":0},null,{"$f":"$K81*(1+$M81)","v":0},null,{"$f":"IF(AND(I74=0,I75=0),CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,"1.6.4","Draaiknoppen van toepassing - indirect personeel (excl. opleidingskosten) - ingehuurd personeel"]
[]
[null,null,null,null,null,{"$f":"O_Dashboard!$N$34","v":"Parttime werken"},null,null,{"$f":"IF(O_Dashboard!$O$46=TRUE,O_Dashboard!$P$46,0)","v":0}]
[]
[null,null,null,null,"1.6.5","Totale personeelskosten direct personeel (excl. opleidingskosten) - ingehuurd personeel"]
[]
[null,null,null,null,null,{"$f":"C_Base!F33","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten) - Ingehuurd personeel"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q33","v":0},null,{"$f":"I85","v":0},null,{"$f":"$K89*(1+$M89)","v":0},null,{"$f":"IF(I85=0,CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,"1.7",null,"Totale personeelskosten indirect personeel (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"C_Base!F37","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"SUM(K68,K81,K89)","v":0},null,null,null,{"$f":"SUM(O68,O81,O89)","v":0}]
[]
[null,null,null,"1.8",null,"Indirect personeel - opleidingskosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E33","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q41","v":0},null,null,null,{"$f":"K97","v":0}]
[]
[null,null,null,"1.9",null,"Totale personeelskosten"]
[]
[null,null,null,null,null,{"$f":"F51","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K51","v":0},null,null,null,{"$f":"O51","v":0}]
[null,null,null,null,null,{"$f":"F55","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"K55","v":0},null,null,null,{"$f":"O55","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F47","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K93","v":0},null,null,null,{"$f":"O93","v":0}]
[null,null,null,null,null,{"$f":"F97","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"K97","v":0},null,null,null,{"$f":"O97","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K101:K104)","v":0},null,null,null,{"$f":"SUM(O101:O104)","v":0}]
[]
[]
[null,null,"2.",{"$f":"I_Kosten!D35","v":"Afschrijvingen"}]
[]
[null,null,null,"2.1",null,"Totale afschrijvingslasten"]
[]
[null,null,null,null,null,{"$f":"O_Dashboard!D39","v":"Bestaande afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q56","v":0},null,{"$f":"O_Dashboard!I39","v":0},null,{"$f":"IF(M113<>\"\",K113*(1+M113),K113)","v":0},null,{"$f":"IF(O_Dashboard!H39=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"O_Dashboard!D40","v":"Bestaande afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q57","v":0},null,{"$f":"O_Dashboard!I40","v":0},null,{"$f":"IF(M114<>\"\",K114*(1+M114),K114)","v":0},null,{"$f":"IF(O_Dashboard!H40=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"O_Dashboard!D41","v":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q148","v":0},null,{"$f":"O_Dashboard!I41","v":0},null,{"$f":"IF(M115<>\"\",K115*(1+M115),K115)","v":0},null,{"$f":"IF(O_Dashboard!H41=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"O_Dashboard!D42","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q149","v":0},null,{"$f":"O_Dashboard!I42","v":0},null,0,null,{"$f":"IF(O_Dashboard!H42=1000,CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K113:K116)","v":0},null,null,null,{"$f":"SUM(O113:O116)","v":0}]
[]
[null,null,"3.",{"$f":"C_Base!D153","v":"Rentelasten"}]
[]
[null,null,null,"3.1",null,"Nieuwe rentelasten (als gevolg van nieuwe financiering)"]
[]
[null,null,null,null,"3.1.1","Financiering 1"]
[null,null,null,null,null,{"$f":"I_Financiering!F15","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"IFERROR(C_Base!K162*C_Base!O165,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L73=\"\",K125,O_Dashboard!L73)","v":0},null,{"$f":"IF(O_Dashboard!L73=\"\",CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"I_Financiering!F16","v":"Rentepercentage "},null,null,"% / jaar",null,{"$f":"I_Financiering!K16","v":0},null,"N.v.t.",null,{"$f":"IF(O_Dashboard!L74=\"\",K126,O_Dashboard!L74)","v":0},null,{"$f":"IF(O_Dashboard!L74=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K125*K126,0)","v":0},null,null,null,{"$f":"IFERROR(O125*O126,0)","v":0},null,{"$f":"IF(OR(Q125=CHAR(252),Q126=CHAR(252)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,null,"3.1.2","Financiering 2"]
[null,null,null,null,null,{"$f":"I_Financiering!F19","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"IFERROR(C_Base!K168*C_Base!O171,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L77=\"\",K131,O_Dashboard!L77)","v":0},null,{"$f":"IF(O_Dashboard!L77=\"\",CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"I_Financiering!F20","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K20","v":0},null,"N.v.t.",null,{"$f":"IF(O_Dashboard!L78=\"\",K132,O_Dashboard!L78)","v":0},null,{"$f":"IF(O_Dashboard!L78=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K131*K132,0)","v":0},null,null,null,{"$f":"IFERROR(O131*O132,0)","v":0},null,{"$f":"IF(OR(Q131=CHAR(252),Q132=CHAR(252)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,null,"3.1.3","Financiering 3"]
[null,null,null,null,null,{"$f":"I_Financiering!F23","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"IFERROR(C_Base!K174*C_Base!O177,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L81=\"\",K137,O_Dashboard!L81)","v":0},null,{"$f":"IF(O_Dashboard!L81=\"\",CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"I_Financiering!F24","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K24","v":0},null,"N.v.t.",null,{"$f":"IF(O_Dashboard!L82=\"\",K138,O_Dashboard!L82)","v":0},null,{"$f":"IF(O_Dashboard!L82=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K137*K138,0)","v":0},null,null,null,{"$f":"IFERROR(O137*O138,0)","v":0},null,{"$f":"IF(OR(Q137=CHAR(252),Q138=CHAR(252)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,null,"3.1.4","Financiering 4"]
[null,null,null,null,null,{"$f":"I_Financiering!F27","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"IFERROR(C_Base!K180*C_Base!O183,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L85=\"\",K143,O_Dashboard!L85)","v":0},null,{"$f":"IF(O_Dashboard!L85=\"\",CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"I_Financiering!F28","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K28","v":0},null,"N.v.t.",null,{"$f":"IF(O_Dashboard!L86=\"\",K144,O_Dashboard!L86)","v":0},null,{"$f":"IF(O_Dashboard!L86=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K143*K144,0)","v":0},null,null,null,{"$f":"IFERROR(O143*O144,0)","v":0},null,{"$f":"IF(OR(Q143=CHAR(252),Q144=CHAR(252)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,null,"3.1.5","Financiering 5"]
[null,null,null,null,null,{"$f":"I_Financiering!F31","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"IFERROR(C_Base!K186*C_Base!O189,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L89=\"\",K149,O_Dashboard!L89)","v":0},null,{"$f":"IF(O_Dashboard!L89=\"\",CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"I_Financiering!F32","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K32","v":0},null,"N.v.t.",null,{"$f":"IF(O_Dashboard!L90=\"\",K150,O_Dashboard!L90)","v":0},null,{"$f":"IF(O_Dashboard!L90=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K149*K150,0)","v":0},null,null,null,{"$f":"IFERROR(O149*O150,0)","v":0},null,{"$f":"IF(OR(Q149=CHAR(252),Q150=CHAR(252)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,null,"3.1.6","Financiering 6"]
[null,null,null,null,null,{"$f":"I_Financiering!F35","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"IFERROR(C_Base!K192*C_Base!O195,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L93=\"\",K155,O_Dashboard!L93)","v":0},null,{"$f":"IF(O_Dashboard!L93=\"\",CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"I_Financiering!F36","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K36","v":0},null,"N.v.t.",null,{"$f":"IF(O_Dashboard!L94=\"\",K156,O_Dashboard!L94)","v":0},null,{"$f":"IF(O_Dashboard!L94=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K155*K156,0)","v":0},null,null,null,{"$f":"IFERROR(O155*O156,0)","v":0},null,{"$f":"IF(OR(Q155=CHAR(252),Q156=CHAR(252)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,null,"3.1.7","Financiering 7"]
[null,null,null,null,null,{"$f":"I_Financiering!F39","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"IFERROR(C_Base!K198*C_Base!O201,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L97=\"\",K161,O_Dashboard!L97)","v":0},null,{"$f":"IF(O_Dashboard!L97=\"\",CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"I_Financiering!F40","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K40","v":0},null,"N.v.t.",null,{"$f":"IF(O_Dashboard!L98=\"\",K162,O_Dashboard!L98)","v":0},null,{"$f":"IF(O_Dashboard!L98=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K161*K162,0)","v":0},null,null,null,{"$f":"IFERROR(O161*O162,0)","v":0},null,{"$f":"IF(OR(Q161=CHAR(252),Q162=CHAR(252)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,null,"3.1.8","Financiering 8"]
[null,null,null,null,null,{"$f":"I_Financiering!F43","v":"Financieringsbedrag"},null,null,"EUR",null,{"$f":"IFERROR(C_Base!K204*C_Base!O207,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L101=\"\",K167,O_Dashboard!L101)","v":0},null,{"$f":"IF(O_Dashboard!L101=\"\",CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"I_Financiering!F44","v":"Rentepercentage"},null,null,"% / jaar",null,{"$f":"I_Financiering!K44","v":0},null,"N.v.t.",null,{"$f":"IF(O_Dashboard!L102=\"\",K168,O_Dashboard!L102)","v":0},null,{"$f":"IF(O_Dashboard!L102=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K167*K168,0)","v":0},null,null,null,{"$f":"IFERROR(O167*O168,0)","v":0},null,{"$f":"IF(OR(Q167=CHAR(252),Q168=CHAR(252)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,"3.2",null,"Totale rentelasten"]
[]
[null,null,null,null,null,"Bestaande rentelasten",null,null,"EUR / jaar",null,{"$f":"C_Base!Q215","v":0},null,{"$f":"IF(O_Dashboard!N51=1,O_Dashboard!$P$59,IF(O_Dashboard!N51=2,O_Dashboard!$P$62,IF(O_Dashboard!N51=4,0,\"N.v.t.\")))","v":0},null,{"$f":"IF(O_Dashboard!N51=1,K174*(1+M174),IF(O_Dashboard!N51=2,K174*(1+M174),IF(O_Dashboard!N51=4,K174,0)))","v":0},null,{"$f":"IF(OR(O_Dashboard!N51=4,O_Dashboard!N51=0),CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / jaar",null,{"$f":"C_Base!Q216","v":0},null,{"$f":"IF(COUNT(O_Dashboard!$L$73:$M$102)>0,\"N.v.t.\",O_Dashboard!I68)","v":"N.v.t."},null,{"$f":"IF(C_Base!$J$209=\"Ja\",IF(O_Dashboard!I68<>\"\",K175*(1+O_Dashboard!I68),K175),SUM(C_Scenario!O128,C_Scenario!O134,C_Scenario!O140,C_Scenario!O146,C_Scenario!O152,C_Scenario!O158,C_Scenario!O164,C_Scenario!O170))","v":0},null,{"$f":"IF(OR(COUNT(O_Dashboard!$L$73:$M$102)>0,AND(O_Dashboard!$I$68<>\"N.v.t.\",O_Dashboard!$I$68<>0)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K174:K175)","v":0},null,null,null,{"$f":"SUM(O174:O175)","v":0}]
[]
[null,null,"4.",{"$f":"C_Base!D220","v":"Directe overige kosten"}]
[]
[null,null,null,"4.1",null,"Directe overige kosten"]
[]
[null,null,null,null,null,{"$f":"C_Base!F241","v":"Leasekosten werkplaatsapparatuur"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q241","v":0},null,{"$f":"O_Dashboard!I13","v":0},null,{"$f":"IF(M183<>\"\",K183*(1+M183),K183)","v":0},null,{"$f":"IF(O_Dashboard!H13=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F242","v":"Garantiekosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q242","v":0},null,{"$f":"O_Dashboard!I14","v":0},null,{"$f":"IF(M184<>\"\",K184*(1+M184),K184)","v":0},null,{"$f":"IF(O_Dashboard!H14=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F224","v":"Huisvestingskosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q237","v":0},null,{"$f":"O_Dashboard!I15","v":0},null,0,null,{"$f":"IF(O_Dashboard!H15=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F243","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q243","v":0},null,{"$f":"O_Dashboard!I16","v":""},null,0,null,{"$f":"IF(O_Dashboard!H16=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F244","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q244","v":0},null,{"$f":"O_Dashboard!I17","v":""},null,0,null,{"$f":"IF(O_Dashboard!H17=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F245","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q245","v":0},null,{"$f":"O_Dashboard!I18","v":""},null,0,null,{"$f":"IF(O_Dashboard!H18=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F246","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q246","v":0},null,{"$f":"O_Dashboard!I19","v":""},null,0,null,{"$f":"IF(O_Dashboard!H19=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F247","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q247","v":0},null,{"$f":"O_Dashboard!I20","v":""},null,0,null,{"$f":"IF(O_Dashboard!H20=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F248","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q248","v":0},null,{"$f":"O_Dashboard!I21","v":""},null,0,null,{"$f":"IF(O_Dashboard!H21=1000,CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K183:K191)","v":0},null,null,null,{"$f":"SUM(O183:O191)","v":0}]
[]
[null,null,"5.",{"$f":"C_Base!D252","v":"Overige indirecte kosten"}]
[]
[null,null,null,"5.1",null,"Indirecte overige kosten"]
[]
[null,null,null,null,null,{"$f":"C_Base!F256","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q256","v":0},null,{"$f":"O_Dashboard!I25","v":0},null,{"$f":"IF(M199<>\"\",K199*(1+M199),K199)","v":0},null,{"$f":"IF(O_Dashboard!H25=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F257","v":"IT kosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q257","v":0},null,{"$f":"O_Dashboard!I26","v":0},null,{"$f":"IF(M200<>\"\",K200*(1+M200),K200)","v":0},null,{"$f":"IF(O_Dashboard!H26=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F258","v":"Energiekosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q258","v":0},null,{"$f":"O_Dashboard!I27","v":0},null,0,null,{"$f":"IF(O_Dashboard!H27=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F259","v":"Marketingkosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q259","v":0},null,{"$f":"O_Dashboard!I28","v":0},null,0,null,{"$f":"IF(O_Dashboard!H28=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F260","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q260","v":0},null,{"$f":"O_Dashboard!I29","v":""},null,0,null,{"$f":"IF(O_Dashboard!H29=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F261","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q261","v":0},null,{"$f":"O_Dashboard!I30","v":""},null,0,null,{"$f":"IF(O_Dashboard!H30=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F262","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q262","v":0},null,{"$f":"O_Dashboard!I31","v":""},null,0,null,{"$f":"IF(O_Dashboard!H31=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F263","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q263","v":0},null,{"$f":"O_Dashboard!I32","v":""},null,0,null,{"$f":"IF(O_Dashboard!H32=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F264","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q264","v":0},null,{"$f":"O_Dashboard!I33","v":""},null,0,null,{"$f":"IF(O_Dashboard!H33=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F265","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q265","v":0},null,{"$f":"O_Dashboard!I34","v":""},null,0,null,{"$f":"IF(O_Dashboard!H34=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F266","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q266","v":0},null,{"$f":"O_Dashboard!I35","v":""},null,0,null,{"$f":"IF(O_Dashboard!H35=1000,CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K199:K209)","v":0},null,null,null,{"$f":"SUM(O199:O209)","v":0}]
[]
[null,null,"6.","Totale kosten"]
[]
[null,null,null,"6.1",null,"Totale kosten"]
[]
[null,null,null,null,null,"Directe personeelskosten",null,null,"EUR / jaar",null,{"$f":"SUM(K51,K55)","v":0},null,null,null,{"$f":"SUM(O51,O55)","v":0}]
[null,null,null,null,null,"Indirecte personeelskosten",null,null,"EUR / jaar",null,{"$f":"SUM(K93,K97)","v":0},null,null,null,{"$f":"SUM(O93,O97)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F276","v":"Directe afschrijvingslasten"},null,null,"EUR / jaar",null,{"$f":"SUM(K113,K115)","v":0},null,null,null,{"$f":"SUM(O113,O115)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F277","v":"Indirecte afschrijvingslasten"},null,null,"EUR / jaar",null,{"$f":"SUM(K114,K116)","v":0},null,null,null,{"$f":"SUM(O114,O116)","v":0}]
[null,null,null,null,null,"Rentelasten",null,null,"EUR / jaar",null,{"$f":"K177","v":0},null,null,null,{"$f":"O177","v":0}]
[null,null,null,null,null,"Directe overige kosten",null,null,"EUR / jaar",null,{"$f":"K193","v":0},null,null,null,{"$f":"O193","v":0}]
[null,null,null,null,null,"Indirecte overige kosten",null,null,"EUR / jaar",null,{"$f":"K211","v":0},null,null,null,{"$f":"O211","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K217:K223)","v":0},null,null,null,{"$f":"SUM(O217:O223)","v":0}]
[]
[null,null,"7.",{"$f":"\"Gefactureerde uren \"&I_Generiek!$F$9","v":"Gefactureerde uren "}]
[]
[null,null,null,"7.1",null,{"$f":"\"Gefactureerde uren \"&I_Generiek!$F$9","v":"Gefactureerde uren "}]
[]
[null,null,null,null,null,{"$f":"I_Generiek!E14","v":"Gefactureerde uren "},null,null,"Uren",null,{"$f":"C_Base!K288","v":0}]
[]
[null,null,"8.","Kostprijs"]
[]
[null,null,null,"8.1",null,"Hoofd kostenelementen"]
[]
[null,null,null,null,null,{"$f":"F217","v":"Directe personeelskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K217/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O217/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"F218","v":"Indirecte personeelskosten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"F219","v":"Directe afschrijvingslasten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"F220","v":"Indirecte afschrijvingslasten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"F221","v":"Rentelasten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,"Directe overige kosten",null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,"Indirecte overige kosten",null,null,"EUR / uur",null,0,null,null,null,0]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / uur",null,{"$f":"SUM(K237:K243)","v":0},null,null,null,{"$f":"SUM(O237:O243)","v":0}]
[]
[null,null,null,"8.2",null,"Alle kostenelementen"]
[]
[null,null,null,null,null,{"$f":"C_Base!F306","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / uur",null,{"$f":"IFERROR(K51/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O51/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F307","v":"Totale personeelskosten direct personeel (excl. opleidingskosten) - In loondienst"},null,null,"EUR / uur",null,{"$f":"IFERROR(K36/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O36/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F308","v":"Totale personeelskosten direct personeel (excl. opleidingskosten) - Ingehuurd personeel"},null,null,"EUR / uur",null,{"$f":"IFERROR(K47/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O47/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F309","v":"Opleidingskosten direct personeel"},null,null,"EUR / uur",null,{"$f":"IFERROR(K55/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O55/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F310","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / uur",null,{"$f":"IFERROR(K93/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O93/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F311","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten) - In loondienst"},null,null,"EUR / uur",null,{"$f":"IFERROR(K81/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O81/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F312","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten) - Ingehuurd personeel"},null,null,"EUR / uur",null,{"$f":"IFERROR(K89/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O89/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F313","v":"Opleidingskosten indirect personeel"},null,null,"EUR / uur",null,{"$f":"IFERROR(K97/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O97/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F314","v":"Bestaande afschrijvingslasten - direct"},null,null,"EUR / uur",null,{"$f":"IFERROR(K113/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O113/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F315","v":"Bestaande afschrijvingslasten - indirect"},null,null,"EUR / uur",null,{"$f":"IFERROR(K114/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O114/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F316","v":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / uur",null,{"$f":"IFERROR(K115/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O115/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F317","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / uur",null,{"$f":"IFERROR(K116/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O116/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F318","v":"Bestaande rentelasten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K174/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O174/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F319","v":"Nieuwe rentelasten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K175/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O175/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F320","v":"Leasekosten werkplaatsapparatuur"},null,null,"EUR / uur",null,{"$f":"IFERROR(K183/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O183/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F321","v":"Garantiekosten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F322","v":"Huisvestingskosten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F323","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F324","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F325","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F326","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F327","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F328","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F329","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / uur",null,{"$f":"IFERROR(K199/$K$231,0)","v":0},null,null,null,{"$f":"IFERROR(O199/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F330","v":"IT kosten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F331","v":"Energiekosten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F332","v":"Marketingkosten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F333","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F334","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F335","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F336","v":""},null,null,"EUR / uur",null,0,null,null,null,{"$f":"IFERROR(O206/$K$231,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F337","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F338","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F339","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / uur",null,{"$f":"SUM(K249,K252:K253,K256:K282)","v":0},null,null,null,{"$f":"SUM(O249,O252:O253,O256:O282)","v":0}]

{"sheet":"Output >>>","index":13,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Output >>>"]

{"sheet":"O_Dashboard","index":14,"n_rows":102,"n_cols":38,"rows_kept":102,"cut":false,"hidden":false,"merged":[[72,11,72,12],[73,11,73,12],[76,11,76,12],[77,11,77,12],[80,11,80,12],[81,11,81,12],[84,11,84,12],[85,11,85,12],[88,11,88,12],[89,11,89,12],[101,11,101,12],[92,11,92,12],[93,11,93,12],[96,11,96,12],[97,11,97,12],[100,11,100,12]]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | O_Dashboard"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"O_Dashboard"}]
[null,null,"Dashboard",null,null,null,null,null,null,null,null,null,{"$f":"IF(CHECK!H9=0,\"Alles is juist ingevuld\",\"Er is iets niet juist ingevuld, controleer het tabblad CHECK om te zien wat er ontbreekt\")","v":"Er is iets niet juist ingevuld, controleer het tabblad CHECK om te zien wat er ontbreekt"}]
[]
[]
[null,null,"1.","Scenario analyse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.","Kostprijs werkplaats - INPUT",null,null,null,null,null,null,null,null,null,null,"4.","Verschil kostprijzen"]
[]
[null,null,null,"1.1","Kostenstijgingen / -dalingen",null,null,null,"% / jaar",null,null,null,"1.2","CAO-ontwikkeling",null,"% / jaar"]
[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,null,null,null,null,null,null,"Verschil kostprijzen",null,null,"Eenheid","INPUT","SCENARIO","Verschil"]
[null,null,null,"Directe overige kosten",null,null,null,null,null,null,null,null,"U heeft gekozen voor EENVOUDIGE INVOER"]
[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,null,null,null,null,null,null,{"$f":"C_Scenario!F237","v":"Directe personeelskosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K237","v":0},{"$f":"C_Scenario!O237","v":0},{"$f":"AK12-AJ12","v":0}]
[null,null,null,{"$f":"C_Base!F320","v":"Leasekosten werkplaatsapparatuur"},null,null,null,1000,{"$f":"IF(D13=\"\",\"\",(H13-1000)/1000)","v":0},null,null,null,null,"Loonstijging conform CAO",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F238","v":"Indirecte personeelskosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K238","v":0},{"$f":"C_Scenario!O238","v":0},{"$f":"AK13-AJ13","v":0}]
[null,null,null,{"$f":"C_Base!F321","v":"Garantiekosten"},null,null,null,1000,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F239","v":"Directe afschrijvingslasten"},null,null,"EUR / uur",{"$f":"C_Scenario!K239","v":0},{"$f":"C_Scenario!O239","v":0},0]
[null,null,null,{"$f":"C_Base!F322","v":"Huisvestingskosten"},null,null,null,1000,0,null,null,null,null,{"$f":"IF(I_Kosten!$G$13=\"Ja\",\"N.v.t.\",C_Base!F306)","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F240","v":"Indirecte afschrijvingslasten"},null,null,"EUR / uur",{"$f":"C_Scenario!K240","v":0},{"$f":"C_Scenario!O240","v":0},0]
[null,null,null,{"$f":"C_Base!F323","v":""},null,null,null,1000,"",null,null,null,null,{"$f":"IF(I_Kosten!$G$25=\"Ja\",\"N.v.t.\",C_Base!F310)","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F241","v":"Rentelasten"},null,null,"EUR / uur",{"$f":"C_Scenario!K241","v":0},{"$f":"C_Scenario!O241","v":0},0]
[null,null,null,{"$f":"C_Base!F324","v":""},null,null,null,1000,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F242","v":"Directe overige kosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K242","v":0},{"$f":"C_Scenario!O242","v":0},0]
[null,null,null,{"$f":"C_Base!F325","v":""},null,null,null,1000,"",null,null,null,"U heeft gekozen voor DETAIL INVOER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F243","v":"Indirecte overige kosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K243","v":0},{"$f":"C_Scenario!O243","v":0},0]
[null,null,null,{"$f":"C_Base!F326","v":""},null,null,null,1000,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kostprijs per uur",null,null,"EUR / uur",{"$f":"SUM(AJ12:AJ18)","v":0},{"$f":"SUM(AK12:AK18)","v":0},0]
[null,null,null,{"$f":"C_Base!F327","v":""},null,null,null,1000,"",null,null,null,null,{"$f":"IF(I_Kosten!$G$13=\"Nee\",\"N.v.t.\",\"Directe personeelskosten (excl. opleidingskosten) - in loondienst\")","v":"Directe personeelskosten (excl. opleidingskosten) - in loondienst"},false,0]
[null,null,null,{"$f":"C_Base!F328","v":""},null,null,null,1000,{"$f":"IF(D21=\"\",\"\",(H21-1000)/1000)","v":""},null,null,null,null,{"$f":"IF(I_Kosten!$G$25=\"Nee\",\"N.v.t.\",\"Indirecte personeelskosten (excl. opleidingskosten) - in loondienst\")","v":"Indirecte personeelskosten (excl. opleidingskosten) - in loondienst"},false,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,true]
[null,null,null,"Indirecte overige kosten",null,null,null,null,null,null,null,null,"1.3","Krapte arbeidsmarkt",null,"% / jaar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.","Kostprijs werkplaats - SCENARIO"]
[null,null,null,{"$f":"C_Base!F329","v":"Management fee / Ondernemersbeloning"},null,null,null,1000,{"$f":"IF(D25=\"\",\"\",(H25-1000)/1000)","v":0},null,null,null,"U heeft gekozen voor EENVOUDIGE INVOER"]
[null,null,null,{"$f":"C_Base!F330","v":"IT kosten"},null,null,null,1000,{"$f":"IF(D26=\"\",\"\",(H26-1000)/1000)","v":0}]
[null,null,null,{"$f":"C_Base!F331","v":"Energiekosten"},null,null,null,1000,0,null,null,null,null,{"$f":"IF(I_Kosten!$G$13=\"Ja\",\"N.v.t.\",C_Base!F306)","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},false,0]
[null,null,null,{"$f":"C_Base!F332","v":"Marketingkosten"},null,null,null,1000,0]
[null,null,null,{"$f":"C_Base!F333","v":""},null,null,null,1000,"",null,null,null,"U heeft gekozen voor DETAIL INVOER"]
[null,null,null,{"$f":"C_Base!F334","v":""},null,null,null,1000,""]
[null,null,null,{"$f":"C_Base!F335","v":""},null,null,null,1000,"",null,null,null,null,{"$f":"IF(I_Kosten!$G$13=\"Nee\",\"N.v.t.\",\"Directe personeelskosten (excl. opleidingskosten) - in loondienst\")","v":"Directe personeelskosten (excl. opleidingskosten) - in loondienst"},false,0]
[null,null,null,{"$f":"C_Base!F336","v":""},null,null,null,1000,"",null,null,null,null,{"$f":"IF(I_Kosten!$G$13=\"Nee\",\"N.v.t.\",\"Directe personeelskosten (excl. opleidingskosten) - ingehuurd\")","v":"Directe personeelskosten (excl. opleidingskosten) - ingehuurd"},false,0]
[null,null,null,{"$f":"C_Base!F337","v":""},null,null,null,1000,""]
[null,null,null,{"$f":"C_Base!F338","v":""},null,null,null,1000,"",null,null,null,"1.4","Parttime werken",null,"% / jaar"]
[null,null,null,{"$f":"C_Base!F339","v":""},null,null,null,1000,""]
[null,null,null,null,null,null,null,null,null,null,null,null,"U heeft gekozen voor EENVOUDIGE INVOER"]
[null,null,null,"Afschrijvingen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"N15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},false,0]
[null,null,null,{"$f":"C_Base!F314","v":"Bestaande afschrijvingslasten - direct"},null,null,null,1000,{"$f":"IF(D39=\"\",\"\",(H39-1000)/1000)","v":0},null,null,null,null,{"$f":"N16","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},false,0]
[null,null,null,{"$f":"C_Base!F315","v":"Bestaande afschrijvingslasten - indirect"},null,null,null,1000,0,null,null,null,null,null,null,null,null,null,"5.","Detail overzicht kostprijzen",null,null,null,null,null,null,null,"6.","KPI's en ratio's - INPUT"]
[null,null,null,{"$f":"C_Base!F316","v":"Nieuwe afschrijvingslasten - direct"},null,null,null,1000,0,null,null,null,"U heeft gekozen voor DETAIL INVOER"]
[null,null,null,{"$f":"C_Base!F317","v":"Nieuwe afschrijvingslasten - indirect"},null,null,null,1000,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I_Kosten!$G$13=\"Nee\",\"N.v.t.\",\"Directe personeelskosten (excl. opleidingskosten) - in loondienst\")","v":"Directe personeelskosten (excl. opleidingskosten) - in loondienst"},false,0,null,null,null,"Kostprijs",null,null,"Eenheid","INPUT","SCENARIO"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I_Kosten!$G$13=\"Nee\",\"N.v.t.\",\"Directe personeelskosten (excl. opleidingskosten) - ingehuurd\")","v":"Directe personeelskosten (excl. opleidingskosten) - ingehuurd"},false,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I_Kosten!$G$25=\"Nee\",\"N.v.t.\",\"Indirecte personeelskosten (excl. opleidingskosten) - in loondienst\")","v":"Indirecte personeelskosten (excl. opleidingskosten) - in loondienst"},false,0,null,null,null,"Directe kosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I_Kosten!$G$25=\"Nee\",\"N.v.t.\",\"Indirecte personeelskosten (excl. opleidingskosten) - ingehuurd\")","v":"Indirecte personeelskosten (excl. opleidingskosten) - ingehuurd"},false,0,null,null,null,{"$f":"O_Graph!E61","v":"Personeelskosten direct personeel"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T46,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T46,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T46,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T46,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E62","v":"Personeelskosten direct personeel - in loondienst"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T47,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T47,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T47,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T47,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,"1.5","Wijziging bestaande rentelasten",null,null,null,null,null,{"$f":"O_Graph!E63","v":"Personeelskosten direct personeel - ingehuurd"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T48,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T48,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T48,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T48,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E64","v":"Opleidingskosten direct personeel"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T49,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T49,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T49,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T49,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E65","v":"Bestaande afschrijvingslasten - direct"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T50,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T50,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T50,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T50,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,{"$f":"O_Graph!E66","v":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T51,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T51,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T51,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T51,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E67","v":"Huisvestingskosten"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T52,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T52,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T52,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T52,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E68","v":"Leasekosten werkplaatsapparatuur"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T53,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T53,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T53,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T53,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E69","v":"Garantiekosten"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T54,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T54,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T54,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T54,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E70","v":"Overige directe kosten"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T55,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T55,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T55,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T55,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaal directe kosten",null,null,"EUR / uur",{"$f":"SUM(X46,X49:X55)","v":0},{"$f":"SUM(Y46,Y49:Y55)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Stijging bestaande rentelasten",null,null,null,null,null,"Indirecte kosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF($N$51=1,N59/1000,\"N.v.t.\")","v":"N.v.t."},null,null,null,{"$f":"O_Graph!E71","v":"Personeelskosten indirect personeel"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T59,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T59,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T59,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T59,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E72","v":"Personeelskosten indirect personeel - in loondienst"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T60,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T60,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T60,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T60,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Daling bestaande rentelasten",null,null,null,null,null,{"$f":"O_Graph!E73","v":"Personeelskosten indirect personeel - ingehuurd"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T61,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T61,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T61,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T61,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,1000,null,null,null,null,null,0,null,{"$f":"IF($N$51=2,-N62/1000,\"N.v.t.\")","v":"N.v.t."},null,null,null,{"$f":"O_Graph!E74","v":"Opleidingskosten indirect personeel"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T62,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T62,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T62,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T62,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E75","v":"Bestaande afschrijvingslasten - indirect"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T63,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T63,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T63,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T63,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,"1.6","Wijziging nieuwe rentelasten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E76","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T64,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T64,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T64,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T64,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E77","v":"Bestaande rentelasten"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T65,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T65,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T65,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T65,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,"Nieuwe rentelasten (eenvoudige invoer)",null,null,null,null,"% / jaar",null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E78","v":"Nieuwe rentelasten"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T66,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T66,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T66,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T66,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E79","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T67,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T67,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T67,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T67,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,"Stijging / daling nieuwe rentelasten",null,null,null,1000,{"$f":"IF(OR(I_Financiering!$G$9=\"\",I_Financiering!$G$9=\"Nee\"),\"N.v.t.\",(H68-1000)/1000)","v":"N.v.t."},null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E80","v":"IT kosten"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T68,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T68,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T68,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T68,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E81","v":"Energiekosten"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T69,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T69,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T69,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T69,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,"Nieuwe rentelasten (detail invoer)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E82","v":"Marketingkosten"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T70,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T70,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T70,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T70,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E83","v":"Overige indirecte kosten"},null,null,"EUR / uur",{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T71,O_Graph!$O$59:$O$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T71,O_Graph!$O$59:$O$92))","v":"N.v.t."},{"$f":"IF(SUMIF(O_Graph!$K$59:$K$92,$T71,O_Graph!$P$59:$P$92)=0,\"N.v.t.\",SUMIF(O_Graph!$K$59:$K$92,$T71,O_Graph!$P$59:$P$92))","v":"N.v.t."}]
[null,null,null,{"$f":"C_Scenario!F124","v":"Financiering 1"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,"`",null,null,null,"Totaal indirecte kosten",null,null,"EUR / uur",{"$f":"SUM(X59,X62:X71)","v":0},{"$f":"SUM(Y59,Y62:Y71)","v":0}]
[null,null,null,{"$f":"C_Scenario!F125","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K125","v":0},null,null,null,null,null,null,"EUR"]
[null,null,null,{"$f":"C_Scenario!F126","v":"Rentepercentage "},null,null,{"$f":"C_Scenario!K126","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,null,"Kostprijs per uur",null,null,"EUR / uur",{"$f":"SUM(X56,X72)","v":0},{"$f":"SUM(Y56,Y72)","v":0}]
[]
[null,null,null,{"$f":"C_Scenario!F130","v":"Financiering 2"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F131","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K131","v":0},null,null,null,null,null,null,"EUR"]
[null,null,null,{"$f":"C_Scenario!F132","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K132","v":0},null,null,null,null,null,null,"% / jaar"]
[]
[null,null,null,{"$f":"C_Scenario!F136","v":"Financiering 3"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F137","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K137","v":0},null,null,null,null,null,null,"EUR"]
[null,null,null,{"$f":"C_Scenario!F138","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K138","v":0},null,null,null,null,null,null,"% / jaar"]
[]
[null,null,null,{"$f":"C_Scenario!F142","v":"Financiering 4"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F143","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K143","v":0},null,null,null,null,null,null,"EUR"]
[null,null,null,{"$f":"C_Scenario!F144","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K144","v":0},null,null,null,null,null,null,"% / jaar"]
[]
[null,null,null,{"$f":"C_Scenario!F148","v":"Financiering 5"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F149","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K149","v":0},null,null,null,null,null,null,"EUR"]
[null,null,null,{"$f":"C_Scenario!F150","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K150","v":0},null,null,null,null,null,null,"% / jaar"]
[]
[null,null,null,{"$f":"C_Scenario!F154","v":"Financiering 6"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F155","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K155","v":0},null,null,null,null,null,null,"EUR"]
[null,null,null,{"$f":"C_Scenario!F156","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K156","v":0},null,null,null,null,null,null,"% / jaar"]
[]
[null,null,null,{"$f":"C_Scenario!F160","v":"Financiering 7"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F161","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K161","v":0},null,null,null,null,null,null,"EUR"]
[null,null,null,{"$f":"C_Scenario!F162","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K162","v":0},null,null,null,null,null,null,"% / jaar"]
[]
[null,null,null,{"$f":"C_Scenario!F166","v":"Financiering 8"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F167","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K167","v":0},null,null,null,null,null,null,"EUR"]
[null,null,null,{"$f":"C_Scenario!F168","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K168","v":0},null,null,null,null,null,null,"% / jaar"]

{"sheet":"O_Graph","index":15,"n_rows":108,"n_cols":16,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | O_Graph"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"O_Graph"}]
[null,null,"Calculaties voor dashboard"]
[]
[]
[null,null,"1.","Waterval 1 - INPUT"]
[]
[null,null,null,"1.1","Kostprijs werkplaats",null,null,"Kosten","Rank"]
[]
[null,null,null,null,{"$f":"C_Base!F294","v":"Directe personeelskosten"},null,null,{"$f":"C_Base!Q294","v":0},{"$f":"IF(H11=0,\"\",RANK(H11,IF($H$11:$H$17>0,$H$11:$H$17,0))+COUNTIF($H$11:$H11,$H11)-1)","v":""}]
[null,null,null,null,{"$f":"C_Base!F295","v":"Indirecte personeelskosten"},null,null,{"$f":"C_Base!Q295","v":0},{"$f":"IF(H12=0,\"\",RANK(H12,IF($H$11:$H$17>0,$H$11:$H$17,0))+COUNTIF($H$11:$H12,$H12)-1)","v":""}]
[null,null,null,null,{"$f":"C_Base!F296","v":"Directe afschrijvingslasten"},null,null,{"$f":"C_Base!Q296","v":0},{"$f":"IF(H13=0,\"\",RANK(H13,IF($H$11:$H$17>0,$H$11:$H$17,0))+COUNTIF($H$11:$H13,$H13)-1)","v":""}]
[null,null,null,null,{"$f":"C_Base!F297","v":"Indirecte afschrijvingslasten"},null,null,{"$f":"C_Base!Q297","v":0},{"$f":"IF(H14=0,\"\",RANK(H14,IF($H$11:$H$17>0,$H$11:$H$17,0))+COUNTIF($H$11:$H14,$H14)-1)","v":""}]
[null,null,null,null,{"$f":"C_Base!F298","v":"Rentelasten"},null,null,{"$f":"C_Base!Q298","v":0},{"$f":"IF(H15=0,\"\",RANK(H15,IF($H$11:$H$17>0,$H$11:$H$17,0))+COUNTIF($H$11:$H15,$H15)-1)","v":""}]
[null,null,null,null,{"$f":"C_Base!F299","v":"Directe overige kosten"},null,null,{"$f":"C_Base!Q299","v":0},{"$f":"IF(H16=0,\"\",RANK(H16,IF($H$11:$H$17>0,$H$11:$H$17,0))+COUNTIF($H$11:$H16,$H16)-1)","v":""}]
[null,null,null,null,{"$f":"C_Base!F300","v":"Indirecte overige kosten"},null,null,{"$f":"C_Base!Q300","v":0},{"$f":"IF(H17=0,\"\",RANK(H17,IF($H$11:$H$17>0,$H$11:$H$17,0))+COUNTIF($H$11:$H17,$H17)-1)","v":""}]
[null,null,null,null,"Totale kostprijs",null,null,{"$f":"SUM(H11:H17)","v":0}]
[]
[null,null,null,"1.2","Waterval"]
[null,null,null,null,null,null,null,"Rank","Kosten","Balance","Invisible","Negative","Positive"]
[]
[null,null,null,null,{"$f":"E18","v":"Totale kostprijs"},null,null,null,{"$f":"$H$18","v":0},null,null,null,{"$f":"MAX(I23,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(INDEX($E$11:$E$17,MATCH(H24,$I$11:$I$17,0)),\"\")","v":""},null,null,1,{"$f":"IFERROR(INDEX($H$11:$H$17,MATCH(H24,$I$11:$I$17,0)),0)","v":0},{"$f":"I24","v":0},null,{"$f":"-MIN(I24,0)","v":0},{"$f":"MAX(I24,0)","v":0}]
[null,null,null,null,"",null,null,{"$f":"H24+1","v":2},{"$f":"IFERROR(INDEX($H$11:$H$17,MATCH(H25,$I$11:$I$17,0)),0)","v":0},{"$f":"IFERROR(J24+I25,\"\")","v":0},{"$f":"IF(I25<0,J25,J24)","v":0},{"$f":"-MIN(I25,0)","v":0},0]
[null,null,null,null,"",null,null,{"$f":"H25+1","v":3},{"$f":"IFERROR(INDEX($H$11:$H$17,MATCH(H26,$I$11:$I$17,0)),0)","v":0},{"$f":"IFERROR(J25+I26,\"\")","v":0},{"$f":"IF(I26<0,J26,J25)","v":0},0,0]
[null,null,null,null,"",null,null,4,{"$f":"IFERROR(INDEX($H$11:$H$17,MATCH(H27,$I$11:$I$17,0)),0)","v":0},0,0,0,0]
[null,null,null,null,"",null,null,5,{"$f":"IFERROR(INDEX($H$11:$H$17,MATCH(H28,$I$11:$I$17,0)),0)","v":0},{"$f":"IFERROR(J27+I28,\"\")","v":0},{"$f":"IF(I28<0,J28,J27)","v":0},{"$f":"-MIN(I28,0)","v":0},{"$f":"MAX(I28,0)","v":0}]
[null,null,null,null,"",null,null,6,0,0,0,0,0]
[null,null,null,null,"",null,null,7,0,0,0,0,0]
[]
[null,null,"2.","Waterval 2 - SCENARIO"]
[]
[null,null,null,"2.1","Kostprijs werkplaats (Scenario)",null,null,"Kosten","Rank"]
[]
[null,null,null,null,{"$f":"C_Scenario!F237","v":"Directe personeelskosten"},null,null,{"$f":"C_Scenario!O237","v":0},{"$f":"IF(H36=0,\"\",RANK(H36,IF($H$36:$H$42>0,$H$36:$H$42,0))+COUNTIF($H$36:$H36,$H36)-1)","v":""}]
[null,null,null,null,{"$f":"C_Scenario!F238","v":"Indirecte personeelskosten"},null,null,{"$f":"C_Scenario!O238","v":0},{"$f":"IF(H37=0,\"\",RANK(H37,IF($H$36:$H$42>0,$H$36:$H$42,0))+COUNTIF($H$36:$H37,$H37)-1)","v":""}]
[null,null,null,null,{"$f":"C_Scenario!F239","v":"Directe afschrijvingslasten"},null,null,{"$f":"C_Scenario!O239","v":0},{"$f":"IF(H38=0,\"\",RANK(H38,IF($H$36:$H$42>0,$H$36:$H$42,0))+COUNTIF($H$36:$H38,$H38)-1)","v":""}]
[null,null,null,null,{"$f":"C_Scenario!F240","v":"Indirecte afschrijvingslasten"},null,null,{"$f":"C_Scenario!O240","v":0},{"$f":"IF(H39=0,\"\",RANK(H39,IF($H$36:$H$42>0,$H$36:$H$42,0))+COUNTIF($H$36:$H39,$H39)-1)","v":""}]
[null,null,null,null,{"$f":"C_Scenario!F241","v":"Rentelasten"},null,null,{"$f":"C_Scenario!O241","v":0},{"$f":"IF(H40=0,\"\",RANK(H40,IF($H$36:$H$42>0,$H$36:$H$42,0))+COUNTIF($H$36:$H40,$H40)-1)","v":""}]
[null,null,null,null,{"$f":"C_Scenario!F242","v":"Directe overige kosten"},null,null,{"$f":"C_Scenario!O242","v":0},{"$f":"IF(H41=0,\"\",RANK(H41,IF($H$36:$H$42>0,$H$36:$H$42,0))+COUNTIF($H$36:$H41,$H41)-1)","v":""}]
[null,null,null,null,{"$f":"C_Scenario!F243","v":"Indirecte overige kosten"},null,null,{"$f":"C_Scenario!O243","v":0},{"$f":"IF(H42=0,\"\",RANK(H42,IF($H$36:$H$42>0,$H$36:$H$42,0))+COUNTIF($H$36:$H42,$H42)-1)","v":""}]
[null,null,null,null,"Totale kostprijs",null,null,{"$f":"SUM(H36:H42)","v":0}]
[]
[null,null,null,"2.2","Waterval (Scenario)"]
[null,null,null,null,null,null,null,"Rank","Kosten","Balance","Invisible","Negative","Positive"]
[]
[null,null,null,null,{"$f":"E43","v":"Totale kostprijs"},null,null,null,{"$f":"$H$43","v":0},null,null,null,{"$f":"MAX(I48,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(INDEX($E$36:$E$42,MATCH(H49,$I$36:$I$42,0)),\"\")","v":""},null,null,1,{"$f":"IFERROR(INDEX($H$36:$H$42,MATCH(H49,$I$36:$I$42,0)),0)","v":0},{"$f":"I49","v":0},null,{"$f":"-MIN(I49,0)","v":0},{"$f":"MAX(I49,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(INDEX($E$36:$E$42,MATCH(H50,$I$36:$I$42,0)),\"\")","v":""},null,null,{"$f":"H49+1","v":2},{"$f":"IFERROR(INDEX($H$36:$H$42,MATCH(H50,$I$36:$I$42,0)),0)","v":0},{"$f":"IFERROR(J49+I50,\"\")","v":0},{"$f":"IF(I50<0,J50,J49)","v":0},{"$f":"-MIN(I50,0)","v":0},0]
[null,null,null,null,{"$f":"IFERROR(INDEX($E$36:$E$42,MATCH(H51,$I$36:$I$42,0)),\"\")","v":""},null,null,{"$f":"H50+1","v":3},{"$f":"IFERROR(INDEX($H$36:$H$42,MATCH(H51,$I$36:$I$42,0)),0)","v":0},{"$f":"IFERROR(J50+I51,\"\")","v":0},{"$f":"IF(I51<0,J51,J50)","v":0},0,0]
[null,null,null,null,{"$f":"IFERROR(INDEX($E$36:$E$42,MATCH(H52,$I$36:$I$42,0)),\"\")","v":""},null,null,4,{"$f":"IFERROR(INDEX($H$36:$H$42,MATCH(H52,$I$36:$I$42,0)),0)","v":0},{"$f":"IFERROR(J51+I52,\"\")","v":0},{"$f":"IF(I52<0,J52,J51)","v":0},{"$f":"-MIN(I52,0)","v":0},{"$f":"MAX(I52,0)","v":0}]
[null,null,null,null,"",null,null,5,{"$f":"IFERROR(INDEX($H$36:$H$42,MATCH(H53,$I$36:$I$42,0)),0)","v":0},{"$f":"IFERROR(J52+I53,\"\")","v":0},{"$f":"IF(I53<0,J53,J52)","v":0},{"$f":"-MIN(I53,0)","v":0},{"$f":"MAX(I53,0)","v":0}]
[null,null,null,null,"",null,null,6,0,0,0,0,0]
[null,null,null,null,"",null,null,7,0,0,0,0,0]
[]
[null,null,"3.","Mapping kostprijs detail inzicht",null,null,null,"Input gebruiker",null,null,"Gekozen mapping",null,null,null,"Base","Scenario"]
[]
[null,null,null,"3.1","Classificatie volgens metamodel",null,null,{"$f":"C_Scenario!F249","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"Personeelskosten direct personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H59,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H59,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F250","v":"Totale personeelskosten direct personeel (excl. opleidingskosten) - In loondienst"},null,null,"Personeelskosten direct personeel - in loondienst",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H60,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H60,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Personeelskosten direct personeel",null,null,{"$f":"C_Scenario!F251","v":"Totale personeelskosten direct personeel (excl. opleidingskosten) - Ingehuurd personeel"},null,null,"Personeelskosten direct personeel - ingehuurd",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H61,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H61,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Personeelskosten direct personeel - in loondienst",null,null,{"$f":"C_Scenario!F252","v":"Opleidingskosten direct personeel"},null,null,"Opleidingskosten direct personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H62,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H62,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Personeelskosten direct personeel - ingehuurd",null,null,{"$f":"C_Scenario!F253","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"Personeelskosten indirect personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H63,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H63,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Opleidingskosten direct personeel",null,null,{"$f":"C_Scenario!F254","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten) - In loondienst"},null,null,"Personeelskosten indirect personeel - in loondienst",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H64,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H64,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Bestaande afschrijvingslasten - direct",null,null,{"$f":"C_Scenario!F255","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten) - Ingehuurd personeel"},null,null,"Personeelskosten indirect personeel - ingehuurd",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H65,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H65,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Nieuwe afschrijvingslasten - direct",null,null,{"$f":"C_Scenario!F256","v":"Opleidingskosten indirect personeel"},null,null,"Opleidingskosten indirect personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H66,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H66,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,{"$f":"I_Generiek!F28","v":"Huisvestingskosten"},null,null,{"$f":"C_Scenario!F257","v":"Bestaande afschrijvingslasten - direct"},null,null,"Bestaande afschrijvingslasten - direct",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H67,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H67,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,{"$f":"I_Generiek!F29","v":"Leasekosten werkplaatsapparatuur"},null,null,{"$f":"C_Scenario!F258","v":"Bestaande afschrijvingslasten - indirect"},null,null,"Bestaande afschrijvingslasten - indirect",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H68,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H68,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,{"$f":"I_Generiek!F30","v":"Garantiekosten"},null,null,{"$f":"C_Scenario!F259","v":"Nieuwe afschrijvingslasten - direct"},null,null,"Nieuwe afschrijvingslasten - direct",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H69,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H69,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Overige directe kosten",null,null,{"$f":"C_Scenario!F260","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"Nieuwe afschrijvingslasten - indirect",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H70,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H70,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Personeelskosten indirect personeel",null,null,{"$f":"C_Scenario!F261","v":"Bestaande rentelasten"},null,null,"Bestaande rentelasten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H71,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H71,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Personeelskosten indirect personeel - in loondienst",null,null,{"$f":"C_Scenario!F262","v":"Nieuwe rentelasten"},null,null,"Nieuwe rentelasten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H72,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H72,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Personeelskosten indirect personeel - ingehuurd",null,null,{"$f":"C_Scenario!F263","v":"Leasekosten werkplaatsapparatuur"},null,null,"Leasekosten werkplaatsapparatuur",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H73,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H73,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Opleidingskosten indirect personeel",null,null,{"$f":"C_Scenario!F264","v":"Garantiekosten"},null,null,"Garantiekosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H74,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H74,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Bestaande afschrijvingslasten - indirect",null,null,{"$f":"C_Scenario!F265","v":"Huisvestingskosten"},null,null,"Huisvestingskosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H75,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H75,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,{"$f":"C_Scenario!F266","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H76,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H76,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Bestaande rentelasten",null,null,{"$f":"C_Scenario!F267","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H77,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H77,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Nieuwe rentelasten",null,null,{"$f":"C_Scenario!F268","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H78,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H78,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,{"$f":"I_Generiek!F42","v":"Management fee / Ondernemersbeloning"},null,null,{"$f":"C_Scenario!F269","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H79,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H79,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,{"$f":"I_Generiek!F43","v":"IT kosten"},null,null,{"$f":"C_Scenario!F270","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H80,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H80,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,{"$f":"I_Generiek!F44","v":"Energiekosten"},null,null,{"$f":"C_Scenario!F271","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H81,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H81,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,{"$f":"I_Generiek!F45","v":"Marketingkosten"},null,null,{"$f":"C_Scenario!F272","v":"Management fee / Ondernemersbeloning"},null,null,"Management fee / Ondernemersbeloning",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H82,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H82,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,"Overige indirecte kosten",null,null,{"$f":"C_Scenario!F273","v":"IT kosten"},null,null,"IT kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H83,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H83,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F274","v":"Energiekosten"},null,null,"Energiekosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H84,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H84,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F275","v":"Marketingkosten"},null,null,"Marketingkosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H85,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H85,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F276","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H86,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H86,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F277","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H87,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H87,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F278","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H88,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H88,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F279","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H89,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H89,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F280","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H90,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H90,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F281","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H91,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H91,C_Scenario!$F$249:$F$282,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F282","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$249:$K$282,MATCH($H92,C_Scenario!$F$249:$F$282,0))","v":0},{"$f":"INDEX(C_Scenario!$O$249:$O$282,MATCH($H92,C_Scenario!$F$249:$F$282,0))","v":0}]
[]
[null,null,null,"3.2","CHECK"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O59:O92)=SUM(C_Scenario!K249:K282)","v":true},{"$f":"SUM(P59:P92)=SUM(C_Scenario!O249:O282)","v":true}]
[]
[null,null,"4.","KPI's en ratio's"]
[]
[null,null,null,"4.1","KPI's en ratio's"]
[]
[]
[null,null,null,null,null,null,null,"Ratio","Restant"]
[null,null,null,null,"Energiekosten / totale kosten",null,null,{"$f":"IFERROR(C_Scenario!K201/C_Scenario!K225,0)","v":0},{"$f":"100%-H103","v":1}]
[null,null,null,null,"Personeelskosten / totale kosten",null,null,{"$f":"IFERROR(SUM(C_Scenario!K217:K218)/C_Scenario!K225,0)","v":0},1]
[null,null,null,null,"Directe kosten / totale kosten",null,null,{"$f":"IFERROR(SUM(C_Scenario!K217,C_Scenario!K219,C_Scenario!K222)/C_Scenario!K225,0)","v":0},1]
[null,null,null,null,"Indirecte kosten / totale kosten",null,null,{"$f":"IFERROR(SUM(C_Scenario!K218,C_Scenario!K220,C_Scenario!K221,C_Scenario!K223)/C_Scenario!K225,0)","v":0},1]
[null,null,null,null,"Personeelskosten ingehuurd personeel / personeelskosten personeel in loondienst",null,null,{"$f":"IFERROR(SUM(C_Scenario!K47,C_Scenario!K89)/SUM(C_Scenario!K36,C_Scenario!K81),0)","v":0},1]
[null,null,null,null,"Directe kosten per gefactureerd uur",null,null,{"$f":"IFERROR(SUM(C_Scenario!K217,C_Scenario!K219,C_Scenario!K222)/C_Scenario!K231,0)","v":0}]

{"sheet":"CHECK","index":16,"n_rows":218,"n_cols":12,"rows_kept":218,"cut":false,"hidden":false,"merged":[[7,10,7,11]]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel Aanhangwagenbedrijven | CHECK"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"CHECK"}]
[null,null,"CHECK"]
[null,null,null,null,null,null,"CHECK",null,"Link naar input"]
[]
[null,null,"0.","Totale check"]
[null,null,null,null,null,null,null,null,null,null,"Alle checks OK?"]
[null,null,null,"0.1","Totale check",null,{"$f":"IF(H9>0,FALSE,TRUE)","v":false},{"$f":"SUM(H13:H91)","v":9},null,null,{"$f":"IF(H9>0,CHAR(108),\"\")","v":"l"},{"$f":"IF(H9=0,CHAR(108),\"\")","v":""}]
[]
[null,null,"1.","I_Generiek"]
[]
[null,null,null,"1.1","Heeft u een jaar ingevuld waarvoor u de kostprijs wilt berekenen?",null,{"$f":"IF(I_Generiek!F9=\"\",FALSE,TRUE)","v":false},{"$f":"IF(G13=FALSE,1,0)","v":1},{"$f":"IF(H13=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"1.2","Heeft u de gefactureerde uren voor het betreffende jaar ingevuld?",null,{"$f":"IF(I_Generiek!F18=\"\",FALSE,TRUE)","v":false},{"$f":"IF(G14=FALSE,1,0)","v":1},"KLIK HIER"]
[]
[null,null,"2.","I_Verdeelsleutel"]
[]
[null,null,null,"2.1","Heeft u 1 of meerdere verdeelsleutels aangemaakt?",null,{"$f":"IF(SUMPRODUCT(I_Verdeelsleutel!J11:J21)*1=0,FALSE,TRUE)","v":false},{"$f":"IF(G18=FALSE,1,0)","v":1},{"$f":"IF(H18=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[]
[null,null,"3.","I_Kosten"]
[]
[null,null,null,"3.1","Heeft u uw totale bedrijfskosten ingevuld?",null,{"$f":"IF(I_Kosten!K9=\"\",FALSE,TRUE)","v":false},{"$f":"IF(G22=FALSE,1,0)","v":1},{"$f":"IF(H22=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"3.2","Heeft u een keuze gemaakt voor eenvoudige of detail invoer van directe personeelskosten?",null,{"$f":"IF(I_Kosten!G13=\"\",FALSE,TRUE)","v":false},1,{"$f":"IF(H23=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"3.3","Heeft u de directe personeelskosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K15=0,COUNTA(I_Kosten!K15)=COUNTA(I_Kosten!M15)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.4","Heeft u de directe personeelskosten (in loondienst) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K17=0,COUNTA(I_Kosten!K17)=COUNTA(I_Kosten!M17)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.5","Heeft u de directe personeelskosten (ingehuurd) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K19=0,COUNTA(I_Kosten!K19)=COUNTA(I_Kosten!M19)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.6","Heeft u de opleidingskosten voor direct personeel ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K21=0,COUNTA(I_Kosten!K21)=COUNTA(I_Kosten!M21)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.7","Heeft u een keuze gemaakt voor eenvoudige of detail invoer van indirecte personeelskosten?",null,{"$f":"IF(I_Kosten!G25=\"\",FALSE,TRUE)","v":false},1,"KLIK HIER"]
[null,null,null,"3.8","Heeft u de indirecte personeelskosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K27=0,COUNTA(I_Kosten!K27)=COUNTA(I_Kosten!M27)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.9","Heeft u de indirecte personeelskosten (in loondienst) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K29=0,COUNTA(I_Kosten!K29)=COUNTA(I_Kosten!M29)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.10","Heeft u de indirecte personeelskosten (ingehuurd) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K31=0,COUNTA(I_Kosten!K31)=COUNTA(I_Kosten!M31)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.11","Heeft u de opleidingskosten voor indirect personeel ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K33=0,COUNTA(I_Kosten!K33)=COUNTA(I_Kosten!M33)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.12","Heeft u de directe afschrijvingslasten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K37=0,COUNTA(I_Kosten!K37)=COUNTA(I_Kosten!M37)),TRUE,FALSE)","v":true},{"$f":"IF(G33=FALSE,1,0)","v":0},{"$f":"IF(H33=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.13","Heeft u de indirecte afschrijvingslasten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K39=0,COUNTA(I_Kosten!K39)=COUNTA(I_Kosten!M39)),TRUE,FALSE)","v":true},{"$f":"IF(G34=FALSE,1,0)","v":0},{"$f":"IF(H34=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.14","Heeft u een keuze gemaakt om wel of niet extra investeringen te willen invullen?",null,{"$f":"IF(I_Kosten!G41=\"\",FALSE,TRUE)","v":false},1,"KLIK HIER"]
[null,null,null,"3.15","Heeft u de rentelasten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K45=0,COUNTA(I_Kosten!K45)=COUNTA(I_Kosten!M45)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.16","Heeft u een keuze gemaakt om wel of niet nieuwe rentelasten te willen invullen?",null,{"$f":"IF(I_Kosten!G47=\"\",FALSE,TRUE)","v":false},1,"KLIK HIER"]
[null,null,null,"3.17","Heeft u de leasekosten werkplaatsapparatuur ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K51=0,COUNTA(I_Kosten!K51)=COUNTA(I_Kosten!M51)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.18","Heeft u de garantiekosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K53=0,COUNTA(I_Kosten!K53)=COUNTA(I_Kosten!M53)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.19","Heeft u een keuze gemaakt voor eenvoudige of detail invoer van huisvestingskosten?",null,{"$f":"IF(I_Kosten!G55=\"\",FALSE,TRUE)","v":false},1,"KLIK HIER"]
[null,null,null,"3.20","Heeft u de huisvestingskosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K57=0,COUNTA(I_Kosten!K57)=COUNTA(I_Kosten!M57)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.21",{"$f":"\"Heeft u de \" &I_Kosten!F59 &\" ingevuld en een verdeelsleutel geselecteerd?\"","v":"Heeft u de Huisvestingskosten - Huur ingevuld en een verdeelsleutel geselecteerd?"},null,{"$f":"IF(OR(I_Kosten!K59=0,COUNTA(I_Kosten!K59)=COUNTA(I_Kosten!M59)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.22",{"$f":"\"Heeft u de \" &I_Kosten!F61 &\" ingevuld en een verdeelsleutel geselecteerd?\"","v":"Heeft u de Huisvestingskosten - Onderhoud ingevuld en een verdeelsleutel geselecteerd?"},null,{"$f":"IF(OR(I_Kosten!K61=0,COUNTA(I_Kosten!K61)=COUNTA(I_Kosten!M61)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.23",{"$f":"\"Heeft u de \" &I_Kosten!F63 &\" ingevuld en een verdeelsleutel geselecteerd?\"","v":"Heeft u de Huisvestingskosten - Verzekeringen ingevuld en een verdeelsleutel geselecteerd?"},null,{"$f":"IF(OR(I_Kosten!K63=0,COUNTA(I_Kosten!K63)=COUNTA(I_Kosten!M63)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.24",{"$f":"\"Heeft u de \" &I_Kosten!F65 &\" ingevuld en een verdeelsleutel geselecteerd?\"","v":"Heeft u de  ingevuld en een verdeelsleutel geselecteerd?"},null,{"$f":"IF(OR(I_Kosten!K65=0,COUNTA(I_Kosten!K65)=COUNTA(I_Kosten!M65)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.25",{"$f":"\"Heeft u de \" &I_Kosten!F67 &\" ingevuld en een verdeelsleutel geselecteerd?\"","v":"Heeft u de  ingevuld en een verdeelsleutel geselecteerd?"},null,{"$f":"IF(OR(I_Kosten!K67=0,COUNTA(I_Kosten!K67)=COUNTA(I_Kosten!M67)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.26",{"$f":"\"Heeft u de \" &I_Kosten!F69 &\" ingevuld en een verdeelsleutel geselecteerd?\"","v":"Heeft u de  ingevuld en een verdeelsleutel geselecteerd?"},null,{"$f":"IF(OR(I_Kosten!K69=0,COUNTA(I_Kosten!K69)=COUNTA(I_Kosten!M69)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.27","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K71=0,COUNTA(I_Kosten!K71)=COUNTA(I_Kosten!M71)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.28","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K73=0,COUNTA(I_Kosten!K73)=COUNTA(I_Kosten!M73)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.29","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K75=0,COUNTA(I_Kosten!K75)=COUNTA(I_Kosten!M75)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.30","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K77=0,COUNTA(I_Kosten!K77)=COUNTA(I_Kosten!M77)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.31","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K79=0,COUNTA(I_Kosten!K79)=COUNTA(I_Kosten!M79)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.32","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K81=0,COUNTA(I_Kosten!K81)=COUNTA(I_Kosten!M81)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.33","Heeft u de management fee / ondernemersbeloning ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K85=0,COUNTA(I_Kosten!K85)=COUNTA(I_Kosten!M85)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.34","Heeft u de IT kosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K87=0,COUNTA(I_Kosten!K87)=COUNTA(I_Kosten!M87)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.35","Heeft u de energiekosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K89=0,COUNTA(I_Kosten!K89)=COUNTA(I_Kosten!M89)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.36","Heeft u de marketing ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K91=0,COUNTA(I_Kosten!K91)=COUNTA(I_Kosten!M91)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.37","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K93=0,COUNTA(I_Kosten!K93)=COUNTA(I_Kosten!M93)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.38","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K95=0,COUNTA(I_Kosten!K95)=COUNTA(I_Kosten!M95)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.39","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K97=0,COUNTA(I_Kosten!K97)=COUNTA(I_Kosten!M97)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.40","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K99=0,COUNTA(I_Kosten!K99)=COUNTA(I_Kosten!M99)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.41","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K101=0,COUNTA(I_Kosten!K101)=COUNTA(I_Kosten!M101)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.42","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K103=0,COUNTA(I_Kosten!K103)=COUNTA(I_Kosten!M103)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.43","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K105=0,COUNTA(I_Kosten!K105)=COUNTA(I_Kosten!M105)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.44","Komen de ingevoerde totale bedrijfskosten overeen met de optelling van de afzonderlijke kosten?",null,{"$f":"I_Kosten!K113","v":true},0,""]
[]
[null,null,"4.","I_Investeringen"]
[]
[null,null,null,"4.1","Heeft u een keuze gemaakt voor eenvoudige of detail invoer voor extra investeringen?",null,{"$f":"IF(AND(I_Kosten!$G$41=\"Ja\",I_Investeringen!G9=\"\"),FALSE,TRUE)","v":true},{"$f":"IF(G69=FALSE,1,0)","v":0},{"$f":"IF(H69=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"4.2","Heeft u de nieuwe directe afschrijvingslasten (eenvoudige invoer) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Investeringen!K10=0,COUNTA(I_Investeringen!K10)=COUNTA(I_Investeringen!M10)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.3","Heeft u de nieuwe indirecte afschrijvingslasten (eenvoudige invoer) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Investeringen!K11=0,COUNTA(I_Investeringen!K11)=COUNTA(I_Investeringen!M11)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.4","Heeft u de extra investering (detail invoer) ingevuld, een verdeelsleutel geselecteerd en keuze tussen direct/indirect gemaakt?",null,{"$f":"IF(OR(I_Investeringen!$G$9=\"\",I_Investeringen!$G$9=\"Ja\",AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G26<>\"\",I_Investeringen!G27<>\"\",I_Investeringen!K28:K30<>\"\",I_Investeringen!M26<>\"\",I_Investeringen!O26<>\"\"),AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G26=\"\",I_Investeringen!G27=\"\",I_Investeringen!K28:K30=\"\",I_Investeringen!M26=\"\",I_Investeringen!O26=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.5","Heeft u de extra investering (detail invoer) ingevuld, een verdeelsleutel geselecteerd en keuze tussen direct/indirect gemaakt?",null,{"$f":"IF(OR(I_Investeringen!$G$9=\"\",I_Investeringen!$G$9=\"Ja\",AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G32<>\"\",I_Investeringen!G33<>\"\",I_Investeringen!K34:K36<>\"\",I_Investeringen!M32<>\"\",I_Investeringen!O32<>\"\"),AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G32=\"\",I_Investeringen!G33=\"\",I_Investeringen!K34:K36=\"\",I_Investeringen!M32=\"\",I_Investeringen!O32=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.6","Heeft u de extra investering (detail invoer) ingevuld, een verdeelsleutel geselecteerd en keuze tussen direct/indirect gemaakt?",null,{"$f":"IF(OR(I_Investeringen!$G$9=\"\",I_Investeringen!$G$9=\"Ja\",AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G38<>\"\",I_Investeringen!G39<>\"\",I_Investeringen!K40:K42<>\"\",I_Investeringen!M38<>\"\",I_Investeringen!O38<>\"\"),AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G38=\"\",I_Investeringen!G39=\"\",I_Investeringen!K40:K42=\"\",I_Investeringen!M38=\"\",I_Investeringen!O38=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.7","Heeft u de extra investering (detail invoer) ingevuld, een verdeelsleutel geselecteerd en keuze tussen direct/indirect gemaakt?",null,{"$f":"IF(OR(I_Investeringen!$G$9=\"\",I_Investeringen!$G$9=\"Ja\",AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G44<>\"\",I_Investeringen!G45<>\"\",I_Investeringen!K46:K48<>\"\",I_Investeringen!M44<>\"\",I_Investeringen!O44<>\"\"),AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G44=\"\",I_Investeringen!G45=\"\",I_Investeringen!K46:K48=\"\",I_Investeringen!M44=\"\",I_Investeringen!O44=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.8","Heeft u de extra investering (detail invoer) ingevuld, een verdeelsleutel geselecteerd en keuze tussen direct/indirect gemaakt?",null,{"$f":"IF(OR(I_Investeringen!$G$9=\"\",I_Investeringen!$G$9=\"Ja\",AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G50<>\"\",I_Investeringen!G51<>\"\",I_Investeringen!K52:K54<>\"\",I_Investeringen!M50<>\"\",I_Investeringen!O50<>\"\"),AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G50=\"\",I_Investeringen!G51=\"\",I_Investeringen!K52:K54=\"\",I_Investeringen!M50=\"\",I_Investeringen!O50=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.9","Heeft u de extra investering (detail invoer) ingevuld, een verdeelsleutel geselecteerd en keuze tussen direct/indirect gemaakt?",null,{"$f":"IF(OR(I_Investeringen!$G$9=\"\",I_Investeringen!$G$9=\"Ja\",AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G56<>\"\",I_Investeringen!G57<>\"\",I_Investeringen!K58:K60<>\"\",I_Investeringen!M56<>\"\",I_Investeringen!O56<>\"\"),AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G56=\"\",I_Investeringen!G57=\"\",I_Investeringen!K58:K60=\"\",I_Investeringen!M56=\"\",I_Investeringen!O56=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.10","Heeft u de extra investering (detail invoer) ingevuld, een verdeelsleutel geselecteerd en keuze tussen direct/indirect gemaakt?",null,{"$f":"IF(OR(I_Investeringen!$G$9=\"\",I_Investeringen!$G$9=\"Ja\",AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G62<>\"\",I_Investeringen!G63<>\"\",I_Investeringen!K64:K66<>\"\",I_Investeringen!M62<>\"\",I_Investeringen!O62<>\"\"),AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G62=\"\",I_Investeringen!G63=\"\",I_Investeringen!K64:K66=\"\",I_Investeringen!M62=\"\",I_Investeringen!O62=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.11","Heeft u de extra investering (detail invoer) ingevuld, een verdeelsleutel geselecteerd en keuze tussen direct/indirect gemaakt?",null,{"$f":"IF(OR(I_Investeringen!$G$9=\"\",I_Investeringen!$G$9=\"Ja\",AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G68<>\"\",I_Investeringen!G69<>\"\",I_Investeringen!K70:K72<>\"\",I_Investeringen!M68<>\"\",I_Investeringen!O68<>\"\"),AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G68=\"\",I_Investeringen!G69=\"\",I_Investeringen!K70:K72=\"\",I_Investeringen!M68=\"\",I_Investeringen!O68=\"\")),TRUE,FALSE)","v":true},{"$f":"IF(G79=FALSE,1,0)","v":0},{"$f":"IF(H79=1,\"KLIK HIER\",\"\")","v":""}]
[]
[null,null,"5.","I_Financiering"]
[]
[null,null,null,"5.1","Heeft u een keuze gemaakt voor eenvoudige of detail invoer voor nieuwe rentelasten?",null,{"$f":"IF(AND(I_Kosten!$G$47=\"Ja\",I_Financiering!G9=\"\"),FALSE,TRUE)","v":true},{"$f":"IF(G83=FALSE,1,0)","v":0},{"$f":"IF(H83=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"5.2","Heeft u de nieuwe financiering (detail invoer) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Financiering!$G$9=\"\",I_Financiering!$G$9=\"Ja\",AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G14<>\"\",I_Financiering!K15<>\"\",I_Financiering!K16<>\"\",I_Financiering!M14<>\"\"),AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G14=\"\",I_Financiering!K15=\"\",I_Financiering!K16=\"\",I_Financiering!M14=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"5.3","Heeft u de nieuwe financiering (detail invoer) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Financiering!$G$9=\"\",I_Financiering!$G$9=\"Ja\",AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G18<>\"\",I_Financiering!K19<>\"\",I_Financiering!K20<>\"\",I_Financiering!M18<>\"\"),AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G18=\"\",I_Financiering!K19=\"\",I_Financiering!K20=\"\",I_Financiering!M18=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"5.4","Heeft u de nieuwe financiering (detail invoer) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Financiering!$G$9=\"\",I_Financiering!$G$9=\"Ja\",AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G22<>\"\",I_Financiering!K23<>\"\",I_Financiering!K24<>\"\",I_Financiering!M22<>\"\"),AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G22=\"\",I_Financiering!K23=\"\",I_Financiering!K24=\"\",I_Financiering!M22=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"5.5","Heeft u de nieuwe financiering (detail invoer) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Financiering!$G$9=\"\",I_Financiering!$G$9=\"Ja\",AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G26<>\"\",I_Financiering!K27<>\"\",I_Financiering!K28<>\"\",I_Financiering!M26<>\"\"),AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G26=\"\",I_Financiering!K27=\"\",I_Financiering!K28=\"\",I_Financiering!M26=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"5.6","Heeft u de nieuwe financiering (detail invoer) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Financiering!$G$9=\"\",I_Financiering!$G$9=\"Ja\",AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G30<>\"\",I_Financiering!K31<>\"\",I_Financiering!K32<>\"\",I_Financiering!M30<>\"\"),AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G30=\"\",I_Financiering!K31=\"\",I_Financiering!K32=\"\",I_Financiering!M30=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"5.7","Heeft u de nieuwe financiering (detail invoer) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Financiering!$G$9=\"\",I_Financiering!$G$9=\"Ja\",AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G34<>\"\",I_Financiering!K35<>\"\",I_Financiering!K36<>\"\",I_Financiering!M34<>\"\"),AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G34=\"\",I_Financiering!K35=\"\",I_Financiering!K36=\"\",I_Financiering!M34=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"5.8","Heeft u de nieuwe financiering (detail invoer) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Financiering!$G$9=\"\",I_Financiering!$G$9=\"Ja\",AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G38<>\"\",I_Financiering!K39<>\"\",I_Financiering!K40<>\"\",I_Financiering!M38<>\"\"),AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G38=\"\",I_Financiering!K39=\"\",I_Financiering!K40=\"\",I_Financiering!M38=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"5.9","Heeft u de nieuwe financiering (detail invoer) ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Financiering!$G$9=\"\",I_Financiering!$G$9=\"Ja\",AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G42<>\"\",I_Financiering!K43<>\"\",I_Financiering!K44<>\"\",I_Financiering!M42<>\"\"),AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G42=\"\",I_Financiering!K43=\"\",I_Financiering!K44=\"\",I_Financiering!M42=\"\")),TRUE,FALSE)","v":true},0,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"ja"]
[null,null,null,null,"nee"]