Round Robin Sports Scheduling Algorithm. HELP!
Posted: Sat Aug 19, 2006 12:20 am
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
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