HV Battery Capacity Spreadsheet

[Danks]

https://docs.google.com/spreadsheet...OQIpT_YiGp9N-vnBOiSz96C2I/edit#gid=1710145002

I've updated the spreadsheet.

Added menu links to tabs on the Introduction Page
Added a column for estimated # charges / week to the Battery Capacity Data entry tab
Added formulas to the Vehicle Data to calculate Days to Purchase and Build YearMonth
Added formulas to the Battery Capacity Analysis Data to

• add Model, Days to Purchase, Build YearMonth from Vehicle Data
• add column converting mi to km
• add column converting km to mi
• Converted the BPC by Distance tab to use the new Battery Capacity Analysis Data
• Converted the BPC by EV Distance tab to use the new Battery Capacity Analysis Data
• Converted the BPC - Miles graph to use the new BPC by Distance data
• Converted the BPC - EV Miles graph to use the new BPC by EV Distance Data

There is more to come. This gets the data in place to start adding more analysis pieces.

 

[vicw]

Great job, @Danks. I've been using Google spreadsheets for a long time, but never in a sharing mode like this. It's an amazingly powerful tool for data gathering and analysis. It will be very interesting to see how many owners participate, and if the accumulated data gives hope that we will almost all avoid early life failure of our batteries.

On the other hand, we may find some of us eventually trying to find ways to push our batteries below the failure line before the 8-10 years Warranty period expires.