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 answers that question on one screen. Risk Register auto-scores every risk, draws the heat map, and flags reviews when they come due. 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 Plan.