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 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 | Current Bank Account | Projected Bank Account |
1 | Anaheim Mighty Ducks | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 188570 | 160648 | 62584 | 118943 | 41028 | 81.40% | 84.76% | 81.05% | 77.02% | 83.49% | 0 | 14661 - 81.45% | 1,098,053$ | 42,824,058$ | 18000 | 100 | 21,570,927$ | 21,570,927$ | 0$ | 19,899,930$ | 0$ | 19,899,930$ | 0 | 0 | 0$ | 0$ | 0 | 119,176$ | 0$ | 0$ | 110,557,185$ | 110,557,185$ |
2 | Boston Bruins | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 31 | 24 | 186 | 210915 | 171472 | 69738 | 145582 | 44330 | 91.05% | 90.47% | 90.31% | 94.26% | 90.21% | 0 | 16462 - 91.46% | 1,205,269$ | 47,005,476$ | 18000 | 100 | 74,744,860$ | 74,744,860$ | 0$ | 63,995,135$ | 0$ | 63,995,135$ | 0 | 0 | 0$ | 0$ | 0 | 412,955$ | 0$ | 0$ | 28,465,771$ | 28,465,771$ |
3 | Carolina Hurricanes | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 187962 | 160033 | 62171 | 119309 | 42089 | 81.14% | 84.43% | 80.51% | 77.25% | 85.65% | 0 | 14655 - 81.42% | 1,101,095$ | 42,942,695$ | 18000 | 100 | 69,302,572$ | 69,302,572$ | 0$ | 69,911,000$ | 0$ | 69,911,000$ | 0 | 0 | 0$ | 0$ | 0 | 382,887$ | 0$ | 0$ | 4,483,436$ | 4,483,436$ |
4 | Chicago Blackhawks | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 191432 | 161220 | 61786 | 120971 | 41853 | 82.63% | 85.06% | 80.01% | 78.33% | 85.17% | 0 | 14802 - 82.23% | 1,111,605$ | 43,352,612$ | 18000 | 100 | 63,373,672$ | 63,373,672$ | 0$ | 59,520,211$ | 0$ | 59,520,211$ | 0 | 0 | 0$ | 0$ | 0 | 350,131$ | 0$ | 0$ | 58,944,134$ | 58,944,134$ |
5 | Colorado Avalanche | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 188606 | 158794 | 63752 | 118219 | 42219 | 81.42% | 83.78% | 82.56% | 76.55% | 85.92% | 0 | 14656 - 81.42% | 1,102,326$ | 42,990,696$ | 18000 | 100 | 76,300,000$ | 76,300,000$ | 0$ | 75,216,512$ | 0$ | 75,216,512$ | 0 | 0 | 0$ | 0$ | 0 | 421,547$ | 0$ | 0$ | 44,110,840$ | 44,110,840$ |
6 | Columbus Blue Jackets | 5940 | 4860 | 1980 | 3960 | 1260 | 92 | 51 | 30 | 23 | 186 | 202648 | 172930 | 67668 | 129155 | 44991 | 87.48% | 91.24% | 87.63% | 83.63% | 91.56% | 0 | 15831 - 87.95% | 1,176,282$ | 45,875,002$ | 18000 | 100 | 76,955,528$ | 76,844,417$ | 0$ | 67,911,761$ | 0$ | 67,911,761$ | 0 | 0 | 0$ | 0$ | 0 | 425,169$ | 0$ | 0$ | 74,337,220$ | 74,337,220$ |
7 | Detroit Red Wings | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 187826 | 159772 | 63178 | 118142 | 41540 | 81.08% | 84.29% | 81.82% | 76.50% | 84.53% | 0 | 14627 - 81.26% | 1,097,498$ | 42,802,408$ | 18000 | 100 | 48,134,442$ | 48,134,442$ | 0$ | 60,409,184$ | 0$ | 60,409,184$ | 0 | 0 | 0$ | 0$ | 0 | 265,936$ | 0$ | 0$ | 42,378,801$ | 42,378,801$ |
8 | Edmonton Oilers | 5940 | 4860 | 1980 | 3960 | 1260 | 92 | 51 | 31 | 24 | 187 | 208591 | 169172 | 68438 | 142247 | 44388 | 90.04% | 89.25% | 88.63% | 92.11% | 90.33% | 0 | 16227 - 90.15% | 1,193,267$ | 46,537,413$ | 18000 | 100 | 67,070,005$ | 67,070,005$ | 0$ | 65,895,420$ | 0$ | 65,895,420$ | 0 | 0 | 0$ | 0$ | 0 | 370,553$ | 0$ | 0$ | 22,094,748$ | 22,094,748$ |
9 | Florida Panthers | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 187767 | 161578 | 61667 | 120113 | 42046 | 81.05% | 85.25% | 79.86% | 77.77% | 85.56% | 0 | 14697 - 81.65% | 1,102,748$ | 43,007,176$ | 18000 | 100 | 70,121,999$ | 69,485,333$ | 0$ | 67,584,200$ | 0$ | 67,584,200$ | 0 | 0 | 0$ | 0$ | 0 | 387,414$ | 0$ | 0$ | 36,448,263$ | 36,448,263$ |
10 | Hamilton Mustangs | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 189046 | 159399 | 62600 | 119389 | 41853 | 81.60% | 84.10% | 81.07% | 77.30% | 85.17% | 0 | 14674 - 81.52% | 1,102,211$ | 42,986,210$ | 18000 | 100 | 79,963,773$ | 79,963,773$ | 0$ | 83,460,999$ | 0$ | 83,460,999$ | 0 | 0 | 0$ | 0$ | 0 | 441,789$ | 0$ | 0$ | 2,190,381$ | 2,190,381$ |
11 | Los Angeles Kings | 5940 | 4860 | 1980 | 3960 | 1260 | 92 | 51 | 30 | 23 | 186 | 197753 | 171511 | 66974 | 130775 | 44391 | 85.36% | 90.49% | 86.73% | 84.68% | 90.34% | 0 | 15677 - 87.09% | 1,161,003$ | 45,279,100$ | 18000 | 100 | 83,310,327$ | 83,310,327$ | 0$ | 72,600,808$ | 0$ | 72,600,808$ | 0 | 0 | 0$ | 0$ | 0 | 460,278$ | 0$ | 0$ | 106,622,162$ | 106,622,162$ |
12 | Minnesota North Stars | 5940 | 4860 | 1980 | 3960 | 1260 | 89 | 45 | 29 | 21 | 187 | 211844 | 182198 | 73165 | 147036 | 45416 | 91.45% | 96.13% | 94.75% | 95.21% | 92.42% | 0 | 16914 - 93.97% | 1,177,450$ | 45,920,558$ | 18000 | 100 | 49,445,260$ | 49,445,260$ | 0$ | 53,893,566$ | 0$ | 53,893,566$ | 0 | 0 | 0$ | 0$ | 0 | 273,178$ | 0$ | 0$ | 3,553,879$ | 3,553,879$ |
13 | Montreal Canadiens | 5940 | 4860 | 1980 | 3960 | 1260 | 92 | 51 | 30 | 23 | 186 | 213527 | 176497 | 71740 | 138688 | 46392 | 92.17% | 93.12% | 92.90% | 89.80% | 94.41% | 0 | 16586 - 92.14% | 1,221,080$ | 47,622,110$ | 18000 | 100 | 69,509,567$ | 69,509,567$ | 0$ | 68,743,955$ | 0$ | 68,743,955$ | 0 | 0 | 0$ | 0$ | 0 | 384,031$ | 0$ | 0$ | 52,425,287$ | 52,425,287$ |
14 | New Jersey Devils | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 189735 | 160103 | 63075 | 122455 | 41752 | 81.90% | 84.47% | 81.68% | 79.29% | 84.97% | 0 | 14798 - 82.21% | 1,107,150$ | 43,178,845$ | 18000 | 100 | 77,566,246$ | 77,566,246$ | 0$ | 76,296,361$ | 0$ | 76,296,361$ | 0 | 0 | 0$ | 0$ | 0 | 428,543$ | 0$ | 0$ | 44,042,000$ | 44,042,000$ |
15 | New York Islanders | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 186787 | 161530 | 61677 | 119484 | 42317 | 80.63% | 85.22% | 79.87% | 77.37% | 86.12% | 0 | 14661 - 81.45% | 1,101,095$ | 42,942,697$ | 18000 | 100 | 92,075,500$ | 92,058,888$ | 0$ | 78,900,543$ | 0$ | 78,900,543$ | 0 | 0 | 0$ | 0$ | 0 | 508,704$ | 0$ | 0$ | 44,096,328$ | 44,096,328$ |
16 | New York Rangers | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 186135 | 159497 | 62371 | 118593 | 42505 | 80.35% | 84.15% | 80.77% | 76.79% | 86.50% | 0 | 14592 - 81.07% | 1,097,364$ | 42,797,198$ | 18000 | 100 | 81,061,667$ | 81,061,667$ | 0$ | 77,371,311$ | 0$ | 77,371,311$ | 0 | 0 | 0$ | 0$ | 0 | 447,855$ | 0$ | 0$ | 127,777,642$ | 127,777,642$ |
17 | Philadelphia Flyers | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 185774 | 161025 | 61664 | 117784 | 41904 | 80.19% | 84.96% | 79.85% | 76.27% | 85.27% | 0 | 14568 - 80.93% | 1,094,235$ | 42,675,152$ | 18000 | 100 | 80,030,166$ | 80,030,166$ | 0$ | 78,441,670$ | 0$ | 78,441,670$ | 0 | 0 | 0$ | 0$ | 0 | 442,156$ | 0$ | 0$ | 108,398,244$ | 108,398,244$ |
18 | Pittsburgh Penguins | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 192012 | 159920 | 62060 | 119659 | 42262 | 82.89% | 84.37% | 80.37% | 77.48% | 86.00% | 0 | 14767 - 82.04% | 1,112,721$ | 43,396,123$ | 18000 | 100 | 59,050,000$ | 59,050,000$ | 0$ | 58,347,782$ | 0$ | 58,347,782$ | 0 | 0 | 0$ | 0$ | 0 | 326,243$ | 0$ | 0$ | 76,876,441$ | 76,876,441$ |
19 | Quebec Nordiques | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 186015 | 160472 | 61980 | 118864 | 42198 | 80.30% | 84.66% | 80.26% | 76.96% | 85.87% | 0 | 14603 - 81.13% | 1,096,684$ | 42,770,657$ | 18000 | 100 | 49,133,334$ | 49,133,334$ | 0$ | 66,624,981$ | 0$ | 66,624,981$ | 0 | 0 | 0$ | 0$ | 0 | 271,455$ | 0$ | 0$ | 19,272,269$ | 19,272,269$ |
20 | Seattle Kraken | 5940 | 4860 | 1980 | 3960 | 1260 | 90 | 55 | 30 | 20 | 190 | 213273 | 142280 | 68651 | 146446 | 37968 | 92.06% | 75.07% | 88.90% | 94.82% | 77.26% | 0 | 15606 - 86.70% | 1,135,155$ | 44,271,039$ | 18000 | 100 | 73,412,706$ | 73,412,706$ | 0$ | 68,188,397$ | 0$ | 68,188,397$ | 0 | 0 | 0$ | 0$ | 0 | 405,595$ | 0$ | 0$ | 28,623,429$ | 28,623,429$ |
21 | St Louis Blues | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 24 | 188 | 186617 | 161909 | 62024 | 145602 | 41500 | 80.56% | 85.42% | 80.32% | 94.28% | 84.45% | 0 | 15324 - 85.14% | 1,111,764$ | 43,358,795$ | 18000 | 100 | 86,543,132$ | 86,543,132$ | 0$ | 86,335,566$ | 0$ | 86,335,566$ | 0 | 0 | 0$ | 0$ | 0 | 478,139$ | 0$ | 0$ | 60,453,190$ | 60,453,190$ |
22 | Tampa Bay Lightning | 6040 | 4960 | 2080 | 4060 | 1360 | 93 | 52 | 32 | 25 | 188 | 192652 | 160793 | 61827 | 120294 | 41782 | 81.78% | 83.12% | 76.22% | 75.97% | 78.77% | 0 | 14804 - 80.02% | 1,113,378$ | 43,421,758$ | 18500 | 100 | 79,369,000$ | 79,369,000$ | 0$ | 70,444,369$ | 0$ | 70,444,369$ | 0 | 0 | 0$ | 0$ | 0 | 438,503$ | 0$ | 0$ | 36,037,037$ | 36,037,037$ |
23 | Toronto Maple Leafs | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 186304 | 160034 | 60642 | 120453 | 42568 | 80.42% | 84.43% | 78.53% | 77.99% | 86.63% | 0 | 14615 - 81.20% | 1,098,692$ | 42,848,992$ | 18000 | 100 | 44,488,000$ | 44,488,000$ | 0$ | 51,107,339$ | 0$ | 51,107,339$ | 0 | 0 | 0$ | 0$ | 0 | 245,790$ | 0$ | 0$ | 32,111,766$ | 32,111,766$ |
24 | Vegas Golden Knights | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 52 | 32 | 25 | 188 | 189043 | 159932 | 62086 | 118107 | 42126 | 81.60% | 84.38% | 80.40% | 76.47% | 85.73% | 0 | 14649 - 81.38% | 1,103,072$ | 43,019,802$ | 18000 | 100 | 45,372,000$ | 45,372,000$ | 0$ | 59,995,153$ | 0$ | 59,995,153$ | 0 | 0 | 0$ | 0$ | 0 | 250,674$ | 0$ | 0$ | 28,056,353$ | 28,056,353$ |