| 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 | 230830 | 169815 | 64291 | 170564 | 39536 | 79.14% | 69.87% | 66.12% | 87.71% | 81.32% | 6 | 19287 - 77.15% | 1,626,982$ | 56,944,372$ | 25000 | 100 | 66,780,500$ | 63,513,500$ | 1,928,000$ | 55,875,898$ | 317,568$ | 50,420,788$ | 22 | 0 | 0$ | 9,761,892$ | 38 | 357,752$ | 13,594,576$ | 14,366,413$ | 64,416,372$ | 24,416,372$ | 65,000,000$ | 583,628$ | 26,372,090$ | 22,541,352$ |
| 2 | Boston | 8333 | 6944 | 2778 | 5556 | 1389 | 87 | 56 | 43 | 32 | 175 | 193789 | 187102 | 73772 | 150990 | 40446 | 66.44% | 76.98% | 75.87% | 77.65% | 83.20% | 6 | 18460 - 73.84% | 1,619,673$ | 56,688,548$ | 25000 | 100 | 67,175,000$ | 64,700,000$ | 1,227,800$ | 55,524,100$ | 323,500$ | 50,728,009$ | 26 | 0 | 0$ | 9,718,037$ | 38 | 350,875$ | 13,333,250$ | 13,924,577$ | 64,248,809$ | 24,248,809$ | 65,000,000$ | 751,191$ | 6,266,843$ | 2,711,740$ |
| 3 | Buffalo | 6500 | 5000 | 2000 | 4000 | 1200 | 125 | 80 | 60 | 45 | 220 | 134702 | 128470 | 54897 | 99075 | 25913 | 60.95% | 75.57% | 80.73% | 72.85% | 63.51% | 7 | 13031 - 69.68% | 1,480,714$ | 50,344,269$ | 18700 | 100 | 67,560,000$ | 65,382,000$ | 1,152,000$ | 53,068,450$ | 326,910$ | 51,026,440$ | 21 | 0 | 0$ | 10,364,997$ | 38 | 349,800$ | 13,292,400$ | 13,960,353$ | 64,601,020$ | 24,601,020$ | 65,000,000$ | 398,980$ | 7,740,855$ | 4,793,428$ |
| 4 | Chicago | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 75 | 60 | 45 | 200 | 225772 | 135681 | 53463 | 98577 | 28131 | 79.69% | 57.47% | 56.60% | 52.18% | 59.57% | 7 | 15930 - 63.72% | 1,515,123$ | 51,514,184$ | 25000 | 100 | 64,823,000$ | 64,823,000$ | 0$ | 55,052,880$ | 324,115$ | 50,333,130$ | 20 | 0 | 0$ | 10,605,861$ | 38 | 349,615$ | 13,285,370$ | 14,238,971$ | 62,649,500$ | 22,649,500$ | 65,000,000$ | 2,350,500$ | 23,393,283$ | 20,541,297$ |
| 5 | Colorado | 6500 | 5000 | 2000 | 4000 | 1000 | 87 | 56 | 43 | 32 | 175 | 223233 | 175000 | 70000 | 140000 | 35000 | 98.12% | 100.00% | 100.00% | 100.00% | 100.00% | 6 | 18378 - 99.34% | 1,521,093$ | 53,238,267$ | 18500 | 100 | 60,650,000$ | 60,650,000$ | 0$ | 52,634,875$ | 303,250$ | 48,442,375$ | 22 | 0 | 0$ | 9,126,560$ | 38 | 325,750$ | 12,378,500$ | 13,330,583$ | 59,965,875$ | 19,965,875$ | 65,000,000$ | 5,034,125$ | 33,017,123$ | 29,586,427$ |
| 6 | Columbus | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 50 | 35 | 25 | 180 | 231722 | 209807 | 91756 | 177544 | 38909 | 79.45% | 86.33% | 94.37% | 91.30% | 80.03% | 6 | 21421 - 85.68% | 1,558,816$ | 54,558,544$ | 25000 | 100 | 67,790,000$ | 66,190,000$ | 0$ | 57,451,650$ | 330,950$ | 52,023,175$ | 21 | 1 | 0$ | 9,352,893$ | 38 | 371,950$ | 14,134,100$ | 14,868,746$ | 64,599,275$ | 24,599,275$ | 65,000,000$ | 400,725$ | 8,535,407$ | 3,810,420$ |
| 7 | Dallas | 8333 | 6944 | 2778 | 5556 | 1389 | 70 | 55 | 40 | 30 | 130 | 211138 | 179209 | 80574 | 149529 | 37668 | 74.52% | 75.91% | 85.31% | 79.16% | 79.76% | 7 | 19356 - 77.43% | 1,510,359$ | 51,352,210$ | 25000 | 100 | 60,634,500$ | 59,991,000$ | 922,500$ | 51,403,104$ | 299,955$ | 48,429,197$ | 21 | 0 | 0$ | 10,572,514$ | 38 | 321,172$ | 12,204,536$ | 12,721,316$ | 60,749,987$ | 20,749,987$ | 65,000,000$ | 4,250,013$ | 19,390,034$ | 18,019,103$ |
| 8 | Detroit | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 60 | 45 | 220 | 135123 | 129294 | 55434 | 98466 | 25932 | 66.24% | 76.06% | 81.52% | 72.40% | 76.27% | 7 | 13066 - 72.59% | 1,487,240$ | 50,566,159$ | 18000 | 100 | 56,110,000$ | 49,897,750$ | 3,787,500$ | 55,025,225$ | 249,489$ | 47,072,612$ | 24 | 0 | 0$ | 10,410,680$ | 38 | 295,550$ | 11,230,900$ | 11,998,876$ | 60,340,694$ | 20,340,694$ | 65,000,000$ | 4,659,306$ | -566,402$ | -1,416,302$ |
| 9 | Edmonton | 6000 | 5100 | 2778 | 5556 | 1000 | 90 | 65 | 40 | 25 | 185 | 189337 | 166578 | 91462 | 178305 | 31157 | 90.16% | 93.32% | 94.07% | 91.69% | 89.02% | 6 | 18767 - 91.84% | 1,498,784$ | 52,457,428$ | 20434 | 100 | 60,685,000$ | 60,091,000$ | 1,350,000$ | 49,668,600$ | 300,455$ | 45,551,370$ | 24 | 0 | 0$ | 8,992,702$ | 38 | 325,925$ | 12,385,150$ | 13,161,343$ | 58,318,660$ | 18,318,660$ | 65,000,000$ | 6,681,340$ | 8,686,323$ | 5,404,268$ |
| 10 | Floride | 6000 | 5100 | 2778 | 5556 | 1000 | 90 | 75 | 55 | 45 | 200 | 203276 | 139500 | 61053 | 102222 | 29736 | 96.80% | 78.15% | 62.79% | 52.57% | 84.96% | 6 | 15308 - 74.92% | 1,512,905$ | 52,951,674$ | 20434 | 100 | 70,600,000$ | 69,263,500$ | 0$ | 57,212,250$ | 346,318$ | 51,822,912$ | 22 | 0 | 0$ | 9,077,430$ | 38 | 382,000$ | 14,516,000$ | 15,486,893$ | 64,982,996$ | 24,982,996$ | 65,000,000$ | 17,004$ | 10,623,484$ | 4,978,598$ |
| 11 | Los Angeles | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 60 | 50 | 35 | 180 | 171628 | 167409 | 63283 | 129192 | 32579 | 81.73% | 95.66% | 90.40% | 92.28% | 93.08% | 6 | 16117 - 89.54% | 1,495,678$ | 52,348,725$ | 18000 | 100 | 51,750,000$ | 43,533,000$ | 1,766,400$ | 40,322,750$ | 217,665$ | 33,942,065$ | 25 | 0 | 0$ | 8,974,067$ | 38 | 262,500$ | 9,975,000$ | 10,564,776$ | 43,979,735$ | 3,979,735$ | 65,000,000$ | 21,020,265$ | 18,671,875$ | 17,891,613$ |
| 12 | Minnesota | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 60 | 50 | 30 | 175 | 204000 | 170000 | 65458 | 166972 | 34000 | 100.00% | 100.00% | 70.78% | 89.62% | 100.00% | 7 | 18836 - 93.25% | 1,489,341$ | 50,637,594$ | 20200 | 100 | 60,238,700$ | 59,743,700$ | 6,550,000$ | 50,516,144$ | 298,718$ | 46,890,038$ | 22 | 0 | 0$ | 10,425,387$ | 38 | 318,694$ | 12,110,372$ | 12,718,760$ | 64,791,322$ | 24,791,322$ | 65,000,000$ | 208,678$ | 7,911,018$ | 6,371,335$ |
| 13 | Montreal | 6415 | 5870 | 2778 | 5556 | 1145 | 85 | 60 | 45 | 25 | 200 | 221602 | 199641 | 87071 | 177571 | 29427 | 98.70% | 97.17% | 89.55% | 91.31% | 73.43% | 6 | 20437 - 93.91% | 1,598,060$ | 55,932,086$ | 21764 | 100 | 54,575,000$ | 50,961,500$ | 925,000$ | 50,793,375$ | 254,808$ | 46,263,819$ | 23 | 1 | 0$ | 9,588,358$ | 38 | 282,875$ | 10,749,250$ | 11,465,086$ | 56,871,523$ | 16,871,523$ | 65,000,000$ | 8,128,477$ | 12,625,764$ | 11,518,577$ |
| 14 | NYIslanders | 6000 | 5000 | 2720 | 5480 | 1000 | 93 | 72 | 42 | 26 | 193 | 187328 | 146746 | 87883 | 175000 | 30772 | 89.20% | 83.85% | 92.31% | 91.24% | 87.92% | 6 | 17935 - 88.79% | 1,500,825$ | 52,528,892$ | 20200 | 100 | 63,380,000$ | 63,380,000$ | 2,977,500$ | 52,119,300$ | 316,900$ | 49,081,800$ | 23 | 0 | 0$ | 9,004,953$ | 38 | 331,900$ | 12,612,200$ | 13,504,817$ | 64,101,500$ | 24,101,500$ | 65,000,000$ | 898,500$ | 11,783,488$ | 8,060,034$ |
| 15 | NYRangers | 7000 | 6000 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 140443 | 132088 | 55497 | 102052 | 27052 | 57.32% | 62.90% | 57.08% | 52.48% | 55.65% | 6 | 13061 - 57.48% | 1,489,358$ | 52,127,531$ | 22723 | 100 | 57,810,000$ | 57,810,000$ | 500,000$ | 52,789,350$ | 289,050$ | 48,435,600$ | 20 | 0 | 0$ | 8,936,148$ | 38 | 315,925$ | 12,005,150$ | 12,651,191$ | 59,919,500$ | 19,919,500$ | 65,000,000$ | 5,080,500$ | 10,418,823$ | 7,487,057$ |
| 16 | New Jersey | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 45 | 25 | 15 | 170 | 210000 | 175000 | 70000 | 140000 | 35000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 6 | 18000 - 100.00% | 1,185,564$ | 41,494,750$ | 18000 | 100 | 48,435,000$ | 46,950,000$ | 13,750,000$ | 41,223,850$ | 234,750$ | 40,354,450$ | 24 | 0 | 0$ | 7,113,386$ | 38 | 247,175$ | 9,392,650$ | 9,633,121$ | 63,024,950$ | 23,024,950$ | 65,000,000$ | 1,975,050$ | 24,229,569$ | 22,794,353$ |
| 17 | Philadelphie | 7033 | 6944 | 2778 | 5556 | 1389 | 80 | 54 | 40 | 36 | 165 | 233018 | 201981 | 90678 | 126803 | 39661 | 94.66% | 83.11% | 93.26% | 65.21% | 81.58% | 6 | 19775 - 83.44% | 1,575,073$ | 55,127,555$ | 23700 | 100 | 63,696,600$ | 63,696,600$ | 0$ | 54,982,246$ | 318,483$ | 50,917,871$ | 20 | 0 | 0$ | 9,450,438$ | 38 | 340,358$ | 12,933,604$ | 13,814,803$ | 63,020,225$ | 23,020,225$ | 65,000,000$ | 1,979,775$ | 13,821,523$ | 10,106,956$ |
| 18 | Pittsburgh | 7360 | 5750 | 2600 | 4800 | 1125 | 75 | 63 | 40 | 33 | 177 | 235832 | 192463 | 88202 | 154832 | 38327 | 91.55% | 95.63% | 96.93% | 92.16% | 97.34% | 6 | 20276 - 93.72% | 1,602,581$ | 56,090,323$ | 21635 | 100 | 55,860,000$ | 41,836,000$ | 2,631,000$ | 50,011,310$ | 209,180$ | 40,960,470$ | 27 | 1 | 0$ | 9,615,484$ | 38 | 300,430$ | 11,416,340$ | 12,161,975$ | 51,540,310$ | 11,540,310$ | 65,000,000$ | 13,459,690$ | 12,398,306$ | 10,666,768$ |
| 19 | San Jose | 8333 | 6944 | 2778 | 5556 | 1000 | 81 | 61 | 46 | 32 | 184 | 234158 | 196069 | 84782 | 164997 | 31789 | 80.29% | 80.67% | 87.20% | 84.85% | 90.83% | 6 | 20337 - 82.63% | 1,667,593$ | 58,365,755$ | 24611 | 100 | 65,619,000$ | 65,619,000$ | 0$ | 57,434,890$ | 328,095$ | 52,021,390$ | 23 | 0 | 0$ | 10,005,558$ | 38 | 361,095$ | 13,721,610$ | 14,252,151$ | 64,489,000$ | 24,489,000$ | 65,000,000$ | 511,000$ | 43,010,248$ | 39,533,138$ |
| 20 | Seattle | 7250 | 6000 | 2778 | 4500 | 1050 | 80 | 50 | 32 | 25 | 145 | 230683 | 199145 | 90377 | 156388 | 36748 | 90.91% | 94.83% | 92.95% | 99.29% | 99.99% | 6 | 20381 - 94.45% | 1,464,181$ | 51,246,341$ | 21578 | 100 | 53,969,000$ | 46,741,010$ | 5,797,500$ | 52,827,662$ | 233,705$ | 46,949,918$ | 25 | 0 | 0$ | 8,785,087$ | 38 | 284,845$ | 10,824,110$ | 11,393,261$ | 61,628,208$ | 21,628,208$ | 65,000,000$ | 3,371,792$ | 6,789,335$ | 4,819,529$ |
| 21 | St. Louis | 6400 | 6944 | 2778 | 5556 | 1389 | 88 | 62 | 39 | 30 | 120 | 222525 | 200750 | 88398 | 171971 | 42192 | 99.34% | 82.60% | 90.92% | 88.44% | 86.79% | 6 | 20738 - 89.90% | 1,620,930$ | 56,732,564$ | 23067 | 100 | 62,450,000$ | 62,150,000$ | 0$ | 53,592,000$ | 310,750$ | 49,866,000$ | 23 | 0 | 0$ | 9,725,582$ | 38 | 333,750$ | 12,682,500$ | 13,250,265$ | 61,674,500$ | 21,674,500$ | 65,000,000$ | 3,325,500$ | 21,272,453$ | 18,585,840$ |
| 22 | Tampa Bay | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 65 | 50 | 22 | 184 | 204000 | 161050 | 65119 | 174043 | 31867 | 100.00% | 94.74% | 70.41% | 93.41% | 93.73% | 7 | 18708 - 92.61% | 1,450,341$ | 49,311,592$ | 20200 | 100 | 53,050,000$ | 52,109,500$ | 2,520,000$ | 53,260,250$ | 260,548$ | 49,127,069$ | 21 | 0 | 0$ | 10,152,387$ | 38 | 287,750$ | 10,934,500$ | 11,473,654$ | 61,547,893$ | 21,547,893$ | 65,000,000$ | 3,452,107$ | 1,450,718$ | 903,764$ |
| 23 | Vancouver | 8333 | 6944 | 2778 | 5556 | 1289 | 115 | 75 | 55 | 40 | 200 | 145789 | 135854 | 59777 | 112741 | 28679 | 51.46% | 57.54% | 63.29% | 59.68% | 65.44% | 7 | 14201 - 57.03% | 1,477,973$ | 50,251,085$ | 24900 | 100 | 65,226,000$ | 65,226,000$ | 0$ | 55,023,560$ | 326,130$ | 51,581,060$ | 23 | 0 | 0$ | 10,345,812$ | 38 | 347,380$ | 13,200,440$ | 13,580,930$ | 63,974,000$ | 23,974,000$ | 65,000,000$ | 1,026,000$ | 7,182,750$ | 4,717,946$ |
| 24 | Washington | 7333 | 6944 | 2778 | 5556 | 1089 | 75 | 59 | 36 | 29 | 160 | 238272 | 205288 | 90767 | 174562 | 37721 | 92.84% | 84.47% | 93.35% | 89.77% | 98.97% | 6 | 21332 - 90.01% | 1,572,805$ | 55,048,172$ | 23700 | 100 | 70,014,000$ | 64,368,750$ | 1,162,000$ | 53,743,450$ | 321,844$ | 49,878,298$ | 22 | 0 | 0$ | 9,436,829$ | 38 | 358,820$ | 13,635,160$ | 14,127,718$ | 63,270,370$ | 23,270,370$ | 65,000,000$ | 1,729,630$ | 6,994,214$ | 3,071,848$ |
| 25 | Winnipeg | 6000 | 6000 | 2778 | 4000 | 1389 | 87 | 65 | 54 | 32 | 175 | 203985 | 163218 | 60290 | 136000 | 38002 | 99.99% | 80.01% | 63.83% | 100.00% | 80.47% | 7 | 17691 - 87.72% | 1,555,064$ | 52,872,176$ | 20167 | 100 | 58,275,000$ | 58,275,000$ | 324,000$ | 52,467,750$ | 291,375$ | 51,252,750$ | 23 | 0 | 0$ | 10,885,448$ | 38 | 298,875$ | 11,357,250$ | 11,850,567$ | 62,649,000$ | 22,649,000$ | 65,000,000$ | 2,351,000$ | 45,913,890$ | 45,720,912$ |
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