emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* ranges of rows in other columns
@ 2006-06-26 20:39 Austin Frank
  2006-06-28  4:13 ` T. V. Raman
  2006-06-28  9:20 ` Carsten Dominik
  0 siblings, 2 replies; 3+ messages in thread
From: Austin Frank @ 2006-06-26 20:39 UTC (permalink / raw)
  To: emacs-orgmode

-----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-----

^ permalink raw reply	[flat|nested] 3+ messages in thread

end of thread, other threads:[~2006-06-28  9:20 UTC | newest]

Thread overview: 3+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2006-06-26 20:39 ranges of rows in other columns Austin Frank
2006-06-28  4:13 ` T. V. Raman
2006-06-28  9:20 ` Carsten Dominik

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).