If you receive the message вЂњSolver could not find a feasible solution,вЂќ and the problem has no integer constraints, two variants of a diagnostic report, the Feasibility Report and Feasibility-Bounds Report, are available.If your model is intentionally nonlinear, you should select the GRG Nonlinear Solving method are re-solve the problem. This report can help you find cell formulas in your model that make the problem nonlinear (possibly by mistake). If you receive the message вЂњThe linearity conditions required by this LP Solver are not satisfied,вЂќ and the problem has no integer constraints, the Linearity Report is available.Reports available when Solver encounters a problem If Solver finds a (locally or globally) optimal solution, and there are no integer constraints, two additional reports are available: the Sensitivity Report and the Limits Report.

When the Evolutionary Solving method is used, its Population Report is also available.

In almost all cases where Solver finds an optimal solution, Solver converges to the current solution, or Solver cannot improve the current solution, the Answer Report is available.

Reports available when Solver finds a solution The reports you selected appear as new worksheets, inserted into your Excel workbook just to the left of the worksheet containing the Solver model. Select any other options you want in the Solver Results dialog box, and click OK.

Outlining groups the variables and constraints in the reports into вЂњblocks,вЂќ just as you entered them in the Solver Parameters dialog you can expand or collapse the groups to see only the information you want.ДЈ. Select the Outline Reports check box if you would like Solver to use ExcelвЂ™s outlining feature in the reports.

If the solving process stopped prematurely when you pressed ESC or selected Stop when a Solving limit was reached, no reports are available.Дў. A list of reports appears in the Reports box of the Solver Results dialog box.

How to add solver excel mac