Randomly Assigning People to a Project

[devanstanton]

Hello, I have a list of people and a list of projects. Each project will need a certain number of people assigned to it and each person can take on a maximum number of projects.  Any ideas on how to accomplish this?  I will eventually have to add in dates - project dates and person availability to make sure the person's availability will align with the project.  I would love if anyone could share anything similar that they have done with project scheduling    

Dataset 1

PersonName          Load

Person1                   4

Person2                   3

Person3                   4

Person4                   5

Dataset2

Project Name        Number of Different People Needed

ProjectA                 1

ProjectB                 2

ProjectC                1

ProjectD                1

ProjectE                3

ProjectF                4 

Results I am looking for

Project Name   PersonName

ProjectA           Person1

ProjectB           Person4

ProjectB           Person2

ProjectC           Person3

ProjectD           Person2

ProjectE           Person3

ProjectE           Person1

ProjectE           Person4

ProjectF           Person1

ProjectF           Person2

ProjectF           Person4

ProjectF           Person3

Thanks in advance!

[Qiu]

@devanstanton 
Since you are saying random, I dont think there will be only one answer?

[devanstanton]

@Qiu Thank you so much! Do you know if there is a way to make sure the same person isn't assigned twice to one project? That is the part I'm struggling with figuring out.

[Qiu]

@devanstanton 

You abosutely have a point, sorry about that.

For small group, we can do something below, but technically, I believe an iterative macro should be in place.
Let me give a try about that later.

[devanstanton]

@Qiu I would appreciate that! Thank you so much for all your help.

[mceleavey]

@devanstanton ,

hang on, isn't this an exam question?

[Qiu]

@devanstanton 
Can you confirm if it is an exam question?

If yes, I am sorry we are not allowed to answer it.

[devanstanton]

@Qiu @mceleavey I have taken the advanced exam a few times and do not remember seeing this question. I’m trying to figure out how to schedule my auditors at work for different audits. I do not know if this appears on a different exam.

[NikyN]

similar question was on the Advanced Test -- but not the same.