1
Requests / Re: Round Robin - 8 Player Doubles
« Last post by tkam on September 21, 2023, 12:39:16 PM »Amazing, that's an upgrade for sure.
Thanks you Ian!
Tej
Thanks you Ian!
Tej
Recent Posts
2
Requests / Re: Round Robin - 8 Player Doubles
« Last post by Ian Wakeling on September 21, 2023, 12:13:40 PM »Tej,
I had another go and I think the schedule below has 4:4:3:3:3:2:1 opponents with no repeated games. It's has a slightly different order to your example, the first two rows are played on the same court, same for the next two rows, etc.. Hope that helps,
Ian
6 5 v 4 1
6 1 v 5 4
8 3 v 7 2
8 7 v 2 3
1 8 v 7 6
1 7 v 8 6
5 2 v 3 4
5 3 v 2 4
2 1 v 5 8
2 8 v 5 1
3 6 v 4 7
3 7 v 4 6
4 2 v 6 8
4 6 v 8 2
7 3 v 1 5
7 5 v 3 1
3 1 v 6 2
3 2 v 1 6
4 8 v 5 7
4 5 v 8 7
I had another go and I think the schedule below has 4:4:3:3:3:2:1 opponents with no repeated games. It's has a slightly different order to your example, the first two rows are played on the same court, same for the next two rows, etc.. Hope that helps,
Ian
6 5 v 4 1
6 1 v 5 4
8 3 v 7 2
8 7 v 2 3
1 8 v 7 6
1 7 v 8 6
5 2 v 3 4
5 3 v 2 4
2 1 v 5 8
2 8 v 5 1
3 6 v 4 7
3 7 v 4 6
4 2 v 6 8
4 6 v 8 2
7 3 v 1 5
7 5 v 3 1
3 1 v 6 2
3 2 v 1 6
4 8 v 5 7
4 5 v 8 7
3
Requests / Re: Round Robin - 8 Player Doubles
« Last post by tkam on September 21, 2023, 10:13:22 AM »I think you have the best possible arrangement. I can see that it's unavoidable that each player will have one other player whom they oppose only once, so this rules out 3:3;3:3:3:3:2. I can get 4:4;3:3:3:2:1 but only by allowing repeated games at a court.
On second thoughts Ian, could you provide the 4433321 solution with the repeat games please?
4
Requests / Re: Round Robin - 8 Player Doubles
« Last post by tkam on September 21, 2023, 04:37:20 AM »Cheers Ian, I can put this to rest finally and just enjoy the session know its the best it can be.
Tej
Tej
5
Requests / Re: Round Robin - 8 Player Doubles
« Last post by Ian Wakeling on September 21, 2023, 02:09:03 AM »I think you have the best possible arrangement. I can see that it's unavoidable that each player will have one other player whom they oppose only once, so this rules out 3:3;3:3:3:3:2. I can get 4:4;3:3:3:2:1 but only by allowing repeated games at a court.
6
Requests / Re: Round Robin - 8 Player Doubles
« Last post by tkam on September 20, 2023, 09:03:23 AM »Hi Ian, any chance you had a chance to look at this please mate?
7
Requests / Round Robin - 8 Player Doubles
« Last post by tkam on September 10, 2023, 05:03:57 PM »Hi Ian,
Looking for help with a balanced schedule for my weekly badminton session of 8 player doubles on 2 courts.
We play 2 consecutive games before we swap players as our courts are booked in different halls in the same venue so single game swapping isn't practical. We play a total of 20 games across the 2 courts (10 per player).
I've tried to construct a round robin that ensures players play with each other min 1 to max 2 times (3 default playe WITH repetitions games due to 10 games), and playing vs others players the same amount of times (ideally 3 max).
I'm starting to think because of the 2 game rotation per swap, its not possible to get the outcome I'm looking for.
From what I've read, I'm looking for a Whist design, but with a caveat that a 4 player court plays 2 games before swapping with the players from the other court.
I.e. the games flows as follows:
Court 1 game 1: A/B vs C/D
Court 1 game 2: A/D vs B/C
Court 2 game 1: E/F vs G/H
Court 2 game 2: E/H vs F/G
Then a rotation will occur between courts and so on.
The most balanced distribution I've been able to achieve is:
PLAY WITH: 2:2:2:1:1:1:1
PLAY AGAINST: 5:4:3:3:2:2:1
Desired:
PLAY WITH: 2:2:2:1:1:1:1
PLAY AGAINST: 3:3:3:3:3:3:2
Is this logically possible given the constraints of my round robin setup?
Here's my solution for the 2222111 / 5433221 ratio:
Thanks in advance...
Looking for help with a balanced schedule for my weekly badminton session of 8 player doubles on 2 courts.
We play 2 consecutive games before we swap players as our courts are booked in different halls in the same venue so single game swapping isn't practical. We play a total of 20 games across the 2 courts (10 per player).
I've tried to construct a round robin that ensures players play with each other min 1 to max 2 times (3 default playe WITH repetitions games due to 10 games), and playing vs others players the same amount of times (ideally 3 max).
I'm starting to think because of the 2 game rotation per swap, its not possible to get the outcome I'm looking for.
From what I've read, I'm looking for a Whist design, but with a caveat that a 4 player court plays 2 games before swapping with the players from the other court.
I.e. the games flows as follows:
Court 1 game 1: A/B vs C/D
Court 1 game 2: A/D vs B/C
Court 2 game 1: E/F vs G/H
Court 2 game 2: E/H vs F/G
Then a rotation will occur between courts and so on.
The most balanced distribution I've been able to achieve is:
PLAY WITH: 2:2:2:1:1:1:1
PLAY AGAINST: 5:4:3:3:2:2:1
Desired:
PLAY WITH: 2:2:2:1:1:1:1
PLAY AGAINST: 3:3:3:3:3:3:2
Is this logically possible given the constraints of my round robin setup?
Here's my solution for the 2222111 / 5433221 ratio:
Thanks in advance...
8
Requests / Re: Round Robin help needed
« Last post by Ian Wakeling on September 05, 2023, 03:55:02 AM »No need for Ultraedit, I just copy-pasted the schedule onto a worksheet and used the "Data/Text to Columns" feature to split it out into columns using "fixed width".
Yes, I am writing a program specifically to solve the problem and not using Excel. The process is not complex, I just fill up the schedule randomly to start and then start swapping pairs of non-fixed matches around to try to improve the quality of the schedule - where the quality is measured by how close it is to having each team once in each round of the schedule.
Yes, I am writing a program specifically to solve the problem and not using Excel. The process is not complex, I just fill up the schedule randomly to start and then start swapping pairs of non-fixed matches around to try to improve the quality of the schedule - where the quality is measured by how close it is to having each team once in each round of the schedule.
9
Requests / Re: Round Robin help needed
« Last post by Ian James on September 04, 2023, 04:45:07 PM »Thankyou again.
I had managed to copy and paste it into Excel already using Ultraedit but that was long winded and laborious!
Are you creating these algorithms as programs or using Excel macros?
I would be interested to know more about the process you use to fill in the draw with matches already in place.
I have created the draws that I needed thanks to your help, this is just out of interest in the process!
Regards
Ian
I had managed to copy and paste it into Excel already using Ultraedit but that was long winded and laborious!
Are you creating these algorithms as programs or using Excel macros?
I would be interested to know more about the process you use to fill in the draw with matches already in place.
I have created the draws that I needed thanks to your help, this is just out of interest in the process!
Regards
Ian
10
Requests / Re: Round Robin help needed
« Last post by Ian Wakeling on September 04, 2023, 12:23:52 PM »Sorry, there is nothing downloadable that I can give you. I have put the schedule in a Excel file as requested - it is attached, but you can only see it when you are logged in to the forum.