* Clocktable feature requests
@ 2015-07-06 16:05 Daniel E. Doherty
2015-07-06 16:21 ` Charles Millar
` (2 more replies)
0 siblings, 3 replies; 5+ messages in thread
From: Daniel E. Doherty @ 2015-07-06 16:05 UTC (permalink / raw)
To: Org-mode List
I typically keep a list of tasks I'm working on in a subtree that is
simply a bunch of subheads that describe the task, like so:
,----
| * Time Records
| ** Review filings for Johnson--Morgan
| CLOCK: [2014-08-27 Wed 09:13]--[2014-08-27 Wed 12:20] => 3:07
| ** Discussion with Smith re Johnson possible violation
| CLOCK: [2014-08-27 Wed 10:35]--[2014-08-27 Wed 10:55] => 0:20
| ** Prepare and send demand letter for Johnson
| CLOCK: [2014-08-28 Mon 11:18]--[2014-08-28 Thu 12:20] => 1:02
| ** Forward summary to Smith following on discussion
| CLOCK: [2014-08-29 Fri 09:35]--[2014-08-29 Fri 09:45] => 0:10
| ** Receive and review letter from Willy Wonka re demand
| CLOCK: [2014-09-11 Thu 09:38]--[2014-09-11 Thu 10:39] => 1:01
| ** Prepare reply to Wonka response letter
| CLOCK: [2014-09-11 Thu 10:40]--[2014-09-11 Thu 11:30] => 0:50
`----
I clock in and out of tasks as I work on them. There is typically no
'SCEDULED' or 'DEADLINE' associated with the tasks.
I would like to produce a clocktable that works as a passible bill.
There are two things that make this difficult:
1. I would like the clocktable to have a column that indicates the date on
which the activity took place.
2. I would like the an optional 'Rate' and 'Charge' columns to be added
As to 1:
The timestamp feature almost takes care of 1, except that it will not use the
CLOCK property to set the timestamp. Using the date (optional time) at which
the CLOCK started would work as a good timestamp, and probably better than
something like the SCHEDULED or DEADLINE. If the purpose is to indicate when
the activity occurred, it would seem that the best order for picking the time
stamp would be something like TIMESTAMP, TIMESTAMP_IA, CLOCK (begin),
SCHEDULED, then DEADLINE, that is from more specific to more general.
As to 2:
With an option like :rate set to, say, 50, the time column could be converted
to dollars (or whatever currency) at rate * hours. It would also be nice to
have that amount summed in the same way that time is summed by levels now.
With those items added, the clocktable would be usable as a billing
mechanism. As it is now, it makes a nice start, but requires a lot of
massaging to turn a clocktable into an invoice.
Any chance of getting these features added?
Dan Doherty
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Clocktable feature requests
2015-07-06 16:05 Clocktable feature requests Daniel E. Doherty
@ 2015-07-06 16:21 ` Charles Millar
2015-07-06 22:16 ` Daniel E. Doherty
2015-07-07 0:20 ` Subhan Michael Tindall
2015-07-07 0:34 ` Subhan Michael Tindall
2 siblings, 1 reply; 5+ messages in thread
From: Charles Millar @ 2015-07-06 16:21 UTC (permalink / raw)
To: emacs-orgmode
Hi Dan,
Maybe Tom Marble's timesheet..el is what you are looking for
https://github.com/tmarble/timesheet.el
As I recall if was discussed on this list awhile ago. Also see his
interview with Sacha Chua's interview with Tom
http://emacslife.com/emacs-chats/chat-tom-marble.html
Hate to say this, but I still haven't tried it myself.
Charlie Millar
On 07/06/2015 12:05 PM, Daniel E. Doherty wrote:
> I typically keep a list of tasks I'm working on in a subtree that is
> simply a bunch of subheads that describe the task, like so:
>
> ,----
> | * Time Records
> | ** Review filings for Johnson--Morgan
> | CLOCK: [2014-08-27 Wed 09:13]--[2014-08-27 Wed 12:20] => 3:07
> | ** Discussion with Smith re Johnson possible violation
> | CLOCK: [2014-08-27 Wed 10:35]--[2014-08-27 Wed 10:55] => 0:20
> | ** Prepare and send demand letter for Johnson
> | CLOCK: [2014-08-28 Mon 11:18]--[2014-08-28 Thu 12:20] => 1:02
> | ** Forward summary to Smith following on discussion
> | CLOCK: [2014-08-29 Fri 09:35]--[2014-08-29 Fri 09:45] => 0:10
> | ** Receive and review letter from Willy Wonka re demand
> | CLOCK: [2014-09-11 Thu 09:38]--[2014-09-11 Thu 10:39] => 1:01
> | ** Prepare reply to Wonka response letter
> | CLOCK: [2014-09-11 Thu 10:40]--[2014-09-11 Thu 11:30] => 0:50
> `----
>
> I clock in and out of tasks as I work on them. There is typically no
> 'SCEDULED' or 'DEADLINE' associated with the tasks.
>
> I would like to produce a clocktable that works as a passible bill.
>
> There are two things that make this difficult:
>
> 1. I would like the clocktable to have a column that indicates the date on
> which the activity took place.
>
> 2. I would like the an optional 'Rate' and 'Charge' columns to be added
>
> As to 1:
>
> The timestamp feature almost takes care of 1, except that it will not use the
> CLOCK property to set the timestamp. Using the date (optional time) at which
> the CLOCK started would work as a good timestamp, and probably better than
> something like the SCHEDULED or DEADLINE. If the purpose is to indicate when
> the activity occurred, it would seem that the best order for picking the time
> stamp would be something like TIMESTAMP, TIMESTAMP_IA, CLOCK (begin),
> SCHEDULED, then DEADLINE, that is from more specific to more general.
>
> As to 2:
>
> With an option like :rate set to, say, 50, the time column could be converted
> to dollars (or whatever currency) at rate * hours. It would also be nice to
> have that amount summed in the same way that time is summed by levels now.
>
> With those items added, the clocktable would be usable as a billing
> mechanism. As it is now, it makes a nice start, but requires a lot of
> massaging to turn a clocktable into an invoice.
>
> Any chance of getting these features added?
>
> Dan Doherty
>
>
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Clocktable feature requests
2015-07-06 16:21 ` Charles Millar
@ 2015-07-06 22:16 ` Daniel E. Doherty
0 siblings, 0 replies; 5+ messages in thread
From: Daniel E. Doherty @ 2015-07-06 22:16 UTC (permalink / raw)
To: Charles Millar, Org-mode List
Thanks Charles. I'm still hoping for Org Mode to do this built-in so I can
export the table to a format of my choosing.
On Mon, 06 Jul 2015 11:21:13 -0500,
Charles Millar <millarc@verizon.net> wrote:
>
> Hi Dan,
>
> Maybe Tom Marble's timesheet..el is what you are looking for
>
> https://github.com/tmarble/timesheet.el
>
> As I recall if was discussed on this list awhile ago. Also see his interview
> with Sacha Chua's interview with Tom
>
> http://emacslife.com/emacs-chats/chat-tom-marble.html
>
> Hate to say this, but I still haven't tried it myself.
>
>
> Charlie Millar
> On 07/06/2015 12:05 PM, Daniel E. Doherty wrote:
> > I typically keep a list of tasks I'm working on in a subtree that is
> > simply a bunch of subheads that describe the task, like so:
> >
> > ,----
> > | * Time Records
> > | ** Review filings for Johnson--Morgan
> > | CLOCK: [2014-08-27 Wed 09:13]--[2014-08-27 Wed 12:20] => 3:07
> > | ** Discussion with Smith re Johnson possible violation
> > | CLOCK: [2014-08-27 Wed 10:35]--[2014-08-27 Wed 10:55] => 0:20
> > | ** Prepare and send demand letter for Johnson
> > | CLOCK: [2014-08-28 Mon 11:18]--[2014-08-28 Thu 12:20] => 1:02
> > | ** Forward summary to Smith following on discussion
> > | CLOCK: [2014-08-29 Fri 09:35]--[2014-08-29 Fri 09:45] => 0:10
> > | ** Receive and review letter from Willy Wonka re demand
> > | CLOCK: [2014-09-11 Thu 09:38]--[2014-09-11 Thu 10:39] => 1:01
> > | ** Prepare reply to Wonka response letter
> > | CLOCK: [2014-09-11 Thu 10:40]--[2014-09-11 Thu 11:30] => 0:50
> > `----
> >
> > I clock in and out of tasks as I work on them. There is typically no
> > 'SCEDULED' or 'DEADLINE' associated with the tasks.
> >
> > I would like to produce a clocktable that works as a passible bill.
> >
> > There are two things that make this difficult:
> >
> > 1. I would like the clocktable to have a column that indicates the date on
> > which the activity took place.
> >
> > 2. I would like the an optional 'Rate' and 'Charge' columns to be added
> >
> > As to 1:
> >
> > The timestamp feature almost takes care of 1, except that it will not use the
> > CLOCK property to set the timestamp. Using the date (optional time) at which
> > the CLOCK started would work as a good timestamp, and probably better than
> > something like the SCHEDULED or DEADLINE. If the purpose is to indicate when
> > the activity occurred, it would seem that the best order for picking the time
> > stamp would be something like TIMESTAMP, TIMESTAMP_IA, CLOCK (begin),
> > SCHEDULED, then DEADLINE, that is from more specific to more general.
> >
> > As to 2:
> >
> > With an option like :rate set to, say, 50, the time column could be converted
> > to dollars (or whatever currency) at rate * hours. It would also be nice to
> > have that amount summed in the same way that time is summed by levels now.
> >
> > With those items added, the clocktable would be usable as a billing
> > mechanism. As it is now, it makes a nice start, but requires a lot of
> > massaging to turn a clocktable into an invoice.
> >
> > Any chance of getting these features added?
> >
> > Dan Doherty
> >
> >
>
>
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Clocktable feature requests
2015-07-06 16:05 Clocktable feature requests Daniel E. Doherty
2015-07-06 16:21 ` Charles Millar
@ 2015-07-07 0:20 ` Subhan Michael Tindall
2015-07-07 0:34 ` Subhan Michael Tindall
2 siblings, 0 replies; 5+ messages in thread
From: Subhan Michael Tindall @ 2015-07-07 0:20 UTC (permalink / raw)
To: Daniel E. Doherty, Org Mode Mailing List
[-- Attachment #1: Type: text/plain, Size: 2545 bytes --]
On Mon, Jul 6, 2015, 9:07 AM Daniel E. Doherty <ded-law@ddoherty.net>
wrote:
I typically keep a list of tasks I'm working on in a subtree that is
simply a bunch of subheads that describe the task, like so:
,----
| * Time Records
| ** Review filings for Johnson--Morgan
| CLOCK: [2014-08-27 Wed 09:13]--[2014-08-27 Wed 12:20] => 3:07
| ** Discussion with Smith re Johnson possible violation
| CLOCK: [2014-08-27 Wed 10:35]--[2014-08-27 Wed 10:55] => 0:20
| ** Prepare and send demand letter for Johnson
| CLOCK: [2014-08-28 Mon 11:18]--[2014-08-28 Thu 12:20] => 1:02
| ** Forward summary to Smith following on discussion
| CLOCK: [2014-08-29 Fri 09:35]--[2014-08-29 Fri 09:45] => 0:10
| ** Receive and review letter from Willy Wonka re demand
| CLOCK: [2014-09-11 Thu 09:38]--[2014-09-11 Thu 10:39] => 1:01
| ** Prepare reply to Wonka response letter
| CLOCK: [2014-09-11 Thu 10:40]--[2014-09-11 Thu 11:30] => 0:50
`----
I clock in and out of tasks as I work on them. There is typically no
'SCEDULED' or 'DEADLINE' associated with the tasks.
I would like to produce a clocktable that works as a passible bill.
There are two things that make this difficult:
1. I would like the clocktable to have a column that indicates the date on
which the activity took place.
2. I would like the an optional 'Rate' and 'Charge' columns to be added
As to 1:
The timestamp feature almost takes care of 1, except that it will not use
the
CLOCK property to set the timestamp. Using the date (optional time) at
which
the CLOCK started would work as a good timestamp, and probably better than
something like the SCHEDULED or DEADLINE. If the purpose is to indicate
when
the activity occurred, it would seem that the best order for picking the
time
stamp would be something like TIMESTAMP, TIMESTAMP_IA, CLOCK (begin),
SCHEDULED, then DEADLINE, that is from more specific to more general.
As to 2:
With an option like :rate set to, say, 50, the time column could be
converted
to dollars (or whatever currency) at rate * hours. It would also be nice to
have that amount summed in the same way that time is summed by levels now.
With those items added, the clocktable would be usable as a billing
mechanism. As it is now, it makes a nice start, but requires a lot of
massaging to turn a clocktable into an invoice.
Any chance of getting these features added?
Dan Doherty
2 should be fairly straightforward with the judicious application of
:formula <formula> to include a #tblfm style calc line in the header to do
your calculations
[-- Attachment #2: Type: text/html, Size: 3249 bytes --]
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: Clocktable feature requests
2015-07-06 16:05 Clocktable feature requests Daniel E. Doherty
2015-07-06 16:21 ` Charles Millar
2015-07-07 0:20 ` Subhan Michael Tindall
@ 2015-07-07 0:34 ` Subhan Michael Tindall
2 siblings, 0 replies; 5+ messages in thread
From: Subhan Michael Tindall @ 2015-07-07 0:34 UTC (permalink / raw)
To: Daniel E. Doherty, Org Mode Mailing List
[-- Attachment #1: Type: text/plain, Size: 2700 bytes --]
On Mon, Jul 6, 2015, 9:07 AM Daniel E. Doherty <ded-law@ddoherty.net>
wrote:
I typically keep a list of tasks I'm working on in a subtree that is
simply a bunch of subheads that describe the task, like so:
,----
| * Time Records
| ** Review filings for Johnson--Morgan
| CLOCK: [2014-08-27 Wed 09:13]--[2014-08-27 Wed 12:20] => 3:07
| ** Discussion with Smith re Johnson possible violation
| CLOCK: [2014-08-27 Wed 10:35]--[2014-08-27 Wed 10:55] => 0:20
| ** Prepare and send demand letter for Johnson
| CLOCK: [2014-08-28 Mon 11:18]--[2014-08-28 Thu 12:20] => 1:02
| ** Forward summary to Smith following on discussion
| CLOCK: [2014-08-29 Fri 09:35]--[2014-08-29 Fri 09:45] => 0:10
| ** Receive and review letter from Willy Wonka re demand
| CLOCK: [2014-09-11 Thu 09:38]--[2014-09-11 Thu 10:39] => 1:01
| ** Prepare reply to Wonka response letter
| CLOCK: [2014-09-11 Thu 10:40]--[2014-09-11 Thu 11:30] => 0:50
`----
I clock in and out of tasks as I work on them. There is typically no
'SCEDULED' or 'DEADLINE' associated with the tasks.
I would like to produce a clocktable that works as a passible bill.
There are two things that make this difficult:
1. I would like the clocktable to have a column that indicates the date on
which the activity took place.
2. I would like the an optional 'Rate' and 'Charge' columns to be added
As to 1:
The timestamp feature almost takes care of 1, except that it will not use
the
CLOCK property to set the timestamp. Using the date (optional time) at
which
the CLOCK started would work as a good timestamp, and probably better than
something like the SCHEDULED or DEADLINE. If the purpose is to indicate
when
the activity occurred, it would seem that the best order for picking the
time
stamp would be something like TIMESTAMP, TIMESTAMP_IA, CLOCK (begin),
SCHEDULED, then DEADLINE, that is from more specific to more general.
As to 2:
With an option like :rate set to, say, 50, the time column could be
converted
to dollars (or whatever currency) at rate * hours. It would also be nice to
have that amount summed in the same way that time is summed by levels now.
With those items added, the clocktable would be usable as a billing
mechanism. As it is now, it makes a nice start, but requires a lot of
massaging to turn a clocktable into an invoice.
Any chance of getting these features added?
Dan Doherty
Sorry for the split reply.
I have some code (a few simple functions) that creates & maintains a
property with a date stamp value that is automatically created /updated for
a headline every time it is clocked into. This can then be displayed as a
column in a clocktable. I'll send it over if you are interested.
Subhan
[-- Attachment #2: Type: text/html, Size: 3358 bytes --]
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2015-07-07 0:34 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2015-07-06 16:05 Clocktable feature requests Daniel E. Doherty
2015-07-06 16:21 ` Charles Millar
2015-07-06 22:16 ` Daniel E. Doherty
2015-07-07 0:20 ` Subhan Michael Tindall
2015-07-07 0:34 ` Subhan Michael Tindall
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).