Spreadsheets for Download

The following spreadsheets were developed by Bill Klein of the NW Michigan Horticultural Research Station. They are formatted to be used in Microsoft Excel97. Please send any questions to Bill Klein, kleinw@msu.edu.

Growing Degree Day Calculator – By entering the daily maximum and minimum temperatures this sheet will automatically calculate daily and seasonal GDD totals for any two base temperatures chosen. Uses either Baskerville-Emin or Averaging method depending on daily temperatures. No upper level cut-off. For those of you who want the real thing, here is a step by step calculation for Baskerville-Emin method from Dr. Jeff Andresen at MSU

Cooperative Observer Forms (WS Form B-92 and WS Form B-83a) – This spreadsheet was developed to aid in the completion of the monthly forms that are sent to the National Weather Service (NWS) from our observation site. These forms have not been approved by the NWS but they have not been rejected by them when I send them in each month either. Please read the instructions and information on the first worksheet and any comments on the second (daily data entry) sheet. This sheet was revised based on new NWS information on 2/22/02.

Wind Chill Calculator – This spreadsheet uses the new formula that is now being used by the NWS to better represent how wind and temperature interact on human skin.