Spreadsheet: 545963d1509749360-final-salary-to-show-in-a-different-cell-final-payout-to-be-placed-in-a-different-sheet-2-
Sheet: Data

week | date | name | sales_person | status | supervisor | appointment completed | successful sales | quality | minutes worked | call gaps | total minutes worked | Attainment | Bonus Money | Tier
1 | 2017-10-16 00:00:00 | [NAME] | [NAME] | Active | Harold | 15 | 24 | 0.99 | 8 | 60 |  | 1.5 | 275 | 6
1 | 2017-10-23 00:00:00 | Ringo | Ringo | Active | [NAME] | 3 | 3 | 0.89 | 8 | 34 |  | 2.5 | 400 | 9
1 | 2017-10-23 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 4 | 5 | 0.98 | 8 | 22 |  | 1.01 | 100 | 1
1 | 2017-10-23 00:00:00 | George | George | Active | Kelly | 1 | 2 | 0.88 | 8 | 3 |  | 0.85 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bonus Pay | 0 | 100 | 125 | 150 | 175
1 | 2017-10-23 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 6 | 6 | 0.78 | 8 | 32 |  |  |  |  |  |  | Quality Week1 | Quality Week2 | Quality Week3 | Quality Week4 | Quality Total |  |  | Basic Pay | Number of Days | Daily Rate | [NAME] | Minute Rate |  | Attainment | Target Appointment Completed | Target Quality | Target Successful Sales |  |  | Attainment [NAME] | Tier 1 | [NAME] | Tier 3 | [NAME]
1 | 2017-10-23 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 4 | 5 | 0.89 | 8 | 12 |  |  |  |  |  | name |  |  |  |  |  |  |  | 621.2 | 20 |  |  |  |  | 1 | 25 | 0.85 | 32 |  |  | 1 | 101% - 109% | 110% - 119% | 120% - 129% | 130% - 139%
1 | 2017-10-23 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 9 | 2 | 0.78 | 8 | 3 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Weight | 0.5 | 0.35 | 0.15
1 | 2017-10-24 00:00:00 | [NAME] | [NAME] | Active | Harold | 2 | 8 | 0.99 | 8 | 43 |  |  |  |  |  | Ringo |  |  |  |  |  |  |  | Please assist with the Z Column. I am not sure I got the |  |  |  |  |  |  |  |  |  |  | For them to get the bonus pay they have to reach the Attainment of 101% to receive
1 | 2017-10-24 00:00:00 | Ringo | Ringo | Active | [NAME] | 5 | 5 | 1 | 8 | 264 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | computation for the Per Minute Rate correctly. |  |  |  |  |  | The montly target is 25 for Appointment Completed, 85% for Quality and |  |  |  |  | $100 bonus pay.
1 | 2017-10-24 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 7 | 9 | 0.87 | 8 | 3 |  |  |  |  |  | George |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 for Successful Sales.
1 | 2017-10-24 00:00:00 | George | George | Active | Kelly | 8 | 4 | 0.88 | 8 | 23 |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | We then get the weighted average for each. Example, we get 50% of 25 for
1 | 2017-10-24 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 5 | 3 | 0.57 | 8 | 44 |  |  |  |  |  | Stuart |  |  |  |  |  |  |  |  |  |  |  |  |  | the Appointed Completed, 35% for Quality and 15% for Successful Sales.
1 | 2017-10-24 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 4 | 6 | 0.99 | 8 | 32 |  |  |  |  |  | [NAME]
1 | 2017-10-24 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 3 | 6 | 0.55 | 8 | 34 |  |  |  |  |  | Team Total
2 | 2017-10-17 00:00:00 | [NAME] | [NAME] | Active | Harold | 9 | 3 | 0.97 | 6 | 56
2 | 2017-10-25 00:00:00 | Ringo | Ringo | Active | [NAME] | 6 | 6 | 0.99 | 8 | 65
2 | 2017-10-25 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 5 | 7 | 0.99 | 8 | 43
2 | 2017-10-25 00:00:00 | George | George | Active | Kelly | 7 | 3 | 0.99 | 8 | 43
2 | 2017-10-25 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 3 | 5 | 0.99 | 8 | 54
2 | 2017-10-25 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 9 | 3 | 0.54 | 8 | 54
2 | 2017-10-25 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 4 | 6 | 0.37 | 8 | 53
2 | 2017-10-26 00:00:00 | [NAME] | [NAME] | Active | Harold | 3 | 9 | 0.99 | 8 | 32
2 | 2017-10-26 00:00:00 | Ringo | Ringo | Active | [NAME] | 6 | 5 | 0.87 | 8 | 43
2 | 2017-10-26 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 3 | 7 | 0.85 | 8 | 23
2 | 2017-10-26 00:00:00 | George | George | Active | Kelly | 2 | 2 | 0.96 | 8 | 32
2 | 2017-10-26 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 8 | 5 | 0.59 | 8 | 38
2 | 2017-10-26 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 5 | 3 | 0.88 | 8 | 56
2 | 2017-10-26 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 4 | 4 | 0.88 | 8 | 0
3 | 2017-10-27 00:00:00 | [NAME] | [NAME] | Active | Harold | 5 | 4 | 0.99 | 5 | 9
3 | 2017-10-27 00:00:00 | Ringo | Ringo | Active | [NAME] | 3 | 3 | 0.89 | 8 | 8
3 | 2017-10-27 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 4 | 5 | 0.77 | 8 | 7
3 | 2017-10-27 00:00:00 | George | George | Active | Kelly | 1 | 2 | 0.88 | 8 | 65
3 | 2017-10-27 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 6 | 6 | 0.78 | 8 | 5
3 | 2017-10-27 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 4 | 5 | 0.89 | 8 | 78
3 | 2017-10-27 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 9 | 2 | 0.78 | 8 | 45
3 | 2017-10-28 00:00:00 | [NAME] | [NAME] | Active | Harold | 2 | 8 | 0.99 | 8 | 6
3 | 2017-10-28 00:00:00 | Ringo | Ringo | Active | [NAME] | 5 | 5 | 1 | 8 | 5
3 | 2017-10-28 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 7 | 9 | 0.87 | 8 | 7
3 | 2017-10-28 00:00:00 | George | George | Active | Kelly | 8 | 4 | 0.88 | 8 | 58
3 | 2017-10-28 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 5 | 3 | 0.57 | 8 | 0
3 | 2017-10-28 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 4 | 6 | 0.77 | 8 | 0
3 | 2017-10-28 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 3 | 6 | 0.55 | 8 | 0
4 | 2017-10-30 00:00:00 | [NAME] | [NAME] | Active | Harold | 9 | 3 | 0.45 | 8 | 0
4 | 2017-10-30 00:00:00 | Ringo | Ringo | Active | [NAME] | 6 | 6 | 0.99 | 8 | 0
4 | 2017-10-30 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 5 | 7 | 0.65 | 8 | 55
4 | 2017-10-30 00:00:00 | George | George | Active | Kelly | 7 | 3 | 0.44 | 8 | 8
4 | 2017-10-30 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 3 | 5 | 0.99 | 8 | 6
4 | 2017-10-30 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 9 | 3 | 0.54 | 8 | 6
4 | 2017-10-30 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 4 | 6 | 0.37 | 8 | 5
4 | 2017-10-31 00:00:00 | [NAME] | [NAME] | Active | Harold | 3 | 9 | 0.99 | 8 | 6
4 | 2017-10-31 00:00:00 | Ringo | Ringo | Active | [NAME] | 6 | 5 | 0.58 | 8 | 65
4 | 2017-10-31 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 3 | 7 | 0.85 | 8 | 4
4 | 2017-10-31 00:00:00 | George | George | Active | Kelly | 2 | 2 | 0.96 | 8 | 5
4 | 2017-10-31 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 8 | 5 | 0.59 | 8 | 54
4 | 2017-10-31 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 5 | 3 | 0.47 | 8 | 5
4 | 2017-10-31 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 4 | 4 | 0.88 | 8 | 46