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@gmail.com - 08 Nov 2006 13:27 GMT
Hi Don,
I would take FastExcel to measure and to compare the speed...
Regards,
Bernd
Don Culp - 08 Nov 2006 14:32 GMT
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
> Hi Don,
>
> I would take FastExcel to measure and to compare the speed...
>
> Regards,
> Bernd