From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nicolas Goaziou <mail@nicolasgoaziou.fr>
Subject: Re: problems with tables using
 https://orgmode.org/worg/org-tutorials/org-lookups.html
Date: Mon, 30 Apr 2018 19:51:10 +0200
Message-ID: <87tvrslh0x.fsf@nicolasgoaziou.fr>
References: <876055fxzs.fsf@mat.ucm.es> <87fu3cna23.fsf@nicolasgoaziou.fr>
	<87h8nsy8dh.fsf@mat.ucm.es>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:42020)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1fDCxP-0001rz-DE
	for emacs-orgmode@gnu.org; Mon, 30 Apr 2018 13:51:24 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1fDCxK-0002ST-Cb
	for emacs-orgmode@gnu.org; Mon, 30 Apr 2018 13:51:23 -0400
Received: from relay2-d.mail.gandi.net ([217.70.183.194]:38157)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32)
	(Exim 4.71) (envelope-from <mail@nicolasgoaziou.fr>)
	id 1fDCxK-0002QH-63
	for emacs-orgmode@gnu.org; Mon, 30 Apr 2018 13:51:18 -0400
Received: from saiph (40-67.ipv4.commingeshautdebit.fr [185.131.40.67])
	(Authenticated sender: admin@nicolasgoaziou.fr)
	by relay2-d.mail.gandi.net (Postfix) with ESMTPSA id 229004000E
	for <emacs-orgmode@gnu.org>; Mon, 30 Apr 2018 19:51:11 +0200 (CEST)
Received: from ngz by saiph with local (Exim 4.89)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1fDCxC-0001pa-FS
	for emacs-orgmode@gnu.org; Mon, 30 Apr 2018 19:51:10 +0200
In-Reply-To: <87h8nsy8dh.fsf@mat.ucm.es> (Uwe Brauer's message of "Mon, 30 Apr
	2018 18:19:38 +0200")
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"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: emacs-orgmode@gnu.org

Hello,

Uwe Brauer <oub@mat.ucm.es> writes:

> #+name: raw-data2
> |---+-----------------+-----+-----+-----+-----+-----+-----+-----|
> |   | /               |     |  <> |  <> |  <> |  <> |  <> |  <> |

I also moved "/" to the left column. But it works without it.

> |   | Nombre Completo | DNI | Ej1 | Ej2 | Ej3 | Ej4 | Ej5 | Res |
> |---+-----------------+-----+-----+-----+-----+-----+-----+-----|
> |   | Candidate1      |   1 |   0 |   5 |   5 |   0 |  10 |   2 |
> |   | Candidate2      |   2 |   5 |   0 |   5 |   0 |   0 |   1 |
> |   | Candidate3      |   3 |   0 |   0 |   0 |  20 |  25 | 4.5 |
> |   | Candidate4      |   4 |   0 |   0 |   0 |  25 |  15 |   4 |
> |   | Candidate5      |   5 |  15 |  15 |  20 |  25 |  25 |  10 |
> |   | Candidate6      |   6 |  15 |  10 |  20 |  20 |  20 | 8.5 |
> |   | Candidate7      |   7 |  15 |  10 |  10 |  20 |  15 |   7 |
> #+TBLFM: $9=($4+$5+$6+$7+$8)/10
>
> | lower bound | upper bound | frequency |
> |-------------+-------------+-----------|
> |           1 |           5 | #ERROR    |
> |           5 |          10 | #ERROR    |
> #+TBLFM: $3='(length (org-lookup-all '($1 $2) '(remote(raw-data2,@2$9..@>$9)) nil 'in-interval));N
>
> #+end_src
>
>
>
> That did not work neither as you can see.

It definitely works here.

Regards,

-- 
Nicolas Goaziou