| 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é de l’aréna | 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é de l’aréna | 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 45,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 | 47443 | 32919 | 12621 | 34589 | 7754 | 81.33% | 67.72% | 64.90% | 88.94% | 79.75% | 35 | 19332 - 77.33% | 1,680,823$ | 11,765,760$ | 25000 | 100 | 66,030,000$ | 62,763,000$ | 1,416,000$ | 12,482,737$ | 373,589$ | 11,105,895$ | 22 | 0 | 0$ | 58,828,800$ | 138 | 421,429$ | 58,157,202$ | 61,774,258$ | 64,077,177$ | 19,077,177$ | 65,000,000$ | 922,823$ | 26,826,520$ | 28,241,672$ |
| 2 | Boston | 8333 | 6944 | 2778 | 5556 | 1389 | 75 | 60 | 50 | 40 | 175 | 55513 | 46383 | 15251 | 26849 | 9005 | 83.27% | 83.49% | 68.62% | 60.41% | 81.04% | 34 | 19125 - 76.50% | 1,618,569$ | 12,948,550$ | 25000 | 100 | 64,257,500$ | 59,861,900$ | 2,817,800$ | 12,461,935$ | 356,321$ | 11,242,303$ | 25 | 0 | 0$ | 55,031,338$ | 138 | 400,342$ | 55,247,196$ | 58,130,532$ | 63,232,401$ | 18,232,401$ | 65,000,000$ | 1,767,599$ | 17,367,362$ | 18,700,953$ |
| 3 | Buffalo | 6500 | 5000 | 2000 | 4000 | 1200 | 125 | 80 | 60 | 45 | 220 | 31861 | 30328 | 12604 | 23013 | 6183 | 61.27% | 75.82% | 78.77% | 71.92% | 64.41% | 34 | 12999 - 69.51% | 1,493,899$ | 11,951,188$ | 18700 | 100 | 63,564,000$ | 62,970,000$ | 1,152,000$ | 12,008,577$ | 374,821$ | 11,167,188$ | 22 | 0 | 0$ | 50,792,549$ | 138 | 405,440$ | 55,950,720$ | 58,871,456$ | 64,044,486$ | 19,044,486$ | 65,000,000$ | 955,514$ | 10,548,650$ | 6,897,827$ |
| 4 | Chicago | 8333 | 6944 | 2778 | 5556 | 1389 | 80 | 75 | 60 | 45 | 200 | 54013 | 32113 | 12809 | 24091 | 6829 | 81.02% | 57.81% | 57.64% | 54.20% | 61.46% | 34 | 16232 - 64.93% | 1,554,367$ | 12,434,938$ | 25000 | 100 | 63,445,000$ | 63,445,000$ | 0$ | 12,240,180$ | 377,649$ | 11,329,470$ | 20 | 0 | 0$ | 52,848,486$ | 138 | 408,006$ | 56,304,828$ | 58,522,988$ | 63,445,032$ | 18,445,032$ | 65,000,000$ | 1,554,968$ | 25,286,507$ | 23,987,363$ |
| 5 | Colorado | 6600 | 5100 | 2050 | 4025 | 1025 | 87 | 56 | 43 | 32 | 175 | 44910 | 35700 | 14350 | 28175 | 7175 | 97.21% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 18616 - 99.02% | 1,550,115$ | 10,850,805$ | 18800 | 100 | 64,650,000$ | 63,675,000$ | 0$ | 12,174,853$ | 379,018$ | 11,026,494$ | 22 | 1 | 0$ | 54,254,025$ | 138 | 411,607$ | 56,801,766$ | 61,432,702$ | 63,330,978$ | 18,330,978$ | 65,000,000$ | 1,669,022$ | 33,993,954$ | 31,195,137$ |
| 6 | Columbus | 8333 | 6944 | 2778 | 5556 | 1389 | 70 | 42 | 32 | 22 | 180 | 54316 | 48576 | 21490 | 43027 | 9226 | 81.48% | 87.44% | 96.70% | 96.80% | 83.03% | 34 | 22079 - 88.32% | 1,427,698$ | 11,421,583$ | 25000 | 100 | 63,370,000$ | 62,657,200$ | 0$ | 12,085,366$ | 372,960$ | 11,095,803$ | 22 | 0 | 0$ | 48,541,728$ | 138 | 406,369$ | 56,078,922$ | 60,035,162$ | 62,564,283$ | 17,564,283$ | 65,000,000$ | 2,435,717$ | -38,827$ | -6,921,313$ |
| 7 | Dallas | 8333 | 6944 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 27862 | 25987 | 11016 | 20683 | 5428 | 47.77% | 53.46% | 56.65% | 53.18% | 55.83% | 35 | 12997 - 51.99% | 1,490,637$ | 10,434,457$ | 25000 | 100 | 56,249,000$ | 56,249,000$ | 0$ | 11,433,005$ | 334,815$ | 10,762,742$ | 19 | 1 | 0$ | 52,172,285$ | 138 | 356,244$ | 49,161,672$ | 51,893,368$ | 56,967,212$ | 11,967,212$ | 65,000,000$ | 8,032,788$ | 24,942,978$ | 29,495,691$ |
| 8 | Detroit | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 60 | 45 | 220 | 35561 | 33911 | 14144 | 26803 | 6717 | 65.85% | 75.36% | 78.58% | 74.45% | 74.63% | 33 | 13015 - 72.31% | 1,484,794$ | 13,363,149$ | 18000 | 100 | 61,710,000$ | 60,126,000$ | 4,582,500$ | 11,466,823$ | 357,893$ | 10,653,407$ | 22 | 0 | 0$ | 48,998,213$ | 138 | 385,179$ | 53,154,702$ | 57,312,494$ | 64,625,141$ | 19,625,141$ | 65,000,000$ | 374,859$ | 3,105,563$ | -1,000,321$ |
| 9 | Edmonton | 6200 | 5300 | 2778 | 5556 | 1000 | 85 | 60 | 40 | 30 | 175 | 43400 | 37100 | 17711 | 33605 | 7000 | 100.00% | 100.00% | 91.08% | 86.41% | 100.00% | 35 | 19831 - 95.19% | 1,581,534$ | 11,070,737$ | 20834 | 100 | 63,010,000$ | 59,366,500$ | 0$ | 11,541,072$ | 353,372$ | 10,370,054$ | 24 | 1 | 0$ | 55,353,685$ | 138 | 406,012$ | 56,029,656$ | 59,889,472$ | 59,135,390$ | 14,135,390$ | 65,000,000$ | 5,864,610$ | 7,734,644$ | 8,128,317$ |
| 10 | Floride | 6000 | 5100 | 2778 | 5556 | 1000 | 90 | 75 | 55 | 45 | 200 | 42000 | 28641 | 12555 | 20449 | 5939 | 100.00% | 80.23% | 64.56% | 52.58% | 84.84% | 35 | 15655 - 76.61% | 1,558,322$ | 10,908,256$ | 20434 | 100 | 65,200,000$ | 63,863,500$ | 0$ | 12,654,462$ | 380,140$ | 11,403,960$ | 23 | 0 | 0$ | 54,541,280$ | 138 | 422,619$ | 58,321,422$ | 63,261,622$ | 63,863,280$ | 18,863,280$ | 65,000,000$ | 1,136,720$ | 1,993,207$ | -2,397,341$ |
| 11 | Los Angeles | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 62 | 52 | 35 | 180 | 42076 | 40000 | 15042 | 30521 | 8000 | 87.66% | 100.00% | 94.01% | 95.38% | 100.00% | 34 | 16955 - 94.19% | 1,526,194$ | 12,209,548$ | 18000 | 100 | 59,900,000$ | 54,455,000$ | 0$ | 11,639,284$ | 324,137$ | 9,727,276$ | 23 | 0 | 0$ | 51,890,579$ | 138 | 377,381$ | 52,078,578$ | 55,099,682$ | 54,458,182$ | 9,458,182$ | 65,000,000$ | 10,541,818$ | 20,932,355$ | 22,386,522$ |
| 12 | Minnesota | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 60 | 50 | 30 | 175 | 48000 | 40000 | 15404 | 39508 | 8000 | 100.00% | 100.00% | 70.79% | 90.12% | 100.00% | 34 | 18864 - 93.39% | 1,499,288$ | 11,994,301$ | 20200 | 100 | 63,236,200$ | 62,741,200$ | 1,260,000$ | 11,908,242$ | 373,460$ | 11,203,710$ | 21 | 0 | 0$ | 50,975,779$ | 138 | 397,239$ | 54,818,982$ | 57,907,678$ | 64,001,190$ | 19,001,190$ | 65,000,000$ | 998,810$ | 18,096,197$ | 15,577,583$ |
| 13 | Montreal | 6515 | 6040 | 2778 | 5556 | 1185 | 90 | 55 | 43 | 28 | 165 | 47376 | 39451 | 18158 | 35277 | 8131 | 90.90% | 81.65% | 81.70% | 79.37% | 85.77% | 34 | 18549 - 84.03% | 1,619,369$ | 12,954,949$ | 22074 | 100 | 60,450,000$ | 57,074,000$ | 0$ | 11,514,581$ | 339,726$ | 10,191,390$ | 23 | 0 | 0$ | 55,058,533$ | 138 | 385,119$ | 53,146,422$ | 56,853,646$ | 57,073,578$ | 12,073,578$ | 65,000,000$ | 7,926,422$ | 21,758,861$ | 24,431,903$ |
| 14 | NYIslanders | 7000 | 6000 | 2778 | 5556 | 1000 | 94 | 70 | 42 | 26 | 192 | 42712 | 34198 | 20270 | 39281 | 7193 | 76.27% | 71.25% | 91.21% | 88.38% | 89.91% | 34 | 17957 - 80.40% | 1,528,567$ | 12,228,535$ | 22334 | 100 | 64,050,000$ | 64,050,000$ | 0$ | 12,070,827$ | 381,250$ | 11,486,500$ | 20 | 0 | 0$ | 51,971,274$ | 138 | 399,107$ | 55,076,766$ | 59,625,830$ | 64,099,000$ | 19,099,000$ | 65,000,000$ | 901,000$ | 5,682,197$ | 2,670,756$ |
| 15 | NYRangers | 7020 | 6040 | 2778 | 5556 | 1389 | 125 | 80 | 60 | 45 | 220 | 33449 | 29400 | 12814 | 24512 | 6170 | 59.56% | 60.84% | 57.66% | 55.15% | 55.53% | 34 | 13293 - 58.35% | 1,525,376$ | 12,203,005$ | 22783 | 100 | 65,910,000$ | 62,445,000$ | 0$ | 12,643,739$ | 371,696$ | 11,127,044$ | 22 | 0 | 0$ | 51,862,771$ | 138 | 424,315$ | 58,555,470$ | 61,607,310$ | 62,421,092$ | 17,421,092$ | 65,000,000$ | 2,578,908$ | 1,165,034$ | -3,965,550$ |
| 16 | New Jersey | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 45 | 25 | 15 | 170 | 48000 | 40000 | 16000 | 32000 | 8000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 18000 - 100.00% | 1,193,750$ | 9,550,000$ | 18000 | 100 | 47,860,000$ | 45,261,250$ | 1,500,000$ | 8,620,833$ | 269,412$ | 8,093,387$ | 27 | 0 | 0$ | 40,587,500$ | 138 | 288,452$ | 39,806,376$ | 41,125,440$ | 46,772,243$ | 1,772,243$ | 65,000,000$ | 18,227,757$ | 17,212,347$ | 22,677,221$ |
| 17 | Philadelphie | 7033 | 6944 | 2778 | 5556 | 1389 | 80 | 54 | 40 | 36 | 165 | 48475 | 40712 | 17629 | 26192 | 8220 | 98.46% | 83.76% | 90.66% | 67.35% | 84.54% | 35 | 20175 - 85.13% | 1,621,575$ | 11,351,025$ | 23700 | 100 | 64,725,000$ | 64,725,000$ | 0$ | 12,346,730$ | 385,268$ | 11,569,940$ | 20 | 0 | 0$ | 56,755,125$ | 138 | 411,161$ | 56,740,218$ | 61,018,506$ | 64,736,924$ | 19,736,924$ | 65,000,000$ | 263,076$ | 17,414,076$ | 17,470,913$ |
| 18 | Pittsburgh | 7560 | 5950 | 2778 | 5000 | 1275 | 74 | 64 | 40 | 34 | 176 | 55918 | 41301 | 19804 | 34770 | 8854 | 92.46% | 86.77% | 89.11% | 86.93% | 86.80% | 34 | 20081 - 89.00% | 1,610,314$ | 12,882,510$ | 22563 | 100 | 65,550,000$ | 60,253,500$ | 4,631,000$ | 12,361,183$ | 358,652$ | 10,758,570$ | 26 | 0 | 0$ | 54,750,668$ | 138 | 415,333$ | 57,315,954$ | 61,134,562$ | 64,883,546$ | 19,883,546$ | 65,000,000$ | 116,454$ | 1,191,919$ | -823,710$ |
| 19 | San Jose | 8333 | 6944 | 2778 | 5556 | 1000 | 81 | 54 | 42 | 32 | 184 | 44397 | 39539 | 16335 | 31484 | 6758 | 66.60% | 71.17% | 73.50% | 70.83% | 84.48% | 34 | 17314 - 70.35% | 1,589,856$ | 12,718,849$ | 24611 | 100 | 62,965,000$ | 62,965,000$ | 0$ | 12,446,126$ | 374,792$ | 11,267,568$ | 20 | 0 | 0$ | 54,055,108$ | 138 | 414,077$ | 57,142,626$ | 60,563,162$ | 62,988,864$ | 17,988,864$ | 65,000,000$ | 2,011,136$ | 45,751,277$ | 43,743,983$ |
| 20 | Seattle | 7250 | 6000 | 2778 | 4500 | 1050 | 82 | 52 | 34 | 30 | 155 | 55172 | 45848 | 21260 | 36000 | 8400 | 95.12% | 95.52% | 95.66% | 100.00% | 100.00% | 34 | 20835 - 96.56% | 1,524,675$ | 12,197,401$ | 21578 | 100 | 60,767,000$ | 57,509,900$ | 4,605,000$ | 11,383,444$ | 342,321$ | 9,907,291$ | 24 | 0 | 0$ | 51,838,954$ | 138 | 392,964$ | 54,229,032$ | 57,179,416$ | 61,752,589$ | 16,752,589$ | 65,000,000$ | 3,247,411$ | 1,491,469$ | 877,827$ |
| 21 | St. Louis | 6400 | 6944 | 2778 | 5556 | 1389 | 88 | 62 | 39 | 30 | 120 | 50160 | 45737 | 20742 | 39303 | 9494 | 97.97% | 82.33% | 93.33% | 88.42% | 85.44% | 34 | 20680 - 89.65% | 1,621,419$ | 12,971,353$ | 23067 | 100 | 54,400,000$ | 53,800,000$ | 0$ | 10,607,130$ | 320,238$ | 9,607,140$ | 20 | 0 | 0$ | 55,128,250$ | 138 | 353,571$ | 48,792,798$ | 51,777,046$ | 53,799,984$ | 8,799,984$ | 65,000,000$ | 11,200,016$ | 20,447,852$ | 28,677,708$ |
| 22 | Tampa Bay | 6000 | 5000 | 2720 | 5480 | 1000 | 80 | 65 | 50 | 22 | 184 | 48000 | 36760 | 15725 | 41468 | 7563 | 100.00% | 91.90% | 72.27% | 94.59% | 94.54% | 34 | 18690 - 92.52% | 1,456,178$ | 11,649,422$ | 20200 | 100 | 62,000,000$ | 62,000,000$ | 2,520,000$ | 11,330,654$ | 369,048$ | 11,058,344$ | 20 | 0 | 0$ | 49,510,044$ | 138 | 378,125$ | 52,181,250$ | 54,716,970$ | 64,506,968$ | 19,506,968$ | 65,000,000$ | 493,032$ | 8,470,692$ | 7,797,941$ |
| 23 | Utah | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 45 | 25 | 15 | 170 | 48000 | 40000 | 16000 | 32000 | 8000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 18000 - 100.00% | 1,193,750$ | 9,550,000$ | 18000 | 100 | 52,976,000$ | 52,976,000$ | 1,751,000$ | 10,229,049$ | 315,333$ | 9,514,754$ | 22 | 0 | 0$ | 40,587,500$ | 138 | 339,143$ | 46,801,734$ | 50,001,814$ | 54,781,708$ | 9,781,708$ | 65,000,000$ | 10,218,292$ | 16,137,310$ | 13,056,591$ |
| 24 | Vancouver | 8333 | 6944 | 2778 | 5556 | 1289 | 115 | 75 | 55 | 40 | 200 | 35421 | 32202 | 14099 | 26559 | 7032 | 53.13% | 57.97% | 63.44% | 59.75% | 68.19% | 34 | 14414 - 57.89% | 1,520,745$ | 12,165,962$ | 24900 | 100 | 65,350,000$ | 64,459,000$ | 0$ | 12,087,506$ | 383,685$ | 11,510,441$ | 21 | 0 | 0$ | 51,705,338$ | 138 | 403,274$ | 55,651,812$ | 58,047,316$ | 64,458,971$ | 19,458,971$ | 65,000,000$ | 541,029$ | 2,749,541$ | 728,300$ |
| 25 | Washington | 7333 | 6944 | 2778 | 5556 | 1089 | 75 | 59 | 36 | 29 | 160 | 48319 | 39774 | 17309 | 34351 | 7592 | 94.13% | 81.83% | 89.01% | 88.32% | 99.59% | 35 | 21049 - 88.82% | 1,572,252$ | 11,005,767$ | 23700 | 100 | 63,984,000$ | 61,360,500$ | 0$ | 11,791,922$ | 365,241$ | 11,057,780$ | 22 | 0 | 0$ | 55,028,835$ | 138 | 391,274$ | 53,995,812$ | 56,202,140$ | 61,461,038$ | 16,461,038$ | 65,000,000$ | 3,538,962$ | 2,133,531$ | 5,484,015$ |
| 26 | Winnipeg | 6000 | 6000 | 2778 | 4000 | 1389 | 87 | 65 | 54 | 32 | 175 | 54000 | 42238 | 16006 | 36000 | 10499 | 100.00% | 78.22% | 64.02% | 100.00% | 83.99% | 33 | 17638 - 87.46% | 1,569,044$ | 14,121,399$ | 20167 | 100 | 54,600,000$ | 54,105,000$ | 1,300,000$ | 10,069,038$ | 322,054$ | 9,694,862$ | 22 | 0 | 0$ | 51,778,463$ | 138 | 334,821$ | 46,205,298$ | 48,591,418$ | 55,438,314$ | 10,438,314$ | 65,000,000$ | 9,561,686$ | 49,444,811$ | 57,097,178$ |
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
Tucson