View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
driller driller is offline
external usenet poster
 
Posts: 740
Default precision in solver

Randi,

The solver solution will have acceptable results as to be dictated by the
sensitivity of your objective, below is a documentation from xls help file.

Degree of precision
In the Precision box, type the degree of precision that you want€” the
smaller the number, the higher the precision.

*IF-*
Solver cannot reach an optimal solution.
The following lists completion messages displayed by the Solver.
Solver cannot improve the current solution. All constraints are satisfied.
Only an approximate solution has been found, but the iterative process
cannot find a better set of values than those displayed. Either further
accuracy is not achievable, or the precision setting is too low.
Try changing the precision setting in the Solver Options dialog box to a
larger number, and then run the problem again.

regards,

"Randi" wrote:

Hi.. Does anyone know what the precision means when you run the solver? We
have to change the number from 0,000001 to 0,001 before solver could find an
optimal solution but I don't know how this affect the solution.
I hope someone can help us!