The Latest Spreadsheet
It’s Version 1.7!
I’ve uploaded a new version of the WPA spreadsheet. I’ve added a “poor man’s” Leverage Index to the spreadsheet, replacing Doug Drinen’s “P” as a way to measure the criticality of a situation. This Leverage Index is based on the difference between the Win Probability of the current situation and the Win Probability of a strikeout (in that situation). This approach was suggested by Tangotiger, and it seems to follow the distribution of his Leverage Index pretty closely.
If you’re using the WPA spreadsheet (particularly if you’d like to track the crticiality of each situation), I suggest you start using this version (1.7). As always, please let me know if you find any problems with it.
The spreadsheet (which requires Windows Excel 2002 or later) can be downloaded from ftp://ftp.baseballgraphs.com/wpa
Don’t rename the spreadsheet, or you’ll lose the macros!