Spreadsheet: 545652d1509610943-how-to-show-it-as-a-blank-value-in-a-cell-how-to-show-as-a-blank-cell
Sheet: Data

week | date | name | sales_person | status | supervisor | appointment completed | successful sales | quality | minutes worked | call gaps | total minutes worked
1 | 2017-10-16 00:00:00 | [NAME] | [NAME] | Active | Harold | 15 | 24 | 99 | 8 | 60
1 | 2017-10-23 00:00:00 | Ringo | Ringo | Active | [NAME] | 3 | 3 | 89 | 8 | 34
1 | 2017-10-23 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 4 | 5 | 98 | 8 | 22
1 | 2017-10-23 00:00:00 | George | George | Active | Kelly | 1 | 2 | 88 | 8 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bonus Pay | 0 | 100 | 125 | 150 | 175
1 | 2017-10-23 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 6 | 6 | 78 | 8 | 32 |  |  |  | Quality Week1 | Quality Week2 | Quality Week3 | Quality Week4 | Quality Total | Average |  | 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 | 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 | 78 | 8 | 3 |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Weight | 0.5 | 0.35 | 0.15
1 | 2017-10-24 00:00:00 | [NAME] | [NAME] | Active | Harold | 2 | 8 | 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 | 87 | 8 | 3 |  |  | George |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 for Successful Sales.
1 | 2017-10-24 00:00:00 | George | George | Active | Kelly | 8 | 4 | 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 | 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 | 99 | 8 | 32 |  |  | [NAME]
1 | 2017-10-24 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 3 | 6 | 55 | 8 | 34 |  |  | Team Total
2 | 2017-10-17 00:00:00 | [NAME] | [NAME] | Active | Harold | 9 | 3 |  | 6 | 56
2 | 2017-10-25 00:00:00 | Ringo | Ringo | Active | [NAME] | 6 | 6 | 99 | 8 | 65
2 | 2017-10-25 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 5 | 7 | 99 | 8 | 43
2 | 2017-10-25 00:00:00 | George | George | Active | Kelly | 7 | 3 | 99 | 8 | 43 |  |  | PREFERRED RESULTS:
2 | 2017-10-25 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 3 | 5 | 99 | 8 | 54
2 | 2017-10-25 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 9 | 3 | 54 | 8 | 54 |  |  |  | Quality Week1 | Quality Week2 | Quality Week3 | Quality Week4 | Quality Total
2 | 2017-10-25 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 4 | 6 | 37 | 8 | 53 |  |  | name
2 | 2017-10-26 00:00:00 | [NAME] | [NAME] | Active | Harold | 3 | 9 |  | 8 | 32 |  |  | [NAME] | 99 |  | 99 | 72 | 90 | Column S23 value should be 90 instead of the value in S8 which shows 68.
2 | 2017-10-26 00:00:00 | Ringo | Ringo | Active | [NAME] | 6 | 5 | 87 | 8 | 43 |  |  | Ringo |  |  |  |  |  | Sometimes the employee would only have 1 or 2 Quality so we don't want
2 | 2017-10-26 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 3 | 7 | 85 | 8 | 23 |  |  | [NAME] |  |  |  |  |  | it to be divided by 4.  It should depend on how many Quality scores and if he
2 | 2017-10-26 00:00:00 | George | George | Active | Kelly | 2 | 2 | 96 | 8 | 32 |  |  | George |  |  |  |  |  | doesn't have a score for the week, it should not show as 0 but just blank.
2 | 2017-10-26 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 8 | 5 | 59 | 8 | 38 |  |  | [NAME]
2 | 2017-10-26 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 5 | 3 | 88 | 8 | 56 |  |  | Stuart
2 | 2017-10-26 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 4 | 4 | 88 | 8 | 0 |  |  | [NAME] |  |  |  |  |  | [NAME] for Week 2 didn't have any Quality so P23 should show as blank and not
3 | 2017-10-27 00:00:00 | [NAME] | [NAME] | Active | Harold | 5 | 4 | 99 | 5 | 9 |  |  | Team Total |  |  |  |  |  | like P8 which shows 0.
3 | 2017-10-27 00:00:00 | Ringo | Ringo | Active | [NAME] | 3 | 3 | 89 | 8 | 8 |  |  |  |  |  |  |  |  | We prefer it to show as blank if there's no quality, so he's total won't be low.
3 | 2017-10-27 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 4 | 5 | 77 | 8 | 7
3 | 2017-10-27 00:00:00 | George | George | Active | Kelly | 1 | 2 | 88 | 8 | 65
3 | 2017-10-27 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 6 | 6 | 78 | 8 | 5
3 | 2017-10-27 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 4 | 5 | 89 | 8 | 78
3 | 2017-10-27 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 9 | 2 | 78 | 8 | 45
3 | 2017-10-28 00:00:00 | [NAME] | [NAME] | Active | Harold | 2 | 8 | 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 | 87 | 8 | 7
3 | 2017-10-28 00:00:00 | George | George | Active | Kelly | 8 | 4 | 88 | 8 | 58
3 | 2017-10-28 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 5 | 3 | 57 | 8 | 0
3 | 2017-10-28 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 4 | 6 | 77 | 8 | 0
3 | 2017-10-28 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 3 | 6 | 55 | 8 | 0
4 | 2017-10-30 00:00:00 | [NAME] | [NAME] | Active | Harold | 9 | 3 | 45 | 8 | 0
4 | 2017-10-30 00:00:00 | Ringo | Ringo | Active | [NAME] | 6 | 6 | 99 | 8 | 0
4 | 2017-10-30 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 5 | 7 | 65 | 8 | 55
4 | 2017-10-30 00:00:00 | George | George | Active | Kelly | 7 | 3 | 44 | 8 | 8
4 | 2017-10-30 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 3 | 5 | 99 | 8 | 6
4 | 2017-10-30 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 9 | 3 | 54 | 8 | 6
4 | 2017-10-30 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 4 | 6 | 37 | 8 | 5
4 | 2017-10-31 00:00:00 | [NAME] | [NAME] | Active | Harold | 3 | 9 | 99 | 8 | 6
4 | 2017-10-31 00:00:00 | Ringo | Ringo | Active | [NAME] | 6 | 5 | 58 | 8 | 65
4 | 2017-10-31 00:00:00 | [NAME] | [NAME] | Active | [NAME] | 3 | 7 | 85 | 8 | 4
4 | 2017-10-31 00:00:00 | George | George | Active | Kelly | 2 | 2 | 96 | 8 | 5
4 | 2017-10-31 00:00:00 | [NAME] | [NAME] | Inactive | Harold | 8 | 5 | 59 | 8 | 54
4 | 2017-10-31 00:00:00 | Stuart | Stuart | Inactive | [NAME] | 5 | 3 | 47 | 8 | 5
4 | 2017-10-31 00:00:00 | [NAME] | [NAME] | Inactive | [NAME] | 4 | 4 | 88 | 8 | 46