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
And here is link: excelexperts.com/reply-forum-topic-help-count-triosquartetsquintets
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.
Manny - create a blog post,
Manny - create a blog post, upload the file, then link back to it.