From mboxrd@z Thu Jan  1 00:00:00 1970
From: Leo Ufimtsev <lufimtse@redhat.com>
Subject: Data format for keeping track of weekly & yearly stats?
Date: Thu, 12 Mar 2015 10:24:27 -0400 (EDT)
Message-ID: <213756074.20532191.1426170267094.JavaMail.zimbra@redhat.com>
References: <98194341.20528930.1426169913842.JavaMail.zimbra@redhat.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:39970)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <lufimtse@redhat.com>) id 1YW42L-0005Hq-JF
	for emacs-orgmode@gnu.org; Thu, 12 Mar 2015 10:24:37 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <lufimtse@redhat.com>) id 1YW42G-0004m6-Ji
	for emacs-orgmode@gnu.org; Thu, 12 Mar 2015 10:24:33 -0400
Received: from mx3-phx2.redhat.com ([209.132.183.24]:50571)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <lufimtse@redhat.com>) id 1YW42G-0004lq-5l
	for emacs-orgmode@gnu.org; Thu, 12 Mar 2015 10:24:28 -0400
Received: from zmail23.collab.prod.int.phx2.redhat.com
	(zmail23.collab.prod.int.phx2.redhat.com [10.5.83.28])
	by mx3-phx2.redhat.com (8.13.8/8.13.8) with ESMTP id t2CEOR79017696
	for <emacs-orgmode@gnu.org>; Thu, 12 Mar 2015 10:24:27 -0400
In-Reply-To: <98194341.20528930.1426169913842.JavaMail.zimbra@redhat.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Org-mode <emacs-orgmode@gnu.org>

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