I need an excel spreadsheet that will create a schedule for sports leagues.
The inputs are:
Number of fields available to play.
Number of teams in league.
Number of Divisions.
Number of teams per division
Number of games each team plays in regular season.
Frequency of games. Number of games each team plays per week.
Days of week available to play(M,T,W,Th,F,Sa,Su).
Hours of day available to play( 1 hour per increments).
Number of weeks available to play.
Round Robin, every team play other teams (# of teams/# of games in reg season) times, remaining games randomly against rest of league
Additional Project Description:
01/11/2013 at 19:58 EST
The attached file generates a Round Robin schedule where each team plays every other team once.
The project I posted needs to be able to adjust so every team plays X number of games.