* Average of best- and worst-case time estimates
@ 2009-12-17 13:48 Martin Thorsen Ranang
2009-12-17 13:49 ` Martin Thorsen Ranang
0 siblings, 1 reply; 2+ messages in thread
From: Martin Thorsen Ranang @ 2009-12-17 13:48 UTC (permalink / raw)
To: emacs-orgmode
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.
--
Sincerely yours,
Martin Thorsen Ranang
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: Average of best- and worst-case time estimates
2009-12-17 13:48 Average of best- and worst-case time estimates Martin Thorsen Ranang
@ 2009-12-17 13:49 ` Martin Thorsen Ranang
0 siblings, 0 replies; 2+ messages in thread
From: Martin Thorsen Ranang @ 2009-12-17 13:49 UTC (permalink / raw)
To: emacs-orgmode
[-- 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
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2009-12-17 13:49 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2009-12-17 13:48 Average of best- and worst-case time estimates Martin Thorsen Ranang
2009-12-17 13:49 ` Martin Thorsen Ranang
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).