Re: calculating column averages follow up

[Jude DaShiell <jdashiel@shellworld.net>]

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 <jdashiel@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
> 
>