League Total Modifier - LTM

NoOne · 04-01-2016, 12:10 AM

EDIT: this didn't work well... lol... individual years were fine, but averaging multiple years did not work as expected. the BB rate looks like it came out accurately though. anything else related to AB was bad info. i'm sure the other LTM below babip would be fine using this method.

well, i'm not finished yet, but the new method is looking pretty sweet after 8 years of the first test run.

I averaged 10 auto-calcs <threw up in my mouth a little bit> per year for 20years... i should have gone longer and still can.

long-story short, i decided to do this a bit late and it was already nearing 2016 in my league... 2015 just happened to be year 20 by coincidence.

if you ever wanted to do something with LTM, this is a great way to hammer out an excellent starting point.

make a spreadsheet that averages the LTM you get from auto-calc. then average all the individual years you have autocalced/averaged out.

this should all be automated. you only have to type in the autocalc figured as many times as you wish. the averages and the average of averages should all be a formula you can copy/fill.

04-01-2016, 12:10 AM	#1
NoOne Banned Join Date: Apr 2015 Posts: 7,273 Infractions: 0/1 (3)	League Total Modifier - LTM EDIT: this didn't work well... lol... individual years were fine, but averaging multiple years did not work as expected. the BB rate looks like it came out accurately though. anything else related to AB was bad info. i'm sure the other LTM below babip would be fine using this method. well, i'm not finished yet, but the new method is looking pretty sweet after 8 years of the first test run. I averaged 10 auto-calcs <threw up in my mouth a little bit> per year for 20years... i should have gone longer and still can. long-story short, i decided to do this a bit late and it was already nearing 2016 in my league... 2015 just happened to be year 20 by coincidence. if you ever wanted to do something with LTM, this is a great way to hammer out an excellent starting point. make a spreadsheet that averages the LTM you get from auto-calc. then average all the individual years you have autocalced/averaged out. this should all be automated. you only have to type in the autocalc figured as many times as you wish. the averages and the average of averages should all be a formula you can copy/fill. Last edited by NoOne; 04-03-2016 at 12:23 AM.