World Trip Weather Planner

nylon2000 · 03-25-2013, 08:39 PM

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!

pastou · 03-26-2013, 07:38 AM

This one is amaizing !!! i'll have a closer look to it !
thx

nylon2000 · 03-26-2013, 08:42 AM

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?

pastou · 03-26-2013, 08:47 AM

Quote:

Originally Posted by nylon2000

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 :)

nylon2000 · 03-26-2013, 09:22 AM

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

03-25-2013, 08:39 PM	#1
nylon2000 ^OP Wanderer Joined: Feb 2013 Location: NYC Oddometer: 185	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

03-26-2013, 07:38 AM	#2
pastou Adventurer Joined: Jan 2013 Location: Rueil - France Oddometer: 11	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

03-26-2013, 08:42 AM	#3
nylon2000 ^OP Wanderer Joined: Feb 2013 Location: NYC Oddometer: 185	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

03-26-2013, 09:22 AM	#5
nylon2000 ^OP Wanderer Joined: Feb 2013 Location: NYC Oddometer: 185	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

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: .
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode