Excel file with Charging values( kWh and Prices) km done with a charge; and costs comparison

[PvinSan]

Hi,

Just sharing an Excel file I've built that calculates charging prices; compares prices based on distance made between charge, calculates average kWh prices per km per 100km , calculates the average km per kWh.
It also compares the prices of Gas/diesel Equivalent ( full tank; or the distance done between charges) to a full Charging; to the distance made on the current charge, etc....
The columns headers might be a bit confuse ( but they work for me;
Its devised in Three Main Sheets ( for data input) and two information sheets
Hope it helps some one else....

Some Remarks :

The file is a made for Kilometers and many calculus is based on this ( per 100km/h for example) ... IF you want to ADAPT to MILES PLEASE GO AHEAD - AND CHECK-CHANGE all the formulas !!!!!!!!! The file can be changed/shared and used for NON commercial purpose . - based on CreativeCommons license BY-NC-SA 4.0. To view a copy of this license, visit CC BY-NC-SA 4.0 Deed | Attribution-NonCommercial-ShareAlike 4.0 International | Creative Commons

Also have it in ODS format ( libreoffice - but xlsx was exported without any conversion erros from it)

 

[jrbeire]

Thanks for the initiative - would you share the .ods too please?

 

[PvinSan]

cannot share it in the thread ( unknnown extension).PM

 

[siteguru]

Upload to Dropbox or similar and share the link in a reply here? ?‍

 

[Tig170]

cannot share it in the thread ( unknnown extension).PM

having said that the excel version is clickable?

 

[Rip Van]

Thanks for the initiative - would you share the .ods too please?

Change it in "save as type".

 

[PvinSan]

having said that the excel version is clickable?

you can download it directly from this thread...

For the ODS file - > copy paste this link: :drive.google.com/file/d/1BnRoIuMYOcpvj8yvI8dRTs5-kPgy9LAl/view?usp=sharing
If I create the link here it auto opens gdrive view

 

[PvinSan]

Upload to Dropbox or similar and share the link in a reply here? ?‍

ODS File :
drive.google.com/file/d/1BnRoIuMYOcpvj8yvI8dRTs5-kPgy9LAl
OK got it - my mistake in mgev edit mode

now ok !