OOTP Developments Forums - View Single Post - Test League: 25 years of stats, stats, and more stats (lots of screenshots included)

rudel.dietrich · 04-14-2013, 11:29 PM

This is great stuff

Since version 8 I have used a custom built Excel spread sheet that I used in almost all of my leagues. I import my league totals into it and then use the formula and ever year it modifies the league totals from 0.0-4.5%
I also have some of the totals linked so if one of the batting totals change then there is a better chance that the other batting totals will change in the same direction.
And I have gone as far as to add the ability for it to simulate eras where the totals will swing one direction and each year the % chance to continue in that direction increases. Once a certain number of years is reached, then there is a decreasing likely hood that it will continue in that direction and it will begin to swing back the other way.

Good stuff though people. Version 14 seems to be a lot more stable out of the gate in terms of maintaining long term statistical output.
In years past, especially in fictional leagues it would drive me to fits of cursing when my leagues would suddenly spin out of control and the league batting averages would be over .315 and league ERA would be over 5.00.

04-14-2013, 11:29 PM	#31
rudel.dietrich Hall Of Famer Join Date: Jul 2004 Location: Zürich, Switzerland Posts: 8,608	This is great stuff Since version 8 I have used a custom built Excel spread sheet that I used in almost all of my leagues. I import my league totals into it and then use the formula and ever year it modifies the league totals from 0.0-4.5% I also have some of the totals linked so if one of the batting totals change then there is a better chance that the other batting totals will change in the same direction. And I have gone as far as to add the ability for it to simulate eras where the totals will swing one direction and each year the % chance to continue in that direction increases. Once a certain number of years is reached, then there is a decreasing likely hood that it will continue in that direction and it will begin to swing back the other way. Good stuff though people. Version 14 seems to be a lot more stable out of the gate in terms of maintaining long term statistical output. In years past, especially in fictional leagues it would drive me to fits of cursing when my leagues would suddenly spin out of control and the league batting averages would be over .315 and league ERA would be over 5.00.