Randomly assign a list of tasks to a set of people. There are conditions for assignments.

New Contributor

 

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 <>FieldQuota
AdamM3
JohnM6
AmandineU+M4
CarolineM3
JosephU2
MariaU1
HannahM0
PaulU7
JasmineM5
CarolM2

 

 

What I expect:

 

TaskFieldPerson <>
Task#1MRandom name
Task#2MRandom name
Task#3MRandom name
Task#4MRandom name
Task#5URandom name
Task#6URandom name
Task#7MRandom name
Task#8URandom name
Task#9MRandom name
Task#10MRandom name
Task#11MRandom name
Task#12URandom name
Task#13MRandom name
Task#14MRandom name
Task#15MRandom name
Task#16URandom name
Task#17MRandom name
Task#18MRandom name
Task#19URandom name
Task#20URandom name

 

0 Replies