Thank you for being so generous putting together these threads. They must take a lot of time and effort.
90's clay was weak, and still Sampras couldn't win RG...
Nadal dominated the strongest era at RG.
Those are the two clear conclusions.
Oh, and: 2016 was the weakest year at RG since 2002.
Thx. I love spreadsheets and the first took 3 or 4 hours and I got to do some new things. The cool thing is the way I set it up it only took 1/2 hour each to generate US Open and French Open data that you see.
A lot of this intuitively makes sense. The weakness started in 1989 when Chang won the French Open which was really cool, but a sign of weakness that a 17 year old came in and one the tournament. Gomez was considered a weak champion in 1990 (nice player, but not a great one.) Courier was not strong in 1991 when he won either. Courier and Bruguera had some nice years, but the overall field was not super strong then and so their achievements are put in perspective. From a points perspective Courier has very nice stats, but the points stats only start in 1991 and so about six of the late 70s and 80s players knock him back to 13. A player like Jose Luis Clerc might appear over rated, but he was knocked out by Lendl in 1981 and Wilander at 1982 at the French. With over 20 titles on clay in a fairly short period I'm not stressed that he rates above two time champs Courier and Bruguera. Clerc got knocked out by a young Yannik Noah in 1980 in a five settter as the 16th seed. Clerc stopped winning tournaments in 1983.
For me the amazing thing is that ELO ranks Borg close to Nadal. The gap though is still huge at over 100 points with Djokovic and Federer being below Borg, but much closer. For anyone to beat peak Nadal, the odds would be really against them.
Part of the weakness of the 2016 French field stats are that many young quarterfinalists were in the tournament and ultimatley their peak ELOs may be much higher which will boost the ranking. Nadal dropping out before the QF hurts some too. Every stat I've seen under states the danger of Wawrinka.
The current live ELO rankings for all surfaces are very interesting from abstracttennis.com:
1 Novak Djokovic 29.2 2555.8 2016 Miami Masters F 28.8 2570.6
2 Andy Murray 29.1 2389.2 2016 Wimbledon F 29.1 2389.2
3 Roger Federer 34.9 2340.8 2007 Dubai F 25.6 2524.3
4 Rafael Nadal 30.0 2302.7 2013 Beijing QF 27.3 2489.5
5 Kei Nishikori 26.6 2280.0 2015 Canada Masters QF 25.6 2289.8
6 Milos Raonic 25.6 2223.0 2016 Wimbledon SF 25.5 2243.3
7 Stanislas Wawrinka 31.3 2170.7 2016 Australian Open R32 30.8 2232.2
8 Tomas Berdych 30.9 2163.7 2013 Miami Masters R16 27.5 2226.1
9 Dominic Thiem 22.9 2138.3 2016 Halle R16 22.8 2215.4
10 Juan Martin Del Potro 27.8 2133.8 2009 US Open F 20.9 2352.3
11 Gael Monfils 29.9 2122.4 2011 Halle QF 24.8 2171.0
12 Richard Gasquet 30.0 2120.2 2013 Monte Carlo Masters R16 26.8 2136.1
13 Jo Wilfried Tsonga 31.2 2119.0 2009 Indian Wells Masters R64 23.9 2257.7
14 Nick Kyrgios 21.2 2089.2 2016 Rome Masters R32 21.0 2158.7
15 David Goffin 25.6 2077.8 2016 Monte Carlo Masters R32 25.3 2115.2
16 David Ferrer 34.3 2065.8 2013 Acapulco SF 30.9 2313.1
17 Roberto Bautista Agut 28.2 2044.6 2016 Rotterdam R16 27.8 2106.2
18 Marin Cilic 27.8 2024.6 2010 Dubai R16 21.4 2194.3
19 Philipp Kohlschreiber 32.8 2018.2 2009 Stuttgart R32 25.7 2086.2
20 Jack Sock 23.8 2016.3 2016 Australian Open R128 23.3 2109.4
21 John Isner 31.2 1997.5 2012 US Open R64 27.3 2147.2
22 Alexander Zverev 19.3 1980.5 2016 Halle SF 19.1 2050.6
23 Gilles Simon 31.6 1964.2 2009 Rotterdam R32 24.1 2118.7
24 Lucas Pouille 22.4 1960.4 2016 Wimbledon R16 22.3 2004.1
We see Nadal and Federer are significantly declined from the earlier peaks, but still good enough to make any top ten list of players at peak since 1978.

They are declined, but far, far from washed up.
We see that Isner, Ferrer, Tsonga, and even Cilic are significantly declined, while others like Ninja, Murray, Djokovic, Raonic, Goffin, Kyrgios, Monfils, RBA, Sock, Wawrinka, and even Berdy are still peaking or near peak.
ELO also spotted that Del Potro was a huge threat before he beat Wawa and Djoko. If Delpo can find his peak form he would be neck and neck with the top players except for Djokovic
Thiem is a fun one and already has a peak ELO of 2215 which is close to Wawrinka's best, not to mention peak Berdych and Tsonga. Thiem is rated much higher than peak Gasquet, Monfils, and Simon. ELO is a very cool stat. So much fun from one little number.
