Go Back   Horizons Unlimited - The HUBB > Planning, Trip > TRAVEL Hints and Tips

TRAVEL Hints and Tips Post your TIPS to travellers - all the interesting little tidbits you learned on the road about packing, where to get stuff, and how to cope with problems. Please make sure the subject describes the tip clearly!
Contact Overland Solutions for all your custom modifications and setup for overland travel.

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 3 Dec 2008
Registered Users
New on the HUBB
 
Join Date: Jun 2007
Location: USA
Posts: 8
Trip financial planning spreadsheet

Hello everyone,
I put together an Excel spreadsheet on my site to use for trip financial planning (trip cost and savings calculations). I hope it will be useful for someone. Please, let me know what you think.

Motorcycle Trip Financial Planner | The Adventure Motorcycle Blog
Reply With Quote
  #2  
Old 3 Dec 2008
Registered Users
HUBB regular
 
Join Date: Aug 2008
Location: Phoenix, AZ, USA
Posts: 69
Very nice! You could make this more accessibly by making it into a Google Doc.

I'm going to use this for my trip.

Thanks!
__________________
AtlasRider.com
Sport Touring Blog
Reply With Quote
  #3  
Old 4 Dec 2008
Registered Users
New on the HUBB
 
Join Date: Jun 2007
Location: USA
Posts: 8
Hi Atlas,

Thanks for the comments! Unfortunately Google docs (like Zoho) does not cooperate with Excel's charts and graphs. You can, however, download the file and upload it to your Google docs account. Functionally it should work, it just doesn't look as nice and the charts don't show up.

I've also been told it works fairly well in OpenOffice (a free alternative to Excel).

Love your blog BTW! I've been drooling over your Utah pics. One of these days I've gotta make it out west.
Reply With Quote
  #4  
Old 4 Dec 2008
PocketHead's Avatar
Registered Users
Veteran HUBBer
 
Join Date: Feb 2008
Location: Sucre, Bolivia
Posts: 556
wow this spreadsheet is awesome
Reply With Quote
  #5  
Old 4 Dec 2008
Registered Users
HUBB regular
 
Join Date: Aug 2008
Location: Phoenix, AZ, USA
Posts: 69
WQF,

OMG I went back to the page and just saw the Zoho things that displays the spreadsheet. It didn't load for me the first time for some reason. In the mean time I was converting it to a Google Doc. Here's mine:

http://spreadsheets.google.com/ccc?k...M6tqOQfvHHzPaw

I pretty much copied what you did (didn't feel like calculating the interest stuff). This really is a VERY nice resource. I am all about trying to quantify as much as I can. I know it will all go to hell on the road, but that's half the fun! I've just started to take a realistic look at what it will take to make it to TDF and back, and this has opened my eyes to the kind of saving I will have to do.

Thanks for posting this! If I have any additional ideas I will post back here.

Glad you liked my pics of Utah. There really are some amazing sights out there.
__________________
AtlasRider.com
Sport Touring Blog
Reply With Quote
  #6  
Old 7 Dec 2008
Registered Users
New on the HUBB
 
Join Date: Jun 2007
Location: USA
Posts: 8
Just a quick update. I just put up version 4 on my site which includes added functionality for "2 bike" planning.
Reply With Quote
  #7  
Old 30 Dec 2008
Registered Users
HUBB regular
 
Join Date: Dec 2005
Location: Simonstone, Lancashire, England
Posts: 66
Thumbs up

A very useful little tool, thank you for sharing that with us, and the link to your blog as very interesting and full of good information
Thanks
__________________
Take care out there
Brian

Britch's Holidays Dreaming of the BIG one :-)
Reply With Quote
  #8  
Old 30 Dec 2008
gixxer.rob's Avatar
Registered Users
Veteran HUBBer
 
Join Date: Mar 2008
Location: Back in Melb
Posts: 292
Thanks WQFTruckster ! That is fantastic, a fair number of hours have gone into that to get it working the way it does !

And yes it works very well in open office (2.4)

thanks for sharing !

Reply With Quote
  #9  
Old 4 Jan 2009
Registered Users
New on the HUBB
 
Join Date: Jun 2007
Location: USA
Posts: 8
Quote:
Originally Posted by gixxer.rob View Post
...a fair number of hours have gone into that to get it working the way it does !
Yup. It was fun though. I love Excel. I'm such a nerd Glad to hear others are finding it useful!
Reply With Quote
  #10  
Old 7 Jan 2009
Registered Users
HUBB regular
 
Join Date: Apr 2007
Location: Burton On Trent, England
Posts: 45
Thats a great spreadsheet. I often mess around working the true cost of things with Excel but that is one well polished spreadsheet. Love it!
Reply With Quote
  #11  
Old 7 Jan 2009
Registered Users
Veteran HUBBer
 
Join Date: Aug 2001
Location: Vancouver, BC - now at large in the world
Posts: 405
Quote:
Originally Posted by WQFTruckster View Post
Yup. It was fun though. I love Excel. I'm such a nerd Glad to hear others are finding it useful!
How did you manage to prevent row/columns from "unhiding"?
Nice tool though...

Here are some data points from my trip:

http://www.nohorizons.net/Pages/RTW%20costs.htm
__________________
http://www.nohorizons.net
Reply With Quote
  #12  
Old 7 Jan 2009
Registered Users
New on the HUBB
 
Join Date: Jan 2009
Location: Denver, CO
Posts: 5
Great work

Thanks for putting that together.
Reply With Quote
  #13  
Old 7 Jan 2009
Registered Users
New on the HUBB
 
Join Date: Jun 2007
Location: USA
Posts: 8
Quote:
Originally Posted by Mombassa View Post
How did you manage to prevent row/columns from "unhiding"?
Nice tool though...

Here are some data points from my trip:

http://www.nohorizons.net/Pages/RTW%20costs.htm
Hi Mombassa, I'm not sure I understand your question. If you right click on a column or row, you can hide it. I've never had a problem with them unhiding. I also locked the non-user changeable cells in the sheet to prevent accidental changing, but I don't think this locks the "hiding". Let me know if that doesn't answer your question.

Wow, that's a detailed cost list you have there! That puts my sheet to shame.
Reply With Quote
  #14  
Old 7 Jan 2009
Registered Users
Veteran HUBBer
 
Join Date: Aug 2001
Location: Vancouver, BC - now at large in the world
Posts: 405
Quote:
Originally Posted by WQFTruckster View Post
Hi Mombassa, I'm not sure I understand your question. If you right click on a column or row, you can hide it. I've never had a problem with them unhiding. I also locked the non-user changeable cells in the sheet to prevent accidental changing, but I don't think this locks the "hiding". Let me know if that doesn't answer your question.

Wow, that's a detailed cost list you have there! That puts my sheet to shame.
It seems a lot of the options are greyed out in the Excel. Maybe a version issue? I still run 2002. Yeah, I worked a while on those costs. It was basically my budget that I updated with actuals as time went by. I like your approach, as mine is not variable to the extent yours is.
__________________
http://www.nohorizons.net
Reply With Quote
  #15  
Old 8 Jan 2009
Registered Users
New on the HUBB
 
Join Date: Jun 2007
Location: USA
Posts: 8
Quote:
Originally Posted by Mombassa View Post
It seems a lot of the options are greyed out in the Excel. Maybe a version issue? I still run 2002. Yeah, I worked a while on those costs. It was basically my budget that I updated with actuals as time went by. I like your approach, as mine is not variable to the extent yours is.
I believe the options are greyed out because the sheet is "protected". If you are interested in unlocking the sheet to modify it for your own needs, then send me a PM and I will give you the password. It was created with Office 2003, so I wouldn't think 2002 should be a problem.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 Registered Users and/or Members and 1 guests)
 
Thread Tools
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 On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Planning RTW trip brfoster Route Planning 0 2 Jun 2008 00:46
Planning/Timing NZ to UK trip Joey1007 Route Planning 30 20 Feb 2008 09:42
planning a trip to mexico!!! tamaro Central America and Mexico 16 29 Jan 2008 21:02
Planning a trip across Canada/USA.. help please rotorhead North America 8 29 May 2007 05:06

 
 
 

NEW! HU 2015 Motorcycle Adventure Travel Calendar is now available! Get your copy now for some terrific travel inspiration!

HUGE, 11.5 x 16.5 inches, beautifully printed in Germany on top quality stock! Photos are the winning images from over 600 entries in the 9th Annual HU Photo Contest!

Horizons Unlimited 2015 Motorcycle Adventure Travel Calendar.

"The calendar is magnificent!"

"I just wanted to say how much I'm loving the new, larger calendar!"

We share the profit with the winning photographers. YOU could be in the HU Calendar too - enter here!

Next HU Eventscalendar

See all events

 

Latvia to Australia, an inspirational 5 month journey full of unexpected adventures!

HU DVD Autumn Special!

Take 40% off Road Heroes Part 1 until October 31 only!

Road Heroes features tales of adventure, joy and sheer terror by veteran travellers Peter and Kay Forwood (193 countries two-up on a Harley); Dr. Greg Frazier (5 times RTW); Tiffany Coates (RTW solo female); and Rene Cormier (University of Gravel Roads).

The first in an exciting new series, Road Heroes features tales of adventure, joy and sheer terror by veteran travellers."Inspiring and hilarious!"

"I loved watching this DVD!"

"Lots of amazing stories and even more amazing photographs, it's great fun and very inspirational."

"Wonderful entertainment!"

Check it out at the HU Store! Remember to use Coupon Code 'HEROES' on your order when you checkout.

 

Scottoiler automatic chain oilers. The most important accessory for your next motorcycle adventure!

Renedian Adventures

Renedian Adventures

What others say about HU...

"I just wanted to say thanks for doing this and sharing so much with the rest of us." Dave, USA

"Your website is a mecca of valuable information and the DVD series is informative, entertaining, and inspiring! The new look of the website is very impressive, updated and catchy. Thank you so very much!" Jennifer, Canada

"...Great site. Keep up the good work." Murray and Carmen, Australia

"We just finished a 7 month 22,000+ mile scouting trip from Alaska to the bottom of Chile and I can't tell you how many times we referred to your site for help. From how to adjust your valves, to where to stay in the back country of Peru. Horizons Unlimited was a key player in our success. Motorcycle enthusiasts from around the world are in debt to your services." Alaska Riders

contest pic

10th Annual HU Travellers Photo Contest is on now! This is an opportunity for YOU to show us your best photos and win prizes!

NEW! HU 2014 Adventure Travel T-shirts! are now available in several colors! Be the first kid on your block to have them! New lower prices on synths!

HU 2014 T-shirts now in!

Check out the new Gildan Performance cotton-feel t-shirt - 100% poly, feels like soft cotton!


What turns you on to motorcycle travel?


Global Rescue, WORLDwide evacuation services for EVERYONE

Global Rescue is the premier provider of medical, security and evacuation services worldwide and is the only company that will come to you, wherever you are, and evacuate you to your home hospital of choice. Additionally, Global Rescue places no restrictions on country of citizenship - all nationalities are eligible to sign-up!


New to Horizons Unlimited?

New to motorcycle travelling? New to the HU site? Confused? Too many options? It's really very simple - just 4 easy steps!

Horizons Unlimited was founded in 1997 by Grant and Susan Johnson following their journey around the world on a BMW R80 G/S motorcycle.

Susan and Grant Johnson Read more about Grant & Susan's story

Membership - help keep us going!

Horizons Unlimited is not a big multi-national company, just two people who love motorcycle travel and have grown what started as a hobby in 1997 into a full time job (usually 8-10 hours per day and 7 days a week) and a labour of love. To keep it going and a roof over our heads, we run events (22 this year!); we sell inspirational and informative DVDs; we have a few selected advertisers; and we make a small amount from memberships.

You don't have to be a Member to come to an HU meeting, access the website, the HUBB or to receive the e-zine. What you get for your membership contribution is our sincere gratitude, good karma and knowing that you're helping to keep the motorcycle travel dream alive. Contributing Members and Gold Members do get additional features on the HUBB. Here's a list of all the Member benefits on the HUBB.


Books & DVDs

amazon

All the best travel books and videos listed and often reviewed on HU's famous Books page. Check it out and get great travel books from all over the world.


Motorcycle Express for shipping and insurance!

Motorcycle Express

MC Air Shipping, (uncrated) USA / Canada / Europe and other areas. Be sure to say "Horizons Unlimited" to get your $25 discount on Shipping!
Insurance - see: For foreigners traveling in US and Canada and for Americans and Canadians traveling in other countries, then mail it to MC Express and get your HU $15 discount!




All times are GMT +1. The time now is 14:53.