Weather.xls daily temperature log

This Microsoft Excel spreadsheet holds 1 year of daily temperature data (actual high/low, normal high/low, and record high/low for each day), calculates various statistics, and has a graph with 6 data series: the daily highs/lows, normal highs/lows and record highs/lows, so you can see how the daily temperatures compare to the normal and record ranges.

A second worksheet has my best guess about how to calculate relative humidity, and a third shows how to interpret "percent probability of precipitation" predictions.

The spreadsheet has some data in it so you can see how it works before entering your own.

Download:

The zip file contains:

• Weather2003.xls for Microsoft Excel 2003
• Weather5.xls for Microsoft Excel 5.0a
• Copying.txt (GNU GPL license)

weather.zip

About 160 KB.

Screenshots:

Great graphical weather forecasts from the National Weather Service, by US region.