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 15,000,000$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
1 | Blackhawks | 6250 | 5250 | 2250 | 4250 | 1000 | 105 | 65 | 40 | 25 | 200 | 232346 | 199082 | 86958 | 166967 | 33259 | 90.67% | 92.49% | 94.26% | 95.82% | 81.12% | 0 | 17527 - 92.25% | 892,122$ | 36,576,994$ | 19000 | 100 | 32,772,500$ | 32,772,500$ | 0$ | 31,992,205$ | 32,772,500$ | 31,992,205$ | 21 | 1 | 0$ | 0$ | 1 | 267,663$ | 267,663$ | 285,980$ | 35,175,500$ | 20,175,500$ | 40,000,000$ | 4,824,500$ | 11,495,025$ | 11,209,045$ |
2 | Bruins | 6500 | 5500 | 2500 | 4000 | 1000 | 90 | 65 | 36 | 32 | 190 | 227619 | 172071 | 78145 | 107006 | 36969 | 85.41% | 76.31% | 76.24% | 65.25% | 90.17% | 0 | 15166 - 77.77% | 880,083$ | 36,083,393$ | 19500 | 100 | 37,251,000$ | 37,251,000$ | 0$ | 36,628,665$ | 37,251,000$ | 36,628,665$ | 22 | 0 | 0$ | 0$ | 1 | 304,073$ | 304,073$ | 321,338$ | 39,524,600$ | 24,524,600$ | 40,000,000$ | 475,400$ | 2,575,695$ | 2,254,357$ |
3 | Canadiens | 6250 | 5250 | 2250 | 4250 | 1000 | 100 | 60 | 36 | 30 | 200 | 226637 | 201471 | 84431 | 125521 | 31372 | 88.44% | 93.60% | 91.52% | 72.04% | 76.52% | 0 | 16328 - 85.93% | 897,445$ | 36,795,243$ | 19000 | 100 | 31,880,000$ | 31,880,000$ | 0$ | 31,310,170$ | 31,880,000$ | 31,310,170$ | 22 | 0 | 0$ | 0$ | 1 | 260,407$ | 260,407$ | 273,114$ | 33,592,900$ | 18,592,900$ | 40,000,000$ | 6,407,100$ | 7,302,319$ | 7,029,205$ |
4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 234380 | 193636 | 81869 | 159365 | 32076 | 95.28% | 94.46% | 99.84% | 97.17% | 78.23% | 0 | 17106 - 95.03% | 883,919$ | 36,240,674$ | 18000 | 100 | 26,439,500$ | 26,439,500$ | 0$ | 26,763,350$ | 26,439,500$ | 26,763,350$ | 21 | 0 | 0$ | 0$ | 1 | 216,175$ | 216,175$ | 225,947$ | 27,791,500$ | 12,791,500$ | 40,000,000$ | 12,208,500$ | 27,265,298$ | 27,039,351$ |
5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 38 | 28 | 205 | 200428 | 196235 | 81811 | 157831 | 31353 | 81.47% | 95.72% | 99.77% | 96.24% | 76.47% | 0 | 16284 - 90.47% | 873,579$ | 35,816,751$ | 18000 | 100 | 25,969,000$ | 25,969,000$ | 0$ | 25,705,016$ | 25,969,000$ | 25,705,016$ | 20 | 0 | 0$ | 0$ | 1 | 212,350$ | 212,350$ | 223,068$ | 27,437,300$ | 12,437,300$ | 40,000,000$ | 12,562,700$ | 38,988,600$ | 38,765,532$ |
6 | Flyers | 6250 | 5250 | 2250 | 4250 | 1000 | 100 | 60 | 35 | 25 | 200 | 232574 | 199530 | 86752 | 157994 | 32508 | 90.76% | 92.70% | 94.04% | 90.67% | 79.29% | 0 | 17301 - 91.06% | 891,164$ | 36,537,728$ | 19000 | 100 | 24,577,000$ | 24,577,000$ | 0$ | 26,104,851$ | 24,577,000$ | 26,104,851$ | 20 | 0 | 0$ | 0$ | 1 | 201,033$ | 201,033$ | 218,144$ | 26,831,700$ | 11,831,700$ | 40,000,000$ | 13,168,300$ | 22,557,954$ | 22,339,810$ |
7 | Jets | 5250 | 4250 | 2250 | 3250 | 1000 | 90 | 75 | 45 | 35 | 180 | 215250 | 152647 | 62101 | 108967 | 39984 | 100.00% | 87.60% | 67.32% | 81.78% | 97.52% | 0 | 14121 - 88.25% | 816,818$ | 33,489,531$ | 16000 | 100 | 30,555,000$ | 30,555,000$ | 0$ | 29,796,536$ | 30,555,000$ | 29,796,536$ | 22 | 0 | 0$ | 0$ | 1 | 249,187$ | 249,187$ | 261,758$ | 32,196,200$ | 17,196,200$ | 40,000,000$ | 7,803,800$ | 16,172,708$ | 15,910,950$ |
8 | Mighty Ducks | 6500 | 5500 | 2500 | 4500 | 1000 | 100 | 60 | 35 | 25 | 200 | 239692 | 204201 | 89704 | 162750 | 33044 | 89.94% | 90.55% | 87.52% | 88.21% | 80.60% | 0 | 17790 - 88.95% | 915,337$ | 37,528,836$ | 20000 | 100 | 31,465,000$ | 31,465,000$ | 0$ | 30,057,639$ | 31,465,000$ | 30,057,639$ | 24 | 0 | 0$ | 0$ | 1 | 257,033$ | 257,033$ | 270,054$ | 33,216,600$ | 18,216,600$ | 40,000,000$ | 6,783,400$ | 13,720,177$ | 13,450,123$ |
9 | Nordiques | 6250 | 5250 | 2250 | 4250 | 1000 | 90 | 55 | 30 | 20 | 175 | 244069 | 206232 | 90722 | 168981 | 38821 | 95.25% | 95.81% | 98.34% | 96.98% | 94.69% | 0 | 18264 - 96.13% | 870,232$ | 35,679,518$ | 19000 | 100 | 37,570,999$ | 37,470,999$ | 0$ | 34,937,040$ | 37,570,999$ | 34,937,040$ | 24 | 0 | 0$ | 0$ | 1 | 306,675$ | 306,675$ | 319,376$ | 39,283,199$ | 24,283,199$ | 40,000,000$ | 716,801$ | 10,889,384$ | 10,570,008$ |
10 | Northstars | 6250 | 5250 | 2250 | 4250 | 1000 | 99 | 65 | 40 | 30 | 200 | 194958 | 202509 | 75488 | 128473 | 34366 | 76.08% | 94.08% | 81.83% | 73.73% | 83.82% | 0 | 15507 - 81.62% | 883,694$ | 36,231,471$ | 19000 | 100 | 38,577,000$ | 38,577,000$ | 0$ | 38,099,971$ | 38,577,000$ | 38,099,971$ | 21 | 0 | 0$ | 0$ | 1 | 314,854$ | 314,854$ | 324,321$ | 39,891,450$ | 24,891,450$ | 40,000,000$ | 108,550$ | 4,232,302$ | 3,907,981$ |
11 | Oilers | 6250 | 5250 | 2250 | 4250 | 1000 | 104 | 67 | 40 | 27 | 200 | 207848 | 200164 | 76561 | 159580 | 33440 | 81.11% | 92.99% | 82.99% | 91.58% | 81.56% | 0 | 16527 - 86.98% | 897,856$ | 36,812,092$ | 19000 | 100 | 22,928,500$ | 22,928,500$ | 0$ | 22,918,465$ | 22,928,500$ | 22,918,465$ | 21 | 0 | 0$ | 0$ | 1 | 187,630$ | 187,630$ | 200,959$ | 24,718,000$ | 9,718,000$ | 40,000,000$ | 15,282,000$ | 32,617,278$ | 32,416,319$ |
12 | Penguins | 6250 | 5250 | 2250 | 4250 | 1000 | 125 | 70 | 42 | 30 | 250 | 164568 | 165938 | 69916 | 128466 | 25498 | 64.22% | 77.09% | 75.79% | 73.73% | 62.19% | 0 | 13522 - 71.17% | 829,603$ | 34,013,710$ | 19000 | 100 | 28,029,000$ | 28,029,000$ | 0$ | 29,183,754$ | 28,029,000$ | 29,183,754$ | 22 | 1 | 0$ | 0$ | 1 | 229,098$ | 229,098$ | 239,420$ | 29,448,600$ | 14,448,600$ | 40,000,000$ | 10,551,400$ | 7,807,724$ | 7,568,304$ |
13 | Rangers | 5000 | 4000 | 2000 | 3000 | 1000 | 75 | 60 | 35 | 25 | 125 | 205000 | 164000 | 81905 | 123000 | 40307 | 100.00% | 100.00% | 99.88% | 100.00% | 98.31% | 0 | 14981 - 99.87% | 662,105$ | 27,146,288$ | 15000 | 100 | 24,114,000$ | 24,114,000$ | 0$ | 24,901,434$ | 24,114,000$ | 24,901,434$ | 25 | 0 | 0$ | 0$ | 1 | 197,268$ | 197,268$ | 206,185$ | 25,360,800$ | 10,360,800$ | 40,000,000$ | 14,639,200$ | 28,192,656$ | 27,986,471$ |
14 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 120 | 70 | 50 | 250 | 134123 | 92709 | 40539 | 74941 | 25046 | 54.52% | 45.22% | 49.44% | 45.70% | 61.09% | 0 | 8960 - 49.78% | 806,521$ | 33,067,355$ | 18000 | 100 | 32,534,000$ | 32,534,000$ | 0$ | 30,602,745$ | 32,534,000$ | 30,602,745$ | 25 | 0 | 0$ | 0$ | 1 | 265,724$ | 265,724$ | 275,753$ | 33,917,600$ | 18,917,600$ | 40,000,000$ | 6,082,400$ | 16,620,751$ | 16,344,998$ |
15 | Rockies | 6100 | 5100 | 2100 | 4100 | 1100 | 100 | 60 | 35 | 25 | 200 | 233788 | 200890 | 85272 | 159595 | 33080 | 93.48% | 96.07% | 99.04% | 94.94% | 73.35% | 0 | 17381 - 93.95% | 896,755$ | 36,766,946$ | 18500 | 100 | 31,525,000$ | 31,525,000$ | 0$ | 31,722,799$ | 31,525,000$ | 31,722,799$ | 21 | 1 | 0$ | 0$ | 1 | 257,520$ | 257,520$ | 270,260$ | 33,242,080$ | 18,242,080$ | 40,000,000$ | 6,757,920$ | 12,124,510$ | 11,854,250$ |
16 | Whalers | 6000 | 5500 | 3000 | 4500 | 1000 | 100 | 70 | 35 | 30 | 180 | 229531 | 147597 | 82355 | 124264 | 39594 | 93.31% | 65.45% | 66.96% | 67.35% | 96.57% | 0 | 15203 - 76.02% | 895,936$ | 36,733,372$ | 20000 | 100 | 37,798,000$ | 37,798,000$ | 0$ | 36,906,431$ | 37,798,000$ | 36,906,431$ | 23 | 0 | 0$ | 0$ | 1 | 308,520$ | 308,520$ | 319,034$ | 39,241,200$ | 24,241,200$ | 40,000,000$ | 758,800$ | 6,584,413$ | 6,265,379$ |