DANCRYST
New Member
- Messages
- 29
- Reaction score
- 0
I was looking at the cap last night and came across this spreadsheet. http://www.ianwhetstone.com/football/cap.html
I took the spreadsheet and expanded on his numbers. The calculations show that almost everyone on the team is cap neutral (which means whether they are on the team or not they will cost about the same)
The only players that would save large money are guys we want to keep i.e romo, witten, ware, etc.
Newman will save 4 million.
The only two that will be a larger cap hit are Roy and Columbo. Together they would raise the cap around 7.5 million if cut compared to both being on the roster.
Barber would be a small savings if cut around 750,000.
I will post the spreadsheet later since I cant open it at work as it was done in a newer version of excel.
If someone wants to redo the calculations and repost then they can do this. (please double check me)
1. I cleaned the list to just players under contract.
2. I filled in the SB (signing bonus column).
SB = 2011 Cap - 2011 Salary (repeated for all years) then totaled the remaining years for bonus remaining.
Some with roster bonuses like barber would save a little more if cut.
3. I then took all the signing bonus columns remaining and added them up.
i.e Roy Williams 3.9+3.9+3.9 = 11.7 remaining signing bonus
4. I then took the Signing bonus total minus 2011 Cap to figure a difference in Cap cost on roster vs Cap cost cut (remaining bonus)
i.e Roy Williams = (3.9*3) - 9.010 = 2.69 million extra to cut him.
Columbo came in at around 4.57 million extra to cut.
i.e. Newman = (2*3) - 10.00 = -4.00 or 4 million savings.
5. Again the majority of the roster came out neutral. Most would only save/cost only a couple hundred thousand if cut or are ones we don't want to cut.
I took the spreadsheet and expanded on his numbers. The calculations show that almost everyone on the team is cap neutral (which means whether they are on the team or not they will cost about the same)
The only players that would save large money are guys we want to keep i.e romo, witten, ware, etc.
Newman will save 4 million.
The only two that will be a larger cap hit are Roy and Columbo. Together they would raise the cap around 7.5 million if cut compared to both being on the roster.
Barber would be a small savings if cut around 750,000.
I will post the spreadsheet later since I cant open it at work as it was done in a newer version of excel.
If someone wants to redo the calculations and repost then they can do this. (please double check me)
1. I cleaned the list to just players under contract.
2. I filled in the SB (signing bonus column).
SB = 2011 Cap - 2011 Salary (repeated for all years) then totaled the remaining years for bonus remaining.
Some with roster bonuses like barber would save a little more if cut.
3. I then took all the signing bonus columns remaining and added them up.
i.e Roy Williams 3.9+3.9+3.9 = 11.7 remaining signing bonus
4. I then took the Signing bonus total minus 2011 Cap to figure a difference in Cap cost on roster vs Cap cost cut (remaining bonus)
i.e Roy Williams = (3.9*3) - 9.010 = 2.69 million extra to cut him.
Columbo came in at around 4.57 million extra to cut.
i.e. Newman = (2*3) - 10.00 = -4.00 or 4 million savings.
5. Again the majority of the roster came out neutral. Most would only save/cost only a couple hundred thousand if cut or are ones we don't want to cut.
