RV Trip Planning Discussions

Go Back   iRV2 Forums > CAMPING, TRAVEL and TRIP PLANNING > Camping Locations, Plans & Trip Reports
Click Here to Login
Join iRV2 Today

Mission Statement: Supporting thoughtful exchange of knowledge, values and experience among RV enthusiasts.
Reply
  This discussion is proudly sponsored by:
Please support our sponsors and let them know you heard about their products on iRV2
 
Thread Tools Search this Thread Display Modes
 
Old 11-09-2017, 01:26 PM   #1
Member
 
Join Date: Jun 2017
Posts: 49
Excel Road Trip Planner

Hi all,

My wife an I are planning a 4-6 week trip from New England out west and back (with some family/friend stops thrown in).

In putting it together, I needed a tool to keep track of how much time we were actually going to spend on the road and make sure we didn't accidentally plan to drive 37hours in 1 day.

So, I built this excel spreadsheet and thought I would share it here. I couldn't figure out how to automatically calculate drive times based on addresses, so you'll have to do that on google maps or your favorite mapping site.

I hope some of you find this useful. Here's a link to the file. Download it to your drive and plan away...

https://drive.google.com/file/d/1G-9...ew?usp=sharing

EDIT TO ADD: I managed to get a version working that uses google maps to get drive times and distances (of course you don't know the route it chooses, but it's a guide). Here is the link to that version:
https://drive.google.com/file/d/1hRr...ew?usp=sharing

Note: It uses a macro to do the calculation, so you will have to enable that.

PS, guessing there's a better way to do this. If so, let me know. I'm new to this.

Matt
__________________

cobalt is offline   Reply With Quote
Join the #1 RV Forum Today - It's Totally Free!

iRV2.com RV Community - Are you about to start a new improvement on your RV or need some help with some maintenance? Do you need advice on what products to buy? Or maybe you can give others some advice? No matter where you fit in you'll find that iRV2 is a great community to join. Best of all it's totally FREE!

You are currently viewing our boards as a guest so you have limited access to our community. Please take the time to register and you will gain a lot of great new features including; the ability to participate in discussions, network with other RV owners, see fewer ads, upload photographs, create an RV blog, send private messages and so much, much more!

Old 11-09-2017, 06:12 PM   #2
Senior Member
 
rgvtexan's Avatar
 
Winnebago Owners Club
Freightliner Owners Club
Join Date: Oct 2009
Location: NE WA or S TX
Posts: 3,195
? Depart date 8/1
5 days driving
arrive date 8/3
__________________

__________________
04 Horizon QD, 12 Ford Flex, Excalibar, Brakemaster, Winter Texan, RVin! since 1974
Norm, Donna & Tinker Kat 74 MGB-GT, 75 MGB, 01 Z3
Life is a Timed Event, you only get One Go Around!
rgvtexan is offline   Reply With Quote
Old 11-09-2017, 09:57 PM   #3
Member
 
Join Date: Jun 2017
Posts: 49
Quote:
Originally Posted by rgvtexan View Post
? Depart date 8/1
5 days driving
arrive date 8/3
hmmm... google is breaking the file when I upload it... It strips out some but not all formulas... don't know why it does that because I'm not importing it into google sheets.
cobalt is offline   Reply With Quote
Reply

Tags
excel



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 Off
Pingbacks are Off
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross Country Trip Planner Mia11 iRV2.com General Discussion 4 06-12-2012 08:52 PM
Trip planner Rain Dog Navigation, Routes & Roads 7 06-11-2012 04:43 PM
RV Trip Planner HappyRV Camping Locations, Plans & Trip Reports 12 01-23-2011 08:47 AM
Best trip planner software? micd Technology: Internet, TV, Satellite, Cell Phones, etc. 22 07-06-2010 07:54 AM
Trip planner w/ Breaks? brucemcdou Navigation, Routes & Roads 13 08-10-2008 05:05 PM

» Featured Campgrounds

Reviews provided by


Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -6. The time now is 02:18 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
×