From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nicolas Goaziou Subject: Re: problems with tables using https://orgmode.org/worg/org-tutorials/org-lookups.html Date: Mon, 30 Apr 2018 14:38:44 +0200 Message-ID: <87fu3cna23.fsf@nicolasgoaziou.fr> References: <876055fxzs.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:50820) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fD850-0000oT-0j for emacs-orgmode@gnu.org; Mon, 30 Apr 2018 08:38:55 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fD84w-0003GY-Tb for emacs-orgmode@gnu.org; Mon, 30 Apr 2018 08:38:54 -0400 Received: from relay7-d.mail.gandi.net ([217.70.183.200]:54593) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1fD84w-0003FV-Lv for emacs-orgmode@gnu.org; Mon, 30 Apr 2018 08:38:50 -0400 In-Reply-To: <876055fxzs.fsf@mat.ucm.es> (Uwe Brauer's message of "Thu, 05 Apr 2018 17:56:23 +0200") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: Uwe Brauer Cc: emacs-orgmode Hello, Uwe Brauer writes: > #+TBLNAME: raw-data2 Not related, but : #+name: raw-data2 > |---+-----------------+-----+-----+-----+-----+-----+-----+-----| > > | | / | | <> | <> | <> | <> | <> | <> | > | | 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 | 0 | > | 5 | 10 | 1 | > > #+TBLFM: $3='(length (org-lookup-all '($1 $2) '(remote(raw-data2,@9$9..@>$9)) nil 'in-interval));N ^^^^ @2$9 > > #+TBLNAME: raw-data3 See above. > |---+-----------------+-----+-----+-----+-----+-----| > > | | / | <> | <> | <> | <> | <> | > | | Nombre Completo | Ej1 | Ej2 | Ej3 | Ej4 | Res | > |---+-----------------+-----+-----+-----+-----+-----| > | | Candidate1 | 0 | 5 | 5 | 0 | 1 | > | | Candidate2 | 5 | 0 | 5 | 0 | 1 | > | | Candidate3 | 0 | 0 | 0 | 20 | 2 | > | | Candidate4 | 0 | 0 | | 25 | 2.5 | > | | Candidate5 | 15 | 15 | 20 | 25 | 7.5 | > | | Candidate6 | 15 | 10 | 20 | 20 | 6.5 | > | | Candidate7 | 15 | 0 | 10 | 20 | 4.5 | > > #+TBLFM: $7=($3+$4+$5+$6)/10 > > | lower bound | upper bound | frequency | > |-------------+-------------+-----------| > | 0 | 5 | 1 | > | 5 | 10 | 2 | > > #+TBLFM: $3='(length (org-lookup-all '($1 $2) '(remote(raw-data3,@7$7..@>$7)) nil 'in-interval));N ^^^^ ditto Regards, -- Nicolas Goaziou