| 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 | 270688 | 196829 | 74807 | 199582 | 46229 | 79.23% | 69.13% | 65.68% | 87.61% | 81.18% | 0 | 19223 - 76.89% | 1,629,475$ | 66,808,462$ | 25000 | 100 | 66,780,500$ | 63,513,500$ | 1,928,000$ | 69,470,474$ | 317,568$ | 62,488,372$ | 22 | 0 | 0$ | 0$ | 0 | 357,752$ | 0$ | 0$ | 64,416,372$ | 24,416,372$ | 65,000,000$ | 583,628$ | 22,657,601$ | 22,657,601$ |
| 2 | Boston | 8333 | 6944 | 2778 | 5556 | 1389 | 87 | 56 | 43 | 32 | 175 | 233115 | 220883 | 88953 | 180134 | 47142 | 68.23% | 77.58% | 78.10% | 79.08% | 82.78% | 0 | 18786 - 75.14% | 1,628,693$ | 66,776,409$ | 25000 | 100 | 67,175,000$ | 62,522,000$ | 1,227,800$ | 68,830,350$ | 312,610$ | 62,787,099$ | 26 | 0 | 0$ | 0$ | 0 | 350,875$ | 0$ | 0$ | 64,014,899$ | 24,014,899$ | 65,000,000$ | 985,101$ | 3,087,615$ | 3,087,615$ |
| 3 | Buffalo | 6500 | 5000 | 2000 | 4000 | 1200 | 125 | 80 | 60 | 45 | 220 | 161876 | 154451 | 65760 | 119750 | 31321 | 60.74% | 75.34% | 80.20% | 73.02% | 63.66% | 0 | 13004 - 69.54% | 1,479,346$ | 60,653,200$ | 18700 | 100 | 68,860,000$ | 66,682,000$ | 1,152,000$ | 66,377,600$ | 333,410$ | 63,465,770$ | 22 | 0 | 0$ | 0$ | 0 | 356,300$ | 0$ | 0$ | 64,617,770$ | 24,617,770$ | 65,000,000$ | 382,230$ | 4,698,609$ | 4,698,609$ |
| 4 | Chicago | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 75 | 60 | 45 | 200 | 271901 | 163159 | 64546 | 118880 | 34085 | 79.58% | 57.31% | 56.67% | 52.19% | 59.85% | 0 | 15916 - 63.67% | 1,516,217$ | 62,164,915$ | 25000 | 100 | 64,823,000$ | 64,823,000$ | 0$ | 68,338,250$ | 324,115$ | 62,649,500$ | 20 | 0 | 0$ | 0$ | 0 | 349,615$ | 0$ | 0$ | 62,649,500$ | 22,649,500$ | 65,000,000$ | 2,350,500$ | 20,581,699$ | 20,581,699$ |
| 5 | Colorado | 6500 | 5000 | 2000 | 4000 | 1000 | 87 | 56 | 43 | 32 | 175 | 260844 | 205000 | 82000 | 164000 | 41000 | 97.88% | 100.00% | 100.00% | 100.00% | 100.00% | 0 | 18362 - 99.25% | 1,520,633$ | 62,345,963$ | 18500 | 100 | 60,650,000$ | 60,650,000$ | 0$ | 65,013,375$ | 303,250$ | 59,965,875$ | 22 | 0 | 0$ | 0$ | 0 | 325,750$ | 0$ | 0$ | 59,965,875$ | 19,965,875$ | 65,000,000$ | 5,034,125$ | 29,557,025$ | 29,557,025$ |
| 6 | Columbus | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 50 | 35 | 25 | 180 | 272661 | 244354 | 107484 | 207746 | 44910 | 79.81% | 85.83% | 94.37% | 91.20% | 78.86% | 0 | 21394 - 85.58% | 1,555,946$ | 63,793,769$ | 25000 | 100 | 66,690,000$ | 66,690,000$ | 0$ | 71,387,750$ | 333,450$ | 64,665,275$ | 21 | 0 | 0$ | 0$ | 0 | 366,450$ | 0$ | 0$ | 64,665,275$ | 24,665,275$ | 65,000,000$ | 334,725$ | 3,885,754$ | 3,885,754$ |
| 7 | Dallas | 8333 | 6944 | 2778 | 5556 | 1389 | 70 | 55 | 40 | 30 | 130 | 259285 | 218881 | 98344 | 182908 | 45940 | 75.89% | 76.88% | 86.34% | 80.29% | 80.67% | 0 | 19643 - 78.57% | 1,506,755$ | 61,776,935$ | 25000 | 100 | 60,085,500$ | 60,085,500$ | 922,500$ | 63,540,168$ | 300,428$ | 59,882,261$ | 20 | 0 | 0$ | 0$ | 0 | 318,428$ | 0$ | 0$ | 60,804,761$ | 20,804,761$ | 65,000,000$ | 4,195,239$ | 17,952,317$ | 17,952,317$ |
| 8 | Detroit | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 60 | 45 | 220 | 162642 | 155682 | 66422 | 118463 | 31197 | 66.11% | 75.94% | 81.00% | 72.23% | 76.09% | 0 | 13034 - 72.41% | 1,485,405$ | 60,901,608$ | 18000 | 100 | 57,910,000$ | 51,697,750$ | 3,787,500$ | 66,436,125$ | 258,489$ | 56,733,194$ | 25 | 0 | 0$ | 0$ | 0 | 304,550$ | 0$ | 0$ | 60,520,694$ | 20,520,694$ | 65,000,000$ | 4,479,306$ | -1,639,717$ | -1,639,717$ |
| 9 | Edmonton | 6000 | 5100 | 2778 | 5556 | 1000 | 85 | 60 | 40 | 30 | 175 | 223227 | 195791 | 107362 | 207348 | 36751 | 90.74% | 93.64% | 94.26% | 91.02% | 89.64% | 0 | 18792 - 91.97% | 1,499,547$ | 61,481,440$ | 20434 | 100 | 60,685,000$ | 60,091,000$ | 1,350,000$ | 62,053,750$ | 300,455$ | 56,968,660$ | 24 | 0 | 0$ | 0$ | 0 | 325,925$ | 0$ | 0$ | 58,318,660$ | 18,318,660$ | 65,000,000$ | 6,681,340$ | 5,443,433$ | 5,443,433$ |
| 10 | Floride | 6000 | 5100 | 2778 | 5556 | 1000 | 90 | 75 | 55 | 45 | 200 | 237257 | 164222 | 71753 | 119633 | 34763 | 96.45% | 78.54% | 63.00% | 52.52% | 84.79% | 0 | 15308 - 74.91% | 1,513,755$ | 62,063,967$ | 20434 | 100 | 70,600,000$ | 69,263,500$ | 0$ | 71,712,750$ | 346,318$ | 64,984,814$ | 22 | 0 | 0$ | 0$ | 0 | 382,000$ | 0$ | 0$ | 64,984,814$ | 24,984,814$ | 65,000,000$ | 15,186$ | 4,995,114$ | 4,995,114$ |
| 11 | Los Angeles | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 62 | 52 | 35 | 180 | 201299 | 197409 | 74669 | 151331 | 38417 | 81.83% | 96.30% | 91.06% | 92.28% | 93.70% | 0 | 16174 - 89.85% | 1,496,063$ | 61,338,600$ | 18000 | 100 | 53,950,000$ | 45,733,000$ | 1,766,400$ | 50,265,750$ | 228,665$ | 42,161,430$ | 26 | 0 | 0$ | 0$ | 0 | 273,500$ | 0$ | 0$ | 43,927,830$ | 3,927,830$ | 65,000,000$ | 21,072,170$ | 17,964,745$ | 17,964,745$ |
| 12 | Minnesota | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 60 | 50 | 30 | 175 | 246000 | 205000 | 79167 | 199976 | 41000 | 100.00% | 100.00% | 70.99% | 89.00% | 100.00% | 0 | 18808 - 93.11% | 1,489,959$ | 61,088,307$ | 20200 | 100 | 60,488,700$ | 59,993,700$ | 6,550,000$ | 62,606,516$ | 299,968$ | 58,221,322$ | 22 | 0 | 0$ | 0$ | 0 | 319,944$ | 0$ | 0$ | 64,771,322$ | 24,771,322$ | 65,000,000$ | 228,678$ | 6,420,468$ | 6,420,468$ |
| 13 | Montreal | 6415 | 5870 | 2778 | 5556 | 1145 | 85 | 60 | 45 | 25 | 200 | 260062 | 234375 | 101648 | 208576 | 34439 | 98.88% | 97.38% | 89.24% | 91.56% | 73.36% | 0 | 20466 - 94.04% | 1,601,594$ | 65,665,373$ | 21764 | 100 | 61,975,000$ | 58,361,500$ | 925,000$ | 62,853,625$ | 291,808$ | 56,702,523$ | 24 | 0 | 0$ | 0$ | 0 | 319,875$ | 0$ | 0$ | 57,627,523$ | 17,627,523$ | 65,000,000$ | 7,372,477$ | 10,340,626$ | 10,340,626$ |
| 14 | NYIslanders | 6000 | 5000 | 2720 | 5480 | 1000 | 93 | 72 | 42 | 26 | 193 | 218920 | 171420 | 103498 | 204737 | 36089 | 88.99% | 83.62% | 92.81% | 91.12% | 88.02% | 0 | 17919 - 88.71% | 1,499,783$ | 61,491,089$ | 20200 | 100 | 61,930,000$ | 61,930,000$ | 2,977,500$ | 64,361,000$ | 309,650$ | 60,753,500$ | 21 | 0 | 0$ | 0$ | 0 | 324,650$ | 0$ | 0$ | 63,731,000$ | 23,731,000$ | 65,000,000$ | 1,269,000$ | 8,342,640$ | 8,342,640$ |
| 15 | NYRangers | 7000 | 6000 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 164367 | 154673 | 64980 | 119606 | 31725 | 57.27% | 62.88% | 57.05% | 52.51% | 55.71% | 0 | 13057 - 57.46% | 1,490,436$ | 61,107,868$ | 22723 | 100 | 57,810,000$ | 57,810,000$ | 500,000$ | 64,794,500$ | 289,050$ | 59,419,500$ | 20 | 0 | 0$ | 0$ | 0 | 315,925$ | 0$ | 0$ | 59,919,500$ | 19,919,500$ | 65,000,000$ | 5,080,500$ | 7,508,479$ | 7,508,479$ |
| 16 | New Jersey | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 45 | 25 | 15 | 170 | 246000 | 205000 | 82000 | 164000 | 41000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 0 | 18000 - 100.00% | 1,186,762$ | 48,657,250$ | 18000 | 100 | 46,235,000$ | 44,750,000$ | 13,750,000$ | 50,308,500$ | 223,750$ | 48,966,950$ | 22 | 0 | 0$ | 0$ | 0 | 236,175$ | 0$ | 0$ | 62,716,950$ | 22,716,950$ | 65,000,000$ | 2,283,050$ | 23,117,493$ | 23,117,493$ |
| 17 | Philadelphie | 7033 | 6944 | 2778 | 5556 | 1389 | 80 | 54 | 40 | 36 | 165 | 273782 | 237112 | 105105 | 148197 | 46345 | 94.95% | 83.28% | 92.28% | 65.06% | 81.38% | 0 | 19769 - 83.41% | 1,576,535$ | 64,637,952$ | 23700 | 100 | 63,696,600$ | 63,696,600$ | 0$ | 67,962,100$ | 318,483$ | 63,066,475$ | 20 | 0 | 0$ | 0$ | 0 | 340,358$ | 0$ | 0$ | 63,066,475$ | 23,066,475$ | 65,000,000$ | 1,933,525$ | 10,114,961$ | 10,114,961$ |
| 18 | Pittsburgh | 7360 | 5750 | 2600 | 4800 | 1125 | 75 | 63 | 40 | 33 | 177 | 276475 | 226408 | 103635 | 179459 | 45015 | 91.62% | 96.04% | 97.22% | 91.19% | 97.59% | 0 | 20268 - 93.68% | 1,605,878$ | 65,841,006$ | 21635 | 100 | 53,660,000$ | 47,714,000$ | 2,631,000$ | 61,208,650$ | 238,570$ | 49,924,370$ | 26 | 1 | 0$ | 0$ | 0 | 289,430$ | 0$ | 0$ | 52,555,370$ | 12,555,370$ | 65,000,000$ | 12,444,630$ | 10,968,796$ | 10,968,796$ |
| 19 | San Jose | 8333 | 6944 | 2778 | 5556 | 1000 | 81 | 61 | 46 | 32 | 184 | 274792 | 230726 | 99119 | 192538 | 37140 | 80.43% | 81.04% | 87.02% | 84.52% | 90.59% | 0 | 20349 - 82.68% | 1,665,349$ | 68,279,290$ | 24611 | 100 | 64,169,000$ | 64,169,000$ | 0$ | 70,895,500$ | 320,845$ | 64,228,000$ | 21 | 0 | 0$ | 0$ | 0 | 353,845$ | 0$ | 0$ | 64,228,000$ | 24,228,000$ | 65,000,000$ | 772,000$ | 39,704,041$ | 39,704,041$ |
| 20 | Seattle | 7250 | 6000 | 2778 | 4500 | 1050 | 80 | 50 | 32 | 25 | 145 | 271621 | 234771 | 106065 | 183388 | 43048 | 91.38% | 95.44% | 93.12% | 99.40% | 100.00% | 0 | 20461 - 94.82% | 1,467,803$ | 60,179,913$ | 21578 | 100 | 54,069,000$ | 46,841,010$ | 5,797,500$ | 63,660,272$ | 234,205$ | 55,839,208$ | 25 | 0 | 0$ | 0$ | 0 | 285,345$ | 0$ | 0$ | 61,636,708$ | 21,636,708$ | 65,000,000$ | 3,363,292$ | 4,955,970$ | 4,955,970$ |
| 21 | St. Louis | 6400 | 6944 | 2778 | 5556 | 1389 | 88 | 62 | 39 | 30 | 120 | 260719 | 235452 | 103854 | 201316 | 49333 | 99.36% | 82.70% | 91.18% | 88.38% | 86.63% | 0 | 20748 - 89.95% | 1,623,131$ | 66,548,376$ | 23067 | 100 | 63,900,000$ | 60,828,000$ | 0$ | 66,344,000$ | 304,140$ | 61,591,540$ | 25 | 0 | 0$ | 0$ | 0 | 341,000$ | 0$ | 0$ | 61,591,540$ | 21,591,540$ | 65,000,000$ | 3,408,460$ | 18,632,797$ | 18,632,797$ |
| 22 | Tampa Bay | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 65 | 50 | 22 | 184 | 246000 | 192679 | 78510 | 209235 | 38365 | 100.00% | 93.99% | 70.40% | 93.13% | 93.57% | 0 | 18653 - 92.34% | 1,448,310$ | 59,380,706$ | 20200 | 100 | 55,140,000$ | 55,140,000$ | 2,520,000$ | 64,550,050$ | 275,700$ | 59,543,061$ | 21 | 0 | 0$ | 0$ | 0 | 298,200$ | 0$ | 0$ | 62,063,061$ | 22,063,061$ | 65,000,000$ | 2,936,939$ | 515,763$ | 515,763$ |
| 23 | Vancouver | 8333 | 6944 | 2778 | 5556 | 1289 | 115 | 75 | 55 | 40 | 200 | 174698 | 163208 | 72075 | 136398 | 34400 | 51.13% | 57.33% | 63.28% | 59.88% | 65.09% | 0 | 14165 - 56.89% | 1,473,897$ | 60,429,778$ | 24900 | 100 | 62,576,000$ | 62,576,000$ | 0$ | 67,747,000$ | 312,880$ | 63,497,000$ | 20 | 0 | 0$ | 0$ | 0 | 334,130$ | 0$ | 0$ | 63,497,000$ | 23,497,000$ | 65,000,000$ | 1,503,000$ | 5,007,861$ | 5,007,861$ |
| 24 | Washington | 7333 | 6944 | 2778 | 5556 | 1089 | 75 | 59 | 36 | 29 | 160 | 278475 | 240358 | 106622 | 204746 | 44184 | 92.62% | 84.42% | 93.61% | 89.88% | 98.96% | 0 | 21326 - 89.99% | 1,573,265$ | 64,503,861$ | 23700 | 100 | 70,014,000$ | 64,368,750$ | 1,162,000$ | 67,378,610$ | 321,844$ | 62,108,370$ | 22 | 0 | 0$ | 0$ | 0 | 358,820$ | 0$ | 0$ | 63,270,370$ | 23,270,370$ | 65,000,000$ | 1,729,630$ | 3,088,756$ | 3,088,756$ |
| 25 | Winnipeg | 6000 | 6000 | 2778 | 4000 | 1389 | 87 | 65 | 54 | 32 | 175 | 245985 | 195584 | 72208 | 164000 | 45977 | 99.99% | 79.51% | 63.40% | 100.00% | 80.73% | 0 | 17653 - 87.53% | 1,554,595$ | 63,738,410$ | 20167 | 100 | 58,275,000$ | 58,275,000$ | 324,000$ | 63,825,000$ | 291,375$ | 62,325,000$ | 23 | 0 | 0$ | 0$ | 0 | 298,875$ | 0$ | 0$ | 62,649,000$ | 22,649,000$ | 65,000,000$ | 2,351,000$ | 45,680,844$ | 45,680,844$ |
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