View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Howard Kaikow Howard Kaikow is offline
external usenet poster
 
Posts: 269
Default How do I set up a bowling schedule for an eight team league

"Oniram" wrote in message
...
If you have eight teams bowling, the first week you have Team 1 & 2 on

lanes
1 & 2 and so on for the eight teams. The next week they would change. I
want to know how to get the different combonations for thirtysix week
schedule.


With 8 teams, there are 28 possible pairings, so for 36 weeks, each team
will not be be matched with each other team the same number of times.

You could, say, divide the 8 teams into say 2 groups of 4 teams, for which
there are 6 possible pairings for each group. Spread this out over 3 * N
weeks, where N is the number of times you wish each team to meet within each
group.

Then take, say, the top 1 or 2 teams from each group and put tem in a
playoff group.

I hope the above is kerrect, I did this on the fly.