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
1AvalancheAvalanche70,461,291$ 7,500,000$ 25 1 8,761,291$ 13,038,709$ 44 32 76
2BlackhawksBlackhawks76,240,834$ 0$ 24 0 14,540,834$ 7,259,166$ 50 31 81
3Blue JacketsBlue Jackets83,285,000$ 0$ 23 0 21,585,000$ 215,000$ 49 25 74
4BluesBlues83,087,500$ -475,000$ 22 0 21,387,500$ 412,500$ 49 12 61
5BruinsBruins71,372,500$ 0$ 23 0 9,672,500$ 12,127,500$ 42 22 64
6CanadiensCanadiens80,596,916$ 0$ 23 0 18,896,916$ 2,903,084$ 43 29 72
7CanucksCanucks77,000,697$ 500,000$ 23 1 15,300,697$ 6,499,303$ 45 28 73
8CapitalsCapitals81,884,167$ -4,250,000$ 23 0 20,184,167$ 1,615,833$ 47 37 84
9DevilsDevils80,544,167$ 9,125,000$ 23 0 18,844,167$ 2,955,833$ 44 42 86
10DucksDucks81,072,500$ -2,375,000$ 27 0 19,372,500$ 2,427,500$ 44 19 63
11FlamesFlames69,184,524$ 0$ 23 0 7,484,524$ 14,315,476$ 44 23 67
12FlyersFlyers82,711,032$ -1,000,000$ 23 0 21,011,032$ 788,968$ 44 33 77
13Golden KnightsGolden Knights66,903,333$ 10,250,000$ 22 1 5,203,333$ 16,596,667$ 46 39 85
14Hockey ClubHockey Club83,066,667$ -2,500,000$ 22 1 21,366,667$ 433,333$ 43 9 52
15HurricanesHurricanes83,021,084$ 0$ 22 1 21,321,084$ 478,916$ 45 28 73
16IslandersIslanders76,956,667$ -9,125,000$ 22 1 15,256,667$ 6,543,333$ 46 18 64
17JetsJets83,313,333$ -4,625,000$ 24 0 21,613,333$ 186,667$ 35 12 47
18KingsKings72,546,666$ 2,125,000$ 22 0 10,846,666$ 10,953,334$ 40 27 67
19KrakenKraken82,917,143$ -2,875,000$ 22 0 21,217,143$ 582,857$ 46 32 78
20LightningLightning80,184,523$ 6,750,000$ 22 3 18,484,523$ 3,315,477$ 39 24 63
21Maple LeafsMaple Leafs83,340,357$ -500,000$ 23 0 21,640,357$ 159,643$ 49 29 78
22OilersOilers83,440,175$ 0$ 20 0 21,740,175$ 59,825$ 38 13 51
23PanthersPanthers81,532,500$ 1,000,000$ 23 0 19,832,500$ 1,967,500$ 34 28 62
24PenguinsPenguins83,015,001$ 1,500,000$ 26 0 21,315,001$ 484,999$ 39 4 43
25PredatorsPredators83,875,000$ -6,875,000$ 23 0 22,175,000$ -375,000$ 46 24 70
26RangersRangers75,780,357$ -2,900,000$ 23 0 14,080,357$ 7,719,643$ 39 32 71
27Red WingsRed Wings76,520,000$ 2,875,000$ 24 0 14,820,000$ 6,980,000$ 49 26 75
28SabresSabres69,842,500$ 0$ 26 1 8,142,500$ 13,657,500$ 43 25 68
29SenateursSenateurs82,809,000$ -7,000,000$ 24 0 21,109,000$ 691,000$ 47 15 62
30SharksSharks83,928,000$ 0$ 22 1 22,228,000$ -428,000$ 42 21 63
31StarsStars83,062,381$ 0$ 21 0 21,362,381$ 437,619$ 45 17 62
32WildWild82,984,834$ 2,875,000$ 22 0 21,284,834$ 515,166$ 50 23 73