Growth Regulators in Orchard Management
University of California
Growth Regulators in Orchard Management

Dynamic Model: Sorting Temperature Data to Get Hourly Data

UC Fruit & Nut Center: Chill Models

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).

Fig. 1. Unsorted temperature data from data logger
Fig. 1. Unsorted temperature data from data logger

Fig. 2. Sorted data from data logger, to select hourly data
Fig. 2. Sorted data from data logger, to select hourly data

Webmaster Email: jmzalom@ucdavis.edu