JRT2006's Madden Scouting Tool

**Rollo** · 10-03-2014, 05:59 PM

Re: JRT2006's Madden Scouting Tool

Originally posted by JRT2006

How about:
IF(players age) is greater than or equal to(age cut off), THEN you add 0 points to future Value, but IF NOT (cut off age)-(players age)*(development multiplier) = Future Value?

Or should players still get the development points?

I think there is a better way to represent this as a superstar will regress (or should regress) slower than someone who is slow.

IF(players age) is greater than or equal to(age cut off), THEN (cut off age)-(players age)*(1/development multiplier) = future value, but IF NOT (cut off age)-(players age)*(development multiplier) = future value.

maybe?

Charles and Davis example comparison
J. Charles
(30-35)*(1/5) = -1
K. Davis
(30-35)*(1/1) = -5

This shows Charles will have a slower fall off than Davis, instead of them having the same fall off over 30. Obviously not a final weight, but you could change it to (2/dev multiplier) and then Charles would be -2 at 35, and Davis would be -10 at 35.

**tdawg3782** · 10-03-2014, 06:39 PM

Re: JRT2006's Madden Scouting Tool

Originally posted by Rollo

I think there is a better way to represent this as a superstar will regress (or should regress) slower than someone who is slow.

IF(players age) is greater than or equal to(age cut off), THEN (cut off age)-(players age)*(1/development multiplier) = future value, but IF NOT (cut off age)-(players age)*(development multiplier) = future value.

maybe?

Charles and Davis example comparison
J. Charles
(30-35)*(1/5) = -1
K. Davis
(30-35)*(1/1) = -5

This shows Charles will have a slower fall off than Davis, instead of them having the same fall off over 30. Obviously not a final weight, but you could change it to (2/dev multiplier) and then Charles would be -2 at 35, and Davis would be -10 at 35.

This would work as well. Just depends if we want to have a calculation for regression or just have the progression stop and assume it will go down. If using this option we'd need a spot to put our number that we want to divide the dev multiplier. I'm good either way.

Loving the back and forth to. I've always loved numbers and this stuff really intrigues me. I did a big excel project on Ncaa last year that was awesome. Really enjoyed it. Been wanting to do something for Madden for awhile but I couldn't come up with what I wanted to accomplish and couldn't find the time (wife, 4 kids, full time job, blah lol). Being able to contribute ideas here has been fun and it's looking like this tool is gonna turn out really good. Can't say it enough JRT2006 but once again thanks man. Much appreciated.

**tdawg3782** · 10-03-2014, 07:13 PM

Re: JRT2006's Madden Scouting Tool

Playing around with some of the formulas. Added Awr in as an average instead of just the whole number to see how it looked. One thing I noticed is if we do that there is no weight applied on it. We all know it is important for the players but don't value it a ton when scouting, etc because we can raise it so easily. But in my opinion it should be a heavily weighted attribute in the long run. Need a way to add a weight to it. Since you already have the attribute listed we can just plug that number in and make sure it's factored into the Actual Talent Value formula. The tabs that need Awr added to the Skill Weight Table are HB and LT. I actually already did it to test and it looks pretty good.

Player/Age/Raw/Actual/Future

<!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves>false</w:TrackMoves> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w

oNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w

ontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:EnableOpenTypeKerning/> <w

ontFlipMirrorIndents/> <w:OverrideTableStyleHps/> </w:Compatibility> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]-->Ryan Mathews - 28 - 275/282/294
Danny Woodhead - 30 - 266/278/278
Brandon Oliver - 24 - 261/258/294

This is with the modifier at 12/9/6/3 and Awr weighted at 5.

Looks good.

**Rollo** · 10-03-2014, 07:32 PM

Re: JRT2006's Madden Scouting Tool

I was a tad bored, so I decided to take the recent EA downloadable rosters and put all of the QBs into my weighted value sheet.

Top 10 QBs based on overall
Peyton Manning
Aaron Rodgers
Drew Brees
Philip Rivers
Russell Wilson
Ben Roethlisberger
Andrew Luck
Cam Newton
Tom Brady
Matt Ryan

Top 10 QBs based on my weight (raw value)
Russell Wilson
Cam Newton
Aaron Rodgers
Colin Kaepernick
Andrew Luck
Ryan Tannehill
Michael Vick
Tony Romo
Johnny Manziel
Peyton Manning

Surprisingly (or not) Tom Brady is #62 in my raw weights (Josh Freeman is 61, Jason Campbell is 63, and Jimmy Garappolo is 67).

**ThatMichiganFan** · 10-03-2014, 07:38 PM

Re: JRT2006's Madden Scouting Tool

Wow. Looks like there is a huge difference between Madden's default overall ratings and the Excel Tool. I think that is a good thing because it can help us separate the players we want based on our own criteria.4

http://www.operationsports.com/forum...n-app-wip.html

JRT, i think you should take a look at this threat by CM Hooe. He would like to make a Madden Draft Big Board app for iOS. I think if you two work together, you could create something awesome.

**Rollo** · 10-03-2014, 07:45 PM

Re: JRT2006's Madden Scouting Tool

Just noticed a couple values int he draft board (final) version. Should the A be 85-99? I don't think 100 is possible outside of EA actually giving to a player. If so, A value would be 92. Also, F value average should be 42.5, unless you meant for it to be 57.5.

No biggie really, just thought I would mention it.

**tdawg3782** · 10-03-2014, 08:19 PM

Re: JRT2006's Madden Scouting Tool

Originally posted by ThatMichiganFan

Wow. Looks like there is a huge difference between Madden's default overall ratings and the Excel Tool. I think that is a good thing because it can help us separate the players we want based on our own criteria.4

http://www.operationsports.com/forum...n-app-wip.html

JRT, i think you should take a look at this threat by CM Hooe. He would like to make a Madden Draft Big Board app for iOS. I think if you two work together, you could create something awesome.

This is what's so cool about this. Madden is trying to do it with the schemes but it's just not where it needs to be. We all value attributes differently and with this tool we will be able to really fine tune our teams to what we want.

Good stuff Rollo. Obviously you like a QB who can move around but it was cool to see Manning was still #10.

Sent from my Galaxy s4 so deal with the short hand

**Rollo** · 10-03-2014, 08:34 PM

Re: JRT2006's Madden Scouting Tool

Originally posted by tdawg3782

This is what's so cool about this. Madden is trying to do it with the schemes but it's just not where it needs to be. We all value attributes differently and with this tool we will be able to really fine tune our teams to what we want.

Good stuff Rollo. Obviously you like a QB who can move around but it was cool to see Manning was still #10.

Sent from my Galaxy s4 so deal with the short hand

I do like a QB who moves, but Speed, Agi, Acc are 3/2/2 in my weights. My 5's are all Deep Accuracy, Throw on the Run and Play Action. I run a lot of west coast style offenses, but want the deep ball available. It just happens that those with high Throw on Run and Play Action typically are the more mobile quarterbacks. My current project QB is only a mid 70's in speed and I'm good with it.

**JRT2006** · 10-03-2014, 08:37 PM

Re: JRT2006's Madden Scouting Tool

Sorry guys. Haven't had a chance to work on anything.

Family of my own, single father of three actually.

Should get some work in tonight, and then working tomorrow should give me some free time as well.

**Shon 23** · 10-03-2014, 08:41 PM

Re: JRT2006's Madden Scouting Tool

Originally posted by JRT2006

Sorry guys. Haven't had a chance to work on anything.

Family of my own, single father of three actually.

Should get some work in tonight, and then working tomorrow should give me some free time as well.

No biggie JRT. I'm sure everyone completely understands. You have done great work.

I am not using your spreadsheet, I'm more of an old school pen and pad on paper guy when it comes to keeping tracks of my draft class and their stats of the players I've scouted, and then coming up with back-up picks in case they go before I expect them to, but I just wanted to say good job on the work you've done. You will provide people interested in this way of scouting a good great way to drafting. Good job.

**tdawg3782** · 10-03-2014, 09:21 PM

Re: JRT2006's Madden Scouting Tool

Originally posted by JRT2006

Sorry guys. Haven't had a chance to work on anything.

Family of my own, single father of three actually.

Should get some work in tonight, and then working tomorrow should give me some free time as well.

Take all the time you need bro. I'm getting repetitive but thanks again.

Sent from my Galaxy s4 so deal with the short hand

**bobloblah1980** · 10-03-2014, 09:41 PM

Re: JRT2006's Madden Scouting Tool

I have to be honest I found it to be very labour intensive with all the typing and filling in the spreadsheet as I have a desktop and it was very awkward filling it out.

But holy smokes the results were awesome!! I found some gems in the late rounds as well as signing some udfa's that were left from my big board that were better than my current roster players!! awesome job JRT!!!!

**ThatMichiganFan** · 10-03-2014, 09:50 PM

Re: JRT2006's Madden Scouting Tool

No problem bro. Im only 17 so I dont have a family of my own but i have 7 younger siblings that often need more attention than Madden or other things. I Feel you bro

**Rollo** · 10-03-2014, 10:47 PM

Re: JRT2006's Madden Scouting Tool

Originally posted by JRT2006

Sorry guys. Haven't had a chance to work on anything.

Family of my own, single father of three actually.

Should get some work in tonight, and then working tomorrow should give me some free time as well.

Family > Work > Fun

Maybe some other stuff in there too =P

Quick question to everyone. We haven't touched upon the Consistency attribute at all, but it directly correlates to experience building up quicker in game prep and actual play time. Do you guys think we should be considering this attribute in potential calculations?

**tdawg3782** · 10-03-2014, 10:59 PM

Re: JRT2006's Madden Scouting Tool

Originally posted by Rollo

Family > Work > Fun

Maybe some other stuff in there too =P

Quick question to everyone. We haven't touched upon the Consistency attribute at all, but it directly correlates to experience building up quicker in game prep and actual play time. Do you guys think we should be considering this attribute in potential calculations?

That's a good point that I completely over looked. I would have to say that we almost have to factor it in for potential. Maybe even actual. Good catch.

Sent from my Galaxy s4 so deal with the short hand

JRT2006's Madden Scouting Tool

Recommended Videos

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment