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!
