Microsoft Excel Solver for Engineering Optimization

Excel Solver is a powerful tool for engineering optimization. This tutorial shows how to solve a simple benchmark problem with an objective function, inequality constraint, and an equality constraint.

[@upasanapadhi8419]

Thank you! Its very useful.

[@tyishayoung5953]

love challenges classic problems.

[@Modhumitamondal]

Nice info

[@CNCPRINTBLOGSPOT]

very good!

[@akshaysunil2852]

can we use this solver tool for dynamic programming in excel'

[@apm]

Yes, you could use it but only for simple cases such as this Excel example: apmonitor.com/pdc/index.php/Main/VehiclePredictiveControl This course teaches tools in Matlab and Python that are much more capable: apmonitor.com/do/

[@dineshkumarsaw8143]

can we solve 5 simultaneous linear equation with excel solver?

[@apm]

Yes, linear equations are easy: apmonitor.com/che263/index.php/Main/ExcelSolveEquations

[@dineshkumarsaw8143]

@@apm ohh sorry sir
its 5 simultaneous non linear equation with variable on both side of equality for example
a=1/a+1.2/b+1/c +3/c +1/d+ 2/e
b=1/a+1.2/b+ 1/c +3/c +1/d++ 2/e
...................................
e=1/a+1.2/b+ 1/c +3/c +1/d++ 2/e
can this type of equation can be solved using excle?

[@mkall]

very helpful

[@bim_engineer_structural]

Good

[@donblackwell5564]

Did not see the file for dowmloading

[@donblackwell5564]

Had to use the search bar

[@apm]

I'm glad that you found it. You can also visit the page apmonitor.com/che263/index.php/Main/ExcelSolver

[@mushai]

Not good for starters but thanks anyway.