Unique Tournament Schedule

Hello,

I am trying to develop a tournament schedule with the following attributes:

• 14 teams
• 7 events (each event is a unique location)
• Each team plays each event exactly 1 time
• A team can't haven't the same opponent more than once

Can someone please help me develop a schedule that works for these parameters? Thanks! (see attached file)

Not a round robin, because in this tournament each team plays in each event only once. They do not play every other team.

I've attached a manual solution to the problem.

To achieve this, I took the teams from the left side of Round 1 and copied them into the left side of Round2, but shifted down by 1 event (Team 13 thus "wraps" into event 1). The teams on the right hand side of Round1 get copied into the right hand side of Round2, but moved down by 2 events (and thus Teams 12 and 14 appear at the top in this round. The same procedure is used for all the other rounds, i.e. the left-hand teams are moved down by 1 event and the right-hand teams are moved down by 2 events (it works because you have an odd number of events).

I feel that I should be able to put a formula in D3 and E3 based on an INDEX of B and C respectively, but which moves the indexed cell by 1 and 2 respectively, wrapping to bring 7 and 6/7 to the top, and then those two columns can be copied across, but as it's getting late here I can't concentrate - perhaps someone else will chip with a solution to this algorithm in while I get some sleep.

Hope this helps.

Pete

Sorry,

I couldn't attach the file to the last post - will try again ...

... seems to have worked this time.

Pete

Here's the file with formulae in it. I used this formula in D3:

=INDEX(B$3:B$9,CHOOSE(ROWS($1:1),7,1,2,3,4,5,6))

and this one in E3:

=INDEX(C$3:C$9,CHOOSE(ROWS($1:1),6,7,1,2,3,4,5))

These were copied down to row 9, and then the block of cells D3:E9 were copied into the other blocks/rounds, and then I re-instated the border at the bottom.

Hope this helps.

Pete

Thank you so much Pete. Good to go!