{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["NL","FR","ENG"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"NL","index":0,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H14+365","v":"2014-10-01"},13,{"$f":"IF(L18>=L2,6%,0%)","v":0}]
[null,null,null,null,null,null,null,"ALLE ZWARTE VAKKEN INVULLEN AUB",null,null,{"$f":"K2+365","v":"2015-10-01"},{"$f":"L2+12","v":25},{"$f":"IF(L18>=L3,6%,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K3+365","v":"2016-09-30"},{"$f":"L3+12","v":37},{"$f":"IF(L18>=L4,6%,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"2017-09-30",{"$f":"L4+12","v":49},{"$f":"IF(L18>=L5,6%,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"2018-09-30",61,{"$f":"IF(L18>=L6,6%,0%)","v":0}]
["Cataloguswaarde op datum van 1ste inschrijving:",null,null,null,null,null,null,38731,null,null,"2019-09-30",73]
["(Gefactureerde waarde inclusief opties en werkelijk betaalde BTW,",null,null,null,null,null,null,null,null,null,"2020-09-29",85]
["zonder rekening te houden met enige korting, vermindering, rabat",null,null,null,null,null,null,null,null,null,"2021-09-29",97]
["of restorno toegekend door de lokale dealer)",null,null,null,null,null,null,null,null,null,"2022-09-29",109]
[null,null,null,null,null,null,null,null,null,null,"2023-09-29",121]
["Korting toegekend door importeur of constructeur:",null,null,null,null,null,null,0,null,null,{"$f":"H7+K13","v":38731},null,{"$f":"SUM(M2:M11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H12<=0,H12,-H12)","v":0}]
["Datum 1ste inschrijving:",null,null,null,null,"DD/MM/JJJJ",null,"2013-10-01",null,null,{"$f":"MONTH(H14)","v":10},{"$f":"YEAR(H14)","v":2013}]
[]
["Datum jaarafsluiting boekjaar:",null,null,null,null,"DD/MM/JJJJ",null,"2013-12-31",null,null,{"$f":"MONTH(H16)","v":12},{"$f":"YEAR(H16)","v":2013}]
[]
["Vermindering 6% per jaar vanaf 13de maand na aankoop:",null,null,null,null,null,null,{"$f":"-K12*M12","v":0},null,null,null,{"$f":"(K16-K14+1)+((L16-L14)*12)","v":3}]
[]
["Huidige fiscale waarde voor berekening VAA:",null,null,null,null,null,null,{"$f":"H7+K13+H18","v":38731}]
[]
["*6/7",null,null,null,null,null,null,{"$f":"H20*6/7","v":33198}]
[]
["CO2 uitstoot g/km:",null,null,null,null,null,null,109]
[]
["Brandstof: DIESEL = D, BENZINE (+ Hybride, LPG, aardgas) =B",null,null,null,null,null,null,"D"]
[]
["Referentiewaarde:",null,null,{"$f":"IF(H26=\"D\",95,116)","v":95},"g/km",null,null,5.5E-2]
["Vermeerdering/vermindering:",null,null,null,null,null,null,{"$f":"(H24-D28)*0.001","v":1.4E-2}]
["Effectief CO2 percentage:",null,null,null,null,null,null,{"$f":"IF(SUM(H28:H29)<=4%,4%,(IF(SUM(H28:H29)>=18%,18%,SUM(H28:H29))))","v":6.9000000000000006E-2}]
[]
["VAA jaarbasis:",null,null,null,null,null,null,{"$f":"IF(H7=0,0,IF(H22*H30<=1230,1230,H22*H30))","v":2290.6620000000003}]
[]
["VAA maandbasis:",null,null,null,null,null,null,{"$f":"H32/12","v":190.88850000000002}]

{"sheet":"FR","index":1,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H14+365","v":"1900-12-30"},13,{"$f":"IF(L18>=L2,6%,0%)","v":0}]
[null,null,null,null,null,null,null,"REMPLIR LES CELLULES NOIRES SVP",null,null,{"$f":"K2+365","v":"1901-12-30"},{"$f":"L2+12","v":25},{"$f":"IF(L18>=L3,6%,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K3+365","v":"1902-12-30"},{"$f":"L3+12","v":37},{"$f":"IF(L18>=L4,6%,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1903-12-30",{"$f":"L4+12","v":49},{"$f":"IF(L18>=L5,6%,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1904-12-29",61,{"$f":"IF(L18>=L6,6%,0%)","v":0}]
["Prix catalogue à la date de la première inscription:",null,null,null,null,null,null,null,null,null,"1905-12-29",73]
["(Valeur facturée options  et TVA réellement payée incluses, ",null,null,null,null,null,null,null,null,null,"1906-12-29",85]
["sans tenir compte de réductions, diminutions, rabais",null,null,null,null,null,null,null,null,null,"1907-12-29",97]
[" ou ristournes, obtenues par l'agent local)",null,null,null,null,null,null,null,null,null,"1908-12-28",109]
[null,null,null,null,null,null,null,null,null,null,"1909-12-28",121]
["Réduction accordée par l'importateur ou le constructeur: ",null,null,null,null,null,null,null,null,null,{"$f":"H7+K13","v":0},null,{"$f":"SUM(M2:M11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H12<=0,H12,-H12)","v":0}]
["Date 1ère inscription:",null,null,null,null,"JJ/MM/AAAA",null,null,null,null,{"$f":"MONTH(H14)","v":1},{"$f":"YEAR(H14)","v":1900}]
[]
["Date clôture année comptable:",null,null,null,null,"JJ/MM/AAAA",null,null,null,null,{"$f":"MONTH(H16)","v":1},{"$f":"YEAR(H16)","v":1900}]
[]
["Vermindering 6% per jaar vanaf 13de maand na aankoop:",null,null,null,null,null,null,{"$f":"-K12*M12","v":0},null,null,null,{"$f":"(K16-K14+1)+((L16-L14)*12)","v":1}]
[]
["Huidige fiscale waarde voor berekening VAA:",null,null,null,null,null,null,{"$f":"H7+K13+H18","v":0}]
[]
["*6/7",null,null,null,null,null,null,{"$f":"H20*6/7","v":0}]
[]
["Taux CO2 g/km:"]
[]
["Carburant: DIESEL = D, ESSENCE (+ Hybride, LPG, gaz naturel) =B",null,null,null,null,null,null,"B"]
[]
["Referentiewaarde:",null,null,{"$f":"IF(H26=\"D\",95,116)","v":116},"g/km",null,null,5.5E-2]
["Vermeerdering/vermindering:",null,null,null,null,null,null,{"$f":"(H24-D28)*0.001","v":-0.11600000000000001}]
["Effectief CO2 percentage:",null,null,null,null,null,null,{"$f":"IF(SUM(H28:H29)<=4%,4%,(IF(SUM(H28:H29)>=18%,18%,SUM(H28:H29))))","v":0.04}]
[]
["ATN annuel:",null,null,null,null,null,null,{"$f":"IF(H7=0,0,IF(H22*H30<=1230,1230,H22*H30))","v":0}]
[]
["ATN mensuel:",null,null,null,null,null,null,{"$f":"H32/12","v":0}]

{"sheet":"ENG","index":2,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H14+365","v":"1900-12-30"},13,{"$f":"IF(L18>=L2,6%,0%)","v":0}]
[null,null,null,null,null,null,null,"FILL OUT THE BLACK CELLS PLEASE ",null,null,{"$f":"K2+365","v":"1901-12-30"},{"$f":"L2+12","v":25},{"$f":"IF(L18>=L3,6%,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"K3+365","v":"1902-12-30"},{"$f":"L3+12","v":37},{"$f":"IF(L18>=L4,6%,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1903-12-30",{"$f":"L4+12","v":49},{"$f":"IF(L18>=L5,6%,0%)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"1904-12-29",61,{"$f":"IF(L18>=L6,6%,0%)","v":0}]
["Catalog value at date of the first inscription:",null,null,null,null,null,null,null,null,null,"1905-12-29",73]
["(invoice value including options and VAT really paid,",null,null,null,null,null,null,null,null,null,"1906-12-29",85]
["without taking into account any discount, reduction or rebate",null,null,null,null,null,null,null,null,null,"1907-12-29",97]
["obtained from the local agent)",null,null,null,null,null,null,null,null,null,"1908-12-28",109]
[null,null,null,null,null,null,null,null,null,null,"1909-12-28",121]
["Reduction obtained from importer or constructor:",null,null,null,null,null,null,null,null,null,{"$f":"H7+K13","v":0},null,{"$f":"SUM(M2:M11)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H12<=0,H12,-H12)","v":0}]
["Date 1st inscription:",null,null,null,null,"DD/MM/YYYY",null,null,null,null,{"$f":"MONTH(H14)","v":1},{"$f":"YEAR(H14)","v":1900}]
[]
["Date year-end closing financial year:",null,null,null,null,"DD/MM/YYYY",null,null,null,null,{"$f":"MONTH(H16)","v":1},{"$f":"YEAR(H16)","v":1900}]
[]
["Vermindering 6% per jaar vanaf 13de maand na aankoop:",null,null,null,null,null,null,{"$f":"-K12*M12","v":0},null,null,null,{"$f":"(K16-K14+1)+((L16-L14)*12)","v":1}]
[]
["Huidige fiscale waarde voor berekening VAA:",null,null,null,null,null,null,{"$f":"H7+K13+H18","v":0}]
[]
["*6/7",null,null,null,null,null,null,{"$f":"H20*6/7","v":0}]
[]
["CO2 rate g/km:"]
[]
["Fuel: DIESEL = D, GASOLINE (+ Hybride, LPG, natural gaz) =B"]
[]
["Referentiewaarde:",null,null,{"$f":"IF(H26=\"D\",95,116)","v":116},"g/km",null,null,5.5E-2]
["Vermeerdering/vermindering:",null,null,null,null,null,null,{"$f":"(H24-D28)*0.001","v":-0.11600000000000001}]
["Effectief CO2 percentage:",null,null,null,null,null,null,{"$f":"IF(SUM(H28:H29)<=4%,4%,(IF(SUM(H28:H29)>=18%,18%,SUM(H28:H29))))","v":0.04}]
[]
["AIK yearly basis:",null,null,null,null,null,null,{"$f":"IF(H7=0,0,IF(H22*H30<=1230,1230,H22*H30))","v":0}]
[]
["AIK monthly basis:",null,null,null,null,null,null,{"$f":"H32/12","v":0}]