View Single Post
Old 11-18-2019, 07:49 PM   #5
ariookke
Just started!
 
OVR: 0
Join Date: Nov 2019
Re: Getting player separation right on NHL2K

Yes if you only look at max/lowest then you have that problem. It's simplest way to go, but not practical.

Better way is to first create reference points to original attribute and hutdb attribute. Then compare those points between themselves and calculate convert. You can use average formula and standard deviation formula together to create reference points.

I would say 4 reference points are accurate enough

2 base points:
High Point is (Average + Std Dev)
Low Point is (Average - Std Dev)

2 help points:
Higer Point is (Average from all values that are greater than High Point + Std Dev from all values that are greater than High Point)
Lower Point is (Average from all values that are less than Low Point - Std Dev from all values that are less than Low Point)

Sure it's complicated and hard to explain. I would be keen to do an example of excel spreadsheet for you to see the function and if does it work. My problem is I don't have rosters in excel format.
ariookke is offline  
Reply With Quote
Advertisements - Register to remove