FanPost

WAR for position player spreadsheets

I posted a link to these in the Sabermetrics 101 thread, and upon doing so I realized that they weren't really all that well suited to being viewed and edited by more than one person at a time. Since some people seemed to be interested, I decided to redo them and make them a bit more user-friendly. 

If you're not familiar with what goes into calculating WAR, read this post by Tangotiger before you proceed. Also, you might want to take note of the fact that the positional adjustments have been updated. The new adjustments are:

  • +1.25 C
  • +0.75 SS
  • +0.25 2B/3B/CF
  • -0.75 LF/RF
  • -1.25 1B
  • -1.75 DH

Playing time should be entered as percentage expressed as a decimal. Tango's post contains a section on figuring playing time; looking at PAs is generally the best way to go. Market value is calculated based on WAR*$4.75mm, which is the current going rate on the open market. (Note: this is the thing I am least sure about, so if I am incorrect, please feel free to let me know.) As far as defense goes, use your method of choice.

The columns that contain the calculations are hidden; if you'd like to take a look at the raw numbers feel free to unhide them, but I'd like to ask that you rehide them when you're finished. In addition,  If you're not familiar with spreadsheets, it might be best to just stick with the basic numbers in the unhidden fields.

Please feel free to use this as much as you'd like, with the following requests; if you see data in a row, use a different row. When you've finished your calculations, please delete the data in uncolored fields that you used; the WAR and Market Value fields will zero out automatically.

If you plan to use this spreadsheet often and you'd like your own copy, there are two ways to go about it; it can be exported into Excel by choosing File-->Export-->.xls, or you can create a copy by choosing File-->Create a Copy. To export the spreadsheet into Excel properly, the hidden columns must be unhidden when exporting. To create a copy, you must have a Google Docs account of your own. Feel free to pass this on to others as well, but send them a link to this post rather than a direct link to the spreadsheets themselves.

Manually changing the data in any colored field (including the WAR and Market Value fields) will screw the pooch, so please try and be careful.If you think the numbers are off, please send me an e-mail and I'll look into it. Accidents happen of course, and so if something does go wrong, I'd like to ask that you drop me a line to let me know. If you need to e-mail me for any reason, my address is on my SBN profile page.

AL Position Player WAR Spreadsheet

NL Position Player WAR Spreadsheet

X
Log In Sign Up

forgot?
Log In Sign Up

Forgot password?

We'll email you a reset link.

If you signed up using a 3rd party account like Facebook or Twitter, please login with it instead.

Forgot password?

Try another email?

Almost done,

By becoming a registered user, you are also agreeing to our Terms and confirming that you have read our Privacy Policy.

Join Lookout Landing

You must be a member of Lookout Landing to participate.

We have our own Community Guidelines at Lookout Landing. You should read them.

Join Lookout Landing

You must be a member of Lookout Landing to participate.

We have our own Community Guidelines at Lookout Landing. You should read them.

Spinner.vc97ec6e

Authenticating

Great!

Choose an available username to complete sign up.

In order to provide our users with a better overall experience, we ask for more information from Facebook when using it to login so that we can learn more about our audience and provide you with the best possible experience. We do not store specific user data and the sharing of it is not required to login with Facebook.

tracking_pixel_9351_tracker