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 Calculator
According 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
This data includes home runs, which is why the Outfield Flyball xBABIP is so high. If you take home runs out of the equation, the xBABIP for Outfield Flyballs and Line Drives fall to .174 and .727, respectively.
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.
I hope everyone enjoys this. If you have any questions/concerns/comments/criticisms, please email them to
, with the subject line xWHIP Calculator.
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.