Average of best- and worst-case time estimates

Average of best- and worst-case time estimates

[Martin Thorsen Ranang]

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

Re: Average of best- and worst-case time estimates

[Martin Thorsen Ranang]

[-- 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