Hi, I just watched the solver video which gives a basic introduction on how to use it and I would like some advice is solver can perform in the following scenario
Here's a sample set of data for part 1.
[TABLE="class: grid, width: 569"]
<tbody>[TR]
[TD][/TD]
[TD]Staff[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Customers[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Workload[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Name[/TD]
[TD]Primary Support[/TD]
[TD] Backup[/TD]
[/TR]
[TR]
[TD]Bennie[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Ada[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Marchelle[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Awilda[/TD]
[TD]Marchelle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Gita[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Beula[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Albert[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Brenna[/TD]
[TD]Bennie[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cecil[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Delora[/TD]
[TD]Bennie[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Elisha[/TD]
[TD]Albert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Esta[/TD]
[TD]Marchelle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Janis[/TD]
[TD]Albert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Jann[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Julissa[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Kareem[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Lacy[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Maida[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Marta[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Nadene[/TD]
[TD]Bennie[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Nanci[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Precious[/TD]
[TD]Albert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Rebbeca[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Rene[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Roy[/TD]
[TD]Albert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sherie[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Soo[/TD]
[TD]Bennie[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Soraya[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Suzi[/TD]
[TD]Marchelle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Wilmer[/TD]
[TD]Bennie[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
And here is a sample set of data for the staffs choices as backup
[TABLE="class: grid, width: 645"]
<tbody>[TR]
[TD]Bennie[/TD]
[TD]Ada[/TD]
[TD]Elisha[/TD]
[TD]Janis[/TD]
[TD]Kareem[/TD]
[TD]Lacy[/TD]
[TD]Nanci[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Marchelle[/TD]
[TD]Beula[/TD]
[TD]Brenna[/TD]
[TD]Delora[/TD]
[TD]Julissa[/TD]
[TD]Maida[/TD]
[TD]Precious[/TD]
[TD]Rene[/TD]
[TD]Soo[/TD]
[TD]Suzi[/TD]
[/TR]
[TR]
[TD]Gita[/TD]
[TD]Ada[/TD]
[TD]Delora[/TD]
[TD]Esta[/TD]
[TD]Julissa[/TD]
[TD]Marta[/TD]
[TD]Nadene[/TD]
[TD]Roy[/TD]
[TD]Soo[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Albert[/TD]
[TD]Awilda[/TD]
[TD]Esta[/TD]
[TD]Jann[/TD]
[TD]Julissa[/TD]
[TD]Maida[/TD]
[TD]Nadene[/TD]
[TD]Rebbeca[/TD]
[TD]Sherie[/TD]
[TD]Wilmer[/TD]
[/TR]
[TR]
[TD]Cecil[/TD]
[TD]Beula[/TD]
[TD]Elisha[/TD]
[TD]Esta[/TD]
[TD]Lacy[/TD]
[TD]Nadene[/TD]
[TD]Precious[/TD]
[TD]Rene[/TD]
[TD]Soraya[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
As you can see each staff member has picked, at least, or more than, their current workload figures. I now need to distribute each staff member as the backup making sure that they do not conflict with the primary support and everyone gets a single backup.
I hope I have explained the question correctly and please feel free to give me some pointers on how I can achieve this.
- Each year 25 customers are distributed between the 5 staff members based on a workload ability
- Next the staff pick and equal or greater number of customers who they feel their skill set will help as a backup, As there are a greater number of Backup choices there will be some overlap.
- Finally the staff are allocated their backup customers ensuring they meet at least their workload ability quota,
Here's a sample set of data for part 1.
[TABLE="class: grid, width: 569"]
<tbody>[TR]
[TD][/TD]
[TD]Staff[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Customers[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]Workload[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Name[/TD]
[TD]Primary Support[/TD]
[TD] Backup[/TD]
[/TR]
[TR]
[TD]Bennie[/TD]
[TD="align: right"]5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Ada[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Marchelle[/TD]
[TD="align: right"]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Awilda[/TD]
[TD]Marchelle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Gita[/TD]
[TD="align: right"]7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Beula[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Albert[/TD]
[TD="align: right"]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Brenna[/TD]
[TD]Bennie[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cecil[/TD]
[TD="align: right"]6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Delora[/TD]
[TD]Bennie[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Elisha[/TD]
[TD]Albert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Esta[/TD]
[TD]Marchelle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Janis[/TD]
[TD]Albert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Jann[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Julissa[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Kareem[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Lacy[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Maida[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Marta[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Nadene[/TD]
[TD]Bennie[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Nanci[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Precious[/TD]
[TD]Albert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Rebbeca[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Rene[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Roy[/TD]
[TD]Albert[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Sherie[/TD]
[TD]Cecil[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Soo[/TD]
[TD]Bennie[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Soraya[/TD]
[TD]Gita[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Suzi[/TD]
[TD]Marchelle[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Wilmer[/TD]
[TD]Bennie[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
And here is a sample set of data for the staffs choices as backup
[TABLE="class: grid, width: 645"]
<tbody>[TR]
[TD]Bennie[/TD]
[TD]Ada[/TD]
[TD]Elisha[/TD]
[TD]Janis[/TD]
[TD]Kareem[/TD]
[TD]Lacy[/TD]
[TD]Nanci[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Marchelle[/TD]
[TD]Beula[/TD]
[TD]Brenna[/TD]
[TD]Delora[/TD]
[TD]Julissa[/TD]
[TD]Maida[/TD]
[TD]Precious[/TD]
[TD]Rene[/TD]
[TD]Soo[/TD]
[TD]Suzi[/TD]
[/TR]
[TR]
[TD]Gita[/TD]
[TD]Ada[/TD]
[TD]Delora[/TD]
[TD]Esta[/TD]
[TD]Julissa[/TD]
[TD]Marta[/TD]
[TD]Nadene[/TD]
[TD]Roy[/TD]
[TD]Soo[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Albert[/TD]
[TD]Awilda[/TD]
[TD]Esta[/TD]
[TD]Jann[/TD]
[TD]Julissa[/TD]
[TD]Maida[/TD]
[TD]Nadene[/TD]
[TD]Rebbeca[/TD]
[TD]Sherie[/TD]
[TD]Wilmer[/TD]
[/TR]
[TR]
[TD]Cecil[/TD]
[TD]Beula[/TD]
[TD]Elisha[/TD]
[TD]Esta[/TD]
[TD]Lacy[/TD]
[TD]Nadene[/TD]
[TD]Precious[/TD]
[TD]Rene[/TD]
[TD]Soraya[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
As you can see each staff member has picked, at least, or more than, their current workload figures. I now need to distribute each staff member as the backup making sure that they do not conflict with the primary support and everyone gets a single backup.
I hope I have explained the question correctly and please feel free to give me some pointers on how I can achieve this.