Template for (soon to be obsolete) roster designs of 2014

[Deus Irae]

I thought I'd break it down, in order to allow anyone else who wants to design the roster to have the basics. Starting baseline template:

Brady - 14.8m
Mallett - 937,945
QB total: 15,737,945

Ridley - 939,750
Vereen - 1,101,275
Bolden - 574,582
Gray - 420,000
McGuffie - 420,000
Develin - 575,000
RB total: 4,025,942

Gronk - 5,400,000
Williams - 645,000
TE total: 6,045,000

Solder - 2,717,429
Mankins - 10,500,000
Cannon - 743,968
Vollmer - 3,750,000
Cave - 420,000
Devey - 420,000
Mattes - 420,000
Kline - 495,000
Barker - 495,000
Schwab - 495,000
Zusevics - 499,334
Connolly - 4,083,334
OL total: 25,039,065 (differs from Miguel by 272,500)

Amendola - 4,575,000
Dobson - 779,175
Boyce - 614,250
Thompkins - 495,833
Moe - 422,666
Harrison - 496,000
Dunn - 420,000
Orton - 420,000
Slater - 2,226,668
WR total: 10,449,592 (differs from Miguel by 1,806,668)

Offense total: 61,297,544 (Differs from Jason by 39,665, Miguel had no O/D breakdown)

Wilfork - 11,600,000
Sopoaga - 3,500,000
Ninkovich - 2,850,000 (Miguel has 2,600,000, likely because he's not adding roster bonus)
Kelly - 2,656,250
Cha. Jones - 2,229,136
Forston - 570,000
Bequette - 709,950
Buchanan - 508,403
Armstead - 495,000
Chr. Jones - 495,000
Vellano - 495,000
Grissom - 421,333
Siliga - 570,000
DL total: 27,100,072 (differs from Miguel by 250,000, likely from Ninkovich roster bonus)

Mayo - 7,287,500
Hightower - 2,106,546
White - 645,000
Collins - 854,773
Beauharnais - 506,898
Reed - 420,000
Davis - 420,000
LB total: 12,240,717 (differs from Miguel by 645,000, Chris White's salary?)

McCourty - 5,115,000
Gregory - 3,683,334
Arrington - 3,625,000
T. Wilson - 1,150,335
A. Wilson - 1,833,333
Ryan - 655,813
Harmon - 633,900
Ebner - 594,150
Dennard - 584,462
Davis - 495,000
Green - 495,000
DB total: 18,865,327 (differs from Miguel by 594,150, Ebner's salary?)

Defense total: 58,206,116 (identical to Jason's numbers)

Gostkowski - 3,800,000
Allen - 495,500
ST total: 4,295,500 (differs from Miguel by 3,505,818)

Team total: 123,799,160 (Jason has 123,838,825)
Dead money: 8,533,721
Carryover: 5,607,914

Total cap outlay: 126,724,967 (NFLPA has 125,631,543, some or all of that possibly because of roster bonuses not being tabbed)


If anyone notices errors I've made, please let me know and I'll make any needed adjustments as long as the system allows me to.

 

[Danger Zone]

Brady - 14.8m

Such respect for this.

 

[Miguel]

My totals match those at
Inside Slant: 'Dead money' totals - NFL Nation Blog - ESPN

so may I suggest using my numbers

Arrington, Kyle CB 3625000 Defense
Ryan, Logan CB 655813 Defense
Dennard, Alfonzo CB 584462 Defense
Green, Justin CB 495000 Defense
Ninkovich, Rob DE 2600000 Defense
Jones, Chandler DE 2229136 Defense
Bequette, Jake DE 709950 Defense
Buchanan, Michael DE 508403 Defense
Wilfork, Vince DT 11600000 Defense
Sopoaga, Isaac DT 3500000 Defense
Kelly, Tommy DT 2656250 Defense
Siliga, Sealver DT 570000 Defense
Grissom, Cory DT 496333 Defense
Armstead, Armond DT 495000 Defense
Forston, Marcus DT 495000 Defense
Jones, Chris DT 495000 Defense
Vellano, Joe DT 495000 Defense
Mayo, Jerod LB 7287500 Defense
Hightower, Dont'a LB 2106546 Defense
Collins, Jamie LB 854773 Defense
Beauharnais, Steve LB 506898 Defense
Davis, Ja'Gared LB 420000 Defense
Reed, Taylor LB 420000 Defense
McCourty, Devin S 5115000 Defense
Gregory, Steve S 3683334 Defense
Wilson, Adrian S 1833333 Defense
Wilson, Tavon S 1150335 Defense
Harmon, Duron S 633900 Defense
Davis, Kanorris S 495000 Defense
Mankins, Logan IOL 10500000 Offense
Connolly, Dan IOL 4083334 Offense
Barker, Chris IOL 495000 Offense
Cave, Braxston IOL 420000 Offense
Kline, Josh IOL 420000 Offense
Vollmer, Sebastian OT 3750000 Offense
Solder, Nate OT 2717429 Offense
Cannon, Marcus OT 743968 Offense
Zusevics, Markus OT 499334 Offense
Fisher, Elvis OT 422500 Offense
Devey, Jordan OT 420000 Offense
Mattes, R.J. OT 420000 Offense
Schwab, Brice OT 420000 Offense
Brady, Tom QB 14800000 Offense
Mallett, Ryan QB 937945 Offense
Vereen, Shane RB 1101275 Offense
Ridley, Stevan RB 939750 Offense
Bolden, Brandon RB 574584 Offense
Develin, James RB 570000 Offense
Hines, Quentin RB 420333 Offense
Gray, Jonas RB 420000 Offense
Gronkowski, Rob TE 5400000 Offense
Williams, D.J TE 645000 Offense
Amendola, Danny WR 4575000 Offense
Dobson, Aaron WR 779175 Offense
Boyce, Josh WR 614250 Offense
Harrison, Mark WR 496000 Offense
Thompkins, Kenbrell WR 495833 Offense
Moe, T.J. WR 422666 Offense
Dunn, Reggie WR 420000 Offense
McGuffie, Sam WR 420000 Offense
Orton, Greg WR 420000 Offense
White, Chris ST 645000 Special Teams
Ebner, Nate ST 594150 Special Teams
Gostkowski, Stephen ST 3800000 Special Teams
Allen, Ryan ST 495500 Special Teams
Slater, Matt ST 2266668 Special Teams

 

[Deus Irae]

My totals match those at
Inside Slant: 'Dead money' totals - NFL Nation Blog - ESPN

so may I suggest using my numbers

I love your work, and I certainly acknowledge the efforts, but I had to make a decision based on utuility v. 100% contract data application. In the end, I went with the higher cap outlay in order to be safe, because I took currently unearned bonuses (i.e. Nink's) into account. As a result, I used a lot of your stuff and blended it with Jason's and the NFLPA, which allowed for a fair amount of double checking. I'm within about $1m of the current NFLPA number while adding those bonuses (1,093,424), so I'm feeling fairly comfortable with my overall approach, although I'd love to correct specific errors if they can be found.


Of note, in direct response to your post, I have the same dead money total that you have ($8,533,721).

 

[Miguel]

Totals if one includes Ebner, Chris White, and Matt Slater in the Special Teams grouping

Defense 56791966
Offense 59763376
Special Teams 7801318

Totals if one does not include Ebner, Chris White, and Matt Slater in the Special Teams grouping
Defense 58031116
Offense 62030044
Special Teams 4295500

 

[Miguel]

I love your work, and I certainly acknowledge the efforts, but I had to make a decision based on utuility v. 100% contract data application. In the end, I went with the higher cap outlay in order to be safe, because I took currently unearned bonuses (i.e. Nink's) into account. As a result, I used a lot of your stuff and blended it with Jason's and the NFLPA. I'm within about $1m of the current NFLPA number while adding those bonuses, so I'm feeling comfortable with my overall approach, although I'd love to correct specific errors if they can be found.


Of note, in direct response to your post, I have the same dead money total that you have ($8,533,721).

I also match the cap total of $117,981,660

 

[Miguel]

Wilfork - 11,600,000
Sopoaga - 3,500,000
Ninkovich - 2,850,000 (Miguel has 2,600,000, likely because he's not adding roster bonus)

Which positions take up most cap space? - New England Patriots Blog - ESPN Boston

I adjusted my number for Ninkovich because it appears that his 250K playing time incentive is not yet counting against the cap.

 

[Deus Irae]

Totals if one includes Ebner, Chris White, and Matt Slater in the Special Teams grouping

Defense 56791966
Offense 59763376
Special Teams 7801318

Totals if one does not include Ebner, Chris White, and Matt Slater in the Special Teams grouping
Defense 58031116
Offense 62030044
Special Teams 4295500

So we match up there, since I had Slater as a WR, White as a LB and Ebner as a safety. That also evens us up at LB and DB. We remain unreconciled at WR, OL and DL (DL seems to be just a matter of Nink's bonus).

 

[Deus Irae]

I also match the cap total of $117,981,660

Which positions take up most cap space? - New England Patriots Blog - ESPN Boston

I adjusted my number for Ninkovich because it appears that his 250K playing time incentive is not yet counting against the cap.

Yeah, this is where I chose to go different, in order to avoid people posting something like "I thought that signing would work, so why am I short?".

I'm still trying to find out the sources of the differences at WR and OL. I'm sure the mistakes are mine but, since they led to higher cap numbers, I kept them out of a sense of erring conservatively for the purpose of the exercise.

 

[BlueThunder]

My figures came within a dollar of Miguel's, but it's probably a rounding error

 

[ausbacker]

Get off your lazy asses and build me a proper template to play around with...

 

[DocHoliday]

Totally selfish plug of my excel spreadsheet

http://www.patsfans.com/new-england-patriots/messageboard/showthread.php?t=1011051

Make sure you use the one in the last post!