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
Jaguars$53,193,03389$189,740,110$136,256,671$290,406
49ers$49,020,39889$176,020,334$120,383,470$6,616,466
Browns$42,618,77192$176,124,694$114,665,633$18,840,290
Panthers$29,937,82591$157,431,541$118,613,713$8,880,003
Bears$24,532,91689$156,027,279$123,044,232$8,450,131
Titans$22,687,02592$175,796,226$146,711,393$6,397,808
Giants$18,298,05190$166,758,559$138,754,877$9,705,631
Dolphins$17,711,24089$166,205,719$138,420,752$10,073,727
Bengals$16,644,90185$162,115,952$145,272,780$198,271
Colts$16,164,52390$160,047,429$133,761,808$10,121,098
Chargers$15,241,52090$156,213,167$131,166,807$9,804,840
Lions$14,491,63289$158,029,616$128,886,690$14,651,294
Bills$13,681,53189$156,814,131$129,581,452$13,551,148
Buccaneers$12,080,45786$160,576,766$148,106,072$390,237
Texans$11,541,45089$156,624,480$139,638,448$5,444,582
Rams$11,241,24288$155,103,589$137,401,955$6,460,392
Cowboys$11,199,95983$158,699,683$146,590,980$908,744
Raiders$11,007,13488$167,771,153$152,843,683$3,920,336
Patriots$9,912,17788$159,080,851$139,470,479$9,698,195
Packers$9,717,12584$162,877,689$152,420,607$739,957
Seahawks$9,595,72490$153,961,327$135,885,559$8,480,044
Ravens$8,655,53493$154,617,155$141,493,596$4,468,025
Vikings$7,445,75188$156,353,117$148,421,980$485,386
Broncos$6,016,49389$153,533,441$139,080,310$8,436,638
Eagles$5,469,14991$161,008,762$140,400,737$15,138,876
Cardinals$4,642,81690$158,406,816$150,269,344$3,494,656
Falcons$3,943,05687$158,240,071$135,466,601$18,830,414
Redskins$3,639,75190$161,402,474$150,502,559$7,260,164
Steelers$3,173,03288$157,067,378$145,894,823$7,999,523
Jets$3,154,45689$156,967,134$146,429,944$7,382,734
Chiefs$1,297,77486$157,394,330$145,496,241$10,600,315
Saints$197,28189$155,000,462$129,672,586$25,130,595

Base Salary Cap: $166,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Broncos$66,248,13349$166,000,000$99,751,867$0
Buccaneers$64,097,08849$166,000,000$101,902,912$0
Patriots$63,201,67046$166,000,000$102,798,330$0
Colts$61,537,57061$166,000,000$104,462,430$0
Bears$58,013,82351$166,000,000$107,986,177$0
Cardinals$56,348,82547$166,000,000$109,651,175$0
Steelers$55,586,60038$166,000,000$110,413,400$0
Panthers$53,881,30146$166,000,000$112,118,699$0
Browns$48,093,36048$166,000,000$117,906,640$0
Bengals$46,069,65460$166,000,000$119,930,346$0
Raiders$45,298,10952$166,000,000$120,701,891$0
49ers$44,916,48661$166,000,000$121,083,514$0
Titans$43,912,34857$166,000,000$122,087,652$0
Redskins$40,774,26862$166,000,000$122,725,732$2,500,000
Vikings$39,250,01856$166,000,000$126,749,982$0
Lions$39,147,26955$166,000,000$126,852,731$0
Saints$39,133,31962$166,000,000$125,566,681$1,300,000
Rams$37,516,69560$166,000,000$128,483,305$0
Chargers$35,857,87357$166,000,000$130,142,127$0
Seahawks$35,328,45645$166,000,000$130,671,544$0
Bills$35,101,18254$166,000,000$130,898,818$0
Jaguars$33,709,04462$166,000,000$132,290,956$0
Falcons$31,726,80953$166,000,000$131,473,191$2,800,000
Packers$26,297,23452$166,000,000$139,702,766$0
Dolphins$23,294,88847$166,000,000$142,705,112$0
Texans$21,160,97566$166,000,000$144,839,025$0
Jets$21,128,19663$166,000,000$144,871,804$0
Giants$21,076,62952$166,000,000$144,923,371$0
Ravens$7,441,77258$166,000,000$158,558,228$0
Chiefs$4,684,78251$166,000,000$161,315,218$0
Cowboys$4,657,29155$166,000,000$161,342,709$0
Eagles($2,410,225)63$166,000,000$168,410,225$0

Base Salary Cap: $178,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Lions$124,523,61734$178,000,000$53,476,383$0
Browns$112,559,22632$178,000,000$65,440,774$0
Panthers$109,490,25327$178,000,000$68,509,747$0
Cardinals$108,479,72533$178,000,000$69,520,275$0
Vikings$107,457,54332$178,000,000$70,542,457$0
Buccaneers$106,708,20731$178,000,000$71,291,793$0
Rams$104,721,92633$178,000,000$73,278,074$0
Jets$101,841,61031$178,000,000$76,158,390$0
Colts$99,674,39742$178,000,000$78,325,603$0
Bears$97,953,46934$178,000,000$80,046,531$0
Patriots$96,486,16533$178,000,000$81,513,835$0
49ers$90,751,78838$178,000,000$87,248,212$0
Raiders$88,154,72738$178,000,000$89,845,273$0
Steelers$86,951,21828$178,000,000$91,048,782$0
Broncos$85,914,46542$178,000,000$92,085,535$0
Bills$84,850,01530$178,000,000$93,149,985$0
Bengals$81,819,62036$178,000,000$96,180,380$0
Redskins$80,858,96935$178,000,000$97,141,031$0
Titans$80,104,59739$178,000,000$97,895,403$0
Dolphins$73,441,26430$178,000,000$104,558,736$0
Jaguars$70,790,06334$178,000,000$107,209,937$0
Giants$70,148,78830$178,000,000$107,851,212$0
Chargers$70,022,01241$178,000,000$107,977,988$0
Falcons$69,627,67038$178,000,000$108,372,330$0
Packers$68,383,09540$178,000,000$109,616,905$0
Texans$66,243,66034$178,000,000$111,756,340$0
Saints$63,923,36949$178,000,000$114,076,631$0
Cowboys$63,283,81727$178,000,000$114,716,183$0
Seahawks$59,597,32036$178,000,000$118,402,680$0
Ravens$52,362,89042$178,000,000$125,637,110$0
Chiefs$42,399,82136$178,000,000$135,600,179$0
Eagles$26,736,21745$178,000,000$151,263,783$0

Base Salary Cap: $190,000,000

TeamCap Space#Team Salary CapActive Cap SpendingDead Money
Jets$174,447,2966$190,000,000$15,552,704$0
Browns$168,071,3158$190,000,000$21,928,685$0
Rams$165,067,6763$190,000,000$24,932,324$0
Titans$164,650,47711$190,000,000$25,349,523$0
Cardinals$163,519,5077$190,000,000$26,480,493$0
Lions$160,511,29313$190,000,000$29,488,707$0
Vikings$150,462,75612$190,000,000$39,537,244$0
Bears$147,665,64710$190,000,000$42,334,353$0
Colts$147,400,37010$190,000,000$42,599,630$0
Buccaneers$144,908,18110$190,000,000$45,091,819$0
Panthers$143,824,3868$190,000,000$46,175,614$0
Bengals$141,734,1719$190,000,000$48,265,829$0
Falcons$141,307,23811$190,000,000$48,692,762$0
Packers$139,121,90610$190,000,000$50,878,094$0
Patriots$136,544,31011$190,000,000$53,455,690$0
Raiders$135,567,14510$190,000,000$54,432,855$0
Saints$135,048,2038$190,000,000$54,951,797$0
49ers$134,127,82514$190,000,000$55,872,175$0
Steelers$133,944,6328$190,000,000$56,055,368$0
Chargers$133,707,98910$190,000,000$56,292,011$0
Seahawks$132,664,53212$190,000,000$57,335,468$0
Bills$128,892,8759$190,000,000$61,107,125$0
Redskins$128,191,48510$190,000,000$61,808,515$0
Chiefs$124,676,80512$190,000,000$65,323,195$0
Broncos$123,330,65212$190,000,000$66,669,348$0
Dolphins$114,501,3169$190,000,000$75,498,684$0
Giants$113,148,5169$190,000,000$76,851,484$0
Texans$112,874,03912$190,000,000$77,125,961$0
Jaguars$111,578,63015$190,000,000$78,421,370$0
Ravens$111,347,54716$190,000,000$78,652,453$0
Cowboys$103,200,0009$190,000,000$86,800,000$0
Eagles$99,980,84415$190,000,000$90,019,156$0