Employee Attendance Tracker

	B	C	D	E	F	G	H	I	J	K	L
1	EMPLOYEE ATTENDANCE TRACKER TEMPLATE
2	User to enter start date below. Enter Shift Data and Employee ID's with Pay Rates on respective tabs. Use dropdown menus in the table below to complete schedule. Calculations will perform automatically.
3	WEEK BEGINNING
4	09/01/2023
5		MON	TUES	WED	THURS	FRI	SAT	SUN
6	EMPLOYEE ID	09/01/2023	09/02/2023	09/03/2023	09/04/2023	09/05/2023	09/06/2023	09/07/2023	HOURS	RATE	PAY
7		–	–	–	–	–	–	–	0.00		$0.00
8		–	–	–	–	–	–	–	0.00		$0.00
9		–	–	–	–	–	–	–	0.00		$0.00
10		–	–	–	–	–	–	–	0.00		$0.00
11		–	–	–	–	–	–	–	0.00		$0.00
12		–	–	–	–	–	–	–	0.00		$0.00
13		–	–	–	–	–	–	–	0.00		$0.00
14		–	–	–	–	–	–	–	0.00		$0.00
15		–	–	–	–	–	–	–	0.00		$0.00
16		–	–	–	–	–	–	–	0.00		$0.00
17		–	–	–	–	–	–	–	0.00		$0.00
18		–	–	–	–	–	–	–	0.00		$0.00
19		–	–	–	–	–	–	–	0.00		$0.00
20		–	–	–	–	–	–	–	0.00		$0.00
21		–	–	–	–	–	–	–	0.00		$0.00
22										TOTAL COST	$0.00
23	ATTENDANCE POINTS
24	EMPLOYEE ID	DATE	DESCRIPTION		POINTS	DISCIPLINARY ACTION		TOTAL POINTS
25		MM/DD/YY			1			10
26		MM/DD/YY			2
27		MM/DD/YY			3
28					4
29					0			0
30					0
31					0
32					0
33					0			0
34					0
35					0
36					0
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