Home | GASolver | Download | Installation | Registration | Step by Step | Reference | Support | About Us | Contacts | EMail Us |
Yearstretch GASolver Reference |
Input Cell Value Range |
Input Cell Value RangeThe initial, or seed, range is the range of values allowed for the input, or changeable, cells. GASolver will start the search for a solution to your sheet by using input values from within the range you set. The setting of input ranges is crucial in minimising the time GASolver will take to reach a best solution. If your data set is large then it takes longer to locate better solutions. If you can narrow the area where those solutions may be found then GASolver can focus on more productive solutions earlier in the search. If your evolution times are long then it is this feature you should concentrate on to reduce them. If a long time passes without a better solution being found then GASolver can look at each of the input ranges and, if you have allowed it, gradually grow the allowed range of input values to expand the solution search area. We strongly recommend you also read Using Constraints and Performance Points. Performance point: 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' option. Performance point: For faster solutions you can check the 'use integers' option and GASolver will only generate integers which are faster to process than other number types. The initial input cell range is set for each individual variable in order to better tune the system to your requirements. To Use Default Initial Ranges:
To Estimate Initial Ranges from your data:
Note that this option does not include your current solution in the search. It only uses the current solution to set the boundaries of the search. To explicitly include the current solution in the search see Include current sheet values in the Solving Options section. To Modify An Initial Range:
Performance point: Range expansion is rather dangerous in that it can rapidly widen the space within which we are creating 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.
See also Using Constraints, Adding Constraints |
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 |