From mboxrd@z Thu Jan  1 00:00:00 1970
From: Suvayu Ali <fatkasuvayu+linux@gmail.com>
Subject: Re: Tables for attendance lists - A problem understanding TBLFM?
Date: Tue, 9 Apr 2013 02:25:19 +0200
Message-ID: <20130409002519.GA3195@kuru.dyndns-at-home.com>
References: <20130408235753.GC109669@gwolf.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:33667)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <fatkasuvayu+linux@gmail.com>) id 1UPMNK-0007Mt-8z
	for emacs-orgmode@gnu.org; Mon, 08 Apr 2013 20:25:28 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <fatkasuvayu+linux@gmail.com>) id 1UPMNJ-0004Ft-Ar
	for emacs-orgmode@gnu.org; Mon, 08 Apr 2013 20:25:26 -0400
Received: from mail-wi0-x232.google.com ([2a00:1450:400c:c05::232]:36843)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <fatkasuvayu+linux@gmail.com>) id 1UPMNJ-0004Fi-3v
	for emacs-orgmode@gnu.org; Mon, 08 Apr 2013 20:25:25 -0400
Received: by mail-wi0-f178.google.com with SMTP id ez12so3132842wid.5
	for <emacs-orgmode@gnu.org>; Mon, 08 Apr 2013 17:25:24 -0700 (PDT)
Content-Disposition: inline
In-Reply-To: <20130408235753.GC109669@gwolf.org>
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: emacs-orgmode@gnu.org

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árdenas, Lázaro  | 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='(length '($3..$7))::@6$2=vmean($3..$7);%.2f::@6$3..@6$7='(length '(@2..@5))::@6$8=vmean(@2..@5);%.2f

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 $>=sum($3..$-1).

-- 
Suvayu

Open source is the future. It sets us free.