EV Roadmap Refuel Trip Estimator (Google Sheets)

[R1 EVY]

Hey Everyone,

Not sure if this already exists somewhere, but I wanted a simple EV Roadmap Refuel Trip Estimator so I could calculate how many stops I would have to make on a trip. So, I created a Google sheet to run the calculation.

Basically, you enter the following:

• Capacity (maximum estimated milage for your vehicle)
• Refill max (maximum percentage you want to refuel default: 80%)
• Min (minimum percentage you want to refuel default: 20%)
• Trip (trip distance)
• L1 (percentage of refuels using a level 1 charger. Not recommended)
• L2 (percentage of refuels using a level 2 charger. Not recommended)
• L3 (percentage of refuels using a level 3 charger. Not recommended)

Then it will calculate:

• Balance (remaining miles available when you arrive)
• Stops (number of stops you will make)
• Wait time (time you will wait assuming the charger is available)

Caveats
I need it so I created it. It's read-only, so feel free to edit to your heart's desire.

Access it here.

-Darren

Sponsored

 

[Chengo888]

There is ABRP (A Better Route Planner) app that does this all for you and even includes chargers and charge length to your route. Rivian acquired them last year. https://stories.rivian.com/rivian-acquires-abrp

ios https://apps.apple.com/us/app/a-better-routeplanner-abrp/id1490860521

 

[WSea]

You can also plan a real world trip in the app and vehicle nav that shows actual real world charging station locations and the nav will take you to those locations. Starting soc and min arrival soc all adjustable to user preferences. I guess I’m misunderstanding the premise of your calculator

 

[R1 EVY]

There is ABRP (A Better Route Planner) app that does this all for you and even includes chargers and charge length to your route. Rivian acquired them last year. https://stories.rivian.com/rivian-acquires-abrp

ios https://apps.apple.com/us/app/a-better-routeplanner-abrp/id1490860521

Thank you. I think the app is clunky and this is way faster. I appreciate the so though. More tools for the tool belt.

 

[R1 EVY]

You can also plan a real world trip in the app and vehicle nav that shows actual real world charging station locations and the nav will take you to those locations. Starting soc and min arrival soc all adjustable to user preferences. I guess I’m misunderstanding the premise of your calculator

Yes, I've done that before. Appreciate it!

 

[R1 EVY]

Not sure if anyone is checking, but I actually like the spreadsheet because it helps calculate much quicker than going into the app. It's like a back-of-the-napkin type thing. I'm able to adjust to the weather or any other variables for estimates.

Someone out there will understand ???.

 

[SANZC02]

Thank you. I think the app is clunky and this is way faster. I appreciate the so though. More tools for the tool belt.

Unless I am missing something, the only issue I see with the spreadsheet is it is not aware of where the DCFC chargers are.

Take stop 1 at 320 miles, it is a problem if the chargers are 280 miles and 370 miles on that stretch. This is where using the vehicle or an App like ABRP makes planning easier.

It is a lot easier to plan stops like this in an ICE as gas stations are everywhere, chargers are just not that readily available yet.

 

[CharonPDX]

If you want to plan the stops yourself, use PlugShare instead of ABRP. It just shows you a circle of "range from this stop" and you pick a next stop yourself, then it routes, and you pick the next one.

This is an interesting exercise in spreadsheeting and planning, and I've absolutely done similar myself - but as a "tool for most people", ABRP/Plugshare makes a lot more sense.

 

[R1 EVY]

What I've found is that real world estimates are easier to guide my stops while planning.

 

[novikovalilia]

I’ve tried making similar tools in Excel before, and one thing I’ve found super helpful is adding features like pulling in real-time data or making the sheet more interactive.

 

[R1 EVY]

Have you developed it yet?

 

[ndmiller]

In my experience where I stop for gas/charge is way more important than when on roadtrips. Clean bathrooms and food/snacks/etc always drive the final decision previewing the route and checking the 300 mile mark and whats around it.

For example on recent trip to Tampa from Atlanta most apps told me to stop where a supercharger was but no decent food and gross bathrooms. I stopped way short at Bucees and then ran longer miles to the next stop. On the way back adjusted and pulled out a stop to make it a 2 stop trip instead of three with Bucees last. Apps and calculators are great, but the route previous is critical to ensure your plan will make sense in reality and not aggravate the passengers.

 

[R1 EVY]

In my experience where I stop for gas/charge is way more important than when on roadtrips. Clean bathrooms and food/snacks/etc always drive the final decision previewing the route and checking the 300 mile mark and whats around it.

For example on recent trip to Tampa from Atlanta most apps told me to stop where a supercharger was but no decent food and gross bathrooms. I stopped way short at Bucees and then ran longer miles to the next stop. On the way back adjusted and pulled out a stop to make it a 2 stop trip instead of three with Bucees last. Apps and calculators are great, but the route previous is critical to ensure your plan will make sense in reality and not aggravate the passengers.

I totally agree with that

Sponsored