I have done a bit more work on the Battery Aging Model (sample screen attached to this message):
--used a slightly different method to calculate predicted Gid Percent at 80% charge which I think is more correct; resulting values are a bit higher
--deleted some cells under fractional year prediction which were duplicates and made the sheet visually more confusing
--changed the percentages to show one decimal place instead of two (it isn't even accurate to one decimal place anyway, easier to read)
--added cells to enter actual Full Charge Gid Percent and 80% Charge Gid Percent under the fractional year area; the spreadsheet now calculates the difference between actual and predicted so it is easy to compare
--removed entries for time spent at 100% charge, as the model has no way to incorporate this information
--added a column for the incremental loss of capacity from year to year; makes it easy to see that the first year suffers by far the greatest capacity loss
--cells where data is entered all have yellow background; calculated values all have blue background
--the spreadsheet cells are currently unprotected; I will protect them (except the ones where data entry is permitted) when put on the Wiki so users don't accidentally change cells they don't want to alter)
Version 0.85 is available here (only in OpenDocument format used with OpenOffice, someone will have to update the Excel format if no problems are found):
https://dl.dropboxusercontent.com/u/481 ... %20085.ods
" onclick="window.open(this.href);return false;
I will add the link to the Wiki if no problems are found with this version.
Note: my Leaf is slightly outperforming the predictions for Santa Monica, CA although it spends about 40 hours a week in the hotter San Fernando Valley. It is currently 1.2% better than predicted for Full Charge and 2.1% better than predicted for 80% charge. It is 2.2% and 3.0% better than predicted for Van Nuys, CA. The correct prediction would fall somewhere between these two climates. There are only three factors that I can think of that might account for my Leaf doing unusually well for the climate:
--my very gentle acceleration not only causes less cycling of the battery (already accounted for in the model), it may be that more rapid discharge rates above one C are harder on the pack
--I keep the average SOC on my Leaf quite low (most of the time between 30-40%, while at work around 50-58%)
--(Edit): I also usually have fairly shallow cycles of the pack (about 40% DOD on most days)
Comments and questions welcome.
You do not have the required permissions to view the files attached to this post.