| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | ||||||
2 | Assumptions | |||||
3 | ||||||
4 | Initial PAR: | 20% | ||||
5 | ||||||
6 | Decay: | |||||
7 | Full PAR | 10% | ||||
8 | Between rounds | 5% | ||||
9 | ||||||
10 | ||||||
11 | ||||||
12 | Notes | |||||
13 | In the "Setup" tab, every possible binomial scenario is made. An initial filtering is also done to reduce file size. | |||||
14 | ||||||
15 | Not all of the scenarios in the "FilteredScenarios" tab are possible because of between round decay. | |||||
16 | However, this is addressed in the "Calculation" tab, as the probability of those scenarios is 0. | |||||
17 | ||||||
18 | Cells with red text have formulas - other cells within that column also use the same fomula, but have had the values repasted in. | |||||
19 | When assumptions are updated, need to manually refresh these hardcoded cells. | |||||
20 |