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 | 100 | 65 | 38 | 25 | 200 | 133017 | 104853 | 40656 | 103747 | 21363 | 82.11% | 77.67% | 75.29% | 96.06% | 79.12% | 14 | 14949 - 83.05% | 867,048$ | 23,410,287$ | 18000 | 100 | 32,821,000$ | 32,821,000$ | 0$ | 20,256,896$ | 32,821,000$ | 20,256,896$ | 21 | 0 | 0$ | 12,138,667$ | 50 | 242,434$ | 12,121,700$ | 12,919,800$ | 35,141,800$ | 20,141,800$ | 40,000,000$ | 4,858,200$ | 9,068,268$ | 8,287,135$ |
2 | Bruins | 6000 | 5000 | 2000 | 4000 | 1000 | 130 | 100 | 50 | 41 | 225 | 100437 | 71795 | 32083 | 56489 | 18315 | 64.38% | 55.23% | 61.70% | 54.32% | 70.44% | 15 | 10735 - 59.64% | 844,527$ | 21,957,690$ | 18000 | 100 | 30,162,000$ | 30,162,000$ | 0$ | 17,292,195$ | 30,162,000$ | 17,292,195$ | 23 | 0 | 0$ | 12,667,898$ | 50 | 222,882$ | 11,144,100$ | 11,546,500$ | 31,406,550$ | 16,406,550$ | 40,000,000$ | 8,593,450$ | 15,515,102$ | 16,636,500$ |
3 | Canadiens | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 151874 | 123931 | 49162 | 97315 | 24437 | 97.36% | 95.33% | 94.54% | 93.57% | 93.99% | 15 | 17182 - 95.45% | 913,391$ | 23,748,153$ | 18000 | 100 | 26,541,000$ | 26,541,000$ | 0$ | 19,573,212$ | 26,541,000$ | 19,573,212$ | 21 | 0 | 0$ | 13,700,858$ | 50 | 196,257$ | 9,812,850$ | 10,264,150$ | 27,918,500$ | 12,918,500$ | 40,000,000$ | 12,081,500$ | 14,350,275$ | 17,786,983$ |
4 | Canucks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 153725 | 131585 | 51662 | 102845 | 24782 | 94.89% | 97.47% | 95.67% | 95.23% | 91.79% | 14 | 17207 - 95.60% | 905,647$ | 24,452,471$ | 18000 | 100 | 20,832,800$ | 20,832,800$ | 0$ | 13,117,794$ | 20,832,800$ | 13,117,794$ | 21 | 0 | 0$ | 12,679,059$ | 50 | 154,285$ | 7,714,250$ | 8,392,000$ | 22,826,300$ | 7,826,300$ | 40,000,000$ | 17,173,700$ | 31,176,739$ | 35,463,798$ |
5 | Flames | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 65 | 38 | 28 | 205 | 149833 | 129860 | 51882 | 99874 | 24329 | 92.49% | 96.19% | 96.08% | 92.48% | 90.11% | 14 | 16881 - 93.78% | 940,826$ | 25,402,307$ | 18000 | 100 | 24,608,000$ | 24,608,000$ | 0$ | 15,162,748$ | 24,608,000$ | 15,162,748$ | 23 | 0 | 0$ | 13,171,567$ | 50 | 182,044$ | 9,102,200$ | 9,533,700$ | 25,931,700$ | 10,931,700$ | 40,000,000$ | 14,068,300$ | 27,284,148$ | 30,922,015$ |
6 | Flyers | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 148425 | 124305 | 49902 | 99641 | 24632 | 95.14% | 95.62% | 95.97% | 95.81% | 94.74% | 15 | 17189 - 95.49% | 907,638$ | 23,598,596$ | 18000 | 100 | 20,908,000$ | 20,908,000$ | 0$ | 13,165,313$ | 20,908,000$ | 13,165,313$ | 22 | 0 | 0$ | 13,614,575$ | 50 | 154,838$ | 7,741,900$ | 8,243,750$ | 22,423,000$ | 7,423,000$ | 40,000,000$ | 17,577,000$ | 27,020,927$ | 32,391,752$ |
7 | Mighty Ducks | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 155581 | 130985 | 50464 | 104399 | 25265 | 96.04% | 97.03% | 93.45% | 96.67% | 93.57% | 14 | 17285 - 96.03% | 912,400$ | 24,634,812$ | 18000 | 100 | 25,593,000$ | 25,593,000$ | 0$ | 15,981,467$ | 25,593,000$ | 15,981,467$ | 24 | 0 | 0$ | 12,773,606$ | 50 | 189,287$ | 9,464,350$ | 9,934,650$ | 27,022,200$ | 12,022,200$ | 40,000,000$ | 12,977,800$ | 18,157,673$ | 20,996,629$ |
8 | Nordiques | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 30 | 20 | 200 | 148755 | 126141 | 51314 | 102350 | 25088 | 95.36% | 97.03% | 98.68% | 98.41% | 96.49% | 15 | 17448 - 96.93% | 895,615$ | 23,285,983$ | 18000 | 100 | 27,683,000$ | 27,683,000$ | 0$ | 17,588,334$ | 27,683,000$ | 17,588,334$ | 21 | 0 | 0$ | 13,434,221$ | 50 | 204,654$ | 10,232,700$ | 10,678,550$ | 29,045,700$ | 14,045,700$ | 40,000,000$ | 10,954,300$ | 19,852,389$ | 22,608,060$ |
9 | Northstars | 6000 | 5000 | 2000 | 4000 | 1000 | 110 | 60 | 35 | 25 | 200 | 124760 | 124843 | 49954 | 98302 | 24813 | 79.97% | 96.03% | 96.07% | 94.52% | 95.43% | 15 | 16257 - 90.31% | 876,425$ | 22,787,040$ | 18000 | 100 | 31,891,500$ | 31,891,500$ | 0$ | 20,267,694$ | 31,891,500$ | 20,267,694$ | 21 | 0 | 0$ | 13,146,369$ | 50 | 235,599$ | 11,779,950$ | 12,202,000$ | 33,189,500$ | 18,189,500$ | 40,000,000$ | 6,810,500$ | 19,187,350$ | 20,131,719$ |
10 | Oilers | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 67 | 41 | 27 | 205 | 147676 | 125811 | 44645 | 99337 | 24332 | 94.66% | 96.78% | 85.86% | 95.52% | 93.58% | 15 | 16992 - 94.40% | 940,369$ | 24,449,586$ | 18000 | 100 | 25,325,000$ | 25,325,000$ | 0$ | 16,056,430$ | 25,325,000$ | 16,056,430$ | 23 | 0 | 0$ | 14,105,530$ | 50 | 187,316$ | 9,365,800$ | 10,034,000$ | 27,292,450$ | 12,292,450$ | 40,000,000$ | 12,707,550$ | 27,331,226$ | 31,402,756$ |
11 | Penguins | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 154777 | 129875 | 51933 | 103905 | 26058 | 95.54% | 96.20% | 96.17% | 96.21% | 96.51% | 14 | 17280 - 96.00% | 913,808$ | 24,672,810$ | 18000 | 100 | 27,241,000$ | 27,241,000$ | 0$ | 17,226,997$ | 27,241,000$ | 17,226,997$ | 21 | 0 | 0$ | 12,793,309$ | 50 | 201,404$ | 10,070,200$ | 10,491,800$ | 28,537,800$ | 13,537,800$ | 40,000,000$ | 11,462,200$ | 25,789,146$ | 28,090,655$ |
12 | Red Wings | 6000 | 5000 | 2000 | 4000 | 1000 | 150 | 120 | 70 | 50 | 250 | 92299 | 62274 | 24293 | 48220 | 17389 | 56.97% | 46.13% | 44.99% | 44.65% | 64.40% | 14 | 9055 - 50.30% | 827,125$ | 22,332,366$ | 18000 | 100 | 22,473,000$ | 22,473,000$ | 0$ | 14,176,578$ | 22,473,000$ | 14,176,578$ | 22 | 0 | 0$ | 11,579,745$ | 50 | 166,346$ | 8,317,300$ | 9,167,900$ | 24,936,700$ | 9,936,700$ | 40,000,000$ | 15,063,300$ | 22,222,970$ | 24,634,815$ |
13 | Rockies | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 154724 | 129841 | 52530 | 101225 | 25277 | 95.51% | 96.18% | 97.28% | 93.73% | 93.62% | 14 | 17170 - 95.39% | 907,984$ | 24,515,576$ | 18000 | 100 | 22,969,000$ | 22,969,000$ | 0$ | 14,158,342$ | 22,969,000$ | 14,158,342$ | 23 | 0 | 0$ | 12,711,780$ | 50 | 169,993$ | 8,499,650$ | 8,990,500$ | 24,454,080$ | 9,454,080$ | 40,000,000$ | 15,545,920$ | 25,529,500$ | 29,250,780$ |
14 | Whalers | 6000 | 5000 | 2000 | 4000 | 1000 | 121 | 100 | 50 | 35 | 180 | 118172 | 78378 | 34264 | 69863 | 25820 | 72.95% | 58.06% | 63.45% | 64.69% | 95.63% | 14 | 12092 - 67.18% | 866,346$ | 23,391,347$ | 18000 | 100 | 32,245,000$ | 32,245,000$ | 0$ | 19,576,376$ | 32,245,000$ | 19,576,376$ | 25 | 0 | 0$ | 12,128,847$ | 50 | 238,199$ | 11,909,950$ | 12,464,750$ | 33,904,100$ | 18,904,100$ | 40,000,000$ | 6,095,900$ | 25,536,343$ | 25,200,440$ |