What if I told you... that Roster Tools is BACK!

[PatsCards87]

Re: What if I told you... that Roster Tools is BACK!

You still have to input the data you want into The Show from the numbers the spreadsheet gives you manually . . . I think or am I wrong?

Correct. If anything I created did something like that automatically, I would expect a job offer from Sony San Diego lol.

[Ghost Of The Year]

Re: What if I told you... that Roster Tools is BACK!

This has so much potential, Thanks!

Out of curiosity, what rating (0-99) did you use as "average" for:
Hitting
Contact
Power
Vision
Discipline

Pitching
H/9
HR/9
BB/9
K/9

Thanks again!

[CologeroNYY]

Re: What if I told you... that Roster Tools is BACK!

How will you figure out the potential rating?

[PatsCards87]

Re: What if I told you... that Roster Tools is BACK!

How will you figure out the potential rating?

Yeesh, good question! This actually isn't something I even thought about.

I'll have to come up with a formula for this.

[EJQJ99]

Re: What if I told you... that Roster Tools is BACK!

This is exciting. Can't wait for release.


Sent from my iPhone using Tapatalk

[PatsCards87]

Re: What if I told you... that Roster Tools is BACK!

This has so much potential, Thanks!

Out of curiosity, what rating (0-99) did you use as "average" for:
Hitting
Contact
Power
Vision
Discipline

Pitching
H/9
HR/9
BB/9
K/9

Thanks again!

Thanks for the question! There is no "average" so to speak with these ratings. It's hard to explain. It's all based on formulas using real life stats and sabermetrics.

Sparing you the boring stuff, it's safe to assume that ratings in the 90s indicates elite status, 80's being great, 70's good, 60's average, 50's below average, and so on.

You will NOT see an oversaturation of 99's with this. These formulas are very intricate, and properly penalizes even the best of players for real life flaws that can/are overlooked based on bias.

Let me use Mike Trout for example. 2014.

SCEA says his Contact vs Right is a 94 and Contact vs Left is a 86.

That's just laughable. There is no question that Mike Trout is hands down the best player in the world. That's where the bias comes in.

Mike Trout ranked #7 in all of baseball for most strikeouts vs LHP and #5 vs RHP last year. You strike out because you aren't making contact (or taking pitches).

My formulas eliminate that bias to properly reflect his strikeout tendencies, while also running those numbers against his AB's and then giving credit for his batting average.

As a result, Trout is given the following ratings in my spreadsheet for contact:

78 Contact Right
68 Contact Left

His batting average was .016 higher vs RHP, and his strikeout percentage is 0.08% lower vs RHP which lends his contact vs RHP being superior than his left.

Again, that was 2014 Trout. 2013 Trout will tell a different story, and that's how intricate this program is. You can select a year, go find your favorite player, and create your favorite version of that player.

I'm working on weighted career ratings, but that is still a WIP.

EDIT: For what it's worth, Trouts power ratings for 2014 for both LHP and RHP are in the 80's. Don't have a fear that this spreadsheet makes players suck, it doesn't. Like I said, it just eliminates bias.

[topside]

Re: What if I told you... that Roster Tools is BACK!

Thanks for the question! There is no "average" so to speak with these ratings. It's hard to explain. It's all based on formulas using real life stats and sabermetrics.

Sparing you the boring stuff, it's safe to assume that ratings in the 90s indicates elite status, 80's being great, 70's good, 60's average, 50's below average, and so on.

You will NOT see an oversaturation of 99's with this. These formulas are very intricate, and properly penalizes even the best of players for real life flaws that can/are overlooked based on bias.

Let me use Mike Trout for example. 2014.

SCEA says his Contact vs Right is a 94 and Contact vs Left is a 86.

That's just laughable. There is no question that Mike Trout is hands down the best player in the world. That's where the bias comes in.

Mike Trout ranked #7 in all of baseball for most strikeouts vs LHP and #5 vs RHP last year. You strike out because you aren't making contact (or taking pitches).

My formulas eliminate that bias to properly reflect his strikeout tendencies, while also running those numbers against his AB's and then giving credit for his batting average.

As a result, Trout is given the following ratings in my spreadsheet for contact:

78 Contact Right
68 Contact Left

His batting average was .016 higher vs RHP, and his strikeout percentage is 0.08% lower vs RHP which lends his contact vs RHP being superior than his left.

Again, that was 2014 Trout. 2013 Trout will tell a different story, and that's how intricate this program is. You can select a year, go find your favorite player, and create your favorite version of that player.

I'm working on weighted career ratings, but that is still a WIP.

EDIT: For what it's worth, Trouts power ratings for 2014 for both LHP and RHP are in the 80's. Don't have a fear that this spreadsheet makes players suck, it doesn't. Like I said, it just eliminates bias.

Even though I understand where you're coming from this means your formula would turn trout into a 270 hitter most likely. Contact directly effects batting average. Vision is the rating that helps with the strikeouts.

[PatsCards87]

Re: What if I told you... that Roster Tools is BACK!

Even though I understand where you're coming from this means your formula would turn trout into a 270 hitter most likely. Contact directly effects batting average. Vision is the rating that helps with the strikeouts.

Well... he hit a career low .287 last year, so your guesstimate vs reality isn't way off.

[CologeroNYY]

Re: What if I told you... that Roster Tools is BACK!

Maybe a release for tonight?

[SupremeYankee]

Re: What if I told you... that Roster Tools is BACK!

I will be using this to rerate a group of dr sublimes guys for my childhood fantasy team roster. Cant wait


Sent from my iPhone using Tapatalk

[topside]

Re: What if I told you... that Roster Tools is BACK!

Well... he hit a career low .287 last year, so your guesstimate vs reality isn't way off.

I do agree with you that his contact numbers should go down. The contact rating is a weird one. You want the guys to hit near their averages but also not get the bat on every pitch. I can strike a guy Like trout out but It's tough to get him to swing through any other pitchers before he's down in the count.

[PatsCards87]

Re: What if I told you... that Roster Tools is BACK!

Maybe a release for tonight?

All I need to do is put some finishing touches on this and I should be able to have this thing out late tonight. Somewhere around 7pm CST.

What kind of hosting site do you all prefer?

[CologeroNYY]

Re: What if I told you... that Roster Tools is BACK!

All I need to do is put some finishing touches on this and I should be able to have this thing out late tonight. Somewhere around 7pm CST.

What kind of hosting site do you all prefer?

Whatever site is easy for you. Thanks again for all the work you've done.

[PatsCards87]

Re: What if I told you... that Roster Tools is BACK!

Whatever site is easy for you. Thanks again for all the work you've done.

Thank you sir. I have plenty of time to meet my deadline, but I'm not gonna lie, I have a bit to do before I'm happy with it, but I won't let everyone down. I want everyone to get excited for their weekend and be ready to make their very own edits.

The beautiful thing about this tool is that ultimately, everyone is getting their own "copy". So you can adjust the ratings however you like, it's YOUR tool now. These ratings will give everyone (the gamer) a base line for any player from 1950-2015, it's up to you if you want to tweak the ratings a bit. Some of the ratings will raise an eyebrow, but the sabermetrics and statistics back up these numbers by default.

For instance, 2013 Andrew McCutchen is pulling up a 74 fielding. It has me scratching my head. But FRAA (Fielding Runs Above Average) was at a -9 for him. The definition of FRAA from Baseball Prospectus:

The biggest difference between Fielding Runs Above Average and similar defensive metrics comes in the data and philosophy used. Whereas other metrics use zone-based fielding data, Fielding Runs Above Average ignores that data due to the numerous biases present. Fielding Runs Above Average instead focuses on play-by-play data, taking a step back and focusing on the number of plays made compared to the average number of plays made by a player at said position. The pitcher's groundball tendencies, batter handedness, park, and base-out state all go into figuring out how many plays an average player at a position would make.

Here is an example of the Fielding Runs Above Average spectrum based upon the 2011 season-for the sake of consistency, the players featured below all play the same position (center field):

Excellent - Jacoby Ellsbury 11.6
Great - Nyjer Morgan 5.5
Average - Marlon Byrd 0.6
Poor - Roger Bernadina -5.2
Horrendous - Melky Cabrera -13.2

So it is what it is, I have to take my bias out of it, and let the numbers speak for themselves. The only reason McCutchen's fielding isn't in the 60's is because my formula also gives credit for his WARP score.

But again, that's the beauty of it. If you disagree, and you want to change a rating here and there in your own game, you can. It's YOUR game, and you should enjoy it how you want.

I'm excited that you all are excited. Now I need to get back to work!

[jermars666]

Re: What if I told you... that Roster Tools is BACK!

Thank you sir. I have plenty of time to meet my deadline, but I'm not gonna lie, I have a bit to do before I'm happy with it, but I won't let everyone down. I want everyone to get excited for their weekend and be ready to make their very own edits.

The beautiful thing about this tool is that ultimately, everyone is getting their own "copy". So you can adjust the ratings however you like, it's YOUR tool now. These ratings will give everyone (the gamer) a base line for any player from 1950-2015, it's up to you if you want to tweak the ratings a bit. Some of the ratings will raise an eyebrow, but the sabermetrics and statistics back up these numbers by default.

For instance, 2013 Andrew McCutchen is pulling up a 74 fielding. It has me scratching my head. But FRAA (Fielding Runs Above Average) was at a -9 for him. The definition of FRAA from Baseball Prospectus:



So it is what it is, I have to take my bias out of it, and let the numbers speak for themselves. The only reason McCutchen's fielding isn't in the 60's is because my formula also gives credit for his WARP score.

But again, that's the beauty of it. If you disagree, and you want to change a rating here and there in your own game, you can. It's YOUR game, and you should enjoy it how you want.

I'm excited that you all are excited. Now I need to get back to work!

I am extremely excited about this!!! Thank you a million times in advance!!