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 48,160,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
1 | Anaheim | 6000 | 5000 | 3000 | 3000 | 1500 | 175 | 90 | 65 | 40 | 325 | 171254 | 162127 | 89516 | 123000 | 39502 | 69.62% | 79.09% | 72.78% | 100.00% | 64.23% | 0 | 14278 - 77.18% | 1,661,892$ | 68,137,570$ | 18500 | 100 | 61,683,335$ | 61,497,621$ | 0$ | 62,208,141$ | 330,632$ | 62,021,430$ | 22 | 0 | 0$ | 0$ | 0 | 331,631$ | 0$ | 0$ | 64,364,769$ | 16,204,769$ | 65,200,000$ | 835,231$ | 129,230,073$ | 129,230,073$ |
2 | Boston | 6105 | 5180 | 2035 | 4070 | 1110 | 180 | 100 | 99 | 98 | 350 | 170336 | 146362 | 55154 | 69132 | 36844 | 68.05% | 68.92% | 66.10% | 41.43% | 80.96% | 0 | 11654 - 63.00% | 1,717,738$ | 70,427,262$ | 18500 | 100 | 55,770,500$ | 55,770,500$ | 590,000$ | 59,889,985$ | 299,841$ | 59,889,985$ | 21 | 0 | 0$ | 0$ | 0 | 299,841$ | 0$ | 0$ | 62,509,702$ | 14,349,702$ | 65,200,000$ | 2,690,298$ | 151,094,464$ | 151,094,464$ |
3 | Buffalo | 7500 | 6000 | 2500 | 4000 | 2000 | 125 | 75 | 50 | 30 | 200 | 257851 | 212707 | 101262 | 163358 | 54807 | 83.85% | 86.47% | 98.79% | 99.61% | 66.84% | 0 | 19268 - 87.58% | 1,685,601$ | 69,109,640$ | 22000 | 100 | 68,875,000$ | 68,875,000$ | 0$ | 63,408,686$ | 370,296$ | 63,408,686$ | 24 | 0 | 0$ | 0$ | 0 | 370,296$ | 0$ | 0$ | 65,413,302$ | 17,253,302$ | 65,200,000$ | -213,302$ | 126,039,894$ | 126,039,894$ |
4 | Calgary | 6500 | 5250 | 2250 | 4000 | 1500 | 200 | 100 | 100 | 100 | 400 | 151813 | 144526 | 53351 | 68026 | 32045 | 56.97% | 67.14% | 57.83% | 41.48% | 52.11% | 0 | 10970 - 56.26% | 1,701,729$ | 69,770,900$ | 19500 | 100 | 66,846,336$ | 66,846,336$ | 0$ | 63,021,061$ | 359,389$ | 61,902,771$ | 22 | 0 | 0$ | 0$ | 0 | 359,389$ | 0$ | 0$ | 63,527,568$ | 15,367,568$ | 65,200,000$ | 1,672,432$ | 236,724,697$ | 236,724,697$ |
5 | Caroline | 6000 | 5000 | 2000 | 4000 | 1000 | 140 | 82 | 64 | 42 | 299 | 243094 | 202501 | 82000 | 160192 | 41000 | 98.82% | 98.78% | 100.00% | 97.68% | 100.00% | 0 | 17775 - 98.75% | 1,826,178$ | 74,873,306$ | 18000 | 100 | 65,725,047$ | 66,193,500$ | -2,631,114$ | 63,805,977$ | 355,879$ | 64,557,752$ | 20 | 0 | 0$ | 0$ | 0 | 353,360$ | 0$ | 0$ | 65,227,714$ | 17,067,714$ | 65,200,000$ | -27,714$ | 112,339,814$ | 112,339,814$ |
6 | Chicago | 7000 | 6000 | 2500 | 5000 | 1500 | 200 | 100 | 99 | 98 | 400 | 151039 | 147724 | 54280 | 82000 | 32220 | 52.63% | 60.05% | 52.96% | 40.00% | 52.39% | 0 | 11397 - 51.80% | 1,738,486$ | 71,277,920$ | 22000 | 100 | 49,087,000$ | 52,987,000$ | 2,886,021$ | 52,640,631$ | 284,876$ | 55,558,369$ | 23 | 0 | 0$ | 0$ | 0 | 263,909$ | 0$ | 0$ | 60,867,452$ | 12,707,452$ | 65,200,000$ | 4,332,548$ | 401,294,586$ | 401,294,586$ |
7 | Colorado | 6000 | 5000 | 2500 | 4000 | 1000 | 160 | 100 | 65 | 40 | 300 | 190231 | 145836 | 90541 | 159097 | 40651 | 77.33% | 71.14% | 88.33% | 97.01% | 99.15% | 0 | 15277 - 82.58% | 1,694,266$ | 69,464,905$ | 18500 | 100 | 61,160,000$ | 61,944,524$ | 0$ | 61,413,189$ | 333,035$ | 62,247,427$ | 20 | 0 | 0$ | 0$ | 0 | 328,817$ | 0$ | 0$ | 64,761,840$ | 16,601,840$ | 65,200,000$ | 438,160$ | 212,527,751$ | 212,527,751$ |
8 | Columbus | 6700 | 5800 | 3000 | 5000 | 1500 | 135 | 70 | 50 | 35 | 260 | 259791 | 213001 | 103731 | 170810 | 52275 | 94.57% | 89.57% | 84.33% | 83.32% | 85.00% | 0 | 19503 - 88.65% | 1,822,884$ | 74,738,255$ | 22000 | 100 | 64,290,833$ | 61,340,833$ | 0$ | 66,174,319$ | 329,789$ | 62,580,774$ | 20 | 0 | 0$ | 0$ | 0 | 345,650$ | 0$ | 0$ | 64,862,224$ | 16,702,224$ | 65,200,000$ | 337,776$ | 230,526,824$ | 230,526,824$ |
9 | Dallas | 6000 | 5000 | 2000 | 4000 | 1000 | 117 | 68 | 66 | 28 | 280 | 244689 | 203664 | 80153 | 163398 | 39738 | 99.47% | 99.35% | 97.75% | 99.63% | 96.92% | 0 | 17845 - 99.14% | 1,573,258$ | 64,503,569$ | 18000 | 100 | 59,892,503$ | 62,589,655$ | 1,300,000$ | 57,854,673$ | 336,504$ | 60,359,578$ | 23 | 0 | 0$ | 0$ | 0 | 322,003$ | 0$ | 0$ | 63,583,828$ | 15,423,828$ | 65,200,000$ | 1,616,172$ | 109,557,961$ | 109,557,961$ |
10 | Detroit | 7500 | 6000 | 2000 | 5000 | 1500 | 150 | 100 | 99 | 98 | 400 | 204263 | 146105 | 54767 | 82000 | 31652 | 66.43% | 59.39% | 66.79% | 40.00% | 51.47% | 0 | 12653 - 57.52% | 1,740,700$ | 71,368,683$ | 22000 | 100 | 67,319,223$ | 67,647,794$ | 520,967$ | 62,631,579$ | 363,698$ | 61,955,421$ | 25 | 0 | 0$ | 0$ | 0 | 361,931$ | 0$ | 0$ | 64,674,976$ | 16,514,976$ | 65,200,000$ | 525,024$ | 265,684,743$ | 265,684,743$ |
11 | Edmonton | 6000 | 5000 | 2500 | 4000 | 1750 | 180 | 100 | 50 | 20 | 400 | 167277 | 147188 | 100124 | 164000 | 31851 | 68.00% | 71.80% | 97.68% | 100.00% | 44.39% | 0 | 14889 - 77.34% | 1,606,226$ | 65,855,260$ | 19250 | 100 | 64,030,499$ | 63,959,071$ | 0$ | 61,558,807$ | 343,866$ | 61,473,559$ | 24 | 0 | 0$ | 0$ | 0 | 344,250$ | 0$ | 0$ | 63,762,185$ | 15,602,185$ | 65,200,000$ | 1,437,815$ | 175,139,251$ | 175,139,251$ |
12 | Hartford | 7000 | 5000 | 2500 | 4000 | 1500 | 107 | 84 | 63 | 50 | 209 | 267393 | 197190 | 97822 | 147950 | 53662 | 93.17% | 96.19% | 95.44% | 90.21% | 87.26% | 0 | 18635 - 93.17% | 1,703,967$ | 69,862,649$ | 20000 | 100 | 61,887,500$ | 62,120,833$ | 0$ | 60,890,640$ | 333,983$ | 60,705,914$ | 21 | 0 | 0$ | 0$ | 0 | 332,728$ | 0$ | 0$ | 63,166,776$ | 15,006,776$ | 65,200,000$ | 2,033,224$ | 200,527,557$ | 200,527,557$ |
13 | Islanders | 6500 | 5000 | 2000 | 4000 | 1000 | 110 | 75 | 50 | 37 | 400 | 258023 | 203059 | 82000 | 163197 | 32285 | 96.82% | 99.05% | 100.00% | 99.51% | 78.74% | 0 | 18014 - 97.37% | 1,568,428$ | 64,305,554$ | 18500 | 100 | 74,192,500$ | 72,021,071$ | -3,490,015$ | 68,504,274$ | 387,210$ | 66,760,531$ | 21 | 0 | 0$ | 0$ | 0 | 398,884$ | 0$ | 0$ | 65,376,125$ | 17,216,125$ | 65,200,000$ | -176,125$ | 158,283,666$ | 158,283,666$ |
14 | Kansas City | 7500 | 6000 | 3000 | 4000 | 1500 | 160 | 100 | 60 | 55 | 399 | 190391 | 145992 | 101991 | 122491 | 31682 | 61.92% | 59.35% | 82.92% | 74.69% | 51.52% | 0 | 14452 - 65.69% | 1,720,960$ | 70,559,343$ | 22000 | 100 | 64,189,167$ | 64,107,024$ | 0$ | 62,991,343$ | 344,661$ | 63,098,960$ | 21 | 0 | 0$ | 0$ | 0 | 345,103$ | 0$ | 0$ | 65,319,211$ | 17,159,211$ | 65,200,000$ | -119,211$ | 207,247,890$ | 207,247,890$ |
15 | LA Kings | 6000 | 5000 | 3500 | 4000 | 1500 | 120 | 70 | 30 | 25 | 160 | 244213 | 203169 | 115570 | 164000 | 57868 | 99.27% | 99.11% | 80.54% | 100.00% | 94.09% | 0 | 19142 - 95.71% | 1,472,033$ | 60,353,370$ | 20000 | 100 | 57,467,500$ | 55,848,453$ | 5,253,167$ | 57,290,885$ | 300,260$ | 55,663,136$ | 22 | 0 | 0$ | 0$ | 0 | 308,965$ | 0$ | 0$ | 63,122,455$ | 14,962,455$ | 65,200,000$ | 2,077,545$ | 221,514,459$ | 221,514,459$ |
16 | Las Vegas | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 98 | 400 | 152012 | 145386 | 54293 | 68190 | 32166 | 61.79% | 70.92% | 66.21% | 41.58% | 78.45% | 0 | 11026 - 61.25% | 1,704,025$ | 69,865,027$ | 18000 | 100 | 60,539,168$ | 61,239,168$ | 124,194$ | 61,618,542$ | 329,243$ | 62,322,307$ | 22 | 0 | 0$ | 0$ | 0 | 325,479$ | 0$ | 0$ | 64,146,463$ | 15,986,463$ | 65,200,000$ | 1,053,537$ | 103,423,583$ | 103,423,583$ |
17 | Minnesota | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 20 | 200 | 245699 | 204653 | 82000 | 164000 | 41000 | 99.88% | 99.83% | 100.00% | 100.00% | 100.00% | 0 | 17984 - 99.91% | 1,248,758$ | 51,199,080$ | 18000 | 100 | 63,647,000$ | 63,647,000$ | 0$ | 60,705,542$ | 342,188$ | 60,705,542$ | 22 | 0 | 0$ | 0$ | 0 | 342,188$ | 0$ | 0$ | 62,994,408$ | 14,834,408$ | 65,200,000$ | 2,205,592$ | 82,901,938$ | 82,901,938$ |
18 | Montreal | 6000 | 5000 | 2000 | 4000 | 1000 | 200 | 100 | 99 | 76 | 400 | 150523 | 145376 | 54490 | 88157 | 32012 | 61.19% | 70.92% | 66.45% | 53.75% | 78.08% | 0 | 11477 - 63.76% | 1,696,133$ | 69,541,442$ | 18000 | 100 | 63,560,000$ | 63,600,476$ | 2,724,839$ | 60,691,744$ | 341,938$ | 60,718,446$ | 21 | 0 | 0$ | 0$ | 0 | 341,720$ | 0$ | 0$ | 65,382,527$ | 17,222,527$ | 65,200,000$ | -182,527$ | 184,784,721$ | 184,784,721$ |
19 | Nashville | 6700 | 5800 | 3200 | 4500 | 1800 | 150 | 90 | 80 | 50 | 250 | 204456 | 163767 | 67656 | 149008 | 52682 | 74.43% | 68.87% | 51.57% | 80.76% | 71.38% | 0 | 15550 - 70.68% | 1,742,459$ | 71,440,810$ | 22000 | 100 | 58,395,000$ | 59,011,667$ | 1,905,925$ | 60,605,048$ | 317,267$ | 61,284,350$ | 21 | 0 | 0$ | 0$ | 0 | 313,952$ | 0$ | 0$ | 65,377,984$ | 17,217,984$ | 65,200,000$ | -177,984$ | 206,442,768$ | 206,442,768$ |
20 | Ottawa | 7500 | 6000 | 2000 | 5000 | 1500 | 175 | 100 | 100 | 95 | 400 | 171473 | 145559 | 54558 | 82000 | 31932 | 55.76% | 59.17% | 66.53% | 40.00% | 51.92% | 0 | 11842 - 53.83% | 1,721,519$ | 70,582,275$ | 22000 | 100 | 47,664,173$ | 47,664,173$ | 381,721$ | 57,065,483$ | 256,259$ | 57,065,483$ | 22 | 0 | 0$ | 0$ | 0 | 256,259$ | 0$ | 0$ | 59,245,050$ | 11,085,050$ | 65,200,000$ | 5,954,950$ | 272,339,414$ | 272,339,414$ |
21 | Philadelphie | 7000 | 5000 | 2500 | 3837 | 1200 | 110 | 80 | 60 | 50 | 150 | 261779 | 202670 | 98562 | 148986 | 49200 | 91.21% | 98.86% | 96.16% | 94.70% | 100.00% | 0 | 18566 - 95.03% | 1,603,715$ | 65,752,310$ | 19537 | 100 | 68,391,114$ | 67,460,162$ | -766,958$ | 65,389,358$ | 362,689$ | 64,391,595$ | 23 | 0 | 0$ | 0$ | 0 | 367,694$ | 0$ | 0$ | 65,506,735$ | 17,346,735$ | 65,200,000$ | -306,735$ | 150,631,400$ | 150,631,400$ |
22 | Pittsburgh | 6100 | 5150 | 2650 | 4300 | 1050 | 142 | 83 | 58 | 35 | 315 | 243843 | 204721 | 101082 | 168697 | 39891 | 97.50% | 96.96% | 93.03% | 95.69% | 92.66% | 0 | 18494 - 96.07% | 1,851,640$ | 75,917,231$ | 19250 | 100 | 56,992,000$ | 58,158,667$ | 1,612,903$ | 59,842,708$ | 312,681$ | 60,876,188$ | 21 | 0 | 0$ | 0$ | 0 | 306,409$ | 0$ | 0$ | 64,838,483$ | 16,678,483$ | 65,200,000$ | 361,517$ | 205,538,477$ | 205,538,477$ |
23 | Quebec | 7000 | 4000 | 3000 | 3500 | 1000 | 200 | 100 | 75 | 50 | 400 | 150361 | 147913 | 71817 | 138196 | 32042 | 52.39% | 90.19% | 58.39% | 96.30% | 78.15% | 0 | 13179 - 71.24% | 1,706,741$ | 69,976,375$ | 18500 | 100 | 63,941,262$ | 63,987,095$ | 0$ | 63,718,344$ | 344,017$ | 63,767,519$ | 22 | 0 | 0$ | 0$ | 0 | 343,770$ | 0$ | 0$ | 65,248,239$ | 17,088,239$ | 65,200,000$ | -48,239$ | 101,580,437$ | 101,580,437$ |
24 | Rangers | 6000 | 6000 | 2500 | 4000 | 1000 | 130 | 60 | 40 | 30 | 260 | 243856 | 224719 | 102153 | 163892 | 41000 | 99.13% | 91.35% | 99.66% | 99.93% | 100.00% | 0 | 18918 - 97.01% | 1,581,641$ | 64,847,300$ | 19500 | 100 | 57,083,349$ | 57,368,164$ | 3,490,015$ | 57,675,437$ | 308,431$ | 57,533,501$ | 25 | 0 | 0$ | 0$ | 0 | 306,900$ | 0$ | 0$ | 63,209,379$ | 15,049,379$ | 65,200,000$ | 1,990,621$ | 135,154,507$ | 135,154,507$ |
25 | San Jose | 6600 | 5600 | 2650 | 5000 | 1000 | 95 | 65 | 35 | 22 | 300 | 264220 | 214817 | 107865 | 184904 | 40896 | 97.64% | 93.56% | 99.28% | 90.20% | 99.75% | 0 | 19822 - 95.07% | 1,443,316$ | 59,175,968$ | 20850 | 100 | 61,425,000$ | 61,431,250$ | 820,000$ | 59,828,973$ | 330,276$ | 59,999,232$ | 22 | 0 | 0$ | 0$ | 0 | 330,242$ | 0$ | 0$ | 63,768,766$ | 15,608,766$ | 65,200,000$ | 1,431,234$ | 186,206,169$ | 186,206,169$ |
26 | St-Louis | 6500 | 5500 | 3500 | 3000 | 1500 | 200 | 100 | 99 | 75 | 395 | 152825 | 146261 | 57705 | 89262 | 32305 | 57.35% | 64.86% | 40.21% | 72.57% | 52.53% | 0 | 11667 - 58.34% | 1,716,074$ | 70,359,020$ | 20000 | 100 | 67,145,444$ | 68,278,777$ | -795,699$ | 62,777,906$ | 367,090$ | 63,400,901$ | 23 | 0 | 0$ | 0$ | 0 | 360,997$ | 0$ | 0$ | 65,200,844$ | 17,040,844$ | 65,200,000$ | -844$ | 347,361,057$ | 347,361,057$ |
27 | Tampa Bay | 6000 | 5000 | 2500 | 4000 | 1000 | 125 | 80 | 50 | 35 | 250 | 243619 | 200957 | 100763 | 162602 | 41000 | 99.03% | 98.03% | 98.31% | 99.15% | 100.00% | 0 | 18267 - 98.74% | 1,646,540$ | 67,508,155$ | 18500 | 100 | 56,794,500$ | 57,411,167$ | 0$ | 58,957,220$ | 308,662$ | 59,577,224$ | 21 | 0 | 0$ | 0$ | 0 | 305,347$ | 0$ | 0$ | 62,114,562$ | 13,954,562$ | 65,200,000$ | 3,085,438$ | 220,068,168$ | 220,068,168$ |
28 | Toronto | 6000 | 5000 | 2500 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 245876 | 204851 | 102480 | 164000 | 41000 | 99.95% | 99.93% | 99.98% | 100.00% | 100.00% | 0 | 18493 - 99.96% | 1,286,962$ | 52,765,460$ | 18500 | 100 | 57,592,000$ | 58,375,334$ | -433,468$ | 59,942,472$ | 313,846$ | 61,060,743$ | 23 | 0 | 0$ | 0$ | 0 | 309,634$ | 0$ | 0$ | 64,361,965$ | 16,201,965$ | 65,200,000$ | 838,035$ | 44,024,237$ | 44,024,237$ |
29 | Vancouver | 5000 | 7000 | 4000 | 4000 | 2000 | 140 | 80 | 65 | 40 | 300 | 205000 | 214988 | 104074 | 163303 | 53402 | 100.00% | 74.91% | 63.46% | 99.58% | 65.12% | 0 | 18067 - 82.12% | 1,452,484$ | 59,551,835$ | 22000 | 100 | 65,423,834$ | 65,040,501$ | -1,403,226$ | 64,943,462$ | 349,680$ | 64,558,056$ | 21 | 0 | 0$ | 0$ | 0 | 351,741$ | 0$ | 0$ | 65,542,039$ | 17,382,039$ | 65,200,000$ | -342,039$ | 63,001,826$ | 63,001,826$ |
30 | Washington | 6000 | 5000 | 2500 | 4000 | 1000 | 130 | 85 | 40 | 30 | 220 | 243119 | 172060 | 101982 | 163771 | 41000 | 98.83% | 83.93% | 99.49% | 99.86% | 100.00% | 0 | 17608 - 95.18% | 1,566,902$ | 64,242,980$ | 18500 | 100 | 57,150,000$ | 57,792,857$ | 0$ | 55,596,085$ | 310,714$ | 56,220,853$ | 23 | 0 | 0$ | 0$ | 0 | 307,258$ | 0$ | 0$ | 59,809,555$ | 11,649,555$ | 65,200,000$ | 5,390,445$ | 113,235,537$ | 113,235,537$ |
31 | Winnipeg | 6500 | 5500 | 2500 | 4000 | 1500 | 100 | 70 | 55 | 45 | 195 | 260292 | 211016 | 100573 | 160555 | 55289 | 97.67% | 93.58% | 98.12% | 97.90% | 89.90% | 0 | 19213 - 96.06% | 1,569,224$ | 64,338,165$ | 20000 | 100 | 66,967,500$ | 65,775,833$ | -790,323$ | 63,550,963$ | 348,660$ | 62,628,122$ | 20 | 1 | 0$ | 0$ | 0 | 360,040$ | 0$ | 0$ | 64,896,057$ | 16,736,057$ | 65,200,000$ | 303,943$ | 116,142,294$ | 116,142,294$ |