Go Back   ADVrider > Riding > Trip Planning
User Name
Register Inmates Photos Site Rules Search Today's Posts Mark Forums Read

Thread Tools Search this Thread Display Modes
Old 10-31-2014, 04:39 PM   #1
Mastery OP
Mr. Funny Man
Mastery's Avatar
Joined: Mar 2011
Location: Hoosier Daddy?
Oddometer: 1,539
Motorcycle Trip $ Planner Spreadsheet

Since I am doing more long distance motorcycle trips, I wanted to create a spreadsheet for planning the estimated expenses of each journey before they happen. I looked at a few different online trip planning spreadsheets, and settled on using WQFTruckster's version that he originally shared HERE. I used his fine work, and expanded on it for what I wanted to track. I've modified it to fit my needs and am offering it here to anybody else that wants it. It's not the prettiest, and I'm still tinkering with it from time to time, but here it is if anybody wants to play with it as well.

If you tinker with it and make it tons better with more options and want somebody to host it, feel free to send me a PM and I'll be glad to host your version as well.

It is in US dollars; simply change it to whatever monetary scale you wish to use. And since most people don't read everything in an Excel sheet, the password is "adv" (no quotes) if you want to modify it. Change the numbers in the default sheet to whatever you want and have at it.

Merry Christmas. Happy Easter. Gobble Gobble. Whatever pleases you.

Mastery is offline   Reply With Quote
Old 11-06-2014, 06:38 PM   #2
Gnarly Adventurer
ZJeepMI's Avatar
Joined: Jul 2013
Location: Plymouth, MI
Oddometer: 141
Very cool, just played around in it for a few, really breaks everything down nicely. Thanks
1999 Suzuki DR350SE - 2013 Specialized Crux Elite - 2012 Specialized Hardrock Sport

ZJeepMI is offline   Reply With Quote
Old 11-06-2014, 07:22 PM   #3
Joined: Oct 2009
Location: North Florida, USA
Oddometer: 57

Just what I needed for planning my trip to Alaska net summer.
Someday is not on the Calendar
Capri142 is offline   Reply With Quote
Old 11-09-2014, 07:42 PM   #4
justafurnaceman's Avatar
Joined: May 2013
Location: Hanging out in VA for the time being...
Oddometer: 1,317
I was playing around with this tonight and now my wife has a better idea of how much it costs me to travel around. Luckily she understands that it's part of the cost to keep me sane!

Thanks for the share!
justafurnaceman is online now   Reply With Quote
Old 11-21-2014, 11:16 PM   #5
Project510's Avatar
Joined: Nov 2011
Location: San Mateo, Ca
Oddometer: 2
Great tool.

Lets you see just how much you need to save in order to make the trip really happen.

Project510 is offline   Reply With Quote
Old 11-23-2014, 11:19 AM   #6
Gnarly Adventurer
Joined: Jan 2011
Location: Palatinate, Germany
Oddometer: 467
Nice idea! But is the calculation for cell E39 correct?
My suggestion is (open office format): if(D10<>1;(E35+E37)*D11+(E36+E38)*D12;(E35+E37)*D11)
alicethomas is offline   Reply With Quote
Old 11-24-2014, 10:42 AM   #7
The Lejund!
Mr_Gone's Avatar
Joined: Jul 2010
Location: Mountain Home, AR
Oddometer: 8,644
Great job!!!
Mr_Gone is offline   Reply With Quote
Old 12-08-2014, 09:35 AM   #8
Joined: Nov 2014
Location: Plano, TX
Oddometer: 26
Originally Posted by alicethomas View Post
Nice idea! But is the calculation for cell E39 correct?
My suggestion is (open office format): if(D10<>1;(E35+E37)*D11+(E36+E38)*D12;(E35+E37)*D11)
I'm not sure even that is necessary. The food expenses area is written as "per bike", not "per rider". In that case, it should be just a simple SUM. If it was written up as per rider, then the IF<>1, etc comes into play.
DJFriar is offline   Reply With Quote
Old 01-03-2015, 08:18 PM   #9
Is it hot in here?
Bern's Avatar
Joined: Jul 2006
Location: Whitehorse, Yukon
Oddometer: 134
Awesome tool!!
Just used it to plan a trip across Canada........the final numbers were shocking and just what I needed to see to make it I really have to start saving if I want it to happen.
Thanks for putting this out there, sure made it easy
Bern is offline   Reply With Quote
Old 01-03-2015, 10:14 PM   #10
black sheep
Joined: Feb 2011
Location: Santa Clara, CALI
Oddometer: 150
I love this thing you did great job on it THANK YOU dude
Sometimes you find yourself in the middle of nowhere, and sometimes in the middle of nowhere, you find yourself.
"You can watch things happen, you can make things happen, or you can wonder what the fuck happened."
polishadam82 is offline   Reply With Quote
Old 01-04-2015, 04:55 PM   #11
Joined: Jul 2012
Oddometer: 62
Thanks a lot for making this, its put a real money number in my head for my trip in June. And the number I had in my head must was unrealistic.
97audia4 is offline   Reply With Quote
Old 01-05-2015, 04:15 PM   #12
Gnarly Adventurer
Joined: Jul 2012
Location: Stinky cheese country
Oddometer: 202
rich idea.

I quickly copy/pasted a new sheet to change it to SI units and euros


Warning: I edited it with libre office, and it's 1 a.m. and I haven't used excel or any calc app in years ... so it might be totally wrong/off :P
1993 DR800
2007 Buell XB12 STT
MrPopples is offline   Reply With Quote
Old 01-22-2015, 09:59 AM   #13
Studly Adventurer
Str8lin's Avatar
Joined: Sep 2009
Location: Puget Sound
Oddometer: 549
Not only a great planning tool, but nice for making calculations on a trip after the fact... for those of us that aren't the best planners!!
Attitude IS the difference between Adventure and Ordeal!
Str8lin is offline   Reply With Quote
Old 01-22-2015, 10:04 AM   #14
Dan Diego
Beastly Adventurer
Joined: Dec 2010
Location: San Diego, CA
Oddometer: 1,090
Very nice.

I created something similar, but yours is quite handy.

Thanks for sharing this.
I have no interest in living a balanced life. I want a life of adventure.
Dan Diego is offline   Reply With Quote
Old 01-22-2015, 11:52 AM   #15
Mr Head
PowerPoint ADV
Mr Head's Avatar
Joined: Sep 2003
Location: Orange County, CA
Oddometer: 7,832
Cool. I have always liked spreadsheet tools. Way back in the day my trip planning tools were 10x10 grid paper and colored pencils.
This is way better.
"You don't go to Mongolia for the food." - Sebastian & Kim
2010 KTM 990 Adventure R
My Life With The 990R
Mr Head is offline   Reply With Quote


Thread Tools Search this Thread
Search this Thread:

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 On

Forum Jump

Times are GMT -7.   It's 03:39 PM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.
Copyright ADVrider 2011-2015