From: Karl Voit <devnull@Karl-Voit.at>
To: emacs-orgmode@gnu.org
Subject: Calculate differences of remote table numbers
Date: Mon, 1 Oct 2018 17:01:08 +0200 [thread overview]
Message-ID: <2018-10-01T16-59-13@devnull.Karl-Voit.at> (raw)
Hi!
I'd like to calculate the differences between rows of numbers of a
different table.
Here is a minimal example showing the issue:
#+NAME: my-table
| Numbers |
|---------|
| 1 |
| 5 |
| 8 |
| 12 |
| 15 |
This is what I expected: "exp. Reference1" and "exp. Reference2" is here only
to demonstrate that the assumed references are wrong in the third table. "exp.
Difference" is the column I want to get in the first place. I don't want to see
Reference 1 or 2 at all in my solution (since I need a couple of those
difference-columns).
| Line | exp. Reference1 | exp. Reference2 | exp. Difference |
|------+-----------------+-----------------+-----------------|
| 1 | 0 | 0 | 0 |
| 2 | 5 | 1 | 4 |
| 3 | 8 | 5 | 3 |
| 4 | 12 | 8 | 4 |
| 5 | 15 | 12 | 3 |
This is what I get instead:
| Line | actual Reference1 | actual Reference2 | Difference |
|------+-------------------+-------------------+------------|
| 1 | 0 | 0 | 0 |
| 2 | 6 | 1 | 5 |
| 3 | 12 | 1 | 11 |
| 4 | 20 | 1 | 19 |
| 5 | 30 | 1 | 29 |
#+TBLFM: $2=if(2 == @#, 0, remote(my-table,@#$1))::$3=if(2 == @#, 0, remote(my-table,@#-1$1))::$4=if(2 == @#, 0, (remote(my-table,@#$1)-remote(my-table,@#-1$1)))
As you can see, the "actual Reference1" are not the values from the first
column above (except the first one). "actual Reference2" is not the shifted
column 1 from above (except the first one). I have no clue, what these numbers
are.
Maybe you can help me (1) explaining what the numbers in actual Reference1 and
actual Reference2 are showing and (2) how to get the result ("expected
Difference"; without explicitly generating Reference 1 or 2).
Thanks!
--
get mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML into Org-mode:
> get Memacs from https://github.com/novoid/Memacs <
Personal Information Management > http://Karl-Voit.at/tags/pim/
Emacs-related > http://Karl-Voit.at/tags/emacs/
next reply other threads:[~2018-10-01 15:01 UTC|newest]
Thread overview: 10+ messages / expand[flat|nested] mbox.gz Atom feed top
2018-10-01 15:01 Karl Voit [this message]
2018-10-01 16:36 ` Calculate differences of remote table numbers Nick Dokos
2018-10-04 7:25 ` Karl Voit
2018-10-04 16:37 ` Nick Dokos
2018-10-05 17:46 ` Michael Brand
2018-10-08 15:19 ` Karl Voit
2018-10-08 15:50 ` Eric S Fraga
2018-10-08 16:16 ` Complexity of using spreadsheet functionality (was: Calculate differences of remote table numbers) Karl Voit
2018-10-09 5:34 ` Complexity of using spreadsheet functionality Eric S Fraga
2018-10-12 21:48 ` Complexity of using spreadsheet functionality (was: Calculate differences of remote table numbers) Samuel Wales
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=2018-10-01T16-59-13@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).