Excel Solver

Copper Contributor

Hello. I am trying to figure out how to set exposure levels in solver.

 

For example. I have 200 players with a point projection attached to each of them. I have constraints set up to return the highest projected combination of points among 9 players given salary restraints.

 

Player A priced at 5000 and projected for 30 points.

 

Anyways. I already have it to build multiple combinations, each one .01 points lower or more than the previous. I would like to set exposure levels in though.

 

Of the 200 players, I want player A to be in at least 3 of the 20 combinations. I am able to set it so they return in a max number of combinations, but have no idea how to read the entire 20 and say Player A must be in at least 3 of these.

 

Any help would be awesome.

0 Replies