Removing not outs all together isn't hard, however this removes the innings as well. To do it the other way you'd need to export it.
Gayle and Attapatu are suprisingly high for mine too.
The Don should actually drop a spot on this list, as for some reason he's being credited with only 28 centuries instead of the 29 he actually scored. So he'd fall behind Sehwag.
Player Innings Not Out Runs Average Average Innings
DG Bradman (Aus) 29 6 5393 234.47 185.9655172
Zaheer Abbas (Pak) 12 2 2158 215.8 179.8333333
V Sehwag (India) 22 1 3879 184.71 176.3181818
SP Fleming (NZ) 9 2 1585 226.42 176.1111111
BC Lara (WI) 34 2 5889 184.03 173.2058824
SM Nurse (WI) 6 0 1037 172.83 172.8333333
DL Amiss (Eng) 11 3 1879 234.87 170.8181818
FMM Worrell (WI) 9 3 1530 255 170
ST Jayasuriya (SL) 14 0 2356 168.28 168.2857143
SJ McCabe (Aus) 6 2 1006 251.5 167.6666667
WR Hammond (Eng) 22 7 3685 245.66 167.5
CH Gayle (WI) 13 1 2168 180.66 166.7692308
KC Sangakkara (SL) 30 8 4963 225.59 165.4333333
RB Simpson (Aus) 10 0 1646 164.6 164.6
IJL Trott (Eng) 7 2 1147 229.4 163.8571429
RG Pollock (SA) 7 0 1147 163.85 163.8571429
MS Atapattu (SL) 16 4 2584 215.33 161.5
DPMD Jayawardene (SL) 31 3 4941 176.46 159.3870968
HH Gibbs (SA) 14 1 2226 171.23 159
ER Dexter (Eng) 9 2 1416 202.28 157.3333333
L Hutton (Eng) 19 4 2966 197.73 156.1052632
Javed Miandad (Pak) 23 8 3584 238.93 155.826087
Younis Khan (Pak) 20 4 3110 194.37 155.5
WH Ponsford (Aus) 7 0 1087 155.28 155.2857143
LG Rowe (WI) 7 1 1066 177.66 152.2857143
GA Gooch (Eng) 20 1 3041 160.05 152.05
AB de Villiers (SA) 13 7 1970 328.33 151.5384615
GN Yallop (Aus) 8 0 1206 150.75 150.75
GS Sobers (WI) 26 9 3918 230.47 150.6923077
ED Weekes (WI) 15 0 2256 150.4 150.4
VT Trumper (Aus) 8 3 1189 237.8 148.625
GA Headley (WI) 10 3 1484 212 148.4
C Hill (Aus) 7 0 1035 147.85 147.8571429
G Gambhir (India) 9 0 1329 147.66 147.6666667
GM Turner (NZ) 7 2 1033 206.6 147.5714286
TW Graveney (Eng) 11 0 1623 147.54 147.5454545
GC Smith (SA) 25 3 3687 167.59 147.48
IVA Richards (WI) 24 5 3536 186.1 147.3333333
MJ Clarke (Aus) 19 4 2798 186.53 147.2631579
EH Hendren (Eng) 7 2 1030 206 147.1428571
Shoaib Mohammad (Pak) 7 2 1029 205.8 147
R Dravid (India) 36 8 5283 188.67 146.75
KWR Fletcher (Eng) 7 2 1027 205.4 146.7142857
Hanif Mohammad (Pak) 12 4 1755 219.37 146.25
RT Ponting (Aus) 41 7 5989 176.14 146.0731707
KP Pietersen (Eng) 20 1 2918 153.57 145.9
SR Tendulkar (India) 51 16 7435 212.42 145.7843137
VVS Laxman (India) 17 8 2473 274.77 145.4705882
HM Amla (SA) 15 6 2179 242.11 145.2666667
Mohammad Yousuf (Pak) 24 4 3485 174.25 145.2083333
JH Edrich (Eng) 12 3 1742 193.55 145.1666667
ME Trescothick (Eng) 14 0 2032 145.14 145.1428571
DM Jones (Aus) 11 5 1596 266 145.0909091
G Kirsten (SA) 21 2 3046 160.31 145.047619
AH Jones (NZ) 7 2 1014 202.8 144.8571429
RB Kanhai (WI) 15 1 2169 154.92 144.6
GS Chappell (Aus) 24 5 3465 182.36 144.375
CG Greenidge (WI) 19 3 2742 171.37 144.3157895
Mudassar Nazar (Pak) 10 1 1443 160.33 144.3
CC Hunte (WI) 8 1 1152 164.57 144
AR Morris (Aus) 12 2 1722 172.2 143.5
JB Hobbs (Eng) 15 1 2149 153.5 143.2666667
JL Langer (Aus) 23 4 3293 173.31 143.173913
PD Collingwood (Eng) 10 1 1427 158.55 142.7
DCS Compton (Eng) 17 2 2425 161.66 142.6470588
MD Crowe (NZ) 17 1 2420 151.25 142.3529412
AD Nourse (SA) 9 1 1281 160.12 142.3333333
MA Taylor (Aus) 19 5 2702 193 142.2105263
A Flower (Zim) 12 7 1700 340 141.6666667
RN Harvey (Aus) 21 1 2975 148.75 141.6666667
SM Gavaskar (India) 34 7 4802 177.85 141.2352941
Saeed Anwar (Pak) 11 1 1550 155 140.9090909
AN Cook (Eng) 20 4 2810 175.62 140.5
TT Samaraweera (SL) 14 4 1959 195.9 139.9285714
DI Gower (Eng) 18 5 2517 193.61 139.8333333
MW Gatting (Eng) 10 3 1398 199.71 139.8
PA de Silva (SL) 20 4 2794 174.62 139.7
KF Barrington (Eng) 20 5 2767 184.46 138.35
MEK Hussey (Aus) 16 4 2209 184.08 138.0625
WM Lawry (Aus) 13 0 1794 138 138
IM Chappell (Aus) 14 1 1929 148.38 137.7857143
JH Kallis (SA) 43 15 5909 211.03 137.4186047
MJ Slater (Aus) 14 0 1917 136.92 136.9285714
Inzamam-ul-Haq (Pak) 25 7 3421 190.05 136.84
MP Vaughan (Eng) 18 1 2456 144.47 136.4444444
ML Hayden (Aus) 30 2 4092 146.14 136.4
RR Sarwan (WI) 15 2 2041 157 136.0666667
AL Hassett (Aus) 10 1 1358 150.88 135.8
GR Viswanath (India) 14 2 1900 158.33 135.7142857
SR Waugh (Aus) 32 15 4342 255.41 135.6875
RB Richardson (WI) 16 2 2168 154.85 135.5
IR Bell (Eng) 16 6 2157 215.7 134.8125
Ijaz Ahmed (Pak) 12 1 1614 146.72 134.5
DJ Cullinan (SA) 14 4 1879 187.9 134.2142857
AJ Stewart (Eng) 15 3 2005 167.08 133.6666667
TM Dilshan (SL) 14 3 1869 169.9 133.5
RJ Shastri (India) 11 1 1468 146.8 133.4545455
CH Lloyd (WI) 19 3 2534 158.37 133.3684211
CL Walcott (WI) 15 1 2000 142.85 133.3333333
B Mitchell (SA) 8 2 1066 177.66 133.25
M Azharuddin (India) 22 4 2925 162.5 132.9545455
CL Hooper (WI) 13 3 1728 172.8 132.9230769
M Leyland (Eng) 9 1 1196 149.5 132.8888889
AR Border (Aus) 27 11 3580 223.75 132.5925926
PR Umrigar (India) 12 3 1591 176.77 132.5833333
AC Gilchrist (Aus) 17 6 2246 204.18 132.1176471
AJ Strauss (Eng) 21 0 2766 131.71 131.7142857
RC Fredericks (WI) 8 0 1053 131.62 131.625
Asif Iqbal (Pak) 11 3 1442 180.25 131.0909091
AG Prince (SA) 11 4 1441 205.85 131
H Sutcliffe (Eng) 16 2 2089 149.21 130.5625
DB Vengsarkar (India) 17 6 2204 200.36 129.6470588
SC Ganguly (India) 16 2 2074 148.14 129.625
KD Walters (Aus) 15 2 1942 149.38 129.4666667
IT Botham (Eng) 14 2 1805 150.41 128.9285714
G Boycott (Eng) 22 7 2830 188.66 128.6363636
DC Boon (Aus) 21 5 2700 168.75 128.5714286
NJ Astle (NZ) 11 2 1409 156.55 128.0909091
RA Smith (Eng) 9 3 1152 192 128
DL Haynes (WI) 18 3 2299 153.26 127.7222222
PBH May (Eng) 13 3 1653 165.3 127.1538462
MA Atherton (Eng) 16 1 2034 135.6 127.125
KJ Hughes (Aus) 9 2 1138 162.57 126.4444444
MC Cowdrey (Eng) 22 2 2778 138.9 126.2727273
S Chanderpaul (WI) 25 14 3154 286.72 126.16
Saleem Malik (Pak) 15 5 1891 189.1 126.0666667
IR Redpath (Aus) 8 1 1008 144 126
HP Tillakaratne (SL) 11 5 1380 230 125.4545455
LEG Ames (Eng) 8 1 1003 143.28 125.375
MA Butcher (Eng) 8 1 1000 142.85 125
NS Sidhu (India) 9 0 1116 124 124
GP Thorpe (Eng) 16 6 1976 197.6 123.5
JG Wright (NZ) 12 2 1480 148 123.3333333
Mushtaq Mohammad (Pak) 10 1 1232 136.88 123.2
DR Martyn (Aus) 13 2 1594 144.9 122.6153846
N Hussain (Eng) 14 3 1716 156 122.5714286
AI Kallicharran (WI) 12 2 1467 146.7 122.25
ME Waugh (Aus) 20 4 2412 150.75 120.6
HA Gomes (WI) 9 3 1083 180.5 120.3333333
SM Katich (Aus) 10 1 1182 131.33 118.2
GM Wood (Aus) 9 0 1057 117.44 117.4444444
AJ Lamb (Eng) 14 3 1642 149.27 117.2857143
M Amarnath (India) 11 5 1252 208.66 113.8181818
Either Broad or Bresnan for someone quicker with do. I've never advocated anything more radical than that. The bowling machine isn't broken, it just needs revving up a bit.
Dropping someone averaging about 17 for the last year before this match because he bowled too slow is just dumb.
That isn't quite what Monk was asking for - he wanted all scores of over 100 converted to exactly 100, not removed from the list altogether...
Player 50s 100s 150s 200s 150/50 150/100 200/100
DG Bradman (Aus) 42 29 18 12 0.428571429 0.620689655 0.413793103
DL Amiss (Eng) 22 11 8 2 0.363636364 0.727272727 0.181818182
V Sehwag (India) 54 22 14 6 0.259259259 0.636363636 0.272727273
Zaheer Abbas (Pak) 32 12 8 4 0.25 0.666666667 0.333333333
AR Morris (Aus) 24 12 6 1 0.25 0.5 0.083333333
MS Atapattu (SL) 33 16 8 6 0.242424242 0.5 0.375
KC Sangakkara (SL) 69 30 16 8 0.231884058 0.533333333 0.266666667
BC Lara (WI) 82 34 19 9 0.231707317 0.558823529 0.264705882
RB Simpson (Aus) 27 10 6 3 0.222222222 0.6 0.3
WR Hammond (Eng) 46 22 10 7 0.217391304 0.454545455 0.318181818
ED Weekes (WI) 34 15 7 2 0.205882353 0.466666667 0.133333333
RN Harvey (Aus) 45 21 9 2 0.2 0.428571429 0.095238095
GS Sobers (WI) 56 26 11 2 0.196428571 0.423076923 0.076923077
TW Graveney (Eng) 31 11 6 1 0.193548387 0.545454545 0.090909091
L Hutton (Eng) 52 19 10 4 0.192307692 0.526315789 0.210526316
DPMD Jayawardene (SL) 73 31 14 6 0.191780822 0.451612903 0.193548387
KP Pietersen (Eng) 47 20 9 3 0.191489362 0.45 0.15
HH Gibbs (SA) 40 14 7 2 0.175 0.5 0.142857143
GA Gooch (Eng) 46 20 8 2 0.173913043 0.4 0.1
SR Tendulkar (India) 116 51 20 6 0.172413793 0.392156863 0.117647059
SR Waugh (Aus) 82 32 14 1 0.170731707 0.4375 0.03125
MP Vaughan (Eng) 36 18 6 #N/A 0.166666667 0.333333333 #N/A
M Azharuddin (India) 43 22 7 #N/A 0.162790698 0.318181818 #N/A
Mohammad Yousuf (Pak) 57 24 9 4 0.157894737 0.375 0.166666667
Younis Khan (Pak) 46 20 7 3 0.152173913 0.35 0.15
SM Gavaskar (India) 79 34 12 4 0.151898734 0.352941176 0.117647059
Javed Miandad (Pak) 66 23 10 6 0.151515152 0.434782609 0.260869565
MJ Clarke (Aus) 41 19 6 2 0.146341463 0.315789474 0.105263158
RT Ponting (Aus) 103 41 15 6 0.145631068 0.365853659 0.146341463
G Kirsten (SA) 55 21 8 3 0.145454545 0.380952381 0.142857143
GS Chappell (Aus) 55 24 8 4 0.145454545 0.333333333 0.166666667
AB de Villiers (SA) 42 13 6 2 0.142857143 0.461538462 0.153846154
JH Kallis (SA) 98 43 14 2 0.142857143 0.325581395 0.046511628
DI Gower (Eng) 57 18 8 2 0.140350877 0.444444444 0.111111111
GC Smith (SA) 57 25 8 4 0.140350877 0.32 0.16
ME Trescothick (Eng) 43 14 6 1 0.139534884 0.428571429 0.071428571
RB Kanhai (WI) 43 15 6 2 0.139534884 0.4 0.133333333
JB Hobbs (Eng) 43 15 6 1 0.139534884 0.4 0.066666667
RB Richardson (WI) 43 16 6 #N/A 0.139534884 0.375 #N/A
ST Jayasuriya (SL) 45 14 6 3 0.133333333 0.428571429 0.214285714
JL Langer (Aus) 53 23 7 3 0.132075472 0.304347826 0.130434783
CH Gayle (WI) 46 13 6 3 0.130434783 0.461538462 0.230769231
MC Cowdrey (Eng) 60 22 7 #N/A 0.116666667 0.318181818 #N/A
DB Vengsarkar (India) 52 17 6 #N/A 0.115384615 0.352941176 #N/A
CG Greenidge (WI) 53 19 6 4 0.113207547 0.315789474 0.210526316
R Dravid (India) 99 36 11 5 0.111111111 0.305555556 0.138888889
IVA Richards (WI) 69 24 7 3 0.101449275 0.291666667 0.125
AR Border (Aus) 90 27 8 2 0.088888889 0.296296296 0.074074074
VVS Laxman (India) 73 17 6 2 0.082191781 0.352941176 0.117647059Ah yeah you'd take that data then merge in the 100s with vlookup. Statsguru is far too limited. Maybe later.That isn't quite what Monk was asking for - he wanted all scores of over 100 converted to exactly 100, not removed from the list altogether...
But it's still interesting.
you remember rightly, he most certainly did shorten Kallis up, I'm certain he struck him on the helmet too. Was watching at the cricket club, was a mightly impressive working over, got me super excited, much more telling of his talent than the actual six wickets imo.
Not that much of a surprise, surely. He was the master of the ground out 50.