emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Karl Voit <devnull@Karl-Voit.at>
To: emacs-orgmode@gnu.org
Subject: Re: Help on spreadsheet/calc references and improvements
Date: Sat, 5 Oct 2013 18:08:18 +0200	[thread overview]
Message-ID: <2013-10-05T18-02-18@devnull.Karl-Voit.at> (raw)
In-Reply-To: CALn3zogFRNTkxuryY-FU9aDNJF6iV+f92ez2+g1P8F9Xp08k1g@mail.gmail.com

* Michael Brand <michael.ch.brand@gmail.com> 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: @2$2..@2$5 = remote(Data23horiz, @3$$#) :: @3$2..@3$5 = 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

  reply	other threads:[~2013-10-05 16:08 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 [this message]
2013-10-05 16:44     ` Michael Brand
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=2013-10-05T18-02-18@devnull.Karl-Voit.at \
    --to=devnull@karl-voit.at \
    --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).