| 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 45,000,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
| 1 | Avalanche | 6000 | 5000 | 3500 | 2000 | 1500 | 93 | 81 | 69 | 52 | 115 | 18000 | 15000 | 10485 | 6000 | 4500 | 100.00% | 100.00% | 99.86% | 100.00% | 100.00% | 38 | 17995 - 99.97% | 1,628,720$ | 4,886,161$ | 18000 | 100 | 61,225,000$ | 925,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 40,137,528$ | 40,137,528$ |
| 2 | Blackhawks | 6000 | 5500 | 2700 | 4000 | 1800 | 95 | 86 | 71 | 55 | 120 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 70,975,000$ | 5,000,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 28,956,229$ | 28,956,229$ |
| 3 | Blues | 7000 | 5000 | 3000 | 3000 | 2000 | 89 | 78 | 61 | 50 | 115 | 34051 | 25000 | 15000 | 15000 | 8838 | 97.29% | 100.00% | 100.00% | 100.00% | 88.38% | 36 | 19578 - 97.89% | 1,685,620$ | 8,428,100$ | 20000 | 100 | 61,200,000$ | 6,750,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 33,766,416$ | 33,766,416$ |
| 4 | Bruins | 6700 | 5900 | 3500 | 2400 | 1500 | 95 | 83 | 71 | 59 | 120 | 18997 | 15930 | 9450 | 7082 | 4500 | 94.51% | 90.00% | 90.00% | 98.36% | 100.00% | 38 | 18653 - 93.27% | 1,743,754$ | 5,231,263$ | 20000 | 100 | 66,400,000$ | 3,500,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 26,429,309$ | 26,429,309$ |
| 5 | Canadiens | 6500 | 5000 | 3000 | 2000 | 1500 | 105 | 93 | 76 | 62 | 120 | 30471 | 23500 | 14260 | 10000 | 7500 | 93.76% | 94.00% | 95.07% | 100.00% | 100.00% | 36 | 17146 - 95.26% | 1,757,517$ | 8,787,585$ | 18000 | 100 | 70,600,000$ | 8,575,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 46,445,597$ | 46,445,597$ |
| 6 | Canucks | 7000 | 5400 | 2400 | 4000 | 1200 | 85 | 72 | 63 | 54 | 125 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 53,519,167$ | 1,819,167$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 49,892,760$ | 49,892,760$ |
| 7 | Capitals | 7300 | 5700 | 2800 | 2000 | 1600 | 95 | 84 | 75 | 63 | 120 | 93904 | 71698 | 36313 | 26000 | 20792 | 98.95% | 96.76% | 99.76% | 100.00% | 99.96% | 28 | 19131 - 98.61% | 1,844,618$ | 23,980,030$ | 19400 | 100 | 72,650,000$ | 1,400,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 49,268,891$ | 49,268,891$ |
| 8 | Devils | 6500 | 5700 | 4000 | 2200 | 1500 | 97 | 85 | 76 | 65 | 115 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19900 | 100 | 63,150,000$ | 2,075,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 4,400,260$ | 4,400,260$ |
| 9 | Ducks | 6500 | 5500 | 3500 | 1500 | 1500 | 91 | 79 | 65 | 58 | 125 | 52000 | 43702 | 27514 | 12000 | 11941 | 100.00% | 99.32% | 98.26% | 100.00% | 99.51% | 33 | 18395 - 99.43% | 1,672,205$ | 13,377,643$ | 18500 | 100 | 62,800,000$ | 575,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 30,605,254$ | 30,605,254$ |
| 10 | Flames | 7500 | 5500 | 2500 | 4500 | 2000 | 95 | 82 | 69 | 50 | 120 | 35802 | 27500 | 12500 | 20250 | 9069 | 95.47% | 100.00% | 100.00% | 90.00% | 90.69% | 36 | 21024 - 95.56% | 1,896,283$ | 9,481,416$ | 22000 | 100 | 78,025,000$ | 2,075,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 5,726,354$ | 5,726,354$ |
| 11 | Flyers | 6000 | 5000 | 3500 | 2000 | 1500 | 88 | 74 | 65 | 50 | 115 | 12000 | 10000 | 6732 | 4000 | 3000 | 100.00% | 100.00% | 96.17% | 100.00% | 100.00% | 39 | 17866 - 99.26% | 1,528,219$ | 3,056,438$ | 18000 | 100 | 63,950,000$ | 2,550,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 35,278,003$ | 35,278,003$ |
| 12 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 73 | 61 | 50 | 115 | 42000 | 35000 | 14000 | 25399 | 7000 | 100.00% | 100.00% | 100.00% | 90.71% | 100.00% | 34 | 17628 - 97.94% | 1,422,764$ | 9,959,345$ | 18000 | 100 | 64,010,000$ | 660,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 14,447,905$ | 14,447,905$ |
| 13 | Kings | 6500 | 5000 | 2500 | 2500 | 1500 | 120 | 99 | 85 | 79 | 145 | 24700 | 19000 | 9934 | 9500 | 5850 | 95.00% | 95.00% | 99.34% | 95.00% | 97.50% | 37 | 17246 - 95.81% | 2,004,239$ | 8,016,954$ | 18000 | 100 | 83,850,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 2,261,671$ | 2,261,671$ |
| 14 | Maple Leafs | 6000 | 6000 | 4700 | 2000 | 1300 | 105 | 91 | 80 | 69 | 120 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 66,800,000$ | 1,000,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 11,565,614$ | 11,565,614$ |
| 15 | Oilers | 6600 | 5800 | 2800 | 5000 | 1800 | 91 | 79 | 65 | 50 | 120 | 19800 | 17400 | 8400 | 13500 | 5075 | 100.00% | 100.00% | 100.00% | 90.00% | 93.98% | 38 | 21392 - 97.23% | 1,835,680$ | 5,507,040$ | 22000 | 100 | 70,250,000$ | 10,750,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 61,054,318$ | 61,054,318$ |
| 16 | Penguins | 6400 | 5400 | 4400 | 2400 | 1400 | 96 | 83 | 71 | 59 | 120 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 69,100,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 18,950,370$ | 18,950,370$ |
| 17 | Predators | 6500 | 5500 | 2500 | 4400 | 1100 | 90 | 78 | 65 | 51 | 115 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 62,300,000$ | 1,750,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 52,176,924$ | 52,176,924$ |
| 18 | Rangers | 6000 | 5000 | 3000 | 2500 | 1500 | 96 | 82 | 71 | 58 | 120 | 23667 | 20000 | 11835 | 10000 | 6000 | 98.61% | 100.00% | 98.63% | 100.00% | 100.00% | 37 | 17876 - 99.31% | 1,664,387$ | 6,657,549$ | 18000 | 100 | 55,458,330$ | 8,258,330$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 74,849,456$ | 74,849,456$ |
| 19 | Red Wings | 6000 | 5500 | 4500 | 2000 | 1500 | 97 | 88 | 74 | 61 | 140 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19500 | 100 | 81,450,000$ | 1,150,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | -34,155,186$ | -34,155,186$ |
| 20 | Sabres | 6000 | 5000 | 4000 | 3000 | 1200 | 97 | 82 | 70 | 56 | 120 | 53439 | 45000 | 31740 | 26156 | 10800 | 98.96% | 100.00% | 88.17% | 96.87% | 100.00% | 32 | 18571 - 96.72% | 1,693,526$ | 15,241,731$ | 19200 | 100 | 73,036,667$ | 1,261,667$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 82,070,704$ | 82,070,704$ |
| 21 | Senateurs | 6500 | 5000 | 4000 | 2000 | 1500 | 91 | 82 | 73 | 58 | 115 | 19500 | 15000 | 10800 | 6000 | 4500 | 100.00% | 100.00% | 90.00% | 100.00% | 100.00% | 38 | 18600 - 97.89% | 1,708,080$ | 5,124,240$ | 19000 | 100 | 67,100,000$ | 1,100,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 22,775,657$ | 22,775,657$ |
| 22 | Sharks | 6500 | 5000 | 3000 | 4000 | 1500 | 100 | 81 | 65 | 50 | 120 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 66,863,333$ | 1,438,333$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 33,111,986$ | 33,111,986$ |
| 23 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 96 | 84 | 70 | 56 | 120 | 17376 | 14596 | 6000 | 9600 | 3000 | 96.53% | 97.31% | 100.00% | 80.00% | 100.00% | 38 | 16857 - 93.65% | 1,544,312$ | 4,632,936$ | 18000 | 100 | 62,950,000$ | 1,500,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 4,813,897$ | 4,813,897$ |
| 24 | Wild | 6500 | 5500 | 2500 | 4500 | 1000 | 50 | 30 | 15 | 10 | 100 | 75823 | 64345 | 29250 | 49815 | 11200 | 97.21% | 97.49% | 97.50% | 92.25% | 93.33% | 29 | 19203 - 96.01% | 6,430,249$ | 77,162,990$ | 20000 | 100 | 81,720,000$ | 575,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -45,000,000$ | 90,000,000$ | 90,000,000$ | 194,134,700$ | 194,134,700$ |