Solver

[Don Culp]

For the Solver, is there any way to determine how many times the target cell
has been evaluated, either the total number until the solution has converged
or the number for each iteration? (Note that this would not be the same as
the number of iterations, since there would likely be several target cell
evaluations for each iteration.) I want to use this to determine the
relative efficiency of the various search methods and other options.

Excel 97, W2K or XP

Thanks,
Don Culp

 

[bplumhoff]

Hi Don,

I would take FastExcel to measure and to compare the speed...

Regards,
Bernd

 

[Don Culp]

Bernd --

I need to know the total number of times that the target cell has been
evaluated. (This has to do with comparisons to other optimizers/solvers.)
The absolute speed is not the issue so FastExcel doesn't really give me what
I need.

Don Culp