Re: ranges of rows in other columns

[Carsten Dominik <carsten.dominik@gmail.com>]

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