Dynamic Model: Sorting Temperature Data to Get Hourly Data
Dr. Kitren Glozer, Dept. of Plant Sciences, UC Davis
If you collect temperature data every 10 minutes from your datatlogger, and need hourly data to input to the Dynamic Model spreadsheet, here is how you can 'fix' your 10 minute data to get hourly intervals. The spreadsheet file convert chill from 10 or 30 min to hour contains all the instructions, as well as the form for sorting your data.
Below (Figures 1 & 2) is an example the file with unsorted temperature data in columnn C (this is 'dummy data' for this illustration).