The above advertisement is provided by Tripod.com and is not endorsed by Robert Morris College SHRM.

Method of Determining Matchups in Games When All Teams are not Able to Play All Other Teams

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