| 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 | Salaire total moyen 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 58,546,442$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Blackhawks | 6000 | 5000 | 5000 | 5000 | 1000 | 100 | 50 | 30 | 15 | 180 | 142058 | 163230 | 136092 | 152895 | 34000 | 69.64% | 96.02% | 80.05% | 89.94% | 100.00% | 7 | 18479 - 83.99% | 1,527,841$ | 51,946,594$ | 22000 | 100 | 77,364,167$ | 77,364,167$ | -3,000,000$ | 65,866,690$ | 77,364,167$ | 63,800,730$ | 23 | 0 | 0$ | 10,694,887$ | 25 | 554,612$ | 13,865,300$ | 13,865,300$ | 74,364,167$ | 15,817,725$ | 78,061,923$ | 3,697,756$ | 102,514,699$ | 99,344,286$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 175000 | 140000 | 138520 | 139938 | 35000 | 100.00% | 100.00% | 95.50% | 99.96% | 100.00% | 6 | 17956 - 98.96% | 1,279,470$ | 44,781,461$ | 18144 | 100 | 76,686,666$ | 76,686,666$ | 0$ | 63,180,452$ | 76,686,666$ | 61,527,661$ | 22 | 0 | 0$ | 7,676,822$ | 25 | 546,435$ | 13,660,875$ | 13,660,875$ | 76,686,666$ | 18,140,224$ | 78,061,923$ | 1,375,257$ | -39,017,963$ | -45,002,016$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 114452 | 87500 | 70000 | 70000 | 17514 | 54.50% | 50.00% | 50.00% | 50.00% | 50.04% | 6 | 10270 - 51.35% | 1,656,012$ | 57,960,404$ | 20000 | 100 | 59,124,167$ | 59,124,167$ | 2,500,000$ | 51,426,784$ | 59,124,167$ | 49,773,996$ | 25 | 0 | 0$ | 9,936,069$ | 25 | 424,473$ | 10,611,825$ | 10,611,825$ | 61,624,167$ | 3,077,725$ | 78,061,923$ | 16,437,756$ | 213,260,724$ | 212,584,968$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 185687 | 158568 | 148182 | 159386 | 34000 | 78.02% | 77.73% | 72.64% | 93.76% | 100.00% | 7 | 20171 - 80.69% | 1,456,673$ | 49,526,866$ | 25000 | 100 | 64,845,000$ | 64,845,000$ | 0$ | 55,349,207$ | 64,845,000$ | 54,109,627$ | 24 | 0 | 0$ | 10,196,708$ | 25 | 460,729$ | 11,518,225$ | 11,518,225$ | 64,845,000$ | 6,298,558$ | 78,061,923$ | 13,216,923$ | 73,076,771$ | 71,755,254$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 84 | 52 | 37 | 15 | 175 | 196597 | 163798 | 108601 | 139930 | 35000 | 93.62% | 93.60% | 97.18% | 99.95% | 100.00% | 6 | 18398 - 95.86% | 1,586,800$ | 55,538,006$ | 19193 | 100 | 52,952,333$ | 52,952,333$ | 6,245,046$ | 51,753,225$ | 52,952,333$ | 50,761,523$ | 23 | 0 | 0$ | 9,520,801$ | 25 | 376,058$ | 9,401,450$ | 9,401,450$ | 59,197,379$ | 650,937$ | 78,061,923$ | 18,864,544$ | 107,970,766$ | 108,090,117$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 193659 | 163717 | 143472 | 152248 | 35942 | 92.22% | 93.55% | 86.30% | 96.67% | 99.99% | 6 | 19687 - 92.53% | 1,554,082$ | 54,392,863$ | 21277 | 100 | 77,787,499$ | 77,787,499$ | 0$ | 65,444,282$ | 77,787,499$ | 64,617,877$ | 22 | 0 | 0$ | 9,324,491$ | 25 | 547,135$ | 13,678,375$ | 13,678,375$ | 77,787,499$ | 19,241,057$ | 78,061,923$ | 274,424$ | 101,220,050$ | 96,866,166$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 55 | 40 | 22 | 125 | 174990 | 140000 | 100881 | 105684 | 35000 | 99.99% | 100.00% | 90.81% | 75.49% | 100.00% | 6 | 15902 - 92.59% | 1,418,030$ | 49,631,062$ | 17174 | 100 | 76,700,000$ | 76,700,000$ | 0$ | 61,883,419$ | 76,700,000$ | 61,057,077$ | 25 | 0 | 0$ | 8,508,182$ | 25 | 539,583$ | 13,489,575$ | 13,489,575$ | 76,700,000$ | 18,153,558$ | 78,061,923$ | 1,361,923$ | 5,557,716$ | 576,323$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 191358 | 166839 | 136753 | 153211 | 41210 | 91.12% | 95.34% | 68.93% | 72.96% | 78.50% | 6 | 19696 - 81.50% | 1,542,484$ | 53,986,942$ | 24168 | 100 | 63,800,000$ | 63,800,000$ | 0$ | 53,221,152$ | 63,800,000$ | 51,568,369$ | 22 | 0 | 0$ | 9,254,904$ | 25 | 456,944$ | 11,423,600$ | 11,423,600$ | 63,800,000$ | 5,253,558$ | 78,061,923$ | 14,261,923$ | 147,373,328$ | 145,204,632$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 84 | 56 | 36 | 19 | 195 | 189986 | 155949 | 105000 | 122500 | 35000 | 98.69% | 99.02% | 100.00% | 100.00% | 100.00% | 6 | 17384 - 99.34% | 1,601,727$ | 56,060,457$ | 17500 | 100 | 71,579,974$ | 71,579,974$ | 0$ | 55,653,456$ | 71,579,974$ | 54,827,037$ | 21 | 1 | 0$ | 9,610,364$ | 25 | 504,028$ | 12,600,700$ | 12,600,700$ | 71,579,974$ | 13,033,532$ | 78,061,923$ | 6,481,949$ | 119,604,199$ | 116,613,863$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 138404 | 128651 | 99294 | 89961 | 21337 | 88.98% | 86.49% | 86.15% | 78.40% | 78.44% | 7 | 14048 - 85.06% | 1,503,982$ | 51,135,396$ | 16515 | 100 | 74,353,000$ | 74,353,000$ | 903,675$ | 63,098,601$ | 74,353,000$ | 61,859,069$ | 23 | 0 | 0$ | 10,527,876$ | 25 | 526,757$ | 13,168,925$ | 13,168,925$ | 75,256,675$ | 16,710,233$ | 78,061,923$ | 2,805,248$ | 236,077,540$ | 233,436,491$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 147874 | 108814 | 136234 | 114129 | 39486 | 79.72% | 72.30% | 90.52% | 73.81% | 86.78% | 6 | 15615 - 79.60% | 1,504,454$ | 52,655,886$ | 19618 | 100 | 71,966,667$ | 71,966,667$ | 0$ | 64,505,101$ | 71,966,667$ | 61,199,537$ | 23 | 0 | 0$ | 9,026,723$ | 25 | 527,546$ | 13,188,650$ | 13,188,650$ | 71,966,667$ | 13,420,225$ | 78,061,923$ | 6,095,256$ | 23,300,944$ | 19,139,017$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 85 | 60 | 20 | 12 | 200 | 189893 | 128230 | 145080 | 153911 | 31372 | 90.43% | 73.27% | 82.90% | 73.29% | 89.63% | 6 | 18528 - 80.56% | 1,499,834$ | 52,494,181$ | 23000 | 100 | 70,977,499$ | 70,977,499$ | 1,500,000$ | 65,031,119$ | 70,977,499$ | 63,378,388$ | 21 | 0 | 0$ | 8,999,002$ | 25 | 506,788$ | 12,669,700$ | 12,669,700$ | 72,477,499$ | 13,931,057$ | 78,061,923$ | 5,584,424$ | 142,240,521$ | 138,569,823$ |
| 13 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 75 | 44 | 32 | 12 | 165 | 192013 | 166918 | 122162 | 153664 | 39761 | 84.40% | 85.16% | 99.72% | 91.47% | 81.14% | 6 | 19272 - 88.40% | 1,449,944$ | 50,748,033$ | 21800 | 100 | 78,520,000$ | 78,520,000$ | -1,150,000$ | 63,090,797$ | 78,520,000$ | 62,264,429$ | 22 | 0 | 0$ | 8,699,663$ | 25 | 552,222$ | 13,805,550$ | 13,805,550$ | 77,370,000$ | 18,823,558$ | 78,061,923$ | 691,923$ | 50,444,856$ | 45,338,969$ |
| 14 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 161664 | 164052 | 89621 | 119014 | 32743 | 76.98% | 93.74% | 98.48% | 85.01% | 93.55% | 6 | 16203 - 87.11% | 1,555,324$ | 54,436,323$ | 18600 | 100 | 77,450,000$ | 77,450,000$ | -2,750,000$ | 62,391,339$ | 77,450,000$ | 59,085,767$ | 21 | 1 | 0$ | 9,331,941$ | 25 | 565,625$ | 14,140,625$ | 14,140,625$ | 74,700,000$ | 16,153,558$ | 78,061,923$ | 3,361,923$ | 38,491,007$ | 33,682,323$ |
| 15 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 35 | 15 | 200 | 191093 | 160017 | 110500 | 147747 | 31587 | 93.67% | 94.13% | 100.00% | 86.91% | 92.90% | 7 | 18851 - 93.09% | 1,564,035$ | 53,177,197$ | 20250 | 100 | 80,124,999$ | 80,124,999$ | -2,625,000$ | 65,108,333$ | 80,124,999$ | 63,042,372$ | 22 | 1 | 0$ | 10,948,246$ | 25 | 573,785$ | 14,344,625$ | 14,344,625$ | 77,499,999$ | 18,953,557$ | 78,061,923$ | 561,924$ | 109,098,143$ | 105,701,764$ |
| 16 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 146799 | 138484 | 137100 | 118628 | 43750 | 66.05% | 71.94% | 90.05% | 84.73% | 50.00% | 6 | 16707 - 73.60% | 1,656,454$ | 57,975,899$ | 22700 | 100 | 69,510,000$ | 69,510,000$ | 1,150,000$ | 57,510,323$ | 69,510,000$ | 55,857,532$ | 22 | 0 | 0$ | 9,938,726$ | 25 | 496,597$ | 12,414,925$ | 12,414,925$ | 70,660,000$ | 12,113,558$ | 78,061,923$ | 7,401,923$ | 81,178,259$ | 78,702,060$ |
| 17 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 70 | 56 | 25 | 12 | 85 | 193321 | 158261 | 139742 | 153795 | 44714 | 81.23% | 93.09% | 91.33% | 90.47% | 87.67% | 7 | 20289 - 88.21% | 1,381,969$ | 46,986,951$ | 23000 | 100 | 75,505,000$ | 75,505,000$ | -2,750,000$ | 62,525,811$ | 75,505,000$ | 59,633,480$ | 20 | 0 | 0$ | 9,673,784$ | 25 | 548,646$ | 13,716,150$ | 13,716,150$ | 72,755,000$ | 14,208,558$ | 78,061,923$ | 5,306,923$ | 162,929,538$ | 158,887,172$ |
| 18 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 86 | 46 | 43 | 18 | 180 | 194325 | 163194 | 89293 | 134522 | 34000 | 95.26% | 96.00% | 99.03% | 98.91% | 100.00% | 7 | 18098 - 97.03% | 1,603,935$ | 54,533,806$ | 18652 | 100 | 72,569,667$ | 72,569,667$ | 1,000,250$ | 63,285,739$ | 72,569,667$ | 62,376,698$ | 23 | 0 | 0$ | 11,227,548$ | 25 | 511,595$ | 12,789,875$ | 12,789,875$ | 73,569,917$ | 15,023,475$ | 78,061,923$ | 4,492,006$ | -3,662,890$ | -5,225,217$ |
| 19 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 113072 | 85000 | 68000 | 68000 | 17028 | 55.43% | 50.00% | 50.00% | 50.00% | 50.08% | 7 | 10326 - 51.63% | 1,666,618$ | 56,664,996$ | 20000 | 100 | 75,730,833$ | 75,730,833$ | 0$ | 66,017,734$ | 75,730,833$ | 63,538,601$ | 21 | 0 | 0$ | 11,666,323$ | 25 | 546,742$ | 13,668,550$ | 13,668,550$ | 75,730,833$ | 17,184,391$ | 78,061,923$ | 2,331,090$ | -7,624,897$ | -9,627,124$ |
| 20 | Utah HC | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 136000 | 126945 | 118944 | 102000 | 39637 | 100.00% | 93.34% | 99.95% | 100.00% | 68.58% | 7 | 15398 - 95.05% | 1,266,995$ | 43,077,820$ | 16200 | 100 | 77,715,000$ | 77,715,000$ | 1,500,000$ | 62,626,069$ | 77,715,000$ | 60,164,299$ | 27 | 0 | 0$ | 8,868,963$ | 25 | 560,521$ | 14,013,025$ | 14,013,025$ | 79,215,000$ | 20,668,558$ | 78,061,923$ | -1,153,077$ | 277,633,610$ | 272,489,548$ |
