Re: calculating column averages follow up

[Achim Gratz <Stromeko@nexgo.de>]

Jude DaShiell <jdashiel@shellworld.net> 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