Spreadsheet: 155726d1337018321-excel-2007-field-calculation-based-on-conditional-formatting-results-and-text-dropdown-picks-r2-sample
Sheet: Mandatory T

 | Frequency ---> |  |  |  |  |  |  |  |  |  | Once | Once | Once | Once | Once | Annual | Annual | Once | B4Depl? | B4Depl? | Annual | Annual | Annual | Annual | Annual | Annual | 2 Yrs | 2 Yrs | Once | 2 Yrs | Once | 2 Yrs | Annual | Annual | Annual | Initially | Once | Annual | Annual
 | Class Type ---> |  |  |  |  |  |  |  |  |  | Operatnl | Operatnl | Operatnl | Operatnl | Operatnl | Operatnl | Operatnl | Operatnl | Deplymt | Deplymt | Ops&L/HR | Ops&L/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR | Legal/HR
Available | Last Name | First Name | [NAME] | EmplType | Region | Division | Branch | Supervisor/Manager? | HR Professional? | NCR Location?   (D.C. area) | (Once & On Revision) MT-1.b | (Once & On Revision) MT-2.a | (Once & On Revision) MT-3 | (Once & On Revision) MT-4 | (Once & On Revision) MT-5 | (Annual - CY) MT-6 | (Annual - CY) MT-7 | (Perms Only - Once) MT-8 | (Not on Ed Capps List) Travel [NAME] | (Not on Ed Capps List) IS-101.a  [NAME] | (Course of Choice in the last year) DHS Employee Preparedness - 1 | (Course of Choice in the last 6 mos) DHS Employee Preparedness - 2 | (Initially + Annually) MT-9 | (Annual - CY) MT-10 | (Annual - CY) MT-11) | (SupvrsOnly - Annual - CY) MT-12 (Supervisors) | (Initially & every 2 Years) MT-13 | (Annual twice, then every 2 Years) MT-14 | (Initially & Annually) MT-15 | (Initially & every 2 Years) MT-16 | (Once & On Revision) MT-17 | (Initially, w/in 3 mos & every 2 Years) MT-18 | (Initially & Annually) MT-19 | (Annual - CY) MT-20 | (Annual - CY) MT-21 | (NCR Only - Initially) Duty Readiness Orientation | ([NAME] Only - Once, w/in 12 mos) MT-22 | (Supvrs/Mgrs Only - Annual ) MT-23 | (HR Professionals Only - Annual) [NAME] for HR | (on [NAME]'s but not [NAME]'s List) DF-434 [NAME]: E.R.O. | (on [NAME]'s but not [NAME]'s List) DF-416 Diversity : Making It Work | (on [NAME]'s but not [NAME]'s List) DF-506 Sexual Harassment | % Individual's Mandatory Training Program  Complete
Y | Smith | Brice |  | Permanent | Region II | Response | Planning | No | No
Y | Jones | [NAME] |  | Student | Region II | Support | Admin/Finance | No | No | No
Y | Cullen | [NAME] |  | Temporary | Region II | Recovery | Private | Yes | No
Y | [NAME] | [NAME] |  | Permanent | Region II | Mitigation | Assistance | Yes | No
Y | Lewis | [NAME] |  | Student | Region II | Response | Integration | No | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-15 00:00:00
Y | Smith | [NAME] |  | Temporary | Region II | Response | Planning | Yes | No |  |  |  |  |  |  | 2011-11-05 00:00:00
Y | Jones | [NAME] |  | Permanent | Region II | Support | Admin/Finance | Yes | No
Y | Cullen | [NAME] |  | Student | Region II | Mitigation | Insurance | No | No
Y | [NAME] | Lashonne |  | Temporary | Region II | Recovery | Government | Yes | No |  |  |  |  |  |  | 2010-11-30 00:00:00
Y | Lewis | [NAME] |  | Permanent | Region II | Administration | External Affairs | Yes | No | No
Y | Smith | [NAME] |  | Student | Region II | Response | Logistics | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-02-05 00:00:00
Y | Jones | [NAME] |  | Temporary | Region II | Preparedness | Technological | No | No | No
Y | Cullen | [NAME] |  | Permanent | Region II | Preparedness | Integration | Yes | No
Y | [NAME] | Cathleen |  | Student | Region II | Preparedness | Legal | No | No |  |  |  |  |  |  | 2011-02-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-05 00:00:00
Y | Lewis | [NAME] |  | Temporary | Region II | Preparedness | Analysts | Yes | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-10-25 00:00:00
Y | Smith | [NAME] |  | Permanent | Region II | Support | I T | Yes | No |  |  | 2011-11-01 00:00:00
Y | Jones | Yvonne |  | Student | Region II | Preparedness | Technological | No | No
Y | Cullen | [NAME] |  | Temporary | Region II | Mitigation | Insurance | Yes | No | No
Y | [NAME] | [NAME] |  | Permanent | Region II | Recovery | Private | Yes | No |  |  |  |  |  |  | 2012-04-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-09-04 00:00:00
Y | Lewis | [NAME] |  | Student | Region II | Response | Planning | No | No
Y | [NAME] | Timothy |  | Temporary | Region II | Response | Integration | Yes | No
Y | Jones | [NAME] |  | Permanent | Region II | Preparedness | Analysts | Yes | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-04-05 00:00:00
Y | McCoy | [NAME] |  | Student | Region II | Response | Logistics | No | No
Y | Murphy | [NAME] |  | Temporary | Region II | Preparedness | Integration | Yes | No
Y | Mason | [NAME] |  | Temporary | Region II | Recovery | Private | Yes | No
Y | O'Henry | [NAME] |  | Temporary | Region II | Recovery | Government | No | No
Y | Rodriguez | Stephen |  | Permanent | Region II | Preparedness | Technological | No | No
Y | [NAME] | Carmen ([NAME]) |  | Student | Region II | Preparedness | Integration | Yes | No |  |  |  | 2011-01-05 00:00:00
Y | [NAME] | [NAME] |  | Student | Region II | Recovery | Private | No | No
Y | Jones | [NAME] |  | Temporary | Region II | Preparedness | Integration | Yes | No | No
Y | McCoy | Josue |  | Student | Region II | Response | Logistics | Yes | No
Y | Murphy | [NAME] |  | Permanent | Region II | Response | Integration | No | No
Y | Mason | [NAME] |  | Permanent | Region II | Mitigation | Insurance | Yes | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-12-15 00:00:00
Y | O'Henry | [NAME] |  | Temporary | Region II | Response | Planning | Yes | No
Y | Rodriguez | Scott |  | Permanent | Region II | Mitigation | Insurance | No | No
Y | Delgado | Korky |  | Student | Region II | Administration | External Affairs | No | No
Y | Rodriguez | [NAME] |  | Student | Region II | Mitigation | Assistance | No | No
Y | [NAME] | [NAME] |  | Temporary | Region II | Mitigation | Insurance | Yes | No
Y | [NAME] | [NAME] |  | Permanent | Region II | Administration | External Affairs | Yes | No |  |  |  |  | 2012-01-06 00:00:00
Y | Jones | [NAME] |  | Student | Region II | Recovery | Government | No | No
Y | McCoy | Tonya |  | Permanent | Region II | Mitigation | Insurance | Yes | No
Y | Murphy | [NAME] |  | Student | Region II | Mitigation | Assistance | Yes | No
Y | Mason | Mark |  | Temporary | Region II | Preparedness | Legal | No | No
Y | O'Henry | Eileen |  | Permanent | Region II | Recovery | Private | Yes | No
Y | Jones | [NAME] |  | Student | Region II | Mitigation | Assistance | Yes | No
Y | Cullen | Lyzette |  | Temporary | Region II | Recovery | Private | No | No
Y | [NAME] | [NAME] |  | Permanent | Region II | Response | Integration | Yes | No
Y | Lewis | [NAME] |  | Student | Region II | Preparedness | Analysts | Yes | No
Y | Edwards | Terra |  | Temporary | Region II | Mitigation | Assistance | No | No
Y | Fisher | [NAME] |  | Permanent | Region II | Recovery | Government | Yes | No
Y | [NAME] | [NAME] |  | Student | Region II | Support | I T | Yes | No
Y | Fox | [NAME] |  | Temporary | Region II | Mitigation | Insurance | No | No
Y | Parker | Jaime |  | Permanent | Region II | RegionAdmin | External Affairs | Yes | No
Y | Lewis | [NAME] |  | Student | Region II | Support | Admin/Finance | Yes | No
Y | Edwards | [NAME] |  | Temporary | Region II | Recovery | Private | No | No
Y | Fisher | [NAME] |  | Permanent | Region II | Support | Admin/Finance | Yes | No
Y | [NAME] | Blaine |  | Student | Region II | Preparedness | Legal | Yes | No
Y | Fox | [NAME] |  | Temporary | Region II | Recovery | Government | No | No
Y | Parker | [NAME] |  | Permanent | Region II | Preparedness | Legal | No | No
Y | [NAME] | [NAME] |  | Student | Region II | Support | I T | Yes | No
Y | Parker | [NAME] |  | Temporary | Region II | Mitigation | Insurance | Yes | No
Y | O'Henry | Sara |  | Permanent | Region II | Recovery | Private | No | No
Y | Jones | [NAME] |  | Student | Region II | Mitigation | Insurance | Yes | No
Y | Cullen | [NAME] |  | Temporary | Region II | Support | Admin/Finance | Yes | No
Y | [NAME] | Hector |  | Temporary | Region II | Mitigation | Assistance | No | No
Y | Edwards | [NAME] |  | Temporary | Region II | Mitigation | Assistance | Yes | No
Y | Fisher | [NAME] |  | Permanent | Region II | Mitigation | Analysis | Yes | No
Y | [NAME] | [NAME] |  | Student | Region II | Preparedness | Legal | No | No
Y | Fox | Julia |  | Student | Region II | Response | Planning | No | No
Y | Parker | Teresa |  | Temporary | Region II | Mitigation | Insurance | Yes | No
Y | Lewis | [NAME] |  | Student | Region II | Response | Integration | No | No
Y | O'Henry | [NAME] |  | Permanent | Region II | Preparedness | Technological | Yes | No
Y | Rodriguez | Tania |  | Permanent | Region II | Response | Planning | Yes | No
Y | Delgado | [NAME] |  | Student | Region II | Support | Admin/Finance | No | No
Y | Rodriguez | Justo |  | Temporary | Region II | Response | Integration | Yes | No
Y | [NAME] | Terrance |  | Permanent | Region II | Preparedness | Technological | Yes | No
Y | [NAME] | Carri |  | Student | Region II | Response | Integration | No | No
Y | Smith | [NAME] |  | Temporary | Region II | Response | Planning | No | No
Y | Jones | [NAME] |  | Permanent | Region II | Preparedness | Legal | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-04-11 00:00:00
Y | Cullen | [NAME] |  | Student | Region II | Preparedness | Analysts | Yes | No
Y | [NAME] | [NAME] |  | Temporary | Region II | Support | Admin/Finance | Yes | No |  |  |  | 2011-04-11 00:00:00
Y | Brower | [NAME] |  | Permanent | Region II | Preparedness | Legal | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-12 00:00:00 |  | 2010-03-05 00:00:00
Y | Branch | Theophilus |  | Student | Region II | Preparedness | Analysts | Yes | No |  |  |  | 2012-05-12 00:00:00
Y | Potter | [NAME] |  | Temporary | Region II | Preparedness | Integration | Yes | No
Y | Garrett | [NAME] |  | Permanent | Region II | Support | Admin/Finance | No | No
Y | [NAME] | [NAME] |  | Student | Region II | Support | I T | Yes | No
Y | [NAME] | [NAME] |  | Temporary | Region II | Response | Planning | Yes | No
Y | Newman | [NAME] |  | Permanent | Region II | Support | Admin/Finance | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-02-20 00:00:00
Y | [NAME] | [NAME] |  | Student | Region II | Preparedness | Integration | Yes | No
Y | Fox | [NAME] |  | Temporary | Region II | Recovery | Government | Yes | No
Y | Parker | Sean |  | Permanent | Region II | Preparedness | Analysts | No | No
Y | Lewis | Adie |  | Student | Region II | Response | Planning | No | No | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-05 00:00:00
Y | Edwards | Walter |  | Temporary | Region II | Response | Planning | Yes | Yes | Yes
Y | Fisher | [NAME] |  | Permanent | Region II | Response | Integration | Yes | Yes | Yes
Y | [NAME] | [NAME] |  | Student | Region II | Recovery | Private | No | No | No
Y | Fox | [NAME] |  | Temporary | Region II | Response | Logistics | Yes | Yes | Yes
Y | Parker | Danna |  | Temporary | Region II | Administration | External Affairs | Yes | Yes | Yes
Y | [NAME] | Jorge |  | Temporary | Region II | Recovery | Private | No | No | No
Y | Parker | Melanio |  | Permanent | Region II | Response | Planning | Yes | No
Y | O'Henry | Gregory |  | Student | Region II | Response | Integration | Yes | No
Y | Jones | Leah |  | Student | Region II | Response | Integration | No | No
Y | Cullen | [NAME] |  | Temporary | Region II | Recovery | Private | Yes | No
Y | [NAME] | [NAME] |  | Student | Region II | Preparedness | Integration | Yes | No