Spreadsheet: 865836d1712821143-best-ideas-for-tracking-toil-toil-template-jt
Sheet: Sheet1

Employee | Date Authorisation Requested | Date Request Authorised | Reason for Request | Request Authorised by | Date TOIL Accrued | Date TOIL Expires | Days until TOIL Expires | Date Requested TOIL to apply | Date of TOIL application approved | TOIL Application Approved by |  | Employee | # Days TOIL | # Days TOIL Expired | # Days Not Yet Expired | Next Expiring TOIL
Employee1 | 2024-01-17 00:00:00 | 2024-01-17 00:00:00 | Assist Contractor on site | Manager 1 | 2024-01-20 00:00:00 |  |  | 2024-02-05 00:00:00 | 2024-01-19 00:00:00 | Manager 3
Employee3 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-06-29 00:00:00 |  |  | 2024-01-29 00:00:00 | 2024-01-22 00:00:00 | Manager 3 |  | Employee3 | 4
Employee4 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-06-30 00:00:00 |  |  | 2024-01-30 00:00:00 | 2024-01-22 00:00:00 | Manager 3 |  | Employee4 | 8
Employee4 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-07-21 00:00:00 |  |  | 2024-03-18 00:00:00 | 2024-01-22 00:00:00 | Manager 3 |  | Employee7 | 6
Employee1 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-09-29 00:00:00 |  |  | 2024-03-19 00:00:00 | 2024-01-22 00:00:00 | Manager 3 |  | Employee2 | 8
Employee1 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-12-04 00:00:00 |  |  | 2024-03-20 00:00:00 | 2024-01-22 00:00:00 | Manager 3 |  | Employee5 | 9
Employee7 | Online Registration | Online Registration | Support for NYE event -  (08:00 to 18:00) | Online Approval | 2024-01-01 00:00:00 |  |  | 2024-03-21 00:00:00 | 2024-01-22 00:00:00 | Manager 3 |  | Employee6 | 5
Employee2 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-05-01 00:00:00 |  |  | 2024-02-12 00:00:00 | 2024-02-10 00:00:00 | Manager 3 |  | Employee8 | 2
Employee3 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-05-01 00:00:00 |  |  | 2024-02-13 00:00:00 | 2024-02-10 00:00:00 | Manager 3 |  | Employee9 | 2
Employee4 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-05-01 00:00:00 |  |  | 2024-02-14 00:00:00 | 2024-02-10 00:00:00 | Manager 3 |  | Employee10 | 1
Employee5 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-05-01 00:00:00 |  |  | 2024-02-15 00:00:00 | 2024-02-10 00:00:00 | Manager 3 |  | Employee 11 | 4
Employee6 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-05-01 00:00:00 |  |  | 2024-02-16 00:00:00 | 2024-02-10 00:00:00 | Manager 3
Employee7 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-05-01 00:00:00 |  |  | 2024-02-19 00:00:00 | 2024-02-10 00:00:00 | Manager 3 |  | First, transpose the raw data as suggested by AliGW.
Employee8 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-05-01 00:00:00 |  |  | 2024-02-20 00:00:00 | 2024-02-10 00:00:00 | Manager 3 |  | Next, convert into an Excel Table.
Employee9 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-05-01 00:00:00 |  |  | 2024-02-21 00:00:00 | 2024-02-10 00:00:00 | Manager 3
Employee3 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-05-01 00:00:00 |  |  | 2024-02-22 00:00:00 | 2024-02-10 00:00:00 | Manager 3 |  | Employee in M3: =UNIQUE(Table1[Employee])
Employee2 | 2023-04-01 00:00:00 | 2023-04-10 00:00:00 | Worked public holiday | Manager 1 | 2023-05-01 00:00:00 |  |  | 2024-02-23 00:00:00 | 2024-02-10 00:00:00 | Manager 3 |  | # Days TOIL in N3: =COUNTIFS(Table1[Employee],$M3#)
Employee2 | 2023-04-08 00:00:00 | 2023-04-08 00:00:00 | To witness the installation of bridge | Manager 1 | 2024-04-09 00:00:00 |  |  | 2024-01-31 00:00:00 | 2024-01-27 00:00:00 | Manager 3 |  | # Days TOIL Expired in O3: =COUNTIFS(Table1[Employee],$M3#,Table1[Date TOIL Expires],"<"&TODAY())
Employee7 | 2023-04-19 00:00:00 | 2023-04-19 00:00:00 | Join the Inspection team | Manager 1 | 2023-04-21 00:00:00 |  |  | 2024-02-01 00:00:00 | 2024-01-27 00:00:00 | Manager 3 |  | # Days Not Yet Expired in P3: =N3#-O3#
Employee2 | 2023-07-30 00:00:00 | 2023-08-18 00:00:00 | Attending with PMO | Manager 1 | 2023-07-30 00:00:00 |  |  | 2024-02-02 00:00:00 | 2024-01-27 00:00:00 | Manager 3 |  | Next Expiring TOIL in Q3: =MINIFS(Table1[Date TOIL Expires],Table1[Employee],M3#,Table1[Date TOIL Expires],">="&TODAY())
Employee7 | 2023-08-16 00:00:00 | 2023-08-16 00:00:00 | Attending ceiling refurbishing works | Manager 1 | 2023-08-12 00:00:00 |  |  | 2024-03-27 00:00:00 | 2024-03-26 00:00:00 | Manager 3
Employee2 | Online Registration | Online Registration | Supporting Public Event | Online Approval | 2023-11-26 00:00:00 |  |  | 2024-03-28 00:00:00 | 2024-03-26 00:00:00 | Manager 3
Employee5 | Online Registration | Online Registration | Support for NYE event -  (08:00 to 18:00) | Online Approval | 2024-01-01 00:00:00 |  |  | 2024-03-29 00:00:00 | 2024-03-26 00:00:00 | Manager 3
Employee5 | 2024-01-19 00:00:00 | 2024-01-19 00:00:00 | Attending the ceiling refurbishing works | Manager 3 | 2024-01-13 00:00:00 |  |  | 2024-03-30 00:00:00 | 2024-03-26 00:00:00 | Manager 3
Employee5 | 2024-01-19 00:00:00 | 2024-01-19 00:00:00 | Grouting works | Manager 3 | 2024-01-19 00:00:00
Employee6 | 2022-02-02 00:00:00 | 2022-02-02 00:00:00 | Attend Depot | Manager 3 | 2024-02-04 00:00:00
Employee5 | 2024-02-21 00:00:00 | 2024-02-22 00:00:00 | Attend demonstration ofmaintenance technique | Manager 1 | 2024-02-23 00:00:00 |  |  | 2024-03-22 00:00:00 | 2024-02-27 00:00:00 | Manager 1
Employee4 | 2024-03-07 00:00:00 | 2024-03-07 00:00:00 | Standby for forecast poor weather | Manager 2 | 2024-03-09 00:00:00 |  |  | 2024-03-25 00:00:00 | 2024-03-18 00:00:00 | Manager 1
Employee5 | 2024-03-07 00:00:00 | 2024-03-07 00:00:00 | Standby for forecast poor weather | Manager 2 | 2024-03-09 00:00:00
Employee5 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 1 | 2024-04-09 00:00:00
Employee7 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 1 | 2024-04-10 00:00:00
Employee5 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 1 | 2024-04-11 00:00:00
Employee6 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-09 00:00:00
Employee3 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-10 00:00:00
Employee4 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-11 00:00:00
Employee5 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-12 00:00:00
Employee7 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-09 00:00:00
Employee8 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-10 00:00:00
Employee9 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-11 00:00:00
Employee10 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-12 00:00:00
Employee2 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-09 00:00:00
Employee2 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-10 00:00:00
Employee2 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-11 00:00:00
Employee 11 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-09 00:00:00
Employee 11 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-10 00:00:00
Employee 11 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-11 00:00:00
Employee 11 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-12 00:00:00
Employee6 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-09 00:00:00
Employee6 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-10 00:00:00
Employee4 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-09 00:00:00
Employee4 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-10 00:00:00
Employee4 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-11 00:00:00
Employee1 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-12 00:00:00
Employee1 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-09 00:00:00
Employee1 | 2024-04-05 00:00:00 | 2024-04-05 00:00:00 | Working public holiday | Manager 3 | 2024-04-10 00:00:00