Login

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. 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, read details below)

Download file Demo_XLS_on_ISO_52016-1_2019-11-20b.zip
Geographical scope:
Global
Theme:
Calculation procedures
Published date:
April 22, 2015
Updated date:
Nov. 20, 2019
Topics:
  • Building as such
Responsibility:
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.

UPDATED VERSION (Nov. 2019)

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):

Links