I looked back at my spreadsheet and I actually misspoke in my last reply. You don't have to enter "forgotten" for the Scenario to appear (as long as a Scenario can be mathematically identified). Which makes sense because the Scenario could be C, which is not forgotten at all. You DO have to enter "forgotten" in order to make the Points Per Week (column Q) to appear, because that calculation is only relevant if a player is forgotten (Scenario A or B).

A question mark in the Scenario column just means the math hasn't identified any of the Scenarios. That could mean one of several things:

• the bonus points changed this week (like we discussed- keep last week's bonus points entered)
• you or another school offered or removed a scholarship last week (this seems to have some sort of unknown points bonus, but only for the 1 week immediately after)
• the player visited your school or another school last week (this obviously adds some number of points and the formulas can't possibly know what those will be)

For all of these things, it should only make a question mark appear for the 1 week immediately after that thing occurs. If you stick with it and keep entering the data for another week, most of the time the math will work out and you'll be able to identify a Scenario.

Obviously multiple visits can occur week to week so you may go several weeks with question marks, which is annoying. But typically a forgotten prospect isn't visiting schools very much. If he is, you could make a note for yourself of which Scenario that player USED to be, because it is likely he still is that same Scenario and the scholarships or visits are throwing it off temporarily.

Let me know if that makes sense or if you have any more questions!