Franchise Spreadsheet Template with Tons of Features!

[JWDixon120]

I found a template a few years back on Reddit I believe and have added bits and pieces to it ever since (I have no clue who originally created the base template but if you're around please let me know!). The file below can be downloaded from Google Drive and edited to your liking.

As you'll notice, Data for 2 years is filled in already to give you an idea on how to fill out each field.

Highlights of this Spreadsheet:

Spoiler

• Player Stat Tracking including OPS+,ERA+,ISO,BABIP, etc.
• Furthest HR's Tracker
• Notable Game Sheet
• Transaction Tracker
• Drafted Player sheet with scouting report section (User input)
• Standings with Games Back Formula
• Historical Stat Tracking
• International Free Agent Tracker (User Input)
• Season Notes Tracker
• MiLB Season Notes Tracker
• All Star Game Selection Tracker
• Player Award Tracker (User can choose winners which is much better than default SDS selections)
• Tons more. I plan on adding a tracker to track User hitter's Average Exit Velo's and monthly stat tracker since these can't be accessed in Franhise.

For Player stats, if you need more years, just copy and paste and rinse and repeat. For OPS+/ERA+, I use the league average OPS/ERA from 2021. You can adjust this in the formula based on your MLB The Show Franchise's league average OPS/ERA.

In the Transactions tab, the "Former Team" pictures are found with a simple google search with "PNG" attached. Then copy and pasted/resized to fit within the column.

If you have any questions let me know! I love keeping spreadsheets for my games and this is my favorite one by far.

https://docs.google.com/spreadsheets...f=true&sd=true

[BertmanT5]

I think this is exactly what I'm looking for! Simple yet still holds a plethora of info. I keep a spreadsheet tracking an NCAA Dynasty and have been wanting to do the same for the show. Appreciate you sharing!

Sent from my Pixel 5 using Tapatalk

[JWDixon120]

Quote: Originally Posted by BertmanT5

I think this is exactly what I'm looking for! Simple yet still holds a plethora of info. I keep a spreadsheet tracking an NCAA Dynasty and have been wanting to do the same for the show. Appreciate you sharing! Sent from my Pixel 5 using Tapatalk

Hope you enjoy! If you have any questions let me know!

[mpklub]

This is awesome. Thanks for sharing!

[bryanm1982]

This is awesome. Thanks for sharing. I added this with my boxscores that I do every game. So the numbers transfer right to the stats page.

[JWDixon120]

Quote: Originally Posted by bryanm1982

This is awesome. Thanks for sharing. I added this with my boxscores that I do every game. So the numbers transfer right to the stats page.

Ooooh smart. I definitely should add in a box score tracker that automatically fills player stats.

[jbooth2367]

This is awesome man, good work. I want to use this as a companion to track and write stuff about my career modes in sports games. Does anybody know if Proboards is the best website to do that? Just looking for something where I can post data from these spreadsheets and write little articles and such. Essentially my own mlb . com for my franchise.

[JWDixon120]

Quote: Originally Posted by jbooth2367

This is awesome man, good work. I want to use this as a companion to track and write stuff about my career modes in sports games. Does anybody know if Proboards is the best website to do that? Just looking for something where I can post data from these spreadsheets and write little articles and such. Essentially my own mlb . com for my franchise.

I’ve never heard of ProBoards but you can give it a shot! If you need anything let me know and I can try to help!