Spreadsheet: 732564d1621014949-rank-formula-error-misses-duplicate-values-rank
Sheet: Sheet1

% | [NAME] | Expected Rank
2.047619047619047 |  | 1
1.807377049180328 |  | 2
1.335585585585585 |  | 3
1.310344827586207 |  | 4
1.240963855421687 |  | 5
1.211538461538461 |  | 6
1.108860759493671 |  | 7
1.0625 |  | 8
0.9780564263322883 |  | 9
0.9381443298969072 |  | 10
0.9330922242314645 |  | 11
0.904761904761905 |  | 12
0.8987854251012146 |  | 13
0.8724966622162884 |  | 14
0.8552631578947372 |  | 15
0.8296296296296297 |  | 16
0.7968749999999998 |  | 17
0.7879746835443038 |  | 18
0.7676767676767675 |  | 19
0.7642857142857146 |  | 20
0.7505330490405118 |  | 21
0.7503607503607506 |  | 22
0.7352185089974292 |  | 23
0.718676122931442 |  | 24
0.6462765957446811 |  | 25
0.6428571428571427 |  | 26
0.6376811594202898 |  | 27
0.6228571428571428 |  | 28
0.5959241040056219 |  | 29
0.5818181818181817 |  | 30
0.5734265734265735 |  | 31
0.5701617110067814 |  | 32
0.5693923480870219 |  | 33
0.5594639865996651 |  | 34
0.543265306122449 |  | 35
0.503731343283582 |  | 36
0.4924812030075188 |  | 37
0.4896373056994819 |  | 38
0.479539641943734 |  | 39
0.4784172661870506 |  | 40
0.4775086505190309 |  | 41
0.4611727416798734 |  | 42
0.4505300353356891 |  | 43
0.4487734487734487 |  | 44
0.4340344168260039 |  | 45
0.4321266968325792 |  | 46
0.4302600472813237 |  | 47
0.42603550295858 |  | 48
0.416445623342175 |  | 49
0.4160958904109588 |  | 50
0.3965217391304346 |  | 51
0.3940443213296398 |  | 52
0.3884026258205688 |  | 53
0.3845193508114856 |  | 54
0.377962085308057 |  | 55
0.3773584905660378 |  | 56
0.3760162601626015 |  | 57
0.3660377358490565 |  | 58
0.3593495934959348 |  | 59
0.3529411764705882 |  | 60
0.3511659807956103 |  | 61
0.3484162895927602 |  | 62
0.3425336164189666 |  | 63
0.3423423423423422 |  | 64
0.3324175824175823 |  | 65
0.3293413173652696 |  | 66
0.3266666666666667 |  | 67
0.3236842105263159 |  | 68
0.3175718849840256 |  | 69
0.3164556962025316 |  | 70
0.3117647058823529 |  | 71
0.3104477611940297 |  | 72
0.3034979423868312 |  | 73
0.3009950248756221 |  | 74
0.2955854126679462 |  | 75
0.2863070539419087 |  | 76
0.2777777777777779 |  | 77
0.2723735408560312 |  | 78
0.2660550458715596 |  | 79
0.2628661916072841 |  | 80
0.2582781456953642 |  | 81
0.2568627450980394 |  | 82
0.2478386167146974 |  | 83
0.2409523809523809 |  | 84
0.2384428223844282 |  | 85
0.2319929297392841 |  | 86
0.2238805970149252 |  | 87
0.213903743315508 |  | 88
0.20625375826819 |  | 89
0.2028608582574772 |  | 90
0.1984 |  | 91
0.1934106162294081 |  | 92
0.192655667908462 |  | 93
0.1922773837667456 |  | 94
0.1901998710509349 |  | 95
0.1897983392645314 |  | 96
0.1873661670235546 |  | 97
0.1798365122615804 |  | 98
0.1759172154280338 |  | 99
0.1688311688311688 |  | 100
0.1667872648335745 |  | 101
0.1660710212151168 |  | 102
0.1591343093570974 |  | 103
0.156108597285068 |  | 104
0.1540130151843818 |  | 105
0.1476510067114094 |  | 106
0.1449948400412798 |  | 107
0.143843498273878 |  | 108
0.1423550087873461 |  | 109
0.1393534002229654 |  | 110
0.1345565749235474 |  | 111
0.1277013752455796 |  | 112
0.1265934065934065 |  | 113
0.1257545271629779 |  | 114
0.1245033112582782 |  | 115
0.1176470588235294 |  | 116
0.1153846153846155 |  | 117
0.112994350282486 |  | 118
0.1126262626262626 |  | 119
0.1119090365050866 |  | 120
0.1101694915254238 |  | 121
0.1101694915254237 |  | 122
0.1061538461538462 |  | 123
0.1026666666666666 |  | 124
0.1001739130434782 |  | 125
0.09985422740524776 |  | 126
0.09626955475330913 |  | 127
0.09076175040518647 |  | 128
0.08686730506155961 |  | 129
0.0848748639825899 |  | 130
0.08425275827482445 |  | 131
0.07718120805369127 |  | 132
0.05905963302752279 |  | 133
0.05537459283387634 |  | 134
0.04359673024523165 |  | 135
0.03685897435897443 |  | 136
0.00290979631425794 |  | 137
-0.004014598540145965 |  | 138
-0.004389173372348244 |  | 139
-0.004926108374384306 |  | 140
-0.007923930269413602 |  | 141
-0.009300595238095238 |  | 142
-0.01953488372093031 |  | 143
-0.0278035217794253 |  | 144
-0.03015075376884425 |  | 145
-0.04021739130434775 |  | 146
-0.04661016949152538 |  | 147
-0.06338652482269502 |  | 148
-0.08411214953271015 |  | 149
-0.1323218066337332 |  | 150
-0.1466395112016294 |  | 151
-0.2756119673617407 |  | 152