| 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 76,900,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Blackhawks | 6000 | 5000 | 5000 | 5000 | 1000 | 100 | 50 | 30 | 15 | 180 | 20346 | 24789 | 20278 | 20756 | 5000 | 67.82% | 99.16% | 81.11% | 83.02% | 100.00% | 37 | 18234 - 82.88% | 1,517,932$ | 7,589,658$ | 22000 | 100 | 98,475,000$ | 98,475,000$ | 2,250,000$ | 13,190,922$ | 98,475,000$ | 12,928,855$ | 22 | 0 | 0$ | 56,163,469$ | 126 | 692,931$ | 87,309,306$ | 87,309,306$ | 100,725,000$ | 23,825,000$ | 104,000,000$ | 3,275,000$ | 75,554,096$ | 44,408,259$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 30000 | 24000 | 23816 | 24000 | 6000 | 100.00% | 100.00% | 95.79% | 100.00% | 100.00% | 36 | 17969 - 99.04% | 1,280,029$ | 7,680,176$ | 18144 | 100 | 103,005,000$ | 103,005,000$ | 0$ | 13,390,311$ | 103,005,000$ | 12,997,201$ | 23 | 0 | 0$ | 46,081,056$ | 126 | 731,069$ | 92,114,694$ | 92,114,694$ | 103,005,000$ | 26,105,000$ | 104,000,000$ | 995,000$ | -74,157,167$ | -120,190,805$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 20361 | 15000 | 12000 | 12000 | 3023 | 56.56% | 50.00% | 50.00% | 50.00% | 50.38% | 36 | 10397 - 51.99% | 1,681,049$ | 10,086,294$ | 20000 | 100 | 73,801,750$ | 73,801,750$ | 3,437,500$ | 10,063,161$ | 73,801,750$ | 9,801,094$ | 24 | 1 | 0$ | 60,517,764$ | 126 | 522,771$ | 65,869,146$ | 65,869,146$ | 77,239,250$ | 339,250$ | 104,000,000$ | 26,760,750$ | 214,553,032$ | 209,201,650$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 34550 | 28563 | 26786 | 28086 | 6000 | 82.26% | 79.34% | 74.41% | 93.62% | 100.00% | 36 | 20664 - 82.66% | 1,502,587$ | 9,015,521$ | 25000 | 100 | 85,161,727$ | 85,161,727$ | 0$ | 11,788,085$ | 85,161,727$ | 11,394,981$ | 23 | 0 | 0$ | 54,093,126$ | 126 | 608,012$ | 76,609,512$ | 76,609,512$ | 85,161,727$ | 8,261,727$ | 104,000,000$ | 18,838,273$ | 58,989,063$ | 36,472,677$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 82 | 50 | 36 | 15 | 178 | 34743 | 28213 | 19158 | 24000 | 6000 | 96.51% | 94.04% | 100.00% | 100.00% | 100.00% | 36 | 18686 - 97.36% | 1,583,688$ | 9,502,125$ | 19193 | 100 | 88,308,334$ | 88,308,334$ | 620,046$ | 11,922,125$ | 88,308,334$ | 11,660,058$ | 25 | 0 | 0$ | 57,012,750$ | 126 | 622,816$ | 78,474,816$ | 78,474,816$ | 88,928,380$ | 12,028,380$ | 104,000,000$ | 15,071,620$ | 116,197,809$ | 94,735,743$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 28459 | 24391 | 20663 | 21588 | 5135 | 94.86% | 97.56% | 87.00% | 95.95% | 100.00% | 37 | 20047 - 94.22% | 1,590,026$ | 7,950,129$ | 21277 | 100 | 103,218,333$ | 103,218,333$ | 0$ | 13,657,918$ | 103,218,333$ | 13,395,850$ | 21 | 0 | 0$ | 58,830,955$ | 126 | 725,644$ | 91,431,144$ | 91,431,144$ | 103,218,333$ | 26,318,333$ | 104,000,000$ | 781,667$ | 94,492,653$ | 61,892,464$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 58 | 36 | 16 | 130 | 25000 | 20000 | 15870 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 17174 - 100.00% | 1,438,243$ | 7,191,215$ | 17174 | 100 | 105,053,589$ | 105,053,589$ | 0$ | 13,403,224$ | 105,053,589$ | 13,245,982$ | 23 | 0 | 0$ | 53,214,991$ | 126 | 732,783$ | 92,330,658$ | 92,330,658$ | 105,053,589$ | 28,153,589$ | 104,000,000$ | -1,053,589$ | -12,883,608$ | -51,999,275$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 34020 | 27173 | 24348 | 26223 | 6978 | 94.50% | 90.58% | 71.59% | 72.84% | 77.53% | 36 | 19790 - 81.89% | 1,552,266$ | 9,313,595$ | 24168 | 100 | 103,738,778$ | 103,738,778$ | 0$ | 13,521,154$ | 103,738,778$ | 13,390,127$ | 21 | 0 | 0$ | 55,881,570$ | 126 | 722,336$ | 91,014,336$ | 91,014,336$ | 103,738,778$ | 26,838,778$ | 104,000,000$ | 261,222$ | 139,101,525$ | 103,968,759$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 90 | 60 | 40 | 20 | 225 | 28277 | 24146 | 17496 | 20360 | 5208 | 85.69% | 89.43% | 97.20% | 96.95% | 86.80% | 36 | 15915 - 90.94% | 1,543,497$ | 9,260,983$ | 17500 | 100 | 102,914,974$ | 102,914,974$ | 0$ | 13,966,656$ | 102,914,974$ | 13,573,546$ | 22 | 0 | 0$ | 55,565,898$ | 126 | 730,448$ | 92,036,448$ | 92,036,448$ | 102,914,974$ | 26,014,974$ | 104,000,000$ | 1,085,026$ | 131,323,841$ | 94,853,291$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 25185 | 23676 | 17215 | 15802 | 3807 | 91.75% | 90.19% | 84.64% | 78.03% | 79.31% | 36 | 14281 - 86.47% | 1,530,928$ | 9,185,568$ | 16515 | 100 | 102,920,857$ | 102,920,857$ | 249,750$ | 13,820,661$ | 102,920,857$ | 13,558,594$ | 23 | 0 | 0$ | 55,113,408$ | 126 | 723,592$ | 91,172,592$ | 91,172,592$ | 103,170,607$ | 26,270,607$ | 104,000,000$ | 829,393$ | 227,903,914$ | 191,844,730$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 25911 | 19568 | 23153 | 19897 | 6975 | 81.48% | 75.84% | 89.74% | 75.06% | 89.42% | 36 | 15917 - 81.14% | 1,543,196$ | 9,259,173$ | 19618 | 100 | 94,975,000$ | 94,975,000$ | -2,437,500$ | 13,344,661$ | 94,975,000$ | 12,951,551$ | 22 | 1 | 0$ | 55,555,038$ | 126 | 675,690$ | 85,136,940$ | 85,136,940$ | 92,537,500$ | 15,637,500$ | 104,000,000$ | 11,462,500$ | -3,162,173$ | -32,744,075$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 100 | 65 | 30 | 10 | 220 | 24477 | 21446 | 25302 | 28921 | 5088 | 67.99% | 71.49% | 84.34% | 80.34% | 84.80% | 36 | 17539 - 76.26% | 1,492,315$ | 8,953,887$ | 23000 | 100 | 95,150,100$ | 95,150,100$ | 5,750,000$ | 12,726,778$ | 95,150,100$ | 12,464,705$ | 22 | 0 | 0$ | 53,723,322$ | 126 | 670,001$ | 84,420,126$ | 84,420,126$ | 100,900,100$ | 24,000,100$ | 104,000,000$ | 3,099,900$ | 144,468,625$ | 113,771,821$ |
| 13 | Mammoth | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 24000 | 22962 | 20971 | 18000 | 6945 | 100.00% | 95.68% | 99.86% | 100.00% | 68.09% | 36 | 15480 - 95.55% | 1,273,318$ | 7,639,910$ | 16200 | 100 | 104,405,000$ | 104,405,000$ | -1,000,000$ | 13,956,514$ | 104,405,000$ | 13,563,414$ | 21 | 0 | 0$ | 45,839,460$ | 126 | 740,724$ | 93,331,224$ | 93,331,224$ | 103,405,000$ | 26,505,000$ | 104,000,000$ | 595,000$ | 231,734,445$ | 184,242,681$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 70 | 45 | 30 | 25 | 165 | 32462 | 29750 | 21000 | 15492 | 6975 | 83.24% | 88.54% | 100.00% | 53.79% | 83.04% | 36 | 17613 - 80.79% | 1,435,184$ | 8,611,104$ | 21800 | 100 | 102,917,917$ | 102,917,917$ | -3,000,000$ | 13,287,868$ | 102,917,917$ | 13,091,313$ | 25 | 0 | 0$ | 51,666,624$ | 126 | 720,124$ | 90,735,624$ | 90,735,624$ | 99,917,917$ | 23,017,917$ | 104,000,000$ | 4,082,083$ | 31,040,005$ | -8,028,995$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 27282 | 27765 | 15600 | 19691 | 6000 | 75.78% | 92.55% | 100.00% | 82.05% | 100.00% | 36 | 16056 - 86.32% | 1,559,105$ | 9,354,630$ | 18600 | 100 | 65,868,333$ | 65,868,333$ | 17,750,000$ | 8,779,813$ | 65,868,333$ | 8,255,678$ | 23 | 1 | 0$ | 56,127,780$ | 126 | 481,851$ | 60,713,226$ | 60,713,226$ | 83,618,333$ | 6,718,333$ | 104,000,000$ | 20,381,667$ | 43,045,480$ | 38,460,034$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 38 | 14 | 200 | 28782 | 24232 | 15939 | 22456 | 5000 | 95.94% | 96.93% | 98.09% | 89.82% | 100.00% | 37 | 19282 - 95.22% | 1,619,399$ | 8,096,997$ | 20250 | 100 | 103,156,666$ | 103,156,666$ | -11,000,000$ | 14,093,140$ | 103,156,666$ | 13,831,073$ | 20 | 1 | 0$ | 59,917,778$ | 126 | 725,218$ | 91,377,468$ | 91,377,468$ | 92,156,666$ | 15,256,666$ | 104,000,000$ | 11,843,334$ | 131,817,990$ | 100,358,300$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 23291 | 23703 | 22914 | 20186 | 7500 | 61.13% | 71.83% | 87.79% | 84.11% | 50.00% | 36 | 16266 - 71.65% | 1,603,486$ | 9,620,915$ | 22700 | 100 | 111,433,274$ | 111,433,274$ | -9,750,000$ | 14,763,672$ | 111,433,274$ | 14,632,630$ | 24 | 0 | 0$ | 57,725,490$ | 126 | 775,402$ | 97,700,652$ | 97,700,652$ | 101,683,274$ | 24,783,274$ | 104,000,000$ | 2,316,726$ | 29,590,405$ | -10,384,757$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 65 | 55 | 25 | 10 | 85 | 35729 | 25477 | 25051 | 28020 | 7790 | 85.07% | 84.92% | 92.78% | 93.40% | 86.56% | 36 | 20345 - 88.45% | 1,375,960$ | 8,255,762$ | 23000 | 100 | 105,008,749$ | 105,008,749$ | -2,000,000$ | 14,127,920$ | 105,008,749$ | 13,669,298$ | 22 | 0 | 0$ | 49,534,572$ | 126 | 748,336$ | 94,290,336$ | 94,290,336$ | 103,008,749$ | 26,108,749$ | 104,000,000$ | 991,251$ | 148,370,243$ | 103,614,479$ |
| 19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 81 | 43 | 42 | 17 | 190 | 34469 | 28931 | 15894 | 23833 | 6000 | 95.75% | 96.44% | 99.89% | 99.30% | 100.00% | 36 | 18188 - 97.51% | 1,551,768$ | 9,310,609$ | 18652 | 100 | 102,950,000$ | 102,950,000$ | 0$ | 13,895,866$ | 102,950,000$ | 13,653,445$ | 22 | 0 | 0$ | 55,863,654$ | 126 | 722,759$ | 91,067,634$ | 91,067,634$ | 102,950,000$ | 26,050,000$ | 104,000,000$ | 1,050,000$ | -5,537,155$ | -40,741,135$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 19324 | 15000 | 12000 | 12000 | 3019 | 53.68% | 50.00% | 50.00% | 50.00% | 50.32% | 36 | 10224 - 51.12% | 1,648,461$ | 9,890,768$ | 20000 | 100 | 96,314,280$ | 96,314,280$ | 0$ | 13,006,699$ | 96,314,280$ | 12,613,589$ | 20 | 1 | 0$ | 59,344,608$ | 126 | 684,926$ | 86,300,676$ | 86,300,676$ | 96,314,280$ | 19,414,280$ | 104,000,000$ | 7,685,720$ | 14,702,085$ | -12,253,983$ |