OOTP Developments Forums - View Single Post

thirdsaint · 12-15-2020, 01:56 PM

I use my spreadsheets to track history more than anything. I have a History Recaps spreadsheet that, for each season, I put critical season events or trades in, milestones, and top achievements. This helps me to remember a season by getting a good snapshot of everything that happened and jog my memory. I also do a game-by-game recap of all my playoff games with a brief line of stats or significant events. Other tabs include top 25 in major stat areas, the history of largest contracts signed to date, and all major awards listed year by year.

My personal favorite tab is rife with formulas for the Bill James proposed Manager Ratings where a manager gets points in a given season depending on milestone their team achieves like so: four points for winning the World Series, three points for winning the pennant but not the World Series, two for a divisional title and one for each season with a record above .500. In addition, a manager gets one point for guiding his team to 20 games above .500 and a second point for winning 100 games.

This allows me to see the best managers and I'll have my own Hall of Fame for them on this tab since OOTP doesn't do a manager hall of fame yet.

I have other spreadsheets for Draft History too. Each season gets its own tab for the first round picks. I track how each pick did in terms of Championships, Major Awards and WAR total. After 10 Years I do a re-draft on that same tab to see how teams did and I also find all of the later round picks that have produced well. Its fun to see a 7th Rounder make the Re-Draft and get picked #4 overall. I may do a re-draft after 20 years too, which I finally hit with Year 21 starting in my league soon.

I have other spreadsheets that keep track of Season Records for each team, Dynasty Tracker with points assigned to teams depending on playoff results, and a Championship/Playoff Drought tracker.

Needless to say, I love Excel and OOTP.

12-15-2020, 01:56 PM	#11
thirdsaint Major Leagues Join Date: Jun 2012 Location: Chicago Posts: 364	I use my spreadsheets to track history more than anything. I have a History Recaps spreadsheet that, for each season, I put critical season events or trades in, milestones, and top achievements. This helps me to remember a season by getting a good snapshot of everything that happened and jog my memory. I also do a game-by-game recap of all my playoff games with a brief line of stats or significant events. Other tabs include top 25 in major stat areas, the history of largest contracts signed to date, and all major awards listed year by year. My personal favorite tab is rife with formulas for the Bill James proposed Manager Ratings where a manager gets points in a given season depending on milestone their team achieves like so: four points for winning the World Series, three points for winning the pennant but not the World Series, two for a divisional title and one for each season with a record above .500. In addition, a manager gets one point for guiding his team to 20 games above .500 and a second point for winning 100 games. This allows me to see the best managers and I'll have my own Hall of Fame for them on this tab since OOTP doesn't do a manager hall of fame yet. I have other spreadsheets for Draft History too. Each season gets its own tab for the first round picks. I track how each pick did in terms of Championships, Major Awards and WAR total. After 10 Years I do a re-draft on that same tab to see how teams did and I also find all of the later round picks that have produced well. Its fun to see a 7th Rounder make the Re-Draft and get picked #4 overall. I may do a re-draft after 20 years too, which I finally hit with Year 21 starting in my league soon. I have other spreadsheets that keep track of Season Records for each team, Dynasty Tracker with points assigned to teams depending on playoff results, and a Championship/Playoff Drought tracker. Needless to say, I love Excel and OOTP.