Spreadsheet: 187494d1350474412-referencing-the-first-15-names-in-a-list-a-list-that-is-manually-altered-bycopy-paste-etc-excel-help-forum2
Sheet: Background 2 - calculations

 |  | impact | probability
 | x | C | A | 2304 |  |  |  |  | Rare | Unlikely | Possible | Probable | Almost Certain
 | x | C | Pr | 1792 |  |  |  | Catastrophic | 256 | 768 | 1280 | 1792 | 2304 | Catastrophic |  | +512
 | x | Ma | A | 576 |  | x4 |  | Major | 64 | 192 | 320 | 448 | 576 | Major |  | +128
 | x | Ma | Pr | 448 |  |  |  | Moderate | 16 | 48 | 80 | 112 | 144 | Moderate |  | +32
 | x | Mo | A | 144 |  |  |  | Minor | 4 | 12 | 20 | 28 | 36 | Minor |  | +8
 | x | Mo | Pr | 112 |  |  |  | Insignificant | 1 | 3 | 5 | 7 | 9 | Insignificant |  | +2
 | x | C | Po | 1280 |  |  |  |  | Rare | Unlikely | Possible | Probable | Almost Certain
 | x | C | Un | 768 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | important background data - do not edit!
 | x | Ma | Po | 320
 | x | Mo | Po | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | y
 | x | Mi | pr | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | fiddle factor offsets |  | 0,48 | 0,05
 | x | Mi | Po | 20
 | x | I | A | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | inverted coordinates (don't use) |  |  | proper coordinates |  |  | modified coordinates
 | x | C | R | 256 |  |  |  |  |  |  |  |  | total occurrence |  | x | y |  | Risk Category | Risk Sub-Category |  | Likelihood | Most likely impact | matrix number | Likelihood | Most likely impact | total occurrence |  | x | y | occurrence | x | y |  | x | y
 | x | Ma | Un | 192 |  |  |  |  |  |  |  |  |  | 2304 | 5 | 5 | 1
 | x | Ma | R | 64 |  |  |  |  |  |  |  |  |  | 36 | 5 | 2 | 2
 | x | Mo | Un | 48 |  |  |  |  |  |  |  |  |  | 576 | 5 | 4 | 3
 | x | Mo | r | 16 |  |  |  | Rare | Unlikely | Possible | Probable | Almost Certain |  | 448 | 4 | 4 | 4
 | x | Mi | Un | 12 |  |  | Catastrophic | 256 | 768 | 1280 | 1792 | 2304 |  | 144 | 5 | 3 | 5
 | x | Mi | R | 4 |  |  | Major | 64 | 192 | 320 | 448 | 576 |  | 112 | 4 | 3 | 6
 | x | I | Pr | 7 |  |  | Moderate | 16 | 48 | 80 | 112 | 144 |  | 1280 | 3 | 5 | 7
 | x | I | Po | 5 |  |  | Minor | 4 | 12 | 20 | 28 | 36 |  | 768 | 2 | 5 | 8
 | x | I | Un | 3 |  |  | Insignificant | 1 | 3 | 5 | 7 | 9 |  | 320 | 3 | 4 | 9
 | x | I | R | 1 |  |  |  |  |  |  |  |  |  | 80 | 3 | 3 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | 4 | 2 | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | 3 | 2 | 12
 |  |  |  |  |  |  | almost certain | 9 | 36 | 144 | 576 | 2304 |  | 9 | 5 | 1 | 13
 |  |  |  |  |  |  | probable | 7 | 28 | 112 | 448 | 1792 |  | 256 | 1 | 5 | 14
 |  |  |  |  |  |  | possible | 5 | 20 | 80 | 320 | 1280 |  | 192 | 2 | 4 | 15
 |  |  |  |  |  |  | unlikely | 3 | 12 | 48 | 192 | 768 |  | 64 | 1 | 4 | 16
 |  |  |  |  |  |  | rare | 1 | 4 | 16 | 64 | 256 |  | 48 | 2 | 3 | 17
 |  |  |  |  |  |  |  | insignificant | minor | moderate | major | catastrophic |  | 16 | 1 | 3 | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 2 | 2 | 19
 | deliverable |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 2 | 20
256 | 768 | 1280 | 1792 | 2304 |  |  |  |  |  |  |  |  |  | 7 | 4 | 1 | 21
risk4 | risk8 |  |  | Risk Data |  |  |  |  |  |  |  |  |  | 5 | 3 | 1 | 22
risk6 |  |  |  | risk2 |  |  |  |  |  |  |  |  |  | 3 | 2 | 1 | 23
risk13 |  |  |  | risk3 |  | Background for Risk Summary Proflie 1. |  |  |  |  |  |  |  | 1 | 1 | 1 | 24
risk14
64 | 192 | 320 | 448 | 576
 |  | risk9 |  |  | c | 256 | 768 | 1280 | 1792 | 2304 |  | c | 256 | 768 | 1280 | 1792 | 2304 |  |  | "normal" colors
16 | 48 | 80 | 112 | 144 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | almost certain | 9 | 36 | 144 | 576 | 2304 |  |  |  |  |  |  |  |  |  |  | Green | Yellow | Red
 | risk7 | risk10 |  | risk5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | probable | 7 | 28 | 112 | 448 | 1792 |  |  |  |  |  |  |  |  |  |  | 1 | 36 | 576
4 | 12 | 20 | 28 | 36 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | possible | 5 | 20 | 80 | 320 | 1280 |  |  |  |  |  |  |  |  |  |  | 4 | 144 | 2304
 |  | risk12 | risk11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | unlikely | 3 | 12 | 48 | 192 | 768 |  |  |  |  |  |  |  |  |  |  | 16 | 112 | 448
1 | 3 | 5 | 7 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rare | 1 | 4 | 16 | 64 | 256 |  |  |  |  |  |  |  |  |  |  | 64 | 80 | 1792
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 192 | 320
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | 256 | 1280
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | background for sheet 7, do not edit |  |  |  |  |  |  |  |  |  |  | 48 |  | 768
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final ranking
 |  |  |  |  | ma | 64 | 192 | 320 | 448 | 576 |  | ma | 64 | 192 | 320 | 448 | 576
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | occurrence | rank | corrected rank | risk score | risk name | likelihood | impact | risk category | risk sub category |  | color code |  |  |  |  | final rank | risk score | risk name | likelihood | impact | risk category | risk sub category | color code - control column
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  | mo | 16 | 48 | 80 | 112 | 144 |  | mo | 16 | 48 | 80 | 112 | 144 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
 |  |  |  |  | mi | 4 | 12 | 20 | 28 | 36 |  | mi | 4 | 12 | 20 | 28 | 36
 |  |  |  |  | i | 1 | 3 | 5 | 7 | 9 |  | ins | 1 | 3 | 5 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | disregard table below
 |  |  |  |  |  | disregard the table below - mixed coordinates (=> inverse table)
 |  |  |  |  |  | rare | unlikely | possible | probable | almost certain |  |  | rare | unlikely | possible | probable | almost certain |  |  |  |  | almost_certain_catastrophic
 |  |  |  |  | catastrophic |  |  |  |  |  |  | catastrophic
 |  |  |  |  | major |  |  |  |  |  |  | major
 |  |  |  |  | moderate |  |  |  |  |  |  | moderate
 |  |  |  |  | minor |  |  |  |  |  |  | minor
 |  |  |  |  | insignificant |  |  |  |  |  |  | insignificant
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | inverse colors
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 256 | 768 | 1280 | 1792 | 2304
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64 | 192 | 320 | 448 | 576
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | 48 | 80 | 112 | 144
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 12 | 20 | 28 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | 5 | 7 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "normal" colors
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | almost certain | 9 | 36 | 144 | 576 | 2304
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | probable | 7 | 28 | 112 | 448 | 1792
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | possible | 5 | 20 | 80 | 320 | 1280
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | unlikely | 3 | 12 | 48 | 192 | 768
 |  |  |  |  |  | Bacground for risk summary profile 2. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rare | 1 | 4 | 16 | 64 | 256
 |  |  |  |  |  | proper table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | background for risk categories |  |  |  |  |  |  |  |  |  |  |  |  |  | background for risk subcategories
 |  |  |  |  |  | insignificant | minor | moderate | major | catastrophic |  |  | insignificant | minor | moderate | major | catastrophic |  |  |  |  | insignificant | minor | moderate | major | catastrophic |  |  | insignificant | minor | moderate | major | catastrophic |  |  |  | insignificant | minor | moderate | major | catastrophic |  |  | insignificant | minor | moderate | major | catastrophic
 |  |  |  |  | almost certain |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | almost certain |  |  |  |  |  |  | a |  |  |  |  |  |  |  | almost certain |  |  |  |  |  |  | a
 |  |  |  |  | probable |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | probable |  |  |  |  |  |  | p |  |  |  |  |  |  |  | probable |  |  |  |  |  |  | p
 |  |  |  |  | possible |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | possible |  |  |  |  |  |  | p |  |  |  |  |  |  |  | possible |  |  |  |  |  |  | p
 |  |  |  |  | unlikely |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | unlikely |  |  |  |  |  |  | u |  |  |  |  |  |  |  | unlikely |  |  |  |  |  |  | u
 |  |  |  |  | rare |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rare |  |  |  |  |  |  | r |  |  |  |  |  |  |  | rare |  |  |  |  |  |  | r