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 | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | Équipe | Niveau1 | Niveau2 | Niveau1 | Niveau2 | Niveau1 | Niveau2 | Niveau1 | Niveau2 | 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 | 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 | Revenus de la Saison Éstimés | Jours Restants de la Saison | Dépenses Par Jour | Dépenses de la Saison Éstimées |
1 | Admirals (ANA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,849,782$ | 2,849,782$ | 387,881$ | 0$ | 298,766$ | 0 | 0 | 0$ | 111 | 29,837$ | 3,311,907$ |
2 | Bruins (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,382,769$ | 3,196,494$ | 548,600$ | 0$ | 354,640$ | 0 | 0 | 0$ | 111 | 42,200$ | 4,684,200$ |
3 | Condors (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,791,190$ | 1,743,440$ | 278,915$ | 0$ | 184,561$ | 0 | 0 | 0$ | 111 | 21,703$ | 2,409,033$ |
4 | Crunch (TBL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,290,000$ | 1,252,500$ | 401,011$ | 0$ | 135,239$ | 0 | 0 | 0$ | 111 | 30,847$ | 3,424,017$ |
5 | Flames (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,409,970$ | 2,133,637$ | 423,824$ | 0$ | 240,362$ | 0 | 0 | 0$ | 111 | 33,548$ | 3,723,828$ |
6 | Griffins (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,620,931$ | 2,202,764$ | 744,577$ | 0$ | 272,800$ | 0 | 0 | 0$ | 111 | 57,427$ | 6,374,397$ |
7 | IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,916,519$ | 2,470,811$ | 594,074$ | 0$ | 305,760$ | 0 | 0 | 0$ | 111 | 45,698$ | 5,072,478$ |
8 | Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,933,835$ | 1,892,502$ | 831,779$ | 0$ | 202,735$ | 0 | 0 | 0$ | 111 | 63,983$ | 7,102,113$ |
9 | Monarchs (LAK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,786,967$ | 2,285,967$ | 659,113$ | 0$ | 292,188$ | 0 | 0 | 0$ | 111 | 50,701$ | 5,627,811$ |
10 | Monsters (CLB) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,529,773$ | 2,531,548$ | 425,675$ | 0$ | 268,414$ | 0 | 0 | 0$ | 111 | 32,498$ | 3,607,278$ |
11 | Moose (WPG) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,850,042$ | 2,624,834$ | 679,078$ | 0$ | 312,140$ | 0 | 0 | 0$ | 111 | 51,210$ | 5,684,310$ |
12 | Penguins (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,338,660$ | 2,649,914$ | 880,106$ | 0$ | 355,920$ | 0 | 0 | 0$ | 111 | 67,247$ | 7,464,417$ |
13 | Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,305,831$ | 2,284,415$ | 350,206$ | 0$ | 261,091$ | 0 | 0 | 0$ | 111 | 25,450$ | 2,824,950$ |
14 | Rampage (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,664,833$ | 1,618,750$ | 403,709$ | 0$ | 167,824$ | 0 | 0 | 0$ | 111 | 31,571$ | 3,504,381$ |
15 | Rocket (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,616,625$ | 2,311,042$ | 447,304$ | 0$ | 274,326$ | 0 | 0 | 0$ | 111 | 34,408$ | 3,819,288$ |
16 | Senators (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,813,333$ | 1,644,000$ | 275,608$ | 0$ | 186,503$ | 0 | 0 | 0$ | 111 | 21,478$ | 2,384,058$ |
17 | Sharks (SJS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,120,941$ | 3,065,945$ | 438,725$ | 0$ | 307,683$ | 0 | 0 | 0$ | 111 | 35,250$ | 3,912,750$ |
18 | Soldiers (VGK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,887,640$ | 2,368,607$ | 444,899$ | 0$ | 302,731$ | 0 | 0 | 0$ | 111 | 34,223$ | 3,798,753$ |
19 | Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,185,559$ | 3,587,308$ | 1,769,975$ | 0$ | 459,497$ | 0 | 0 | 0$ | 111 | 134,561$ | 14,936,271$ |
20 | Stars (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 36 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,472,126$ | 1,472,126$ | 285,389$ | 0$ | 154,336$ | 0 | 0 | 0$ | 111 | 21,953$ | 2,436,783$ |
21 | Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,708,168$ | 3,456,251$ | 501,475$ | 0$ | 399,261$ | 0 | 0 | 0$ | 111 | 37,767$ | 4,192,137$ |
22 | Wolves (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,688,368$ | 3,451,785$ | 490,106$ | 0$ | 385,274$ | 0 | 0 | 0$ | 111 | 37,809$ | 4,196,799$ |