Custom - 28 Days Cycle Rotating Schedule Generator - Model 1 V3.5 - Samples

	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	AL	AM	AN	AO	AQ	AR	AT	AV
1				1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28
2	ROTATION SCHEDULE PLANNER																							28 DAYS CYCLE										SETUP
3

4	1	January 3, 2022 - January 30, 2022
5	1	January 3, 2022 - January 30, 2022		3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	Work Hours		Start Date		Monday, January 03, 2022		Shift Code List
6	P	Employee	Role	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	Total	WAv	Employee Name	Hourly Rate	Paid Day	Paid Period	Code	Start	End	Hrs
7	1	John Doe 1	Security	A	A	B	B	C	C	C	X	X	A	A	B	B	B	C	C	X	X	A	A	A	B	B	C	C	X	X	X	168.0	42.0	John Doe 1	20.0	Monday	Weekly	A	6:00 AM	2:00 PM	8.0
8	2	John Doe 2	Security	X	X	A	A	B	B	B	C	C	X	X	A	A	A	B	B	C	C	X	X	X	A	A	B	B	C	C	C	168.0	42.0	John Doe 2	21.0	Tuesday	Weekly	B	2:00 PM	10:00 PM	8.0
9	3	John Doe 3	Security	C	C	X	X	A	A	A	B	B	C	C	X	X	X	A	A	B	B	C	C	C	X	X	A	A	B	B	B	168.0	42.0	John Doe 3	22.0	Wednesday	Weekly	C	10:00 PM	6:00 AM	8.0
10	4	John Doe 4	Security	B	B	C	C	X	X	X	A	A	B	B	C	C	C	X	X	A	A	B	B	B	C	C	X	X	A	A	A	168.0	42.0	John Doe 4	23.0	Thursday	Weekly	D	12:00 AM	8:00 AM	8.0
11	5	John Doe 5	Security	D	D	E	E	F	F	F	X	X	D	D	E	E	E	F	F	X	X	D	D	D	E	E	F	F	X	X	X	168.0	42.0	John Doe 5	24.0	Friday	Weekly	E	8:00 AM	4:00 PM	8.0
12	6	John Doe 6	Security	G	G	G	G	G	X	X	G	G	G	G	G	X	X	H	H	H	H	H	X	X	H	H	H	H	H	X	X	240.0	60.0	John Doe 6	25.0	Saturday	Weekly	F	4:00 PM	12:00 AM	8.0
13	7	John Doe 7	Security	H	H	H	H	H	X	X	H	H	H	H	H	X	X	G	G	G	G	G	X	X	G	G	G	G	G	X	X	240.0	60.0	John Doe 7	26.0	Sunday	Weekly	G	12:00 AM	12:00 PM	12.0
14	8	John Doe 8	Security	I	I	J	J	C	C	C	X	X	I	I	J	J	J	C	C	X	X	I	I	I	J	J	C	C	X	X	X	175.0	43.8	John Doe 8	27.0	Monday	Weekly	H	12:00 PM	12:00 AM	12.0
15	9	John Doe 9	Security																													-	-	John Doe 9	28.0	Tuesday	Weekly	I	8:00 AM	5:00 PM	9.0
16	10	John Doe 10	Security																													-	-	John Doe 10	29.0	Wednesday	Weekly	J	8:30 AM	4:30 PM	8.0
17	11	John Doe 11	Security																													-	-	John Doe 11	30.0	Thursday	Weekly	X	OFF
18	12	John Doe 12	Sales																													-	-	John Doe 12	31.0	Friday	Weekly
19	13	John Doe 13	Sales																													-	-	John Doe 13	32.0	Saturday	Weekly
20	14	John Doe 14	Sales																													-	-	John Doe 14	33.0	Sunday	Weekly
21	15	John Doe 15	Sales																													-	-	John Doe 15	33.0	Monday	Weekly
22	16	John Doe 16	Sales																													-	-	John Doe 16	33.0	Tuesday	Weekly
23	17	John Doe 17	Sales																													-	-	John Doe 17	33.0	Wednesday	Weekly
24	18	John Doe 18	Sales																													-	-	John Doe 18	33.0	Thursday	Weekly
25	19	John Doe 19	Sales																													-	-	John Doe 19	33.0	Friday	Weekly
26	20	John Doe 20	Sales																													-	-	John Doe 20	33.0	Saturday	Weekly
27	21	John Doe 21	Sales																													-	-	John Doe 21	33.0	Sunday	Weekly
28	22	John Doe 22	Sales																													-	-	John Doe 22	33.0	Monday	Weekly
29	23	John Doe 23	Sales																													-	-	John Doe 23	33.0	Tuesday	Weekly
30	24	John Doe 24	Sales																													-	-	John Doe 24	33.0	Wednesday	Weekly
31	25	John Doe 25	Sales																													-	-	John Doe 25	33.0	Thursday	Weekly
32	TOTAL EMPLOYEE /SHIFT
33	A	06:00 AM - 02:00 PM		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
34	B	02:00 PM - 10:00 PM		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
35	C	10:00 PM - 06:00 AM		1	1	1	1	2	2	2	1	1	1	1	1	1	1	2	2	1	1	1	1	1	1	1	2	2	1	1	1
36	D	12:00 AM - 08:00 AM		1	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0
37	E	08:00 AM - 04:00 PM		0	0	1	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0
38	F	04:00 PM - 12:00 AM		0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	1	1	0	0	0
39	G	12:00 AM - 12:00 PM		1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0
40	H	12:00 PM - 12:00 AM		1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0
41	I	08:00 AM - 05:00 PM		1	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0
42	J	08:30 AM - 04:30 PM		0	0	1	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0
43
44	2	January 31, 2022 - February 27, 2022
45	2	January 31, 2022 - February 27, 2022		31	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	Work Hours
46	P	Employee	Role	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	Total	WAv
47	1	John Doe 1	Security	D	D	E	E	F	F	F	X	X	D	D	E	E	E	F	F	X	X	D	D	D	E	E	F	F	X	X	X	168.0	42.0
48	2	John Doe 2	Security	X	X	A	A	B	B	B	C	C	X	X	A	A	A	B	B	C	C	X	X	X	A	A	B	B	C	C	C	168.0	42.0
49	3	John Doe 3	Security	C	C	X	X	A	A	A	B	B	C	C	X	X	X	A	A	B	B	C	C	C	X	X	A	A	B	B	B	168.0	42.0
50	4	John Doe 4	Security	B	B	C	C	X	X	X	A	A	B	B	C	C	C	X	X	A	A	B	B	B	C	C	X	X	A	A	A	168.0	42.0
51	5	John Doe 5	Security	D	D	E	E	F	F	F	X	X	D	D	E	E	E	F	F	X	X	D	D	D	E	E	F	F	X	X	X	168.0	42.0
52	6	John Doe 6	Security	G	G	G	G	G	X	X	G	G	G	G	G	X	X	H	H	H	H	H	X	X	H	H	H	H	H	X	X	240.0	60.0
53	7	John Doe 7	Security	H	H	H	H	H	X	X	H	H	H	H	H	X	X	G	G	G	G	G	X	X	G	G	G	G	G	X	X	240.0	60.0
54	8	John Doe 8	Security	I	I	J	J	C	C	C	X	X	I	I	J	J	J	C	C	X	X	I	I	I	J	J	C	C	X	X	X	175.0	43.8
55	9	John Doe 9	Security																													-	-
56	10	John Doe 10	Security																													-	-
57	11	John Doe 11	Security																													-	-
58	12	John Doe 12	Sales																													-	-
59	13	John Doe 13	Sales																													-	-
60	14	John Doe 14	Sales																													-	-
61	15	John Doe 15	Sales																													-	-
62	16	John Doe 16	Sales																													-	-
63	17	John Doe 17	Sales																													-	-
64	18	John Doe 18	Sales																													-	-
65	19	John Doe 19	Sales																													-	-
66	20	John Doe 20	Sales																													-	-
67	21	John Doe 21	Sales																													-	-
68	22	John Doe 22	Sales																													-	-
69	23	John Doe 23	Sales																													-	-
70	24	John Doe 24	Sales																													-	-
71	25	John Doe 25	Sales																													-	-
72	TOTAL EMPLOYEE /SHIFT
73	A	06:00 AM - 02:00 PM		0	0	1	1	1	1	1	1	1	0	0	1	1	1	1	1	1	1	0	0	0	1	1	1	1	1	1	1
74	B	02:00 PM - 10:00 PM		1	1	0	0	1	1	1	1	1	1	1	0	0	0	1	1	1	1	1	1	1	0	0	1	1	1	1	1
75	C	10:00 PM - 06:00 AM		1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1	1
76	D	12:00 AM - 08:00 AM		2	2	0	0	0	0	0	0	0	2	2	0	0	0	0	0	0	0	2	2	2	0	0	0	0	0	0	0
77	E	08:00 AM - 04:00 PM		0	0	2	2	0	0	0	0	0	0	0	2	2	2	0	0	0	0	0	0	0	2	2	0	0	0	0	0
78	F	04:00 PM - 12:00 AM		0	0	0	0	2	2	2	0	0	0	0	0	0	0	2	2	0	0	0	0	0	0	0	2	2	0	0	0
79	G	12:00 AM - 12:00 PM		1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0
80	H	12:00 PM - 12:00 AM		1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0	1	1	1	1	1	0	0
81	I	08:00 AM - 05:00 PM		1	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0
82	J	08:30 AM - 04:30 PM		0	0	1	1	0	0	0	0	0	0	0	1	1	1	0	0	0	0	0	0	0	1	1	0	0	0	0	0
83
84	3	February 28, 2022 - March 27, 2022
85	3	February 28, 2022 - March 27, 2022		28	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	Work Hours
86	P	Employee	Role	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	M	T	W	T	F	S	S	Total	WAv
87	1	John Doe 1	Security	G	G	G	G	G	X	X	G	G	G	G	G	X	X	H	H	H	H	H	X	X	H	H	H	H	H	X	X	240.0	60.0
88	2	John Doe 2	Security	X	X	A	A	B	B	B	C	C	X	X	A	A	A	B	B	C	C	X	X	X	A	A	B	B	C	C	C	168.0	42.0
89	3	John Doe 3	Security	C	C	X	X	A	A	A	B	B	C	C	X	X	X	A	A	B	B	C	C	C	X	X	A	A	B	B	B	168.0	42.0
90	4	John Doe 4	Security	B	B	C	C	X	X	X	A	A	B	B	C	C	C	X	X	A	A	B	B	B	C	C	X	X	A	A	A	168.0	42.0
91	5	John Doe 5	Security	D	D	E	E	F	F	F	X	X	D	D	E	E	E	F	F	X	X	D	D	D	E	E	F	F	X	X	X	168.0	42.0
92	6	John Doe 6	Security	G	G	G	G	G	X	X	G	G	G	G	G	X	X	H	H	H	H	H	X	X	H	H	H	H	H	X	X	240.0	60.0
93	7	John Doe 7	Security	H	H	H	H	H	X	X	H	H	H	H	H	X	X	G	G	G	G	G	X	X	G	G	G	G	G	X	X	240.0	60.0
94	8	John Doe 8	Security	I	I	J	J	C	C	C	X	X	I	I	J	J	J	C	C	X	X	I	I	I	J	J	C	C	X	X	X	175.0	43.8
95	9	John Doe 9	Security																													-	-
96	10	John Doe 10	Security																													-	-
97	11	John Doe 11	Security																													-	-
98	12	John Doe 12	Sales																													-	-
99	13	John Doe 13	Sales																													-	-
100	14	John Doe 14	Sales																													-	-