RuThaN

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..

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..

It would be nice to add also some view mode export format with table header.. and stats converted to 0-100 format value. Even better would be possibility to export these stats from this document back to game.. But it would maybe need probably some more advanced coding with Excel internal format parsing..

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

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..

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..

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

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.

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..

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