| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Project | Value if succesful (arbitrary units) | Probability of successful outcome | FTEs needed ("energy?") | Expected value per FTE calculation | Expected value per FTE |
2 | — | 0.1 to 100 | 0.8 | 1 | mean(0.1 to 100*0.8/1) | 23 |
3 | — | 0.1 to 100 | 0.5 | 1 | mean(0.1 to 100*0.5/1) | 14 |
4 | — | 0.01 to 10 | 0.8 | 0.5 | mean(0.01 to 10*0.8/0.5) | 4.6 |
5 | — | 0.1 to 50 | 0.2 | 0.7 | mean(0.1 to 50*0.2/0.7) | 3.8 |
6 | — | 0.1 to 10 | 0.95 | 0.7 | mean(0.1 to 10*0.95/0.7) | 3.6 |
7 | — | 0.5 to 10 | 0.5 | 0.5 | mean(0.5 to 10*0.5/0.5) | 3.4 |
8 | — | 0.001 to 100 | 0.01 | 1 | mean(0.001 to 100*0.01/1) | 1.4 |
9 | — | 0.1 to 10 | 0.3 | 1 | mean(0.1 to 10*0.3/1) | 0.8 |
10 | — | 0.01 to 1 | 1 | 0.5 | mean(0.01 to 1*1/0.5) | 0.5 |
11 | — | 0.01 to 1 | 0.7 | 0.7 | mean(0.01 to 1*0.7/0.7) | 0.3 |
12 | ||||||
13 |