I was looking for help in creating this macro that should solve several future problems for my beach volleybal tournament :)
(我正在寻找帮助来创建此宏，该宏应解决我的沙滩排球锦标赛的几个未来问题：）)
I googled several different solutions on combinations calculations but I found them to be unnecessary complicated or not exactly answering my needs, therefore here I am :D
(我用谷歌搜索了几种关于组合计算的解决方案，但发现它们不必要复杂或不能完全满足我的需求，因此我在这里：D)
The idea is the following:
(这个想法如下：)
I start with a number of teams (let's say up to 64)
(我从一些团队开始（比如说最多64个）)
Depending on the number of courts that I have available I am separating these teams in a number of "pools" (as a first approach I am planning on doing it manually, so that I can also mix strong/weak teams)
(根据可用的法院数量，我将这些团队划分为多个“池”（作为第一种方法，我计划手动进行操作，以便我也可以混合使用强弱团队）)
At this point I need some help --> how to create automatically a combination of all the teams within the pool?
(此时，我需要一些帮助->如何自动创建池中所有团队的组合？)
I would like to have two contraints: no repetitions & try to avoid as much as possible the same team to play twice in a row (sometimes it is not physically possible) (我想有两个矛盾：不重复，并尽量避免同一支球队连续两次出战（有时在身体上是不可能的）)
The intention is to use the sheet automatically generated for each pools to insert the results and then calculate separately all the statistics.
(目的是使用为每个池自动生成的工作表来插入结果，然后分别计算所有统计信息。)
Here you can find the idea that I had on the final "look" of the Excel sheet (I inputed manually the "desired" results for the first pool as an example).
(在这里，您可以找到我对Excel工作表的最终“外观”的想法（我以手动输入第一个池的“所需”结果为例）。)
The idea is to have all the "orange" cells to be calculated automatically through this macro, all the "grey" ones to be filled manually and all the "green" ones with a standard Excel formula.
(想法是通过该宏自动计算所有“橙色”单元格，手动填充所有“灰色”单元格，并使用标准Excel公式填充所有“绿色”单元格。)
Thanks in advance and looking for your suggestions!
(在此先感谢您的建议！)
ask by Alessio Nebbia-Colomba translate from so 与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…
