From mboxrd@z Thu Jan 1 00:00:00 1970 From: Neil Hepburn Subject: lookup functions in spreadsheet/table Date: Fri, 30 Jul 2010 15:06:49 -0600 Message-ID: <460AB3C0-8E5C-403F-AC3A-147357C46306@ualberta.ca> Mime-Version: 1.0 (Apple Message framework v1081) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Return-path: Received: from [140.186.70.92] (port=42753 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Oewn8-0005op-5K for emacs-orgmode@gnu.org; Fri, 30 Jul 2010 17:06:55 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1Oewn6-000672-II for emacs-orgmode@gnu.org; Fri, 30 Jul 2010 17:06:53 -0400 Received: from smtp.srv.ualberta.ca ([129.128.5.19]:50694 helo=mail4.srv.ualberta.ca) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1Oewn6-00066u-Bu for emacs-orgmode@gnu.org; Fri, 30 Jul 2010 17:06:52 -0400 Received: from [192.168.1.103] (admin-host-29-242.augustana.ualberta.ca [142.244.29.242]) (authenticated bits=0) by mail4.srv.ualberta.ca (8.14.3/8.13.8) with ESMTP id o6UL6nca010934 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NOT) for ; Fri, 30 Jul 2010 15:06:50 -0600 (MDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org 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 =3Dvlookup(,,). 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.=20 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 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D 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.)