Hi Guys,
not 100% best way to explain this, but i will provide sample data below
What we have setup is a 4 shift roster for the weekend, and people were able to nominate what shifts they wanted to do.
Saturday AM, Saturday PM, Sunday AM, Sunday PM
now these shifts do overlap, so no-one can work twice on the same day, and we want to avoid working them all weekend as then they are doing 12 days straight.
The next concern is having them working multiple weekends in a row (the smallest shift has 12 ppl interested, and only req 2 onsite, so max 6 week rotation)
please find attached the list with some random names...
any help would be greatly accepted
Currently what I have is sheet 1 with randbetween formula's and sheet 2 with the names in columns based on availability (a->d == Saturday AM, Saturday PM, Sunday AM, Sunday PM)
Bookmarks