[O] Using org-mode for project replanning

[Daniel Rigby]

Hi all,

I've been using org-mode to track the time spent on various tasks in a project. I'm now planning additional tasks, and for these new tasks I am adding time estimates. The columnview dynamic block gives a nice summary of the time I've spent on tasks and the time estimates.

I'm specifying the time estimates in hours and days. These are the settings I'm using, although I'm just experimenting with this at the moment

(setq org-global-properties (quote (("Effort_ALL" . "1:00 2:00 3:00 4:00 5:00 6:00 .25d .5d 1d 2d 3d 4d 5d 1w 2w 3w 4w 0:00")
                                    ("STYLE_ALL" . "habit"))))

I am using the following property to set up the column view.

:COLUMNS: %80ITEM(Task) %TODO(Status) %Effort(Estimated time){:} %CLOCKSUM(Actual time) %10Effort(Outstanding){:}

What I'm interested in tracking is how much time the outstanding tasks will take - this should go in the 'Outstanding' column. Is there a way to print the estimated time for outstanding tasks only? Maybe a table formula would work a bit like "if Status == TODO then print estimated time else print 0".

It's a bit more complicated than it first looks because of how estimates in days and weeks are interpreted.

Any ideas on how to populate the 'Outstanding' column?
Additionally, if possible, is there a way to make the table contain just the outstanding tasks?

Many thanks.