| 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 67,450,000$ | 67,450,000$ | 0$ | 0$ | 0$ | 0$ | 12 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 32,095,937$ | 32,095,937$ |
| 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 | 73,474,812$ | 73,474,812$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 35,067,647$ | 35,067,647$ |
| 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 | 49,185,000$ | 49,185,000$ | 0$ | 0$ | 0$ | 0$ | 17 | 1 | 0$ | 0$ | 0 | 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 | 78,635,850$ | 78,635,850$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 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 | 43,136,125$ | 43,136,125$ | 0$ | 0$ | 0$ | 0$ | 14 | 1 | 0$ | 0$ | 0 | 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 | 29,975,000$ | 29,975,000$ | 0$ | 0$ | 0$ | 0$ | 10 | 1 | 0$ | 0$ | 0 | 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 | 61,675,000$ | 61,675,000$ | 0$ | 0$ | 0$ | 0$ | 16 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 7,264,433$ | 7,264,433$ |
| 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 | 53,995,938$ | 53,995,938$ | 0$ | 0$ | 0$ | 0$ | 14 | 1 | 0$ | 0$ | 0 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 64,425,000$ | 64,425,000$ | 0$ | 0$ | 0$ | 0$ | 12 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 22,002,612$ | 22,002,612$ |
| 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 | 57,989,625$ | 57,989,625$ | 0$ | 0$ | 0$ | 0$ | 16 | 1 | 0$ | 0$ | 0 | 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 | 60,250,000$ | 60,250,000$ | 0$ | 0$ | 0$ | 0$ | 11 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 49,003,376$ | 49,003,376$ |
| 12 | Florida Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 35 | 20 | 10 | 125 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 80,700,000$ | 80,700,000$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 42,023,065$ | 42,023,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 | 67,502,875$ | 67,502,875$ | 0$ | 0$ | 0$ | 0$ | 16 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 6,170,880$ | 6,170,880$ |
| 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 | 58,331,250$ | 58,331,250$ | 0$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 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 | 61,398,125$ | 61,398,125$ | 0$ | 0$ | 0$ | 0$ | 14 | 1 | 0$ | 0$ | 0 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 68,849,188$ | 68,849,188$ | 0$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 33,046,722$ | 33,046,722$ |
| 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 | 60,864,000$ | 60,864,000$ | 0$ | 0$ | 0$ | 0$ | 15 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 14,148,768$ | 14,148,768$ |
| 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 | 57,500,000$ | 57,500,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 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 | 72,773,125$ | 72,773,125$ | 0$ | 0$ | 0$ | 0$ | 15 | 1 | 0$ | 0$ | 0 | 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 | 72,369,500$ | 72,369,500$ | 0$ | 0$ | 0$ | 0$ | 16 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 38,457,467$ | 38,457,467$ |
| 21 | Philadelphia Flyers | 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 | 58,306,625$ | 58,306,625$ | 0$ | 0$ | 0$ | 0$ | 14 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 12,926,311$ | 12,926,311$ |
| 22 | Pittsburgh Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 500 | 149 | 148 | 147 | 999 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 64,497,250$ | 64,497,250$ | 0$ | 0$ | 0$ | 0$ | 13 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 76,173,582$ | 76,173,582$ |
| 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 | 54,693,762$ | 54,693,762$ | 0$ | 0$ | 0$ | 0$ | 18 | 1 | 0$ | 0$ | 0 | 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 | 44,195,000$ | 44,195,000$ | 0$ | 0$ | 0$ | 0$ | 12 | 1 | 0$ | 0$ | 0 | 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 | 65,515,000$ | 65,515,000$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 43,409,017$ | 43,409,017$ |
| 26 | Tampa Bay Lightning | 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 | 73,907,625$ | 73,907,625$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 18,261,583$ | 18,261,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 | 53,400,000$ | 53,400,000$ | 0$ | 0$ | 0$ | 0$ | 11 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 22,120,798$ | 22,120,798$ |
| 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 | 32,483,500$ | 32,483,500$ | 0$ | 0$ | 0$ | 0$ | 11 | 1 | 0$ | 0$ | 0 | 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 | 34,917,750$ | 34,917,750$ | 0$ | 0$ | 0$ | 0$ | 7 | 1 | 0$ | 0$ | 0 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 58,519,500$ | 58,519,500$ | 0$ | 0$ | 0$ | 0$ | 12 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 23,350,862$ | 23,350,862$ |
| 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 | 52,539,750$ | 52,539,750$ | 0$ | 0$ | 0$ | 0$ | 16 | 1 | 0$ | 0$ | 0 | 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 | 22,920,937$ | 22,920,937$ | 0$ | 0$ | 0$ | 0$ | 7 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,000,000$ | 95,000,000$ | 95,000,000$ | 41,748,139$ | 41,748,139$ |