Mẫu quản lý ngày nghỉ phép_02.xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AN	AO
1	January	Leave Management worksheet - Januray 2022																																				Template designed by
2	January	Leave Management worksheet - Januray 2022
3	Department 1	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	Total Absence Days	Total Vacation Leave Days	Total Sick Leave Days	Total Other Leave Days	Total Work from Home Days	Absence type	Code
4	Department 1	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
5	Manager:	Manager Name
6	Employee 1																																0	0	0	0	0	Vacation Leave (Full Day)	L
7	Employee 2																																0	0	0	0	0	Vacation Leave (Morning)	L1
8	Employee 3																																0	0	0	0	0	Vacation Leave (Afternoon)	L2
9	Employee 4																																0	0	0	0	0	Sickness Leave (Full Day)	S
10	Employee 5																																0	0	0	0	0	Sickness Leave (Morning)	S1
11	Employee 6																																0	0	0	0	0	Sickness Leave (Afternoon)	S2
12	Employee 7																																0	0	0	0	0	Maternity or Paternity	P
13	Employee 8																																0	0	0	0	0	Compassionate Leave	C
14	Employee 9																																0	0	0	0	0	TOIL (Time Off In Lieu)	T
15	Employee 10																																0	0	0	0	0	Work From Home	W
16
17
18	Department 2	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	Total Absence Days	Total Vacation Leave Days	Total Sick Leave Days	Total Other Leave Days	Total Work from Home Days
19	Department 2	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
20	Manager:	Manager Name
21	Employee 11																																0	0	0	0	0
22	Employee 12																																0	0	0	0	0
23	Employee 13																																0	0	0	0	0
24	Employee 14																																0	0	0	0	0
25	Employee 15																																0	0	0	0	0
26	Employee 16																																0	0	0	0	0
27	Employee 17																																0	0	0	0	0
28	Employee 18																																0	0	0	0	0
29	Employee 19																																0	0	0	0	0
30	Employee 20																																0	0	0	0	0
31
32
33	Department 3	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	Total Absence Days	Total Vacation Leave Days	Total Sick Leave Days	Total Other Leave Days	Total Work from Home Days
34	Department 3	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
35	Manager:	Manager Name
36	Employee 21																																0	0	0	0	0
37	Employee 22																																0	0	0	0	0
38	Employee 23																																0	0	0	0	0
39	Employee 24																																0	0	0	0	0
40	Employee 25																																0	0	0	0	0
41	Employee 26																																0	0	0	0	0
42	Employee 27																																0	0	0	0	0
43	Employee 28																																0	0	0	0	0
44	Employee 29																																0	0	0	0	0
45	Employee 30																																0	0	0	0	0
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100