Do you like Google Docs more than Excel?

No, I like excel better. However, I just bought the new microsoft office about 3 weeks ago and this document was created prior to that purchase. Tell you what, for a free speadsheet though, I have no complaints about google docs.

Thanks for sharing bobby, great stuff! My initial question is that if it includes the offensive production from the home team that it is going to be skewed towards their batting productivity, no? I think it would be more accurate to only take the average of runs/HR/Hits/2B from away teams throughout the season. Also, I would ask how you wound up at the multipliers you did for each stat?

How did you arrive at those multipliers? They seem kind of random. No accounting for 3Bs? HRs worth 6 times a 2B (2 for HR + 1 for run)?

Also, how did you account for the difference in home line-ups? Basically, I would expect the Yankees’ line-up to hit more HRs than the Padres’ line-up no matter what park they were in, so it seems like this would help make the Yankees’ new stadium look like it’s even more hitter-friendly than Petco even though a lot of that has to do with the fact that the lowly Padres are the ones swinging in Petco while the mighty Yankees are the ones bombing the Bronx. Maybe you can combine all the teams in some statistical manner in a neutral site to allow a standard to be established?

I’m also curious about the multipliers…but then again at first glance it seems fairly accurate. Padres and Mariners toward the bottom, Rockies, CWS, Toronto towards the top. Those are all parks I think of as being friendly or really unfriendly.

Honestly I cannot remember where I came up with those multipliers. I beleive I created this spreadsheet in Feb. and I do have a bad memory. Either way, I do feel like the results are fairly accurate given the historical data of park factors. Anyhow, you guys are welcome to tweak it and find a system you like. Change tha multipliers to what you think they should be. I do know that I didn’t include triples because I feel that triples have more to do with the hitters running ability then it does the hitters placement of the ball within the park.

Eh, using FanGraphs’ historical speed data, you’ll find that the fastest guy != the most triples. Certain parks are more friendly to triples and certain guys are better at placing the ball where it needs to go to give them a triple. Speed’s useful, but not the deciding factor.

We’re discussing this in FD chat right now, but this link is a good comparison from ESPN:

http://espn.go.com/mlb/stats/parkfactor/_/year/2010

It looks like Bob’s outcomes are pretty accurate, and similar to ESPNs. I wonder if theres a way we could take this and apply it to our Daily Optimal projections…

I was just saying that the worst park is only 1/2 a run per game different from the best park and to me, that really has no impact on who I am picking unless I am really looking for a tie breaker between two players. Also think sometimes, some of us can be very guilty of looking too deeply into things in regards to our player selection.

You read that chart and concluded it’s “only 1/2 a run per game different”? And you’re our stats guy?

Take from it what you want. However, I am not your anything though. I offered some of my material that I like to look at from time to time, you can take it or leave it.