Main Tour, Challenger and Futures stats 2012! - MensTennisForums.com

MensTennisForums.com

MenstennisForums.com is the premier Men's Tennis forum on the internet. Registered Users do not see the above ads.Please Register - It's Free!

Reply

Old 12-21-2012, 06:34 PM   #1
country flag V.H.
Registered User
 
V.H.'s Avatar
 
Join Date: Jun 2009
Posts: 305
V.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond repute
Default 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
V.H. is offline View My Blog!   Reply With Quote
Sponsored Links
Advertisement
 

Old 12-22-2012, 12:18 PM   #2
country flag Litotes
ALT-0
 
Litotes's Avatar
 
Join Date: Mar 2012
Location: Norway
Age: 41
Posts: 30,068
Litotes has a reputation beyond reputeLitotes has a reputation beyond reputeLitotes has a reputation beyond reputeLitotes has a reputation beyond reputeLitotes has a reputation beyond reputeLitotes has a reputation beyond reputeLitotes has a reputation beyond reputeLitotes has a reputation beyond reputeLitotes has a reputation beyond reputeLitotes has a reputation beyond reputeLitotes has a reputation beyond repute
Default Re: Main Tour, Challenger and Futures stats 2012!

Many thanks, really great work
Litotes is online now View My Blog!   Reply With Quote
Old 12-23-2012, 07:12 PM   #3
country flag Henry Chinaski
Registered User
 
Henry Chinaski's Avatar
 
Join Date: Oct 2006
Posts: 13,752
Henry Chinaski has a reputation beyond reputeHenry Chinaski has a reputation beyond reputeHenry Chinaski has a reputation beyond reputeHenry Chinaski has a reputation beyond reputeHenry Chinaski has a reputation beyond reputeHenry Chinaski has a reputation beyond reputeHenry Chinaski has a reputation beyond reputeHenry Chinaski has a reputation beyond reputeHenry Chinaski has a reputation beyond reputeHenry Chinaski has a reputation beyond reputeHenry Chinaski has a reputation beyond repute
Default Re: Main Tour, Challenger and Futures stats 2012!

great work. thanks
__________________
www.shanktennis.com
Henry Chinaski is offline View My Blog!   Reply With Quote
Old 01-03-2013, 02:15 PM   #4
country flag Adri89
Registered User
 
Join Date: Mar 2008
Age: 24
Posts: 1,644
Adri89 has a reputation beyond reputeAdri89 has a reputation beyond reputeAdri89 has a reputation beyond reputeAdri89 has a reputation beyond reputeAdri89 has a reputation beyond reputeAdri89 has a reputation beyond reputeAdri89 has a reputation beyond reputeAdri89 has a reputation beyond reputeAdri89 has a reputation beyond reputeAdri89 has a reputation beyond reputeAdri89 has a reputation beyond repute
Default 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
Adri89 is offline View My Blog!   Reply With Quote
Old 01-03-2013, 09:41 PM   #5
country flag V.H.
Registered User
 
V.H.'s Avatar
 
Join Date: Jun 2009
Posts: 305
V.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond reputeV.H. has a reputation beyond repute
Default 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...
V.H. is offline View My Blog!   Reply With Quote
Reply


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


Copyright (C) Verticalscope Inc
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
vBCredits v1.4 Copyright ©2007, PixelFX Studios