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 03-25-2013, 08:39 PM   #1
nylon2000 OP
Wanderer
 
nylon2000's Avatar
 
Joined: Feb 2013
Location: NYC
Oddometer: 253
World Trip Weather Planner

Something I've been building for my own trip, that I thought might be useful for you folks. I posted this on HorizonsUnlimited a few days back, and wanted to share here too (not sure how much overlap between both sites).



This excel weather planner takes into account:
- rainfall
- rainy days per month
- max temp
- min temp
- humidity
- heat index

Coverage area:
- Asia (partial)
- North America (partial)
- Africa
- SE Asia (partial)
- Australia (partial)

Looking for volunteers to help add cities, instructions are in the file.

You can see detailed data for each city on each of the above stats:


I assign a "discomfort level" to each data point, using 20C and no rain as the ideal weather. The further away from this ideal, the more discomfort.

You can choose your own tolerance to rain, heat or cold, and the summary will adjust automatically. To do this, just change the percentages in the weighting box, as seen below:



Just use the dropdown menu in the Output sheet to choose your cities:



No idea how to attach a file here, but you can grab a copy from here:
http://www.horizonsunlimited.com/hub...-planner-69535

Please let me know your comments.
Philip (aka NY-Lon)

PS. Those diagonal lines represent the trip I'm planning. Pretty sure I've timed it as optimally as I can at this point!
__________________
WineAndWater. West around the world, New York to London, then Africa. Raising money for Wine to Water, supporting clean water projects in 15 countries.

The expedition
About the bike
nylon2000 is offline   Reply With Quote
Old 03-26-2013, 07:38 AM   #2
pastou
Adventurer
 
pastou's Avatar
 
Joined: Jan 2013
Location: Rueil - France
Oddometer: 12
This one is amaizing !!! i'll have a closer look to it !
thx
__________________
Trips ==> http://www.2mil.fr
Way of living ==> o_O

pastou screwed with this post 03-26-2013 at 08:37 AM
pastou is offline   Reply With Quote
Old 03-26-2013, 08:42 AM   #3
nylon2000 OP
Wanderer
 
nylon2000's Avatar
 
Joined: Feb 2013
Location: NYC
Oddometer: 253
Thanks, I'm a dork ;)

Did you have problems opening it at first? I got an email notification of the initial response you gave. How did you fix it?
__________________
WineAndWater. West around the world, New York to London, then Africa. Raising money for Wine to Water, supporting clean water projects in 15 countries.

The expedition
About the bike
nylon2000 is offline   Reply With Quote
Old 03-26-2013, 08:47 AM   #4
pastou
Adventurer
 
pastou's Avatar
 
Joined: Jan 2013
Location: Rueil - France
Oddometer: 12
Quote:
Originally Posted by nylon2000 View Post
Thanks, I'm a dork ;)

Did you have problems opening it at first? I got an email notification of the initial response you gave. How did you fix it?
i was trying to open the mac OS version under windows

Your excel i a great work ! i see that using the http://www.weatherbase.com/ we should be able to add destinations easily ! that's great :) :) :)
I will test it for my next trip :)
__________________
Trips ==> http://www.2mil.fr
Way of living ==> o_O
pastou is offline   Reply With Quote
Old 03-26-2013, 09:22 AM   #5
nylon2000 OP
Wanderer
 
nylon2000's Avatar
 
Joined: Feb 2013
Location: NYC
Oddometer: 253
yeah, i wasnt going to be able to troubleshoot windows for ya ;)

I've just added Australia after someone on HUBB added the data for me.

If you add data, please post it there, and I'll merge it into the master file.

thanks
__________________
WineAndWater. West around the world, New York to London, then Africa. Raising money for Wine to Water, supporting clean water projects in 15 countries.

The expedition
About the bike
nylon2000 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 08:50 PM.


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