Re: [O] Table formula references

2017-04-02 Thread Manuel Schneckenreither
Thanks, I'll take a look. On Sun, Apr 2, 2017, 19:11 Michael Brand wrote: > Hi Manuel > > Not sure if I understand your formulas right, so check my solutions with > the formula debugger. > > On Thu, Mar 30, 2017 at 10:38 AM, Manuel Schneckenreither > wrote: > > > So @5$3 should be 0.9^0*127 + 0

Re: [O] Table formula references

2017-04-02 Thread Michael Brand
Hi Manuel Not sure if I understand your formulas right, so check my solutions with the formula debugger. On Thu, Mar 30, 2017 at 10:38 AM, Manuel Schneckenreither wrote: > So @5$3 should be 0.9^0*127 + 0.9^1*118 + 0.9^2*121 + 0.9^3*115. Emacs Calc has map with anonymous function and one or mor

Re: [O] Table formula references

2017-03-30 Thread Eric S Fraga
I thought the following would work but org seems to reorder the vector: | t | y_t | 0.9^t | y_{t+1} | |---+-++-| | 1 | 115 |0.9 | 0.9 | | 2 | 121 | 0.81 |2.52 | | 3 | 118 | 0.729 | 4.707 | | 4 | 127 | 0.6561 | 7.3314 | #+TBLFM: $3=0.9^$1::$4=(@2

[O] Table formula references

2017-03-30 Thread Manuel Schneckenreither
Hi, I'd like to use following formula on like this: | t | y_t | y_{t+1} | |---+-+-| | 1 | 115 | | | 2 | 121 | | | 3 | 118 | | | 4 | 127 | | $4 = \sum_{\tau=0}^{@#-2}{0.9^{\tau} * y_{@#-2-\tau}} So that's a simple sum, which just itera

[O] Table formula references

2017-03-30 Thread Manuel Schneckenreither
Hi, I'd like to use following formula on like this: | t | y_t | y_{t+1} | |---+-+-| | 1 | 115 | | | 2 | 121 | | | 3 | 118 | | | 4 | 127 | | $4 = \sum_{\tau=0}^{@#-2}{0.9^{\tau} * y_{@#-2-\tau}} So that's a simple sum, which just itera