| 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 84,600,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Anaheim Ducks | 5174 | 5000 | 2000 | 4000 | 1000 | 250 | 150 | 90 | 60 | 500 | 2849 | 2407 | 1031 | 1746 | 454 | 55.06% | 48.14% | 51.55% | 43.65% | 45.40% | 42 | 8487 - 49.42% | 2,231,796$ | 2,231,796$ | 17174 | 100 | 113,946,245$ | 113,946,245$ | 187,500$ | 3,233,538$ | 525,098$ | 3,150,588$ | 25 | 0 | 0$ | 93,735,432$ | 211 | 538,923$ | 113,712,753$ | 117,453,644$ | 114,133,766$ | 29,533,766$ | 114,500,000$ | 366,234$ | 156,954,296$ | 138,452,442$ |
| 2 | Boston Bruins | 7150 | 5000 | 2000 | 4000 | 1000 | 180 | 95 | 65 | 40 | 250 | 4269 | 4129 | 1539 | 2950 | 1000 | 59.71% | 82.58% | 76.95% | 73.75% | 100.00% | 42 | 13887 - 72.52% | 2,426,778$ | 2,426,778$ | 19150 | 100 | 111,342,857$ | 111,342,856$ | 0$ | 3,097,040$ | 513,101$ | 3,014,090$ | 23 | 0 | 0$ | 101,924,676$ | 211 | 526,926$ | 111,181,386$ | 116,120,265$ | 111,278,401$ | 26,678,401$ | 114,500,000$ | 3,221,599$ | 81,613,410$ | 71,837,229$ |
| 3 | Buffalo Sabres | 7100 | 5100 | 2000 | 4000 | 1000 | 240 | 145 | 85 | 55 | 490 | 6527 | 4981 | 2204 | 4193 | 951 | 45.96% | 48.83% | 55.10% | 52.41% | 47.55% | 41 | 9428 - 49.10% | 2,409,811$ | 4,819,621$ | 19200 | 100 | 117,666,666$ | 117,666,666$ | -3,175,000$ | 3,336,408$ | 542,243$ | 3,253,458$ | 24 | 0 | 0$ | 98,802,230$ | 211 | 556,068$ | 117,330,348$ | 121,145,016$ | 114,491,731$ | 29,891,731$ | 114,500,000$ | 8,269$ | 149,652,165$ | 132,241,439$ |
| 4 | Carolina Hurricanes | 6680 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 6470 | 5000 | 1961 | 4000 | 1000 | 96.86% | 100.00% | 98.05% | 100.00% | 100.00% | 42 | 18431 - 98.67% | 1,960,296$ | 1,960,296$ | 18680 | 100 | 86,920,000$ | 79,420,000$ | 8,750,000$ | 2,451,706$ | 365,991$ | 2,334,194$ | 26 | 1 | 0$ | 82,332,432$ | 211 | 414,378$ | 87,433,758$ | 91,711,152$ | 88,308,295$ | 3,708,295$ | 114,500,000$ | 26,191,705$ | 96,438,639$ | 92,353,893$ |
| 5 | Chicago Blackhawks | 7717 | 5000 | 2000 | 4000 | 1000 | 90 | 60 | 35 | 25 | 200 | 12974 | 9817 | 4000 | 8000 | 1931 | 84.06% | 98.17% | 100.00% | 100.00% | 96.55% | 41 | 18361 - 93.12% | 1,849,746$ | 3,699,491$ | 19717 | 100 | 113,968,333$ | 113,968,333$ | 0$ | 3,234,150$ | 525,200$ | 3,151,200$ | 23 | 0 | 0$ | 75,839,566$ | 211 | 539,025$ | 113,734,275$ | 117,087,889$ | 113,968,400$ | 29,368,400$ | 114,500,000$ | 531,600$ | 34,634,401$ | -1,920,422$ |
| 6 | Colorado Avalanche | 6007 | 5000 | 2000 | 4000 | 1000 | 150 | 80 | 55 | 30 | 290 | 5451 | 5000 | 2000 | 3862 | 943 | 90.74% | 100.00% | 100.00% | 96.55% | 94.30% | 42 | 17256 - 95.83% | 2,558,300$ | 2,558,300$ | 18007 | 100 | 108,535,920$ | 108,535,920$ | 0$ | 3,083,940$ | 500,166$ | 3,000,948$ | 22 | 1 | 0$ | 107,448,600$ | 211 | 513,990$ | 108,451,890$ | 112,018,684$ | 108,535,974$ | 23,935,974$ | 114,500,000$ | 5,964,026$ | 175,232,003$ | 175,228,369$ |
| 7 | Dallas Stars | 6532 | 5000 | 2000 | 4000 | 1000 | 185 | 120 | 90 | 60 | 500 | 4232 | 2747 | 1011 | 2128 | 503 | 64.79% | 54.94% | 50.55% | 53.20% | 50.30% | 42 | 10621 - 57.31% | 2,358,268$ | 2,358,268$ | 18532 | 100 | 108,312,000$ | 108,312,000$ | -2,138,500$ | 3,070,380$ | 499,134$ | 2,987,430$ | 23 | 0 | 0$ | 99,047,256$ | 211 | 512,959$ | 108,234,349$ | 110,981,445$ | 106,166,204$ | 21,566,204$ | 114,500,000$ | 8,333,796$ | 80,374,077$ | 73,458,174$ |
| 8 | Detroit Red Wings | 8066 | 5000 | 2000 | 4000 | 1000 | 105 | 62 | 37 | 20 | 220 | 13487 | 9820 | 4000 | 8000 | 2000 | 83.60% | 98.20% | 100.00% | 100.00% | 100.00% | 41 | 18654 - 92.96% | 2,065,866$ | 4,131,732$ | 20066 | 100 | 94,962,539$ | 91,712,539$ | 11,033,500$ | 2,664,861$ | 422,638$ | 2,522,004$ | 25 | 1 | 0$ | 84,700,506$ | 211 | 451,440$ | 95,253,840$ | 99,963,864$ | 102,732,122$ | 18,132,122$ | 114,500,000$ | 11,767,878$ | 98,137,233$ | 88,013,533$ |
| 9 | Los Angeles Kings | 7153 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 190 | 12250 | 9623 | 3981 | 8000 | 2000 | 85.63% | 96.23% | 99.53% | 100.00% | 100.00% | 41 | 17927 - 93.60% | 1,878,678$ | 3,757,355$ | 19153 | 100 | 115,221,435$ | 115,221,435$ | -2,940,000$ | 3,268,794$ | 530,974$ | 3,185,844$ | 22 | 0 | 0$ | 77,025,778$ | 211 | 544,799$ | 114,952,589$ | 117,821,114$ | 112,281,358$ | 27,681,358$ | 114,500,000$ | 2,218,642$ | 56,572,578$ | 20,813,948$ |
| 10 | Minnesota Wild | 6215 | 6074 | 2000 | 4000 | 1000 | 151 | 91 | 61 | 25 | 200 | 11626 | 8450 | 3023 | 8000 | 1983 | 93.53% | 69.56% | 75.58% | 100.00% | 99.15% | 41 | 16541 - 85.75% | 2,462,582$ | 4,925,163$ | 19289 | 100 | 113,941,190$ | 113,941,190$ | 0$ | 3,233,394$ | 525,075$ | 3,150,450$ | 23 | 0 | 0$ | 100,965,842$ | 211 | 538,899$ | 113,707,689$ | 117,566,247$ | 113,941,275$ | 29,341,275$ | 114,500,000$ | 558,725$ | 60,866,757$ | 49,237,388$ |
| 11 | Montreal Canadiens | 8273 | 6000 | 2000 | 4000 | 1000 | 150 | 90 | 60 | 30 | 300 | 6031 | 5082 | 1436 | 3832 | 754 | 72.90% | 84.70% | 71.80% | 95.80% | 75.40% | 42 | 17135 - 80.55% | 2,666,132$ | 2,666,132$ | 21273 | 100 | 109,001,857$ | 109,001,857$ | 0$ | 3,096,828$ | 502,313$ | 3,013,878$ | 24 | 0 | 0$ | 111,977,544$ | 211 | 516,138$ | 108,905,118$ | 112,365,531$ | 109,001,921$ | 24,401,921$ | 114,500,000$ | 5,498,079$ | 168,136,279$ | 172,512,533$ |
| 12 | Nashville Predators | 5113 | 5000 | 2000 | 4000 | 1000 | 180 | 95 | 65 | 45 | 320 | 4022 | 4091 | 1390 | 2677 | 709 | 78.66% | 81.82% | 69.50% | 66.93% | 70.90% | 42 | 12889 - 75.32% | 2,309,947$ | 2,309,947$ | 17113 | 100 | 108,552,500$ | 108,552,500$ | 0$ | 3,084,402$ | 500,242$ | 3,001,452$ | 22 | 0 | 0$ | 97,017,774$ | 211 | 514,067$ | 108,468,137$ | 111,336,662$ | 108,552,514$ | 23,952,514$ | 114,500,000$ | 5,947,486$ | 114,431,910$ | 105,058,102$ |
| 13 | NewYork Islanders | 4895 | 3900 | 2000 | 4000 | 1000 | 139 | 80 | 45 | 26 | 234 | 9790 | 7800 | 3719 | 7740 | 1932 | 100.00% | 100.00% | 92.98% | 96.75% | 96.60% | 41 | 15491 - 98.07% | 2,090,092$ | 4,180,184$ | 15795 | 100 | 114,300,000$ | 114,300,000$ | 0$ | 3,243,318$ | 526,728$ | 3,160,368$ | 24 | 0 | 0$ | 85,693,772$ | 211 | 540,553$ | 114,056,683$ | 118,201,362$ | 114,299,976$ | 29,699,976$ | 114,500,000$ | 200,024$ | 52,553,342$ | 25,322,800$ |
| 14 | NewYork Rangers | 5200 | 5000 | 2000 | 4000 | 1000 | 190 | 100 | 65 | 45 | 400 | 3841 | 3929 | 1567 | 2476 | 589 | 73.87% | 78.58% | 78.35% | 61.90% | 58.90% | 42 | 12402 - 72.10% | 2,341,632$ | 2,341,632$ | 17200 | 100 | 115,238,455$ | 115,238,455$ | -3,500,000$ | 3,265,235$ | 531,053$ | 3,182,286$ | 22 | 0 | 0$ | 98,348,544$ | 211 | 544,878$ | 114,969,258$ | 118,056,188$ | 111,734,469$ | 27,134,469$ | 114,500,000$ | 2,765,531$ | 119,181,201$ | 104,729,017$ |
| 15 | Ottawa Senateurs | 5039 | 4800 | 2000 | 4000 | 1000 | 100 | 50 | 30 | 20 | 280 | 5039 | 4800 | 2000 | 4000 | 1000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 42 | 16839 - 100.00% | 1,734,211$ | 1,734,211$ | 16839 | 100 | 107,533,334$ | 107,533,334$ | 0$ | 3,056,220$ | 495,545$ | 2,973,270$ | 24 | 0 | 0$ | 72,836,862$ | 211 | 509,370$ | 107,477,070$ | 111,227,993$ | 107,533,265$ | 22,933,265$ | 114,500,000$ | 6,966,735$ | 17,505,567$ | -15,386,420$ |
| 16 | Philadelphia Flyers | 7537 | 5000 | 2000 | 4000 | 1000 | 125 | 65 | 50 | 30 | 250 | 6602 | 4764 | 1937 | 3668 | 998 | 87.59% | 95.28% | 96.85% | 91.70% | 99.80% | 42 | 17969 - 91.97% | 2,371,037$ | 2,371,037$ | 19537 | 100 | 113,670,658$ | 113,670,157$ | 0$ | 3,225,918$ | 523,826$ | 3,142,956$ | 22 | 0 | 0$ | 99,583,554$ | 211 | 537,653$ | 113,444,783$ | 117,160,594$ | 113,670,242$ | 29,070,242$ | 114,500,000$ | 829,758$ | 88,464,110$ | 75,554,026$ |
| 17 | Pittsburgh Penguins | 6387 | 5000 | 2000 | 4000 | 1000 | 105 | 70 | 42 | 30 | 225 | 6291 | 4852 | 2000 | 3638 | 897 | 98.50% | 97.04% | 100.00% | 90.95% | 89.70% | 42 | 17678 - 96.14% | 2,078,788$ | 2,078,788$ | 18387 | 100 | 109,125,000$ | 104,775,000$ | 0$ | 3,100,230$ | 482,834$ | 2,897,004$ | 24 | 0 | 0$ | 87,309,096$ | 211 | 516,705$ | 109,024,755$ | 113,329,319$ | 104,774,978$ | 20,174,978$ | 114,500,000$ | 9,725,022$ | 84,002,875$ | 63,200,845$ |
| 18 | SanJose Sharks | 5562 | 5000 | 2000 | 4000 | 1000 | 130 | 80 | 55 | 38 | 218 | 11124 | 9768 | 3762 | 5874 | 1961 | 100.00% | 97.68% | 94.05% | 73.43% | 98.05% | 41 | 16245 - 92.50% | 2,298,460$ | 4,596,919$ | 17562 | 100 | 113,450,000$ | 113,250,000$ | 0$ | 3,219,816$ | 521,889$ | 3,131,334$ | 25 | 0 | 0$ | 94,236,840$ | 211 | 536,636$ | 113,230,196$ | 116,122,547$ | 113,249,913$ | 28,649,913$ | 114,500,000$ | 1,250,087$ | 153,372,620$ | 136,237,029$ |
| 19 | Seattle Kraken | 6118 | 5000 | 2000 | 4000 | 1000 | 125 | 70 | 42 | 26 | 230 | 12236 | 9492 | 3839 | 7546 | 1863 | 100.00% | 94.92% | 95.98% | 94.33% | 93.15% | 41 | 17488 - 96.52% | 2,219,999$ | 4,439,998$ | 18118 | 100 | 117,279,502$ | 117,279,502$ | -3,200,000$ | 3,325,698$ | 540,459$ | 3,242,754$ | 23 | 0 | 0$ | 91,019,959$ | 211 | 554,283$ | 116,953,713$ | 120,467,003$ | 114,079,603$ | 29,479,603$ | 114,500,000$ | 420,397$ | 135,687,312$ | 111,105,884$ |
| 20 | St-Louis Blues | 5565 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 37 | 25 | 210 | 5565 | 5000 | 1910 | 4000 | 914 | 100.00% | 100.00% | 95.50% | 100.00% | 91.40% | 42 | 17389 - 99.00% | 1,816,474$ | 1,816,474$ | 17565 | 100 | 113,098,333$ | 113,098,333$ | 0$ | 3,210,090$ | 521,190$ | 3,127,140$ | 23 | 0 | 0$ | 76,291,908$ | 211 | 535,015$ | 112,888,165$ | 115,390,104$ | 113,098,230$ | 28,498,230$ | 114,500,000$ | 1,401,770$ | 14,300,251$ | -19,309,847$ |
| 21 | Tampa Bay Lightning | 7204 | 5000 | 2000 | 4000 | 1000 | 225 | 135 | 90 | 60 | 325 | 8644 | 6000 | 2400 | 4800 | 1332 | 59.99% | 60.00% | 60.00% | 60.00% | 66.60% | 41 | 11588 - 60.34% | 2,750,391$ | 5,500,782$ | 19204 | 100 | 112,327,499$ | 112,327,499$ | -2,250,000$ | 3,188,778$ | 517,638$ | 3,105,828$ | 23 | 0 | 0$ | 112,766,031$ | 211 | 531,463$ | 112,138,693$ | 115,799,537$ | 110,077,446$ | 25,477,446$ | 114,500,000$ | 4,422,554$ | 237,935,848$ | 239,467,574$ |
| 22 | Toronto Maple Leafs | 5000 | 5000 | 2000 | 4000 | 1000 | 250 | 150 | 90 | 60 | 500 | 3204 | 2391 | 1116 | 1858 | 464 | 64.08% | 47.82% | 55.80% | 46.45% | 46.40% | 42 | 9033 - 53.14% | 2,389,319$ | 2,389,319$ | 17000 | 100 | 117,363,420$ | 117,363,420$ | -5,650,000$ | 3,328,020$ | 540,845$ | 3,245,070$ | 20 | 0 | 0$ | 100,351,398$ | 211 | 554,670$ | 117,035,370$ | 120,008,186$ | 111,713,365$ | 27,113,365$ | 114,500,000$ | 2,786,635$ | 75,845,392$ | 61,201,556$ |
| 23 | Vancouver Canucks | 6910 | 5000 | 2000 | 4000 | 1000 | 125 | 85 | 61 | 26 | 185 | 5603 | 4581 | 1660 | 3901 | 1000 | 81.09% | 91.62% | 83.00% | 97.53% | 100.00% | 42 | 16745 - 88.55% | 2,201,395$ | 2,201,395$ | 18910 | 100 | 110,375,000$ | 110,375,000$ | 0$ | 3,134,790$ | 508,641$ | 3,051,846$ | 23 | 0 | 0$ | 92,458,590$ | 211 | 522,465$ | 110,240,115$ | 113,370,726$ | 110,375,097$ | 25,775,097$ | 114,500,000$ | 4,124,903$ | 82,898,319$ | 66,886,197$ |
| 24 | Vegas Golden Knights | 5368 | 5000 | 2000 | 4000 | 1000 | 150 | 90 | 70 | 50 | 250 | 5368 | 4656 | 1262 | 2554 | 1000 | 100.00% | 93.12% | 63.10% | 63.85% | 100.00% | 42 | 14840 - 85.44% | 2,518,517$ | 2,518,517$ | 17368 | 100 | 99,200,000$ | 99,200,000$ | 0$ | 2,825,808$ | 457,143$ | 2,742,858$ | 23 | 0 | 0$ | 105,777,714$ | 211 | 470,968$ | 99,374,248$ | 102,573,620$ | 99,200,031$ | 14,600,031$ | 114,500,000$ | 15,299,969$ | 94,487,290$ | 102,710,300$ |
| 25 | Washington Capitals | 6506 | 5000 | 2000 | 4000 | 1000 | 100 | 61 | 45 | 30 | 200 | 12158 | 9612 | 3776 | 7667 | 1970 | 93.44% | 96.12% | 94.40% | 95.84% | 98.50% | 41 | 17592 - 95.06% | 1,934,066$ | 3,868,132$ | 18506 | 100 | 101,441,667$ | 98,791,667$ | 0$ | 2,869,354$ | 455,261$ | 2,713,134$ | 22 | 0 | 0$ | 79,296,706$ | 211 | 481,298$ | 101,553,878$ | 104,500,151$ | 98,773,205$ | 14,173,205$ | 114,500,000$ | 15,726,795$ | 55,234,185$ | 34,842,049$ |
| 26 | Winnipeg Jets | 5004 | 4000 | 2000 | 3000 | 1000 | 250 | 150 | 90 | 60 | 500 | 5702 | 4679 | 1989 | 4049 | 923 | 56.97% | 58.49% | 49.73% | 67.48% | 46.15% | 41 | 8671 - 57.79% | 2,243,046$ | 4,486,092$ | 15004 | 100 | 93,963,333$ | 93,963,333$ | 3,200,000$ | 2,681,016$ | 433,011$ | 2,598,066$ | 22 | 0 | 0$ | 91,964,886$ | 211 | 446,836$ | 94,282,396$ | 97,890,572$ | 97,163,387$ | 12,563,387$ | 114,500,000$ | 17,336,613$ | 42,287,933$ | 41,098,923$ |