emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* Determine min/max values in a table
@ 2017-08-02 12:07 Karl Voit
  2017-08-02 14:56 ` Finding calc/elisp methods (was: Determine min/max values in a table) Karl Voit
                   ` (2 more replies)
  0 siblings, 3 replies; 9+ messages in thread
From: Karl Voit @ 2017-08-02 12:07 UTC (permalink / raw)
  To: emacs-orgmode

Hi!

How can I determine minimum and/or maximum value of a table?

Here is my example:

#+NAME: myvalues
| Values |
|--------|
|      4 |
|      2 |
|      3 |
|      7 |
|      5 |
|      6 |

| Min    | Max    | Average | First | Last |
|--------+--------+---------+-------+------|
| #ERROR | #ERROR |     4.5 |     4 |    6 |
#+TBLFM: @2$1='(min (remote(myvalues,@2$1..@>$1)))::@2$2='(max (remote(myvalues,@2$1..@>$1)))::@2$3=vmean(remote(myvalues,@2$1..@>$1))::@2$4=remote(myvalues,@2$1)::@2$5=remote(myvalues,@>$1)

My goal is to get min==2 in the first column and max==7 in the
second.

-- 
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] 9+ messages in thread

end of thread, other threads:[~2017-08-15 16:57 UTC | newest]

Thread overview: 9+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2017-08-02 12:07 Determine min/max values in a table Karl Voit
2017-08-02 14:56 ` Finding calc/elisp methods (was: Determine min/max values in a table) Karl Voit
2017-08-02 18:02   ` Finding calc/elisp methods Nick Dokos
2017-08-02 18:22   ` Adonay Felipe Nogueira
2017-08-03  9:58   ` Adam Porter
2017-08-02 21:22 ` Determine min/max values in a table Thierry Banel
2017-08-03  9:53   ` Adam Porter
2017-08-05 21:20     ` Karl Voit
     [not found] ` <c1ddc30d7673477da50fa40d6d00ac2d@HE1PR01MB1898.eurprd01.prod.exchangelabs.com>
2017-08-15 16:57   ` Finding calc/elisp methods Eric S Fraga

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