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
1AvalancheAvalanche84,408,768$ 7,500,000$ 24 0 22,708,768$ -908,768$ 42 31 73
2BlackhawksBlackhawks62,005,001$ 0$ 23 0 305,001$ 21,494,999$ 49 30 79
3Blue JacketsBlue Jackets72,712,500$ 0$ 21 0 11,012,500$ 10,787,500$ 46 25 71
4BluesBlues70,258,333$ 0$ 15 0 8,558,333$ 13,241,667$ 44 11 55
5BruinsBruins65,787,500$ 0$ 17 0 4,087,500$ 17,712,500$ 42 21 63
6CanadiensCanadiens84,455,249$ 0$ 23 0 22,755,249$ -955,249$ 44 29 73
7CanucksCanucks71,581,530$ 0$ 22 1 9,881,530$ 11,918,470$ 47 30 77
8CapitalsCapitals72,756,250$ 0$ 20 0 11,056,250$ 10,743,750$ 44 38 82
9DevilsDevils69,638,333$ 4,625,000$ 20 0 7,938,333$ 13,861,667$ 46 41 87
10DucksDucks73,338,333$ 0$ 24 0 11,638,333$ 10,161,667$ 43 22 65
11FlamesFlames68,728,334$ 0$ 21 0 7,028,334$ 14,771,666$ 42 22 64
12FlyersFlyers74,729,365$ 0$ 16 0 13,029,365$ 8,770,635$ 46 35 81
13Golden KnightsGolden Knights64,251,250$ 10,250,000$ 21 2 2,551,250$ 19,248,750$ 44 40 84
14Hockey ClubHockey Club83,129,167$ -2,500,000$ 23 0 21,429,167$ 370,833$ 44 11 55
15HurricanesHurricanes82,721,084$ 0$ 21 0 21,021,084$ 778,916$ 46 28 74
16IslandersIslanders78,723,333$ -9,125,000$ 23 0 17,023,333$ 4,776,667$ 44 18 62
17JetsJets81,700,000$ -4,625,000$ 20 0 20,000,000$ 1,800,000$ 32 12 44
18KingsKings68,270,000$ 2,125,000$ 18 0 6,570,000$ 15,230,000$ 39 27 66
19KrakenKraken80,804,167$ 0$ 21 0 19,104,167$ 2,695,833$ 44 30 74
20LightningLightning77,388,690$ 2,500,000$ 17 0 15,688,690$ 6,111,310$ 38 23 61
21Maple LeafsMaple Leafs81,712,857$ 0$ 22 0 20,012,857$ 1,787,143$ 46 30 76
22OilersOilers82,199,818$ 0$ 22 0 20,499,818$ 1,300,182$ 39 14 53
23PanthersPanthers76,532,500$ 2,000,000$ 20 0 14,832,500$ 6,967,500$ 33 30 63
24PenguinsPenguins79,599,524$ 1,500,000$ 21 0 17,899,524$ 3,900,476$ 32 4 36
25PredatorsPredators79,350,833$ -2,375,000$ 22 0 17,650,833$ 4,149,167$ 47 24 71
26RangersRangers69,335,357$ -5,750,000$ 17 0 7,635,357$ 14,164,643$ 32 27 59
27Red WingsRed Wings75,035,000$ 0$ 24 0 13,335,000$ 8,465,000$ 47 25 72
28SabresSabres67,518,334$ 0$ 20 1 5,818,334$ 15,981,666$ 38 25 63
29SenateursSenateurs79,172,333$ -7,000,000$ 21 0 17,472,333$ 4,327,667$ 43 15 58
30SharksSharks83,942,166$ 0$ 23 0 22,242,166$ -442,166$ 41 22 63
31StarsStars77,862,381$ 0$ 17 0 16,162,381$ 5,637,619$ 38 17 55
32WildWild74,008,126$ 875,000$ 23 0 12,308,126$ 9,491,874$ 47 23 70