PDA

View Full Version : Sony Ericsson Championships 2007: Excel file with Bartoli up! *bug fixed*


GoDominique
Nov 3rd, 2007, 04:05 PM
Excel file *now with Bartoli* *bug fixed*

This is a new version of the file with Bartoli in it. I can't guarantee it's without flaws as not all info on this situation is available. But it should suffice for now.
The blue numbers for Bartoli are needed for the sheet to work properly. Just ignore them. The standings are correct which is what matters.

http://geocities.com/godominique2/2007ChampionshipsBartoli.xls
or
http://www.yousendit.com/transfer.php?action=download&ufid=8F1557240AFA7623

Fill in the match results as they happen - or as you want them to happen. ;)
Group standings and rankings update automatically.

Any questions/bugs? Post them in here!

GoDominique
Nov 3rd, 2007, 04:06 PM
Group updates

Yellow Group

Henin #1.
Chakvetadze #2.
Bartoli vs. Jankovic will battle for 3rd place.

Red Group

Sharapova vs. Ivanovic for 1st and 2nd place.
Kuznetsova vs. Hantuchova for 3rd and 4th place.

GoDominique
Nov 3rd, 2007, 04:06 PM
Ranking scenarios

Battle for the No.2 ranking

Kuznetsova will finish the year as No.2 if Ivanovic doesn't win the tournament.
Ivanovic will finish the year as No.2 if she wins the tournament.

gumoll
Nov 3rd, 2007, 04:11 PM
was waiting for this :p

Kart
Nov 3rd, 2007, 04:16 PM
I assume this is the one you wanted stuck.

GoDominique
Nov 3rd, 2007, 04:22 PM
I assume this is the one you wanted stuck.
Indeed. Thank you, Sir.

DragonFlame
Nov 3rd, 2007, 04:28 PM
Ok kuznetsova has #2 pretty much in the bag then...

1.If she ends third or fourth jelena needs to make the final to surpass her.
2.If kuzzie makes the semi's jelena needs a win to get #2.
3.Ivanovic has to win it to have a shot at #2. If kuzzie makes the semis or jankovic the final she can't be #2 anymore even if she wins it.

©@®eLess
Nov 3rd, 2007, 04:35 PM
Kuznetsova needs semifinal to secure no.2
Jankovic and Ivanovic get to no.2 only if sveta doesnt qualify and they win the title...

lucky woman Sveta :(

serenus_2k8
Nov 3rd, 2007, 04:36 PM
wow very well made! how clever :D

©@®eLess
Nov 3rd, 2007, 04:50 PM
actually the best thing would be Ana to win it, Jelena to reach the finals, and Kuzzie to bottom the gropu...then it would be fair. Jelena would finish no.2, Ana no.3 and Kuzzie where she belongs with 1 title (and 3 ret en route) at no.4

Babolatpro880
Nov 3rd, 2007, 05:07 PM
I can't use the tables because my version of Excel is too new :sad:

GoDominique
Nov 3rd, 2007, 05:34 PM
I can't use the tables because my version of Excel is too new :sad:
That's weird. I'm also using a newer version but I save this file as Excel 2000 because I thought that should work for everyone.

Which version do you have, and what does it say when you try to open it?

Fired
Nov 3rd, 2007, 05:43 PM
wow great job :worship:

iPatty
Nov 3rd, 2007, 06:36 PM
So basically, Kuznetsova has finished the year as the #2 player in the world. :lol:

Thanks for this, GoDom. Really nice work. :worship:

In The Zone
Nov 3rd, 2007, 06:37 PM
Can you do a Serena ranking scenario? I know she has a shot at # 4.

Babolatpro880
Nov 3rd, 2007, 07:10 PM
That's weird. I'm also using a newer version but I save this file as Excel 2000 because I thought that should work for everyone.

Which version do you have, and what does it say when you try to open it?

I have Office 07 and it says that like I have to save it as Excel Beta or something and then do it?

GoDominique
Nov 3rd, 2007, 07:17 PM
Can you do a Serena ranking scenario? I know she has a shot at # 4.
Actually Serena has a shot at #3 too. :eek:

Will do it later on. :)

GoDominique
Nov 3rd, 2007, 07:23 PM
I have Office 07 and it says that like I have to save it as Excel Beta or something and then do it?
Okay please try this one: http://www.yousendit.com/transfer.php?action=download&ufid=AB6E07713D3B50DF

MrSerenaWilliams
Nov 3rd, 2007, 07:36 PM
Serena has a shot @ #3 if she wins and JJ goes 0-3 :eek:

Her best shot is for #4, but for that she either has to win, or Ana has to go 0-3.

She's essentially a lock @ #5 if she makes it out of RR, which seems VERY do-able.

Cp6uja
Nov 3rd, 2007, 08:28 PM
Is anybody knows tournaments OOP (Shedule)???

TO newbie
Nov 3rd, 2007, 10:29 PM
Tours Name pre-YEC SCORE lowscore QF Semi Final Win
15 HENIN, JUSTINE 5930 6035 6115 6265 6455 6680
19 KUZNETSOVA, SVETLANA 3750 3725 3805 3955 4145 4370
28 JANKOVIC, JELENA 3475 3475 3660 3810 4000 4225
20 IVANOVIC, ANA 3161 3231 3311 3461 3651 3876
11 WILLIAMS, SERENA 2767 2872 2952 3102 3292 3517
13 SHARAPOVA, MARIA 2666 2771 2851 3001 3191 3416
21 CHAKVETADZE, ANNA 2660 2705 2785 2935 3125 3350
26 HANTUCHOVA, DANIELA 2242 2287 2367 2517 2707 2932
Williams Venus 2470 2470 2470 2470 2470 2470


for those of you who are trying to determine end of season scenarios I just thought that I would post all of the possible scores that are possible. I took into account that some of the women will have to take away a tournament since they have more than 17 for the official rankings.
I hope my math is correct.

TO newbie
Nov 3rd, 2007, 10:31 PM
sorry the formating once you post is not that good.
each row is the following players number of tournaments, players name, their score before the YEC, their lowest possible score (if they are the low person in their pool) and then their score if they are not the lowest but don't get to go to the semis, semis, finals and victory.
this allows anyone to contemplate all of the possible scenarios for the end of the year.

Cp6uja
Nov 4th, 2007, 03:18 AM
2007 Year End Rankings


Number of points after Madrid

Player W F SF RR#3 RR#4
Henin 6155 5930 5740 5590 5510
Kuznetsova 4370 4145 3955 3805 3725
Jankovic 4110 3885 3695 3545 3475
Ivanovic 3876 3651 3461 3311 3231
S. Williams 3517 3292 3102 2952 2872
Sharapova 3181 2956 2766 2616 2536
Chakvetadze 3350 3125 2935 2785 2705
Hantuchova 2932 2707 2517 2367 2287



if no more withdraws




Current 2007 "real ranking"

1. Henin
2. Kuznetsova
3. Jankovic
4. Ivanovic
5. S.Williams
6. Chakvetadze
7. Sharapova
8. V.Williams
9. Hantuchova
10. Bartoli




Key facts for eventual Changes after Madrid:


Henin will be #1 in all cases

Jankovic to overtake Kuznetsova - W vs. SF(or worse) ,,, F vs. g3(or worse)

Ivanovic to overtake Kuznetsova - W vs. g3(or worse)
Ivanovic to overtake Jankovic - W vs. SF(or worse) ,,, F vs. g3(or worse)

S.Williams to overtake Jankovic - W vs. g4
S.Williams to overtake Ivanovic - W vs. SF(or worse) ,,, F vs. g4

Chakvetadze to overtake Ivanovic - W vs. g3(or worse)
Chakvetadze to overtake S.Williams - W vs. F(or worse) ,,, F vs. SF(or worse) ,,, SF vs. g4

Sharapova to overtake S.Williams - W vs. SF(or worse) ,,, F vs. g4
Sharapova to overtake Chakvetadze - W vs. F(or worse) ,,, F vs. SF(or worse) ,,, SF vs. g4

Hantuchova to overtake S.Williams - W vs. g4
Hantuchova to overtake Chakvetadze - W vs. g3(or worse) ,,, F vs. g4
Hantuchova to overtake Sharapova - W vs. SF(or worse) ,,, F vs. g3(or worse)
Hantuchova to overtake V.Williams - she need atleast SF

Bartoli will be #10 in all cases

KoOlMaNsEaN
Nov 4th, 2007, 03:33 AM
Can you do one for the TMC as well next week in shanghai

supergrunt
Nov 4th, 2007, 07:05 AM
so when me rena goon play henin?

ZeroSOFInfinity
Nov 4th, 2007, 07:17 AM
Can't wait for the matches to begin :)

Well, last year's "Race for the #1" is a more interesting one, but hey, #2 is still good enough :bounce:

Hashim.
Nov 4th, 2007, 07:40 AM
so kuzy's no.2 position is very much safe :tears:

Renalicious
Nov 4th, 2007, 08:08 AM
Wooo! Serena for #3!! Pull a big one out of your hat Rena :D

Does anyone know where livestream can be found when the games begin?

So Disrespectful
Nov 4th, 2007, 01:05 PM
What happens if Daniela wins it all?

Cp6uja
Nov 4th, 2007, 04:58 PM
2007 Year End Rankings


Number of points after Madrid

Player W F SF RR#3 RR#4
Henin 6155 5930 5740 5590 5510
Kuznetsova 4370 4145 3955 3805 3725
Jankovic 4110 3885 3695 3545 3475
Ivanovic 3876 3651 3461 3311 3231
S. Williams 3517 3292 3102 2952 2872
Sharapova 3181 2956 2766 2616 2536
Chakvetadze 3350 3125 2935 2785 2705
Hantuchova 2932 2707 2517 2367 2287



if no more withdraws




Current 2007 "real ranking"

1. Henin
2. Kuznetsova
3. Jankovic
4. Ivanovic
5. S.Williams
6. Chakvetadze
7. Sharapova
8. V.Williams
9. Hantuchova
10. Bartoli




Key facts for eventual Changes after Madrid:


Henin will be #1 in all cases

Jankovic to overtake Kuznetsova - W vs. SF(or worse) ,,, F vs. g3(or worse)

Ivanovic to overtake Kuznetsova - W vs. g3(or worse)
Ivanovic to overtake Jankovic - W vs. SF(or worse) ,,, F vs. g3(or worse)

S.Williams to overtake Jankovic - W vs. g4
S.Williams to overtake Ivanovic - W vs. SF(or worse) ,,, F vs. g4

Chakvetadze to overtake Ivanovic - W vs. g3(or worse)
Chakvetadze to overtake S.Williams - W vs. F(or worse) ,,, F vs. SF(or worse) ,,, SF vs. g4

Sharapova to overtake S.Williams - W vs. SF(or worse) ,,, F vs. g4
Sharapova to overtake Chakvetadze - W vs. F(or worse) ,,, F vs. SF(or worse) ,,, SF vs. g4

Hantuchova to overtake S.Williams - W vs. g4
Hantuchova to overtake Chakvetadze - W vs. g3(or worse) ,,, F vs. g4
Hantuchova to overtake Sharapova - W vs. SF(or worse) ,,, F vs. g3(or worse)
Hantuchova to overtake V.Williams - she need atleast SF

Bartoli will be #10 in all cases
I forget to present rest of 2007 Year End TOP50 (final rank):

11. Elena Dementieva RUS - 1985 pts
12. Nicole Vaidisova CZE - 1942 pts
13. Tatiana Golovin FRA - 1882 pts
14. Nadia Petrova RUS - 1862 pts
15. Dinara Safina RUS - 1830 pts
16. Patty Schnyder SUI - 1806 pts
17. Shahar Peer ISR - 1675 pts
18. Amelie Mauresmo FRA - 1538 pts
19. Martina Hingis SUI - 1372 pts
20. Agnes Szavay HUN - 1331.5 pts
21. Sybille Bammer AUT - 1323 pts
22. Alona Bondarenko UKR - 1171 pts
23. Vera Zvonareva RUS - 1117 pts
24. Lucie Safarova CZE - 1112 pts
25. Francesca Schiavone ITA - 1046 pts
26. Vika Azarenka BLR - 965.5 pts
27. Agnieszka Radwanska POL - 962 pts
28. Katarina Srebotnik SLO - 961 pts
29. Virginie Razzano FRA - 956 pts
30. Na Li CHN - 937 pts
31. Maria Kirilenko RUS - 928 pts
32. Sania Mirza IND - 921 pts
***33. Julia Vakulenko UKR - 916 pts
34. Michaella Krajicek NED - 864 pts
35. Ana Isabel Medina ESP - 840 pts
36. Mara Santangelo ITA - 824 pts
37. Tathiana Garbin ITA - 805 pts
38. Gisela Dulko ARG - 780 pts
39. Ai Sugiyama JPN - 743 pts
40. Flavia Pennetta ITA - 737 pts
41. Vera Dushevina RUS - 722 pts
42. Tamira Paszek AUT - 718 pts
43. Eleni Daniilidou GRE - 710 pts
44. Kateryna Bondarenko UKR - 695 pts
45. Emilie Loit FRA - 659 pts
46. Shuai Peng CHN - 619 pts
47. Samantha Stosur AUS - 611 pts
48. Meilen Tu USA - 607 pts
49. Olga Govortsova BLR - 592 pts
50. Akiko Morigami JPN - 588 pts


***if beat today Lindsay in Quebec final, Vakulenko will finish year like #26 with 1111 pts.

ZeroSOFInfinity
Nov 5th, 2007, 11:49 AM
Here's an analysis / guide of the WTA Championships from Eurosport:-

WTA Tour - Championships guide

Eurosport - Mon, 05 Nov 09:58:00 2007

Eight players, six days, one trophy. Eurosport.com looks at all of the contenders for this week's WTA Tour Championships.
http://d.yimg.com/eur.yimg.com//ng/sp/eurosport/20071105/09/3752062746.jpg



YELLOW GROUP
(1) Justine Henin (BEL)
Since returning to the WTA Tour after skipping the Australian Open because of her then-ongoing divorce, the Belgian star has put together one of the most dominant campaigns in recent memory. In 13 events this season the world number one has compiled a whopping 58-4 record, won nine titles including the French Open and US Open, and reached at least the semi-finals in every tournament in which she's played. Just for comparison's sake, her counterpart on the ATP Tour (one Roger Federer (http://uk.eurosport.yahoo.com/te/profile/676.html)) has only won seven titles in 2007 with a 63-7 record.

Against Jankovic: 8-0 (2007 record 6-0)
Against Williams: 6-6 (2007 record 3-1)
Against Chakvetadze: 2-0 (2007 record 1-0)

(3) Jelena Jankovic (http://uk.eurosport.yahoo.com/te/profile/2815.html) (SRB)
The world number three Jankovic has arguably been the second-best player on Tour this year, a fact backed up by her number two ranking in the 2007 Sony Ericsson WTA Race. In her break-out season the 22-year-old Serbian has won more matches than anyone on Tour, including Henin, compiling a 72-22 record. Perhaps the only thing that prevented her from claiming more than four titles in 2007 is a horrid record against the Belgian world number one, who beat Jankovic in the semi-finals in Stuttgart, Warsaw, Doha, and the French Open, and in the final in Toronto.

Against Henin: 0-8 (2007 record 0-6)
Against Williams: 2-2 (2007 record 0-1)
Against Chakvetadze: 2-5 (2007 record 1-1)

(5) Serena Williams (http://uk.eurosport.yahoo.com/te/profile/333.html) (USA)
The former world number one had an amazing start to the year winning the Australian Open despite entering with a lowly 81 ranking, but like Jankovic has been thwarted time and again by Henin. Serena won her first clash of the season against the world number one, coming from behind brilliantly to claim an 0-6 7-5 6-3 triumph in the Miami final to collect the second of two trophies in 2007. Since then the two arch-rivals have met in the quarter-finals of the year's last three grand slams at Roland Garros, Wimbledon, and Flushing Meadows. Each time, Serena's tournament has ended in frustration. It begs the question, what would have happened had Justine played in Melbourne?

Against Henin: 6-6 (2007 record 1-3)
Against Jankovic: 2-2 (2007 record 1-0)
Against Chakvetadze: 0-0

(7) Anna Chakvetadze (http://uk.eurosport.yahoo.com/te/profile/3158.html) (RUS)
The 20-year-old Muscovite has had her best season on Tour and the second-best of the three Russians playing in Madrid. Chakvetadze's success is largely attributable to a stunning summer hardcourt campaign. Two of her four 2007 titles came during the North American summer in Cincinnati and Stanford, while Chakvetadze also made her grand slam semi-final debut at the US Open. Though she has struggled to a 2-4 record in four events since Flushing Meadows, Chakvetadze could play the role of spoiler in Madrid, especially against Jankovic.

Against Henin: 0-2 (2007 record 0-1)
Against Jankovic: 5-2 (2007 record 1-1)
Against Williams: 0-0


RED GROUP
(2) Svetlana Kuznetsova (http://uk.eurosport.yahoo.com/te/profile/500000000002890.html) (RUS)
The top seeded player in the weaker of the two group is by no means the section's star, despite being one of the most consistent performers on the circuit this season. In 18 tournaments the 2004 US Open champion has reached the quarter-finals 15 times, including six finals appearances. Kuznetsova's problem is her 1-5 record in those finals, including a 6-1 6-3 humiliation at the hands of Henin in the last round of the Flushing Meadows.

Against Ivanovic: 1-3 (2007 record 0-2)
Against Sharapova: 3-3 (2007 record 0-0)
Against Hantuchova: 6-3 (2007 record 2-1)

(4) Ana Ivanovic (http://uk.eurosport.yahoo.com/te/profile/3196.html) (SRB)
Ivanovic has arguably made the biggest splash on the Tour this season, causing even greater waves than compatriot and world number three Jankovic. The Serbian number two, who turns 20-years-old on the opening day of the Championships, has made a name for herself as the WTA Tour's next bright young star after winning three titles in 2007, reaching the semi-finals at Wimbledon, and making it to the last round of the French Open. Though she was utterly obliterated 6-1 6-2 by the defending champion in the Roland Garros final, Ivanovic did have one impressive game against Henin breaking the world number one in the first game of the match.

Against Kuznetsova: 3-1 (2007 record 2-0)
Against Sharapova: 2-1 (2007 record 2-0)
Against Hantuchova: 1-1 (2007 record 1-1)

(6) Maria Sharapova (http://uk.eurosport.yahoo.com/te/profile/1500000000003013.html) (RUS)
The Russian superstar began 2007 on a high, claiming hold of the world number one ranking despite losing to Serena Williams in the Australian Open final. Everything has gone downhill since, as a string of injuries have seen the 2006 US Open champion tumble down the rankings to sixth. Despite a career-best semi-finals showing at Roland Garros, Sharapova lost in the fourth round at Wimbledon and saw her title defence at Flushing Meadows come to a crashing halt against Polish teenager (and likely future Madrid challenger) Agnieszka Radwanska (http://uk.eurosport.yahoo.com/te/profile/3359.html) in round three. In addition to fitness issues over her season-long shoulder injury, Sharapova could be a bit rusty having played just one event (an opening loss at her home-tournament in Moscow) since the US Open debacle.

Against Kuznetsova: 3-3 (2007 record 0-0)
Against Ivanovic: 1-2 (2007 record 0-2)
Against Hantuchova: 5-1 (2007 record 0-0)

(8) Daniela Hantuchova (http://uk.eurosport.yahoo.com/te/profile/2418.html) (SVK)
The Slovakian number one is clearly the straggler in this field, having earned the eighth and final berth after Wimbledon champion Venus Williams (http://uk.eurosport.yahoo.com/te/profile/334.html) withdrew from Madrid with an injury. The Slovakian number one is the only one of the eight challengers never to have reached at least a grand slam semi-final, and she hasn't reached the quarter-finals of a major since 2003. That being said, Hantuchova has been in fine late-season form reaching three finals and winning one title in the last two months. The highlight of her year was a title in March at Indian Wells where she beat Martina Hingis (http://uk.eurosport.yahoo.com/te/profile/227.html) in the fourth round and Kuznetsova in the final.

Against Kuznetsova: 3-6 (2007 record 1-2)
Against Ivanovic: 1-1 (2007 record 1-1)
Against Sharapova: 1-4 (2007 record 0-0)

MrSerenaWilliams
Nov 5th, 2007, 03:46 PM
Here's an analysis / guide of the WTA Championships from Eurosport:-

WTA Tour - Championships guide

(5) Serena Williams (http://uk.eurosport.yahoo.com/te/profile/333.html) (USA)
The former world number one had an amazing start to the year winning the Australian Open despite entering with a lowly 81 ranking, but like Jankovic has been thwarted time and again by Henin. Serena won her first clash of the season against the world number one, coming from behind brilliantly to claim an 0-6 7-5 6-3 triumph in the Miami final to collect the second of two trophies in 2007. Since then the two arch-rivals have met in the quarter-finals of the year's last three grand slams at Roland Garros, Wimbledon, and Flushing Meadows. Each time, Serena's tournament has ended in frustration. It begs the question, what would have happened had Justine played in Melbourne?

Against Henin: 6-6 (2007 record 1-3)
Against Jankovic: 2-2 (2007 record 1-0)
Against Chakvetadze: 0-0

are you serious?! :o

the same thing that happened in Miami

BuTtErFrEnA
Nov 5th, 2007, 05:14 PM
are you serious?! :o

the same thing that happened in Miami

LOL i always wonder why people ask that....did they see how she played there?? totally different from RG and US open...

Kim's_fan_4ever
Nov 5th, 2007, 05:15 PM
(8) Daniela Hantuchova (http://uk.eurosport.yahoo.com/te/profile/2418.html) (SVK)
The Slovakian number one is clearly the straggler in this field, having earned the eighth and final berth after Wimbledon champion Venus Williams (http://uk.eurosport.yahoo.com/te/profile/334.html) withdrew from Madrid with an injury. The Slovakian number one is the only one of the eight challengers never to have reached at least a grand slam semi-final, and she hasn't reached the quarter-finals of a major since 2003. That being said, Hantuchova has been in fine late-season form reaching three finals and winning one title in the last two months. The highlight of her year was a title in March at Indian Wells where she beat Martina Hingis (http://uk.eurosport.yahoo.com/te/profile/227.html) in the fourth round and Kuznetsova in the final.


Get it together Eurosport :help: It's Maria who has earned her place because of Venus' withdrawal...

BuTtErFrEnA
Nov 5th, 2007, 05:22 PM
Get it together Eurosport :help: It's Maria who has earned her place because of Venus' withdrawal...

it floats their boats so leave them to their imagination...how ever wrong it may be lol

DragonFlame
Nov 6th, 2007, 11:57 PM
update time, day 1 of yec complete!:bounce:

mckyle.
Nov 7th, 2007, 03:30 AM
There's not much to update yet :o

GoDominique
Nov 7th, 2007, 04:10 AM
There's not much to update yet :o
Right.

After Day 2 I will.

serenus_2k8
Nov 7th, 2007, 09:29 AM
what do you need to update? cant we do scores ourselves??? :S

GoDominique
Nov 7th, 2007, 09:36 AM
what do you need to update? cant we do scores ourselves??? :S
The scenarios. ;) Of course you can do the scores by yourself.

GoDominique
Nov 7th, 2007, 09:40 AM
New file is up. :)

Sorry to all Excel 2007 users, the file does not seem to work for you, which is my fault. :o But right now I am not able to fix that. Maybe later this week, or else ... next year. :sad:

serenus_2k8
Nov 7th, 2007, 11:40 AM
I dont see the difference... other than the scores are filled in!

DragonFlame
Nov 7th, 2007, 06:49 PM
Justine is almost secure of her SFspot right, taking a set from serena would close the deal? Although she probably won't even need that..

BuTtErFrEnA
Nov 7th, 2007, 06:54 PM
she just needs serena to win i think

LDF
Nov 7th, 2007, 08:03 PM
I have a question:

Anna just beat Serena 6-4 ret. Now, will that go down as a one set to love victory, or will it be two sets? Because if it's the former, surely Anna will be at a disadvantage :shrug:

GoDominique
Nov 7th, 2007, 08:09 PM
2-0 sets.

Serena is a **** BTW. :)

TheBoiledEgg
Nov 7th, 2007, 08:14 PM
Anna gets a 6-4 6-0 win if im not mistaken

loppy
Nov 7th, 2007, 08:14 PM
Serena has retired and is now out of the tournament.

How does it work for Marion? Coming in with a one loss disadvantage?

GoDominique
Nov 7th, 2007, 08:15 PM
Anna gets a 6-4 6-0 win if im not mistaken
Do you know if Serena still gets the 105 points for playing the YEC?

Lady
Nov 7th, 2007, 08:19 PM
Serena has retired and is now out of the tournament.

How does it work for Marion? Coming in with a one loss disadvantage?

What loss? She hasn't lost anything yet.

TO newbie
Nov 7th, 2007, 08:20 PM
Serena has retired and is now out of the tournament.

How does it work for Marion? Coming in with a one loss disadvantage?

Can you retire from a match and still play again later in the tournament ??

cecilija
Nov 7th, 2007, 08:22 PM
Serena has retired and is now out of the tournament.

How does it work for Marion? Coming in with a one loss disadvantage?

No, she gets to play two matches, I think.

TheBoiledEgg
Nov 7th, 2007, 08:25 PM
Do you know if Serena still gets the 105 points for playing the YEC?

she doesnt get all 105 now but a fraction
which i havent got table of, last yr i had info on that.

TheBoiledEgg
Nov 7th, 2007, 08:26 PM
Serena has retired and is now out of the tournament.

How does it work for Marion? Coming in with a one loss disadvantage?

Marion starts at 0-0
but can only play 2 matches

if she is tied with any player, player who's played most matches gets thru
so Marion is basically doomed, unless she wins both
and jankovic beats Anna C.

GoDominique
Nov 7th, 2007, 08:32 PM
she doesnt get all 105 now but a fraction
which i havent got table of, last yr i had info on that.
Thanks. This messes up the rankings though. :fiery: If you could find the info that would be great.

TheBoiledEgg
Nov 7th, 2007, 08:34 PM
Thanks. This messes up the rankings though. :fiery: If you could find the info that would be great.

the new person who does ranks is of no help
dunno where Liz has gone :confused:

GoDominique
Nov 7th, 2007, 08:40 PM
so Marion is basically doomed, unless she wins both
and jankovic beats Anna C.
If that happens, I assume Justine is still no.1 in the group although h2h is in favour of Marion, right?

No problem with the ranks, I'll pick a random number. :p

GoDominique
Nov 7th, 2007, 09:27 PM
Okay this is what I've done:

Serena gets 35 points.
Bartoli gets 70 points if she finishes 4th, else she gets regular points.
The blue numbers in the table (for Bartoli) are necessary so that the thing works. I have counted Serena's loss as hers and added two more lost sets so in a 3-way tie she always finishes last.
Justine finishes 1st in any case.

KoOlMaNsEaN
Nov 7th, 2007, 09:40 PM
I'll just redownload the sheet after the day is done. this is sooo confusing

DragonFlame
Nov 7th, 2007, 10:00 PM
Every source other then TBE is stating serena can still play if she wants too.(not that she will) Eurosportcommentary just said it now as well.

GoDominique
Nov 7th, 2007, 10:51 PM
I have made a first update on the groups in post #2.

Tennace
Nov 7th, 2007, 10:58 PM
So even if Hantuchova beats Kuznetsova and Sharapova beats Kuznetsova and Ivanovic beats Kuznetsova Dani cant make the semis? With Ana 3-0, and Kuznetsova, Sharapova, and Hantuchova 1-2?

GoDominique
Nov 7th, 2007, 11:04 PM
So even if Hantuchova beats Kuznetsova and Sharapova beats Kuznetsova and Ivanovic beats Kuznetsova Dani cant make the semis? With Ana 3-0, and Kuznetsova, Sharapova, and Hantuchova 1-2?
No, because Daniela will never have the best set record from the three players who are tied in wins.

DragonFlame
Nov 7th, 2007, 11:09 PM
Exactly, the kuzzie-ana second set that kuznetsova won was an important 1. Daniela should have converted a setpoint against ana to still have a chance.

Daniela's out.

GoDominique
Nov 7th, 2007, 11:10 PM
Yeah she needed a set at least.

MakarovaFan
Nov 7th, 2007, 11:15 PM
So even if Hantuchova beats Kuznetsova and Sharapova beats Kuznetsova and Ivanovic beats Kuznetsova Dani cant make the semis? With Ana 3-0, and Kuznetsova, Sharapova, and Hantuchova 1-2?

Umm if sharapova BEATS Kuznetsova then she's not 1-2!!!! she's 2-1....unless you mean Kuznetsova beats Sharapova

DAVAJ MKirilenko
Nov 7th, 2007, 11:54 PM
Do you know what can be confusing?
If Sveta beats Maria in 3
Then Sveta beats Daniela in 2
And Maria beats Ana in 3

Then I guess the matches against Daniela won't count?
Ana has +5 against Sveta, so then I must look good.

DragonFlame
Nov 8th, 2007, 12:04 AM
Do you know what can be confusing?
If Sveta beats Maria in 3
Then Sveta beats Daniela in 2
And Maria beats Ana in 3

If that happens(all of them ending up with a 2-1 record and 5-3 record) they will look at games won/lost.:o

GoDominique
Nov 8th, 2007, 12:11 AM
Do you know what can be confusing?
If Sveta beats Maria in 3
Then Sveta beats Daniela in 2
And Maria beats Ana in 3

Then I guess the matches against Daniela won't count?
Ana has +5 against Sveta, so then I must look good.
No, it's not as in football. In tennis they always count ALL the matches.

jerk-in-the-box
Nov 8th, 2007, 12:12 AM
i thought head to head would at least be a factor before going into sets to decide who advances:shrug:

DAVAJ MKirilenko
Nov 8th, 2007, 12:20 AM
i thought head to head would at least be a factor before going into sets to decide who advances:shrug:

That's why my question about taking the Daniela matches of.
If the Daniela matches count as well, then it's also good for Ana.
Probably Ana will qualify before she has to play. It must be really weird if she has not enough of 1 set.

DragonFlame
Nov 8th, 2007, 12:28 AM
i thought head to head would at least be a factor before going into sets to decide who advances:shrug:

yes it is, but not if there is a 3-way tie. (like ana beating kuzie, kuzie beating maria, maria beating ana). Then they will look at sets and if those are the same as well( All could have a 5-3 setrecord) they will look at games.

GoDominique
Nov 8th, 2007, 12:31 AM
If Ana just wins a set against Maria she's pretty much through, unless the final score is something like 7-5 1-6 1-6.
But let's wait for tomorrow's match, if Maria wins then it's all moot.

DragonFlame
Nov 8th, 2007, 12:36 AM
But let's wait for tomorrow's match, if Maria wins then it's all moot.

Yeah, that will probably happen anyway:lol:

1000
Nov 8th, 2007, 12:39 AM
Has Justine officially qualified yet?

DragonFlame
Nov 8th, 2007, 12:42 AM
Has Justine officially qualified yet?

if serena still plays no, if she withdraws yes. If justine wins a set tomorrow she officially qualifies as well.

Cp6uja
Nov 8th, 2007, 12:59 AM
Excel file *now with Bartoli* Check your file again... you give Bartoli in default negative 0-4 set record before her first match.

ZeroSOFInfinity
Nov 8th, 2007, 01:01 AM
It's official - Serena has withdrawn from the YEC.

Thursday, November 8, 2007
From 18.00hrs
1. Kuznetsova vs. Sharapova
2. Henin vs. Bartoli* (NB 20.00hrs)
3. Jankovic vs. Chakvetadze

* Bartoli replaces S.Williams (left patella femoral inflammation)

KoOlMaNsEaN
Nov 8th, 2007, 01:05 AM
GoDomi could you PLEASE make an excel file for the Tennis Masters Cup

NeeemZ
Nov 8th, 2007, 01:06 AM
Is Bartoli still eligible to progress through to the semi finals?

DragonFlame
Nov 8th, 2007, 01:13 AM
Is Bartoli still eligible to progress through to the semi finals?

Again: If she wins her 2 matches and jelena beats anna, Yes she will progress.:) That's the only scenario in which it is possible.

Okay so if serena withdrew, justine just qualified.

DAVAJ MKirilenko
Nov 8th, 2007, 01:18 AM
Okay so if serena withdrawed, justine just qualified.

Which also means that Ana is AT LEAST number 5 in the end of this year.

GoDominique
Nov 8th, 2007, 01:30 AM
Check your file again... you give Bartoli in default negative 0-4 set record before her first match.
Yes. I know.

GoDominique
Nov 8th, 2007, 02:08 AM
There was a minor error in the file because of Serena's withdrawal. Please get the latest version. :)

And I have added the Yellow Group scenarios. Pretty simple. ;)

DragonFlame
Nov 8th, 2007, 02:20 AM
Pretty simple. ;)

Yay! :yeah: Now we hopefully won't have to repeat ourselves so much anymore :lol:

In The Zone
Nov 8th, 2007, 05:41 AM
How is Daniela officially out? If Sveta beats Maria and Daniela beats Maria, and Ana beats Maria, all very likely -- Sveta, Maria and Daniela are all 1-2. How can we rule Daniela 100% out of the 2nd spot?

EDIT: Sveta took a set off Ana. There is Sveta's advantage right there.

Foot's Fingers
Nov 8th, 2007, 08:17 AM
How is Daniela officially out? If Sveta beats Maria and Daniela beats Maria, and Ana beats Maria, all very likely -- Sveta, Maria and Daniela are all 1-2. How can we rule Daniela 100% out of the 2nd spot?

EDIT: Sveta took a set off Ana. There is Sveta's advantage right there.

you mean beats Sveta i beleive....

Renalicious
Nov 8th, 2007, 12:47 PM
Wow, Bartoli has an extremely tough task in front of her. Please win against Chakvetadze then Jelena. :sad: GL against Justine and Jankovic, Marion.

ZeroSOFInfinity
Nov 8th, 2007, 01:40 PM
How is Daniela officially out? If Sveta beats Maria and Daniela beats Maria, and Ana beats Maria, all very likely -- Sveta, Maria and Daniela are all 1-2. How can we rule Daniela 100% out of the 2nd spot?

EDIT: Sveta took a set off Ana. There is Sveta's advantage right there.

This was taken on Eurosport's website on the Ana-Daniela match....

"After losing to both Sharapova and Ivanovic, Hantuchova - whose only other appearance at the Championships was in 2002 - is now eliminated from contention for one of the two semi-final berths out of the group."

ViennaCalling
Nov 8th, 2007, 08:03 PM
That's the most boring YEC i've ever seen so far :help:

Henin will win without dropping a set :yawn: Very, very bad for Tennis.

John.
Nov 8th, 2007, 08:09 PM
That's the most boring YEC i've ever seen so far :help:

Henin will win without dropping a set :yawn: Very, very bad for Tennis.

Unfortunately, I can't help but agree with you.

Noone there can match Juju..

Poova
Nov 8th, 2007, 09:48 PM
If Anna wins today the only match that will even mean anything tomorrow is Ana-Maria, and that's only to see who will finish top. :lol:

I doubt I'll bother watching the matches tomorrow...

Renalicious
Nov 8th, 2007, 10:47 PM
That's the most boring YEC i've ever seen so far :help:

Henin will win without dropping a set :yawn: Very, very bad for Tennis.

No she won't. GO MASHA.

GoDominique
Nov 8th, 2007, 11:09 PM
Updated.

Of course, the first time we have this thread the event is so boring that the thread wasn't even necessary. :lol: :mad:

gumoll
Nov 8th, 2007, 11:59 PM
sad but true

Cp6uja
Nov 9th, 2007, 12:12 AM
Here is all possible scenarios (after today's matches):

2007 Year End Rankings


Number of points after Madrid

Player W F SF g3 g4
Henin 6155 5930 5740
Kuznetsova 3805 3725
Jankovic 3545 3475
Ivanovic 3876 3651 3461
S. Williams 2802
Sharapova 3181 2956 2766
Chakvetadze 3350 3125 2935
Hantuchova 2367 2287
Bartoli 2226 2111





update Nov 8.




Current 2007 "real ranking"

1. Henin
2. Kuznetsova (#2 or #3)
3. Jankovic (#3 or #4)
4. Ivanovic (#4 or #3 or #4)
5. Chakvetadze (#5 or #6)
6. S.Williams (#6 or #7)
7. Sharapova (#7 or #6 or #5)
8. V.Williams
9. Hantuchova
10. Bartoli

***BLUE = FINAL RANK



Key facts about eventual Changes after Madrid:


Henin will be #1 in all cases

Ivanovic to overtake Kuznetsova - need YEC title
Ivanovic to overtake Jankovic - need atleast final

Sharapova to overtake S.Williams - need atleast final
Sharapova to overtake Chakvetadze - W vs. F(or worse) ,,, F vs. SF

Venus will be #8, Hantuchova #9 and Bartoli will be #10 in all cases
Rest of 2007 Year End TOP50 (final rank):

11. Elena Dementieva RUS - 1985 pts
12. Nicole Vaidisova CZE - 1942 pts
13. Tatiana Golovin FRA - 1882 pts
14. Nadia Petrova RUS - 1862 pts
15. Dinara Safina RUS - 1830 pts
16. Patty Schnyder SUI - 1806 pts
17. Shahar Peer ISR - 1675 pts
18. Amelie Mauresmo FRA - 1538 pts
19. Martina Hingis SUI - 1372 pts
20. Agnes Szavay HUN - 1331.5 pts
21. Sybille Bammer AUT - 1323 pts
22. Alona Bondarenko UKR - 1171 pts
23. Vera Zvonareva RUS - 1117 pts
24. Lucie Safarova CZE - 1112 pts
25. Francesca Schiavone ITA - 1046 pts
26. Vika Azarenka BLR - 965.5 pts
27. Agnieszka Radwanska POL - 962 pts
28. Katarina Srebotnik SLO - 961 pts
29. Virginie Razzano FRA - 956 pts
30. Na Li CHN - 937 pts
31. Maria Kirilenko RUS - 928 pts
32. Sania Mirza IND - 921 pts
33. Julia Vakulenko UKR - 916 pts
34. Michaella Krajicek NED - 864 pts
35. Ana Isabel Medina ESP - 840 pts
36. Mara Santangelo ITA - 824 pts
37. Tathiana Garbin ITA - 805 pts
38. Gisela Dulko ARG - 780 pts
39. Ai Sugiyama JPN - 743 pts
40. Flavia Pennetta ITA - 737 pts
41. Vera Dushevina RUS - 722 pts
42. Tamira Paszek AUT - 718 pts
43. Eleni Daniilidou GRE - 710 pts
44. Kateryna Bondarenko UKR - 695 pts
45. Emilie Loit FRA - 659 pts
46. Shuai Peng CHN - 619 pts
47. Samantha Stosur AUS - 611 pts
48. Meilen Tu USA - 607 pts
49. Olga Govortsova BLR - 592 pts
50. Akiko Morigami JPN - 588 pts

DragonFlame
Nov 9th, 2007, 12:28 AM
Ivanovic can become #3 and serbian #1 if she makes the final:bounce: Lets hope she meets chackvetadze in the semi and reaches the final!

Giovanna
Nov 9th, 2007, 12:44 AM
If Maria lost tomorrow is she going to play against Chakvetadze??

ViennaCalling
Nov 9th, 2007, 07:39 AM
If Maria lost tomorrow is she going to play against Chakvetadze??

Nope, if she loses tomorrow she is 2nd in her group and has to play in semis against Henin.

Jorn
Nov 9th, 2007, 06:18 PM
Marion 'wins' and finish 3rd, Anybody know how much points and prize money she gets?

cometz9
Nov 9th, 2007, 07:29 PM
Marion 'wins' and finish 3rd, Anybody know how much points and prize money she gets?

from Yahoo! Sports:

"Williams took home $43,333 because she completed one of three group matches before being replaced. Bartoli made $86,667 for finishing third in the group."

Giovanna
Nov 9th, 2007, 07:45 PM
Nope, if she loses tomorrow she is 2nd in her group and has to play in semis against Henin.

Thanks for the information

Cp6uja
Nov 10th, 2007, 12:28 AM
YER ENDING CALCULATIONS AFTER TODAYS MATCHES:

2007 Year End Rankings


Number of points after Madrid

Player W F SF g3 g4
Henin 6155 5930 5740
Kuznetsova 3725
Jankovic 3475
Ivanovic 3876 3651 3461
S. Williams 2802
Sharapova 3181 2956 2766
Chakvetadze 3350 3125 2935
Hantuchova 2367
Bartoli 2226



update Nov 9.




Current 2007 "real ranking"

1. Henin (#1)
2. Kuznetsova (#2 or #3)
3. Jankovic (#3 or #4)
4. Ivanovic (#4 or #3 or #2)
5. Chakvetadze (#5 or #6)
6. S.Williams (#6 or #7)
7. Sharapova (#7 or #6 or #5)
8. V.Williams (#8)
9. Hantuchova (#9)
10. Bartoli (#10)

***BLUE = FINAL RANK



Key facts about eventual Changes after Madrid:


Henin will be #1 in all cases

Ivanovic to overtake Kuznetsova - need YEC title
Ivanovic to overtake Jankovic - need YEC final

Sharapova to overtake S.Williams and Chakvetadze - need YEC final

Venus will be #8, Hantuchova #9 and Bartoli will be #10 in all cases

NeeemZ
Nov 10th, 2007, 04:37 AM
from Yahoo! Sports:

"Williams took home $43,333 because she completed one of three group matches before being replaced. Bartoli made $86,667 for finishing third in the group."

So, Serena and Marion split their earnings for the amount of matches they played. Third place received $130,000 and fourth received $100,000, which means that Marion's win against Jelena allowed Serena to pocket an extra 10k! Nice!!

saniapower
Nov 10th, 2007, 10:32 AM
That's the most boring YEC i've ever seen so far :help:

Henin will win without dropping a set :yawn: Very, very bad for Tennis.

Not boring at all! Most interesting and glamourous lineup. We have seen some great tennis.
Don't forget Sharapova so easily! She is the biggest obstacle for Henin. The final will be between Maria v Henin and i think Maria will win the battle.

loppy
Nov 10th, 2007, 02:12 PM
So, Serena and Marion split their earnings for the amount of matches they played. Third place received $130,000 and fourth received $100,000, which means that Marion's win against Jelena allowed Serena to pocket an extra 10k! Nice!!

Does anyone know if they also split Marion's 3rd place ranking points?

Jorn
Nov 10th, 2007, 02:53 PM
In TBEs updateing Ranking Marion got all the 3rd place 185 Points.

The danish Eurosport Commentator said she got 96K in prize money

Cp6uja
Nov 10th, 2007, 08:01 PM
2007 - Year End Ranking



2007
RANK (2006) PLAYER POINTS

1. (1) Justine Henin (BEL,1982) 6155 pts
2. (4) Svetlana Kuznetsova (RUS,1985) 3725 pts
3. (12) Jelena Jankovic (SRB,1985) 3475 pts
4. (14) Ana Ivanovic (SRB,1987) 3461 pts
5. (2) Maria Sharapova (RUS,1987) 2956 pts
6. (13) Anna Chakvetadze (RUS,1987) 2935 pts
7. (95) Serena Williams (USA,1981) 2802 pts
8. (48) Venus Williams (USA,1980) 2470 pts
9. (18) Daniela Hantuchova (SVK,1983) 2367 pts
10. (17) Marion Bartoli (FRA,1984) 2226 pts

11. (8) Elena Dementieva (RUS,1981) 1985 pts
12. (10) Nicole Vaidisova (CZE,1989) 1942 pts
13. (22) Tatiana Golovin (FRA,1988) 1882 pts
14. (6) Nadia Petrova (RUS,1982) 1862 pts
15. (11) Dinara Safina (RUS,1986) 1830 pts
16. (9) Patty Schnyder (SUI,1978) 1806 pts
17. (20) Shahar Peer (ISR,1987) 1675 pts
18. (3) Amelie Mauresmo (FRA,1979) 1538 pts
19. (7) Martina Hingis (SUI,1980) 1372 pts
20. (207) Agnes Szavay (HUN,1988) 1331.5 pts
21. (53) Sybille Bammer (AUT,1980) 1323 pts
22. (32) Alona Bondarenko (UKR,1984) 1171 pts
23. (24) Vera Zvonareva (RUS,1984) 1117 pts
24. (41) Lucie Safarova (CZE,1987) 1112 pts
25. (15) Francesca Schiavone (ITA,1980) 1046 pts
26. (57) Agnieszka Radwanska (POL,1989) 962 pts
27. (23) Katarina Srebotnik (SLO,1981) 961 pts
28. (87) Virginie Razzano (FRA,1983) 956 pts
29. (21) Na Li (CHN,1982) 937 pts
30. (92) Vika Azarenka (BLR,1989) 928 pts
31. (30) Maria Kirilenko (RUS,1987) 928 pts
32. (66) Sania Mirza (IND,1986) 921 pts
33. (120) Julia Vakulenko (UKR,1983) 916 pts
34. (35) Michaella Krajicek (NED,1989) 864 pts
35. (27) Ana Isabel Medina (ESP,1982) 840 pts
36. (31) Mara Santangelo (ITA,1981) 824 pts
37. (40) Tathiana Garbin (ITA,1977) 805 pts
38. (61) Gisela Dulko (ARG,1985) 780 pts
39. (26) Ai Sugiyama (JPN,1975) 743 pts
40. (28) Flavia Pennetta (ITA,1982) 737 pts
41. (97) Vera Dushevina (RUS,1986) 722 pts
42. (181) Tamira Paszek (AUT,1990) 718 pts
43. (36) Eleni Daniilidou (GRE,1982) 710 pts
44. (118) Kateryna Bondarenko (UKR,1986) 695 pts
45. (58) Emilie Loit (FRA,1979) 659 pts
46. (56) Shuai Peng (CHN,1986) 619 pts
47. (29) Samantha Stosur (AUS,1984) 611 pts
48. (89) Meilen Tu (USA,1978) 607 pts
49. (334) Olga Govortsova (BLR,1988) 592 pts
50. (85) Akiko Morigami (JPN,1980) 588 pts
51. (123) Karin Knapp (ITA,1987) 574.5 pts
52. (156) Dominika Cibulkova (SVK,1989) 559 pts
53. (37) Meghann Shaughnessy (USA,1979) 541 pts
54. (34) Martina Muller (GER,1982) 540 pts
55. (44) Elena Vesnina (RUS,1986) 524 pts
56. (311) Ioana-Raluca Olaru (ROU,1989) 521 pts
57. (189) Alize Cornet (FRA,1990) 506 pts
58. (197) Pauline Parmentier (FRA,1986) 505 pts
59. (163) Alicia Molik (AUS,1981) 505 pts
60. (166) Zi Yan (CHN,1984) 498 pts
61. (170) Yvonne Meusburger (AUT,1983) 493 pts
62. (125) Klara Zakopalova (CZE,1982) 478.5 pts
63. (237) Caroline Wozniacki (DEN,1990) 470 pts
64. (102) Roberta Vinci (ITA,1983) 470 pts
65. (70) Laura Granville (USA,1981) 460 pts
66. (42) Elena Likhovtseva (RUS,1975) 458 pts
67. (96) Yung-Jan Chan (TPE,1989) 450 pts
68. (59) Aiko Nakamura (JPN,1983) 445 pts
69. (51) Nathalie Dechy (FRA,1979) 437 pts
70. (171) Sara Errani (ITA,1987) 436 pts
71. (78) Nicole Pratt (AUS,1973) 433 pts
72. (52) L. Dominguez-Lino (ESP,1981) 433 pts
73. (25) Lindsay Davenport (USA,1976) 430 pts
74. (101) Milagros Sequera (VEN,1980) 424 pts
75. (64) Kaia Kanepi (EST,1985) 421 pts
76. (76) Camille Pin (FRA,1981) 407 pts
77. (172) Casey Dellacqua (AUS,1985) 402 pts
78. (82) Anastassia Rodionova (RUS,1982) 397 pts
79. (49) Aravane Rezai (FRA,1987) 394 pts
80. (73) Jill Craybas (USA,1974) 391 pts
etc... etc...