Re: [Orgmode] lookup functions in spreadsheet/table

2010-07-30 Thread Juan
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")

[Orgmode] lookup functions in spreadsheet/table

2010-07-30 Thread Neil Hepburn
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 c