Recent Posts

51

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?

52

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.

53

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.

54

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.

55

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)

56

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.

57

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

58

Requests / Re: Uno Tournament 6

« Last post by Ian Wakeling on February 12, 2024, 03:44:04 AM »

Regarding the question about the numbers at each table. This should be as balanced as possible as long the player numbers you don't use are the high numbers.  So if you used player numbers 1 to 30, then each round should have 5 tables of 4 and 2 tables of 5.

59

Requests / Re: Uno Tournament 6

« Last post by Ian Wakeling on February 12, 2024, 03:33:46 AM »

Yes, you are correct, I did intend that you signed people up sequentially.  There is something you may not have noticed with the schedule above, if you have 42 players, then each will play with 7 x 5 = 35 other players out of a possible 41 other players.  The 6 players whom a player does not meet are precisely the same players as the others within their own group of 7 - so if you are player 8 for example, you will not meet players 9 to 14; here the groups of 7 are the same as the 6 columns within any one table.  If people arrive in small groups because they have traveled together, and you assign sequentially then there is a good chance that the members of that group will not play each other - of course this might be what you want as the members of the group are more likely to play with people they don't already know.  If it is not what you want, then I would pick a minimum number of players that you are sure will turn up - say 28 - and then assign the first 28 at random and then go sequentially after that.

60

Requests / Re: Uno Tournament 6

« Last post by schmidthaus on February 11, 2024, 05:11:21 PM »

Question about this: "Simply delete the unused player numbers from the schedule above."

In the past, I have a posterboard with a sign-in where the line number becomes their player number.  I've done both assigning in order, and letting them choose a random line (player) number.  Do I understand correctly that it would be best for this example to have them sign in sequentially, not randomly?