| Priority | Type | Description |
|---|---|---|
| 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 |
| 10 | text | Any text entered in the filter will match text found within the column |
| Capacité de l'Aréna | Prix des Billets | Assistance | Assistance PCT | Revenus | Dépenses | Éstimation | Total de l'Équipe Éstimé | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Équipe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Niveau1 | Niveau2 | Niveau3 | Niveau4 | Luxe | Matchs à domicile Restants | Assistance Moyenne - % | Revenus Moyen par Match | Revenus Annuels à ce Jour | Capacité de l'Aréna | Popularité de l'Équipe | Salaire Total des Joueurs | Salaire Total Moyen des Joueurs | Valeur du Cap Salarial Spécial | Dépenses Annuelles à Ce Jour | Cap Salarial Par Jour | Cap salarial à ce jour | Joueurs Inclut dans la Cap Salariale | Joueurs Exclut dans la Cap Salariale | Taxe de Luxe Totale | Revenus de la Saison Éstimés | Jours Restants de la Saison | Dépenses Par Jour | Dépenses de la Saison Éstimées | Dépenses de la Saison Éstimées | Cap Salarial de la Saison Éstimé | Au dessus du Plafond Salarial Minimum of 58,800,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
| 1 | Anaheim Ducks | 5174 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 10348 | 8911 | 3782 | 7344 | 1971 | 100.00% | 89.11% | 94.55% | 91.80% | 98.55% | 39 | 16178 - 94.20% | 1,860,294$ | 3,720,588$ | 17174 | 100 | 72,396,429$ | 27,891,110$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 62,486,454$ | 62,486,454$ |
| 2 | Arizona Coyotes | 5799 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 225 | 17397 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 17799 - 100.00% | 1,505,880$ | 4,517,640$ | 17799 | 100 | 74,866,667$ | 48,605,554$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 42,193,043$ | 42,193,043$ |
| 3 | Boston Bruins | 5565 | 5000 | 2000 | 4000 | 1000 | 97 | 57 | 33 | 19 | 207 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17565 | 100 | 57,949,125$ | 48,919,167$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 87,502,523$ | 87,502,523$ |
| 4 | Buffalo Sabres | 6690 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 12459 | 9359 | 3771 | 7200 | 1943 | 93.12% | 93.59% | 94.28% | 90.00% | 97.15% | 39 | 17366 - 92.92% | 2,051,568$ | 4,103,136$ | 18690 | 100 | 67,175,000$ | 49,244,167$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 91,335,554$ | 91,335,554$ |
| 5 | Calgary Flames | 7285 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 210 | 29140 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 19285 - 100.00% | 1,756,200$ | 7,024,800$ | 19285 | 100 | 76,459,000$ | 72,675,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 59,606,032$ | 59,606,032$ |
| 6 | Carolina Hurricanes | 6680 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18680 | 100 | 65,775,000$ | 57,757,500$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 63,473,150$ | 63,473,150$ |
| 7 | Chicago Blackhawks | 8500 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20500 | 100 | 71,033,333$ | 58,139,167$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 118,541,901$ | 118,541,901$ |
| 8 | Colorado Avalanche | 6007 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 29642 | 24306 | 9541 | 19121 | 4785 | 98.69% | 97.22% | 95.41% | 95.61% | 95.70% | 36 | 17479 - 97.07% | 2,024,855$ | 10,124,274$ | 18007 | 100 | 77,175,000$ | 47,700,000$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 30,279,934$ | 30,279,934$ |
| 9 | Columbus Blue Jackets | 6700 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 38170 | 29641 | 11747 | 22130 | 5745 | 94.95% | 98.80% | 97.89% | 92.21% | 95.75% | 35 | 17906 - 95.75% | 2,102,646$ | 12,615,876$ | 18700 | 100 | 72,533,333$ | 62,638,333$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 72,105,719$ | 72,105,719$ |
| 10 | Dallas Stars | 6532 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18532 | 100 | 56,850,000$ | 27,803,333$ | 0$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 59,812,860$ | 59,812,860$ |
| 11 | Detroit Red Wings | 8066 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 40437 | 28998 | 11855 | 23548 | 5909 | 83.55% | 96.66% | 98.79% | 98.12% | 98.48% | 35 | 18458 - 91.99% | 2,175,040$ | 13,050,240$ | 20066 | 100 | 76,216,666$ | 76,675,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 157,986,485$ | 157,986,485$ |
| 12 | Edmonton Oilers | 6841 | 4800 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 79677 | 57073 | 23864 | 47440 | 11861 | 97.06% | 99.09% | 99.43% | 98.83% | 98.84% | 29 | 18326 - 98.31% | 2,153,947$ | 25,847,364$ | 18641 | 100 | 77,900,000$ | 72,200,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 52,232,167$ | 52,232,167$ |
| 13 | Florida Panthers | 7250 | 5000 | 2000 | 4000 | 1000 | 92 | 53 | 31 | 19 | 200 | 14500 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 19250 - 100.00% | 1,524,000$ | 3,048,000$ | 19250 | 100 | 72,625,833$ | 63,477,777$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 22,182,420$ | 22,182,420$ |
| 14 | Los Angeles Kings | 6118 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18118 | 100 | 62,720,000$ | 36,757,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 108,623,074$ | 108,623,074$ |
| 15 | Minnesota Wild | 6064 | 5000 | 3000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 17650 | 13573 | 5472 | 11081 | 2834 | 97.02% | 90.49% | 60.80% | 92.34% | 94.47% | 38 | 16870 - 88.49% | 1,970,710$ | 5,912,130$ | 19064 | 100 | 72,458,332$ | 55,050,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 29,958,539$ | 29,958,539$ |
| 16 | Montreal Canadiens | 8273 | 6000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 21273 | 100 | 68,703,333$ | 59,076,000$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 96,367,604$ | 96,367,604$ |
| 17 | Nashville Predators | 5113 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17113 | 100 | 75,610,833$ | 55,175,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 5,307,707$ | 5,307,707$ |
| 18 | New Jersey Devils | 5625 | 5000 | 2000 | 4000 | 1000 | 107 | 55 | 40 | 25 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17625 | 100 | 68,705,556$ | 53,127,777$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 94,711,891$ | 94,711,891$ |
| 19 | New York Islanders | 5795 | 3500 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 40565 | 24500 | 13983 | 27063 | 6992 | 100.00% | 100.00% | 99.88% | 96.65% | 99.89% | 34 | 16158 - 99.16% | 1,891,449$ | 13,240,146$ | 16295 | 100 | 80,018,333$ | 59,996,387$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 28,129,526$ | 28,129,526$ |
| 20 | New York Rangers | 6280 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 11455 | 9501 | 3696 | 7099 | 1994 | 91.20% | 95.01% | 92.40% | 88.74% | 99.70% | 39 | 16873 - 92.30% | 1,977,327$ | 3,954,654$ | 18280 | 100 | 75,269,934$ | 65,944,167$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 49,285,064$ | 49,285,064$ |
| 21 | Ottawa Senators | 7153 | 5000 | 2000 | 4000 | 1000 | 130 | 67 | 47 | 32 | 230 | 92975 | 65000 | 26000 | 52000 | 13000 | 99.98% | 100.00% | 100.00% | 100.00% | 100.00% | 28 | 19152 - 99.99% | 2,060,100$ | 26,781,300$ | 19153 | 100 | 75,850,000$ | 63,100,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 128,603,528$ | 128,603,528$ |
| 22 | Philadelphia Flyers | 7519 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19519 | 100 | 75,133,333$ | 66,844,167$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 57,876,801$ | 57,876,801$ |
| 23 | Pittsburgh Penguins | 6087 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18087 | 100 | 64,985,000$ | 48,830,554$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 67,432,860$ | 67,432,860$ |
| 24 | San Jose Sharks | 5496 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 16488 | 14235 | 5852 | 11322 | 2932 | 100.00% | 94.90% | 97.53% | 94.35% | 97.73% | 38 | 16943 - 96.84% | 1,947,596$ | 5,842,788$ | 17496 | 100 | 69,600,000$ | 68,950,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 55,603,595$ | 55,603,595$ |
| 25 | St.Louis Blues | 7250 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 59713 | 43465 | 17497 | 34894 | 8836 | 91.51% | 96.59% | 97.21% | 96.93% | 98.18% | 32 | 18267 - 94.89% | 2,152,288$ | 19,370,592$ | 19250 | 100 | 68,738,333$ | 59,627,777$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 135,774,296$ | 135,774,296$ |
| 26 | Tampa Bay Lightning | 7758 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19758 | 100 | 64,526,667$ | 63,310,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 76,127,713$ | 76,127,713$ |
| 27 | Toronto Maple Leafs | 7300 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 12748 | 10000 | 3883 | 7748 | 1994 | 87.32% | 100.00% | 97.08% | 96.85% | 99.70% | 39 | 18187 - 94.23% | 2,129,130$ | 4,258,260$ | 19300 | 100 | 76,600,000$ | 68,177,777$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 20,560,909$ | 20,560,909$ |
| 28 | Vancouver Canucks | 6630 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18630 | 100 | 67,314,102$ | 45,603,610$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 19,019,603$ | 19,019,603$ |
| 29 | Vegas Golden Knights | 5900 | 4900 | 1900 | 3900 | 900 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 17500 | 100 | 64,191,667$ | 67,000,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 56,863,558$ | 56,863,558$ |
| 30 | Washington Capitals | 6672 | 5000 | 2000 | 4000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18672 | 100 | 57,798,333$ | 53,484,719$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 40,359,505$ | 40,359,505$ |
| 31 | Winnipeg Jets | 5015 | 4000 | 2000 | 3000 | 1000 | 140 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 15015 | 100 | 63,557,143$ | 64,902,777$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,800,000$ | 79,500,000$ | 79,500,000$ | 46,988,402$ | 46,988,402$ |