Fixture list for soccer/football league

Fixture list for soccer/football league is project number 282068 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider xxxjmt)

Status:	Closed
Budget:	$30-250
Created:	07/02/2008 at 14:35 EDT
Bidding Ends:	07/09/2008 at 14:35 EDT
Project Creator:	chimp   Buyer Rating: (1 reviews)
Description:	I have a spreadsheet that generates games/matches/fixtures (call them what you like ) however i have a small problem where games at the same venues clash and games being played back to back. I am looking for someone to modify my code to account for the following: -------------- Every team in a division plays every other team twice (once as home team, once as away team). some teams share a home field, which may cause some confusion in the process. For each team, generate the home games and append to a list or array: Team 2 @ Team 1 (teams 1 and 2 play at team 1's home field) Team 3 @ Team 1 Team 1 @ Team 2 Team 3 @ Team 2 Team 1 @ Team 3 Team 2 @ Team 3 If you order the teams by home field before matching up, then the resulting list will be grouped by venue. For each venue, pick a random element and assign it to a random date from the list (this can be done by shuffling the list of dates and then assigning sequentially). Continue until all games for a particular venue are assigned different dates. Shuffle the list of dates again (otherwise you'll end up with teams playing each other twice in a row) and repeat for the next venue. Continue until you've assigned all matches. Additional files submitted: Fixtures generator.xls
Job Type:	Excel
Database:	(None)
Operating system:	MS Windows
Bid count:	14
Average bid:	$ 96