Author Topic: Live ATP Rankings  (Read 6224 times)

0 Members and 1 Guest are viewing this topic.

Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Live ATP Rankings
« on: March 20, 2013, 09:16:39 AM »
I am delighted to bring to this forum the live updates from the ranking system I developed.
The rankings are displayed using images. Please follow the instructions of this thread for a maximum viewing experience.

Here is the legend for the color code and display mode of the table.

- The table displays current ranking standings by calculating the number of points dropped at the end of the period mentioned on the head table (the next official ATP rankings date).
- The Drop column details the number of points for all the tournaments that will be taken out of the player's rankings. Multiple tournaments may be dropped for each player, but the tournament with the most points dropped will determine the color of the drop points. For instance, 180 Wimbledon dropped along with 45 ATP 250 in the week after Wimbledon will result in 225 colored in red (Grand Slam color).
- The Gain column displays the total number of points the player has raised at the current tournament.
- The Effective column is the exact number of points the player will win or lose at the next official ranking. The total here is calculated based on all tournaments dropped and all tournaments played (GS qualies, Futures and all other tournaments that will be counted at the next official rankings). The color is determined again by the tournament with most points.
- The second Points column is for the next week after the current week. When no Grand Slam is being played, all current Futures tournaments are first counted there, since they won't be part of the rankings until a week later. Also, all next week's qualifiers will be counted there.
- In all weeks an additional Incoming Futures column is being displayed, along with the total tournament count calculated in advance so that the players with the same number of points are separated properly.
- During Grand Slam qualies another column with the points made there (not yet Live) is added. And during Grand Slams, another column with the points from the tournament is added in case a player goes to another tournament after the GS or GS qualies, but before the next official rankings.
- In the detailed week by week part of the table, you will encounter -1 points for certain players. Those tournaments are actually the tournaments in which the player has received a 0-point penalty for retiring or for not completing at least 4 ATP 500 tournaments in a year.


The colors used as background inside the table mean:
Green- The player is currently not eliminated from the Main Draw.
Red - The player was eliminated from the Main Draw or Qualifying Draw.
Blue - The player is currently playing on the Qualifying Draw.
Orange - The player has retired from any match.
Gray - The player has withdrawn from the tournament, but will incur a 0-point penalty. This will be noted as a -1 in case of ATP 500 events, and 0 in case of ATP 1000. This is due to the fact that ATP 1000 events are recognized as Mandatory by the system, while ATP 500 events are not, and there needs to be a difference between regular 0 (first round loss) and mandatory 0 (penalty).
White - The player currently does not participate in a tournament.


The colors used for text inside the table mean:
Red - The player is/was on a Grand Slam Main Draw
Regular orange - The player is/was on a ATP 1000 Mandatory Masters Main Draw
Light orange - The player is/was on a ATP 1000 Optional (MC) Masters Main Draw
Maroon - The player is/was on the ATP Tour Finals Main Draw
Green - The player is/was on a ATP 500 Main Draw
Olive - The player is/was on the Olympics Main Draw
Purple - The player is/was on a ATP 250 Main Draw
Plum - The player is/was on the World Team Championships tournament
Sky Blue - The player participated in the Davis Cup
Teal - The player is/was on the ATP Challenger Finals
Blue - The player is/was on a Challenger Main Draw
Navy - The player is/was on a 15K Futures Main Draw
Black - The player is/was on a 10K Futures Main Draw
Gray - The player participates on the Qualifying Draw of any tournament
Silver - The player does not participate in a tournament

If you have any trouble seeing the latest image, please clear your internet cache and try again... Help on clearing the cache: http://kb.iu.edu/data/ahic.html#fire35w

With all the instructions being laid, here comes the table:

Link to complete table: LIVE ATP

Link to official rankings from past Mondays: OFFICIAL RANKINGS

Further on, the Rankings are displayed as follows:
USE LINKS BELOW TO EASILY NAVIGATE TO THE DESIRED RANKINGS TABLE:
LIVE ATP RANKINGS AND RACE [COMPLETE]
LIVE U16 RANKINGS AND RACE
LIVE U18 RANKINGS AND RACE
LIVE U19 RANKINGS AND RACE
LIVE U21 RANKINGS AND RACE
LIVE U24 RANKINGS AND RACE
LIVE O30 RANKINGS AND RACE
LIVE O32 RANKINGS AND RACE
LIVE O35 RANKINGS AND RACE
LIVE RANKINGS AND RACE ENTRY PROJECTIONS
LIVE RANKINGS AND RACE ENTRIES
LIVE RANKINGS EXITS
« Last Edit: November 15, 2013, 02:08:33 AM by Slasher1985 »

Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #1 on: March 20, 2013, 09:16:59 AM »
« Last Edit: March 20, 2013, 09:46:10 AM by Slasher1985 »

Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #2 on: March 20, 2013, 09:46:20 AM »


Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #3 on: March 20, 2013, 09:46:44 AM »


Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #4 on: March 20, 2013, 09:47:02 AM »


Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #5 on: March 20, 2013, 09:47:25 AM »


Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #6 on: March 20, 2013, 09:47:43 AM »


Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #7 on: March 20, 2013, 09:48:00 AM »


Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #8 on: March 20, 2013, 09:48:18 AM »


Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #9 on: March 20, 2013, 09:48:36 AM »


Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #10 on: March 20, 2013, 09:48:57 AM »


Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #11 on: March 20, 2013, 09:49:23 AM »

« Last Edit: May 21, 2013, 08:34:29 AM by Slasher1985 »

Offline Tennis4you

  • Administrator
  • Tennis God
  • ******
  • Posts: 24854
  • Gender: Male
    • Tennis4you
Re: Live ATP Rankings
« Reply #12 on: March 20, 2013, 10:31:03 AM »
Holy crap!  You do the top 2000?  That is amazing!  How often do you update these?
Good Luck on the Court!!!
Scott Baker
http://www.tennis4you.com

Offline masterclass

  • Tennis Pro
  • *****
  • Posts: 366
Re: Live ATP Rankings
« Reply #13 on: March 20, 2013, 10:47:29 AM »
This is fantastic!  Thank you Sir!

Just curious, how do you know for sure when someone is going to get a 0 pointer for missing a tournament, or not?

Respectfully,
masterclass
Legends of Tennis

Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #14 on: March 20, 2013, 12:10:35 PM »
Holy crap!  You do the top 2000?  That is amazing!  How often do you update these?

I do it all, not just the Top 2000. I also do the race and a version divided by age groups for each, but I have not yet had time to post them. :))

This is fantastic!  Thank you Sir!

Just curious, how do you know for sure when someone is going to get a 0 pointer for missing a tournament, or not?

Respectfully,
masterclass

In the case of Masters and GS, there is an automatic routine that views the entry list of the tournaments to know the players that have been directly accepted on the Main Draw. If they are not subsequently found in the Main Draw, they automatically get a penalty. In the case of ATP 500, stuff must be done manually, and only when it is known for sure it's gonna happen. ATP is crap regarding this rule, so this is much harder.

Offline masterclass

  • Tennis Pro
  • *****
  • Posts: 366
Re: Live ATP Rankings
« Reply #15 on: March 20, 2013, 01:23:05 PM »
Holy crap!  You do the top 2000?  That is amazing!  How often do you update these?

I do it all, not just the Top 2000. I also do the race and a version divided by age groups for each, but I have not yet had time to post them. :))

This is fantastic!  Thank you Sir!

Just curious, how do you know for sure when someone is going to get a 0 pointer for missing a tournament, or not?

Respectfully,
masterclass

In the case of Masters and GS, there is an automatic routine that views the entry list of the tournaments to know the players that have been directly accepted on the Main Draw. If they are not subsequently found in the Main Draw, they automatically get a penalty. In the case of ATP 500, stuff must be done manually, and only when it is known for sure it's gonna happen. ATP is crap regarding this rule, so this is much harder.

Makes sense, thanks.  I've seen sometimes in the case of 500's that they even change it later. You almost have to scrape each player's ranking list everyday to make sure it is always correct.  I can see how it would be a pain.

Respectfully,
masterclass
Legends of Tennis

Offline Swish

  • Tennis God
  • ******
  • Posts: 9999
  • Gender: Male
  • How Many Times?
Re: Live ATP Rankings
« Reply #16 on: March 20, 2013, 10:39:16 PM »
I nominate slasher1985 to the tennis hall of fame.  :king:
 
 

Offline FreakyGOAT > CD

  • Tennis God
  • ******
  • Posts: 1678
  • Gender: Male
  • Amir Blumensauce
Re: Live ATP Rankings
« Reply #17 on: March 20, 2013, 10:53:02 PM »
Do you have a copy of your sheet? I would like to see all the crazy formulas you use

Just by looking at the bottom rankings I found Joao Lucas Magalhaes Hueb De Menezes. What a GOAT name.
Oh Sheesh Y'all T'was A Dream

Offline Slasher1985

  • Global Moderator
  • Tennis God
  • ******
  • Posts: 565
  • Gender: Male
  • Rankings Wizard
Re: Live ATP Rankings
« Reply #18 on: March 21, 2013, 02:45:52 AM »
Do you have a copy of your sheet? I would like to see all the crazy formulas you use

Just by looking at the bottom rankings I found Joao Lucas Magalhaes Hueb De Menezes. What a GOAT name.

Of course. The link to a macroless sheet containing all data is in the OP, right there at "Link to complete table". Just go to that folder, and search for the xlsx to get it all. The key though to the live update is the macros, which are not public. :))

Offline tennisville

  • Tennis Player
  • **
  • Posts: 74
Re: Live ATP Rankings
« Reply #19 on: March 21, 2013, 04:44:10 AM »
you must be an expert in Excel to create a live rankings spreadsheet  ://  How did you master Excel ?