On Wed, Jun 3, 2015 at 7:21 PM, Nick Dokos <ndo...@gmail.com> wrote: > | Date | Sys | Dia | Pul | Sugar | > |----------------------+--------+-------+-------+-------| > | [2014-04-27 Sun] | 125 | 88 | 78 | 92 | > | [2014-04-28 Mon] | 102 | 88 | 86 | 92 | > |----------------------+--------+-------+-------+-------| > | Averages: | 113.50 | 88.00 | 82.00 | 92.00 | > | Counts: | 2 | 2 | 2 | 2 | > | Maximums: | 125.00 | 88.00 | 86.00 | 92.00 | > | Medians: | | | | | > | Minimums: | | | | | > | Modes: | | | | | > | Standard Deviations: | | | | | > | Sums: | | | | | > |----------------------+--------+-------+-------+-------| > #+TBLFM: @>>>>>>>>$2..@>>>>>>>>$> = vmean(@I..@II);%.2f :: > @>>>>>>>$2..@>>>>>>>$> = vcount(@I..@II) :: @>>>>>>$2..@>>>>>>$> = > vmax(@I..@II);%.2f
I just found the Calc function apply() which leads to this simplification: | Date | Sys | Dia | Pul | Sugar | |------------------+--------+--------+--------+--------| | [2014-04-27 Sun] | 125 | 88 | 78 | 92 | | [2014-04-28 Mon] | 102 | 88 | 86 | 92 | |------------------+--------+--------+--------+--------| | vmean | 113.50 | 88.00 | 82.00 | 92.00 | | vcount | 2.00 | 2.00 | 2.00 | 2.00 | | vmax | 125.00 | 88.00 | 86.00 | 92.00 | | vmedian | 113.50 | 88.00 | 82.00 | 92.00 | | vmin | 102.00 | 88.00 | 78.00 | 92.00 | | vstdev | 0.00 | 0.00 | 0.00 | 0.00 | | vsum | 227.00 | 176.00 | 164.00 | 184.00 | |------------------+--------+--------+--------+--------| #+TBLFM: @>>>>>>>$2..@>$> = apply($1, @I..@II); %.2f Michael
