| 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 | 174647 | 145195 | 57320 | 113584 | 22627 | 97.03% | 96.80% | 95.53% | 94.65% | 75.42% | 11 | 17112 - 95.07% | 1,184,920$ | 35,547,600$ | 18000 | 100 | 47,600,000$ | 47,600,000$ | 0$ | 28,654,842$ | 47,600,000$ | 28,291,749$ | 23 | 0 | 0$ | 13,034,120$ | 60 | 219,635$ | 13,178,100$ | 13,647,681$ | 51,125,000$ | 51,125,000$ | 63,000,000$ | 11,875,000$ | 47,210,128$ | 46,596,567$ |
| 2 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 166926 | 141434 | 55776 | 110213 | 22011 | 92.74% | 94.29% | 92.96% | 91.84% | 73.37% | 11 | 16545 - 91.92% | 1,142,944$ | 34,288,325$ | 18000 | 100 | 34,417,000$ | 34,417,000$ | 0$ | 25,067,550$ | 34,417,000$ | 24,704,553$ | 22 | 0 | 0$ | 12,572,386$ | 60 | 159,438$ | 9,566,280$ | 9,760,320$ | 35,580,200$ | 35,580,200$ | 63,000,000$ | 27,419,800$ | 85,854,081$ | 88,666,147$ |
| 3 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 176350 | 148634 | 58704 | 118507 | 23913 | 94.81% | 95.89% | 94.68% | 95.57% | 77.14% | 10 | 16971 - 94.28% | 1,172,676$ | 36,352,955$ | 18000 | 100 | 45,225,000$ | 45,225,000$ | 0$ | 38,288,897$ | 45,225,000$ | 37,925,888$ | 20 | 0 | 0$ | 11,726,760$ | 60 | 208,790$ | 12,527,400$ | 12,702,393$ | 46,225,000$ | 46,225,000$ | 63,000,000$ | 16,775,000$ | 29,524,861$ | 28,549,228$ |
| 4 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 99 | 59 | 34 | 24 | 199 | 178418 | 144628 | 58457 | 117750 | 23565 | 95.92% | 93.31% | 94.29% | 94.96% | 76.02% | 10 | 16865 - 93.69% | 1,167,379$ | 36,188,746$ | 18000 | 100 | 44,875,000$ | 44,875,000$ | 2,415,000$ | 35,429,788$ | 44,875,000$ | 35,066,780$ | 21 | 0 | 0$ | 11,673,789$ | 60 | 207,192$ | 12,431,520$ | 12,589,020$ | 48,140,000$ | 48,140,000$ | 63,000,000$ | 14,860,000$ | 39,645,173$ | 38,729,942$ |
| 5 | Colorado Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 176276 | 148482 | 58459 | 117850 | 23540 | 94.77% | 95.79% | 94.29% | 95.04% | 75.94% | 10 | 16923 - 94.02% | 1,168,930$ | 36,236,835$ | 18000 | 100 | 47,599,999$ | 47,599,999$ | 0$ | 37,523,552$ | 47,599,999$ | 36,859,165$ | 23 | 0 | 0$ | 11,689,302$ | 60 | 219,635$ | 13,178,100$ | 13,321,593$ | 48,329,999$ | 48,329,999$ | 63,000,000$ | 14,670,001$ | 36,855,941$ | 35,223,650$ |
| 6 | Dallas Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 172365 | 141347 | 56839 | 113741 | 22977 | 95.76% | 94.23% | 94.73% | 94.78% | 76.59% | 11 | 16909 - 93.94% | 1,171,520$ | 35,145,610$ | 18000 | 100 | 54,000,000$ | 54,000,000$ | 0$ | 37,550,177$ | 54,000,000$ | 37,187,180$ | 21 | 0 | 0$ | 12,886,724$ | 60 | 248,858$ | 14,931,480$ | 15,144,105$ | 55,322,500$ | 55,322,500$ | 63,000,000$ | 7,677,500$ | 44,956,838$ | 42,699,457$ |
| 7 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 172273 | 144004 | 57515 | 114005 | 22947 | 95.71% | 96.00% | 95.86% | 95.00% | 76.49% | 11 | 17025 - 94.58% | 1,177,336$ | 35,320,090$ | 18000 | 100 | 61,750,000$ | 61,750,000$ | 0$ | 40,807,079$ | 61,750,000$ | 40,444,032$ | 22 | 0 | 0$ | 12,950,700$ | 60 | 284,247$ | 17,054,820$ | 17,212,320$ | 62,600,000$ | 62,600,000$ | 63,000,000$ | 400,000$ | 47,823,623$ | 43,562,003$ |
| 8 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 65 | 40 | 25 | 175 | 175191 | 118495 | 44831 | 115369 | 28752 | 97.33% | 79.00% | 74.72% | 96.14% | 95.84% | 11 | 16088 - 89.38% | 1,105,948$ | 33,178,430$ | 18000 | 100 | 61,500,000$ | 61,500,000$ | 0$ | 39,724,916$ | 61,500,000$ | 39,361,887$ | 22 | 0 | 0$ | 12,165,424$ | 60 | 283,105$ | 16,986,300$ | 17,139,138$ | 62,310,000$ | 62,310,000$ | 63,000,000$ | 690,000$ | 27,915,684$ | 22,941,970$ |
| 9 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 169750 | 141120 | 56720 | 114804 | 22395 | 94.31% | 94.08% | 94.53% | 95.67% | 74.65% | 11 | 16826 - 93.48% | 1,159,217$ | 34,776,500$ | 18000 | 100 | 26,750,000$ | 26,750,000$ | 1,925,000$ | 26,853,232$ | 26,750,000$ | 26,490,137$ | 20 | 0 | 0$ | 12,751,383$ | 60 | 124,429$ | 7,465,740$ | 7,689,747$ | 30,095,000$ | 30,095,000$ | 63,000,000$ | 32,905,000$ | 78,347,095$ | 83,408,731$ |
| 10 | Minnesota Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 176919 | 146797 | 58273 | 119213 | 23646 | 95.12% | 94.71% | 93.99% | 96.14% | 76.28% | 10 | 16931 - 94.06% | 1,169,316$ | 36,248,800$ | 18000 | 100 | 45,250,000$ | 45,250,000$ | 0$ | 33,039,945$ | 45,250,000$ | 32,676,948$ | 22 | 0 | 0$ | 11,693,161$ | 60 | 208,904$ | 12,534,240$ | 12,732,564$ | 46,450,000$ | 46,450,000$ | 63,000,000$ | 16,550,000$ | 50,275,373$ | 49,235,970$ |
| 11 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 174373 | 146390 | 58907 | 119494 | 23242 | 93.75% | 94.45% | 95.01% | 96.37% | 74.97% | 10 | 16852 - 93.62% | 1,158,651$ | 35,918,195$ | 18000 | 100 | 28,700,000$ | 28,700,000$ | 0$ | 27,323,244$ | 28,700,000$ | 26,960,247$ | 22 | 0 | 0$ | 11,586,515$ | 60 | 133,333$ | 7,999,980$ | 8,224,554$ | 30,125,000$ | 30,125,000$ | 63,000,000$ | 32,875,000$ | 57,032,006$ | 60,393,967$ |
| 12 | Nashville Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 164554 | 139815 | 56325 | 110361 | 22333 | 91.42% | 93.21% | 93.88% | 91.97% | 74.44% | 11 | 16446 - 91.37% | 1,134,710$ | 34,041,300$ | 18000 | 100 | 35,900,000$ | 35,900,000$ | 0$ | 27,884,017$ | 35,900,000$ | 27,219,652$ | 22 | 0 | 0$ | 12,481,810$ | 60 | 166,210$ | 9,972,600$ | 10,112,607$ | 36,600,000$ | 36,600,000$ | 63,000,000$ | 26,400,000$ | 44,264,455$ | 46,633,658$ |
| 13 | New York Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 68 | 45 | 28 | 210 | 142193 | 109384 | 39151 | 89165 | 21371 | 79.00% | 72.92% | 65.25% | 74.30% | 71.24% | 11 | 13375 - 74.31% | 1,037,157$ | 31,114,702$ | 18000 | 100 | 56,650,000$ | 56,650,000$ | 0$ | 35,358,002$ | 56,650,000$ | 34,934,728$ | 22 | 0 | 0$ | 11,408,724$ | 60 | 260,959$ | 15,657,540$ | 15,871,047$ | 57,980,000$ | 57,980,000$ | 63,000,000$ | 5,020,000$ | 45,837,509$ | 41,375,186$ |
| 14 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 173149 | 141684 | 57159 | 114310 | 22703 | 96.19% | 94.46% | 95.27% | 95.26% | 75.68% | 11 | 16967 - 94.26% | 1,173,829$ | 35,214,855$ | 18000 | 100 | 50,100,000$ | 50,100,000$ | 0$ | 36,207,287$ | 50,100,000$ | 35,844,290$ | 21 | 0 | 0$ | 12,912,114$ | 60 | 231,050$ | 13,863,000$ | 14,055,507$ | 51,250,000$ | 51,250,000$ | 63,000,000$ | 11,750,000$ | 42,687,402$ | 41,544,009$ |
| 15 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 30 | 220 | 135472 | 116470 | 44700 | 85977 | 20969 | 75.26% | 77.65% | 74.50% | 71.65% | 69.90% | 11 | 13453 - 74.74% | 1,048,432$ | 31,452,960$ | 18000 | 100 | 58,499,999$ | 58,499,999$ | 2,100,000$ | 35,789,990$ | 58,499,999$ | 35,426,945$ | 21 | 0 | 0$ | 11,532,752$ | 60 | 269,406$ | 16,164,360$ | 16,396,536$ | 62,089,999$ | 62,089,999$ | 63,000,000$ | 910,001$ | 54,259,765$ | 49,395,981$ |
| 16 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 170880 | 142040 | 58177 | 115482 | 23064 | 94.93% | 94.69% | 96.96% | 96.24% | 76.88% | 11 | 16988 - 94.38% | 1,171,548$ | 35,146,445$ | 18000 | 100 | 60,000,000$ | 60,000,000$ | 175,000$ | 39,805,909$ | 54,500,000$ | 38,764,816$ | 21 | 1 | 0$ | 12,887,030$ | 60 | 276,256$ | 16,575,360$ | 16,733,448$ | 55,530,000$ | 55,530,000$ | 63,000,000$ | 7,470,000$ | 69,383,154$ | 65,536,736$ |
| 17 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 179077 | 150014 | 59514 | 119868 | 23870 | 96.28% | 96.78% | 95.99% | 96.67% | 77.00% | 10 | 17172 - 95.40% | 1,185,878$ | 36,762,230$ | 18000 | 100 | 56,000,000$ | 56,000,000$ | 0$ | 34,004,103$ | 56,000,000$ | 33,641,104$ | 22 | 0 | 0$ | 11,858,784$ | 60 | 257,991$ | 15,479,460$ | 15,891,879$ | 59,035,000$ | 59,035,000$ | 63,000,000$ | 3,965,000$ | 40,661,291$ | 36,628,196$ |
| 18 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 172091 | 141423 | 57472 | 113239 | 22799 | 95.61% | 94.28% | 95.79% | 94.37% | 76.00% | 11 | 16901 - 93.89% | 1,169,893$ | 35,096,775$ | 18000 | 100 | 53,000,000$ | 53,000,000$ | 0$ | 38,871,007$ | 53,000,000$ | 38,507,996$ | 22 | 0 | 0$ | 12,868,818$ | 60 | 244,292$ | 14,657,520$ | 14,838,351$ | 54,050,000$ | 54,050,000$ | 63,000,000$ | 8,950,000$ | 32,845,403$ | 30,875,870$ |
| 19 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 20 | 190 | 174062 | 145513 | 57561 | 117023 | 28007 | 96.70% | 97.01% | 95.94% | 97.52% | 93.36% | 11 | 17406 - 96.70% | 985,795$ | 29,573,860$ | 18000 | 100 | 39,425,000$ | 39,425,000$ | 0$ | 38,229,593$ | 39,425,000$ | 37,866,529$ | 20 | 0 | 0$ | 10,843,749$ | 60 | 182,306$ | 10,938,360$ | 11,101,698$ | 40,325,000$ | 40,325,000$ | 63,000,000$ | 22,675,000$ | 17,818,415$ | 17,560,466$ |
| 20 | Utah Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 120 | 70 | 50 | 25 | 74973 | 62921 | 25017 | 50066 | 30000 | 41.65% | 41.95% | 41.70% | 41.72% | 100.00% | 11 | 8099 - 45.00% | 918,320$ | 27,549,610$ | 18000 | 100 | 31,850,000$ | 31,850,000$ | 0$ | 29,270,058$ | 31,850,000$ | 28,907,058$ | 23 | 0 | 0$ | 10,101,524$ | 60 | 147,717$ | 8,863,020$ | 9,073,020$ | 33,150,000$ | 33,150,000$ | 63,000,000$ | 29,850,000$ | 23,772,594$ | 24,801,098$ |
| 21 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 171985 | 143907 | 56733 | 115420 | 22742 | 95.55% | 95.94% | 94.56% | 96.18% | 75.81% | 11 | 17026 - 94.59% | 1,175,083$ | 35,252,475$ | 18000 | 100 | 59,450,000$ | 59,450,000$ | 350,000$ | 39,707,974$ | 59,450,000$ | 39,344,977$ | 23 | 0 | 0$ | 12,925,908$ | 60 | 273,744$ | 16,424,640$ | 16,602,552$ | 60,825,000$ | 60,825,000$ | 63,000,000$ | 2,175,000$ | 71,086,697$ | 67,410,053$ |
| 22 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 163606 | 137874 | 55982 | 110657 | 21824 | 90.89% | 91.92% | 93.30% | 92.21% | 72.75% | 11 | 16331 - 90.73% | 1,124,121$ | 33,723,635$ | 18000 | 100 | 39,650,000$ | 39,650,000$ | 0$ | 28,890,186$ | 39,650,000$ | 28,527,179$ | 23 | 0 | 0$ | 12,365,333$ | 60 | 183,333$ | 10,999,980$ | 11,348,517$ | 42,137,500$ | 42,137,500$ | 63,000,000$ | 20,862,500$ | 42,405,383$ | 43,422,199$ |