MLB Ballpark data

[TheKT]

Hey all, I've recently started going to school again after a long hiatus. Well one of my first classes was an "Intro to MS Office" course. Well durring the Excell portion of the class, one of our assignments was to make a spreadsheet using several formulas and styles, what it covered was compleatly up to us. I decided to do mine on MLB ballparks, mainly looking at the distances to the fences and how the distance relates to their HR Ballpark Factor.

https://spreadsheets0.google.com/spreadsheet/ccc?hl=en_US&key=tF3a3XcMY-hTDikJKZZFNbg&authkey=CJi9jrIN&hl=en_US#gid=0

Here it is, it's not the worlds greatest by any stretch, I'm sure any number of you could make one that was 100x better in half the time, but I'm proud of it.

Anyway, I listed all the teams and their parks along with the distance to all of the outfield fences* then I took an average of all of a particular parks distances and used that as my basis for how big each ballpark is. Then I added in their HR Park factor, averaged over the last 3 years from espn's ratings. The numbers highlighted in green are smaller than average distances and a HRPF of greater than 1, and the red highlighted numbers are higher than average distances and a HRPF less than 1

Some of the data is pretty cool to see, so check it out if you want and let me know what you think.

*I got my ballpark dimensions from Wikipedia, so they might not be 100% accurate.

[yougo1000]

Re: MLB Ballpark data

That's better than I can do.

[thaSLAB]

I agree, that's pretty good (and interesting) - so when can we expect the version that takes into account wall heights?

I'm joking, of course :thumbsup: very good stuff KT!


Sent from my PC36100 using Tapatalk

[Trevytrev11]

Re: MLB Ballpark data

Just a heads up:

Check your min/max formulas when you calculate your shortest/longest porches. Probaly won't change your data, but your ranges aren't consistant.

Your data is from row 2 - 31, but your min forumula goes from 1-30 and your max from 3-32. Your average is right.

As a hint, You can use $ in front of your rows to lock your ranges, so that when you copy across or down you hold the range steady.

Sorry...I work on spreasheets all day.

Anyway, interesting data for sure. No surpise the AL East has the shortest average fences with NY and Boston's short porches.