| 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 | 170607 | 128452 | 48569 | 124976 | 29729 | 78.74% | 71.15% | 67.24% | 86.51% | 82.32% | 15 | 19321 - 77.28% | 1,615,552$ | 42,004,341$ | 25000 | 100 | 63,991,700$ | 62,011,700$ | 1,928,000$ | 42,560,666$ | 310,058$ | 38,553,866$ | 21 | 0 | 0$ | 24,233,274$ | 76 | 343,808$ | 26,129,408$ | 27,790,027$ | 64,046,274$ | 24,046,274$ | 65,000,000$ | 953,726$ | 24,506,996$ | 22,904,305$ |
| 2 | Boston | 8333 | 6944 | 2778 | 5556 | 1389 | 87 | 56 | 43 | 32 | 175 | 139384 | 140129 | 54514 | 111502 | 31088 | 61.95% | 74.74% | 72.68% | 74.33% | 82.89% | 14 | 17652 - 70.61% | 1,586,007$ | 42,822,194$ | 25000 | 100 | 66,995,000$ | 64,520,000$ | 1,227,800$ | 42,134,750$ | 322,600$ | 38,378,909$ | 24 | 0 | 0$ | 22,204,101$ | 76 | 349,975$ | 26,598,100$ | 27,875,816$ | 64,124,309$ | 24,124,309$ | 65,000,000$ | 875,691$ | 3,317,385$ | -517,797$ |
| 3 | Buffalo | 6500 | 5000 | 2000 | 4000 | 1200 | 125 | 80 | 60 | 45 | 220 | 102698 | 98477 | 41644 | 76288 | 19988 | 60.77% | 75.75% | 80.08% | 73.35% | 64.06% | 15 | 13042 - 69.74% | 1,478,432$ | 38,439,227$ | 18700 | 100 | 65,235,000$ | 65,235,000$ | 1,152,000$ | 40,391,550$ | 326,175$ | 38,903,550$ | 23 | 0 | 0$ | 22,176,477$ | 76 | 338,175$ | 25,701,300$ | 27,057,400$ | 64,844,850$ | 24,844,850$ | 65,000,000$ | 155,150$ | 10,127,981$ | 7,068,158$ |
| 4 | Chicago | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 75 | 60 | 45 | 200 | 173296 | 104538 | 40770 | 75629 | 21473 | 79.99% | 57.90% | 56.45% | 52.35% | 59.46% | 15 | 15989 - 63.95% | 1,516,909$ | 39,439,629$ | 25000 | 100 | 64,823,000$ | 64,823,000$ | 0$ | 41,767,510$ | 324,115$ | 38,016,760$ | 20 | 0 | 0$ | 22,753,632$ | 76 | 349,615$ | 26,570,740$ | 28,622,427$ | 62,649,500$ | 22,649,500$ | 65,000,000$ | 2,350,500$ | 24,693,127$ | 20,663,776$ |
| 5 | Colorado | 6500 | 5000 | 2000 | 4000 | 1000 | 87 | 56 | 43 | 32 | 175 | 165857 | 130000 | 52000 | 104000 | 26000 | 98.14% | 100.00% | 100.00% | 100.00% | 100.00% | 15 | 18379 - 99.35% | 1,518,168$ | 39,472,377$ | 18500 | 100 | 59,850,000$ | 59,850,000$ | 0$ | 40,304,375$ | 299,250$ | 36,966,875$ | 21 | 0 | 0$ | 22,772,525$ | 76 | 321,750$ | 24,453,000$ | 26,530,602$ | 59,709,875$ | 19,709,875$ | 65,000,000$ | 5,290,125$ | 31,651,226$ | 29,697,229$ |
| 6 | Columbus | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 50 | 35 | 25 | 180 | 172622 | 156745 | 67693 | 131730 | 28810 | 79.67% | 86.82% | 93.72% | 91.19% | 79.78% | 15 | 21446 - 85.78% | 1,560,594$ | 40,575,450$ | 25000 | 100 | 63,970,000$ | 63,970,000$ | 0$ | 43,945,900$ | 319,850$ | 39,853,900$ | 21 | 0 | 0$ | 23,408,913$ | 76 | 352,850$ | 26,816,600$ | 28,480,982$ | 64,162,500$ | 24,162,500$ | 65,000,000$ | 837,500$ | 7,890,600$ | 4,668,263$ |
| 7 | Dallas | 8333 | 6944 | 2778 | 5556 | 1389 | 70 | 55 | 40 | 30 | 130 | 153976 | 133543 | 60584 | 111383 | 28019 | 71.07% | 73.97% | 83.88% | 77.11% | 77.58% | 15 | 18750 - 75.00% | 1,508,195$ | 39,213,060$ | 25000 | 100 | 60,134,500$ | 60,134,500$ | 922,500$ | 39,182,544$ | 300,672$ | 36,950,544$ | 20 | 0 | 0$ | 22,622,919$ | 76 | 318,672$ | 24,219,072$ | 25,356,421$ | 60,724,116$ | 20,724,116$ | 65,000,000$ | 4,275,884$ | 18,897,069$ | 18,107,278$ |
| 8 | Detroit | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 60 | 45 | 220 | 102955 | 99246 | 42950 | 75505 | 19713 | 66.00% | 76.34% | 82.60% | 72.60% | 75.82% | 15 | 13091 - 72.73% | 1,484,501$ | 38,597,027$ | 18000 | 100 | 59,610,000$ | 52,457,250$ | 3,787,500$ | 43,577,325$ | 262,286$ | 37,384,436$ | 26 | 0 | 0$ | 22,267,516$ | 76 | 313,050$ | 23,791,800$ | 25,396,755$ | 61,105,672$ | 21,105,672$ | 65,000,000$ | 3,894,328$ | -1,349,663$ | -2,644,070$ |
| 9 | Edmonton | 6000 | 5100 | 2778 | 5556 | 1000 | 90 | 65 | 40 | 25 | 185 | 146280 | 129543 | 70533 | 137425 | 23879 | 90.30% | 94.08% | 94.04% | 91.61% | 88.44% | 14 | 18802 - 92.01% | 1,503,609$ | 40,597,435$ | 20434 | 100 | 56,560,000$ | 55,966,000$ | 1,350,000$ | 37,793,200$ | 279,830$ | 34,643,830$ | 23 | 0 | 0$ | 21,050,522$ | 76 | 305,300$ | 23,202,800$ | 24,938,324$ | 57,260,910$ | 17,260,910$ | 65,000,000$ | 7,739,090$ | 8,279,361$ | 6,602,088$ |
| 10 | Floride | 6000 | 5100 | 2778 | 5556 | 1000 | 90 | 75 | 55 | 45 | 200 | 159447 | 107540 | 47750 | 79156 | 22887 | 98.42% | 78.10% | 63.66% | 52.77% | 84.77% | 14 | 15436 - 75.54% | 1,522,236$ | 41,100,368$ | 20434 | 100 | 67,300,000$ | 66,458,500$ | 0$ | 43,132,750$ | 332,292$ | 39,027,582$ | 22 | 0 | 0$ | 21,311,302$ | 76 | 365,500$ | 27,778,000$ | 29,866,891$ | 64,281,774$ | 24,281,774$ | 65,000,000$ | 718,226$ | 12,831,708$ | 6,192,693$ |
| 11 | Los Angeles | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 60 | 50 | 35 | 180 | 132654 | 127409 | 48010 | 100215 | 24579 | 81.89% | 94.38% | 88.91% | 92.79% | 91.03% | 14 | 16032 - 89.07% | 1,489,299$ | 40,211,082$ | 18000 | 100 | 51,750,000$ | 43,533,000$ | 1,766,400$ | 30,347,750$ | 217,665$ | 25,670,795$ | 25 | 0 | 0$ | 20,850,191$ | 76 | 262,500$ | 19,950,000$ | 21,218,912$ | 43,979,735$ | 3,979,735$ | 65,000,000$ | 21,020,265$ | 16,100,950$ | 17,619,734$ |
| 12 | Minnesota | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 60 | 50 | 30 | 175 | 156000 | 130000 | 50254 | 128052 | 26000 | 100.00% | 100.00% | 71.06% | 89.87% | 100.00% | 15 | 18858 - 93.36% | 1,487,609$ | 38,677,844$ | 20200 | 100 | 63,227,500$ | 59,332,500$ | 6,550,000$ | 38,391,808$ | 296,662$ | 35,524,760$ | 23 | 1 | 0$ | 22,314,141$ | 76 | 333,638$ | 25,356,488$ | 26,629,021$ | 64,621,072$ | 24,621,072$ | 65,000,000$ | 378,928$ | 7,660,529$ | 5,234,434$ |
| 13 | Montreal | 6415 | 5870 | 2778 | 5556 | 1145 | 85 | 60 | 45 | 25 | 200 | 171561 | 153926 | 67678 | 137363 | 22826 | 99.05% | 97.12% | 90.23% | 91.57% | 73.83% | 14 | 20495 - 94.17% | 1,599,593$ | 43,188,999$ | 21764 | 100 | 61,475,000$ | 57,861,500$ | 0$ | 39,057,125$ | 289,308$ | 35,594,115$ | 24 | 0 | 0$ | 22,394,296$ | 76 | 317,375$ | 24,120,500$ | 25,660,632$ | 57,581,523$ | 17,581,523$ | 65,000,000$ | 7,418,477$ | 11,296,379$ | 9,959,150$ |
| 14 | NYIslanders | 6000 | 5000 | 2720 | 5480 | 1000 | 93 | 72 | 42 | 26 | 193 | 145450 | 112415 | 68311 | 136033 | 23762 | 89.78% | 83.27% | 93.02% | 91.94% | 88.01% | 14 | 17999 - 89.10% | 1,503,173$ | 40,585,666$ | 20200 | 100 | 61,630,000$ | 61,630,000$ | 2,977,500$ | 39,804,600$ | 308,150$ | 37,794,600$ | 21 | 0 | 0$ | 21,044,419$ | 76 | 323,150$ | 24,559,400$ | 26,543,566$ | 64,191,500$ | 24,191,500$ | 65,000,000$ | 808,500$ | 12,183,878$ | 8,499,347$ |
| 15 | NYRangers | 7000 | 6000 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 104100 | 97852 | 41446 | 75649 | 20214 | 57.20% | 62.73% | 57.38% | 52.37% | 55.97% | 15 | 13049 - 57.42% | 1,484,842$ | 38,605,894$ | 22723 | 100 | 57,810,000$ | 57,810,000$ | 500,000$ | 40,784,200$ | 289,050$ | 37,451,700$ | 20 | 0 | 0$ | 22,272,631$ | 76 | 315,925$ | 24,010,300$ | 25,400,267$ | 59,919,500$ | 19,919,500$ | 65,000,000$ | 5,080,500$ | 8,469,211$ | 7,298,536$ |
| 16 | New Jersey | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 45 | 25 | 15 | 170 | 156000 | 130000 | 52000 | 104000 | 26000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 15 | 18000 - 100.00% | 1,182,731$ | 30,751,000$ | 18000 | 100 | 49,635,000$ | 49,635,000$ | 1,200,000$ | 31,706,200$ | 248,175$ | 31,086,200$ | 23 | 0 | 0$ | 17,740,962$ | 76 | 253,175$ | 19,241,300$ | 19,802,413$ | 51,147,500$ | 11,147,500$ | 65,000,000$ | 13,852,500$ | 21,850,199$ | 22,322,586$ |
| 17 | Philadelphie | 7033 | 6944 | 2778 | 5556 | 1389 | 80 | 54 | 40 | 36 | 165 | 173135 | 151758 | 67069 | 94146 | 29304 | 94.68% | 84.06% | 92.86% | 65.17% | 81.14% | 15 | 19824 - 83.64% | 1,575,502$ | 40,963,057$ | 23700 | 100 | 63,571,600$ | 63,571,600$ | 0$ | 41,967,142$ | 317,858$ | 38,734,017$ | 20 | 0 | 0$ | 23,632,533$ | 76 | 339,733$ | 25,819,708$ | 27,715,621$ | 62,891,225$ | 22,891,225$ | 65,000,000$ | 2,108,775$ | 12,509,535$ | 10,247,103$ |
| 18 | Pittsburgh | 7360 | 5750 | 2600 | 4800 | 1125 | 75 | 63 | 40 | 33 | 177 | 180577 | 148854 | 67999 | 121780 | 29471 | 90.87% | 95.88% | 96.86% | 93.97% | 97.02% | 14 | 20322 - 93.93% | 1,597,890$ | 43,143,023$ | 21635 | 100 | 55,860,000$ | 48,336,000$ | 2,631,000$ | 39,049,970$ | 241,680$ | 32,491,630$ | 28 | 0 | 0$ | 22,370,456$ | 76 | 300,430$ | 22,832,680$ | 24,436,925$ | 53,490,310$ | 13,490,310$ | 65,000,000$ | 11,509,690$ | 10,095,455$ | 10,093,443$ |
| 19 | San Jose | 8333 | 6944 | 2778 | 5556 | 1000 | 81 | 61 | 46 | 32 | 184 | 178921 | 150799 | 65720 | 126957 | 24384 | 79.52% | 80.43% | 87.62% | 84.63% | 90.31% | 14 | 20251 - 82.28% | 1,666,680$ | 45,000,356$ | 24611 | 100 | 64,169,000$ | 64,169,000$ | 0$ | 43,964,780$ | 320,845$ | 39,805,280$ | 21 | 0 | 0$ | 23,333,518$ | 76 | 353,845$ | 26,892,220$ | 28,086,511$ | 64,189,500$ | 24,189,500$ | 65,000,000$ | 810,500$ | 42,728,515$ | 39,772,433$ |
| 20 | Seattle | 7250 | 6000 | 2778 | 4500 | 1050 | 80 | 50 | 32 | 25 | 145 | 176165 | 152203 | 69289 | 120388 | 28348 | 89.99% | 93.95% | 92.38% | 99.08% | 99.99% | 14 | 20237 - 93.78% | 1,458,135$ | 39,369,643$ | 21578 | 100 | 61,594,000$ | 57,435,010$ | 4,491,000$ | 41,050,302$ | 287,175$ | 36,694,138$ | 24 | 0 | 0$ | 20,413,889$ | 76 | 322,970$ | 24,545,720$ | 25,717,504$ | 63,010,438$ | 23,010,438$ | 65,000,000$ | 1,989,562$ | 6,366,815$ | 2,659,086$ |
| 21 | St. Louis | 6400 | 6944 | 2778 | 5556 | 1389 | 88 | 62 | 39 | 30 | 120 | 171389 | 155101 | 68246 | 132679 | 32523 | 99.18% | 82.73% | 90.99% | 88.45% | 86.72% | 14 | 20738 - 89.91% | 1,617,170$ | 43,663,596$ | 23067 | 100 | 61,650,000$ | 61,350,000$ | 0$ | 40,953,500$ | 306,750$ | 38,101,500$ | 22 | 0 | 0$ | 22,640,383$ | 76 | 329,750$ | 25,061,000$ | 26,311,665$ | 61,414,500$ | 21,414,500$ | 65,000,000$ | 3,585,500$ | 20,364,799$ | 18,639,649$ |
| 22 | Tampa Bay | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 65 | 50 | 22 | 184 | 156000 | 124243 | 49897 | 132998 | 24382 | 100.00% | 95.57% | 70.56% | 93.35% | 93.78% | 15 | 18751 - 92.83% | 1,450,745$ | 37,719,360$ | 20200 | 100 | 62,465,000$ | 62,465,000$ | 0$ | 40,903,400$ | 312,325$ | 37,794,515$ | 23 | 0 | 0$ | 21,761,169$ | 76 | 334,825$ | 25,446,700$ | 26,519,723$ | 61,531,215$ | 21,531,215$ | 65,000,000$ | 3,468,785$ | 1,778,893$ | -1,172,795$ |
| 23 | Vancouver | 8333 | 6944 | 2778 | 5556 | 1289 | 115 | 75 | 55 | 40 | 200 | 111411 | 104718 | 45873 | 86336 | 21907 | 51.42% | 58.00% | 63.51% | 59.77% | 65.37% | 15 | 14240 - 57.19% | 1,477,735$ | 38,421,098$ | 24900 | 100 | 63,626,000$ | 63,626,000$ | 0$ | 41,963,120$ | 318,130$ | 39,328,120$ | 21 | 0 | 0$ | 22,166,018$ | 76 | 339,380$ | 25,792,880$ | 26,669,801$ | 63,506,000$ | 23,506,000$ | 65,000,000$ | 1,494,000$ | 7,843,297$ | 5,139,331$ |
| 24 | Washington | 7333 | 6944 | 2778 | 5556 | 1089 | 75 | 59 | 36 | 29 | 160 | 184653 | 157278 | 69369 | 135881 | 29083 | 93.26% | 83.89% | 92.48% | 90.58% | 98.91% | 14 | 21343 - 90.06% | 1,569,924$ | 42,387,957$ | 23700 | 100 | 67,939,000$ | 64,375,000$ | 1,162,000$ | 40,260,040$ | 321,875$ | 37,499,720$ | 22 | 0 | 0$ | 21,978,941$ | 76 | 348,445$ | 26,481,820$ | 27,541,566$ | 63,124,220$ | 23,124,220$ | 65,000,000$ | 1,875,780$ | 7,376,067$ | 3,623,123$ |
| 25 | Winnipeg | 6000 | 6000 | 2778 | 4000 | 1389 | 87 | 65 | 54 | 32 | 175 | 155985 | 126750 | 46427 | 104000 | 29342 | 99.99% | 81.25% | 64.28% | 100.00% | 81.25% | 15 | 17789 - 88.21% | 1,560,732$ | 40,579,025$ | 20167 | 100 | 63,675,000$ | 63,675,000$ | 0$ | 40,408,500$ | 318,375$ | 39,478,500$ | 23 | 0 | 0$ | 23,410,976$ | 76 | 325,875$ | 24,766,500$ | 25,827,879$ | 63,675,000$ | 23,675,000$ | 65,000,000$ | 1,325,000$ | 45,077,128$ | 44,583,243$ |
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