Version 3 of the Monarch Degree Days Workbook is available for download:mDDworkbook-v3.xls
Taking the K.I.S.S. method to heart we have decided to provide this first temperature monitoring workbook with only a single spreadsheet. We will probably add a summary page to allow easy access to monarch Degree Day values by date (24-hour period) and perhaps some other details such as max/min temperatures, etc. but we'd like to get your thoughts on this first.
In this version I have decided to stay away from using macros since I do not know how well they will translate across all spreadsheet programs that are being used. Rather, simple functions are used to automatically do the necessary calculations provided that your data are copied and pasted into the appropriate cells. I think this is pretty straightforward but please share any questions or concerns here.
Download the workbook file using the link above and then follow the directions in the "Instructions for Retrieving Data" thread. Once you have all of your hourly temperature data in three columns of a spreadsheet you need to do a few things before pasting this information into the Monarch Degree Days Workbook:(1)
make sure that the first row of data corresponds to the first hour of a day (the midnight hour, which will appear as 0:## or 12:## AM). You will probably need to delete a few entire rows of data to do this.(2)
insert a blank row at the top so that your temperature data begins with the midnight hour in row #2 of your spreadsheet. To do this select the first cell (A1) and choose Insert --> Rows from the menubar in Excel. [If you are using another spreadsheet program please let me know what the appropriate command/menu item is - thanks!](3)
select the three columns of your hourly temperature data (in their entirety) and copy them.
Now open the Monarch Degree Days Workbook. You will be presented with a single worksheet, "Monarch Degree Days" into which you will paste your data and review the resulting values.
Select the upper-leftmost cell (A1) and paste your data here. [Confirm that cells A1, A2, and A3 are empty and that your temperature data begins on Row 2; if this isn't the case please revisit the steps listed above to prepare your "raw" data.]
You will notice that the numbers in the other three columns of this worksheet will change. We will discuss these columns in greater detail later, but from left to right they are Adjusted T (a temperature adjustment necessary for the Monarch Degree Day calculation), mDD (monarch Degree Days), and Acc mDD (accumulated monarch Degree Days).
The sheet is set up to accept 80 days worth of hourly data (24 hours x 80 days = 1920 rows).
All numbers used in these calculations are monarch specific; we plan to include other sheets that will be able to calculate Degree Days for other plants (e.g., milkweed) and animals (e.g., monarch predators), all using the single hourly temperature data set you record with your temperature logger.
We have not yet worked out the details of getting your data to us, but it will either be by entering the data online or by sending us your workbook files via email (probably the latter for the initial study).
So take this worksheet for a test drive with your temperature data and let us know how things turn out. If you have any questions along the way please let us know. Thank you for your patience!