Re: searching for csv utilities

[Jonathan Leech-Pepin <jonathan.leechpepin@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 1798 bytes --]

Hello,

On 2 June 2015 at 07:44, Jude DaShiell <jdashiel@panix.com> wrote:

> | Date             |               Sys | Dia | Pul | Sugar |
> |------------------+-------------------+-----+-----+-------|
> | [2014-04-27 Sun] |               125 |  88 |  78 |    92 |
> | [2014-04-28 Mon] |               102 |  88 |  86 |    92 |
> | Averages:        | =$2=vmean(@<..@>) |     |     |       |
> #+TBLFM: $2=$2=vmean(@<..@>)
>

The formula in question is the culprit in this case (at least as stated
there).

: $2=$2=vmean(@<..@>)

Second column is equal to the second column which is equal to the mean of
all the values in the second column (including the header "Sys").

If you change the table as follows:

| Date             |   Sys | Dia | Pul | Sugar |
|------------------+-------+-----+-----+-------|
| [2014-04-27 Sun] |   125 |  88 |  78 |    92 |
| [2014-04-28 Mon] |   102 |  88 |  86 |    92 |
|------------------+-------+-----+-----+-------|
| Averages:        | 113.5 |  88 |  82 |    92 |
#+TBLFM: @>$2..@>$>=vmean(@I..@II)

All the values will properly compute.  If you want to avoid the second
HLINE above Averages: then change =@II= to =@>>= (penultimate row)

Regards,
Jon


> This is a cut down version of my full record set.  Sometimes when I key
> formulas in I get ?ERROR back for a result after keying in c-c+c-c once
> I've completed the formula and hit tab.  If I do c-u+c-c+c-c that sometimes
> generated ?ERROR.  Other times I key in a formula and the cursor gets
> locked and I have to hit c-g to exit #+TBLFM: mode; I don't know what's
> actually happening when that situation arises since other than suddenly
> finding the cursor locked I can neither tell what state I'm in or if a few
> more keystrokes are needed or if I've generated an error situation.
>
>  --
>
>
>

[-- Attachment #2: Type: text/html, Size: 2589 bytes --]