Spreadsheet: 80501d1280751245-index-match-formula-not-pulling-through-desired-results-agent-average-cc-2010-version-2-
Sheet: July

 |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  | Ranking |  |  |  | Agent Ranking on Sales
Agent Name | AB Number | Team Leader | 2010-07-28 00:00:00 | 2010-07-27 00:00:00 | 2010-07-26 00:00:00 | 2010-07-24 00:00:00 | 2010-07-23 00:00:00 | 2010-07-22 00:00:00 | 2010-07-21 00:00:00 | 2010-07-20 00:00:00 | 2010-07-19 00:00:00 | 2010-07-17 00:00:00 | 2010-07-16 00:00:00 | 2010-07-15 00:00:00 | 2010-07-14 00:00:00 | 2010-07-13 00:00:00 | 2010-07-12 00:00:00 | 2010-07-10 00:00:00 | 2010-07-09 00:00:00 | 2010-07-08 00:00:00 | 2010-07-07 00:00:00 | 2010-07-06 00:00:00 | 2010-07-05 00:00:00 | 2010-07-03 00:00:00 | 2010-07-02 00:00:00 | 2010-07-01 00:00:00 | Monthly Average | Monthly average (Excl Saturdays) | Consultant | Monthly Average (Excl Saturday) | Sales |  |  | # | Consultant | Sales
Hope Seemise | EXIS123 | 0 | 4 | 4 | 2 |  |  | 6 | 5 | 8 | 4 |  | 2 |  | 5 | 8 | 6 |  | 3 | 2 | 7 | 5 |  |  |  |  | 4.733333333333333 | 4.733333333333333 | [NAME] | 8.4 | 171 |  |  | 1 | [NAME] | 171
[NAME] | EXAM322 | [NAME] | 7 | 9 | 4 |  | 4 | 7 |  | 5 | 7 | 4 | 5 | 6 | 6 | 5 | 6 |  | 4 | 4 | 4 | 4 | 5 |  | 4 | 3 | 5.15 | 5.210526315789473 | [NAME] | 8.263157894736842 | 160 |  |  | 2 | Kamo C Maripane | 169
[NAME] | ABLP420 | [NAME] | 8 | 8 | 12 |  | 6 | 10 | 12 | 7 | 9 | 3 | 7 | 11 | 8 | 8 | 10 |  | 8 | 7 | 8 | 10 | 5 |  | 5 | 9 | 8.142857142857142 | 8.4 | Kamo C Maripane | 8.15 | 169 |  |  | 3 | [NAME] | 160
[NAME] | ABBT137 | [NAME] | 6 | 6 | 6 | 2 | 6 | 5 | 7 | 4 | 9 |  | 6 |  |  |  | 4 |  | 5 | 2 | 8 | 9 | 7 |  | 6 | 7 | 5.833333333333333 | 6.058823529411764 | Bridget Mohale | 8.058823529411764 | 139 |  |  | 4 | Nyadzawela [NAME] | 155
Bridget Mohale | [NAME] | [NAME] | 10 | 8 | 6 |  | 7 | 8 | 6 | 12 | 8 |  | 9 | 9 |  |  |  |  | 1 | 13 | 5 | 8 | 6 | 2 | 11 | 10 | 7.722222222222222 | 8.058823529411764 | [NAME] | 8.055555555555555 | 154 |  |  | 5 | [NAME] | 154
[NAME] | ABCW433 | [NAME] | 10 | 5 | 7 | 5 | 5 | 4 | 5 | 5 | 5 | 4 | 3 | 4 | 2 | 7 | 3 |  |  |  |  | 13 | 3 |  | 5 | 7 | 5.368421052631579 | 5.470588235294118 | Nyadzawela [NAME] | 7.842105263157895 | 155 |  |  | 6 | [NAME] | 154
[NAME] | EXDM277 | [NAME] | 9 | 6 | 10 |  | 6 | 7 | 7 | 9 |  |  | 9 | 9 | 4 | 9 | 6 | 1 | 3 | 6 | 5 | 8 | 7 | 4 | 6 | 9 | 6.666666666666667 | 7.105263157894737 | [NAME] | 7.5 | 154 |  |  | 7 | [NAME] | 154
[NAME] | ABDV180 | [NAME] | 9 | 8 | 8 |  | 4 | 11 | 9 | 9 | 8 | 3 | 8 | 9 | 6 | 8 | 10 |  | 7 | 6 | 8 | 11 |  |  | 6 | 12 | 8 | 8.263157894736842 | Ranchia Nokayi | 7.45 | 153 |  |  | 8 | Ranchia Nokayi | 153
Danisile [NAME] | EXDM318 | 0 | 4 | 3 | 3 |  | 1 | 3 | 3 | 1 | 2 |  | 1 |  | 2 | 3 | 3 |  | 1 |  |  |  |  |  |  |  | 2.307692307692307 | 2.307692307692307 | [NAME] | 7.4 | 37 |  |  | 9 | Innocentia Letsoalo | 147
[NAME] | EXNB190 | Marinda du Plessis | 3 | 6 | 4 |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 6 | 6 | 2 |  | 6 | 3 | 4.222222222222222 | 4.222222222222222 | [NAME] | 7.25 | 154 |  |  | 10 | [NAME] | 145
[NAME] | EXEM221 | [NAME] | 7 | 6 | 9 |  | 12 | 6 | 7 | 7 | 7 | 4 | 6 | 9 | 6 | 5 | 14 |  | 7 | 5 | 9 | 6 | 8 |  | 7 | 7 | 7.333333333333333 | 7.5 | [NAME] | 7.105263157894737 | 140 |  |  | 11 | [NAME] | 144
[NAME] | ABFH099 | [NAME] | 11 | 6 | 7 | 5 | 3 | 6 | 3 | 6 | 8 |  | 3 | 2 | 2 |  | 1 |  | 1 |  | 4 | 6 | 6 |  | 5 | 8 | 4.894736842105263 | 4.888888888888889 | Innocentia Letsoalo | 7.1 | 147 |  |  | 12 | [NAME] | 140
Glodean ([NAME]) Mekwa | EXGM103 | [NAME] | 1 | 7 | 10 | 1 | 2 | 5 | 6 | 3 | 7 |  | 1 | 3 | 4 | 1 | 5 |  | 2 | 4 | 10 | 5 | 5 | 1 | 5 | 4 | 4.181818181818182 | 4.5 | [NAME] | 7.05 | 144 |  |  | 13 | Bridget Mohale | 139
[NAME] | EXGM232 | Marinda du Plessis | 5 | 7 |  |  | 4 | 1 | 8 |  | 5 | 1 | 2 | 8 | 5 | 2 | 8 |  | 6 | 4 | 5 | 8 | 6 |  | 4 | 7 | 5.052631578947368 | 5.277777777777778 | [NAME] | 7.05 | 145 |  |  | 14 | [NAME] | 134
Innocentia Letsoalo | EXIL107 | [NAME] | 7 | 10 | 8 |  | 8 | 6 | 5 | 7 | 8 | 2 | 6 | 10 | 3 | 8 | 4 |  | 4 | 6 | 8 | 9 | 9 | 3 | 8 | 8 | 6.681818181818182 | 7.1 | [NAME] | 6.777777777777778 | 127 |  |  | 15 | [NAME] | 131
Kamo C Maripane | ABKM964 | 0 | 6 | 8 | 9 |  | 10 | 8 | 7 | 7 | 10 | 6 | 7 | 9 | 7 | 8 | 10 |  | 6 | 8 | 6 | 9 | 8 |  | 11 | 9 | 8.047619047619047 | 8.15 | [NAME] | 6.666666666666667 | 41 |  |  | 16 | [NAME] | 129
[NAME] | ABCMA2K | Marinda du Plessis | 8 | 4 | 6 | 1 | 7 |  |  | 6 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.857142857142857 | 6.666666666666667 | [NAME] | 6.611111111111111 | 125 |  |  | 17 | Sibusiso Sibeko | 129
[NAME] | ABKM782 | [NAME] | 7 | 8 | 9 |  | 13 | 8 | 8 | 6 | 5 |  | 2 | 4 | 3 | 8 | 9 |  | 4 | 4 | 3 | 7 | 6 |  | 11 | 6 | 6.55 | 6.55 | [NAME] | 6.555555555555555 | 121 |  |  | 18 | [NAME] | 127
[NAME] | EXLN222 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 9 | 10 | 9 | 8 |  |  |  | 7.4 | 7.4 | [NAME] | 6.55 | 131 |  |  | 19 | [NAME] | 125
Lindiwe Maepa | ABFM329 | [NAME] | 9 | 4 | 7 | 2 | 2 | 4 | 7 | 5 | 5 | 2 | 3 | 2 | 2 | 1 | 2 |  | 3 | 4 | 2 | 4 | 2 |  | 6 | 4 | 3.727272727272727 | 3.9 | [NAME] | 6.5 | 134 |  |  | 20 | [NAME] | 122
[NAME] | EXGM138 | [NAME] | 8 | 8 | 7 |  |  | 10 | 8 | 7 | 5 |  |  | 3 | 4 | 4 | 3 |  | 5 | 5 | 4 | 5 | 7 |  | 8 | 8 | 6.055555555555555 | 6.055555555555555 | [NAME] | 6.473684210526316 | 129 |  |  | 21 | [NAME] | 121
Magauta Petlele | EXMP221 | 0 |  | 3 | 4 |  | 6 | 2 | 3 | 4 | 2 |  |  | 1 | 2 | 5 | 2 |  | 2 | 3 | 4 | 3 |  |  |  |  | 3.066666666666667 | 3.066666666666667 | Sibusiso Sibeko | 6.2 | 129 |  |  | 22 | Musiwalo [NAME] | 120
[NAME] | ABMH452 | Marinda du Plessis | 6 | 4 | 7 |  | 5 | 5 | 2 | 5 | 2 |  | 4 | 6 | 4 | 3 | 5 |  | 6 | 4 | 9 | 6 | 10 | 2 | 9 | 3 | 5.095238095238095 | 5.25 | [NAME] | 6.058823529411764 | 105 |  |  | 23 | [NAME] | 110
[NAME] | EXNS298 | 0 | 3 | 4 | 1 |  | 3 | 4 | 4 | 3 | 5 |  |  | 1 | 3 | 4 | 6 |  | 1 | 1 | 1 | 2 |  |  |  |  | 2.875 | 2.875 | [NAME] | 6.055555555555555 | 109 |  |  | 24 | [NAME] | 110
Michelle Damons | ABMD419 | [NAME] | 6 | 9 | 3 | 2 | 2 | 4 | 4 |  | 7 |  | 2 | 8 | 3 |  | 3 |  | 5 | 4 | 6 | 10 | 4 |  | 5 | 5 | 4.842105263157895 | 5 | Musiwalo [NAME] | 5.9 | 120 |  |  | 25 | [NAME] | 109
[NAME] | EXMM922 | [NAME] | 7 | 4 | 7 | 4 | 3 | 2 | 3 | 4 | 4 | 3 | 2 | 6 |  | 4 | 4 |  | 2 | 3 | 3 | 2 | 5 |  | 6 | 5 | 3.952380952380953 | 4 | [NAME] | 5.85 | 122 |  |  | 26 | [NAME] | 107
[NAME] | ABMMBKY | [NAME] | 10 | 8 | 9 | 4 | 7 | 11 | 1 | 7 | 7 | 2 | 6 | 6 | 3 | 5 |  |  | 2 | 8 | 3 | 9 | 9 |  | 6 | 6 | 6.142857142857143 | 6.473684210526316 | [NAME] | 5.470588235294118 | 102 |  |  | 27 | [NAME] | 106
[NAME] | ABMMBAO | [NAME] | 11 | 8 | 5 | 2 | 5 | 4 | 7 | 8 | 12 |  | 4 | 8 | 5 | 6 | 5 |  | 6 | 9 | 11 | 7 | 10 | 1 | 7 | 3 | 6.545454545454546 | 7.05 | [NAME] | 5.277777777777778 | 96 |  |  | 28 | [NAME] | 105
Musiwalo [NAME] | ABMT654 | 0 | 6 | 6 | 8 |  | 6 | 5 | 7 | 4 | 8 | 2 | 8 | 3 | 5 | 6 | 5 |  | 6 | 2 | 7 | 7 | 6 |  | 6 | 7 | 5.714285714285714 | 5.9 | [NAME] | 5.25 | 107 |  |  | 29 | [NAME] | 103
[NAME] | ABNK365 | 0 | 9 | 7 | 7 | 2 | 6 | 8 | 7 | 8 | 10 |  | 3 | 8 | 4 | 7 | 8 |  | 6 | 4 | 9 | 7 | 12 | 7 | 9 | 6 | 7 | 7.25 | [NAME] | 5.210526315789473 | 103 |  |  | 30 | [NAME] | 102
[NAME] | ABNMADZ | [NAME] | 4 | 8 | 7 |  | 3 | 3 | 4 | 4 | 6 | 3 | 2 | 4 | 7 | 5 | 3 |  | 5 | 5 | 1 | 4 | 3 |  | 4 | 7 | 4.380952380952381 | 4.45 | [NAME] | 5.2 | 110 |  |  | 31 | Phindile Ndhlovu | 100
[NAME] | EXNB189 | [NAME] | 3 | 10 | 8 |  | 10 | 5 |  |  | 10 | 2 | 2 | 6 | 8 | 5 | 8 |  | 3 | 4 | 10 | 10 | 7 | 1 | 4 | 5 | 6.05 | 6.555555555555555 | Phindile Ndhlovu | 5.166666666666667 | 100 |  |  | 32 | [NAME] | 96
[NAME] | EXNM743 | 0 | 4 | 1 | 2 |  | 1 | 4 | 2 | 3 | 5 |  |  | 1 | 2 | 3 | 3 |  | 1 | 1 | 1 | 1 |  |  |  |  | 2.1875 | 2.1875 | [NAME] | 5.1 | 110 |  |  | 33 | [NAME] | 93
[NAME] | EXNM105 | [NAME] | 9 | 9 | 8 | 3 | 7 | 7 | 8 | 7 | 9 | 3 | 3 | 1 | 2 | 6 | 1 |  | 2 | 3 | 6 | 4 | 3 |  | 4 | 5 | 5 | 5.2 | Michelle Damons | 5 | 92 |  |  | 34 | Glodean ([NAME]) Mekwa | 92
[NAME] | EXNK127 | 0 | 6 | 5 | 3 |  | 6 | 4 | 3 | 2 | 2 |  | 2 | 1 | 2 | 5 | 3 |  | 2 | 2 | 1 | 3 |  |  |  |  | 3.058823529411764 | 3.058823529411764 | [NAME] | 4.888888888888889 | 93 |  |  | 35 | Michelle Damons | 92
Nyadzawela [NAME] | ABNMAD3 | Marinda du Plessis | 9 | 7 | 5 | 3 | 5 | 8 | 11 | 8 | 10 |  | 6 | 6 | 2 | 6 | 11 | 1 |  | 6 | 15 | 8 | 11 | 2 | 8 | 7 | 7.045454545454546 | 7.842105263157895 | [NAME] | 4.85 | 106 |  |  | 36 | [NAME] | 92
Phindile Ndhlovu | ABPN476 | [NAME] | 7 | 8 | 7 | 5 | 4 | 9 | 3 | 8 | 4 | 2 | 4 | 2 | 2 | 6 | 2 |  |  |  | 5 | 2 | 6 |  | 7 | 7 | 5 | 5.166666666666667 | Hope Seemise | 4.733333333333333 | 71 |  |  | 37 | [NAME] | 86
[NAME] | ABPMA7M | [NAME] |  |  | 9 | 3 | 6 | 3 | 2 | 5 | 6 |  | 4 | 4 | 2 | 5 | 1 |  | 2 | 7 | 8 | 5 | 1 |  | 8 | 2 | 4.368421052631579 | 4.444444444444445 | [NAME] | 4.555555555555555 | 86 |  |  | 38 | [NAME] | 83
[NAME] | ABRM956 | [NAME] | 10 | 11 | 6 |  | 11 | 8 | 6 | 6 | 10 | 4 | 9 | 9 | 4 |  |  |  | 7 | 5 | 7 | 9 | 11 | 5 | 8 | 8 | 7.7 | 8.055555555555555 | Glodean ([NAME]) Mekwa | 4.5 | 92 |  |  | 39 | [NAME] | 83
Ranchia Nokayi | EXRN145 | Marinda du Plessis | 10 | 7 | 9 | 2 | 7 | 9 | 7 | 9 | 10 |  | 4 | 8 | 5 | 7 | 9 |  | 5 | 5 | 6 | 8 | 8 | 2 | 9 | 7 | 6.954545454545454 | 7.45 | [NAME] | 4.45 | 92 |  |  | 40 | Lindiwe Maepa | 82
[NAME] | EXRC130 | Marinda du Plessis | 9 | 3 | 1 |  | 6 | 7 | 4 | 4 | 5 |  | 2 |  | 3 | 4 | 5 |  | 3 |  | 2 | 1 | 7 | 4 | 13 | 3 | 4.526315789473684 | 4.555555555555555 | [NAME] | 4.444444444444445 | 83 |  |  | 41 | Hope Seemise | 71
[NAME] | EXRK111 | Marinda du Plessis | 9 | 9 | 11 | 5 | 6 | 5 | 8 | 8 | 8 | 1 | 10 | 5 | 6 | 7 |  |  | 1 | 3 | 5 | 5 | 6 |  | 7 |  | 6.25 | 6.611111111111111 | [NAME] | 4.222222222222222 | 38 |  |  | 42 | Sivuyile Ngovela | 54
[NAME] | ABRS621 | [NAME] | 6 | 7 | 7 |  | 6 | 4 | 5 | 8 | 8 | 5 | 6 | 5 | 4 | 7 | 9 |  | 4 | 4 | 6 | 3 | 7 |  | 5 | 6 | 5.809523809523809 | 5.85 | [NAME] | 4 | 83 |  |  | 43 | [NAME] | 52
[NAME] | ABSW334 | Marinda du Plessis |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  | 1 |  |  | 4 | 4 | 2.2 | 2.5 | Lindiwe Maepa | 3.9 | 82 |  |  | 44 | Magauta Petlele | 46
Sibusiso Sibeko | ABSSA3W | 0 | 6 | 6 | 9 |  | 7 | 6 | 7 | 5 | 7 | 5 | 8 | 6 | 4 | 8 | 8 |  | 5 | 3 | 6 | 5 | 7 |  | 5 | 6 | 6.142857142857143 | 6.2 | Sivuyile Ngovela | 3.375 | 54 |  |  | 45 | [NAME] | 46
Sivuyile Ngovela | EXSN321 | 0 | 3 | 2 | 2 |  | 3 | 5 | 3 | 5 | 4 |  |  | 1 | 3 | 8 | 4 |  | 2 | 1 | 6 | 2 |  |  |  |  | 3.375 | 3.375 | Magauta Petlele | 3.066666666666667 | 46 |  |  | 46 | [NAME] | 41
[NAME] | EXSK133 | [NAME] | 10 | 3 | 6 | 3 | 5 | 7 | 6 | 8 | 3 | 6 | 3 | 4 | 4 | 4 | 4 |  | 1 | 2 | 5 | 7 | 5 |  | 5 | 5 | 4.818181818181818 | 4.85 | [NAME] | 3.058823529411764 | 52 |  |  | 47 | [NAME] | 38
[NAME] | EXSF123 | [NAME] | 6 | 6 | 4 | 4 | 4 | 5 | 8 | 6 | 5 | 4 | 4 | 5 | 3 | 7 | 2 |  | 1 | 5 | 3 | 10 | 6 |  | 6 | 6 | 5 | 5.1 | [NAME] | 2.875 | 46 |  |  | 48 | [NAME] | 37
[NAME] | EXTM596 | [NAME] | 7 | 5 | 8 |  | 8 | 7 | 5 | 7 | 8 | 4 | 5 | 7 | 5 | 6 | 8 |  | 5 | 5 | 6 | 7 | 6 |  | 7 | 8 | 6.380952380952381 | 6.5 | [NAME] | 2.5 | 0 |  |  | 49 | [NAME] | 35
[NAME] | ABTR217 | [NAME] |  |  | 1 |  | 10 | 8 | 10 | 5 | 7 | 5 | 7 | 8 | 6 | 5 | 8 |  | 5 | 8 | 8 | 1 | 10 |  | 7 | 8 | 6.684210526315789 | 6.777777777777778 | Danisile [NAME] | 2.307692307692307 | 30 |  |  | 50 | [NAME] | 34
[NAME] | EXZH108 | 0 | 2 | 1 | 3 |  | 2 | 4 | 4 | 3 | 3 |  |  | 2 | 2 | 1 | 2 |  | 1 |  | 2 | 2 |  |  |  |  | 2.266666666666667 | 2.266666666666667 | [NAME] | 2.266666666666667 | 34 |  |  | 51 | Danisile [NAME] | 30
[NAME] | EXZW105 | [NAME] | 6 | 7 | 8 |  | 7 | 8 | 9 | 8 | 10 | 4 | 8 | 7 | 5 | 8 | 9 |  | 6 | 8 | 6 | 3 | 6 |  | 5 | 7 | 6.904761904761905 | 7.05 | [NAME] | 2.1875 | 35 |  |  | 52 | [NAME] | 11
Average |  |  | 6.872340425531915 | 6.229166666666667 | 6.306122448979592 | 3.052631578947369 | 5.680851063829787 | 5.958333333333333 | 5.782608695652174 | 6 | 6.625 | 3.269230769230769 | 4.714285714285714 | 5.386363636363637 | 3.977777777777778 | 5.534883720930233 | 5.422222222222222 | 1 | 3.652173913043478 | 4.659090909090909 | 5.833333333333333 | 5.92 | 6.487804878048781 | 2.833333333333333 | 6.619047619047619 | 6.26829268292683 | 5.170203946773977 | 5.6964849520532
 |  |  | 6 | 6 | 6 | 3 | 5 | 5 | 5 | 6 | 6 | 3 | 4 | 5 | 3 | 5 | 5 | 1 | 3 | 4 | 5 | 5 | 6 | 2 | 6 | 6 | 5 | 5
Ab number | Team Leader
EXSS139 | [NAME]
EXKM193 | [NAME]
ABLP420 | [NAME]
ABBT137 | [NAME]
EXMT148 | [NAME]
ABNMADZ | [NAME]
ABRS621 | [NAME]
ABDV180 | [NAME]
ABTR217 | [NAME]
EXAM322 | [NAME]
EXZW105 | [NAME]
EXNP145 | [NAME]
EXEM221 | [NAME]
EXTM596 | [NAME]
ABMMBAO | [NAME]
ABKM782 | [NAME]
EXGM103 | [NAME]
[NAME] | [NAME]
EXLL119 | [NAME]
EXMK126 | [NAME]
ABRM956 | [NAME]
EXNK128 | [NAME]
EXIL107 | [NAME]
EXDM277 | [NAME]
EXGN124 | [NAME]
EXNB189 | [NAME]
EXLN222 | [NAME]
EXSK133 | [NAME]
ABMD419 | [NAME]
ABCW433 | [NAME]
ABPN476 | [NAME]
ABFM329 | [NAME]
ABMN629 | [NAME]
EXNM105 | [NAME]
ABFH099 | [NAME]
ABMMBKY | [NAME]
EXSF123 | [NAME]
ABPMA7M | [NAME]
EXMM922 | [NAME]
EXGM138 | [NAME]
EXAT130 | Marinda du Plessis
EXNS241 | Marinda du Plessis
ABNMAD3 | Marinda du Plessis
ABCMA2K | Marinda du Plessis
ABSW334 | Marinda du Plessis
EXBR103 | Marinda du Plessis
EXRS129 | Marinda du Plessis
EXRK111 | Marinda du Plessis
ABMH452 | Marinda du Plessis
EXRN145 | Marinda du Plessis
EXGM232 | Marinda du Plessis
EXNB190 | Marinda du Plessis
EXFC119 | Marinda du Plessis
EXRC130 | Marinda du Plessis