I have been wanting to have this win prediction tool available for a while and finally have what I think is rather simple working model. This spreadsheet can be filled out with the players anyone thinks will be playing, along with their all their stats and then the team’s projected wins will be calculated.
Note: An error was found on the spreadsheet dealing with position adjustment and corrected around 4:30 EST on 11/4. If you downloaded it before then, you will need to re-download it. Sorry for the inconvenience. -Jeff
While it can be used to get an idea of how many wins a team might get in the up coming season, I plan on using it to evaluate changes in a team. Those changes could be a free agent signing, a trade, an injury or a rookie called up to the majors. The team’s expect wins before or after the roster change can be evaluated .
Today, I am not going to do look at any team. I just wanted to make it available and once the Royals sign Cliff Lee, I can see how their expected wins compare before and after the acquisition.
Right now I have it set it up with a basic Royals roster for reference. Have fun plugging in your own team’s players and see what type of season may be in store for them. The spreadsheet can be downloaded to your computer by opening it, selecting File => Download As and selecting the format you prefer to use. Here are the instructions and feel free to ask any questions.
Here are the instructions:
The formatting, by going to Google Docs and back, gets stripped off (e.x. The wins go to 10 decimal places, 1 would probably do). Feel free to format all the columns for easier readability.
For projection information, we will have them available as soon as the data is available. Since they are not available yet, one decent method to get a close value is to weight this past year’s stats as 1/3rd of the 2011 projection and the 2010 projection data as the other 2/3rds.
Fill in the data in the yellow and/or orange boxes. The rest of the boxes have formulas in them and if one is changed or deleted, all the values could change. From uploading and downloading it a few times, the color formatting doesn’t transfer so you may need to compare the online and downloaded sheets to see which columns need to be filled out.
Fill out the lineup section with name and projected OBP with what you think will be the most common lineup. This information is used to generate an approximate number of PA for the team. The team’s PA will be at a maximum value since the best lineups number were used. This season is just to get an idea on the number PA.
The next section is used to determine the amount of WAR from the position players. In this area, you can either fill in the player’s OBP and SLG -or- the players wOBA. For handling multiple players at a position, just make sure that that the number of games add up to 162
In the UZR/150 cells put in the players lifetime UZR/150 for that position. Sometimes the UZR/150 can be extremely high for the position and a value of 20, positive or negative is league leading or lagging value, so the values may need to regressed towards 0 quite a bit. Here are my 2010 projections for reference and I hope to have the 2011 ones done by Christmas.
Catcher defense can/should be set to zero.
To account for inter league play, the pitchers will bat in 9 games during the season for AL teams and NL teams will need to account for DH for 9 games also.
Once the data in the second section is filled out, go back to line 7 and 8 and make sure the Projected and Calculated number of PA are the same. Adjust the individual player PA as needed.
In the pitcher’s area, the player’s Name, Innings Pitched and projected ERA/FIPs/xFIPs need to be entered. I used FIPs with a 1/3 weighting for 2010 data and 2/3 for 2010 projections.
The total innings in the past 3 seasons have 1444, so the total innings from the pitchers you have need to equal this number.
Now the Leverage Index column need to filled out. This column can be filled out will all 1s and the total win values will remain close to the same final value compared to if pitcher’s values are filled out. If you want to fill out each value, here is an article on the the subject and some general rules to follow 1) Ace closers has an LI of 2 usually 2)Main setup men usually has an LI of 1.3 3)Your decent starters will have an LI of 1 4)Bad starters will usually have an LI of .9 as they will be pitching from behind in quite a few games. 5)Mop up relievers will have values less then 1.
If you put in LI values for each pitcher, the value labeled Total LI needs to be as close to 1444 (the total innings pitched) as you can get.
If you want to do a NL team, you will need to swap the data in cells C71 and C73 and also in cells L71 and L73.
You Aren't a FanGraphs Member
It looks like you aren't yet a FanGraphs Member (or aren't logged in). We aren't mad, just disappointed.
We get it. You want to read this article. But before we let you get back to it, we'd like to point out a few of the good reasons why you should become a Member.
1. Ad Free viewing! We won't bug you with this ad, or any other.
2. Unlimited articles! Non-Members only get to read 10 free articles a month. Members never get cut off.
3. Dark mode and Classic mode!
4. Custom player page dashboards! Choose the player cards you want, in the order you want them.
5. One-click data exports! Export our projections and leaderboards for your personal projects.
6. Remove the photos on the home page! (Honestly, this doesn't sound so great to us, but some people wanted it, and we like to give our Members what they want.)
7. Even more Steamer projections! We have handedness, percentile, and context neutral projections available for Members only.
8. Get FanGraphs Walk-Off, a customized year end review! Find out exactly how you used FanGraphs this year, and how that compares to other Members. Don't be a victim of FOMO.
9. A weekly mailbag column, exclusively for Members.
10. Help support FanGraphs and our entire staff! Our Members provide us with critical resources to improve the site and deliver new features!
We hope you'll consider a Membership today, for yourself or as a gift! And we realize this has been an awfully long sales pitch, so we've also removed all the other ads in this article. We didn't want to overdo it.
In case you didn't read all that, here's the short version. Membership includes:
✓Ad-free browsing
✓Unlimited FanGraphs & RotoGraphs articles
✓Historical & platoon projections
✓Leaderboard & player-page stat heatmaps
✓One-click data exports
✓Customizable player-page dashboards
✓Dark & Classic site modes
✓Weekly Members-only mailbag
✓FanGraphs Walk-Off, your year in review
✓Optional homepage photo removal
✓Gift articles to non-members
Great just what needed another thing to distract me from my research paper.
So awesome, thanks.
Now Greinke will have a friend!
Wait – perhaps I’m misunderstanding how the math works out, but why are you applying the full-season positional adjustment to each player regardless of playing time? For example, Kila Ka’aihue clearly isn’t a -0.77 win player next year, but the -1.25 positional adjustment makes him so even though he’s playing only 53 games. I guess the point is only to evaluate team WAR and not individual WAR, but I still don’t think that those unadjusted positional adjustments just cancel out.
Rather, that’s a -0.77 win first baseman – he’s worth -1.63 wins when you add his DH at-bats.
…
seriously? does anything think that kila ka’aiuhe would be a negative win value player, even in as small a sample size as 53 games? carlos santana hit .260/.401/.467 in 46GP and192PA in 2010, good for a .382 wOBA and 2 WAR. now, kila isn’t a catcher, but still, shouldn’t we expect something similar from kila in a similar SS?
Sorry, I was a little unclear with my second comment, which I meant as a continuation of the first. I was pointing out that an error in the spreadsheet’s hidden calculations was calling Ka’aihue an awful player because he was receiving twice the negative positional adjustment that he should have.
Nice catch – the spreadsheet was corrected around 4:30 EST
I had several people look over it. but one one caught it. Thanks.
Are you mentally retarted??? no way the Royals sign Cliff Lee!! Who would want to go to a crappy team like the ROYALS! The Yankees are going to sign him no doubt cuz we r BEAST. This is why sabermetricks are so FAKE! you guys are NERDS!
AHAHAHAHAHAHAHAHA.
C-, too transparent.
Just started playing around with this. I was wondering though, when doing an NL team, what is the typical pitcher’s OBP and SLG?
For 2010, the OBP/SLG numbers for pitchers were .177/.176
So it’s like a team full of Brandon Woodses!
This is excellent! Thanks!
[…] Predicting a Team’s Wins Using Underlying Player Talent (FanGraphs). This looks like a potentially fun way to waste time over the off-season. […]