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

 |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  |  |  |  | Ranking
Agent Name | AB Number | Team Leader | 2010-05-31 00:00:00 | 2010-05-29 00:00:00 | 2010-05-28 00:00:00 | 2010-05-27 00:00:00 | 2010-05-26 00:00:00 | 2010-05-25 00:00:00 | 2010-05-24 00:00:00 | 2010-05-22 00:00:00 | 2010-05-21 00:00:00 | 2010-05-20 00:00:00 | 2010-05-19 00:00:00 | 2010-05-18 00:00:00 | 2010-05-17 00:00:00 | 2010-05-15 00:00:00 | 2010-05-14 00:00:00 | 2010-05-13 00:00:00 | 2010-05-12 00:00:00 | 2010-05-11 00:00:00 | 2010-05-10 00:00:00 | 2010-05-08 00:00:00 | 2010-05-07 00:00:00 | 2010-05-06 00:00:00 | 2010-05-05 00:00:00 | 2010-05-04 00:00:00 | 2010-05-03 00:00:00 | Monthly Average | Monthly average (Excl Saturdays) | Consultant | Monthly Average (Excl Saturday)
[NAME] | EXAM322 | [NAME] | 11 | 5 | 12 | 14 | 15 | 13 | 6 | 1 | 4 | 10 | 9 | 10 | 6 | 4 | 7 | 7 | 7 | 8 | 6 | 5 | 4 | 3 | 9 | 7 | 5 | 7.52 | 8.238095238095237 | Bridget Mohale | 11.27777777777778
[NAME] | ABLP420 | [NAME] | 15 | 6 | 10 | 10 | 11 | 12 | 10 | 3 | 12 | 12 | 7 | 10 | 6 | 5 | 7 | 8 | 6 | 5 | 8 | 6 | 6 | 3 | 4 | 7 | 7 | 7.84 | 8.380952380952381 | [NAME] | 10.57142857142857
[NAME] | ABBT137 | [NAME] | 10 | 4 | 12 | 14 | 13 | 10 | 6 | 2 | 5 | 6 | 11 | 8 | 6 |  | 6 | 10 | 6 | 5 | 8 | 5 | 7 | 7 | 1 | 12 | 9 | 7.625 | 8.19047619047619 | Innocentia Letsoalo | 10.10526315789474
Bridget Mohale | [NAME] | [NAME] | 16 | 3 | 12 | 16 | 16 | 10 |  | 4 | 12 | 14 | 13 | 12 | 12 | 3 |  | 8 | 7 | 11 | 7 |  |  | 12 | 9 | 6 | 10 | 10.14285714285714 | 11.27777777777778 | [NAME] | 10
[NAME] | ABCW433 | [NAME] | 13 | 6 | 12 | 8 | 11 | 6 | 3 | 3 | 5 | 4 | 5 | 8 | 4 | 2 | 5 | 7 | 8 | 9 | 8 |  | 4 | 3 | 2 | 5 | 5 | 6.083333333333333 | 6.428571428571429 | [NAME] | 10
[NAME] | EXDM277 | [NAME] | 1 | 5 | 10 | 12 | 8 | 11 | 8 | 5 | 6 | 7 | 7 | 9 | 9 | 2 | 5 | 6 | 8 | 7 | 3 | 3 | 5 | 7 | 6 |  | 7 | 6.541666666666667 | 7.1 | [NAME] | 9.714285714285714
[NAME] | ABDV180 | [NAME] | 12 | 5 | 13 | 13 | 14 | 12 | 11 | 4 | 8 | 11 | 10 | 11 | 8 | 5 | 7 | 9 | 7 | 10 | 7 | 5 | 9 | 11 | 7 |  |  | 9.08695652173913 | 10 | Nyadzawela [NAME] | 8.8
[NAME] | EXNB190 | Marinda du Plessis | 10 | 5 | 6 | 5 | 8 | 9 | 6 |  | 6 | 3 | 7 | 7 | 3 | 3 | 4 | 5 |  |  | 2 |  | 3 | 3 | 7 | 4 | 5 | 5.285714285714286 | 5.421052631578948 | [NAME] | 8.777777777777779
[NAME] | EXEM221 | [NAME] | 8 | 4 | 12 | 13 | 13 | 12 | 9 | 1 | 7 | 10 | 11 | 11 | 7 | 3 | 6 | 10 | 10 | 9 | 7 | 5 | 10 | 7 | 11 | 12 | 9 | 8.68 | 9.714285714285714 | [NAME] | 8.4
[NAME] | ABFH099 | [NAME] | 9 | 5 | 11 | 3 | 11 | 11 | 9 | 1 | 5 | 7 | 7 | 4 |  | 1 | 6 | 5 | 5 | 7 | 4 |  |  |  | 4 | 6 | 4 | 5.952380952380953 | 6.555555555555555 | [NAME] | 8.380952380952381
Glodean ([NAME]) Mekwa | EXGM103 | [NAME] | 7 |  | 12 | 11 | 8 | 9 | 8 | 1 |  | 11 | 8 | 7 | 6 | 3 | 3 | 9 | 7 | 10 | 6 |  | 8 | 6 | 1 | 6 | 8 | 7.045454545454546 | 7.55 | Michelle Damons | 8.25
[NAME] | EXGM232 | Marinda du Plessis | 11 | 2 | 5 | 5 | 5 | 13 | 7 | 1 | 7 | 5 | 6 | 8 | 3 | 2 | 5 | 8 | 5 | 3 | 5 |  | 3 | 4 | 6 | 3 | 7 | 5.375 | 5.904761904761905 | [NAME] | 8.238095238095237
Innocentia Letsoalo | EXIL107 | [NAME] | 13 |  | 14 | 14 | 11 | 13 | 11 |  |  | 8 | 9 |  | 11 | 4 | 7 | 10 | 12 | 10 | 8 | 3 | 7 | 8 | 9 | 9 | 8 | 9.476190476190476 | 10.10526315789474 | [NAME] | 8.19047619047619
[NAME] | ABJO114 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 2 |  |  |  |  |  |  | 4 | 4 | [NAME] | 8.047619047619047
Kamo C Maripane | EXKM193 | [NAME] |  |  |  |  | 13 | 7 | 6 | 1 | 5 |  |  |  |  |  |  |  |  |  |  |  | 10 | 6 | 3 | 9 | 8 | 6.8 | 7.444444444444445 | [NAME] | 7.857142857142857
[NAME] | ABKM782 | [NAME] | 9 |  | 12 | 9 | 10 | 10 | 7 | 1 | 8 | 9 |  |  | 8 | 4 | 4 | 7 | 8 | 9 | 7 | 2 | 2 | 9 | 6 | 6 | 6 | 6.954545454545454 | 7.684210526315789 | Ranchia Nokayi | 7.809523809523809
[NAME] | EXLN222 | [NAME] | 6 |  | 12 | 10 | 1 | 6 | 4 | 2 | 5 | 7 |  | 9 | 8 | 4 | 3 | 6 | 5 | 8 | 3 | 5 | 7 | 5 | 6 | 7 | 4 | 5.782608695652174 | 6.1 | [NAME] | 7.684210526315789
Lindiwe Maepa | ABFM329 | [NAME] | 11 | 5 | 13 | 12 | 9 |  | 2 | 1 | 5 | 4 | 7 | 8 | 3 | 1 | 7 | 5 | 7 | 5 | 2 |  |  | 1 | 2 | 5 | 7 | 5.545454545454546 | 6.052631578947368 | Glodean ([NAME]) Mekwa | 7.55
[NAME] | EXGM138 | [NAME] | 13 | 4 | 10 | 10 | 11 | 7 | 6 | 4 | 4 | 8 | 7 | 6 | 7 | 2 | 5 | 7 | 5 | 6 | 6 |  | 5 | 4 | 4 | 7 | 7 | 6.458333333333333 | 6.904761904761905 | Kamo C Maripane | 7.444444444444445
[NAME] | ABMH452 | Marinda du Plessis | 7 |  | 5 | 6 | 11 | 12 | 11 | 1 | 4 | 2 | 7 | 5 | 4 |  |  |  |  |  |  |  |  | 3 | 8 | 5 | 4 | 5.9375 | 6.266666666666667 | [NAME] | 7.368421052631579
Michelle Damons | ABMD419 | [NAME] | 10 | 5 | 5 | 12 | 13 | 7 | 11 | 1 | 6 | 10 | 8 | 8 | 7 | 4 | 12 | 8 | 8 | 9 | 8 |  |  | 8 | 3 | 8 | 4 | 7.608695652173913 | 8.25 | Phindile Ndhlovu | 7.25
[NAME] | EXMM922 | [NAME] | 10 |  |  | 11 | 7 | 7 | 6 | 3 | 2 | 6 |  | 9 | 7 | 1 | 3 | 5 | 5 | 6 | 4 |  | 3 | 8 | 8 | 6 |  | 5.85 | 6.277777777777778 | Sibusiso Sibeko | 7.222222222222222
[NAME] | ABMMBAO | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 7 | 5 | 7 |  |  |  |  |  | 6 | 6.2 | 6.2 | [NAME] | 7.2
Musiwalo [NAME] | EXMT148 | [NAME] |  |  |  |  |  |  | 4 |  | 5 |  |  |  |  |  |  |  |  |  | 4 |  | 7 | 9 | 5 | 9 | 8 | 6.375 | 6.375 | [NAME] | 7.15
[NAME] | EXNK128 | [NAME] | 11 |  |  |  |  |  |  | 5 | 10 | 1 |  |  |  |  |  |  |  |  |  |  | 7 | 3 |  | 9 | 6 | 6.5 | 6.714285714285714 | [NAME] | 7.1
[NAME] | ABNMADZ | [NAME] | 8 | 2 | 9 | 9 | 11 | 10 | 7 | 2 | 8 | 11 | 7 | 8 | 5 | 3 | 4 | 7 | 7 |  |  | 2 | 3 | 7 | 3 | 9 | 7 | 6.478260869565218 | 7.368421052631579 | [NAME] | 6.904761904761905
[NAME] | EXNB189 | [NAME] | 7 |  | 13 | 3 | 6 | 13 | 8 | 2 | 5 | 10 | 7 | 12 | 7 | 2 | 4 |  |  | 4 | 5 | 4 | 3 | 8 | 5 | 5 | 6 | 6.318181818181818 | 6.894736842105263 | [NAME] | 6.894736842105263
[NAME] | EXNM105 | [NAME] | 13 | 5 |  |  | 9 | 14 | 7 | 2 |  |  |  |  |  | 2 | 11 | 7 | 7 |  |  |  |  |  | 3 | 8 |  | 7.333333333333333 | 8.777777777777779 | [NAME] | 6.714285714285714
Nyadzawela [NAME] | ABNMAD3 | Marinda du Plessis | 12 | 6 | 12 | 12 | 13 | 14 | 14 |  |  | 8 | 6 | 8 | 4 | 4 | 8 | 8 | 8 | 7 | 7 | 3 | 8 | 4 | 8 | 6 | 9 | 8.217391304347826 | 8.8 | [NAME] | 6.555555555555555
Phindile Ndhlovu | ABPN476 | [NAME] | 13 | 4 | 11 | 10 | 10 | 10 | 8 | 3 | 6 | 7 | 5 | 10 | 5 | 3 | 6 | 7 | 9 | 7 |  |  | 6 | 4 | 1 | 6 | 4 | 6.739130434782608 | 7.25 | [NAME] | 6.5
[NAME] | ABPMA7M | [NAME] | 13 | 5 | 13 | 16 | 18 | 8 |  | 1 | 4 | 10 | 12 | 8 | 7 |  |  |  |  |  |  |  |  | 4 | 7 |  |  | 9 | 10 | [NAME] | 6.428571428571429
[NAME] | ABRM956 | [NAME] | 14 |  | 13 | 14 | 13 | 14 | 9 | 6 | 8 | 15 | 13 | 12 | 13 | 3 | 9 | 9 | 9 | 6 | 9 | 5 | 7 | 9 | 5 | 11 | 10 | 9.833333333333334 | 10.57142857142857 | Musiwalo [NAME] | 6.375
Ranchia Nokayi | EXRN145 | Marinda du Plessis | 9 | 5 | 14 | 7 | 9 | 11 | 6 |  | 5 | 7 | 9 | 13 | 6 | 6 | 4 | 9 | 9 | 6 | 8 |  | 7 | 8 | 6 | 4 | 7 | 7.608695652173913 | 7.809523809523809 | [NAME] | 6.277777777777778
[NAME] | EXRC130 | Marinda du Plessis | 12 | 5 | 8 | 7 | 11 | 11 | 5 | 3 | 1 | 4 | 9 | 10 | 6 | 5 | 2 | 10 | 8 | 7 | 7 |  | 6 | 5 | 8 |  | 6 | 6.782608695652174 | 7.15 | [NAME] | 6.266666666666667
[NAME] | EXRK111 | Marinda du Plessis | 7 |  |  | 7 | 7 | 10 | 10 | 4 | 5 | 7 | 9 | 7 | 2 | 4 | 2 | 7 | 6 | 4 | 5 |  | 9 | 5 | 2 | 7 | 6 | 6 | 6.2 | [NAME] | 6.2
[NAME] | ABRS621 | [NAME] | 13 | 3 | 12 | 11 | 12 | 12 | 12 | 3 | 9 | 11 | 7 | 7 | 3 | 5 | 6 | 7 | 5 | 8 | 3 | 3 | 7 | 4 | 3 | 5 | 8 | 7.16 | 7.857142857142857 | [NAME] | 6.2
[NAME] | ABSW334 | Marinda du Plessis |  |  | 1 | 6 | 3 |  | 3 | 5 | 2 |  | 5 | 5 | 6 |  | 1 | 5 | 4 | 3 | 4 |  |  |  |  |  |  | 3.785714285714286 | 3.692307692307693 | [NAME] | 6.1
Sibusiso Sibeko | EXSS139 | [NAME] |  |  |  |  |  | 10 | 9 | 2 | 6 |  |  |  |  |  |  |  |  |  | 6 | 4 | 5 | 9 | 5 | 8 | 7 | 6.454545454545454 | 7.222222222222222 | Lindiwe Maepa | 6.052631578947368
[NAME] | EXSK133 | [NAME] | 8 | 5 | 10 | 1 | 7 | 9 | 4 | 2 | 8 | 6 | 10 | 9 | 6 | 2 | 5 | 7 | 3 | 6 | 4 |  | 4 | 3 | 4 | 5 |  | 5.565217391304348 | 5.95 | [NAME] | 5.95
[NAME] | EXSF123 | [NAME] | 10 | 4 | 8 | 10 | 10 | 8 | 4 | 3 | 3 | 5 | 5 | 7 | 6 |  | 3 | 6 | 7 | 7 | 10 |  |  | 6 | 3 | 9 | 3 | 6.227272727272728 | 6.5 | [NAME] | 5.904761904761905
[NAME] | EXTM596 | [NAME] | 8 | 4 | 10 | 10 | 9 | 10 | 6 | 4 | 4 | 5 | 8 | 6 | 9 | 4 | 6 | 8 | 10 | 9 | 6 | 4 | 6 | 2 | 6 |  | 6 | 6.666666666666667 | 7.2 | [NAME] | 5.421052631578948
[NAME] | ABTR217 | [NAME] | 11 | 6 | 14 | 13 | 11 | 12 | 9 | 4 | 8 | 8 | 8 | 10 | 6 | 2 | 5 | 9 | 7 | 5 | 6 | 5 | 5 | 1 | 6 | 8 | 7 | 7.44 | 8.047619047619047 | [NAME] | 4
[NAME] | EXZW105 | [NAME] | 8 | 3 | 10 | 15 | 14 | 11 | 7 | 3 | 5 | 10 | 7 | 9 | 8 | 4 | 5 | 10 | 5 | 14 | 7 | 5 | 6 | 6 |  | 4 | 7 | 7.625 | 8.4 | [NAME] | 3.692307692307693
Average |  |  | 10.24324324324324 | 4.481481481481482 | 10.47058823529412 | 9.972222222222221 | 10.31578947368421 | 10.37837837837838 | 7.342105263157895 | 2.611111111111111 | 5.891891891891892 | 7.75 | 8.06060606060606 | 8.558823529411764 | 6.4 | 3.1875 | 5.382352941176471 | 7.485714285714286 | 6.970588235294118 | 7.088235294117647 | 5.805555555555555 | 4.111111111111111 | 5.90625 | 5.657894736842105 | 5.157894736842105 | 6.942857142857143 | 6.583333333333333 | 6.91022113053305 | 7.54115831236298
 |  |  | 10 | 4 | 10 | 9 | 10 | 10 | 7 | 2 | 5 | 7 | 8 | 8 | 6 | 3 | 5 | 7 | 6 | 7 | 5 | 4 | 5 | 5 | 5 | 6 | 6
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