| 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 |
| 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 | Capacity | Team Popularity | Players Total Salaries | Players Total Salaries Cap | 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 70,600,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 52753 | 42809 | 17812 | 34746 | 8792 | 97.69% | 95.13% | 98.96% | 96.52% | 97.69% | 32 | 17435 - 96.86% | 1,171,066$ | 10,539,595$ | 18000 | 100 | 88,640,238$ | 88,640,238$ | 0$ | 17,022,887$ | 88,640,238$ | 16,608,934$ | 20 | 1 | 0$ | 37,474,116$ | 143 | 515,174$ | 73,669,882$ | 76,313,952$ | 88,640,238$ | 18,040,238$ | 95,500,000$ | 6,859,762$ | 45,522,022$ | 9,251,768$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 52005 | 42819 | 16854 | 34682 | 8457 | 96.31% | 95.15% | 93.63% | 96.34% | 93.97% | 32 | 17202 - 95.57% | 1,152,453$ | 10,372,081$ | 18000 | 100 | 79,100,000$ | 79,100,000$ | 8,823,000$ | 15,929,957$ | 79,100,000$ | 15,507,545$ | 20 | 1 | 0$ | 36,878,510$ | 143 | 460,345$ | 65,829,335$ | 67,981,056$ | 87,923,000$ | 17,323,000$ | 95,500,000$ | 7,577,000$ | 37,602,415$ | 8,964,196$ |
| 3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 51751 | 42507 | 17320 | 34456 | 8719 | 95.84% | 94.46% | 96.22% | 95.71% | 96.88% | 32 | 17195 - 95.53% | 1,154,453$ | 10,390,074$ | 18000 | 100 | 93,919,998$ | 93,919,998$ | 0$ | 16,864,479$ | 93,919,998$ | 16,686,322$ | 21 | 0 | 0$ | 36,942,485$ | 143 | 545,517$ | 78,008,931$ | 80,833,181$ | 93,919,998$ | 23,319,998$ | 95,500,000$ | 1,580,002$ | 40,043,350$ | -1,322,493$ |
| 4 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 50773 | 43919 | 17171 | 34521 | 8596 | 94.02% | 97.60% | 95.39% | 95.89% | 95.51% | 32 | 17220 - 95.67% | 1,150,096$ | 10,350,867$ | 18000 | 100 | 96,633,332$ | 96,633,332$ | 0$ | 17,112,783$ | 96,633,332$ | 16,934,626$ | 22 | 0 | 0$ | 36,803,083$ | 143 | 561,111$ | 80,238,873$ | 83,180,812$ | 96,633,332$ | 26,033,332$ | 95,500,000$ | -1,133,332$ | 35,024,164$ | -8,664,524$ |
| 5 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 51901 | 41795 | 17189 | 34925 | 8573 | 96.11% | 92.88% | 95.49% | 97.01% | 95.26% | 32 | 17154 - 95.30% | 1,149,198$ | 10,342,783$ | 18000 | 100 | 64,620,829$ | 64,620,829$ | 20,196,500$ | 11,774,978$ | 64,620,829$ | 11,418,648$ | 23 | 0 | 0$ | 36,774,340$ | 143 | 382,878$ | 54,751,554$ | 57,707,221$ | 84,817,329$ | 14,217,329$ | 95,500,000$ | 10,682,671$ | 28,164,325$ | 9,753,549$ |
| 6 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 46185 | 37096 | 14946 | 31088 | 7518 | 96.22% | 92.74% | 93.41% | 97.15% | 93.98% | 33 | 17104 - 95.02% | 1,145,720$ | 9,165,762$ | 18000 | 100 | 94,751,083$ | 94,751,083$ | 0$ | 16,329,226$ | 94,751,083$ | 15,921,178$ | 20 | 0 | 0$ | 37,808,768$ | 143 | 550,294$ | 78,692,042$ | 82,069,988$ | 94,751,083$ | 24,151,083$ | 95,500,000$ | 748,917$ | 37,976,268$ | -3,777,727$ |
| 7 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 50973 | 42819 | 17410 | 35083 | 8785 | 94.39% | 95.15% | 96.72% | 97.45% | 97.61% | 32 | 17230 - 95.72% | 1,151,597$ | 10,364,373$ | 18000 | 100 | 94,200,563$ | 94,200,563$ | 0$ | 16,356,734$ | 94,200,563$ | 15,706,730$ | 22 | 0 | 0$ | 36,851,104$ | 143 | 547,130$ | 78,239,590$ | 80,274,766$ | 94,200,563$ | 23,600,563$ | 95,500,000$ | 1,299,437$ | 53,674,310$ | 12,737,585$ |
| 8 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 190 | 140 | 100 | 80 | 400 | 38910 | 32658 | 12900 | 25587 | 6356 | 72.06% | 72.57% | 71.67% | 71.08% | 70.62% | 32 | 12935 - 71.86% | 1,167,727$ | 10,509,542$ | 18000 | 100 | 75,069,262$ | 75,069,262$ | 14,972,000$ | 13,419,238$ | 75,069,262$ | 13,241,081$ | 22 | 0 | 0$ | 37,367,260$ | 143 | 437,180$ | 62,516,740$ | 66,014,234$ | 90,041,262$ | 19,441,262$ | 95,500,000$ | 5,458,738$ | 34,260,676$ | 7,946,914$ |
| 9 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 50205 | 42526 | 17680 | 35061 | 8366 | 92.97% | 94.50% | 98.22% | 97.39% | 92.96% | 32 | 17093 - 94.96% | 1,133,728$ | 10,203,555$ | 18000 | 100 | 95,225,012$ | 95,225,012$ | 0$ | 17,143,527$ | 95,225,012$ | 16,965,370$ | 20 | 0 | 0$ | 36,279,307$ | 143 | 553,017$ | 79,081,431$ | 81,250,312$ | 95,225,012$ | 24,625,012$ | 95,500,000$ | 274,988$ | 38,798,010$ | -3,552,490$ |
| 10 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 45165 | 37664 | 15411 | 30835 | 7788 | 94.09% | 94.16% | 96.32% | 96.36% | 97.35% | 33 | 17108 - 95.04% | 1,145,249$ | 9,161,989$ | 18000 | 100 | 83,291,667$ | 83,291,667$ | 3,937,750$ | 14,638,161$ | 83,291,667$ | 14,460,004$ | 22 | 0 | 0$ | 37,793,205$ | 143 | 484,435$ | 69,274,205$ | 73,655,582$ | 87,229,417$ | 16,629,417$ | 95,500,000$ | 8,270,583$ | 41,401,975$ | 8,135,064$ |
| 11 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 51909 | 42836 | 17838 | 35430 | 8477 | 96.13% | 95.19% | 99.10% | 98.42% | 94.19% | 32 | 17388 - 96.60% | 1,157,579$ | 10,418,212$ | 18000 | 100 | 92,316,126$ | 92,316,126$ | 3,000,000$ | 16,675,284$ | 92,316,126$ | 16,497,118$ | 20 | 0 | 0$ | 37,042,532$ | 143 | 536,300$ | 76,690,900$ | 79,400,178$ | 95,316,126$ | 24,716,126$ | 95,500,000$ | 183,874$ | 38,252,031$ | -1,485,613$ |
| 12 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 51814 | 42587 | 17737 | 33610 | 8718 | 95.95% | 94.64% | 98.54% | 93.36% | 96.87% | 32 | 17163 - 95.35% | 1,154,911$ | 10,394,202$ | 18000 | 100 | 95,075,000$ | 95,075,000$ | 0$ | 17,116,805$ | 95,075,000$ | 16,938,648$ | 23 | 0 | 0$ | 36,957,163$ | 143 | 552,155$ | 78,958,165$ | 81,905,681$ | 95,075,000$ | 24,475,000$ | 95,500,000$ | 425,000$ | 42,944,487$ | 566,100$ |
| 13 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 98 | 62 | 39 | 25 | 210 | 45382 | 38367 | 15396 | 31031 | 7677 | 94.55% | 95.92% | 96.23% | 96.97% | 95.96% | 33 | 17232 - 95.73% | 1,164,090$ | 9,312,719$ | 18000 | 100 | 94,450,000$ | 94,450,000$ | 0$ | 16,804,885$ | 94,450,000$ | 16,296,268$ | 20 | 0 | 0$ | 38,414,966$ | 143 | 548,563$ | 78,444,509$ | 81,758,105$ | 94,450,000$ | 23,850,000$ | 95,500,000$ | 1,050,000$ | 37,673,237$ | -3,070,657$ |
| 14 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 51398 | 43019 | 17596 | 34406 | 8543 | 95.18% | 95.60% | 97.76% | 95.57% | 94.92% | 32 | 17218 - 95.66% | 1,151,141$ | 10,360,271$ | 18000 | 100 | 84,799,981$ | 84,799,981$ | 5,500,000$ | 15,729,889$ | 84,799,981$ | 15,551,732$ | 21 | 0 | 0$ | 36,836,519$ | 143 | 493,103$ | 70,513,729$ | 73,989,344$ | 90,299,981$ | 19,699,981$ | 95,500,000$ | 5,200,019$ | 49,924,827$ | 15,278,281$ |
| 15 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 52161 | 44231 | 17472 | 34107 | 8601 | 96.59% | 98.29% | 97.07% | 94.74% | 95.57% | 32 | 17397 - 96.65% | 1,166,849$ | 10,501,637$ | 18000 | 100 | 89,479,166$ | 89,479,166$ | 5,750,000$ | 15,856,914$ | 89,479,166$ | 15,283,642$ | 21 | 0 | 0$ | 37,339,154$ | 143 | 519,995$ | 74,359,285$ | 77,473,253$ | 95,229,166$ | 24,629,166$ | 95,500,000$ | 270,834$ | 41,633,552$ | 4,014,447$ |
| 16 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 51372 | 43250 | 17184 | 35239 | 8548 | 95.13% | 96.11% | 95.47% | 97.89% | 94.98% | 32 | 17288 - 96.05% | 1,153,111$ | 10,378,003$ | 18000 | 100 | 94,233,812$ | 94,233,812$ | 0$ | 16,959,252$ | 94,233,812$ | 16,781,095$ | 20 | 0 | 0$ | 36,899,566$ | 143 | 547,321$ | 78,266,903$ | 81,898,102$ | 94,233,812$ | 23,633,812$ | 95,500,000$ | 1,266,188$ | 43,781,891$ | 1,350,569$ |
| 17 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 50557 | 43011 | 17189 | 34173 | 8717 | 93.62% | 95.58% | 95.49% | 94.93% | 96.86% | 32 | 17072 - 94.84% | 1,143,768$ | 10,293,916$ | 18000 | 100 | 86,555,001$ | 86,555,001$ | 0$ | 14,675,988$ | 77,055,001$ | 14,115,645$ | 22 | 1 | 0$ | 36,600,590$ | 143 | 503,190$ | 71,956,170$ | 74,208,992$ | 77,055,001$ | 6,455,001$ | 95,500,000$ | 18,444,999$ | 44,207,730$ | 9,140,092$ |
| 18 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 52865 | 42629 | 17717 | 35123 | 8376 | 97.90% | 94.73% | 98.43% | 97.56% | 93.07% | 32 | 17412 - 96.73% | 1,162,970$ | 10,466,729$ | 18000 | 100 | 92,668,102$ | 92,668,102$ | 0$ | 16,708,322$ | 92,668,102$ | 16,530,165$ | 20 | 0 | 0$ | 37,215,036$ | 143 | 538,322$ | 76,980,046$ | 80,057,978$ | 92,668,102$ | 22,068,102$ | 95,500,000$ | 2,831,898$ | 44,625,026$ | 4,407,494$ |
| 19 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 50876 | 44496 | 17092 | 34785 | 8781 | 94.21% | 98.88% | 94.96% | 96.63% | 97.57% | 32 | 17337 - 96.31% | 1,159,148$ | 10,432,333$ | 18000 | 100 | 95,275,000$ | 95,275,000$ | 1,930,000$ | 16,852,153$ | 95,275,000$ | 16,398,853$ | 23 | 0 | 0$ | 37,092,740$ | 143 | 559,052$ | 79,944,436$ | 82,876,937$ | 97,205,000$ | 26,605,000$ | 95,500,000$ | -1,705,000$ | 47,890,234$ | 4,534,602$ |
| 20 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 175 | 120 | 75 | 55 | 450 | 25881 | 20277 | 8100 | 15516 | 3679 | 47.93% | 45.06% | 45.00% | 43.10% | 40.88% | 32 | 8161 - 45.34% | 1,063,878$ | 9,574,903$ | 18000 | 100 | 90,399,999$ | 90,399,999$ | 0$ | 16,074,701$ | 90,399,999$ | 15,871,401$ | 21 | 0 | 0$ | 34,044,100$ | 143 | 525,287$ | 75,116,041$ | 78,390,884$ | 90,399,999$ | 19,799,999$ | 95,500,000$ | 5,100,001$ | 41,086,608$ | -766,498$ |
| 21 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 51150 | 43600 | 17314 | 34041 | 8540 | 94.72% | 96.89% | 96.19% | 94.56% | 94.89% | 32 | 17183 - 95.46% | 1,150,135$ | 10,351,214$ | 18000 | 100 | 89,221,667$ | 89,221,667$ | 7,500,000$ | 15,841,999$ | 82,965,834$ | 15,434,114$ | 20 | 2 | 0$ | 36,804,316$ | 143 | 524,262$ | 74,969,466$ | 79,071,850$ | 90,465,834$ | 19,865,834$ | 95,500,000$ | 5,034,166$ | 41,518,194$ | 1,870,167$ |
| 22 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 51139 | 42995 | 17660 | 34109 | 8697 | 94.70% | 95.54% | 98.11% | 94.75% | 96.63% | 32 | 17178 - 95.43% | 1,150,959$ | 10,358,633$ | 18000 | 100 | 84,935,714$ | 84,935,714$ | 9,400,000$ | 15,319,602$ | 84,935,714$ | 15,114,145$ | 20 | 0 | 0$ | 36,830,695$ | 143 | 493,883$ | 70,625,269$ | 74,599,954$ | 94,335,714$ | 23,735,714$ | 95,500,000$ | 1,164,286$ | 48,629,225$ | 13,384,130$ |
| 23 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 50766 | 42555 | 17482 | 35510 | 8475 | 94.01% | 94.57% | 97.12% | 98.64% | 94.17% | 32 | 17199 - 95.55% | 1,142,588$ | 10,283,293$ | 18000 | 100 | 95,154,524$ | 95,154,524$ | 0$ | 17,179,770$ | 95,154,524$ | 17,001,612$ | 20 | 0 | 0$ | 36,562,820$ | 143 | 552,612$ | 79,023,516$ | 81,681,314$ | 95,154,524$ | 24,554,524$ | 95,500,000$ | 345,476$ | 53,125,401$ | 10,517,833$ |
| 24 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 46083 | 38545 | 15529 | 30590 | 7669 | 96.01% | 96.36% | 97.06% | 95.59% | 95.86% | 33 | 17302 - 96.12% | 1,159,364$ | 9,274,911$ | 18000 | 100 | 85,175,000$ | 85,175,000$ | 4,752,959$ | 16,265,089$ | 85,175,000$ | 16,086,929$ | 20 | 1 | 0$ | 38,259,008$ | 143 | 495,259$ | 70,822,037$ | 73,853,780$ | 89,927,959$ | 19,327,959$ | 95,500,000$ | 5,572,041$ | 33,449,643$ | 363,785$ |
| 25 | Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 250 | 200 | 150 | 100 | 500 | 21600 | 18000 | 7200 | 14400 | 3600 | 40.00% | 40.00% | 40.00% | 40.00% | 40.00% | 32 | 7200 - 40.00% | 1,406,000$ | 12,654,000$ | 18000 | 100 | 95,324,000$ | 95,324,000$ | 0$ | 17,069,214$ | 95,324,000$ | 16,891,057$ | 21 | 0 | 0$ | 44,992,000$ | 143 | 553,586$ | 79,162,798$ | 82,052,828$ | 95,324,000$ | 24,724,000$ | 95,500,000$ | 176,000$ | 58,574,500$ | 23,737,765$ |
| 26 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 51805 | 42894 | 17447 | 34739 | 8679 | 95.94% | 95.32% | 96.93% | 96.50% | 96.43% | 32 | 17285 - 96.03% | 1,157,845$ | 10,420,608$ | 18000 | 100 | 94,894,167$ | 94,894,167$ | 0$ | 17,084,596$ | 94,894,167$ | 16,906,439$ | 21 | 0 | 0$ | 37,051,051$ | 143 | 551,116$ | 78,809,588$ | 81,084,861$ | 94,894,167$ | 24,294,167$ | 95,500,000$ | 605,833$ | 43,711,762$ | 2,335,178$ |
| 27 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 50606 | 43658 | 17328 | 35267 | 8627 | 93.71% | 97.02% | 96.27% | 97.96% | 95.86% | 32 | 17276 - 95.98% | 1,149,884$ | 10,348,953$ | 18000 | 100 | 90,724,523$ | 90,724,523$ | 0$ | 16,488,800$ | 90,724,523$ | 16,126,717$ | 23 | 0 | 0$ | 36,796,277$ | 143 | 532,900$ | 76,204,700$ | 78,982,475$ | 90,724,523$ | 20,124,523$ | 95,500,000$ | 4,775,477$ | 38,663,245$ | -985,232$ |
| 28 | Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 52011 | 43400 | 17022 | 34645 | 8513 | 96.32% | 96.44% | 94.57% | 96.24% | 94.59% | 32 | 17288 - 96.04% | 1,157,902$ | 10,421,115$ | 18000 | 100 | 78,952,499$ | 78,952,499$ | 7,370,000$ | 14,121,948$ | 78,952,499$ | 13,627,691$ | 21 | 0 | 0$ | 37,052,853$ | 143 | 459,497$ | 65,708,071$ | 70,140,499$ | 86,322,499$ | 15,722,499$ | 95,500,000$ | 9,177,501$ | 51,874,276$ | 21,382,649$ |