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 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | Équipe | Niveau1 | Niveau2 | Niveau1 | Niveau2 | Niveau1 | Niveau2 | Niveau1 | Niveau2 | 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 | Dépenses annuelles à ce jour | Plafond salarial par jour | Plafond salarial à ce jour | Joueurs Inclus dans le plafond salarial | Joueurs exclut du plafond Salarial | Revenus de la saison estimés | Jours restants de la saison | Dépenses par jour | Dépenses de la saison estimées |
1 | Admirals (ANA) | 2000 | 1000 | 33 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,701,527$ | 3,569,027$ | 128,808$ | 0$ | 101,412$ | 0 | 0 | 0$ | 153 | 32,202$ | 4,572,684$ |
2 | Bruins (BOS) | 2000 | 1000 | 35 | 15 | 1737 | 872 | 86.85% | 87.20% | 35 | 2609 - 86.97% | 81,263$ | 81,263$ | 3000 | 100 | 2,897,498$ | 2,626,082$ | 120,480$ | 0$ | 79,384$ | 0 | 0 | 2,844,205$ | 153 | 30,120$ | 4,277,040$ |
3 | Condors (EDM) | 2000 | 1000 | 35 | 15 | 1739 | 1000 | 86.95% | 100.00% | 35 | 2739 - 91.30% | 83,451$ | 83,451$ | 3000 | 100 | 2,282,917$ | 2,255,417$ | 75,559$ | 0$ | 61,859$ | 0 | 0 | 2,920,785$ | 153 | 19,061$ | 2,706,662$ |
4 | Crunch (TBL) | 2000 | 1000 | 35 | 15 | 1724 | 868 | 86.20% | 86.80% | 35 | 2592 - 86.40% | 80,696$ | 80,696$ | 3000 | 100 | 4,683,084$ | 4,683,084$ | 183,100$ | 0$ | 128,304$ | 0 | 0 | 2,824,360$ | 153 | 45,775$ | 6,500,050$ |
5 | Flames (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,695,555$ | 2,686,222$ | 101,248$ | 0$ | 73,852$ | 0 | 0 | 0$ | 153 | 25,312$ | 3,594,304$ |
6 | Griffins (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,891,667$ | 2,817,500$ | 147,716$ | 0$ | 79,224$ | 0 | 0 | 0$ | 153 | 36,929$ | 5,243,918$ |
7 | IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 1775 | 882 | 88.75% | 88.20% | 35 | 2657 - 88.57% | 82,891$ | 82,891$ | 3000 | 100 | 2,685,329$ | 2,548,830$ | 114,085$ | 0$ | 72,989$ | 0 | 0 | 2,901,185$ | 153 | 28,667$ | 4,070,714$ |
8 | Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,695,060$ | 2,645,892$ | 142,332$ | 0$ | 73,836$ | 0 | 0 | 0$ | 153 | 35,583$ | 5,052,786$ |
9 | Monarchs (LAK) | 2000 | 1000 | 35 | 15 | 1834 | 888 | 91.70% | 88.80% | 35 | 2722 - 90.73% | 85,261$ | 85,261$ | 3000 | 100 | 2,424,244$ | 2,424,244$ | 80,116$ | 0$ | 66,416$ | 0 | 0 | 2,984,135$ | 153 | 20,029$ | 2,844,118$ |
10 | Monsters (CLB) | 2000 | 1000 | 35 | 15 | 1974 | 900 | 98.70% | 90.00% | 35 | 2874 - 95.80% | 90,849$ | 90,849$ | 3000 | 100 | 3,157,732$ | 3,090,565$ | 132,813$ | 0$ | 91,717$ | 0 | 0 | 0$ | 153 | 31,902$ | 4,530,084$ |
11 | Moose (WPG) | 2000 | 1000 | 35 | 15 | 1801 | 1000 | 90.05% | 100.00% | 35 | 2801 - 93.37% | 85,839$ | 85,839$ | 3000 | 100 | 4,150,000$ | 4,100,000$ | 144,366$ | 0$ | 116,970$ | 0 | 0 | 0$ | 153 | 35,274$ | 5,008,908$ |
12 | Penguins (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,038,833$ | 3,953,833$ | 165,448$ | 0$ | 110,652$ | 0 | 0 | 0$ | 153 | 41,362$ | 5,873,404$ |
13 | Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 1714 | 951 | 85.70% | 95.10% | 35 | 2665 - 88.83% | 81,681$ | 81,681$ | 3000 | 100 | 2,687,616$ | 2,687,616$ | 87,332$ | 0$ | 73,632$ | 0 | 0 | 2,858,835$ | 153 | 21,833$ | 3,100,286$ |
14 | Rampage (COL) | 2000 | 1000 | 40 | 20 | 1421 | 566 | 71.05% | 56.60% | 35 | 1987 - 66.23% | 74,976$ | 74,976$ | 3000 | 100 | 2,939,584$ | 2,807,084$ | 107,932$ | 0$ | 80,536$ | 0 | 0 | 2,624,160$ | 153 | 26,983$ | 3,831,586$ |
15 | Rocket (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,701,117$ | 2,653,617$ | 101,400$ | 0$ | 74,004$ | 0 | 0 | 0$ | 153 | 25,350$ | 3,599,700$ |
16 | Senators (OTT) | 2000 | 1000 | 35 | 15 | 1979 | 1000 | 98.95% | 100.00% | 35 | 2979 - 99.30% | 92,691$ | 92,691$ | 3000 | 100 | 3,733,416$ | 3,532,833$ | 143,380$ | 0$ | 102,284$ | 0 | 0 | 3,244,185$ | 153 | 35,845$ | 5,089,990$ |
17 | Sharks (SJS) | 2000 | 1000 | 35 | 15 | 2000 | 896 | 100.00% | 89.60% | 35 | 2896 - 96.53% | 91,784$ | 91,784$ | 3000 | 100 | 3,080,625$ | 3,080,625$ | 112,009$ | 0$ | 84,612$ | 0 | 0 | 3,212,440$ | 153 | 27,949$ | 3,968,758$ |
18 | Soldiers (VGK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,916,930$ | 2,889,846$ | 93,616$ | 0$ | 79,916$ | 0 | 0 | 0$ | 153 | 23,404$ | 3,323,368$ |
19 | Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,377,582$ | 4,124,249$ | 162,056$ | 0$ | 120,960$ | 0 | 0 | 0$ | 153 | 40,257$ | 5,716,494$ |
20 | Stars (DAL) | 2000 | 1000 | 35 | 15 | 1795 | 928 | 89.75% | 92.80% | 35 | 2723 - 90.77% | 84,419$ | 84,419$ | 3000 | 100 | 2,640,214$ | 2,620,214$ | 101,119$ | 0$ | 73,721$ | 0 | 0 | 2,954,665$ | 153 | 24,933$ | 3,540,486$ |
21 | Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 1786 | 931 | 89.30% | 93.10% | 35 | 2717 - 90.57% | 84,123$ | 84,123$ | 3000 | 100 | 3,975,533$ | 3,906,867$ | 122,616$ | 0$ | 108,920$ | 0 | 0 | 0$ | 153 | 30,654$ | 4,352,868$ |
22 | Wolves (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,205,333$ | 1,960,917$ | 74,120$ | 0$ | 60,420$ | 0 | 0 | 0$ | 153 | 18,530$ | 2,631,260$ |