DoG's Test Team Ratings - Throughout History

[The Battlers Prince]

Post no.9 in this thread on the first page has the attached excel file with all the data.

Thanks a whole heap DoG, I was worried that was the case. When I tried looking it up I couldn't find anything else beyond 1912, but its ok. I still found that small snippet a great exercise of the sides back then. Looking forward to your list of bowlers to come.
EDIT forget it sorted it out! Wow some amazing analysis there

 

[Days of Grace]

Update after the England-New Zealand and West Indies-Bangladesh series.

Now using a points-exchange system. The average of all teams is 100.00. Afghanistan and Ireland are not officially ranked since they have played less than 10 matches.

Australia	125.41
India	125.14
South Africa	113.06
England	109.61
New Zealand	108.98
Pakistan	106.45
Sri Lanka	96.06
West Indies	92.50
Bangladesh	72.35
Zimbabwe	60.70
Afghanistan	96.22
Ireland	93.51

 

[Days of Grace]

England has overtaken New Zealand, who have fallen from no.3 to no.5. The results of England-India and Australia-Sri Lanka will determine who takes no.1. I update the rankings after every series, rather than every match.

 

[Zinzan]

Update after the England-New Zealand and West Indies-Bangladesh series.

Now using a points-exchange system. The average of all teams is 100.00. Afghanistan and Ireland are not officially ranked since they have played less than 10 matches.

Australia	125.41
India	125.14
South Africa	113.06
England	109.61
New Zealand	108.98
Pakistan	106.45
Sri Lanka	96.06
West Indies	92.50
Bangladesh	72.35
Zimbabwe	60.70
Afghanistan	96.22
Ireland	93.51

Don't always agree with your outcomes, but this intuitively feels about right.

 

[Days of Grace]

Update: 22 March 2023

Australia	125.15
India	124.44
England	121.22
South Africa	112.50
New Zealand	112.18
Pakistan	98.77
Sri Lanka	95.98
West Indies	89.65
Bangladesh	70.12
Zimbabwe	60.27

Australia retain top spot after their comeback against India. New Zealand are still at no.5 despite winning their last three test matches. Sri Lanka slips down to no.7 below Pakistan. Now a noticeable gap between the top 5 and the rest.

 

[Days of Grace]

Update: 3 November 2024:

New Zealand have incredibly jumped from 6th to 2nd!

Australia	131.75
New Zealand	116.96
India	115.36
South Africa	113.19
England	112.35
Sri Lanka	106.32
Pakistan	98.11
West Indies	89.03
Bangladesh	79.17
Zimbabwe	59.71

 

[Coronis]

Update: 3 November 2024:

New Zealand have incredibly jumped from 6th to 2nd!

Australia	131.75
New Zealand	116.96
India	115.36
South Africa	113.19
England	112.35
Sri Lanka	106.32
Pakistan	98.11
West Indies	89.03
Bangladesh	79.17
Zimbabwe	59.71

Just for clarity, how was the gap between India vs Australia prior to the series?

 

[vitalogy83]

Attaching it now, in fact. Enjoy.

This is great work DOG. Is there an updated version of this excel?

 

[Days of Grace]

Before the series, Australia had 131.75 and India had 127.87. Even if India had won 3-0, it would have only boosted their score to 130.36, such was the massive difference between India and New Zealand.

How the formula works:
Win: 2.50
Draw: 0.00
Loss -2.50

Points adjusted by the difference between the two teams:
Points + Difference *-0.05

When the difference between the two teams is 40.00 or more:
Maximum points for wins: 4.50
Minimum points for wins: 0.50
Minimum points for losses: -4.50
Maximum points for losses: -0.50
Minimum points for draws: -2:00
Maximum points for draws: 2.00

Before the series, India had 127.87 points, New Zealand 104.45. Add 5 points to India and subtract 5 points from New Zealand because India were playing at home. The difference was therefore 33.43.

For India:
Three losses -2.50 + (33.43 *-0.05) = -12.51 *3 =-12.51

For New Zealand:
Three wins 2.50 + (-33.43 *-0.05) = 4.17 * 3 = 12.51

 

[Coronis]

Before the series, Australia had 131.75 and India had 127.87. Even if India had won 3-0, it would have only boosted their score to 130.36, such was the massive difference between India and New Zealand.

How the formula works:
Win: 2.50
Draw: 0.00
Loss -2.50

Points adjusted by the difference between the two teams:
Points + Difference *-0.05

When the difference between the two teams is 40.00 or more:
Maximum points for wins: 4.50
Minimum points for wins: 0.50
Minimum points for losses: -4.50
Maximum points for losses: -0.50
Minimum points for draws: -2:00
Maximum points for draws: 2.00

Before the series, India had 127.87 points, New Zealand 104.45. Add 5 points to India and subtract 5 points from New Zealand because India were playing at home. The difference was therefore 33.43.

For India:
Three losses -2.50 + (33.43 *-0.05) = -12.51 *3 =-12.51

For New Zealand:
Three wins 2.50 + (-33.43 *-0.05) = 4.17 * 3 = 12.51

Thanks mate, great work as always