ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJBKBLBMBNBOBPBQBRBSBTBUBVBW
1
12345678910111213141516171819202122232425262728
2
ROTATION SCHEDULE PLANNER
28 DAYS CYCLESETUP
3
4
1January 3, 2022 - January 30, 2022Start DateMonday, January 03, 2022
Select Pattern
1
5
3456789101112131415161718192021222324252627282930Work HoursNoDay
6
PEmployeeRoleMTWTFSSMTWTFSSMTWTFSSMTWTFSSTotalWAvEmployee Name
Hourly Rate
Paid DayPaid Period12345678910111213141516171819202122232425262728
7
1John Doe 1SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0 John Doe 1 20.0 MondayWeekly1DDSSNNNXXDDSSSNNXXDDDSSNNXXX
8
2John Doe 2SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0 John Doe 2 21.0 TuesdayWeekly2XXDDSSSNNXXDDDSSNNXXXDDSSNNN
9
3John Doe 3SecurityNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0 John Doe 3 22.0 WednesdayWeekly3NNXXDDDSSNNXXXDDSSNNNXXDDSSS
10
1John Doe 4SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0 John Doe 4 23.0 ThursdayWeekly
11
2John Doe 5SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0 John Doe 5 24.0 FridayWeekly
12
3John Doe 6SecurityNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0 John Doe 6 25.0 SaturdayWeekly
Code
StartEndHrs
13
1John Doe 7SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0 John Doe 7 26.0 SundayWeeklyD6:00 AM2:00 PM 8.0
14
2John Doe 8SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0 John Doe 8 27.0 MondayWeeklyN2:00 PM10:00 PM 8.0
15
3John Doe 9SecurityNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0 John Doe 9 28.0 TuesdayWeeklyS10:00 PM6:00 AM 8.0
16
1John Doe 10SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0 John Doe 10 29.0 WednesdayWeeklyXOFF
17
2John Doe 11SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0 John Doe 11 30.0 ThursdayWeekly
18
3John Doe 12SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0 John Doe 12 31.0 FridayWeekly
Pattern Table
19
1John Doe 13SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0 John Doe 13 32.0 SaturdayWeekly1Day
20
2John Doe 14SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0 John Doe 14 33.0 SundayWeekly12345678910111213141516171819202122232425262728
21
3John Doe 15SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0 John Doe 15 33.0 MondayWeekly1DDSSNNNXXDDSSSNNXXDDDSSNNXXX
22
1John Doe 16SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0 John Doe 16 33.0 TuesdayWeekly2XXDDSSSNNXXDDDSSNNXXXDDSSNNN
23
2John Doe 17SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0 John Doe 17 33.0 WednesdayWeekly3NNXXDDDSSNNXXXDDSSNNNXXDDSSS
24
3John Doe 18SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0 John Doe 18 33.0 ThursdayWeekly
25
1John Doe 19SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0 John Doe 19 33.0 FridayWeekly2Day
26
2John Doe 20SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0 John Doe 20 33.0 SaturdayWeekly12345678910111213141516171819202122232425262728
27
3John Doe 21SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0 John Doe 21 33.0 SundayWeekly1DDSSNNNXXDDSSSNNXXDDDSSNNXXX
28
1John Doe 22SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0 John Doe 22 33.0 MondayWeekly2XXDDSSSNNXXDDDSSNNXXXDDSSNNN
29
2John Doe 23SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0 John Doe 23 33.0 TuesdayWeekly3NNXXDDDSSNNXXXDDSSNNNXXDDSSS
30
3John Doe 24SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0 John Doe 24 33.0 WednesdayWeekly
31
1John Doe 25SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0 John Doe 25 33.0 ThursdayWeekly3Day
32
TOTAL EMPLOYEE /SHIFT
12345678910111213141516171819202122232425262728
33
D
06:00 AM - 02:00 PM
99888880099888880099988880001DDSSNNNXXDDSSSNNXXDDDSSNNXXX
34
N
02:00 PM - 10:00 PM
88009998888000998888800998882XXDDSSSNNXXDDDSSNNXXXDDSSNNN
35
S
10:00 PM - 06:00 AM
00998888800999888800099888883NNXXDDDSSNNXXXDDSSNNNXXDDSSS
36
37
2January 31, 2022 - February 27, 20224Day
38
31123456789101112131415161718192021222324252627Work Hours12345678910111213141516171819202122232425262728
39
PEmployeeRoleMTWTFSSMTWTFSSMTWTFSSMTWTFSSTotalWAv1
40
1John Doe 1SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0 2
41
2John Doe 2SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0 3
42
3John Doe 3SecurityNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
43
1John Doe 4SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
44
2John Doe 5SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
45
3John Doe 6SecurityNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
46
1John Doe 7SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
47
2John Doe 8SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
48
3John Doe 9SecurityNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
49
1John Doe 10SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
50
2John Doe 11SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
51
3John Doe 12SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
52
1John Doe 13SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
53
2John Doe 14SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
54
3John Doe 15SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
55
1John Doe 16SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
56
2John Doe 17SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
57
3John Doe 18SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
58
1John Doe 19SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
59
2John Doe 20SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
60
3John Doe 21SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
61
1John Doe 22SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
62
2John Doe 23SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
63
3John Doe 24SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
64
1John Doe 25SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
65
TOTAL EMPLOYEE /SHIFT
66
D
06:00 AM - 02:00 PM
9988888009988888009998888000
67
N
02:00 PM - 10:00 PM
8800999888800099888880099888
68
S
10:00 PM - 06:00 AM
0099888880099988880009988888
69
70
3February 28, 2022 - March 27, 2022
71
28123456789101112131415161718192021222324252627Work Hours
72
PEmployeeRoleMTWTFSSMTWTFSSMTWTFSSMTWTFSSTotalWAv
73
1John Doe 1SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
74
2John Doe 2SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
75
3John Doe 3SecurityNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
76
1John Doe 4SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
77
2John Doe 5SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
78
3John Doe 6SecurityNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
79
1John Doe 7SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
80
2John Doe 8SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
81
3John Doe 9SecurityNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
82
1John Doe 10SecurityDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
83
2John Doe 11SecurityXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
84
3John Doe 12SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
85
1John Doe 13SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
86
2John Doe 14SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
87
3John Doe 15SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
88
1John Doe 16SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
89
2John Doe 17SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
90
3John Doe 18SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
91
1John Doe 19SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
92
2John Doe 20SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
93
3John Doe 21SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
94
1John Doe 22SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
95
2John Doe 23SalesXXDDSSSNNXXDDDSSNNXXXDDSSNNN 168.0 42.0
96
3John Doe 24SalesNNXXDDDSSNNXXXDDSSNNNXXDDSSS 168.0 42.0
97
1John Doe 25SalesDDSSNNNXXDDSSSNNXXDDDSSNNXXX 168.0 42.0
98
TOTAL EMPLOYEE /SHIFT
99
D
06:00 AM - 02:00 PM
9988888009988888009998888000
100
N
02:00 PM - 10:00 PM
8800999888800099888880099888