From mboxrd@z Thu Jan 1 00:00:00 1970 From: Carsten Dominik Subject: Re: ranges of rows in other columns Date: Wed, 28 Jun 2006 11:20:30 +0200 Message-ID: <6199610c5682799795d05c77f8b8031c@science.uva.nl> References: <44A045FD.1080602@gmail.com> Mime-Version: 1.0 (Apple Message framework v624) Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1FvWDq-0003fb-S9 for emacs-orgmode@gnu.org; Wed, 28 Jun 2006 05:20:34 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1FvWDo-0003er-VX for emacs-orgmode@gnu.org; Wed, 28 Jun 2006 05:20:34 -0400 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1FvWDo-0003em-NQ for emacs-orgmode@gnu.org; Wed, 28 Jun 2006 05:20:32 -0400 Received: from [199.232.41.67] (helo=mx20.gnu.org) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA:32) (Exim 4.52) id 1FvWQ6-0008Em-Uc for emacs-orgmode@gnu.org; Wed, 28 Jun 2006 05:33:15 -0400 Received: from [72.14.214.200] (helo=hu-out-0102.google.com) by mx20.gnu.org with esmtp (Exim 4.52) id 1FvWDm-0008Gc-US for emacs-orgmode@gnu.org; Wed, 28 Jun 2006 05:20:31 -0400 Received: by hu-out-0102.google.com with SMTP id 34so1257911hue for ; Wed, 28 Jun 2006 02:20:28 -0700 (PDT) In-Reply-To: <44A045FD.1080602@gmail.com> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Austin Frank Cc: emacs-orgmode Unfortunately, this is beyond the current syntax envelope for table equations in org-mode. I could widen that envelope, but not soon. - Carsten On Jun 26, 2006, at 22:39, Austin Frank wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hello all-- > > I'm looking for help in setting up a calculation in a table in org > mode. > I'd like to keep a running average of my past three days worth of > measurements. Something like > > |------------------+-----------------+-----------------| > | Date | TV Time (hours) | Running Average | > |------------------+-----------------+-----------------| > | <2006-06-24 Sat> | 1 | | > | <2006-06-25 Sun> | 1.5 | | > | <2006-06-26 Mon> | .5 | 1 | > | <2006-06-27 Tue> | 3 | 1.66 | > | <2006-06-28 Wed> | 2.5 | 2 | > |------------------+-----------------+-----------------| > > I just did the numbers for running average in my head-- I'm hoping for > help with a formula that will get the mean for the last three rows of > the `TV Time' column. I tried using $3=vsum($2&3-1), but this didn't > work. > > Is there a syntax for accessing row ranges of other columns for a > calculation? If not, can anyone suggest an elisp formula that will > accomplish this? > > If a helpful soul is feeling especially generous, is there also a way > to > set this table up that will calculate the new running average every > time > I enter a new date's measurement? Extra credit if you use Carsten's > constants.el to provide units in the measurment column and the > calculated column ;) > > Thanks for any help, > /au > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.3 (Darwin) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org > > iD8DBQFEoEX8lHMl2/XbR4ERAgQMAKDb48ZGq4JlA8NU4g6jBtV/BG3DBwCfb5at > OHz4gmF2ONOcPhOUPGWbXow= > =zkAf > -----END PGP SIGNATURE----- > > > _______________________________________________ > Emacs-orgmode mailing list > Emacs-orgmode@gnu.org > http://lists.gnu.org/mailman/listinfo/emacs-orgmode > > -- Carsten Dominik Sterrenkundig Instituut "Anton Pannekoek" Universiteit van Amsterdam Kruislaan 403 NL-1098SJ Amsterdam phone: +31 20 525 7477