From mboxrd@z Thu Jan  1 00:00:00 1970
From: Cecil Westerhof <cldwesterhof@gmail.com>
Subject: Smart vsum
Date: Mon, 15 Nov 2010 13:10:52 +0100
Message-ID: <87ipzyzt0z.fsf@Compaq.site>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=53275 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1PHxsl-0006MX-G7
	for emacs-orgmode@gnu.org; Mon, 15 Nov 2010 07:10:01 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1PHxsh-0008MH-NF
	for emacs-orgmode@gnu.org; Mon, 15 Nov 2010 07:09:59 -0500
Received: from mail-ey0-f169.google.com ([209.85.215.169]:46099)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1PHxsh-0008MC-Ie
	for emacs-orgmode@gnu.org; Mon, 15 Nov 2010 07:09:55 -0500
Received: by eydd26 with SMTP id d26so2749152eyd.0
	for <emacs-orgmode@gnu.org>; Mon, 15 Nov 2010 04:09:54 -0800 (PST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/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: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

Until now I did not use org-mode for fancy things. One of the things I
use is the following table:
|---+----------+-----------|
|   | activity | time      |
|---+----------+-----------|
| * | A        | 0@ 10'    |
| * | B        | 0@ 05'    |
|   | C        | 0@ 05'    |
|   | D        | 0@ 05'    |
|   | E        | 0@ 05'    |
|---+----------+-----------|
| # | Totaal   | 0.50      |
| ^ |          | totalTime |
|---+----------+-----------|
#+TBLFM: $totalTime = deg(vsum(@-II..@-I)); f2

It is just a table with activities and the needed time pro activity.
When there is an asterisk in the first column, that means that the
activity is already done. I would like a little more fancy table that
also displays the time needed for the activities that still have to be
done. Like the following:
|---+----------+-----------|
|   | activity | time      |
|---+----------+-----------|
| * | A        | 0@ 10'    |
| * | B        | 0@ 05'    |
|   | C        | 0@ 05'    |
|   | D        | 0@ 05'    |
|   | E        | 0@ 05'    |
|---+----------+-----------|
| # | Totaal   | 0.50      |
| ^ |          | totalTime |
| # | Totaal   | 0.25      |
| ^ |          | restTime  |
|---+----------+-----------|
#+TBLFM: $totalTime = deg(vsum(@-II..@-I)); f2

Is this possible? If yes, how would I do this?

-- 
Cecil Westerhof
Senior Software Engineer
LinkedIn: http://www.linkedin.com/in/cecilwesterhof