Motorcycle Trip $ Planner Spreadsheet

Discussion in 'Trip Planning' started by Mastery, Oct 31, 2014.

  1. Mastery

    Mastery Mr. Funny Man

    Joined:
    Mar 25, 2011
    Oddometer:
    2,458
    Location:
    Hoosier Daddy?
    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. :D

    CLICK HERE TO DOWNLOAD EXCEL SPREADSHEET
    #1
  2. ZJeepMI

    ZJeepMI Been here awhile

    Joined:
    Jul 6, 2013
    Oddometer:
    163
    Location:
    Tacoma, WA
    Very cool, just played around in it for a few, really breaks everything down nicely. Thanks
    #2
  3. Capri142

    Capri142 Adventurer

    Joined:
    Oct 21, 2009
    Oddometer:
    66
    Location:
    North Florida, USA
    Just what I needed for planning my trip to Alaska net summer.
    #3
  4. justafurnaceman

    justafurnaceman Imaginary

    Joined:
    May 4, 2013
    Oddometer:
    2,112
    Location:
    S. Korea
    I was playing around with this tonight and now my wife has a better idea of how much it costs me to travel around. :lol3 Luckily she understands that it's part of the cost to keep me sane! :clap


    Thanks for the share!
    #4
  5. Project510

    Project510 n00b

    Joined:
    Nov 24, 2011
    Oddometer:
    2
    Location:
    San Mateo, Ca
    Great tool.

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

    Thanks!
    #5
  6. alicethomas

    alicethomas Been here awhile

    Joined:
    Jan 1, 2011
    Oddometer:
    632
    Location:
    Palatinate, Germany
    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)
    #6
  7. Mr_Gone

    Mr_Gone Mad Bad Viking Berserker

    Joined:
    Jul 18, 2010
    Oddometer:
    12,874
    Location:
    Mountain Home, AR
    Great job!!!
    #7
  8. DJFriar

    DJFriar Adventurer

    Joined:
    Nov 30, 2014
    Oddometer:
    26
    Location:
    Plano, TX
    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.
    #8
  9. Bern

    Bern Is it hot in here?

    Joined:
    Jul 20, 2006
    Oddometer:
    144
    Location:
    Whitehorse, Yukon
    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
    #9
  10. polishadam82

    polishadam82 black sheep

    Joined:
    Feb 19, 2011
    Oddometer:
    252
    Location:
    Santa Clara, CALI
    I love this thing you did great job on it THANK YOU dude :D:D
    #10
  11. 97audia4

    97audia4 Adventurer

    Joined:
    Jul 3, 2012
    Oddometer:
    84
    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.
    #11
  12. MrPopples

    MrPopples Been here awhile

    Joined:
    Jul 2, 2012
    Oddometer:
    290
    Location:
    Stinky cheese country
    rich idea.

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

    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
    #12
  13. Str8lin

    Str8lin Keep it moving!

    Joined:
    Sep 20, 2009
    Oddometer:
    613
    Location:
    Auburn, WA
    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!!
    #13
    DavidM1 likes this.
  14. Dan Diego

    Dan Diego Long timer

    Joined:
    Dec 24, 2010
    Oddometer:
    1,575
    Location:
    San Diego, CA
    Very nice.

    I created something similar, but yours is quite handy.

    Thanks for sharing this.
    #14
  15. Mr Head

    Mr Head Adventure Hippie

    Joined:
    Sep 21, 2003
    Oddometer:
    10,610
    Location:
    San Clemente, CA
    Cool. I have always liked spreadsheet tools. Way back in the day my trip planning tools were 10x10 grid paper and colored pencils. :D
    This is way better. :thumb
    #15
  16. Racerboy000

    Racerboy000 Canuck

    Joined:
    Feb 25, 2014
    Oddometer:
    76
    Location:
    Alexandria, Ontario
    Thanks:clap
    #16
  17. Mastery

    Mastery Mr. Funny Man

    Joined:
    Mar 25, 2011
    Oddometer:
    2,458
    Location:
    Hoosier Daddy?
    Nah...there's something to be said about the old way of doing things too. :wink:
    #17
  18. cb200t

    cb200t Been here awhile

    Joined:
    Jun 26, 2012
    Oddometer:
    345
    Location:
    Bellefontaine, OH
    Since I am still new to this, I will be using this to figure out what trips cost for the next couple, then I can actually start planning properly. Thank you for putting this together!
    #18
  19. Moto Mikey

    Moto Mikey Been here awhile

    Joined:
    Jun 28, 2008
    Oddometer:
    461
    Location:
    Charlottesville, VA
    #19
  20. Mastery

    Mastery Mr. Funny Man

    Joined:
    Mar 25, 2011
    Oddometer:
    2,458
    Location:
    Hoosier Daddy?
    Giving this a bump since I see a lot of "how much does it cost" and "what budget did you have" postings lately. So, for those planning their upcoming riding trips, have at it. :D
    #20