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 | 138840 | 106514 | 96.42% | 95.10% | 2 | 7667 - 95.84% | 151,856$ | 4,859,400$ | 8000 | 100 | 1,783,125$ | 1,408,125$ | 1,657,664$ | 0$ | 1,657,664$ | 0 | 0 | 303,712$ | 31 | 10,074$ | 161,184$ |
2 | Bakersfield Condors (EDM) | 4500 | 3500 | 35 | 0 | 136308 | 106722 | 94.66% | 95.29% | 2 | 7595 - 94.93% | 149,087$ | 4,770,780$ | 8000 | 100 | 2,298,095$ | 1,838,533$ | 2,028,770$ | 0$ | 2,028,770$ | 0 | 0 | 298,174$ | 31 | 12,984$ | 207,744$ |
3 | Belleville Senators (OTT) | 4500 | 3500 | 35 | 0 | 139689 | 106690 | 97.01% | 95.26% | 2 | 7699 - 96.24% | 152,785$ | 4,889,115$ | 8000 | 100 | 1,706,583$ | 1,256,583$ | 1,539,942$ | 0$ | 1,539,942$ | 0 | 0 | 305,570$ | 31 | 9,642$ | 154,272$ |
4 | Bridgeport Islanders (NYI) | 4500 | 3500 | 35 | 0 | 138019 | 106268 | 95.85% | 94.88% | 2 | 7634 - 95.42% | 150,958$ | 4,830,665$ | 8000 | 100 | 1,350,000$ | 825,000$ | 1,470,751$ | 0$ | 1,470,751$ | 0 | 0 | 301,917$ | 31 | 7,627$ | 122,032$ |
5 | Calgary Wranglers (CGY) | 4500 | 3500 | 35 | 0 | 138768 | 106597 | 96.37% | 95.18% | 2 | 7668 - 95.85% | 151,778$ | 4,856,880$ | 8000 | 100 | 1,749,251$ | 1,524,251$ | 1,588,487$ | 0$ | 1,588,487$ | 0 | 0 | 303,555$ | 31 | 9,883$ | 158,128$ |
6 | Charlotte Checkers (FLO) | 4500 | 3500 | 35 | 0 | 141205 | 109548 | 95.09% | 94.85% | 1 | 7599 - 94.98% | 149,763$ | 4,942,175$ | 8000 | 100 | 1,989,279$ | 608,500$ | 1,806,773$ | 0$ | 1,806,773$ | 0 | 0 | 149,763$ | 31 | 11,239$ | 179,824$ |
7 | Chicago Wolves (CAR) | 4500 | 3500 | 35 | 0 | 139376 | 108891 | 96.79% | 97.22% | 2 | 7758 - 96.98% | 152,443$ | 4,878,160$ | 8000 | 100 | 1,912,750$ | 1,687,750$ | 1,728,426$ | 0$ | 1,728,426$ | 0 | 0 | 304,885$ | 31 | 10,806$ | 172,896$ |
8 | Cleveland Monsters (CLB) | 4500 | 3500 | 35 | 0 | 139848 | 106959 | 97.12% | 95.50% | 2 | 7713 - 96.41% | 152,959$ | 4,894,680$ | 8000 | 100 | 1,666,833$ | 1,141,833$ | 1,208,953$ | 0$ | 1,208,953$ | 0 | 0 | 305,918$ | 31 | 9,417$ | 150,672$ |
9 | Coachella Valley Firebirds (SEA) | 4500 | 3500 | 40 | 20 | 115200 | 89600 | 80.00% | 80.00% | 2 | 6400 - 80.00% | 200,000$ | 6,400,000$ | 8000 | 100 | 1,368,667$ | 843,667$ | 1,324,792$ | 0$ | 1,324,792$ | 0 | 0 | 400,000$ | 31 | 7,733$ | 123,728$ |
10 | Colorado Eagles (COL) | 4500 | 3500 | 35 | 0 | 138030 | 107340 | 95.85% | 95.84% | 2 | 7668 - 95.85% | 150,970$ | 4,831,050$ | 8000 | 100 | 1,753,667$ | 1,102,417$ | 1,597,017$ | 0$ | 1,597,017$ | 0 | 0 | 301,941$ | 31 | 9,908$ | 158,528$ |
11 | Grand Rapids Griffins (DET) | 4500 | 3500 | 35 | 0 | 138900 | 107552 | 96.46% | 96.03% | 2 | 7702 - 96.27% | 151,922$ | 4,861,500$ | 8000 | 100 | 1,337,583$ | 887,583$ | 1,212,161$ | 0$ | 1,212,161$ | 0 | 0 | 303,844$ | 31 | 7,557$ | 120,912$ |
12 | Hartford Wolf Pack (NYR) | 4500 | 3500 | 35 | 0 | 140442 | 109292 | 97.53% | 97.58% | 2 | 7804 - 97.55% | 153,608$ | 4,915,470$ | 8000 | 100 | 1,223,251$ | 848,251$ | 1,106,595$ | 0$ | 1,106,595$ | 0 | 0 | 307,217$ | 31 | 6,911$ | 110,576$ |
13 | Henderson Silver Knights (VGK) | 4500 | 3500 | 40 | 20 | 101513 | 67200 | 70.50% | 60.00% | 2 | 5272 - 65.90% | 168,891$ | 5,404,520$ | 8000 | 100 | 1,604,750$ | 929,750$ | 1,426,386$ | 0$ | 1,426,386$ | 0 | 0 | 337,782$ | 31 | 9,066$ | 145,056$ |
14 | Hershey Bears (WSH) | 4500 | 3500 | 35 | 0 | 137008 | 107123 | 95.14% | 95.65% | 2 | 7629 - 95.36% | 149,853$ | 4,795,280$ | 8000 | 100 | 1,475,083$ | 950,083$ | 1,339,165$ | 0$ | 1,339,165$ | 0 | 0 | 299,705$ | 31 | 8,334$ | 133,344$ |
15 | Iowa Wild (MIN) | 4500 | 3500 | 35 | 0 | 142934 | 110847 | 96.25% | 95.97% | 1 | 7690 - 96.13% | 151,597$ | 5,002,690$ | 8000 | 100 | 1,718,917$ | 1,718,917$ | 1,562,949$ | 0$ | 1,562,949$ | 0 | 0 | 151,597$ | 31 | 9,711$ | 155,376$ |
16 | Laval Rocket (MTL) | 4500 | 3500 | 35 | 0 | 139005 | 106842 | 96.53% | 95.39% | 2 | 7683 - 96.03% | 152,037$ | 4,865,175$ | 8000 | 100 | 2,630,083$ | 2,100,083$ | 2,430,800$ | 0$ | 2,430,800$ | 0 | 0 | 304,073$ | 31 | 14,859$ | 237,744$ |
17 | Lehigh Valley Phantoms (PHI) | 4500 | 3500 | 35 | 0 | 137777 | 107029 | 95.68% | 95.56% | 2 | 7650 - 95.63% | 150,694$ | 4,822,195$ | 8000 | 100 | 2,011,917$ | 1,711,917$ | 1,653,688$ | 0$ | 1,653,688$ | 0 | 0 | 301,387$ | 31 | 11,367$ | 181,872$ |
18 | Manitoba Moose (WPG) | 4500 | 3500 | 35 | 0 | 139350 | 106987 | 96.77% | 95.52% | 2 | 7698 - 96.23% | 152,414$ | 4,877,250$ | 8000 | 100 | 1,427,361$ | 1,277,361$ | 1,522,169$ | 0$ | 1,522,169$ | 0 | 0 | 304,828$ | 31 | 8,064$ | 129,024$ |
19 | Milwaukee Admirals (NSH) | 4500 | 3500 | 35 | 0 | 138659 | 106380 | 96.29% | 94.98% | 2 | 7657 - 95.72% | 151,658$ | 4,853,065$ | 8000 | 100 | 1,165,000$ | 865,000$ | 1,119,180$ | 0$ | 1,119,180$ | 0 | 0 | 303,317$ | 31 | 6,582$ | 105,312$ |
20 | Ontario Reign (LOS) | 4500 | 3500 | 35 | 0 | 139695 | 108528 | 97.01% | 96.90% | 2 | 7757 - 96.96% | 152,791$ | 4,889,325$ | 8000 | 100 | 1,318,417$ | 718,417$ | 1,199,289$ | 0$ | 1,199,289$ | 0 | 0 | 305,583$ | 31 | 7,449$ | 119,184$ |
21 | Providence Bruins (BOS) | 4500 | 3500 | 35 | 0 | 137626 | 108944 | 95.57% | 97.27% | 2 | 7705 - 96.32% | 150,528$ | 4,816,910$ | 8000 | 100 | 1,290,000$ | 765,000$ | 1,172,520$ | 0$ | 1,172,520$ | 0 | 0 | 301,057$ | 31 | 7,288$ | 116,608$ |
22 | Rochester Americans (BUF) | 4500 | 3500 | 35 | 0 | 136969 | 108470 | 95.12% | 96.85% | 2 | 7670 - 95.87% | 149,810$ | 4,793,915$ | 8000 | 100 | 1,908,662$ | 1,758,662$ | 1,596,394$ | 0$ | 1,596,394$ | 0 | 0 | 299,620$ | 31 | 10,783$ | 172,528$ |
23 | Rockford IceHogs (CHI) | 4500 | 3500 | 35 | 0 | 137597 | 107317 | 95.55% | 95.82% | 2 | 7654 - 95.67% | 150,497$ | 4,815,895$ | 8000 | 100 | 1,575,000$ | 375,000$ | 1,406,767$ | 0$ | 1,406,767$ | 0 | 0 | 300,993$ | 31 | 8,898$ | 142,368$ |
24 | San Diego Gulls (ANA) | 4500 | 3500 | 35 | 0 | 137944 | 107388 | 95.79% | 95.88% | 2 | 7667 - 95.83% | 150,876$ | 4,828,040$ | 8000 | 100 | 1,765,167$ | 1,165,167$ | 1,646,620$ | 0$ | 1,646,620$ | 0 | 0 | 301,752$ | 31 | 9,973$ | 159,568$ |
25 | San Jose Barracuda (SAN) | 4500 | 3500 | 35 | 0 | 136815 | 108465 | 95.01% | 96.84% | 2 | 7665 - 95.81% | 149,641$ | 4,788,525$ | 8000 | 100 | 1,762,084$ | 1,237,084$ | 1,549,064$ | 0$ | 1,549,064$ | 0 | 0 | 299,283$ | 31 | 9,955$ | 159,280$ |
26 | Springfield Thunderbirds (STL) | 4500 | 3500 | 35 | 0 | 138932 | 106216 | 96.48% | 94.84% | 2 | 7661 - 95.76% | 151,957$ | 4,862,620$ | 8000 | 100 | 1,761,666$ | 1,461,666$ | 1,539,681$ | 0$ | 1,539,681$ | 0 | 0 | 303,914$ | 31 | 9,953$ | 159,248$ |
27 | Syracuse Crunch (TAM) | 4500 | 3500 | 35 | 0 | 138268 | 108299 | 96.02% | 96.70% | 2 | 7705 - 96.32% | 151,231$ | 4,839,380$ | 8000 | 100 | 1,352,166$ | 977,166$ | 1,226,972$ | 0$ | 1,226,972$ | 0 | 0 | 302,461$ | 31 | 7,639$ | 122,224$ |
28 | Texas Stars (DAL) | 4500 | 3500 | 35 | 0 | 137925 | 105499 | 95.78% | 94.20% | 2 | 7607 - 95.09% | 150,855$ | 4,827,375$ | 8000 | 100 | 1,472,500$ | 872,500$ | 1,342,498$ | 0$ | 1,342,498$ | 0 | 0 | 301,711$ | 31 | 8,319$ | 133,104$ |
29 | Toronto Marlies (TOR) | 4500 | 3500 | 35 | 0 | 136903 | 109044 | 95.07% | 97.36% | 2 | 7686 - 96.07% | 149,738$ | 4,791,605$ | 8000 | 100 | 1,819,917$ | 1,294,917$ | 1,651,474$ | 0$ | 1,651,474$ | 0 | 0 | 299,475$ | 31 | 10,282$ | 164,512$ |
30 | Tucson Roadrunners (ARZ) | 4500 | 3500 | 35 | 0 | 139134 | 107966 | 96.62% | 96.40% | 2 | 7722 - 96.52% | 152,178$ | 4,869,690$ | 8000 | 100 | 1,212,166$ | 612,166$ | 1,166,920$ | 0$ | 1,166,920$ | 0 | 0 | 304,356$ | 31 | 6,848$ | 109,568$ |
31 | Utica Comets (NJD) | 4500 | 3500 | 35 | 0 | 139428 | 107433 | 96.83% | 95.92% | 2 | 7714 - 96.43% | 152,499$ | 4,879,980$ | 8000 | 100 | 1,288,375$ | 538,375$ | 1,216,439$ | 0$ | 1,216,439$ | 0 | 0 | 304,999$ | 31 | 7,279$ | 116,464$ |
32 | Wilkes Barre Scranton Penguins (PIT) | 4500 | 3500 | 35 | 0 | 139035 | 107482 | 96.55% | 95.97% | 2 | 7704 - 96.30% | 152,070$ | 4,866,225$ | 8000 | 100 | 1,468,042$ | 1,018,042$ | 1,283,028$ | 0$ | 1,283,028$ | 0 | 0 | 304,139$ | 31 | 8,294$ | 132,704$ |