A risk register is broader than the NEC Early Warning Register. It's project management standard rather than contractually mandated, and it should capture everything that could derail or accelerate the project — including opportunities, not just threats. Done properly, it's a live document reviewed monthly with the whole project team, owned by the PM, and feeding the monthly board report.
This toolkit gives you a full risk register with probability × impact scoring, response strategies, pre and post-mitigation views, expected monetary value (EMV), and a 5×5 heatmap that visualises the risk landscape. It tracks both threats and opportunities — many registers ignore opportunities, which means projects miss the upside they could have captured.
The Action Tracker keeps the mitigation actions visible and accountable, with owners and due dates. The Top 10 Risks tab uses LARGE + INDEX + MATCH to rank automatically by EMV — no manual re-sorting. The dashboard shows the headline KPIs and EMV by category.
What's inside:
- Cover & Guidance — methodology, response strategies for threats vs opportunities
- Set-Up Page — probability scale, impact scale, EMV multipliers, score bands
- Risk Register — 19 columns covering ID, category, description, owner, pre-mitigation P×I, response strategy, mitigation action, post-mitigation P×I, residual score, residual cost, EMV, status
- Heatmap — 5×5 grid showing residual position
- Top 10 Risks — auto-ranked by EMV
- Action Tracker — 16 sample actions with owners, due dates, status
- Dashboard — KPIs, threat / opportunity split, EMV by category bar chart
