| 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 | 161868 | 134416 | 53298 | 109242 | 26103 | 79.35% | 79.07% | 78.38% | 80.33% | 76.77% | 4 | 14263 - 79.24% | 1,055,548$ | 35,888,638$ | 18000 | 100 | 4,226,697$ | 4,226,697$ | 99,645$ | 3,653,129$ | 4,226,697$ | 3,475,377$ | 23 | 0 | 8,118,531$ | 4,222,193$ | 15 | 32,790$ | 491,850$ | 516,870$ | 4,351,849$ | 4,351,849$ | 5,500,000$ | 1,148,151$ | 202,419,183$ | 206,412,055$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 171160 | 141769 | 56655 | 111048 | 27419 | 81.50% | 81.01% | 80.94% | 79.32% | 78.34% | 3 | 14516 - 80.64% | 1,078,536$ | 37,748,762$ | 18000 | 100 | 3,766,620$ | 3,766,620$ | 163,807$ | 3,538,686$ | 3,766,620$ | 3,360,962$ | 27 | 0 | 7,775,286$ | 3,235,608$ | 15 | 29,382$ | 440,730$ | 467,805$ | 3,910,340$ | 3,910,340$ | 5,500,000$ | 1,589,660$ | 143,720,583$ | 146,629,627$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 156737 | 132772 | 52331 | 103773 | 25051 | 81.63% | 82.98% | 81.77% | 81.07% | 78.28% | 6 | 14708 - 81.71% | 1,084,481$ | 34,703,387$ | 18000 | 100 | 3,668,863$ | 3,668,863$ | 76,960$ | 3,313,818$ | 3,668,863$ | 3,136,078$ | 28 | 0 | 7,100,634$ | 6,506,885$ | 15 | 28,658$ | 429,870$ | 456,495$ | 3,808,491$ | 3,808,491$ | 5,500,000$ | 1,691,509$ | 162,459,070$ | 168,789,747$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 161283 | 133679 | 52864 | 104588 | 26017 | 81.46% | 81.02% | 80.10% | 79.23% | 78.84% | 5 | 14498 - 80.54% | 1,081,061$ | 35,675,016$ | 18000 | 100 | 4,661,623$ | 4,661,623$ | 152,796$ | 4,050,840$ | 4,661,623$ | 3,873,049$ | 27 | 0 | 9,311,547$ | 5,405,305$ | 15 | 36,012$ | 540,180$ | 566,835$ | 4,801,523$ | 4,801,523$ | 5,500,000$ | 698,477$ | 200,751,204$ | 205,823,066$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 170350 | 139315 | 56471 | 111841 | 27564 | 81.12% | 79.61% | 80.67% | 79.89% | 78.75% | 3 | 14444 - 80.24% | 1,076,973$ | 37,694,056$ | 18000 | 100 | 2,873,720$ | 2,873,720$ | 147,585$ | 2,745,407$ | 2,873,720$ | 2,567,631$ | 22 | 0 | 5,395,293$ | 3,230,919$ | 15 | 22,768$ | 341,520$ | 370,020$ | 3,030,220$ | 3,030,220$ | 5,500,000$ | 2,469,780$ | 175,502,637$ | 178,502,180$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 161214 | 131650 | 53729 | 106596 | 26424 | 79.03% | 77.44% | 79.01% | 78.38% | 77.72% | 4 | 14106 - 78.37% | 1,055,883$ | 35,900,037$ | 18000 | 100 | 3,897,893$ | 3,897,893$ | 103,023$ | 3,687,924$ | 3,897,893$ | 3,510,157$ | 36 | 0 | 8,222,871$ | 4,223,534$ | 15 | 30,355$ | 455,325$ | 481,665$ | 4,034,893$ | 4,034,893$ | 5,500,000$ | 1,465,107$ | 183,903,334$ | 187,830,211$ |
| 7 | Islanders | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 165278 | 138650 | 56044 | 110284 | 27364 | 78.70% | 79.23% | 80.06% | 78.77% | 78.18% | 3 | 14218 - 78.99% | 1,062,217$ | 37,177,598$ | 18000 | 100 | 3,529,240$ | 3,529,240$ | 49,987$ | 3,303,506$ | 3,529,240$ | 3,125,717$ | 23 | 0 | 7,069,551$ | 3,186,651$ | 15 | 27,624$ | 414,360$ | 439,560$ | 3,656,040$ | 3,656,040$ | 5,500,000$ | 1,843,960$ | 158,830,564$ | 161,795,961$ |
| 8 | Maple Leafs | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 166192 | 138828 | 55647 | 110904 | 27432 | 79.14% | 79.33% | 79.50% | 79.22% | 78.38% | 3 | 14257 - 79.21% | 1,065,348$ | 37,287,196$ | 18000 | 100 | 2,222,560$ | 2,222,560$ | 79,666$ | 2,104,391$ | 2,222,560$ | 1,926,638$ | 21 | 0 | 3,472,314$ | 3,196,045$ | 15 | 17,945$ | 269,175$ | 294,015$ | 2,346,060$ | 2,346,060$ | 5,500,000$ | 3,153,940$ | 207,404,477$ | 210,521,297$ |
| 9 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 157898 | 133647 | 51462 | 105934 | 25612 | 79.75% | 81.00% | 77.97% | 80.25% | 77.61% | 5 | 14380 - 79.89% | 1,066,267$ | 35,186,802$ | 18000 | 100 | 3,992,417$ | 3,992,417$ | 123,918$ | 3,610,967$ | 3,992,417$ | 3,433,179$ | 23 | 0 | 7,991,937$ | 5,331,334$ | 15 | 31,055$ | 465,825$ | 493,185$ | 4,138,661$ | 4,138,661$ | 5,500,000$ | 1,361,339$ | 144,502,947$ | 149,709,658$ |
| 10 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 163063 | 136127 | 52994 | 109379 | 26192 | 79.93% | 80.07% | 77.93% | 80.43% | 77.04% | 4 | 14346 - 79.70% | 1,061,437$ | 36,088,852$ | 18000 | 100 | 4,041,410$ | 4,041,410$ | 168,160$ | 3,718,887$ | 4,041,410$ | 3,541,075$ | 25 | 0 | 8,315,625$ | 4,245,747$ | 15 | 31,418$ | 471,270$ | 493,785$ | 4,144,110$ | 4,144,110$ | 5,500,000$ | 1,355,890$ | 130,370,446$ | 134,412,409$ |
| 11 | Rangers | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 50 | 30 | 20 | 750 | 161986 | 134064 | 53544 | 107498 | 26330 | 79.40% | 78.86% | 78.74% | 79.04% | 77.44% | 4 | 14218 - 78.99% | 1,058,898$ | 36,002,542$ | 18000 | 100 | 3,341,760$ | 3,341,760$ | 93,729$ | 3,281,491$ | 3,341,760$ | 3,103,721$ | 21 | 0 | 7,003,563$ | 4,235,593$ | 15 | 26,235$ | 393,525$ | 417,255$ | 3,455,360$ | 3,455,360$ | 5,500,000$ | 2,044,640$ | 166,043,179$ | 170,146,437$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 30 | 20 | 10 | 5 | 60 | 198000 | 165000 | 66000 | 132000 | 33000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 5 | 18000 - 100.00% | 323,000$ | 10,659,000$ | 18000 | 100 | 3,323,854$ | 3,323,854$ | 122,753$ | 3,146,164$ | 3,323,854$ | 2,968,328$ | 22 | 0 | 6,597,384$ | 1,615,000$ | 15 | 26,103$ | 391,545$ | 418,920$ | 3,470,254$ | 3,470,254$ | 5,500,000$ | 2,029,746$ | 137,335,409$ | 138,582,489$ |
CCCP
Jets
Mooseheads
Nordiques
Thunder
Tigers
Americans
Brass
Bulls
Gibsons
Scouts
Whalers