| 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 | Cap Salarial de la Saison estimé | Au dessus du plancher salarial of 40,000,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Anaheim | 8333 | 6944 | 2778 | 5556 | 1389 | 66 | 50 | 41 | 22 | 157 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 25000 | 100 | 54,640,000$ | 53,105,500$ | 5,388,505$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 37,729,739$ | 37,729,739$ |
| 2 | Boston | 8333 | 6944 | 2778 | 5556 | 1389 | 110 | 65 | 49 | 35 | 175 | 20309 | 22993 | 11112 | 16166 | 4296 | 60.93% | 82.78% | 100.00% | 72.74% | 77.32% | 37 | 18719 - 74.88% | 1,784,715$ | 7,138,858$ | 25000 | 100 | 72,930,000$ | 69,539,250$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 16,529,659$ | 16,529,659$ |
| 3 | Buffalo | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 75 | 55 | 45 | 215 | 35802 | 30000 | 12000 | 23354 | 5725 | 99.45% | 100.00% | 100.00% | 97.31% | 95.42% | 35 | 17814 - 98.96% | 1,754,401$ | 10,526,406$ | 18000 | 100 | 64,762,550$ | 63,772,550$ | 4,673,500$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 32,824,083$ | 32,824,083$ |
| 4 | Chicago | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 75 | 60 | 45 | 200 | 54870 | 37395 | 15006 | 28370 | 7596 | 94.07% | 76.93% | 77.17% | 72.95% | 78.12% | 34 | 20462 - 81.85% | 1,866,932$ | 13,068,522$ | 25000 | 100 | 64,637,000$ | 64,043,000$ | 2,022,650$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 35,665,133$ | 35,665,133$ |
| 5 | Colorado | 6500 | 5000 | 2000 | 4000 | 1000 | 87 | 56 | 43 | 32 | 175 | 13000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18500 - 100.00% | 1,481,400$ | 2,962,800$ | 18500 | 100 | 62,305,000$ | 56,266,000$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 32,613,081$ | 32,613,081$ |
| 6 | Columbus | 8333 | 6944 | 2778 | 5556 | 1389 | 100 | 60 | 40 | 30 | 200 | 15601 | 15887 | 7364 | 14320 | 2931 | 62.41% | 76.26% | 88.36% | 85.91% | 70.34% | 38 | 18701 - 74.80% | 1,725,062$ | 5,175,186$ | 25000 | 100 | 68,806,000$ | 67,717,000$ | 1,100,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 10,578,054$ | 10,578,054$ |
| 7 | Dallas | 8333 | 6944 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 45584 | 41228 | 17556 | 33150 | 8190 | 68.38% | 74.22% | 79.00% | 74.58% | 73.70% | 33 | 18214 - 72.85% | 2,001,473$ | 16,011,780$ | 25000 | 100 | 60,148,500$ | 61,708,500$ | 922,500$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 42,133,258$ | 42,133,258$ |
| 8 | Detroit | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 60 | 45 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 71,970,000$ | 67,861,500$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 15,683,583$ | 15,683,583$ |
| 9 | Edmonton | 6000 | 5000 | 2720 | 5480 | 1000 | 95 | 65 | 40 | 25 | 190 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20200 | 100 | 58,360,000$ | 58,360,000$ | 1,830,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 4,001,798$ | 4,001,798$ |
| 10 | Floride | 6000 | 5100 | 2778 | 5556 | 1000 | 90 | 75 | 55 | 45 | 200 | 54000 | 44656 | 21488 | 37775 | 8954 | 100.00% | 97.29% | 85.95% | 75.54% | 99.49% | 32 | 18541 - 90.74% | 1,717,562$ | 15,458,058$ | 20434 | 100 | 66,273,000$ | 66,273,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 19,276,303$ | 19,276,303$ |
| 11 | Los Angeles | 6000 | 5000 | 2000 | 4000 | 1000 | 99 | 69 | 59 | 35 | 199 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 52,625,000$ | 45,497,000$ | 4,415,732$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 10,618,459$ | 10,618,459$ |
| 12 | Minnesota | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 60 | 50 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20200 | 100 | 65,812,500$ | 55,863,000$ | 6,050,133$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | -5,649,198$ | -5,649,198$ |
| 13 | Montreal | 6415 | 5870 | 2778 | 5556 | 1145 | 85 | 60 | 45 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21764 | 100 | 61,210,000$ | 58,537,000$ | 2,355,000$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 14,319,989$ | 14,319,989$ |
| 14 | NYIslanders | 6000 | 5000 | 2720 | 5480 | 1000 | 95 | 74 | 40 | 28 | 195 | 12000 | 9844 | 5440 | 10960 | 1962 | 100.00% | 98.44% | 100.00% | 100.00% | 98.10% | 39 | 20103 - 99.52% | 1,665,316$ | 3,330,631$ | 20200 | 100 | 60,192,845$ | 60,192,845$ | 817,500$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 20,253,149$ | 20,253,149$ |
| 15 | NYRangers | 7000 | 6000 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 30380 | 29011 | 12331 | 23321 | 5909 | 72.33% | 80.59% | 73.98% | 69.96% | 70.90% | 35 | 16825 - 74.05% | 1,841,533$ | 11,049,198$ | 22723 | 100 | 67,900,000$ | 67,108,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 12,175,320$ | 12,175,320$ |
| 16 | Philadelphie | 7033 | 6944 | 2778 | 5556 | 1389 | 115 | 70 | 54 | 32 | 200 | 76204 | 71378 | 30945 | 64876 | 13426 | 90.29% | 85.66% | 92.83% | 97.31% | 80.55% | 29 | 21402 - 90.31% | 2,007,050$ | 24,084,601$ | 23700 | 100 | 67,602,500$ | 67,602,500$ | 1,560,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 36,557,244$ | 36,557,244$ |
| 17 | Pittsburgh | 7360 | 5400 | 2600 | 4800 | 1075 | 77 | 63 | 41 | 32 | 177 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21235 | 100 | 66,280,000$ | 58,954,000$ | 3,171,000$ | 0$ | 0$ | 0$ | 32 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 11,872,337$ | 11,872,337$ |
| 18 | San Jose | 8333 | 6944 | 2778 | 5556 | 1000 | 125 | 80 | 60 | 45 | 220 | 71459 | 64422 | 28408 | 52094 | 11708 | 71.46% | 77.31% | 85.22% | 78.13% | 97.57% | 29 | 19008 - 77.23% | 2,063,431$ | 24,761,166$ | 24611 | 100 | 65,679,000$ | 64,788,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 45,195,904$ | 45,195,904$ |
| 19 | Seattle | 7250 | 6000 | 2778 | 4500 | 1050 | 100 | 70 | 55 | 35 | 175 | 16345 | 14593 | 6054 | 11675 | 2954 | 75.15% | 81.07% | 72.64% | 86.48% | 93.78% | 38 | 17207 - 79.74% | 1,779,890$ | 5,339,670$ | 21578 | 100 | 64,458,500$ | 63,914,000$ | 2,291,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 11,107,180$ | 11,107,180$ |
| 20 | St. Louis | 6400 | 6944 | 2778 | 5556 | 1389 | 88 | 62 | 39 | 30 | 120 | 19200 | 19471 | 8120 | 15965 | 4107 | 100.00% | 93.47% | 97.43% | 95.78% | 98.56% | 38 | 22288 - 96.62% | 1,674,109$ | 5,022,326$ | 23067 | 100 | 67,570,000$ | 61,907,200$ | 1,300,000$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 16,071,932$ | 16,071,932$ |
| 21 | Tampa Bay | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 65 | 50 | 22 | 184 | 24000 | 20000 | 9508 | 21920 | 4000 | 100.00% | 100.00% | 87.39% | 100.00% | 100.00% | 37 | 19857 - 98.30% | 1,474,092$ | 5,896,368$ | 20200 | 100 | 67,290,000$ | 65,904,000$ | 1,200,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 1,262,819$ | 1,262,819$ |
| 22 | Vancouver | 8333 | 6944 | 2778 | 5556 | 1289 | 115 | 75 | 55 | 40 | 200 | 33640 | 29944 | 12700 | 23973 | 6367 | 67.28% | 71.87% | 76.19% | 71.91% | 82.32% | 35 | 17771 - 71.37% | 1,844,777$ | 11,068,662$ | 24900 | 100 | 65,125,000$ | 65,125,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 12,945,732$ | 12,945,732$ |
| 23 | Washington | 7333 | 6944 | 2778 | 5556 | 1089 | 75 | 59 | 36 | 29 | 160 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23700 | 100 | 51,826,000$ | 49,895,500$ | 4,070,950$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 25,209,231$ | 25,209,231$ |
| 24 | Winnipeg | 6000 | 6000 | 2778 | 4000 | 1389 | 87 | 65 | 54 | 32 | 175 | 12000 | 11912 | 4605 | 8000 | 2360 | 100.00% | 99.27% | 82.88% | 100.00% | 84.95% | 39 | 19439 - 96.39% | 1,641,570$ | 3,283,140$ | 20167 | 100 | 69,475,000$ | 69,475,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 65,000,000$ | 65,000,000$ | 48,027,047$ | 48,027,047$ |
Bridgeport
Charlotte
Cleveland
Grand Rapids
Hartford
Hershey
Laval
Lehigh Valley
Providence
Rochester
Syracuse
Wilkes-Barre/Scranton
Abbotsford
Bakersfield
Coachella Valley
Eagles
Iowa
Manitoba
Ontario
Rockford
San Diego
San Jose
Springfield
Texas