I have a small dataset approx 60. (lets just say they are work tasks)
I would like to randomly assign tasks to people, but i would also like assign an equal amount of tasks where possible.
so if i were to have 63 tasks
and 6 people (adam, ben, colm, derek, elvis, fiona)
I would expect/hope to assign tasks (adam 10, ben 11, colm 10, derek 10, elvis 11, fiona 11)
my efforts so far will random assign, however results are not fair because of small dataset.
results simular to thes are returned 4,7,15,10,11,13 (some people have 3 times as much work as others)
In (A) I use =RANDBETWEEN(1,6) and across the sheet I assigna number between 1 and 6 to all 6 people, Vlookup does the rest
Does anyone have any ideas on how to distribute tasks in a fair way.
I would like to randomly assign tasks to people, but i would also like assign an equal amount of tasks where possible.
so if i were to have 63 tasks
and 6 people (adam, ben, colm, derek, elvis, fiona)
I would expect/hope to assign tasks (adam 10, ben 11, colm 10, derek 10, elvis 11, fiona 11)
my efforts so far will random assign, however results are not fair because of small dataset.
results simular to thes are returned 4,7,15,10,11,13 (some people have 3 times as much work as others)
In (A) I use =RANDBETWEEN(1,6) and across the sheet I assigna number between 1 and 6 to all 6 people, Vlookup does the rest
Does anyone have any ideas on how to distribute tasks in a fair way.