Round Robin with constraints (grouping)

[tiger8609]

Hi everyone,

I am trying to solve a problem, and I need your help! I have a group of 13 teams, with 5 or 6 members each. I would like to create a 1-on-1 round robin tournament, where one member from each team gets paired with one member from another team, but never with someone on their own team. For example, if you had 78 people, one person can only get matched with one of 72 people (he can't get matched with himself, or anyone else on his team).

Is this possible? If there is an excel spreadsheet that already does this, it would be great!

Thanks in advance for your help.

 

[cooper645]

How does this suit your needs?

https://www.dropbox.com/s/4fb9mu24daaiesg/round robin.xlsx?dl=0

 

[cooper645]

Just run two teams against each other in each round to keep it simple, rather than trying to mix. They will all play one another bar their own team in the end.

but there's a lot of rounds lol