Making a sports league schedule

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

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.
 
H

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top