From mboxrd@z Thu Jan  1 00:00:00 1970
From: Jude DaShiell <jdashiel@shellworld.net>
Subject: calculating column averages
Date: Fri, 22 Jul 2011 05:06:42 -0400 (EDT)
Message-ID: <alpine.BSF.2.00.1107220459580.49902@freire1.furyyjbeyq.arg>
Mime-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:60225)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <jdashiel@shellworld.net>) id 1QkBgy-0002Ya-Ct
	for emacs-orgmode@gnu.org; Fri, 22 Jul 2011 05:06:45 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <jdashiel@shellworld.net>) id 1QkBgx-0006Vj-Fk
	for emacs-orgmode@gnu.org; Fri, 22 Jul 2011 05:06:44 -0400
Received: from shellworld.net ([69.60.117.94]:50641
	helo=server1.shellworld.net) by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <jdashiel@shellworld.net>) id 1QkBgx-0006VH-CX
	for emacs-orgmode@gnu.org; Fri, 22 Jul 2011 05:06:43 -0400
Received: from localhost (localhost [127.0.0.1])
	by server1.shellworld.net (Postfix) with ESMTP id 5212F22811
	for <emacs-orgmode@gnu.org>; Fri, 22 Jul 2011 05:06:42 -0400 (EDT)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: </archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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

In this case I don't want to tell org-mode how many rows to calculate, and 
I put a table together with an averages line in its own footer section.  I 
prefer when doing these things to output final averages and totals just 
under table headers then go down into detail records after that.  Could 
someone take a look at the following table and tell me how to get an 
average on column 2 of this table?
Cut here.

| 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               | $2=vmean(@<..@>) |           |       |   |   |   |   |   |   |   |
|                        |                  |         - |       |   |   |   |   |   |   |   |
|                        |                  |           |       |   |   |   |   |   |   |   |
  
# Local Variables:
# kept-new-versions: 100
# version-control: t
# End:

-