| 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 | 45738 | 53355 | 44996 | 45670 | 11000 | 69.30% | 97.01% | 81.81% | 83.04% | 100.00% | 31 | 18251 - 82.96% | 1,524,741$ | 16,772,156$ | 22000 | 100 | 86,900,000$ | 86,900,000$ | 2,250,000$ | 27,224,192$ | 86,900,000$ | 26,686,265$ | 20 | 2 | 0$ | 47,266,985$ | 106 | 613,103$ | 64,988,918$ | 64,988,918$ | 89,150,000$ | 12,250,000$ | 104,000,000$ | 14,850,000$ | 71,053,323$ | 53,331,390$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 60000 | 48000 | 46927 | 48000 | 12000 | 100.00% | 100.00% | 94.37% | 100.00% | 100.00% | 30 | 17911 - 98.71% | 1,277,403$ | 15,328,838$ | 18144 | 100 | 103,005,000$ | 103,005,000$ | 0$ | 27,928,397$ | 103,005,000$ | 27,121,490$ | 23 | 0 | 0$ | 38,322,095$ | 106 | 731,069$ | 77,493,314$ | 77,493,314$ | 103,005,000$ | 26,105,000$ | 104,000,000$ | 995,000$ | -81,046,591$ | -120,217,810$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 40493 | 30000 | 24000 | 24000 | 6069 | 56.24% | 50.00% | 50.00% | 50.00% | 50.58% | 30 | 10380 - 51.90% | 1,678,637$ | 20,143,646$ | 20000 | 100 | 73,801,750$ | 73,801,750$ | 3,437,500$ | 20,518,581$ | 73,801,750$ | 19,980,654$ | 24 | 1 | 0$ | 50,359,115$ | 106 | 522,771$ | 55,413,726$ | 55,413,726$ | 77,239,250$ | 339,250$ | 104,000,000$ | 26,760,750$ | 214,154,964$ | 209,100,353$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 61513 | 51508 | 48635 | 51273 | 11000 | 79.89% | 78.04% | 73.69% | 93.22% | 100.00% | 31 | 20357 - 81.43% | 1,475,148$ | 16,226,629$ | 25000 | 100 | 83,661,728$ | 83,661,728$ | 0$ | 23,715,217$ | 83,661,728$ | 22,908,317$ | 22 | 0 | 0$ | 45,729,591$ | 106 | 597,667$ | 63,352,702$ | 63,352,702$ | 83,661,728$ | 6,761,728$ | 104,000,000$ | 20,338,272$ | 54,773,039$ | 37,149,928$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 82 | 50 | 36 | 15 | 178 | 69076 | 55881 | 38316 | 47944 | 12000 | 95.94% | 93.14% | 100.00% | 99.88% | 100.00% | 30 | 18601 - 96.92% | 1,576,025$ | 18,912,301$ | 19193 | 100 | 88,308,334$ | 88,308,334$ | 620,046$ | 24,242,675$ | 88,308,334$ | 23,704,748$ | 25 | 0 | 0$ | 47,280,752$ | 106 | 622,816$ | 66,018,496$ | 66,018,496$ | 88,928,380$ | 12,028,380$ | 104,000,000$ | 15,071,620$ | 113,287,435$ | 94,549,691$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 61575 | 52113 | 44606 | 47738 | 11297 | 93.30% | 94.75% | 85.37% | 96.44% | 100.00% | 31 | 19757 - 92.86% | 1,564,862$ | 17,213,482$ | 21277 | 100 | 103,218,333$ | 103,218,333$ | 0$ | 28,136,315$ | 103,218,333$ | 27,598,387$ | 21 | 0 | 0$ | 48,510,722$ | 106 | 725,644$ | 76,918,264$ | 76,918,264$ | 103,218,333$ | 26,318,333$ | 104,000,000$ | 781,667$ | 89,877,609$ | 61,470,067$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 87 | 60 | 38 | 18 | 132 | 55000 | 42695 | 34519 | 44000 | 11000 | 100.00% | 97.03% | 98.87% | 100.00% | 100.00% | 31 | 17019 - 99.10% | 1,448,867$ | 15,937,535$ | 17174 | 100 | 102,053,589$ | 102,053,589$ | 0$ | 27,686,482$ | 102,053,589$ | 27,363,722$ | 22 | 0 | 0$ | 44,914,871$ | 106 | 712,094$ | 75,481,964$ | 75,481,964$ | 102,053,589$ | 25,153,589$ | 104,000,000$ | 1,946,411$ | -19,170,546$ | -49,737,639$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 61561 | 51135 | 44283 | 48152 | 12953 | 93.27% | 92.97% | 71.03% | 72.96% | 78.50% | 31 | 19826 - 82.03% | 1,554,388$ | 17,098,271$ | 24168 | 100 | 103,738,778$ | 103,738,778$ | 0$ | 27,947,186$ | 103,738,778$ | 27,678,236$ | 21 | 0 | 0$ | 48,186,036$ | 106 | 722,336$ | 76,567,616$ | 76,567,616$ | 103,738,778$ | 26,838,778$ | 104,000,000$ | 261,222$ | 132,460,169$ | 104,078,589$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 88 | 58 | 38 | 18 | 220 | 53540 | 45715 | 32307 | 37635 | 9568 | 88.50% | 92.35% | 97.90% | 97.75% | 86.98% | 31 | 16251 - 92.86% | 1,575,060$ | 17,325,661$ | 17500 | 100 | 102,914,974$ | 102,914,974$ | 0$ | 28,575,616$ | 102,914,974$ | 27,768,706$ | 22 | 0 | 0$ | 48,826,863$ | 106 | 730,448$ | 77,427,488$ | 77,427,488$ | 102,914,974$ | 26,014,974$ | 104,000,000$ | 1,085,026$ | 125,029,559$ | 96,428,934$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 49616 | 46990 | 35159 | 31595 | 7549 | 90.38% | 89.50% | 86.43% | 78.01% | 78.64% | 30 | 14242 - 86.24% | 1,520,040$ | 18,240,485$ | 16515 | 100 | 102,920,857$ | 102,920,857$ | 249,750$ | 28,225,262$ | 102,920,857$ | 27,718,367$ | 23 | 0 | 0$ | 45,601,212$ | 106 | 720,144$ | 76,335,264$ | 76,335,264$ | 103,170,607$ | 26,270,607$ | 104,000,000$ | 829,393$ | 221,119,747$ | 190,385,695$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 46779 | 36109 | 42566 | 36872 | 12672 | 80.24% | 76.34% | 89.99% | 75.87% | 88.62% | 31 | 15909 - 81.09% | 1,534,751$ | 16,882,259$ | 19618 | 100 | 101,975,000$ | 101,975,000$ | -2,437,500$ | 27,582,601$ | 101,975,000$ | 26,775,691$ | 23 | 0 | 0$ | 47,577,275$ | 106 | 723,966$ | 76,740,396$ | 76,740,396$ | 99,537,500$ | 22,637,500$ | 104,000,000$ | 4,462,500$ | -9,777,027$ | -38,940,148$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 100 | 65 | 30 | 10 | 220 | 49470 | 43242 | 50463 | 58542 | 10377 | 68.71% | 72.07% | 84.10% | 81.31% | 86.48% | 30 | 17675 - 76.85% | 1,507,381$ | 18,088,569$ | 23000 | 100 | 95,150,100$ | 95,150,100$ | 5,750,000$ | 26,126,798$ | 95,150,100$ | 25,588,865$ | 22 | 0 | 0$ | 45,221,422$ | 106 | 670,001$ | 71,020,106$ | 71,020,106$ | 100,900,100$ | 24,000,100$ | 104,000,000$ | 3,099,900$ | 140,203,287$ | 114,404,603$ |
| 13 | Mammoth | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 44000 | 42135 | 38471 | 33000 | 13136 | 100.00% | 95.76% | 99.92% | 100.00% | 70.25% | 31 | 15522 - 95.81% | 1,281,940$ | 14,101,340$ | 16200 | 100 | 102,496,667$ | 102,496,667$ | -1,000,000$ | 28,586,740$ | 102,496,667$ | 27,779,854$ | 20 | 0 | 0$ | 39,740,140$ | 106 | 727,563$ | 77,121,678$ | 77,121,678$ | 101,496,667$ | 24,596,667$ | 104,000,000$ | 2,503,333$ | 220,313,580$ | 182,932,042$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 70 | 45 | 30 | 25 | 165 | 61162 | 53567 | 38500 | 28988 | 12838 | 85.54% | 86.96% | 100.00% | 54.90% | 83.36% | 31 | 17732 - 81.34% | 1,447,985$ | 15,927,838$ | 21800 | 100 | 104,036,250$ | 104,036,250$ | -7,000,000$ | 27,691,786$ | 104,036,250$ | 27,267,650$ | 25 | 1 | 0$ | 44,887,543$ | 106 | 731,284$ | 77,516,104$ | 77,516,104$ | 97,036,250$ | 20,136,250$ | 104,000,000$ | 6,963,750$ | 22,239,372$ | -10,389,189$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 53776 | 54639 | 30461 | 40171 | 12000 | 74.69% | 91.07% | 97.63% | 83.69% | 100.00% | 30 | 15921 - 85.59% | 1,542,045$ | 18,504,534$ | 18600 | 100 | 69,033,333$ | 69,033,333$ | 21,750,000$ | 18,679,344$ | 69,033,333$ | 17,603,484$ | 24 | 0 | 0$ | 46,261,335$ | 106 | 503,678$ | 53,389,868$ | 53,389,868$ | 90,783,333$ | 13,883,333$ | 104,000,000$ | 13,216,667$ | 42,295,855$ | 35,167,322$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 38 | 14 | 200 | 67279 | 57731 | 37474 | 52120 | 12000 | 93.44% | 96.22% | 96.09% | 86.87% | 100.00% | 30 | 18884 - 93.25% | 1,592,135$ | 19,105,618$ | 20250 | 100 | 114,762,499$ | 114,762,499$ | -11,000,000$ | 30,124,445$ | 114,762,499$ | 29,586,518$ | 20 | 0 | 0$ | 47,764,045$ | 106 | 805,259$ | 85,357,454$ | 85,357,454$ | 103,762,499$ | 26,862,499$ | 104,000,000$ | 237,501$ | 127,395,306$ | 89,801,897$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 43798 | 42786 | 42492 | 37025 | 13750 | 62.70% | 70.72% | 88.80% | 84.15% | 50.00% | 31 | 16350 - 72.03% | 1,615,252$ | 17,767,774$ | 22700 | 100 | 111,433,274$ | 111,433,274$ | -9,750,000$ | 30,271,712$ | 111,433,274$ | 30,002,730$ | 24 | 0 | 0$ | 50,072,818$ | 106 | 775,402$ | 82,192,612$ | 82,192,612$ | 101,683,274$ | 24,783,274$ | 104,000,000$ | 2,316,726$ | 22,229,224$ | -9,890,570$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 65 | 55 | 25 | 10 | 85 | 64337 | 49399 | 44793 | 52198 | 13948 | 83.55% | 89.82% | 90.49% | 94.91% | 84.53% | 31 | 20425 - 88.80% | 1,351,128$ | 14,862,407$ | 23000 | 100 | 99,908,749$ | 99,908,749$ | -2,000,000$ | 28,918,780$ | 99,908,749$ | 27,977,398$ | 21 | 0 | 0$ | 41,884,965$ | 106 | 713,164$ | 75,595,384$ | 75,595,384$ | 97,908,749$ | 21,008,749$ | 104,000,000$ | 6,091,251$ | 140,186,028$ | 106,475,609$ |
| 19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 81 | 43 | 42 | 17 | 190 | 62516 | 52454 | 29038 | 43787 | 11000 | 94.72% | 95.37% | 99.54% | 99.52% | 100.00% | 31 | 18072 - 96.89% | 1,540,564$ | 16,946,206$ | 18652 | 100 | 102,950,000$ | 102,950,000$ | 0$ | 28,320,011$ | 102,950,000$ | 27,822,411$ | 22 | 0 | 0$ | 47,757,490$ | 106 | 722,759$ | 76,612,454$ | 76,612,454$ | 102,950,000$ | 26,050,000$ | 104,000,000$ | 1,050,000$ | -12,325,703$ | -41,180,667$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 36092 | 27500 | 22000 | 22000 | 5546 | 54.68% | 50.00% | 50.00% | 50.00% | 50.42% | 31 | 10285 - 51.43% | 1,660,321$ | 18,263,526$ | 20000 | 100 | 98,214,280$ | 98,214,280$ | 0$ | 26,941,091$ | 98,214,280$ | 26,134,181$ | 21 | 0 | 0$ | 51,469,937$ | 106 | 698,030$ | 73,991,180$ | 73,991,180$ | 98,214,280$ | 21,314,280$ | 104,000,000$ | 5,785,720$ | 9,140,451$ | -13,380,792$ |