| 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 | 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é de l’aréna | Popularité de l’équipe | Salaire total des joueurs | Plafond Salariale total 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 0$ | Plafond salarial maximum | Plafond salarial disponible | Compte bancaire actuel | Compte bancaire projeté |
| 1 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 118884 | 98437 | 39279 | 80090 | 19350 | 79.26% | 78.75% | 78.56% | 80.09% | 77.40% | 13 | 14242 - 79.12% | 1,058,448$ | 26,461,196$ | 18000 | 100 | 3,891,177$ | 3,891,177$ | 99,645$ | 2,558,573$ | 3,891,177$ | 2,431,187$ | 23 | 0 | 5,639,781$ | 13,759,822$ | 49 | 30,305$ | 1,484,945$ | 1,566,285$ | 4,015,329$ | 4,015,329$ | 5,500,000$ | 1,484,671$ | 195,975,093$ | 209,103,271$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 122931 | 101354 | 40409 | 80660 | 19600 | 81.95% | 81.08% | 80.82% | 80.66% | 78.40% | 13 | 14598 - 81.10% | 1,081,642$ | 27,041,046$ | 18000 | 100 | 3,766,620$ | 3,766,620$ | 163,807$ | 2,537,705$ | 3,766,620$ | 2,410,336$ | 27 | 0 | 5,577,228$ | 14,061,344$ | 49 | 29,382$ | 1,439,718$ | 1,528,163$ | 3,910,340$ | 3,910,340$ | 5,500,000$ | 1,589,660$ | 135,802,644$ | 148,948,065$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 123647 | 103003 | 40921 | 80887 | 19527 | 82.43% | 82.40% | 81.84% | 80.89% | 78.11% | 13 | 14719 - 81.77% | 1,085,086$ | 27,127,150$ | 18000 | 100 | 3,536,130$ | 3,536,130$ | 76,960$ | 2,350,655$ | 3,536,130$ | 2,223,273$ | 26 | 0 | 5,016,039$ | 14,106,118$ | 49 | 27,675$ | 1,356,075$ | 1,448,734$ | 3,691,358$ | 3,691,358$ | 5,500,000$ | 1,808,642$ | 157,945,845$ | 171,212,947$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 116481 | 97414 | 38173 | 76161 | 18875 | 80.89% | 81.18% | 79.53% | 79.33% | 78.65% | 14 | 14463 - 80.35% | 1,077,780$ | 25,866,721$ | 18000 | 100 | 4,276,623$ | 4,276,623$ | 152,796$ | 2,875,956$ | 4,276,623$ | 2,748,528$ | 25 | 0 | 6,591,804$ | 15,088,921$ | 49 | 33,160$ | 1,624,840$ | 1,711,717$ | 4,416,023$ | 4,416,023$ | 5,500,000$ | 1,083,977$ | 194,531,642$ | 208,563,426$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 111952 | 91571 | 36573 | 73128 | 17924 | 81.12% | 79.63% | 79.51% | 79.49% | 77.93% | 15 | 14398 - 79.99% | 1,070,915$ | 24,631,044$ | 18000 | 100 | 2,873,720$ | 2,873,720$ | 147,585$ | 1,952,510$ | 2,873,720$ | 1,825,098$ | 22 | 0 | 3,821,514$ | 16,063,724$ | 49 | 22,768$ | 1,115,632$ | 1,207,115$ | 3,025,720$ | 3,025,720$ | 5,500,000$ | 2,474,280$ | 164,336,874$ | 179,896,916$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 109099 | 89818 | 36764 | 71630 | 17919 | 79.06% | 78.10% | 79.92% | 77.86% | 77.91% | 15 | 14140 - 78.56% | 1,058,734$ | 24,350,880$ | 18000 | 100 | 3,772,933$ | 3,772,933$ | 103,023$ | 2,656,088$ | 3,772,933$ | 2,528,699$ | 36 | 0 | 5,932,317$ | 15,881,009$ | 49 | 29,429$ | 1,442,021$ | 1,533,161$ | 3,924,033$ | 3,924,033$ | 5,500,000$ | 1,575,967$ | 175,229,837$ | 190,272,837$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 108928 | 90919 | 36722 | 71891 | 18269 | 78.93% | 79.06% | 79.83% | 78.14% | 79.43% | 15 | 14206 - 78.92% | 1,070,142$ | 24,613,263$ | 18000 | 100 | 3,548,240$ | 3,548,240$ | 49,987$ | 2,362,226$ | 3,548,240$ | 2,234,811$ | 22 | 0 | 5,050,653$ | 16,052,128$ | 49 | 27,765$ | 1,360,485$ | 1,444,667$ | 3,680,140$ | 3,680,140$ | 5,500,000$ | 1,819,860$ | 148,409,772$ | 164,107,868$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 119409 | 99318 | 40108 | 79732 | 19804 | 79.61% | 79.45% | 80.22% | 79.73% | 79.22% | 13 | 14335 - 79.64% | 1,073,463$ | 26,836,587$ | 18000 | 100 | 2,102,560$ | 2,102,560$ | 79,666$ | 1,512,485$ | 2,102,560$ | 1,385,100$ | 20 | 0 | 2,501,520$ | 13,955,025$ | 49 | 17,056$ | 835,744$ | 917,966$ | 2,229,060$ | 2,229,060$ | 5,500,000$ | 3,270,940$ | 197,866,275$ | 211,838,711$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 104182 | 87781 | 33954 | 70004 | 16960 | 78.93% | 79.80% | 77.17% | 79.55% | 77.09% | 16 | 14222 - 79.01% | 1,056,372$ | 23,240,188$ | 18000 | 100 | 3,902,417$ | 3,902,417$ | 123,918$ | 2,558,947$ | 3,902,417$ | 2,431,533$ | 22 | 0 | 5,640,819$ | 16,901,955$ | 49 | 30,388$ | 1,489,012$ | 1,587,894$ | 4,074,848$ | 4,074,848$ | 5,500,000$ | 1,425,152$ | 136,027,654$ | 152,507,823$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 104227 | 88156 | 34296 | 70200 | 16788 | 78.96% | 80.14% | 77.95% | 79.77% | 76.31% | 16 | 14258 - 79.21% | 1,052,791$ | 23,161,399$ | 18000 | 100 | 4,383,623$ | 4,383,623$ | 168,160$ | 2,673,805$ | 4,383,623$ | 2,546,369$ | 25 | 0 | 5,985,327$ | 16,844,654$ | 49 | 33,953$ | 1,663,697$ | 1,742,489$ | 4,500,723$ | 4,500,723$ | 5,500,000$ | 999,277$ | 120,426,332$ | 136,691,160$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 110553 | 90260 | 36133 | 73548 | 17885 | 80.11% | 78.49% | 78.55% | 79.94% | 77.76% | 15 | 14277 - 79.32% | 1,063,357$ | 24,457,200$ | 18000 | 100 | 3,461,760$ | 3,461,760$ | 93,729$ | 2,373,109$ | 3,461,760$ | 2,245,707$ | 22 | 0 | 5,083,341$ | 15,950,348$ | 49 | 27,124$ | 1,329,076$ | 1,405,516$ | 3,572,360$ | 3,572,360$ | 5,500,000$ | 1,927,640$ | 156,596,386$ | 172,209,662$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 120000 | 100000 | 40000 | 80000 | 20000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 18 | 18000 - 100.00% | 323,000$ | 6,460,000$ | 18000 | 100 | 3,323,854$ | 3,323,854$ | 122,753$ | 2,248,784$ | 3,323,854$ | 2,121,332$ | 22 | 0 | 4,710,216$ | 5,814,000$ | 49 | 26,103$ | 1,279,047$ | 1,368,472$ | 3,470,254$ | 3,470,254$ | 5,500,000$ | 2,029,746$ | 135,849,421$ | 140,478,549$ |
CCCP
Jets
Mooseheads
Nordiques
Thunder
Tigers
Americans
Brass
Bulls
Gibsons
Scouts
Whalers