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) | 2000 | 1000 | 45 | 20 | 67169 | 32989 | 95.96% | 94.25% | 1 | 2862 - 95.39% | 105,211$ | 3,682,385$ | 3000 | 100 | 2,950,297$ | 2,950,297$ | 3,065,636$ | 0$ | 2,579,432$ | 0 | 0 | 105,211$ | 11 | 23,795$ | 95,180$ |
2 | Bakersfield Condors (EDM) | 2000 | 1000 | 50 | 20 | 54312 | 33602 | 77.59% | 96.01% | 1 | 2512 - 83.73% | 96,790$ | 3,387,640$ | 3000 | 100 | 2,540,499$ | 2,540,499$ | 3,027,204$ | 0$ | 2,541,036$ | 0 | 0 | 96,790$ | 11 | 20,969$ | 83,876$ |
3 | Belleville Senators (OTT) | 2000 | 1000 | 49 | 20 | 64880 | 34474 | 90.11% | 95.76% | 0 | 2760 - 91.99% | 107,822$ | 3,881,600$ | 3000 | 100 | 3,504,682$ | 3,504,682$ | 3,459,477$ | 0$ | 2,973,246$ | 0 | 0 | 0$ | 11 | 27,618$ | 110,472$ |
4 | Bridgeport Islanders (NYI) | 2000 | 1000 | 40 | 22 | 68631 | 26978 | 95.32% | 74.94% | 0 | 2656 - 88.53% | 92,743$ | 3,338,756$ | 3000 | 100 | 2,075,153$ | 2,075,153$ | 2,534,653$ | 0$ | 2,048,406$ | 0 | 0 | 0$ | 11 | 17,760$ | 71,040$ |
5 | Calgary Wranglers (CGY) | 2000 | 1000 | 50 | 20 | 56043 | 32964 | 77.84% | 91.57% | 0 | 2472 - 82.41% | 97,882$ | 3,523,745$ | 3000 | 100 | 3,263,935$ | 3,263,935$ | 3,627,322$ | 0$ | 3,141,154$ | 0 | 0 | 0$ | 11 | 25,958$ | 103,832$ |
6 | Charlotte Checkers (FLA) | 2000 | 1000 | 50 | 20 | 54028 | 33441 | 77.18% | 95.55% | 1 | 2499 - 83.30% | 96,292$ | 3,370,220$ | 3000 | 100 | 2,579,833$ | 2,579,833$ | 3,068,516$ | 0$ | 2,582,348$ | 0 | 0 | 96,292$ | 11 | 21,240$ | 84,960$ |
7 | Chicago Wolves (CAR) | 2000 | 1000 | 50 | 20 | 53993 | 33182 | 77.13% | 94.81% | 1 | 2491 - 83.02% | 96,094$ | 3,363,290$ | 3000 | 100 | 2,088,500$ | 2,088,500$ | 2,517,132$ | 0$ | 2,030,823$ | 0 | 0 | 96,094$ | 11 | 17,852$ | 71,408$ |
8 | Cleveland Monsters (CBJ) | 2000 | 1000 | 50 | 20 | 54535 | 33521 | 77.91% | 95.77% | 1 | 2516 - 83.86% | 97,062$ | 3,397,170$ | 3000 | 100 | 10,021,083$ | 10,021,083$ | 4,721,786$ | 0$ | 4,235,617$ | 0 | 0 | 97,062$ | 11 | 72,559$ | 290,236$ |
9 | Coachella Valley Firebirds (SEA) | 2000 | 1000 | 50 | 20 | 55797 | 34328 | 77.50% | 95.36% | 0 | 2503 - 83.45% | 96,567$ | 3,476,410$ | 3000 | 100 | 1,799,584$ | 1,799,584$ | 2,318,403$ | 0$ | 1,832,232$ | 0 | 0 | 0$ | 11 | 15,859$ | 63,436$ |
10 | Colorado Eagles (COL) | 2000 | 1000 | 55 | 25 | 49810 | 23962 | 69.18% | 66.56% | 0 | 2049 - 68.31% | 92,739$ | 3,338,600$ | 3000 | 100 | 2,169,782$ | 2,169,782$ | 2,596,092$ | 0$ | 2,109,924$ | 0 | 0 | 0$ | 11 | 18,412$ | 73,648$ |
11 | Grand Rapids Griffins (DET) | 2000 | 1000 | 50 | 25 | 57148 | 23623 | 79.37% | 65.62% | 0 | 2244 - 74.79% | 95,777$ | 3,447,975$ | 3000 | 100 | 2,126,408$ | 2,126,408$ | 2,553,933$ | 0$ | 2,067,765$ | 0 | 0 | 0$ | 11 | 18,113$ | 72,452$ |
12 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 50 | 20 | 55725 | 33748 | 77.40% | 93.74% | 0 | 2485 - 82.85% | 96,145$ | 3,461,210$ | 3000 | 100 | 2,505,438$ | 2,505,438$ | 2,935,288$ | 0$ | 2,449,119$ | 0 | 0 | 0$ | 11 | 20,727$ | 82,908$ |
13 | Henderson Silver Knights (VGK) | 2000 | 1000 | 50 | 20 | 56549 | 34578 | 78.54% | 96.05% | 0 | 2531 - 84.38% | 97,750$ | 3,519,010$ | 3000 | 100 | 2,458,825$ | 2,458,825$ | 2,846,577$ | 0$ | 2,360,273$ | 0 | 0 | 0$ | 11 | 20,406$ | 81,624$ |
14 | Hershey Bears (WSH) | 2000 | 1000 | 50 | 20 | 57475 | 34954 | 79.83% | 97.09% | 0 | 2567 - 85.58% | 99,245$ | 3,572,830$ | 3000 | 100 | 2,713,092$ | 2,713,092$ | 2,663,901$ | 0$ | 2,177,724$ | 0 | 0 | 0$ | 11 | 22,159$ | 88,636$ |
15 | Iowa Wild (MIN) | 2000 | 1000 | 35 | 20 | 68590 | 32895 | 97.99% | 93.99% | 1 | 2900 - 96.65% | 88,129$ | 3,084,530$ | 3000 | 100 | 3,135,063$ | 3,150,750$ | 3,564,532$ | 0$ | 3,078,338$ | 0 | 0 | 88,129$ | 11 | 25,069$ | 100,276$ |
16 | Laval Rocket (MTL) | 2000 | 1000 | 50 | 20 | 54013 | 33036 | 77.16% | 94.39% | 1 | 2487 - 82.90% | 96,039$ | 3,361,370$ | 3000 | 100 | 2,593,230$ | 2,721,350$ | 2,491,559$ | 0$ | 2,005,373$ | 0 | 0 | 96,039$ | 11 | 21,333$ | 85,332$ |
17 | Lehigh Valley Phantoms (PHI) | 2000 | 1000 | 50 | 20 | 52007 | 25496 | 72.23% | 70.82% | 0 | 2153 - 71.76% | 95,441$ | 3,435,880$ | 3000 | 100 | 3,016,573$ | 3,016,573$ | 2,716,386$ | 0$ | 2,230,199$ | 0 | 0 | 0$ | 11 | 24,252$ | 97,008$ |
18 | Manitoba Moose (WPG) | 2000 | 1000 | 50 | 25 | 54176 | 23299 | 77.39% | 66.57% | 1 | 2214 - 73.79% | 94,036$ | 3,291,275$ | 3000 | 100 | 2,087,625$ | 2,087,625$ | 2,516,286$ | 0$ | 2,029,977$ | 0 | 0 | 94,036$ | 11 | 17,846$ | 71,384$ |
19 | Milwaukee Admirals (NSH) | 2000 | 1000 | 50 | 20 | 56765 | 34559 | 78.84% | 96.00% | 0 | 2537 - 84.56% | 98,040$ | 3,529,430$ | 3000 | 100 | 1,944,829$ | 1,944,829$ | 2,377,401$ | 0$ | 1,891,233$ | 0 | 0 | 0$ | 11 | 16,861$ | 67,444$ |
20 | Ontario Reign (LAK) | 2000 | 1000 | 50 | 20 | 56632 | 33625 | 78.66% | 93.40% | 0 | 2507 - 83.57% | 97,336$ | 3,504,100$ | 3000 | 100 | 2,109,548$ | 2,109,548$ | 2,461,199$ | 0$ | 1,974,958$ | 0 | 0 | 0$ | 11 | 17,997$ | 71,988$ |
21 | Providence Bruins (BOS) | 2000 | 1000 | 55 | 25 | 49862 | 23739 | 69.25% | 65.94% | 0 | 2044 - 68.15% | 92,663$ | 3,335,885$ | 3000 | 100 | 2,454,179$ | 2,454,179$ | 2,992,225$ | 0$ | 2,505,958$ | 0 | 0 | 0$ | 11 | 20,374$ | 81,496$ |
22 | Rochester Americans (BUF) | 2000 | 1000 | 55 | 25 | 51434 | 23650 | 71.44% | 65.69% | 0 | 2086 - 69.52% | 95,003$ | 3,420,120$ | 3000 | 100 | 2,715,688$ | 2,715,688$ | 3,126,957$ | 0$ | 2,640,789$ | 0 | 0 | 0$ | 11 | 22,177$ | 88,708$ |
23 | Rockford IceHogs (CHI) | 2000 | 1000 | 50 | 21 | 54137 | 29442 | 77.34% | 84.12% | 1 | 2388 - 79.60% | 95,004$ | 3,325,132$ | 3000 | 100 | 2,122,166$ | 2,122,166$ | 2,777,998$ | 0$ | 2,291,782$ | 0 | 0 | 95,004$ | 11 | 18,084$ | 72,336$ |
24 | San Diego Gulls (ANA) | 2000 | 1000 | 39 | 18 | 69773 | 34606 | 96.91% | 96.13% | 0 | 2899 - 96.65% | 92,890$ | 3,344,055$ | 3000 | 100 | 1,794,041$ | 1,781,791$ | 2,223,273$ | 0$ | 1,737,091$ | 0 | 0 | 0$ | 11 | 15,821$ | 63,284$ |
25 | San Jose Barracuda (SJS) | 2000 | 1000 | 55 | 25 | 49700 | 24170 | 69.03% | 67.14% | 0 | 2052 - 68.40% | 92,715$ | 3,337,750$ | 3000 | 100 | 2,737,708$ | 2,737,708$ | 3,079,453$ | 0$ | 2,593,232$ | 0 | 0 | 0$ | 11 | 22,329$ | 89,316$ |
26 | Springfield Thunderbirds (STL) | 2000 | 1000 | 50 | 20 | 54595 | 33345 | 75.83% | 92.63% | 0 | 2443 - 81.43% | 94,351$ | 3,396,650$ | 3000 | 100 | 2,225,500$ | 2,225,500$ | 2,652,162$ | 0$ | 2,165,856$ | 0 | 0 | 0$ | 11 | 18,797$ | 75,188$ |
27 | Syracuse Crunch (TBL) | 2000 | 1000 | 50 | 20 | 53403 | 32741 | 76.29% | 93.55% | 1 | 2461 - 82.04% | 94,999$ | 3,324,970$ | 3000 | 100 | 1,902,499$ | 1,902,499$ | 2,376,077$ | 0$ | 1,889,909$ | 0 | 0 | 94,999$ | 11 | 16,569$ | 66,276$ |
28 | Texas Stars (DAL) | 2000 | 1000 | 50 | 20 | 55587 | 34217 | 77.20% | 95.05% | 0 | 2495 - 83.15% | 96,214$ | 3,463,690$ | 3000 | 100 | 2,026,500$ | 2,026,500$ | 2,510,764$ | 0$ | 2,024,507$ | 0 | 0 | 0$ | 11 | 17,424$ | 69,696$ |
29 | Toronto Marlies (TOR) | 2000 | 1000 | 36 | 15 | 70733 | 35359 | 98.24% | 98.22% | 0 | 2947 - 98.23% | 88,256$ | 3,177,199$ | 3000 | 100 | 2,488,369$ | 2,488,369$ | 2,905,869$ | 0$ | 2,419,701$ | 0 | 0 | 0$ | 11 | 20,609$ | 82,436$ |
30 | Tucson Roadrunners (ARZ) | 2000 | 1000 | 50 | 20 | 55899 | 34160 | 77.64% | 94.89% | 0 | 2502 - 83.39% | 96,615$ | 3,478,150$ | 3000 | 100 | 2,561,382$ | 2,553,882$ | 2,975,950$ | 0$ | 2,489,782$ | 0 | 0 | 0$ | 11 | 21,113$ | 84,452$ |
31 | Utica Comets (NJD) | 2000 | 1000 | 50 | 20 | 56007 | 34118 | 77.79% | 94.77% | 0 | 2503 - 83.45% | 96,742$ | 3,482,710$ | 3000 | 100 | 2,750,912$ | 2,750,912$ | 2,674,225$ | 0$ | 2,188,057$ | 0 | 0 | 0$ | 11 | 22,420$ | 89,680$ |
32 | Wilkes-Barre Scranton Penguins (PIT) | 2000 | 1000 | 50 | 20 | 54269 | 33588 | 75.37% | 93.30% | 0 | 2440 - 81.35% | 94,034$ | 3,385,210$ | 3000 | 100 | 1,860,501$ | 1,860,501$ | 2,364,996$ | 0$ | 1,878,827$ | 0 | 0 | 0$ | 11 | 16,279$ | 65,116$ |