Good evening everyone, hope you are well.
I am trying to figure out a solution for the problem below:
1) assume we have 3 players in our team and 3 opponents in an upcoming tournament lets say.
2) each on of our players can have 1 opponent in a tournament. (no duplication of players or opponents)
3) assume that we know all the scores for all possible combination of players and opponents, i.e.
3.1) if player 1 plays with opponent 1 the score will be 15 for player 1
3.2) if player 1 plays with opponent 2 the score will be 16 for player 1
3.3) if player 1 plays with opponent 3 the score will be 17 for player 1
3.4) if player 2 plays with opponent 1 the score will be 10 for player 2
3.5) if player 2 plays with opponent 2 the score will be 11 for player 2
3.6) if player 2 plays with opponent 3 the score will be 12 for player 2
3.7) if player 3 plays with opponent 1 the score will be 18 for player 3
3.8) if player 3 plays with opponent 2 the score will be 19 for player 3
3.9) if player 3 plays with opponent 3 the score will be 25 for player 3
Question is, is there any way to automatically calculate (or populate the various scenarios) which opponent to assign to our players in order to have the maximum score for the team?
To be more clear, lets have a look at two different tournament scenarios:
Scenario 1:
player 1 plays with opponent 1 the score will be 15 for player 1
player 2 plays with opponent 2 the score will be 11 for player 2
player 3 plays with opponent 3 the score will be 25 for player 3
total team score = 15 + 11 + 20 = 51
Scenario 2:
player 1 plays with opponent 2 the score will be 16 for player 1
player 2 plays with opponent 3 the score will be 12 for player 2
player 3 plays with opponent 1 the score will be 18 for player 3
total team score = 16 + 12 + 18 = 46
As you can see scenario 1 is preferable cause it has more expected score than scenario 2. I need this to be automated in some way.
I also have the data in a table, columns have our player names, rows have opponent names, and respective cells have the score expected for our player.
I would really appreciate your help!
Thank you very much in advance for reading this.
I am trying to figure out a solution for the problem below:
1) assume we have 3 players in our team and 3 opponents in an upcoming tournament lets say.
2) each on of our players can have 1 opponent in a tournament. (no duplication of players or opponents)
3) assume that we know all the scores for all possible combination of players and opponents, i.e.
3.1) if player 1 plays with opponent 1 the score will be 15 for player 1
3.2) if player 1 plays with opponent 2 the score will be 16 for player 1
3.3) if player 1 plays with opponent 3 the score will be 17 for player 1
3.4) if player 2 plays with opponent 1 the score will be 10 for player 2
3.5) if player 2 plays with opponent 2 the score will be 11 for player 2
3.6) if player 2 plays with opponent 3 the score will be 12 for player 2
3.7) if player 3 plays with opponent 1 the score will be 18 for player 3
3.8) if player 3 plays with opponent 2 the score will be 19 for player 3
3.9) if player 3 plays with opponent 3 the score will be 25 for player 3
Question is, is there any way to automatically calculate (or populate the various scenarios) which opponent to assign to our players in order to have the maximum score for the team?
To be more clear, lets have a look at two different tournament scenarios:
Scenario 1:
player 1 plays with opponent 1 the score will be 15 for player 1
player 2 plays with opponent 2 the score will be 11 for player 2
player 3 plays with opponent 3 the score will be 25 for player 3
total team score = 15 + 11 + 20 = 51
Scenario 2:
player 1 plays with opponent 2 the score will be 16 for player 1
player 2 plays with opponent 3 the score will be 12 for player 2
player 3 plays with opponent 1 the score will be 18 for player 3
total team score = 16 + 12 + 18 = 46
As you can see scenario 1 is preferable cause it has more expected score than scenario 2. I need this to be automated in some way.
I also have the data in a table, columns have our player names, rows have opponent names, and respective cells have the score expected for our player.
I would really appreciate your help!
Thank you very much in advance for reading this.