I got this close using Evolutionary Solver, changing col C to minimize max - min:
Row\Col A B C D E F G H I 1 Wafer Qty Stack 1 2 3 4 2 0 0 0 0 3wf01 522 2 0 522 0 0D3: =D2 + (ROUND($C3, 0)=D$1)*$B3 4wf02 526 4 0 522 0 526 5wf03 542 2 0 1064 0 526 6wf04 530 3 0 1064 530 526 7wf05 579 1 579 1064 530 526 8wf06 529 4 579 1064 530 1055 9wf07 483 3 579 1064 1013 1055 10wf08 477 3 579 1064 1490 1055 11wf09 578 2 579 1642 1490 1055 12wf10 558 1 1137 1642 1490 1055 13wf11 522 3 1137 1642 2012 1055 14wf12 430 3 1137 1642 2442 1055 15wf13 571 4 1137 1642 2442 1626 16wf14 554 2 1137 2196 2442 1626 17wf15 504 2 1137 2700 2442 1626 18wf16 528 4 1137 2700 2442 2154 19wf17 579 2 1137 3279 2442 2154 20wf18 560 1 1697 3279 2442 2154 21wf19 478 3 1697 3279 2920 2154 22wf20 572 4 1697 3279 2920 2726 23wf21 522 4 1697 3279 2920 3248 24wf22 499 3 1697 3279 3419 3248 25wf23 565 1 2262 3279 3419 3248 26wf24 531 1 2793 3279 3419 3248 max-min 27wf25 557 1 3350 3279 3419 3248 171
Bookmarks