From: "Sebastien Vauban" <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org>
To: emacs-orgmode-mXXj517/zsQ@public.gmane.org
Subject: Remaining Work Report
Date: Mon, 19 Mar 2012 14:33:17 +0100 [thread overview]
Message-ID: <80ehsog1gi.fsf@somewhere.org> (raw)
#+COLUMNS: %40ITEM(Task) %6Effort(Estim.){:}
* Context
The question I'm trying to give an answer to is: *what's the remaining number
of hours (or days) to finish my project*?
I don't see obvious solutions for that question. And trials I've done
hereunder did not lead yet to satisfactory results.
Am I passing next to some more obvious solution?
* Development tasks
:PROPERTIES:
:ID: fc314ab6-5bdc-4a2d-9c2d-d9aece03a864
:END:
** DONE Task 1 :Fred:
:PROPERTIES:
:Effort: 1:00
:END:
** TODO Task 2
*** DONE Task 2a :Fred:
:PROPERTIES:
:Effort: 2:00
:END:
*** TODO Task 2b :Sara:
:PROPERTIES:
:Effort: 4:00
:END:
** TODO Task 3 :Sara:
:PROPERTIES:
:Effort: 8:00
:END:
* Reporting
I'd like to report remaining work, among others.
** Columnview
From the columnview, we can't do that, as there is no way to exclude some
lines, and hence no way to get the right total.
#+BEGIN: columnview :hlines 1 :id "fc314ab6-5bdc-4a2d-9c2d-d9aece03a864" :maxlevel 2
| Task | Estim. |
|-----------------------+--------|
| * Development tasks | 15:00 |
| ** DONE Task 1 :Fred: | 1:00 |
| ** TODO Task 2 | 6:00 |
| ** TODO Task 3 :Sara: | 8:00 |
#+END:
** Propview
After a =(require 'org-collector)=, we can get a table similar to this one:
#+BEGIN: propview :id "fc314ab6-5bdc-4a2d-9c2d-d9aece03a864" :conds ((string= TODO "TODO")) :cols (ITEM Effort)
| ITEM | Effort |
|----------------+--------|
| "TODO Task 2" | "6:00" |
| "TODO Task 2b" | "4:00" |
| "TODO Task 3" | "8:00" |
|----------------+--------|
| | |
#+END:
There is a good step in the right direction, in that I don't have anymore
headlines with keyword DONE appearing.
Though,
1. There is no total available, and summing such a table give false results
(due to the string nature of the values?):
| ITEM | Effort |
|----------------+--------|
| "TODO Task 2" | "6:00" |
| "TODO Task 2b" | "4:00" |
| "TODO Task 3" | "8:00" |
|----------------+--------|
| | 624 |
#+TBLFM: @5$2=vsum(@-I..-II)
2. Exclusion of lines can be tricky, as shown above:
- "project 2" is task 2a (DONE, 2 hours) + task 2b (TODO, 4 hours)
- total of "project 2" tasks is 6 hours, then
- "project 2" is not DONE yet, as task 2b is still TODO
- but remaining time of "project 2" is 4 hours, not 6
The fact that org-collector shows 6 hours is due to a mix:
- "project" is still in state TODO,
- we show tasks (or projects) up to level 2, with sub-tasks being /summed up/
3. Not giving a status keyword to the "project 2" does not solve anything: in
this case, nothing would show up in org-collector's view.
I understand I could be misusing org-collector.
But that's not what I'm after: if there is an alternative way to be able to
report remaining work to be done on a project, please let me know.
Best regards,
Seb
--
Sebastien Vauban
next reply other threads:[~2012-03-19 13:33 UTC|newest]
Thread overview: 7+ messages / expand[flat|nested] mbox.gz Atom feed top
2012-03-19 13:33 Sebastien Vauban [this message]
2012-03-22 14:33 ` Remaining Work Report Myles English
2012-03-24 14:28 ` Manish
2012-03-26 10:49 ` Myles English
2012-03-26 13:03 ` Sebastien Vauban
2012-05-03 14:38 ` Sebastien Vauban
[not found] ` <87havhk5qn.fsf@gmail.com>
2012-05-15 14:39 ` Myles English
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=80ehsog1gi.fsf@somewhere.org \
--to=wxhgmqzgwmuf-genee64ty+gs+fvcfc7uqw@public.gmane.org \
--cc=emacs-orgmode-mXXj517/zsQ@public.gmane.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).