Register Inmates Photos Site Rules Search Today's Posts Mark Forums Read

 11-06-2014, 06:38 PM #2 ZJeepMI Gnarly Adventurer     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
 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
 11-09-2014, 07:42 PM #4 justafurnaceman Imaginary     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
 11-21-2014, 11:16 PM #5 Project510 n00b     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!
 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)
 11-24-2014, 10:42 AM #7 Mr_Gone The Lejund!     Joined: Jul 2010 Location: Mountain Home, AR Oddometer: 8,644 Great job!!!
12-08-2014, 09:35 AM   #8
DJFriar

Joined: Nov 2014
Location: Plano, TX
Oddometer: 26
Quote:
 Originally Posted by alicethomas 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.

 01-03-2015, 08:18 PM #9 Bern Is it hot in here?     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
 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
 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.
 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
 01-22-2015, 09:59 AM #13 Str8lin Studly Adventurer     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!
 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.
 01-22-2015, 11:52 AM #15 Mr Head PowerPoint ADV     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

 Share