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 35,000,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 59,690,000$ | 49,440,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 119,774,150$ | 119,774,150$ | 53,774,150$ | 53,774,150$ |
2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 63,450,000$ | 42,771,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 67,975,368$ | 67,975,368$ | 1,975,368$ | 1,975,368$ |
3 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 64,025,000$ | 53,970,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 92,740,090$ | 92,740,090$ | 26,740,090$ | 26,740,090$ |
4 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 61,550,000$ | 46,425,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 96,130,067$ | 96,130,067$ | 30,130,067$ | 30,130,067$ |
5 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 64,600,000$ | 51,100,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 81,740,618$ | 81,740,618$ | 15,740,618$ | 15,740,618$ |
6 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 64,950,000$ | 59,745,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 67,859,028$ | 67,859,028$ | 1,859,028$ | 1,859,028$ |
7 | Capitals | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 67,950,000$ | 58,200,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 68,287,091$ | 68,287,091$ | 2,287,091$ | 2,287,091$ |
8 | Devils | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 61,900,000$ | 52,650,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 86,116,687$ | 86,116,687$ | 20,116,687$ | 20,116,687$ |
9 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 61,400,000$ | 44,025,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 109,053,740$ | 109,053,740$ | 43,053,740$ | 43,053,740$ |
10 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 56,100,000$ | 48,400,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 69,096,757$ | 69,096,757$ | 3,096,757$ | 3,096,757$ |
11 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 64,695,000$ | 47,525,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 105,487,251$ | 105,487,251$ | 39,487,251$ | 39,487,251$ |
12 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 49,345,000$ | 42,975,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 72,775,242$ | 72,775,242$ | 6,775,242$ | 6,775,242$ |
13 | Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 66,000,000$ | 52,025,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 68,338,048$ | 68,338,048$ | 2,338,048$ | 2,338,048$ |
14 | Kings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 65,595,000$ | 49,945,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 76,341,772$ | 76,341,772$ | 10,341,772$ | 10,341,772$ |
15 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 48,700,000$ | 28,800,000$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 73,985,071$ | 73,985,071$ | 7,985,071$ | 7,985,071$ |
16 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 64,345,000$ | 52,495,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 115,543,711$ | 115,543,711$ | 49,543,711$ | 49,543,711$ |
17 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 62,600,000$ | 47,800,000$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 76,300,762$ | 76,300,762$ | 10,300,762$ | 10,300,762$ |
18 | Panthers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 40,100,000$ | 33,650,000$ | 0$ | 0$ | 0$ | 0$ | 17 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 84,341,038$ | 84,341,038$ | 18,341,038$ | 18,341,038$ |
19 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 61,050,000$ | 55,195,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 98,093,935$ | 98,093,935$ | 32,093,935$ | 32,093,935$ |
20 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 64,100,000$ | 56,600,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 72,441,274$ | 72,441,274$ | 6,441,274$ | 6,441,274$ |
21 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 48,950,000$ | 39,925,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 110,226,993$ | 110,226,993$ | 44,226,993$ | 44,226,993$ |
22 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 61,600,000$ | 55,250,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 91,822,890$ | 91,822,890$ | 25,822,890$ | 25,822,890$ |
23 | Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 63,175,000$ | 51,175,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 69,818,628$ | 69,818,628$ | 3,818,628$ | 3,818,628$ |
24 | Senateurs | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 62,250,000$ | 49,000,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 69,742,391$ | 69,742,391$ | 3,742,391$ | 3,742,391$ |
25 | Sharks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 59,200,000$ | 48,695,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 72,550,144$ | 72,550,144$ | 6,550,144$ | 6,550,144$ |
26 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 40 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 62,275,000$ | 48,325,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -35,000,000$ | 86,093,206$ | 86,093,206$ | 20,093,206$ | 20,093,206$ |