Re: [O] How to analyze clocking reports (e. g. with spreadsheet application)?

[Christoph LANGE-BEVER]

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