Scouting Tool for Madden 17 CFM

[Old Man Nathy]

Quote: Originally Posted by burth179

I'm thinking of experimenting with scouting order and not scouting red chips further until the blue chips are identified. Basically just go down the draft board and scout as far as I can pre-combine (QB exception to the rule I think), then check the late round guys for physicals and scout accordingly. I'll see how it goes. I guess the theory is that I'd rather have a smaller board but try to identify all of the blue chips, than have a larger board but possibly missing out on a few blue chips. And also for red chips, not going to fully scout the potential red chips in the 1st round for sure, and maybe the 2nd and 3rd as well. The theory being I want a definite blue chip in 1st round and can save scouting to identify red chips in the mid-late rounds.

You're totally right: This is what I recommend doing too. I'm updating the blog post (and moving it over to Wordpress because Blogspot is unusable) to include some of this type of info.

[burth179]

Yeah it seems logical enough to me, I'll see how it goes!

Also, what type of age modifications do you personally use? I'm thinking of increasing it for youth as well but don't wanna over do it.

[darkraiusa]

Here's my draft class finished, OVRs only recorded for players In the draft recap screen, game broke down towards the end so I didn't get all of them unfortunately, but still has main bulk of them.

[DaBklynWay902]

Quote: Originally Posted by burth179

I'm thinking of experimenting with scouting order and not scouting red chips further until the blue chips are identified. Basically just go down the draft board and scout as far as I can pre-combine (QB exception to the rule I think), then check the late round guys for physicals and scout accordingly. I'll see how it goes. I guess the theory is that I'd rather have a smaller board but try to identify all of the blue chips, than have a larger board but possibly missing out on a few blue chips. And also for red chips, not going to fully scout the potential red chips in the 1st round for sure, and maybe the 2nd and 3rd as well. The theory being I want a definite blue chip in 1st round and can save scouting to identify red chips in the mid-late rounds. Also used the trade sheet and made a deal that was like within 2 points of each other (like a 2nd and 2 4ths for a late first and a future pick something like that). I tried a few other fair deals CPU even had small advantage according to sheet but they denied.

Can you post a link to the Jimmy Johnson trade sheet? Thanks

[Old Man Nathy]

Quote: Originally Posted by darkraiusa

Here's my draft class finished, OVRs only recorded for players In the draft recap screen, game broke down towards the end so I didn't get all of them unfortunately, but still has main bulk of them.

Thanks very much. Any chance you could upload it in .zip format? I can't open rars on my laptop.

[djp73]

is there a way to "dumb this down" for oldr versions of excel or for open office?

[Old Man Nathy]

Quote: Originally Posted by djp73

is there a way to "dumb this down" for oldr versions of excel or for open office?

I ran it through a validation checker and there are just way too many things to ever make it compatible with 2003. It's just about everything, from number of columns/rows, nested formulae, unavailable functions, unavailable types of conditional formatting and data validation. No way I can make it work in versions of excel that old.

For Excel 2007, it looks like there are a few issues around data validation whereby the validation looks up values in other worksheets for it's list of allowed inputs, and it uses a couple of functions not available in 2007. Problem is that these functions do quite important things, so I can't really sacrifice them just for the sake of Office 2007 compatibility. I'll change the data validation in the skills, grades, and scouting requirements cells to reference a list rather than an array in another worksheet so Office 2007 users will at least be able to use that aspect of the tool.

[Khaos_Kiwi]

Hey has anyone had any experience/success changing position type in the tool in order to change a prospect from do not draft to red chip, or red chip to blue chip, or just increase TVR rating?