Thanks to statdude for all the work he's doing testing this out. You are helping immensely with improving this calc.
So here's the deal. Steven Souza has now been fixed with Steven Souza Jr. giving you the correct info. He probably won't be the last guy we find either, so skip them for the time being and please post them here so I can get it fixed.
Second in regards to Mikie Mahtouk and others like him, your finding has caused me to change how I'm choosing whether to use their minor league stats or major league stats. The first file was basing it off total at bats which you can see in row 5 above each year. What I've now done is changed it to at bats vs l and at bats vs r. So Mikie Mahtouk is now having all his calculations based on his minor league stats.
Here's how it happened. Mikie Mahtouk had 37 ABs vs R and 68 ABs vs L. This got him above my minimum at bats of 100, but it really wasn't enough data to support using his SMALL major league statistics. He produced incredibly well when he played in 2015, but it was in a small number of at bats.
He now gets a career 51 vs R and 55 vs L, a 44 and 47 for 2015, with weighted ratings of 49 and 53. Power is now lowered significantly too.
So here's a question for the community. Per year, what do you think is the minimum number of at bats a player should have vs R and vs L to justify using his MLB stats. I need this by year and for career. Currently, it's set at 100 ABs across the board, but I feel this needs to be tweaked.
Thoughts? Thanks again statdude!
Comment