Spreadsheet for Time to Charge to 85%

[lloydt]

I got tired of figure out how much time to put on the timer for my Vado (600wh) and Levo (700wh) so that I could charge to around 85%. I ended up creating a spreadsheet that works really well. I come home, look at the percentage remaining, look on the chart set the timer and when I come back my bike is at 85% or below. I was doing the calculation in my head for a while, but I got too lazy. I printed a sheet for my Vado and my Levo and taped them to the wall next to the timer.

You can copy this spreadsheet (choose File/Make Copy) and then your battery and charger size. It will create a nice charge grid for you.

https://docs.google.com/spreadsheets/d/1_wrgeJ1kZV-pMzrMBtx0ciUmuGf6cAYCNA1vn4VlRW0/edit?usp=sharing

I'm using this $10 from Amazon.

https://www.amazon.com/gp/product/B00MVDTEXS/ref=ppx_yo_dt_b_asin_title_o09_s00?ie=UTF8&psc=1

 

[NitroStar]

I'm struggling to open and save this file on my Galaxy and it has Excel. Can ya help

 

[lloydt]

I'm struggling to open and save this file on my Galaxy and it has Excel. Can ya help

You can keep it in Google Sheets. From the google sheets menu, select "File/Make a Copy"

 

[jim6b]

A trick Tesla uses is to rate their batteries at less then absolute maximum charge. Why? It behooves Tesla to have their batteries last to the 8 year warranty and if charging to less than max will extend life and reducing battery replacement. So the thinking is Tesla set max recharge at something less than true max (though they also suggest using battery between roughtly 1/3 charge to 2/3 rds charge for optimum longevity).

My thought is that other manufacturer's may also be using this trick, e.g. consider the universal feeling that manufacturers "overstate" the max (charge level) range which could be just cutting back the charge level possible with provided chargers.

Wondering if anyone has successfully had feedback from Specialized on this point.