From mboxrd@z Thu Jan 1 00:00:00 1970 From: Daniel Rigby Subject: Using org-mode for project replanning Date: Wed, 30 Jul 2014 16:12:21 +0100 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=001a1139a62438d13804ff6a9592 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:60125) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XCVYI-000390-Bx for emacs-orgmode@gnu.org; Wed, 30 Jul 2014 11:12:32 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XCVYE-0005p1-Ms for emacs-orgmode@gnu.org; Wed, 30 Jul 2014 11:12:26 -0400 Received: from mail-qg0-x230.google.com ([2607:f8b0:400d:c04::230]:55196) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XCVYE-0005nl-JQ for emacs-orgmode@gnu.org; Wed, 30 Jul 2014 11:12:22 -0400 Received: by mail-qg0-f48.google.com with SMTP id i50so1605409qgf.7 for ; Wed, 30 Jul 2014 08:12:22 -0700 (PDT) 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 --001a1139a62438d13804ff6a9592 Content-Type: text/plain; charset=UTF-8 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. --001a1139a62438d13804ff6a9592 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi all,

I've been using org-mode to track the t= ime spent on various tasks in a project. I'm now planning additional ta= sks, and for these new tasks I am adding time estimates. The columnview dyn= amic 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= =20 settings I'm using, although I'm just experimenting with this at th= e=20 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")
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= ("STYLE_ALL" . "habit"))))

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

:CO= LUMNS: %80ITEM(Task) %TODO(Status) %Effort(Estimated time){:} %CLOCKSUM(Act= ual time) %10Effort(Outstanding){:}

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

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

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

Many thanks.

--001a1139a62438d13804ff6a9592--