Making a sports league schedule

  • Thread starter Thread starter noylddot
  • Start date Start date
N

noylddot

I have 8 teams that play each other twice. 14 games each. That is 56 games.
Each week each team plays once. There are two games on Wednesday night and
two games on Thursday night, four games a week. I want to make a schedule in
excel that has each team playing close to the same amount of games on
Wednesday and Thursday nights. Is there a way to input the teams and have
excel create the schedule?
 
I have 8 teams that  play each other twice. 14 games each. That is 56 games.
Each week each team plays once. There are two games on Wednesday night and
two games on Thursday night, four games a week. I want to make a schedulein
excel that has each team playing close to the same amount of games on
Wednesday and Thursday nights. Is there a way to input the teams and have
excel create the schedule?
Click to expand...

fyi - just a note. I think there are free canned sports schedulers
out there. Don't know if there worth anything to you but you might
what to hunt around.
 
2 6 7 8 Week 1.
1 5 3 4

5 7 3 6 Week 2.
2 4 1 8

4 6 2 7
5 8 1 3

2 8 6 7
3 5 1 4

1 5 6 7
2 3 4 8

3 7 2 8
4 5 1 6

4 6 1 2
3 8 5 7

3 5 1 7
6 8 2 4

1 2 5 6
7 8 3 4

1 7 4 8
5 6 2 3

1 4 3 7
2 6 5 8

1 3 4 7
2 5 6 8

3 8 2 7
4 5 1 6

4 7 1 8
3 6 2 5

best regards

Gabor Sebo
 
Back
Top