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?

On Mar 23, 4:01*pm, noylddot wrote:
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?

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





"noylddot" wrote in message
...
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?