EHM Prospect Generator [Complete]

ImActuallyAnOtter · Post by **ImActuallyAnOtter** » Fri May 25, 2018 10:34 pm

Tired of prospects becoming terrible after a while? Have you ever seen the game generate an elite goalie? Any Crosby's or Ovechkin's?

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

BKarchitect · Post by **BKarchitect** » Sat May 26, 2018 2:19 am

Wickedly cool concept for one of the game’s bigger flaws. Busy editing right now but will definitely want to test drive this when I start a new game.

Let me ask, without even opening this up - do we import the generated players in via archi’s editor? I assume we could also tweak the generated results? For example, in NHL36 I’ve got a pretty robust prospect base with lots of future stars thru about the 2020 or 2021 NHL Drafts. After that, as you make light of, the game really struggles to generate any decent prospects until the real stars start to retire - at that point, I find the draft classes start to go back up in quality; I know there are no longer direct regens but there definitely is an influence. So I don’t want to “pollute” the drafts that are currently stocked (with real ‘specs) with fake names but I absolutely want to beef up future drafts...at least for a while.

Using the concept of this generator to fill that gap and to keep robust draft classes entering the NHL would be ideal and could also help prevent the league from having a ton of really aging and old teams that seems to occur right now when the stock of real star prospects runs out and you have that dry period. With no good young players, every team seemingly ices old squads.

Nice work though and I’m sure the excel file is a masterpiece of equations!

ImActuallyAnOtter · Post by **ImActuallyAnOtter** » Sat May 26, 2018 2:33 pm

Yeah that’s a complex one to answer...

Firstly, instructions on how to import are included

Second, it would be tough to edit the output in any way unless you really knew the core of the generator.

Regarding your prospect issue there, There’s a whole bunch of hidden tabs you could look into - but I think the easiest way to do it would be to set your first draft year to 2022, and then Change all the current abilities in the csv tab to RANDBETWEEN(1,31). Reputations will even out on their own prior to drafting.

I’m usin your nhl32db as an online league right now - I made significant edits to your prospects to tone them down because I thought you were barking mad xD. I also change every fixed pa of 145 or more to a -7, -8 etc. For randomness.

What I have found when testing your dB though is players just don’t hit their potentials as often. I’m guessing the game only “allows” a certain number of high ca players at any one time.

thegreaterikku · Post by **thegreaterikku** » Mon Jul 09, 2018 7:01 pm

Good afternoon,

I was looking at the .csv file generated and is it normal that only a selected few people have all the info generated? Like there's a first batch, then another with just names then another with everything and so on. Is it supposed to be like this?

ImActuallyAnOtter · Post by **ImActuallyAnOtter** » Fri Aug 03, 2018 12:57 am

Hi everyone,

I've rehashed this one completely to improve generation and randomness.

Link: https://www.dropbox.com/s/ozi1t2rtwpt6b ... .xlsx?dl=0

Don't want to mess with Excel and just want to import something into the pre-game editor? Try one of these:
CSV File #1 - https://www.dropbox.com/s/c3qk1n84n91v9 ... 1.csv?dl=0
CSV File #2 - https://www.dropbox.com/s/pjahxr2x5swfp ... 2.csv?dl=0
CSV File #3 - https://www.dropbox.com/s/ifmshunnhtts9 ... 3.csv?dl=0

This one is a little different. it generates the following (per calendar year):
- 1 franchise/generational prospect (any skater position)
- 3 elite prospects (1G, 1D, 1F)
- 9 "-15" prospects
- 8 "-14" prospects
- 4 "-9" prospects
- 10 "-8" prospects
- ~32 "-7" prospects
- ~64 "-6" or "-13" prospects

Nationalities, Names, City of Births etc. all run off random number generation.

Reminder:
-6 Potential will be between 90-120
-7 Potential will be between 110-140 (quite rare - a good prospect with a decent chance of being a regular NHL player)
-8 Potential will be between 130-160 (rare - a top prospect with a good chance of being a talented NHL player)
-9 Potential will be between 150-180 (very rare - a top 10 prospect who is considered a can't miss NHL talent)

-13 Potential will be between 60-130 (intended for very young, hard-to-predict players)
-14 Potential will be between 90-160 (intended for very young, hard-to-predict players)
-15 Potential will be between 110-190 (intended for very young, hard-to-predict players)

Weasel · Post by **Weasel** » Sat Dec 15, 2018 12:55 am

Hi; I am trying to use your generator but I keep getting an error. I am using MS Office 2009. I open generator revD in excel and set the year to 2043 (yep, playing a long time) and hit F9, I then click on the csv tab, press CTL-A (select all) and copy. I then create a new excel workbook and paste (ctl-c) and save that as a CSV (tried both DOS and comma delimited) but always get an error message: 'the selected file type does not support workbooks that contain multiple sheets' and then continue to save only the active sheet yes/no. If I say yes and try to import into the editor the editor says there are no columns and data to import.

What am I doing wrong, is it something to do with macros?

Weasel · Post by **Weasel** » Sat Dec 15, 2018 1:02 am

Just as a follow up, I tried your 3 auto generated CSV and they do the same, the editor says "there are no valid rows to import".

Post by **archibalduk** » Sat Dec 15, 2018 9:01 am

Weasel wrote: ↑
Sat Dec 15, 2018 12:55 am
Hi; I am trying to use your generator but I keep getting an error. I am using MS Office 2009. I open generator revD in excel and set the year to 2043 (yep, playing a long time) and hit F9, I then click on the csv tab, press CTL-A (select all) and copy. I then create a new excel workbook and paste (ctl-c) and save that as a CSV (tried both DOS and comma delimited) but always get an error message: 'the selected file type does not support workbooks that contain multiple sheets' and then continue to save only the active sheet yes/no. If I say yes and try to import into the editor the editor says there are no columns and data to import.

What am I doing wrong, is it something to do with macros?

CSV files can only contain one worksheet. So you have to paste one worksheet into your spreadsheet and delete all others. Then save as CSV.

Weasel · Post by **Weasel** » Sat Dec 15, 2018 7:09 pm

Hi; Yep, got that part, but even the CSV from his own links do not work, and they are a single sheet. I even tried it as an excel worksheet just to see but that failed too.
Thanks.

Weasel · Post by **Weasel** » Sat Dec 15, 2018 7:29 pm

When copying and pasting into a new workbook, should macros be enabled, disabled, or doesn't matter in the new book?

Post by **archibalduk** » Sat Dec 15, 2018 8:33 pm

Weasel wrote: ↑
Sat Dec 15, 2018 7:29 pm
When copying and pasting into a new workbook, should macros be enabled, disabled, or doesn't matter in the new book?

It doesn't matter. CSV is just a plain text file and does not support macros.

Weasel · Post by **Weasel** » Sat Dec 15, 2018 9:07 pm

Ok, thanks. Yeah, no matter what I try EHM Editor says there is nothing to import.

ImActuallyAnOtter · Post by **ImActuallyAnOtter** » Wed Jan 23, 2019 11:18 pm

Hi all, sorry for the delay in responding. I've got a new version of the Prospect Generator which I'm planning to release soon and should have far easier usability etc.

The CSV error comes from not deleting the 2 additional tabs in Excel when you create a new workbook.

xECK29x · Post by **xECK29x** » Sat Feb 09, 2019 2:09 am

Any chance there is a way I can build a version for my DB? I've added a ton of names/places of birth and would like to use my expanded junior team club list.

TurboJ · Post by **TurboJ** » Wed Feb 13, 2019 2:16 am

ImActuallyAnOtter wrote: ↑
Fri Aug 03, 2018 12:57 am
Don't want to mess with Excel and just want to import something into the pre-game editor? Try one of these:
CSV File #1 - https://www.dropbox.com/s/c3qk1n84n91v9 ... 1.csv?dl=0
CSV File #2 - https://www.dropbox.com/s/pjahxr2x5swfp ... 2.csv?dl=0
CSV File #3 - https://www.dropbox.com/s/ifmshunnhtts9 ... 3.csv?dl=0

May I ask how these differ from each other? And is there any reason the Excel version would be better? I take it that these .csv files use RNG for names and nationalities?

Also, I'm new with editing EHM; if I want to use one of the above files, I just import the file from the starting screen in-game, right?
What starting options should I use along with this, or does it not matter? (Add extra players etc, all those kinds of options)

Thanks for the effort btw! The medicore prospects one gets in the un-edited game is a real turnoff as it makes the whole draft business almost redundant.

TurboJ · Post by **TurboJ** » Fri Feb 15, 2019 6:59 am

Anyone? I'd really want to try these out but I'm scared of messing up the install and setup. It takes a long time to get to the first draft to see if the plugin worked you know...

So please if someone can, just instruct me in a noob friendly way how to set this thing up when starting a new game (without excel, please as I don't have excel).

THANKS.

TurboJ · Post by **TurboJ** » Fri Feb 15, 2019 3:08 pm

edit. I'd also like to know if you could use this on an existing savegame. Any help would be much appreciated.

ktbits1234 · Post by **ktbits1234** » Sat Mar 16, 2019 4:30 pm

Any idea, when the new version will come out?
Thanks for your awesome work

Moses Doughty · Post by **Moses Doughty** » Wed Apr 10, 2019 7:22 pm

Do you happen to still have workable links for the pregame downloadables? Doesn't seem to work anymore

ImActuallyAnOtter · Post by **ImActuallyAnOtter** » Wed Apr 17, 2019 2:51 pm

Hi all,

New version released.

Link: https://drive.google.com/file/d/1j9IzOO ... sp=sharing

TurboJ · Post by **TurboJ** » Thu Apr 25, 2019 11:22 am

Played with the earlier version of this for about 6-7 seasons and was very satisfied with the results. The draft became much more useful with there being more than 1-2 useful prospects per year. As promised, there were also a few good goalies added by this generator. Some players had, erm, "unexpected" nationalities, but of course it's a matter of taste whether that's a good or bad thing (variety vs. immersion I guess.) In any case, this made the game much more enjoyable because spending time and effort drafting well really paid off.

Gonna try the new version now, thanks for making it!