p**********l 发帖数: 1160 | 1 Has anybody used the Solver function in Excel?
If you do, can you share the experience?
I have googled and it seems that Solver is a very powerful tool and we want
to use it for optimization projects.
If you want to share something about optimization and the methods you have
known, especially in SAS, I would appreciate that too. | s*****9 发帖数: 108 | 2 I have used excel solver for some simple optimization problems. Constraints
are linear, it's good to use that for illustration of how optimization
solver works. When the number of variables goes large, I use SAS/OR,
commands like "solve with nlpc " etc. | p**********l 发帖数: 1160 | 3 thank you so much.
Constraints
【在 s*****9 的大作中提到】![](/moin_static193/solenoid/img/up.png) : I have used excel solver for some simple optimization problems. Constraints : are linear, it's good to use that for illustration of how optimization : solver works. When the number of variables goes large, I use SAS/OR, : commands like "solve with nlpc " etc.
|
|