This file should help cure your ills: https://www.dropbox.com/s/989rk5y0s25pn ... .xlsx?dl=0
What does it do?
Using some overly ridiculous Excel Logic, this file generates prospects for the next 16 seasons; many of which should become NHL players; some of which actually have the potential to become superstars.
Specifically?
Each year, the following is generated:
23 players (3 G, 7 D, 13 F) with PA's ranging from 115 to 175 (Significantly tends towards lower) - these are "specialist" players - sniper, playmakers, defensive D that actually work as defensive D etc
A further 23 players (3 G, 7 D, 13 F) with -8 and -7 PA's - these are also "specialist" players - sniper, playmakers etc
3 High PA players (1 G, 1 D, 1 F*) (PA 170-200, but tending towards the lower end of the range) - generated to be elite at their position.
*F will always be a natural C, may have other positions as well.
I also generate a bunch of rarer nationality players so that every national team has 23 players, because I think that's cool. They generally have low PA's, maxing out around 120-130.
Names and Nationalities etc.?
There's an inbuilt name database. Nationalities are decided by RNG, roughly 40% of prospects generated are Canadian, 25% are American, 25% Scandinavian/Russian, 10% anything else.
I wanna play further than 16 seasons at the draft!
Sure, add 16 to the Draft Year in the cover sheet and import that XLS as well.
Instruction on how to use are inside the file. Enjoy! I've tested this with TBL, NHL32, NHL36 db etc and seems to work with all.
Let me see how good a prospect you can get out of this
