[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Emacs-orgmode] ranges of rows in other columns

From: Carsten Dominik
Subject: Re: [Emacs-orgmode] ranges of rows in other columns
Date: Wed, 28 Jun 2006 11:20:30 +0200

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:

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

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,
Version: GnuPG v1.4.3 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org


Emacs-orgmode mailing list

Carsten Dominik
Sterrenkundig Instituut "Anton Pannekoek"
Universiteit van Amsterdam
Kruislaan 403
NL-1098SJ Amsterdam
phone: +31 20 525 7477

reply via email to

[Prev in Thread] Current Thread [Next in Thread]