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 | Salaire total moyen 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 50,000,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
1 | Avalanche | 6500 | 5500 | 2250 | 4250 | 1000 | 150 | 120 | 80 | 45 | 250 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 19500 | 100 | 77,651,943$ | 72,186,943$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 19,831,384$ | 19,831,384$ |
2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 175 | 100 | 75 | 50 | 350 | 42000 | 35000 | 14000 | 28000 | 7000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 34 | 18000 - 100.00% | 2,812,500$ | 19,687,500$ | 18000 | 100 | 81,608,699$ | 75,750,366$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 81,354,264$ | 81,354,264$ |
3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 45 | 35 | 300 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 2,000,000$ | 6,000,000$ | 18000 | 100 | 72,309,827$ | 70,859,664$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 26,348,439$ | 26,348,439$ |
4 | Blues | 6250 | 5250 | 2250 | 4250 | 1000 | 125 | 80 | 50 | 25 | 180 | 18750 | 15750 | 6750 | 12750 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 19000 - 100.00% | 2,000,000$ | 6,000,000$ | 19000 | 100 | 81,154,723$ | 71,604,723$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 16,673,148$ | 16,673,148$ |
5 | Bruins | 6500 | 5500 | 2500 | 4500 | 2000 | 350 | 300 | 250 | 100 | 500 | 19157 | 14497 | 6654 | 13764 | 5369 | 58.94% | 52.72% | 53.23% | 61.17% | 53.69% | 36 | 11888 - 56.61% | 4,194,613$ | 20,973,063$ | 21000 | 100 | 82,955,832$ | 81,255,832$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 101,613,857$ | 101,613,857$ |
6 | Canadiens | 7000 | 6000 | 3000 | 5000 | 2000 | 350 | 300 | 250 | 100 | 500 | 37538 | 28627 | 13611 | 27606 | 10431 | 59.58% | 53.01% | 50.41% | 61.35% | 57.95% | 32 | 13090 - 56.91% | 4,597,951$ | 41,381,562$ | 23000 | 100 | 78,759,999$ | 72,021,666$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 124,793,488$ | 124,793,488$ |
7 | Ducks | 8000 | 6000 | 3000 | 5000 | 2000 | 100 | 80 | 60 | 40 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 24000 | 100 | 63,527,315$ | 58,339,815$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 42,399,532$ | 42,399,532$ |
8 | Flames | 6500 | 5500 | 2750 | 4750 | 1750 | 156 | 125 | 76 | 60 | 300 | 13000 | 10921 | 5500 | 7496 | 3340 | 100.00% | 99.28% | 100.00% | 78.91% | 95.43% | 39 | 20129 - 94.72% | 3,289,303$ | 6,578,606$ | 21250 | 100 | 65,774,641$ | 58,480,475$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 113,555,852$ | 113,555,852$ |
9 | Flyers | 6250 | 5250 | 4500 | 4000 | 2000 | 240 | 150 | 90 | 70 | 450 | 18889 | 18544 | 11358 | 13738 | 4226 | 75.56% | 88.30% | 63.10% | 85.86% | 52.83% | 37 | 16689 - 75.86% | 3,500,169$ | 14,000,676$ | 22000 | 100 | 84,524,393$ | 76,924,393$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 68,859,515$ | 68,859,515$ |
10 | Golden Knights | 7000 | 5000 | 2000 | 4000 | 2000 | 135 | 90 | 70 | 40 | 220 | 35000 | 25000 | 10000 | 20000 | 9661 | 100.00% | 100.00% | 100.00% | 100.00% | 96.61% | 36 | 19932 - 99.66% | 2,627,605$ | 13,138,025$ | 20000 | 100 | 81,590,833$ | 80,465,833$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 24,296,070$ | 24,296,070$ |
11 | Islanders | 7000 | 6000 | 4000 | 4000 | 3000 | 350 | 300 | 250 | 100 | 500 | 14858 | 10919 | 6400 | 11091 | 4800 | 53.06% | 45.50% | 40.00% | 69.32% | 40.00% | 37 | 12017 - 50.07% | 4,245,344$ | 16,981,374$ | 24000 | 100 | 60,264,999$ | 58,264,999$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 98,925,855$ | 98,925,855$ |
12 | Jets | 6200 | 5000 | 2000 | 4000 | 2800 | 350 | 300 | 250 | 100 | 500 | 57851 | 44492 | 20890 | 42127 | 16630 | 71.78% | 68.45% | 80.35% | 81.01% | 45.69% | 28 | 13999 - 70.00% | 4,937,082$ | 64,182,062$ | 20000 | 100 | 82,865,476$ | 78,202,976$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 113,887,470$ | 113,887,470$ |
13 | Kings | 6500 | 5500 | 2500 | 4500 | 1000 | 200 | 100 | 50 | 40 | 270 | 10705 | 10910 | 5000 | 9000 | 2000 | 82.35% | 99.18% | 100.00% | 100.00% | 100.00% | 39 | 18808 - 94.04% | 2,738,750$ | 5,477,500$ | 20000 | 100 | 83,763,928$ | 78,188,928$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 22,034,659$ | 22,034,659$ |
14 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 160 | 110 | 90 | 50 | 300 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 81,809,500$ | 79,034,500$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 61,318,475$ | 61,318,475$ |
15 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 350 | 300 | 250 | 100 | 500 | 64469 | 52133 | 23755 | 43410 | 11926 | 89.54% | 86.89% | 98.98% | 90.44% | 99.38% | 29 | 16308 - 90.60% | 4,432,552$ | 53,190,624$ | 18000 | 100 | 73,751,752$ | 72,294,252$ | 0$ | 0$ | 0$ | 0$ | 22 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 91,738,634$ | 91,738,634$ |
16 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 120 | 75 | 65 | 285 | 18000 | 15000 | 6000 | 10646 | 3000 | 100.00% | 100.00% | 100.00% | 88.72% | 100.00% | 38 | 17549 - 97.49% | 2,707,079$ | 8,121,237$ | 18000 | 100 | 88,578,277$ | 82,703,277$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 24,108,364$ | 24,108,364$ |
17 | Penguins | 6000 | 5000 | 6000 | 7000 | 3000 | 120 | 100 | 65 | 25 | 150 | 18000 | 15000 | 15300 | 17850 | 7650 | 100.00% | 100.00% | 85.00% | 85.00% | 85.00% | 38 | 24600 - 91.11% | 2,603,438$ | 7,810,314$ | 27000 | 100 | 76,685,832$ | 67,105,832$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 28,398,420$ | 28,398,420$ |
18 | Rangers | 7400 | 6400 | 3400 | 5400 | 2400 | 145 | 120 | 75 | 50 | 310 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 25000 | 100 | 83,429,166$ | 79,041,666$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 61,220,982$ | 61,220,982$ |
19 | Red Wings | 6250 | 5250 | 2250 | 4250 | 1000 | 154 | 82 | 65 | 44 | 306 | 18750 | 15750 | 6750 | 12750 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 19000 - 100.00% | 2,540,312$ | 7,620,936$ | 19000 | 100 | 82,271,666$ | 78,288,333$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 20,575,917$ | 20,575,917$ |
20 | Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 195 | 115 | 80 | 65 | 287 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 69,564,164$ | 65,150,831$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 68,437,529$ | 68,437,529$ |
21 | Sharks | 6000 | 5000 | 3000 | 4000 | 2000 | 120 | 110 | 80 | 70 | 130 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 82,300,005$ | 78,175,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 14,174,584$ | 14,174,584$ |
22 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 150 | 115 | 70 | 275 | 29391 | 24620 | 10000 | 19301 | 5000 | 97.97% | 98.48% | 100.00% | 96.51% | 100.00% | 36 | 17662 - 98.12% | 3,225,317$ | 16,126,587$ | 18000 | 100 | 76,639,295$ | 80,207,628$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 84,000,000$ | 84,000,000$ | 71,345,951$ | 71,345,951$ |