| 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 | Salaire total moyen 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 58,546,442$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Blackhawks | 6000 | 5000 | 5000 | 5000 | 1000 | 100 | 50 | 30 | 15 | 180 | 9794 | 10000 | 8855 | 9876 | 2000 | 81.62% | 100.00% | 88.55% | 98.76% | 100.00% | 39 | 20263 - 92.10% | 1,678,627$ | 3,357,253$ | 22000 | 100 | 78,814,167$ | 78,814,167$ | -3,000,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 102,482,658$ | 102,482,658$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 20000 | 16000 | 16569 | 16000 | 4000 | 100.00% | 100.00% | 99.96% | 100.00% | 100.00% | 37 | 18142 - 99.99% | 1,287,759$ | 5,151,035$ | 18144 | 100 | 76,686,666$ | 76,686,666$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | -39,843,381$ | -39,843,381$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 16279 | 11296 | 9070 | 8583 | 2704 | 67.83% | 56.48% | 56.69% | 53.64% | 67.60% | 37 | 11983 - 59.92% | 1,999,968$ | 7,999,870$ | 20000 | 100 | 66,355,834$ | 66,355,834$ | 2,500,000$ | 0$ | 0$ | 0$ | 30 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 220,805,922$ | 220,805,922$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 100 | 64,845,000$ | 64,845,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 71,749,668$ | 71,749,668$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 84 | 52 | 37 | 15 | 175 | 12000 | 10000 | 6386 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 19193 - 100.00% | 1,664,540$ | 3,329,080$ | 19193 | 100 | 52,952,333$ | 52,952,333$ | 6,245,046$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 111,436,221$ | 111,436,221$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 35792 | 30000 | 27627 | 27000 | 6162 | 99.42% | 100.00% | 96.94% | 100.00% | 100.00% | 35 | 21097 - 99.15% | 1,653,996$ | 9,923,974$ | 21277 | 100 | 77,787,499$ | 77,787,499$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 106,786,614$ | 106,786,614$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 55 | 40 | 22 | 125 | 25000 | 20000 | 15816 | 18253 | 5000 | 100.00% | 100.00% | 99.66% | 91.27% | 100.00% | 36 | 16814 - 97.90% | 1,455,493$ | 7,277,467$ | 17174 | 100 | 76,700,000$ | 76,700,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 7,910,837$ | 7,910,837$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 17978 | 15000 | 12714 | 13890 | 3904 | 99.88% | 100.00% | 74.77% | 77.17% | 86.76% | 38 | 21162 - 87.56% | 1,670,593$ | 5,011,780$ | 24168 | 100 | 60,838,333$ | 60,838,333$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 150,293,658$ | 150,293,658$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 84 | 56 | 36 | 19 | 195 | 22000 | 18000 | 12000 | 14000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 17500 - 100.00% | 1,614,415$ | 6,457,660$ | 17500 | 100 | 72,529,974$ | 72,529,974$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 122,810,295$ | 122,810,295$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 36569 | 35000 | 26925 | 26732 | 6290 | 99.92% | 100.00% | 99.28% | 99.01% | 98.28% | 33 | 16440 - 99.54% | 1,748,739$ | 13,989,909$ | 16515 | 100 | 76,093,000$ | 76,093,000$ | 903,675$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 247,487,907$ | 247,487,907$ |
| 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 | 73,766,667$ | 73,766,667$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 19,247,983$ | 19,247,983$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 85 | 60 | 20 | 12 | 200 | 53237 | 41344 | 44054 | 49301 | 8984 | 98.59% | 91.88% | 97.90% | 91.30% | 99.82% | 32 | 21880 - 95.13% | 1,701,129$ | 15,310,161$ | 23000 | 100 | 70,977,499$ | 70,977,499$ | 1,500,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 154,078,088$ | 154,078,088$ |
| 13 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 75 | 44 | 32 | 12 | 165 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21800 | 100 | 72,513,333$ | 72,513,333$ | -1,150,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 46,156,027$ | 46,156,027$ |
| 14 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 15778 | 15000 | 7800 | 11282 | 3000 | 87.66% | 100.00% | 100.00% | 94.02% | 100.00% | 38 | 17620 - 94.73% | 1,699,424$ | 5,098,273$ | 18600 | 100 | 78,375,000$ | 78,375,000$ | -2,750,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 38,662,658$ | 38,662,658$ |
| 15 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 35 | 15 | 200 | 65513 | 55000 | 35750 | 53958 | 10995 | 99.26% | 100.00% | 100.00% | 98.11% | 99.95% | 30 | 20111 - 99.31% | 1,659,408$ | 18,253,487$ | 20250 | 100 | 79,924,999$ | 79,924,999$ | -2,625,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 124,192,046$ | 124,192,046$ |
| 16 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 13598 | 12866 | 12509 | 11146 | 3750 | 71.38% | 77.98% | 95.85% | 92.88% | 50.00% | 38 | 17956 - 79.10% | 1,759,439$ | 5,278,317$ | 22700 | 100 | 69,510,000$ | 69,510,000$ | 1,150,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 84,170,912$ | 84,170,912$ |
| 17 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 70 | 56 | 25 | 12 | 85 | 20175 | 14474 | 12899 | 14373 | 4257 | 96.07% | 96.49% | 95.55% | 95.82% | 94.60% | 38 | 22059 - 95.91% | 1,529,530$ | 4,588,589$ | 23000 | 100 | 79,404,999$ | 79,404,999$ | -2,750,000$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 162,783,770$ | 162,783,770$ |
| 18 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 86 | 46 | 43 | 18 | 180 | 30000 | 25000 | 13260 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18652 - 100.00% | 1,656,934$ | 8,284,670$ | 18652 | 100 | 72,569,667$ | 72,569,667$ | 1,000,250$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 2,905,760$ | 2,905,760$ |
| 19 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 63486 | 45757 | 34822 | 35206 | 10495 | 81.39% | 70.40% | 66.97% | 67.70% | 80.73% | 28 | 14597 - 72.99% | 2,422,299$ | 31,489,892$ | 20000 | 100 | 76,480,832$ | 76,480,832$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 21,845,305$ | 21,845,305$ |
| 20 | Utah HC | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 16200 | 100 | 77,890,000$ | 77,890,000$ | 1,500,000$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 264,186,881$ | 264,186,881$ |