Re: [O] calculating column averages follow up

2011-07-23 Thread Achim Gratz
Jude DaShiell 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 ne

Re: [O] calculating column averages follow up

2011-07-23 Thread Jude DaShiell
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 diffi

Re: [O] calculating column averages

2011-07-22 Thread Ken Williams
Jude DaShiell shellworld.net> writes: > > In this case I don't want to tell org-mode how many rows to calculate, and > I put a table together with an averages line in its own footer section. Since you have a header & footer, one solution is to use a formula like this: :=vmean(@I..@II)

Re: [O] calculating column averages follow up

2011-07-22 Thread Nick Dokos
Jude DaShiell 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 | | |

Re: [O] calculating column averages follow up

2011-07-22 Thread Jude DaShiell
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 | | | | | | | | |-

Re: [O] calculating column averages

2011-07-22 Thread Rasmus
Jude DaShiell writes: > In this case I don't want to tell org-mode how many rows to calculate, and > I put a table together with an averages line in its own footer section. I > prefer when doing these things to output final averages and totals just > under table headers then go down into deta

[O] calculating column averages

2011-07-22 Thread Jude DaShiell
In this case I don't want to tell org-mode how many rows to calculate, and I put a table together with an averages line in its own footer section. I prefer when doing these things to output final averages and totals just under table headers then go down into detail records after that. Could s