Batter Comparison Tool (Spreadsheet)

Slant · 07-21-2003, 11:47 PM

This spreadsheet does three things.

First, it takes up to three years of batting statistics and removes the park factors to put all batters on equal footing for comparison. See whether that power hitter from Colorado deserved the MVP award.

Second, it applies a park factor to all batters. See if that new power lefty will thrive in Fenway. Should the Braves acquire a power righty or a contact lefty?

Third, it condenses three years of statistics to one year's worth based on custom weights. This can be used to evaluate talent or consistency, or to predict future performance.

All the info you need is on the first sheet of the spreadsheet.

There are two players programmed in as examples, A-Rod and Bonds. The final page shows their predicted statistics for 2003 if they played half their games in Coors field, with 2001 statistics weighted twice as heavily as 2000, and 2002 statistics weighted three times as heavily as 2001.

Let's just say we would have some new records if this had come true...

Note: This file has macros (I think). I promise there are no viruses which would harm your computer, but nevertheless you are using this at your own risk. If you are nervous, run a virus scanner on it.

Any questions, comments, or concerns - please ask.

-HH

PS The file is just a tiny bit too big to post

If anyone wants to host this, I'll email it to them and link it here so you can can check it out.

Later

adventureran · 07-22-2003, 12:03 AM

If you send it to me at adventureran@ransplace.com, I'll put it up on OOTPLinks.com for all.

Slant · 07-22-2003, 12:37 AM

Quote:

Originally posted by adventureran
If you send it to me at adventureran@ransplace.com, I'll put it up on OOTPLinks.com for all.

Sent.

Alan T · 07-22-2003, 07:27 AM

How does it figure out or use park factors in this spreadsheet? Does it automatically compute them for each park, or are they pre-programmed in based on RL parks, or do they use the OOTP park factor settings? Or D) None of the above

adventureran · 07-22-2003, 08:01 AM

OOTPLinks.com is down right now, so I have uploaded it to my site for now and will move it over later. You can find it HERE.

Enjoy!

Slant · 07-22-2003, 09:35 AM

Quote:

Originally posted by Alan T
How does it figure out or use park factors in this spreadsheet? Does it automatically compute them for each park, or are they pre-programmed in based on RL parks, or do they use the OOTP park factor settings? Or D) None of the above

You can manually enter any park factors you like, but it will not compute them for you. The defaults are the park factors from GeForce's Total Minors roster set. You can add an unlimited amount of park factors (well, actually, up to 17,576, because each needs its own unique three letter abbreviation), or change the existing ones any way you see fit. For example, in my solo league, I moved the Expos to Boston after the 2003 season, had them buy Fenway from the Red Sox, who built a top-of-the line stadium. BOS changed to BSA and MON to BSN and I added BSA and BSN park factors. (I left BOS and MON because the spreadsheet looks at three different years, and for two of those three years BOS and MON were still in existence.)

Slant · 07-22-2003, 09:36 AM

Quote:

Originally posted by Alan T
How does it figure out or use park factors in this spreadsheet? Does it automatically compute them for each park, or are they pre-programmed in based on RL parks, or do they use the OOTP park factor settings? Or D) None of the above

Thanks

Slant · 07-27-2003, 11:54 PM

anyone have any comments?

ctorg · 07-29-2003, 10:02 AM

Sounds cool. I'll download it and give it a try when I get a chance.

bsbll_n_mn · 07-29-2003, 10:25 AM

do we manually type player stats? or are the stats in the spreadsheet already? what format is this spreadsheet in?

sounds interesting

Slant · 07-29-2003, 12:22 PM

You have to type in name, team, games, at bats, hits, doubles, triples, home runs, walks, strikeouts, stolen bases, and caught stealing.

If I knew how to make the spreadsheet import from a Joe's Exporter CSV or html files, I would (anyone who wants to, go ahead).

the spreadsheet is in .xls format (Excel)

07-21-2003, 11:47 PM	#1
Slant Minors (Triple A) Join Date: Nov 2002 Location: Red Sox Nation Posts: 257	Batter Comparison Tool (Spreadsheet) This spreadsheet does three things. First, it takes up to three years of batting statistics and removes the park factors to put all batters on equal footing for comparison. See whether that power hitter from Colorado deserved the MVP award. Second, it applies a park factor to all batters. See if that new power lefty will thrive in Fenway. Should the Braves acquire a power righty or a contact lefty? Third, it condenses three years of statistics to one year's worth based on custom weights. This can be used to evaluate talent or consistency, or to predict future performance. All the info you need is on the first sheet of the spreadsheet. There are two players programmed in as examples, A-Rod and Bonds. The final page shows their predicted statistics for 2003 if they played half their games in Coors field, with 2001 statistics weighted twice as heavily as 2000, and 2002 statistics weighted three times as heavily as 2001. Let's just say we would have some new records if this had come true... Note: This file has macros (I think). I promise there are no viruses which would harm your computer, but nevertheless you are using this at your own risk. If you are nervous, run a virus scanner on it. Any questions, comments, or concerns - please ask. -HH PS The file is just a tiny bit too big to post If anyone wants to host this, I'll email it to them and link it here so you can can check it out. Later

07-27-2003, 11:54 PM	#8
Slant Minors (Triple A) Join Date: Nov 2002 Location: Red Sox Nation Posts: 257	anyone have any comments? __________________ Boiler Room Project

07-29-2003, 10:02 AM	#9
ctorg Global Moderator Join Date: Nov 2002 Location: Queens, NY Posts: 9,848	Sounds cool. I'll download it and give it a try when I get a chance. __________________ My music "When the trees blow back and forth, that's what makes the wind." - Steven Wright Fjord emena pancreas thorax fornicate marmalade morpheme proteolysis smaxa cabana offal srue vitriol grope hallelujah lentils

07-29-2003, 12:22 PM	#11
Slant Minors (Triple A) Join Date: Nov 2002 Location: Red Sox Nation Posts: 257	You have to type in name, team, games, at bats, hits, doubles, triples, home runs, walks, strikeouts, stolen bases, and caught stealing. If I knew how to make the spreadsheet import from a Joe's Exporter CSV or html files, I would (anyone who wants to, go ahead). the spreadsheet is in .xls format (Excel) __________________ Boiler Room Project

07-22-2003, 12:03 AM	#2
adventureran Major Leagues Join Date: Aug 2002 Location: Ohio Posts: 447	If you send it to me at adventureran@ransplace.com, I'll put it up on OOTPLinks.com for all.

07-22-2003, 07:27 AM	#4
Alan T All Star Starter Join Date: Mar 2002 Location: Mass. Posts: 1,963	How does it figure out or use park factors in this spreadsheet? Does it automatically compute them for each park, or are they pre-programmed in based on RL parks, or do they use the OOTP park factor settings? Or D) None of the above

07-22-2003, 08:01 AM	#5
adventureran Major Leagues Join Date: Aug 2002 Location: Ohio Posts: 447	OOTPLinks.com is down right now, so I have uploaded it to my site for now and will move it over later. You can find it HERE. Enjoy!

07-29-2003, 10:25 AM	#10
bsbll_n_mn Registered User Join Date: Apr 2003 Posts: 593	do we manually type player stats? or are the stats in the spreadsheet already? what format is this spreadsheet in? sounds interesting