Spreadsheet: 755486d1636911139-i-am-stumped-i-need-a-cell-to-contain-a-drop-down-list-or-display-a-name-depending-data-mass-tracker-2022-final
Sheet: Assessments

0.9 | Program Area | Program Audit | Manager | Monitor | Coordinator | Type (SELF ASS, QA MON, NON-QA, W/C ASS) | Audit Due Month | Special Audit Required (Yes or No) | Special Audit Due     (DD-MON-YR) | Remarks
 | 200 | [NAME] | MGYSGT KITTEL | SSGT DICARLO | SGT BROWNE | QA Mon | Jan | No
 | 200 | [NAME] | MGYSGT KITTEL | SSGT DICARLO | SGT BROWNE | SELF ASS | Jul | No
 | 300 | FUEL SURVEILLANCE | GYSGT CAHILL | SSGT LYLES |  | QA MON | Feb | No
 | 300 | FUEL SURVEILLANCE | GYSGT CAHILL | SSGT LYLES |  | SELF ASS | Aug | No
 | 400 | NOAP/OIL CONSUMPTION | SSGT RUSSEL | SSGT LYLES |  | QA MON | Mar | No
 | 400 | NOAP/OIL CONSUMPTION | SSGT RUSSEL | SSGT LYLES |  | SELF ASS | Sep | No
 | 600 | HYDRAULIC CONTAM | CPL LARNEY | SGT BROWNE |  | QA MON | Apr | No
 | 600 | HYDRAULIC CONTAM | CPL LARNEY | SGT BROWNE |  | SELF ASS | Oct | No
 | 800 | NAMP COMPLIANCE AUDITING PROGRAM | [NAME] | CAPT LIDDLE |  | QA MON | Jun | No
 | 800 | NAMP COMPLIANCE AUDITING PROGRAM | [NAME] | CAPT LIDDLE |  | SELF ASS | Nov | No
 | 900 | MAINT SAFETY | [NAME] | CAPT LIDDLE |  | QA MON | Jul | No
 | 900 | MAINT SAFETY | [NAME] | CAPT LIDDLE |  | SELF ASS | Jan | No
 | 1000 | NAMDRP | SGT SPURLOCK | SSGT DICARLO |  | QA MON | Aug | No
 | 1000 | NAMDRP | SGT SPURLOCK | SSGT DICARLO |  | SELF ASS | Feb | No
 | 1100 | ACSP | [NAME] | SGT SPURLOCK |  | QA MON | Sep | No
 | 1100 | ACSP | [NAME] | SGT SPURLOCK |  | SELF ASS | Mar | No
 | 1200 | FOD | GYSGT CAHILL | SSGT LYLES |  | QA MON | Oct | No
 | 1200 | FOD | GYSGT CAHILL | SSGT LYLES |  | SELF ASS | Apr | No
 | 1300 | TOOL CONTROL | CWO2 HENAO | SSGT DICARLO | SSGT PAVALUS | QA MON | Nov | No
 | 1300 | TOOL CONTROL | CWO2 HENAO | SSGT DICARLO | SSGT PAVALUS | SELF ASS | May | No
 | 1400 | CORROSION CONTROL | SSGT ACRI | SGT BROWNE |  | QA MON | Dec | No
 | 1400 | CORROSION CONTROL | SSGT ACRI | SGT BROWNE |  | SELF ASS | Jun | No
 | 1500 | PLANE CAPTAIN | CAPT LIDDLE | SSGT LYLES |  | QA MON | Jan | No
 | 1500 | PLANE CAPTAIN | CAPT LIDDLE | SSGT LYLES |  | SELF ASS | Jul | No
 | 1600 | EGRESS | SSGT KEENAN | SGT BROWNE |  | QA MON | Feb | No
 | 1600 | EGRESS | SSGT KEENAN | SGT BROWNE |  | SELF ASS | Aug | No
 | 1700 | SE TRNG/LIC | CAPT LIDDLE | SSGT LYLES | SSGT SELERT | QA MON | Mar | No
 | 1700 | SE TRNG/LIC | CAPT LIDDLE | SSGT LYLES | SSGT SELERT | SELF ASS | Sep | No
 | 1800 | SE PMS | CWO2 HENAO | SSGT LYLES | SSGT SELERT | QA MON | Apr | No
 | 1800 | SE PMS | CWO2 HENAO | SSGT LYLES | SSGT SELERT | SELF ASS | Oct | No
 | 1900 | TECH DATA MANAGEMENT | CAPT LIDDLE | SGT SPURLOCK | [NAME] | QA MON | May | No
 | 1900 | TECH DATA MANAGEMENT | CAPT LIDDLE | SGT SPURLOCK | [NAME] | SELF ASS | Nov | No
 | 2000 | METCAL | [NAME] | SGT SPURLOCK |  | QA MON | Jun | No
 | 2000 | METCAL | [NAME] | SGT SPURLOCK |  | SELF ASS | Dec | No
 | 2200 | HAZMAT | CAPT LIDDLE | SGT BROWNE | SSGT ACRI | QA MON | Jul | No
 | 2200 | HAZMAT | CAPT LIDDLE | SGT BROWNE | SSGT ACRI | SELF ASS | Jan | No
 | 2400 | ESD | CPL YOON | SSGT DICARLO |  | QA MON | Aug | No
 | 2400 | ESD | CPL YOON | SSGT DICARLO |  | SELF ASS | Feb | No
 | 2600 | TD COMPLIANCE | CWO2 HENAO | SSGT DICARLO | SSGT ROBINSON | QA MON | Sep | No
 | 2600 | TD COMPLIANCE | CWO2 HENAO | SSGT DICARLO | SSGT ROBINSON | SELF ASS | Mar | No
 | 2700 | ELECTRICAL WIRING INTERCONNECT SYSTEM | MSGT TALBERT | SSGT DICARLO |  | QA MON | FEB | No
 | 2700 | ELECTRICAL WIRING INTERCONNECT SYSTEM | MSGT TALBERT | SSGT DICARLO |  | SELF ASS | JUL | No
 | 2900 | [NAME] | CWO2 HENAO | SGT BROWNE | MGYSGT KITTEL | QA MON | Oct | No
 | 2900 | [NAME] | CWO2 HENAO | SGT BROWNE | MGYSGT KITTEL | SELF ASS | Apr | No
 | 3100 | WEIGHT AND BALANCE | CWO2 HENAO | SSGT DICARLO |  | QA MON | Nov | No
 | 3100 | WEIGHT AND BALANCE | CWO2 HENAO | SSGT DICARLO |  | SELF ASS | May | No
 | 3300 | LOGS AND RECORDS | CWO2 HENAO | SGT SPURLOCK | SGT GLORIA | QA MON | Jan | No
 | 3300 | LOGS AND RECORDS | CWO2 HENAO | SGT SPURLOCK | SGT GLORIA | SELF ASS | Jul | No
 | 3400 | PHASE MAINTENANCE | CWO2 HENAO | SGT BROWNE | SSGT LEMEN | QA MON | Feb | No
 | 3400 | PHASE MAINTENANCE | CWO2 HENAO | SGT BROWNE | SSGT LEMEN | SELF ASS | Aug | No
 | 3600 | DATA ANALYSIS | CWO2 HENAO | SGT BROWNE |  | QA MON | Mar | No
 | 3600 | DATA ANALYSIS | CWO2 HENAO | SGT BROWNE |  | SELF ASS | Sep | No
 | 3700 | MATERIAL CONTROL | CWO2 HENAO | SGT SPURLOCK | SSGT RUSSEL | QA MON | Apr | No
 | 3700 | MATERIAL CONTROL | CWO2 HENAO | SGT SPURLOCK | SSGT RUSSEL | SELF ASS | Oct
 | 3800 | AMMRL | SGT LAMA | SSGT DICARLO |  | QA MON | May | No
 | 3800 | AMMRL | SGT LAMA | SSGT DICARLO |  | SELF ASS | Nov | No
 | 3900 | [NAME] | SSGT LYLES | SGT SPURLOCK |  | QA MON | Jun | No
 | 3900 | [NAME] | SSGT LYLES | SGT SPURLOCK |  | SELF ASS | Dec | No
 | 4000 | APU TAXI/TURNUP | CAPT LIDDLE | SSGT LYLES |  | QA MON | Jul | No
 | 4000 | APU TAXI/TURNUP | CAPT LIDDLE | SSGT LYLES |  | SELF ASS | Jan | No
 | 4500 | BATTERY MAINT SAFETY | SGT HERRERA | SSGT DICARLO |  | QA MON | Aug | No
 | 4500 | BATTERY MAINT SAFETY | SGT HERRERA | SSGT DICARLO |  | SELF ASS | Feb | No
 | 4600 | COMPASS CALIBRATION | SGT HERRERA | SSGT DICARLO |  | QA MON | Sep | No
 | 4600 | COMPASS CALIBRATION | SGT HERRERA | SSGT DICARLO |  | SELF ASS | Mar | No
 | 4700 | LASER SAFETY | GYSGT DOLATA | SSGT DICARLO |  | QA MON | Oct | No
 | 4700 | LASER SAFETY | GYSGT DOLATA |  |  | SELF ASS | Apr | No
 | 4800 | NOMMP AWCAP | MSGT PENNS | SGT SPURLOCK |  | QA MON | Nov | No
 | 4800 | NOMMP AWCAP | MSGT PENNS | SGT SPURLOCK |  | SELF ASS | May | No
 | 4900 | EXPLOSIVE CERT | WO ROMERO | SGT SPURLOCK |  | QA MON | Dec | No
 | 4900 | EXPLOSIVE CERT | WO ROMERO | SGT SPURLOCK |  | SELF ASS | Jun | No
 | 5000 | AAS | SSGT SOMMER | SGT SPURLOCK |  | QA MON | Jan | No
 | 5000 | AAS | SSGT SOMMER | SGT SPURLOCK |  | SELF ASS | Jul | No
 | 5200 | ALSS | SSGT MORALES | SGT SPURLOCK |  | QA MON | Feb | No
 | 5200 | ALSS | SSGT MORALES | SGT SPURLOCK |  | SELF ASS | Aug | No
 | 5300 | ASE | MSGT TALBERT | SSGT DICARLO |  | QA MON | Apr | No
 | 5300 | ASE | MSGT TALBERT | SSGT DICARLO |  | SELF ASS | Apr | No
 | W/C 020 | [NAME] | CWO2 HENAO | N/A |  | W/C ASS | Jan | No
 | W/C 030 | AMDS | CWO2 HENAO | N/A |  | W/C ASS | Feb | No
 | W/C 040 | QUALITY ASSURANCE | CAPT LIDDLE | N/A |  | W/C ASS | Mar | Na
 | W/C 05D | TOOL ROOM | CWO2 HENAO | N/A |  | W/C ASS | Jun | No
 | W/C 120 | AIRFRAMES | CAPT LIDDLE | N/A |  | W/C ASS | May | No
 | W/C 12C | CORROSION CONTROL | CAPT LIDDLE | N/A |  | W/C ASS | Oct | No
 | W/C 13A | FLIGHT EQUIPMENT | CAPT LIDDLE | N/A |  | W/C ASS | Jun | No
 | W/C 140 | PHASE MAINTENANCE | CWO2 HENAO | N/A |  | W/C  ASS | Nov | No
 | W/C 220 | AVIONICS | WO ROMERO | N/A |  | W/C ASS | Jul | No
 | W/C 230 | ORDNANCE | WO ROMERO | N/A |  | W/C ASS | Aug | No
 | W/C 310 | FLIGHTLINE | CAPT LIDDLE | N/A |  | W/C ASS | Sep | No
 | W/C 020 |  | SSGT RUSSEL | N/A |  | W/C SUP | Aug | NO
 | W/C 030 |  | SGT GLORIA | N/A |  | W/C SUP | May | NO
 | W/C 040 |  | SSGT DICARLO | N/A |  | W/C SUP | Oct | NO
 | W/C 05D |  | SSGT PAVALUS | N/A |  | W/C SUP | Aug | NO
 | W/C 120 |  | SSGT ACRI | N/A |  | W/C SUP | Oct | NO
 | W/C 12C |  | SSGT ACRI | N/A |  | W/C SUP | Oct | NO
 | W/C 13A |  | SSGT MORALES | N/A |  | W/C SUP | Sep | NO
 | W/C 140 |  | SSGT LEMEN | N/A |  | W/C SUP | May | NO
 | W/C 220 |  | GYSGT DOLATA | N/A |  | W/C SUP | Aug | NO
 | W/C 230 |  | SSGT SOMMER | N/A |  | W/C SUP | Oct | NO
 | W/C 310 |  | SSGT FOLEY | N/A |  | W/C SUP | Oct | NO