| 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$ | 3 | 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$ | 3 | 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$ | 3 | 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$ | 3 | 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 | 29868 | 25000 | 15965 | 20000 | 5000 | 99.56% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 19167 - 99.86% | 1,628,247$ | 8,141,237$ | 19193 | 100 | 59,380,916$ | 59,380,916$ | 620,046$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 106,736,336$ | 106,736,336$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 24000 | 20000 | 18804 | 18000 | 4108 | 100.00% | 100.00% | 98.97% | 100.00% | 100.00% | 37 | 21228 - 99.77% | 1,661,723$ | 6,646,891$ | 21277 | 100 | 93,375,000$ | 93,375,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 83,536,894$ | 83,536,894$ |
| 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$ | 3 | 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$ | 3 | 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$ | 3 | 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$ | 3 | 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$ | 3 | 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 | 65 | 30 | 10 | 215 | 22923 | 18768 | 19271 | 22814 | 3967 | 95.51% | 93.84% | 96.36% | 95.06% | 99.18% | 37 | 21936 - 95.37% | 1,794,219$ | 7,176,876$ | 23000 | 100 | 83,909,999$ | 83,909,999$ | 3,500,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 138,491,516$ | 138,491,516$ |
| 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$ | 3 | 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$ | 3 | 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 | 27385 | 24988 | 13000 | 19649 | 5000 | 91.28% | 99.95% | 100.00% | 98.25% | 100.00% | 36 | 18004 - 96.80% | 1,733,457$ | 8,667,286$ | 18600 | 100 | 61,066,667$ | 61,066,667$ | 11,000,000$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 37,320,663$ | 37,320,663$ |
| 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$ | 3 | 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$ | 3 | 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 | 95 | 70 | 50 | 20 | 120 | 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$ | 3 | 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$ | 3 | 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$ | 3 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 4,847,012$ | 4,847,012$ |