If you follow the schedules link above and dial up a whist schedule for 16 players, then I have rearranged that to provide a full round-robin in 5 weeks:
(16 1 v 9 14) ( 3 10 v 12 13) ( 6 15 v 7 11)
(16 6 v 14 4) ( 8 15 v 2 3) (11 5 v 12 1)
(16 11 v 4 9) (13 5 v 7 8) ( 1 10 v 2 6)
( 2 4 v 5 8) ( 7 9 v 10 13) (12 14 v 15 3)
(16 2 v 10 15) ( 4 11 v 13 14) ( 7 1 v 8 12)
(16 7 v 15 5) ( 9 1 v 3 4) (12 6 v 13 2)
(16 12 v 5 10) (14 6 v 8 9) ( 2 11 v 3 7)
( 3 5 v 6 9) ( 8 10 v 11 14) (13 15 v 1 4)
(16 3 v 11 1) ( 5 12 v 14 15) ( 8 2 v 9 13)
(16 8 v 1 6) (10 2 v 4 5) (13 7 v 14 3)
(16 13 v 6 11) (15 7 v 9 10) ( 3 12 v 4 8)
( 4 6 v 7 10) ( 9 11 v 12 15) (14 1 v 2 5)
(16 4 v 12 2) ( 6 13 v 15 1) ( 9 3 v 10 14)
(16 9 v 2 7) (11 3 v 5 6) (14 8 v 15 4)
(16 14 v 7 12) ( 1 8 v 10 11) ( 4 13 v 5 9)
( 5 7 v 8 11) (10 12 v 13 1) (15 2 v 3 6)
(16 5 v 13 3) ( 7 14 v 1 2) (10 4 v 11 15)
(16 10 v 3 8) (12 4 v 6 7) (15 9 v 1 5)
(16 15 v 8 13) ( 2 9 v 11 12) ( 5 14 v 6 10)
( 6 8 v 9 12) (11 13 v 14 2) ( 1 3 v 4 7)
You can use this three times, each time making a different random assignment on the 16 players' names to the numbers 1 to 16. This gives you 15 weeks of scheduling. Perhaps have 'finals' in the last week were you match people up based on their scores in weeks 1 to 15.
I am using version 5.1 of your very useful spreadsheet for preparing schedules for a curling league and assigning ice sheets (i.e. courts) to games. To do this I generate a schedule in both Home/Away and Court/Field formats and copy these to my spreadsheet. This has worked well until today when I was generating a schedule for a 6 team round-robin league. My assumption has been up to this point that the actual game schedule would remain the same as I switched format. I guess I have been lucky until now, as that assumption has worked out. However today, it didn't work.
What I have found is that when switching formats the rounds are shuffled. For example for a 6 game round-robin (not randomized) I get the following:
Court/Field (CF) format
round court 1 court 2 court 3
1 (3 6) (1 2) (4 5)
2 (6 2) (5 3) (1 4)
3 (4 3) (2 5) (6 1)
4 (2 4) (3 1) (5 6)
5 (1 5) (6 4) (2 3)
Home Away (HA) format
team R1 R2 R3 R4 R5
1 2 3 4 5 6
2 1 4 6 3 5
3 6 1 5 2 4
4 5 2 1 6 3
5 4 6 3 1 2
6 3 5 2 4 1
So, in CF format round 1 is the same as HA round 1. However, CF format round 2 is actually HA round 3. Other rounds are also shuffled.
So, my questions:
1. Am I missing an option that makes the round assignments consistent between the formats?
2. Am I the first person to need the 2 formats to be consistent?
3. Is there a work-around?
4. Could a future version of the scheduler make the 2 formats consistent?
Tom Moore