| Priority | Type | Description |
|---|---|---|
| 1 | | or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar |
| 2 | && or AND | Logical "and". Filter the column for content that matches text from either side of the operator. |
| 3 | /\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig) |
| 4 | < <= >= > | Find alphabetical or numerical values less than or greater than or equal to the filtered query |
| 5 | ! or != | Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter. |
| 6 | " or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query |
| 7 | - or to | Find a range of values. Make sure there is a space before and after the dash (or the word "to") |
| 8 | ? | Wildcard for a single, non-space character. |
| 8 | * | Wildcard for zero or more non-space characters. |
| 9 | ~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query |
| 10 | text | Any text entered in the filter will match text found within the column |
| Arena Capacity | Ticket Price | Attendance | Attendance PCT | Income | Expenses | Estimate | Team Total Estimate | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Team | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Arena Capacity | Team Popularity | Players Total Salaries | Players Total Average Salaries | Special Salary Cap Value | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Luxury Taxe Total | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses | Estimated Season Expenses | Estimated Season Salary Cap | Over Minimum Salary Cap of 47,040,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Anaheim | 6000 | 5000 | 3000 | 3000 | 1500 | 175 | 90 | 65 | 40 | 325 | 164758 | 157481 | 77097 | 123000 | 37009 | 66.97% | 76.82% | 62.68% | 100.00% | 60.18% | 0 | 13643 - 73.74% | 1,584,516$ | 64,965,170$ | 18500 | 100 | 53,969,500$ | 53,969,500$ | 0$ | 53,569,184$ | 288,607$ | 53,569,184$ | 23 | 0 | 0$ | 0$ | 0 | 288,607$ | 0$ | 0$ | 56,400,497$ | 9,360,497$ | 63,600,000$ | 7,199,503$ | 118,227,596$ | 118,227,596$ |
| 2 | Boston | 6105 | 5180 | 2035 | 4070 | 1110 | 180 | 100 | 99 | 98 | 350 | 158554 | 140260 | 51180 | 67832 | 34556 | 63.34% | 66.04% | 61.34% | 40.65% | 75.93% | 0 | 11034 - 59.64% | 1,618,895$ | 66,374,676$ | 18500 | 100 | 53,738,000$ | 53,738,000$ | 0$ | 52,419,686$ | 280,952$ | 52,400,435$ | 23 | 1 | 0$ | 0$ | 0 | 287,369$ | 0$ | 0$ | 55,043,006$ | 8,003,006$ | 63,600,000$ | 8,556,994$ | 133,223,334$ | 133,223,334$ |
| 3 | Buffalo | 7500 | 6000 | 2500 | 4000 | 2000 | 125 | 75 | 50 | 30 | 200 | 258715 | 209852 | 100137 | 163323 | 53974 | 84.13% | 85.31% | 97.69% | 99.59% | 65.82% | 0 | 19171 - 87.14% | 1,677,552$ | 68,779,615$ | 22000 | 100 | 57,218,000$ | 57,218,000$ | 0$ | 61,135,228$ | 305,979$ | 61,135,228$ | 20 | 0 | 0$ | 0$ | 0 | 305,979$ | 0$ | 0$ | 63,585,889$ | 16,545,889$ | 63,600,000$ | 14,111$ | 97,555,024$ | 97,555,024$ |
| 4 | Calgary | 6500 | 5250 | 2250 | 4000 | 1500 | 200 | 100 | 100 | 100 | 400 | 145598 | 139052 | 50219 | 66322 | 30153 | 54.63% | 64.60% | 54.44% | 40.44% | 49.03% | 0 | 10521 - 53.95% | 1,627,807$ | 66,740,100$ | 19500 | 100 | 50,226,500$ | 50,226,500$ | 0$ | 51,322,383$ | 268,591$ | 51,322,383$ | 25 | 0 | 0$ | 0$ | 0 | 268,591$ | 0$ | 0$ | 53,591,960$ | 6,551,960$ | 63,600,000$ | 10,008,040$ | 200,538,789$ | 200,538,789$ |
| 5 | Caroline | 6000 | 5000 | 2000 | 4000 | 1000 | 140 | 82 | 64 | 42 | 299 | 205783 | 188145 | 78794 | 159940 | 39733 | 83.65% | 91.78% | 96.09% | 97.52% | 96.91% | 0 | 16400 - 91.11% | 1,655,560$ | 67,877,973$ | 18000 | 100 | 46,922,000$ | 38,705,333$ | 0$ | 60,382,305$ | 250,920$ | 60,382,305$ | 24 | 0 | 0$ | 0$ | 0 | 250,920$ | 0$ | 0$ | 63,293,988$ | 16,253,988$ | 63,600,000$ | 306,012$ | 92,072,837$ | 92,072,837$ |
| 6 | Chicago | 7000 | 6000 | 2500 | 5000 | 1500 | 200 | 100 | 99 | 98 | 400 | 145518 | 141595 | 51169 | 82000 | 30218 | 50.70% | 57.56% | 49.92% | 40.00% | 49.13% | 0 | 10988 - 49.94% | 1,669,562$ | 68,452,031$ | 22000 | 100 | 60,585,000$ | 59,772,500$ | 0$ | 59,095,444$ | 323,984$ | 59,095,444$ | 21 | 0 | 0$ | 0$ | 0 | 323,984$ | 0$ | 0$ | 62,412,381$ | 15,372,381$ | 63,600,000$ | 1,187,619$ | 347,890,445$ | 347,890,445$ |
| 7 | Colorado | 6000 | 5000 | 2500 | 4000 | 1000 | 160 | 100 | 65 | 40 | 300 | 178329 | 141090 | 77865 | 160780 | 39315 | 72.49% | 68.82% | 75.97% | 98.04% | 95.89% | 0 | 14570 - 78.76% | 1,608,014$ | 65,928,565$ | 18500 | 100 | 57,656,000$ | 59,148,857$ | 0$ | 59,054,221$ | 308,321$ | 59,054,221$ | 22 | 0 | 0$ | 0$ | 0 | 308,321$ | 0$ | 0$ | 61,867,459$ | 14,827,459$ | 63,600,000$ | 1,732,541$ | 187,450,861$ | 187,450,861$ |
| 8 | Columbus | 6700 | 5800 | 3000 | 5000 | 1500 | 135 | 70 | 50 | 35 | 260 | 247909 | 213676 | 102768 | 168828 | 51445 | 90.25% | 89.86% | 83.55% | 82.36% | 83.65% | 0 | 19137 - 86.99% | 1,776,783$ | 72,848,115$ | 22000 | 100 | 59,630,000$ | 58,880,000$ | 0$ | 58,524,961$ | 318,877$ | 58,524,961$ | 24 | 0 | 0$ | 0$ | 0 | 318,877$ | 0$ | 0$ | 60,672,305$ | 13,632,305$ | 63,600,000$ | 2,927,695$ | 194,949,483$ | 194,949,483$ |
| 9 | Dallas | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 60 | 35 | 20 | 250 | 242377 | 204629 | 82000 | 164000 | 41000 | 98.53% | 99.82% | 100.00% | 100.00% | 100.00% | 0 | 17903 - 99.46% | 1,438,411$ | 58,974,865$ | 18000 | 100 | 50,032,000$ | 50,032,000$ | 0$ | 50,241,363$ | 241,348$ | 47,490,002$ | 23 | 1 | 0$ | 0$ | 0 | 267,551$ | 0$ | 0$ | 51,344,035$ | 4,304,035$ | 63,600,000$ | 12,255,965$ | 84,132,609$ | 84,132,609$ |
| 10 | Detroit | 7500 | 6000 | 2000 | 5000 | 1500 | 150 | 100 | 99 | 98 | 400 | 194355 | 143610 | 50556 | 82000 | 30289 | 63.20% | 58.38% | 61.65% | 40.00% | 49.25% | 0 | 12215 - 55.52% | 1,674,900$ | 68,670,894$ | 22000 | 100 | 59,342,500$ | 59,406,786$ | 0$ | 56,802,463$ | 317,340$ | 56,802,463$ | 24 | 0 | 0$ | 0$ | 0 | 317,340$ | 0$ | 0$ | 60,712,033$ | 13,672,033$ | 63,600,000$ | 2,887,967$ | 234,402,696$ | 234,402,696$ |
| 11 | Edmonton | 6000 | 5000 | 2500 | 4000 | 1750 | 150 | 100 | 60 | 25 | 300 | 189186 | 141209 | 99594 | 164000 | 40003 | 76.90% | 68.88% | 97.16% | 100.00% | 55.75% | 0 | 15463 - 80.33% | 1,575,008$ | 64,575,340$ | 19250 | 100 | 42,319,999$ | 42,319,999$ | 0$ | 48,711,547$ | 226,310$ | 48,711,547$ | 24 | 0 | 0$ | 0$ | 0 | 226,310$ | 0$ | 0$ | 51,074,306$ | 4,034,306$ | 63,600,000$ | 12,525,694$ | 158,890,124$ | 158,890,124$ |
| 12 | Hartford | 7000 | 5000 | 2500 | 4000 | 1500 | 105 | 82 | 59 | 46 | 208 | 261020 | 176976 | 98833 | 158283 | 53899 | 90.95% | 86.33% | 96.42% | 96.51% | 87.64% | 0 | 18269 - 91.34% | 1,620,584$ | 66,443,947$ | 20000 | 100 | 64,582,000$ | 64,924,857$ | 0$ | 59,071,851$ | 345,358$ | 59,071,851$ | 21 | 0 | 0$ | 0$ | 0 | 345,358$ | 0$ | 0$ | 62,084,663$ | 15,044,663$ | 63,600,000$ | 1,515,337$ | 181,630,889$ | 181,630,889$ |
| 13 | Islanders | 6500 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 45 | 32 | 400 | 258370 | 202737 | 82000 | 162117 | 30519 | 96.95% | 98.90% | 100.00% | 98.85% | 74.44% | 0 | 17945 - 97.00% | 1,490,584$ | 61,113,934$ | 18500 | 100 | 60,992,000$ | 57,342,000$ | 0$ | 60,417,355$ | 326,160$ | 60,417,355$ | 21 | 0 | 0$ | 0$ | 0 | 326,160$ | 0$ | 0$ | 62,287,970$ | 15,247,970$ | 63,600,000$ | 1,312,030$ | 145,496,876$ | 145,496,876$ |
| 14 | Kansas City | 7500 | 6000 | 3000 | 4000 | 1500 | 160 | 100 | 60 | 55 | 399 | 180431 | 139264 | 100057 | 115013 | 30258 | 58.68% | 56.61% | 81.35% | 70.13% | 49.20% | 0 | 13781 - 62.64% | 1,638,962$ | 67,197,437$ | 22000 | 100 | 61,252,333$ | 62,002,333$ | 0$ | 57,283,746$ | 327,553$ | 57,268,907$ | 24 | 0 | 0$ | 0$ | 0 | 327,553$ | 0$ | 0$ | 62,540,525$ | 15,500,525$ | 63,600,000$ | 1,059,475$ | 177,733,022$ | 177,733,022$ |
| 15 | LA Kings | 6000 | 5000 | 3500 | 4000 | 1500 | 125 | 75 | 35 | 30 | 175 | 242616 | 202613 | 111498 | 162925 | 56007 | 98.62% | 98.84% | 77.70% | 99.34% | 91.07% | 0 | 18919 - 94.59% | 1,563,765$ | 64,114,380$ | 20000 | 100 | 57,175,000$ | 57,889,286$ | 0$ | 55,980,060$ | 305,749$ | 55,980,060$ | 23 | 0 | 0$ | 0$ | 0 | 305,749$ | 0$ | 0$ | 58,040,725$ | 11,000,725$ | 63,600,000$ | 5,559,275$ | 205,809,667$ | 205,809,667$ |
| 16 | Las Vegas | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 144967 | 143371 | 51950 | 68962 | 30714 | 58.93% | 69.94% | 63.35% | 42.05% | 74.91% | 0 | 10731 - 59.62% | 1,617,521$ | 66,318,373$ | 18000 | 100 | 58,490,000$ | 59,490,000$ | 0$ | 56,825,373$ | 312,781$ | 56,825,373$ | 23 | 0 | 0$ | 0$ | 0 | 312,781$ | 0$ | 0$ | 58,516,666$ | 11,476,666$ | 63,600,000$ | 5,083,334$ | 79,785,574$ | 79,785,574$ |
| 17 | Minnesota | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 245120 | 204585 | 82000 | 164000 | 41000 | 99.64% | 99.80% | 100.00% | 100.00% | 100.00% | 0 | 17968 - 99.82% | 1,247,246$ | 51,137,100$ | 18000 | 100 | 54,405,000$ | 54,405,000$ | 0$ | 54,431,574$ | 290,936$ | 54,431,574$ | 23 | 0 | 0$ | 0$ | 0 | 290,936$ | 0$ | 0$ | 56,540,024$ | 9,500,024$ | 63,600,000$ | 7,059,976$ | 79,489,919$ | 79,489,919$ |
| 18 | Montreal | 6000 | 5000 | 2000 | 4000 | 1000 | 145 | 97 | 77 | 52 | 375 | 198375 | 144645 | 65837 | 121492 | 32217 | 80.64% | 70.56% | 80.29% | 74.08% | 78.58% | 0 | 13721 - 76.23% | 1,616,179$ | 66,263,348$ | 18000 | 100 | 63,743,047$ | 59,154,158$ | 0$ | 60,593,024$ | 340,872$ | 60,593,024$ | 21 | 0 | 0$ | 0$ | 0 | 340,872$ | 0$ | 0$ | 63,485,019$ | 16,445,019$ | 63,600,000$ | 114,981$ | 155,954,923$ | 155,954,923$ |
| 19 | Nashville | 6700 | 5800 | 3200 | 4500 | 1800 | 145 | 80 | 70 | 50 | 200 | 193436 | 210182 | 71948 | 126898 | 53811 | 70.42% | 88.39% | 54.84% | 68.78% | 72.91% | 0 | 16007 - 72.76% | 1,668,009$ | 68,388,360$ | 22000 | 100 | 65,280,000$ | 65,280,000$ | 0$ | 59,941,853$ | 349,091$ | 59,941,853$ | 22 | 0 | 0$ | 0$ | 0 | 349,091$ | 0$ | 0$ | 62,984,088$ | 15,944,088$ | 63,600,000$ | 615,912$ | 155,847,045$ | 155,847,045$ |
| 20 | Ottawa | 7500 | 6000 | 2000 | 5000 | 1500 | 175 | 100 | 100 | 95 | 400 | 164917 | 142303 | 50301 | 82000 | 30127 | 53.63% | 57.85% | 61.34% | 40.00% | 48.99% | 0 | 11455 - 52.07% | 1,657,602$ | 67,961,675$ | 22000 | 100 | 52,049,890$ | 45,091,557$ | 0$ | 49,836,942$ | 278,342$ | 49,836,942$ | 27 | 0 | 0$ | 0$ | 0 | 278,342$ | 0$ | 0$ | 53,684,884$ | 6,644,884$ | 63,600,000$ | 9,915,116$ | 247,742,802$ | 247,742,802$ |
| 21 | Philadelphie | 7000 | 5000 | 2500 | 3837 | 1200 | 110 | 80 | 60 | 50 | 150 | 260698 | 202057 | 98793 | 125705 | 49200 | 90.84% | 98.56% | 96.38% | 79.91% | 100.00% | 0 | 17962 - 91.94% | 1,571,565$ | 64,434,170$ | 19537 | 100 | 60,767,000$ | 59,237,000$ | 0$ | 61,367,674$ | 324,957$ | 61,367,674$ | 20 | 0 | 0$ | 0$ | 0 | 324,957$ | 0$ | 0$ | 63,586,554$ | 16,546,554$ | 63,600,000$ | 13,446$ | 113,646,580$ | 113,646,580$ |
| 22 | Pittsburgh | 6100 | 5150 | 2650 | 4300 | 1050 | 135 | 75 | 50 | 30 | 300 | 219805 | 205707 | 103101 | 169005 | 40146 | 87.89% | 97.42% | 94.89% | 95.86% | 93.25% | 0 | 17994 - 93.48% | 1,682,715$ | 68,991,320$ | 19250 | 100 | 57,219,892$ | 57,113,225$ | 0$ | 56,657,252$ | 305,989$ | 56,657,252$ | 21 | 0 | 0$ | 0$ | 0 | 305,989$ | 0$ | 0$ | 59,406,566$ | 12,366,566$ | 63,600,000$ | 4,193,434$ | 160,024,785$ | 160,024,785$ |
| 23 | Quebec | 7000 | 4000 | 3000 | 3500 | 1000 | 100 | 60 | 35 | 20 | 200 | 263083 | 164000 | 110362 | 143500 | 41000 | 91.67% | 100.00% | 89.73% | 100.00% | 100.00% | 0 | 17608 - 95.18% | 1,245,877$ | 51,080,970$ | 18500 | 100 | 52,893,011$ | 52,893,011$ | 0$ | 54,578,027$ | 282,850$ | 54,578,027$ | 23 | 1 | 0$ | 0$ | 0 | 282,850$ | 0$ | 0$ | 56,566,496$ | 9,526,496$ | 63,600,000$ | 7,033,504$ | 84,479,897$ | 84,479,897$ |
| 24 | Rangers | 6000 | 6000 | 2500 | 4000 | 1000 | 135 | 70 | 40 | 30 | 250 | 240477 | 211186 | 101642 | 162824 | 41000 | 97.75% | 85.85% | 99.16% | 99.28% | 100.00% | 0 | 18467 - 94.70% | 1,620,678$ | 66,447,815$ | 19500 | 100 | 44,780,000$ | 44,780,000$ | 0$ | 58,527,342$ | 239,465$ | 58,167,141$ | 28 | 0 | 0$ | 0$ | 0 | 239,465$ | 0$ | 0$ | 60,099,494$ | 13,059,494$ | 63,600,000$ | 3,500,506$ | 133,707,376$ | 133,707,376$ |
| 25 | San Jose | 6600 | 5600 | 2650 | 5000 | 1000 | 95 | 65 | 35 | 22 | 300 | 261589 | 216304 | 107300 | 182758 | 40102 | 96.67% | 94.21% | 98.76% | 89.15% | 97.81% | 0 | 19709 - 94.53% | 1,432,134$ | 58,717,491$ | 20850 | 100 | 54,591,000$ | 53,222,250$ | 0$ | 51,244,288$ | 291,930$ | 51,244,288$ | 24 | 0 | 0$ | 0$ | 0 | 291,930$ | 0$ | 0$ | 56,501,836$ | 9,461,836$ | 63,600,000$ | 7,098,164$ | 182,698,133$ | 182,698,133$ |
| 26 | St-Louis | 6500 | 5500 | 3500 | 3000 | 1500 | 200 | 100 | 99 | 75 | 395 | 144134 | 143204 | 57400 | 83003 | 30348 | 54.08% | 63.51% | 40.00% | 67.48% | 49.35% | 0 | 11173 - 55.86% | 1,635,183$ | 67,042,485$ | 20000 | 100 | 55,550,000$ | 55,550,000$ | 0$ | 58,473,624$ | 297,059$ | 58,473,624$ | 22 | 0 | 0$ | 0$ | 0 | 297,059$ | 0$ | 0$ | 61,799,877$ | 14,759,877$ | 63,600,000$ | 1,800,123$ | 313,538,521$ | 313,538,521$ |
| 27 | Tampa Bay | 6000 | 5000 | 2500 | 4000 | 1000 | 125 | 80 | 50 | 35 | 250 | 243218 | 200866 | 100527 | 162211 | 41000 | 98.87% | 97.98% | 98.08% | 98.91% | 100.00% | 0 | 18240 - 98.59% | 1,644,519$ | 67,425,265$ | 18500 | 100 | 61,492,000$ | 59,860,333$ | 0$ | 56,007,354$ | 325,267$ | 55,679,190$ | 21 | 1 | 0$ | 0$ | 0 | 328,834$ | 0$ | 0$ | 59,131,736$ | 12,091,736$ | 63,600,000$ | 4,468,264$ | 197,373,567$ | 197,373,567$ |
| 28 | Toronto | 6000 | 5000 | 2500 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 245194 | 204648 | 102304 | 164000 | 41000 | 99.67% | 99.83% | 99.81% | 100.00% | 100.00% | 0 | 18467 - 99.82% | 1,284,852$ | 52,678,920$ | 18500 | 100 | 51,435,002$ | 49,568,334$ | 0$ | 51,459,613$ | 275,053$ | 51,459,613$ | 24 | 0 | 0$ | 0$ | 0 | 275,053$ | 0$ | 0$ | 54,798,112$ | 7,758,112$ | 63,600,000$ | 8,801,888$ | 46,167,485$ | 46,167,485$ |
| 29 | Vancouver | 5000 | 7000 | 4000 | 4000 | 2000 | 80 | 60 | 40 | 20 | 160 | 205000 | 220458 | 106648 | 164000 | 58403 | 100.00% | 76.81% | 65.03% | 100.00% | 71.22% | 0 | 18403 - 83.65% | 1,134,582$ | 46,517,880$ | 22000 | 100 | 53,715,000$ | 53,715,000$ | 0$ | 55,267,786$ | 287,246$ | 55,267,786$ | 20 | 0 | 0$ | 0$ | 0 | 287,246$ | 0$ | 0$ | 58,389,250$ | 11,349,250$ | 63,600,000$ | 5,210,750$ | 83,021,915$ | 83,021,915$ |
| 30 | Washington | 6000 | 5000 | 2500 | 4000 | 1000 | 130 | 85 | 40 | 30 | 220 | 240874 | 166496 | 101683 | 163317 | 41000 | 97.92% | 81.22% | 99.20% | 99.58% | 100.00% | 0 | 17399 - 94.05% | 1,547,625$ | 63,452,610$ | 18500 | 100 | 65,138,000$ | 65,138,000$ | 0$ | 59,140,312$ | 348,332$ | 59,140,312$ | 22 | 0 | 0$ | 0$ | 0 | 348,332$ | 0$ | 0$ | 62,432,138$ | 15,392,138$ | 63,600,000$ | 1,167,862$ | 89,036,967$ | 89,036,967$ |
| 31 | Winnipeg | 6500 | 5500 | 2500 | 4000 | 1500 | 95 | 65 | 45 | 35 | 195 | 260159 | 214398 | 100937 | 162027 | 55371 | 97.62% | 95.08% | 98.48% | 98.80% | 90.03% | 0 | 19339 - 96.69% | 1,455,157$ | 59,661,430$ | 20000 | 100 | 59,707,000$ | 58,540,333$ | 0$ | 57,439,740$ | 319,289$ | 57,364,875$ | 21 | 0 | 0$ | 0$ | 0 | 319,289$ | 0$ | 0$ | 60,617,479$ | 13,577,479$ | 63,600,000$ | 2,982,521$ | 101,388,588$ | 101,388,588$ |