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
1AvalancheAvalanche73,152,142$ 4,125,000$ 25 0 8,152,142$ 14,847,858$ 48 36 84
2BlackhawksBlackhawks74,470,000$ 0$ 24 0 9,470,000$ 13,530,000$ 45 32 77
3Blue JacketsBlue Jackets89,580,357$ 0$ 23 1 24,580,357$ -1,580,357$ 43 20 63
4BluesBlues88,208,333$ -2,500,000$ 21 0 23,208,333$ -208,333$ 45 10 55
5BruinsBruins83,257,500$ 0$ 23 0 18,257,500$ 4,742,500$ 43 24 67
6CanadiensCanadiens86,642,501$ 0$ 23 0 21,642,501$ 1,357,499$ 48 25 73
7CanucksCanucks70,087,365$ 0$ 23 1 5,087,365$ 17,912,635$ 47 31 78
8CapitalsCapitals79,845,000$ 3,000,000$ 23 0 14,845,000$ 8,155,000$ 41 26 67
9DevilsDevils58,100,000$ 4,625,000$ 22 1 -6,900,000$ 29,900,000$ 43 44 87
10DucksDucks86,309,524$ 0$ 23 0 21,309,524$ 1,690,476$ 36 17 53
11FlamesFlames72,537,857$ 0$ 23 2 7,537,857$ 15,462,143$ 41 27 68
12FlyersFlyers86,880,333$ 0$ 24 0 21,880,333$ 1,119,667$ 42 43 85
13Golden KnightsGolden Knights68,915,833$ 7,400,000$ 22 1 3,915,833$ 19,084,167$ 45 41 86
14HurricanesHurricanes87,357,587$ 0$ 20 0 22,357,587$ 642,413$ 40 26 66
15IslandersIslanders88,737,500$ 4,000,000$ 22 0 23,737,500$ -737,500$ 44 20 64
16JetsJets87,841,270$ -4,625,000$ 23 1 22,841,270$ 158,730$ 36 12 48
17KingsKings84,436,750$ -3,937,500$ 24 0 19,436,750$ 3,563,250$ 43 32 75
18KrakenKraken87,567,500$ -3,000,000$ 21 1 22,567,500$ 432,500$ 45 31 76
19LightningLightning72,067,857$ 2,500,000$ 22 2 7,067,857$ 15,932,143$ 38 28 66
20MammothMammoth86,366,667$ -4,775,000$ 23 0 21,366,667$ 1,633,333$ 38 12 50
21Maple LeafsMaple Leafs83,853,690$ -6,625,000$ 21 0 18,853,690$ 4,146,310$ 38 29 67
22OilersOilers81,864,342$ -4,500,000$ 22 1 16,864,342$ 6,135,658$ 39 18 57
23PanthersPanthers87,465,457$ -3,000,000$ 21 0 22,465,457$ 534,543$ 34 30 64
24PenguinsPenguins87,366,667$ 1,500,000$ 21 1 22,366,667$ 633,333$ 26 7 33
25PredatorsPredators84,937,500$ 0$ 22 0 19,937,500$ 3,062,500$ 45 25 70
26RangersRangers66,540,357$ -2,412,500$ 23 1 1,540,357$ 21,459,643$ 44 45 89
27Red WingsRed Wings73,181,667$ 2,775,000$ 24 0 8,181,667$ 14,818,333$ 42 33 75
28SabresSabres67,558,333$ 2,750,000$ 23 0 2,558,333$ 20,441,667$ 40 26 66
29SenateursSenateurs85,180,667$ 4,000,000$ 23 0 20,180,667$ 2,819,333$ 38 17 55
30SharksSharks87,403,000$ 0$ 22 0 22,403,000$ 597,000$ 44 20 64
31StarsStars81,343,174$ -1,750,000$ 22 1 16,343,174$ 6,656,826$ 44 21 65
32WildWild72,167,144$ 0$ 23 2 7,167,144$ 15,832,856$ 46 21 67