Page 1 of 1

Round Robin Sports Scheduling Algorithm. HELP!

Posted: Sat Aug 19, 2006 12:20 am
by ZeroFear
I have a database that is laid out like this:

http://img244.imageshack.us/img244/4674/dbri6.jpg


I have 17 teams entered into the teams table, divided into 2 conferences, with 2 divisions in each conference. A team plays 15 games a season. ( 15 weeks, 1 game a week ). With 17 teams there are 4 teams per divison, with one division having 5, so i will have to create a dummy team for BYES.

The user will enter in the following data:

1. The minimum amount of inter divison games.

2. The minimum amount of inter conference games.

3. The minimum amount of cross conference games.


anyone got some ideas on this? I have some of my own but I would like the opinion of others. thanks ;o

Re: Round Robin Sports Scheduling Algorithm. HELP!

Posted: Sat Aug 19, 2006 1:12 am
by RobertGonzalez
ZeroFear wrote:The user will enter in the following data:

1. The minimum amount of inter divison games.

2. The minimum amount of inter conference games.

3. The minimum amount of cross conference games.
How is this relative? I only ask so I have an understanding of what you want.

Posted: Sat Aug 19, 2006 1:58 pm
by ZeroFear
the inter divison games are the most important, since they are playing for #1 seed in there divison so they can go to playoffs. If people in a divison never play other people in there own divison, just people from other conferences and divisions, how does that make them the best team in there OWN divison. Thats why the user ( leauge manager ) can set the min number of times people play in there own divison, conference, and inter conference. I think i might do only a var that sets inter divison games.

Posted: Tue Aug 22, 2006 2:21 am
by grudgeuk
I have looked at your Database structure and read what you are trying to do, but I am still a little confused.

Am I right in thinking you are looking for an algorithm to calculate all the matches? :?