Niels Giesen <niels.gie...@gmail.com> writes: > Bernt Hansen <be...@norang.ca> 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.
Hi Niels, Thanks for the example. That helps a lot. I think posting this to Worg would be very useful. Thanks for sharing this! Regards, -- Bernt