Trip Planning Spreadsheet - Jaguar I-Pace EV400 Forum
 2Likes
  • 2 Post By WattAJag
 
LinkBack Thread Tools
post #1 of 5 (permalink) Old 11-22-2019, 03:43 PM Thread Starter
Senior Member
 
Join Date: Nov 2018
Location: Scottsdale, AZ
Posts: 398
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.
D5 =IF(B5>0,B2-C5,"")
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.
Attached Thumbnails
Click image for larger version

Name:	Trip Planner.png
Views:	64
Size:	9.9 KB
ID:	2897  
Dantrium and juice like this.
WattAJag is offline  
post #2 of 5 (permalink) Old 11-22-2019, 11:56 PM
Super Moderator
 
sciencegeek's Avatar
 
Join Date: Jun 2018
Location: Palo Alto
Posts: 1,287
Awesome! I'll PM you
sciencegeek is online now  
post #3 of 5 (permalink) Old 11-29-2019, 01:56 PM Thread Starter
Senior Member
 
Join Date: Nov 2018
Location: Scottsdale, AZ
Posts: 398
P.S. Used this on a 5 leg, 350 mile trip this weekend, and it was 100% accurate.
WattAJag is offline  
Sponsored Links
Advertisement
 
post #4 of 5 (permalink) Old 12-08-2019, 05:58 PM
Junior Member
 
Join Date: Nov 2019
Location: San Diego
Posts: 2
Thumbs up Thanks!

Thanks for posting this spreadsheet! I used it on a recent trip and it was very accurate! A very handy tool.
serenityNow is offline  
post #5 of 5 (permalink) Old 12-08-2019, 09:38 PM
Member
 
SeanM1's Avatar
 
Join Date: Sep 2019
Posts: 38
Quote:
Originally Posted by WattAJag View Post
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.
D5 =IF(B5>0,B2-C5,"")
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.

Just use this web site. It's great.
https://abetterrouteplanner.com/

Narvik Black HSE, all options including carbon fiber.
SeanM1 is online now  
Reply

Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



Posting Rules  
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome