Managing Your Cap in Madden

[majesty95]

How do you guys manage your cap in Madden this year? I'm trying to decide if keeping Marcel Dareus with the Bills is worth it. He's asking for $11.5M per year. He's a beast and I want to keep him, I'm just not sure I can afford him without sacrificing somewhere else. Anyone have any good ideas on solving these kinds of issues?

 

[majesty95]

I started playing around with an Excel workbook as I need to figure out my finances for both teams. What I have now allows you to put in salaries for all of your players and then it will total your salary each year by Offense, Defense and Total. It also shows your percentage of salary used for Offense and Defense so you can track that as you go. Additionally, it shows the projected cap amount, percent used and remaining available cap room. It is no masterpiece by any means but maybe it will help out some of you. If you are better with Excel than me and want to improve upon it and share it, feel free.

Here is a screenshot of the spreadsheet using my Vikings team: