ADVrider

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

Reply
 
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.

CLICK HERE TO DOWNLOAD EXCEL SPREADSHEET
Mastery is offline   Reply With Quote
Old 11-06-2014, 06:38 PM   #2
ZJeepMI
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
Capri142
Adventurer
 
Joined: Oct 2009
Location: North Florida, USA
Oddometer: 57
Thanks

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
Imaginary
 
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!
__________________
STILL ALIVE UNTIL I'M DEAD
justafurnaceman is online now   Reply With Quote
Old 11-21-2014, 11:16 PM   #5
Project510
n00b
 
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.

Thanks!
Project510 is offline   Reply With Quote
Old 11-23-2014, 11:19 AM   #6
alicethomas
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
Mr_Gone
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
DJFriar
Adventurer
 
Joined: Nov 2014
Location: Plano, TX
Oddometer: 26
Quote:
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
Bern
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 real......now 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
polishadam82
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."
IBA#59715
polishadam82 is offline   Reply With Quote
Old 01-04-2015, 04:55 PM   #11
97audia4
Adventurer
 
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
MrPopples
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

here

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
Str8lin
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.
__________________
...Dick
"You don't go to Mongolia for the food." - Sebastian & Kim
2010 KTM 990 Adventure R
My Life With The 990R
Smugmug
Mr Head is offline   Reply With Quote
Reply

Share

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