More stats to input for League Total Modifiers.

SirMichaelJordan · 01-23-2015, 01:09 PM

I would love to be able to input even more stats like stolen bases, errors, etc to create LTM's to closely match leagues outside of MLB in any given year.

Great feature overall and was able to mirror specific league stats but often had problems with stats that aren't available for LTM. Instead I had to manually come up with LTM to get the stats I wanted which led to alot of trial and error testing instead of enjoying the game.

Rchw did hook me up with a tool to use but I'd rather have the option in the game.

RchW · 01-23-2015, 02:01 PM

I'd like a spreadsheet option where we could export current settings, make changes then import just like we do with other game modules.

League total errors and the distribution by position needs to be more transparent. At the top (MLB) level it seems fine but the lower minors are way off.

SMJ I've revised that spreadsheet to use data more efficiently. It's still clunky but easier to use.

Let me know if you want it?

SirMichaelJordan · 01-23-2015, 02:12 PM

Quote:

Originally Posted by RchW

I'd like a spreadsheet option where we could export current settings, make changes then import just like we do with other game modules.

League total errors and the distribution by position needs to be more transparent. At the top (MLB) level it seems fine but the lower minors are way off.

SMJ I've revised that spreadsheet to use data more efficiently. It's still clunky but easier to use.

Let me know if you want it?

I would like that. Need my email again?

RchW · 01-23-2015, 02:22 PM

Quote:

Originally Posted by SirMichaelJordan

I would like that. Need my email again?

Yes please.

PM

PsychoBulk · 02-05-2015, 05:53 PM

Rch would you mind if i PM you my address for this spreadsheet?

Having some real modifier issues and would love to see your approach to it.

darkcloud4579 · 02-05-2015, 07:31 PM

Should share it. Would love to try it out, too.

RchW · 02-24-2015, 12:04 PM

Here you go. My biggest problem is explaining how to use it.

Do this before the start of the next season ie before opening day.

Pick the real life totals you want and put them in real life totals tab

Take the league history totals csv for batting pitching and fielding (almanac or dump on Jan 1) and copy paste the year totals you need to the proper spot on the various totals tabs. If they are right the variation from RL will be calculated instantly.

On the short LTM tab, go to the lower RH box and enter the existing LTM from your league without decimal point. I do this because it makes entering data easy. The decimal point is added and displayed on the upper LH box.

If the data is entered correctly the proposed LTM for the next season will be displayed in the lower LH box. I print this off then run Autocalc and decide whether to keep the OOTP LTM or my own.

The various colors and shadings indicate where a modifier is outside the range of 0.8-1.2. That's just my arbitrary idea of where certain modifiers should be.

It's a bit of a cluttered mess if anyone is able to streamline it feel free. There is also a partially done error module but I lost my notes so may have to start it from scratch.

darkcloud4579 · 03-02-2015, 10:54 AM

This is amazing. Just tinkered and got it figured out. Thanks again!

RchW · 03-02-2015, 11:46 AM

Quote:

Originally Posted by darkcloud4579

This is amazing, but yeah...gonna take me a little while to figure it out. Haha thanks for sharing it, it's a hell of a job you did.

I'm just about to start a season so I'll try to post a few screenshots. I've tried to color code things so you can trace links from each tabbed sheet. See below.

The data in orange from the bottom of the batting totals (this is from the league history totals csv file) tab is linked to the league totals in from real life found in the batting variation tab in orange.
The data is normalized because OOTP typically has more AB due to no rainout. This is neccessary for accuracy
The normalized totals are then compared to the real life totals and the variation shown in red in the batting variation tab is linked to the Short LTM tab below the tables also in red.
This data is in the wrong orientation so we must transpose the variations in red to the table on the upper RHS. You will see the numbers all match.
We then take the previous seasons LTM which we had to enter manually from my previous post and they are multiplied by the the transposed variations (upper RHS table). The results which are the proposed or calculated LTM for the upcoming season are displayed on the lower LHS table.

I have set it up so you can print off the tables as needed.

What I do is run autocalc and fill in the autocalc LTM beside the calculated values on a printed sheet. Where the autocalc LTM are close to my calculated LTM I go with the autocalc. Where they are not close (usually in red) I look back and see how far off the real live variation is and either use my calcuated version or split the difference.

Screenshots to follow. They are matched to the numbered list above.

RchW · 03-02-2015, 11:52 AM

More screenshots.

Original variation data.

Same data trasposed to fit the orientation found in game on the OOTP league totals screen.

Edit:

On the second screenshot below, please note the numbers in red font are league total variations from the real life totals chosen that are outside the range of 0.80-1.20. Note that the red font for errors is for a calculation not yet implemented. Ignoring them temporarily we see that only 8 league totals for 9 leagues and 3 levels of minors are ouside a ± 20% range. I think this is outstanding especially in the low minors.

RchW · 03-02-2015, 12:16 PM

More screenshots.

Input previous season mods manually. This is where I wish Markus would allow LT and LTM data to be exported and/or extracted so I didn't have to do this manually. I have tendonitis so this table was set up so I didn't have to enter decimal points. The entered mods are copied to the upper LHS table which can be seen in the next screen shot.

RchW · 03-02-2015, 12:27 PM

Last but not least.

Previous season mods shown above the calculated mods. As I said before this can be printed and you can compare autocalc generated LTM with the season just finished and the one about to start.

Don't be put off by some of the high numbers. This league has been played for many OOTP versions and well before autocalc was introduced. The high modifiers are a legacy effect of some drastic variations back then. The year to year variations shown earlier are a clear indication of realistic output.

I'd expect a more recent and more controlled league to be less variable/volatile.

PsychoBulk · 03-02-2015, 04:04 PM

Thanks for this Rich, it looks like it could prove very useful.

Ill try and get my head round it soon!

Cheers

RchW · 03-02-2015, 07:16 PM

Another note. The modifier for GB% is actually the modifier for GO% (ground out percent). This has been confirmed by Markus. The target for MLB is 52% recently. In the pitching variation tab I arbitrarily chose 50% for the minor leagues because there is no real data AFAIK. Obviously the default value can be changed if desired.

01-23-2015, 01:09 PM	#1
SirMichaelJordan Hall Of Famer Join Date: Apr 2012 Posts: 2,717	More stats to input for League Total Modifiers. I would love to be able to input even more stats like stolen bases, errors, etc to create LTM's to closely match leagues outside of MLB in any given year. Great feature overall and was able to mirror specific league stats but often had problems with stats that aren't available for LTM. Instead I had to manually come up with LTM to get the stats I wanted which led to alot of trial and error testing instead of enjoying the game. Rchw did hook me up with a tool to use but I'd rather have the option in the game. Last edited by SirMichaelJordan; 01-23-2015 at 01:16 PM.

01-23-2015, 02:01 PM	#2
RchW Hall Of Famer Join Date: Jul 2004 Location: Toronto ON by way of Glasgow UK Posts: 15,629	I'd like a spreadsheet option where we could export current settings, make changes then import just like we do with other game modules. League total errors and the distribution by position needs to be more transparent. At the top (MLB) level it seems fine but the lower minors are way off. SMJ I've revised that spreadsheet to use data more efficiently. It's still clunky but easier to use. Let me know if you want it? __________________ Cheers RichW If you’re looking for a good cause to donate money to please consider a Donation to Parkinson’s Canada. It may help me have a better future and if not me, someone else. Thanks. “Conservatism consists of exactly one proposition …There must be in-groups whom the law protects but does not bind, alongside out-groups whom the law binds but does not protect.” Frank Wilhoit

02-05-2015, 07:31 PM	#6
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,654	Should share it. Would love to try it out, too. __________________ ------ My Mods Managerial Strategy Pack Competitive Balance Tax Calculator Major League Women's Baseball (OOTP24) quickstart Indian Premier League \| 300+ years of baseball quickstart \| Expatriate League quickstart \| Off-Field Injuries Update \| Women's Name File for OOTP \| ---- Dynasty classics: Centurion comes to OOTP5 \| DC Moneyball Dynasty (2004)

03-02-2015, 10:54 AM	#8
darkcloud4579 Hall Of Famer Join Date: Jun 2003 Posts: 8,654	This is amazing. Just tinkered and got it figured out. Thanks again! Last edited by darkcloud4579; 03-02-2015 at 11:18 AM.

03-02-2015, 11:52 AM	#10
RchW Hall Of Famer Join Date: Jul 2004 Location: Toronto ON by way of Glasgow UK Posts: 15,629	More screenshots. Original variation data. Same data trasposed to fit the orientation found in game on the OOTP league totals screen. Edit: On the second screenshot below, please note the numbers in red font are league total variations from the real life totals chosen that are outside the range of 0.80-1.20. Note that the red font for errors is for a calculation not yet implemented. Ignoring them temporarily we see that only 8 league totals for 9 leagues and 3 levels of minors are ouside a ± 20% range. I think this is outstanding especially in the low minors. Attached Images __________________ Cheers RichW If you’re looking for a good cause to donate money to please consider a Donation to Parkinson’s Canada. It may help me have a better future and if not me, someone else. Thanks. “Conservatism consists of exactly one proposition …There must be in-groups whom the law protects but does not bind, alongside out-groups whom the law binds but does not protect.” Frank Wilhoit Last edited by RchW; 03-02-2015 at 12:03 PM.

02-05-2015, 05:53 PM	#5
PsychoBulk Minors (Double A) Join Date: Dec 2012 Location: UK Posts: 129	Rch would you mind if i PM you my address for this spreadsheet? Having some real modifier issues and would love to see your approach to it.

03-02-2015, 12:16 PM	#11
RchW Hall Of Famer Join Date: Jul 2004 Location: Toronto ON by way of Glasgow UK Posts: 15,629	More screenshots. Input previous season mods manually. This is where I wish Markus would allow LT and LTM data to be exported and/or extracted so I didn't have to do this manually. I have tendonitis so this table was set up so I didn't have to enter decimal points. The entered mods are copied to the upper LHS table which can be seen in the next screen shot. Attached Images __________________ Cheers RichW If you’re looking for a good cause to donate money to please consider a Donation to Parkinson’s Canada. It may help me have a better future and if not me, someone else. Thanks. “Conservatism consists of exactly one proposition …There must be in-groups whom the law protects but does not bind, alongside out-groups whom the law binds but does not protect.” Frank Wilhoit

03-02-2015, 12:27 PM	#12
RchW Hall Of Famer Join Date: Jul 2004 Location: Toronto ON by way of Glasgow UK Posts: 15,629	Last but not least. Previous season mods shown above the calculated mods. As I said before this can be printed and you can compare autocalc generated LTM with the season just finished and the one about to start. Don't be put off by some of the high numbers. This league has been played for many OOTP versions and well before autocalc was introduced. The high modifiers are a legacy effect of some drastic variations back then. The year to year variations shown earlier are a clear indication of realistic output. I'd expect a more recent and more controlled league to be less variable/volatile. Attached Images __________________ Cheers RichW If you’re looking for a good cause to donate money to please consider a Donation to Parkinson’s Canada. It may help me have a better future and if not me, someone else. Thanks. “Conservatism consists of exactly one proposition …There must be in-groups whom the law protects but does not bind, alongside out-groups whom the law binds but does not protect.” Frank Wilhoit

03-02-2015, 04:04 PM	#13
PsychoBulk Minors (Double A) Join Date: Dec 2012 Location: UK Posts: 129	Thanks for this Rich, it looks like it could prove very useful. Ill try and get my head round it soon! Cheers

03-02-2015, 07:16 PM	#14
RchW Hall Of Famer Join Date: Jul 2004 Location: Toronto ON by way of Glasgow UK Posts: 15,629	Another note. The modifier for GB% is actually the modifier for GO% (ground out percent). This has been confirmed by Markus. The target for MLB is 52% recently. In the pitching variation tab I arbitrarily chose 50% for the minor leagues because there is no real data AFAIK. Obviously the default value can be changed if desired. __________________ Cheers RichW If you’re looking for a good cause to donate money to please consider a Donation to Parkinson’s Canada. It may help me have a better future and if not me, someone else. Thanks. “Conservatism consists of exactly one proposition …There must be in-groups whom the law protects but does not bind, alongside out-groups whom the law binds but does not protect.” Frank Wilhoit