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 49,360,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
1 | Anaheim | 6000 | 5000 | 3000 | 3000 | 1500 | 175 | 90 | 65 | 40 | 325 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 76,379,167$ | 76,379,167$ | -3,500,000$ | 0$ | 0$ | 0$ | 26 | 3 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 184,563,438$ | 184,563,438$ |
2 | Boston | 6105 | 5180 | 2035 | 4070 | 1110 | 180 | 100 | 99 | 98 | 350 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 70,470,836$ | 69,831,947$ | 2,246,823$ | 0$ | 0$ | 0$ | 24 | 2 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 189,785,417$ | 189,785,417$ |
3 | Buffalo | 7500 | 6000 | 2500 | 4000 | 2000 | 125 | 75 | 50 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 64,863,335$ | 64,577,621$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 167,660,105$ | 167,660,105$ |
4 | Calgary | 6500 | 5250 | 2250 | 4000 | 1500 | 200 | 100 | 100 | 100 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19500 | 100 | 66,257,502$ | 66,400,359$ | -1,190,476$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 307,804,710$ | 307,804,710$ |
5 | Caroline | 6000 | 5000 | 2000 | 4000 | 1000 | 140 | 82 | 64 | 42 | 299 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 69,390,919$ | 71,105,205$ | 307,334$ | 0$ | 0$ | 0$ | 24 | 1 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 178,366,915$ | 178,366,915$ |
6 | Chicago | 7000 | 6000 | 2500 | 5000 | 1500 | 200 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 72,889,167$ | 73,889,167$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 464,543,393$ | 464,543,393$ |
7 | Colorado | 6000 | 5000 | 2500 | 4000 | 1000 | 160 | 100 | 65 | 40 | 300 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 70,464,446$ | 70,607,303$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 284,133,279$ | 284,133,279$ |
8 | Columbus | 6700 | 5800 | 3000 | 5000 | 1500 | 135 | 70 | 50 | 35 | 260 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 71,460,621$ | 71,679,668$ | -1,696,429$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 295,642,378$ | 295,642,378$ |
9 | Dallas | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 67 | 65 | 27 | 275 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 66,444,947$ | 66,444,947$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 128,641,343$ | 128,641,343$ |
10 | Detroit | 7500 | 6000 | 2000 | 5000 | 1500 | 150 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 66,662,548$ | 66,733,977$ | 429$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 348,054,351$ | 348,054,351$ |
11 | Edmonton | 6000 | 5000 | 2500 | 4000 | 1750 | 180 | 100 | 50 | 20 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19250 | 100 | 73,735,000$ | 73,985,000$ | 0$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 187,433,857$ | 187,433,857$ |
12 | Hartford | 7000 | 5000 | 2500 | 4000 | 1500 | 110 | 87 | 68 | 55 | 215 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 70,527,502$ | 71,444,169$ | 689,270$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 242,500,519$ | 242,500,519$ |
13 | Islanders | 6500 | 5000 | 2000 | 4000 | 1000 | 110 | 75 | 50 | 37 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 67,734,039$ | 67,595,467$ | -2,380,952$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 173,577,653$ | 173,577,653$ |
14 | Kansas City | 240 | 6000 | 3000 | 4000 | 1500 | 185 | 100 | 60 | 55 | 399 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 14740 | 100 | 68,345,000$ | 68,345,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 216,441,443$ | 216,441,443$ |
15 | LA Kings | 6000 | 5000 | 3500 | 4000 | 1500 | 120 | 70 | 30 | 25 | 160 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 63,780,000$ | 64,565,714$ | -440,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 232,292,525$ | 232,292,525$ |
16 | Las Vegas | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 66,477,168$ | 67,977,168$ | -1,033,333$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 157,620,919$ | 157,620,919$ |
17 | Minnesota | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 56,623,335$ | 57,290,002$ | 3,500,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 76,787,262$ | 76,787,262$ |
18 | Montreal | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 76 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 57,751,927$ | 57,753,032$ | 1,896,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 273,198,411$ | 273,198,411$ |
19 | Nashville | 6700 | 5800 | 3200 | 4500 | 1800 | 120 | 80 | 60 | 40 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 46,206,669$ | 46,206,669$ | 16,197,889$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 259,173,218$ | 259,173,218$ |
20 | Ottawa | 7500 | 6000 | 2000 | 5000 | 1500 | 175 | 100 | 99 | 95 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 78,142,333$ | 78,142,333$ | 0$ | 0$ | 0$ | 0$ | 34 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 326,929,510$ | 326,929,510$ |
21 | Philadelphie | 7000 | 5000 | 2500 | 3837 | 1200 | 110 | 80 | 60 | 50 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19537 | 100 | 52,207,058$ | 52,207,058$ | -1,041,667$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 187,162,899$ | 187,162,899$ |
22 | Pittsburgh | 6100 | 5150 | 2650 | 4300 | 1050 | 144 | 84 | 59 | 36 | 316 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19250 | 100 | 77,644,167$ | 77,144,167$ | -1,604,167$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 278,490,599$ | 278,490,599$ |
23 | Quebec | 7000 | 4000 | 3000 | 3500 | 1000 | 200 | 100 | 75 | 50 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 71,414,501$ | 71,414,501$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 164,908,200$ | 164,908,200$ |
24 | Rangers | 6000 | 6000 | 2500 | 4000 | 1000 | 130 | 60 | 40 | 30 | 260 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19500 | 100 | 58,676,391$ | 58,841,206$ | 4,571,429$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 172,499,533$ | 172,499,533$ |
25 | San Jose | 6600 | 5600 | 2650 | 5000 | 1000 | 130 | 80 | 55 | 40 | 344 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20850 | 100 | 53,579,500$ | 52,722,357$ | 1,234,740$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 218,209,424$ | 218,209,424$ |
26 | Seattle | 6000 | 5000 | 2500 | 4000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 78,786,111$ | 77,571,825$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 54,170,494$ | 54,170,494$ |
27 | St-Louis | 6500 | 5500 | 3500 | 3000 | 1500 | 200 | 100 | 99 | 75 | 395 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 67,451,988$ | 65,651,988$ | 1,033,333$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 411,640,148$ | 411,640,148$ |
28 | Tampa Bay | 6000 | 5000 | 2500 | 4000 | 1000 | 125 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 63,680,000$ | 63,680,000$ | -595,833$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 259,725,107$ | 259,725,107$ |
29 | Toronto | 6000 | 5000 | 2500 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 69,301,667$ | 68,956,429$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 95,466,858$ | 95,466,858$ |
30 | Vancouver | 5000 | 7000 | 4000 | 4000 | 2000 | 120 | 70 | 50 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 70,535,838$ | 71,035,838$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 145,292,165$ | 145,292,165$ |
31 | Washington | 6000 | 5000 | 2500 | 4000 | 1000 | 130 | 85 | 40 | 30 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 71,521,461$ | 71,521,461$ | 0$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 162,276,138$ | 162,276,138$ |
32 | Winnipeg | 6500 | 5500 | 2500 | 4000 | 1500 | 105 | 75 | 60 | 50 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 75,773,449$ | 75,973,449$ | 0$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 0$ | 14 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 147,580,482$ | 147,580,482$ |