From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nicolas Goaziou <n.goaziou@neuf.fr>
Subject: Spreadsheet and weighted means
Date: Sat, 20 Sep 2008 09:00:37 +0200
Message-ID: <87wsh7w589.fsf@selenimh.orion.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1KgyZs-0006ja-B3
	for emacs-orgmode@gnu.org; Sat, 20 Sep 2008 05:16:32 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1KgyZl-0006j8-V5
	for emacs-orgmode@gnu.org; Sat, 20 Sep 2008 05:16:30 -0400
Received: from [199.232.76.173] (port=46983 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1KgyZk-0006j2-RI
	for emacs-orgmode@gnu.org; Sat, 20 Sep 2008 05:16:24 -0400
Received: from sp604003av.neufgp.fr ([84.96.92.124]:38391
	helo=neuf-infra-smtp-out-sp604003av.neufgp.fr)
	by monty-python.gnu.org with esmtp (Exim 4.60)
	(envelope-from <n.goaziou@neuf.fr>) id 1KgyZl-0002lM-34
	for emacs-orgmode@gnu.org; Sat, 20 Sep 2008 05:16:25 -0400
Received: from selenimh.orion.org. (71.61.86-79.rev.gaoland.net [79.86.61.71])
	by lowzel (Postfix) with ESMTPSA id 01CBB1FD9A
	for <emacs-orgmode@gnu.org>; Sat, 20 Sep 2008 11:11:55 +0200 (CEST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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

Hello,

I stumbled upon this problem : I'd like to compute the weighted mean of
some values, even though cells might be empty. In fact, I'm aiming at
something like this :

|           | Coeff. |    0.2 |    0.5 |      1 |
|-----------+--------+--------+--------+--------|
| Name      |   Mean | Test 1 | Test 2 | Test 3 |
|-----------+--------+--------+--------+--------|
| Student A |     10 |     15 |     12 |      8 |
| Student B |     12 |        |     16 |     10 |

where 10=3D(15*0.2+12*0.5+8*1)/(0.2+0.5+1) and 12=3D(16*0.5+10*1)/(0.5+1)

I just can't guess what has to be put in @3$2 as a column formula to
calculate those mean means=E2=80=A6 I perhaps have overlooked something sim=
ple.
Anyway, if anyone has a clue here, I will be pleased to hear it.

--=20
Nicolas Goaziou