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
1AvalancheAvalanche39,752,143$ 0$ 10 0 -25,247,857$ 48,247,857$ 48 37 85
2BlackhawksBlackhawks40,745,000$ 0$ 14 0 -24,255,000$ 47,255,000$ 44 32 76
3Blue JacketsBlue Jackets61,630,357$ 0$ 13 0 -3,369,643$ 26,369,643$ 43 20 63
4BluesBlues79,758,333$ 0$ 16 0 14,758,333$ 8,241,667$ 43 12 55
5BruinsBruins68,325,000$ 0$ 15 0 3,325,000$ 19,675,000$ 45 23 68
6CanadiensCanadiens67,425,000$ 0$ 12 0 2,425,000$ 20,575,000$ 48 25 73
7CanucksCanucks49,160,714$ 0$ 12 0 -15,839,286$ 38,839,286$ 47 31 78
8CapitalsCapitals66,925,000$ 0$ 13 0 1,925,000$ 21,075,000$ 42 25 67
9DevilsDevils57,800,000$ 0$ 15 0 -7,200,000$ 30,200,000$ 43 43 86
10DucksDucks73,201,857$ 0$ 13 0 8,201,857$ 14,798,143$ 37 13 50
11FlamesFlames47,402,024$ 0$ 11 0 -17,597,976$ 40,597,976$ 40 28 68
12FlyersFlyers62,242,500$ 0$ 13 0 -2,757,500$ 25,757,500$ 42 43 85
13Golden KnightsGolden Knights45,600,833$ 0$ 14 0 -19,399,167$ 42,399,167$ 44 41 85
14HurricanesHurricanes79,539,254$ 0$ 17 0 14,539,254$ 8,460,746$ 39 26 65
15IslandersIslanders62,850,000$ 0$ 14 0 -2,150,000$ 25,150,000$ 44 20 64
16JetsJets63,116,667$ 0$ 13 0 -1,883,333$ 24,883,333$ 36 12 48
17KingsKings46,168,333$ 0$ 10 0 -18,831,667$ 41,831,667$ 43 32 75
18KrakenKraken65,125,000$ 0$ 13 0 125,000$ 22,875,000$ 43 31 74
19LightningLightning59,192,857$ 0$ 13 0 -5,807,143$ 28,807,143$ 38 28 66
20MammothMammoth59,350,000$ 0$ 11 0 -5,650,000$ 28,650,000$ 38 12 50
21Maple LeafsMaple Leafs63,342,857$ 0$ 13 0 -1,657,143$ 24,657,143$ 41 29 70
22OilersOilers71,400,000$ 0$ 13 0 6,400,000$ 16,600,000$ 40 18 58
23PanthersPanthers58,990,457$ 0$ 11 0 -6,009,543$ 29,009,543$ 34 30 64
24PenguinsPenguins59,850,000$ 0$ 14 0 -5,150,000$ 28,150,000$ 28 7 35
25PredatorsPredators65,600,000$ 0$ 14 0 600,000$ 22,400,000$ 45 25 70
26RangersRangers56,527,857$ 0$ 16 0 -8,472,143$ 31,472,143$ 44 45 89
27Red WingsRed Wings57,291,667$ 0$ 16 0 -7,708,333$ 30,708,333$ 42 33 75
28SabresSabres44,595,833$ 0$ 14 0 -20,404,167$ 43,404,167$ 40 26 66
29SenateursSenateurs64,000,000$ 0$ 16 0 -1,000,000$ 24,000,000$ 39 20 59
30SharksSharks63,085,000$ 0$ 14 0 -1,915,000$ 24,915,000$ 44 20 64
31StarsStars75,793,174$ 0$ 17 0 10,793,174$ 12,206,826$ 44 21 65
32WildWild70,498,810$ 0$ 15 0 5,498,810$ 17,501,190$ 45 21 66