| 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é | Prix des billets | Assistance | Assistance PCT | Revenu | Dépenses | Estimation | Total de l’équipe estimé | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | É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 - % | Revenu moyen par match | Revenu annuel à ce jour | Capacité | Popularité de l’équipe | Salaire total des joueurs | Plafond Salariale total des joueurs | Valeur du plafond salarial spécial | Dépenses annuelles à ce jour | Plafond salarial par jour | Plafond salarial à ce jour | Joueurs Inclus dans le plafond salarial | Joueurs exclut du plafond Salarial | Taxe de luxe totale | Revenus de la saison estimés | Jours restants de la saison | Dépenses par jour | Dépenses de la saison estimées | Dépenses de la saison estimées | Cap Salarial de la Saison estimé | Au dessus du plancher salarial of 0$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Boston Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 12000 | 10000 | 4000 | 8000 | 1838 | 100.00% | 100.00% | 100.00% | 100.00% | 91.90% | 39 | 17919 - 99.55% | 1,253,800$ | 2,507,600$ | 18000 | 100 | 47,600,000$ | 47,600,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 49,002,482$ | 49,002,482$ |
| 2 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 34,917,000$ | 34,917,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 88,014,043$ | 88,014,043$ |
| 3 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 18000 | 15000 | 6000 | 12000 | 2753 | 100.00% | 100.00% | 100.00% | 100.00% | 91.77% | 38 | 17918 - 99.54% | 1,253,533$ | 3,760,600$ | 18000 | 100 | 45,725,000$ | 45,725,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 32,270,288$ | 32,270,288$ |
| 4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 99 | 59 | 34 | 24 | 199 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 45,375,000$ | 45,375,000$ | 2,415,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 38,414,294$ | 38,414,294$ |
| 5 | Colorado Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 47,599,999$ | 47,599,999$ | 0$ | 0$ | 0$ | 0$ | 21 | 2 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 35,323,998$ | 35,323,998$ |
| 6 | Dallas Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 18000 | 15000 | 6000 | 12000 | 2708 | 100.00% | 100.00% | 100.00% | 100.00% | 90.27% | 38 | 17903 - 99.46% | 1,250,533$ | 3,751,600$ | 18000 | 100 | 54,000,000$ | 54,000,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 46,134,348$ | 46,134,348$ |
| 7 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 12000 | 10000 | 4000 | 8000 | 1770 | 100.00% | 100.00% | 100.00% | 100.00% | 88.50% | 39 | 17885 - 99.36% | 1,247,000$ | 2,494,000$ | 18000 | 100 | 61,750,000$ | 61,750,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 46,194,868$ | 46,194,868$ |
| 8 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 65 | 40 | 25 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 61,500,000$ | 61,500,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 23,026,046$ | 23,026,046$ |
| 9 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 26,750,000$ | 26,750,000$ | 1,925,000$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 83,152,313$ | 83,152,313$ |
| 10 | Minnesota Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 18000 | 15000 | 6000 | 12000 | 2639 | 100.00% | 100.00% | 100.00% | 100.00% | 87.97% | 38 | 17880 - 99.33% | 1,245,933$ | 3,737,800$ | 18000 | 100 | 46,500,000$ | 46,500,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 52,877,757$ | 52,877,757$ |
| 11 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 29,200,000$ | 29,200,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 60,416,973$ | 60,416,973$ |
| 12 | Nashville Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 35,900,000$ | 35,900,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 46,523,918$ | 46,523,918$ |
| 13 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 68 | 45 | 28 | 210 | 17589 | 13205 | 4922 | 11005 | 2606 | 97.72% | 88.03% | 82.03% | 91.71% | 86.87% | 38 | 16442 - 91.35% | 1,273,892$ | 3,821,675$ | 18000 | 100 | 56,650,000$ | 56,650,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 45,243,950$ | 45,243,950$ |
| 14 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 12000 | 10000 | 4000 | 8000 | 1825 | 100.00% | 100.00% | 100.00% | 100.00% | 91.25% | 39 | 17913 - 99.51% | 1,252,500$ | 2,505,000$ | 18000 | 100 | 50,100,000$ | 50,100,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 43,945,180$ | 43,945,180$ |
| 15 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 30 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 58,499,999$ | 58,499,999$ | 2,100,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 50,170,219$ | 50,170,219$ |
| 16 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 12000 | 10000 | 4000 | 8000 | 1860 | 100.00% | 100.00% | 100.00% | 100.00% | 93.00% | 39 | 17930 - 99.61% | 1,256,000$ | 2,512,000$ | 18000 | 100 | 60,000,000$ | 60,000,000$ | 175,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 68,179,996$ | 68,179,996$ |
| 17 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 18000 | 15000 | 6000 | 11980 | 2697 | 100.00% | 100.00% | 100.00% | 99.83% | 89.90% | 38 | 17892 - 99.40% | 1,249,633$ | 3,748,900$ | 18000 | 100 | 57,500,000$ | 57,500,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 40,113,914$ | 40,113,914$ |
| 18 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 12000 | 10000 | 4000 | 8000 | 1793 | 100.00% | 100.00% | 100.00% | 100.00% | 89.65% | 39 | 17897 - 99.43% | 1,249,300$ | 2,498,600$ | 18000 | 100 | 53,000,000$ | 53,000,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 33,535,152$ | 33,535,152$ |
| 19 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 20 | 190 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 39,425,000$ | 39,425,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 17,362,430$ | 17,362,430$ |
| 20 | Utah Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 120 | 70 | 50 | 25 | 9580 | 8090 | 3157 | 6502 | 3000 | 53.22% | 53.93% | 52.62% | 54.18% | 100.00% | 38 | 10110 - 56.16% | 1,169,297$ | 3,507,890$ | 18000 | 100 | 31,850,000$ | 31,850,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 28,306,524$ | 28,306,524$ |
| 21 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 18000 | 15000 | 6000 | 12000 | 2661 | 100.00% | 100.00% | 100.00% | 100.00% | 88.70% | 38 | 17887 - 99.37% | 1,247,400$ | 3,742,200$ | 18000 | 100 | 59,450,000$ | 59,450,000$ | 350,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 71,056,435$ | 71,056,435$ |
| 22 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 39,650,000$ | 39,650,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 2 | 0$ | 0$ | 0$ | 0$ | 0$ | 63,000,000$ | 63,000,000$ | 43,366,096$ | 43,366,096$ |