Hi Neil, One possible solution is to have a babel block defining an elisp function for note to grade transformation, and then using that function in your table.
Something like this (partly tested): #+begin_src emacs-lisp (defun grade (x) (cond ( (< x 20) "C") ( (< x 50) "B") ( t "A") )) #+end_src | 1 | C | | 22 | B | | 44 | B | | 77 | A | #+TBLFM: $2='(grade $1);N This way you get notes and grades in a single table. If you need a separate table with just names and grades (no notes) then probably babel is the way to go to explicitly process the table and generate a new one. Hope it helps. Regards, .j. On Fri, Jul 30, 2010 at 03:06:49PM -0600, Neil Hepburn wrote: > 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. _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
