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$48,952,25990$176,020,334$120,451,609$6,616,466
Browns$41,411,07491$176,124,694$115,873,330$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,68090$156,027,279$125,423,127$8,565,472
Lions$19,389,96687$158,029,616$122,186,690$16,452,960
Giants$18,238,76790$166,758,559$138,814,161$9,705,631
Dolphins$15,989,89089$166,205,719$140,142,102$10,073,727
Colts$13,343,46691$160,047,429$136,582,865$10,121,098
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,72692$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,65687$167,771,153$153,382,908$3,939,589
Patriots$9,912,17790$159,080,851$139,470,479$9,698,195
Jets$8,777,90689$156,967,134$140,806,161$7,383,067
Falcons$8,773,72388$158,240,071$129,229,101$20,237,247
Packers$8,521,34284$162,877,689$153,597,724$758,623
Seahawks$7,920,72492$153,961,327$137,560,559$8,480,044
Chargers$7,883,87591$156,213,167$138,522,452$9,806,840
Eagles$6,844,14989$161,008,762$139,025,737$15,138,876
Cowboys$6,667,23790$158,699,683$151,108,130$924,316
Rams$6,595,93988$155,103,589$142,047,258$6,460,392
Vikings$5,257,96887$156,353,117$150,556,763$538,386
Broncos$5,256,54689$153,533,441$139,840,257$8,436,638
Cardinals$4,601,93491$158,406,816$150,309,560$3,495,322
Steelers$3,454,53090$157,067,378$144,509,659$9,103,189
Saints$1,431,51694$155,000,462$124,386,851$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
Cardinals$55,661,31748$166,000,000$110,337,349$1,334
Bears$54,634,33353$166,000,000$111,298,850$66,817
Steelers$51,827,70542$166,000,000$111,964,961$2,207,334
Panthers$48,671,30145$166,000,000$117,328,699$0
49ers$44,501,37164$166,000,000$121,498,629$0
Raiders$44,354,15955$166,000,000$121,607,335$38,506
Browns$44,214,35355$166,000,000$121,785,647$0
Colts$42,205,42666$166,000,000$123,794,574$0
Bengals$41,059,86564$166,000,000$124,940,135$0
Titans$40,564,52459$166,000,000$125,435,476$0
Redskins$40,513,27265$166,000,000$122,985,728$2,501,000
Broncos$39,779,44953$166,000,000$126,220,551$0
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
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,245,84965$166,000,000$134,754,151$0
Chargers$26,541,04861$166,000,000$139,454,952$4,000
Packers$24,708,25453$166,000,000$141,290,412$1,334
Seahawks$22,935,47752$166,000,000$143,064,523$0
Jaguars$22,202,91463$166,000,000$143,797,086$0
Dolphins$21,199,76350$166,000,000$144,800,237$0
Giants$20,801,79354$166,000,000$145,198,207$0
Texans$18,909,23670$166,000,000$147,090,764$0
Ravens$11,478,23357$166,000,000$150,121,767$4,400,000
Chiefs$4,288,20753$166,000,000$161,711,793$0
Jets$3,667,52963$166,000,000$162,331,804$667
Cowboys($1,550,890)70$166,000,000$167,533,650$17,240
Eagles($11,331,370)65$166,000,000$177,331,370$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$106,996,05135$178,000,000$71,003,949$0
Buccaneers$105,602,96132$178,000,000$72,397,039$0
Browns$105,550,84239$178,000,000$72,449,158$0
Panthers$100,620,25326$178,000,000$77,379,747$0
Vikings$96,910,36933$178,000,000$81,089,631$0
Patriots$95,555,93834$178,000,000$82,444,062$0
Rams$92,936,18640$178,000,000$85,063,814$0
Bears$92,724,38736$178,000,000$85,275,613$0
49ers$89,106,70740$178,000,000$88,893,293$0
Raiders$84,562,47442$178,000,000$93,437,526$0
Steelers$84,466,93232$178,000,000$93,533,068$0
Jets$81,841,61032$178,000,000$96,158,390$0
Bills$81,617,70930$178,000,000$96,382,291$0
Redskins$79,368,97137$178,000,000$98,631,029$0
Titans$74,182,13542$178,000,000$103,817,865$0
Colts$74,146,50044$178,000,000$103,853,500$0
Bengals$73,528,66640$178,000,000$104,471,334$0
Dolphins$71,056,13933$178,000,000$106,943,861$0
Falcons$68,856,28839$178,000,000$109,143,712$0
Giants$68,433,95233$178,000,000$109,566,048$0
Packers$65,829,92041$178,000,000$112,170,080$0
Saints$63,156,11550$178,000,000$114,843,885$0
Texans$61,877,40737$178,000,000$116,122,593$0
Ravens$61,304,85141$178,000,000$116,695,149$0
Chargers$57,649,67344$178,000,000$120,350,327$0
Jaguars$56,472,46437$178,000,000$121,527,536$0
Broncos$52,756,04446$178,000,000$125,243,956$0
Cowboys$46,774,03141$178,000,000$131,225,969$0
Seahawks$45,624,33943$178,000,000$132,375,661$0
Chiefs$40,723,24638$178,000,000$137,276,754$0
Eagles$8,145,07247$178,000,000$169,854,928$0

Base Salary Cap: $190,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Cardinals$161,861,3339$190,000,000$28,138,667$0
Lions$161,292,77212$190,000,000$28,707,228$0
Browns$159,426,16416$190,000,000$30,573,836$0
Titans$158,493,37713$190,000,000$31,506,623$0
Jets$155,089,5138$190,000,000$34,910,487$0
Rams$152,192,0429$190,000,000$37,807,958$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
Bengals$133,242,05112$190,000,000$56,757,949$0
49ers$132,291,16816$190,000,000$57,708,832$0
Raiders$132,070,33013$190,000,000$57,929,670$0
Steelers$127,846,62112$190,000,000$62,153,379$0
Redskins$126,480,65512$190,000,000$63,519,345$0
Bills$122,947,82612$190,000,000$67,052,174$0
Chiefs$122,814,73014$190,000,000$67,185,270$0
Chargers$120,440,63613$190,000,000$69,559,364$0
Seahawks$119,783,21915$190,000,000$70,216,781$0
Colts$118,483,05312$190,000,000$71,516,947$0
Dolphins$111,831,19112$190,000,000$78,168,809$0
Giants$111,243,68012$190,000,000$78,756,320$0
Ravens$110,447,54717$190,000,000$79,552,453$0
Texans$107,858,27215$190,000,000$82,141,728$0
Jaguars$95,100,45418$190,000,000$94,899,546$0
Broncos$89,062,49416$190,000,000$100,937,506$0
Cowboys$88,513,44317$190,000,000$101,486,557$0
Eagles$77,199,69917$190,000,000$112,800,301$0