emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Calculate differences of remote table numbers
@ 2018-10-01 15:01 Karl Voit
  2018-10-01 16:36 ` Nick Dokos
  2018-10-05 17:46 ` Michael Brand
  0 siblings, 2 replies; 10+ messages in thread
From: Karl Voit @ 2018-10-01 15:01 UTC (permalink / raw)
  To: emacs-orgmode

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/

^ permalink raw reply	[flat|nested] 10+ messages in thread

end of thread, other threads:[~2018-10-12 21:49 UTC | newest]

Thread overview: 10+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2018-10-01 15:01 Calculate differences of remote table numbers Karl Voit
2018-10-01 16:36 ` 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

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).