currently there are no functions in PlanMaker to return the number of iterations or the calculated difference to the old calculation.
The iterations are stopped when the differences to the last calculation run reach the limit given in File/Prefs/Calculate. The number of iterations is only a fail-safe limit in case this does not happen.
Yes I guessed that the number of iterations box was only a fail-safe-limit. I tried techniques like putting "=B2+1" in B2 along with the rest of the model, but the B2 counter would just run to whatever the limit was and reveal nothing about the rest of the model.
There are times when knowing how many iterations were needed to reach a certain limit can be useful - for example I have an algorithm for calculating sample size that uses that information. That is why I was asking.
Here is a solution for the equivalent problem in MS Excel posted on a MS newsgroup by "Charles":
I think this works, but I have not done exhaustive testing. Its a UDF that
will return the number of iterations.
The aCircularCell reference MUST reference one of the cells in the circular
It relies on the fact that Application.Iteration seems to be False in the
initial part of the calculation when Excel is determining if there are
circular references, and then Application.Iteration becomes true when Excel
has determined that there are circular references and has switched to its
algorithm for resolving circular references.
Not sure what happens if you have more than one circular chain!
Dim IterCount As Long
Public Function IterCounter(aCircularCell As Range)
Dim var As Variant
var = aCircularCell
If Not Application.Iteration Then
IterCount = 0
IterCount = IterCount + 1
IterCounter = IterCount
Could something like this be written for Planmaker?