JWDixon's All-Inclusive Franchise Spreadsheet

[JWDixon120]

Back with another revamped and better version of my Franchise Sheet! This sheet will only be available on Excel, as some formulas and data was easier to use with it. I apologize for any inconvenience.

Also PLEASE watch the YT Video I have linked that acts as the README for this file. It is time-stamped in the description if you ever need to reference it again.

Here are the features:

• Team Summary Page
• Top Prospect Tracker
• Roster Tracker
• Team and League Transaction Tracker
• Draft Pick Tracker
• NEW REVAMPED Trade Value Calculator
• NEW International Free Agent Generator
• NEW Franchise Storyline and Event Generators (Idea from 2k's ATD Roster guru''s)
• Player Stat Tracker (Counting Stats, OPS, wOBA,BABIP, OPS+, ERA-, Custom Park Factors etc.
• NEW custom WAR formula and Custom Stat!
• Player Season Summary's
• Notable Game Tracker
• MiLB Season Summary Tracker
• ASG Selection Tracker
• Standings
• NEW Monthly Power Rankings!
• Playoff Stat Tracker
• Playoff Result Tracker
• Season Awards Tracker
• NEW Realistic MVP/CYA Voting!
• Hall Of Fame Tracker
• Team Logos
• Contract Demand Calculator

Currently, the spreadsheet has a few lines on each sheet filled out to give a rough template of how it should look.

Here is a breakdown of how to use each of the features:

TRANSACTIONS:

• Track every move made by your team or league
• Spaces for notes are allowed to jot down why a move was made
• Team Logos sheet can be used to copy and paste into this sheet under "Former Team"
• Track each draft pick your team makes including their Scouting Report and MLB Comparison (Use your imagination)

TRADE VALUE CALCULATOR

• Enter a players Previous 3 years WAR, Games Played, and Contract Info and a Trade Value is spit back out.
• Use this to compare when making trades between MLB Players
• Also use the Prospect Value sheet to reference when trades involving Farmhands.
• This calculation is based on the MLB The Show 20 Trade Discussion Thread

IFA Generator

• Vanilla MLB The Show has never included International Free Agents even though they are seen everywhere in today's game.
• Use this tool during the offseason to generate up to 3 IFA's
• This Tool has the chance to generate superstar players at ages 18-20 although superstar players are very rare to generate.
• Most players will be in the 60's for Overall and 70's for Potential
• If you think a player Generated is simply "Too OP" then by all means do not put them into the game.
• Use the Read Me within this sheet in the workbook to Learn More

STORYLINE/EVENT GENERATORS

• Unfortunately, MLBTS can have a severe lack of storylines without a great imagination from the User
• This tool intends on helping that aspect of your Franchise
• Event Generators should be used as specifically noted for certain times throughout your Franchise
• Always remember if you do not like a certain event, you do not have to use it
• Please suggest more events to be added into the sheet!

PLAYER STATS

• User should follow the read me on this sheet as well
• User should enter mainly just counting stats as all other stats are automatically calculated

I really hope you guys enjoy. Please let me know if you have any suggestions!


Link to Sheets File:

https://docs.google.com/spreadsheets...it?usp=sharing

Link for YouTube README:
https://youtu.be/75C7DmZtrZo

[bryanm1982]

This is awesome. I love the scenarios that you can generate. Thanks for sharing this.

[JWDixon120]

Quote: Originally Posted by bryanm1982

This is awesome. I love the scenarios that you can generate. Thanks for sharing this.

I hope you enjoy!

[Jeffrey Smith]

I’ve never used a spreadsheet in any of my franchises in all the years I’ve played.

How much of a time investment is needed to update after games?


Sent from my iPhone using Tapatalk

[JWDixon120]

Quote: Originally Posted by Jeffrey Smith

I’ve never used a spreadsheet in any of my franchises in all the years I’ve played. How much of a time investment is needed to update after games? Sent from my iPhone using Tapatalk

Personally in my opinion it’s not much at all.

I only input player stats usually at the end of every month. That one is the most time consuming and takes about 20 minutes. Everything else can be done in about 5-10 minutes after a game is over depending on what you want to enter!

[Jeffrey Smith]

Quote: Originally Posted by JWDixon120

Personally in my opinion it’s not much at all. I only input player stats usually at the end of every month. That one is the most time consuming and takes about 20 minutes. Everything else can be done in about 5-10 minutes after a game is over depending on what you want to enter!

Sounds great. I may attempt to try these out in 23’. Like someone else posted, the scenarios look awesome.

Great idea!


Sent from my iPhone using Tapatalk

[JWDixon120]

Quote: Originally Posted by Jeffrey Smith

Sounds great. I may attempt to try these out in 23’. Like someone else posted, the scenarios look awesome. Great idea! Sent from my iPhone using Tapatalk

Thanks! I hope you enjoy it.

[bryanm1982]

Question on the scenarios. Do you start by selecting 0 for the scenario first or by the team on the top left?