Forum Discussion
sbauer40
Mar 13, 2023Copper Contributor
Excel Solver Question
Hi Everyone, this question pertains specifically to the built in solver function.
I have built a linear program that, with one set of hard-coded inputs, yields an optimal answer and satisfied linearity. When I put in different inputs however, without changing the constraints or formulas, I do not meet the linearity requirements of the model. I've been combing through the model but have been unable to figure out what could be causing this.
- JoeUser2004Bronze Contributor
To paraphrase Uncle Ben's advice to Spider-Man: "With great details come great answers".
And "if a picture is worth a thousand words, an Excel file is worth a thousand pictures".