Use Excel to automatically assign the person on duty

Copper Contributor
  • Is it possible, through Excel, to distribute a group of employees to rotate to perform a daily task in an automatic way, where one employee performs the task every day during working days, and they rotate on the same task during the weekend, with the exception of employees who are on other tasks or on vacation
2 Replies
This is essentially resource allocation, and it can be done.

To get started, we'd need a sample list of employees, shift hours, any applicable rates, shift preferences, etc.
Would this be the same as creating a rotation system to automate a list of odd numbers on a weekly basis. Assignment has to be in pairs every week. Thanks.