• 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.

divide values into 2 different groups as equally as possible

p.a.l.

New Member
I have a situation where I have some items each with different weights, (lets say 10 different items with 10 different weights). I need a way to divide those items into 2 boxes so that they are as balanced as possible between the 2 boxes. So lets say if i can get 5 items into one box, and 5 into another and they balance out almost equally, ok. but i also need it to determine if i only need 2 items in one box, and 8 in the other and they can still balance out somewhat.
 
p.a.l.
Seems that this has moved here ...
anyway, check this to sample how to balance those 'weights'.

1) Modify own 'weights' or press [RND] to get new 'weights'
2) Press [ Balance ] to 'balance' 'weights'
3) repeat #1 & #2 as needed
 

Attachments

  • xxx.xlsb
    39.7 KB · Views: 3
Back
Top