"Chris" wrote:
I am trying to solve the equation
T=(11.4L^0.5)(K^0.52)(S^-0.318)(i^-0.38)
[....]

Is there an easy way to set this up in excel to
run an iterative process with a table?

Take a look at Solver (Tools Solver in Excel 2003).

You do not provide enough details for me to offer specific guidance. But as
an example, I set up the following model. Assume that T, L, K, S and i are
in B1 through B5 respectively. Set up the following formulas:

B1: =(11.4*B2^0.5)*(B3^0.52)*(B4^-0.318)*(B5^-0.38)

B6: =ABS(B2-B5)

In Solver, set Target to B6 "equal to min"; set the "by changing" list to
B2, B3, B4, B5; and set appropriate constraints for each cell in B2:B5.

Without sufficient information, I set the contraints to B2=1 and similarly
for B3:B5. Solver found the following solutions (all numbers are
approximate):

B1, T: 4.74556655
B2, L: 1.005004378
B3, K: 1.200421826
B4, S: 3.325846819
B5, i: 4.745566554
B6: 3.91799E-09


"i" is determined from a table based on time.

I suspect this can be accomplished with the use of some helper cells. I did
not bother to try. However, in my experience, Solver has difficulty with
discrete (i.e. non-continuous) variables. Caveat emptor!


----- original message -----

"Chris" wrote:
I am trying to solve the equation T=(11.4L^0.5)(K^0.52)(S^-0.318)(i^-0.38),
where "L, K & S" are constants and "i" is determined from a table based on
time. "T" is time in minutes. To solve the equation fully, once "T" is
solved for it is compared with the time value used in the table that "i" was
determined from. If necessary, a new value of "i" is determined and the
equation is solved again. This is repeated until an acceptable tolerance
between "T" and the value used to determine "i" is reached. Is there an easy
way to set this up in excel to run an iterative process with a table? Any
help would be greatly appreciated.