B
Brian Clarke
There are 5 staff members who want to park their cars at the office, but
only 3 parking spaces. So the spaces need to be allocated by rotation.
I looked at the past rotas, and they don't seem to have been fair. It
would be good to do the allocation automatically, perhaps in Excel. If
we use cols D-F for the parking spaces and a row for each week, is there
a general method which will quickly fill in the rota?
I know that this is a relatively trivial task to do manually, but it's a
type of problem I haven't come across before, and it's interesting. I
suspect the MOD function might be useful here, but I can't put the thing
together.
only 3 parking spaces. So the spaces need to be allocated by rotation.
I looked at the past rotas, and they don't seem to have been fair. It
would be good to do the allocation automatically, perhaps in Excel. If
we use cols D-F for the parking spaces and a row for each week, is there
a general method which will quickly fill in the rota?
I know that this is a relatively trivial task to do manually, but it's a
type of problem I haven't come across before, and it's interesting. I
suspect the MOD function might be useful here, but I can't put the thing
together.