View Single Post
Old 11-01-2024, 12:22 AM   #1
darkcloud4579
Hall Of Famer
 
Join Date: Jun 2003
Posts: 8,660
MarketCalc 24: CBT & Revenue Sharing Sheet

I made two new tabs in my MarketCalc update, but since most of you newbies don't remember this very old tool, I decided to just make a new thread to talk about the latest feature add.

You can use this tool to track deferrals, if you decide to play with them.

Ever wanted a more realistic way to handle competitive balance in your OOTP league? I've created a spreadsheet tool that helps implement both a Competitive Balance Tax system and revenue sharing for smaller markets.
The CBT calculator uses dynamic tiers that you can adjust based on your league's economy, rather than hard-coded MLB numbers. This lets you maintain competitive balance without being locked into real-world figures that might not fit your league's financial structure.

The small market distribution system ensures that teams aren't rewarded for tanking, while providing support to genuinely competitive small market clubs. It takes into account market size rankings (1-36) and uses performance metrics to determine revenue sharing. My league has 36 teams, but even if you're just using normal 30 team MLB, this will work.

This tool is part of my larger league financial tracking system, but these two components have been isolated and simplified for easy implementation in any OOTP league setup. There are far more complicated ways to iterate on this, I tried to keep it relatively lightweight and pretty easy to maintain year to year. It'll only work for you folks in Commissioner mode, but the formulas are tweakable.

Here's the Google sheet version that you can clone or export

Want to make your league's finances more realistic while maintaining competitive balance? Give it a try!
Attached Files
File Type: xlsx GMExcel24(1).xlsx (203.3 KB, 208 views)

Last edited by darkcloud4579; 11-01-2024 at 01:14 AM.
darkcloud4579 is offline   Reply With Quote