Round Robin Tournament Scheduling

Recent Posts

41
Comments and Thanks / Re: Round Robin Scheduler
« Last post by Ian Wakeling on February 24, 2024, 11:39:43 AM »
If you register as a user of the forum, and you are also logged in, then you can download my Excel spreadsheet here.  If that doesn't help then you are welcome to post in the 'requests' section.
42
Requests / 10 Team Quiz League with 3 Triangular Meets Per Night
« Last post by HillJackBob on February 23, 2024, 10:59:39 PM »
Hello.  I'm a coach in an elementary school quiz league where our conference includes 10 teams.  Each night we have 3 triangular meets at 3 locations, and each week 1 team has the night off.  Right now the schedule is all messed up, there are 9 dates, some teams are playing each other 3 times, some just once, some teams have 0 byes, some have 1 bye week, and some have 2.  It's chaos.

I'd like to try to see if I could come up with a schedule with a 10th date, so therefore every team could have one bye week.  In that scenario, everyone SHOULD be able to play each other twice.  Can anyone direct me to a way to arrange these teams in this way.

i.e.  the first week could be (A B C) (D E F) (G H I) with team J on bye.  After 10 weeks, each team should have 1 bye, and have played each of the other teams twice.
43
Comments and Thanks / Round Robin Scheduler
« Last post by Craig Sukenic on February 21, 2024, 05:48:54 PM »
I am very interested in downloading a copy of your round robin scheduler.  It will be very helpful to use for scheduling an upcoming charity pickleball tournament
 
44
Requests / Re: Balanced Home & Away Draw with extra criteria
« Last post by geffish on February 20, 2024, 08:41:00 AM »
I guess having alternating home and away wouldn't have to be crucial as long as each team has an even as possible home and away draw. I understand the more criteria one adds to the equation the harder it would be to come up with a solution. The question is, is it still possible for other number of teams?
45
Requests / Re: Balanced Home & Away Draw with extra criteria
« Last post by Ian Wakeling on February 19, 2024, 03:42:35 AM »
I have looked at your spreadsheet.  I am not aware of any general way of making the schedule where all the derby games are in the first round, so have you managed to do this for any other number of player apart from 8?  In your schedule players 3 to 8 each have 2 breaks from the strictly alternating pattern, while the original unrandomized schedule has only 1 break each for players 3 to 8 -  I am guessing this a compromise that needs to be made in order to obtain the derby games you want.
46
Requests / Re: Balanced Home & Away Draw with extra criteria
« Last post by geffish on February 18, 2024, 07:01:14 AM »
I have downloaded the file previously. I works great. The only thing I want is a specific round where all paired teams play each other i.e. a 'local derby'. Two teams playing from the same venue would play each other.
47
Requests / Re: Balanced Home & Away Draw with extra criteria
« Last post by Ian Wakeling on February 17, 2024, 10:46:38 AM »
Have you looked at my macro based spreadsheet that you can download here. It will make single or double round-robins with optimally alternating patterns of home and away games.  Note that you need to be logged in to the forum in order to see the download link.
48
Requests / Re: 10 golfers 4 rounds 2 teams
« Last post by Ian Wakeling on February 17, 2024, 10:27:59 AM »
Unfortunately, this problem does not have any good solutions. In fact the "every other person at least once" property that you are looking for is not possible, which can be seen by counting partnerships between pairs of players on the same team. There are 20 partnerships to cover, 10 per team, however each round covers 4 partnerships, so the schedule as a whole has slots for 16 partnerships, meaning that (at least) 4 partnerships must be missing from the schedule.

In the schedules below players 1 to 5 are team A, and players 6 to 10 are team B.

Solution 1: where players 1 and 6 are always in the foursome and the 4 pairs who never meet are (3 5), (4 5), (8 9), (8 10)

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

If you don't like the idea of 1 and 6 opposing 4 times, then the next best is to have 5 pairs who never meet

Solution 2: Player 2 is always in the foursome and player 10 is always in a threesome and the 5 pairs who never meet are: (1 4), (3 5), (6 8), (7 9), (2 10)

 (1  2 v 6  7)  (3  4 v 8)  (5 v 9 10)
 (2  3 v 6  9)  (4  5 v 7)  (1 v 8 10)
 (2  4 v 8  9)  (1  5 v 6)  (3 v 7 10)
 (2  5 v 7  8)  (1  3 v 9)  (4 v 6 10)
49
Requests / Balanced Home & Away Draw with extra criteria
« Last post by geffish on February 16, 2024, 08:15:44 PM »
Hi,

I am looking for a formula or way to create a balanced Home & Away Draw. I also want to ensure there is one round where all paired teams play each other.

I am using Microsoft Excel.

I would like to display the draw in two adjacent columns so I can use a Lookup function to substitute numbers for teams.

Thanks in advance.
50
Requests / 10 golfers 4 rounds 2 teams
« Last post by Bpo29 on February 15, 2024, 01:12:06 PM »
Hello!

Ten golfers will play four rounds. Each round will have a foursome and two threesomes. 

Teams have been selected (5 vs 5)
Each group must have a least 1 player from each team. 
An example round, using Team A and Team B:

A A vs B B.     A vs B B.     B vs A A

Would like to get everyone to play in a group with every other person at least once. Not sure if it’s possible though!

Thank you so much for your help!

Brett