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

Reply via email to