{"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":8,"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 \n(Gemotoriseerde) Tweewielers"]
[]
[]
[]
[]
[]
[null,null,"Finale versie"]

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

{"sheet":"I_Generiek","index":2,"n_rows":213,"n_cols":6,"rows_kept":213,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \n(Gemotoriseerde) Tweewielers | 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":"\"Extern gefactureerde uren \"&$F$9","v":"Extern gefactureerde uren "}]
[]
[null,null,null,null,"Eenheid",{"$f":"\"Gefactureerde uren \"&$F$9","v":"Gefactureerde uren "}]
[]
[null,null,null,null,"Extern gefactureerde uren"]
[]
[null,null,null,"1.2",{"$f":"\"Intern gefactureerde uren \"&F9","v":"Intern gefactureerde uren "}]
[]
[null,null,null,null,"Eenheid",{"$f":"\"Gefactureerde uren \"&$F$9","v":"Gefactureerde uren "}]
[]
[null,null,null,null,"Intern gefactureerde uren"]
[]
[null,null,"2.","Toekenning directe en indirecte kosten"]
[]
[null,null,null,null,"Directe- / Indirecte kosten","Kosten item"]
[]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E23","v":"Opleidingskosten direct personeel"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E33","v":"Afschrijvingslasten - direct"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E59","v":"Huisvestingskosten"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E47","v":"Leasekosten werkplaatsapparatuur"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E49","v":"Kosten gereedschappen klein"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E51","v":"Garantiekosten"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E53","v":"Franchisekosten"}]
[null,null,null,null,"Directe kosten",{"$f":"I_Kosten!E55","v":"Transportkosten"}]
[null,null,null,0,{"$f":"IF(F39=\"\",\"\",\"Directe kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$73,$D39,)=\"\",\"\",OFFSET(I_Kosten!$F$73,$D39,))","v":""}]
[null,null,null,{"$f":"D39+2","v":2},"",{"$f":"IF(OFFSET(I_Kosten!$F$73,$D40,)=\"\",\"\",OFFSET(I_Kosten!$F$73,$D40,))","v":""}]
[null,null,null,{"$f":"D40+2","v":4},"",{"$f":"IF(OFFSET(I_Kosten!$F$73,$D41,)=\"\",\"\",OFFSET(I_Kosten!$F$73,$D41,))","v":""}]
[null,null,null,6,"",{"$f":"IF(OFFSET(I_Kosten!$F$73,$D42,)=\"\",\"\",OFFSET(I_Kosten!$F$73,$D42,))","v":""}]
[]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E27","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E29","v":"Opleidingskosten indirect personeel"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E35","v":"Afschrijvingslasten - indirect"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E41","v":"Rentelasten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E83","v":"Management fee / Ondernemersbeloning"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E85","v":"IT kosten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E87","v":"Energiekosten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E89","v":"Marketingkosten"}]
[null,null,null,null,"Indirecte kosten",{"$f":"I_Kosten!E91","v":"Overige indirecte kosten"}]
[null,null,null,0,{"$f":"IF(F53=\"\",\"\",\"Indirecte kosten\")","v":""},{"$f":"IF(OFFSET(I_Kosten!$F$93,$D53,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D53,))","v":""}]
[null,null,null,{"$f":"D53+2","v":2},"",{"$f":"IF(OFFSET(I_Kosten!$F$93,$D54,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D54,))","v":""}]
[null,null,null,{"$f":"D54+2","v":4},"",{"$f":"IF(OFFSET(I_Kosten!$F$93,$D55,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D55,))","v":""}]
[null,null,null,6,"",{"$f":"IF(OFFSET(I_Kosten!$F$93,$D56,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D56,))","v":""}]
[null,null,null,8,"",{"$f":"IF(OFFSET(I_Kosten!$F$93,$D57,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D57,))","v":""}]
[null,null,null,10,"",{"$f":"IF(OFFSET(I_Kosten!$F$93,$D58,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D58,))","v":""}]
[null,null,null,12,"",{"$f":"IF(OFFSET(I_Kosten!$F$93,$D59,)=\"\",\"\",OFFSET(I_Kosten!$F$93,$D59,))","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":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \n(Gemotoriseerde) Tweewielers | I_Verdeelsleutel"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"I_Verdeelsleutel"}]
[null,null,"Verdeelsleutel"]
[]
[]
[null,null,"1.","Verdeelsleutel voor kosten"]
[]
[null,null,null,null,"Verdeelsleutel","Eenheid","Totaal","Behorende aan werkplaats","Behorende aan Sales","% werkplaats","Check"]
[]
[null,null,null,null,"Percentage",{"$f":"IF(E11=\"\",\"\",\"%\")","v":"%"},1,null,null,{"$f":"IFERROR($H11/SUM($H11:$I11),\"\")","v":""},{"$f":"IF(AND(SUM(H11:I11)=G11,G11<>\"\",E11:G11<>\"\"),TRUE,FALSE)","v":false},{"$f":"IF(AND($G11<>SUM($H11:$I11),SUM($H11:$I11)<>0),\"Let op: Het Totaal komt niet overeen met de optelling van werkplaats en Sales\",\"\")","v":""}]
[null,null,null,null,"Omzet","EUR",null,null,null,{"$f":"IFERROR($H12/SUM($H12:$I12),\"\")","v":""},{"$f":"IF(AND(SUM(H12:I12)=G12,G12<>\"\",E12:G12<>\"\"),TRUE,FALSE)","v":false},{"$f":"IF(AND($G12<>SUM($H12:$I12),SUM($H12:$I12)<>0),\"Let op: Het Totaal komt niet overeen met de optelling van werkplaats en Sales\",\"\")","v":""}]
[null,null,null,null,"Kosten","EUR",null,null,null,"",{"$f":"IF(AND(SUM(H13:I13)=G13,G13<>\"\",E13:G13<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,"Aantal medewerkers","Aantal",null,null,null,"",{"$f":"IF(AND(SUM(H14:I14)=G14,G14<>\"\",E14:G14<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,"Gebruiksoppervlak","m²",null,null,null,"",{"$f":"IF(AND(SUM(H15:I15)=G15,G15<>\"\",E15:G15<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(SUM(H16:I16)=G16,G16<>\"\",E16:G16<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(SUM(H17:I17)=G17,G17<>\"\",E17:G17<>\"\"),TRUE,FALSE)","v":false},""]
[null,null,null,null,null,null,null,null,null,"",{"$f":"IF(AND(SUM(H18:I18)=G18,G18<>\"\",E18:G18<>\"\"),TRUE,FALSE)","v":false},""]

{"sheet":"I_Kosten","index":4,"n_rows":114,"n_cols":13,"rows_kept":114,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \n(Gemotoriseerde) Tweewielers | I_Kosten"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"I_Kosten"}]
[null,null,{"$f":"\"Kosten \"&I_Generiek!$F$9","v":"Kosten "}]
[null,null,null,null,null,null,"Keuze",null,"Eenheid",null,{"$f":"I_Generiek!$F$9","v":0},null,"Verdeelsleutel"]
[]
[null,null,"0.","Totale bedrijfskosten"]
[]
[null,null,null,"0.1","Totale bedrijfskosten (alle directe + indirecte kosten)"]
[]
[null,null,"1.","Personele lasten direct personeel"]
[]
[null,null,null,"1.1","Personeelskosten op meer detail niveau invullen?"]
[]
[null,null,null,"1.2","Totale personeelskosten direct personeel (excl. opleidingskosten)",null,null,null,"EUR / jaar"]
[]
[null,null,null,null,"1.2.1","Brutolonen",null,null,"EUR / jaar"]
[]
[null,null,null,null,"1.2.2","Sociale-en werkgeverslasten",null,null,"EUR / jaar"]
[]
[null,null,null,null,"1.2.3","Overige personeelskosten",null,null,"EUR / jaar"]
[]
[null,null,null,"1.3","Opleidingskosten direct personeel",null,null,null,"EUR / jaar"]
[]
[null,null,"2.","Personele lasten indirect personeel"]
[]
[null,null,null,"2.1","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,"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($G37=\"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(K37=\"\",\"\",\"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($G43=\"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(K43=\"\",\"\",\"KLIK HIER\")","v":""}]
[null,null,"5.","Directe overige kosten"]
[]
[null,null,null,"5.1","Leasekosten werkplaatsapparatuur",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.2","Kosten gereedschappen klein",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.3","Garantiekosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.4","Franchisekosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.5","Transportkosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.6","Wilt u de huisvestingskosten op detail niveau invoeren?"]
[]
[null,null,null,"5.7","Huisvestingskosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.7.1","Huisvestingskosten - Huur",null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.7.2","Huisvestingskosten - Onderhoud",null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.7.3","Huisvestingskosten - Verzekeringen",null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.7.4",null,null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.7.5",null,null,null,"EUR / jaar"]
[]
[null,null,null,null,"5.7.6",null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.8",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.9",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.10",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"5.11",null,null,null,null,"EUR / jaar"]
[]
[null,null,"6.","Overige indirecte kosten"]
[]
[null,null,null,"6.1","Management fee / Ondernemersbeloning",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.2","IT kosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.3","Energiekosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.4","Marketingkosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.5","Overige indirecte kosten",null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.6",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.7",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.8",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.9",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.10",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.11",null,null,null,null,"EUR / jaar"]
[]
[null,null,null,"6.12",null,null,null,null,"EUR / jaar"]
[]
[null,null,"7.","Check totale kosten"]
[]
[null,null,null,"7.1","Ingevulde totale bedrijfskosten",null,null,null,"EUR / jaar",null,{"$f":"K9","v":0}]
[]
[null,null,null,"7.2","Optelling ingevulde individuele kosten",null,null,null,"EUR / jaar",null,{"$f":"SUM(IF(G13=\"Nee\",K15,IF(G13=\"Ja\",K17:K21,0)),K23,K27:K29,K33,K35,K41,K47:K55,IF(G57=\"Nee\",K59,IF(G57=\"Ja\",K61:K71,0)),K73:K79,K83:K105)","v":0}]
[]
[null,null,null,"7.3","Controle of de ingevulde totale bedrijfskosten gelijk is aan de optelling van de ingevulde individuele kosten",null,null,null,null,null,{"$f":"K109=K111","v":true}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF($K113=FALSE,\"Let op, de ingevulde totale bedrijfskosten komen niet overeen met de optelling van de ingevulde individuele kosten\",\"\")","v":""}]

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

{"sheet":"I_Financiering","index":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 \n(Gemotoriseerde) Tweewielers | 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$43=\"\",I_Kosten!$G$43=\"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":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Calc >>>"]

{"sheet":"C_Base","index":9,"n_rows":337,"n_cols":17,"rows_kept":337,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \n(Gemotoriseerde) Tweewielers | C_Base"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"C_Base"}]
[null,null,"Calculatie_Base"]
[null,null,null,null,null,null,null,null,null,null,"Input",null,"Verdeelsleutel",null,"% werkplaats",null,"Berekening werkplaats"]
[]
[null,null,"1.","Personeelskosten"]
[]
[null,null,null,"1.1",null,"Direct personeel - personeelskosten (excl. opleidingskosten) - Eenvoudige invoer",null,null,null,{"$f":"IF(J13=\"Ja\",\"Nee\",IF(J13=0,0,\"Ja\"))","v":0}]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"IF($J$9=\"Ja\",I_Kosten!K15,0)","v":0},null,{"$f":"I_Kosten!M15","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M11,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M11,I_Verdeelsleutel!$E$11:$E$18,0))*$K11,0)","v":0}]
[]
[null,null,null,"1.2",null,"Direct personeel - personeelskosten (excl. opleidingskosten) - Detail invoer",null,null,null,{"$f":"I_Kosten!G13","v":0}]
[]
[null,null,null,null,null,{"$f":"I_Kosten!F17","v":"Brutolonen"},null,null,"EUR / jaar",null,{"$f":"IF($J$13=\"Ja\",I_Kosten!K17,0)","v":0},null,{"$f":"I_Kosten!M17","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M15,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M15,I_Verdeelsleutel!$E$11:$E$18,0))*$K15,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!F19","v":"Sociale-en werkgeverslasten"},null,null,"EUR / jaar",null,{"$f":"IF($J$13=\"Ja\",I_Kosten!K19,0)","v":0},null,{"$f":"I_Kosten!M19","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M16,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M16,I_Verdeelsleutel!$E$11:$E$18,0))*$K16,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!F21","v":"Overige personeelskosten"},null,null,"EUR / jaar",null,{"$f":"IF($J$13=\"Ja\",I_Kosten!K21,0)","v":0},null,{"$f":"I_Kosten!M21","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M17,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M17,I_Verdeelsleutel!$E$11:$E$18,0))*$K17,0)","v":0}]
[]
[null,null,null,"1.3",null,"Totale personeelskosten direct personeel (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"SUM(K11,K15:K17)","v":0},null,null,null,null,null,{"$f":"SUM(Q11,Q15:Q17)","v":0}]
[]
[null,null,null,"1.4",null,"Direct personeel - opleidingskosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E23","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K23","v":0},null,{"$f":"I_Kosten!M23","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M25,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M25,I_Verdeelsleutel!$E$11:$E$18,0))*$K25,0)","v":0}]
[]
[null,null,null,"1.5",null,"Indirect personeel - personeelskosten (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E27","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K27","v":0},null,{"$f":"I_Kosten!M27","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M29,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M29,I_Verdeelsleutel!$E$11:$E$18,0))*$K29,0)","v":0}]
[]
[null,null,null,"1.6",null,"Totale personeelskosten indirect personeel (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E27","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K29","v":0},null,null,null,null,null,{"$f":"Q29","v":0}]
[]
[null,null,null,"1.7",null,"Indirect personeel - opleidingskosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E29","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K29","v":0},null,{"$f":"I_Kosten!M29","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M37,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M37,I_Verdeelsleutel!$E$11:$E$18,0))*$K37,0)","v":0}]
[]
[null,null,null,"1.8",null,"Totale personeelskosten"]
[]
[null,null,null,null,null,{"$f":"F21","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K21","v":0},null,null,null,null,null,{"$f":"Q21","v":0}]
[null,null,null,null,null,{"$f":"F25","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"K25","v":0},null,null,null,null,null,{"$f":"Q25","v":0}]
[null,null,null,null,null,{"$f":"F31","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K33","v":0},null,null,null,null,null,{"$f":"Q33","v":0}]
[null,null,null,null,null,{"$f":"F37","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"K37","v":0},null,null,null,null,null,{"$f":"Q37","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K41:K44)","v":0},null,null,null,null,null,{"$f":"SUM(Q41:Q44)","v":0}]
[]
[null,null,"2.",{"$f":"I_Kosten!D31","v":"Afschrijvingen"}]
[]
[null,null,null,"2.1",null,"Bestaande afschrijvingslasten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E33","v":"Afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K33","v":0},null,{"$f":"I_Kosten!M33","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M52,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M52,I_Verdeelsleutel!$E$11:$E$18,0))*$K52,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E35","v":"Afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K35","v":0},null,{"$f":"I_Kosten!M35","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M53,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M53,I_Verdeelsleutel!$E$11:$E$18,0))*$K53,0)","v":0}]
[]
[null,null,null,"2.2",null,"Nieuwe afschrijvingslasten (als gevolg van investeringen) - detail invoer",null,null,null,{"$f":"IF(J135=\"Ja\",\"Nee\",IF(J135=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$37","v":0},{"$f":"IF($J63=\"Ja\",IFERROR((K58-K60)/K59,0),0)","v":0},null,{"$f":"I_Investeringen!M26","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M63,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M63,I_Verdeelsleutel!$E$11:$E$18,0))*$K63,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$37","v":0},{"$f":"IF($J71=\"Ja\",IFERROR((K66-K68)/K67,0),0)","v":0},null,{"$f":"I_Investeringen!M32","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M71,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M71,I_Verdeelsleutel!$E$11:$E$18,0))*$K71,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$37","v":0},{"$f":"IF($J79=\"Ja\",IFERROR((K74-K76)/K75,0),0)","v":0},null,{"$f":"I_Investeringen!M38","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M79,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M79,I_Verdeelsleutel!$E$11:$E$18,0))*$K79,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$37","v":0},{"$f":"IF($J87=\"Ja\",IFERROR((K82-K84)/K83,0),0)","v":0},null,{"$f":"I_Investeringen!M44","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M87,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M87,I_Verdeelsleutel!$E$11:$E$18,0))*$K87,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$37","v":0},{"$f":"IF($J95=\"Ja\",IFERROR((K90-K92)/K91,0),0)","v":0},null,{"$f":"I_Investeringen!M50","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M95,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M95,I_Verdeelsleutel!$E$11:$E$18,0))*$K95,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$37","v":0},{"$f":"IF($J103=\"Ja\",IFERROR((K98-K100)/K99,0),0)","v":0},null,{"$f":"I_Investeringen!M56","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M103,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M103,I_Verdeelsleutel!$E$11:$E$18,0))*$K103,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$37","v":0},{"$f":"IF($J111=\"Ja\",IFERROR((K106-K108)/K107,0),0)","v":0},null,{"$f":"I_Investeringen!M62","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M111,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M111,I_Verdeelsleutel!$E$11:$E$18,0))*$K111,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$37","v":0},{"$f":"IF($J119=\"Ja\",IFERROR((K114-K116)/K115,0),0)","v":0},null,{"$f":"I_Investeringen!M68","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M119,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M119,I_Verdeelsleutel!$E$11:$E$18,0))*$K119,0)","v":0}]
[]
[null,null,null,null,"2.2.9","Totaal nieuwe afschrijvingslasten - detail invoer"]
[]
[null,null,null,null,null,{"$f":"F57","v":""},null,null,"EUR / jaar",{"$f":"J61","v":0},{"$f":"K63","v":0},null,null,null,null,null,{"$f":"Q63","v":0}]
[null,null,null,null,null,{"$f":"F65","v":""},null,null,"EUR / jaar",{"$f":"J69","v":0},{"$f":"K71","v":0},null,null,null,null,null,{"$f":"Q71","v":0}]
[null,null,null,null,null,{"$f":"F73","v":""},null,null,"EUR / jaar",{"$f":"J77","v":0},{"$f":"K79","v":0},null,null,null,null,null,{"$f":"Q79","v":0}]
[null,null,null,null,null,{"$f":"F81","v":""},null,null,"EUR / jaar",{"$f":"J85","v":0},{"$f":"K87","v":0},null,null,null,null,null,{"$f":"Q87","v":0}]
[null,null,null,null,null,{"$f":"F89","v":""},null,null,"EUR / jaar",{"$f":"J93","v":0},{"$f":"K95","v":0},null,null,null,null,null,{"$f":"Q95","v":0}]
[null,null,null,null,null,{"$f":"F97","v":""},null,null,"EUR / jaar",{"$f":"J101","v":0},{"$f":"K103","v":0},null,null,null,null,null,{"$f":"Q103","v":0}]
[null,null,null,null,null,{"$f":"F105","v":""},null,null,"EUR / jaar",{"$f":"J109","v":0},{"$f":"K111","v":0},null,null,null,null,null,{"$f":"Q111","v":0}]
[null,null,null,null,null,{"$f":"F113","v":""},null,null,"EUR / jaar",{"$f":"J117","v":0},{"$f":"K119","v":0},null,null,null,null,null,{"$f":"Q119","v":0}]
[]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - direct",null,null,"EUR / jaar","Direct",{"$f":"SUMIF($J$123:$J$130,$J132,K$123:K$130)","v":0},null,null,null,null,null,{"$f":"SUMIF($J$123:$J$130,$J132,Q$123:Q$130)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR / jaar","Indirect",{"$f":"SUMIF($J$123:$J$130,$J133,K$123:K$130)","v":0},null,null,null,null,null,{"$f":"SUMIF($J$123:$J$130,$J133,Q$123:Q$130)","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$37","v":0},{"$f":"IF($J137=\"Ja\",I_Investeringen!$K$10,0)","v":0},null,{"$f":"I_Investeringen!$M$10","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M137,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M137,I_Verdeelsleutel!$E$11:$E$18,0))*$K137,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$37","v":0},{"$f":"IF($J138=\"Ja\",I_Investeringen!$K$11,0)","v":0},null,{"$f":"I_Investeringen!$M$11","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M138,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M138,I_Verdeelsleutel!$E$11:$E$18,0))*$K138,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":"K52","v":0},null,null,null,null,null,{"$f":"Q52","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - indirect",null,null,"EUR / jaar",null,{"$f":"K53","v":0},null,null,null,null,null,{"$f":"Q53","v":0}]
[null,null,null,null,null,{"$f":"F137","v":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"IF($J$55=\"Ja\",K132,K137)","v":0},null,null,null,null,null,{"$f":"IF($J$55=\"Ja\",Q132,Q137)","v":0}]
[null,null,null,null,null,{"$f":"F138","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"IF($J$55=\"Ja\",K133,K138)","v":0},null,null,null,null,null,{"$f":"IF($J$55=\"Ja\",Q133,Q138)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K142:K145)","v":0},null,null,null,null,null,{"$f":"SUM(Q142:Q145)","v":0}]
[]
[null,null,"3.",{"$f":"I_Kosten!D39","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!K41","v":0},null,{"$f":"I_Kosten!M41","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M153,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M153,I_Verdeelsleutel!$E$11:$E$18,0))*$K153,0)","v":0}]
[]
[null,null,null,"3.2",null,"Nieuwe rentelasten (als gevolg van nieuwe financiering) - detail invoer",null,null,null,{"$f":"IF(J205=\"Ja\",\"Nee\",IF(J205=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$43","v":0},{"$f":"IF($J161=\"Ja\",IFERROR(K158*K159,0),0)","v":0},null,{"$f":"I_Financiering!M14","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M161,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M161,I_Verdeelsleutel!$E$11:$E$18,0))*$K161,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$43","v":0},{"$f":"IF($J167=\"Ja\",IFERROR(K164*K165,0),0)","v":0},null,{"$f":"I_Financiering!M18","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M167,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M167,I_Verdeelsleutel!$E$11:$E$18,0))*$K167,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$43","v":0},{"$f":"IF($J173=\"Ja\",IFERROR(K170*K171,0),0)","v":0},null,{"$f":"I_Financiering!M22","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M173,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M173,I_Verdeelsleutel!$E$11:$E$18,0))*$K173,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$43","v":0},{"$f":"IF($J179=\"Ja\",IFERROR(K176*K177,0),0)","v":0},null,{"$f":"I_Financiering!M26","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M179,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M179,I_Verdeelsleutel!$E$11:$E$18,0))*$K179,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$43","v":0},{"$f":"IF($J185=\"Ja\",IFERROR(K182*K183,0),0)","v":0},null,{"$f":"I_Financiering!M30","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M185,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M185,I_Verdeelsleutel!$E$11:$E$18,0))*$K185,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$43","v":0},{"$f":"IF($J191=\"Ja\",IFERROR(K188*K189,0),0)","v":0},null,{"$f":"I_Financiering!M34","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M191,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M191,I_Verdeelsleutel!$E$11:$E$18,0))*$K191,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$43","v":0},{"$f":"IF($J197=\"Ja\",IFERROR(K194*K195,0),0)","v":0},null,{"$f":"I_Financiering!M38","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M197,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M197,I_Verdeelsleutel!$E$11:$E$18,0))*$K197,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$43","v":0},{"$f":"IF($J203=\"Ja\",IFERROR(K200*K201,0),0)","v":0},null,{"$f":"I_Financiering!M42","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M203,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M203,I_Verdeelsleutel!$E$11:$E$18,0))*$K203,0)","v":0}]
[]
[null,null,null,"3.3",null,"Nieuwe rentelasten (als gevolg van nieuwe financiering) - eenvoudige invoer",null,null,null,{"$f":"I_Financiering!G9","v":0}]
[]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / jaar",{"$f":"I_Kosten!$G$43","v":0},{"$f":"IF(AND($J205=\"Ja\",$J207=\"Ja\"),I_Financiering!K10,0)","v":0},null,{"$f":"IF(J205=\"Ja\",I_Financiering!M10,\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M207,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M207,I_Verdeelsleutel!$E$11:$E$18,0))*$K207,0)","v":0}]
[]
[null,null,null,"3.4",null,"Totale rentelasten"]
[]
[null,null,null,null,null,{"$f":"F153","v":"Bestaande rentelasten"},null,null,"EUR / jaar",null,{"$f":"K153","v":0},null,null,null,null,null,{"$f":"Q153","v":0}]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / jaar",null,{"$f":"IF($J$155=\"Ja\",SUM(K161,K167,K173,K179,K185,K191,K197,K203),K207)","v":0},null,null,null,null,null,{"$f":"IF($J$155=\"Ja\",SUM(Q161,Q167,Q173,Q179,Q185,Q191,Q197,Q203),Q207)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K211:K212)","v":0},null,null,null,null,null,{"$f":"SUM(Q211:Q212)","v":0}]
[]
[null,null,"4.",{"$f":"I_Kosten!D45","v":"Directe overige kosten"}]
[]
[null,null,null,"4.1",null,"Huisvestingskosten - eenvoudige invoer",null,null,null,{"$f":"IF(J222=\"Ja\",\"Nee\",IF(J222=0,0,\"Ja\"))","v":0}]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E59","v":"Huisvestingskosten"},null,null,"EUR / jaar",null,{"$f":"IF(I_Kosten!$G$57=\"Nee\",I_Kosten!K59,SUM(I_Kosten!K61:K71))","v":0},null,{"$f":"I_Kosten!M59","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M220,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M220,I_Verdeelsleutel!$E$11:$E$18,0))*$K220,0)","v":0}]
[]
[null,null,null,"4.2",null,"Huisvestingskosten - detail invoer",null,null,null,{"$f":"I_Kosten!$G$57","v":0}]
[]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F61=\"\",\"\",I_Kosten!F61)","v":"Huisvestingskosten - Huur"},null,null,"EUR / jaar",null,{"$f":"IF($J$222=\"Ja\",I_Kosten!K61,0)","v":0},null,{"$f":"I_Kosten!M61","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M224,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M224,I_Verdeelsleutel!$E$11:$E$18,0))*$K224,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F63=\"\",\"\",I_Kosten!F63)","v":"Huisvestingskosten - Onderhoud"},null,null,"EUR / jaar",null,{"$f":"IF($J$222=\"Ja\",I_Kosten!K63,0)","v":0},null,{"$f":"I_Kosten!M63","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M225,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M225,I_Verdeelsleutel!$E$11:$E$18,0))*$K225,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F65=\"\",\"\",I_Kosten!F65)","v":"Huisvestingskosten - Verzekeringen"},null,null,"EUR / jaar",null,{"$f":"IF($J$222=\"Ja\",I_Kosten!K65,0)","v":0},null,{"$f":"I_Kosten!M65","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M226,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M226,I_Verdeelsleutel!$E$11:$E$18,0))*$K226,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F67=\"\",\"\",I_Kosten!F67)","v":""},null,null,"EUR / jaar",null,{"$f":"IF($J$222=\"Ja\",I_Kosten!K67,0)","v":0},null,{"$f":"I_Kosten!M67","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M227,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M227,I_Verdeelsleutel!$E$11:$E$18,0))*$K227,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F69=\"\",\"\",I_Kosten!F69)","v":""},null,null,"EUR / jaar",null,{"$f":"IF($J$222=\"Ja\",I_Kosten!K69,0)","v":0},null,{"$f":"I_Kosten!M69","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M228,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M228,I_Verdeelsleutel!$E$11:$E$18,0))*$K228,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F71=\"\",\"\",I_Kosten!F71)","v":""},null,null,"EUR / jaar",null,{"$f":"IF($J$222=\"Ja\",I_Kosten!K71,0)","v":0},null,{"$f":"I_Kosten!M71","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M229,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M229,I_Verdeelsleutel!$E$11:$E$18,0))*$K229,0)","v":0}]
[]
[null,null,null,"4.3",null,"Huisvestingskosten - totaal"]
[]
[null,null,null,null,null,{"$f":"F220","v":"Huisvestingskosten"},null,null,"EUR / jaar",null,{"$f":"IF($J$222=\"Ja\",SUM(K224:K229),K220)","v":0},null,null,null,null,null,{"$f":"IF($J$222=\"Ja\",SUM(Q224:Q229),Q220)","v":0}]
[]
[null,null,null,"4.4",null,"Directe overige kosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E47","v":"Leasekosten werkplaatsapparatuur"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K47","v":0},null,{"$f":"I_Kosten!M47","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M237,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M237,I_Verdeelsleutel!$E$11:$E$18,0))*$K237,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E49","v":"Kosten gereedschappen klein"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K49","v":0},null,{"$f":"I_Kosten!M49","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M238,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M238,I_Verdeelsleutel!$E$11:$E$18,0))*$K238,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E51","v":"Garantiekosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K51","v":0},null,{"$f":"I_Kosten!M51","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M239,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M239,I_Verdeelsleutel!$E$11:$E$18,0))*$K239,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E53","v":"Franchisekosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K53","v":0},null,{"$f":"I_Kosten!M53","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M240,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M240,I_Verdeelsleutel!$E$11:$E$18,0))*$K240,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E55","v":"Transportkosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K55","v":0},null,{"$f":"I_Kosten!M55","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M241,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M241,I_Verdeelsleutel!$E$11:$E$18,0))*$K241,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F73=\"\",\"\",I_Kosten!F73)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K73","v":0},null,{"$f":"I_Kosten!M73","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M242,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M242,I_Verdeelsleutel!$E$11:$E$18,0))*$K242,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F75=\"\",\"\",I_Kosten!F75)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K75","v":0},null,{"$f":"I_Kosten!M75","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M243,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M243,I_Verdeelsleutel!$E$11:$E$18,0))*$K243,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F77=\"\",\"\",I_Kosten!F77)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K77","v":0},null,{"$f":"I_Kosten!M77","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M244,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M244,I_Verdeelsleutel!$E$11:$E$18,0))*$K244,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F79=\"\",\"\",I_Kosten!F79)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K79","v":0},null,{"$f":"I_Kosten!M79","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M245,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M245,I_Verdeelsleutel!$E$11:$E$18,0))*$K245,0)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K237:K245)","v":0},null,null,null,null,null,{"$f":"SUM(Q237:Q245)","v":0}]
[]
[null,null,"5.",{"$f":"I_Kosten!D81","v":"Overige indirecte kosten"}]
[]
[null,null,null,"5.1",null,"Indirecte overige kosten"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E83","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K83","v":0},null,{"$f":"I_Kosten!M83","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M253,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M253,I_Verdeelsleutel!$E$11:$E$18,0))*$K253,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E85","v":"IT kosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K85","v":0},null,{"$f":"I_Kosten!M85","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M254,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M254,I_Verdeelsleutel!$E$11:$E$18,0))*$K254,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E87","v":"Energiekosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K87","v":0},null,{"$f":"I_Kosten!M87","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M255,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M255,I_Verdeelsleutel!$E$11:$E$18,0))*$K255,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E89","v":"Marketingkosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K89","v":0},null,{"$f":"I_Kosten!M89","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M256,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M256,I_Verdeelsleutel!$E$11:$E$18,0))*$K256,0)","v":0}]
[null,null,null,null,null,{"$f":"I_Kosten!E91","v":"Overige indirecte kosten"},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K91","v":0},null,{"$f":"I_Kosten!M91","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M257,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M257,I_Verdeelsleutel!$E$11:$E$18,0))*$K257,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F93=\"\",\"\",I_Kosten!F93)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K93","v":0},null,{"$f":"I_Kosten!M93","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M258,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M258,I_Verdeelsleutel!$E$11:$E$18,0))*$K258,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F95=\"\",\"\",I_Kosten!F95)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K95","v":0},null,{"$f":"I_Kosten!M95","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M259,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M259,I_Verdeelsleutel!$E$11:$E$18,0))*$K259,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F97=\"\",\"\",I_Kosten!F97)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K97","v":0},null,{"$f":"I_Kosten!M97","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M260,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M260,I_Verdeelsleutel!$E$11:$E$18,0))*$K260,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F99=\"\",\"\",I_Kosten!F99)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K99","v":0},null,{"$f":"I_Kosten!M99","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M261,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M261,I_Verdeelsleutel!$E$11:$E$18,0))*$K261,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F101=\"\",\"\",I_Kosten!F101)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K101","v":0},null,{"$f":"I_Kosten!M101","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M262,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M262,I_Verdeelsleutel!$E$11:$E$18,0))*$K262,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F103=\"\",\"\",I_Kosten!F103)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K103","v":0},null,{"$f":"I_Kosten!M103","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M263,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M263,I_Verdeelsleutel!$E$11:$E$18,0))*$K263,0)","v":0}]
[null,null,null,null,null,{"$f":"IF(I_Kosten!F105=\"\",\"\",I_Kosten!F105)","v":""},null,null,"EUR / jaar",null,{"$f":"I_Kosten!K105","v":0},null,{"$f":"I_Kosten!M105","v":0},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M264,I_Verdeelsleutel!$E$11:$E$18,0)),\"\")","v":""},null,{"$f":"IFERROR(INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH($M264,I_Verdeelsleutel!$E$11:$E$18,0))*$K264,0)","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K253:K264)","v":0},null,null,null,null,null,{"$f":"SUM(Q253:Q264)","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(K41:K42)","v":0},null,null,null,null,null,{"$f":"SUM(Q41:Q42)","v":0}]
[null,null,null,null,null,"Indirecte personeelskosten",null,null,"EUR / jaar",null,{"$f":"SUM(K43:K44)","v":0},null,null,null,null,null,{"$f":"SUM(Q43:Q44)","v":0}]
[null,null,null,null,null,"Directe afschrijvingslasten",null,null,"EUR / jaar",null,{"$f":"K142+K144","v":0},null,null,null,null,null,{"$f":"Q142+Q144","v":0}]
[null,null,null,null,null,"Indirecte afschrijvingslasten",null,null,"EUR / jaar",null,{"$f":"SUM(K143,K145)","v":0},null,null,null,null,null,{"$f":"SUM(Q143,Q145)","v":0}]
[null,null,null,null,null,"Rentelasten",null,null,"EUR / jaar",null,{"$f":"K214","v":0},null,null,null,null,null,{"$f":"Q214","v":0}]
[null,null,null,null,null,"Directe overige kosten",null,null,"EUR / jaar",null,{"$f":"SUM(K233,K247)","v":0},null,null,null,null,null,{"$f":"SUM(Q233,Q247)","v":0}]
[null,null,null,null,null,"Indirecte overige kosten",null,null,"EUR / jaar",null,{"$f":"K266","v":0},null,null,null,null,null,{"$f":"Q266","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K272:K278)","v":0},null,null,null,null,null,{"$f":"SUM(Q272:Q278)","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!E18","v":"Extern gefactureerde uren"},null,null,"Uren",null,{"$f":"I_Generiek!F18","v":0}]
[]
[null,null,"8.","Kostprijs"]
[]
[null,null,null,"8.1",null,"Hoofd kostenelementen"]
[]
[null,null,null,null,null,{"$f":"F272","v":"Directe personeelskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K272/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q272/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F273","v":"Indirecte personeelskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K273/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q273/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F274","v":"Directe afschrijvingslasten"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F275","v":"Indirecte afschrijvingslasten"},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F276","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(K292:K298)","v":0},null,null,null,null,null,{"$f":"SUM(Q292:Q298)","v":0}]
[]
[null,null,null,"8.2",null,"Alle kostenelementen"]
[]
[null,null,null,null,null,{"$f":"F11","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / uur",null,{"$f":"IFERROR(K21/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q21/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F25","v":"Opleidingskosten direct personeel"},null,null,"EUR / uur",null,{"$f":"IFERROR(K25/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q25/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F29","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / uur",null,{"$f":"IFERROR(K33/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q33/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F37","v":"Opleidingskosten indirect personeel"},null,null,"EUR / uur",null,{"$f":"IFERROR(K37/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q37/$K$286,0)","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - direct",null,null,"EUR / uur",null,{"$f":"IFERROR(K52/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q52/$K$286,0)","v":0}]
[null,null,null,null,null,"Bestaande afschrijvingslasten - indirect",null,null,"EUR / uur",null,{"$f":"IFERROR(K53/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q53/$K$286,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - direct",null,null,"EUR / uur",null,{"$f":"IFERROR(K144/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q144/$K$286,0)","v":0}]
[null,null,null,null,null,"Nieuwe afschrijvingslasten - indirect",null,null,"EUR / uur",null,{"$f":"IFERROR(K145/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q145/$K$286,0)","v":0}]
[null,null,null,null,null,"Bestaande rentelasten",null,null,"EUR / uur",null,{"$f":"IFERROR(K211/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q211/$K$286,0)","v":0}]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / uur",null,{"$f":"IFERROR(K212/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q212/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F237","v":"Leasekosten werkplaatsapparatuur"},null,null,"EUR / uur",null,{"$f":"IFERROR(K237/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q237/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F238","v":"Kosten gereedschappen klein"},null,null,"EUR / uur",null,{"$f":"IFERROR(K238/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q238/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F239","v":"Garantiekosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K239/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q239/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F240","v":"Franchisekosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K240/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q240/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F241","v":"Transportkosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K241/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q241/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F220","v":"Huisvestingskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K233/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q233/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F242","v":""},null,null,"EUR / uur",null,{"$f":"IFERROR(K242/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q242/$K$286,0)","v":0}]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"IFERROR(K243/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q243/$K$286,0)","v":0}]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"IFERROR(K244/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q244/$K$286,0)","v":0}]
[null,null,null,null,null,"",null,null,"EUR / uur",null,{"$f":"IFERROR(K245/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q245/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F253","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / uur",null,{"$f":"IFERROR(K253/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q253/$K$286,0)","v":0}]
[null,null,null,null,null,{"$f":"F254","v":"IT kosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K254/$K$286,0)","v":0},null,null,null,null,null,{"$f":"IFERROR(Q254/$K$286,0)","v":0}]
[null,null,null,null,null,"Energiekosten",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"Marketingkosten",null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,"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,{"$f":"F263","v":""},null,null,"EUR / uur",null,0,null,null,null,null,null,0]
[null,null,null,null,null,{"$f":"F264","v":""},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(K304,K305:K335)","v":0},null,null,null,null,null,{"$f":"SUM(Q304,Q305:Q335)","v":0}]

{"sheet":"C_Scenario","index":10,"n_rows":229,"n_cols":17,"rows_kept":229,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \n(Gemotoriseerde) Tweewielers | C_Scenario"}]
[]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"C_Scenario"}]
[null,null,"Calculatie_Scenario"]
[null,null,null,null,null,null,null,null,null,null,"Base werkplaats",null,"Gekozen draaiknop (%)",null,"Scenario werkplaats",null,"Scenario actief?"]
[]
[null,null,"1.","Personeelskosten"]
[]
[null,null,null,"1.1",null,"Direct personeel - personeelskosten (excl. opleidingskosten)"]
[]
[null,null,null,null,"1.1.1","Draaiknoppen van toepassing - Directe personeelskosten (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"O_Dashboard!M11","v":"CAO-ontwikkeling"},null,null,{"$f":"IF(O_Dashboard!$O$15=TRUE,O_Dashboard!$P$13,0)","v":0}]
[null,null,null,null,null,{"$f":"O_Dashboard!$M$20","v":"Krapte arbeidsmarkt"},null,null,{"$f":"IF(O_Dashboard!$O$22=TRUE,O_Dashboard!$P$22,0)","v":0}]
[null,null,null,null,null,{"$f":"O_Dashboard!$M$26","v":"Parttime werken"},null,null,{"$f":"IF(O_Dashboard!O28=TRUE,O_Dashboard!$P$28,0)","v":0}]
[]
[null,null,null,null,"1.1.2","Totale impact van de gekozen draaiknoppen",null,null,{"$f":"SUM(I13:I15)","v":0}]
[]
[null,null,null,null,"1.1.3","Totale personeelskosten direct personeel (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"I_Kosten!E15","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q21","v":0},null,{"$f":"I17","v":0},null,{"$f":"$K21*(1+$M21)","v":0},null,{"$f":"IF(AND(I13=0,I14=0,I15=0),CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,"1.2",null,{"$f":"C_Base!F23","v":"Direct personeel - opleidingskosten"}]
[]
[null,null,null,null,null,{"$f":"C_Base!F25","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q25","v":0},null,null,null,{"$f":"K25","v":0}]
[]
[null,null,null,"1.3",null,"Indirect personeel - personeelskosten (excl. opleidingskosten)"]
[]
[null,null,null,null,"1.3.1","Draaiknoppen van toepassing - Indirecte personeelskosten (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"O_Dashboard!M11","v":"CAO-ontwikkeling"},null,null,{"$f":"IF(O_Dashboard!$O$16=TRUE,O_Dashboard!$P$13,0)","v":0}]
[null,null,null,null,null,{"$f":"O_Dashboard!M26","v":"Parttime werken"},null,null,{"$f":"IF(O_Dashboard!O29=TRUE,O_Dashboard!$P$29,0)","v":0}]
[]
[null,null,null,null,"1.3.2","Totale impact van de gekozen draaiknoppen",null,null,{"$f":"SUM(I31:I32)","v":0}]
[]
[null,null,null,null,"1.3.3","Totale personeelskosten indirect personeel (excl. opleidingskosten)"]
[]
[null,null,null,null,null,{"$f":"C_Base!F33","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q33","v":0},null,{"$f":"I34","v":0},null,{"$f":"$K38*(1+$M38)","v":0},null,{"$f":"IF(AND(I31=0,I32=0),CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,"1.4",null,"Indirect personeel - opleidingskosten"]
[]
[null,null,null,null,null,{"$f":"C_Base!F37","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q37","v":0},null,null,null,{"$f":"K42","v":0}]
[]
[null,null,null,"1.5",null,"Totale personeelskosten"]
[]
[null,null,null,null,null,{"$f":"F21","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K21","v":0},null,null,null,{"$f":"O21","v":0}]
[null,null,null,null,null,{"$f":"F25","v":"Opleidingskosten direct personeel"},null,null,"EUR / jaar",null,{"$f":"K25","v":0},null,null,null,{"$f":"O25","v":0}]
[null,null,null,null,null,{"$f":"F38","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / jaar",null,{"$f":"K38","v":0},null,null,null,{"$f":"O38","v":0}]
[null,null,null,null,null,{"$f":"F42","v":"Opleidingskosten indirect personeel"},null,null,"EUR / jaar",null,{"$f":"K42","v":0},null,null,null,{"$f":"O42","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K46:K49)","v":0},null,null,null,{"$f":"SUM(O46:O49)","v":0}]
[]
[]
[null,null,"2.",{"$f":"C_Base!D48","v":"Afschrijvingen"}]
[]
[null,null,null,"2.1",null,"Totale afschrijvingslasten"]
[]
[null,null,null,null,null,{"$f":"C_Base!F142","v":"Bestaande afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q142","v":0},null,{"$f":"O_Dashboard!I41","v":0},null,{"$f":"IF(O_Dashboard!I41<>\"\",K58*(1+O_Dashboard!I41),K58)","v":0},null,{"$f":"IF(O_Dashboard!H41=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F143","v":"Bestaande afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q143","v":0},null,{"$f":"O_Dashboard!I42","v":0},null,{"$f":"IF(O_Dashboard!I42<>\"\",K59*(1+O_Dashboard!I42),K59)","v":0},null,{"$f":"IF(O_Dashboard!H42=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F144","v":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q144","v":0},null,{"$f":"O_Dashboard!I43","v":0},null,{"$f":"IF(O_Dashboard!I43<>\"\",K60*(1+O_Dashboard!I43),K60)","v":0},null,{"$f":"IF(O_Dashboard!H43=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F145","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q145","v":0},null,{"$f":"O_Dashboard!I44","v":0},null,{"$f":"IF(O_Dashboard!I44<>\"\",K61*(1+O_Dashboard!I44),K61)","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(K58:K61)","v":0},null,null,null,{"$f":"SUM(O58:O61)","v":0}]
[]
[null,null,"3.",{"$f":"C_Base!D149","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!K158*C_Base!O161,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L57=\"\",K70,O_Dashboard!L57)","v":0},null,{"$f":"IF(O_Dashboard!L57=\"\",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!L58=\"\",K71,O_Dashboard!L58)","v":0},null,{"$f":"IF(O_Dashboard!L58=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K70*K71,0)","v":0},null,null,null,{"$f":"IFERROR(O70*O71,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!K164*C_Base!O167,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L61=\"\",K76,O_Dashboard!L61)","v":0},null,{"$f":"IF(O_Dashboard!L61=\"\",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!L62=\"\",K77,O_Dashboard!L62)","v":0},null,{"$f":"IF(O_Dashboard!L62=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K76*K77,0)","v":0},null,null,null,{"$f":"IFERROR(O76*O77,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!K170*C_Base!O173,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L65=\"\",K82,O_Dashboard!L65)","v":0},null,{"$f":"IF(O_Dashboard!L65=\"\",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!L66=\"\",K83,O_Dashboard!L66)","v":0},null,{"$f":"IF(O_Dashboard!L66=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K82*K83,0)","v":0},null,null,null,{"$f":"IFERROR(O82*O83,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!K176*C_Base!O179,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L69=\"\",K88,O_Dashboard!L69)","v":0},null,{"$f":"IF(O_Dashboard!L69=\"\",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!L70=\"\",K89,O_Dashboard!L70)","v":0},null,{"$f":"IF(O_Dashboard!L70=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K88*K89,0)","v":0},null,null,null,{"$f":"IFERROR(O88*O89,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!K182*C_Base!O185,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L73=\"\",K94,O_Dashboard!L73)","v":0},null,{"$f":"IF(O_Dashboard!L73=\"\",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!L74=\"\",K95,O_Dashboard!L74)","v":0},null,{"$f":"IF(O_Dashboard!L74=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K94*K95,0)","v":0},null,null,null,{"$f":"IFERROR(O94*O95,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!K188*C_Base!O191,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L77=\"\",K100,O_Dashboard!L77)","v":0},null,{"$f":"IF(O_Dashboard!L77=\"\",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!L78=\"\",K101,O_Dashboard!L78)","v":0},null,{"$f":"IF(O_Dashboard!L78=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K100*K101,0)","v":0},null,null,null,{"$f":"IFERROR(O100*O101,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!K194*C_Base!O197,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L81=\"\",K106,O_Dashboard!L81)","v":0},null,{"$f":"IF(O_Dashboard!L81=\"\",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!L82=\"\",K107,O_Dashboard!L82)","v":0},null,{"$f":"IF(O_Dashboard!L82=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K106*K107,0)","v":0},null,null,null,{"$f":"IFERROR(O106*O107,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!K200*C_Base!O203,0)","v":0},null,{"$f":"\"N.v.t.\"","v":"N.v.t."},null,{"$f":"IF(O_Dashboard!L85=\"\",K112,O_Dashboard!L85)","v":0},null,{"$f":"IF(O_Dashboard!L85=\"\",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!L86=\"\",K113,O_Dashboard!L86)","v":0},null,{"$f":"IF(O_Dashboard!L86=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"IFERROR(K112*K113,0)","v":0},null,null,null,{"$f":"IFERROR(O112*O113,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!Q211","v":0},null,{"$f":"IF(O_Dashboard!N34=1,O_Dashboard!$P$42,IF(O_Dashboard!N34=2,O_Dashboard!$P$45,IF(O_Dashboard!N34=4,0,\"N.v.t.\")))","v":0},null,{"$f":"IF(O_Dashboard!N34=1,K119*(1+O_Dashboard!$P$42),IF(O_Dashboard!N34=2,K119*(1+O_Dashboard!$P$45),IF(O_Dashboard!N34=4,K119,0)))","v":0},null,{"$f":"IF(OR(O_Dashboard!N34=4,O_Dashboard!N34=0),CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,"Nieuwe rentelasten",null,null,"EUR / jaar",null,{"$f":"C_Base!Q212","v":0},null,{"$f":"IF(COUNT(O_Dashboard!$L$57:$M$86)>0,\"N.v.t.\",O_Dashboard!I52)","v":"N.v.t."},null,{"$f":"IF(C_Base!$J$205=\"Ja\",IF(O_Dashboard!I52<>\"\",K120*(1+O_Dashboard!I52),K120),SUM(C_Scenario!O73,C_Scenario!O79,C_Scenario!O85,C_Scenario!O91,C_Scenario!O97,C_Scenario!O103,C_Scenario!O109,C_Scenario!O115))","v":0},null,{"$f":"IF(OR(COUNT(O_Dashboard!$L$57:$M$86)>0,AND(O_Dashboard!$I$52<>\"N.v.t.\",O_Dashboard!$I$52<>0)),CHAR(252),CHAR(251))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K119:K120)","v":0},null,null,null,{"$f":"SUM(O119:O120)","v":0}]
[]
[null,null,"4.",{"$f":"C_Base!D216","v":"Directe overige kosten"}]
[]
[null,null,null,"4.1",null,"Directe overige kosten"]
[]
[null,null,null,null,null,{"$f":"C_Base!F220","v":"Huisvestingskosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q233","v":0},null,{"$f":"O_Dashboard!I13","v":0},null,{"$f":"IF(O_Dashboard!I13<>\"\",K128*(1+O_Dashboard!I13),K128)","v":0},null,{"$f":"IF(O_Dashboard!H13=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F237","v":"Leasekosten werkplaatsapparatuur"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q237","v":0},null,{"$f":"O_Dashboard!I14","v":0},null,{"$f":"IF(O_Dashboard!I14<>\"\",K129*(1+O_Dashboard!I14),K129)","v":0},null,{"$f":"IF(O_Dashboard!H14=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F238","v":"Kosten gereedschappen klein"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q238","v":0},null,{"$f":"O_Dashboard!I15","v":0},null,{"$f":"IF(O_Dashboard!I15<>\"\",K130*(1+O_Dashboard!I15),K130)","v":0},null,{"$f":"IF(O_Dashboard!H15=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F239","v":"Garantiekosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q239","v":0},null,{"$f":"O_Dashboard!I16","v":0},null,{"$f":"IF(O_Dashboard!I16<>\"\",K131*(1+O_Dashboard!I16),K131)","v":0},null,{"$f":"IF(O_Dashboard!H16=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F240","v":"Franchisekosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q240","v":0},null,{"$f":"O_Dashboard!I17","v":0},null,{"$f":"IF(O_Dashboard!I17<>\"\",K132*(1+O_Dashboard!I17),K132)","v":0},null,{"$f":"IF(O_Dashboard!H17=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F241","v":"Transportkosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q241","v":0},null,{"$f":"O_Dashboard!I18","v":0},null,{"$f":"IF(O_Dashboard!I18<>\"\",K133*(1+O_Dashboard!I18),K133)","v":0},null,{"$f":"IF(O_Dashboard!H18=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F242","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q242","v":0},null,{"$f":"O_Dashboard!I19","v":""},null,{"$f":"IF(O_Dashboard!I19<>\"\",K134*(1+O_Dashboard!I19),K134)","v":0},null,{"$f":"IF(O_Dashboard!H19=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F243","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q243","v":0},null,{"$f":"O_Dashboard!I20","v":""},null,{"$f":"IF(O_Dashboard!I20<>\"\",K135*(1+O_Dashboard!I20),K135)","v":0},null,{"$f":"IF(O_Dashboard!H20=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F244","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q244","v":0},null,{"$f":"O_Dashboard!I21","v":""},null,{"$f":"IF(O_Dashboard!I21<>\"\",K136*(1+O_Dashboard!I21),K136)","v":0},null,{"$f":"IF(O_Dashboard!H21=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F245","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q245","v":0},null,{"$f":"O_Dashboard!I22","v":""},null,{"$f":"IF(O_Dashboard!I22<>\"\",K137*(1+O_Dashboard!I22),K137)","v":0},null,{"$f":"IF(O_Dashboard!H22=1000,CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K128:K137)","v":0},null,null,null,{"$f":"SUM(O128:O137)","v":0}]
[]
[null,null,"5.",{"$f":"C_Base!D249","v":"Overige indirecte kosten"}]
[]
[null,null,null,"5.1",null,"Indirecte overige kosten"]
[]
[null,null,null,null,null,{"$f":"C_Base!F253","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q253","v":0},null,{"$f":"O_Dashboard!I26","v":0},null,{"$f":"IF(O_Dashboard!I26<>\"\",K145*(1+O_Dashboard!I26),K145)","v":0},null,{"$f":"IF(O_Dashboard!H26=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F254","v":"IT kosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q254","v":0},null,{"$f":"O_Dashboard!I27","v":0},null,{"$f":"IF(O_Dashboard!I27<>\"\",K146*(1+O_Dashboard!I27),K146)","v":0},null,{"$f":"IF(O_Dashboard!H27=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F255","v":"Energiekosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q255","v":0},null,{"$f":"O_Dashboard!I28","v":0},null,{"$f":"IF(O_Dashboard!I28<>\"\",K147*(1+O_Dashboard!I28),K147)","v":0},null,{"$f":"IF(O_Dashboard!H28=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F256","v":"Marketingkosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q256","v":0},null,{"$f":"O_Dashboard!I29","v":0},null,{"$f":"IF(O_Dashboard!I29<>\"\",K148*(1+O_Dashboard!I29),K148)","v":0},null,{"$f":"IF(O_Dashboard!H29=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F257","v":"Overige indirecte kosten"},null,null,"EUR / jaar",null,{"$f":"C_Base!Q257","v":0},null,{"$f":"O_Dashboard!I30","v":0},null,{"$f":"IF(O_Dashboard!I30<>\"\",K149*(1+O_Dashboard!I30),K149)","v":0},null,{"$f":"IF(O_Dashboard!H30=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F258","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q258","v":0},null,{"$f":"O_Dashboard!I31","v":""},null,{"$f":"IF(O_Dashboard!I31<>\"\",K150*(1+O_Dashboard!I31),K150)","v":0},null,{"$f":"IF(O_Dashboard!H31=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F259","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q259","v":0},null,{"$f":"O_Dashboard!I32","v":""},null,{"$f":"IF(O_Dashboard!I32<>\"\",K151*(1+O_Dashboard!I32),K151)","v":0},null,{"$f":"IF(O_Dashboard!H32=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F260","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q260","v":0},null,{"$f":"O_Dashboard!I33","v":""},null,{"$f":"IF(O_Dashboard!I33<>\"\",K152*(1+O_Dashboard!I33),K152)","v":0},null,{"$f":"IF(O_Dashboard!H33=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F261","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q261","v":0},null,{"$f":"O_Dashboard!I34","v":""},null,{"$f":"IF(O_Dashboard!I34<>\"\",K153*(1+O_Dashboard!I34),K153)","v":0},null,{"$f":"IF(O_Dashboard!H34=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F262","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q262","v":0},null,{"$f":"O_Dashboard!I35","v":""},null,{"$f":"IF(O_Dashboard!I35<>\"\",K154*(1+O_Dashboard!I35),K154)","v":0},null,{"$f":"IF(O_Dashboard!H35=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F263","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q263","v":0},null,{"$f":"O_Dashboard!I36","v":""},null,{"$f":"IF(O_Dashboard!I36<>\"\",K155*(1+O_Dashboard!I36),K155)","v":0},null,{"$f":"IF(O_Dashboard!H36=1000,CHAR(251),CHAR(252))","v":"û"}]
[null,null,null,null,null,{"$f":"C_Base!F264","v":""},null,null,"EUR / jaar",null,{"$f":"C_Base!Q264","v":0},null,{"$f":"O_Dashboard!I37","v":""},null,{"$f":"IF(O_Dashboard!I37<>\"\",K156*(1+O_Dashboard!I37),K156)","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(K145:K156)","v":0},null,null,null,{"$f":"SUM(O145:O156)","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(K21,K25)","v":0},null,null,null,{"$f":"SUM(O21,O25)","v":0}]
[null,null,null,null,null,"Indirecte personeelskosten",null,null,"EUR / jaar",null,{"$f":"SUM(K38,K42)","v":0},null,null,null,{"$f":"SUM(O38,O42)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F274","v":"Directe afschrijvingslasten"},null,null,"EUR / jaar",null,{"$f":"SUM(K58,K60)","v":0},null,null,null,{"$f":"SUM(O58,O60)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F275","v":"Indirecte afschrijvingslasten"},null,null,"EUR / jaar",null,{"$f":"SUM(K59,K61)","v":0},null,null,null,{"$f":"SUM(O59,O61)","v":0}]
[null,null,null,null,null,"Rentelasten",null,null,"EUR / jaar",null,{"$f":"K122","v":0},null,null,null,{"$f":"O122","v":0}]
[null,null,null,null,null,"Directe overige kosten",null,null,"EUR / jaar",null,{"$f":"K139","v":0},null,null,null,{"$f":"O139","v":0}]
[null,null,null,null,null,"Indirecte overige kosten",null,null,"EUR / jaar",null,{"$f":"K158","v":0},null,null,null,{"$f":"O158","v":0}]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / jaar",null,{"$f":"SUM(K164:K170)","v":0},null,null,null,{"$f":"SUM(O164:O170)","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":"Extern gefactureerde uren "},null,null,"Uren",null,{"$f":"C_Base!K286","v":0},null,null,null,{"$f":"IF(P178=TRUE,IF(O_Dashboard!L93=\"\",O_Dashboard!G93,O_Dashboard!L93),K178)","v":0},{"$f":"IF(COUNTA(O_Dashboard!$L$93:$M$93)>0,TRUE,FALSE)","v":false},{"$f":"IF(O_Dashboard!L93=\"\",CHAR(251),CHAR(252))","v":"û"}]
[]
[null,null,"8.","Kostprijs"]
[]
[null,null,null,"8.1",null,"Hoofd kostenelementen"]
[]
[null,null,null,null,null,{"$f":"F164","v":"Directe personeelskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K164/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O164/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"F165","v":"Indirecte personeelskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K165/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O165/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"F166","v":"Directe afschrijvingslasten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"F167","v":"Indirecte afschrijvingslasten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"F168","v":"Rentelasten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,"Directe overige kosten",null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,"Indirecte overige kosten",null,null,"EUR / uur",null,0,null,null,null,0]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / uur",null,{"$f":"SUM(K184:K190)","v":0},null,null,null,{"$f":"SUM(O184:O190)","v":0}]
[]
[null,null,null,"8.2",null,"Alle kostenelementen"]
[]
[null,null,null,null,null,{"$f":"C_Base!F304","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"EUR / uur",null,{"$f":"IFERROR(K46/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O46/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F305","v":"Opleidingskosten direct personeel"},null,null,"EUR / uur",null,{"$f":"IFERROR(K47/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O47/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F306","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"EUR / uur",null,{"$f":"IFERROR(K48/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O48/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F307","v":"Opleidingskosten indirect personeel"},null,null,"EUR / uur",null,0,null,null,null,{"$f":"IFERROR(O49/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F308","v":"Bestaande afschrijvingslasten - direct"},null,null,"EUR / uur",null,{"$f":"IFERROR(K58/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O58/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F309","v":"Bestaande afschrijvingslasten - indirect"},null,null,"EUR / uur",null,{"$f":"IFERROR(K59/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O59/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F310","v":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / uur",null,{"$f":"IFERROR(K60/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O60/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F311","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / uur",null,{"$f":"IFERROR(K61/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O61/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F312","v":"Bestaande rentelasten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K119/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O119/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F313","v":"Nieuwe rentelasten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K120/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O120/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F314","v":"Leasekosten werkplaatsapparatuur"},null,null,"EUR / uur",null,{"$f":"IFERROR(K129/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O129/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F315","v":"Kosten gereedschappen klein"},null,null,"EUR / uur",null,{"$f":"IFERROR(K130/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O130/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F316","v":"Garantiekosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K131/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O131/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F317","v":"Franchisekosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K132/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O132/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F318","v":"Transportkosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K133/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O133/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F319","v":"Huisvestingskosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K128/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O128/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F320","v":""},null,null,"EUR / uur",null,{"$f":"IFERROR(K134/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O134/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F321","v":""},null,null,"EUR / uur",null,{"$f":"IFERROR(K135/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O135/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F322","v":""},null,null,"EUR / uur",null,{"$f":"IFERROR(K136/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O136/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F323","v":""},null,null,"EUR / uur",null,{"$f":"IFERROR(K137/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O137/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F324","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / uur",null,{"$f":"IFERROR(K145/$K$178,0)","v":0},null,null,null,{"$f":"IFERROR(O145/$O$178,0)","v":0}]
[null,null,null,null,null,{"$f":"C_Base!F325","v":"IT kosten"},null,null,"EUR / uur",null,{"$f":"IFERROR(K146/$K$178,0)","v":0},null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F326","v":"Energiekosten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F327","v":"Marketingkosten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F328","v":"Overige indirecte kosten"},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F329","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F330","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F331","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F332","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F333","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F334","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[null,null,null,null,null,{"$f":"C_Base!F335","v":""},null,null,"EUR / uur",null,0,null,null,null,0]
[]
[null,null,null,null,null,"Totaal",null,null,"EUR / uur",null,{"$f":"SUM(K196:K227)","v":0},null,null,null,{"$f":"SUM(O196:O227)","v":0}]

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

{"sheet":"O_Dashboard","index":12,"n_rows":117,"n_cols":39,"rows_kept":117,"cut":false,"hidden":false,"merged":[[116,23,116,24],[114,23,114,24],[115,23,115,24],[100,23,100,24],[101,23,101,24],[104,23,104,24],[105,23,105,24],[106,23,106,24],[112,23,112,24],[107,23,107,24],[108,23,108,24],[109,23,109,24],[110,23,110,24],[111,23,111,24],[95,23,95,24],[102,23,102,24],[103,23,103,24],[92,23,92,24],[93,23,93,24],[94,23,94,24],[96,23,96,24],[99,23,99,24],[87,23,87,24],[88,23,88,24],[89,23,89,24],[90,23,90,24],[91,23,91,24],[80,23,80,24],[81,23,81,24],[82,23,82,24],[85,23,85,24],[86,23,86,24],[78,23,78,24],[65,11,65,12],[68,11,68,12],[69,11,69,12],[72,11,72,12],[73,11,73,12],[56,11,56,12],[92,11,92,12],[93,11,93,12],[85,11,85,12],[76,11,76,12],[77,11,77,12],[80,11,80,12],[81,11,81,12],[84,11,84,12],[57,11,57,12],[60,11,60,12],[61,11,61,12],[64,11,64,12]]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \n(Gemotoriseerde) Tweewielers | O_Dashboard"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gemiddelde kostprijzen per uur - SCENARIO"]
[{"$f":"MID(CELL(\"filename\",B3),FIND(\"]\",CELL(\"filename\",B3))+1,99)","v":"O_Dashboard"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gemiddelde kostprijs o.b.v. extern gefactureerde uren",null,null,null,null,null,null,null,{"$f":"O_Graph!H43","v":0}]
[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,null,null,null,null,null,null,null,"Gemiddelde kostprijs o.b.v. intern gefactureerde uren",null,null,null,null,null,null,null,{"$f":"IFERROR(IF(L94=\"\",C_Base!Q280/O_Dashboard!G94,C_Base!Q280/O_Dashboard!L94),0)","v":0}]
[]
[]
[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,"CAO-ontwikkeling"]
[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!F184","v":"Directe personeelskosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K184","v":0},{"$f":"C_Scenario!O184","v":0},{"$f":"AL12-AK12","v":0}]
[null,null,null,{"$f":"C_Base!F220","v":"Huisvestingskosten"},null,null,null,1000,{"$f":"IF(D13=\"\",\"\",(H13-1000)/1000)","v":0},null,null,null,null,"Loonstijging conform CAO",null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F185","v":"Indirecte personeelskosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K185","v":0},{"$f":"C_Scenario!O185","v":0},{"$f":"AL13-AK13","v":0}]
[null,null,null,{"$f":"C_Base!F237","v":"Leasekosten werkplaatsapparatuur"},null,null,null,1000,{"$f":"IF(D14=\"\",\"\",(H14-1000)/1000)","v":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!F186","v":"Directe afschrijvingslasten"},null,null,"EUR / uur",{"$f":"C_Scenario!K186","v":0},{"$f":"C_Scenario!O186","v":0},0]
[null,null,null,{"$f":"C_Base!F238","v":"Kosten gereedschappen klein"},null,null,null,1000,0,null,null,null,null,{"$f":"C_Base!F21","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F187","v":"Indirecte afschrijvingslasten"},null,null,"EUR / uur",{"$f":"C_Scenario!K187","v":0},{"$f":"C_Scenario!O187","v":0},0]
[null,null,null,{"$f":"C_Base!F239","v":"Garantiekosten"},null,null,null,1000,0,null,null,null,null,{"$f":"C_Base!F33","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F188","v":"Rentelasten"},null,null,"EUR / uur",{"$f":"C_Scenario!K188","v":0},{"$f":"C_Scenario!O188","v":0},0]
[null,null,null,{"$f":"C_Base!F240","v":"Franchisekosten"},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!F189","v":"Directe overige kosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K189","v":0},{"$f":"C_Scenario!O189","v":0},0]
[null,null,null,{"$f":"C_Base!F241","v":"Transportkosten"},null,null,null,1000,0,null,null,null,"1.3","Krapte arbeidsmarkt",null,"% / jaar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C_Scenario!F190","v":"Indirecte overige kosten"},null,null,"EUR / uur",{"$f":"C_Scenario!K190","v":0},{"$f":"C_Scenario!O190","v":0},0]
[null,null,null,{"$f":"C_Base!F242","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,"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!F243","v":""},null,null,null,1000,"",null,null,null,"Krapte arbeidsmarkt"]
[null,null,null,{"$f":"C_Base!F244","v":""},null,null,null,1000,""]
[null,null,null,{"$f":"C_Base!F245","v":""},null,null,null,1000,{"$f":"IF(D22=\"\",\"\",(H22-1000)/1000)","v":""},null,null,null,null,{"$f":"C_Base!F304","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},false,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.","Marge en resultaat - INPUT"]
[]
[null,null,null,"Indirecte overige kosten",null,null,null,null,null,null,null,null,"1.4","Parttime werken",null,"% / jaar",null,null,"3.","Gemiddelde kostprijs werkplaats - SCENARIO"]
[]
[null,null,null,{"$f":"C_Base!F253","v":"Management fee / Ondernemersbeloning"},null,null,null,1000,{"$f":"IF(D26=\"\",\"\",(H26-1000)/1000)","v":0},null,null,null,"Parttime werken"]
[null,null,null,{"$f":"C_Base!F254","v":"IT kosten"},null,null,null,1000,{"$f":"IF(D27=\"\",\"\",(H27-1000)/1000)","v":0}]
[null,null,null,{"$f":"C_Base!F255","v":"Energiekosten"},null,null,null,1000,0,null,null,null,null,{"$f":"C_Base!F21","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},false,0]
[null,null,null,{"$f":"C_Base!F256","v":"Marketingkosten"},null,null,null,1000,0,null,null,null,null,{"$f":"C_Base!F33","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},false,0]
[null,null,null,{"$f":"C_Base!F257","v":"Overige indirecte kosten"},null,null,null,1000,0]
[null,null,null,{"$f":"C_Base!F258","v":""},null,null,null,1000,"",null,null,null,"1.5","Wijziging bestaande rentelasten"]
[null,null,null,{"$f":"C_Base!F259","v":""},null,null,null,1000,""]
[null,null,null,{"$f":"C_Base!F260","v":""},null,null,null,1000,""]
[null,null,null,{"$f":"C_Base!F261","v":""},null,null,null,1000,"",null,null,null,null,4]
[null,null,null,{"$f":"C_Base!F262","v":""},null,null,null,1000,""]
[null,null,null,{"$f":"C_Base!F263","v":""},null,null,null,1000,""]
[null,null,null,{"$f":"C_Base!F264","v":""},null,null,null,1000,{"$f":"IF(D37=\"\",\"\",(H37-1000)/1000)","v":""}]
[]
[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!F308","v":"Bestaande afschrijvingslasten - direct"},null,null,null,1000,{"$f":"IF(D41=\"\",\"\",(H41-1000)/1000)","v":0},null,null,null,null,"Stijging bestaande rentelasten"]
[null,null,null,{"$f":"C_Base!F309","v":"Bestaande afschrijvingslasten - indirect"},null,null,null,1000,0,null,null,null,null,0,null,{"$f":"IF($N$34=1,N42/1000,\"N.v.t.\")","v":"N.v.t."}]
[null,null,null,{"$f":"C_Base!F310","v":"Nieuwe afschrijvingslasten - direct"},null,null,null,1000,0,null,null,null,null,null,null,null,null,null,null,"Kostprijs",null,null,"Eenheid","INPUT","SCENARIO"]
[null,null,null,{"$f":"C_Base!F311","v":"Nieuwe afschrijvingslasten - indirect"},null,null,null,1000,0,null,null,null,null,"Daling bestaande rentelasten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF($N$34=2,-N45/1000,\"N.v.t.\")","v":"N.v.t."},null,null,null,"Directe kosten"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E71","v":"Personele lasten direct personeel"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T46,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T46,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E72","v":"Opleidingskosten direct personeel"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T47,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T47,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,"1.6","Wijziging nieuwe rentelasten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E73","v":"Bestaande afschrijvingslasten - direct"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T48,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T48,O_Graph!$P$69:$P$100)","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":"Nieuwe afschrijvingslasten - direct"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T49,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T49,O_Graph!$P$69:$P$100)","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":"Leasekosten werkplaatsapparatuur"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T50,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T50,O_Graph!$P$69:$P$100)","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":"Kosten gereedschappen klein"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T51,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T51,O_Graph!$P$69:$P$100)","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.\",(H52-1000)/1000)","v":"N.v.t."},null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E77","v":"Garantiekosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T52,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T52,O_Graph!$P$69:$P$100)","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":"Franchisekosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T53,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T53,O_Graph!$P$69:$P$100)","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":"Transportkosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T54,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T54,O_Graph!$P$69:$P$100)","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":"Huisvestingskosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T55,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T55,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,{"$f":"C_Scenario!F69","v":"Financiering 1"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,"`",null,null,null,{"$f":"O_Graph!E81","v":"Overige directe kosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T56,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T56,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,{"$f":"C_Scenario!F70","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K70","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,"Totaal directe kosten",null,null,"EUR / uur",{"$f":"SUM(X46:X56)","v":0},{"$f":"SUM(Y46:Y56)","v":0}]
[null,null,null,{"$f":"C_Scenario!F71","v":"Rentepercentage "},null,null,{"$f":"C_Scenario!K71","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,"Indirecte kosten"]
[null,null,null,{"$f":"C_Scenario!F75","v":"Financiering 2"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E82","v":"Personele lasten indirect personeel"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T60,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T60,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,{"$f":"C_Scenario!F76","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K76","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,{"$f":"O_Graph!E83","v":"Opleidingskosten indirect personeel"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T61,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T61,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,{"$f":"C_Scenario!F77","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K77","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,null,{"$f":"O_Graph!E84","v":"Bestaande afschrijvingslasten - indirect"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T62,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T62,O_Graph!$P$69:$P$100)","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":"Nieuwe afschrijvingslasten - indirect"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T63,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T63,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,{"$f":"C_Scenario!F81","v":"Financiering 3"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E86","v":"Bestaande rentelasten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T64,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T64,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,{"$f":"C_Scenario!F82","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K82","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,{"$f":"O_Graph!E87","v":"Nieuwe rentelasten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T65,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T65,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,{"$f":"C_Scenario!F83","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K83","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,null,{"$f":"O_Graph!E88","v":"Management fee / Ondernemersbeloning"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T66,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T66,O_Graph!$P$69:$P$100)","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$69:$K$100,$T67,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T67,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,{"$f":"C_Scenario!F87","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$69:$K$100,$T68,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T68,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,{"$f":"C_Scenario!F88","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K88","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,{"$f":"O_Graph!E91","v":"Marketingkosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T69,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T69,O_Graph!$P$69:$P$100)","v":0}]
[null,null,null,{"$f":"C_Scenario!F89","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K89","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,null,{"$f":"O_Graph!E92","v":"Overige indirecte kosten"},null,null,"EUR / uur",{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T70,O_Graph!$O$69:$O$100)","v":0},{"$f":"SUMIF(O_Graph!$K$69:$K$100,$T70,O_Graph!$P$69:$P$100)","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 / uur",{"$f":"SUM(X60:X70)","v":0},{"$f":"SUM(Y60:Y70)","v":0}]
[null,null,null,{"$f":"C_Scenario!F93","v":"Financiering 5"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F94","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K94","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,"Gemiddelde kostprijs per uur",null,null,"EUR / uur",{"$f":"SUM(X57,X71)","v":0},{"$f":"SUM(Y57,Y71)","v":0}]
[null,null,null,{"$f":"C_Scenario!F95","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K95","v":0},null,null,null,null,null,null,"% / jaar"]
[]
[null,null,null,{"$f":"C_Scenario!F99","v":"Financiering 6"},null,null,"Ingevuld:",null,null,null,null,null,null,null,null,null,null,null,"8.","Overzicht marge en resultaat - INPUT"]
[null,null,null,{"$f":"C_Scenario!F100","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K100","v":0},null,null,null,null,null,null,"EUR"]
[null,null,null,{"$f":"C_Scenario!F101","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K101","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,"Marge en resultaat",null,null,"Eenheid",{"$f":"\"Jaar \" & I_Generiek!$F$9","v":"Jaar "}]
[null,null,null,{"$f":"C_Scenario!F105","v":"Financiering 7"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F106","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K106","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,{"$f":"O_Graph!E61","v":"Netto omzet"},null,null,"EUR",{"$f":"O_Graph!H61","v":0}]
[null,null,null,{"$f":"C_Scenario!F107","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K107","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,null,{"$f":"O_Graph!E62","v":"Inkoopwaarde voorraad"},null,null,"EUR",{"$f":"O_Graph!H62","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O_Graph!E63","v":"Brutomarge"},null,null,"EUR",{"$f":"SUM(X81:Y82)","v":0}]
[null,null,null,{"$f":"C_Scenario!F111","v":"Financiering 8"},null,null,"Ingevuld:"]
[null,null,null,{"$f":"C_Scenario!F112","v":"Financieringsbedrag"},null,null,{"$f":"C_Scenario!K112","v":0},null,null,null,null,null,null,"EUR",null,null,null,null,null,{"$f":"T45","v":"Directe kosten"}]
[null,null,null,{"$f":"C_Scenario!F113","v":"Rentepercentage"},null,null,{"$f":"C_Scenario!K113","v":0},null,null,null,null,null,null,"% / jaar",null,null,null,null,null,"Personele lasten 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,"1.7","Productie",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bestaande afschrijvingslasten - direct",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,"Nieuwe afschrijvingslasten - direct",null,null,"EUR",{"$f":"-X49*I_Generiek!$F$18","v":0}]
[null,null,null,"Interne en externe gefactureerde uren",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Leasekosten werkplaatsapparatuur",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,"Kosten gereedschappen klein",null,null,"EUR",{"$f":"-X51*I_Generiek!$F$18","v":0}]
[null,null,null,null,null,null,"Ingevuld:",null,null,null,null,null,null,null,null,null,null,null,null,"Garantiekosten",null,null,"EUR",{"$f":"-X52*I_Generiek!$F$18","v":0}]
[null,null,null,{"$f":"I_Generiek!E18","v":"Extern gefactureerde uren"},null,null,{"$f":"I_Generiek!F18","v":0},null,null,null,null,null,null,"uren",null,null,null,null,null,"Franchisekosten",null,null,"EUR",{"$f":"-X53*I_Generiek!$F$18","v":0}]
[null,null,null,{"$f":"I_Generiek!E24","v":"Intern gefactureerde uren"},null,null,{"$f":"I_Generiek!F24","v":0},null,null,null,null,null,null,"uren",null,null,null,null,null,"Transportkosten",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,"Huisvestingskosten",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,"Overige directe kosten",null,null,"EUR",{"$f":"-X56*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(X86:Y96)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T59","v":"Indirecte kosten"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Personele lasten 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,"Opleidingskosten indirect personeel",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,"Bestaande 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,"Nieuwe afschrijvingslasten - indirect",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,"Bestaande 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,"Nieuwe rentelasten",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,"Management fee / Ondernemersbeloning",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,"IT kosten",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,"Energiekosten",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,"Marketingkosten",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,{"$f":"T71","v":"Totaal indirecte kosten"},null,null,"EUR",{"$f":"SUM(X100:Y110)","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(X83,X97,X111)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correctie voor afschrijvingslasten",null,null,"EUR",{"$f":"-SUM(X88:Y89,X102:Y103)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correctie voor rentelasten",null,null,"EUR",{"$f":"-SUM(X104:Y105)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EBITDA",null,null,"EUR",{"$f":"SUM(X113,X115:Y116)","v":0}]

{"sheet":"O_Graph","index":13,"n_rows":117,"n_cols":16,"rows_kept":117,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \n(Gemotoriseerde) Tweewielers | 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!F292","v":"Directe personeelskosten"},null,null,{"$f":"C_Base!Q292","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!F293","v":"Indirecte personeelskosten"},null,null,{"$f":"C_Base!Q293","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!F294","v":"Directe afschrijvingslasten"},null,null,{"$f":"C_Base!Q294","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!F295","v":"Indirecte afschrijvingslasten"},null,null,{"$f":"C_Base!Q295","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!F296","v":"Rentelasten"},null,null,{"$f":"C_Base!Q296","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!F297","v":"Directe overige kosten"},null,null,{"$f":"C_Base!Q297","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!F298","v":"Indirecte overige kosten"},null,null,{"$f":"C_Base!Q298","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},0,{"$f":"IFERROR(J25+I26,\"\")","v":0},{"$f":"IF(I26<0,J26,J25)","v":0},0,0]
[null,null,null,null,"",null,null,4,0,0,0,0,0]
[null,null,null,null,"",null,null,5,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!F184","v":"Directe personeelskosten"},null,null,{"$f":"C_Scenario!O184","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!F185","v":"Indirecte personeelskosten"},null,null,{"$f":"C_Scenario!O185","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!F186","v":"Directe afschrijvingslasten"},null,null,{"$f":"C_Scenario!O186","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!F187","v":"Indirecte afschrijvingslasten"},null,null,{"$f":"C_Scenario!O187","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!F188","v":"Rentelasten"},null,null,{"$f":"C_Scenario!O188","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!F189","v":"Directe overige kosten"},null,null,{"$f":"C_Scenario!O189","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!F190","v":"Indirecte overige kosten"},null,null,{"$f":"C_Scenario!O190","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,"Netto omzet",null,null,{"$f":"IFERROR(IF(I_Omzet!$G$9<>\"Ja\",I_Omzet!K11*INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH(I_Omzet!M11,I_Verdeelsleutel!$E$11:$E$18,0)),I_Omzet!K11),0)","v":0}]
[null,null,null,null,"Inkoopwaarde voorraad",null,null,{"$f":"-IFERROR(IF(I_Omzet!$G$9<>\"Ja\",I_Omzet!K13*INDEX(I_Verdeelsleutel!$J$11:$J$18,MATCH(I_Omzet!M13,I_Verdeelsleutel!$E$11:$E$18,0)),I_Omzet!K13),0)","v":0}]
[null,null,null,null,"Brutomarge",null,null,{"$f":"SUM(H61:H62)","v":0}]
[null,null,null,null,"Bedrijfskosten",null,null,{"$f":"-C_Scenario!K172","v":0}]
[null,null,null,null,"Resultaat (voor belasting)",null,null,{"$f":"SUM(H63:H64)","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!F196","v":"Totale personeelskosten direct personeel (excl. opleidingskosten)"},null,null,"Personele lasten direct personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H69,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H69,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F197","v":"Opleidingskosten direct personeel"},null,null,"Opleidingskosten direct personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H70,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H70,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!D11","v":"Personele lasten direct personeel"},null,null,{"$f":"C_Scenario!F198","v":"Totale personeelskosten indirect personeel (excl. opleidingskosten)"},null,null,"Personele lasten indirect personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H71,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H71,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E23","v":"Opleidingskosten direct personeel"},null,null,{"$f":"C_Scenario!F199","v":"Opleidingskosten indirect personeel"},null,null,"Opleidingskosten indirect personeel",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H72,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H72,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"C_Base!F142","v":"Bestaande afschrijvingslasten - direct"},null,null,{"$f":"C_Scenario!F200","v":"Bestaande afschrijvingslasten - direct"},null,null,"Bestaande afschrijvingslasten - direct",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H73,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H73,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"C_Base!F144","v":"Nieuwe afschrijvingslasten - direct"},null,null,{"$f":"C_Scenario!F201","v":"Bestaande afschrijvingslasten - indirect"},null,null,"Bestaande afschrijvingslasten - indirect",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H74,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H74,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E47","v":"Leasekosten werkplaatsapparatuur"},null,null,{"$f":"C_Scenario!F202","v":"Nieuwe afschrijvingslasten - direct"},null,null,"Nieuwe afschrijvingslasten - direct",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H75,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H75,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E49","v":"Kosten gereedschappen klein"},null,null,{"$f":"C_Scenario!F203","v":"Nieuwe afschrijvingslasten - indirect"},null,null,"Nieuwe afschrijvingslasten - indirect",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H76,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H76,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E51","v":"Garantiekosten"},null,null,{"$f":"C_Scenario!F204","v":"Bestaande rentelasten"},null,null,"Bestaande rentelasten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H77,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H77,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E53","v":"Franchisekosten"},null,null,{"$f":"C_Scenario!F205","v":"Nieuwe rentelasten"},null,null,"Nieuwe rentelasten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H78,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H78,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E55","v":"Transportkosten"},null,null,{"$f":"C_Scenario!F206","v":"Leasekosten werkplaatsapparatuur"},null,null,"Leasekosten werkplaatsapparatuur",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H79,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H79,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E59","v":"Huisvestingskosten"},null,null,{"$f":"C_Scenario!F207","v":"Kosten gereedschappen klein"},null,null,"Kosten gereedschappen klein",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H80,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H80,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,"Overige directe kosten",null,null,{"$f":"C_Scenario!F208","v":"Garantiekosten"},null,null,"Garantiekosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H81,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H81,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!D25","v":"Personele lasten indirect personeel"},null,null,{"$f":"C_Scenario!F209","v":"Franchisekosten"},null,null,"Franchisekosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H82,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H82,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E29","v":"Opleidingskosten indirect personeel"},null,null,{"$f":"C_Scenario!F210","v":"Transportkosten"},null,null,"Transportkosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H83,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H83,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"C_Base!F143","v":"Bestaande afschrijvingslasten - indirect"},null,null,{"$f":"C_Scenario!F211","v":"Huisvestingskosten"},null,null,"Huisvestingskosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H84,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H84,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"C_Base!F145","v":"Nieuwe afschrijvingslasten - indirect"},null,null,{"$f":"C_Scenario!F212","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H85,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H85,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"C_Base!F211","v":"Bestaande rentelasten"},null,null,{"$f":"C_Scenario!F213","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H86,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H86,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"C_Base!F212","v":"Nieuwe rentelasten"},null,null,{"$f":"C_Scenario!F214","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H87,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H87,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E83","v":"Management fee / Ondernemersbeloning"},null,null,{"$f":"C_Scenario!F215","v":""},null,null,"Overige directe kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H88,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H88,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E85","v":"IT kosten"},null,null,{"$f":"C_Scenario!F216","v":"Management fee / Ondernemersbeloning"},null,null,"Management fee / Ondernemersbeloning",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H89,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H89,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E87","v":"Energiekosten"},null,null,{"$f":"C_Scenario!F217","v":"IT kosten"},null,null,"IT kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H90,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H90,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E89","v":"Marketingkosten"},null,null,{"$f":"C_Scenario!F218","v":"Energiekosten"},null,null,"Energiekosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H91,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H91,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,{"$f":"I_Kosten!E91","v":"Overige indirecte kosten"},null,null,{"$f":"C_Scenario!F219","v":"Marketingkosten"},null,null,"Marketingkosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H92,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H92,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F220","v":"Overige indirecte kosten"},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H93,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H93,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F221","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H94,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H94,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F222","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H95,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H95,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F223","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H96,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H96,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F224","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H97,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H97,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F225","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H98,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H98,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F226","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H99,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H99,C_Scenario!$F$196:$F$227,0))","v":0}]
[null,null,null,null,null,null,null,{"$f":"C_Scenario!F227","v":""},null,null,"Overige indirecte kosten",null,null,null,{"$f":"INDEX(C_Scenario!$K$196:$K$227,MATCH($H100,C_Scenario!$F$196:$F$227,0))","v":0},{"$f":"INDEX(C_Scenario!$O$196:$O$227,MATCH($H100,C_Scenario!$F$196:$F$227,0))","v":0}]
[]
[null,null,null,"4.2","Check",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O69:O100)=C_Scenario!K229","v":true},{"$f":"SUM(P69:P100)=C_Scenario!O229","v":true}]
[]
[null,null,"5.","KPI's en ratio's"]
[]
[null,null,null,"5.1","KPI's en ratio's"]
[null,null,null,null,null,null,null,"Ratio","Restant"]
[null,null,null,null,"Energiekosten / totale kosten",null,null,{"$f":"IFERROR(C_Scenario!K147/C_Scenario!K172,0)","v":0},{"$f":"100%-H108","v":1}]
[null,null,null,null,"Personeelskosten / totale kosten",null,null,{"$f":"IFERROR(SUM(C_Scenario!K164:K165)/C_Scenario!K172,0)","v":0},1]
[null,null,null,null,"Personeelskosten / netto omzet",null,null,{"$f":"IFERROR(SUM(C_Scenario!K164:K165)/H61,0)","v":0},1]
[null,null,null,null,"Afschrijvingen en leasekosten / netto omzet",null,null,{"$f":"IFERROR(SUM(C_Scenario!K166:K167,C_Scenario!K129)/H61,0)","v":0},1]
[null,null,null,null,"Rentelasten / netto omzet",null,null,{"$f":"IFERROR(C_Scenario!K168/H61,0)","v":0},1]
[null,null,null,null,"Directe kosten / netto omzet",null,null,{"$f":"IFERROR(SUM(C_Scenario!K164,C_Scenario!K166,C_Scenario!K169)/H61,0)","v":0},1]
[null,null,null,null,"Directe kosten / totale kosten",null,null,{"$f":"IFERROR(SUM(C_Scenario!K164,C_Scenario!K166,C_Scenario!K169)/C_Scenario!K172,0)","v":0},1]
[null,null,null,null,"Indirecte kosten / totale kosten",null,null,{"$f":"IFERROR(SUM(C_Scenario!K165,C_Scenario!K167,C_Scenario!K168,C_Scenario!K170)/C_Scenario!K172,0)","v":0},1]
[null,null,null,null,"Indirecte kosten / netto omzet",null,null,{"$f":"IFERROR(SUM(C_Scenario!K165,C_Scenario!K167,C_Scenario!K168,C_Scenario!K170)/H61,0)","v":0},1]
[null,null,null,null,"Directe kosten per gefactureerd uur",null,null,{"$f":"IFERROR(SUM(C_Scenario!K164,C_Scenario!K166,C_Scenario!K169)/C_Scenario!K178,0)","v":0}]

{"sheet":"CHECK","index":14,"n_rows":224,"n_cols":12,"rows_kept":224,"cut":false,"hidden":false,"merged":[[7,10,7,11]]}
[null,null,{"$f":"COVER!C5&\" | \"&COVER!C6&\" | \"&A3","v":"BOVAG | Kostprijsmodel \n(Gemotoriseerde) Tweewielers | 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:H97)","v":9},null,null,{"$f":"IF(H9>0,CHAR(108),\"\")","v":"l"},{"$f":"IF(H9=0,CHAR(108),\"\")","v":""}]
[]
[null,null,"1.","I_Generiek"]
[]
[null,null,null,"1.1","Heeft u een jaar ingevuld waarvoor u de kostprijs wilt berekenen?",null,{"$f":"IF(I_Generiek!F9=\"\",FALSE,TRUE)","v":false},{"$f":"IF(G13=FALSE,1,0)","v":1},{"$f":"IF(H13=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"1.2","Heeft u de extern en intern gefactureerde uren voor het betreffende jaar ingevuld?",null,{"$f":"IF(SUM(I_Generiek!F18,I_Generiek!F24)<=0,FALSE,TRUE)","v":false},{"$f":"IF(G14=FALSE,1,0)","v":1},"KLIK HIER"]
[]
[null,null,"2.","I_Verdeelsleutel"]
[]
[null,null,null,"2.1","Heeft u 1 of meerdere verdeelsleutels aangemaakt?",null,{"$f":"IF(SUMPRODUCT(I_Verdeelsleutel!J11:J18)*1=0,FALSE,TRUE)","v":false},{"$f":"IF(G18=FALSE,1,0)","v":1},{"$f":"IF(H18=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[]
[null,null,"3.","I_Kosten"]
[]
[null,null,null,"3.1","Heeft u uw totale bedrijfskosten ingevuld?",null,{"$f":"IF(I_Kosten!K9=\"\",FALSE,TRUE)","v":false},{"$f":"IF(G22=FALSE,1,0)","v":1},{"$f":"IF(H22=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"3.2","Heeft u een keuze gemaakt voor eenvoudige of detail invoer voor directe personeelskosten?",null,{"$f":"IF(I_Kosten!G13=\"\",FALSE,TRUE)","v":false},1,{"$f":"IF(H23=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"3.3","Heeft u de totale personeelskosten 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 brutolonen voor direct personeel ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K17=0,COUNTA(I_Kosten!K17)=COUNTA(I_Kosten!M17)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.5","Heeft u de sociale- en werkgeverslasten voor direct personeel ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K19=0,COUNTA(I_Kosten!K19)=COUNTA(I_Kosten!M19)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.6","Heeft u de overige directe personeelskosten 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,{"$f":"IF(H27=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.7","Heeft u de opleidingskosten voor direct personeel ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K23=0,COUNTA(I_Kosten!K23)=COUNTA(I_Kosten!M23)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.8","Heeft u de indirecte personeelskosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K27=0,COUNTA(I_Kosten!K27)=COUNTA(I_Kosten!M27)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.9","Heeft u de opleidingskosten voor indirect personeel ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K29=0,COUNTA(I_Kosten!K29)=COUNTA(I_Kosten!M29)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.10","Heeft u de directe afschrijvingslasten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K33=0,COUNTA(I_Kosten!K33)=COUNTA(I_Kosten!M33)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.11","Heeft u de indirecte afschrijvingslasten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K35=0,COUNTA(I_Kosten!K35)=COUNTA(I_Kosten!M35)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.12","Heeft u een keuze gemaakt om wel of niet extra investeringen te willen invullen?",null,{"$f":"IF(I_Kosten!G37=\"\",FALSE,TRUE)","v":false},1,{"$f":"IF(H33=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"3.13","Heeft u de rentelasten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K41=0,COUNTA(I_Kosten!K41)=COUNTA(I_Kosten!M41)),TRUE,FALSE)","v":true},0,{"$f":"IF(H34=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.14","Heeft u een keuze gemaakt om wel of niet nieuwe rentelasten te willen invullen?",null,{"$f":"IF(I_Kosten!G43=\"\",FALSE,TRUE)","v":false},1,"KLIK HIER"]
[null,null,null,"3.15","Heeft u de leasekosten werkplaatsapparatuur 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.16","Heeft u de kosten gereedschappen klein ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K49=0,COUNTA(I_Kosten!K49)=COUNTA(I_Kosten!K49)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.17","Heeft u de garantiekosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K51=0,COUNTA(I_Kosten!K51)=COUNTA(I_Kosten!M51)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.18","Heeft u de franchisekosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K53=0,COUNTA(I_Kosten!K53)=COUNTA(I_Kosten!M53)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.19","Heeft u de transportkosten ingevuld 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.20","Heeft u een keuze gemaakt voor eenvoudige of detail invoer voor huisvestingslasten?",null,{"$f":"IF(I_Kosten!G57=\"\",FALSE,TRUE)","v":false},{"$f":"IF(G41=FALSE,1,0)","v":1},{"$f":"IF(H41=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"3.21","Heeft u huisvestingskosten 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},{"$f":"IF(G42=FALSE,1,0)","v":0},{"$f":"IF(H42=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.22","Heeft u de huisvestingkosten - huur ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K61=0,COUNTA(I_Kosten!K61)=COUNTA(I_Kosten!M61)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.23","Heeft u de huisvestingkosten - onderhoud ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K63=0,COUNTA(I_Kosten!K63)=COUNTA(I_Kosten!M63)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.24","Heeft u de huisvestingkosten - verzekeringen 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(G45=FALSE,1,0)","v":0},{"$f":"IF(H45=1,\"KLIK HIER\",\"\")","v":""}]
[null,null,null,"3.25","Heeft u gebruik gemaakt van de lege velden bij huisvestingkosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K67=0,COUNTA(I_Kosten!K67)=COUNTA(I_Kosten!M67)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.26","Heeft u gebruik gemaakt van de lege velden bij huisvestingkosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K69=0,COUNTA(I_Kosten!K69)=COUNTA(I_Kosten!M69)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.27","Heeft u gebruik gemaakt van de lege velden bij huisvestingkosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K71=0,COUNTA(I_Kosten!K71)=COUNTA(I_Kosten!M71)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.28","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K73=0,COUNTA(I_Kosten!K73)=COUNTA(I_Kosten!M73)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.29","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K75=0,COUNTA(I_Kosten!K75)=COUNTA(I_Kosten!M75)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.30","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K77=0,COUNTA(I_Kosten!K77)=COUNTA(I_Kosten!M77)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.31","Heeft u gebruik gemaakt van de lege velden bij directe overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K79=0,COUNTA(I_Kosten!K79)=COUNTA(I_Kosten!M79)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.32","Heeft u de management fee / ondernemersbeloning kosten ingevuld 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.33","Heeft u de IT kosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K85=0,COUNTA(I_Kosten!K85)=COUNTA(I_Kosten!M85)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.34","Heeft u de energiekosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K87=0,COUNTA(I_Kosten!K87)=COUNTA(I_Kosten!M87)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.35","Heeft u de marketingkosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K89=0,COUNTA(I_Kosten!K89)=COUNTA(I_Kosten!M89)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.36","Heeft u de overige indirecte kosten ingevuld en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K91=0,COUNTA(I_Kosten!K91)=COUNTA(I_Kosten!M91)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.37","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K93=0,COUNTA(I_Kosten!K93)=COUNTA(I_Kosten!M93)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.38","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K95=0,COUNTA(I_Kosten!K95)=COUNTA(I_Kosten!M95)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.39","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K97=0,COUNTA(I_Kosten!K97)=COUNTA(I_Kosten!M97)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.40","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K99=0,COUNTA(I_Kosten!K99)=COUNTA(I_Kosten!M99)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.41","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K101=0,COUNTA(I_Kosten!K101)=COUNTA(I_Kosten!M101)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.42","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K103=0,COUNTA(I_Kosten!K103)=COUNTA(I_Kosten!M103)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.43","Heeft u gebruik gemaakt van de lege velden bij indirecte overige kosten en een verdeelsleutel geselecteerd?",null,{"$f":"IF(OR(I_Kosten!K105=0,COUNTA(I_Kosten!K105)=COUNTA(I_Kosten!M105)),TRUE,FALSE)","v":true},0,""]
[null,null,null,"3.44","Komen de ingevoerde totale bedrijfskosten overeen met de optelling van de afzonderlijke kosten?",null,{"$f":"I_Kosten!K113","v":true},0,""]
[]
[null,null,"4.","I_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(G69=FALSE,1,0)","v":1},{"$f":"IF(H69=1,\"KLIK HIER\",\"\")","v":"KLIK HIER"}]
[null,null,null,"4.2","Heeft u de netto 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 inkoopwaarde voorraad 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,"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$37=\"Ja\",I_Investeringen!G9=\"\"),FALSE,TRUE)","v":true},{"$f":"IF(G75=FALSE,1,0)","v":0},{"$f":"IF(H75=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!G68<>\"\",I_Investeringen!G69<>\"\",I_Investeringen!K70:K72<>\"\",I_Investeringen!M68<>\"\",I_Investeringen!O68<>\"\"),AND(I_Investeringen!$G$9=\"Nee\",I_Investeringen!G68=\"\",I_Investeringen!G69=\"\",I_Investeringen!K70:K72=\"\",I_Investeringen!M68=\"\",I_Investeringen!O68=\"\")),TRUE,FALSE)","v":true},0,""]
[]
[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$43=\"Ja\",I_Financiering!G9=\"\"),FALSE,TRUE)","v":true},{"$f":"IF(G89=FALSE,1,0)","v":0},{"$f":"IF(H89=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!G38<>\"\",I_Financiering!K39<>\"\",I_Financiering!K40<>\"\",I_Financiering!M38<>\"\"),AND(I_Financiering!$G$9=\"Nee\",I_Financiering!G38=\"\",I_Financiering!K39=\"\",I_Financiering!K40=\"\",I_Financiering!M38=\"\")),TRUE,FALSE)","v":true},0,""]
[null,null,null,"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"]