| 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 (NSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,059,333$ | 1,059,333$ | 1,320,948$ | 5,695$ | 831,696$ | 0 | 0 | 0$ | 57 | 9,459$ | 529,704$ |
| 2 |  American (BUF) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,716,276$ | 1,716,276$ | 1,786,430$ | 9,227$ | 1,192,355$ | 0 | 0 | 0$ | 57 | 13,797$ | 772,632$ |
| 3 |  Barrucada (SJS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,109,532$ | 1,109,532$ | 1,384,245$ | 5,965$ | 825,115$ | 0 | 0 | 0$ | 57 | 10,266$ | 574,896$ |
| 4 |  Bears (WSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,682,333$ | 1,682,333$ | 1,696,379$ | 9,045$ | 1,172,196$ | 0 | 0 | 0$ | 57 | 13,077$ | 732,312$ |
| 5 |  Bruins (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,409,334$ | 1,409,334$ | 1,539,768$ | 7,577$ | 980,602$ | 0 | 0 | 0$ | 57 | 11,878$ | 665,168$ |
| 6 |  Canucks (VAN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,507,417$ | 1,507,417$ | 1,661,872$ | 8,104$ | 1,172,572$ | 0 | 0 | 0$ | 57 | 11,868$ | 664,608$ |
| 7 |  Checkers (FLO) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,145,166$ | 1,145,166$ | 1,429,217$ | 6,157$ | 835,117$ | 0 | 0 | 0$ | 57 | 10,727$ | 600,712$ |
| 8 | Chekers (SEA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 545,000$ | 545,000$ | 867,467$ | 2,930$ | 448,135$ | 0 | 0 | 0$ | 57 | 6,156$ | 344,736$ |
| 9 |  Comets (NJD) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 975,666$ | 975,666$ | 1,509,327$ | 5,246$ | 845,299$ | 0 | 0 | 0$ | 57 | 10,353$ | 579,768$ |
| 10 |  Condors (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,359,000$ | 1,359,000$ | 1,622,471$ | 7,306$ | 1,098,285$ | 0 | 0 | 0$ | 57 | 11,339$ | 634,984$ |
| 11 |  Crunch (TBL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 945,917$ | 945,917$ | 1,335,973$ | 5,086$ | 706,970$ | 0 | 0 | 0$ | 57 | 9,924$ | 555,744$ |
| 12 |  Eagles (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,190,500$ | 1,190,500$ | 1,492,909$ | 6,401$ | 933,779$ | 0 | 0 | 0$ | 57 | 10,702$ | 599,312$ |
| 13 |  Griffins (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 867,612$ | 867,612$ | 1,183,423$ | 4,665$ | 624,211$ | 0 | 0 | 0$ | 57 | 8,966$ | 502,096$ |
| 14 |  Gulls (ANA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,457,639$ | 1,457,639$ | 1,713,441$ | 7,837$ | 1,084,442$ | 0 | 0 | 0$ | 57 | 12,675$ | 709,800$ |
| 15 |  Heat (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,019,784$ | 1,019,784$ | 1,347,425$ | 5,483$ | 788,295$ | 0 | 0 | 0$ | 57 | 9,784$ | 547,904$ |
| 16 |  IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 958,750$ | 958,750$ | 1,238,448$ | 5,155$ | 714,279$ | 0 | 0 | 0$ | 57 | 9,187$ | 514,472$ |
| 17 |  Islanders (NYI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,407,250$ | 1,407,250$ | 1,608,989$ | 7,566$ | 1,049,839$ | 0 | 0 | 0$ | 57 | 11,867$ | 664,552$ |
| 18 |  Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 989,394$ | 989,394$ | 1,262,805$ | 5,319$ | 738,621$ | 0 | 0 | 0$ | 57 | 9,352$ | 523,712$ |
| 19 |  Monsters (CLB) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 586,500$ | 586,500$ | 995,778$ | 3,153$ | 506,504$ | 0 | 0 | 0$ | 57 | 6,917$ | 387,352$ |
| 20 |  Moose (WIN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,172,167$ | 1,172,167$ | 1,348,853$ | 6,302$ | 789,723$ | 0 | 0 | 0$ | 57 | 10,603$ | 593,768$ |
| 21 |  Penguins (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 818,167$ | 818,167$ | 1,224,846$ | 4,399$ | 630,781$ | 0 | 0 | 0$ | 57 | 8,969$ | 502,264$ |
| 22 |  Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,149,083$ | 1,149,083$ | 1,550,109$ | 6,178$ | 851,229$ | 0 | 0 | 0$ | 57 | 11,554$ | 647,024$ |
| 23 |  Reign (LAK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,894,261$ | 1,894,261$ | 1,933,088$ | 10,184$ | 1,338,988$ | 0 | 0 | 0$ | 57 | 14,754$ | 826,224$ |
| 24 |  Roadrunners (ARI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,033,083$ | 1,033,083$ | 1,490,833$ | 5,554$ | 861,807$ | 0 | 0 | 0$ | 57 | 10,393$ | 582,008$ |
| 25 |  Rocket (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,265,018$ | 1,265,018$ | 1,602,089$ | 6,801$ | 1,007,989$ | 0 | 0 | 0$ | 57 | 11,371$ | 636,776$ |
| 26 |  Senators (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,130,865$ | 1,130,865$ | 1,425,378$ | 6,080$ | 901,203$ | 0 | 0 | 0$ | 57 | 10,112$ | 566,272$ |
| 27 | Silver Knights (VEG) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,331,283$ | 1,331,283$ | 1,601,193$ | 7,157$ | 1,007,093$ | 0 | 0 | 0$ | 57 | 11,727$ | 656,712$ |
| 28 |  Stars (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,763,865$ | 1,763,865$ | 1,867,943$ | 9,483$ | 1,238,890$ | 0 | 0 | 0$ | 57 | 14,322$ | 802,032$ |
| 29 |  Thunderbirds (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,195,408$ | 1,195,408$ | 1,332,377$ | 6,427$ | 843,167$ | 0 | 0 | 0$ | 57 | 10,190$ | 570,640$ |
| 30 |  Wild (MIN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,086,416$ | 1,086,416$ | 1,310,964$ | 5,841$ | 786,782$ | 0 | 0 | 0$ | 57 | 9,873$ | 552,888$ |
| 31 |  Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 12 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,834,196$ | 1,834,196$ | 2,050,575$ | 9,861$ | 1,421,543$ | 0 | 0 | 0$ | 57 | 14,700$ | 823,200$ |
| 32 |  Wolves (CAR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 11 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,257,709$ | 1,257,709$ | 1,668,229$ | 6,762$ | 1,178,984$ | 0 | 0 | 0$ | 57 | 10,525$ | 589,400$ |