Hello All,
I'm looking for the simplest approach/tool to solve a problem where trying to assign evenly. It seems the optimization tool may help but the examples I saw seemed to be different so if that was the best tool would need tips on how to setup. I've also been wondering about the tile tool or using iterative macro - or maybe a combination of.
1. Get a total of each of the cases (4 types) *Already Assigned* to each person
2. Get a total of new cases (4 types) *Unassigned*
3. Need to *Evenly assign* the 4 types (with a higher weighting on lower type if possible) so that each person has as equal as possible a total after assignment
For Example:
*Already Assigned*
Person A - Type 1 (5) - Type 3 (2)
Person B - Type 2 (2) - Type 4 (1)
Person C - Type 2 (4) - Type 3 (2) - Type (4)
*Unassigned*
CASE A - Type 1 (4) - Type (2)
CASE B - Type 2 (2) - Type 3 (5) - Type 4 (1)
CASE C - Type 3 (2) - Type 4 (5)
CASE D - Type 1 (2) - Type 4 (5)
Thanks so much in advance!
