| 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 0$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Avalanches | 8000 | 6000 | 3000 | 5000 | 1000 | 127 | 80 | 50 | 49 | 268 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 125 | 79,250,000$ | 79,250,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 71,278,280$ | 71,278,280$ |
| 2 | BlackHawks | 8000 | 6000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21000 | 125 | 79,250,000$ | 79,250,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 37,015,035$ | 37,015,035$ |
| 3 | BlueJacket | 8000 | 6000 | 3000 | 5000 | 1500 | 140 | 85 | 65 | 60 | 245 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23500 | 125 | 81,950,000$ | 81,950,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 69,085,565$ | 69,085,565$ |
| 4 | Blues | 8000 | 6000 | 3000 | 4000 | 1500 | 100 | 70 | 45 | 35 | 205 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22500 | 125 | 78,940,000$ | 78,940,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 90,130,586$ | 90,130,586$ |
| 5 | Bruins | 8000 | 6000 | 3000 | 5000 | 1500 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23500 | 125 | 70,250,000$ | 70,250,000$ | 0$ | 0$ | 0$ | 0$ | 18 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 64,936,915$ | 64,936,915$ |
| 6 | Canadiens | 8000 | 6000 | 3000 | 5000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 125 | 77,850,000$ | 77,850,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 70,332,632$ | 70,332,632$ |
| 7 | Canucks | 7000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19000 | 125 | 86,700,000$ | 86,700,000$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 83,589,315$ | 83,589,315$ |
| 8 | Capitals | 8000 | 5000 | 2000 | 4000 | 1000 | 145 | 90 | 70 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 125 | 77,150,000$ | 77,150,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 4,985,305$ | 4,985,305$ |
| 9 | Devils | 8000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 125 | 73,650,000$ | 73,650,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 42,865,049$ | 42,865,049$ |
| 10 | Ducks | 7000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19000 | 125 | 68,800,000$ | 68,800,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 49,986,806$ | 49,986,806$ |
| 11 | Flames | 8000 | 6000 | 3000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 125 | 80,255,000$ | 80,255,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 47,452,366$ | 47,452,366$ |
| 12 | Flyers | 8000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 125 | 79,550,000$ | 79,550,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 51,892,231$ | 51,892,231$ |
| 13 | GoldenKnights | 8000 | 6000 | 3000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 125 | 79,050,000$ | 79,050,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 86,892,328$ | 86,892,328$ |
| 14 | Hurricanes | 8000 | 6000 | 3000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 125 | 86,700,000$ | 86,700,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 30,687,569$ | 30,687,569$ |
| 15 | Islanders | 8000 | 6000 | 3000 | 5000 | 1500 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23500 | 125 | 80,750,000$ | 80,750,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 119,793,458$ | 119,793,458$ |
| 16 | Jets | 8000 | 6000 | 3000 | 5000 | 1000 | 135 | 71 | 70 | 55 | 265 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 125 | 79,250,000$ | 79,250,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 255,619,424$ | 255,619,424$ |
| 17 | Kings | 8000 | 6000 | 3000 | 5000 | 1000 | 140 | 100 | 75 | 70 | 230 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 125 | 80,350,001$ | 80,350,001$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 64,713,920$ | 64,713,920$ |
| 18 | Kraken | 8000 | 5000 | 2000 | 4000 | 1000 | 150 | 80 | 60 | 59 | 300 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 125 | 80,400,000$ | 80,400,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 32,262,241$ | 32,262,241$ |
| 19 | Lightning | 8000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 125 | 78,900,000$ | 78,900,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 10,607,946$ | 10,607,946$ |
| 20 | Mammoth | 8000 | 5000 | 2000 | 4000 | 1000 | 140 | 90 | 71 | 60 | 275 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 125 | 79,600,000$ | 79,600,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 67,828,831$ | 67,828,831$ |
| 21 | MapleLeafs | 8000 | 6000 | 2000 | 4000 | 1000 | 130 | 80 | 68 | 52 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21000 | 125 | 78,600,000$ | 78,600,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 49,823,486$ | 49,823,486$ |
| 22 | Oilers | 8000 | 5000 | 2000 | 4000 | 1000 | 133 | 83 | 63 | 56 | 300 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 125 | 79,500,000$ | 79,500,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 8,700,151$ | 8,700,151$ |
| 23 | Panthers | 8000 | 6000 | 3000 | 5000 | 1000 | 150 | 100 | 75 | 70 | 300 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23000 | 125 | 79,950,000$ | 79,950,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 158,578,776$ | 158,578,776$ |
| 24 | Penguins | 8000 | 6000 | 3000 | 5000 | 1500 | 140 | 80 | 58 | 55 | 225 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23500 | 125 | 78,650,000$ | 78,650,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 163,977,995$ | 163,977,995$ |
| 25 | Predators | 8000 | 6000 | 3000 | 5000 | 1500 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 23500 | 125 | 79,800,000$ | 79,800,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 24,874,789$ | 24,874,789$ |
| 26 | Rangers | 7000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19000 | 125 | 86,785,000$ | 86,785,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 11,263,729$ | 11,263,729$ |
| 27 | RedWings | 8000 | 6000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21000 | 125 | 82,550,000$ | 82,550,000$ | 0$ | 0$ | 0$ | 0$ | 19 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 30,140,128$ | 30,140,128$ |
| 28 | Sabres | 8000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 125 | 79,500,000$ | 79,500,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 18,696,779$ | 18,696,779$ |
| 29 | Senators | 8000 | 6000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 21000 | 125 | 82,400,000$ | 82,400,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 47,930,023$ | 47,930,023$ |
| 30 | Sharks | 8000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 125 | 82,200,000$ | 82,200,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 70,229,177$ | 70,229,177$ |
| 31 | Stars | 8000 | 6000 | 3000 | 4000 | 1000 | 125 | 75 | 50 | 50 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 125 | 78,800,000$ | 78,800,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 125,746,402$ | 125,746,402$ |
| 32 | Wild | 8000 | 6000 | 3000 | 4000 | 1000 | 128 | 78 | 56 | 55 | 280 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 125 | 80,000,000$ | 80,000,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | 0$ | 80,000,000$ | 80,000,000$ | 30,845,212$ | 30,845,212$ |