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.