| 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 | 123694 | 142683 | 118554 | 132212 | 30000 | 68.72% | 95.12% | 79.04% | 88.14% | 100.00% | 11 | 18238 - 82.90% | 1,512,020$ | 45,360,590$ | 22000 | 100 | 94,307,860$ | 94,307,860$ | 0$ | 67,506,458$ | 94,307,860$ | 66,111,501$ | 21 | 0 | 0$ | 16,632,216$ | 36 | 809,310$ | 29,135,160$ | 29,135,160$ | 94,307,860$ | 23,707,860$ | 95,500,000$ | 1,192,140$ | 79,836,790$ | 67,333,846$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 150000 | 120000 | 120721 | 120000 | 30000 | 100.00% | 100.00% | 97.11% | 100.00% | 100.00% | 11 | 18024 - 99.34% | 1,282,474$ | 38,474,231$ | 18144 | 100 | 92,080,000$ | 92,080,000$ | 0$ | 65,318,833$ | 92,080,000$ | 63,696,971$ | 23 | 0 | 0$ | 14,107,218$ | 36 | 798,992$ | 28,763,712$ | 28,763,712$ | 92,080,000$ | 21,480,000$ | 95,500,000$ | 3,420,000$ | -67,611,513$ | -82,268,007$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 99156 | 75000 | 60000 | 60000 | 15030 | 55.09% | 50.00% | 50.00% | 50.00% | 50.10% | 11 | 10306 - 51.53% | 1,662,915$ | 49,887,438$ | 20000 | 100 | 64,575,084$ | 64,575,084$ | 5,937,500$ | 52,109,130$ | 64,575,084$ | 50,714,160$ | 24 | 2 | 0$ | 18,292,061$ | 36 | 559,454$ | 20,140,344$ | 20,140,344$ | 70,512,584$ | -87,416$ | 95,500,000$ | 24,987,416$ | 216,734,230$ | 214,885,947$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 163409 | 138011 | 126523 | 136868 | 29000 | 80.50% | 79.32% | 72.71% | 94.39% | 100.00% | 12 | 20476 - 81.90% | 1,485,537$ | 43,080,574$ | 25000 | 100 | 84,521,061$ | 84,521,061$ | 0$ | 60,679,901$ | 84,521,061$ | 58,587,471$ | 23 | 1 | 0$ | 17,826,444$ | 36 | 735,471$ | 26,476,956$ | 26,476,956$ | 84,521,061$ | 13,921,061$ | 95,500,000$ | 10,978,939$ | 54,150,341$ | 45,499,829$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 82 | 50 | 36 | 15 | 178 | 163042 | 137870 | 91937 | 119528 | 30000 | 90.58% | 91.91% | 95.98% | 99.61% | 100.00% | 11 | 18079 - 94.20% | 1,549,974$ | 46,499,213$ | 19193 | 100 | 76,285,000$ | 76,285,000$ | 620,046$ | 53,788,030$ | 76,285,000$ | 52,581,296$ | 25 | 0 | 0$ | 17,049,711$ | 36 | 657,857$ | 23,682,852$ | 23,682,852$ | 76,905,046$ | 6,305,046$ | 95,500,000$ | 18,594,954$ | 103,780,345$ | 97,147,204$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 162562 | 136307 | 117189 | 125334 | 29783 | 93.43% | 94.00% | 85.07% | 96.04% | 100.00% | 12 | 19696 - 92.57% | 1,561,842$ | 45,293,422$ | 21277 | 100 | 89,258,750$ | 89,258,750$ | 0$ | 65,258,201$ | 89,258,750$ | 64,909,443$ | 22 | 1 | 0$ | 18,742,106$ | 36 | 754,275$ | 27,153,900$ | 27,153,900$ | 89,258,750$ | 18,658,750$ | 95,500,000$ | 6,241,250$ | 86,871,835$ | 78,460,041$ |
| 7 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 58 | 36 | 16 | 130 | 149898 | 120000 | 86865 | 93705 | 30000 | 99.93% | 100.00% | 91.23% | 78.09% | 100.00% | 11 | 16016 - 93.25% | 1,417,651$ | 42,529,527$ | 17174 | 100 | 90,379,881$ | 90,379,881$ | 0$ | 61,836,095$ | 90,379,881$ | 61,138,631$ | 25 | 0 | 0$ | 15,594,160$ | 36 | 767,898$ | 27,644,328$ | 27,644,328$ | 90,379,881$ | 19,779,881$ | 95,500,000$ | 5,120,119$ | -11,195,731$ | -23,245,899$ |
| 8 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 162372 | 138359 | 112486 | 126939 | 34085 | 93.32% | 95.42% | 68.43% | 72.95% | 78.36% | 12 | 19801 - 81.93% | 1,556,748$ | 45,145,697$ | 24168 | 100 | 81,583,420$ | 81,583,420$ | 0$ | 61,666,436$ | 81,583,420$ | 61,317,678$ | 22 | 1 | 0$ | 18,680,978$ | 36 | 689,777$ | 24,831,972$ | 24,831,972$ | 81,583,420$ | 10,983,420$ | 95,500,000$ | 13,916,580$ | 133,872,919$ | 127,721,925$ |
| 9 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 89 | 59 | 38 | 22 | 201 | 153425 | 129757 | 88788 | 94672 | 29171 | 92.98% | 96.12% | 98.65% | 90.16% | 97.24% | 11 | 16527 - 94.44% | 1,574,061$ | 47,221,831$ | 17500 | 100 | 88,558,307$ | 88,558,307$ | 0$ | 60,044,495$ | 88,558,307$ | 59,347,038$ | 23 | 0 | 0$ | 17,314,671$ | 36 | 752,591$ | 27,093,276$ | 27,093,276$ | 88,558,307$ | 17,958,307$ | 95,500,000$ | 6,941,693$ | 110,287,631$ | 100,509,026$ |
| 10 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 60 | 40 | 25 | 300 | 118597 | 112252 | 86196 | 79298 | 18200 | 89.39% | 88.47% | 87.68% | 81.02% | 78.45% | 12 | 14295 - 86.56% | 1,514,925$ | 43,932,816$ | 16515 | 100 | 94,451,857$ | 94,451,857$ | 662,250$ | 66,348,373$ | 94,451,857$ | 64,953,421$ | 23 | 0 | 0$ | 18,179,096$ | 36 | 810,520$ | 29,178,720$ | 29,178,720$ | 95,114,107$ | 24,514,107$ | 95,500,000$ | 385,893$ | 225,372,350$ | 214,372,726$ |
| 11 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 129241 | 96545 | 114924 | 98382 | 34009 | 81.28% | 74.84% | 89.09% | 74.23% | 87.20% | 11 | 15770 - 80.39% | 1,526,906$ | 45,807,176$ | 19618 | 100 | 91,225,000$ | 91,225,000$ | -2,437,500$ | 63,379,770$ | 91,225,000$ | 61,287,295$ | 23 | 0 | 0$ | 16,795,965$ | 36 | 791,807$ | 28,505,052$ | 28,505,052$ | 88,787,500$ | 18,187,500$ | 95,500,000$ | 6,712,500$ | 1,875,389$ | -9,833,698$ |
| 12 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 87 | 55 | 18 | 8 | 205 | 168669 | 129267 | 130403 | 139318 | 27468 | 93.71% | 86.18% | 86.94% | 77.40% | 91.56% | 11 | 19838 - 86.25% | 1,544,352$ | 46,330,556$ | 23000 | 100 | 81,859,999$ | 81,859,999$ | 3,500,000$ | 60,545,235$ | 81,859,999$ | 59,150,254$ | 23 | 0 | 0$ | 16,987,871$ | 36 | 704,706$ | 25,369,416$ | 25,369,416$ | 85,359,999$ | 14,759,999$ | 95,500,000$ | 10,140,001$ | 139,713,409$ | 131,331,864$ |
| 13 | Mammoth | 4000 | 4000 | 3500 | 3000 | 1700 | 71 | 60 | 35 | 15 | 150 | 120000 | 114356 | 104904 | 90000 | 35970 | 100.00% | 95.30% | 99.91% | 100.00% | 70.53% | 11 | 15508 - 95.73% | 1,281,326$ | 38,439,767$ | 16200 | 100 | 98,215,000$ | 98,215,000$ | -4,500,000$ | 66,478,471$ | 98,215,000$ | 64,386,030$ | 22 | 0 | 0$ | 14,094,581$ | 36 | 850,546$ | 30,619,656$ | 30,619,656$ | 93,715,000$ | 23,115,000$ | 95,500,000$ | 1,785,000$ | 234,219,605$ | 217,694,530$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 75 | 44 | 32 | 12 | 165 | 166077 | 144798 | 104913 | 134936 | 33942 | 85.17% | 86.19% | 99.92% | 93.71% | 80.81% | 11 | 19489 - 89.40% | 1,460,387$ | 43,811,610$ | 21800 | 100 | 80,775,000$ | 80,775,000$ | 0$ | 56,518,810$ | 80,775,000$ | 56,170,067$ | 23 | 0 | 0$ | 16,064,257$ | 36 | 682,983$ | 24,587,388$ | 24,587,388$ | 80,775,000$ | 10,175,000$ | 95,500,000$ | 14,725,000$ | 33,448,827$ | 24,925,696$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 139089 | 139806 | 75431 | 100368 | 28031 | 77.27% | 93.20% | 96.71% | 83.64% | 93.44% | 11 | 16091 - 86.51% | 1,550,360$ | 46,510,789$ | 18600 | 100 | 61,066,667$ | 61,066,667$ | 11,000,000$ | 49,913,660$ | 61,066,667$ | 47,123,714$ | 25 | 0 | 0$ | 17,053,956$ | 36 | 546,779$ | 19,684,044$ | 19,684,044$ | 72,066,667$ | 1,466,667$ | 95,500,000$ | 23,433,333$ | 33,459,787$ | 30,829,699$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 80 | 50 | 38 | 14 | 200 | 168924 | 141233 | 94381 | 136049 | 28326 | 93.85% | 94.16% | 96.80% | 90.70% | 94.42% | 11 | 18964 - 93.65% | 1,574,383$ | 47,231,490$ | 20250 | 100 | 100,175,000$ | 100,175,000$ | -4,750,000$ | 70,154,170$ | 100,175,000$ | 68,410,496$ | 23 | 0 | 0$ | 17,318,213$ | 36 | 862,815$ | 31,061,340$ | 31,061,340$ | 95,425,000$ | 24,825,000$ | 95,500,000$ | 75,000$ | 102,369,366$ | 88,626,239$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 118041 | 107849 | 108425 | 94340 | 36250 | 64.10% | 67.62% | 85.95% | 81.33% | 50.00% | 12 | 16031 - 70.62% | 1,603,379$ | 46,498,005$ | 22700 | 100 | 92,963,334$ | 92,963,334$ | 0$ | 67,865,286$ | 92,963,334$ | 66,470,332$ | 21 | 0 | 0$ | 19,240,554$ | 36 | 798,011$ | 28,728,396$ | 28,728,396$ | 92,963,334$ | 22,363,334$ | 95,500,000$ | 2,536,666$ | 35,953,631$ | 26,465,789$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 70 | 56 | 25 | 12 | 85 | 178056 | 139084 | 122922 | 139592 | 40537 | 84.79% | 92.72% | 91.05% | 93.06% | 90.08% | 11 | 20673 - 89.88% | 1,412,839$ | 42,385,170$ | 23000 | 100 | 97,499,999$ | 97,499,999$ | -8,750,000$ | 68,776,728$ | 97,499,999$ | 66,335,536$ | 21 | 0 | 0$ | 15,541,229$ | 36 | 848,739$ | 30,554,604$ | 30,554,604$ | 88,749,999$ | 18,149,999$ | 95,500,000$ | 6,750,001$ | 136,792,212$ | 121,778,837$ |
| 19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 81 | 43 | 42 | 17 | 190 | 169216 | 145316 | 79361 | 119903 | 30000 | 94.01% | 96.88% | 99.75% | 99.92% | 100.00% | 11 | 18127 - 97.18% | 1,589,632$ | 47,688,974$ | 18652 | 100 | 85,280,500$ | 85,280,500$ | 0$ | 61,511,207$ | 85,280,500$ | 60,345,625$ | 24 | 1 | 0$ | 17,485,957$ | 36 | 732,189$ | 26,358,804$ | 26,358,804$ | 85,280,500$ | 14,680,500$ | 95,500,000$ | 10,219,500$ | -10,516,473$ | -19,389,320$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 98470 | 75000 | 60000 | 60000 | 15037 | 54.71% | 50.00% | 50.00% | 50.00% | 50.12% | 11 | 10284 - 51.42% | 1,658,795$ | 49,763,840$ | 20000 | 100 | 92,964,280$ | 92,964,280$ | 0$ | 65,538,124$ | 92,964,280$ | 63,445,693$ | 23 | 0 | 0$ | 18,246,741$ | 36 | 806,423$ | 29,031,228$ | 29,031,228$ | 92,964,280$ | 22,364,280$ | 95,500,000$ | 2,535,720$ | 6,221,021$ | -4,563,466$ |