Help Count Trios/Quartets/Quintets

Good Afternoon,

I need your help to make some statistics for a indoor soccer team that I'm coaching a school.

Each class has 15 players. And these 15 players play games with each other every week. Each soccer team has 5 members, so I get three teams of five players. The teams are filled through a random draw.

For example:

week 1

Team A:
player_1
player_2
player_3
player_4
player_5

Team B:
player_6
player_7
player_8
player_9
player_10

Team C:
player_11
player_12
player_13
player_14
player_15

Week 2

Team A:
player_1
player_6
player_11
player_12
player_5

Team B:
player_4
player_7
player_8
player_13
player_14

Team C:
player_9
player_10
player_2
player_3
player_15

Week ...

Week 10

Team A:
player_8
player_13
player_11
player_4
player_7

Team B:
player_12
player_5
player_3
player_15
player_14

Team C:
player_9
player_10
player_2
player_1
player_6

I have all games on an excel scheet, and I've managed to calculate how many times each player played with another player, but only with this for two players. For combinations of 3 players, 4 or even whether any team of 5 players have repeated itself I can not do.

Anyone can help me in this? It would be a tremendous help for the kids.

Thank you all.

Link to attached file

RE: Help count...

Hello,

I make sample file, but cannot attach it to comment. Can you tell me how to send file to you (e-mail, share server, ...) to see is it that you need or not. If you have questions of what and how I do, ask me and I will explain you.

I make file, not explain here, because I don't know how your data are store and I decide to improvise to solve your problem. Hope I guess what you need.

Best regards.

Nick's picture

Manny - create a blog post,

Manny - create a blog post, upload the file, then link back to it.