Calculate differences of remote table numbers

[Karl Voit <devnull@Karl-Voit.at>]

Hi!

I'd like to calculate the differences between rows of numbers of a
different table.

Here is a minimal example showing the issue:

    #+NAME: my-table
    | Numbers |
    |---------|
    |       1 |
    |       5 |
    |       8 |
    |      12 |
    |      15 |

This is what I expected: "exp. Reference1" and "exp. Reference2" is here only
to demonstrate that the assumed references are wrong in the third table. "exp.
Difference" is the column I want to get in the first place. I don't want to see
Reference 1 or 2 at all in my solution (since I need a couple of those
difference-columns).

    | Line | exp. Reference1 | exp. Reference2 | exp. Difference |
    |------+-----------------+-----------------+-----------------|
    |    1 |               0 |               0 |               0 |
    |    2 |               5 |               1 |               4 |
    |    3 |               8 |               5 |               3 |
    |    4 |              12 |               8 |               4 |
    |    5 |              15 |              12 |               3 |

This is what I get instead:

    | Line | actual Reference1 | actual Reference2 | Difference |
    |------+-------------------+-------------------+------------|
    |    1 |                 0 |                 0 |          0 |
    |    2 |                 6 |                 1 |          5 |
    |    3 |                12 |                 1 |         11 |
    |    4 |                20 |                 1 |         19 |
    |    5 |                30 |                 1 |         29 |
    #+TBLFM: $2=if(2 == @#, 0, remote(my-table,@#$1))::$3=if(2 == @#, 0, remote(my-table,@#-1$1))::$4=if(2 == @#, 0, (remote(my-table,@#$1)-remote(my-table,@#-1$1)))

As you can see, the "actual Reference1" are not the values from the first
column above (except the first one). "actual Reference2" is not the shifted
column 1 from above (except the first one). I have no clue, what these numbers
are.

Maybe you can help me (1) explaining what the numbers in actual Reference1 and
actual Reference2 are showing and (2) how to get the result ("expected
Difference"; without explicitly generating Reference 1 or 2).

Thanks!


-- 
get mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML into Org-mode:
       > get Memacs from https://github.com/novoid/Memacs <
Personal Information Management > http://Karl-Voit.at/tags/pim/
Emacs-related > http://Karl-Voit.at/tags/emacs/