Crew members rotation board at work using excel

问题:

At work, we assigned some tasks that we have to do. We have two main shifts, the AM and the PM. In the AM, one crew member is assigned to check the equipment, another one is assigned filling up the equipment and the third one is assigned the watch over the equipment.

The PM one crew member is assigned to check the equipment, and the second one is assigned the watch over the equipment.

Each shift has about 5 crew members. Open 7 days a week.

Now, I am trying to automate the assignments so that crew members don't get assigned to do one task twice during their 5 days of work.

Is there a way of doing such a thing using excel if number of crew members is know?

回答1:

Try working from this, you will need to expand for assistants, but the method is clear...