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 52,000,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
1 | Anaheim | 6000 | 5000 | 3000 | 3000 | 1500 | 175 | 90 | 65 | 40 | 325 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 64,271,667$ | 64,271,667$ | -3,500,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 200,711,033$ | 200,711,033$ |
2 | Boston | 6105 | 5180 | 2035 | 4070 | 1110 | 180 | 100 | 99 | 98 | 350 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 60,539,336$ | 57,359,336$ | 2,410,000$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 220,980,825$ | 220,980,825$ |
3 | Buffalo | 7500 | 6000 | 2500 | 4000 | 2000 | 125 | 75 | 50 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 65,328,333$ | 63,605,952$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 188,276,639$ | 188,276,639$ |
4 | Calgary | 6500 | 5250 | 2250 | 4000 | 1500 | 200 | 100 | 100 | 100 | 400 | 12530 | 12109 | 4768 | 6299 | 2742 | 64.26% | 76.88% | 70.64% | 52.49% | 60.93% | 38 | 12816 - 65.72% | 2,565,507$ | 7,696,520$ | 19500 | 100 | 68,491,667$ | 68,491,667$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 340,360,736$ | 340,360,736$ |
5 | Caroline | 6000 | 5000 | 2000 | 4000 | 1000 | 140 | 82 | 64 | 42 | 299 | 29980 | 25000 | 10000 | 20000 | 5000 | 99.93% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 17996 - 99.98% | 2,397,772$ | 11,988,860$ | 18000 | 100 | 66,070,000$ | 66,664,288$ | 0$ | 0$ | 0$ | 0$ | 23 | 1 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 260,944,796$ | 260,944,796$ |
6 | Chicago | 7000 | 6000 | 2500 | 5000 | 1500 | 200 | 100 | 99 | 98 | 400 | 43138 | 41822 | 17023 | 23434 | 9499 | 68.47% | 77.45% | 75.66% | 52.08% | 70.36% | 32 | 14991 - 68.14% | 2,974,286$ | 26,768,572$ | 22000 | 100 | 80,430,833$ | 78,603,688$ | -4,571,429$ | 0$ | 0$ | 0$ | 28 | 1 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 520,850,215$ | 520,850,215$ |
7 | Colorado | 6000 | 5000 | 2500 | 4000 | 1000 | 160 | 100 | 65 | 40 | 300 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 70,999,167$ | 67,239,168$ | 2,800,000$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 327,011,928$ | 327,011,928$ |
8 | Columbus | 6700 | 5800 | 3000 | 5000 | 1500 | 135 | 70 | 50 | 35 | 260 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 69,913,888$ | 66,986,112$ | -1,142,858$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 326,619,296$ | 326,619,296$ |
9 | Dallas | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 67 | 65 | 27 | 275 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 61,188,278$ | 60,568,279$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 156,838,718$ | 156,838,718$ |
10 | Detroit | 7500 | 6000 | 2000 | 5000 | 1500 | 150 | 100 | 99 | 98 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 69,384,491$ | 67,760,920$ | 1,552,428$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 378,973,878$ | 378,973,878$ |
11 | Edmonton | 6000 | 5000 | 2500 | 4000 | 1750 | 180 | 100 | 50 | 20 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19250 | 100 | 56,672,500$ | 52,122,500$ | 0$ | 0$ | 0$ | 0$ | 30 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 210,497,756$ | 210,497,756$ |
12 | Hartford | 7000 | 5000 | 2500 | 4000 | 1500 | 108 | 87 | 67 | 53 | 215 | 26034 | 19122 | 9246 | 14442 | 5767 | 92.98% | 95.61% | 92.46% | 90.26% | 96.12% | 37 | 18653 - 93.26% | 2,307,532$ | 9,230,128$ | 20000 | 100 | 82,777,500$ | 78,737,504$ | -4,000,000$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 280,677,198$ | 280,677,198$ |
13 | Islanders | 6500 | 5000 | 2000 | 4000 | 1000 | 160 | 100 | 80 | 60 | 400 | 51405 | 40000 | 16000 | 32000 | 7837 | 98.86% | 100.00% | 100.00% | 100.00% | 97.96% | 33 | 18405 - 99.49% | 2,416,968$ | 19,335,745$ | 18500 | 100 | 73,988,372$ | 69,641,941$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 206,773,830$ | 206,773,830$ |
14 | Kansas City | 240 | 6000 | 3000 | 4000 | 1500 | 185 | 100 | 60 | 55 | 399 | 720 | 12059 | 8397 | 11215 | 2733 | 100.00% | 66.99% | 93.30% | 93.46% | 60.73% | 38 | 11708 - 79.43% | 1,538,425$ | 4,615,275$ | 14740 | 100 | 75,920,000$ | 74,805,712$ | 46,429$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 209,881,946$ | 209,881,946$ |
15 | LA Kings | 6000 | 5000 | 3500 | 4000 | 1500 | 120 | 70 | 30 | 25 | 160 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 64,407,500$ | 63,582,500$ | 560,000$ | 0$ | 0$ | 0$ | 25 | 4 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 247,727,220$ | 247,727,220$ |
16 | Las Vegas | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 12350 | 12445 | 4856 | 6571 | 2627 | 68.61% | 82.97% | 80.93% | 54.76% | 87.57% | 38 | 12950 - 71.94% | 2,552,334$ | 7,657,002$ | 18000 | 100 | 71,775,000$ | 70,975,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 204,788,063$ | 204,788,063$ |
17 | Minnesota | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 63,024,166$ | 62,274,166$ | 3,500,000$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 80,625,607$ | 80,625,607$ |
18 | Montreal | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 76 | 400 | 7930 | 8448 | 3109 | 5481 | 1858 | 66.08% | 84.48% | 77.73% | 68.51% | 92.90% | 39 | 13413 - 74.52% | 2,533,926$ | 5,067,851$ | 18000 | 100 | 70,450,833$ | 63,750,832$ | 1,696,000$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 289,337,426$ | 289,337,426$ |
19 | Ottawa | 7500 | 6000 | 2000 | 5000 | 1500 | 175 | 100 | 99 | 95 | 400 | 63093 | 52418 | 20512 | 30807 | 11923 | 76.48% | 79.42% | 93.24% | 56.01% | 72.26% | 30 | 16250 - 73.86% | 3,073,865$ | 33,812,515$ | 22000 | 100 | 73,517,333$ | 69,877,328$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 407,212,918$ | 407,212,918$ |
20 | Philadelphie | 7000 | 5000 | 2500 | 3837 | 1200 | 110 | 80 | 60 | 50 | 150 | 13591 | 10000 | 5000 | 7674 | 2400 | 97.08% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 19333 - 98.95% | 2,170,162$ | 4,340,323$ | 19537 | 100 | 77,085,972$ | 72,355,974$ | 5,706,957$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 209,502,907$ | 209,502,907$ |
21 | Pittsburgh | 6100 | 5150 | 2650 | 4300 | 1050 | 144 | 84 | 59 | 36 | 316 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19250 | 100 | 74,039,167$ | 69,794,168$ | -2,500,000$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 310,815,684$ | 310,815,684$ |
22 | Quebec | 7000 | 4000 | 3000 | 3500 | 1000 | 200 | 100 | 75 | 50 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 70,031,277$ | 68,791,277$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 202,037,838$ | 202,037,838$ |
23 | Rangers | 6000 | 6000 | 2500 | 4000 | 1000 | 130 | 60 | 40 | 30 | 260 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19500 | 100 | 61,330,000$ | 59,330,000$ | 4,571,429$ | 0$ | 0$ | 0$ | 26 | 1 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 199,271,885$ | 199,271,885$ |
24 | San Jose | 6600 | 5600 | 2650 | 5000 | 1000 | 130 | 80 | 55 | 40 | 344 | 38803 | 33600 | 15900 | 27304 | 6000 | 97.99% | 100.00% | 100.00% | 91.01% | 100.00% | 35 | 20268 - 97.21% | 2,548,661$ | 15,291,965$ | 20850 | 100 | 76,151,716$ | 70,309,574$ | 2,110,000$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 257,366,194$ | 257,366,194$ |
25 | Seattle | 6000 | 5000 | 2500 | 4000 | 1000 | 100 | 60 | 40 | 30 | 200 | 30000 | 25000 | 12500 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18500 - 100.00% | 1,716,000$ | 8,580,000$ | 18500 | 100 | 74,050,000$ | 72,495,712$ | 1,940,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 72,865,469$ | 72,865,469$ |
26 | St-Louis | 6500 | 5500 | 3500 | 3000 | 1500 | 200 | 100 | 99 | 75 | 395 | 12773 | 12424 | 4846 | 7981 | 2709 | 65.50% | 75.30% | 46.15% | 88.68% | 60.20% | 38 | 13578 - 67.89% | 2,576,333$ | 7,728,999$ | 20000 | 100 | 70,464,375$ | 67,579,376$ | 674,667$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 443,619,459$ | 443,619,459$ |
27 | Tampa Bay | 6000 | 5000 | 2500 | 4000 | 1000 | 125 | 80 | 50 | 35 | 250 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 60,514,167$ | 58,414,167$ | 3,024,111$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 278,913,418$ | 278,913,418$ |
28 | Toronto | 6000 | 5000 | 2500 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 13159 | 12459 | 4830 | 6364 | 2850 | 73.11% | 83.06% | 64.40% | 53.03% | 95.00% | 38 | 13221 - 71.46% | 2,651,801$ | 7,955,404$ | 18500 | 100 | 75,274,167$ | 73,537,496$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 135,512,835$ | 135,512,835$ |
29 | Utah | 6700 | 5800 | 3200 | 4500 | 1800 | 120 | 80 | 60 | 40 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 46,984,167$ | 44,341,668$ | 22,618,333$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 294,675,304$ | 294,675,304$ |
30 | Vancouver | 5000 | 7000 | 4000 | 4000 | 2000 | 125 | 72 | 52 | 25 | 206 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 70,893,500$ | 70,273,500$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 155,565,751$ | 155,565,751$ |
31 | Washington | 6000 | 5000 | 2500 | 4000 | 1000 | 130 | 85 | 40 | 30 | 220 | 30000 | 25000 | 12500 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18500 - 100.00% | 2,138,500$ | 10,692,500$ | 18500 | 100 | 71,033,959$ | 70,233,959$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 191,680,781$ | 191,680,781$ |
32 | Winnipeg | 6500 | 5500 | 2500 | 4000 | 1500 | 105 | 75 | 60 | 50 | 200 | 52000 | 43655 | 20000 | 31997 | 11952 | 100.00% | 99.22% | 100.00% | 99.99% | 99.60% | 33 | 19951 - 99.75% | 2,262,711$ | 18,101,688$ | 20000 | 100 | 79,195,111$ | 73,035,112$ | 0$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 3 | 0$ | 0$ | 0$ | 0$ | -52,000,000$ | 70,400,000$ | 70,400,000$ | 210,947,455$ | 210,947,455$ |