SELECT team_id, IFNULL((SELECT (SELECT SalaryCap FROM yearlycaps WHERE Year=2015)+Carryover+Adjustments+WebAdjustments FROM `teamcaps` AS d WHERE d.team_id=1 AND d.Year=2015),(SELECT SalaryCap FROM yearlycaps WHERE Year=2015)) AS TotalCap, bb.Year AS Year, SUM(bb.CP) AS Top51, IFNULL((SELECT SUM(Dead) FROM `Dead` AS c WHERE c.team_id=1 AND c.Year=2015 AND player_id!=0),0) AS DeadMoney, (SELECT COUNT(e.id) FROM `Cap` AS e WHERE Status!=’Inactive’ AND Status!=” AND e.team_id=1 AND Year=2015) AS roster_count FROM (SELECT team_id, Year, CP FROM `Cap` AS b WHERE b.team_id=1 AND Status!=” AND Status IS NOT NULL AND b.Year=2015 ORDER BY b.CP DESC) AS bb



















Salary Cap Space

Calculations:

Cap Space = (Team Salary Cap) – (Active Cap Spending) – (Dead Money)
Team Salary Cap = (Base Salary Cap) + (Carryover) +/- (Adjustments)

Base Salary Cap: $143,280,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Jaguars$33,119,72076$168,074,086$128,126,269$6,828,097
Titans$23,637,13172$152,451,978$111,402,409$17,412,438
Browns$17,731,74677$159,059,670$134,027,331$7,300,593
Raiders$13,866,11673$150,984,556$120,285,503$16,832,937
49ers$12,010,85675$150,133,811$109,425,932$28,697,023
Giants$11,144,89184$143,078,442$115,929,485$16,004,066
Dolphins$10,999,15168$154,141,057$114,340,333$28,801,573
Eagles$8,350,49272$159,440,569$132,172,797$18,917,280
Bengals$8,180,52366$151,666,085$140,070,646$3,414,916
Buccaneers$7,557,47275$143,186,730$109,454,339$26,174,919
Packers$7,175,73769$150,844,514$138,874,129$4,794,648
Falcons$5,983,53371$145,696,738$115,797,874$23,915,331
Redskins$5,762,49881$145,793,105$128,208,590$11,822,017
Bills$5,207,79181$144,849,718$125,626,443$14,015,484
Colts$5,101,60278$150,591,024$131,687,688$13,801,734
Steelers$4,976,33780$143,804,798$119,785,293$19,043,168
Panthers$4,736,24771$149,729,886$129,647,532$15,346,107
Broncos$4,072,43869$149,675,723$140,143,084$5,460,201
Cardinals$3,874,72178$148,886,198$132,747,571$12,263,906
Cowboys$3,440,34579$147,793,955$125,452,770$18,900,840
Bears$3,062,23780$144,829,019$113,623,772$28,143,010
Vikings$3,031,72073$149,919,071$138,171,541$8,715,810
Chiefs$2,951,00770$145,094,948$120,585,026$21,558,915
Rams$2,623,00474$144,354,916$130,211,991$11,519,921
Chargers$2,581,07678$142,411,012$124,349,341$15,480,595
Jets$2,368,47873$155,857,264$145,317,709$8,171,077
Texans$2,157,23277$145,638,057$126,298,465$17,182,360
Ravens$1,940,01085$144,572,371$118,538,078$24,094,283
Saints$1,768,78878$144,894,746$108,871,497$34,254,461
Patriots$1,232,67882$143,542,717$122,667,741$19,642,298
Lions$553,14472$144,095,241$122,927,427$20,614,670
Seahawks$235,03678$148,629,793$128,624,883$19,769,874

Base Salary Cap: $155,270,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
49ers$49,020,39889$176,020,334$120,383,470$6,616,466
Browns$41,591,29092$176,124,694$115,693,114$18,840,290
Jaguars$40,755,63789$189,740,110$148,674,067$310,406
Panthers$28,429,82589$157,431,541$120,113,713$8,888,003
Titans$24,863,47489$175,796,226$144,534,944$6,397,808
Bears$22,038,68089$156,027,279$125,423,127$8,565,472
Giants$18,238,76789$166,758,559$138,814,161$9,705,631
Dolphins$17,630,82888$166,205,719$138,501,164$10,073,727
Colts$15,823,41092$160,047,429$134,102,921$10,121,098
Lions$14,489,96688$158,029,616$128,886,690$14,652,960
Ravens$13,096,43689$154,617,155$134,593,428$6,927,291
Bengals$12,530,23987$162,115,952$149,387,442$198,271
Texans$12,277,65690$156,624,480$138,902,242$5,444,582
Buccaneers$11,866,62786$160,576,766$148,317,902$392,237
Bills$11,865,72691$156,814,131$131,392,424$13,555,981
Redskins$11,009,64589$161,402,474$141,882,165$8,510,664
Raiders$10,448,65688$167,771,153$153,382,908$3,939,589
Patriots$9,912,17790$159,080,851$139,470,479$9,698,195
Seahawks$9,595,72493$153,961,327$135,885,559$8,480,044
Falcons$8,773,72388$158,240,071$129,229,101$20,237,247
Packers$8,521,34283$162,877,689$153,597,724$758,623
Chargers$8,029,46491$156,213,167$138,376,863$9,806,840
Eagles$6,844,14990$161,008,762$139,025,737$15,138,876
Cowboys$6,596,70791$158,699,683$151,192,566$910,410
Rams$6,595,93989$155,103,589$142,047,258$6,460,392
Vikings$5,257,96887$156,353,117$150,556,763$538,386
Cardinals$4,601,93491$158,406,816$150,309,560$3,495,322
Steelers$3,454,53089$157,067,378$144,509,659$9,103,189
Jets$3,089,12388$156,967,134$146,494,944$7,383,067
Broncos$2,627,54689$153,533,441$142,469,257$8,436,638
Saints$1,560,19491$155,000,462$124,258,173$29,182,095
Chiefs$1,169,49288$157,394,330$145,624,523$10,600,315

Base Salary Cap: $166,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Buccaneers$62,557,05051$166,000,000$103,438,950$4,000
Patriots$62,426,48147$166,000,000$103,573,519$0
Colts$60,925,37066$166,000,000$105,074,630$0
Broncos$59,239,44952$166,000,000$106,760,551$0
Cardinals$56,230,81747$166,000,000$109,767,849$1,334
Bears$54,634,33353$166,000,000$111,298,850$66,817
Steelers$52,367,70541$166,000,000$111,424,961$2,207,334
Panthers$48,671,30145$166,000,000$117,328,699$0
49ers$44,916,48661$166,000,000$121,083,514$0
Browns$44,673,39053$166,000,000$121,326,610$0
Raiders$44,387,27854$166,000,000$121,574,216$38,506
Bengals$41,059,86564$166,000,000$124,940,135$0
Titans$40,579,15958$166,000,000$125,420,841$0
Redskins$40,574,49664$166,000,000$122,924,504$2,501,000
Lions$39,130,41452$166,000,000$126,866,252$3,334
Saints$38,993,06763$166,000,000$125,703,933$1,303,000
Seahawks$33,706,79048$166,000,000$132,293,210$0
Bills$32,486,95254$166,000,000$133,503,381$9,667
Vikings$31,849,04057$166,000,000$134,150,960$0
Falcons$31,583,76057$166,000,000$131,614,573$2,801,667
Rams$31,348,34263$166,000,000$134,651,658$0
Chargers$26,836,30360$166,000,000$139,159,697$4,000
Packers$24,708,25453$166,000,000$141,290,412$1,334
Jaguars$22,202,91463$166,000,000$143,797,086$0
Dolphins$21,199,76350$166,000,000$144,800,237$0
Jets$21,127,52962$166,000,000$144,871,804$667
Giants$20,947,34552$166,000,000$145,052,655$0
Texans$20,679,30769$166,000,000$145,320,693$0
Ravens$11,514,65656$166,000,000$150,085,344$4,400,000
Chiefs$4,288,20753$166,000,000$161,711,793$0
Cowboys($1,631,420)70$166,000,000$167,628,086$3,334
Eagles($11,270,225)64$166,000,000$177,270,225$0

Base Salary Cap: $178,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Lions$125,845,09632$178,000,000$52,154,904$0
Cardinals$107,655,55134$178,000,000$70,344,449$0
Browns$107,334,76937$178,000,000$70,665,231$0
Buccaneers$105,602,96132$178,000,000$72,397,039$0
Jets$101,841,61031$178,000,000$76,158,390$0
Panthers$100,620,25326$178,000,000$77,379,747$0
Colts$97,776,44444$178,000,000$80,223,556$0
Vikings$96,910,36933$178,000,000$81,089,631$0
Patriots$95,555,93834$178,000,000$82,444,062$0
Rams$94,928,67937$178,000,000$83,071,321$0
Bears$92,724,38736$178,000,000$85,275,613$0
49ers$90,751,78838$178,000,000$87,248,212$0
Raiders$85,225,59341$178,000,000$92,774,407$0
Steelers$85,096,93231$178,000,000$92,903,068$0
Bills$81,617,70930$178,000,000$96,382,291$0
Redskins$80,060,19536$178,000,000$97,939,805$0
Broncos$75,256,04445$178,000,000$102,743,956$0
Titans$74,826,77041$178,000,000$103,173,230$0
Bengals$73,528,66640$178,000,000$104,471,334$0
Dolphins$71,056,13933$178,000,000$106,943,861$0
Giants$69,209,50431$178,000,000$108,790,496$0
Falcons$68,856,28839$178,000,000$109,143,712$0
Packers$65,829,92041$178,000,000$112,170,080$0
Texans$64,649,49236$178,000,000$113,350,508$0
Saints$63,156,11550$178,000,000$114,843,885$0
Ravens$61,971,27440$178,000,000$116,028,726$0
Chargers$58,631,92843$178,000,000$119,368,072$0
Seahawks$57,705,65239$178,000,000$120,294,348$0
Jaguars$56,472,46437$178,000,000$121,527,536$0
Cowboys$47,558,50140$178,000,000$130,441,499$0
Chiefs$40,723,24638$178,000,000$137,276,754$0
Eagles$8,836,21746$178,000,000$169,163,783$0

Base Salary Cap: $190,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Jets$173,589,5137$190,000,000$16,410,487$0
Cardinals$162,610,8338$190,000,000$27,389,167$0
Browns$161,395,09114$190,000,000$28,604,909$0
Lions$161,292,77212$190,000,000$28,707,228$0
Titans$159,228,01212$190,000,000$30,771,988$0
Rams$154,454,5356$190,000,000$35,545,465$0
Colts$145,147,99712$190,000,000$44,852,003$0
Panthers$143,824,3868$190,000,000$46,175,614$0
Buccaneers$143,618,72711$190,000,000$46,381,273$0
Bears$141,617,15612$190,000,000$48,382,844$0
Falcons$140,445,85612$190,000,000$49,554,144$0
Vikings$138,339,38614$190,000,000$51,660,614$0
Packers$136,143,20211$190,000,000$53,856,798$0
Patriots$135,459,04512$190,000,000$54,540,955$0
Saints$134,192,6179$190,000,000$55,807,383$0
49ers$134,127,82514$190,000,000$55,872,175$0
Bengals$133,242,05112$190,000,000$56,757,949$0
Raiders$132,823,44912$190,000,000$57,176,551$0
Seahawks$132,664,53212$190,000,000$57,335,468$0
Steelers$127,846,62112$190,000,000$62,153,379$0
Redskins$127,261,87911$190,000,000$62,738,121$0
Bills$122,947,82612$190,000,000$67,052,174$0
Chiefs$122,814,73014$190,000,000$67,185,270$0
Chargers$121,527,89112$190,000,000$68,472,109$0
Giants$112,109,23210$190,000,000$77,890,768$0
Dolphins$111,831,19112$190,000,000$78,168,809$0
Ravens$111,203,97016$190,000,000$78,796,030$0
Texans$111,092,37114$190,000,000$78,907,629$0
Broncos$110,062,49415$190,000,000$79,937,506$0
Jaguars$95,100,45418$190,000,000$94,899,546$0
Cowboys$90,133,00215$190,000,000$99,866,998$0
Eagles$77,980,84416$190,000,000$112,019,156$0