Accurate Attribute Spreadsheets

[Caulfield]

Re: Accurate Attribute Spreadsheets

10% off the attribute rating. Ex:
Player A hit .280 vs R, (74 Rating)
74 x .10 = 7.4
74 - 7 = 67


Also if a player split time between AAA and AA I would do a 15% or .15 reduction.
Minor League stats I've found an increased percentage reduction for each lower level helps with the accuracy.


AAA - .10
AA - .20
A - .30
RK - .40

FWIW you can eliminate a step, I've done it this way the last few years:
AAA = X .90
AA = X .80
A = X .70
RK = X .60


example:74X.9=66.6 (67)

[Nate497]

Re: Accurate Attribute Spreadsheets

FanGraphs has some pretty good advanced fielding stats. I used an average from RZR, UZR and RngR for 'Reaction' - also factored in the Jump and DRS from statcast. I used ErrR and Def for 'Fielding.' They also track catchers defense really well too, including framing which it's honestly a joke this hasn't been added as an attribute yet to help you gain or lose calls on the corners depending on who you have catching.

Could you give an example on how to calculate it? I’m trying to figure out how to properly rate Derek Jeters fielding (1998)...most classic rosters seem to rate him too high.

[GainzBro]

Re: Accurate Attribute Spreadsheets

Could you give an example on how to calculate it? I’m trying to figure out how to properly rate Derek Jeters fielding (1998)...most classic rosters seem to rate him too high.

It's in the links in the OP

Sent from my LGMP260 using Operation Sports mobile app

[CBoller1331]

Re: Accurate Attribute Spreadsheets

Anyone done something similar with Durability (Games Played) and Base Running Aggressiveness (SB Attempts)?

[GainzBro]

Re: Accurate Attribute Spreadsheets

Anyone done something similar with Durability (Games Played) and Base Running Aggressiveness (SB Attempts)?

PS9119 from the classic rosters thread has a simple system he uses.

Sent from my LGMP260 using Operation Sports mobile app

[fkozminski]

Re: Accurate Attribute Spreadsheets

I’ve been able to match up almost all player attributes with corresponding stats. Fielding has been a great source of frustration. I may have something close . If you take the “def” score from fan graphs and add or subtract to 76 (not sure why) it statistically comes close if you throw out some outliers. For instance a player had a year with a def of 10 that would correspond to a score of 86 (10+76). A negative 10 would give you a score of 66. Now on to reaction and arm. Ugh. Anyone else have anything?

[fkozminski]

Re: Accurate Attribute Spreadsheets

Using my condensed formula ( tested vs def field) th short answer is adding 76 to whatever def score. So, in 1999 jeter had a 6, so his show def should be 82.

[Wbcfan]

Re: Accurate Attribute Spreadsheets

What kind of forula would you use for foreighn leagues like the NPB, KBO and CPBL?

[Wbcfan]

Re: Accurate Attribute Spreadsheets

Thought I might share what I've made and been using for quite a few years now.
Should be fairly straight forward and self explanatory. For most accurate results, use a 3 year average of each stat.

Minor League stats I've found an increased percentage reduction for each lower level helps with the accuracy.

AAA - .10
AA - .20
A - .30
RK - .40

I hope this helps some people, Enjoy.

CONTACT/BATTING CLUTCH
https://docs.google.com/spreadsheets...it?usp=sharing
POWER
https://docs.google.com/spreadsheets...it?usp=sharing
VISION
https://docs.google.com/spreadsheets...it?usp=sharing
DISCIPLINE
https://docs.google.com/spreadsheets...it?usp=sharing
PITCHING STAMINA
https://docs.google.com/spreadsheets...it?usp=sharing
PITCHING CLUTCH
https://docs.google.com/spreadsheets...it?usp=sharing
H/9
https://docs.google.com/spreadsheets...it?usp=sharing
HR/9
https://docs.google.com/spreadsheets...it?usp=sharing
K/9
https://docs.google.com/spreadsheets...it?usp=sharing
BB/9
https://docs.google.com/spreadsheets...it?usp=sharing

I like this formula.. If I player were coming over from the Japanese or Korean league, how would you rate them?

[iikoharik]

Re: Accurate Attribute Spreadsheets

I like this formula.. If I player were coming over from the Japanese or Korean league, how would you rate them?

I’m Japanese watching Japanese baseball over the years. Instinctively, if they are from Japan, giving them AAA ratings will be appropriate. If they are from Korea, AA or between AAA and AA will suit them as players from Korea often tend to make much less impact in Japan.

[bigdawg1690]

Re: Accurate Attribute Spreadsheets

I've made a simple calculator based off these if anyone is interested.


https://docs.google.com/spreadsheets...it?usp=sharing

[seatown27]

Re: Accurate Attribute Spreadsheets

Looks good except I cant enter stats into it?

I've made a simple calculator based off these if anyone is interested.


https://docs.google.com/spreadsheets...it?usp=sharing

Sent from my SM-S102DL using Operation Sports mobile app

[Billy Batson]

Re: Accurate Attribute Spreadsheets

I've made a simple calculator based off these if anyone is interested.


https://docs.google.com/spreadsheets...it?usp=sharing

this is super helpful, thank you!

[Billy Batson]

Re: Accurate Attribute Spreadsheets

Looks good except I cant enter stats into it?

Sent from my SM-S102DL using Operation Sports mobile app

you probably have to create a copy of it in order to edit it.

[exeter]

Re: Accurate Attribute Spreadsheets

This looks amazing…but:

Has anyone created a roster and run a franchise based on this?

If so, how did the stats work & more importantly how did the game play? Are slider adjustments necessary to seem realistic?

Thank for your time.


Sent from my iPhone using Operation Sports