[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Orgmode] lookup functions in spreadsheet/table

From: Juan
Subject: Re: [Orgmode] lookup functions in spreadsheet/table
Date: Fri, 30 Jul 2010 19:29:26 -0300
User-agent: Mutt/1.5.20 (2009-06-14)

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)
   ( (< x 20) "C")
   ( (< x 50) "B")
   ( t "A")

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


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.

reply via email to

[Prev in Thread] Current Thread [Next in Thread]