A macro-enabled Excel tool developed to support Environmental Health Officers in delivering consistent, transparent hazard scoring under HHSRS2 (HHSRS 2026).
Designed for UK housing professionals preparing for the June 23rd 2026 HHSRS v2 rollout.
- Calculates HHSRS2 (HHSRS 2026) hazard scores automatically
- Assigns High, Medium, and Low risk bands
- Supports the 21 consolidated housing hazards
- Provides a simple, inspection-ready Excel interface
- Reduces the need for manual scoring calculations
- Easy to access hyperlinks for all hazard case studies
- Allows users to create a Full Hazard Report for landlords
- Environmental Health Officers (EHOs)
- Local Authority housing teams
- Private Sector Housing enforcement officers
- Housing surveyors and inspectors
- Regulatory compliance professionals
This tool is designed to ensure a smooth, consistent transition between existing HHSRS guidance and HHSRS2 (HHSRS 2026).
With limited official tools and case studies currently available, it provides a practical, real-world solution for calculating hazard scores during inspections.
👉 Go to the Releases section of this repository (next to the preview picture on PC or at the bottom of this readme on mobile) and download the latest version (currently v4.5.2 - Macro)
- This spreadsheet contains macros (required for scoring calculations)
- You will need to enable macros when opening the file
- No external data connections are included
- Right-click the downloaded file
- Select Properties
- Tick Unblock
- Click Apply
- Open the file and click Enable Macros
- ✅ Automated hazard scoring calculations
- ✅ HHSRS2-compatible structure
- ✅ Consistent risk banding outputs
- ✅ Designed for field-based inspections
- ✅ Fully offline Excel tool (no subscription required)
This tool helps address current gaps by:
- Providing a consistent scoring approach
- Supporting risk band calculation without full case study availability
- Enabling officers to apply structured hazard assessments in practice
**v4.5.2 - Macro Complete rework from the ground up. New design features. Added stability. No password protection.
User guidance is available in the /instructions folder within this repository.
``
HHSRS2 scoring sheet, HHSRS calculator Excel, housing hazard scoring tool, environmental health risk bands, UK housing inspections, HHSRS v2 tool, HHSRS 2026, housing health and safety rating system calculator
For any questions, feedback, or suggestions, feel free to get in touch or raise an issue on this repository.
This tool is intended to support professional judgement for those HHSRS trained and does not replace official guidance or statutory requirements.