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 50,000,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
1 | Avalanche | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 80,227,776$ | 74,186,109$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -63,217,051$ | -63,217,051$ |
2 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 175 | 100 | 75 | 50 | 350 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 1 | 18000 - 100.00% | 3,352,500$ | 13,410,000$ | 18000 | 100 | 82,638,000$ | 71,679,667$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -46,583,053$ | -46,583,053$ |
3 | Blue Jackets | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 45 | 35 | 300 | 30000 | 25000 | 10000 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 0 | 18000 - 100.00% | 2,384,000$ | 11,920,000$ | 18000 | 100 | 75,375,557$ | 73,761,667$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -46,949,662$ | -46,949,662$ |
4 | Blues | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 80 | 50 | 25 | 180 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 78,232,208$ | 75,886,665$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -33,641,100$ | -33,641,100$ |
5 | Bruins | 6500 | 5500 | 2500 | 4500 | 2000 | 301 | 278 | 230 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 21000 | 100 | 76,999,119$ | 74,399,119$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -42,224,141$ | -42,224,141$ |
6 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 350 | 300 | 250 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 78,715,125$ | 68,665,125$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -37,293,794$ | -37,293,794$ |
7 | Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 68,018,093$ | 68,018,056$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -47,835,734$ | -47,835,734$ |
8 | Flames | 6250 | 5250 | 2500 | 4500 | 1500 | 155 | 125 | 75 | 65 | 300 | 12500 | 10259 | 4978 | 6375 | 2722 | 100.00% | 97.70% | 99.56% | 70.83% | 90.73% | 3 | 18417 - 92.09% | 3,594,029$ | 7,188,058$ | 20000 | 100 | 55,414,166$ | 49,720,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -1,804,397$ | -1,804,397$ |
9 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 240 | 160 | 90 | 70 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 69,507,251$ | 68,132,251$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -39,593,529$ | -39,593,529$ |
10 | 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% | 5 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 80,890,833$ | 74,547,083$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -52,952,832$ | -52,952,832$ |
11 | Jets | 6200 | 5000 | 2000 | 4000 | 1800 | 350 | 300 | 250 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 19000 | 100 | 82,321,311$ | 74,433,810$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -63,621,436$ | -63,621,436$ |
12 | 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% | 5 | 0 - 0.00% | 0$ | 0$ | 20000 | 100 | 80,834,761$ | 71,334,761$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -59,998,552$ | -59,998,552$ |
13 | Lightning | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 100 | 80 | 40 | 275 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 80,584,167$ | 80,659,167$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -40,434,543$ | -40,434,543$ |
14 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 125 | 75 | 50 | 500 | 22209 | 20000 | 8000 | 16000 | 3495 | 92.54% | 100.00% | 100.00% | 100.00% | 87.38% | 1 | 17426 - 96.81% | 3,758,264$ | 15,033,057$ | 18000 | 100 | 80,700,006$ | 63,470,340$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -58,551,396$ | -58,551,396$ |
15 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 70 | 45 | 35 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 79,406,333$ | 78,356,333$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -50,187,801$ | -50,187,801$ |
16 | Penguins | 4000 | 4500 | 5500 | 7000 | 3000 | 120 | 100 | 65 | 25 | 150 | 8000 | 9000 | 9350 | 11900 | 5100 | 100.00% | 100.00% | 85.00% | 85.00% | 85.00% | 3 | 21675 - 90.31% | 2,630,036$ | 5,260,072$ | 24000 | 100 | 81,252,364$ | 73,600,126$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -48,754,637$ | -48,754,637$ |
17 | Predators | 6000 | 5000 | 2000 | 4000 | 1000 | 130 | 80 | 60 | 30 | 220 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 77,905,000$ | 69,655,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -64,125,593$ | -64,125,593$ |
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% | 5 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 76,679,254$ | 73,204,254$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -31,438,910$ | -31,438,910$ |
19 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 154 | 82 | 65 | 44 | 306 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 1 | 18000 - 100.00% | 2,899,540$ | 11,598,160$ | 18000 | 100 | 81,145,833$ | 78,158,333$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -43,150,085$ | -43,150,085$ |
20 | Senators | 6000 | 5000 | 2000 | 4000 | 1000 | 160 | 78 | 45 | 35 | 260 | 12000 | 10000 | 4000 | 8000 | 2000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 3 | 18000 - 100.00% | 2,741,600$ | 5,483,200$ | 18000 | 100 | 71,810,555$ | 67,435,555$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -31,914,023$ | -31,914,023$ |
21 | Sharks | 6000 | 5000 | 3000 | 4000 | 2000 | 90 | 75 | 55 | 45 | 150 | 18000 | 15000 | 7980 | 12000 | 4816 | 100.00% | 100.00% | 88.67% | 100.00% | 80.27% | 2 | 19265 - 96.33% | 2,208,329$ | 6,624,987$ | 20000 | 100 | 69,379,170$ | 61,979,170$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -56,614,072$ | -56,614,072$ |
22 | Stars | 6000 | 5000 | 2000 | 4000 | 1000 | 300 | 200 | 150 | 100 | 500 | 0 | 0 | 0 | 0 | 0 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 18000 | 100 | 72,035,129$ | 73,860,129$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 1 | 0$ | 0$ | 0$ | 0$ | -50,000,000$ | 83,500,000$ | 83,500,000$ | -45,687,616$ | -45,687,616$ |