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 |
Capacity | Ticket Price | Attendance | Attendance PCT | Income | Expenses | Estimate | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
# | Team | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Capacity | Team Popularity | Players Total Salaries | Players Total Average Salaries | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses |
1 | Abbotsford Canucks (VAN) | 4500 | 3500 | 35 | 0 | 142809 | 109821 | 96.17% | 95.08% | 1 | 7655 - 95.69% | 151,464$ | 4,998,315$ | 8000 | 100 | 1,856,500$ | 1,481,500$ | 1,760,479$ | 0$ | 1,760,479$ | 0 | 0 | 151,464$ | 21 | 10,489$ | 62,934$ |
2 | Bakersfield Condors (EDM) | 4500 | 3500 | 35 | 0 | 144889 | 113722 | 94.70% | 95.56% | 0 | 7606 - 95.08% | 149,150$ | 5,071,115$ | 8000 | 100 | 2,188,728$ | 1,739,783$ | 2,161,028$ | 0$ | 2,161,028$ | 0 | 0 | 0$ | 21 | 12,366$ | 74,196$ |
3 | Belleville Senators (OTT) | 4500 | 3500 | 35 | 0 | 148262 | 113671 | 96.90% | 95.52% | 0 | 7704 - 96.30% | 152,623$ | 5,189,170$ | 8000 | 100 | 1,706,583$ | 1,256,583$ | 1,633,394$ | 0$ | 1,633,394$ | 0 | 0 | 0$ | 21 | 9,642$ | 57,852$ |
4 | Bridgeport Islanders (NYI) | 4500 | 3500 | 35 | 0 | 146251 | 112877 | 95.59% | 94.85% | 0 | 7621 - 95.27% | 150,553$ | 5,118,785$ | 8000 | 100 | 1,420,000$ | 895,000$ | 1,548,153$ | 0$ | 1,548,153$ | 0 | 0 | 0$ | 21 | 8,023$ | 48,138$ |
5 | Calgary Wranglers (CGY) | 4500 | 3500 | 35 | 0 | 142721 | 109803 | 96.11% | 95.07% | 1 | 7652 - 95.65% | 151,371$ | 4,995,235$ | 8000 | 100 | 1,810,005$ | 1,585,005$ | 1,690,204$ | 0$ | 1,690,204$ | 0 | 0 | 151,371$ | 21 | 10,226$ | 61,356$ |
6 | Charlotte Checkers (FLO) | 4500 | 3500 | 35 | 0 | 145705 | 112853 | 95.23% | 94.83% | 0 | 7605 - 95.06% | 149,990$ | 5,099,675$ | 8000 | 100 | 1,989,279$ | 608,500$ | 1,919,163$ | 0$ | 1,919,163$ | 0 | 0 | 0$ | 21 | 11,239$ | 67,434$ |
7 | Chicago Wolves (CAR) | 4500 | 3500 | 35 | 0 | 143641 | 112391 | 96.73% | 97.31% | 1 | 7759 - 96.98% | 152,347$ | 5,027,435$ | 8000 | 100 | 1,912,750$ | 1,687,750$ | 1,836,486$ | 0$ | 1,836,486$ | 0 | 0 | 152,347$ | 21 | 10,806$ | 64,836$ |
8 | Cleveland Monsters (CLB) | 4500 | 3500 | 35 | 0 | 148766 | 113654 | 97.23% | 95.51% | 0 | 7718 - 96.48% | 153,141$ | 5,206,810$ | 8000 | 100 | 1,491,083$ | 966,083$ | 1,293,193$ | 0$ | 1,293,193$ | 0 | 0 | 0$ | 21 | 8,424$ | 50,544$ |
9 | Coachella Valley Firebirds (SEA) | 4500 | 3500 | 40 | 20 | 122400 | 95200 | 80.00% | 80.00% | 0 | 6400 - 80.00% | 200,000$ | 6,800,000$ | 8000 | 100 | 1,444,917$ | 919,917$ | 1,402,552$ | 0$ | 1,402,552$ | 0 | 0 | 0$ | 21 | 8,163$ | 48,978$ |
10 | Colorado Eagles (COL) | 4500 | 3500 | 35 | 0 | 142159 | 110840 | 95.73% | 95.97% | 1 | 7667 - 95.83% | 150,775$ | 4,975,565$ | 8000 | 100 | 1,754,500$ | 1,103,250$ | 1,696,117$ | 0$ | 1,696,117$ | 0 | 0 | 150,775$ | 21 | 9,912$ | 59,472$ |
11 | Grand Rapids Griffins (DET) | 4500 | 3500 | 35 | 0 | 143110 | 110786 | 96.37% | 95.92% | 1 | 7694 - 96.17% | 151,783$ | 5,008,850$ | 8000 | 100 | 1,337,583$ | 887,583$ | 1,287,731$ | 0$ | 1,287,731$ | 0 | 0 | 151,783$ | 21 | 7,557$ | 45,342$ |
12 | Hartford Wolf Pack (NYR) | 4500 | 3500 | 35 | 0 | 144420 | 112792 | 97.25% | 97.66% | 1 | 7794 - 97.43% | 153,173$ | 5,054,700$ | 8000 | 100 | 1,298,251$ | 923,251$ | 1,177,825$ | 0$ | 1,177,825$ | 0 | 0 | 153,173$ | 21 | 7,335$ | 44,010$ |
13 | Henderson Silver Knights (VGK) | 4500 | 3500 | 40 | 20 | 107770 | 71400 | 70.44% | 60.00% | 0 | 5270 - 65.87% | 168,788$ | 5,738,800$ | 8000 | 100 | 1,529,750$ | 854,750$ | 1,514,083$ | 0$ | 1,514,083$ | 0 | 0 | 0$ | 21 | 8,643$ | 51,858$ |
14 | Hershey Bears (WSH) | 4500 | 3500 | 35 | 0 | 141508 | 110195 | 95.29% | 95.41% | 1 | 7627 - 95.34% | 150,084$ | 4,952,780$ | 8000 | 100 | 1,552,583$ | 1,102,583$ | 1,423,791$ | 0$ | 1,423,791$ | 0 | 0 | 150,084$ | 21 | 8,772$ | 52,632$ |
15 | Iowa Wild (MIN) | 4500 | 3500 | 35 | 0 | 147434 | 114291 | 96.36% | 96.04% | 0 | 7698 - 96.22% | 151,770$ | 5,160,190$ | 8000 | 100 | 1,913,917$ | 1,913,917$ | 1,665,569$ | 0$ | 1,665,569$ | 0 | 0 | 0$ | 21 | 10,813$ | 64,878$ |
16 | Laval Rocket (MTL) | 4500 | 3500 | 35 | 0 | 147490 | 113403 | 96.40% | 95.30% | 0 | 7673 - 95.92% | 151,828$ | 5,162,150$ | 8000 | 100 | 2,630,083$ | 2,100,083$ | 2,579,390$ | 0$ | 2,579,390$ | 0 | 0 | 0$ | 21 | 14,859$ | 89,154$ |
17 | Lehigh Valley Phantoms (PHI) | 4500 | 3500 | 35 | 0 | 146532 | 113387 | 95.77% | 95.28% | 0 | 7645 - 95.56% | 150,842$ | 5,128,620$ | 8000 | 100 | 2,011,917$ | 1,711,917$ | 1,767,358$ | 0$ | 1,767,358$ | 0 | 0 | 0$ | 21 | 11,367$ | 68,202$ |
18 | Manitoba Moose (WPG) | 4500 | 3500 | 35 | 0 | 143850 | 110291 | 96.87% | 95.49% | 1 | 7701 - 96.27% | 152,568$ | 5,034,750$ | 8000 | 100 | 1,427,361$ | 1,277,361$ | 1,602,809$ | 0$ | 1,602,809$ | 0 | 0 | 152,568$ | 21 | 8,064$ | 48,384$ |
19 | Milwaukee Admirals (NSH) | 4500 | 3500 | 35 | 0 | 142675 | 109524 | 96.08% | 94.83% | 1 | 7642 - 95.53% | 151,322$ | 4,993,625$ | 8000 | 100 | 1,165,000$ | 865,000$ | 1,186,293$ | 0$ | 1,186,293$ | 0 | 0 | 151,322$ | 21 | 6,582$ | 39,492$ |
20 | Ontario Reign (LOS) | 4500 | 3500 | 35 | 0 | 148144 | 115295 | 96.83% | 96.89% | 0 | 7748 - 96.85% | 152,501$ | 5,185,040$ | 8000 | 100 | 1,318,417$ | 718,417$ | 1,272,931$ | 0$ | 1,272,931$ | 0 | 0 | 0$ | 21 | 7,449$ | 44,694$ |
21 | Providence Bruins (BOS) | 4500 | 3500 | 35 | 0 | 146260 | 115519 | 95.59% | 97.07% | 0 | 7699 - 96.24% | 150,562$ | 5,119,100$ | 8000 | 100 | 1,441,250$ | 916,250$ | 1,248,148$ | 0$ | 1,248,148$ | 0 | 0 | 0$ | 21 | 8,143$ | 48,858$ |
22 | Rochester Americans (BUF) | 4500 | 3500 | 35 | 0 | 141018 | 111752 | 94.96% | 96.75% | 1 | 7660 - 95.75% | 149,565$ | 4,935,630$ | 8000 | 100 | 1,983,662$ | 1,833,662$ | 1,706,344$ | 0$ | 1,706,344$ | 0 | 0 | 149,565$ | 21 | 11,207$ | 67,242$ |
23 | Rockford IceHogs (CHI) | 4500 | 3500 | 35 | 0 | 141639 | 110619 | 95.38% | 95.77% | 1 | 7644 - 95.55% | 150,223$ | 4,957,365$ | 8000 | 100 | 1,500,000$ | 300,000$ | 1,493,632$ | 0$ | 1,493,632$ | 0 | 0 | 150,223$ | 21 | 8,475$ | 50,850$ |
24 | San Diego Gulls (ANA) | 4500 | 3500 | 35 | 0 | 142067 | 110888 | 95.67% | 96.01% | 1 | 7665 - 95.82% | 150,677$ | 4,972,345$ | 8000 | 100 | 1,765,167$ | 1,165,167$ | 1,746,350$ | 0$ | 1,746,350$ | 0 | 0 | 150,677$ | 21 | 9,973$ | 59,838$ |
25 | San Jose Barracuda (SAN) | 4500 | 3500 | 35 | 0 | 141099 | 111699 | 95.02% | 96.71% | 1 | 7661 - 95.76% | 149,650$ | 4,938,465$ | 8000 | 100 | 1,958,334$ | 1,446,084$ | 1,654,159$ | 0$ | 1,654,159$ | 0 | 0 | 149,650$ | 21 | 11,064$ | 66,384$ |
26 | Springfield Thunderbirds (STL) | 4500 | 3500 | 35 | 0 | 143010 | 109716 | 96.30% | 94.99% | 1 | 7658 - 95.73% | 151,677$ | 5,005,350$ | 8000 | 100 | 1,761,666$ | 1,461,666$ | 1,639,211$ | 0$ | 1,639,211$ | 0 | 0 | 151,677$ | 21 | 9,953$ | 59,718$ |
27 | Syracuse Crunch (TAM) | 4500 | 3500 | 35 | 0 | 142768 | 111633 | 96.14% | 96.65% | 1 | 7709 - 96.36% | 151,421$ | 4,996,880$ | 8000 | 100 | 1,352,166$ | 977,166$ | 1,303,362$ | 0$ | 1,303,362$ | 0 | 0 | 151,421$ | 21 | 7,639$ | 45,834$ |
28 | Texas Stars (DAL) | 4500 | 3500 | 35 | 0 | 146113 | 111811 | 95.50% | 93.96% | 0 | 7586 - 94.83% | 150,410$ | 5,113,955$ | 8000 | 100 | 1,702,000$ | 1,102,000$ | 1,435,601$ | 0$ | 1,435,601$ | 0 | 0 | 0$ | 21 | 9,616$ | 57,696$ |
29 | Toronto Marlies (TOR) | 4500 | 3500 | 35 | 0 | 141403 | 112220 | 95.22% | 97.16% | 1 | 7686 - 96.07% | 149,973$ | 4,949,105$ | 8000 | 100 | 1,819,917$ | 1,294,917$ | 1,754,294$ | 0$ | 1,754,294$ | 0 | 0 | 149,973$ | 21 | 10,282$ | 61,692$ |
30 | Tucson Roadrunners (ARZ) | 4500 | 3500 | 35 | 0 | 143399 | 111282 | 96.56% | 96.35% | 1 | 7718 - 96.47% | 152,090$ | 5,018,965$ | 8000 | 100 | 1,287,166$ | 687,166$ | 1,239,640$ | 0$ | 1,239,640$ | 0 | 0 | 152,090$ | 21 | 7,272$ | 43,632$ |
31 | Utica Comets (NJD) | 4500 | 3500 | 35 | 0 | 143928 | 110536 | 96.92% | 95.70% | 1 | 7711 - 96.39% | 152,651$ | 5,037,480$ | 8000 | 100 | 1,517,542$ | 842,542$ | 1,297,824$ | 0$ | 1,297,824$ | 0 | 0 | 152,651$ | 21 | 8,574$ | 51,444$ |
32 | Wilkes Barre Scranton Penguins (PIT) | 4500 | 3500 | 35 | 0 | 143070 | 110892 | 96.34% | 96.01% | 1 | 7696 - 96.20% | 151,741$ | 5,007,450$ | 8000 | 100 | 1,468,042$ | 1,018,042$ | 1,365,968$ | 0$ | 1,365,968$ | 0 | 0 | 151,741$ | 21 | 8,294$ | 49,764$ |