Introducing The xWHIP Calculatorby Jeffrey Gross
July 16, 2010
If you have the old version of the xWHIP calculator (anything before v.1.4.3), please download the new one (available through the link below), as it will give you the most accurate projection.
I am forever locked in Mortal Kombat for the souls of sports fans everywhere. Statistics are my science and 'the immeasurable character of men' is the obsolete religion of blind faith. My job is to prove that God doesn't exist and that athletes are merely cold, metal machines with no hearts or souls.
Earlier this week, I projected Cliff Lee's prospective rest of season WHIP. The formulaic process of calculating his xWHIP got me thinking and I spent the (entire) morning creating an xWHIP calculator (visually based on the THT xBABIP Quick Calculator). If you would like a copy of the program, you can download the xWHIP calculator by clicking here. The password to utilize the excel sheet is soto18.
Explanation of the xWHIP CalculatorAccording to Gameday data, circa 2005-2010, BABIP by batted ball type is general broken down as follows:
- Popups: .008
- Groundballs: 0.237
- Outfield Flyballs: 0.269
- Line Drives: 0.733
I've taken the above numbers and paired them with a formula that normalizes a pitcher's line drive percentage to 19% and spits out remaining balls in play (BIP) data. The calculator also features a defensive adjustment so that you can account for a pitcher's team defense. The defensive adjustment operates under the assumption that all "saved hits" were of the singles variety.
Below is a picture of the xWHIP calculator. The numbers plugged into the model for the picture are those of Tom Gorzelanny through July 17, 2010.
The grey cells are for data you should input. The green cells feature the xBIP data per IP. The blue and orange cells feature xWHIP and xHit calculations. The data cells are pre-formatted to visually round all numbers to keep the sheet clean, though cells will retain the full value of any number entered.
On a final note, I would like to give a special thank you to Derek Carty, who (possibly unknowingly) helped me create this xWHIP calculator.
Jeffrey Gross is an attorney (and die-hard Cubs fan) who currently resides in Green Bay, Wisconsin. In addition to writing for The Hardball Times, he also reviews tasty adult beverages as part of a side project titled "saBEERmetrics." He previously worked for The Daily Illini and Northern Star newspapers as a film critic and sportswriter (respectively). You can reach him by email at saBEERmetrics AT gmail DOT com.
<< Return to Article