Spreadsheet: 137889d1327422503-data-validation-gone-wrong-kol-wb-distributor-billing-frequency-aso11
Sheet: Total

 |  |  |  |  |  |  |  |  | KOL
 |  | No of Orders | No of Distributors - Aug'11 | No of Distributors - Sep'11 | No of Distributors - Oct'11 | Cumm %of Distributors - Aug'11 | Cumm %of Distributors - Sep'11 | Cumm %of Distributors - Oct'11 | WB | Circle : WB
 | KOL | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | KOL | 1 | 0 | 0 | 5 | 0 | 0 | 0.09803921568627451 |  | No of Orders | No of Distributors - Aug'11 | No of Distributors - Sep'11 | No of Distributors - Oct'11 | Cumm %of Distributors - Aug'11 | Cumm %of Distributors - Sep'11 | Cumm %of Distributors - Oct'11
 | KOL | 2 | 0 | 0 | 0 | 0 | 0 | 0.09803921568627451 |  | 0 | 31 | 32 | 28 | 0.1036789297658863 | 0.1056105610561056 | 0.0979020979020979
 | KOL | 3 | 1 | 0 | 3 | 0.02173913043478261 | 0 | 0.1568627450980392 |  | 1 | 26 | 24 | 35 | 0.1906354515050167 | 0.1848184818481848 | 0.2202797202797203
 | KOL | 4 | 4 | 0 | 1 | 0.108695652173913 | 0 | 0.1764705882352941 |  | 2 | 34 | 32 | 37 | 0.3043478260869565 | 0.2904290429042904 | 0.3496503496503497
 | KOL | 5 | 6 | 0 | 3 | 0.2391304347826087 | 0 | 0.2352941176470588 |  | 3 | 39 | 28 | 47 | 0.4347826086956521 | 0.3828382838283829 | 0.513986013986014
 | KOL | 6 | 10 | 2 | 7 | 0.4565217391304348 | 0.04347826086956522 | 0.3725490196078431 |  | 4 | 37 | 29 | 37 | 0.5585284280936454 | 0.4785478547854786 | 0.6433566433566433
 | KOL | 7 | 5 | 5 | 7 | 0.5652173913043479 | 0.1521739130434783 | 0.5098039215686274 |  | 5 | 36 | 27 | 34 | 0.6789297658862876 | 0.5676567656765676 | 0.7622377622377622
 | KOL | 8 | 4 | 7 | 12 | 0.6521739130434783 | 0.3043478260869565 | 0.7450980392156863 |  | 6 | 29 | 26 | 18 | 0.7759197324414716 | 0.6534653465346535 | 0.8251748251748251
 | KOL | 9 | 11 | 15 | 4 | 0.8913043478260869 | 0.6304347826086957 | 0.8235294117647058 |  | 7 | 17 | 24 | 21 | 0.8327759197324415 | 0.7326732673267327 | 0.8986013986013985
 | KOL | 10 | 3 | 11 | 7 | 0.9565217391304347 | 0.8695652173913044 | 0.9607843137254901 |  | 8 | 13 | 25 | 13 | 0.8762541806020067 | 0.8151815181518152 | 0.944055944055944
 | KOL | >10 | 2 | 6 | 2 | 0.9999999999999999 | 1 | 1 |  | 9 | 18 | 24 | 7 | 0.9364548494983277 | 0.8943894389438943 | 0.9685314685314684
 | KOL | Total | 46 | 46 | 51 |  |  |  |  | 10 | 11 | 10 | 7 | 0.9732441471571905 | 0.9273927392739273 | 0.9930069930069929
 | WB | 0 | 31 | 32 | 28 | 0.1036789297658863 | 0.1056105610561056 | 0.0979020979020979 |  | >10 | 8 | 22 | 2 | 0.9999999999999999 | 1 | 1
 | WB | 1 | 26 | 24 | 35 | 0.1906354515050167 | 0.1848184818481848 | 0.2202797202797203 |  | Total | 299 | 303 | 286
 | WB | 2 | 34 | 32 | 37 | 0.3043478260869565 | 0.2904290429042904 | 0.3496503496503497
 | WB | 3 | 39 | 28 | 47 | 0.4347826086956521 | 0.3828382838283829 | 0.513986013986014
 | WB | 4 | 37 | 29 | 37 | 0.5585284280936454 | 0.4785478547854786 | 0.6433566433566433
 | WB | 5 | 36 | 27 | 34 | 0.6789297658862876 | 0.5676567656765676 | 0.7622377622377622
 | WB | 6 | 29 | 26 | 18 | 0.7759197324414716 | 0.6534653465346535 | 0.8251748251748251
 | WB | 7 | 17 | 24 | 21 | 0.8327759197324415 | 0.7326732673267327 | 0.8986013986013985
 | WB | 8 | 13 | 25 | 13 | 0.8762541806020067 | 0.8151815181518152 | 0.944055944055944
 | WB | 9 | 18 | 24 | 7 | 0.9364548494983277 | 0.8943894389438943 | 0.9685314685314684
 | WB | 10 | 11 | 10 | 7 | 0.9732441471571905 | 0.9273927392739273 | 0.9930069930069929
 | WB | >10 | 8 | 22 | 2 | 0.9999999999999999 | 1 | 1
 | WB | Total | 299 | 303 | 286