JRT2006's Madden Scouting Tool

[MaddenGod69]

Re: JRT2006's Madden Scouting Tool

I think this is a fantastic tool. It reminds me of the PocketScout iPhone app that I used to use for NCAA football. That app allowed you to assign letter grades to position specific attributes. It then generated an approximate overall rating based on the letter grades that you input. Your system has the potential to be better, though, because you can also create and manage a draft board from the same "app." (On a side note, you could totally be making money from this.)

Anyway, rather than find the "best fit" for my team, I am hoping to find and draft the best rated players. I feel that I can accomplish this by determining what position specific attributes generate higher overall ratings than others and then weight them accordingly. For example, let's say that a QB's THP can increase his overall rating by 20 pts, but his SPD can only increase his overall rating by 10 pts and his AWR can only increase his overall rating by 5 pts, then I will weight THP a 5, SPD a 3 and AWR a 2. To determine what attributes increase overall rating most, I'll just (1) go into the create-a-player screen and keep all their position specific ratings at the base level (2) max out one position specific rating at a time and (3) track how much the player's overall rating increases when the one position specific rating is maxed out.

This is all just theoretic, but I figure its worth a shot.

[Last Gunfighter]

Re: JRT2006's Madden Scouting Tool

I think this is a fantastic tool. It reminds me of the PocketScout iPhone app that I used to use for NCAA football. That app allowed you to assign letter grades to position specific attributes. It then generated an approximate overall rating based on the letter grades that you input. Your system has the potential to be better, though, because you can also create and manage a draft board from the same "app." (On a side note, you could totally be making money from this.)

Anyway, rather than find the "best fit" for my team, I am hoping to find and draft the best rated players. I feel that I can accomplish this by determining what position specific attributes generate higher overall ratings than others and then weight them accordingly. For example, let's say that a QB's THP can increase his overall rating by 20 pts, but his SPD can only increase his overall rating by 10 pts and his AWR can only increase his overall rating by 5 pts, then I will weight THP a 5, SPD a 3 and AWR a 2. To determine what attributes increase overall rating most, I'll just (1) go into the create-a-player screen and keep all their position specific ratings at the base level (2) max out one position specific rating at a time and (3) track how much the player's overall rating increases when the one position specific rating is maxed out.

This is all just theoretic, but I figure its worth a shot.

Man, I thought the exact same thing, these guys could be selling this thing. And make it into an app for your mobile, that would be huge!!! I think you guys are really on to something here.

[JRT2006]

Re: JRT2006's Madden Scouting Tool

I don't know too much how apps work with mobile phones, or if programming is required. I assumed it was, but being that I have the weird addiction to excel and MS Access - its something I'm going to go to school for.
Weird going from firefighter to programmer - but then again, in my department, I've created such tools to track training, maintenance, and personnel as well.

That being said, I wouldn't be opposed to somebody wanting to try and make an app with the information gathered and anything useful from the tool, as long as I can help and gain some knowledge from it

Originally, I wanted to make the tool to find the best overall players, but then i started thinking of how many guides are out there, how many threads tell you what to scout to find those gyms. i wanted something different, one of my favorite things to do in the game, besides play it, is creating my vision on the field, "if i were a coach I would do this" type of thing.
i shout at the tv and computer screen all the time, demanding my favorite team to pick this player and that player because they have certain qualities. I figured creating a tool like this, where you value players on specific skills you prefer rather than overall ratings would make managing a team much more interesting.

Anyways, if you all see anything that needs fixing, or have more suggestions, let me know. I'm always open to trying to fit something new in if its useful

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

I don't know too much how apps work with mobile phones, or if programming is required. I assumed it was, but being that I have the weird addiction to excel and MS Access - its something I'm going to go to school for.
Weird going from firefighter to programmer - but then again, in my department, I've created such tools to track training, maintenance, and personnel as well.

That being said, I wouldn't be opposed to somebody wanting to try and make an app with the information gathered and anything useful from the tool, as long as I can help and gain some knowledge from it

Originally, I wanted to make the tool to find the best overall players, but then i started thinking of how many guides are out there, how many threads tell you what to scout to find those gyms. i wanted something different, one of my favorite things to do in the game, besides play it, is creating my vision on the field, "if i were a coach I would do this" type of thing.
i shout at the tv and computer screen all the time, demanding my favorite team to pick this player and that player because they have certain qualities. I figured creating a tool like this, where you value players on specific skills you prefer rather than overall ratings would make managing a team much more interesting.

Anyways, if you all see anything that needs fixing, or have more suggestions, let me know. I'm always open to trying to fit something new in if its useful

It's because we are able to create our own ovr ratings now based on what we value most. What more could a virtual gm/coach ask for lol.

Sent from my Galaxy s4 so deal with the short hand

[Nuke LaLoosh]

Re: JRT2006's Madden Scouting Tool

How the heck do you open these files on a Macbook?

[mmorg]

Re: JRT2006's Madden Scouting Tool

For the guys trying to find the best overall players. What I've done basically is create different sheets within the workbook for different types of players. I have a separate sheet for 4-3 Right Defensive Ends, 3-4 Right Defensive Ends, 3-4 Left Defensive Ends just like I have a different sheet for Receiving Running Backs and Power or Elusive Running Backs. This way I can enter in all the information and see who the best players in the draft are, not just how many guys fit into a certain archetype.

For some of these players I will enter them into the sheet multiple times to get a good grade on them. I will put 4-3 DTs into the 3-4 DE books, and 4-3 DEs into the 3-4 OLB sheets. I think this gives me a good idea on who the best players are overall and how much flexibility they will have within a scheme.

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

Quick error I noticed. On all the sheets the Awr and/or Play Rec is multiplied by 5 except on the HB one. It is multiplied by 1. Quick fix.

Edit:
Also just realized quite a few tabs are not showing the Future Value. Since the cells are protected I can't see what's happening.

Edit 2:
Ok. Sorry. Just the QB and RT tab isn't showing a Future Value so far. Did we change that forumla by the way. It seems off to me.

Example:
Keenan Allen is 23 with Superstar Dev.
His Actual Value is 303
With age cut off set at 34 and Superstar Dev set at 20 his Future Value is only 334?? So after 11 years of progression he is only going to get 31 better?? It seems like instead of it being this:

11(years progression)*20(superstar dev)=220

It's this:

11(years progression)+20(superstar dev)=31

Am I missing something? Thanks again.

Edit 3:
On the RE tab you have locked the cells for the Skill/Weight table, Prof Droop Off Age, Priority/Weight table, and the Development table.

Edit 4:

On the MLB tab row 2 works fine. But it seems row 3 and beyond doesn't account for Sped, Agility, Acc, Zone Cov, and Man Cov in the Raw Potential formula.

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

How the heck do you open these files on a Macbook?

Now I don't have a mac so I can't say for sure this works but from reading I think this application should do it.

Apache OpenOffice 3.4.1

Just google it. I believe it's free as well.

[KingFry]

Re: JRT2006's Madden Scouting Tool

Just finished my draft, using this tool. Had an A+ draft IMO.... lots of my targets got stolen, but I traded back and this tool got me some nice studs. Got a 80 OVR SS, about 5 more guys ranging from 75-77 in mid rounds. Later on I didn't have many guys left(switched to coach midseason, didn't have 2x points), so I had to go with a UD guy I scouted, ended up at 68.... took some risks on unscouted guys and they weren't bad... anyways, back to the main point, this tool helped me find the next Ed Reed and A.J. Green(whats cool is I have green on my team too.... lol), so... uh... I love you!

Anyways, trying out your roster eval since I just got to the preseason. Very curious to see what it recommends for me as I signed a bunch of UDFA's. Once again, thank you and great job JRT and co.

[Rollo]

Re: JRT2006's Madden Scouting Tool

How the heck do you open these files on a Macbook?

They are Excel files. They work on my Mac mini with Mac Office 2011.

[JRT2006]

Re: JRT2006's Madden Scouting Tool

Quick error I noticed. On all the sheets the Awr and/or Play Rec is multiplied by 5 except on the HB one. It is multiplied by 1. Quick fix.

Edit:
Also just realized quite a few tabs are not showing the Future Value. Since the cells are protected I can't see what's happening.

Edit 2:
Ok. Sorry. Just the QB and RT tab isn't showing a Future Value so far. Did we change that forumla by the way. It seems off to me.

Example:
Keenan Allen is 23 with Superstar Dev.
His Actual Value is 303
With age cut off set at 34 and Superstar Dev set at 20 his Future Value is only 334?? So after 11 years of progression he is only going to get 31 better?? It seems like instead of it being this:

11(years progression)*20(superstar dev)=220

It's this:

11(years progression)+20(superstar dev)=31

Am I missing something? Thanks again.

Edit 3:
On the RE tab you have locked the cells for the Skill/Weight table, Prof Droop Off Age, Priority/Weight table, and the Development table.

Edit 4:

On the MLB tab row 2 works fine. But it seems row 3 and beyond doesn't account for Sped, Agility, Acc, Zone Cov, and Man Cov in the Raw Potential formula.

Dammit, I knew it couldn't be perfect. I'll look into the errors in a minute.
As far as the future values, I brought it up quite a few pages back on if multiplying or adding the modifiers was better, somebody suggested adding, and I went with it. It was a question of would you rather have future values far an above higher than actual or somewhat close

But I never read it the way you did, in 11 years he should be this value. I've always looked at it like, this guy's has the best potential.
I like your way better, and I think going back with multiplying the modifier is the way to go.

[JRT2006]

Re: JRT2006's Madden Scouting Tool

If not tonight, I'll get the fixed tools put up sometime during work tomorrow

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

Dammit, I knew it couldn't be perfect. I'll look into the errors in a minute.
As far as the future values, I brought it up quite a few pages back on if multiplying or adding the modifiers was better, somebody suggested adding, and I went with it. It was a question of would you rather have future values far an above higher than actual or somewhat close

But I never read it the way you did, in 11 years he should be this value. I've always looked at it like, this guy's has the best potential.
I like your way better, and I think going back with multiplying the modifier is the way to go.

It's all good man. Finally got a chance to start plugging in my team today. I have no problem being the "bug" finding guy lol. Fantastic job btw. This thing is going to be amazing to use. If I notice anything else I'll be sure to let you know.

As far as the Future Value and multiplying I always thought of it as here is so and so's potential. If you give this guy every opportunity (playing time and game prep) this is the level he can get to.

[Nuke LaLoosh]

Re: JRT2006's Madden Scouting Tool

They are Excel files. They work on my Mac mini with Mac Office 2011.

I bought my MacBook in 2010 and I don't have Mac office. I don't use the MacBook for anything of real use besides emails and browsing. The Apache open office seems to have worked though.

[tdawg3782]

Re: JRT2006's Madden Scouting Tool

Couple more things.

Item 1

This is strictly up to up but only the QB tab has the player name column frozen. The rest don't. Would be great to have them all like that.

Item 2

When clicking on "Evaluate Roster" on the "Roster Board" tab it puts all the players "Future Value" on the "Future Value" column and the "Actual Value" column. It doesn't pull up the "Actual Value" numbers.

Also since you have row 1 on the "Roster Board" tab protected we are not able to sort the data.

Also all the OL show up as LT for their position. I not sure but even though all OL come in as LT on the board it doesn't seem to take them into account as far as Team Needs. I only have 1 LT and on my needs board I want 2. That should come out as a -1 but it still says -2.