help with a formula

[bradyj7]

Hi there,

I have three columns Time (t) Charge (Q) and Current (I).

The Time column contains second values 1,2,3 etc.

Q is defined as I * t.

Lets just say I is defined as Q * 2. The proper formula is too and would confuse things.

So for first time step I is given a value so Q can can be calculated. Then from Q, I can be calculated. Now for the next time step I want the new value for I to be used to calculate Q and then I again and so on

t	Q	                                    I	
1	1* 0.01(starting value for I)	0.01*2	
2	This should be 0.02 *2	        This should be 0.04*2	
3			.....                      ......
4			.....                      ......

I was trying to use the formular1c1 function, but I can't use it because I is need to calculate Q but it is in the following column.

Any suggestions on how to do this just using the simple example above?

Thank you

 

[Roseus]

Since your formula is a circular reference, the only approach I can think of is to have a single catalyst value, a pre-I value.

So you'd enter pre-I as .01.
Where t=1
Q=t*pre-I = .01
I=pre-I*2 = .02

Where t=2
Q=t*I(from row where t=1) = .04
I= Q*2 = .08

Where t=3
Q=t*I(from row where t=2) = .24
I= Q*2 = .48

And so on...

Does that help?

 

[bradyj7]

Hi thanks,

Any ideas as to how to write that in code? So I can try and modify to fit in what I have