Spreadsheet: 857023d1706117640-vlookup-and-indirect-maybe-cant-har_test_chopped_down
Sheet: Risk Matrix Tables

7x7 Risk Matrix |  |  |  |  |  |  |  |  |  |  | 7x8 Risk Matrix
 |  | Severity |  |  |  |  |  |  |  |  | ESOH Risk1 |  | Severity
 |  | CVN Loss | Ship Loss | Catastrophic | Critical | Significant | Marginal | Negligible |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | N/A
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | N/A |  | Probability | A | 2 | 2 | 2 | High | High | Serious | Medium | Not Reportable as a Mishap
Frequency and Probability | Frequent | High | High | High | High | High | Serious | Medium
 | (A) |  |  |  |  |  |  |  |  |  |  | B | 2 | 2 | High | High | Serious | Serious | Medium
 | Probable | High | High | High | High | Serious | Serious | Medium
 | (B) |  |  |  |  |  |  |  |  |  |  | C | 2 | High | High | Serious3 | Serious | Medium | Medium
 | Occasional | High | High | High | Serious | Serious | Medium | Medium
 | (C) |  |  |  |  |  |  |  |  |  |  | D | High | High | Serious | Serious | Medium | Medium | Low
 | Infrequent | High | High | Serious | Serious | Medium | Medium | Low
 | (D) |  |  |  |  |  |  |  |  |  |  | E | High | Serious | Serious | Medium3 | Medium | Low | Low
 | Rare | High | Serious | Serious | Medium | Medium | Low | Low
 | (E) |  |  |  |  |  |  |  |  |  |  | F | Serious | Serious | Medium | Medium | Low | Low | 4
 | Remote | Serious | Serious | Medium | Medium | Low | Low | Low
 | (F) |  |  |  |  |  |  |  |  |  |  | G | Serious | Medium6 | Medium | Low | Low | 4 | 4
 | Improbable | Serious 2 | Serious 3 | Medium | Low | Low | Low | Low
 | (G) |  |  |  |  |  |  |  |  |  |  | H | Medium6 | Medium6 | Low | Low | 4 | 4 | 4
 | Eliminated 1
 | (H) |  |  |  |  |  |  |  |  |  |  | I5 | Eliminated
Footnotes:
1 - Administrative controls cannot move risk to Eliminated (e.g., [NAME], Warnings, Procedures, etc.).  Risk can be moved to Eliminated only by design or engineering changes that remove the hazard or engineer it out. |  |  |  |  |  |  |  |  |  |  | Footnotes:
2 - Considered Medium Risk if <1x10-11 per Ship-Year and may be accepted as a medium risk. |  |  |  |  |  |  |  |  |  |  | 1 – If it is unclear how a particular risk should be coded, then engineering judgement with documented assumptions may be used to support the Risk Assessment Code (RAC) determination.
3 - Considered Medium Risk if <1x10-9 per Ship-Year and may be accepted as a medium risk. |  |  |  |  |  |  |  |  |  |  | 2 – This area of the matrix is part of the high risk region and as a general rule should be considered too high to be  accepted. Risks that fall in this region should be mitigated.
 |  |  |  |  |  |  |  |  |  |  | 3 – If the hazard results in death or permanent total disability, then the RAC for 4C is High and the RAC for 4E is        Serious.
 |  |  |  |  |  |  |  |  |  |  | 4 - This area of the matrix is part of the low risk region and as a general rule effort should not be expended to  further analyze, mitigate or eliminate risks that are assessed in this area. Continue to monitor mishaps to  determine if this risk is realized.
 |  |  |  |  |  |  |  |  |  |  | 5 - Administrative controls cannot move risk to Eliminated (e.g., [NAME], Warnings, Cautions, and Procedures).  Risk can be moved to Eliminated only by implementing design or engineering changes that remove the hazard  from the system.
 |  |  |  |  |  |  |  |  |  |  | 6 – This RAC is considered Serious for weapons systems hazard probabilities >10-11 with Severity 1 and >10-9 with [NAME]. Per NAVSEAINST 8020.6, WSESRB will request that these risks are presented to COMNAVSEA  for concurrence prior to acceptance.