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$ 24 1 8,152,142$ 14,847,858$ 48 36 84
2BlackhawksBlackhawks71,840,000$ 0$ 24 0 6,840,000$ 16,160,000$ 45 32 77
3Blue JacketsBlue Jackets87,030,357$ 0$ 23 0 22,030,357$ 969,643$ 43 20 63
4BluesBlues88,284,166$ -2,500,000$ 21 0 23,284,166$ -284,166$ 44 10 54
5BruinsBruins83,757,500$ -2,500,000$ 23 1 18,757,500$ 4,242,500$ 45 23 68
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
9DevilsDevils67,600,000$ 4,625,000$ 23 0 2,600,000$ 20,400,000$ 43 44 87
10DucksDucks87,159,524$ 0$ 22 1 22,159,524$ 840,476$ 37 17 54
11FlamesFlames70,012,857$ 2,500,000$ 23 1 5,012,857$ 17,987,143$ 40 28 68
12FlyersFlyers83,205,333$ -1,375,000$ 23 0 18,205,333$ 4,794,667$ 41 43 84
13Golden KnightsGolden Knights70,117,500$ 8,775,000$ 22 1 5,117,500$ 17,882,500$ 44 41 85
14HurricanesHurricanes88,282,587$ 0$ 20 1 23,282,587$ -282,587$ 40 26 66
15IslandersIslanders87,787,500$ 4,000,000$ 21 0 22,787,500$ 212,500$ 44 20 64
16JetsJets79,041,270$ -4,625,000$ 23 1 14,041,270$ 8,958,730$ 36 12 48
17KingsKings84,436,750$ -3,937,500$ 24 0 19,436,750$ 3,563,250$ 43 32 75
18KrakenKraken86,667,500$ -6,750,000$ 21 1 21,667,500$ 1,332,500$ 44 31 75
19LightningLightning72,992,857$ 2,500,000$ 23 1 7,992,857$ 15,007,143$ 38 28 66
20MammothMammoth81,791,667$ -4,775,000$ 23 1 16,791,667$ 6,208,333$ 38 12 50
21Maple LeafsMaple Leafs85,352,857$ -6,625,000$ 21 0 20,352,857$ 2,647,143$ 40 29 69
22OilersOilers85,364,342$ -4,500,000$ 23 1 20,364,342$ 2,635,658$ 39 18 57
23PanthersPanthers87,465,457$ -3,000,000$ 21 0 22,465,457$ 534,543$ 34 30 64
24PenguinsPenguins88,236,667$ 1,500,000$ 23 0 23,236,667$ -236,667$ 28 7 35
25PredatorsPredators83,987,500$ 0$ 21 0 18,987,500$ 4,012,500$ 45 25 70
26RangersRangers66,540,357$ -2,412,500$ 23 1 1,540,357$ 21,459,643$ 44 45 89
27Red WingsRed Wings73,798,334$ 2,775,000$ 24 0 8,798,334$ 14,201,666$ 42 33 75
28SabresSabres67,558,333$ 2,750,000$ 23 0 2,558,333$ 20,441,667$ 40 26 66
29SenateursSenateurs80,580,667$ 7,750,000$ 22 1 15,580,667$ 7,419,333$ 39 17 56
30SharksSharks87,403,000$ 0$ 22 0 22,403,000$ 597,000$ 44 20 64
31StarsStars87,968,174$ -1,750,000$ 24 0 22,968,174$ 31,826$ 44 21 65
32WildWild82,150,477$ 0$ 23 1 17,150,477$ 5,849,523$ 45 21 66