From mboxrd@z Thu Jan  1 00:00:00 1970
From: Martin <kleinerdrache@gmx.at>
Subject: special table from clock
Date: Thu, 13 Mar 2014 17:25:14 +0100
Message-ID: <87iorirrpx.fsf@gmx.at>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:45250)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <kleinerdrache@gmx.at>) id 1WO8Rh-0007ho-Cn
	for emacs-orgmode@gnu.org; Thu, 13 Mar 2014 12:25:32 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <kleinerdrache@gmx.at>) id 1WO8Ra-0004qR-3u
	for emacs-orgmode@gnu.org; Thu, 13 Mar 2014 12:25:25 -0400
Received: from mout.gmx.net ([212.227.17.22]:56509)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <kleinerdrache@gmx.at>) id 1WO8RZ-0004qL-QZ
	for emacs-orgmode@gnu.org; Thu, 13 Mar 2014 12:25:18 -0400
Received: from martin-desktop ([62.46.153.9]) by mail.gmx.com (mrgmx003) with
	ESMTPSA (Nemesis) id 0MaZrd-1Wha2H28gD-00KCA8 for
	<emacs-orgmode@gnu.org>; Thu, 13 Mar 2014 17:25:16 +0100
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org



Hi there,

I know, this is a very special question, but I hope you have some ideas
about that.

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