From mboxrd@z Thu Jan 1 00:00:00 1970 From: Kene Meniru Subject: evaluating rows or columns in org-table Date: Wed, 30 Jul 2008 10:08:05 -0400 Message-ID: <489075C5.807@gmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1KOCLc-0007Cg-UT for emacs-orgmode@gnu.org; Wed, 30 Jul 2008 10:08:12 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1KOCLc-0007CM-94 for emacs-orgmode@gnu.org; Wed, 30 Jul 2008 10:08:12 -0400 Received: from [199.232.76.173] (port=56201 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1KOCLb-0007CG-VR for emacs-orgmode@gnu.org; Wed, 30 Jul 2008 10:08:12 -0400 Received: from yx-out-1718.google.com ([74.125.44.157]:14816) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1KOCLb-0004hi-Jl for emacs-orgmode@gnu.org; Wed, 30 Jul 2008 10:08:11 -0400 Received: by yx-out-1718.google.com with SMTP id 34so6103yxf.66 for ; Wed, 30 Jul 2008 07:08:10 -0700 (PDT) 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@gnu.org | | | names | grade 1 | grade 2 | grade 3 | Total | | Letter grade | |---+---+------------+---------+---------+---------+-------+---+--------------| | # | 1 | student 01 | 91.80 | 96.40 | 97.00 | 95.07 | 1 | C | | # | 2 | student 02 | 88.78 | 89.15 | 98.00 | 91.98 | 2 | B | | # | 3 | student 03 | 92.00 | 95.14 | 97.00 | 94.71 | 3 | B | | # | 4 | student 04 | 84.00 | 74.62 | 88.00 | 82.21 | 4 | B | #+TBLFM: $7=($4+$5+$6)/3;%.2f Sample letter grade calculation: 90-100 = A 80-89 = B 70-79 = C 60-69 = D 0-59 = F I am deeply sorry if this has been addressed before here. I have searched but could not find any reference. I am a teacher and have been using org-mode in combination with noweb as a class manager. I also use moodle and blackboard but I like to keep my lecture notes and student grades local on my machine. I typically have the above table for student grades (usually substantially more than that). I am able to calculate many things like averages, etc., but would like to have letter grades and "best performing" comments by the students doing as well. Starting with letter grades, is there a way I can evaluate the Total column and assign letter grades as shown above? Thanks -- Kene Meniru :::::::::::::::::::::::::::: keMeniru@gmail.com