Sinclair (2001): Biologically relevant environmental data: Macros to make the most of microclimate recordings.

Sinclair, B.J. 2001. Biologically relevant environmental data: Macros to make the most of microclimate recordings. Cryo-Letters 22: 125-134.

Automated data loggers make it possible to gather vast quantities of environmental data, but the quantity can be overwhelming, limiting interpretation to means, rather than the biologically relevant thresholds. This paper presents macros for Microsoft Excel that calculate rates of change of a data series that has crossed a threshold; it will count the number of times a threshold is crossed (and allows for the decreasing threshold being different from the increasing threshold), and for calculating the amount of time that a threshold is exceeded. These macros are available electronically from the author bjs@sun.ac.za.