My Spreadsheet Spits out Something Ridiculous

Use your ← → (arrow) keys to browse more stories
My Spreadsheet Spits out Something Ridiculous

I have finally figured out everything I need to show the results for this post, and the results kind of surprised me.

You can see everything in this spreadsheet.

Here are the lineups that it came up with:

Lineup Slot POS BestLHP Runs POS BestRHP Runs  
1 LF Braun 37.37 2B Counsell 55.01  
2 2B Durham 62.28 1B Fielder 90.75  
3 1B Fielder 27.15 CF Cameron 57.4  
4 RF Kapler 48.03 3B Branyan 90.26  
5 SS Hardy 44.21 LF Braun 75.03  
6 CF Cameron 41.65 RF Kapler 53.85  
7 3B Hall 35.75 SS Hardy 52.92  
8 SP/PH SP/PH 9.77 SP/PH SP/PH 19.54  
9 C Kendall 20.5 C Kendall 38.44  
.   TOTAL 326.71   TOTAL 533.2  
    PER GAME 6.05   PER GAME 4.94  

Obviously this is not realistic at all, but I think it is kind of interesting to see what these role players could have done in a perfect world.  Clearly, these lineups are not the kind of lineups that would hold up over the course of the season.  However, I think it does show something interesting—the importance of OBP.  The guys with the higher OBPs are the guys that you see higher in the lineup, and are the guys that are just plain better overall.  That is one of the problems with the Brewers lineup as it is—when players are getting on base, the high SLG guys will knock them in consistently, but when guys are not getting on in front of them, they can go completely anemic.

The best lineup posted in the comments was Jared’s, and the worst was Kevin’s.  Kendall’s OBP only looks good compared to his SLG, Kevin.

Follow Milwaukee Brewers from B/R on Facebook

Follow Milwaukee Brewers from B/R on Facebook and get the latest updates straight to your newsfeed!

Milwaukee Brewers

Subscribe Now

By signing up for our newsletter, you agree to our Terms and Privacy Policy.

Thanks for signing up.