Pick-Your-Winner [PYW] News | Extensive database completed for downloading - TennisForum.com

 
LinkBack Thread Tools
post #1 of 9 (permalink) Old Jul 11th, 2005, 03:40 PM Thread Starter
Team WTAworld
Senior Member
 
CooCooCachoo's Avatar
 
Join Date: Jan 2004
Location: Upstate New York
Posts: 63,522
                     
Pick-Your-Winner [PYW] News | Extensive database completed for downloading

PYW News

Note:

The database files are all Excel files. They will self evidently only be visible to you if you have Excel installed on your computer.



Quote:
What PYW is:

First of all, a note on what Pick-Your-Winner [PYW] is. This is the largest popularity contest held on WTAworld. Every week, we hold the same events as the WTA Tour (and, as of two weeks ago, also every ITF event higher than $50K). We use the original tournament draws and people can then vote for who they want to win the matches. The first player to win two sets in a match wins the match, with the tennis scoring system also pertaining to PYW. Every vote counts as one game, so the first person to cast a vote, determines the first game.

The winners of the matches move on to the next round, where people can vote once more. In the end, there will be one player standing, winning the tournament.

Every WTAworld member can vote in PYW. You don't have to commit, you don't need a minimum number of posts or whatever - just vote! PYW Threads can be found in the tournament forums.


After a lot of hard work and dedication, the PYW database has finally been completed. The database provides you with interesting statistics, great overviews and more. The database consists of three Excel files. I will explain in short what the files contain:

Head-to-Heads:

This file obviously contains head-to-heads. The large group of players is split into several groups, based on their surname (AB, CD, EF, GH, IJK, LM, NO, PQR, S, TU, VW and XYZ). Every group contains a table, with the names of the players on the top columns and the opponents in the left column. Head-to-heads in red mean a positive score for the player v. the opponent; h2hs in red stand for a negative score. If a score is in black, it means there is a tie (e.g. 1-1). If a cell is blank, there were no previous encounters between the two players.

Rankings & Overview of Results Per Player:

By far the largest and most important file, for it contains detailed rankings. You can see the amount of points a player scored every week. You can also see who won tournaments that week, because the points have a yellow background (WTA level tournament victories) or orange background (ITF tournament victories). You can also see the progress of a player, because a formula is installed to calculate how many spots a player's ranking dropped or increased compared to the previous week.

The large group of over 350 different players has been split again for the overview of results per player. The same groups as in the head-to-heads (AB, CD and so on) all have a tag of their own. The results of the players are there, with the players ordered alphabetically. Not only can you see the results, you can also see if a player was seeded, got a wild card, qualified or was a lucky loser; you can read how many points she scored that week and you can check the win/loss record.

Tournament History:

The tournament history includes the draws of every tournament played in the history of PYW. It also includes information on the ranking points to be earned in that event. Furthermore, there is a tag with a Hall of Fame, giving you an overview of all the tournament champions, runners-up and the final score.

Just have a look at the database and discover many interesting facts, keep track of your favourite players' results and see the database continuously being edited.

Click on the links to download the Excel files:
Guaranteed virus free

Head-to-Heads

Rankings & Overview of Results Per Player

Tournament History



____________________________________


This week's events in PYW are:

WTA Tier IV | Modena, Italy
ITF $50K | Vittel, France
ITF $50K | Louisville, Kentucky, USA

Visit the Internazionali di Modena forum and the Challenger Forums to vote. Keep an eye on my signature, which states what round the PYW events are in.

I hope to see your votes soon!



_____________
Martijn

CHARDY | CHIUDINELLI | CIPOLLA


Bemelmans|Camerin|Cornet|Crivoi|Cuevas|Dentoni|Dod ig|Garbin|Granollers
Hlavackova|Ilhan|Kohli|Kuznetsov|Lammer|Mannarino| Menendez|Phau|Polansky
Rezaï|Robredo|Roger-Vasselin|Srebotnik|Szavay|Wörle|Zverev

CooCooCachoo is offline  
Sponsored Links
Advertisement
 
post #2 of 9 (permalink) Old Jul 11th, 2005, 03:43 PM
Team WTAworld
 
TF Chipmunk's Avatar
 
Join Date: Jan 2005
Posts: 15,959
                     
Wow very nice work!

JUSTINE HENIN
ALLEZ!!!

ANASTASIA MYSKINA
Riding the 3AM Rollercoaster


NADIA PETROVA
ANNA-LENA GROENEFELD
TF Chipmunk is offline  
post #3 of 9 (permalink) Old Jul 11th, 2005, 03:44 PM
Senior Member
 
mandy7's Avatar
 
Join Date: Sep 2002
Posts: 12,263
                     
someone was bored

but good job tijn
mandy7 is offline  
post #4 of 9 (permalink) Old Jul 11th, 2005, 03:46 PM Thread Starter
Team WTAworld
Senior Member
 
CooCooCachoo's Avatar
 
Join Date: Jan 2004
Location: Upstate New York
Posts: 63,522
                     
Also, if you have any questions, just ask me or Geoffry.

And I would like to hear from you if you have any suggestions on how to improve the database.

CHARDY | CHIUDINELLI | CIPOLLA


Bemelmans|Camerin|Cornet|Crivoi|Cuevas|Dentoni|Dod ig|Garbin|Granollers
Hlavackova|Ilhan|Kohli|Kuznetsov|Lammer|Mannarino| Menendez|Phau|Polansky
Rezaï|Robredo|Roger-Vasselin|Srebotnik|Szavay|Wörle|Zverev

CooCooCachoo is offline  
post #5 of 9 (permalink) Old Jul 11th, 2005, 03:47 PM
Senior Member
 
VeeDaQueen's Avatar
 
Join Date: Dec 2004
Location: United States
Posts: 3,588
                     
some much effort. great job. y'all are really good at excel. i wish i could do more on it.
VeeDaQueen is offline  
post #6 of 9 (permalink) Old Jul 11th, 2005, 04:46 PM Thread Starter
Team WTAworld
Senior Member
 
CooCooCachoo's Avatar
 
Join Date: Jan 2004
Location: Upstate New York
Posts: 63,522
                     
Quote:
Originally Posted by shauny_r
some much effort. great job. y'all are really good at excel. i wish i could do more on it.
Actually, I didn't really use the mathematical advantages Excel offers here. Only for the rankings, where I use the Sum formula, so that's all very basic and anyone could do that (and I use the sort option). I do know a bit more about Excel, because I took a course in it (but I forgot most of it I bet, though it's easy to revive my memory with some exercises). It's pretty easy!

CHARDY | CHIUDINELLI | CIPOLLA


Bemelmans|Camerin|Cornet|Crivoi|Cuevas|Dentoni|Dod ig|Garbin|Granollers
Hlavackova|Ilhan|Kohli|Kuznetsov|Lammer|Mannarino| Menendez|Phau|Polansky
Rezaï|Robredo|Roger-Vasselin|Srebotnik|Szavay|Wörle|Zverev

CooCooCachoo is offline  
post #7 of 9 (permalink) Old Jul 11th, 2005, 04:51 PM
Team WTAworld
Senior Member
 
-Kieron-'s Avatar
 
Join Date: Feb 2005
Location: Leeds - UK
Posts: 3,187
                     
Cheers Martijn.
-Kieron- is offline  
post #8 of 9 (permalink) Old Jul 11th, 2005, 07:31 PM
Team WTAworld
Senior Member
 
KoOlMaNsEaN's Avatar
 
Join Date: Jan 2002
Location: Ottawa
Posts: 49,259
                     
good job

My Forever Fav: Jelena Dokic

Serena Williams, Ana Ivanovic

KoOlMaNsEaN is offline  
post #9 of 9 (permalink) Old Jul 12th, 2005, 12:43 AM
Senior Member
 
Join Date: Jan 2003
Location: Erm...
Posts: 28,923
                     
Nice work.


Sharapova's_Boy 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