I'm interested in recreating this table which shows the percentage cut off (or threshold) to earn shares (based on the size of the share pool) based off of volume of sales. The left side of the chart shows the number of shares available to earn. The top row shows the number of shares won. There is a 15% threshold to earn the first share.
What formulas/equations are required to create this table? I want to expand the table to more shares beyond 7 but can't seem to figure out to do so.
------------------------------------------------------
| | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|-----------------------------------------------------
| 3 | 16.7 | 50.0 | 83.3 |
| 4 | 15.0 | 37.5 | 62.5 | 85.0 |
| 5 | 15.0 | 30.0 | 50.0 | 70.0 | 85.0 |
| 6 | 15.0 | 25.0 | 41.7 | 58.3 | 75.0 | 85.0 |
| 7 | 15.0 | 21.4 | 35.7 | 50.0 | 64.3 | 78.6 | 85.0 |
Thanks in advance for the help and advice on this.
What formulas/equations are required to create this table? I want to expand the table to more shares beyond 7 but can't seem to figure out to do so.
------------------------------------------------------
| | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|-----------------------------------------------------
| 3 | 16.7 | 50.0 | 83.3 |
| 4 | 15.0 | 37.5 | 62.5 | 85.0 |
| 5 | 15.0 | 30.0 | 50.0 | 70.0 | 85.0 |
| 6 | 15.0 | 25.0 | 41.7 | 58.3 | 75.0 | 85.0 |
| 7 | 15.0 | 21.4 | 35.7 | 50.0 | 64.3 | 78.6 | 85.0 |
Thanks in advance for the help and advice on this.
