Re: [O] Help on spreadsheet/calc references and improvements

[Karl Voit]

* Michael Brand <address@hidden> wrote:
> Hi Karl

Hi!

> You may want to look at the example "$3 = remote(FOO, @@#$2)" in the
> Org manual, then it becomes quite simple.

:-)

I have to admit that I found @@#$2 in the manual. However, I was not
able to understand its meaning at all :-(

With your example below, I begin to understand it a bit. Thanks!

>> #+NAME: Data23vert
>> | Descr+ | Data1+ | Data2+ |
>> |--------+--------+--------|
>> | foo    |     12 |     10 |
>> | bar    |     22 |     24 |
>> | baz    |     16 |     17 |
>> |--------+--------+--------|
>> | sum    |     50 |     51 |
>
>| Descr | Data2 | Double |
>|-------+-------+--------|
>| foo   |    10 |     20 |
>| bar   |    24 |     48 |
>| baz   |    17 |     34 |
>|-------+-------+--------|
>| sum   |    51 |    102 |
> #+TBLFM: $2 = remote(Data23vert, @@#$3) :: $3 = 2 * remote(Data23vert, @@#$3)

May I add another example I cannot cope with?

| Descr | Current Data2+ | diff | abs.diff |
|-------+----------------+------+----------|
| foo   |              9 |   -1 |        1 |
| bar   |             20 |   -4 |        4 |
| baz   |             23 |   +6 |        6 |
|-------+----------------+------+----------|
| sum   |             52 |      |       11 |

$2 are manually entered values to compare Data2 from above. I still
have no idea how to adopt your reference example for $3 and $4.
Would you please help me one more time?

>> #+NAME: Data23horiz
>> | Descr+ | foo | bar | baz | sum |
>> |--------+-----+-----+-----+-----|
>> | Data1+ |  12 |  22 |  16 |  50 |
>> | Data2+ |  10 |  24 |  17 |  51 |
>
>| Descr  | foo | bar | baz | sum |
>|--------+-----+-----+-----+-----|
>| Data2  |  10 |  24 |  17 |  51 |
>| Double |  20 |  48 |  34 | 102 |
> #+TBLFM: @address@hidden = remote(Data23horiz, @3$$#) :: @address@hidden = 2 *
> remote(Data23horiz, @3$$#)

Helped me a lot, thanks! ("$$#" is not mentioned in the Org-manual at all.)

-- 
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
       > get Memacs from https://github.com/novoid/Memacs <

https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github