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
1AvalancheAvalanche76,365,832$ 0$ 25 3 5,765,832$ 19,134,168$ 49 38 87
2BlackhawksBlackhawks73,954,167$ 0$ 23 0 3,354,167$ 21,545,833$ 43 32 75
3Blue JacketsBlue Jackets94,105,357$ 0$ 23 0 23,505,357$ 1,394,643$ 36 22 58
4BluesBlues94,128,333$ -2,500,000$ 23 0 23,528,333$ 1,371,667$ 48 12 60
5BruinsBruins86,487,500$ 0$ 24 0 15,887,500$ 9,012,500$ 45 27 72
6CanadiensCanadiens94,266,667$ -1,375,000$ 23 0 23,666,667$ 1,233,333$ 46 30 76
7CanucksCanucks90,741,547$ 0$ 23 0 20,141,547$ 4,758,453$ 44 29 73
8CapitalsCapitals82,220,000$ 3,000,000$ 23 0 11,620,000$ 13,280,000$ 33 17 50
9DevilsDevils91,075,000$ 1,375,000$ 23 0 20,475,000$ 4,425,000$ 47 34 81
10DucksDucks94,889,357$ -8,500,000$ 23 0 24,289,357$ 610,643$ 37 14 51
11FlamesFlames76,454,249$ 0$ 22 1 5,854,249$ 19,045,751$ 47 25 72
12FlyersFlyers95,599,166$ 0$ 23 0 24,999,166$ -99,166$ 39 48 87
13Golden KnightsGolden Knights76,336,667$ 5,375,000$ 23 1 5,736,667$ 19,163,333$ 47 38 85
14HurricanesHurricanes94,795,444$ 0$ 23 0 24,195,444$ 704,556$ 46 28 74
15IslandersIslanders95,100,000$ -2,375,000$ 22 0 24,500,000$ 400,000$ 45 21 66
16JetsJets93,550,000$ 0$ 23 1 22,950,000$ 1,950,000$ 37 15 52
17KingsKings82,961,393$ 1,400,000$ 23 0 12,361,393$ 12,538,607$ 41 33 74
18KrakenKraken84,395,000$ -3,000,000$ 23 1 13,795,000$ 11,105,000$ 48 28 76
19LightningLightning86,005,357$ 5,875,000$ 24 0 15,405,357$ 9,494,643$ 46 32 78
20MammothMammoth92,175,000$ -6,625,000$ 24 0 21,575,000$ 3,325,000$ 38 12 50
21Maple LeafsMaple Leafs87,950,357$ 0$ 23 0 17,350,357$ 7,549,643$ 41 28 69
22OilersOilers88,404,769$ -4,500,000$ 22 3 17,804,769$ 7,095,231$ 38 23 61
23PanthersPanthers94,815,457$ -1,400,000$ 23 0 24,215,457$ 684,543$ 36 32 68
24PenguinsPenguins83,933,690$ 1,500,000$ 21 0 13,333,690$ 11,566,310$ 28 7 35
25PredatorsPredators93,980,947$ -3,375,000$ 23 0 23,380,947$ 1,519,053$ 38 25 63
26RangersRangers92,440,357$ 0$ 23 0 21,840,357$ 3,059,643$ 44 35 79
27Red WingsRed Wings75,016,667$ 2,275,000$ 23 0 4,416,667$ 20,483,333$ 46 32 78
28SabresSabres72,520,000$ 4,350,000$ 24 0 1,920,000$ 22,980,000$ 45 27 72
29SenateursSenateurs86,000,000$ 8,500,000$ 24 1 15,400,000$ 9,500,000$ 37 34 71
30SharksSharks95,893,574$ 0$ 24 0 25,293,574$ -393,574$ 41 17 58
31StarsStars93,218,214$ 0$ 21 0 22,618,214$ 2,281,786$ 35 25 60
32WildWild94,233,334$ 0$ 23 0 23,633,334$ 1,266,666$ 43 22 65