My Spreadsheet Spits out Something Ridiculous

Right Field BleachersCorrespondent IDecember 28, 2008

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 SlotPOSBestLHPRunsPOSBestRHPRuns 
. TOTAL326.71 TOTAL533.2 
  PER GAME6.05 PER GAME4.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.