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 56,972,312$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
1 | Blackhawks | 6000 | 5000 | 5000 | 5000 | 1000 | 100 | 50 | 30 | 15 | 180 | 166400 | 186932 | 156670 | 173712 | 39000 | 71.11% | 95.86% | 80.34% | 89.08% | 100.00% | 2 | 18531 - 84.23% | 1,540,140$ | 60,065,443$ | 22000 | 100 | 77,399,999$ | 77,024,999$ | -3,000,000$ | 72,062,655$ | 77,399,999$ | 69,738,431$ | 25 | 0 | 0$ | 3,080,279$ | 9 | 624,219$ | 5,617,971$ | 5,617,971$ | 74,399,999$ | 17,427,687$ | 75,963,083$ | 1,563,084$ | 87,940,709$ | 85,403,017$ |
2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 195000 | 156000 | 154489 | 155954 | 39000 | 100.00% | 100.00% | 95.59% | 99.97% | 100.00% | 2 | 17960 - 98.99% | 1,279,642$ | 49,906,033$ | 18144 | 100 | 76,463,333$ | 76,296,666$ | -1,250,000$ | 71,366,091$ | 76,463,333$ | 69,878,591$ | 21 | 0 | 0$ | 2,559,284$ | 9 | 609,870$ | 5,488,830$ | 5,488,830$ | 75,213,333$ | 18,241,021$ | 75,963,083$ | 749,750$ | -39,427,959$ | -42,357,505$ |
3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 133405 | 97500 | 78000 | 78000 | 19505 | 57.01% | 50.00% | 50.00% | 50.00% | 50.01% | 2 | 10421 - 52.10% | 1,683,896$ | 65,671,934$ | 20000 | 100 | 60,405,833$ | 60,405,833$ | 250,000$ | 59,522,296$ | 60,405,833$ | 57,662,921$ | 24 | 1 | 0$ | 3,367,791$ | 9 | 487,546$ | 4,387,914$ | 4,387,914$ | 60,655,833$ | 3,683,521$ | 75,963,083$ | 15,307,250$ | 203,228,094$ | 202,207,971$ |
4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 220650 | 182711 | 167306 | 181941 | 38926 | 80.82% | 78.08% | 71.50% | 93.30% | 99.81% | 2 | 20296 - 81.18% | 1,479,755$ | 57,710,440$ | 25000 | 100 | 66,300,833$ | 66,300,833$ | 3,250,000$ | 60,023,558$ | 66,300,833$ | 58,629,045$ | 25 | 0 | 0$ | 2,959,510$ | 9 | 529,694$ | 4,767,246$ | 4,767,246$ | 69,550,833$ | 12,578,521$ | 75,963,083$ | 6,412,250$ | 68,610,195$ | 66,802,459$ |
5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 80 | 50 | 35 | 14 | 170 | 218849 | 180467 | 124527 | 155273 | 38949 | 93.53% | 92.55% | 100.00% | 99.53% | 99.87% | 2 | 18412 - 95.93% | 1,516,165$ | 59,130,448$ | 19193 | 100 | 60,999,834$ | 61,449,834$ | 3,339,504$ | 54,169,892$ | 60,999,834$ | 53,147,207$ | 25 | 0 | 0$ | 3,032,331$ | 9 | 485,155$ | 4,366,395$ | 4,366,395$ | 64,339,338$ | 7,367,026$ | 75,963,083$ | 11,623,745$ | 89,186,322$ | 87,852,258$ |
6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 223308 | 186168 | 160247 | 170292 | 40036 | 95.43% | 95.47% | 86.50% | 97.03% | 99.96% | 2 | 20001 - 94.00% | 1,585,530$ | 61,835,663$ | 21277 | 100 | 78,424,999$ | 78,924,999$ | -3,000,000$ | 73,401,784$ | 78,424,999$ | 72,472,049$ | 24 | 0 | 0$ | 3,171,060$ | 9 | 620,508$ | 5,584,572$ | 5,584,572$ | 75,424,999$ | 18,452,687$ | 75,963,083$ | 538,084$ | 124,964,826$ | 122,551,314$ |
7 | Coyotes | 7500 | 5000 | 4000 | 4000 | 1500 | 71 | 60 | 35 | 15 | 150 | 236985 | 156427 | 149966 | 156000 | 46239 | 81.02% | 80.22% | 96.13% | 100.00% | 79.04% | 2 | 19118 - 86.90% | 1,556,332$ | 60,696,964$ | 22000 | 100 | 73,938,750$ | 77,063,750$ | 0$ | 71,451,105$ | 73,938,750$ | 68,661,995$ | 21 | 0 | 0$ | 3,112,665$ | 9 | 601,084$ | 5,409,756$ | 5,409,756$ | 73,938,750$ | 16,966,438$ | 75,963,083$ | 2,024,333$ | 281,600,755$ | 279,303,664$ |
8 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 85 | 55 | 40 | 22 | 125 | 200000 | 160000 | 118486 | 122551 | 40000 | 100.00% | 100.00% | 93.33% | 76.59% | 100.00% | 1 | 16026 - 93.32% | 1,411,122$ | 56,444,881$ | 17174 | 100 | 66,919,167$ | 67,419,167$ | 1,250,000$ | 64,877,965$ | 66,919,167$ | 63,948,311$ | 25 | 0 | 0$ | 1,411,122$ | 9 | 530,618$ | 4,775,562$ | 4,775,562$ | 68,169,167$ | 11,196,855$ | 75,963,083$ | 7,793,916$ | -3,171,878$ | -6,536,318$ |
9 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 215777 | 179001 | 148596 | 163801 | 44639 | 92.21% | 91.80% | 67.22% | 70.00% | 76.31% | 2 | 19277 - 79.76% | 1,521,441$ | 59,336,206$ | 24168 | 100 | 59,500,000$ | 59,500,000$ | 3,000,000$ | 61,833,752$ | 59,500,000$ | 59,990,001$ | 24 | 0 | 0$ | 3,042,882$ | 9 | 480,469$ | 4,324,221$ | 4,324,221$ | 62,500,000$ | 5,527,688$ | 75,963,083$ | 13,463,083$ | 137,448,645$ | 136,167,306$ |
10 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 84 | 56 | 36 | 19 | 195 | 211988 | 174303 | 115922 | 133921 | 36492 | 98.83% | 99.32% | 99.08% | 98.11% | 93.57% | 2 | 17247 - 98.55% | 1,574,865$ | 61,419,727$ | 17500 | 100 | 61,866,666$ | 61,241,666$ | 5,250,000$ | 61,948,181$ | 61,866,666$ | 61,018,529$ | 25 | 0 | 0$ | 3,149,730$ | 9 | 491,146$ | 4,420,314$ | 4,420,314$ | 67,116,666$ | 10,144,354$ | 75,963,083$ | 8,846,417$ | 102,997,505$ | 101,726,921$ |
11 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 88 | 57 | 37 | 23 | 250 | 166699 | 147420 | 116756 | 105181 | 29088 | 93.43% | 86.40% | 88.31% | 79.91% | 93.23% | 2 | 14491 - 87.74% | 1,537,754$ | 59,972,412$ | 16515 | 100 | 78,440,000$ | 77,877,500$ | -3,605,825$ | 66,492,233$ | 78,440,000$ | 65,097,754$ | 22 | 0 | 0$ | 3,075,508$ | 9 | 624,531$ | 5,620,779$ | 5,620,779$ | 74,834,175$ | 17,861,863$ | 75,963,083$ | 1,128,908$ | 232,313,445$ | 229,768,174$ |
12 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 176110 | 133061 | 156904 | 135449 | 45442 | 85.20% | 79.34% | 93.56% | 78.61% | 89.63% | 2 | 16589 - 84.56% | 1,599,557$ | 62,382,705$ | 19618 | 100 | 71,862,500$ | 71,862,500$ | 214,500$ | 72,635,252$ | 71,862,500$ | 68,943,846$ | 22 | 0 | 0$ | 3,199,113$ | 9 | 592,676$ | 5,334,084$ | 5,334,084$ | 72,077,000$ | 15,104,688$ | 75,963,083$ | 3,886,083$ | 19,569,862$ | 17,434,891$ |
13 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 85 | 60 | 20 | 10 | 200 | 219359 | 151936 | 173077 | 186116 | 35013 | 93.74% | 77.92% | 88.76% | 79.54% | 89.78% | 2 | 19628 - 85.34% | 1,547,087$ | 60,336,395$ | 23000 | 100 | 76,816,750$ | 76,441,750$ | -1,000,000$ | 71,785,470$ | 76,816,750$ | 70,078,429$ | 21 | 0 | 0$ | 3,094,174$ | 9 | 615,756$ | 5,541,804$ | 5,541,804$ | 75,816,750$ | 18,844,438$ | 75,963,083$ | 146,333$ | 150,004,930$ | 147,557,300$ |
14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 75 | 44 | 32 | 12 | 165 | 231376 | 196045 | 136500 | 178379 | 45670 | 91.27% | 89.76% | 100.00% | 95.29% | 83.64% | 2 | 20204 - 92.68% | 1,529,094$ | 59,634,684$ | 21800 | 100 | 68,894,167$ | 68,019,167$ | 1,250,000$ | 64,854,325$ | 68,894,167$ | 63,924,666$ | 22 | 0 | 0$ | 3,058,189$ | 9 | 546,048$ | 4,914,432$ | 4,914,432$ | 70,144,167$ | 13,171,855$ | 75,963,083$ | 5,818,916$ | -56,023,396$ | -57,879,639$ |
15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 186352 | 185346 | 99446 | 132098 | 35609 | 79.64% | 95.05% | 98.07% | 84.68% | 91.31% | 2 | 16381 - 88.07% | 1,574,225$ | 61,394,765$ | 18600 | 100 | 59,400,833$ | 59,600,833$ | 6,500,000$ | 52,617,127$ | 59,400,833$ | 51,687,421$ | 24 | 0 | 0$ | 3,148,449$ | 9 | 471,882$ | 4,246,938$ | 4,246,938$ | 65,900,833$ | 8,928,521$ | 75,963,083$ | 10,062,250$ | 11,446,890$ | 10,348,401$ |
16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 85 | 55 | 40 | 15 | 205 | 216372 | 187871 | 116737 | 175459 | 36464 | 92.47% | 96.34% | 92.10% | 89.98% | 93.50% | 2 | 18792 - 92.80% | 1,674,694$ | 65,313,073$ | 20250 | 100 | 83,325,000$ | 82,887,500$ | -7,500,000$ | 74,987,616$ | 83,325,000$ | 72,698,582$ | 21 | 0 | 0$ | 3,349,388$ | 9 | 670,508$ | 6,034,572$ | 6,034,572$ | 75,825,000$ | 18,852,688$ | 75,963,083$ | 138,083$ | 97,035,805$ | 94,350,621$ |
17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 165163 | 155504 | 151986 | 131910 | 48750 | 66.69% | 72.50% | 89.59% | 84.56% | 50.00% | 2 | 16752 - 73.80% | 1,663,996$ | 64,895,829$ | 22700 | 100 | 63,891,666$ | 62,558,333$ | 2,625,000$ | 65,278,218$ | 63,891,666$ | 63,418,843$ | 20 | 0 | 0$ | 3,327,991$ | 9 | 514,779$ | 4,633,011$ | 4,633,011$ | 66,516,666$ | 9,544,354$ | 75,963,083$ | 9,446,417$ | 165,110,906$ | 163,805,886$ |
18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 70 | 56 | 25 | 12 | 85 | 227875 | 185315 | 160015 | 179819 | 50546 | 83.47% | 95.03% | 91.18% | 92.21% | 86.40% | 2 | 20604 - 89.58% | 1,405,318$ | 54,807,418$ | 23000 | 100 | 66,680,000$ | 67,180,000$ | 1,625,000$ | 73,560,526$ | 66,680,000$ | 70,306,612$ | 20 | 0 | 0$ | 2,810,637$ | 9 | 548,281$ | 4,934,529$ | 4,934,529$ | 68,305,000$ | 11,332,688$ | 75,963,083$ | 7,658,083$ | 162,708,088$ | 160,584,196$ |
19 | Senators | 6000 | 5000 | 2652 | 4000 | 1000 | 86 | 46 | 43 | 18 | 180 | 220728 | 188034 | 102106 | 155306 | 39000 | 94.33% | 96.43% | 98.72% | 99.56% | 100.00% | 2 | 18081 - 96.94% | 1,598,435$ | 62,338,974$ | 18652 | 100 | 70,413,000$ | 71,238,000$ | 750,250$ | 65,311,790$ | 70,413,000$ | 64,289,148$ | 23 | 0 | 0$ | 3,196,870$ | 9 | 558,695$ | 5,028,255$ | 5,028,255$ | 71,163,250$ | 14,190,938$ | 75,963,083$ | 4,799,833$ | -14,749,805$ | -16,581,190$ |
20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 137903 | 97750 | 78000 | 78000 | 19716 | 58.93% | 50.13% | 50.00% | 50.00% | 50.55% | 2 | 10548 - 52.74% | 1,709,604$ | 66,674,555$ | 20000 | 100 | 86,367,499$ | 87,804,999$ | -11,625,000$ | 74,208,449$ | 86,367,499$ | 71,438,868$ | 22 | 0 | 0$ | 3,419,208$ | 9 | 698,184$ | 6,283,656$ | 6,283,656$ | 74,742,499$ | 17,770,187$ | 75,963,083$ | 1,220,584$ | -34,388,840$ | -37,253,288$ |