This spreadsheet comprises a full annual calculation of the hourly shading reduction factors.

UPDATED VERSION (March 2022): A few errata have been removed.

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 comprises a full annual calculation of the hourly shading reduction factors.
Prime application: EN ISO 52016-1 (calculation of energy needs for heating and cooling and internal temperatures)
But also applicable to system components, such as thermal solar collectors and photovoltaic panels.
The calculation procedures used in this spreadsheet are fully described in the normative Annex F of (EN) ISO 52016-1.

The shading reduction factors here may concern distant obstacles (if not already taken into account in the output of (EN) ISO 52010-1)
and obstacles on (or close by) the building itself and overhangs, side fins and rebates (especially for windows).

In this spreadsheet max 3 objects that are (potentially) shaded can be specified.
One potentially shaded object can be assigned to different (e.g. window) elements in the same building, if these have the same orientation and tilt and similar position relative to the obstacles and overhangs.
Each object is described by it's position (orientation and tilt, height above ground, height)

For calculating the shading, max 3 obstacles and max 1 overhang can be chosen for each object.
These obstacles and overhang can be chosen from a list of max 6 obstacles and 3 overhangs (the "library"), as input for the calculation

The distance and height of each obstacle and overhang is given per segment of the skyline.
For this purpose, the skyline (360 degrees) is divided into a number of (for this spreadsheet: max 15)  segments.
The default is 8 segments of equal size (ergo: segments of 45 degrees each).

This spreadsheet can be used as stand-alone tool.
 In that case not only the (hourly) solar height and azimuth is needed as input, but also the hourly total and diffuse solar irradiance for the orientations and tilt angles of the specified objects.
The output of this spreadsheet can also be linked to (copy-pasted in) the spreadsheet on (EN) ISO 52016-1
(in the update under preparation, autumn 2021)

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
• The page on the case study to explain and demonstrate this tool