League Total Modifiers - Spreadsheet

[NoOne]

New post coming soon... left the original thread just for reference.



EDIT: the "Adjusted to 150,350AB" section has a bad formula. edit adjusted hits cell at top to be =AG19/($D19/$D$3). fill across that grey section. then select that top row of the grey area along with 1 empty line, then fill down to fix the entire table.

This isn't a "mod." so, i was unsure which forum was best. the zip file attached is 3 pieces. delete the extra .zip extension from the ones that have .z01 and .z02. the spreasheet was created with free apache openoffice calc.

This spreadsheet requires 3 csv data dump files from your game. you can get them through 2 methods:

1: go to almanac and setup yearly csv dump. you will find them in the your gamedirectory\data\saved games\league name.lg\dump

2: go to the database page in league/game settings. export data to csv. these will be in the league directory's import/export folder.

important notes for either method:

*** in the main ootp settings - make sure csv dumps are comma delimited.

*** when setting up the csv dump or manually exporting you can edit profile and/or configure csv dump depending on which method you are using. deselect all, then select 4 checkboxes named below. This will potentially save alot of wasted time.
"include headers...for columns"
"league_history_batting_stats"
"league_history_fielding_stats"
"league_history_pitching_stats"

*** these 3 csv files must be in the same directory as this attached spreadsheet. it should ask to "update" data from these files anytime you load the spreadsheet. also, under edit>links>"update," you can update it manually at anytime.

each time you want to use new data dumps, drag and drop the new batting, fielding, and pitching csv files to the directory your keep the spreadsheet. do not change the file names from default. if you did not include the headers for the columns, it will be all jacked up too.

How-to Use:

On the "Input" worksheet, you must enter the values/goals you wish to achieve. They have a yellow background. this is the only place you will edit a cell's contents.

avg/obp/slug/ops/era are merely aesthetic in nature - linked in "work" worksheet but merely as a reference value for you/me. The PCM table can be ignored too. go ahead and delete the pcm table if you want.

Do Not edit any other worksheet. Do not edit any field with a green background. Fields with a green background are outputs for your LTM modifiers.

any colors used in the "Work" worksheet are merely for aesthetic purposes. i did a simple min/max for each mod's related stat, if you'd like more information on the resulting range of values.

It is currently setup for 100 years of data starting on the 36th year (2015-2049 completed) of a simulation. if you don't mess with the first or last row of data, you can easily adjust this to start on any year and use as many years of data as you wish by inserting/removing entire rows and making use of the "Fill" function. when "Filling" make sure you highlight one row of data and one empty row. if this is greek to you, make use of google and openoffice's help resources. (if you need a different starting date, you will actually 'mess' with the first row of data - you should not have to do more than a 'fill' operation. if you are editing individual cells you are doing it wrong)

This spreadsheet will NOT suggest "Starter Pitcher's Stamina," "OF Assists" or Fielding errors by position.

don't use my data for your league. it most likley will not match up unless we have exactly the same league structure and settings.

One thing to note on use... don't try or expect to get your modifiers all perfect the first run. i usually do a 20-30yr short run to get some general ballpark figures before doing a 100+ year sim. a very simplified example: fielding % affects offense, but number of opportunities does not affect fielding %. so, you need to have fielding properly set up in order for other modifier suggestions to be of better use.

edit: sac fly and sac hits should probably be scaled to AB. other things should be scaled to games or batters faced, too. more changes could easily be made.

[NoOne]

okay, this one is slightly better. remember, this is not magic. you will not get your mods without effort. the spreadsheet is far from perfect. the suggestions are not caclulated as they should. the larger the suggested change the more innaccurate they are. within .010 they should be more than fine. also, if there is a large change suggested, i would take half the difference. some ltm influence others. so, suggested ltm's can change drastically if another LTM is not the same.

the instuctions work sheet and various comments should help a bit, but there is a steep learning curve to honing these LTM to the stat range you want.

here's what i got using it with a 28team, 156 game league ((28/30)(156/162) ~.8988 if you want to divide by that to see a 30t/162g value). *the avg/obp is not a range, it is a difference between the two. it shows min/max and average. there is a missing column because it is the difference of gdp and dp. i didn't do the difference per year in the data table, so no min/max on LiDP - which may not constitute all of dp-gidp.

my goal for the the minimum ERA was a bit higher, but don't get picky when you get close to your goals. i'm happy with the total range of ERA. a few ticks one way or the other is no big deal. e.g. there was nothign i could do with balks.. the average was either 90-100 or 165-170 and nothing in between.

if you choose to improve it, share with the forums. you can even say it's yours. it even shows a suggestion on the last worksheet how to automate a proper LTM Mod suggestion +/-.500(or any change really)

edit: ugh to .zip ext... could we get .ods added to the approved extensions?

[Rizon]

I have a modifiers spreadsheet I've been using since they were added. I might share it later today.

I've only had to use it for one of my leagues, all other leagues seem to work without it.

[RchW]

Originally Posted by Rizon

I have a modifiers spreadsheet I've been using since they were added. I might share it later today.

I've only had to use it for one of my leagues, all other leagues seem to work without it.

Me too. Been using one since v10 I think. It's very easy to tweak results so that you can create historical eras such as dominant pitching or HR environments. I do agree that large changes should be split. What I do is calculate my mods via the spreadsheet then use autocalc and tweak the autocalc LTM's based on my spreadsheet results. It's impressive how often many of the autocalc mods match my spreadsheet. I guess 90 and 70 seasons of data helps. I'v posted mine in a thread some time ago. I'll paste the link when I find it.

http://www.ootpdevelopments.com/boar...modifiers.html

This link is just another good thread. We can't have enough of these threads. LTM and LT tweaking can really help your league.

http://www.ootpdevelopments.com/boar...-league-2.html

[NoOne]

Originally Posted by RchW

Me too. Been using one since v10 I think. It's very easy to tweak results so that you can create historical eras such as dominant pitching or HR environments. I do agree that large changes should be split. What I do is calculate my mods via the spreadsheet then use autocalc and tweak the autocalc LTM's based on my spreadsheet results. It's impressive how often many of the autocalc mods match my spreadsheet. I guess 90 and 70 seasons of data helps. I'v posted mine in a thread some time ago. I'll paste the link when I find it.

http://www.ootpdevelopments.com/boar...modifiers.html

This link is just another good thread. We can't have enough of these threads. LTM and LT tweaking can really help your league.

http://www.ootpdevelopments.com/boar...-league-2.html

EDIT: added pictures, figured some would like to see before they download.

as far as tips/instructions, the spreadsheet contains a page with a suggested plan of attack - including making use of autocalc. if i forgot, the only thing i'd add to it is to get BABIP in line with hits ltm, before working on other offensive categories. it comes with a decent range of results.

if i were picky, i'd have centered mine a little differently... had i done things in the order i suggested i'd have been closer to my goal. i tried to pass that type of knowledge along.

in regard to spreadsheet construction: if you do this already, it's for others. all a user should have to do is enter inputs. in this case target totals and current LTMs. all other things should occur automatically.

if you have the correct sigma notation calculation for the LTMs, i'd defintely steal that mine just has the cheap way of associating result to current ltm value and making a percentage change.

also, i comitted some cardinal sins. i have extra junk on the inpute page that shouldn't be there, and i didn't link all the labels. so changing them would require changing them everywhere else. dum, dum, dum, dum, dum. (south park fans will recognize)

the only drawback to using autocalc alone is hoping your current league players are average as far as the ebb and flow of talent from year-to-year. if you it is a high talent year, those auto calcs will reduce your players output, and in low talent eras it will make their output better than it should be.

this spreadsheet (and yours) allow someone to center the statistical output. the ebb and flow of talent and other tangible and rational factors the game quantifies will dictate the volatility(yearly fluctuation).

as far as sample size, i'd even suggest 150-200 years. 100 can still be influenced by a hot or cold streak of years. i saw 15years in a 100yr run that stayed rock-bottom offensively similar to ... was it the 70's? the suggestions were found to be a few ticks too high the next run.

i don't know what i am doing differently, but it was taking 5:20ish to sim a year. i had it down to ~4mins a couple months ago. something changed in the patches that affected this. oh well, it's just a bit slower likely for a good reason.