NewNapkin's Dynasty Tracking Spreadsheet (Google Sheets)

[NewNapkin]

Hey everyone,

I'm one of those people who need to track all of the important happenings in Dynasty Mode in order to get immersed into the world. Because of this, I'm working on a new spreadsheet that will (hopefully) keep all of the records I need.

It is still a work-in-progress, but I wanted to post it here to crowdsource some ideas to make it even better. It is currently 100% usable, so feel free to download a copy and use it for your dynasty. I'm going to hold off and wait to see what improvements can be made, though.

There are no formulas in this spreadsheet, only a few instances of conditional formatting. It is designed for you to update manually throughout the season, but if anyone has any ideas for some automation, let me know.

Current Tabs

• Coaching History (includes year-by-year results and trophy case)
• Hall of Fame (for players you want to immortalize)
• NFL (I import draft classes to Madden 25, so I'll keep track of my players here)
• Future Non-Conf (I like to keep scheduling realistic, so I'll list out matchups I plan)
• 2013 (yearly template filled out throughout season)

Obviously, you can tweak it to your heart's desire due to different playing styles. For instance, I come up with a full, fictional coaching staff even though we only have two coordinators.

Here's the link for those interested in checking it out: https://docs.google.com/spreadsheets...it?usp=sharing

Once again, I'm primarily posting this to crowdsource potential improvements. Let me know how I can make it better.

[gluke]

This has some really awesome elements to it that I hadn't considered. I have a spreadsheet for mine but you thought of a ton of stuff that slipped my mind. I know you posted this months ago, but my only thought would be to have more of an area for actual season stats too.

[king8838]

This looks amazing, and I love how simple it is too. Will definitely be used in my next dynasty, so thank you my friend.

[volwalker]

I have my own dynasty tracker on my site that may be of use. It may not be as detailed as you need but it is a start. You might get some ideas from it. I am not a tracker myself and created this for other who do. They seem to like it though.

You can access the file HERE.