| 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 | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 47 | 35 | 160 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 95,762,500$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 58,538,110$ | 58,538,110$ |
| 2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 83,928,523$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 75,818,436$ | 75,818,436$ |
| 3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 55 | 34 | 300 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 94,675,000$ | 0$ | 1,750,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 21,181,652$ | 21,181,652$ |
| 4 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 68,310,000$ | 0$ | 4,250,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 47,988,323$ | 47,988,323$ |
| 5 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 85,523,707$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 35,297,352$ | 35,297,352$ |
| 6 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 165 | 99 | 79 | 39 | 224 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 79,300,175$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 17,510,440$ | 17,510,440$ |
| 7 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 55 | 30 | 20 | 175 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 84,458,689$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 50,815,880$ | 50,815,880$ |
| 8 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 42 | 25 | 195 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 84,888,333$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 265,983$ | 265,983$ |
| 9 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 82,411,666$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 82,295,666$ | 82,295,666$ |
| 10 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 54 | 33 | 22 | 165 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 91,826,647$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 29,945,523$ | 29,945,523$ |
| 11 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 65 | 45 | 35 | 125 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 79,715,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 28,649,134$ | 28,649,134$ |
| 12 | Golden Seals | 6000 | 5000 | 2000 | 4000 | 1000 | 60 | 35 | 16 | 10 | 100 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 81,329,769$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 13,725,009$ | 13,725,009$ |
| 13 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 75,053,333$ | 0$ | 7,400,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 74,571,550$ | 74,571,550$ |
| 14 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 60 | 45 | 27 | 210 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 80,850,000$ | 0$ | 3,000,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 44,584,756$ | 44,584,756$ |
| 15 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 50 | 30 | 10 | 160 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 93,967,857$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 34,155,130$ | 34,155,130$ |
| 16 | Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 91,800,000$ | 0$ | 2,000,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 33,967,380$ | 33,967,380$ |
| 17 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 75 | 55 | 40 | 150 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 89,925,834$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 49,003,490$ | 49,003,490$ |
| 18 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 45 | 22 | 225 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 83,116,666$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 2,456,021$ | 2,456,021$ |
| 19 | Maroons | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 92,906,667$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 29,148,761$ | 29,148,761$ |
| 20 | Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 50 | 25 | 10 | 160 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 84,037,500$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 24,048,909$ | 24,048,909$ |
| 21 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 38 | 23 | 190 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 91,482,583$ | 0$ | 1,500,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 47,883,574$ | 47,883,574$ |
| 22 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 75,333,334$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 63,674,583$ | 63,674,583$ |
| 23 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 60 | 35 | 20 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 79,592,857$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 42,894,802$ | 42,894,802$ |
| 24 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 65 | 40 | 25 | 195 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 85,450,002$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 21,130,278$ | 21,130,278$ |
| 25 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 90,605,357$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 47,365,916$ | 47,365,916$ |
| 26 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 130 | 85 | 50 | 25 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 78,561,667$ | 0$ | 4,750,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 19,179,540$ | 19,179,540$ |
| 27 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 62 | 50 | 25 | 186 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 95,988,421$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 15,745,922$ | 15,745,922$ |
| 28 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 55 | 33 | 18 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 85,182,143$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 12,041,213$ | 12,041,213$ |
| 29 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 1 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 80,817,857$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 56,787,790$ | 56,787,790$ |
| 30 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 75 | 45 | 30 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 73,130,000$ | 0$ | 3,250,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 7,483,253$ | 7,483,253$ |
| 31 | Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 125 | 120 | 80 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 71,001,667$ | 0$ | 5,390,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 37,273,526$ | 37,273,526$ |
| 32 | Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 2 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 95,090,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 27,317,527$ | 27,317,527$ |