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 | 65169 | 32055 | 95.84% | 94.28% | 2 | 2860 - 95.32% | 105,109$ | 3,573,705$ | 3000 | 100 | 2,950,297$ | 2,950,297$ | 2,970,456$ | 0$ | 2,498,044$ | 0 | 0 | 210,218$ | 15 | 23,795$ | 190,360$ |
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$ | 2,943,328$ | 0$ | 2,470,952$ | 0 | 0 | 96,790$ | 15 | 20,969$ | 167,752$ |
3 | Belleville Senators (OTT) | 2000 | 1000 | 49 | 20 | 63197 | 33521 | 90.28% | 95.77% | 1 | 2763 - 92.11% | 108,002$ | 3,780,073$ | 3000 | 100 | 3,579,682$ | 3,579,682$ | 3,348,487$ | 0$ | 2,876,049$ | 0 | 0 | 108,002$ | 15 | 28,136$ | 225,088$ |
4 | Bridgeport Islanders (NYI) | 2000 | 1000 | 40 | 22 | 66819 | 26270 | 95.46% | 75.06% | 1 | 2660 - 88.66% | 92,877$ | 3,250,700$ | 3000 | 100 | 2,075,153$ | 2,075,153$ | 2,463,613$ | 0$ | 1,991,162$ | 0 | 0 | 92,877$ | 15 | 17,760$ | 142,080$ |
5 | Calgary Wranglers (CGY) | 2000 | 1000 | 50 | 20 | 54471 | 32026 | 77.82% | 91.50% | 1 | 2471 - 82.38% | 97,897$ | 3,426,385$ | 3000 | 100 | 3,263,935$ | 3,263,935$ | 3,523,490$ | 0$ | 3,051,114$ | 0 | 0 | 97,897$ | 15 | 25,958$ | 207,664$ |
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$ | 2,983,556$ | 0$ | 2,511,180$ | 0 | 0 | 96,292$ | 15 | 21,240$ | 169,920$ |
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,445,724$ | 0$ | 1,973,211$ | 0 | 0 | 96,094$ | 15 | 17,852$ | 142,816$ |
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,126,083$ | 10,126,083$ | 4,431,550$ | 0$ | 3,959,173$ | 0 | 0 | 97,062$ | 15 | 73,283$ | 586,264$ |
9 | Coachella Valley Firebirds (SEA) | 2000 | 1000 | 50 | 20 | 54147 | 33432 | 77.35% | 95.52% | 1 | 2502 - 83.41% | 96,457$ | 3,375,990$ | 3000 | 100 | 1,799,584$ | 1,799,584$ | 2,254,967$ | 0$ | 1,782,588$ | 0 | 0 | 96,457$ | 15 | 15,859$ | 126,872$ |
10 | Colorado Eagles (COL) | 2000 | 1000 | 55 | 25 | 48557 | 23326 | 69.37% | 66.65% | 1 | 2054 - 68.46% | 92,965$ | 3,253,785$ | 3000 | 100 | 2,169,782$ | 2,169,782$ | 2,522,444$ | 0$ | 2,050,068$ | 0 | 0 | 92,965$ | 15 | 18,412$ | 147,296$ |
11 | Grand Rapids Griffins (DET) | 2000 | 1000 | 50 | 25 | 54028 | 22268 | 79.45% | 65.49% | 2 | 2244 - 74.80% | 95,826$ | 3,258,100$ | 3000 | 100 | 2,126,408$ | 2,126,408$ | 2,481,481$ | 0$ | 2,009,105$ | 0 | 0 | 191,653$ | 15 | 18,113$ | 144,904$ |
12 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 50 | 20 | 52583 | 31929 | 77.33% | 93.91% | 2 | 2486 - 82.85% | 96,110$ | 3,267,730$ | 3000 | 100 | 2,505,438$ | 2,505,438$ | 2,852,380$ | 0$ | 2,380,003$ | 0 | 0 | 192,219$ | 15 | 20,727$ | 165,816$ |
13 | Henderson Silver Knights (VGK) | 2000 | 1000 | 50 | 20 | 53454 | 32586 | 78.61% | 95.84% | 2 | 2531 - 84.35% | 97,777$ | 3,324,420$ | 3000 | 100 | 2,458,825$ | 2,458,825$ | 2,764,953$ | 0$ | 2,292,445$ | 0 | 0 | 195,554$ | 15 | 20,406$ | 163,248$ |
14 | Hershey Bears (WSH) | 2000 | 1000 | 50 | 20 | 56038 | 33975 | 80.05% | 97.07% | 1 | 2572 - 85.73% | 99,469$ | 3,481,400$ | 3000 | 100 | 2,713,092$ | 2,713,092$ | 2,575,265$ | 0$ | 2,102,880$ | 0 | 0 | 99,469$ | 15 | 22,159$ | 177,272$ |
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,042,563$ | 3,058,250$ | 3,464,256$ | 0$ | 2,991,854$ | 0 | 0 | 88,129$ | 15 | 24,431$ | 195,448$ |
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,406,227$ | 0$ | 1,933,837$ | 0 | 0 | 96,039$ | 15 | 21,333$ | 170,664$ |
17 | Lehigh Valley Phantoms (PHI) | 2000 | 1000 | 50 | 20 | 49086 | 23496 | 72.19% | 69.11% | 2 | 2135 - 71.16% | 95,583$ | 3,249,830$ | 3000 | 100 | 3,016,573$ | 3,016,573$ | 2,619,378$ | 0$ | 2,146,983$ | 0 | 0 | 191,166$ | 15 | 24,252$ | 194,016$ |
18 | Manitoba Moose (WPG) | 2000 | 1000 | 50 | 25 | 52742 | 22701 | 77.56% | 66.77% | 2 | 2219 - 73.96% | 94,254$ | 3,204,625$ | 3000 | 100 | 2,087,625$ | 2,087,625$ | 2,444,902$ | 0$ | 1,972,389$ | 0 | 0 | 188,507$ | 15 | 17,846$ | 142,768$ |
19 | Milwaukee Admirals (NSH) | 2000 | 1000 | 50 | 20 | 55312 | 33637 | 79.02% | 96.11% | 1 | 2541 - 84.71% | 98,238$ | 3,438,340$ | 3000 | 100 | 1,944,829$ | 1,944,829$ | 2,309,957$ | 0$ | 1,837,581$ | 0 | 0 | 98,238$ | 15 | 16,861$ | 134,888$ |
20 | Ontario Reign (LAK) | 2000 | 1000 | 50 | 20 | 54937 | 32625 | 78.48% | 93.21% | 1 | 2502 - 83.39% | 97,124$ | 3,399,350$ | 3000 | 100 | 2,109,548$ | 2,109,548$ | 2,389,211$ | 0$ | 1,916,762$ | 0 | 0 | 97,124$ | 15 | 17,997$ | 143,976$ |
21 | Providence Bruins (BOS) | 2000 | 1000 | 55 | 25 | 47049 | 22538 | 69.19% | 66.29% | 2 | 2047 - 68.22% | 92,681$ | 3,151,145$ | 3000 | 100 | 2,454,179$ | 2,454,179$ | 2,910,729$ | 0$ | 2,438,258$ | 0 | 0 | 185,361$ | 15 | 20,374$ | 162,992$ |
22 | Rochester Americans (BUF) | 2000 | 1000 | 55 | 25 | 50042 | 23044 | 71.49% | 65.84% | 1 | 2088 - 69.61% | 95,097$ | 3,328,410$ | 3000 | 100 | 2,715,688$ | 2,715,688$ | 3,038,249$ | 0$ | 2,565,873$ | 0 | 0 | 95,097$ | 15 | 22,177$ | 177,416$ |
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,705,662$ | 0$ | 2,233,238$ | 0 | 0 | 95,004$ | 15 | 18,084$ | 144,672$ |
24 | San Diego Gulls (ANA) | 2000 | 1000 | 39 | 18 | 67938 | 33623 | 97.05% | 96.07% | 1 | 2902 - 96.72% | 92,994$ | 3,254,796$ | 3000 | 100 | 1,794,041$ | 1,781,791$ | 2,159,989$ | 0$ | 1,687,599$ | 0 | 0 | 92,994$ | 15 | 15,821$ | 126,568$ |
25 | San Jose Barracuda (SJS) | 2000 | 1000 | 55 | 25 | 48346 | 23559 | 69.07% | 67.31% | 1 | 2054 - 68.48% | 92,800$ | 3,248,005$ | 3000 | 100 | 2,737,708$ | 2,737,708$ | 2,990,137$ | 0$ | 2,517,708$ | 0 | 0 | 92,800$ | 15 | 22,329$ | 178,632$ |
26 | Springfield Thunderbirds (STL) | 2000 | 1000 | 50 | 20 | 53090 | 32469 | 75.84% | 92.77% | 1 | 2445 - 81.48% | 94,397$ | 3,303,880$ | 3000 | 100 | 2,225,500$ | 2,225,500$ | 2,576,974$ | 0$ | 2,104,464$ | 0 | 0 | 94,397$ | 15 | 18,797$ | 150,376$ |
27 | Syracuse Crunch (TBL) | 2000 | 1000 | 50 | 20 | 51910 | 31761 | 76.34% | 93.41% | 2 | 2461 - 82.03% | 95,021$ | 3,230,720$ | 3000 | 100 | 1,902,499$ | 1,902,499$ | 2,309,801$ | 0$ | 1,837,425$ | 0 | 0 | 190,042$ | 15 | 16,569$ | 132,552$ |
28 | Texas Stars (DAL) | 2000 | 1000 | 50 | 20 | 53986 | 33251 | 77.12% | 95.00% | 1 | 2492 - 83.08% | 96,123$ | 3,364,320$ | 3000 | 100 | 2,026,500$ | 2,026,500$ | 2,441,068$ | 0$ | 1,968,603$ | 0 | 0 | 96,123$ | 15 | 17,424$ | 139,392$ |
29 | Toronto Marlies (TOR) | 2000 | 1000 | 36 | 15 | 68733 | 34359 | 98.19% | 98.17% | 1 | 2945 - 98.18% | 88,291$ | 3,090,199$ | 3000 | 100 | 2,488,369$ | 2,488,369$ | 2,823,433$ | 0$ | 2,351,057$ | 0 | 0 | 88,291$ | 15 | 20,609$ | 164,872$ |
30 | Tucson Roadrunners (ARZ) | 2000 | 1000 | 50 | 20 | 54254 | 33160 | 77.51% | 94.74% | 1 | 2498 - 83.25% | 96,454$ | 3,375,900$ | 3000 | 100 | 2,561,382$ | 2,553,882$ | 2,891,498$ | 0$ | 2,419,122$ | 0 | 0 | 96,454$ | 15 | 21,113$ | 168,904$ |
31 | Utica Comets (NJD) | 2000 | 1000 | 50 | 20 | 54431 | 33196 | 77.76% | 94.85% | 1 | 2504 - 83.45% | 96,728$ | 3,385,470$ | 3000 | 100 | 2,750,912$ | 2,750,912$ | 2,584,545$ | 0$ | 2,112,169$ | 0 | 0 | 96,728$ | 15 | 22,420$ | 179,360$ |
32 | Wilkes-Barre Scranton Penguins (PIT) | 2000 | 1000 | 50 | 20 | 52755 | 32665 | 75.36% | 93.33% | 1 | 2441 - 81.35% | 94,030$ | 3,291,050$ | 3000 | 100 | 1,860,501$ | 1,860,501$ | 2,299,880$ | 0$ | 1,827,503$ | 0 | 0 | 94,030$ | 15 | 16,279$ | 130,232$ |