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