I need to make a work schedule in a where different people are assigned tasks on different days of the week.
I would like to get any ideas on a way I can make a VBA that automatically fills out the blank days on the schedule while meeting these rules.
- Only people that can preform the job are assigned to it.
- If possible, a person only does one job a day.
- If possible, a good rotation where you must do all the jobs you are assigned to.
- If possible, a good mix of jobs that require multiple people.
(example Task #1 requires 2 people on M/W/F and 1 on Tu/Th try to mix so you get an even number of chores on that task, not always stuck on M/W/F or Tu/Th)
- If possible, try to keep it even as possible in Area #2 & 3
(these are Common Areas, others are Group Areas)
Attached is the beginning spreadsheet. This is an idea of where I'm heading for the schedule to look like. But open to any and all ideas.
Feel free to suggest options to make it easier. I did start with an idea of a task that takes multiple people to have multiple cells (see Task Schedule Test tab).
I'm fine going back to that format if it makes it easier.
You'll notice I did add a simple conditional format that the employee can type their name and it highlights what days and tasks they are assigned to.
I will also add a count to each employee so I can see the split of work. That will be easy so I'm not concerned about that formula.
I'm not sure where to begin with this so I wanted to get some input and tips on where I should start or if anyone has encountered something similar to this already written which I can modify.
Can anyone help me?
Thank you in advance,
Steven
Bookmarks