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)

Download file
Geographical scope:
(EP) 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.