emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: "T. V. Raman" <raman@users.sf.net>
To: austin.frank@gmail.com
Cc: emacs-orgmode@gnu.org
Subject: ranges of rows in other columns
Date: Tue, 27 Jun 2006 21:13:49 -0700	[thread overview]
Message-ID: <17570.509.426623.619032@localhost.localdomain> (raw)
In-Reply-To: <44A045FD.1080602@gmail.com>


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 <austin.frank@gmail.com> 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

  reply	other threads:[~2006-06-28  4:13 UTC|newest]

Thread overview: 3+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2006-06-26 20:39 ranges of rows in other columns Austin Frank
2006-06-28  4:13 ` T. V. Raman [this message]
2006-06-28  9:20 ` Carsten Dominik

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=17570.509.426623.619032@localhost.localdomain \
    --to=raman@users.sf.net \
    --cc=austin.frank@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body. 
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).