Karl Voit <devn...@karl-voit.at> 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: > > @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 > >
