| 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 | 87 | 65 | 54 | 32 | 175 | 111153 | 86620 | 32839 | 81797 | 19657 | 78.46% | 73.38% | 69.54% | 86.60% | 83.25% | 24 | 19533 - 78.13% | 1,596,923$ | 27,147,685$ | 25000 | 100 | 63,991,700$ | 62,011,700$ | 1,928,000$ | 28,763,346$ | 310,058$ | 26,106,546$ | 21 | 0 | 0$ | 38,326,144$ | 116 | 343,808$ | 39,881,728$ | 42,477,907$ | 64,001,274$ | 24,001,274$ | 65,000,000$ | 998,726$ | 23,185,954$ | 22,132,145$ |
| 2 | Boston | 8333 | 6944 | 2778 | 5556 | 1389 | 110 | 65 | 49 | 35 | 175 | 81849 | 92533 | 34610 | 68060 | 20710 | 54.57% | 74.03% | 69.21% | 68.05% | 82.83% | 23 | 16542 - 66.17% | 1,555,861$ | 28,005,504$ | 25000 | 100 | 65,095,000$ | 62,620,000$ | 1,227,800$ | 28,297,750$ | 313,100$ | 26,056,909$ | 23 | 0 | 0$ | 35,784,811$ | 116 | 340,475$ | 39,495,100$ | 41,492,656$ | 63,604,309$ | 23,604,309$ | 65,000,000$ | 1,395,691$ | 1,867,539$ | -794,181$ |
| 3 | Buffalo | 6500 | 5000 | 2000 | 4000 | 1200 | 125 | 80 | 60 | 45 | 220 | 67130 | 64415 | 27678 | 49841 | 13162 | 60.75% | 75.78% | 81.41% | 73.30% | 64.52% | 24 | 13072 - 69.90% | 1,474,311$ | 25,063,282$ | 18700 | 100 | 61,360,000$ | 61,360,000$ | 1,152,000$ | 27,551,300$ | 306,800$ | 26,543,300$ | 20 | 0 | 0$ | 35,383,457$ | 116 | 318,800$ | 36,980,800$ | 39,227,551$ | 63,284,100$ | 23,284,100$ | 65,000,000$ | 1,715,900$ | 9,221,767$ | 8,360,318$ |
| 4 | Chicago | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 75 | 60 | 45 | 200 | 113328 | 69516 | 26780 | 49925 | 14218 | 80.00% | 58.89% | 56.71% | 52.86% | 60.21% | 24 | 16104 - 64.42% | 1,520,627$ | 25,850,666$ | 25000 | 100 | 66,223,000$ | 58,373,000$ | 0$ | 27,768,910$ | 291,865$ | 25,077,410$ | 20 | 1 | 0$ | 36,495,058$ | 116 | 356,615$ | 41,367,340$ | 44,654,605$ | 58,933,750$ | 18,933,750$ | 65,000,000$ | 6,066,250$ | 24,979,514$ | 19,959,524$ |
| 5 | Colorado | 6500 | 5000 | 2000 | 4000 | 1000 | 87 | 56 | 43 | 32 | 175 | 114586 | 90000 | 36000 | 72000 | 18000 | 97.94% | 100.00% | 100.00% | 100.00% | 100.00% | 23 | 18366 - 99.28% | 1,511,481$ | 27,206,655$ | 18500 | 100 | 60,650,000$ | 53,350,000$ | 0$ | 27,362,375$ | 266,750$ | 25,435,875$ | 21 | 1 | 0$ | 34,764,059$ | 116 | 325,750$ | 37,787,000$ | 40,989,461$ | 56,378,875$ | 16,378,875$ | 65,000,000$ | 8,621,125$ | 32,321,473$ | 29,047,974$ |
| 6 | Columbus | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 50 | 35 | 25 | 180 | 119522 | 109522 | 46974 | 89886 | 20221 | 79.68% | 87.62% | 93.94% | 89.88% | 80.88% | 23 | 21451 - 85.81% | 1,564,856$ | 28,167,406$ | 25000 | 100 | 63,970,000$ | 63,970,000$ | 0$ | 29,831,900$ | 319,850$ | 27,059,900$ | 21 | 0 | 0$ | 35,991,685$ | 116 | 352,850$ | 40,930,600$ | 43,532,662$ | 64,162,500$ | 24,162,500$ | 65,000,000$ | 837,500$ | 9,377,253$ | 4,916,177$ |
| 7 | Dallas | 8333 | 6944 | 2778 | 5556 | 1389 | 70 | 55 | 40 | 30 | 130 | 98315 | 86367 | 40165 | 71661 | 18774 | 65.55% | 69.10% | 80.32% | 71.66% | 75.09% | 23 | 17516 - 70.06% | 1,504,808$ | 27,086,535$ | 25000 | 100 | 59,734,500$ | 59,734,500$ | 922,500$ | 26,437,616$ | 298,672$ | 24,925,616$ | 20 | 0 | 0$ | 34,610,572$ | 116 | 316,672$ | 36,733,952$ | 38,512,061$ | 60,494,068$ | 20,494,068$ | 65,000,000$ | 4,505,932$ | 18,986,465$ | 18,190,209$ |
| 8 | Detroit | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 60 | 45 | 220 | 67523 | 65934 | 28211 | 49416 | 12899 | 66.20% | 77.57% | 82.97% | 72.67% | 75.88% | 24 | 13175 - 73.20% | 1,487,223$ | 25,282,797$ | 18000 | 100 | 67,560,000$ | 60,407,250$ | 1,537,500$ | 29,741,325$ | 302,036$ | 25,578,996$ | 24 | 0 | 0$ | 35,693,360$ | 116 | 352,800$ | 40,924,800$ | 43,647,408$ | 62,152,672$ | 22,152,672$ | 65,000,000$ | 2,847,328$ | -973,037$ | -5,987,054$ |
| 9 | Edmonton | 6000 | 5100 | 2778 | 5556 | 1000 | 95 | 65 | 40 | 25 | 185 | 97102 | 87408 | 46738 | 93210 | 15893 | 89.91% | 95.22% | 93.47% | 93.20% | 88.29% | 23 | 18908 - 92.53% | 1,511,304$ | 27,203,473$ | 20434 | 100 | 56,560,000$ | 55,966,000$ | 1,350,000$ | 25,581,200$ | 279,830$ | 23,450,630$ | 23 | 0 | 0$ | 34,759,993$ | 116 | 305,300$ | 35,414,800$ | 38,128,084$ | 57,260,910$ | 17,260,910$ | 65,000,000$ | 7,739,090$ | 6,731,983$ | 6,876,939$ |
| 10 | Floride | 6000 | 5100 | 2778 | 5556 | 1000 | 90 | 75 | 55 | 45 | 200 | 108000 | 71838 | 31572 | 52604 | 15638 | 100.00% | 78.25% | 63.14% | 52.60% | 86.88% | 23 | 15536 - 76.03% | 1,530,416$ | 27,547,481$ | 20434 | 100 | 63,800,000$ | 62,958,500$ | 0$ | 29,107,750$ | 314,792$ | 26,330,902$ | 21 | 0 | 0$ | 35,199,559$ | 116 | 348,000$ | 40,368,000$ | 43,633,731$ | 62,846,774$ | 22,846,774$ | 65,000,000$ | 2,153,226$ | 13,365,130$ | 8,046,061$ |
| 11 | Los Angeles | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 60 | 50 | 35 | 180 | 90553 | 82409 | 30828 | 67392 | 15757 | 83.85% | 91.57% | 85.63% | 93.60% | 87.54% | 23 | 15941 - 88.56% | 1,489,750$ | 26,815,494$ | 18000 | 100 | 47,575,000$ | 40,843,000$ | 1,766,400$ | 20,188,250$ | 204,215$ | 17,163,620$ | 24 | 0 | 0$ | 34,264,242$ | 116 | 241,625$ | 28,028,500$ | 30,016,510$ | 42,618,960$ | 2,618,960$ | 65,000,000$ | 22,381,040$ | 12,352,529$ | 19,682,149$ |
| 12 | Minnesota | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 60 | 50 | 30 | 175 | 102000 | 85000 | 33297 | 83465 | 17000 | 100.00% | 100.00% | 72.01% | 89.59% | 100.00% | 24 | 18868 - 93.41% | 1,482,486$ | 25,202,269$ | 20200 | 100 | 57,602,500$ | 56,513,500$ | 6,550,000$ | 25,801,068$ | 282,568$ | 24,035,520$ | 22 | 0 | 0$ | 35,579,674$ | 116 | 305,512$ | 35,439,392$ | 37,514,204$ | 63,363,408$ | 23,363,408$ | 65,000,000$ | 1,636,592$ | 6,358,125$ | 7,435,246$ |
| 13 | Montreal | 6415 | 5870 | 2778 | 5556 | 1145 | 85 | 60 | 45 | 25 | 200 | 114227 | 102484 | 44655 | 90179 | 15388 | 98.92% | 96.99% | 89.30% | 90.17% | 74.66% | 23 | 20385 - 93.66% | 1,589,448$ | 28,610,067$ | 21764 | 100 | 61,475,000$ | 57,861,500$ | 0$ | 26,382,125$ | 289,308$ | 24,191,795$ | 24 | 0 | 0$ | 36,557,308$ | 116 | 317,375$ | 36,815,500$ | 39,223,312$ | 57,751,523$ | 17,751,523$ | 65,000,000$ | 7,248,477$ | 9,221,302$ | 9,500,525$ |
| 14 | NYIslanders | 6000 | 5000 | 2720 | 5480 | 1000 | 93 | 72 | 42 | 26 | 193 | 97252 | 75589 | 45881 | 90664 | 15952 | 90.05% | 83.99% | 93.71% | 91.91% | 88.62% | 23 | 18074 - 89.48% | 1,507,338$ | 27,132,079$ | 20200 | 100 | 60,930,000$ | 60,930,000$ | 2,977,500$ | 26,789,850$ | 304,650$ | 25,379,850$ | 20 | 0 | 0$ | 34,668,768$ | 116 | 319,650$ | 37,079,400$ | 40,221,255$ | 63,696,750$ | 23,696,750$ | 65,000,000$ | 1,303,250$ | 11,562,712$ | 9,128,169$ |
| 15 | NYRangers | 7000 | 6000 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 72136 | 69344 | 28795 | 53191 | 14079 | 57.25% | 64.21% | 57.59% | 53.19% | 56.31% | 23 | 13197 - 58.08% | 1,492,306$ | 26,861,506$ | 22723 | 100 | 61,310,000$ | 61,310,000$ | 500,000$ | 27,552,200$ | 306,550$ | 25,294,700$ | 21 | 0 | 0$ | 34,323,035$ | 116 | 333,425$ | 38,677,300$ | 40,850,347$ | 61,354,500$ | 21,354,500$ | 65,000,000$ | 3,645,500$ | 9,586,098$ | 6,218,682$ |
| 16 | New Jersey | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 45 | 25 | 15 | 170 | 108000 | 90000 | 36000 | 72000 | 18000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 23 | 18000 - 100.00% | 1,177,833$ | 21,201,000$ | 18000 | 100 | 50,610,000$ | 50,610,000$ | 1,200,000$ | 21,765,825$ | 253,050$ | 21,345,825$ | 23 | 0 | 0$ | 27,090,167$ | 116 | 258,050$ | 29,933,800$ | 30,886,402$ | 51,899,625$ | 11,899,625$ | 65,000,000$ | 13,100,375$ | 20,951,634$ | 21,315,114$ |
| 17 | Philadelphie | 7033 | 6944 | 2778 | 5556 | 1389 | 80 | 54 | 40 | 36 | 165 | 119600 | 105971 | 46101 | 64881 | 20460 | 94.48% | 84.78% | 92.19% | 64.88% | 81.83% | 23 | 19834 - 83.69% | 1,573,863$ | 28,329,534$ | 23700 | 100 | 58,196,600$ | 58,196,600$ | 0$ | 28,513,447$ | 290,983$ | 26,595,947$ | 20 | 1 | 0$ | 36,198,849$ | 116 | 312,858$ | 36,291,528$ | 39,227,034$ | 60,349,975$ | 20,349,975$ | 65,000,000$ | 4,650,025$ | 13,224,487$ | 13,192,847$ |
| 18 | Pittsburgh | 7360 | 5750 | 2600 | 4800 | 1125 | 76 | 62 | 39 | 32 | 176 | 119923 | 98599 | 45163 | 84319 | 19511 | 90.52% | 95.26% | 96.50% | 97.59% | 96.35% | 23 | 20418 - 94.37% | 1,589,884$ | 28,617,904$ | 21635 | 100 | 59,360,000$ | 52,430,000$ | 2,631,000$ | 27,002,270$ | 262,150$ | 22,413,275$ | 28 | 0 | 0$ | 36,567,322$ | 116 | 317,930$ | 36,879,880$ | 39,387,925$ | 55,453,675$ | 15,453,675$ | 65,000,000$ | 9,546,325$ | 7,477,585$ | 7,897,673$ |
| 19 | San Jose | 8333 | 6944 | 2778 | 5556 | 1000 | 81 | 61 | 46 | 32 | 184 | 115499 | 97964 | 43156 | 82905 | 16251 | 77.00% | 78.38% | 86.31% | 82.90% | 90.28% | 23 | 19765 - 80.31% | 1,645,562$ | 29,620,109$ | 24611 | 100 | 64,669,000$ | 64,669,000$ | 0$ | 29,790,980$ | 323,345$ | 26,951,480$ | 22 | 0 | 0$ | 37,847,917$ | 116 | 356,345$ | 41,336,020$ | 43,174,624$ | 64,459,500$ | 24,459,500$ | 65,000,000$ | 540,500$ | 41,048,365$ | 38,687,360$ |
| 20 | Seattle | 7250 | 6000 | 2778 | 4500 | 1050 | 80 | 50 | 32 | 25 | 145 | 115665 | 99917 | 45692 | 79888 | 18898 | 88.63% | 92.52% | 91.38% | 98.63% | 99.99% | 23 | 20003 - 92.70% | 1,451,636$ | 26,129,448$ | 21578 | 100 | 62,095,500$ | 57,936,510$ | 4,491,000$ | 28,131,502$ | 289,683$ | 25,207,138$ | 25 | 0 | 0$ | 33,387,628$ | 116 | 325,478$ | 37,755,448$ | 39,558,865$ | 63,301,366$ | 23,301,366$ | 65,000,000$ | 1,698,634$ | 5,743,988$ | 2,120,436$ |
| 21 | St. Louis | 6400 | 6944 | 2778 | 5556 | 1389 | 88 | 62 | 39 | 30 | 120 | 113789 | 104254 | 45388 | 87922 | 21738 | 98.78% | 83.41% | 90.77% | 87.91% | 86.95% | 23 | 20727 - 89.86% | 1,609,805$ | 28,976,489$ | 23067 | 100 | 61,650,000$ | 61,350,000$ | 0$ | 27,763,500$ | 306,750$ | 25,831,500$ | 22 | 0 | 0$ | 37,025,514$ | 116 | 329,750$ | 38,251,000$ | 40,206,265$ | 61,414,500$ | 21,414,500$ | 65,000,000$ | 3,585,500$ | 18,186,424$ | 18,347,866$ |
| 22 | Tampa Bay | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 65 | 50 | 22 | 184 | 102000 | 82792 | 32716 | 87419 | 16063 | 100.00% | 97.40% | 70.75% | 93.84% | 94.49% | 24 | 18882 - 93.47% | 1,453,580$ | 24,710,862$ | 20200 | 100 | 61,865,000$ | 61,865,000$ | 0$ | 27,513,400$ | 309,325$ | 25,304,515$ | 22 | 0 | 0$ | 34,885,923$ | 116 | 331,825$ | 38,491,700$ | 40,044,035$ | 61,186,215$ | 21,186,215$ | 65,000,000$ | 3,813,785$ | 1,590,078$ | -558,258$ |
| 23 | Vancouver | 8333 | 6944 | 2778 | 5556 | 1289 | 115 | 75 | 55 | 40 | 200 | 73923 | 68060 | 29720 | 57337 | 14393 | 52.18% | 57.65% | 62.93% | 60.70% | 65.68% | 24 | 14320 - 57.51% | 1,479,797$ | 25,156,541$ | 24900 | 100 | 63,551,000$ | 63,551,000$ | 0$ | 28,426,920$ | 317,755$ | 26,641,920$ | 21 | 0 | 0$ | 35,515,117$ | 116 | 339,005$ | 39,324,580$ | 40,699,759$ | 63,501,500$ | 23,501,500$ | 65,000,000$ | 1,498,500$ | 7,444,585$ | 5,202,272$ |
| 24 | Washington | 7333 | 6944 | 2778 | 5556 | 1089 | 75 | 59 | 36 | 29 | 160 | 122482 | 104296 | 47033 | 92119 | 19392 | 92.79% | 83.44% | 94.06% | 92.11% | 98.93% | 23 | 21407 - 90.32% | 1,562,351$ | 28,122,310$ | 23700 | 100 | 64,639,000$ | 55,055,000$ | 1,162,000$ | 27,010,240$ | 275,275$ | 25,326,220$ | 21 | 1 | 0$ | 35,934,063$ | 116 | 331,945$ | 38,505,620$ | 40,162,406$ | 58,420,120$ | 18,420,120$ | 65,000,000$ | 6,579,880$ | 5,806,929$ | 4,551,244$ |
| 25 | Winnipeg | 6000 | 6000 | 2778 | 4000 | 1389 | 87 | 65 | 54 | 32 | 175 | 108000 | 89585 | 32190 | 72000 | 20510 | 100.00% | 82.95% | 64.37% | 100.00% | 82.03% | 23 | 17905 - 88.78% | 1,564,889$ | 28,168,003$ | 20167 | 100 | 63,675,000$ | 63,675,000$ | 0$ | 27,373,500$ | 318,375$ | 26,743,500$ | 23 | 0 | 0$ | 35,992,448$ | 116 | 325,875$ | 37,801,500$ | 39,460,839$ | 63,675,000$ | 23,675,000$ | 65,000,000$ | 1,325,000$ | 45,285,781$ | 44,781,767$ |
Bridgeport
Charlotte
Cleveland
Grand Rapids
Hartford
Hershey
Laval
Lehigh Valley
Providence
Rochester
Syracuse
Utica 
Wilkes-Barre/Scranton
Abbotsford
Bakersfield
Coachella Valley
Eagles
Iowa
Manitoba
Ontario
Rockford
San Diego
San Jose
Springfield
Texas