Having finally managed to work out what counts in the 400 (slam and ATP main tour, including qualifying but not including DC or walkovers
Really? I know DC is counted in the player pages and I couldn't imagine qualifying is.
I was mildly surprised by that bit too (at least, I wouldn't have been confident about it without reconciling the 400 figure), so I'll tell you how I got there and you can see if you can find a flaw: (*)
- copied his whole history off ITF and added in today's win
- took out all Challs/Fut (I don't think there he played any of those from 2006 onwards - if he did, I really have messed up!)
- set Excel to count the lines with no "partnering" (i.e. no doubles) in them and "W"s in the W/L column (that also cut out the w/os which are coded "O")
- that gave me a total of 414, which included 14 Davis Cup singles wins and 2 wins in ATP qualifying
From that, I made the obvious assumption about what the ATP must count (and not count) to arrive at the 400 figure.
So that you have the whole story, the number of walkover wins I excluded was 5.
Edit: (*) by which I mean something I missed and/or another plausible way to get to 400
-- Edited by steven on Tuesday 7th of May 2013 11:14:28 PM
__________________
GB on a shirt, Davis Cup still gleaming, 79 years of hurt, never stopped us dreaming ... 29/11/2015 that dream came true!
A bit of a nail-biter, but Mayer is not called Funky Flo for nothing. A difficult player to read, and Andy said he had problems with it. I've always liked Flo - I always like players that are a bit (or a lot) unorthodox.
Sounded like a really tough match but to his credit Andy found a way to win in 2 and Mayer can be an awkward customer. Simon is a good match up for Andy generally and hopefully he can also master him on clay.
Having finally managed to work out what counts in the 400 (slam and ATP main tour, including qualifying but not including DC or walkovers - much as I expected but it took a bit of manipulation of the data to make sure), those 400 wins came against 165 different players from 46 countries. With those sorts done in the spreadsheet, it's just a case of reading off the most frequent country and player scalps among those 400 wins.
The country list is obviously heavily correlated with how many players each country has on the ATP tour:
FRA 56 14% ESP 53 13% USA 42 11% ARG 25 6% SUI 23 6% CRO 19 5% ITA 18 5% RUS 18 5% SRB 17 4% GER 13 3% CZE 11 3% UKR 7 2% AUS 6 2% BEL 6 2% SWE 6 2% AUT 5 1% CYP 5 1% FIN 5 1% LAT 5 1% CHI 4 1% COL 4 1% GBR 4 1% JPN 4 1% KAZ 4 1% ROU 4 1% BLR 3 1% BUL 3 1% DEN 3 1% NED 3 1% RSA 3 1% SVK 3 1% CAN 2 1% POR 2 1% TPE 2 1% BRA 1 0% CHN 1 0% GRE 1 0% IND 1 0% JAM 1 0% KOR 1 0% LTU 1 0% LUX 1 0% PAR 1 0% THA 1 0% URU 1 0% UZB 1 0%
__________________
GB on a shirt, Davis Cup still gleaming, 79 years of hurt, never stopped us dreaming ... 29/11/2015 that dream came true!