Skip to content

Instantly share code, notes, and snippets.

@accidentalrebel
Last active December 12, 2017 05:53
Show Gist options
  • Save accidentalrebel/0df9f9e024c7e3d433ef8a4f9fada2a9 to your computer and use it in GitHub Desktop.
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.
#+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