Navigation: Jump to content areas:


Pro Quality. Fan Perspective.
Login-facebook
Around SBN: What If This Is It For The Celtics? End Of An Era Looming

The 2011 Royals will go 69-93 and I Can Prove It ...

Not really.  Not even close, but I think I have the next best thing. I finally have a semi-easy spreadsheet to fill out that predicts a team's winning percentage knowing the underlying talent on the team. I have been wanting to do this for a while and now I think I have it ready.  

 

Knowing the projected stats for the pitchers and hitters and their possible playing times, the number of wins the team is expected to win will be calculated.  I would love to give a big thanks to The Book Blog for supplying the needed information for the calculations.

 

Here is the LINK to the spreadsheet and it is filled out with a basic predicted Royals lineup for reference. The spreadsheet can be downloaded to your computer by opening it, selecting File Download and selecting the format you prefer to use.

 

I am sure I have an error or two or haven't explained everything in the instructions so let me know when have any questions.


 

Here are the instructions

  1. 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.

Star-divide

  • For projection information, Fangraphs.com 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 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.
  • 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/SIERA 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 are some general rules 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
  • Have fun and try not to get to depressed about next season already.

    Comment 52 comments  |  10 recs  | 

    Do you like this story?

    Comments

    Display:

    Ooooh....this is so badass

    Thanks a bunch my man!

    This will be fun tweaking.

    TWSS.

    Like a weapon labeled "very stupid weapon, do not use." - BabyBlues

    by Crooow on Nov 2, 2010 11:19 AM EDT reply actions  

    My own has several other changes for what I see. KIla at 1B => better May catching => worse Moose's June callup => better

    The pitching staff is a mess without any changes/additions

    - .-. ..- … – / – …. . / .—. .-. - .. . … …

    by Jeff Zimmerman on Nov 2, 2010 11:28 AM EDT up reply actions  

    Thanks.

    - .-. ..- … – / – …. . / .—. .-. - .. . … …

    by Jeff Zimmerman on Nov 2, 2010 11:05 PM EDT up reply actions  

    69-93

    Is good enough to make the playoffs if Bud gets his way and expands it to allow everyone to participate.

    Relive Royals History at royalsretro.blogspot.com

    by RoyalsRetro on Nov 2, 2010 4:02 PM EDT reply actions  

    Maybe I'm being nitpicky...

    But the number of PA’s seems way off. By about 40 AB’s per spot in the lineup.

    Since I assume the extra 360 PA’s are likely being taken by bench players it would seem like this spreadsheet is probably skewing the results positivly, making it look like the team is going to do better than it should.

    I don’t know how you would fix that, maybe take the aggregate stats of the non-starters and wrap those extra AB’s up with those stats instead? IDK, its probably not much of a difference, maybe a win.

    "We don’t have guys with a long history of being effective in the seventh and eighth innings."
    ~Trey Hillman, master of understatements.

    by RoyalPug on Nov 2, 2010 4:54 PM EDT reply actions  

    The person who bats first will get 40 extra PA compared to the person that bats second throughout a season. The spots won't be equal.

    The first part is to get a general idea for the number of PA. That is all.

    That is why it is important to get the high OBP people at the top of the lineup so the rest of the team can get more PA

    - .-. ..- … – / – …. . / .—. .-. - .. . … …

    by Jeff Zimmerman on Nov 2, 2010 5:00 PM EDT up reply actions  

    No i understand that.

    I just mean that your system predicts 5 players with more than 700 PAs in the lineup, and there were only 10 players to break that mark this season. And no player had more than you predict for Blanco. My point more than anything really, was that these guys arn’t going to play 162 games, most will probably play 150 give or take. and while the drop from Betancourt to say Getz isn’t big, the drop from Butler or Kila, is. And its probably big enough to be worth about a win.

    "We don’t have guys with a long history of being effective in the seventh and eighth innings."
    ~Trey Hillman, master of understatements.

    by RoyalPug on Nov 2, 2010 7:29 PM EDT up reply actions  

    OK, I get what you are saying now.

    Yes, the PA are on the high end, max WAR for hitters. I was just wanted to set a baseline for PAs.

    - .-. ..- … – / – …. . / .—. .-. - .. . … …

    by Jeff Zimmerman on Nov 2, 2010 10:31 PM EDT up reply actions  

    Thanks for setting the tone for 2011 so quickly!

    Yeah, I know – another lousy season is inevitable and 69-93 is really not too surprising; however, it is still DAMN DEPRESSING!

    "We're gonna win with pitching and defense" General Manager Dayton Moore, circa winter 2009

    "Where did all these Indians come from?" General George Armstrong Custer, circa summer 1876

    by loyal2sdad on Nov 2, 2010 5:18 PM EDT reply actions  

    Making some quick improvements to the team

    I added Albert Pujols at 1B with his 2010 stats, and moved Billy to DH, dropping Kila. This resulted in 76.92 wins.

    Adding Cliff Lee’s 2010 to the pitching stats (I went with a 3.00 FIP) and dropping Bannister moves the Royals to 81.42 wins. This was the same as adding a 2nd Greinke.

    Finally, let’s add Jayson Werth, I split the difference between 2009 and 2010 on his stats for a quick and dirty estimate. I’m replacing Gordon with Werth as Gordon has the lowest projected WAR. This moves the Royals to 86 wins.

    If Moustakas gets called up, I would expect an improvement over Betemit at 3rd, so maybe another win or 2, not to mention if we have somebody like Montgomery step up and replace SOS’s -1.2 with a 0 to 1 WAR season, we could be looking at a 90 win season.

    That could all happen right?

    So to summarize:

    Step 1: Add Albert Pujols
    Step 2: Add Cliff Lee
    Step 3: Add Jayson Werth
    Step 4: Moustakas gets called up
    Step 5: Montgomery replaces SOS
    Step 6: ???
    Step 7: Plaza Parade!!!!

    by AxDxMx on Nov 2, 2010 5:50 PM EDT reply actions  

    Way to keep Yuni around

    - .-. ..- … – / – …. . / .—. .-. - .. . … …

    by Jeff Zimmerman on Nov 2, 2010 5:56 PM EDT up reply actions  

    Exactly.

    There is a larger chance that we actually do what I suggest than actually replacing Yuni. How sad is that?

    by AxDxMx on Nov 2, 2010 6:05 PM EDT up reply actions   1 recs

    Thanks

    - .-. ..- … – / – …. . / .—. .-. - .. . … …

    by Jeff Zimmerman on Nov 2, 2010 11:05 PM EDT up reply actions  

    you don't trust the process...

    asshole.

    where's ross gload to explode the process?

    by blue bandwagon on Nov 2, 2010 6:21 PM EDT reply actions  

    In Soviet Russia

    Dayton Moore is also considered an idiot.

    Like a weapon labeled "very stupid weapon, do not use." - BabyBlues

    by Crooow on Nov 2, 2010 6:42 PM EDT up reply actions  

    Ironicly though...

    He’s considered a national hero in France….humm

    "Chiefs will...crush our enemies, see them drivin before us and hear the lamentation of the women."

    by Brian Harris on Nov 2, 2010 8:52 PM EDT up reply actions  

    I did some awesome tweaking

    had Aviles, Gordon and Kila having career years (with only Kila going over .800 OPS)

    Had Greinke, Hochevar and “Tejaha” performing better than expected (with Hoch having a break-out year). Result?

    83 wins. The planets just might align, gentlemen. 2003 all the f**k over again.

    Like a weapon labeled "very stupid weapon, do not use." - BabyBlues

    by Crooow on Nov 2, 2010 7:01 PM EDT reply actions  

    just bumped the offense up a tad

    (Kila w/ .860 OPS, Bettemit and Gordon and Aviles with .800-even OPS)

    and bumped down the pitching a tad,

    and got us to 86 wins.

    WE CAN DO THIS

    Like a weapon labeled "very stupid weapon, do not use." - BabyBlues

    by Crooow on Nov 2, 2010 7:20 PM EDT up reply actions  

    Royals 2011 forecast

    Gritty with occasional guts, wins .400 to .450. Slight chance of prospects by mid-summer, with a sprinkling of hope in an early fall. Kyle Davies looks great in September, wherever he may be.

    by 2X2L on Nov 3, 2010 9:23 AM EDT reply actions   1 recs

    Revised forecast

    It’s a “glimmering” of hope, of course, not a “sprinkling”. Sorry, bad data. And we have an origin now for those wins: they are “out of the ordinary from .400 to .450.”

    by 2X2L on Nov 5, 2010 1:52 PM EDT up reply actions  

    good stuff

    But if Blanco ends up with a higher OBP than Kila, I will eat my shirt.

    Actually, strike that.

    If Blanco ends up with a higher OBP than Kila, I will make a shirt out of bacon. And then I will eat my bacon-flavored shirt!

    batter nine you sucky

    by marbotty on Nov 3, 2010 10:10 AM EDT reply actions  

    Bacon-flavored shirt...

    …will be eaten by Billy Butler. Despite the weight gain, no discernible increase in power.

    by 2motley4thetitle on Nov 3, 2010 11:24 AM EDT up reply actions  

    How has this not been rec'd about 15 more times?

    How?

    Like a weapon labeled "very stupid weapon, do not use." - BabyBlues

    by Crooow on Nov 3, 2010 9:10 PM EDT reply actions  

    and the 2012 Royals will go 66-90...

    and the 2013 Royals will go 58-102….
    and the 2014 Royals will go 56-104
    and the 2015 Royals will go 57-103

    and hopefully by then you’ll realize you’ve all been wasting your time.

    "In the final analysis, the only opinion that really matters to all of us, is our own." ~TheK-Man~

    by TheK-man on Nov 4, 2010 4:55 PM EDT reply actions  

    this is wise shit right here

    Like a weapon labeled "very stupid weapon, do not use." - BabyBlues

    by Crooow on Nov 4, 2010 5:15 PM EDT up reply actions  

    DM's window is closing

    If DM doesn’t actually put a competent team on the field that can reach .500 by 2013 then i have zero hope for the future. The way it is I’ve already lost a lot of interest in the MLB team.

    by AxDxMx on Nov 5, 2010 12:08 AM EDT up reply actions  

    Nothing to worry about

    If the Giants can go from a #23 ranking, just below the Royals, to World Champions in one year, with a GM who as you probably know is not highly regarded, why give up now? I was convinced that the Giants would never win again with Sabean still at the helm after Bonds had gone, and look what happened.

    For every Guillen-sized mistake by Moore, Sabean has signed an Aaron Rowand. For every Kyle Farnsworth, Sabean got there first with an Armando Benitez. You say Scott Podsednik, I say Dave Roberts. You’ll run out of Moore’s mistakes before I’ll run out of Sabean’s — and that’s good, because I think we’ll both want to stop before we have to talk about Neifi.

    So, what happened? The Giants decided (finally!) to develop talent in their own system, and they improved their ability to evaluate amateur talent and plan for draft day by adding a few key guys to the organization. Within a few years, with tremendous good fortune in the rapid development and success of 3 consecutive #1 picks as well as a few other picks, they became a “competent” team again. Add to that good fortune a convivial willingness among opponents to stop hitting whenever their FIP-defying pitchers took the ball, the timely intervention of federal agents to help persuade them to exclude their biggest mistake from their postseason roster, a modest collection of 3-6 WAR players along with complementary guys who are league-average or a little better at just about every other position, an unlikely heroic postseason performance by a guy with a torn biceps tendon who is considering retirement, and, it must be mentioned, a few extra breaks along the way, and they became World Champions. You have to wonder whether it can happen to anybody.

    So, with the 2012 and 2013 seasons not actually having been played yet, and with no definite indication yet of how the Royals’ current collection of well-regarded prospects will perform at the major league level, I think it’s fair to hold out some hope for them. I won’t pin my hopes on a parade in the Plaza, but the chances of fielding a club that’s “competent” and even competitive, with their current level of commitment to drafting and development, aren’t bad at all.

    [Don’t get me wrong about last year’s BtB ranking — a better informed ranking of the 2009 Giants puts them toward the middle of the pack, not leading the bottom quartile. Can’t help but bring it up again, as a public service.]

    by 2X2L on Nov 5, 2010 1:39 PM EDT up reply actions  

    So, you'd be happy giving Mr. Moore two more years

    that’s six years, of meaningless trades and draft picking, to simply watch the team play 500 ball?

    I’m moving to Boston.

    "In the final analysis, the only opinion that really matters to all of us, is our own." ~TheK-Man~

    by TheK-man on Nov 5, 2010 9:16 PM EDT up reply actions  

    I wonder who will be the DM handpicked, yes men, poster boys

    for mediocrity this winter?

    "In the final analysis, the only opinion that really matters to all of us, is our own." ~TheK-Man~

    by TheK-man on Nov 5, 2010 9:18 PM EDT up reply actions  

    So wait!!

    Will there only be 156 games played in 2012?
    And only 160 the next 3 years?
    That seems strange.

    by sonofmun on Nov 6, 2010 10:27 AM EDT up reply actions  

    lol...someone actually did the math. Hysterical.

    "In the final analysis, the only opinion that really matters to all of us, is our own." ~TheK-Man~

    by TheK-man on Nov 8, 2010 3:15 PM EST up reply actions  

    To correct it....all ya gotta do is add 6 games to the loss column in 2012...

    and 2 games to the loss column in 2013, 14 and 15….and there ya have it.

    I’m glad you’re around to make sure we have the correct accounting for all of our losses.

    A true fan.

    "In the final analysis, the only opinion that really matters to all of us, is our own." ~TheK-Man~

    by TheK-man on Nov 12, 2010 5:08 PM EST up reply actions  

    I think we should start to post our (heavily-opinionized) most likely scenarios

    I’m going to do this now.

    Same thread or new thread?

    Like a weapon labeled "very stupid weapon, do not use." - BabyBlues

    by Crooow on Nov 7, 2010 3:00 AM EDT reply actions  

    Update for fun

    Just for fun, used Bill James’ optimistic projections for 2011, including 2011 FIP for pitchers. These projections show relative breakout years for Kila and Gordon. Replaced DDJ with Maier. Replaced Banny with Mazzaro.

    Result? 70-92

    by Tito42 on Nov 12, 2010 2:17 PM EST reply actions  

    Comments For This Post Are Closed


    User Tools

    Welcome to the SB Nation blog about Kansas City Royals.

    FanPosts

    Community blog posts and discussion.

    Recommended FanPosts

    Royalsretro_small
    Would Royals Review Make Better Decisions Than Dayton Moore?
    Funny-tattoos-hey-look-they-found-a-royals-fan_small
    Mitch On the Bench
    Royalsretro_small
    Happy Mother's Day From Royals Review

    Recent FanPosts

    Small
    Is Dave Eiland doing ... anything?
    Small
    Alcides Escobar's Bat
    Download_small
    Was Dayton Moore Right on Bruce Chen?
    Chalmers2_small
    2012 Royals vs 2012 Ex-Royals
    1481395546_m_small
    Why is our lineup so flawed?
    Small
    Fortune favors the bold
    Sexy-beast-original_small
    OT Friday: The first rule of Fight Club is NO FIGHTING
    387504_small
    Get to know a stop-gap starter - Vol. 2: Luis Mendoza

    + New FanPost All FanPosts >

    Yahoo_full_count

    Managers

    Cimg0036_small Freneau

    Editors

    Dayton_small Jeff Zimmerman

    Authors

    Royalsretro_small RoyalsRetro

    Headshot_small Old Man Duggan