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

sorting groups for a competition

B

bwright

New Member
Hi! I would like to know how to create a program that will sort 22 teams of 5 people each for 4 rounds of a game that does not allow anyone from their original

team of 5 to play each other and does not allow anyone to play against anyone else more than once. Hope this makes sense Any help would be appreciated.


bwright
 
Hi Wright ,


I think more details are required before anyone can proceed ; since 22 teams of 5 people each is an unwieldy number , let us start with 10 , so that we have 2 teams of 5 each.


If we assume that people A through E are in one team , and people F through J are in the second team , in the first round Team 1 ( consisting of people A through E ) plays Team 2 ( consisting of people F through J ).


What happens thereafter ? Can the teams be reorganized ? Otherwise , the words you have used in your post "....game that does not allow anyone from their original team of 5 to play each other ..." is not explainable.


Can you please clarify ?


Narayan
 
Hi Wright,


Not sure if this is the answer, but look at the attached link and all posts about the subject of sorting and pairing people


http://www.dailydoseofexcel.com/archives/2012/04/09/lunch-pairing-performance/


kanti
 
You must log in or register to reply here.
Back
Top