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 | Ailes Rouges (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,019,200$ | 2,019,200$ | 858,512$ | 2,019,200$ | 858,512$ | 26 | 2 | 0$ | 53 | 15,546$ | 823,938$ |
2 | As (MIN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,053,000$ | 993,000$ | 691,895$ | 1,053,000$ | 691,895$ | 23 | 0 | 0$ | 53 | 8,441$ | 447,373$ |
3 | Banshees (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,270,000$ | 1,270,000$ | 805,273$ | 1,270,000$ | 805,273$ | 28 | 0 | 0$ | 53 | 10,037$ | 531,961$ |
4 | Canadiens (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 988,500$ | 988,500$ | 741,435$ | 988,500$ | 741,435$ | 23 | 1 | 0$ | 53 | 7,967$ | 422,251$ |
5 | Chiefs (QUE) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,117,700$ | 1,117,700$ | 737,615$ | 1,117,700$ | 737,615$ | 29 | 0 | 0$ | 53 | 8,917$ | 472,601$ |
6 | Citadelles (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,089,300$ | 1,089,300$ | 715,624$ | 1,089,300$ | 715,624$ | 29 | 0 | 0$ | 53 | 8,708$ | 461,524$ |
7 | Croque-Morts (ANA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,184,200$ | 1,184,200$ | 778,932$ | 1,184,200$ | 778,932$ | 28 | 0 | 0$ | 53 | 9,406$ | 498,518$ |
8 | Harvard (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 999,550$ | 999,550$ | 727,478$ | 999,550$ | 727,478$ | 24 | 0 | 0$ | 53 | 8,048$ | 426,544$ |
9 | Isotopes (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,240,080$ | 1,240,080$ | 830,133$ | 1,240,080$ | 830,133$ | 28 | 0 | 0$ | 53 | 9,817$ | 520,301$ |
10 | Pacifiques de la route (CAL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,078,700$ | 1,078,700$ | 753,950$ | 1,078,700$ | 753,950$ | 26 | 0 | 0$ | 53 | 8,630$ | 457,390$ |
11 | Riverman (VAN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,788,500$ | 1,748,500$ | 747,893$ | 1,788,500$ | 747,893$ | 30 | 0 | 0$ | 53 | 13,849$ | 733,997$ |
12 | Snipers (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,784,950$ | 1,784,950$ | 871,800$ | 1,784,950$ | 871,800$ | 32 | 0 | 0$ | 53 | 13,823$ | 732,619$ |
13 | Spoonman's (HAR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 15 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,414,100$ | 1,424,100$ | 918,554$ | 1,414,100$ | 918,554$ | 30 | 0 | 0$ | 53 | 11,096$ | 588,088$ |
14 | Wolves (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 16 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,275,800$ | 1,275,800$ | 1,337,590$ | 1,275,800$ | 1,337,590$ | 33 | 0 | 0$ | 53 | 16,366$ | 867,398$ |