Home

M22 Scouting Tool

This is a discussion on M22 Scouting Tool within the Madden NFL Football forums.

Go Back   Operation Sports Forums > Football > Madden NFL Football
Operation Sports Survey - Newsletter, Forums, Content and More
From Guaranteed to Never Happening, a College Football 26 Wishlist
2025 Sports Video Game Predictions
Reply
 
Thread Tools
Old 11-10-2021, 12:43 PM   #25
Pro
 
OVR: 6
Join Date: Mar 2003
Posts: 580
Blog Entries: 5
Re: M22 Scouting Tool

What a great tool, much appreciated Matt. Just wanted to make sure I am doing this right after seeing some comments.

1. I am adding the players by region just makes it easier for me to just go down the region and already know who the scout is and position expert which I can enter same for all so it cuts time down. I just want to make sure this type of data entry will not screw anything up. I plan on entering all of the prospects into the tool.

2. This was just feedback that I resolved on my own. I noticed "Connecticut" was missing. I entered the details myself in the college tab.

3. When you post a new version, do we just download the new version and copy and paste the data we have already entered and paste it into the new version?

Again thank you for this. If you need any help please let me know.
Proff56 is offline  
Reply With Quote
Advertisements - Register to remove
Old 11-10-2021, 01:01 PM   #26
MVP
 
Mattanite's Arena
 
OVR: 0
Join Date: Sep 2015
Location: UK
Posts: 1,729
Re: M22 Scouting Tool

Version control bug in version 1.01, sorry folks, 1.01.01 up now
Mattanite is offline  
Reply With Quote
Old 11-10-2021, 01:09 PM   #27
MVP
 
Mattanite's Arena
 
OVR: 0
Join Date: Sep 2015
Location: UK
Posts: 1,729
Re: M22 Scouting Tool

Quote:
Originally Posted by Proff56
What a great tool, much appreciated Matt. Just wanted to make sure I am doing this right after seeing some comments.

1. I am adding the players by region just makes it easier for me to just go down the region and already know who the scout is and position expert which I can enter same for all so it cuts time down. I just want to make sure this type of data entry will not screw anything up. I plan on entering all of the prospects into the tool.

2. This was just feedback that I resolved on my own. I noticed "Connecticut" was missing. I entered the details myself in the college tab.

3. When you post a new version, do we just download the new version and copy and paste the data we have already entered and paste it into the new version?

Again thank you for this. If you need any help please let me know.
1 If you don't start by adding all player names in their Madden projected order it will screw ScoutScore up. The idea is that projection is mostly decent with a few nasty busts and shiny gems mixed in. The tool lets you know that a player may be best avoiding until later rounds. If you enter the player names in any other order then it'll mix up the "Pick" Column B in Scouting Tool and then cascade the problem onwards.

2 Cheers, there's likely to be missing ones, I'm don't follow NCAA much. Will look it up.

3 Yes, download new version and then copy paste Names to the correct Pick, then region, scouts, age, height, weight, precombine, notes, stories, grades etc. It'll automatically do the rest. I will always try to keep the info you've had to type as simple as possible to copy during versions.
Mattanite is offline  
Reply With Quote
Old 11-10-2021, 01:35 PM   #28
Pro
 
OVR: 6
Join Date: Mar 2003
Posts: 580
Blog Entries: 5
Re: M22 Scouting Tool

Thank you.. Reading is fundamental.

NOOOOOOOOO!!!!! Lol..
Proff56 is offline  
Reply With Quote
Old 11-10-2021, 01:40 PM   #29
Rookie
 
OVR: 0
Join Date: Mar 2018
Re: M22 Scouting Tool

The Kick Power column appears to be broken. The scout card lists kick power as Elite, Great, Good, etc. but the spreadsheet only allows for A,B,C values. I'm assuming that A corresponds with Elite and on down the line but is that correct or does this need fixed? TIA
bware322 is offline  
Reply With Quote
Old 11-10-2021, 01:44 PM   #30
MVP
 
Mattanite's Arena
 
OVR: 0
Join Date: Sep 2015
Location: UK
Posts: 1,729
Re: M22 Scouting Tool

Quote:
Originally Posted by bware322
The Kick Power column appears to be broken. The scout card lists kick power as Elite, Great, Good, etc. but the spreadsheet only allows for A,B,C values. I'm assuming that A corresponds with Elite and on down the line but is that correct or does this need fixed? TIA
Kick power has a formula in (Green background) that indexes the approx. KPW based on Pre Combine info. If you've accidentally overridden it paste this formula into the first row and extend it to the whole column so you don't have to re-paste stuff.

=IFERROR(IF(X4="ST",IFERROR(INDEX(Physical!$AB$3:$AB$8,MATCH(AJ4,Phys ical!$AA$3:$AA$8,0)),""),""),"")

Edit: Posting wants to add a space to second Physical in formula, delete this space when you paste.
Mattanite is offline  
Reply With Quote
Old 11-10-2021, 01:53 PM   #31
Rookie
 
OVR: 0
Join Date: Sep 2012
Re: M22 Scouting Tool

I started inputting information and started to notice that the ScoutScore column wasn't updating. I looked at the formula and it is indexing another xls from a D: drive that we don't have access to. Any fix for this?
JstkrznTTU is offline  
Reply With Quote
Advertisements - Register to remove
Old 11-10-2021, 01:55 PM   #32
Rookie
 
OVR: 0
Join Date: Sep 2010
Re: M22 Scouting Tool

Quote:
Originally Posted by Mattanite
1 If you don't start by adding all player names in their Madden projected order it will screw ScoutScore up. The idea is that projection is mostly decent with a few nasty busts and shiny gems mixed in. The tool lets you know that a player may be best avoiding until later rounds. If you enter the player names in any other order then it'll mix up the "Pick" Column B in Scouting Tool and then cascade the problem onwards.
What if you don't get all the players entered immediately? If it's week 6 and there's already been some player movement, will it work correctly if you are still adding them based on the overall order?
j1mmycr4ckc0rn is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Football > Madden NFL Football »


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 12:26 AM.
Top -