Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about the Solver Addin
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question about the Solver Addin
Franz -
First of all - congrats on Italy winning the World Cup. 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. Thanks, Mark "Franz Verga" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver does not work from Macros | Setting up and Configuration of Excel | |||
Interesting Solver problem (Solver encounters an error) | Excel Discussion (Misc queries) | |||
Excel Solver Issue | Excel Discussion (Misc queries) | |||
Solver parameter constraint question | Excel Discussion (Misc queries) | |||
question on excel Solver | Excel Worksheet Functions |