Mixing
Form three random groups satisfying certain parameters
Clash Royale CLAN TAG#URR8PPP
up vote
1
down vote
favorite
I want to form three football teams out of 18 players that have been playing for years. The input data is the following: 1) skill index per player, and 2) 100+ game results, including the most successful combination of two and three players. The teams generated need to be: 1) randomly selected, 2) more or less even in terms of average skill index, and 3) the best potential combination of players given past combined performances (but maintaining average skill intact).
Here is some sample data:
Player Team Game Result Skill
Player A Team X Game 1 Win 1
Player B Team X Game 1 Win 2
Player C Team X Game 1 Win 3
Player D Team Z Game 1 Lose 4
Player E Team Z Game 1 Lose 5
Player F Team Z Game 1 Lose 6
Player A Team P Game 2 Lose 1
Player B Team Q Game 2 Win 2
Player C Team P Game 2 Lose 3
Player D Team Q Game 2 Win 4
Player E Team P Game 2 Lose 5
Player F Team Q Game 2 Win 6
Player A Team R Game 3 Win 1
Player B Team R Game 3 Win 2
Player C Team S Game 3 Lose 3
Player D Team S Game 3 Lose 4
Player E Team R Game 3 Win 5
Player F Team S Game 3 Lose 6
Using these data, how do I form three teams that are randomly selected, but balanced in terms of skills and maximising in terms of matches of players that play well together?
*This question is similar to mine but not what I need.
permutations
asked Jul 30 at 12:18
NBK
153
add a comment |Â
up vote
1
down vote
favorite
I want to form three football teams out of 18 players that have been playing for years. The input data is the following: 1) skill index per player, and 2) 100+ game results, including the most successful combination of two and three players. The teams generated need to be: 1) randomly selected, 2) more or less even in terms of average skill index, and 3) the best potential combination of players given past combined performances (but maintaining average skill intact).
Here is some sample data:
Player Team Game Result Skill
Player A Team X Game 1 Win 1
Player B Team X Game 1 Win 2
Player C Team X Game 1 Win 3
Player D Team Z Game 1 Lose 4
Player E Team Z Game 1 Lose 5
Player F Team Z Game 1 Lose 6
Player A Team P Game 2 Lose 1
Player B Team Q Game 2 Win 2
Player C Team P Game 2 Lose 3
Player D Team Q Game 2 Win 4
Player E Team P Game 2 Lose 5
Player F Team Q Game 2 Win 6
Player A Team R Game 3 Win 1
Player B Team R Game 3 Win 2
Player C Team S Game 3 Lose 3
Player D Team S Game 3 Lose 4
Player E Team R Game 3 Win 5
Player F Team S Game 3 Lose 6
Using these data, how do I form three teams that are randomly selected, but balanced in terms of skills and maximising in terms of matches of players that play well together?
*This question is similar to mine but not what I need.
permutations
asked Jul 30 at 12:18
NBK
153
add a comment |Â
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I want to form three football teams out of 18 players that have been playing for years. The input data is the following: 1) skill index per player, and 2) 100+ game results, including the most successful combination of two and three players. The teams generated need to be: 1) randomly selected, 2) more or less even in terms of average skill index, and 3) the best potential combination of players given past combined performances (but maintaining average skill intact).
Here is some sample data:
Player Team Game Result Skill
Player A Team X Game 1 Win 1
Player B Team X Game 1 Win 2
Player C Team X Game 1 Win 3
Player D Team Z Game 1 Lose 4
Player E Team Z Game 1 Lose 5
Player F Team Z Game 1 Lose 6
Player A Team P Game 2 Lose 1
Player B Team Q Game 2 Win 2
Player C Team P Game 2 Lose 3
Player D Team Q Game 2 Win 4
Player E Team P Game 2 Lose 5
Player F Team Q Game 2 Win 6
Player A Team R Game 3 Win 1
Player B Team R Game 3 Win 2
Player C Team S Game 3 Lose 3
Player D Team S Game 3 Lose 4
Player E Team R Game 3 Win 5
Player F Team S Game 3 Lose 6
Using these data, how do I form three teams that are randomly selected, but balanced in terms of skills and maximising in terms of matches of players that play well together?
*This question is similar to mine but not what I need.
permutations
asked Jul 30 at 12:18
NBK
153
I want to form three football teams out of 18 players that have been playing for years. The input data is the following: 1) skill index per player, and 2) 100+ game results, including the most successful combination of two and three players. The teams generated need to be: 1) randomly selected, 2) more or less even in terms of average skill index, and 3) the best potential combination of players given past combined performances (but maintaining average skill intact).
Here is some sample data:
Player Team Game Result Skill
Player A Team X Game 1 Win 1
Player B Team X Game 1 Win 2
Player C Team X Game 1 Win 3
Player D Team Z Game 1 Lose 4
Player E Team Z Game 1 Lose 5
Player F Team Z Game 1 Lose 6
Player A Team P Game 2 Lose 1
Player B Team Q Game 2 Win 2
Player C Team P Game 2 Lose 3
Player D Team Q Game 2 Win 4
Player E Team P Game 2 Lose 5
Player F Team Q Game 2 Win 6
Player A Team R Game 3 Win 1
Player B Team R Game 3 Win 2
Player C Team S Game 3 Lose 3
Player D Team S Game 3 Lose 4
Player E Team R Game 3 Win 5
Player F Team S Game 3 Lose 6
Using these data, how do I form three teams that are randomly selected, but balanced in terms of skills and maximising in terms of matches of players that play well together?
*This question is similar to mine but not what I need.
permutations
asked Jul 30 at 12:18
NBK
153
asked Jul 30 at 12:18
NBK
153
asked Jul 30 at 12:18
NBK
153
asked Jul 30 at 12:18
NBK
153
153
add a comment |Â
add a comment |Â
1 Answer
1
active
oldest
votes
up vote
1
down vote
accepted
You asked a
question
earlier that's clearly a leadup to this one.
Your requirements are getting more and more complex. I suggest that you proceed by generating many sets of three six person teams at random, calculate a "strength" for each team using some combination of players' individual skill level and the value of pairs and triples from your previous question. Then pick the set of teams for which the strengths are closest together.
answered Jul 30 at 12:29
Ethan Bolker
35.7k54199
@NBK If you actually use this method let me know how it works out. Comment here, or find my email (easy).
– Ethan Bolker
Jul 31 at 1:03
it did work, thank you. I created many random series of three teams and then chose the triplets with the same average skill. An additional problem me and a friend are trying to solve is how to use past match scores of teams to assess the individual skill of players in a non-tautological way. I may formulate a new question sometime soon, just to make the requirements more and more complex ;).
– NBK
Jul 31 at 17:50
add a comment |Â
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
accepted
You asked a
question
earlier that's clearly a leadup to this one.
Your requirements are getting more and more complex. I suggest that you proceed by generating many sets of three six person teams at random, calculate a "strength" for each team using some combination of players' individual skill level and the value of pairs and triples from your previous question. Then pick the set of teams for which the strengths are closest together.
answered Jul 30 at 12:29
Ethan Bolker
35.7k54199
@NBK If you actually use this method let me know how it works out. Comment here, or find my email (easy).
– Ethan Bolker
Jul 31 at 1:03
it did work, thank you. I created many random series of three teams and then chose the triplets with the same average skill. An additional problem me and a friend are trying to solve is how to use past match scores of teams to assess the individual skill of players in a non-tautological way. I may formulate a new question sometime soon, just to make the requirements more and more complex ;).
– NBK
Jul 31 at 17:50
add a comment |Â
up vote
1
down vote
accepted
You asked a
question
earlier that's clearly a leadup to this one.
Your requirements are getting more and more complex. I suggest that you proceed by generating many sets of three six person teams at random, calculate a "strength" for each team using some combination of players' individual skill level and the value of pairs and triples from your previous question. Then pick the set of teams for which the strengths are closest together.
answered Jul 30 at 12:29
Ethan Bolker
35.7k54199
@NBK If you actually use this method let me know how it works out. Comment here, or find my email (easy).
– Ethan Bolker
Jul 31 at 1:03
it did work, thank you. I created many random series of three teams and then chose the triplets with the same average skill. An additional problem me and a friend are trying to solve is how to use past match scores of teams to assess the individual skill of players in a non-tautological way. I may formulate a new question sometime soon, just to make the requirements more and more complex ;).
– NBK
Jul 31 at 17:50
add a comment |Â
up vote
1
down vote
accepted
up vote
1
down vote
accepted
You asked a
question
earlier that's clearly a leadup to this one.
Your requirements are getting more and more complex. I suggest that you proceed by generating many sets of three six person teams at random, calculate a "strength" for each team using some combination of players' individual skill level and the value of pairs and triples from your previous question. Then pick the set of teams for which the strengths are closest together.
answered Jul 30 at 12:29
Ethan Bolker
35.7k54199
You asked a
question
earlier that's clearly a leadup to this one.
Your requirements are getting more and more complex. I suggest that you proceed by generating many sets of three six person teams at random, calculate a "strength" for each team using some combination of players' individual skill level and the value of pairs and triples from your previous question. Then pick the set of teams for which the strengths are closest together.
answered Jul 30 at 12:29
Ethan Bolker
35.7k54199
answered Jul 30 at 12:29
Ethan Bolker
35.7k54199
answered Jul 30 at 12:29
Ethan Bolker
35.7k54199
answered Jul 30 at 12:29
Ethan Bolker
35.7k54199
35.7k54199
@NBK If you actually use this method let me know how it works out. Comment here, or find my email (easy).
– Ethan Bolker
Jul 31 at 1:03
it did work, thank you. I created many random series of three teams and then chose the triplets with the same average skill. An additional problem me and a friend are trying to solve is how to use past match scores of teams to assess the individual skill of players in a non-tautological way. I may formulate a new question sometime soon, just to make the requirements more and more complex ;).
– NBK
Jul 31 at 17:50
add a comment |Â
@NBK If you actually use this method let me know how it works out. Comment here, or find my email (easy).
– Ethan Bolker
Jul 31 at 1:03
it did work, thank you. I created many random series of three teams and then chose the triplets with the same average skill. An additional problem me and a friend are trying to solve is how to use past match scores of teams to assess the individual skill of players in a non-tautological way. I may formulate a new question sometime soon, just to make the requirements more and more complex ;).
– NBK
Jul 31 at 17:50
@NBK If you actually use this method let me know how it works out. Comment here, or find my email (easy).
– Ethan Bolker
Jul 31 at 1:03
@NBK If you actually use this method let me know how it works out. Comment here, or find my email (easy).
– Ethan Bolker
Jul 31 at 1:03
it did work, thank you. I created many random series of three teams and then chose the triplets with the same average skill. An additional problem me and a friend are trying to solve is how to use past match scores of teams to assess the individual skill of players in a non-tautological way. I may formulate a new question sometime soon, just to make the requirements more and more complex ;).
– NBK
Jul 31 at 17:50
it did work, thank you. I created many random series of three teams and then chose the triplets with the same average skill. An additional problem me and a friend are trying to solve is how to use past match scores of teams to assess the individual skill of players in a non-tautological way. I may formulate a new question sometime soon, just to make the requirements more and more complex ;).
– NBK
Jul 31 at 17:50
add a comment |Â
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f2866961%2fform-three-random-groups-satisfying-certain-parameters%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password