[Guest]

Here is the teaser:

On an excel spreadsheet, how do I lay out a card playing tournament with the following criteria?

1) There will be 8 teams

2) Two persons to each team

3) Each team must play all other teams, but cannot play the same team more than once.

Cheers!

[Guest]

I dont know what you wrote two players in each team for. But the games can be organised as shown below.

1 v/s 5

2 v/s 6

3 v/s 7

4 v/s 8

1 v/s 8

2 v/s 5

3 v/s 6

4 v/s 7

1 v/s 7

2 v/s 8

3 v/s 5

4 v/s 6

1 v/s 6

2 v/s 7

3 v/s 8

4 v/s 5

1 v/s 2

3 v/s 4

5 v/s 6

7 v/s 8

1 v/s 4

2 v/s 3

5 v/s 8

6 v/s 7

1 v/s 3

4 v/s 2

5 v/s 7

8 v/s 6

[Guest]

- A B C D E F G

H X X X X X X X

G X X X X X X

F X X X X X

E X X X X

D X X X

C X X

B X

[Guest]

See attached Excel file... not sure if this is what you were looking for.

Team_Tourny.xls

[Guest]

I forgot to add the one more criteria:

Each team will have 2 people on it, however, they cannot play with the same team member more than once throughout the tournament.

See attached Excel file... not sure if this is what you were looking for.

[Guest]

I forgot to add the one more criteria:

Each team will have 2 people on it, however, they cannot play with the same team member more than once throughout the tournament.

quote name='DeeGee' date='Jul 2 2009, 10:19 AM' post='184570']

I dont know what you wrote two players in each team for. But the games can be organised as shown below.

1 v/s 5

2 v/s 6

3 v/s 7

4 v/s 8

1 v/s 8

2 v/s 5

3 v/s 6

4 v/s 7

1 v/s 7

2 v/s 8

3 v/s 5

4 v/s 6

1 v/s 6

2 v/s 7

3 v/s 8

4 v/s 5

1 v/s 2

3 v/s 4

5 v/s 6

7 v/s 8

1 v/s 4

2 v/s 3

5 v/s 8

6 v/s 7

1 v/s 3

4 v/s 2

5 v/s 7

8 v/s 6

[Guest]

Cannot play with the same team member more than once throughout the tournament? What is that supposed to even mean?

Is this a real teaser, or do you need help setting up a tournament? j/k, but i'm still a lil confused on what the OP is and what type of 'solution' you're looking for

[Guest]

You might be thinking about something more like this.

cards.xls

[Guest]

I think someone is using the den to do their homework

[Guest]

Here you go--

See the Attachment...

Edited July 2, 2009 by Terminator

[Guest]

Just to clarify, because this is what the previous answers might be missing, do people switch teams every game, or do they stay with the same partner throughout the tournament?

[Guest]

Use the Round Play table to for team to team play, and use the Team Matrix table to see who is on each team for each round.

Enjoy!

Team_Tourny.xls

[Guest]

Use the Round Play table to for team to team play, and use the Team Matrix table to see who is on each team for each round.

Enjoy!

Sorry, I noticed in my haste that I posted too quickly and my table is not complete... but you should get the idea to complete rounds 9 through 15. I believe you would end up with 420 games played to complete the task. (hint: it will be easier to make a second team matrix table for rounds 9-15)