| 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 40,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 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 60,344,000$ | 1,375,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 35,062,023$ | 35,062,023$ |
| 2 | Blackhawks | 6000 | 5500 | 2700 | 4000 | 1800 | 95 | 86 | 71 | 55 | 120 | 66000 | 58609 | 29700 | 40866 | 19102 | 100.00% | 96.87% | 100.00% | 92.88% | 96.47% | 30 | 19480 - 97.40% | 1,469,368$ | 16,163,050$ | 20000 | 100 | 69,975,000$ | 5,575,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 41,222,913$ | 41,222,913$ |
| 3 | Blues | 7000 | 5000 | 3000 | 3000 | 2000 | 89 | 78 | 61 | 50 | 115 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 66,900,000$ | 3,475,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 23,175,492$ | 23,175,492$ |
| 4 | Bruins | 6700 | 5900 | 3500 | 2400 | 1500 | 95 | 83 | 71 | 59 | 120 | 40200 | 34938 | 20615 | 14400 | 9000 | 100.00% | 98.69% | 98.17% | 100.00% | 100.00% | 35 | 19859 - 99.29% | 1,516,818$ | 9,100,907$ | 20000 | 100 | 67,550,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 37,400,321$ | 37,400,321$ |
| 5 | Canadiens | 6500 | 5000 | 3000 | 2000 | 1500 | 105 | 93 | 76 | 62 | 120 | 19500 | 15000 | 9000 | 6000 | 4500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 1,511,550$ | 4,534,650$ | 18000 | 100 | 77,050,000$ | 7,975,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 65,687,831$ | 65,687,831$ |
| 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 | 54,869,167$ | 6,144,167$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 44,641,145$ | 44,641,145$ |
| 7 | Capitals | 7300 | 5700 | 2800 | 2000 | 1600 | 95 | 84 | 75 | 63 | 120 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19400 | 100 | 69,800,000$ | 575,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 52,164,874$ | 52,164,874$ |
| 8 | Devils | 6700 | 5700 | 4000 | 2200 | 1300 | 97 | 82 | 71 | 59 | 115 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19900 | 100 | 62,725,000$ | 2,075,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 10,051,508$ | 10,051,508$ |
| 9 | Ducks | 6500 | 5500 | 3500 | 1500 | 1500 | 91 | 79 | 65 | 58 | 125 | 32500 | 27500 | 17500 | 7500 | 7425 | 100.00% | 100.00% | 100.00% | 100.00% | 99.00% | 36 | 18485 - 99.92% | 1,373,513$ | 6,867,563$ | 18500 | 100 | 68,050,000$ | 1,150,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 19,765,786$ | 19,765,786$ |
| 10 | Flames | 7500 | 5500 | 2500 | 4500 | 2000 | 95 | 82 | 69 | 50 | 120 | 22265 | 16500 | 7500 | 10358 | 4926 | 98.96% | 100.00% | 100.00% | 76.73% | 82.10% | 38 | 20516 - 93.26% | 1,528,409$ | 4,585,226$ | 22000 | 100 | 81,100,000$ | 1,725,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 7,543,231$ | 7,543,231$ |
| 11 | Flyers | 6000 | 5000 | 3500 | 2000 | 1500 | 88 | 74 | 65 | 50 | 115 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 60,063,000$ | 6,550,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 66,799,629$ | 66,799,629$ |
| 12 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 85 | 73 | 61 | 50 | 115 | 60000 | 50000 | 20000 | 37749 | 10000 | 100.00% | 100.00% | 100.00% | 94.37% | 100.00% | 31 | 17775 - 98.75% | 1,170,671$ | 11,706,705$ | 18000 | 100 | 67,700,000$ | 1,000,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 43,290,833$ | 43,290,833$ |
| 13 | Kings | 6500 | 5000 | 2500 | 2500 | 1500 | 90 | 79 | 75 | 65 | 120 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 88,219,167$ | 5,969,167$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 31,540,267$ | 31,540,267$ |
| 14 | Maple Leafs | 6000 | 6000 | 4700 | 2000 | 1300 | 105 | 91 | 80 | 69 | 120 | 24000 | 23839 | 16094 | 8000 | 5200 | 100.00% | 99.33% | 85.61% | 100.00% | 100.00% | 37 | 19283 - 96.42% | 1,609,396$ | 6,437,582$ | 20000 | 100 | 71,050,000$ | 1,000,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 31,869,756$ | 31,869,756$ |
| 15 | Oilers | 6600 | 5800 | 2800 | 5000 | 1800 | 91 | 79 | 65 | 50 | 120 | 19800 | 17400 | 8400 | 10716 | 5082 | 100.00% | 100.00% | 100.00% | 71.44% | 94.11% | 38 | 20466 - 93.03% | 1,460,412$ | 4,381,236$ | 22000 | 100 | 72,644,000$ | 11,644,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 80,722,880$ | 80,722,880$ |
| 16 | Penguins | 6400 | 5400 | 4400 | 2400 | 1400 | 96 | 83 | 71 | 59 | 120 | 12800 | 10800 | 7019 | 4800 | 2800 | 100.00% | 100.00% | 79.76% | 100.00% | 100.00% | 39 | 19110 - 95.55% | 1,459,237$ | 2,918,474$ | 20000 | 100 | 68,650,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 53,282,956$ | 53,282,956$ |
| 17 | Predators | 6500 | 5500 | 2500 | 4400 | 1100 | 90 | 78 | 65 | 51 | 115 | 32500 | 27500 | 12500 | 17998 | 5500 | 100.00% | 100.00% | 100.00% | 81.81% | 100.00% | 36 | 19200 - 96.00% | 1,337,922$ | 6,689,608$ | 20000 | 100 | 58,250,000$ | 13,500,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 73,270,279$ | 73,270,279$ |
| 18 | Rangers | 6000 | 5000 | 3000 | 2500 | 1500 | 96 | 82 | 71 | 58 | 120 | 18000 | 15000 | 9000 | 7500 | 4500 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 1,371,600$ | 4,114,800$ | 18000 | 100 | 58,825,000$ | 6,000,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 80,073,886$ | 80,073,886$ |
| 19 | Red Wings | 6500 | 5000 | 4500 | 2000 | 1500 | 97 | 88 | 74 | 61 | 120 | 32029 | 24587 | 18061 | 10000 | 7500 | 98.55% | 98.35% | 80.27% | 100.00% | 100.00% | 36 | 18435 - 94.54% | 1,461,057$ | 7,305,284$ | 19500 | 100 | 88,008,000$ | 2,233,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | -5,483,822$ | -5,483,822$ |
| 20 | Sabres | 6000 | 5000 | 4000 | 3000 | 1200 | 97 | 82 | 70 | 56 | 120 | 78000 | 65000 | 48981 | 39000 | 15600 | 100.00% | 100.00% | 94.19% | 100.00% | 100.00% | 28 | 18968 - 98.79% | 1,410,969$ | 18,342,603$ | 19200 | 100 | 75,036,667$ | 1,261,667$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 82,732,133$ | 82,732,133$ |
| 21 | Senateurs | 6500 | 5000 | 4000 | 2000 | 1500 | 91 | 82 | 73 | 58 | 115 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 70,175,000$ | 1,100,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 23,679,548$ | 23,679,548$ |
| 22 | Sharks | 6500 | 5000 | 3000 | 4000 | 1500 | 100 | 81 | 65 | 50 | 120 | 19500 | 15000 | 9000 | 10362 | 4500 | 100.00% | 100.00% | 100.00% | 86.35% | 100.00% | 38 | 19454 - 97.27% | 1,442,430$ | 4,327,290$ | 20000 | 100 | 63,900,000$ | 1,150,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 54,696,890$ | 54,696,890$ |
| 23 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 96 | 84 | 70 | 56 | 120 | 18000 | 15000 | 6000 | 10514 | 3000 | 100.00% | 100.00% | 100.00% | 87.62% | 100.00% | 38 | 17505 - 97.25% | 1,307,035$ | 3,921,105$ | 18000 | 100 | 59,500,000$ | 4,900,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 28,302,386$ | 28,302,386$ |
| 24 | Wild | 6500 | 5500 | 4000 | 3000 | 1000 | 128 | 95 | 66 | 63 | 255 | 62084 | 53212 | 39000 | 29310 | 9770 | 86.83% | 87.95% | 88.64% | 88.82% | 88.82% | 30 | 17580 - 87.90% | 8,590,412$ | 94,494,533$ | 20000 | 100 | 83,621,000$ | 4,075,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -40,000,000$ | 85,000,000$ | 85,000,000$ | 156,098,095$ | 156,098,095$ |