نموذج حساب ايام التغيب (1).xls

	A	B	D	F	H	J
1
2	Absenteeism - Combined Calculation
3	(Lost workdays due to absenteeism)
4	(Formulas are included.)
5		No. of Lost	Avg No. of	Avg no. of	Avg No. of	Absenteeism
6		Workdays Due	Employees	Workdays	Employees	Rate
7		to Absences			x Avg No. of
8					Workdays
9
10	January					#DIV/0!
11	February					#DIV/0!
12	March					#DIV/0!
13	April					#DIV/0!
14	May					#DIV/0!
15	June					#DIV/0!
16	July					#DIV/0!
17	August					#DIV/0!
18	September					#DIV/0!
19	October					#DIV/0!
20	November					#DIV/0!
21	December					#DIV/0!
22	TOTALS	0	0	0	N/A	#DIV/0!
23
24
25	Note: The formula for combined absenteeism rate is the number of lost workdays due to absences divided by the product of the average number of employees multiplied by the average number of workdays during period multiplied by 100.
26
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