emacs-orgmode
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]