Spreadsheet: 94821d1294584301-lookup-last-cell-with-certain-text-and-give-heading-of-this-cell-dasha_absence-1-
Sheet: Employee Absence Tracker (2010)

Employee [NAME] project RBU
2010-01-01 00:00:00 | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total in days |  |  |  |  | %
Day & date of month | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | Total A/L | Total Stat | Total Sickness | Leave (unpaid) | Total Absence | Absentage | LAST DATE OF SICKNESS
 | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00 | 2010-01-16 00:00:00 | 2010-01-17 00:00:00 | 2010-01-18 00:00:00 | 2010-01-19 00:00:00 | 2010-01-20 00:00:00 | 2010-01-21 00:00:00 | 2010-01-22 00:00:00 | 2010-01-23 00:00:00 | 2010-01-24 00:00:00 | 2010-01-25 00:00:00 | 2010-01-26 00:00:00 | 2010-01-27 00:00:00 | 2010-01-28 00:00:00 | 2010-01-29 00:00:00 | 2010-01-30 00:00:00 | 2010-01-31 00:00:00 |  |  |  |  |  | % absentage
Anna | SICK | DO | DO | NCS | NCS1/2 | W | W | DO | DO | W | ST | W | A/L | W | DO | DO | A/L | W | W | SICK | W | DO | DO | W | W | W | SICK | W | DO | DO | W | 2 | 1 | 3 | 0 | 6 | 0.2142857142857143 | 2010-01-27 00:00:00
Beta | W |  |  | LU 1/2 | L | W | SICK | DO | DO |  | A/L | W | W | W | W | W | W | SICK | W | W | W | W |  |  | W | W | W | W | W |  |  | 1 | 0 | 2 | 0.5 | 3.5 | 0.09090909090909091 | 2010-01-18 00:00:00
Cecilia |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SICK |  |  | SICK |  |  |  |  |  |  | 0 | 0 | 2 | 0 | 2 | 1 | 2010-01-25 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | w |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Eva |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | N/A
Total occasion in absence | 1 | 0 | 0 | 0.5 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 1 | 7 | 0.5 | 11.5 | 1.305194805194805
Type of absence | 1day |  | 1/2 day
Annual Leave | A/L |  | AL 1/2
Stat days | ST |  | ST
Sickness | SICK |  | S 1/2
Leave (unpaid) | L/U |  | LU 1/2
Lateness | L |  | L 1/2
Left early | E |  | E 1/2
Paid special leave | PSL |  | PSL 1/2
No call no show | NCS |  | NCS1/2
Day off | DO |  | DO
Work | W |  | W