### Solver Options

**Max Time** - Sets the maximum amount of time that Solver will spend to try and find a valid solution.**Iterations** - Defines the limit of the number od attempts that Solver should use to try and find a satisfactory solution.**Precision** - This pertains to the constraints. The precision given here refers to the precision with with the constraints have to be met.**Tolerance** - This pertains to integer constraints. You should always try and find a solution without an integer constraint ?**Convergence** - Defines the amount of relative change to allow in the last five iterations before Solver stops with a solution.**Assume Liner Model** - This defines which algorithm to use to try and solve the model. Linear models are easier to solve.**Assume Non-Negative** - This ensures that all the decision variables which do not have a constraint attached to them have a lower bound of zero.**Use Automatic Scaling** - **Show Iteration Results** -

**Tangent** - Select when the model is linear.**Quadratic** - Select when the model is non linear.**Forward** - Selecting this option will potentially speed up Solver when the iterations are very slow due to the constraints.**Central** - This can be used to improve the accuracy when the cells which have constraints change by a large amount.**Newton** - This uses more memory but requires fewer iterations to obtain the solution.**Conjugate** - This uses less memory and should be used for more complicated and larger models. You may alos need to increase the number of iterations.

**Load Model** - **Save Model** -

#### Important

After you apply the "Keep Solver Solution" option, you cannot undo the changes to the cells.

This can also be used to find combinations of variables that may provide a maximum or minimum result.

You only need to add constraints to cells which are going to be changed.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited TopPrevNext