From mboxrd@z Thu Jan 1 00:00:00 1970 From: Achim Gratz Subject: Re: calculating column averages follow up Date: Sat, 23 Jul 2011 11:39:28 +0200 Message-ID: <87y5zpxrn3.fsf@Rainer.invalid> References: <11092.1311332109@alphaville.dokosmarshall.org> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([140.186.70.92]:37207) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QkYgR-0003rw-P4 for emacs-orgmode@gnu.org; Sat, 23 Jul 2011 05:39:44 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QkYgQ-0000Tw-Ct for emacs-orgmode@gnu.org; Sat, 23 Jul 2011 05:39:43 -0400 Received: from lo.gmane.org ([80.91.229.12]:37921) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QkYgQ-0000To-73 for emacs-orgmode@gnu.org; Sat, 23 Jul 2011 05:39:42 -0400 Received: from list by lo.gmane.org with local (Exim 4.69) (envelope-from ) id 1QkYgO-0006Qd-TJ for emacs-orgmode@gnu.org; Sat, 23 Jul 2011 11:39:40 +0200 Received: from p57aacfab.dip.t-dialin.net ([87.170.207.171]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 23 Jul 2011 11:39:40 +0200 Received: from Stromeko by p57aacfab.dip.t-dialin.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 23 Jul 2011 11:39:40 +0200 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 Jude DaShiell writes: > Thanks, here's what I have now and it almost works. When I add a new > line though the averages don't change until I delete the TBLFM: line and > the line with the =vmean(@2..-1) formulas on it then key the formulas in > again. Then the averages do update to reflect new numbers. That's not > a difficulty though, I can easily handle that light work using a sed > script. Nah... I think you would want you table like that: | | Date Stamp | Systolic | Diastolic | Pulse | |---+------------------------+----------+-----------+-------| | | [2011-07-19 Tue 02:26] | 138 | 92 | 174 | | | [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 | | | [2011-07-23 Sat 02:52] | 118 | 75 | 68 | |---+------------------------+----------+-----------+-------| | # | Average | 127.0 | 82.2 | 94.2 | | | | | | | #+TBLFM: @>>$3..@>>$5=vmean(@I..II);%.1f Then you can just add another line, tab into the averages line and everything updates just the way you want. Regards, Achim. -- +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+ SD adaptations for Waldorf Q V3.00R3 and Q+ V3.54R2: http://Synth.Stromeko.net/Downloads.html#WaldorfSDada