From: Martin Thorsen Ranang <mtr@ranang.org>
To: emacs-orgmode@gnu.org
Subject: Re: Average of best- and worst-case time estimates
Date: Thu, 17 Dec 2009 14:49:05 +0100 [thread overview]
Message-ID: <877hsld832.fsf@mtr-laptop.lan> (raw)
In-Reply-To: <87fx79d84r.fsf@mtr-laptop.lan> (Martin Thorsen Ranang's message of "Thu, 17 Dec 2009 14:48:04 +0100")
[-- Attachment #1: Type: text/plain, Size: 48 bytes --]
And, of course I had to forget the attachment:
[-- Attachment #2: estimate-example.org --]
[-- Type: application/octet-stream, Size: 2911 bytes --]
* User Stories
:PROPERTIES:
:COLUMNS: %30ITEM(Feature) %5EffortBest(Best-case Estimated Effort){:} %5EffortWorst(Worst-case Estimated Effort){:} %5AvgEffort(Average Estimated Effort){:} %5CLOCKSUM
:ID: project-1
:END:
Blah, blah, blah...
** As a user, I can play with the cool widget to waste time.
*** Implement the cool widget view layer.
:PROPERTIES:
:EffortBest: 5:00
:EffortWorst: 8:00
:END:
*** Implement the control layer of the cool widget.
:PROPERTIES:
:EffortBest: 2:00
:EffortWorst: 8:00
:END:
*** Implement the model layer of the cool widget.
:PROPERTIES:
:EffortBest: 3:00
:EffortWorst: 8:00
:END:
** All users of the system can login using OpenID.
*** Implement OpenID authorization functionality
:PROPERTIES:
:EffortBest: 13:00
:EffortWorst: 21:00
:END:
* Estimates
#+BEGIN: columnview :hlines 2 :vlines nil :id "project-1" :skip-empty-rows t
| Feature | Best-case Estimated Effort | Worst-case Estimated Effort | Average Estimated Effort | CLOCKSUM |
|--------------------------------------------------------------+----------------------------+-----------------------------+--------------------------+----------|
| * User Stories | 23:00 | 45:00 | EffortBest + EffortWorst | |
|--------------------------------------------------------------+----------------------------+-----------------------------+--------------------------+----------|
| ** As a user, I can play with the cool widget to waste time. | 10:00 | 24:00 | EffortBest + EffortWorst | |
| *** Implement the cool widget view layer. | 5:00 | 8:00 | EffortBest + EffortWorst | |
| *** Implement the control layer of the cool widget. | 2:00 | 8:00 | EffortBest + EffortWorst | |
| *** Implement the model layer of the cool widget. | 3:00 | 8:00 | EffortBest + EffortWorst | |
|--------------------------------------------------------------+----------------------------+-----------------------------+--------------------------+----------|
| ** All users of the system can login using OpenID. | 13:00 | 21:00 | EffortBest + EffortWorst | |
| *** Implement OpenID authorization functionality | 13:00 | 21:00 | EffortBest + EffortWorst | |
#+TBLFM: $4=$EffortBest+$EffortWorst;
#+END:
#+PROPERTY: EffortBest_ALL 0 1:00 2:00 3:00 5:00 8:00 13:00 21:00
#+PROPERTY: EffortWorst_ALL 0 1:00 2:00 3:00 5:00 8:00 13:00 21:00
[-- Attachment #3: Type: text/plain, Size: 456 bytes --]
On to., des. 17 2009, Martin Thorsen Ranang wrote:
> Dear, Org-mode gurus.
>
> Please see my attached example file. I wonder if it is easily possible
> to calculate the average of two time formatted (hh:mm) columns.
>
> Do you know how I can express that with the :COLUMNS: attribute? If
> that is not possible, do you know how to express that as a #+TBLFM:
> specification?
>
> Any help is appreciated.
--
Vennlig hilsen,
Martin Thorsen Ranang
[-- Attachment #4: Type: text/plain, Size: 201 bytes --]
_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
prev parent reply other threads:[~2009-12-17 13:49 UTC|newest]
Thread overview: 2+ messages / expand[flat|nested] mbox.gz Atom feed top
2009-12-17 13:48 Average of best- and worst-case time estimates Martin Thorsen Ranang
2009-12-17 13:49 ` Martin Thorsen Ranang [this message]
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=877hsld832.fsf@mtr-laptop.lan \
--to=mtr@ranang.org \
--cc=emacs-orgmode@gnu.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).