| 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 (NSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,323,499$ | 643,416$ | 813,728$ | 0$ | 813,728$ | 0 | 0 | 0$ | 72 | 7,272$ | 523,584$ |
| 2 | Americans (BUF) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,408,870$ | 448,333$ | 991,550$ | 0$ | 991,550$ | 0 | 0 | 0$ | 72 | 7,741$ | 557,352$ |
| 3 | Barracuda (SJS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,535,833$ | 714,250$ | 1,590,420$ | 0$ | 1,590,420$ | 0 | 0 | 0$ | 72 | 13,933$ | 1,003,176$ |
| 4 | Bears (WSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,091,667$ | 155,000$ | 624,440$ | 0$ | 624,440$ | 0 | 0 | 0$ | 72 | 5,998$ | 431,856$ |
| 5 | Bruins (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,882,749$ | 821,999$ | 1,235,175$ | 0$ | 1,235,175$ | 0 | 0 | 0$ | 72 | 10,345$ | 744,840$ |
| 6 | Checkers (CAR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,372,500$ | 325,000$ | 832,564$ | 0$ | 832,564$ | 0 | 0 | 0$ | 72 | 7,541$ | 542,952$ |
| 7 | Comets (VAN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,561,000$ | 621,583$ | 928,833$ | 0$ | 928,833$ | 0 | 0 | 0$ | 72 | 8,577$ | 617,544$ |
| 8 | Condors (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 896,667$ | 316,083$ | 637,060$ | 0$ | 637,060$ | 0 | 0 | 0$ | 72 | 4,927$ | 354,744$ |
| 9 | Crunch (TBL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,568,495$ | 1,160,750$ | 1,552,320$ | 0$ | 1,552,320$ | 0 | 0 | 0$ | 72 | 14,113$ | 1,016,136$ |
| 10 | Devils (NJD) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,346,667$ | 461,250$ | 853,545$ | 0$ | 853,545$ | 0 | 0 | 0$ | 72 | 7,399$ | 532,728$ |
| 11 | Eagles (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,587,501$ | 507,667$ | 1,014,742$ | 0$ | 1,014,742$ | 0 | 0 | 0$ | 72 | 8,723$ | 628,056$ |
| 12 | Griffins (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,372,250$ | 384,417$ | 826,976$ | 0$ | 826,976$ | 0 | 0 | 0$ | 72 | 7,540$ | 542,880$ |
| 13 | Gulls (ANA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,740,324$ | 1,402,999$ | 1,652,395$ | 0$ | 1,652,395$ | 0 | 0 | 0$ | 72 | 15,057$ | 1,084,104$ |
| 14 | Heat (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 555,000$ | 0$ | 400,404$ | 0$ | 400,404$ | 0 | 0 | 0$ | 72 | 3,049$ | 219,528$ |
| 15 | IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,534,833$ | 780,083$ | 1,110,227$ | 0$ | 1,110,227$ | 0 | 0 | 0$ | 72 | 8,433$ | 607,176$ |
| 16 | Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,603,515$ | 1,580,951$ | 1,706,698$ | 0$ | 1,706,698$ | 0 | 0 | 0$ | 72 | 14,305$ | 1,029,960$ |
| 17 | Monsters (CLB) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,451,246$ | 1,433,917$ | 1,745,506$ | 0$ | 1,745,506$ | 0 | 0 | 0$ | 72 | 13,468$ | 969,696$ |
| 18 | Moose (WIN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,625,000$ | 447,500$ | 1,009,739$ | 0$ | 1,009,739$ | 0 | 0 | 0$ | 72 | 8,929$ | 642,888$ |
| 19 | Penguins (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 934,333$ | 303,083$ | 635,275$ | 0$ | 635,275$ | 0 | 0 | 0$ | 72 | 5,134$ | 369,648$ |
| 20 | Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,209,750$ | 832,167$ | 822,077$ | 0$ | 822,077$ | 0 | 0 | 0$ | 72 | 6,647$ | 478,584$ |
| 21 | Rampage (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,097,000$ | 844,667$ | 1,119,632$ | 0$ | 1,119,632$ | 0 | 0 | 0$ | 72 | 11,522$ | 829,584$ |
| 22 | Reign (LAK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,538,083$ | 1,388,833$ | 1,482,774$ | 0$ | 1,482,774$ | 0 | 0 | 0$ | 72 | 13,946$ | 1,004,112$ |
| 23 | Roadrunners (ARI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,102,876$ | 736,500$ | 1,284,681$ | 0$ | 1,284,681$ | 0 | 0 | 0$ | 72 | 11,554$ | 831,888$ |
| 24 | Rocket (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,563,002$ | 1,148,335$ | 1,476,554$ | 0$ | 1,476,554$ | 0 | 0 | 0$ | 72 | 14,082$ | 1,013,904$ |
| 25 | Senators (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,549,815$ | 1,132,232$ | 1,022,826$ | 0$ | 1,022,826$ | 0 | 0 | 0$ | 72 | 8,515$ | 613,080$ |
| 26 | Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,379,579$ | 727,166$ | 833,800$ | 0$ | 833,800$ | 0 | 0 | 0$ | 72 | 7,580$ | 545,760$ |
| 27 | Stars (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,388,749$ | 1,109,311$ | 1,474,755$ | 0$ | 1,474,755$ | 0 | 0 | 0$ | 72 | 13,125$ | 945,000$ |
| 28 | Thunderbirds (FLO) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,817,416$ | 853,416$ | 1,123,406$ | 0$ | 1,123,406$ | 0 | 0 | 0$ | 72 | 9,986$ | 718,992$ |
| 29 | Wild (MIN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,306,583$ | 1,239,084$ | 1,354,093$ | 0$ | 1,354,093$ | 0 | 0 | 0$ | 72 | 12,674$ | 912,528$ |
| 30 | Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,086,166$ | 1,271,166$ | 1,256,492$ | 0$ | 1,256,492$ | 0 | 0 | 0$ | 72 | 11,462$ | 825,264$ |
| 31 | Wolves (VGK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,724,250$ | 979,833$ | 1,145,902$ | 0$ | 1,145,902$ | 0 | 0 | 0$ | 72 | 9,474$ | 682,128$ |