MensTennisForums.com

MensTennisForums.com (http://www.menstennisforums.com/index.php)
-   Statistics (http://www.menstennisforums.com/forumdisplay.php?f=11)
-   -   Main Tour, Challenger and Futures stats 2012! (http://www.menstennisforums.com/showthread.php?t=214003)

V.H. 12-21-2012 06:34 PM

Main Tour, Challenger and Futures stats 2012!
 
Okay, so I have now updated my files for 2012!
It's too much bother to get the stats into these code-tables in here, so in stead I give you guys the link to my Excel file!

http://www.2shared.com/file/aPxMnR_Y/ATP_Archive.html


How to use
After you've opened the file you see the different tabs on the bottom with the following color codes:
  • Blue: The data, copy-paste-magic-tricked from ATP site into Excel. DBL-tabs are just duplicants (double rows) for making doubles stats.
  • Grey/"PT": PivotTables. Here's where I actually make the stats. Now you try it!! You can make all sorts of stats! Like.. which doubles pair won most clay titles in 1972?
  • Red/"Lists": The stats I have chosen to pick out from the data, most titles and stuff like that, just in case you're too lazy to make them on your own!

Notes
  • Tournaments is from ATP Arhive as it was when I made this (2010?). So some tournaments are left out... (Connors still with 107 titles i.e.) All later years should be complete.
  • Futures circuit 2012 aren't played trough, so this is updated after week of December 3

Litotes 12-22-2012 12:18 PM

Re: Main Tour, Challenger and Futures stats 2012!
 
Many thanks, really great work :D

Henry Chinaski 12-23-2012 07:12 PM

Re: Main Tour, Challenger and Futures stats 2012!
 
great work. thanks

Adri89 01-03-2013 02:15 PM

Re: Main Tour, Challenger and Futures stats 2012!
 
V.H., you did a great work. I could see it for Ionita : the ATP shows that he won only 23 titles in Futures and 1 Challenger. In fact, as you mentionned, he won 24 titles :
- F1 Romania (2003)
- F3, F5, F9, F13, F15, F16 and F17 Romania (2004) with a 25 wins in a row this year
- F7 Italy (2005)
- F8, F16 Italy, F4, F8, F16, F17 Romania (2006)
- F2, F3 Portugal, F3, F8, F11, F18 Romania (2008)
- F8 and F9 Romania (2009)
- F2 Romania (2011)
The legend didn't play in 2012.

So thank you very much for this work :yeah:

V.H. 01-03-2013 09:41 PM

Re: Main Tour, Challenger and Futures stats 2012!
 
Thank you!
I'm pretty sure the reason for this mistake is his walkover-win in the final of Romania F8 in 2008. Since the stats count final wins and walkovers aren't counted as wins (poor programming by ATP staff here), they cause some errors! After all, my data is collected from the ATP website...


All times are GMT. The time now is 05:41 PM.

Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.