Keeping track of my MG4 (efficiency)

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?
 
MattyS said:
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?
Click to expand...
You 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:
XWoaiBa.png
 
Last edited:
MG4JP said:
You 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:
LvxiXOX.png
Click to expand...
AHH that's brilliant thanks 👍 I'll add that to my sheet
 
First post updated, with March's data:


PeriodDistance (km)Efficiency (kWh/100km)Average Speed (km/h)Up Time
March 2025169714.9 (4.17 mi/kWh)3547:58

Current overall combined efficiency: 15.2 kWh/100km (4.10 mi/kWh)
 
Screen Shot 2025-04-02 at 6.38.52 am.webp


Economy for March was much worse than usual as I did a lot of towing (we moved home). I'd say there would be something like 1,200 km of towing work in that.

Costs are also up as I have been charging with grid power at the new place and I need new utility smart metering to get access to cheap grid charging rates, plus there is no solar PV either (which I will be adding before long). New meter scheduled to be installed on 8 April and I should be changing electricity plans very soon.

I brought over our ZJBeny OCPP 7 kW charge station, sparky costs for the removal and reinstall were $217. Fortunately it was a pretty simple installation at the new place.
 
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.
 
Rolfe said:
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.
Click to expand...
I account for things like discharging V2L - that gets removed.

In the end though it's just an expression of how you use your car.
 
I have always had an MPG spreadsheet - well since I earnt enough to fill my car up whenever I go to the petrol station.

The biggest issue I have is adding charge only to 80% (or a different percentage). Now I can just add some charges together, but if I only charge to 100% once in a blue moon, what's the point of knowing my stats once every 125 days (say!) rather than every 2-3 weeks when I'd usually have 'filled up'.
I'm still doing it (old habit die hard) but it is all a bit of a mess...

1743925397795.webp
 
This is how I've done it so far might add mpge too
 

Attachments

  • Screenshot_2025-04-06-09-20-36-512_com.google.android.apps.docs.editors.sheets-edit.webp
    Screenshot_2025-04-06-09-20-36-512_com.google.android.apps.docs.editors.sheets-edit.webp
    19.7 KB · Views: 10
SBJames said:
The biggest issue I have is adding charge only to 80%
Click to expand...
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).

Another couple of things thing to note:
The GOM is always changing estimates of range so make sure all calculations are against actual miles travelled.
There are losses between what a charger supplies and what reaches the battery, so unless you are using an actual charge figures from the battery the kWh supplied will not be what the battery has received.
The amount of charge each battery cell thinks it can receive changes depending when the last equalisation charge took place.
 
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
 
LenEV2016 said:
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
Click to expand...

Absolutely, totally agree. 🙂👍
 
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.
 
MG4JP said:
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.
Click to expand...

Fair enough. If that's what you want to do.
Each to there own. 🙂👍
 
MG4JP said:
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.
Click to expand...
As you say it all comes to down to what you are interested in, I feel the same about whisky, beer and rugby😁
 
The GOM is particularly frustrating, one example would be when efficiency increases yet the estimated range reduces. For example, Monday averaged 3.4m/kWh and remaining range estimate when I parked up for the day was 160 miles, Tuesday, drove 12 miles at an average of 4.2 and the GOM advises there's now 136 miles left, aaarrrgghh! I'd rather just see battery % remaining as I'm too lazy to do the maths (mulitply by 2 works as a safe approximation) :ROFLMAO:
 

Are you enjoying your MG4?

  • Yes

    Votes: 930 77.6%

  • I'm in the middle

    Votes: 177 14.8%

  • No

    Votes: 91 7.6%
See comments…
Support us by becoming a Premium Member

Latest MG EVs video

MG ZS EV Retrospective & First Look at the MG S5 EV | Live Q&A with Owners & MGEVs Panel
Published
Subscribe to our YouTube channel
Back
Top Bottom