Schduling Employees - Fairly - Randomly

**nickmessick1** · 06-06-2013, 05:27 PM

I have an employee scheduling problem maybe someone has run into before. I've had good luck on this site.

Ok - Every month I have 4 spots to divide among 10 people. All 10 people want the spot and I have to track month by month who gets the spot - and who does not get the spot. I also have to keep track of people who cancel working when given a spot. The schedule needs to be fair and take into account who has not received a spot relative to the other workers. Ultimately this is for 200 people but I cut it down to get the basics on what to do.

Let me hear what you think. I was playing around with the RANDOM function for fairness.

equal_work_schedule.xlsx

**jroques** · 06-07-2013, 01:28 AM

This opinion is out of the Excel scope so if you want you can skip it

Anyway, if you decided to keep reading I think that you are making this issue to complex, the first time you schedule the 200+ employee do it random (take the list of employee, make a RAND() column, copy and paste as value if not I will continue changing every time the sheet recalculates, order ascending) assign the spot in that order, and as a company policy every new employee goes to the bottom of the list. Keep it en the way you show you table.

Good luck!

Javier

**nickmessick1** · 06-07-2013, 09:57 AM

Thanks for the response. I will try it your way. What do you think about keeping track of people who get the work day, but then do not take it?

**jroques** · 06-08-2013, 02:12 AM

Use the same table to control the schedule. Using an X for future schedule, an A for absentee people
and O for people who show up for work

See attached file.equal_work_schedule.xlsx