|
|
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
|
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!
|
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.
|
4 Dec 2008
|
|
Registered Users
Veteran HUBBer
|
|
Join Date: Feb 2008
Location: Sucre, Bolivia
Posts: 535
|
|
wow this spreadsheet is awesome
|
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.
|
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.
|
30 Dec 2008
|
Registered Users
HUBB regular
|
|
Join Date: Dec 2005
Location: Simonstone, Lancashire, England
Posts: 63
|
|
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 :-)
|
30 Dec 2008
|
|
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 !
|
4 Jan 2009
|
Registered Users
New on the HUBB
|
|
Join Date: Jun 2007
Location: USA
Posts: 8
|
|
Quote:
Originally Posted by gixxer.rob
...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!
|
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!
|
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
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
|
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.
|
7 Jan 2009
|
Registered Users
New on the HUBB
|
|
Join Date: Jun 2007
Location: USA
Posts: 8
|
|
Quote:
Originally Posted by Mombassa
|
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.
|
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
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.
|
8 Jan 2009
|
Registered Users
New on the HUBB
|
|
Join Date: Jun 2007
Location: USA
Posts: 8
|
|
Quote:
Originally Posted by Mombassa
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.
|
Currently Active Users Viewing This Thread: 1 (0 Registered Users and/or Members and 1 guests)
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
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.
"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™ 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!
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.
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.
|
|
|