wOBA to WAR Conversion Spreadsheet
Update 2 11/10/09 - 4:20 MST - In column B of the spreadsheet there was some extra calculations that added 2 extra runs to all calculations. I think they were an artifact from once wanting to add WAA. They have been removed and the spreadsheet is corrected.
Update 11/10/09 - 4:00 MST - An error was found in the spreadsheet. I will post a corrected version later tonight once I get a chance to make the correction. Sorry for this inconvenience. -Jeff
Last Friday, Justin ran an article on free agent first basemen with their 2009 wOBAs. Justin and I determined that it needed a baseline wOBA for reference. The overall league averages can't be used because each position has its own run adjustment depending on its difficultly. For example, 2B is much harder to play than 1B, so if Chase Utley and Ryan Howard have the same wOBA, Chase's value is worth more since he is playing a more difficult position. Fangraphs has a great explanation of the process for each value in the WAR calculation.
I created a spreadsheet that has the projected RAA, RAR and WAR for each position assuming a certain wOBA.
For the spreadsheet I made the following assumptions:
- The player plays an entire season thereby getting the entire positional adjustment and has 700 plate appearances
- Player is a league average defender. If defense is needed, use a multi-year average of UZR from Fangraphs.
- The values for "League Average wOBA," "conversion of wOBA to runs, PA per year," "Run to Wins Conversion" and positional adjustments are set to the current league scoring conditions. The spreadsheet can be downloaded and these values can be manipulated as each user sees fit.
- No assumptions are made for league adjustments (AL being more difficult than NL) in the calculations.
Here are the wOBA values for each position needed to get league average and replacement level production:
| Average Level | Replacement Level | |
| All Players | 0.327 | 0.289 |
| C | 0.310 | 0.273 |
| SS | 0.32 | 0.28 |
| 2B/3B/CF | 0.326 | 0.289 |
| RF/LF | 0.342 | 0.305 |
| 1B | 0.350 | 0.313 |
| DH | 0.366 | 0.329 |
Examples for using the spreadsheet.
Example 1. Justin's look at 1B Free Agents
Here is the graphic Justin posted Friday:
Values are in the graphic, but no reference for meaning. Instead, if we look at the preceding table, we can see that a 1B needs to hit .350 for league average production. There are only 5 free agent first basemen that meet this criteria (LaRoche, Mientkiewicz, Branyan, Johnson, and Delgado). Also we can find that 6 players contribute at below replacement level when batting (Garciaparra, Cairo, Millar, Tracy, Betemit and Aurilia).
Example 2 - The Royals are considering having Jose Guillen be the permanent DH next season. What does his wOBA need to be to contribute positive WAR for the Royals?
This answer is actually pretty simple. He needs to bat a wOBA of 0.329 since there is no defensive adjustment to add. Currently, Bill James, the only person out with projected wOBA, has Jose projected to hit a wOBA of 0.321. Jose's production isn't enough to get DH replacement level production. Then by going back to the spreadsheet, it can be seen that if he gets 700 at bats he will have a -0.5 WAR. The Royals should be looking for another DH if they are hoping to have at least replacement level contribution from the DH spot.
I hope that you find this spreadsheet useful, and let me know if you need any further explanation.
4 recs |
20 comments
|
Comments
Useful, easy, and productive. Very nice.
Beyond the Boxscore Not a member? Sign up.
by Sky Kalkman on Nov 10, 2009 2:50 PM EST reply actions 0 recs
Agreed.
Thanks Jeff. This data is and will continue to be used in the Free Agent Friday posts. Certainly makes the pickings look a little more slim.
See Data Differently.
beyondtheboxscore.com | Twitter: @ justinbopp
by Justin Bopp on Nov 13, 2009 12:30 PM EST up reply actions 0 recs
Are the average wOBA’s per position just a one-year sample?
And now at Beyond the Boxscore and Project Prospect!
by Mike Rogers on Nov 10, 2009 3:08 PM EST reply actions 0 recs
I am not sure what you are asking?
Are you saying that they are only good for this year?
Jeff Zimmerman - Protecting the world from RBI's and Wins from my mom's guest house.
by Jeff Zimmerman (TucsonRoyal) on Nov 10, 2009 3:15 PM EST up reply actions 0 recs
He's asking how many years do the averages encompass.
A la, are they based only on 2009 numbers, or 2007-2009?
by R.J. Anderson on Nov 10, 2009 3:54 PM EST up reply actions 0 recs
Just 2009 and then even some of those numbers can be debated.
Jeff Zimmerman - Protecting the world from RBI's and Wins from my mom's guest house.
by Jeff Zimmerman (TucsonRoyal) on Nov 10, 2009 4:02 PM EST up reply actions 0 recs
Ahh, gotcha. Do you think going multiple years back would be better/benefitial or just be inconsequential (mostly)? I know in looking at 2nd base over the years, the wOBA has gone from (06-09) .338, .352, .351, and .361.
And now at Beyond the Boxscore and Project Prospect!
by Mike Rogers on Nov 11, 2009 7:44 AM EST up reply actions 0 recs
Mike - I will look into the difference later
Jeff Zimmerman - Protecting the world from RBI's and Wins from my mom's guest house.
by Jeff Zimmerman (TucsonRoyal) on Nov 11, 2009 10:18 AM EST up reply actions 0 recs
In the RAA formula, why is there the second term added
2.0*G2/680.0
???
by ktsharp on Nov 10, 2009 5:37 PM EST reply actions 0 recs
A horrible artificact from initially have WAA. Remove it or download new spreadsheet.
Sorry about that.
Jeff Zimmerman - Protecting the world from RBI's and Wins from my mom's guest house.
by Jeff Zimmerman (TucsonRoyal) on Nov 10, 2009 6:27 PM EST up reply actions 0 recs
so its not needed?
just clicked on the spreadsheet link above again but its still there i think
by ktsharp on Nov 10, 2009 8:03 PM EST reply actions 0 recs
It is not needed
It will have all the values 2 Runs too high.
Jeff Zimmerman - Protecting the world from RBI's and Wins from my mom's guest house.
by Jeff Zimmerman (TucsonRoyal) on Nov 10, 2009 8:43 PM EST up reply actions 0 recs
Looks like when I corrected it, I missed the All Players tab.
Jeff Zimmerman - Protecting the world from RBI's and Wins from my mom's guest house.
by Jeff Zimmerman (TucsonRoyal) on Nov 10, 2009 10:19 PM EST up reply actions 0 recs
This is more on the graph than the spreadsheet.
The spreadsheet looks fun, going to play around with that over the weekend.
But Adam LaRoche and Dougie M?
I used to work with an old man that told me. Son, every workplace has a dumbass, if you don't have one where you work, then I'm afraid you're it.
by Warden11 on Nov 10, 2009 9:51 PM EST reply actions 0 recs
Yeah, that was an oversight, corrected with this week's look at FA 2Bs.
See Data Differently.
beyondtheboxscore.com | Twitter: @ justinbopp
by Justin Bopp on Nov 13, 2009 12:29 PM EST up reply actions 0 recs
This is awesome.
But 700 PAs seems like a lot. What do the numbers look like at 600PAs?
I would think that the wOBA values required would be higher, especially for the easy defensive positions.
by ARock on Nov 16, 2009 12:29 AM EST reply actions 0 recs
You can download the sheets and change the numbers to whatever you like, make sure to adjust the defensive position adjustements also.
Jeff Zimmerman - Protecting the world from RBI's and Wins from my mom's guest house.
by Jeff Zimmerman (TucsonRoyal) on Nov 16, 2009 9:09 AM EST up reply actions 0 recs
Love the spreadsheet. Any chance you can add the numbers for (hitting) pitchers?
vr, Xei
by Xeifrank on Nov 16, 2009 12:59 AM EST reply actions 0 recs
Not sure what you mean.
Jeff Zimmerman - Protecting the world from RBI's and Wins from my mom's guest house.
by Jeff Zimmerman (TucsonRoyal) on Nov 16, 2009 9:10 AM EST up reply actions 0 recs
a tab for pitchers. Pitcher hit too. :)
vr, Xei
by Xeifrank on Nov 16, 2009 10:42 PM EST up reply actions 0 recs

by 













BtB on Facebook















