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's Canucks (VAN) | 5000 | 5000 | 9 | 5 | 190000 | 190000 | 100.00% | 100.00% | 3 | 10000 - 100.00% | 104,300$ | 3,963,400$ | 10000 | 110 | 5,000,000$ | 5,000,000$ | 4,961,416$ | 0$ | 4,725,857$ | 0 | 0 | 312,900$ | 11 | 27,632$ | 303,952$ |
2 | Bakersfield Condors (EDM) | 5000 | 5000 | 35 | 15 | 172579 | 189132 | 90.83% | 99.54% | 3 | 9519 - 95.19% | 348,082$ | 13,227,097$ | 10000 | 110 | 5,453,222$ | 5,433,222$ | 5,304,011$ | 0$ | 5,068,447$ | 0 | 0 | 1,044,244$ | 11 | 30,017$ | 330,187$ |
3 | Belleville Senators (OTT) | 5000 | 5000 | 50 | 30 | 116687 | 100510 | 64.83% | 55.84% | 5 | 6033 - 60.33% | 343,124$ | 12,352,448$ | 10000 | 110 | 3,335,000$ | 3,335,000$ | 3,419,823$ | 0$ | 3,184,322$ | 0 | 0 | 1,715,618$ | 11 | 18,868$ | 207,548$ |
4 | Bridgeport's Islanders (NYI) | 5000 | 5000 | 33 | 12 | 195000 | 195000 | 100.00% | 100.00% | 2 | 10000 - 100.00% | 311,372$ | 12,143,500$ | 10000 | 110 | 5,228,000$ | 5,208,000$ | 5,190,343$ | 0$ | 4,954,813$ | 0 | 0 | 622,744$ | 11 | 28,832$ | 317,152$ |
5 | Calgary Wranglers (CGY) | 5000 | 5000 | 35 | 15 | 180738 | 200000 | 90.37% | 100.00% | 1 | 9518 - 95.18% | 347,387$ | 13,895,488$ | 10000 | 110 | 3,265,000$ | 3,265,000$ | 3,500,523$ | 0$ | 3,264,964$ | 0 | 0 | 347,387$ | 11 | 18,500$ | 203,500$ |
6 | Charlotte Checkers (FLO) | 5000 | 5000 | 35 | 15 | 173360 | 194746 | 88.90% | 99.87% | 2 | 9439 - 94.39% | 343,418$ | 13,393,299$ | 10000 | 110 | 3,630,000$ | 3,545,000$ | 4,027,408$ | 0$ | 3,791,897$ | 0 | 0 | 686,836$ | 11 | 20,421$ | 224,631$ |
7 | Chicago Wolves (CAR) | 5000 | 5000 | 35 | 15 | 177166 | 194524 | 90.85% | 99.76% | 2 | 9531 - 95.31% | 348,380$ | 13,586,820$ | 10000 | 110 | 3,446,000$ | 3,446,000$ | 3,294,875$ | 0$ | 3,059,368$ | 0 | 0 | 696,760$ | 11 | 19,453$ | 213,983$ |
8 | Colorado Eagles (COL) | 5000 | 5000 | 45 | 23 | 137155 | 130935 | 70.34% | 67.15% | 2 | 6874 - 68.74% | 350,856$ | 13,683,385$ | 10000 | 110 | 4,096,100$ | 4,121,100$ | 4,170,494$ | 0$ | 3,934,932$ | 0 | 0 | 701,712$ | 11 | 22,874$ | 251,614$ |
9 | Grand Rapids Griffins (DET) | 5000 | 5000 | 40 | 30 | 147052 | 94099 | 79.49% | 50.86% | 4 | 6518 - 65.18% | 350,555$ | 12,970,525$ | 10000 | 110 | 5,733,000$ | 5,709,000$ | 4,060,767$ | 0$ | 3,825,231$ | 0 | 0 | 1,402,219$ | 11 | 31,489$ | 346,379$ |
10 | Hartford Wolfpack (NYR) | 5000 | 5000 | 35 | 15 | 170925 | 185000 | 92.39% | 100.00% | 4 | 9620 - 96.20% | 352,662$ | 13,048,487$ | 10000 | 110 | 5,080,000$ | 5,080,000$ | 4,925,965$ | 0$ | 4,690,451$ | 0 | 0 | 1,410,647$ | 11 | 28,053$ | 308,583$ |
11 | Henderson Silver Knights (VGK) | 5000 | 5000 | 42 | 25 | 133416 | 108840 | 70.22% | 57.28% | 3 | 6375 - 63.75% | 316,605$ | 12,030,979$ | 10000 | 100 | 4,987,000$ | 4,987,000$ | 4,784,887$ | 0$ | 4,549,333$ | 0 | 0 | 949,814$ | 11 | 27,563$ | 303,193$ |
12 | Hershey Bears (WSH) | 5000 | 5000 | 30 | 15 | 185000 | 184707 | 100.00% | 99.84% | 4 | 9992 - 99.92% | 335,073$ | 12,397,701$ | 10000 | 110 | 2,430,000$ | 2,430,000$ | 2,546,292$ | 0$ | 2,310,734$ | 0 | 0 | 1,340,292$ | 11 | 14,105$ | 155,155$ |
13 | Iowa Wild (MIN) | 5000 | 5000 | 30 | 10 | 195000 | 195000 | 100.00% | 100.00% | 2 | 10000 - 100.00% | 298,000$ | 11,622,000$ | 10000 | 110 | 4,258,000$ | 4,258,000$ | 3,851,110$ | 0$ | 3,615,560$ | 0 | 0 | 596,000$ | 11 | 23,726$ | 260,986$ |
14 | Laval Rocket (MTL) | 5000 | 5000 | 30 | 10 | 185000 | 185000 | 100.00% | 100.00% | 4 | 10000 - 100.00% | 298,000$ | 11,026,000$ | 10000 | 110 | 6,328,505$ | 6,328,505$ | 5,903,654$ | 0$ | 5,668,122$ | 0 | 0 | 1,192,000$ | 11 | 34,624$ | 380,864$ |
15 | Lehigh Valley Phantoms (PHI) | 5000 | 5000 | 30 | 10 | 195000 | 195000 | 100.00% | 100.00% | 2 | 10000 - 100.00% | 298,000$ | 11,622,000$ | 10000 | 110 | 4,128,000$ | 4,128,000$ | 3,745,937$ | 0$ | 3,510,387$ | 0 | 0 | 596,000$ | 11 | 23,042$ | 253,462$ |
16 | Manitoba Moose (WPG) | 5000 | 5000 | 39 | 19 | 159804 | 154236 | 81.95% | 79.10% | 2 | 8052 - 80.52% | 350,067$ | 13,652,629$ | 10000 | 110 | 6,333,000$ | 5,843,000$ | 5,997,868$ | 0$ | 5,762,344$ | 0 | 0 | 700,135$ | 11 | 34,647$ | 381,117$ |
17 | Ontario Reign (LAK) | 5000 | 5000 | 33 | 17 | 185000 | 171782 | 100.00% | 92.86% | 4 | 9643 - 96.43% | 357,436$ | 13,225,142$ | 10000 | 110 | 7,043,000$ | 7,043,000$ | 6,335,736$ | 0$ | 6,100,189$ | 0 | 0 | 1,429,745$ | 11 | 38,384$ | 422,224$ |
18 | Providence Bruins (BOS) | 5000 | 5000 | 25 | 13 | 195000 | 195000 | 100.00% | 100.00% | 2 | 10000 - 100.00% | 283,100$ | 11,040,900$ | 10000 | 110 | 5,730,000$ | 5,730,000$ | 6,244,227$ | 0$ | 5,302,150$ | 0 | 0 | 566,200$ | 11 | 35,421$ | 389,631$ |
19 | Rochester Americans (BUF) | 5000 | 5000 | 50 | 30 | 155388 | 129997 | 81.78% | 68.42% | 3 | 7510 - 75.10% | 353,984$ | 13,451,385$ | 10000 | 110 | 3,827,800$ | 3,727,800$ | 3,773,719$ | 0$ | 3,538,236$ | 0 | 0 | 1,061,951$ | 11 | 21,462$ | 236,082$ |
20 | Rockford IceHogs (CHI) | 5000 | 5000 | 12 | 7 | 200000 | 200000 | 100.00% | 100.00% | 1 | 10000 - 100.00% | 141,550$ | 5,662,000$ | 10000 | 110 | 5,334,000$ | 5,028,000$ | 4,702,605$ | 0$ | 4,467,066$ | 0 | 0 | 141,550$ | 11 | 29,389$ | 323,279$ |
21 | San Diego Gulls (ANA) | 5000 | 5000 | 30 | 25 | 190000 | 115711 | 100.00% | 60.90% | 3 | 8045 - 80.45% | 336,927$ | 12,803,234$ | 10000 | 110 | 4,431,000$ | 4,431,000$ | 4,198,659$ | 0$ | 3,963,153$ | 0 | 0 | 1,010,782$ | 11 | 24,637$ | 271,007$ |
22 | San Jose Barracuda (SJS) | 5000 | 5000 | 30 | 12 | 200000 | 200000 | 100.00% | 100.00% | 1 | 10000 - 100.00% | 312,900$ | 12,516,000$ | 10000 | 110 | 4,325,000$ | 4,325,000$ | 4,653,909$ | 0$ | 4,418,463$ | 0 | 0 | 312,900$ | 11 | 24,079$ | 264,869$ |
23 | Springfield Thunderbirds (STL) | 5000 | 5000 | 35 | 15 | 169494 | 184304 | 91.62% | 99.62% | 4 | 9562 - 95.62% | 350,225$ | 12,958,307$ | 10000 | 110 | 4,349,000$ | 4,349,000$ | 4,075,260$ | 0$ | 3,839,728$ | 0 | 0 | 1,400,898$ | 11 | 24,205$ | 266,255$ |
24 | Syracuse Crunch (TBL) | 5000 | 5000 | 35 | 10 | 170875 | 185000 | 92.36% | 100.00% | 4 | 9618 - 96.18% | 315,341$ | 11,667,633$ | 10000 | 110 | 6,884,999$ | 6,684,999$ | 5,532,442$ | 0$ | 5,296,884$ | 0 | 0 | 1,261,366$ | 11 | 37,553$ | 413,083$ |
25 | Texas Stars (DAL) | 5000 | 5000 | 15 | 5 | 200000 | 200000 | 100.00% | 100.00% | 1 | 10000 - 100.00% | 149,000$ | 5,960,000$ | 10000 | 110 | 4,652,000$ | 4,652,000$ | 4,535,675$ | 0$ | 4,300,180$ | 0 | 0 | 149,000$ | 11 | 25,800$ | 283,800$ |
26 | Toronto Marlies (TOR) | 5000 | 5000 | 80 | 45 | 78979 | 76620 | 41.57% | 40.33% | 3 | 4095 - 40.95% | 376,065$ | 14,290,457$ | 10000 | 110 | 4,362,000$ | 4,362,000$ | 4,388,715$ | 0$ | 3,888,720$ | 0 | 0 | 1,128,194$ | 11 | 28,221$ | 310,431$ |
27 | Utica Comets (NJD) | 5000 | 5000 | 28 | 12 | 190000 | 190000 | 100.00% | 100.00% | 3 | 10000 - 100.00% | 298,000$ | 11,324,000$ | 10000 | 110 | 4,224,600$ | 3,824,600$ | 4,240,616$ | 0$ | 4,001,117$ | 0 | 0 | 894,000$ | 11 | 23,551$ | 259,061$ |
28 | Wilkes-Barre/Scranton Penguins (PIT) | 5000 | 5000 | 20 | 5 | 195000 | 195000 | 100.00% | 100.00% | 2 | 10000 - 100.00% | 186,250$ | 7,263,750$ | 10000 | 110 | 4,515,000$ | 4,515,000$ | 4,355,611$ | 0$ | 4,120,057$ | 0 | 0 | 372,500$ | 11 | 25,079$ | 275,869$ |