Request: 24 players 4v4; 10 games

[saintsriracha]

First of all, huge thanks to the contributors and moderators of this forum. It's super helpful. There is not another forum like this on the internet. 

I found this awesome response for a 16 player, 4v4 10 game tournament in two fields (in ABCD EFGH ...) 
https://www.devenezia.com/round-robin/forum/?topic=774 

Would it be possible to have one for 24 players, 4v4, 10 games, 3 fields? 
Only additional requirement is not to have any one pair repeat more than twice, everyone paired with most others, and facing most everyone else. 
THANKS!

PS - is there a widget that I could install in Excell or formula to import in Google Sheets where we input # of players (maintaining 4v4 and 10 games)? 

[saintsriracha]

Perhaps I found the answer - i eventually got to this page following many breadcrumbs:
https://web.archive.org/web/20120503232317/http://www.maa.org/editorial/mathgames/mathgames_08_14_07.html#g24o4d7

This appears to be the answer I was looking for (do please let me know if it appears correct):
24 golfers can play in foursomes for 7 days.

Day1 ABKU IJSE QRCM DGFX HLNO PTVW
Day2 ACLV IKTF QSDN EHGR BMOP JUWX
Day3 ADMW ILUG QTEO FBHS CJNP KRVX
Day4 AENX IMVH QUFP GCBT DJKO LRSW
Day5 AFOR INWB QVGJ HDCU EKLP MSTX
Day6 AEPS IOXC QWHK BEDV FJLM NRTU
Day7 AHJT IPRD QXBL CFEW GKMN OSUV

[Ian Wakeling]

There is actually an error in the 24 player schedule that you copied - for Day 6 the first 'E' should be a 'G'.  However, this schedule is for foursomes over 7 days, each player plays exactly once with 21 different players, and has exactly two players who they never meet - so for example player A meets everyone except I and Q.  The problem is that the schedule does not work well if you try and divide each day into 3 games of 4 versus 4.  For example if you played column 1 versus column 2, then A would always oppose I, and never oppose Q.  No matter how you form the 4v4 games, you will always have poor balance for opponents.

I don't know of any software that will help you here, but perhaps I can help with a schedule.  The schedule above is for 7 rounds when you were asking for a 10 round schedule, so I presume there is some flexibility in the number of rounds - is that right?

[saintsriracha]

Ian,
Realistically, we can play 8 games in a single one-time tournament, keeping it under 2 hours. 

I found that the sequence I had posted before was made for golf not soccer, so it did not take into account the opponents team- as a result, works great to avoid repeating any two pairings more than twice, but it does repeat oponents (same two oponennt players ended up facing three times sometimes). 

So ideally I'm looking for:
* 24 players
* 4v4 games
* Three fields 
* 8 rounds
* Any two players are not paired together or face against each other more than twice 
* It's OK to have pairings that do not happen (I imagine this is unavoidable). 

In this Dutch style tournament, each team point is tracked at the indivdual level, so there is one player that wins most points at the end (penalty shootouts if there are players tied for most points). This has three concurrent 4v4 games, looking like this: 




Once I receive the sequences from you, I will create a Google Spreadsheet that will automatically tally indivdiual points and provides a final player ranking at the end of the tournament. I will be organizing these tournaments on a monthly basis (several of us doing this at the club), so whatever you provide will be used A LOT. 

THANAK YOU!!!

PS- I already created exactly this tracking spreadsheet for the 16 player tournament that you had posted here on this site in response to an earlier query, so you've already helped!

[Ian Wakeling]

My thinking is that there are no good solutions for the length of tournament that you are looking for, in particular the opposition part of your 5th bullet point is the problem. The 8 round solutions that I have managed to make are really bad, so instead I am offering a 7 round solution.

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

The pairs of players within a team of 4 are the best they can be - so everyone is partnered with 21 different players. As mentioned above, the balance for opponents is not so great - players 1 to 21 have 5 other players who they never oppose and one other player who they oppose 3 times; players 22 to 24 all have 9 other players who they never oppose, and 7 other players who they oppose 3 times, so the last three players get a raw deal.

It's worth mentioning that if you were to have a 23 round schedule, then I think full balance would be possible with each player having every other player 3 times as a partner, and 4 times as an opponent.

[saintsriracha]

A HUGE MAHALO ("thanks") from Hawaii. 
Aloha,
P.