Risk Assessment

Risk Assessment

For

From

Reddit

Status

Updating

Formulas

Share

Risk

Impact

Total

Status

Desired

Match

Very Unlikely • 1

Insignificant • 1

1

Highest

Very Unlikely • 1

Minor • 2

2

Highest

Very Unlikely • 1

Moderate • 3

3

Highest

Very Unlikely • 1

Significant • 4

4

Highest

Very Unlikely • 1

Severe • 5

5

Highest

Unlikely • 2

Insignificant • 1

2

Highest

Unlikely • 2

Minor • 2

4

Highest

Unlikely • 2

Moderate • 3

6

Highest

Unlikely • 2

Significant • 4

8

Highest

Unlikely • 2

Severe • 5

10

Highest

Likely • 3

Insignificant • 1

3

Highest

Likely • 3

Minor • 2

6

Highest

Likely • 3

Moderate • 3

9

Highest

Likely • 3

Significant • 4

12

Highest

Likely • 3

Severe • 5

15

Highest

Very Likely • 4

Insignificant • 1

4

Highest

Very Likely • 4

Minor • 2

8

Highest

Very Likely • 4

Moderate • 3

12

Highest

Very Likely • 4

Significant • 4

16

Highest

Very Likely • 4

Severe • 5

20

Highest

Possible • 5

Insignificant • 1

5

Highest

Possible • 5

Minor • 2

10

Highest

Possible • 5

Moderate • 3

15

Highest

Possible • 5

Significant • 4

20

Highest

Possible • 5

Severe • 5

25

Highest

Status


if(prop("Count") <= 2, "Low", if(prop("Count") <= 6, "Low-Med", if(prop("Count") <= 9, "Medium", if(prop("Count") <= 16, "Med-High", "Highest"))))

Status (One Property)


if(toNumber(replaceAll(prop("Risk"), "[^0-9]", "")) * toNumber(replaceAll(prop("Impact"), "[^0-9]", "")) <= 2, "Low", if(toNumber(replaceAll(prop("Risk"), "[^0-9]", "")) * toNumber(replaceAll(prop("Impact"), "[^0-9]", "")) <= 6, "Low-Med", if(toNumber(replaceAll(prop("Risk"), "[^0-9]", "")) * toNumber(replaceAll(prop("Impact"), "[^0-9]", "")) <= 9, "Medium", if(toNumber(replaceAll(prop("Risk"), "[^0-9]", "")) * toNumber(replaceAll(prop("Impact"), "[^0-9]", "")) <= 16, "Med-High", "Highest"))))

Result Options

Desired — Desired

Desired — Desired

Alternate — Alternate

Alternate — Alternate

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!

By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!