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.
He is otherwise good, but not super good (#45 in League). All other prospects have reasonable numbers.Ģ) Andre Faust - as guess because of demonic name has Endurance 390, insted of 90 a guess he has to be importal, as some bug. Same thing is Oleg Petrov Edmonton - #6, but i maybe heard about this one once. He managed 8 point in first 27 game, so some analytic go excited way too much. And in same way all players even with good 92/93 stats in TBL,SJS and OTW have trash stats.ġ) 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. 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.Īll 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. I fixed most of them but russian names are nightmare there is sometimes Vachaslav, sometime vaichaslav, vaychaslav etc, ui dunno what is right. 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.
#Nhl 21 team ratings code
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. If you have an older version of Excel, you'll need to manually adjust the scale.Ĭomments 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.
Note that the automatic scale won't work in Excel unless you have the Excel 365 version because it uses the function MAXIFS. This is very helpful for draft leagues, or in general. Really, you can customize your ratings however you prefer. If you want lighter players, put a negative value on weight. Mario isn't the top rated player anymore, but Mogilny, Yzerman, Bure, etc. When I go to my Forwards on the "New Ratings" sheet, you can see the updated overall calculations as compared to the original: And so I put in my new custom attributes as follows: 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. The sheet is defaulting to be equal to the original. The automatic scale will make sure the top rated F/D/G are the same as the original game so the data makes sense.
#Nhl 21 team ratings update
On this page you can change the values in the "custom" ratings and the sheet that says "new ratings" will update automatically. The sheet that I provided allows you to value the attributes to your OWN preference to come up with new calculated ratings: 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. So for Wayne Gretzky, his calculation would be as follows. The total is above 99, the overall will display 99. If the total is less than 50, divide the total number by 2 and add 25. Take the attributes values (0-6) and multiply them by the following factors:Īdd all of those numbers together to get the “overall” number.
The default overall calculation that the game uses for Forwards and Defensemen is as follows. Wayne Gretzky is 87 overall! But what does that mean? I added the ability to customize the player overall scores as compared to the original version.įor reference, here is how the overall calculation works in NHL'94 (thanks - original reference) This is useful for draft leagues or anyone interested in the player attributes. This Google Sheet has all of the NHL'94 players, duplicates removed, and their ratings. This has been asked a bunch, so here it is.
0 kommentar(er)
