Gesendet: Sonntag, 28. April 2013 um 01:27 Uhr
Von: "Richard Lawrence" <address@hidden>
An: address@hidden
Betreff: Re: [O] How to analyze clocking reports (e. g. with spreadsheet application)?
Hi Martin,
Martin <address@hidden> 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