From mboxrd@z Thu Jan 1 00:00:00 1970 From: Jonathan Leech-Pepin Subject: Re: searching for csv utilities Date: Tue, 2 Jun 2015 08:04:20 -0400 Message-ID: References: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001a11473da2529e76051787bf60 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:54298) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Yzkw3-0006bs-V3 for emacs-orgmode@gnu.org; Tue, 02 Jun 2015 08:04:48 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Yzkvy-0003Ta-3s for emacs-orgmode@gnu.org; Tue, 02 Jun 2015 08:04:47 -0400 Received: from mail-qg0-x22b.google.com ([2607:f8b0:400d:c04::22b]:35626) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Yzkvx-0003TB-V4 for emacs-orgmode@gnu.org; Tue, 02 Jun 2015 08:04:42 -0400 Received: by qgg60 with SMTP id 60so57662122qgg.2 for ; Tue, 02 Jun 2015 05:04:41 -0700 (PDT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Jude DaShiell Cc: Org Mode Mailing List --001a11473da2529e76051787bf60 Content-Type: text/plain; charset=UTF-8 Hello, On 2 June 2015 at 07:44, Jude DaShiell 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. > > -- > > > --001a11473da2529e76051787bf60 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hello,

On 2 June 2015 at 07:44, Jude DaShiell <jdashiel@panix.com&= gt; wrote:
| Da= te=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Sys | Dia | Pul | Sugar |
|------------------+-------------------+-----+-----+-------|
| [2014-04-27 Sun] |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= 125 |=C2=A0 88 |=C2=A0 78 |=C2=A0 =C2=A0 92 |
| [2014-04-28 Mon] |=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= 102 |=C2=A0 88 |=C2=A0 86 |=C2=A0 =C2=A0 92 |
| Averages:=C2=A0 =C2=A0 =C2=A0 =C2=A0 | =3D$2=3Dvmean(@<..@>) |=C2= =A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0|=C2=A0 =C2=A0 =C2=A0 =C2=A0|
#+TBLFM: $2=3D$2=3Dvmean(@<..@>)

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

: $2=3D$2=3Dvmean(@<..@>)

Se= cond 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=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2= =A0 Sys | Dia | Pul | Sugar |
|------------------+-------+-----+-----+--= -----|
| [2014-04-27 Sun] |=C2=A0=C2=A0 125 |=C2=A0 88 |=C2=A0 78 |=C2= =A0=C2=A0=C2=A0 92 |
| [2014-04-28 Mon] |=C2=A0=C2=A0 102 |=C2=A0 88 |= =C2=A0 86 |=C2=A0=C2=A0=C2=A0 92 |
|------------------+-------+-----+---= --+-------|
| Averages:=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | 113.= 5 |=C2=A0 88 |=C2=A0 82 |=C2=A0=C2=A0=C2=A0 92 |
#+TBLFM: @>$2..@>= $>=3Dvmean(@I..@II)

All the values will properly compu= te.=C2=A0 If you want to avoid the second HLINE above Averages: then change= =3D@II=3D to =3D@>>=3D (penultimate row)

Regards,<= br>
Jon
=C2=A0
This is a cut down version of my full record set.=C2=A0 Sometimes when I ke= y 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.=C2=A0 If I do c-u+c-c+c-c that s= ometimes generated ?ERROR.=C2=A0 Other times I key in a formula and the cur= sor gets locked and I have to hit c-g to exit #+TBLFM: mode; I don't kn= ow what's actually happening when that situation arises since other tha= n 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.

=C2=A0--



--001a11473da2529e76051787bf60--