From mboxrd@z Thu Jan 1 00:00:00 1970 From: OSiUX Subject: Re: How to analyze clocking reports (e. g. with spreadsheet application)? Date: Sun, 28 Apr 2013 11:51:50 -0300 Message-ID: <20130428145150.GA9271@osiux.com.ar> References: Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="xHFwDpU9dbj6ez1V" Return-path: Received: from eggs.gnu.org ([208.118.235.92]:51184) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UWSxO-0006kR-Kw for emacs-orgmode@gnu.org; Sun, 28 Apr 2013 10:52:03 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1UWSxM-0001Tb-7R for emacs-orgmode@gnu.org; Sun, 28 Apr 2013 10:52:02 -0400 Received: from merlot.gcoop.coop ([67.208.113.123]:39647) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1UWSxM-0001TF-1a for emacs-orgmode@gnu.org; Sun, 28 Apr 2013 10:52:00 -0400 Received: from osiux.com.ar (merlot [127.0.0.1]) (Authenticated sender: xuiso@osiux.com.ar) by merlot.gcoop.coop (Postfix) with ESMTPSA id 1B067149068 for ; Sun, 28 Apr 2013 11:52:18 -0300 (ART) Content-Disposition: inline In-Reply-To: List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 --xHFwDpU9dbj6ez1V Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable El s=C3=A1b, 27 abr 2013, Martin dec=C3=ADa: > I'm using the org-mode clocking features (in org-mode 7.9.4) extensively= =20 > to document how much time I spent with which task and when. >=20 > I wonder how I can export the data (e. g. to MS Excel) for further analys= is; > * time consumed by different projects > * interruptions and "jumping" from task to task > * time consumed by tasks with a special tag > etc. >=20 > I searched the internet and this list, but I did not find any description= =20 > from someone who has already=20 > done that (however I'm quite sure that I'm not the first one with this id= ea). >=20 > Any hints on how to do it or tutorials/reports from others are welcome. >=20 > Martin is possible to obtain statistics using a bash script and plot by gnuplot, an article about it in Spanish: http://www.osiux.com/visualizando-org-mode-con-gnuplot.html and a graph of each month regarding the same color for each task over a year http://www.osiux.com/img/org-task-by-day-2012.png soon publish a new article in English... recently created a public repository with some bash scripts: https://github.com/osiris/org-bash-utils --=20 :: Osiris Alejandro Gomez (OSiUX) osiux@osiux.com.ar DC44 95D2 0D5D D544 FC1A F00F B308 A671 9237 D36C http://www.osiux.com.ar http://www.altermundi.net --xHFwDpU9dbj6ez1V Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iQIcBAEBAgAGBQJRfTeFAAoJELMIpnGSN9NsUuAP/0hN6HesqHvnAq2A9HfCu1bB objd0rSpoX7N6RseAQ1eRJLh75AhZZYbWSp4R5T2ehaE/Zfo1Mj261D26ds9IZR/ aiiWyuILg/t+u+Vp3oOS+W/jpzRsw79F22Tq+srB7Siv8bW9PYEKipuxHN3LHRSJ fz6gBGhgH9SyIY0+FnyIcrL7fROJKeAXJDc9ut/6k+kuLZzLZgVwgiIaD0mzMzYW mrRq3mLCOsf2izLmtRmuj9cutAhoPXHMByMl1TyACJMWtrMZgaRTDu4qP5Fc7w4F Uukw8iL4zl8sQ+NjwCaqo7v3dStlf4MBYmm8zTq8NvJAlk+HGNqAc+dtYdFYFkzG GL6AGSOlPTrEulphc2bZ5u2mZ8y5Z7QbU1ckOtHhpbPLyZvgAEfC/uiDTPyWmL3b fgEeuPHKZ5TsFX+xY04Hx4RYfGEDS6c6+evTp+ZYWO8luRavhCo3Fz1d8rEgH8AH HXuhrLjasSe5lA53YP9vNgfM4TqjapZan15qjk9kVGgLiQoLFHAYyvYq9Rrbskui DbVVwKk4U7KvBRfw6qDadRDEDgx5dm4YeU4firpdWl9bsA0FIzsQpuIeubviFVxQ LpgTdUUbI/sHoRbmBBWVK9vzi65A5a6AJcXa8mMFtkbcBOIAsV1yDmm8OkNPgfEo ullgg27lM6xJb/kPrp3M =1pEU -----END PGP SIGNATURE----- --xHFwDpU9dbj6ez1V--