Do you use spreadsheets to track your franchise/players?

[TexasDBack]

I'm curious to find out if there is a best practice out there that I'm missing. I have a spreadsheet I use to track all of my players, the key stats I care about for each, salary, as well as my 5 year outlook on positions, rotations and roles.

How about you guys? Are there best practices, spreadsheets, sites you use to track your franchise?

TIA.

[TheCoastIsBen]

I use a spreadsheet that I orriginally got from a member here... I cannot remember his name atm. I edited it to be a little more streamlined, but I track current roster/jersey numbers. Draft order and selections for all 30 teams, monthly and yearly awards. Trades in the league, game results for my team. Also regular/postseason stats for my guys and postseason box scores. Im in year three of my current franchise and I'm hoping that mlbts19 gives me a reason to start a new franchise, otherwose ill carryover. I used to keep a tab for minor league stats too, but it just got too time consuming.

Sent from my VS996 using Operation Sports mobile app

[Hayman19]

This will be my first year doing it. I plan on finishing the rebuild of the Marlins into(Hopefully) a contending team. I had never really used google sheets before this other than very simple tasks - never getting into the formulas much so it has been quite the learning experience. I did this for an EA UFC Universe but to much less extent.

So far this is what I have. I'm big into the design aspect so that was a big thing for me, I wanted it to look like I am reading an MLB.com page or something like that.

Standings
For the standings I have it set to automatically calculate winning percentage as well as games back(with a little help, of course). This is just a matter of plugging in wins and losses which is pretty cool and works very well.


Roster
For this page, I created a table for each of the MLB, AAA, AA & A teams. This is just an easy visual way to see who is on which team. I have it set to calculate how many players are on each team at the bottom, as an easy way to track that my rosters are set properly.


Transactions/Draft Picks
This is really basic, no formulas or anything, just a simple sheet to track trades & draft picks. Its really annoying a few years into a franchise to see where a player came from or judge trades a few years down the line as MLB The Show doesn't keep records


Contracts
This is by far my favorite and most complex sheet. I have an easy checkbox system for adding/subtracting players from the 40man roster, which calculates how many players are on it at the bottom. All contract values are calculated and Arb & Pre-Arb entries have a value assigned to them and factor into the total dollars committed at the bottom.

I also have a bar graph showing service time and ages and it also shows the average age of the team as well as average service time for the players. Lastly, I have a graph showing how much money is committed over the next few years. I play with budgets off to make it easier to manage the unsigned free agents at the start of spring training(which funnily enough, is happening in the real MLB haha). I do want to keep payroll somewhat realistic so this is an easy tool to track that


I plan on having another sheet for tracking awards, all star appearances, world series wins, etc... I am undecided if I want to track stats at well, as I want this to be a companion to franchise and not feel like work. I wont be tracking schedules or matchups or anything like that, just feels like too much work.

My main reason for this is to try and feel more immersed in franchise mode and not get bored quickly. If anyone has any suggestions for things to add, I know there are things I am missing but can't remember off the top of my head.

[ECUoak]

Well damn. I feel like I need to step my game up like y’all. But I’m terrible at creating spreadsheets so I’ll just keep jotting random things in my iPhone notes.


Sent from my iPhone using Operation Sports

[moTIGS]

That is beautiful.

I'm gonna have to steal that format for my own.

I've used spreadsheets to track various things in my franchise/dynasty modes for about 15 years (started as a college freshman when I got my first laptop and NCAA football 2015), but I've never used anything that looked that good.

Adding jersey numbers is something that's painfully obvious that I've overlooked. I recently got fed up with the game changing jersey numbers randomly throughout my franchise so went through and edited a bunch so there were no duplicates (seems to be the cause of random numbers). Don't know why I never thought to add it to my spreadsheets formally.

[xXInfectedXx]

@Hayman19 Those spreadsheets are amazing in every way.

[Bullit]

I am so old. I have literally dozens upon dozens of spiral notebooks from all of my years of playing video game baseball.

With The Show '18 I have used four 5 subject notebooks. I have never thrown away a single book in all of these years. They are all kept in a sealed plastic tub with every scorebook from every live game I have ever been to.

[Hayman19]

Quote: Originally Posted by moTIGS

That is beautiful. I'm gonna have to steal that format for my own. I've used spreadsheets to track various things in my franchise/dynasty modes for about 15 years (started as a college freshman when I got my first laptop and NCAA football 2015), but I've never used anything that looked that good. Adding jersey numbers is something that's painfully obvious that I've overlooked. I recently got fed up with the game changing jersey numbers randomly throughout my franchise so went through and edited a bunch so there were no duplicates (seems to be the cause of random numbers). Don't know why I never thought to add it to my spreadsheets formally.

Oh I forgot to add, it automatically highlights duplicate jersey numbers on a per team basis because of that exact issue you have.