Brew Crew Ball: An SB Nation Community

Navigation: Jump to content areas:



Sports blogs for fans, by fans.
New Blog: Backing the Pack for NC State Fans!


Projecting the Second Half

Sal Baxamusa at the Hardball Times recently published a very useful tool: downloadable Excel spreadsheets that produce Marcel projections for players. Marcels are basically weighted averages and are surprisingly competitive with advanced projection systems like PECOTA or ZiPS. For our purposes--predicting the most likely immediate future performance to evaluate, for instance, whether we should get a new second baseman--Marcel will do just fine. So, let's see what we've got:

Jason Kendall
PeriodAVGOBPSLG
Current.258.339.333
Balance.259.330.329
Total.258.334.331

Prince Fielder
PeriodAVGOBPSLG
Current.270.357.488
Balance.282.374.531
Total.275.364.507

Rickie Weeks
PeriodAVGOBPSLG
Current.217.320.367
Balance.247.357.409
Total.231.335.386

Bill Hall
PeriodAVGOBPSLG
Current.234.294.431
Balance.260.326.465
Total.246.308.446

Russell Branyan
PeriodAVGOBPSLG
Current.245.331.604
Balance.236.332.469
Total.239.332.515

J.J. Hardy
PeriodAVGOBPSLG
Current.283.352.476
Balance.273.335.448
Total.279.343.463

Ryan Braun
PeriodAVGOBPSLG
Current.286.324.549
Balance.303.354.567
Total.293.337.556

Mike Cameron
PeriodAVGOBPSLG
Current.231.320.481
Balance.246.329.443
Total.240.325.461

Gabe Kapler
PeriodAVGOBPSLG
Current.315.352.517
Balance.272.332.425
Total.294.341.471

Corey Hart
PeriodAVGOBPSLG
Current.289.327.504
Balance.285.340.496
Total.287.331.501

Ben Sheets
PeriodERAIPHKBBWHIP
Current2.85123109108281.11
Balance3.47878171221.18
Total3.11210190179501.14

CC Sabathia
PeriodERAIPHKBBWHIP
Current3.67137.313013740124
Balance3.21989486251.22
Total3.48235224223651.23

Jeff Suppan
PeriodERAIPHKBBWHIP
Current4.71101.311855441.60
Balance4.44728242271.52
Total4.6017320097711.57

Manny Parra
PeriodERAIPHKBBWHIP
Current3.781009978501.49
Balance3.98717057311.42
Total3.86171169135811.46

Dave Bush
PeriodERAIPHKBBWHIP
Current4.39106.79766261.15
Balance4.19767652191.25
Total4.30182173118451.19

Son of Clung
PeriodERAIPHKBBWHIP
Current4.1675.76664361.35
Balance4.53545140241.40
Total4.32129117104601.37

4 recs | Comment 14 comments

Story-email Email Printer Print

More from Brew Crew Ball

Cubs 2, Brewers 1 (10 innings)

Jul 2009 by KLSnow - 119 comments

Friday's Frosty Mug

Jul 2009 by KLSnow - 19 comments

Comments

Display:

Great work

thanks for much for doing this for all of our guys.

One note: This isn’t a criticism of Marcel, since it is what it is, but the one thing that most differentiates it from other systems (to me, anyway) is that it doesn’t use any minor league data. For someone with less than 3 full years in the majors, it just regresses to the mean more. In a system like mine (or ZiPS, or PECOTA) I don’t think Parra would look as good, because while his MILB results were good, they wouldn’t translate to the equivalent of an average major leaguer. Parra would still fare just fine…but it’s a caveat worth considering for anybody who has spent a good portion of the last three years not in the majors.

Also, cheese.

by Jeff Sackmann on Jul 17, 2008 6:28 PM CDT reply reply actions actions   0 recs

maybe you saw this, but

Jessica did it for the Mets, too.

At some point-probably not until next season, sadly-I think I can build this into minorleaguesplits, so you can see a current projection for every player every day of the season.

Also, cheese.

by Jeff Sackmann on Jul 17, 2008 7:07 PM CDT to parent up reply reply actions actions   0 recs

cool, thanks.

David Appelman’s working on figuring out how to code a daily updated Marcel forecast into Fangraphs, too.

by Sky Kalkman on Jul 17, 2008 7:20 PM CDT to parent up reply reply actions actions   0 recs

with the data presentation he has...

it should be really easy. it actually wouldn’t be that hard for me at MLS, either, but it would require harnessing a bunch of data I don’t yet have in the same place. and it would require a bunch of my time, which isn’t exactly available in abundance.

Also, cheese.

by Jeff Sackmann on Jul 17, 2008 7:44 PM CDT to parent up reply reply actions actions   0 recs

Nice work

As a side note/statistical anomaly, Fielder this year has 15 HRs at home and 3 on the road.

And neck size to baby eating ratio.

by Jordan M on Jul 17, 2008 11:42 PM CDT reply reply actions actions   0 recs

You know what goes well with offensive projections?

Defensive projections. It’s simply a weighted average of 2005-2008 zone rating data, with a little regression to the mean thrown in. Plays and Runs are presuming a full season’s of chances, not the chances published per player.

by cwyers on Jul 18, 2008 12:37 AM CDT reply reply actions actions   1 recs

Thanks Colin

I’m going to use Craig Counsell as a proxy for Alcides Escobar here, simply to illustrate how much swapping out Escobar for Hardy would improve the team defensively.

Counsell, according to Colin’s ratings, would make 6.85 extra plays per 161 at-bats, or 13.87 extra plays per Hardy’s 326 chances. Over those same 326 chances, Hardy would make 8.51 less plays than average. The run value of those eight and and a half lost plays is (negative) 6.41, while Counsell’s almost fourteen extra plays net 10.44 runs—that’s a difference of almost 17 runs between the two players, meaning Whitefish Bay’s finest has a glove almost two wins better than James Jerry.

BCB's "very own marginally deserving all-star!"

by battlekow on Jul 18, 2008 5:40 PM CDT to parent up reply reply actions actions   0 recs

Runs are prorated out to a full season's playing time...

...on the spreadsheet, not to the chances listed. (Chances are balls in zone – in this case they’re just an artifact of the weighted averages, and not a projection of playing time.)

Really, looking at the chart, Weeks is the guy who you’d replace with Counsell. I’d have to check, but can’t Counsell hit as well as Weeks has this year?

by cwyers on Jul 18, 2008 10:17 PM CDT to parent up reply reply actions actions   0 recs

Ah, thanks for the correction

Either way, the difference is large between Hardy and Counsell, who I am assuming is a fairly good defensive comp for Escobar.

BCB's "very own marginally deserving all-star!"

by battlekow on Jul 18, 2008 10:28 PM CDT to parent up reply reply actions actions   0 recs

Rickie

.247 batting with an OBP of .357

I hope so. Given Marcel’s stated accuracy, maybe yes, maybe no.

by ol Pete on Jul 18, 2008 10:19 AM CDT reply reply actions actions   0 recs

Haha, awesome
Battlekow at Brew Crew Ball put together a projection of each player on the Brewers using the Marcel system. It’s a fine system to use if one expects the players to perform exactly how they did in the first half, but it does not take trends into example at all. What about Dave Bush’s sub-3.00 ERA since May? Nope. Rickie Weeks’ career OBP above .360 after July? Nope. Manny Parra gaining more and more confidence with every start? Not a chance.
Who wants to take a guess on which is more predictive: Manny Parra’s pitching line over the last two years, or a blogger’s impression of his confidence? Anyone? Bueller?

BCB's "very own marginally deserving all-star!"

by battlekow on Jul 18, 2008 5:44 PM CDT reply reply actions actions   0 recs

hilarious

“It’s a fine system to use if one expects the players to perform exactly how they did in the first half, but it does not take trends into example at all.”

One, the point is that Marcel most certainly does not expect players to perform exactly how they did in the first half. Two, ignoring trends is a good thing. A GREAT thing.

by Sky Kalkman on Jul 19, 2008 4:19 PM CDT to parent up reply reply actions actions   0 recs

Marcel does not ignore trends.

Marcel considers this year’s data more to be more important than last year’s.

I’ve done day-by-day Marcels in the past (search my archive on THT), it generally turns out the same as the year-by-year Marcels.

Children, until we have taught them better, will be perfectly happy with a seasonal round of games in which conkers succeeds hopscotch.

by salb918 on Jul 22, 2008 9:16 AM CDT to parent up reply reply actions actions   0 recs

Comments For This Post Are Closed


User Tools

Brew Crew Ball is dedicated to providing a friendly atmosphere for intelligent Brewer conversation. Click here to view our Posting Guide and Community Guidelines.
Start posting about the Brewers »

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

FanPosts

Community blog posts and discussion.

Recent FanPosts

U8xcikxxuei8lvi_small
Rumorville: Corey Hart
Ndnca2ybu96ca2zf430caal7kyvcawcctckcaqauabwcahv6yhfcaf3osgpcalt1mjmca8o7n6acakmcz1pcalalgz7camdo2j0caiy8i01camu1gi6calj3xtkcabyqnapcalwwmlgcaic4tau_small
Braves fan here
Newavatar_small
Game Thread #80a
Newavatar_small
Game Thread #79a
Mark-renton_small
Suppan makes it hard to hate him
Cowswithguns_small
Draft Pick Signings [Updated 7/1]
Turtle_small
Rumorville: Brandon Backe
Cowswithguns_small
Brewers sign Dominican OF Jose Pena for $400K
Dscf0051_small
Curtain Calls
Sixtocard_small
Lets Trade for Ian Snell

Post_icon New FanPost All FanPosts Carrot-mini

Featured Poll

Poll
Admit it. Before the season you thought Casey McGehee would be...

  442 votes | Results

42 - 38

1

Lost 3

82

NL Central Standings

W L PCT GB STRK
St. Louis 44 38 .536 0 Won 3
Milwaukee 42 38 .525 1 Lost 3
Chicago 39 38 .506 2.5 Won 3
Cincinnati 39 39 .500 3 Lost 1
Houston 38 40 .487 4 Lost 1
Pittsburgh 37 43 .462 6 Won 1

(updated 7.4.2009 at 10:31 AM CDT)

FanShots

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

Recent FanShots

The Brewers are partnering with the University of Wisconsin-Milwaukee's...
Probably applicable right now.
July 11th Brewers Block Party
Go Cubs Go Parody
"He could be in the big leagues this year, and in the end, I could see him...
Jeff Suppan eBay Auction
Former Brewer note: TGJr
Rumored 2003 Steroid List (UPDATED)
Cardinals get DeRosa
Taylor Green to the DL

Post_icon New FanShot All FanShots Carrot-mini


Moderators

U8xcikxxuei8lvi_small roguejim

Mordecai_brown_small Jeff Sackmann

Cowswithguns_small battlekow

Newavatar_small KLSnow

Turtle_small TheJay

Communist_party_small Jordan M

Contributors

Dsci0355_small kirbir

Picture_069_small tristarscoop

Braun-fielder-gamel_small BrewHaHeather

Official Partner of Yahoo! Sports