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

NAME | DATE | SHIFT | BADGE | DEPT | REASON | COMMENT
 | 2002-07-01 00:00:00 | 3 | 285518 | [NAME] | Left Early
 | 2002-07-07 00:00:00 | 3 | 285518 | [NAME] | Personal
 | 2022-07-01 00:00:00 | 1 | 289677 | [NAME] | Sick
 | 2022-07-01 00:00:00 | 1 | 287111 | GP | Sick |  |  |  |  | Count of REASON | Column Labels
 | 2022-07-01 00:00:00 | 3 | 639820 | RL | FMLA |  |  |  |  | Row Labels | Arrived Late | FMLA | Left Early | LOA | Other | Personal | Sick | SICK | (blank) | Grand Total
 | 2022-07-03 00:00:00 | 3 | 639820 | RL | Sick |  |  |  |  | FT | 1 | 2 | 1 |  | 2 | 5 | 6 |  |  | 17
 | 2022-07-05 00:00:00 | 1 | 444822 | RM | Sick |  |  |  |  | Crystal Bell | 1 |  |  |  |  |  | 3 |  |  | 4
 | 2022-07-05 00:00:00 | 1 | 677163 | RM | Sick |  |  |  |  | [NAME] |  |  |  |  |  |  | 1 |  |  | 1
 | 2022-07-06 00:00:00 | 1 | 677163 | RM | Sick |  |  |  |  | [NAME] |  | 2 | 1 |  |  |  | 2 |  |  | 5
 | 2022-07-06 00:00:00 | 1 | 278459 | HP | Sick |  |  |  |  | Marcial Plazola |  |  |  |  |  | 1 |  |  |  | 1
 | 2022-07-06 00:00:00 | 1 | 272459 | Hotel | Personal |  |  |  |  | [NAME]
 | 2022-07-06 00:00:00 | 2 | 461070 | HP | FMLA |  |  |  |  | [NAME] |  |  |  |  | 1 |  |  |  |  | 1
 | 2022-07-07 00:00:00 | 1 | 278459 | HP | Sick |  |  |  |  | [NAME] |  |  |  |  | 1 | 4 |  |  |  | 5
 | 2022-07-07 00:00:00 | 1 | 272459 | Hotel | Personal |  |  |  |  | GP |  | 1 |  |  |  | 1 | 5 |  |  | 7
 | 2022-07-07 00:00:00 | 2 | 461070 | HP | FMLA |  |  |  |  | [NAME] |  |  |  |  |  |  | 3 |  |  | 3
 | 2022-07-08 00:00:00 | 1 | 282157 | RM | Personal |  |  |  |  | [NAME] |  | 1 |  |  |  | 1 | 2 |  |  | 4
 | 2022-07-08 00:00:00 | 2 | 296580 | HP | Sick |  |  |  |  | Hotel |  | 5 |  |  |  |  |  |  |  | 5
 | 2022-07-11 00:00:00 | 3 | 639820 | RL | Sick |  |  |  |  | Sergio Platas |  | 5 |  |  |  |  |  |  |  | 5
 | 2022-07-11 00:00:00 | 2 | 461070 | HP | FMLA |  |  |  |  | HP |  | 4 |  |  |  | 2 |  |  |  | 6
 | 2022-07-11 00:00:00 | 1 | 668536 | RL | Sick |  |  |  |  | [NAME] |  |  |  |  |  | 1 |  |  |  | 1
 | 2022-07-11 00:00:00 | 1 | 841622 | IC | Sick |  |  |  |  | [NAME] |  | 4 |  |  |  | 1 |  |  |  | 5
 | 2022-07-12 00:00:00 | 1 | 580586 | GP | Other |  |  |  |  | RL |  |  | 1 |  |  |  | 4 |  |  | 5
 | 2022-07-12 00:00:00 | 1 | 444801 | SP | Left Early |  |  |  |  | [NAME] |  |  |  |  |  |  | 1 |  |  | 1
 | 2022-07-12 00:00:00 | 1 | 812245 | [NAME] | Sick |  |  |  |  | [NAME] |  |  | 1 |  |  |  | 2 |  |  | 3
 | 2022-07-12 00:00:00 | 3 | 639820 | RL | Sick |  |  |  |  | [NAME] |  |  |  |  |  |  | 1 |  |  | 1
 | 2022-07-12 00:00:00 | 2 | 571161 | GP | Sick |  |  |  |  | RM |  |  | 1 |  |  |  | 11 |  |  | 12
 | 2022-07-12 00:00:00 | 1 | 841622 | IC | Sick |  |  |  |  | [NAME] |  |  |  |  |  |  | 1 |  |  | 1
 | 2022-07-13 00:00:00 | 1 | 615723 | [NAME] | Sick |  |  |  |  | Deida Marquez |  |  | 1 |  |  |  | 10 |  |  | 11
 | 2022-07-13 00:00:00 | 1 | 812245 | [NAME] | Sick |  |  |  |  | Shipping |  |  |  |  |  | 1 |  | 3 |  | 4
 | 2022-07-13 00:00:00 | 3 | 600130 | FT | Personal |  |  |  |  | Rambo Mereb |  |  |  |  |  | 1 |  | 3 |  | 4
 | 2022-07-13 00:00:00 | 3 | 639820 | RL | Sick |  |  |  |  | SP |  |  | 1 |  |  | 1 | 3 |  |  | 5
 | 2022-07-13 00:00:00 | 2 | 296580 | HP | Sick |  |  |  |  | [NAME] |  |  |  |  |  | 1 |  |  |  | 1
 | 2022-07-13 00:00:00 | 2 | 461070 | HP | FMLA |  |  |  |  | [NAME] |  |  |  |  |  |  | 1 |  |  | 1
 | 2022-07-14 00:00:00 | 1 | 580310 | SP | Left Early |  |  |  |  | [NAME] |  |  |  |  |  |  | 1 |  |  | 1
 | 2022-07-14 00:00:00 | 3 | 639820 | RL | Sick |  |  |  |  | [NAME] |  |  | 1 |  |  |  | 1 |  |  | 2
 | 2022-07-15 00:00:00 | 1 | 580586 | GP | Other |  |  |  |  | [NAME] | 3 |  |  | 3 |  | 11 |  |  |  | 17
 | 2022-07-15 00:00:00 | 1 |  | FT | Arrived Late |  |  |  |  | [NAME] |  |  |  |  |  | 4 |  |  |  | 4
 | 2022-07-15 00:00:00 | 1 | 282157 | RM | Sick |  |  |  |  | [NAME] |  |  |  |  |  | 2 |  |  |  | 2
 | 2022-07-15 00:00:00 | 1 |  | FT | Left Early |  |  |  |  | [NAME] |  |  |  |  |  | 1 |  |  |  | 1
 | 2022-07-18 00:00:00 | 1 | 287111 | GP | Sick |  |  |  |  | [NAME] |  |  |  |  |  | 1 |  |  |  | 1
 | 2022-07-18 00:00:00 | 2 |  | RM |  |  |  |  |  | [NAME] | 1 |  |  |  |  |  |  |  |  | 1
 | 2022-07-18 00:00:00 | 2 | 461070 | HP | FMLA |  |  |  |  | [NAME] |  |  |  |  |  | 1 |  |  |  | 1
 | 2022-07-19 00:00:00 | 1 |  | FT | Sick |  |  |  |  | [NAME] | 2 |  |  | 3 |  | 1 |  |  |  | 6
 | 2022-07-20 00:00:00 | 1 |  | FT | Sick |  |  |  |  | [NAME] |  |  |  |  |  | 1 |  |  |  | 1
 | 2022-07-21 00:00:00 | 1 |  | FT | Sick |  |  |  |  | (blank)
 | 2022-07-21 00:00:00 | 2 | 461070 | HP | FMLA |  |  |  |  | (blank)
 | 2022-07-23 00:00:00 | 1 |  | FT | Sick |  |  |  |  | Grand Total | 4 | 12 | 4 | 3 | 2 | 21 | 29 | 3 |  | 78
 | 2022-07-23 00:00:00 | 1 | 287111 | GP | FMLA
 | 2022-07-25 00:00:00 | 1 | 287111 | GP | FMLA
 | 2022-07-25 00:00:00 | 1 | 272459 | Hotel | Sick
 | 2022-07-25 00:00:00 | 1 | 272459 | Hotel | Sick
 | 2022-07-25 00:00:00 | 1 | 272459 | Hotel | Sick
 | 2022-07-26 00:00:00 | 1 | 287111 | GP | FMLA
 | 2022-07-26 00:00:00 | 1 |  | FT | Sick
 | 2022-07-27 00:00:00 | 1 | 44482 | RM | Sick
 | 2022-07-27 00:00:00 | 1 |  | FT | Sick
 | 2022-07-28 00:00:00 | 1 | 274037 | HP | Personal
 | 2022-07-28 00:00:00 | 2 | 461070 | HP | FMLA
 | 2022-07-29 00:00:00 | 1 | 274037 | HP | Personal
 | 2022-07-29 00:00:00 | 2 | 461070 | HP | FMLA