On Wednesday, 2 Aug 2017 at 14:56, Karl Voit wrote:
[...]
> However, let's make this thread a valuable one by adding a question:
> how does somebody find such things? Is there a source of information
> where I could find calc methods by "apropos" method together with
> elisp methods?
The calc i
Karl Voit writes:
> Leslie helped here by mentioning vmin/vmax which is that obvious
> that I do feel embarrassed now ;-)
>
> #+TBLFM:
> @2$1=vmin(remote(myvalues,@2$1..@>$1))::@2$2=vmax(remote(myvalues,@2$1..@>$1))::@2$3=vmean(remote(myvalues,@2$1..@>$1))::@2$4=remote(myvalues,@2$1)::@2$5=remot
Hi, you can find such information in the Calc Mode info pages:
[[info:calc]]
Avoid the commands between parenthesis which start with "calc-" because
these are actually Emacs Lisp procedures --- if you would really need to
use such, you would have to write the formula as a Emacs Lisp notation
and
Karl Voit writes:
> ...
> Leslie helped here by mentioning vmin/vmax which is that obvious
> that I do feel embarrassed now ;-)
>
> #+TBLFM:
> @2$1=vmin(remote(myvalues,@2$1..@>$1))::@2$2=vmax(remote(myvalues,@2$1..@>$1))::@2$3=vmean(remote(myvalues,@2$1..@>$1))::@2$4=remote(myvalues,@2$1)::@2$5
Hi,
* Karl Voit wrote:
>
> 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 |
>|++
