| 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 | Revenus | Dépenses | Éstimation | Total de l'Équipe Éstimé | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | É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 - % | Revenus Moyen par Match | Revenus Annuels à ce Jour | Capacité de l'Aréna | Popularité de l'Équipe | Salaire Total des Joueurs | Salaire Total Moyen des Joueurs | Valeur du Cap Salarial Spécial | Dépenses Annuelles à Ce Jour | Cap Salarial Par Jour | Cap salarial à ce jour | Joueurs Inclut dans la Cap Salariale | Joueurs Exclut dans la Cap Salariale | Taxe de Luxe Totale | Revenus de la Saison Éstimés | Jours Restants de la Saison | Dépenses Par Jour | Dépenses de la Saison Éstimées | Dépenses de la Saison Éstimées | Cap Salarial de la Saison Éstimé | Au dessus du Plafond Salarial Minimum of 56,000,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
| 1 | ANAHEIM Ducks | 6000 | 5000 | 2000 | 5000 | 1000 | 195 | 190 | 185 | 180 | 225 | 13897 | 10081 | 3314 | 8058 | 3430 | 57.90% | 50.41% | 41.43% | 40.29% | 85.75% | 37 | 9695 - 51.03% | 2,611,205$ | 10,444,819$ | 19000 | 100 | 88,550,000$ | 88,550,000$ | 0$ | 6,352,266$ | 88,550,000$ | 6,267,410$ | 24 | 0 | 0$ | 96,614,576$ | 104 | 801,232$ | 83,328,128$ | 84,118,138$ | 88,550,000$ | 32,550,000$ | 89,650,000$ | 1,100,000$ | 193,183,015$ | 205,679,453$ |
| 2 | ARIZONA Coyotes | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 55 | 45 | 30 | 180 | 18000 | 15000 | 6000 | 15000 | 2995 | 100.00% | 100.00% | 100.00% | 100.00% | 99.83% | 38 | 18998 - 99.99% | 1,728,580$ | 5,185,740$ | 19000 | 100 | 57,725,000$ | 57,725,000$ | 0$ | 4,206,696$ | 57,725,000$ | 4,156,696$ | 20 | 0 | 0$ | 65,686,040$ | 104 | 521,652$ | 54,251,808$ | 56,796,629$ | 57,725,000$ | 1,725,000$ | 89,650,000$ | 31,925,000$ | 150,935,250$ | 159,824,661$ |
| 3 | BOSTON Bruins | 6000 | 5000 | 2000 | 5000 | 1000 | 95 | 70 | 55 | 40 | 190 | 18000 | 15000 | 6000 | 15000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 19000 - 100.00% | 1,988,000$ | 5,964,000$ | 19000 | 100 | 58,375,000$ | 58,125,000$ | 0$ | 4,218,319$ | 58,375,000$ | 4,188,391$ | 23 | 0 | 0$ | 75,544,000$ | 104 | 524,946$ | 54,594,384$ | 57,138,793$ | 58,375,000$ | 2,375,000$ | 89,650,000$ | 31,275,000$ | 135,530,402$ | 153,935,609$ |
| 4 | CALGARY Flames | 6000 | 5000 | 2000 | 5000 | 1000 | 115 | 90 | 60 | 55 | 250 | 17577 | 15000 | 6000 | 15000 | 2383 | 97.65% | 100.00% | 100.00% | 100.00% | 79.43% | 38 | 18653 - 98.18% | 2,404,316$ | 7,212,947$ | 19000 | 100 | 86,250,000$ | 86,250,000$ | 0$ | 6,237,503$ | 86,250,000$ | 6,176,784$ | 21 | 0 | 0$ | 91,363,995$ | 104 | 777,679$ | 80,878,616$ | 82,757,645$ | 86,250,000$ | 30,250,000$ | 89,650,000$ | 3,400,000$ | 76,007,791$ | 84,614,141$ |
| 5 | CHICAGO Blackhawks | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 68 | 42 | 27 | 210 | 18000 | 15000 | 6000 | 15000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 19000 - 100.00% | 1,916,600$ | 5,749,800$ | 19000 | 100 | 63,490,000$ | 63,490,000$ | 0$ | 4,663,072$ | 63,490,000$ | 4,535,000$ | 21 | 0 | 0$ | 72,830,800$ | 104 | 582,884$ | 60,619,936$ | 62,916,527$ | 63,490,000$ | 7,490,000$ | 89,650,000$ | 26,160,000$ | 89,305,784$ | 99,220,057$ |
| 6 | COLORADO Avalanche | 6000 | 5000 | 2000 | 5000 | 1000 | 175 | 170 | 165 | 125 | 200 | 11220 | 8413 | 2703 | 8283 | 3000 | 62.33% | 56.09% | 45.05% | 55.22% | 100.00% | 38 | 11206 - 58.98% | 2,555,037$ | 7,665,112$ | 19000 | 100 | 85,675,000$ | 85,675,000$ | 0$ | 6,180,360$ | 85,675,000$ | 6,119,640$ | 21 | 0 | 0$ | 97,091,419$ | 104 | 772,545$ | 80,344,680$ | 82,071,578$ | 85,675,000$ | 29,675,000$ | 89,650,000$ | 3,975,000$ | 63,644,737$ | 78,664,578$ |
| 7 | DETROIT Red Wings | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 100 | 90 | 79 | 250 | 18000 | 14885 | 5888 | 13237 | 2220 | 100.00% | 99.23% | 98.13% | 88.25% | 74.00% | 38 | 18077 - 95.14% | 2,738,933$ | 8,216,800$ | 19000 | 100 | 75,586,667$ | 75,586,667$ | 0$ | 5,402,917$ | 75,586,667$ | 5,352,917$ | 20 | 0 | 0$ | 104,079,467$ | 104 | 681,131$ | 70,837,624$ | 72,563,595$ | 75,586,667$ | 19,586,667$ | 89,650,000$ | 14,063,333$ | 151,243,751$ | 182,759,623$ |
| 8 | EDMONTON Oilers | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 105 | 94 | 78 | 220 | 18000 | 14863 | 5073 | 14110 | 3000 | 100.00% | 99.09% | 84.55% | 94.07% | 100.00% | 38 | 18349 - 96.57% | 2,835,509$ | 8,506,526$ | 19000 | 100 | 79,390,000$ | 79,390,000$ | 0$ | 5,485,139$ | 79,390,000$ | 5,393,853$ | 22 | 0 | 0$ | 107,749,329$ | 104 | 720,250$ | 74,906,000$ | 77,469,361$ | 79,390,000$ | 23,390,000$ | 89,650,000$ | 10,260,000$ | 132,897,840$ | 163,177,808$ |
| 9 | MINNESOTA Wild | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 60 | 40 | 30 | 200 | 18000 | 15000 | 6000 | 15000 | 2990 | 100.00% | 100.00% | 100.00% | 100.00% | 99.67% | 38 | 18997 - 99.98% | 1,861,067$ | 5,583,200$ | 19000 | 100 | 76,435,000$ | 76,435,000$ | 0$ | 5,472,144$ | 76,435,000$ | 5,418,572$ | 21 | 0 | 0$ | 70,720,533$ | 104 | 689,152$ | 71,671,808$ | 73,311,877$ | 76,435,000$ | 20,435,000$ | 89,650,000$ | 13,215,000$ | 14,761,937$ | 12,170,593$ |
| 10 | MONTREAL Canadiens | 6000 | 5000 | 2000 | 5000 | 1000 | 96 | 69 | 49 | 36 | 193 | 18000 | 15000 | 6000 | 15000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 19000 - 100.00% | 1,948,800$ | 5,846,400$ | 19000 | 100 | 87,940,000$ | 87,940,000$ | 0$ | 6,424,288$ | 87,940,000$ | 6,281,432$ | 21 | 0 | 0$ | 74,054,400$ | 104 | 803,036$ | 83,515,744$ | 86,229,897$ | 87,940,000$ | 31,940,000$ | 89,650,000$ | 1,710,000$ | 62,362,138$ | 50,186,641$ |
| 11 | NASHVILLE Predators | 6000 | 5000 | 2000 | 5000 | 1000 | 125 | 85 | 75 | 45 | 217 | 24000 | 19853 | 8000 | 20000 | 3915 | 100.00% | 99.27% | 100.00% | 100.00% | 97.88% | 37 | 18942 - 99.69% | 2,462,971$ | 9,851,884$ | 19000 | 100 | 76,110,000$ | 76,110,000$ | 0$ | 5,488,821$ | 76,110,000$ | 5,371,253$ | 21 | 0 | 0$ | 91,129,927$ | 104 | 694,250$ | 72,202,000$ | 74,164,562$ | 76,110,000$ | 20,110,000$ | 89,650,000$ | 13,540,000$ | 65,989,713$ | 82,955,078$ |
| 12 | NEW JERSEY Devils | 6000 | 5000 | 2000 | 5000 | 1000 | 115 | 95 | 80 | 65 | 205 | 18000 | 15000 | 6000 | 14886 | 3000 | 100.00% | 100.00% | 100.00% | 99.24% | 100.00% | 38 | 18962 - 99.80% | 2,593,542$ | 7,780,626$ | 19000 | 100 | 64,575,000$ | 64,575,000$ | 0$ | 4,773,663$ | 64,575,000$ | 4,712,944$ | 22 | 0 | 0$ | 98,554,596$ | 104 | 584,152$ | 60,751,808$ | 62,957,450$ | 64,575,000$ | 8,575,000$ | 89,650,000$ | 25,075,000$ | 95,108,963$ | 130,706,109$ |
| 13 | NEW YORK Islanders | 6000 | 5000 | 2000 | 5000 | 1000 | 150 | 135 | 120 | 100 | 200 | 13713 | 9680 | 3814 | 10275 | 3000 | 76.18% | 64.53% | 63.57% | 68.50% | 100.00% | 38 | 13494 - 71.02% | 2,542,834$ | 7,628,502$ | 19000 | 100 | 84,770,000$ | 84,886,667$ | 0$ | 6,048,716$ | 84,770,000$ | 6,005,716$ | 22 | 0 | 0$ | 96,627,692$ | 104 | 762,250$ | 79,274,000$ | 81,872,175$ | 84,770,000$ | 28,770,000$ | 89,650,000$ | 4,880,000$ | 117,341,432$ | 132,096,949$ |
| 14 | NEW YORK Rangers | 6000 | 5000 | 2000 | 5000 | 1000 | 150 | 120 | 95 | 94 | 300 | 14452 | 11516 | 4989 | 10982 | 1891 | 80.29% | 76.77% | 83.15% | 73.21% | 63.03% | 38 | 14610 - 76.89% | 2,624,199$ | 7,872,596$ | 19000 | 100 | 86,865,000$ | 86,865,000$ | 0$ | 6,259,146$ | 86,865,000$ | 6,174,283$ | 21 | 0 | 0$ | 99,719,549$ | 104 | 786,188$ | 81,763,552$ | 82,867,815$ | 86,865,000$ | 30,865,000$ | 89,650,000$ | 2,785,000$ | 41,250,246$ | 58,101,980$ |
| 15 | OTTAWA Senators | 6000 | 5000 | 2000 | 5000 | 1000 | 95 | 94 | 90 | 89 | 190 | 24000 | 19811 | 7887 | 15228 | 3953 | 100.00% | 99.06% | 98.59% | 76.14% | 98.83% | 37 | 17720 - 93.26% | 2,435,449$ | 9,741,797$ | 19000 | 100 | 67,535,000$ | 67,535,000$ | 0$ | 5,044,466$ | 67,535,000$ | 4,973,036$ | 21 | 0 | 0$ | 90,111,622$ | 104 | 611,920$ | 63,639,680$ | 65,054,797$ | 67,535,000$ | 11,535,000$ | 89,650,000$ | 22,115,000$ | 27,798,035$ | 52,854,860$ |
| 16 | PHILADELPHIA Flyers | 6000 | 5000 | 2000 | 5000 | 1000 | 225 | 220 | 215 | 210 | 280 | 9008 | 6415 | 2400 | 6000 | 2001 | 50.04% | 42.77% | 40.00% | 40.00% | 66.70% | 38 | 8608 - 45.31% | 2,694,711$ | 8,084,132$ | 19000 | 100 | 89,204,286$ | 89,204,286$ | 0$ | 6,466,592$ | 89,204,286$ | 6,371,736$ | 20 | 0 | 0$ | 102,399,005$ | 104 | 808,324$ | 84,065,696$ | 86,133,112$ | 89,204,286$ | 33,204,286$ | 89,650,000$ | 445,714$ | 84,441,152$ | 100,707,045$ |
| 17 | PITTSBURGH Penguins | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 56 | 31 | 16 | 194 | 17968 | 15000 | 6000 | 15000 | 3000 | 99.82% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18989 - 99.94% | 1,650,596$ | 4,951,789$ | 19000 | 100 | 62,090,000$ | 62,090,000$ | 0$ | 4,479,784$ | 62,090,000$ | 4,435,000$ | 22 | 0 | 0$ | 62,722,661$ | 104 | 559,973$ | 58,237,192$ | 60,200,681$ | 62,090,000$ | 6,090,000$ | 89,650,000$ | 27,560,000$ | 26,278,384$ | 28,800,364$ |
| 18 | QUEBEC Nordiques | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 63 | 37 | 33 | 240 | 17974 | 15000 | 6000 | 15000 | 2405 | 99.86% | 100.00% | 100.00% | 100.00% | 80.17% | 38 | 18793 - 98.91% | 1,833,419$ | 5,500,258$ | 19000 | 100 | 80,330,000$ | 80,080,000$ | 0$ | 5,800,354$ | 80,330,000$ | 5,657,498$ | 23 | 0 | 0$ | 69,669,935$ | 104 | 735,089$ | 76,449,256$ | 77,525,606$ | 80,330,000$ | 24,330,000$ | 89,650,000$ | 9,320,000$ | 25,477,828$ | 17,622,157$ |
| 19 | SEATTLE Totems | 6000 | 5000 | 2000 | 5000 | 1000 | 94 | 56 | 33 | 27 | 195 | 24000 | 20000 | 8000 | 20000 | 3920 | 100.00% | 100.00% | 100.00% | 100.00% | 98.00% | 37 | 18980 - 99.89% | 1,730,540$ | 6,922,160$ | 19000 | 100 | 89,862,858$ | 89,862,858$ | 0$ | 6,510,704$ | 89,862,858$ | 6,472,344$ | 21 | 0 | 0$ | 64,029,980$ | 104 | 807,142$ | 83,942,768$ | 85,872,885$ | 89,862,858$ | 33,862,858$ | 89,650,000$ | -212,858$ | 15,980,066$ | -5,862,839$ |
| 20 | ST-LOUIS Blues | 6000 | 5000 | 2000 | 5000 | 1000 | 140 | 120 | 95 | 70 | 200 | 18429 | 15450 | 6493 | 20000 | 4000 | 76.79% | 77.25% | 81.16% | 100.00% | 100.00% | 37 | 16093 - 84.70% | 2,537,813$ | 10,151,253$ | 19000 | 100 | 89,391,000$ | 89,391,000$ | 0$ | 6,509,360$ | 89,391,000$ | 6,385,072$ | 20 | 0 | 0$ | 93,899,090$ | 104 | 813,670$ | 84,621,680$ | 85,541,985$ | 89,391,000$ | 33,391,000$ | 89,650,000$ | 259,000$ | 96,741,889$ | 105,098,994$ |
| 21 | TAMPA BAY Lightning | 6000 | 5000 | 2000 | 5000 | 1000 | 160 | 125 | 105 | 100 | 325 | 12934 | 11413 | 4382 | 9795 | 1807 | 71.86% | 76.09% | 73.03% | 65.30% | 60.23% | 38 | 13444 - 70.76% | 2,577,377$ | 7,732,130$ | 19000 | 100 | 83,555,000$ | 83,555,000$ | 0$ | 6,036,714$ | 83,555,000$ | 5,928,930$ | 20 | 0 | 0$ | 97,940,313$ | 104 | 759,500$ | 78,988,000$ | 80,771,445$ | 83,555,000$ | 27,555,000$ | 89,650,000$ | 6,095,000$ | 87,996,760$ | 105,165,628$ |
| 22 | TORONTO Maple Leafs | 6000 | 5000 | 2000 | 5000 | 1000 | 195 | 190 | 185 | 180 | 225 | 10339 | 7365 | 2553 | 6000 | 2461 | 57.44% | 49.10% | 42.55% | 40.00% | 82.03% | 38 | 9573 - 50.38% | 2,576,693$ | 7,730,079$ | 19000 | 100 | 74,625,000$ | 74,625,000$ | 0$ | 5,400,496$ | 74,625,000$ | 5,330,360$ | 23 | 0 | 0$ | 97,914,334$ | 104 | 675,062$ | 70,206,448$ | 70,953,404$ | 74,625,000$ | 18,625,000$ | 89,650,000$ | 15,025,000$ | 202,099,733$ | 229,060,663$ |
| 23 | VANCOUVER Canucks | 6000 | 5000 | 2000 | 5000 | 1000 | 129 | 85 | 65 | 42 | 225 | 17594 | 15000 | 6000 | 15000 | 2485 | 97.74% | 100.00% | 100.00% | 100.00% | 82.83% | 38 | 18693 - 98.38% | 2,391,084$ | 7,173,252$ | 19000 | 100 | 62,445,000$ | 62,445,000$ | 0$ | 4,471,069$ | 62,445,000$ | 4,435,357$ | 22 | 0 | 0$ | 90,861,192$ | 104 | 562,009$ | 58,448,936$ | 61,787,166$ | 62,445,000$ | 6,445,000$ | 89,650,000$ | 27,205,000$ | 66,555,072$ | 95,629,098$ |
| 24 | VEGAS Golden Knights | 6000 | 5000 | 2000 | 5000 | 1000 | 215 | 210 | 205 | 200 | 250 | 9697 | 6751 | 2400 | 6000 | 2329 | 53.87% | 45.01% | 40.00% | 40.00% | 77.63% | 38 | 9059 - 47.68% | 2,695,847$ | 8,087,541$ | 19000 | 100 | 62,075,000$ | 62,075,000$ | 0$ | 4,527,360$ | 62,075,000$ | 4,433,928$ | 20 | 0 | 0$ | 102,442,186$ | 104 | 565,920$ | 58,855,680$ | 61,111,895$ | 62,075,000$ | 6,075,000$ | 89,650,000$ | 27,575,000$ | 148,638,617$ | 189,968,908$ |
| 25 | WASHINGTON Capitals | 6000 | 5000 | 2000 | 5000 | 1000 | 100 | 99 | 58 | 50 | 225 | 18000 | 15000 | 6000 | 15000 | 2585 | 100.00% | 100.00% | 100.00% | 100.00% | 86.17% | 38 | 18862 - 99.27% | 2,316,825$ | 6,950,475$ | 19000 | 100 | 87,250,000$ | 87,250,000$ | 0$ | 6,292,856$ | 87,250,000$ | 6,232,144$ | 21 | 0 | 0$ | 88,039,350$ | 104 | 786,607$ | 81,807,128$ | 83,839,318$ | 87,250,000$ | 31,250,000$ | 89,650,000$ | 2,400,000$ | 29,847,084$ | 34,047,116$ |
| 26 | WINNIPEG Jets | 6000 | 5000 | 2000 | 5000 | 1000 | 90 | 70 | 55 | 40 | 190 | 18000 | 15000 | 6000 | 15000 | 2979 | 100.00% | 100.00% | 100.00% | 100.00% | 99.30% | 38 | 18993 - 99.96% | 1,944,138$ | 5,832,414$ | 19000 | 100 | 59,915,000$ | 59,915,000$ | 0$ | 4,469,694$ | 59,915,000$ | 4,441,694$ | 22 | 0 | 0$ | 73,877,244$ | 104 | 538,455$ | 55,999,320$ | 57,829,630$ | 59,915,000$ | 3,915,000$ | 89,650,000$ | 29,735,000$ | 52,217,478$ | 68,265,092$ |