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,967,33477$159,059,670$134,027,331$7,065,005
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$7,595,52366$151,666,085$140,070,646$3,999,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,372,67482$145,793,105$128,598,414$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,701,83571$149,729,886$129,647,532$15,380,519
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$46,583,12593$176,323,559$123,121,302$6,619,132
Browns$41,434,03094$176,336,464$116,059,812$18,842,622
Jaguars$40,901,08390$189,910,735$148,647,580$362,072
Panthers$24,199,31591$153,201,031$120,113,713$8,888,003
Titans$23,179,42093$174,496,296$144,331,398$6,985,478
Bears$22,220,08591$156,219,744$125,349,347$8,650,312
Giants$17,672,08692$167,036,044$139,651,661$9,712,297
Ravens$14,510,59493$154,885,595$133,447,710$6,927,291
Colts$13,402,66392$160,281,624$136,730,865$10,148,096
Bengals$12,751,57489$162,477,787$149,482,442$243,771
Dolphins$12,412,35489$163,426,849$140,938,602$10,075,893
Buccaneers$12,036,73189$160,754,536$148,317,902$399,903
Redskins$11,483,03891$161,624,774$141,497,165$8,644,571
Lions$11,397,44590$155,298,326$127,167,921$16,732,960
Texans$11,259,90590$155,785,355$138,902,242$5,623,208
Raiders$10,614,81087$168,099,728$153,445,329$4,039,589
Falcons$10,195,72887$157,341,741$125,989,433$21,156,580
Patriots$9,717,79883$159,220,861$139,229,785$10,273,278
Chargers$9,683,28897$156,313,432$136,667,452$9,962,692
Packers$8,863,85583$163,223,034$153,597,724$761,455
Seahawks$8,558,69096$154,153,792$136,810,559$8,784,543
Eagles$6,876,52984$161,244,517$138,927,113$15,440,875
Vikings$6,864,59789$156,661,412$147,506,763$2,290,052
Rams$6,840,56692$155,284,549$133,983,591$14,460,392
Cardinals$6,267,61090$158,657,391$148,891,793$3,497,988
Bills$5,930,52692$155,576,601$135,992,424$13,653,651
Broncos$5,676,09591$153,794,156$139,679,423$8,438,638
Cowboys$4,773,40195$156,893,513$151,188,130$931,982
Chiefs$4,477,15188$157,571,345$142,493,546$10,600,648
Steelers$2,995,90495$155,987,418$143,747,159$9,244,355
Jets$1,398,09493$157,172,469$148,389,642$7,384,733
Saints$970,70997$155,167,847$118,665,043$35,532,095

Base Salary Cap: $166,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Patriots$64,179,81444$166,000,000$101,684,269$135,917
Buccaneers$62,466,71652$166,000,000$103,513,950$19,334
Bears$55,704,65249$166,000,000$110,218,850$76,498
Steelers$52,360,37141$166,000,000$111,424,961$2,214,668
Panthers$47,591,30147$166,000,000$118,408,699$0
Cardinals$46,907,99147$166,000,000$119,088,007$4,002
Browns$44,209,68552$166,000,000$121,785,647$4,668
Rams$43,955,84964$166,000,000$122,044,151$0
Saints$43,953,06762$166,000,000$117,143,933$4,903,000
Colts$42,270,42468$166,000,000$123,717,574$12,002
Redskins$40,423,68968$166,000,000$123,007,497$2,568,814
Broncos$39,777,11553$166,000,000$126,220,551$2,334
Bengals$39,323,86565$166,000,000$126,675,135$1,000
49ers$38,686,42166$166,000,000$127,308,245$5,334
Titans$37,752,43862$166,000,000$127,072,221$1,175,341
Raiders$36,209,15957$166,000,000$129,752,335$38,506
Falcons$31,498,75857$166,000,000$131,689,573$2,811,669
Vikings$31,475,70657$166,000,000$134,520,960$3,334
Lions$29,045,41452$166,000,000$136,951,252$3,334
Chargers$26,536,04761$166,000,000$139,454,952$9,001
Packers$24,702,58653$166,000,000$141,290,412$7,002
Seahawks$23,543,14250$166,000,000$142,447,857$9,001
Jaguars$22,199,58062$166,000,000$143,797,086$3,334
Dolphins$21,810,42949$166,000,000$144,185,237$4,334
Giants$20,798,45953$166,000,000$145,198,207$3,334
Bills$19,000,44649$166,000,000$146,874,543$125,011
Texans$18,904,56870$166,000,000$147,090,764$4,668
Ravens$7,718,23358$166,000,000$153,881,767$4,400,000
Jets($2,578,906)65$166,000,000$168,574,905$4,001
Chiefs($3,478,437)53$166,000,000$169,477,770$667
Cowboys($7,683,724)73$166,000,000$173,656,150$27,574
Eagles($14,231,456)61$166,000,000$180,227,455$4,001

Base Salary Cap: $178,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Lions$120,898,82732$178,000,000$57,101,173$0
Browns$107,440,84236$178,000,000$70,559,158$0
Buccaneers$105,602,79332$178,000,000$72,397,207$0
Panthers$99,360,25328$178,000,000$78,639,747$0
Patriots$96,815,93832$178,000,000$81,184,062$0
Vikings$96,615,36933$178,000,000$81,384,631$0
Bears$95,244,38732$178,000,000$82,755,613$0
Rams$92,306,18641$178,000,000$85,693,814$0
Cardinals$91,720,22535$178,000,000$86,279,775$0
Steelers$85,096,93231$178,000,000$92,903,068$0
49ers$79,679,16842$178,000,000$98,320,832$0
Jets$79,053,38933$178,000,000$98,946,611$0
Raiders$78,562,47443$178,000,000$99,437,526$0
Redskins$78,292,87839$178,000,000$99,707,122$0
Titans$77,225,09939$178,000,000$100,774,901$0
Colts$75,480,66642$178,000,000$102,519,334$0
Falcons$72,006,28834$178,000,000$105,993,712$0
Dolphins$71,686,13932$178,000,000$106,313,861$0
Bengals$70,523,66642$178,000,000$107,476,334$0
Giants$68,433,95233$178,000,000$109,566,048$0
Bills$67,486,54727$178,000,000$110,513,453$0
Packers$65,829,92041$178,000,000$112,170,080$0
Saints$62,526,11551$178,000,000$115,473,885$0
Texans$62,507,40736$178,000,000$115,492,593$0
Chargers$58,279,67343$178,000,000$119,720,327$0
Ravens$56,854,85142$178,000,000$121,145,149$0
Jaguars$56,472,46437$178,000,000$121,527,536$0
Broncos$52,756,04446$178,000,000$125,243,956$0
Seahawks$46,886,00741$178,000,000$131,113,993$0
Cowboys$37,386,53140$178,000,000$140,613,469$0
Chiefs$27,373,24638$178,000,000$150,626,754$0
Eagles$9,637,61145$178,000,000$168,362,389$0

Base Salary Cap: $190,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Browns$159,426,16416$190,000,000$30,573,836$0
Titans$158,493,37713$190,000,000$31,506,623$0
Rams$152,192,0429$190,000,000$37,807,958$0
Jets$151,837,1729$190,000,000$38,162,828$0
Cardinals$148,670,0079$190,000,000$41,329,993$0
Lions$145,892,77213$190,000,000$44,107,228$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$137,379,38615$190,000,000$52,620,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$130,767,05113$190,000,000$59,232,949$0
Steelers$127,846,62112$190,000,000$62,153,379$0
Redskins$126,480,65512$190,000,000$63,519,345$0
Raiders$124,570,33014$190,000,000$65,429,670$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
49ers$116,515,70619$190,000,000$73,484,294$0
Dolphins$111,831,19112$190,000,000$78,168,809$0
Giants$111,243,68012$190,000,000$78,756,320$0
Chiefs$109,664,73015$190,000,000$80,335,270$0
Texans$107,858,27215$190,000,000$82,141,728$0
Ravens$105,897,54718$190,000,000$84,102,453$0
Bills$105,567,82613$190,000,000$84,432,174$0
Jaguars$95,100,45418$190,000,000$94,899,546$0
Broncos$89,062,49416$190,000,000$100,937,506$0
Cowboys$81,863,44318$190,000,000$108,136,557$0
Eagles$77,199,69917$190,000,000$112,800,301$0