optimize-roster-3.js

optimize-roster-3.js

function setSolution(solution) {
  // for each player
  for (var row = 1; row <= PLAYERS.getNumRows(); row++) {
    var playerId = PLAYERS.getCell(
      row,
      PLAYERS_PLAYER_COLUMN
    ).getValue();
    
    // set the selected column based on the optimization solution
    PLAYERS.getCell(
      row, 
      PLAYERS_SELECTED_COLUMN
    ).setValue(
      solution.getVariableValue(playerId)
    );
  }
}