| 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 | 231059 | 193263 | 76858 | 151485 | 30388 | 96.27% | 96.63% | 96.07% | 94.68% | 75.97% | 1 | 17076 - 94.87% | 1,181,411$ | 47,256,435$ | 18000 | 100 | 47,600,000$ | 47,600,000$ | 0$ | 40,515,132$ | 47,600,000$ | 40,028,757$ | 23 | 0 | 0$ | 1,181,411$ | 6 | 219,635$ | 1,317,810$ | 1,317,810$ | 51,125,000$ | 51,125,000$ | 63,000,000$ | 11,875,000$ | 46,589,092$ | 46,452,693$ |
| 2 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 226884 | 189581 | 75465 | 148910 | 29810 | 92.23% | 92.48% | 92.03% | 90.80% | 72.71% | 0 | 16357 - 90.87% | 1,131,446$ | 46,389,285$ | 18000 | 100 | 34,917,000$ | 34,917,000$ | 0$ | 33,814,188$ | 34,917,000$ | 33,327,903$ | 22 | 0 | 0$ | 0$ | 6 | 161,721$ | 970,326$ | 970,326$ | 36,480,200$ | 36,480,200$ | 63,000,000$ | 26,519,800$ | 88,984,369$ | 88,014,043$ |
| 3 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 228026 | 190806 | 75783 | 153029 | 30784 | 95.01% | 95.40% | 94.73% | 95.64% | 76.96% | 1 | 16961 - 94.23% | 1,172,147$ | 46,885,890$ | 18000 | 100 | 45,225,000$ | 45,225,000$ | 0$ | 49,563,557$ | 45,225,000$ | 49,077,266$ | 20 | 0 | 0$ | 1,172,147$ | 6 | 208,790$ | 1,252,740$ | 1,252,740$ | 46,225,000$ | 46,225,000$ | 63,000,000$ | 16,775,000$ | 28,608,143$ | 28,527,550$ |
| 4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 99 | 59 | 34 | 24 | 199 | 229437 | 187701 | 75149 | 150544 | 30454 | 95.60% | 93.85% | 93.94% | 94.09% | 76.14% | 1 | 16832 - 93.51% | 1,162,661$ | 46,506,429$ | 18000 | 100 | 45,375,000$ | 45,375,000$ | 2,415,000$ | 46,702,627$ | 45,375,000$ | 46,216,337$ | 22 | 0 | 0$ | 1,162,661$ | 6 | 209,475$ | 1,256,850$ | 1,256,850$ | 48,590,000$ | 48,590,000$ | 63,000,000$ | 14,410,000$ | 38,533,629$ | 38,439,440$ |
| 5 | Colorado Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 234363 | 196523 | 77292 | 155979 | 31019 | 95.27% | 95.86% | 94.26% | 95.11% | 75.66% | 0 | 16956 - 94.20% | 1,171,614$ | 48,036,175$ | 18000 | 100 | 47,599,999$ | 47,599,999$ | 0$ | 49,392,974$ | 43,099,999$ | 47,803,933$ | 21 | 2 | 0$ | 0$ | 6 | 219,635$ | 1,317,810$ | 1,317,810$ | 43,879,999$ | 43,879,999$ | 63,000,000$ | 19,120,001$ | 36,641,808$ | 35,323,998$ |
| 6 | Dallas Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 227988 | 188467 | 75754 | 151611 | 30284 | 95.00% | 94.23% | 94.69% | 94.76% | 75.71% | 1 | 16853 - 93.63% | 1,165,132$ | 46,605,285$ | 18000 | 100 | 54,000,000$ | 54,000,000$ | 0$ | 50,988,509$ | 54,000,000$ | 50,502,230$ | 21 | 0 | 0$ | 1,165,132$ | 6 | 248,858$ | 1,493,148$ | 1,493,148$ | 55,322,500$ | 55,322,500$ | 63,000,000$ | 7,677,500$ | 42,765,556$ | 42,437,540$ |
| 7 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 230627 | 192465 | 76875 | 152290 | 30495 | 96.09% | 96.23% | 96.09% | 95.18% | 76.24% | 1 | 17069 - 94.83% | 1,180,187$ | 47,207,475$ | 18000 | 100 | 61,750,000$ | 61,750,000$ | 0$ | 56,156,417$ | 61,750,000$ | 55,670,034$ | 22 | 0 | 0$ | 1,180,187$ | 6 | 284,247$ | 1,705,482$ | 1,705,482$ | 62,600,000$ | 62,600,000$ | 63,000,000$ | 400,000$ | 44,204,170$ | 43,678,875$ |
| 8 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 65 | 40 | 25 | 175 | 239448 | 162320 | 61399 | 158670 | 39452 | 97.34% | 79.18% | 74.88% | 96.75% | 96.22% | 0 | 16129 - 89.61% | 1,107,998$ | 45,427,930$ | 18000 | 100 | 61,500,000$ | 61,500,000$ | 0$ | 55,012,586$ | 61,500,000$ | 54,526,275$ | 22 | 0 | 0$ | 0$ | 6 | 283,105$ | 1,698,630$ | 1,698,630$ | 62,310,000$ | 62,310,000$ | 63,000,000$ | 690,000$ | 24,724,676$ | 23,026,046$ |
| 9 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 226272 | 187343 | 74621 | 150874 | 29829 | 94.28% | 93.67% | 93.28% | 94.30% | 74.57% | 1 | 16723 - 92.91% | 1,155,429$ | 46,217,165$ | 18000 | 100 | 26,750,000$ | 26,750,000$ | 1,925,000$ | 33,623,773$ | 26,750,000$ | 33,137,396$ | 20 | 0 | 0$ | 1,155,429$ | 6 | 124,429$ | 746,574$ | 746,574$ | 30,095,000$ | 30,095,000$ | 63,000,000$ | 32,905,000$ | 82,793,212$ | 83,202,067$ |
| 10 | Minnesota Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 228643 | 190778 | 75534 | 153996 | 30637 | 95.27% | 95.39% | 94.42% | 96.25% | 76.59% | 1 | 16990 - 94.39% | 1,173,299$ | 46,931,970$ | 18000 | 100 | 46,500,000$ | 46,500,000$ | 0$ | 44,537,665$ | 46,500,000$ | 44,051,386$ | 23 | 0 | 0$ | 1,173,299$ | 6 | 214,612$ | 1,287,672$ | 1,287,672$ | 47,575,000$ | 47,575,000$ | 63,000,000$ | 15,425,000$ | 49,265,969$ | 49,151,596$ |
| 11 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 226658 | 188386 | 76069 | 152907 | 30159 | 94.44% | 94.19% | 95.09% | 95.57% | 75.40% | 1 | 16854 - 93.64% | 1,162,146$ | 46,485,850$ | 18000 | 100 | 29,200,000$ | 29,200,000$ | 0$ | 34,625,961$ | 29,200,000$ | 34,139,682$ | 23 | 0 | 0$ | 1,162,146$ | 6 | 135,616$ | 813,696$ | 813,696$ | 30,575,000$ | 30,575,000$ | 63,000,000$ | 32,425,000$ | 60,075,694$ | 60,424,144$ |
| 12 | Nashville Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 225904 | 189082 | 76325 | 150763 | 30188 | 91.83% | 92.24% | 93.08% | 91.93% | 73.63% | 0 | 16397 - 91.09% | 1,132,033$ | 46,413,370$ | 18000 | 100 | 35,900,000$ | 35,900,000$ | 0$ | 36,859,357$ | 35,900,000$ | 36,071,710$ | 21 | 1 | 0$ | 0$ | 6 | 166,210$ | 997,260$ | 997,260$ | 36,600,000$ | 36,600,000$ | 63,000,000$ | 26,400,000$ | 47,521,178$ | 46,523,918$ |
| 13 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 68 | 45 | 28 | 210 | 193349 | 150571 | 53922 | 122274 | 29428 | 78.60% | 73.45% | 65.76% | 74.56% | 71.78% | 0 | 13404 - 74.46% | 1,038,305$ | 42,570,515$ | 18000 | 100 | 56,650,000$ | 56,650,000$ | 0$ | 49,449,788$ | 56,650,000$ | 48,903,232$ | 22 | 0 | 0$ | 0$ | 6 | 260,959$ | 1,565,754$ | 1,565,754$ | 57,980,000$ | 57,980,000$ | 63,000,000$ | 5,020,000$ | 42,988,029$ | 41,422,275$ |
| 14 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 228821 | 189613 | 76028 | 152659 | 30519 | 95.34% | 94.81% | 95.04% | 95.41% | 76.30% | 1 | 16941 - 94.12% | 1,171,003$ | 46,840,135$ | 18000 | 100 | 50,100,000$ | 50,100,000$ | 0$ | 48,683,987$ | 50,100,000$ | 48,197,708$ | 21 | 0 | 0$ | 1,171,003$ | 6 | 231,050$ | 1,386,300$ | 1,386,300$ | 51,250,000$ | 51,250,000$ | 63,000,000$ | 11,750,000$ | 41,643,475$ | 41,428,178$ |
| 15 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 30 | 220 | 189375 | 162338 | 61978 | 118845 | 28783 | 76.98% | 79.19% | 75.58% | 72.47% | 70.20% | 0 | 13691 - 76.06% | 1,067,316$ | 43,759,950$ | 18000 | 100 | 58,499,999$ | 58,499,999$ | 2,100,000$ | 50,337,914$ | 58,499,999$ | 49,851,587$ | 21 | 0 | 0$ | 0$ | 6 | 269,406$ | 1,616,436$ | 1,616,436$ | 62,139,999$ | 62,139,999$ | 63,000,000$ | 860,001$ | 51,786,655$ | 50,170,219$ |
| 16 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 223436 | 185891 | 75767 | 150257 | 29696 | 95.49% | 95.33% | 97.14% | 96.32% | 76.14% | 2 | 17052 - 94.74% | 1,175,501$ | 45,844,530$ | 18000 | 100 | 60,000,000$ | 60,000,000$ | 175,000$ | 54,723,733$ | 60,000,000$ | 53,383,553$ | 22 | 0 | 0$ | 2,351,002$ | 6 | 276,256$ | 1,657,536$ | 1,657,536$ | 61,080,000$ | 61,080,000$ | 63,000,000$ | 1,920,000$ | 65,005,327$ | 65,698,793$ |
| 17 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 225238 | 189043 | 74717 | 150778 | 30050 | 96.26% | 96.95% | 95.79% | 96.65% | 77.05% | 2 | 17175 - 95.42% | 1,186,178$ | 46,260,925$ | 18000 | 100 | 57,500,000$ | 57,500,000$ | 0$ | 48,175,332$ | 57,500,000$ | 47,689,051$ | 23 | 0 | 0$ | 2,372,355$ | 6 | 264,840$ | 1,589,040$ | 1,589,040$ | 59,035,000$ | 59,035,000$ | 63,000,000$ | 3,965,000$ | 35,593,004$ | 36,376,319$ |
| 18 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 235934 | 193649 | 78811 | 155758 | 31308 | 95.91% | 94.46% | 96.11% | 94.97% | 76.36% | 0 | 16962 - 94.24% | 1,173,812$ | 48,126,275$ | 18000 | 100 | 53,000,000$ | 53,000,000$ | 0$ | 52,062,775$ | 53,000,000$ | 51,576,482$ | 22 | 0 | 0$ | 0$ | 6 | 244,292$ | 1,465,752$ | 1,465,752$ | 54,050,000$ | 54,050,000$ | 63,000,000$ | 8,950,000$ | 32,502,304$ | 31,036,552$ |
| 19 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 20 | 190 | 231585 | 193166 | 77086 | 155288 | 37107 | 96.49% | 96.58% | 96.36% | 97.06% | 92.77% | 1 | 17356 - 96.42% | 982,563$ | 39,302,510$ | 18000 | 100 | 39,425,000$ | 39,425,000$ | 0$ | 48,074,117$ | 39,425,000$ | 47,587,771$ | 20 | 0 | 0$ | 982,563$ | 6 | 182,306$ | 1,093,836$ | 1,093,836$ | 40,325,000$ | 40,325,000$ | 63,000,000$ | 22,675,000$ | 17,539,203$ | 17,427,930$ |
| 20 | Utah Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 120 | 70 | 50 | 25 | 99942 | 83709 | 33255 | 66900 | 40000 | 41.64% | 41.85% | 41.57% | 41.81% | 100.00% | 1 | 8095 - 44.97% | 917,658$ | 36,706,330$ | 18000 | 100 | 31,850,000$ | 31,850,000$ | 0$ | 37,246,776$ | 31,850,000$ | 36,760,494$ | 23 | 0 | 0$ | 917,658$ | 6 | 147,717$ | 886,302$ | 886,302$ | 33,150,000$ | 33,150,000$ | 63,000,000$ | 29,850,000$ | 24,742,596$ | 24,773,952$ |
| 21 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 228100 | 192619 | 76236 | 154809 | 30419 | 95.04% | 96.31% | 95.30% | 96.76% | 76.05% | 1 | 17055 - 94.75% | 1,174,736$ | 46,989,425$ | 18000 | 100 | 59,450,000$ | 59,450,000$ | 350,000$ | 54,515,263$ | 59,450,000$ | 54,001,592$ | 23 | 0 | 0$ | 1,174,736$ | 6 | 273,744$ | 1,642,464$ | 1,642,464$ | 60,825,000$ | 60,825,000$ | 63,000,000$ | 2,175,000$ | 67,841,504$ | 67,373,776$ |
| 22 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 218525 | 181956 | 74045 | 147118 | 29213 | 91.05% | 90.98% | 92.56% | 91.95% | 73.03% | 1 | 16271 - 90.40% | 1,122,050$ | 44,881,985$ | 18000 | 100 | 39,650,000$ | 39,650,000$ | 0$ | 38,790,168$ | 39,650,000$ | 38,303,879$ | 23 | 0 | 0$ | 1,122,050$ | 6 | 183,333$ | 1,099,998$ | 1,099,998$ | 42,137,500$ | 42,137,500$ | 63,000,000$ | 20,862,500$ | 43,315,214$ | 43,337,266$ |