Great feedback guys. A lot to digest.
Admittedly the first estimator Excel file based on linear extrapolation was going to be a bad first kick at the can. I meant for it to be applied when there is some extended use and then two data spaced apart by a wide period of use (say charging behavior data at 1 and 1.5 or 2 years). Using data from 0 and 1 year will give a poor estimate of capacity loss at 10 years.
Looking at capacity loss curves from LIB research and Honda itself shows non-linear degradation as Cash described. I found a free paper (
https://www.researchgate.net/public..._Battery_Degradation_for_Cell_Life_Assessment) that provides a lot of insight into how best to model the degradation. But in looking at example LIB capacity loss curves:
...and this one from Honda:
It appears to approximate a :
y = -a*x^b
function where b<1. I experimented with a variety of values for b and it seems like when b = 0.5 the curve shape looks right. Meaning when the x axis is battery usage (odometer, # of deep charges, time, or whatever) then the degradation likely approximates a negative square root function.
Here again I am making invalid assumptions and the end result is imperfect, but I think the behavior and degradation rate will get much closer than my previous simple linear model. So if we assume the new battery has 0% degradation, and have an estimate of the battery degradation at mile X, then we can find the constant "a" (knowing y (estimate of capacity loss), x (odometer), and assuming b=0.5). Then a better estimate of the odometer at 33% loss can be fashioned by using the same equation and now we have y (the target capacity loss of 33.33%), the constant "a", and the assumed b = 0.5.
So attached is version 2 of the battery capacity loss estimator. I could someday do a better model by using the functions provided in the research paper I cited above, but that is way too complex at the moment. The 33.3% loss estimate in the new file only calculates based on the 'Result #2' data. Note that for this model the data seems to show that it will be difficult to stress the battery so much that the 33% is achieved before 100,000 miles. Which I think was ultimately Honda's goal.
Obviously, each usage pattern and charging pattern will be different for each car and driver, but the more data that can be shared on this forum, the better our knowledge base can get in terms of what to expect for capacity decline, and offering advice to new members on what to expect and perhaps even how to reduce capacity loss. I will continue to track my own charging cycles and see if the curve does mimic the V2 model or if it will need a new function to better extrapolate into the future.
Thanks for all the work and feedback so far. It is taking time for me to read and comprehend everything. Keep the data and thoughts coming.