How can one use "optimizers" to solve linear, nonlinear, and integer programs within spreadsheets?
How can one use "optimizers" to solve linear, nonlinear, and integer programs within spreadsheets?
The major PC-based spreadsheets used today, Lotus, Excel, and Quattro, all have built-in optimizers. These optimizers allow linear, nonlinear, and integer programs to be solved within the spreadsheet. This guide provides a step-by-step introduction to using the optimizer that is built into Microsoft Excel.