JRT2006's Madden Scouting Tool

[JRT2006]

Re: JRT2006's Madden Scouting Tool

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.

You'll have to help me understand your math on this.

You lost me at the quoted part above.

[Rollo]

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

Just remember that all of my values correspond only to 6 hour and 10 hour QB training. Most of the other positions have 8 hour training, and even then the exp ranges are split in two groups. My assumption is the plateaus stay the same, and that the consistency bonus stays the same % difference with dev trait.

It looks like for 6 hour QB, we have a total change of +13/+10 between lowest and highest plateau. Likewise, normal to superstar for 6 hour game prep is a difference of 180 points. In this instance, total consistency is 6.4% of normal to superstar. 10 hour QB training looks like a +30/+24 total change from low to high consistency. That gives a 6% value when compared to normal to superstar boost. I could either do some more research with other positions, or we can call the 6% good and I can concentrate on coach trait experience boost.

If we call the 6% good, then I would say 0-25 consistency should get 0% boost, 25-41 gets 1.33%, 42-49 gets 2%, 50-74 gets 3.33%, 75-84 gets 4.67%, 85+ gets 6%.

Someone with slow and 85 consistency would have a (10)(1.06)= 10.6 potential modifier. Someone with quick and 50 would get (12.87)(1.0333)= 13.3 potential modifier. Someone with superstar and 25 would get (14.987)(1.0133)= 15.19 potential modifier. Add in coaching trait modifier and I think we're golden.

[JRT2006]

Re: JRT2006's Madden Scouting Tool

So, are these consistency bonuses pointless if we don't use the coaching trait?

Can we get a good read on future value with a consistency bonus the way you have listed now without adding coaching traits?

[JRT2006]

Re: JRT2006's Madden Scouting Tool

I feel as though I'm not doing my math right,
using a QB from your created roster eval sheet, Barry Marshall.

Barry Marshall is average development with 57 Consistency

Average development is 20 points, 57 Consistency puts him in the 3.33% range.

3.33% of the development points(20) = .666 points.

Add that to his modifier?

*the italics above are where I think I'm misunderstanding

**Have a look at the QB Tab on the attached file and let me know if this is what you were getting at? Keep in mind the age factor we have implace as well

[JRT2006]

Re: JRT2006's Madden Scouting Tool

The more I think about it, with a less then 1 point addition to values, having consistency in the formulas is a lot of wasted effort. Rather than add add all the data and formulas to go with it, it would be much quicker to remove the consistency column and formula from the entire sheet.

Players values will only increase by a point or two...

[JRT2006]

Re: JRT2006's Madden Scouting Tool

Cleaning up the Roster Evaluation Tool.
-Double Checking for errors
-Locking cells with formulas not so you cant see but so they don't get changed on accident. If you want the formula, I will gladly share it
-Removing Consistency Thank you Rollo for the effort in discovering that information. With a less than 2 point increase in value, I found it was best to leave it out of the sheet. Age and development make a much bigger impact and will likely be the deciding factor over who to keep on the roster, not their consistency
-Creating new buttons to clear board information

Should be posted by tonight (12:11pm here now). Then i will clean up the scouting tool and add age to it as well.

[Rollo]

Re: JRT2006's Madden Scouting Tool

The more I think about it, with a less then 1 point addition to values, having consistency in the formulas is a lot of wasted effort. Rather than add add all the data and formulas to go with it, it would be much quicker to remove the consistency column and formula from the entire sheet.

Players values will only increase by a point or two...

I agree. I'll keep it on mine just cuz I'm a tad OCD about that ****, but it's pretty pointless.

As for coach trait. It's a pretty size able bonus. I'm at work right now, but iirc it was a 390-600ish boost for 2 coach trait bubbles on the 10 hour game prep.

Edit: on second thought, adding coach trait to the sheet won't separate one player from another since each player gets the exact same bonus. We should be good where we stand.

[bobloblah1980]

Re: JRT2006's Madden Scouting Tool

Jrt has anyone asked about a team needs column in the big board section just for reference while you are drafting? just a thought

[JRT2006]

Re: JRT2006's Madden Scouting Tool

They haven't, weve just weighted the team needs and taken who was valued highest, it wouldnt be difficult to add though.

I'll work on that as well as the age addition as soon as the roster eval is done

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

I agree. I'll keep it on mine just cuz I'm a tad OCD about that ****, but it's pretty pointless.

As for coach trait. It's a pretty size able bonus. I'm at work right now, but iirc it was a 390-600ish boost for 2 coach trait bubbles on the 10 hour game prep.

Edit: on second thought, adding coach trait to the sheet won't separate one player from another since each player gets the exact same bonus. We should be good where we stand.

Really good research bro. I was just gonna post that the coach traits wouldn't matter since it'd be the same for all at that position but u got there first lol. I think we are golden on this. Good job everyone all around.

Sent from my Galaxy s4 so deal with the short hand

[JRT2006]

Re: JRT2006's Madden Scouting Tool

Roster Eval Tool complete.

I feel like I may have missed a Clear button on a tab or two, idk.

Posting now in original post.

Need to clean up the OP so it isnt so hard to read too

THANKS FOR EVERYONES input and work on this!

[JRT2006]

Re: JRT2006's Madden Scouting Tool

Jrt has anyone asked about a team needs column in the big board section just for reference while you are drafting? just a thought

Need label has been added. On your Team Needs tab, where you input your desired weights for position, right beside it you may label the need (Low, medium, High - or whatever you want really) and it will appear on the Big Board when it is generated.

[Last Gunfighter]

Re: JRT2006's Madden Scouting Tool

Been following this thread since the beginning and I have to say JRT and company (you know who you are), your collaboration on this has been a pleasure to watch. You guys came together and produced 2 extremely useful tools that I think almost all Madden users would find most beneficial. The way you gathered information, and bounced it off each until finding the way to leverage it best, was awesome. It was great to see JRT put all this together and while doing it manage to listen too, answer and very often add just about every request or suggestion made. I will be using both tools extensively when I start my new CFM after the patch today. Thanks guys, very impressive!!!

[Rollo]

Re: JRT2006's Madden Scouting Tool

Roster Eval Tool complete.

I feel like I may have missed a Clear button on a tab or two, idk.

Posting now in original post.

Need to clean up the OP so it isnt so hard to read too

THANKS FOR EVERYONES input and work on this!

If I get time, I'll check it out tonight. Most likely won't til tomorrow though. Good work all around!

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

If I get time, I'll check it out tonight. Most likely won't til tomorrow though. Good work all around!

Same with me. I'm at my draft to so I have all kinds of stuff to input and what not. Should be fun.

Sent from my Galaxy s4 so deal with the short hand