Round Robin Tournament Scheduling

Schedules - You must register to Post and Download => Requests => Topic started by: GoldenOldie on April 30, 2022, 03:25:20 PM

Title: Am I asking for the impossible?
Post by: GoldenOldie on April 30, 2022, 03:25:20 PM
Hi all. I'm looking for a schedule that will cover a maximum of 4 courts for random doubles pairings and catering for 8 to 20 players. 

When there is an odd number of players or more than 16,  some will have to sit out no more than one round.

Each player must play a maximum of 4 matches, ideally with a different partner and against a different pairing, so ideally no duplicate match ups. Am I asking for the impossible or could this be done?
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on May 01, 2022, 06:26:34 AM
This is more complex than I first thought - since you commented on the thread for the Excel generator I had assumed you were interested in singles play - but doubles play and 4 courts is a much harder problem.

I think your ideal of no duplicate matchups, either as partners or opponents, will only be achieveable if there are 16 or more players.  When this is true you only need to schedule which 4 players to send to a court as they can split into 2 vs 2 any way they like.  Below I have given example schedules for 16 to 18 players, something similar for 19 or 20 players should be possible and I will continue looking, however I don't believe you will find anything useful for less than 16 players.  For example if there are 12 players, then at 1st sight you might think it possible to have everyone matched up with everyone else at least once over 4 rounds on 3 courts, however this is impossible to achieve.

16 players (all players have 4 games each)
      court 1      court 2      court 3      court 4
R1 (16  4  6  7) ( 1  2  3  5) ( 8 12 14 15) ( 9 10 11 13)
R2 (14 11  5  7) ( 8  9  2  4) ( 6  3 13 15) (16  1 10 12)
R3 (13  2 12  7) (14 16  9  3) ( 5 10  4 15) ( 6  8  1 11)
R4 (11 16  2 15) (12  5  6  9) ( 3  8 10  7) ( 4 13 14  1)

17 players (1-13 have 4 games each, 14-17 have 3 games each)

(2 9 7 12) (1 11 14 3) (6 4 5 10) (17 13 8 16)
(13 11 9 10) (4 8 7 3) (17 6 14 2) (12 15 1 5)
(11 4 15 2) (16 12 10 3) (8 5 14 9) (7 1 13 6)
(15 7 17 10) (2 5 3 13) (1 9 4 16) (6 12 11 8)

18 players (1-10 have 4 games each, 11-18 have 3 games each)

(5 15 9 4) (10 3 8 14) (6 17 16 2) (1 13 18 7)
(15 12 6 8) (17 4 3 7) (2 9 11 13) (1 16 10 5)
(5 7 14 2) (8 17 9 1) (6 10 4 11) (16 18 12 3)
(6 13 5 3) (8 2 18 4) (12 9 7 10) (15 14 1 11)
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on May 01, 2022, 06:54:09 AM
Here are some similar schedules for 19 and 20 players hope that helps:

19 players (players 1,2,3,8,12,13,14 have 4 games, the rest have 3 games)
(13 2 8 10) (12 9 18 7) (4 16 14 1) (15 19 3 17)
(8 3 4 11) (2 1 5 7) (13 15 16 12) (6 19 14 9)
(10 9 11 1) (13 17 5 4) (12 3 14 2) (8 15 6 18)
(17 14 7 8) (10 12 5 19) (18 11 16 2) (3 6 13 1)

20 players (players 6,7,12,15 have 4 games, the rest have 3 games)
(8 16 3 7) (15 14 11 20) (17 10 4 12) (1 6 2 5)
(18 10 6 16) (5 7 13 20) (19 14 12 2) (9 15 3 4)
(2 18 17 7) (12 8 9 20) (15 19 16 1) (11 6 4 13)
(13 12 3 1) (8 5 18 15) (17 14 9 6) (19 10 7 11)
Title: Re: Am I asking for the impossible?
Post by: canadave on June 04, 2022, 07:35:16 PM
Sorry to piggyback on this thread, but I'm looking for something similar and am at my wits' end, so hoping maybe you can help Ian :)

I'm looking to generate round robin schedules for doubles pickleball, involving from 8 to 40 players, over ideally 7 rounds (but 6 would be fine too). So 32 schedules in all, each one involving a different number of players (from 8 to 40).

My request is similar to GoldenOldie's but not the same, in that I'm looking to *spread around as much as possible* the people on a court. In other words, it would be fine for Player 16 to play on the same court as Player 23 twice or more...as long as it's not a situation where, for example, Player 16 plays on the same court as Player 23 four times, but yet never plays on the same court as Player 5 at all. Ideally everyone should play with as many other people as possible. Currently, with the flawed round robin sheets we use, a player will come off the courts and say "wow, I played on the same court as Bob three times tonight, but never got to play with Jim at all!"

Ideally, too, no player would be "top" more than "bottom" or vice versa. In pickleball, the "top" pairing on a court always starts with the serve, so if our round robin is, for example, six rounds, and Player 1 winds up on "top" for five of those rounds, while Player 2 is on "top" for only one round, that's not fair. "Top" means the first two numbers in the pairing on the court; so, if "1 and 2 play against 3 and 4", then 1 and 2 are on top (and thus start with the serve), and 3 and 4 are on the bottom. So in other words, let's say there's 7 rounds; ideally, in that scenario, players should either be on top four times and bottom three times, or on top three times and on bottom four times. No one should be on top, say, five or more times.

Is THAT doable? :)
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on June 06, 2022, 12:49:17 PM
Just like the original question in this thread, the more players you have the easier the problem becomes.  And clearly multiples of 4 players are desireable, as having no byes means a further simplification. There are issues that make 7 rounds and 20 players difficult, so I believe the first scenario where it is posisble to have a reasonably nice schedule is for 24 players.  For example I have created the following for 7 rounds (rows) with 6 courts (columns) :

( 4  7  6 24) (11 21  1  2) ( 3 13 17 18) (22 23 16 20) ( 8 12 14 15) (19  5  9 10)
(20  6  9 11) ( 4 14 17 19) ( 7 18  5  8) (10 21 23 24) (15 16  2 13) ( 1  3 12 22)
(22 24 11 18) ( 6  2  8 19) (14 16  3 10) (13 23  1  4) ( 9 12 21  7) (17 20  5 15)
( 2 20  7  3) ( 4 10 11 15) ( 1  5 14 24) ( 9 13 22  8) (17 21  6 16) (19 23 12 18)
(23  2  9 14) (15 18  1  6) ( 8  4  3 21) (17 22  7 10) (13 19 20 24) (12 16  5 11)
( 1  7 16 19) (24  3  9 15) (14 18 20 21) ( 8 11 17 23) ( 2  5  4 22) ( 6 10 12 13)
(17 24  2 12) ( 3  6  5 23) (15 19 21 22) ( 7 11 13 14) ( 1  8 10 20) ( 9 16 18  4)

above if a game is shown as (A B C D), then play the pair AB vs CD, where AB is the top pair and CD is the bottom pair.  If you do this then I think that no two players are on court together more than once, and the top/bottom 3 or 4 times criteria is also met.  I guess I could find something similar for 28,32,36 & 40  players, but it would be too much work to consider the others numbers of players.
Title: Re: Am I asking for the impossible?
Post by: canadave on June 06, 2022, 07:03:50 PM
Thanks very much for taking the time to do that, Ian--much appreciated :)

I guess the issue is, although it would definitely be preferable if people showed up in multiples of 4, oftentimes they don't ;)  Would it help the problem if I said the arrangement/distribution of players doesn't have to necessarily be "perfect", but rather it just needs to be "as good as possible"?

In other words, everyone doesn't necessarily need to play with everyone else, there doesn't need to be a precisely perfect distribution of players on top/bottom evenly, byes in the case of numbers of players that are not divisible by 4 are okay, etc. We're just looking for an arrangement that is "better than it currently is"--we currently have situations where some people play on the same court as someone else three times in seven rounds, but never plays with many other players at all. I'm not sure how the round robin sheets we're currently using got generated, but I have to believe there's a way to improve upon them even if it's not perfect distribution in all respects :0
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on June 08, 2022, 02:50:03 AM
"As good as possible" assumes that there is some criterion by which it is possible to measure how good the schedule is - but there are a lot of competing factors here - the number of times pairs of players partner, oppose, or play on the same court together, the number of games and byes each player has, and finally the balance for top/bottom.  These could all be weighted differently, so there is no single best criterion, but the approach you need would be to consider these factors carefully and design a search algorithm to look for an optimal schedule.  Unfortunately, I don't have software that can help here.

I am guessing some of the schedules you have for 4n players, or 4n+1 players, may have been cut down from Whist schedules (https://www.devenezia.com/downloads/round-robin/rounds.php?it=12&v=w1). If you select any 7 rounds from one of these, this might well leave one pair together three times, while another pair never meets.

If you post the schedule that you have for 14 players, then I will have a look at it, and see if there is any improvement that I can offer.
Title: Re: Am I asking for the impossible?
Post by: canadave on June 13, 2022, 04:11:18 PM
"As good as possible" assumes that there is some criterion by which it is possible to measure how good the schedule is - but there are a lot of competing factors here - the number of times pairs of players partner, oppose, or play on the same court together, the number of games and byes each player has, and finally the balance for top/bottom.  These could all be weighted differently, so there is no single best criterion, but the approach you need would be to consider these factors carefully and design a search algorithm to look for an optimal schedule.  Unfortunately, I don't have software that can help here.

I am guessing some of the schedules you have for 4n players, or 4n+1 players, may have been cut down from Whist schedules (https://www.devenezia.com/downloads/round-robin/rounds.php?it=12&v=w1). If you select any 7 rounds from one of these, this might well leave one pair together three times, while another pair never meets.

If you post the schedule that you have for 14 players, then I will have a look at it, and see if there is any improvement that I can offer.
Hi Ian, sorry for the delay in getting back to you.

An example of what I'm talking about is here on these pickleball round robin sheets: RR-Charts.pdf (bendpickleballclub.com) (https://bendpickleballclub.com/wp-content/uploads/2021/03/RR-Charts.pdf) I'm guessing they just used one of the many free round robin generators to generate the schedules for various numbers of players.

If you look at the 14-player sheet, you'll see (for instance) that Player 2 is on the same court as some players once, some players twice, and even plays on the same court as Player 12 THREE times....but never plays on the same court as Player 5.

I guess what I'm not understanding is that this seems to me to be simple from a computational perspective (although I freely admit that since what I'm looking for doesn't seem to currently exist, there' may very well be some factor of difficulty that I'm overlooking). It seems to me that the scheduler should just do this:


I know I mentioned other criteria (dividing up who's on top/bottom equally, etc), but even if we could do this minimum thing (have players on the same court as all the other players as equally as possible), that would be an improvement.
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on June 14, 2022, 12:32:05 PM
I had a look at 14 and 12 player sheets in the document that you linked to and I can improve on both of them. Just to be clear I am ignoring top/bottom as suggested.  The new 14 player schedule is optimal, and the 12 player one must be close to being optimal.

For 14 players the 7 round schedule below has all partners different, all opponents different, and all pairs of player on court together either once or twice. Each player has one bye shown in the final column.

  ( 9 3 v 5 2) ( 8 1 v 10 11) (4 13 v 12 7)  (14 6)
  (10 4 v 6 3) ( 9 2 v 11 12) (5 14 v 13 1)  ( 8 7)
  (11 5 v 7 4) (10 3 v 12 13) (6  8 v 14 2)  ( 9 1)
  (12 6 v 1 5) (11 4 v 13 14) (7  9 v  8 3)  (10 2)
  (13 7 v 2 6) (12 5 v 14  8) (1 10 v  9 4)  (11 3)
  (14 1 v 3 7) (13 6 v  8  9) (2 11 v 10 5)  (12 4)
  ( 8 2 v 4 1) (14 7 v  9 10) (3 12 v 11 6)  (13 5)


For 12 players the schedule below has all partners different, all opponents occur once or twice, most pairs of players are on court together either once or twice, however the pairs (7,12), (8,10) and (9,11) occur 3 times.

  (10 2 v 7 8) ( 3 12 v 6 1) (4  9 v 5 11)
  (11 3 v 8 9) ( 1 10 v 4 2) (5  7 v 6 12)
  (12 1 v 9 7) ( 2 11 v 5 3) (6  8 v 4 10)
  ( 6 9 v 2 8) (10  5 v 1 3) (4 11 v 7 12)
  ( 4 7 v 3 9) (11  6 v 2 1) (5 12 v 8 10)
  ( 5 8 v 1 7) (12  4 v 3 2) (6 10 v 9 11)


Regarding the algorithm you have suggested above, I worry it would 'get stuck' before the schedule had filled up, as you would soon find a game where any player that was added would create a problem.  I have had better success with algorithms that start from a randomly generated schedule, and then make iterative improvements by swapping one player for another within a round.
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on June 15, 2022, 03:29:23 AM
I can improve on the 6 round 16 player schedule too, the old version has 13 pairs of players who are never on court together, and one pair (5,16) who meet three times.  In the schedule below all partners are different, all opponents are different, and all pairs of players are on court together either once or twice.

  ( 9 13 v 10 15) (3  7 v 12  1) (14  2 v  4 5) (8 11 v  6 16)
  ( 7 14 v 11 13) (1  8 v 10  2) (15  3 v  5 6) (9 12 v  4 16)
  ( 8 15 v 12 14) (2  9 v 11  3) (13  1 v  6 4) (7 10 v  5 16)
  (10 13 v 12  3) (9 15 v  1  7) ( 6 14 v 16 2) (8  5 v 11  4)
  (11 14 v 10  1) (7 13 v  2  8) ( 4 15 v 16 3) (9  6 v 12  5)
  (12 15 v 11  2) (8 14 v  3  9) ( 5 13 v 16 1) (7  4 v 10  6)


Title: Re: Am I asking for the impossible?
Post by: canadave on June 15, 2022, 08:59:21 PM
Thanks very much for these improvements :) Very much appreciated. Is there any programmatic way to try to improve the other sheets?
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on June 16, 2022, 03:55:53 AM
I have been picking off the easy ones above, as they are accessible to a cyclic solution where a small number of base rounds need to be found.  For example the 16 player schedule above is defined by rounds 1 and 4 only, the other rounds are derived by simple permutations.  This does not work all the time, specially for the less symmetric schedules with empty courts.

I have outlined some of the features of a general solution above, it would need to count the frequency of the three types of player pairs, and the frequency of the byes.  Then look for a small change to the schedule that makes the sum of the squares of the frequencies smaller.  You could program this from scratch, or you might be able to set this up in a constraint programming (https://en.wikipedia.org/wiki/Constraint_programming) package.
Title: Re: Am I asking for the impossible?
Post by: raydog on October 10, 2022, 04:35:18 PM
I am in charge of scheduling for a euchre tournament held by a group of fraternity alums each year, where I have dealt with exactly this problem. My constraints are that we have a variable number of people participating each year, and for our initial seeding round I'd like to have as much "mixing" as possible, so (if possible):
1) everyone plays at a table at least once with every other player (either as partner or opponent);
2) if multiple meetings are required, then we don't have pairs which sit together twice while another pair never meets (or one pair meets each other 3 times while another pair hasn't yet met 2 times);
3) no two players are partners twice.

We also have a time constraint, so play exactly 8 rounds (no more, no less).

I have devised schedules for 15 to 36 players using these constraints, and found many of them by using a computer program (rather poorly designed, as I am not a great programmer) running billions of combinations and trying to find the best one. I let some scenarios run for literally weeks! Truly brute force, but it did produce results.

In the end, I was not able to optimize every scenario, but I think I found some pretty reasonable solutions. I was able to avoid any players ever meeting 3 times, but I wasn't always able to have every possible pair of players meet. I calculated the "ideal" situation by comparing the number of actual parings in the tournament (#tables X # rounds) to the number of different possible pairings = n(n-1)/2, where n is the number of players. I presume this ideal is not always achievable, but it gave me a target to shoot for.

I found ideal solutions for 16, 17, 20 and 27+ players.

For the rest, I found the following:
players       never meet (ideal)   never meet (my solution)
    18                     0                                5 
    19                     0                                12
    21                     0                                7
    22                     0                                19
    23                     13                              27
    24                     0                                8
    25                     12                              26
    26                     37                              52

in the case of 15 players, I think I am still far from optimal: I have 18 pairs never meeting and 6 pairs meeting 3 times! Fortunately, we generally have more than 15 players in attendance.

I'd be happy to share these schedules if anyone is interested, but as they are quite specific and would take a long time to type our I prefer to wait for a specific request. Also, if anyone can improve upon my results (as summarized above), please do let me know.

Finally, is there an easy way to generate the solution for 40 players? I know how to generate the perfect solution for 39 rounds (every player partnering with every other player exactly once and opposing every other player exactly twice), but is there a 13 round solution which has every possible pair meeting exactly once [from which I would just take any 8 games]?

Ray                          
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on October 11, 2022, 04:22:39 AM
Hi Ray,

I am thinking about what you have posted and may respond later.   You are of course welcome to post schedules if you would like and you can do this as Excel attachments if that would be more convenient for you.  The 40 player 13 round schedule you are looking for can be found here in the top half of my reply #10 (https://www.devenezia.com/round-robin/forum/?topic=488).  Or if you want to know how to make it I can find a reference in the mathematical literature for you.

Ian
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on October 12, 2022, 04:08:30 AM
Ray,

I have an observation on your 24 player schedule with 8 never meeting. If you take the schedule in reply #4 above and add the following 8th round:

1  9 17 -
2 10 18 -
3 11 19 -
4 12 20 -
5 13 21 -
6 14 22 -

where "-" represents an unfilled player slot, then the schedule will have only 6 pairs of players who never meet - so improving on your 8 pairs.  To complete the schedule you are free to fill the empty slots with the remaining players 7 8 15 16 23 & 24 in any way you like.

I notice that you don't make any constraints on the byes - I believe I can do better than (26,52), but allowing 2 of the players to have 2 byes allows for better mixing.  Is that acceptable?


Ian
Title: Re: Am I asking for the impossible?
Post by: raydog on October 12, 2022, 07:11:49 PM
Ian, you're a genius!

Thank you for the improvement to my 24 player schedule. I had attacked it from a different angle and thought 8 no-meets was pretty good.

As for the 40 player schedule, I did search the forum for a solution ready-made, but gave up after 15 minutes. I figured it was there somewhere, thank you for pointing me in the right direction (this also solved my 39-player schedule).

I am attaching a spreadsheet with my solutions (not always optimized) for the other numbers of players, 15-40. Excel format. In case it is of use for others. There is a tab for each scenario, and a summary on the last tab. Some references to "Bob" (a stalwart colleague who did an incredible job devising schedules by hand many years ago), I was trying to improve upon his results. And sometimes a bit of explanation as to my tactics. Maybe this will prove useful to someone.

As for byes, I neglected to mention that a minimum number of byes is essential: everyone should play as many games as possible (no more than 1 bye). Thank you for pointing that out.

A story: a computer programmer gets a call from his wife at work. She says, "On your way home, can you pick up a loaf of bread? And if they have eggs, get a dozen." He comes home with 12 loaves or bread.

Cheers!

Ray
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on October 13, 2022, 04:12:34 AM
Ray,

Thanks for posting the spreadsheet and your kind words - I will let you know if I find any improvements.

Kind regards,

Ian
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on October 13, 2022, 12:18:55 PM
Ray,

I found the following for 15 players:

  (13  6  1 11) ( 9  5  7 12) ( 8  2 10  4)  (14  3 15)
  (15  2 13  5) ( 7 14  4  6) ( 1  8  3 12)  ( 9 11 10)
  (10 15  1  7) ( 2  4  3 11) ( 9 13 14  8)  (12  6  5)
  ( 5  8  1  6) ( 7 15 11 14) ( 3  4 13 12)  (10  9  2)
  ( 1  5  4 11) ( 2  7  8 12) ( 9 10  3  6)  (15 14 13)
  (11 15  3  8) ( 9  7  2  1) (12  5 14 10)  ( 4 13  6)
  (15  4  6  9) (12 10 13 11) ( 3  1 14  2)  ( 5  8  7)
  (10 11  9 14) (13  3  5  7) ( 2 12  6 15)  ( 8  1  4)

above read (A B C D) as (A B vs C D).  Appart from the pair 2 & 3 who oppose twice, I think it's as good as it can be, so it should come very close to your ideal parameters.

Ian
Title: Re: Am I asking for the impossible?
Post by: raydog on October 13, 2022, 06:12:50 PM
I don't know how you do it, Ian, but this obviously an ideal schedule. Thanks!

Ray
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on October 15, 2022, 12:24:47 PM
Ray,

Can you explain to me how you calculate the ideal values for "partner once", "oppose once", "oppose twice" & "partner once + oppose once" that I can see in the spreadsheet that you posted?   Perhaps you could take n=18 as an example.

When player pairs are going to meet twice, do you see "partner once + oppose once" as more desirable than "oppose twice"?

Thanks,

Ian
Title: Re: Am I asking for the impossible?
Post by: raydog on October 17, 2022, 10:42:12 AM
Ah, you caught me out! Those are more or less made up. I think I just applied some ratios I thought seemed reasonable. But there is in fact no reason to think those numbers are achievable (sorry if that was misleading - part of my hesitancy in posting this spreadsheet was the fact that there are numbers like that included!)

The cardinal rules are:
1) a pair of player never meets 3 times (which is now the case in all scenarios, thanks to your help with the 15-player scenario);
2) no player gets 2 byes until all other players have had 1 bye.

So the important numbers in that "ideal" scenario are the "never meet" number (which I strive to make 0 if there are more "possible meetings" than "possible pairings"), and the "meet 3 times" number (which I strive to make 0: solved). It's that first stipulation which may not actually be possible.

When I coded my program, I needed to specify what made a given solution better than any previous solution. So if "never meet" was the same for two scenarios [and "meet 3 times" was 0], I applied a 2nd order comparison, and prioritized "partner once + oppose once" over "oppose twice".  This just seemed reasonable, on a human level. So yes, you have interpreted correctly, but the 1st order priority is minimizing "never meet".
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on October 18, 2022, 01:39:42 PM
Consider the 18 player tournament, and count the pairs in the schedule in different ways.  With 8 rounds and 4 tables, there are 32 games.  Each game has 2 partner pairs and 4 opposition pairs, so over the tournament 64 partner pairs and 128 opposition pairs, or a total of 192 pairs.  With 18 players there are a possible 153 distinct player pairs, so the ideal arrangement, with no player pairs who never meet, or player pairs who meet 3 or more times, has:

114 pairs who meet once(x)
39 pairs who meet twice(y)

this follows because these numbers are the only solutions to:

x + y = 153
x*1 + y*2 = 192

As we have agreed, the best schedule will have all 39 pairs who meet twice of the type where 2 players partner once and oppose once. Therefore, by subtraction we can discover how the players pairs who meet once are distributed:

64 - 39 = 25 pairs who partner once
128 - 39 = 89 pairs who oppose once.

So putting this together the ideal parameters are as follows:
Never meet = 0
Partner once = 25
Oppose once = 89
Oppose twice = 0
Partner once + Oppose once = 39
Meet 3+ times = 0

This is not that far away from your Excel sheet.  So I went looking, and I can find such a schedule by computer search:

(13  6  5  1) (14  3  7 16) ( 2 10 15 11) (17 12 18  9)  ( 4  8)
( 6 11 12 15) ( 2  4 13 16) (17  8 10  3) ( 7 18  1  9)  (14  5)
(14  8  1 12) (11 17  7 13) (15  6 16  9) ( 5  2  4 18)  (10  3)
(13  1 10 16) ( 5 11  9 14) ( 3  4 18 12) ( 7  6  2  8)  (15 17)
(15 17  1  4) (11 13  8  3) (18  2 14 10) (16  5 12  7)  ( 9  6)
(18 14 15 13) ( 6  4 10  7) ( 5 17 16  8) ( 1  2  9  3)  (12 11)
( 3  5 10 15) (11 18 16  6) ( 8  9 14  4) ( 2 12  1 17)  ( 7 13)
( 3 17  6 14) ( 9 12 10 13) (15 18  7  8) ( 4  5 11  1)  ( 2 16)
Title: Re: Am I asking for the impossible?
Post by: raydog on October 18, 2022, 08:58:02 PM
Certainly can't argue with your logic, Ian, and get another ideal solution! I'm updating my spreadsheet with each update, will repost once you get tired of optimizing my results.

Thanks again!

Ray
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on October 23, 2022, 04:47:02 AM
Ray,

I have been having another look at 26 players and using some statistical experimental design software, I can get an improvement.  Your excel file has a schedule with parameters (52,10,5) for (never meet, partner twice, partner/oppose once). The schedule below has parameters (46,0,9) where players 11 to 26 are the ones who get a bye.

(12  3 18  1) ( 7 23 25 14) (20 22 17 15) ( 8 21  2  4) (11  5 10 13) ( 6 19  9 24)  (16 26)
(23 12  4 10) ( 2 18 14 20) ( 1  9 25  5) ( 3 13  6 17) (19 26 15  8) (21 16  7 24)  (11 22)
( 2 22 10 16) (23 26  6  5) ( 4 17 19  1) (12 11 24 15) ( 9 14 21 13) (20  7  8  3)  (18 25)
( 6 10  8 20) (26 21 11  1) (24  3  2  5) (15 13 18 23) (25 19 12 16) (22  4  7  9)  (14 17)
(18 11  6  2) ( 3 16 15  9) ( 8 23 22  1) (26 13  4  7) (14  5 19 20) (21 17 25 10)  (12 24)
(25 11 22  3) ( 1 16 13 20) (24 17 14  8) ( 7 18 19 10) ( 6  4 15  5) (12  2 26  9)  (21 23)
( 4 14 16 11) (13 25  8  2) (10  1  9  6) ( 3 23 19 21) (12  5 17  7) (24 18 22 26)  (15 20)
( 2  1  7 15) (23 17  9 11) ( 3 14 26 10) (16  8 18  5) (21 12 22  6) ( 4 24 20 25)  (13 19)

as with the other schedules the match (A B C D) should be read as (A B) vs (C D).
Title: Re: Am I asking for the impossible?
Post by: raydog on October 29, 2022, 08:43:58 AM
Another fine improvement to my schedule, thanks!

Ray
Title: Re: Am I asking for the impossible?
Post by: AEuchreDude on October 15, 2023, 12:03:52 PM
A big thank you to raydog for posting your schedules. This is exactly what I have been looking for. I am creating scorecards for a Euchre tournament for 2-48 players. I was able to take raydog's info and create "perfect" scorecards from 41-48 players successfully.

raydog, do you have any updated/improved schedules?

Ian, would you be able to help improve some of my schedules? A small problem was raydog's schedules were for 8 rounds and I only want 7 rounds.
I attached a spreadsheet that has 12,13,23,25,26 schedules that it seems could be improved upon. The 25 and 26 schedules are raydog's, not sure if these can be made "perfect" but raydog's 24 player is.

I have the exact same criteria as raydog except I have 7 rounds instead of 8.
Thank you for any help
Title: Re: Am I asking for the impossible?
Post by: Ian Wakeling on October 30, 2023, 01:28:27 PM
AEuchreDude,

I have been thinking about the three larger schedules that you give above.  These are of the sort where it might be possible to have no pair of players meet twice. I am getting quite close.

23 players:

 ( 3 18  4 13)  ( 5  7 20 15)  ( 1  9 16 12)  (14  8 11 10)  (17  2 19  6)
 (23 22  9 13)  (12  3 17 11)  (16  5  4  8)  ( 7  6 14 21)  (10 15  1  2)
 (11 21 23 13)  ( 8  2  3  9)  ( 5  6 10 12)  ( 1  7  4 22)  (19 14 18 20)
 ( 6  1 18 11)  (23 20  4  2)  ( 5 21  9 17)  ( 8 15 19 22)  (10 16  7  3)
 ( 7 23  8 12)  ( 5 19 13  1)  (14  4 17 15)  ( 6 22  3 20)  (18  2 21 16)
 (22  2 11  5)  (18 15 12  9)  (23  3 14  1)  (17 20 13 16)  (10 21  4 19)
 (17 10 22 18)  ( 9 11 19  7)  ( 2 14 13 12)  (21 20  8  1)  (15 23  6 16)

Above the pairs (9 12) & (13 23) are the only ones who meet twice.

25 players:

 (18 22  1 19)  ( 9 20  7  8)  (24 12 15  6)  (16  2 17 13)  (10 23 14  5)  ( 3 11 21  4)
 ( 7 19 12  3)  (10 21 20  1)  ( 6 22 16 14)  (17 15 18 25)  (13 23  8  4)  ( 9  2  5 11)
 ( 5 22  4 15)  (20 18 16 11)  ( 3 24  8 10)  (17  1  9 12)  ( 7 13 19 14)  (21  2 25  6)
 ( 7 10 15 16)  ( 2 23 24 19)  (18 14  3  9)  (12 20 25  4)  (13  1  6 11)  (17  8 21  5)
 (22  3 17 23)  (20  6 19  5)  (18 12 10 13)  (15 11  8 14)  (16 24  9 25)  ( 4  1  7  2)
 ( 6  7 18 23)  (22  8 12  2)  (13 21  9 15)  (16  3  5  1)  (10 25 19 11)  ( 4 14 17 24)
 (17 22 11  7)  ( 3 20  2 15)  (24  5 13 18)  (12 23 21 16)  ( 4  6 10  9)  ( 8  1 14 25)


Above the pairs (7 19), (8 14), (13 18) & (17 22) are the only ones who meet twice.


26 players:

 (15  4 23 10)  ( 6 22  2  5)  (14 24 11 18)  (20 17 12  9)  (16  3  7 19)  (21  1 13  8)
 (12 13  4 18)  (11 20 10  3)  ( 9  2  1 25)  (22 14 15 19)  ( 5 26 16 21)  ( 6 17  8  7)
 (26 15 11  9)  (23  3 12  8)  (18  7  2 10)  ( 5  4 19 24)  (20 14  1  6)  (17 16 13 25)
 (14 10 25 21)  (12 24  1 26)  ( 5 18 15  8)  ( 7 22 13 11)  (23  6  9 16)  ( 2 17  4  3)
 (14 26  8  2)  (24 23 22 25)  ( 9  5 13  3)  ( 1 16 11  4)  (20 15 21  7)  (19  6 12 10)
 (26  6 25  4)  (17 11 23 21)  ( 2 20 13 19)  ( 8 10  9 24)  ( 1 22  3 18)  (14  7  5 12)
 (12 16 15  2)  (11  8 19 25)  ( 4  7  9 22)  ( 3 21  6 24)  ( 5 10  1 17)  (26 20 23 18)


Above the pair (7 22) is the only one to meet twice.

If games such as (A B C D) in the schedules above are played as (A B vs C D) then those who meet twice will do so once as partners and once as opponents.

Those sitting out are logically arranged with the highest player numbers sitting out in the first round.

Hope that helps.