| 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$ | 0 | 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 | 106,855,000$ | 106,855,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 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$ | 0 | 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$ | 0 | 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 | 35868 | 30000 | 19158 | 24000 | 6000 | 99.63% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 19171 - 99.89% | 1,628,785$ | 9,772,710$ | 19193 | 100 | 78,660,000$ | 78,660,000$ | 620,046$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 108,367,809$ | 108,367,809$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 30000 | 25000 | 23554 | 22500 | 5135 | 100.00% | 100.00% | 99.17% | 100.00% | 100.00% | 36 | 21238 - 99.82% | 1,662,088$ | 8,310,439$ | 21277 | 100 | 93,375,000$ | 93,375,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 85,200,442$ | 85,200,442$ |
| 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 | 106,428,589$ | 106,428,589$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 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 | 120,002,944$ | 120,002,944$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 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 | 60500 | 49500 | 33000 | 38500 | 11000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 17500 - 100.00% | 1,673,270$ | 18,405,970$ | 17500 | 100 | 88,795,807$ | 88,795,807$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 119,354,514$ | 119,354,514$ |
| 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$ | 0 | 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$ | 0 | 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 | 100 | 65 | 30 | 10 | 220 | 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$ | 0 | 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$ | 0 | 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$ | 0 | 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$ | 0 | 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 | 77954 | 65000 | 42250 | 64724 | 13000 | 99.94% | 100.00% | 100.00% | 99.58% | 100.00% | 28 | 20225 - 99.88% | 1,673,150$ | 21,750,955$ | 20250 | 100 | 100,175,000$ | 100,175,000$ | -4,750,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 110,739,133$ | 110,739,133$ |
| 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$ | 0 | 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 | 80 | 45 | 25 | 145 | 47324 | 34367 | 29376 | 33128 | 10500 | 96.58% | 98.19% | 93.26% | 94.65% | 100.00% | 34 | 22099 - 96.08% | 1,894,136$ | 13,258,955$ | 23000 | 100 | 100,499,999$ | 100,499,999$ | -8,750,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 134,742,401$ | 134,742,401$ |
| 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 | 107,213,000$ | 107,213,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 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 | 36554 | 25677 | 19389 | 19462 | 5902 | 76.15% | 64.19% | 60.59% | 60.82% | 73.78% | 33 | 13373 - 66.87% | 2,226,824$ | 17,814,588$ | 20000 | 100 | 95,164,280$ | 95,164,280$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -70,600,000$ | 95,500,000$ | 95,500,000$ | 12,443,016$ | 12,443,016$ |