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!
Photo by Daniel Rintz, Himba children, Namibia

The only impossible journey
is the one
you never begin

Photo by Daniel Rintz,
Himba children, Namibia



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: 535
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: 63
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: 287
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: 411
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: 411
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

 
 

Announcements

Thinking about traveling? Not sure about the whole thing? Watch the HU Achievable Dream Video Trailers and then get ALL the information you need to get inspired and learn how to travel anywhere in the world!

Have YOU ever wondered who has ridden around the world? We did too - and now here's the list of Circumnavigators!
Check it out now
, and add your information if we didn't find you.

Next HU Eventscalendar

HU Event and other updates on the HUBB Forum "Traveller's Advisories" thread.
ALL Dates subject to change.

2024:

Add yourself to the Updates List for each event!

Questions about an event? Ask here

HUBBUK: info

See all event details

 
World's most listened to Adventure Motorbike Show!
Check the RAW segments; Grant, your HU host is on every month!
Episodes below to listen to while you, err, pretend to do something or other...

2020 Edition of Chris Scott's Adventure Motorcycling Handbook.

2020 Edition of Chris Scott's Adventure Motorcycling Handbook.

"Ultimate global guide for red-blooded bikers planning overseas exploration. Covers choice & preparation of best bike, shipping overseas, baggage design, riding techniques, travel health, visas, documentation, safety and useful addresses." Recommended. (Grant)



Ripcord Rescue Travel Insurance.

Ripcord Rescue Travel Insurance™ combines into a single integrated program the best evacuation and rescue with the premier travel insurance coverages designed for adventurers.

Led by special operations veterans, Stanford Medicine affiliated physicians, paramedics and other travel experts, Ripcord is perfect for adventure seekers, climbers, skiers, sports enthusiasts, hunters, international travelers, humanitarian efforts, expeditions and more.

Ripcord travel protection is now available for ALL nationalities, and travel is covered on motorcycles of all sizes!


 

What others say about HU...

"This site is the BIBLE for international bike travelers." Greg, Australia

"Thank you! The web site, The travels, The insight, The inspiration, Everything, just thanks." Colin, UK

"My friend and I are planning a trip from Singapore to England... We found (the HU) site invaluable as an aid to planning and have based a lot of our purchases (bikes, riding gear, etc.) on what we have learned from this site." Phil, Australia

"I for one always had an adventurous spirit, but you and Susan lit the fire for my trip and I'll be forever grateful for what you two do to inspire others to just do it." Brent, USA

"Your website is a mecca of valuable information and the (video) series is informative, entertaining, and inspiring!" Jennifer, Canada

"Your worldwide organisation and events are the Go To places to for all serious touring and aspiring touring bikers." Trevor, South Africa

"This is the answer to all my questions." Haydn, Australia

"Keep going the excellent work you are doing for Horizons Unlimited - I love it!" Thomas, Germany

Lots more comments here!



Five books by Graham Field!

Diaries of a compulsive traveller
by Graham Field
Book, eBook, Audiobook

"A compelling, honest, inspiring and entertaining writing style with a built-in feel-good factor" Get them NOW from the authors' website and Amazon.com, Amazon.ca, Amazon.co.uk.



Back Road Map Books and Backroad GPS Maps for all of Canada - a must have!

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 R80G/S.

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 all over the world with the help of volunteers; 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, or ask questions on the HUBB. 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.




All times are GMT +1. The time now is 22:00.