| 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% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 926,907$ | 926,907$ | 768,100$ | 0$ | 350,408$ | 0 | 0 | 0$ | 148 | 8,552$ | 1,257,144$ |
| 2 | Barracuda (SJ.) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 911,083$ | 911,083$ | 535,860$ | 0$ | 345,960$ | 0 | 0 | 0$ | 148 | 5,954$ | 875,238$ |
| 3 | Bears (WSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 86,333$ | 86,333$ | 184,316$ | 0$ | 32,396$ | 0 | 0 | 0$ | 148 | 2,052$ | 301,644$ |
| 4 | Blacknight (VGS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 966,499$ | 966,499$ | 368,122$ | 0$ | 178,283$ | 0 | 0 | 0$ | 148 | 6,188$ | 909,636$ |
| 5 | Bruins (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 994,417$ | 994,417$ | 822,566$ | 0$ | 366,862$ | 0 | 0 | 0$ | 148 | 9,259$ | 1,361,073$ |
| 6 | Condors (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,378,900$ | 2,378,900$ | 925,215$ | 0$ | 811,322$ | 0 | 0 | 0$ | 148 | 11,303$ | 1,661,541$ |
| 7 | Crunch (TB.) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 24 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 472,000$ | 472,000$ | 634,950$ | 0$ | 179,280$ | 0 | 0 | 0$ | 148 | 7,055$ | 1,037,085$ |
| 8 | Devils (NJD) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 26 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,889,600$ | 1,889,600$ | 1,151,775$ | 0$ | 715,094$ | 0 | 0 | 0$ | 148 | 12,825$ | 1,885,275$ |
| 9 | Gulls (ANA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 375,000$ | 375,000$ | 330,384$ | 0$ | 140,484$ | 0 | 0 | 0$ | 148 | 3,692$ | 542,724$ |
| 10 | Heat (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 225,000$ | 225,000$ | 487,672$ | 0$ | 69,911$ | 0 | 0 | 0$ | 148 | 5,591$ | 821,877$ |
| 11 | Icedogs (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 514,417$ | 514,417$ | 396,270$ | 0$ | 195,390$ | 0 | 0 | 0$ | 148 | 4,403$ | 647,241$ |
| 12 | Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,973,162$ | 1,960,750$ | 855,991$ | 0$ | 732,598$ | 0 | 0 | 0$ | 148 | 9,697$ | 1,425,459$ |
| 13 | Monsters (CLB) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 553,750$ | 553,750$ | 324,180$ | 0$ | 210,240$ | 0 | 0 | 0$ | 148 | 3,602$ | 529,494$ |
| 14 | Moose (WPG) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 586,750$ | 586,750$ | 507,235$ | 0$ | 317,342$ | 0 | 0 | 0$ | 148 | 4,585$ | 673,995$ |
| 15 | Penguins (Pit) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,181,917$ | 1,166,917$ | 560,685$ | 0$ | 446,749$ | 0 | 0 | 0$ | 148 | 6,253$ | 919,191$ |
| 16 | Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 586,333$ | 586,333$ | 620,651$ | 0$ | 240,882$ | 0 | 0 | 0$ | 148 | 6,693$ | 983,871$ |
| 17 | Rampages (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 26 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 939,750$ | 939,750$ | 514,610$ | 0$ | 362,713$ | 0 | 0 | 0$ | 148 | 5,653$ | 830,991$ |
| 18 | Reigh (LA.) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,276,417$ | 1,276,417$ | 673,602$ | 0$ | 483,789$ | 0 | 0 | 0$ | 148 | 7,495$ | 1,101,765$ |
| 19 | Rocket (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 26 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,066,245$ | 1,066,245$ | 784,620$ | 0$ | 404,910$ | 0 | 0 | 0$ | 148 | 8,718$ | 1,281,546$ |
| 20 | Senateurs (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 3,130,000$ | 3,230,000$ | 1,659,685$ | 0$ | 1,279,922$ | 0 | 0 | 0$ | 148 | 17,426$ | 2,561,622$ |
| 21 | Sound Tigers (NYI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 604,912$ | 604,912$ | 361,978$ | 0$ | 229,048$ | 0 | 0 | 0$ | 148 | 4,029$ | 592,263$ |
| 22 | Stars (DAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,213,251$ | 968,251$ | 724,882$ | 0$ | 459,022$ | 0 | 0 | 0$ | 148 | 8,073$ | 1,186,731$ |
| 23 | Thunderbird (FLA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 930,000$ | 930,000$ | 457,395$ | 0$ | 267,531$ | 0 | 0 | 0$ | 148 | 6,034$ | 886,998$ |
| 24 | Wolves (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 25 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 736,500$ | 736,500$ | 735,390$ | 0$ | 279,720$ | 0 | 0 | 0$ | 148 | 8,171$ | 1,201,137$ |