| 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,711,116$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Blackhawks | 6000 | 5000 | 5000 | 5000 | 1000 | 100 | 50 | 30 | 15 | 180 | 45759 | 51431 | 43232 | 46906 | 11000 | 69.33% | 93.51% | 78.60% | 85.28% | 100.00% | 30 | 18030 - 81.95% | 1,507,338$ | 16,580,719$ | 22000 | 100 | 59,402,499$ | 58,477,499$ | 0$ | 18,181,853$ | 59,402,499$ | 17,416,920$ | 25 | 0 | 0$ | 45,220,143$ | 93 | 461,959$ | 42,962,187$ | 42,962,187$ | 59,402,499$ | 2,691,383$ | 75,614,821$ | 16,212,322$ | 106,965,856$ | 109,223,812$ |
| 2 | Blue Jackets | 5000 | 4000 | 4144 | 4000 | 1000 | 75 | 45 | 30 | 15 | 125 | 55000 | 44000 | 43896 | 43959 | 11000 | 100.00% | 100.00% | 96.30% | 99.91% | 100.00% | 30 | 17987 - 99.13% | 1,280,894$ | 14,089,836$ | 18144 | 100 | 74,763,333$ | 74,763,333$ | 0$ | 23,028,347$ | 74,763,333$ | 22,875,335$ | 22 | 0 | 0$ | 38,426,825$ | 93 | 561,667$ | 52,235,031$ | 52,235,031$ | 74,763,333$ | 18,052,217$ | 75,614,821$ | 851,488$ | -9,640,679$ | -23,448,885$ |
| 3 | Blues | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 41799 | 30000 | 24000 | 24000 | 6000 | 58.05% | 50.00% | 50.00% | 50.00% | 50.00% | 29 | 10483 - 52.42% | 1,695,480$ | 20,345,762$ | 20000 | 100 | 65,350,000$ | 65,350,000$ | 0$ | 21,194,344$ | 65,350,000$ | 20,582,407$ | 23 | 0 | 0$ | 49,168,925$ | 93 | 502,612$ | 46,742,916$ | 46,742,916$ | 65,350,000$ | 8,638,884$ | 75,614,821$ | 10,264,821$ | 190,466,073$ | 192,892,082$ |
| 4 | Canadiens | 7000 | 6000 | 6000 | 5000 | 1000 | 82 | 50 | 16 | 10 | 180 | 63140 | 51964 | 48051 | 51093 | 11000 | 82.00% | 78.73% | 72.80% | 92.90% | 100.00% | 30 | 20477 - 81.91% | 1,494,799$ | 16,442,786$ | 25000 | 100 | 68,021,666$ | 67,096,666$ | 0$ | 19,846,929$ | 68,021,666$ | 19,540,947$ | 26 | 1 | 0$ | 44,843,962$ | 93 | 515,087$ | 47,903,091$ | 47,903,091$ | 68,021,666$ | 11,310,550$ | 75,614,821$ | 7,593,155$ | 73,370,951$ | 70,311,822$ |
| 5 | Canucks | 6000 | 5000 | 3193 | 4000 | 1000 | 80 | 50 | 35 | 14 | 170 | 63134 | 52640 | 35123 | 44000 | 11000 | 95.66% | 95.71% | 100.00% | 100.00% | 100.00% | 30 | 18718 - 97.52% | 1,543,914$ | 16,983,057$ | 19193 | 100 | 59,959,835$ | 61,009,835$ | 469,458$ | 16,716,030$ | 59,959,835$ | 16,379,462$ | 24 | 0 | 0$ | 46,317,428$ | 93 | 455,670$ | 42,377,310$ | 42,377,310$ | 60,429,293$ | 3,718,177$ | 75,614,821$ | 15,185,528$ | 83,326,028$ | 87,266,146$ |
| 6 | Capitals | 6000 | 5000 | 4750 | 4500 | 1027 | 80 | 55 | 25 | 14 | 175 | 68829 | 56764 | 49442 | 52270 | 12320 | 95.60% | 94.61% | 86.74% | 96.80% | 99.97% | 29 | 19969 - 93.85% | 1,583,395$ | 19,000,734$ | 21277 | 100 | 74,675,000$ | 74,675,000$ | 0$ | 22,782,274$ | 74,675,000$ | 22,476,302$ | 24 | 0 | 0$ | 45,918,440$ | 93 | 564,739$ | 52,520,727$ | 52,520,727$ | 74,675,000$ | 17,963,884$ | 75,614,821$ | 939,821$ | 143,506,553$ | 136,904,266$ |
| 7 | Coyotes | 7500 | 5000 | 4000 | 4000 | 1500 | 71 | 60 | 35 | 15 | 150 | 71444 | 56229 | 46117 | 47979 | 13695 | 79.38% | 93.72% | 96.08% | 99.96% | 76.08% | 29 | 19622 - 89.19% | 1,593,592$ | 19,123,098$ | 22000 | 100 | 70,975,000$ | 70,975,000$ | 0$ | 22,305,102$ | 70,975,000$ | 21,387,192$ | 24 | 1 | 0$ | 46,214,154$ | 93 | 552,052$ | 51,340,836$ | 51,340,836$ | 70,975,000$ | 14,263,884$ | 75,614,821$ | 4,639,821$ | 279,491,408$ | 274,364,726$ |
| 8 | Ducks | 5000 | 4000 | 3174 | 4000 | 1000 | 80 | 53 | 38 | 20 | 120 | 55000 | 44000 | 34112 | 38548 | 11000 | 100.00% | 100.00% | 97.70% | 87.61% | 100.00% | 30 | 16605 - 96.69% | 1,370,694$ | 15,077,631$ | 17174 | 100 | 63,269,167$ | 63,269,167$ | 0$ | 19,111,623$ | 63,269,167$ | 18,805,671$ | 23 | 1 | 0$ | 41,120,812$ | 93 | 479,621$ | 44,604,753$ | 44,604,753$ | 63,269,167$ | 6,558,051$ | 75,614,821$ | 12,345,654$ | 6,109,571$ | 2,625,630$ |
| 9 | Flyers | 6000 | 5000 | 5668 | 6000 | 1500 | 80 | 50 | 30 | 15 | 150 | 62116 | 52577 | 42275 | 47994 | 13029 | 94.12% | 95.59% | 67.80% | 72.72% | 78.96% | 30 | 19817 - 82.00% | 1,563,232$ | 17,195,555$ | 24168 | 100 | 64,430,000$ | 64,430,000$ | 0$ | 19,683,814$ | 64,430,000$ | 19,530,826$ | 25 | 1 | 0$ | 46,896,968$ | 93 | 484,552$ | 45,063,336$ | 45,063,336$ | 64,430,000$ | 7,718,884$ | 75,614,821$ | 11,184,821$ | 128,513,662$ | 130,347,294$ |
| 10 | Golden Knights | 5500 | 4500 | 3000 | 3500 | 1000 | 98 | 68 | 45 | 27 | 195 | 47578 | 38189 | 29857 | 28081 | 11000 | 78.64% | 77.15% | 90.48% | 72.94% | 100.00% | 30 | 14064 - 80.37% | 1,558,574$ | 17,144,310$ | 17500 | 100 | 68,934,166$ | 68,934,166$ | 1,500,000$ | 19,156,091$ | 68,934,166$ | 18,850,124$ | 27 | 1 | 0$ | 46,757,209$ | 93 | 521,897$ | 48,536,421$ | 48,536,421$ | 70,434,166$ | 13,723,050$ | 75,614,821$ | 5,180,655$ | 104,777,292$ | 102,998,080$ |
| 11 | Jets | 4575 | 4375 | 3390 | 3375 | 800 | 100 | 70 | 40 | 25 | 250 | 46294 | 37210 | 32724 | 29966 | 7772 | 91.99% | 77.32% | 87.76% | 80.72% | 88.32% | 30 | 13997 - 84.75% | 1,521,860$ | 16,740,464$ | 16515 | 100 | 74,263,167$ | 73,013,167$ | 528,000$ | 22,906,467$ | 74,263,167$ | 22,447,513$ | 23 | 0 | 0$ | 45,655,811$ | 93 | 565,397$ | 52,581,921$ | 52,581,921$ | 74,791,167$ | 18,080,051$ | 75,614,821$ | 823,654$ | 234,686,723$ | 227,760,613$ |
| 12 | Kings | 5300 | 4300 | 4300 | 4418 | 1300 | 95 | 70 | 30 | 20 | 185 | 47567 | 37615 | 44176 | 38763 | 12414 | 81.59% | 79.52% | 93.40% | 79.76% | 86.81% | 30 | 16412 - 83.66% | 1,564,371$ | 17,208,077$ | 19618 | 100 | 74,092,500$ | 74,092,500$ | 214,500$ | 22,147,150$ | 74,092,500$ | 21,994,149$ | 24 | 0 | 0$ | 46,931,119$ | 93 | 556,660$ | 51,769,380$ | 51,769,380$ | 74,307,000$ | 17,595,884$ | 75,614,821$ | 1,307,821$ | 30,585,574$ | 25,747,313$ |
| 13 | Lightning | 6000 | 5000 | 5000 | 6000 | 1000 | 90 | 65 | 25 | 10 | 225 | 55492 | 45300 | 49910 | 58750 | 9943 | 77.07% | 75.50% | 83.18% | 81.60% | 82.86% | 29 | 18283 - 79.49% | 1,511,400$ | 18,136,802$ | 23000 | 100 | 66,149,999$ | 65,649,999$ | 0$ | 21,177,276$ | 66,149,999$ | 20,718,322$ | 22 | 1 | 0$ | 43,830,605$ | 93 | 504,851$ | 46,951,143$ | 46,951,143$ | 66,149,999$ | 9,438,883$ | 75,614,821$ | 9,464,822$ | 153,565,469$ | 150,444,931$ |
| 14 | Maple Leafs | 6500 | 5600 | 3500 | 4800 | 1400 | 75 | 44 | 32 | 12 | 165 | 66691 | 54772 | 38500 | 49807 | 12996 | 93.27% | 88.92% | 100.00% | 94.33% | 84.39% | 30 | 20251 - 92.90% | 1,542,261$ | 16,964,867$ | 21800 | 100 | 67,780,833$ | 67,405,833$ | 0$ | 20,754,016$ | 67,780,833$ | 20,295,062$ | 22 | 0 | 0$ | 46,267,819$ | 93 | 517,021$ | 48,082,953$ | 48,082,953$ | 67,780,833$ | 11,069,717$ | 75,614,821$ | 7,833,988$ | -51,088,685$ | -52,903,819$ |
| 15 | Oilers | 6000 | 5000 | 2600 | 4000 | 1000 | 90 | 55 | 45 | 20 | 200 | 53734 | 52057 | 28116 | 38608 | 10288 | 81.42% | 94.65% | 98.31% | 87.75% | 93.53% | 30 | 16618 - 89.35% | 1,597,574$ | 17,573,319$ | 18600 | 100 | 74,875,000$ | 71,275,000$ | -1,500,000$ | 22,033,578$ | 74,875,000$ | 21,727,610$ | 22 | 0 | 0$ | 47,927,234$ | 93 | 566,231$ | 52,659,483$ | 52,659,483$ | 73,375,000$ | 16,663,884$ | 75,614,821$ | 2,239,821$ | -3,788,716$ | -8,520,965$ |
| 16 | Penguins | 6000 | 5000 | 3250 | 5000 | 1000 | 90 | 55 | 45 | 15 | 205 | 52664 | 51609 | 28994 | 48543 | 9989 | 79.79% | 93.83% | 81.10% | 88.26% | 90.81% | 30 | 17436 - 86.11% | 1,579,248$ | 17,371,725$ | 20250 | 100 | 75,299,999$ | 76,799,999$ | 0$ | 23,105,590$ | 75,299,999$ | 22,646,636$ | 21 | 0 | 0$ | 47,377,432$ | 93 | 573,134$ | 53,301,462$ | 53,301,462$ | 75,299,999$ | 18,588,883$ | 75,614,821$ | 314,822$ | 100,140,278$ | 94,216,248$ |
| 17 | Rangers | 6350 | 5500 | 4350 | 4000 | 2500 | 100 | 60 | 35 | 20 | 200 | 50432 | 56771 | 47396 | 40816 | 15000 | 66.18% | 86.02% | 90.80% | 85.03% | 50.00% | 29 | 17535 - 77.24% | 1,728,976$ | 20,747,715$ | 22700 | 100 | 71,727,499$ | 64,644,166$ | 0$ | 21,941,610$ | 71,727,499$ | 21,482,656$ | 23 | 1 | 0$ | 50,140,311$ | 93 | 546,474$ | 50,822,082$ | 50,822,082$ | 71,727,499$ | 15,016,383$ | 75,614,821$ | 3,887,322$ | 139,789,958$ | 139,108,187$ |
| 18 | Red Wings | 7000 | 5000 | 4500 | 5000 | 1500 | 70 | 56 | 25 | 12 | 85 | 74552 | 56015 | 51441 | 55525 | 16184 | 88.75% | 93.36% | 95.26% | 92.54% | 89.91% | 29 | 21143 - 91.93% | 1,450,694$ | 17,408,333$ | 23000 | 100 | 75,100,000$ | 75,100,000$ | 0$ | 23,885,754$ | 75,100,000$ | 22,814,870$ | 21 | 0 | 0$ | 42,070,138$ | 93 | 586,567$ | 54,550,731$ | 54,550,731$ | 75,100,000$ | 18,388,884$ | 75,614,821$ | 514,821$ | 187,535,823$ | 175,055,230$ |
| 19 | Sabres | 6000 | 5000 | 2595 | 4000 | 1000 | 86 | 46 | 43 | 18 | 180 | 63383 | 52769 | 28452 | 43793 | 11000 | 96.03% | 95.94% | 99.67% | 99.53% | 100.00% | 30 | 18127 - 97.48% | 1,607,849$ | 17,686,334$ | 18595 | 100 | 59,731,666$ | 60,681,666$ | 0$ | 18,479,957$ | 59,731,666$ | 18,143,388$ | 24 | 1 | 0$ | 48,235,456$ | 93 | 453,968$ | 42,219,024$ | 42,219,024$ | 59,731,666$ | 3,020,550$ | 75,614,821$ | 15,883,155$ | 28,073,590$ | 34,090,022$ |
| 20 | Sharks | 6000 | 5000 | 4000 | 4000 | 1000 | 125 | 105 | 75 | 45 | 400 | 37173 | 27500 | 22000 | 22000 | 5500 | 56.32% | 50.00% | 50.00% | 50.00% | 50.00% | 30 | 10379 - 51.90% | 1,676,131$ | 18,437,445$ | 20000 | 100 | 69,110,001$ | 69,110,001$ | 0$ | 23,843,640$ | 69,110,001$ | 23,690,638$ | 20 | 1 | 0$ | 50,283,941$ | 93 | 519,478$ | 48,311,454$ | 48,311,454$ | 69,110,001$ | 12,398,885$ | 75,614,821$ | 6,504,820$ | -28,189,528$ | -26,217,041$ |