How to: Solve a Model

After you bind data to parameters and decisions and configure goals, constraints, and directives, you can validate and solve the model. Then, you can read the summary, solver execution details, and the stochastic and sensitivity reports.

To validate the model

  1. In the Solver Foundation ribbon, click Check.

  2. In the Modeling Pane, review the log to verify that there are no errors.

To solve the model

  1. In the Solver Foundation ribbon, click Solve.

  2. In the Modeling Pane, review the log to verify that there are no errors.

To view the summary

  1. In the Solver Foundation ribbon, click Summary.

    Excel changes the focus to the Solver Foundation Summary worksheet.

  2. Review the summary report.

See Also

Concepts

Modeling in Excel