Using Solver

graphics/microsoft46.gif

The Solver is similar to Goal Seek and scenarios, but provides more options to restrict the allowable range of values for different cells that can affect the goal. The Solver is an add-in program, which may need to be loaded using the Add-In command on the Tools menu. The Solver is useful for predicting how results might change over time based on different assumptions. For example, suppose you have sales goals and quotas for the next three months. The Solver can take the expectations and the current quotas for each month, and determine how sales quotas for all three amounts be adjusted to achieve the goal.

Use Solver

graphics/one_icon.jpg

Click the Tools menu, and then click Solver.

graphics/tow_icon.jpg

Select the target cell .

graphics/three_icon.jpg

Click an Equal To option, and then, if necessary, enter a value.

graphics/foure_icon.jpg

Select the range of cells the solver uses to compare against the target cell.

graphics/five_icon.jpg

Click Add.

graphics/six_icon.jpg

Enter specific cell reference and constraint, and then click Add. You can specify several cell constraints.

graphics/seven_icon.jpg

Click OK.

graphics/eight_icon.jpg Click Solve.

If the Solver finds a solution, the Solver Results dialog box appears.

graphics/nine_icon.jpg

Click the Keep Solver Solution option.

graphics/ten_icon.jpg

Click a report type.

graphics/leven_icon.jpg

Click OK.

graphics/11inf12.jpg

graphics/11inf13.jpg

graphics/11inf14.jpg

graphics/11inf15.jpg

graphics/11inf16.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net