The event risk register template that doesn't die in a drawer.

Every event has a risk register. It gets written in a serious mood during master planning, filed with the authorities for the permit, and then never opened again. It works right up until something happens — and by then it is a year out of date.

I have written that register before every major event since the 2000s, and watched it fall asleep in a drawer every time. The problem is not that organisers don't care about risk. It is that a spreadsheet makes staying current more expensive than going stale.

Why the spreadsheet register goes quiet

• The score column holds a dragged formula — =M6*N6+O21 — quietly referencing the wrong row. The total looks plausible and is wrong.
• Thirty-five columns of x-marks. Filling it feels like an audit, so it happens once and never again.
• The steering group asks "what are our top five risks right now?" and the answer is silence and a sideways scroll.
• Probability was scored 1–3 in one year's file and 1–5 in the next. Your own registers don't agree with each other.
• There are names in the owner column, but no review dates. Whether any mitigation happened, nobody knows.

What an event risk register template needs

A register earns its keep when it is cheaper to keep current than to let slide. That takes a few things Excel won't give you on its own.

• Scores that compute themselves. Set probability and impact on the same 1–5 scale every year; the score, the band and the colour follow. No dragged formula pointing at the wrong row.
• A live heat map. The 5×5 matrix draws itself from the register in real time, so "show me the top five" takes seconds, not a scroll.
• Owners, plans and review dates. Every risk carries a response and a review date. Passed dates turn red and count on the board — the register nags you before it goes stale.
• Before and after. Score the residual risk once mitigation is in place, and show both pictures on the same heat map. Proof the work moved the needle.

The point of a risk register isn't the permit

It is the meeting where someone asks what could go wrong and what's being done about it. A register that lives — Risk Register auto-scores every risk, draws the heat map, and flags reviews when they come due — answers that question on one screen. It still prints the authority-ready PDF for the permit. It just stops being a document you write once and forget.

And a register only names what could go wrong. When you want to write what you actually do when it happens — the response steps, the owners, the activation trigger — that pairs with Contingency Planner.