Spreadsheet: 101440d1299565151-bonus-calculation-sample_bonus
Sheet: ISE Bonus & Comission

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40610
 |  |  | 8 | 22 |  |  | 9 | 23 |  | 10 | 24 |  | 11 | 25 |  | 12 | 26 |  | 13 | 27 |  | 14 | 28 |  | 15 | 29 |  | 16 | 30 |  | 17 | 31 |  | 18 | 32 |  | 19 | 33
 |  |  | P1 |  | P1 Bonus |  | P2 |  | P2 Total | P3 |  | P3 Total | P4 |  | P4 Total | P5 |  | P5 Total | P6 |  | P6 Total | P7 |  | P7 Total | P8 |  | P8 Total | P9 |  | P9 Total | P10 |  | P10 Total | P11 |  | P11 Total | P12 |  | P12 Total | YTD |  | YTD Total
 |  | ISE Name | Purge | Quota | % to purge | bonus | Purge | Quota | % to purge | Purge | Quota | % to purge | Purge | Quota | % to purge | Purge | Quota | % to purge | Purge | Quota | % to purge | Purge | Quota | % to purge | Purge | Quota | % to purge | Purge | Quota | % to purge | Purge | Quota | % to purge | Purge | Quota | % to purge | Purge | Quota | % to purge | Purge | Quota | % to purge
 |  | [NAME] | 12222 | 15000 | 0.8148 |  | 0 | 15000 |  | 0 | 15000 |  | 0 | 15000 |  | 0 | 15000 |  | 0 | 15000 |  | 0 | 15000 |  | 0 | 15000 |  | 0 | 15000 |  | 0 | 15000 |  | 0 | 15000 |  | 0 | 15000
 |  | [NAME] | 14560 | 17000 | 0.8564705882352941
 |  | [NAME] | 0 | 0 | #N/A
 |  | [NAME] | 15654 | 15000 | 1.0436
 |  | Zach Praise | 11233 | 12000 | 0.9360833333333334
 |  | [NAME] | 5655 | 15000 | 0.377
 |  | [NAME] | 15000 | 15000 | 1
 |  | [NAME] | 3600 | 9000 | 0.4
 |  | [NAME] | 19500 | 20000 | 0.975
 |  | ISE Name
 |  | ISE Name
 |  | ISE Name
 |  | ISE Name
 |  | ISE Name
 |  | ISE Name
 |  | ISE Name
 |  | ISE Name
 |  | ISE Name
 |  |  | 8 |  |  |  | 9 |  |  | 10 |  |  | 11 |  |  | 12 |  |  | 13 |  |  | 14 |  |  | 15 |  |  | 16 |  |  | 17 |  |  | 18 |  |  | 19
 |  |  | P1 |  | P1 Total |  | P2 |  | P2 Total | P3 |  | P3 Total | P4 |  | P4 Total | P5 |  | P5 Total | P6 |  | P6 Total | P7 |  | P7 Total | P8 |  | P8 Total | P9 |  | P9 Total | P10 |  | P10 Total | P11 |  | P11 Total | P12 |  | P12 Total | YTD |  | YTD Total
 |  | ISE Name | Purge | CSA (S.L $) | Total |  | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total | Purge | CSA (S.L $) | Total
 |  | [NAME] | 12222 | 240 | 12462 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12222 | 240 | 12462
 |  | [NAME] | 14560 | 0 | 14560 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14560 | 0 | 14560
 |  | [NAME] | 0 | 0 | 0 |  | 4500 | 0 | 4500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4500 | 0 | 4500
 |  | [NAME] | 15654 | 0 | 15654 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15654 | 0 | 15654
 |  | Zach Praise | 11233 | 0 | 11233 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11233 | 0 | 11233
 |  | [NAME] | 5655 | 0 | 5655 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5655 | 0 | 5655
 |  | [NAME] | 15000 | 0 | 15000 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 15000 | 0 | 15000
 |  | [NAME] | 3600 | 0 | 3600 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3600 | 0 | 3600
 |  | [NAME] | 19500 | 0 | 19500 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19500 | 0 | 19500
 |  | ISE Name | - | 0 | 0 |  | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | 0 | 0 | 0
 |  | ISE Name | - | 0 | 0 |  | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | 0 | 0 | 0
 |  | ISE Name | - | 0 | 0 |  | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | 0 | 0 | 0
 |  | ISE Name | - | 0 | 0 |  | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | 0 | 0 | 0
 |  | ISE Name | - | 0 | 0 |  | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | 0 | 0 | 0
 |  | ISE Name | - | 0 | 0 |  | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | 0 | 0 | 0
 |  | ISE Name | - | 0 | 0 |  | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | 0 | 0 | 0
 |  | ISE Name | - | 0 | 0 |  | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | 0 | 0 | 0
 |  | ISE Name | - | 0 | 0 |  | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | - | 0 | 0 | 0 | 0 | 0