| 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 0$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Boston Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 87413 | 72507 | 28582 | 56721 | 11076 | 97.13% | 96.68% | 95.27% | 94.54% | 73.84% | 26 | 17087 - 94.93% | 1,181,688$ | 17,725,315$ | 18000 | 100 | 37,600,000$ | 37,600,000$ | 0$ | 13,395,921$ | 37,600,000$ | 13,220,053$ | 20 | 0 | 0$ | 30,723,879$ | 142 | 173,973$ | 24,704,166$ | 25,891,550$ | 39,025,000$ | 39,025,000$ | 58,000,000$ | 18,975,000$ | 45,749,826$ | 50,582,155$ |
| 2 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 83678 | 71414 | 28227 | 55762 | 11128 | 92.98% | 95.22% | 94.09% | 92.94% | 74.19% | 26 | 16681 - 92.67% | 1,150,682$ | 17,260,235$ | 18000 | 100 | 33,917,000$ | 33,917,000$ | 0$ | 12,100,935$ | 33,917,000$ | 11,925,144$ | 21 | 0 | 0$ | 29,917,741$ | 142 | 157,155$ | 22,316,010$ | 23,296,364$ | 35,130,200$ | 35,130,200$ | 58,000,000$ | 22,869,800$ | 82,556,680$ | 89,178,057$ |
| 3 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 85218 | 72707 | 27832 | 57557 | 11696 | 94.69% | 96.94% | 92.77% | 95.93% | 77.97% | 26 | 17001 - 94.45% | 1,175,764$ | 17,636,465$ | 18000 | 100 | 51,725,000$ | 51,725,000$ | 0$ | 19,069,963$ | 51,725,000$ | 18,894,161$ | 20 | 0 | 0$ | 30,569,873$ | 142 | 238,470$ | 33,862,740$ | 34,978,539$ | 53,175,000$ | 53,175,000$ | 58,000,000$ | 4,825,000$ | 30,864,783$ | 26,456,117$ |
| 4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 87624 | 69940 | 28249 | 55657 | 11449 | 97.36% | 93.25% | 94.16% | 92.76% | 76.33% | 26 | 16861 - 93.67% | 1,175,249$ | 17,628,740$ | 18000 | 100 | 49,000,000$ | 49,000,000$ | 2,415,000$ | 17,417,789$ | 49,000,000$ | 17,241,987$ | 20 | 0 | 0$ | 30,556,483$ | 142 | 226,027$ | 32,095,834$ | 32,947,026$ | 52,402,500$ | 52,402,500$ | 58,000,000$ | 5,597,500$ | 39,730,166$ | 37,339,623$ |
| 5 | Colorado Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 84554 | 71706 | 28806 | 57142 | 11390 | 93.95% | 95.61% | 96.02% | 95.24% | 75.93% | 26 | 16907 - 93.93% | 1,164,835$ | 17,472,520$ | 18000 | 100 | 53,099,999$ | 52,599,998$ | 0$ | 18,772,617$ | 52,599,998$ | 18,421,035$ | 23 | 0 | 0$ | 30,285,701$ | 142 | 244,749$ | 34,754,358$ | 35,458,157$ | 53,329,998$ | 53,329,998$ | 58,000,000$ | 4,670,002$ | 37,413,987$ | 32,241,531$ |
| 6 | Dallas Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 86109 | 70803 | 28391 | 57300 | 11695 | 95.68% | 94.40% | 94.64% | 95.50% | 77.97% | 26 | 16953 - 94.18% | 1,174,951$ | 17,624,265$ | 18000 | 100 | 54,000,000$ | 54,000,000$ | 0$ | 17,162,085$ | 54,000,000$ | 16,986,294$ | 21 | 0 | 0$ | 30,548,726$ | 142 | 248,858$ | 35,337,836$ | 36,380,711$ | 55,322,500$ | 55,322,500$ | 58,000,000$ | 2,677,500$ | 48,653,835$ | 42,821,850$ |
| 7 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 80144 | 66455 | 26325 | 52731 | 10533 | 95.41% | 94.94% | 94.02% | 94.16% | 75.24% | 27 | 16871 - 93.73% | 1,167,711$ | 16,347,950$ | 18000 | 100 | 52,750,000$ | 52,750,000$ | 0$ | 19,571,924$ | 52,750,000$ | 19,396,112$ | 20 | 1 | 0$ | 31,528,189$ | 142 | 243,151$ | 34,527,442$ | 35,328,576$ | 53,650,000$ | 53,650,000$ | 58,000,000$ | 4,350,000$ | 50,709,700$ | 46,909,313$ |
| 8 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 65 | 40 | 25 | 175 | 82080 | 54301 | 20643 | 52537 | 13349 | 97.71% | 77.57% | 73.73% | 93.82% | 95.35% | 27 | 15922 - 88.46% | 1,099,428$ | 15,391,985$ | 18000 | 100 | 52,750,000$ | 52,750,000$ | 0$ | 18,907,550$ | 52,750,000$ | 18,731,758$ | 20 | 1 | 0$ | 29,684,542$ | 142 | 243,151$ | 34,527,442$ | 35,277,076$ | 53,560,000$ | 53,560,000$ | 58,000,000$ | 4,440,000$ | 31,552,019$ | 25,959,485$ |
| 9 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 80722 | 67218 | 27275 | 54209 | 10496 | 96.10% | 96.03% | 97.41% | 96.80% | 74.97% | 27 | 17137 - 95.21% | 1,179,595$ | 16,514,330$ | 18000 | 100 | 33,250,000$ | 33,250,000$ | 1,925,000$ | 14,676,514$ | 33,250,000$ | 14,500,669$ | 21 | 0 | 0$ | 31,849,065$ | 142 | 154,110$ | 21,883,620$ | 22,982,321$ | 36,595,000$ | 36,595,000$ | 58,000,000$ | 21,405,000$ | 73,269,264$ | 82,136,008$ |
| 10 | Minnesota Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 84322 | 70801 | 28281 | 57148 | 11271 | 93.69% | 94.40% | 94.27% | 95.25% | 75.14% | 26 | 16788 - 93.27% | 1,156,866$ | 17,352,995$ | 18000 | 100 | 44,750,000$ | 44,750,000$ | 0$ | 15,969,175$ | 44,750,000$ | 15,793,384$ | 21 | 0 | 0$ | 30,078,525$ | 142 | 206,621$ | 29,340,182$ | 30,312,914$ | 45,950,000$ | 45,950,000$ | 58,000,000$ | 12,050,000$ | 49,221,976$ | 48,987,587$ |
| 11 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 79189 | 66158 | 26628 | 54494 | 10425 | 94.27% | 94.51% | 95.10% | 97.31% | 74.46% | 27 | 16921 - 94.01% | 1,161,979$ | 16,267,710$ | 18000 | 100 | 38,200,000$ | 38,200,000$ | 0$ | 13,419,618$ | 38,200,000$ | 13,243,827$ | 21 | 0 | 0$ | 31,373,441$ | 142 | 176,712$ | 25,093,104$ | 26,223,220$ | 39,675,000$ | 39,675,000$ | 58,000,000$ | 18,325,000$ | 52,181,237$ | 57,331,458$ |
| 12 | Nashville Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 77644 | 65315 | 26609 | 51521 | 10407 | 92.43% | 93.31% | 95.03% | 92.00% | 74.34% | 27 | 16535 - 91.86% | 1,141,717$ | 15,984,040$ | 18000 | 100 | 35,900,000$ | 35,400,000$ | 0$ | 14,254,797$ | 35,400,000$ | 13,903,203$ | 22 | 0 | 0$ | 30,826,363$ | 142 | 166,210$ | 23,601,820$ | 24,288,521$ | 36,100,000$ | 36,100,000$ | 58,000,000$ | 21,900,000$ | 40,383,109$ | 46,920,951$ |
| 13 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 68 | 45 | 28 | 210 | 71509 | 53734 | 19216 | 44254 | 10740 | 79.45% | 71.65% | 64.05% | 73.76% | 71.60% | 26 | 13297 - 73.87% | 1,034,773$ | 15,521,589$ | 18000 | 100 | 42,575,000$ | 42,475,000$ | 0$ | 15,286,656$ | 42,475,000$ | 15,075,696$ | 21 | 0 | 0$ | 26,904,088$ | 142 | 196,689$ | 27,929,838$ | 28,948,405$ | 43,555,000$ | 43,555,000$ | 58,000,000$ | 14,445,000$ | 51,138,316$ | 49,093,999$ |
| 14 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 87080 | 71168 | 28375 | 57338 | 11212 | 96.76% | 94.89% | 94.58% | 95.56% | 74.75% | 26 | 17012 - 94.51% | 1,176,470$ | 17,647,055$ | 18000 | 100 | 50,600,000$ | 50,600,000$ | 0$ | 17,226,942$ | 50,600,000$ | 17,051,151$ | 22 | 0 | 0$ | 30,588,229$ | 142 | 233,333$ | 33,133,286$ | 34,048,853$ | 51,650,000$ | 51,650,000$ | 58,000,000$ | 6,350,000$ | 44,844,135$ | 41,383,511$ |
| 15 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 30 | 220 | 63386 | 55296 | 20617 | 39042 | 9695 | 75.46% | 78.99% | 73.63% | 69.72% | 69.25% | 27 | 13431 - 74.62% | 1,049,681$ | 14,695,540$ | 18000 | 100 | 50,999,999$ | 50,999,999$ | 2,100,000$ | 16,061,672$ | 50,999,999$ | 15,885,833$ | 22 | 0 | 0$ | 28,341,399$ | 142 | 235,160$ | 33,392,720$ | 34,560,019$ | 54,639,999$ | 54,639,999$ | 58,000,000$ | 3,360,001$ | 58,150,288$ | 51,931,668$ |
| 16 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 85681 | 70091 | 28846 | 57303 | 11540 | 95.20% | 93.45% | 96.15% | 95.51% | 76.93% | 26 | 16897 - 93.87% | 1,168,250$ | 17,523,745$ | 18000 | 100 | 51,750,000$ | 51,750,000$ | 175,000$ | 19,823,030$ | 51,750,000$ | 19,647,236$ | 21 | 1 | 0$ | 30,374,491$ | 142 | 238,584$ | 33,878,928$ | 34,682,946$ | 52,830,000$ | 52,830,000$ | 58,000,000$ | 5,170,000$ | 72,382,570$ | 68,074,115$ |
| 17 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 87561 | 73303 | 28760 | 58360 | 11585 | 97.29% | 97.74% | 95.87% | 97.27% | 77.23% | 26 | 17305 - 96.14% | 1,195,792$ | 17,936,880$ | 18000 | 100 | 50,900,000$ | 50,900,000$ | 0$ | 14,350,683$ | 50,900,000$ | 14,174,892$ | 21 | 0 | 0$ | 31,090,592$ | 142 | 234,703$ | 33,327,826$ | 34,449,393$ | 52,360,000$ | 52,360,000$ | 58,000,000$ | 5,640,000$ | 42,568,786$ | 39,209,985$ |
| 18 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 86226 | 70884 | 28461 | 56967 | 11372 | 95.81% | 94.51% | 94.87% | 94.95% | 75.81% | 26 | 16927 - 94.04% | 1,171,357$ | 17,570,350$ | 18000 | 100 | 53,750,000$ | 53,750,000$ | 0$ | 18,786,547$ | 53,750,000$ | 18,610,742$ | 23 | 0 | 0$ | 30,455,273$ | 142 | 247,717$ | 35,175,814$ | 35,919,680$ | 54,550,000$ | 54,550,000$ | 58,000,000$ | 3,450,000$ | 36,090,649$ | 30,626,242$ |
| 19 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 20 | 190 | 88422 | 73476 | 29151 | 58170 | 14245 | 98.25% | 97.97% | 97.17% | 96.95% | 94.97% | 26 | 17564 - 97.58% | 998,594$ | 14,978,905$ | 18000 | 100 | 51,250,000$ | 51,250,000$ | 0$ | 20,014,868$ | 51,250,000$ | 19,839,010$ | 20 | 0 | 0$ | 25,963,435$ | 142 | 236,301$ | 33,554,742$ | 34,413,041$ | 52,250,000$ | 52,250,000$ | 58,000,000$ | 5,750,000$ | 22,104,308$ | 13,654,702$ |
| 20 | Utah Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 120 | 70 | 50 | 25 | 37128 | 31590 | 12426 | 25160 | 15000 | 41.25% | 42.12% | 41.42% | 41.93% | 100.00% | 26 | 8087 - 44.93% | 914,615$ | 13,719,220$ | 18000 | 100 | 37,850,000$ | 37,850,000$ | 0$ | 16,371,901$ | 37,850,000$ | 16,196,110$ | 20 | 0 | 0$ | 23,779,981$ | 142 | 175,114$ | 24,866,188$ | 25,953,456$ | 39,200,000$ | 39,200,000$ | 58,000,000$ | 18,800,000$ | 23,673,701$ | 21,500,226$ |
| 21 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 84784 | 71516 | 28347 | 57418 | 11237 | 94.20% | 95.35% | 94.49% | 95.70% | 74.91% | 26 | 16887 - 93.82% | 1,162,957$ | 17,444,355$ | 18000 | 100 | 53,950,000$ | 53,950,000$ | 350,000$ | 18,993,832$ | 53,950,000$ | 18,818,041$ | 22 | 0 | 0$ | 30,236,882$ | 142 | 248,630$ | 35,305,460$ | 36,178,076$ | 55,325,000$ | 55,325,000$ | 58,000,000$ | 2,675,000$ | 74,687,423$ | 68,746,229$ |
| 22 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 83706 | 69500 | 28334 | 56090 | 11228 | 93.01% | 92.67% | 94.45% | 93.48% | 74.85% | 26 | 16591 - 92.17% | 1,145,343$ | 17,180,140$ | 18000 | 100 | 39,250,000$ | 39,250,000$ | 0$ | 13,944,069$ | 39,250,000$ | 13,768,278$ | 23 | 0 | 0$ | 29,778,909$ | 142 | 181,507$ | 25,773,994$ | 27,454,851$ | 41,687,500$ | 41,687,500$ | 58,000,000$ | 16,312,500$ | 42,149,242$ | 44,473,300$ |