{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dashboard","Voertuig_Profielen","Brandstof_Profielen","Referentie","Alternatief 1","Alternatief 2","Info en copyright"],"not_rendered":{"charts":5,"images":13,"macros":1,"external_links":0,"defined_names":273,"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":"Dashboard","index":0,"n_rows":128,"n_cols":63,"rows_kept":128,"cut":false,"hidden":false,"merged":[[126,16,127,17],[59,60,59,61],[60,60,60,61],[47,56,47,61],[57,60,57,61],[58,60,58,61],[127,25,127,30],[113,25,113,30],[122,25,122,30],[123,25,123,30],[124,25,124,30],[125,25,125,30],[126,25,126,30],[117,25,117,30],[118,25,118,30],[119,25,119,30],[117,2,118,2],[70,15,70,48],[61,16,61,20],[92,32,92,33],[92,36,92,39],[112,15,112,31],[112,33,112,45],[114,25,114,30],[115,25,115,30],[116,25,116,30],[92,26,92,27],[92,30,92,31],[92,34,92,35],[114,22,114,23],[115,22,115,23],[116,22,116,23],[1,4,1,6],[70,1,70,13],[86,2,87,4],[82,2,83,4],[109,10,110,10],[109,8,110,8],[109,12,110,12],[109,2,110,6],[75,7,76,7],[77,7,78,7],[80,2,80,12],[63,6,63,12],[120,25,120,30],[121,25,121,30],[117,22,117,23],[118,22,118,23],[119,22,119,23],[120,22,120,23],[121,22,121,23],[127,22,127,23],[122,22,122,23],[123,22,123,23],[124,22,124,23],[125,22,125,23],[126,22,126,23]]}
[]
[null,null,null,null,"Keuze Nieuw of Retrofit",null,null,null,"Categorie",null,"Categorie",null,"Categorie",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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Kosten per \"&IF(Per_uur=1,\"uur\",\"km\")","v":"Kosten per uur"},null,"Ref","Alt1","Alt2",null,"Rank"]
[null,null,null,null,{"$f":"Profielgroep2","v":"Alt1"},null,"Cat2_",null,"Cat1_",null,{"$f":"VLOOKUP(K85,$E3:$G4,3,0)","v":"Cat2_"},null,{"$f":"VLOOKUP(M85,$E3:$G4,3,0)","v":"Cat2_"},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,null,null,null,null,null,null,null,null,null,null,null,"Brandstofkosten",null,{"$f":"ROUND(Referentie!G34,2)","v":2.5},{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G34,2))","v":1},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G34,2))","v":1.2},null,{"$f":"COUNTIF($BG$3:$BG$11,\">\"&BG3)+COUNTIF(BG$3:BG3,BG3)","v":3}]
[null,null,null,null,{"$f":"Profielgroep3","v":"Alt2"},null,"Cat3_",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Onderhoudskosten",null,{"$f":"ROUND(Referentie!G35,2)","v":0},{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G35,2))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G35,2))","v":0},null,{"$f":"COUNTIF($BG$3:$BG$11,\">\"&BG4)+COUNTIF(BG$3:BG4,BG4)","v":5}]
[null,null,null,null,null,null,null,null,null,null,"Bepaal PullDown",null,"Bepaal PullDown",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,null,null,null,null,null,null,null,null,null,null,null,"Verzekeringen",null,{"$f":"ROUND(Referentie!G36,2)","v":0},{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G36,2))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G36,2))","v":0},null,{"$f":"COUNTIF($BG$3:$BG$11,\">\"&BG5)+COUNTIF(BG$3:BG5,BG5)","v":6}]
[null,null,null,null,"Overzicht voertuigprofielen",null,null,null,null,null,"PullDown Alternatief 1",null,"PullDown Alternatief 2",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,null,null,null,null,null,null,null,null,null,null,null,"Voertuigbelastingen",null,{"$f":"ROUND(Referentie!G37,2)","v":0},{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G37,2))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G37,2))","v":0},null,{"$f":"COUNTIF($BG$3:$BG$11,\">\"&BG6)+COUNTIF(BG$3:BG6,BG6)","v":7}]
[null,null,null,null,"Soort+Naam",null,"Nr.",null,null,null,{"$f":"Alternatief1_Categorie&\"PullDown\"&HLOOKUP(K85,PullDown_Selectie,14,0)","v":"Cat2_PullDown2"},null,{"$f":"Alternatief2_Categorie&\"PullDown\"&HLOOKUP(M85,PullDown_Selectie,14,0)","v":"Cat2_PullDown2"},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,null,null,null,null,null,null,null,null,null,null,null,"Overige kosten",null,{"$f":"ROUND(Referentie!G38,2)","v":0},{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G38,2))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G38,2))","v":0},null,{"$f":"COUNTIF($BG$3:$BG$11,\">\"&BG7)+COUNTIF(BG$3:BG7,BG7)","v":8}]
[null,null,null,null,{"$f":"\"Cat1_\"&Voertuig_Profielen!H42","v":"Cat1_EUR6"},null,1,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ontheffingen",null,{"$f":"ROUND(Referentie!G39,2)","v":0},{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G39,2))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G39,2))","v":0},null,{"$f":"COUNTIF($BG$3:$BG$11,\">\"&BG8)+COUNTIF(BG$3:BG8,BG8)","v":9}]
[null,null,null,null,{"$f":"\"Cat1_\"&Voertuig_Profielen!I42","v":"Cat1_"},null,{"$f":"G8+1","v":2},null,"Ophalen Referentie",null,"Ophalen Alternatief1",null,"Ophalen Alternatief 2",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,null,null,null,null,null,null,null,null,null,null,null,"Personeelskosten",null,{"$f":"ROUND(Referentie!G40,2)","v":25},{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G40,2))","v":25},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G40,2))","v":25},null,{"$f":"COUNTIF($BG$3:$BG$11,\">\"&BG9)+COUNTIF(BG$3:BG9,BG9)","v":1}]
[null,null,null,null,{"$f":"\"Cat1_\"&Voertuig_Profielen!J42","v":"Cat1_"},null,{"$f":"G9+1","v":3},null,"Naam",null,"Soort+Naam:",null,"Soort+Naam:",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,null,null,null,null,null,null,null,null,null,null,null,"Rente",null,{"$f":"ROUND(Referentie!G41,2)","v":0.35},{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G41,2))","v":0.68},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G41,2))","v":0.68},null,{"$f":"COUNTIF($BG$3:$BG$11,\">\"&BG10)+COUNTIF(BG$3:BG10,BG10)","v":4}]
[null,null,null,null,{"$f":"\"Cat1_\"&Voertuig_Profielen!K42","v":"Cat1_"},null,4,null,{"$f":"\"Cat1_\"&I87","v":"Cat1_EUR6"},null,{"$f":"Alternatief1_Categorie&K87","v":"Cat2_Elek1"},null,{"$f":"Alternatief2_Categorie&M87","v":"Cat2_Elek1"},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,null,null,null,null,null,null,null,null,null,null,null,"Afschrijving",null,{"$f":"ROUND(Referentie!G42,2)","v":3.13},{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G42,2))","v":5},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G42,2))","v":5},null,{"$f":"COUNTIF($BG$3:$BG$11,\">\"&BG11)+COUNTIF(BG$3:BG11,BG11)","v":2}]
[null,null,null,null,{"$f":"\"Cat1_\"&Voertuig_Profielen!L42","v":"Cat1_"},null,5,null,{"$f":"IF(Referentie_Naam=\"Nieuw Profiel\",\"Ref_New\",IFERROR(\"Naar_Ref_\"&VLOOKUP(I11,Voertuigdefinitie_Tabel2,3,FALSE),\"Ref_New\"))","v":"Naar_Ref_1"},null,{"$f":"IF(Alternatief1_Naam=\"Nieuw Profiel\",\"Alt1_New\",IFERROR(\"Naar_Alt1_\"&VLOOKUP(K11,Voertuigdefinitie_Tabel,3,FALSE),\"Alt1_New\"))","v":"Naar_Alt1_1"},null,{"$f":"IF(Alternatief2_Naam=\"Nieuw Profiel\",\"Alt2_New\",IFERROR(\"Naar_Alt2_\"&VLOOKUP(M11,Voertuigdefinitie_Tabel,3,FALSE),\"Alt2_New\"))","v":"Naar_Alt2_1"},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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(BE$3:BE$11,MATCH(ROWS(BE$12:BE12),$BK$3:$BK$11,0)),\"\")","v":"Personeelskosten"},null,{"$f":"INDEX(BG$3:BG$11,MATCH(ROWS(BG$12:BG12),$BK$3:$BK$11,0))","v":25},{"$f":"VLOOKUP($BE12,$BE$3:$BI$11,4,FALSE)","v":25},{"$f":"VLOOKUP($BE12,$BE$3:$BI$11,5,FALSE)","v":25}]
[null,null,null,null,{"$f":"\"Cat1_\"&Voertuig_Profielen!M42","v":"Cat1_"},null,6,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(BE$3:BE$11,MATCH(ROWS(BE$12:BE13),$BK$3:$BK$11,0)),\"\")","v":"Afschrijving"},null,{"$f":"INDEX(BG$3:BG$11,MATCH(ROWS(BG$12:BG13),$BK$3:$BK$11,0))","v":3.13},5,5]
[null,null,null,null,{"$f":"\"Cat1_\"&Voertuig_Profielen!N42","v":"Cat1_"},null,7,null,"Bewaren Referentie",null,"Bewaren Alternatief 1",null,"Bewaren Alternatief 2",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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(BE$3:BE$11,MATCH(ROWS(BE$12:BE14),$BK$3:$BK$11,0)),\"\")","v":"Brandstofkosten"},null,{"$f":"INDEX(BG$3:BG$11,MATCH(ROWS(BG$12:BG14),$BK$3:$BK$11,0))","v":2.5},1,1.2]
[null,null,null,null,{"$f":"\"Cat1_\"&Voertuig_Profielen!O42","v":"Cat1_"},null,8,null,"Soort+Naam:",null,"Soort+Naam:",null,"Soort+Naam:",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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(BE$3:BE$11,MATCH(ROWS(BE$12:BE15),$BK$3:$BK$11,0)),\"\")","v":"Rente"},null,{"$f":"INDEX(BG$3:BG$11,MATCH(ROWS(BG$12:BG15),$BK$3:$BK$11,0))","v":0.35},0.68,0.68]
[null,null,null,null,{"$f":"\"Cat1_\"&Voertuig_Profielen!P42","v":"Cat1_"},null,9,null,{"$f":"IF(AND(I87<>\"Nieuw Profiel\",I104<>\"\",COUNTIF(Cat1_Duiding,I104)=0),Referentie_Categorie,IF(I87<>\"Nieuw Profiel\",Referentie_Categorie&IF(I104=\"\",I87,I104),IF(COUNTIF(Voertuig_Name2,Referentie_Categorie&I104)=0,Referentie_Categorie,Referentie_Categorie&I104)))","v":"Cat1_EUR6"},null,{"$f":"IF(AND(K87<>\"Nieuw Profiel\",K104<>\"\",COUNTIF(Cat2_Duiding,K104)=0,COUNTIF(Cat3_Duiding,K104)=0),Alternatief1_Categorie,IF(K87<>\"Nieuw Profiel\",Alternatief1_Categorie&IF(K104=\"\",K87,K104),IF(COUNTIF(Voertuig_Name,Alternatief1_Categorie&K104)=0,Alternatief1_Categorie,Alternatief1_Categorie&K104)))","v":"Cat2_Elek1"},null,{"$f":"IF(AND(M87<>\"Nieuw Profiel\",M104<>\"\",COUNTIF(Cat2_Duiding,M104)=0,COUNTIF(Cat3_Duiding,M104)=0),Alternatief2_Categorie,IF(M87<>\"Nieuw Profiel\",Alternatief2_Categorie&IF(M104=\"\",M87,M104),IF(COUNTIF(Voertuig_Name,Alternatief2_Categorie&M104)=0,Alternatief2_Categorie,Alternatief2_Categorie&M104)))","v":"Cat2_Elek1"},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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(BE$3:BE$11,MATCH(ROWS(BE$12:BE16),$BK$3:$BK$11,0)),\"\")","v":"Onderhoudskosten"},null,{"$f":"INDEX(BG$3:BG$11,MATCH(ROWS(BG$12:BG16),$BK$3:$BK$11,0))","v":0},0,0]
[null,null,null,null,{"$f":"\"Cat1_\"&Voertuig_Profielen!Q42","v":"Cat1_"},null,10,null,"Macronaam:",null,"Macronaam:",null,"Macronaam:",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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(BE$3:BE$11,MATCH(ROWS(BE$12:BE17),$BK$3:$BK$11,0)),\"\")","v":"Verzekeringen"},null,{"$f":"INDEX(BG$3:BG$11,MATCH(ROWS(BG$12:BG17),$BK$3:$BK$11,0))","v":0},0,0]
[null,null,null,null,{"$f":"\"Cat2_\"&Voertuig_Profielen!H66","v":"Cat2_Elek1"},null,1,null,{"$f":"\"Van_Ref_\"&VLOOKUP(IF(COUNTIF(Voertuig_Name2,I16)=0,\"Referentievoertuig\",I16),Voertuigdefinitie_Tabel2,3,FALSE)","v":"Van_Ref_1"},null,{"$f":"\"Van_Alt1_\"&VLOOKUP(IF(COUNTIF(Voertuig_Name,K16)=0,Alternatief1_Categorie,K16),Voertuigdefinitie_Tabel,3,FALSE)","v":"Van_Alt1_1"},null,{"$f":"\"Van_Alt2_\"&VLOOKUP(IF(COUNTIF(Voertuig_Name,M16)=0,Alternatief2_Categorie,M16),Voertuigdefinitie_Tabel,3,FALSE)","v":"Van_Alt2_1"},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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(BE$3:BE$11,MATCH(ROWS(BE$12:BE18),$BK$3:$BK$11,0)),\"\")","v":"Voertuigbelastingen"},null,{"$f":"INDEX(BG$3:BG$11,MATCH(ROWS(BG$12:BG18),$BK$3:$BK$11,0))","v":0},0,0]
[null,null,null,null,{"$f":"\"Cat2_\"&Voertuig_Profielen!I66","v":"Cat2_"},null,{"$f":"G18+1","v":2},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(BE$3:BE$11,MATCH(ROWS(BE$12:BE19),$BK$3:$BK$11,0)),\"\")","v":"Overige kosten"},null,{"$f":"INDEX(BG$3:BG$11,MATCH(ROWS(BG$12:BG19),$BK$3:$BK$11,0))","v":0},0,0]
[null,null,null,null,{"$f":"\"Cat2_\"&Voertuig_Profielen!J66","v":"Cat2_"},null,3,null,"Referentie Dummy",null,"Alternatief 1 Dummy",null,"Alternatief 2 Dummy",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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(BE$3:BE$11,MATCH(ROWS(BE$12:BE20),$BK$3:$BK$11,0)),\"\")","v":"Ontheffingen"},null,{"$f":"INDEX(BG$3:BG$11,MATCH(ROWS(BG$12:BG20),$BK$3:$BK$11,0))","v":0},0,0]
[null,null,null,null,{"$f":"\"Cat2_\"&Voertuig_Profielen!K66","v":"Cat2_"},null,4,null,"Kopiëren Ref nr Profielen",null,"Kopiëren Alt 1 nr Profielen",null,"Kopiëren Alt 2 nr Profielen"]
[null,null,null,null,{"$f":"\"Cat2_\"&Voertuig_Profielen!L66","v":"Cat2_"},null,5,null,{"$f":"IF(I104=\"\",I87,I104)","v":"EUR6"},null,{"$f":"IF(K104=\"\",K87,K104)","v":"Elek1"},null,{"$f":"IF(M104=\"\",M87,M104)","v":"Elek1"},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,null,null,null,null,null,null,null,null,null,null,null,"Vermindering uitstoot #",null,null,"Alt1","Alt2"]
[null,null,null,null,{"$f":"\"Cat2_\"&Voertuig_Profielen!M66","v":"Cat2_"},null,6,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"CO2 (\"&U63&\", \"&CO2_weight&\")\"","v":"CO2 (WtW, ton)"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),-ROUND('Alternatief 1'!J112,0))","v":16},{"$f":"IF(Switch_Alt2=0,NA(),-ROUND('Alternatief 2'!J112,0))","v":16}]
[null,null,null,null,{"$f":"\"Cat2_\"&Voertuig_Profielen!N66","v":"Cat2_"},null,7,null,{"$f":"I89","v":"DSL1"},null,{"$f":"K89","v":"Elek"},null,{"$f":"M89","v":"Elek"},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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"NOx (\"&U64&\", \"&NOx_weight&\")\"","v":"NOx (TtW, kg)"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),-ROUND('Alternatief 1'!J115,0))","v":10},{"$f":"IF(Switch_Alt2=0,NA(),-ROUND('Alternatief 2'!J115,0))","v":10}]
[null,null,null,null,{"$f":"\"Cat2_\"&Voertuig_Profielen!O66","v":"Cat2_"},null,8,null,{"$f":"I90","v":50000},null,{"$f":"K90","v":100000},null,{"$f":"M90","v":100000},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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"PM (\"&U65&\", \"&PM_weight&\")\"","v":"PM (TtW, dag)"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),-ROUND('Alternatief 1'!J118,0))","v":23},{"$f":"IF(Switch_Alt2=0,NA(),-ROUND('Alternatief 2'!J118,0))","v":23}]
[null,null,null,null,{"$f":"\"Cat2_\"&Voertuig_Profielen!P66","v":"Cat2_"},null,9,null,{"$f":"I91","v":8},null,{"$f":"K91","v":10},null,{"$f":"M91","v":10},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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"geluid (×10^\"&noise_weight&\" dBh)\"","v":"geluid (×10^4 dBh)"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),-ROUND('Alternatief 1'!J121,0))","v":9},{"$f":"IF(Switch_Alt2=0,NA(),-ROUND('Alternatief 2'!J121,0))","v":9}]
[null,null,null,null,{"$f":"\"Cat2_\"&Voertuig_Profielen!Q66","v":"Cat2_"},null,10,null,{"$f":"I92","v":0},null,{"$f":"K92","v":8},null,{"$f":"M92","v":8}]
[null,null,null,null,{"$f":"\"Cat3_\"&Voertuig_Profielen!H90","v":"Cat3_"},null,11,null,{"$f":"I93","v":25},null,{"$f":"K93","v":100},null,{"$f":"M93","v":100},null,null,null,null,"Switch uur/km",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,null,null,null,null,null,null,"Vermindering uitstoot EUR",null,null,"Alt1","Alt2"]
[null,null,null,null,{"$f":"\"Cat3_\"&Voertuig_Profielen!I90","v":"Cat3_"},null,12,null,0,null,0,null,0,null,null,null,null,"uur/km",1,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,null,null,null,null,null,{"$f":"\"CO2 (\"&U63&\")\"","v":"CO2 (WtW)"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),-ROUND('Alternatief 1'!J113,0))","v":420},{"$f":"IF(Switch_Alt2=0,NA(),-ROUND('Alternatief 2'!J113,0))","v":420}]
[null,null,null,null,{"$f":"\"Cat3_\"&Voertuig_Profielen!J90","v":"Cat3_"},null,13,null,0,null,0,null,0,null,null,null,null,"per uur",{"$f":"IF(S29=1,1,0)","v":1},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,null,null,null,null,null,{"$f":"\"NOx (\"&U64&\")\"","v":"NOx (TtW)"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),-ROUND('Alternatief 1'!J116,0))","v":113},{"$f":"IF(Switch_Alt2=0,NA(),-ROUND('Alternatief 2'!J116,0))","v":113}]
[null,null,null,null,{"$f":"\"Cat3_\"&Voertuig_Profielen!K90","v":"Cat3_"},null,14,null,0,null,0,null,0,null,null,null,null,"per km",{"$f":"IF(S29=2,1,0)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"PM (\"&U65&\")\"","v":"PM (TtW)"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),-ROUND('Alternatief 1'!J119,0))","v":132},{"$f":"IF(Switch_Alt2=0,NA(),-ROUND('Alternatief 2'!J119,0))","v":132}]
[null,null,null,null,{"$f":"\"Cat3_\"&Voertuig_Profielen!L90","v":"Cat3_"},null,15,null,0,null,0,null,0,null,null,null,null,{"$f":"IF(Per_uur=1,\"EUR per uur\", \"EUR per kilometer\")","v":"EUR per uur"},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,null,null,null,null,null,null,"geluid",null,null,{"$f":"IF(Switch_Alt1=0,NA(),-ROUND('Alternatief 1'!J122,0))","v":724},{"$f":"IF(Switch_Alt2=0,NA(),-ROUND('Alternatief 2'!J122,0))","v":758}]
[null,null,null,null,{"$f":"\"Cat3_\"&Voertuig_Profielen!M90","v":"Cat3_"},null,16,null,0,null,0,null,0,null,null,null,null,{"$f":"IF(Per_uur=1,\"(EUR/uur):\", \"(EUR/km):\")","v":"(EUR/uur):"}]
[null,null,null,null,{"$f":"\"Cat3_\"&Voertuig_Profielen!N90","v":"Cat3_"},null,17,null,3.23,null,0,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Contante waarden",null,null,"Alt1","Alt2"]
[null,null,null,null,{"$f":"\"Cat3_\"&Voertuig_Profielen!O90","v":"Cat3_"},null,18,null,2.0609999999999999,null,0,null,0,null,null,null,null,"Switch alternatieven",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,null,null,null,null,null,null,"kosten",null,null,{"$f":"IF(Switch_Alt1=0,NA(),-ROUND('Alternatief 1'!G129,0))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),-ROUND('Alternatief 2'!G129,0))","v":0}]
[null,null,null,null,{"$f":"\"Cat3_\"&Voertuig_Profielen!P90","v":"Cat3_"},null,19,null,0.35699999999999998,null,7.8E-2,null,7.8E-2,null,null,null,null,"Alt1",1,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,null,null,null,null,null,"opbrengsten",null,null,{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G128,0))","v":11263},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G128,0))","v":11539}]
[null,null,null,null,{"$f":"\"Cat3_\"&Voertuig_Profielen!Q90","v":"Cat3_"},null,20,null,78,null,70,null,70,null,null,null,null,"Alt2",1]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Kn per maatregel",null,null,"Alt1","Alt2"]
[null,null,null,null,"Overzicht brandstofprofielen",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIA",null,null,{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G80,0))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G80,0))","v":0}]
[null,null,null,null,"Soort+Naam",null,"Nr.",null,null,null,null,null,null,null,null,null,null,"Switch gtm/ld",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,null,null,null,null,null,null,"VAMIL",null,null,{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G81,0))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G81,0))","v":0}]
[null,null,null,null,{"$f":"Brandstof_Profielen!G29","v":"DSL1"},null,1,null,null,null,null,null,null,null,null,null,null,"switch",1,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,null,null,null,null,null,{"$f":"Referentie!B84","v":"Subsidies"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G84,0))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G84,0))","v":0}]
[null,null,null,null,{"$f":"Brandstof_Profielen!H29","v":"Elek"},null,{"$f":"G41+1","v":2},null,"Checks tbv macro - alvorens profiel op te slaan",null,null,null,null,null,null,null,null,"gebruikstermijn",{"$f":"IF(S41=1,1,0)","v":1},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,null,null,null,null,null,{"$f":"Referentie!B85","v":"Δ Voertuigbelastingen"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G85,0))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G85,0))","v":0}]
[null,null,null,null,{"$f":"Brandstof_Profielen!I29","v":0},null,{"$f":"G42+1","v":3},null,"Fout in naam",null,"Fout in naam",null,"Fout in naam",null,null,null,null,"levensduur",{"$f":"IF(S41=2,1,0)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Referentie!B86","v":"Δ Overige kosten"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G86,0))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G86,0))","v":0}]
[null,null,null,null,{"$f":"Brandstof_Profielen!J29","v":0},null,4,null,{"$f":"IF(OR(AND(Referentie_Naam=\"\",I104=\"\"),AND(Referentie_Naam=\"Nieuw Profiel\",I104=\"\")),\"ja\",\"nee\")","v":"nee"},null,{"$f":"IF(OR(AND(Alternatief1_Naam=\"\",K104=\"\"),AND(Alternatief1_Naam=\"Nieuw Profiel\",K104=\"\")),\"ja\",\"nee\")","v":"nee"},null,{"$f":"IF(OR(AND(Alternatief2_Naam=\"\",M104=\"\"),AND(Alternatief2_Naam=\"Nieuw Profiel\",M104=\"\")),\"ja\",\"nee\")","v":"nee"},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,null,null,null,null,null,null,null,null,null,null,null,"Δ Ontheffing venster",null,null,{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G87,0))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G87,0))","v":0}]
[null,null,null,null,{"$f":"Brandstof_Profielen!K29","v":0},null,5,null,"Overschrijven naam",null,"Overschrijven naam",null,"Overschrijven naam",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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Referentie!B88","v":"Δ Brandstofprijs"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G88,0))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G88,0))","v":0}]
[null,null,null,null,{"$f":"Brandstof_Profielen!L29","v":0},null,6,null,{"$f":"IF(COUNTIF(Voertuig_Name2,I3&ProfielnaamR)>0,\"ja\",\"nee\")","v":"ja"},null,{"$f":"IF(COUNTIF(Voertuig_Name,K3&Profielnaam1)>0,\"ja\",\"nee\")","v":"ja"},null,{"$f":"IF(COUNTIF(Voertuig_Name,M3&Profielnaam2)>0,\"ja\",\"nee\")","v":"ja"},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,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Referentie!B89","v":"Rentesubsidies"},null,null,{"$f":"IF(Switch_Alt1=0,NA(),ROUND('Alternatief 1'!G89,0))","v":0},{"$f":"IF(Switch_Alt2=0,NA(),ROUND('Alternatief 2'!G89,0))","v":0}]
[null,null,null,null,{"$f":"Brandstof_Profielen!M29","v":0},null,7,null,"Vrije profielruimte",null,"Vrije profielruimte",null,"Vrije profielruimte"]
[null,null,null,null,{"$f":"Brandstof_Profielen!N29","v":0},null,8,null,{"$f":"IF(I105=0,\"nee\",\"ja\")","v":"ja"},null,{"$f":"IF(K105=0,\"nee\",\"ja\")","v":"ja"},null,{"$f":"IF(M105=0,\"nee\",\"ja\")","v":"ja"},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,null,null,null,null,null,null,null,null,null,null,null,"Omrekening gewichten en monteriseringsgetallen"]
[null,null,null,null,{"$f":"Brandstof_Profielen!O29","v":0},null,9,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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"gewichten","g","kg","geluid","kg","ton"]
[null,null,null,null,{"$f":"Brandstof_Profielen!P29","v":0},null,10,null,"Macronamen voor ophalen en bewaren brandstofprofiel",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mg",{"$f":"BF51*10","v":1000},1000000,1,{"$f":"BI51/10","v":1.0000000000000002E-6},1.0000000000000003E-9]
[null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(Referentie,Brandstofdefinitie_Tabel,3,FALSE)","v":1},null,{"$f":"VLOOKUP(Alternatief1,Brandstofdefinitie_Tabel,3,FALSE)","v":2},null,{"$f":"VLOOKUP(Alternatief2,Brandstofdefinitie_Tabel,3,FALSE)","v":2},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,null,null,null,null,null,null,null,null,null,null,null,"cg",100,100000,2,1.0000000000000001E-5,1.0000000000000002E-8]
[null,null,null,null,"Overzicht namen",null,null,null,{"$f":"\"Naar_Ref_Br\"&I51","v":"Naar_Ref_Br1"},null,{"$f":"\"Naar_Alt1_Br\"&K51","v":"Naar_Alt1_Br2"},null,{"$f":"\"Naar_Alt2_Br\"&M51","v":"Naar_Alt2_Br2"},null,null,null,"Fouten en waarschuwingen",null,"Dashboard","Voertuig","Brandstof",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,null,null,null,"dg",{"$f":"BF53*10","v":10},10000,3,1E-4,1.0000000000000002E-7]
[null,null,null,null,"Referentie",null,{"$f":"CONCATENATE(\"Referentie\"&CHAR(10)&TEXT(U127,\"##\")&\" km/jr \n\"&TEXT(U128,\"##\")&\" uren/jr\")","v":"Referentie\n20000 km/jr \n2000 uren/jr"},null,{"$f":"\"Van_Ref_Br\"&I51","v":"Van_Ref_Br1"},null,{"$f":"\"Van_Alt1_Br\"&K51","v":"Van_Alt1_Br2"},null,{"$f":"\"Van_Alt2_Br\"&M51","v":"Van_Alt2_Br2"},null,null,null,"Fouten",null,{"$f":"COUNTIF(H90:H123,\"→\")+COUNTIF(J90:J123,\"→\")+COUNTIF(L90:L123,\"→\")","v":0},{"$f":"IF(SUM(Voertuig_Profielen!S18:S20)+SUM(Voertuig_Profielen!S28:S30)>0,1,0)","v":0},{"$f":"IF(SUM(Brandstof_Profielen!R17)>0,1,0)","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,null,null,null,null,null,null,null,null,null,null,null,null,"g",1,1000,4,1E-3,1.0000000000000002E-6]
[null,null,null,null,"Alternatief 1",null,{"$f":"CONCATENATE(\"Alternatief 1\"&CHAR(10)&TEXT(W127,\"##\")&\" km/jr\n\"&TEXT(W128,\"##\")&\" uren/jr\")","v":"Alternatief 1\n20000 km/jr\n2000 uren/jr"},null,null,null,null,null,null,null,null,null,"Indirecte tijd",null,{"$f":"IF(Indirecte_minuten<0,1,)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"dag",{"$f":"BF53/10","v":0.1},100,5,0.01,1.0000000000000001E-5]
[null,null,null,null,"Alternatief 2",null,{"$f":"CONCATENATE(\"Alternatief 2\"&CHAR(10)&TEXT(Z127,\"##\")&\" km/jr\n \"&TEXT(Z128,\"##\")&\" uren/jr\")","v":"Alternatief 2\n24000 km/jr\n 2000 uren/jr"},null,"Reéle financieringsrente",null,null,null,null,null,null,null,"Ongeldige brandstofprofielen",null,{"$f":"COUNTIF(H89:H89,\"→\")+COUNTIF(J89:J89,\"→\")+COUNTIF(L89:L89,\"→\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hg",0.01,{"$f":"BG56*10","v":10},6,0.1,1E-4]
[null,null,null,null,null,null,null,null,"Regulier",null,"Regulier",null,"Regulier",null,null,null,"Categorie namen",null,{"$f":"COUNTIF(H85,\"→\")+COUNTIF(J85,\"→\")+COUNTIF(L85,\"→\")","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kg",1E-3,1,7,1,{"$f":"BJ57/1000","v":1E-3}]
[null,null,null,null,"Aantal voertuigkm",null,null,null,{"$f":"((1+Rente_nominaal/1)/(1+Inflatie/1)-1)","v":2.4630541871921263E-2},null,{"$f":"((1+Rente_nominaal/1)/(1+Inflatie/1)-1)","v":2.4630541871921263E-2},null,{"$f":"((1+Rente_nominaal/1)/(1+Inflatie/1)-1)","v":2.4630541871921263E-2},null,null,null,"Lege velden",null,{"$f":"COUNTBLANK(G75:G79)+COUNTBLANK(I89:I102)+COUNTBLANK(AS115:AS123)+Switch_Alt1*COUNTBLANK(K89:K102)+Switch_Alt2*COUNTBLANK(M89:M102)+COUNTBLANK(BrandstofprijsR)+Switch_Alt1*COUNTBLANK(Brandstofprijs1)+Switch_Alt2*COUNTBLANK(Brandstofprijs2)","v":0},{"$f":"IF(SUM(Voertuig_Profielen!S23:S25)>0,1,0)","v":0},{"$f":"IF(SUM(Brandstof_Profielen!R18)>0,1,0)","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,null,null,null,null,null,null,null,null,null,null,null,null,"ton",{"$f":"BF56/1000","v":9.9999999999999995E-7},{"$f":"BG56/1000","v":1E-3},8,{"$f":"BI56*1000","v":1000},1]
[null,null,null,null,"Referentie",null,{"$f":"G75","v":20000},null,"Zacht",null,"Zacht",null,"Zacht",null,null,null,"Lege velden referentie/algemeen",null,{"$f":"COUNTBLANK(I89:I102)+COUNTBLANK(BrandstofprijsR)+COUNTBLANK(AS115:AS123)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CO2",{"$f":"INDEX(weights_CO2,MATCH(CO2_weight,weights,0))","v":1E-3},null,9,{"$f":"INDEX(weights_CO2_EUR,MATCH(CO2_weight,weights,0))","v":1}]
[null,null,null,null,"Alternatief 1",null,{"$f":"K119/(Indirecte_minuten/60+G76*(1-K118)/Snelheid_Venster+(1-G76+G76*K118)/Snelheid_Overig)","v":20000},null,{"$f":"((1+I128/1)/(1+Inflatie/1)-1)","v":-1.477832512315258E-2},null,{"$f":"((1+K128/1)/(1+Inflatie/1)-1)","v":-1.477832512315258E-2},null,{"$f":"((1+M128/1)/(1+Inflatie/1)-1)","v":-1.477832512315258E-2},null,null,null,"Lege velden alternatieven",null,{"$f":"S57-S58","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOX",{"$f":"INDEX(weights_NOx_PM,MATCH(NOx_weight,weights,0))","v":1E-3},null,10,{"$f":"INDEX(weights_NOx_PM_EUR,MATCH(NOx_weight,weights,0))","v":1}]
[null,null,null,null,"Alternatief 2",null,{"$f":"M119/(Indirecte_minuten/60+G76*(1-M118)/Snelheid_Venster+(1-G76+G76*M118)/Snelheid_Overig)","v":23999.999999999996},null,null,null,null,null,null,null,null,null,"Inflatie",null,{"$f":"COUNTIF(H128,\"→\")+COUNTIF(J128,\"→\")+COUNTIF(L128,\"→\")+COUNTIF(AR119:AR120,\"→\")","v":0},{"$f":"COUNTIF(I128,\"→\")+COUNTIF(K128,\"→\")+COUNTIF(M128,\"→\")+COUNTIF(AS119:AS120,\"→\")","v":0},{"$f":"COUNTIF(J128,\"→\")+COUNTIF(L128,\"→\")+COUNTIF(N128,\"→\")+COUNTIF(AT119:AT121,\"→\")","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,null,null,null,null,null,null,null,null,null,null,null,null,"PM",{"$f":"INDEX(weights_NOx_PM,MATCH(PM_weight,weights,0))","v":0.1},null,null,{"$f":"INDEX(weights_NOx_PM_EUR,MATCH(PM_weight,weights,0))","v":0.01}]
[null,null,null,null,null,null,null,null,"Eenheden",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Geluid",{"$f":"noise_weight","v":4},null,null,"n.v.t."]
[null,null,null,null,null,null,null,null,{"$f":"HLOOKUP(Referentie,Brandstofprofielen,4,FALSE)","v":"liter"},null,{"$f":"HLOOKUP(Alternatief1,Brandstofprofielen,4,FALSE)","v":"kWh"},null,{"$f":"HLOOKUP(Alternatief2,Brandstofprofielen,4,FALSE)","v":"kWh"},null,null,null,"Type Emissie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Well-to-Wheel (WtW)",null,"WtW","CO2",{"$f":"VLOOKUP(Voertuig_Profielen!V46,Emissielijst,3,FALSE)","v":"WtW"}]
[null,null,null,null,null,null,"Check of profielnamen reeds voorkomen in de database t.b.v. opslaan",null,null,null,null,null,null,null,null,null,"Tank-to-Wheel (TtW)",null,"TtW","NOx",{"$f":"VLOOKUP(Voertuig_Profielen!V47,Emissielijst,3,FALSE)","v":"TtW"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(I104=\"\",Referentie_Naam,I104)","v":"EUR6"},null,{"$f":"IF(K104=\"\",Alternatief1_Naam,K104)","v":"Elek1"},null,{"$f":"IF(M104=\"\",Alternatief2_Naam,M104)","v":"Elek1"},null,null,null,"Tailpipe",null,"Tp","PM",{"$f":"VLOOKUP(Voertuig_Profielen!V48,Emissielijst,3,FALSE)","v":"TtW"}]
[null,null,null,null,null,null,"Voertuig -->",null,{"$f":"COUNTIF(Cat1_Duiding,I65)","v":1},null,{"$f":"IF(COUNTIF(Cat2_Duiding,K65)+COUNTIF(Cat3_Duiding,K65)>0,1,0)","v":1},null,{"$f":"IF(COUNTIF(Cat2_Duiding,M65)+COUNTIF(Cat3_Duiding,M65)>0,1,0)","v":1},null,null,null,"Selected:"]
[null,null,null,null,null,null,"Brandstof -->",null,{"$f":"COUNTIF(Brandstof_Duiding,Referentie)","v":1},null,{"$f":"COUNTIF(Brandstof_Duiding,Alternatief1)","v":1},null,{"$f":"COUNTIF(Brandstof_Duiding,Alternatief2)","v":1},null,null,null,{"$f":"Voertuig_Profielen!V46","v":"Well-to-Wheel (WtW)"}]
[null,null,null,null,null,null,null,null,"EUR6",null,"Elek1",null,"Elek1",null,null,null,{"$f":"\"Emissiereductie ten opzichte van referentie\"","v":"Emissiereductie ten opzichte van referentie"}]
[]
[]
[null,"INPUT: DEFINITIE VOERTUIGEN",null,null,null,null,null,null,null,null,null,null,null,null,null,"OUTPUT: GRAFIEKEN"]
[]
[]
[null,null,"VOERTUIGINZET",null,null,null,"Referentie"]
[null,null,"Inzet voertuig (km/jaar):",null,null,null,20000]
[null,null,"Inzet in APV-gebied (%):",null,null,null,1]
[null,null,"Inzet in APV-gebied (km):",null,null,null,{"$f":"Inzet_voertuig_Ref*G76","v":20000}]
[null,null,"Ø wv buiten APV-tijden (%):",null,null,null,0]
[null,null,"voertuiguren per jaar (uren):",null,null,null,2000]
[]
[null,null,{"$f":"IF(S53>0,\"FOUTEN GEDETECTEERD! Check geel gemarkeerde cellen.\",IF(S54>0,\"INDIRECTE TIJD IS NEGATIEF, PAS GEMARKEERDE VELDEN AAN\",IF(S55>0,\"SELECTEER EEN BESTAAND BRANDSTOFPROFIEL\",IF(U53>0,\"FOUTEN GEDETECTEERD. Check werkblad 'Brandstsof_Profielen'\",IF(T53>0,\"FOUTEN GEDETECTEERD. Check werkblad 'Voertuig_Profielen'.\",IF(S56>0,\"SELECTEER EEN BESTAANDE CATEGORIE OF HERSTEL FOUT IN VOERTUIG_PROFIELEN\",IF(S58>0,\"VOORZIE ORANJE GEKLEURDE CEL(LEN) VAN EEN WAARDE!\",IF(S59>0,\"VOORZIE ORANJE GEKLEURDE CEL(LEN) VAN EEN WAARDE OF DEACTIVEER ALTERNATIEF!\",IF(T57>0,\"ONVOLLEDIGE PROFIELEN GEDETECTEERD. Check werkblad 'Voertuig_Profielen'.\",IF(U57>0,\"ONVOLLEDIGE PROFIELEN GEDETECTEERD. Check werkblad 'Brandstof_Profielen'.\",IF(S60>0,\"WAARSCHUWING: rente is lager dan inflatie resulterend in negatieve reëele rente, zie oranje markeringen\",\"Status: ok\")))))))))))","v":"Status: ok"}]
[]
[null,null,"VOERTUIGSPECIFICATIE",null,null,null,null,null,"Referentie",null,"Alternatief 1",null,"Alternatief 2"]
[]
[null,null," KIES VOERTUIGPROFIEL →",null,null,null," Categorie:",null,{"$f":"Profielgroep1","v":"Referentie"},{"$f":"IF(Switch_Alt1=0,\"\",IF(K85=\"\",\"\",IF(AND(COUNTIF(Profielgroep2,K85)=0,COUNTIF(Profielgroep3,K85)=0),\"→\",\"\")))","v":""},"Alt1",{"$f":"IF(Switch_Alt2=0,\"\",IF(M85=\"\",\"\",IF(AND(COUNTIF(Profielgroep2,M85)=0,COUNTIF(Profielgroep3,M85)=0),\"→\",\"\")))","v":""},"Alt1"]
[]
[null,null,"↓ PAS PROFIEL AAN ↓",null,null,null," Profielnaam:",null,"EUR6",null,"Elek1",null,"Elek1"]
[]
[null,null,"Brandstofprofiel:",null,null,null,null,{"$f":"IF(checkR_Brandstof=0,\"→\",\"\")","v":""},"DSL1",{"$f":"IF(Switch_Alt1=0,\"\",IF(check1_Brandstof=0,\"→\",\"\"))","v":""},"Elek",{"$f":"IF(Switch_Alt2=0,\"\",IF(check2_Brandstof=0,\"→\",\"\"))","v":""},"Elek"]
[null,null,"Aanschafprijs voertuig (EUR):",null,null,null,null,null,50000,null,100000,null,100000]
[null,null,"Gebruikstermijn (hele jaren):",null,null,null,null,null,8,null,10,null,10]
[null,null,"Restwaarde (EUR):",null,null,null,null,null,0,null,8,null,8]
[null,null,"Gemiddeld verbruik (per 100 km):",null,null,null,null,null,25,null,100,null,100,null,null,null,null,null,null,null,null,null,null,null,null,"CO2:","ton",null,"NOx:",null,"kg",null,"PM:",null,"dag",null,"dBh×10^:",null,null,null,4]
[null,null,"Onderhoud (EUR/jaar):",null,null,null,null,null,0,null,0,null,0]
[null,null,"Verzekeringen (EUR/jaar):",null,null,null,null,null,0,null,0,null,0]
[null,null,"Voertuigbelasting (EUR/jaar):",null,null,null,null,{"$f":"IF(-I120>I96,\"→\",\"\")","v":""},0,{"$f":"IF(OR(Switch_Alt1=0,K96=\"\"),\"\",IF(-K120>K96,\"→\",\"\"))","v":""},0,{"$f":"IF(OR(Switch_Alt2=0,M96=\"\"),\"\",IF(-M120>M96,\"→\",\"\"))","v":""},0]
[null,null,"Overige kosten (EUR/jaar):",null,null,null,null,{"$f":"IF(-I121>I97,\"→\",\"\")","v":""},0,{"$f":"IF(OR(Switch_Alt1=0,K97=\"\"),\"\",IF(-K121>K97,\"→\",\"\"))","v":""},0,{"$f":"IF(OR(Switch_Alt2=0,M97=\"\"),\"\",IF(-M121>M97,\"→\",\"\"))","v":""},0]
[null,null,"Kosten ontheffingen:",null,null,null,null,{"$f":"IF(-I122>I98,\"→\",\"\")","v":""},0,{"$f":"IF(OR(Switch_Alt1=0,K98=\"\"),\"\",IF(-K122>K98,\"→\",\"\"))","v":""},0,{"$f":"IF(OR(Switch_Alt2=0,M98=\"\"),\"\",IF(-M122>M98,\"→\",\"\"))","v":""},0]
[null,null,{"$f":"U63&\" emissie CO2 (kg/eenheid brandstof):\"","v":"WtW emissie CO2 (kg/eenheid brandstof):"},null,null,null,null,null,3.23,null,0,null,0]
[null,null,{"$f":"U64&\" emissie NOx (g/eenheid brandstof):\"","v":"TtW emissie NOx (g/eenheid brandstof):"},null,null,null,null,null,2.0609999999999999,null,0,null,0]
[null,null,{"$f":"U65&\" emissie PM (g/eenheid brandstof):\"","v":"TtW emissie PM (g/eenheid brandstof):"},null,null,null,null,null,0.35699999999999998,null,7.8E-2,null,7.8E-2]
[null,null,"Gemiddelde emissie geluid (dBA):",null,null,null,null,null,78,null,70,null,70]
[]
[null,null,"(Nieuwe) voertuigprofielnaam:"]
[null,null,"Aantal vrije voertuigprofielen in categorie:",null,null,null,null,null,{"$f":"COUNTIF(Voertuig_Name2,I3)","v":9},null,{"$f":"COUNTIF(Voertuig_Name,K3)","v":9},null,{"$f":"COUNTIF(Voertuig_Name,M3)","v":9}]
[null,null,"UPDATE / BEWAAR VOERTUIGPROFIEL →"]
[null,null,"BRANDSTOFSPECIFICATIE",null,null,null,null,null,"Referentie",null,"Alternatief 1",null,"Alternatief 2"]
[null,null,"Brandstofsoort",null,null,null,null,null,{"$f":"IFERROR(HLOOKUP(Referentie,Brandstofprofielen,3,FALSE),\"n.v.t.\")","v":"Diesel"},null,{"$f":"IFERROR(HLOOKUP(Alternatief1,Brandstofprofielen,3,FALSE),\"n.v.t.\")","v":"Elektr"},null,{"$f":"IFERROR(HLOOKUP(Alternatief2,Brandstofprofielen,3,FALSE),\"n.v.t.\")","v":"Elektr"}]
[null,null,"Brandstofprijs (EUR per eenheid):",null,null,null,null,{"$f":"IF(-I123>I109,\"→\",\"\")","v":""},1,{"$f":"IF(OR(Switch_Alt1=0,K109=\"\"),\"\",IF(-K123>K109,\"→\",\"\"))","v":""},0.1,{"$f":"IF(OR(Switch_Alt2=0,M109=\"\"),\"\",IF(-M123>M109,\"→\",\"\"))","v":""},0.1]
[null,null,"UPDATE / BEWAAR BRANDSTOFPRIJS →"]
[]
[null,null,"MAATREGELEN BEZIT",null,null,null,null,null,"Referentie",null,"Alternatief 1",null,"Alternatief 2"]
[null,null,"MIA (%):",null,null,null,null,null,0,null,0,null,0,null,null,"OUTPUT IN KERNCIJFERS EN RATIO'S",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"INPUT: ALGEMENE PARAMETERS"]
[null,null,"Vamil (%):",null,null,null,null,null,0,null,0,null,0,null,null,null,null,null,null,null,"Referentie",null,"Alternatief 1",null,null,"Alternatief 2"]
[null,null,"Investeringssubsidie (% aanschafprijs):",null,null,null,null,null,0,null,0,null,0,null,null,null,{"$f":"BE12&\" \"&Eenheid","v":"Personeelskosten (EUR/uur):"},null,null,null,{"$f":"BG12","v":25},null,{"$f":"IF(Switch_Alt1=0,\"n.v.t.\",BH12)","v":25},null,null,{"$f":"IF(Switch_Alt2=0,\"n.v.t.\",BI12)","v":25},null,null,null,null,null,null,null,null,"Gem. aantal personen/voertuig:",null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Afschrijving (EUR/uur):",null,null,null,3.13,null,5,null,null,5,null,null,null,null,null,null,null,null,"Indirecte tijd (minuten/km):",null,null,null,null,null,null,null,null,{"$f":"IF(S54>0,\"→\",\"\")","v":""},{"$f":"60*(G79-Referentie!J26)/G75","v":2.0000000000000004}]
[null,null,"MAATREGELEN GEBRUIK",null,null,null,null,null,"Referentie",null,"Alternatief 1",null,"Alternatief 2",null,null,null,"Brandstofkosten (EUR/uur):",null,null,null,2.5,null,1,null,null,1.2,null,null,null,null,null,null,null,null,"Arbeidskosten (EUR/uur):",null,null,null,null,null,null,null,null,null,25]
[null,null,"Inzet","Inzet APV-gebied buiten APV-tijden (%):",null,null,null,null,{"$f":"G78","v":0},null,0,null,1,null,null,null,"Rente (EUR/uur):",null,null,null,0.35,null,0.68,null,null,0.68,null,null,null,null,null,null,null,null,"Effectieve VpB (%):",null,null,null,null,null,null,null,null,null,0.25]
[null,null,null,"Aantal voertuiguren per jaar (uren):",null,null,null,null,{"$f":"G79","v":2000},{"$f":"IF(Switch_Alt1=0,\"\",IF(K119=0,\"→\",\"\"))","v":""},2000,{"$f":"IF(Switch_Alt2=0,\"\",IF(M119=0,\"→\",\"\"))","v":""},2000,null,null,null,"Onderhoudskosten (EUR/uur):",null,null,null,0,null,0,null,null,0,null,null,null,null,null,null,null,null,"Nominale marktrente (%):",null,null,null,null,null,null,null,null,{"$f":"IF(Rente_nominaal<Inflatie,\"→\",\"\")","v":""},0.04]
[null,null,"Δ Voertuigbelasting (EUR/jaar)",null,null,null,null,{"$f":"IF(-I120>I96,\"→\",\"\")","v":""},0,{"$f":"IF(OR(Switch_Alt1=0,K96=\"\"),\"\",IF(-K120>K96,\"→\",\"\"))","v":""},0,{"$f":"IF(OR(Switch_Alt2=0,M96=\"\"),\"\",IF(-M120>M96,\"→\",\"\"))","v":""},0,null,null,null,"Verzekeringen (EUR/uur):",null,null,null,0,null,0,null,null,0,null,null,null,null,null,null,null,null,"Inflatie (%):",null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(H128,\"→\")+COUNTIF(J128,\"→\")+COUNTIF(L128,\"→\")+COUNTIF(AR119,\"→\")>0,\"→\",\"\")","v":""},1.4999999999999999E-2]
[null,null,"Δ Overige kosten (EUR/jaar):",null,null,null,null,{"$f":"IF(-I121>I97,\"→\",\"\")","v":""},0,{"$f":"IF(OR(Switch_Alt1=0,K97=\"\"),\"\",IF(-K121>K97,\"→\",\"\"))","v":""},0,{"$f":"IF(OR(Switch_Alt2=0,M97=\"\"),\"\",IF(-M121>M97,\"→\",\"\"))","v":""},0,null,null,null,"Voertuigbelastingen (EUR/uur):",null,null,null,0,null,0,null,null,0,null,null,null,null,null,null,null,null,"Maatsch. kosten CO2 (EUR/ton):",null,null,null,null,null,null,null,null,null,26]
[null,null,"Δ Kosten ontheffingen (EUR/jaar):",null,null,null,null,{"$f":"IF(-I122>I98,\"→\",\"\")","v":""},0,{"$f":"IF(OR(Switch_Alt1=0,K98=\"\"),\"\",IF(-K122>K98,\"→\",\"\"))","v":""},0,{"$f":"IF(OR(Switch_Alt2=0,M98=\"\"),\"\",IF(-M122>M98,\"→\",\"\"))","v":""},0,null,null,null,"Overige kosten (EUR/uur):",null,null,null,0,null,0,null,null,0,null,null,null,null,null,null,null,null,"Maatsch. kosten NOx (EUR/kg):",null,null,null,null,null,null,null,null,null,11]
[null,null,"Δ Brandstofprijs (EUR per eenheid):",null,null,null,null,{"$f":"IF(-I123>I109,\"→\",\"\")","v":""},0,{"$f":"IF(OR(Switch_Alt1=0,K109=\"\"),\"\",IF(-K123>K109,\"→\",\"\"))","v":""},0,{"$f":"IF(OR(Switch_Alt2=0,M123=\"\"),\"\",IF(-M123>M109,\"→\",\"\"))","v":""},0,null,null,null,"Ontheffingen (EUR/uur):",null,null,null,0,null,0,null,null,0,null,null,null,null,null,null,null,null,"Maatsch. kosten PM (EUR/kg):",null,null,null,null,null,null,null,null,null,585]
[null,null,"Exploitatiesubsidie (EUR):",null,null,null,null,null,0,null,0,null,0,null,null,null,{"$f":"\"Totale kritische distributiekosten \"&Eenheid","v":"Totale kritische distributiekosten (EUR/uur):"},null,null,null,{"$f":"SUM(U115:U123)","v":30.98},null,{"$f":"IF(Switch_Alt1=0,\"n.v.t.\",SUM(W115:W123))","v":31.68},null,null,{"$f":"IF(Switch_Alt2=0,\"n.v.t.\",SUM(Z115:Z123))","v":31.88},null,null,null,null,null,null,null,null,"Maatsch. kn geluid (eurocent/km):",null,null,null,null,null,null,null,null,null,{"$f":"4.3","v":4.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reëel emissierendem. nieuwe maatregelen (%):",null,null,null,"n.v.t.",null,{"$f":"IF(Switch_Alt1=0,\"n.v.t.\",IFERROR('Alternatief 1'!H130/-'Alternatief 1'!H129,\"n.v.t.\"))","v":"n.v.t."},null,null,{"$f":"IF(Switch_Alt2=0,\"n.v.t.\",IFERROR('Alternatief 2'!H130/-'Alternatief 2'!H129,\"n.v.t.\"))","v":"n.v.t."},null,null,null,null,null,null,null,null,"Snelheid tijdens APV-tijden (km/u):",null,null,null,null,null,null,null,null,null,15]
[null,null,"MAATREGELEN FINANCIERING",null,null,null,null,null,"Referentie",null,"Alternatief 1",null,"Alternatief 2",null,null,null,"IRR emissierendem. nieuwe maatregelen (%):",null,null,null,"n.v.t.",null,{"$f":"IF(Switch_Alt1=0,\"n.v.t.\",'Alternatief 1'!E130)","v":"n.v.t."},null,null,{"$f":"IF(Switch_Alt2=0,\"n.v.t.\",'Alternatief 2'!E130)","v":"n.v.t."},null,null,null,null,null,null,null,null,"Snelheid overig (km/u):",null,null,null,null,null,null,null,null,null,20]
[null,null,"Zachte leningen (% financieringsbehoefte):",null,null,null,null,null,0,null,0,null,0,null,null,null,"Inzet voertuig",null,"afstand (km):",null,{"$f":"Inzet_voertuig_Ref","v":20000},null,{"$f":"IF(Switch_Alt1=0,\"n.v.t.\",Inzet_voertuig_Alt1)","v":20000},null,null,{"$f":"IF(Switch_Alt2=0,\"n.v.t.\",Inzet_voertuig_Alt2)","v":23999.999999999996},null,null,null,null,null,null,null,null,"Reële maatsch. discontovoet (%):",null,null,null,null,null,null,null,null,null,0.04]
[null,null,"Rente op zachte leningen (%):",null,null,null,null,{"$f":"IF(AND(I127>0,I128<Inflatie),\"→\",\"\")","v":""},0,{"$f":"IF(Switch_Alt1=0,\"\",IF(AND(K127>0,K128<Inflatie),\"→\",\"\"))","v":""},0,{"$f":"IF(Switch_Alt2=0,\"\",IF(AND(M127>0,M128<Inflatie),\"→\",\"\"))","v":""},0,null,null,null,null,null,"tijd (uren):",null,{"$f":"Referentie!H30","v":2000},null,{"$f":"IF(Switch_Alt1=0,\"n.v.t.\",'Alternatief 1'!H30)","v":2000},null,null,{"$f":"IF(Switch_Alt2=0,\"n.v.t.\",'Alternatief 2'!H30)","v":1999.9999999999998}]

{"sheet":"Voertuig_Profielen","index":1,"n_rows":113,"n_cols":22,"rows_kept":113,"cut":false,"hidden":false,"merged":[[84,5,86,5],[37,3,37,4],[61,3,61,4],[85,3,85,4],[74,19,79,22],[43,20,44,21],[1,7,1,8],[1,9,1,10],[1,11,1,12],[36,5,38,5],[60,5,62,5]]}
[]
[null,null,null,null,null,null,null,{"$f":"Profielgroep1","v":"Referentie"},null,{"$f":"Profielgroep2","v":"Alt1"},null,{"$f":"Profielgroep3","v":"Alt2"},null,null,"Dubbeltelling categorienamen"]
[null,null,null,null,null,null,null,"Nummers","Duiding","Nummers","Duiding","Nummers","Duiding",null,{"$f":"Profielgroep1","v":"Referentie"},{"$f":"COUNTIF($O$3:$O$5,O3)","v":1}]
[null,null,null,null,null,null,null,null,"Nieuw Profiel",null,"Nieuw Profiel",null,"Nieuw Profiel",null,{"$f":"Profielgroep2","v":"Alt1"},{"$f":"COUNTIF($O$3:$O$5,O4)","v":1}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Cat1_Nummers,1),\"\")","v":1},{"$f":"IF(H5=\"\",\"\",INDEX(Cat1_Duiding,1,MATCH(H5,Cat1_Nummers,FALSE)))","v":"EUR6"},{"$f":"IFERROR(SMALL(Cat2_Nummers,1),\"\")","v":1},{"$f":"IF(J5=\"\",\"\",INDEX(Cat2_Duiding,1,MATCH(J5,Cat2_Nummers,FALSE)))","v":"Elek1"},{"$f":"IFERROR(SMALL(Cat3_Nummers,1),\"\")","v":""},{"$f":"IF(L5=\"\",\"\",INDEX(Cat3_Duiding,1,MATCH(L5,Cat3_Nummers,FALSE)))","v":""},null,{"$f":"Profielgroep3","v":"Alt2"},{"$f":"COUNTIF($O$3:$O$5,O5)","v":1}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Cat1_Nummers,2),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat2_Nummers,2),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat3_Nummers,2),\"\")","v":""},"",null,"Fout",{"$f":"COUNTIF(P3:P5,\">1\")","v":0}]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Cat1_Nummers,3),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat2_Nummers,3),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat3_Nummers,3),\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Cat1_Nummers,4),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat2_Nummers,4),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat3_Nummers,4),\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Cat1_Nummers,5),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat2_Nummers,5),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat3_Nummers,5),\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Cat1_Nummers,6),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat2_Nummers,6),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat3_Nummers,6),\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Cat1_Nummers,7),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat2_Nummers,7),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat3_Nummers,7),\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Cat1_Nummers,8),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat2_Nummers,8),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat3_Nummers,8),\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Cat1_Nummers,9),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat2_Nummers,9),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat3_Nummers,9),\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Cat1_Nummers,10),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat2_Nummers,10),\"\")","v":""},"",{"$f":"IFERROR(SMALL(Cat3_Nummers,10),\"\")","v":""},""]
[null,null,null,null,null,null,null,{"$f":"10-COUNTBLANK((H5:H14))+1","v":2},null,{"$f":"10-COUNTBLANK((J5:J14))+1","v":2},null,{"$f":"10-COUNTBLANK((L5:L14))+1","v":1}]
[]
[null,null,null,"Dubbeltelling profielnamen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fout"]
[null,null,null,"Referentie",null,null,null,{"$f":"COUNTIF(Cat1_Duiding,H42)","v":1},0,0,0,0,0,0,0,0,0,null,{"$f":"COUNTIF(H18:Q18,\">1\")","v":0}]
[null,null,null,"Alt1",null,null,null,{"$f":"COUNTIF(Cat2_Duiding,H66)","v":1},0,0,0,0,0,0,0,0,0,null,{"$f":"COUNTIF(H19:Q19,\">1\")","v":0}]
[null,null,null,"Alt2",null,null,null,{"$f":"COUNTIF(Cat3_Duiding,H90)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"COUNTIF(H20:Q20,\">1\")","v":0}]
[]
[null,null,null,"Incomplete profielen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fout"]
[null,null,null,"Referentie",null,{"$f":"COUNTBLANK(Profielgroep1)","v":0},null,{"$f":"IF(AND(COUNTBLANK(H42)=0,COUNTBLANK(H44:H57)>0),1,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTBLANK(Cat1_1)","v":0},{"$f":"SUM(H23:Q23)","v":0}]
[null,null,null,"Alt1",null,{"$f":"COUNTBLANK(Profielgroep2)*(10-COUNTBLANK(Cat2_Duiding))","v":0},null,{"$f":"IF(AND(COUNTBLANK(H66)=0,COUNTBLANK(H68:H81)>0),1,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(H24:Q24)","v":0}]
[null,null,null,"Alt2",null,{"$f":"COUNTBLANK(Profielgroep3)*(10-COUNTBLANK(Cat3_Duiding))","v":0},null,{"$f":"IF(AND(COUNTBLANK(H90)=0,COUNTBLANK(H92:H105)>0),1,0)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(H25:Q25)","v":0}]
[]
[null,null,null,"Check brandstofnaam",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fout"]
[null,null,null,"Referentie",null,null,null,{"$f":"IF(AND(H44<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!H44)=0),1,0)","v":0},{"$f":"IF(AND(I44<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!I44)=0),1,0)","v":0},{"$f":"IF(AND(J44<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!J44)=0),1,0)","v":0},{"$f":"IF(AND(K44<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!K44)=0),1,0)","v":0},{"$f":"IF(AND(L44<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!L44)=0),1,0)","v":0},{"$f":"IF(AND(M44<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!M44)=0),1,0)","v":0},{"$f":"IF(AND(N44<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!N44)=0),1,0)","v":0},{"$f":"IF(AND(O44<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!O44)=0),1,0)","v":0},{"$f":"IF(AND(P44<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!P44)=0),1,0)","v":0},{"$f":"IF(AND(Q44<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!Q44)=0),1,0)","v":0},{"$f":"IF(AND(COUNTIF(Brandstof_Duiding,Voertuig_Profielen!R44)=0),1,0)","v":1},{"$f":"SUM(H28:Q28)","v":0}]
[null,null,null,"Alt1",null,null,null,{"$f":"IF(AND(H68<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!H68)=0),1,0)","v":0},{"$f":"IF(AND(I68<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!I68)=0),1,0)","v":0},{"$f":"IF(AND(J68<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!J68)=0),1,0)","v":0},{"$f":"IF(AND(K68<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!K68)=0),1,0)","v":0},{"$f":"IF(AND(L68<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!L68)=0),1,0)","v":0},{"$f":"IF(AND(M68<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!M68)=0),1,0)","v":0},{"$f":"IF(AND(N68<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!N68)=0),1,0)","v":0},{"$f":"IF(AND(O68<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!O68)=0),1,0)","v":0},{"$f":"IF(AND(P68<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!P68)=0),1,0)","v":0},{"$f":"IF(AND(Q68<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!Q68)=0),1,0)","v":0},null,{"$f":"SUM(H29:Q29)","v":0}]
[null,null,null,"Alt2",null,null,null,{"$f":"IF(AND(H92<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!H92)=0),1,0)","v":0},{"$f":"IF(AND(I92<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!I92)=0),1,0)","v":0},{"$f":"IF(AND(J92<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!J92)=0),1,0)","v":0},{"$f":"IF(AND(K92<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!K92)=0),1,0)","v":0},{"$f":"IF(AND(L92<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!L92)=0),1,0)","v":0},{"$f":"IF(AND(M92<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!M92)=0),1,0)","v":0},{"$f":"IF(AND(N92<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!N92)=0),1,0)","v":0},{"$f":"IF(AND(O92<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!O92)=0),1,0)","v":0},{"$f":"IF(AND(P92<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!P92)=0),1,0)","v":0},{"$f":"IF(AND(Q92<>\"\",COUNTIF(Brandstof_Duiding,Voertuig_Profielen!Q92)=0),1,0)","v":0},null,{"$f":"SUM(H30:Q30)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Referentie",null,null,null,"Referentievoertuigen"]
[]
[null,null,"VERWIJDER PROFIEL→ → →",null,null,null,null,{"$f":"IF(OR(H23=1,H18>1),\"↓         ↓\",\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H42<>\"\",1,\"\")","v":1},{"$f":"IF(I42<>\"\",2,\"\")","v":""},{"$f":"IF(J42<>\"\",3,\"\")","v":""},{"$f":"IF(K42<>\"\",4,\"\")","v":""},{"$f":"IF(L42<>\"\",5,\"\")","v":""},{"$f":"IF(M42<>\"\",6,\"\")","v":""},{"$f":"IF(N42<>\"\",7,\"\")","v":""},{"$f":"IF(O42<>\"\",8,\"\")","v":""},{"$f":"IF(P42<>\"\",9,\"\")","v":""},{"$f":"IF(Q42<>\"\",10,\"\")","v":""}]
[null,null,"Voertuig profielnaam:",null,null,null,null,"EUR6"]
[]
[null,null,{"$f":"Dashboard!C89","v":"Brandstofprofiel:"},null,null,null,null,"DSL1",null,null,null,null,null,null,null,null,null,null,null,null,"Type Emissie:"]
[null,null,{"$f":"Dashboard!C90","v":"Aanschafprijs voertuig (EUR):"},null,null,null,null,50000]
[null,null,{"$f":"Dashboard!C91","v":"Gebruikstermijn (hele jaren):"},null,null,null,null,8,null,null,null,null,null,null,null,null,null,null,null,null,"CO2:","Well-to-Wheel (WtW)"]
[null,null,{"$f":"Dashboard!C92","v":"Restwaarde (EUR):"},null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,"NOx:","Tank-to-Wheel (TtW)"]
[null,null,{"$f":"Dashboard!C93","v":"Gemiddeld verbruik (per 100 km):"},null,null,null,null,25,null,null,null,null,null,null,null,null,null,null,null,null,"PM:","Tank-to-Wheel (TtW)"]
[null,null,{"$f":"Dashboard!C94","v":"Onderhoud (EUR/jaar):"},null,null,null,null,0]
[null,null,{"$f":"Dashboard!C95","v":"Verzekeringen (EUR/jaar):"},null,null,null,null,0]
[null,null,{"$f":"Dashboard!C96","v":"Voertuigbelasting (EUR/jaar):"},null,null,null,null,0]
[null,null,{"$f":"Dashboard!C97","v":"Overige kosten (EUR/jaar):"},null,null,null,null,0]
[null,null,{"$f":"Dashboard!C98","v":"Kosten ontheffingen:"},null,null,null,null,0]
[null,null,{"$f":"Dashboard!C99","v":"WtW emissie CO2 (kg/eenheid brandstof):"},null,null,null,null,3.23]
[null,null,{"$f":"Dashboard!C100","v":"TtW emissie NOx (g/eenheid brandstof):"},null,null,null,null,2.0609999999999999]
[null,null,{"$f":"Dashboard!C101","v":"TtW emissie PM (g/eenheid brandstof):"},null,null,null,null,0.35699999999999998]
[null,null,{"$f":"Dashboard!C102","v":"Gemiddelde emissie geluid (dBA):"},null,null,null,null,78]
[null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,3]
[]
[null,null,null,null,null,"❶"]
[null,null,null,"Alt1",null,null,null,"Alternatieve voertuigen 1"]
[]
[null,null,"VERWIJDER PROFIEL→ → →",null,null,null,null,{"$f":"IF(OR(H24=1,H19>1),\"↓         ↓\",\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H66<>\"\",1,\"\")","v":1},{"$f":"IF(I66<>\"\",2,\"\")","v":""},{"$f":"IF(J66<>\"\",3,\"\")","v":""},{"$f":"IF(K66<>\"\",4,\"\")","v":""},{"$f":"IF(L66<>\"\",5,\"\")","v":""},{"$f":"IF(M66<>\"\",6,\"\")","v":""},{"$f":"IF(N66<>\"\",7,\"\")","v":""},{"$f":"IF(O66<>\"\",8,\"\")","v":""},{"$f":"IF(P66<>\"\",9,\"\")","v":""},{"$f":"IF(Q66<>\"\",10,\"\")","v":""}]
[null,null,"Voertuig profielnaam:",null,null,null,null,"Elek1"]
[]
[null,null,{"$f":"C44","v":"Brandstofprofiel:"},null,null,null,null,"Elek"]
[null,null,"Aanschafprijs voertuig (EUR):",null,null,null,null,100000,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(G60,\"←\")+COUNTIF(G88,\"←\")>0,\"ERRORS DETECTED!\nCheck marked fields\",\"\")","v":""}]
[null,null,"Gebruikstermijn (hele jaren):",null,null,null,null,10]
[null,null,"Restwaarde (EUR):",null,null,null,null,8]
[null,null,"Gemiddeld verbruik (per 100 km):",null,null,null,null,100]
[null,null,"Onderhoud (EUR/jaar):",null,null,null,null,0]
[null,null,"Verzekeringen (EUR/jaar):",null,null,null,null,0]
[null,null,"Voertuigbelasting (EUR/jaar):",null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P6>0,\"DE CATEGORIENAMEN ZIJN NIET UNIEK! WIJZIG EEN OF MEER NAMEN\",IF(SUM(F23:F25)>0,\"VOORZIE DE GEMARKEERDE CATEGORIEËN VAN EEN NAAM\",IF(SUM(S18:S20)>0,\"NIET-UNIEKE PROFIELNAMEN!\nCheck de gemarkeerde profielen en pas een of meer namen aan.\",IF(SUM(S23:S25)>0,\"ER ZIJN INCOMPLETE PROFIELEN!\nZorg dat alle velden van de met oranje pijlen gemarkeerde profielen ingevuld zijn!\",IF(SUM(S28:S30)<>0,\"NIET BESTAANDE BRANDSTOFPROFIELEN!\nVoorzie de gemarkeerde velden van een bestaand brandstofprofiel.\",\"Status: OK\")))))","v":"Status: OK"}]
[null,null,"Overige kosten (EUR/jaar):",null,null,null,null,0]
[null,null,"Kosten ontheffingen:",null,null,null,null,0]
[null,null,"WtW emissie CO2 (kg/eenheid brandstof):",null,null,null,null,0]
[null,null,"TtW emissie NOx (g/eenheid brandstof):",null,null,null,null,0]
[null,null,"TtW emissie PM (g/eenheid brandstof):",null,null,null,null,7.8E-2]
[null,null,"Gemiddelde emissie geluid (dBA):",null,null,null,null,70]
[null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,"❷"]
[null,null,null,"Alt2",null,null,null,"Alternatieve voertuigen 2"]
[]
[null,null,"VERWIJDER PROFIEL→ → →",null,null,null,null,{"$f":"IF(OR(H25=1,H20>1),\"↓         ↓\",\"\")","v":""},"","","","","","","","",""]
[null,null,null,null,null,null,null,{"$f":"IF(H90<>\"\",1,\"\")","v":""},{"$f":"IF(I90<>\"\",2,\"\")","v":""},{"$f":"IF(J90<>\"\",3,\"\")","v":""},{"$f":"IF(K90<>\"\",4,\"\")","v":""},{"$f":"IF(L90<>\"\",5,\"\")","v":""},{"$f":"IF(M90<>\"\",6,\"\")","v":""},{"$f":"IF(N90<>\"\",7,\"\")","v":""},{"$f":"IF(O90<>\"\",8,\"\")","v":""},{"$f":"IF(P90<>\"\",9,\"\")","v":""},{"$f":"IF(Q90<>\"\",10,\"\")","v":""}]
[null,null,"Voertuig profielnaam:"]
[]
[null,null,{"$f":"C44","v":"Brandstofprofiel:"}]
[null,null,"Aanschafprijs voertuig (EUR):"]
[null,null,"Gebruikstermijn (hele jaren):"]
[null,null,"Restwaarde (EUR):"]
[null,null,"Gemiddeld verbruik (per 100 km):"]
[null,null,"Onderhoud (EUR/jaar):"]
[null,null,"Verzekeringen (EUR/jaar):"]
[null,null,"Voertuigbelasting (EUR/jaar):"]
[null,null,"Overige kosten (EUR/jaar):"]
[null,null,"Kosten ontheffingen:"]
[null,null,"WtW emissie CO2 (kg/eenheid brandstof):"]
[null,null,"TtW emissie NOx (g/eenheid brandstof):"]
[null,null,"TtW emissie PM (g/eenheid brandstof):"]
[null,null,"Gemiddelde emissie geluid (dBA):"]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,"u"]
[null,null,null,null,null,null,null,null,null,null,"u"]
[null,null,null,null,null,null,null,null,null,null,"u"]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,null,{"$error":"#REF!"}]

{"sheet":"Brandstof_Profielen","index":2,"n_rows":33,"n_cols":19,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,8,1,9],[30,18,33,19]]}
[]
[null,null,null,null,null,null,"Verbruikseenheid",null,"Brandstofsoorten"]
[null,null,null,null,null,null,"kilogram",null,"Nummers","Duiding"]
[null,null,null,null,null,null,"liter",null,{"$f":"IFERROR(SMALL(Brandstof_Nummers,1),\"\")","v":1},{"$f":"IF(I4=\"\",\"\",INDEX(Brandstof_Duiding,1,MATCH(I4,Brandstof_Nummers,FALSE)))","v":"DSL1"}]
[null,null,null,null,null,null,"kWh",null,{"$f":"IFERROR(SMALL(Brandstof_Nummers,2),\"\")","v":2},"Elek"]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Brandstof_Nummers,3),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Brandstof_Nummers,4),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Brandstof_Nummers,5),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Brandstof_Nummers,6),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Brandstof_Nummers,7),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Brandstof_Nummers,8),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Brandstof_Nummers,9),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(SMALL(Brandstof_Nummers,10),\"\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"10-COUNTBLANK((I4:I13))","v":2}]
[]
[null,null,null,"Fouten",null,null,null,null,null,null,null,null,null,null,null,null,null,"FOUT"]
[null,null,null,"Dubbeltelling",null,null,{"$f":"COUNTIF(Brandstof_Duiding,G29)","v":1},1,0,0,0,0,0,0,0,0,null,{"$f":"COUNTIF(G17:P17,\">1\")","v":0}]
[null,null,null,"Incompleet",null,null,{"$f":"IF(AND(COUNTBLANK(G29)=0,COUNTBLANK(G31:G33)>0),1,0)","v":0},{"$f":"IF(AND(COUNTBLANK(H29)=0,COUNTBLANK(H31:H33)>0),1,0)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"SUM(G18:P18)","v":0}]
[]
[]
[]
[]
[]
[]
[null,null,null,"Brandstofprofielen"]
[]
[null,null,null,"VERWIJDER PROFIEL→ → →",null,null,{"$f":"IF(OR(G18=1,G17>1),\"â  â\",\"\")","v":""},{"$f":"IF(OR(H18=1,H17>1),\"â  â\",\"\")","v":""},"","","","","","","",""]
[null,null,null,null,null,null,{"$f":"IF(G31<>\"\",1,\"\")","v":1},{"$f":"IF(H31<>\"\",2,\"\")","v":2},{"$f":"IF(I31<>\"\",3,\"\")","v":""},{"$f":"IF(J31<>\"\",4,\"\")","v":""},{"$f":"IF(K31<>\"\",5,\"\")","v":""},{"$f":"IF(L31<>\"\",6,\"\")","v":""},{"$f":"IF(M31<>\"\",7,\"\")","v":""},{"$f":"IF(N31<>\"\",8,\"\")","v":""},{"$f":"IF(O31<>\"\",9,\"\")","v":""},{"$f":"IF(P31<>\"\",10,\"\")","v":""}]
[null,null,null,"Brandstof profielnaam:",null,null,"DSL1","Elek"]
[]
[null,null,null,"Brandstofsoort:",null,null,"Diesel","Elektr",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R17>0,\"NIET-UNIEKE PROFIELNAMEN!\nCheck de met gele pijlen gemarkeerde profielen en pas een of meer namen aan.\",IF(R18>0,\"ER ZIJN INCOMPLETE PROFIELEN!\nZorg dat alle velden van de met oranje pijlen gemarkeerde profielen ingevuld zijn!\",\"Status: OK\"))","v":"Status: OK"}]
[null,null,null,"Verbruikseenheid:",null,null,"liter","kWh"]
[null,null,null,"Brandstofprijs (EUR/eenheid):",null,null,1,0.1]

{"sheet":"Referentie","index":3,"n_rows":108,"n_cols":24,"rows_kept":108,"cut":false,"hidden":false,"merged":[[16,1,16,4],[16,8,16,23]]}
[]
[null,null,null,null,null,null,null,null,{"$f":"I19","v":0},{"$f":"J19","v":1},2,3,4,5,6,7,8,9,10,{"$f":"T19","v":11},{"$f":"U19","v":12},{"$f":"V19","v":13},{"$f":"W19","v":14},{"$f":"X19","v":15}]
[]
[null,"Jaar meetellen regulier",null,null,null,null,null,null,1,{"$f":"IF(J2<=Dashboard!$I91,1,0)","v":1},{"$f":"IF(K2<=Dashboard!$I91,1,0)","v":1},{"$f":"IF(L2<=Dashboard!$I91,1,0)","v":1},{"$f":"IF(M2<=Dashboard!$I91,1,0)","v":1},{"$f":"IF(N2<=Dashboard!$I91,1,0)","v":1},{"$f":"IF(O2<=Dashboard!$I91,1,0)","v":1},{"$f":"IF(P2<=Dashboard!$I91,1,0)","v":1},{"$f":"IF(Q2<=Dashboard!$I91,1,0)","v":1},{"$f":"IF(R2<=Dashboard!$I91,1,0)","v":0},{"$f":"IF(S2<=Dashboard!$I91,1,0)","v":0},{"$f":"IF(T2<=Dashboard!$I91,1,0)","v":0},{"$f":"IF(U2<=Dashboard!$I91,1,0)","v":0},{"$f":"IF(V2<=Dashboard!$I91,1,0)","v":0},{"$f":"IF(W2<=Dashboard!$I91,1,0)","v":0},{"$f":"IF(X2<=Dashboard!$I91,1,0)","v":0}]
[null,"Jaar metellen financieringen",null,null,null,null,null,null,{"$f":"IF(I6=1,0,I4)","v":1},1,1,1,1,1,1,1,0,0,0,0,0,0,0,0]
[null,"Laatste jaar",null,null,null,null,null,null,{"$f":"IF(AND(I4=1,J4=0),1,0)","v":0},0,0,0,0,0,0,0,1,0,0,0,0,0,0,0]
[null,"Inzet voertuig",null,null,null,null,null,null,null,{"$f":"J4","v":1},{"$f":"K4","v":1},1,1,1,1,1,1,0,0,0,0,0,0,0]
[]
[null,"Bedrijfseconomische afschrijving",null,null,null,null,null,null,0,{"$f":"IFERROR(1/Dashboard!$I91*J4,0)","v":0.125},{"$f":"IFERROR(1/Dashboard!$I91*K4,0)","v":0.125},{"$f":"IFERROR(1/Dashboard!$I91*L4,0)","v":0.125},{"$f":"IFERROR(1/Dashboard!$I91*M4,0)","v":0.125},{"$f":"IFERROR(1/Dashboard!$I91*N4,0)","v":0.125},{"$f":"IFERROR(1/Dashboard!$I91*O4,0)","v":0.125},{"$f":"IFERROR(1/Dashboard!$I91*P4,0)","v":0.125},{"$f":"IFERROR(1/Dashboard!$I91*Q4,0)","v":0.125},{"$f":"IFERROR(1/Dashboard!$I91*R4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$I91*S4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$I91*T4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$I91*U4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$I91*V4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$I91*W4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$I91*X4,0)","v":0}]
[null,"Fiscale afschrijving",null,null,null,null,null,null,{"$f":"MAX(Dashboard!I114,Referentie!I9)","v":0},{"$f":"IFERROR((1-I10)/SUM(J4:W4)*J4,0)","v":0.125},{"$f":"J10*K4","v":0.125},0.125,0.125,0.125,0.125,0.125,0.125,0,0,0,0,0,0,0]
[]
[null,"Aantal referentievoertuigen voor vergelijking",null,null,null,null,null,null,"n.v.t."]
[]
[]
[null,null,null,null,null,null,null,null,null,"SPECIFICATIE REFERENTIE"]
[]
[null,{"$f":"IF(Referentie_Naam=\"\",\"\",Referentie_Naam)","v":"EUR6"},null,null,null,null,null,null,{"$f":"IF(SUM(Dashboard!S53:S62)>0,\"Dit overzicht is mogelijk niet correct als gevolg van incomplete of foutieve invoer, check de foutmeldingen op werkblad 'Dashboard'\",\"\")","v":""}]
[]
[null,"Kerndata",null,null,null,null,null,"Totaal",0,1,{"$f":"J19+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Aantal kilometers",null,null,null,null,null,{"$f":"SUM(I21:X21)","v":160000},0,{"$f":"Inzet_voertuig_Ref*J4","v":20000},20000,20000,20000,20000,20000,20000,20000,0,0,0,0,0,0,0]
[null,"- waarvan binnen APV-tijden",null,null,null,null,null,160000,{"$f":"I21*Dashboard!$G76*(1-Dashboard!$I118)","v":0},{"$f":"J21*Dashboard!$G76*(1-Dashboard!$I118)","v":20000},{"$f":"K21*Dashboard!$G76*(1-Dashboard!$I118)","v":20000},{"$f":"L21*Dashboard!$G76*(1-Dashboard!$I118)","v":20000},{"$f":"M21*Dashboard!$G76*(1-Dashboard!$I118)","v":20000},{"$f":"N21*Dashboard!$G76*(1-Dashboard!$I118)","v":20000},{"$f":"O21*Dashboard!$G76*(1-Dashboard!$I118)","v":20000},{"$f":"P21*Dashboard!$G76*(1-Dashboard!$I118)","v":20000},{"$f":"Q21*Dashboard!$G76*(1-Dashboard!$I118)","v":20000},{"$f":"R21*Dashboard!$G76*(1-Dashboard!$I118)","v":0},{"$f":"S21*Dashboard!$G76*(1-Dashboard!$I118)","v":0},{"$f":"T21*Dashboard!$G76*(1-Dashboard!$I118)","v":0},{"$f":"U21*Dashboard!$G76*(1-Dashboard!$I118)","v":0},{"$f":"V21*Dashboard!$G76*(1-Dashboard!$I118)","v":0},{"$f":"W21*Dashboard!$G76*(1-Dashboard!$I118)","v":0},{"$f":"X21*Dashboard!$G76*(1-Dashboard!$I118)","v":0}]
[null,"- waarvan buiten APV-tijden",null,null,null,null,null,0,{"$f":"I21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"J21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"K21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"L21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"M21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"N21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"O21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"P21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"Q21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"R21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"S21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"T21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"U21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"V21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"W21*Dashboard!$G76*Dashboard!$I118","v":0},{"$f":"X21*Dashboard!$G76*Dashboard!$I118","v":0}]
[null,"- waarvan buiten APV-gebieden",null,null,null,null,null,0,{"$f":"I21*(1-Dashboard!$G76)","v":0},{"$f":"J21*(1-Dashboard!$G76)","v":0},{"$f":"K21*(1-Dashboard!$G76)","v":0},{"$f":"L21*(1-Dashboard!$G76)","v":0},{"$f":"M21*(1-Dashboard!$G76)","v":0},{"$f":"N21*(1-Dashboard!$G76)","v":0},{"$f":"O21*(1-Dashboard!$G76)","v":0},{"$f":"P21*(1-Dashboard!$G76)","v":0},{"$f":"Q21*(1-Dashboard!$G76)","v":0},{"$f":"R21*(1-Dashboard!$G76)","v":0},{"$f":"S21*(1-Dashboard!$G76)","v":0},{"$f":"T21*(1-Dashboard!$G76)","v":0},{"$f":"U21*(1-Dashboard!$G76)","v":0},{"$f":"V21*(1-Dashboard!$G76)","v":0},{"$f":"W21*(1-Dashboard!$G76)","v":0},{"$f":"X21*(1-Dashboard!$G76)","v":0}]
[null,{"$f":"\"Brandstofverbruik (\"&HLOOKUP(Referentie,Brandstofprofielen,4, FALSE)&\")\"","v":"Brandstofverbruik (liter)"},null,null,null,null,null,40000,0,{"$f":"J21/100*Dashboard!$I93","v":5000},{"$f":"K21/100*Dashboard!$I93","v":5000},{"$f":"L21/100*Dashboard!$I93","v":5000},{"$f":"M21/100*Dashboard!$I93","v":5000},{"$f":"N21/100*Dashboard!$I93","v":5000},{"$f":"O21/100*Dashboard!$I93","v":5000},{"$f":"P21/100*Dashboard!$I93","v":5000},{"$f":"Q21/100*Dashboard!$I93","v":5000},{"$f":"R21/100*Dashboard!$I93","v":0},{"$f":"S21/100*Dashboard!$I93","v":0},{"$f":"T21/100*Dashboard!$I93","v":0},{"$f":"U21/100*Dashboard!$I93","v":0},{"$f":"V21/100*Dashboard!$I93","v":0},{"$f":"W21/100*Dashboard!$I93","v":0},{"$f":"X21/100*Dashboard!$I93","v":0}]
[null,"Aantal directe uren chauffeur",null,null,null,null,null,10666.666666666666,{"$f":"I22/Snelheid_Venster+SUM(I23:I24)/Snelheid_Overig","v":0},1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,0,0,0,0,0,0,0]
[null,"Aantal indirecte uren chauffeur",null,null,null,null,null,5333.3333333333348,0,{"$f":"Indirecte_minuten/60*J21","v":666.66666666666674},666.66666666666674,666.66666666666674,666.66666666666674,666.66666666666674,666.66666666666674,666.66666666666674,666.66666666666674,0,0,0,0,0,0,0]
[null,"Aantal uren bijrijder(s)",null,null,null,null,null,0,0,{"$f":"(Bezetting-1)*SUM(J26:J27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Brandstofprijs per \"&Dashboard!I62&\" (EUR)\"","v":"Brandstofprijs per liter (EUR)"},null,null,null,null,null,{"$f":"BrandstofprijsR+Dashboard!I123","v":1}]
[null,"Aantal uren per jaar",null,null,null,null,null,{"$f":"J26+J27","v":2000}]
[]
[null,"Overzicht kosten",null,null,"EUR",null,{"$f":"IF(Per_uur=1,\"Per uur\",\"Per km\")","v":"Per uur"},"Totaal",{"$f":"I19","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Brandstofkosten",null,null,null,null,{"$f":"H34/(Dashboard!I$91*Inzet_voertuig_Ref*Per_km+Dashboard!I$91*Contractuele_uren_Ref*Per_uur)","v":2.5},{"$f":"SUM(I34:X34)","v":40000},0,{"$f":"J25*$H29","v":5000},5000,5000,5000,5000,5000,5000,5000,0,0,0,0,0,0,0]
[null,"Onderhoudskosten",null,null,null,null,{"$f":"H35/(Dashboard!I$91*Inzet_voertuig_Ref*Per_km+Dashboard!I$91*Contractuele_uren_Ref*Per_uur)","v":0},0,0,{"$f":"Dashboard!$I94*J4","v":0},{"$f":"Dashboard!$I94*K4","v":0},{"$f":"Dashboard!$I94*L4","v":0},{"$f":"Dashboard!$I94*M4","v":0},{"$f":"Dashboard!$I94*N4","v":0},{"$f":"Dashboard!$I94*O4","v":0},{"$f":"Dashboard!$I94*P4","v":0},{"$f":"Dashboard!$I94*Q4","v":0},{"$f":"Dashboard!$I94*R4","v":0},{"$f":"Dashboard!$I94*S4","v":0},{"$f":"Dashboard!$I94*T4","v":0},{"$f":"Dashboard!$I94*U4","v":0},{"$f":"Dashboard!$I94*V4","v":0},{"$f":"Dashboard!$I94*W4","v":0},{"$f":"Dashboard!$I94*X4","v":0}]
[null,"Verzekeringen",null,null,null,null,{"$f":"H36/(Dashboard!I$91*Inzet_voertuig_Ref*Per_km+Dashboard!I$91*Contractuele_uren_Ref*Per_uur)","v":0},0,0,{"$f":"Dashboard!$I95*J4","v":0},{"$f":"Dashboard!$I95*K4","v":0},{"$f":"Dashboard!$I95*L4","v":0},{"$f":"Dashboard!$I95*M4","v":0},{"$f":"Dashboard!$I95*N4","v":0},{"$f":"Dashboard!$I95*O4","v":0},{"$f":"Dashboard!$I95*P4","v":0},{"$f":"Dashboard!$I95*Q4","v":0},{"$f":"Dashboard!$I95*R4","v":0},{"$f":"Dashboard!$I95*S4","v":0},{"$f":"Dashboard!$I95*T4","v":0},{"$f":"Dashboard!$I95*U4","v":0},{"$f":"Dashboard!$I95*V4","v":0},{"$f":"Dashboard!$I95*W4","v":0},{"$f":"Dashboard!$I95*X4","v":0}]
[null,"Voertuigbelasting",null,null,null,null,{"$f":"H37/(Dashboard!I$91*Inzet_voertuig_Ref*Per_km+Dashboard!I$91*Contractuele_uren_Ref*Per_uur)","v":0},0,0,{"$f":"(Dashboard!$I96+Dashboard!$I120)*J4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*K4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*L4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*M4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*N4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*O4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*P4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*Q4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*R4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*S4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*T4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*U4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*V4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*W4","v":0},{"$f":"(Dashboard!$I96+Dashboard!$I120)*X4","v":0}]
[null,"Overige kosten",null,null,null,null,{"$f":"H38/(Dashboard!I$91*Inzet_voertuig_Ref*Per_km+Dashboard!I$91*Contractuele_uren_Ref*Per_uur)","v":0},0,0,{"$f":"(Dashboard!$I97+Dashboard!$I121)*J4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*K4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*L4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*M4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*N4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*O4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*P4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*Q4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*R4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*S4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*T4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*U4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*V4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*W4","v":0},{"$f":"(Dashboard!$I97+Dashboard!$I121)*X4","v":0}]
[null,"Kosten ontheffingen",null,null,null,null,{"$f":"H39/(Dashboard!I$91*Inzet_voertuig_Ref*Per_km+Dashboard!I$91*Contractuele_uren_Ref*Per_uur)","v":0},0,0,{"$f":"(Dashboard!$I98+Dashboard!$I122)*J4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*K4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*L4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*M4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*N4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*O4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*P4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*Q4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*R4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*S4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*T4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*U4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*V4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*W4","v":0},{"$f":"(Dashboard!$I98+Dashboard!$I122)*X4","v":0}]
[null,"Personeelskosten",null,null,null,null,{"$f":"H40/(Dashboard!I$91*Inzet_voertuig_Ref*Per_km+Dashboard!I$91*Contractuele_uren_Ref*Per_uur)","v":25},400000,0,{"$f":"SUM(J26:J28)*Uurtarief","v":50000},50000,50000,50000,50000,50000,50000,50000,0,0,0,0,0,0,0]
[null,"Rente",null,null,null,null,{"$f":"H41/(Dashboard!I$91*Inzet_voertuig_Ref*Per_km+Dashboard!I$91*Contractuele_uren_Ref*Per_uur)","v":0.34636699507389274},5541.8719211822836,0,{"$f":"I75*Rente_reeel+I74*zachte_rente_reeelR","v":1231.5270935960632},1077.5862068965553,923.64532019704734,769.70443349753953,615.7635467980316,461.82266009852367,307.8817733990158,153.9408866995079,0,0,0,0,0,0,0]
[null,"Bedrijfseconomische afschrijving",null,null,null,null,{"$f":"H42/(Dashboard!I$91*Inzet_voertuig_Ref*Per_km+Dashboard!I$91*Contractuele_uren_Ref*Per_uur)","v":3.125},50000,0,{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*J4,0)","v":6250},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*K4,0)","v":6250},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*L4,0)","v":6250},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*M4,0)","v":6250},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*N4,0)","v":6250},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*O4,0)","v":6250},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*P4,0)","v":6250},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*Q4,0)","v":6250},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*R4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*S4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*T4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*U4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*V4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*W4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$I92)/Dashboard!$I91*X4,0)","v":0}]
[null,"Totaal Kritische Distributie Kosten",null,null,null,null,{"$f":"SUM(G34:G42)","v":30.971366995073893},495541.87192118238,{"$f":"SUM(I34:I42)","v":0},62481.527093596065,62327.586206896558,62173.645320197051,62019.704433497536,61865.763546798029,61711.822660098522,61557.881773399014,61403.940886699507,0,0,0,0,0,0,0]
[]
[null,"Overzicht kasstromen",null,null,"EUR",null,null,"Totaal",{"$f":"I32","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"negatieve cijfers = cash out, positieve cijfers = cash in"]
[null,"Operationele kasstroom",null,null,null,null,null,{"$f":"SUM(I47:X47)","v":-445541.87192118238},{"$f":"-I43+I42","v":0},-56231.527093596065,-56077.586206896558,-55923.645320197051,-55769.704433497536,-55615.763546798029,{"$f":"-O43+O42","v":-55461.822660098522},-55307.881773399014,-55153.940886699507,0,0,0,0,0,0,0]
[null,"(totaal kritische distributiekosten excl. afschrijving)"]
[]
[null,"Investering in voertuig",null,null,null,null,null,{"$f":"SUM(I50:X50)","v":-50000},{"$f":"-Dashboard!$I$90","v":-50000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Investeringssubsidie",null,null,null,null,null,{"$f":"SUM(I51:X51)","v":0},{"$f":"-Dashboard!$I115*I50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Investering na investeringssubsidie",null,null,null,null,null,{"$f":"SUM(I52:X52)","v":-50000},{"$f":"SUM(I50:I51)","v":-50000},{"$f":"SUM(J50:J51)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Exploitatiesubsidie",null,null,null,null,null,{"$f":"SUM(I53:X53)","v":0},{"$f":"Dashboard!$I124","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Investering na investering- en exploitatiesubsidie",null,null,null,null,null,{"$f":"SUM(I54:X54)","v":-50000},{"$f":"SUM(I52:I53)","v":-50000},{"$f":"SUM(J52:J53)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Kasstroomeffect MIA",null,null,null,null,null,{"$f":"SUM(I56:X56)","v":0},{"$f":"-I52*Dashboard!$I113*VpB","v":0},{"$f":"-J52*Dashboard!$I113*VpB","v":0},{"$f":"-K52*Dashboard!$I113*VpB","v":0},{"$f":"-L52*Dashboard!$I113*VpB","v":0},{"$f":"-M52*Dashboard!$I113*VpB","v":0},{"$f":"-N52*Dashboard!$I113*VpB","v":0},{"$f":"-O52*Dashboard!$I113*VpB","v":0},{"$f":"-P52*Dashboard!$I113*VpB","v":0},{"$f":"-Q52*Dashboard!$I113*VpB","v":0},{"$f":"-R52*Dashboard!$I113*VpB","v":0},{"$f":"-S52*Dashboard!$I113*VpB","v":0},{"$f":"-T52*Dashboard!$I113*VpB","v":0},{"$f":"-U52*Dashboard!$I113*VpB","v":0},{"$f":"-V52*Dashboard!$I113*VpB","v":0},{"$f":"-W52*Dashboard!$I113*VpB","v":0},{"$f":"-X52*Dashboard!$I113*VpB","v":0}]
[null,"Kasstroomeffect VAMIL",null,null,null,null,null,{"$f":"SUM(I57:X57)","v":0},{"$f":"(I10-I9)*-$H52*VpB","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Netto investeringsgerelateerde kassstroom",null,null,null,null,null,{"$f":"SUM(I59:X59)","v":-50000},{"$f":"SUM(I54:I57)","v":-50000},{"$f":"SUM(J54:J57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Opname zachte leningen",null,null,null,null,null,{"$f":"SUM(I61:X61)","v":0},{"$f":"Dashboard!$I127*-I59","v":0},{"$f":"Dashboard!$I127*-J59","v":0},{"$f":"Dashboard!$I127*-K59","v":0},{"$f":"Dashboard!$I127*-L59","v":0},{"$f":"Dashboard!$I127*-M59","v":0},{"$f":"Dashboard!$I127*-N59","v":0},{"$f":"Dashboard!$I127*-O59","v":0},{"$f":"Dashboard!$I127*-P59","v":0},{"$f":"Dashboard!$I127*-Q59","v":0},{"$f":"Dashboard!$I127*-R59","v":0},{"$f":"Dashboard!$I127*-S59","v":0},{"$f":"Dashboard!$I127*-T59","v":0},{"$f":"Dashboard!$I127*-U59","v":0},{"$f":"Dashboard!$I127*-V59","v":0},{"$f":"Dashboard!$I127*-W59","v":0},{"$f":"Dashboard!$I127*-X59","v":0}]
[null,"Opname reguliere leningen",null,null,null,null,null,{"$f":"SUM(I62:X62)","v":50000},{"$f":"(1-Dashboard!$I127)*-I59","v":50000},{"$f":"(1-Dashboard!$I127)*-J59","v":0},{"$f":"(1-Dashboard!$I127)*-K59","v":0},{"$f":"(1-Dashboard!$I127)*-L59","v":0},{"$f":"(1-Dashboard!$I127)*-M59","v":0},{"$f":"(1-Dashboard!$I127)*-N59","v":0},{"$f":"(1-Dashboard!$I127)*-O59","v":0},{"$f":"(1-Dashboard!$I127)*-P59","v":0},{"$f":"(1-Dashboard!$I127)*-Q59","v":0},{"$f":"(1-Dashboard!$I127)*-R59","v":0},{"$f":"(1-Dashboard!$I127)*-S59","v":0},{"$f":"(1-Dashboard!$I127)*-T59","v":0},{"$f":"(1-Dashboard!$I127)*-U59","v":0},{"$f":"(1-Dashboard!$I127)*-V59","v":0},{"$f":"(1-Dashboard!$I127)*-W59","v":0},{"$f":"(1-Dashboard!$I127)*-X59","v":0}]
[null,"Aflossing reguliere leningen",null,null,null,null,null,{"$f":"SUM(I63:X63)","v":-50000},0,{"$f":"IFERROR((-I75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(J4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*J6-J62*J6,0)","v":-6250},{"$f":"IFERROR((-J75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(K4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*K6-K62*K6,0)","v":-6250},{"$f":"IFERROR((-K75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(L4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*L6-L62*L6,0)","v":-6250},{"$f":"IFERROR((-L75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(M4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*M6-M62*M6,0)","v":-6250},{"$f":"IFERROR((-M75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(N4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*N6-N62*N6,0)","v":-6250},{"$f":"IFERROR((-N75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(O4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*O6-O62*O6,0)","v":-6250},{"$f":"IFERROR((-O75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(P4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*P6-P62*P6,0)","v":-6250},{"$f":"IFERROR((-P75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(Q4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*Q6-Q62*Q6,0)","v":-6250},{"$f":"IFERROR((-Q75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(R4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*R6-R62*R6,0)","v":0},{"$f":"IFERROR((-R75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(S4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*S6-S62*S6,0)","v":0},{"$f":"IFERROR((-S75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(T4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*T6-T62*T6,0)","v":0},{"$f":"IFERROR((-T75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(U4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*U6-U62*U6,0)","v":0},{"$f":"IFERROR((-U75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(V4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*V6-V62*V6,0)","v":0},{"$f":"IFERROR((-V75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(W4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*W6-W62*W6,0)","v":0},{"$f":"IFERROR((-W75+(1-Dashboard!$I127)*Dashboard!$I92)/SUM(X4:$X4)+(1-Dashboard!$I127)*-Dashboard!$I92*X6-X62*X6,0)","v":0}]
[null,"Aflossing zachte leningen",null,null,null,null,null,{"$f":"SUM(I64:X64)","v":0},0,{"$f":"IFERROR((-I74+(Dashboard!$I127)*Dashboard!$I92)/SUM(J4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*J6-J61*J6,0)","v":0},{"$f":"IFERROR((-J74+(Dashboard!$I127)*Dashboard!$I92)/SUM(K4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*K6-K61*K6,0)","v":0},{"$f":"IFERROR((-K74+(Dashboard!$I127)*Dashboard!$I92)/SUM(L4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*L6-L61*L6,0)","v":0},{"$f":"IFERROR((-L74+(Dashboard!$I127)*Dashboard!$I92)/SUM(M4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*M6-M61*M6,0)","v":0},{"$f":"IFERROR((-M74+(Dashboard!$I127)*Dashboard!$I92)/SUM(N4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*N6-N61*N6,0)","v":0},{"$f":"IFERROR((-N74+(Dashboard!$I127)*Dashboard!$I92)/SUM(O4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*O6-O61*O6,0)","v":0},{"$f":"IFERROR((-O74+(Dashboard!$I127)*Dashboard!$I92)/SUM(P4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*P6-P61*P6,0)","v":0},{"$f":"IFERROR((-P74+(Dashboard!$I127)*Dashboard!$I92)/SUM(Q4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*Q6-Q61*Q6,0)","v":0},{"$f":"IFERROR((-Q74+(Dashboard!$I127)*Dashboard!$I92)/SUM(R4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*R6-R61*R6,0)","v":0},{"$f":"IFERROR((-R74+(Dashboard!$I127)*Dashboard!$I92)/SUM(S4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*S6-S61*S6,0)","v":0},{"$f":"IFERROR((-S74+(Dashboard!$I127)*Dashboard!$I92)/SUM(T4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*T6-T61*T6,0)","v":0},{"$f":"IFERROR((-T74+(Dashboard!$I127)*Dashboard!$I92)/SUM(U4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*U6-U61*U6,0)","v":0},{"$f":"IFERROR((-U74+(Dashboard!$I127)*Dashboard!$I92)/SUM(V4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*V6-V61*V6,0)","v":0},{"$f":"IFERROR((-V74+(Dashboard!$I127)*Dashboard!$I92)/SUM(W4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*W6-W61*W6,0)","v":0},{"$f":"IFERROR((-W74+(Dashboard!$I127)*Dashboard!$I92)/SUM(X4:$X4)+(Dashboard!$I127)*-Dashboard!$I92*X6-X61*X6,0)","v":0}]
[]
[null,"Financieringskasstroom",null,null,null,null,null,{"$f":"SUM(I66:X66)","v":0},{"$f":"SUM(I61:I64)","v":50000},-6250,-6250,-6250,-6250,-6250,{"$f":"SUM(O61:O64)","v":-6250},-6250,-6250,0,0,0,0,0,0,0]
[]
[null,"Totaal Kritische Distributie Kasstroom",null,null,null,null,null,{"$f":"SUM(I68:X68)","v":-495541.87192118238},{"$f":"I47+I59+I66","v":0},-62481.527093596065,-62327.586206896558,-62173.645320197051,-62019.704433497536,-61865.763546798029,-61711.822660098522,-61557.881773399014,-61403.940886699507,0,0,0,0,0,0,0]
[]
[null,"Balanspositie voertuig",null,null,"EUR",null,null,null,{"$f":"I32","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Hoofdvoertuig (boekwaarde)",null,null,null,null,null,null,{"$f":"(H72-I54-I56-I42)*J4","v":50000},{"$f":"(I72-J54-J56-J42)*K4","v":43750},37500,31250,25000,18750,12500,6250,0,0,0,0,0,0,0,0]
[]
[null,"Zachte leningen",null,null,null,null,null,null,{"$f":"H74+I61+I64","v":0},0,0,0,0,0,{"$f":"N74+O61+O64","v":0},0,0,0,0,0,0,0,0,0]
[null,"Reguliere leningen",null,null,null,null,null,null,{"$f":"H75+I62+I63","v":50000},43750,37500,31250,25000,18750,{"$f":"N75+O62+O63","v":12500},6250,0,0,0,0,0,0,0,0]
[null,"Totaal leningen",null,null,null,null,null,null,{"$f":"SUM(I74:I75)","v":50000},43750,37500,31250,25000,18750,{"$f":"SUM(O74:O75)","v":12500},6250,0,0,0,0,0,0,0,0]
[]
[null,"Kasstroom maatregelen",null,null,"EUR",null,"Contant","Totaal",{"$f":"I32","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"MIA",null,null,null,null,{"$f":"NPV(Discontovoet,J80:X80)+I80","v":0},{"$f":"SUM(I80:X80)","v":0},{"$f":"I56","v":0},0,0,0,0,0,{"$f":"O56","v":0},0,0,0,0,0,0,0,0,0]
[null,"VAMIL",null,null,null,null,{"$f":"NPV(Discontovoet,J81:X81)+I81","v":0},{"$f":"SUM(I81:X81)","v":0},0,0,0,0,0,0,{"$f":"O57","v":0},0,0,0,0,0,0,0,0,0]
[null,"Kasstroom bestaande maatregelen",null,null,null,null,{"$f":"NPV(Discontovoet,J82:X82)+I82","v":0},{"$f":"SUM(I82:X82)","v":0},{"$f":"SUM(I80:I81)","v":0},{"$f":"SUM(J80:J81)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Subsidies",null,null,null,null,{"$f":"NPV(Discontovoet,J84:X84)+I84","v":0},{"$f":"SUM(I84:X84)","v":0},{"$f":"I51","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Δ Voertuigbelastingen",null,null,null,null,{"$f":"NPV(Discontovoet,J85:X85)+I85","v":0},0,0,{"$f":"-Dashboard!$K120*J7","v":0},{"$f":"-Dashboard!$K120*K7","v":0},{"$f":"-Dashboard!$K120*L7","v":0},{"$f":"-Dashboard!$K120*M7","v":0},{"$f":"-Dashboard!$K120*N7","v":0},{"$f":"-Dashboard!$K120*O7","v":0},{"$f":"-Dashboard!$K120*P7","v":0},{"$f":"-Dashboard!$K120*Q7","v":0},{"$f":"-Dashboard!$K120*R7","v":0},{"$f":"-Dashboard!$K120*S7","v":0},{"$f":"-Dashboard!$K120*T7","v":0},{"$f":"-Dashboard!$K120*U7","v":0},{"$f":"-Dashboard!$K120*V7","v":0},{"$f":"-Dashboard!$K120*W7","v":0},{"$f":"-Dashboard!$K120*X7","v":0}]
[null,"Δ Overige kosten",null,null,null,null,0,0,0,{"$f":"-Dashboard!$K121*J7","v":0},{"$f":"-Dashboard!$K121*K7","v":0},{"$f":"-Dashboard!$K121*L7","v":0},{"$f":"-Dashboard!$K121*M7","v":0},{"$f":"-Dashboard!$K121*N7","v":0},{"$f":"-Dashboard!$K121*O7","v":0},{"$f":"-Dashboard!$K121*P7","v":0},{"$f":"-Dashboard!$K121*Q7","v":0},{"$f":"-Dashboard!$K121*R7","v":0},{"$f":"-Dashboard!$K121*S7","v":0},{"$f":"-Dashboard!$K121*T7","v":0},{"$f":"-Dashboard!$K121*U7","v":0},{"$f":"-Dashboard!$K121*V7","v":0},{"$f":"-Dashboard!$K121*W7","v":0},{"$f":"-Dashboard!$K121*X7","v":0}]
[null,"Δ Kosten ontheffingen",null,null,null,null,{"$f":"NPV(Discontovoet,J87:X87)+I87","v":0},0,{"$f":"-Dashboard!$K122*I7","v":0},{"$f":"-Dashboard!$K122*J7","v":0},{"$f":"-Dashboard!$K122*K7","v":0},{"$f":"-Dashboard!$K122*L7","v":0},{"$f":"-Dashboard!$K122*M7","v":0},{"$f":"-Dashboard!$K122*N7","v":0},{"$f":"-Dashboard!$K122*O7","v":0},{"$f":"-Dashboard!$K122*P7","v":0},{"$f":"-Dashboard!$K122*Q7","v":0},{"$f":"-Dashboard!$K122*R7","v":0},{"$f":"-Dashboard!$K122*S7","v":0},{"$f":"-Dashboard!$K122*T7","v":0},{"$f":"-Dashboard!$K122*U7","v":0},{"$f":"-Dashboard!$K122*V7","v":0},{"$f":"-Dashboard!$K122*W7","v":0},{"$f":"-Dashboard!$K122*X7","v":0}]
[null,"Δ Brandstofprijs",null,null,null,null,0,0,0,{"$f":"-Inzet_voertuig_Ref*J7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*K7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*L7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*M7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*N7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*O7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*P7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*Q7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*R7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*S7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*T7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*U7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*V7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*W7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Ref*X7/100*Dashboard!$K93*Dashboard!$K123","v":0}]
[null,"Rentesubsidies",null,null,null,null,0,0,0,{"$f":"I74*(Rente_reeel-zachte_rente_reeel1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Kasstroom nieuwe maatregelen",null,null,null,null,0,{"$f":"SUM(H84:H89)","v":0},{"$f":"SUM(I84:I89)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Totaal kasstroom maatregelen",null,null,null,null,{"$f":"NPV(Discontovoet,J92:X92)+I92","v":0},{"$f":"SUM(I92:X92)","v":0},{"$f":"I82+I90","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Emissies",null,null,null,null,null,null,null,{"$f":"J32","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Nominaal"]
[]
[null,{"$f":"Dashboard!U63&\" emissie CO2 (\"&CO2_weight&\"/jaar)\"","v":"WtW emissie CO2 (ton/jaar)"},null,null,null,null,null,null,null,{"$f":"IF(J94>Dashboard!$I91,I98*J7,(J21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":16.149999999999999},{"$f":"IF(K94>Dashboard!$I91,J98*K7,(K21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":16.149999999999999},{"$f":"IF(L94>Dashboard!$I91,K98*L7,(L21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":16.149999999999999},{"$f":"IF(M94>Dashboard!$I91,L98*M7,(M21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":16.149999999999999},{"$f":"IF(N94>Dashboard!$I91,M98*N7,(N21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":16.149999999999999},{"$f":"IF(O94>Dashboard!$I91,N98*O7,(O21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":16.149999999999999},{"$f":"IF(P94>Dashboard!$I91,O98*P7,(P21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":16.149999999999999},{"$f":"IF(Q94>Dashboard!$I91,P98*Q7,(Q21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":16.149999999999999},{"$f":"IF(R94>Dashboard!$I91,Q98*R7,(R21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":0},{"$f":"IF(S94>Dashboard!$I91,R98*S7,(S21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":0},{"$f":"IF(T94>Dashboard!$I91,S98*T7,(T21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":0},{"$f":"IF(U94>Dashboard!$I91,T98*U7,(U21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":0},{"$f":"IF(V94>Dashboard!$I91,U98*V7,(V21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":0},{"$f":"IF(W94>Dashboard!$I91,V98*W7,(W21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":0},{"$f":"IF(X94>Dashboard!$I91,W98*X7,(X21/100)*Dashboard!$I93*Dashboard!$I99)*CO2_factor","v":0}]
[null,"Kosten CO2 emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J98*Kosten_CO2*CO2_factor_EUR","v":419.9},419.9,419.9,419.9,419.9,419.9,419.9,419.9,0,0,0,0,0,0,0]
[]
[null,{"$f":"Dashboard!U64&\" emissie NOx (\"&NOx_weight&\"/jaar)\"","v":"TtW emissie NOx (kg/jaar)"},null,null,null,null,null,null,null,{"$f":"IF(J94>Dashboard!$I91,I101*J7,(J21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":10.305},{"$f":"IF(K94>Dashboard!$I91,J101*K7,(K21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":10.305},{"$f":"IF(L94>Dashboard!$I91,K101*L7,(L21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":10.305},{"$f":"IF(M94>Dashboard!$I91,L101*M7,(M21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":10.305},{"$f":"IF(N94>Dashboard!$I91,M101*N7,(N21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":10.305},{"$f":"IF(O94>Dashboard!$I91,N101*O7,(O21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":10.305},{"$f":"IF(P94>Dashboard!$I91,O101*P7,(P21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":10.305},{"$f":"IF(Q94>Dashboard!$I91,P101*Q7,(Q21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":10.305},{"$f":"IF(R94>Dashboard!$I91,Q101*R7,(R21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":0},{"$f":"IF(S94>Dashboard!$I91,R101*S7,(S21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":0},{"$f":"IF(T94>Dashboard!$I91,S101*T7,(T21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":0},{"$f":"IF(U94>Dashboard!$I91,T101*U7,(U21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":0},{"$f":"IF(V94>Dashboard!$I91,U101*V7,(V21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":0},{"$f":"IF(W94>Dashboard!$I91,V101*W7,(W21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":0},{"$f":"IF(X94>Dashboard!$I91,W101*X7,(X21/100)*Dashboard!$I93*Dashboard!$I100)*NOx_factor","v":0}]
[null,"Kosten NOx emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J101*Kosten_NOx*NOx_factor_EUR","v":113.35499999999999},113.35499999999999,113.35499999999999,113.35499999999999,113.35499999999999,113.35499999999999,113.35499999999999,113.35499999999999,0,0,0,0,0,0,0]
[]
[null,{"$f":"Dashboard!U65&\" emissie PM (\"&PM_weight&\"/jaar)\"","v":"TtW emissie PM (dag/jaar)"},null,null,null,null,null,null,null,{"$f":"IF(J94>Dashboard!$I91,I104*J7,(J21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":178.5},{"$f":"IF(K94>Dashboard!$I91,J104*K7,(K21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":178.5},{"$f":"IF(L94>Dashboard!$I91,K104*L7,(L21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":178.5},{"$f":"IF(M94>Dashboard!$I91,L104*M7,(M21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":178.5},{"$f":"IF(N94>Dashboard!$I91,M104*N7,(N21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":178.5},{"$f":"IF(O94>Dashboard!$I91,N104*O7,(O21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":178.5},{"$f":"IF(P94>Dashboard!$I91,O104*P7,(P21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":178.5},{"$f":"IF(Q94>Dashboard!$I91,P104*Q7,(Q21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":178.5},{"$f":"IF(R94>Dashboard!$I91,Q104*R7,(R21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":0},{"$f":"IF(S94>Dashboard!$I91,R104*S7,(S21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":0},{"$f":"IF(T94>Dashboard!$I91,S104*T7,(T21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":0},{"$f":"IF(U94>Dashboard!$I91,T104*U7,(U21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":0},{"$f":"IF(V94>Dashboard!$I91,U104*V7,(V21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":0},{"$f":"IF(W94>Dashboard!$I91,V104*W7,(W21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":0},{"$f":"IF(X94>Dashboard!$I91,W104*X7,(X21/100)*Dashboard!$I93*Dashboard!$I101)*PM_factor","v":0}]
[null,"Kosten PM emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J104*Kosten_PM*PM_factor_EUR","v":1044.2249999999999},1044.2249999999999,1044.2249999999999,1044.2249999999999,1044.2249999999999,1044.2249999999999,1044.2249999999999,1044.2249999999999,0,0,0,0,0,0,0]
[]
[null,{"$f":"\"emissie geluid (× 10^\"&noise_weight&\" dBh)\"","v":"emissie geluid (× 10^4 dBh)"},null,null,null,null,null,null,null,{"$f":"J7*J26*Dashboard!$I102/10^noise_weight","v":10.4},{"$f":"K7*K26*Dashboard!$I102/10^noise_weight","v":10.4},{"$f":"L7*L26*Dashboard!$I102/10^noise_weight","v":10.4},{"$f":"M7*M26*Dashboard!$I102/10^noise_weight","v":10.4},{"$f":"N7*N26*Dashboard!$I102/10^noise_weight","v":10.4},{"$f":"O7*O26*Dashboard!$I102/10^noise_weight","v":10.4},{"$f":"P7*P26*Dashboard!$I102/10^noise_weight","v":10.4},{"$f":"Q7*Q26*Dashboard!$I102/10^noise_weight","v":10.4},{"$f":"R7*R26*Dashboard!$I102/10^noise_weight","v":0},{"$f":"S7*S26*Dashboard!$I102/10^noise_weight","v":0},{"$f":"T7*T26*Dashboard!$I102/10^noise_weight","v":0},{"$f":"U7*U26*Dashboard!$I102/10^noise_weight","v":0},{"$f":"V7*V26*Dashboard!$I102/10^noise_weight","v":0},{"$f":"W7*W26*Dashboard!$I102/10^noise_weight","v":0},{"$f":"X7*X26*Dashboard!$I102/10^noise_weight","v":0}]
[null,"Kosten emissie geluid (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J21*Kosten_geluid/100","v":860},860,860,860,860,860,860,860,0,0,0,0,0,0,0]

{"sheet":"Alternatief 1","index":4,"n_rows":134,"n_cols":24,"rows_kept":134,"cut":false,"hidden":false,"merged":[[16,1,16,4],[125,8,126,8],[125,7,126,7],[16,8,16,23],[125,6,126,6]]}
[]
[null,null,null,null,null,null,null,null,{"$f":"I19","v":0},{"$f":"J19","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Jaar meetellen regulier",null,null,null,null,null,{"$f":"SUM(I4:X4)-1","v":10},1,{"$f":"IF(J2<=Dashboard!$K91,1,0)","v":1},{"$f":"IF(K2<=Dashboard!$K91,1,0)","v":1},{"$f":"IF(L2<=Dashboard!$K91,1,0)","v":1},{"$f":"IF(M2<=Dashboard!$K91,1,0)","v":1},{"$f":"IF(N2<=Dashboard!$K91,1,0)","v":1},{"$f":"IF(O2<=Dashboard!$K91,1,0)","v":1},{"$f":"IF(P2<=Dashboard!$K91,1,0)","v":1},{"$f":"IF(Q2<=Dashboard!$K91,1,0)","v":1},{"$f":"IF(R2<=Dashboard!$K91,1,0)","v":1},{"$f":"IF(S2<=Dashboard!$K91,1,0)","v":1},{"$f":"IF(T2<=Dashboard!$K91,1,0)","v":0},{"$f":"IF(U2<=Dashboard!$K91,1,0)","v":0},{"$f":"IF(V2<=Dashboard!$K91,1,0)","v":0},{"$f":"IF(W2<=Dashboard!$K91,1,0)","v":0},{"$f":"IF(X2<=Dashboard!$K91,1,0)","v":0}]
[null,"Jaar metellen financieringen",null,null,null,null,null,null,{"$f":"IF(I6=1,0,I4)","v":1},{"$f":"IF(J6=1,0,J4)","v":1},1,1,1,1,1,1,1,1,0,0,0,0,0,0]
[null,"Laatste jaar",null,null,null,null,null,null,{"$f":"IF(AND(I4=1,J4=0),1,0)","v":0},{"$f":"IF(AND(J4=1,K4=0),1,0)","v":0},0,0,0,0,0,0,0,0,1,0,0,0,0,0]
[null,"Inzet voertuig",null,null,null,null,null,null,null,{"$f":"J4","v":1},{"$f":"K4","v":1},1,1,1,1,1,1,1,1,0,0,0,0,0]
[]
[null,"Bedrijfseconomische afschrijving",null,null,null,null,null,null,0,{"$f":"IFERROR(1/Dashboard!$K91*J4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$K91*K4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$K91*L4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$K91*M4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$K91*N4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$K91*O4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$K91*P4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$K91*Q4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$K91*R4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$K91*S4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$K91*T4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$K91*U4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$K91*V4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$K91*W4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$K91*X4,0)","v":0}]
[null,"Fiscale afschrijving",null,null,null,null,null,null,{"$f":"MAX(Dashboard!K114,Referentie!I9)","v":0},{"$f":"IFERROR((1-I10)/SUM(J4:W4)*J4,0)","v":0.1},{"$f":"J10*K4","v":0.1},0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0,0,0,0,0]
[]
[null,"Aantal referentievoertuigen voor vergelijking",null,null,null,null,null,null,{"$f":"ROUND(J21/Referentie!J21,2)","v":1}]
[]
[]
[null,null,null,null,null,null,null,null,null,"SPECIFICATIE ALTERNATIEF 1"]
[]
[null,{"$f":"IF(Alternatief1_Naam=\"\",\"\",Alternatief1_Naam)","v":"Elek1"},null,null,null,null,null,null,{"$f":"IF(Switch_Alt1=0,\"Dit profiel is in het werkblad 'Dashboard' gedeactiveerd waardoor de foutencontrole is uitgeschakeld en dit overzicht mogelijk niet correct is\",IF(SUM(Dashboard!S53:S62)>0,\"Dit overzicht is mogelijk niet correct als gevolg van incomplete of foutieve invoer, check de foutmeldingen op werkblad 'Dashboard'\",\"\"))","v":""}]
[]
[null,"Kerndata",null,null,null,null,null,"Totaal",0,1,{"$f":"J19+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Aantal kilometers",null,null,null,null,null,{"$f":"SUM(I21:X21)","v":200000},0,{"$f":"Inzet_voertuig_Alt1*J4","v":20000},20000,20000,20000,20000,20000,20000,20000,20000,20000,0,0,0,0,0]
[null,"- waarvan binnen APV-tijden",null,null,null,null,null,200000,{"$f":"I21*Dashboard!$G76*(1-Dashboard!$K118)","v":0},{"$f":"J21*Dashboard!$G76*(1-Dashboard!$K118)","v":20000},{"$f":"K21*Dashboard!$G76*(1-Dashboard!$K118)","v":20000},{"$f":"L21*Dashboard!$G76*(1-Dashboard!$K118)","v":20000},{"$f":"M21*Dashboard!$G76*(1-Dashboard!$K118)","v":20000},{"$f":"N21*Dashboard!$G76*(1-Dashboard!$K118)","v":20000},{"$f":"O21*Dashboard!$G76*(1-Dashboard!$K118)","v":20000},{"$f":"P21*Dashboard!$G76*(1-Dashboard!$K118)","v":20000},{"$f":"Q21*Dashboard!$G76*(1-Dashboard!$K118)","v":20000},{"$f":"R21*Dashboard!$G76*(1-Dashboard!$K118)","v":20000},{"$f":"S21*Dashboard!$G76*(1-Dashboard!$K118)","v":20000},{"$f":"T21*Dashboard!$G76*(1-Dashboard!$K118)","v":0},{"$f":"U21*Dashboard!$G76*(1-Dashboard!$K118)","v":0},{"$f":"V21*Dashboard!$G76*(1-Dashboard!$K118)","v":0},{"$f":"W21*Dashboard!$G76*(1-Dashboard!$K118)","v":0},{"$f":"X21*Dashboard!$G76*(1-Dashboard!$K118)","v":0}]
[null,"- waarvan buiten APV-tijden",null,null,null,null,null,0,{"$f":"I21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"J21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"K21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"L21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"M21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"N21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"O21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"P21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"Q21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"R21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"S21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"T21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"U21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"V21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"W21*Dashboard!$G76*Dashboard!$K118","v":0},{"$f":"X21*Dashboard!$G76*Dashboard!$K118","v":0}]
[null,"- waarvan buiten APV-gebieden",null,null,null,null,null,0,{"$f":"I21*(1-Dashboard!$G76)","v":0},{"$f":"J21*(1-Dashboard!$G76)","v":0},{"$f":"K21*(1-Dashboard!$G76)","v":0},{"$f":"L21*(1-Dashboard!$G76)","v":0},{"$f":"M21*(1-Dashboard!$G76)","v":0},{"$f":"N21*(1-Dashboard!$G76)","v":0},{"$f":"O21*(1-Dashboard!$G76)","v":0},{"$f":"P21*(1-Dashboard!$G76)","v":0},{"$f":"Q21*(1-Dashboard!$G76)","v":0},{"$f":"R21*(1-Dashboard!$G76)","v":0},{"$f":"S21*(1-Dashboard!$G76)","v":0},{"$f":"T21*(1-Dashboard!$G76)","v":0},{"$f":"U21*(1-Dashboard!$G76)","v":0},{"$f":"V21*(1-Dashboard!$G76)","v":0},{"$f":"W21*(1-Dashboard!$G76)","v":0},{"$f":"X21*(1-Dashboard!$G76)","v":0}]
[null,{"$f":"\"Brandstofverbruik (\"&HLOOKUP(Alternatief1,Brandstofprofielen,4, FALSE)&\")\"","v":"Brandstofverbruik (kWh)"},null,null,null,null,null,200000,0,{"$f":"J21/100*Dashboard!$K93","v":20000},{"$f":"K21/100*Dashboard!$K93","v":20000},{"$f":"L21/100*Dashboard!$K93","v":20000},{"$f":"M21/100*Dashboard!$K93","v":20000},{"$f":"N21/100*Dashboard!$K93","v":20000},{"$f":"O21/100*Dashboard!$K93","v":20000},{"$f":"P21/100*Dashboard!$K93","v":20000},{"$f":"Q21/100*Dashboard!$K93","v":20000},{"$f":"R21/100*Dashboard!$K93","v":20000},{"$f":"S21/100*Dashboard!$K93","v":20000},{"$f":"T21/100*Dashboard!$K93","v":0},{"$f":"U21/100*Dashboard!$K93","v":0},{"$f":"V21/100*Dashboard!$K93","v":0},{"$f":"W21/100*Dashboard!$K93","v":0},{"$f":"X21/100*Dashboard!$K93","v":0}]
[null,"Aantal directe uren chauffeur",null,null,null,null,null,13333.333333333334,0,{"$f":"J22/Snelheid_Venster+SUM(J23:J24)/Snelheid_Overig","v":1333.3333333333333},1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,1333.3333333333333,0,0,0,0,0]
[null,"Aantal indirecte uren chauffeur",null,null,null,null,null,6666.6666666666688,0,{"$f":"Indirecte_minuten/60*J21","v":666.66666666666674},666.66666666666674,666.66666666666674,666.66666666666674,666.66666666666674,666.66666666666674,666.66666666666674,666.66666666666674,666.66666666666674,666.66666666666674,0,0,0,0,0]
[null,"Aantal uren bijrijder(s)",null,null,null,null,null,0,0,{"$f":"(Bezetting-1)*SUM(J26:J27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Brandstofprijs per \"&Dashboard!I62&\" (EUR)\"","v":"Brandstofprijs per liter (EUR)"},null,null,null,null,null,{"$f":"Brandstofprijs1+Dashboard!K123","v":0.1}]
[null,"Aantal uren per jaar",null,null,null,null,null,{"$f":"J26+J27","v":2000}]
[]
[null,"Overzicht kosten",null,null,"EUR",null,{"$f":"IF(Per_uur=1,\"Per uur\",\"Per km\")","v":"Per uur"},"Totaal",{"$f":"I19","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Brandstofkosten",null,null,null,null,{"$f":"H34/(Dashboard!K$91*Inzet_voertuig_Alt1*Per_km+Dashboard!K$91*Contractuele_uren_Alt1*Per_uur)","v":1},{"$f":"SUM(I34:X34)","v":20000},0,{"$f":"J25*$H29","v":2000},2000,2000,2000,2000,2000,2000,2000,2000,2000,0,0,0,0,0]
[null,"Onderhoudskosten",null,null,null,null,{"$f":"H35/(Dashboard!K$91*Inzet_voertuig_Alt1*Per_km+Dashboard!K$91*Contractuele_uren_Alt1*Per_uur)","v":0},0,0,{"$f":"Dashboard!$K94*J4","v":0},{"$f":"Dashboard!$K94*K4","v":0},{"$f":"Dashboard!$K94*L4","v":0},{"$f":"Dashboard!$K94*M4","v":0},{"$f":"Dashboard!$K94*N4","v":0},{"$f":"Dashboard!$K94*O4","v":0},{"$f":"Dashboard!$K94*P4","v":0},{"$f":"Dashboard!$K94*Q4","v":0},{"$f":"Dashboard!$K94*R4","v":0},{"$f":"Dashboard!$K94*S4","v":0},{"$f":"Dashboard!$K94*T4","v":0},{"$f":"Dashboard!$K94*U4","v":0},{"$f":"Dashboard!$K94*V4","v":0},{"$f":"Dashboard!$K94*W4","v":0},{"$f":"Dashboard!$K94*X4","v":0}]
[null,"Verzekeringen",null,null,null,null,{"$f":"H36/(Dashboard!K$91*Inzet_voertuig_Alt1*Per_km+Dashboard!K$91*Contractuele_uren_Alt1*Per_uur)","v":0},0,0,{"$f":"Dashboard!$K95*J4","v":0},{"$f":"Dashboard!$K95*K4","v":0},{"$f":"Dashboard!$K95*L4","v":0},{"$f":"Dashboard!$K95*M4","v":0},{"$f":"Dashboard!$K95*N4","v":0},{"$f":"Dashboard!$K95*O4","v":0},{"$f":"Dashboard!$K95*P4","v":0},{"$f":"Dashboard!$K95*Q4","v":0},{"$f":"Dashboard!$K95*R4","v":0},{"$f":"Dashboard!$K95*S4","v":0},{"$f":"Dashboard!$K95*T4","v":0},{"$f":"Dashboard!$K95*U4","v":0},{"$f":"Dashboard!$K95*V4","v":0},{"$f":"Dashboard!$K95*W4","v":0},{"$f":"Dashboard!$K95*X4","v":0}]
[null,"Voertuigbelasting",null,null,null,null,{"$f":"H37/(Dashboard!K$91*Inzet_voertuig_Alt1*Per_km+Dashboard!K$91*Contractuele_uren_Alt1*Per_uur)","v":0},0,0,{"$f":"(Dashboard!$K96+Dashboard!$K120)*J4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*K4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*L4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*M4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*N4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*O4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*P4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*Q4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*R4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*S4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*T4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*U4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*V4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*W4","v":0},{"$f":"(Dashboard!$K96+Dashboard!$K120)*X4","v":0}]
[null,"Overige kosten",null,null,null,null,{"$f":"H38/(Dashboard!K$91*Inzet_voertuig_Alt1*Per_km+Dashboard!K$91*Contractuele_uren_Alt1*Per_uur)","v":0},0,0,{"$f":"(Dashboard!$K97+Dashboard!$K121)*J4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*K4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*L4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*M4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*N4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*O4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*P4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*Q4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*R4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*S4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*T4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*U4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*V4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*W4","v":0},{"$f":"(Dashboard!$K97+Dashboard!$K121)*X4","v":0}]
[null,"Kosten ontheffingen",null,null,null,null,{"$f":"H39/(Dashboard!K$91*Inzet_voertuig_Alt1*Per_km+Dashboard!K$91*Contractuele_uren_Alt1*Per_uur)","v":0},0,0,{"$f":"(Dashboard!$K98+Dashboard!$K122)*J4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*K4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*L4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*M4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*N4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*O4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*P4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*Q4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*R4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*S4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*T4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*U4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*V4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*W4","v":0},{"$f":"(Dashboard!$K98+Dashboard!$K122)*X4","v":0}]
[null,"Personeelskosten",null,null,null,null,{"$f":"H40/(Dashboard!K$91*Inzet_voertuig_Alt1*Per_km+Dashboard!K$91*Contractuele_uren_Alt1*Per_uur)","v":25},500000,0,{"$f":"SUM(J26:J28)*Uurtarief","v":50000},50000,50000,50000,50000,50000,50000,50000,50000,50000,0,0,0,0,0]
[null,"Rente",null,null,null,null,{"$f":"H41/(Dashboard!K$91*Inzet_voertuig_Alt1*Per_km+Dashboard!K$91*Contractuele_uren_Alt1*Per_uur)","v":0.67733990147783474},13546.798029556696,0,{"$f":"I75*Rente_reeel+I74*zachte_rente_reeel1","v":2463.0541871921264},2216.7487684729135,1970.4433497537011,1724.1379310344885,1477.8325123152758,1231.5270935960632,985.22167487685056,738.91625615763792,492.61083743842528,246.30541871921264,0,0,0,0,0]
[null,"Bedrijfseconomische afschrijving",null,null,null,null,{"$f":"H42/(Dashboard!K$91*Inzet_voertuig_Alt1*Per_km+Dashboard!K$91*Contractuele_uren_Alt1*Per_uur)","v":4.9995999999999992},99991.999999999985,0,{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*J4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*K4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*L4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*M4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*N4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*O4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*P4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*Q4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*R4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*S4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*T4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*U4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*V4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*W4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$K92)/Dashboard!$K91*X4,0)","v":0}]
[null,"Totaal Kritische Distributie Kosten",null,null,null,null,{"$f":"SUM(G34:G42)","v":31.676939901477837},633538.79802955675,{"$f":"SUM(I34:I42)","v":0},64462.254187192128,64215.94876847291,63969.643349753707,63723.33793103449,63477.032512315272,63230.72709359607,62984.421674876852,62738.116256157635,62491.810837438432,62245.505418719215,0,0,0,0,0]
[]
[null,"Overzicht kasstromen",null,null,"EUR",null,null,"Totaal",{"$f":"I32","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"negatieve cijfers = cash out, positieve cijfers = cash in"]
[null,"Operationele kasstroom",null,null,null,null,null,{"$f":"SUM(I47:X47)","v":-533546.79802955675},{"$f":"-I43+I42","v":0},-54463.05418719213,-54216.748768472913,-53970.44334975371,-53724.137931034493,-53477.832512315275,{"$f":"-O43+O42","v":-53231.527093596073},-52985.221674876855,-52738.916256157638,-52492.610837438435,-52246.305418719217,0,0,0,0,0]
[null,"(totaal kritische distributiekosten excl. afschrijving)"]
[]
[null,"Investering in voertuig",null,null,null,null,null,{"$f":"SUM(I50:X50)","v":-100000},{"$f":"-Dashboard!$K$90","v":-100000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Investeringssubsidie",null,null,null,null,null,{"$f":"SUM(I51:X51)","v":0},{"$f":"-Dashboard!$K115*I50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Investering na investeringssubsidie",null,null,null,null,null,{"$f":"SUM(I52:X52)","v":-100000},{"$f":"SUM(I50:I51)","v":-100000},{"$f":"SUM(J50:J51)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Exploitatiesubsidie",null,null,null,null,null,{"$f":"SUM(I53:X53)","v":0},{"$f":"Dashboard!$K124","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Investering na investering- en exploitatiesubsidie",null,null,null,null,null,{"$f":"SUM(I54:X54)","v":-100000},{"$f":"SUM(I52:I53)","v":-100000},{"$f":"SUM(J52:J53)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Kasstroomeffect MIA",null,null,null,null,null,{"$f":"SUM(I56:X56)","v":0},{"$f":"-I52*Dashboard!$K113*VpB","v":0},{"$f":"-J52*Dashboard!$K113*VpB","v":0},{"$f":"-K52*Dashboard!$K113*VpB","v":0},{"$f":"-L52*Dashboard!$K113*VpB","v":0},{"$f":"-M52*Dashboard!$K113*VpB","v":0},{"$f":"-N52*Dashboard!$K113*VpB","v":0},{"$f":"-O52*Dashboard!$K113*VpB","v":0},{"$f":"-P52*Dashboard!$K113*VpB","v":0},{"$f":"-Q52*Dashboard!$K113*VpB","v":0},{"$f":"-R52*Dashboard!$K113*VpB","v":0},{"$f":"-S52*Dashboard!$K113*VpB","v":0},{"$f":"-T52*Dashboard!$K113*VpB","v":0},{"$f":"-U52*Dashboard!$K113*VpB","v":0},{"$f":"-V52*Dashboard!$K113*VpB","v":0},{"$f":"-W52*Dashboard!$K113*VpB","v":0},{"$f":"-X52*Dashboard!$K113*VpB","v":0}]
[null,"Kasstroomeffect VAMIL",null,null,null,null,null,{"$f":"SUM(I57:X57)","v":0},{"$f":"(I10-I9)*-$H52*VpB","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Netto investeringsgerelateerde kassstroom",null,null,null,null,null,{"$f":"SUM(I59:X59)","v":-100000},{"$f":"SUM(I54:I57)","v":-100000},{"$f":"SUM(J54:J57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Opname zachte leningen",null,null,null,null,null,{"$f":"SUM(I61:X61)","v":0},{"$f":"Dashboard!$K127*-I59","v":0},{"$f":"Dashboard!$K127*-J59","v":0},{"$f":"Dashboard!$K127*-K59","v":0},{"$f":"Dashboard!$K127*-L59","v":0},{"$f":"Dashboard!$K127*-M59","v":0},{"$f":"Dashboard!$K127*-N59","v":0},{"$f":"Dashboard!$K127*-O59","v":0},{"$f":"Dashboard!$K127*-P59","v":0},{"$f":"Dashboard!$K127*-Q59","v":0},{"$f":"Dashboard!$K127*-R59","v":0},{"$f":"Dashboard!$K127*-S59","v":0},{"$f":"Dashboard!$K127*-T59","v":0},{"$f":"Dashboard!$K127*-U59","v":0},{"$f":"Dashboard!$K127*-V59","v":0},{"$f":"Dashboard!$K127*-W59","v":0},{"$f":"Dashboard!$K127*-X59","v":0}]
[null,"Opname reguliere leningen",null,null,null,null,null,{"$f":"SUM(I62:X62)","v":100000},{"$f":"(1-Dashboard!$K127)*-I59","v":100000},{"$f":"(1-Dashboard!$K127)*-J59","v":0},{"$f":"(1-Dashboard!$K127)*-K59","v":0},{"$f":"(1-Dashboard!$K127)*-L59","v":0},{"$f":"(1-Dashboard!$K127)*-M59","v":0},{"$f":"(1-Dashboard!$K127)*-N59","v":0},{"$f":"(1-Dashboard!$K127)*-O59","v":0},{"$f":"(1-Dashboard!$K127)*-P59","v":0},{"$f":"(1-Dashboard!$K127)*-Q59","v":0},{"$f":"(1-Dashboard!$K127)*-R59","v":0},{"$f":"(1-Dashboard!$K127)*-S59","v":0},{"$f":"(1-Dashboard!$K127)*-T59","v":0},{"$f":"(1-Dashboard!$K127)*-U59","v":0},{"$f":"(1-Dashboard!$K127)*-V59","v":0},{"$f":"(1-Dashboard!$K127)*-W59","v":0},{"$f":"(1-Dashboard!$K127)*-X59","v":0}]
[null,"Aflossing zachte leningen",null,null,null,null,null,{"$f":"SUM(I63:X63)","v":0},0,{"$f":"IFERROR(-I74/(Dashboard!$K91-I45)*J5-(I74+J61)*J6,0)","v":0},{"$f":"IFERROR(-J74/(Dashboard!$K91-J45)*K5-(J74+K61)*K6,0)","v":0},{"$f":"IFERROR(-K74/(Dashboard!$K91-K45)*L5-(K74+L61)*L6,0)","v":0},{"$f":"IFERROR(-L74/(Dashboard!$K91-L45)*M5-(L74+M61)*M6,0)","v":0},{"$f":"IFERROR(-M74/(Dashboard!$K91-M45)*N5-(M74+N61)*N6,0)","v":0},{"$f":"IFERROR(-N74/(Dashboard!$K91-N45)*O5-(N74+O61)*O6,0)","v":0},{"$f":"IFERROR(-O74/(Dashboard!$K91-O45)*P5-(O74+P61)*P6,0)","v":0},{"$f":"IFERROR(-P74/(Dashboard!$K91-P45)*Q5-(P74+Q61)*Q6,0)","v":0},{"$f":"IFERROR(-Q74/(Dashboard!$K91-Q45)*R5-(Q74+R61)*R6,0)","v":0},{"$f":"IFERROR(-R74/(Dashboard!$K91-R45)*S5-(R74+S61)*S6,0)","v":0},{"$f":"IFERROR(-S74/(Dashboard!$K91-S45)*T5-(S74+T61)*T6,0)","v":0},{"$f":"IFERROR(-T74/(Dashboard!$K91-T45)*U5-(T74+U61)*U6,0)","v":0},{"$f":"IFERROR(-U74/(Dashboard!$K91-U45)*V5-(U74+V61)*V6,0)","v":0},{"$f":"IFERROR(-V74/(Dashboard!$K91-V45)*W5-(V74+W61)*W6,0)","v":0},{"$f":"IFERROR(-W74/(Dashboard!$K91-W45)*X5-(W74+X61)*X6,0)","v":0}]
[null,"Aflossing reguliere leningen",null,null,null,null,null,{"$f":"SUM(I64:X64)","v":-100000},0,{"$f":"IFERROR(-I75/SUM(J4:$X4)*J5-(I75+J62)*J6,0)","v":-10000},{"$f":"IFERROR(-J75/SUM(K4:$X4)*K5-(J75+K62)*K6,0)","v":-10000},{"$f":"IFERROR(-K75/SUM(L4:$X4)*L5-(K75+L62)*L6,0)","v":-10000},{"$f":"IFERROR(-L75/SUM(M4:$X4)*M5-(L75+M62)*M6,0)","v":-10000},{"$f":"IFERROR(-M75/SUM(N4:$X4)*N5-(M75+N62)*N6,0)","v":-10000},{"$f":"IFERROR(-N75/SUM(O4:$X4)*O5-(N75+O62)*O6,0)","v":-10000},{"$f":"IFERROR(-O75/SUM(P4:$X4)*P5-(O75+P62)*P6,0)","v":-10000},{"$f":"IFERROR(-P75/SUM(Q4:$X4)*Q5-(P75+Q62)*Q6,0)","v":-10000},{"$f":"IFERROR(-Q75/SUM(R4:$X4)*R5-(Q75+R62)*R6,0)","v":-10000},{"$f":"IFERROR(-R75/SUM(S4:$X4)*S5-(R75+S62)*S6,0)","v":-10000},{"$f":"IFERROR(-S75/SUM(T4:$X4)*T5-(S75+T62)*T6,0)","v":0},{"$f":"IFERROR(-T75/SUM(U4:$X4)*U5-(T75+U62)*U6,0)","v":0},{"$f":"IFERROR(-U75/SUM(V4:$X4)*V5-(U75+V62)*V6,0)","v":0},{"$f":"IFERROR(-V75/SUM(W4:$X4)*W5-(V75+W62)*W6,0)","v":0},{"$f":"IFERROR(-W75/SUM(X4:$X4)*X5-(W75+X62)*X6,0)","v":0}]
[]
[null,"Financieringskasstroom",null,null,null,null,null,{"$f":"SUM(I66:X66)","v":0},{"$f":"SUM(I61:I64)","v":100000},-10000,-10000,-10000,-10000,-10000,-10000,-10000,-10000,-10000,-10000,0,0,0,0,0]
[]
[null,"Totaal Kritische Distributie Kasstroom",null,null,null,null,null,{"$f":"SUM(I68:X68)","v":-633546.79802955675},{"$f":"I47+I59+I66","v":0},-64463.05418719213,-64216.748768472913,-63970.44334975371,-63724.137931034493,-63477.832512315275,-63231.527093596073,-62985.221674876855,-62738.916256157638,-62492.610837438435,-62246.305418719217,0,0,0,0,0]
[]
[null,"Balanspositie voertuig",null,null,"EUR",null,null,null,{"$f":"I32","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Hoofdvoertuig (boekwaarde)",null,null,null,null,null,null,{"$f":"(H72-I54-I56-I42)*J4","v":100000},90000.8,80001.600000000006,70002.400000000009,60003.200000000012,50004.000000000015,40004.800000000017,30005.600000000017,20006.400000000016,10007.200000000015,0,0,0,0,0,0]
[]
[null,"Zachte leningen",null,null,null,null,null,null,{"$f":"H74+I61+I63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Reguliere leningen",null,null,null,null,null,null,{"$f":"H75+I62+I64","v":100000},90000,80000,70000,60000,50000,40000,30000,20000,10000,0,0,0,0,0,0]
[null,"Totaal leningen",null,null,null,null,null,null,{"$f":"SUM(I74:I75)","v":100000},90000,80000,70000,60000,50000,{"$f":"SUM(O74:O75)","v":40000},30000,20000,10000,0,0,0,0,0,0]
[]
[null,"Kasstroom maatregelen",null,null,"EUR",null,"Contant","Totaal",{"$f":"I32","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"MIA",null,null,null,null,{"$f":"NPV(Discontovoet,J80:X80)+I80","v":0},{"$f":"SUM(I80:X80)","v":0},{"$f":"I56","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"VAMIL",null,null,null,null,{"$f":"NPV(Discontovoet,J81:X81)+I81","v":0},{"$f":"SUM(I81:X81)","v":0},{"$f":"I57","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Kasstroom bestaande maatregelen",null,null,null,null,{"$f":"NPV(Discontovoet,J82:X82)+I82","v":0},{"$f":"SUM(I82:X82)","v":0},{"$f":"SUM(I80:I81)","v":0},{"$f":"SUM(J80:J81)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Subsidies",null,null,null,null,{"$f":"NPV(Discontovoet,J84:X84)+I84","v":0},{"$f":"SUM(I84:X84)","v":0},{"$f":"I51+I53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Δ Voertuigbelastingen",null,null,null,null,0,0,0,{"$f":"-Dashboard!$K120*J7","v":0},{"$f":"-Dashboard!$K120*K7","v":0},{"$f":"-Dashboard!$K120*L7","v":0},{"$f":"-Dashboard!$K120*M7","v":0},{"$f":"-Dashboard!$K120*N7","v":0},{"$f":"-Dashboard!$K120*O7","v":0},{"$f":"-Dashboard!$K120*P7","v":0},{"$f":"-Dashboard!$K120*Q7","v":0},{"$f":"-Dashboard!$K120*R7","v":0},{"$f":"-Dashboard!$K120*S7","v":0},{"$f":"-Dashboard!$K120*T7","v":0},{"$f":"-Dashboard!$K120*U7","v":0},{"$f":"-Dashboard!$K120*V7","v":0},{"$f":"-Dashboard!$K120*W7","v":0},{"$f":"-Dashboard!$K120*X7","v":0}]
[null,"Δ Overige kosten",null,null,null,null,0,0,0,{"$f":"-Dashboard!$K121*J7","v":0},{"$f":"-Dashboard!$K121*K7","v":0},{"$f":"-Dashboard!$K121*L7","v":0},{"$f":"-Dashboard!$K121*M7","v":0},{"$f":"-Dashboard!$K121*N7","v":0},{"$f":"-Dashboard!$K121*O7","v":0},{"$f":"-Dashboard!$K121*P7","v":0},{"$f":"-Dashboard!$K121*Q7","v":0},{"$f":"-Dashboard!$K121*R7","v":0},{"$f":"-Dashboard!$K121*S7","v":0},{"$f":"-Dashboard!$K121*T7","v":0},{"$f":"-Dashboard!$K121*U7","v":0},{"$f":"-Dashboard!$K121*V7","v":0},{"$f":"-Dashboard!$K121*W7","v":0},{"$f":"-Dashboard!$K121*X7","v":0}]
[null,"Δ Kosten ontheffingen",null,null,null,null,{"$f":"NPV(Discontovoet,J87:X87)+I87","v":0},0,{"$f":"-Dashboard!$K122*I7","v":0},{"$f":"-Dashboard!$K122*J7","v":0},{"$f":"-Dashboard!$K122*K7","v":0},{"$f":"-Dashboard!$K122*L7","v":0},{"$f":"-Dashboard!$K122*M7","v":0},{"$f":"-Dashboard!$K122*N7","v":0},{"$f":"-Dashboard!$K122*O7","v":0},{"$f":"-Dashboard!$K122*P7","v":0},{"$f":"-Dashboard!$K122*Q7","v":0},{"$f":"-Dashboard!$K122*R7","v":0},{"$f":"-Dashboard!$K122*S7","v":0},{"$f":"-Dashboard!$K122*T7","v":0},{"$f":"-Dashboard!$K122*U7","v":0},{"$f":"-Dashboard!$K122*V7","v":0},{"$f":"-Dashboard!$K122*W7","v":0},{"$f":"-Dashboard!$K122*X7","v":0}]
[null,"Δ Brandstofprijs",null,null,null,null,0,0,0,{"$f":"-Inzet_voertuig_Alt1*J7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*K7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*L7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*M7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*N7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*O7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*P7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*Q7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*R7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*S7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*T7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*U7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*V7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*W7/100*Dashboard!$K93*Dashboard!$K123","v":0},{"$f":"-Inzet_voertuig_Alt1*X7/100*Dashboard!$K93*Dashboard!$K123","v":0}]
[null,"Rentesubsidies",null,null,null,null,0,0,0,{"$f":"I74*(Rente_reeel-zachte_rente_reeel1)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Kasstroom nieuwe maatregelen",null,null,null,null,0,{"$f":"SUM(H84:H89)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(X85:X89)","v":0}]
[]
[null,"Totaal kasstroom maatregelen",null,null,null,null,{"$f":"NPV(Discontovoet,J92:X92)+I92","v":0},{"$f":"SUM(I92:X92)","v":0},{"$f":"I82+I90","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Emissies",null,null,null,null,"Contant","Totaal",{"$f":"I32","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Nominaal"]
[]
[null,{"$f":"Dashboard!U$63&\" emissie CO2 (\"&CO2_weight&\"/jaar)\"","v":"WtW emissie CO2 (ton/jaar)"},null,null,null,null,null,null,null,{"$f":"IF(J94>Dashboard!$K91,I98*J7,(J21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(K94>Dashboard!$K91,J98*K7,(K21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(L94>Dashboard!$K91,K98*L7,(L21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(M94>Dashboard!$K91,L98*M7,(M21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(N94>Dashboard!$K91,M98*N7,(N21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(O94>Dashboard!$K91,N98*O7,(O21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(P94>Dashboard!$K91,O98*P7,(P21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(Q94>Dashboard!$K91,P98*Q7,(Q21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(R94>Dashboard!$K91,Q98*R7,(R21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(S94>Dashboard!$K91,R98*S7,(S21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(T94>Dashboard!$K91,S98*T7,(T21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(U94>Dashboard!$K91,T98*U7,(U21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(V94>Dashboard!$K91,U98*V7,(V21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(W94>Dashboard!$K91,V98*W7,(W21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0},{"$f":"IF(X94>Dashboard!$K91,W98*X7,(X21/100)*Dashboard!$K93*Dashboard!$K99)*CO2_factor","v":0}]
[null,"Kosten CO2 emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J98*Kosten_CO2*CO2_factor_EUR","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"Dashboard!U$64&\" emissie NOx (\"&NOx_weight&\"/jaar)\"","v":"TtW emissie NOx (kg/jaar)"},null,null,null,null,null,null,null,{"$f":"IF(J94>Dashboard!$K91,I101*J7,(J21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(K94>Dashboard!$K91,J101*K7,(K21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(L94>Dashboard!$K91,K101*L7,(L21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(M94>Dashboard!$K91,L101*M7,(M21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(N94>Dashboard!$K91,M101*N7,(N21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(O94>Dashboard!$K91,N101*O7,(O21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(P94>Dashboard!$K91,O101*P7,(P21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(Q94>Dashboard!$K91,P101*Q7,(Q21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(R94>Dashboard!$K91,Q101*R7,(R21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(S94>Dashboard!$K91,R101*S7,(S21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(T94>Dashboard!$K91,S101*T7,(T21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(U94>Dashboard!$K91,T101*U7,(U21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(V94>Dashboard!$K91,U101*V7,(V21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(W94>Dashboard!$K91,V101*W7,(W21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0},{"$f":"IF(X94>Dashboard!$K91,W101*X7,(X21/100)*Dashboard!$K93*Dashboard!$K100)*NOx_factor","v":0}]
[null,"Kosten NOx emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J101*Kosten_NOx*NOx_factor_EUR","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"Dashboard!U$65&\" emissie PM (\"&PM_weight&\"/jaar)\"","v":"TtW emissie PM (dag/jaar)"},null,null,null,null,null,null,null,{"$f":"IF(J94>Dashboard!$K91,I104*J7,(J21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":156},{"$f":"IF(K94>Dashboard!$K91,J104*K7,(K21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":156},{"$f":"IF(L94>Dashboard!$K91,K104*L7,(L21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":156},{"$f":"IF(M94>Dashboard!$K91,L104*M7,(M21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":156},{"$f":"IF(N94>Dashboard!$K91,M104*N7,(N21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":156},{"$f":"IF(O94>Dashboard!$K91,N104*O7,(O21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":156},{"$f":"IF(P94>Dashboard!$K91,O104*P7,(P21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":156},{"$f":"IF(Q94>Dashboard!$K91,P104*Q7,(Q21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":156},{"$f":"IF(R94>Dashboard!$K91,Q104*R7,(R21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":156},{"$f":"IF(S94>Dashboard!$K91,R104*S7,(S21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":156},{"$f":"IF(T94>Dashboard!$K91,S104*T7,(T21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":0},{"$f":"IF(U94>Dashboard!$K91,T104*U7,(U21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":0},{"$f":"IF(V94>Dashboard!$K91,U104*V7,(V21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":0},{"$f":"IF(W94>Dashboard!$K91,V104*W7,(W21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":0},{"$f":"IF(X94>Dashboard!$K91,W104*X7,(X21/100)*Dashboard!$K93*Dashboard!$K101)*PM_factor","v":0}]
[null,"Kosten PM emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J104*Kosten_PM*PM_factor_EUR","v":912.6},912.6,912.6,912.6,912.6,912.6,912.6,912.6,912.6,912.6,0,0,0,0,0]
[]
[null,{"$f":"\"emissie geluid (× 10^\"&noise_weight&\" dBh)\"","v":"emissie geluid (× 10^4 dBh)"},null,null,null,null,null,null,null,{"$f":"Referentie!J107  *  10^((Dashboard!$K$102-Dashboard!$I$102)/10)","v":1.6482889201595576},{"$f":"J107*K$7","v":1.6482889201595576},1.6482889201595576,1.6482889201595576,1.6482889201595576,1.6482889201595576,1.6482889201595576,1.6482889201595576,1.6482889201595576,1.6482889201595576,0,0,0,0,0]
[null,"Kosten emissie geluid (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"Referentie!J108  *  10^((Dashboard!$K$102-Dashboard!$I$102)/10) * (J26/Referentie!J26)","v":136.30081455165572},136.30081455165572,136.30081455165572,136.30081455165572,136.30081455165572,136.30081455165572,136.30081455165572,136.30081455165572,136.30081455165572,136.30081455165572,0,0,0,0,0]
[]
[null,{"$f":"\"Totale emissie ten opzichte van 1 referentievoertuig *)\"","v":"Totale emissie ten opzichte van 1 referentievoertuig *)"}]
[]
[null,{"$f":"Dashboard!U$63&\" emissie CO2 (\"&CO2_weight&\"/jaar)\"","v":"WtW emissie CO2 (ton/jaar)"},null,null,null,null,null,null,null,{"$f":"J98/($J$21/Referentie!$J$21)-Referentie!J98","v":-16.149999999999999},{"$f":"J112*K$7","v":-16.149999999999999},{"$f":"K112*L$7","v":-16.149999999999999},-16.149999999999999,-16.149999999999999,-16.149999999999999,-16.149999999999999,-16.149999999999999,-16.149999999999999,-16.149999999999999,0,0,0,0,0]
[null,"Kosten CO2 emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J99/($J$21/Referentie!$J$21)-Referentie!J99","v":-419.9},{"$f":"J113*K$7","v":-419.9},-419.9,-419.9,-419.9,-419.9,-419.9,-419.9,-419.9,-419.9,0,0,0,0,0]
[]
[null,{"$f":"Dashboard!U$64&\" emissie NOx (\"&NOx_weight&\"/jaar)\"","v":"TtW emissie NOx (kg/jaar)"},null,null,null,null,null,null,null,{"$f":"J101/($J$21/Referentie!$J$21)-Referentie!J101","v":-10.305},{"$f":"J115*K$7","v":-10.305},{"$f":"K115*L$7","v":-10.305},-10.305,-10.305,-10.305,-10.305,-10.305,-10.305,-10.305,0,0,0,0,0]
[null,"Kosten NOx emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J102/($J$21/Referentie!$J$21)-Referentie!J102","v":-113.35499999999999},{"$f":"J116*K$7","v":-113.35499999999999},-113.35499999999999,-113.35499999999999,-113.35499999999999,-113.35499999999999,-113.35499999999999,-113.35499999999999,-113.35499999999999,-113.35499999999999,0,0,0,0,0]
[]
[null,{"$f":"Dashboard!U$65&\" emissie PM (\"&PM_weight&\"/jaar)\"","v":"TtW emissie PM (dag/jaar)"},null,null,null,null,null,null,null,{"$f":"J104/($J$21/Referentie!$J$21)-Referentie!J104","v":-22.5},{"$f":"J118*K$7","v":-22.5},{"$f":"K118*L$7","v":-22.5},-22.5,-22.5,-22.5,-22.5,-22.5,-22.5,-22.5,0,0,0,0,0]
[null,"Kosten PM emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J105/($J$21/Referentie!$J$21)-Referentie!J105","v":-131.62499999999989},{"$f":"J119*K$7","v":-131.62499999999989},-131.62499999999989,-131.62499999999989,-131.62499999999989,-131.62499999999989,-131.62499999999989,-131.62499999999989,-131.62499999999989,-131.62499999999989,0,0,0,0,0]
[]
[null,{"$f":"\"emissie geluid (× 10^\"&noise_weight&\" dBh)\"","v":"emissie geluid (× 10^4 dBh)"},null,null,null,null,null,null,null,{"$f":"J107/($J$21/Referentie!$J$21)-Referentie!J107","v":-8.7517110798404421},{"$f":"J121*K$7","v":-8.7517110798404421},{"$f":"K121*L$7","v":-8.7517110798404421},-8.7517110798404421,-8.7517110798404421,-8.7517110798404421,-8.7517110798404421,-8.7517110798404421,-8.7517110798404421,-8.7517110798404421,0,0,0,0,0]
[null,"Kosten emissie geluid (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J108/($J$21/Referentie!$J$21)-Referentie!J108","v":-723.69918544834422},{"$f":"J122*K$7","v":-723.69918544834422},-723.69918544834422,-723.69918544834422,-723.69918544834422,-723.69918544834422,-723.69918544834422,-723.69918544834422,-723.69918544834422,-723.69918544834422,0,0,0,0,0]
[]
[null,{"$f":"\" *) het equivalent van 1 referentievoertuig is \"&ROUND(1/I12,2)&\" alternatief 1 voertuig(en)\"","v":" *) het equivalent van 1 referentievoertuig is 1 alternatief 1 voertuig(en)"}]
[]
[null,"Gemonetariseerd",null,null,null,null,"Contant","Totaal"]
[]
[null,"Emissiewinst",null,null,null,null,{"$f":"NPV(Discontovoet,J128:X128)+I128","v":11262.621054553216},{"$f":"SUM(I128:X128)","v":13885.791854483439},0,{"$f":"-1*(J113+J116+J119+J122)","v":1388.5791854483441},{"$f":"-1*(K113+K116+K119+K122)","v":1388.5791854483441},1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,0,0,0,0,0]
[null,"Nieuwe maatregelen (excl. MIA/VAMIL) (-)",null,null,null,null,{"$f":"NPV(Discontovoet,J129:X129)+I129","v":0},{"$f":"SUM(I129:X129)","v":0},{"$f":"-I90","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Resultaat",null,"IRR:",{"$f":"IFERROR((1+IRR(I130:X130))*(1+Inflatie)-1,\"n.v.t.\")","v":"n.v.t."},null,{"$f":"NPV(Discontovoet,J130:X130)+I130","v":11262.621054553216},{"$f":"SUM(I130:X130)","v":13885.791854483439},{"$f":"SUM(I128:I129)","v":0},{"$f":"SUM(J128:J129)","v":1388.5791854483441},1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,0,0,0,0,0]
[]
[null,"Emissiewinst",null,null,null,null,{"$f":"NPV(Discontovoet,J132:X132)+I132","v":11262.621054553216},{"$f":"SUM(I132:X132)","v":13885.791854483439},0,{"$f":"J128","v":1388.5791854483441},{"$f":"K128","v":1388.5791854483441},1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,0,0,0,0,0]
[null,"Alle maatregelen (incl. MIA/VAMIL) (-)",null,null,null,null,{"$f":"NPV(Discontovoet,J133:X133)+I133","v":0},{"$f":"SUM(I133:X133)","v":0},{"$f":"-I92","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Resultaat",null,"IRR:",{"$f":"IFERROR((1+IRR(I134:X134))*(1+Inflatie)-1,\"n.v.t.\")","v":"n.v.t."},null,{"$f":"NPV(Discontovoet,J134:X134)+I134","v":11262.621054553216},{"$f":"SUM(I134:X134)","v":13885.791854483439},{"$f":"SUM(I132:I133)","v":0},1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,1388.5791854483441,0,0,0,0,0]

{"sheet":"Alternatief 2","index":5,"n_rows":134,"n_cols":24,"rows_kept":134,"cut":false,"hidden":false,"merged":[[16,1,16,4],[125,8,126,8],[125,7,126,7],[16,8,16,23],[125,6,126,6]]}
[]
[null,null,null,null,null,null,null,null,{"$f":"I19","v":0},{"$f":"J19","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Jaar meetellen regulier",null,null,null,null,null,{"$f":"SUM(I4:X4)-1","v":10},1,{"$f":"IF(J2<=Dashboard!$M91,1,0)","v":1},{"$f":"IF(K2<=Dashboard!$M91,1,0)","v":1},{"$f":"IF(L2<=Dashboard!$M91,1,0)","v":1},{"$f":"IF(M2<=Dashboard!$M91,1,0)","v":1},{"$f":"IF(N2<=Dashboard!$M91,1,0)","v":1},{"$f":"IF(O2<=Dashboard!$M91,1,0)","v":1},{"$f":"IF(P2<=Dashboard!$M91,1,0)","v":1},{"$f":"IF(Q2<=Dashboard!$M91,1,0)","v":1},{"$f":"IF(R2<=Dashboard!$M91,1,0)","v":1},{"$f":"IF(S2<=Dashboard!$M91,1,0)","v":1},{"$f":"IF(T2<=Dashboard!$M91,1,0)","v":0},{"$f":"IF(U2<=Dashboard!$M91,1,0)","v":0},{"$f":"IF(V2<=Dashboard!$M91,1,0)","v":0},{"$f":"IF(W2<=Dashboard!$M91,1,0)","v":0},{"$f":"IF(X2<=Dashboard!$M91,1,0)","v":0}]
[null,"Jaar metellen financieringen",null,null,null,null,null,null,{"$f":"IF(I6=1,0,I4)","v":1},{"$f":"IF(J6=1,0,J4)","v":1},1,1,1,1,1,1,1,1,0,0,0,0,{"$f":"IF(W6=1,0,W4)","v":0},{"$f":"IF(X6=1,0,X4)","v":0}]
[null,"Laatste jaar",null,null,null,null,null,null,{"$f":"IF(AND(I4=1,J4=0),1,0)","v":0},{"$f":"IF(AND(J4=1,K4=0),1,0)","v":0},0,0,0,0,0,0,0,0,1,0,0,0,{"$f":"IF(AND(W4=1,X4=0),1,0)","v":0},{"$f":"IF(AND(X4=1,Y4=0),1,0)","v":0}]
[null,"Inzet voertuig",null,null,null,null,null,null,null,{"$f":"J4","v":1},{"$f":"K4","v":1},1,1,1,1,1,1,1,1,0,0,0,0,0]
[]
[null,"Bedrijfseconomische afschrijving",null,null,null,null,null,null,0,{"$f":"IFERROR(1/Dashboard!$M91*J4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$M91*K4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$M91*L4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$M91*M4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$M91*N4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$M91*O4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$M91*P4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$M91*Q4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$M91*R4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$M91*S4,0)","v":0.1},{"$f":"IFERROR(1/Dashboard!$M91*T4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$M91*U4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$M91*V4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$M91*W4,0)","v":0},{"$f":"IFERROR(1/Dashboard!$M91*X4,0)","v":0}]
[null,"Fiscale afschrijving",null,null,null,null,null,null,{"$f":"MAX(Dashboard!M114,Referentie!I9)","v":0},{"$f":"IFERROR((1-I10)/SUM(J4:W4)*J4,0)","v":0.1},{"$f":"J10*K4","v":0.1},0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0,0,0,0,0]
[]
[null,"Aantal referentievoertuigen voor vergelijking",null,null,null,null,null,null,{"$f":"ROUND(J21/Referentie!J21,2)","v":1.2}]
[]
[]
[null,null,null,null,null,null,null,null,null,"SPECIFICATIE ALTERNATIEF 2"]
[]
[null,{"$f":"IF(Alternatief2_Naam=\"\",\"\",Alternatief2_Naam)","v":"Elek1"},null,null,null,null,null,null,{"$f":"IF(Switch_Alt2=0,\"Dit profiel is in het werkblad 'Dashboard' gedeactiveerd waardoor de foutencontrole is uitgeschakeld en dit overzicht mogelijk niet correct is\",IF(SUM(Dashboard!S53:S62)>0,\"Dit overzicht is mogelijk niet correct als gevolg van incomplete of foutieve invoer, check de foutmeldingen op werkblad 'Dashboard'\",\"\"))","v":""}]
[]
[null,"Kerndata",null,null,null,null,null,"Totaal",0,1,{"$f":"J19+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Aantal kilometers",null,null,null,null,null,{"$f":"SUM(I21:X21)","v":239999.99999999997},0,{"$f":"Inzet_voertuig_Alt2*J4","v":23999.999999999996},23999.999999999996,23999.999999999996,23999.999999999996,23999.999999999996,23999.999999999996,23999.999999999996,23999.999999999996,23999.999999999996,23999.999999999996,0,0,0,0,0]
[null,"- waarvan binnen APV-tijden",null,null,null,null,null,0,{"$f":"I21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"J21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"K21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"L21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"M21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"N21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"O21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"P21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"Q21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"R21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"S21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"T21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"U21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"V21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"W21*Dashboard!$G76*(1-Dashboard!$M118)","v":0},{"$f":"X21*Dashboard!$G76*(1-Dashboard!$M118)","v":0}]
[null,"- waarvan buiten APV-tijden",null,null,null,null,null,239999.99999999997,{"$f":"I21*Dashboard!$G76*Dashboard!$M118","v":0},{"$f":"J21*Dashboard!$G76*Dashboard!$M118","v":23999.999999999996},{"$f":"K21*Dashboard!$G76*Dashboard!$M118","v":23999.999999999996},{"$f":"L21*Dashboard!$G76*Dashboard!$M118","v":23999.999999999996},{"$f":"M21*Dashboard!$G76*Dashboard!$M118","v":23999.999999999996},{"$f":"N21*Dashboard!$G76*Dashboard!$M118","v":23999.999999999996},{"$f":"O21*Dashboard!$G76*Dashboard!$M118","v":23999.999999999996},{"$f":"P21*Dashboard!$G76*Dashboard!$M118","v":23999.999999999996},{"$f":"Q21*Dashboard!$G76*Dashboard!$M118","v":23999.999999999996},{"$f":"R21*Dashboard!$G76*Dashboard!$M118","v":23999.999999999996},{"$f":"S21*Dashboard!$G76*Dashboard!$M118","v":23999.999999999996},{"$f":"T21*Dashboard!$G76*Dashboard!$M118","v":0},{"$f":"U21*Dashboard!$G76*Dashboard!$M118","v":0},{"$f":"V21*Dashboard!$G76*Dashboard!$M118","v":0},{"$f":"W21*Dashboard!$G76*Dashboard!$M118","v":0},{"$f":"X21*Dashboard!$G76*Dashboard!$M118","v":0}]
[null,"- waarvan buiten APV-gebieden",null,null,null,null,null,0,{"$f":"I21*(1-Dashboard!$G76)","v":0},{"$f":"J21*(1-Dashboard!$G76)","v":0},{"$f":"K21*(1-Dashboard!$G76)","v":0},{"$f":"L21*(1-Dashboard!$G76)","v":0},{"$f":"M21*(1-Dashboard!$G76)","v":0},{"$f":"N21*(1-Dashboard!$G76)","v":0},{"$f":"O21*(1-Dashboard!$G76)","v":0},{"$f":"P21*(1-Dashboard!$G76)","v":0},{"$f":"Q21*(1-Dashboard!$G76)","v":0},{"$f":"R21*(1-Dashboard!$G76)","v":0},{"$f":"S21*(1-Dashboard!$G76)","v":0},{"$f":"T21*(1-Dashboard!$G76)","v":0},{"$f":"U21*(1-Dashboard!$G76)","v":0},{"$f":"V21*(1-Dashboard!$G76)","v":0},{"$f":"W21*(1-Dashboard!$G76)","v":0},{"$f":"X21*(1-Dashboard!$G76)","v":0}]
[null,{"$f":"\"Brandstofverbruik (\"&HLOOKUP(Alternatief2,Brandstofprofielen,4, FALSE)&\")\"","v":"Brandstofverbruik (kWh)"},null,null,null,null,null,239999.99999999997,0,{"$f":"J21/100*Dashboard!$M93","v":23999.999999999996},{"$f":"K21/100*Dashboard!$M93","v":23999.999999999996},{"$f":"L21/100*Dashboard!$M93","v":23999.999999999996},{"$f":"M21/100*Dashboard!$M93","v":23999.999999999996},{"$f":"N21/100*Dashboard!$M93","v":23999.999999999996},{"$f":"O21/100*Dashboard!$M93","v":23999.999999999996},{"$f":"P21/100*Dashboard!$M93","v":23999.999999999996},{"$f":"Q21/100*Dashboard!$M93","v":23999.999999999996},{"$f":"R21/100*Dashboard!$M93","v":23999.999999999996},{"$f":"S21/100*Dashboard!$M93","v":23999.999999999996},{"$f":"T21/100*Dashboard!$M93","v":0},{"$f":"U21/100*Dashboard!$M93","v":0},{"$f":"V21/100*Dashboard!$M93","v":0},{"$f":"W21/100*Dashboard!$M93","v":0},{"$f":"X21/100*Dashboard!$M93","v":0}]
[null,"Aantal directe uren chauffeur",null,null,null,null,null,11999.999999999998,0,{"$f":"J22/Snelheid_Venster+SUM(J23:J24)/Snelheid_Overig","v":1199.9999999999998},1199.9999999999998,1199.9999999999998,1199.9999999999998,1199.9999999999998,1199.9999999999998,1199.9999999999998,1199.9999999999998,1199.9999999999998,1199.9999999999998,0,0,0,0,0]
[null,"Aantal indirecte uren chauffeur",null,null,null,null,null,8000,0,{"$f":"Indirecte_minuten/60*J21","v":800},800,800,800,800,800,800,800,800,800,0,0,0,0,0]
[null,"Aantal uren bijrijder(s)",null,null,null,null,null,0,0,{"$f":"(Bezetting-1)*SUM(J26:J27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"\"Brandstofprijs per \"&Dashboard!I62&\" (EUR)\"","v":"Brandstofprijs per liter (EUR)"},null,null,null,null,null,{"$f":"Brandstofprijs2+Dashboard!M123","v":0.1}]
[null,"Aantal uren per jaar",null,null,null,null,null,{"$f":"J26+J27","v":1999.9999999999998}]
[]
[null,"Overzicht kosten",null,null,"EUR",null,{"$f":"IF(Per_uur=1,\"Per uur\",\"Per km\")","v":"Per uur"},"Totaal",{"$f":"I19","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Brandstofkosten",null,null,null,null,{"$f":"H34/(Dashboard!M$91*Inzet_voertuig_Alt2*Per_km+Dashboard!M$91*Contractuele_uren_Alt2*Per_uur)","v":1.2},{"$f":"SUM(I34:X34)","v":23999.999999999996},0,{"$f":"J25*$H29","v":2399.9999999999995},2399.9999999999995,2399.9999999999995,2399.9999999999995,2399.9999999999995,2399.9999999999995,2399.9999999999995,2399.9999999999995,2399.9999999999995,2399.9999999999995,0,0,0,0,0]
[null,"Onderhoudskosten",null,null,null,null,{"$f":"H35/(Dashboard!M$91*Inzet_voertuig_Alt2*Per_km+Dashboard!M$91*Contractuele_uren_Alt2*Per_uur)","v":0},0,0,{"$f":"Dashboard!$M94*J4","v":0},{"$f":"Dashboard!$M94*K4","v":0},{"$f":"Dashboard!$M94*L4","v":0},{"$f":"Dashboard!$M94*M4","v":0},{"$f":"Dashboard!$M94*N4","v":0},{"$f":"Dashboard!$M94*O4","v":0},{"$f":"Dashboard!$M94*P4","v":0},{"$f":"Dashboard!$M94*Q4","v":0},{"$f":"Dashboard!$M94*R4","v":0},{"$f":"Dashboard!$M94*S4","v":0},{"$f":"Dashboard!$M94*T4","v":0},{"$f":"Dashboard!$M94*U4","v":0},{"$f":"Dashboard!$M94*V4","v":0},{"$f":"Dashboard!$M94*W4","v":0},{"$f":"Dashboard!$M94*X4","v":0}]
[null,"Verzekeringen",null,null,null,null,{"$f":"H36/(Dashboard!M$91*Inzet_voertuig_Alt2*Per_km+Dashboard!M$91*Contractuele_uren_Alt2*Per_uur)","v":0},0,0,{"$f":"Dashboard!$M95*J4","v":0},{"$f":"Dashboard!$M95*K4","v":0},{"$f":"Dashboard!$M95*L4","v":0},{"$f":"Dashboard!$M95*M4","v":0},{"$f":"Dashboard!$M95*N4","v":0},{"$f":"Dashboard!$M95*O4","v":0},{"$f":"Dashboard!$M95*P4","v":0},{"$f":"Dashboard!$M95*Q4","v":0},{"$f":"Dashboard!$M95*R4","v":0},{"$f":"Dashboard!$M95*S4","v":0},{"$f":"Dashboard!$M95*T4","v":0},{"$f":"Dashboard!$M95*U4","v":0},{"$f":"Dashboard!$M95*V4","v":0},{"$f":"Dashboard!$M95*W4","v":0},{"$f":"Dashboard!$M95*X4","v":0}]
[null,"Voertuigbelasting",null,null,null,null,{"$f":"H37/(Dashboard!M$91*Inzet_voertuig_Alt2*Per_km+Dashboard!M$91*Contractuele_uren_Alt2*Per_uur)","v":0},0,0,{"$f":"(Dashboard!$M96+Dashboard!$M120)*J4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*K4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*L4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*M4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*N4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*O4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*P4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*Q4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*R4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*S4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*T4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*U4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*V4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*W4","v":0},{"$f":"(Dashboard!$M96+Dashboard!$M120)*X4","v":0}]
[null,"Overige kosten",null,null,null,null,{"$f":"H38/(Dashboard!M$91*Inzet_voertuig_Alt2*Per_km+Dashboard!M$91*Contractuele_uren_Alt2*Per_uur)","v":0},0,0,{"$f":"(Dashboard!$M97+Dashboard!$M121)*J4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*K4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*L4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*M4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*N4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*O4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*P4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*Q4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*R4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*S4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*T4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*U4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*V4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*W4","v":0},{"$f":"(Dashboard!$M97+Dashboard!$M121)*X4","v":0}]
[null,"Kosten ontheffingen",null,null,null,null,{"$f":"H39/(Dashboard!M$91*Inzet_voertuig_Alt2*Per_km+Dashboard!M$91*Contractuele_uren_Alt2*Per_uur)","v":0},0,0,{"$f":"(Dashboard!$M98+Dashboard!$M122)*J4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*K4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*L4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*M4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*N4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*O4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*P4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*Q4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*R4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*S4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*T4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*U4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*V4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*W4","v":0},{"$f":"(Dashboard!$M98+Dashboard!$M122)*X4","v":0}]
[null,"Personeelskosten",null,null,null,null,{"$f":"H40/(Dashboard!M$91*Inzet_voertuig_Alt2*Per_km+Dashboard!M$91*Contractuele_uren_Alt2*Per_uur)","v":25},499999.99999999994,0,{"$f":"SUM(J26:J28)*Uurtarief","v":49999.999999999993},49999.999999999993,49999.999999999993,49999.999999999993,49999.999999999993,49999.999999999993,49999.999999999993,49999.999999999993,49999.999999999993,49999.999999999993,0,0,0,0,0]
[null,"Rente",null,null,null,null,{"$f":"H41/(Dashboard!M$91*Inzet_voertuig_Alt2*Per_km+Dashboard!M$91*Contractuele_uren_Alt2*Per_uur)","v":0.67733990147783496},13546.798029556696,0,{"$f":"I75*Rente_reeel+I74*zachte_rente_reeel2","v":2463.0541871921264},2216.7487684729135,1970.4433497537011,1724.1379310344885,1477.8325123152758,1231.5270935960632,985.22167487685056,738.91625615763792,492.61083743842528,246.30541871921264,0,0,0,0,0]
[null,"Bedrijfseconomische afschrijving",null,null,null,null,{"$f":"H42/(Dashboard!M$91*Inzet_voertuig_Alt2*Per_km+Dashboard!M$91*Contractuele_uren_Alt2*Per_uur)","v":4.9996},99991.999999999985,0,{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*J4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*K4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*L4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*M4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*N4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*O4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*P4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*Q4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*R4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*S4,0)","v":9999.2000000000007},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*T4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*U4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*V4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*W4,0)","v":0},{"$f":"IFERROR((-$H59-Dashboard!$M92)/Dashboard!$M91*X4,0)","v":0}]
[null,"Totaal Kritische Distributie Kosten",null,null,null,null,{"$f":"SUM(G34:G42)","v":31.876939901477837},637538.79802955664,{"$f":"SUM(I34:I42)","v":0},64862.254187192113,64615.94876847291,64369.643349753693,64123.337931034475,63877.032512315272,63630.727093596055,63384.421674876838,63138.116256157635,62891.810837438417,62645.5054187192,0,0,0,0,0]
[]
[null,"Overzicht kasstromen",null,null,"EUR",null,null,"Totaal",{"$f":"I32","v":0},1,2,3,4,5,{"$f":"O32","v":6},7,8,9,10,11,12,13,14,15]
[null,"negatieve cijfers = cash out, positieve cijfers = cash in"]
[null,"Operationele kasstroom",null,null,null,null,null,{"$f":"SUM(I47:X47)","v":-537546.79802955664},{"$f":"-I43+I42","v":0},-54863.054187192116,-54616.748768472913,-54370.443349753696,-54124.137931034478,-53877.832512315275,{"$f":"-O43+O42","v":-53631.527093596058},-53385.221674876841,-53138.916256157638,-52892.61083743842,-52646.305418719203,0,0,0,0,0]
[null,"(totaal kritische distributiekosten excl. afschrijving)"]
[]
[null,"Investering in voertuig",null,null,null,null,null,{"$f":"SUM(I50:X50)","v":-100000},{"$f":"-Dashboard!$M$90","v":-100000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Investeringssubsidie",null,null,null,null,null,{"$f":"SUM(I51:X51)","v":0},{"$f":"-Dashboard!$M115*I50","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Investering na investeringssubsidie",null,null,null,null,null,{"$f":"SUM(I52:X52)","v":-100000},{"$f":"SUM(I50:I51)","v":-100000},{"$f":"SUM(J50:J51)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Exploitatiesubsidie",null,null,null,null,null,{"$f":"SUM(I53:X53)","v":0},{"$f":"Dashboard!$M124","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Investering na investering- en exploitatiesubsidie",null,null,null,null,null,{"$f":"SUM(I54:X54)","v":-100000},{"$f":"SUM(I52:I53)","v":-100000},{"$f":"SUM(J52:J53)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Kasstroomeffect MIA",null,null,null,null,null,{"$f":"SUM(I56:X56)","v":0},{"$f":"-I52*Dashboard!$M113*VpB","v":0},{"$f":"-J52*Dashboard!$M113*VpB","v":0},{"$f":"-K52*Dashboard!$M113*VpB","v":0},{"$f":"-L52*Dashboard!$M113*VpB","v":0},{"$f":"-M52*Dashboard!$M113*VpB","v":0},{"$f":"-N52*Dashboard!$M113*VpB","v":0},{"$f":"-O52*Dashboard!$M113*VpB","v":0},{"$f":"-P52*Dashboard!$M113*VpB","v":0},{"$f":"-Q52*Dashboard!$M113*VpB","v":0},{"$f":"-R52*Dashboard!$M113*VpB","v":0},{"$f":"-S52*Dashboard!$M113*VpB","v":0},{"$f":"-T52*Dashboard!$M113*VpB","v":0},{"$f":"-U52*Dashboard!$M113*VpB","v":0},{"$f":"-V52*Dashboard!$M113*VpB","v":0},{"$f":"-W52*Dashboard!$M113*VpB","v":0},{"$f":"-X52*Dashboard!$M113*VpB","v":0}]
[null,"Kasstroomeffect VAMIL",null,null,null,null,null,{"$f":"SUM(I57:X57)","v":0},{"$f":"(I10-I9)*-$H52*VpB","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Netto investeringsgerelateerde kassstroom",null,null,null,null,null,{"$f":"SUM(I59:X59)","v":-100000},{"$f":"SUM(I54:I57)","v":-100000},{"$f":"SUM(J54:J57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Opname zachte leningen",null,null,null,null,null,{"$f":"SUM(I61:X61)","v":0},{"$f":"Dashboard!$M127*-I59","v":0},{"$f":"Dashboard!$M127*-J59","v":0},{"$f":"Dashboard!$M127*-K59","v":0},{"$f":"Dashboard!$M127*-L59","v":0},{"$f":"Dashboard!$M127*-M59","v":0},{"$f":"Dashboard!$M127*-N59","v":0},{"$f":"Dashboard!$M127*-O59","v":0},{"$f":"Dashboard!$M127*-P59","v":0},{"$f":"Dashboard!$M127*-Q59","v":0},{"$f":"Dashboard!$M127*-R59","v":0},{"$f":"Dashboard!$M127*-S59","v":0},{"$f":"Dashboard!$M127*-T59","v":0},{"$f":"Dashboard!$M127*-U59","v":0},{"$f":"Dashboard!$M127*-V59","v":0},{"$f":"Dashboard!$M127*-W59","v":0},{"$f":"Dashboard!$M127*-X59","v":0}]
[null,"Opname reguliere leningen",null,null,null,null,null,{"$f":"SUM(I62:X62)","v":100000},{"$f":"(1-Dashboard!$M127)*-I59","v":100000},{"$f":"(1-Dashboard!$M127)*-J59","v":0},{"$f":"(1-Dashboard!$M127)*-K59","v":0},{"$f":"(1-Dashboard!$M127)*-L59","v":0},{"$f":"(1-Dashboard!$M127)*-M59","v":0},{"$f":"(1-Dashboard!$M127)*-N59","v":0},{"$f":"(1-Dashboard!$M127)*-O59","v":0},{"$f":"(1-Dashboard!$M127)*-P59","v":0},{"$f":"(1-Dashboard!$M127)*-Q59","v":0},{"$f":"(1-Dashboard!$M127)*-R59","v":0},{"$f":"(1-Dashboard!$M127)*-S59","v":0},{"$f":"(1-Dashboard!$M127)*-T59","v":0},{"$f":"(1-Dashboard!$M127)*-U59","v":0},{"$f":"(1-Dashboard!$M127)*-V59","v":0},{"$f":"(1-Dashboard!$M127)*-W59","v":0},{"$f":"(1-Dashboard!$M127)*-X59","v":0}]
[null,"Aflossing zachte leningen",null,null,null,null,null,{"$f":"SUM(I63:X63)","v":0},0,{"$f":"IFERROR(-I74/(Dashboard!$M91-I45)*J5-(I74+J61)*J6,0)","v":0},{"$f":"IFERROR(-J74/(Dashboard!$M91-J45)*K5-(J74+K61)*K6,0)","v":0},{"$f":"IFERROR(-K74/(Dashboard!$M91-K45)*L5-(K74+L61)*L6,0)","v":0},{"$f":"IFERROR(-L74/(Dashboard!$M91-L45)*M5-(L74+M61)*M6,0)","v":0},{"$f":"IFERROR(-M74/(Dashboard!$M91-M45)*N5-(M74+N61)*N6,0)","v":0},{"$f":"IFERROR(-N74/(Dashboard!$M91-N45)*O5-(N74+O61)*O6,0)","v":0},{"$f":"IFERROR(-O74/(Dashboard!$M91-O45)*P5-(O74+P61)*P6,0)","v":0},{"$f":"IFERROR(-P74/(Dashboard!$M91-P45)*Q5-(P74+Q61)*Q6,0)","v":0},{"$f":"IFERROR(-Q74/(Dashboard!$M91-Q45)*R5-(Q74+R61)*R6,0)","v":0},{"$f":"IFERROR(-R74/(Dashboard!$M91-R45)*S5-(R74+S61)*S6,0)","v":0},{"$f":"IFERROR(-S74/(Dashboard!$M91-S45)*T5-(S74+T61)*T6,0)","v":0},{"$f":"IFERROR(-T74/(Dashboard!$M91-T45)*U5-(T74+U61)*U6,0)","v":0},{"$f":"IFERROR(-U74/(Dashboard!$M91-U45)*V5-(U74+V61)*V6,0)","v":0},{"$f":"IFERROR(-V74/(Dashboard!$M91-V45)*W5-(V74+W61)*W6,0)","v":0},{"$f":"IFERROR(-W74/(Dashboard!$M91-W45)*X5-(W74+X61)*X6,0)","v":0}]
[null,"Aflossing reguliere leningen",null,null,null,null,null,{"$f":"SUM(I64:X64)","v":-100000},0,{"$f":"IFERROR(-I75/SUM(J4:$X4)*J5-(I75+J62)*J6,0)","v":-10000},{"$f":"IFERROR(-J75/SUM(K4:$X4)*K5-(J75+K62)*K6,0)","v":-10000},{"$f":"IFERROR(-K75/SUM(L4:$X4)*L5-(K75+L62)*L6,0)","v":-10000},{"$f":"IFERROR(-L75/SUM(M4:$X4)*M5-(L75+M62)*M6,0)","v":-10000},{"$f":"IFERROR(-M75/SUM(N4:$X4)*N5-(M75+N62)*N6,0)","v":-10000},{"$f":"IFERROR(-N75/SUM(O4:$X4)*O5-(N75+O62)*O6,0)","v":-10000},{"$f":"IFERROR(-O75/SUM(P4:$X4)*P5-(O75+P62)*P6,0)","v":-10000},{"$f":"IFERROR(-P75/SUM(Q4:$X4)*Q5-(P75+Q62)*Q6,0)","v":-10000},{"$f":"IFERROR(-Q75/SUM(R4:$X4)*R5-(Q75+R62)*R6,0)","v":-10000},{"$f":"IFERROR(-R75/SUM(S4:$X4)*S5-(R75+S62)*S6,0)","v":-10000},{"$f":"IFERROR(-S75/SUM(T4:$X4)*T5-(S75+T62)*T6,0)","v":0},{"$f":"IFERROR(-T75/SUM(U4:$X4)*U5-(T75+U62)*U6,0)","v":0},{"$f":"IFERROR(-U75/SUM(V4:$X4)*V5-(U75+V62)*V6,0)","v":0},{"$f":"IFERROR(-V75/SUM(W4:$X4)*W5-(V75+W62)*W6,0)","v":0},{"$f":"IFERROR(-W75/SUM(X4:$X4)*X5-(W75+X62)*X6,0)","v":0}]
[]
[null,"Financieringskasstroom",null,null,null,null,null,{"$f":"SUM(I66:X66)","v":0},{"$f":"SUM(I61:I64)","v":100000},-10000,-10000,-10000,-10000,-10000,-10000,-10000,-10000,-10000,-10000,0,0,0,0,0]
[]
[null,"Totaal Kritische Distributie Kasstroom",null,null,null,null,null,{"$f":"SUM(I68:X68)","v":-637546.79802955664},{"$f":"I47+I59+I66","v":0},-64863.054187192116,-64616.748768472913,-64370.443349753696,-64124.137931034478,-63877.832512315275,-63631.527093596058,-63385.221674876841,-63138.916256157638,-62892.61083743842,-62646.305418719203,0,0,0,0,0]
[]
[null,"Balanspositie voertuig",null,null,"EUR",null,null,null,{"$f":"I32","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Hoofdvoertuig (boekwaarde)",null,null,null,null,null,null,{"$f":"(H72-I54-I56-I42)*J4","v":100000},90000.8,80001.600000000006,70002.400000000009,60003.200000000012,50004.000000000015,40004.800000000017,30005.600000000017,20006.400000000016,10007.200000000015,0,0,0,0,0,0]
[]
[null,"Zachte leningen",null,null,null,null,null,null,{"$f":"H74+I61+I63","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Reguliere leningen",null,null,null,null,null,null,{"$f":"H75+I62+I64","v":100000},90000,80000,70000,60000,50000,40000,30000,20000,10000,0,0,0,0,0,0]
[null,"Totaal leningen",null,null,null,null,null,null,{"$f":"SUM(I74:I75)","v":100000},90000,80000,70000,60000,50000,{"$f":"SUM(O74:O75)","v":40000},30000,20000,10000,0,0,0,0,0,0]
[]
[null,"Kasstroom maatregelen",null,null,"EUR",null,"Contant","Totaal",{"$f":"I32","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"MIA",null,null,null,null,{"$f":"NPV(Discontovoet,J80:X80)+I80","v":0},{"$f":"SUM(I80:X80)","v":0},{"$f":"I56","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"VAMIL",null,null,null,null,{"$f":"NPV(Discontovoet,J81:X81)+I81","v":0},{"$f":"SUM(I81:X81)","v":0},{"$f":"I57","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Kasstroom bestaande maatregelen",null,null,null,null,{"$f":"NPV(Discontovoet,J82:X82)+I82","v":0},{"$f":"SUM(I82:X82)","v":0},{"$f":"SUM(I80:I81)","v":0},{"$f":"SUM(J80:J81)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Subsidies",null,null,null,null,{"$f":"NPV(Discontovoet,J84:X84)+I84","v":0},{"$f":"SUM(I84:X84)","v":0},{"$f":"I51+I53","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Δ Voertuigbelastingen",null,null,null,null,0,0,0,{"$f":"-Dashboard!$M120*J7","v":0},{"$f":"-Dashboard!$M120*K7","v":0},{"$f":"-Dashboard!$M120*L7","v":0},{"$f":"-Dashboard!$M120*M7","v":0},{"$f":"-Dashboard!$M120*N7","v":0},{"$f":"-Dashboard!$M120*O7","v":0},{"$f":"-Dashboard!$M120*P7","v":0},{"$f":"-Dashboard!$M120*Q7","v":0},{"$f":"-Dashboard!$M120*R7","v":0},{"$f":"-Dashboard!$M120*S7","v":0},{"$f":"-Dashboard!$M120*T7","v":0},{"$f":"-Dashboard!$M120*U7","v":0},{"$f":"-Dashboard!$M120*V7","v":0},{"$f":"-Dashboard!$M120*W7","v":0},{"$f":"-Dashboard!$M120*X7","v":0}]
[null,"Δ Overige kosten",null,null,null,null,0,0,0,{"$f":"-Dashboard!$M121*J7","v":0},{"$f":"-Dashboard!$M121*K7","v":0},{"$f":"-Dashboard!$M121*L7","v":0},{"$f":"-Dashboard!$M121*M7","v":0},{"$f":"-Dashboard!$M121*N7","v":0},{"$f":"-Dashboard!$M121*O7","v":0},{"$f":"-Dashboard!$M121*P7","v":0},{"$f":"-Dashboard!$M121*Q7","v":0},{"$f":"-Dashboard!$M121*R7","v":0},{"$f":"-Dashboard!$M121*S7","v":0},{"$f":"-Dashboard!$M121*T7","v":0},{"$f":"-Dashboard!$M121*U7","v":0},{"$f":"-Dashboard!$M121*V7","v":0},{"$f":"-Dashboard!$M121*W7","v":0},{"$f":"-Dashboard!$M121*X7","v":0}]
[null,"Δ Kosten ontheffingen",null,null,null,null,{"$f":"NPV(Discontovoet,J87:X87)+I87","v":0},0,{"$f":"-Dashboard!$M122*I7","v":0},{"$f":"-Dashboard!$M122*J7","v":0},{"$f":"-Dashboard!$M122*K7","v":0},{"$f":"-Dashboard!$M122*L7","v":0},{"$f":"-Dashboard!$M122*M7","v":0},{"$f":"-Dashboard!$M122*N7","v":0},{"$f":"-Dashboard!$M122*O7","v":0},{"$f":"-Dashboard!$M122*P7","v":0},{"$f":"-Dashboard!$M122*Q7","v":0},{"$f":"-Dashboard!$M122*R7","v":0},{"$f":"-Dashboard!$M122*S7","v":0},{"$f":"-Dashboard!$M122*T7","v":0},{"$f":"-Dashboard!$M122*U7","v":0},{"$f":"-Dashboard!$M122*V7","v":0},{"$f":"-Dashboard!$M122*W7","v":0},{"$f":"-Dashboard!$M122*X7","v":0}]
[null,"Δ Brandstofprijs",null,null,null,null,0,0,0,{"$f":"-Inzet_voertuig_Alt2*J7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*K7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*L7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*M7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*N7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*O7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*P7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*Q7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*R7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*S7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*T7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*U7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*V7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*W7/100*Dashboard!$M93*Dashboard!$M123","v":0},{"$f":"-Inzet_voertuig_Alt2*X7/100*Dashboard!$M93*Dashboard!$M123","v":0}]
[null,"Rentesubsidies",null,null,null,null,0,0,0,{"$f":"I74*(Rente_reeel-zachte_rente_reeel2)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Kasstroom nieuwe maatregelen",null,null,null,null,0,{"$f":"SUM(H84:H89)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(X85:X89)","v":0}]
[]
[null,"Totaal kasstroom maatregelen",null,null,null,null,{"$f":"NPV(Discontovoet,J92:X92)+I92","v":0},{"$f":"SUM(I92:X92)","v":0},{"$f":"I82+I90","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Emissies",null,null,null,null,"Contant","Totaal",{"$f":"I32","v":0},1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[]
[null,"Nominaal"]
[]
[null,{"$f":"Dashboard!U$63&\" emissie CO2 (\"&CO2_weight&\"/jaar)\"","v":"WtW emissie CO2 (ton/jaar)"},null,null,null,null,null,null,null,{"$f":"IF(J94>Dashboard!$M91,I98*J7,(J21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(K94>Dashboard!$M91,J98*K7,(K21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(L94>Dashboard!$M91,K98*L7,(L21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(M94>Dashboard!$M91,L98*M7,(M21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(N94>Dashboard!$M91,M98*N7,(N21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(O94>Dashboard!$M91,N98*O7,(O21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(P94>Dashboard!$M91,O98*P7,(P21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(Q94>Dashboard!$M91,P98*Q7,(Q21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(R94>Dashboard!$M91,Q98*R7,(R21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(S94>Dashboard!$M91,R98*S7,(S21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(T94>Dashboard!$M91,S98*T7,(T21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(U94>Dashboard!$M91,T98*U7,(U21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(V94>Dashboard!$M91,U98*V7,(V21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(W94>Dashboard!$M91,V98*W7,(W21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0},{"$f":"IF(X94>Dashboard!$M91,W98*X7,(X21/100)*Dashboard!$M93*Dashboard!$M99)*CO2_factor","v":0}]
[null,"Kosten CO2 emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J98*Kosten_CO2*CO2_factor_EUR","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"Dashboard!U$64&\" emissie NOx (\"&NOx_weight&\"/jaar)\"","v":"TtW emissie NOx (kg/jaar)"},null,null,null,null,null,null,null,{"$f":"IF(J94>Dashboard!$M91,I101*J7,(J21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(K94>Dashboard!$M91,J101*K7,(K21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(L94>Dashboard!$M91,K101*L7,(L21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(M94>Dashboard!$M91,L101*M7,(M21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(N94>Dashboard!$M91,M101*N7,(N21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(O94>Dashboard!$M91,N101*O7,(O21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(P94>Dashboard!$M91,O101*P7,(P21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(Q94>Dashboard!$M91,P101*Q7,(Q21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(R94>Dashboard!$M91,Q101*R7,(R21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(S94>Dashboard!$M91,R101*S7,(S21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(T94>Dashboard!$M91,S101*T7,(T21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(U94>Dashboard!$M91,T101*U7,(U21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(V94>Dashboard!$M91,U101*V7,(V21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(W94>Dashboard!$M91,V101*W7,(W21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0},{"$f":"IF(X94>Dashboard!$M91,W101*X7,(X21/100)*Dashboard!$M93*Dashboard!$M100)*NOx_factor","v":0}]
[null,"Kosten NOx emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J101*Kosten_NOx*NOx_factor_EUR","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,{"$f":"Dashboard!U$65&\" emissie PM (\"&PM_weight&\"/jaar)\"","v":"TtW emissie PM (dag/jaar)"},null,null,null,null,null,null,null,{"$f":"IF(J94>Dashboard!$M91,I104*J7,(J21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":187.2},{"$f":"IF(K94>Dashboard!$M91,J104*K7,(K21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":187.2},{"$f":"IF(L94>Dashboard!$M91,K104*L7,(L21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":187.2},{"$f":"IF(M94>Dashboard!$M91,L104*M7,(M21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":187.2},{"$f":"IF(N94>Dashboard!$M91,M104*N7,(N21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":187.2},{"$f":"IF(O94>Dashboard!$M91,N104*O7,(O21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":187.2},{"$f":"IF(P94>Dashboard!$M91,O104*P7,(P21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":187.2},{"$f":"IF(Q94>Dashboard!$M91,P104*Q7,(Q21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":187.2},{"$f":"IF(R94>Dashboard!$M91,Q104*R7,(R21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":187.2},{"$f":"IF(S94>Dashboard!$M91,R104*S7,(S21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":187.2},{"$f":"IF(T94>Dashboard!$M91,S104*T7,(T21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":0},{"$f":"IF(U94>Dashboard!$M91,T104*U7,(U21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":0},{"$f":"IF(V94>Dashboard!$M91,U104*V7,(V21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":0},{"$f":"IF(W94>Dashboard!$M91,V104*W7,(W21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":0},{"$f":"IF(X94>Dashboard!$M91,W104*X7,(X21/100)*Dashboard!$M93*Dashboard!$M101)*PM_factor","v":0}]
[null,"Kosten PM emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J104*Kosten_PM*PM_factor_EUR","v":1095.1200000000001},1095.1200000000001,1095.1200000000001,1095.1200000000001,1095.1200000000001,1095.1200000000001,1095.1200000000001,1095.1200000000001,1095.1200000000001,1095.1200000000001,0,0,0,0,0]
[]
[null,{"$f":"\"emissie geluid (× 10^\"&noise_weight&\" dBh)\"","v":"emissie geluid (× 10^4 dBh)"},null,null,null,null,null,null,null,{"$f":"Referentie!J107  *  10^((Dashboard!$M$102-Dashboard!$I$102)/10) * (J26/Referentie!J26)","v":1.4834600281436017},{"$f":"J107*K$7","v":1.4834600281436017},1.4834600281436017,1.4834600281436017,1.4834600281436017,1.4834600281436017,1.4834600281436017,1.4834600281436017,1.4834600281436017,1.4834600281436017,0,0,0,0,0]
[null,"Kosten emissie geluid (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"Referentie!J108  *  10^((Dashboard!$M$102-Dashboard!$I$102)/10) * (J26/Referentie!J26)","v":122.67073309649014},{"$f":"J108*K$7","v":122.67073309649014},122.67073309649014,122.67073309649014,122.67073309649014,122.67073309649014,122.67073309649014,122.67073309649014,122.67073309649014,122.67073309649014,0,0,0,0,0]
[]
[null,{"$f":"\"Totale emissie ten opzichte van 1 referentievoertuig *)\"","v":"Totale emissie ten opzichte van 1 referentievoertuig *)"}]
[]
[null,{"$f":"Dashboard!U$63&\" emissie CO2 (\"&CO2_weight&\"/jaar)\"","v":"WtW emissie CO2 (ton/jaar)"},null,null,null,null,null,null,null,{"$f":"J98/($J$21/Referentie!$J$21)-Referentie!J98","v":-16.149999999999999},{"$f":"J112*K$7","v":-16.149999999999999},{"$f":"K112*L$7","v":-16.149999999999999},-16.149999999999999,-16.149999999999999,-16.149999999999999,-16.149999999999999,-16.149999999999999,-16.149999999999999,-16.149999999999999,0,0,0,0,0]
[null,"Kosten CO2 emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J99/($J$21/Referentie!$J$21)-Referentie!J99","v":-419.9},{"$f":"J113*K$7","v":-419.9},-419.9,-419.9,-419.9,-419.9,-419.9,-419.9,-419.9,-419.9,0,0,0,0,0]
[]
[null,{"$f":"Dashboard!U$64&\" emissie NOx (\"&NOx_weight&\"/jaar)\"","v":"TtW emissie NOx (kg/jaar)"},null,null,null,null,null,null,null,{"$f":"J101/($J$21/Referentie!$J$21)-Referentie!J101","v":-10.305},{"$f":"J115*K$7","v":-10.305},{"$f":"K115*L$7","v":-10.305},-10.305,-10.305,-10.305,-10.305,-10.305,-10.305,-10.305,0,0,0,0,0]
[null,"Kosten NOx emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J102/($J$21/Referentie!$J$21)-Referentie!J102","v":-113.35499999999999},{"$f":"J116*K$7","v":-113.35499999999999},-113.35499999999999,-113.35499999999999,-113.35499999999999,-113.35499999999999,-113.35499999999999,-113.35499999999999,-113.35499999999999,-113.35499999999999,0,0,0,0,0]
[]
[null,{"$f":"Dashboard!U$65&\" emissie PM (\"&PM_weight&\"/jaar)\"","v":"TtW emissie PM (dag/jaar)"},null,null,null,null,null,null,null,{"$f":"J104/($J$21/Referentie!$J$21)-Referentie!J104","v":-22.499999999999972},{"$f":"J118*K$7","v":-22.499999999999972},{"$f":"K118*L$7","v":-22.499999999999972},-22.499999999999972,-22.499999999999972,-22.499999999999972,-22.499999999999972,-22.499999999999972,-22.499999999999972,-22.499999999999972,0,0,0,0,0]
[null,"Kosten PM emissie (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J105/($J$21/Referentie!$J$21)-Referentie!J105","v":-131.62499999999966},{"$f":"J119*K$7","v":-131.62499999999966},-131.62499999999966,-131.62499999999966,-131.62499999999966,-131.62499999999966,-131.62499999999966,-131.62499999999966,-131.62499999999966,-131.62499999999966,0,0,0,0,0]
[]
[null,{"$f":"\"emissie geluid (× 10^\"&noise_weight&\" dBh)\"","v":"emissie geluid (× 10^4 dBh)"},null,null,null,null,null,null,null,{"$f":"J107/($J$21/Referentie!$J$21)-Referentie!J107","v":-9.1637833098803316},{"$f":"J121*K$7","v":-9.1637833098803316},{"$f":"K121*L$7","v":-9.1637833098803316},-9.1637833098803316,-9.1637833098803316,-9.1637833098803316,-9.1637833098803316,-9.1637833098803316,-9.1637833098803316,-9.1637833098803316,0,0,0,0,0]
[null,"Kosten emissie geluid (EUR/jaar)",null,null,null,null,null,null,null,{"$f":"J108/($J$21/Referentie!$J$21)-Referentie!J108","v":-757.77438908625822},{"$f":"J122*K$7","v":-757.77438908625822},-757.77438908625822,-757.77438908625822,-757.77438908625822,-757.77438908625822,-757.77438908625822,-757.77438908625822,-757.77438908625822,-757.77438908625822,0,0,0,0,0]
[]
[null,{"$f":"\" *) het equivalent van 1 referentievoertuig is \"&ROUND(1/I12,2)&\" alternatief 2 voertuig(en)\"","v":" *) het equivalent van 1 referentievoertuig is 0,83 alternatief 2 voertuig(en)"}]
[]
[null,"Gemonetariseerd",null,null,null,null,"Contant","Totaal"]
[]
[null,"Emissiewinst",null,null,null,null,{"$f":"NPV(Discontovoet,J128:X128)+I128","v":11539.001479920635},{"$f":"SUM(I128:X128)","v":14226.543890862578},0,{"$f":"-1*(J113+J116+J119+J122)","v":1422.6543890862579},{"$f":"-1*(K113+K116+K119+K122)","v":1422.6543890862579},1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,0,0,0,0,0]
[null,"Nieuwe maatregelen (excl. MIA/VAMIL) (-)",null,null,null,null,{"$f":"NPV(Discontovoet,J129:X129)+I129","v":0},{"$f":"SUM(I129:X129)","v":0},{"$f":"-I90","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Resultaat",null,"IRR:",{"$f":"IFERROR((1+IRR(I130:X130))*(1+Inflatie)-1,\"n.v.t.\")","v":"n.v.t."},null,{"$f":"NPV(Discontovoet,J130:X130)+I130","v":11539.001479920635},{"$f":"SUM(I130:X130)","v":14226.543890862578},{"$f":"SUM(I128:I129)","v":0},{"$f":"SUM(J128:J129)","v":1422.6543890862579},1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,0,0,0,0,0]
[]
[null,"Emissiewinst",null,null,null,null,{"$f":"NPV(Discontovoet,J132:X132)+I132","v":11539.001479920635},{"$f":"SUM(I132:X132)","v":14226.543890862578},0,{"$f":"J128","v":1422.6543890862579},{"$f":"K128","v":1422.6543890862579},1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,0,0,0,0,0]
[null,"Alle maatregelen (incl. MIA/VAMIL) (-)",null,null,null,null,{"$f":"NPV(Discontovoet,J133:X133)+I133","v":0},{"$f":"SUM(I133:X133)","v":0},{"$f":"-I92","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Resultaat",null,"IRR:",{"$f":"IFERROR((1+IRR(I134:X134))*(1+Inflatie)-1,\"n.v.t.\")","v":"n.v.t."},null,{"$f":"NPV(Discontovoet,J134:X134)+I134","v":11539.001479920635},{"$f":"SUM(I134:X134)","v":14226.543890862578},{"$f":"SUM(I132:I133)","v":0},{"$f":"SUM(J132:J133)","v":1422.6543890862579},1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,1422.6543890862579,0,0,0,0,0]

{"sheet":"Info en copyright","index":6,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,"LIBIT [fuel distribution focus]"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"EIBIT [fuel consumption focus] is provided as a professional tool for the purpose of electric commercial vehicles business case analysis, for use by all parties directly or indirectely involved in electric vehicle decision-making, policy-making, developing, operating or funding. EIBIT [fuel consumption focus] is a calculation tool for which there is absolutely no guarantee or warranty of fitness for a particular purpose or any purpose expressed or implied. Any user of information contained herein assumes any and all responsibility and liability for use of the information including any misunderstanding, misuse or misapplication of the information or algorithms."]
[null,null,null,null,null,null,null,"Any use of EIBIT [fuel consumption focus] is 'as is' and should only follow the user’s independent confirmation that it produces valid results for the user before results are used for any purpose whatsoever."]
[null,null,null,null,null,null,null,"In no event shall Infram be liable for any incorrect or invalid results that are obtained by any use of EIBIT [fuel consumption focus] nor shall Infram be liable for any loss of data, or profits or special, incidental, indirect or consequential damages arising out of or in connection with the use or performance of EIBIT [fuel consumption focus]. "]
[null,null,null,null,null,null,null,"© Copyright. EIBIT [fuel consumption focus] remains the intellectual property of Infram B.V. and is protected by international copyright laws. Any publication or distribution of the EIBIT [fuel consumption focus] model and template outside the scope of the permitted use of EIBIT [fuel consumption focus] is expressly prohibited. Permitted use is limited to using EIBIT [fuel consumption focus] in an unamended form to perform LNG bunker station business case calculations. EIBIT [fuel consumption focus] worksheet protection can be disabled without a password with the single purpose of enabling EIBIT [fuel consumption focus] users to verify EIBIT [fuel consumption focus] formulas. Any amendments and/or distribution of the EIBIT [fuel consumption focus] model  or template is expressly prohibited and represents an infringement of international copyright laws."]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"EIBIT [fuel consumption focus] is provided as a professional tool for the purpose of electric commercial vehicles business case analysis, for use by all parties directly or indirectely involved in electric vehicle decision-making, policy-making, developing, operating or funding. EIBIT [fuel consumption focus] is a calculation tool for which there is absolutely no guarantee or warranty of fitness for a particular purpose or any purpose expressed or implied. Any user of information contained herein assumes any and all responsibility and liability for use of the information including any misunderstanding, misuse or misapplication of the information or algorithms."]
[null,null,null,null,null,null,null,"Any use of EIBIT [fuel consumption focus] is 'as is' and should only follow the user’s independent confirmation that it produces valid results for the user before results are used for any purpose whatsoever."]
[null,null,null,null,null,null,null,"In no event shall Infram be liable for any incorrect or invalid results that are obtained by any use of EIBIT [fuel consumption focus] nor shall Infram be liable for any loss of data, or profits or special, incidental, indirect or consequential damages arising out of or in connection with the use or performance of EIBIT [fuel consumption focus]. "]
[null,null,null,null,null,null,null,"© Copyright. EIBIT [fuel consumption focus] remains the intellectual property of Infram B.V. and is protected by international copyright laws. Any publication or distribution of the EIBIT [fuel consumption focus] model and template outside the scope of the permitted use of EIBIT [fuel consumption focus] is expressly prohibited. Permitted use is limited to using EIBIT [fuel consumption focus] in an unamended form to perform LNG bunker station business case calculations. EIBIT [fuel consumption focus] worksheet protection can be disabled without a password with the single purpose of enabling EIBIT [fuel consumption focus] users to verify EIBIT [fuel consumption focus] formulas. Any amendments and/or distribution of the EIBIT [fuel consumption focus] model  or template is expressly prohibited and represents an infringement of international copyright laws."]