kingraph 849 Posted May 21, 2020 Report Share Posted May 21, 2020 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: 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: When I go to my Forwards on the "New Ratings" sheet, you can see the updated overall calculations as compared to the original: 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. 2 3 Quote Link to post Share on other sites

smozoma 501 Posted May 21, 2020 Report Share Posted May 21, 2020 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 1 2 Quote Link to post Share on other sites

## Recommended Posts

## Join the conversation

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