New for Madden 18 CFM Version 4
Scout Dev Traits! My research into scouting dynamic dev traits via draft stories is now incorporated into the tool. You get a predictor for % likelihood of a certain dev trait, and the draft stories now impact TVR at a much more granular level than in previous versions and madden 18 coins.
Some minor scouting criteria tweaks. Lots of minor tweaks and changes. 4-3 OLBs are now at less of a disadvantage compared to their pass rushing counterparts, and the chance of missing on a potentially good safety that the tool tells you not to draft has gone down significantly.
True Value Rating algorithm tweaked to further normalise it across positions.
Download the file now:
https://drive.google.com/file/d/0B_j3eHm2ZFqVVVNHR1JySjFMelk/view
Compatibility:
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.
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.
Moving in-flight draft classes from V3 to V4:
You shouldn't have too many problems moving in-flight classes from V3 to V4. The only problems will come from the Draft Stories field. You will need to remove values from this field before copying your V3 data.
When selecting your v3 data to copy, only select cells up to column R (Bench Press), and remember to use Paste Values, not the default paste option, when pasting your data into V4.
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.
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 post-Tuning Update class (based on approx. 15 classes) in terms of elite prospects, depth, and strength at different positions.
Big Board: Tool provides you with an NFL-style Big Board ready for draft day.
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.
Scout Dev Traits! My research into scouting dynamic dev traits via draft stories is now incorporated into the tool. You get a predictor for % likelihood of a certain dev trait, and the draft stories now impact TVR at a much more granular level than in previous versions and madden 18 coins.
Some minor scouting criteria tweaks. Lots of minor tweaks and changes. 4-3 OLBs are now at less of a disadvantage compared to their pass rushing counterparts, and the chance of missing on a potentially good safety that the tool tells you not to draft has gone down significantly.
True Value Rating algorithm tweaked to further normalise it across positions.
https://drive.google.com/file/d/0B_j3eHm2ZFqVVVNHR1JySjFMelk/view
Compatibility:
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.
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.
Moving in-flight draft classes from V3 to V4:
You shouldn't have too many problems moving in-flight classes from V3 to V4. The only problems will come from the Draft Stories field. You will need to remove values from this field before copying your V3 data.
When selecting your v3 data to copy, only select cells up to column R (Bench Press), and remember to use Paste Values, not the default paste option, when pasting your data into V4.
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.
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 post-Tuning Update class (based on approx. 15 classes) in terms of elite prospects, depth, and strength at different positions.
Big Board: Tool provides you with an NFL-style Big Board ready for draft day.
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.
Hey man, I'm having problems downloading it. Could you help me out?
ReplyDelete