EHM Prospect Generator [Complete]

Utilities and editors for Eastside Hockey Manager 1.
Post Reply
ImActuallyAnOtter
Junior League
Posts: 10
Joined: Sun May 14, 2017 4:39 am
Favourite Team: Vancouver Canucks

EHM Prospect Generator [Complete]

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
Checking Line
Posts: 556
Joined: Sat Jan 07, 2012 11:21 pm

Re: EHM Prospect Generator [Complete]

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! :notworthy:

ImActuallyAnOtter
Junior League
Posts: 10
Joined: Sun May 14, 2017 4:39 am
Favourite Team: Vancouver Canucks

Re: EHM Prospect Generator [Complete]

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.

User avatar
thegreaterikku
Junior League
Posts: 24
Joined: Fri Aug 12, 2011 5:36 pm
Location: Quebec, Canada

EHM Prospect Generator [Complete]

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
Junior League
Posts: 10
Joined: Sun May 14, 2017 4:39 am
Favourite Team: Vancouver Canucks

EHM Prospect Generator [Complete]

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)

User avatar
Weasel
Junior League
Posts: 43
Joined: Sat Sep 05, 2009 9:08 pm
Favourite Team: Ottawa Senators
Location: Courtenay, Britsh Columbia

EHM Prospect Generator [Complete]

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?

User avatar
Weasel
Junior League
Posts: 43
Joined: Sat Sep 05, 2009 9:08 pm
Favourite Team: Ottawa Senators
Location: Courtenay, Britsh Columbia

EHM Prospect Generator [Complete]

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

User avatar
archibalduk
TBL Admin Team
Posts: 19133
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

EHM Prospect Generator [Complete]

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.

User avatar
Weasel
Junior League
Posts: 43
Joined: Sat Sep 05, 2009 9:08 pm
Favourite Team: Ottawa Senators
Location: Courtenay, Britsh Columbia

EHM Prospect Generator [Complete]

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.

User avatar
Weasel
Junior League
Posts: 43
Joined: Sat Sep 05, 2009 9:08 pm
Favourite Team: Ottawa Senators
Location: Courtenay, Britsh Columbia

EHM Prospect Generator [Complete]

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?

User avatar
archibalduk
TBL Admin Team
Posts: 19133
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

EHM Prospect Generator [Complete]

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.

User avatar
Weasel
Junior League
Posts: 43
Joined: Sat Sep 05, 2009 9:08 pm
Favourite Team: Ottawa Senators
Location: Courtenay, Britsh Columbia

EHM Prospect Generator [Complete]

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
Junior League
Posts: 10
Joined: Sun May 14, 2017 4:39 am
Favourite Team: Vancouver Canucks

EHM Prospect Generator [Complete]

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.

Post Reply

Return to “Utilities (EHM 1)”