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
1AvalancheAvalanche60,898,332$ 0$ 22 1 -4,101,668$ 27,101,668$ 43 38 81
2BlackhawksBlackhawks75,842,000$ 0$ 31 0 10,842,000$ 12,158,000$ 51 32 83
3Blue JacketsBlue Jackets95,655,357$ 0$ 20 0 30,655,357$ -7,655,357$ 40 26 66
4BluesBlues79,858,333$ -2,500,000$ 18 0 14,858,333$ 8,141,667$ 41 12 53
5BruinsBruins82,062,500$ 0$ 21 0 17,062,500$ 5,937,500$ 45 28 73
6CanadiensCanadiens86,566,667$ 0$ 20 0 21,566,667$ 1,433,333$ 42 30 72
7CanucksCanucks89,649,714$ 0$ 23 0 24,649,714$ -1,649,714$ 45 30 75
8CapitalsCapitals79,603,333$ 3,000,000$ 20 0 14,603,333$ 8,396,667$ 36 28 64
9DevilsDevils89,550,000$ 0$ 24 0 24,550,000$ -1,550,000$ 44 34 78
10DucksDucks88,964,357$ -4,500,000$ 20 0 23,964,357$ -964,357$ 37 15 52
11FlamesFlames71,902,582$ 0$ 23 0 6,902,582$ 16,097,418$ 45 25 70
12FlyersFlyers90,708,333$ 0$ 21 0 25,708,333$ -2,708,333$ 36 49 85
13Golden KnightsGolden Knights62,215,833$ 3,000,000$ 23 0 -2,784,167$ 25,784,167$ 49 38 87
14HurricanesHurricanes93,957,111$ 0$ 22 0 28,957,111$ -5,957,111$ 44 29 73
15IslandersIslanders97,800,000$ 0$ 20 0 32,800,000$ -9,800,000$ 44 22 66
16JetsJets96,616,667$ 0$ 22 0 31,616,667$ -8,616,667$ 38 15 53
17KingsKings73,289,250$ 0$ 15 0 8,289,250$ 14,710,750$ 33 33 66
18KrakenKraken94,450,000$ -3,000,000$ 20 0 29,450,000$ -6,450,000$ 47 32 79
19LightningLightning75,980,357$ 5,875,000$ 20 0 10,980,357$ 12,019,643$ 44 32 76
20MammothMammoth91,712,500$ -2,275,000$ 22 0 26,712,500$ -3,712,500$ 34 13 47
21Maple LeafsMaple Leafs93,442,857$ -4,000,000$ 18 0 28,442,857$ -5,442,857$ 42 24 66
22OilersOilers95,763,102$ -4,500,000$ 21 0 30,763,102$ -7,763,102$ 39 24 63
23PanthersPanthers80,340,457$ 0$ 14 0 15,340,457$ 7,659,543$ 33 36 69
24PenguinsPenguins87,517,857$ 1,500,000$ 19 0 22,517,857$ 482,143$ 28 9 37
25PredatorsPredators97,655,947$ -3,375,000$ 20 0 32,655,947$ -9,655,947$ 45 27 72
26RangersRangers78,815,357$ 0$ 22 0 13,815,357$ 9,184,643$ 41 37 78
27Red WingsRed Wings67,166,667$ 2,275,000$ 23 0 2,166,667$ 20,833,333$ 48 32 80
28SabresSabres53,395,833$ 0$ 20 0 -11,604,167$ 34,604,167$ 39 29 68
29SenateursSenateurs73,125,000$ 8,500,000$ 19 0 8,125,000$ 14,875,000$ 36 34 70
30SharksSharks90,281,074$ 0$ 19 0 25,281,074$ -2,281,074$ 43 19 62
31StarsStars94,268,174$ 0$ 21 0 29,268,174$ -6,268,174$ 41 25 66
32WildWild84,816,310$ 0$ 23 0 19,816,310$ 3,183,690$ 41 21 62