Posted by Mr_Kid on 3/25/2016 4:51:00 PM (view original):
That is a very good in-depth analysis. I appreciate all of the tips. Do you have any good ideas for a spreadsheet? I have made one, but feel I can make it more effective.
Some things I do (and keep in mind I'm an average coach):
1. As said before, class planning. On each team's 'tab', I have the next 5-10 year "Ideal" classes planned out, so I will have position coverage and not be stuck with a young group. Saves time while recruiting to know which types of players I need, and what juco/transfers I may need. As with all wars the best laid plans go out the window at contact of the enemy, but a good plan is better than no plan.
2. I have one tab just to sort recruiting- I copy and paste all players relevant to what I want, then I can use overall formulas to sort them, and can type in their 'final' numbers (Adding 20 for blue, etc as said above) to sort what they will be, not what they currently are.
3. I have a chart for each team to decide lineups. I don't use my personal overall formulas as gospel, but it makes it quicker to sort out my team (personally) and allows me to see what positions I'm okay with each player playing. I have a copy of that again with their 'ideal' ratings they may get to. I also find it easier to use the filter and remove players that I'm not looking at to decide strategies and lineups.
4. I have a PER calculator, mostly from back in my So-Cal awards days (long time ago), but it helps me see who's really contributing.
5. Extreme and usually useless- I have a notes sheet. It has what O/D certain HS's run (which I don't think has ever been useful) a list of messages for potential (to help me remember what's High-high), study hall time vs. GPA and other odds and ends from the forum (like HS FT% to letter grade). There's a lot of good info here, and sometimes it slides into oblivion and becomes very hard to find again.
Hope that helps, but as I said at the start, I've been playing off and on for years and only have one final four...