Home

NewNapkin's Dynasty Tracking Spreadsheet (Google Sheets)

This is a discussion on NewNapkin's Dynasty Tracking Spreadsheet (Google Sheets) within the EA Sports College Football forums.

Go Back   Operation Sports Forums > Football > EA Sports College Football
Football Simulator Hands-On Preview
World of Chel Tips and Tricks: How to Be a Good Teammate
Sunday Rivals Review - Great Mix of Sim and Arcade
Reply
 
Thread Tools
Old 02-05-2020, 06:41 PM   #1
#FlyTheW
 
NewNapkin's Arena
 
OVR: 9
Join Date: May 2009
Location: Tennessee
Posts: 1,001
NewNapkin's Dynasty Tracking Spreadsheet (Google Sheets)

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.
__________________
Moderator
Cubs | Bears | Blackhawks | Bulls | Blue Raiders
NewNapkin is offline  
Reply With Quote
Advertisements - Register to remove
Old 08-21-2020, 11:24 PM   #2
Rookie
 
OVR: 0
Join Date: Jul 2020
Re: KGHerm's Dynasty Tracking Spreadsheet (Google Sheets)

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.
gluke is offline  
Reply With Quote
Old 09-10-2020, 08:52 AM   #3
Rookie
 
king8838's Arena
 
OVR: 2
Join Date: Dec 2009
Location: Central KY
Re: KGHerm's Dynasty Tracking Spreadsheet (Google Sheets)

This looks amazing, and I love how simple it is too. Will definitely be used in my next dynasty, so thank you my friend.
__________________
Psalm 118:17 "I will not die; instead, I will live to tell what the LORD has done."
king8838 is offline  
Reply With Quote
Old 09-10-2020, 11:42 AM   #4
Pro
 
volwalker's Arena
 
OVR: 3
Join Date: Jun 2011
Re: KGHerm's Dynasty Tracking Spreadsheet (Google Sheets)

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.
__________________
Playbook Gamer - Football Gaming & Strategy
volwalker is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Football > EA Sports College Football »


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 06:07 PM.

Top -