From mboxrd@z Thu Jan  1 00:00:00 1970
From: Gunnar Wolf <gwolf@gwolf.org>
Subject: Re: Tables for attendance lists - A problem understanding TBLFM?
Date: Mon, 8 Apr 2013 21:21:23 -0500
Message-ID: <20130409022123.GD112475@gwolf.org>
References: <20130408235753.GC109669@gwolf.org>
	<20130409002519.GA3195@kuru.dyndns-at-home.com>
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 eggs.gnu.org ([208.118.235.92]:58612)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <gwolf@gwolf.org>) id 1UPOBb-0000nV-Mc
	for emacs-orgmode@gnu.org; Mon, 08 Apr 2013 22:21:30 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <gwolf@gwolf.org>) id 1UPOBZ-0006cN-1V
	for emacs-orgmode@gnu.org; Mon, 08 Apr 2013 22:21:27 -0400
Received: from lafa.iiec.unam.mx ([132.248.72.141]:36458)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <gwolf@gwolf.org>) id 1UPOBY-0006cF-RL
	for emacs-orgmode@gnu.org; Mon, 08 Apr 2013 22:21:24 -0400
Content-Disposition: inline
In-Reply-To: <20130409002519.GA3195@kuru.dyndns-at-home.com>
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: Suvayu Ali <fatkasuvayu+linux@gmail.com>
Cc: emacs-orgmode@gnu.org

Suvayu Ali dijo [Tue, Apr 09, 2013 at 02:25:19AM +0200]:
> On Mon, Apr 08, 2013 at 06:57:53PM -0500, Gunnar Wolf wrote:
> > #+CAPTION: Attendances for April
> > |---------+-------------------+---+---+---+---+----+-------|
> > | Account | Name              | 1 | 3 | 5 | 8 | 10 | Total |
> > |---------+-------------------+---+---+---+---+----+-------|
> > |    1234 | C=C3=A1rdenas, L=C3=A1zaro  | X |   | X | X |    |     3 =
|
> > |    5678 | Madero, Francisco | X | X | X | X |    |     4 |
> > |    1544 | Villa, Pancho     |   |   |   |   |    |     1 |
> > |    0113 | Zapata, Emiliano  |   | X | X |   |    |     2 |
> > |---------+-------------------+---+---+---+---+----+-------|
> > | Day avg | 2.25              | 2 | 2 | 3 | 2 |  1 |  2.50 |
> > |---------+-------------------+---+---+---+---+----+-------|
> > #+tblfm: @2$8..@5$8=3D'(length '($3..$7))::@6$2=3Dvmean($3..$7);%.2f:=
:@6$3..@6$7=3D'(length '(@2..@5))::@6$8=3Dvmean(@2..@5);%.2f
>=20
> Probably not what you were looking for, why complicate things by using
> Xs instead of just a numeral like 1?  If you use 1, then you can use a
> column formula; maybe something like $>=3Dsum($3..$-1).

I had though about it, and it's currently a last resort for me. I want
to publish the lists in the course's webpage, and while a '1' would do
for me, I'd rather present to the students something they are more
likely to understand as natural.