Thanks, here's what I have now and it almost works. When I add a new line though the averages don't change until I delete the TBLFM: line and the line with the =vmean(@2..-1) formulas on it then key the formulas in again. Then the averages do update to reflect new numbers. That's not a difficulty though, I can easily handle that light work using a sed script.
| Date Stamp | Systalic | Diastalic | Pulse | | | | | | | | |------------------------+----------+-----------+-------+---+---+---+---+---+---+---| | [2011-07-19 Tue 02:26] | 138 | 92 | 74 | | | | | | | | | [2011-07-21 Thu 03:50] | 128 | 79 | 76 | | | | | | | | | [2011-07-20 Wed 04:03] | 130 | 85 | 74 | | | | | | | | | [2011-07-22 Fri 02:33] | 121 | 80 | 79 | | | | | | | | | [2011-07-23 Sat 02:52] | 118 | 75 | 68 | | | | | | | | |------------------------+----------+-----------+-------+---+---+---+---+---+---+---| | Averages | 127 | 82.2 | 74.2 | | | | | | | | | | | | | | | | | | | | #+TBLFM: $2=vmean(@2..-1)::$3=vmean(@2..-1)::$4=vmean(@2..-1) # Local Variables: # kept-new-versions: 100 # version-control: t # End: - On Fri, 22 Jul 2011, Nick Dokos wrote: > Jude DaShiell <jdash...@shellworld.net> wrote: > > > I removed a separator line above averages and removed a row with blank > > fields and ran the calculation on this table and it does have a defective > > formula but I don't know where the defect is now. > > > > | Date Stamp | Systalic | Diastalic | Pulse | | | | | > > | | | > > |------------------------+----------+-----------+-------+---+---+---+---+---+---+---| > > | [2011-07-19 Tue 02:26] | 138 | 92 | 74 | | | | | > > | | | > > | [2011-07-21 Thu 03:50] | 128 | 79 | 76 | | | | | > > | | | > > | [2011-07-20 Wed 04:03] | 130 | 85 | 74 | | | | | > > | | | > > | [2011-07-22 Fri 02:33] | 121 | 80 | 79 | | | | | > > | | | > > | Averages | #ERROR | | | | | | | > > | | | > > | | | - | | | | | | > > | | | > > | | | | | | | | | > > | | | > > #+TBLFM: $2=vmean(@<..@>) > > > > Two problems: 1) you want to set a single cell but the way the formula is > written > makes it a column formula and 2) the rows as written include the header line > and go > all the way to the bottom - assuming you want the two rows after the > "Averages" row, > you can say > > #+TBLFM: @>>>$2=vmean(@<<..@>>>>) > > That says "the third row from the bottom in column two is the mean of the > rows in the > same column, ranging from second from the top to fourth from the bottom". > > I thought I could use references relative to @> (e.g. @>-3) but apparently > that's > not the case: > > #+TBLFM: @>>>$2=vmean(@<<..@>-3) > > does not work for me. > > Nick > >
