Useless OOTP4 Spreadsheet Pack version 1

Jason Moyer · 06-22-2002, 06:49 PM

Ok, I have a collection of spreadsheets in a nearly releasable form. If anyone would be interested in hosting these on their website, please let me know via a personal message so I can send them to you sometime today or tommorrow. I just need to tweak a few things in the example spreadsheets I'm including with most of these, fix some number formatting issues here and there, and they're good to go.

If you have no idea what I'm talking about, don't worry, these probably won't interest you at all.

These were developed in my spare time as tools that I like to use to get more statistical satisfaction out of my fictional leagues, but they may be of interest to any stathead who is constantly making spreadsheets for things or just wants stuff to play around with.

Here is what I currently have in the readme file:

--------------------------
Useless OOTP4 Spreadsheet Pack version 1
Assembled by Jason Moyer 6/23/02
Distribute At Your Leisure

This zip file contains:

1. Gold Glove Calculator v0.1

My first attempt at taking the available defensive stats in OOTP4 and adjusting them for team and league performance in an attempt to gauge defensive value.

2. HOF Standards Calculator - Hitting v0.2

I've taken the spreadsheet that I've used to calculate Bill James HOF Standards and modified it so that the standards themselves are adjustable. You can now increase the base factors for hits, average, homeruns, etc in order to create standards that are more applicable for the scoring output in the league you're running. Even suggests which automatic qualifiers you should use in your league settings.

3. HOF Standards Calculator - Pitching v0.2

Similar to the calculator for hitters, with adjustments available for things like average ERA, games started (to adjust for rotation size), and so forth.

4. League Finances Calculator v0.1

Allows you to enter a city, the metropolitan population, and the average attendance at games in that city and attempts to calculate appropriate market size, fan loyalty, fan interest, and TV contract values based on that information. Recommended for leagues with "fixed" financials (i.e. with contract lengths set to indefinite lengths to model non-changing markets). They'll work fine with normal contract lengths as well, but I find OOTP's increasing of market size to be a bit aggressive for my taste. I'm sure Milwaukee isn't going to become a boom town capable of supporting a better financed team within a 2-3 year period.

5. League Totals Calculator v0.1

A quick and dirty tool for calculating recommended league totals based on the goals of your league, the era setting used the previous season, and the recalculated league totals based on simmed games from the previous season.

6. Short Form Win Shares Calculator v0.1

Calculates Short Form Win Shares.

7. Win Shares Calculator v0.1

The motherlode. While I've verified that the formulas in this spreadsheet are 100% accurate by using the example data given in Bill James wonderful book "Win Shares", this spreadsheet is by far the least user friendly of the bunch, and for that I apologize. It is fairly impossible to calculate Win Shares accurately for an OOTP league due to limitations in the reported statistics, but those of you with too much time on your hands can have fun messing about with this spreadsheet anyway

Version history:

1. Putting this out on the net for the first time. Probably numerous issues in terms of logic, accuracy, and user friendiness.

Planned updates:

1. Inclusion of pitchers in GG calculator. I need to do more research to determine a correlation between a pitcher's range and their statistics as collected in OOTP, assuming on exists.

2. Fine tuning of the HOF Calculators. They are very rough and not entirely logical in their present state. Also, they do not currently allow for adjustments based on position. I'm not entirely certain this is useful in OOTP4 since players at different positions age at the same rate (a catcher can play 2000+ games as easily as a first baseman) but I'll add something to address this in v0.3.

3. Inclusion of recommended merchandising revenue in the League Finances Spreadsheet. In all honesty, this is just something I've overlooked and I haven't spent much time thinking of an appropriate way of calculating it.

4. Complete redesign of the layout of the Win Shares spreadsheet. I want to combine formulas and simplify this as much as possible in order to make the process of gathering/inputting the required data to be as smooth and painless as possible. In the current state it's outlined more or less in the same way as the book, which isn't necessarily the most efficient way to do things in a practical sense.

Other notes:

Feel free to modify, appropriate, or distribute these spreadsheets however you like. If something seems incredibly wrong to you, let me know. If anything, I'm always up for a good argument. I would highly recommend not using these formulas in any utilities until they've been polished and any errors are corrected.

If you have suggestions for future spreadsheets that you don't feel like taking the time to compile, or you'd just like to complain about the spreadsheets included here, shoot me an email at jmoyer@chemlab.org.

Thanks:

Bill James for creating most of the concepts and formulas that these spreadsheets are based on.

Markus H and .400 Software for creating the only baseball simulation which is worthy of deep statistical analysis.

Anyone who finds these remotely useful or interesting.

Ankit · 06-22-2002, 11:17 PM

I can host them but I don't have a web page just space for files. You can create one for the file though. My e-mail is in my profile.

Mel_Ott · 06-24-2002, 03:13 AM

bump

jblaze03fuel · 06-24-2002, 03:27 AM

sounds entertaining....although i dont know 100% of what your talking about, i have a pretty well idea. would it be a good idea to use this in my real players with 2002rolen rosters league? with a draft?

Jason Moyer · 06-24-2002, 06:03 AM

Read the subject. They're not useful to anyone.

And, uh, yeah, I'll have them ready to go soon. I've found a few things I'm not really happy with in a few of the spreadsheets and I'd like to hammer out some fixes before I post the zip anywhere. Instead of just having someone host them, I'll stick the zip file somewhere for a few days so everyone who wants them can grab them and do whatever they want with them. The zip should be around 1-1.5mb, altho I'm not 100% certain how large they will be in .xls format.

Jason

Scott Vibert · 06-24-2002, 09:49 AM

If its small enough you should be able to attach your .zip file here.

Jason Moyer · 06-24-2002, 09:58 AM

Are you saying it's tiny?!?

Jason

Malleus Dei · 06-24-2002, 11:34 AM

IMO you should send these to www.baseballcentral.com for posting.

Jason Moyer · 06-24-2002, 11:50 AM

Wouldn't they likely have a problem with the Win Shares spreadsheets? I'm not using any text from the book but I dunno if the formulas can be published without permission from BJ. And even if they could, bsc seems sketchy on that sort of thing.

I'll definitely stick them there if I can.

Jason (who just finished reading an article on ESPN.com that compared Tony LaRussa to Gene Mauch...ew)

lfj · 07-27-2002, 02:37 PM

Jason,

Were your spreadsheets ever made available for download? I am interested in your calculations for gold glove (along with the others). If not, would you be willing to e-mail them to me at jjulrich@lycos.com?

Thanks

lfj

Crapshoot · 07-27-2002, 04:15 PM

same here... these look like interesting sheets to play around with...

fantom1979 · 07-27-2002, 04:33 PM

these speadsheets sound very interesting and i would love to have a copy of it when its available. I think you underestimate the interest for these utilites.

Dwolfson20 · 07-27-2002, 05:35 PM

This stuff does sound very interesting... it's been over a month since the original post, so I wonder what happened.

CMH · 07-27-2002, 07:15 PM

question....

will this download automatically take the fielding stats of every player in your league and then set up a spreadsheet giving the user information on who might be a gold glover?

i'm sort of confused as to how this works...

lfj · 07-29-2002, 10:36 AM

bump...Jason?

Jason Moyer · 07-29-2002, 10:56 AM

Hey guys still working on this stuff.

I'm at work now so I don't have the spreadsheets handy but I'll post a current list of what I'm planning on including. Full win shares will *not* be included in all likelihood because it's not possible to calculate them in any baseball sim that I'm aware of. I will figure out what we need statistically in order to do this and pester Markus on the suggestions board so we can do this in OOTP5.

I'll post more later this evening, just keep bugging me. The advanced defensive statistics spreadsheet is, imho, the most useful of all of them.

To answer YankeePride's question, you will need to enter the data by hand or copy/paste it from a CSV/XML export using Pierre's reporting utilities. All the spreadsheet does is automate the calculation of rate statistics.

Jason

lfj · 07-29-2002, 12:59 PM

Thanks...looking forward to it! I've just finished my first historic season in 1903 and want to award some Gold Gloves (I formulated my own calculation based on some of the basic defensive statistics, but would like to elaborate on them if possible).

lfj · 08-07-2002, 01:58 PM

Jason,

I hate to keep bugging you, but you asked me to...any luck in hosting or releasing these spreadsheets of yours?

As you stated earlier, the advanced defensive statistics one sounds the most interesting.

Jason Moyer · 08-08-2002, 02:46 AM

Ugh, yeah, these will be posted somewhere soon. Still been a bit busy with my new job and whatnot.

Try to remind me Thursday afternoon.

Jason

lfj · 08-08-2002, 03:59 PM

No problem Jason...I understand how things like real-life jobs and families can get in the way of OOTP (I haven't been able to find the necessary time to conduct my off-season agenda in a week).

By the time the kids get to bed and it's time to relax, have a cold one, turn on the ballgame, fire up OOTP, analyze my roster, ponder trades...the next thing I know the alarm is going off for me to get up to go to work again.

Your advanced defensive statistics would give me something to look at during lunch...it seems to be the only quiet hour I have during the day.

Thanks much!

lfj

06-22-2002, 06:49 PM	#1
Jason Moyer Hall Of Famer Join Date: Feb 2002 Location: Pittsburgh Posts: 5,088	Useless OOTP4 Spreadsheet Pack version 1 Ok, I have a collection of spreadsheets in a nearly releasable form. If anyone would be interested in hosting these on their website, please let me know via a personal message so I can send them to you sometime today or tommorrow. I just need to tweak a few things in the example spreadsheets I'm including with most of these, fix some number formatting issues here and there, and they're good to go. If you have no idea what I'm talking about, don't worry, these probably won't interest you at all. These were developed in my spare time as tools that I like to use to get more statistical satisfaction out of my fictional leagues, but they may be of interest to any stathead who is constantly making spreadsheets for things or just wants stuff to play around with. Here is what I currently have in the readme file: -------------------------- Useless OOTP4 Spreadsheet Pack version 1 Assembled by Jason Moyer 6/23/02 Distribute At Your Leisure This zip file contains: 1. Gold Glove Calculator v0.1 My first attempt at taking the available defensive stats in OOTP4 and adjusting them for team and league performance in an attempt to gauge defensive value. 2. HOF Standards Calculator - Hitting v0.2 I've taken the spreadsheet that I've used to calculate Bill James HOF Standards and modified it so that the standards themselves are adjustable. You can now increase the base factors for hits, average, homeruns, etc in order to create standards that are more applicable for the scoring output in the league you're running. Even suggests which automatic qualifiers you should use in your league settings. 3. HOF Standards Calculator - Pitching v0.2 Similar to the calculator for hitters, with adjustments available for things like average ERA, games started (to adjust for rotation size), and so forth. 4. League Finances Calculator v0.1 Allows you to enter a city, the metropolitan population, and the average attendance at games in that city and attempts to calculate appropriate market size, fan loyalty, fan interest, and TV contract values based on that information. Recommended for leagues with "fixed" financials (i.e. with contract lengths set to indefinite lengths to model non-changing markets). They'll work fine with normal contract lengths as well, but I find OOTP's increasing of market size to be a bit aggressive for my taste. I'm sure Milwaukee isn't going to become a boom town capable of supporting a better financed team within a 2-3 year period. 5. League Totals Calculator v0.1 A quick and dirty tool for calculating recommended league totals based on the goals of your league, the era setting used the previous season, and the recalculated league totals based on simmed games from the previous season. 6. Short Form Win Shares Calculator v0.1 Calculates Short Form Win Shares. 7. Win Shares Calculator v0.1 The motherlode. While I've verified that the formulas in this spreadsheet are 100% accurate by using the example data given in Bill James wonderful book "Win Shares", this spreadsheet is by far the least user friendly of the bunch, and for that I apologize. It is fairly impossible to calculate Win Shares accurately for an OOTP league due to limitations in the reported statistics, but those of you with too much time on your hands can have fun messing about with this spreadsheet anyway Version history: 1. Putting this out on the net for the first time. Probably numerous issues in terms of logic, accuracy, and user friendiness. Planned updates: 1. Inclusion of pitchers in GG calculator. I need to do more research to determine a correlation between a pitcher's range and their statistics as collected in OOTP, assuming on exists. 2. Fine tuning of the HOF Calculators. They are very rough and not entirely logical in their present state. Also, they do not currently allow for adjustments based on position. I'm not entirely certain this is useful in OOTP4 since players at different positions age at the same rate (a catcher can play 2000+ games as easily as a first baseman) but I'll add something to address this in v0.3. 3. Inclusion of recommended merchandising revenue in the League Finances Spreadsheet. In all honesty, this is just something I've overlooked and I haven't spent much time thinking of an appropriate way of calculating it. 4. Complete redesign of the layout of the Win Shares spreadsheet. I want to combine formulas and simplify this as much as possible in order to make the process of gathering/inputting the required data to be as smooth and painless as possible. In the current state it's outlined more or less in the same way as the book, which isn't necessarily the most efficient way to do things in a practical sense. Other notes: Feel free to modify, appropriate, or distribute these spreadsheets however you like. If something seems incredibly wrong to you, let me know. If anything, I'm always up for a good argument. I would highly recommend not using these formulas in any utilities until they've been polished and any errors are corrected. If you have suggestions for future spreadsheets that you don't feel like taking the time to compile, or you'd just like to complain about the spreadsheets included here, shoot me an email at jmoyer@chemlab.org. Thanks: Bill James for creating most of the concepts and formulas that these spreadsheets are based on. Markus H and .400 Software for creating the only baseball simulation which is worthy of deep statistical analysis. Anyone who finds these remotely useful or interesting. __________________ "I pretty much popped everything cold turkey. We were doing steroids they wouldn't give to horses." -- Tom House "I was very fortunate to have a pitching coach by the name of Tom House...Tom, I really miss those days that we spent in the weight room and out on the field working together." -- Nolan Ryan's HoF Induction Speech

06-22-2002, 11:17 PM	#2
Ankit All Star Reserve Join Date: Feb 2002 Location: Singapore Posts: 603	I can host them but I don't have a web page just space for files. You can create one for the file though. My e-mail is in my profile. __________________

06-24-2002, 03:13 AM	#3
Mel_Ott Registered User Join Date: Apr 2002 Location: Where the deer and the antelope play Posts: 924	bump __________________ jgross's worst nightmare!!!!111 Owner, Sin City Swingers, OBTL

06-24-2002, 06:03 AM	#5
Jason Moyer Hall Of Famer Join Date: Feb 2002 Location: Pittsburgh Posts: 5,088	Read the subject. They're not useful to anyone. And, uh, yeah, I'll have them ready to go soon. I've found a few things I'm not really happy with in a few of the spreadsheets and I'd like to hammer out some fixes before I post the zip anywhere. Instead of just having someone host them, I'll stick the zip file somewhere for a few days so everyone who wants them can grab them and do whatever they want with them. The zip should be around 1-1.5mb, altho I'm not 100% certain how large they will be in .xls format. Jason __________________ "I pretty much popped everything cold turkey. We were doing steroids they wouldn't give to horses." -- Tom House "I was very fortunate to have a pitching coach by the name of Tom House...Tom, I really miss those days that we spent in the weight room and out on the field working together." -- Nolan Ryan's HoF Induction Speech

06-24-2002, 09:58 AM	#7
Jason Moyer Hall Of Famer Join Date: Feb 2002 Location: Pittsburgh Posts: 5,088	Are you saying it's tiny?!? Jason __________________ "I pretty much popped everything cold turkey. We were doing steroids they wouldn't give to horses." -- Tom House "I was very fortunate to have a pitching coach by the name of Tom House...Tom, I really miss those days that we spent in the weight room and out on the field working together." -- Nolan Ryan's HoF Induction Speech

06-24-2002, 03:27 AM	#4
jblaze03fuel All Star Reserve Join Date: Apr 2002 Posts: 920	sounds entertaining....although i dont know 100% of what your talking about, i have a pretty well idea. would it be a good idea to use this in my real players with 2002rolen rosters league? with a draft?

06-24-2002, 09:49 AM	#6
Scott Vibert Hall Of Famer Join Date: Dec 2001 Location: My Computer Posts: 8,210	If its small enough you should be able to attach your .zip file here.

06-24-2002, 11:50 AM	#9
Jason Moyer Hall Of Famer Join Date: Feb 2002 Location: Pittsburgh Posts: 5,088	Wouldn't they likely have a problem with the Win Shares spreadsheets? I'm not using any text from the book but I dunno if the formulas can be published without permission from BJ. And even if they could, bsc seems sketchy on that sort of thing. I'll definitely stick them there if I can. Jason (who just finished reading an article on ESPN.com that compared Tony LaRussa to Gene Mauch...ew) __________________ "I pretty much popped everything cold turkey. We were doing steroids they wouldn't give to horses." -- Tom House "I was very fortunate to have a pitching coach by the name of Tom House...Tom, I really miss those days that we spent in the weight room and out on the field working together." -- Nolan Ryan's HoF Induction Speech

07-27-2002, 02:37 PM	#10
lfj Minors (Single A) Join Date: Dec 2001 Posts: 69	Jason, Were your spreadsheets ever made available for download? I am interested in your calculations for gold glove (along with the others). If not, would you be willing to e-mail them to me at jjulrich@lycos.com? Thanks lfj

07-27-2002, 04:15 PM	#11
Crapshoot Hall Of Famer Join Date: Feb 2002 Location: watching: DArwin's missing link in action Posts: 3,112	same here... these look like interesting sheets to play around with...

07-27-2002, 04:33 PM	#12
fantom1979 Hall Of Famer Join Date: Jul 2002 Location: Detroit, MI Posts: 3,498	these speadsheets sound very interesting and i would love to have a copy of it when its available. I think you underestimate the interest for these utilites. __________________

07-27-2002, 05:35 PM	#13
Dwolfson20 Hall Of Famer Join Date: Mar 2002 Location: Not St. Louis Posts: 2,872	This stuff does sound very interesting... it's been over a month since the original post, so I wonder what happened. __________________

07-27-2002, 07:15 PM	#14
CMH Hall Of Famer Join Date: Feb 2002 Posts: 5,057	question.... will this download automatically take the fielding stats of every player in your league and then set up a spreadsheet giving the user information on who might be a gold glover? i'm sort of confused as to how this works...

07-29-2002, 10:36 AM	#15
lfj Minors (Single A) Join Date: Dec 2001 Posts: 69	bump...Jason?

07-29-2002, 10:56 AM	#16
Jason Moyer Hall Of Famer Join Date: Feb 2002 Location: Pittsburgh Posts: 5,088	Hey guys still working on this stuff. I'm at work now so I don't have the spreadsheets handy but I'll post a current list of what I'm planning on including. Full win shares will not be included in all likelihood because it's not possible to calculate them in any baseball sim that I'm aware of. I will figure out what we need statistically in order to do this and pester Markus on the suggestions board so we can do this in OOTP5. I'll post more later this evening, just keep bugging me. The advanced defensive statistics spreadsheet is, imho, the most useful of all of them. To answer YankeePride's question, you will need to enter the data by hand or copy/paste it from a CSV/XML export using Pierre's reporting utilities. All the spreadsheet does is automate the calculation of rate statistics. Jason __________________ "I pretty much popped everything cold turkey. We were doing steroids they wouldn't give to horses." -- Tom House "I was very fortunate to have a pitching coach by the name of Tom House...Tom, I really miss those days that we spent in the weight room and out on the field working together." -- Nolan Ryan's HoF Induction Speech

07-29-2002, 12:59 PM	#17
lfj Minors (Single A) Join Date: Dec 2001 Posts: 69	Thanks...looking forward to it! I've just finished my first historic season in 1903 and want to award some Gold Gloves (I formulated my own calculation based on some of the basic defensive statistics, but would like to elaborate on them if possible).

08-07-2002, 01:58 PM	#18
lfj Minors (Single A) Join Date: Dec 2001 Posts: 69	Jason, I hate to keep bugging you, but you asked me to...any luck in hosting or releasing these spreadsheets of yours? As you stated earlier, the advanced defensive statistics one sounds the most interesting.

08-08-2002, 02:46 AM	#19
Jason Moyer Hall Of Famer Join Date: Feb 2002 Location: Pittsburgh Posts: 5,088	Ugh, yeah, these will be posted somewhere soon. Still been a bit busy with my new job and whatnot. Try to remind me Thursday afternoon. Jason __________________ "I pretty much popped everything cold turkey. We were doing steroids they wouldn't give to horses." -- Tom House "I was very fortunate to have a pitching coach by the name of Tom House...Tom, I really miss those days that we spent in the weight room and out on the field working together." -- Nolan Ryan's HoF Induction Speech

08-08-2002, 03:59 PM	#20
lfj Minors (Single A) Join Date: Dec 2001 Posts: 69	No problem Jason...I understand how things like real-life jobs and families can get in the way of OOTP (I haven't been able to find the necessary time to conduct my off-season agenda in a week). By the time the kids get to bed and it's time to relax, have a cold one, turn on the ballgame, fire up OOTP, analyze my roster, ponder trades...the next thing I know the alarm is going off for me to get up to go to work again. Your advanced defensive statistics would give me something to look at during lunch...it seems to be the only quiet hour I have during the day. Thanks much! lfj