Hi Leo You may want to have a look at org-aggregate It provides partial sums, means, and so on, and also correlation between two columns.
Source code and documentation here: https://github.com/tbanel/orgaggregate Also available as an Emacs package on Melpa: (require 'package) (add-to-list 'package-archives '("melpa" . "http://melpa.milkbox.net/packages";) t) (package-initialize) M-x package-list-packages install orgtbl-aggregate Thierry Le 12/03/2015 15:24, Leo Ufimtsev a écrit : > Hello, > > I'm new to Tables/formulas. > > I started using a table with formulas to keep track of productivity, # of > hours of sleep etc.. > > I have something like this: > | Day | Dev | Leo | @ 9 | Sleep | > |------------------+------+------+------------+-------| > | [2015-03-04 Wed] | 3:01 | 3:55 | 1 | 8:00 | > | [2015-03-05 Thu] | 4:00 | 0:52 | 0 | 7:39 | > | [2015-03-06 Fri] | 4:03 | 0:00 | .5 | 8:00 | > | [2015-03-09 Mon] | 5:09 | 0:00 | 0 | 8:15 | > | [2015-03-10 Tue] | 3:14 | 1:12 | .5 | 7:25 | > | [2015-03-11 Wed] | 4:55 | 0:53 | .5 | 7:30 | > | [2015-03-12 Thu] | | | 0 | 7:24 | > | [2015-03-13 Fri] | | | | | > |------------------+------+------+------------+-------| > | March | 3.0 | 3.9 | 0.42857143 | 7.8 | > #+TBLFM: > @>$4=vmean(@I..@II)::@>$5=vmean(@I..@II);t%.1f::@>$2=vmean(@I$2);t%.1f::@>$3=vmean(@I$3);t%.1f > > At the bottom I have averages for each column. (in the future I'd like to > make a correlation analysis between sleep and productivity). > > Now, I would like weekly *and* yearly totals. I can't seem to come up with a > solution that wouldn't involve a lot of hard-coding or insertion of formulas > by hand. > > Any ideas? Do you think org-collector with two collector tables might be a > better solution for this sort of requirement? > > Thank you > > Leo Ufimtsev | Intern Software Engineer @ Eclipse Team > > > >
