Demo (EN) ISO 52016-1 (energy needs heating and cooling, internal temperatures and loads)

Tool to perform a full annual calculation of the heating and cooling loads and needs and indoor temperatures, with both the hourly and the monthly calculation method, according to the corresponding EPB standard, EN ISO 52016-1:2017.

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.

About this spreadsheet: UPDATED VERSION (Nov. 2019, read details below)

Download file
Geographical scope:
(EP) Calculation procedures
Published date:
April 22, 2015
Updated date:
Nov. 20, 2019
  • Building as such
EPB Center

About this spreadsheet

This spreadsheet comprises a full annual calculation of the heating and cooling loads and needs and indoor temperatures.

With both the hourly and the monthly calculation method given in ISO 52016-1:2017. Most input data for both methods are identical.

The side-by-side calculation using both methods enables comparison of both methods.

The hourly method can also be used to develop or validate the correlation factors for the monthly method. For that purpose the hourly method produces key monthly parameter values

Ground floor: The calculation of the thermal transmission through the ground floor according to ISO 13370:2017 has been fully integrated in this spreadsheet (both for the hourly and monthly method). Otherwise, a manual transfer of monthly output from the ISO 13370 spreadheet would have been required.


Completely revised version, in line with the final version of ISO 52016-1 (published in 2017)

Main changes compared to the previous version of the spreadsheet (2015):