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

Download file Demo_XLS_on_ISO_52016-1_2023-10-04add2.zip
Geographical scope:
Global
Theme:
(EP) Calculation procedures
Published date:
April 22, 2015
Updated date:
Nov. 21, 2023
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.

!!NEW VERSION: Oct. 4, 2023 (replacing test version Jan. 19, 2023)
With several new features, such as:

  • Adaptive comfort criteria according to EN 16798-1
  • Hourly building use profiles based on EN 16798-1, extracted from the spreadsheet: the Use Profile Generator (https://epb.center/support/documents/demo-en-16798-1/
  • A simple algorithm on the impact of ventilative cooling, to support the work of the Task Group in CEN/TC 156/WG 21, in particular concerning the development of a Ventilative Cooling Potential Tool (built on the VCPT developed in IEA EBC Annex 62).
  • An integrated special sheet to demonstrate and test the impact of reference control scenarios for adaptive transparent building elements for EN ISO 52016-3:2023 (https://epb.center/support/documents/iso-52016-3/), incl. draft Amendment

Update: Nov. 21, 2023: BESTEST input data files (cases 600, 640, 900, 940) have been added. Plus one calculation file with results (case 940).

At short notice additional examples (input data files on EN ISO 52016-3 cases) will be added to the set of files, as soon as these have been made up-to-date with the new version.