Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Solver

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Don Culp - 08 Nov 2006 10:01 GMT
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

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.