Where can I find historical rainfall data?
Historical rainfall data is easy to obtain from various sources, but the best options differ depending upon your needs. Below, we’ll help sort through the options to find the easiest and best way to obtain historical rainfall data for your project. Single Location and Single Date If you need historical rainfall data for only a …
Continue reading “Where can I find historical rainfall data?”
How We Process the NOAA Integrated Surface Database Historical Weather Data
We use a lot of sources for our weather data. One of the richest sources of historical weather data is the Integrated Surface Database (ISD) from NOAA. The amount of data available is impressive. Hourly or sub-hourly weather records for 1000s of weather stations that are, in some cases, over 100 years old. However obtaining and manipulating …
Continue reading “How We Process the NOAA Integrated Surface Database Historical Weather Data”
Using Microsoft Excel to Analyze Gardening Weather – Part 3, Growing Degree Days
PART 3 – CREATE A GROWING DEGREE DAYS CALCULATOR USING HISTORICAL AND FORECAST WEATHER DATA Download the free Degree Day Excel workbook (no add-in required) Learn more In our previous gardening weather blog, we have learned how to use Microsoft Excel to analyze the historical and forecast weather data of a location. We can now identify the …
Continue reading “Using Microsoft Excel to Analyze Gardening Weather – Part 3, Growing Degree Days”
Using Microsoft Excel to Analyze Gardening Weather and Climate – Part 2
PART 2 – CREATING AN MICROSOFT EXCEL GARDENING WEATHER FORECAST In our previous gardening weather blog, we set up a Microsoft Excel workbook that displays a summary of the historical weather information for a location targeted towards the gardener. With the historical Excel workbook, we can understand the climate that they can expect for a particular …
Continue reading “Using Microsoft Excel to Analyze Gardening Weather and Climate – Part 2”
A Mountain of Weather Data
Does the number of people who visit Mount Rushmore depend on the weather? In this blog I investigate the correlation between the daily Mount Rushmore visitor counts and the weather that occurred on those days. I was in the process of considering a trip to visit Mount Rushmore, and being a data guy, I decided …
Using Microsoft Excel to Analyze Gardening Weather and Climate – Part 1
PART 1 – CREATING AN HISTORICAL WEATHER DASHBOARD It’s hard to think of an activity that depends on the weather and climate more than gardening. How cold does my location get? When is the last frost date? Is it too hot for this kind of plant? Do I need to water, or will it rain …
Continue reading “Using Microsoft Excel to Analyze Gardening Weather and Climate – Part 1”
Weather Data in Microsoft Excel
Does weather affect my business? This seems like a simple question but as many of us have quickly learned, it is not a simple task. I have performance data for a set of stores and I am pretty certain that weather has been affecting my business, but I need create an analytical sheet to be …