Simplified Draft Classes 2018-2022 (XB1 & PS4) - Operation Sports Forums
Home

Simplified Draft Classes 2018-2022 (XB1 & PS4)

This is a discussion on Simplified Draft Classes 2018-2022 (XB1 & PS4) within the Madden NFL Football Rosters forums.

Go Back   Operation Sports Forums > Football > Madden NFL Football > Madden NFL Football Rosters
Reply
 
Thread Tools
Old 10-19-2017, 05:15 PM   #1
Rookie
 
klawler's Arena
 
OVR: 2
Join Date: Jun 2006
Simplified Draft Classes 2018-2022 (XB1 & PS4)

If you want a simplified way to get most of the college players into Madden 18 for XB1 or PS4 then download this Excel spreadsheet and follow these basic steps...

.xlsx file -->https://drive.google.com/open?id=0B_...EFSSWJ0dG82bnM
.xls file -->https://drive.google.com/file/d/0B_d...ew?usp=sharing

1. After you complete your draft take a video with your phone cycling through all the teams draft picks.

2. Using the video you took then open a new blank tab in the Excel file provided and start entering in each of the teams highest rated draft picks. It doesn't matter what round just keep the best players. Enter the Team, Player Name, Position and Overall rating. Just get between 45-55 players that you would like to see as rookies. Once done adding players create a filter on Overall rating and sort highest to lowest. Then, cut and Paste the players into their proper slots in the 2018 Draft class tab.

For example, the highest rated running back for 2018 will be Saquon Barkley, so whichever team drafted the highest rated running back will now get assigned Saquon.

3. Once finished entering all the information in Excel either print out a copy of your completed draft class or use your laptop to go into each teams rosters and make the necessary edits to the player names, colleges, height, weight, skin color, ratings, etc...

4. I will typically give only a few players (maybe 2-3) Superstar ratings but then leave all the other players random for development.

5. I most likely won't be making any new versions of this file so feel free to do so yourself. If you want to see a different player or change some of the overall ratings then go for it. It's a good starting point and I've spent a lot of time so far. Now it's time to enjoy the game!

Cheers,
klawler


Last edited by klawler; 10-30-2017 at 12:40 PM. Reason: Added .xls link for Excel 1997-2003
klawler is offline  
Reply With Quote
Advertisements - Register to remove
Old 10-27-2017, 06:25 PM   #2
MVP
 
tonybologna's Arena
 
OVR: 27
Join Date: Sep 2005
Location: East Tennessee
Posts: 8,019
Blog Entries: 4
Question Re: Simplified Draft Classes 2018-2022 (XB1 & PS4)

The Google Drive link isn't loading up for me. Could you please check or fix? Thanks.
__________________
NCAA- GO VOLS
NBA- GO CELTICS
MLB- GO BRAVES
NFL- GO COWBOYS
NHL- GO PREDATORS
NASCAR- Chase Elliott
MLS- LA Galaxy

RIP Pat Summitt: We will all miss you!

Jeremiah 29:11
tonybologna is offline  
Reply With Quote
Old 10-30-2017, 12:43 PM   #3
Rookie
 
klawler's Arena
 
OVR: 2
Join Date: Jun 2006
Re: Simplified Draft Classes 2018-2022 (XB1 & PS4)

Quote:
Originally Posted by tonybologna
The Google Drive link isn't loading up for me. Could you please check or fix? Thanks.
I added a .xls file link for Excel 1997-2003. My gues is the .xlsx file might not work if your version of Excel isn't newer.
klawler is offline  
Reply With Quote
Old 10-30-2017, 04:56 PM   #4
MVP
 
tonybologna's Arena
 
OVR: 27
Join Date: Sep 2005
Location: East Tennessee
Posts: 8,019
Blog Entries: 4
Re: Simplified Draft Classes 2018-2022 (XB1 & PS4)

Quote:
Originally Posted by klawler
I added a .xls file link for Excel 1997-2003. My gues is the .xlsx file might not work if your version of Excel isn't newer.
I was saying that the link itself wasn't loading up. Nothing to do with what version of Excel that I am using. Haven't even gotten that far yet. I will try the link(s) again. Thanks.
__________________
NCAA- GO VOLS
NBA- GO CELTICS
MLB- GO BRAVES
NFL- GO COWBOYS
NHL- GO PREDATORS
NASCAR- Chase Elliott
MLS- LA Galaxy

RIP Pat Summitt: We will all miss you!

Jeremiah 29:11
tonybologna is offline  
Reply With Quote
Old 11-23-2017, 01:02 PM   #5
MVP
 
Yaoza11's Arena
 
OVR: 8
Join Date: Jan 2003
Re: Simplified Draft Classes 2018-2022 (XB1 & PS4)

This is great work. Thank you!
Yaoza11 is offline  
Reply With Quote
Old 12-06-2017, 08:19 AM   #6
Rookie
 
klawler's Arena
 
OVR: 2
Join Date: Jun 2006
Re: Simplified Draft Classes 2018-2022 (XB1 & PS4)

Franchise Mode Update #1

Although it takes a good bit of time to enter all these players names and information I really do enjoy these simplified draft classes. I'd like to share a list of the highest rated prospects from the excel file at this point in my career mode. These ratings will not be the same for you so no spoilers. These overall ratings were taken at the beginning of week 11 in the 2021 season. Keep in mind I've already done 4 draft classes so it's obviously the first class that has progressed the most. I hope you are all having similar progress. Enjoy!

-Klawler

C Will Clapp 96
QB Josh Rosen 95
LT Jonah Williams 95
HB Saquon Barkley 94
LG Tyrone Crowder 92
ROLB Harold Landry 92
HB Mike Weber 92
HB Royce Freeman 90
LE Arden Key 90
LOLB James Hearns 90
TE Mike Gesicki 89
ROLB Jerome Baker 88
LG Quentin Nelson 88
QB Sam Darnold 88
FS J. Whitehead 88
HB Cam Akers 88
LT M. McGlinchey 88
SS Derwin James 88
FS Taylor Rapp 87
HB T. Williams 87
LE Bradley Chubb 87
QB Jacob Eason 87
RG S. Quesenberry 87
C Billy Price 86
RE Nick Bosa 86
CB C. Gardner 86
TE M. Saunders 86
FS Marcus Allen 86
QB Shea Patterson 86
LT Trey Adams 86
WR Christian Kirk 85
DT Dremont Jones 85
QB Mason Rudolph 85
RT Connor Williams 85
MLB Cameron Smith 85
MLB Michael Pickney 85
CB Iman Marshall 85
DT C. Wilkins 85
LE Clelin Ferrell 85
CB Levonte Taylor 85
CB T. McFadden 85
SS M. Fitzpatrick 85
LOLB Joe Jackson 85
C Mason Cole 85
C TJ McCoy 85
WR D Peoples-Jones 85
SS Devon Hunter 85
TE Colby Parkinson 85
SS Terrell Edmunds 85
RG Martez Ivey 84
QB Justin Fields 84
WR Calvin Ridley 84
QB Jake Fromm 84
klawler is offline  
Reply With Quote
Old 12-06-2017, 04:22 PM   #7
Working for the weekend
 
Herky's Arena
 
OVR: 32
Join Date: Jun 2004
Location: Davenport, Iowa
Posts: 4,684
Blog Entries: 7
Re: Simplified Draft Classes 2018-2022 (XB1 & PS4)

How are you determining what trait to use for each player? For example, speed HB or mobile QB.
__________________
GT: Herkyalert
PSN: Herkyalert

Iowa Hawkeyes
Northern Iowa Panthers
Minnesota Vikings
Chicago Cubs
Minnesota Twins
Boston Celtics
Minnesota Timberwolves

Last edited by Herky; 12-06-2017 at 04:25 PM.
Herky is offline  
Reply With Quote
Old 12-06-2017, 04:54 PM   #8
Rookie
 
klawler's Arena
 
OVR: 2
Join Date: Jun 2006
Re: Simplified Draft Classes 2018-2022 (XB1 & PS4)

Quote:
Originally Posted by Herky
How are you determining what trait to use for each player? For example, speed HB or mobile QB.
Good question, I might revise the spreadsheet to include this... For the QB's I already know what their play styles are and just assign them traits according to mobile, balanced or pocket passer. For the HB's I like to make the big guys (225 lbs +) powerbacks, the balanced guys I prefer one cut and the little receiving backs get speed.
klawler is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Football > Madden NFL Football > Madden NFL Football Rosters »


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 11:25 AM.

Top -