Beyond the Box Score: An SB Nation Community

Navigation: Jump to content areas:



Sports blogs for fans, by fans.
Around SBN: Coyotes Ink Aucoin to One Year Deal


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 | Comment 42 comments

Story-email Email Printer Print

Comments

Display:

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 reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions actions   1 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 reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions actions   0 recs

This.

Beyond the Boxscore // Calling BJ Upton lazy is lazy.

by Sky Kalkman on Jan 7, 2009 9:27 PM EST to parent up reply reply actions actions   0 recs

My Cardinals version

Google Docs

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 reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions 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 to parent up reply reply actions actions   0 recs

Pinata

Yeah, last night I was playing around with replacing him with Sheets/Lowe/etc and forgot to put his ERA back in (and the google doc automatically updates). It should be fixed now.

by JBrew on Jan 8, 2009 9:56 AM EST to parent up reply reply actions 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 reply actions 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 to parent up reply reply actions 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 reply actions actions   0 recs

2009 Red Sox Projected

2009 Red Sox Projections

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 reply actions actions   0 recs

Comments For This Post Are Closed


User Tools

We use numbers and stuff.
Community Guidelines
Start posting on Beyond the Box Score »

Join SB Nation and dive into communities focused on all your favorite teams.

FanPosts

Community blog posts and discussion.

Recommended FanPosts

Sleepy_jeff_small
WAR Lords of the Diamond (Pitchers)

Recent FanPosts

Small
SLG and Speed
Small
Interleague Attendance Nonsense
Limes_125_small
A Note About Becoming a BtB Author: Contributing to the Community Helps
Small
Is Adrian Beltre underrated...?
Limes_125_small
How Do You Like the New Daily Link Roundup Posts?
Stlouiscardinals_small
Depth Charts Help
Zorilla_small
How Do You Measure a Pitching Coach?
Limes_125_small
Looking For SQL & Tech Geek Help For Collaborative Projects
Small
When do MLBers get paid...?
Limes_125_small
Help Me Expand Who I Follow On Google Reader

Post_icon New FanPost All FanPosts Carrot-mini

FanShots

Quick hits of video, photos, quotes, chats, links and lists that you find around the web.

Recent FanShots

Fire Jim Leyland: Fu-Te Ni Follow Up; Concern Over Big Three?
Rany Gets Banned By the Royals
Contract Retrospective: Vernon Wells' 7-year, $126 Million Contract
The Rockets are innovative
Flip Flop Fly Ball
Yanks Considered Trading Rivera For Wells In '95: MLB Rumors - MLBTradeRumors.com
Bullpen Usuage Charts for Last 5 days
MiLB Game of the Week
Drive Mechanics Looks at Chris Perez's Mechanics and Pitch F/X numbers
WPA Inquirer

Post_icon New FanShot All FanShots Carrot-mini

Most Commented

Subscribe to BtB via Email

Enter your email address:

Delivered by FeedBurner

BtB Goes Social

BtB on Facebook

BtB_Sky on Twitter


Managers

Mos-def-the-ecstatic_small R.J. Anderson

Limes_125_small Sky Kalkman

Editors

Rawlings_baseball_bigger_small Dan Turkenkopf

Face_small Harry Pavlidis

770insig_small Jeff Zimmerman (TucsonRoyal)

Rickstache_small erik

Authors

Jinaz-reds-avatar_small JinAZ

Hms_surprise_small Graham

Wisc19cropped2_small jhmoore

Raysring1_small Tommy Rancel

E52205a2_small tbsmkdn

Official Partner of Yahoo! Sports