Copyright 2004 David A. Wheeler, Ph.D., ACMT NoStress@mail.com Last updated 03/12/04 09:16 AM
N= Number of teams
Number of Combinations of teams = N*(N-1)/2
# teams |
# combinations |
# of games necessary to have every team play three times | # of rooms necessary to play in three rounds. |
2 |
1 |
3 | 1 |
3 |
3 |
4.5 | 1 |
4 |
6 |
6 | 2 |
5 |
10 |
7.5 | 2 |
6 |
15 |
9 | 3 |
7 |
21 |
10.5 | 3 |
8 |
28 |
12 | 4 |
9 |
36 |
13.5 | 4 |
10 |
45 |
15 | 5 |
11 |
55 |
16.5 | 5 |
12 |
66 |
18 | 6 |
13 |
78 |
19.5 | 6 |
14 |
91 |
21 | 7 |
15 |
105 |
22.5 | 7 |
16 |
120 |
24 | 8 |
17 |
136 |
25.5 | 8 |
18 |
153 |
27 | 9 |
19 |
171 |
28.5 | 9 |
20' |
190 |
30 | 10 |
21 |
210 |
31.5 | 10 |
[When there is a odd number of teams, there will have to be one game which is three teams playing together.
Fourth round with just the three teams playing will need to be scheduled if there is an odd number of teams.]
"Preferred method of dealing with an odd number of teams in the HRGames is to have an extra round and each team take a by." -Chuck Salvetti, 2003
Lay out spreadsheet with these columns:
Random, Combination, Team A, Team B, Game
Fill in team A with 1, then team B with 2 to N; Team A with 2, Team B with 2 to N and so forth
Fill in Combinations with numbers from 1 to number of combinations.
Sort spreadsheet on random column
Make N by N table of the match ups.
Go down the Team A and B columns transferring the game number to the N by N table.
For example, match up 1 is team 1 vs team 2. Put a 1 in the N by N table where team 1 and team 2 intersect. (two intersections)
Skip matchups if one of the teams has a full slate of games.
Fill in game number column as you go
Sort on Game, team A, team B
Fill in rooms matrix. No team is in the same room twice.
Copy game matrix to new sheet
Convert to values.
Sort on room A/B random.
Select rows with A/B random
Transpose
Move top row below bottom row
Transpose again
Copy back into game matrix.
Randomize teams
Search and replace numbers with team names