Weather data - Latin America Planning Tool
 

While preparing for our round the world trip we were inspired by Jay Kannaiyan (also known as Jammin Jay) and his weather spreadsheet so I started my own. We want to share this with you.

For now this includes a Central and South America weather spreadsheet that has average temperature, average high temperature, and average rain fall (inches) by month. For most countries more than one city location was used as weather can vary within a country. The information was taken from weatherbase.com. I then color coded ranges so that we could track our ideal and overlaid the rain and temperature information. The ranges are noted in fahrenheit and celsius otherwise all data is in fahrenheit and rainfall is in inches as we are both from the US. The excel version is attached so anyone is able to adapt is and change formula for conversion. We are currently working on Europe, Central Asia and Southeast Asia spreadsheets which we will share when finished.

The Excel version is available for download: Weather Latin America

It has two worksheets within the document. The first includes multiple tables and the second is the summary like the photo below.
http://www.smboilerworks.com/superco...in-America.jpg

Weather data - Latin America Planning Tool
 

SMBoilerworks: Hello. Thank you very much for your time and effort to prepare the data. Over-laying the rainfall data is a fantastic idea and a very useful tool to save hours of planning for others. I am researching a Central/South American trip starting during the fall of 2016 and departing from California and your data will be very helpful. Thanks again for your contribution to the forum! David

SMBoilerworks,
That is great information to have as I plan my trip south. Couple of questions for you:
-On the first chart on top line, why does the first entry for Sept have a value of 88 while the second entry for Sept has 78? The same inconsistency runs throughout the chart.
-Could you explain what the second chart represents? It seems to have rainfall amounts, yet uses the temperature color coding. Am I missing something?
Thanks!

Hi Huskydogg,
I just opened it and the reason is because one chart is "average high temperature" and then next one is "average temperature". We were interested in how hot can it get in places so we pulled the temperatures as both average high and as plain/regular average. This is also one the color coding is pretty much the same or small differences only.

We also did the color coding based on our preferences; example we really wanted to avoid the deep red and deep blue.

On worksheet one:
All in all - there are two temp charts: average temp and average high
Rain chart that is just that: average rain
Then there is one overlay chart that has rain and average high temp

On worksheet two - overlays:
1. rain plus average high temp
2. rain plus average temp
3. rainfall with color coding of average temp

Let me know if there are any other questions.

Cheers, Shannon

into each ride a litle rain shall fall
 

Late Sept to late Oct is the classic time to head south. Hurricane season in the Atlantic begins June 1st and ends November 30th. Those seasonal weather patterns drift into Central America. Be sure to pack rain gear in any event. Your never gonna avoid all the rain drops.

:rain: :rain: :rain: :rain: :rain: :rain: :rain: :rain: :rain: :rain:
:rain: :rain: :rain: :rain: :rain: :rain: :scooter: :rain: :rain: :rain:

For those that are made of brown sugar, think about getting home. On the a return leg in June 2013 I encountered drenching rain 5 out of 6 riding days (Texas > Florida > New Jersey)