[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] calculating column averages follow up
From: |
Achim Gratz |
Subject: |
Re: [O] calculating column averages follow up |
Date: |
Sat, 23 Jul 2011 11:39:28 +0200 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/24.0.50 (gnu/linux) |
Jude DaShiell <address@hidden> 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