[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Help on spreadsheet/calc references and improvements
From: |
Michael Brand |
Subject: |
Re: [O] Help on spreadsheet/calc references and improvements |
Date: |
Sat, 5 Oct 2013 17:16:27 +0200 |
Hi Karl
On Sat, Oct 5, 2013 at 4:49 PM, Karl Voit <address@hidden> wrote:
> Feel free to make suggestions how to overcome my lack of knowledge
You may want to look at the example "$3 = remote(FOO, @@#$2)" in the
Org manual, then it becomes quite simple.
> #+NAME: Data23vert
> | Descr+ | Data1+ | Data2+ |
> |--------+--------+--------|
> | foo | 12 | 10 |
> | bar | 22 | 24 |
> | baz | 16 | 17 |
> |--------+--------+--------|
> | sum | 50 | 51 |
>
> #+NAME: Calc23vert-WISH
> | Descr | Data2 | Double |
> |-------+-------+---------|
> | foo | 10 | 20 |
> | bar | 24 | 48 |
> | baz | 17 | 34 |
> |-------+-------+---------|
> | sum | 51 | 102 |
> #+TBLFM: FIXXME
#+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)
> #+NAME: Data23horiz
> | Descr+ | foo | bar | baz | sum |
> |--------+-----+-----+-----+-----|
> | Data1+ | 12 | 22 | 16 | 50 |
> | Data2+ | 10 | 24 | 17 | 51 |
>
> #+NAME: Calc23horiz-WISH
> | Descr | foo | bar | baz | sum |
> |---------+-----+-----+-----+-----|
> | Data2 | 10 | 24 | 17 | 51 |
> | Double | 20 | 48 | 34 | 102 |
> #+TBLFM: FIXXME
#+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$$#)
Michael