×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Excel Solver & nonlinear problems

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!

RE: Excel Solver & nonlinear problems

I have used Solver successfully numerous times, including on some highly 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

Has anybody else observed that many of these canned routines work great for about 95% of what you need to do, but to solve the truly hard problems, it seems inevitably I have to go back to writing my own codes so I can be certain what is happening and where the problems/tricks in the code are?

RE: Excel Solver & nonlinear problems

I forgot to offer an answer to the second part of your question.  I am aware of two products that claim to be "more sophisticated solver plugins".

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

I find that for reasonably complex problems, where the optimum result is governed by several non linearities, then a Genetic Algorithm approach is best. For instance, if you want to set up the optimum gearing in an automatic gearbox for fuel economy, you have to tune the shift schedule and the actual gear ratios in parallel.

Cheers

Greg Locock

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources