From mboxrd@z Thu Jan 1 00:00:00 1970 From: "T. V. Raman" Subject: ranges of rows in other columns Date: Tue, 27 Jun 2006 21:13:49 -0700 Message-ID: <17570.509.426623.619032@localhost.localdomain> References: <44A045FD.1080602@gmail.com> Reply-To: raman@users.sf.net Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1FvRR3-0005v1-Au for emacs-orgmode@gnu.org; Wed, 28 Jun 2006 00:13:53 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1FvRR1-0005ul-LV for emacs-orgmode@gnu.org; Wed, 28 Jun 2006 00:13:52 -0400 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1FvRR1-0005ui-D8 for emacs-orgmode@gnu.org; Wed, 28 Jun 2006 00:13:51 -0400 Received: from [216.148.227.152] (helo=rwcrmhc12.comcast.net) by monty-python.gnu.org with esmtp (Exim 4.52) id 1FvRdG-0004Wi-99 for emacs-orgmode@gnu.org; Wed, 28 Jun 2006 00:26:30 -0400 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@gmail.com Cc: emacs-orgmode@gnu.org calc may be your friend here. We should create a couple recipes for passing a row or column from org to calc and getting it back -- then we can do all the computes on the calc side. Calc has an "embed" mode that works very well out of the box inside text LaTeX and consequently org files; would be nice to take org's table minor mode and couple it with calc's vector capabilities >>>>> "Austin" == Austin Frank writes: Austin> -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Austin> Austin> Hello all-- Austin> Austin> I'm looking for help in setting up a calculation in a Austin> table in org mode. I'd like to keep a running Austin> average of my past three days worth of measurements. Austin> Something like Austin> Austin> |------------------+-----------------+-----------------| Austin> | Date | TV Time (hours) | Running Average | Austin> |------------------+-----------------+-----------------| Austin> | <2006-06-24 Sat> | 1 | | | <2006-06-25 Sun> | 1.5 | Austin> | | <2006-06-26 Mon> | .5 | 1 | | <2006-06-27 Tue> | Austin> 3 | 1.66 | | <2006-06-28 Wed> | 2.5 | 2 | Austin> |------------------+-----------------+-----------------| Austin> Austin> I just did the numbers for running average in my Austin> head-- I'm hoping for help with a formula that will Austin> get the mean for the last three rows of the `TV Time' Austin> column. I tried using $3=vsum($2&3-1), but this Austin> didn't work. Austin> Austin> Is there a syntax for accessing row ranges of other Austin> columns for a calculation? If not, can anyone Austin> suggest an elisp formula that will accomplish this? Austin> Austin> If a helpful soul is feeling especially generous, is Austin> there also a way to set this table up that will Austin> calculate the new running average every time I enter Austin> a new date's measurement? Extra credit if you use Austin> Carsten's constants.el to provide units in the Austin> measurment column and the calculated column ;) Austin> Austin> Thanks for any help, /au -----BEGIN PGP Austin> SIGNATURE----- Version: GnuPG v1.4.3 (Darwin) Austin> Comment: Using GnuPG with Mozilla - Austin> http://enigmail.mozdev.org Austin> Austin> iD8DBQFEoEX8lHMl2/XbR4ERAgQMAKDb48ZGq4JlA8NU4g6jBtV/BG3DBwCfb5at Austin> OHz4gmF2ONOcPhOUPGWbXow= =zkAf -----END PGP Austin> SIGNATURE----- Austin> Austin> Austin> _______________________________________________ Austin> Emacs-orgmode mailing list Emacs-orgmode@gnu.org Austin> http://lists.gnu.org/mailman/listinfo/emacs-orgmode -- Best Regards, --raman Email: raman@users.sf.net WWW: http://emacspeak.sf.net/raman/ AIM: emacspeak GTalk: tv.raman.tv@gmail.com PGP: http://emacspeak.sf.net/raman/raman-almaden.asc Google: tv+raman IRC: irc://irc.freenode.net/#emacs