Gesendet: Sonntag, 28. April 2013 um 01:27 Uhr
Von: "Richard Lawrence" <richard.lawrence@berkeley.edu>
An: emacs-orgmode@gnu.org
Betreff: Re: [O] How to analyze clocking reports (e. g. with spreadsheet application)?

Hi Martin,

Martin <elwood151@web.de> writes:

> 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.

Have you looked at this section in the manual? I don't use many of
these features myself, but I think Org itself can tell you many of these
things without exporting the data to a separate tool:

http://orgmode.org/org.html#The-clock-table

Hi Richard,

thanks for the pointer to the manual page. I had seen that, but for the beginning (as my structure of tasks, projects and tags is not very well "designed" yet,

I need some more sophisticated way to find out how my working time is spent.

(I'm not yet familiar with elisp and org-tables, so the easiest way for me would be to export all data to e. g. csv and then analyze them with MS Excel (e. g. a pivot table and maybe some self-made VBA "intelligence" to sort or group them...)

What is great in org-mode is the hierarchichal structure of tasks and sub-tasks. The drawback is however, that as long as all hierarchies of sub-tasks are listed in the clocking table, the time is counted manyfold in the "real value" and in all tasks which contain that value.

I wonder if anybody else already has put some thoughts in how to export and analyze those data..

Kind regards

Martin