Using solver to pick optimal basketball lineup

[JesseM]

I am trying to use Solver to optimize a daily fantasy basketball lineup. I have (hopefully) attached the file here. Here are the basics:

• I have 28 columns in the top table for 28 possible players (10 guards, 10 forwards, 8 centers)
• Each column has a player ID#, name, salary and projected points (among other things)
• In the bottom table, I have rows representing an actual lineup of 8 players (2 guards, 2 forwards, 1 center and 3 "flex" players who can be any of the three positions).
• I created the ID# so I could use the Solver to test different players. I used HLOOKUP to pull the player name, salary and proj. pts. based on the ID from the top table into the bottom table.
• I set the solver to max the total points with the total salary being <= 50,000. I set the constraints for the ID based on the position (ex. the guard slots must use ID of 1 to 10) and used a unique value counter to count unique ID's in the lineup, then constrained that value to equal 8 (so there are no duplicate players selected.

Everything seems to make sense to me, but the solver only goes through 5 iterations (or runs into an error under non-evolutionary methods) and doesn't satisfy all the constraints.

Any help would be appreciated. Thanks.