I have an interesting challenge.
I have a list of people who do duty on a duty roster
they are categorised into the number of duties that they do in a month i.e. once, twice, three or four times a month
They are also categorised by weekly or weekend duties as well as by specific time limitations.
Does anyone have any smart ideas of a way to generate this duty roster automatically on a monthly basis by taking the above criteria into account. We are currently doing it in excel and it is tedious. I have attached an example.