J21C's Draft Class and UDFA Generator

jose21crisis
Hall of Fame
Posts: 1336
Joined: Wed Nov 22, 2017 10:14 am

J21C's Draft Class and UDFA Generator

Postby jose21crisis » Sun Jun 16, 2019 10:03 pm

So what I came up here was an Excel Spreadsheet capable of generating complete draft classes, as well as UDFA classes for those that like to use practice squads. The Spreadsheet will output 257 rookies, which can then be imported into an MDC file with Excel or whatever spreadsheet program you have, and then be imported into Madden. It will also generate 193 UDFA rookies, which can then be placed into an MDC file, imported into a backup Madden Franchise to generate the UDFAs, then export it and import it into your main Franchise file.

For it to work, the spreadsheet first generates 450 Rookies. The players per position distribution is the same as Madden 08's players per position distribution. Continuing on, each player is assigned a "Projected Round" and a "Dev Rate". Those numbers are used to determine the player's "Adj. Dev Rate", which is then used to determine a player's ratings. Speed and Jumping are determined randomly based on position, as well as random deviation. Strength is determined by using the player's Body Mass Index. "Adj. Dev Rate" comes into play for the remaining Physical Ratings (Acceleration, Agility), as well as every other Skill Rating (Catching, Carrying, Pass Block, Injury, to name a few). First, the ratings are determined based on position, then a boost or penalty is given depending on the "ADR". High "ADR" players (Those players at the top of the draft, although some mid round guys can qualify) get bigger boosts, or at the very least don't get hit with a penalty. Naturally, Low "ADR" players (UDFAs and lower round guys) either get smaller boosts, or get penalties. These can be quite important. For example, a High "ADR" OL (Say, a highly rated Tackle) could come with solid AWR (60s), all around blocking ability (High 70s to low 80s, with some high 80s around too), and solid strength (90s), along with decent injury and toughness (Not an issue on linemen, but an issue on nearly every other position). Similarly, a Low "ADR" OL (Say, a UDFA Tackle), while he could be pretty good for a UDFA, he could: come with low AWR (Think 40s or even 30s), poor blocking ability (High 60s) or poor injury/toughness (Again, a red flag on other positions). With some luck, you might be able to get UDFA that outperform actual draft picks ... thing is, they are rare.

The spreadsheet is attached here. Every time you ask it to calculate (F9 in my case), it will generate a full, new batch of rookies. Just copy the whole "Output (Draft Class)" sheet into a MDC file and import it, and you should be good to go. The same with the "Output (UDFAs)" sheet, but the process is a bit longer, you do need to use RevanFan's instructions on importing UDFAs into your franchise.

Keep in mind, this is version 2 of this spreadsheet. I was going to release version 1 a while ago, but there were a few issues with guys rated pretty highly. WRs and HBs had way too high catching and carrying. I want the occasional big time running back (An Zeke Elliot or Saquon Barkley type back) or receiver (A Larry Fitzgerald type of receiver) that could be an instant starter, but I don't want the draft to be filled with Pro Bowlers. Another problem is that the OVR of rookies is ALWAYS 50 until the first progression period (UNLESS use NZA or MaddenAMP to recalculate their OVRs, that works too). Finally, the generated classes assume that you are using either FF/FI Mod OR you at least have the Updated College lists on the Modding Forum. You should go pick it up. Finally, if you have any suggestion, such as some ratings being too high or the CPU over-ranking some player positions (Say, HBs, WRs, LBs, CBs to name a few), make sure to report it. I'll find a way to tone that dow.

Credits to:
Cursive - About 50% of the spreadsheet comes from his M19 Draft Class Generator. Most of it is the Height, Weight, Skin Tone, as well as the generation of the Speed and Jump ratings.
LOBBS - I used his method for calculating Strength (Using BMI).
elguapo - I used part of his Roster Monster, namely the body type for players, as well as the face they'll use after being generated.
You do not have the required permissions to view the files attached to this post.
Who Dares Wins

J21C's Draft Class and UDFA Generator

Sponsor

Sponsor
 

User avatar
Danchat
Hall of Fame
Posts: 2445
Joined: Wed Jul 27, 2011 9:07 pm
Location: Minnesota

Re: J21C's Draft Class and UDFA Generator

Postby Danchat » Thu Jun 20, 2019 11:03 pm

Whoa... this looks like it has a ton of work put into it! Good stuff, Jose! I am going to dig into this when I get some time on my hands, as I think this type of draft class generator is right up my alley.
Franchise Journal - Atticus Jenkins: Head Coach of the San Francisco 49ers
http://www.footballidiot.com/forum/viewtopic.php?f=2&t=2387&start=400

jose21crisis
Hall of Fame
Posts: 1336
Joined: Wed Nov 22, 2017 10:14 am

Re: J21C's Draft Class and UDFA Generator

Postby jose21crisis » Mon Jun 24, 2019 12:37 am

Danchat wrote:Whoa... this looks like it has a ton of work put into it! Good stuff, Jose! I am going to dig into this when I get some time on my hands, as I think this type of draft class generator is right up my alley.

Go ahead, give it a look. See if there's anything that could be improved.
Who Dares Wins

User avatar
RevanFan
Legend
Posts: 11002
Joined: Fri Jul 15, 2011 5:25 pm
Location: New York

Re: J21C's Draft Class and UDFA Generator

Postby RevanFan » Mon Jun 24, 2019 3:25 pm

I am very interested in trying this, especially since making UDFAs for my franchise takes freaking forever, but I'm not very familiar with the MDC file format? Wasn't there an issue with NZA where it wouldn't import the jump rating when importing an MDC file?

Also, regarding player face IDs, do you have it randomly select between all available faces? Because it always pisses me off that Madden by default only uses a select few for rookies. I always go through each player I draft and assign them a new random face based on their previously assigned skin tone.
My Historic Cowboys Teams - http://footballidiot.com/forum/viewtopic.php?f=12&t=240
My Cowboys Journal - http://footballidiot.com/forum/viewtopic.php?f=2&t=3610
I'm a die hard Cowboys fan and a New Yorker born and raised.

User avatar
RevanFan
Legend
Posts: 11002
Joined: Fri Jul 15, 2011 5:25 pm
Location: New York

Re: J21C's Draft Class and UDFA Generator

Postby RevanFan » Mon Jun 24, 2019 3:28 pm

jose21crisis wrote:The same with the "Output (UDFAs)" sheet, but the process is a bit longer, you do need to use RevanFan's instructions on importing UDFAs into your franchise.

Did I ever actually publish those intructions? I'm not sure I have. If I sent them to you at some point, could you forward them back to me? Or you can post them yourself in the Franchise Guides forum. Just give me credit.
My Historic Cowboys Teams - http://footballidiot.com/forum/viewtopic.php?f=12&t=240
My Cowboys Journal - http://footballidiot.com/forum/viewtopic.php?f=2&t=3610
I'm a die hard Cowboys fan and a New Yorker born and raised.

jose21crisis
Hall of Fame
Posts: 1336
Joined: Wed Nov 22, 2017 10:14 am

Re: J21C's Draft Class and UDFA Generator

Postby jose21crisis » Mon Jun 24, 2019 3:54 pm

RevanFan wrote:I am very interested in trying this, especially since making UDFAs for my franchise takes freaking forever, but I'm not very familiar with the MDC file format? Wasn't there an issue with NZA where it wouldn't import the jump rating when importing an MDC file?

Also, regarding player face IDs, do you have it randomly select between all available faces? Because it always pisses me off that Madden by default only uses a select few for rookies. I always go through each player I draft and assign them a new random face based on their previously assigned skin tone.

The method that I've tried that works is keeping an MDC around (Which I get by exporting a draft class in NZA), which I open with Excel then I put the generated Draft Class/UDFAs, then re import them using NZA.

I have the spreadsheet randomly select a face based on skin tone, so that SHOULDN'T be an issue.

RevanFan wrote:Did I ever actually publish those intructions? I'm not sure I have. If I sent them to you at some point, could you forward them back to me? Or you can post them yourself in the Franchise Guides forum. Just give me credit.

I actually meant your Guide to Undrafted Rookies in Franchise Mode. But instead of directly exporting the PLAY CSV of the "Rookie Generating" franchise, first you import the MDC with the UDFAs into the "Rookie Generating" franchise. After that you just export the PLAY CSV as the instructions say and move on.
Who Dares Wins

User avatar
RevanFan
Legend
Posts: 11002
Joined: Fri Jul 15, 2011 5:25 pm
Location: New York

Re: J21C's Draft Class and UDFA Generator

Postby RevanFan » Mon Jun 24, 2019 3:56 pm

jose21crisis wrote:
RevanFan wrote:Did I ever actually publish those intructions? I'm not sure I have. If I sent them to you at some point, could you forward them back to me? Or you can post them yourself in the Franchise Guides forum. Just give me credit.

I actually meant your Guide to Undrafted Rookies in Franchise Mode. But instead of directly exporting the PLAY CSV of the "Rookie Generating" franchise, first you import the MDC with the UDFAs into the "Rookie Generating" franchise. After that you just export the PLAY CSV as the instructions say and move on.

I completely forgot I posted that. I guess when you've been posting on the forums for... uh... 11 years, things start to blur.
My Historic Cowboys Teams - http://footballidiot.com/forum/viewtopic.php?f=12&t=240
My Cowboys Journal - http://footballidiot.com/forum/viewtopic.php?f=2&t=3610
I'm a die hard Cowboys fan and a New Yorker born and raised.


Return to “Draft Classes”

Who is online

Users browsing this forum: No registered users and 0 guests