• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Restrictions of Solver

Hi All

I need help with a problem that I'm having. I have say 148 unique numbers that need to be allocated into 7 buckets where the sum of the numbers in each bucket is predefined. I've seen an example on this site using solver to split the 8 unique numbers into 2 buckets but when I've followed the logic in the example for my problem, I realise that solver has restrictions on the number of constraints (max 100 constraints) and changing values(max 200 changing values). The link to the example that I followed can be found below. I' ve adjusted the final target cell to be a sum of a single bucket rather than a difference that the example shows. Can someone please assist me with this problem. Thanks

http://chandoo.org/wp/2011/05/11/using-solver-to-assign-item/#comment-856721
 
Back
Top