Jude DaShiell <[email protected]> writes: > 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.
Nah... I think you would want you table like that: | | Date Stamp | Systolic | Diastolic | Pulse | |---+------------------------+----------+-----------+-------| | | [2011-07-19 Tue 02:26] | 138 | 92 | 174 | | | [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 | |---+------------------------+----------+-----------+-------| | # | Average | 127.0 | 82.2 | 94.2 | | | | | | | #+TBLFM: @>>$3..@>>$5=vmean(@I..II);%.1f Then you can just add another line, tab into the averages line and everything updates just the way you want. Regards, Achim. -- +<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+ SD adaptations for Waldorf Q V3.00R3 and Q+ V3.54R2: http://Synth.Stromeko.net/Downloads.html#WaldorfSDada
