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 | 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é | 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 50,000,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 71 | 70 | 50 | 40 | 230 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 74,077,776$ | 68,036,109$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -6,757,941$ | -6,757,941$ |
2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 175 | 100 | 75 | 50 | 350 | 65958 | 55000 | 22000 | 44000 | 11000 | 99.94% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 17996 - 99.98% | 2,811,665$ | 30,928,312$ | 18000 | 100 | 78,569,667$ | 70,373,834$ | 0$ | 0$ | 0$ | 0$ | 21 | 2 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 65,961,108$ | 65,961,108$ |
3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 45 | 35 | 300 | 84000 | 70000 | 28000 | 56000 | 14000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 27 | 18000 - 100.00% | 2,000,000$ | 28,000,000$ | 18000 | 100 | 70,706,388$ | 69,317,500$ | 0$ | 0$ | 0$ | 0$ | 21 | 1 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 39,238,782$ | 39,238,782$ |
4 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 50 | 25 | 180 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,912,500$ | 3,825,000$ | 18000 | 100 | 85,691,389$ | 81,872,639$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 28,717,580$ | 28,717,580$ |
5 | Bruins | 6500 | 5500 | 2500 | 4500 | 2000 | 350 | 300 | 250 | 100 | 500 | 33444 | 24383 | 9832 | 21887 | 7295 | 64.32% | 55.42% | 49.16% | 60.80% | 45.59% | 33 | 12105 - 57.64% | 4,000,193$ | 32,001,542$ | 21000 | 100 | 80,734,999$ | 75,174,166$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 80,929,066$ | 80,929,066$ |
6 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 350 | 300 | 250 | 100 | 500 | 9596 | 7245 | 2912 | 7144 | 2408 | 53.31% | 48.30% | 48.53% | 59.53% | 80.27% | 38 | 9768 - 54.27% | 3,407,708$ | 10,223,125$ | 18000 | 100 | 82,860,959$ | 74,860,959$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 67,443,947$ | 67,443,947$ |
7 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 80 | 70 | 50 | 300 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 2,425,000$ | 4,850,000$ | 18000 | 100 | 63,355,351$ | 63,355,314$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 44,333,165$ | 44,333,165$ |
8 | Flames | 6250 | 5250 | 2500 | 4500 | 1500 | 155 | 125 | 75 | 63 | 300 | 62500 | 52500 | 25000 | 39593 | 14661 | 100.00% | 100.00% | 100.00% | 87.98% | 97.74% | 31 | 19425 - 97.13% | 3,127,207$ | 31,272,074$ | 20000 | 100 | 57,689,166$ | 51,870,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 120,727,899$ | 120,727,899$ |
9 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 240 | 160 | 90 | 70 | 500 | 33999 | 30806 | 14000 | 23564 | 6151 | 80.95% | 88.02% | 100.00% | 84.16% | 87.87% | 34 | 15503 - 86.13% | 3,406,018$ | 23,842,125$ | 18000 | 100 | 78,469,751$ | 77,726,001$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 72,977,812$ | 72,977,812$ |
10 | Golden Knights | 6000 | 5000 | 2000 | 4000 | 1000 | 130 | 80 | 60 | 30 | 220 | 36000 | 30000 | 12000 | 24000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 18000 - 100.00% | 2,050,000$ | 12,300,000$ | 18000 | 100 | 83,180,000$ | 77,680,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 17,249,065$ | 17,249,065$ |
11 | Islanders | 6500 | 5500 | 2500 | 4000 | 1500 | 350 | 300 | 250 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 76,885,499$ | 71,647,999$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 41,119,703$ | 41,119,703$ |
12 | Jets | 6200 | 5000 | 2000 | 4000 | 1800 | 350 | 300 | 250 | 100 | 500 | 20889 | 16172 | 6652 | 15327 | 5326 | 56.15% | 53.91% | 55.43% | 63.86% | 49.31% | 35 | 10728 - 56.46% | 3,754,469$ | 22,526,812$ | 19000 | 100 | 73,764,017$ | 71,232,767$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 59,201,228$ | 59,201,228$ |
13 | Kings | 6500 | 5500 | 2500 | 4500 | 1000 | 200 | 100 | 50 | 40 | 270 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 73,951,105$ | 67,951,093$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 25,446,159$ | 25,446,159$ |
14 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 100 | 80 | 40 | 275 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 2,493,750$ | 7,481,250$ | 18000 | 100 | 81,809,167$ | 82,259,167$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 51,571,809$ | 51,571,809$ |
15 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 125 | 75 | 50 | 500 | 10902 | 10000 | 4000 | 8000 | 1653 | 90.85% | 100.00% | 100.00% | 100.00% | 82.65% | 39 | 17278 - 95.99% | 3,098,063$ | 6,196,125$ | 18000 | 100 | 84,620,007$ | 67,390,341$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 17,407,822$ | 17,407,822$ |
16 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 130 | 100 | 55 | 45 | 250 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 2,275,000$ | 9,100,000$ | 18000 | 100 | 83,875,000$ | 80,350,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 26,710,059$ | 26,710,059$ |
17 | Penguins | 4000 | 4500 | 5500 | 7000 | 3000 | 120 | 100 | 65 | 25 | 150 | 20000 | 22500 | 23375 | 30164 | 12750 | 100.00% | 100.00% | 85.00% | 86.18% | 85.00% | 36 | 21758 - 90.66% | 2,208,994$ | 11,044,968$ | 24000 | 100 | 82,095,698$ | 76,718,460$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 34,344,836$ | 34,344,836$ |
18 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 120 | 100 | 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 | 82,080,087$ | 75,355,087$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 58,825,543$ | 58,825,543$ |
19 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 154 | 82 | 65 | 44 | 306 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 41 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 75,165,083$ | 70,971,333$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 30,584,215$ | 30,584,215$ |
20 | Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 160 | 78 | 45 | 35 | 260 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 2,300,000$ | 6,900,000$ | 18000 | 100 | 72,145,833$ | 67,083,333$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 47,830,075$ | 47,830,075$ |
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 | 76,490,836$ | 68,028,336$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 8,620,689$ | 8,620,689$ |
22 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 185 | 132 | 95 | 60 | 240 | 11807 | 9925 | 4000 | 7165 | 2000 | 98.39% | 99.25% | 100.00% | 89.56% | 100.00% | 39 | 17449 - 96.94% | 2,990,185$ | 5,980,369$ | 18000 | 100 | 77,228,588$ | 77,696,795$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | 48,675,533$ | 48,675,533$ |