JRT2006's Madden Scouting Tool

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

ehh...maybe a few.

So, how was the roster management tool. Did it work as intended, curious because I just implemented it and the way it evaluates into the new tool. Ran a test, and other then not being able to get the values to avg out with some damn decimal points, it works fine

I used the tool with great success. Loved it. Really helped to find those guys on your roster who fit your style.

Sent from my Galaxy s4 so deal with the short hand

[JRT2006]

Re: JRT2006's Madden Scouting Tool

Thats good to know because I've implemented the same system in the new tool, works exactly the same as the excel tool does.

Not just trying to find a good way to format it for viewing.

Datasheet form.......report?

[woodjer]

Re: JRT2006's Madden Scouting Tool

ehh...maybe a few.

So, how was the roster management tool. Did it work as intended, curious because I just implemented it and the way it evaluates into the new tool. Ran a test, and other then not being able to get the values to avg out with some damn decimal points, it works fine

Loved it. In fact, I've used it a lot more than the scouting one (then again, I'm still in Week 2 of my 1st season...) and it's helped me approach things a little differently than in the past.

As for formatting for viewing, I could people wanting to view it more as a datasheet than a report. Then again, there are a lot of people that might prefer a cleaner report look if they're not trying to do any sorting/filtering with the end results.

[JRT2006]

Re: JRT2006's Madden Scouting Tool

I did the datasheet veiw, it wasn't very pretty, but like you said, it allows for user interaction to sort between what value they want to evaluate on

[JRT2006]

Re: JRT2006's Madden Scouting Tool

I would think the complicated thing with that idea would be, what justifies a 1st round pick? What value would be considered a 1st rounder? You would need an range to determine that considering we can't really scout every available player

[JRT2006]

Re: JRT2006's Madden Scouting Tool

True. If you use the V/MV idea that I had in my tool, I think you could come up with expected ranges of players from the best to the worst by position and then just specify what range equates to which round.

The V/MV concept is already looking for the absolute max a player could be and when the NFL does the draft they are not only comparing players in the current draft, but also to previous drafts to see how they'd stack up.

I was going to mention that, the V/MV concept you used in your tool could work the issue.

[JRT2006]

Re: JRT2006's Madden Scouting Tool

I want to implement that into the tool, I'll be looking for a way yo include it today.

For those of you who don't know, the V/MV system Cloud uses values the "Perfect" prospect, A's across the board. Then it values a prospect you scout in accordance with the "Perfect" prospect. The value is shown as a percentage, so a scouted prospect could be 78%, compared to a perfect prospect at 100%

There's a bit more to it than that, that's just my quick version.
Cloud, feel free to explain more in depth if needed

[AlDizzL]

Re: JRT2006's Madden Scouting Tool

i noticed on 2 of your sheets. i can't recall at the moment, but the clear button isn't working....says the macro isn't available in workbook? it's only on like 1 or 2 position tabs that it doesn't work. it won't let me fix it. Any help?

[AlDizzL]

Re: JRT2006's Madden Scouting Tool

i noticed on 2 of your sheets. i can't recall at the moment, but the clear button isn't working....says the macro isn't available in workbook? it's only on like 1 or 2 position tabs that it doesn't work. it won't let me fix it. Any help?

OK so i went back to check it out. It's on the Roster Evaluation spreadsheet. The SS & LOLB tabs will not let me clear with the clear button.

[AlDizzL]

Re: JRT2006's Madden Scouting Tool

i noticed on 2 of your sheets. i can't recall at the moment, but the clear button isn't working....says the macro isn't available in workbook? it's only on like 1 or 2 position tabs that it doesn't work. it won't let me fix it. Any help?

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****

Looking forward to the 2016 version!!!!!!

[Cheese2121]

Re: JRT2006's Madden Scouting Tool

This tool was absolutely fantastic and I am still using it for my current CCM. Just wanted to say thanks!

[jacKaepernick7]

Re: JRT2006's Madden Scouting Tool

This sounds really interesting, will give it a try on my CCM and let you know how I get on. Many thanks!

[tosa]

Re: JRT2006's Madden Scouting Tool

Is this tool still being created? any plans to release for Madden 16?

[JRT2006]

Re: JRT2006's Madden Scouting Tool

Is this tool still being created? any plans to release for Madden 16?

I'm without a computer so progress has come to a screeching halt unfortunately

[Rollo]

Re: JRT2006's Madden Scouting Tool

Glad to see people still posting about this =)

Also, another opinion needed from the crowd.
2 prospects, both a first rd projection and both are of a position with medium need. listed below is there skills importance and the grade for each (I didnt list the skill because it was irrelevant)
Which prospect should be rated higher than the other? Because I seen a different result in the new tool than I did in the old one and I have opinions.

Aiken		     Shepherd
High - A	     High - A 
High - A	     High - A 
High - B	     High - B 
Med  - A	     Med  - B 
Med  - A	     Med  - B 
Med  - B	     Med  - B 
Low  - B	     Low  - A 
Low  - C	     Low  - B 
Low  - F	     Low  - C

This is something I struggled with a lot last year in the process of our build. If they're the same position, Shepherd is a more rounded player, but Aiken will most likely have a higher ceiling depending on which attributes are weighted what, and what they cost to upgrade.

The tool is amazing when comparing two players in the same position. When comparing two players out of position, you need to rely on your team need modifier (I changed mine a lot through trial and error between a lot of my test drafts). What I use now is a round specific position needed modifier. I try to address my greatest need in the 1st round, so that will typically get the biggest modifier. That modifier grows the longer I do not select that position (I have to manually do this). If I am meeting my team needs in the first few rounds, my position needed modifiers start converging together. I'd rather get the best value with a 7th rounder, regardless of position, than to draft a "need."

tl;dr - Let the position need modifier and the suggested round drafted modifier handle too close to call picks between different positions.