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 | 185000 | 185000 | 100.00% | 100.00% | 4 | 10000 - 100.00% | 104,300$ | 3,859,100$ | 10000 | 110 | 4,815,000$ | 4,815,000$ | 4,823,256$ | 0$ | 4,594,277$ | 0 | 0 | 417,200$ | 16 | 26,658$ | 426,528$ |
2 | Bakersfield Condors (EDM) | 5000 | 5000 | 35 | 15 | 167697 | 184132 | 90.65% | 99.53% | 4 | 9509 - 95.09% | 347,588$ | 12,860,751$ | 10000 | 110 | 5,453,222$ | 5,433,222$ | 5,153,926$ | 0$ | 4,924,942$ | 0 | 0 | 1,390,351$ | 16 | 30,017$ | 480,272$ |
3 | Belleville Senators (OTT) | 5000 | 5000 | 50 | 30 | 110582 | 95424 | 65.05% | 56.13% | 7 | 6059 - 60.59% | 343,244$ | 11,670,281$ | 10000 | 110 | 3,305,000$ | 3,305,000$ | 3,324,956$ | 0$ | 3,096,031$ | 0 | 0 | 2,402,705$ | 16 | 18,711$ | 299,376$ |
4 | Bridgeport's Islanders (NYI) | 5000 | 5000 | 33 | 12 | 185000 | 185000 | 100.00% | 100.00% | 4 | 10000 - 100.00% | 310,081$ | 11,473,000$ | 10000 | 110 | 5,528,000$ | 5,508,000$ | 5,041,446$ | 0$ | 4,812,496$ | 0 | 0 | 1,240,324$ | 16 | 30,411$ | 486,576$ |
5 | Calgary Wranglers (CGY) | 5000 | 5000 | 35 | 15 | 176209 | 195000 | 90.36% | 100.00% | 2 | 9518 - 95.18% | 347,373$ | 13,547,551$ | 10000 | 110 | 3,265,000$ | 3,265,000$ | 3,408,023$ | 0$ | 3,179,044$ | 0 | 0 | 694,746$ | 16 | 18,500$ | 296,000$ |
6 | Charlotte Checkers (FLO) | 5000 | 5000 | 35 | 15 | 164988 | 184746 | 89.18% | 99.86% | 4 | 9452 - 94.52% | 344,141$ | 12,733,199$ | 10000 | 110 | 3,815,000$ | 3,730,000$ | 3,924,329$ | 0$ | 3,695,398$ | 0 | 0 | 1,376,562$ | 16 | 21,395$ | 342,320$ |
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,199,111$ | 0$ | 2,970,183$ | 0 | 0 | 696,760$ | 16 | 19,453$ | 311,248$ |
8 | Colorado Eagles (COL) | 5000 | 5000 | 45 | 23 | 130190 | 123989 | 70.37% | 67.02% | 4 | 6870 - 68.70% | 350,766$ | 12,978,342$ | 10000 | 110 | 4,096,100$ | 4,121,100$ | 4,056,124$ | 0$ | 3,827,142$ | 0 | 0 | 1,403,064$ | 16 | 22,874$ | 365,984$ |
9 | Grand Rapids Griffins (DET) | 5000 | 5000 | 40 | 30 | 138821 | 88978 | 79.33% | 50.84% | 6 | 6509 - 65.09% | 350,030$ | 12,251,049$ | 10000 | 110 | 5,733,000$ | 5,709,000$ | 3,903,322$ | 0$ | 3,674,361$ | 0 | 0 | 2,100,180$ | 16 | 31,489$ | 503,824$ |
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,180,000$ | 5,180,000$ | 4,784,648$ | 0$ | 4,555,714$ | 0 | 0 | 1,410,647$ | 16 | 28,579$ | 457,264$ |
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,647,072$ | 0$ | 4,418,098$ | 0 | 0 | 949,814$ | 16 | 27,563$ | 441,008$ |
12 | Hershey Bears (WSH) | 5000 | 5000 | 30 | 15 | 175000 | 174707 | 100.00% | 99.83% | 6 | 9992 - 99.92% | 335,063$ | 11,727,201$ | 10000 | 110 | 2,532,000$ | 2,532,000$ | 2,474,693$ | 0$ | 2,245,715$ | 0 | 0 | 2,010,377$ | 16 | 14,642$ | 234,272$ |
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,363,000$ | 4,363,000$ | 3,732,337$ | 0$ | 3,503,365$ | 0 | 0 | 596,000$ | 16 | 24,279$ | 388,464$ |
14 | Laval Rocket (MTL) | 5000 | 5000 | 30 | 10 | 180000 | 180000 | 100.00% | 100.00% | 5 | 10000 - 100.00% | 298,000$ | 10,728,000$ | 10000 | 110 | 6,328,505$ | 6,328,505$ | 5,730,534$ | 0$ | 5,501,582$ | 0 | 0 | 1,490,000$ | 16 | 34,624$ | 553,984$ |
15 | Lehigh Valley Phantoms (PHI) | 5000 | 5000 | 30 | 10 | 190000 | 190000 | 100.00% | 100.00% | 3 | 10000 - 100.00% | 298,000$ | 11,324,000$ | 10000 | 110 | 3,758,000$ | 3,758,000$ | 3,632,674$ | 0$ | 3,403,704$ | 0 | 0 | 894,000$ | 16 | 21,095$ | 337,520$ |
16 | Manitoba Moose (WPG) | 5000 | 5000 | 39 | 19 | 155394 | 150437 | 81.79% | 79.18% | 3 | 8048 - 80.48% | 349,706$ | 13,288,814$ | 10000 | 110 | 6,333,000$ | 5,843,000$ | 5,824,633$ | 0$ | 5,595,684$ | 0 | 0 | 1,049,117$ | 16 | 34,647$ | 554,352$ |
17 | Ontario Reign (LAK) | 5000 | 5000 | 33 | 17 | 180000 | 166959 | 100.00% | 92.76% | 5 | 9638 - 96.38% | 357,142$ | 12,857,125$ | 10000 | 110 | 7,043,000$ | 7,043,000$ | 6,143,816$ | 0$ | 5,914,849$ | 0 | 0 | 1,785,712$ | 16 | 38,384$ | 614,144$ |
18 | Providence Bruins (BOS) | 5000 | 5000 | 25 | 13 | 190000 | 190000 | 100.00% | 100.00% | 3 | 10000 - 100.00% | 283,100$ | 10,757,800$ | 10000 | 110 | 5,730,000$ | 5,730,000$ | 6,067,122$ | 0$ | 5,151,360$ | 0 | 0 | 849,300$ | 16 | 35,421$ | 566,736$ |
19 | Rochester Americans (BUF) | 5000 | 5000 | 50 | 30 | 152007 | 127348 | 82.17% | 68.84% | 4 | 7550 - 75.50% | 353,543$ | 13,081,090$ | 10000 | 110 | 3,827,800$ | 3,727,800$ | 3,666,409$ | 0$ | 3,437,506$ | 0 | 0 | 1,414,172$ | 16 | 21,462$ | 343,392$ |
20 | Rockford IceHogs (CHI) | 5000 | 5000 | 12 | 7 | 195000 | 195000 | 100.00% | 100.00% | 2 | 10000 - 100.00% | 141,550$ | 5,520,450$ | 10000 | 110 | 5,334,000$ | 5,028,000$ | 4,557,790$ | 0$ | 4,328,828$ | 0 | 0 | 283,100$ | 16 | 29,389$ | 470,224$ |
21 | San Diego Gulls (ANA) | 5000 | 5000 | 30 | 25 | 185000 | 112823 | 100.00% | 60.99% | 4 | 8049 - 80.49% | 337,085$ | 12,472,156$ | 10000 | 110 | 4,431,000$ | 4,431,000$ | 4,075,474$ | 0$ | 3,846,548$ | 0 | 0 | 1,348,341$ | 16 | 24,637$ | 394,192$ |
22 | San Jose Barracuda (SJS) | 5000 | 5000 | 30 | 12 | 190000 | 190000 | 100.00% | 100.00% | 3 | 10000 - 100.00% | 312,900$ | 11,890,200$ | 10000 | 110 | 4,195,000$ | 4,195,000$ | 4,536,250$ | 0$ | 4,307,384$ | 0 | 0 | 938,700$ | 16 | 23,395$ | 374,320$ |
23 | Springfield Thunderbirds (STL) | 5000 | 5000 | 35 | 15 | 164711 | 179304 | 91.51% | 99.61% | 5 | 9556 - 95.56% | 349,920$ | 12,597,124$ | 10000 | 110 | 3,534,000$ | 3,534,000$ | 3,962,193$ | 0$ | 3,733,238$ | 0 | 0 | 1,749,601$ | 16 | 19,916$ | 318,656$ |
24 | Syracuse Crunch (TBL) | 5000 | 5000 | 35 | 10 | 161491 | 175000 | 92.28% | 100.00% | 6 | 9614 - 96.14% | 315,122$ | 11,029,257$ | 10000 | 110 | 6,884,999$ | 6,684,999$ | 5,345,625$ | 0$ | 5,116,647$ | 0 | 0 | 1,890,730$ | 16 | 37,553$ | 600,848$ |
25 | Texas Stars (DAL) | 5000 | 5000 | 15 | 5 | 195000 | 195000 | 100.00% | 100.00% | 2 | 10000 - 100.00% | 149,000$ | 5,811,000$ | 10000 | 110 | 4,277,000$ | 4,277,000$ | 4,408,649$ | 0$ | 4,179,733$ | 0 | 0 | 298,000$ | 16 | 23,826$ | 381,216$ |
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,247,610$ | 0$ | 3,773,930$ | 0 | 0 | 1,128,194$ | 16 | 28,221$ | 451,536$ |
27 | Utica Comets (NJD) | 5000 | 5000 | 28 | 12 | 185000 | 185000 | 100.00% | 100.00% | 4 | 10000 - 100.00% | 298,000$ | 11,026,000$ | 10000 | 110 | 4,324,600$ | 3,924,600$ | 4,122,335$ | 0$ | 3,889,416$ | 0 | 0 | 1,192,000$ | 16 | 24,077$ | 385,232$ |
28 | Wilkes-Barre/Scranton Penguins (PIT) | 5000 | 5000 | 20 | 5 | 190000 | 190000 | 100.00% | 100.00% | 3 | 10000 - 100.00% | 186,250$ | 7,077,500$ | 10000 | 110 | 4,385,000$ | 4,385,000$ | 4,231,900$ | 0$ | 4,002,926$ | 0 | 0 | 558,750$ | 16 | 24,395$ | 390,320$ |