Motorcycle Trip $ Planner Spreadsheet

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

  1. ThirtyOne

    ThirtyOne unfiltered

    Joined:
    Mar 17, 2014
    Oddometer:
    266
    Location:
    Honduras
    I thought my Excel spreadsheets were pretty good. Ha! Nice work!

    PS. $75 for an oil change?! :eek1
    #21
  2. Mastery

    Mastery Mr. Funny Man

    Joined:
    Mar 25, 2011
    Oddometer:
    2,458
    Location:
    Hoosier Daddy?
    Fake data. Had to plug some stuff in to show how it worked. Imagine you are taking your bike to a Harley dealer. :lol3
    #22
    Bartimus likes this.
  3. Swede650

    Swede650 n00b

    Joined:
    Jul 20, 2013
    Oddometer:
    3
    Location:
    Cambridge, MA - city mouse
    Very nice! Thanks :thumb
    #23
  4. SomeDude451

    SomeDude451 Adventurer

    Joined:
    Oct 29, 2012
    Oddometer:
    29
    Location:
    Katy, Tx
    Excellent work. Thanks for sharing.
    #24
  5. Corbeau

    Corbeau Been here awhile

    Joined:
    Feb 22, 2006
    Oddometer:
    750
    Location:
    Ottawa, Ontario, Great White North
    Thanks for sharing.

    I'll modify it for clarity as I ride solo trip (on one bike, that is). Since I budget for performance certificates, I'll have to add lines for that... :lol3
    #25
  6. Dusty_Bottoms

    Dusty_Bottoms Adventurer Ordinaire

    Joined:
    May 8, 2011
    Oddometer:
    955
    Location:
    Fort Collins, CO
    Very handy. Thanks!
    #26
  7. Idahohigh

    Idahohigh Been here awhile

    Joined:
    Apr 8, 2015
    Oddometer:
    478
    Location:
    Retired ,USA
    Thanks , By using this tool it seems I have money left over from what I originally was planning. Never hurts to have a little extra....
    #27
  8. gmk999

    gmk999 ____ as a Rotax

    Joined:
    May 2, 2011
    Oddometer:
    3,262
    Location:
    New England
    I plan my expences at $100 per day per bike. I usually come in under that but not by much when traveling alone. There is a bit of redundant savings with 2 bikes. primarily camping/ hotels. and groceries..
    Gas is 10-15
    camping is 30 (incl firewood) If you walk in, as online as fees (reserve america) can make a mom-n-pop hotel a bargain versus camping
    food 40
    Local tourism 15
    Obviously how you travel is a huge variable, I usually set up camp in an area for a few days and do excursions in the area then pack up and move on. on a smaller bike it is nice to not have to carry gear all day every day. For that the 100 buck budget sends me home with cash in hand or allows a few more added days at the trip’s supposed end.
    I primarily travel the eastern US on a 650 cc bike
    #28
  9. ducmons

    ducmons Been here awhile

    Joined:
    Jan 8, 2007
    Oddometer:
    372
    Location:
    Phoenix
    Very helpful!
    #29
  10. ZiaThunder

    ZiaThunder Go big or go home

    Joined:
    Jul 27, 2012
    Oddometer:
    1,673
    Location:
    NM
    Well done!
    #30
  11. rrookey

    rrookey Adventurer

    Joined:
    Jun 12, 2012
    Oddometer:
    77
    Location:
    Fremont NH
    This is great! Thank you
    #31
  12. N-Id-Jim

    N-Id-Jim Been here awhile

    Joined:
    May 14, 2009
    Oddometer:
    993
    Location:
    where elephants roam
    Nice tool! Thx
    #32
  13. Phaedrus68

    Phaedrus68 Been here awhile

    Joined:
    Oct 1, 2015
    Oddometer:
    100
    Location:
    Dublin
    Thanks for this! I can be a bit of a head-in-the-clouds-guy, but something like this puts manners on that - drives it home that without planning, aspirations will remain aspirations.

    Planning all the bike gear, cameras, clothes, the route... All great fun, but addressing the finances is crucial.

    I've modified the spreadsheet to my own style & preference, but the fundamental notion is still there!

    Thanks again. :beer
    #33
  14. AllSeasonRider

    AllSeasonRider Wandering, maybe a little lost...

    Joined:
    Feb 20, 2008
    Oddometer:
    1,251
    Location:
    Los Angeles, CA
    Cell R24 needs a tweak to the formula. I put in some data from my last big trip, total cost was only $2,392.34. I left the $500 in the Beginning Savings Amount and the default 8 days to departure. Extra savings needed is correct at $1,892.34, but the 'Monthly Savings Neccesary' is showing $7,196.63.

    There needs to be another IF statement that says if the Monthly Savings Neccesary is more than the Extra Savings Needed, then just display the extra savings needed.
    #34
  15. NorthBayPete

    NorthBayPete Adventurer

    Joined:
    Apr 12, 2013
    Oddometer:
    62
    Location:
    North Bay, Ontario, Canada
    Think I'll take a look at that after my trip to Alaska.
    #35
  16. mercurydog47

    mercurydog47 Adventurer

    Joined:
    Feb 7, 2015
    Oddometer:
    60
    Location:
    Northern California
    One note on food costs...I usually attribute half of that cost incurred since I eat even when I am home going nowhere.
    #36
  17. mtnhead

    mtnhead Been here awhile

    Joined:
    Aug 23, 2007
    Oddometer:
    103
    Location:
    Colorado Springs, CO
    Just downloaded the file. Thanks for the work that went into this.
    #37
  18. NewYorkLuke

    NewYorkLuke Been here awhile

    Joined:
    Oct 19, 2010
    Oddometer:
    474
    Location:
    Upstate NY
    Very cool, I envy your ability to use excel I still struggle to make a decent maintenance spread sheet for my bikes
    #38
  19. Eatmore Mudd

    Eatmore Mudd Mischief on wheels.

    Joined:
    May 28, 2012
    Oddometer:
    708
    Location:
    Wet side of WA.
    Freakin' way groovy spreadsheet. Thanks !!!
    #39
  20. sean.flynn

    sean.flynn Just this guy, you know?

    Joined:
    Dec 28, 2010
    Oddometer:
    61
    Location:
    Central PA
    Hey, this rocks. I wish I'd seen this a couple years ago when I made something similar-but-less-cool. Mine did Canadian currency conversions and gas price conversions. :D
    #40