| 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é de l’aréna | 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é de l’aréna | 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 52,000,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Boston Bruins | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 24000 | 110 | 57,750,000$ | 57,750,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 99,280,264$ | 99,280,264$ |
| 2 | Buffalo Sabres | 7050 | 6400 | 3750 | 6100 | 1700 | 150 | 100 | 70 | 50 | 250 | 14100 | 12800 | 7500 | 12200 | 3400 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 25000 - 100.00% | 2,286,500$ | 4,573,000$ | 25000 | 110 | 75,650,000$ | 75,650,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 126,748,844$ | 126,748,844$ |
| 3 | Calgary Flames | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 14000 | 12000 | 6900 | 12000 | 3100 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 24000 - 100.00% | 2,192,150$ | 4,384,300$ | 24000 | 110 | 76,800,000$ | 76,800,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 105,182,955$ | 105,182,955$ |
| 4 | Chicago Blackhawks | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 20400 | 17400 | 9750 | 17400 | 4050 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 23000 - 100.00% | 2,086,750$ | 6,260,250$ | 23000 | 110 | 73,900,000$ | 73,900,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 1 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 96,481,761$ | 96,481,761$ |
| 5 | Detroit Red Wings | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 20400 | 17400 | 9750 | 17400 | 4050 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 23000 - 100.00% | 2,086,750$ | 6,260,250$ | 23000 | 110 | 72,550,000$ | 72,550,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 64,537,284$ | 64,537,284$ |
| 6 | Edmonton Oilers | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 20400 | 17400 | 9750 | 17400 | 4050 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 23000 - 100.00% | 2,086,750$ | 6,260,250$ | 23000 | 110 | 78,250,000$ | 78,250,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 81,570,879$ | 81,570,879$ |
| 7 | Hartford Whalers | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 21000 | 18000 | 10350 | 18000 | 4650 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 24000 - 100.00% | 2,192,150$ | 6,576,450$ | 24000 | 110 | 73,900,000$ | 73,900,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 79,350,243$ | 79,350,243$ |
| 8 | Los Angeles Kings | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 110 | 71,000,000$ | 71,000,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 106,982,623$ | 106,982,623$ |
| 9 | Montreal Canadiens | 10400 | 6800 | 5250 | 6700 | 1900 | 150 | 100 | 70 | 50 | 250 | 37533 | 27200 | 17433 | 26750 | 7364 | 90.22% | 100.00% | 83.01% | 99.81% | 96.89% | 37 | 29070 - 93.62% | 2,709,112$ | 10,836,447$ | 31050 | 110 | 71,700,000$ | 71,700,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 219,010,449$ | 219,010,449$ |
| 10 | New York Rangers | 7800 | 7400 | 5000 | 7600 | 2200 | 150 | 100 | 70 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 30000 | 110 | 70,775,000$ | 70,775,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 184,843,947$ | 184,843,947$ |
| 11 | Ottawa Senators | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 110 | 74,900,000$ | 74,900,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 41,823,829$ | 41,823,829$ |
| 12 | Philadelphia Flyers | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 27200 | 23200 | 13000 | 23200 | 5400 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 23000 - 100.00% | 2,086,750$ | 8,347,000$ | 23000 | 110 | 78,450,000$ | 78,450,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 99,757,435$ | 99,757,435$ |
| 13 | Pittsburgh Penguins | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 27200 | 23200 | 13000 | 23200 | 5400 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 23000 - 100.00% | 2,086,750$ | 8,347,000$ | 23000 | 110 | 70,200,000$ | 70,200,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 74,365,660$ | 74,365,660$ |
| 14 | Quebec Nordiques | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 28000 | 24000 | 13800 | 24000 | 6200 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 24000 - 100.00% | 2,192,150$ | 8,768,600$ | 24000 | 110 | 69,600,000$ | 69,600,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 91,907,244$ | 91,907,244$ |
| 15 | San Jose Sharks | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 28000 | 24000 | 13800 | 24000 | 6200 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 24000 - 100.00% | 2,192,150$ | 8,768,600$ | 24000 | 110 | 75,750,000$ | 75,750,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 79,478,985$ | 79,478,985$ |
| 16 | St.Louis Blues | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 24000 | 110 | 66,500,000$ | 66,500,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 144,598,423$ | 144,598,423$ |
| 17 | Toronto Maple Leafs | 6800 | 5800 | 3250 | 5800 | 1350 | 150 | 100 | 70 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 110 | 73,850,000$ | 73,850,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 53,106,625$ | 53,106,625$ |
| 18 | Vancouver Canucks | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 14000 | 12000 | 6900 | 12000 | 3100 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 24000 - 100.00% | 2,192,150$ | 4,384,300$ | 24000 | 110 | 74,650,000$ | 74,650,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 99,874,231$ | 99,874,231$ |
| 19 | Washington Capitals | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 28000 | 24000 | 13800 | 24000 | 6200 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 24000 - 100.00% | 2,192,150$ | 8,768,600$ | 24000 | 110 | 75,650,000$ | 75,650,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 143,408,908$ | 143,408,908$ |
| 20 | Winnipeg Jets | 7000 | 6000 | 3450 | 6000 | 1550 | 150 | 100 | 70 | 50 | 250 | 21000 | 18000 | 10350 | 18000 | 4650 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 24000 - 100.00% | 2,192,150$ | 6,576,450$ | 24000 | 110 | 69,900,000$ | 69,900,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 75,000,000$ | 75,000,000$ | 97,725,014$ | 97,725,014$ |