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 | 3L (WAS) | 2000 | 1000 | 35 | 15 | 6000 | 3000 | 100.00% | 100.00% | 36 | 3000 - 100.00% | 97,750$ | 293,250$ | 3000 | 100 | 1,430,000$ | 1,430,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
2 | Armada (EDM) | 2000 | 1000 | 40 | 20 | 9164 | 4462 | 91.64% | 89.24% | 34 | 2725 - 90.84% | 104,834$ | 524,170$ | 3000 | 100 | 3,752,500$ | 3,752,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
3 | Chops (BUF) | 2000 | 1000 | 50 | 25 | 0 | 0 | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 940,000$ | 940,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
4 | Draveurs (OTT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,425,000$ | 1,425,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
5 | Griffins (DET) | 2000 | 1000 | 40 | 20 | 0 | 0 | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,585,000$ | 2,585,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
6 | Heat (CGY) | 2000 | 1000 | 30 | 15 | 18000 | 9000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 86,250$ | 776,250$ | 3000 | 100 | 2,282,500$ | 2,282,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
7 | Jarrets Noirs (ANA) | 2000 | 1000 | 33 | 13 | 0 | 0 | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,950,000$ | 1,950,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
8 | Monarchs (LAK) | 2000 | 1000 | 30 | 20 | 10000 | 4633 | 100.00% | 92.66% | 34 | 2927 - 97.55% | 89,162$ | 445,809$ | 3000 | 100 | 2,090,000$ | 2,070,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
9 | Monster (TOR) | 2000 | 1000 | 35 | 15 | 3994 | 1994 | 99.85% | 99.70% | 37 | 2994 - 99.80% | 97,577$ | 195,154$ | 3000 | 100 | 3,662,500$ | 3,662,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
10 | Mosquitos (MIN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,515,000$ | 1,485,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
11 | National (PIT) | 2000 | 1000 | 35 | 15 | 5971 | 3000 | 99.52% | 100.00% | 36 | 2990 - 99.68% | 97,361$ | 292,083$ | 3000 | 100 | 2,730,000$ | 2,730,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
12 | Pantheres (NYI) | 2000 | 1000 | 40 | 20 | 17153 | 8331 | 95.29% | 92.57% | 30 | 2832 - 94.39% | 108,961$ | 980,651$ | 3000 | 100 | 2,647,500$ | 2,647,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
13 | Phantoms (PHI) | 2000 | 1000 | 40 | 20 | 22467 | 11236 | 93.61% | 93.63% | 27 | 2809 - 93.62% | 107,659$ | 1,291,910$ | 3000 | 100 | 3,973,500$ | 3,953,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
14 | Rambo (SJS) | 2000 | 1000 | 35 | 15 | 6000 | 3000 | 100.00% | 100.00% | 36 | 3000 - 100.00% | 97,750$ | 293,250$ | 3000 | 100 | 1,757,500$ | 1,757,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
15 | Rapido (CLB) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,032,500$ | 2,032,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
16 | Red Bull (COL) | 2000 | 1000 | 50 | 30 | 0 | 0 | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,842,500$ | 2,842,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
17 | Rivermen (STL) | 2000 | 1000 | 50 | 30 | 2838 | 1268 | 70.95% | 63.40% | 37 | 2053 - 68.43% | 103,466$ | 206,932$ | 3000 | 100 | 2,660,000$ | 2,660,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
18 | Rocket (WPG) | 2000 | 1000 | 40 | 20 | 9538 | 4626 | 95.38% | 92.52% | 34 | 2833 - 94.43% | 109,029$ | 545,146$ | 3000 | 100 | 2,120,000$ | 2,615,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
19 | Rockets (CHI) | 2000 | 1000 | 35 | 15 | 4000 | 2000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 97,750$ | 195,500$ | 3000 | 100 | 2,497,000$ | 2,477,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
20 | Sea Dogs (MTL) | 2000 | 1000 | 50 | 30 | 10937 | 4505 | 78.12% | 64.36% | 32 | 2206 - 73.53% | 112,043$ | 784,299$ | 3000 | 100 | 2,390,000$ | 2,390,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
21 | Spartans (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 39 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,172,500$ | 2,172,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
22 | Trashers (NAS) | 2000 | 1000 | 35 | 15 | 6000 | 3000 | 100.00% | 100.00% | 36 | 3000 - 100.00% | 97,750$ | 293,250$ | 3000 | 100 | 3,972,500$ | 3,972,500$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
23 | Walleye (VGK) | 2000 | 1000 | 50 | 30 | 4458 | 1930 | 74.30% | 64.33% | 36 | 2129 - 70.98% | 107,640$ | 322,921$ | 3000 | 100 | 1,905,000$ | 1,905,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |
24 | Wolf Pack (NYR) | 2000 | 1000 | 40 | 20 | 13173 | 6595 | 94.09% | 94.21% | 32 | 2824 - 94.13% | 108,235$ | 757,643$ | 3000 | 100 | 2,540,000$ | 2,540,000$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0 | 0$ | 0$ |