From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Help on spreadsheet/calc references and improvements
Date: Sat, 5 Oct 2013 18:44:18 +0200
Message-ID: <CALn3zojK6+E25owJcrZdK=YTOsp4262xcHazDug50db+_E3=cA@mail.gmail.com>
References: <2013-10-05T16-39-57@devnull.Karl-Voit.at>
	<CALn3zogFRNTkxuryY-FU9aDNJF6iV+f92ez2+g1P8F9Xp08k1g@mail.gmail.com>
	<2013-10-05T18-02-18@devnull.Karl-Voit.at>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:44398)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1VSUxs-0005wL-GU
	for emacs-orgmode@gnu.org; Sat, 05 Oct 2013 12:44:29 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1VSUxn-0003FY-Gx
	for emacs-orgmode@gnu.org; Sat, 05 Oct 2013 12:44:24 -0400
Received: from mail-la0-x235.google.com ([2a00:1450:4010:c03::235]:52452)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1VSUxn-0003FQ-8c
	for emacs-orgmode@gnu.org; Sat, 05 Oct 2013 12:44:19 -0400
Received: by mail-la0-f53.google.com with SMTP id el20so4205309lab.40
	for <emacs-orgmode@gnu.org>; Sat, 05 Oct 2013 09:44:18 -0700 (PDT)
In-Reply-To: <2013-10-05T18-02-18@devnull.Karl-Voit.at>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: news1142@karl-voit.at
Cc: Org Mode <emacs-orgmode@gnu.org>

Hi Karl

On Sat, Oct 5, 2013 at 6:08 PM, Karl Voit <devnull@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