Excel Solver & nonlinear problems
Excel Solver & nonlinear problems
(OP)
Hi all,
what kinds of experiences do you have when using the excel solver for nonlinear optimization tasks? For me, it seems that it doesn't work very reliably even in the case of quite simple target functions and boundary conditions.
Are there more sophisticated solver plugins?
Thanks for your comments!
what kinds of experiences do you have when using the excel solver for nonlinear optimization tasks? For me, it seems that it doesn't work very reliably even in the case of quite simple target functions and boundary conditions.
Are there more sophisticated solver plugins?
Thanks for your comments!





RE: Excel Solver & nonlinear problems
However for the latter you do need to give it starting conditions that are "reasonably" close to the ultimate answer. Otherwise it makes big jumps, which can either land you in an area where there is a local optimum which it will home in on, or in an area where one of your equations breaks down with (say) the square root of a negative number.
RE: Excel Solver & nonlinear problems
RE: Excel Solver & nonlinear problems
The first is from the same people that wrote the "free" solver that comes with Excel. They offer several premium versions. See www.solver.com for details.
The second is a product called "What'sBest". See www.lindo.com for info.
RE: Excel Solver & nonlinear problems
Cheers
Greg Locock
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.