View Single Post
  #2   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:
How can I make the solver produce the same solution (i.e., "By
Changing Cells") run after run assuming no change to the underlying
data?

Maybe by solver's nature this is impossible.

The model is fairly simple. At one point I thought if the initial
values in the "By Changing Cells" remained the same, the final
solution (i.e., in "By Changing Cells) would be unchanged assuming no
changes to the underlying data. This however does not seem to be true.

Thanks for your comments.

Mark



Hi Mark,

Are you sure that nothing change in your model?

Maybe you have a cell that use the NOW() function: try to replace it with
TODAY().

Maybe you have some cells with RAND() function: replace the function with
values (copy & past special, values).

Or maybe your problem has more than one solution...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy