From mboxrd@z Thu Jan  1 00:00:00 1970
From: scrawler@gmail.com
Subject: Re: begging table formula help
Date: Sun, 6 Sep 2015 16:06:46 -0500
Message-ID: <20150906210646.GA2727@bigblessing.localdomain>
References: <20150906124633.GA8983@bigblessing.localdomain>
	<m2zj0zmsei.fsf@vpn-128-237-147-75.library.vpn.cmu.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:50981)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <scrawler@gmail.com>) id 1ZYh8t-0000Oe-84
	for emacs-orgmode@gnu.org; Sun, 06 Sep 2015 17:06:28 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <scrawler@gmail.com>) id 1ZYh8p-0008V0-6I
	for emacs-orgmode@gnu.org; Sun, 06 Sep 2015 17:06:27 -0400
Received: from out4-smtp.messagingengine.com ([66.111.4.28]:49975)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <scrawler@gmail.com>) id 1ZYh8p-0008Uw-2m
	for emacs-orgmode@gnu.org; Sun, 06 Sep 2015 17:06:23 -0400
Received: from compute2.internal (compute2.nyi.internal [10.202.2.42])
	by mailout.nyi.internal (Postfix) with ESMTP id 9BBFC20854
	for <emacs-orgmode@gnu.org>; Sun,  6 Sep 2015 17:06:22 -0400 (EDT)
Received: from bigblessing (fl-67-235-134-230.dhcp.embarqhsd.net
	[67.235.134.230])
	by mail.messagingengine.com (Postfix) with ESMTPA id 20181C0028B
	for <emacs-orgmode@gnu.org>; Sun,  6 Sep 2015 17:06:22 -0400 (EDT)
Content-Disposition: inline
In-Reply-To: <m2zj0zmsei.fsf@vpn-128-237-147-75.library.vpn.cmu.edu>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: orgmode list <emacs-orgmode@gnu.org>

On Sun, Sep 06, 2015 at 12:20:05PM -0400, John Kitchin wrote:
> I assume you want to calculate the Points Earned and Percentage columns?
> 
> | Student | Assgn Points | Points Earned | Possible | Achieved | Percentage |
> |---------+--------------+---------------+----------+----------+------------|
> | Barney  |           40 |           35. |       16 |       14 |       87.5 |
> | Barney  |           40 |           35. |       16 |       14 |       87.5 |
> | Betty   |           40 |           30. |       16 |       12 |        75. |
> | Fred    |           40 |           25. |       16 |       10 |       62.5 |
> | Wilma   |           40 |          17.5 |       16 |        7 |      43.75 |
> #+TBLFM: $6 = ($5 / $4) * 100 ::  $3 = ($6 / 100) * $2

Yes, sorry, I looked at my email after I sent it and realized I wasn't
clear about that. Thank you very much for the formula. It's going into
production in about five minutes.
-- 
signature angry: "grrrrr"
:-)