Spreadsheet: 763350d1642116153-how-to-auto-populate-values-based-on-multiple-criteria-sample
Sheet: Program 2

 |  | Completed on: [enter date here] | Completed By: [enter your name here]
 |  | Risk Assessment
 |  | This report is used to capture identified risks and the initial mitigation that have been implemented to identify the residual risk rating.
 |  | Program 2
 |  | Program Description: [enter description here]
 |  |  |  |  |  | RISK CATEGORIES
 |  | Transfer Payment Recipient | Lead TP Yes/No | 2021/22 Funding $ | Are there any risks? | OPERATIONAL |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | STRATEGIC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | External Environmental
 |  |  |  |  |  | Human Resources |  |  |  | Finance |  |  |  | I&IT |  |  |  | Program Delivery |  |  |  | Policy |  |  |  | Project Initiative |  |  |  | Legal |  |  |  | Regulatory |  |  |  | Emergency Management |  |  |  | Infrastructure |  |  |  | Physical Security |  |  |  | Other |  |  |  | Cultural |  |  |  | Governance |  |  |  | Regulational |  |  |  | Other
 |  |  |  |  |  | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating | Likelihood | Impact |  | Risk Rating
 |  | TPR 1 |  |  | Yes | 4 | 5 |  |  | 1 | 1 |  |  | 4 | 3 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 2 |  |  | No | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 3 |  |  | No | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 4 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 5 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 6 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 7 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 8 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 9 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 10 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 11 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 12 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 13 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 14 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 15 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 16 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 17 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 18 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 19 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 20 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 21 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TPR 22 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1 |  |  | 1 | 1
 |  | TOTALS