Spreadsheet: 157423d1337720531-automatically-sort-the-data-and-ranking-based-on-the-sorted-data-schedule-calculator
Sheet: Monthly Average Adherence

 | 2012-03-01 00:00:00
 | Employee ID | Name | 2012-03-01 00:00:00 | 2012-03-02 00:00:00 | 2012-03-05 00:00:00 | 2012-03-06 00:00:00 | 2012-03-07 00:00:00 | 2012-03-08 00:00:00 | 2012-03-09 00:00:00 | 2012-03-12 00:00:00 | 2012-03-13 00:00:00 | 2012-03-14 00:00:00 | 2012-03-15 00:00:00 | 2012-03-16 00:00:00 | 2012-03-19 00:00:00 | 2012-03-20 00:00:00 | 2012-03-21 00:00:00 | 2012-03-22 00:00:00 | 2012-03-23 00:00:00 | 2012-03-26 00:00:00 | 2012-03-27 00:00:00 | 2012-03-28 00:00:00 | 2012-03-29 00:00:00 | 2012-03-30 00:00:00 | Monthly Average
 | A2733 | [NAME] | 0.9866666666666668 | 0.9948366013071891 | 0.9997385620915029 | 0.9962745098039214 | 0.9876470588235293 | 0.9938562091503274 | 1 | 0.9978758169934643 | 0.9993790849673205 | 0.9992156862745103 | 0.9989542483660128 | 0.9939542483660133 | 0.9997058823529411 | 0.9983333333333334 | 0.9982026143790851 | 0.9855882352941179 | 0.9973202614379085 | 0.9997385620915038 | 0.9997058823529414 | 0.9943790849673197 | 0.9950326797385621 | 0.9999019607843137
 | A978 | Nasrin Warsi | 0.9999019607843137 | 0.9998039215686277 | 0.99983660130719 | 0.9997712418300657 | 0.9960130718954248 | 0.9999673202614375 | 1 | 0.9999999999999997 | 0.99983660130719 | 0.9998692810457523 | 0.9997712418300657 | 0.999901960784314 | 0.9999346405228762 | 0.997549019607844 | 0.9998039215686276 | 0.998006535947713 | 0.9935620915032679 | 0.990490196078431 | 0.9999346405228763 | 0.9940849673202614 | 0.9998039215686277 | 0.9998039215686284
 | A1128 | Rajeev [NAME] | 0.9803267973856212 | 0.9985620915032677 | 0.988627450980392 | 0.999967320261438 | 0.9948692810457516 | 0.9998692810457515 | 1 | 0.9963071895424833 | 0.9984313725490194 | 0.9648692810457519 | 0.9999999999999997 | 0.9996732026143789 | 0.9980718954248362 | 0.9999999999999997 | 0.9999999999999997 | 0.9997712418300648 | 0.9999999999999997 | 0.9999999999999997 | 0.9409477124183003 | 0.9983986928104573 | 0.9957843137254898 | 0.9999999999999997
 | A942 | [NAME] | 0.9844771241830067 | 0.9998039215686281 | 0.9928431372549015 | 0.9982352941176471 | 0.9986601307189542 | 0.9954901960784316 | 1 | 0.99640522875817 | 0.99937908496732 | 0.9901960784313719 | 0.9966993464052291 | 1 |  | 0.9978104575163402 | 1 | 1 | 0.9884967320261433 | 0.9901960784313719 | 0.9999673202614383 | 0.9999673202614383 | 0.9998692810457515 | 1
 | A2559 | Sandeep Jain D | 0.9952941176470586 | 0.9468627450980395 |  |  |  |  | 1 |  | 1 | 0.9999346405228763 | 0.9994444444444442 | 0.9996078431372551 | 0.999967320261438 | 0.999901960784314 | 0.9999673202614383 | 0.9998692810457517 | 0.995555555555555 | 0.9999019607843137 | 0.9918954248366012 | 1 | 0.9999673202614383 | 1
 | A378 | [NAME] | 0.9677777777777773 | 0.9735294117647055 | 0.9858823529411761 | 0.9666993464052288 | 0.972254901960785 | 0.9758823529411768 | 1 | 0.9877450980392156 | 0.9695424836601315 | 0.9750326797385631 | 0.9395098039215686 |  |  | 0.9117647058823526 | 0.98235294117647 | 0.9549019607843132 | 0.9826797385620918 | 0.9900653594771237 | 0.9821241830065358 | 0.9928431372549018 | 0.986797385620916 | 0.9873856209150331
 | A3784 | [NAME] | 0.9986601307189549 | 0.9983660130718957 | 0.9990196078431369 | 0.9975816993464054 | 0.9962745098039213 | 0.9997712418300657 | 1 |  | 0.9962091503267976 | 0.9970915032679739 | 0.9970915032679739 | 0.9967973856209149 | 0.9997712418300656 | 0.9999346405228757 | 0.999901960784314 |  |  | 0.9997712418300652 | 0.999967320261438 | 0.9960784313725494 | 0.999901960784314 | 0.9975816993464057
 | 2012-02-01 00:00:00
 | Employee ID | Name | 2012-02-01 00:00:00 | 2012-02-02 00:00:00 | 2012-02-03 00:00:00 | 2012-02-06 00:00:00 | 2012-02-07 00:00:00 | 2012-02-08 00:00:00 | 2012-02-09 00:00:00 | 2012-02-10 00:00:00 | 2012-02-13 00:00:00 | 2012-02-14 00:00:00 | 2012-02-15 00:00:00 | 2012-02-16 00:00:00 | 2012-02-17 00:00:00 | 2012-02-20 00:00:00 | 2012-02-21 00:00:00 | 2012-02-22 00:00:00 | 2012-02-23 00:00:00 | 2012-02-24 00:00:00 | 2012-02-27 00:00:00 | 2012-02-28 00:00:00 | 2012-02-29 00:00:00 | Monthly Average
 | A2733 | [NAME] | 0.9856209150326798 | 0.9976470588235293 | 0.9983006535947716 | 0.9943137254901968 | 0.9890522875817 | 0.9932026143790847 | 0.9985294117647053 | 0.9957189542483659 | 0.9925816993464049 | 0.9965686274509802 | 0.9987908496732029 | 0.9906209150326795 | 0.9990522875816991 | 0.9988888888888885 | 0.9968300653594767 | 0.9787254901960782 | 1 | 0.9940849673202622 |  |  | 0.9887908496732025
 | A978 | Nasrin Warsi | 0.9937908496732025 | 0.9999346405228757 | 0.9998366013071898 | 0.9995751633986931 | 0.9956862745098042 | 0.999705882352941 | 0.9993464052287586 |  | 0.9998366013071898 |  |  | 0.9998366013071894 | 0.9987908496732024 | 0.9992810457516338 | 0.9992810457516338 | 0.9982026143790851 | 1 | 0.9966013071895422 | 0.9998366013071898 | 0.9966993464052287 | 0.9998692810457517
 | A1128 | Rajeev [NAME] | 0.9881045751633986 | 0.9994771241830064 | 0.9999019607843137 | 0.9989542483660131 | 0.9998692810457517 | 1 | 1 | 0.9994444444444442 | 0.999967320261438 | 0.9901960784313726 | 0.9903267973856211 | 0.9971895424836602 | 0.9996078431372555 | 0.9974183006535948 | 0.9878431372549024 | 0.9890849673202615 | 1 | 0.9807843137254904 | 0.9975816993464052 | 0.9919281045751634 | 0.9986928104575166
 | A942 | [NAME] | 0.9998039215686277 | 0.9998366013071898 | 0.9993790849673205 | 0.9934967320261441 | 0.9998039215686274 | 0.9959477124183005 | 0.9962745098039216 | 0.9952614379084973 | 0.99983660130719 | 0.9998039215686281 | 0.9989869281045755 | 0.9962418300653596 | 0.9997058823529411 | 0.9995424836601314 | 0.9981372549019615 | 0.9981372549019615 | 1 | 0.9981372549019615 | 0.999738562091504 | 0.99983660130719
 | A2559 | Sandeep Jain D | 0.9993464052287575 | 0.9951633986928106 | 0.9982352941176464 | 0.9951307189542483 | 0.9996732026143796 | 0.9975816993464055 | 0.9999999999999999 | 0.9948366013071892 | 0.9914379084967321 | 0.9999673202614375 | 0.9893137254901961 | 0.9932352941176474 | 0.9979084967320261 | 0.9983660130718952 | 0.9996405228758167 | 0.9981045751633988 | 1 | 0.9962091503267971 | 0.9975816993464052 | 0.997450980392156 | 0.9925163398692809
 | A378 | [NAME] | 0.9563071895424836 |  |  | 0.9718300653594778 | 0.9774183006535945 | 0.9960130718954244 | 0.9772875816993459 | 0.9785947712418299 | 0.9792810457516343 |  |  |  |  | 0.9845751633986927 | 0.9916339869281052 | 0.9410784313725489 | 1 | 0.9438235294117637 | 0.9764052287581703 | 0.984477124183007 | 0.9437254901960784
 | A3784 | [NAME] | 0.9989869281045755 | 0.9986274509803917 | 0.999901960784314 | 0.998823529411765 | 0.9974836601307192 | 0.9997712418300648 | 0.9986928104575162 | 0.9997712418300652 | 0.9988235294117646 | 0.9985620915032677 | 0.9901960784313723 | 0.9999346405228755 | 0.9998692810457517 | 0.9989215686274506 | 0.9930065359477123 | 0.9999999999999997 | 1 | 0.9999346405228757 | 0.9925816993464055 | 0.9981699346405236 | 0.9985620915032687
 | 2012-01-01 00:00:00
 | Employee ID | Name | 2012-01-03 00:00:00 |  |  |  | 2012-01-09 00:00:00 |  |  |  |  | 2012-01-17 00:00:00 |  |  |  | 2012-01-23 00:00:00 |  |  |  |  | 2012-01-30 00:00:00 |  | Montly Average
 | A2733 | [NAME] | 0.9868954248366016 | 0.9902614379084971 | 0.9865359477124181 | 0.9994444444444454 | 0.998692810457517 | 0.9896078431372554 | 0.99983660130719 | 0.9988888888888888 | 0.9998039215686271 | 0.9865686274509805 | 0.9801307189542486 | 0.9935620915032678 | 0.9929084967320264 | 0.9997058823529418 | 0.9953267973856206 | 0.9947712418300653 | 0.99967320261438 | 0.9948692810457519 | 0.9992156862745105 | 0.9997058823529416
 | A978 | Nasrin Warsi | 0.9930065359477127 | 0.9999019607843134 | 0.9998039215686274 | 0.9997712418300656 | 0.9958496732026142 | 0.9995098039215687 | 0.9853594771241826 | 0.9998039215686277 | 0.9997058823529413 | 0.9900653594771243 | 0.9998039215686277 | 0.9997712418300662 | 0.9900000000000003 | 0.9997385620915035 | 0.9999019607843134 | 0.9998692810457517 | 0.9704575163398692 | 0.9998039215686274 | 0.9991176470588234 | 0.9998039215686277
 | A1128 | Rajeev [NAME] | 1 | 0.9998692810457515 | 0.9999019607843134 |  |  |  |  |  |  |  |  |  | 0.9882026143790851 | 0.9992810457516346 | 0.9968627450980391 | 0.9951960784313725 | 0.9960784313725484 | 0.9935294117647058 | 0.9999346405228757 | 0.9964705882352942
 | A942 | [NAME] | 0.9895098039215685 | 0.9835294117647061 | 0.9999346405228757 | 0.999869281045752 | 0.9992483660130717 | 0.9970915032679732 | 0.9909803921568632 | 0.999869281045752 | 0.9984967320261433 | 0.9979738562091502 | 0.9998039215686277 | 0.9989542483660131 | 0.9995751633986926 | 0.9820261437908495 | 0.9899346405228757 | 0.9997058823529408 | 0.9978104575163399 | 0.9939215686274503 | 0.9988562091503268 | 0.9982679738562094
 | A2559 | Sandeep Jain D | 0.9985294117647061 | 0.9999999999999999 | 0.9999673202614379 | 0.998692810457517 | 0.9910457516339873 | 0.9991830065359475 | 0.9993137254901958 | 0.9964052287581701 | 0.9933333333333327 | 0.9999346405228761 | 0.9896405228758169 | 0.9951633986928095 | 0.9998039215686271 | 0.9803594771241828 |  |  |  |  |  | 0.9935294117647058
 | A378 | [NAME] | 0.991601307189543 | 0.9919934640522868 | 0.9826143790849668 | 0.9799673202614377 | 0.9949019607843139 | 0.9916339869281047 | 0.9742483660130715 | 0.9795751633986919 | 0.9843137254901958 | 0.9716666666666672 | 0.9840849673202615 | 0.9840849673202615 | 0.9273529411764705 | 0.9847385620915027 | 0.9887908496732022 | 0.9944444444444441 | 0.9672549019607846 | 0.9463398692810449 | 0.980098039215686 | 0.9840849673202613
 | A3784 | [NAME] | 0.9885947712418296 | 0.9954575163398693 | 0.9983006535947716 | 0.9991503267973854 | 0.9926143790849669 | 0.9918954248366012 | 0.9999019607843134 | 0.9981045751633985 |  | 0.9986601307189538 | 0.9885947712418298 | 0.9943464052287582 | 0.9997712418300652 |  |  |  |  |  | 0.993921568627451 | 0.9971568627450982