| 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 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 44,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Anaheim Ducks | 8000 | 4000 | 5000 | 2000 | 1000 | 110 | 65 | 45 | 35 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 108 | 37,300,000$ | 37,300,000$ | 6,000,000$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 25,839,162$ | 25,839,162$ |
| 2 | Boston Bruins | 8000 | 4000 | 5000 | 2000 | 1000 | 105 | 59 | 41 | 29 | 202 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 128 | 64,500,000$ | 64,500,000$ | 700,000$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 21,050,466$ | 21,050,466$ |
| 3 | Buffalo Sabres | 8000 | 4000 | 5000 | 2000 | 1000 | 101 | 61 | 41 | 32 | 206 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 113 | 28,500,000$ | 28,500,000$ | 5,900,000$ | 0$ | 0$ | 0$ | 10 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 43,205,970$ | 43,205,970$ |
| 4 | Calgary Flames | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 90 | 39,600,000$ | 39,600,000$ | 2,200,000$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 27,221,956$ | 27,221,956$ |
| 5 | Carolina Hurricanes | 8000 | 4000 | 5000 | 2000 | 1000 | 96 | 56 | 41 | 29 | 195 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 96 | 27,900,000$ | 27,900,000$ | 0$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 45,153,089$ | 45,153,089$ |
| 6 | Chicago Blackhawks | 8000 | 4000 | 5000 | 2000 | 1000 | 105 | 63 | 45 | 33 | 209 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 123 | 59,700,000$ | 59,700,000$ | 195,625$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 31,870,604$ | 31,870,604$ |
| 7 | Colorado Avalanche | 8000 | 4000 | 5000 | 2000 | 1000 | 127 | 73 | 53 | 40 | 235 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 147 | 52,000,000$ | 52,000,000$ | 0$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 20,019,350$ | 20,019,350$ |
| 8 | Columbus Blue Jackets | 8000 | 4000 | 5000 | 2000 | 1000 | 103 | 61 | 42 | 31 | 209 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 126 | 47,400,000$ | 47,400,000$ | 0$ | 0$ | 0$ | 0$ | 14 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 29,408,921$ | 29,408,921$ |
| 9 | Dallas Stars | 8000 | 4000 | 5000 | 2000 | 1000 | 104 | 62 | 42 | 31 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 113 | 42,200,000$ | 42,200,000$ | 0$ | 0$ | 0$ | 0$ | 13 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 15,197,092$ | 15,197,092$ |
| 10 | Detroit Red Wings | 8000 | 4000 | 5000 | 2000 | 1000 | 110 | 63 | 44 | 35 | 219 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 135 | 50,700,000$ | 50,700,000$ | 0$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 62,708,680$ | 62,708,680$ |
| 11 | Edmonton Oilers | 8000 | 4000 | 5000 | 2000 | 1000 | 110 | 65 | 45 | 38 | 232 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 121 | 72,800,000$ | 72,800,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 22,072,526$ | 22,072,526$ |
| 12 | Florida Panthers | 8000 | 4000 | 5000 | 2000 | 1000 | 103 | 60 | 42 | 32 | 208 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 107 | 57,000,000$ | 57,000,000$ | 0$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 13,839,127$ | 13,839,127$ |
| 13 | Los Angeles Kings | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 205 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 106 | 47,100,000$ | 47,100,000$ | 0$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 22,406,578$ | 22,406,578$ |
| 14 | Minnesota Wild | 8000 | 4000 | 5000 | 2000 | 1000 | 94 | 54 | 42 | 30 | 189 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 30,200,000$ | 30,200,000$ | 4,000,000$ | 0$ | 0$ | 0$ | 13 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 36,387,908$ | 36,387,908$ |
| 15 | Montreal Canadiens | 8000 | 4000 | 5000 | 2000 | 1000 | 97 | 55 | 37 | 26 | 155 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 108 | 65,200,000$ | 65,200,000$ | 3,300,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 21,755,793$ | 21,755,793$ |
| 16 | Nashville Predators | 8000 | 4000 | 5000 | 2000 | 1000 | 99 | 60 | 40 | 30 | 204 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 39,000,000$ | 39,000,000$ | 6,950,000$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 15,338,231$ | 15,338,231$ |
| 17 | New Jersey Devils | 8000 | 4000 | 5000 | 2000 | 1000 | 113 | 71 | 49 | 39 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 142 | 63,400,000$ | 63,400,000$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 52,779,630$ | 52,779,630$ |
| 18 | New York Islanders | 8000 | 4000 | 5000 | 2000 | 1000 | 105 | 63 | 43 | 33 | 213 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 117 | 64,600,000$ | 64,600,000$ | 650,000$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 20,400,637$ | 20,400,637$ |
| 19 | New York Rangers | 8000 | 4000 | 5000 | 2000 | 1000 | 103 | 61 | 41 | 32 | 206 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 126 | 41,100,000$ | 41,100,000$ | 0$ | 0$ | 0$ | 0$ | 14 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 38,792,272$ | 38,792,272$ |
| 20 | Ottawa Senators | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 35 | 30 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 114 | 60,400,000$ | 60,400,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 45,493,269$ | 45,493,269$ |
| 21 | Philadelphia Flyers | 8000 | 4000 | 5000 | 2000 | 1000 | 102 | 62 | 42 | 32 | 204 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 127 | 50,000,000$ | 50,000,000$ | 167,500$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 32,549,926$ | 32,549,926$ |
| 22 | Pittsburgh Penguins | 8000 | 4000 | 5000 | 2000 | 1000 | 102 | 62 | 42 | 32 | 202 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 118 | 42,600,000$ | 42,600,000$ | 0$ | 0$ | 0$ | 0$ | 14 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 19,645,243$ | 19,645,243$ |
| 23 | San Jose Sharks | 8000 | 4000 | 5000 | 2000 | 1000 | 95 | 55 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 144 | 55,900,000$ | 55,900,000$ | 900,000$ | 0$ | 0$ | 0$ | 13 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 34,144,462$ | 34,144,462$ |
| 24 | Seattle Kraken | 8000 | 4000 | 5000 | 2000 | 1000 | 85 | 50 | 30 | 25 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 90 | 40,600,000$ | 40,600,000$ | 2,700,000$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 24,026,559$ | 24,026,559$ |
| 25 | St. Louis Blues | 8000 | 4000 | 5000 | 2000 | 1000 | 110 | 65 | 48 | 36 | 216 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 139 | 55,000,000$ | 55,000,000$ | 0$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 44,122,674$ | 44,122,674$ |
| 26 | Tampa Bay Lightning | 8000 | 4000 | 5000 | 2000 | 1000 | 99 | 57 | 37 | 27 | 197 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 92 | 40,800,000$ | 40,800,000$ | 3,000,000$ | 0$ | 0$ | 0$ | 13 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 37,500,151$ | 37,500,151$ |
| 27 | Toronto Maple Leafs | 8000 | 4000 | 5000 | 2000 | 1000 | 112 | 67 | 47 | 37 | 213 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 112 | 38,100,000$ | 38,100,000$ | 0$ | 0$ | 0$ | 0$ | 13 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 25,294,436$ | 25,294,436$ |
| 28 | Utah Mammoth | 8000 | 4000 | 5000 | 2000 | 1000 | 106 | 65 | 43 | 32 | 211 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 138 | 52,200,000$ | 52,200,000$ | 0$ | 0$ | 0$ | 0$ | 14 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 47,737,808$ | 47,737,808$ |
| 29 | Vancouver Canucks | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 202 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 104 | 37,700,000$ | 37,700,000$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 19,669,713$ | 19,669,713$ |
| 30 | Vegas Golden Knights | 8000 | 4000 | 5000 | 2000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 93 | 37,200,000$ | 37,200,000$ | 7,900,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 11,159,276$ | 11,159,276$ |
| 31 | Washington Capitals | 8000 | 4000 | 5000 | 2000 | 1000 | 102 | 60 | 40 | 31 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 118 | 44,500,000$ | 44,500,000$ | 2,500,000$ | 0$ | 0$ | 0$ | 12 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 22,695,241$ | 22,695,241$ |
| 32 | Winnipeg Jets | 8000 | 4000 | 5000 | 2000 | 1000 | 112 | 67 | 47 | 37 | 213 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 134 | 66,100,000$ | 66,100,000$ | 0$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -44,000,000$ | 74,000,000$ | 74,000,000$ | 38,074,097$ | 38,074,097$ |