Salary Cap Spreadsheet
Hey guys, inspired by people like Old Man Nathy, who produce great content here, I decided to share this little project i made and used in Madden 17 and 18 and helped me manage salaries in CFM.
There is nothing extraordinary in this spreadsheet but it gives a pretty accurate idea of how much cap space we will have next season. It is possible to simulate cuts /trades and check how your salary situation will be in the current season and next season in these cases.
I think this kind of information is useful because when our roster gets better it also gets more expensive and we have to make some important decisions (if you want to keep a realistic approach), especially in online leagues since all assets matter and we have more competition in FA. And with this progression/regression system that allows players to continue at a high level for longer we're going to have to make a little more difficult decisions.
HOW IT WORKS?
Current Season spreadsheet: Put the name, contract time (remaining), cap hit, savings and penalty of each player in the respective columns. Also put the salary cap and the previous penalties. In the "CUT / Traded" column, enter "YES" if it is cut /traded or "NO" if not.
Next Season Spreadsheet: Just put the cap hit of each player next season in the "Cap Hit" column. Put also the previous penaltys. You can also put an estimate of how much future rookies will cost (Rookie Reserve).
NOTES:
You must refill the spreadsheet in each preseason.
In the offseason, the NEXT SEASON spreadsheet will show you how much cap space you have.
In the offseason, you will get the real information of your rookie reserve
You can update the contract information for each player on your roster, as well enter new players that you sign or trade for.
DO NOT REMOVE PLAYERS THAT YOU CUT OR TRADED
You do not need to update penalties when cutting a player. Just update this information in preseason when you redo the spreadsheet.
There is nothing extraordinary in this spreadsheet but it gives a pretty accurate idea of how much cap space we will have next season. It is possible to simulate cuts /trades and check how your salary situation will be in the current season and next season in these cases.
I think this kind of information is useful because when our roster gets better it also gets more expensive and we have to make some important decisions (if you want to keep a realistic approach), especially in online leagues since all assets matter and we have more competition in FA. And with this progression/regression system that allows players to continue at a high level for longer we're going to have to make a little more difficult decisions.
HOW IT WORKS?
Current Season spreadsheet: Put the name, contract time (remaining), cap hit, savings and penalty of each player in the respective columns. Also put the salary cap and the previous penalties. In the "CUT / Traded" column, enter "YES" if it is cut /traded or "NO" if not.
Next Season Spreadsheet: Just put the cap hit of each player next season in the "Cap Hit" column. Put also the previous penaltys. You can also put an estimate of how much future rookies will cost (Rookie Reserve).
NOTES:
You must refill the spreadsheet in each preseason.
In the offseason, the NEXT SEASON spreadsheet will show you how much cap space you have.
In the offseason, you will get the real information of your rookie reserve
You can update the contract information for each player on your roster, as well enter new players that you sign or trade for.
DO NOT REMOVE PLAYERS THAT YOU CUT OR TRADED
You do not need to update penalties when cutting a player. Just update this information in preseason when you redo the spreadsheet.
Comment