Iterative Calculations??
Iterative Calculations??
(OP)
Take a look at the attached worksheet. The only two values changing are highlighted. To solve this problem takes an iterative process. First guessing the first highlighted value and back-checking against the second highlighted value. The solution occurs at the point where the two values are equal. I know there has to be a way to automate this.
Can anyone help me?
Can anyone help me?





RE: Iterative Calculations??
RE: Iterative Calculations??
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Iterative Calculations??
More questions:
Since I created an ~11 step calculation loop, does that mena I have to "Find" all 11 values (i.e. Find(a,b,c,d,e,f,g...)? Is there an easier way to repeat the calcuation loop and minimize the error between the two highlighted values?
I appreciate the input.
RE: Iterative Calculations??
RE: Iterative Calculations??
Are you asking how to calculate the coefficients for
HN=c0+c1*QN+c2*QN^2+c3*QN^3
?
What are you iterating and changing?
RE: Iterative Calculations??
RE: Iterative Calculations??
That's all you need to do.
TTFN
FAQ731-376: Eng-Tips.com Forum Policies