Spreadsheet: 844469d1696256791-percentage-calculation-formula-incentive-plan-matrix
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