Spreadsheet: 844888d1696515427-percentage-calculation-formula-incentive-plan-matrix-darrencl-
Sheet: Matrix Answer

Monthly Attainment Calculator |  | Revenue Attainment | 2023-09-23 00:00:00 | 2023-09-23 00:00:00 | 2023-09-23 00:00:00 | 2023-09-23 00:00:00 | 2023-09-23 00:00:00 | 2023-09-23 00:00:00 | 2023-10-23 00:00:00 | 2023-10-23 00:00:00 | 2023-10-23 00:00:00 | 2023-10-23 00:00:00 | 2023-10-23 00:00:00 | 2023-10-23 00:00:00 | 2023-11-23 00:00:00 | 2023-11-23 00:00:00 | 2023-11-23 00:00:00 | 2023-11-23 00:00:00 | 2023-11-23 00:00:00 | 2023-11-23 00:00:00 | 2023-12-23 00:00:00 | 2023-12-23 00:00:00 | 2023-12-23 00:00:00 | 2023-12-23 00:00:00 | 2023-12-23 00:00:00 | 2023-12-23 00:00:00
 |  |  | 1.5 | 1.25 | 1 | 0.9 | 0.8 | Below 80% | 1.5 | 1.25 | 1 | 0.9 | 0.8 | Below 80% | 1.5 | 1.25 | 1 | 0.9 | 0.8 | Below 80% | 1.5 | 1.25 | 1 | 0.9 | 0.8 | Below 80%
Lead Delivery Attainment |  |  |  |  | 2250000 |  |  |  |  |  | 2400000 |  |  |  |  |  | 2750000 |  |  |  |  |  | 2300000
2023-09-23 00:00:00 | 1.5 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-09-23 00:00:00 | 1.25 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-09-23 00:00:00 | 1 | 75000 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-09-23 00:00:00 | 0.9 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-09-23 00:00:00 | 0.8 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-09-23 00:00:00 | Below 80% |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-10-23 00:00:00 | 1.5 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-10-23 00:00:00 | 1.25 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-10-23 00:00:00 | 1 | 80000 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-10-23 00:00:00 | 0.9 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-10-23 00:00:00 | 0.8 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-10-23 00:00:00 | Below 80% |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-11-23 00:00:00 | 1.5 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-11-23 00:00:00 | 1.25 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-11-23 00:00:00 | 1 | 91667 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-11-23 00:00:00 | 0.9 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-11-23 00:00:00 | 0.8 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-11-23 00:00:00 | Below 80% |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2023-12-23 00:00:00 | 1.5 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-12-23 00:00:00 | 1.25 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-12-23 00:00:00 | 1 | 76667 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-12-23 00:00:00 | 0.9 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-12-23 00:00:00 | 0.8 |  |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
2023-12-23 00:00:00 | Below 80% |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Percentage calculation formula (excelforum.com)
Insentive | Annual % | Multiplier
1.5 | 15
1.25 | 12.5
1 | 10
0.9 | 7.5
0.8 | 5
Below 80% | 0