Page 345 - Excel for Scientists and Engineers: Numerical Methods
P. 345
322 EXCEL: NUMERICAL METHODS
When the Solver finds a solution, the Solver Results dialog box is displayed
(Figure 14-8). There are three reports that you can choose to print: Answer,
Sensitivity and Limits, but none of these reports contain any information that we
will use.
You have the option of accepting the Solver's solution or restoring the
original values. Press the Keep Solver Solution button. The spreadsheet will be
displayed with the final values of the changing and target cells (Figure 14-9).
Figure 14-9. The spreadsheet after optimization of coefficients by the Solver. The three
coefficients (the changing cells) and the objective (the target cell) are in bold.
