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

[Michael Brand]

Hi Karl

On Sat, Oct 5, 2013 at 6:08 PM, Karl Voit <devn...@karl-voit.at> wrote:
> | 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?

Here you are:

#+NAME: Data23vert
| Descr+ | Data1+ | Data2+ |
|--------+--------+--------|
| foo    |     12 |     10 |
| bar    |     22 |     24 |
| baz    |     16 |     17 |
|--------+--------+--------|
| sum    |     50 |     51 |

| Descr | Current Data2+ | diff | abs.diff |
|-------+----------------+------+----------|
| foo   |              9 |   -1 |        1 |
| bar   |             20 |   -4 |        4 |
| baz   |             23 |    6 |        6 |
|-------+----------------+------+----------|
| sum   |             52 |      |       11 |
#+TBLFM: $3 = $2 - remote(Data23vert, @@#$3) :: $4 = abs($3) :: @5$3 =
string("") :: @5$4 = vsum(@I..@II)

Or use
$4 = abs($2 - remote(Data23vert, @@#$3))
if you prefer.

Michael