I am planning a trip to Champaign IL on Monday, and I have been trying to figure out the best way to approach it. I created this spreadsheet ...
In case you find it useful, here's the most recent trip that I've built from my spreadsheet. You might find it useful, you might not. I've found it very useful. It's intentionally fairly conservative.
Quick user's guide:
First: Read through the below, updating any fields that say "Set" below.
- Colored values are calculated, except for N2.
- N2: Set the max range you want to charge. I only do 90% (Daily) charges, and mine currently caps at around 216. So I use 215...roundish number.
- K2: Set the rated consumption. Some say 312. Some say 308. Some say < 300. I use 300 as a nice round number.
- I2: Specify the minimum voltage at the charging locations. I've seen 192V before, but usually 208V is the lowest I see.
- F2: Take your typical consumption rate and inflate it slightly (like round up by 10-15 Wh/mi).
- H2: (Calculated) Tells you how much padding you've specified vs. Rated.
- A: (Optional) Phone number for location.
- B: (Optional) Name of location.
- C: Set addresses of all the places you intend to stop. Makes for easier management while travelling to have them here.
- D: Set the amperage of the charging location. Note that for superchargers you want twiddle with the number until column I (Charge rate in mph) looks "right" to you.
- E: Set the distance to arrive to a given location from the location on the preceding line.
- F: Set your average speed of travel.
- G: (Calculated) Drive duration to this location.
- H: (Calculated) Estimate of rated miles spent to reach this location.
- I: (Calculated) Charge rate at this location, in mph.
- J: Set all these to zero. We'll come back to this.
- K: (Calculated) Rated miles added at this location.
- L: (Calculated, except first location) Arrival time for this location.
- M: (Calculated, except first location) Arrival rated miles.
- N: (Calculated) Departure rated miles.
- O: (Calculated) Departure time.
- P: (Optional) Notes, like business hours or whatever.
Second: Save. You just typed a lot and you don't want to lose it.
Third: You probably see negative numbers in column M that get progressively worse as you look down the locations. This means you can't make the trip with a single charge (duh). Your mission: Make all those numbers positive, and ideally with at least 10 rated miles of buffer. Find the first negative value in column M. On the preceding row put 15 ("15 minutes") in column J. If that's not enough, try 30. Repeat until all of column M is positive numbers.
When building my column J, I use increments of 15min but you can use 5min or 1min or 0.1 minutes if you like. I generally try to "roughly minimize" each J column. When I'm all done I look at the Arrive time for my final location. If that's way wrong (like late to an appointment) then the trip is in trouble.
After you've built this out, you might be missing one key component: Sleep. Look at the Leave column and figure out where you want to stay at night and grow the "Charge duration" to account for sleeping, eating, etc. The N2 field that you filled out earlier will prevent the rest of the N column from having absurd values.
Sidenote: This post is mildly on-topic because my example spreadsheet contains only superchargers.