[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] table: referencing row of other table
From: |
Nick Dokos |
Subject: |
Re: [O] table: referencing row of other table |
Date: |
Mon, 13 Aug 2012 18:27:21 -0400 |
Karl Voit <address@hidden> wrote:
> 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: <fillme>
>
#+TBLFM: $2 = remote(2012-08-12vkmeasure, @@#$5)
Nick
> I tried following references but failed so far:
>
> @address@hidden(remote(2012-08-12vkmeasure,@address@hidden),$#) #-> 0.08 0.08
> ...
> @2$2=remote(2012-08-12vkmeasure,@2$5) -> works for one value
> @address@hidden(remote(2012-08-12vkmeasure,@address@hidden),$#) #-> 0.08 0.08
> ...
> $2=subscr(remote(2012-08-12vkmeasure,@I$>address@hidden>),$#)
>
> 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
>
>