JRT2006's Madden Scouting Tool

[Rollo]

Re: JRT2006's Madden Scouting Tool

I'm currently plugging in the consistency ratings on my tool. I haven't made any adjustments to the linked thread above yet. If we decide, I'll make the adjustments later

I let my brother borrow my game, it keeps me on the tool and off the controller, so I'm using all the player info that was in your sheet Rollo.

Should be completed withing 2 or 3 days.

I've spent more time on the sheet than in the game since finding this thread. I had something rudimentary last year that didn't really do what I wanted, but having some like minded players has increased the fun this tool is providing me.

[ThatMichiganFan]

Re: JRT2006's Madden Scouting Tool

I wanna say thanks to all of you excel smart people in this thread. I am not particularly good with excel, so it is nice to have people who are good and want to talk about ideas on how to create the tool.

[Nate.Walton1]

Re: JRT2006's Madden Scouting Tool

Just a quick note regarding age regression...
I'm currently running a Colt's CFM - made the transfer to a 4-3 D.
Robert Mathis is my RE - I'm now in year 3 and he has showed NO regression whatsoever.
However, I signed Pierre Garcon has a WR, and after 1 year his speed dropped to a 78! Which dropped him from my #1 WR, to my slot WR. Does anyone know if age regression is position specific, or just random?

[JRT2006]

Re: JRT2006's Madden Scouting Tool

I had assumed it was position specific, that's why the user input age drop off was added. Is there any other noticeable differences in non position specific skills between the two? Consistency, confidence, etc?

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

I had assumed it was position specific, that's why the user input age drop off was added. Is there any other noticeable differences in non position specific skills between the two? Consistency, confidence, etc?

I've only got to one off season so small sample size but Phil Rivers went from being a 99 ovr (kinda high but whatever) to 85 ovr in one season. That's a huge drop. His consistency if I remember correctly was pretty high. His confidence however at the end of the year was in the teens (I might have played bad lol).

On the flip side Gates only dropped 1 ovr. His confidence was around 50.

This leads me to believe confidence plays a pretty big role, along with goals being met and stats. And probably a little with consistency.

As far as implementing this in the tool I wouldn't even try. What we have gives a pretty good idea.

Sent from my Galaxy s4 so deal with the short hand

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

I'm currently plugging in the consistency ratings on my tool. I haven't made any adjustments to the linked thread above yet. If we decide, I'll make the adjustments later

I let my brother borrow my game, it keeps me on the tool and off the controller, so I'm using all the player info that was in your sheet Rollo.

Should be completed withing 2 or 3 days.

What are your ideas on adding consistency? I've been thinking about it and I'm kinda stumped on how to implement it.

Sent from my Galaxy s4 so deal with the short hand

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

I wanna say thanks to all of you excel smart people in this thread. I am not particularly good with excel, so it is nice to have people who are good and want to talk about ideas on how to create the tool.

I'm like Rollo. I've been using my own excel sheet the last few years. Fine tuning it each year but just not getting what I wanted out of it. Then JRT comes along and streamlines his tool. This is basically what I've been trying to do for 3 years but just didn't have the excel skill to pull it off.

Love all the input from everyone. Really making this thing legit.

Sent from my Galaxy s4 so deal with the short hand

[JRT2006]

Re: JRT2006's Madden Scouting Tool

Thanks guys.

I just can't wait to implement it into my CCM. All the work and testing and I haven't truly used it yet, so that's a pretty exciting g thing to look forward to, especially hearing all the feedback.

Have to give props to everyone who leneed a hand and tested, offering suggestions and finding errors.

Brought my laptop to work today so I should definitely get a finished product up by tonight.

After that it will all he fine tuning.

The confidence thing bugs me though, I know I should leave as is, but I'll probably be looking into how to implement it

[BeantowneS]

Re: JRT2006's Madden Scouting Tool

I took a couple days off of work to take care of some personal things and used the free time to really dive into this. I have had 5 great drafts and some awesome gems in 4-7 round picks. A couple of questions and thoughts came up though.

With consistency has it been proven the higher grade will lead to more xp through each season.

With the confidence factor I would suggest not putting it into any algorithm or calculation you do. It is such a vague guess on the impact it would have on each position that you will mess with the original numbers too much. Take it into account week per week on the game prep.

For the draft is there any way that we could implement a small percentage boost for matching the teams scheme and or style. I know you get a small bump for both when you have the player and he will earn xp faster if they fit the scheme but that is a great deal breaker I use when deciding on a draft pick and if the sheet could calculate that into its board setup we would have a better idea on taking a chance on someone who doesn't fit our scheme versus someone who does. Just a random though. Not sure if it would work.

Thanks you again for your hard work on these sheets. I think this is something that could be used well through the future Madden titles.


Sent from my Android phone thingy.

[Rollo]

Re: JRT2006's Madden Scouting Tool

With consistency has it been proven the higher grade will lead to more xp through each season.

I can't find an easy way to test how confidence works throughout the season outside of game prep. There are just way to many variables. My assumption is that consistency gives the same bonus in game prep as in game play stats/goals.

[Rollo]

Re: JRT2006's Madden Scouting Tool

I have (kind of) a long write up concerning consistency and game prep experience gain, but I wanted to get the basic of it out in case you come through and it hasn't been posted yet. Basically, I think consistency should be treated just like development in our equations. It seems there is a range of value where increasing consistency won't affect experience gain, until you enter the next plateau. It looks like there are either 5 or 6 plateaus. Still trying to narrow them down.

So, seeing as we are currently giving value to development as slow (10), normal (20), quick (30), superstar (40), we should do something similar with consistency plateaus. Just not sure how to value it yet. More to come.

[Rollo]

Re: JRT2006's Madden Scouting Tool

Looking at the game prep screen, you can see that development, coach trait and consistency all have 5 bubbles (either filled or unfilled). Coach trait will fill initially when you train that positions experience trait, and then will gain more filled bubbles as your coach gains higher levels. A QB will gain more experience in Game Prep from a max level coach with QB Experience Trait unlocked, than from a level 1 coach with the trait unlocked (haven't tested this, this is an assumption off the tutorial tool tip).

The development trait, while having 5 bubbles, will only fill them in 3 steps. Slow dev will have zero filled. Normal dev will have 1 filled. Quick will have 3 filled, and Superstar will have all 5 filled.

Last, we have the consistency trait.
0->19 consistency will have zero bubbles filled.
20->39 consistency will have 1 filled.
40->59 consistency will have 2 filled.
60->79 consistency will have 3 filled.
80->98 consistency will have 4 filled.
99 consistency will have 5 bubbles.

This is where I hit another wall. My rookie QB has 57 consistency, and even if I boost him up to 60 and he gets 3 filled bubbles, his experience gain from game prep does not increase. It doesn't increase until he hits 75 consistency, and that's only a 4 or 7 point average increase on the spread (10 hour game prep). So obviously, getting to the next plateau bubble-wise doesn't increase game prep experience. It seems there is a separate experience plateau, and "75" is the beginning of one of the plateau's.

I'm going to sim forward through my season and hopefully get enough points saved up to figure out the actual experience gains plateau's.

More to come later.

Edit: This is going to take me a lot longer than I thought, but I've got a plan and strategy that's working pretty well so far.

What I have seen is there is a plateau at 42, 50, 75, and 85. I also think there is a plateau at 25 and 99, but don't have enough information yet to see that. The plateau at 42 only adds to the lower end of the spread, the other 3 plateau's add equally to both sides. When looking at the 10 hour prep, the changes to lower/upper ends of the spread are +6. For the 6 hour prep, it looks like the 42 plateau is +2 on the lower end, and the 50 plateau is +3. Not enough information for the 75/85 plateau on 6 hour prep, but I think it goes by 2.5 (so 75 plateau should be +2/+2 and 85 should be +3/+3).

The way I am currently mapping the game prep is by using QBs and measuring the coach trait, development differences, and consistency value.

One thing I found is that a QB with 50 to 74 consistency will get the same experience spread. I have B. Osweiler at 50 consistency, normal development, and B. Marshall at 57 consistency, normal development. The only difference is coach trait is 2 for the broncos. Osweiler gets 1014-1512 experience, while Marshall gets 624-828. The Broncos coach is Level 27, with no QB experience trait (which changes something I thought earlier). Anyways, that coach trait bonus of 2 gives 390-684 more experience.

Doing the same thing, but with 6 hour prep, the Bears (3 coach trait), and K. Orton (65 consistency), gets 432-631 experience while T. Welch (66 consistency not he Vikings no coach trait) gets 249-331; difference of 183-300.

Edit#2: One last thing before bed. Looking at the Browns QBs, Manziel and Henne are in the same consistency plateau (70 and 65 respectively), but Manziel is a superstar while Henne is normal. Manziel gets 450 more experience on the lower and upper end of the range. Bridgewater has quick development (and no coach trait boost), and was at 74 consistency (same plateau), and is 864-1068 experience (240-240). Safe to say (for 10 hour QB game prep), Quick gives a 240 experience boost over normal, and superstar gives a 210 boost over quick (450 over normal).

Edit#3: Couldn't sleep as this was bugging me. Long story short, consistency is a minuscule change. M. Vick is at 15 consistency and gets an average 708 experience per 10 hours game prep (600-816), whereas taking P. Manning's superstar down to normal, and removing the 2 coach trait bubble bonus, he would be sitting at 738 experience per 10 hours game prep (636-840) at 96 consistency. If consistency cost 375 for every point from 0 to 99 (which it doesn't), it would take me 30,375 experience to boost Vick to Manning's consistency, and get a bonus average of 30 experience extra per 10 hours game prep. That would take over 1000 game prep's (again, if consistency cost 375 for every point, which it starts increasing every point after 74 i think). It's definitely not worth the trouble to boost up consistency, unless your player is 1 point away from 25/50/75/85 plateau's. And even then, if it cost 375 experience, it would take 63 10-hour game prep's (same as normal to quick boost) to wash out.

For the sake of adding it to our equation, personally I think we can completely ignore it, but if it's necessary, 25/50/75/85 plateau's should give 2.5% of the bonus Quick development gives, and the 42 plateau should give 1.125% of the bonus Quick development gives. Also, since normal to quick gives a bigger boost than quick to superstar, I think it should be reflected in the valuing (instead of a standard 10->20->30->40). Normal could be +0% bonus, quick could be +24% bonus, superstar could be +45% bonus. I'll have to get J. Locker onto my team and see what his 10 hour experience value is to determine how bad slow is compared to normal. Rough estimate is that slow is 32.5 points worse than normal, so slow would be -3.25%. In other words, if Slow is valued at 10, Normal should be 10.336, Quick should be 12.817, and Superstar should be 14.987.

Coach level and position experience trait give a bigger boost (more than dev trait). If anything, we should switch our concentration to adding that to our max potential.

[BeantowneS]

Re: JRT2006's Madden Scouting Tool

Awesome research. Understood the examples and conclusion perfectly. Thank you.

Sent from my Android phone thingy.

[JRT2006]

Re: JRT2006's Madden Scouting Tool

Damn Rollo, that is some fine data you found there.

As I've already got consistency put into the tabs, I'd hate to let the findings you discovered go to waste. It shouldnt be too much wor to implement the idea you had at the end of your post.

I'm going to upload a test as soon as I change one of the tabs to reflect your findings.

See what you think. For such a minimal impact in game, it will take some work, but again, so will removing the consistency additions I've already put in.

Thanks for this

[BeantowneS]

Re: JRT2006's Madden Scouting Tool

Played with the workbook a little and put in my roster manager. Got tired of going back and forth between Google sheets and excel. Thought it might help you in your adjustments and testing. its pretty straight forward but I included my pats CFM for a example. I am now where near you when it comes to excel but I tried to make it easy. All the conditional formatting is setup. I did notice that if you move players though you need to copy and paste values only. Or else it will make hundreds of conditional formats and you will lose the original format. Let me know if it helps. Thanks