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