| 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 | 19482 | 23832 | 19266 | 21527 | 5000 | 64.94% | 95.33% | 77.06% | 86.11% | 100.00% | 36 | 17821 - 81.01% | 1,472,324$ | 7,361,620$ | 22000 | 100 | 94,757,860$ | 94,757,860$ | 0$ | 10,821,574$ | 94,757,860$ | 10,603,088$ | 22 | 0 | 0$ | 53,003,664$ | 106 | 813,091$ | 86,187,646$ | 86,187,646$ | 94,757,860$ | 24,157,860$ | 95,500,000$ | 742,140$ | 98,272,704$ | 65,088,722$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 25000 | 20000 | 20234 | 20000 | 5000 | 100.00% | 100.00% | 97.65% | 100.00% | 100.00% | 36 | 18047 - 99.46% | 1,283,492$ | 6,417,460$ | 18144 | 100 | 83,639,395$ | 83,639,395$ | 0$ | 10,361,128$ | 83,639,395$ | 10,142,637$ | 20 | 1 | 0$ | 46,205,712$ | 106 | 719,659$ | 76,283,854$ | 76,283,854$ | 83,639,395$ | 13,039,395$ | 95,500,000$ | 11,860,605$ | -43,737,049$ | -73,815,191$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 16350 | 12500 | 10000 | 10000 | 2500 | 54.50% | 50.00% | 50.00% | 50.00% | 50.00% | 36 | 10270 - 51.35% | 1,655,763$ | 8,278,813$ | 20000 | 100 | 67,187,583$ | 67,187,583$ | 2,500,000$ | 8,101,900$ | 67,187,583$ | 7,883,414$ | 22 | 3 | 0$ | 59,607,454$ | 106 | 581,408$ | 61,629,248$ | 61,629,248$ | 69,687,583$ | -912,417$ | 95,500,000$ | 25,812,417$ | 220,882,835$ | 218,861,041$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 33165 | 29118 | 26334 | 27872 | 6000 | 78.96% | 80.88% | 73.15% | 92.91% | 100.00% | 35 | 20415 - 81.66% | 1,478,948$ | 8,873,687$ | 25000 | 100 | 86,549,999$ | 86,549,999$ | 0$ | 9,185,589$ | 86,549,999$ | 8,857,859$ | 25 | 0 | 0$ | 51,763,174$ | 106 | 752,521$ | 79,767,226$ | 79,767,226$ | 86,549,999$ | 15,949,999$ | 95,500,000$ | 8,950,001$ | 71,437,766$ | 43,433,714$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 84 | 52 | 37 | 15 | 175 | 26775 | 22379 | 14970 | 19917 | 5000 | 89.25% | 89.52% | 93.77% | 99.59% | 100.00% | 36 | 17808 - 92.78% | 1,531,855$ | 7,659,276$ | 19193 | 100 | 74,660,000$ | 74,660,000$ | 620,046$ | 8,251,530$ | 74,660,000$ | 8,120,438$ | 25 | 0 | 0$ | 55,146,787$ | 106 | 637,479$ | 67,572,774$ | 67,572,774$ | 75,280,046$ | 4,680,046$ | 95,500,000$ | 20,219,954$ | 110,843,967$ | 98,417,980$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 27915 | 23520 | 21101 | 21642 | 5135 | 93.05% | 94.08% | 88.85% | 96.19% | 100.00% | 36 | 19863 - 93.35% | 1,566,269$ | 7,831,346$ | 21277 | 100 | 94,258,750$ | 94,258,750$ | 0$ | 10,141,711$ | 94,258,750$ | 10,087,088$ | 23 | 0 | 0$ | 56,385,691$ | 106 | 796,292$ | 84,406,952$ | 84,406,952$ | 94,258,750$ | 23,658,750$ | 95,500,000$ | 1,241,250$ | 104,476,249$ | 76,454,988$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 55 | 40 | 22 | 125 | 25000 | 20000 | 14366 | 14762 | 5000 | 100.00% | 100.00% | 90.52% | 73.81% | 100.00% | 36 | 15826 - 92.15% | 1,415,322$ | 7,076,612$ | 17174 | 100 | 87,944,167$ | 87,944,167$ | 0$ | 9,966,316$ | 87,944,167$ | 9,857,077$ | 25 | 0 | 0$ | 50,951,606$ | 106 | 747,430$ | 79,227,580$ | 79,227,580$ | 87,944,167$ | 17,344,167$ | 95,500,000$ | 7,555,833$ | 5,121,133$ | -23,154,841$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 27541 | 23892 | 19954 | 21808 | 5708 | 91.80% | 95.57% | 70.41% | 72.69% | 76.11% | 36 | 19781 - 81.85% | 1,543,586$ | 7,717,931$ | 24168 | 100 | 88,583,420$ | 88,583,420$ | 0$ | 9,796,506$ | 88,583,420$ | 9,741,881$ | 23 | 0 | 0$ | 55,569,103$ | 106 | 748,600$ | 79,351,600$ | 79,351,600$ | 88,583,420$ | 17,983,420$ | 95,500,000$ | 6,916,580$ | 148,315,083$ | 124,532,586$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 84 | 56 | 36 | 19 | 195 | 26995 | 22500 | 15000 | 17500 | 5000 | 98.16% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 17399 - 99.42% | 1,601,774$ | 8,008,868$ | 17500 | 100 | 85,358,307$ | 85,358,307$ | 0$ | 9,539,140$ | 85,358,307$ | 9,429,901$ | 22 | 0 | 0$ | 57,663,850$ | 106 | 725,700$ | 76,924,200$ | 76,924,200$ | 85,358,307$ | 14,758,307$ | 95,500,000$ | 10,141,693$ | 121,280,023$ | 102,019,673$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 19290 | 19537 | 15194 | 13837 | 3134 | 84.33% | 89.31% | 89.64% | 82.00% | 78.35% | 36 | 14198 - 85.97% | 1,488,541$ | 7,442,707$ | 16515 | 100 | 90,022,857$ | 90,022,857$ | 662,250$ | 10,209,536$ | 90,022,857$ | 9,991,053$ | 20 | 0 | 0$ | 53,587,490$ | 106 | 773,301$ | 81,969,906$ | 81,969,906$ | 90,685,107$ | 20,085,107$ | 95,500,000$ | 4,814,893$ | 244,721,078$ | 216,338,662$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 21396 | 16355 | 19138 | 16871 | 5570 | 80.74% | 76.07% | 89.01% | 76.37% | 85.69% | 36 | 15866 - 80.87% | 1,525,605$ | 7,628,025$ | 19618 | 100 | 89,980,000$ | 89,980,000$ | 0$ | 10,011,263$ | 89,980,000$ | 9,683,525$ | 24 | 0 | 0$ | 54,921,780$ | 106 | 781,345$ | 82,822,570$ | 82,822,570$ | 89,980,000$ | 19,380,000$ | 95,500,000$ | 5,520,000$ | 16,864,745$ | -11,036,045$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 85 | 60 | 20 | 12 | 200 | 28941 | 19779 | 21802 | 22137 | 4712 | 96.47% | 79.12% | 87.21% | 73.79% | 94.24% | 36 | 19474 - 84.67% | 1,576,661$ | 7,883,305$ | 23000 | 100 | 88,609,999$ | 88,609,999$ | 0$ | 9,621,264$ | 88,609,999$ | 9,402,773$ | 23 | 0 | 0$ | 56,759,796$ | 106 | 761,429$ | 80,711,474$ | 80,711,474$ | 88,609,999$ | 18,009,999$ | 95,500,000$ | 6,890,001$ | 152,140,129$ | 128,188,451$ |
| 13 | Mammoth | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 20000 | 19495 | 17500 | 15000 | 5903 | 100.00% | 97.48% | 100.00% | 100.00% | 69.45% | 36 | 15580 - 96.17% | 1,285,170$ | 6,425,849$ | 16200 | 100 | 82,975,000$ | 82,975,000$ | 0$ | 9,381,961$ | 82,975,000$ | 9,054,230$ | 23 | 0 | 0$ | 46,266,113$ | 106 | 722,479$ | 76,582,774$ | 76,582,774$ | 82,975,000$ | 12,375,000$ | 95,500,000$ | 12,525,000$ | 261,530,769$ | 231,214,108$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 75 | 44 | 32 | 12 | 165 | 28197 | 24728 | 17500 | 22126 | 5541 | 86.76% | 88.31% | 100.00% | 92.19% | 79.16% | 36 | 19618 - 89.99% | 1,472,890$ | 7,364,450$ | 21800 | 100 | 79,775,000$ | 79,775,000$ | 0$ | 8,601,681$ | 79,775,000$ | 8,547,057$ | 21 | 0 | 0$ | 53,024,040$ | 106 | 674,580$ | 71,505,480$ | 71,505,480$ | 79,775,000$ | 9,175,000$ | 95,500,000$ | 15,725,000$ | 44,918,796$ | 26,437,356$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 23192 | 23345 | 12640 | 17164 | 4642 | 77.31% | 93.38% | 97.23% | 85.82% | 92.84% | 36 | 16197 - 87.08% | 1,553,097$ | 7,765,485$ | 18600 | 100 | 75,944,167$ | 75,944,167$ | 4,000,000$ | 8,614,072$ | 75,944,167$ | 8,177,091$ | 22 | 0 | 0$ | 55,911,492$ | 106 | 671,800$ | 71,210,800$ | 71,210,800$ | 79,944,167$ | 9,344,167$ | 95,500,000$ | 15,555,833$ | 37,814,071$ | 22,514,763$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 35 | 15 | 200 | 33543 | 28096 | 19500 | 25552 | 5758 | 93.18% | 93.65% | 100.00% | 85.17% | 95.97% | 35 | 18742 - 92.55% | 1,565,896$ | 9,395,374$ | 20250 | 100 | 97,285,000$ | 97,285,000$ | -2,500,000$ | 10,900,877$ | 97,285,000$ | 10,627,773$ | 23 | 0 | 0$ | 54,806,348$ | 106 | 838,529$ | 88,884,074$ | 88,884,074$ | 94,785,000$ | 24,185,000$ | 95,500,000$ | 715,000$ | 122,736,543$ | 88,658,817$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 19495 | 18919 | 19088 | 15845 | 6250 | 61.40% | 68.80% | 87.76% | 79.23% | 50.00% | 36 | 15919 - 70.13% | 1,585,247$ | 7,926,234$ | 22700 | 100 | 95,407,500$ | 95,407,500$ | 0$ | 10,398,618$ | 95,407,500$ | 10,180,136$ | 21 | 1 | 0$ | 57,068,885$ | 106 | 818,550$ | 86,766,300$ | 86,766,300$ | 95,407,500$ | 24,807,500$ | 95,500,000$ | 92,500$ | 81,698,528$ | 52,001,113$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 70 | 56 | 25 | 12 | 85 | 30837 | 22777 | 19872 | 21805 | 6564 | 88.11% | 91.11% | 88.32% | 87.22% | 87.52% | 36 | 20371 - 88.57% | 1,415,649$ | 7,078,247$ | 23000 | 100 | 94,699,999$ | 94,699,999$ | -4,000,000$ | 10,727,730$ | 94,699,999$ | 10,345,374$ | 22 | 0 | 0$ | 50,963,378$ | 106 | 825,210$ | 87,472,260$ | 87,472,260$ | 90,699,999$ | 20,099,999$ | 95,500,000$ | 4,800,001$ | 159,184,287$ | 122,675,405$ |
| 19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 86 | 46 | 43 | 18 | 180 | 23066 | 18968 | 10562 | 16000 | 4000 | 96.11% | 94.84% | 99.57% | 100.00% | 100.00% | 37 | 18149 - 97.30% | 1,608,593$ | 6,434,371$ | 18652 | 100 | 77,655,500$ | 77,655,500$ | 0$ | 9,673,294$ | 77,655,500$ | 9,595,980$ | 23 | 2 | 0$ | 59,517,932$ | 106 | 668,113$ | 70,819,978$ | 70,819,978$ | 77,655,500$ | 7,055,500$ | 95,500,000$ | 17,844,500$ | -333,163$ | -11,635,209$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 15952 | 12500 | 10000 | 10000 | 2500 | 53.17% | 50.00% | 50.00% | 50.00% | 50.00% | 36 | 10190 - 50.95% | 1,640,937$ | 8,204,685$ | 20000 | 100 | 91,964,280$ | 91,964,280$ | 0$ | 10,313,324$ | 91,964,280$ | 9,985,594$ | 23 | 0 | 0$ | 59,073,732$ | 106 | 798,019$ | 84,590,014$ | 84,590,014$ | 91,964,280$ | 21,364,280$ | 95,500,000$ | 3,535,720$ | 19,786,666$ | -5,729,616$ |