Tuesday, May 27, 2008

Tuesday 5/27 Bonus - the technical "how to" post

I'm go to walkthrough my process for those interested. Let's say you want to make a club emphasizing how bad of a hitter Ray Ordonez is. Start by going to baseballreference.com and typing in Rey Ordonez at the top. (or you can type "Ray Ordonez" or even "Reinal Or").
Now you have all of his stats in front of you. If you aren't savvy enough to do this by mind, then you can open an excel spread sheet and type in Ray Ordonez and input a bunch of his offensive stats into columns.
Now, click the words "play index" next to "Quick Index:" towards the top of the page under the huge "Baseball-Reference.com" link. Under non-player specific tools, select batting season finder (because ordonez is a hitter).
Now, select "find totals for matching seasons or careers." Then look on the right where it says "Select Additional Criteria to Match." Now, based on our mind/excel spreadsheet, we know that Ordonez has played in 973 games with 3407 PA, 12 HR and 28 SB.
So set:
G>=973
PA>=3407
HR<=12
SB<=28
Above 'Get Results' you can select to sort it by something. You should choose one of the 4 categories you already inputted, and select ascending or descending so that Ordonez is not the #1 return. What I mean by that, is that you know Rey Ordonez will be one of the qualifiers for this club. If you choose to sort by Games, ascending, then you know that he will be the #1 return because of all the people who qualify for the above club, he has played the fewest games (973) while everyone else has played 973 or more. Therefore, if you are choosing to sort by G or PA leave the "ascending" box blank, if you are choosing to sort by HR or SB then select "ascending" to get an answer BESIDES Rey Ordonez. If you want to follow along with my example, select G and keep it descending.
Click 'Get Results.'
In a few moments a list should appear only showing you the #1 return, in this case Dal Maxvill who played 1423 games, the most games. Below you can see it says "Seasons/careers found: 6" This means that besides Dal Maxvill and Rey Ordonez, there are 4 more qualifiers. By being smart with the sorting options, you can possibly uncover the other 4. It doesn't take as long as it is about to look when you are used to going back and forth and when you have a fast computer, both of which I do/have. But to save you noobie the time:

Sorting by descending PA uncovers Tommy Thevenow.
Sorting by ascending HR uncovers Mike Tresh.
Sorting by ascending SB uncovers Dal Maxvill as well. No new name. Still 2 left.
Now you can just sort by anything until you uncover the final 2:
Sorting by ascending R uncovers Doug Flynn.
Sorting by ascending OBP uncovers Hal Lanier.
Now, you might say it is possible with this system that you can't ever find certain players no matter how you sort. That is to say, of this group, maybe there is a player that belongs neither at the top or bottom at every single searchable category. But considering you can search by year or birth, year of death, year of debut, height, weight, etc, this becomes extremely unlikely.

Now that you have the 6 players who qualify for the aforementioned 4 parameters, you need to whittle it down even further to find where Rey Ordonez stands alone. By making an excel spread sheet (or the way I prefer - a chart on a piece of paper) and adding a dose of common sense/4th grade skill with charts, you can see that by adding in 3B<=17 you eliminate everyone except Ordonez and Tresh. Now, you see that Tresh had more RBI than Ordonez, so set RBI<=287 and you have your 6th and final parameter. Thus:

3. Rey Ordonez: G>973, PA>=3407, HR<=12, SB<=28, 3B<=17, RBI<=287
Can't hit or run for freaking beans.
This was one of the more tough ones I had to go through, so I thought it would be a good example to show you how I did it. It's the first time I had to sort through so much to find all the qualifiers of my initial 4-parametered search, and it's also the first time I had to make a chart to find out which additional parameters to use. Therefore it made a perfect "example" example for people to learn from, but don't think I spend more than 5 minutes on a typical club creation.

No comments: