NHL14 Overall Formula! NHL View

[domjr4]

I have replicated EA's overall formula for Forwards and I am about to work on deriving the Defenceman and Goalie Overall formulas. This could then be used in NHL View in order to calculate/update overalls when attributes are edited in the program.

Here is the spreadsheet including the formula (Feel free to test it out)...

https://www.dropbox.com/s/c8nb1d9zyi...alculator.xlsx

The Formula is...

Overall= 1.9165*(((Speed*3)+(Body Checking*2)+(Endurance)+(Puck Control*2)+(Passing*5)+(Slapshot Power*2)+(Slapshot Accuracy*2)+(Wristshot Power*3)+(Wristshot Accuracy*4)+(Agility*3)+(Strength*3)+(Acceleration *3)+(Balance*3)+(Faceoffs)+(Durability)+(Deking)+( Aggressiveness)+(Poise*2)+(HandEye)+(Shot Blocking)+(Offensive Awareness*7)+(Defensive Awareness*9)+(Discipline)+(Fighting Skill)+(Stick Checking*3))/65)-78.725

*The final formula is still being developed. It isn't 100% perfect yet, but the final product will be. Any overall rating over 99 overall is considered to be 99 overall in the game and any overall less than 36 is displayed as a 36 overall in the game*

[s_mkheidze]

Quote: Originally Posted by domjr4

I have replicated EA's overall formula for Forwards and I am about to work on deriving the Defenceman and Goalie Overall formulas. This could then be used in NHL View in order to calculate/update overalls when attributes are edited in the program. Here is the spreadsheet with the formula... https://www.dropbox.com/s/c8nb1d9zyi...alculator.xlsx The Formula is... Overall= 1.9165*(((Speed*3)+(Body Checking*2)+(Endurance)+(Puck Control*2)+(Passing*5)+(Slapshot Power*2)+(Slapshot Accuracy*2)+(Wristshot Power*3)+(Wristshot Accuracy*4)+(Agility*3)+(Strength*3)+(Acceleration *3)+(Balance*3)+(Faceoffs)+(Durability)+(Deking)+( Aggressiveness)+(Poise*2)+(HandEye)+(Shot Blocking)+(Offensive Awareness*7)+(Defensive Awareness*9)+(Discipline)+(Fighting Skill)+(Stick Checking*3))/65)-78.725

well done sir!

[Fernand126]

Wow man, well done. May I know how you came up with this?

Sent from my GT-I8190L using Tapatalk

[domjr4]

Quote: Originally Posted by Fernand126

Wow man, well done. May I know how you came up with this? Sent from my GT-I8190L using Tapatalk

I tested the influence of each attribute on a player's overall. Based on these results, I came up with weighted values for each attribute that accurately reflects its impact on a player's overall rating. After doing this, I compared the average of these attributes to a player's actual "in-game overall" and performed linear regression between the two numbers. The final result was the formula shown in the OP. I repeated doing so on numerous players of a wide range of overall ratings in order to make sure my findings were consistent for all forwards.

[Koju1313]

Wow! This is amazing! Great job! Will be great if Artem can factor this into version 2 of his NHLVIEWNG. Did you check this on created players? Whenever I try to create a forward in the game, it only lets me get to an overall of 95.

[TommyWizard]

Quote: Originally Posted by domjr4

https://www.dropbox.com/s/c8nb1d9zyi...alculator.xlsx The Formula is... Overall= 1.9165*(((Speed*3)+(Body Checking*2)+(Endurance)+(Puck Control*2)+(Passing*5)+(Slapshot Power*2)+(Slapshot Accuracy*2)+(Wristshot Power*3)+(Wristshot Accuracy*4)+(Agility*3)+(Strength*3)+(Acceleration *3)+(Balance*3)+(Faceoffs)+(Durability)+(Deking)+( Aggressiveness)+(Poise*2)+(HandEye)+(Shot Blocking)+(Offensive Awareness*7)+(Defensive Awareness*9)+(Discipline)+(Fighting Skill)+(Stick Checking*3))/65)-78.725

So let me ask then... in theory... the numbers that act as multipliers, like the defensive and offensive stats, a created player with heavy investment in those multipliers, the level SHOULD increase a lot more than a balanced build? It makes sense as to why grinders and enforcers are such lower levels despite fantastic physical qualities.

Kudos Domjr4. This is very impressive!

[domjr4]

Quote: Originally Posted by TommyWizard

So let me ask then... in theory... the numbers that act as multipliers, like the defensive and offensive stats, a created player with heavy investment in those multipliers, the level SHOULD increase a lot more than a balanced build? It makes sense as to why grinders and enforcers are such lower levels despite fantastic physical qualities. Kudos Domjr4. This is very impressive!

Thanks! And yes, you are correct. Each attribute has its own multiplier and players with high rating in attributes with high multipliers will have a higher Overall as a result.

[Fernand126]

Quote: Originally Posted by Koju1313

Wow! This is amazing! Great job! Will be great if Artem can factor this into version 2 of his NHLVIEWNG. Did you check this on created players? Whenever I try to create a forward in the game, it only lets me get to an overall of 95.

I guess the thing is that, when you create a player, the overall system glitches. If you save your player and check back, his overall will be correct (and possibly above 95 if you made him a beast)

Sent from my GT-I8190L using Tapatalk