View Single Post
Old 09-06-2018, 11:26 PM   #7
SN49ers
Rookie
 
OVR: 0
Join Date: Aug 2017
Re: Salary Cap Spreadsheet

Quote:
Originally Posted by Billy4NY
This looks like an awesome tool, but you need to layer in some details to help people make decisions. The best part about tracking salary information outside of the game is that it will help you make the choice of when to cut, trade, re-sign, release, or acquire other players.

See attached for my version of a CFM tracker tool. The manual labor is similar to yours as you will need to update this manually each time a transaction is made or at the start of each offseason, but the goal is the same. It shows you your projected cap space and also counts the number of players with expiring contracts for you. The other information I included like overall, age, and dev. trait will allow you to make smarter roster management decisions.

I also have a tab that helps you project the annual cap hit for new contracts so that you can test the waters before signing a player to a huge deal.

I hope you find this helpful.
Appreciate your feedback...And awesome work on the sheet. What i liked the most was the "Annual Cap Calculator" tab. I had a hard time trying to figured out how the progression of contracts signed at madden works. If its ok to you, i would like to use that on my sheet too.

I plan to put some additional information as a table with the rookie salarie scale. I would also like to add some columns for data like age, dev, ovrl, position and role of each player to provide some kind of feedback on their contractual situation (if you are overpaying some player, if you should consider cutting somebody ) and also on the salary situation of the team as a whole.
SN49ers is offline  
Reply With Quote