0% found this document useful (0 votes)
152 views13 pages

tf03987167 Win321

The employee absence schedule summarizes employee absences for January through June 2016. It shows the type of absence taken each date for 5 employees. In January, Employee 1 took 5 vacation days, Employee 2 took 7 days consisting of sick and personal days, Employee 3 took 3 personal days, Employee 4 took 4 vacation days, and Employee 5 took 6 days consisting of sick and vacation days. The January total was 25 absent days among the employees.

Uploaded by

Widya Astika
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
152 views13 pages

tf03987167 Win321

The employee absence schedule summarizes employee absences for January through June 2016. It shows the type of absence taken each date for 5 employees. In January, Employee 1 took 5 vacation days, Employee 2 took 7 days consisting of sick and personal days, Employee 3 took 3 personal days, Employee 4 took 4 vacation days, and Employee 5 took 6 days consisting of sick and vacation days. The January total was 25 absent days among the employees.

Uploaded by

Widya Astika
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 13

Employee Absence Schedule

Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2


Enter year:

January Dates of Absence 2016


Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 V V V V V 5

Employee 2 S S P S V V V 7

Employee 3 P S S 3

Employee 4 P V V V 4

Employee 5 S V V S S V 6

January Total 2 2 3 3 1 1 1 1 1 1 2 1 1 1 1 1 1 1 25
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

February Dates of Absence 2016


Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Total Days

Employee 1 V V V V V 5

Employee 2 S S P S V V V 7

Employee 3 0

Employee 4 S S P S 4

Employee 5 V V V V S 5

February Total 2 1 2 2 1 1 1 2 1 1 1 1 1 1 1 1 1 21

Page 2 of 13
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

March Dates of Absence 2016


Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 0

Employee 2 0

Employee 3 0

Employee 4 0

Employee 5 0

March Total

Page 3 of 13
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

April Dates of Absence 2016


Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 0

Employee 2 0

Employee 3 0

Employee 4 0

Employee 5 0

April Total

Page 4 of 13
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

May Dates of Absence 2016


Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 0

Employee 2 0

Employee 3 0

Employee 4 0

Employee 5 0

May Total

Page 5 of 13
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

June Dates of Absence 2016


Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 0

Employee 2 0

Employee 3 0

Employee 4 0

Employee 5 0

June Total

Page 6 of 13
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

July Dates of Absence 2016


Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 0

Employee 2 0

Employee 3 0

Employee 4 0

Employee 5 0

July Total

Page 7 of 13
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

August Dates of Absence 2016


Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 0

Employee 2 0

Employee 3 0

Employee 4 0

Employee 5 0

August Total

Page 8 of 13
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

September Dates of Absence 2016


Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 0

Employee 2 0

Employee 3 0

Employee 4 0

Employee 5 0

September Total

Page 9 of 13
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

October Dates of Absence 2016


Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 0

Employee 2 0

Employee 3 0

Employee 4 0

Employee 5 0

October Total

Page 10 of 13
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

November Dates of Absence 2016


Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 0

Employee 2 0

Employee 3 0

Employee 4 0

Employee 5 0

November Total

Page 11 of 13
Employee Absence Schedule
Absence Type Key V Vacation P Personal S Sick Custom 1 Custom 2

December Dates of Absence 2016


Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat
Employee Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Total Days

Employee 1 0

Employee 2 0

Employee 3 0

Employee 4 0

Employee 5 0

December Total

Page 12 of 13
Employee Names

Employee Names

Benny Usdianto

Employee 2

Employee 3

Employee 4

Employee 5

You might also like