| 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 | Plafond Salariale total 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) | 6000 | 3000 | 50 | 25 | 156581 | 77780 | 96.65% | 96.02% | 8 | 8680 - 96.44% | 434,380$ | 11,728,260$ | 9000 | 100 | 1,322,334$ | 1,322,334$ | 996,020$ | 0$ | 993,750$ | 0 | 0 | 3,475,040$ | 60 | 7,471$ | 336,195$ |
| 2 |  Bakersfield Condors (EDM) | 6000 | 3000 | 50 | 25 | 155338 | 77585 | 95.89% | 95.78% | 8 | 8627 - 95.85% | 431,401$ | 11,647,830$ | 9000 | 100 | 1,352,650$ | 1,352,650$ | 994,728$ | 0$ | 994,728$ | 0 | 0 | 3,451,209$ | 60 | 7,642$ | 343,890$ |
| 3 |  Belleville Senators (OTT) | 6000 | 3000 | 50 | 25 | 156489 | 76974 | 96.60% | 95.03% | 8 | 8647 - 96.08% | 433,280$ | 11,698,560$ | 9000 | 100 | 1,605,333$ | 1,605,333$ | 1,251,842$ | 0$ | 1,251,842$ | 0 | 0 | 3,466,240$ | 60 | 9,070$ | 408,150$ |
| 4 |  Bridgeport Islanders (NYI) | 6000 | 3000 | 50 | 25 | 150367 | 74423 | 96.39% | 95.41% | 9 | 8646 - 96.06% | 432,873$ | 11,254,710$ | 9000 | 100 | 1,723,417$ | 1,723,417$ | 1,577,725$ | 0$ | 1,577,725$ | 0 | 0 | 3,895,861$ | 60 | 9,737$ | 438,165$ |
| 5 |  Calgary Wranglers (CGY) | 6000 | 3000 | 50 | 25 | 150681 | 75344 | 96.59% | 96.59% | 9 | 8693 - 96.59% | 434,661$ | 11,301,180$ | 9000 | 100 | 1,045,332$ | 1,045,332$ | 742,501$ | 0$ | 736,372$ | 0 | 0 | 3,911,947$ | 60 | 5,906$ | 265,770$ |
| 6 |  Charlotte Checkers (FLA) | 6000 | 3000 | 50 | 25 | 156148 | 77472 | 96.39% | 95.64% | 8 | 8653 - 96.14% | 433,076$ | 11,693,040$ | 9000 | 100 | 560,000$ | 560,000$ | 449,364$ | 0$ | 449,364$ | 0 | 0 | 3,464,604$ | 60 | 3,164$ | 142,380$ |
| 7 |  Chicago Wolves (CAR) | 6000 | 3000 | 50 | 25 | 157849 | 78255 | 97.44% | 96.61% | 8 | 8745 - 97.16% | 437,726$ | 11,818,590$ | 9000 | 100 | 967,750$ | 967,750$ | 760,308$ | 0$ | 760,308$ | 0 | 0 | 3,501,804$ | 60 | 5,468$ | 246,060$ |
| 8 |  Cleveland Monsters (CBJ) | 6000 | 3000 | 50 | 25 | 155437 | 76790 | 95.95% | 94.80% | 8 | 8601 - 95.57% | 430,738$ | 11,629,920$ | 9000 | 100 | 1,376,514$ | 1,376,514$ | 1,024,267$ | 0$ | 1,024,267$ | 0 | 0 | 3,445,902$ | 60 | 7,777$ | 349,965$ |
| 9 |  Coachella Valley Firebirds (SEA) | 6000 | 3000 | 50 | 25 | 154534 | 78036 | 95.39% | 96.34% | 8 | 8614 - 95.71% | 430,116$ | 11,613,120$ | 9000 | 100 | 1,077,000$ | 1,077,000$ | 888,258$ | 0$ | 885,803$ | 0 | 0 | 3,440,924$ | 60 | 6,085$ | 273,825$ |
| 10 |  Colorado Eagles (COL) | 6000 | 3000 | 50 | 25 | 155790 | 77854 | 96.17% | 96.12% | 8 | 8653 - 96.15% | 432,704$ | 11,683,020$ | 9000 | 100 | 1,512,916$ | 1,512,916$ | 1,136,198$ | 0$ | 1,134,008$ | 0 | 0 | 3,461,636$ | 60 | 8,548$ | 384,660$ |
| 11 |  Grand Rapids Griffins (DET) | 6000 | 3000 | 50 | 25 | 148842 | 75429 | 95.41% | 96.70% | 9 | 8626 - 95.84% | 430,515$ | 11,193,390$ | 9000 | 100 | 1,696,416$ | 1,696,416$ | 1,262,694$ | 0$ | 1,260,014$ | 0 | 0 | 3,874,635$ | 60 | 9,584$ | 431,280$ |
| 12 |  Hartford Wolf Pack (NYR) | 6000 | 3000 | 50 | 25 | 155139 | 77585 | 95.76% | 95.78% | 8 | 8619 - 95.77% | 430,959$ | 11,635,890$ | 9000 | 100 | 1,712,667$ | 1,712,667$ | 1,274,541$ | 0$ | 1,274,541$ | 0 | 0 | 3,447,671$ | 60 | 9,676$ | 435,420$ |
| 13 |  Henderson Silver Knights (VGK) | 6000 | 3000 | 50 | 25 | 156785 | 77390 | 96.78% | 95.54% | 8 | 8673 - 96.37% | 434,400$ | 11,728,800$ | 9000 | 100 | 1,849,267$ | 1,849,267$ | 1,346,029$ | 0$ | 1,346,029$ | 0 | 0 | 3,475,200$ | 60 | 10,448$ | 470,160$ |
| 14 |  Hershey Bears (WSH) | 6000 | 3000 | 50 | 25 | 155563 | 76810 | 96.03% | 94.83% | 8 | 8606 - 95.63% | 431,040$ | 11,638,080$ | 9000 | 100 | 968,778$ | 968,778$ | 799,849$ | 0$ | 797,412$ | 0 | 0 | 3,448,320$ | 60 | 5,473$ | 246,285$ |
| 15 |  Iowa Wild (MIN) | 6000 | 3000 | 50 | 25 | 155301 | 77376 | 95.86% | 95.53% | 8 | 8618 - 95.75% | 431,087$ | 11,639,340$ | 9000 | 100 | 1,420,666$ | 1,420,666$ | 988,563$ | 0$ | 986,123$ | 0 | 0 | 3,448,693$ | 60 | 8,026$ | 361,170$ |
| 16 |  Laval Rocket (MTL) | 6000 | 3000 | 50 | 25 | 153610 | 77831 | 94.82% | 96.09% | 8 | 8572 - 95.24% | 427,834$ | 11,551,530$ | 9000 | 100 | 794,417$ | 794,417$ | 604,680$ | 0$ | 604,680$ | 0 | 0 | 3,422,676$ | 60 | 4,488$ | 201,960$ |
| 17 |  Lehigh Valley Phantoms (PHI) | 6000 | 3000 | 50 | 25 | 156544 | 78111 | 96.63% | 96.43% | 8 | 8691 - 96.57% | 434,666$ | 11,735,970$ | 9000 | 100 | 1,975,083$ | 1,975,083$ | 1,354,333$ | 0$ | 1,354,333$ | 0 | 0 | 3,477,324$ | 60 | 11,159$ | 502,155$ |
| 18 |  Manitoba Moose (WPG) | 6000 | 3000 | 50 | 25 | 156230 | 77808 | 96.44% | 96.06% | 8 | 8668 - 96.31% | 433,631$ | 11,708,040$ | 9000 | 100 | 1,624,445$ | 1,624,445$ | 1,194,159$ | 0$ | 1,186,959$ | 0 | 0 | 3,469,049$ | 60 | 9,178$ | 413,010$ |
| 19 |  Milwaukee Admirals (NSH) | 6000 | 3000 | 50 | 25 | 154478 | 78111 | 95.36% | 96.43% | 8 | 8614 - 95.72% | 430,074$ | 11,612,010$ | 9000 | 100 | 1,543,833$ | 1,543,833$ | 1,141,986$ | 0$ | 1,141,986$ | 0 | 0 | 3,440,596$ | 60 | 8,722$ | 392,490$ |
| 20 |  Ontario Reign (LAK) | 6000 | 3000 | 50 | 25 | 150907 | 74901 | 96.74% | 96.03% | 9 | 8685 - 96.50% | 434,671$ | 11,301,450$ | 9000 | 100 | 1,184,001$ | 1,184,001$ | 947,778$ | 0$ | 947,778$ | 0 | 0 | 3,912,040$ | 60 | 6,689$ | 301,005$ |
| 21 |  Providence Bruins (BOS) | 6000 | 3000 | 50 | 25 | 154933 | 77707 | 95.64% | 95.93% | 8 | 8616 - 95.74% | 430,637$ | 11,627,190$ | 9000 | 100 | 1,760,999$ | 1,760,999$ | 1,186,471$ | 0$ | 1,186,033$ | 0 | 0 | 3,445,093$ | 60 | 9,949$ | 447,705$ |
| 22 |  Rochester Americans (BUF) | 6000 | 3000 | 50 | 25 | 148596 | 74939 | 95.25% | 96.08% | 9 | 8598 - 95.53% | 429,382$ | 11,163,930$ | 9000 | 100 | 1,575,828$ | 1,575,828$ | 1,205,654$ | 0$ | 1,205,654$ | 0 | 0 | 3,864,437$ | 60 | 8,903$ | 400,635$ |
| 23 |  Rockford IceHogs (CHI) | 6000 | 3000 | 50 | 25 | 156582 | 77354 | 96.66% | 95.50% | 8 | 8664 - 96.27% | 433,909$ | 11,715,540$ | 9000 | 100 | 1,019,834$ | 942,334$ | 867,902$ | 0$ | 865,712$ | 0 | 0 | 3,471,271$ | 60 | 5,762$ | 259,290$ |
| 24 |  San Diego Gulls (ANA) | 6000 | 3000 | 50 | 25 | 154356 | 77915 | 95.28% | 96.19% | 8 | 8603 - 95.58% | 429,586$ | 11,598,810$ | 9000 | 100 | 1,334,167$ | 1,334,167$ | 997,599$ | 0$ | 995,149$ | 0 | 0 | 3,436,684$ | 60 | 7,538$ | 339,210$ |
| 25 |  San Jose Barracuda (SJS) | 6000 | 3000 | 50 | 25 | 156030 | 77750 | 96.31% | 95.99% | 8 | 8659 - 96.21% | 433,122$ | 11,694,300$ | 9000 | 100 | 1,273,375$ | 1,273,375$ | 980,246$ | 0$ | 975,796$ | 0 | 0 | 3,464,978$ | 60 | 7,194$ | 323,730$ |
| 26 |  Springfield Thunderbirds (STL) | 6000 | 3000 | 50 | 25 | 148777 | 74761 | 95.37% | 95.85% | 9 | 8598 - 95.53% | 429,594$ | 11,169,450$ | 9000 | 100 | 1,553,925$ | 1,553,925$ | 1,146,505$ | 0$ | 1,141,315$ | 0 | 0 | 3,866,348$ | 60 | 8,779$ | 395,055$ |
| 27 |  Syracuse Crunch (TBL) | 6000 | 3000 | 50 | 25 | 157934 | 77635 | 97.49% | 95.85% | 8 | 8725 - 96.94% | 437,226$ | 11,805,090$ | 9000 | 100 | 779,917$ | 779,917$ | 582,906$ | 0$ | 580,296$ | 0 | 0 | 3,497,804$ | 60 | 4,406$ | 198,270$ |
| 28 |  Texas Stars (DAL) | 6000 | 3000 | 50 | 25 | 156705 | 78490 | 96.73% | 96.90% | 8 | 8711 - 96.79% | 435,444$ | 11,757,000$ | 9000 | 100 | 928,417$ | 928,417$ | 880,806$ | 0$ | 878,531$ | 0 | 0 | 3,483,556$ | 60 | 5,245$ | 236,025$ |
| 29 |  Toronto Marlies (TOR) | 6000 | 3000 | 50 | 25 | 156192 | 78353 | 96.41% | 96.73% | 8 | 8687 - 96.52% | 434,152$ | 11,722,110$ | 9000 | 100 | 1,329,666$ | 1,329,666$ | 949,948$ | 0$ | 949,948$ | 0 | 0 | 3,473,218$ | 60 | 7,512$ | 338,040$ |
| 30 |  Tucson Roadrunners (UTA) | 6000 | 3000 | 50 | 25 | 148277 | 75203 | 95.05% | 96.41% | 9 | 8595 - 95.50% | 428,950$ | 11,152,710$ | 9000 | 100 | 1,696,974$ | 1,696,974$ | 1,077,868$ | 0$ | 1,077,868$ | 0 | 0 | 3,860,553$ | 60 | 9,587$ | 431,415$ |
| 31 |  Utica Comets (NJD) | 6000 | 3000 | 50 | 25 | 155239 | 76775 | 95.83% | 94.78% | 8 | 8593 - 95.48% | 430,281$ | 11,617,590$ | 9000 | 100 | 1,500,583$ | 1,500,583$ | 1,126,010$ | 0$ | 1,125,572$ | 0 | 0 | 3,442,249$ | 60 | 8,478$ | 381,510$ |
| 32 |  Wilkes-Barre Penguins (PIT) | 6000 | 3000 | 50 | 25 | 154730 | 77517 | 95.51% | 95.70% | 8 | 8602 - 95.57% | 429,974$ | 11,609,310$ | 9000 | 100 | 1,274,667$ | 1,274,667$ | 891,757$ | 0$ | 891,739$ | 0 | 0 | 3,439,796$ | 60 | 7,202$ | 324,090$ |