Spreadsheet: 699523d1602645608-if-vlookup-and-concatenate-issues-with-formulas-working-together-2020-som-risk-register-template-v2
Sheet: Sheet3

Likelihood
Likelihood level | Probability | Descriptor
A | Rare | May occur once every 10-20 years
B | Unlikely | May occur once every 5-10 years
C | Possible | May occur once every 2-5 years
D | Likely | May occur once per year
E | Almost certain | May occur more than once per year
Consequence
Consequence Category | IMPACT SEVERITY LEVELS
Financial | Insignificant | Minor | Severe | Major | Catastrophic
Impact | -5 | -4 | -3 | -2 | -1
 | Less than $2,000 | $2,001 to $20,000 | $20,001 to $100,000 | $100,001 to $1,000,000 | Greater than $1,000,000
Corporate Image | Minor community interest   Local media report | Public community discussion.  Broad adverse media coverage | Public investigation. Regional/ State-wide publicity.  Some public demand for action. |  | Public investigation. National/ international publicity.  Public demand for action.
Environmental | Negligible impact on physical environment. Reversible within 1 day. | Minor biological effects of local importance. Prosecution possible.   Impact fully reversible within 1 week. | Serious damage of local importance. Prosecution expected.  Impact fully reversible within 1 month. | Serious damage of national importance. Prosecution.  Impact fully reversible within 1 year. | Very serious damage of national importance. Prosecution.  Long term study. Impact not fully reversible.
Health and Safety | Negligible injury, no medical treatment required. | Moderate reversible injury requiring treatment. | Serious injury (not fully reversible) to less than 3 persons.  Hospitalisation required. | Severe irreversible disability to persons, or district wide epidemic. Loss of life <3. | Loss of life and/ or significant irreversible effects to more than 3 people. Regional wide epidemic.
Loss of Service/ Community Effect | Small number of customers experiencing minor service disruption. | Significant service disruption affecting small number of customers. | Significant localised disruption over extended period. | Major localised disruption over extended period. | Major long term service disruption.
Social/ Cultural Heritage | Minor medium term social impacts on local population. Mostly repairable. | On-going social issues.  Minor mostly repairable damage to items of cultural significance. | On-going social issues.  Significant mostly repairable damage to structures/ items of cultural significance. | On-going serious social issues.  Significant permanent damage to structures/ items of cultural significance.
Economic                                  3rd Party Losses | Minimal liability for consequential loss | Liability for consequential loss between $2,000 to $20,000 | Liability for consequential loss between $20,001 to $100,000 | Liability for consequential loss between $100,001 to $1,000,000 | Liability for consequential loss greater than $1,000,000
Economic                                           Shire Revenue/ Business Costs | Total direct revenue loss & cost to restore service | Total direct revenue loss & cost to restore service | Total direct revenue loss & cost to restore service | Total direct revenue loss & cost to restore service | Total direct revenue loss & cost to restore service