Thank you for the response Alf,

How would I change my model to allow this sensitivity analysis? Going off what you are saying, I would have to delete the "Selec" column and change my constraints. I am changing the constraints to the following: sum(E2:E12) = 1 to effectively force that constraint to be 1, the same for the rest of the positions.


One type of analysis I want to do would be changing the numbers for each position. I know I can change two positions most at one time, but I am not sure how to modify the model to show this. I was thinking of adding a cell called “Additional”, all the constraints for the number of each position is the sum of the number I would put like 2 and that cell. If i were to change the cell to 1 let's say, it would add a player to another position.

I also want to show a sensitivity analysis for salary if possible.


Trey