| 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 Salaries Cap | 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 | 38246 | 18915 | 95.62% | 94.58% | 16 | 2858 - 95.27% | 104,969$ | 2,099,370$ | 3000 | 100 | 3,120,750$ | 3,120,750$ | 1,705,050$ | 0$ | 1,432,530$ | 0 | 0 | 1,679,496$ | 93 | 19,157$ | 1,647,502$ |
| 2 | Bakersfield Condors (EDM) | 2000 | 1000 | 40 | 20 | 39372 | 18947 | 98.43% | 94.74% | 16 | 2916 - 97.20% | 97,691$ | 1,953,820$ | 3000 | 100 | 2,396,329$ | 2,396,329$ | 1,418,008$ | 0$ | 1,145,559$ | 0 | 0 | 1,563,056$ | 93 | 15,324$ | 1,317,864$ |
| 3 | Belleville Senators (OTT) | 2000 | 1000 | 49 | 20 | 30695 | 18885 | 76.74% | 94.43% | 16 | 2479 - 82.63% | 94,088$ | 1,881,755$ | 3000 | 100 | 3,423,576$ | 3,423,576$ | 1,796,831$ | 0$ | 1,524,294$ | 0 | 0 | 1,505,404$ | 93 | 20,760$ | 1,785,360$ |
| 4 | Bridgeport Islanders (NYI) | 2000 | 1000 | 40 | 22 | 38766 | 14828 | 96.92% | 74.14% | 16 | 2680 - 89.32% | 93,843$ | 1,876,856$ | 3000 | 100 | 2,894,750$ | 2,894,750$ | 1,657,446$ | 0$ | 1,384,951$ | 0 | 0 | 1,501,485$ | 93 | 17,962$ | 1,544,732$ |
| 5 | Calgary Wranglers (CGY) | 2000 | 1000 | 45 | 18 | 40338 | 20193 | 96.04% | 96.16% | 15 | 2882 - 96.08% | 103,747$ | 2,178,684$ | 3000 | 100 | 2,788,391$ | 2,788,391$ | 1,822,022$ | 0$ | 1,549,484$ | 0 | 0 | 1,556,203$ | 93 | 17,399$ | 1,496,314$ |
| 6 | Charlotte Checkers (FLA) | 2000 | 1000 | 50 | 20 | 29455 | 18770 | 73.64% | 93.85% | 16 | 2411 - 80.38% | 92,408$ | 1,848,150$ | 3000 | 100 | 2,363,001$ | 2,363,001$ | 1,529,944$ | 0$ | 1,257,479$ | 0 | 0 | 1,478,520$ | 93 | 15,148$ | 1,302,728$ |
| 7 | Chicago Wolves (CAR) | 2000 | 1000 | 50 | 20 | 29712 | 18712 | 74.28% | 93.56% | 16 | 2421 - 80.71% | 92,992$ | 1,859,840$ | 3000 | 100 | 2,349,466$ | 2,349,466$ | 1,504,421$ | 0$ | 1,231,982$ | 0 | 0 | 1,487,872$ | 93 | 15,077$ | 1,296,622$ |
| 8 | Cleveland Monsters (CBJ) | 2000 | 1000 | 50 | 20 | 30273 | 18788 | 75.68% | 93.94% | 16 | 2453 - 81.77% | 94,471$ | 1,889,410$ | 3000 | 100 | 1,834,334$ | 1,834,334$ | 1,289,280$ | 0$ | 1,016,743$ | 0 | 0 | 1,511,528$ | 93 | 12,351$ | 1,062,186$ |
| 9 | Coachella Valley Firebirds (SEA) | 2000 | 1000 | 50 | 20 | 29246 | 18886 | 73.12% | 94.43% | 16 | 2407 - 80.22% | 92,001$ | 1,840,020$ | 3000 | 100 | 4,586,735$ | 4,586,735$ | 1,588,890$ | 0$ | 1,316,442$ | 0 | 0 | 1,472,016$ | 93 | 26,914$ | 2,314,604$ |
| 10 | Colorado Eagles (COL) | 2000 | 1000 | 55 | 25 | 27596 | 12730 | 68.99% | 63.65% | 16 | 2016 - 67.21% | 91,802$ | 1,836,030$ | 3000 | 100 | 4,441,729$ | 4,441,729$ | 1,337,944$ | 0$ | 1,065,507$ | 0 | 0 | 1,468,824$ | 93 | 26,147$ | 2,248,642$ |
| 11 | Grand Rapids Griffins (DET) | 2000 | 1000 | 45 | 25 | 37530 | 12945 | 93.83% | 64.73% | 16 | 2524 - 84.13% | 100,624$ | 2,012,475$ | 3000 | 100 | 2,021,729$ | 2,021,729$ | 1,374,226$ | 0$ | 1,101,791$ | 0 | 0 | 1,609,980$ | 93 | 13,342$ | 1,147,412$ |
| 12 | Hartford Wolf Pack (NYR) | 2000 | 1000 | 50 | 20 | 29882 | 19281 | 74.71% | 96.41% | 16 | 2458 - 81.94% | 93,986$ | 1,879,720$ | 3000 | 100 | 2,679,041$ | 2,679,041$ | 1,698,689$ | 0$ | 1,426,254$ | 0 | 0 | 1,503,776$ | 93 | 16,820$ | 1,446,520$ |
| 13 | Henderson Silver Knights (VGK) | 2000 | 1000 | 40 | 15 | 38228 | 19719 | 95.57% | 98.60% | 16 | 2897 - 96.58% | 91,245$ | 1,824,905$ | 3000 | 100 | 2,383,008$ | 2,383,008$ | 1,559,452$ | 0$ | 1,286,996$ | 0 | 0 | 1,459,924$ | 93 | 15,254$ | 1,311,844$ |
| 14 | Hershey Bears (WSH) | 2000 | 1000 | 40 | 20 | 38419 | 18885 | 96.05% | 94.43% | 16 | 2865 - 95.51% | 95,723$ | 1,914,460$ | 3000 | 100 | 2,291,111$ | 2,291,111$ | 1,521,104$ | 0$ | 1,248,566$ | 0 | 0 | 1,531,568$ | 93 | 14,768$ | 1,270,048$ |
| 15 | Iowa Wild (MIN) | 2000 | 1000 | 36 | 17 | 39205 | 19519 | 98.01% | 97.60% | 16 | 2936 - 97.87% | 87,160$ | 1,743,203$ | 3000 | 100 | 3,120,000$ | 3,120,000$ | 1,953,907$ | 0$ | 1,681,424$ | 0 | 0 | 1,394,562$ | 93 | 19,153$ | 1,647,158$ |
| 16 | Laval Rocket (MTL) | 2000 | 1000 | 50 | 20 | 30559 | 19549 | 76.40% | 97.75% | 16 | 2505 - 83.51% | 95,947$ | 1,918,930$ | 3000 | 100 | 1,746,200$ | 1,746,200$ | 1,406,616$ | 0$ | 1,134,139$ | 0 | 0 | 1,535,144$ | 93 | 11,885$ | 1,022,110$ |
| 17 | Lehigh Valley Phantoms (PHI) | 2000 | 1000 | 50 | 20 | 29832 | 18630 | 74.58% | 93.15% | 16 | 2423 - 80.77% | 93,210$ | 1,864,200$ | 3000 | 100 | 3,753,278$ | 3,753,278$ | 1,895,248$ | 0$ | 1,622,718$ | 0 | 0 | 1,491,360$ | 93 | 22,504$ | 1,935,344$ |
| 18 | Manitoba Moose (WPG) | 2000 | 1000 | 50 | 25 | 29502 | 12378 | 73.76% | 61.89% | 16 | 2094 - 69.80% | 89,228$ | 1,784,550$ | 3000 | 100 | 1,917,417$ | 1,917,417$ | 1,313,782$ | 0$ | 1,041,245$ | 0 | 0 | 1,427,640$ | 93 | 12,791$ | 1,100,026$ |
| 19 | Milwaukee Admirals (NSH) | 2000 | 1000 | 50 | 20 | 29779 | 18916 | 74.45% | 94.58% | 16 | 2435 - 81.16% | 93,364$ | 1,867,270$ | 3000 | 100 | 2,364,888$ | 2,364,888$ | 1,561,274$ | 0$ | 1,288,839$ | 0 | 0 | 1,493,816$ | 93 | 15,158$ | 1,303,588$ |
| 20 | Ontario Reign (LAK) | 2000 | 1000 | 50 | 20 | 29707 | 18541 | 74.27% | 92.71% | 16 | 2412 - 80.41% | 92,809$ | 1,856,170$ | 3000 | 100 | 1,936,783$ | 1,936,783$ | 1,333,101$ | 0$ | 1,060,659$ | 0 | 0 | 1,484,936$ | 93 | 12,893$ | 1,108,798$ |
| 21 | Providence Bruins (BOS) | 2000 | 1000 | 55 | 25 | 27929 | 13038 | 69.82% | 65.19% | 16 | 2048 - 68.28% | 93,102$ | 1,862,045$ | 3000 | 100 | 2,634,451$ | 2,634,451$ | 1,816,739$ | 0$ | 1,544,238$ | 0 | 0 | 1,489,636$ | 93 | 16,584$ | 1,426,224$ |
| 22 | Rochester Americans (BUF) | 2000 | 1000 | 55 | 25 | 26985 | 12825 | 71.01% | 67.50% | 17 | 2095 - 69.84% | 94,989$ | 1,804,800$ | 3000 | 100 | 2,501,624$ | 2,501,624$ | 1,635,846$ | 0$ | 1,363,308$ | 0 | 0 | 1,614,821$ | 93 | 15,882$ | 1,365,852$ |
| 23 | Rockford IceHogs (CHI) | 2000 | 1000 | 50 | 21 | 27896 | 14933 | 73.41% | 78.59% | 17 | 2254 - 75.14% | 89,915$ | 1,708,393$ | 3000 | 100 | 2,049,249$ | 2,049,249$ | 1,389,264$ | 0$ | 1,116,829$ | 0 | 0 | 1,528,562$ | 93 | 13,488$ | 1,159,968$ |
| 24 | San Diego Gulls (ANA) | 2000 | 1000 | 40 | 19 | 38513 | 19134 | 96.28% | 95.67% | 16 | 2882 - 96.08% | 95,203$ | 1,904,066$ | 3000 | 100 | 2,177,027$ | 2,177,027$ | 1,458,892$ | 0$ | 1,186,457$ | 0 | 0 | 1,523,253$ | 93 | 14,164$ | 1,218,104$ |
| 25 | San Jose Barracuda (SJS) | 2000 | 1000 | 55 | 25 | 27489 | 13103 | 68.72% | 65.52% | 16 | 2030 - 67.65% | 91,974$ | 1,839,470$ | 3000 | 100 | 3,872,062$ | 3,872,062$ | 1,917,105$ | 0$ | 1,644,589$ | 0 | 0 | 1,471,576$ | 93 | 23,133$ | 1,989,438$ |
| 26 | Springfield Thunderbirds (STL) | 2000 | 1000 | 50 | 20 | 31373 | 19187 | 78.43% | 95.94% | 16 | 2528 - 84.27% | 97,620$ | 1,952,390$ | 3000 | 100 | 2,076,866$ | 2,076,866$ | 1,221,321$ | 0$ | 948,802$ | 0 | 0 | 1,561,912$ | 93 | 13,634$ | 1,172,524$ |
| 27 | Syracuse Crunch (TBL) | 2000 | 1000 | 50 | 20 | 29118 | 18889 | 72.80% | 94.45% | 16 | 2400 - 80.01% | 91,684$ | 1,833,680$ | 3000 | 100 | 2,110,333$ | 2,110,333$ | 1,390,691$ | 0$ | 1,118,256$ | 0 | 0 | 1,466,944$ | 93 | 13,811$ | 1,187,746$ |
| 28 | Texas Stars (DAL) | 2000 | 1000 | 50 | 20 | 30083 | 18644 | 75.21% | 93.22% | 16 | 2436 - 81.21% | 93,852$ | 1,877,030$ | 3000 | 100 | 1,942,467$ | 1,942,467$ | 1,363,596$ | 0$ | 1,091,064$ | 0 | 0 | 1,501,624$ | 93 | 12,923$ | 1,111,378$ |
| 29 | Toronto Marlies (TOR) | 2000 | 1000 | 32 | 18 | 39275 | 19043 | 98.19% | 95.22% | 16 | 2916 - 97.20% | 79,979$ | 1,599,574$ | 3000 | 100 | 2,227,752$ | 2,227,752$ | 1,476,437$ | 0$ | 1,203,912$ | 0 | 0 | 1,279,659$ | 93 | 14,433$ | 1,241,238$ |
| 30 | Tucson Roadrunners (UTA) | 2000 | 1000 | 50 | 20 | 29816 | 18596 | 74.54% | 92.98% | 16 | 2421 - 80.69% | 93,136$ | 1,862,720$ | 3000 | 100 | 2,376,600$ | 2,376,600$ | 1,605,892$ | 0$ | 1,333,457$ | 0 | 0 | 1,490,176$ | 93 | 15,220$ | 1,308,920$ |
| 31 | Utica Comets (NJD) | 2000 | 1000 | 50 | 20 | 29916 | 18939 | 74.79% | 94.70% | 16 | 2443 - 81.43% | 93,729$ | 1,874,580$ | 3000 | 100 | 2,126,001$ | 2,126,001$ | 1,442,499$ | 0$ | 1,170,043$ | 0 | 0 | 1,499,664$ | 93 | 13,894$ | 1,194,884$ |
| 32 | Wilkes-Barre Scranton Penguins (PIT) | 2000 | 1000 | 50 | 20 | 29951 | 19153 | 74.88% | 95.77% | 16 | 2455 - 81.84% | 94,031$ | 1,880,610$ | 3000 | 100 | 2,539,349$ | 2,539,349$ | 1,330,463$ | 0$ | 1,057,932$ | 0 | 0 | 1,504,488$ | 93 | 16,081$ | 1,382,966$ |