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 |
# | Équipe | Masse salariale | Valeur du Cap Salarial Spécial | Joueurs inclus | Joueurs exclus | Au-dessus du plancher | Cap Salarial Disponible | Contrats | Espoirs | Total Joueurs |
---|---|---|---|---|---|---|---|---|---|---|
1 | Avalanche | 84,408,768$ | 7,500,000$ | 24 | 0 | 22,708,768$ | -908,768$ | 42 | 31 | 73 |
2 | Blackhawks | 62,005,001$ | 0$ | 23 | 0 | 305,001$ | 21,494,999$ | 49 | 30 | 79 |
3 | Blue Jackets | 72,712,500$ | 0$ | 21 | 0 | 11,012,500$ | 10,787,500$ | 46 | 25 | 71 |
4 | Blues | 70,258,333$ | 0$ | 15 | 0 | 8,558,333$ | 13,241,667$ | 44 | 11 | 55 |
5 | Bruins | 65,787,500$ | 0$ | 17 | 0 | 4,087,500$ | 17,712,500$ | 42 | 21 | 63 |
6 | Canadiens | 84,455,249$ | 0$ | 23 | 0 | 22,755,249$ | -955,249$ | 44 | 29 | 73 |
7 | Canucks | 71,581,530$ | 0$ | 22 | 1 | 9,881,530$ | 11,918,470$ | 47 | 30 | 77 |
8 | Capitals | 72,756,250$ | 0$ | 20 | 0 | 11,056,250$ | 10,743,750$ | 44 | 38 | 82 |
9 | Devils | 69,638,333$ | 4,625,000$ | 20 | 0 | 7,938,333$ | 13,861,667$ | 46 | 41 | 87 |
10 | Ducks | 73,338,333$ | 0$ | 24 | 0 | 11,638,333$ | 10,161,667$ | 43 | 22 | 65 |
11 | Flames | 68,728,334$ | 0$ | 21 | 0 | 7,028,334$ | 14,771,666$ | 42 | 22 | 64 |
12 | Flyers | 74,729,365$ | 0$ | 16 | 0 | 13,029,365$ | 8,770,635$ | 46 | 35 | 81 |
13 | Golden Knights | 64,251,250$ | 10,250,000$ | 21 | 2 | 2,551,250$ | 19,248,750$ | 44 | 40 | 84 |
14 | Hockey Club | 83,129,167$ | -2,500,000$ | 23 | 0 | 21,429,167$ | 370,833$ | 44 | 11 | 55 |
15 | Hurricanes | 82,721,084$ | 0$ | 21 | 0 | 21,021,084$ | 778,916$ | 46 | 28 | 74 |
16 | Islanders | 78,723,333$ | -9,125,000$ | 23 | 0 | 17,023,333$ | 4,776,667$ | 44 | 18 | 62 |
17 | Jets | 81,700,000$ | -4,625,000$ | 20 | 0 | 20,000,000$ | 1,800,000$ | 32 | 12 | 44 |
18 | Kings | 68,270,000$ | 2,125,000$ | 18 | 0 | 6,570,000$ | 15,230,000$ | 39 | 27 | 66 |
19 | Kraken | 80,804,167$ | 0$ | 21 | 0 | 19,104,167$ | 2,695,833$ | 44 | 30 | 74 |
20 | Lightning | 77,388,690$ | 2,500,000$ | 17 | 0 | 15,688,690$ | 6,111,310$ | 38 | 23 | 61 |
21 | Maple Leafs | 81,712,857$ | 0$ | 22 | 0 | 20,012,857$ | 1,787,143$ | 46 | 30 | 76 |
22 | Oilers | 82,199,818$ | 0$ | 22 | 0 | 20,499,818$ | 1,300,182$ | 39 | 14 | 53 |
23 | Panthers | 76,532,500$ | 2,000,000$ | 20 | 0 | 14,832,500$ | 6,967,500$ | 33 | 30 | 63 |
24 | Penguins | 79,599,524$ | 1,500,000$ | 21 | 0 | 17,899,524$ | 3,900,476$ | 32 | 4 | 36 |
25 | Predators | 79,350,833$ | -2,375,000$ | 22 | 0 | 17,650,833$ | 4,149,167$ | 47 | 24 | 71 |
26 | Rangers | 69,335,357$ | -5,750,000$ | 17 | 0 | 7,635,357$ | 14,164,643$ | 32 | 27 | 59 |
27 | Red Wings | 75,035,000$ | 0$ | 24 | 0 | 13,335,000$ | 8,465,000$ | 47 | 25 | 72 |
28 | Sabres | 67,518,334$ | 0$ | 20 | 1 | 5,818,334$ | 15,981,666$ | 38 | 25 | 63 |
29 | Senateurs | 79,172,333$ | -7,000,000$ | 21 | 0 | 17,472,333$ | 4,327,667$ | 43 | 15 | 58 |
30 | Sharks | 83,942,166$ | 0$ | 23 | 0 | 22,242,166$ | -442,166$ | 41 | 22 | 63 |
31 | Stars | 77,862,381$ | 0$ | 17 | 0 | 16,162,381$ | 5,637,619$ | 38 | 17 | 55 |
32 | Wild | 74,008,126$ | 875,000$ | 23 | 0 | 12,308,126$ | 9,491,874$ | 47 | 23 | 70 |