British Men - Top 25 etc table

steven · Tennis legend

RE: British Men - Top 25 etc table

Count Zero · Tennis legend

well my outrage was slightly tongue in cheek :)

i was thinking of possibly a bandage around the head smiley and a sweatband around the head smiley.

indiana · Tennis legend

Oh, a training block one for Boggo. Never can have too many training blocks. A man born to train wink

steven · Tennis legend

12 September rankings now added.

There are new singles career highs in the top 1000 for Sean Thornley, up 37 to 538, Fitzy, up 102

to 755, Lewis Burton at 811, James Marsalek at 847 and Matthew Short at 873, which Nicholas Jones takes over from Liam as the youngest Brit with an ATP singles ranking, joining the list at WR 1515, having beaten fellow-qualifier John Rambotas in Wrexham a couple of weeks ago.

There are new doubles CHs in the top 500 for Flembo, back into the top 50 at 43 (up 8 and taking out his old CH of 46), Sean & Dave at 205 & 211 and Lewis Burton at 454.

steven · Tennis legend

Updated with 26 September 2011 rankings.

There are new singles career highs in the top 1000 for Alex Ward, up 24 to 445, Lewis Burton, up 62 to 682, Fitzy, up 2 to 733, & James Marsalek, up 24 to 826.

New doubles career highs are led by Colin Fleming at 42, while Jamie Murray gets 10 places closer to his CH, moving up to DWR 31.

-- Edited by steven on Monday 26th of September 2011 06:22:44 AM

steven · Tennis legend

Updated with 3 Oct rankings.

There are new singles career highs for Alex Ward, up 28 to 417 with his Falun title still to add next Monday), Lewis Burton 672, James Marsalek 813, Matthew Short 852 and Toby Martin 1115. Last but not least, George Morgan soars 1163 places to WR 760 as his Danderyd title points get added, improving his career high by 150 places - he even has a new doubles career high, up over 200 to 822, to go with it.

There are new doubles career highs in the top 500 for Flembo, up another 1 to 41 as he closes in on the top 40, Morgan Phillips 405 and Dan Cox 476.

steven · Tennis legend

Updated with 10 October 2011 rankings.

There are new singles career highs for Alex Ward, breaking into the top 400 at WR 375 (up 42), Lewis Burton at 611 and George Morgan at 745.

There are new doubles career highs in the top 500 for Jamie Murray, breaking into the top 25 at WR 23 (up 9), Andy Murray at 52 (up 25), Sean Thornley at 204, Morgan Phillips at 399 and Dan Cox at 472.

Somewhat coincidentally (and it won't make much difference to any of them), the doubles pair for the Luxembourg DC tie, Andy & Jamie, are now just one place behind the doubles pair for the Hungary DC tie, Flembo & Hutch, in the ATP doubles team race, at 23 and 22 respectively.

steven · Tennis legend

Updated with 17 October 2011 rankings, which see Muzz move ahead of Fed for the very first time as he climbs to WR 3.

There are new singles career highs in the top 1000 for Lewis Burton 660, Liam Brody 662, Fitzy, up 43 to 708, George Morgan 743, Oli Golding 769, James Marsalek 812 and Matthew Short 826, while Alastair Barnes and Darren Walsh have both joined the singles rankings for the first time at 1534=.

Sean Thornley has made it into the doubles top 200 at 197 and there are also new doubles career highs in the top 500 for Andy Murray at 51, Dave Rice 200 and Dan Cox 469.

Mikeduke · County player

Steven,

Is it possible to give the page a title tag so we can see what we are looking at when it is tabbed?

I also wondered if it was possible to put the ranking of the player that beat the british player next to their name so we can establish if it was (at the time) a good or bad loss? Although obviously the smiley does indicate this!

Also thanks for doing this, its an amazing resource.

steven · Tennis legend

Thank you for your comments. I'm always happy to consider suggestions for improvement but I have to admit, I'm getting more reluctant these days to add things that might end up involving significant extra work without a huge benefit.
That reluctance probably stems from slightly regretting taking up a suggestion to put links to all the tournament threads at the bottom of the tables - it has definitely been a worthwhile addition, but it is quite a pain to do every week, especuially when (for obvious reasons) the threads don't all appear on the forum at the same time.
Mikeduke wrote:
Is it possible to give the page a title tag so we can see what we are looking at when it is tabbed?
If you mean a title that will appear in the blue bar at the top of the browser, I agree that it would be nice but not being able to do that is a limitation of Excel's 'publish as web page' function, without which I wouldn't have been able to do the tables in the first place.
There are ways to get around it, but they would make it more fiddly to keep republishing the table. Being able to rapidly republish and re-upload when a result has come in but I'm in a hurry is something I don't want to risk losing.

Mikeduke wrote:
I also wondered if it was possible to put the ranking of the player that beat the british player next to their name so we can establish if it was (at the time) a good or bad loss? Although obviously the smiley does indicate this!
This is a feature I've often thought about adding, but again it would involve extra work (perhaps not that much extra work, given that I tend to tweet some of the opponents' rankings nowadays, but it would be very tedious at times - and would make the table even wider!) without adding much beyond what the smileys already show in most cases.
In addition, the ranking of the opponent lost to (especially if the opponent is much higher-ranked) does not mean that much without the scoreline and adding that would mean more work and an even wider table.
Also, you could argue that the ranking of the last opponent beaten in the tournament (or the highest-ranked opponent beaten during the tournament) is more important than the ranking of the opponent you finally get knocked out by, but trying to incorporate would be even harder.
However, I was intending to have a think at the end of this year about whether that column could be improved without creating significant extra work, with a view to implementing any change at the start of 2012, and I will consider then whether your suggestion (or a variant of it) could be incorporated.

-- Edited by steven on Monday 17th of October 2011 01:54:27 PM

Count Zero · Tennis legend

don't forget the new smileys too :)

indiana · Tennis legend

steven wrote:
Thank you for your comments. I'm always happy to consider suggestions for improvement but I have to admit, I'm getting more reluctant these days to add things that might end up involving significant extra work without a huge benefit.
That reluctance probably stems from slightly regretting taking up a suggestion to put links to all the tournament threads at the bottom of the tables - it has definitely been a worthwhile addition, but it is quite a pain to do every week, especuially when (for obvious reasons) the threads don't all appear on the forum at the same time.

Maybe, Steven, if you are considering adding anything at the end of the year you could also consider removing things that are a bit of a pain to update, and may not be used much at all.

I think I was maybe vaguely previously aware of the tournament links, but it is not something I use. I wonder how much other folk use them

Anyway, as folk often say, but it bears repeating, overall a truly great resource smile

-- Edited by indiana on Monday 17th of October 2011 03:30:38 PM

Mikeduke · County player

steven wrote:
Thank you for your comments. I'm always happy to consider suggestions for improvement but I have to admit, I'm getting more reluctant these days to add things that might end up involving significant extra work without a huge benefit.
That reluctance probably stems from slightly regretting taking up a suggestion to put links to all the tournament threads at the bottom of the tables - it has definitely been a worthwhile addition, but it is quite a pain to do every week, especuially when (for obvious reasons) the threads don't all appear on the forum at the same time.

erm I'm fairly sure that I made that request, if it makes you feel any better I do use the feature every time I use the table!

steven wrote:

Mikeduke wrote:
Is it possible to give the page a title tag so we can see what we are looking at when it is tabbed?
If you mean a title that will appear in the blue bar at the top of the browser, I agree that it would be nice but not being able to do that is a limitation of Excel's 'publish as web page' function, without which I wouldn't have been able to do the tables in the first place.
There are ways to get around it, but they would make it more fiddly to keep republishing the table. Being able to rapidly republish and re-upload when a result has come in but I'm in a hurry is something I don't want to risk losing.

I'm not sure which version of Excel you are using but in 2010 and 2007 there is an option on the save as webpage screen to add in a title. Although if you are constantly saving from a excel to a webpage then this will quickly become an arduous process unless you made a macro to do it for you!

Mikeduke wrote:

I also wondered if it was possible to put the ranking of the player that beat the british player next to their name so we can establish if it was (at the time) a good or bad loss? Although obviously the smiley does indicate this!

This is a feature I've often thought about adding, but again it would involve extra work (perhaps not that much extra work, given that I tend to tweet some of the opponents' rankings nowadays, but it would be very tedious at times - and would make the table even wider!) without adding much beyond what the smileys already show in most cases.

In addition, the ranking of the opponent lost to (especially if the opponent is much higher-ranked) does not mean that much without the scoreline and adding that would mean more work and an even wider table.

Also, you could argue that the ranking of the last opponent beaten in the tournament (or the highest-ranked opponent beaten during the tournament) is more important than the ranking of the opponent you finally get knocked out by, but trying to incorporate would be even harder.

However, I was intending to have a think at the end of this year about whether that column could be improved without creating significant extra work, with a view to implementing any change at the start of 2012, and I will consider then whether your suggestion (or a variant of it) could be incorporated.

-- Edited by steven on Monday 17th of October 2011 01:54:27 PM

I think you have probably shown that you have already thought about all of the updates you possibly could make to the table and I agree that the table is probably getting a bit wide already. I guess the problem is that I don't know which information you are keeping in the spreadsheet and which appears because of the formulas, I think I assumed that as you answered all the q's so fast that there was a big database of information somewhere you were mining for the data and so could just add this in at no extra cost!

I know this question doesn't really get raised very often or is perhaps quite difficult to answer, but where do you see the top 25 table going in the future? Do you think that it will continue in the same format or would you be interested in enhancing it to a new platform? I think the reason I ask is that the forums seem to contain a number of extremely passionate people who are constantly looking for some data on runs, best results, performance in the year and the current format, being in a forum, seems to make it hard to show them

For example, it would be excellent if we were able to record all of the results for the players (as they already get posted on the forums) and then use this to generate the top 25 tables and others. Multiple users could post the results and this would build up an incredible resource. Even better would be the automatic scanning of the draw pdfs or if the itf provided a results feed allowing better use of the data. Then no input would be required at all! I appreciate this is way to complex and not something that is actually wanted, but seeing as I have been thinking about it for ages I thought I would at least write it down!

Anyway I got massively off track, the point I was going to make was that you can always ask people for help. I would be happy to assist with any part of the top 25 table if you ever wanted a week off! And i'm sure that plenty of others would as well, for example you can now publish direct from a google docs spreadsheet to the web, although I have never done this, it's easier than ever to allow collaboration.

Thanks for all the hard work again! :)

steven · Tennis legend

Oops, how did I miss the previous post last week, I wonder ... It's geting a bit late tonight, but I'll make sure I reply to it later in the week.

The reason I came back into this thread was to say that the tables have been updated with the 24 October 2011 rankings.

There are new singles career highs in the top 1000 for Lewis Burton at 658, Liam Broady at 661, George Morgan at 737, Edward Corrie at 747, Oli Golding at 768, Matthew Short at 815 and, last but not least, the only one resulting from a really big move - Richard Gabb moving up 157 to break into the top 1000 at 978.

Sean Thornley leads the new doubles career highs at 194 but he is joined in the top 200 by 'partner in crime' Dave Rice, up 3 to 199.

The Magician Santoro · Top national player

Is there something wrong with the rankings? It has Broady at 648 but minus 3 from last week but he was at 661 last week? Also I think most of the rankings are wrong in there shift from last week so i'm not sure what's happened.