Recent Posts

51

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.

52

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.

53

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)

54

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.

55

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

56

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.

57

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.

58

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? 

59

Requests / Re: Uno Tournament 6

« Last post by schmidthaus on February 11, 2024, 04:33:31 PM »

Actually yes, I have more than enough uno versions for a 7th table!  And it doesn't matter to me how many people per table as long as it is relatively close (like we wouldn't want 2 people at one table and another have 6).  

I hadn't thought about the 'bye' idea.  We've had 'bye' player numbers when someone no-shows at the last minute (grrr).  If a different solution isn't available, then the bye is a viable option as long as everyone has the same number of byes since they will be scored.  

60

Requests / Re: Uno Tournament 6

« Last post by Ian Wakeling on February 11, 2024, 12:18:19 PM »

I have another idea.  A lot of the difficulty here is specifically because you have 6 tables, and this is just a difficult number to work with.  Are you able to find a 7th version of Uno?  If you can that's great, or if not still have 7 tables, but assign the last one as a bye, so it becomes the drinks and snacks table.  Now you can use the following:

(1  8 15 22 29 36) (2 10 18 26 34 42) (3 12 21 23 32 41) (4 14 17 27 30 40) (5  9 20 24 35 39) (6 11 16 28 33 38) (7 13 19 25 31 37)
(2  9 16 23 30 37) (3 11 19 27 35 36) (4 13 15 24 33 42) (5  8 18 28 31 41) (6 10 21 25 29 40) (7 12 17 22 34 39) (1 14 20 26 32 38)
(3 10 17 24 31 38) (4 12 20 28 29 37) (5 14 16 25 34 36) (6  9 19 22 32 42) (7 11 15 26 30 41) (1 13 18 23 35 40) (2  8 21 27 33 39)
(4 11 18 25 32 39) (5 13 21 22 30 38) (6  8 17 26 35 37) (7 10 20 23 33 36) (1 12 16 27 31 42) (2 14 19 24 29 41) (3  9 15 28 34 40)
(5 12 19 26 33 40) (6 14 15 23 31 39) (7  9 18 27 29 38) (1 11 21 24 34 37) (2 13 17 28 32 36) (3  8 20 25 30 42) (4 10 16 22 35 41)
(6 13 20 27 34 41) (7  8 16 24 32 40) (1 10 19 28 30 39) (2 12 15 25 35 38) (3 14 18 22 33 37) (4  9 21 26 31 36) (5 11 17 23 29 42)
(7 14 21 28 35 42) (1  9 17 25 33 41) (2 11 20 22 31 40) (3 13 16 26 29 39) (4  8 19 23 34 38) (5 10 15 27 32 37) (6 12 18 24 30 36)

This has best possible mix of players and it also has the property that it will work no matter how many players turn up (between 14 and 42).  Simply delete the unused player numbers from the schedule above.