Demo (EN) ISO 52010-1 (Climatic data conversion)
Tool to perform the conversion of climatic data for energy calculations, according to the corresponding EPB standard, EN ISO 52010-1.
The spreadsheets related to the EPB standards are provided to demonstrate specific elements of the calculation procedures in the relevant standard(s). Consequently, they do not replace the EPB standards, but they shall be used along with the EPB standards.
Please read also the disclaimer in the spreadsheet.
NOTE: A set of meteorological data (a Typical Meteorological Year, TMY), with data values for every hour in a year for a given geographical location, can be generated using a tool developed and made available by the EC Joint Research Centre (JRC).
NEW (Jan.2021): The EPB Center has created a tool to convert a JRC-TMY data set into the format that is needed as input for this demo XLS on (EN) ISO 52010-1. Link
About this spreadsheet: Updated version (Nov. 2019, see details below)
About this spreadsheet
This spreadsheet comprises a full annual calculation of the hourly solar irradiance on a vertical or tilted plane, using measured solar irradiance on a horizontal plane.
The calculation can be done as stand alone file, for a single plane
Or (!new, in the updated version of Nov. 2019):
Via a separate configuration file calculations can be performed for a number of specific planes in one calculation run, with climatic data obtained from a separate data file. The output is provided in a separate output file, in the format that is needed in the climatic data sheet of the spreadsheet on ISO 52016-1 (calculation of energy loads & needs for heating and cooling and indoor temperatures). Although the calculation concerns only the conversion of solar radiation, all other climatic data (temperature, wind, ...) needed for e.g. ISO 52016-1 are also read from the climatic data file and copied to the output file.
Solar shading by external objects:
Solar shading by distant external objects is covered in EN ISO 52010-1 and was covered in the first version of the spreadsheet on this standard. However, to avoid double counting, it is prefered to calculate solar shading by external objects, whether distant, remote or from own building elements, all combined, as part of the calculation according to EN ISO 52016-1 (or any other application, such as shading on solar collectors or solar panels). The calculation rules are given in EN ISO 52016-1, Annex F. See Links below for the spreadsheet.