I put together a simple spreadsheet that uses successive approximations to solve quadratic equations to illustrate what I am trying to do (something I picked up in an analytical chemistry class). I have a few spreadsheets where I use successive approximations in circular references (iteration enabled) to solve some equations, and the spreadsheet works very well. The only thing I wish I had was a way to tell how many iterations were used during the last calculate event to obtain the results.
When my computer was slower, I could watch the status bar while it counted off iterations, and I could get a rough idea of how many iterations it took, but now, my computer is so fast, I can see the status bar flicker, but I cannot tell if it took 10 or 100 iterations (my usual maxiteration setting). The goal would be to know if Excel terminated calculation because it reached maxiteration or if it determined that the spreadsheet had converged in fewer iterations.
Does anyone have any ideas for capturing the number of iterations from a calculate event?
Bookmarks