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 11-19-2008, 02:27 PM   #1
WQFTruckster OP
Adventure Engineer
 
WQFTruckster's Avatar
 
Joined: Jun 2007
Location: North Central Florida
Oddometer: 61
Financial Trip Planning Spreadsheet

Hi all,

I just put together a 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.

EDIT: For those that don't want to read the whole thread, the files have been revised and moved a couple of times but here are the current file locations as of 2/24/10:

Standard version:
http://www.halolightingsystems.com/w...planner-v4.xls

Metric version:
http://www.halolightingsystems.com/w...-v4-metric.xls

Any value in blue can be user modified, including adding additional maintenance items. Also, if you hover over any cell with a red triangle in the upper corner there is a description that pops up.

If you are proficient in excel and want to modify it, the password to unprotect the sheets is "adventure". As long as you give credit where credit is due, feel free to copy, modify for your own use, etc. Enjoy!
__________________
HID Helmet Mounted Adventure Lighting

WQFTruckster screwed with this post 02-24-2010 at 06:07 PM
WQFTruckster is offline   Reply With Quote
Old 11-19-2008, 03:10 PM   #2
intothenew
Briar Patch Navigator
 
intothenew's Avatar
 
Joined: Jul 2007
Location: Almost Heaven
Oddometer: 2,133
I downloaded the excel file, opened it with openoffice 2.4.1 and everything works fine. Nice tool, thanks.
__________________
Momentum is your friend, and never trust a grapevine.

"For a boy,it was a kind of paradise.
I wasn't just playing Indian, I was living Indian."
intothenew is offline   Reply With Quote
Old 11-19-2008, 03:37 PM   #3
WQFTruckster OP
Adventure Engineer
 
WQFTruckster's Avatar
 
Joined: Jun 2007
Location: North Central Florida
Oddometer: 61
Cool, glad to know it works with openoffice. Thanks!
__________________
HID Helmet Mounted Adventure Lighting
WQFTruckster is offline   Reply With Quote
Old 11-19-2008, 05:54 PM   #4
WhistlingFool
Dixie!? I know a Dixie...
 
WhistlingFool's Avatar
 
Joined: May 2008
Location: BRP early morning with no traffic
Oddometer: 693
way to go

Damn fine job

.. it is on my desktop and will have me tweaking things for months to come..
__________________

.........
and Larry said, "Wow, you really need to run out of gas more often!"

by Northwoods Yeti - "Rubber mallet and Crisco here I come...."



Read My 2005 Trip Report

WhistlingFool screwed with this post 11-20-2008 at 12:50 PM
WhistlingFool is offline   Reply With Quote
Old 11-20-2008, 10:16 AM   #5
Incredulous
Peanut Gallery
 
Joined: Dec 2006
Location: The O.V.
Oddometer: 565
Guess I have to plan a trip now.

Thanks, great job.
Incredulous is online now   Reply With Quote
Old 11-20-2008, 10:29 AM   #6
BlaSTr
Adventurer
 
BlaSTr's Avatar
 
Joined: Feb 2007
Location: SoFlo - land of 11 turns in 318 miles
Oddometer: 77
Thanks for the work and post. It's far better looking than the one I cobbled together. And more extensive.
__________________
BlaSTr

IBA SS1000 & BBG1500

06 ST1300A
00 Jeep Cherokee
----------------------
Scars are tatoos with better stories.
BlaSTr is offline   Reply With Quote
Old 11-21-2008, 03:31 AM   #7
heetseeker
Hopelessly addicted
 
heetseeker's Avatar
 
Joined: Oct 2007
Location: Wilton CA
Oddometer: 370
I'll have to download that to my smart phone so I can take it on the road with me... great job. I'll have to add a couple of fields to it later.
__________________
GS 1200, 12' EXC 500, ktm sx250, RZR 900 XP

PDMC 38x
heetseeker is offline   Reply With Quote
Old 11-21-2008, 11:29 AM   #8
gus1911
Team F5
 
gus1911's Avatar
 
Joined: Sep 2008
Location: Virtual Bivouac
Oddometer: 97
Nice job. Only 222 days until departure.
gus1911 is offline   Reply With Quote
Old 11-21-2008, 01:03 PM   #9
Brent4ADV
Enjoying empty roads...
 
Brent4ADV's Avatar
 
Joined: Jul 2007
Location: B'ham, AL
Oddometer: 1,006
Looks great

I will have to start plugging in some numbers for my CDT trip coming up next year. Thanks for the work!
__________________
01 KTM LC4-E
02 KTM 520 EXC
My TAT Ride '08
Brent4ADV is offline   Reply With Quote
Old 11-21-2008, 01:18 PM   #10
sassage
Wanderer
 
sassage's Avatar
 
Joined: Oct 2008
Location: Kansas City
Oddometer: 156
planning? i'll just figure it out when i get back home

nice looking spreadsheet you worked up, i like it. thanks and I added it to my favorites.
__________________
A witty saying proves nothing.

1994 Honda XR650L
2002 Honda VTX1800C/R/F
2000 Honda VTR1000F Superhawk
2000 Ducati 996
sassage is offline   Reply With Quote
Old 11-22-2008, 02:40 AM   #11
GoGo Gadget
Beastly Adventurer
 
GoGo Gadget's Avatar
 
Joined: Apr 2004
Oddometer: 1,256
Plan the finances? Where is the fun in that. I plan the route. That is fun. I plan the sites. That is fun. I plan the gear. That is fun. I leave with a credit card in hand and have fun. Come back and give to my wife to figure out how to pay off. Not so much fun there, but I can deal with it.
__________________
I don't know how or when I'll die, but I know someone will be holding my beer for me when I do.


I have been told I have the body of a God. What does this Buddha guy look like?
GoGo Gadget is offline   Reply With Quote
Old 11-23-2008, 07:47 PM   #12
WQFTruckster OP
Adventure Engineer
 
WQFTruckster's Avatar
 
Joined: Jun 2007
Location: North Central Florida
Oddometer: 61
Quote:
Originally Posted by GoGo Gadget
...I leave with a credit card in hand and have fun. Come back and give to my wife to figure out how to pay off.
You must tell me how you do this. Usually, my wife is the one with the credit card and I'm the one figuring out how to pay it off.
__________________
HID Helmet Mounted Adventure Lighting
WQFTruckster is offline   Reply With Quote
Old 11-23-2008, 07:53 PM   #13
WQFTruckster OP
Adventure Engineer
 
WQFTruckster's Avatar
 
Joined: Jun 2007
Location: North Central Florida
Oddometer: 61
Thanks for all of the positive responses. I really like the smart phone idea. Too bad all I have is a dumb phone.

Just a quick update, I tweaked a few things and added a couple of graphs in the current Excel download version.

too cold to ride + bored engineer = fun with excel spreadsheets

Enjoy!

BTW if there are any fellow Excel gurus (nerds?) out there that are interested in modifying this sheet for their own use, send me a PM and I will send you the password to unlock the sheet.
__________________
HID Helmet Mounted Adventure Lighting
WQFTruckster is offline   Reply With Quote
Old 11-24-2008, 06:10 PM   #14
brianjonesphoto
Single Track Noob
 
brianjonesphoto's Avatar
 
Joined: Feb 2007
Location: The Brier Patch, WA
Oddometer: 1,546
Nicely done! Would it be possible to add a field for a second bikes average fuel? It would make it a little slicker for a couple traveling together on 2 bikes

Thanks
__________________
Brian
Mine: 07 DL650 ABS, 99 DR350SEx, 05 Montesa 4RT Her's: 02 KL250 Super Sherpa

www.PhotoSupportNW.com

brianjonesphoto is offline   Reply With Quote
Old 11-24-2008, 06:31 PM   #15
WQFTruckster OP
Adventure Engineer
 
WQFTruckster's Avatar
 
Joined: Jun 2007
Location: North Central Florida
Oddometer: 61
Quote:
Originally Posted by brianjonesphoto
Nicely done! Would it be possible to add a field for a second bikes average fuel? It would make it a little slicker for a couple traveling together on 2 bikes

Thanks
Good idea, I'll see what I can do.
__________________
HID Helmet Mounted Adventure Lighting
WQFTruckster 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:54 PM.


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