The Climate Toolbox—A Microsoft® Excel® Based Tool for Assessing and Comparing the Effects of Internal Climates on Museum Artefacts

Abstract

This paper describes the Climate Toolbox—a set of utilities for assessing and comparing real internal climates in terms of hazards they pose to museum collections. The Toolbox is a Microsoft® Excel® workbook with complex VBA codes optimised to process large datasets efficiently and quickly. The Toolbox takes user-provided climate data (up to 8000 sets of temperature, T, and relative humidity, rh, data) and characterises the climates in terms of critical parameters for stresses and mechanical damage, risk and magnitude of mould, relative permanence compared to (selectable) reference specifications, the proportion of data lying within and without selectable specification ranges, and the proportion of rh data swings exceeding a given magnitude. The interface is easily customisable, allowing users to input desired specification ranges, insert opening and closing times (to allow for different temperature specifications for periods when a space is open and occupied to when it is closed and empty), selectively change material critical strain parameters, and adjust the cycle periods for stress analysis. Results are summarised in a range of different graphical and tabular outputs and can be processed further to compare and rank spaces for their suitability to house different collections.