| 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 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 51,400,000$ | 51,400,000$ | 0$ | 0$ | 0$ | 0$ | 14 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18144 | 100 | 47,323,333$ | 47,323,333$ | 0$ | 0$ | 0$ | 0$ | 14 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 38,969,167$ | 38,969,167$ | 2,500,000$ | 0$ | 0$ | 0$ | 14 | 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 | 55,500,000$ | 55,500,000$ | 0$ | 0$ | 0$ | 0$ | 16 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19193 | 100 | 35,440,000$ | 35,440,000$ | 620,046$ | 0$ | 0$ | 0$ | 14 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21277 | 100 | 50,000,000$ | 50,000,000$ | 0$ | 0$ | 0$ | 0$ | 15 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 17174 | 100 | 53,200,000$ | 53,200,000$ | 0$ | 0$ | 0$ | 0$ | 16 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 24168 | 100 | 68,838,333$ | 68,838,333$ | 0$ | 0$ | 0$ | 0$ | 22 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 17500 | 100 | 19,882,474$ | 19,882,474$ | 0$ | 0$ | 0$ | 0$ | 9 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 16515 | 100 | 63,802,000$ | 63,802,000$ | 662,250$ | 0$ | 0$ | 0$ | 20 | 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 | 51,900,000$ | 51,900,000$ | 0$ | 0$ | 0$ | 0$ | 15 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 79,609,999$ | 79,609,999$ | 0$ | 0$ | 0$ | 0$ | 22 | 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 | 59,200,000$ | 59,200,000$ | 0$ | 0$ | 0$ | 0$ | 16 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18600 | 100 | 47,800,000$ | 47,800,000$ | 0$ | 0$ | 0$ | 0$ | 14 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20250 | 100 | 54,025,000$ | 54,025,000$ | -2,500,000$ | 0$ | 0$ | 0$ | 14 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22700 | 100 | 52,601,667$ | 52,601,667$ | 0$ | 0$ | 0$ | 0$ | 16 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 62,274,999$ | 62,274,999$ | 0$ | 0$ | 0$ | 0$ | 14 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18652 | 100 | 60,280,500$ | 60,280,500$ | 0$ | 0$ | 0$ | 0$ | 19 | 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 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 61,850,000$ | 61,850,000$ | 0$ | 0$ | 0$ | 0$ | 13 | 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 | 73,081,666$ | 73,081,666$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -58,546,442$ | 78,061,923$ | 78,061,923$ | 264,186,881$ | 264,186,881$ |