This spreadsheet enables (just for testing, demonstration and validation) the hourly calculation of three thermally coupled thermal zones using the spreadsheet on ISO 52016-1.
NEW (Jan. 2026)
More details on this tool: see below.
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.
More details on this spreadsheet
This spreadsheet enables to run the Demo Excel tool on ISO 52016-1 (hourly method) with two or three thermally coupled thermal zones
The aim was to enable to run three thermally coupled zones, as easy as possible and with a minimum of changes in the calculation tool.
The purpose is not to have high performance, but to provide a transparant tool and output data for testing, demonstration and validation.
It is only intended for testing and demonstration
The “work around” is that three files are calculated in succession, each containing one of the zones, independent from the other.
In the calculation the hourly temperatures in the adjacent thermal zones are read from three columns in the Excel file,
initially filled with arbitrary values, because they are unknown.
However, after the completion of the three calculations, the hourly calculated internal operative temperatures of each of the files (zones) are copy-pasted
in the three columns in all three Excel files,as new estimates.
This process is repeated (iterated) until these temperatures no longer change (within a specific tolerance).
See flow chart.
Links
- The page on the corresponding EPB standard (EN) ISO 52016-1
- The page on the accompanying technical report (CEN) ISO/TR 52016-2
- The page on the spreadsheet for (EN) ISO 52016-1
Flow chart:
