team player 1 teqm player 2 team player 3

Solver is found in the Data, Analyze Tab. We should be able to get Solver to Minimise this value. Next add a Formula to Calculate the Sum of the Variations from Mean for each Team Solver will put a value of 1 when a Player is in a Team, and a 0 when the player is not in a Team. Next we need to distribute each player into one of 3 teams. Then calculate the Differences between the each players Score and the Average My initial though was to setup a Delta or Difference between each Players Score and the Mean (Average of all scores).įirst calculate the Average of All the Scores The question posed by Shenricus is to distribute the players into teams so that each team is “As even as possible”.Ĭonsidering that we have 24 players and need to put them into 3 teams, we will assume each team has the same number of players and hence requires 8 players. We have no other information as to the Sport or Score. The players are Ranked from Best to Worst. Shenricus gave us a list of 24 players and a score for each player. This post will examine the thought process used to derive the solution and then implement that using solver.Īs always a Sample file is provided so you can follow along: Download Sample File here. This caused me to reconsider my first attempt and finally I posted a Final Solution, which was also a Solver based solution, but was a much more robust solution than my original solution or Bosco Yip’s solution.

I answered with a Solver Based solution, and Bosco Yip also added to my solution with a slightly different approach. I’ve been trying to figure out how I can divide these names into 3 even teams – or as close as possible.” “I have 24 people who each have their own score. In April 2017, Shenricus, posed a question in the Forums:

Team player 1 teqm player 2 team player 3