Home

Madden 19 CFM Scouting Tool

This is a discussion on Madden 19 CFM Scouting Tool within the Madden NFL Football forums.

Go Back   Operation Sports Forums > Football > Madden NFL Football
Forza Horizon 5 Review
Have Card-Collecting Modes Become Too Complicated?
Hockey Ultimate Team in NHL 22 Polishes Familiar Formula
Poll: What's more important to you, when the time comes to purchase a game? (Click to vote)
Reply
 
Thread Tools
Old 10-14-2018, 12:12 PM   #1
Pro
 
Old Man Nathy's Arena
 
OVR: 0
Join Date: Jan 2015
Arrow Madden 19 CFM Scouting Tool

Download the Excel version of the tool from here:
https://drive.google.com/file/d/1-V8...ew?usp=sharing


Download the Sheets version of the tool from here:
https://drive.google.com/open?id=1Nr...mG_7DIRTcwAicQ



Hello and welcome to the Madden 19 edition of the (in)famous Madden Scouting Tool! EA made a lot of big changes to the way team-building works in CFM this year, with a much greater emphasis on scheme fits, some all new archetypes, specialist positions on the depth chart, extra attributes, and draft classes that are more linear than in previous iterations of the game (more on this in a second). The result is that I had to rewrite the tool pretty much from scratch, but I hope you'll agree that the results have been worth the effort.



What is the scouting tool?
The Scouting Tool is a spreadsheet where you input data about prospects in Madden 19 CFM. The tool has an algorithm that calculates the value of a player based on your inputs, taking into account their scouted skills/grades, combine scores, projected round, talent round, and myriad of other factors. This allows you to fairly and objectively rank prospects against each other, giving you an advantage in CFM. It also helps you conserve scouting points throughout the season by projecting how good/bad a prospect is, allowing you to focus on the guys that are likely to be talented. It also outputs loads of other cool reports, like Top 5 players at each position, a draft day planner, and individual NFL.com-style scouting reports.



Key Features
  • Never draft a bust: "Draft Status" column separates the blue chippers from the scrubs using a huge number of position-specific checks against unlocked scouting attributes and combine stats.
  • Set up your Big Board correctly: The tool provides a ranking algorithm to help you set your board before draft classes. Invaluable, particularly in Online CFMs where you're unable to attend the live draft!
  • Scout Dev Traits: My extensive research into how you can use draft stories to predict dev traits is incorporated into the tool.
  • Find the mid/late round gems: You will now be able to see the potential stars hiding in the middle and late rounds of the draft.
  • Find depth in the later rounds: As well as the elite prospects, the tool will also find potential contributors for your team who are likely to have an OVR in the 70-74 range.
  • Set your team building philosophy: are you in win-now mode or rebuilding longer term? Set your philosophy and the tool will adjust your board accordingly.
  • Choose how you approach the draft: do you go BPA or draft for need? The tool will re-rank prospects based on your preferences.
  • Set your biggest needs and positions of strength: prioritise players at different positions on your board based on your roster's strengths and weaknesses.
  • Set your schemes: scheme fit is king in Madden 19, and the tool will help you find players who can be adjusted to fit your scheme.
  • Conserve your scouting points: the tool will predict whether a player looks like a top-tier prospect (blue chip), a decent prospect (red chip) or a depth player only while you input data. This will help you only spend your scouting points on players worth scouting.
  • See the Top 5 players at each position: new feature for this version, the tool will show you the best prospects at each position group.
  • Get ready for draft day with the Draft Day Planner: another new feature, the tool will show you who is likely to be available at each of your picks. Invaluable for offline leagues!
  • NFL.com-style scouting reports: a cool little feature, you can now generate individual scouting reports against every prospect on your board, complete with strengths, weaknesses and pro comparisons.



Preview Images
Check out this album of gifs to see some of the different parts of the tool in action:

https://imgur.com/a/yRtvRas

Your Big Board:
[img]https://i.redd.it/2uy29p1kn8r11.gif]/IMG]

Your Team Settings:


Draft Day Planner


Individual Scouting Reports


Top 5 Players at Each Position



Compatibility
The tool is designed to work with auto-generated draft classes only. It will not work with custom draft classes, as it relies on the Madden 'templates' for prospects to know what the hidden attributes will grade out at. Custom draft classes will be all over the place.

The tool is designed to work in Excel 2016 desktop application. There are various compatibility issues with other spreadsheet tools, detailed below.



Old versions of Excel

I use a new function called TEXTJOIN for some stuff on the scouting reports in particular, so there will be some bits that come up blank for schemes in Excel 2013. Other than that, it will work fine. For Excel 2010 and older, The draft board rank will not work, and there will be various other bits that won't either. It's not going to work well in Excel 2007 or older.



Google Sheets

I've now released a Sheets-optimised version of the tool. There are some trade-offs in terms of usability and look and feel, but it will work fine now.


Excel Online:

It ain't gonna work well... Just download it and use it on the desktop!



Excel Mobile App:

You can give it a try, but it isn't gonna be pretty... It's designed for desktop.



Thanks and Acknowledgements

This tool took a lot of effort to create, and it wouldn't have been possible without the vast array of people who have helped me, including many from within my league (reddit.com/r/MaddenGMs), reddit.com/r/madden, and Operation Sports.



The following people helped me gather pre-requisite information to build the tool:

- u/TheWunderWaffe (AKA Jox)

- u/Teutonic

- Trey31 (Operation Sports)



The following people gave me data to help tailor the TVR algorithm and helped me BETA test:

- u/JD81ND (AKA Jim)

- u/jjnelson30

- u/adiobroyster

- u/pbnotorious

- u/darceknight

- dxpsman (Operation Sports)



Previous Versions of the Tool if you're not using Madden 19 yet
Madden 18 version

Madden 17 version





Download the Sheets version of the tool from here:
https://drive.google.com/open?id=1Nr...mG_7DIRTcwAicQ
__________________

v7.1 released 16th October 2018! Check out the thread and download the latest version!

Last edited by Old Man Nathy; 10-16-2018 at 08:29 AM.
Old Man Nathy is offline  
Reply With Quote
Advertisements - Register to remove
Old 10-14-2018, 12:43 PM   #2
Rookie
 
OVR: 0
Join Date: Sep 2017
Location: Dublin, Ireland
Re: Madden 19 CFM Scouting Tool

Thanks Nate. I'm sorry for dropping if the face of the Earth earlier this year after trying to start work on a web version of this. I ended up moving countries for work and side projects had to take a back seat to life.

Really excited to give this a go!
pkloehn is offline  
Reply With Quote
Old 10-14-2018, 01:53 PM   #3
Rookie
 
OVR: 0
Join Date: Sep 2018
Re: Madden 19 CFM Scouting Tool

First of all, this is the greatest tool for Madden. Thank you and everyone else that put in work for this!

Do you still recommend the scouting strategy that you had on Reddit? Where you want to scout younger guys, then 1st rounders, etc.

Last edited by J.hunt1376; 10-14-2018 at 01:54 PM. Reason: Props
J.hunt1376 is offline  
Reply With Quote
Old 10-14-2018, 02:37 PM   #4
That's top class!
 
extremeskins04's Arena
 
OVR: 1
Join Date: Aug 2010
Location: Boston, Mass.
Posts: 3,640
Re: Madden 19 CFM Scouting Tool

Nate you have once again outdone yourself. This is incredible. Thank you so much!
extremeskins04 is offline  
Reply With Quote
Old 10-14-2018, 04:03 PM   #5
Just started!
 
OVR: 0
Join Date: May 2017
Re: Madden 19 CFM Scouting Tool

Can I just say, having used both previous tools, that you have completely outdone yourself with this one? This is really freaking awesome!
MonoBird is offline  
Reply With Quote
Advertisements - Register to remove
Old 10-14-2018, 06:00 PM   #6
Rookie
 
WeWereGiants's Arena
 
OVR: 0
Join Date: May 2012
Re: Madden 19 CFM Scouting Tool

__________________
San Francisco 49ers
Golden State Warriors
San Francisco Giants
San Jose Sharks
Stanford Cardinal
WeWereGiants is offline  
Reply With Quote
Old 10-14-2018, 10:34 PM   #7
Pro
 
rkocjay's Arena
 
OVR: 0
Join Date: Oct 2013
Location: Brooklyn NY
Re: Madden 19 CFM Scouting Tool

I really like the individual scouting screen. Great addition.

Sent from my SM-G960U1 using Operation Sports mobile app
__________________
Yankees Lakers NY Giants


U mad Bro!!
rkocjay is offline  
Reply With Quote
Old 10-14-2018, 10:45 PM   #8
Rookie
 
OVR: 1
Join Date: Sep 2010
Re: Madden 19 CFM Scouting Tool

Thank you as always. Is there a way to unlock the sheet enough to be able to sort it but not accidentally erase vital columns? I'd also like to be able to change the column widths and hide the college column
phantomshark is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Football > Madden NFL Football »


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 08:19 AM.

Top -