{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["COVER","Input >>>","I_Generiek","I_Verdeelsleutel","I_Kosten","I_Omzet","I_Investeringen","I_Financiering","Calc >>>","C_Base","C_Scenario","Output >>>","O_Dashboard","O_Graph","CHECK"],"not_rendered":{"charts":12,"images":10,"macros":1,"external_links":0,"defined_names":7,"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 \nOnafhankelijke Autobedrijven (OAB)"]
[]
[]
[]
[]
[]
[null,null,"Finale versie"]

{"sheet":"Input >>>","index":1,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Input >>>"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PRIVATE AND CONFIDENTIAL"]

{"sheet":"I_Generiek","index":2,"n_rows":209,"n_cols":6,"rows_kept":209,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \nOnafhankelijke Autobedrijven (OAB) | 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.","Overzicht directe en indirecte kosten"]
[]
[null,null,null,null,"Directe- / Indirecte kosten","Kosten item"]
[]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E13","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E15","v":"Opleidingskosten direct personeel"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E25","v":"Afschrijvingslasten - direct"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E39","v":"Kosten uitbesteed werk (specialist)"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E41","v":"Garantiekosten"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E43","v":"Kosten service-auto"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E45","v":"Marketingkosten werkplaats"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E47","v":"Equipment leasekosten"}]
[null,null,null,0,{"$f":"IF(F33=\"\",\"\",\"Directe kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$49,$D33,)=\"\",\"\",OFFSET(I_Kosten!$F$49,$D33,))","v":""}]
[null,null,null,{"$f":"D33+2","v":2},{"$f":"IF(F34=\"\",\"\",\"Directe kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$49,$D34,)=\"\",\"\",OFFSET(I_Kosten!$F$49,$D34,))","v":""}]
[null,null,null,{"$f":"D34+2","v":4},"",{"$f":"IF(OFFSET(I_Kosten!$F$49,$D35,)=\"\",\"\",OFFSET(I_Kosten!$F$49,$D35,))","v":""}]
[null,null,null,6,"",{"$f":"IF(OFFSET(I_Kosten!$F$49,$D36,)=\"\",\"\",OFFSET(I_Kosten!$F$49,$D36,))","v":""}]
[]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E19","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E21","v":"Opleidingskosten indirect personeel"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E27","v":"Afschrijvingslasten - indirect"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E33","v":"Rentelasten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E59","v":"IT kosten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E61","v":"Energiekosten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E63","v":"Huisvestingskosten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E65","v":"Algemene marketingkosten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E67","v":"Management fee / Ondernemersbeloning"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E69","v":"Overige indirecte kosten"}]
[null,null,null,0,{"$f":"IF(F48=\"\",\"\",\"Indirecte kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$71,$D48,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D48,))","v":""}]
[null,null,null,{"$f":"D48+2","v":2},{"$f":"IF(F49=\"\",\"\",\"Indirecte kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$71,$D49,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D49,))","v":""}]
[null,null,null,{"$f":"D49+2","v":4},{"$f":"IF(F50=\"\",\"\",\"Indirecte kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$71,$D50,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D50,))","v":""}]
[null,null,null,6,"",{"$f":"IF(OFFSET(I_Kosten!$F$71,$D51,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D51,))","v":""}]
[null,null,null,8,"",{"$f":"IF(OFFSET(I_Kosten!$F$71,$D52,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D52,))","v":""}]
[null,null,null,10,"",{"$f":"IF(OFFSET(I_Kosten!$F$71,$D53,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D53,))","v":""}]
[null,null,null,12,"",{"$f":"IF(OFFSET(I_Kosten!$F$71,$D54,)=\"\",\"\",OFFSET(I_Kosten!$F$71,$D54,))","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":3,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \nOnafhankelijke Autobedrijven (OAB) | 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","Behorende aan overige activiteiten","% werkplaats","Check"]
[]
[null,null,null,null,"Percentage",{"$f":"IF(E11=\"\",\"\",\"%\")","v":"%"},1,null,null,null,{"$f":"IFERROR($H11/$G11,\"\")","v":0},{"$f":"IF(AND(SUM(H11:J11)=G11,G11<>\"\",E11:G11<>\"\"),TRUE,FALSE)","v":false},{"$f":"IF(AND($G11<>SUM($H11:$J11),SUM($H11:$J11)<>0),\"Let op: Het Totaal komt niet overeen met de optelling van werkplaats, Sales en overige activiteiten\",\"\")","v":""}]
[null,null,null,null,"Omzet","EUR",null,null,null,null,{"$f":"IFERROR($H12/$G12,\"\")","v":""},{"$f":"IF(AND(SUM(H12:J12)=G12,G12<>\"\",E12:G12<>\"\"),TRUE,FALSE)","v":false},{"$f":"IF(AND($G12<>SUM($H12:$J12),SUM($H12:$J12)<>0),\"Let op: Het Totaal komt niet overeen met de optelling van werkplaats, Sales en overige activiteiten\",\"\")","v":""}]
[null,null,null,null,"Kosten","EUR",null,null,null,null,{"$f":"IFERROR($H13/$G13,\"\")","v":""},{"$f":"IF(AND(SUM(H13:J13)=G13,G13<>\"\",E13:G13<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,"Aantal medewerkers","Aantal",null,null,null,null,"",{"$f":"IF(AND(SUM(H14:J14)=G14,G14<>\"\",E14:G14<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,"Gebruiksoppervlak","m²",null,null,null,null,"",{"$f":"IF(AND(SUM(H15:J15)=G15,G15<>\"\",E15:G15<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(SUM(H16:J16)=G16,G16<>\"\",E16:G16<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(SUM(H17:J17)=G17,G17<>\"\",E17:G17<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(SUM(H18:J18)=G18,G18<>\"\",E18:G18<>\"\"),TRUE,FALSE)","v":false},""]

{"sheet":"I_Kosten","index":4,"n_rows":92,"n_cols":13,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \nOnafhankelijke Autobedrijven (OAB) | 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","Totale personeelskosten direct personeel (excl. opleidingskosten)",null,null,null,"EUR / jaar"]
[]
[null,null,null,"1.2","Opleidingskosten direct personeel",null,null,null,"EUR / jaar"]
[]
[null,null,"2.","Personele lasten indirect personeel"]
[]
[null,null,null,"2.1","Totale personeelskosten indirect personeel (excl. opleidingskosten)",null,null,null,"EUR / jaar"]
[]
[null,null,null,"2.2","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 nieuwe investeringen die meegenomen moeten worden?",null,null,null,null,null,{"$f":"IF($G29=\"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(K29=\"\",\"\",\"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($G35=\"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(K35=\"\",\"\",\"KLIK HIER\")","v":""}]
[null,null,"5.","Directe overige kosten"]
[]
[null,null,null,"5.1","Kosten uitbesteed werk (specialist)",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.2","Garantiekosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.3","Kosten service-auto",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.4","Marketingkosten werkplaats",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.5","Equipment leasekosten",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,"6.","Overige indirecte kosten"]
[]
[null,null,null,"6.1","IT kosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.2","Energiekosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.3","Huisvestingskosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.4","Algemene marketingkosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.5","Management fee / Ondernemersbeloning",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.6","Overige indirecte kosten",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,null,"6.12",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.13",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(K13:K21,K25,K33,K39:K55,K59:K83)","v":0}]
[]
[null,null,null,"7.3","Check of de ingevulde totale bedrijfskosten gelijk is aan de optelling van de ingevulde individuele kosten",null,null,null,null,null,{"$f":"K87=K89","v":true}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K91=FALSE,\"Let op, de ingevulde totale bedrijfskosten komen niet overeen met de optelling van de ingevulde individuele kosten\",\"\")","v":""}]

{"sheet":"I_Omzet","index":5,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \nOnafhankelijke Autobedrijven (OAB) | I_Omzet"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"I_Omzet"}]
[null,null,{"$f":"\"Bruto omzet, korting leasemaatschappijen en materiaalkosten \" &I_Generiek!$F$9","v":"Bruto omzet, korting leasemaatschappijen en materiaalkosten "}]
[null,null,null,null,null,null,"Keuze",null,"Eenheid",null,{"$f":"I_Generiek!$F$9","v":0},null,"Verdeelsleutel"]
[]
[null,null,"1.","Bruto omzet, korting leasemaatschappijen en materiaalkosten"]
[]
[null,null,null,"1.1","Hebben de ingevulde kosten (op tabblad I_Kosten) enkel betrekking op de werkplaats?"]
[]
[null,null,null,"1.2",{"$f":"IF($G$9=\"Ja\",\"Bruto omzet - Werkplaats\",IF($G$9=\"Nee\",\"Bruto omzet - op bedrijfsniveau\",\"Bruto omzet\"))","v":"Bruto omzet"},null,null,null,"EUR / jaar"]
[]
[null,null,null,"1.3",{"$f":"IF($G$9=\"Ja\",\"Korting leasemaatschappijen - Werkplaats\",IF($G$9=\"Nee\",\"Korting leasemaatschappijen - op bedrijfsniveau\",\"Korting leasemaatschappijen\"))","v":"Korting leasemaatschappijen"},null,null,null,"EUR / jaar"]
[]
[null,null,null,"1.4",{"$f":"IF($G$9=\"Ja\",\"Materiaalkosten - Werkplaats\",IF($G$9=\"Nee\",\"Materiaalkosten - op bedrijfsniveau\",\"Materiaalkosten\"))","v":"Materiaalkosten"},null,null,null,"EUR / jaar"]

{"sheet":"I_Investeringen","index":6,"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 \nOnafhankelijke Autobedrijven (OAB) | I_Investeringen"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"I_Investeringen"}]
[null,null,{"$f":"\"Extrainvesteringen \"&I_Generiek!$F$9","v":"Extrainvesteringen "}]
[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$29=\"\",I_Kosten!$G$29=\"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.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(K30>K28,\"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(K36>K34,\"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(K42>K40,\"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(K48>K46,\"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(K54>K52,\"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(K60>K58,\"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(K66>K64,\"Let op: De restwaarde is momenteel groter dan de investering\",\"\")","v":""}]
[]
[null,null,null,null,"1.2.9","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":7,"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 \nOnafhankelijke Autobedrijven (OAB) | 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$35=\"\",I_Kosten!$G$35=\"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":8,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Calc >>>"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PRIVATE AND CONFIDENTIAL"]

{"sheet":"C_Base","index":9,"n_rows":301,"n_cols":17,"rows_kept":301,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \nOnafhankelijke Autobedrijven (OAB) | 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"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E13","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K13","v":0},null,{"$f":"I_Kosten!M13","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M11,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M11,I_Verdeelsleutel!$E$11:$E$18,0))*$K11,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E15","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K15","v":0},null,{"$f":"I_Kosten!M15","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M12,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M12,I_Verdeelsleutel!$E$11:$E$18,0))*$K12,0)","v":0}]
[]
[null,null,null,"1.2",null,"Indirect personeel"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E19","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K19","v":0},null,{"$f":"I_Kosten!M19","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M16,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M16,I_Verdeelsleutel!$E$11:$E$18,0))*$K16,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E21","v":"Opleidingskosten indirect 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!$K$11:$K$18,MATCH($M17,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M17,I_Verdeelsleutel!$E$11:$E$18,0))*$K17,0)","v":0}]
[]
[null,null,null,"1.3",null,"Totale personeelskosten"]
[]
[null,null,null,null,null,{"$f":"F11","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K11","v":0},null,null,null,null,null,{"$f":"Q11","v":0}]
[null,null,null,null,null,{"$f":"F12","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"K12","v":0},null,null,null,null,null,{"$f":"Q12","v":0}]
[null,null,null,null,null,{"$f":"F16","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K16","v":0},null,null,null,null,null,{"$f":"Q16","v":0}]
[null,null,null,null,null,{"$f":"F17","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"K17","v":0},null,null,null,null,null,{"$f":"Q17","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K21:K24)","v":0},null,null,null,null,null,{"$f":"SUM(Q21:Q24)","v":0}]
[]
[null,null,"2.",{"$f":"I_Kosten!D23","v":"Afschrijvingen"}]
[]
[null,null,null,"2.1",null,"Bestaande afschrijvingslasten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E25","v":"Afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K25","v":0},null,{"$f":"I_Kosten!M25","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M32,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M32,I_Verdeelsleutel!$E$11:$E$18,0))*$K32,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E27","v":"Afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K27","v":0},null,{"$f":"I_Kosten!M27","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M33,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M33,I_Verdeelsleutel!$E$11:$E$18,0))*$K33,0)","v":0}]
[]
[null,null,null,"2.2",null,"Nieuwe afschrijvingslasten (als gevolg van investeringen) - detail invoer",null,null,null,{"$f":"IF(J115=\"Ja\",\"Nee\",IF(J115=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$29","v":0},{"$f":"IF($J43=\"Ja\",IFERROR((K38-K40)/K39,0),0)","v":0},null,{"$f":"I_Investeringen!M26","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M43,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M43,I_Verdeelsleutel!$E$11:$E$18,0))*$K43,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$29","v":0},{"$f":"IF($J51=\"Ja\",IFERROR((K46-K48)/K47,0),0)","v":0},null,{"$f":"I_Investeringen!M32","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M51,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M51,I_Verdeelsleutel!$E$11:$E$18,0))*$K51,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$29","v":0},{"$f":"IF($J59=\"Ja\",IFERROR((K54-K56)/K55,0),0)","v":0},null,{"$f":"I_Investeringen!M38","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M59,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M59,I_Verdeelsleutel!$E$11:$E$18,0))*$K59,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$29","v":0},{"$f":"IF($J67=\"Ja\",IFERROR((K62-K64)/K63,0),0)","v":0},null,{"$f":"I_Investeringen!M44","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M67,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M67,I_Verdeelsleutel!$E$11:$E$18,0))*$K67,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$29","v":0},{"$f":"IF($J75=\"Ja\",IFERROR((K70-K72)/K71,0),0)","v":0},null,{"$f":"I_Investeringen!M50","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M75,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M75,I_Verdeelsleutel!$E$11:$E$18,0))*$K75,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$29","v":0},{"$f":"IF($J83=\"Ja\",IFERROR((K78-K80)/K79,0),0)","v":0},null,{"$f":"I_Investeringen!M56","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M83,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M83,I_Verdeelsleutel!$E$11:$E$18,0))*$K83,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$29","v":0},{"$f":"IF($J91=\"Ja\",IFERROR((K86-K88)/K87,0),0)","v":0},null,{"$f":"I_Investeringen!M62","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M91,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M91,I_Verdeelsleutel!$E$11:$E$18,0))*$K91,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$29","v":0},{"$f":"IF($J99=\"Ja\",IFERROR((K94-K96)/K95,0),0)","v":0},null,{"$f":"I_Investeringen!M68","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M99,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M99,I_Verdeelsleutel!$E$11:$E$18,0))*$K99,0)","v":0}]
[]
[null,null,null,null,"2.2.9","Totaal nieuwe afschrijvingslasten - detail invoer"]
[]
[null,null,null,null,null,{"$f":"F37","v":""},null,null,"EUR / jaar",{"$f":"J41","v":0},{"$f":"K43","v":0},null,null,null,null,null,{"$f":"Q43","v":0}]
[null,null,null,null,null,{"$f":"F45","v":""},null,null,"EUR / jaar",{"$f":"J49","v":0},{"$f":"K51","v":0},null,null,null,null,null,{"$f":"Q51","v":0}]
[null,null,null,null,null,{"$f":"F53","v":""},null,null,"EUR / jaar",{"$f":"J57","v":0},{"$f":"K59","v":0},null,null,null,null,null,{"$f":"Q59","v":0}]
[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,"Nieuwe afschrijvingslasten - direct",null,null,"EUR / jaar","Direct",{"$f":"SUMIF($J$103:$J$110,$J112,K$103:K$110)","v":0},null,null,null,null,null,{"$f":"SUMIF($J$103:$J$110,$J112,Q$103:Q$110)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR / jaar","Indirect",{"$f":"SUMIF($J$103:$J$110,$J113,K$103:K$110)","v":0},null,null,null,null,null,{"$f":"SUMIF($J$103:$J$110,$J113,Q$103:Q$110)","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$29","v":0},{"$f":"IF($J117=\"Ja\",I_Investeringen!$K$10,0)","v":0},null,{"$f":"I_Investeringen!$M$10","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M117,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M117,I_Verdeelsleutel!$E$11:$E$18,0))*$K117,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$29","v":0},{"$f":"IF($J118=\"Ja\",I_Investeringen!$K$11,0)","v":0},null,{"$f":"I_Investeringen!$M$11","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M118,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M118,I_Verdeelsleutel!$E$11:$E$18,0))*$K118,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":"K32","v":0},null,null,null,null,null,{"$f":"Q32","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - indirect",null,null,"EUR / jaar",null,{"$f":"K33","v":0},null,null,null,null,null,{"$f":"Q33","v":0}]
[null,null,null,null,null,{"$f":"F117","v":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"IF($J$35=\"Ja\",K112,K117)","v":0},null,null,null,null,null,{"$f":"IF($J$35=\"Ja\",Q112,Q117)","v":0}]
[null,null,null,null,null,{"$f":"F118","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"IF($J$35=\"Ja\",K113,K118)","v":0},null,null,null,null,null,{"$f":"IF($J$35=\"Ja\",Q113,Q118)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K122:K125)","v":0},null,null,null,null,null,{"$f":"SUM(Q122:Q125)","v":0}]
[]
[null,null,"3.",{"$f":"I_Kosten!D31","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!K33","v":0},null,{"$f":"I_Kosten!M33","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M133,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M133,I_Verdeelsleutel!$E$11:$E$18,0))*$K133,0)","v":0}]
[]
[null,null,null,"3.2",null,"Nieuwe rentelasten (als gevolg van nieuwe financiering) - detail invoer",null,null,null,{"$f":"IF(J185=\"Ja\",\"Nee\",IF(J185=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$35","v":0},{"$f":"IF($J141=\"Ja\",IFERROR(K138*K139,0),0)","v":0},null,{"$f":"I_Financiering!M14","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M141,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M141,I_Verdeelsleutel!$E$11:$E$18,0))*$K141,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$35","v":0},{"$f":"IF($J147=\"Ja\",IFERROR(K144*K145,0),0)","v":0},null,{"$f":"I_Financiering!M18","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M147,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M147,I_Verdeelsleutel!$E$11:$E$18,0))*$K147,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$35","v":0},{"$f":"IF($J153=\"Ja\",IFERROR(K150*K151,0),0)","v":0},null,{"$f":"I_Financiering!M22","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M153,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M153,I_Verdeelsleutel!$E$11:$E$18,0))*$K153,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$35","v":0},{"$f":"IF($J159=\"Ja\",IFERROR(K156*K157,0),0)","v":0},null,{"$f":"I_Financiering!M26","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M159,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M159,I_Verdeelsleutel!$E$11:$E$18,0))*$K159,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$35","v":0},{"$f":"IF($J165=\"Ja\",IFERROR(K162*K163,0),0)","v":0},null,{"$f":"I_Financiering!M30","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M165,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M165,I_Verdeelsleutel!$E$11:$E$18,0))*$K165,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$35","v":0},{"$f":"IF($J171=\"Ja\",IFERROR(K168*K169,0),0)","v":0},null,{"$f":"I_Financiering!M34","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M171,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M171,I_Verdeelsleutel!$E$11:$E$18,0))*$K171,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$35","v":0},{"$f":"IF($J177=\"Ja\",IFERROR(K174*K175,0),0)","v":0},null,{"$f":"I_Financiering!M38","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M177,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M177,I_Verdeelsleutel!$E$11:$E$18,0))*$K177,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$35","v":0},{"$f":"IF($J183=\"Ja\",IFERROR(K180*K181,0),0)","v":0},null,{"$f":"I_Financiering!M42","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M183,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M183,I_Verdeelsleutel!$E$11:$E$18,0))*$K183,0)","v":0}]
[]
[null,null,null,"2.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$35","v":0},{"$f":"IF(AND($J185=\"Ja\",$J187=\"Ja\"),I_Financiering!K10,0)","v":0},null,{"$f":"I_Financiering!M10","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M187,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M187,I_Verdeelsleutel!$E$11:$E$18,0))*$K187,0)","v":0}]
[]
[null,null,null,"3.3",null,"Totale rentelasten"]
[]
[null,null,null,null,null,{"$f":"F133","v":"Bestaande rentelasten"},null,null,"EUR / jaar",null,{"$f":"K133","v":0},null,null,null,null,null,{"$f":"Q133","v":0}]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / jaar",null,{"$f":"IF($J$135=\"Ja\",SUM(K141,K147,K153,K159,K165,K171,K177,K183),K187)","v":0},null,null,null,null,null,{"$f":"IF($J$135=\"Ja\",SUM(Q141,Q147,Q153,Q159,Q165,Q171,Q177,Q183),Q187)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K191:K192)","v":0},null,null,null,null,null,{"$f":"SUM(Q191:Q192)","v":0}]
[]
[null,null,"4.",{"$f":"I_Kosten!D37","v":"Directe overige kosten"}]
[]
[null,null,null,"4.1",null,"Directe overige kosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E39","v":"Kosten uitbesteed werk (specialist)"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K39","v":0},null,{"$f":"I_Kosten!M39","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M200,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M200,I_Verdeelsleutel!$E$11:$E$18,0))*$K200,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E41","v":"Garantiekosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K41","v":0},null,{"$f":"I_Kosten!M41","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M201,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M201,I_Verdeelsleutel!$E$11:$E$18,0))*$K201,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E43","v":"Kosten service-auto"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K43","v":0},null,{"$f":"I_Kosten!M43","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M202,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M202,I_Verdeelsleutel!$E$11:$E$18,0))*$K202,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E45","v":"Marketingkosten werkplaats"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K45","v":0},null,{"$f":"I_Kosten!M45","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M203,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M203,I_Verdeelsleutel!$E$11:$E$18,0))*$K203,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E47","v":"Equipment leasekosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K47","v":0},null,{"$f":"I_Kosten!M47","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M204,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M204,I_Verdeelsleutel!$E$11:$E$18,0))*$K204,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F49=\"\",\"\",I_Kosten!F49)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K49","v":0},null,{"$f":"I_Kosten!M49","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M205,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M205,I_Verdeelsleutel!$E$11:$E$18,0))*$K205,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F51=\"\",\"\",I_Kosten!F51)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K51","v":0},null,{"$f":"I_Kosten!M51","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M206,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M206,I_Verdeelsleutel!$E$11:$E$18,0))*$K206,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F53=\"\",\"\",I_Kosten!F53)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K53","v":0},null,{"$f":"I_Kosten!M53","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M207,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M207,I_Verdeelsleutel!$E$11:$E$18,0))*$K207,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F55=\"\",\"\",I_Kosten!F55)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K55","v":0},null,{"$f":"I_Kosten!M55","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M208,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M208,I_Verdeelsleutel!$E$11:$E$18,0))*$K208,0)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K200:K208)","v":0},null,null,null,null,null,{"$f":"SUM(Q200:Q208)","v":0}]
[]
[null,null,"5.",{"$f":"I_Kosten!D57","v":"Overige indirecte kosten"}]
[]
[null,null,null,"5.1",null,"Indirecte overige kosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E59","v":"IT kosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K59","v":0},null,{"$f":"I_Kosten!M59","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M216,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M216,I_Verdeelsleutel!$E$11:$E$18,0))*$K216,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E61","v":"Energiekosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K61","v":0},null,{"$f":"I_Kosten!M61","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M217,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M217,I_Verdeelsleutel!$E$11:$E$18,0))*$K217,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E63","v":"Huisvestingskosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K63","v":0},null,{"$f":"I_Kosten!M63","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M218,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M218,I_Verdeelsleutel!$E$11:$E$18,0))*$K218,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E65","v":"Algemene marketingkosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K65","v":0},null,{"$f":"I_Kosten!M65","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M219,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M219,I_Verdeelsleutel!$E$11:$E$18,0))*$K219,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E67","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K67","v":0},null,{"$f":"I_Kosten!M67","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M220,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M220,I_Verdeelsleutel!$E$11:$E$18,0))*$K220,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E69","v":"Overige indirecte kosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K69","v":0},null,{"$f":"I_Kosten!M69","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M221,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M221,I_Verdeelsleutel!$E$11:$E$18,0))*$K221,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!$K$11:$K$18,MATCH($M222,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M222,I_Verdeelsleutel!$E$11:$E$18,0))*$K222,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!$K$11:$K$18,MATCH($M223,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M223,I_Verdeelsleutel!$E$11:$E$18,0))*$K223,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!$K$11:$K$18,MATCH($M224,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M224,I_Verdeelsleutel!$E$11:$E$18,0))*$K224,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!$K$11:$K$18,MATCH($M225,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M225,I_Verdeelsleutel!$E$11:$E$18,0))*$K225,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!$K$11:$K$18,MATCH($M226,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M226,I_Verdeelsleutel!$E$11:$E$18,0))*$K226,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!$K$11:$K$18,MATCH($M227,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M227,I_Verdeelsleutel!$E$11:$E$18,0))*$K227,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F83=\"\",\"\",I_Kosten!F83)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K83","v":0},null,{"$f":"I_Kosten!M83","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M228,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH($M228,I_Verdeelsleutel!$E$11:$E$18,0))*$K228,0)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K216:K228)","v":0},null,null,null,null,null,{"$f":"SUM(Q216:Q228)","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(K11:K12)","v":0},null,null,null,null,null,{"$f":"SUM(Q11:Q12)","v":0}]
[null,null,null,null,null,"Indirecte personeelskosten",null,null,"EUR / jaar",null,{"$f":"SUM(K16:K17)","v":0},null,null,null,null,null,{"$f":"SUM(Q16:Q17)","v":0}]
[null,null,null,null,null,"Directe afschrijvingslasten",null,null,"EUR / jaar",null,{"$f":"K122+K124","v":0},null,null,null,null,null,{"$f":"Q122+Q124","v":0}]
[null,null,null,null,null,"Indirecte afschrijvingslasten",null,null,"EUR / jaar",null,{"$f":"SUM(K123,K125)","v":0},null,null,null,null,null,{"$f":"SUM(Q123,Q125)","v":0}]
[null,null,null,null,null,"Rentelasten",null,null,"EUR / jaar",null,{"$f":"K194","v":0},null,null,null,null,null,{"$f":"Q194","v":0}]
[null,null,null,null,null,"Directe overige kosten",null,null,"EUR / jaar",null,{"$f":"K210","v":0},null,null,null,null,null,{"$f":"Q210","v":0}]
[null,null,null,null,null,"Indirecte overige kosten",null,null,"EUR / jaar",null,{"$f":"K230","v":0},null,null,null,null,null,{"$f":"Q230","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K236:K242)","v":0},null,null,null,null,null,{"$f":"SUM(Q236:Q242)","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,"6.1",null,"Hoofd kostenelementen"]
[]
[null,null,null,null,null,{"$f":"F236","v":"Directe personeelskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K236/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q236/$K$250,0)","v":0}]
[null,null,null,null,null,{"$f":"F237","v":"Indirecte personeelskosten"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F238","v":"Directe afschrijvingslasten"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F239","v":"Indirecte afschrijvingslasten"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F240","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(K256:K262)","v":0},null,null,null,null,null,{"$f":"SUM(Q256:Q262)","v":0}]
[]
[null,null,null,"6.1",null,"Alle kostenelementen"]
[]
[null,null,null,null,null,"Directe personeelskosten",null,null,"EUR / uur",null,{"$f":"IFERROR(K11/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q11/$K$250,0)","v":0}]
[null,null,null,null,null,"Opleidingskosten direct personeel",null,null,"EUR / uur",null,{"$f":"IFERROR(K12/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q12/$K$250,0)","v":0}]
[null,null,null,null,null,"Indirecte personeelskosten",null,null,"EUR / uur",null,{"$f":"IFERROR(K16/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q16/$K$250,0)","v":0}]
[null,null,null,null,null,"Opleidingskosten indirect personeel",null,null,"EUR / uur",null,{"$f":"IFERROR(K17/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q17/$K$250,0)","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - direct",null,null,"EUR / uur",null,{"$f":"IFERROR(K122/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q122/$K$250,0)","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - indirect",null,null,"EUR / uur",null,{"$f":"IFERROR(K123/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q123/$K$250,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - direct",null,null,"EUR / uur",null,{"$f":"IFERROR(K124/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q124/$K$250,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR / uur",null,{"$f":"IFERROR(K125/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q125/$K$250,0)","v":0}]
[null,null,null,null,null,"Bestaande rentelasten",null,null,"EUR / uur",null,{"$f":"IFERROR(K191/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q191/$K$250,0)","v":0}]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / uur",null,{"$f":"IFERROR(K192/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q192/$K$250,0)","v":0}]
[null,null,null,null,null,{"$f":"F200","v":"Kosten uitbesteed werk (specialist)"},null,null,"EUR / uur",null,{"$f":"IFERROR(K200/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q200/$K$250,0)","v":0}]
[null,null,null,null,null,{"$f":"F201","v":"Garantiekosten"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F202","v":"Kosten service-auto"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F203","v":"Marketingkosten werkplaats"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F204","v":"Equipment leasekosten"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F205","v":""},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":"F216","v":"IT kosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K216/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q216/$K$250,0)","v":0}]
[null,null,null,null,null,{"$f":"F217","v":"Energiekosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K217/$K$250,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q217/$K$250,0)","v":0}]
[null,null,null,null,null,"Huisvestingskosten",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"Algemene marketingkosten",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"Management fee / Ondernemersbeloning",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"Overige indirecte kosten",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(K268:K299)","v":0},null,null,null,null,null,{"$f":"SUM(Q268:Q299)","v":0}]

{"sheet":"C_Scenario","index":10,"n_rows":203,"n_cols":17,"rows_kept":203,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \nOnafhankelijke Autobedrijven (OAB) | 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"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E13","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q11","v":0},null,{"$f":"O_Dashboard!$P$11","v":0},null,{"$f":"IF(O_Dashboard!O13=TRUE,K11*(1+O_Dashboard!$P$11),K11)","v":0},null,{"$f":"IF(O_Dashboard!O13=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,{"$f":"I_Kosten!E15","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q12","v":0},null,{"$f":"O_Dashboard!$P$19","v":0},null,{"$f":"IF(O_Dashboard!O19=TRUE,K12*(1+O_Dashboard!$P$19),K12)","v":0},null,{"$f":"IF(O_Dashboard!O19=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,"1.2",null,"Indirect personeel"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E19","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q16","v":0},null,{"$f":"O_Dashboard!$P$11","v":0},null,{"$f":"IF(O_Dashboard!O14=TRUE,K16*(1+O_Dashboard!$P$11),K16)","v":0},null,{"$f":"IF(O_Dashboard!O14=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[null,null,null,null,null,{"$f":"I_Kosten!E21","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q17","v":0},null,{"$f":"O_Dashboard!$P$20","v":0},null,{"$f":"IF(O_Dashboard!O20=TRUE,K17*(1+O_Dashboard!$P$20),K17)","v":0},null,{"$f":"IF(O_Dashboard!O20=TRUE,CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,"1.3",null,"Totale personeelskosten"]
[]
[null,null,null,null,null,{"$f":"F11","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q21","v":0},null,{"$f":"M11","v":0},null,{"$f":"O11","v":0},null,{"$f":"Q11","v":"û"}]
[null,null,null,null,null,{"$f":"F12","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q22","v":0},null,{"$f":"M12","v":0},null,{"$f":"O12","v":0},null,{"$f":"Q12","v":"û"}]
[null,null,null,null,null,{"$f":"F16","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q23","v":0},null,{"$f":"M16","v":0},null,{"$f":"O16","v":0},null,{"$f":"Q16","v":"û"}]
[null,null,null,null,null,{"$f":"F17","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q24","v":0},null,{"$f":"M17","v":0},null,{"$f":"O17","v":0},null,{"$f":"Q17","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K21:K24)","v":0},null,null,null,{"$f":"SUM(O21:O24)","v":0}]
[]
[null,null,"2.",{"$f":"I_Kosten!D23","v":"Afschrijvingen"}]
[]
[null,null,null,"2.1",null,"Totale afschrijvingslasten"]
[]
[null,null,null,null,null,{"$f":"O_Dashboard!D41","v":"Bestaande afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q32","v":0},null,{"$f":"O_Dashboard!I41","v":0},null,{"$f":"IF(O_Dashboard!I41<>\"\",K32*(1+O_Dashboard!I41),K32)","v":0},null,{"$f":"IF(O_Dashboard!H41=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"O_Dashboard!D42","v":"Bestaande afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q33","v":0},null,{"$f":"O_Dashboard!I42","v":0},null,{"$f":"IF(O_Dashboard!I42<>\"\",K33*(1+O_Dashboard!I42),K33)","v":0},null,{"$f":"IF(O_Dashboard!H42=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"O_Dashboard!D43","v":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q124","v":0},null,{"$f":"O_Dashboard!I43","v":0},null,{"$f":"IF(O_Dashboard!I43<>\"\",K34*(1+O_Dashboard!I43),K34)","v":0},null,{"$f":"IF(O_Dashboard!H43=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"O_Dashboard!D44","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q125","v":0},null,{"$f":"O_Dashboard!I44","v":0},null,{"$f":"IF(O_Dashboard!I44<>\"\",K35*(1+O_Dashboard!I44),K35)","v":0},null,{"$f":"IF(O_Dashboard!H44=1000,CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K32:K35)","v":0},null,null,null,{"$f":"SUM(O32:O35)","v":0}]
[]
[null,null,"3.",{"$f":"I_Kosten!D31","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!K138*C_Base!O141,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L55=\"\",K44,O_Dashboard!L55)","v":0},null,{"$f":"IF(O_Dashboard!L55=\"\",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!L56=\"\",K45,O_Dashboard!L56)","v":0},null,{"$f":"IF(O_Dashboard!L56=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K44*K45,0)","v":0},null,null,null,{"$f":"IFERROR(O44*O45,0)","v":0}]
[]
[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!K144*C_Base!O147,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L59=\"\",K50,O_Dashboard!L59)","v":0},null,{"$f":"IF(O_Dashboard!L59=\"\",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!L60=\"\",K51,O_Dashboard!L60)","v":0},null,{"$f":"IF(O_Dashboard!L60=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K50*K51,0)","v":0},null,null,null,{"$f":"IFERROR(O50*O51,0)","v":0}]
[]
[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!K150*C_Base!O153,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L63=\"\",K56,O_Dashboard!L63)","v":0},null,{"$f":"IF(O_Dashboard!L63=\"\",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!L64=\"\",K57,O_Dashboard!L64)","v":0},null,{"$f":"IF(O_Dashboard!L64=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K56*K57,0)","v":0},null,null,null,{"$f":"IFERROR(O56*O57,0)","v":0}]
[]
[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!K156*C_Base!O159,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L67=\"\",K62,O_Dashboard!L67)","v":0},null,{"$f":"IF(O_Dashboard!L67=\"\",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!L68=\"\",K63,O_Dashboard!L68)","v":0},null,{"$f":"IF(O_Dashboard!L68=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K62*K63,0)","v":0},null,null,null,{"$f":"IFERROR(O62*O63,0)","v":0}]
[]
[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!K162*C_Base!O165,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L71=\"\",K68,O_Dashboard!L71)","v":0},null,{"$f":"IF(O_Dashboard!L71=\"\",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!L72=\"\",K69,O_Dashboard!L72)","v":0},null,{"$f":"IF(O_Dashboard!L72=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K68*K69,0)","v":0},null,null,null,{"$f":"IFERROR(O68*O69,0)","v":0}]
[]
[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!K168*C_Base!O171,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L75=\"\",K74,O_Dashboard!L75)","v":0},null,{"$f":"IF(O_Dashboard!L75=\"\",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!L76=\"\",K75,O_Dashboard!L76)","v":0},null,{"$f":"IF(O_Dashboard!L76=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K74*K75,0)","v":0},null,null,null,{"$f":"IFERROR(O74*O75,0)","v":0}]
[]
[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!K174*C_Base!O177,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L79=\"\",K80,O_Dashboard!L79)","v":0},null,{"$f":"IF(O_Dashboard!L79=\"\",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!L80=\"\",K81,O_Dashboard!L80)","v":0},null,{"$f":"IF(O_Dashboard!L80=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K80*K81,0)","v":0},null,null,null,{"$f":"IFERROR(O80*O81,0)","v":0}]
[]
[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!K180*C_Base!O183,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L83=\"\",K86,O_Dashboard!L83)","v":0},null,{"$f":"IF(O_Dashboard!L83=\"\",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!L84=\"\",K87,O_Dashboard!L84)","v":0},null,{"$f":"IF(O_Dashboard!L84=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K86*K87,0)","v":0},null,null,null,{"$f":"IFERROR(O86*O87,0)","v":0}]
[]
[null,null,null,"3.2",null,"Totale rentelasten"]
[]
[null,null,null,null,null,"Bestaande rentelasten",null,null,"EUR / jaar",null,{"$f":"C_Base!Q191","v":0},null,{"$f":"IF(O_Dashboard!N26=1,O_Dashboard!$P$34,IF(O_Dashboard!N26=2,O_Dashboard!$P$37,IF(O_Dashboard!N26=4,0,\"N.v.t.\")))","v":0},null,{"$f":"IF(O_Dashboard!N26=1,K93*(1+O_Dashboard!$P$34),IF(O_Dashboard!N26=2,K93*(1+O_Dashboard!$P$37),IF(O_Dashboard!N26=4,K93,0)))","v":0},null,{"$f":"IF(OR(O_Dashboard!N26=4,O_Dashboard!N26=0),CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / jaar",null,{"$f":"C_Base!Q192","v":0},null,{"$f":"IF(COUNT(O_Dashboard!$L$55:$M$84)>0,\"N.v.t.\",O_Dashboard!I50)","v":"N.v.t."},null,{"$f":"IF(C_Base!$J$185=\"Ja\",IF(O_Dashboard!I50<>\"\",K94*(1+O_Dashboard!I50),K94),SUM(C_Scenario!O47,C_Scenario!O53,C_Scenario!O59,C_Scenario!O65,C_Scenario!O71,C_Scenario!O77,C_Scenario!O83,C_Scenario!O89))","v":0},null,{"$f":"IF(OR(COUNT(O_Dashboard!$L$55:$M$84)>0,AND(O_Dashboard!$I$50<>\"N.v.t.\",O_Dashboard!$I$50<>0)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K93:K94)","v":0},null,null,null,{"$f":"SUM(O93:O94)","v":0}]
[]
[null,null,"4.",{"$f":"I_Kosten!D37","v":"Directe overige kosten"}]
[]
[null,null,null,"4.1",null,"Directe overige kosten"]
[]
[null,null,null,null,null,{"$f":"C_Base!F200","v":"Kosten uitbesteed werk (specialist)"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q200","v":0},null,{"$f":"O_Dashboard!I13","v":0},null,{"$f":"IF(O_Dashboard!I13<>\"\",K102*(1+O_Dashboard!I13),K102)","v":0},null,{"$f":"IF(O_Dashboard!H13=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F201","v":"Garantiekosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q201","v":0},null,{"$f":"O_Dashboard!I14","v":0},null,{"$f":"IF(O_Dashboard!I14<>\"\",K103*(1+O_Dashboard!I14),K103)","v":0},null,{"$f":"IF(O_Dashboard!H14=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F202","v":"Kosten service-auto"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q202","v":0},null,{"$f":"O_Dashboard!I15","v":0},null,{"$f":"IF(O_Dashboard!I15<>\"\",K104*(1+O_Dashboard!I15),K104)","v":0},null,{"$f":"IF(O_Dashboard!H15=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F203","v":"Marketingkosten werkplaats"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q203","v":0},null,{"$f":"O_Dashboard!I16","v":0},null,{"$f":"IF(O_Dashboard!I16<>\"\",K105*(1+O_Dashboard!I16),K105)","v":0},null,{"$f":"IF(O_Dashboard!H16=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F204","v":"Equipment leasekosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q204","v":0},null,{"$f":"O_Dashboard!I17","v":0},null,{"$f":"IF(O_Dashboard!I17<>\"\",K106*(1+O_Dashboard!I17),K106)","v":0},null,{"$f":"IF(O_Dashboard!H17=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F205","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q205","v":0},null,{"$f":"O_Dashboard!I18","v":""},null,{"$f":"IF(O_Dashboard!I18<>\"\",K107*(1+O_Dashboard!I18),K107)","v":0},null,{"$f":"IF(O_Dashboard!H18=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F206","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q206","v":0},null,{"$f":"O_Dashboard!I19","v":""},null,{"$f":"IF(O_Dashboard!I19<>\"\",K108*(1+O_Dashboard!I19),K108)","v":0},null,{"$f":"IF(O_Dashboard!H19=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F207","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q207","v":0},null,{"$f":"O_Dashboard!I20","v":""},null,{"$f":"IF(O_Dashboard!I20<>\"\",K109*(1+O_Dashboard!I20),K109)","v":0},null,{"$f":"IF(O_Dashboard!H20=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F208","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q208","v":0},null,{"$f":"O_Dashboard!I21","v":""},null,{"$f":"IF(O_Dashboard!I21<>\"\",K110*(1+O_Dashboard!I21),K110)","v":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(K102:K110)","v":0},null,null,null,{"$f":"SUM(O102:O110)","v":0}]
[]
[null,null,"5.",{"$f":"I_Kosten!D57","v":"Overige indirecte kosten"}]
[]
[null,null,null,"5.1",null,"Indirecte overige kosten"]
[]
[null,null,null,null,null,{"$f":"C_Base!F216","v":"IT kosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q216","v":0},null,{"$f":"O_Dashboard!I25","v":0},null,{"$f":"IF(O_Dashboard!I25<>\"\",K118*(1+O_Dashboard!I25),K118)","v":0},null,{"$f":"IF(O_Dashboard!H25=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F217","v":"Energiekosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q217","v":0},null,{"$f":"O_Dashboard!I26","v":0},null,{"$f":"IF(O_Dashboard!I26<>\"\",K119*(1+O_Dashboard!I26),K119)","v":0},null,{"$f":"IF(O_Dashboard!H26=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F218","v":"Huisvestingskosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q218","v":0},null,{"$f":"O_Dashboard!I27","v":0},null,{"$f":"IF(O_Dashboard!I27<>\"\",K120*(1+O_Dashboard!I27),K120)","v":0},null,{"$f":"IF(O_Dashboard!H27=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F219","v":"Algemene marketingkosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q219","v":0},null,{"$f":"O_Dashboard!I28","v":0},null,{"$f":"IF(O_Dashboard!I28<>\"\",K121*(1+O_Dashboard!I28),K121)","v":0},null,{"$f":"IF(O_Dashboard!H28=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F220","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q220","v":0},null,{"$f":"O_Dashboard!I29","v":0},null,{"$f":"IF(O_Dashboard!I29<>\"\",K122*(1+O_Dashboard!I29),K122)","v":0},null,{"$f":"IF(O_Dashboard!H29=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F221","v":"Overige indirecte kosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q221","v":0},null,{"$f":"O_Dashboard!I30","v":0},null,{"$f":"IF(O_Dashboard!I30<>\"\",K123*(1+O_Dashboard!I30),K123)","v":0},null,{"$f":"IF(O_Dashboard!H30=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F222","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q222","v":0},null,{"$f":"O_Dashboard!I31","v":""},null,{"$f":"IF(O_Dashboard!I31<>\"\",K124*(1+O_Dashboard!I31),K124)","v":0},null,{"$f":"IF(O_Dashboard!H31=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F223","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q223","v":0},null,{"$f":"O_Dashboard!I32","v":""},null,{"$f":"IF(O_Dashboard!I32<>\"\",K125*(1+O_Dashboard!I32),K125)","v":0},null,{"$f":"IF(O_Dashboard!H32=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F224","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q224","v":0},null,{"$f":"O_Dashboard!I33","v":""},null,{"$f":"IF(O_Dashboard!I33<>\"\",K126*(1+O_Dashboard!I33),K126)","v":0},null,{"$f":"IF(O_Dashboard!H33=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F225","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q225","v":0},null,{"$f":"O_Dashboard!I34","v":""},null,{"$f":"IF(O_Dashboard!I34<>\"\",K127*(1+O_Dashboard!I34),K127)","v":0},null,{"$f":"IF(O_Dashboard!H34=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F226","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q226","v":0},null,{"$f":"O_Dashboard!I35","v":""},null,{"$f":"IF(O_Dashboard!I35<>\"\",K128*(1+O_Dashboard!I35),K128)","v":0},null,{"$f":"IF(O_Dashboard!H35=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F227","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q227","v":0},null,{"$f":"O_Dashboard!I36","v":""},null,{"$f":"IF(O_Dashboard!I36<>\"\",K129*(1+O_Dashboard!I36),K129)","v":0},null,{"$f":"IF(O_Dashboard!H36=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F228","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q228","v":0},null,{"$f":"O_Dashboard!I37","v":""},null,{"$f":"IF(O_Dashboard!I37<>\"\",K130*(1+O_Dashboard!I37),K130)","v":0},null,{"$f":"IF(O_Dashboard!H37=1000,CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K118:K130)","v":0},null,null,null,{"$f":"SUM(O118:O130)","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":"C_Base!Q236","v":0},null,null,null,{"$f":"SUM(O11:O12)","v":0}]
[null,null,null,null,null,"Indirecte personeelskosten",null,null,"EUR / jaar",null,{"$f":"C_Base!Q237","v":0},null,null,null,{"$f":"SUM(O16:O17)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F238","v":"Directe afschrijvingslasten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q238","v":0},null,null,null,{"$f":"SUM(O32,O34)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F239","v":"Indirecte afschrijvingslasten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q239","v":0},null,null,null,{"$f":"SUM(O33,O35)","v":0}]
[null,null,null,null,null,"Rentelasten",null,null,"EUR / jaar",null,{"$f":"C_Base!Q240","v":0},null,null,null,{"$f":"O96","v":0}]
[null,null,null,null,null,"Directe overige kosten",null,null,"EUR / jaar",null,{"$f":"C_Base!Q241","v":0},null,null,null,{"$f":"O112","v":0}]
[null,null,null,null,null,"Indirecte overige kosten",null,null,"EUR / jaar",null,{"$f":"C_Base!Q242","v":0},null,null,null,{"$f":"O132","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K138:K144)","v":0},null,null,null,{"$f":"SUM(O138:O144)","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":"C_Base!K250","v":0}]
[]
[null,null,"8.","Kostprijs"]
[]
[null,null,null,"8.1",null,"Hoofd kostenelementen"]
[]
[null,null,null,null,null,{"$f":"F138","v":"Directe personeelskosten"},null,null,"EUR / uur",null,{"$f":"C_Base!Q256","v":0},null,null,null,{"$f":"IFERROR(O138/$K$152,0)","v":0}]
[null,null,null,null,null,{"$f":"F139","v":"Indirecte personeelskosten"},null,null,"EUR / uur",null,{"$f":"C_Base!Q257","v":0},null,null,null,0]
[null,null,null,null,null,{"$f":"F140","v":"Directe afschrijvingslasten"},null,null,"EUR / uur",null,{"$f":"C_Base!Q258","v":0},null,null,null,0]
[null,null,null,null,null,{"$f":"F141","v":"Indirecte afschrijvingslasten"},null,null,"EUR / uur",null,{"$f":"C_Base!Q259","v":0},null,null,null,0]
[null,null,null,null,null,{"$f":"F142","v":"Rentelasten"},null,null,"EUR / uur",null,{"$f":"C_Base!Q260","v":0},null,null,null,0]
[null,null,null,null,null,"Directe overige kosten",null,null,"EUR / uur",null,{"$f":"C_Base!Q261","v":0},null,null,null,0]
[null,null,null,null,null,"Indirecte overige kosten",null,null,"EUR / uur",null,{"$f":"C_Base!Q262","v":0},null,null,null,0]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / uur",null,{"$f":"SUM(K158:K164)","v":0},null,null,null,{"$f":"SUM(O158:O164)","v":0}]
[]
[null,null,null,"8.2",null,"Alle kostenelementen"]
[]
[null,null,null,null,null,"Directe personeelskosten",null,null,"EUR / uur",null,{"$f":"C_Base!Q268","v":0},null,null,null,{"$f":"IFERROR(O11/$K$152,0)","v":0}]
[null,null,null,null,null,"Opleidingskosten direct personeel",null,null,"EUR / uur",null,{"$f":"C_Base!Q269","v":0},null,null,null,{"$f":"IFERROR(O12/$K$152,0)","v":0}]
[null,null,null,null,null,"Indirecte personeelskosten",null,null,"EUR / uur",null,{"$f":"C_Base!Q270","v":0},null,null,null,{"$f":"IFERROR(O16/$K$152,0)","v":0}]
[null,null,null,null,null,"Opleidingskosten indirect personeel",null,null,"EUR / uur",null,{"$f":"C_Base!Q271","v":0},null,null,null,{"$f":"IFERROR(O17/$K$152,0)","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - direct",null,null,"EUR / uur",null,{"$f":"C_Base!Q272","v":0},null,null,null,{"$f":"IFERROR(O32/$K$152,0)","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - indirect",null,null,"EUR / uur",null,{"$f":"C_Base!Q273","v":0},null,null,null,{"$f":"IFERROR(O33/$K$152,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - direct",null,null,"EUR / uur",null,{"$f":"C_Base!Q274","v":0},null,null,null,{"$f":"IFERROR(O34/$K$152,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR / uur",null,{"$f":"C_Base!Q275","v":0},null,null,null,0]
[null,null,null,null,null,"Bestaande rentelasten",null,null,"EUR / uur",null,{"$f":"C_Base!Q276","v":0},null,null,null,{"$f":"IFERROR(O93/$K$152,0)","v":0}]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / uur",null,{"$f":"C_Base!Q277","v":0},null,null,null,{"$f":"IFERROR(O94/$K$152,0)","v":0}]
[null,null,null,null,null,{"$f":"F102","v":"Kosten uitbesteed werk (specialist)"},null,null,"EUR / uur",null,{"$f":"C_Base!Q278","v":0},null,null,null,{"$f":"IFERROR(O102/$K$152,0)","v":0}]
[null,null,null,null,null,"Garantiekosten",null,null,"EUR / uur",null,{"$f":"C_Base!Q279","v":0},null,null,null,{"$f":"IFERROR(O103/$K$152,0)","v":0}]
[null,null,null,null,null,"Kosten service-auto",null,null,"EUR / uur",null,{"$f":"C_Base!Q280","v":0},null,null,null,0]
[null,null,null,null,null,"Marketingkosten werkplaats",null,null,"EUR / uur",null,{"$f":"C_Base!Q281","v":0},null,null,null,0]
[null,null,null,null,null,"Equipment leasekosten",null,null,"EUR / uur",null,{"$f":"C_Base!Q282","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q283","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q284","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q285","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q286","v":0},null,null,null,0]
[null,null,null,null,null,{"$f":"F118","v":"IT kosten"},null,null,"EUR / uur",null,{"$f":"C_Base!Q287","v":0},null,null,null,{"$f":"IFERROR(O118/$K$152,0)","v":0}]
[null,null,null,null,null,{"$f":"F119","v":"Energiekosten"},null,null,"EUR / uur",null,{"$f":"C_Base!Q288","v":0},null,null,null,{"$f":"IFERROR(O119/$K$152,0)","v":0}]
[null,null,null,null,null,"Huisvestingskosten",null,null,"EUR / uur",null,{"$f":"C_Base!Q289","v":0},null,null,null,0]
[null,null,null,null,null,"Algemene marketingkosten",null,null,"EUR / uur",null,{"$f":"C_Base!Q290","v":0},null,null,null,0]
[null,null,null,null,null,"Management fee / Ondernemersbeloning",null,null,"EUR / uur",null,{"$f":"C_Base!Q291","v":0},null,null,null,0]
[null,null,null,null,null,"Overige indirecte kosten",null,null,"EUR / uur",null,{"$f":"C_Base!Q292","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q293","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q294","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q295","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q296","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q297","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q298","v":0},null,null,null,0]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"C_Base!Q299","v":0},null,null,null,0]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / uur",null,{"$f":"SUM(K170:K201)","v":0},null,null,null,{"$f":"SUM(O170:O201)","v":0}]

{"sheet":"Output >>>","index":11,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Output >>>"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PRIVATE AND CONFIDENTIAL"]

{"sheet":"O_Dashboard","index":12,"n_rows":116,"n_cols":39,"rows_kept":116,"cut":false,"hidden":false,"merged":[[115,23,115,24],[109,23,109,24],[110,23,110,24],[111,23,111,24],[112,23,112,24],[113,23,113,24],[104,23,104,24],[105,23,105,24],[106,23,106,24],[107,23,107,24],[108,23,108,24],[97,23,97,24],[98,23,98,24],[101,23,101,24],[102,23,102,24],[103,23,103,24],[92,23,92,24],[93,23,93,24],[94,23,94,24],[95,23,95,24],[96,23,96,24],[85,23,85,24],[88,23,88,24],[89,23,89,24],[90,23,90,24],[91,23,91,24],[80,23,80,24],[78,23,78,24],[81,23,81,24],[82,23,82,24],[84,23,84,24],[83,11,83,12],[74,11,74,12],[75,11,75,12],[78,11,78,12],[79,11,79,12],[82,11,82,12],[63,11,63,12],[66,11,66,12],[67,11,67,12],[70,11,70,12],[71,11,71,12],[54,11,54,12],[55,11,55,12],[58,11,58,12],[59,11,59,12],[62,11,62,12]]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \nOnafhankelijke Autobedrijven (OAB) | 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.","Gemiddelde kostprijs werkplaats - INPUT",null,null,null,null,null,null,null,null,null,null,null,"4.","Verschil gemiddelde 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,null,"Verschil kostprijzen",null,null,"Eenheid","INPUT","SCENARIO","Verschil"]
[null,null,null,"Directe overige kosten",null,null,null,null,null,null,null,null,null,"Loonstijging conform CAO",null,0]
[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,null,{"$f":"C_Scenario!F158","v":"Directe personeelskosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K158","v":0},{"$f":"C_Scenario!O158","v":0},{"$f":"AL12-AK12","v":0}]
[null,null,null,{"$f":"C_Base!F278","v":"Kosten uitbesteed werk (specialist)"},null,null,null,1000,{"$f":"IF(D13=\"\",\"\",(H13-1000)/1000)","v":0},null,null,null,null,{"$f":"C_Base!F268","v":"Directe personeelskosten"},false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F159","v":"Indirecte personeelskosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K159","v":0},{"$f":"C_Scenario!O159","v":0},{"$f":"AL13-AK13","v":0}]
[null,null,null,{"$f":"C_Base!F279","v":"Garantiekosten"},null,null,null,1000,{"$f":"IF(D14=\"\",\"\",(H14-1000)/1000)","v":0},null,null,null,null,{"$f":"C_Base!F270","v":"Indirecte personeelskosten"},false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F160","v":"Directe afschrijvingslasten"},null,null,"EUR / uur",{"$f":"C_Scenario!K160","v":0},{"$f":"C_Scenario!O160","v":0},0]
[null,null,null,{"$f":"C_Base!F280","v":"Kosten service-auto"},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,null,{"$f":"C_Scenario!F161","v":"Indirecte afschrijvingslasten"},null,null,"EUR / uur",{"$f":"C_Scenario!K161","v":0},{"$f":"C_Scenario!O161","v":0},0]
[null,null,null,{"$f":"C_Base!F281","v":"Marketingkosten werkplaats"},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,null,{"$f":"C_Scenario!F162","v":"Rentelasten"},null,null,"EUR / uur",{"$f":"C_Scenario!K162","v":0},{"$f":"C_Scenario!O162","v":0},0]
[null,null,null,{"$f":"C_Base!F282","v":"Equipment leasekosten"},null,null,null,1000,0,null,null,null,"1.3","Stijging opleidingskosten",null,"% / jaar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F163","v":"Directe overige kosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K163","v":0},{"$f":"C_Scenario!O163","v":0},0]
[null,null,null,{"$f":"C_Base!F283","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,null,{"$f":"C_Scenario!F164","v":"Indirecte overige kosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K164","v":0},{"$f":"C_Scenario!O164","v":0},0]
[null,null,null,{"$f":"C_Base!F284","v":""},null,null,null,1000,"",null,null,null,null,{"$f":"C_Base!F269","v":"Opleidingskosten direct personeel"},false,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gemiddelde kostprijs per uur",null,null,"EUR / uur",{"$f":"SUM(AK12:AK18)","v":0},{"$f":"SUM(AL12:AL18)","v":0},0]
[null,null,null,{"$f":"C_Base!F285","v":""},null,null,null,1000,"",null,null,null,null,{"$f":"C_Base!F271","v":"Opleidingskosten indirect personeel"},false,0]
[null,null,null,{"$f":"C_Base!F286","v":""},null,null,null,1000,""]
[]
[null,null,null,"Indirecte overige kosten",null,null,null,null,null,null,null,null,"1.4","Wijziging bestaande rentelasten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.","Marge en resultaat - INPUT"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.","Gemiddelde kostprijs werkplaats - SCENARIO"]
[null,null,null,{"$f":"C_Base!F287","v":"IT kosten"},null,null,null,1000,{"$f":"IF(D25=\"\",\"\",(H25-1000)/1000)","v":0}]
[null,null,null,{"$f":"C_Base!F288","v":"Energiekosten"},null,null,null,1000,{"$f":"IF(D26=\"\",\"\",(H26-1000)/1000)","v":0},null,null,null,null,4]
[null,null,null,{"$f":"C_Base!F289","v":"Huisvestingskosten"},null,null,null,1000,0]
[null,null,null,{"$f":"C_Base!F290","v":"Algemene marketingkosten"},null,null,null,1000,0]
[null,null,null,{"$f":"C_Base!F291","v":"Management fee / Ondernemersbeloning"},null,null,null,1000,0]
[null,null,null,{"$f":"C_Base!F292","v":"Overige indirecte kosten"},null,null,null,1000,0]
[null,null,null,{"$f":"C_Base!F293","v":""},null,null,null,1000,""]
[null,null,null,{"$f":"C_Base!F294","v":""},null,null,null,1000,""]
[null,null,null,{"$f":"C_Base!F295","v":""},null,null,null,1000,"",null,null,null,null,"Stijging bestaande rentelasten"]
[null,null,null,{"$f":"C_Base!F296","v":""},null,null,null,1000,"",null,null,null,null,0,null,{"$f":"IF($N$26=1,N34/1000,\"N.v.t.\")","v":"N.v.t."}]
[null,null,null,{"$f":"C_Base!F297","v":""},null,null,null,1000,""]
[null,null,null,{"$f":"C_Base!F298","v":""},null,null,null,1000,"",null,null,null,null,"Daling bestaande rentelasten"]
[null,null,null,{"$f":"C_Base!F299","v":""},null,null,null,1000,"",null,null,null,null,0,null,{"$f":"IF($N$26=2,-N37/1000,\"N.v.t.\")","v":"N.v.t."}]
[]
[null,null,null,"Afschrijvingen"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6.","Detail overzicht gemiddelde kostprijzen",null,null,null,null,null,null,null,"7.","(Kosten)verhoudingen - INPUT"]
[null,null,null,{"$f":"C_Base!F272","v":"Bestaande afschrijvingslasten - direct"},null,null,null,1000,{"$f":"IF(D41=\"\",\"\",(H41-1000)/1000)","v":0}]
[null,null,null,{"$f":"C_Base!F273","v":"Bestaande afschrijvingslasten - indirect"},null,null,null,1000,0]
[null,null,null,{"$f":"C_Base!F274","v":"Nieuwe afschrijvingslasten - direct"},null,null,null,1000,0,null,null,null,null,null,null,null,null,null,null,"Gemiddelde kostprijs",null,null,"Eenheid","INPUT","SCENARIO"]
[null,null,null,{"$f":"C_Base!F275","v":"Nieuwe afschrijvingslasten - indirect"},null,null,null,1000,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Directe kosten"]
[null,null,null,"1.5","Wijziging nieuwe rentelasten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E73","v":"Personeelskosten direct personeel"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T46,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T46,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E74","v":"Opleidingskosten direct personeel"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T47,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T47,O_Graph!$P$71:$P$102)","v":0}]
[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!E75","v":"Kosten uitbesteed werk (specialist)"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T48,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T48,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E76","v":"Garantiekosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T49,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T49,O_Graph!$P$71:$P$102)","v":0}]
[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.\",(H50-1000)/1000)","v":"N.v.t."},null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E77","v":"Kosten service-auto"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T50,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T50,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E78","v":"Marketingkosten werkplaats"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T51,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T51,O_Graph!$P$71:$P$102)","v":0}]
[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!E79","v":"Equipment leasekosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T52,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T52,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E80","v":"Bestaande afschrijvingslasten - direct"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T53,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T53,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F43","v":"Financiering 1"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,"`",null,null,null,{"$f":"O_Graph!E81","v":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T54,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T54,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F44","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K44","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,{"$f":"O_Graph!E82","v":"Overige directe kosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T55,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T55,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F45","v":"Rentepercentage "},null,null,{"$f":"C_Scenario!K45","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,null,"Totaal directe kosten",null,null,"EUR / uur",{"$f":"SUM(X46:X55)","v":0},{"$f":"SUM(Y46:Y55)","v":0}]
[]
[null,null,null,{"$f":"C_Scenario!F49","v":"Financiering 2"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,null,null,null,null,"Indirecte kosten"]
[null,null,null,{"$f":"C_Scenario!F50","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K50","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,{"$f":"O_Graph!E83","v":"Personeelskosten indirect personeel"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T59,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T59,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F51","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K51","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,null,{"$f":"O_Graph!E84","v":"Opleidingskosten indirect personeel"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T60,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T60,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E85","v":"Bestaande afschrijvingslasten - indirect"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T61,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T61,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F55","v":"Financiering 3"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E86","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T62,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T62,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F56","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K56","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,{"$f":"O_Graph!E87","v":"Bestaande rentelasten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T63,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T63,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F57","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K57","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,null,{"$f":"O_Graph!E88","v":"Nieuwe rentelasten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T64,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T64,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E89","v":"IT kosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T65,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T65,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F61","v":"Financiering 4"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E90","v":"Energiekosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T66,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T66,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F62","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K62","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,{"$f":"O_Graph!E91","v":"Huisvestingskosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T67,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T67,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F63","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K63","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,null,{"$f":"O_Graph!E92","v":"Algemene marketingkosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T68,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T68,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E93","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T69,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T69,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F67","v":"Financiering 5"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E94","v":"Overige indirecte kosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T70,O_Graph!$O$71:$O$102)","v":0},{"$f":"SUMIF(O_Graph!$K$71:$K$102,$T70,O_Graph!$P$71:$P$102)","v":0}]
[null,null,null,{"$f":"C_Scenario!F68","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K68","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,"Totaal indirecte kosten",null,null,"EUR / uur",{"$f":"SUM(X59:X70)","v":0},{"$f":"SUM(Y59:Y70)","v":0}]
[null,null,null,{"$f":"C_Scenario!F69","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K69","v":0},null,null,null,null,null,null,"% / jaar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gemiddelde kostprijs per uur",null,null,"EUR / uur",{"$f":"SUM(X56,X71)","v":0},{"$f":"SUM(Y56,Y71)","v":0}]
[null,null,null,{"$f":"C_Scenario!F73","v":"Financiering 6"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F74","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K74","v":0},null,null,null,null,null,null,"EUR"]
[null,null,null,{"$f":"C_Scenario!F75","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K75","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,"8.","Overzicht marge en resultaat - INPUT"]
[]
[null,null,null,{"$f":"C_Scenario!F79","v":"Financiering 7"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F80","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K80","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,"Marge en resultaat",null,null,"Eenheid",{"$f":"\"Jaar \" & I_Generiek!$F$9","v":"Jaar "}]
[null,null,null,{"$f":"C_Scenario!F81","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K81","v":0},null,null,null,null,null,null,"% / jaar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E61","v":"Bruto omzet"},null,null,"EUR",{"$f":"O_Graph!H61","v":0}]
[null,null,null,{"$f":"C_Scenario!F85","v":"Financiering 8"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E62","v":"Korting leasemaatschappijen"},null,null,"EUR",{"$f":"O_Graph!H62","v":0}]
[null,null,null,{"$f":"C_Scenario!F86","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K86","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,{"$f":"O_Graph!E63","v":"Netto omzet"},null,null,"EUR",{"$f":"O_Graph!H63","v":0}]
[null,null,null,{"$f":"C_Scenario!F87","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K87","v":0},null,null,null,null,null,null,"% / jaar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E64","v":"Materiaalkosten"},null,null,"EUR",{"$f":"O_Graph!H64","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E65","v":"Brutomarge"},null,null,"EUR",{"$f":"SUM(X83,X85)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T45","v":"Directe kosten"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personeelskosten direct personeel",null,null,"EUR",{"$f":"-X46*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opleidingskosten direct personeel",null,null,"EUR",{"$f":"-X47*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kosten uitbesteed werk (specialist)",null,null,"EUR",{"$f":"-X48*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Garantiekosten",null,null,"EUR",{"$f":"-X49*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kosten service-auto",null,null,"EUR",{"$f":"-X50*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Marketingkosten werkplaats",null,null,"EUR",{"$f":"-X51*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Equipment leasekosten",null,null,"EUR",{"$f":"-X52*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bestaande afschrijvingslasten - direct",null,null,"EUR",{"$f":"-X53*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nieuwe afschrijvingslasten - direct",null,null,"EUR",{"$f":"-X54*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overige directe kosten",null,null,"EUR",{"$f":"-X55*I_Generiek!$F$18","v":0}]
[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",{"$f":"SUM(X89:Y98)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T58","v":"Indirecte kosten"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personeelskosten indirect personeel",null,null,"EUR",{"$f":"-X59*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Opleidingskosten indirect personeel",null,null,"EUR",{"$f":"-X60*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bestaande afschrijvingslasten - indirect",null,null,"EUR",{"$f":"-X61*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR",{"$f":"-X62*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bestaande rentelasten",null,null,"EUR",{"$f":"-X63*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR",{"$f":"-X64*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IT kosten",null,null,"EUR",{"$f":"-X65*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Energiekosten",null,null,"EUR",{"$f":"-X66*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Huisvestingskosten",null,null,"EUR",{"$f":"-X67*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Algemene marketingkosten",null,null,"EUR",{"$f":"-X68*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Management fee / Ondernemersbeloning",null,null,"EUR",{"$f":"-X69*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overige indirecte kosten",null,null,"EUR",{"$f":"-X70*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaal indirecte kosten",null,null,"EUR",{"$f":"SUM(X102:Y113)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resultaat (voor belasting)",null,null,"EUR",{"$f":"SUM(X86,X99,X114)","v":0}]

{"sheet":"O_Graph","index":13,"n_rows":121,"n_cols":16,"rows_kept":121,"cut":false,"hidden":false,"merged":[[85,7,85,8],[86,7,86,8],[87,7,87,8],[83,7,83,8],[82,7,82,8],[84,7,84,8],[88,7,88,8],[101,7,101,8],[92,7,92,8],[93,7,93,8],[94,7,94,8],[95,7,95,8],[96,7,96,8],[97,7,97,8],[98,7,98,8],[99,7,99,8],[100,7,100,8],[89,7,89,8],[90,7,90,8],[91,7,91,8],[70,7,70,8],[71,7,71,8],[72,7,72,8],[73,7,73,8],[74,7,74,8],[75,7,75,8],[77,7,77,8],[79,7,79,8],[80,7,80,8],[81,7,81,8],[76,7,76,8],[78,7,78,8]]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \nOnafhankelijke Autobedrijven (OAB) | 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!F256","v":"Directe personeelskosten"},null,null,{"$f":"C_Base!Q256","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!F257","v":"Indirecte personeelskosten"},null,null,{"$f":"C_Base!Q257","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!F258","v":"Directe afschrijvingslasten"},null,null,{"$f":"C_Base!Q258","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!F259","v":"Indirecte afschrijvingslasten"},null,null,{"$f":"C_Base!Q259","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!F260","v":"Rentelasten"},null,null,{"$f":"C_Base!Q260","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!F261","v":"Directe overige kosten"},null,null,{"$f":"C_Base!Q261","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!F262","v":"Indirecte overige kosten"},null,null,{"$f":"C_Base!Q262","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!F158","v":"Directe personeelskosten"},null,null,{"$f":"C_Scenario!O158","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!F159","v":"Indirecte personeelskosten"},null,null,{"$f":"C_Scenario!O159","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!F160","v":"Directe afschrijvingslasten"},null,null,{"$f":"C_Scenario!O160","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!F161","v":"Indirecte afschrijvingslasten"},null,null,{"$f":"C_Scenario!O161","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!F162","v":"Rentelasten"},null,null,{"$f":"C_Scenario!O162","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!F163","v":"Directe overige kosten"},null,null,{"$f":"C_Scenario!O163","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!F164","v":"Indirecte overige kosten"},null,null,{"$f":"C_Scenario!O164","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.","Waterval 3 - Omzet, marges en resultaat"]
[]
[null,null,null,"3.1","Omzet, marges en resultaat"]
[]
[null,null,null,null,"Bruto omzet",null,null,{"$f":"IFERROR(IF(I_Omzet!$G$9<>\"Ja\",I_Omzet!K11*INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH(I_Omzet!M11,I_Verdeelsleutel!$E$11:$E$18,0)),I_Omzet!K11),0)","v":0}]
[null,null,null,null,"Korting leasemaatschappijen",null,null,{"$f":"-IFERROR(IF(I_Omzet!$G$9<>\"Ja\",I_Omzet!K13*INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH(I_Omzet!M13,I_Verdeelsleutel!$E$11:$E$18,0)),I_Omzet!K13),0)","v":0}]
[null,null,null,null,"Netto omzet",null,null,{"$f":"SUM(H61:H62)","v":0}]
[null,null,null,null,"Materiaalkosten",null,null,{"$f":"-IFERROR(IF(I_Omzet!$G$9<>\"Ja\",I_Omzet!K15*INDEX(I_Verdeelsleutel!$K$11:$K$18,MATCH(I_Omzet!M15,I_Verdeelsleutel!$E$11:$E$18,0)),I_Omzet!K15),0)","v":0}]
[null,null,null,null,"Brutomarge",null,null,{"$f":"SUM(H63:H64)","v":0}]
[null,null,null,null,"Bedrijfskosten",null,null,{"$f":"-C_Scenario!K146","v":0}]
[null,null,null,null,"Resultaat (voor belasting)",null,null,{"$f":"SUM(H65:H66)","v":0}]
[]
[null,null,"4.","Mapping kostprijs detail inzicht",null,null,null,"Input gebruiker",null,null,"Gekozen mapping",null,null,null,"Base","Scenario"]
[]
[null,null,null,"4.1","Classificatie volgens metamodel",null,null,{"$f":"C_Scenario!F170","v":"Directe personeelskosten"},null,null,"Personeelskosten direct personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H71,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H71,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F171","v":"Opleidingskosten direct personeel"},null,null,"Opleidingskosten direct personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H72,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H72,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Personeelskosten direct personeel",null,null,{"$f":"C_Scenario!F172","v":"Indirecte personeelskosten"},null,null,"Personeelskosten indirect personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H73,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H73,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Opleidingskosten direct personeel",null,null,{"$f":"C_Scenario!F173","v":"Opleidingskosten indirect personeel"},null,null,"Opleidingskosten indirect personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H74,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H74,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E39","v":"Kosten uitbesteed werk (specialist)"},null,null,{"$f":"C_Scenario!F174","v":"Bestaande afschrijvingslasten - direct"},null,null,"Bestaande afschrijvingslasten - direct",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H75,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H75,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E41","v":"Garantiekosten"},null,null,{"$f":"C_Scenario!F175","v":"Bestaande afschrijvingslasten - indirect"},null,null,"Bestaande afschrijvingslasten - indirect",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H76,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H76,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E43","v":"Kosten service-auto"},null,null,{"$f":"C_Scenario!F176","v":"Nieuwe afschrijvingslasten - direct"},null,null,"Nieuwe afschrijvingslasten - direct",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H77,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H77,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E45","v":"Marketingkosten werkplaats"},null,null,{"$f":"C_Scenario!F177","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"Nieuwe afschrijvingslasten - indirect",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H78,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H78,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E47","v":"Equipment leasekosten"},null,null,{"$f":"C_Scenario!F178","v":"Bestaande rentelasten"},null,null,"Bestaande rentelasten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H79,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H79,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Bestaande afschrijvingslasten - direct",null,null,{"$f":"C_Scenario!F179","v":"Nieuwe rentelasten"},null,null,"Nieuwe rentelasten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H80,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H80,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Nieuwe afschrijvingslasten - direct",null,null,{"$f":"C_Scenario!F180","v":"Kosten uitbesteed werk (specialist)"},null,null,"Kosten uitbesteed werk (specialist)",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H81,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H81,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Overige directe kosten",null,null,{"$f":"C_Scenario!F181","v":"Garantiekosten"},null,null,"Garantiekosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H82,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H82,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Personeelskosten indirect personeel",null,null,{"$f":"C_Scenario!F182","v":"Kosten service-auto"},null,null,"Kosten service-auto",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H83,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H83,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Opleidingskosten indirect personeel",null,null,{"$f":"C_Scenario!F183","v":"Marketingkosten werkplaats"},null,null,"Marketingkosten werkplaats",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H84,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H84,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Bestaande afschrijvingslasten - indirect",null,null,{"$f":"C_Scenario!F184","v":"Equipment leasekosten"},null,null,"Equipment leasekosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H85,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H85,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,{"$f":"C_Scenario!F185","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H86,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H86,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Bestaande rentelasten",null,null,{"$f":"C_Scenario!F186","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H87,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H87,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Nieuwe rentelasten",null,null,{"$f":"C_Scenario!F187","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H88,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H88,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E59","v":"IT kosten"},null,null,{"$f":"C_Scenario!F188","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H89,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H89,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E61","v":"Energiekosten"},null,null,{"$f":"C_Scenario!F189","v":"IT kosten"},null,null,"IT kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H90,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H90,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E63","v":"Huisvestingskosten"},null,null,{"$f":"C_Scenario!F190","v":"Energiekosten"},null,null,"Energiekosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H91,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H91,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E65","v":"Algemene marketingkosten"},null,null,{"$f":"C_Scenario!F191","v":"Huisvestingskosten"},null,null,"Huisvestingskosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H92,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H92,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E67","v":"Management fee / Ondernemersbeloning"},null,null,{"$f":"C_Scenario!F192","v":"Algemene marketingkosten"},null,null,"Algemene marketingkosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H93,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H93,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,"Overige indirecte kosten",null,null,{"$f":"C_Scenario!F193","v":"Management fee / Ondernemersbeloning"},null,null,"Management fee / Ondernemersbeloning",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H94,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H94,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F194","v":"Overige indirecte kosten"},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H95,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H95,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F195","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H96,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H96,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F196","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H97,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H97,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F197","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H98,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H98,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F198","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H99,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H99,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F199","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H100,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H100,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F200","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H101,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H101,C_Scenario!$F$170:$F$201,0))","v":0}]
[null,null,null,"4.2",null,null,null,{"$f":"C_Scenario!F201","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$170:$K$201,MATCH($H102,C_Scenario!$F$170:$F$201,0))","v":0},{"$f":"INDEX(C_Scenario!$O$170:$O$201,MATCH($H102,C_Scenario!$F$170:$F$201,0))","v":0}]
[]
[null,null,null,null,"Check",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O71:O102)=C_Scenario!K203","v":true},{"$f":"SUM(P71:P102)=C_Scenario!O203","v":true}]
[]
[null,null,"5.","KPI's en ratio's"]
[]
[null,null,null,"5.1"]
[]
[null,null,null,null,"KPI's en ratio's"]
[null,null,null,null,null,null,null,"Ratio","Restant"]
[null,null,null,null,"Energiekosten / totale kosten",null,null,{"$f":"C_Scenario!K119/C_Scenario!K146","v":{"$error":"#DIV/0!"}},{"$f":"100%-H112","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Personeelskosten / totale kosten",null,null,{"$f":"SUM(C_Scenario!K138:K139)/C_Scenario!K146","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"Personeelskosten / netto omzet",null,null,{"$f":"SUM(C_Scenario!K138:K139)/H63","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"Afschrijvingen en leasekosten / netto omzet",null,null,{"$f":"SUM(C_Scenario!K140:K141,C_Scenario!K106)/H63","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"Rentelasten / netto omzet",null,null,{"$f":"C_Scenario!K142/H63","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"Directe kosten / netto omzet",null,null,{"$f":"SUM(C_Scenario!K138,C_Scenario!K140,C_Scenario!K143)/H63","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"Directe kosten / totale kosten",null,null,{"$f":"SUM(C_Scenario!K32,C_Scenario!K138,C_Scenario!K143)/C_Scenario!K146","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"Indirecte kosten / totale kosten",null,null,{"$f":"(SUM(C_Scenario!K139:K142,C_Scenario!K144)-C_Scenario!K32)/C_Scenario!K146","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"Indirecte kosten / netto omzet",null,null,{"$f":"SUM(C_Scenario!K139,C_Scenario!K141:K142,C_Scenario!K144)/H63","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,"Directe kosten per gefactureerd uur",null,null,{"$f":"SUM(C_Scenario!K138,C_Scenario!K140,C_Scenario!K143)/C_Scenario!K152","v":{"$error":"#DIV/0!"}}]

{"sheet":"CHECK","index":14,"n_rows":214,"n_cols":12,"rows_kept":214,"cut":false,"hidden":false,"merged":[[7,10,7,11]]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \nOnafhankelijke Autobedrijven (OAB) | 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:H87)","v":7},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!K11:K18)*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 de directe personeelskosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K13=0,COUNTA(I_Kosten!K13)=COUNTA(I_Kosten!M13)),TRUE,FALSE)","v":true},0,{"$f":"IF(H23=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.3","Heeft u de opleidingskosten voor direct personeel 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 indirecte personeelskosten 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.5","Heeft u de opleidingskosten voor indirect 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 de directe afschrijvingslasten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K25=0,COUNTA(I_Kosten!K25)=COUNTA(I_Kosten!M25)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.8","Heeft u de indirecte afschrijvingslasten 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.6","Heeft u een keuze gemaakt om wel of niet extra investeringen te willen invullen?",null,{"$f":"IF(I_Kosten!G29=\"\",FALSE,TRUE)","v":false},1,{"$f":"IF(H29=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"3.8","Heeft u de rentelasten 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},{"$f":"IF(G30=FALSE,1,0)","v":0},{"$f":"IF(H30=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.9","Heeft u een keuze gemaakt om wel of niet nieuwe rentelasten te willen invullen?",null,{"$f":"IF(I_Kosten!G35=\"\",FALSE,TRUE)","v":false},1,"KLIK HIER"]
[null,null,null,"3.10","Heeft u de kosten uitbesteed werk (specialist) 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},0,""]
[null,null,null,"3.11","Heeft u de garantiekosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K41=0,COUNTA(I_Kosten!K41)=COUNTA(I_Kosten!K41)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.12","Heeft u de kosten service-auto ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K43=0,COUNTA(I_Kosten!K43)=COUNTA(I_Kosten!M43)),TRUE,FALSE)","v":true},{"$f":"IF(G34=FALSE,1,0)","v":0},{"$f":"IF(H34=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.13","Heeft u de marketingkosten werkplaats 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.14","Heeft u de equipment leasekosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K47=0,COUNTA(I_Kosten!K47)=COUNTA(I_Kosten!M47)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.15","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K49=0,COUNTA(I_Kosten!K49)=COUNTA(I_Kosten!M49)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.16","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten 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.17","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten 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.18","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K55=0,COUNTA(I_Kosten!K55)=COUNTA(I_Kosten!M55)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.19","Heeft u de IT kosten 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.20","Heeft u de energiekosten 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.21","Heeft u de huisvestingkosten 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.22","Heeft u de algemene marketingkosten 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},{"$f":"IF(G44=FALSE,1,0)","v":0},{"$f":"IF(H44=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.23","Heeft u de management fee / ondernemersbeloning 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.24","Heeft u de overige indirecte kosten 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},{"$f":"IF(G46=FALSE,1,0)","v":0},{"$f":"IF(H46=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.25","Heeft u gebruik gemaakt van de lege velden bij indirecte 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},{"$f":"IF(G47=FALSE,1,0)","v":0},""]
[null,null,null,"3.26","Heeft u gebruik gemaakt van de lege velden bij indirecte 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.27","Heeft u gebruik gemaakt van de lege velden bij indirecte 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.28","Heeft u gebruik gemaakt van de lege velden bij indirecte 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.29","Heeft u gebruik gemaakt van de lege velden bij indirecte 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.30","Heeft u gebruik gemaakt van de lege velden bij indirecte 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.31","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K83=0,COUNTA(I_Kosten!K83)=COUNTA(I_Kosten!M83)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.32","Komen de ingevoerde totale bedrijfskosten overeen met de optelling van de afzonderlijke kosten?",null,{"$f":"I_Kosten!K91","v":true},0,""]
[]
[null,null,"4.","I_Omzet"]
[]
[null,null,null,"4.1","Heeft u aangegeven of de ingevulde kosten op I_Kosten enkel betrekking hebben op de werkplaats?",null,{"$f":"IF(I_Omzet!$G$9=\"\",FALSE,TRUE)","v":false},{"$f":"IF(G58=FALSE,1,0)","v":1},{"$f":"IF(H58=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"4.2","Heeft u de bruto omzet ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Omzet!K11=0,I_Omzet!$G$9=\"Ja\",COUNTA(I_Omzet!K11)=COUNTA(I_Omzet!M11)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.3","Heeft u de korting leasemaatschappijen ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Omzet!K13=0,I_Omzet!$G$9=\"Ja\",COUNTA(I_Omzet!K13)=COUNTA(I_Omzet!M13)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"4.4","Heeft u de materiaalkosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Omzet!K15=0,I_Omzet!$G$9=\"Ja\",COUNTA(I_Omzet!K15)=COUNTA(I_Omzet!M15)),TRUE,FALSE)","v":true},0,""]
[]
[null,null,"5.","I_Investeringen"]
[]
[null,null,null,"5.1","Heeft u een keuze gemaakt voor eenvoudige of detail invoer voor extra investeringen?",null,{"$f":"IF(AND(I_Kosten!$G$35=\"Ja\",I_Investeringen!G9=\"\"),FALSE,TRUE)","v":true},{"$f":"IF(G65=FALSE,1,0)","v":0},{"$f":"IF(H65=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"5.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,"5.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,"5.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,"5.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,"5.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,"5.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,"5.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,"5.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,"5.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,"5.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!G63<>\"\",I_Investeringen!G64<>\"\",I_Investeringen!K65:K67<>\"\",I_Investeringen!M63<>\"\",I_Investeringen!O63<>\"\"),AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G63=\"\",I_Investeringen!G64=\"\",I_Investeringen!K65:K67=\"\",I_Investeringen!M63=\"\",I_Investeringen!O63=\"\")),TRUE,FALSE)","v":true},{"$f":"IF(G75=FALSE,1,0)","v":0},{"$f":"IF(H75=1,\"KLIK HIER\",\"\")","v":""}]
[]
[null,null,"6.","I_Financiering"]
[]
[null,null,null,"6.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(G79=FALSE,1,0)","v":0},{"$f":"IF(H79=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"6.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,"6.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,"6.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,"6.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,"6.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,"6.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,"6.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!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,"6.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"]