From mboxrd@z Thu Jan 1 00:00:00 1970 From: Christoph LANGE-BEVER Subject: Re: How to analyze clocking reports (e. g. with spreadsheet application)? Date: Tue, 29 Jul 2014 17:19:41 +0200 Message-ID: <53D7BB8D.7020502@gmail.com> References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:48254) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XC9Bz-0002xU-97 for emacs-orgmode@gnu.org; Tue, 29 Jul 2014 11:20:00 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XC9Bt-0004MH-LC for emacs-orgmode@gnu.org; Tue, 29 Jul 2014 11:19:55 -0400 Received: from mail-wg0-x233.google.com ([2a00:1450:400c:c00::233]:40342) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XC9Bt-0004M8-E4 for emacs-orgmode@gnu.org; Tue, 29 Jul 2014 11:19:49 -0400 Received: by mail-wg0-f51.google.com with SMTP id b13so9076933wgh.22 for ; Tue, 29 Jul 2014 08:19:46 -0700 (PDT) In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: Martin , emacs-orgmode@gnu.org Hi all, I thought I'd share with you one nice thing I figured out recently. It seemed appropriate to post it as a belated answer to this thread: On 2013-04-27 23:50, Martin wrote: > I'm using the org-mode clocking features (in org-mode 7.9.4) extensively > to document how much time I spent with which task and when. > > I wonder how I can export the data (e. g. to MS Excel) for further analysis; > * time consumed by different projects > * interruptions and "jumping" from task to task > * time consumed by tasks with a special tag > etc. So I was interested in doing some of this analytics right inside Org spreadsheets. At https://github.com/clange/org-mode/tree/master/clocktable-spreadsheet please find a self-documenting solution for computing my weekly overtime balance from working hours logged using the clocking features. The key to this solution is accessing entries of a clock table from a spreadsheet table. I would be happy to contribute this mini-tutorial to Worg. It is already available under GPL, and I'll be happy to make it available under any other license you may need. However I have little time and would prefer not having to learn any complex procedures before being able to contribute. Cheers, Christoph -- Christoph Lange-Bever, http://www.facebook.com/ch.lange, Skype duke4701