Spreadsheet: 857023d1706117640-vlookup-and-indirect-maybe-cant-har_test_chopped_down
Sheet: PICKLISTS

[NAME]) Identified | Mitigation Status |  |  |  |  | Seven | Eight |  |  |  | [NAME] |  |  |  | What Har List
In-Service | Identified |  |  |  |  | 1A High | 1A High (Footnote 2) |  | Seven |  | Open |  | CVN-78
Decomissioning | Submitted |  |  |  |  | 1B High | 1B High (Footnote 2) |  | Eight |  | Closed |  | CVN-79 |  | [NAME]
Disposal | Deferred |  |  |  |  | 1C High | 1C High (Footnote 2) |  |  |  |  |  | CVN-80
Single Deployment | Rejected |  |  |  |  | 1D High | 1D High |  |  |  |  |  | CVN-81
Pre-deployment | Accepted - In Progress |  |  |  |  | 1E High | 1E High
Single Test Event or Exercise | Accepted - Pending |  |  |  |  | 1F Serious | 1F Serious
Multiple Test Events | Verified |  |  |  |  | 1G Serious | 1G Serious
In-Service, Decommissioning, Disposal, Single Deployment, Pre-Deployment | Validated |  |  |  |  | 1G Medium (Footnote 2) | 1H Serious (Footnote 6)
In Service, Pre Deployment |  |  |  |  |  |  | 1H Medium
In-Service, Operations and support (OS) Phase |  |  |  |  |  | 2A High
In Service, Single Deployment, Pre-Deployment |  |  |  |  |  | 2B High | 2A High (Footnote 2)
Operations and support (OS) Phase |  |  |  |  |  | 2C High | 2B High (Footnote 2)
 |  |  |  |  |  | 2D High | 2C High
 |  |  |  |  |  | 2E Serious | 2D High
 |  |  |  |  |  | 2F Serious | 2E Serious
 |  |  |  |  |  | 2G Serious | 2F Serious
 |  |  |  |  |  | 2G Medium (Footnote 3) | 2G Serious (Footnote 6)
 |  |  |  |  |  |  | 2G Medium
 |  |  |  |  |  | 3A High | 2H Serious (Footnote 6)
 |  |  |  |  |  | 3B High | 2H Medium
 |  |  |  |  |  | 3C High
 |  |  |  |  |  | 3D Serious | 3A High (Footnote 2)
 |  |  |  |  |  | 3E Serious | 3B High
 |  |  |  |  |  | 3F Medium | 3C High
 |  |  |  |  |  | 3G Medium | 3D Serious
 |  |  |  |  |  |  | 3E Serious
 |  |  |  |  |  | 4A High | 3F Medium
 |  |  |  |  |  | 4B High | 3G Medium
 |  |  |  |  |  | 4C Serious | 3H Low
 |  |  |  |  |  | 4D Serious
 |  |  |  |  |  | 4E Medium | 4A High
 |  |  |  |  |  | 4F Medium | 4B High
 |  |  |  |  |  | 4G Low | 4C High (Footnote 3)
 |  |  |  |  |  |  | 4C Serious
 |  |  |  |  |  | 5A High | 4D Serious
 |  |  |  |  |  | 5B Serious | 4E Serious (Footnote 3)
 |  |  |  |  |  | 5C Serious | 4E Medium
 |  |  |  |  |  | 5D Medium | 4F Medium
 |  |  |  |  |  | 5E Medium | 4G Low
 |  |  |  |  |  | 5F Low | 4H Low
 |  |  |  |  |  | 5G Low
 |  |  |  |  |  |  | 5A High
 |  |  |  |  |  | 6A Serious | 5B Serious
 |  |  |  |  |  | 6B Serious | 5C Serious
 |  |  |  |  |  | 6C Medium | 5D Medium
 |  |  |  |  |  | 6D Medium | 5E Medium
 |  |  |  |  |  | 6E Low | 5F Low
 |  |  |  |  |  | 6F Low | 5G Low
 |  |  |  |  |  | 6G Low | 5H Low (Footnote 4)
 |  |  |  |  |  | 7A Medium | 6A Serious
 |  |  |  |  |  | 7B Medium | 6B Serious
 |  |  |  |  |  | 7C Medium | 6C Medium
 |  |  |  |  |  | 7D Low | 6D Medium
 |  |  |  |  |  | 7E Low | 6E Low
 |  |  |  |  |  | 7F Low | 6F Low
 |  |  |  |  |  | 7G Low | 6G Low (Footnote 4)
 |  |  |  |  |  |  | 6H Low (Footnote 4)
 |  |  |  |  |  | Eliminated
 |  |  |  |  |  |  | 7A Medium
 |  |  |  |  |  |  | 7B Medium
 |  |  |  |  |  |  | 7C Medium
 |  |  |  |  |  |  | 7D Low
 |  |  |  |  |  |  | 7E Low
 |  |  |  |  |  |  | 7F Low (Footnote 4)
 |  |  |  |  |  |  | 7G Low (Footnote 4)
 |  |  |  |  |  |  | 7H Low (Footnote 4)
 |  |  |  |  |  |  | Eliminated