Trip Planning Spreadsheet
I have made a quick spreadsheet that I think is useful for trip planning. (See Picture). I put in my real world range per battery % (which, my highway range is about 2 miles per % of battery, so I use 1.9 as a conservative number in the picture). Then, I enter legs of my trip and distances. It will start computing % used, and remaining battery % at arrival. Then, at stops with a charger, I enter what I want to charge back to, and what the KW speed of the charger is, and it computes the time at that charger. This lets me figure my extra time at chargers is and my arrival %'s. I'm using a version on Google sheets on my phone for doing it on the road.
If you'd like an excel or Google sheets copy, IM me with your email, and I will send it to you. (I will not email you with anything else, and I'm not making lists of any kind). If there's a way to attach a file here, I'm happy to do it, or let an administrator do it. No macros are in this spreadsheet.
Or, if you want to build it yourself, here are my formulas:
C5 =IF(B5>0,B5/$B$1,"") --- Copy this down 15 rows.
G5 =IF(AND(B5>0,E5>0,F5>0),(E5-D5)/(100*F5/$E$1)/24,"") --- Copy this down 15 rows.
D6 =IF(B6>0,MAX(D5,E5)-C6,"") --- Copy this down 14 rows.