| 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 | Revenus | Dépenses | Éstimation | Total de l'Équipe Éstimé | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | É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 - % | Revenus Moyen par Match | Revenus Annuels à ce Jour | Capacité de l'Aréna | Popularité de l'Équipe | Salaire Total des Joueurs | Salaire Total Moyen des Joueurs | Valeur du Cap Salarial Spécial | Dépenses Annuelles à Ce Jour | Cap Salarial Par Jour | Cap salarial à ce jour | Joueurs Inclut dans la Cap Salariale | Joueurs Exclut dans la Cap Salariale | Taxe de Luxe Totale | Revenus de la Saison Éstimés | Jours Restants de la Saison | Dépenses Par Jour | Dépenses de la Saison Éstimées | Dépenses de la Saison Éstimées | Cap Salarial de la Saison Éstimé | Au dessus du Plafond Salarial Minimum of 56,000,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
| 1 | ANAHEIM Ducks | 6000 | 5000 | 2000 | 5000 | 1000 | 195 | 190 | 185 | 180 | 225 | 12582 | 9540 | 3330 | 8000 | 3702 | 52.43% | 47.70% | 41.63% | 40.00% | 92.55% | 36 | 9289 - 48.89% | 2,504,282$ | 10,017,126$ | 19000 | 100 | 89,400,000$ | 89,400,000$ | 0$ | 8,862,610$ | 89,400,000$ | 8,852,700$ | 22 | 0 | 0$ | 90,154,134$ | 100 | 805,405$ | 80,540,500$ | 81,192,298$ | 89,400,000$ | 33,400,000$ | 89,650,000$ | 250,000$ | 219,804,089$ | 228,765,925$ |
| 2 | ARIZONA Coyotes | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 55 | 45 | 30 | 180 | 23195 | 20000 | 8000 | 20000 | 3920 | 96.65% | 100.00% | 100.00% | 100.00% | 98.00% | 36 | 18779 - 98.84% | 1,698,603$ | 6,794,410$ | 19000 | 100 | 62,850,000$ | 62,850,000$ | 0$ | 6,237,836$ | 62,850,000$ | 6,235,133$ | 23 | 0 | 0$ | 61,149,690$ | 100 | 566,216$ | 56,621,600$ | 58,338,854$ | 62,850,000$ | 6,850,000$ | 89,650,000$ | 26,800,000$ | 145,843,050$ | 148,653,886$ |
| 3 | BOSTON Bruins | 6000 | 5000 | 2000 | 5000 | 1000 | 95 | 70 | 55 | 40 | 190 | 29794 | 25000 | 9945 | 25000 | 4939 | 99.31% | 100.00% | 99.45% | 100.00% | 98.78% | 35 | 18936 - 99.66% | 1,978,428$ | 9,892,141$ | 19000 | 100 | 56,570,000$ | 56,570,000$ | 0$ | 5,543,423$ | 56,570,000$ | 5,539,820$ | 23 | 0 | 0$ | 69,244,987$ | 100 | 509,640$ | 50,964,000$ | 53,611,764$ | 56,570,000$ | 570,000$ | 89,650,000$ | 33,080,000$ | 199,504,146$ | 215,137,369$ |
| 4 | CALGARY Flames | 6000 | 5000 | 2000 | 5000 | 1000 | 115 | 90 | 60 | 55 | 250 | 23164 | 19667 | 7919 | 20000 | 2944 | 96.52% | 98.34% | 98.99% | 100.00% | 73.60% | 36 | 18424 - 96.97% | 2,360,761$ | 9,443,042$ | 19000 | 100 | 78,200,000$ | 78,200,000$ | 0$ | 7,760,365$ | 78,200,000$ | 7,749,555$ | 22 | 0 | 0$ | 84,987,378$ | 100 | 704,505$ | 70,450,500$ | 72,147,566$ | 78,200,000$ | 22,200,000$ | 89,650,000$ | 11,450,000$ | 77,031,077$ | 89,870,889$ |
| 5 | CAROLINA Huricanes | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 63 | 37 | 33 | 240 | 23872 | 20000 | 7982 | 20000 | 3152 | 99.47% | 100.00% | 99.78% | 100.00% | 78.80% | 36 | 18752 - 98.69% | 1,825,524$ | 7,302,095$ | 19000 | 100 | 79,270,000$ | 79,020,000$ | 0$ | 7,860,539$ | 79,270,000$ | 7,848,827$ | 22 | 0 | 0$ | 65,718,855$ | 100 | 714,144$ | 71,414,400$ | 72,111,180$ | 79,270,000$ | 23,270,000$ | 89,650,000$ | 10,380,000$ | 11,513,197$ | 5,120,872$ |
| 6 | CHICAGO Blackhawks | 6000 | 5000 | 2000 | 5000 | 1000 | 150 | 130 | 110 | 105 | 250 | 17658 | 13468 | 5657 | 12372 | 2748 | 73.58% | 67.34% | 70.71% | 61.86% | 68.70% | 36 | 12976 - 68.29% | 2,452,755$ | 9,811,018$ | 19000 | 100 | 71,540,000$ | 71,540,000$ | 0$ | 7,126,491$ | 71,540,000$ | 7,116,581$ | 22 | 0 | 0$ | 88,299,162$ | 100 | 644,505$ | 64,450,500$ | 66,145,312$ | 71,540,000$ | 15,540,000$ | 89,650,000$ | 18,110,000$ | 101,130,451$ | 123,284,301$ |
| 7 | COLORADO Avalanche | 6000 | 5000 | 2000 | 5000 | 1000 | 175 | 170 | 165 | 125 | 200 | 14488 | 10538 | 3780 | 10960 | 3760 | 60.37% | 52.69% | 47.25% | 54.80% | 94.00% | 36 | 10882 - 57.27% | 2,475,396$ | 9,901,584$ | 19000 | 100 | 83,025,000$ | 83,025,000$ | 0$ | 8,255,631$ | 83,025,000$ | 8,248,424$ | 21 | 0 | 0$ | 89,114,256$ | 100 | 747,973$ | 74,797,300$ | 76,584,232$ | 83,025,000$ | 27,025,000$ | 89,650,000$ | 6,625,000$ | 81,473,018$ | 94,003,042$ |
| 8 | DETROIT Red Wings | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 100 | 90 | 79 | 250 | 22985 | 18947 | 7424 | 18381 | 2843 | 95.77% | 94.74% | 92.80% | 91.91% | 71.08% | 36 | 17645 - 92.87% | 2,659,592$ | 10,638,368$ | 19000 | 100 | 69,715,000$ | 66,965,000$ | 0$ | 6,913,198$ | 69,715,000$ | 6,908,693$ | 21 | 0 | 0$ | 95,745,312$ | 100 | 628,063$ | 62,806,300$ | 64,741,604$ | 69,715,000$ | 13,715,000$ | 89,650,000$ | 19,935,000$ | 191,074,217$ | 222,077,925$ |
| 9 | EDMONTON Oilers | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 105 | 94 | 78 | 220 | 23159 | 18775 | 7488 | 18385 | 3670 | 96.50% | 93.88% | 93.60% | 91.93% | 91.75% | 36 | 17869 - 94.05% | 2,734,043$ | 10,936,173$ | 19000 | 100 | 89,290,000$ | 89,290,000$ | 0$ | 8,860,266$ | 89,290,000$ | 8,848,554$ | 22 | 0 | 0$ | 98,425,557$ | 100 | 804,414$ | 80,441,400$ | 81,996,856$ | 89,290,000$ | 33,290,000$ | 89,650,000$ | 360,000$ | 153,382,891$ | 169,811,592$ |
| 10 | LOS ANGELES Kings | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 100 | 90 | 79 | 250 | 23203 | 19266 | 7614 | 18704 | 2949 | 96.68% | 96.33% | 95.18% | 93.52% | 73.73% | 36 | 17934 - 94.39% | 2,704,485$ | 10,817,941$ | 19000 | 100 | 87,950,000$ | 87,950,000$ | 0$ | 8,727,474$ | 87,950,000$ | 8,715,762$ | 21 | 0 | 0$ | 97,361,469$ | 100 | 792,342$ | 79,234,200$ | 80,672,742$ | 87,950,000$ | 31,950,000$ | 89,650,000$ | 1,700,000$ | 51,078,769$ | 67,767,496$ |
| 11 | MINNESOTA Wild | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 60 | 40 | 30 | 200 | 23769 | 20000 | 8000 | 20000 | 3773 | 99.04% | 100.00% | 100.00% | 100.00% | 94.33% | 36 | 18886 - 99.40% | 1,838,025$ | 7,352,100$ | 19000 | 100 | 87,700,000$ | 87,700,000$ | 0$ | 8,801,805$ | 87,700,000$ | 8,799,102$ | 22 | 0 | 0$ | 66,168,900$ | 100 | 790,090$ | 79,009,000$ | 80,222,730$ | 87,700,000$ | 31,700,000$ | 89,650,000$ | 1,950,000$ | 1,579,003$ | -12,474,827$ |
| 12 | MONTREAL Canadiens | 6000 | 5000 | 2000 | 5000 | 1000 | 96 | 69 | 49 | 36 | 193 | 23175 | 19910 | 8000 | 20000 | 3867 | 96.56% | 99.55% | 100.00% | 100.00% | 96.68% | 36 | 18738 - 98.62% | 1,909,923$ | 7,639,690$ | 19000 | 100 | 87,982,858$ | 87,982,858$ | 0$ | 8,724,424$ | 87,982,858$ | 8,719,018$ | 21 | 0 | 0$ | 68,757,210$ | 100 | 792,638$ | 79,263,800$ | 80,954,104$ | 87,982,858$ | 31,982,858$ | 89,650,000$ | 1,667,142$ | 52,293,999$ | 40,097,105$ |
| 13 | NASHVILLE Predators | 6000 | 5000 | 2000 | 5000 | 1000 | 130 | 90 | 80 | 50 | 225 | 22638 | 19465 | 7803 | 20000 | 3733 | 94.33% | 97.33% | 97.54% | 100.00% | 93.33% | 36 | 18410 - 96.89% | 2,505,634$ | 10,022,537$ | 19000 | 100 | 84,315,000$ | 83,890,000$ | 0$ | 8,341,130$ | 84,315,000$ | 8,328,518$ | 22 | 0 | 0$ | 90,202,833$ | 100 | 759,595$ | 75,959,500$ | 77,128,346$ | 84,315,000$ | 28,315,000$ | 89,650,000$ | 5,335,000$ | 72,844,134$ | 85,918,621$ |
| 14 | NEW JERSEY Devils | 6000 | 5000 | 2000 | 5000 | 1000 | 115 | 95 | 80 | 65 | 205 | 23646 | 19588 | 7915 | 19791 | 3818 | 98.53% | 97.94% | 98.94% | 98.96% | 95.45% | 36 | 18690 - 98.37% | 2,548,859$ | 10,195,437$ | 19000 | 100 | 59,050,000$ | 59,050,000$ | 0$ | 5,863,964$ | 59,050,000$ | 5,852,252$ | 20 | 0 | 0$ | 91,758,933$ | 100 | 531,982$ | 53,198,200$ | 54,470,436$ | 59,050,000$ | 3,050,000$ | 89,650,000$ | 30,600,000$ | 90,803,374$ | 128,091,871$ |
| 15 | NEW YORK Islanders | 6000 | 5000 | 2000 | 5000 | 1000 | 150 | 135 | 120 | 100 | 200 | 21825 | 16674 | 6151 | 17131 | 4699 | 72.75% | 66.70% | 61.51% | 68.52% | 93.98% | 35 | 13296 - 69.98% | 2,496,413$ | 12,482,064$ | 19000 | 100 | 82,550,000$ | 82,666,667$ | 0$ | 8,192,345$ | 82,550,000$ | 8,180,634$ | 23 | 0 | 0$ | 87,374,448$ | 100 | 743,694$ | 74,369,400$ | 75,852,924$ | 82,550,000$ | 26,550,000$ | 89,650,000$ | 7,100,000$ | 119,118,244$ | 130,639,768$ |
| 16 | NEW YORK Rangers | 6000 | 5000 | 2000 | 5000 | 1000 | 150 | 120 | 95 | 94 | 300 | 17382 | 15547 | 7782 | 13681 | 2486 | 72.43% | 77.74% | 97.28% | 68.41% | 62.15% | 36 | 14220 - 74.84% | 2,535,416$ | 10,141,663$ | 19000 | 100 | 87,865,000$ | 87,865,000$ | 0$ | 8,717,256$ | 87,865,000$ | 8,707,347$ | 22 | 0 | 0$ | 91,274,967$ | 100 | 791,577$ | 79,157,700$ | 80,281,564$ | 87,865,000$ | 31,865,000$ | 89,650,000$ | 1,785,000$ | 64,095,498$ | 75,088,901$ |
| 17 | OTTAWA Senators | 6000 | 5000 | 2000 | 5000 | 1000 | 95 | 94 | 90 | 89 | 190 | 23434 | 19422 | 7771 | 14985 | 3800 | 97.64% | 97.11% | 97.14% | 74.93% | 95.00% | 36 | 17353 - 91.33% | 2,382,434$ | 9,529,734$ | 19000 | 100 | 73,900,000$ | 73,900,000$ | 0$ | 7,326,128$ | 73,900,000$ | 7,323,426$ | 22 | 0 | 0$ | 85,767,606$ | 100 | 665,766$ | 66,576,600$ | 68,107,262$ | 73,900,000$ | 17,900,000$ | 89,650,000$ | 15,750,000$ | 52,867,822$ | 70,528,166$ |
| 18 | PHILADELPHIA Flyers | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 105 | 93 | 79 | 220 | 23282 | 19358 | 7508 | 19125 | 3754 | 97.01% | 96.79% | 93.85% | 95.63% | 93.85% | 36 | 18257 - 96.09% | 2,792,244$ | 11,168,974$ | 19000 | 100 | 88,935,000$ | 88,935,000$ | 0$ | 8,802,161$ | 88,935,000$ | 8,764,323$ | 22 | 0 | 0$ | 100,520,766$ | 100 | 801,216$ | 80,121,600$ | 81,065,634$ | 88,935,000$ | 32,935,000$ | 89,650,000$ | 715,000$ | 149,124,799$ | 168,579,931$ |
| 19 | PITTSBURGH Penguins | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 100 | 90 | 75 | 250 | 23006 | 18697 | 7653 | 19042 | 2738 | 95.86% | 93.49% | 95.66% | 95.21% | 68.45% | 36 | 17784 - 93.60% | 2,641,405$ | 10,565,618$ | 19000 | 100 | 62,700,000$ | 62,450,000$ | 0$ | 6,307,209$ | 62,700,000$ | 6,295,497$ | 22 | 0 | 0$ | 95,090,562$ | 100 | 564,865$ | 56,486,500$ | 58,388,092$ | 62,700,000$ | 6,700,000$ | 89,650,000$ | 26,950,000$ | 44,269,150$ | 80,971,620$ |
| 20 | ST-LOUIS Blues | 6000 | 5000 | 2000 | 5000 | 1000 | 140 | 120 | 95 | 70 | 200 | 18970 | 15906 | 7602 | 19671 | 3754 | 79.04% | 79.53% | 95.03% | 98.36% | 93.85% | 36 | 16476 - 86.71% | 2,595,068$ | 10,380,272$ | 19000 | 100 | 86,625,000$ | 86,625,000$ | 0$ | 8,589,861$ | 86,625,000$ | 8,585,356$ | 21 | 0 | 0$ | 93,422,448$ | 100 | 780,405$ | 78,040,500$ | 79,002,566$ | 86,625,000$ | 30,625,000$ | 89,650,000$ | 3,025,000$ | 140,337,640$ | 154,757,522$ |
| 21 | TAMPA BAY Lightning | 6000 | 5000 | 2000 | 5000 | 1000 | 165 | 130 | 115 | 110 | 335 | 14908 | 13988 | 5611 | 11838 | 2254 | 62.12% | 69.94% | 70.14% | 59.19% | 56.35% | 36 | 12150 - 63.95% | 2,443,278$ | 9,773,113$ | 19000 | 100 | 88,190,000$ | 88,190,000$ | 0$ | 8,832,798$ | 88,190,000$ | 8,820,185$ | 21 | 0 | 0$ | 87,958,017$ | 100 | 794,505$ | 79,450,500$ | 80,947,450$ | 88,190,000$ | 32,190,000$ | 89,650,000$ | 1,460,000$ | 92,908,584$ | 99,919,151$ |
| 22 | TORONTO Maple Leafs | 6000 | 5000 | 2000 | 5000 | 1000 | 195 | 190 | 185 | 180 | 225 | 12954 | 9420 | 3295 | 8000 | 3852 | 53.98% | 47.10% | 41.19% | 40.00% | 96.30% | 36 | 9380 - 49.37% | 2,531,237$ | 10,124,947$ | 19000 | 100 | 71,600,000$ | 71,600,000$ | 0$ | 7,101,801$ | 71,600,000$ | 7,095,495$ | 23 | 0 | 0$ | 91,124,523$ | 100 | 645,045$ | 64,504,500$ | 66,217,246$ | 71,600,000$ | 15,600,000$ | 89,650,000$ | 18,050,000$ | 222,990,010$ | 247,897,287$ |
| 23 | VANCOUVER Canucks | 6000 | 5000 | 2000 | 5000 | 1000 | 129 | 85 | 65 | 42 | 225 | 22740 | 19412 | 7837 | 20000 | 3872 | 94.75% | 97.06% | 97.96% | 100.00% | 96.80% | 36 | 18465 - 97.19% | 2,381,430$ | 9,525,719$ | 19000 | 100 | 87,239,286$ | 87,239,286$ | 0$ | 8,650,744$ | 87,239,286$ | 8,645,339$ | 22 | 0 | 0$ | 85,731,471$ | 100 | 785,940$ | 78,594,000$ | 80,576,442$ | 87,239,286$ | 31,239,286$ | 89,650,000$ | 2,410,714$ | 99,807,309$ | 104,962,338$ |
| 24 | VEGAS Golden Knights | 6000 | 5000 | 2000 | 5000 | 1000 | 215 | 210 | 205 | 200 | 250 | 14753 | 10757 | 4000 | 10000 | 3630 | 49.18% | 43.03% | 40.00% | 40.00% | 72.60% | 35 | 8628 - 45.41% | 2,564,342$ | 12,821,711$ | 19000 | 100 | 57,310,000$ | 57,310,000$ | 0$ | 5,669,863$ | 57,310,000$ | 5,663,556$ | 22 | 0 | 0$ | 89,751,977$ | 100 | 516,306$ | 51,630,600$ | 54,051,396$ | 57,310,000$ | 1,310,000$ | 89,650,000$ | 32,340,000$ | 177,380,807$ | 213,081,388$ |
| 25 | WASHINGTON Capitals | 6000 | 5000 | 2000 | 5000 | 1000 | 215 | 190 | 135 | 110 | 310 | 11832 | 9175 | 4576 | 11803 | 2433 | 49.30% | 45.88% | 57.20% | 59.02% | 60.83% | 36 | 9955 - 52.39% | 2,435,108$ | 9,740,430$ | 19000 | 100 | 79,150,000$ | 79,150,000$ | 0$ | 7,911,712$ | 79,150,000$ | 7,909,009$ | 20 | 0 | 0$ | 87,663,870$ | 100 | 713,063$ | 71,306,300$ | 72,803,250$ | 79,150,000$ | 23,150,000$ | 89,650,000$ | 10,500,000$ | 71,943,775$ | 86,804,395$ |
| 26 | WINNIPEG Jets | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 70 | 55 | 40 | 190 | 23812 | 20000 | 7931 | 20000 | 3940 | 99.22% | 100.00% | 99.14% | 100.00% | 98.50% | 36 | 18921 - 99.58% | 1,934,760$ | 7,739,039$ | 19000 | 100 | 60,325,000$ | 60,325,000$ | 0$ | 5,974,094$ | 60,325,000$ | 5,971,392$ | 21 | 0 | 0$ | 69,651,351$ | 100 | 543,468$ | 54,346,800$ | 56,012,310$ | 60,325,000$ | 4,325,000$ | 89,650,000$ | 29,325,000$ | 55,470,974$ | 69,110,015$ |