Spreadsheet: 865568d1712642123-assign-data-items-within-my-cells-to-specific-groups-question-explained-in-message-qualifications-and-competencies-expiration-tracker-sample
Sheet: Sheet1

Qualifications and Competencies Expiration Tracker
Employee Name |  |  |  |  |  |  | Forest
Employee ID |  |  |  |  |  |  | District
Position |  |  |  |  |  |  | Station
Last Review Date |  |  |  |  |  |  | Today's Date
Qualifications/ Competencies/ Taskbooks | Description | Date Attained | Most Recent Effective Date | Performance Currency Duration | Currency Expiration Date | Taskbook Completion % | Currency Status | Maintains Currency | Column8 | Column9 | Column10 | Column11 | Column12 | Column13
FFT2 | Firefighter 2 | 2016-05-24 00:00:00 | 2023-10-07 00:00:00 | 5 |  | Complete | Qualified |  |  |  |  |  |  |  |  | Functional Area | Positon | Currency Duration
FFT1 | Firefighter 1 | 2019-11-21 00:00:00 | 2023-10-07 00:00:00 | 5 |  | Complete | Qualified | FFT2, ICT5 |  |  |  |  |  |  |  | Air Operations | HECM | 3
ICT5 | Incident Commander - Type 5 | 2023-04-18 00:00:00 | 2023-10-07 00:00:00 | 5 |  | Complete | Qualified | FFT1, FFT2 |  |  |  |  |  |  |  | Air Operations | ABRO | 3
ENOP | Engine Operator | 2022-04-04 00:00:00 | 2024-03-01 00:00:00 | 5 |  | Complete | Qualified |  |  |  |  |  |  |  |  | Operations | FFT2 | 5
ENGB | Engine Boss | 2023-05-17 00:00:00 | 2023-05-21 00:00:00 | 3 |  | 0.8 | Trainee | FFT1, FFT2, ICT5 CRWB |  |  |  |  |  |  |  | Operations | FFT1 | 5
CRWB | [NAME] | 2022-04-04 00:00:00 | 2022-04-04 00:00:00 | 3 |  | 0 | Trainee | FFT1, FFT2, ICT5, ENGB |  |  |  |  |  |  |  | Operations | ICT5 | 5
HECM | [NAME] Member | 2021-01-27 00:00:00 | 2023-03-02 00:00:00 | 3 |  | Complete | Qualified | FFT2, ABRO |  |  |  |  |  |  |  | Operations | ENGB | 5
ABRO | Airbase Radio Operator | 2021-01-27 00:00:00 | 2023-03-02 00:00:00 | 3 |  | Complete | Qualified | RADO |  |  |  |  |  |  |  | Operations | CRWB | 5
RADO | Radio Operator | 2021-12-10 00:00:00 | 2022-07-14 00:00:00 | 5 |  | Complete | Qualified | ABRO |  |  |  |  |  |  |  | Logistics | RADO | 5
INCM | Incident Communications Center Manager | 2022-04-22 00:00:00 | 2022-04-22 00:00:00 | 3 |  | 0.2 | Trainee | RADO |  |  |  |  |  |  |  | Logistics | INCM | 3
A-100 |  |  | 2022-05-01 00:00:00 |  |  | N/A | Certified |  |  |  |  |  |  |  |  | Additional | ENOP | 5
A-110 | Aviation Transportation of Hazmat |  | 2022-05-30 00:00:00 | 3 |  | N/A | Certified | HECM
A-200 |  |  | 2023-07-26 00:00:00 |  |  | N/A | Certified
RT-219FS | FS Heli Transport Ext Cargo RT |  | 2020-06-11 00:00:00 | 3 |  | N/A |  | HECM
[NAME] | Plastic Sphere Refresher |  | 2019-06-07 00:00:00 | 3 |  | N/A
RT-9059 | CRM 7 Skills Refresher |  | 2019-06-06 00:00:00 | 3 |  | N/A
N9022 | Defensive Driving |  | 2023-03-24 00:00:00 | 3 |  | N/A | Certified |  |  |  |  |  |  |  |  | TABLE KEY | Column1
RT-301BL | BLM Fire Vehicle [NAME] |  | 2023-03-31 00:00:00 | 3 |  | N/A | Certified |  |  |  |  |  |  |  |  | Color | Time Remaining
RT-503F | Emergency Vehicle Response Refresher |  | 2023-03-20 00:00:00 | 3 |  | N/A | Certified |  |  |  |  |  |  |  |  | GREEN | > 2.5 years
 | ATV/UTV Refresher |  |  |  |  | N/A | Certified |  |  |  |  |  |  |  |  | AMBER | 1.5 - 2.5 years
RT-212 | Fire Chain Saw Refresher |  | 2018-07-10 00:00:00 | 3 |  | N/A |  |  |  |  |  |  |  |  |  | RED | < 1.5 years
CPR/FA/AED | CPR, First Aid, AED [NAME] |  |  |  |  | N/A |  |  |  |  |  |  |  |  |  | PURPLE | Expired
RT-130 | Annual Fire Safety Refresher |  | 2024-03-19 00:00:00 | 1 |  | N/A | Certified
FitCat | Physical Fitness Level |  | 2024-03-20 00:00:00 | 1 |  | N/A | Certified