25 Years of Programming
An open source source for C, C++, OWL, BASIC, MDB, XLS, DOT, and more...
Weather.xls Excel 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, normal, and record highs/lows, so you can see graphically how the daily temperatures compared to the normal and record ranges. The spreadsheet has some data in it so you can see how it works before entering your own.
There are two additional trivial sheets in the workbook. One shows calculations that I once did to figure out how to calculate relative humidity, and a third shows how to interpret "percent probability of precipitation" predictions.
I used red text for heat (Highs) and blue for cold (Lows). The Fixedsys font was the one I liked best of the ones available in Windows 3.1, and it showed the colors well. It is easy to change the worksheet to a different font.
Changing the topmost date to the current year causes all the other dates, and the days of the week in Column A, to auto-adjust. In leap years, there is a Feb 29. In ordinary years, the row is a duplicate of Feb 28.
The High and Low values in Columns C and D are initially set (using cell formulas) to equal the corresponding Normal values in E and F. Overwrite cells in C and D with the actual values as they occur.
At the bottom of the table is an area where descriptive statistics are calculated. The formulas can serve as examples of how to use the Excel statistical functions. Throughout the worksheet are comments describing what is being calculated or what the significance of a cell's value is.
This chart, automatically generated from the data table, shows the Record Highs and Lows (brown top and bottom), Normal Highs and Lows (yellow), and the Actual Highs and Lows (red and blue). It is easy to see how actual values fluctuated above or below the normal range and in relation to the record Highs and Lows.
This chart shows whether the year as a whole is progressing as warmer or colder than normal.
Copyright ©2012 Steven Whitney. Last modified Wed 11/28/2012 21:02:32 -0800.