| 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 | 31325 | 37930 | 31144 | 34984 | 8000 | 65.26% | 94.83% | 77.86% | 87.46% | 100.00% | 33 | 17923 - 81.47% | 1,476,605$ | 11,812,839$ | 22000 | 100 | 94,757,860$ | 94,757,860$ | 0$ | 17,326,302$ | 94,757,860$ | 16,973,368$ | 22 | 0 | 0$ | 48,727,961$ | 98 | 813,091$ | 79,682,918$ | 79,682,918$ | 94,757,860$ | 24,157,860$ | 95,500,000$ | 742,140$ | 96,219,195$ | 65,264,238$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 35000 | 28000 | 28198 | 28000 | 7000 | 100.00% | 100.00% | 97.21% | 100.00% | 100.00% | 34 | 18028 - 99.36% | 1,282,664$ | 8,978,651$ | 18144 | 100 | 92,389,395$ | 92,389,395$ | 0$ | 16,748,860$ | 92,389,395$ | 16,395,913$ | 20 | 0 | 0$ | 43,610,591$ | 98 | 793,188$ | 77,732,424$ | 77,732,424$ | 92,389,395$ | 21,789,395$ | 95,500,000$ | 3,110,605$ | -47,563,590$ | -81,685,423$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 26876 | 20000 | 16000 | 16000 | 4000 | 55.99% | 50.00% | 50.00% | 50.00% | 50.00% | 33 | 10360 - 51.80% | 1,672,432$ | 13,379,456$ | 20000 | 100 | 76,200,084$ | 76,200,084$ | 2,500,000$ | 13,398,231$ | 76,200,084$ | 13,045,289$ | 24 | 1 | 0$ | 55,190,256$ | 98 | 657,144$ | 64,400,112$ | 64,400,112$ | 78,700,084$ | 8,100,084$ | 95,500,000$ | 16,799,916$ | 220,687,147$ | 211,477,291$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 44480 | 38617 | 35165 | 36973 | 8000 | 79.43% | 80.45% | 73.26% | 92.43% | 100.00% | 33 | 20404 - 81.62% | 1,480,796$ | 11,846,365$ | 25000 | 100 | 86,549,999$ | 86,549,999$ | 0$ | 15,205,757$ | 86,549,999$ | 14,676,347$ | 25 | 0 | 0$ | 48,866,256$ | 98 | 752,521$ | 73,747,058$ | 73,747,058$ | 86,549,999$ | 15,949,999$ | 95,500,000$ | 8,950,001$ | 68,390,276$ | 43,509,474$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 84 | 52 | 37 | 15 | 175 | 43213 | 35948 | 23898 | 31917 | 8000 | 90.03% | 89.87% | 93.56% | 99.74% | 100.00% | 33 | 17872 - 93.12% | 1,538,829$ | 12,310,633$ | 19193 | 100 | 74,660,000$ | 74,660,000$ | 620,046$ | 13,351,362$ | 74,660,000$ | 13,139,598$ | 25 | 0 | 0$ | 50,781,361$ | 98 | 637,479$ | 62,472,942$ | 62,472,942$ | 75,280,046$ | 4,680,046$ | 95,500,000$ | 20,219,954$ | 110,395,492$ | 98,703,911$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 45596 | 37981 | 33432 | 34764 | 8216 | 94.99% | 94.95% | 87.98% | 96.57% | 100.00% | 33 | 19999 - 93.99% | 1,582,553$ | 12,660,425$ | 21277 | 100 | 94,258,750$ | 94,258,750$ | 0$ | 16,491,039$ | 94,258,750$ | 16,402,800$ | 23 | 0 | 0$ | 52,224,253$ | 98 | 796,292$ | 78,036,616$ | 78,036,616$ | 94,258,750$ | 23,658,750$ | 95,500,000$ | 1,241,250$ | 102,956,000$ | 77,143,637$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 55 | 40 | 22 | 125 | 40000 | 32000 | 23216 | 23386 | 8000 | 100.00% | 100.00% | 91.43% | 73.08% | 100.00% | 33 | 15825 - 92.15% | 1,416,083$ | 11,328,667$ | 17174 | 100 | 87,944,167$ | 87,944,167$ | 0$ | 15,945,756$ | 87,944,167$ | 15,769,293$ | 25 | 0 | 0$ | 46,730,751$ | 98 | 747,430$ | 73,248,140$ | 73,248,140$ | 87,944,167$ | 17,344,167$ | 95,500,000$ | 7,555,833$ | 3,393,748$ | -23,123,641$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 44642 | 37931 | 31761 | 33945 | 9397 | 93.00% | 94.83% | 70.04% | 70.72% | 78.31% | 33 | 19710 - 81.55% | 1,553,225$ | 12,425,801$ | 24168 | 100 | 83,583,420$ | 83,583,420$ | 0$ | 15,743,289$ | 83,583,420$ | 15,655,049$ | 22 | 1 | 0$ | 51,256,429$ | 98 | 706,583$ | 69,245,134$ | 69,245,134$ | 83,583,420$ | 12,983,420$ | 95,500,000$ | 11,916,580$ | 147,076,170$ | 129,087,465$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 84 | 56 | 36 | 19 | 195 | 42690 | 35865 | 24000 | 28000 | 8000 | 97.02% | 99.63% | 100.00% | 100.00% | 100.00% | 33 | 17319 - 98.97% | 1,592,512$ | 12,740,095$ | 17500 | 100 | 82,408,307$ | 82,408,307$ | 0$ | 15,297,457$ | 82,408,307$ | 15,120,994$ | 20 | 2 | 0$ | 52,552,892$ | 98 | 700,910$ | 68,689,180$ | 68,689,180$ | 82,408,307$ | 11,808,307$ | 95,500,000$ | 13,091,693$ | 120,502,933$ | 104,366,645$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 31397 | 30875 | 24023 | 21902 | 4974 | 85.78% | 88.21% | 88.58% | 81.12% | 77.72% | 33 | 14146 - 85.66% | 1,488,672$ | 11,909,377$ | 16515 | 100 | 92,446,857$ | 92,446,857$ | 662,250$ | 16,518,164$ | 92,446,857$ | 16,165,227$ | 22 | 0 | 0$ | 49,126,180$ | 98 | 793,671$ | 77,779,758$ | 77,779,758$ | 93,109,107$ | 22,509,107$ | 95,500,000$ | 2,390,893$ | 242,879,120$ | 214,225,542$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 29912 | 22504 | 26366 | 23372 | 7787 | 80.63% | 74.76% | 87.59% | 75.57% | 85.57% | 34 | 15706 - 80.06% | 1,514,678$ | 10,602,743$ | 19618 | 100 | 85,805,000$ | 85,805,000$ | 0$ | 16,030,089$ | 85,805,000$ | 15,500,667$ | 23 | 0 | 0$ | 51,499,037$ | 98 | 746,261$ | 73,133,578$ | 73,133,578$ | 85,805,000$ | 15,205,000$ | 95,500,000$ | 9,695,000$ | 13,920,637$ | -7,713,904$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 85 | 60 | 20 | 12 | 200 | 45487 | 31133 | 34044 | 35533 | 7524 | 94.76% | 77.83% | 85.11% | 74.03% | 94.05% | 33 | 19215 - 83.54% | 1,554,526$ | 12,436,211$ | 23000 | 100 | 88,609,999$ | 88,609,999$ | 0$ | 15,712,696$ | 88,609,999$ | 15,359,749$ | 23 | 0 | 0$ | 51,299,370$ | 98 | 761,429$ | 74,620,042$ | 74,620,042$ | 88,609,999$ | 18,009,999$ | 95,500,000$ | 6,890,001$ | 150,601,603$ | 127,280,931$ |
| 13 | Mammoth | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 32000 | 30753 | 28000 | 24000 | 9686 | 100.00% | 96.10% | 100.00% | 100.00% | 71.22% | 33 | 15555 - 96.02% | 1,287,003$ | 10,296,020$ | 16200 | 100 | 93,125,000$ | 93,125,000$ | 0$ | 15,620,617$ | 93,125,000$ | 15,091,204$ | 25 | 0 | 0$ | 42,471,082$ | 98 | 807,773$ | 79,161,754$ | 79,161,754$ | 93,125,000$ | 22,525,000$ | 95,500,000$ | 2,375,000$ | 256,883,712$ | 220,193,040$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 75 | 44 | 32 | 12 | 165 | 43996 | 39482 | 28000 | 35575 | 9034 | 84.61% | 88.13% | 100.00% | 92.64% | 80.66% | 33 | 19511 - 89.50% | 1,462,140$ | 11,697,123$ | 21800 | 100 | 79,775,000$ | 79,775,000$ | 0$ | 13,998,321$ | 79,775,000$ | 13,910,081$ | 21 | 0 | 0$ | 48,250,632$ | 98 | 674,580$ | 66,108,840$ | 66,108,840$ | 79,775,000$ | 9,175,000$ | 95,500,000$ | 15,725,000$ | 43,854,829$ | 25,996,621$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 37611 | 36971 | 20434 | 27447 | 7407 | 78.36% | 92.43% | 98.24% | 85.77% | 92.59% | 33 | 16234 - 87.28% | 1,558,589$ | 12,468,715$ | 18600 | 100 | 75,944,167$ | 75,944,167$ | 4,000,000$ | 13,948,556$ | 75,944,167$ | 13,242,663$ | 22 | 0 | 0$ | 51,433,449$ | 98 | 671,800$ | 65,836,400$ | 65,836,400$ | 79,944,167$ | 9,344,167$ | 95,500,000$ | 15,555,833$ | 37,182,817$ | 22,779,866$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 38 | 14 | 200 | 43899 | 37070 | 25418 | 35052 | 7601 | 91.46% | 92.68% | 97.76% | 87.63% | 95.01% | 33 | 18630 - 92.00% | 1,547,604$ | 12,380,833$ | 20250 | 100 | 97,285,000$ | 97,285,000$ | -2,500,000$ | 17,609,109$ | 97,285,000$ | 17,167,941$ | 23 | 0 | 0$ | 51,070,936$ | 98 | 838,529$ | 82,175,842$ | 82,175,842$ | 94,785,000$ | 24,185,000$ | 95,500,000$ | 715,000$ | 119,013,770$ | 87,908,864$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 31681 | 30150 | 29787 | 25071 | 10000 | 62.36% | 68.52% | 85.59% | 78.35% | 50.00% | 33 | 15836 - 69.76% | 1,587,048$ | 12,696,387$ | 22700 | 100 | 96,301,667$ | 96,301,667$ | 0$ | 17,007,130$ | 96,301,667$ | 16,654,200$ | 22 | 0 | 0$ | 52,372,596$ | 98 | 826,064$ | 80,954,272$ | 80,954,272$ | 96,301,667$ | 25,701,667$ | 95,500,000$ | -801,667$ | 74,860,169$ | 46,278,493$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 70 | 56 | 25 | 12 | 85 | 48575 | 37014 | 32430 | 36023 | 10624 | 86.74% | 92.54% | 90.08% | 90.06% | 88.53% | 33 | 20583 - 89.49% | 1,419,057$ | 11,352,458$ | 23000 | 100 | 92,274,999$ | 92,274,999$ | -4,000,000$ | 17,271,217$ | 92,274,999$ | 16,653,565$ | 20 | 1 | 0$ | 46,828,889$ | 98 | 804,832$ | 78,873,536$ | 78,873,536$ | 88,274,999$ | 17,674,999$ | 95,500,000$ | 7,225,001$ | 156,915,011$ | 124,870,364$ |
| 19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 86 | 46 | 43 | 18 | 180 | 45239 | 38649 | 21084 | 32000 | 8000 | 94.25% | 96.62% | 99.38% | 100.00% | 100.00% | 33 | 18122 - 97.16% | 1,600,077$ | 12,800,619$ | 18652 | 100 | 88,405,500$ | 88,405,500$ | 0$ | 15,763,580$ | 88,405,500$ | 15,561,896$ | 25 | 0 | 0$ | 52,802,553$ | 98 | 758,450$ | 74,328,100$ | 74,328,100$ | 88,405,500$ | 17,805,500$ | 95,500,000$ | 7,094,500$ | 42,799$ | -21,482,748$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 25316 | 20000 | 16000 | 16000 | 4000 | 52.74% | 50.00% | 50.00% | 50.00% | 50.00% | 33 | 10165 - 50.82% | 1,636,113$ | 13,088,906$ | 20000 | 100 | 90,964,280$ | 90,964,280$ | 0$ | 16,647,058$ | 90,964,280$ | 16,117,648$ | 22 | 0 | 0$ | 53,991,737$ | 98 | 789,616$ | 77,382,368$ | 77,382,368$ | 90,964,280$ | 20,364,280$ | 95,500,000$ | 4,535,720$ | 18,337,153$ | -5,053,478$ |