optimize-roster-2.js

optimize-roster-2.js

function addSalaryCapConstraint(engine)  {
  // add a constraint for the overall salary cap
  var salaryCapConstraint = engine.addConstraint(0, SALARY_CAP);

  // for each player
  for (var row = 1; row <= PLAYERS.getNumRows(); row++) {
    var player = PLAYERS.getCell(
      row,
      PLAYERS_PLAYER_COLUMN
    ).getValue();
    var playerSalary = PLAYERS.getCell(
      row,
      PLAYERS_SALARY_COLUMN
    ).getValue();

    // add the player's salary to the constraint
    salaryCapConstraint.setCoefficient(player, playerSalary);
  }
}