Housing Need and Demand Assessment (HNDA) Tool Instructions (2026)

4. Results: Where to find results and how to interpret them

Finding and interpreting results

The Tool results are displayed in several ways depending on what users need. This includes:

• ‘Results’ = summary results (use to populate the ‘Key Findings Template’
• ‘RawResultsCore’ = detailed results using the core (default) settings.
• `RawResultsSummary’ = detailed results using your scenario settings.

Both sets of raw results populate the summary results.

Worksheet called ‘Results’

• shows annual(ised) estimates for additional housing units for groups of years within the projection period.
• the default is set at 5 yearly intervals e.g. 2026-2030, 2027-2031 etc. but these intervals can be changed using the drop-down box at the top left of the screen (to 4, 5, 6, or 7 year intervals).
• estimates represent the value for each year in that time interval. To get a total value for all five years, multiply by 5.
• Results displayed by banded years are useful because planners and policy makers often need to work in periods of time rather than single years. This is the case for LHS and LDPs.
• The green-shaded values show the default (core) results and the orange-shaded values show the user’s results.
• Results for the whole area are shown at the top of the page and results for each sub-area are shown below this.
• Totals are shown for each tenure.
• For each area three sets of results are displayed:

1) ‘Top Level’ = total for the whole area e.g. local authority, regional, National Park

2) ‘Summed’ = total based on the sum of any sub-areas (HMAs).

3) Constrained = if changes were made to the sub-areas, the sub-areas

(and differences between them) are constrained to the total for the wholeareas (1).

This ensures that the total of the sum of the sub-areas is the same as the total for the whole area, whilst at the same time ensuring that the results reflect the differences between the sub-areas.

Worksheet called ‘RawResultsScenario’

• Shows results for the user scenarios for every year, every tenure and every sub-area. These are the most detailed results. These are the most detailed results and have not been summarised in any way. The ‘RawResultsCore’ is the same but for the Tool core(default) settings.