[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] table: referencing row of other table
From: |
Karl Voit |
Subject: |
[O] table: referencing row of other table |
Date: |
Mon, 13 Aug 2012 23:50:06 +0200 |
User-agent: |
slrn/0.9.9 (Linux) |
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>
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
- [O] table: referencing row of other table,
Karl Voit <=