Start Of Day Template

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Name	10-bday SOD Submisison %	10-bday SOD Punctuality	Schedule	Fri, Jan 14,	Thu, Jan 13,	Wed, Jan 12,	Tue, Jan 11,	Mon, Jan 10,	Fri, Jan 7,	Thu, Jan 6,	Wed, Jan 5,	Tue, Jan 4,	Mon, Jan 3,

2	Add name here	100.00%	Never Submitted	Add schedule here
3	Add name here	100.00%	Never Submitted	Add schedule here
4	Add name here	100.00%	Never Submitted	Add schedule here
5	Add name here	100.00%	Never Submitted	Add schedule here
6	Add name here	100.00%	Never Submitted	Add schedule here
7	John (Sample)	100.00%	0:06:36	9 AM to 5 PM PST	0:04:00	0:06:00	0:04:00	0:06:00	0:04:00	0:09:00	0:10:00	0:04:00	0:09:00	0:10:00
8	Maria (Sample)	100.00%	-0:02:06	9 AM to 5 PM PST	0:06:00	0:04:00	0:06:00	0:04:00	0:09:00	0:00:00	-0:30:00	0:00:00	-0:14:00	-0:06:00
9	Jane (Sample)	70.00%	0:05:34	1 PM to 9 PM PST	0:04:00	0:06:00	0:04:00	X	X	0:10:00	-0:02:00	0:07:00	0:10:00	x
10	Hector (Sample)	100.00%	0:02:00	8 AM to 4 PM PST	0:04:00	0:04:00	0:04:00	0:00:00	J	J	J	0:00:00	0:00:00	J
11
12
13	Legend
14	X - Value of a cell under a date column if the individual is absent without leave.
15	J - Value of a cell under a date column if the individual is on a leave of absence.
16	10-bday SOD Submisison % - The % of days that an individual has come in for work in the last 10 business days. Excludes leaves of absence.
17	10-bday SOD Punctuality - The average difference of an individual's start of shift and actual time started working in the last 10 business days. Excludes leaves of absence.
18
19	Remarks
20	You can copy the cells under column B to other cells under column B to preserve the formula.
21	You can copy the cells under column C to other cells under column C to preserve the formula.
22
23
24
25
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