| 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 |  67s (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,069,582$ | 2,868,999$ | 971,709$ | 0$ | 652,366$ | 0 | 0 | 0$ | 122 | 29,481$ | 3,596,682$ |
| 2 |  Barracuda (SJS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 28 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,544,667$ | 2,544,667$ | 762,915$ | 0$ | 550,015$ | 0 | 0 | 0$ | 122 | 22,869$ | 2,790,018$ |
| 3 |  Bruins (BOS) | 2000 | 1000 | 30 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,541,249$ | 2,294,833$ | 847,954$ | 0$ | 528,605$ | 0 | 0 | 0$ | 122 | 26,073$ | 3,180,906$ |
| 4 |  Condors (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 28 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,855,166$ | 2,784,333$ | 720,884$ | 0$ | 614,427$ | 0 | 0 | 0$ | 122 | 21,646$ | 2,640,812$ |
| 5 |  Crunch (TBL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,800,667$ | 3,800,667$ | 1,308,585$ | 0$ | 882,777$ | 0 | 0 | 0$ | 122 | 37,424$ | 4,565,728$ |
| 6 |  Eagles (COL) | 2000 | 1000 | 45 | 25 | 0 | 0 | 0.00% | 0.00% | 28 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 5,985,080$ | 5,985,080$ | 888,480$ | 0$ | 675,588$ | 0 | 0 | 0$ | 122 | 45,065$ | 5,497,930$ |
| 7 |  Griffins (DET) | 2000 | 1000 | 36 | 16 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,025,084$ | 2,941,751$ | 849,837$ | 0$ | 636,946$ | 0 | 0 | 0$ | 122 | 25,968$ | 3,168,096$ |
| 8 |  Gulls (ANA) | 2000 | 1000 | 33 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,324,384$ | 3,191,884$ | 923,596$ | 0$ | 710,681$ | 0 | 0 | 0$ | 122 | 27,899$ | 3,403,678$ |
| 9 |  Heat (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,321,002$ | 2,311,669$ | 727,386$ | 0$ | 514,478$ | 0 | 0 | 0$ | 122 | 21,426$ | 2,613,972$ |
| 10 |  IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,927,704$ | 2,883,287$ | 949,982$ | 0$ | 630,623$ | 0 | 0 | 0$ | 122 | 28,566$ | 3,485,052$ |
| 11 |  Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,597,917$ | 2,583,750$ | 1,126,897$ | 0$ | 594,640$ | 0 | 0 | 0$ | 122 | 32,890$ | 4,012,580$ |
| 12 |  Monarchs (LAK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 28 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,319,328$ | 2,319,328$ | 599,999$ | 0$ | 493,543$ | 0 | 0 | 0$ | 122 | 18,189$ | 2,219,058$ |
| 13 |  Monsters (CLB) | 2000 | 1000 | 35 | 20 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,265,684$ | 3,239,517$ | 1,022,421$ | 0$ | 703,064$ | 0 | 0 | 0$ | 122 | 30,746$ | 3,751,012$ |
| 14 |  Moose (WPG) | 2000 | 1000 | 150 | 149 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,305,750$ | 3,255,750$ | 865,765$ | 0$ | 652,873$ | 0 | 0 | 0$ | 122 | 27,779$ | 3,389,038$ |
| 15 |  Penguins (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,662,959$ | 3,292,959$ | 1,107,045$ | 0$ | 787,700$ | 0 | 0 | 0$ | 122 | 33,309$ | 4,063,698$ |
| 16 |  Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,063,034$ | 2,930,534$ | 955,995$ | 0$ | 636,652$ | 0 | 0 | 0$ | 122 | 29,439$ | 3,591,558$ |
| 17 |  Rocket (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 28 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,759,935$ | 2,712,435$ | 812,364$ | 0$ | 599,457$ | 0 | 0 | 0$ | 122 | 24,258$ | 2,959,476$ |
| 18 |  Sound Tigers (NYI) | 2000 | 1000 | 150 | 149 | 0 | 0 | 0.00% | 0.00% | 28 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 4,703,300$ | 4,449,968$ | 1,205,354$ | 0$ | 992,451$ | 0 | 0 | 0$ | 122 | 36,795$ | 4,488,990$ |
| 19 |  Stars (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 5,524,168$ | 5,524,168$ | 921,037$ | 0$ | 708,135$ | 0 | 0 | 0$ | 122 | 42,091$ | 5,135,102$ |
| 20 |  Thunderbird (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,797,414$ | 3,666,331$ | 913,283$ | 0$ | 806,827$ | 0 | 0 | 0$ | 122 | 27,725$ | 3,382,450$ |
| 21 |  Wolf Pack (NYR) | 2000 | 1000 | 50 | 30 | 0 | 0 | 0.00% | 0.00% | 27 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,501,416$ | 3,486,500$ | 915,620$ | 0$ | 809,163$ | 0 | 0 | 0$ | 122 | 25,816$ | 3,149,552$ |
| 22 |  Wolves (VGK) | 2000 | 1000 | 50 | 30 | 0 | 0 | 0.00% | 0.00% | 28 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,512,708$ | 2,485,624$ | 716,015$ | 0$ | 503,123$ | 0 | 0 | 0$ | 122 | 22,663$ | 2,764,886$ |