optimize-roster.js

optimize-roster.js

function optimizeRoster() {
  // this sets engine to an instance of Google's LP/MIP solver
  var engine = LinearOptimizationService.createEngine();
  
  // clear previous selections from the Players worksheet
  clearPreviousSelections();
  
  // add the variables (players and their salaries)
  // to the optimization problem
  addVariables(engine);
  
  // add the contraints that ensure that the correct number
  // of players are on the roster for each position
  addPositionConstraints(engine);
  
  // add the constraint to ensure that the total
  // of the salaries on the roster is under the salary cap
  addSalaryCapConstraint(engine);
  
  // solve the problem and set the solution
  var solution = engine.setMaximization().solve();
  
  // export the solution to the Players worksheet
  setSolution(solution);
  
  // copy the optimal roster to a new worksheet
  createRosterSheet();
}