optimize-roster-1.js

optimize-roster-1.js

function addPositionConstraints(engine) {
  // for each position
  for (var row = 1; row <= POSITIONS.getNumRows(); row++) {
    var position = POSITIONS.getCell(
      row,
      POSITIONS_POSITION_COLUMN
    ).getValue();
    var positionSpots = POSITIONS.getCell(
      row,
      POSITIONS_SPOTS_COLUMN
    ).getValue();
    
    // add a constraint that sets the number of spots
    // required for the position
    var constraint = engine.addConstraint(
      positionSpots,
      positionSpots
    );
    
    // for each player
    for (var playerRow = 1; playerRow <= PLAYERS.getNumRows(); playerRow++) {
      var player = PLAYERS.getCell(
        playerRow,
        PLAYERS_PLAYER_COLUMN
      ).getValue();
      var playerPosition = PLAYERS.getCell(
        playerRow,
        PLAYERS_POSITION_COLUMN
      ).getValue();
      
      // if the player plays the position
      if (playerPosition == position) {
        // add the player to the position contraint
        constraint.setCoefficient(player, 1);
      }
    }
  }
}