| 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 76,500,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
| 1 | Anaheim Ducks | 5174 | 5000 | 2000 | 4000 | 1000 | 250 | 150 | 90 | 60 | 500 | 3449 | 2953 | 1233 | 2285 | 572 | 66.66% | 59.06% | 61.65% | 57.13% | 57.20% | 42 | 10492 - 61.09% | 2,740,512$ | 2,740,512$ | 17174 | 100 | 107,425,412$ | 107,425,412$ | 187,500$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 142,544,579$ | 142,544,579$ |
| 2 | Boston Bruins | 7150 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 37 | 25 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 19150 | 100 | 86,957,943$ | 86,957,942$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 81,438,278$ | 81,438,278$ |
| 3 | Buffalo Sabres | 7100 | 5100 | 2000 | 4000 | 1000 | 220 | 130 | 90 | 60 | 350 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 19200 | 100 | 115,725,000$ | 115,725,000$ | -1,144,417$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 138,568,016$ | 138,568,016$ |
| 4 | Carolina Hurricanes | 6680 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18680 | 100 | 75,685,419$ | 75,685,419$ | 2,365,116$ | 0$ | 0$ | 0$ | 30 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 95,836,948$ | 95,836,948$ |
| 5 | Chicago Blackhawks | 7717 | 5000 | 2000 | 4000 | 1000 | 90 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 19717 | 100 | 86,967,857$ | 86,967,857$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 34,153,586$ | 34,153,586$ |
| 6 | Colorado Avalanche | 6007 | 5000 | 2000 | 4000 | 1000 | 150 | 80 | 55 | 30 | 290 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18007 | 100 | 95,291,042$ | 95,296,042$ | 343,256$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 159,095,470$ | 159,095,470$ |
| 7 | Dallas Stars | 6532 | 5000 | 2000 | 4000 | 1000 | 185 | 120 | 90 | 60 | 500 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18532 | 100 | 105,500,000$ | 102,363,333$ | 3,155,000$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 80,307,217$ | 80,307,217$ |
| 8 | Detroit Red Wings | 8066 | 5000 | 2000 | 4000 | 1000 | 105 | 62 | 37 | 20 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 20066 | 100 | 84,050,039$ | 84,050,039$ | 5,508,767$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 96,251,777$ | 96,251,777$ |
| 9 | Los Angeles Kings | 7153 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 190 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 19153 | 100 | 98,768,102$ | 98,768,102$ | -2,940,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 51,102,789$ | 51,102,789$ |
| 10 | Minnesota Wild | 6215 | 6074 | 2000 | 4000 | 1000 | 151 | 91 | 61 | 25 | 200 | 5554 | 4255 | 1828 | 4000 | 1000 | 89.36% | 70.05% | 91.40% | 100.00% | 100.00% | 42 | 16637 - 86.25% | 2,439,677$ | 2,439,677$ | 19289 | 100 | 115,357,857$ | 115,357,856$ | -3,917,605$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 35,202,508$ | 35,202,508$ |
| 11 | Montreal Canadiens | 8273 | 6000 | 2000 | 4000 | 1000 | 140 | 81 | 51 | 20 | 230 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 21273 | 100 | 106,402,857$ | 106,402,857$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 152,224,718$ | 152,224,718$ |
| 12 | Nashville Predators | 5113 | 5000 | 2000 | 4000 | 1000 | 180 | 95 | 65 | 45 | 320 | 4588 | 4328 | 1570 | 3032 | 756 | 89.73% | 86.56% | 78.50% | 75.80% | 75.60% | 42 | 14274 - 83.41% | 2,558,941$ | 2,558,941$ | 17113 | 100 | 111,312,500$ | 111,312,500$ | 670,698$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 105,717,520$ | 105,717,520$ |
| 13 | NewYork Islanders | 4895 | 3900 | 2000 | 4000 | 1000 | 139 | 80 | 45 | 26 | 234 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 15795 | 100 | 99,142,857$ | 99,142,857$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 51,233,249$ | 51,233,249$ |
| 14 | NewYork Rangers | 5200 | 5000 | 2000 | 4000 | 1000 | 190 | 100 | 65 | 45 | 400 | 4470 | 3836 | 1584 | 3066 | 696 | 85.96% | 76.72% | 79.20% | 76.65% | 69.60% | 42 | 13652 - 79.37% | 2,610,823$ | 2,610,823$ | 17200 | 100 | 107,741,667$ | 107,741,667$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 96,507,491$ | 96,507,491$ |
| 15 | Ottawa Senateurs | 5039 | 4800 | 2000 | 4000 | 1000 | 100 | 50 | 30 | 20 | 280 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 16839 | 100 | 101,875,000$ | 101,875,000$ | 891,628$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 12,924,535$ | 12,924,535$ |
| 16 | Philadelphia Flyers | 7537 | 5000 | 2000 | 4000 | 1000 | 125 | 65 | 50 | 30 | 250 | 6326 | 5000 | 2000 | 4000 | 1000 | 83.93% | 100.00% | 100.00% | 100.00% | 100.00% | 42 | 18326 - 93.80% | 2,362,768$ | 2,362,768$ | 19537 | 100 | 108,499,957$ | 108,499,957$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 74,222,208$ | 74,222,208$ |
| 17 | Pittsburgh Penguins | 6387 | 5000 | 2000 | 4000 | 1000 | 105 | 70 | 42 | 30 | 225 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18387 | 100 | 73,633,889$ | 69,283,889$ | 0$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 84,918,347$ | 84,918,347$ |
| 18 | SanJose Sharks | 5562 | 5000 | 2000 | 4000 | 1000 | 130 | 80 | 55 | 38 | 218 | 5562 | 5000 | 2000 | 3385 | 1000 | 100.00% | 100.00% | 100.00% | 84.63% | 100.00% | 42 | 16947 - 96.50% | 2,353,738$ | 2,353,738$ | 17562 | 100 | 113,319,167$ | 113,119,167$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 128,186,450$ | 128,186,450$ |
| 19 | Seattle Kraken | 6118 | 5000 | 2000 | 4000 | 1000 | 125 | 70 | 42 | 26 | 230 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18118 | 100 | 103,734,999$ | 103,734,999$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 133,332,125$ | 133,332,125$ |
| 20 | St-Louis Blues | 5565 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 37 | 25 | 210 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 17565 | 100 | 104,289,643$ | 104,289,643$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 11,667,154$ | 11,667,154$ |
| 21 | Tampa Bay Lightning | 7204 | 5000 | 2000 | 4000 | 1000 | 225 | 135 | 90 | 60 | 325 | 4322 | 3283 | 1200 | 2400 | 848 | 59.99% | 65.66% | 60.00% | 60.00% | 84.80% | 42 | 12053 - 62.76% | 2,895,450$ | 2,895,450$ | 19204 | 100 | 108,750,000$ | 108,750,000$ | 108,372$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 194,394,406$ | 194,394,406$ |
| 22 | Toronto Maple Leafs | 5000 | 5000 | 2000 | 4000 | 1000 | 250 | 150 | 90 | 60 | 500 | 3664 | 2713 | 1226 | 2470 | 528 | 73.28% | 54.26% | 61.30% | 61.75% | 52.80% | 42 | 10601 - 62.36% | 2,749,780$ | 2,749,780$ | 17000 | 100 | 116,596,500$ | 116,596,500$ | -3,013,722$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 68,412,657$ | 68,412,657$ |
| 23 | Vancouver Canucks | 6910 | 5000 | 2000 | 4000 | 1000 | 125 | 85 | 61 | 26 | 185 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18910 | 100 | 102,921,189$ | 102,921,189$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 76,394,982$ | 76,394,982$ |
| 24 | Vegas Golden Knights | 5368 | 5000 | 2000 | 4000 | 1000 | 150 | 90 | 70 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 17368 | 100 | 80,865,000$ | 80,865,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 94,716,931$ | 94,716,931$ |
| 25 | Washington Capitals | 6506 | 5000 | 2000 | 4000 | 1000 | 100 | 61 | 45 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 18506 | 100 | 104,191,667$ | 101,541,667$ | 0$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 47,680,610$ | 47,680,610$ |
| 26 | Winnipeg Jets | 5004 | 4000 | 2000 | 3000 | 1000 | 250 | 150 | 90 | 60 | 500 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 43 | 0 - 0% | 0$ | 0$ | 15004 | 100 | 95,663,333$ | 95,663,333$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 12 | 0$ | 0$ | 0$ | 0$ | -76,500,000$ | 105,000,000$ | 105,000,000$ | 40,473,663$ | 40,473,663$ |