O'Reilly logo

Ludwig's Applied Process Design for Chemical and Petrochemical Plants, 4th Edition by A. Kayode Coker, PhD

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix F

F.1 MICROSOFT EXCEL SOLVER FOR NON-LINEAR EQUATIONS

The Solver is an optimization package that finds a maximum, minimum, or specified value of a target cell by varying the values in one or several changing cells. It uses an iterative process, beginning with trial values of the coefficients. The value of each coefficient is changed by a suitable increment, the new value of the function is then calculated, and the change in the value of the function is used to calculate improved values for each of the coefficients. The process is repeated until the desired results are obtained. The Solver employs the gradient methods or the simplex method to find the optimum set of coefficients.

Constraints can be applied to the Solver using the Add ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required