See also solution with formulas. It's composed of 4 groups of columns:
1) numbers to be assigned
2) sums assigned to given person in all previous steps (C3 and down/right):3) nomination formula - finding who shall get new assignment, because has lowest sum so far (in I3 and down): 4) number assigned to nominated person in given step (in k3 and down/right):
It shall be easier to understand if you start analyzing formulas for instance from row 4 (second number to be assigned).
To change number of people just delete/add columns in group 2 and 4 and check whether "nomination formula" covers all columns of group 2.
To change number of assigned numbers just add or delete rows with formulas. Note that group 2 has always 1 row more than other groups.
Bookmarks