|
Post by Chicago Cubs (Curtis) on Jan 21, 2018 19:53:43 GMT -8
I just completed an audit of each team's spreadsheet and encountered several issues in salary accounting. To this point I have allowed each owner to maintain control over his team's spreadsheet and would like to continue to do so, but chalk most of these issues up to poor spreadsheet management and not verifying the total salary formula towards the bottom of each sheet. The teams found in violation were: CLE (per previous trade, now addressed) COL NYM (nearly $20 million double-counted!) NYY SFG (now over cap, needs to be addressed)
In order to prevent these issues from reoccuring I am creating the following salary cap violation system (Constitution updated)
Section 5.4 Salary Cap Violations Teams found with a team salary greater than its salary cap shall be subject to the following punishments: 1st offense in a season: Warning 2nd offense in a season: Forfeiture of 2nd + 3rd rd AMAT draft picks 3rd offense in a season: Forfeiture of 1st rd AMAT draft pick 4th offense in a season: Owner expulsion from league
Teams exceeding its salary cap cannot participate in free agent bidding until a trade or waiving/DFA-ing a player puts the team back into compliance with the salary cap.
The Co-Commissioner of Accounting and Ownership will conduct routine salary cap audits. If violations are found they will be addressed without punishment, and the violating owner will be informed. However it is ultimately the responsibility of each owner to remain in compliance with the salary cap.
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Jan 21, 2018 20:07:16 GMT -8
Did you fix mine already? It looks the same as the last time I looked at it and seems to be correct.
|
|
|
Post by Chicago Cubs (Curtis) on Jan 21, 2018 20:18:36 GMT -8
Yep fixed: Burns, Kang, Gomez and Lawrie were all double-counted in your salary calculation
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Jan 21, 2018 20:28:52 GMT -8
Looks like it happened when I moved guys to paid minors. Not sure what I did, oh well
|
|
|
Post by Philadelphia Phillies (Paul) on Jan 21, 2018 20:36:17 GMT -8
I found an error in the calculation myself early on and fixed it - it was missing one cell out of the cell ranges needed to tally the correct total salary. It said I had more cap space than I thought. Now, I double-check those cells.
Sorry, long way of intro-ing that if you want to penalize cap errors (which, in principle, I'm in agreement with) I think you should lock down the calculation cells and let everyone know not to add any rows/columns that could alter the calculations.
|
|
|
Post by Chicago Cubs (Curtis) on Jan 21, 2018 20:59:46 GMT -8
I hadn't considered locking individual cells. I know you can do this in excel, but am unsure with Google sheets. I'll look into this option tomorrow
|
|
Deleted
Deleted Member
Posts: 0
|
Post by Deleted on Jan 22, 2018 12:03:51 GMT -8
The Nationals are thankful they have a licensed CPA on staff to avoid any payroll or reconciliation issues. (6+ years of schooling has finally paid off!)
|
|