From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Tables for attendance lists - A problem understanding TBLFM?
Date: Tue, 9 Apr 2013 14:41:17 +0200
Message-ID: <CALn3zogrv=npGXaWBVtxniKj8wRdMqzdmWbuvWO4cjgWz+t-Vg@mail.gmail.com>
References: <20130408235753.GC109669@gwolf.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:53137)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1UPXrU-0002PK-3v
	for emacs-orgmode@gnu.org; Tue, 09 Apr 2013 08:41:24 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1UPXrS-0000op-TR
	for emacs-orgmode@gnu.org; Tue, 09 Apr 2013 08:41:20 -0400
Received: from mail-lb0-f178.google.com ([209.85.217.178]:56655)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1UPXrS-0000oe-M0
	for emacs-orgmode@gnu.org; Tue, 09 Apr 2013 08:41:18 -0400
Received: by mail-lb0-f178.google.com with SMTP id q13so6793881lbi.37
	for <emacs-orgmode@gnu.org>; Tue, 09 Apr 2013 05:41:17 -0700 (PDT)
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: Gunnar Wolf <gwolf@gwolf.org>
Cc: Org Mode <emacs-orgmode@gnu.org>

Hi Gunnar

On Tue, Apr 9, 2013 at 1:57 AM, Gunnar Wolf <gwolf@gwolf.org> wrote:

> #+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

I would use

#+TBLFM: $8 = vlen($3..$7) :: @>$2 = vmean($3..$7); E %.2f ::
@>$3..@>$7 = vlen(@II..@III) :: @>$8 = vmean(@2..@5); E %.2f

or

#+TBLFM: $8 = vlen($3..$7) :: @>$2 = vmean($3..$7) +.0; E f-2 ::
@>$3..@>$7 = vlen(@II..@III) :: @>$8 = vmean(@2..@5) +.0; E f-2

For +.0 and f-2 see
http://orgmode.org/worg/org-faq.html#table-float-fraction

Michael