Last active
December 12, 2017 05:53
-
-
Save accidentalrebel/0df9f9e024c7e3d433ef8a4f9fada2a9 to your computer and use it in GitHub Desktop.
This is an orgmode template that I use when making Risk-Adjusted Technical Estimates.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#+TBLNAME: estimates | |
| Task | Estimate | Confidence | Risk Adjusted | Revisions and Fixes | Testing | Total | | |
|-----------+----------+------------+---------------+---------------------+---------+-----------| | |
| Test Task | 2 | 9 | 2.2222222 | 1 | 1 | 4.2222222 | | |
|-----------+----------+------------+---------------+---------------------+---------+-----------| | |
| | 2 | 9 | 3 | 1 | 1 | 5 | | |
#+TBLFM: @>$3=vmean(@2$3..@II$3)::@>$2=vsum(@2$2..@II$2)::@>$4=ceil(vsum(@2$4..@II$4))::@>$5=ceil(vsum(@2$5..@II$5))::@>$6=ceil(vsum(@2$5..@II$5))::$4=$2+($2*(10-$3)/9)::$5=ceil($4 * remote(factors, @1$2))::$6=ceil($4 * remote(factors, @2$2))::$7=$4+$5+$6 | |
|-------------------------------+-------| | |
| Average confidence | 9 | | |
| Estimated hours | 2 | | |
| Risk-Adjusted Estimated Hours | 3 | | |
| Revisions and Fixes | 1 | | |
| Testing | 1 | | |
|-------------------------------+-------| | |
| Total Hours | 5 | | |
| Total Days | 0.625 | | |
|-------------------------------+-------| | |
#+TBLFM: @1$2=remote(estimates, @>$3)::@2$2=remote(estimates, @>$2)::@3$2=remote(estimates,@>$4)::@4$2=remote(estimates,@>$5)::@5$2=remote(estimates,@>$6)::@6$2=@3+@4+@5::@7$2=@6/8 | |
#+TBLNAME: factors | |
|----------------------------+-----| | |
| Revisions and Fixes Factor | 0.3 | | |
| Testing Factor | 0.3 | | |
|----------------------------+-----| | |
#+TBLNAME: legend | |
|----+--------------------------------------------------------------------------------------------------------------------------------------------------------| | |
| 1 | No clue -- don't make decisions on this. We need to talk more. | | |
| 2 | Hardly a clue -- don't make decisions on this. We need to talk more. | | |
| 3 | Someone else has done this and I read about it; job not well defined -- don't make decisions on this. We need to talk more. | | |
| 4 | Someone else has done this and I think I understand this; job might not be well-defined -- don't make decisions on this. We need to talk more. | | |
| 5 | Done something similar to this before and this relates to that work -- this estimate has a variance of +/- 50 percent of estimate. | | |
| 6 | I think I understand this fairly well and I understand the goal. | | |
| 7 | The average case for programming when the requirements are understood. | | |
| 8 | A confident case for programming. It's rare that something unexpected would happen. | | |
| 9 | I've done this before and it's very similar. If something unexpected comes up, I know how to tackle it. | | |
| 10 | No matter what, I'm only going to work on this for the specified period of time | | |
|----+--------------------------------------------------------------------------------------------------------------------------------------------------------| |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment