| 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 (NHS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 900,000$ | 900,000$ | 106,812$ | 0$ | 67,542$ | 0 | 0 | 0$ | 174 | 7,330$ | 1,290,080$ |
| 2 | Barracuda (SJ.) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 645,917$ | 645,917$ | 90,000$ | 0$ | 50,730$ | 0 | 0 | 0$ | 174 | 6,000$ | 1,056,000$ |
| 3 | Bears (WSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 589,300$ | 589,300$ | 85,545$ | 0$ | 46,275$ | 0 | 0 | 0$ | 174 | 5,703$ | 1,003,728$ |
| 4 | Blacknight (VGS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,343,833$ | 1,343,833$ | 144,810$ | 0$ | 105,540$ | 0 | 0 | 0$ | 174 | 9,654$ | 1,699,104$ |
| 5 | Bruins (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 820,000$ | 820,000$ | 156,022$ | 0$ | 61,777$ | 0 | 0 | 0$ | 174 | 10,576$ | 1,861,376$ |
| 6 | Condors (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,466,617$ | 1,466,617$ | 142,130$ | 0$ | 118,573$ | 0 | 0 | 0$ | 174 | 9,249$ | 1,627,824$ |
| 7 | Crunch (TB.) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 342,500$ | 342,500$ | 66,165$ | 0$ | 26,895$ | 0 | 0 | 0$ | 174 | 4,411$ | 776,336$ |
| 8 | Devils (NJD) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,248,400$ | 2,205,900$ | 266,895$ | 0$ | 176,580$ | 0 | 0 | 0$ | 174 | 17,793$ | 3,131,568$ |
| 9 | Gulls (ANA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 750,000$ | 750,000$ | 98,175$ | 0$ | 58,905$ | 0 | 0 | 0$ | 174 | 6,545$ | 1,151,920$ |
| 10 | Heat (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 613,333$ | 613,333$ | 85,864$ | 0$ | 46,594$ | 0 | 0 | 0$ | 174 | 5,829$ | 1,025,904$ |
| 11 | Icedogs (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 575,000$ | 575,000$ | 84,420$ | 0$ | 45,150$ | 0 | 0 | 0$ | 174 | 5,628$ | 990,528$ |
| 12 | Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,693,745$ | 1,608,537$ | 158,535$ | 0$ | 133,020$ | 0 | 0 | 0$ | 174 | 10,569$ | 1,860,144$ |
| 13 | Monsters (CLB) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,392,166$ | 1,392,166$ | 165,931$ | 0$ | 103,103$ | 0 | 0 | 0$ | 174 | 11,477$ | 2,019,952$ |
| 14 | Moose (WPG) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 969,250$ | 966,750$ | 115,380$ | 0$ | 76,125$ | 0 | 0 | 0$ | 174 | 7,692$ | 1,353,792$ |
| 15 | Penguins (Pit) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,067,500$ | 1,052,500$ | 107,400$ | 0$ | 83,835$ | 0 | 0 | 0$ | 174 | 7,160$ | 1,260,160$ |
| 16 | Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 440,000$ | 440,000$ | 113,085$ | 0$ | 34,560$ | 0 | 0 | 0$ | 174 | 7,539$ | 1,326,864$ |
| 17 | Rampages (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 708,834$ | 708,834$ | 114,570$ | 0$ | 55,665$ | 0 | 0 | 0$ | 174 | 7,638$ | 1,344,288$ |
| 18 | Reigh (LA.) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,157,050$ | 1,157,050$ | 142,386$ | 0$ | 91,340$ | 0 | 0 | 0$ | 174 | 9,461$ | 1,665,136$ |
| 19 | Rocket (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,119,824$ | 1,119,824$ | 165,095$ | 0$ | 86,558$ | 0 | 0 | 0$ | 174 | 11,099$ | 1,953,424$ |
| 20 | Senateurs (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,617,334$ | 2,617,334$ | 283,299$ | 0$ | 204,761$ | 0 | 0 | 0$ | 174 | 18,939$ | 3,333,264$ |
| 21 | Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 685,000$ | 685,000$ | 81,285$ | 0$ | 53,790$ | 0 | 0 | 0$ | 174 | 5,419$ | 953,744$ |
| 22 | Stars (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,271,650$ | 1,271,650$ | 156,413$ | 0$ | 101,442$ | 0 | 0 | 0$ | 174 | 10,323$ | 1,816,848$ |
| 23 | Thunderbird (FLA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 38 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,038,917$ | 1,038,917$ | 114,023$ | 0$ | 74,753$ | 0 | 0 | 0$ | 174 | 8,057$ | 1,418,032$ |
| 24 | Wolves (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 37 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 570,000$ | 564,167$ | 139,005$ | 0$ | 44,760$ | 0 | 0 | 0$ | 174 | 9,267$ | 1,630,992$ |