Group Distribution based on Weightage/Score

Hello Everyone,

I have combed the internet to find a solution for this but I was unable to come up with something that addressing my requirements. They are as follows.

1. There is a master list of users which is not fixed and can increase or decrease.
2. Amongst that master list, there is a number of users who attend at a given time when groups are being created. They can be even or odd in number. I would add/remove users and the solution would accommodate it.
2. Each user has a certain weightage value associated to it (1 to 10 or decimal value like 2.1 and 2.4).
3. At the time of running the users in the list will be distributed in a certain number of groups (quantity of group based on input from users)
4. Each group should have as close to equal weightage distribution as possible.
5. All the user in the list should be accounted for. One group could at max have 1 additional person like 11/10, 9/8/8, 9/9/8.

I have attached an excel file that could visually describe what I want. This is what's happening in it.

1. There is a master list of users.
2. I remove the ones not in attendance and create a list which would be used to generate groups (there are 2 variations shown)
3. Groups are generated where the total score of each group is as close to equal as possible
4. Two use-case not mentioned are
a. Where the group has exactly equal score distribution.
b. Where the total number of groups is more than 2.

I have been able to find some websites that can do that like the following however, their weightage distribution is from 1 to 5 which is not enough to assess skill value since someone who is a 2.1 score would be equal to a 2.4 score rounded off.

www.keamk.com

This question is also posted on the following forums.

http://www.mrexcel.com/board/threads...groups.1211432
http://www.chandoo.org/forum/threads...9/#post-286619

Looking for assistance regarding this.

Any help in this would be greatly appreciated.

Thanks,
Hawajiko

I've made your cross-links into live urls...

OK. I fall at the first fence. I do not see how the values in G/H relate to those in B/C.

Please enlighten...

I think I understand - please confirm:

Columns A and B contain the names of the full membership and their scores.

Columns G and H contain two possible scenarios: one with an even number of attendees at a group meeing, and one with an odd number.

Columns P to S show expected results (i.e. even numbered teams with even score total, or thereabouts).

Is this correct?

Please share the solution here (nobody should have to follow a link to find it).

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.