Sign in to follow this  
kingraph

Custom NHL'94 Player Attribute & Overall Calculation Spreadsheet

Recommended Posts

This has been asked a bunch, so here it is.

This Google Sheet has all of the NHL'94 players, duplicates removed, and their ratings.  This is useful for draft leagues or anyone interested in the player attributes.

https://docs.google.com/spreadsheets/d/1Vr9sVwLbLhpp3baIKDvk-VaA2aom2IonjEB84u5wgqc/edit?usp=sharing

I added the ability to customize the player overall scores as compared to the original version.  

For reference, here is how the overall calculation works in NHL'94 (thanks @smozoma! - original reference)

OVERALL CALCULATION

Wayne Gretzky is 87 overall!  But what does that mean?

The default overall calculation that the game uses for Forwards and Defensemen is as follows.  Take the attributes values (0-6) and multiply them by the following factors:

Agility x 2
Speed x 3
Offensive Awareness x 3
Defensive Awareness x 2
Shot Power x 1
Checking x 2
Stickhandling x 3
Shot Accuracy x 2
Endurance x 1
Passing x 1

Add all of those numbers together to get the “overall” number.

There are two caveats:

If the total is less than 50, divide the total number by 2 and add 25.  
the total is above 99, the overall will display 99.
So for Wayne Gretzky, his calculation would be as follows.

Agility: 6 x 2 = 12
Speed: 4 x 3 = 12
Offensive Awareness: 5 x 3 = 15
Defensive Awareness 4 x 2 = 8
Shot Power: 2 x 1 = 2
Checking: 2 x 2 = 4
Stickhandling: 6 x 3 = 18
Shot Accuracy: 2 x 2 = 4
Endurance: 6 x 1 = 6
Passing: 6 x 1 = 6

12+12+15+8+2+4+18+6+6 = 87!

For Goalies

Agility x 4.5 (round down)
Defensive Awareness x 4.5 (round down)
Puck Control x 4.5 (round down)
Stick Right x 1
Stick Left x 1
Glove Right x 1
Glove Left x 1

The same two caveats apply.

Note that the game has given the most importance to speed, offensive awareness and stickhandling for both forwards and defensemen by weighing those attributes by 3, but this is not likely what you value most in a player.

The sheet that I provided allows you to value the attributes to your OWN preference to come up with new calculated ratings:

sample.png

On this page you can change the values in the "custom" ratings and the sheet that says "new ratings" will update automatically.  The automatic scale will make sure the top rated F/D/G are the same as the original game so the data makes sense.  The sheet is defaulting to be equal to the original. 

I'll show you an example for forwards.  Let's say I value Speed, Shot Power, Stick Handling and Agility a bunch, while I don't really care about Endurance, or the Awareness.  And so I put in my new custom attributes as follows:

forwards.png

When I go to my Forwards on the "New Ratings" sheet, you can see the updated overall calculations as compared to the original:

 

forwards2.png

Mario isn't the top rated player anymore, but Mogilny, Yzerman, Bure, etc.  

If you want lighter players, put a negative value on weight.  Really, you can customize your ratings however you prefer.  This is very helpful for draft leagues, or in general.

Note that the automatic scale won't work in Excel unless you have the Excel 365 version because it uses the function MAXIFS.  If you have an older version of Excel, you'll need to manually adjust the scale. 

 

  • Like 2
  • Thanks 3

Share this post


Link to post
Share on other sites

To customize Raph's Google doc:

* for an online copy, use the File -> Make a Copy option to make your own copy which you can edit

* for a downloaded copy, use the File -> Download and select the Excel format

  • Like 1
  • Thanks 2

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this