emacs-orgmode
[Top][All Lists]

## [O] Table formula references

 From: Manuel Schneckenreither Subject: [O] Table formula references Date: Thu, 30 Mar 2017 10:38:20 +0200 User-agent: Gnus/5.13 (Gnus v5.13) Emacs/25.1 (gnu/linux)

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 = address@hidden * address@hidden So that's a simple sum, which just iterates over the values and uses the index for power and to get the value of y_{4-\tau}. So @5$3 should be
0.9^0*127 + 0.9^1*118 + 0.9^2*121 + 0.9^3*115. Shouldn't be too hard I
though, but I couldn't figure it out how to implement it using

As I need the index I tried using subscr with no success. I can
obviously generate the list of rows used for the calculation using
@address@hidden However, as soon as I use an elsip function in the formula I
struggle with the representation of the list:

#+TBLFM: $3='(mapcar '1+ (@address@hidden)) shows following debug output: Substitution history of formula Orig: '(mapcar '1+ (@address@hidden))$xyz->  '(mapcar '1+ (@address@hidden))
@r$c-> '(mapcar '1+ (#("1" 0 1 (fontified t line-prefix #("******* " 0 7 (face org-indent)) wrap-prefix #("******* " 0 8 (face org-indent)) face org-table)) #("115" 0 3 (fontified t line-prefix #("******* " 0 7 (face org-indent)) wrap-prefix #("******* " 0 8 (face org-indent)) face org-table))))$1->    '(mapcar '1+ (#("1" 0 1 (fontified t line-prefix #("******* " 0 7
(face org-indent)) wrap-prefix #("******* " 0 8 (face org-indent)) face
org-table)) #("115" 0 3 (fontified t line-prefix #("******* " 0 7 (face
org-indent)) wrap-prefix #("******* " 0 8 (face org-indent)) face org-table))))
Result: #ERROR
Format: NONE
Final:  #ERROR

Is there a simple way to do it? Do I need to go over elsip functions,
and if so. How can I properly use a list?

I couldn't find a way on the web.

Best regards

Manuel