Fixture list for soccer/football league

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.