JRT2006's Madden Scouting Tool

[JRT2006]

Re: JRT2006's Madden Scouting Tool

so I am a 3-4 guy on the defensive side and maybe it's just me but i find there just isn't enough quality pass rush olb's so i start looking at speed rush DE's and switch em will that make a difference?

I do the same. Usually theres 1 or 2 good 3-4 OLB rushers, I start digging into the RE/LE Speed Rushers, plug their names in on the LOLB/ROLB tab with a (RE/LE) to remind me.

Just ran a test draft, drafted an 81 Speed Rush LE, converted him to a ROLB which dropped him to 78. Simmed a season, progressed his awareness from 56 to 75 and he's an 82 OVR now.

Those of you using the Round modified tool, id suggest downloading again here in a few minutes. "Scouting Tool (Final).zip" will be the file name.
There were a lot of positions missing formulas which are corrected now.

[Captain Slayer]

Re: JRT2006's Madden Scouting Tool

Having the 5-3-2 ranking systems is great. Maybe we could start comparing notes on what we think would make a great player by position, by scheme?

For example, while I don't necessarily want a "running" QB, I do like to have some mobility. I've set up my QB ratings as follows:

Short/Med/Deep Acc - 5
THP/Speed/Acc - 3
AGI / Throw on Run / Play Action - 2

I did have THP as a 5 and MAC as a 3, but other posts in this thread lead me to believe that "A" THP is very common and thus not a great attribute to help separate the cream of the crop at the QB position.

[burth179]

Re: JRT2006's Madden Scouting Tool

Having the 5-3-2 ranking systems is great. Maybe we could start comparing notes on what we think would make a great player by position, by scheme?

For example, while I don't necessarily want a "running" QB, I do like to have some mobility. I've set up my QB ratings as follows:

Short/Med/Deep Acc - 5
THP/Speed/Acc - 3
AGI / Throw on Run / Play Action - 2

I did have THP as a 5 and MAC as a 3, but other posts in this thread lead me to believe that "A" THP is very common and thus not a great attribute to help separate the cream of the crop at the QB position.

I do the exact same for QB, except I bump THP up to a 5 and drop medium acc to a 3. I keep THP at '5' so they are more of a "true" rating compared to other positions, because I value that the most (even if almost all have 'A'). You can still get separation from other QBs if the rating is a '3' or even a '2' IMO.

Also deep accuracy is harder to upgrade that is why I value it over medium accuracy, although maybe I should consider flip flopping those..

[Captain Slayer]

Re: JRT2006's Madden Scouting Tool

I played around with the file today, inserting the top 39 players at each position from the Madden "All Ratings" initial excel document that was put out on EA's website. I converted the rating scores into letter grades, though not sure I got the exact ranges correct (used 90-99 for A, 80-89 for B, etc).

I then played around with the skill weightings at each position to try to match my style of play (generally 4-3 on D; quick hitting and speed oriented on O) and to generally try to get back somewhat close to how real players are rated in M15. The goal was to try to find the best set of weightings to uncover the types of players I want to draft.

I'm sure there is plenty of room for debate at practically every position, but nonetheless, I've attached the file that I modified based on JRT2006's hard work.

Enjoy

[JRT2006]

Re: JRT2006's Madden Scouting Tool

I played around with the file today, inserting the top 39 players at each position from the Madden "All Ratings" initial excel document that was put out on EA's website. I converted the rating scores into letter grades, though not sure I got the exact ranges correct (used 90-99 for A, 80-89 for B, etc).

I then played around with the skill weightings at each position to try to match my style of play (generally 4-3 on D; quick hitting and speed oriented on O) and to generally try to get back somewhat close to how real players are rated in M15. The goal was to try to find the best set of weightings to uncover the types of players I want to draft.

I'm sure there is plenty of room for debate at practically every position, but nonetheless, I've attached the file that I modified based on JRT2006's hard work.

Enjoy

I was actually just in the middle of doing something like this. Wanted a tool to use to help me decide who to cut on my roster to reach minimum, what free agents may be best to target, who to plug in my depth charts, etc.

-The ranges for A, B, C, D, F are seen on the QB tab near the weights.

-This is fun to look at, seeing who is the best of the veterans based on the weights.

-Would like to find a way to implement roster requirements into it. After values are scored, a modified value based on roster requirement adjusts it.
I.E. I want to keep 3 running backs on the roster, I have two, so the lowest valued running back appears on the list to be cut.

You seem knowledgeable in excel, you should head that up (roster evaluating tool), could create your own thread or add it to this and we can change the title.

[Captain Slayer]

Re: JRT2006's Madden Scouting Tool

I was actually just in the middle of doing something like this. Wanted a tool to use to help me decide who to cut on my roster to reach minimum, what free agents may be best to target, who to plug in my depth charts, etc.

-The ranges for A, B, C, D, F are seen on the QB tab near the weights.

-This is fun to look at, seeing who is the best of the veterans based on the weights.

-Would like to find a way to implement roster requirements into it. After values are scored, a modified value based on roster requirement adjusts it.
I.E. I want to keep 3 running backs on the roster, I have two, so the lowest valued running back appears on the list to be cut.

You seem knowledgeable in excel, you should head that up (roster evaluating tool), could create your own thread or add it to this and we can change the title.

I know a little bit about excel, but cannot really write code or anything too advanced. The real reason I had the time to do it was that I'm on my last couple of days at my current job and will be starting a new job Monday...

Which will result in roughly zero free time during the day to devote to M15... unfortunately!

[JRT2006]

Re: JRT2006's Madden Scouting Tool

I could probably find some time to work in something.

Only reason i got the scouting tool complete was because i took 1.5 weeks of leave (was supposed to go to KC for the chiefs game on Monday night).

Just need to think of a way to grade players on the team. Dont want the lowest valued player to be critical roster depth, and then be cut because excel says so

[JRT2006]

Re: JRT2006's Madden Scouting Tool

If I just rid of the LOOKUP function for letter grades, you could type the players actual rating into the cell and it will calculate based on that and not the estimated guess (letter grade)

But, what do I do about players who appear to be low rating, but have great development? I need some kind of modifier in there to keep rookies from being the bottom of the list because they havent had time to develop.

Suggestions?

[mmorg]

Re: JRT2006's Madden Scouting Tool

That'd be a tough tool to make as you'd have to take contracts into account as well. You'd have to input their bonus and years left and the workbook would have to some how calculate which players uncuttable/untradable due to cap issues and also try and determine who you should cut based on player value, basically who is overpaid or underpaid I guess.

[JRT2006]

Re: JRT2006's Madden Scouting Tool

That'd be a tough tool to make as you'd have to take contracts into account as well. You'd have to input their bonus and years left and the workbook would have to some how calculate which players uncuttable/untradable due to cap issues and also try and determine who you should cut based on player value, basically who is overpaid or underpaid I guess.

Damn, I hadnt even thought about that. I like a good challenge though.
I mean Madden breaks down the salary pretty well, you'd just have a lot of information to input at the beginning of each year.

[swenk16]

Re: JRT2006's Madden Scouting Tool

Just wanted to take a minute to say thank you. You selflessly put this tool on this forum for all of us to use and it has enhanced my gaming experience immensely. Just want to say I really appreciate your hard work and most of all the time it took to put this together and finely tune it to be the best tool it could be for everyone to use.
Sincerely, thank you.


Sent from my iPhone using Tapatalk

[JRT2006]

Re: JRT2006's Madden Scouting Tool

Questions for the community:

1) When making roster cuts, what cap penalty amount usually deters you from releasing? Anything over [dollar] amount?

2) When judging your players, what do you use to determine how well he will improve?

trying to find a good balance in valuing players on rosters

[Rollo]

Re: JRT2006's Madden Scouting Tool

If I just rid of the LOOKUP function for letter grades, you could type the players actual rating into the cell and it will calculate based on that and not the estimated guess (letter grade)

But, what do I do about players who appear to be low rating, but have great development? I need some kind of modifier in there to keep rookies from being the bottom of the list because they havent had time to develop.

Suggestions?

I did something like this, but very simple as my excel knowledge is limited to basic equations.

I pretty much just grabbed the same 9 attributes I used for draft board rankings, a roster by position with the 9 attributes listed out highest rank to lowest, with a final calculated value listed after all the attributes. This gives me a real value according to my desired weights and allows me to compare to my liking. Also, I don't weigh awareness or play recognition, so my value represents raw potential.

edit: after a re-read, I realized what I do may not be what you were looking for.

[koberocks1]

Re: JRT2006's Madden Scouting Tool

This is just a basic scouting question but I hope someone here can help me. What are the attribute ranges for letter grades? For example if a guy has "A" for his speed, catching, or any attribute, does that mean it 90-99? If it's "B" does that mean 80-89?

[JRT2006]

Re: JRT2006's Madden Scouting Tool

What do you all think? Useful, or not?

ROSTER BOARD


PLAYER TAB

Cap Penalty is not figured into grade

FINAL GRADE - PLAYER TAB


ROSTER REQUIREMENTS