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: FEB. 2026: NEW VERSION available !! Read details below….
Links
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.
Including (version 2.92, Oct. 4, 2023):
Several new features, such as:
- Optional: Adaptive comfort criteria according to EN 16798-1
- Thermal comfort scores, based on the recommendations from the EU ALDREN project
- Hourly building use profiles based on EN 16798-1, extracted from the spreadsheet: the Use Profile Generator
- 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 such as movable solar shading provisions, according to EN ISO 52016-3:2023, incl. Amendment_1:2025
!! NEW, version 3.00, Feb. 16, 2026:
Main new features, primarily aiming to expand and facilitate the use as demonstration and validation tool:
-
Input data for building elements no longer per element (U-value, thermal capacity), but per construction layer of each building element.Remember that ‘input data per building element’ was a deliberate choice for EN ISO 52016-1:2017 to avoid the claim that for hourly calculations more input data are needed from the user than for monthly calculations.
- A sheet with the calculated temperatures of all nodes for two selected days, plus:
A summary of the hourly calculation results according to the template for validation described in ASHRAE 140-2023, the “BESTESTS” envelope cases. - A simple to use work around for the hourly calculation of multiple, thermally coupled zones, just for testing and validation purposes.
Note that these changes led to a new format for the input data files (now version 2.40).
Consequently, the download packages also contains new example input data files.
Package 1 (see 1st download link below):
the demo calculation file (few examples), plus examples of climatic data files and input data files:
Demo_XLS_on_ISO_52016-1_v3.00_2026-02-16.zip
Package 2 (see 2nd download link below:
the configuration file for the work around multizone calculations,plus example input data and result files:
Demo_XLS_on_ISO_52016-1_MultiZone_2026-02-16.zip
Also new: a detailed Application Guide, that can be viewed or downloaded here: