emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* lookup functions in spreadsheet/table
@ 2010-07-30 21:06 Neil Hepburn
  2010-07-30 22:29 ` Juan
  0 siblings, 1 reply; 2+ messages in thread
From: Neil Hepburn @ 2010-07-30 21:06 UTC (permalink / raw)
  To: emacs-orgmode

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

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

end of thread, other threads:[~2010-07-30 22:29 UTC | newest]

Thread overview: 2+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2010-07-30 21:06 lookup functions in spreadsheet/table Neil Hepburn
2010-07-30 22:29 ` Juan

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