Hi All,

I am trying to comeup with an automated excel table that can be used to create a carpark roster.

The carpark has 6 slots for whch I need to roster 9 staff on a weekly rotating basis. This needs to be done in an equitable manner. For example, at the end of a certain period of time, all staff memebers should have had equal chance and on the other hand we shouldnt have instance where a staff member goes two consecutive weeks without a car slot.

Can someone suggest how i can optimally use excel to acheve the same?

Many thanks
Naz