Making a sports league schedule

[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?

 

[cate]

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?

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.

 

[helene and gabor]

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