Hey everybody,
I am trying to create an automatic shift scheduler which automatically assigns employees (operators) to work stations.
Background
I supervise this team but I don't have the time to make a schedule on a daily basis, so I need a quick command which auto-populates the schedule. However the station assignment needs to be based on specific conditions
There are three shifts:
1. Early shift works from (6am -14pm) and breaks 8am-8.30am, 12pm-12.35pm
2. Day shift works from (8am-16.30pm) and breaks 10am-10.30am, 12pm-12.35pm
3. Late shift works from (2pm-10pm) and breaks 18pm-18.35pm
Conditions
- Max 1 operator per station
- Operators are required to take their breaks
- however if production demands it may be planned earlier/later but never cancelled!
- Operators can be assigned to station after time (example new station after break)
- Depending on production requirements not all machines should be operational. E.g before auto-generation an option to select wheter all machines or a specific one needs to be manned
- if possible the generation could be based on operator proficiency. So E.g in normal production conditions a random generation is allowed. But in critical situation I would like to auto-assign the employees to the station they are most experienced in. I could create a employee-station table in which their experience can be ranked by score going from 1 (less experienced) to 3 (most experienced).
Question
I want to ask if something like this is possible and if so which would be the best method to approach this probem. Like which formulas or what kind or VBA-method would I have to use. I have little experience with VBA but I have a friend who has plenty of experience.
Thanks in advance
Kind regards.
Bookmarks