使用Excel的工作人员轮换委员会 [英] Crew members rotation board at work using excel

问题描述

在工作中，我们分配了一些必须要做的任务.我们有两个主要的班次，上午和下午. 在AM中，指派一名机组人员检查设备， 另一人被分配装满设备，第三个人被分配监视设备上的手表.

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.

PM指派了一名机组人员检查设备，第二名指派了值班人员监视设备.

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

每个班次约有5名机组人员.每周开放7天.

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

现在，我正在尝试使任务自动化，以使机组成员在工作5天之内不会被分配去完成一项任务.

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.

如果知道机组人员的数量，是否有办法使用excel做这样的事情?

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

推荐答案

尝试使用此方法，您将需要扩展助手，但是方法很明确...

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

这篇关于使用Excel的工作人员轮换委员会的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！