Madden 18 CFM Scouting Tool - Operation Sports Forums
Home

Madden 18 CFM Scouting Tool

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

Go Back   Operation Sports Forums > Football > Madden NFL Football
Reply
 
Thread Tools
Old 08-24-2017, 09:51 AM   #1
Rookie
 
Old Man Nathy's Arena
 
OVR: 0
Join Date: Jan 2015
Arrow Madden 18 CFM Scouting Tool

Hi all, and thanks for checking out the Madden CFM Scouting Tool. A good number of you will have used the previous iterations of this tool for Madden 17, and I'm pleased to say that it's back and better than ever. There's a load of new features and it's been tuned to work with the current M18 draft classes.

Download Here (or from the attachment on this thread)



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 dynamic dev traits is now 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.
  • Rebuild through the draft like a real GM: The tool will help you draft entire classes of high quality players who are all potential starters for your team.
  • Draft by BPA: The unique "True Value Rating" system provides a ranking algorithm to compare all prospects so that you can always draft best player available.
  • Compare YOUR draft class to the average Madden draft class: Draft Class Strength Analysis tab shows you how your class compares to the average class in terms of elite prospects, depth, and strength at different positions.
  • Scout efficiently: Tool ensures you spend your scouting points as efficiently as possible, ruling out players with a low OVR quickly in the scouting process.
  • Scout more players: the Tool will ensure you can cover as many prospects as possible in the class, meaning you don't have to focus on positions of need.
  • Bring in Free Agents at the right positions: Draft Class Strength Analysis will show you which holes in your team you can plug through the draft, and which areas you would be advised to bring in Free Agents.

Preview Images:
Here is a little preview of V5 of the tool (N.B. this is an incomplete draft class):






New for Madden 18!
  • Choose player archetypes: The player type (e.g. 3-4 Pass Rusher, Cover 2, Run Stopper etc.) will now affect the Grade given to players in the tool. This will help you find players that perfectly fit your scheme!
  • Big is Beautiful: After the "Fat 5" research somebody (I forget who, sorry) published last year, I did my own testing on the impact of a player's weight to their performance, particularly on offensive and defensive line. The results were conclusive: it's good to be fat: you get more push in the run game (or are more able to resist the initial push as defender), and you collapse the pocket far more effectively against the pass, resulting in 40% more sacks. Now the tool takes this into account as well.
  • More draft stories: I'm pretty sure I've got 99% of the draft stories covered off in the tool now (N.B. some stories are part of a broader archetype that has the same effect but different wording depending on position - check the Draft Stories tab in the tool). Keep an eye out for stories in Draft week itself, not many people know about these ones!
  • Further tweaks to the algorithm: True Value Rating algorithm tweaked to further normalise it across positions and to make sure certain archetypes aren't penalised (e.g. Blocking TEs).
  • Scouted Skill Abbreviations: You asked for it, I listened. You can now use abbreviations when entering the scouted skills for players, speeding up input and improving the user experience.
  • Blue/Red Chip Checks Updated for M18: The checks against players at different positions have been retuned for Madden 18 draft classes.

A couple of caveats...
The tool is still quite "Beta" in terms of the Red/Blue chip tests for M18, as I've only had time to run about 6 classes through the tool. My advice is to err on the side of caution with red chip players in particular, and make greater use of the Grade/TVR column, particularly if you're torn between two guys in your draft class.

Compatibility:
This is particularly important for non-Microsoft Excel users!

To use the tool, you will need Windows with Excel 2010 or newer installed. I cannot guarantee it will work on any other version of Office or older versions of Excel.

Other users have managed to get it working on iPad and Mac, but I can't offer much comment on how effectively the tool works in this form. Apparently it works on Sheets, but some of the conditional formatting goes funny and the drop downs may not work correctly.

I do know there are major, major compatibility problems with Excel 2003 or older, so probably not even worth trying. There are a couple of minor compatibility problems with Excel 2007: the TVR ranking column won't work because the function used to drive that only came into play with Excel 2010, and some of the data validation for skills and grades will mess up because it references a different sheet.

Data Input Syntax for Non-Excel Users

The data validation/dropdown lists may not work in tools like Sheets. Dropdowns are used in the following areas:
  • Player Archetypes
  • Scouted Skills
  • Draft Stories

The tool may throw an error if you don't use the correct syntax on these fields. My guidance is as follows:

Player Archetypes: Input these exactly as you see them on Madden, e.g. 3-4 Pass Rusher, Balanced 4-3, Cover 2, Zone, etc. etc.
Draft Stories: Use the first column in the Draft Stories tab to ensure you get the right syntax.
Scouted Skills: Use the abbreviations as per below:
  • STR
  • AGI
  • SPD
  • ACC
  • AWR
  • CTH
  • CAR
  • THP
  • PBK
  • RBK
  • JMP
  • TRK
  • ELU
  • BCV
  • SFA
  • SPM
  • JKM
  • IBK
  • SPC
  • CIT
  • RTE
  • RLS
  • TAS
  • TAM
  • TAD
  • TOR
  • PAC
  • KPW
  • KAC
  • TAK
  • PMV
  • FMV
  • BSH
  • PUR
  • PRC
  • MCV
  • ZCV
  • POW
  • PRS

Acknowledgements

Massive thanks to Alex the Great who help me gather data during the EA Access Trial.

If anyone else wants to help me out, please unhide columns D and E in the tool after the draft, and populate them with the OVR and dev traits for the players you scouted. This will give me a bigger sample size to ensure the tool is even more accurate for the next version! Either upload these direct to the thread (or post a link) or PM me for my email to send these over.

Happy drafting!
OMN
Attached Files
File Type: zip Madden CFM Scouting Tool v5.02.zip (2.53 MB, 370 views)

__________________

v5 released 24th August 2017! Check out the thread and download the latest version!

Last edited by Old Man Nathy; 08-24-2017 at 02:55 PM.
Old Man Nathy is offline  
Reply With Quote
Advertisements - Register to remove
Old 08-24-2017, 09:56 AM   #2
Rookie
 
OVR: 0
Join Date: Oct 2014
Re: Madden 18 CFM Scouting Tool

You my friend are a saint

Sent from my Nexus 6P using Tapatalk
infinite76 is offline  
Reply With Quote
Old 08-24-2017, 10:26 AM   #3
Rookie
 
OVR: 0
Join Date: Sep 2016
Re: Madden 18 CFM Scouting Tool

Never used your tool last year as I never got much play time in on 17 but I plan to use this when I start my relocation Franchise with either the Jets or Browns tomorrow.

So even though I haven't used it yet, thank you for all the work that you have clearly put into this.
reerdo is offline  
Reply With Quote
Old 08-24-2017, 10:39 AM   #4
Rookie
 
asmmargod's Arena
 
OVR: 0
Join Date: Sep 2014
Re: Madden 18 CFM Scouting Tool

You are a star, mate!

Sent from my HTC One using Tapatalk
asmmargod is offline  
Reply With Quote
Old 08-24-2017, 10:58 AM   #5
That's top class!
 
extremeskins04's Arena
 
OVR: 1
Join Date: Aug 2010
Location: Boston, Mass.
Posts: 3,174
Re: Madden 18 CFM Scouting Tool

THANK YOU!!!!
extremeskins04 is offline  
Reply With Quote
Old 08-24-2017, 11:16 AM   #6
Rookie
 
SirRoyal's Arena
 
OVR: 2
Join Date: Mar 2004
Re: Madden 18 CFM Scouting Tool

Loved this last year. Guess I'll have to subscribe to Windows office again for a few months for excel
SirRoyal is offline  
Reply With Quote
Old 08-24-2017, 11:48 AM   #7
That's top class!
 
extremeskins04's Arena
 
OVR: 1
Join Date: Aug 2010
Location: Boston, Mass.
Posts: 3,174
Re: Madden 18 CFM Scouting Tool

Question: Under the TVR it's showing #VALUE! there and Draft Board Rank as #####. Is this normal because I so far only have 3 players in the sheet right now? Does this eventually start ranking them?
extremeskins04 is offline  
Reply With Quote
Old 08-24-2017, 11:51 AM   #8
Rookie
 
OVR: 0
Join Date: Sep 2016
Re: Madden 18 CFM Scouting Tool

You know you mention the need for excel? Does open office work as it's based off of MS Office?
reerdo 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 -5. The time now is 06:43 PM.

Top -