RAID Log Excel Template | Programme Risks, Issues, Assumptions, Dependencies, Decisions Pack

PMO-grade RAID + Steerco pack — built by a programme manager who has actually run the Friday steerco prep, not a template designer.

10-sheet Excel system. Worked example included. Built by a Lean Six Sigma Black Belt and project management practitioner.

Every PMO uses RAID. Most do it badly: one Excel sheet per artefact, no relations, no sponsor view, then a panicked Friday morning rebuilding the steerco pack from scratch. This template fixes that — Risks, Issues, Assumptions, Dependencies and Decisions live as separate sheets, Actions roll up from all of them, and the Steerco Pack sheet builds itself.

WHAT YOU GET

- Workstreams sheet — code, owner, RAG, with auto-counts of open risks, open issues, open decisions per workstream
- Risks sheet — Probability (1-5) × Impact (1-5), auto-score, auto-RAG (Red ≥15, Amber 8-14, Green ≤7), mitigation, trigger, last reviewed
- Issues sheet — severity, raised date, owner, resolution, target close
- Assumptions sheet — open vs validated, validation method
- Dependencies sheet — internal and external dependencies with hard/soft gate, required-by date
- Decisions sheet — reversibility flag (reversible / one-way) and reverse-cost £ — to filter the two-way doors from the one-way doors
- Actions sheet — every action from any source in one register; never lose an action again
- Steerco Pack sheet — auto-builds five blocks: RAG by workstream, top 5 open risks, decisions awaited, actions due in 7 days, plus a handwritten weekly narrative slot
- README with field definitions, RAG band rules and conventions

WHY THIS EXISTS

Programmes don't fail because no one wrote the risks down. They fail because:

1. Risks live in one sheet, decisions in another, actions nowhere — and nothing connects.
2. Reversibility isn't flagged on decisions, so reversible and one-way calls get treated the same.
3. Every Friday someone rebuilds the steerco pack from scratch.

This template addresses all three. One workspace. Reversibility as a first-class field. Steerco pack that refreshes itself.

WHO THIS IS FOR

- PMO leads and programme managers running 2+ workstreams
- Transformation directors reporting weekly to a steerco
- Heads of change on regulated programmes (Consumer Duty, ISO, audit)
- Operations directors running multi-site cutovers
- PMP and Prince2 practitioners who want the structure but not the bureaucracy

WHO THIS IS NOT FOR

- Single-project work — use a basic risk register
- Enterprise GRC — use ServiceNow / Archer
- Marketing campaign trackers — wrong vocabulary
- Aesthetic "PMO" templates (this is a working tool, not a deck)

WHAT'S IN THE WORKED EXAMPLE

Ardendale Logistics WMS Rollout programme. Four workstreams (Technical Build, Operational Readiness, Data Migration, People & Change). 6 risks, 5 issues, 4 assumptions, 4 dependencies, 5 decisions, 8 actions. RAG status set, P×I scoring populated, reversibility flagged on every decision, Steerco Pack auto-built and ready to read.

Includes the kind of detail you only get from real delivery — Marc on a platinum SLA decision, Helen on a one-way archive sweep, Lina chasing trainer evening availability, Daniel pre-buying agency cover. Real-sounding because it's real-pattern.

DELIVERY

Instant download. Excel .xlsx — Excel for Mac, Excel for Windows, Google Sheets compatible. No macros. Lifetime updates.

REFUND POLICY

Digital, non-refundable per Etsy guidance. If anything is missing or broken, message me — I'll fix it the same day.

SafetyDeskStudio — practical tools for operations.