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,987,86571$145,696,738$115,797,874$23,910,999
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
Jaguars$53,746,85290$189,740,110$135,702,852$290,406
49ers$51,727,85182$176,020,334$117,676,017$6,616,466
Browns$41,737,85980$176,124,694$116,296,545$18,090,290
Panthers$31,028,21485$157,431,541$117,612,324$8,791,003
Titans$29,422,02880$175,796,226$140,038,948$6,335,250
Bears$26,324,52279$156,027,279$121,255,960$8,446,797
Giants$20,977,06378$166,758,559$136,075,865$9,705,631
Dolphins$18,653,18178$166,205,719$137,478,811$10,073,727
Colts$17,649,79190$160,047,429$132,276,540$10,121,098
Bengals$16,915,31773$162,115,952$145,007,364$193,271
Lions$16,590,93477$158,029,616$126,787,388$14,651,294
Chargers$15,395,03391$156,213,167$131,013,294$9,804,840
Buccaneers$14,703,76390$160,576,766$145,482,766$390,237
Raiders$12,797,89171$167,771,153$151,052,926$3,920,336
Ravens$12,149,34782$154,617,155$137,999,783$4,468,025
Texans$11,884,62774$156,624,480$139,295,271$5,444,582
Rams$11,241,90973$155,103,589$137,401,955$6,459,725
Cowboys$11,207,62788$158,699,683$146,590,980$901,076
Packers$10,092,70669$162,877,689$152,081,666$703,317
Eagles$9,760,35877$161,008,762$136,109,528$15,138,876
Vikings$8,652,11189$156,353,117$147,215,620$485,386
Broncos$6,278,69689$153,533,441$138,823,107$8,431,638
Bills$6,214,10588$156,814,131$137,048,878$13,551,148
Patriots$5,810,78782$159,080,851$143,571,869$9,698,195
Chiefs$5,780,89283$157,394,330$141,013,123$10,600,315
Cardinals$5,718,61894$158,406,816$149,195,542$3,492,656
Falcons$5,592,39768$158,240,071$133,831,428$18,816,246
Seahawks$5,163,18683$153,961,327$145,320,097$3,478,044
Redskins$4,323,43375$161,402,474$151,830,877$5,248,164
Jets$3,338,54779$156,967,134$146,245,853$7,382,734
Saints$3,009,56194$155,000,462$126,925,806$25,065,095
Steelers$2,976,80793$157,067,378$146,093,048$7,997,523

Base Salary Cap: $166,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Patriots$72,908,11430$166,000,000$93,091,886$0
Broncos$69,370,47944$166,000,000$96,629,521$0
Bears$69,212,45432$166,000,000$96,787,546$0
Buccaneers$68,281,27348$166,000,000$97,718,727$0
Colts$63,880,44355$166,000,000$102,119,557$0
Panthers$60,248,46038$166,000,000$105,751,540$0
Cardinals$59,800,44644$166,000,000$106,199,554$0
Browns$59,602,50131$166,000,000$106,397,499$0
Raiders$58,500,57231$166,000,000$107,499,428$0
Titans$57,312,91739$166,000,000$108,687,083$0
Steelers$56,187,36537$166,000,000$109,812,635$0
Saints$53,467,85057$166,000,000$111,232,150$1,300,000
49ers$53,173,18543$166,000,000$112,826,815$0
Lions$52,076,19233$166,000,000$113,923,808$0
Bengals$51,662,30442$166,000,000$114,337,696$0
Bills$50,178,30749$166,000,000$115,821,693$0
Redskins$48,730,36342$166,000,000$114,769,637$2,500,000
Falcons$45,740,18130$166,000,000$117,459,819$2,800,000
Dolphins$42,165,96430$166,000,000$123,834,036$0
Vikings$41,774,08250$166,000,000$124,225,918$0
Rams$40,606,36145$166,000,000$125,393,639$0
Packers$39,263,11229$166,000,000$126,736,888$0
Chargers$36,299,88251$166,000,000$129,700,118$0
Seahawks$35,682,03827$166,000,000$130,317,962$0
Jaguars$34,774,55659$166,000,000$131,225,444$0
Giants$33,140,21336$166,000,000$132,859,787$0
Jets$25,861,15544$166,000,000$140,138,845$0
Texans$23,492,84448$166,000,000$142,507,156$0
Ravens$21,304,31936$166,000,000$144,695,681$0
Chiefs$12,559,89739$166,000,000$153,440,103$0
Eagles$7,648,80843$166,000,000$158,351,192$0
Cowboys$4,657,29158$166,000,000$161,342,709$0

Base Salary Cap: $178,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Lions$142,778,93211$178,000,000$35,221,068$0
Browns$126,038,13915$178,000,000$51,961,861$0
Panthers$116,959,11019$178,000,000$61,040,890$0
Rams$115,431,92616$178,000,000$62,568,074$0
Jets$114,886,40112$178,000,000$63,113,599$0
Vikings$113,583,19726$178,000,000$64,416,803$0
Cardinals$112,504,78230$178,000,000$65,495,218$0
Buccaneers$112,501,20929$178,000,000$65,498,791$0
Bears$111,595,79414$178,000,000$66,404,206$0
49ers$108,100,35018$178,000,000$69,899,650$0
Patriots$107,674,72217$178,000,000$70,325,278$0
Redskins$106,518,27414$178,000,000$71,481,726$0
Colts$106,182,31636$178,000,000$71,817,684$0
Raiders$104,237,38617$178,000,000$73,762,614$0
Titans$102,525,45018$178,000,000$75,474,550$0
Bills$102,157,14025$178,000,000$75,842,860$0
Bengals$93,995,85918$178,000,000$84,004,141$0
Broncos$89,487,81137$178,000,000$88,512,189$0
Steelers$87,641,98327$178,000,000$90,358,017$0
Dolphins$87,417,14414$178,000,000$90,582,856$0
Falcons$87,305,73715$178,000,000$90,694,263$0
Giants$84,821,32214$178,000,000$93,178,678$0
Packers$84,094,44117$178,000,000$93,905,559$0
Saints$83,043,03344$178,000,000$94,956,967$0
Texans$78,422,57316$178,000,000$99,577,427$0
Jaguars$74,648,50430$178,000,000$103,351,496$0
Seahawks$74,584,84517$178,000,000$103,415,155$0
Chargers$73,464,02136$178,000,000$104,535,979$0
Ravens$72,997,89020$178,000,000$105,002,110$0
Cowboys$63,913,81726$178,000,000$114,086,183$0
Chiefs$51,576,91024$178,000,000$126,423,090$0
Eagles$48,867,81221$178,000,000$129,132,188$0

Base Salary Cap: $190,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Jets$179,106,1361$190,000,000$10,893,864$0
Browns$175,600,0002$190,000,000$14,400,000$0
Titans$172,957,0004$190,000,000$17,043,000$0
Lions$172,750,0002$190,000,000$17,250,000$0
Cardinals$169,550,0002$190,000,000$20,450,000$0
Rams$165,067,6763$190,000,000$24,932,324$0
Vikings$157,490,0006$190,000,000$32,510,000$0
Saints$156,753,0003$190,000,000$33,247,000$0
Colts$155,550,0003$190,000,000$34,450,000$0
Buccaneers$154,500,0004$190,000,000$35,500,000$0
Bears$153,850,0003$190,000,000$36,150,000$0
Panthers$150,229,9413$190,000,000$39,770,059$0
Falcons$148,605,0006$190,000,000$41,395,000$0
Bengals$146,274,0004$190,000,000$43,726,000$0
49ers$146,093,2505$190,000,000$43,906,750$0
Packers$144,800,0004$190,000,000$45,200,000$0
Redskins$144,750,0004$190,000,000$45,250,000$0
Bills$144,565,0004$190,000,000$45,435,000$0
Patriots$143,500,0003$190,000,000$46,500,000$0
Seahawks$141,850,0004$190,000,000$48,150,000$0
Raiders$141,750,0006$190,000,000$48,250,000$0
Chargers$137,600,0005$190,000,000$52,400,000$0
Steelers$136,165,3975$190,000,000$53,834,603$0
Chiefs$131,531,6005$190,000,000$58,468,400$0
Broncos$128,074,9986$190,000,000$61,925,002$0
Ravens$126,335,0006$190,000,000$63,665,000$0
Dolphins$122,662,0004$190,000,000$67,338,000$0
Giants$121,400,0005$190,000,000$68,600,000$0
Texans$116,720,0008$190,000,000$73,280,000$0
Jaguars$116,715,00010$190,000,000$73,285,000$0
Eagles$113,150,0008$190,000,000$76,850,000$0
Cowboys$103,200,0009$190,000,000$86,800,000$0