All articles with 'Constraints' Tag

Using Solver to Assign Items to Buckets

Published on May 11, 2011 in Excel Howtos, Huis, Learn Excel, Posts by Hui
Using Solver to Assign Items to Buckets

Ok, You’ve just finished the mother of all Spreadsheets. Not only does it solve your companies budget, it tracks production, reports variances, makes a mean cup of coffee and some say, “it May Even Solve World Peace ?”.
But the boss walks in and asks “I have a list of items which I need to distribute evenly into colored buckets”
I had never thought of that option, Maybe I can constrain my model and let it work it out for me ?
Solver I need your help !

Continue »