| 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 |
| # | Team | Players Total Salaries | Special Salary Cap Value | Players In Salary Cap | Over Minimum Salary Cap of 60,200,000$ | Maximum Salary Cap | Available Salary Cap |
|---|---|---|---|---|---|---|---|
| 1 | Anaheim Ducks | 87,575,833$ | -2,962,500$ | 22 | 27,375,833$ | 85,000,000$ | 386,667$ |
| 2 | Boston Bruins | 88,661,717$ | -7,125,000$ | 22 | 28,461,717$ | 85,000,000$ | 3,463,283$ |
| 3 | Buffalo Sabres | 73,062,357$ | 0$ | 22 | 12,862,357$ | 85,000,000$ | 11,937,643$ |
| 4 | Calgary Flames | 82,967,893$ | -750,000$ | 22 | 22,767,893$ | 85,000,000$ | 2,782,107$ |
| 5 | Carolina Hurricanes | 82,036,089$ | 2,881,000$ | 22 | 21,836,089$ | 85,000,000$ | 82,911$ |
| 6 | Chicago Blackhawks | 81,125,000$ | 3,500,000$ | 22 | 20,925,000$ | 85,000,000$ | 375,000$ |
| 7 | Colorado Avalanche | 78,675,250$ | 5,750,000$ | 21 | 18,475,250$ | 85,000,000$ | 574,750$ |
| 8 | Columbus Blue Jackets | 75,700,000$ | 0$ | 21 | 15,500,000$ | 85,000,000$ | 9,300,000$ |
| 9 | Dallas Stars | 91,550,000$ | -6,625,000$ | 22 | 31,350,000$ | 85,000,000$ | 75,000$ |
| 10 | Detroit Red Wings | 78,480,210$ | -2,500,000$ | 21 | 18,280,210$ | 85,000,000$ | 9,019,790$ |
| 11 | Edmonton Oilers | 79,981,981$ | 1,606,667$ | 22 | 19,781,981$ | 85,000,000$ | 3,411,352$ |
| 12 | Florida Panthers | 86,696,143$ | -2,775,000$ | 23 | 26,496,143$ | 85,000,000$ | 1,078,857$ |
| 13 | Los Angeles Kings | 82,432,000$ | 200,000$ | 23 | 22,232,000$ | 85,000,000$ | 2,368,000$ |
| 14 | Minnesota Wild | 91,417,857$ | -9,458,333$ | 22 | 31,217,857$ | 85,000,000$ | 3,040,476$ |
| 15 | Montreal Canadiens | 77,518,647$ | 0$ | 22 | 17,318,647$ | 85,000,000$ | 7,481,353$ |
| 16 | Nashville Predators | 84,983,999$ | -10,129,500$ | 23 | 24,783,999$ | 85,000,000$ | 10,145,501$ |
| 17 | New Jersey Devils | 70,824,998$ | 9,437,500$ | 23 | 10,624,998$ | 85,000,000$ | 4,737,502$ |
| 18 | New York Islanders | 81,990,050$ | -1,750,000$ | 23 | 21,790,050$ | 85,000,000$ | 4,759,950$ |
| 19 | New York Rangers | 77,408,333$ | -2,400,000$ | 21 | 17,208,333$ | 85,000,000$ | 9,991,667$ |
| 20 | Ottawa Senators | 84,400,000$ | -2,500,000$ | 23 | 24,200,000$ | 85,000,000$ | 3,100,000$ |
| 21 | Philadelphia Flyers | 65,495,087$ | 4,500,000$ | 23 | 5,295,087$ | 85,000,000$ | 15,004,913$ |
| 22 | Pittsburgh Penguins | 61,215,714$ | 7,125,000$ | 23 | 1,015,714$ | 85,000,000$ | 16,659,286$ |
| 23 | San Jose Sharks | 50,834,487$ | 14,342,000$ | 23 | -9,365,513$ | 85,000,000$ | 19,823,513$ |
| 24 | Seattle Kraken | 63,613,250$ | 5,225,000$ | 22 | 3,413,250$ | 85,000,000$ | 16,161,750$ |
| 25 | St. Louis Blues | 80,799,994$ | 0$ | 21 | 20,599,994$ | 85,000,000$ | 4,200,006$ |
| 26 | Tampa Bay Lightning | 78,806,805$ | 6,025,000$ | 21 | 18,606,805$ | 85,000,000$ | 168,195$ |
| 27 | Toronto Maple Leafs | 83,250,000$ | -2,425,000$ | 24 | 23,050,000$ | 85,000,000$ | 4,175,000$ |
| 28 | Utah Mammoth | 65,265,000$ | 10,112,500$ | 25 | 5,065,000$ | 85,000,000$ | 9,622,500$ |
| 29 | Vancouver Canucks | 77,023,660$ | 0$ | 23 | 16,823,660$ | 85,000,000$ | 7,976,340$ |
| 30 | Vegas Golden Knights | 68,034,999$ | -2,025,000$ | 19 | 7,834,999$ | 85,000,000$ | 18,990,001$ |
| 31 | Washington Capitals | 77,532,024$ | 3,051,250$ | 23 | 17,332,024$ | 85,000,000$ | 4,416,726$ |
| 32 | Winnipeg Jets | 92,154,904$ | -7,987,500$ | 21 | 31,954,904$ | 85,000,000$ | 832,596$ |