org-mode special table from clock

org-mode special table from clock

[Martin]

Hi there,

I'd like to create a table from my org file appointments:

Table for March 2014
| Day | Kind | Eltern | Familie | km |
|-----+------+--------+---------+----|
|   1 |      |      4 |       3 | 32 |
|   2 |      |        |         |    |
|   3 |    2 |        |         |    |
|   4 |    6 |        |       4 | 32 |
|     |      |        |         |    |

This is where Day is the day of the month, Kind, Eltern, Familie are
something like categories the appt belongs to, maybe not categories but
subcategories.  km is the distance of driving for that job.  The count
below the subcategories are not hours, that are quater hours, so a
number of 4 tells me it is one hour.

At the end of the table I'd like to have it summarized per subcategory
and the km.

But I'm unsure how to store the data for that in my APPT entries:  I
could use properties (but how?)  and I would really like to use the
CLOCK entries for calculating the times.

Thanks for your Ideas,
Martin

Re: org-mode special table from clock

[kleinerdrache]

Arent there any org-mode users here who know a little a bout this issue?

Thanks for every idea you have,
Martin

Martin writes:

> Hi there,
>
> I'd like to create a table from my org file appointments:
>
> Table for March 2014
> | Day | Kind | Eltern | Familie | km |
> |-----+------+--------+---------+----|
> |   1 |      |      4 |       3 | 32 |
> |   2 |      |        |         |    |
> |   3 |    2 |        |         |    |
> |   4 |    6 |        |       4 | 32 |
> |     |      |        |         |    |
>
> This is where Day is the day of the month, Kind, Eltern, Familie are
> something like categories the appt belongs to, maybe not categories but
> subcategories.  km is the distance of driving for that job.  The count
> below the subcategories are not hours, that are quater hours, so a
> number of 4 tells me it is one hour.
>
> At the end of the table I'd like to have it summarized per subcategory
> and the km.
>
> But I'm unsure how to store the data for that in my APPT entries:  I
> could use properties (but how?)  and I would really like to use the
> CLOCK entries for calculating the times.
>
> Thanks for your Ideas,
> Martin

Re: org-mode special table from clock

[Bastien]

Hi,

kleinerdrache@gmx.at writes:

> Arent there any org-mode users here who know a little a bout this
> issue?

This is a very specific use-case, I doubt another Org-mode user has
the same.  You will hit more Org users on the orgmode mailing list*,
but again, the use-case is quite specific.

* https://lists.gnu.org/mailman/listinfo/emacs-orgmode

-- 
 Bastien

Re: org-mode special table from clock

[Martin Kaffanke]

Bastien writes:

> Hi,
>
> kleinerdrache@gmx.at writes:
>
>> Arent there any org-mode users here who know a little a bout this
>> issue?
>
> This is a very specific use-case, I doubt another Org-mode user has
> the same.  You will hit more Org users on the orgmode mailing list*,
> but again, the use-case is quite specific.
>
> * https://lists.gnu.org/mailman/listinfo/emacs-orgmode

Thanks I'll try it there.  Even if it is very specific, people could
have some Ideas about that...  In fact there is more to do, but I
thought if I can get that result I will be able to get the other things
by myself.

Thanks,
Martin

-- 
Mag. Martin Kaffanke
http://www.kaffanke.at
+43 650 4514224

Re: org-mode special table from clock

[Martin]

Bastien writes:

> Hi,
>
> kleinerdrache@gmx.at writes:
>
>> Arent there any org-mode users here who know a little a bout this
>> issue?
>
> This is a very specific use-case, I doubt another Org-mode user has
> the same.  You will hit more Org users on the orgmode mailing list*,
> but again, the use-case is quite specific.
>
> * https://lists.gnu.org/mailman/listinfo/emacs-orgmode


Thanks I'll try it there.  Even if it is very specific, people could
have some Ideas about that...  In fact there is more to do, but I
thought if I can get that result I will be able to get the other things
by myself.

Thanks,
Martin