For example OpenSolver ( OpenSolver for Excel) is an open-source add-in for Excel that complements the native Solver. If that happens, you might want to investigate other optimization engines.

In my experience, the Excel Solver works well for some problem formulations and not so well or not at all for others. I don't see any issues with your approach, and I encountered the same problems you mentioned. Clearly I am doing something wrong and need some help trying to understand how to model and solve this. But I run the model and it doesn't converge to any answers.

I know that if the 'changing cell' in solver is equal to the number 22, the model is solved. So I created a very simple solver model that aims to make the difference of the original contract (Cell F23) and the new contract (Cell N23) equal to ZERO, thus maintaing the total contract amount-makes sense right? And the solver should be changing cell P10 (which is a number that is being added to the quantity of ITEM 9, I do it this way because in the future I might want to try to change two or three items respectfully-always with the same goal: maintaining the total amount of the contract equal to cell F23. I am stuck at this simple (I believe it is simple *sighs*) solver problem.īasically I have a total amount of money in a contract which is cell F23 ($37,257,548.96) and I am trying to redistribute some quantities but maintaining the final TOTAL AMOUNT constant.

Excel solver function doesnt display