YEC scoreboard for download - ULTIMATE version and YET another error corrected! - TennisForum.com
Reply
 
LinkBack Thread Tools
post #1 of 18 (permalink) Old Nov 9th, 2004, 04:10 PM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,831
                     
YEC scoreboard for download - ULTIMATE version and YET another error corrected!

www.geocities.com/godominique2/YEC.xls

I already posted this in GM but it took me quite a while so I want some attention.

Last edited by GoDominique; Nov 13th, 2004 at 01:49 AM.
GoDominique is offline  
Sponsored Links
Advertisement
 
post #2 of 18 (permalink) Old Nov 9th, 2004, 07:59 PM
Team WTAworld
Senior Member
 
ghosts's Avatar
 
Join Date: Feb 2002
Location: Stuttgart
Posts: 25,925
                     
Nicely done, GoDominique
I already have this file on my desktop

I think you just forgot to delete those numbers on row 39/40/42/44


My #1 in tennis
>> Tsvetana Pironkova <<








ghosts is offline  
post #3 of 18 (permalink) Old Nov 10th, 2004, 12:11 AM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,831
                     
Thanks ghosts. Those numbers are gone, and new features have been added. Check it out.
GoDominique is offline  
 
post #4 of 18 (permalink) Old Nov 10th, 2004, 12:42 AM
country flag kes
Senior Member
 
Join Date: Feb 2002
Location: NSW, Australia
Posts: 521
                     
Great chart GD - thanks for all the work!!

(btw - what does YEC actually stand for?? - i know its a dumb question - but i have no idea - is it 'Year End Championship' or something??? lol )
kes is offline  
post #5 of 18 (permalink) Old Nov 10th, 2004, 09:47 PM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,831
                     
Quote:
Originally Posted by kes
Great chart GD - thanks for all the work!!

(btw - what does YEC actually stand for?? - i know its a dumb question - but i have no idea - is it 'Year End Championship' or something??? lol )
That's correct. And please get the latest version of my chart.
GoDominique is offline  
post #6 of 18 (permalink) Old Nov 10th, 2004, 11:19 PM
GIMME SHELTER
 
Steff_forever's Avatar
 
Join Date: Mar 2003
Location: LA, Germany
Posts: 47,847
                     
Hallo GoDo !

Hab gestern verzweifelt versucht noch schnell aus Deiner Tabelle und einer von meinen auch ne Ranglisten-Tabelle mit aktuellem Stand zu machen. Ist nur so +/- geglückt. Aber mit Deinen "Wenn(zählenwenn..." -Funktionen hast Du einfach alles und Dich selbst übertroffen

Danke, echt klasse !

go
BeLLy_CarO-GArBi_SLoAne

Angelique Kerber | Ashleigh Barty

forgive, you will never reach the level of bimy loyalty for the best that has ever played:
__Steffi forever__

Steff_forever is offline  
post #7 of 18 (permalink) Old Nov 10th, 2004, 11:19 PM
Honorary Admin
 
Ceze's Avatar
 
Join Date: Nov 2004
Location: Here
Posts: 98,235
                     
Thks for the .xls but i found a mistake : in AH15, its "Sharapova" not "Kuznetsova" in the formula. An other thing : are u sure with the initial points (column W when board is empty or column AB), cause that doesnt match with the WTA ranking.
Thanks again for all the work. Very usefull chart.
Ceze is offline  
post #8 of 18 (permalink) Old Nov 11th, 2004, 12:19 AM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,831
                     
Quote:
Originally Posted by Ceze
Thks for the .xls but i found a mistake : in AH15, its "Sharapova" not "Kuznetsova" in the formula. An other thing : are u sure with the initial points (column W when board is empty or column AB), cause that doesnt match with the WTA ranking.
Thanks again for all the work. Very usefull chart.
Regarding AH15: Thanks, I have corrected it.

Regarding the initial points: I am (quite) sure they are correct. Column W takes into account that each YEC player will get 67 points for sure.
BTW: the columns on the right weren't supposed to be visible, I forgot to make them white.
GoDominique is offline  
post #9 of 18 (permalink) Old Nov 11th, 2004, 02:09 AM
Honorary Admin
 
Ceze's Avatar
 
Join Date: Nov 2004
Location: Here
Posts: 98,235
                     
Quote:
Originally Posted by GoDominique
Regarding AH15: Thanks, I have corrected it.

Regarding the initial points: I am (quite) sure they are correct. Column W takes into account that each YEC player will get 67 points for sure.
BTW: the columns on the right weren't supposed to be visible, I forgot to make them white.
I dont want to quibble, but I'd just like to have a correct chart because the n°1 place after the YEC should be a matter of 10 or 20 points. And if my calculations are correct (based on the current ranking on the WTA site), you should have :
Davenport >> 4613
Mauresmo >> 4613
Myskina >> 4262
Kuznetsova >> 3712
Dementieva >> 3512
Sharapova >> 3449
Henin-Hardenne >> 2969
S. Williams >> 2664
Zvonareva >> 2366
I think there are no big differences with yours. Nvm ur chart is very usefull, especially the last version with the ranking projection. Great work !
Ceze is offline  
post #10 of 18 (permalink) Old Nov 11th, 2004, 02:11 AM
Honorary Admin
 
Ceze's Avatar
 
Join Date: Nov 2004
Location: Here
Posts: 98,235
                     
Quote:
Originally Posted by Ceze
I dont want to quibble, but I'd just like to have a correct chart because the n°1 place after the YEC should be a matter of 10 or 20 points. And if my calculations are correct (based on the current ranking on the WTA site), you should have :
Davenport >> 4613
Mauresmo >> 4613
Myskina >> 4262
Kuznetsova >> 3712
Dementieva >> 3512
Sharapova >> 3449
Henin-Hardenne >> 2969
S. Williams >> 2664
Zvonareva >> 2366
I think there are no big differences with yours. Nvm ur chart is very usefull, especially the last version with the ranking projection. Great work !
Of course, without error, that gives :
Davenport >> 4613
Mauresmo >> 4262
Myskina >> 3712
Kuznetsova >> 3512
Dementieva >> 3449
Sharapova >> 2969
S. Williams >> 2664
Zvonareva >> 2366
Sorry ;-)
Ceze is offline  
post #11 of 18 (permalink) Old Nov 11th, 2004, 02:18 AM
Honorary Admin
 
Ceze's Avatar
 
Join Date: Nov 2004
Location: Here
Posts: 98,235
                     
Quote:
Originally Posted by Ceze
Of course, without error, that gives :
Davenport >> 4613
Mauresmo >> 4262
Myskina >> 3712
Kuznetsova >> 3512
Dementieva >> 3449
Sharapova >> 2969
S. Williams >> 2664
Zvonareva >> 2366
Sorry ;-)
I really cant help thinking that Amelie can be n°1 after the Masters... and that Justine is not there

Let's go Amelie !
Ceze is offline  
post #12 of 18 (permalink) Old Nov 11th, 2004, 07:00 AM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,831
                     
Quote:
Originally Posted by Ceze
Of course, without error, that gives :
Davenport >> 4613
Mauresmo >> 4262
Myskina >> 3712
Kuznetsova >> 3512
Dementieva >> 3449
Sharapova >> 2969
S. Williams >> 2664
Zvonareva >> 2366
Sorry ;-)
Those players where points differ, I think you didn't take into account their 17th tournament.

For example, Sharapova's 17th tournament is 50 points. So these points will be OFF when YEC points are added. So Sharapova's total = current points + YEC points MINUS 50.

For Zvonareva, it's a little different. Her 17th tournament is 72 points. So if she doesn't win a match here, her total will be = her old ranking points (2299).
If she wins at least one match, her YEC points will replace her 17th tournament: her total = current points + YEC points MINUS 72.
GoDominique is offline  
post #13 of 18 (permalink) Old Nov 11th, 2004, 10:03 AM
GIMME SHELTER
 
Steff_forever's Avatar
 
Join Date: Mar 2003
Location: LA, Germany
Posts: 47,847
                     
GoDominique:

Shouldn't Dementieva be 4th now and Myskina 3rd ? Alyona won only 1 game. Or does your calculation only sum it up at the end of all 6 matches in a group ?
Positions in Red Group are 1-3-3-1.

Why not
Davenport #1
sWilliams #2
Myskina #3
Dementieva #4 ?????

go
BeLLy_CarO-GArBi_SLoAne

Angelique Kerber | Ashleigh Barty

forgive, you will never reach the level of bimy loyalty for the best that has ever played:
__Steffi forever__

Steff_forever is offline  
post #14 of 18 (permalink) Old Nov 11th, 2004, 10:55 AM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,831
                     
Quote:
Originally Posted by DaniDoki-addict
GoDominique:

Shouldn't Dementieva be 4th now and Myskina 3rd ? Alyona won only 1 game. Or does your calculation only sum it up at the end of all 6 matches in a group ?
Positions in Red Group are 1-3-3-1.

Why not
Davenport #1
sWilliams #2
Myskina #3
Dementieva #4 ?????
Yeah, sets are counted only after all six matches. That's the way it works, but until then the placements are pretty useless anyway.

Games are never counted. I won't add that because the rules aren't 100% clear, so if players are equal in games AND sets, you will get "???".

Then you have to fill in the semifinalist yourself, after that it works again.
GoDominique is offline  
post #15 of 18 (permalink) Old Nov 11th, 2004, 10:57 AM
GIMME SHELTER
 
Steff_forever's Avatar
 
Join Date: Mar 2003
Location: LA, Germany
Posts: 47,847
                     
Quote:
Originally Posted by GoDominique
Yeah, sets are counted only after all six matches. That's the way it works, but until then the placements are pretty useless anyway.

Games are never counted. I won't add that because the rules aren't 100% clear, so if players are equal in games AND sets, you will get "???".

Then you have to fill in the semifinalist yourself, after that it works again.
ok, thanks

go
BeLLy_CarO-GArBi_SLoAne

Angelique Kerber | Ashleigh Barty

forgive, you will never reach the level of bimy loyalty for the best that has ever played:
__Steffi forever__

Steff_forever is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the TennisForum.com forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome