Jump to content
NHL'94 Forums

Custom NHL'94 Player Attribute & Overall Calculation Spreadsheet


kingraph

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. 

 

  • Love 1
  • Thanks 3
  • Like 2
Link to comment
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

  • Thanks 2
  • Like 1
Link to comment
Share on other sites

  • kingraph pinned this topic
  • 1 year later...
14 hours ago, RuThaN said:

Is this for Snes, Megadrive or PC Dos.. or stats for all are the same?

It was set up for the Sega Megadrive, though I believe the underlying stats are the same for SNES for each player so it can be used for that as well.

Not sure about PC Dos.

Link to comment
Share on other sites

Hmm, i checked PC Dos stats, it seems different, these are just in:

Speed
Agility
Weight
ShotPower
Checking
Stick
Handling
Accuracy
Passing
OFF. Awarenewss
Def Awarenews
Aggressiveness
Endurance
Shoot/Passbias
FaceOffs

  Style 0-100 values, there is not overall rating. It seems different from SNES and Megadrive rating and seems to be made by some Calgary fan, because in top 20 players seems to be 9 Calgary players, or my version caught some Calgary virus: )

  So someone did not make stats for Dos version, i can make it happen, i already started with best players.

  Im sure than someone could grep stats from data files and convert Hex values by some coding, but it could be done by hand in day or two..

Edited by RuThaN
Link to comment
Share on other sites

1 hour ago, RuThaN said:

Hmm, i checked PC Dos stats, it seems different, these are just in:

Speed
Agility
Weight
ShotPower
Checking
Stick
Handling
Accuracy
Passing
OFF. Awarenewss
Def Awarenews
Aggressiveness
Endurance
Shoot/Passbias
FaceOffs

  Style 0-100 values, there is not overall rating. It seems different from SNES and Megadrive rating and seems to be made by some Calgary fan, because in top 20 players seems to be 9 Calgary players: )

  So someone did not make stats for Dos version, i can make it happen, i already started with best players.

  Im sure than someone could grep stats from data files and convert Hex values by some coding, but it could be done by hand in day or two..

I'm pinging @Koppewho is our resident DOS roster updater!  Do you have any insights into the 95 DOS player attributes/spreadsheet?

Link to comment
Share on other sites

There some mess about PC NHL numbering.. first NHL for PC has NHL 92/93 season stats, game is named just NHL Hockey, but its usually called NHL94.. but it should be probably called NHL 93 (24 Teams).. That is game which i care about.. NHL 95 on PC looks like very small update.

  It would be nice to have some export to Excel and import from tools.. new updated roosters etc.. same as for SNES / Megadrive versions. 
  If finishing ma work, we would be only import tool.. because exporting present stats would not be needed.

  Otherwise my digitalizing progress (im saving it to Google sheet which i will share later):
250 of 600 players are done - im starting from best to worst using Snes stats as guideline.. i know there is some delta(93 vs 94), i will deal with it later.
all goalies ~60 done.

Edited by RuThaN
Link to comment
Share on other sites

Some sneak peek..

 Yeah Gary Roberts and Theo Fleury are the best at least if you just add up all stats together.

Overall AVG is just sum of all stats number / number of stats.. and Overall - > 100, presumes that best player should be 100, to he has 86.. to 100/86 generate magic number to aprox. values of all player to rating where 100 is the best.

 I also added Nation collumn to easy filter and make by through trading (its cumbersome but its possible in possible version, you have to add new player to league - to team from which you want to trade, select trade option, trade player and remove "helper" player.) version own national teams etc..  So i can play with Chicago (it has once czech mayor and still has small czech community) czech team with JR and Chelios, i dont have a heart to trade them :) 

Screenshot 2022-02-07 21.04.07.png

Edited by RuThaN
Link to comment
Share on other sites

 

Its done!

 Link:
 https://docs.google.com/spreadsheets/d/1lak0GSiHA6UKkUIESaYnElAAK62Gbyzj4_c4eMKQTNQ/edit#gid=929815946
 
 Comments are enabled, because of pure mass of data, there have to be some typos, but i did my best, it took me quite a lot time.. I was thinking about code something for it, but im not fan of hex porn and binary data and im sure that brute force solution took less time (thanks to my 3 monitors) and learned big pure nothing about coding but something about old NHL stats and mz eyes and quite red..
 
  With coding or DOS vs. SNES/Genesis stats comparision there would be fewer problems with typos if names of players, from original SNES/Megadrive sheet, which i used as source for these, i saw few of errors here. I fixed most of them but russian names are nightmare there is sometimes Vachaslav, sometime vaichaslav, vaychaslav etc, ui dunno what is right.. Otherwise sheet could be export to *.csv (2 one for players are one go goalies) to it should be quite easy job to work with it and make possible import to game so new adjusted stats made by just some edited copy of this sheet.

All numbers except Calgary seems fine, i dunno if exist some patch, i even searched for my old backup from 96, but Calgary numbers are same, as in retro archives. And in same way all players even with good 92/93 stats in TBL,SJS and OTW have trash stats.

 Only other strange numbers are these:
1) Jarrod Skalde NYD prospect - its #7 best player in League, i never heard of him a guess that he should be some good draft pick. He managed 8 point in first 27 game, so some analytic go excited way too much. 
  Same thing is Oleg Petrov Edmonton - #6, but i maybe heard about this one once. All other prospects have reasonable numbers.
2) Andre Faust - as guess because of demonic name has Endurance 390, insted of 90 a guess he has to be importal, as some bug.. He is otherwise good, but not super good (#45 in League).    

 In PC versions i bit more players, i guess more prostecs, 600 vs 560 in Genesis / Megadrive version and very few is missing (<10) from console version, i guess some not good prospects.
 
  Official EA worst player of league for 92/93 season is:  
  Kent Paynter - OTW - avg stat value 36 of 100.
  BTW with this sheet you can easily make team of worst of the worst and share the league files to make some fun or nightmare mode.
 
 Main work is done, but is someone is good with Google sheet there are reports to make, lets see Todo sheet.
 
 Otherwise about hacking, i would like to see some backporting photos from newer PC NHLs to players where is not photo available.
 
 Now i not want to see this game for while and i need some rest..
 

Edited by RuThaN
Link to comment
Share on other sites

  • 2 weeks later...

I added some (~ 70) youtube videos links for significant players mainly from The Hockey Guy channel, its best which i know. 
 I thing is great to just could get quickly player stats, story etc just by one click while browsing the list..

Edited by RuThaN
Link to comment
Share on other sites

I pushed my myself to do some table porn.. i always suffering during that and saying that its easier to wrote own program to make it, than use table editor functions. 
I even make it without Pivot tables hell.

On sheet PC-Analysis93 you can find total players values sum for all 24 teams.. same for top6 forwards and defensemen:, nationality counts etc:

Here are example:  // If you want to get 0.. 100 stats for players.. divide just values by 14 (number of stats per player i.e for CGY 12725/14 = 901 ).. if you want to get values for all player together overall average without 100 approximation.. divide value to additionally by 12 (because 12 player. ie for CGY 901/12=75).. with approximation to 100 rating (100 for best player, because otherwise is best player stats average is 86 ) just multiple value by 1.1627 (ie. for CGY - 75 * 1.1627=87 ).

 If someone will extract (to exactly same table format as i used) or just copy from screen values for NHL95 PC version or other version its really easy to do same calculations to them..

Teams TOP 6 forwards + Top 6 defensemen value sum   (more is better):

Team value Sum
CGY 12725
BOS 11530
DET 11255
LA 11155
NYR 11130
WSH 11105
NJD 11035
CHI 11030
VAN 10955
PIT 10900
WPG 10885
EDM 10875
QUE 10845
MTL 10835
TOR 10775
NYI 10700
STL 10695
BUF 10690
SJS 10580
PHI 10555
MIN 10545
HFD 10470
TBL 10370
OTW 9935

 Difference at first look, but not seems to high but where Calgary best players are 75 of 86 (87 to 100 rating) are Ottawa players 59 (70 of 100) and in view how NHL game logic works its huge difference.. and you can even somehow add goalies to logic with some fuzzy logic, because there are much more important that normal players and usually better teams have better goalies.. even Barasso dont sucks in Dos version of 93.

  Otherwise is someone is interested just for fun i made some dream team league team with all best player by stats traded in to show difference.. Sorry there only a bit mess in players number, because i dunno how to edit them.. and if player with same number is already in team, you have to set other number. You can fix it by find some players with same numbers in other team trade players in and out and it the process change jersey numbers to right ones, so far i was lazy to do it.


   I made lines for best play experience, not by just numbers, because slow players or players with low shot accuracy sucks or even if numbers in average are good.

DREAMTEA.LP.7z

Edited by RuThaN
Link to comment
Share on other sites

I used NHL95 PC data extracted by someone above and added them to sheet.. Most problem was adjust stats from 0 to 15 logic to 25 to 100, it would nice to make right inside the code, same as headers.. and vice versa make importing tool which would use my adjusted more human like format sheets as input..

Interesting things from data analysis:
- no more these prospect nonsenses as in NHL Hockey DOS,
-  very best player ib overall are a bit worse (best one 1145 vs. 1210), less superman..
- no more overrated Calgary 10 players in top 20
- number differences between best and worst team are now much smaller
- number differences between best and worst players are smaller.. worst player are now i would say ~ 100 points better still not great, but less useless and these are still healthy scratches..
- best team (Top 6 forwards + Top 6 defensemen ) is now BOS only per few thousands above NYR and CGY is still strong
- best teams just by overall value of player is VAN (21555 for players without goalies), than CHI (21175) and PIT (21100), worst are WOG(18845), SJS(18800) and ANA(18065) and old good beach boys not disappointed either TBL (17380).. Hartford (18995).

Link:

https://docs.google.com/spreadsheets/d/1lak0GSiHA6UKkUIESaYnElAAK62Gbyzj4_c4eMKQTNQ/edit?usp=sharing

  Otherwise i would make some NHL Hockey (93) vs NHL 95, NHL 94 Snes player stat comparison, but it need some formulas which im not able to make so far.. Update: I done NHL 93 vs NHL 95 comparison, but comparision with NHL 94 is problematic there are no sum values.. or input values looks different not (25-100 logic vs 1-6 logic it would be rough less steps ) i thing that PC version is better in this thing.
   Update2: Even with rough hacking, it seems that on console there are less stats for players or i dont understand source data..

image.png

Edited by RuThaN
Link to comment
Share on other sites

I made some NHL94 SNES comparison with NHL 93 and NHL 95 DOS, but its dirty.. it someone understand Genesis data, he could check if i used right one.. dont understand why in Gen comparison are some data omitted and what exactly is for example Roughness skill if is positive or negative one.

  Its in last 2 sheets.. comparison is in the NHL93PCvs95PCvsGen94-PlayersStatsDiff sheet.  I also never used some weights of some skills, because i was just searching for best all around player.. which skill is more important i guess detents on play style.

  Genesis data seems to be worst from point of view, difference between best and worst players.
  NHL 93 PC has -  510 - 1210 total skills points sum range // Middle ground
  NHL 95 PC has  -  690 - 1140 total skills sum points range // Best one.. differences are smaller.
  NHL 94 Gen has  - 308 to 1140 total skills sum points range // Worst..

Edited by RuThaN
Link to comment
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.

×
×
  • Create New...