| 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 | Anaheim Ducks | 5000 | 4000 | 1000 | 3000 | 1000 | 100 | 60 | 35 | 25 | 200 | 25000 | 20000 | 5000 | 15000 | 3527 | 100.00% | 100.00% | 100.00% | 100.00% | 70.54% | 37 | 13705 - 97.90% | 991,080$ | 4,955,400$ | 14000 | 100 | 38,150,000$ | 38,150,000$ | 0$ | 4,334,870$ | 38,150,000$ | 4,278,462$ | 23 | 0 | 0$ | 36,669,960$ | 173 | 198,205$ | 34,289,465$ | 36,540,329$ | 40,185,500$ | 40,185,500$ | 58,000,000$ | 17,814,500$ | 333,388$ | 463,019$ |
| 2 | Atlanta Thrashers | 5000 | 4000 | 1000 | 3000 | 1000 | 100 | 60 | 35 | 25 | 200 | 25000 | 20000 | 5000 | 15000 | 3813 | 100.00% | 100.00% | 100.00% | 100.00% | 76.26% | 37 | 13763 - 98.30% | 1,002,520$ | 5,012,600$ | 14000 | 100 | 54,500,000$ | 54,500,000$ | 0$ | 6,205,122$ | 54,500,000$ | 6,148,714$ | 20 | 0 | 0$ | 37,093,240$ | 173 | 282,051$ | 48,794,823$ | 49,864,575$ | 55,205,000$ | 55,205,000$ | 58,000,000$ | 2,795,000$ | 3,672,222$ | -9,099,113$ |
| 3 | Boston Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 28493 | 23138 | 9451 | 18395 | 3712 | 94.98% | 92.55% | 94.51% | 91.98% | 74.24% | 37 | 16638 - 92.43% | 1,154,128$ | 5,770,640$ | 18000 | 100 | 20,850,000$ | 20,850,000$ | 0$ | 2,408,714$ | 20,850,000$ | 2,352,306$ | 20 | 0 | 0$ | 42,702,736$ | 173 | 109,487$ | 18,941,251$ | 20,916,499$ | 22,575,000$ | 22,575,000$ | 58,000,000$ | 35,425,000$ | 52,114,664$ | 73,900,901$ |
| 4 | Buffalo Sabres | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 26916 | 24202 | 9076 | 18220 | 3639 | 89.72% | 96.81% | 90.76% | 91.10% | 72.78% | 37 | 16411 - 91.17% | 1,128,936$ | 5,644,680$ | 18000 | 100 | 28,167,000$ | 28,167,000$ | 0$ | 3,226,528$ | 28,167,000$ | 3,170,120$ | 21 | 0 | 0$ | 41,770,632$ | 173 | 147,010$ | 25,432,730$ | 26,697,710$ | 29,092,000$ | 29,092,000$ | 58,000,000$ | 28,908,000$ | 90,271,487$ | 105,344,409$ |
| 5 | Calgary Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 29265 | 22325 | 9411 | 18976 | 3759 | 97.55% | 89.30% | 94.11% | 94.88% | 75.18% | 37 | 16747 - 93.04% | 1,164,317$ | 5,821,585$ | 18000 | 100 | 53,750,000$ | 53,750,000$ | 350,000$ | 6,120,510$ | 53,750,000$ | 6,064,102$ | 20 | 0 | 0$ | 43,079,729$ | 173 | 278,205$ | 48,129,465$ | 49,438,989$ | 55,075,000$ | 55,075,000$ | 58,000,000$ | 2,925,000$ | 31,805,791$ | 25,446,531$ |
| 6 | Carolina Hurricanes | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 68 | 45 | 28 | 210 | 22185 | 17608 | 6468 | 14832 | 3695 | 73.95% | 70.43% | 64.68% | 74.16% | 73.90% | 37 | 12958 - 71.99% | 1,001,815$ | 5,009,075$ | 18000 | 100 | 48,000,000$ | 48,000,000$ | 0$ | 5,471,796$ | 48,000,000$ | 5,415,388$ | 20 | 0 | 0$ | 37,067,155$ | 173 | 248,718$ | 43,028,214$ | 44,532,966$ | 49,195,000$ | 49,195,000$ | 58,000,000$ | 8,805,000$ | 44,590,973$ | 37,125,162$ |
| 7 | Chicago Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 99 | 59 | 34 | 24 | 199 | 28015 | 24007 | 9678 | 19295 | 3897 | 93.38% | 96.03% | 96.78% | 96.48% | 77.94% | 37 | 16978 - 94.32% | 1,151,507$ | 5,757,533$ | 18000 | 100 | 47,125,000$ | 47,125,000$ | 665,000$ | 5,373,082$ | 47,125,000$ | 5,316,674$ | 21 | 0 | 0$ | 42,605,744$ | 173 | 244,231$ | 42,251,963$ | 43,561,487$ | 48,765,000$ | 48,765,000$ | 58,000,000$ | 9,235,000$ | 38,633,173$ | 37,677,430$ |
| 8 | Colorado Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 28442 | 22548 | 8891 | 18359 | 3910 | 94.81% | 90.19% | 88.91% | 91.80% | 78.20% | 37 | 16430 - 91.28% | 1,149,848$ | 5,749,240$ | 18000 | 100 | 50,099,998$ | 50,099,998$ | 0$ | 5,718,970$ | 50,099,998$ | 5,662,562$ | 23 | 0 | 0$ | 42,544,376$ | 173 | 259,487$ | 44,891,251$ | 46,018,771$ | 50,869,998$ | 50,869,998$ | 58,000,000$ | 7,130,002$ | 35,212,732$ | 31,738,337$ |
| 9 | Dallas Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 27632 | 24128 | 8862 | 17748 | 3745 | 92.11% | 96.51% | 88.62% | 88.74% | 74.90% | 37 | 16423 - 91.24% | 1,142,750$ | 5,713,750$ | 18000 | 100 | 51,000,000$ | 51,000,000$ | 0$ | 5,810,266$ | 51,000,000$ | 5,753,836$ | 20 | 0 | 0$ | 42,281,750$ | 173 | 264,103$ | 45,689,819$ | 47,398,673$ | 52,425,000$ | 52,425,000$ | 58,000,000$ | 5,575,000$ | 52,155,480$ | 47,038,557$ |
| 10 | Detroit Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 28268 | 24171 | 9037 | 18362 | 3975 | 94.23% | 96.68% | 90.37% | 91.81% | 79.50% | 37 | 16763 - 93.13% | 1,169,481$ | 5,847,405$ | 18000 | 100 | 56,700,000$ | 56,700,000$ | 0$ | 6,499,478$ | 56,700,000$ | 6,443,070$ | 20 | 0 | 0$ | 43,270,797$ | 173 | 293,333$ | 50,746,609$ | 51,900,751$ | 57,500,000$ | 57,500,000$ | 58,000,000$ | 500,000$ | 50,479,859$ | 41,849,905$ |
| 11 | Edmonton Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 65 | 40 | 25 | 150 | 28302 | 19438 | 6833 | 18956 | 4926 | 94.34% | 77.75% | 68.33% | 94.78% | 98.52% | 37 | 15691 - 87.17% | 1,002,750$ | 5,013,750$ | 18000 | 100 | 54,750,000$ | 54,750,000$ | 0$ | 6,233,326$ | 54,750,000$ | 6,176,918$ | 20 | 0 | 0$ | 37,101,750$ | 173 | 283,333$ | 49,016,609$ | 50,614,625$ | 56,050,000$ | 56,050,000$ | 58,000,000$ | 1,950,000$ | 26,464,002$ | 12,951,127$ |
| 12 | Hartford Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 27519 | 23399 | 8951 | 19446 | 3905 | 91.73% | 93.60% | 89.51% | 97.23% | 78.10% | 37 | 16644 - 92.47% | 1,147,255$ | 5,736,275$ | 18000 | 100 | 28,500,000$ | 28,500,000$ | 1,400,000$ | 3,271,796$ | 28,500,000$ | 3,215,388$ | 21 | 0 | 0$ | 42,448,435$ | 173 | 148,718$ | 25,728,214$ | 27,610,198$ | 31,520,000$ | 31,520,000$ | 58,000,000$ | 26,480,000$ | 85,378,840$ | 100,217,077$ |
| 13 | Minnesota Wild | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 27070 | 23997 | 9320 | 18706 | 3703 | 90.23% | 95.99% | 93.20% | 93.53% | 74.06% | 37 | 16559 - 92.00% | 1,136,254$ | 5,681,270$ | 18000 | 100 | 53,500,000$ | 53,500,000$ | 0$ | 6,092,306$ | 53,500,000$ | 6,035,898$ | 20 | 0 | 0$ | 42,041,398$ | 173 | 276,923$ | 47,907,679$ | 49,194,931$ | 54,450,000$ | 54,450,000$ | 58,000,000$ | 3,550,000$ | 53,556,165$ | 46,402,632$ |
| 14 | Montreal Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 28162 | 22834 | 9050 | 18668 | 3843 | 93.87% | 91.34% | 90.50% | 93.34% | 76.86% | 37 | 16511 - 91.73% | 1,147,658$ | 5,738,290$ | 18000 | 100 | 46,300,000$ | 46,300,000$ | 0$ | 5,226,156$ | 46,300,000$ | 5,169,748$ | 21 | 0 | 0$ | 42,463,346$ | 173 | 240,000$ | 41,520,000$ | 43,482,024$ | 48,010,000$ | 48,010,000$ | 58,000,000$ | 9,990,000$ | 60,675,680$ | 59,657,002$ |
| 15 | Nashville Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 27517 | 22945 | 9295 | 19528 | 3732 | 91.72% | 91.78% | 92.95% | 97.64% | 74.64% | 37 | 16603 - 92.24% | 1,137,665$ | 5,688,325$ | 18000 | 100 | 30,400,000$ | 30,400,000$ | 0$ | 3,486,164$ | 30,400,000$ | 3,429,734$ | 23 | 0 | 0$ | 42,093,605$ | 173 | 158,462$ | 27,413,926$ | 28,434,784$ | 31,050,000$ | 31,050,000$ | 58,000,000$ | 26,950,000$ | 48,597,005$ | 62,255,826$ |
| 16 | New York Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 28455 | 23895 | 9204 | 19105 | 3729 | 94.85% | 95.58% | 92.04% | 95.53% | 74.58% | 37 | 16878 - 93.76% | 1,164,953$ | 5,824,765$ | 18000 | 100 | 48,100,000$ | 48,100,000$ | 0$ | 5,483,082$ | 48,100,000$ | 5,426,674$ | 22 | 0 | 0$ | 43,103,261$ | 173 | 249,231$ | 43,116,963$ | 44,714,979$ | 49,400,000$ | 49,400,000$ | 58,000,000$ | 8,600,000$ | 47,892,215$ | 46,280,497$ |
| 17 | Ottawa Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 65 | 40 | 30 | 220 | 21338 | 18746 | 7057 | 12760 | 3391 | 71.13% | 74.98% | 70.57% | 63.80% | 67.82% | 37 | 12658 - 70.32% | 995,354$ | 4,976,770$ | 18000 | 100 | 46,750,000$ | 46,750,000$ | 1,750,000$ | 5,330,776$ | 46,250,000$ | 5,217,938$ | 20 | 1 | 0$ | 36,828,098$ | 173 | 242,308$ | 41,919,284$ | 43,512,776$ | 49,295,000$ | 49,295,000$ | 58,000,000$ | 8,705,000$ | 62,116,397$ | 55,431,719$ |
| 18 | Quebec Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 28934 | 23214 | 9112 | 19018 | 3794 | 96.45% | 92.86% | 91.12% | 95.09% | 75.88% | 37 | 16814 - 93.41% | 1,167,882$ | 5,839,410$ | 18000 | 100 | 52,700,000$ | 52,700,000$ | 0$ | 5,930,256$ | 49,700,000$ | 5,535,392$ | 20 | 1 | 0$ | 43,211,634$ | 173 | 272,821$ | 47,198,033$ | 48,931,421$ | 51,152,500$ | 51,152,500$ | 58,000,000$ | 6,847,500$ | 71,672,046$ | 65,952,259$ |
| 19 | Seattle Kraken | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 28644 | 24028 | 9268 | 18425 | 3680 | 95.48% | 96.11% | 92.68% | 92.13% | 73.60% | 37 | 16809 - 93.38% | 1,165,417$ | 5,827,085$ | 18000 | 100 | 55,050,000$ | 55,050,000$ | 0$ | 6,231,288$ | 55,050,000$ | 6,174,880$ | 21 | 0 | 0$ | 43,120,429$ | 173 | 284,872$ | 49,282,856$ | 50,423,600$ | 55,835,000$ | 55,835,000$ | 58,000,000$ | 2,165,000$ | 40,794,509$ | 33,491,338$ |
| 20 | Tampa Bay Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 28601 | 23929 | 9350 | 18605 | 3829 | 95.34% | 95.72% | 93.50% | 93.03% | 76.58% | 37 | 16863 - 93.68% | 1,170,803$ | 5,854,015$ | 18000 | 100 | 49,100,000$ | 49,100,000$ | 0$ | 5,590,770$ | 49,100,000$ | 5,534,362$ | 21 | 0 | 0$ | 43,319,711$ | 173 | 254,359$ | 44,004,107$ | 45,180,347$ | 49,925,000$ | 49,925,000$ | 58,000,000$ | 8,075,000$ | 33,649,167$ | 31,788,531$ |
| 21 | Toronto Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 45 | 25 | 20 | 190 | 28976 | 24142 | 9698 | 19232 | 4813 | 96.59% | 96.57% | 96.98% | 96.16% | 96.26% | 37 | 17372 - 96.51% | 989,206$ | 4,946,030$ | 18000 | 100 | 56,500,000$ | 56,500,000$ | 0$ | 6,405,136$ | 56,500,000$ | 6,348,718$ | 21 | 0 | 0$ | 36,600,622$ | 173 | 292,308$ | 50,569,284$ | 52,018,530$ | 57,632,500$ | 57,632,500$ | 58,000,000$ | 367,500$ | 15,717,536$ | 299,628$ |
| 22 | Utah Mammoth | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 120 | 70 | 50 | 25 | 12154 | 10000 | 4096 | 8088 | 5000 | 40.51% | 40.00% | 40.96% | 40.44% | 100.00% | 37 | 7868 - 43.71% | 889,384$ | 4,446,920$ | 18000 | 100 | 46,200,000$ | 46,200,000$ | 875,000$ | 5,268,714$ | 46,200,000$ | 5,212,306$ | 21 | 0 | 0$ | 32,907,208$ | 173 | 239,487$ | 41,431,251$ | 42,545,373$ | 47,830,000$ | 47,830,000$ | 58,000,000$ | 10,170,000$ | 40,109,144$ | 30,470,979$ |
| 23 | Vancouver Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 27763 | 24010 | 8790 | 18727 | 3797 | 92.54% | 96.04% | 87.90% | 93.64% | 75.94% | 37 | 16617 - 92.32% | 1,150,425$ | 5,752,125$ | 18000 | 100 | 46,750,000$ | 46,750,000$ | 0$ | 5,330,776$ | 46,750,000$ | 5,274,368$ | 20 | 0 | 0$ | 42,565,725$ | 173 | 242,308$ | 41,919,284$ | 43,961,174$ | 48,550,000$ | 48,550,000$ | 58,000,000$ | 9,450,000$ | 76,286,014$ | 74,890,565$ |
| 24 | Winnipeg Jets | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 28201 | 23813 | 9081 | 18472 | 3851 | 94.00% | 95.25% | 90.81% | 92.36% | 77.02% | 37 | 16684 - 92.69% | 1,159,743$ | 5,798,715$ | 18000 | 100 | 38,600,000$ | 38,600,000$ | 0$ | 4,372,826$ | 38,600,000$ | 4,316,413$ | 22 | 1 | 0$ | 42,910,491$ | 173 | 200,513$ | 34,688,749$ | 36,222,385$ | 39,827,500$ | 39,827,500$ | 58,000,000$ | 18,172,500$ | 44,594,252$ | 51,282,358$ |