emacs-orgmode
[Top][All Lists]
Advanced

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

[O] Re: lisp/org-clock.el: Add param :properties to list properties in c


From: Niels Giesen
Subject: [O] Re: lisp/org-clock.el: Add param :properties to list properties in clocktable
Date: Sun, 27 Mar 2011 12:13:41 +0200
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/24.0.50 (gnu/linux)

Bernt Hansen <address@hidden> writes:

[...]

> Could you provide a sample clock report using this patch to get a
> better idea of why you find this useful?

Yes, here you are, along with the contents of a sample file, so that you
may get a gist of my need for inheritance.

* Clocktables
  #+BEGIN: clocktable :maxlevel 2 :scope file :properties ("Costcenter" 
"Billable") :inherit-props t
  Clock summary at [2011-03-27 Sun 12:04]
  
  | Costcenter                        | Billable | Headline                     
   |   Time |      |
  
|-----------------------------------+----------+---------------------------------+--------+------|
  |                                   |          | *Total time*                 
   | *3:08* |      |
  
|-----------------------------------+----------+---------------------------------+--------+------|
  | A-102: General Administration     |          | TODO Travel cost declaration 
   |   0:42 |      |
  | A-102: General Administration     |          | TODO December 2007-2009      
   |        | 0:37 |
  | O-100: General overhead           |          | Making coffee for the lot of 
us |   0:06 |      |
  | C-100: Customer relations general |          | Helpdesk                     
   |   1:10 |      |
  | C-100: Customer relations general |          | Categorize our helpdesk 
e-mails |        | 0:20 |
  | C-101: Customer A                 | [X]      | Help out customer a          
   |        | 0:10 |
  | C-102: Customer B                 | [?]      | Help out customer b on issue 
x  |        | 0:20 |
  | C-100: Customer relations general |          | Help out potential customer 
c   |        | 0:20 |
  | W-100: Web Development            |          | Develop our main web app     
   |   1:10 |      |
  | W-100: Web Development            |          | that                         
   |        | 0:41 |
  | C-102: Customer B                 | [?]      | something only customer b 
wants |        | 0:29 |
  #+END:

Actually, my boss needs something more like the table below, which I
can export to something that Outlook Times also spits out (some
clocking plugin for MS Outlook that the rest of us uses, and I was
supposed to use too, you may understand that that is just a silly idea
for someone used to org-mode).

Patches 1 and 3 allowed me to get this specific output using a custom
formatter and a #+TBLFM: line, which I may post to Worg if people are
interested.

#+BEGIN: clocktable :formatter org-clocktable-write-outlook-times-style 
:maxlevel 2 :scope file :inherit-props t :properties ("Costcenter" "Billable") 
:date t :block day
Clock summary at [2011-03-27 Sun 12:04], for Sunday, March 27, 2011.

|       Date | Headline                                                  |   
Time | Costcenter                        | Billable |
|------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
|            | *Total time*                                              | 
*3.05* |                                   |          |
|------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
| 27-03-2011 | TODO Travel cost declaration                              |   
0.00 | A-102: General Administration     |          |
| 27-03-2011 | TODO Travel cost declaration, TODO December 2007-2009     |   
0.62 | A-102: General Administration     |          |
|------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
| 27-03-2011 | Making coffee for the lot of us                           |   
0.10 | O-100: General overhead           |          |
|------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
| 27-03-2011 | Helpdesk                                                  |   
0.00 | C-100: Customer relations general |          |
| 27-03-2011 | Helpdesk, Categorize our helpdesk e-mails                 |   
0.33 | C-100: Customer relations general |          |
| 27-03-2011 | Helpdesk, Help out customer a                             |   
0.17 | C-101: Customer A                 | [X]      |
| 27-03-2011 | Helpdesk, Help out customer b on issue x                  |   
0.33 | C-102: Customer B                 | [?]      |
| 27-03-2011 | Helpdesk, Help out potential customer c                   |   
0.33 | C-100: Customer relations general |          |
|------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
| 27-03-2011 | Develop our main web app                                  |   
0.00 | W-100: Web Development            |          |
| 27-03-2011 | Develop our main web app, that                            |   
0.68 | W-100: Web Development            |          |
| 27-03-2011 | Develop our main web app, something only customer b wants |   
0.48 | C-102: Customer B                 | [?]      |
#+TBLFM: $2='(if (string= "$0" "@-I") "$0" (concat "@-I" ", " "$0"));L::$4='(if 
(string= "$0" "") "@-I" "$0");L
#+END:
* TODO Travel cost declaration
  DEADLINE: <2011-04-01 vr .+1m>
  - State "DONE"       from "TESTING"    [2011-02-01 di 10:02]
  :LOGBOOK:
  CLOCK: [2011-03-02 wo 09:17]--[2011-03-02 wo 09:22] =>  0:05
  :END:
  - State "DONE"       from "TESTING"    [2011-01-04 di 09:40]
  :PROPERTIES:
  :COSTCENTER: A-102: General Administration
  :END:
** TODO December 2007-2009
   :CLOCK:
   CLOCK: [2011-03-27 Sun 09:28]--[2011-03-27 Sun 10:05] =>  0:37
   :END:
   Find out what were my costs during this hazy period of my life.
   
   
* Dishes                                                              :daily:
  :PROPERTIES:
  :COSTCENTER: O-100: General overhead
  :END:
* Making coffee for the lot of us                                     :daily:
  :CLOCK:
  CLOCK: [2011-03-27 Sun 09:22]--[2011-03-27 Sun 09:28] =>  0:06
  :END:
  :PROPERTIES:
  :COSTCENTER: O-100: General overhead
  :END:
* Helpdesk  
  :PROPERTIES:
  :COSTCENTER: C-100: Customer relations general
  :END:
** Categorize our helpdesk e-mails                                    :daily:
   :CLOCK:
   CLOCK: [2011-03-27 Sun 10:05]--[2011-03-27 Sun 10:25] =>  0:20
   :END:
** Help out customer a
   :CLOCK:
   CLOCK: [2011-03-27 Sun 10:25]--[2011-03-27 Sun 10:35] =>  0:10
   :END:
  :PROPERTIES:
  :COSTCENTER: C-101: Customer A
  :BILLABLE: [X]
  :END:
** Help out customer b on issue x
   :CLOCK:
   CLOCK: [2011-03-27 Sun 10:35]--[2011-03-27 Sun 10:55] =>  0:20
   :END:
  :PROPERTIES:
  :COSTCENTER: C-102: Customer B
  :BILLABLE: [?]
  :END:
** Help out potential customer c
   :CLOCK:
   CLOCK: [2011-03-27 Sun 10:55]--[2011-03-27 Sun 11:15] =>  0:20
   :END:
   Does not yet have a cost center
* Develop our main web app
   :PROPERTIES:
   :COSTCENTER: W-100: Web Development
   :END:
** this

** that
   :CLOCK:
   CLOCK: [2011-03-27 Sun 11:44]--[2011-03-27 Sun 12:25] =>  0:45
   :END:
   
** something only customer b wants
   :CLOCK:
   CLOCK: [2011-03-27 Sun 11:15]--[2011-03-27 Sun 11:44] =>  0:29
   :END:
  :PROPERTIES:
  :COSTCENTER: C-102: Customer B
  :BILLABLE: [?]
  :END:
   


>
> Thanks,

-- 
http://pft.github.com/



reply via email to

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