PDA

View Full Version : Roster Automation



Adrian11
07-14-2020, 09:04 PM
Hi,

I have just recently taken on the role of rostering for 250 staff in my department. Currently we are using an excel spreadsheet that uses countIF formulas to total up the number of people on a shift. There has to be an easier way to schedule staff.

I am after some guidance as to if there might be a way to automate the roster generation.

We have 3 different levels of staff - managers, senior staff and junior staff that all need to make up a proportion of each shift. There are 2 shifts per day with different numbers of staff on each shift. Staff work a different number of days per 2 weeks. From 2-9 days per fortnight roster cycle. The only requirement for days off is that staff have at least 2 days off in a row and they don't have only 1 day on at a time ... so a minimum of 2 days on.

I'm not sure if this is actually even something that can be done.