Example Schedule.xlsx

	A	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	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BQ	BR
1	Name	Status	Hire Date (Manual)	Current Group	Years of Service (Formula)	Group 1	Rotation Frequency (Formula-1)	Starting Weekend-1	Ending Weekend-1	Group-2	Rotation Frequency (Formula-2)	Starting Weekend-2	Ending Weekend-2	2025	4-Jan-25	11-Jan-25	18-Jan-25	25-Jan-25	1-Feb-25	8-Feb-25	15-Feb-25	22-Feb-25	1-Mar-25	8-Mar-25	15-Mar-25	22-Mar-25	29-Mar-25	5-Apr-25	12-Apr-25	19-Apr-25	26-Apr-25	3-May-25	10-May-25	17-May-25	24-May-25	31-May-25	7-Jun-25	14-Jun-25	21-Jun-25	28-Jun-25	5-Jul-25	12-Jul-25	19-Jul-25	26-Jul-25	2-Aug-25	9-Aug-25	16-Aug-25	23-Aug-25	30-Aug-25	6-Sep-25	13-Sep-25	20-Sep-25	27-Sep-25	4-Oct-25	11-Oct-25	18-Oct-25	25-Oct-25	1-Nov-25	8-Nov-25	15-Nov-25	22-Nov-25	29-Nov-25	6-Dec-25	13-Dec-25	20-Dec-25	27-Dec-25	# Staff per Group
2														Group Working →	B	E	A	B,E	F	A,E	B	E	A	B,E	F	A,E		E	A	E	F	A,E	C	E	D,A	C,E	D	A,E	C,D	F	D,A	C,F	D	A	C,D		D,A	C,F		A				E,F		E		E		E,F		E		E		E	Groups	Count
3														# of Staff Assigned →	1	1	1	2	1	2	1	1	1	2	1	2	1	1	1	1	1	2	1	1	2	2	1	2	2	1	2	2	1	1	2	1	2	2	1	1	1	1	1	2	1	1	1	1	1	2	1	1	1	1	1	1	6	4

4	Joe	Current	6/9/2024	C	10	B	3	4-Jan-25	15-Mar-25	C	3	10-May-25	23-Aug-25	Joe	Joe			Joe			Joe			Joe									Joe			Joe			Joe			Joe			Joe			Joe																			A	0
5	Sam	Current	10/12/2015	D	10	F	6	1-Feb-25	17-May-25	D	2	24-May-25	23-Aug-25	Sam					Sam						Sam						Sam				Sam		Sam		Sam		Sam		Sam		Sam		Sam																				B	0
6	Betty	Current	2/7/2022	E	04	A	3	18-Jan-25	20-Sep-25	E	2	4-Oct-25	27-Dec-25	Betty			Betty			Betty			Betty			Betty			Betty			Betty			Betty			Betty			Betty			Betty			Betty			Betty				Betty		Betty		Betty		Betty		Betty		Betty		Betty	C	1
7	Tom	Former	10/13/2024	F	06	E	2	11-Jan-25	28-Jun-25	F	6	12-Jul-25	15-Nov-25	Tom		Tom		Tom		Tom		Tom		Tom		Tom		Tom		Tom		Tom		Tom		Tom		Tom		Tom		Tom						Tom						Tom						Tom							D	1
8																																																																			E	1
9																																																																			F	1
10
11
12
13
14
15
16
17
18
19
20
21
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