Re: [O] table: referencing row of other table

[Nick Dokos]

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