Front Office Football Central  

Go Back   Front Office Football Central > Main Forums > Baseball Text-Based Sims
Register FAQ Members List Calendar Mark Forums Read Statistics

Thread Tools
Old 04-24-2010, 12:06 AM   #1
Young Drachma
Dark Cloud
Join Date: Apr 2001
Salary Cap Calculator Tool for OOTP

I'm releasing an experimental tool today for Excel called CAP'N SALARY CRUNCH. It's a pretty straightforward tool that's useful for solo leagues or online leagues and comes from a lot of studying I've done about player movement, salary disbursement and how arbitrary salary caps negatively affect gameplay.

I think that with the ascent of budget busting salaries in MLB, leagues try to do whatever they can to stem the tide of market inflation. Human owners though, will always spend no matter what and in a solo league, it's easy to create a depression where teams compete for the same small sector of top players, but hamper their payrolls so much that talent gets diluted across the league leaving you with a bunch of average teams rather than great ones, some good ones, average ones and ones that stink.

What this tool does, is take information from your league without factoring current team payrolls and comes up with a salary cap figure that takes into account how spending is done in your league, how much media revenue is available and how big team budgets are.

I've tested it using data from a variety of online leagues and it seems to do precisely what I hoped it would, which is produce a realistic and dynamic cap number that's reflective of active league spending.

How you use it is up to you, whether you adjust the cap number annually like the NFL, NBA and NHL do or whether you want to make it happen every few years. It's very easy to do and input though and shouldn't take you more than a few minutes, so it's not labor intensive.

The tool has room for five spaces built in, so you could use it for the same league over five years or five different ones and naturally can just copy the formulas in Excel if you want to create future ones or delete the figures once you've inputted them.

Some suggestions:

- If you want to control salary in your league, consider using a flat rate media contract for all teams (especially in a solo league) rather than having market sizes determine media money, since the game's methodology of this isn't realistic by any measure.

- Lowering player salary baselines in the league editor is always a surefire way to keep things in a place where you can tolerate it. If it's an online league though, this tool is essentially to ensuring your cap is fluid and reflective of how your league's owners are spending relative to the way your financial system works. It can handle any sort of variability and the calculations are based off studying the way real life teams spend and taking into account payroll percentages, average spending and the elements it takes to build a winning team in a competitive financial environment.

I do plan to add this tool to a newly update GMExcel 11 Suite, but I don't have an ETA on it right this second and I just thought this would be a nice way to whet the thistle.

This tool can be used in Microsoft Excel, Open Office or Google Docs too I believe. It's just an XLS file and is attached to this post.

As always, feel free to post questions or suggestions, comments and praise.
Attached Files
File Type: xls CAPNSALARYCRUNCH.xls (20.0 KB, 21 views)

Young Drachma is offline   Reply With Quote
Old 10-30-2014, 06:12 AM   #2
Join Date: Oct 2014
I'm convinced you'd have better luck searching the OOTP site and seeing if you can find one, because if there'd be pretty apparent fast. There might be, though I can't recall one offhand for that version, but only because it's been a while.
Cut down your exam HP0-Y32 braindumps by using our latest wikipedia and high quality California Institute of Technology gmat and VMWARE We provide updated exam sheets with 100% pass guarantee along with CHECKPOINT
Haider01 is offline   Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

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

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump

All times are GMT -5. The time now is 05:50 PM.

Powered by vBulletin Version 3.6.0
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.