From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Monroe, Will" Subject: Re: How to analyze clocking reports (e. g. with spreadsheet application)? Date: Tue, 29 Jul 2014 15:07:52 -0500 Message-ID: <53D7FF18.3040707@gmail.com> References: <53D7BB8D.7020502@gmail.com> 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]:51066) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XCDgo-0001do-Gm for emacs-orgmode@gnu.org; Tue, 29 Jul 2014 16:08:07 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XCDgj-00085m-Q9 for emacs-orgmode@gnu.org; Tue, 29 Jul 2014 16:08:02 -0400 Received: from mail-oi0-x22e.google.com ([2607:f8b0:4003:c06::22e]:61160) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XCDgj-00085a-L1 for emacs-orgmode@gnu.org; Tue, 29 Jul 2014 16:07:57 -0400 Received: by mail-oi0-f46.google.com with SMTP id i138so175478oig.33 for ; Tue, 29 Jul 2014 13:07:55 -0700 (PDT) Received: from wmonro1-3.lsu.edu (wmonro1-3.lsu.edu. [130.39.217.187]) by mx.google.com with ESMTPSA id wu2sm48171474obb.22.2014.07.29.13.07.53 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Tue, 29 Jul 2014 13:07:54 -0700 (PDT) In-Reply-To: <53D7BB8D.7020502@gmail.com> 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: emacs-orgmode@gnu.org Christoph, Thanks for sharing this. I'm just now beginning to explore the ability of org to provide weekly and monthly reports. I've gotten as far as implementing the elisp that Sacha Chua shared here: http://pages.sachachua.com/.emacs.d/Sacha.html#monthly-reviews It works great but at this early stage, I'd like to explore the features of org further to develop an approach that works for me. So I'd love to see a mini-tutorial on worg about what you've developed. All the best, Will On 7/29/14, 10:19 AM, Christoph LANGE-BEVER wrote: > 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 >