{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Input","Output"],"not_rendered":{"images":2,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[7,2,7,4],[8,4,8,5]]}
[]
[]
[]
[]
[null,"Kostenvergelijking"]
[null," Elektrische auto vs. brandstof auto"]
[]
[null,null,"Vul de lichtblauwe cellen in om te berekenen wat voor jou de voordeligste optie is. Klik daarna op de knop \"Start\" om de berekening te starten. "]
[]
[null,null,"Gegevens",null,"Elektrisch",null,"Brandstof"]
[]
[]
[null,null,"FUNCTIONALITEITEN"]
[null,null,"Merk, model en type",null,"Skoda Citigo Ambition",null,"VW up Basis"]
[null,null,"Motorinhoud (KWH / CC)",null,38,null,{"v":1000,"d":"1,000"}]
[null,null,"Vermogen KwH / pk",null,"60 / 83",null,"48 / 65"]
[null,null,"Topsnelheid km / uur",null,130,null,163]
[null,null,"Actieradius in km",null,260,null,650]
[null,null,"Afmetingen",null,"conform up",null,"conform Citigo"]
[null,null,"Accessoires:"]
[{"$nulls":3},"Automaat","traploos",null,"niet leverbaar"]
[{"$nulls":3},"verwarming / koeling","climate control",null,"nee"]
[{"$nulls":3},"cruise control","ja",null,"ja"]
[{"$nulls":3},"navigatie","Skoda app",null,"VW app"]
[]
[null,null,"KOSTEN"]
[null,null,"Cataloguswaarde",null,{"v":23290,"d":"€ 23,290.00"},null,{"v":15925,"d":"€ 15,925.00"}]
[null,null,"Totaal bedrag accessoires",null,{"v":600,"d":"€ 600.00"},null,{"v":1234,"d":"€ 1,234.00"}]
[null,null,"Totaal per jaar te rijden km's",null,{"v":20000,"d":"20,000"},null,{"v":20000,"d":"20,000"}]
[null,null,"Leaseprijs (10.000 km / 5 jaar / max. no-claim)",null,{"v":369,"d":"€ 369.00"},null,{"v":309,"d":"€ 309.00"}]
[null,null,"Meerprijs per km",null,{"v":0.05,"d":"€ 0.05"},null,{"v":0.06,"d":"€ 0.06"}]
[null,null,"KwH  / brandstofprijs",null,0.25,null,{"v":1.6,"d":"1.60"}]
[null,null,"Km per KwH / liter brandstof",null,{"v":7,"d":"7.00"},null,{"v":20,"d":"20.00"}]

{"sheet":"Output","index":1,"n_rows":50,"n_cols":7,"rows_kept":50,"merged":[[9,4,9,5],[10,4,10,5]]}
[]
[]
[]
[]
[null,"Kostenvergelijking"]
[null," Elektrische auto vs. brandstof auto"]
[]
[]
[{"$nulls":3},"Voordeligste optie",{"$f":"IF(E21-G21<0,\"Elektrisch \",\"Brandstof\")","v":"Elektrisch "}]
[{"$nulls":3},"Verschil op jaarbasis",{"$f":"IF((E21-G21)<0,((E21-G21)*-1)*12,(E21-G21)*12)","v":{"v":265.714285714286,"d":"€ 266"}}]
[{"$nulls":3},"Besparing na 5 jaar",{"$f":"Output!E10*5","v":{"v":1328.57142857143,"d":"€ 1,329"}}]
[]
[]
[null,null,"Gegevens",null,"Elektrisch",null,"Brandstof"]
[]
[{"$nulls":4},"€",null,"€"]
[null,null,"UITKOMST"]
[null,null,"Leaseprijs (10.000 km / 5 jaar / max. no-claim)",null,{"$f":"Input!E30","v":369},null,{"$f":"Input!G30","v":309}]
[null,null,"Leasekosten per maand voor de extra km",null,{"$f":"+Output!$E41*Input!E31/12","v":{"v":41.666666666666664,"d":"42"}},null,{"$f":"+Output!$E41*Input!G31/12","v":50}]
[null,null,"Energie / brandstofkosten per maand voor alle km's",null,{"$f":"+Input!$E29/12*E43","v":{"v":59.523809523809526,"d":"60"}},null,{"$f":"+Input!$E29/12*G43","v":{"v":133.33333333333334,"d":"133"}}]
[null,null,"Totale kosten per maand",null,{"$f":"SUM(E18:E20)","v":{"v":470.1904761904762,"d":"470"}},null,{"$f":"SUM(G18:G20)","v":{"v":492.33333333333337,"d":"492"}}]
[]
[null,null,"FUNCTIONALITEITEN"]
[null,null,"Merk, model en type",null,{"$f":"Input!E14","v":"Skoda Citigo Ambition"},null,{"$f":"Input!G14","v":"VW up Basis"}]
[null,null,"Motorinhoud (KWH / CC)",null,{"$f":"Input!E15","v":38},null,{"$f":"Input!G15","v":{"v":1000,"d":"1,000"}}]
[null,null,"Vermogen KwH / pk",null,{"$f":"Input!E16","v":"60 / 83"},null,{"$f":"Input!G16","v":"48 / 65"}]
[null,null,"Topsnelheid km / uur",null,{"$f":"Input!E17","v":130},null,{"$f":"Input!G17","v":163}]
[null,null,"Actieradius in km",null,{"$f":"Input!E18","v":260},null,{"$f":"Input!G18","v":650}]
[null,null,"Afmetingen",null,{"$f":"Input!E19","v":"conform up"},null,{"$f":"Input!G19","v":"conform Citigo"}]
[null,null,"Accessoires:"]
[{"$nulls":3},"Automaat",{"$f":"Input!E21","v":"traploos"},null,{"$f":"Input!G21","v":"niet leverbaar"}]
[{"$nulls":3},"verwarming / koeling",{"$f":"Input!E22","v":"climate control"},null,{"$f":"Input!G22","v":"nee"}]
[{"$nulls":3},"cruise control",{"$f":"Input!E23","v":"ja"},null,{"$f":"Input!G23","v":"ja"}]
[{"$nulls":3},"navigatie",{"$f":"Input!E24","v":"Skoda app"},null,{"$f":"Input!G24","v":"VW app"}]
[]
[null,null,"KOSTEN"]
[null,null,"Cataloguswaarde",null,{"$f":"Input!E27","v":{"v":23290,"d":"23,290"}},null,{"$f":"Input!G27","v":{"v":15925,"d":"15,925"}}]
[null,null,"Totaal bedrag accessoires",null,{"$f":"Input!E28","v":600},null,{"$f":"Input!G28","v":{"v":1234,"d":"1,234"}}]
[null,null,"Totaal per jaar te rijden km's",null,{"$f":"Input!E29","v":{"v":20000,"d":"20,000"}},null,{"$f":"Input!G29","v":{"v":20000,"d":"20,000"}}]
[null,null,"Aantal km's in de basis leaseprijs",null,{"v":10000,"d":"10,000"},null,{"v":10000,"d":"10,000"}]
[null,null,"Extra km's",null,{"$f":"E39-E40","v":{"v":10000,"d":"10,000"}},null,{"$f":"G39-G40","v":{"v":10000,"d":"10,000"}}]
[null,null,"Meerprijs per km",null,{"$f":"Input!E31","v":0.05},null,{"$f":"Input!G31","v":0.06}]
[null,null,"Elektra / brandstofkosten per km",null,{"$f":"+Input!E32/Input!E33","v":{"v":0.03571428571428571,"d":"0.04"}},null,{"$f":"+Input!G32/Input!G33","v":0.08}]
[null,null,"KwH  / brandstofprijs",null,{"$f":"Input!E32","v":0.25},null,{"$f":"Input!G32","v":{"v":1.6,"d":"1.60"}}]
[null,null,"Km per KwH / liter brandstof",null,{"$f":"Input!E33","v":{"v":7,"d":"7.00"}},null,{"$f":"Input!G33","v":{"v":20,"d":"20.00"}}]
[]
[null,null,"Niet meegenomen in de berekening:"]
[{"$nulls":3},"- kosten laadpaal thuis"]
[{"$nulls":3},"- voordeel eigen zonnepanelen"]
[{"$nulls":3},"- laden bij dure snelladers"]