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. Many of the spreadsheets related to the EPB standards have been developed parallel to the preparation of the set of EPB standards under the M/480 mandate from the European Commission (2012 - 2017) and do not necessarily reflect the final status of the standard.

About this spreadsheet: Updated version (Nov. 2019, see details below)

Download file Demo_XLS_on_ISO_52010-1_2019-11-20.zip
Geographical scope:
Calculation procedures
Published date:
July 5, 2016
Updated date:
Nov. 20, 2019
  • Overarching
EPB Center

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.