MattyS
Established Member
I do love a good spreadsheet. I'd love to set something like this up but I find my data gets reset each time I restart the car...is there a way to pull the data out filtering by month/week/data range on the car?
You can scroll through 3 counters in total*: "From Start", "From last charge" and "Accumulated Total".I do love a good spreadsheet. I'd love to set something like this up but I find my data gets reset each time I restart the car...is there a way to pull the data out filtering by month/week/data range on the car?
AHH that's brilliant thanksYou can scroll through 3 counters in total*: "From Start", "From last charge" and "Accumulated Total".
"From Start" will reset each time you start the car (if half an hour or more has passed since the last start, otherwise it will keep going);
"From last charge" will reset every time you plug-in the car, even if not reaching 100% charge.
"Accumulated Total" will only reset by demand - or if 99 hours and 59 minutes of running time have gone by, in which case it will reset itself automatically.
Because of this last point, I now reset "Accumulated Total" each month.
*To be able to scroll, press the button circled below and then use the up/down arrows:
![]()
Period | Distance (km) | Efficiency (kWh/100km) | Average Speed (km/h) | Up Time |
---|---|---|---|---|
March 2025 | 1697 | 14.9 (4.17 mi/kWh) | 35 | 47:58 |
I account for things like discharging V2L - that gets removed.One thing that makes me not bother about any of this is that I use the power in the car for many things. Pre-heating the battery. Pre-heating the cabin. Boiling the kettle. Keeping the car warm while sleeping in it overnight, and so on. All that, especially the last, plays havoc with any calculations.
Not sure why this would be an issue. You would never get an exact 100% fill in a fuel tank and the other metric with fuel is the amount of weight it adds to the car. 60 litres is around 43.2kg. Which would mean your calculations should adjust as the tank empties.(To be fair I never did this in all my MPG spreadsheets over the years).The biggest issue I have is adding charge only to 80%
I take my hat off to all the members who have the patience to monitor this continuously, for me when I switched to an EV several years ago (now on my third) I do nothing different to when I owned my ice cars, I drive at exactly the same speeds, heat it when it needs it, cool it when it needs it and fuel it when it needs it.
It's just that's it's easier and cheaper to fuel now and a more relaxing drive.
Even on really long journeys I can't be arsed with going slow or getting cold or hot just to get a few extra miles drive as I always have.
Not a dig at anyone that does but it does kind of add to the anti EV idiots arguements when they bring it up as reasons against EVs
Keeping track of a car's mileage and its economy has been around forever and is actually part of a car/engine data sheet for decades.
It all comes down to being interested in such data or not caring about it at all - not sure being an EV or ICE has anything to do with it in the end.
In my particular case, I do this because I find it interesting and also because it helps when planning longer journeys - stopping mid-journey for charging can be quite a hassle where I come from and may easily mess up your travelling plans.
Also, as a side note, I don't actually care how much my car is spending, as I don't pay for the electricity that goes into it. I'm just interested in this kind of data and want to get to know my car (and the EV world) the best I can.
As you say it all comes to down to what you are interested in, I feel the same about whisky, beer and rugbyIt all comes down to being interested in such data or not caring about it at all - not sure being an EV or ICE has anything to do with it in the end.