From mboxrd@z Thu Jan 1 00:00:00 1970 From: Jude DaShiell Subject: Re: calculating column averages follow up Date: Fri, 22 Jul 2011 05:35:42 -0400 (EDT) Message-ID: Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Return-path: Received: from eggs.gnu.org ([140.186.70.92]:57754) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QkC92-00083j-Nh for emacs-orgmode@gnu.org; Fri, 22 Jul 2011 05:35:45 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QkC92-0002sm-0f for emacs-orgmode@gnu.org; Fri, 22 Jul 2011 05:35:44 -0400 Received: from shellworld.net ([69.60.117.94]:50935 helo=server1.shellworld.net) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QkC91-0002sY-U7 for emacs-orgmode@gnu.org; Fri, 22 Jul 2011 05:35:43 -0400 Received: from localhost (localhost [127.0.0.1]) by server1.shellworld.net (Postfix) with ESMTP id CDDA922A25 for ; Fri, 22 Jul 2011 05:35:42 -0400 (EDT) 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: emacs-orgmode@gnu.org I removed a separator line above averages and removed a row with blank fields and ran the calculation on this table and it does have a defective formula but I don't know where the defect is now. | Date Stamp | Systalic | Diastalic | Pulse | | | | | | | | |------------------------+----------+-----------+-------+---+---+---+---+---+---+---| | [2011-07-19 Tue 02:26] | 138 | 92 | 74 | | | | | | | | | [2011-07-21 Thu 03:50] | 128 | 79 | 76 | | | | | | | | | [2011-07-20 Wed 04:03] | 130 | 85 | 74 | | | | | | | | | [2011-07-22 Fri 02:33] | 121 | 80 | 79 | | | | | | | | | Averages | #ERROR | | | | | | | | | | | | | - | | | | | | | | | | | | | | | | | | | | | #+TBLFM: $2=vmean(@<..@>) # Local Variables: # kept-new-versions: 100 # version-control: t # End: -