From mboxrd@z Thu Jan 1 00:00:00 1970 From: Karl Voit Subject: table: referencing row of other table Date: Mon, 13 Aug 2012 23:50:06 +0200 Message-ID: <2012-08-13T23-36-12@devnull.Karl-Voit.at> Reply-To: news1142@Karl-Voit.at Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([208.118.235.92]:54568) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1T12Wn-0004iC-Jq for emacs-orgmode@gnu.org; Mon, 13 Aug 2012 17:50:27 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1T12Wl-0004Wd-Jo for emacs-orgmode@gnu.org; Mon, 13 Aug 2012 17:50:25 -0400 Received: from plane.gmane.org ([80.91.229.3]:47663) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1T12Wl-0004WP-Dl for emacs-orgmode@gnu.org; Mon, 13 Aug 2012 17:50:23 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1T12Wi-0004TF-Ku for emacs-orgmode@gnu.org; Mon, 13 Aug 2012 23:50:20 +0200 Received: from mail.michael-prokop.at ([88.198.6.110]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 13 Aug 2012 23:50:20 +0200 Received: from news1142 by mail.michael-prokop.at with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Mon, 13 Aug 2012 23:50:20 +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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org Hi! I want to use the column "average" of the first table to fill the column "h1" in the second one. #+TBLNAME: 2012-08-12vkmeasure | tags/item | m1 | m2 | m3 | average | |-----------+-------+-------+-------+---------| | 4 | 0.02 | 0.03 | 0.02 | 0.02 | | 5 | 0.06 | 0.12 | 0.06 | 0.08 | | 6 | 0.31 | 0.53 | 0.29 | 0.38 | | 7 | 3.83 | 4.08 | 4.48 | 4.13 | | 8 | 85.33 | 89.22 | 92.07 | 88.87 | #+TBLFM: $5 = vmean($2..$4);%.2f | tags/item | h1 [s] | h2 [s] | |-----------+--------+--------| | 4 | | | | 5 | | | | 6 | | | | 7 | | | | 8 | | | #+TBLFM: I tried following references but failed so far: @2$2..@6$2=subscr(remote(2012-08-12vkmeasure,@2$5..@6$5),$#) #-> 0.08 0.08 ... @2$2=remote(2012-08-12vkmeasure,@2$5) -> works for one value @2$2..@6$2=subscr(remote(2012-08-12vkmeasure,@2$5..@6$5),$#) #-> 0.08 0.08 ... $2=subscr(remote(2012-08-12vkmeasure,@I$>..@II$>),$#) What did I do wrong? How is the correct TBLFM in order to get 0.02 ... 88.87 into the h1-column? Thanks for your help! -- Karl Voit