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 | Compte bancaire actuel | Compte bancaire projeté |
1 | Avalanche | 6000 | 4919 | 1990 | 3900 | 1000 | 350 | 300 | 250 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 17809 | 100 | 95,510,478$ | 95,510,478$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 18,439,322$ | 18,439,322$ |
2 | Blackhawks | 6500 | 5500 | 2500 | 4200 | 1017 | 175 | 100 | 75 | 50 | 350 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 19717 | 100 | 93,870,533$ | 93,870,533$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 21,781,874$ | 21,781,874$ |
3 | Blue Jackets | 6144 | 5000 | 2000 | 4000 | 1000 | 155 | 100 | 80 | 60 | 355 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18144 | 100 | 81,506,206$ | 82,104,203$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 18,512,901$ | 18,512,901$ |
4 | Blues | 6024 | 5024 | 2024 | 4024 | 1000 | 125 | 80 | 50 | 25 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18096 | 100 | 91,402,333$ | 90,516,500$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 34,865,789$ | 34,865,789$ |
5 | Bruins | 5613 | 4613 | 1613 | 3613 | 2113 | 350 | 300 | 250 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 17565 | 100 | 89,908,690$ | 89,908,691$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 75,665,495$ | 75,665,495$ |
6 | Canadiens | 6527 | 5527 | 3527 | 4524 | 1000 | 350 | 300 | 250 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 21105 | 100 | 94,788,458$ | 94,788,458$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 54,564,995$ | 54,564,995$ |
7 | Ducks | 6295 | 4295 | 2295 | 3289 | 1000 | 85 | 45 | 30 | 20 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 17174 | 100 | 75,234,722$ | 75,234,722$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 54,647,150$ | 54,647,150$ |
8 | Flames | 6325 | 5325 | 2325 | 4314 | 1000 | 160 | 125 | 80 | 60 | 300 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 19289 | 100 | 90,397,083$ | 90,113,750$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 84,140,495$ | 84,140,495$ |
9 | Flyers | 6200 | 5200 | 3100 | 4043 | 1000 | 240 | 150 | 90 | 70 | 450 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 19543 | 100 | 87,987,024$ | 87,987,024$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 67,193,359$ | 67,193,359$ |
10 | Golden Knights | 5842 | 3842 | 2842 | 3842 | 1000 | 350 | 230 | 180 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 17368 | 100 | 87,983,174$ | 87,983,174$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 20,220,917$ | 20,220,917$ |
11 | Islanders | 5800 | 3800 | 2713 | 3800 | 1000 | 350 | 300 | 250 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 17113 | 100 | 89,372,500$ | 89,372,500$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 43,811,023$ | 43,811,023$ |
12 | Jets | 5100 | 4100 | 2100 | 3021 | 1000 | 350 | 300 | 250 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 15321 | 100 | 92,264,357$ | 92,264,357$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 57,225,579$ | 57,225,579$ |
13 | Kings | 6070 | 5070 | 2070 | 4020 | 1000 | 200 | 140 | 70 | 60 | 290 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18230 | 100 | 85,259,166$ | 85,259,166$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 29,226,867$ | 29,226,867$ |
14 | Lightning | 6273 | 5273 | 2273 | 4273 | 1000 | 170 | 120 | 90 | 50 | 320 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 19092 | 100 | 97,975,000$ | 97,975,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 58,865,495$ | 58,865,495$ |
15 | Maple Leafs | 6650 | 5650 | 2250 | 4250 | 1000 | 300 | 250 | 200 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 19800 | 100 | 92,096,332$ | 91,746,332$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 69,665,495$ | 69,665,495$ |
16 | Oilers | 6092 | 5085 | 2085 | 4085 | 1000 | 155 | 125 | 80 | 65 | 285 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18347 | 100 | 93,448,917$ | 92,448,916$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 36,271,934$ | 36,271,934$ |
17 | Penguins | 6000 | 4500 | 2500 | 4347 | 1000 | 120 | 100 | 65 | 25 | 150 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18347 | 100 | 83,394,167$ | 83,394,167$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 19,663,832$ | 19,663,832$ |
18 | Rangers | 7744 | 4250 | 2250 | 4256 | 1000 | 200 | 125 | 90 | 80 | 400 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 19500 | 100 | 78,117,042$ | 78,117,042$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 59,084,187$ | 59,084,187$ |
19 | Red Wings | 6475 | 5375 | 2375 | 4290 | 1000 | 155 | 84 | 66 | 45 | 310 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 19515 | 100 | 75,399,167$ | 74,174,167$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 25,618,603$ | 25,618,603$ |
20 | Senators | 6200 | 5200 | 2200 | 4052 | 1000 | 195 | 115 | 80 | 65 | 287 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 18652 | 100 | 82,930,417$ | 82,930,417$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 39,339,960$ | 39,339,960$ |
21 | Sharks | 6150 | 4150 | 2131 | 4131 | 1000 | 120 | 110 | 80 | 70 | 130 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 17562 | 100 | 83,075,000$ | 83,075,000$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 19,826,559$ | 19,826,559$ |
22 | Stars | 6223 | 5223 | 2323 | 4323 | 1000 | 210 | 160 | 125 | 85 | 300 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0 | 0 - 0.00% | 0$ | 0$ | 19092 | 100 | 79,688,462$ | 81,687,462$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 66,890,242$ | 66,890,242$ |