Spreadsheet: 861363d1709234946-summing-values-based-on-when-they-occured-in-a-fiscal-year-sample-data-2-29-24-etaf
Sheet: Occurrences

[NAME]
Associate: | [NAME], [NAME] |  | Date Prepared:
Total Points: |  | Level:
Last Accountability Issue Date: |  |  | Expiration Date:
Date | ID# | Employee ID | Associate Name | Occ. Type | Wellness | Age (Days old) | Points | Notes
2023-02-09 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-02-10 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-02-14 00:00:00 | 871 |  |  | Early Quit - Worked MORE than 1/2 Scheduled Day |  |  |  | eq 1.5
2023-02-15 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-02-16 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-02-17 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-02-22 00:00:00 | 871 |  |  | Wellness 2 | 2 |  |  | wlb 2.0-2023
2023-02-24 00:00:00 | 871 |  |  | Wellness 8 | 8 |  |  | wlb 8.0-2023
2023-03-01 00:00:00 | 871 |  |  | Tardy |  |  |  | 5:01
2023-03-02 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-03-03 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-03-06 00:00:00 | 871 |  |  | Wellness 2 | 2 |  |  | wlb 2.0-2023
2023-03-07 00:00:00 | 871 |  |  | Wellness 8 | 8 |  |  | wlb 8.0-2023
2023-03-08 00:00:00 | 871 |  |  | Wellness 2 | 2 |  |  | wlb 2.0-2023
2023-03-14 00:00:00 | 871 |  |  | Wellness 2 | 2 |  |  | wlb 2.0-2023
2023-03-15 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-03-17 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-03-20 00:00:00 | 871 |  |  | Wellness 2 | 2 |  |  | wlb 2.0-2023
2023-03-21 00:00:00 | 871 |  |  | Wellness 2 | 2 |  |  | wlb 2.0-2023
2023-03-22 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-03-23 00:00:00 | 871 |  |  |  |  |  |  | fmla 2.0
2023-03-24 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-03-27 00:00:00 | 871 |  |  |  |  |  |  | fmla 3.0
2023-03-28 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-03-30 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-03-31 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-04-03 00:00:00 | 871 |  |  |  |  |  |  | fmla 2.0
2023-04-04 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-04-05 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-04-06 00:00:00 | 871 |  |  |  |  |  |  | fmla 1.9
2023-04-07 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-04-10 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-04-11 00:00:00 | 871 |  |  |  |  |  |  | fmla 1.9
2023-04-12 00:00:00 | 871 |  |  |  |  |  |  | fmla 2.9
2023-04-13 00:00:00 | 871 |  |  |  |  |  |  | per Jan B.
2023-04-18 00:00:00 | 871 |  |  |  |  |  |  | per Jan B.
2023-04-19 00:00:00 | 871 |  |  | Wellness 2 | 2 |  |  | wlb 2.0-2023
2023-04-24 00:00:00 | 871 |  |  |  |  |  |  | per Jan B.
2023-05-01 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-05-03 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-05-04 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-05-10 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-05-11 00:00:00 | 871 |  |  | Wellness 2 | 2 |  |  | wlb 2.0-2023--no wlb left
2023-05-15 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-05-16 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-05-25 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-05-26 00:00:00 | 871 |  |  |  |  |  |  | FMLA 1.9
2023-05-31 00:00:00 | 871 |  |  |  |  |  |  | per Jan B
2023-06-01 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-06-02 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-06-05 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-06-09 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-06-13 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-06-20 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-06-21 00:00:00 | 871 |  |  |  |  |  |  | fmla 1.9
2023-06-28 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-06-29 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-06-30 00:00:00 | 871 |  |  |  |  |  |  | per Jan B
2023-07-03 00:00:00 | 871 |  |  | Late - Worked MORE than 1/2 Scheduled Day |  |  |  | late 1.9
2023-07-05 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-07-06 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-07-07 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-07-10 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-07-11 00:00:00 | 871 |  |  |  |  |  |  | fmla 1.8
2023-07-12 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-07-13 00:00:00 | 871 |  |  | Late - Worked MORE than 1/2 Scheduled Day |  |  |  | late 1.8
2023-07-21 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-07-25 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-08-01 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-08-02 00:00:00 | 871 |  |  |  |  |  |  | fmla 1.9
2023-08-03 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-08-08 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-08-09 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-08-10 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-08-11 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-08-14 00:00:00 | 871 |  |  | LOA |  |  |  | 8/14 to 8/18/2023
2023-08-21 00:00:00 | 871 |  |  | LOA |  |  |  | 8/21 o 8/25/2023
2023-08-28 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-08-31 00:00:00 | 871 |  |  |  |  |  |  | per Jan B
2023-09-01 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-09-05 00:00:00 | 871 |  |  | LOA |  |  |  | FMLA PD
2023-09-06 00:00:00 | 871 |  |  | LOA |  |  |  | FMLA PD 4.9 UNPD 3.1
2023-09-07 00:00:00 | 871 |  |  | LOA |  |  |  | 1.9 FMLA UNPD
2023-09-08 00:00:00 | 871 |  |  | LOA |  |  |  | 1.9 FMLA UNPD
2023-09-11 00:00:00 | 871 |  |  |  |  |  |  | fmla
2023-09-14 00:00:00 | 871 |  |  | Absent - Sick
2023-09-15 00:00:00 | 871 |  |  | Absent - Combined (Days 2-3)
2023-09-18 00:00:00 | 871 |  |  | Absent - Combined (Days 2-3)
2023-09-25 00:00:00 | 871
2023-09-29 00:00:00 | 871
2023-10-02 00:00:00 | 871
2023-10-04 00:00:00 | 871
2023-10-05 00:00:00 | 871
2023-10-06 00:00:00 | 871
2023-10-10 00:00:00 | 871
2023-10-13 00:00:00 | 871
2023-10-16 00:00:00 | 871 |  |  | Late - Worked MORE than 1/2 Scheduled Day
2023-10-17 00:00:00 | 871 |  |  | Absent - Failure to Report
2023-10-19 00:00:00 | 871 |  |  | Absent
2023-10-20 00:00:00 | 871
2023-10-24 00:00:00 | 871
2023-10-25 00:00:00 | 871 |  |  | Absent
2023-10-26 00:00:00 | 871
2023-10-31 00:00:00 | 871 |  |  | LOA
2023-11-06 00:00:00 | 871 |  |  | LOA
2023-11-13 00:00:00 | 871 |  |  | LOA
2023-11-20 00:00:00 | 871 |  |  | LOA
2023-11-27 00:00:00 | 871 |  |  | LOA
2023-12-01 00:00:00 | 871 |  |  | LOA
2023-12-04 00:00:00 | 871 |  |  | LOA
2023-12-11 00:00:00 | 871 |  |  | LOA
2023-12-12 00:00:00 | 871 |  |  | LOA
2023-12-13 00:00:00 | 871 |  |  | LOA
2023-12-14 00:00:00 | 871 |  |  | LOA
2023-12-15 00:00:00 | 871 |  |  | LOA
2023-12-18 00:00:00 | 871 |  |  | LOA
2023-12-26 00:00:00 | 871 |  |  | LOA
2024-01-09 00:00:00 | 871
2024-01-22 00:00:00 | 871
2024-02-02 00:00:00 | 871
2024-02-05 00:00:00 | 871 |  |  | WDU8 | 8
2024-02-06 00:00:00 | 871 |  |  | WDU8 | 8
2023-03-02 00:00:00 | 142 |  |  | Tardy
2023-03-16 00:00:00 | 142 |  |  | Wellness 8 | 8
2023-03-20 00:00:00 | 142 |  |  | Wellness 8 | 8
2023-03-23 00:00:00 | 142 |  |  | Tardy
2023-03-28 00:00:00 | 142 |  |  | Tardy
2023-03-29 00:00:00 | 142 |  |  | Late - Worked MORE than 1/2 Scheduled Day
2023-03-30 00:00:00 | 142 |  |  | Tardy
2023-04-03 00:00:00 | 142 |  |  | Tardy
2023-04-06 00:00:00 | 142 |  |  | Tardy
2023-04-11 00:00:00 | 142 |  |  | Tardy
2023-04-24 00:00:00 | 142 |  |  | Absent
2023-04-25 00:00:00 | 142 |  |  | Absent - Combined (Days 2-3)
2023-04-26 00:00:00 | 142 |  |  | Absent - Combined (Days 2-3)
2023-05-12 00:00:00 | 142 |  |  | Tardy
2023-05-16 00:00:00 | 142 |  |  | Absent - Sick
2023-05-22 00:00:00 | 142 |  |  | Tardy
2023-06-30 00:00:00 | 142 |  |  | Tardy
2023-07-06 00:00:00 | 142 |  |  | Tardy
2023-07-12 00:00:00 | 142 |  |  | Absent - Sick
2023-07-13 00:00:00 | 142 |  |  | Absent - Combined (Days 2-3)
2023-07-14 00:00:00 | 142 |  |  | Absent - Combined (Days 2-3)
2023-08-23 00:00:00 | 142 |  |  | Tardy
2023-09-28 00:00:00 | 142 |  |  | Wellness 2 | 2
2023-11-13 00:00:00 | 142 |  |  | Wellness 8 | 8
2023-11-14 00:00:00 | 142 |  |  | Wellness 8 | 8
2023-11-15 00:00:00 | 142 |  |  | Absent - Sick
2023-11-16 00:00:00 | 142 |  |  | Absent - Combined (Days 2-3)
2023-11-17 00:00:00 | 142 |  |  | Absent - Combined (Days 2-3)
2023-12-27 00:00:00 | 142 |  |  | Absent - Sick
2023-12-28 00:00:00 | 142 |  |  | Absent - Combined (Days 2-3)
2023-12-29 00:00:00 | 142 |  |  | Absent - Combined (Days 2-3)
2024-01-10 00:00:00 | 142 |  |  | Tardy
2023-02-06 00:00:00 | 213 |  |  | Wellness 8 | 8
2023-02-07 00:00:00 | 213 |  |  | Wellness 8 | 8
2023-02-08 00:00:00 | 213 |  |  | Absent - Sick
2023-02-20 00:00:00 | 213 |  |  | Bereavement
2023-03-06 00:00:00 | 213 |  |  | Wellness 8 | 8
2023-03-13 00:00:00 | 213 |  |  | Wellness 8 | 8
2023-04-13 00:00:00 | 213 |  |  | Absent
2023-06-30 00:00:00 | 213 |  |  | Funeral
2023-07-06 00:00:00 | 213 |  |  | Absent - Sick
2023-07-07 00:00:00 | 213 |  |  | Absent - Combined (Days 2-3)
2023-07-10 00:00:00 | 213 |  |  | Absent - Combined (Days 2-3)
2023-08-11 00:00:00 | 213 |  |  | Absent - Sick
2023-08-14 00:00:00 | 213 |  |  | Absent - Combined (Days 2-3)
2023-08-15 00:00:00 | 213 |  |  | Absent - Combined (Days 2-3)
2023-08-21 00:00:00 | 213 |  |  | Late - Worked MORE than 1/2 Scheduled Day
2023-10-04 00:00:00 | 213 |  |  | Absent - Sick
2023-10-05 00:00:00 | 213 |  |  | Absent - Combined (Days 2-3)
2023-10-06 00:00:00 | 213 |  |  | Absent - Combined (Days 2-3)
2023-12-29 00:00:00 | 213 |  |  | Absent - Sick
2024-01-23 00:00:00 | 213 |  |  | Absent
2024-02-05 00:00:00 | 213 |  |  | WDU8 | 8
2024-02-06 00:00:00 | 213 |  |  | WDU8 | 8