Sensitivity Analysis for Fantasy Football Selections

[treyweeks11]

Hi all and thank you for reading my first post,

I am creating an excel fantasy football model using solver to maximize the amount of points my fantasy football rosters scores. I have successful accomplished this, however now I am looking to create a what if sensitivity analysis by changing the variables of number of players picked (0-10 or more) and the salary constraint (0 - 100K or more). I am having difficulty with this aspect of the problem and have not been able to set up a table that works. I am not sure what I am doing wrong, is somebody able to help? I have attached the spreadsheet and am only looking to get the sensitivity analysis working.

Thank you!

Trey

[treyweeks11]

To clarify, I simply want to see how changing the variables of salary and total players selected affects and changes the output of maximized points. Is this possible? If not, I really want to see how changing the amount of players selected affects the total points.