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 | Revenus | Dépenses | Éstimation | Total de l'Équipe Éstimé | ||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | É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 - % | Revenus Moyen par Match | Revenus Annuels à ce Jour | Capacité de l'Aréna | Popularité de l'Équipe | Salaire Total des Joueurs | Salaire Total Moyen des Joueurs | Valeur du Cap Salarial Spécial | Dépenses Annuelles à Ce Jour | Cap Salarial Par Jour | Cap salarial à ce jour | Joueurs Inclut dans la Cap Salariale | Joueurs Exclut dans la Cap Salariale | Taxe de Luxe Totale | Revenus de la Saison Éstimés | Jours Restants de la Saison | Dépenses Par Jour | Dépenses de la Saison Éstimées | Dépenses de la Saison Éstimées | Cap Salarial de la Saison Éstimé | Au dessus du Plafond Salarial Minimum of 61,500,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
1 | Avalanche | 3360 | 4480 | 5600 | 6720 | 2240 | 125 | 70 | 45 | 30 | 225 | 10080 | 13440 | 16800 | 20160 | 6720 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 22400 - 100.00% | 2,266,208$ | 6,798,624$ | 22400 | 127 | 80,775,000$ | 80,775,000$ | -1,862,800$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 45,362,995$ | 45,362,995$ |
2 | Blackhawks | 3000 | 4000 | 5000 | 6000 | 2000 | 127 | 82 | 54 | 32 | 232 | 21000 | 28000 | 35000 | 42000 | 14000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 20000 - 100.00% | 2,190,900$ | 15,336,300$ | 20000 | 121 | 82,400,000$ | 82,400,000$ | -1,815,304$ | 0$ | 0$ | 0$ | 22 | 0 | 66,672$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 67,391,265$ | 67,391,265$ |
3 | BlueJackets | 3000 | 4000 | 5000 | 6000 | 2000 | 112 | 82 | 59 | 27 | 218 | 12000 | 16000 | 19752 | 24000 | 8000 | 100.00% | 100.00% | 98.76% | 100.00% | 100.00% | 37 | 19938 - 99.69% | 2,081,478$ | 8,325,913$ | 20000 | 112 | 80,600,000$ | 80,600,000$ | -1,704,276$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 33,944,924$ | 33,944,924$ |
4 | Blues | 3000 | 4000 | 5000 | 6000 | 2000 | 120 | 80 | 50 | 30 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 111 | 73,200,000$ | 73,200,000$ | 2,450,110$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 22,498,181$ | 22,498,181$ |
5 | Bruins | 3000 | 4000 | 5000 | 6000 | 2000 | 110 | 74 | 48 | 25 | 221 | 9000 | 12000 | 15000 | 18000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 20000 - 100.00% | 1,953,720$ | 5,861,160$ | 20000 | 97 | 82,250,000$ | 82,250,000$ | -1,838,651$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 24,308,498$ | 24,308,498$ |
6 | Canadiens | 3750 | 5000 | 6250 | 7500 | 2500 | 135 | 85 | 60 | 35 | 240 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 157 | 77,950,000$ | 77,950,000$ | -4,842,661$ | 0$ | 0$ | 0$ | 22 | 0 | 910,104$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 62,790,665$ | 62,790,665$ |
7 | Capitals | 3750 | 5000 | 6250 | 7500 | 2500 | 111 | 68 | 46 | 28 | 210 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 117 | 78,185,000$ | 78,185,000$ | -1,031,379$ | 0$ | 0$ | 0$ | 20 | 0 | 696,008$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 36,475,835$ | 36,475,835$ |
8 | Ducks | 3750 | 5000 | 6250 | 7500 | 2500 | 115 | 75 | 50 | 30 | 216 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 124 | 81,000,000$ | 81,000,000$ | -298,381$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 34,521,968$ | 34,521,968$ |
9 | Flames | 3750 | 5000 | 6250 | 7500 | 2500 | 110 | 75 | 50 | 25 | 215 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 141 | 78,950,000$ | 78,950,000$ | -1,797,255$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 41,801,836$ | 41,801,836$ |
10 | Flyers | 3300 | 4400 | 5500 | 6600 | 2200 | 118 | 67 | 47 | 28 | 220 | 6600 | 8800 | 11000 | 13200 | 4400 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 22000 - 100.00% | 2,159,410$ | 4,318,820$ | 22000 | 115 | 65,600,000$ | 65,600,000$ | 2,496,685$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 33,793,490$ | 33,793,490$ |
11 | GoldenKnights | 3750 | 5000 | 6250 | 7500 | 2500 | 135 | 90 | 65 | 40 | 240 | 13915 | 18340 | 22020 | 24710 | 9656 | 74.21% | 73.36% | 70.46% | 65.89% | 77.25% | 36 | 17728 - 70.91% | 2,215,359$ | 11,076,795$ | 25000 | 95 | 73,183,333$ | 73,183,333$ | -1,844,477$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 37,113,715$ | 37,113,715$ |
12 | Islanders | 3750 | 5000 | 6250 | 7500 | 2500 | 121 | 80 | 51 | 29 | 224 | 7500 | 10000 | 12500 | 15000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 25000 - 100.00% | 2,613,000$ | 5,226,000$ | 25000 | 142 | 84,875,000$ | 84,875,000$ | -753,854$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 55,400,532$ | 55,400,532$ |
13 | Jets | 3750 | 5000 | 6250 | 7500 | 2500 | 94 | 63 | 47 | 19 | 193 | 48750 | 65000 | 81250 | 97500 | 32500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 28 | 25000 - 100.00% | 2,125,575$ | 27,632,475$ | 25000 | 117 | 63,050,000$ | 63,050,000$ | 2,784,239$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 71,918,493$ | 71,918,493$ |
14 | Kings | 2709 | 3612 | 4515 | 5418 | 1806 | 135 | 90 | 65 | 35 | 240 | 21672 | 28896 | 36120 | 43344 | 14448 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 33 | 18060 - 100.00% | 2,150,055$ | 17,200,437$ | 18060 | 120 | 70,150,000$ | 70,150,000$ | 2,269,011$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 61,633,720$ | 61,633,720$ |
15 | Maple Leafs | 3750 | 5000 | 6250 | 7500 | 2500 | 135 | 90 | 65 | 40 | 240 | 18566 | 24794 | 30434 | 34841 | 12500 | 99.02% | 99.18% | 97.39% | 92.91% | 100.00% | 36 | 24227 - 96.91% | 2,977,405$ | 14,887,025$ | 25000 | 134 | 74,600,000$ | 74,600,000$ | -1,184,521$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 82,777,616$ | 82,777,616$ |
16 | Oilers | 3750 | 5000 | 6250 | 7500 | 2500 | 134 | 89 | 60 | 34 | 240 | 11250 | 15000 | 18750 | 22500 | 7500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 25000 - 100.00% | 2,917,850$ | 8,753,550$ | 25000 | 158 | 92,225,000$ | 92,225,000$ | -4,669,455$ | 0$ | 0$ | 0$ | 25 | 0 | 3,106,176$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 68,493,637$ | 68,493,637$ |
17 | Pengouins | 3000 | 4000 | 5000 | 6000 | 2000 | 115 | 75 | 50 | 30 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 146 | 81,530,000$ | 81,530,000$ | -1,800,224$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 11,637,281$ | 11,637,281$ |
18 | Predateurs | 3750 | 5000 | 6250 | 7500 | 2500 | 130 | 85 | 58 | 24 | 240 | 7500 | 10000 | 12500 | 15000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 25000 - 100.00% | 2,766,263$ | 5,532,525$ | 25000 | 147 | 86,100,000$ | 86,100,000$ | -6,069,251$ | 0$ | 0$ | 0$ | 23 | 0 | 3,993,388$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 37,787,699$ | 37,787,699$ |
19 | Rangers | 3600 | 4800 | 6000 | 7200 | 2400 | 125 | 75 | 50 | 32 | 225 | 21600 | 28800 | 36000 | 43200 | 14400 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 24000 - 100.00% | 2,519,736$ | 15,118,416$ | 24000 | 137 | 86,350,000$ | 86,350,000$ | -5,812,659$ | 0$ | 0$ | 0$ | 21 | 0 | 176,692$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 63,688,150$ | 63,688,150$ |
20 | Red Wings | 3188 | 4250 | 5312 | 6375 | 2125 | 115 | 75 | 50 | 28 | 240 | 38256 | 51000 | 63744 | 76500 | 25500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 29 | 21250 - 100.00% | 2,196,890$ | 26,362,680$ | 21250 | 109 | 85,550,000$ | 85,550,000$ | -1,754,337$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 48,930,635$ | 48,930,635$ |
21 | Sabres | 3000 | 4000 | 5000 | 6000 | 2000 | 135 | 90 | 65 | 40 | 240 | 20964 | 28000 | 34710 | 41303 | 14000 | 99.83% | 100.00% | 99.17% | 98.34% | 100.00% | 34 | 19854 - 99.27% | 2,415,524$ | 16,908,669$ | 20000 | 115 | 83,950,000$ | 83,950,000$ | -1,863,359$ | 0$ | 0$ | 0$ | 23 | 0 | 536,676$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 33,889,919$ | 33,889,919$ |
22 | Senateurs | 2700 | 3600 | 4500 | 5400 | 1800 | 120 | 88 | 60 | 33 | 230 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 121 | 81,465,000$ | 81,465,000$ | -1,775,994$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 23,815,428$ | 23,815,428$ |
23 | Sharks | 3000 | 4000 | 5000 | 6000 | 2000 | 98 | 59 | 35 | 21 | 204 | 9000 | 11935 | 15000 | 18000 | 6000 | 100.00% | 99.46% | 100.00% | 100.00% | 100.00% | 38 | 19978 - 99.89% | 1,658,547$ | 4,975,641$ | 20000 | 84 | 75,400,000$ | 75,400,000$ | -1,413,305$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 13,938,856$ | 13,938,856$ |
24 | Wild | 3750 | 5000 | 6250 | 7500 | 2500 | 95 | 54 | 30 | 17 | 194 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 85,600,000$ | 85,600,000$ | -5,698,015$ | 0$ | 0$ | 0$ | 25 | 0 | 2,015,052$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -61,500,000$ | 83,200,000$ | 83,200,000$ | 16,263,897$ | 16,263,897$ |