Contact Overland Solutions for all your custom modifications and setup for overland travel.

Go Back   Horizons Unlimited - The HUBB > Planning, Trip > TRAVEL Hints and Tips
Trip financial planning spreadsheet Trip financial planning spreadsheet
Register FAQ Calendar Search Today's Posts Mark Forums Read

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!
With more than 58 destinations worldwide, Edelweiss Bike Travel is Number 1 in guided motorcycle tours!

Reply
Page 1 of 3 1 2 3
 
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: 404
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: 404
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
Page 1 of 3 1 2 3

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 2 (0 Registered Users and/or Members and 2 guests)
 
Thread Tools
Display Modes
Linear Mode Linear Mode

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


All times are GMT +1. The time now is 10:31.

Contact Us - Horizons Unlimited Motorcycle Travellers Website - Archive - Privacy Statement - Top