Thread: League Fixtures
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DubboPete DubboPete is offline
external usenet poster
 
Posts: 30
Default League Fixtures

Hi all,

I have been racking my brains for the last three days trying to work a
logical sequence to setting up fixtures for a 19 week league
competition for 20 players.

Here's what I want to do:

20 players (numbered 1 thru 20 for ease of use) each play a game per
week, so there's 10 games per week. Each player only plays an
opponent once every 19 weeks. Each player obviously plays 19 games -
one player plays 19 opponents.

I just can't work out a formula to set the fixtures automatically
without any duplications. Can anyone help or point me in the right
direction?

cheers in anticipation

DubboPete