"Fuel Consumption" Spreadsheet

[siteguru]

Has anyone created a spreadsheet they can share that they use to record charges vs miles to yield efficiency and cost per mile results? I've created one myself but the bit I'm pondering how best to account for is partial charges. (i.e. current charge to 100% "fill" makes the calculation quite easy - it's when you do, say, a 20-80% charge that's giving me pause for thought).

TIA

Edit - this is what I have at the moment, but it doesn't account for partial charges. Data shown is merely example data and not based on any real results - I don't actually have my EV yet.

Date	Charge (kWh)	Mileage	Unit Cost	"Fill" Cost	Efficiency (mpkWh)	p per mile
14-Oct-22	45	170	£ 0.3376	£ 15.19	3.78	8.94

 

[Ian Key]

As you say it's not easy as unless you do a full charge it's not very accurate.
Perhaps another column for starting percentage and another for finishing percentage and then use the difference to work out the kWh used to work out the cost per mile. It will still only give a ball park figure but over time it will give you some idea.

 

[siteguru]

I was thinking re. the charge difference - i.e. amount of charge % (which is effectively the same thing).

Maybe I'm overthinking this.

 

[Aussi55]

Hi,

Not sure if it would help but I use an app called glovebox.

I started making a spreadsheet, but unlike the ones I made for ice cars, found it hard to figure out how best to record things.

Anyway, happy with the app so far.

GloveBox: Trip, gas and expens - Apps on Google Play

Log gas mileage, prices and expenses, see statistics and charts, get reminders.

play.google.com