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
1AvalancheAvalanche69,048,809$ 4,125,000$ 24 1 4,048,809$ 18,951,191$ 48 37 85
2BlackhawksBlackhawks71,717,500$ 0$ 23 1 6,717,500$ 16,282,500$ 44 32 76
3Blue JacketsBlue Jackets87,030,357$ 0$ 23 0 22,030,357$ 969,643$ 43 20 63
4BluesBlues82,583,333$ -2,500,000$ 20 0 17,583,333$ 5,416,667$ 43 12 55
5BruinsBruins83,757,500$ -2,500,000$ 24 0 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
8CapitalsCapitals85,070,000$ 3,000,000$ 23 0 20,070,000$ 2,930,000$ 42 25 67
9DevilsDevils71,775,000$ 4,625,000$ 22 1 6,775,000$ 16,225,000$ 43 43 86
10DucksDucks83,643,524$ -4,500,000$ 23 0 18,643,524$ 4,356,476$ 37 13 50
11FlamesFlames64,162,857$ 2,500,000$ 22 2 -837,143$ 23,837,143$ 40 28 68
12FlyersFlyers84,580,333$ -1,375,000$ 23 0 19,580,333$ 3,419,667$ 42 43 85
13Golden KnightsGolden Knights70,892,500$ 8,775,000$ 24 0 5,892,500$ 17,107,500$ 44 41 85
14HurricanesHurricanes87,357,587$ 0$ 20 0 22,357,587$ 642,413$ 39 26 65
15IslandersIslanders87,787,500$ 4,000,000$ 21 0 22,787,500$ 212,500$ 44 20 64
16JetsJets89,486,270$ -4,625,000$ 26 0 24,486,270$ -1,486,270$ 36 12 48
17KingsKings84,436,750$ -3,937,500$ 24 0 19,436,750$ 3,563,250$ 43 32 75
18KrakenKraken86,325,000$ -6,750,000$ 21 1 21,325,000$ 1,675,000$ 43 31 74
19LightningLightning70,242,857$ 5,875,000$ 22 2 5,242,857$ 17,757,143$ 38 28 66
20MammothMammoth87,816,667$ -4,775,000$ 22 0 22,816,667$ 183,333$ 38 12 50
21Maple LeafsMaple Leafs86,152,857$ -6,625,000$ 22 0 21,152,857$ 1,847,143$ 41 29 70
22OilersOilers85,914,342$ -4,500,000$ 22 2 20,914,342$ 2,085,658$ 40 18 58
23PanthersPanthers88,240,457$ -3,000,000$ 22 0 23,240,457$ -240,457$ 34 30 64
24PenguinsPenguins88,236,667$ 1,500,000$ 23 0 23,236,667$ -236,667$ 28 7 35
25PredatorsPredators87,512,500$ -3,375,000$ 22 0 22,512,500$ 487,500$ 45 25 70
26RangersRangers67,127,857$ -2,412,500$ 23 1 2,127,857$ 20,872,143$ 44 45 89
27Red WingsRed Wings71,599,167$ 2,775,000$ 23 0 6,599,167$ 16,400,833$ 42 33 75
28SabresSabres68,400,000$ 2,750,000$ 24 0 3,400,000$ 19,600,000$ 40 26 66
29SenateursSenateurs81,021,667$ 12,250,000$ 21 2 16,021,667$ 6,978,333$ 39 20 59
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
32WildWild84,850,477$ 0$ 22 2 19,850,477$ 3,149,523$ 45 21 66