Saturday Work Schedule - 28 Advisors - 8 Shifts

[SVTF]

Hello Excel Guru’s

Looking for some help with creating a schedule for Saturdays

I have 28 team members
There are 8 shifts to randomize .

Shift # 1 – 10:00 – 5:00
Shift # 2 – 10:00 – 5:00
Shift # 3 – 11:00 – 6:00
Shift # 4 – 11:00 – 6:00
Shift # 5 – 11:00 – 6:00
Shift # 6 – 12:00 – 7:00
Shift # 7 – 12:00 – 7:00
Shift # 8 – 12:00 – 7:00



Each Team member needs to go through the schedule pattern and repeat when they get to the end as needed to finish out the 52 weeks.
However on each Saturday each of the 8 shifts need to be present.

Like to have
Distribute the 8 shifts evenly as possible over 28 Team Members for the 52 Saturdays

While trying to limit as much as possible
• Multiple Saturdays in the same month
• No back to back Saturday shift

Let me know if you have any questions

I have added a template to work with

Thanks in advance