Home

JWDixon's All-Inclusive Franchise Spreadsheet

This is a discussion on JWDixon's All-Inclusive Franchise Spreadsheet within the MLB The Show forums.

Go Back   Operation Sports Forums > Baseball > MLB The Show
Why Player Ratings Change When Starting Dynasty Mode in College Football 25
What Is Pro Yakyuu Spirits 2024/Professional Baseball Spirits 2024, and How Do You Get It?
The House Rules Hub for Recruiting in College Football 25 Dynasty Mode
Reply
 
Thread Tools
Old 12-31-2022, 01:44 AM   #1
Rookie
 
JWDixon120's Arena
 
OVR: 0
Join Date: Jul 2012
Posts: 628
JWDixon's All-Inclusive Franchise Spreadsheet

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

Last edited by JWDixon120; 04-25-2024 at 04:55 PM.
JWDixon120 is offline  
Reply With Quote
Advertisements - Register to remove
Old 12-31-2022, 02:20 AM   #2
MVP
 
bryanm1982's Arena
 
OVR: 0
Join Date: Nov 2016
Re: JWDixon's All Inclusive Franchise Spreadsheet

This is awesome. I love the scenarios that you can generate. Thanks for sharing this.
__________________
Follow me on Twitch

https://twitch.tv/bryanm1982

Dodgers Franchise

https://docs.google.com/spreadsheets...it?usp=sharing
bryanm1982 is offline  
Reply With Quote
Old 12-31-2022, 02:31 PM   #3
Rookie
 
JWDixon120's Arena
 
OVR: 0
Join Date: Jul 2012
Posts: 628
Re: JWDixon's All Inclusive Franchise Spreadsheet

Quote:
Originally Posted by bryanm1982
This is awesome. I love the scenarios that you can generate. Thanks for sharing this.

I hope you enjoy!
JWDixon120 is offline  
Reply With Quote
Old 12-31-2022, 02:39 PM   #4
MVP
 
Jeffrey Smith's Arena
 
OVR: 0
Join Date: Apr 2014
Location: Canada
Re: JWDixon's All Inclusive Franchise Spreadsheet

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
__________________
MLB: TORONTO BLUE JAYS
NFL: MINNESOTA VIKINGS
NHL: TORONTO MAPLE LEAFS
NBA: TORONTO RAPTORS
Jeffrey Smith is offline  
Reply With Quote
Old 12-31-2022, 02:40 PM   #5
Rookie
 
JWDixon120's Arena
 
OVR: 0
Join Date: Jul 2012
Posts: 628
Re: JWDixon's All Inclusive Franchise Spreadsheet

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!
JWDixon120 is offline  
Reply With Quote
Advertisements - Register to remove
Old 12-31-2022, 02:44 PM   #6
MVP
 
Jeffrey Smith's Arena
 
OVR: 0
Join Date: Apr 2014
Location: Canada
Re: JWDixon's All Inclusive Franchise Spreadsheet

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
__________________
MLB: TORONTO BLUE JAYS
NFL: MINNESOTA VIKINGS
NHL: TORONTO MAPLE LEAFS
NBA: TORONTO RAPTORS
Jeffrey Smith is offline  
Reply With Quote
Old 12-31-2022, 02:45 PM   #7
Rookie
 
JWDixon120's Arena
 
OVR: 0
Join Date: Jul 2012
Posts: 628
Re: JWDixon's All Inclusive Franchise Spreadsheet

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.
JWDixon120 is offline  
Reply With Quote
Old 12-31-2022, 03:17 PM   #8
MVP
 
bryanm1982's Arena
 
OVR: 0
Join Date: Nov 2016
Re: JWDixon's All Inclusive Franchise Spreadsheet

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

https://twitch.tv/bryanm1982

Dodgers Franchise

https://docs.google.com/spreadsheets...it?usp=sharing
bryanm1982 is offline  
Reply With Quote
Reply


« Previous Thread | Next Thread »

« Operation Sports Forums > Baseball > MLB The Show »



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 02:22 PM.
Top -