| 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 70,600,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 | 164533 | 190590 | 158601 | 176915 | 40000 | 68.56% | 95.30% | 79.30% | 88.46% | 100.00% | 1 | 18266 - 83.03% | 1,512,147$ | 60,485,886$ | 22000 | 100 | 94,957,860$ | 94,957,860$ | 0$ | 90,626,654$ | 94,957,860$ | 88,744,298$ | 22 | 0 | 0$ | 1,512,147$ | 7 | 814,772$ | 5,703,404$ | 5,703,404$ | 94,957,860$ | 24,357,860$ | 95,500,000$ | 542,140$ | 71,791,890$ | 67,600,633$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 195000 | 156000 | 156502 | 156000 | 39000 | 100.00% | 100.00% | 96.84% | 100.00% | 100.00% | 2 | 18013 - 99.28% | 1,281,975$ | 49,997,043$ | 18144 | 100 | 91,155,000$ | 91,155,000$ | 0$ | 88,270,471$ | 91,155,000$ | 85,917,519$ | 22 | 0 | 0$ | 2,563,951$ | 7 | 791,218$ | 5,538,526$ | 5,538,526$ | 91,155,000$ | 20,555,000$ | 95,500,000$ | 4,345,000$ | -79,040,339$ | -82,014,914$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 127538 | 97500 | 78000 | 78000 | 19530 | 54.50% | 50.00% | 50.00% | 50.00% | 50.08% | 2 | 10271 - 51.35% | 1,656,259$ | 64,594,112$ | 20000 | 100 | 68,200,084$ | 68,200,084$ | 5,937,500$ | 69,015,236$ | 68,200,084$ | 67,132,882$ | 25 | 0 | 0$ | 3,312,519$ | 7 | 589,917$ | 4,129,419$ | 4,129,419$ | 74,137,584$ | 3,537,584$ | 95,500,000$ | 21,362,416$ | 214,484,798$ | 213,667,898$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 221252 | 184545 | 169408 | 184699 | 39000 | 81.04% | 78.87% | 72.40% | 94.72% | 100.00% | 2 | 20485 - 81.94% | 1,487,992$ | 58,031,676$ | 25000 | 100 | 82,946,061$ | 82,946,061$ | 0$ | 81,617,392$ | 82,946,061$ | 78,793,872$ | 23 | 0 | 0$ | 2,975,983$ | 7 | 722,236$ | 5,055,652$ | 5,055,652$ | 82,946,061$ | 12,346,061$ | 95,500,000$ | 12,553,939$ | 48,413,952$ | 46,334,283$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 82 | 50 | 36 | 15 | 178 | 212565 | 179725 | 120674 | 155528 | 39000 | 90.84% | 92.17% | 96.91% | 99.70% | 100.00% | 2 | 18141 - 94.52% | 1,548,748$ | 60,401,164$ | 19193 | 100 | 71,860,000$ | 71,860,000$ | 620,046$ | 71,894,526$ | 71,860,000$ | 70,200,408$ | 24 | 0 | 0$ | 3,097,496$ | 7 | 620,672$ | 4,344,704$ | 4,344,704$ | 72,480,046$ | 1,880,046$ | 95,500,000$ | 23,019,954$ | 99,925,800$ | 98,678,592$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 224793 | 187595 | 162171 | 173165 | 41080 | 93.66% | 93.80% | 85.35% | 96.20% | 100.00% | 1 | 19720 - 92.68% | 1,563,336$ | 62,533,437$ | 21277 | 100 | 94,258,750$ | 94,258,750$ | 0$ | 88,407,391$ | 94,258,750$ | 87,609,046$ | 23 | 0 | 0$ | 1,563,336$ | 7 | 808,897$ | 5,662,279$ | 5,662,279$ | 94,258,750$ | 23,658,750$ | 95,500,000$ | 1,241,250$ | 80,962,660$ | 76,863,717$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 58 | 36 | 16 | 130 | 199898 | 160000 | 118605 | 133581 | 40000 | 99.95% | 100.00% | 93.42% | 83.49% | 100.00% | 1 | 16302 - 94.92% | 1,422,725$ | 56,909,001$ | 17174 | 100 | 90,379,881$ | 90,379,881$ | 0$ | 84,069,123$ | 90,379,881$ | 83,127,971$ | 25 | 0 | 0$ | 1,422,725$ | 7 | 767,898$ | 5,375,286$ | 5,375,286$ | 90,379,881$ | 19,779,881$ | 95,500,000$ | 5,120,119$ | -18,799,285$ | -22,751,846$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 217737 | 185744 | 151578 | 169115 | 45814 | 93.05% | 95.25% | 68.57% | 72.27% | 78.31% | 2 | 19743 - 81.69% | 1,553,509$ | 60,586,864$ | 24168 | 100 | 75,833,420$ | 75,833,420$ | 0$ | 81,048,951$ | 75,833,420$ | 80,578,346$ | 21 | 2 | 0$ | 3,107,019$ | 7 | 641,457$ | 4,490,199$ | 4,490,199$ | 75,833,420$ | 5,233,420$ | 95,500,000$ | 19,666,580$ | 130,231,571$ | 128,848,391$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 86 | 59 | 37 | 21 | 200 | 200736 | 169565 | 115683 | 123257 | 37745 | 93.58% | 96.62% | 98.87% | 90.30% | 96.78% | 2 | 16589 - 94.80% | 1,584,535$ | 61,796,871$ | 17500 | 100 | 88,795,807$ | 88,795,807$ | 0$ | 81,991,593$ | 88,795,807$ | 81,050,420$ | 22 | 0 | 0$ | 3,169,070$ | 7 | 754,587$ | 5,282,109$ | 5,282,109$ | 88,795,807$ | 18,195,807$ | 95,500,000$ | 6,704,193$ | 102,915,573$ | 100,802,534$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 159470 | 150199 | 115556 | 107298 | 24469 | 89.38% | 88.03% | 87.40% | 81.52% | 78.43% | 2 | 14282 - 86.48% | 1,513,089$ | 59,010,452$ | 16515 | 100 | 94,451,857$ | 94,451,857$ | 662,250$ | 89,809,335$ | 94,451,857$ | 87,926,980$ | 23 | 0 | 0$ | 3,026,177$ | 7 | 810,520$ | 5,673,640$ | 5,673,640$ | 95,114,107$ | 24,514,107$ | 95,500,000$ | 385,893$ | 216,989,024$ | 214,341,561$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 167907 | 125749 | 149191 | 128334 | 44768 | 81.23% | 74.98% | 88.96% | 74.48% | 88.30% | 2 | 15794 - 80.51% | 1,531,188$ | 59,716,351$ | 19618 | 100 | 91,225,000$ | 91,225,000$ | -2,437,500$ | 86,325,366$ | 91,225,000$ | 83,501,801$ | 23 | 0 | 0$ | 3,062,377$ | 7 | 791,807$ | 5,542,649$ | 5,542,649$ | 88,787,500$ | 18,187,500$ | 95,500,000$ | 6,712,500$ | -7,161,032$ | -9,641,304$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 87 | 58 | 18 | 10 | 205 | 218422 | 171868 | 168758 | 182337 | 35771 | 93.34% | 88.14% | 86.54% | 77.92% | 91.72% | 2 | 19927 - 86.64% | 1,553,734$ | 60,595,644$ | 23000 | 100 | 83,909,999$ | 83,909,999$ | 3,500,000$ | 81,375,409$ | 83,909,999$ | 79,493,026$ | 23 | 0 | 0$ | 3,107,469$ | 7 | 721,933$ | 5,053,531$ | 5,053,531$ | 87,409,999$ | 16,809,999$ | 95,500,000$ | 8,090,001$ | 133,248,323$ | 131,302,261$ |
| 13 | Mammoth | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 160000 | 151852 | 139904 | 120000 | 47500 | 100.00% | 94.91% | 99.93% | 100.00% | 69.85% | 1 | 15481 - 95.56% | 1,277,405$ | 51,096,214$ | 16200 | 100 | 99,675,000$ | 99,675,000$ | -4,500,000$ | 91,435,154$ | 99,675,000$ | 88,611,623$ | 22 | 0 | 0$ | 1,277,405$ | 7 | 862,815$ | 6,039,705$ | 6,039,705$ | 95,175,000$ | 24,575,000$ | 95,500,000$ | 325,000$ | 221,969,369$ | 217,207,069$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 70 | 45 | 30 | 25 | 165 | 217522 | 185808 | 136413 | 159195 | 43789 | 85.81% | 85.08% | 99.94% | 85.04% | 80.20% | 2 | 19044 - 87.36% | 1,457,587$ | 56,845,884$ | 21800 | 100 | 75,188,333$ | 75,188,333$ | 0$ | 75,426,875$ | 75,188,333$ | 74,729,395$ | 21 | 0 | 0$ | 2,915,174$ | 7 | 644,440$ | 4,511,080$ | 4,511,080$ | 75,188,333$ | 4,588,333$ | 95,500,000$ | 20,311,667$ | 27,725,036$ | 26,129,130$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 178649 | 180564 | 97773 | 130926 | 36730 | 76.35% | 92.60% | 96.42% | 83.93% | 94.18% | 2 | 16016 - 86.11% | 1,542,484$ | 60,156,865$ | 18600 | 100 | 61,066,667$ | 61,066,667$ | 11,000,000$ | 65,551,764$ | 61,066,667$ | 61,787,013$ | 25 | 0 | 0$ | 3,084,967$ | 7 | 546,779$ | 3,827,453$ | 3,827,453$ | 72,066,667$ | 1,466,667$ | 95,500,000$ | 23,433,333$ | 29,467,759$ | 28,725,273$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 38 | 14 | 200 | 220386 | 185052 | 122360 | 176422 | 36956 | 94.18% | 94.90% | 96.54% | 90.47% | 94.76% | 2 | 19005 - 93.85% | 1,580,215$ | 61,628,367$ | 20250 | 100 | 100,175,000$ | 100,175,000$ | -4,750,000$ | 95,175,805$ | 100,175,000$ | 92,822,899$ | 23 | 0 | 0$ | 3,160,429$ | 7 | 862,815$ | 6,039,705$ | 6,039,705$ | 95,425,000$ | 24,825,000$ | 95,500,000$ | 75,000$ | 91,844,608$ | 88,965,332$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 158440 | 146162 | 146120 | 129138 | 48750 | 63.98% | 68.14% | 86.13% | 82.78% | 50.00% | 2 | 16118 - 71.01% | 1,606,934$ | 62,670,413$ | 22700 | 100 | 95,206,191$ | 95,206,191$ | 0$ | 90,796,600$ | 95,206,191$ | 88,914,245$ | 21 | 0 | 0$ | 3,213,867$ | 7 | 816,859$ | 5,718,013$ | 5,718,013$ | 95,206,191$ | 24,606,191$ | 95,500,000$ | 293,809$ | 29,244,725$ | 26,740,579$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 70 | 56 | 25 | 12 | 85 | 231415 | 182566 | 160433 | 181545 | 52292 | 84.77% | 93.62% | 91.41% | 93.10% | 89.39% | 2 | 20724 - 90.11% | 1,415,765$ | 55,214,826$ | 23000 | 100 | 100,499,999$ | 100,499,999$ | -8,750,000$ | 94,020,436$ | 100,499,999$ | 90,726,296$ | 21 | 0 | 0$ | 2,831,530$ | 7 | 873,950$ | 6,117,650$ | 6,117,650$ | 91,749,999$ | 21,149,999$ | 95,500,000$ | 3,750,001$ | 124,478,160$ | 121,192,040$ |
| 19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 81 | 43 | 42 | 17 | 190 | 219777 | 189059 | 103040 | 155903 | 39000 | 93.92% | 96.95% | 99.62% | 99.94% | 100.00% | 2 | 18123 - 97.16% | 1,577,831$ | 61,535,407$ | 18652 | 100 | 86,205,500$ | 86,205,500$ | 0$ | 82,453,933$ | 86,205,500$ | 80,837,517$ | 25 | 0 | 0$ | 3,155,662$ | 7 | 739,962$ | 5,179,734$ | 5,179,734$ | 86,205,500$ | 15,605,500$ | 95,500,000$ | 9,294,500$ | -17,612,766$ | -19,636,838$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 127119 | 97500 | 78000 | 78000 | 19541 | 54.32% | 50.00% | 50.00% | 50.00% | 50.11% | 2 | 10261 - 51.30% | 1,654,426$ | 64,522,626$ | 20000 | 100 | 95,164,280$ | 95,164,280$ | 0$ | 89,397,490$ | 95,164,280$ | 86,573,966$ | 23 | 0 | 0$ | 3,308,853$ | 7 | 824,910$ | 5,774,370$ | 5,774,370$ | 95,164,280$ | 24,564,280$ | 95,500,000$ | 335,720$ | -2,879,559$ | -5,345,076$ |