I just assume that was my fault for not following the story lines close enough. I did draft a QB in the 5th or 6th that the chart said "do not draft". Turned out to be quick development. Could have been user error on my part when I entered the info. I love this program though.

I started a CFM to test out and use this scouting tool. So far, I’ve gotten up to the week of the NFL combine, and I have a few observations that I think will help aid you in updating the scouting tool. Overall, I really like the functionality of the spreadsheet and think it is very beneficial to the scouting process as a whole, so thanks again for creating it!

With that said, here are the observations/issues I came across in my ~3 hours of scouting thus far:

1.) Currently, it looks like the Draft Status cells do not take into account the order in which the Scouted Skills 1 – 3 are entered. For example, a LT must have at least one Scouted Skill at a grade of B or higher; otherwise, they Buy Madden 17 Coins should not be considered for drafting. However, one of my scouted LTs is not being removed from the Scout further Draft Status, even though his best skill, Scouted Skill 1, is Impact Blocking of C+ which does not meet the requirement of having at least one Scouted Skill at a grade of B or higher. It’s only when his third Scouted Skill, Pass Block of C-, does the Draft Status cell's logic switch the output to Do not draft. It should have said Do not draft right away after Scouted Skill 1 was entered.

2.) Similarly, the Draft Status cells do not have the logic built in to immediately remove a player from draft consideration if their first Scouted Skill Grade is lower than a specific skill requirement. For example, a MLB I scouted has his first Scouted Skill at as Block Shedding of B-. Well, if you look at the required skills for a MLB, one of them is B or higher in Tackle. Since the Scouted Skill 1 is a B-, that Tackle skill requirement can never be met; the highest it could be would also be a B-. After all 3 Scouted Skills are input, this MLB ends up being labeled as a Risky Pick, but I think he should be labeled as a Do not draft, since we know he doesn’t meet the Tackle skill requirement from the Scouted Skill 1.

3.) Lastly, and this addresses how to “fix” problem 2 listed above, I think the Scouting Requirements tab needs to have more entries in the G-column titled “Must have at least one”. Using the MLB as an example, if we are requiring the MLB to have a Tackle skill of B or above, then the G-column for the MLBs should have a B in it. In this example, if the G-column were updated to require a B for MLB, then the scouted MLB would be a Do not draft after entering just his Scouted Skill 1. Likewise, for QBs, they’d need an A- in this column, HBs would need a B, etc. all based on the highest required skill for that position. From QB all the way to CB (and technically Ks and Ps too), there should be a value in the G-column for “Must have at least one” if this cell is currently empty.

So in conclusion, I think there are some simple ways to improve upon this already robust spreadsheet. Namely that the Draft Status cells would have functionality built in that also does these two things:

a.) Checks the Scouted Skill 1 Grade, and if it is Buy NFL 17 Coins(https://www.nfl17coin.com/) below the Scouting Requirement for "Must have at least one" rating at X or higher, then the player’s Draft Status switches immediately to Do not draft. Essentially, the order in which the Scouted Skills are entered and/or read would matter this way.

b.) By adding entries to the Scouting Requirements tab under the “Must have at least one” for all positions, the Draft Status cell will be more accurate as a result.

Again, overall this is already an awesome tool as it stands today, and I think these modifications can make it even better. Let me know what you all think! (Sidenote - I had originally planned to insert screenshots, but was unable to do so, not sure what I'm doing wrong there...)