Finance

Astuces sur les Filtres (Anglais seulement)
PriorityTypeDescription
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
10textAny 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 DisponibleContrats Espoirs Total Joueurs
1AvalancheAvalanche71,848,332$ 0$ 25 0 1,248,332$ 23,651,668$ 47 38 85
2BlackhawksBlackhawks73,954,167$ 0$ 23 0 3,354,167$ 21,545,833$ 44 32 76
3Blue JacketsBlue Jackets102,455,357$ 0$ 24 0 31,855,357$ -6,955,357$ 37 22 59
4BluesBlues94,028,333$ -2,500,000$ 23 0 23,428,333$ 1,471,667$ 45 12 57
5BruinsBruins91,162,500$ 0$ 24 1 20,562,500$ 4,337,500$ 45 28 73
6CanadiensCanadiens93,231,667$ 0$ 24 0 22,631,667$ 2,268,333$ 44 30 74
7CanucksCanucks89,708,047$ 0$ 23 0 19,108,047$ 5,791,953$ 44 29 73
8CapitalsCapitals79,603,333$ 3,000,000$ 20 0 9,003,333$ 15,896,667$ 31 17 48
9DevilsDevils89,825,000$ 0$ 23 0 19,225,000$ 5,675,000$ 47 34 81
10DucksDucks89,964,357$ -4,500,000$ 21 0 19,364,357$ 5,535,643$ 37 15 52
11FlamesFlames72,966,749$ 0$ 23 0 2,366,749$ 22,533,251$ 47 25 72
12FlyersFlyers95,270,833$ 0$ 23 0 24,670,833$ 229,167$ 40 48 88
13Golden KnightsGolden Knights71,965,000$ 5,375,000$ 23 0 1,365,000$ 23,535,000$ 47 38 85
14HurricanesHurricanes94,700,444$ 0$ 23 0 24,100,444$ 799,556$ 45 29 74
15IslandersIslanders100,475,000$ -2,375,000$ 24 0 29,875,000$ -4,975,000$ 45 22 67
16JetsJets94,341,667$ 0$ 24 1 23,741,667$ 1,158,333$ 36 15 51
17KingsKings82,293,060$ 2,375,000$ 22 0 11,693,060$ 13,206,940$ 36 33 69
18KrakenKraken84,475,000$ -3,000,000$ 22 1 13,875,000$ 11,025,000$ 48 32 80
19LightningLightning86,780,357$ 5,875,000$ 25 0 16,180,357$ 8,719,643$ 47 32 79
20MammothMammoth93,475,833$ -6,625,000$ 25 0 22,875,833$ 2,024,167$ 36 12 48
21Maple LeafsMaple Leafs89,450,357$ -4,000,000$ 23 1 18,850,357$ 6,049,643$ 42 25 67
22OilersOilers94,888,102$ -4,500,000$ 23 1 24,288,102$ 611,898$ 38 24 62
23PanthersPanthers90,240,457$ -2,375,000$ 23 0 19,640,457$ 5,259,543$ 36 32 68
24PenguinsPenguins87,983,690$ 1,500,000$ 22 0 17,383,690$ 7,516,310$ 28 8 36
25PredatorsPredators100,505,947$ -3,375,000$ 22 0 29,905,947$ -5,005,947$ 39 25 64
26RangersRangers88,140,357$ 0$ 23 0 17,540,357$ 7,359,643$ 44 35 79
27Red WingsRed Wings76,316,667$ 2,275,000$ 24 0 5,716,667$ 19,183,333$ 49 32 81
28SabresSabres66,245,833$ 4,350,000$ 23 0 -4,354,167$ 29,254,167$ 38 29 67
29SenateursSenateurs73,425,000$ 8,500,000$ 21 1 2,825,000$ 22,075,000$ 37 34 71
30SharksSharks95,956,074$ 0$ 23 1 25,356,074$ -456,074$ 40 17 57
31StarsStars95,868,214$ 0$ 20 1 25,268,214$ -368,214$ 37 25 62
32WildWild94,098,334$ 0$ 23 0 23,498,334$ 1,401,666$ 43 21 64