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,899,142$ 4,125,000$ 26 0 4,899,142$ 18,100,858$ 48 37 85
2BlackhawksBlackhawks71,717,500$ 0$ 24 0 6,717,500$ 16,282,500$ 44 32 76
3Blue JacketsBlue Jackets87,930,357$ 0$ 24 0 22,930,357$ 69,643$ 43 20 63
4BluesBlues83,493,333$ -2,500,000$ 21 0 18,493,333$ 4,506,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$ 22 1 21,642,501$ 1,357,499$ 48 25 73
7CanucksCanucks67,862,365$ 0$ 23 2 2,862,365$ 20,137,635$ 47 31 78
8CapitalsCapitals85,945,000$ 3,000,000$ 24 0 20,945,000$ 2,055,000$ 42 25 67
9DevilsDevils74,800,000$ 4,625,000$ 26 0 9,800,000$ 13,200,000$ 43 43 86
10DucksDucks83,643,524$ -4,500,000$ 23 0 18,643,524$ 4,356,476$ 37 13 50
11FlamesFlames73,737,857$ 2,500,000$ 27 1 8,737,857$ 14,262,143$ 40 28 68
12FlyersFlyers84,072,833$ -1,375,000$ 24 0 19,072,833$ 3,927,167$ 42 43 85
13Golden KnightsGolden Knights70,240,833$ 8,775,000$ 22 1 5,240,833$ 17,759,167$ 44 41 85
14HurricanesHurricanes83,814,254$ 0$ 20 1 18,814,254$ 4,185,746$ 39 26 65
15IslandersIslanders81,287,500$ 4,000,000$ 20 1 16,287,500$ 6,712,500$ 44 20 64
16JetsJets87,841,270$ -4,625,000$ 24 0 22,841,270$ 158,730$ 36 12 48
17KingsKings84,436,750$ -3,937,500$ 24 0 19,436,750$ 3,563,250$ 43 32 75
18KrakenKraken87,941,667$ -6,750,000$ 23 1 22,941,667$ 58,333$ 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 Leafs87,953,690$ -6,625,000$ 24 0 22,953,690$ 46,310$ 41 29 70
22OilersOilers72,489,342$ -4,500,000$ 21 2 7,489,342$ 15,510,658$ 40 18 58
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
25PredatorsPredators87,512,500$ -3,375,000$ 22 0 22,512,500$ 487,500$ 45 25 70
26RangersRangers67,978,690$ -2,412,500$ 24 1 2,978,690$ 20,021,310$ 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
29SenateursSenateurs86,521,667$ 12,250,000$ 23 0 21,521,667$ 1,478,333$ 39 20 59
30SharksSharks87,403,000$ 0$ 22 0 22,403,000$ 597,000$ 44 20 64
31StarsStars87,018,174$ -1,750,000$ 23 0 22,018,174$ 981,826$ 44 21 65
32WildWild84,850,477$ 0$ 23 1 19,850,477$ 3,149,523$ 45 21 66