Standard Excel Solver - Messages in the Solver Results Dialog (1-3)

Messages in the Solver Results Dialog (1-3)

Solver has converged to the current solution. All constraints are satisfied. (1) 

This message appears only when Assume Linear Model is not checked (i.e. the GRG Solver engine is used). It means that the Solver stopped because the objective function value is changing very slowly for the last few iterations or trial solutions. More precisely, the GRG Solver stops if the absolute value of the relative change in the objective function is less than the Convergence tolerance in the Solver Options dialog for the last few iterations.

A poorly scaled model is more likely to trigger this stopping condition, even if the Use Automatic Scaling box in the Solver Options dialog is checked. If you are sure that your model is well scaled, you should consider why it is that the objective function is changing so slowly. For more information, click on GRG Solver Stopping Conditions.

Solver cannot improve the current solution. All constraints are satisfied. (2) 

This message appears only when Assume Linear Model is not checked (i.e. the GRG Solver engine is used), and occurs only rarely. It means that the model is degenerate and the Solver is probably cycling. One possibility worth checking is that some of your constraints are redundant, and should be removed. For more information, click on GRG Solver Stopping Conditions.

Stop chosen when the maximum iteration limit was reached. (3)

This message appears when (i) the Solver has completed the maximum number of iterations, or trial solutions, allowed in the Iterations box in the Solver Options dialog and (ii) you clicked on the Stop button when the Solver displayed the Show Trial Solution dialog.

You may increase the value in the Iterations box (to a maximum of 32767) or click on Continue instead of Stop in the Show Trial Solution dialog. But you should also consider whether re-scaling your model or adding constraints might reduce the total number of iterations required. For more information, click on Standard Excel Solver:  Improving Slow Solution Times.

Next Solver Results Message >

< Previous Solver Results Message

< Back to Standard Excel Solver:  Help with Specific Solver Messages

< Back to Standard Excel Solver Support Information

 

To Learn More: For instant access to our white papers, example models, full-text User Guides, and to download free 15-day trial versions of our software products whenever you're ready, register now with no obligation.

User type Please Select Commercial User Consultant Corp Developer Govt/Military Professor Student VAR/ISV Firm Email address Name First Last Company University Phone

Trial version passwords are sent to the above email address. Our Privacy Policy protects you.