MLB The Show Franchise companion (spreadsheets)

[japowery]

I've spent years lurking this and other forums, trying to find companion spreadsheets that I could use with my franchises in the Show. After never finding quite what I was looking for, I decided to bite the bullet and commit to making my own sheets. 300+ hours of research and tinkering later, and I've finally made the franchise spreadsheet that I've always wanted.

Gallery


Features:

• Accurate Wins Above Replacement models (for pitching, defense, offense, and baserunning)
• Complete, 30-team Playoff Odds
• Actual Win Probability (depending on the inning and score) and Implied Win -
• Probability (depending on your offensive, pitching, and defensive statistics up to that point)
• Automatic algorithm to determine performance awards for users (MVP, Cy Young, Gold Glove, etc.)
• Exit Velocity tracker (calculating Hard hit ball%, Soft hit ball %, and expected wOBA)
• Automatic Run Differential and Win Differential tracking (line charts)
• Automatic Streak and "Last 10" calculators
• Game Crown (Player of the Game) algorithm; Determines which user had the best game (when multiple users play same game)
• Full 162 game projections. Byproduct of current play (expected win% dependent on your WAR), current RS/RA ratio (Pythagorean win%), and current record
• Fully comprehensive WAR and metrics for individual players, including positional adjustments
• Miscellaneous metrics: Strength of Schedule, Runs Created, "Clutch"-ness, wRC+, Defensive Runs Saved (DRS), Win Shares
• Works in both Microsoft Excel and Google Sheets
• I'm making these spreadsheets available under a Pay What You Want model. Send as little as $0 to my PayPal ([email protected]) and leave a note that includes your email. I'll reply to you with the spreadsheets attached within 12 hours. If you're feeling more generous, I would be most grateful!

Here's to a great season!

[DoTheSankeyLeg]

This is so cool. I can't believe the depth this thing has.

[xNobleEaglex]

A lot of great advanced analytics tracked in here. I know for certain that I'll be incorporating at LEAST your oWAR and pWAR formulas into my franchise tracking spreadsheets. Well done

[Councilmann_Jamm]

Well this looks amazing

[MetsFan16]

Question for those who track these elaborate spreadsheets.

How do you input the data into each? Do you take time after every game and input the box score?


Sent from my iPhone using Operation Sports

[ty5oke]

This looks awesome. I'm also interested in the amount of work to keep inputting into this. I would love to use something like this but scared I won't have the time/patience to keep it up.

[markprior22]

Quote: Originally Posted by MetsFan16

Question for those who track these elaborate spreadsheets. How do you input the data into each? Do you take time after every game and input the box score? Sent from my iPhone using Operation Sports

I'm curious about this also

[TheBleedingRed21]

He inputs them after every game. No other way to do it currently.