Spreadsheet: 71929d1272609171-matching-names-between-different-sheets-and-getting-averages-agent-average-2010
Sheet: March

 |  |  |  |  |  | Saturday |  |  |  |  | Saturday |  |  |  |  |  | Saturday |  |  |  |  |  | Saturday
Agent Name | AB Number | Team Leader | 2010-03-31 00:00:00 | 2010-03-30 00:00:00 | 2010-03-29 00:00:00 | 2010-03-27 00:00:00 | 2010-03-26 00:00:00 | 2010-03-25 00:00:00 | 2010-03-24 00:00:00 | 2010-03-23 00:00:00 | 2010-03-20 00:00:00 | 2010-03-19 00:00:00 | 2010-03-18 00:00:00 | 2010-03-17 00:00:00 | 2010-03-16 00:00:00 | 2010-03-15 00:00:00 | 2010-03-13 00:00:00 | 2010-03-12 00:00:00 | 2010-03-11 00:00:00 | 2010-03-10 00:00:00 | 2010-03-09 00:00:00 | 2010-03-08 00:00:00 | 2010-03-06 00:00:00 | 2010-03-05 00:00:00 | 2010-03-04 00:00:00 | 2010-03-03 00:00:00 | 2010-03-02 00:00:00 | 2010-03-01 00:00:00 | Monthly Average | Monthly average (Excl Saturdays) | Consultant | Monthly Average (Excl Saturday)
[NAME] | EXAM322 | [NAME] | 5 | 9 | 9 | 5 | 3 | 4 | 7 | 2 |  | 6 | 8 | 10 | 11 | 11 | 4 | 8 | 10 | 6 | 3 | 2 |  | 4 | 4 | 4 | 3 | 1 | 5.791666666666667 | 5.909090909090909 | Kamo C Maripane | 7.428571428571429
[NAME] | EXAT130 | Marinda du Plessis |  |  |  |  |  |  |  | 1 | 4 | 5 | 3 | 6 | 9 | 2 |  | 5 | 2 | 1 |  | 1 |  | 1 | 1 |  | 1 | 3 | 3 | 2.928571428571428 | [NAME] | 7.363636363636363
[NAME] | ABLP420 | [NAME] | 2 | 4 | 4 | 2 | 5 | 5 | 10 | 4 | 5 | 11 | 7 | 10 | 10 | 8 | 5 | 7 | 4 | 7 |  | 1 |  | 1 | 2 | 2 | 3 | 2 | 5.041666666666667 | 5.190476190476191 | [NAME] | 6.8125
[NAME] | ABBT137 | [NAME] | 7 | 7 | 5 | 3 | 5 | 5 | 5 | 9 | 2 | 7 | 6 | 10 | 9 | 7 | 4 | 8 | 8 | 6 | 1 | 2 |  |  | 2 | 2 | 2 | 2 | 5.166666666666667 | 5.476190476190476 | [NAME] | 6.8
Bridget Mohale | [NAME] | [NAME] | 9 | 10 | 9 | 5 | 7 | 10 | 7 | 7 |  | 11 | 4 | 1 | 1 | 6 | 4 | 7 | 5 | 2 | 4 |  |  |  |  |  | 3 |  | 5.894736842105263 | 6.058823529411764 | Ranchia Nokayi | 6.714285714285714
[NAME] | ABCW433 | [NAME] | 9 | 7 | 3 | 5 | 7 | 7 | 7 | 8 | 4 | 11 | 9 | 8 | 7 | 5 | 4 | 8 | 4 | 5 | 3 | 2 |  | 1 | 3 | 1 | 1 |  | 5.375 | 5.523809523809524 | [NAME] | 6.523809523809524
[NAME] | EXDM277 | [NAME] | 4 | 2 | 2 | 3 | 6 | 5 | 6 | 7 |  | 8 | 6 | 10 | 6 | 2 | 1 | 2 |  | 5 | 1 |  |  | 1 | 2 | 2 | 4 | 3 | 4 | 4.2 | [NAME] | 6.380952380952381
[NAME] | ABDV180 | [NAME] | 11 | 10 | 9 | 3 | 9 | 6 | 7 | 8 |  | 3 | 8 | 12 | 13 | 12 | 4 | 9 | 10 | 8 | 5 | 2 |  | 3 | 5 | 3 | 6 | 3 | 7.041666666666667 | 7.363636363636363 | [NAME] | 6.352941176470588
[NAME] | EXNB190 | Marinda du Plessis | 3 | 1 | 3 |  | 5 | 5 | 4 | 5 | 5 | 6 | 8 | 5 | 9 | 6 | 4 | 4 | 2 | 1 | 2 | 1 |  |  | 3 | 1 | 1 |  | 3.818181818181818 | 3.75 | Musiwalo [NAME] | 6.272727272727272
[NAME] | EXEM221 | [NAME] | 4 | 10 | 6 | 4 | 9 | 3 | 13 | 11 | 3 | 6 | 5 | 10 | 10 | 12 | 4 | 7 | 9 | 7 | 3 | 3 |  | 2 |  | 4 | 2 |  | 6.391304347826087 | 6.8 | [NAME] | 6.190476190476191
[NAME] | ABFH099 | [NAME] | 8 | 4 | 4 | 1 | 6 | 9 | 6 | 7 | 2 | 6 | 10 | 8 | 10 | 9 | 3 | 8 | 2 | 7 |  |  |  |  | 1 | 3 |  |  | 5.7 | 6.352941176470588 | Nyadzawela [NAME] | 6.181818181818182
[NAME] | EXFC119 | Marinda du Plessis |  |  |  |  | 1 |  | 5 |  |  |  |  |  | 5 | 3 |  |  | 1 |  |  |  |  |  | 1 |  | 3 |  | 2.714285714285714 | 2.714285714285714 | [NAME] | 6.157894736842105
Glodean ([NAME]) Mekwa | EXGM103 | [NAME] | 6 | 3 | 4 | 1 | 3 | 3 | 4 | 5 |  | 10 | 13 | 8 | 6 | 3 | 1 | 5 | 4 | 5 |  | 1 |  |  | 1 |  | 1 | 3 | 4.285714285714286 | 4.631578947368421 | Innocentia Letsoalo | 6.136363636363637
[NAME] | EXGN124 | [NAME] |  | 8 | 6 |  | 4 | 6 | 4 |  |  | 12 | 10 | 10 | 8 | 6 | 4 | 8 | 5 | 4 | 2 |  |  | 2 |  | 2 | 3 |  | 5.777777777777778 | 5.882352941176471 | Michelle Damons | 6.111111111111111
[NAME] | EXGM232 | Marinda du Plessis | 3 | 3 | 6 |  | 3 | 6 | 6 | 5 | 6 | 6 | 7 | 7 | 7 | 4 | 4 | 4 | 4 | 3 | 4 | 1 | 1 | 1 | 4 | 1 | 1 |  | 4.041666666666667 | 4.095238095238095 | [NAME] | 6.1
Innocentia Letsoalo | EXIL107 | [NAME] | 2 | 5 | 9 | 2 | 9 | 4 | 10 | 2 |  | 6 | 10 | 11 | 10 | 12 | 4 | 10 | 9 | 6 | 2 | 4 |  | 2 | 2 | 2 | 4 | 4 | 5.875 | 6.136363636363637 | [NAME] | 6.090909090909091
[NAME] | ABJO114 | 0 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | Bridget Mohale | 6.058823529411764
Kamo C Maripane | EXKM193 | [NAME] | 7 | 9 | 8 |  |  | 7 | 8 | 11 |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.428571428571429 | 7.428571428571429 | [NAME] | 5.95
[NAME] | ABCMA2K | Marinda du Plessis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 5 | 4 | 3 | 2 | 3.166666666666667 | 3.4 | Phindile Ndhlovu | 5.947368421052632
[NAME] | ABKM782 | [NAME] | 5 | 5 | 4 | 2 | 5 | 5 | 1 | 6 |  | 5 | 10 | 6 | 6 | 5 |  | 3 | 7 | 2 | 2 | 3 |  |  | 3 | 2 | 1 |  | 4.190476190476191 | 4.3 | [NAME] | 5.909090909090909
[NAME] | EXLL119 | [NAME] | 3 | 5 | 6 | 3 | 4 | 6 | 8 | 14 |  | 5 | 9 | 10 | 11 | 12 | 5 | 7 | 11 |  | 2 | 2 |  | 3 | 5 | 3 | 3 | 1 | 6 | 6.190476190476191 | Sibusiso Sibeko | 5.904761904761905
[NAME] | EXLN222 | [NAME] |  | 1 | 4 | 1 |  |  |  | 6 |  | 10 | 8 | 7 | 2 | 5 | 5 | 3 | 7 | 3 | 2 | 3 |  | 1 | 1 | 3 |  |  | 4 | 4.125 | [NAME] | 5.882352941176471
Lindiwe Maepa | ABFM329 | [NAME] | 5 | 5 | 6 | 1 | 4 | 6 | 4 | 4 | 3 | 8 | 10 | 8 | 10 | 7 | 3 |  |  |  |  |  |  | 1 | 1 | 3 | 3 |  | 4.842105263157895 | 5.3125 | [NAME] | 5.714285714285714
[NAME] | EXGM138 | [NAME] | 4 | 6 | 5 | 2 | 3 | 9 | 7 | 6 | 2 | 10 | 11 | 11 | 6 | 7 | 4 | 7 | 6 | 5 | 4 | 1 | 1 |  | 1 | 1 | 1 |  | 5 | 5.55 | [NAME] | 5.55
[NAME] | ABMH452 | Marinda du Plessis | 7 | 7 | 4 |  | 3 | 3 | 5 | 9 | 3 | 6 | 3 | 5 | 5 | 5 | 3 | 4 | 5 | 3 |  | 3 |  |  | 1 | 5 |  |  | 4.45 | 4.611111111111111 | [NAME] | 5.523809523809524
Matshidiso Kganyago | EXMK126 | [NAME] | 1 | 2 | 1 | 2 | 3 | 2 | 7 | 3 |  | 8 | 7 | 6 | 6 | 2 | 1 | 2 | 4 | 1 |  |  |  |  |  | 1 | 1 |  | 3.157894736842105 | 3.352941176470588 | [NAME] | 5.476190476190476
Michelle Damons | ABMD419 | [NAME] | 7 | 8 | 8 | 2 | 12 | 9 | 7 | 2 | 4 | 12 | 7 |  | 4 | 10 | 5 |  | 4 | 5 | 4 | 2 | 4 |  | 2 | 5 | 2 |  | 5.681818181818182 | 6.111111111111111 | [NAME] | 5.368421052631579
[NAME] | EXMM922 | [NAME] | 3 | 1 | 4 | 3 | 3 | 6 | 2 | 5 | 3 | 11 | 7 | 10 | 4 | 6 | 5 | 1 | 2 | 5 | 1 | 1 | 2 |  | 2 | 2 | 2 |  | 3.791666666666667 | 3.9 | Lindiwe Maepa | 5.3125
Monchu Ntswane | ABMN629 | [NAME] | 4 | 1 | 3 | 4 | 2 | 3 | 3 | 5 | 3 |  | 5 | 7 | 6 | 4 | 4 |  |  | 3 | 1 | 2 |  |  | 1 |  | 3 | 3 | 3.35 | 3.294117647058823 | [NAME] | 5.190476190476191
[NAME] | ABMMBAO | [NAME] | 8 | 5 | 6 |  |  |  | 7 | 5 |  | 9 | 10 | 9 | 8 | 5 | 4 | 7 | 5 | 4 | 4 | 3 |  | 1 | 3 | 1 | 2 |  | 5.3 | 5.368421052631579 | [NAME] | 5.190476190476191
Musiwalo [NAME] | EXMT148 | [NAME] | 8 | 8 | 5 | 4 | 9 | 6 | 5 | 6 |  | 10 | 5 | 12 | 10 | 9 | 5 | 8 | 9 | 10 | 4 | 2 |  | 2 | 1 | 5 | 2 | 2 | 6.125 | 6.272727272727272 | [NAME] | 5.125
[NAME] | EXNK128 | [NAME] | 3 |  |  |  |  | 8 | 8 | 10 |  | 8 | 13 | 10 | 10 | 9 | 5 | 8 | 9 | 4 | 2 |  |  |  |  | 1 | 4 | 2 | 6.705882352941177 | 6.8125 | [NAME] | 5.090909090909091
[NAME] | ABNMADZ | [NAME] | 8 | 6 | 4 | 3 | 6 | 7 | 5 | 1 |  | 4 | 7 | 13 | 7 | 7 | 6 | 5 | 7 | 5 | 5 | 2 |  | 2 | 4 | 4 | 1 | 2 | 5.041666666666667 | 5.090909090909091 | [NAME] | 4.846153846153846
[NAME] | EXNS241 | Marinda du Plessis | 8 | 5 | 5 |  | 1 | 5 | 7 | 1 | 3 | 7 | 4 | 5 | 5 | 4 |  |  |  | 2 | 1 | 2 |  | 2 | 3 | 2 | 1 | 6 | 3.761904761904762 | 3.8 | [NAME] | 4.647058823529412
[NAME] | EXNB189 | [NAME] | 3 | 3 | 4 | 4 | 6 | 7 | 7 | 5 |  | 7 | 8 | 7 | 4 | 5 | 5 | 4 | 3 | 3 |  | 1 |  | 2 | 2 | 2 | 3 |  | 4.318181818181818 | 4.3 | Glodean ([NAME]) Mekwa | 4.631578947368421
[NAME] | EXNM105 | [NAME] | 7 | 3 | 5 | 1 | 8 | 8 | 6 |  | 3 | 4 | 14 | 10 | 10 | 10 | 5 | 8 | 5 | 4 | 1 |  | 2 |  | 3 | 5 | 3 | 3 | 5.565217391304348 | 6.157894736842105 | [NAME] | 4.611111111111111
Nyadzawela [NAME] | ABNMAD3 | Marinda du Plessis | 9 | 6 | 8 |  | 5 | 7 | 8 | 7 | 4 | 7 | 7 | 9 | 8 | 9 | 3 | 7 | 6 | 7 | 3 | 2 | 1 | 2 | 7 | 3 | 4 | 5 | 5.76 | 6.181818181818182 | [NAME] | 4.578947368421052
Phindile Ndhlovu | ABPN476 | [NAME] | 6 | 7 | 3 | 4 | 6 | 11 | 5 | 6 | 3 | 6 | 13 | 10 | 9 | 8 | 5 | 8 | 5 | 5 | 1 | 2 |  | 1 | 1 |  |  |  | 5.681818181818182 | 5.947368421052632 | [NAME] | 4.3
[NAME] | ABPMA7M | [NAME] | 3 |  | 3 | 2 | 5 | 14 | 7 | 6 | 2 | 4 | 12 | 14 | 14 | 13 |  | 8 | 5 | 3 |  | 2 |  | 2 | 1 | 2 | 2 | 2 | 5.727272727272728 | 6.1 | [NAME] | 4.3
[NAME] | ABRM956 | [NAME] |  | 5 | 7 | 3 | 8 | 8 | 10 | 12 | 3 | 5 | 11 | 10 | 9 | 12 | 5 | 8 | 9 | 7 | 1 | 2 |  | 1 | 4 | 4 | 2 | 2 | 6.166666666666667 | 6.523809523809524 | [NAME] | 4.2
Ranchia Nokayi | EXRN145 | Marinda du Plessis | 4 | 8 | 8 |  | 4 | 3 | 7 | 2 |  | 5 | 11 | 11 | 11 | 12 | 4 | 8 | 10 | 6 |  | 3 | 2 | 5 | 4 | 5 | 7 | 7 | 6.391304347826087 | 6.714285714285714 | [NAME] | 4.125
[NAME] | EXRC130 | Marinda du Plessis | 4 | 4 | 6 |  | 3 |  |  |  | 5 | 8 | 6 | 5 | 4 | 7 | 2 | 5 | 5 | 3 |  | 3 |  |  |  |  |  |  | 4.666666666666667 | 4.846153846153846 | [NAME] | 4.095238095238095
[NAME] | EXRK111 | Marinda du Plessis | 11 | 9 | 8 |  |  | 7 | 5 |  |  |  |  |  |  | 1 | 4 | 8 | 5 |  |  |  |  |  |  | 2 | 6 | 5 | 5.916666666666667 | 6.090909090909091 | [NAME] | 3.9
[NAME] | ABRS621 | [NAME] | 8 | 6 | 8 | 1 | 2 | 6 | 8 | 6 |  | 6 | 8 | 11 | 12 | 12 | 2 | 7 | 7 | 9 | 2 | 4 |  | 3 | 2 | 5 |  | 2 | 5.956521739130435 | 6.380952380952381 | [NAME] | 3.8
[NAME] | ABSW334 | Marinda du Plessis | 2 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 2.333333333333333 | 1.5 | [NAME] | 3.75
Sibusiso Sibeko | EXSS139 | [NAME] | 6 | 7 | 2 | 4 | 6 | 3 | 8 | 7 |  | 5 | 9 | 14 | 9 | 11 | 4 | 6 | 8 | 5 | 2 | 5 |  | 2 |  | 3 | 4 | 2 | 5.739130434782608 | 5.904761904761905 | [NAME] | 3.4
[NAME] | EXSK133 | [NAME] | 8 | 4 | 8 | 3 | 3 | 7 | 5 | 6 | 1 | 6 | 11 | 8 | 8 | 10 | 4 | 6 | 1 | 7 | 1 | 2 |  | 1 | 1 | 3 | 3 |  | 4.875 | 5.190476190476191 | Matshidiso Kganyago | 3.352941176470588
[NAME] | EXSF123 | [NAME] | 3 | 3 | 4 | 1 | 7 | 5 | 5 | 4 | 1 | 10 | 8 | 5 | 7 | 6 | 2 | 2 | 3 | 4 |  |  |  |  | 1 |  |  | 2 | 4.15 | 4.647058823529412 | Monchu Ntswane | 3.294117647058823
[NAME] | EXTM596 | [NAME] | 3 | 5 | 5 | 2 | 5 | 2 | 6 | 4 | 2 | 2 | 4 | 11 | 10 | 9 | 5 | 5 | 6 | 3 |  | 2 |  |  | 2 | 2 |  | 1 | 4.363636363636363 | 4.578947368421052 | [NAME] | 2.928571428571428
[NAME] | ABTR217 | [NAME] | 8 | 8 | 6 | 3 | 8 |  | 7 | 8 |  | 4 | 10 | 12 | 11 | 9 | 5 | 6 | 6 | 5 | 3 |  |  | 2 | 2 | 1 | 2 | 1 | 5.772727272727272 | 5.95 | [NAME] | 2.714285714285714
[NAME] | EXBR103 | Marinda du Plessis |  |  |  |  |  |  |  |  |  |  | 6 | 7 | 5 | 5 | 3 | 8 | 3 | 3 | 4 |  |  |  |  |  |  |  | 4.888888888888889 | 5.125 | [NAME] | 1.5
[NAME] | EXZW105 | [NAME] | 5 | 5 | 8 | 4 | 7 | 7 | 9 | 5 | 3 | 7 | 5 | 9 | 8 | 5 | 3 | 7 | 7 | 4 | 9 | 6 |  | 1 | 1 | 3 | 2 |  | 5.416666666666667 | 5.714285714285714 | [NAME] | 1
Average |  |  | 5.444444444444445 | 5.355555555555555 | 5.444444444444445 | 2.735294117647059 | 5.238095238095238 | 6.071428571428571 | 6.4 | 5.883720930232558 | 3.16 | 7.113636363636363 | 7.978723404255319 | 8.844444444444445 | 7.872340425531915 | 7.270833333333333 | 3.863636363636364 | 6.186046511627907 | 5.659090909090909 | 4.613636363636363 | 2.696969696969697 | 2.285714285714286 | 1.875 | 1.896551724137931 | 2.375 | 2.725 | 2.625 | 2.730769230769231 | 4.782514475331997 | 5.123247539879478
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