emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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


From: Martin Beck
Subject: Re: [O] How to analyze clocking reports (e. g. with spreadsheet application)?
Date: Sun, 28 Apr 2013 08:29:05 +0200 (CEST)

 
 
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
 

reply via email to

[Prev in Thread] Current Thread [Next in Thread]