emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Michael Brand <michael.ch.brand@gmail.com>
To: news1142@karl-voit.at
Cc: Org Mode <emacs-orgmode@gnu.org>
Subject: Re: Help on spreadsheet/calc references and improvements
Date: Sat, 5 Oct 2013 18:44:18 +0200	[thread overview]
Message-ID: <CALn3zojK6+E25owJcrZdK=YTOsp4262xcHazDug50db+_E3=cA@mail.gmail.com> (raw)
In-Reply-To: <2013-10-05T18-02-18@devnull.Karl-Voit.at>

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

  reply	other threads:[~2013-10-05 16:44 UTC|newest]

Thread overview: 23+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2013-10-05 14:49 Help on spreadsheet/calc references and improvements Karl Voit
2013-10-05 15:16 ` Michael Brand
2013-10-05 16:08   ` Karl Voit
2013-10-05 16:44     ` Michael Brand [this message]
2013-10-06 11:30 ` Karl Voit
2013-10-06 17:03   ` Michael Brand
2013-10-06 18:31     ` Karl Voit
2013-10-06 19:38       ` Michael Brand
2013-10-06 20:06         ` Karl Voit
2013-10-06 20:51           ` Michael Brand
2013-10-18 19:07     ` Michael Brand
2013-10-23 15:12       ` Michael Brand
2013-10-24  6:18         ` Carsten Dominik
2013-10-24 20:47           ` Michael Brand
2013-10-25 10:56             ` Nicolas Goaziou
2013-10-25 13:30               ` Carsten Dominik
2013-10-25 17:03                 ` Nicolas Goaziou
2013-10-25 13:31             ` Carsten Dominik
2013-10-30 17:59               ` Michael Brand
2013-11-13 17:27                 ` Michael Brand
2013-11-13 17:34                   ` Bastien
2013-11-13 19:42                     ` Michael Brand
2013-11-13 23:21                       ` Bastien

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to='CALn3zojK6+E25owJcrZdK=YTOsp4262xcHazDug50db+_E3=cA@mail.gmail.com' \
    --to=michael.ch.brand@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=news1142@karl-voit.at \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).