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.
