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 49,360,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 | 77,329,167$ | 77,329,167$ | -3,500,000$ | 0$ | 0$ | 0$ | 27 | 2 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 184,563,438$ | 184,563,438$ |
2 | Boston | 6105 | 5180 | 2035 | 4070 | 1110 | 180 | 100 | 99 | 98 | 350 | 9751 | 8228 | 3082 | 4042 | 2030 | 79.86% | 79.42% | 75.72% | 49.66% | 91.44% | 39 | 13567 - 73.33% | 2,593,314$ | 5,186,628$ | 18500 | 100 | 70,470,836$ | 69,831,947$ | 2,246,823$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 195,176,045$ | 195,176,045$ |
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 | 64,863,335$ | 64,577,621$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 167,660,105$ | 167,660,105$ |
4 | Calgary | 6500 | 5250 | 2250 | 4000 | 1500 | 200 | 100 | 100 | 100 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19500 | 100 | 66,257,502$ | 66,400,359$ | -1,190,476$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 307,804,710$ | 307,804,710$ |
5 | Caroline | 6000 | 5000 | 2000 | 4000 | 1000 | 140 | 82 | 64 | 42 | 299 | 36000 | 30000 | 12000 | 24000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 18000 - 100.00% | 2,398,500$ | 14,391,000$ | 18000 | 100 | 68,887,169$ | 70,601,455$ | 307,334$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 192,940,315$ | 192,940,315$ |
6 | Chicago | 7000 | 6000 | 2500 | 5000 | 1500 | 200 | 100 | 99 | 98 | 400 | 12799 | 12192 | 4951 | 6257 | 2700 | 60.95% | 67.73% | 66.01% | 41.71% | 60.00% | 38 | 12966 - 58.94% | 2,583,679$ | 7,751,036$ | 22000 | 100 | 71,995,000$ | 72,995,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 472,854,505$ | 472,854,505$ |
7 | Colorado | 6000 | 5000 | 2500 | 4000 | 1000 | 160 | 100 | 65 | 40 | 300 | 31950 | 26214 | 14984 | 24000 | 6000 | 88.75% | 87.38% | 99.89% | 100.00% | 100.00% | 35 | 17191 - 92.93% | 2,484,595$ | 14,907,568$ | 18500 | 100 | 71,327,779$ | 71,470,636$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 299,446,903$ | 299,446,903$ |
8 | Columbus | 6700 | 5800 | 3000 | 5000 | 1500 | 135 | 70 | 50 | 35 | 260 | 19663 | 16941 | 8681 | 13829 | 4253 | 97.83% | 97.36% | 96.46% | 92.19% | 94.51% | 38 | 21122 - 96.01% | 2,541,162$ | 7,623,485$ | 22000 | 100 | 71,460,621$ | 71,679,668$ | -1,696,429$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 303,877,539$ | 303,877,539$ |
9 | Dallas | 6000 | 5000 | 2000 | 4000 | 1000 | 115 | 67 | 65 | 27 | 275 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 1,999,400$ | 5,998,200$ | 18000 | 100 | 66,444,947$ | 66,444,947$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 134,801,543$ | 134,801,543$ |
10 | Detroit | 7500 | 6000 | 2000 | 5000 | 1500 | 150 | 100 | 99 | 98 | 400 | 15902 | 12570 | 4955 | 6530 | 2739 | 70.68% | 69.83% | 82.58% | 43.53% | 60.87% | 38 | 14232 - 64.69% | 2,542,967$ | 7,628,900$ | 22000 | 100 | 67,487,548$ | 67,558,977$ | 429$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 355,904,507$ | 355,904,507$ |
11 | Edmonton | 6000 | 5000 | 2500 | 4000 | 1750 | 180 | 100 | 50 | 20 | 400 | 13800 | 12415 | 7500 | 12000 | 2622 | 76.67% | 82.77% | 100.00% | 100.00% | 49.94% | 38 | 16112 - 83.70% | 2,335,363$ | 7,006,090$ | 19250 | 100 | 73,735,000$ | 73,985,000$ | 0$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 194,439,947$ | 194,439,947$ |
12 | Hartford | 7000 | 5000 | 2500 | 4000 | 1500 | 110 | 87 | 68 | 55 | 215 | 13981 | 8747 | 4686 | 6832 | 2987 | 99.86% | 87.47% | 93.72% | 85.40% | 99.57% | 39 | 18617 - 93.08% | 2,363,083$ | 4,726,166$ | 20000 | 100 | 69,685,002$ | 70,601,669$ | 689,270$ | 0$ | 0$ | 0$ | 28 | 1 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 247,531,926$ | 247,531,926$ |
13 | Islanders | 6500 | 5000 | 2000 | 4000 | 1000 | 110 | 75 | 50 | 37 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 67,538,206$ | 67,399,634$ | -2,380,952$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 173,750,453$ | 173,750,453$ |
14 | Kansas City | 240 | 6000 | 3000 | 4000 | 1500 | 185 | 100 | 60 | 55 | 399 | 720 | 12096 | 8569 | 10522 | 2846 | 100.00% | 67.20% | 95.21% | 87.68% | 63.24% | 38 | 11584 - 78.59% | 1,547,522$ | 4,642,565$ | 14740 | 100 | 68,345,000$ | 68,345,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 221,084,008$ | 221,084,008$ |
15 | LA Kings | 6000 | 5000 | 3500 | 4000 | 1500 | 120 | 70 | 30 | 25 | 160 | 18000 | 15000 | 9399 | 12000 | 4415 | 100.00% | 100.00% | 89.51% | 100.00% | 98.11% | 38 | 19605 - 98.02% | 1,949,294$ | 5,847,881$ | 20000 | 100 | 63,780,000$ | 64,565,714$ | -440,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 238,140,406$ | 238,140,406$ |
16 | Las Vegas | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 27002 | 24934 | 10142 | 13406 | 5543 | 75.01% | 83.11% | 84.52% | 55.86% | 92.38% | 35 | 13505 - 75.03% | 2,692,917$ | 16,157,500$ | 18000 | 100 | 66,477,168$ | 67,977,168$ | -1,033,333$ | 0$ | 0$ | 0$ | 22 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 173,778,419$ | 173,778,419$ |
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 | 56,623,335$ | 57,290,002$ | 3,500,000$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 76,787,262$ | 76,787,262$ |
18 | Montreal | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 76 | 400 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 57,751,927$ | 57,753,032$ | 1,896,000$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 273,198,411$ | 273,198,411$ |
19 | Nashville | 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,206,669$ | 46,206,669$ | 16,197,889$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 259,173,218$ | 259,173,218$ |
20 | Ottawa | 7500 | 6000 | 2000 | 5000 | 1500 | 175 | 100 | 99 | 95 | 400 | 25834 | 21236 | 8869 | 11713 | 4593 | 68.89% | 70.79% | 88.69% | 46.85% | 61.24% | 36 | 14449 - 65.68% | 2,722,854$ | 13,614,272$ | 22000 | 100 | 76,442,333$ | 76,442,333$ | 0$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 340,747,446$ | 340,747,446$ |
21 | Philadelphie | 7000 | 5000 | 2500 | 3837 | 1200 | 110 | 80 | 60 | 50 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 19537 | 100 | 52,207,058$ | 52,207,058$ | -1,041,667$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 187,162,899$ | 187,162,899$ |
22 | 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 | 77,644,167$ | 77,144,167$ | -1,604,167$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 278,785,259$ | 278,785,259$ |
23 | Quebec | 7000 | 4000 | 3000 | 3500 | 1000 | 200 | 100 | 75 | 50 | 400 | 8684 | 8000 | 4161 | 7000 | 1699 | 62.03% | 100.00% | 69.35% | 100.00% | 84.95% | 39 | 14772 - 79.85% | 2,521,009$ | 5,042,017$ | 18500 | 100 | 71,414,501$ | 71,414,501$ | 0$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 169,950,217$ | 169,950,217$ |
24 | 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 | 58,676,391$ | 58,841,206$ | 4,571,429$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 172,499,533$ | 172,499,533$ |
25 | San Jose | 6600 | 5600 | 2650 | 5000 | 1000 | 130 | 80 | 55 | 40 | 344 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20850 | 100 | 53,579,500$ | 52,722,357$ | 1,234,740$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 218,209,424$ | 218,209,424$ |
26 | Seattle | 6000 | 5000 | 2500 | 4000 | 1000 | 100 | 60 | 40 | 30 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 78,786,111$ | 77,571,825$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 54,984,058$ | 54,984,058$ |
27 | St-Louis | 6500 | 5500 | 3500 | 3000 | 1500 | 200 | 100 | 99 | 75 | 395 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 20000 | 100 | 67,451,988$ | 65,651,988$ | 1,033,333$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 411,866,048$ | 411,866,048$ |
28 | 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 | 63,680,000$ | 63,680,000$ | -595,833$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 259,725,107$ | 259,725,107$ |
29 | Toronto | 6000 | 5000 | 2500 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 12110 | 12498 | 5059 | 6763 | 2791 | 67.28% | 83.32% | 67.45% | 56.36% | 93.03% | 38 | 13074 - 70.67% | 2,579,120$ | 7,737,360$ | 18500 | 100 | 69,301,667$ | 68,956,429$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 103,629,330$ | 103,629,330$ |
30 | Vancouver | 5000 | 7000 | 4000 | 4000 | 2000 | 120 | 70 | 50 | 20 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 22000 | 100 | 70,535,838$ | 71,035,838$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 145,619,177$ | 145,619,177$ |
31 | Washington | 6000 | 5000 | 2500 | 4000 | 1000 | 130 | 85 | 40 | 30 | 220 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 41 | 0 - 0% | 0$ | 0$ | 18500 | 100 | 71,521,461$ | 71,521,461$ | 0$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 162,276,138$ | 162,276,138$ |
32 | Winnipeg | 6500 | 5500 | 2500 | 4000 | 1500 | 105 | 75 | 60 | 50 | 200 | 19442 | 16363 | 7500 | 11974 | 4406 | 99.70% | 99.17% | 100.00% | 99.78% | 97.91% | 38 | 19895 - 99.48% | 2,252,698$ | 6,758,095$ | 20000 | 100 | 75,773,449$ | 75,973,449$ | 0$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 0$ | 10 | 0$ | 0$ | 0$ | 0$ | -49,360,000$ | 66,800,000$ | 66,800,000$ | 154,897,555$ | 154,897,555$ |