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
- 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.
Have fun and try not to get to depressed about next season already.
52 comments
|
10 recs |
Do you like this story?
Comments
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
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
Hopefully better than Sean
- .-. ..- … – / – …. . / .—. .-. - .. . … …
by Jeff Zimmerman on Nov 2, 2010 1:37 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
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.
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.
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
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!!!!
Way to keep Yuni around
- .-. ..- … – / – …. . / .—. .-. - .. . … …
by Jeff Zimmerman on Nov 2, 2010 5:56 PM EDT up reply actions
Thanks
- .-. ..- … – / – …. . / .—. .-. - .. . … …
by Jeff Zimmerman on Nov 2, 2010 11:05 PM EDT up reply actions
In Soviet Russia
Dayton Moore is also considered an idiot.
Like a weapon labeled "very stupid weapon, do not use." - BabyBlues
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."
Not a national hero
but a comic genius. On the other hand, we sometimes think that too…
Feh.
by The Ol' Perfesser on Nov 2, 2010 10:48 PM EDT up reply actions 2 recs
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
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
That is a serious typo
"Chiefs will...crush our enemies, see them drivin before us and hear the lamentation of the women."
He is currently a FA.
Once we resign him, feel free to add him
- .-. ..- … – / – …. . / .—. .-. - .. . … …
by Jeff Zimmerman on Nov 2, 2010 9:04 PM EDT up reply actions
thats 16 wins right there right?
Go Royals!
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.”
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
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
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~
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.
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.]
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~
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~
So wait!!
Will there only be 156 games played in 2012?
And only 160 the next 3 years?
That seems strange.
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~
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~
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
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 
















