| 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 40,000,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Anaheim | 8333 | 6944 | 2778 | 5556 | 1389 | 70 | 48 | 44 | 35 | 165 | 268715 | 238472 | 103182 | 177988 | 43859 | 78.65% | 83.76% | 90.59% | 78.13% | 77.01% | 0 | 20298 - 81.19% | 1,577,592$ | 64,681,265$ | 25000 | 100 | 66,005,000$ | 66,005,000$ | 0$ | 70,774,547$ | 400,030$ | 64,741,333$ | 22 | 0 | 0$ | 0$ | 0 | 421,242$ | 0$ | 14,919$ | 64,741,333$ | 24,741,333$ | 65,000,000$ | 258,667$ | 18,116,230$ | 18,101,311$ |
| 2 | Boston | 8333 | 6944 | 2778 | 5556 | 1389 | 88 | 60 | 55 | 30 | 175 | 243558 | 234007 | 76323 | 200091 | 44401 | 71.29% | 82.19% | 67.01% | 87.84% | 77.97% | 0 | 19473 - 77.89% | 1,725,330$ | 70,738,549$ | 25000 | 100 | 65,425,000$ | 65,425,000$ | 1,932,000$ | 67,144,110$ | 392,015$ | 62,263,530$ | 24 | 0 | 0$ | 0$ | 0 | 417,727$ | 0$ | 17,008$ | 64,195,530$ | 24,195,530$ | 65,000,000$ | 804,470$ | 19,305,322$ | 19,288,314$ |
| 3 | Buffalo | 6000 | 5000 | 2000 | 4000 | 1000 | 87 | 62 | 42 | 32 | 165 | 244762 | 205000 | 82000 | 163264 | 40868 | 99.50% | 100.00% | 100.00% | 99.55% | 99.68% | 0 | 17949 - 99.71% | 1,627,111$ | 66,711,550$ | 18000 | 100 | 58,950,000$ | 58,950,000$ | 2,375,000$ | 60,781,505$ | 331,415$ | 54,900,670$ | 23 | 1 | 0$ | 0$ | 0 | 371,818$ | 0$ | 11,404$ | 57,275,670$ | 17,275,670$ | 65,000,000$ | 7,724,330$ | 30,942,146$ | 30,930,742$ |
| 4 | Chicago | 8033 | 6944 | 2778 | 5556 | 1389 | 80 | 75 | 60 | 45 | 200 | 267327 | 164115 | 67443 | 117301 | 32337 | 81.17% | 57.64% | 59.21% | 51.49% | 56.78% | 0 | 15818 - 64.04% | 1,629,460$ | 66,807,868$ | 24700 | 100 | 62,011,000$ | 62,011,000$ | 0$ | 68,479,952$ | 371,624$ | 63,175,719$ | 21 | 0 | 0$ | 0$ | 0 | 391,764$ | 0$ | 32,605$ | 63,175,719$ | 23,175,719$ | 65,000,000$ | 1,824,281$ | 30,872,464$ | 30,839,859$ |
| 5 | Colorado | 6500 | 5000 | 2000 | 4000 | 1000 | 87 | 56 | 43 | 32 | 175 | 257988 | 205000 | 82000 | 162840 | 40947 | 96.81% | 100.00% | 100.00% | 99.29% | 99.87% | 0 | 18263 - 98.72% | 1,640,664$ | 67,267,207$ | 18500 | 100 | 64,530,000$ | 64,530,000$ | 0$ | 67,109,084$ | 352,691$ | 56,344,892$ | 26 | 0 | 0$ | 0$ | 0 | 418,364$ | 0$ | 14,096$ | 56,344,892$ | 16,344,892$ | 65,000,000$ | 8,655,108$ | 27,797,395$ | 27,783,299$ |
| 6 | Columbus | 6500 | 6944 | 2778 | 5556 | 1000 | 85 | 58 | 45 | 25 | 180 | 258745 | 233739 | 103467 | 207012 | 35805 | 97.09% | 82.10% | 90.84% | 90.88% | 87.33% | 0 | 20458 - 89.81% | 1,706,479$ | 69,965,642$ | 22778 | 100 | 61,933,000$ | 61,933,000$ | 4,575,000$ | 68,806,200$ | 365,152$ | 59,844,000$ | 23 | 0 | 0$ | 0$ | 0 | 415,352$ | 0$ | 12,121$ | 64,419,000$ | 24,419,000$ | 65,000,000$ | 581,000$ | 22,744,182$ | 22,732,061$ |
| 7 | Dallas | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 60 | 45 | 35 | 125 | 225616 | 193659 | 101973 | 187477 | 45977 | 66.04% | 68.02% | 89.53% | 82.30% | 80.73% | 0 | 18407 - 73.63% | 1,611,803$ | 66,083,923$ | 25000 | 100 | 65,486,500$ | 65,486,500$ | 0$ | 65,293,080$ | 396,888$ | 63,043,014$ | 21 | 0 | 0$ | 0$ | 0 | 410,524$ | 0$ | 23,076$ | 63,043,014$ | 23,043,014$ | 65,000,000$ | 1,956,986$ | 3,772,997$ | 3,749,921$ |
| 8 | Detroit | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 60 | 45 | 220 | 157017 | 151007 | 66814 | 119016 | 29143 | 63.83% | 73.66% | 81.48% | 72.57% | 71.08% | 0 | 12756 - 70.87% | 1,563,488$ | 64,103,002$ | 18000 | 100 | 72,260,000$ | 72,260,000$ | 0$ | 72,838,490$ | 425,339$ | 64,776,867$ | 26 | 0 | 0$ | 0$ | 0 | 465,212$ | 0$ | 22,108$ | 64,776,867$ | 24,776,867$ | 65,000,000$ | 223,133$ | 6,292,406$ | 6,270,298$ |
| 9 | Edmonton | 6000 | 5000 | 2720 | 5480 | 1000 | 85 | 60 | 40 | 30 | 175 | 224854 | 194972 | 89857 | 162737 | 37146 | 91.40% | 95.11% | 80.57% | 72.43% | 90.60% | 0 | 17306 - 85.68% | 1,600,762$ | 65,631,244$ | 20200 | 100 | 65,140,000$ | 65,140,000$ | 0$ | 69,548,812$ | 394,788$ | 64,398,201$ | 22 | 0 | 0$ | 0$ | 0 | 422,061$ | 0$ | 18,801$ | 64,398,201$ | 24,398,201$ | 65,000,000$ | 601,799$ | 4,216,343$ | 4,197,542$ |
| 10 | Floride | 6000 | 5100 | 2778 | 5556 | 1000 | 85 | 60 | 40 | 30 | 175 | 245420 | 209100 | 104764 | 199767 | 40873 | 99.76% | 100.00% | 91.98% | 87.70% | 99.69% | 0 | 19510 - 95.48% | 1,670,808$ | 68,503,114$ | 20434 | 100 | 62,800,000$ | 62,800,000$ | 0$ | 68,942,717$ | 367,706$ | 64,187,111$ | 23 | 1 | 0$ | 0$ | 0 | 398,788$ | 0$ | 18,599$ | 64,187,111$ | 24,187,111$ | 65,000,000$ | 812,889$ | 5,370,731$ | 5,352,132$ |
| 11 | LosAngeles | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 78 | 58 | 40 | 200 | 195868 | 155224 | 68911 | 134316 | 32056 | 79.62% | 75.72% | 84.04% | 81.90% | 78.19% | 0 | 14302 - 79.45% | 1,563,200$ | 64,091,184$ | 18000 | 100 | 53,660,000$ | 53,660,000$ | 4,280,000$ | 57,160,287$ | 325,212$ | 52,755,008$ | 23 | 0 | 0$ | 0$ | 0 | 351,273$ | 0$ | 11,609$ | 57,035,008$ | 17,035,008$ | 65,000,000$ | 7,964,992$ | 20,412,152$ | 20,400,543$ |
| 12 | Minnesota | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 60 | 50 | 30 | 175 | 245704 | 205000 | 79708 | 199965 | 40914 | 99.88% | 100.00% | 71.47% | 89.00% | 99.79% | 0 | 18812 - 93.13% | 1,616,728$ | 66,285,838$ | 20200 | 100 | 71,200,000$ | 71,200,000$ | 0$ | 72,902,721$ | 388,615$ | 63,795,124$ | 26 | 0 | 0$ | 0$ | 0 | 452,727$ | 0$ | 19,044$ | 63,795,124$ | 23,795,124$ | 65,000,000$ | 1,204,876$ | 3,891,851$ | 3,872,807$ |
| 13 | Montreal | 6415 | 5870 | 2778 | 5556 | 1145 | 90 | 65 | 55 | 35 | 220 | 214505 | 184150 | 70139 | 146399 | 28725 | 81.56% | 76.52% | 61.58% | 64.27% | 61.19% | 0 | 15705 - 72.16% | 1,566,292$ | 64,217,975$ | 21764 | 100 | 60,150,000$ | 60,150,000$ | 525,000$ | 68,545,737$ | 337,845$ | 61,647,075$ | 23 | 0 | 0$ | 0$ | 0 | 380,303$ | 0$ | 17,020$ | 62,172,075$ | 22,172,075$ | 65,000,000$ | 2,827,925$ | 11,380,324$ | 11,363,304$ |
| 14 | NYIslanders | 6000 | 5000 | 2720 | 5480 | 1000 | 88 | 68 | 35 | 23 | 185 | 234332 | 179692 | 105933 | 210888 | 35119 | 95.26% | 87.65% | 94.99% | 93.86% | 85.66% | 0 | 18682 - 92.49% | 1,575,124$ | 64,580,102$ | 20200 | 100 | 62,320,000$ | 62,320,000$ | 2,677,500$ | 65,118,141$ | 369,597$ | 60,251,717$ | 23 | 0 | 0$ | 0$ | 0 | 398,909$ | 0$ | 14,556$ | 62,929,217$ | 22,929,217$ | 65,000,000$ | 2,070,783$ | 12,733,105$ | 12,718,549$ |
| 15 | NYRangers | 7000 | 6000 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 155863 | 150016 | 67374 | 116923 | 29778 | 54.31% | 60.98% | 59.15% | 51.33% | 52.29% | 0 | 12682 - 55.81% | 1,558,733$ | 63,908,040$ | 22723 | 100 | 65,400,000$ | 65,400,000$ | 2,100,000$ | 66,443,357$ | 396,364$ | 62,193,332$ | 22 | 0 | 0$ | 0$ | 0 | 422,121$ | 0$ | 18,640$ | 64,293,332$ | 24,293,332$ | 65,000,000$ | 706,668$ | 18,093,295$ | 18,074,655$ |
| 16 | Philadelphie | 6500 | 6944 | 2778 | 5556 | 1100 | 85 | 56 | 40 | 30 | 180 | 256596 | 228705 | 105563 | 198733 | 36152 | 96.28% | 80.33% | 92.68% | 87.24% | 80.16% | 0 | 20140 - 88.03% | 1,701,069$ | 69,743,846$ | 22878 | 100 | 64,285,000$ | 64,285,000$ | 0$ | 67,256,304$ | 389,606$ | 64,081,374$ | 21 | 0 | 0$ | 0$ | 0 | 408,848$ | 0$ | 26,558$ | 64,081,374$ | 24,081,374$ | 65,000,000$ | 918,626$ | 11,151,623$ | 11,125,065$ |
| 17 | Pittsburgh | 6760 | 5400 | 2600 | 4800 | 1075 | 84 | 65 | 41 | 33 | 176 | 262349 | 196940 | 102819 | 188976 | 41037 | 94.66% | 88.95% | 96.45% | 96.02% | 93.11% | 0 | 19320 - 93.63% | 1,709,408$ | 70,085,748$ | 20635 | 100 | 49,039,000$ | 49,039,000$ | 13,168,500$ | 60,171,245$ | 243,452$ | 50,941,833$ | 28 | 0 | 0$ | 0$ | 0 | 315,388$ | 0$ | 13,734$ | 64,110,333$ | 24,110,333$ | 65,000,000$ | 889,667$ | 27,400,774$ | 27,387,040$ |
| 18 | San Jose | 6666 | 6000 | 2778 | 5556 | 1000 | 85 | 56 | 43 | 32 | 170 | 258820 | 234218 | 104106 | 192122 | 40784 | 94.70% | 95.21% | 91.40% | 84.34% | 99.47% | 0 | 20245 - 92.02% | 1,734,376$ | 71,109,426$ | 22000 | 100 | 60,000,000$ | 60,000,000$ | 550,000$ | 65,261,232$ | 363,636$ | 62,245,300$ | 21 | 0 | 0$ | 0$ | 0 | 375,758$ | 0$ | 20,424$ | 62,795,300$ | 22,795,300$ | 65,000,000$ | 2,204,700$ | 35,854,494$ | 35,834,070$ |
| 19 | Seattle | 7000 | 6000 | 2778 | 4500 | 1000 | 82 | 50 | 41 | 32 | 172 | 262396 | 234305 | 104267 | 184291 | 40950 | 91.43% | 95.25% | 91.54% | 99.89% | 99.88% | 0 | 20151 - 94.71% | 1,646,796$ | 67,518,623$ | 21278 | 100 | 68,840,000$ | 68,840,000$ | 1,875,000$ | 70,121,431$ | 413,912$ | 62,954,368$ | 22 | 0 | 0$ | 0$ | 0 | 435,394$ | 0$ | 14,120$ | 64,829,368$ | 24,829,368$ | 65,000,000$ | 170,632$ | 8,125,477$ | 8,111,357$ |
| 20 | St. Louis | 6400 | 5810 | 2778 | 5200 | 1389 | 88 | 62 | 39 | 30 | 120 | 239505 | 225378 | 104793 | 198120 | 47739 | 91.27% | 94.61% | 92.01% | 92.93% | 83.83% | 0 | 19891 - 92.19% | 1,686,657$ | 69,152,944$ | 21577 | 100 | 70,170,000$ | 70,170,000$ | 1,300,000$ | 74,159,345$ | 377,273$ | 61,908,290$ | 27 | 0 | 0$ | 0$ | 0 | 451,333$ | 0$ | 12,620$ | 63,208,290$ | 23,208,290$ | 65,000,000$ | 1,791,710$ | 11,106,499$ | 11,093,879$ |
| 21 | Tampa Bay | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 65 | 50 | 22 | 184 | 245740 | 187327 | 79684 | 214010 | 34964 | 99.89% | 91.38% | 71.45% | 95.25% | 85.28% | 0 | 18579 - 91.97% | 1,546,285$ | 63,397,689$ | 20200 | 100 | 62,000,000$ | 62,000,000$ | 1,200,000$ | 64,668,475$ | 334,958$ | 54,929,677$ | 24 | 0 | 0$ | 0$ | 0 | 406,061$ | 0$ | 18,175$ | 56,129,677$ | 16,129,677$ | 65,000,000$ | 8,870,323$ | 18,203,566$ | 18,185,391$ |
| 22 | Vancouver | 8333 | 6944 | 2778 | 5556 | 1289 | 95 | 65 | 46 | 27 | 145 | 247904 | 181627 | 90676 | 208543 | 45414 | 72.56% | 63.80% | 79.61% | 91.55% | 85.93% | 0 | 18882 - 75.83% | 1,657,850$ | 67,971,831$ | 24900 | 100 | 66,800,000$ | 66,800,000$ | 0$ | 70,721,070$ | 385,048$ | 62,807,363$ | 23 | 0 | 0$ | 0$ | 0 | 430,606$ | 0$ | 13,102$ | 62,807,363$ | 22,807,363$ | 65,000,000$ | 2,192,637$ | 2,666,893$ | 2,653,791$ |
| 23 | Washington | 6000 | 6944 | 2778 | 5556 | 1000 | 75 | 59 | 36 | 29 | 160 | 245918 | 234598 | 106795 | 199842 | 40932 | 99.97% | 82.40% | 93.76% | 87.73% | 99.83% | 0 | 20197 - 90.66% | 1,596,105$ | 65,440,291$ | 22278 | 100 | 65,673,500$ | 65,673,500$ | 1,755,000$ | 62,007,914$ | 398,021$ | 59,691,932$ | 22 | 0 | 0$ | 0$ | 0 | 407,112$ | 0$ | 11,885$ | 61,446,932$ | 21,446,932$ | 65,000,000$ | 3,553,068$ | 16,327,383$ | 16,315,498$ |
| 24 | Winnipeg | 6000 | 6000 | 2778 | 4000 | 1000 | 87 | 65 | 54 | 32 | 175 | 244926 | 186698 | 74138 | 163194 | 40906 | 99.56% | 75.89% | 65.09% | 99.51% | 99.77% | 0 | 17314 - 87.54% | 1,640,683$ | 67,267,990$ | 19778 | 100 | 69,825,000$ | 69,825,000$ | 1,000,000$ | 70,427,424$ | 423,182$ | 63,224,320$ | 24 | 0 | 0$ | 0$ | 0 | 432,273$ | 0$ | 9,918$ | 64,224,320$ | 24,224,320$ | 65,000,000$ | 775,680$ | 44,375,019$ | 44,365,101$ |
Bridgeport
Charlotte
Cleveland
Coachella Valley
Grand Rapids
Hartford
Hershey
Laval
Lehigh Valley
Providence
Rochester
Wilkes-Barre/Scranton
Abbotsford
Bakersfield
Eagles
Iowa
Manitoba
Ontario
Rockford
San Diego
San Jose
Springfield
Syracuse
Texas