OK, there is a lot to unpack here and I need to do a bit more work and research. There are entire industries trying to solve this problem, and we are not going to do it with an OBDII and MS Excel... However, this is not completely unreasonable as a fun "dartboard" prediction tool and I applaud Ray for this effort. The best part is you can track it's accuracy, if we report current and predicted HV Capacity in amp-hours. You then compare that to readings taken at the dealer. However the data here is not linear and we are missing several factors. I completely agree with Ray and MrF's assumptions, and the premise that this must be based on data the "pro-consumer" owner would have regular access to.
The one variable I noticed listed was "time to charge" and how long it took to reach that SOC. This is not a good metric for Lithium batteries unlike almost all other types. Li-poly, especially those other than LiFePO4 cells, actually take longer to charge the older they get (cycles or age). You can monitor power input and correct for parasitic charge losses (efficiency degradation) but the shorter time may be very misleading due to loss of charge transfer capability. This basically means the battery takes longer to absorb the same amount of energy, and in fact longer to absorb even "less" energy as capacity declines. There are a lot of things going on here effecting those observations, that make them still valid but for different reasons (whether that matters in the end for this remains to be seen).
A good article on that is here from Cadex:
https://batteryuniversity.com/index...y_do_old_li_ion_batteries_take_long_to_charge
The current model is too aggressive and missing some parametrics that would shallow (refuse to say "flatten" right now) the curve.
All the data to predict this is being streamed over telemetrics to Honda anyway... our cars are research units for them. They are using our cars to train Tensorflow ML models for EV battery life predictions and consumer use modeling I am sure of it (putting on foil hat now...)
Seriously though - all the data is in the car's CAN buss - geez I wish I could figure more of it out, but I am getting a slow handle on it likely much more time needed than I have right now while home schooling. Steep learning curve for me (not a coder) and I really need to sniff the BUSS while the battery capacity is being requested by the i-HDS to be sure. Then this would be a sub $100 problem for everyone and "check at will." I'm actually pretty convinced that once I know the PID and scaling that the $20 OBDII/Bluetooth/Phone mentioned below would work.
So, a basic ELM327 OBDII probe and mobile phone software in the $20 range (I am working on the reason, has to do with voltage drop under a "known load"). Either an
EVSE that reports charge data (likely level 2) or a Kilowatt meter ($35 Amazon) and use their OEM Level 1 charger for all data points (you can't mix and match charger data, it all has to come from a single source) and the basic 5 step guide to use it. This spreadsheet will need an entry table for the data and time range for the pretty output page Ray already created. People can use any charger regularly - work, home, destination, etc - however for any entry of data in this to be accurate for a specific vehicle, they have to use only data from a specific charger, mixing will break the range.
You need to know some absolutes. PDI type stuff to extrapolate and interpolate from. Some beginning point... Date of manufacture or date placed in service/sold, original or first known HV Pack capacity (i-HDS reported) and full charge input power as close to the time the pack capacity was obtained. Don't put EV "range" anywhere on there, that's a rabbit hole beaten to death.
- Input charge, age, mileage, and known pack capacity are primary
- Known pack capacity with a full charge cycle data capture within a short time for correlation
- Actual EV "mileage" (not predicted) from full charge to automatic HV mode is good data relative to an individual driver
These don't have to happen all the time, once a month data points would be predictive enough for this form.
Hmmm, I am not good enough at excel formulas for this....
Oh, and yes I had a glass of Scotch in hand while reading the attached document...
Cheers and Happy Easter,
Cash