[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Determine min/max values in a table
From: |
Karl Voit |
Subject: |
[O] Determine min/max values in a table |
Date: |
Wed, 2 Aug 2017 14:07:18 +0200 |
User-agent: |
slrn/pre1.0.0-18 (Linux) |
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/
- [O] Determine min/max values in a table,
Karl Voit <=