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

 |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday
Agent Name | AB Number | Team Leader | 2010-02-27 00:00:00 | 2010-02-26 00:00:00 | 2010-02-25 00:00:00 | 2010-02-24 00:00:00 | 2010-02-23 00:00:00 | 2010-02-22 00:00:00 | 2010-02-20 00:00:00 | 2010-02-19 00:00:00 | 2010-02-18 00:00:00 | 2010-02-17 00:00:00 | 2010-02-16 00:00:00 | 2010-02-15 00:00:00 | 2010-02-13 00:00:00 | 2010-02-12 00:00:00 | 2010-02-11 00:00:00 | 2010-02-10 00:00:00 | 2010-02-09 00:00:00 | 2010-02-08 00:00:00 | 2010-02-06 00:00:00 | 2010-02-05 00:00:00 | 2010-02-04 00:00:00 | 2010-02-03 00:00:00 | 2010-02-02 00:00:00 | 2010-02-01 00:00:00 | Monthly Average | Monthly average (Excl Saturdays) | Consultant | Monthly Average (Excl Saturday)
[NAME] | EXAM322 | [NAME] |  | 2 | 5 | 5 | 5 | 10 |  | 3 | 5 | 7 | 5 | 6 | 8 | 9 | 10 | 8 | 8 | 9 |  | 5 | 8 | 8 | 7 | 7 | 6.666666666666667 | 6.6 | [NAME] | 10
[NAME] | EXAT130 | Marinda du Plessis |  |  | 5 | 3 |  | 3 |  | 4 | 4 | 6 | 6 | 3 | 2 | 6 | 4 |  |  |  |  | 3 | 6 | 8 | 7 | 7 | 4.8125 | 5 | [NAME] | 8.263157894736842
[NAME] | ABLP420 | [NAME] |  | 4 | 6 | 5 | 3 | 2 |  | 4 | 6 | 3 | 3 | 4 | 4 | 6 | 7 | 8 | 6 | 6 |  | 1 | 8 | 6 | 8 | 6 | 5.047619047619047 | 5.1 | [NAME] | 8.052631578947368
[NAME] | ABBT137 | [NAME] |  | 1 | 4 | 7 | 3 | 2 |  | 4 | 4 | 6 | 3 | 5 | 5 | 9 | 6 | 4 | 4 | 7 |  | 6 | 6 | 8 | 4 | 7 | 5 | 5 | [NAME] | 8
Bridget Mohale | [NAME] | [NAME] | 1 |  | 3 | 3 | 2 |  |  |  | 8 | 14 | 9 | 5 |  | 2 | 2 | 5 | 7 | 8 |  |  |  |  | 3 |  | 5.142857142857143 | 5.461538461538462 | Innocentia Letsoalo | 7.7
[NAME] | ABCW433 | [NAME] |  |  | 4 | 6 | 6 | 3 | 4 |  | 6 | 7 | 9 | 11 |  | 8 | 5 |  |  | 5 |  | 4 | 6 | 6 | 8 | 9 | 6.294117647058823 | 6.4375 | Musiwalo [NAME] | 7.7
[NAME] | EXDM277 | [NAME] | 3 | 5 | 6 | 8 | 3 | 7 |  | 5 |  | 2 | 4 | 3 |  | 6 | 7 | 7 | 6 | 3 |  | 3 | 1 | 6 | 5 | 2 | 4.6 | 4.684210526315789 | Monchu Ntswane | 7.55
[NAME] | ABDV180 | [NAME] |  | 3 | 6 |  | 8 | 7 |  | 4 | 9 | 8 | 8 | 6 | 5 | 11 | 13 | 13 | 8 | 8 |  | 8 | 8 | 9 | 9 | 11 | 8.1 | 8.263157894736842 | Michelle Damons | 7.352941176470588
[NAME] | EXNB190 | Marinda du Plessis | 3 | 1 | 2 | 3 |  |  |  |  |  | 6 | 2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | 2.857142857142857 | 2.833333333333333 | Nyadzawela [NAME] | 7.055555555555555
[NAME] | EXEM221 | [NAME] |  | 3 | 2 | 9 | 5 | 7 |  | 2 | 5 | 6 | 5 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 4.6 | 4.6 | Ranchia Nokayi | 6.75
[NAME] | ABFH099 | [NAME] |  | 2 | 7 | 4 | 5 | 3 | 2 | 6 | 8 | 7 | 6 | 8 |  | 6 | 7 | 12 | 9 | 7 |  | 8 |  | 4 | 10 | 5 | 6.3 | 6.526315789473684 | Sibusiso Sibeko | 6.65
[NAME] | EXFC119 | Marinda du Plessis |  |  | 3 | 7 | 3 | 5 |  | 3 | 3 | 5 | 2 | 4 |  |  |  |  |  |  |  |  |  |  |  |  | 3.888888888888889 | 3.888888888888889 | [NAME] | 6.6
Glodean ([NAME]) Mekwa | EXGM103 | [NAME] | 2 | 2 | 4 | 5 | 3 | 3 |  | 4 | 3 | 7 | 3 | 3 |  | 3 | 5 | 6 | 5 | 4 |  | 3 | 4 | 1 | 4 |  | 3.7 | 3.789473684210526 | [NAME] | 6.526315789473684
[NAME] | EXGN124 | [NAME] |  | 2 | 4 | 3 | 4 | 2 |  |  |  |  |  |  |  |  | 5 | 6 | 4 | 7 |  | 3 | 4 | 3 | 8 | 1 | 4 | 4 | [NAME] | 6.4375
[NAME] | EXGM232 | Marinda du Plessis | 2 | 2 | 3 | 7 | 4 | 5 |  | 2 | 4 | 6 | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4.2 | Phindile Ndhlovu | 6.263157894736842
Innocentia Letsoalo | EXIL107 | [NAME] |  | 2 | 8 | 12 | 5 | 7 |  | 4 | 8 | 11 | 10 | 3 |  | 7 | 10 | 9 | 12 | 11 |  | 7 | 7 | 5 | 8 | 8 | 7.7 | 7.7 | [NAME] | 6.222222222222222
[NAME] | ABCMA2K | Marinda du Plessis | 2 | 1 | 5 | 9 | 4 | 2 |  | 1 | 6 | 8 | 6 | 8 |  | 10 |  | 8 | 7 | 4 |  | 3 | 6 | 4 | 5 | 6 | 5.25 | 5.421052631578948 | [NAME] | 6.1
[NAME] | ABKM782 | [NAME] | 2 | 4 | 6 | 6 | 4 | 2 |  |  | 6 | 7 | 3 | 3 |  | 2 | 6 | 6 | 7 | 7 |  | 6 | 8 | 6 | 7 | 9 | 5.35 | 5.526315789473684 | [NAME] | 6.058823529411764
[NAME] | EXLL119 | [NAME] |  | 2 | 3 | 5 | 6 | 2 |  | 5 | 4 | 10 | 9 | 5 |  |  |  | 8 | 6 | 5 |  | 5 | 8 |  |  | 7 | 5.625 | 5.625 | [NAME] | 5.842105263157895
[NAME] | EXLN222 | [NAME] | 1 | 2 | 4 | 5 | 3 | 4 |  | 3 | 3 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.1 | 3.333333333333333 | [NAME] | 5.647058823529412
Lindiwe Maepa | ABFM329 | [NAME] |  | 1 | 7 | 3 | 4 | 3 | 2 | 4 | 4 | 6 | 7 | 8 |  | 6 | 8 | 9 | 5 | 7 |  | 2 |  |  |  | 5 | 5.055555555555555 | 5.235294117647059 | [NAME] | 5.625
[NAME] | EXGM138 | [NAME] |  |  | 5 | 3 | 4 | 6 | 2 | 3 | 4 | 4 | 2 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 3.9 | 4.111111111111111 | [NAME] | 5.526315789473684
[NAME] | ABMH452 | Marinda du Plessis |  | 1 | 3 |  |  | 3 | 1 | 2 | 4 | 2 | 3 | 4 |  | 4 | 3 | 1 | 2 | 2 | 1 | 2 | 5 | 5 | 3 | 8 | 2.95 | 3.166666666666667 | Bridget Mohale | 5.461538461538462
Matshidiso Kganyago | EXMK126 | [NAME] | 1 | 3 | 4 | 2 | 2 | 3 |  | 4 | 3 | 4 | 3 | 2 |  | 2 | 5 | 1 | 4 | 3 |  | 3 | 1 |  |  |  | 2.777777777777778 | 2.882352941176471 | [NAME] | 5.42
Michelle Damons | ABMD419 | [NAME] | 2 | 3 | 2 | 4 | 9 | 3 | 3 | 8 | 5 |  | 8 | 14 |  | 10 | 7 | 8 | 10 |  |  |  | 9 | 9 | 10 | 6 | 6.842105263157895 | 7.352941176470588 | Lindiwe Maepa | 5.235294117647059
[NAME] | EXMM922 | [NAME] |  |  | 4 | 4 | 4 | 3 | 4 | 1 | 4 | 6 | 6 | 5 |  |  |  |  |  |  |  |  |  |  |  |  | 4.1 | 4.111111111111111 | [NAME] | 5.157894736842105
Monchu Ntswane | ABMN629 | [NAME] | 1 | 6 | 6 | 4 | 4 | 7 |  | 4 | 6 | 8 | 6 | 12 |  | 11 | 9 | 8 | 10 | 8 |  | 6 | 9 | 9 | 9 | 9 | 7.238095238095238 | 7.55 | [NAME] | 5.1
[NAME] | ABMMBAO | [NAME] | 1 | 3 | 2 | 4 | 7 | 4 |  | 4 | 5 | 9 | 4 | 4 |  | 5 | 5 | 5 | 6 | 7 |  | 2 | 6 | 6 | 7 | 6 | 4.857142857142857 | 5.05 | [NAME] | 5.05
Musiwalo [NAME] | EXMT148 | [NAME] |  | 5 | 4 | 9 | 5 | 3 |  | 5 | 8 | 8 | 6 | 6 | 4 | 12 | 9 | 10 | 12 | 11 |  | 4 | 10 | 11 | 7 | 9 | 7.523809523809524 | 7.7 | [NAME] | 5
[NAME] | EXNK128 | [NAME] |  | 5 | 10 | 10 | 13 | 8 |  | 10 | 9 | 12 | 7 | 3 |  | 8 | 14 | 10 | 15 | 10 |  | 10 | 11 | 10 | 13 | 12 | 10 | 10 | [NAME] | 5
[NAME] | ABNMADZ | [NAME] |  |  |  | 1 | 1 |  |  | 2 | 2 | 6 | 4 | 6 | 5 | 8 | 9 | 9 | 10 | 8 |  | 5 | 9 | 7 | 4 | 5 | 5.611111111111111 | 5.647058823529412 | [NAME] | 4.9
[NAME] | EXNS241 | Marinda du Plessis |  | 1 | 4 | 4 | 5 | 3 |  | 4 | 5 | 10 | 6 | 1 |  | 7 | 2 | 6 | 5 | 4 | 2 |  |  | 8 | 5 | 7 | 4.684210526315789 | 4.833333333333333 | [NAME] | 4.833333333333333
[NAME] | EXNB189 | [NAME] |  | 3 | 6 | 5 | 8 | 7 |  | 2 | 8 | 3 | 5 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 4.9 | 4.9 | [NAME] | 4.684210526315789
[NAME] | EXNM105 | [NAME] |  | 1 | 2 | 5 | 3 | 5 | 3 | 8 | 5 | 6 | 10 |  |  | 7 | 10 | 9 | 5 | 6 |  | 6 | 9 | 6 |  |  | 5.888888888888889 | 6.058823529411764 | [NAME] | 4.6
Nyadzawela [NAME] | ABNMAD3 | Marinda du Plessis | 2 |  | 5 | 8 | 4 | 5 |  | 7 | 7 | 10 | 8 | 10 |  | 9 | 5 | 5 | 10 | 7 | 4 | 5 | 8 | 10 | 4 |  | 6.65 | 7.055555555555555 | [NAME] | 4.2
Phindile Ndhlovu | ABPN476 | [NAME] |  | 1 | 6 | 5 | 2 | 3 | 3 | 5 | 7 | 6 | 9 | 12 | 3 | 7 | 8 | 8 | 9 | 5 |  |  | 7 | 6 | 10 | 3 | 5.952380952380953 | 6.263157894736842 | [NAME] | 4.111111111111111
[NAME] | ABPMA7M | [NAME] | 1 | 1 | 5 | 4 | 1 | 4 |  | 9 | 2 | 5 | 8 | 8 | 5 | 10 | 4 | 9 | 5 | 7 |  |  | 6 | 7 | 7 | 9 | 5.571428571428571 | 5.842105263157895 | [NAME] | 4.111111111111111
[NAME] | ABRM956 | [NAME] | 2 | 2 | 5 | 10 | 11 | 6 |  |  | 10 | 9 | 7 | 3 |  | 4 | 9 | 9 | 8 | 11 |  | 11 | 9 | 9 | 12 | 8 | 7.75 | 8.052631578947368 | [NAME] | 4.105263157894737
Ranchia Nokayi | EXRN145 | Marinda du Plessis |  | 1 | 5 | 8 | 5 | 7 |  | 3 | 5 | 8 | 12 | 7 |  | 9 | 7 | 9 | 12 | 5 | 2 | 4 | 7 | 7 | 4 | 10 | 6.523809523809524 | 6.75 | [NAME] | 4
[NAME] | EXRC130 | Marinda du Plessis |  | 2 | 5 | 4 | 5 | 2 |  | 1 | 2 | 6 | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | [NAME] | 3.888888888888889
[NAME] | EXRK111 | Marinda du Plessis |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 7 | 8 | 10 | 8 | 3 | 5 | 9 | 10 | 7 | 8 | 7.545454545454546 | 8 | [NAME] | 3.842105263157895
[NAME] | ABRS621 | [NAME] |  | 1 | 6 | 7 | 4 | 4 |  | 6 | 9 | 6 | 8 | 6 | 4 |  |  | 8 | 5 | 8 |  | 4 | 9 | 9 | 6 | 6 | 6.105263157894737 | 6.222222222222222 | Glodean ([NAME]) Mekwa | 3.789473684210526
Sibusiso Sibeko | EXSS139 | [NAME] |  | 3 | 5 | 7 | 4 | 6 |  | 6 | 9 | 6 | 8 | 1 | 4 | 10 | 6 | 7 | 10 | 7 |  | 5 | 8 | 9 | 9 | 7 | 6.523809523809524 | 6.65 | [NAME] | 3.333333333333333
[NAME] | EXSK133 | [NAME] |  | 3 | 2 | 6 | 3 | 2 | 4 | 4 | 7 | 5 | 7 | 12 |  | 6 | 9 | 7 | 6 | 8 |  | 5 | 8 | 6 | 8 | 8 | 6 | 6.1 | [NAME] | 3.2
[NAME] | EXSF123 | [NAME] |  |  | 1 | 2 | 2 | 3 | 2 | 6 | 2 | 3 | 5 | 6 |  | 9 | 6 | 6 | 7 | 3 |  | 2 | 3 | 3 | 2 | 2 | 3.75 | 3.842105263157895 | [NAME] | 3.166666666666667
[NAME] | EXTM596 | [NAME] |  | 3 | 3 | 5 | 3 | 2 |  | 4 | 4 | 4 | 1 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 3.1 | 3.1 | [NAME] | 3.1
[NAME] | ABTR217 | [NAME] |  | 2 | 3 | 1 | 2 | 1 |  | 3 | 1 | 1 |  | 6 | 4 | 8 | 8 | 5 | 10 | 5 |  | 6 | 9 | 9 | 10 | 8 | 5.1 | 5.157894736842105 | [NAME] | 3
[NAME] | EXBR103 | Marinda du Plessis |  | 1 | 1 | 7 | 3 | 6 |  | 2 | 2 | 6 | 5 | 1 |  |  | 5 | 4 | 6 | 4 | 4 | 2 | 4 | 5 | 7 | 7 | 4.1 | 4.105263157894737 | Matshidiso Kganyago | 2.882352941176471
[NAME] | EXZW105 | [NAME] |  | 2 | 5 | 5 | 5 | 1 |  | 2 | 2 | 4 | 4 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 3.2 | 3.2 | [NAME] | 2.833333333333333
Average |  |  | 1.733333333333333 | 2.358974358974359 | 4.382978723404255 | 5.413043478260869 | 4.422222222222222 | 4.133333333333334 | 2.727272727272727 | 4.119047619047619 | 5.177777777777778 | 6.369565217391305 | 5.652173913043478 | 5.266666666666667 | 4.416666666666667 | 7.205882352941177 | 6.914285714285715 | 7.25 | 7.527777777777778 | 6.527777777777778 | 2.666666666666667 | 4.666666666666667 | 6.941176470588236 | 6.911764705882353 | 6.970588235294118 | 6.909090909090909 | 5.277697221431916 | 5.75603969602133
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