Forum Discussion
Randomly assign a list of tasks to a set of people. There are conditions for assignments.
Hi!
I want to assign persons to tasks randomly, but I need to classify the task as U and M, and also persons has quota for that the maximum possible assignments to tasks. Persons have U or M or U+M classification too.
Why I need this?
I'm planning assessments. I have a list of assessors and a list of assessments that need to be planned. I don't want to do this planning manually every time. I want to do random assignments. However, our company has a quota application that allows us to appoint. i.e. The company says an assessor can go as much as e.g. 5 times per month.
(And after that, I want to add some other conditions to the formula)
Can you help me in this matter?
Here is the tables for visualization:
Data:
| Person <> | Field | Quota |
| Adam | M | 3 |
| John | M | 6 |
| Amandine | U+M | 4 |
| Caroline | M | 3 |
| Joseph | U | 2 |
| Maria | U | 1 |
| Hannah | M | 0 |
| Paul | U | 7 |
| Jasmine | M | 5 |
| Carol | M | 2 |
What I expect:
| Task | Field | Person <> |
| Task#1 | M | Random name |
| Task#2 | M | Random name |
| Task#3 | M | Random name |
| Task#4 | M | Random name |
| Task#5 | U | Random name |
| Task#6 | U | Random name |
| Task#7 | M | Random name |
| Task#8 | U | Random name |
| Task#9 | M | Random name |
| Task#10 | M | Random name |
| Task#11 | M | Random name |
| Task#12 | U | Random name |
| Task#13 | M | Random name |
| Task#14 | M | Random name |
| Task#15 | M | Random name |
| Task#16 | U | Random name |
| Task#17 | M | Random name |
| Task#18 | M | Random name |
| Task#19 | U | Random name |
| Task#20 | U | Random name |
No RepliesBe the first to reply