| 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 | Current Bank Account | Projected Bank Account |
| 1 | Anaheim Mighty Ducks | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 36,528,888$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 43,145,000$ | 43,145,000$ |
| 2 | Boston Bruins | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 79,689,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 71,872,323$ | 71,872,323$ |
| 3 | California Golden Seals | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 65,539,561$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 40,571,863$ | 40,571,863$ |
| 4 | Carolina Hurricanes | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 54,360,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 73,628,087$ | 73,628,087$ |
| 5 | Chicago Blackhawks | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 64,335,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 72,870,689$ | 72,870,689$ |
| 6 | Colorado Avalanche | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 78,180,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 76,015,475$ | 76,015,475$ |
| 7 | Columbus Blue Jackets | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 72,133,667$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 96,146,449$ | 96,146,449$ |
| 8 | Detroit Red Wings | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 70,301,441$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 63,296,309$ | 63,296,309$ |
| 9 | Edmonton Oilers | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 78,193,783$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 100,535,379$ | 100,535,379$ |
| 10 | Florida Panthers | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 55,789,098$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 59,366,760$ | 59,366,760$ |
| 11 | Hamilton Mustangs | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 80,689,033$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 80,142,681$ | 80,142,681$ |
| 12 | Los Angeles Kings | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 82,924,689$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 202,249,386$ | 202,249,386$ |
| 13 | Montreal Canadiens | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 71,874,756$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 58,865,465$ | 58,865,465$ |
| 14 | New Jersey Devils | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 89,437,745$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 70,504,535$ | 70,504,535$ |
| 15 | New York Islanders | 5940 | 4860 | 1980 | 3960 | 1260 | 93 | 55 | 33 | 22 | 175 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 84,851,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 86,034,928$ | 86,034,928$ |
| 16 | New York Rangers | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 90,276,667$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 166,257,871$ | 166,257,871$ |
| 17 | Ottawa Senators | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 57,893,996$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 47,450,000$ | 47,450,000$ |
| 18 | Philadelphia Flyers | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 68,194,766$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 146,911,288$ | 146,911,288$ |
| 19 | Pittsburgh Penguins | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 67,555,715$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 141,013,771$ | 141,013,771$ |
| 20 | Quebec Nordiques | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 15,446,429$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 173,397,915$ | 173,397,915$ |
| 21 | San Jose Sharks | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 24,658,999$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 48,000,000$ | 48,000,000$ |
| 22 | Seattle Kraken | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 72,875,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 53,827,623$ | 53,827,623$ |
| 23 | St Louis Blues | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 56,784,307$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 49,782,820$ | 49,782,820$ |
| 24 | Tampa Bay Lightning | 6040 | 4960 | 2080 | 4060 | 1360 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18500 | 100 | 78,246,667$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 101,223,592$ | 101,223,592$ |
| 25 | Toronto Maple Leafs | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 66,032,445$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 55,137,252$ | 55,137,252$ |
| 26 | Vancouver Canucks | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 29,714,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 42,548,000$ | 42,548,000$ |
| 27 | Vegas Golden Knights | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 57,345,200$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 152,074,443$ | 152,074,443$ |
| 28 | Winnipeg Jets | 5940 | 4860 | 1980 | 3960 | 1260 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 31,455,063$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 41,911,465$ | 41,911,465$ |