| 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 | Revenus | Dépenses | Éstimation | Total de l'Équipe Éstimé | ||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | É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 - % | Revenus Moyen par Match | Revenus Annuels à ce Jour | Capacité de l'Aréna | Popularité de l'Équipe | Salaire Total des Joueurs | Salaire Total Moyen des Joueurs | Valeur du Cap Salarial Spécial | Dépenses Annuelles à Ce Jour | Cap Salarial Par Jour | Cap salarial à ce jour | Joueurs Inclut dans la Cap Salariale | Joueurs Exclut dans la Cap Salariale | Taxe de Luxe Totale | Revenus de la Saison Éstimés | Jours Restants de la Saison | Dépenses Par Jour | Dépenses de la Saison Éstimées | Dépenses de la Saison Éstimées | Cap Salarial de la Saison Éstimé | Au dessus du Plafond Salarial Minimum of 15,000,000$ | Cap Salarial Maximum | Cap Salarial Disponible | Compte Bancaire Actuel | Compte Bancaire Projeté |
| 1 | Blackhawks | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 75 | 44 | 25 | 215 | 46212 | 34339 | 13492 | 34620 | 7165 | 85.58% | 76.31% | 74.96% | 96.17% | 79.61% | 32 | 15092 - 83.84% | 888,197$ | 7,993,775$ | 18000 | 100 | 31,496,000$ | 31,496,000$ | 0$ | 7,033,663$ | 31,496,000$ | 7,033,663$ | 20 | 0 | 0$ | 28,422,311$ | 107 | 232,691$ | 24,897,937$ | 26,617,641$ | 33,831,800$ | 18,831,800$ | 40,000,000$ | 6,168,200$ | 7,802,939$ | 9,607,609$ |
| 2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 135 | 107 | 55 | 45 | 238 | 29769 | 20705 | 8584 | 15516 | 5499 | 62.02% | 51.76% | 53.65% | 48.49% | 68.74% | 33 | 10009 - 55.61% | 860,785$ | 6,886,279$ | 18000 | 100 | 27,437,000$ | 27,437,000$ | 0$ | 5,789,579$ | 27,437,000$ | 5,789,579$ | 20 | 0 | 0$ | 28,405,901$ | 107 | 202,846$ | 21,704,522$ | 22,738,784$ | 28,901,550$ | 13,901,550$ | 40,000,000$ | 11,098,450$ | 12,436,000$ | 18,103,117$ |
| 3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 52413 | 43554 | 17213 | 33442 | 8551 | 97.06% | 96.79% | 95.63% | 92.89% | 95.01% | 32 | 17241 - 95.79% | 916,937$ | 8,252,432$ | 18000 | 100 | 30,741,000$ | 30,741,000$ | 0$ | 6,559,701$ | 30,741,000$ | 6,559,701$ | 21 | 0 | 0$ | 29,341,980$ | 107 | 227,140$ | 24,303,980$ | 25,261,630$ | 32,108,200$ | 17,108,200$ | 40,000,000$ | 7,891,800$ | 12,368,176$ | 16,448,526$ |
| 4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 46315 | 39693 | 15190 | 30754 | 7200 | 96.49% | 99.23% | 94.94% | 96.11% | 90.00% | 33 | 17394 - 96.63% | 914,398$ | 7,315,184$ | 18000 | 100 | 20,558,800$ | 20,558,800$ | 0$ | 4,409,605$ | 20,558,800$ | 4,409,605$ | 21 | 0 | 0$ | 30,175,134$ | 107 | 152,271$ | 16,292,997$ | 17,109,621$ | 21,746,800$ | 6,746,800$ | 40,000,000$ | 18,253,200$ | 23,299,200$ | 36,364,713$ |
| 5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 38 | 27 | 205 | 51681 | 43597 | 17562 | 34229 | 8537 | 95.71% | 96.88% | 97.57% | 95.08% | 94.86% | 32 | 17290 - 96.05% | 948,866$ | 8,539,797$ | 18000 | 100 | 22,908,000$ | 22,908,000$ | 0$ | 5,112,356$ | 22,908,000$ | 5,112,356$ | 21 | 1 | 0$ | 30,363,723$ | 107 | 169,544$ | 18,141,208$ | 19,123,682$ | 24,306,700$ | 9,306,700$ | 40,000,000$ | 15,693,300$ | 20,988,025$ | 32,228,066$ |
| 6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 52449 | 43262 | 17244 | 34618 | 8616 | 97.13% | 96.14% | 95.80% | 96.16% | 95.73% | 32 | 17354 - 96.41% | 919,401$ | 8,274,608$ | 18000 | 100 | 20,458,000$ | 20,458,000$ | 0$ | 4,395,812$ | 20,458,000$ | 4,395,812$ | 21 | 0 | 0$ | 29,420,828$ | 107 | 151,529$ | 16,213,603$ | 17,301,258$ | 21,990,500$ | 6,990,500$ | 40,000,000$ | 18,009,500$ | 21,017,086$ | 33,136,656$ |
| 7 | Mighty Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 52164 | 43312 | 16662 | 34680 | 8250 | 96.60% | 96.25% | 92.57% | 96.33% | 91.67% | 32 | 17230 - 95.72% | 909,607$ | 8,186,467$ | 18000 | 100 | 25,593,000$ | 25,593,000$ | 0$ | 5,221,189$ | 25,593,000$ | 5,221,189$ | 24 | 0 | 0$ | 29,107,438$ | 107 | 189,287$ | 20,253,709$ | 21,260,151$ | 27,022,200$ | 12,022,200$ | 40,000,000$ | 12,977,800$ | 13,004,387$ | 20,851,674$ |
| 8 | Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 30 | 20 | 200 | 51563 | 43484 | 17992 | 34906 | 8622 | 95.49% | 96.63% | 99.96% | 96.96% | 95.80% | 32 | 17396 - 96.65% | 893,968$ | 8,045,715$ | 18000 | 100 | 27,683,000$ | 27,683,000$ | 0$ | 5,934,966$ | 27,683,000$ | 5,934,966$ | 21 | 0 | 0$ | 28,606,987$ | 107 | 204,654$ | 21,897,978$ | 22,852,097$ | 29,045,700$ | 14,045,700$ | 40,000,000$ | 10,954,300$ | 16,771,262$ | 22,526,152$ |
| 9 | Northstars | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 60 | 35 | 25 | 200 | 44717 | 44030 | 17229 | 33851 | 8670 | 82.81% | 97.84% | 95.72% | 94.03% | 96.33% | 32 | 16500 - 91.66% | 895,330$ | 8,057,969$ | 18000 | 100 | 31,891,500$ | 31,891,500$ | 0$ | 6,838,551$ | 31,891,500$ | 6,838,551$ | 21 | 0 | 0$ | 28,650,556$ | 107 | 235,599$ | 25,209,093$ | 26,074,081$ | 33,140,900$ | 18,140,900$ | 40,000,000$ | 6,859,100$ | 18,365,674$ | 20,942,149$ |
| 10 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 46279 | 38944 | 15253 | 30464 | 7655 | 96.41% | 97.36% | 95.33% | 95.20% | 95.69% | 33 | 17324 - 96.25% | 917,906$ | 7,343,247$ | 18000 | 100 | 25,415,000$ | 25,415,000$ | 0$ | 5,424,892$ | 25,415,000$ | 5,424,892$ | 23 | 0 | 0$ | 30,290,894$ | 107 | 187,978$ | 20,113,646$ | 21,236,718$ | 26,992,450$ | 11,992,450$ | 40,000,000$ | 13,007,550$ | 21,464,851$ | 30,519,027$ |
| 11 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 51494 | 42847 | 17202 | 33754 | 8482 | 95.36% | 95.22% | 95.57% | 93.76% | 94.24% | 32 | 17087 - 94.93% | 905,212$ | 8,146,905$ | 18000 | 100 | 27,241,000$ | 27,241,000$ | 0$ | 5,779,615$ | 27,241,000$ | 5,779,615$ | 21 | 0 | 0$ | 28,966,773$ | 107 | 201,404$ | 21,550,228$ | 22,481,984$ | 28,575,300$ | 13,575,300$ | 40,000,000$ | 11,424,700$ | 21,202,918$ | 27,687,707$ |
| 12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 120 | 70 | 50 | 250 | 28594 | 18751 | 7254 | 14408 | 5216 | 59.57% | 46.88% | 45.34% | 45.03% | 65.20% | 33 | 9278 - 51.54% | 850,444$ | 6,803,550$ | 18000 | 100 | 22,458,000$ | 22,458,000$ | 0$ | 4,748,885$ | 22,458,000$ | 4,748,885$ | 22 | 0 | 0$ | 28,064,644$ | 107 | 166,235$ | 17,787,145$ | 18,706,596$ | 23,776,700$ | 8,776,700$ | 40,000,000$ | 16,223,300$ | 16,778,915$ | 26,136,963$ |
| 13 | Rockies | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 45937 | 39113 | 15431 | 29735 | 7603 | 95.70% | 97.78% | 96.44% | 92.92% | 95.04% | 33 | 17227 - 95.71% | 913,551$ | 7,308,405$ | 18000 | 100 | 22,469,000$ | 22,469,000$ | 0$ | 4,623,718$ | 22,469,000$ | 4,623,718$ | 22 | 0 | 0$ | 30,147,171$ | 107 | 166,316$ | 17,795,812$ | 18,846,231$ | 23,954,080$ | 8,954,080$ | 40,000,000$ | 16,045,920$ | 18,440,235$ | 29,741,175$ |
| 14 | Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 121 | 100 | 50 | 35 | 180 | 39142 | 25936 | 11110 | 23048 | 8356 | 72.49% | 57.64% | 61.72% | 64.02% | 92.84% | 32 | 11955 - 66.41% | 870,157$ | 7,831,416$ | 18000 | 100 | 30,910,000$ | 30,910,000$ | 0$ | 6,557,531$ | 30,910,000$ | 6,557,531$ | 25 | 0 | 0$ | 27,845,035$ | 107 | 228,382$ | 24,436,874$ | 25,624,146$ | 32,569,100$ | 17,569,100$ | 40,000,000$ | 7,430,900$ | 23,627,325$ | 25,848,214$ |