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
1AvalancheAvalanche61,848,332$ 0$ 23 1 -3,151,668$ 26,151,668$ 43 38 81
2BlackhawksBlackhawks72,216,667$ 0$ 21 0 7,216,667$ 15,783,333$ 49 33 82
3Blue JacketsBlue Jackets98,148,690$ 0$ 23 0 33,148,690$ -10,148,690$ 40 26 66
4BluesBlues84,853,333$ -2,500,000$ 21 0 19,853,333$ 3,146,667$ 42 12 54
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
9DevilsDevils88,775,000$ 0$ 23 0 23,775,000$ -775,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
12FlyersFlyers87,458,333$ 0$ 20 0 22,458,333$ 541,667$ 35 49 84
13Golden KnightsGolden Knights60,315,833$ 3,000,000$ 23 0 -4,684,167$ 27,684,167$ 50 38 88
14HurricanesHurricanes93,957,111$ 0$ 22 0 28,957,111$ -5,957,111$ 44 29 73
15IslandersIslanders97,725,000$ 0$ 21 0 32,725,000$ -9,725,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
18KrakenKraken93,200,000$ -3,000,000$ 20 0 28,200,000$ -5,200,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 Leafs97,975,357$ -4,000,000$ 23 0 32,975,357$ -9,975,357$ 42 24 66
22OilersOilers96,688,102$ -4,500,000$ 22 0 31,688,102$ -8,688,102$ 39 24 63
23PanthersPanthers80,340,457$ 0$ 14 0 15,340,457$ 7,659,543$ 33 36 69
24PenguinsPenguins84,567,857$ 1,500,000$ 20 0 19,567,857$ 3,432,143$ 30 8 38
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,591,667$ 2,275,000$ 23 0 2,591,667$ 20,408,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
30SharksSharks92,181,074$ 0$ 21 0 27,181,074$ -4,181,074$ 42 19 61
31StarsStars94,268,174$ 0$ 21 0 29,268,174$ -6,268,174$ 41 25 66
32WildWild84,041,310$ 0$ 22 0 19,041,310$ 3,958,690$ 41 21 62