World Trip Weather Planner

Discussion in 'Trip Planning' started by nylon2000, Mar 25, 2013.

  1. nylon2000

    nylon2000 Wanderer

    Joined:
    Feb 8, 2013
    Oddometer:
    253
    Location:
    NYC
    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).

    [​IMG]

    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:
    [​IMG]

    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:

    [​IMG]

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

    [​IMG]

    No idea how to attach a file here, but you can grab a copy from here:
    http://www.horizonsunlimited.com/hubb/route-planning/world-weather-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!
    #1
  2. pastou

    pastou www.2mil.fr

    Joined:
    Jan 27, 2013
    Oddometer:
    15
    Location:
    Rueil - France
    This one is amaizing !!! i'll have a closer look to it !
    thx
    #2
  3. nylon2000

    nylon2000 Wanderer

    Joined:
    Feb 8, 2013
    Oddometer:
    253
    Location:
    NYC
    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?
    #3
  4. pastou

    pastou www.2mil.fr

    Joined:
    Jan 27, 2013
    Oddometer:
    15
    Location:
    Rueil - France
    i was trying to open the mac OS version under windows :clap:clap:clap

    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 :)
    #4
  5. nylon2000

    nylon2000 Wanderer

    Joined:
    Feb 8, 2013
    Oddometer:
    253
    Location:
    NYC
    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
    #5