User-Friendly WAR Spreadsheet (beta)
I've had this WAR spreadsheet sitting around for a couple weeks now, just waiting for the perfect time to present it along with detailed instructions, zero kinks, and some community collaboration. Well, that plan has been scrapped. We're going instead with a "here's the spreadsheet, we'll work everything else out later" plan (which actually might not be a bad idea.) So...
Feel free to download this thing and tell me what you think. Some brief instructions:
- Change the information in the green cells, but don't touch the rest.
- Everything is measured in wins. If you prefer to do your scratch work in runs, just divide by ten when entering the info in the spreadsheet.
- If you're not up with using wOBA, try using (OBP*1.75 + SLG)/3, which puts a properly adjusted OPS number on the wOBA scale. If you're really lazy, you can go with OPS/2.25
- BR is baserunning, which probably will include both SB/CS info and non-SB/CS info, unless you're looking at Fangraphs for wOBA (which already includes SB and CS in wOBA). I'd suggest assigning most players 0 for non-SB/CS BR, with some at +/- .25 wins and the rare player at +/- .5 wins. Baseball Prospectus has some solid baserunning numbers, just make sure to ignore the EQSBR piece if appropriate.
- Fld is fielding relative to position. You could even add in OF throwing arms from THT, although 2008 data isn't available yet.
- Once you have IP set for the relievers, change their leverages so that the team averages out to 1.0. Closers should stay at about 1.8 with one setup guy at 1.3 and a bunch of guys below 1.0 to average it out.
- Please, please, please don't just look at 2008 data. This is a projection. All past performance matters to varying degrees, not just last year. Even better, use projections done by people smarter than both you and me (CHONE and PECOTA are my favorites). Or get community input and take a wisdom-of-the-crowds approach. Or see how much over their heads the players on your favorite team have to perform in order to reach 90 wins.
- WAR stands for wins above replacement. An average player over a full season is worth 2.0 to 2.5 WAR. FA$ is the per-season value of each player's projected production priced at $4.84MM per win above replacement.
Feel free to ask questions or make suggestions in the comments. I'll fix things as we go. Be warned, depending on what changes need to be made, you maybe need to enter all the information again in the new version. Remember, this is a BETA.
1 recs |
42 comments
Comments
Great stuff
Before I dive into it, what fielding metric/data did you use?
The immoderate moderator
by NYRoyal on
Jan 7, 2009 12:32 PM EST
reply
actions
0 recs
The spreadsheet is blank, for you to fill in.
So I haven’t used any. I would recommend CHONE’s projections, a community-based estimate, or some weighted average of the past few seasons using bUZR, Dewan’s +/-, or PMR.
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 1:07 PM EST
up
reply
actions
0 recs
I used UZR
basically weighted over the past few years at the position. Since UZR is used on fangraphs as part of their WAR calculations, this seemed to make sense. I’m interested to see how others do it.
by Adam Peterson on
Jan 7, 2009 2:39 PM EST
up
reply
actions
0 recs
One potential problem
Skye — I’m not sure,but I think the “defense/700” column might be set on wins instead of runs… if not, I’m thrilled that David Dejesus is gong to be a 10 WAR player next year
Bringing you more-or-less replacement level analysis and commentary since sometime in 2008.
by devil_fingers on
Jan 7, 2009 2:26 PM EST
reply
actions
0 recs
Yes
I entered the Twins data and baserunning/defense is definitely in wins.
by Adam Peterson on
Jan 7, 2009 2:37 PM EST
up
reply
actions
0 recs
yeah, baserunning, twoo
Bringing you more-or-less replacement level analysis and commentary since sometime in 2008.
by devil_fingers on
Jan 7, 2009 2:43 PM EST
up
reply
actions
0 recs
Divide your input by 10
as he notes in bullet #2 to work in run versus wins.
by JBrew on
Jan 7, 2009 2:47 PM EST
up
reply
actions
0 recs
yeah, I know
just noting the problem, since other stuff is in runs
Bringing you more-or-less replacement level analysis and commentary since sometime in 2008.
by devil_fingers on
Jan 7, 2009 2:49 PM EST
up
reply
actions
0 recs
There's nothing in runs on the spreadsheet, unless I'm being really dense.
It’s ALL in wins and should be input as such.
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 2:52 PM EST
up
reply
actions
0 recs
doh, I'm the moron
sorry
Bringing you more-or-less replacement level analysis and commentary since sometime in 2008.
by devil_fingers on
Jan 7, 2009 2:56 PM EST
up
reply
actions
0 recs
Yay, it's not me today!
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 2:59 PM EST
up
reply
actions
0 recs
Oh, and you're banned next time you put an 'e' at the end of my name. ; )
Just one of those things, like ‘less’ vs. ‘fewer’.
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 3:54 PM EST
up
reply
actions
0 recs
yikes
that was a legit typo
I’ll try to do it less times
Bringing you more-or-less replacement level analysis and commentary since sometime in 2008.
by devil_fingers on
Jan 7, 2009 5:11 PM EST
up
reply
actions
1 recs
Both rec'd and flagged for use of humor
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 9:26 PM EST
up
reply
actions
0 recs
What do you recommend we do with the sheets
when we’ve finished for a given team? I’ve taken a crack at the Twins and have seen Fanposts from various folks, but this doesn’t lend itself too well to maintaining the projections and producing/refining a community projection for a given team.
by Adam Peterson on
Jan 7, 2009 2:46 PM EST
reply
actions
0 recs
If I had a team blog...
… I’d create a permanent link to a google docs or edit grid page housing the spreadsheet. You could fill it out yourself or let the community vote on all players, or some combination of the two (you initially and you could modify it if the consensus says so). As players and playing time expectations change, modify the sheet, but keep it always at the same link. Maybe make weekly posts to note changes you’ve made. Or if a major change takes place, make note immediately. As a team blogger, how well does that work?
As for bringing these projections together across multiple teams, there’s room for discussion. Ideally, there’d be one “official” sheet for each team and owners of those sheets would have access to update some master doc with 30 tabs. And/or one sheet with all projected WAR totals so someone could normalize them (assuming they average out to significantly more than 81 wins).
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 2:59 PM EST
up
reply
actions
0 recs
Other fun uses
- Do a best-case or worst-case scenario.
- See how well players have to perform in order to project 90 or 95 wins for the team.
- Create a dream team.
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 3:03 PM EST
up
reply
actions
0 recs
Another more fun use
- Ignore Chone’s projections and pretend the Royals will have an average team defense in 2009
Bringing you more-or-less replacement level analysis and commentary since sometime in 2008.
by devil_fingers on
Jan 7, 2009 5:12 PM EST
up
reply
actions
0 recs
awesome adjective use, I know
Bringing you more-or-less replacement level analysis and commentary since sometime in 2008.
by devil_fingers on
Jan 7, 2009 5:12 PM EST
up
reply
actions
0 recs
I think it would be interesting to build a google doc with every team
Or one for each league at least that compiles all of the WAR spreadsheets (I think Sky hinted at this before). An individual tab for each team with a summary tab showing hitting/pitching and total WAR to see if the overall total gets close to realistic records (i.e not every team ends up with 81+ wins).
by JBrew on
Jan 7, 2009 2:54 PM EST
reply
actions
0 recs
My thoughts exactly (see above, I didn't copy you, I swear!)
One problem is that multiple people will likely project each team. Whose projection do we use? Do I ask for first-come first-served volunteers? Pick someone I trust the most (not this one)? Designate a team coordinator who averages all projections for their team?
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 3:01 PM EST
up
reply
actions
0 recs
Should I be worried about using ERA to project win value?
by JI on
Jan 7, 2009 3:14 PM EST
reply
actions
0 recs
It's an ERA-like number.
You want to estimate how many runs a pitcher will allow and how many innings they’ll pitch. The ERA scale isn’t perfect because it doesn’t include unearned runs, but it’s not a big deal. You obviously want to use a decent ERA projection, not one based on previous year’s ERAs. Use FIP, xFIP, tRA (times .92), tRA* (times .92) or any projection that’s based on skills, not actual ERA.
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 3:22 PM EST
up
reply
actions
0 recs
Recommend we rename the tab
to simply “RA” or “FIP RA” to avoind the confusion. Whatever communicates that this is not ERA, but rather a fielding independent representation of pitching runs.
by Adam Peterson on
Jan 8, 2009 6:46 PM EST
up
reply
actions
0 recs
Using "RA" implies it's not on the ERA scale, though.
I prefer to keep it on the ERA, as that’s much more intuitive to most people.
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 9, 2009 10:26 AM EST
up
reply
actions
0 recs
Base Running
If we are using Chones’ projections, do you think his speed score would be good to use for the BR column? I guess I could just go to FanGraphps and get the wOBA with base running included but was just curious.
I made a file for each of my 2 sim league teams using Chones’, Marcel’s and ZiPS so far. I may go back through and do James since FanGraphs has his projections on there and hopefully DMB decides to do their projection disk again.
Thanks for the sheet, very interesting and helpful.
by jfish26101 on
Jan 7, 2009 4:33 PM EST
reply
actions
0 recs
FanGraphs wOBA does not include baserunning other than SB/CS
CHONE’s speed score would be decent, although speed isn’t the be-all and end-all of baserunning. You’ll need to turn his speed scores into ratings on the negative .5 to positive .5 baserunning wins scale, though.
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 4:39 PM EST
up
reply
actions
0 recs
How would I go about doing that? If you aren’t sure off the top of your head that is cool, don’t worry about it.
by jfish26101 on
Jan 7, 2009 5:12 PM EST
up
reply
actions
0 recs
Speed Score is cool, but doesn't translate to baserunning
since baserunning involves more than just speed.
Go to the link Sky gives above for Baseball Prospectus’s baserunning numbers. That should give you a good idea how how people did this past season. Too bad BP only goes back through 2007 for some reason (I assume this is a retrosheet-based system…). From the total baserunning score, substract the EQSBR number (since SB/CS are already included in the wOBA score). Then divide by 10 to get the baserunnings wins for the spreadsheet (although ideally you’d want more than 1-2 years of data to make a projections).
Bringing you more-or-less replacement level analysis and commentary since sometime in 2008.
by devil_fingers on
Jan 7, 2009 5:15 PM EST
up
reply
actions
0 recs
This.
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 9:27 PM EST
up
reply
actions
0 recs
My Cardinals version
I mostly used CHONE (they are on the google doc) with some slight differences (I’m usually pessimistic). I know each position won’t get exactly 700 PA I just used that as a nice round number for assigning the PA.
Baserunning is purely my wild ass guess. Mostly just those I think of as good baserunners and the piano carrying Yadier Molina.
The fielding numbers are somewhat gut, somewhat UZR and somewhat CHONE. I more or less took CHONE and divided by 20 (10 to convert to wins and 2 to reduce the values in half). I cross checked with UZR and think they are ok.
Pitching is meh, tried to account for LaRussa bullpen usage.
Welcome any comments.
(Sky – I have an advisor who would probably like a word with you, I’m never going to get these papers done with stuff like this available. Thanks though for making this for the rest of us.)
by JBrew on
Jan 7, 2009 5:25 PM EST
reply
actions
0 recs
Awesome.
Pitching is meh, tried to account for LaRussa bullpen usage.
Hilarious. If the Cards project anything like they performed last year, hitting and fielding are huge strengths while the pitching is double meh.
If you need a note for your advisor, let me know.
Positions should vary around the 700 number most definitely, although there’s no easy way to plug in lineups. I do add up “outs” made by each team by assuming the team’s OBP is exactly their wOBA (a bad assumption for OBP-heavy or SLG-heavy teams). The “outs targets” listed assume 700 PAs from 8 or 9 (depending on NL or AL) positions at a .335 OBP/wOBA. I also give IP targets based on averages from last year.
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 9:31 PM EST
up
reply
actions
0 recs
I will take 89 wins
It may not win the division, but it might shut Bernie Miklasz up.
I'll be the one overrating these Faberge' eggs, thank you very much!
Future Redbirds
by erik on
Jan 8, 2009 12:20 AM EST
up
reply
actions
0 recs
one nitpick
but you have Pineiro as a 2.7 WAR. That has to be a mistake
I'll be the one overrating these Faberge' eggs, thank you very much!
Future Redbirds
by erik on
Jan 8, 2009 12:31 AM EST
up
reply
actions
0 recs
Wow Sky
Great job. This will save me so much time. As well as making it so I don’t have to help my friends w/ their teams.
by rglass44 on
Jan 7, 2009 6:10 PM EST
reply
actions
0 recs
Thanks.
I’m surprised more people haven’t questioned some of the numbers I used. I assume that will come as people actually use the spreadsheet. I’d like to discuss some of the choices eventually…
Beyond the Boxscore // Calling BJ Upton lazy is lazy.
by Sky Kalkman on
Jan 7, 2009 9:31 PM EST
up
reply
actions
0 recs
Very Convenient
This would have been really useful when I was doing some O’s projections, but it should come in handy in the future. I used a lower starting baseline for wins since the Orioles play in the crazy tough AL East (and are the worst team there).
by KakesForROY on
Jan 8, 2009 7:43 PM EST
reply
actions
0 recs
2009 Red Sox Projected
I posted the 2009 Red Sox projection over at Over the Monster. The projected win total was 106, which obviously seems high. I was hoping someone could look at my post and see if anything seems incorrect.
by drabidea on
Jan 9, 2009 3:28 PM EST
reply
actions
0 recs












BtB on Facebook
BtB_Sky on Twitter



