emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: Neil Hepburn <nhepburn@ualberta.ca>
To: emacs-orgmode <emacs-orgmode@gnu.org>
Subject: lookup functions in spreadsheet/table
Date: Fri, 30 Jul 2010 15:06:49 -0600	[thread overview]
Message-ID: <460AB3C0-8E5C-403F-AC3A-147357C46306@ualberta.ca> (raw)

Greetings

I am looking for a lookup function for tables in org-mode. In the past I have used a spreadsheet to keep track of student grades and then had a table that contained cut points and grades. Assigning grades was simple because the formula would simply look up the student's grade in the cut points table and assign the appropriate letter grade.  In Yicksel, also known as Excel, the function would be =vlookup(<target>,<lookup range>,<column to return>). If I need to "tweak" my grade distribution to satisfy an anal retentive Registrar type, I can do so by altering the cut points. Now that I am using org-mode and emacs for everything else, thought it would be interesting to keep my grade book in it too. 

I've looked at the org-mode manual for the spreadsheet functions as well as looked in the GNU Emacs Calc manual for such a function but to no avail. Does such a function exist in org-mode?

Cheers,
Neil



=============================================
Neil Hepburn, Economics Instructor
Department of Social Sciences, Augustana Faculty
University of Alberta
4901-46 Avenue
Camrose, Alberta  T4V 2R3

Phone (780) 679-1588
email nhepburn@ualberta.ca

No trees were harmed in creating this message. (However, millions of electrons were terribly disturbed.)

next             reply	other threads:[~2010-07-30 21:06 UTC|newest]

Thread overview: 2+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2010-07-30 21:06 Neil Hepburn [this message]
2010-07-30 22:29 ` lookup functions in spreadsheet/table Juan

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=460AB3C0-8E5C-403F-AC3A-147357C46306@ualberta.ca \
    --to=nhepburn@ualberta.ca \
    --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

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