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.