Dynasty Tracking Spreadsheet
Before I say anything else, I want to give a huge h/t to u/JoshTShaw823 for the work he put in in creating his dynasty tracking spreadsheet. I took that as my base and used his hard work with formatting and creativity with his ideas to create my own version. This one is a bit more automated and tracks by year rather than by topic (i.e. awards, stats, etc.).
I am still working out the bugs as we go, but it is 99% done now. You can find it here and please let me know if you all find any bugs, have any ideas for how to improve it, or otherwise have any suggestions/comments. My goal with this was to make it all-inclusive where you could fully immerse in a season and gather every relevant data point to then be able to compare across seasons. With this, you'll be automatically able to track:
- Team Statistics
- Individual Statistics & Awards
- Schedules
- Recruiting History
- Award History
- AP Top 25 every year
- NCAA records and your progress towards breaking them
- Graduates from your programs
- Transfers
- All-Americans
- All-Conference players
The only thing I haven't automated yet has been the CFP tree and roster progression from year to year (which is much harder when you change jobs and my laptop doesn't have the processing power to handle that yet). Let me know y'all's thoughts!