I managed to get the worksheet to produce the desired answer, however, there is a chicken and egg problem which makes simply filling across and down not possible. This stems from the dependency of one cell on another.

Does anyone see how to rearrange the calculations so that I can do a simple fill down?

Thanks,

Art

Book3 | |||||||||
---|---|---|---|---|---|---|---|---|---|

A | B | C | D | E | F | G | |||

4 | q | 0.02 | |||||||

5 | data | P(t)(t-1) | P(t) | g(t) | ln(P) | lambda | a(t)fw | ||

6 | 5.6 | 0 | =$A$6 | 0 | 0 | 0 | =$A$6 | ||

7 | 4.86 | =C6+q | =(1+B7^(-1))^(-1) | =1+B7 | =LN(D7) | =1/(1+B7) | =F7*G6+(1-F7)*A7 | ||

8 | 5.1 | =C7+q | =(1+B8^(-1))^(-1) | =1+B8 | =LN(D8) | =1/(1+B8) | =F8*G7+(1-F8)*A8 | ||

9 | 5.35 | =C8+q | =(1+B9^(-1))^(-1) | =1+B9 | =LN(D9) | =1/(1+B9) | =F9*G8+(1-F9)*A9 | ||

10 | 5.65 | =C9+q | =(1+B10^(-1))^(-1) | =1+B10 | =LN(D10) | =1/(1+B10) | =F10*G9+(1-F10)*A10 | ||

11 | 5.6 | =C10+q | =(1+B11^(-1))^(-1) | =1+B11 | =LN(D11) | =1/(1+B11) | =F11*G10+(1-F11)*A11 | ||

12 | 5.63 | =C11+q | =(1+B12^(-1))^(-1) | =1+B12 | =LN(D12) | =1/(1+B12) | =F12*G11+(1-F12)*A12 | ||

Sheet1 |