• Welcome to the Cricket Web forums, one of the biggest forums in the world dedicated to cricket.

    You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join the Cricket Web community today!

    If you have any problems with the registration process or your account login, please contact us.

Five year peaks - point to point (excel help)

srbhkshk

srbhkshk

International Captain
Days of Grace said:
Test Batsmen Top 10 Five Calendar Year Peaks (Ranked by adjusted average, adjusted runs per innings and adjusted strike-rate; 40 innings required to get full points)

1. DG Bradman 1930-1934 Ave: 98.14 RPI: 92.36 S/R: 73.57 (34 innings)
2. JB Hobbs 1910-1914 Ave: 76.46 RPI: 67.72 S/R: 60.37 (35 innings)
3. IVA Richards 1976-1980 Ave: 69.13 RPI: 67.63 S/R: 65.55 (46 innings)
4. GS Sobers 1958-1962 Ave: 72.26 RPI: 62.84 S/R: 61.66 (46 innings)
5. CL Walcott 1952-1956 Ave: 71.80 RPI: 65.07 S/R: 64.26 (32 innings)
6. SPD Smith 2014-2018 Ave: 68.13 RPI: 57.83 S/R: 51.96 (86 innings)
7. RT Ponting 2002-2006 Ave: 67.64 RPI: 57.88 S/R: 54.46 (97 innings)
8. GA Faulkner 1907-1911 Ave: 69.60 RPI: 64.24 S/R: 56.65 (26 innings)
9. C Hill 1898-1902 Ave: 65.45 RPI: 61.60 S/R: 57.54 (34 innings)
10. KC Sangakkara 2006-2010 Ave: 64.94 RPI: 58.35 S/R: 51.77 (69 innings)
Click to expand...
This is a great list but somehow I find it hard to believe that the two most modern guys are also the ones with the lowest strike rate.
 
honestbharani

honestbharani

Whatever it takes!!!
I guess he batted faster maybe earlier in his career then? Anyways, adjusted SR is a bit complicated and maybe even unnecessary for a test match peak list IMO.
 
trundler

trundler

Request Your Custom Title Now!
Nah definitely necessary. They had 120 overs a day at times in the olden days. Bradman alone faced 70 overs when he scored 300 in a day. He was scoring much faster than anyone else except McCabe despite an SR in the high 50s/low 60s over his career. Defensive batsmen like Hutton, Sutcliffe (and an older Hammond) had strike rates in the 30s. Stroke-makers like May and Dexter in the 40s so a guy like Sobers or Walcott stood out more than Pietersen.

Now whether the strike rates themselves are reliable or not given they're mere estimates is an issue though.
 
Coronis

Coronis

Cricketer Of The Year
Days of Grace said:
Test Batsmen Top 10 Five Calendar Year Peaks (Ranked by adjusted average, adjusted runs per innings and adjusted strike-rate; 40 innings required to get full points)

1. DG Bradman 1930-1934 Ave: 98.14 RPI: 92.36 S/R: 73.57 (34 innings)
2. JB Hobbs 1910-1914 Ave: 76.46 RPI: 67.72 S/R: 60.37 (35 innings)
3. IVA Richards 1976-1980 Ave: 69.13 RPI: 67.63 S/R: 65.55 (46 innings)
4. GS Sobers 1958-1962 Ave: 72.26 RPI: 62.84 S/R: 61.66 (46 innings)
5. CL Walcott 1952-1956 Ave: 71.80 RPI: 65.07 S/R: 64.26 (32 innings)
6. SPD Smith 2014-2018 Ave: 68.13 RPI: 57.83 S/R: 51.96 (86 innings)
7. RT Ponting 2002-2006 Ave: 67.64 RPI: 57.88 S/R: 54.46 (97 innings)
8. GA Faulkner 1907-1911 Ave: 69.60 RPI: 64.24 S/R: 56.65 (26 innings)
9. C Hill 1898-1902 Ave: 65.45 RPI: 61.60 S/R: 57.54 (34 innings)
10. KC Sangakkara 2006-2010 Ave: 64.94 RPI: 58.35 S/R: 51.77 (69 innings)
Click to expand...
My favourite part of this is that Bradman’s 5 year peak includes bodyline. Also imagine how Hobbs’ career would look without WW1.
 
weldone

weldone

Hall of Fame Member
Days of Grace said:
Unfortunately, the five year peak rating doesn't work for Pat Cummins, who play one test in 2011 and then didn't play again until 2017. So they only time we has played two test matches during a period of five years was from 2011 to 2017.

It may be better to just stick to calendar years, but then again you have players who didn't string together five consecutive calandar years at any point in their careers.

I wanted a change from 40 innings or 50 innings because a player from this century may complete 40 innings in 2 years but a player from 70 years ago may have taken 8 years to do the same thing.
Click to expand...
How about doing something like 6-year peaks for batsmen and spinners and 4-year peaks for seam bowlers thereby recognizing different disciplines of the game require different levels of physical stamina?
 
0

_00_deathscar

International Regular
Days of Grace said:
Test Bowlers Top 10 Five Calendar Year Peaks (Ranked by adjusted average, wickets per innings and adjusted strike-rate; 40 innings required to get full points)

WicketsAdj. Ave. (Orig.)WPIAdj. S/R (Orig.)Innings
1.Imran Khan1982-198613814.39 (14.31)3.4539.62 (39.13)40
2.M Muralitharan2002-200628717.36 (18.08)3.9348.56 (45.54)73
3.SF Barnes1910-191412217.72 (14.08)4.5243.89 (35.07)27
4.Sir RJ Hadlee1984-198819117.97 (18.15)3.4743.01 (43.90)55
5.Waqar Younis1990-199418418.92 (18.49)3.3536.64 (35.38)55
6.JC Laker1955-195911416.18 (15.69)2.5349.84 (57.14)45
7.GA Lohmann1892-18965413.87 (10.07)3.8643.28 (33.61)14
8.Shoaib Akhtar2000-200411018.80 (19.32)2.8238.50 (35.15)39
9.DW Steyn2013-201711818.04 (18.54)2.6843.21 (39.90)44
10.MD Marshall1985-198916518.66 (18.35)2.8443.51 (42.58)58
Click to expand...
It wasn't until recently when someone mentioned Shoaib's peak period - I wouldn't have had him down to be a top tenner in this list even with that though. That's interesting.

Imran's peak is well documented - incredible strike rate too.
 
vcs

vcs

Request Your Custom Title Now!
Surprising that Steyn's peak didn't come some time between 2007-11 rather than 2013-17. Thought he missed a lot of matches between 2015-17.
 
Days of Grace

Days of Grace

International Captain
Steyn didn’t play any matches in 2017 so I revised the criteria so a player’s peak must include at least five calandar years from first match to last match. Therefore Steyn’s peak is from 2007-2011 and Walcott’s from 1954-1958.
 
stephen

stephen

Cricket Web: All-Time Legend
How are you adjusting the averages? Does it take into account quality of opposition it just era? And if just era, how is the era calculated.

Viv, for example, never faced his own attack which was by far the strongest. Is that factored in? Faulkner and Hill both feel over adjusted.

Can we get the list for the unadjusted peaks?
 
trundler

trundler

Request Your Custom Title Now!
stephen said:
How are you adjusting the averages? Does it take into account quality of opposition it just era? And if just era, how is the era calculated.

Viv, for example, never faced his own attack which was by far the strongest. Is that factored in? Faulkner and Hill both feel over adjusted.

Can we get the list for the unadjusted peaks?
Click to expand...
Are they though? That could just as well mean we're underrating them rather than any problem with the algorithm.
 
Coronis

Coronis

Cricketer Of The Year
Was looking at Charles Davis’ site today and saw something very odd in his historically adjusted SR’s.. Trumper and Hill despite having an almost complete career overlap had very different adjustments, Trumper’s SR adjusting from 68-69 down to 66-67 and Hill’s adjusting from 66.9 all the way down to 58-59..
 
srbhkshk

srbhkshk

International Captain
Coronis said:
Was looking at Charles Davis’ site today and saw something very odd in his historically adjusted SR’s.. Trumper and Hill despite having an almost complete career overlap had very different adjustments, Trumper’s SR adjusting from 68-69 down to 66-67 and Hill’s adjusting from 66.9 all the way down to 58-59..
Click to expand...
I might be wrong but I think he used time batted to derive this stat, so career overlap doesn't necessarily mean the same adjustment.
 
You must log in or register to reply here.

Top