JRT2006's Madden Scouting Tool

[JRT2006]

A special shout out and BIG thank you goes out to: Rollo, tdawg3782, and BeantowneS. Your countless effort in finding errors, researching data, and making suggestions made these two tools what they are. I did all the typing, these guys did all the research and thinking.

Updates in Spoiler Box

Spoiler

UPDATE 1: Added the ability to cross prospects off your big board after they are drafted. Allows you to track prospects better.

UPDATE 2: Added the True Value of a prospect(before need multiplier is added) to the column right next to Final Grade to compare how much the prospect really fits your scheme against how big of a reach you are about to take for a position of need.

UPDATE 3: Adjusted the Grade Values of A, B, C, D, F to separate prospects better so you don't get too many prospects with the same draft grade.

UPDATE 4: Removed the Late Round Depth need from the Team needs chart. If you are looking to draft depth in the late rounds, pay attention to the listed Projected Round of the prospect.

UPDATE 5: Changed Position Not Needed to Best Value Pick. If you don't need to draft a position, do not scout it. Best Value Pick drops the value of a prospect slightly. This allows the prospect to be slightly lower on your Big Board, but not dropped to the bottom, especially if he is a good fit and talented.

UPDATE 6: Adjusted the numbers in Team Needs to not separate prospects too far from their true value.

UPDATE 7: Changed a Scouting Tool Rule below(highlighted in red). Removed the weight counter and adjusted the Position tabs to reflect new rule with "Even Weights" notifier.

UPDATE 8: Fixed a few minor problems with columns not being voided

UPDATE 9: Adjusted the Grade value to average projected grade value range.

UPDATE 10: Added is the Round modifier. The round modifier slightly reduces the overall value per the projected round. It keeps the 5th round projections from being on the board at #1 (although they may be the highest valued player scouted-See UPDATE 11). High value targets will still be in the mix with prospects 1, possibly 2, rounds ahead of projections, but not 3 or 4 rounds.

UPDATE 11: Added Positional Rank to the big board. The rank of the player against other players at his position you scouted is necessary on the big board with the round modified rankings. This allows you to view the rankings of a prospect projected to go in the earlier rounds compared to the later rounds.

UPDATE 12:The counter under the weights has been removed. It wasn't working properly, will be fixed and replaced soon. Remember to keep your weight ratios accurate, even amounts.

UPDATE 13:A VERY Super Beta version of the roster evaluation tool has been uploaded. The only working (possibly) tabs are the QB through TE tabs. The Big Board needs the code overhauled and I'm slowly upgrading all the tabs to finish, but won't be tonight. My biggest focus right now is for everyone to test the Raw and Max values to help me determine if thats a pretty good balance in separating future talent from current slow progressing players.
Please report back any suggestions or findings.

UPDATE 14:A Beta Version of the Roster Evaluation Tool has been uploaded. I haven't figured the consistency into the averages yet as I ran out of time before the Chiefs game. Each tab is working besides that one rating, Even the Roster Board Generator. Clear buttons only work for the board and the QB tab.

UPDATE 15: Adden a Team Need label to the Big Board and Team need tab. You can designate how much of a need the position is (High, Medium, Low) on the team need tab, when you generate your big board, it will appear, allowing you to make a better decision on drafting a player

Each and Every year us Madden fans want the most realistic experience possible, and while some years we get improvements in that aspect, usually there are things in the game that are so far from reality, they are not even fun to use. The Madden NFL Draft is one of those things. Scouting a player with a designated amount of scouting points to reveal grade averages for skill and even further, the complete rating is just unnecessary. We struggle to manage our scouting points, but find ways to decipher the potential of each player scouted, most likely avoiding a bust each draft.
We want to see college stats, combine times, wonderlic scores, and/or even having the chance to run a few practices with a scouted player. We should be given HOURS, not points, and scouting a player or a team of players entering the draft should cost hours. We shouldnt base our judgement off grades, we should base it off scouting notes provided to us by our scouts, and times ran in the combine or stats through their college careers. This gives us, the player, the managers, the opportunity to draft gems in the later rounds and busts in the earlier rounds. The reward, or lack of, would be tremendously greater.
WE WANT TO SCOUT!


SCOUTING TOOL:

Spoiler

What you need to know about this tool:
1) It is designed to find best fit, not highest overall.
2) It still provides a 'bust factor' in drafting
3)It is designed to be used a certain way, if you choose to or not to use it as designed is up to you.


1)*Try not to stray too far from your Scheme and Player Type, in most cases, scouting each player that fits that criteria will still allow you to scout further (depending on your total SP). Use your leftover Scouting Points to scout players out of system that you think will fit your team and be available at your pick

2)*When designating your attribute priority (weight), be sure to designate an equal amount of weight (5, 3, 2) for the skills. You must have an equal amount of 5 weighted skills, 3 weighted skills, and 2 weighted skills. If you scouted 12 skills for a cornerback, 4 of those skills must have a 5 weight, 4 must have a 3 weight, and 4 must have a 2 weight.

3)*You DO NOT have to scout the same amount of skills for each position, if you want to evaluate a QB with 9 scouted skills, you may evaluate a linebacker with 6 or a cornerback with 12. Just be sure that you keep the weights even among each position (SEE ABOVE).

4)*Scout*ONLY*to the letter grade result(B?, A?, F? etc), anything passed that is a waste of points.

5)*Highly suggested to save your scouting points until after free agency. You may scout as you wish, but you can better judge your team needs after Free Agency signings, adjust your Team Needs in the tool, and scout accordingly.

6)*Generate your Big Board and use it wisely. The Big Board is initially sorted by 'BEST VALUE' which values the players by which round they are projected to be draft. Sorting boxes are provided for each category (grey square with triangle) to allow you to sort by position, true value, positional rank, Name.

Instructions(After Free Agency is complete):
1) Set your Team Scheme in game to your desired preference (Do this at the beginning of the season).

2) Go to the last tab labeled "Team Needs" and fill out your position needs. You fill this out to your liking. Some may want to strictly draft BPA at each pick, ignoring needs, seeking talent at any position. Some may have glaring holes they need to fill immediately with a starter. The team needs board is user preference, just stick with the number identifiers when completing it. Also, you may label the level of need that position is (High, Medium, Low) and it will appear on your big board to help make tough decisions a little more easy.

3) Go to each position tab and scroll right until you see the skill/weight blue box. Rank the skills from most important(5) to least important (1).*Do not use '4' as a rank*as the tool doesn't calculate it. Make sure you follow the tool rules. Only scout the attributes labeled with a 5, 3, or 2. Any skill designated with a number less than '2' will completely black out the entire column to deter you from scouting and entering a grade. NOTE:*The team scheme area of Madden lets you decide what type of player you want at that position. It also gives you an idea of what to look for on that type of player. But you can chose to scout what you like.

4) Begin scouting. Search for players that fit your scheme and Player Type, those are the players that will give you best results. players that are our of your scheme/type can still give you good value and ratings, they just may be slightly less than they would be if they were familiar with your scheme. Scout to the letter grade only. Scout only the attributes you designated with a 5, 3, or 2. Record the scouting results in the tool. Do this for each position you want to scout until you have run out of points. If you have extra points,*do not OVER SCOUT a player.*Even if you accidentally scout the wrong attribute, it can not be used. Fill in the grades on the tool, along with the projected round and Name.

5) Go to the first tab on the tool labeled "Big Board". Click the 'Generate Big Board' button. The list of players scouted will appear with best value on top and lowest on bottom. The projected round*IS NOT*sorted, so pay close attention to their projected draft round unless you are reaching for a position of need. Best Value however is modified with projected round in mind, it will suggest drafting players when the value is right, or if you should reach them because the value is outstanding. Pay close attention the the position rank also, it ranks the scouted prospects for that position from best(lowest number) to worst (highest number). This will help you decide a pick, because you may grab your #3 WR at a valuable position in the draft of round 3, but your #1 WR may be able to get picked in round 5. On the Column labels is a small grey box with a triangle, you can use these to sort the categories. If each column label does not have the sort box/triangle attached to it, and you sort one of the columns, you WILL mix up the names/round/grade. Place a lowercase x next to the players information underneath the generate button to mark that player off your list.

6) At the top right of each position sheet is a button labeled "Clear". Clicking this button will erase all the inputted data you entered (except the weights). Be sure not to click the button until you are ready to move on to the next season. On the "Big Board" tab is a GIANT button labeled "Clear". This button will erase your big board.

Roster Evaluation Tool:

Spoiler

The Roster Evaluation Tool was created to evaluate your roster the same way you evaluated prospects when scouting.

Some things to know about this tool:
1) It will not follow Maddens overall ratings.
2) It will suggest players by three different categories
-Raw Talent (The players skills only, not including their awareness and/or play recognition)
-Actual Talent (The players skills averaged in with their awareness and/or play recognition)
-Future Value (The predicted value based on how many years the player has before you believe his attributes will decrease dramatically and his development trait. This gives you a small value which is added to his actual value)
3) It organizes your roster by value, and helps you decide who is valuable to your team now and in the future, supplies you with the user inputted cap penalty, and gives you the option to make cuts.
4) Free Agent names can be added to the sheet to determine their value on the team as well.

Instructions:

1) Go to the Team Needs page. Here you will place the amount of personnel you want at each position. You are looking to hit the total of 53 for your final rosters. Don't go over a total of 53, because these team will later suggest how many you should cut at each position

2) Just as you did in the Scouting Tool, go to the weight and enter your weights for each skill. Following the same rules as the Scouting tool, select the amount of attributes you want to grade (multiples of 3) evenly distributing the weights.

3) Input the age at which you believe the players at that position will decline, this will only affect their future value from increasing passed their actual value.

4) You can change the development trait points if you like, but 10, 20, 30, 40 is a very good base to start on.

5) Enter your players data for all available columns not filled in with black.

6) Once complete, go to the Roster Board tab at the beginning and Generate your Evaluated Roster. The roster will be sorted from least to greatest on Actual Value. The information provided is their too help you. Cap Penalty, all three values, and Amount to Cut (negative numbers mean you need to fill a roster spot to meet your requirements)

7) Use this Roster Board to your advantage in help determining who you should cut based on their value to your team in the future, their current value, and their raw value.

Feedback is welcome, I am no excel expert, everything I've learn has been from online research. If you find a problem, or want to suggest a change to better enhance the scouting process, PLEASE let me know. I want to make this tool as helpful and awesome as possible

****I am not responsible for the outcome of your draft or your team. You've read the description. You've read the rules. This tool does not guarantee you a perfect draft or a perfect roster, there are cheat guides and OS cheese blogs for that. These tools are only here for you to use at your own risk to give managing a football team a more interesting approach****

[BeantowneS]

Grabbed the update and will try tonight. Thanks for the great work.

Playing with this sheet at work a little and this is much better than the first version. I wanted to share with you this sheet that I created. it allows me to keep track of what I am doing and also shows me all the good dev people for free agency or trading. Hope this helps a little with you and thanks again for your sheet

Sent from my GT-I9295 using Tapatalk

[JRT2006]

ive already found a problem, quick fix i believe. taking care of it now.
The code for the draft board is pulling the wrong grades, its pulling the grades before the needs multiplier is applied. just have to switch around and will upload the repaired tool.

[Sreister]

Can't wait to try this out, though this may be a bit much for me as the thrill of a bust might be minimized. Still, thanks for sharing your work with us all!

[andybill]

Quote: Originally Posted by JRT2006

4) Scout ONLY to the letter grade result, anything passed that is a waste of points.

Does this mean scout just to the letter with a question mark? (e.g. "B?")
Or, if you scout past that do you get a firm letter (e.g. "B"). I have never scouted past the question mark, so was unsure. thanks for the scouting tool!

[JRT2006]

Quote: Originally Posted by BeantowneS

Grabbed the update and will try tonight. Thanks for the great work. Playing with this sheet at work a little and this is much better than the first version. I wanted to share with you this sheet that I created. it allows me to keep track of what I am doing and also shows me all the good dev people for free agency or trading. Hope this helps a little with you and thanks again for your sheet Sent from my GT-I9295 using Tapatalk

Awesome, I will have a look at your sheet as soon as i finish repairing the one i uploaded. The Big Board is pulling the wrong draft grade, so pretty much what you get on the big board each time is a rank of value, without the needs adjustment.

I thought about creating a free agency/team player evaluation tool.
Player/Team evaluation: you type in the "important" ratings of your players and it grades their fit on your team.
Free Agency Hunt: You type in the "important" ratings of free agents youre interested in, type in your Position Grade (found in the Team Needs area of Madden) and it ranks the most important Free Agents to seek.

[JRT2006]

Quote: Originally Posted by andybill

Does this mean scout just to the letter with a question mark? (e.g. "B?") Or, if you scout past that do you get a firm letter (e.g. "B"). I have never scouted past the question mark, so was unsure. thanks for the scouting tool!

Yes, just scout to the letter with the question mark, anything after that (which costs a bunch of points) is just a firm overall grade. But I've given each letter an average point value that is pretty close to what the game reflects for an overall (within 10 points I believe)

Also, if you are using the tool now, there is an error with team needs. The tool still works, but the big board that you generate will only rank players by their value, the need multiplier isnt applied.

Currently working on that fix now and will have it updated shortly

[JRT2006]

Quote: Originally Posted by Sreister

Can't wait to try this out, though this may be a bit much for me as the thrill of a bust might be minimized. Still, thanks for sharing your work with us all!

You still gets your busts, or what you think is a bust. This tool is grading players that fit your team, not their overall. Now their overall may be higher than normal because they fit your scheme well, but on any other team it would likely be much lower.

I've drafted 78 overall LT's in the 5th-6th round, 70 overall corners in the 6th round, 64 overall QB's in the 3rd, 55 overall DT's in the 7th. Passed on talent because my big board says I should go for another player, to later find out that the player I passed on was 5 points higher.

It keeps drafting interesting and mysterious still.