Re: [O] Data format for keeping track of weekly yearly stats?
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
Re: [O] Data format for keeping track of weekly yearly stats?
This looks like the promised land here. SQL aggregation in org-mode omg X-D!! Pretty much what I was looking for. Thank you so much for the link. Leo Ufimtsev | Intern Software Engineer @ Eclipse Team - Original Message - From: Thierry Banel tbanelweb...@free.fr To: emacs-orgmode@gnu.org Sent: Friday, March 13, 2015 3:06:18 AM Subject: Re: [O] Data format for keeping track of weekly yearly stats? 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
[O] Data format for keeping track of weekly yearly stats?
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