| 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 70,600,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Blackhawks | 6000 | 5000 | 5000 | 5000 | 1000 | 100 | 50 | 30 | 15 | 180 | 14328 | 14979 | 13546 | 14956 | 3000 | 79.60% | 99.86% | 90.31% | 99.71% | 100.00% | 38 | 20270 - 92.13% | 1,665,060$ | 4,995,180$ | 22000 | 100 | 94,957,860$ | 94,957,860$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 72,630,360$ | 72,630,360$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 10000 | 8000 | 8288 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18144 - 100.00% | 1,287,837$ | 2,575,674$ | 18144 | 100 | 91,155,000$ | 91,155,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | -79,447,032$ | -79,447,032$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 68,200,084$ | 68,200,084$ | 5,937,500$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 213,704,899$ | 213,704,899$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 12872 | 11680 | 10137 | 9979 | 2000 | 91.94% | 97.33% | 84.48% | 99.79% | 100.00% | 39 | 23334 - 93.34% | 1,684,807$ | 3,369,614$ | 25000 | 100 | 82,946,061$ | 82,946,061$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 49,661,627$ | 49,661,627$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 82 | 50 | 36 | 15 | 178 | 23868 | 20000 | 12772 | 16000 | 4000 | 99.45% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 19160 - 99.83% | 1,627,441$ | 6,509,764$ | 19193 | 100 | 58,428,333$ | 58,428,333$ | 620,046$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 105,104,863$ | 105,104,863$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 18000 | 15000 | 14054 | 13500 | 3081 | 100.00% | 100.00% | 98.62% | 100.00% | 100.00% | 38 | 21212 - 99.69% | 1,661,114$ | 4,983,343$ | 21277 | 100 | 93,375,000$ | 93,375,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 81,873,346$ | 81,873,346$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 58 | 36 | 16 | 130 | 15000 | 12000 | 9522 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 17174 - 100.00% | 1,438,243$ | 4,314,729$ | 17174 | 100 | 90,379,881$ | 90,379,881$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | -18,421,599$ | -18,421,599$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 17974 | 15000 | 13693 | 14050 | 3846 | 99.86% | 100.00% | 80.53% | 78.06% | 85.47% | 38 | 21521 - 89.05% | 1,681,892$ | 5,045,677$ | 24168 | 100 | 86,833,420$ | 86,833,420$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 133,834,084$ | 133,834,084$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 86 | 59 | 37 | 21 | 200 | 27500 | 22500 | 15000 | 17500 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 17500 - 100.00% | 1,673,270$ | 8,366,350$ | 17500 | 100 | 88,795,807$ | 88,795,807$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 109,314,894$ | 109,314,894$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 17963 | 17252 | 12903 | 12620 | 3065 | 98.16% | 98.58% | 95.15% | 93.48% | 95.78% | 37 | 15951 - 96.58% | 1,706,996$ | 6,827,985$ | 16515 | 100 | 94,451,857$ | 94,451,857$ | 662,250$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 221,139,006$ | 221,139,006$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19618 | 100 | 91,225,000$ | 91,225,000$ | -2,437,500$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | -9,576,685$ | -9,576,685$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 95 | 60 | 25 | 10 | 210 | 16923 | 13771 | 14483 | 17064 | 2967 | 94.02% | 91.81% | 96.55% | 94.80% | 98.90% | 38 | 21736 - 94.50% | 1,741,189$ | 5,223,568$ | 23000 | 100 | 83,909,999$ | 83,909,999$ | 3,500,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 136,538,208$ | 136,538,208$ |
| 13 | Mammoth | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 16000 | 16000 | 14000 | 12000 | 5706 | 100.00% | 100.00% | 100.00% | 100.00% | 83.91% | 37 | 15927 - 98.31% | 1,349,158$ | 5,396,630$ | 16200 | 100 | 99,675,000$ | 99,675,000$ | -4,500,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 222,601,049$ | 222,601,049$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 70 | 45 | 30 | 25 | 165 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21800 | 100 | 78,514,999$ | 78,514,999$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 26,116,770$ | 26,116,770$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 21545 | 19988 | 10400 | 15649 | 4000 | 89.77% | 99.94% | 100.00% | 97.81% | 100.00% | 37 | 17896 - 96.21% | 1,720,716$ | 6,882,862$ | 18600 | 100 | 61,066,667$ | 61,066,667$ | 11,000,000$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 35,536,239$ | 35,536,239$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 38 | 14 | 200 | 35954 | 30000 | 19500 | 29724 | 6000 | 99.87% | 100.00% | 100.00% | 99.08% | 100.00% | 35 | 20196 - 99.73% | 1,672,142$ | 10,032,850$ | 20250 | 100 | 100,175,000$ | 100,175,000$ | -4,750,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 99,021,028$ | 99,021,028$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22700 | 100 | 95,206,191$ | 95,206,191$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 26,733,162$ | 26,733,162$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 85 | 75 | 35 | 25 | 100 | 27998 | 19663 | 18000 | 19602 | 6000 | 99.99% | 98.32% | 100.00% | 98.01% | 100.00% | 37 | 22816 - 99.20% | 1,688,055$ | 6,752,221$ | 23000 | 100 | 100,499,999$ | 100,499,999$ | -8,750,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 128,235,667$ | 128,235,667$ |
| 19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 81 | 43 | 42 | 17 | 190 | 17901 | 15000 | 7956 | 12000 | 3000 | 99.45% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18619 - 99.82% | 1,590,889$ | 4,772,668$ | 18652 | 100 | 86,205,500$ | 86,205,500$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | -15,001,898$ | -15,001,898$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 21019 | 14811 | 11046 | 11074 | 3372 | 70.06% | 59.24% | 55.23% | 55.37% | 67.44% | 36 | 12264 - 61.32% | 2,043,717$ | 10,218,584$ | 20000 | 100 | 95,164,280$ | 95,164,280$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 4,847,012$ | 4,847,012$ |