Spreadsheet: 794632d1662163656-employee-absence-tracker-rolling-12-month-window-needed-2022-exempt-sick-test
Sheet: JUNE

NAME | DATE | SHIFT | BADGE | DEPT | REASON | COMMENT
[NAME] | 2022-06-02 00:00:00 | 1 | 274037 | HP | Personal
[NAME] | 2022-06-03 00:00:00 | 1 | 274037 | HP | Personal
[NAME] | 2022-06-09 00:00:00 | 1 | 274037 | HP | Left Early | 11:30AM
 | 2022-06-02 00:00:00 | 2 |  | FT | Sick
 | 2022-06-03 00:00:00 | 2 |  | FT | Sick
 | 2022-06-06 00:00:00 | 1 | 289680 | SP | Sick
 | 2022-06-07 00:00:00 | 1 | 289680 | SP | Sick
 | 2022-06-08 00:00:00 | 1 | 289680 | SP | Sick |  |  |  |  | Count of REASON | Column Labels
 | 2022-06-09 00:00:00 | 1 | 289680 | SP | Sick |  |  |  |  | Row Labels | Arrived Late | FMLA | Left Early | Personal | Sick | (blank) | Grand Total
 | 2022-06-10 00:00:00 | 1 | 289680 | SP | Sick |  |  |  |  | FT |  | 1 | 1 | 6 | 11 |  | 19
 | 2022-06-08 00:00:00 | 1 | 842249 | RL | Left Early |  |  |  |  | Crystal Bell |  |  |  |  | 4 |  | 4
 | 2022-06-10 00:00:00 | 1 | 842249 | RL | Left Early |  |  |  |  | [NAME] |  |  |  | 2 |  |  | 2
 | 2022-06-14 00:00:00 | 2 |  | RM | Personal |  |  |  |  | [NAME] |  | 1 |  |  |  |  | 1
 | 2022-06-20 00:00:00 | 1 | 710194 | GP | Personal |  |  |  |  | Marcial Plazola |  |  |  |  | 1 |  | 1
 | 2022-06-07 00:00:00 | 1 | 580586 | GP | Personal |  |  |  |  | [NAME] |  |  |  |  | 5 |  | 5
 | 2022-06-27 00:00:00 | 1 | 580586 | GP | Sick |  |  |  |  | [NAME] |  |  | 1 |  | 1 |  | 2
 | 2022-06-28 00:00:00 | 1 | 580586 | GP | Sick |  |  |  |  | [NAME] |  |  |  | 4 |  |  | 4
 | 2022-06-01 00:00:00 | 2 | 280484 | [NAME] | Arrived Late |  |  |  |  | [NAME] |  | 1 |  | 4 | 6 |  | 11
 | 2022-06-03 00:00:00 | 2 | 280484 | [NAME] | Left Early |  |  |  |  | [NAME] bonazinga |  |  |  | 2 | 3 |  | 5
 | 2022-06-04 00:00:00 | 2 | 280484 | [NAME] | Personal |  |  |  |  | [NAME] |  |  |  | 2 |  |  | 2
 | 2022-06-10 00:00:00 | 1 | 677163 | RM | Left Early |  |  |  |  | [NAME] |  | 1 |  |  |  |  | 1
 | 2022-06-13 00:00:00 | 1 | 677163 | RM | Sick |  |  |  |  | [NAME] |  |  |  |  | 2 |  | 2
 | 2022-06-14 00:00:00 | 1 | 677163 | RM | Sick |  |  |  |  | Vevenice Hernandez |  |  |  |  | 1 |  | 1
 | 2022-06-09 00:00:00 | 1 |  | [NAME] | Sick |  |  |  |  | Hotel |  | 4 |  | 2 | 1 |  | 7
 | 2022-06-20 00:00:00 | 1 | 615723 | [NAME] | Sick |  |  |  |  | Sergio Platas |  | 4 |  |  |  |  | 4
 | 2022-06-21 00:00:00 | 1 | 615723 | [NAME] | Sick |  |  |  |  | [NAME] fuller |  |  |  | 2 |  |  | 2
 | 2022-06-28 00:00:00 | 1 | 289677 | [NAME] | Sick |  |  |  |  | [NAME] |  |  |  |  | 1 |  | 1
 | 2022-06-29 00:00:00 | 1 | 289677 | [NAME] | Sick |  |  |  |  | HP |  |  | 1 | 3 | 3 |  | 7
 | 2022-06-30 00:00:00 | 1 | 289677 | [NAME] | Sick |  |  |  |  | [NAME] |  |  |  |  | 3 |  | 3
 | 2022-06-21 00:00:00 | 1 | 287111 | GP | FMLA |  |  |  |  | [NAME] |  |  |  | 2 |  |  | 2
 | 2022-06-22 00:00:00 | 1 | 287111 | GP | FMLA |  |  |  |  | [NAME] |  |  | 1 | 1 |  |  | 2
 | 2022-06-29 00:00:00 | 1 | 287111 | GP | Sick |  |  |  |  | RL |  | 1 |  | 1 | 2 |  | 4
 | 2022-06-30 00:00:00 | 1 | 287111 | GP | Sick |  |  |  |  | [NAME] |  |  |  |  | 1 |  | 1
 | 2022-06-08 00:00:00 | 3 | 434025 | FT | sick |  |  |  |  | carolina [NAME] |  | 1 |  | 1 |  |  | 2
 | 2022-06-08 00:00:00 | 2 | 841627 | [NAME] | sick |  |  |  |  | [NAME] |  |  |  |  | 1 |  | 1
 | 2022-06-27 00:00:00 | 1 | 279310 | HP | Sick |  |  |  |  | RM |  |  | 1 |  | 7 |  | 8
 | 2022-06-28 00:00:00 | 1 | 279310 | HP | Sick |  |  |  |  | Deida Marquez |  |  | 1 |  | 4 |  | 5
 | 2022-06-29 00:00:00 | 1 | 279310 | HP | Sick |  |  |  |  | [NAME] |  |  |  |  | 3 |  | 3
 | 2022-06-21 00:00:00 | 1 |  | FT | Personal |  |  |  |  | Shipping |  |  |  | 7 | 1 |  | 8
 | 2022-06-22 00:00:00 | 1 |  | FT | Personal |  |  |  |  | Ana Cerros |  |  |  | 5 |  |  | 5
 | 2022-06-23 00:00:00 | 1 |  | FT | Personal |  |  |  |  | Rambo Mereb |  |  |  | 2 |  |  | 2
 | 2022-06-27 00:00:00 | 1 | 279041 | RL | Sick |  |  |  |  | [NAME] |  |  |  |  | 1 |  | 1
 | 2022-06-16 00:00:00 | 2 |  | RM | Personal |  |  |  |  | SP | 2 |  |  | 3 | 9 |  | 14
 | 2022-06-24 00:00:00 | 2 |  | RM | Other |  |  |  |  | [NAME] |  |  |  | 2 | 1 |  | 3
 | 2022-06-04 00:00:00 | 2 |  | FT | Left Early |  |  |  |  | [NAME] |  |  |  |  | 1 |  | 1
 | 2022-06-13 00:00:00 | 2 | 108757 | RL | Personal |  |  |  |  | [NAME] |  |  |  | 1 |  |  | 1
 | 2022-06-21 00:00:00 | 2 | 969977 | Shipping | Sick |  |  |  |  | [NAME] | 2 |  |  |  | 2 |  | 4
 | 2022-06-22 00:00:00 | 2 | 969977 | Shipping | Sick |  |  |  |  | [NAME] |  |  |  |  | 5 |  | 5
 | 2022-06-30 00:00:00 | 2 | 969977 | Shipping | FMLA |  |  |  |  | [NAME] | 1 |  | 4 | 8 | 9 |  | 22
 | 2022-06-09 00:00:00 | 1 | 841622 | IC | Left Early |  |  |  |  | [NAME] |  |  |  | 2 | 1 |  | 3
 | 2022-06-30 00:00:00 | 1 | 841622 | IC | Left Early |  |  |  |  | [NAME] |  |  |  |  | 2 |  | 2
 | 2022-06-06 00:00:00 | 1 | 278459 | HP | Left Early |  |  |  |  | [NAME] |  |  |  | 1 |  |  | 1
 | 2022-06-28 00:00:00 | 1 | 278459 | HP | SICK |  |  |  |  | [NAME] |  |  | 1 |  |  |  | 1
 | 2022-06-29 00:00:00 | 1 | 278459 | HP | SICK |  |  |  |  | [NAME] |  |  |  | 2 |  |  | 2
 | 2022-06-06 00:00:00 | 2 | 296580 | HP | Sick |  |  |  |  | [NAME] | 1 |  | 1 | 2 |  |  | 4
 | 2022-06-07 00:00:00 | 2 | 296580 | HP | Arrived Late |  |  |  |  | [NAME] |  |  | 2 | 1 | 1 |  | 4
 | 2022-06-20 00:00:00 | 2 | 296580 | HP | Sick |  |  |  |  | [NAME] |  |  |  |  | 5 |  | 5
 | 2022-06-20 00:00:00 | 1 | 563447 | RL | Sick |  |  |  |  | (blank)
 | 2022-06-03 00:00:00 | 1 | 570698 | SP | Left Early |  |  |  |  | (blank)
 | 2022-06-04 00:00:00 | 1 | 570698 | SP | Sick |  |  |  |  | Grand Total | 3 | 7 | 7 | 34 | 49 |  | 100
 | 2022-06-02 00:00:00 | 1 | 272459 | Hotel | Sick
 | 2022-06-03 00:00:00 | 1 | 272459 | Hotel | Sick
 | 2022-06-02 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-06-06 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-06-09 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-06-13 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-06-16 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-06-20 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-06-27 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-06-14 00:00:00 | 1 |  | RL | Sick
 | 2022-06-15 00:00:00 | 1 |  | RL | Sick
 | 2022-06-16 00:00:00 | 1 |  | RL | Sick
 | 2022-06-20 00:00:00 | 1 |  | RL | Sick
 | 2022-06-21 00:00:00 | 1 |  | RL | Sick
 | 2022-06-23 00:00:00 | 1 |  | RL | Sick