Sorting the data - Interesting observations

cigardave

cigardave

Who's got a light?
Silver Member
I started a separate thread on this hoping it'll prompt some interesting observations and comments.


First off, on my copy of the database, I highlighted all the ladies' data in yellow just to be able to quickly see any trends or such.

Next I was interested in seeing if the data could help us statistically address which player(s) that got eliminated in Round 1 were eliminated principally because they got drawn into what turned out to be a very tough group.

So I first sorted the data by B&R% + and then by B&R% * (both descending) to see whose name(s) were near the top of the list... and again, I'm looking for players who were eliminated during Round 1... and Shane van Boening's name jumps out... with Tony Robles not too far behind.

My conclusion... both of these typically strong players got put into what turned out to be very tough Round 1 groups... even though we didn't realize it at the time.

Comments?
 
I noticed the same thing. I think the two who didn't advance out of that group probably would have in any other group...I think SVB must have given back some games where his opponents came up dry on the break...I think the IPT should be tracking RUNOUTS AFTER DRY BREAKS...JMO...
 
Hi Dave,

Are you able to attach your file? Or email it to me? I wish their stats were in an Excel file, so all you had to do was click to rearrange by your preference. :(
 
Analysis

I think it would be interesting to do an analysis by Countries. I would like it really to broken down into regions for the USA players, but we don't have that data available for all USA players (Midwest, West Coast, East Coast, South, etc.).

To see what percentage of players from each country dropped off at a level and continued on to the next level. This sheds some more light onto the quality of players arising from what countries (yes, I know the Filapinos have the best quality players). Mostly it would benefit the analysis of the quality of players that the USA is providing.

It would answer questions like, 'Is the big pockets around the country producing lower quality players here in the USA?'. And many more questions. If we knew by region for the USA, then we could analyze why an area might be dominate in producing more quality players than other areas, and how they are doing it. It could be a very interesting study.
 
rackmsuckr said:
Hi Dave,

Are you able to attach your file? Or email it to me? I wish their stats were in an Excel file, so all you had to do was click to rearrange by your preference. :(
Click to expand...

Linda - I'll try to PM it to ya.


Edit: I sent ya a PM but I couldn't attach it... wouldn't let me... PM me back your email addy and we'll go in that direction.
 
Last edited:
Even though it's just the first tournament with a full field, it's easy to see the top 15 to 20 players will be filled with the usual suspects as it should be. This format is truly the best way to have the best of the best rise to the top again and again, the chance of a a dark horse or one time Johnny making it to the final rounds will be rare.

Also, not making balls off the break is just as a important as I thought it would be, another nice stat for them to keep would be # of balls made on the break and wet verse dry breaks, these 2 stats would be great to have kept.

The IPT web master needs to make the columns sortable, it's super easy to do, I have no idea why they didn't.

It's also clear this is the first time stats will be kept on a distinct group of players over a long time frame, and from the same tournament format, it will be most interesting to see how it plays out. The stats and records alone will create more buzz and excitement for pool.
 
It would also be interesting to find out how many tour card members are left vs. qualifiers.
 
rackmsuckr said:
It would also be interesting to find out how many tour card members are left vs. qualifiers.
Click to expand...

20 Qualified players are still in!

The first number is their rank by winning%

5 Martinez, Rafael
6 Boyes, Karl
9 Lining, Antonio
15 Kirkwood, Jason
18 Matlock, David
21 Tot, Sandor
22 Luat, Rodolfo
25 Diks, Rico
29 Alcano, Ronato
30 Foldes, Vilmos
31 Abood, Gary
36 Sambajon, Santos
39 Moore, Steve
42 Heuwagen, Lee
46 Monday, Sam
47 Fu, Jianbo
50 Walden, James
65 Nevel, Larry
69 Kucharo, Jon
74 Pinegar, Jonathan

correct me if I'm wrong, I did it fast:-)
 
SlimShafty said:
24 Qualified players are still in!

The first number is their rank by winning%

5 Martinez, Rafael
6 Boyes, Karl
9 Lining, Antonio
15 Kirkwood, Jason
18 Matlock, David
21 Tot, Sandor
22 Luat, Rodolfo
25 Diks, Rico
29 Alcano, Ronato
30 Foldes, Vilmos
31 Abood, Gary
36 Sambajon, Santos
39 Moore, Steve
40 Bennett, Keith
42 Heuwagen, Lee
46 Monday, Sam
47 Fu, Jianbo
50 Walden, James
54 Schmidt, Michael
65 Nevel, Larry
66 Okumura, Takeshi
69 Kucharo, Jon
70 Mladenovic, Goran
74 Pinegar, Jonathan

correct me if I'm wrong, I did it fast:-)
Click to expand...

I inserted the ones that I believe that you skipped.
 
Last edited:
cigardave said:
I inserted the ones that I believe that you skipped.
Click to expand...

I think Linda was just looking for the players who are still active, so I skipped them on purpose since those 4 players are eliminated, right? but yeah that would be the correct order of qualified players.
 
Well I think your stats are a little off since there are only 60 players left and you have someone ranked 74th.
 
mnShooter said:
Well I think your stats are a little off since there are only 60 players left and you have someone ranked 74th.
Click to expand...

Not true... cuz the EXCEL database that assigns the numbers has all the players listed... sorted by their Games Won %... therefore, there are some players still in the tournament that have a Games Won % that is less than someone already eliminated.

It could be sorted such that only the remaining players are listed at the top... but when SlimShafty answered Linda's question... that was not the case.
 
Last edited:
Correct, here I removed the players that are already out. So the number is their ranking by winning% and b&r% before the third round out of 60 players

5 Martinez, Rafael
6 Boyes, Karl
9 Lining, Antonio
15 Kirkwood, Jason
18 Matlock, David
21 Tot, Sandor
22 Luat, Rodolfo
25 Diks, Rico
29 Foldes, Vilmos
30 Alcano, Ronato
31 Abood, Gary
35 Sambajon, Santos
37 Moore, Steve
39 Heuwagen, Lee
43 Monday, Sam
44 Fu, Jianbo
47 Walden, James
55 Nevel, Larry
57 Kucharo, Jon
59 Pinegar, Jonathan
 
SlimShafty said:
20 Qualified players are still in!

The first number is their rank by winning%

5 Martinez, Rafael
6 Boyes, Karl
9 Lining, Antonio
15 Kirkwood, Jason
18 Matlock, David
21 Tot, Sandor
22 Luat, Rodolfo
25 Diks, Rico
29 Alcano, Ronato
30 Foldes, Vilmos
31 Abood, Gary
36 Sambajon, Santos
39 Moore, Steve
42 Heuwagen, Lee
46 Monday, Sam
47 Fu, Jianbo
50 Walden, James
65 Nevel, Larry
69 Kucharo, Jon
74 Pinegar, Jonathan

correct me if I'm wrong, I did it fast:-)
Click to expand...

I think you forgot Alex. He'd be up near the top of this list.

Dave
 
DaveK said:
I think you forgot Alex. He'd be up near the top of this list.

Dave
Click to expand...

Alex Pagulayan won his tour card and is a tour member, he's not one of the 50 qualified players. What players who are not tour members are still active is what was asked for. I see where the word Qualified could be mistaken with tour card qualifiers:-)

It's pretty interesting how 20 players without tour cards are doing so good, I'm betting the qualifiers get more people entering:-)
 
You must log in or register to reply here.
Back
Top