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

[karavelioglu]

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