Excel 97 - Tables and Iteration (Circ References)

[Umfriend]

Dear all,

I guess I'm doing what I should not, but I don;t see another way
around it.

I have a model which based on a set of parameters performs
calculations. For each set of parameters, there is one result that
can't be solved analytically. I use iterations/circular references for
this.

It seems to work fine, but there is an issue when I use <Data><Table>
to create a table for each set of parameters. The thing is that I want
the iteration to work for each set, which it does, but need to ensure
that only if the iteration is done, that the actual result is taken
into the table. It *seems* it is taking the value of the iteration
belonging to the previous set of parameters.

As a side Q: Can I determine/influence which cell is used in the
iteration to get the approximation done? It is a circular, so I guess
it could be either? Is ther a way I can influence the step-size for an
iteration? Sometimes it doesn't get there because the steps it takes
are to small compared the lenght it needs to go (increasing maximum
number of iterations solves this, but I'd like to speed it up).

Hope someone can help with this.....

 

[Bernard Liengme]

Are you familiar with Solver?

 

[Umfriend]

Yes, I am familiar with both goal seek and solver and can program them
both to be used by VBA, but..... I need them to calculate not becuase
a button is pressed, but simply because one or more of the inputs are
changed.

 

[Umfriend]

Never mind, I got it all wrong. Sorry. Tables and iteration works
fine. Had to ensure that the iteration (or goal seek in effect)
adjusted it's estimate as I wanted to, not as it did by itself, which
was lousy

Thanks,
Umf