rekap absensi karyawan.xlsx

	B	C	D	E	F	G	H
1
2	Employee Absent Rate Calculator
3	Absent Rate
4			Total Employees			25
5			Working Days			5360
6			Average Working Days			214.4
7			Days Lost			1286
8			Absent Rate			23.99%
9
10	Absent Rate Monthly Data
11	Sr. No.	Month	Total Employees	Working Days	Average Working Days	Total Days Lost	Monthly Absent Rate
12	1	January	21	456	21.71	135	29.61%
13	2	February	21	415	19.76	144	34.70%
14	3	March	23	452	19.65	112	24.78%
15	4	April	22	422	19.18	106	25.12%
16	5	May	21	467	22.24	158	33.83%
17	6	June	19	417	21.95	133	31.89%
18	7	July	22	451	20.50	129	28.60%
19	8	August	21	486	23.14	125	25.72%
20	9	September	23	498	21.65	113	22.69%
21	10	October	23	426	18.52	106	24.88%
22	11	November	21	454	21.62	115	25.33%
23	12	December	21	418	19.90	100	23.92%
24			21	5362	249.84	1476
25
26	Yearly Absent Rate						28.13%
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
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