Sony Ericsson Championships 2007: Excel file with Bartoli up! *bug fixed* - TennisForum.com

Reply
 
LinkBack Thread Tools
post #1 of 108 (permalink) Old Nov 3rd, 2007, 03:05 PM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,036
                     
Exclamation Sony Ericsson Championships 2007: Excel file with Bartoli up! *bug fixed*

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/20...ipsBartoli.xls
or
http://www.yousendit.com/transfer.ph...1557240AFA7623

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!

Last edited by GoDominique; Nov 8th, 2007 at 01:06 AM.
GoDominique is offline  
Sponsored Links
Advertisement
 
post #2 of 108 (permalink) Old Nov 3rd, 2007, 03:06 PM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,036
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

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.

Last edited by GoDominique; Nov 8th, 2007 at 10:07 PM.
GoDominique is offline  
post #3 of 108 (permalink) Old Nov 3rd, 2007, 03:06 PM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,036
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

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.

Last edited by GoDominique; Nov 8th, 2007 at 10:08 PM.
GoDominique is offline  
post #4 of 108 (permalink) Old Nov 3rd, 2007, 03:11 PM
Sad Member
 
gumoll's Avatar
 
Join Date: May 2005
Posts: 54,034
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

was waiting for this

gumoll is offline  
post #5 of 108 (permalink) Old Nov 3rd, 2007, 03:16 PM
 
Join Date: Nov 2001
Posts: 27,279
 
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

I assume this is the one you wanted stuck.
Kart is offline  
post #6 of 108 (permalink) Old Nov 3rd, 2007, 03:22 PM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,036
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

Quote:
Originally Posted by Kart View Post
I assume this is the one you wanted stuck.
Indeed. Thank you, Sir.
GoDominique is offline  
post #7 of 108 (permalink) Old Nov 3rd, 2007, 03:28 PM
Team WTAworld
Senior Member
 
DragonFlame's Avatar
 
Join Date: Jul 2005
Location: Groningen
Posts: 15,529
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

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.

All-Time-Great
Justine Henin

Elena, thank you for all the joy you gave me, you will always remain in my mind.
Intelligence Officer of the SS Dementieva
DragonFlame is offline  
post #8 of 108 (permalink) Old Nov 3rd, 2007, 03:35 PM
Senior Member
 
咖容Less's Avatar
 
Join Date: Sep 2003
Location: Belgrade
Posts: 7,319
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

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

NO


Jankovic suffers from severe Chinese syndrome! Only God can help her!
咖容Less is offline  
post #9 of 108 (permalink) Old Nov 3rd, 2007, 03:36 PM
Senior Member
 
serenus_2k8's Avatar
 
Join Date: Oct 2007
Posts: 10,966
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

wow very well made! how clever

heatherwatson laurarobson

usopen and wimbledon
#219juniorchampions #220

venuswilliams serenawilliams
serenus_2k8 is offline  
post #10 of 108 (permalink) Old Nov 3rd, 2007, 03:50 PM
Senior Member
 
咖容Less's Avatar
 
Join Date: Sep 2003
Location: Belgrade
Posts: 7,319
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

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

NO


Jankovic suffers from severe Chinese syndrome! Only God can help her!
咖容Less is offline  
post #11 of 108 (permalink) Old Nov 3rd, 2007, 04:07 PM
Team WTAworld
Senior Member
 
Babolatpro880's Avatar
 
Join Date: Jul 2004
Posts: 8,711
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

I can't use the tables because my version of Excel is too new
Babolatpro880 is offline  
post #12 of 108 (permalink) Old Nov 3rd, 2007, 04:34 PM Thread Starter
Senior Member
 
Join Date: Sep 2001
Posts: 26,036
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

Quote:
Originally Posted by Babolatpro880 View Post
I can't use the tables because my version of Excel is too new
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?
GoDominique is offline  
post #13 of 108 (permalink) Old Nov 3rd, 2007, 04:43 PM
Senior Member
 
Fired's Avatar
 
Join Date: Nov 2006
Location: Spain.
Posts: 3,408
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

wow great job

Lisicki . Giorgi . Pennetta . Goerges . Muguruza . Cirstea . Dodin . Schmiedlova
Fired is offline  
post #14 of 108 (permalink) Old Nov 3rd, 2007, 05:36 PM
Senior Member
 
Demosthenes's Avatar
 
Join Date: Jun 2005
Location: Novak Egg
Posts: 45,084
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

So basically, Kuznetsova has finished the year as the #2 player in the world.

Thanks for this, GoDom. Really nice work.

2016 Title(s):
Suicide: Strasbourg


Quote:
Originally Posted by Vikapower View Post
And to think that G幯ie is 0-4 against this Kvitova player. Sometimes tennis is just not logical at all.
Demosthenes is offline  
post #15 of 108 (permalink) Old Nov 3rd, 2007, 05:37 PM
it's just me against the music.
 
In The Zone's Avatar
 
Join Date: Feb 2006
Posts: 26,541
                     
Re: Sony Ericsson Championships 2007: Group Updates and Ranking Scenarios

Can you do a Serena ranking scenario? I know she has a shot at # 4.
In The Zone 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









Human Verification

In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.



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