The Climate Toolbox—A Microsoft<sup>®</sup> Excel<sup>®</sup> Based Tool for Assessing and Comparing the Effects of Internal Climates on Museum Artefacts
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<sup>®</sup> Excel<sup>®</sup> workbook with complex VBA codes optimised to process la...
| Main Author: | |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
MDPI AG
2023-04-01
|
| Series: | Heritage |
| Subjects: | |
| Online Access: | https://www.mdpi.com/2571-9408/6/4/198 |
| _version_ | 1827744938037608448 |
|---|---|
| author | Boris Pretzel |
| author_facet | Boris Pretzel |
| author_sort | Boris Pretzel |
| collection | DOAJ |
| description | 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<sup>®</sup> Excel<sup>®</sup> 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. |
| first_indexed | 2024-03-11T04:57:59Z |
| format | Article |
| id | doaj.art-4aab822375ac48b9b29ad444c9c0b6e4 |
| institution | Directory Open Access Journal |
| issn | 2571-9408 |
| language | English |
| last_indexed | 2024-03-11T04:57:59Z |
| publishDate | 2023-04-01 |
| publisher | MDPI AG |
| record_format | Article |
| series | Heritage |
| spelling | doaj.art-4aab822375ac48b9b29ad444c9c0b6e42023-11-17T19:28:18ZengMDPI AGHeritage2571-94082023-04-01643745375610.3390/heritage6040198The Climate Toolbox—A Microsoft<sup>®</sup> Excel<sup>®</sup> Based Tool for Assessing and Comparing the Effects of Internal Climates on Museum ArtefactsBoris Pretzel0Victoria and Albert Museum, London SW7 2RL, UKThis 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<sup>®</sup> Excel<sup>®</sup> 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.https://www.mdpi.com/2571-9408/6/4/198damageclimateriskfluctuations |
| spellingShingle | Boris Pretzel The Climate Toolbox—A Microsoft<sup>®</sup> Excel<sup>®</sup> Based Tool for Assessing and Comparing the Effects of Internal Climates on Museum Artefacts Heritage damage climate risk fluctuations |
| title | The Climate Toolbox—A Microsoft<sup>®</sup> Excel<sup>®</sup> Based Tool for Assessing and Comparing the Effects of Internal Climates on Museum Artefacts |
| title_full | The Climate Toolbox—A Microsoft<sup>®</sup> Excel<sup>®</sup> Based Tool for Assessing and Comparing the Effects of Internal Climates on Museum Artefacts |
| title_fullStr | The Climate Toolbox—A Microsoft<sup>®</sup> Excel<sup>®</sup> Based Tool for Assessing and Comparing the Effects of Internal Climates on Museum Artefacts |
| title_full_unstemmed | The Climate Toolbox—A Microsoft<sup>®</sup> Excel<sup>®</sup> Based Tool for Assessing and Comparing the Effects of Internal Climates on Museum Artefacts |
| title_short | The Climate Toolbox—A Microsoft<sup>®</sup> Excel<sup>®</sup> Based Tool for Assessing and Comparing the Effects of Internal Climates on Museum Artefacts |
| title_sort | climate toolbox a microsoft sup r sup excel sup r sup based tool for assessing and comparing the effects of internal climates on museum artefacts |
| topic | damage climate risk fluctuations |
| url | https://www.mdpi.com/2571-9408/6/4/198 |
| work_keys_str_mv | AT borispretzel theclimatetoolboxamicrosoftsupsupexcelsupsupbasedtoolforassessingandcomparingtheeffectsofinternalclimatesonmuseumartefacts AT borispretzel climatetoolboxamicrosoftsupsupexcelsupsupbasedtoolforassessingandcomparingtheeffectsofinternalclimatesonmuseumartefacts |