| 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 61,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Anaheim Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 89 | 54 | 28 | 21 | 186 | 12000 | 9967 | 4000 | 8000 | 1977 | 100.00% | 99.67% | 100.00% | 100.00% | 98.85% | 39 | 17972 - 99.84% | 1,126,970$ | 2,253,940$ | 18000 | 100 | 94,000,000$ | 94,000,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 29,845,130$ | 29,845,130$ |
| 2 | Boston Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 55 | 35 | 17 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 87,752,562$ | 87,752,562$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 27,569,367$ | 27,569,367$ |
| 3 | Buffalo Sabres | 5 | 5000 | 2000 | 4000 | 1000 | 110 | 60 | 40 | 25 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 12005 | 100 | 66,900,000$ | 66,900,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 27,900,976$ | 27,900,976$ |
| 4 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 50 | 30 | 10 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 88,630,850$ | 88,630,850$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 9,198,830$ | 9,198,830$ |
| 5 | Carolina Hurricanes | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 63,457,125$ | 63,457,125$ | 0$ | 0$ | 0$ | 0$ | 23 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 33,119,462$ | 33,119,462$ |
| 6 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 75 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 64,420,600$ | 64,420,600$ | 0$ | 0$ | 0$ | 0$ | 23 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 21,830,781$ | 21,830,781$ |
| 7 | Colorado Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 92 | 60 | 35 | 23 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 75,853,000$ | 75,853,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 4,894,212$ | 4,894,212$ |
| 8 | Columbus Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 50 | 30 | 15 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 80,445,938$ | 80,445,938$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 5,668,674$ | 5,668,674$ |
| 9 | Dallas Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 80 | 60 | 30 | 120 | 12000 | 7175 | 2521 | 5954 | 2000 | 100.00% | 71.75% | 63.03% | 74.43% | 100.00% | 39 | 14825 - 82.36% | 1,171,940$ | 2,343,880$ | 18000 | 100 | 85,640,000$ | 85,640,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 15,838,622$ | 15,838,622$ |
| 10 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 50 | 28 | 15 | 160 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 78,204,625$ | 78,204,625$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 25,932,942$ | 25,932,942$ |
| 11 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 91,450,000$ | 91,450,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 41,514,776$ | 41,514,776$ |
| 12 | Florida Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 35 | 20 | 10 | 125 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 830,000$ | 1,660,000$ | 18000 | 100 | 92,475,000$ | 92,475,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 33,723,065$ | 33,723,065$ |
| 13 | Los Angeles Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 91,215,375$ | 91,215,375$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 2,388,255$ | 2,388,255$ |
| 14 | Minnesota Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 60 | 37 | 20 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 84,598,750$ | 84,598,750$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 28,620,836$ | 28,620,836$ |
| 15 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 75,761,225$ | 75,761,225$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 13,940,084$ | 13,940,084$ |
| 16 | Nashville Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 11893 | 9839 | 4000 | 7261 | 1989 | 99.11% | 98.39% | 100.00% | 90.76% | 99.45% | 39 | 17491 - 97.17% | 1,249,483$ | 2,498,965$ | 18000 | 100 | 94,424,188$ | 94,424,188$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 29,250,547$ | 29,250,547$ |
| 17 | New Jersey Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 40 | 20 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 77,467,500$ | 77,467,500$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 10,516,248$ | 10,516,248$ |
| 18 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 77,582,500$ | 77,582,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 45,105,815$ | 45,105,815$ |
| 19 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 58 | 35 | 17 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 85,231,625$ | 85,231,625$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 8,048,621$ | 8,048,621$ |
| 20 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 48 | 25 | 160 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 88,032,000$ | 88,032,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 33,571,252$ | 33,571,252$ |
| 21 | Philadelphia Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 12000 | 9920 | 4000 | 8000 | 2000 | 100.00% | 99.20% | 100.00% | 100.00% | 100.00% | 39 | 17960 - 99.78% | 1,247,600$ | 2,495,200$ | 18000 | 100 | 82,662,825$ | 82,662,825$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 9,176,486$ | 9,176,486$ |
| 22 | Pittsburgh Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 500 | 149 | 148 | 147 | 999 | 4800 | 4264 | 1600 | 3200 | 800 | 40.00% | 42.64% | 40.00% | 40.00% | 40.00% | 39 | 7332 - 40.73% | 2,270,868$ | 4,541,736$ | 18000 | 100 | 90,147,875$ | 90,147,875$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 73,883,642$ | 73,883,642$ |
| 23 | San Jose Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 70,518,762$ | 70,518,762$ | 0$ | 0$ | 0$ | 0$ | 23 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 2,053,334$ | 2,053,334$ |
| 24 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 63,165,000$ | 63,165,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 5,968,333$ | 5,968,333$ |
| 25 | St. Louis Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 76 | 55 | 35 | 20 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 92,818,000$ | 92,818,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 40,327,026$ | 40,327,026$ |
| 26 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 11710 | 10000 | 4000 | 8000 | 1991 | 97.58% | 100.00% | 100.00% | 100.00% | 99.55% | 39 | 17851 - 99.17% | 1,234,600$ | 2,469,200$ | 18000 | 100 | 77,607,625$ | 77,607,625$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 17,013,583$ | 17,013,583$ |
| 27 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 68 | 55 | 31 | 22 | 135 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 87,437,750$ | 87,437,750$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 20,195,578$ | 20,195,578$ |
| 28 | Utah Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 87 | 58 | 35 | 20 | 185 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 70,716,724$ | 70,716,724$ | 0$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 21,211,486$ | 21,211,486$ |
| 29 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 86 | 56 | 32 | 19 | 182 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 71,964,812$ | 71,964,812$ | 0$ | 0$ | 0$ | 0$ | 20 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 27,588,852$ | 27,588,852$ |
| 30 | Vegas Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 12000 | 10000 | 4000 | 7007 | 1963 | 100.00% | 100.00% | 100.00% | 87.59% | 98.15% | 39 | 17485 - 97.14% | 1,253,888$ | 2,507,775$ | 18000 | 100 | 88,739,500$ | 88,739,500$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 10,684,937$ | 10,684,937$ |
| 31 | Washington Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 83 | 51 | 26 | 16 | 170 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 74,097,250$ | 74,097,250$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 535,138$ | 535,138$ |
| 32 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 51 | 1 | 16 | 174 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 66,080,937$ | 66,080,937$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 41,748,139$ | 41,748,139$ |