Home GASolver Download Installation Registration Step by Step Reference Support About Us Contacts EMail Us

Yearstretch GASolver Reference

Performance Points


Performance Points

This page contains tips concerning the speed performance of GASolver.

Input cell range

Estimating Initial Ranges from your data is a very efficient way of controlling the search as the effect of using this option is to commence the search in the area of your existing sheet solution from where you can allow it to widen as required.

The smaller the input cell range the faster the solver will work. The larger the seed range the better the chance of a solution. To get the best of both worlds however try setting a small a range as is practical and then check the 'grow range if required' option. Be careful here though and do not allow the range to grow to such values that widen the range so much that a solution may not be found in your lifetime! It is best to use the widen range only after a base solution has been located then GASolver can be used to widen a range can and so grow outwards from that base solution. To change the input cell properties click the input cell in the list on the main dialog.

integer working

For really fast solutions you can check the 'use only integer values' option and GASolver will only generate integers which are far faster to process than other number types. To change the input cell properties click the input cell in the list on the main dialog.

automatic range expansion

Range expansion is rather dangerous in that it can rapidly widen the space within which we are searching for solutions so it must be used with care. In fact it should only be used if one can start from a valid solution and then check the range expansion if no better one can be found. If searching for a first solution from scratch then do not use range expansion at all until a reasonable solution has first been located.

Constraints

Output cell constraints or Input cell limits? It is useful to appreciate the difference as limiting the input cell values is far faster than constraining the output cell values. Although there is no technical reason why you should not use 'output' constraints to limit input cell values we strongly recommend that, where possible, you use constraints only on output cells and limit input cell values by the method provided. See also Input Cell Conditioning.

Options

The smaller the 'target cell is within' value the more accurate the answer but the longer the solution time. The larger the convergence value the less accurate the answer but the shorter the solution time. To change the options click the Option button in the main dialog.

See also Version Variations.

 

Any questions or comments about this site or page should be addressed to gasolver@yearstretch.com

Copyright ©1995-2023 Yearstretch Limited. Legal and Privacy statements

Go to the top of the page