Projects template
Risk register
Score each risk by likelihood and impact, assign an owner and a response. A 5 by 5 heat map counts where the risks sit.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
2 sheets
- Register
- Heat map
61 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 209 filled cells in all.
Built in
- Charts
- Conditional formatting
- Dropdowns
- Frozen headers
- 1 chart
- 6 conditional format rules
A look at the Register sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Risk register | |||||||
| 2 | Rate likelihood and impact from 1 (low) to 5 (high). Score = likelihood x impact. | |||||||
| 3 | OPEN RISKS | HIGH | MEDIUM | AVERAGE SCORE | ||||
| 4 | 12 | 1 | 8 | 8.8 | ||||
| 5 | ||||||||
| 6 | ID | Risk | Category | Owner | Likelihood | Impact | Score | Level |
| 7 | R01 | Key vendor misses hardware delivery | Vendor | Morgan | 3 | 4 | 12 | Medium |
| 8 | R02 | Scope grows after sign off | Schedule | Avery | 4 | 3 | 12 | Medium |
| 9 | R03 | Lead engineer unavailable in December | People | Quinn | 2 | 4 | 8 | Medium |
| 10 | R04 | Data migration loses records | Technical | Morgan | 2 | 5 | 10 | Medium |
| 11 | R05 | Budget overrun on contractors | Budget | Jordan | 3 | 3 | 9 | Medium |
| 12 | R06 | Privacy review delays launch | Legal | Riley | 3 | 4 | 12 | Medium |
- risk
- heat map
- compliance
- project
More projects templates
ProjectsProject trackerTrack every task with an owner, status, priority and due date. Overdue work turns red and the summary counts update as you go.
ProjectsGantt chartA weekly timeline where bars draw themselves from each task start and end date. The current week is highlighted and progress shades the bar.
ProjectsProduct roadmapList initiatives once and see them laid out by lane and quarter on a board that builds itself. Capacity checks flag quarters that are overbooked.
ProjectsIssue and bug trackerLog bugs and requests with severity, status and assignee. Ages count up live and a summary matrix shows open work by severity.
Start your risk register now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.