| 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 65,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Anaheim Ducks | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 16000 | 10000 | 6000 | 10300 | 1700 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 22000 - 100.00% | 2,240,588$ | 4,481,176$ | 22000 | 100 | 84,931,667$ | 84,931,667$ | -2,812,500$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 139,389,503$ | 139,389,503$ |
| 2 | Boston Bruins | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 86,960,040$ | 86,960,040$ | -3,050,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 179,414,536$ | 179,414,536$ |
| 3 | Buffalo Sabres | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 78,947,634$ | 78,947,634$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 194,729,613$ | 194,729,613$ |
| 4 | Calgary Flames | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 48000 | 30000 | 18000 | 30900 | 5100 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 22000 - 100.00% | 2,240,588$ | 13,443,528$ | 22000 | 100 | 87,976,249$ | 87,976,249$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 119,382,377$ | 119,382,377$ |
| 5 | Carolina Hurricanes | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 48000 | 30000 | 18000 | 30900 | 5100 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 22000 - 100.00% | 2,240,588$ | 13,443,528$ | 22000 | 100 | 84,914,670$ | 84,914,670$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 143,629,861$ | 143,629,861$ |
| 6 | Chicago Blackhawks | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 32000 | 20000 | 12000 | 20600 | 3400 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 22000 - 100.00% | 2,240,588$ | 8,962,352$ | 22000 | 100 | 85,060,417$ | 85,060,417$ | 350,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 146,369,574$ | 146,369,574$ |
| 7 | Colorado Avalanche | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 87,320,000$ | 87,320,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 144,958,907$ | 144,958,907$ |
| 8 | Columbus Blue Jackets | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 78,865,416$ | 78,865,416$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 129,136,467$ | 129,136,467$ |
| 9 | Dallas Stars | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 77,850,000$ | 77,850,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 156,742,301$ | 156,742,301$ |
| 10 | Detroit Red Wings | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 48000 | 30000 | 18000 | 30900 | 5100 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 22000 - 100.00% | 2,240,588$ | 13,443,528$ | 22000 | 100 | 72,201,458$ | 72,201,458$ | 5,768,750$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 129,749,606$ | 129,749,606$ |
| 11 | Edmonton Oilers | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 24000 | 15000 | 9000 | 15450 | 2550 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 22000 - 100.00% | 2,240,588$ | 6,721,764$ | 22000 | 100 | 85,660,937$ | 85,660,937$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 77,961,927$ | 77,961,927$ |
| 12 | Florida Panthers | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 48000 | 30000 | 18000 | 30900 | 5100 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 22000 - 100.00% | 2,240,588$ | 13,443,528$ | 22000 | 100 | 87,641,667$ | 87,641,667$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 140,245,154$ | 140,245,154$ |
| 13 | Los Angeles Kings | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 87,221,417$ | 87,221,417$ | 2,000,000$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 121,262,052$ | 121,262,052$ |
| 14 | Minnesota Wild | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 24000 | 15000 | 9000 | 15450 | 2550 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 22000 - 100.00% | 2,240,588$ | 6,721,764$ | 22000 | 100 | 81,200,595$ | 81,200,595$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 150,985,287$ | 150,985,287$ |
| 15 | Montreal Canadiens | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 24000 | 15000 | 9000 | 15450 | 2550 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 22000 - 100.00% | 2,240,588$ | 6,721,764$ | 22000 | 100 | 88,731,500$ | 88,731,500$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 142,368,547$ | 142,368,547$ |
| 16 | Nashville Predators | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 81,660,000$ | 81,660,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 162,705,445$ | 162,705,445$ |
| 17 | New Jersey Devils | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 24000 | 15000 | 9000 | 15450 | 2550 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 22000 - 100.00% | 2,240,588$ | 6,721,764$ | 22000 | 100 | 85,406,667$ | 85,406,667$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 151,379,698$ | 151,379,698$ |
| 18 | New York Islanders | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 83,389,584$ | 83,389,584$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 119,885,737$ | 119,885,737$ |
| 19 | New York Rangers | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 62,059,525$ | 62,059,525$ | 7,333,333$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 129,911,190$ | 129,911,190$ |
| 20 | Ottawa Senators | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 73,162,631$ | 73,162,631$ | 5,827,500$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 137,279,128$ | 137,279,128$ |
| 21 | Philadelphia Flyers | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 73,337,302$ | 73,337,302$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 158,830,206$ | 158,830,206$ |
| 22 | Pittsburgh Penguins | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 85,709,334$ | 85,709,334$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 123,024,448$ | 123,024,448$ |
| 23 | San Jose Sharks | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 83,907,812$ | 83,907,812$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 117,845,657$ | 117,845,657$ |
| 24 | Seattle Kraken | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 78,311,650$ | 78,311,650$ | 8,850,000$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 135,154,002$ | 135,154,002$ |
| 25 | St. Louis Blues | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 64,055,000$ | 64,055,000$ | 2,812,500$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 138,538,338$ | 138,538,338$ |
| 26 | Tampa Bay Lightning | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 24000 | 15000 | 9000 | 15450 | 2550 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 22000 - 100.00% | 2,240,588$ | 6,721,764$ | 22000 | 100 | 87,007,500$ | 87,007,500$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 128,283,871$ | 128,283,871$ |
| 27 | Toronto Maple Leafs | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 16000 | 10000 | 6000 | 10300 | 1700 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 22000 - 100.00% | 2,240,588$ | 4,481,176$ | 22000 | 100 | 86,955,000$ | 86,955,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 125,836,532$ | 125,836,532$ |
| 28 | Utah Mammoth | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 74,382,917$ | 74,382,917$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 144,692,443$ | 144,692,443$ |
| 29 | Vancouver Canucks | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 56000 | 35000 | 21000 | 36050 | 5950 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 22000 - 100.00% | 2,240,588$ | 15,684,116$ | 22000 | 100 | 82,755,833$ | 82,755,833$ | 3,125,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 160,729,115$ | 160,729,115$ |
| 30 | Vegas Golden Knights | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 48000 | 30000 | 18000 | 30900 | 5100 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 22000 - 100.00% | 2,240,588$ | 13,443,528$ | 22000 | 100 | 84,602,500$ | 84,602,500$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 142,039,781$ | 142,039,781$ |
| 31 | Washington Capitals | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 56000 | 35000 | 21000 | 36050 | 5950 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 22000 - 100.00% | 2,240,588$ | 15,684,116$ | 22000 | 100 | 87,429,500$ | 87,429,500$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 139,629,506$ | 139,629,506$ |
| 32 | Winnipeg Jets | 8000 | 5000 | 3000 | 5150 | 850 | 100 | 60 | 35 | 25 | 200 | 48000 | 30000 | 18000 | 30900 | 5100 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 22000 - 100.00% | 2,240,588$ | 13,443,528$ | 22000 | 100 | 85,156,250$ | 85,156,250$ | 2,162,500$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | -65,000,000$ | 88,000,000$ | 88,000,000$ | 95,901,782$ | 95,901,782$ |