View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Franz Verga Franz Verga is offline
external usenet poster
 
Posts: 459
Default Question about the Solver Addin

Mark wrote:
Franz -

First of all - congrats on Italy winning the World Cup.


It was hard, but we did... :-)

The model doesn't have anything changing from run to run.

I'm sure the model has multiple solutions. But given the multiple
solution model, is there a way to make Solver produce the same
solution run after run, assuming no changes to input?

I thought using the same inital values (run after run) in the "By
Changing Cells" would do the trick. On the tests that I have run
since I wrote this question, keeping the same initial values, has
done the trick. So maybe this is the answer.

It would be nice to get confirmation.



Yes, if the model has multiple solutions, to have always the same result you
have to use the same initial values.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy