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]

Re: Do you use spreadsheets to track your franchise/players?

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]

Re: Do you use spreadsheets to track your franchise/players?

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]

Re: Do you use spreadsheets to track your franchise/players?

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]

Re: Do you use spreadsheets to track your franchise/players?

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.

[Bullit]

Re: Do you use spreadsheets to track your franchise/players?

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]

Re: Do you use spreadsheets to track your franchise/players?

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.

[SoxSoxSox]

Re: Do you use spreadsheets to track your franchise/players?

This is beautiful.

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.

[LukePurcy]

Re: Do you use spreadsheets to track your franchise/players?

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.

I've attempted to do something like this but mine wasn't as nice looking or in depth as what you did. This is amazing . Would you be willing to share this if you are done with it/when it's a finished product?

[coach422001]

Re: Do you use spreadsheets to track your franchise/players?

I started spreadsheeting (hey I made up a word!) when I realized that teams would draft players, and since they'd sign one year deals and were low overalls, I may cut them the following season. I'm on 17 so I don't know if that has changed in 18 or will change in 19, but I've had to:
1. type out each team's draft pick's fictional names and positions (plus the year and round)
2. in the off season when they are now editable on the roster, change names to actual names (and change their features to something reasonable to match real life)
3. Track these from year to year so that I don't mistakenly cut the number 2 pick 2 years in.

I've also now begun tracking the league leaders, award winners, WS team winners (I make up the WS MVP based on performance not what the game tells me). Unfortunately work/wife keeps me from spending the kind of time to make spreadsheets like we see above. The nice thing about excel is once you get a template for calculations or contracts or positions you just need to copy that page 29 more times (don't have to build from scratch) to be able to populate anything on a per team basis. The bad thing is that I just don't have that kind of time anymore.

[Hayman19]

Re: Do you use spreadsheets to track your franchise/players?

I've attempted to do something like this but mine wasn't as nice looking or in depth as what you did. This is amazing . Would you be willing to share this if you are done with it/when it's a finished product?

Once I am finished I probably will upload and share it. Maybe if it isn't too much trouble I can make a blank version so people can edit it to their favorite teams.

I probably won't finish until MLB 19 comes out as I want to browse the menus and see if there is anything else I want to include.

Thanks for all the nice comments, it's been slow at work recently so 90% has been done at work and me having a graphic design background, I usually cannot stand how most spreadsheets look. There are some challenges to making it look half decent however.

[millertime98]

Re: Do you use spreadsheets to track your franchise/players?

I have used the Dynasty page on here, dynastynationnetwork.com , Bloggr, WordPress, etc. Never Spreadsheets. Perhaps I should start.

[johnjimmy]

Re: Do you use spreadsheets to track your franchise/players?

i have started using a spreadsheet for my rtts player to track his stats, advanced stats, whenever i led the league in anything, where my team finishes and the world series winners

[LegendKillerOne]

Re: Do you use spreadsheets to track your franchise/players?

Once I am finished I probably will upload and share it. Maybe if it isn't too much trouble I can make a blank version so people can edit it to their favorite teams.

I probably won't finish until MLB 19 comes out as I want to browse the menus and see if there is anything else I want to include.

Thanks for all the nice comments, it's been slow at work recently so 90% has been done at work and me having a graphic design background, I usually cannot stand how most spreadsheets look. There are some challenges to making it look half decent however.

I gotta ask I use a spreadsheet for my league as I use 30 team control and its too much to keep track of without a spreadsheet. What can I do to get you to share that? Its so much nicer. Even if its blank and I fill it in

[KBLover]

Re: Do you use spreadsheets to track your franchise/players?

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.

I mostly track team stats for/against me. I use Nomo17k's spreadsheet with modifications to add a few more analytic stats to the ones he tracks on his original document.

For players, I don't track too much - I'm looking more for team trends then look at individuals in relation to that. For example, if a hitter is batting .236 and I calc his BABIP by hand to be .279 - both of those are low. However, if the team is batting .260 with a .283 BABIP, it might not be (and probably isn't) just him. He's getting "unlucky" maybe with base hits, or he's K'ing too much, but something is up (i.e. I'm doing something wrong. The league as a whole is pitching oriented, etc).