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 | Abbotsford Canucks (VAN) | 2000 | 1000 | 45 | 20 | 69065 | 33989 | 95.92% | 94.41% | 0 | 2863 - 95.42% | 105,214$ | 3,787,705$ | 3000 | 100 | 2,950,297$ | 2,950,297$ | 3,160,816$ | 0$ | 2,660,820$ | 0 | 0 | 0$ | 0 | 23,795$ | 0$ |
2 | Bakersfield Condors (EDM) | 2000 | 1000 | 50 | 20 | 55937 | 34574 | 77.69% | 96.04% | 0 | 2514 - 83.81% | 96,898$ | 3,488,330$ | 3000 | 100 | 2,540,499$ | 2,540,499$ | 3,111,080$ | 0$ | 2,611,120$ | 0 | 0 | 0$ | 0 | 20,969$ | 0$ |
3 | Belleville Senators (OTT) | 2000 | 1000 | 49 | 20 | 64880 | 34474 | 90.11% | 95.76% | 0 | 2760 - 91.99% | 107,822$ | 3,881,600$ | 3000 | 100 | 3,504,682$ | 3,504,682$ | 3,569,949$ | 0$ | 3,069,926$ | 0 | 0 | 0$ | 0 | 27,618$ | 0$ |
4 | Bridgeport Islanders (NYI) | 2000 | 1000 | 40 | 22 | 68631 | 26978 | 95.32% | 74.94% | 0 | 2656 - 88.53% | 92,743$ | 3,338,756$ | 3000 | 100 | 2,075,153$ | 2,075,153$ | 2,605,693$ | 0$ | 2,105,650$ | 0 | 0 | 0$ | 0 | 17,760$ | 0$ |
5 | Calgary Wranglers (CGY) | 2000 | 1000 | 50 | 20 | 56043 | 32964 | 77.84% | 91.57% | 0 | 2472 - 82.41% | 97,882$ | 3,523,745$ | 3000 | 100 | 3,263,935$ | 3,263,935$ | 3,731,154$ | 0$ | 3,231,194$ | 0 | 0 | 0$ | 0 | 25,958$ | 0$ |
6 | Charlotte Checkers (FLA) | 2000 | 1000 | 50 | 20 | 55498 | 34436 | 77.08% | 95.66% | 0 | 2498 - 83.27% | 96,212$ | 3,463,620$ | 3000 | 100 | 2,579,833$ | 2,579,833$ | 3,153,476$ | 0$ | 2,653,516$ | 0 | 0 | 0$ | 0 | 21,240$ | 0$ |
7 | Chicago Wolves (CAR) | 2000 | 1000 | 50 | 20 | 55510 | 34065 | 77.10% | 94.63% | 0 | 2488 - 82.94% | 96,022$ | 3,456,800$ | 3000 | 100 | 2,088,500$ | 2,088,500$ | 2,588,540$ | 0$ | 2,088,435$ | 0 | 0 | 0$ | 0 | 17,852$ | 0$ |
8 | Cleveland Monsters (CBJ) | 2000 | 1000 | 50 | 20 | 56234 | 34521 | 78.10% | 95.89% | 0 | 2521 - 84.03% | 97,281$ | 3,502,120$ | 3000 | 100 | 10,021,083$ | 10,021,083$ | 5,012,022$ | 0$ | 4,512,061$ | 0 | 0 | 0$ | 0 | 72,559$ | 0$ |
9 | Coachella Valley Firebirds (SEA) | 2000 | 1000 | 50 | 20 | 55797 | 34328 | 77.50% | 95.36% | 0 | 2503 - 83.45% | 96,567$ | 3,476,410$ | 3000 | 100 | 1,799,584$ | 1,799,584$ | 2,381,839$ | 0$ | 1,881,876$ | 0 | 0 | 0$ | 0 | 15,859$ | 0$ |
10 | Colorado Eagles (COL) | 2000 | 1000 | 55 | 25 | 49810 | 23962 | 69.18% | 66.56% | 0 | 2049 - 68.31% | 92,739$ | 3,338,600$ | 3000 | 100 | 2,169,782$ | 2,169,782$ | 2,669,740$ | 0$ | 2,169,780$ | 0 | 0 | 0$ | 0 | 18,412$ | 0$ |
11 | Grand Rapids Griffins (DET) | 2000 | 1000 | 50 | 25 | 57148 | 23623 | 79.37% | 65.62% | 0 | 2244 - 74.79% | 95,777$ | 3,447,975$ | 3000 | 100 | 2,033,908$ | 2,033,908$ | 2,623,833$ | 0$ | 2,123,873$ | 0 | 0 | 0$ | 0 | 17,475$ | 0$ |
12 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 50 | 20 | 55725 | 33748 | 77.40% | 93.74% | 0 | 2485 - 82.85% | 96,145$ | 3,461,210$ | 3000 | 100 | 2,412,938$ | 2,412,938$ | 3,017,558$ | 0$ | 2,517,597$ | 0 | 0 | 0$ | 0 | 20,089$ | 0$ |
13 | Henderson Silver Knights (VGK) | 2000 | 1000 | 50 | 20 | 56549 | 34578 | 78.54% | 96.05% | 0 | 2531 - 84.38% | 97,750$ | 3,519,010$ | 3000 | 100 | 2,458,825$ | 2,458,825$ | 2,928,201$ | 0$ | 2,428,101$ | 0 | 0 | 0$ | 0 | 20,406$ | 0$ |
14 | Hershey Bears (WSH) | 2000 | 1000 | 50 | 20 | 57475 | 34954 | 79.83% | 97.09% | 0 | 2567 - 85.58% | 99,245$ | 3,572,830$ | 3000 | 100 | 2,713,092$ | 2,713,092$ | 2,752,537$ | 0$ | 2,252,568$ | 0 | 0 | 0$ | 0 | 22,159$ | 0$ |
15 | Iowa Wild (MIN) | 2000 | 1000 | 35 | 20 | 70530 | 33893 | 97.96% | 94.15% | 0 | 2901 - 96.69% | 88,122$ | 3,172,390$ | 3000 | 100 | 3,135,063$ | 3,150,750$ | 3,664,808$ | 0$ | 3,164,822$ | 0 | 0 | 0$ | 0 | 25,069$ | 0$ |
16 | Laval Rocket (MTL) | 2000 | 1000 | 50 | 20 | 55460 | 34036 | 77.03% | 94.54% | 0 | 2486 - 82.87% | 95,937$ | 3,453,720$ | 3000 | 100 | 2,593,230$ | 2,721,350$ | 2,576,891$ | 0$ | 2,076,909$ | 0 | 0 | 0$ | 0 | 21,333$ | 0$ |
17 | Lehigh Valley Phantoms (PHI) | 2000 | 1000 | 50 | 20 | 52007 | 25496 | 72.23% | 70.82% | 0 | 2153 - 71.76% | 95,441$ | 3,435,880$ | 3000 | 100 | 2,941,573$ | 2,941,573$ | 2,812,360$ | 0$ | 2,312,381$ | 0 | 0 | 0$ | 0 | 23,735$ | 0$ |
18 | Manitoba Moose (WPG) | 2000 | 1000 | 50 | 25 | 55883 | 23927 | 77.62% | 66.46% | 0 | 2217 - 73.90% | 94,231$ | 3,392,325$ | 3000 | 100 | 2,087,625$ | 2,087,625$ | 2,587,670$ | 0$ | 2,087,565$ | 0 | 0 | 0$ | 0 | 17,846$ | 0$ |
19 | Milwaukee Admirals (NSH) | 2000 | 1000 | 50 | 20 | 56765 | 34559 | 78.84% | 96.00% | 0 | 2537 - 84.56% | 98,040$ | 3,529,430$ | 3000 | 100 | 1,944,829$ | 1,944,829$ | 2,444,845$ | 0$ | 1,944,885$ | 0 | 0 | 0$ | 0 | 16,861$ | 0$ |
20 | Ontario Reign (LAK) | 2000 | 1000 | 50 | 20 | 56632 | 33625 | 78.66% | 93.40% | 0 | 2507 - 83.57% | 97,336$ | 3,504,100$ | 3000 | 100 | 2,109,548$ | 2,109,548$ | 2,533,187$ | 0$ | 2,033,154$ | 0 | 0 | 0$ | 0 | 17,997$ | 0$ |
21 | Providence Bruins (BOS) | 2000 | 1000 | 55 | 25 | 49862 | 23739 | 69.25% | 65.94% | 0 | 2044 - 68.15% | 92,663$ | 3,335,885$ | 3000 | 100 | 2,454,179$ | 2,454,179$ | 3,073,721$ | 0$ | 2,573,658$ | 0 | 0 | 0$ | 0 | 20,374$ | 0$ |
22 | Rochester Americans (BUF) | 2000 | 1000 | 55 | 25 | 51434 | 23650 | 71.44% | 65.69% | 0 | 2086 - 69.52% | 95,003$ | 3,420,120$ | 3000 | 100 | 2,551,938$ | 2,551,938$ | 3,213,959$ | 0$ | 2,713,998$ | 0 | 0 | 0$ | 0 | 21,048$ | 0$ |
23 | Rockford IceHogs (CHI) | 2000 | 1000 | 50 | 21 | 55536 | 30202 | 77.13% | 83.89% | 0 | 2382 - 79.39% | 94,751$ | 3,411,042$ | 3000 | 100 | 2,122,166$ | 2,122,166$ | 2,850,334$ | 0$ | 2,350,326$ | 0 | 0 | 0$ | 0 | 18,084$ | 0$ |
24 | San Diego Gulls (ANA) | 2000 | 1000 | 39 | 18 | 69773 | 34606 | 96.91% | 96.13% | 0 | 2899 - 96.65% | 92,890$ | 3,344,055$ | 3000 | 100 | 1,711,791$ | 1,711,791$ | 2,286,557$ | 0$ | 1,786,583$ | 0 | 0 | 0$ | 0 | 15,254$ | 0$ |
25 | San Jose Barracuda (SJS) | 2000 | 1000 | 55 | 25 | 49700 | 24170 | 69.03% | 67.14% | 0 | 2052 - 68.40% | 92,715$ | 3,337,750$ | 3000 | 100 | 2,737,708$ | 2,737,708$ | 3,168,769$ | 0$ | 2,668,756$ | 0 | 0 | 0$ | 0 | 22,329$ | 0$ |
26 | Springfield Thunderbirds (STL) | 2000 | 1000 | 50 | 20 | 54595 | 33345 | 75.83% | 92.63% | 0 | 2443 - 81.43% | 94,351$ | 3,396,650$ | 3000 | 100 | 2,145,500$ | 2,145,500$ | 2,726,798$ | 0$ | 2,226,697$ | 0 | 0 | 0$ | 0 | 18,245$ | 0$ |
27 | Syracuse Crunch (TBL) | 2000 | 1000 | 50 | 20 | 54937 | 33611 | 76.30% | 93.36% | 0 | 2460 - 81.99% | 94,974$ | 3,419,070$ | 3000 | 100 | 1,902,499$ | 1,902,499$ | 2,442,353$ | 0$ | 1,942,393$ | 0 | 0 | 0$ | 0 | 16,569$ | 0$ |
28 | Texas Stars (DAL) | 2000 | 1000 | 50 | 20 | 55587 | 34217 | 77.20% | 95.05% | 0 | 2495 - 83.15% | 96,214$ | 3,463,690$ | 3000 | 100 | 2,026,500$ | 2,026,500$ | 2,580,460$ | 0$ | 2,080,411$ | 0 | 0 | 0$ | 0 | 17,424$ | 0$ |
29 | Toronto Marlies (TOR) | 2000 | 1000 | 36 | 15 | 70733 | 35359 | 98.24% | 98.22% | 0 | 2947 - 98.23% | 88,256$ | 3,177,199$ | 3000 | 100 | 2,488,369$ | 2,488,369$ | 2,988,305$ | 0$ | 2,488,345$ | 0 | 0 | 0$ | 0 | 20,609$ | 0$ |
30 | Tucson Roadrunners (ARZ) | 2000 | 1000 | 50 | 20 | 55899 | 34160 | 77.64% | 94.89% | 0 | 2502 - 83.39% | 96,615$ | 3,478,150$ | 3000 | 100 | 2,471,965$ | 2,464,465$ | 3,060,402$ | 0$ | 2,560,442$ | 0 | 0 | 0$ | 0 | 20,496$ | 0$ |
31 | Utica Comets (NJD) | 2000 | 1000 | 50 | 20 | 56007 | 34118 | 77.79% | 94.77% | 0 | 2503 - 83.45% | 96,742$ | 3,482,710$ | 3000 | 100 | 2,750,912$ | 2,750,912$ | 2,763,905$ | 0$ | 2,263,945$ | 0 | 0 | 0$ | 0 | 22,420$ | 0$ |
32 | Wilkes-Barre Scranton Penguins (PIT) | 2000 | 1000 | 50 | 20 | 54269 | 33588 | 75.37% | 93.30% | 0 | 2440 - 81.35% | 94,034$ | 3,385,210$ | 3000 | 100 | 1,860,501$ | 1,860,501$ | 2,430,112$ | 0$ | 1,930,151$ | 0 | 0 | 0$ | 0 | 16,279$ | 0$ |